关于FND_MESSAGE的详细用法可以参见 http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T462354.htm
这里只列出几个常用的Example,方便查用

FND_MESSAGE.SET_NAME

Retrieves your message from Message Dictionary and sets it on the message stack. You call FND_MESSAGE.SET_NAME once for each message you use in your client-side PL/SQL procedure. You must call FND_MESSAGE.SET_NAME before you call FND_MESSAGE.SET_TOKEN.
Example 1

/* Display a warning, asking OK/Cancel question */
FND_MESSAGE.SET_NAME (\'FND\', \'WANT_TO_CONTINUE\');
FND_MESSAGE.SET_TOKEN (\'PROCEDURE\', \'Compiling this flexfield\');
if (FND_MESSAGE.WARN) then
  /* User selected OK, so add appropriate logic ... */ 

FND_MESSAGE.WARN

Example:

/* Display a warning, asking OK/Cancel question */
FND_MESSAGE.SET_NAME (\'FND\', \'WANT TO CONTINUE\');
FND_MESSAGE.SET_TOKEN (\'PROCEDURE\', \'Compiling this flexfield\');
IF (FND_MESSAGE.WARN) THEN
  /* User selected OK, so add appropriate logic ... */
ELSE
  /* User selected Cancel, so add appropriate logic ... */
END IF;

FND_MESSAGE.ERROR

Example:

/* Display an error message with a translated token */
FND_MESSAGE.SET_NAME (\'FND\', \'FLEX_COMPILE_ERROR\');
FND_MESSAGE.SET_TOKEN (\'PROCEDURE\', \'TRANS_PROC_NAME\', TRUE);
FND_MESSAGE.ERROR;
  /* Then either raise FORM_TRIGGER_FAILURE, or exit  
     routine*/   

FND_MESSAGE.SHOW

Example

/* Show an informational message */
FND_MESSAGE.SET_NAME (\'FND\', \'COMPILE_CANCELLED\');
FND_MESSAGE.SHOW;   

FND_MESSAGE.QUESTION

Example 1

/* Display a message with two buttons in a modal window */
FND_MESSAGE.SET_NAME(\'INV\', \'MY_PRINT_MESSAGE\');
FND_MESSAGE.SET_TOKEN(\'PRINTER\', \'hqunx138\');
FND_MESSAGE.QUESTION(\'PRINT-BUTTON\');
  /* If \'PRINT-BUTTON\' is defined with the value “Print",
     the user sees two buttons: “Print", and “Cancel".  */  
       
Example 2

/* Display a message with three buttons in a modal window.
   Use the Caution icon for the window. */

FND_MESSAGE.SET_NAME(\'FND\', \'DELETE_EVERYTHING\');
FND_MESSAGE.QUESTION(\'DELETE\', NULL, \'CANCEL\', 1, 3, \'caution\');

Example 3

/* Display a message with two buttons in a modal window.
   "Yes" and "No" */

FND_MESSAGE.SET_NAME(\'FND\', \'REALLY\');
FND_MESSAGE.QUESTION(\'YES\', \'NO\', NULL);

FND_MESSAGE.DEBUG

 /* as the last part of an item handler */
       ELSE 
          fnd_message.debug(\'Invalid event passed to
              ORDER.ITEM_NAME: \' || EVENT); 
       END IF;