Search Results set_message_mode




Overview
Explore in AI Chat

Overview

INV_ITEM_MSG is an application-level PL/SQL package body owned by the APPS schema that provides the message handling and error reporting infrastructure for the Oracle Inventory item interface and related item maintenance processes. Its classification in the ETRM repository is "OTHER," reflecting that it is an internal utility package rather than a public business API. The package isolates the mechanics of message accumulation, formatting, and output so that item-related concurrent programs and interface routines can register errors, warnings, and informational messages consistently and then persist or display them through Oracle Application Object Library (AOL) mechanisms such as FND_MESSAGE and FND_MSG_PUB.

The package depends on FND_API, FND_MESSAGE, FND_MSG_PUB, FND_FILE, FND_PROFILE, ERROR_HANDLER, and INVPUTLI, confirming its role as a wrapper around the standard EBS message stack and the Inventory item utility layer. It is referenced by eleven other packages in the APPS schema, indicating that it is a shared service relied upon broadly across item interface and item import processing rather than a component invoked in isolation.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions:

  • INITIALIZE / INITIALIZE_ERROR_HANDLER — Establish the package's internal message state and wire up the error handler before any messages are recorded.
  • SET_MESSAGE_LEVEL / SET_MESSAGE_MODE — Control the verbosity and disposition of messages, determining which severities are captured and how they are reported.
  • ADD_MESSAGE, ADD_ERROR, ADD_WARNING, ADD_UNEXPECTED_ERROR — Register individual messages on the stack, each targeting a different severity so callers can distinguish fatal conditions from advisories.
  • DEBUG — Emit diagnostic output when debug mode is enabled, typically used during interface troubleshooting.
  • COUNT_MSG / COUNT_AND_GET — Query the accumulated message stack, returning counts and retrieving stored entries for downstream processing or reporting.
  • WRITE_MESSAGE / WRITE_LIST — Flush accumulated messages to the designated output destination, such as the concurrent program log or a persistent error table.
  • GET — Retrieve a stored message for display or further handling.

Parameter lists are not reproduced here; callers should consult the package specification for exact signatures.

Tables Accessed

The package operates against three documented objects, accessed through APPS synonyms:

  • MTL_INTERFACE_ERRORS — the standard Inventory interface error repository, used to persist validation failures encountered during item import so they can be reviewed and corrected.
  • MTL_SYSTEM_ITEMS_INTERFACE_S — the item interface sequence, used to obtain identifiers for interface rows being processed.
  • PLITBLM — the PL/SQL integer table type used internally for bulk message collection and list handling.

Usage Notes

INV_ITEM_MSG is typically invoked from concurrent programs and PL/SQL routines that load or validate item data, including the item import and interface programs that maintain MTL_SYSTEM_ITEMS_INTERFACE and its error table. Custom code extending the item interface should adopt the same initialize, add-message, and write-message sequence to preserve consistency with standard error reporting and to ensure messages reach the concurrent manager log. Because the package is referenced by eleven other APPS packages, changes to its behavior can propagate widely; it should be treated as a shared internal utility and modified only with full regression testing across the item interface, as it is not itself referenced by any database object such as a trigger or view.