[Home] [Help]
52: Fetch cur_old_ref_values INTO old_references;
53: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
54: Close cur_old_ref_values;
55: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
56: IGS_GE_MSG_STACK.ADD;
57: App_Exception.Raise_Exception;
58: Return;
59: END IF;
60: Close cur_old_ref_values;
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);
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123: END IF;
124:
129: new_references.grd_ci_sequence_number,
130: new_references.ceremony_number,
131: v_message_name) = FALSE THEN
132: Fnd_Message.Set_Name('IGS', v_message_name);
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(
143: new_references.academic_gown_size,
144: new_references.academic_hat_size,
145: v_message_name) = FALSE THEN
146: Fnd_Message.Set_Name('IGS', v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: -- validate unit set group
151: IF (NVL(new_references.us_group_number, 0) <>
164: new_references.award_cd,
165: new_references.us_group_number,
166: v_message_name) = FALSE THEN
167: Fnd_Message.Set_Name('IGS', v_message_name);
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;
172: END IF;
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;
182: App_Exception.Raise_Exception;
183: END IF;
184: END IF;
185: END IF;
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;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197: END IF;
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);
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
213:
227: new_references.award_crs_version_number,
228: new_references.award_cd,
229: v_message_name) = FALSE THEN
230: Fnd_Message.Set_Name('IGS', v_message_name);
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: END IF;
234: END IF;
235:
252: new_references.award_cd,
253: new_references.us_group_number,
254: v_message_name) = FALSE THEN
255: Fnd_Message.Set_Name('IGS', v_message_name);
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259: END IF;
260: END IF;
285: old_references.award_crs_version_number,
286: old_references.award_cd,
287: v_message_name) = FALSE THEN
288: Fnd_Message.Set_Name('IGS', v_message_name);
289: IGS_GE_MSG_STACK.ADD;
290: App_Exception.Raise_Exception;
291: END IF;
292:
293:
321: NEW_REFERENCES.ceremony_number,
322: NEW_REFERENCES.graduand_seat_number,
323: v_message_name) = FALSE THEN
324: Fnd_Message.Set_Name('IGS', v_message_name);
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: END IF;
328: END IF;
329: -- validate order in presentation
335: NEW_REFERENCES.ceremony_number,
336: NEW_REFERENCES.order_in_presentation,
337: v_message_name) = FALSE THEN
338: Fnd_Message.Set_Name('IGS', v_message_name);
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: END IF;
342: END IF;
343: v_rowid_saved := TRUE;
361: NEW_REFERENCES.ceremony_number,
362: NEW_REFERENCES.graduand_seat_number,
363: v_message_name) = FALSE THEN
364: Fnd_Message.Set_Name('IGS', v_message_name);
365: IGS_GE_MSG_STACK.ADD;
366: App_Exception.Raise_Exception;
367: END IF;
368: END IF;
369:
446: old_references.award_crs_version_number,
447: old_references.award_cd,
448: v_message_name) = FALSE THEN
449: Fnd_Message.Set_Name('IGS', v_message_name);
450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END IF;
453: END IF;
454:
480: IF NOT IGS_GE_MEASUREMENT_PKG.Get_PK_For_Validation (
481: new_references.academic_gown_size
482: ) THEN
483: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
484: IGS_GE_MSG_STACK.ADD;
485: APP_EXCEPTION.RAISE_EXCEPTION;
486: END IF;
487: END IF;
488:
505: new_references.award_crs_version_number,
506: new_references.award_cd
507: ) THEN
508: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
509: IGS_GE_MSG_STACK.ADD;
510: APP_EXCEPTION.RAISE_EXCEPTION;
511: END IF;
512: END IF;
513:
675: END IF;
676: IF ((UPPER (column_name) = 'ACADEMIC_GOWN_SIZE') OR (column_name IS NULL)) THEN
677: IF (new_references.ACADEMIC_GOWN_SIZE <> UPPER (new_references.ACADEMIC_GOWN_SIZE)) THEN
678: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
679: IGS_GE_MSG_STACK.ADD;
680: App_Exception.Raise_Exception;
681: END IF;
682: END IF;
683: IF ((UPPER (column_name) = 'ACADEMIC_HAT_SIZE') OR (column_name IS NULL)) THEN
682: END IF;
683: IF ((UPPER (column_name) = 'ACADEMIC_HAT_SIZE') OR (column_name IS NULL)) THEN
684: IF (new_references.ACADEMIC_HAT_SIZE <> UPPER (new_references.ACADEMIC_HAT_SIZE)) THEN
685: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
686: IGS_GE_MSG_STACK.ADD;
687: App_Exception.Raise_Exception;
688: END IF;
689: END IF;
690: IF ((UPPER (column_name) = 'AWARD_CD') OR (column_name IS NULL)) THEN
689: END IF;
690: IF ((UPPER (column_name) = 'AWARD_CD') OR (column_name IS NULL)) THEN
691: IF (new_references.AWARD_CD <> UPPER (new_references.AWARD_CD)) THEN
692: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
693: IGS_GE_MSG_STACK.ADD;
694: App_Exception.Raise_Exception;
695: END IF;
696: END IF;
697: IF ((UPPER (column_name) = 'AWARD_COURSE_CD') OR (column_name IS NULL)) THEN
696: END IF;
697: IF ((UPPER (column_name) = 'AWARD_COURSE_CD') OR (column_name IS NULL)) THEN
698: IF (new_references.AWARD_COURSE_CD <> UPPER (new_references.AWARD_COURSE_CD)) THEN
699: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
700: IGS_GE_MSG_STACK.ADD;
701: App_Exception.Raise_Exception;
702: END IF;
703: END IF;
704: IF upper(column_name) = 'FEES_PAID_IND' OR column_name is null then
709: END IF;
710: IF ((UPPER (column_name) = 'GRADUAND_SEAT_NUMBER') OR (column_name IS NULL)) THEN
711: IF (new_references.GRADUAND_SEAT_NUMBER <> UPPER (new_references.GRADUAND_SEAT_NUMBER)) THEN
712: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
713: IGS_GE_MSG_STACK.ADD;
714: App_Exception.Raise_Exception;
715: END IF;
716: END IF;
717: IF ((UPPER (column_name) = 'GRD_CAL_TYPE') OR (column_name IS NULL)) THEN
716: END IF;
717: IF ((UPPER (column_name) = 'GRD_CAL_TYPE') OR (column_name IS NULL)) THEN
718: IF (new_references.GRD_CAL_TYPE <> UPPER (new_references.GRD_CAL_TYPE)) THEN
719: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
720: IGS_GE_MSG_STACK.ADD;
721: App_Exception.Raise_Exception;
722: END IF;
723: END IF;
724: IF ((UPPER (column_name) = 'GUEST_SEATS') OR (column_name IS NULL)) THEN
723: END IF;
724: IF ((UPPER (column_name) = 'GUEST_SEATS') OR (column_name IS NULL)) THEN
725: IF (new_references.GUEST_SEATS <> UPPER (new_references.GUEST_SEATS)) THEN
726: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
727: IGS_GE_MSG_STACK.ADD;
728: App_Exception.Raise_Exception;
729: END IF;
730: END IF;
731: IF ((UPPER (column_name) = 'NAME_ANNOUNCED') OR (column_name IS NULL)) THEN
730: END IF;
731: IF ((UPPER (column_name) = 'NAME_ANNOUNCED') OR (column_name IS NULL)) THEN
732: IF (new_references.NAME_ANNOUNCED <> UPPER (new_references.NAME_ANNOUNCED)) THEN
733: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
734: IGS_GE_MSG_STACK.ADD;
735: App_Exception.Raise_Exception;
736: END IF;
737: END IF;
738: END Check_Constraints;
824: Fetch cur_rowid INTO lv_rowid;
825: IF (cur_rowid%FOUND) THEN
826: Close cur_rowid;
827: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_CRD_FK');
828: IGS_GE_MSG_STACK.ADD;
829: App_Exception.Raise_Exception;
830: Return;
831: END IF;
832: Close cur_rowid;
851: Fetch cur_rowid INTO lv_rowid;
852: IF (cur_rowid%FOUND) THEN
853: Close cur_rowid;
854: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_GOWN_MSR_FK');
855: IGS_GE_MSG_STACK.ADD;
856: App_Exception.Raise_Exception;
857: Return;
858: END IF;
859: Close cur_rowid;
885: Fetch cur_rowid INTO lv_rowid;
886: IF (cur_rowid%FOUND) THEN
887: Close cur_rowid;
888: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_GR_FK');
889: IGS_GE_MSG_STACK.ADD;
890: App_Exception.Raise_Exception;
891: Return;
892: END IF;
893: Close cur_rowid;
923: Fetch cur_rowid INTO lv_rowid;
924: IF (cur_rowid%FOUND) THEN
925: Close cur_rowid;
926: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_ACUSG_FK');
927: IGS_GE_MSG_STACK.ADD;
928: App_Exception.Raise_Exception;
929: Return;
930: END IF;
931: Close cur_rowid;
959: Fetch cur_rowid INTO lv_rowid;
960: IF (cur_rowid%FOUND) THEN
961: Close cur_rowid;
962: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GAC_AWC_FK');
963: IGS_GE_MSG_STACK.ADD;
964: App_Exception.Raise_Exception;
965: Return;
966: END IF;
967: Close cur_rowid;
1043: p_deleting => FALSE);
1044: IF Get_PK_For_Validation (
1045: NEW_REFERENCES.gac_id) THEN
1046: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1047: IGS_GE_MSG_STACK.ADD;
1048: App_Exception.Raise_Exception;
1049: END IF;
1050: Check_Uniqueness;
1051: Check_Constraints;
1060: Check_Parent_Existance;
1061: ELSIF (p_action = 'VALIDATE_INSERT') THEN
1062: IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.GAC_ID) THEN
1063: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1064: IGS_GE_MSG_STACK.ADD;
1065: App_Exception.Raise_Exception;
1066: END IF;
1067: check_uniqueness;
1068: check_constraints;