Search Results c_nls_no_data_exists

Overview

AP_APXPTPTR_XMLP_PKG is a server-side PL/SQL package body owned by APPS in the Oracle E-Business Suite Payables module. Its name follows the standard Oracle Reports XML Publisher (XMLP) integration convention, indicating that it supports the report module APXPTPTR — the Payables "Terms Listing" report. In Oracle EBS 12.1.1 and 12.2.2, every Reports-to-XML-Publisher converted report has a corresponding generated package of the form <REPORT>_XMLP_PKG. This package encapsulates the data retrieval and formatting logic used to populate the report's layout template, acting as the runtime data source for the report definition.

The package is classified as OTHER within the API classification scheme and references the AP_SYSTEM_PARAMETERS table through an APPS synonym. It is not referenced by any other package, confirming that it is a leaf-level, report-specific object rather than a shared utility.

Key Procedures and Functions

The ETRM metadata documents twenty procedures and functions, most of which follow the naming convention used by Oracle Reports' XML Publisher integration to expose report parameters and layout values as IN OUT variables passed between the report and the PL/SQL package:

• GET_BASE_CURR_DATA — Queries AP_SYSTEM_PARAMETERS and FND_CURRENCIES_VL to populate the base currency code, precision, minimum accountable unit, and description into package-level variables.
• CUSTOM_INIT — A standard hook invoked before report execution; returns a boolean status.
• GET_COVER_PAGE_VALUES — Resolves values used on the report cover page.
• GET_NLS_STRINGS — Retrieves translated lookup meanings and displayed fields from FND_LOOKUPS and AP_LOOKUP_CODES for yes/no, "all", and term type labels, supporting multilingual output.
• BEFOREREPORT and AFTERREPORT — Standard report-level trigger entry points invoked at the start and end of report execution.
• GET_COMPANY_NAME — Fetches the operating unit or organization name for header display.
• C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_DESCRIPTION_P — Package globals exposing the base currency attributes populated by GET_BASE_CURR_DATA.
• C_COMPANY_NAME_HEADER_P — Stores the company name used in the report header.
• C_REPORT_START_DATE_P — Captures the report start date parameter.
• C_NLS_YES_P, C_NLS_NO_P, C_NLS_ALL_P, C_NLS_TERMTYPE_P, C_NLS_NO_DATA_EXISTS_P, C_NLS_END_OF_REPORT_P — Localized strings surfaced from the NLS lookups. C_NLS_NO_DATA_EXISTS_P is the translated "no data exists" message shown when the report query returns zero rows.
• C_CHART_OF_ACCOUNTS_ID_P — Holds the chart of accounts identifier used during report processing.

Tables Accessed

Only one table is documented as directly accessed: AP_SYSTEM_PARAMETERS via its APPS synonym. This table supplies the base_currency_code from the AP system setup, which the package joins to FND_CURRENCIES_VL to derive the currency precision, minimum accountable unit, and description. FND_LOOKUPS and AP_LOOKUP_CODES are also referenced in the GET_NLS_STRINGS source, providing localized lookup meanings.

Usage Notes

This package is invoked automatically by the XML Publisher report definition for APXPTPTR whenever the report is run from the Standard Report Submission (SRS) window or via the report's entry point in the Payables responsibility. It is not intended for direct invocation by custom code, and it is not referenced by other packages. When troubleshooting the c_nls_no_data_exists message, note that this value derives from a lookup of type YES_NO (lookup code 'N') in FND_LOOKUPS, translated per the session language. The package returns FALSE from its initialization functions if the surrounding query fails, which typically manifests as a report error rather than a localized message.