Search Results g_db_error

Overview

OKL_LRF_PVT is a private (PVT-classified) PL/SQL package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its name reflects its function: LRF denotes Lease Rate Factor, and the package encapsulates the business logic for maintaining lease rate factor records in the OKL_LS_RT_FCTR_ENTS entity. A lease rate factor is the multiplier used to convert an asset cost into a periodic lease payment, and the accuracy of these factors is central to lease pricing, quotation, and contract generation in ETRM. The package body exposes a small public surface — the get_rec function and the standard DML wrapper procedures — while delegating validation and row-level locking to its documented procedures. The distribution comment header (OKLSLRFB.pls, version 120.6) indicates this is a long-standing seeded object maintained by Oracle, not a customer extension.

Key Procedures and Functions

• INSERT_ROW — Inserts a new lease rate factor entry into the underlying rate factor entity table, applying the standard WHO columns and returning status to the caller.
• LOCK_ROW — Issues a SELECT ... FOR UPDATE against the target row to serialize concurrent modifications, typically invoked before an update so that optimistic locking via OBJECT_VERSION_NUMBER and pessimistic locking cooperate.
• UPDATE_ROW — Updates an existing rate factor record, enforcing the object version number check to detect lost updates.
• DELETE_ROW — Removes a rate factor record, subject to the referential and business rules enforced in VALIDATE_ROW or by the surrounding API.
• VALIDATE_ROW — Performs field-level and cross-field validation on a rate factor record, including checks on term, residual value percent, interest rate, lease rate factor, rate set version, and descriptive flexfield attribute columns, before insert or update is permitted.

The package body also contains a private get_rec function that selects a single row by primary key from the OKL_LS_RT_FCTR_ENTS_V view into the lrfv_rec_type PL/SQL record, returning g_ret_sts_success, g_ret_sts_error, or g_ret_sts_unexpected_error through the x_return_status OUT parameter. The user search term "g_db_error" relates to the global error-handling constants declared in the OKL_API / shared exception layer that these procedures use to classify Oracle errors and unexpected exceptions.

Tables Accessed

• OKL_LS_RT_FCTR_ENTS — The primary rate factor entity table; the target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW, and the source for get_rec via its _V view.
• OKL_FE_RATE_SET_VERSIONS — Stores rate set version headers; referenced to validate the RATE_SET_VERSION_ID foreign key on each factor row.
• OKL_LS_RT_FCTR_SETS_B — Base table of rate factor sets that group individual factors; used to confirm set membership and version consistency.
• PLITBLM — The standard EBS PL/SQL index-by table used for bulk/array processing in the package's DML and validation loops.

Usage Notes

As a PVT package, OKL_LRF_PVT is not intended to be called directly from customer code or concurrent programs. It is invoked by the public OKL API layer and by nine other OKL packages that manage rate factor maintenance, pricing, and lease origination. Typical entry points are the Lease Rate Factor maintenance form in the OKL responsibility and the internal pricing/quoting routines that read factor values during lease creation. Because all mutating procedures follow the standard EBS pattern (lock, validate, apply, return status), any custom integration should call the corresponding public OKL_API wrapper rather than this package directly. The global constants and exception handling (including the shared g_db_error path) mean errors are surfaced through x_return_status and the OKL message stack rather than unhandled exceptions, allowing the calling form or program to present a meaningful error to the user.