Search Results c_no_data_found

Overview

PA_PAXSMPRD_XMLP_PKG is the PL/SQL package body associated with an Oracle Projects XML Publisher (BI Publisher) report in Oracle E-Business Suite 12.1.1 and 12.2.2. "PAXSMPRD" is the report short name for a Projects sample report delivered in the APPS schema. The package implements the standard Oracle Reports XML Publisher integration contract: it exposes the BeforeReport, AfterReport, and cover-page placeholder functions that the report engine calls during report execution, and it maintains package-level global variables that are surfaced into the report layout as XML elements or lexical parameters. Its primary responsibilities are to initialize report state, resolve the company (ledger) name for the report header, and resolve localized message text for the "no data found" condition — which directly corresponds to the user search term c_no_data_found.

Key Procedures and Functions

• BEFOREREPORT — The main report initialization function, invoked by the Oracle Reports runtime before the data model query executes. It calls GET_COMPANY_NAME (raising init_failure if it returns FALSE), retrieves the NO_DATA_FOUND message meaning from PA_LOOKUPS into the global c_no_data_found, and invokes PA_ACCUM_UTILS.SET_CHECK_REPORTING_END_DATE with the report's period name parameter. It handles NO_DATA_FOUND by resetting c_no_data_found and setting c_dummy_data to 1 so the report still renders, while all other errors are converted to a generic application error.
• GET_COMPANY_NAME — Queries GL_SETS_OF_BOOKS joined to PA_IMPLEMENTATIONS to resolve the ledger name for the current implementation, assigning it to c_company_name_header for display on the cover page. Returns FALSE on any exception so the caller can abort gracefully.
• GET_COVER_PAGE_VALUES — A cover-page initialization function that returns TRUE under normal conditions and FALSE when an unexpected error occurs, allowing the report to suppress or blank cover-page elements.
• AFTERREPORT — Cleanup hook invoked after report completion; in this package it simply returns TRUE, as the SRWEXIT call is commented out.
• C_COMPANY_NAME_HEADER_P, C_NO_DATA_FOUND_P, C_DUMMY_DATA_P — Placeholder accessor functions that expose the package globals c_company_name_header, c_no_data_found, and c_dummy_data to the report layout. These correspond to the lexical parameters an XML Publisher template references.

Tables Accessed

The package reads PA_IMPLEMENTATIONS (via its APPS synonym) to obtain the set of books identifier used in the company name query, and implicitly joins GL_SETS_OF_BOOKS for the ledger name. It also selects from PA_LOOKUPS to retrieve the MESSAGE-type lookup meaning for lookup code NO_DATA_FOUND, which populates c_no_data_found. No inserts, updates, or deletes are documented; the package is read-only with respect to application data.

Usage Notes

This package is invoked exclusively by the Oracle Reports/XML Publisher runtime when the PAXSMPRD concurrent program is submitted; it is not called from Oracle Forms or by other PL/SQL packages (ETRM records zero dependent packages). Because c_no_data_found controls the message displayed when the extract returns no rows, users searching for that term are typically diagnosing an empty report: the value is sourced from the PA_LOOKUPS seeded meaning, and if the lookup row is missing, the NO_DATA_FOUND exception handler sets c_dummy_data := 1 to force a placeholder output. Any custom extension should preserve the BEFOREREPORT/AfterReport contract and avoid altering the package globals relied upon by the layout template.