Search Results validate_required_numvalue

Overview

OKS_ENTITLEMENTS_PVT is a private PL/SQL package body in the Oracle E-Business Suite Service Contracts (OKS) module. It encapsulates the validation, date computation, and entitlement-processing logic that underpins the Service Contracts entitlement engine in release 12.1.1 and 12.2.2. The package is classified as PVT (private), meaning its program units are not intended for direct external invocation; instead they are consumed by the public APIs and dependent packages that drive contract, coverage, and business-process processing. The header comment identifies the source file as OKSRENTB.pls, with a revision identifier indicating sustained maintenance through the 12.1.3 code line. Because it belongs to the APPS schema and references OKC and CSI entities through APPS synonyms, it operates strictly within the standard EBS data model.

Key Procedures and Functions

The package exposes 99 documented program units, of which the validation and computation routines form the functional core. The user search term validate_required_numvalue maps to the procedure VALIDATE_REQUIRED_NUMVALUE, which is the numeric counterpart of a family of required-value validators.

• VALIDATE_REQUIRED_NUMVALUE — Confirms that a mandatory numeric value is populated. The excerpt shows it raises an internal null-value exception when the input is NULL, optionally pushes an error message onto the exception stack through OKC_API.Set_Message using the G_REQUIRED_VALUE message name, and returns a boolean result together with a return status.
• VALIDATE_REQUIRED_DATEVALUE and VALIDATE_REQUIRED_CHARVALUE — Equivalent mandatory-value checks for date and character inputs.
• VALIDATE_REQUIRED_RT_TOKENS — Verifies that reaction-time tokens required for entitlement evaluation are present.
• VALIDATE_SERVICE_LINE, VALIDATE_COVERAGE_LINE, VALIDATE_BUSINESSPROCESS_LINE, VALIDATE_CONTRACT_BP, VALIDATE_EFFECTIVITY — Line-level and header-level validations covering service lines, coverage lines, business processes, contract business processes, and effective-date ranges.
• GET_EFFECTIVE_END_DATE, GET_CONT_EFFECTIVE_DATES, CONVERT_TIMEZONE — Date derivation and time-zone normalization helpers used when computing entitlement windows.
• GET_BP_LINE_START_OFFSET — Calculates the offset that positions a business-process line within the contract timeline.
• GET_BP_REACTRESOLTIME_LINE, GET_BP_COVER_TIMES, GET_BP_REACTION_TIMES, GET_REACTN_DURN_IN_DAYS, GET_COVER_DAY_ATTRIBS, COMPUTE_DAY_REACT_BY_DATETIME, COMPUTE_REACT_BY_DATETIME — A set of reaction-time and coverage-time calculators that translate coverage day attributes and business-process definitions into concrete respond-by datetimes.

Package-level constants initialize localized day-of-week names (Bug Fix 5546615) via Get_NLS_Day_Of_Week, supporting multi-language reaction-time calculations.

Tables Accessed

The package reads and writes through APPS synonyms across the contracts, install-base, and trading-partner schemas.

• OKC_K_HEADERS_B / OKC_K_HEADERS_TL — Contract header base and translated attributes supplying header-level entitlement context.
• OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_PARTY_ROLES_B — Contract lines, line items, and party roles defining who is entitled and under what line.
• CSI_ITEM_INSTANCES, CSI_II_RELATIONSHIPS, CSI_I_ORG_ASSIGNMENTS, CSI_SYSTEMS_B — Install-base instances, relationships, organization assignments, and systems that determine entitlement applicability.
• CS_BUSINESS_PROCESSES — Business-process definitions that drive reaction and resolution time seeding.
• JTF_RS_RESOURCE_EXTNS, JTF_RS_RESOURCE_EXTNS_TL, FND_USER — Resource and user references for validation of responsible parties.
• HZ_PARTIES, HR_ALL_ORGANIZATION_UNITS_TL — Trading partners and internal organizations resolved during validation and coverage checks.

Usage Notes

OKS_ENTITLEMENTS_PVT is invoked indirectly. The Service Contracts forms and the entitlement/reaction-time concurrent programs call the public OKS APIs, which in turn delegate validation and computation to this private package. Because it is marked PVT, custom code should not call it directly; developers should use the supported public OKS API surface. The package is referenced by six other packages, confirming its role as a shared internal library. When troubleshooting entitlement errors, the G_REQUIRED_VALUE and G_UNEXPECTED_ERROR messages raised by VALIDATE_REQUIRED_NUMVALUE and its sibling validators typically surface through OKC_API message handling, so the exception stack or FND message log should be inspected to identify the offending mandatory column.