Re: Question about fnd_message
Date: Thu, 02 Nov 2000 16:44:00 GMT
Message-ID: <8ts5ke$aq4$1_at_nnrp1.deja.com>
In article <8tq98m$dgh_at_gap.cco.caltech.edu>,
"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.'
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.
Received on Thu Nov 02 2000 - 17:44:00 CET