Search Results confirm_receipt

Overview

CSP_MO_MTLTXNS_UTIL is an Oracle EBS utility package owned by APPS that handles material transactions associated with move orders. It is classified as a UTIL API within ETRM 12.2.2 and traces its origin to the 11i codebase, as indicated by the header revision string dated 26-Nov-2002. The package is primarily used by the Order Management and shipping execution flows, where move orders are generated to replenish, stage, or transfer material between subinventories and locators.

The package acts as a central coordinator for the transaction-level processing of move order lines: validating line status, updating statuses, and confirming receipts. It encapsulates the logic necessary to translate a move order line or packlist line into the appropriate inventory material transaction, including serial and lot handling, unit-of-measure conversion, and receipt quantity validation.

Key Procedures and Functions

• MOVE_ORDER_LINES_TXN — Accepts a move order line identifier and invokes the appropriate material transaction API to process the movement. This is the principal driver for executing a move order line transaction.
• UPDATE_ORDER_LINE_STATUS — Updates the status of a move order line after a transaction or status change, using the standard API message-list and commit conventions.
• VALIDATE_MO_LINE_STATUS — Function that validates a move order line status against an expected status, returning a status indicator to the caller.
• CONFIRM_RECEIPT — Confirms receipt of material against a packlist line. It accepts the packlist line, organization, transaction temporary ID, received quantity, destination subinventory, locator, and serial number, and processes the receipt into inventory.
• TRANSACT_SERIAL_LOTS — Processes serial-number and lot-controlled material, populating the serial number and lot temporary tables prior to the material transaction.
• CONVERT_TEMP_UOM — Converts quantities held in the transaction temporary table to the inventory primary unit of measure.
• CLEAN_UP — Removes residual rows from temporary structures once transaction processing is complete.
• GET_CSP_ACCCOUNT_ID — Retrieves the CSP account identifier used in the accounting or transaction context.
• UNDER_OVER_RECEIPT — Handles tolerance logic for receipts that are under or over the expected quantity.
• CALL_ONLINE — Invokes the online processing path for material transactions, typically used when the transaction must be performed synchronously.

Tables Accessed

The package reads and writes several CSP move order and packlist tables: CSP_MOVEORDER_LINES, CSP_PACKLIST_HEADERS, CSP_PACKLIST_LINES, and CSP_PACKLIST_SERIAL_LOTS. Inventory base tables referenced through APPS synonyms include MTL_MATERIAL_TRANSACTIONS and its _S and _TEMP variants, which record and stage the resulting inventory transactions; MTL_SERIAL_NUMBERS_TEMP and MTL_LOT_NUMBERS, which hold serial and lot data during processing; MTL_SECONDARY_INVENTORIES, MTL_ITEM_LOCATIONS, MTL_ITEM_LOC_DEFAULTS, and MTL_ITEM_SUB_INVENTORIES, which provide subinventory and locator validation and defaults; MTL_PARAMETERS for organization-level inventory setup; and MTL_GENERIC_DISPOSITIONS for transaction disposition handling.

Usage Notes

CSP_MO_MTLTXNS_UTIL is invoked from Oracle Shipping Execution and Order Management forms and concurrent programs that process move orders and packlist receipts. It is documented as being referenced by two other packages, indicating that it is a shared utility layer rather than a top-level entry point. In custom code, it should be called with the standard API conventions: pass the API version number and initialization flags, set P_Commit to control transaction scope, and check X_Return_Status, X_Msg_Count, and X_Msg_Data for error handling. The package is not intended for direct end-user invocation; callers should respect the validation level parameter and rely on the package to manage temporary table cleanup.