Search Results val_pmt_reg_instr_accessible

Overview

IBY_FD_POST_PICP_PROGS_PVT is a private PL/SQL package in the Oracle Payments (IBY) module of Oracle E-Business Suite, declared with AUTHID CURRENT_USER. Its central business purpose is to support the extract, formatting, and delivery of Federal summary formats after an original bulk payment file has been produced. The package is registered with the application debugging framework under the module name iby.plsql.IBY_FD_POST_PICP_PROGS_PVT, allowing diagnostics to be captured through the standard IBY debug logging infrastructure. In ETRM the package is classified as an API of type PVT, meaning it is intended for internal consumption by other IBY components rather than direct invocation by end users or customer extensions. The header in the shipped source carries a revision reference consistent with the 12.1.1 code line, and the package remains present and documented in 12.2.2, where it is referenced by ten other packages.

Key Procedures and Functions

The ETRM metadata documents twenty-one procedures and functions. The principal entry point is PROCESS_FEDERAL_SUMMARY_FORMAT, which initiates extraction, formatting, and delivery of a Federal summary format. It requires that the summary format control number be stored in FV_SUMMARY_CONSOLIDATE, that treasury symbol and amount data be present in FV_TP_TS_AMT_DATA, and that the summary format code be a valid format defined in IBY. Standard FND parameters accompany inputs such as the payment instruction ID, the ECS periodic sequence number used to build the DOS file name field, and the summary format code.

Supporting procedures include RUN_POST_PI_PROGRAMS and POST_RESULTS for executing post-processing programs and recording their outcomes, and INSERT_TRANSMISSION_ERROR to log transmission failures into the payment transmission error tables. Status management is handled by SET_SRA_CREATED, SET_POS_PAY_CREATED, SET_REG_RPT_CREATED, and POST_FV_SUMMARY_FORMAT_STATUS. Retrieval functions include GET_INSTRUCTION_FORMAT and GET_ALLOW_MULTIPLE_SRA_FLAG. Access and eligibility checks are provided by VAL_INSTRUCTION_ACCESSIBLE, VAL_PMT_REG_INSTR_ACCESSIBLE, and VAL_PPR_ST_RPT_ACCESSIBLE. The procedure CHECK_PPR_MOAC_BLOCKING evaluates whether a payment process request is blocked from a MOAC perspective. Additional routines include RESET_PERIODIC_SEQUENCE_VALUE, SAVE_LAST_PERIODIC_SEQ_NUMS, SUBMIT_SCHEDULE, TEST_CP, SUBMIT_ACP_LTR, and RUN_ECE_FORMATTING.

Tables Accessed

The package works against configuration and transactional data through APPS synonyms. IBY_PAY_INSTRUCTIONS_ALL and IBY_PAYMENTS_ALL supply the payment instruction and payment records being processed, while IBY_PROCESS_ORGS and IBY_ACCT_PMT_PROFILES_B provide processing organization and account payment profile context. IBY_FORMATS_B holds format definitions resolved by the format code. IBY_DOCS_PAYABLE_ALL links documents payable to payments, and IBY_REMIT_ADVICE_SETUP controls remittance advice behavior. IBY_TRANSACTION_ERRORS and IBY_TRANSACTION_ERRORS_S receive transmission and processing error records. IBY_PAY_SERVICE_REQUESTS supports service request creation. FND_APPLICATION identifies application context, XDO_TEMPLATES_B provides formatting templates, and DUAL is used for scalar evaluation.

Usage Notes

Because this is a PVT package, it is not exposed through standard setup forms; it is invoked by IBY post-processing logic, by other IBY packages (ten documented references), and by concurrent programs that drive Federal summary format extraction and delivery. The presence of RUN_ECE_FORMATTING, SUBMIT_ACP_LTR, and SUBMIT_SCHEDULE indicates use from scheduled concurrent submission flows. Custom code should avoid calling these routines directly and instead rely on supported Payment Process Request or payment instruction APIs. The CHECK_PPR_MOAC_BLOCKING routine is of particular interest to administrators diagnosing payment process requests that cannot be released because of Multi-Org Access Control blocking conditions. Debug output is controlled through the iby.plsql.IBY_FD_POST_PICP_PROGS_PVT module in the FND debugging framework.