Search Results validate_pick_to_lpn

Overview

WMS_TASK_LOAD is a warehouse management execution package in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by APPS and classified as an OTHER API. It supports the Warehouse Management System (WMS) task execution flow that governs how warehouse operators load, merge, split, and confirm material handling tasks against License Plate Numbers (LPNs) and locators. The package body encapsulates the procedural logic used by the WMS task-loading client to resolve quantity conversions, validate pick-to-LPN eligibility, match loose or packed material, and persist transaction records used downstream by inventory transaction processing.

A defining characteristic of this package is its use of FND_API return-status constants (success, error, unexpected error) and a task-status model: pending (1), queued (2), dispatched (3), loaded (4), and active (9). These constants reflect the dispatch lifecycle that the package drives when a task is staged and later executed. Quantity tolerance handling is signaled through the SHORT and OVER exception constants, with rounding governed by a decimal-precision constant of five. Actions such as LOAD_SINGLE, LOAD_MULTIPLE, and SPLIT determine whether work is loaded for one or many containers. The header note (120.20.12010000.13, dated 2009) indicates that the current code line is shared across the 12.1.1 and 12.2.2 releases, with a documented fix (B4625329) that widened action constants to 80 characters.

Key Procedures and Functions

• VALIDATE_PICK_TO_LPN — the entry point the user searched for. It evaluates whether material can be picked to a specified LPN under current task configuration, returning a validation outcome consistent with the FND_API status model.
• TASK_LOAD — the primary loading routine that processes a task for staging and confirmation.
• TASK_MERGE_SPLIT — handles consolidation or division of task quantities across LPNs or locators.
• PROCESS_F2 — executes the secondary function-key workflow within the task-load interaction.
• LPN_MATCH and LOOSE_MATCH — matching routines for packed LPN contents versus loose material.
• CAN_PICKDROP and CHECK_PACK_LPN — pre-execution eligibility checks for pick/drop operations and packed LPNs.
• VALIDATE_SUB_LOC_STATUS — verifies subinventory/locator status before commitment.
• PROC_CONVERT_QTY_TO_SUGG_UOM — converts quantities to the suggested unit of measure to align task demands with stocking UOM.
• POPULATE_LOT_LOV — builds the lot list of values presented to the operator.
• INSERT_SERIAL — records serial numbers assigned during the load.
• CHECK_IF_LOT_IS_SUBSTITUTED and ITEM_LOT_DIVISIBLE_FLAG — evaluate lot substitution and divisibility rules that constrain partial loading.
• UPDATE_TREE_FLEX_LOT — maintains lot attribute flexfield data on the tree hierarchy.

Tables Accessed

The package reads and writes inventory core tables through APPS synonyms. On-hand and availability context is drawn from MTL_ONHAND_QUANTITIES_DETAIL and MTL_ITEM_LOCATIONS, with locator and subinventory attributes from MTL_SECONDARY_INVENTORIES. Item and lot definitions come from MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, MTL_LOT_NUMBERS, and MTL_TRANSACTION_LOTS_TEMP. Serial tracking uses MTL_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP. Reservation control relies on MTL_RESERVATIONS, while transaction persistence uses MTL_MATERIAL_TRANSACTIONS_S, MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_TRANSACTION_TYPES, and the temporary allocation table MTL_ALLOCATIONS_GTMP.

Usage Notes

WMS_TASK_LOAD is invoked from the WMS task execution forms and related mobile/desktop task clients, and is also callable from custom code that drives task loading. VALIDATE_PICK_TO_LPN is typically called before TASK_LOAD to confirm that a pick target LPN is valid. Because the package uses FND_API messaging, callers should read x_return_status, x_msg_count, and x_msg_data consistently. No other package references this one, so it functions as a top-level execution utility rather than shared infrastructure.