Search Results process_load

Overview

WMS_ITEM_LOAD is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, declared with AUTHID CURRENT_USER. It belongs to the Warehouse Management System (WMS) product family and supports inventory and license plate number (LPN) processing operations. The package header carries the revision identifier $Header: WMSTKILS.pls 120.1 2006/01/31 08:40:08 gayu noship $, indicating it was authored and maintained well before the 12.1.1 and 12.2.2 releases. In ETRM the object is classified under the generic API category OTHER, reflecting that its procedures are largely internal warehouse task utilities rather than a formally published public API.

The principal business function of WMS_ITEM_LOAD is to load, validate, and process item, lot, and serial information against LPNs and warehouse tasks. This includes quantity availability queries within an LPN, pre-processing of load transactions, execution of the load itself, serial number housekeeping, and cleanup of application temporary framework (ATF) records. The package therefore sits at the intersection of inventory transaction validation and warehouse execution support.

Key Procedures and Functions

The ETRM metadata documents six procedures or functions in this package:

• GET_AVAILABLE_QTY — Returns the available quantity for a given organization, LPN, inventory item, and revision combination. The quantity is returned in the UOM supplied by the caller. It also returns total quantity, added under bug 5000292, and uses the standard FND_API return status / message count / message data output convention.
• GET_AVAILABLE_LOT_QTY — Extends the availability query to lot-controlled items, accepting a lot number in addition to the LPN, item, and revision inputs, and returning available quantity in the requested UOM.
• PRE_PROCESS_LOAD — Performs pre-load validation and setup. The header comments describe the x_return_status convention of this API: fnd_api.g_ret_sts_success on success, g_ret_sts_error for expected errors, and g_ret_sts_unexp_error for unexpected errors, with corresponding message count and message data outputs.
• PROCESS_LOAD — The procedure referenced by the "process_load" search term. It performs the actual load processing for the item/LPN transaction, presumably invoking the validation performed by PRE_PROCESS_LOAD and committing the resulting inventory movement or warehouse task update.
• UNMARK_SERIALS — Reverses or clears serial number markings, likely in support of rollback or correction of serial-controlled load operations.
• CLEANUP_ATF — Removes residual records from the Application Temporary Framework (ATF) tables used to stage load data between procedures.

Tables Accessed

The documented tables accessed through APPS synonyms fall into several groups. Inventory item and parameter tables include MTL_SYSTEM_ITEMS and MTL_PARAMETERS, used to derive item attributes such as primary UOM, lot control, and serial control. LPN and warehouse execution tables include WMS_LICENSE_PLATE_NUMBERS, WMS_DISPATCHED_TASKS, and MTL_ITEM_LOCATIONS, which supply the LPN, task, and locator context. Transaction and interface tables include MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_TXN_REQUEST_HEADERS and MTL_TXN_REQUEST_LINES, and RCV_TRANSACTIONS_INTERFACE, reflecting movement and receipt processing. Serial number handling uses MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP, and WIP_LPN_COMPLETIONS_SERIALS. Lot staging uses MTL_TRANSACTION_LOTS_TEMP. Finally, FND_USER is referenced for user context.

Usage Notes

WMS_ITEM_LOAD is referenced by zero other packages per the ETRM metadata, meaning it is not a shared utility invoked across the application codebase. Its procedures are most likely called from WMS mobile or desktop forms, from warehouse execution concurrent programs, or from custom extensions that need to validate and process LPN-based item loads. Because the package is declared AUTHID CURRENT_USER, privileges are evaluated against the invoking user, so callers must have appropriate grants on the underlying inventory and WMS tables. Custom code invoking PROCESS_LOAD should always call PRE_PROCESS_LOAD first and inspect x_return_status, x_msg_count, and x_msg_data before proceeding, and should execute CLEANUP_ATF afterward to release staged ATF records.