Bloque facturas proveedores UUID

[former_member817449]

Hello, good afternoon, I request your collaboration to know why my validation of the UUID that is already in sap hana is not working for me, I am doing it in Transaction Notification,
my code is as follows:

IF :object_type = '18' AND (:transaction_type='A' or :transaction_type='U')
 then

select "EDocNum" from OPCH where "EDocNum" = "EDocNum" AND "DocEntry" =:list_of_cols_val_tab_del;
IF :UUID2 = (SELECT COUNT("EDocNum") FROM OPCH WHERE "EDocNum" = :UUID2 HAVING COUNT("EDocNum")> '1')
then
 error := 100;
 error_message := 'Existe UUID de Proveedor duplicado';
 
end if;
end if;

I get an error (-1) Stored procedure SBO_SP_TransactionNotification has to return a value