Search Results cleanup_atf

Overview

WMS_ITEM_LOAD is a Warehouse Management Systems (WMS) PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its primary business function is to support the loading of items into License Plate Numbers (LPNs) and containers within the warehouse execution flow. The package validates item availability against a specified LPN, performs pre-processing and processing of load transactions, and cleans up temporary staging data used during the material handling operation. It is classified under the ETRM API category OTHER, indicating it is an internal utility package rather than a public, versioned open interface API. The package is directly relevant to the search term "packunpack_container" because its procedures manage the loading (packing) of inventory items and serialized material into LPN containers and handle the supporting transaction and lot data.

Key Procedures and Functions

The ETRM metadata documents six procedures or functions within this package. Parameter lists are not enumerated in the documented metadata and are therefore described only by purpose:

• GET_AVAILABLE_QTY — Determines the quantity of an item available within a given LPN for a specified organization, inventory item, revision, and unit of measure. The excerpt from the source confirms parameters for organization, LPN, item, revision, primary UOM, and UOM, with outputs for available quantity and total quantity. This procedure underpins the validation logic when packing items into a container.
• GET_AVAILABLE_LOT_QTY — Retrieves the available quantity for a specific lot, extending the availability check to lot-controlled items so that packing operations respect lot-level on-hand balances.
• PRE_PROCESS_LOAD — Performs preparatory validation and staging steps before the actual load (pack) transaction is executed, ensuring that the item, LPN, and related data satisfy business rules.
• PROCESS_LOAD — Executes the core load transaction, moving item quantities into the target LPN container and writing the associated material transaction records.
• UNMARK_SERIALS — Reverses or clears the serial number marking associated with a load operation, allowing serialized items to be released from a container or corrected.
• CLEANUP_ATF — Removes residual staging or temporary data (associated with the Available-to-... / ATF staging area) once loading is complete, preventing orphaned rows in temporary tables.

Tables Accessed

The package reads and writes a range of WMS, INV, and WIP tables through APPS synonyms. Key tables include MTL_SYSTEM_ITEMS and MTL_PARAMETERS for item and organization validation; MTL_ITEM_LOCATIONS and WMS_LICENSE_PLATE_NUMBERS for container and locator context; MTL_MATERIAL_TRANSACTIONS_S, MTL_MATERIAL_TRANSACTIONS_TEMP, and RCV_TRANSACTIONS_INTERFACE for staging and recording the movement transactions; MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP, and WIP_LPN_COMPLETIONS_SERIALS for serial-controlled material handling; MTL_TRANSACTION_LOTS_TEMP for lot data; MTL_TXN_REQUEST_HEADERS and MTL_TXN_REQUEST_LINES for move order references; WMS_DISPATCHED_TASKS for warehouse task context; and FND_USER for user attribution. These tables support availability checks, transaction staging, and final commit of the load operation.

Usage Notes

WMS_ITEM_LOAD is referenced by zero other packages according to the documented metadata, indicating it is invoked directly rather than through a broader API chain. It is typically called from Oracle Warehouse Management mobile radio-frequency (RF) screens and related WMS forms where operators pack or unpack items into LPN containers, and it may also be invoked by custom code that replicates the standard packing workflow. Because the package writes to temporary and interface tables, calling code must manage commits, savepoints (a savepoint named get_available_qty_sp appears in the source), and cleanup, and should invoke CLEANUP_ATF on completion. Debug tracing is controlled through the INV_DEBUG_TRACE profile option, which routes messages through INV_MOBILE_HELPER_FUNCTIONS.TRACELOG when set to 1.