Search Results pa_paxcpcal_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PA_PAXCPCAL_XMLP_PKG is the generated PL/SQL package body that backs the Oracle Projects concurrent program commonly identified as the "PRC: Interface Assets" (PAXCPCAL) XML Publisher report. Its principal business purpose is to invoke the asset interface engine exposed by PA_FAXFACE, passing the operating unit, project number range, and DPIS (Date Placed In Service) through-date supplied at submission, and to surface the engine's return code and message buffer to the concurrent manager log so that request completion status reflects the outcome of the asset cost interface.

The package body carries a dated header ($Header: PAXCPCALB.pls 120.0 2008/01/02) consistent with Oracle EBS 12.1.1 and unchanged for 12.2.2. It is classified in ETRM as an OTHER API rather than a public interfaces API, meaning it is intended for internal use by the report definition and should not be called as a supported integration point.

Key Procedures and Functions

  • GET_COVER_PAGE_VALUES — Returns a BOOLEAN flag controlling whether cover-page values are populated for the XML Publisher output; traps errors and returns FALSE on failure.
  • BEFOREREPORT — The core logic of the package. It resolves the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, formats the DPIS through-date, retrieves the functional currency code, validates the company name, loads the NO_DATA_FOUND message text from PA_LOOKUPS, calls PA_FAXFACE.SET_REQUEST_ID and PA_FAXFACE.INTERFACE_ASSETS, and evaluates C_RETCODE. Non-zero return codes are treated as an error condition, and the returned error buffer is stored in C_ERROR_BUF. Storage errors, resource timeouts, and unexpected exceptions all collapse the return code to the sentinel value -9999.
  • GET_COMPANY_NAME — Resolves the organization name used in the report header from the implementation/operating unit context; a FALSE result raises the INIT_FAILURE exception in BEFOREREPORT and aborts processing.
  • AFTERREPORT — Standard XML Publisher after-report hook, performing post-processing such as releasing the SRW/FAXFACE context.
  • CF_FORMAT_MASKFORMULA — Formatting helper applied to the mask style element in the report layout.
  • C_COMPANY_NAME_HEADER_P, C_NO_DATA_FOUND_P, C_DUMMY_DATA_P, C_RETCODE_P, CURR_CODE_P, C_ERROR_BUF_P — Generated accessor functions returning the corresponding package-level globals: the company name header string, the localized "no data found" message, the dummy data placeholder, the interface return code, the functional currency code, and the error buffer text. These are the standard XMLP_PKG getters emitted by Oracle Reports-to-XML Publisher conversion.

Tables Accessed

The only documented table reference is PA_IMPLEMENTATIONS, accessed through APPS synonyms, to derive operating unit and company name information used in BEFOREREPORT and GET_COMPANY_NAME. Message text is additionally read from PA_LOOKUPS (LOOKUP_TYPE = 'MESSAGE', LOOKUP_CODE = 'NO_DATA_FOUND'), and the principal data movement occurs indirectly through the PA_FAXFACE.INTERFACE_ASSETS call, which writes to the asset interface tables rather than being performed by this package itself. No direct DML is documented against application tables in this package body.

Usage Notes

PA_PAXCPCAL_XMLP_PKG is invoked exclusively by the concurrent program definition for the asset interface report. It is not referenced by any other package, and external callers should invoke PA_FAXFACE.INTERFACE_ASSETS directly rather than this wrapper. When troubleshooting a user search for c_retcode, the value to inspect is C_RETCODE: zero (0) indicates the asset interface completed successfully, while any non-zero value indicates a failure, with -9999 denoting a trapped storage error, resource timeout, or unexpected exception. The accompanying C_ERROR_BUF holds the message text returned by PA_FAXFACE and is the primary diagnostic output to review in the concurrent request log. Note that SRW.USER_EXIT calls have been commented out in favor of native XML Publisher hooks, so no character-mode report output is produced.