Who's Online Now
0 registered members (), 10 guests, and 19 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Ravi Pasapula, kumar1900, B_DOYLE, rdeshab, samba
1296 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
492,376 PAYE RTI
59,860 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#11614 - 04/08/16 02:38 PM fnd_message.get is truncating err String in WebADI  
Joined: Aug 2014
Posts: 2
KIRTI_MOHAN Offline
stranger
KIRTI_MOHAN  Offline
stranger

Joined: Aug 2014
Posts: 2
fnd_message.get is not able to pass whole error msg from package to WebADI Excel.
Could you guys please suggest something else for that
Exception handling code of package is provided below
-----
Exception
when others then
lc_err_msg := 'Web ADI Error Message: '||lc_emp_number;
fnd_message.set_name('XXCMN', lc_err_msg);
lc_mesg := fnd_message.get;
raise_application_error(-20001, lc_mesg);
-----

Whole Error Was : "ORA-20116: ORA-20001: FLEX-VALUE DOES NOT EXIST: N, VALUE, 1400USD, N, SEGMENT, Referral Amount, N, VALUESET, KE_HR_REFERRAL_AMT"

Value passed by variable lc_mesg was : "ORA-20116: ORA-20001: FLEX-VAL (ERROR_MESSAGE=)" ...........i.e. only first 30 characters from whole string.


Thanks & Regards,
Kirti Mohan Sharma

#11617 - 05/08/16 07:19 AM Re: fnd_message.get is truncating err String in WebADI [Re: KIRTI_MOHAN]  
Joined: Mar 2005
Posts: 1,293
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,293
Earth, Europe, England, here
This may sound like the obvious question, but what is the definition of the variable lc_err_msg and lc_mesg.


No signature required
#11634 - 23/08/16 05:11 PM Re: fnd_message.get is truncating err String in WebADI [Re: KIRTI_MOHAN]  
Joined: Aug 2014
Posts: 2
KIRTI_MOHAN Offline
stranger
KIRTI_MOHAN  Offline
stranger

Joined: Aug 2014
Posts: 2
Thanks Cooper!!!
I was doing a mistake earlier....i have created one custom message XXHRWEBADIERR and when i used below code it worked fine.

EXCEPTION
WHEN OTHERS THEN
x_errorm := SQLERRM;

FND_MESSAGE.set_name ('BNE', 'XXHRWEBADIERR');

fnd_message.set_token('ERROR_MESSAGE', x_errorm);
lc_mesg := fnd_message.get();

RAISE_APPLICATION_ERROR(-20116, lc_mesg);

fnd_message.clear;

ROLLBACK;
END;


Moderated by  Administrator, Geoff Dixon 

Forum Statistics
Forums60
Topics2,227
Posts12,029
Members1,296
Most Online283
Dec 25th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,116
delboy 1,306
bcooper 1,293
paulgos 439
SBi 427
pat 254
Gus 252
vkumar 223
April
S M T W T F S
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.021s Queries: 15 (0.007s) Memory: 2.7462 MB (Peak: 2.8915 MB) Zlib disabled. Server Time: 2020-04-07 14:01:23 UTC