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;
[Note - Noticed thhat the event does not fetch the runtime gross amt values, inspite it always fetches 0]
Appreciate your response !!