Results for “dm_reversal_amount_chk”

8 results




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

Overview

ARP_TRX_COMPLETE_CHK is a private Oracle Receivables package body in the APPS schema whose central purpose is to determine whether a transaction is eligible for completion. It functions as the validation gate that must be satisfied before a receivable is finalized, ensuring that accounting distributions and tax obligations are internally consistent. The package is classified under ETRM as "OTHER" and is referenced by six other packages, confirming its role as a shared internal utility rather than a user-facing API entry point. Its procedures are invoked during transaction completion processing to short-circuit incomplete or unbalanced transactions before they post to the general ledger.

Key Procedures and Functions

The documented procedures and functions total five, though the source excerpt and metadata present them under a combination of names. The principal routine is CHECK_TAX_AND_ACCOUNTING, which performs the substantive validation logic described in its in-line header. It verifies the existence and validity of account assignments or account sets, requiring that records exist for each transaction line, that all code combinations are valid, and that assignment amounts reconcile to line amounts. For account sets, the sum of percentages per line and account class must equal 100%. The procedure additionally enforces tax rules: where TAX_CALCULATION_FLAG is Yes, tax is required on every invoice line unless the line is a memo line not of type LINE; tax is likewise required where TAX_CALCULATION_FLAG is No but TAX_EXEMPT_FLAG is Require. DO_COMPLETION_CHECKING acts as the orchestrating entry point that drives the overall completion validation. DM_REVERSAL_AMOUNT_CHK validates reversal amounts, commonly applied to debit memo and credit memo processing. INIT performs one-time initialization, loading values such as the salesrep required flag, set of books identifier, base currency code, and source information from AR_SYSTEM_PARAMETERS and GL_SETS_OF_BOOKS, and initializing package-level cursors for account set checks. Parameter lists are not reproduced here.

Tables Accessed

The package reads and writes against standard Receivables and tax tables by way of APPS synonyms. RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES supply the transaction header and line data being validated. RA_CUST_TRX_LINE_GL_DIST holds the accounting distributions examined for amount reconciliation and code combination validity. RA_CUST_TRX_LINE_SALESREPS supports salesrep validation, tied to the salesrep required flag loaded in INIT. RA_CUST_TRX_TYPES and RA_TERMS provide transaction type and payment term context. AR_SYSTEM_PARAMETERS furnishes system-level defaults during initialization. AR_ADJUSTMENTS and AR_CASH_RECEIPTS are referenced for reversal and application-related checks. On the tax side, ZX_LINES, ZX_RATES_B, and ZX_FORMULA_B support tax determination and validation, while DBMS_SQL is used for dynamic SQL within the package.

Usage Notes

ARP_TRX_COMPLETE_CHK is invoked internally by the Receivables transaction completion workflow, including the Transactions form and completion-related concurrent processing, rather than being called directly by end users or custom integrations. Because its procedures are PRIVATE in scope, external parties should not call them directly; the package is consumed by the six packages that reference it. It depends on supporting utilities including arp_bal_util.get_commitment_balance, arp_ct_pkg.fetch_p, arp_non_db_pkg.check_creation_sign, arp_non_db_pkg.check_natural_application, arp_trx_global.profile_info.use_inv_acct_for_cm_flag, arp_trx_util.get_summary_trx_balances, arp_trx_validate.validate_trx_date, arp_util.debug, and arp_util.validate_and_default_gl_date. Debug output may be directed through arp_util.debug. Custom code requiring equivalent validation should prefer supported public APIs, as the private routines in this package are subject to change without notice.