Search Results okl_lla_invalid_date_format

Overview

OKL_FUNDING_CHECKLIST_PVT is a private PL/SQL package that belongs to the Oracle Lease and Finance Management (OKL) application within Oracle E-Business Suite, delivered under the APPS schema. As an "_PVT" (private) API, it implements the underlying business logic for maintaining funding checklists associated with lease and loan funding requests. Funding checklists represent the set of conditions, documents, and validation steps that must be satisfied before a funding request can be approved and disbursed. This package provides the procedural engine that allows checklist records to be created, modified, removed, and formally approved, and it supports the approval workflow for the parent funding request itself.

The package header declares a rich set of global constants typical of ETRM APIs, including return status values (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR), error tokens, and named error constants. Notably, G_OKL_LLA_INVALID_DATE_FORMAT is defined as 'OKL_LLA_INVALID_DATE_FORMAT', which is the message key surfaced when a date supplied to the checklist logic does not match the expected mask. The UI date mask is derived at runtime from the profile option ICX_DATE_FORMAT_MASK, stored in G_UI_DATE_MASK. Additional error constants such as G_NOT_UNIQUE, G_REQUIRED_VALUE, and G_LLA_RANGE_CHECK indicate the validation rules applied to checklist values.

Key Procedures and Functions

• CREATE_FUNDING_CHKLST — Inserts a new funding checklist record, applying required-value, uniqueness, range, and date-format validations before persisting the row.
• UPDATE_FUNDING_CHKLST — Modifies an existing funding checklist record, enforcing the same validation and object-version control rules as creation.
• DELETE_FUNDING_CHKLST — Removes a funding checklist record, subject to any referential or status restrictions.
• APPROVE_FUNDING_REQUEST — Drives the approval of the parent funding request, evaluating completeness of associated checklists and related conditions.
• APPROVE_FUNDING_CHKLST — Marks an individual funding checklist as approved, updating its status so the overall funding request can progress toward disbursement.

Tables Accessed

• OKC_RULES_B — The core rules/conditions table; checklist logic derives condition rows and validation rules from here.
• OKC_RULE_GROUPS_B — Groups related rules for evaluation during checklist validation.
• OKC_K_HEADERS_B — The contract/lease header table, providing the parent contract context for the funding request.
• OKL_TRX_AP_INVOICES_B — Links checklist processing to associated AP invoices involved in funding.
• PLITBLM — A general PL/SQL table used internally for bulk processing/in-memory collections.

Usage Notes

This private package is not intended for direct invocation by external callers. It is referenced by two other packages, which are the public APIs that expose its functionality. In a standard EBS 12.1.1 or 12.2.2 environment, OKL_FUNDING_CHECKLIST_PVT is invoked indirectly through the Lease and Finance Management funding and approval forms, and through concurrent or workflow-driven approval processes that call the public wrapper APIs. Because the invalid-date error key OKL_LLA_INVALID_DATE_FORMAT originates here, runtime errors matching that token generally indicate that a date value passed into checklist processing failed the ICX_DATE_FORMAT_MASK validation, and troubleshooting should focus on the date format supplied by the calling form or interface. Custom extensions should call the public API layer rather than this private package to remain upgrade-safe.