Search Results ar_no_data_found




Overview
Explore in AI Chat

Overview

APPS.AR_ARXRWS_XMLP_PKG is the PL/SQL package body that supports the Oracle Receivables concurrent report program associated with the ARXRWS module (Receivables Statement of Account / print-related reporting, driven by the ARXRWS executable and XML Publisher template). The package is classified as OTHER in the ETRM metadata and contains the standard Oracle Reports server-side package structure: a BeforeReport trigger function and an AfterReport trigger function. Its primary business purpose is to initialize the reporting session, retrieve operating context (the ledger name), resolve the localized "No Data Found" message text, and then cleanly terminate the report execution environment. The package was authored under header revision ARXRWSB.pls 120.0 (2007/12/27), indicating a long-standing, low-volatility component within the Receivables reporting stack.

Key Procedures and Functions

  • BEFOREREPORT — Executed at the start of report execution. It captures the concurrent request identifier via FND_GLOBAL.conc_request_id, then queries the ledger name into the report placeholder p_company_name. It subsequently assigns the message AR_NO_DATA_FOUND (resolved through ARP_STANDARD.FND_MESSAGE) to the placeholder p_no_data_found. A local NO_DATA_FOUND exception handler overrides that placeholder with the literal string 'No Data Found', ensuring the report always has usable placeholder text even when no system parameters row exists. The function returns TRUE to allow the report to proceed.
  • AFTERREPORT — Executed when report processing completes. In the documented source it performs no substantive work (the traditional FND SRWEXIT user exit is commented out) and simply returns TRUE. It serves as the standard completion hook for the report lifecycle.

Both functions are declared without documented parameters, consistent with Oracle Reports PL/SQL trigger interfaces, which rely on package-level placeholders and globals rather than explicit argument lists. The metadata records only these two procedures/functions.

Tables Accessed

  • AR_SYSTEM_PARAMETERS — Referenced through an APPS synonym. The package joins AR_SYSTEM_PARAMETERS to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID to obtain the ledger (set of books) name, which is written to the p_company_name placeholder and printed on the report output. The AR_SYSTEM_PARAMETERS row supplies the current operating ledger for the Receivables application, making it the authoritative source for report-level company/ledger context.

No other application tables are documented as accessed by this package. The join target GL_SETS_OF_BOOKS appears in the source excerpt but is not listed in the ETRM table inventory, which records only AR_SYSTEM_PARAMETERS.

Usage Notes

This package is invoked implicitly by Oracle Reports during execution of the concurrent program built on the AR_ARXRWS report definition; the BeforeReport and AfterReport triggers fire automatically and are not called directly by user code. It is not referenced by any other documented package (0 dependents), indicating it is a leaf-level reporting unit rather than a shared library.

The user search term p_no_data_found corresponds directly to the package-level placeholder populated in BEFOREREPORT. This placeholder holds the localized message resolved by ARP_STANDARD.FND_MESSAGE for AR_NO_DATA_FOUND, with a fallback literal when the lookup raises NO_DATA_FOUND. Customizations that alter this message or the ledger query should be applied cautiously, since the package is a seeded (noship) Oracle deliverable; changes are typically made via a copy in a custom schema rather than direct modification. In 12.1.1 and 12.2.2, the package remains compatible, though 12.2.2 multi-org and ledger (GL_SETS_OF_BOOKS to LEDGER migration) considerations may affect the ledger name resolution logic depending on applied patches. The commented-out FND SRWINIT and SRWEXIT user exits reflect newer Reports/XML Publisher integration where these exits are no longer required.