Order Management - EBS (MOSC)

MOSC Banner

Getting nothing when calling fnd_message.get()

edited May 7, 2014 12:00PM in Order Management - EBS (MOSC) 2 commentsAnswered

This has nothing to do with Order Management, but I couldn't find a community area for general-purpose FND issues.  Maybe someone can find one and move this post to it.

When I issue a call to fnd_message.get in a package, its returns a NULL.  Here is an example of a stored procedure in which fnd_message.get returns nothing:

PROCEDURE generate_email_body_hasp_new (
                   p_passcode            IN  VARCHAR2,
                   x_email_body          OUT VARCHAR2,
                   x_status              OUT VARCHAR2,
                   x_status_msg          OUT VARCHAR2)  IS

  l_email_body                    VARCHAR2(2000);
   l_temp_email_body               VARCHAR2(2000);

BEGIN

   fnd_global.apps_initialize (1855, 51952, 20003);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center