Search Results okl_invalid_dates

Overview

The APPS.OKL_SETUPPQUALITYS_PUB package is a public (PUB) API within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its name reflects its purpose: it manages setup records related to property quality definitions ("PQUALITYS"), which are configuration entities used to categorize or qualify leased assets during contract and asset setup. In release 12.1.1 and 12.2.2, this package resides in the APPS schema and exposes a controlled, documented interface for the creation, retrieval, and maintenance of property quality setup rows, insulating calling code from the private implementation held in OKL_SETUPPQUALITYS_PVT.

The package is significant in error-handling terms because it defines a dedicated constant, G_INVALID_DATES, set to the token 'OKL_INVALID_DATES', alongside related constants such as G_DATES_MISMATCH, G_PAST_RECORDS, and G_START_DATE. These constants are used with the standard OKL message framework to raise dated-validation errors — precisely the kind of diagnostic a user searching for okl_invalid_dates would encounter when a setup record fails date-range validation. The package also inherits shared tokens (G_SQLERRM, G_SQLCODE, parent/child table tokens) from OKL_API, confirming its integration with the broader OKL API error stack.

Key Procedures and Functions

The metadata documents three public procedures. No parameter lists are reproduced here; only their documented purposes are described.

• GET_REC — Retrieves a single property quality setup record into the public record type pqyv_rec_type. It signals absence of data through the x_no_data_found output flag and returns status/message information via the standard API OUT parameters.
• INSERT_PQUALITYS — Creates a new property quality setup row. It accepts the standard API version and message-list initialization parameters together with the input record, returning the persisted record and standard return status, message count, and message data.
• UPDATE_PQUALITYS — Modifies an existing property quality setup row using the supplied record, applying the same standard APPS API OUT parameter conventions for status and message feedback.

All three procedures follow the OKL API signature convention (version, init message list, return status, message count, message data), which permits consistent error propagation into the concurrent manager or calling form.

Tables Accessed

The ETRM metadata for this object does not enumerate the underlying tables directly; table access is performed by the private package (OKL_SETUPPQUALITYS_PVT) and exposed through APPS synonyms. Based on the package name and the OKL data model, the procedures operate against the property quality setup entity table (the OKL_SETUPPQUALITYS family of tables) and its associated value/translation rows. Read operations support retrieval of setup definitions, while insert and update operations persist validated configuration data. Because the metadata lists no explicit table references, any statement beyond the property quality setup schema should be treated as inferred rather than documented.

Usage Notes

This package is classified as a public API and is referenced by one other package in the documented ETRM metadata, indicating that internal OKL components depend on it for property quality setup maintenance. It is typically invoked from Oracle Forms setup screens, from concurrent programs performing bulk configuration loads, and from custom PL/SQL code that needs to create or amend property quality definitions. Callers must supply p_api_version, optionally request message-list initialization, and inspect x_return_status and x_msg_data after every call. When date validation fails, the returned error token resolves to OKL_INVALID_DATES, which callers should handle explicitly rather than treating as an unexpected exception.