TR_CREDITMEMO_DELETE

CREATE trigger TR_CREDITMEMO_DELETE on dbo.CREDITMEMO for delete not for replication
as begin
    set nocount on;
    begin try
        if exists(
            select D.ID
            from Deleted D
            inner join dbo.FINANCIALTRANSACTION F on F.ID = D.ID
            where F.POSTSTATUSCODE = 2)
        begin
            raiserror('The credit memo cannot be deleted because it has been posted', 13,1)
        end
        if exists(
            select D.ID
            from Deleted D
            inner join dbo.DISBURSEMENTPROCESS DP on DP.ID = D.DISBURSEMENTPROCESSID)
        begin
            raiserror('The credit memo cannot be deleted because it is being processed.', 13,1)
        end
    if exists(
      select D.ID
      from Deleted D
      inner join dbo.FINANCIALTRANSACTION F on F.ID = D.ID
      where D.ZEROBALANCE = 1)
    begin
      raiserror('The credit memo cannot be deleted because it has been paid.', 13,1)
    end
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
    end catch
end