Results for “p_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AR_CONFIRMATION_ACTION is an Oracle E-Business Suite PL/SQL package, classified as an "OTHER" API, that belongs to the Receivables (AR) module. Its function is to handle the outcomes produced by the electronic invoice presentment and transmission process, commonly associated with the Oracle Receivables e-Invoicing / Confirmation feature that supports electronic invoice delivery to customers and trading partners. When transmission or import events occur, this package provides a standardized disposition routine for each distinct outcome — successful transmissions and a catalog of validation and data-integrity exceptions. Each procedure consumes a consistent set of arguments: a status, an identifier, a reason code, a description text, and a message identifier. The package thereby centralizes the mapping of transmission results and errors to persistent records and downstream processing. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than its owner, a design consistent with shared APPS schema utilities that rely on synonyms and invoker-rights resolution.

Key Procedures and Functions

The documented interface exposes 21 procedures, all following the same parameter convention (a status, an ID, a reason code, a description, and a message ID). They are organized into two logical groups.

• Success handling: SUCCESSFUL_TRANSMISSION records or processes the outcome of an invoice transmitted successfully.
• Import duplicates: DUPL_INV_NUM_IN_IMPORT, DUPLICATE_INVOICE_NUMBER, and DUPLICATE_LINE_NUMBER address duplicate invoice and line numbers encountered during import and transmission.
• Currency and supplier consistency: INCONSISTENT_CURR, INCONSISTENT_PO_SUPPLIER, INVALID_SUPPLIER, and INVALID_SUPPLIER_SITE handle mismatched currencies and supplier or supplier-site validation failures.
• Amount and quantity validation: INVALID_LINE_AMOUNT, INVALID_INVOICE_AMOUNT, INVALID_PRICE_QUANTITY, INVALID_QUANTITY, and INVALID_UNIT_PRICE cover pricing, quantity, and amount errors.
• Purchase order validation: INVALID_PO_INFO, INVALID_PO_NUM, INVALID_PO_RELEASE_INFO, INVALID_PO_RELEASE_NUM, INVALID_PO_SHIPMENT_NUM, and NO_PO_LINE_NUM address purchase order reference failures.
• Missing data: NO_SUPPLIER handles the absence of a supplier on the transaction.

Tables Accessed

The package references three tables through APPS synonyms, reflecting its role in the invoice lifecycle:

• AR_DOCUMENT_TRANSFERS — stores document transmission records, including status, reason codes, descriptions, and message identifiers, matching the procedure parameters.
• RA_CUSTOMER_TRX — the Receivables transactions header, providing the invoice context (currency, supplier, amounts) against which validation outcomes are recorded.
• RA_CUSTOMER_TRX_LINES — the transaction lines, supplying line-level data for amount, quantity, price, and line-number validation failures.

Usage Notes

AR_CONFIRMATION_ACTION is typically invoked indirectly by the Oracle Receivables confirmation and e-Invoicing infrastructure, such as the concurrent programs and Java/PLSQL transmission handlers that exchange invoice data with customers or partners. It is not ordinarily called from Oracle Forms; rather, it is driven by the invoice transmission workflow, where each invocation corresponds to a specific transmission or import result. Because each procedure carries a full diagnostic payload (status, ID, reason code, description, message ID), the package is well suited for updating status columns on AR_DOCUMENT_TRANSFERS and for communicating resolution information to downstream processing. The package is referenced by zero other documented packages, indicating it is an application-level entry point rather than a shared utility library. Custom code integrating with the invoice transmission process may call these procedures directly, but should mirror the same five-argument convention and be aware of the AUTHID CURRENT_USER execution model.