Search Results log_messages

Overview

OKS_RENCON_PVT is a private PL/SQL package body in the Oracle E-Business Suite Service Contracts (OKS) module that supports renewal processing and contract consolidation logic. The package name, "RENCON," reflects its role in the Renewal Contract Management (REN_CON) operation flow, a functional area within Service Contracts used to renew service contracts by transferring eligible source lines into a new or existing target operation. Working alongside the OKC (Contracts Core) operation infrastructure, this package evaluates whether lines are eligible for renewal, builds operation instances and operation lines, validates target contracts, and merges eligible lines into the renewed agreement.

Because it is a PVT (private) package, it is not part of the public API surface exposed to integrators; it is invoked internally by the Service Contracts renewal UI and by the concurrent programs that orchestrate renewal processing. It embeds the class operation retrieval for the REN_CON operation on the SERVICE class, caching the class operation identifier to avoid repeated lookups on each call, as noted in the header comment referencing bug fix 5981381. This caching improves performance during bulk renewal operations where many lines are processed in a single session.

Key Procedures and Functions

• GET_VALID_OPER_LINE_SOURCES — Returns the source operation lines that qualify for renewal processing, filtering to valid candidates.
• GET_VALID_LINE_SOURCES — Identifies valid contract line sources available for inclusion in a renewal.
• CREATE_OPERATION_INSTANCES — Creates operation instances representing the renewal action against the target contract.
• CREATE_OPERATION_LINES — Populates operation lines linking source lines to the target operation.
• FIND_OL_STATUS — Determines the processing status of an operation line.
• IS_VALID_TARGET — Validates whether a given contract is an acceptable renewal target.
• GET_PARENT_LINE_ID — Retrieves the parent line for a given line, supporting hierarchy traversal.
• GET_LRT_RULE — Obtains the renewal rule governing line eligibility.
• GET_LINE_DETAILS — Fetches line-level attributes needed for renewal processing.
• MERGE_ELIGIBLE_YN — Evaluates whether a source line is eligible for merge into the target operation.
• MERGE — Performs the merge of eligible source lines into the target operation.
• SUBMIT_CONC, SUBMIT_FORM_CONC, SUBMIT — Submit the renewal processing as a concurrent request, from either a form or a programmatic context.
• UPDATE_CONTRACT_AMOUNT — Recalculates and updates the contract amount following renewal merge.
• LOG_MESSAGES — Writes diagnostic, error, or informational messages to the logging repository during renewal processing. This is the routine users most often locate when troubleshooting renewal failures or reviewing trace output; it centralizes message emission so renewal operations produce consistent, reviewable output.

Tables Accessed

The package reads OKC_CLASS_OPERATIONS to resolve the REN_CON operation identifier, and works across the OKC operation infrastructure: OKC_OPERATION_INSTANCES and OKC_OPERATION_LINES hold the instantiated renewal operations and their line-level mappings, with OKC_STATUSES_B supplying status codes. Contract and line data come from OKC_K_HEADERS_ALL_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_PARTY_ROLES_B, OKS_K_HEADERS_B, and OKS_K_LINES_B. DBMS_TRANSACTION and PLITBLM are used for transaction control and PL/SQL table operations.

Usage Notes

OKS_RENCON_PVT is typically invoked indirectly rather than called directly by customers. It is triggered from the Service Contracts renewal forms and from the concurrent programs that execute renewal consolidations in the background, with SUBMIT_CONC and SUBMIT_FORM_CONC serving as the entry points for those two invocation modes. Because it is classified as a private package and is referenced by zero other packages, custom code should avoid calling it directly; supported extensions belong in the public OKS APIs. When diagnosing renewal issues in 12.1.1 or 12.2.2, examine the output produced by LOG_MESSAGES and the concurrent request log for the renewal program.