Search Results c_error_msg_p

Overview

APPS.PA_PAXTRTRX_XMLP_PKG is a generated PL/SQL package body that supports an Oracle Projects XML Publisher (BI Publisher) report used to print and audit Project Accounting transaction interface data. The package follows the standard XML Publisher concurrent program architecture in Oracle E-Business Suite 12.1.1 and 12.2.2, in which a report-specific PL/SQL package supplies before-report and after-report logic, returns the SQL data set, and manages report-level parameters and error conditions.

The package operates against the Oracle Projects transaction import interface, reading the staging rows that hold unprocessed transaction data along with the interface control and implementation setup that governs the import. Its XML report output provides a printable review of interface records, typically including the interface identifier, source, transaction details, and status information, allowing users to validate interface contents before running the import.

Key Procedures and Functions

The package exposes eleven documented program units:

• BEFOREREPORT — the XML Publisher before-report trigger, executed by the concurrent manager prior to data retrieval. It performs initialization such as resolving the organization and ledger context, populating report-level profile values, and clearing prior error state.
• AFTERREPORT — the after-report trigger, used for cleanup and for setting the final completion status of the concurrent request.
• GET_COVER_PAGE_VALUES — assembles the values rendered on the report cover page, such as report title, run date, and parameter text.
• GET_COMPANY_NAME — returns the organization or company name derived from the implementation and ledger setup, used as report header data.
• C_COMPANY_NAME_HEADER_P — a lexical/report parameter constant supplying the company name header placeholder.
• C_NO_DATA_FOUND_P — parameter constant holding the message displayed when the query returns no interface rows.
• C_DUMMY_DATA_P — parameter constant used to drive the report's dummy or empty data set block.
• C_ERROR_CODE_P — parameter constant carrying the error code communicated back to the concurrent manager.
• C_ERROR_MSG_P — parameter constant carrying the error message text.
• SET_ERROR_STATUS — records a failure condition and the associated message so the request completes with an error.
• GET_ERROR_STATUS — retrieves the current error state, allowing the report logic and after-report trigger to react to prior failures.

Tables Accessed

The package reads and writes the following APPS-synonym tables:

• PA_INTERFACE_ID_S — the sequence that supplies interface identifiers for new staged transaction rows; in this report context it is referenced primarily for identifier resolution and sequence consistency.
• PA_TRANSACTION_INTERFACE — the primary staging table holding transactions awaiting import; the report selects these rows, including the interface identifier, for display.
• PA_MC_TXN_INTERFACE_ALL — the multi-currency transaction interface holding currency and conversion attributes associated with staged transactions.
• PA_TRANSACTION_SOURCES — provides the transaction source name and import configuration for each staged row.
• PA_TRANSACTION_XFACE_CONTROL — the interface control table governing import run parameters and batch grouping.
• PA_IMPLEMENTATIONS — supplies implementation and organization-level setup used for report header and context values.
• GL_SETS_OF_BOOKS — provides ledger name and currency for the reporting context.
• PA_LOOKUPS — resolves lookup-meaning text for coded columns.
• FND_CONCURRENT, FND_GLOBAL, FND_PROFILE — supply concurrent request identifiers, session context, and profile option values.

Imports of PA_TRX_IMPORT, PA_PAXTRTRX_XMLP_PKG, and DBMS_STANDARD provide supporting logic and standard PL/SQL constructs.

Usage Notes

The package is invoked exclusively by the XML Publisher concurrent program it is registered against; it is not designed as a callable API and is not referenced by any other database object. The keyword "pa_interface_id_s" corresponds to the PA_INTERFACE_ID_S sequence dependency and to report parameters that accept or constrain an interface identifier, allowing users to restrict the report to a single staged transaction. Because the object is a package body with no public specification intended for external use, customization should be limited to Oracle-supported extension points in the report definition rather than direct edits to the generated package, which may be overwritten during patching.