Results for “inv_debug_trace”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.INV_COST_GROUP_PUB is a public PL/SQL package body in the Oracle E-Business Suite Inventory module. It provides the published application programming interface for assigning cost groups to inventory transactions. A cost group is the Inventory attribute that determines how an item's cost is valued and grouped within a given organization, and correct assignment is fundamental to accurate costing, variance analysis, and inventory valuation reporting.

The package body is a thin public wrapper: its exposed procedure delegates processing to the private package INV_COST_GROUP_PVT, which contains the actual business logic. This public/private split is a standard EBS coding convention that keeps the callable contract stable while allowing Oracle to revise internal implementation. The package was authored in 2005 and carries no significant structural changes across the 12.1.1 and 12.2.2 releases, since the module's cost group assignment semantics have remained consistent.

Key Procedures and Functions

The documented API surface consists of three procedures:

• ASSIGN_COST_GROUP — The principal public entry point. It accepts standard FND_API parameters such as an API version number, an initialization flag, and a commit flag, returns the standard status and message outputs, and takes the transaction line and organization identifiers along with an input type. It returns the assigned cost group identifier and a transfer cost group identifier. Internally it calls inv_cost_group_pvt.assign_cost_group to perform validation and assignment.
• SET_GLOBALS — Stores the cost group identifier and transfer cost group identifier in package-level global variables so that they persist for the duration of the session or calling sequence.
• GET_GLOBALS — Returns the current values of the two global variables set by SET_GLOBALS.

An internal helper, PRINT_DEBUG, exists in the body but is not part of the documented public contract; its message output is currently disabled.

Tables Accessed

The ETRM metadata documents no direct table references via APPS synonyms. This is consistent with the package's design as a delegating wrapper: all reads and writes against inventory costing and transaction tables are performed inside INV_COST_GROUP_PVT and its underlying validation routines. Callers should therefore consult the private package and its dependent tables when tracing the full data footprint of a cost group assignment.

Usage Notes

The package is referenced by five other packages, indicating it is consumed primarily by other EBS APIs and internal programs rather than being invoked directly by end users. Typical invocation scenarios include Inventory transaction processing, receiving and transfer flows, and custom extensions that need to place a line into the correct cost group. Because ASSIGN_COST_GROUP follows the FND_API error-handling pattern, custom callers must check x_return_status for FND_API.G_RET_STS_SUCCESS and inspect x_msg_count and x_msg_data when errors occur.

Regarding the search term inv_debug_trace: every procedure in this body reads the profile option INV_DEBUG_TRACE via FND_PROFILE.VALUE into a local variable named l_debug. In the supplied source this variable is declared but never used for conditional output, and PRINT_DEBUG is effectively a no-op. Setting INV_DEBUG_TRACE therefore produces no trace output from this package. Developers seeking diagnostic detail for cost group assignment must instrument the private package or rely on other logging mechanisms.