Search Results log_msg

Overview

OKL_PRB_UPGRADE_PVT is a private PL/SQL package body owned by APPS within the Oracle E-Business Suite Lease Management (OKL) module, part of the Enterprise Transaction Management (ETRM) family. Its principal business function is to support the Parallel Reamortization Batch (PRB) upgrade initiative, which performs transaction state upgrades on existing lease contracts — specifically ESG (Enterprise Service Group) lease Reamort contracts. The package orchestrates the identification of eligible contracts based on user-supplied criteria and launches parallel workers to process those contracts concurrently, thereby minimizing runtime for large contract populations that must be brought forward to a newer transactional model.

As a _PVT package, it is classified as private and is intended for internal use by the lease upgrade framework rather than as a public integration API. It is not referenced by any other documented package, indicating it functions as a top-level driver in the upgrade chain.

Key Procedures and Functions

• REAMORT_UPGRADE — Requests the transaction state upgrade of a single ESG Lease Reamort contract for a given worker. It logs its entry and exit points and delegates the actual upgrade work to EFF_DATED_RBK_UPGRADE, capturing the returned retcode for diagnostic logging.
• REAMORT_UPGRADE_CONC — Identifies eligible contracts for the ESG PRB Upgrade according to criteria supplied by the caller, then launches multiple parallel workers to process them. Documented parameters include Operating Unit (mandatory), Criteria Set (mandatory, [REAMORT]), and optional filters for Legal Entity, Contract Number, Product, and Start Date (low).
• EFF_DATED_RBK_UPGRADE — Performs the effective-dated rebooking upgrade operation. This procedure is invoked by REAMORT_UPGRADE and carries the core upgrade logic, accepting the standard concurrent-program errbuf/retcode pair along with the worker identifier.
• EFF_DATED_RBK_UPGRADE_CONC — The concurrent-program entry point for the effective-dated rebooking upgrade, providing the concurrent-manager wrapper around the effective-dated upgrade logic.

The package also contains two internal logging helpers. log_msg writes a message to a specified destination via FND_FILE.PUT_LINE; this is the routine referenced by the search term "log_msg" and is called throughout REAMORT_UPGRADE to trace progress. log_n_print_msg writes the same message to both the concurrent log and the concurrent output file.

Tables Accessed

The package and its downstream upgrade logic touch a broad set of lease and concurrent-management tables. Contract identification and header resolution rely on OKC_K_HEADERS_B, OKC_K_HEADERS_ALL_B, OKC_STATUSES_TL, and OKL_K_HEADERS. Product and accounting configuration are drawn from OKL_PRODUCTS and OKL_SYS_ACCT_OPTS_ALL. Parallel execution status is tracked through OKL_PARALLEL_PROCESSES and FND_CONCURRENT_REQUESTS. Working and staging data used during the upgrade are held in OKL_RBK_SELECTED_CONTRACT, OKL_STREAM_INTERFACES, OKL_STREAM_TRX_DATA, OKL_AE_TMPT_SETS_ALL, OKL_ST_GEN_TMPT_SETS_ALL, OKL_OPP_SEQ, and OKL_TRX_ASSETS.

Usage Notes

This package is typically invoked through a concurrent program that submits REAMORT_UPGRADE_CONC, which in turn fans out work to individual REAMORT_UPGRADE workers. The FND_FILE logging calls direct diagnostic output to the concurrent manager log and output files, so troubleshooting is performed by reviewing those files for "reamort_upgrade: Begin/End" and retcode messages. Because the package is private and not referenced by other documented APIs, customization should target the invoking concurrent program rather than the package directly, and any modification should preserve the errbuf/retcode contract expected by the concurrent manager.