Search Results g_exc_error

Overview

OKS_QP_INT is a service contract integration package in the Oracle E-Business Suite Applications (APPS) schema. Its documented purpose is to provide integration utilities that bridge Oracle Service (OKS) contract data and Oracle Advanced Pricing (QP) style unit-of-measure and conversion logic. The package exposes a single public program unit, GET_CONVERSION_FACTOR, which computes a numeric factor used to convert a service duration expressed in a time unit into a target pricing or billing unit of measure (UOM). This factor supports downstream contract pricing, quantity proration, and billing calculations where service periods must be normalized to the units expected by pricing and order-capture modules.

The package header declares an API version constant (l_api_version) and an initialization message list flag (l_init_msg_list), following the standard EBS PL/SQL API conventions. The body carries the source control header identifying it as OKSGPINB.pls, version 120.0, dated 2005/05/25, indicating a long-stable component carried forward into EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

• GET_CONVERSION_FACTOR — The sole documented program unit. It accepts a start date and end date, a source time unit and a target UOM (p_pb_uom), and returns the conversion factor (x_factor) together with standard API output parameters: return status (x_return_status), message count (x_msg_count), and message data (x_msg_data). It first calls OKS_TIME_MEASURES_PUB.get_duration_uom to derive the duration and its native time unit for the specified date range. If that call fails, x_factor is set to NULL and the packaged exception G_EXC_ERROR is raised. When the requested UOM matches the derived time unit, the factor is 1 for a single-unit duration or the raw duration value otherwise. When the units differ, the routine delegates to OKS_TIME_MEASURES_PUB.get_target_qty, passing the source duration and source UOM against the target UOM with a rounding precision of 20 decimal places.

Tables Accessed

The ETRM metadata records no direct table references through APPS synonyms for this package. All data retrieval is performed indirectly through the OKS_TIME_MEASURES_PUB API, which encapsulates the underlying lookups against service duration and time-measure definitions. This design keeps OKS_QP_INT insulated from base-table schema changes and centralizes UOM and calendar logic in the time measures package. No DML is performed by OKS_QP_INT itself; it functions purely as a conversion calculation layer.

Usage Notes

GET_CONVERSION_FACTOR is typically invoked from service contract pricing flows, order and quote integration logic, and custom extensions that must translate a contract period into a billable quantity expressed in a pricing UOM. Callers should supply p_api_version (1.0), p_init_msg_list, and the contract start and end dates, then inspect x_return_status against G_RET_STS_SUCCESS. The package uses the standard EBS error handling pattern: unexpected errors are trapped in the OTHERS handler, the return status is set to G_RET_STS_UNEXP_ERROR, and OKC_API.SET_MESSAGE is called with G_APP_NAME, G_UNEXPECTED_ERROR, and the SQLCODE/SQLERRM tokens to populate the message stack. The G_EXC_ERROR exception raised on a failed duration lookup is deliberately re-raised and swallowed by the local handler so that a NULL factor and a non-success return status signal the failure to the caller. Because ETRM lists zero dependent packages, OKS_QP_INT is a leaf-level utility suitable for direct invocation from forms, concurrent programs, or custom PL/SQL, provided the caller handles the message count and message data outputs.