Search Results validate_reverse_info

Overview

APPS.AR_RECEIPT_VAL_PVT is a private (PVT) PL/SQL validation package within the Oracle Receivables module of Oracle E-Business Suite. As its name indicates, the package centralizes the server-side validation logic that governs receipt entry, receipt application, unapplication, reversal, and miscellaneous receipt processing. It is not a public API intended for direct invocation by external integrators; rather, it is an internal validation layer consumed by the Receipts forms, the AutoLockbox and post-batch processing routines, and other Receivables packages.

The package header carries a header revision of 120.14.12010000.2 (dated 2008/11/14), reflecting the code line maintained through the 12.1.1 and 12.2.2 releases. A significant portion of its modification history relates to the Consolidate Bank Accounts project, in which references to AP_BANK_BRANCHES were migrated to CE_BANK_BRANCHES_V, internal bank account references moved from AP_BANK_ACCOUNTS to CE_BANK_ACCT_USES, and local identifiers holding REMITTANCE_BANK_ACCOUNT_ID were renamed to REMIT_BANK_ACCT_USE_ID. Earlier bug fixes (2270825, 2751910) added parameters for claims validation and introduced VALIDATE_OPEN_RECEIPT_INFO. These changes confirm the package's role as a long-lived, actively maintained validation component.

Key Procedures and Functions

The ETRM metadata documents seventeen procedures within the package. VALIDATE_CASH_RECEIPT performs the core validation of a receipt record prior to insertion or update. VALIDATE_APPLICATION_INFO, VALIDATE_UNAPP_INFO, VALIDATE_ON_AC_APP, VALIDATE_UNAPP_ON_AC_ACT_INFO, VALIDATE_ACTIVITY_APP, VALIDATE_APPLICATION_REF, VALIDATE_UNAPP_OPEN_RECEIPT, and VALIDATE_CLAIM_UNAPPLY govern the application and unapplication of receipts against transactions, including on-account and claim scenarios. VALIDATE_REVERSE_INFO and CHECK_STD_REVERSIBLE control receipt reversal eligibility.

VALIDATE_MISC_RECEIPT validates miscellaneous receipt entries, while VALIDATE_PAYMENT_TYPE verifies the receipt method and payment classification. VALIDATE_OPEN_RECEIPT_INFO checks unapplied and unidentified open receipt conditions. VALIDATE_PREPAY_AMOUNT validates the amount applied against prepayment records, ensuring the requested amount does not exceed what is available on the referenced prepayment. VALIDATE_LLCA_INSERT_AD and VALIDATE_LLCA_INSERT_APP support low-level cash application (LLCA) insert scenarios for adjustments and applications. Each procedure raises application errors or returns status indicators consumed by the calling form or batch process; parameter lists are not reproduced here.

Tables Accessed

The package reads and validates against AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, AR_RECEIPT_METHOD_ACCOUNTS, AR_PAYMENT_SCHEDULES, AR_ADJUSTMENTS, AR_ACTIVITY_DETAILS, AR_APPROVAL_USER_LIMITS, and AR_BATCHES. Bank and customer reference data are drawn from CE_BANK_ACCOUNTS and HZ_CUST_SITE_USES. Payment instrument data comes from AP_CHECKS. AR_INVOICE_SELECTION_CRITERIA supports application-matching rules, and AR_LLCA_TRX_LINES_GT is the global temporary table used during low-level cash application. These accesses confirm the package's function: verifying that receipt, application, reversal, and adjustment data conform to Receivables business rules before persistence.

Usage Notes

AR_RECEIPT_VAL_PVT is invoked internally by the Receipts and Receipt Application forms, by AutoLockbox and automatic receipt application programs, and by three other documented packages within the Receivables code line. Because it is classified as PVT, Oracle does not guarantee its interface across patches or upgrades, and custom code should not call it directly. Integrators requiring receipt validation should use the public Receipt API (AR_RECEIPT_API_PUB) or the documented open interfaces rather than this private validation layer.