Search Results c_exception_meaningformula




Overview
Explore in AI Chat

Overview

APPS.AR_ARZCARPO_XMLP_PKG is the server-side PL/SQL package body that supports the Oracle Receivables Automatic Receipts and Automatic Remittances Execution Report, a concurrent program driven by Oracle Reports (XML Publisher). The package encapsulates the report's data-binding and formatting logic, supplying values for the report's lexical parameters and formula columns at runtime. It is classified in ETRM as an "OTHER" API, reflecting that it is an internal report-support package rather than a published integration interface. The header comment ($Header: ARZCARPOB.pls 120.0 2007/12/27) confirms the package has been stable since the late 11i/12.0 era and remains in use in Oracle EBS 12.1.1 and 12.2.2 without functional change beyond environment recompilation.

The package derives its behavior from the arguments passed into the concurrent request by the concurrent program definition. It distinguishes between receipt processing and remittance processing, and formats report titles and subtitles to reflect the user's requested execution options (creation, approval, and formatting).

Key Procedures and Functions

  • REPORT_NAMEFORMULA — Derives the report's main title. It evaluates the process type argument and assigns either the Automatic Receipts Execution Report or Automatic Remittances Execution Report title into the package-level RP_REPORT_NAME variable, then returns that value to the report layout.
  • BEFOREREPORT — Executes before the report body. It captures the concurrent request identifier via FND_GLOBAL.CONC_REQUEST_ID, parses the concatenated ARGUMENT1 through ARGUMENT6 values from FND_CONCURRENT_REQUESTS into the internal parameters P_PROCESS_TYPE, P_BATCH_ID, P_CREATE_FLAG, P_APPROVE_FLAG, P_FORMAT_FLAG, and P_REQUEST_ID_MAIN. It retrieves the batch name from AR_BATCHES, sets the P_CREATE_ONLY_FLAG indicator, and resolves the localized "No Data Found" message.
  • SUB_TITLEFORMULA — Builds the report subtitle from the create, approve, and format flags. If creation only is requested it emits "For Creation"; approval appends "/Approval"; the resulting RP_SUB_TITLE string conveys the exact processing mode to the reader.
  • AFTERREPORT — Performs post-processing cleanup at the end of report execution.
  • C_EXCEPTION_MEANINGFORMULA — Resolves the exception meaning text presented on the report output.
  • CF_1FORMULA — A report formula column used to compute a derived display value within the layout.
  • DESNAMEVALIDTRIGGER — A validation trigger associated with the destination/description name field of the report parameter form.
  • RP_REPORT_NAME_P, RP_DATA_FOUND_P, RP_SUB_TITLE_P — Accessor functions that return the package-level report name, data-found indicator, and subtitle values respectively, allowing the report layout to reference these derived values safely.

Tables Accessed

The package reads two documented tables through APPS synonyms. FND_CONCURRENT_REQUESTS is queried for the current concurrent request, providing the concatenated ARGUMENT1 through ARGUMENT6 strings that the package decomposes into its runtime parameters. AR_BATCHES is queried by BATCH_ID to retrieve the batch name displayed in the report header. No writes to persistent application tables are documented; processing is confined to deriving report presentation values.

Usage Notes

This package is not intended for direct invocation by custom code. It is registered as the PL/SQL body behind the AR_ARZCARPO_XMLP concurrent program's report definition and is executed automatically by the Oracle Reports runtime whenever that program is submitted from the Receivables batch execution window or the Standard Request Submission interface. Report metadata is also referenced by zero other packages, confirming its narrow, self-contained role. Developers troubleshooting report titles, subtitles, or "No Data Found" behavior should inspect the parameter arguments supplied to the concurrent program, since all conditioning in this package flows from those values.