Search Results g_not_unique

Overview

OKL_SPLIT_ASSET_COMP_PVT is a private PL/SQL API package owned by APPS within the Oracle E-Business Suite ETRM (Enterprise Contracts and Lease Management) module, classified as a PVT (private) API. Its principal business function is the splitting of asset components on lease and contract lines. When a lease line references an asset that must be divided among multiple sub-components — for example, when a single asset is apportioned across several contract lines or split for financial restructuring — this package coordinates the creation, maintenance, and removal of those asset component records. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than its owning schema, and it is designed for internal invocation by higher-level ETRM APIs rather than direct end-user calls.

The package header defines global message constants including G_PKG_NAME, G_APP_NAME, G_UNEXPECTED_ERROR, G_REQUIRED_VALUE, and notably G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE'. The trailing comment line $Header: OKLRSACS.pls 115.1 2002/07/29 identifies the source file and indicates the object has remained stable on the noship branch, which is consistent with its internal, non-shipped status. The OKL_LLA_NOT_UNIQUE message corresponds directly to the user's search term and is raised when a uniqueness validation over lease line asset records fails.

Key Procedures and Functions

• CREATE_SPLIT_ASSET_COMP — Creates new split asset component records. It accepts an API version, an initialization flag, standard return status/message output parameters, and an input array of asset detail records, returning the populated asset detail table.
• UPDATE_SPLIT_ASSET_COMP — Modifies existing split asset component records, using the same calling convention as the create procedure.
• DELETE_SPLIT_ASSET_COMP — Removes split asset component records that are no longer required, such as when a lease is terminated or a split is reversed.
• PROCESS_SPLIT_ASSET_COMP — Orchestrates the overall split operation, invoking the create, update, and delete logic as required by the incoming data set and performing associated validation.

The package also declares the global exception G_EXCEPTION_HALT_VALIDATION, used to abort validation processing when a fatal condition is encountered.

Tables Accessed

• OKL_TRX_ASSETS — Stores the transaction-level asset records associated with lease lines; the primary repository for split asset data.
• OKL_TXD_ASSETS_B — Holds asset detail definitions, providing the component-level structure of each asset.
• OKL_TXL_ASSETS_B — Holds asset-line associations that link assets to specific contract lines.
• OKC_K_LINES_B — The contract line base table; split components must reconcile back to valid contract lines.
• OKC_LINE_STYLES_B — Defines line styles that govern how asset lines are classified and processed.
• WF_PARAMETER_LIST_T — The Workflow parameter list, used when the split operation is driven or followed by a workflow process.
• PLITBLM — A PL/SQL internal table type used for array handling within the API's collection logic.

Usage Notes

Because OKL_SPLIT_ASSET_COMP_PVT is classified as a private API, it is not intended for direct customer invocation. It is referenced by two other packages within the ETRM stack, which act as the public entry points for asset-splitting functionality. Invocation typically originates from lease and contract management forms or from concurrent programs that perform bulk asset restructuring. Custom code should call the public wrapper packages rather than this private package to remain upgrade-safe. When the OKL_LLA_NOT_UNIQUE error is encountered, it indicates that the input asset detail table contains duplicate lease-line asset combinations that violate the uniqueness constraint enforced during validation.