Search Results write_fndlog_string

Overview

APPS.GL_MESSAGE is a General Ledger utility package that provides centralized message retrieval and token-substitution services for Oracle EBS Release 12.1.1 and 12.2.2. Its principal business function is to resolve Oracle Application Object Library (AOL) message names into fully formatted, language-appropriate message text, replacing embedded tokens with runtime values supplied by the calling program. This includes the expansion of the special token syntax used for numeric and formatted substitution, illustrated by inputs such as the token reference "Token@2026789".

The package is declared AUTHID CURRENT_USER, meaning executing privileges are evaluated against the invoking schema rather than the package owner. Its source header (gluplmgs.pls, version 120.1) dates from 2004, and the package remains a documented component of the ETRM 12.2.2 object inventory, classified under API classification OTHER. It is referenced by 57 other packages, confirming its role as a shared infrastructure service across General Ledger and adjacent modules.

Key Procedures and Functions

• GET_MESSAGE — The primary public interface. Documented in multiple overloaded forms, each accepting a message name and a "show number" indicator, and optionally accepting up to four token-name/token-value pairs (t1/v1 through t4/v4). Returns the resolved message string. Callers select the overload matching the number of tokens present in the message.
• MSG_TKN_EXPAND — Expands token references within a message string, substituting a supplied token name with its corresponding value. This function underpins the numbered token behavior referenced by searches such as "Token@2026789".
• WRITE_BUFFER — Writes a message name and its actual message text (including token values) into an internal buffer. Documented arguments include the message name, the number of tokens present, and up to five token name/value pairs. Originally created by Srini Pala on 10-04-2001.
• SET_LANGUAGE — Establishes the language context used when retrieving and expanding messages.
• WRITE_LOG, WRITE_OUTPUT, WRITE_FNDLOG_MSG, and WRITE_FNDLOG_STRING — Diagnostic and output helpers that record message content to the log or output stream, including integration with FND_LOG-style message and string logging.
• FUNC_SUCC, FUNC_FAIL, and FUNC_ENT — Status and instrumentation utilities that signal successful or failed function completion and mark function entry, supporting consistent logging conventions.

The documented inventory lists 15 procedures and functions in total; no parameter lists beyond those shown in the source excerpt should be assumed.

Tables Accessed

The only documented table reference is DUAL, accessed through an APPS synonym. DUAL is used for single-row evaluations and expression testing inherent to PL/SQL message formatting, and it does not represent persistent application data. Message text is resolved through the AOL message dictionary rather than through direct table references recorded in this package's metadata.

Usage Notes

GL_MESSAGE is typically invoked from PL/SQL-based concurrent programs, forms-level server-side logic, and custom extensions that must present consistent, translated Oracle EBS messages. Calling code supplies the AOL message name, the token pairs required by that message, and receives a formatted string suitable for display in a form, a report, or a concurrent program log. The WRITE_* routines are used where the requirement is to persist message output into a buffer, log file, or FND log destination rather than return it to the caller. Because the package is referenced by 57 other packages, it should be treated as shared infrastructure: changes to behavior would have broad impact, and customizations should call the documented GET_MESSAGE overloads rather than depend on internal buffer state.