OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » User-Defined Exception in arp_auto_rule .create

Home » Applications » Oracle Fusion Apps & E-Business Suite » User-Defined Exception in arp_auto_rule .create_distributions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User-Defined Exception in arp_auto_rule .create_distributions [message #409583]

Tue, 23 June 2009 03:44

rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India

Senior Member

I am using the following code snippet in a report(without anonymous block ofcourse)

Code: [Select all] [Show/ hide]

declare
lines number;
 begin
dbms_output.put_line('lines value before: ' || lines);  
lines := arp_auto_rule.create_distributions( :p_commit_at_end     																					 ,:p_debug_flag     																					 ,NULL      																					 ,'N'  																					 ,'N'																			 );
dbms_output.put_line('lines value after: ' || lines);
 exception
  when others then
       dbms_output.put_line('Error is: ' || SQLERRM);
end;

Here 'lines' is defined as a number as the function return a number.
Now if i run this in a anonymous block with the first two values as 'N' it runs fine and gives the following output

Code: [Select all] [Show/ hide]

lines value before: 
lines value after: 0

Now if i used the same API call in report i get the following error

Code: [Select all] [Show/ hide]

lines value before: 
Error is: User-Defined Exception

Report message to a moderator

Re: User-Defined Exception in arp_auto_rule .create_distributions [message #409588 is a reply to message #409583]

Tue, 23 June 2009 03:57

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Next time you post code can you format it properly so it's not five screens wide please.

arp_auto_rule.create_distributions is rasing an exception.
Without knowing what code it contains I really can't say any more except you should check all the parameter values being passed by the report to see if they are what you think they are.

Report message to a moderator

Re: User-Defined Exception in arp_auto_rule .create_distributions [message #409600 is a reply to message #409583]

Tue, 23 June 2009 04:45

rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India

Senior Member

^^ sorry for the formatting. next time i will ensure it is proper. I am not able to edit the post else would have changed it.

As i have told, i am able to run using the same set of parameters in toad but not when the concurrent program is run which is based on a report.

Report message to a moderator

Re: User-Defined Exception in arp_auto_rule .create_distributions [message #410391 is a reply to message #409600]

Fri, 26 June 2009 14:58

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Is your concurrent program having an executable as "Stored Procedure"?
What is the signature of the procedure?
What are the values you are passing as the parameters to the concurrent program?

By
Vamsi

Report message to a moderator

Previous Topic:	how to join ap_invoices_all,ap_invoice_payments _all,ap_checks_all,jai_ap_tds_payments_all
Next Topic:	per_accrual_calc_functions.get_net_accrual error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 04:15:35 CDT 2025