Search Results raise_error

Overview

ARP_NON_DB_PKG is a non-database utility package in the Oracle Receivables (AR) module of Oracle E-Business Suite. Its name and body content indicate that it performs validation and error-handling logic that does not directly read from or write to application tables. The package encapsulates the business rules governing natural application and creation sign behavior, which determine whether a payment, credit memo, or receipt can be applied to a transaction. In Release 12.1.1 and 12.2.2 the package remains part of the ARPLIB library used by the AutoInvoice, Lockbox, and manual receipt entry flows.

A private procedure, raise_error, is declared at the top of the body and is invoked whenever a validation routine returns a non-null message name. This private helper converts an internal message code into a user-facing error, allowing the public procedures to remain free of hard-coded error text. The header identifier $Header: ARXNODBB.pls 120.7 2005/10/30 confirms that the package is a long-standing member of the AR codebase and is compiled into the APPS schema.

Key Procedures and Functions

• CHECK_NATURAL_APPLICATION — The principal public routine. It evaluates the sign of the payment or credit against the sign of the transaction being applied, and returns an error condition when the application violates the natural-application rules. The multiple overload and wrapper declarations visible in the body show that it supports configurable flags such as Allow Overapplication, Natural Application Only, and Check Overapplication If Zero, and that it can operate in Lockbox context. It is the routine most closely associated with the raise_error search, because each of its validation failures is surfaced through that private procedure.
• CHECK_CREATION_SIGN — The second documented public procedure. As its name suggests, it validates the creation sign of the transaction type being processed, ensuring that the sign convention expected by Receivables matches the sign carried on the incoming record. Failure results in a raised error consistent with the natural-application checks.

The private raise_error procedure accepts a message code and is responsible for signaling the error to the calling layer; it is not exposed as a public API and therefore should not be called directly.

Tables Accessed

No base tables are referenced by the documented metadata for ARP_NON_DB_PKG. As the package name denotes, the module is intentionally non-database: it operates on the values passed in as scalar parameters and returns validation results rather than querying AR tables. Any descriptive information required for an error message is resolved through the flexible message framework rather than direct SQL against Receivables entities.

Usage Notes

• Invoked primarily by AutoInvoice, Lockbox, and manual receipt and credit-note entry when an application is created or validated.
• Called internally by six other APPS packages according to the ETRM metadata, making it a shared validation dependency rather than a standalone API.
• Debug output is controlled through the FND profile option AFLOG_ENABLED; when the profile is enabled, each entry, exit, and exception path writes to the AR debug log via ARP_STANDARD.DEBUG.
• Custom code should not call the private raise_error procedure directly. Customizations that need the same validation should call CHECK_NATURAL_APPLICATION or CHECK_CREATION_SIGN and honor the returned error rather than duplicating the error-raising logic.
• Because the package contains no DML, it is safe to invoke from read-only contexts and does not participate in transaction rollback or savepoint logic.