Oracle Apps KFF  and   DFF

FND_KEY_FLEX.DEFINE(BLOCK => 'TI_PRICING_AMENDMENT_HISTORY',
                                        FIELD => 'ITEM_CATG',                   
                APPL_SHORT_NAME => 'INV',
                                       CODE => 'MCAT',
                                             ID => 'CATEGORY_ID',
                                         NUM => '101',
                          DISPLAYABLE => 'ALL',
                                    VRULE => '\\nSUMMARY_FLAG\\nI\\nAPPL=INV;NAME =INV_VRULE_POSTING\\nN',
                                VALIDATE =>  'NONE',
                              REQUIRED => 'N',
                        ALLOWNULLS  => 'Y');

--------------------------------------------------------------------

FND_DESCR_FLEX.UPDATE_DEFINITION(
          BLOCK=>’block_name’,
            FIELD=>’field_name’,
    /* Argument to enable or disable flexfield */
     [ENABLED=>’{Y|N}’,]
    /* Other optional parameters */
         [VDATE=>’date’,]
          [TITLE =>’Title’,]
    [AUTOPICK=>’{Y|N}’,]
    [USEDBFLDS=>’{Y|N}’,]
    [READ_ONLY=>’{Y|N}’,]
    [LOCK_FLAG=>’{Y|N}’,]
    [HELP=>’APPL=application_short_name;
    TARGET=target_name’,]
    [CONTEXT_LIKE=>’WHERE_clause_fragment’}
);
 

------------------------------------------------------------------------------------------------------------------------------------------------------------------



Oracle Apps Form Message

FND_MESSAGE.CLEAR – Clears all the Oracle message stack of all the messages.

FND_MESSAGE.DEBUG – Immediately displays the string passed to it as input parameter.

FND_MESSAGE.ERASE – Clears the Oracle Forms status line.

FND_MESSAGE.ERROR - (Example: “Invalid value entered.”). It takes its message from the stack,

            displays the message, and then clears all the messages from the message stack.

FND_MESSAGE.HINT - Displays the message, and then clears that message

                   from the Oracle Apps message stack. The user may still need to acknowledge the message

                   if another message immediately comes onto the message line.

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: ”)  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 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.

FND_MESSAGE.RETRIEVE - Retrieves a message from the database server, translates and substitutes tokens,

                       and sets the message on the message stack.

FND_MESSAGE.SET_NAME - User can call it once for each message user use in client–side PL/SQL procedure.

            User must call this procedure before call FND_MESSAGE.SET_TOKEN.

FND_MESSAGE.SET_STRING - User can hard coded in the Oracle Apps form level and are not translated like messages defined in Message Dictionary.

FND_MESSAGE.SET_TOKEN - Substitutes a message token with a value you specify. User can 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.

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.

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?”   OK  /  CANCEL )

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

--------------------------------------------------------------------------------------------------------------------------------------------------------------------