111: v_message_name VARCHAR2(30);
112:
113: BEGIN
114: IF p_inserting THEN
115: IF IGS_GR_VAL_GAC.grdp_val_gac_insert(
116: new_references.person_id,
117: new_references.create_dt,
118: v_message_name) = FALSE THEN
119: Fnd_Message.Set_Name('IGS', v_message_name);
123: END IF;
124:
125: IF p_inserting OR p_updating THEN
126: -- Validate the graduand award ceremony record may be inserted or updated
127: IF IGS_GR_VAL_GAC.grdp_val_gac_iu(
128: new_references.grd_cal_type,
129: new_references.grd_ci_sequence_number,
130: new_references.ceremony_number,
131: v_message_name) = FALSE THEN
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: -- validate required details have been specified
137: IF IGS_GR_VAL_GAC.grdp_val_gac_rqrd(
138: new_references.award_course_cd,
139: new_references.award_crs_version_number,
140: new_references.award_cd,
141: new_references.us_group_number,
150: -- validate unit set group
151: IF (NVL(new_references.us_group_number, 0) <>
152: NVL(old_references.us_group_number, 0)) THEN
153: IF (new_references.us_group_number IS NOT NULL) THEN
154: IF IGS_GR_VAL_GAC.grdp_val_gac_susa(
155: new_references.person_id,
156: new_references.create_dt,
157: new_references.grd_cal_type,
158: new_references.grd_ci_sequence_number,
173: -- validate measurement codes
174: IF (NVL(new_references.academic_gown_size, 'NULL') <>
175: NVL(old_references.academic_gown_size, 'NULL')) THEN
176: IF (new_references.academic_gown_size IS NOT NULL) THEN
177: IF IGS_GR_VAL_GAC.grdp_val_msr_closed(
178: new_references.academic_gown_size,
179: v_message_name) = FALSE THEN
180: Fnd_Message.Set_Name('IGS', v_message_name);
181: IGS_GE_MSG_STACK.ADD;
185: END IF;
186: IF (NVL(new_references.academic_hat_size, 'NULL') <>
187: NVL(old_references.academic_hat_size, 'NULL')) THEN
188: IF (new_references.academic_hat_size IS NOT NULL) THEN
189: IF IGS_GR_VAL_GAC.grdp_val_msr_closed(
190: new_references.academic_hat_size,
191: v_message_name) = FALSE THEN
192: Fnd_Message.Set_Name('IGS', v_message_name);
193: IGS_GE_MSG_STACK.ADD;
200: IF p_inserting OR (p_updating AND
201: new_references.grd_cal_type <> old_references.grd_cal_type OR
202: new_references.grd_ci_sequence_number <> old_references.grd_ci_sequence_number) THEN
203: -- validate the graduation calendar instance
204: IF IGS_GR_VAL_GAC.grdp_val_gac_grd_ci(
205: new_references.grd_cal_type,
206: new_references.grd_ci_sequence_number,
207: v_message_name) = FALSE THEN
208: Fnd_Message.Set_Name('IGS', v_message_name);
313: NVL(old_references.graduand_seat_number, 'NULL')) THEN
314: IF (new_references.graduand_seat_number IS NOT NULL) THEN
315: -- validate graduand seat number
316: IF (NEW_REFERENCES.graduand_seat_number IS NOT NULL) THEN
317: IF IGS_GR_VAL_GAC.grdp_val_gac_seat(
318: NEW_REFERENCES.person_id,
319: NEW_REFERENCES.grd_cal_type,
320: NEW_REFERENCES.grd_ci_sequence_number,
321: NEW_REFERENCES.ceremony_number,
327: END IF;
328: END IF;
329: -- validate order in presentation
330: IF (NEW_REFERENCES.order_in_presentation IS NOT NULL) THEN
331: IF IGS_GR_VAL_GAC.grdp_val_gac_order(
332: NEW_REFERENCES.person_id,
333: NEW_REFERENCES.grd_cal_type,
334: NEW_REFERENCES.grd_ci_sequence_number,
335: NEW_REFERENCES.ceremony_number,
353: IF v_rowid_saved = FALSE THEN
354:
355: -- validate graduand seat number
356: IF (NEW_REFERENCES.graduand_seat_number IS NOT NULL) THEN
357: IF IGS_GR_VAL_GAC.grdp_val_gac_seat(
358: NEW_REFERENCES.person_id,
359: NEW_REFERENCES.grd_cal_type,
360: NEW_REFERENCES.grd_ci_sequence_number,
361: NEW_REFERENCES.ceremony_number,