fnd_message.show [message #470174] |
Mon, 09 August 2010 04:35  |
lokeshsurana
Messages: 212 Registered: April 2010 Location: India
|
Senior Member |
|
|
Hi i written simple procedure...as...
Declare
Begin
....
...
...
...
...
if condition then
fnd_message.set_string('Message');
fnd_message.show();
else
null;
end if;
end;
But getting error as
PLS-00302 'show' variable must be declared
PLS-00302 'set_string' variable must be declared
what should need to do to resolve this problem...?
|
|
|
|
|
|
|
|
|
|
|
|
Re: fnd_message.show [message #470199 is a reply to message #470197] |
Mon, 09 August 2010 05:34   |
 |
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
Cool!!!!!
This is what happens when you copy the code from Forms to database procedure.
These are Oracle Apps packages (under module Application Object Library - FND) with same name and different content.
$FND_TOP/patch/115/sql/AFNLMSGB.pls - database package
$FND_TOP/resource/FNDSQF.pld - forms package in pll / pld / plx
By
Vamsi
[Updated on: Mon, 09 August 2010 05:37] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|