Saturday 17 September 2016

How to Create and Use Messages in Oracle Apps |Oracle E-Business Suite

Messages in Oracle Apps:
Oracle application uses a message dictionary to display the messages in Forms, Reports, PLSQL code, OAF, and ADF. 

Oracle has given a mechanism to define your own messages, it provides you the flexibility to define and store your messages in a message dictionary and you can display them as error/warning/notes.
You can use your custom messages in Forms, Reports, PLSQL Code, and OAF etc. The main advantage of messages is that you can change your messages whenever you want without changing the code.

How to create messages:
Login to oracle applications and follow the below steps.
Navigation:
                Application developer > Application Messages


Now fill in all the mandatory details and save the record as shown below

Note: You can also use tokens in your message to change the text dynamically; the token name should be in cap’s as shown in the above image.
 I have used “USER” as a token.

How to use messages?
Oracle has provided predefine API “FND_MESSAGE” to retrieve and set the messages.
Below are the procedure names and example

FND_MESSAGE.SET_NAME (‘Application Short Name’, ‘Message name’);
FND_MESSAGE.SET_TOKEN (‘Token Name’, VALUE);
FND_MESSAGE.GET



I have registered the above code as a concurrent program, Check the below output.


Now let us check how to use messages in FORMS, and OAF


No comments:

Post a Comment