DBA Data[Home] [Help]

APPS.IGS_EN_GEN_LEGACY dependencies on FND_MESSAGE

Line 65: Fnd_Message.Set_Name( 'IGS' , 'IGS_AS_GRADE_INVALID');

61: FETCH check_grade INTO l_dummy ;
62:
63: IF check_grade%NOTFOUND THEN
64: CLOSE check_grade;
65: Fnd_Message.Set_Name( 'IGS' , 'IGS_AS_GRADE_INVALID');
66: FND_MSG_PUB.ADD;
67: RETURN FALSE ;
68: END IF;
69: CLOSE check_grade;

Line 85: Fnd_Message.Set_Name( 'IGS' , 'IGS_AS_GRADE_INVALID');

81: FETCH check_grade INTO l_dummy ;
82:
83: IF check_grade%NOTFOUND THEN
84: CLOSE check_grade;
85: Fnd_Message.Set_Name( 'IGS' , 'IGS_AS_GRADE_INVALID');
86: FND_MSG_PUB.ADD;
87: RETURN FALSE ;
88: END IF;
89: CLOSE check_grade;

Line 94: Fnd_Message.Set_Name( 'IGS' , 'IGS_PS_ONE_UGSV_DFLT_MARK' );

90:
91: ELSE
92: CLOSE ger_grd_schm_unit ;
93: -- If default grading schema is not found
94: Fnd_Message.Set_Name( 'IGS' , 'IGS_PS_ONE_UGSV_DFLT_MARK' );
95: FND_MSG_PUB.ADD;
96: RETURN FALSE ;
97: END IF ;
98: END IF ;

Line 132: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_DISC_CD_INV');

128: FETCH val_discn_cd INTO l_discn_ind ;
129: CLOSE val_discn_cd ;
130:
131: IF NVL (l_discn_ind , 'N' ) = 'N' THEN
132: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_DISC_CD_INV');
133: FND_MSG_PUB.ADD;
134: RETURN FALSE ;
135: END IF ;
136: RETURN TRUE;

Line 201: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_TRNSFR_UNT_NT_FND');

197: FETCH cnt_unit INTO l_count ;
198: CLOSE cnt_unit ;
199:
200: IF l_count = 0 THEN
201: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_TRNSFR_UNT_NT_FND');
202: FND_MSG_PUB.ADD;
203: RETURN FALSE ;
204: ELSE
205: IF l_count > 1 THEN

Line 206: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_MULTI_PRM_FND');

202: FND_MSG_PUB.ADD;
203: RETURN FALSE ;
204: ELSE
205: IF l_count > 1 THEN
206: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_MULTI_PRM_FND');
207: FND_MSG_PUB.ADD;
208: RETURN FALSE ;
209: ELSIF l_count =1 THEN
210:

Line 215: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_TRN_SUA_STAT_INV');

211: OPEN val_status ;
212: FETCH val_status INTO l_unit_attempt_status;
213: CLOSE val_status ;
214: IF l_unit_attempt_status NOT IN ( 'COMPLETED','DISCONTIN' ) THEN
215: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_TRN_SUA_STAT_INV');
216: FND_MSG_PUB.ADD;
217: RETURN FALSE ;
218: END IF ;
219: END IF ;

Line 277: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_TRNSFR_CD_INV' );

273: OPEN get_prgm_reasn ;
274: FETCH get_prgm_reasn INTO l_dummy;
275: IF get_prgm_reasn%NOTFOUND THEN
276: CLOSE get_prgm_reasn;
277: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_TRNSFR_CD_INV' );
278: FND_MSG_PUB.ADD;
279: RETURN FALSE ;
280: END IF ;
281: CLOSE get_prgm_reasn;

Line 330: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_UNIT_OFR_OPT_NT_FND');

326: FETCH get_uoo_id INTO l_uoo_id , l_org_unit_cd;
327:
328: IF get_uoo_id%NOTFOUND THEN
329: CLOSE get_uoo_id ;
330: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_UNIT_OFR_OPT_NT_FND');
331: FND_MSG_PUB.ADD;
332: RETURN FALSE ;
333: END IF;
334:

Line 393: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_UNT_VER_NA');

389:
390: -- If No matching Unit versions found for a Unit section , Error Out.
391: IF get_unit_ver%NOTFOUND THEN
392: CLOSE get_unit_ver ;
393: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_UNT_VER_NA');
394: FND_MSG_PUB.ADD;
395: RETURN FALSE ;
396: ELSE
397: CLOSE get_unit_ver ;

Line 404: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_MUL_UNT_VER_EXTS');

400: CLOSE get_unit_ver_count ;
401:
402: -- If Multiple Unit versions found for a Unit section , Error Out.
403: IF l_count > 1 THEN
404: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_MUL_UNT_VER_EXTS');
405: FND_MSG_PUB.ADD;
406: RETURN FALSE ;
407: END IF;
408: END IF;

Line 714: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

710: CLOSE cur_coo_id;
711: RETURN l_coo_id;
712: EXCEPTION
713: WHEN OTHERS THEN
714: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
715: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_coo_id');
716: FND_MSG_PUB.ADD;
717: APP_EXCEPTION.RAISE_EXCEPTION;
718: END get_coo_id;

Line 715: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_coo_id');

711: RETURN l_coo_id;
712: EXCEPTION
713: WHEN OTHERS THEN
714: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
715: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_coo_id');
716: FND_MSG_PUB.ADD;
717: APP_EXCEPTION.RAISE_EXCEPTION;
718: END get_coo_id;
719:

Line 752: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

748: CLOSE cur_class_std;
749: RETURN l_igs_pr_class_std_id;
750: EXCEPTION
751: WHEN OTHERS THEN
752: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
753: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_class_std_id');
754: FND_MSG_PUB.ADD;
755: APP_EXCEPTION.RAISE_EXCEPTION;
756: END get_class_std_id;

Line 753: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_class_std_id');

749: RETURN l_igs_pr_class_std_id;
750: EXCEPTION
751: WHEN OTHERS THEN
752: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
753: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_class_std_id');
754: FND_MSG_PUB.ADD;
755: APP_EXCEPTION.RAISE_EXCEPTION;
756: END get_class_std_id;
757:

Line 811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

807: RETURN NVL(l_career_course_att_status,l_course_att_status);
808: END IF;
809: EXCEPTION
810: WHEN OTHERS THEN
811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
812: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_course_att_status');
813: FND_MSG_PUB.ADD;
814: APP_EXCEPTION.RAISE_EXCEPTION;
815: END get_course_att_status;

Line 812: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_course_att_status');

808: END IF;
809: EXCEPTION
810: WHEN OTHERS THEN
811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
812: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_course_att_status');
813: FND_MSG_PUB.ADD;
814: APP_EXCEPTION.RAISE_EXCEPTION;
815: END get_course_att_status;
816:

Line 842: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

838: CLOSE cur_per_type;
839: RETURN l_person_type_code;
840: EXCEPTION
841: WHEN OTHERS THEN
842: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
843: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_sca_dropped_by');
844: FND_MSG_PUB.ADD;
845: APP_EXCEPTION.RAISE_EXCEPTION;
846: END get_sca_dropped_by;

Line 843: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_sca_dropped_by');

839: RETURN l_person_type_code;
840: EXCEPTION
841: WHEN OTHERS THEN
842: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
843: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_sca_dropped_by');
844: FND_MSG_PUB.ADD;
845: APP_EXCEPTION.RAISE_EXCEPTION;
846: END get_sca_dropped_by;
847:

Line 883: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

879: CLOSE cur_cour_typ;
880: RETURN l_course_type;
881: EXCEPTION
882: WHEN OTHERS THEN
883: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
884: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_sca_prog_type');
885: FND_MSG_PUB.ADD;
886: APP_EXCEPTION.RAISE_EXCEPTION;
887: END get_sca_prog_type;

Line 884: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_sca_prog_type');

880: RETURN l_course_type;
881: EXCEPTION
882: WHEN OTHERS THEN
883: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
884: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.get_sca_prog_type');
885: FND_MSG_PUB.ADD;
886: APP_EXCEPTION.RAISE_EXCEPTION;
887: END get_sca_prog_type;
888:

Line 912: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

908: RETURN TRUE;
909: END IF;
910: EXCEPTION
911: WHEN OTHERS THEN
912: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
913: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_start_dt');
914: FND_MSG_PUB.ADD;
915: APP_EXCEPTION.RAISE_EXCEPTION;
916: END val_sca_start_dt;

Line 913: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_start_dt');

909: END IF;
910: EXCEPTION
911: WHEN OTHERS THEN
912: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
913: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_start_dt');
914: FND_MSG_PUB.ADD;
915: APP_EXCEPTION.RAISE_EXCEPTION;
916: END val_sca_start_dt;
917:

Line 939: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

935: RETURN TRUE;
936: END IF;
937: EXCEPTION
938: WHEN OTHERS THEN
939: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
940: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_disc_date');
941: FND_MSG_PUB.ADD;
942: APP_EXCEPTION.RAISE_EXCEPTION;
943: END val_sca_disc_date;

Line 940: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_disc_date');

936: END IF;
937: EXCEPTION
938: WHEN OTHERS THEN
939: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
940: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_disc_date');
941: FND_MSG_PUB.ADD;
942: APP_EXCEPTION.RAISE_EXCEPTION;
943: END val_sca_disc_date;
944:

Line 970: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

966: END IF;
967: RETURN TRUE;
968: EXCEPTION
969: WHEN OTHERS THEN
970: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
971: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_reqcmpl_dt');
972: FND_MSG_PUB.ADD;
973: APP_EXCEPTION.RAISE_EXCEPTION;
974: END val_sca_reqcmpl_dt;

Line 971: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_reqcmpl_dt');

967: RETURN TRUE;
968: EXCEPTION
969: WHEN OTHERS THEN
970: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
971: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_reqcmpl_dt');
972: FND_MSG_PUB.ADD;
973: APP_EXCEPTION.RAISE_EXCEPTION;
974: END val_sca_reqcmpl_dt;
975:

Line 1013: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SCA_NO_KEY_PROG');

1009:
1010: --If count is zero and current program is also not a key program then log the error message.
1011: IF l_key_count =0 AND p_key_program = 'N' AND (p_course_attempt_st <> 'UNCONFIRM') THEN
1012: l_error:=1;
1013: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SCA_NO_KEY_PROG');
1014: FND_MSG_PUB.ADD;
1015: --If count is one and current program is also a key program then log the error message.
1016: ELSIF l_key_count =1 AND p_key_program = 'Y' THEN
1017: l_error:=1;

Line 1018: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_PROG');

1014: FND_MSG_PUB.ADD;
1015: --If count is one and current program is also a key program then log the error message.
1016: ELSIF l_key_count =1 AND p_key_program = 'Y' THEN
1017: l_error:=1;
1018: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_PROG');
1019: FND_MSG_PUB.ADD;
1020: --If count is greater than one then log the error message.
1021: ELSIF l_key_count > 1 THEN
1022: l_error:=1;

Line 1023: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_PRO');

1019: FND_MSG_PUB.ADD;
1020: --If count is greater than one then log the error message.
1021: ELSIF l_key_count > 1 THEN
1022: l_error:=1;
1023: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_PRO');
1024: FND_MSG_PUB.ADD;
1025: END IF;
1026: --In career model, If primary program type is not a primary and key program set to Y then log an error message.
1027: IF p_career_flag = 'Y' AND

Line 1031: FND_MESSAGE.SET_NAME('IGS','IGS_EN_KEY_PROG_NOT_PRIMARY');

1027: IF p_career_flag = 'Y' AND
1028: p_primary_prg_type <> 'PRIMARY' AND
1029: p_key_program ='Y' THEN
1030: l_error:=1;
1031: FND_MESSAGE.SET_NAME('IGS','IGS_EN_KEY_PROG_NOT_PRIMARY');
1032: FND_MSG_PUB.ADD;
1033: END IF;
1034: IF l_error = 1 THEN
1035: RETURN FALSE;

Line 1041: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1037: RETURN TRUE;
1038: END IF;
1039: EXCEPTION
1040: WHEN OTHERS THEN
1041: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1042: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_key_prg');
1043: FND_MSG_PUB.ADD;
1044: APP_EXCEPTION.RAISE_EXCEPTION;
1045: END val_sca_key_prg;

Line 1042: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_key_prg');

1038: END IF;
1039: EXCEPTION
1040: WHEN OTHERS THEN
1041: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1042: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_key_prg');
1043: FND_MSG_PUB.ADD;
1044: APP_EXCEPTION.RAISE_EXCEPTION;
1045: END val_sca_key_prg;
1046:

Line 1073: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRIMARY_PRG_MUST');

1069: l_count NUMBER(3) := 0;
1070: BEGIN
1071: --In career model, primary program type is null then log an error message.
1072: IF p_primary_prog_type IS NULL THEN
1073: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRIMARY_PRG_MUST');
1074: FND_MSG_PUB.ADD;
1075: RETURN FALSE;
1076: END IF;
1077: --In career model, get total number of primary program for a given program type.

Line 1084: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SCA_STDNT_NO_PRIMARY');

1080: CLOSE cur_count;
1081:
1082: --If count is zero and current primary program type is not a primary then log error message.
1083: IF l_count = 0 AND p_primary_prog_type <> 'PRIMARY' THEN
1084: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SCA_STDNT_NO_PRIMARY');
1085: FND_MSG_PUB.ADD;
1086: RETURN FALSE;
1087: --If count is one and current primary program type is a primary then log error message.
1088: ELSIF l_count = 1 AND p_primary_prog_type = 'PRIMARY' THEN

Line 1089: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STDNT_PS_MORE_PRIMARY');

1085: FND_MSG_PUB.ADD;
1086: RETURN FALSE;
1087: --If count is one and current primary program type is a primary then log error message.
1088: ELSIF l_count = 1 AND p_primary_prog_type = 'PRIMARY' THEN
1089: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STDNT_PS_MORE_PRIMARY');
1090: FND_MSG_PUB.ADD;
1091: RETURN FALSE;
1092: --If count is more than one then log error message.
1093: ELSIF l_count > 1 THEN

Line 1094: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STDNT_PS_MORE_PRIMARY');

1090: FND_MSG_PUB.ADD;
1091: RETURN FALSE;
1092: --If count is more than one then log error message.
1093: ELSIF l_count > 1 THEN
1094: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STDNT_PS_MORE_PRIMARY');
1095: FND_MSG_PUB.ADD;
1096: RETURN FALSE;
1097: ELSE
1098: RETURN TRUE;

Line 1102: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1098: RETURN TRUE;
1099: END IF;
1100: EXCEPTION
1101: WHEN OTHERS THEN
1102: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1103: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_primary_pg');
1104: FND_MSG_PUB.ADD;
1105: APP_EXCEPTION.RAISE_EXCEPTION;
1106: END val_sca_primary_pg;

Line 1103: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_primary_pg');

1099: END IF;
1100: EXCEPTION
1101: WHEN OTHERS THEN
1102: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1103: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_primary_pg');
1104: FND_MSG_PUB.ADD;
1105: APP_EXCEPTION.RAISE_EXCEPTION;
1106: END val_sca_primary_pg;
1107:

Line 1132: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1128: RETURN TRUE;
1129: END IF;
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1133: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_comp_flag');
1134: FND_MSG_PUB.ADD;
1135: APP_EXCEPTION.RAISE_EXCEPTION;
1136: END val_sca_comp_flag;

Line 1133: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_comp_flag');

1129: END IF;
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1133: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_comp_flag');
1134: FND_MSG_PUB.ADD;
1135: APP_EXCEPTION.RAISE_EXCEPTION;
1136: END val_sca_comp_flag;
1137:

Line 1297: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PERSON_TYPE_NOTFOUND');

1293: OPEN cur_per_type('STUDENT');
1294: FETCH cur_per_type INTO l_person_type_code;
1295: IF cur_per_type%NOTFOUND THEN
1296: l_error := 1;
1297: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PERSON_TYPE_NOTFOUND');
1298: FND_MESSAGE.SET_TOKEN('TYPE','STUDENT');
1299: FND_MSG_PUB.ADD;
1300: ELSE
1301: --Check whether person type instance of type STUDENT is exist for the given person id

Line 1298: FND_MESSAGE.SET_TOKEN('TYPE','STUDENT');

1294: FETCH cur_per_type INTO l_person_type_code;
1295: IF cur_per_type%NOTFOUND THEN
1296: l_error := 1;
1297: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PERSON_TYPE_NOTFOUND');
1298: FND_MESSAGE.SET_TOKEN('TYPE','STUDENT');
1299: FND_MSG_PUB.ADD;
1300: ELSE
1301: --Check whether person type instance of type STUDENT is exist for the given person id
1302: --If not exist then create the person type instance of type STUDENT

Line 1428: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PERSON_TYPE_NOTFOUND');

1424: OPEN cur_per_type('FORMER_STUDENT');
1425: FETCH cur_per_type INTO l_person_type_code;
1426: IF cur_per_type%NOTFOUND THEN
1427: l_error := 1;
1428: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PERSON_TYPE_NOTFOUND');
1429: FND_MESSAGE.SET_TOKEN('TYPE','FORMER_STUDENT');
1430: FND_MSG_PUB.ADD;
1431: ELSE
1432: --Check whether person type instance of type FORMER_STUDENT is exist for the given person id

Line 1429: FND_MESSAGE.SET_TOKEN('TYPE','FORMER_STUDENT');

1425: FETCH cur_per_type INTO l_person_type_code;
1426: IF cur_per_type%NOTFOUND THEN
1427: l_error := 1;
1428: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PERSON_TYPE_NOTFOUND');
1429: FND_MESSAGE.SET_TOKEN('TYPE','FORMER_STUDENT');
1430: FND_MSG_PUB.ADD;
1431: ELSE
1432: --Check whether person type instance of type FORMER_STUDENT is exist for the given person id
1433: -- If not exist then create the person type instance of type FORMER_STUDENT

Line 1508: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1504: RETURN TRUE;
1505: END IF;
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1509: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_per_type');
1510: FND_MSG_PUB.ADD;
1511: APP_EXCEPTION.RAISE_EXCEPTION;
1512: END val_sca_per_type;

Line 1509: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_per_type');

1505: END IF;
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1509: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.val_sca_per_type');
1510: FND_MSG_PUB.ADD;
1511: APP_EXCEPTION.RAISE_EXCEPTION;
1512: END val_sca_per_type;
1513:

Line 1559: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1555: END IF;
1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1560: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_pre_enroll_prof');
1561: FND_MSG_PUB.Add;
1562: App_Exception.Raise_Exception;
1563:

Line 1560: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_pre_enroll_prof');

1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1560: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_pre_enroll_prof');
1561: FND_MSG_PUB.Add;
1562: App_Exception.Raise_Exception;
1563:
1564: END check_pre_enroll_prof;

Line 1656: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1652: END IF;
1653:
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1657: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_usa_overlap');
1658: FND_MSG_PUB.Add;
1659: App_Exception.Raise_Exception;
1660:

Line 1657: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_usa_overlap');

1653:
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1657: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_usa_overlap');
1658: FND_MSG_PUB.Add;
1659: App_Exception.Raise_Exception;
1660:
1661: END check_usa_overlap;

Line 1709: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1705: END IF;
1706:
1707: EXCEPTION
1708: WHEN OTHERS THEN
1709: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1710: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_dup_susa');
1711: FND_MSG_PUB.Add;
1712: App_Exception.Raise_Exception;
1713:

Line 1710: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_dup_susa');

1706:
1707: EXCEPTION
1708: WHEN OTHERS THEN
1709: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1710: FND_MESSAGE.SET_TOKEN('NAME', 'igs_en_gen_legacy.check_dup_susa');
1711: FND_MSG_PUB.Add;
1712: App_Exception.Raise_Exception;
1713:
1714: END check_dup_susa;