Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Oracle Apps Message Dictionary

By Exforsys | on June 19, 2005 |
Oracle Apps

Oracle Apps 11i Free Training : Message Dictionary : This document discuss about message dictionary in oracle applications. It talks about the standards to be followed while defining the messages in oracle applications. It also discusses the usage of messages in the forms and concurrent programs.

 

Overview of Message Dictionary

Message Dictionary lets you catalog messages for display from your application without hard coding them into your forms and programs.

Using Message Dictionary, you can:

  • Define standard messages you can use in all your applications
  • Provide a consistent look and feel for messages within and across all your applications
  • Define flexible messages that can include context–sensitive variable text
  • Change or translate the text of your messages without regenerating or recompiling your application code.

Define Messages

Following things should be complete before defining the messages.

1. Register your application. Standard applications come registered with oracle applications and hence you can skip this step if you are defining messages for any standard application.

2. Create a mesg directory under your application’s base directory (e.g $AP_TOP if application is oracle payables) where oracle application object library can store your message files.

Navigate to below mentioned path to define your messages.

Navigation – Application Developer->Application->Messages

Figure 1. Define Messages Navigation

Click on messages and following screen will appear.

Figure 2. Define Messages

Following fields are required while defining messages.

Name – Any meaningful name made of letters, numbers, hypens and underscores upto 30 characters can be used. This is used while invoking message dictionary through forms or concurrent programs.

Language-Language code for the language in which you want to get your message displayed. The common value is US.

Application – Name of the application for which you want to define the message.

Current Message Text – The text of the message which you to be displayed when your message is used in forms or concurrent programs.

Following fields are optional while defining messages.




Number – Enter any appropriate number for your message. If you define a non-zero message number for your message, Message Dictionary automatically prepends your message with the prefix APP:– (or its translated equivalent). Message Dictionary treats 0 and null as the same (and does not display the APP:– or the message number).

Figure 2.1 Define Messages

Type– Use the message type to classify your messages. The message type does not affect how your messages can be called in your code.

In Oracle Applications, the message type is used to help translators translate messages within length expansion constraints that vary by message type. For certain message types, this form enforces message byte length limits smaller than 1800. The message length limits (in bytes) are 60 for Menu Entry, 250 for Hint, and 80 for Title (note that these limits are for translated messages, so messages in English should be 30% shorter if they will be translated).

Maximum Length – In Oracle Applications, the maximum length (in bytes) is used to help translators translate messages within length expansion constraints imposed by the form or program that uses the message. Specifying a maximum length is particularly important where the expansion constraint is tighter than would otherwise be expected for a particular type of message. If your message is in English, the maximum length you specify should be at least 30% longer than your actual English message to allow for expansion during translation.

Figure 2.2 Define Messages

Description – You should enter information in this field that would help explain the context of this message to translators. This field is required if the message is of type Token or Other.

After defining your message you need to run “Generate Messages” program to build your message file. Your new messages take effect as soon as your concurrent request finishes successfully and you have placed the new file in the appropriate directories.

Navigation – Application Developer->Other->Requests->Run

Figure 3 Running Generate messages Navigation

Figure 4 Running Generate messages parameters

Required Parameters to Generate Messages Program

Language – Enter the language in which you want the messages to be generated. The normal value used is US.

Application – Enter the application name for which you have defined the message.



Mode – Following four values are possible for this parameter

a. DB_TO_RUNTIME – This will create a msg file under the application top directory.
b. DB_TO_SCRIPT – This will create a script(.msg file) that can be used to load messages to other database. This would be normally used in case of upgradation only.
c. SCRIPT_TO_DB This will take a script(.msg file) and load the messages in it to the database. This would be normally used in case of upgradation only.
d. SCRIPT_TO_RUNTIME – This will take script(.msg file) and load the messages in to the database and also create the msg file under application top.

Optional Parameters of Generate Messages Program

File Application Shortname (or Local) – Here we should enter the application short name of the application for which we want to generate the msg file. Generally this field is left blank and system automatically generates the file name.

Filename – Here we should enter the name of msg file to be generated. Generally this field is left blank and system automatically generates the file name.

Application Message Standards

Oracle Applications use messages to communicate with users. Typical messages include warnings and error messages, brief instructions, and informative messages that advise your user about the progress of concurrent requests, work done, and anything else of interest or helpful to users.

Forms–based applications display messages on the user’s screen; applications also print messages to output and log files. Messages are part of the product, and should be treated with the same amount of care and attention to the user interface as a form.

These message standards help you write messages that are brief, clear, and informative. When you follow these standards and use Message Dictionary, your application provides messages that are easy to understand, document, edit, and translate into other languages, resulting in an application that is easy to support and enhance.

Message Naming Standards

The following suggested standards provide a consistent naming convention for message names.

Message names are hard coded into forms and programs and should never change.

Use descriptive words and make your message names meaningful to other developers. Your name should clearly summarize the content or purpose of the message. • Message names can contain no more than 30 characters. • Make message names all uppercase. Although message names are case insensitive, this provides consistency so that messages can be searched for easily.

Do not use spaces in message names; use underscore characters instead to separate words.

Message names should not contain message numbers (or prefixes), because message numbers may change over time.

Include your two–to–three–character application short name or abbreviation as the first word in each message name (optional).

Message Numbering Standards

The following suggested standards provide a consistent convention for message numbers

  • Use a number for all errors and warnings, but not hints, notes or questions.
  • Do not put the message prefix or a message number in your message text.
  • All errors and warnings now have message numbers to help developers trace a message if the problem comes from an installation running in a language other than English.
  • Oracle recommends that you number messages using 400000 (400,000) and up (the largest possible message number is about 2 billion).

Message Description Standards

The following suggested standards provide a consistent convention for message descriptions.

  • Description should include where and how the message is used (button label, form message, boilerplate, etc.). If it is a text fragment used to build another message (as a token value), include the text defined for the target message and the target message name so the translator can see the expected context of the fragment.
  • Include what text is expected to replace the token.If your message contains a nonobvious variable token name, use your notes field to tell translators what your token represents.

Message Content Standards

Messages should never exceed about 1260 characters in English. This allows space for the messages to be translated to ”longer” languages such as German.

Message Token Standards

  • Always make tokens in your message uppercase so they are easy to identify in a messages manual or in a message file being translated.
  • Avoid using tokens to substitute for words or phrases in a sentence.
  • These are nearly impossible to translate, because different token values
  • may require different translations for the surrounding text.
  • Avoid hard coding text into your code
  • Use descriptive variable token name

Calling messages

Following standard procedure can be called to show predefined oracle applications message through forms or concurrent programs.

  1. FND_MESSAGE.CLEAR – Clears the message stack of all the messages.
  2. FND_MESSAGE.DEBUG – Immediately displays the string passed to it as input parameter.
  3. FND_MESSAGE.ERASE – Clears the oracle Forms status line.
  4. FND_MESSAGE.ERROR – Displays an error message in an Oracle Forms modal window or a concurrent program log file. (Example: “Invalid value entered.”).
    It takes its message from the stack, displays the message, and then clears all the messages from the message stack.
  5. FND_MESSAGE.GET – Retrieves a translated and token–substituted message from the message stack and then clears that message from the message stack. This could be used for getting a translated message for a forms built–in or other function. Assumes you have already called FND_MESSAGE.SET_NAME and, if necessary, FND_MESSAGE.SET_TOKEN. It returns up to 2000 bytes of message.
  6. FND_MESSAGE.HINT – Displays a message in the Oracle Forms status line. It takes its message from the stack, displays the message, and then clears that message from the message stack. The user may still need to acknowledge the message if another message immediately comes onto the message line.
  7. FND_MESSAGE.QUESTION – Displays a message and up to three buttons in an Oracle Forms modal window. (Example: “Please choose one of the following actions: ”) It takes its message from the stack, and clears that message. After the user selects a button, It returns the number of the button selected.
    For each button, you must define or use an existing message in Message Dictionary (under the Oracle Application Object Library application) that contains the text of the button. This routine looks for your button name message in the Oracle Application Object Library messages, so when you define your message, you must associate it with Oracle Application Object Library (the “FND” application) instead of your application.
  8. FND_MESSAGE.RETRIEVE – Retrieves a message from the database server, translates and substitutes tokens, and sets the message on the message stack.
  9. FND_MESSAGE.SET_NAME – Retrieves your message from Message Dictionary and sets it on the message stack. You call it once for each message you use in your client–side PL/SQL procedure. You must call this procedure before you call FND_MESSAGE.SET_TOKEN.
  10. FND_MESSAGE.SET_STRING – Takes an input string and sets it directly on the message stack. The string does not need to be defined in the Messages window. These strings may be hard coded into the form and are not translated like messages defined in Message Dictionary.
  11. FND_MESSAGE.SET_TOKEN – Substitutes a message token with a value you specify. You call FND_MESSAGE.SET_TOKEN once for each token/value pair in a message. The optional translate parameter can be set to TRUE to indicate that the value should be translated before substitution. (The value should be translated if it is, itself, a Message Dictionary message name.)
  12. FND_MESSAGE.SHOW – Displays an informational message in an Oracle Forms modal window or a concurrent program log file. (Example: “To complete this function, please enter the following… ”). It takes its message from the stack, displays the message, and then clears only that message from the message stack.
  13. FND_MESSAGE.WARN – Displays a warning message in an Oracle Forms modal window and allows the user to either accept or cancel the current operation. (Example: “Do you wish to proceed with the current operation?”) FND_MESSAGE.WARN returns TRUE if the user accepts the message (that is, clicks OK), or FALSE if the user cancels. It takes its message from the stack, displays the message, and clears that message from the message stack.

Most frequently used procedures are FND_MESSAGE.SET_NAME and FND_MESSAGE.SET_TOKEN

Example

/*Here FND_MESSAGE.SET_NAME is used to retrieve the message and put it on the message stack. Message name is ‘WANT TO CONTINUE’.*/

FND_MESSAGE.SET_NAME (’FND’, ‘WANT TO CONTINUE);

/*Next FND_MESSAGE.SET_TOKEN is used to replace the token ‘PROCEDURE’ with text ‘Compiling this flexfield’.

FND_MESSAGE.SET_TOKEN (’PROCEDURE’, ’Compiling this

flexfield’);

IF FND_MESSAGE.WARN THEN
/* User want to continue */

ELSE
/* User want to cancel*/

END;

Frequently asked Questions

1. Which program is required to be executed after defining messages in the oracle applications?
2. What is token in the message?
3. Which procedure should we use to display an information message through a form?
4. Which procedure can be used to display the button along with messages?
5. What are the two prerequisites before defining messages for any application?
6. Why do we have oracle applications message standards?
7. What is the significance of DB_TO_RUNTIME value of the mode parameter while running “Generate Messages” program?
8. Why do we use FND_MESSAGE.SET_NAME procedure?
9. Which application should be used while defining message for Buttons?
10. Can we use messages in the report triggers?









« « Formatting Your Resume
Visual Studio Adding Controls to Windows Form » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 0 Followers
  • Popular
  • Recent
  • Oracle Apps 11i : Asset Management – Asset Adjustments

    October 12, 2005 - 0 Comment
  • Single Node and Multi Node Installation Part 1

    May 28, 2005 - 0 Comment
  • Creating New Forms in Oracle Apps 11i

    July 17, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Mass Transfers

    October 12, 2005 - 0 Comment
  • Single Node and Multi Node Installation Part 2

    May 28, 2005 - 0 Comment
  • Creation of Master Detail Block in Oracle Apps 11i

    July 24, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Depreciation

    October 13, 2005 - 0 Comment
  • Oracle Apps Application Framework

    May 31, 2005 - 0 Comment
  • Registering New Forms in Oracle Apps 11i

    July 24, 2005 - 0 Comment
  • ERP Overview

    May 3, 2005 - 0 Comment
  • Oracle Reports 6i

    December 13, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Journal Entries

    October 16, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Retirements

    October 16, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Depreciation

    October 13, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Mass Transfers

    October 12, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Asset Adjustments

    October 12, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Mass Additions

    October 9, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Manual and Quick Additions

    October 9, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Asset Books Regions

    October 9, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Asset Book Positioning

    October 9, 2005 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Oracle Reports 6i
  • Oracle Apps 11i : Asset Management – Journal Entries
  • Oracle Apps 11i : Asset Management – Retirements
  • Oracle Apps 11i : Asset Management – Depreciation
  • Oracle Apps 11i : Asset Management – Mass Transfers

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2023. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT