DBA Data[Home] [Help]

APPS.IGS_EN_GEN_LEGACY dependencies on FND_MSG_PUB

Line 66: FND_MSG_PUB.ADD;

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;
70:

Line 86: FND_MSG_PUB.ADD;

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;
90:

Line 95: FND_MSG_PUB.ADD;

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 ;
99:

Line 133: FND_MSG_PUB.ADD;

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;
137:

Line 202: FND_MSG_PUB.ADD;

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
206: Fnd_Message.Set_Name( 'IGS' , 'IGS_EN_MULTI_PRM_FND');

Line 207: 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:
211: OPEN val_status ;

Line 216: FND_MSG_PUB.ADD;

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 ;
220: END IF;

Line 278: FND_MSG_PUB.ADD;

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;
282:

Line 331: FND_MSG_PUB.ADD;

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:
335: CLOSE get_uoo_id ;

Line 394: FND_MSG_PUB.ADD;

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 ;
398: OPEN get_unit_ver_count ;

Line 405: FND_MSG_PUB.ADD;

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;
409: p_version_number := l_version_number;

Line 716: FND_MSG_PUB.ADD;

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:
720:

Line 754: FND_MSG_PUB.ADD;

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:
758: FUNCTION get_course_att_status(

Line 813: FND_MSG_PUB.ADD;

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:
817:

Line 844: FND_MSG_PUB.ADD;

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:
848:

Line 885: FND_MSG_PUB.ADD;

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:
889:

Line 914: FND_MSG_PUB.ADD;

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:
918:

Line 941: FND_MSG_PUB.ADD;

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:
945:

Line 972: FND_MSG_PUB.ADD;

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:
976:

Line 1014: FND_MSG_PUB.ADD;

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;
1018: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_PROG');

Line 1019: 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;
1023: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_PRO');

Line 1024: 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
1028: p_primary_prg_type <> 'PRIMARY' AND

Line 1032: FND_MSG_PUB.ADD;

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;
1036: ELSE

Line 1043: FND_MSG_PUB.ADD;

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:
1047:

Line 1074: FND_MSG_PUB.ADD;

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.
1078: OPEN cur_count;

Line 1085: FND_MSG_PUB.ADD;

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
1089: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STDNT_PS_MORE_PRIMARY');

Line 1090: 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
1094: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STDNT_PS_MORE_PRIMARY');

Line 1095: 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;
1099: END IF;

Line 1104: FND_MSG_PUB.ADD;

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:
1108:

Line 1134: FND_MSG_PUB.ADD;

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:
1138: PROCEDURE raise_person_type_event(

Line 1299: FND_MSG_PUB.ADD;

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
1303: OPEN cur_per_inst('STUDENT');

Line 1430: FND_MSG_PUB.ADD;

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
1434: OPEN cur_per_inst('FORMER_STUDENT');

Line 1510: FND_MSG_PUB.ADD;

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:
1514:

Line 1561: FND_MSG_PUB.Add;

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;
1565:

Line 1658: FND_MSG_PUB.Add;

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;
1662:

Line 1711: FND_MSG_PUB.Add;

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;
1715: