Search Results explode_lpn

Overview

APPS.RCV_NORMALIZE_DATA_PKG is a receiving-related PL/SQL package body that supports the normalization and validation of interface data flowing into Oracle E-Business Suite Receiving. Its primary responsibility is to reconcile raw, pre-processed receiving records held in the interface tables before they are converted into final receiving transactions. The package manages error handling for staged interface rows and validates header records for orphan conditions, ensuring that incomplete or inconsistent data does not propagate into downstream receipt, delivery, and put-away processing. It participates in the RCV interface pipeline alongside the ROI pre-processor components and is typically invoked as part of a larger concurrent processing flow that moves rows from RCV_TRANSACTIONS_INTERFACE into RCV_TRANSACTIONS.

Key Procedures and Functions

• PROCESS_PENDING_ROWS — The single documented procedure in the package metadata. It drives processing over rows that remain in a PENDING state, coordinating the normalization and error-handling logic for the receiving interface. It is the public entry point through which the package performs its core work.
• handle_error (internal) — Sets processing_status_code to ERROR on a given RCV_TRANSACTIONS_INTERFACE row, stamps the row with the concurrent request identifier, and delegates granular updates to RCV_ROI_PREPROCESSOR.update_rti_error. It honors profile RCV_FAIL_IF_LINE_FAILS and behaves differently when the global fail-all flag (g_fail_all) is set, when an LPN group is present, or when a header/interface transaction must be targeted individually.
• check_orphan_rhi (internal) — Validates RCV_HEADERS_INTERFACE rows to detect orphaned header records, using a count against related transaction interface data to determine whether a header lacks corresponding detail rows.

The package references the global g_request_id, which is used to populate the processing_request_id column on interface rows so that errors can be traced back to the concurrent request that processed them.

Tables Accessed

• RCV_TRANSACTIONS_INTERFACE — The principal target table, updated to mark rows as ERROR and to record the processing request identifier.
• RCV_HEADERS_INTERFACE — Read and validated to detect orphaned header records.
• RCV_INTERFACE_GROUPS_S — Provides group-level context for interface processing.
• RCV_TRANSACTIONS — The final receiving transaction table, destination for successfully normalized data.
• PO_LINE_LOCATIONS_ALL — Supplies purchase order shipment/line-location details against which receipts are validated.
• WMS_LPN_CONTENTS_INTERFACE — Supports license plate number (LPN) content processing during normalization.
• DUAL — Used for scalar and control-value queries.

Usage Notes

This package is invoked within the Receiving open interface and ROI processing framework, generally through concurrent programs rather than directly from a form. The g_request_id global ties each error update to the specific concurrent request, and this value is populated with the current request context so that processing_request_id is meaningful for diagnostics. Because the package commits conditionally—only when g_multiple_groups is FALSE—callers must be aware of the transaction boundaries it manages. The package is not referenced by any other documented package, so custom extensions should treat it as an internal implementation component of the RCV interface flow and avoid direct modification; instead, integrations should rely on the standard open interface concurrent programs and the documented PROCESS_PENDING_ROWS entry point.