Search Results default_locator

Overview

WSH_DEL_OI_CORE is an Oracle EBS shipping and order-intake utility package owned by APPS and classified as OTHER in the ETRM repository for 12.2.2. It provides the low-level validation, defaulting, and lookup services that Shipping Execution and Order Management use while processing pick slips, delivery lines, and shipping transactions. Rather than exposing a single public API, the body aggregates a family of helper procedures and functions that resolve item control attributes (lot, serial, revision, locator), validate subinventories and locators, confirm carriers, freight types, currencies, and units of measure, and shield callers from the underlying MTL and SO schema. The source header (WSHSDVAB.pls) shows the package was ported early in the 11i line and remained stable through 12.1.1 and 12.2.2. Because several procedures encapsulate business rules that would otherwise be duplicated across shipping forms, WSH_DEL_OI_CORE is referenced by three other packages and is commonly reached indirectly through the Shipping Execution UI.

Key Procedures and Functions

The package documents 23 procedures and functions. The order-intake group includes GET_ORDER_INFO, which returns the currency and order category for a given picking header, and PICKSLIP_CLOSED, a Boolean function that reports whether a pick slip header is no longer in OPEN status. Item attribute and control routines include GET_ITEM_CONTROL_CODES, GET_LOCATOR_CONTROLS, VALID_SUBINVENTORY, DEFAULT_SUBINVENTORY, VALID_LOT_NUMBER, VALID_REVISION, VALID_LOCATOR_ID, and DEFAULT_LOCATOR. The default_locator logic is the primary mechanism for deriving a locator value from item locator controls and item-level defaults when no explicit locator is supplied. Additional validators cover VALID_SERIAL_NUMBER, VALIDATE_CONTAINER_ID, AR_INTERFACED, VALID_FREIGHT_TYPE, VALID_CARRIER_CODE, VALIDATE_CURRENCY, VALIDATE_UOM, and VALIDATE_USER. Transaction-level operations include UPDATE_SHIPPING_ONLINE and SHIP_MULTI_ORG. Error handling consistently uses FND_MESSAGE and APP_EXCEPTION.Raise_Exception, with tokens identifying the calling package and the Oracle error, as shown in GET_ORDER_INFO and PICKSLIP_CLOSED.

Tables Accessed

The package reads and, in selected paths, writes through APPS synonyms. Order context is drawn from SO_HEADERS_ALL and SO_PICKING_HEADERS_ALL, while freight lookups use ORG_FREIGHT and SO_FREIGHT_CHARGE_TYPES. Inventory validation relies on MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, MTL_ITEM_LOC_DEFAULTS, MTL_ITEM_REVISIONS, MTL_ITEM_SUB_DEFAULTS, MTL_ITEM_SUB_INVENTORIES, MTL_SECONDARY_INVENTORIES, MTL_SECONDARY_LOCATORS, MTL_PARAMETERS, MTL_SERIAL_NUMBERS, and MTL_UNITS_OF_MEASURE. User validation references FND_USER.

Usage Notes

WSH_DEL_OI_CORE is typically invoked from Shipping Execution and Order Management forms, from concurrent programs that process pick slips and deliveries, and from custom PL/SQL that requires consistent defaulting of locator, subinventory, lot, serial, or revision values. Because it is classified OTHER, it is not a formally supported public API; customizations should treat it as an internal dependency, avoid direct calls where a supported WSH or INV API exists, and revalidate behavior after patching or upgrading between 12.1.1 and 12.2.2.