Search Results validate_transfer

Overview

GMIVXFR is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a supporting ("OTHER") API rather than a public interface. Its documented purpose is to contain the private code that backs the Transfers Inventory API — specifically the validation logic used when transferring inventory between organizations or subinventories. The package was originally authored in 1998 and carries a header history noting a major restructuring in May 2000 (Bug 1294915) undertaken for performance reasons, which is reflected in its version tag (115.5). In EBS 12.1.1 and 12.2.2, GMIVXFR remains an internal helper package: it is not intended to be called directly by end users or external integrations, but rather to be consumed by the higher-level inventory transfer APIs and the forms that drive them. It declares AUTHID CURRENT_USER, so its SQL executes with the privileges of the calling schema, a common convention for EBS private code that relies on APPS synonyms.

Key Procedures and Functions

ETRM documents a single procedure in this package:

• Validate_Transfer — The sole documented routine and the object users most often search for. It performs validation of a pending inventory transfer before it is committed. It accepts an API version and validation level, a transfer record type (GMIGAPI.xfer_rec_typ), and inbound rows from the master and child transfer, item, and lot tables; it returns the validated transfer master row along with the standard EBS API return status, message count, and message data outputs. The procedure follows the standard Oracle API error-stack convention, allowing callers to diagnose failures through FND_MSG_PUB. No other procedures or functions are exposed in the documented metadata.

Tables Accessed

The package reads the following tables through APPS synonyms, and the parameters of Validate_Transfer confirm their role as validation inputs:

• IC_XFER_MST — The transfer master table; validated and returned to the caller.
• IC_ITEM_MST — Item master information used to confirm the item is valid and transferable.
• IC_ITEM_CPG — Item-level organization/CPG attributes that govern transfer eligibility.
• IC_LOTS_MST — Lot master data, validating lot-controlled items.
• IC_LOTS_CPG — Lot-level organizational attributes that constrain the transfer.

These are read/validated against during the transfer check; the procedure is fundamentally an inbound validation routine rather than a data-modifying one.

Usage Notes

GMIVXFR is not documented as referenced by any other package in ETRM, indicating it is invoked from the Inventory transfer forms or from the public transfer API layer rather than from peer PL/SQL units tracked in the repository. Typical invocation points are the inter-org and subinventory transfer forms, where Validate_Transfer is called before the transfer is saved, and custom extensions that need to pre-validate a transfer record using the same rules as the seeded UI. Because the procedures are private and rely on GMIGAPI record types, custom code should treat this package as an internal dependency: it is safe to call Validate_Transfer when following the documented signature, but implementations should be aware that Oracle may alter private packages without public deprecation notice. When diagnosing errors, inspect x_return_status, x_msg_count, and x_msg_data and drain the message stack accordingly.