Search Results submit_delivery_line

Overview

APPS.INV_SHIPPING_TRANSACTION_PUB is a public PL/SQL API package in Oracle E-Business Suite that encapsulates the business logic governing shipping transactions in the Inventory module. The package body carries the header INVPWSHB.pls (version 120.15.12010000.2) and exposes a public interface for validating and submitting delivery-related shipping activity, including delivery line submission, ship method validation, return-to-stock, delay shipment, and reporting of missing quantities. It is classified as a PUB API, meaning it is intended for supported external invocation by other Oracle EBS modules and custom code, rather than as an internal helper. The package follows Oracle EBS API conventions, using FND_API global return status constants (g_ret_sts_success, g_ret_sts_error, G_RET_STS_UNEXP_ERROR) and the standard x_return_status, x_msg_count, x_msg_data output signature. A trace routine (DEBUG) controlled by the INV_DEBUG_TRACE profile option and by the internal G_Debug flag routes diagnostic messages through inv_trx_util_pub.trace. Inline branching logic references WMS, INV, and inv_release release-level globals (g_wms_current_release_level, g_inv_current_release_level, g_j_release_level), reflecting version-aware behavior across Warehouse Management and Inventory code levels.

Key Procedures and Functions

The package exposes 42 documented procedures and functions. Notable entries include SUBMIT_DELIVERY_LINE, which processes a delivery line for shipping transaction processing — the search term that led to this object. VALIDATE_SHIP_METHOD and GET_SHIPMETHOD_MEANING support transportation validation, with VALIDATE_SHIP_METHOD checking a ship method code against a delivery, including FTE (Freight Terms Engine) constraint group checks. GET_VALID_DELIVERY, GET_VALID_DELIVERY_VIA_LPN, and GET_VALID_DELIVERY_LINE retrieve and validate delivery and delivery line records; GET_DELIVERY_INFO, INV_DELIVERY_LINE_INFO, and GET_DELIVERY_LINE_SERIAL_INFO return descriptive delivery, line, and serial information. Serial validation is provided by SERIAL_AT_SALES_CHECK. Logistics lookups include GET_VALID_CARRIER, GET_SHIP_METHOD_LOV, GET_TRIP_NAME, GET_TRIP_LOV, and GET_DOCK_DOOR, while GET_ITEMS_IN_LPN returns items associated with a license plate number. Transactional procedures include INV_RETURN_TO_STOCK, INV_LINE_RETURN_TO_STOCK, INV_DELAY_SHIPMENT, and INV_REPORT_MISSING_QTY, covering reverse and exception shipping flows. Parameter lists are not reproduced here and should be confirmed against the ETRM signature listing.

Tables Accessed

Documented tables are referenced through APPS synonyms. Material and item data is drawn from MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV; transactional shipping activity is recorded in MTL_MATERIAL_TRANSACTIONS_S and WMS_SHIPPING_TRANSACTION_TEMP. Serial tracking uses MTL_SERIAL_NUMBERS_TEMP. Unit-of-measure conversions are handled by MTL_UOM_CLASS_CONVERSIONS, MTL_LOT_UOM_CLASS_CONVERSIONS, and MTL_TRANSACTION_TYPES. Inter-org and order context comes from MTL_INTERORG_PARAMETERS and OE_ORDER_LINES_ALL, with OE_SETS and PO_REQUISITION_LINES_ALL supporting set and sourcing references. Carrier and service validation uses WSH_CARRIERS and WSH_CARRIER_SERVICES, and license plate handling uses WMS_LICENSE_PLATE_NUMBERS.

Usage Notes

This package is typically invoked from Oracle Shipping Execution and Inventory forms, concurrent programs, and custom extensions that need to submit or validate delivery lines, query carrier or ship method values, or perform return-to-stock and delay-shipment actions. The package is referenced by four other packages, indicating it functions as a callable downstream dependency. Callers should invoke the procedures through the standard FND_API result contract, checking x_return_status for g_ret_sts_success or g_ret_sts_error and retrieving messages via x_msg_count and x_msg_data. Because the package performs version-aware branching against WMS and INV release levels, behavior may vary between EBS 12.1.1 and 12.2.2.