Search Results g_invalid_criteria

Overview

OKL_MASS_REBOOK_PUB is the public API wrapper for the Oracle Lease and Finance Management (OLFM) mass rebook process delivered with Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2. Its principal business function is to restate, or "rebook," a selected population of lease contracts in response to changes in accounting rules, depreciation parameters, or book setup. Rather than adjusting contracts one at a time through the Lease Management forms, the mass rebook framework lets users define a set of selection criteria, preview the resulting contract population, and then apply the rebooking across all matching contracts in a controlled, auditable manner.

The package is declared AUTHID CURRENT_USER and is classified as a PUB API, meaning it is a supported programmatic entry point intended for callers outside the OLFM schema. Its specification exposes a set of named error constants and shared record/table types, and delegates the substantive business logic to the private package OKL_MASS_REBOOK_PVT through SUBTYPE definitions such as mrbv_rec_type, mstv_rec_type, tcnv_rec_type, and thpv_rec_type. This public/private split preserves encapsulation while giving callers a stable interface.

Key Procedures and Functions

The package documents six procedures/functions:

• BUILD_AND_GET_CONTRACTS — Assembles the contract population that satisfies the supplied rebook criteria, returning the matching set for review or subsequent processing.
• PROCESS_MASS_REBOOK — Drives the overall mass rebook run against the contracts identified by the criteria built earlier.
• APPLY_MASS_REBOOK — Executes the actual rebook logic against the assembled contracts, applying the new book, depreciation, or accounting treatment.
• UPDATE_MASS_RBK_CONTRACT — Updates the mass rebook contract record, maintaining the linkage between the request and the contracts affected.
• MASS_REBOOK_AFTER_YIELD — Handles the rebook step triggered after a yield adjustment on a lease.

The specification also defines error constants including G_UNEXPECTED_ERROR, G_NOT_VALID_REQUEST, and — the token referenced in the user's search — G_INVALID_CRITERIA, mapped to message name OKL_LLA_INVALID_CRITERIA. This constant is raised when the selection criteria passed to the API do not conform to the expected structure. The source header comment specifies the required order of criteria codes: CONTRACT_NUMBER, START_DATE, BOOK_TYPE_CODE, DEPRN_METHOD_CODE, DATE_PLACED_IN_SERVICE, and ASSET_CATEGORY_ID. The criteria record type crit_rec_type carries LINE_NUMBER, CRITERIA_CODE, OPERAND, CRITERIA_VALUE1, CRITERIA_VALUE2, and SET_VALUE.

Tables Accessed

• FA_BOOKS — Read to obtain the depreciation book definitions that govern how rebooked assets are depreciated.
• OKL_MASS_RBK_CRITERIA — Stores the criteria records defining which contracts qualify for the mass rebook and the parameters applied to them.

Usage Notes

OKL_MASS_REBOOK_PUB is typically invoked from the Lease Management mass rebook concurrent program and related forms, and is referenced by six other packages within the OLFM module. Custom code may call it directly to script bulk rebook operations, but callers must populate the criteria table in the documented order and be prepared to handle the G_INVALID_CRITERIA condition, which signals malformed or unsupported selection criteria.