Search Results ar_error_number

Overview

ARP_STANDARD is a foundational utility package body in the Oracle Receivables (AR) module of Oracle E-Business Suite. Despite its unassuming name, it is one of the most heavily depended-upon packages in the entire AR schema: the ETRM metadata records that it is referenced by 345 other database objects, while it references a wide array of AR and shared services packages. Its role is to provide low-level shared services — numeric rounding helpers, flag management, message resolution, period validation, and generic query execution — that higher-level Receivables programs call rather than reimplementing. In Oracle EBS 12.1.1 and 12.2.2 the package remains VALID under the APPS schema, and its API classification is listed as OTHER, reflecting its internal, non-public nature. It is not a documented public API and carries no Oracle-supplied signature documentation for external consumers.

Key Procedures and Functions

The ETRM metadata documents 60 procedures and functions. The most frequently used groups are:

• Numeric utilities: CEIL, EVEN, and ODD provide integer rounding and parity testing helpers used throughout Receivables calculations.
• Flag management: CHECK_FLAG, CLEAR_FLAG, and SET_FLAG implement a consistent way of testing and manipulating flag columns and profile-style indicators.
• Message handling: FND_MESSAGE, PREVIOUS_MESSAGE, and the MD_MSG_* family (MD_MSG_NUMBER, MD_MSG_TEXT, MD_MSG_NAME, MD_MSG_TOKENS, MD_MSG_EXPLANATION, MD_MSG_FIND_NUMBER) resolve and format Oracle error messages through the FND_MESSAGE and FND_NEW_MESSAGES infrastructure.
• General helpers: GET_NEXT_WORD (tokenising a delimited string), FUNCTIONAL_AMOUNT (currency/functional-amount conversion), AR_LOOKUP (quick lookup-value retrieval), and GL_DATE_RANGE_OPEN / GL_PERIOD_INFO / GL_PERIOD_NAME (General Ledger period validation and naming).

No parameter lists are documented for these routines; callers must rely on the shipped signature or on standard EBS conventions.

Tables Accessed

ARP_STANDARD reads the following tables via APPS synonyms: AR_SYSTEM_PARAMETERS and AR_VAT_TAX (Receivables system options and tax setup used by functional-amount and tax calculations); RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, and RA_CUST_TRX_TYPES (transaction headers, lines, and transaction types used during query and lookup processing); GL_PERIOD_STATUSES (to test whether an accounting period is open); and MO_GLOB_ORG_ACCESS_TMP (multi-org temporary table for organisation access). FND_NEW_MESSAGES is accessed to resolve message text. It also utilises DBMS_SQL, PLITBLM, and UTL_FILE for dynamic SQL, PL/SQL table management, and file handling respectively. The package is predominantly a reader of configuration and reference data; the writes it performs are incidental to callers' transactions.

Usage Notes

ARP_STANDARD is an internal support package and is not intended for direct customer invocation. It is normally executed indirectly — for example, AR forms and concurrent programs that need a period-open check, an amount rounded to the currency precision, or a message formatted for the user will call these helpers rather than coding them inline. Because 345 objects depend on it, changes to its body must be treated with extreme care during upgrades and patching. Custom code in Oracle EBS 12.1.1 or 12.2.2 should avoid calling undocumented routines inside ARP_STANDARD directly, since Oracle does not guarantee their signatures across releases; where equivalent public APIs or documented AR packages exist, those should be preferred. The package continues to resolve successfully in the ETRM listings for both 12.1.1 and 12.2.2, confirming its ongoing role as shared Receivables infrastructure.