Search Results create_case

Overview

OKL_CASE_UTIL_PUB is the public API package for case (dispute) management within the Oracle Lease Management (OKL) module of Oracle E-Business Suite, Release 12.1.1 and 12.2.2. The package body acts as a thin wrapper or façade layer over the private implementation package OKL_CASE_UTIL_PVT. Its principal responsibility is to expose a stable, standardized public interface through which EBS forms, concurrent programs, and custom extensions may create a case record associated with a contract. By delegating all business logic to the private package, OKL_CASE_UTIL_PUB preserves the integrity of the API boundary and protects callers from internal implementation changes. The package follows the Oracle Applications API coding conventions, including the standard API version parameter, message list initialization, savepoint management, and the FND_API return status model.

Key Procedures and Functions

• CREATE_CASE — The sole documented procedure in this package. It accepts the caller's API version and message list initialization flag, along with a contract identifier, and returns the standard API out parameters: return status, message count, and message data. The procedure validates the API version, opens a savepoint named CREATE_CASE, and invokes the corresponding CREATE_CASE procedure in OKL_CASE_UTIL_PVT to perform the actual creation. Based on the private API's return status, it raises the appropriate FND_API exception (error or unexpected error), propagates any messages accumulated during processing, and assigns the final values to the OUT parameters. If an error occurs, the exception handler rolls back to the savepoint, sets the return status to error, resequences the message stack, and emits diagnostic data using FND_MSG_PUB.ADD_EXC_MSG and FND_MSG_PUB.COUNT_AND_GET.

Tables Accessed

The documentation excerpt for OKL_CASE_UTIL_PUB records no direct table references via APPS synonyms. This is consistent with its design as a wrapper: all INSERT, UPDATE, and SELECT operations against the underlying case tables — such as the OKL_CASE tables that store dispute header and related contract data — are performed by the private package OKL_CASE_UTIL_PVT. The public package therefore contains no direct DML, and the tables accessed are those managed by the private implementation.

Usage Notes

OKL_CASE_UTIL_PUB is typically invoked when a case or dispute must be raised against a lease contract, either automatically or on user request. Standard consumers include Oracle Lease Management forms that present a case or dispute action, concurrent programs that generate cases in bulk, and custom code that integrates with external dispute or collections systems. Callers should always invoke the public API rather than the private package, supply a valid API version, and initialize the message list as needed. The return status must be checked against FND_API.G_RET_STS_SUCCESS; when it is not successful, the caller should read the message count and data to surface errors. Because the procedure performs savepoint handling and message stacking internally, callers should not assume the operation is committed — commit or rollback remains the responsibility of the calling transaction.