• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4975
  • Last Modified:

Using FND_MESSAGE database package

Hi.  I have an exception handler in a database trigger that is to display a message in the application when a certain condition is met.  I'd like to use the fnd_message package to do this, but I am having some difficulty.  I'm looking for an examples for use of the package.  I'd appreciate it if there is anyone out there that can help.  Thanks!
0
jschwartzy
Asked:
jschwartzy
1 Solution
 
adrian_angCommented:
Using something like this :
             fnd_message.set_string ('Je fais ici mes dérivations de données.');
             fnd_message.show;
   
look at :http://www.iherve.com/oracle/didYouKnow0206.htm
Hope this helps!
0
 
jschwartzyAuthor Commented:
Thank you, but that would be an example of using fnd_message in PL/SQL in a form.  I am trying to use the database package that does not contain some of the procs and funcs in the package your example uses.
0
 
jschwartzyAuthor Commented:
Also, I am attempting to use the message dictionary to accomplish this.  I've setup the message in the messages form.
0
 
slightwv (䄆 Netminder) Commented:
I'm not familiar with this package but see if this link will help.  It looks very similar to what you describe:

http://www.sap-img.com/oracle-database/changing-default-gl-account-type.htm
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now