Search Results igs_ge_record_already_exists

Overview

IGS_AD_VAL_APCOO is a validation package body in the Oracle EBS Advanced Education / Student System (IGS) product family, owned by the APPS schema. Its name derives from "Admissions Validation — Admission Period Course Offering Option." The package centralizes the business rules that determine whether a course offering, option, or linked offering is valid for a given admission period and admission category before admissions data is created or updated. It is a typical ETRM "OTHER"-classified API: a server-side validation layer called indirectly by admissions forms, concurrent processes, and other IGS packages rather than being exposed as a standalone public interface.

The user search term igs_ge_record_already_exists refers to the generic IGS error-message constant commonly raised through the message-name OUT parameter convention used by this package. When a duplicate or already-existing combination is detected (for example, a default admission period course offering option that is already defined), the calling layer surfaces the standard "record already exists" message. IGS_AD_VAL_APCOO itself returns BOOLEAN success/failure plus a message name; the duplicate-detection semantics are part of that contract.

Key Procedures and Functions

• ADMP_VAL_APCOO_CO — Validates that a course offering pattern is valid for an admission period. It queries IGS_CA_INST_REL joined to IGS_PS_OFR_PAT to confirm that a course/version/calendar combination is offered and flagged as an entry point for the admission calendar instance. Returns a message name via an OUT parameter.
• ADMP_VAL_APCOO_LINKS — Validates the linkage relationships between the admission period, admission process, and the course offering options attached to them.
• ADMP_INS_DFLT_APCOO — Inserts or establishes the default admission period course offering option record, applying validation beforehand.
• ADMP_VAL_APCOO_OPT — Validates an individual admission period course offering option against the parent admission period and offering option definitions.
• GENP_VAL_OPTNL_COO — Generic validation of optional course offering option attributes.
• CRSP_VAL_AM_CLOSED — Checks whether the related admission method (AM) is administratively closed. Includes a PRAGMA (per Bug 1956374) to control inlining/restriction behavior.
• CRSP_VAL_ATT_CLOSED — Checks whether the attendance type/mode is closed, preventing use of inactive attendance definitions; also carries the pragma added under Bug 1956374.

Tables Accessed

• IGS_AD_PRD_AD_PRC_CA — Admission period to admission process calendar association; drives which offerings are in scope.
• IGS_AD_PRD_PS_OF_OPT — Admission period to program/offering option mapping; the core validated entity.
• IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S — Sequence-number generator for the offering option records created by ADMP_INS_DFLT_APCOO.
• IGS_CA_INST_REL — Calendar instance relationship linking the admission calendar to the academic calendar.
• IGS_PS_OFR_PAT — Course offering pattern, filtered on offered_ind and entry_point_ind.
• DUAL — Used for scalar validation checks.

Usage Notes

The package is referenced by five other IGS packages and is normally invoked from admissions setup forms and from packages that admit applicants or maintain admission period offering options. It is not intended for direct external calls; customizations should call the higher-level admissions APIs and allow the validation layer to raise the standard IGS messages, including the "record already exists" condition. Because all tables are accessed through APPS synonyms, grants on APPS objects are sufficient.