Search Results api_header

Overview

VEA_TPA_UTIL_PVT is a private PL/SQL utility package within the Oracle E-Business Suite Trade Management (formerly ETRM) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its header, seeded at version 115.16, identifies it as a general-purpose helper for the Vendor/Third-Party (TPA) processing family, supplying reusable primitives for message handling, cross-reference conversion, layer (trade agreement layer) activity caching, and lookups. The package embodies the standard EBS public/private API convention: constants G_PUBLIC_API ('PUB'), G_PRIVATE_API ('PVT'), and G_GROUP_API ('GRP') distinguish API visibility, while G_ERROR, G_UNEXPECTED_ERROR, and G_OTHER_ERROR standardize error severities. Because it is classified as a private API, it is not intended for direct customer invocation; it exists to be called by higher-level public APIs and internal TPA program units. The header also defines private collection types — g_programUnit_rec_type/g_programUnit_tbl_type, g_layer_rec_type/g_layer_tbl_type, and g_code_conversion_rec_type — together with package globals g_ProgramUnit_Tbl, g_ProgramUnitExt_Tbl, and g_layer_Tbl, which cache program-unit and layer metadata for the duration of a session to avoid repeated queries. As an internal utility, changes to its internals can occur without notice, reinforcing why it is classified PVT.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions, all serving internal plumbing roles:

• ADD_MESSAGE — places a formatted message onto the internal message stack for later retrieval.
• ADD_MESSAGE_AND_RAISE — adds a message and immediately raises the corresponding application exception.
• ADD_EXC_MESSAGE_AND_RAISE — variant that formats a caught exception's text, adds it, and raises it.
• DISPLAY_MESSAGE — renders the pending message text, typically for debugging or user feedback.
• GET_MESSAGE_TEXT — returns the accumulated message text from the stack.
• DEBUG — writes diagnostic output controlled by the package's debugging flags.
• VALIDATE — performs common validation checks shared by TPA callers.
• CONVERT_FROM_EXT_TO_INT — converts an external (legacy/partner) value into its Oracle internal value using cross-reference data.
• CONVERT_FROM_INT_TO_EXT — the inverse conversion, from internal to external value.
• CONVERTBRANCHCRITERIA — converts branch-search criteria, applying value mapping before query construction.
• UPDATE_LOOKUP_VALUES — maintains existing FND_LOOKUP_VALUES entries used by the module.
• INSERT_LOOKUP_VALUES — seeds new lookup values.
• CLEARLAYERACTIVETABLE — clears the cached layer-active collection (g_layer_Tbl) so it is repopulated on next use.
• NAME — returns the object/attribute name resolved through the package's naming logic.

No parameter lists are published for these units; callers should rely on the packaged specification rather than reconstructing signatures.

Tables Accessed

The package reads and writes a defined set of TPA and cross-reference tables. Conversion routines rely on ECE_XREF_DATA together with ECE_XREF_CATEGORIES, ECE_XREF_CATEGORIES_S1, and ECE_XREF_DATA_S1 to map internal and external code values. Layer and program-unit configuration is drawn from VEA_LAYERS, VEA_LAYER_HEADERS, VEA_TP_LAYERS, VEA_PROGRAM_UNITS, VEA_PARAMETERS, and VEA_PACKAGES, which supply the provider codes, layer identifiers, active flags, and parameter names cached in the package global collections. Lookup maintenance routines operate on FND_LOOKUP_VALUES. DUAL is used for scalar expression evaluation, and PLITBLM is the standard EBS PL/SQL index-by table helper. These tables are referenced through APPS synonyms, consistent with the CURRENT_USER invoker-rights model.

Usage Notes

VEA_TPA_UTIL_PVT is invoked indirectly. The ETRM metadata records that it is referenced by seventeen other packages, meaning public TPA APIs and internal processing routines call its conversion, validation, and messaging helpers rather than customers calling it directly. Typical invocation paths are ETRM forms and concurrent programs that process vendor/third-party trade agreements, where external identifiers must be converted to internal IDs, branch criteria mapped, and errors surfaced through the shared message stack. Session-scoped caching (g_layer_Tbl, g_ProgramUnit_Tbl) means callers should call CLEARLAYERACTIVETABLE when layer configuration changes mid-session. Because the package is a private API, customizations should not bind to it; supported extension should use the public APIs that consume it. On both EBS 12.1.1 and 12.2.2 the behavior is governed by the same packaged specification.