Search Results assp_val_ai_exmnbl

Overview

The APPS.IGS_AS_VAL_AIEM package body is a validation library within the Oracle E-Business Suite Student System (IGS) product family. It belongs to the Assessment (IGS_AS) functional area and provides reusable PL/SQL validation routines that enforce business rules governing assessment items, examination material, and assessment types. The package name follows the IGS naming convention, where the "VAL" component indicates a validation-oriented unit and "AIEM" denotes the assessment item / exam material domain. Its API classification in ETRM is recorded as OTHER, reflecting that it is an internal validation utility rather than a public, standalone application programming interface.

The package is invoked by higher-level assessment processing logic and by other packages in the assessment module. ETRM metadata records that it is referenced by four other packages, confirming its role as a shared validation service rather than an entry-point program. Its routines return a BOOLEAN status and pass back a message name token, which the calling program resolves to a user-facing message. This design allows validation failures to be surfaced consistently through the Oracle Forms message stack and the FND_MESSAGE infrastructure.

Key Procedures and Functions

• ASSP_VAL_AIEM_CATQTY — Validates the relationship between the material category and the quantity per student on an assessment item. It enforces the rule that the material category must be SUPPLIED whenever a quantity per student is specified. When the category is anything other than SUPPLIED but a quantity is populated, the function returns FALSE and sets the message name IGS_AS_SYS_MATCAT_SUPPLIED.
• ASSP_VAL_AI_EXMNBL — Validates that an assessment item is examinable. It queries the assessment type associated with the item and checks the examinable_ind flag. If the item is linked to a non-examinable assessment type, the function returns FALSE and sets the message name IGS_AS_ASSITEM_NOT_EXAMINABLE. This routine corresponds directly to the user search term assp_val_ai_exmnbl.
• ASSP_VAL_EXMT_CLOSED — Validates the closed status of exam material type records, ensuring that downstream assessment processing does not proceed against exam material definitions that are closed or otherwise unavailable for use.

Each function traps unhandled exceptions with WHEN OTHERS, sets the generic error message IGS_GE_UNHANDLED_EXP, records a token identifying the failing routine, and pushes the message onto the IGS message stack. This uniform error handling supports consistent diagnostics across the assessment module.

Tables Accessed

• IGS_AS_ASSESSMNT_ITM_ALL — The assessment item entity, supplying the ass_id and assessment_type used to identify the item under validation.
• IGS_AS_ASSESSMNT_TYP — The assessment type definition, providing the examinable_ind flag that determines whether an item may be treated as examinable.
• IGS_AS_ITM_EXAM_MTRL — The examination material definition, providing s_material_cat and quantity_per_student used by the category/quantity validation.
• IGS_AS_EXM_MTRL_TYPE — The exam material type definition, consulted when validating material type status.

All tables are accessed through APPS synonyms, consistent with standard EBS data dictionary conventions. The routines perform read-only lookups and do not modify data.

Usage Notes

The package is typically invoked from Oracle Forms validation triggers and from other PL/SQL packages during assessment item entry and maintenance. Callers are expected to inspect the returned BOOLEAN and, when FALSE, display the returned message name through the standard FND_MESSAGE mechanism. Because the routines are internal validators, direct invocation from concurrent programs or custom extensions is uncommon, though custom code may call them to enforce identical business rules. The $Header attribute in the source indicates the script is a retrofitted release artifact (IGSAS13B.pls), so behavior should be validated against the specific patch level in use on 12.1.1 or 12.2.2.