Search Results get_fobloc_code_meaning
Overview
APPS.WMS_DIRECT_SHIP_PVT is a private PL/SQL package within the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite. It encapsulates the server-side business logic that supports direct-ship fulfilment, trip and trip-stop management, delivery confirmation, and shipping-document generation. The package is declared with AUTHID CURRENT_USER, indicating that its dynamic SQL and unqualified references resolve under the privileges of the invoking session rather than the package owner, which is the customary pattern for private WMS APIs invoked from forms, concurrent programs, and other WMS packages.
The package is classified as a Private (PVT) API in the ETRM 12.2.2 metadata, meaning it is not a formally published public interface. It is referenced by three other packages and is not intended for direct customer invocation without risk, though it is commonly reached indirectly through standard WMS shipping and direct-ship flows. The version header (120.3.12020000.5, dated 2013/03/13) confirms applicability across both 12.1.1 and 12.2.2 code lines.
Key Procedures and Functions
ETRM documents 47 procedures and functions in this package. The principal documented entries include:
- DEBUG — internal diagnostic logging utility accepting a message, module, and level.
- GET_TRIPSTOP_INFO and GET_DELIVERY_INFO — return ref-cursor result sets for trip-stop and delivery detail retrieval; the delivery variant passes org context to correctly evaluate Enforce Ship Method.
- GET_DELIVERY_LPN — returns the LPN associated with a delivery.
- CHECK_DIRECT_SHIP_FOR_LPN — boolean test determining whether an LPN is direct-ship eligible.
- GET_SHIPMETHOD_MEANING, GET_FOBLOC_CODE_MEANING, GET_FOB_LOCATION, GET_FREIGHT_TERM — lookup functions translating codes and IDs into descriptive values.
- GET_BOL — retrieves the bill-of-lading number for a delivery.
- GET_ENFORCE_SHIP — returns the enforce-ship indicator.
- CHECK_DELIVERY and UPDATE_DELIVERY — validate and persist delivery attributes such as weights, waybill, ship method, FOB, and freight terms.
- MISSING_ITEM_CUR, SHIP_CONFIRM, CONFIRM_ALL_DELIVERIES — support short-shipment detection and shipping confirmation across one or all deliveries.
- CREATE_TRIP, UPDATE_TRIPSTOP, CLOSE_TRIP, UNLOAD_TRUCK — manage the trip lifecycle from creation through stop updates, closure, and truck unloading.
- PRINT_SHIPPING_DOCUMENT — the procedure directly relevant to the search term print_shipping_document; it drives generation of the shipping documentation associated with a delivery or trip, typically by orchestrating the standard WMS shipping-paperwork concurrent request or report output.
Tables Accessed
The package reads and writes a defined set of WMS/inventory tables through APPS synonyms, including MTL_ITEM_LOCATIONS, MTL_LOT_NUMBERS, MTL_LOT_UOM_CLASS_CONVERSIONS, MTL_MATERIAL_TRANSACTIONS_S, MTL_RESERVATIONS, MTL_SECONDARY_INVENTORIES, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP, MTL_SYSTEM_ITEMS and its _B and _KFV variants, MTL_TRANSACTION_TYPES, OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and PJM_ORG_PARAMETERS. Inventory tables supply item, lot, serial, locator, and reservation data required to validate and confirm shipments, while the order and project-parameter tables provide order and organizational context.
Usage Notes
This private package is normally invoked indirectly from WMS shipping forms, the direct-ship processing flows, and concurrent programs such as shipping-document print and delivery-confirmation requests. Custom code should call the public WMS APIs wherever possible; direct calls to WMS_DIRECT_SHIP_PVT require careful handling of the ref-cursor OUT parameters and the standard x_return_status / x_msg_count / x_msg_data error stack. Because the package resolves objects under the caller's privileges, execution should occur within a session that has APPS-level access.