Skip to Content
0
Feb 27, 2019 at 12:56 PM

Transaction Notification project at Purchase Blanket Agreement

114 Views

Hi the below transaction notification is not working, if the project is missing at the level of the purchase blanket agreement then it must not allow to add.

Sergei Travkin Former Member your help is appreciated

IF (:object_type = '001250000025' and (:transaction_type = 'A' OR :transaction_type = 'U'))
THEN
(Select COUNT(*) into cnt From "OOAT" a Where a."DocEntry" = :list_of_cols_val_tab_del 
AND a."Project" IS NULL);
IF :cnt > 0 THEN
   error := 2301;
   error_message := 'Project is missing ...';
END IF;
END IF;