Search Results nested_serial_check

Overview

WMS_SHIPPING_TRANSACTION_PUB is the public PL/SQL API package for Oracle Warehouse Management (WMS) shipping transactions in Oracle EBS 12.1.1 and 12.2.2. It encapsulates the business logic used to validate, stage, and submit outbound shipping activity, bridging warehouse execution data (LPNs, staging lanes, dock doors, trips, and deliveries) with the execution tables that record material movement. The package header and body follow Oracle's API standards, returning status through the FND_API constants G_RET_STS_SUCCESS, G_RET_STS_ERROR, and G_RET_STS_UNEXP_ERROR, and using an internal g_debug flag driven by the INV_DEBUG_TRACE profile option to control diagnostic tracing through inv_trx_util_pub.trace.

The body declares the package version through a header string (120.50.12020000.6, last modified 2013/03/14) and uses a g_debug variable initialized lazily on first call. Utility functions such as check_last_del_trip illustrate the package's use of multi-table joins across WSH_TRIP_STOPS, WSH_DELIVERY_LEGS, and WSH_NEW_DELIVERIES to determine whether a delivery is the last on a trip, which affects whether a trip can be closed or confirmed.

Key Procedures and Functions

• IS_LOADED — Indicates whether a given delivery or LPN has been loaded, used to gate downstream shipping actions.
• GET_DOCK_DOORS — Returns valid dock doors for a warehouse organization.
• GET_DELIVERIES and GET_DELIVERY_NAME — Retrieve delivery records and their user-facing names for LOV display.
• GET_DELIVERY_INFO — Returns attribute details about a specific delivery.
• GET_STAGING_LANE — Returns the staging lane assigned to an inventory organization.
• GET_DELIVERY_DETAIL_ID — Resolves the delivery detail identifier for a given transaction.
• POPULATE_WSTT — Populates the WSH staging/delivery transaction temp structure used during shipping submission.
• GET_LPN_LOV — Provides the List of Values of LPNs available for selection.
• NESTED_SERIAL_CHECK — Validates nested serial number rules when an LPN contains child LPNs with serial-controlled items.
• LPN_DISCREPANCY_CHECK — Detects discrepancies between expected and actual LPN contents.
• CHECK_LPN_IN_SAME_TRIP and CHECK_LPN_DELIVERIES — Verify that LPNs are consistently assigned to the same trip and that their deliveries are compatible.
• LPN_SUBMIT — Submits LPN-based shipping transactions to the execution layer.
• CREATE_DELIVERY and GET_LPN_DELIVERY — Create and retrieve deliveries associated with LPNs.
• UPDATE_TRIP and UPDATE_DELIVERY — Update trip and delivery status attributes.
• MISSING_ITEM_CHECK and NONTRANSACTABLE_ITEM_CHECK — Validate that all expected items are present and that items are eligible for shipping transactions.

Tables Accessed

The package reads and writes a mix of warehouse, inventory, and order management tables through APPS synonyms. MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP store the temporary and permanent material transaction records generated during shipping. MTL_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP support serial-controlled item validation used by NESTED_SERIAL_CHECK. MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_KFV provide item attributes, while MTL_TRANSACTION_TYPES and MTL_TXN_REQUEST_LINES describe the movement being performed. OE_ORDER_LINES_ALL, OE_TRANSACTION_TYPES_TL, and OE_SETS link shipping execution back to order management for direct-ship scenarios. HZ_CUST_ACCOUNTS and HZ_PARTIES supply customer and ship-to party data, GL_DAILY_CONVERSION_TYPES provides currency conversion rates, and WMS_DIRECT_SHIP_TEMP stages direct-ship transactions prior to submission.

Usage Notes

WMS_SHIPPING_TRANSACTION_PUB is invoked from WMS shipping forms, concurrent programs, and custom extensions that need to validate or submit outbound shipments. The NESTED_SERIAL_CHECK routine in particular is called from the shipping transaction UI and mobile pages when an LPN hierarchy containing serialized items is confirmed, ensuring that nested serial numbers are unique and correctly associated. The package is referenced by six other packages, indicating its role as a foundational shipping validation layer. Custom code should call the public routines rather than manipulating the underlying tables, and should honor the FND_API return status conventions. Debug output can be enabled by setting INV_DEBUG_TRACE to 1, after which trace messages are written with the WMS_SHPTRX prefix.