Skip to main content

Hi All,

I received what I thought was a very straightforward request for a custom events: Our customer wants to prevent Manual Customer Invoices from reaching PostedAuth status until the prepostings tab is filled out. 

This invoice should not be able to reach PostedAuth status

 

So, I created a custom event using the following info:

 

Then I created an event action with these conditions:

 

And it’s running this code:

DECLARE

var_company varchar2(25) := '&OLD:CODE_B';
var_fsg varchar2(50) := '&OLD:CODE_C';
var_sbu varchar2(50) := '&OLD:CODE_D';
var_worksite varchar2(50) := '&OLD:CODE_E';
var_project varchar2(50) := '&OLD:CODE_F';
var_rel_party varchar2(50) := '&OLD:CODE_G';
var_activity_seq varchar2(50) := '&OLD:PROJECT_ACTIVITY_ID';

BEGIN

IF LEAST(var_company, var_fsg, var_sbu, var_worksite, var_project, var_rel_party, var_activity_seq) is null THEN
Error_SYS.Record_General('ManCustInvoice', 'Please ensure that prepostings are properly filled out.');
ELSE NULL;
END IF;

END; 

 

But, when I test the event, I get this error:

 

 

When I look at FND_EVENT_ACTION_API line 2193, I’m not sure where to start troubleshooting the event:

 

However, when I run the debug console it appears that there’s some conflict between my event and MAN_CUST_INVOICE_API.CREATE_VOUCHER_AFTER_INV__ and I’m wondering if that’s causing my issue:

 

So, I guess I’m wondering if it’s even possible to write this kind of event on INVOICE_TAB, and if so whether anyone has any ideas for what I can do to get my event working. 

Be the first to reply!

Reply