Search Results orgp_get_s_loc_type2

Overview

IGS_OR_VAL_LOC is a validation package in the Oracle E-Business Suite higher education (Student System / Oracle Student System, IGS) product family. Its responsibility is to enforce the business rules that govern location records defined in the IGS_AD_LOCATION and IGS_AD_LOCATION_TYPE entities. The package body exposes Boolean-returning validation routines that forms and other PL/SQL components call before committing location data, ensuring that closed location types are not reused and that mandatory attributes, such as an examination centre co-ordinator, are populated where the system location type requires them.

The package follows the standard IGS validation idiom: each function returns a BOOLEAN and, on failure, returns the name of a message registered in FND_MESSAGE. Unexpected errors are routed through the IGS_GE_MSG_STACK and re-raised via APP_EXCEPTION.RAISE_EXCEPTION, allowing the calling form to present a uniform error to the user. The header comment identifies the source as IGSOR05B.pls and records that the function GENP_VAL_PRSN_ID was removed under Bug 1956374.

Key Procedures and Functions

• ORGP_VAL_LOC_TYPE — Validates that a supplied location type is not closed. It queries IGS_AD_LOCATION_TYPE for a row matching the location type with closed_ind = 'Y'; if found, it sets the message name to IGS_OR_LOC_TYPE_CLOSED and returns FALSE.
• ASSP_VAL_LOC_COORD — Validates that a co-ordinator person is specified when the location is an examination centre. It calls IGS_OR_GEN_001.ORGP_GET_S_LOC_TYPE2 to resolve the system location type for the given location type, and when that value equals 'EXAM_CTR' it requires a non-null co-ordinator, returning IGS_AS_COORD_SET_EXAMLOC on failure. This is the reference point for the search term orgp_get_s_loc_type2: the cross-package call that resolves the system location type from the user-defined location type.
• ASSP_VAL_LOC_VE_OPEN — Validation routine concerned with the open state of a location record. (Descriptive detail not present in the supplied ETRM excerpt.)
• ASSP_VAL_LOC_VE_XIST — Validation routine concerned with the existence of a location record. (Descriptive detail not present in the supplied ETRM excerpt.)

Tables Accessed

The documented table reference is IGS_AD_LOCATION_ALL, accessed through its APPS synonym. This entity stores location definitions, including the location type, co-ordinator person identifier, and related attributes, and is the subject of the co-ordinator and open/existence validations. The package body additionally reads IGS_AD_LOCATION_TYPE, which holds the closed indicator and the system location type used by ORGP_VAL_LOC_TYPE and by the IGS_OR_GEN_001 lookup respectively.

Usage Notes

IGS_OR_VAL_LOC is an internal validation library rather than a user-facing API and carries an API classification of OTHER. It is invoked from the Oracle Forms layer that maintains locations, and from custom or extension PL/SQL that must apply identical rules. The documented metadata shows it is referenced by one other package, indicating reuse elsewhere in the IGS schema. Because the functions return BOOLEAN and surface messages only through an OUT NOCOPY message-name parameter, callers must inspect the return value and, on FALSE, translate the message name through FND_MESSAGE before displaying it. Customisations should call these routines rather than re-implementing the closed-type or examination co-ordinator rules, so that validation remains consistent across the application.