Friday, July 3, 2009


Hi All
QP_CUSTOM is a standard package given by oracle to customize the price derivation based on our custom logic.
Recently i customisee this package to get freight charge based on the wegith of the line items.
This was not so tough to achieve but the user want to show some messages when ever any exception occurs....But the qp_custom is supposed to return a number..
This api is called from dynanic formual on some event like saving entering ..
The solution we thought of is form personalization by returning some constant number an throw exception when we encouter that values...But still i didn't work...the possible ways form personalization works are far less than the ways it didnt work...

after sorm R&D on google and metalink i found that there is api oe_msg_pub to put error messages...
But unfortunately i didnt find right code to use it properly after some hit and try
i figured out that
oe_msg_pub.add_text will add a message
oe_msg_pub.add will put the message on the stack..This will display messages in the
message window in order entry screen
i thought it would be better if we display message in a modal window
so i gave a blind try like define a message in application developer message window

fnd_message.set_name ('XXCUST', 'XX_ERROR_MSG');
fnd_message.set_token ('MESSAGE', 'No Shipping Charges defined');
"Message is a token in the message"
This really works...every time you change qp_custom package close the order entry form ,reload it and try...


Anonymous said...

u never reply to anybody's post.. y r u creating this blog.. plz close ur blog ASAP...

ur blog is totally waste.. plz close ur blog and save the Apps people..

Thanks in anticipation


Anonymous said...

Dear Murthy ganjam,

Really sorry for the previous msg.It hurts me a lot.My friend has used my name for joke purporse.Really U r doing a awesome job.Helping so many apps professionals.Keep up the good work. Thanks in anticipation


Anonymous said...

This post is really good man. Even I thought of Customize of Personalise the Form, but found good article which meets my requirement exactly.

Venkat K

krishna reddy said...

My requirement is when we click on book order button on sales order form then my custom package will validate all the values items, quantities on the order. If validation fails then it should display custom message or popup and need to prevent booking.
I have used fnd_message.set_name
fnd_message.set_token but no luck

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

Amit said...

Nice Blog

Install Oracle Appsr12 Dump For Better Practice