Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SP_TRANSACTION NOTIFICATION NOT FIRING

Hi All,

I've written a SP TRANSACTION NOTOFICATION.

ON pressing F5 SQL server 2008 is giving COMMAND(S) COMPLETELY SUCCESSFULLY.

BUT IN FRONT END NO RESULT.

I TRIED SQL PROFILER BUT THAT PROCEDURE IS NOT VISIBLE THERE.

Any help about calling it would be greatly appreciated.

Thanks

Malhaar

Former Member
Former Member replied

Hi Malhaar....

Forget Your code and just Run this code as it is.......

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER proc [dbo].[SBO_SP_TransactionNotification]

@object_type nvarchar(20), 				-- SBO Object Type
@transaction_type nchar(1),			-- [A]dd, <u>pdate, [D]elete, [C]ancel, C[L]ose
@num_of_cols_in_key int,
@list_of_key_cols_tab_del nvarchar(255),
@list_of_cols_val_tab_del nvarchar(255)

AS

begin

-- Return values
declare @error  int				-- Result (0 for no error)
declare @error_message nvarchar (200) 		-- Error string to be displayed
select @error = 0
select @error_message = N'Ok'

--------------------------------------------------------------------------------------------------------------------------------

--	ADD	YOUR	CODE	HERE
IF (@object_type = '2') and (@transaction_type IN ('A', 'U'))
BEGIN
IF exists (select T0.CardCode FROM OCRD T0 Where (T0.GroupNum != 4 And T0.GroupCode != 116) and T0.UserSign = 16 and T0.CardCode =@list_of_cols_val_tab_del)
Begin
Select @error = -1,
@error_message ='You are not authorized to change payment terms and customer group'
End
END



--------------------------------------------------------------------------------------------------------------------------------

-- Select the return values
select @error, @error_message

end

Regards,

Rahul

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question