Monday, June 18, 2007

FND_MSG_PUB for error logging in Oracle Applications

FND_MSG_PUB for error logging in Oracle Applications.

Use the following snipped of code while calling any seeded API in Oracle Applications, like CRM, or Financials.

Put this block exactly under the section where you invoke the private or public API. The errors raised in the API are logged in the following API. Use this code while error logging or while debugging. Comment out the code before moving into production.

IF ( FND_MSG_PUB.Count_Msg > 0) THEN
FOR i IN 1..FND_MSG_PUB.Count_Msg    LOOP
FND_MSG_PUB.Get(p_msg_index     => i,
          p_encoded       => 'F',
          p_data          => out_message,
          p_msg_index_OUT => l_msg_index_OUT );
dbms_output.put_line('l_msg_data :' ||out_message);
END LOOP;
END IF;

30 comments:

Anonymous said...

Remarkable! Its truly remarkable piece of writing, I have got much clear idea concerning from this piece of writing.


My weblog; time to stop smoking tobacco

Anonymous said...

It's actually a cool and useful piece of info. I am satisfied that you simply shared this helpful information with us. Please keep us up to date like this. Thanks for sharing.

Here is my web-site: phil cardella arrested

Anonymous said...

What's up to every body, it's my first visit of this webpage; this
web site contains remarkable and genuinely good stuff in support of visitors.



my web site ... escort amsterdam

Anonymous said...

Can I put up your post to my wordpress blog? I'll add a back link to your forum. That’s one really nice post.

Check out my page: having trouble getting pregnant the third time

Anonymous said...

Superb, what a blog it is! This blog provides valuable data to us, keep it
up.

Also visit my web page somanabolic type

Anonymous said...

I am really delighted to glance at this weblog posts which carries plenty of
helpful facts, thanks for providing such statistics.


Take a look at my weblog :: somanabolic type

Anonymous said...

You made some decent points there. I checked on the internet for more information
about the issue and found most individuals will go along
with your views on this site.

My web page - signs of thyroid problems

Anonymous said...

Wow, incredible blog layout! How long have you been blogging for?

you make blogging look easy. The overall look of your website is
great, as well as the content!

My page; seo Google

Anonymous said...

Greetings! Very helpful advice in this particular article!
It's the little changes that will make the most significant
changes. Many thanks for sharing!

Look into my weblog; Charlotte Olympia Flats

Anonymous said...

What a stuff of un-ambiguity and preserveness of precious
familiarity concerning unpredicted emotions.

Review my site: clash of clans cheats

Anonymous said...

Ahaa, its pleasant discussion regarding this piece of writing here at this web site, I have read all that, so now
me also commenting here.

Here is my web-site - Beats By Dre Cheap (http://yinglong.org/guifa/viewtopic.php?id=40490)

Anonymous said...

Hurrah! At last I got a blog from where I be capable of genuinely get useful information concerning my study and knowledge.


my web blog web hosting company for sale 2011

Anonymous said...

I enjoy what you guys tend to be up too. This sort of clever work and coverage!
Keep up the very good works guys I've added you guys
to blogroll.

Here is my web blog: New Balance Store

Adiseshu said...

Hi All,

I am trying to create one receipt using API.
But my data has two issues one is invalid receipt method identifier and one is with dff value.
So i want to pront both message at a time in the log.
But i could not.
I am able to print only one messge at a time and after rectifing that one only i am able to show the second error message but i want both at a time.
Can any one please help me on this thing?

Regards,
Adi

Indian Pride said...

Celebration is going to be more fun and enjoyable on this independence day 2016, wish you a very Happy independence day

Goyal said...

15 August Speech in Hindi 15 august

Unknown said...



Independence day Images 2016

Akshay said...

great post really appreciable work Your site is truly cool and this is an incredible rousing article.
xmas Quotes
propose day images
happy rose day
chocolate day messages
happy hug day 2017
kiss day images
happy promise day 2017
teddy day

RdxPunjaB said...

rose day quotation
kissing day 2017
chocolate day messages
valentine week
happy valentines day pictures
valentine images of love
hug day pic
happy valentine day sms

himan said...

visits site for best health tips on http://healthtipo.com and stay tuned with us.

himan said...

visit http://howtomore.com for pc tricks, mobile, tech tricks, and how to do.

Unknown said...


Have Lovely and Beautiful Salwar Suit And Many More…
We Have Some For You In Your Budget For more…
Plz visit:- Salwar Kameez

Unknown said...

Fancy designer wear our website and reasonable price More…
We Have Some For You In Your Budget For more…
Plz visit:- Indian Clothing

Anonymous said...

Designer Sarees is perhaps the desire of every single girl in this world to look amazing on her wedding day.
It is certainly important that the bride must be the star of the show.The most beautiful woman at the wedding venue.
In India,Designer Sarees are the most obvious choice for the Young Ladies.There are many Designer Sarees in our site...
For more...
Plz visit:- Designer Sarees

An adorable personality partnered with a perfect choice for designer Sarees unbeatable.
Even before the blossom of modernization in Indian culture, kurta, sarees, and salwar kameez had been part of India's unique civilization.
In India,Designer Sarees are the most obvious choice for the Young Ladies.There are many Designer Sarees in our site...
For more...
Plz visit:- Designer Sarees

Mike said...

Viral Axe
weight loss
Make Money
trending videos
Funny compilation
Angelina

Unknown said...

Thanks for the great content


گوشی هوشمند iPhone X و قابلیت تشخیص چهره
گوشی هوشمند iPhone X و تحویل با تاخیر آن
نرم‌افزار WhatsApp و اضافه‌شدن ویژگی حذف پیام

Cricket Highlights said...

Are you an avid fan of cricket sport! If yes then online cricket game can serve your purpose very well. But to those who are new to the cricket world for them its necessary to know some of the vital factors which influence the nature of the game. Online cricket games are completedly built in similar tunes with those of the real ones that are seen across the Watch Online Score At CricketHighlights.

Haider Jamal Abbasi (iAMHJA) said...

Tiktok foryou page
Best Kahoot Names
Google Question Hub

@star Nepal said...

Thanks and Regards. For any information about Tiktok , please check Arcplux

foodie.com said...

What is cyber law

Cyber law in also known as the internet law. It means that cyber law protect us from cyber crimes like DDoS attacks.
Botnets, Identity Theft, Cyberstalking, Social Engineering, PUPs, Phishing, Prohibited/Illegal Content. Cyber law is a legal system designed to deal with the Internet, computing, Cyberspace, and related legal issues.