Search Results okl_db_error

Overview

OKL_ITM_CAT_RV_PRCS_PUB is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Lease and Finance Management (OKL) product family, which is part of the ETRM (Enterprise Trade and Risk Management) application suite. The package encapsulates the business logic that governs item category revenue processing rules, which determine how lease and finance transactions classify items into revenue-recognition categories. These rules form part of the contract authoring and pricing infrastructure that drives downstream revenue schedules, billing streams, and accounting entries for leased assets.

The object is documented with a status of VALID and is classified as a public (PUB) API, indicating that its procedures are intended for invocation from external callers such as Oracle Forms, concurrent programs, or custom extensions. It references the standard EBS API infrastructure, notably FND_API, FND_MSG_PUB, and OKL_API, and delegates low-level validation and persistence to its corresponding private package body, OKL_ICP_PVT. The metadata confirms that OKL_ITM_CAT_RV_PRCS_PUB is not referenced by any other database object, meaning it sits at the top of its dependency chain as an entry-point API.

Key Procedures and Functions

The documented package exposes ten procedures and functions, with the following set identified as the core public entry points:

• INSERT_ITM_CAT_RV_PRCS — Creates a new item category revenue processing rule record, applying the full multi-layer validation sequence before persisting the row.
• LOCK_ITM_CAT_RV_PRCS — Acquires the required lock on an existing rule record to prevent concurrent modification during an update or delete operation.
• UPDATE_ITM_CAT_RV_PRCS — Modifies attributes of an existing revenue processing rule, re-validating the changed data set before committing the change.
• DELETE_ITM_CAT_RV_PRCS — Removes a revenue processing rule record, subject to referential and validation checks that guard against deletion of rules still in active use.
• VALIDATE_ITM_CAT_RV_PRCS — Performs the standalone validation of a rule definition, covering entity-level, column-level, and cross-field checks, and populates the FND_MSG_PUB message stack on failure.

All five follow the standard Oracle EBS API conventions: a p_init_msg_list mode, an x_return_status out parameter carrying the FND_API.G_RET_STS_SUCCESS, ERROR, or UNEXPECTED values, and x_msg_count and x_msg_data out parameters that surface messages returned through FND_MSG_PUB.

Tables Accessed

The metadata excerpt does not enumerate specific base tables; the dependency list records only package references. Because the private counterpart OKL_ICP_PVT is the repository for SQL against the ETRM item category revenue processing entity, the public body is a thin procedural wrapper that marshals parameters and messages. Validation tables such as OKL_ITM_CAT_RV_PRCS itself and related setup tables with appropriate APPS synonyms are accessed through OKL_ICP_PVT rather than directly from the public body.

Usage Notes

OKL_ITM_CAT_RV_PRCS_PUB is typically invoked from the Oracle Lease and Finance Management setup forms where administrators define item category revenue processing rules, and by custom PL/SQL that needs to create or maintain these rules programmatically. Callers must check x_return_status after every call and drain the message stack with FND_MSG_PUB.GET when errors are returned. Because the package is defined as a public API and is not referenced by any other database object, it is safe to extend but should never be modified in-place in a supported environment.