USP_PLEDGE_VALIDATE_2

CREATE procedure dbo.USP_PLEDGE_VALIDATE_2 (
  @PLEDGEID uniqueidentifier
  ,@ISMEMBERSHIPPLEDGE bit
  )
as
begin
  set @ISMEMBERSHIPPLEDGE = coalesce(@ISMEMBERSHIPPLEDGE, 0);

  if @ISMEMBERSHIPPLEDGE = 1
  begin
    if dbo.UFN_MEMBERSHIPRG_INSTALLMENTSPLITSBALANCE(@PLEDGEID) = 0
      raiserror (
          'BBERR_INSTALLMENTSPLITS_MEMBERSHIPPLEDGEBALANCE'
          ,13
          ,10
          );
  end
  else
    if dbo.UFN_PLEDGE_INSTALLMENTSPLITSBALANCE(@PLEDGEID) = 0
      raiserror (
          'INSTALLMENTSPLITSBALANCE'
          ,13
          ,10
          );

  if dbo.UFN_PLEDGE_INSTALLMENTSPLITSSUMTOINSTALLMENTS(@PLEDGEID) = 0
    raiserror (
        'INSTALLMENTSPLITSSUMTOINSTALLMENTS'
        ,13
        ,10
        );

  if dbo.UFN_PLEDGEPAYMENT_INSTALLMENTSBALANCE(@PLEDGEID) = 0
    raiserror (
        'PLEDGEPAYMENT_INSTALLMENTSBALANCE'
        ,13
        ,10
        );

  if dbo.UFN_PLEDGEPAYMENT_DESIGNATIONSBALANCE(@PLEDGEID) = 0
    raiserror (
        'PLEDGEPAYMENT_DESIGNATIONSBALANCE'
        ,13
        ,10
        );

  if dbo.UFN_PLEDGE_PAYMENTSVALID(@PLEDGEID) = 0
    raiserror (
        'PLEDGEPAYMENT_DESIGNATIONSBALANCE'
        ,13
        ,10
        );
end