Hello All,

I need to have a setting to check minimum value of gross amount is always greater then 200 EUR / USD on each purchase line for a particular supplier

I have made below event for this case, but now the issue is it triggers error pop-up for all the cases without checking if amount is >200 or <200

Can anyone please check and suggest what is wrong -

declare
PRAGMA AUTONOMOUS_TRANSACTION; 
dummy_ number;
str varchar2(100);
str1 varchar2(100);

cursor c1 is
select Purchase_Order_Line_Part_API.Get_Total_In_Order_Curr('&NEW:Order_No','&NEW:Line_No','&NEW:Release_No') from PURCHASE_ORDER_LINE_PART_CFV
where VENDOR_NO= '******';

begin

OPEN c1;   
       FETCH c1  INTO str1;
CLOSE c1;

if (str1 <= 200) then
  error_sys.appl_general ('PURCHASE_ORDER_LINE_PART_CFV','EVENT: The gross curr amount cannot be less than or equal to 200');

end if;

end;

eNote - Noticed thhat the event does not fetch the runtime gross amt values, inspite it always fetches 0]

Appreciate your response !!