TR_RECEIVABLECREDIT_INSERT_UPDATE (Trigger)

        
          CREATE trigger TR_RECEIVABLECREDIT_INSERT_UPDATE on dbo.RECEIVABLECREDIT after insert,update not for replication
          as begin
              begin try                
                if exists(
                    select I.ID
                    from INSERTED I
                    where not STUDENTPROGRESSIONID is null and dbo.UFN_STUDENTCHARGE_VALIDSTUDENTPROGRESSION(ID, STUDENTPROGRESSIONID) = 0                        
                  )
                      begin
                        raiserror('ERR_RECEIVABLECREDIT_VALIDSTUDENTPROGRESSION', 13, 1);
                      end
        
        if exists(
                    select I.ID
                    from INSERTED I                                                         
                    where not EDUCATIONALHISTORYID is null and dbo.UFN_STUDENTCHARGE_VALIDENROLLMENT(ID, EDUCATIONALHISTORYID) = 0                        
                  )
                      begin
                        raiserror('ERR_RECEIVABLECREDIT_VALIDENROLLMENT', 13, 1);
                      end
        
              end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch
          end