Search Results validate_into_lpn

Overview

WMS_PUTAWAY_UTILS is a core Warehouse Management System (WMS) utility package in Oracle E-Business Suite that encapsulates the business logic governing the putaway process — the movement of received or manufactured material from a staging location to its final storage destination within a warehouse. The package body, delivered in source file WMSPUTLB.pls, exposes a set of wrapper APIs invoked primarily by the WMS Java-based putaway UI and mobile transactions. Beyond simple task execution, the package manages putaway groupings, LPN (License Plate Number) handling across Inventory, WIP, and Receiving contexts, Automatic Task Fulfillment (ATF) processing, cross-docking decisions, and material status validation. It also populates the global temporary table WMS_PUTAWAY_GROUP_TASKS_GTEMP to support grouped task consolidation logic.

The package originated in patchset 11510 and is maintained as part of the WMS module under the APPS schema. It is closely integrated with the WMS globals package, which supplies operation-type constants (load, drop, inspect, pack, crossdock) referenced throughout its procedures.

Key Procedures and Functions

• VALIDATE_INTO_LPN — Validates that a license plate number is eligible to receive material into it during putaway, confirming LPN context and status before content transfer. This is the object the user searched for and is a gatekeeper routine for LPN-based putaway operations.
• GET_SUBINVENTORY_TYPE — Returns the type designation of a subinventory, used to determine putaway rules applicable to the destination.
• CREATE_GROUPED_TASKS and REMOVE_TASKS_IN_GROUP — Build and maintain grouped putaway tasks, populating the global temporary table used for consolidation.
• LOAD_LPN, UNLOAD_TASK, DETACH_LOADED_LPNS, and CHECK_LPN_VALIDITY_WRAPPER — Manage the loading, unloading, and detachment of LPNs from putaway tasks, including validity checking.
• COMPLETE_PUTAWAY_WRAPPER, COMPLETE_ATF_LOAD, and ACTIVATE_PLAN_FOR_INSPECT — Drive completion of putaway and ATF plan lifecycle events (activate, abort, cancel).
• ATF_FOR_MANUAL_DROP, CLEANUP_ATF, and SUGGESTIONS_PUB_WRAPPER — Support ATF drop operations, plan cleanup, and putaway location suggestions.
• TRANSFER_CONTENTS, INSERT_RTI, and UPDATE_MO — Move LPN contents and update move order records reflecting the putaway.
• GET_CROSSDOCK_INFO — Retrieves cross-docking eligibility information.
• UPDATE_LOC_SUGGESTED_CAPACITY and VALIDATE_MATERIAL_STATUS — Maintain suggested location capacity and validate material status constraints.

Tables Accessed

The package references several inventory and warehouse tables through APPS synonyms. MTL_ITEM_LOCATIONS supports location capacity and suggestion logic; MTL_SECONDARY_INVENTORIES supplies subinventory data; MTL_SYSTEM_ITEMS and MTL_ITEM_REVISIONS provide item and revision validation; MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, and their interface/temp counterparts support lot and serial controlled material. Transactional writes flow through MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP. Organization and user context is drawn from HR_ORGANIZATION_INFORMATION, FND_USER, BOM_DEPARTMENTS, and MO_GLOB_ORG_ACCESS_TMP. FND_NEW_MESSAGES supplies runtime messaging.

Usage Notes

WMS_PUTAWAY_UTILS is not typically called directly by end users. Its procedures are invoked from the WMS putaway Java/HTML UI, mobile RF transactions, ATF concurrent processing, and by four other PL/SQL packages in the WMS stack. Customizations should call the wrapper procedures rather than the underlying logic, and must respect organization context and the WMS globals operation constants. Because the package writes to move orders and material transaction tables, it should be invoked within the standard putaway transactional flow to preserve data integrity.