Search Results itg_msg

Overview

ITG_MSG is a PL/SQL message-handling package body owned by the APPS schema in Oracle E-Business Suite. It is classified as an OTHER API within the ETRM documentation set for release 12.2.2 and remains in VALID status in 12.1.1 and 12.2.2 environments. The package serves as a centralized repository of user-facing error, warning, and informational messages used by the ITG (Internet Time Group / iProcurement-adjacent) product family. Rather than hard-coding literal text at each validation site, dependent programs call ITG_MSG to obtain a consistent, standardized message string. The package therefore acts as a message abstraction layer, improving maintainability and translation readiness while allowing message text to be revised in one location.

Key Procedures and Functions

The package exposes 96 documented procedures and functions, most of which are parameterless functions returning message text or small helper routines for constructing debug output. Representative members include:

Message accessors: TEXT returns a generic text message; MISSING_ELEMENT_VALUE, DATA_VALUE_ERROR, and UPDATE_FAILED return standard messages for missing required values, invalid data, and failed DML operations respectively.
Flexfield and account validation: EXISTING_FLEX_VALUE, FLEX_INSERT_FAIL, FLEX_UPDATE_FAIL_NOVALUE, FLEX_UPDATE_FAIL_NOTL, and INVALID_ACCOUNT_TYPE provide messages for Key Flexfield and Accounting Flexfield validation failures.
Currency and exchange rate: INVALID_CURRENCY_CODE, SAME_CURRENCY_CODE, and DUPLICATE_EXCHANGE_RATE return messages relating to multi-currency processing errors.
Purchasing and allocation: NO_PO_FOUND, NO_LINE_LOCS_FOUND, POLINE_CLOSED_RCV, ALLOCSHIP_TOOMANY_RTN, ALLOCDIST_TOOMANY_RTN, and ALLOCREQN_TOOMANY_RTN supply messages when purchase orders, line locations, or allocation routing rules are missing or exceed permitted limits.
Diagnostic helpers: DEBUG and DEBUG_MORE produce varying levels of trace output used during development and troubleshooting.

All functions are intended to be called directly from validation logic; none accept parameters in the documented metadata, and text is returned as the function result.

Tables Accessed

No base application tables are documented as directly referenced by ITG_MSG. Although the package body is compiled against APPS synonyms, its dependency list shows references only to other PL/SQL units: FND_MESSAGE, FND_MSG_PUB, ITG_X_UTILS, ITG_MSG (itself, for recursive calls to spec members), and SYS.STANDARD. The absence of table references confirms the package is a pure message provider rather than a data-access component. FND_MESSAGE and FND_MSG_PUB supply the Oracle Application Object Library messaging infrastructure, while ITG_X_UTILS supplies shared ITG utility routines.

Usage Notes

ITG_MSG is not referenced by any database object according to the ETRM dependency report on the package body, but the documented metadata indicates the package is referenced by 11 other packages. This means ITG_MSG is consumed almost exclusively at the PL/SQL layer by sibling ITG packages, which call its functions and append the returned text to the FND_MSG_PUB message stack. Typical callers are concurrent programs, OAF/forms validation routines, and custom extensions that need to raise a standard ITG error. Because the package is VALID and shipped in the APPS schema, customizations should reference APPS.ITG_MSG rather than creating a private copy, ensuring message consistency across releases.

PACKAGE BODY: APPS.ITG_MSG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_MSG, status:VALID,
PACKAGE BODY: APPS.ITG_MSG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_MSG, status:VALID,
PACKAGE: APPS.ITG_MSG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ITG_MSG, status:VALID,
PACKAGE: APPS.ITG_MSG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ITG_MSG, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.ITG_SYNCEXCHINBOUND_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCEXCHINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCCOAINBOUND_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCCOAINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_BOAPI_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_BOAPI_UTILS, status:VALID,
PACKAGE BODY: APPS.ITG_ORGEFF_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_ORGEFF_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCUOMINBOUND_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCUOMINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_DEBUG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_DEBUG, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCPOINBOUND_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCPOINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCCOAINBOUND_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCCOAINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCUOMINBOUND_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCUOMINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCPOINBOUND_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCPOINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCEXCHINBOUND_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCEXCHINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_BOAPI_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_BOAPI_UTILS, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCSUPPLIERINBOUND_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCSUPPLIERINBOUND_PVT, status:VALID,
PACKAGE: APPS.ITG_X_UTILS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ITG_X_UTILS, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCFIELDINBOUND_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCFIELDINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_DEBUG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_DEBUG, status:VALID,
PACKAGE BODY: APPS.ITG_ORGEFF_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_ORGEFF_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCFIELDINBOUND_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCFIELDINBOUND_PVT, status:VALID,
PACKAGE: APPS.ITG_X_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ITG_X_UTILS, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCITEMINBOUND_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCITEMINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCSUPPLIERINBOUND_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCSUPPLIERINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_SYNCITEMINBOUND_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_SYNCITEMINBOUND_PVT, status:VALID,
PACKAGE BODY: APPS.ITG_BOAPI_WRAPPERS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_BOAPI_WRAPPERS, status:VALID,
PACKAGE BODY: APPS.ITG_BOAPI_WRAPPERS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ITG_BOAPI_WRAPPERS, status:VALID,
PACKAGE: APPS.ITG_MSG 12.2.2
PACKAGE: APPS.ITG_MSG 12.1.1
APPS.ITG_SYNCUOMINBOUND_PVT dependencies on ITG_MSG 12.1.1
APPS.ITG_SYNCITEMINBOUND_PVT dependencies on ITG_MSG 12.1.1
APPS.ITG_BOAPI_UTILS dependencies on ITG_MSG 12.1.1
APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on ITG_MSG 12.2.2
APPS.ITG_SYNCCOAINBOUND_PVT dependencies on ITG_MSG 12.1.1
APPS.ITG_SYNCEXCHINBOUND_PVT dependencies on ITG_MSG 12.1.1
APPS.ITG_ORGEFF_PVT dependencies on ITG_MSG 12.1.1
APPS.ITG_SYNCFIELDINBOUND_PVT dependencies on ITG_MSG 12.2.2
APPS.ITG_DEBUG dependencies on ITG_MSG 12.2.2
APPS.ITG_MSG dependencies on ITG_MSG 12.2.2
APPS.ITG_BOAPI_WRAPPERS dependencies on ITG_MSG 12.1.1
APPS.ITG_MSG dependencies on ITG_MSG 12.1.1
APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on ITG_MSG 12.1.1
APPS.ITG_BOAPI_UTILS dependencies on ITG_MSG 12.2.2
APPS.ITG_SYNCEXCHINBOUND_PVT dependencies on ITG_MSG 12.2.2
APPS.ITG_SYNCUOMINBOUND_PVT dependencies on ITG_MSG 12.2.2