Search Results orgp_val_loc_closed

Overview

IGS_AS_VAL_ELS is a validation package body owned by the APPS schema in Oracle E-Business Suite, classified under the "Other" API category. It belongs to the Oracle Student System (IGS) product family, specifically the assessment (IGS_AS) module, and provides centralized validation logic used across assessment-related setup and processing. The package encapsulates reusable business rules that check the correctness and consistency of location and venue data before those records are used in assessment scheduling and delivery. Its naming convention and structure follow the Oracle IGS standards, including standardized error handling through FND_MESSAGE and the IGS_GE_MSG_STACK utility, which pushes unhandled exceptions onto the message stack for downstream reporting.

The package reflects a maintenance history typical of long-lived EBS code. The header comment indicates a modernization pass in 2002 under the $Header tag, and a change history entry records the removal of the function genp_val_staff_prsn in August 2001 under Bug 1956374. The documented interface has therefore evolved over time, and only two procedures/functions remain exposed in the ETRM metadata: ASSP_VAL_ACTV_STDNT and ORGP_VAL_LOC_CLOSED.

Key Procedures and Functions

• ASSP_VAL_ACTV_STDNT — A validation routine concerned with the active student indicator. It is intended to verify that a student record holds a valid active status before assessment-related processing proceeds, returning a boolean result and surfacing the relevant message name through an OUT parameter.
• ORGP_VAL_LOC_CLOSED — The function most directly associated with the search term "orgp_val_loc_closed". It validates the location closed indicator on a location record. The cursor c_loc selects the closed_ind column from IGS_AD_LOCATION for a supplied location code, and the function returns a boolean indicating whether the closed indicator passes validation, while populating P_MESSAGE_NAME for error communication. This routine guards against using locations that have been administratively closed.

Although the excerpt also shows ASSP_VAL_VE_LOT, which validates that the system location type is EXAM_CTR, the ETRM metadata lists only the two documented procedures above. Parameter details should be taken from the source listing rather than assumed.

Tables Accessed

• IGS_AD_LOCATION_ALL — Referenced through APPS synonyms and used by ORGP_VAL_LOC_CLOSED to read the location closed indicator. The base table IGS_AD_LOCATION supplies the closed_ind value checked by the cursor.
• IGS_GR_VENUE_ALL — Associated with venue and exam location validation, supporting routines such as ASSP_VAL_VE_LOT that confirm the location type definition.

These are predominantly read-only validation lookups. No inserts, updates, or deletes are documented.

Usage Notes

IGS_AS_VAL_ELS is typically invoked from Oracle Forms and from other PL/SQL packages within the assessment module, rather than directly by end users. The metadata records that it is referenced by four other packages, indicating it acts as a shared validation service layer. Custom extensions and concurrent programs that create or validate location, venue, and student assessment data may call ORGP_VAL_LOC_CLOSED before committing records. Because return values are boolean and errors are routed through FND_MESSAGE tokens, calling code must handle the boolean result and check P_MESSAGE_NAME to present meaningful messages. Consumers should validate against both EBS 12.1.1 and 12.2.2, where the package remains an APPS-owned dependency.