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 #470181 is a reply to message #470179] |
Mon, 09 August 2010 04:53 |
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
I search for this it saying its PATCH problem....it is really..?
what should need to do to resolve this problem...?
|
|
|
|
|
Re: fnd_message.show [message #470187 is a reply to message #470185] |
Mon, 09 August 2010 05:06 |
cookiemonster
Messages: 13961 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
So this is a database procedure?
Because the error messages you are reporting look wrong:
SQL> Begin
2 if 1=1 then
3 fnd_message.set_string('Message');
4 fnd_message.show();
5 else
6 null;
7 end if;
8 end;
9 /
fnd_message.set_string('Message');
*
ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00201: identifier 'FND_MESSAGE.SET_STRING' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
ORA-06550: line 4, column 1:
PLS-00201: identifier 'FND_MESSAGE.SHOW' must be declared
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
SQL>
You should be getting PLS-00201 not PLS-00302.
So what exactly is this code written in and what is fnd_message?
|
|
|
Re: fnd_message.show [message #470188 is a reply to message #470187] |
Mon, 09 August 2010 05:11 |
lokeshsurana
Messages: 212 Registered: April 2010 Location: India
|
Senior Member |
|
|
Its Database procedure only.....
As any of request_ID in particular range suppose to be 1 to 10000 is get called then i need to show message...
The code is come to me as for testing purpose...I checked the same code is working on the Application form but it not working in this simple procedure.
This procedure is reflects results at application level...
So what should i need to do to resolve this issue..?
|
|
|
|
Re: fnd_message.show [message #470194 is a reply to message #470191] |
Mon, 09 August 2010 05:16 |
lokeshsurana
Messages: 212 Registered: April 2010 Location: India
|
Senior Member |
|
|
PROCEDURE CLEAR
FUNCTION FETCH_SQL_TOKEN RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TOK_VAL VARCHAR2 IN
FUNCTION GET RETURNS VARCHAR2
FUNCTION GET RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AUTO_LOG VARCHAR2 IN
FUNCTION GET_ENCODED RETURNS VARCHAR2
FUNCTION GET_ENCODED RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AUTO_LOG VARCHAR2 IN
PROCEDURE GET_MESSAGE_INTERNAL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPIN VARCHAR2 IN
NAMEIN VARCHAR2 IN
LANGIN VARCHAR2 IN
AUTO_LOG VARCHAR2 IN
MSG VARCHAR2 OUT
MSG_NUMBER NUMBER OUT
MSG_TYPE VARCHAR2 OUT
FND_LOG_SEVERITY NUMBER OUT
ALERT_CATEGORY VARCHAR2 OUT
ALERT_SEVERITY VARCHAR2 OUT
FUNCTION GET_NUMBER RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPIN VARCHAR2 IN
NAMEIN VARCHAR2 IN
FUNCTION GET_STRING RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPIN VARCHAR2 IN
NAMEIN VARCHAR2 IN
FUNCTION GET_STRING RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPIN VARCHAR2 IN
NAMEIN VARCHAR2 IN
AUTO_LOG VARCHAR2 IN
PROCEDURE GET_TEXT_NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPIN VARCHAR2 IN
NAMEIN VARCHAR2 IN
MSGTEXT VARCHAR2 OUT
MSGNUMBER NUMBER OUT
FUNCTION GET_TOKEN RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TOKEN VARCHAR2 IN
REMOVE_FROM_MESSAGE VARCHAR2 IN DEFAULT
FUNCTION GET_TOKEN RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TOKEN VARCHAR2 IN
REMOVE_FROM_MESSAGE VARCHAR2 IN DEFAULT
AUTO_LOG VARCHAR2 IN
PROCEDURE PARSE_ENCODED
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
ENCODED_MESSAGE VARCHAR2 IN
APP_SHORT_NAME VARCHAR2 OUT
MESSAGE_NAME VARCHAR2 OUT
PROCEDURE RAISE_ERROR
PROCEDURE RETRIEVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MSGOUT VARCHAR2 OUT
PROCEDURE SET_ENCODED
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
ENCODED_MESSAGE VARCHAR2 IN
PROCEDURE SET_MODULE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MODULE VARCHAR2 IN
PROCEDURE SET_NAME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLICATION VARCHAR2 IN
NAME VARCHAR2 IN
PROCEDURE SET_TOKEN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TOKEN VARCHAR2 IN
VALUE VARCHAR2 IN
TRANSLATE BOOLEAN IN DEFAULT
PROCEDURE SET_TOKEN_SQL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TOKEN VARCHAR2 IN
VALUE VARCHAR2 IN
|
|
|
Re: fnd_message.show [message #470197 is a reply to message #470194] |
Mon, 09 August 2010 05:27 |
cookiemonster
Messages: 13961 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
A quick search of that ouput reveals no functions or procedures called either SET_STRING or SHOW.
So you're calling stuff that doesn't exist.
So I suggest you ask who ever wrote this code where these procedures they are trying to call actually are.
|
|
|
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
|
|
|
Re: fnd_message.show [message #470201 is a reply to message #470199] |
Mon, 09 August 2010 05:36 |
cookiemonster
Messages: 13961 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Can you clarify something for those of us that don't have apps Vamsi?
Do these procedures he's trying to call exist in the forms package and not the DB one?
|
|
|
|
Re: fnd_message.show [message #470205 is a reply to message #470202] |
Mon, 09 August 2010 05:47 |
cookiemonster
Messages: 13961 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
So oracle created a forms package, then created a DB package with the same name, with some (but not all) of the same functions/procedures in the forms package?
What were they thinking?
@lokeshsurana - you're trying to call forms specific code so you can only test this using forms.
|
|
|
|
|
|
|
|
|
|
Re: fnd_message.show [message #470240 is a reply to message #470228] |
Mon, 09 August 2010 06:52 |
lokeshsurana
Messages: 212 Registered: April 2010 Location: India
|
Senior Member |
|
|
@vasmi
Thanks for this information.
Frankly speak...
I have one procedure which i used to send mail.And this procedure i am calling on User creation form by Form personalization method.
if mail procedure runs successfully then i want to show message as Send in message window if get error while sending i need to show that error message.
For this purpose i write fnd_message.set and .show in procedure but procedure is getting those errors
Resolve this problem what should need to do..?
|
|
|
|
Re: fnd_message.show [message #470242 is a reply to message #470241] |
Mon, 09 August 2010 07:03 |
lokeshsurana
Messages: 212 Registered: April 2010 Location: India
|
Senior Member |
|
|
is it right way to do...? Because the form is Standard one....to do modification in Standard form...some what danger..?
Is there any other way to solve this problem..?
|
|
|
|