[Home] [Help]
1: PACKAGE BODY igs_en_gen_legacy AS
2: /* $Header: IGSEN91B.pls 120.5 2006/04/25 23:37:19 stutta ship $ */
3:
4: FUNCTION validate_grading_schm (
5: p_grade IN VARCHAR2 ,
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
1153: Change History
1154: Who When What
1155: ***********************************************************************************************/
1156:
1157: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_en_gen_legacy.raise_person_type_event';
1158: l_label VARCHAR2(500);
1159: l_debug_str VARCHAR2(3200);
1160:
1161: CURSOR get_active_inst_cur(cp_person_id hz_parties.party_id%type,
1171: l_max_active_date DATE;
1172: BEGIN
1173:
1174: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1175: l_label := 'igs.plsql.igs_en_gen_legacy.raise_person_type_event.'||p_action;
1176: l_debug_str := 'Person Type Code : '||p_person_type_code||'/'|| ' Person id : ' ||p_person_id ||'/'||
1177: ' Start Date :'||p_person_type_start_date ||'/'||' End Date :' ||p_person_type_end_date;
1178: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1179: END IF;
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:
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;
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;
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;
2026: RETURN FALSE;
2027: END IF;
2028: END validate_awd_offer_pgm;
2029:
2030: END igs_en_gen_legacy;