hii all i am facing problem in SP_Transaction Notification

hii all

Hi All,

i used some SP_Transaction Notification to check whether the Road permit(UDF) is Filled in sales order , in the beginning its worked fine without any problem when i was using sap 2007 but after upgrading my system from 2007 to 8.8 . its not responding not giving any error message.. i dint made any changes.. is any one faced same problem in real time?

Coding sample

-

condition for Road permit detail----

--

if @object_type = '23' and @transaction_type in ( 'A','U')

begin

-- in variable @list_of_cols_val_tab_del is cardcode of BP

if exists (SELECT *

FROM OQUT

Where DocNum = @list_of_cols_val_tab_del

And U_RdPr is NULL )

begin

select @error =14

select @error_message = 'Please Enter the Road permit Detail '

end

end

Regard

SAHIL KUMAR GAUTAM