Re: Question about fnd_message

Just got back from the Extend Oracle Applications class and have not tried this stuff yet, but here are notes I made from several sources. The documentation should be in the Extend Oracle Applications guide (metalink), not developer.

P.S. Direct mail to you bounced.

rakessler_at_mindspring.com

for failures in PL/SQL stored procedures where you want to stop further processing:

        IF (error condition) THEN
        fnd_message.set_name(appl_short_name, message_name);
        APP_EXCEPTION.RAISE_EXCEPTION;
        END IF;

also try FND_MESSAGE.SET_STRING(value VARCHAR2);
        then either
        FND_MESSAGE.[SHOW | ERROR | WARN | QUESTION ]
                        ERROR,    1 button returns TRUE or FALSE
                        QUESTION, 2 button returns button number
                        SHOW,     1 button no return

=======================================

On Wed, 1 Nov 2000 15:38:58 -0800, "C r a i g e r s" <nospam.craigers_at_ukrm.org> wrote:

>Hope this isn't too old already- we aren't upgrading to 11i until mid '01.
>
>I was wondering if I can get your input on this problem, I'm relatively new
>to forms development.
>
>I'm modifying an existing form (GMSINWKB - AP Workbench). The modification
>is a warning message that pops up warning the user that they may want to
>change the expenditure type for certain items (having line type like
>'FREIGHT')- but not mandatory, more as a reminder, a suggestion, not real
>action taken other than perhaps a GO_BLOCK or GO_ITEM call if they select
>the button.
>
>At first I tried adding an alert and that wasn't entirely successful, for
>reasons unknown- compilation error message was not helpful in discerning
>why.
>
>Attempting now to add the message using FND_MESSAGE.
>
> Fnd_Message.Set_Name('SQLAP', 'AP_INV_MATCH_EQU_EXP_TYPE');
> Fnd_Message.Question('Yes', 'No', null);
>
>The form utilises FND_MESSAGE.WARN and FND_MESSAGE.ERROR and I went to call
>a different one FND_MESSAGE.QUESTION but when compiling get 'QUESTION is not
>a procedure or is undefined.'
>
>I text-ised the .fmb into an .fmt and searched to see what else I could be
>missing, but nothing obvious.
>
>Forms Developer doesn't have any info in Help on FND_MESSAGE, and the coding
>standard manual does not make mention of any declarations or database
>insertions to make this happen.
>
>
>--
>D o t a c i o n
>
>Oracle Environment 7.3.4 NCA
>Solaris
>Designer Reports 2.5 Forms 4.5
>
>A tech once calmed a man who was enraged because "his computer had told him
>he was bad and an invalid." The tech patiently explained that the computer's
>"bad command" and "invalid" responses shouldn't be taken personally.
>
>
>
>
>
>
>
Received on Sun Nov 05 2000 - 16:48:53 CET