Search Results validate_rcv_input

Overview

CSD_RECEIVE_UTIL is a utility package body in the Oracle E-Business Suite (EBS) Applications schema (APPS) that supports the receiving functionality within the Complex Maintenance, Repair, and Overhaul (CSD) module. Its primary business purpose is to provide reusable validation and helper routines for the receiving process, particularly when items are received against repair orders, internal orders, and standard purchase order receipts. The package encapsulates logic for determining whether an item is eligible for auto-receiving, validating the input parameters supplied to receiving APIs, and interpreting errors returned from the receiving interface tables. In the context of EBS 12.1.1 and 12.2.2, this package is part of the CSD (Service/Depot Repair) product family and is typically invoked by higher-level APIs such as CSD_RECEIVE_PVT.RECEIVE_ITEM and by the Logistics user interface.

Key Procedures and Functions

The package exposes five documented procedures and functions, each addressing a specific validation or lookup task:

• IS_AUTO_RCV_AVAILABLE — Determines whether a given inventory item is eligible for automatic receiving. It evaluates routing information, location control, and serial control attributes, and returns a routing header identifier. It is called from the Logistics UI and from CSD_RECEIVE_PVT.RECEIVE_ITEM.
• VALIDATE_RCV_INPUT — Validates the input parameters provided to the receiving process. This is the routine most commonly searched for as "validate_rcv_input." It performs pre-processing checks before a receipt is submitted, helping to ensure that required data is present and consistent.
• CHECK_RCV_ERRORS — Inspects errors generated during processing of the receiving interface tables. It is used to detect and surface failures that occur when receipt records are processed through the RCV interfaces.
• GET_EMPLOYEE_ID — Retrieves the employee identifier associated with a user or context, supporting attribution of receiving transactions to the appropriate personnel.
• GET_RCV_ITEM_PARAMS — Returns receiving-related item parameters, such as routing, inspection, and control attributes, used to drive the receiving logic.

Tables Accessed

The package reads from and writes to a range of EBS tables through APPS synonyms. It references MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B for item attribute and control information, MTL_ITEM_CATEGORIES for category assignments, MTL_SECONDARY_INVENTORIES and MTL_INTERORG_PARAMETERS for inventory organization and transfer configuration, and MTL_SERIAL_NUMBERS for serial-controlled item validation. Transactional receiving data is handled through RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE, and RCV_PARAMETERS, while PO_INTERFACE_ERRORS stores error information. OE_ORDER_LINES_ALL is referenced for order line context, and FND_USER supports user identification.

Usage Notes

CSD_RECEIVE_UTIL is an internal utility package rather than an end-user facing API. It is invoked indirectly through CSD_RECEIVE_PVT.RECEIVE_ITEM and the Logistics user interface, and is referenced by three other packages within the CSD module. Customizations and extensions that need to replicate or extend receiving validation logic may call these routines directly, but they should be aware that the package is not part of the public, supported API surface. The header comment ($Header: csdvrutb.pls 120.4.12000000.2 2007/04/24 ...) indicates the file has been stable since the 12.0 code line, and the same interface is expected to behave consistently across 12.1.1 and 12.2.2. Developers debugging receipt failures should examine CHECK_RCV_ERRORS and the RCV interface tables shown above.