USP_SALESORDER_DISTRIBUTEFEESANDDISCOUNTS

CREATE procedure dbo.USP_SALESORDER_DISTRIBUTEFEESANDDISCOUNTS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    if isnull((select STATUSCODE from dbo.SALESORDER where ID = @ID), 0) <> 1
    begin
        raiserror('This order is not yet complete. Please refresh the page and try again.', 13, 1);
        return 1;
    end

    exec dbo.USP_SALESORDER_DISTRIBUTEAPPLIEDDISCOUNTS @ID, @CHANGEAGENTID;
    exec dbo.USP_SALESORDER_DISTRIBUTEITEMFEES @ID, @CHANGEAGENTID;

    return 0;
end