Search Results termination_interface

Overview

The APPS.OKL_AM_TERMNT_INTERFACE_PUB package is the public API wrapper within the Oracle Lease and Finance Management (OKL) module responsible for processing contract termination interfaces in Oracle E-Business Suite 12.1.1 and 12.2.2. The package name follows the EBS naming convention in which OKL denotes the leasing application, AM denotes the Asset Management sub-module, and TERMNT_INTERFACE identifies the termination interface business process. The _PUB suffix indicates that this is a public, externally callable package intended to be invoked by forms, concurrent programs, or external integration code, as opposed to the corresponding _PVT package that holds the substantive business logic.

The package serves as a thin delegating layer. It exposes a single public entry point that accepts error and return-code output parameters, forwards control to the private implementation OKL_AM_TERMNT_INTERFACE_PVT, and then normalizes the outcome using the standard OKC_API error-handling framework. This pattern ensures that callers receive consistent return statuses and messages irrespective of the internal failure mode.

Key Procedures and Functions

The documented interface exposes one public procedure:

• TERMINATION_INTERFACE — The sole public entry point for the termination interface process. It declares output parameters for an error buffer (err_buf) and a numeric return code (ret_code). Internally it invokes OKL_AM_TERMNT_INTERFACE_PVT.termination_interface, passing an API version constant, an initialization flag (OKC_API.G_TRUE), and receiving message data, message count, and return status. Based on the returned status, it raises the appropriate standard exception: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR for unexpected errors or OKC_API.G_EXCEPTION_ERROR for standard errors. Exception handlers then call OKC_API.HANDLE_EXCEPTIONS to populate the message stack, and an OTHERS handler uses OKC_API.set_message to record SQLCODE and SQLERRM tokens before allowing the procedure to terminate.

Tables Accessed

The ETRM metadata excerpt for this package body does not document any direct table references through APPS synonyms. This is consistent with the package's architecture: it is a pure delegation and error-handling wrapper that performs no SQL of its own. All data manipulation associated with the termination interface is performed downstream by OKL_AM_TERMNT_INTERFACE_PVT, which is where the relevant OKL termination staging and transaction tables are read and written. Consequently, no table-level detail can be attributed to the public package itself from the supplied metadata.

Usage Notes

This package is typically invoked when an external process or user action needs to initiate the termination interface for lease contracts — for example, from the lease termination form, a concurrent program that processes inbound termination data, or custom integration code performing bulk contract terminations. Because the procedure uses output parameters for err_buf and ret_code rather than a function return, callers must inspect both values after invocation and also monitor the OKC_API message stack for accumulated errors.

The metadata confirms this package is referenced by zero other packages, underscoring its role as a top-level public entry point rather than a shared internal utility. The header timestamp (115.3, dated 2003) indicates the package has been stable across releases, and the same structure applies in both 12.1.1 and 12.2.2. Standard practice is to call this public wrapper instead of the _PVT package so that exception translation and message handling remain consistent with the rest of the OKL API suite.