Search Results validate_tmpt_set

Overview

OKL_TMPT_SET_PUB is the public (PUB-classified) PL/SQL API package for managing Oracle Lease Management template sets and template lines in Oracle E-Business Suite Release 12.1.1 and 12.2.2. A template set defines a reusable collection of contract terms, conditions, and attributes that can be applied when creating or amending lease and financing agreements within the ETRM (Enterprise Transaction and Relationship Management) product family. The package exposes the supported, externally callable interface for template set and template maintenance, insulating callers such as Oracle Forms, concurrent programs, and custom extensions from the underlying private implementation.

As a public wrapper, OKL_TMPT_SET_PUB follows the Oracle Application Object Library (AOL) API conventions: it accepts an API version, an initialization flag for the message stack, and standard OUT parameters for return status, message count, and message data. The package body delegates its core processing to the private package OKL_TMPT_SET_PVT, performing customer and vertical-industry pre- and post-processing, complex entity validation, and exception translation before returning results to the caller. The header references the file OKLPAESB.pls, confirming its registration and versioning within the ETRM source tree.

Key Procedures and Functions

The package documents thirty-three procedures and functions, organized into logical families for template sets, templates, and template lines. Each family provides a consistent lifecycle pattern:

• Create_TMPT_SET — Creates a new template set record based on the supplied entity and value records, returning the created set for use by the caller.
• Update_TMPT_SET — Applies modifications to an existing template set.
• Validate_TMPT_SET (the object of the user's search) — Validates a template set against business rules without persisting changes, giving callers a mechanism to perform pre-save checks.
• Lock_TMPT_SET — Obtains a concurrency lock on a template set prior to modification, preventing simultaneous updates.
• Delete_TMPT_SET — Removes a template set from the system.
• Create_Template, Update_Template, Validate_Template, Lock_Template, Delete_Template — The corresponding lifecycle operations for individual templates within a template set.
• Create_TMPT_LINES, Update_TMPT_LINES, Validate_TMPT_LINES, Lock_TMPT_LINES, Delete_TMPT_LINES — The lifecycle operations for template lines, which represent the individual detail items belonging to a template.

The parameter signature shown for Create_TMPT_SET illustrates the standard pattern: API version, initialization list, return status, message count and data, an entity record plus collection structures for values and lines, with mirrored OUT versions of each entity and collection. The validate procedures follow the same pattern but do not commit data.

Tables Accessed

Per the documented ETRM metadata, the package references PLITBLM through an APPS synonym. This is the Oracle AOL message table used by FND_MSG_PUB to store and retrieve localized message text, consistent with the package's calls to FND_MSG_PUB.Count_and_get. Transactional data for template sets, templates, and template lines is written and read through the private layer and its underlying OKL tables, which are not enumerated in the public package metadata. The public package's direct table interaction is therefore limited to message resolution.

Usage Notes

OKL_TMPT_SET_PUB is invoked whenever template sets need to be created, validated, locked, updated, or deleted from a supported external entry point. Typical callers include the Lease Management setup forms for templates and template sets, concurrent programs that seed or migrate template content, and custom code extending ETRM functionality. Nine other packages reference this API, indicating it is a central integration point for template-related processing.

Callers must observe standard AOL API semantics: check x_return_status for FND_API.G_RET_STS_SUCCESS, G_RET_STS_ERROR, or G_RET_STS_UNEXP_ERROR; honor the x_msg_count and x_msg_data outputs by calling FND_MSG_PUB for details; and use the Lock procedures before Update or Delete operations to ensure concurrency control. Validate procedures should be called before persistence where business-rule confirmation is required. Because the package performs savepoint-based exception handling and rolls back to its savepoint on error, callers should not rely on partial application of template set changes.