Question about fnd_message

[C r a i g e r s]

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.

[jamesn...@my-deja.com]

In article <8tq98m$d...@gap.cco.caltech.edu>,

fnd_message.question is a function.

function fnd_message.question
(button1 IN VARCHAR2 default 'YES',
button2 IN VARCHAR2 default 'NO',
button3 IN VARCHAR2 default 'CANCEL',
default_btn IN NUMBER default 1,
cancel_btn IN NUMBER default 3,
icon IN varchar2 default 'question'
) RETURN number

>
> 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.

Developer does not have any info about this because it is an
applications function which resides in the FNDSQF library. You should
read the Oracle Applications Developers Guide for more information

>
> --
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy.

[Richard Kessler]

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.

rake...@mindspring.com
==================================
Stored Procedures Exceptions

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

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