Search Results error_message_type

Overview

OKL_VENDOR_REFUND_PVT is a private PL/SQL package in the Oracle E-Business Suite (EBS) Oracle Lease Management (OKL) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It supports the vendor refund process by identifying non-delinquent lease contracts that qualify for a refund under vendor program rules. The package evaluates a vendor's refund eligibility and drives a concurrent process that generates vendor refunds. As a PVT (private) package, it is not part of the public API layer; it is invoked internally by other OKL components and is referenced by two other packages.

The package header declares the constant G_PKG_NAME ('OKL_VENDOR_REFUND_PVT') and G_APP_NAME ('OKL'), and establishes a message level threshold derived from the FND profile option FND_AS_MSG_LEVEL_THRESHOLD, defaulting to FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW. This controls the verbosity of logging output produced during processing.

Key Procedures and Functions

Two procedures are documented in the package specification:

• GENERATE_VENDOR_REFUND — The core concurrent process procedure. It receives standard concurrent manager output parameters (errbuf and retcode) along with a contract number, and identifies non-delinquent contracts eligible for refund based on vendor program rules. It calculates the vendor's eligibility for refund and populates success and error collections tracking contract number, cure type, and cure amount.
• WRITE_LOG — A logging utility that accepts a message level and message text and writes diagnostic output, respecting the configured message level threshold.

The package also declares several PL/SQL types used to organize processing results, including error_rec_type (a record of contract number, cure type, and cure amount), error_tbl_type (a table of error records indexed by binary integer), and error_message_type (a table of VARCHAR2(2000) messages indexed by binary integer). The error_message_type collection is the element referenced by users searching for that term; it stores formatted error text surfaced during refund generation. Corresponding package-level variables l_error_tbl, l_success_tbl, l_error_idx, and l_success_idx accumulate results across processing.

Tables Accessed

The package reads and processes data from the following documented tables and synonyms:

• OKC_K_HEADERS_B — Source of contract header data, including contract_number used in the error record type.
• OKL_CURE_AMOUNTS — Provides cure type and cure amount values used in error and success tracking.
• AR_PAYMENT_SCHEDULES_ALL — Supports delinquency determination that distinguishes non-delinquent contracts eligible for refund.
• OKC_RULE_GROUPS_B — Holds vendor program rule group definitions applied during eligibility evaluation.
• OKL_K_HEADERS — OKL-specific lease header data.
• OKL_TXD_AR_LN_DTLS_B — Transaction detail lines associated with lease and receivables processing.
• DUAL and PLITBLM — Utility references used for structure and bulk operations.

Usage Notes

OKL_VENDOR_REFUND_PVT is typically invoked through the OKL vendor refund concurrent program, which calls GENERATE_VENDOR_REFUND with contract-level scope. It is not intended for direct calls from forms or custom code; as a PVT package it is consumed by the internal OKL refund architecture and by the two packages that reference it. Developers extending vendor refund logic should respect the private classification and avoid depending on its signatures, which are subject to change across releases such as 12.1.1 and 12.2.2. Diagnostic output is controlled via the FND message level threshold profile, making WRITE_LOG useful for debugging concurrent runs.