53: IF p_person_id IS NULL OR
54: p_effective_dt IS NULL OR
55: p_encmb_effect_type IS NULL THEN
56: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
57: App_Exception.Raise_Exception;
58:
59: END IF;
60: --2. Look for an encumbrance with a matching encumbrance type effect.
61: v_pen_found := FALSE;
97: EXCEPTION
98: WHEN OTHERS THEN
99: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END enrp_val_encmb_efct;
103: --
104: -- Validate graduand student course attempt is a graduating course.
105: FUNCTION grdp_val_gr_sca(
163: EXCEPTION
164: WHEN OTHERS THEN
165: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END grdp_val_gr_sca;
169: --
170: -- Validate Graduand Ceremony Round calendar instance.
171: FUNCTION grdp_val_gr_crd_ci(
212: EXCEPTION
213: WHEN OTHERS THEN
214: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END grdp_val_gr_crd_ci;
218: --
219: -- Validate GRADUAND required details.
220: FUNCTION grdp_val_gr_rqrd(
275: EXCEPTION
276: WHEN NO_DATA_FOUND THEN
277: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: END;
281: -- Check if course award details are required
282: IF p_course_cd IS NULL THEN
283: -- Honorary award
331: EXCEPTION
332: WHEN OTHERS THEN
333: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END grdp_val_gr_rqrd;
337: --
338: -- Validate graduand status.
339: FUNCTION grdp_val_gr_gst(
538: EXCEPTION
539: WHEN OTHERS THEN
540: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
541: IGS_GE_MSG_STACK.ADD;
542: App_Exception.Raise_Exception;
543: END grdp_val_gr_gst;
544: --
545: -- Validate graduand approval status.
546: FUNCTION grdp_val_gr_gas(
627: EXCEPTION
628: WHEN OTHERS THEN
629: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
630: IGS_GE_MSG_STACK.ADD;
631: App_Exception.Raise_Exception;
632: END grdp_val_gr_gas;
633: --
634: -- Validate system graduand type.
635: FUNCTION GRDP_VAL_GR_TYPE(
775: EXCEPTION
776: WHEN OTHERS THEN
777: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
778: IGS_GE_MSG_STACK.ADD;
779: App_Exception.Raise_Exception;
780: END grdp_val_gr_type;
781: --
782: -- Validate proxy details.
783: FUNCTION grdp_val_gr_proxy(
861: EXCEPTION
862: WHEN OTHERS THEN
863: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
864: IGS_GE_MSG_STACK.ADD;
865: App_Exception.Raise_Exception;
866: END grdp_val_gr_proxy;
867: --
868: -- Check for multiple instances of the same award for the person.
869: FUNCTION grdp_val_gr_unique(
948: EXCEPTION
949: WHEN OTHERS THEN
950: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
951: IGS_GE_MSG_STACK.ADD;
952: App_Exception.Raise_Exception;
953: END grdp_val_gr_unique;
954: --
955: -- Validate the update of a graduand with graduand awards ceremonies.
956: FUNCTION grdp_val_gr_upd(
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1047: IGS_GE_MSG_STACK.ADD;
1048: App_Exception.Raise_Exception;
1049: END grdp_val_gr_upd;
1050: --
1051: -- Validate inserting or updating a graduand.
1052: FUNCTION grdp_val_gr_iu(
1113: EXCEPTION
1114: WHEN OTHERS THEN
1115: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1116: IGS_GE_MSG_STACK.ADD;
1117: App_Exception.Raise_Exception;
1118: END grdp_val_gr_iu;
1119: --
1120: -- Validate the graduand has satisfied academic requirements for an award
1121: FUNCTION grdp_val_aw_eligible(
1158: (p_award_course_cd IS NULL OR
1159: p_award_crs_version_number IS NULL)) THEN
1160: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
1161: IGS_GE_MSG_STACK.ADD;
1162: App_Exception.Raise_Exception;
1163: END IF;
1164: --2. Check if an honorary award rather than a course award is being given
1165: IF p_course_cd IS NULL THEN
1166: RETURN TRUE;
1209: EXCEPTION
1210: WHEN OTHERS THEN
1211: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1212: IGS_GE_MSG_STACK.ADD;
1213: App_Exception.Raise_Exception;
1214: END grdp_val_aw_eligible;
1215: --
1216: -- Validate graduand course award.
1217: FUNCTION grdp_val_gr_caw(
1283: EXCEPTION
1284: WHEN OTHERS THEN
1285: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1286: IGS_GE_MSG_STACK.ADD;
1287: App_Exception.Raise_Exception;
1288: END grdp_val_gr_caw;
1289: --
1290: -- Validate if graduand approval status is closed.
1291: FUNCTION grdp_val_gas_closed(
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1325: IGS_GE_MSG_STACK.ADD;
1326: App_Exception.Raise_Exception;
1327: END grdp_val_gas_closed;
1328: --
1329: -- Validate if graduand status is closed.
1330: FUNCTION grdp_val_gst_closed(
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1364: IGS_GE_MSG_STACK.ADD;
1365: App_Exception.Raise_Exception;
1366: END grdp_val_gst_closed;
1367: --
1368: --validate if IGS_GR_HONOURS_LEVEL.honours_level is closed
1369: FUNCTION grdp_val_hl_closed(
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1458: IGS_GE_MSG_STACK.ADD;
1459: App_Exception.Raise_Exception;
1460: END grdp_val_gr_sur_caw;
1461: END IGS_GR_VAL_GR;