Search Results lease_loan_termination




Overview
Explore in AI Chat

Overview

OKL_AM_LEASE_LOAN_TRMNT_PUB is a public PL/SQL package body in the Oracle EBS Lease Management (OKL) application, part of the Enterprise Contracts and Lease Management module. It governs the termination of lease and loan contracts within Oracle Lease and Loan Management. The package exposes a supported, public API (API classification PUB) that allows both standard EBS functionality and external/custom callers to validate contracts prior to termination and to execute the lease/loan termination transaction. Its header records a revision date of 2007, indicating the interface has been stable across the 12.1.1 and 12.2.2 releases. Logging infrastructure is embedded through OKL_DEBUG_PUB and FND_LOG, with constants at PROCEDURE, EXCEPTION, and STATEMENT levels and a module namespace prefix of "okl.am.plsql.okl_am_lease_loan_trmnt_pub." that enables fine-grained debugging.

Key Procedures and Functions

  • VALIDATE_CONTRACT — Confirms that a given contract is eligible for termination. It accepts an API version, an initialization message-list flag, a contract identifier, and a control flag, and returns a status indicator together with the standard return status, message count, and message data outputs. It initializes a savepoint (trx_validate_contract), evaluates logging flags, and writes debug messages for input parameters at the appropriate log levels. The procedure establishes the termination context and surfaces validation errors through the OKL API messaging convention.
  • LEASE_LOAN_TERMINATION — Performs the actual lease or loan termination once validation succeeds, processing the contract identified by the caller and returning status information consistent with Oracle's public API pattern. It is the transactional entry point that downstream business logic and concurrent processes invoke to close out a lease or loan.

Both procedures follow the standard Oracle public API signature and messaging conventions (x_return_status, x_msg_count, x_msg_data), and both are instrumented for logging.

Tables Accessed

The documented table reference for this package is PLITBLM (through the APPS synonym layer). PLITBLM is the Lease/Payment Invoice Line Table that stores invoice line detail associated with lease and loan contracts. The package reads this table during validation and termination to determine the financial lines attached to the contract being terminated, ensuring that invoicing and accounting implications of the termination are properly evaluated.

Usage Notes

OKL_AM_LEASE_LOAN_TRMNT_PUB is typically invoked from the Oracle Lease Management termination forms, from concurrent programs that automate end-of-term or early-termination processing, and from custom client code that requires programmatic termination of leases or loans. Because it is a classified PUB API, it is the sanctioned integration surface and should be preferred over direct table manipulation. Callers must supply a valid API version and initialize the message list as required by EBS standards, then inspect x_return_status and x_msg_data for errors. The package is referenced by nine other packages, confirming its role as a shared termination service. Debug tracing can be enabled per module using OKL_DEBUG_PUB.Check_Log_On, allowing support teams to capture procedure, statement, and exception level diagnostics during termination troubleshooting.