Search Results unit_of

Overview

CSD_RECEIVE_PVT is a private PL/SQL package in the APPS schema that implements the receiving business logic for Oracle Enterprise Asset Management (eAM) and depot repair flows within Oracle E-Business Suite 12.1.1 and 12.2.2. The package is classified as a PVT (private) API, indicating that it is intended to be called internally by other CSD product packages rather than directly by external applications. Its primary responsibility is to populate the Oracle Receiving open interface tables and to invoke the standard receiving processor so that inbound customer-owned material—typically returned from the field or received against a depot repair work order—is recorded correctly in inventory.

The header comment dated 2008/10/30 (csdvrcvb.pls version 120.2.12010000.2) reflects the long-standing stability of this module. Global constants such as g_process_sts_pending ('PENDING'), g_rcpt_source_customer ('CUSTOMER'), and g_txn_type_new ('NEW') establish the default receiving context used throughout the package. Two helper routines, check_group_id and dump_receive_tbl, support validation and diagnostic logging, while log_error_stack centralizes error propagation to the FND message stack.

Key Procedures and Functions

ETRM documents four public program units in the package body:

• RECEIVE_ITEM — The principal entry point. It handles both direct and standard receives, populating the Receive open interface tables and then calling the receiving processor. It is invoked from CSDREPLN.pld on the Logistics tab.
• POPULATE_RCV_INTF_TBLS — Performs the row-level inserts into RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE, including serial and lot child records, before the processor is triggered.
• RCV_REQ_ONLINE — Executes the online receiving request, invoking the standard RCV interface processor in an interactive (online) mode rather than through a concurrent manager submission.
• DELETE_INTF_TBLS — Cleans up interface staging rows once processing succeeds or when a failed attempt must be rolled back, preventing orphaned interface data.

The global variable g_debug_level inherits from csd_gen_utility_pvt.g_debug_level, enabling conditional diagnostic output without interfering with normal production execution.

Tables Accessed

The package reads and writes the following APPS synonyms:

• RCV_HEADERS_INTERFACE, RCV_HEADERS_INTERFACE_S, RCV_TRANSACTIONS_INTERFACE, RCV_TRANSACTIONS_INTERFACE_S, and RCV_INTERFACE_GROUPS_S — staging of receipt header, transaction, and grouping data.
• MTL_MATERIAL_TRANSACTIONS_S, MTL_SERIAL_NUMBERS_INTERFACE, and MTL_TRANSACTION_LOTS_INTERFACE — serial and lot attribute capture.
• OE_ORDER_LINES_ALL — source order line reference for RMA-linked receipts.
• PO_INTERFACE_ERRORS and FND_NEW_MESSAGES — error staging and user-facing message delivery.
• DUAL and PLITBLM — utility and PL/SQL table support.

Usage Notes

CSD_RECEIVE_PVT is invoked indirectly by Oracle Depot Repair and eAM forms and by the CSDREPLN.pld library behind the Logistics tab. Two additional CSD packages reference it, reinforcing its role as a shared internal service. It is not exposed as a public API and should not be called from unrelated custom code. Because it directly stages rows in the RCV open interface tables, any invocation must respect the standard Receiving transaction manager processing cycle to avoid duplicate or orphaned interface records.