Search Results assp_val_ai_exist2

Overview

The package body APPS.IGS_AS_VAL_ATYP belongs to the Oracle E-Business Suite Student Systems (Advanced Studies / Academic Assessment) family of validation utilities, shipped under the IGS application short name. Its business function is to centralise the server-side validation rules that govern assessment type data used when defining and administering student assessments. The package encapsulates two discrete validation routines, each returning a Boolean outcome plus an optional message name that calling code can resolve through FND_MESSAGE and surface to the end user. The _ATYP suffix in the package name indicates its scope is assessment type and assessment item configuration, and the unit is classified in the ETRM as an OTHER API rather than a public API, reflecting its role as an internal supporting validation library.

Key Procedures and Functions

• ASSP_VAL_SAT_CLOSED — Validates the closed indicator held against a System Assessment Type record. The function accepts a system assessment type and returns a message name to the caller. It queries the closed indicator for the supplied assessment type; if no record is found the function returns success, and if the record is flagged closed it returns failure together with the message name IGS_AS_SYSASSTYPE_CLOSED. Unhandled errors are trapped and logged through FND_MESSAGE and IGS_GE_MSG_STACK using the token IGS_AS_GEN_015.assp_val_sat_closed.
• ASSP_VAL_AI_EXIST2 — Confirms that assessment item records exist for a given assessment type. The function accepts an assessment type and returns a message name, treating the presence of at least one matching assessment item as the success condition. This is the routine associated with the search term assp_val_ai_exist2. It is typically used before permitting operations that depend on at least one configured assessment item, such as result entry, marking, or progression processing.

Both functions follow the same contract pattern: a default message name of NULL, a Boolean return of TRUE for success, and a populated message name on failure. Parameter lists are intentionally not reproduced here.

Tables Accessed

• IGS_AS_SASSESS_TYPE — Read by ASSP_VAL_SAT_CLOSED to retrieve the CLOSED_IND value for the supplied system assessment type, determining whether the type remains open for use.
• IGS_AS_ASSESSMNT_ITM_ALL — Read by ASSP_VAL_AI_EXIST2 to establish whether any assessment item exists for the supplied assessment type. In the documented excerpt the cursor is defined against the base table IGS_AS_ASSESSMNT_ITM; access is presented to the package through the APPS synonyms listed above.

Both accesses are read-only; the package performs no inserts, updates, or deletes.

Usage Notes

Because IGS_AS_VAL_ATYP is classified as an OTHER API, it is not intended for direct external integration. It is normally invoked from within the Advanced Studies/Assessment forms and concurrent program layer, and the ETRM records that the package is referenced by one other PL/SQL package, indicating its role as a shared validation dependency. The package header (IGSAS15B.pls revision 115.4, last modified 2002) shows the object has remained stable across the 12.1.1 and 12.2.2 releases, so customisations should call the functions through their wrappers or through the referencing package rather than duplicating the validation logic. Typical invocation points include assessment type maintenance screens, assessment item setup, and any process that must reject activity on a closed assessment type or require at least one assessment item before proceeding. Callers must inspect the returned message name and use FND_MESSAGE to display the corresponding text; the functions deliberately do not raise exceptions themselves.