Search Results g_exception_stop_validation

Overview

OKL_ITI_PVT is a private PL/SQL package body in the Oracle E-Business Suite Oracle Lease and Finance Management (OKL) module, owned by the APPS schema. It is classified as a Private (PVT) API, meaning it is intended for internal consumption by the OKL transaction-line item-instance layer and other OKL packages rather than for direct external calls. The package supports the maintenance of transaction line item asset instances — the relationship between lease transaction lines and the physical item instances tracked through Oracle Install Base (CSI). Its responsibilities include row-level insert, update, delete, lock, and validation logic for the OKL_TXL_ITM_INSTS entity, which records the item instances attached to transaction lines.

The header identifies the constants and hand-coded validation infrastructure reused across the OKL transaction validation framework: G_REQUIRED_VALUE, G_INVALID_VALUE, G_NO_MATCHING_RECORD, G_TAL_LOOKUP_TYPE, and the named exceptions G_EXCEPTION_HALT_VALIDATION and G_EXCEPTION_STOP_VALIDATION. This places OKL_ITI_PVT within the standard OKC/OKL table-handler pattern, where bulk validation errors are accumulated and processing is conditionally halted or stopped.

Key Procedures and Functions

• QC — A quality-control/consistency check routine used to verify data integrity conditions for the package's underlying entity.
• CHANGE_VERSION — Manages the versioning behaviour of the transaction line item instance records, supporting OKL's versioned transaction model.
• API_COPY — Copies transaction line item instance rows, typically when a transaction is duplicated or a new version is generated.
• INSERT_ROW — Creates a new OKL_TXL_ITM_INSTS record, applying defaulting and validation prior to insertion.
• LOCK_ROW — Places a pessimistic lock on a targeted row to serialize concurrent modifications.
• UPDATE_ROW — Modifies an existing transaction line item instance record, applying change-based validation.
• DELETE_ROW — Removes the item-instance association from the transaction line.
• VALIDATE_ROW — Executes attribute-level validations for the entity, including the listed checks against TAS, TAL, KLE, object IDs (old and new), JTOT object codes, manufacturing serial number flags, inventory item and organization identifiers, instance_id, selected_for_split_flag, and AS_ ID.

Tables Accessed

• OKL_TXL_ITM_INSTS — The primary entity, holding transaction line item instance associations.
• CSI_ITEM_INSTANCES — Oracle Install Base item instances referenced by the validations.
• JTF_OBJECTS_B — Source of object-code validation for JTOT references.
• OKL_TRX_ASSETS — Transaction asset data supporting line item asset validation.
• OKL_TXD_ASSETS_B — Transaction detail asset base-table data.
• OKL_TXL_ASSETS_B — Transaction line asset base-table data.
• DUAL — Used for single-row lookups and constant evaluation.
• PLITBLM — Standard EBS PL/SQL table/array manipulation package.

Usage Notes

OKL_ITI_PVT is a private package and should not be invoked directly by customer code; it is called internally by OKL public APIs, forms, and concurrent processes that manage lease transaction line item instances. The metadata records that it is referenced by 26 other packages, confirming its role as a shared low-level handler. The g_exception_stop_validation identifier searched by the user is a package-level named exception declared in the specification and raised by validation routines within this package and its callers to abort validation when a stop-level condition is detected. Because it is a package-global, it can only be referenced in code that has visibility of the OKL_ITI_PVT package. Modifications should be limited to Oracle-supported patches, as the body carries a standard OKLSITIB.pls header and version history.