Home » Applications » Oracle Fusion Apps & E-Business Suite » fnd_message.show (oracle 10g)
fnd_message.show [message #470174] Mon, 09 August 2010 04:35 Go to next message
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 #470179 is a reply to message #470174] Mon, 09 August 2010 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you write it in Forms?

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: fnd_message.show [message #470181 is a reply to message #470179] Mon, 09 August 2010 04:53 Go to previous messageGo to next message
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 #470184 is a reply to message #470181] Mon, 09 August 2010 04:56 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Again - is this forms question?
Re: fnd_message.show [message #470185 is a reply to message #470184] Mon, 09 August 2010 04:58 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
no its not...

I just want to compile this procedure ...

but giving error....
Re: fnd_message.show [message #470187 is a reply to message #470185] Mon, 09 August 2010 05:06 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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 Go to previous messageGo to next message
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 #470191 is a reply to message #470188] Mon, 09 August 2010 05:13 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
In sqlplus do:
desc FND_MESSAGE;

and post the result here.
Re: fnd_message.show [message #470194 is a reply to message #470191] Mon, 09 August 2010 05:16 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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 #470202 is a reply to message #470201] Mon, 09 August 2010 05:39 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Yes. Exactly.

By
Vamsi
Re: fnd_message.show [message #470205 is a reply to message #470202] Mon, 09 August 2010 05:47 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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 #470206 is a reply to message #470199] Mon, 09 August 2010 05:50 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
so..is possible to run this procedure without error...?
Re: fnd_message.show [message #470212 is a reply to message #470206] Mon, 09 August 2010 05:58 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Not in the DB no.
You're calling procedures that only exist in a forms package.
So only forms can see them.
Re: fnd_message.show [message #470215 is a reply to message #470212] Mon, 09 August 2010 06:02 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
ops so i need to go in Form Personalization things.....


Thank you guys..........
Re: fnd_message.show [message #470219 is a reply to message #470206] Mon, 09 August 2010 06:09 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
lokeshsurana wrote on Mon, 09 August 2010 16:20
so..is possible to run this procedure without error...?
As you have the apps instance, go to the files, which I've provided.
Check the code in both the packages and change your database procedure.
Anyway, I think the DB package is only for seeded error messages (table fnd_new_messages).
We normally use fnd_log for tracing.
fnd_log.message (Or) fnd_log.string
Check them out.

@cookiemonster,
What I can say by looking at the code is:
DB packages is for the error messages stack and write the messages to log file.
Form package is for form messages / warnings / errors in GUI.

Both packages are entirely different.

By
Vamsi
Re: fnd_message.show [message #470221 is a reply to message #470219] Mon, 09 August 2010 06:12 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Fair enough, I'm still baffled as to why they have the same name, but it's not like oracle's going to change it.
Re: fnd_message.show [message #470223 is a reply to message #470215] Mon, 09 August 2010 06:16 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
lokeshsurana wrote on Mon, 09 August 2010 16:32
ops so i need to go in Form Personalization things.....
Quote:
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..?
Got confused.
So, you are writing a DB procedure that will be used in Forms code?
If you can't change the form code, then you should go for personalization. And you can write the custom code in pld itself using forms fnd_message package. Isn't it?

By
Vamsi
Re: fnd_message.show [message #470228 is a reply to message #470221] Mon, 09 August 2010 06:21 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
cookiemonster wrote on Mon, 09 August 2010 16:42
Fair enough, I'm still baffled as to why they have the same name, but it's not like oracle's going to change it.
True.
But I better not to comment on it. Cool

By
Vamsi
Re: fnd_message.show [message #470240 is a reply to message #470228] Mon, 09 August 2010 06:52 Go to previous messageGo to next message
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 #470241 is a reply to message #470240] Mon, 09 August 2010 07:00 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Can you try to change / replicate the procedure (send mail) into CUSTOM.pld, which can have access to Forms FND package?

By
Vamsi
Re: fnd_message.show [message #470242 is a reply to message #470241] Mon, 09 August 2010 07:03 Go to previous messageGo to next message
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..?
Re: fnd_message.show [message #470247 is a reply to message #470242] Mon, 09 August 2010 07:13 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I don't think I've asked you to change the Form code.
Hope this helps you.

By
Vamsi
Previous Topic: Account present in hz_cust_accounts table but cannot find through customer screen in oracle apps
Next Topic: Create and Enable Find/Torch menu Button in Customized Form
Goto Forum:
  


Current Time: Fri Mar 29 06:54:02 CDT 2024