DBA Data[Home] [Help]

APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_EN_DROP_UNITS_API

Line 1: PACKAGE BODY igs_en_drop_units_api AS

1: PACKAGE BODY igs_en_drop_units_api AS
2: /* $Header: IGSEN92B.pls 120.13 2006/08/24 07:27:08 bdeviset noship $ */
3:
4: --package variables
5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 73: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.is_unit_subordinate');

69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
73: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.is_unit_subordinate');
74: IGS_GE_MSG_STACK.ADD;
75: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
76: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.is_unit_subordinate :',SQLERRM);
77: END IF;

Line 76: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.is_unit_subordinate :',SQLERRM);

72: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
73: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.is_unit_subordinate');
74: IGS_GE_MSG_STACK.ADD;
75: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
76: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.is_unit_subordinate :',SQLERRM);
77: END IF;
78: RAISE;
79: END is_unit_subordinate;
80:

Line 318: igs_en_drop_units_api.create_ss_warning(

314: RETURN;
315:
316: ELSIF l_deny_warn_core = 'WARN' THEN
317: --create a warning record with message_icon set to "W" IGS_EN_NO_CORE_REM_CRT
318: igs_en_drop_units_api.create_ss_warning(
319: p_person_id => p_person_id,
320: p_course_cd => p_course_cd,
321: p_term_cal_type => p_load_cal_type,
322: p_term_ci_sequence_number => p_load_sequence_number,

Line 384: igs_en_drop_units_api.create_ss_warning(

380: l_message_for := igs_ss_enroll_pkg.enrf_get_lookup_meaning (
381: p_lookup_code => 'FMIN_CRDT',
382: p_lookup_type => 'ENROLMENT_STEP_TYPE_EXT');
383: --create a warning record with message_icon set to "W" IGS_SS_EN_MINIMUM_CP_WARN
384: igs_en_drop_units_api.create_ss_warning(
385: p_person_id => p_person_id,
386: p_course_cd => p_course_cd,
387: p_term_cal_type => p_load_cal_type,
388: p_term_ci_sequence_number => p_load_sequence_number,

Line 438: igs_en_drop_units_api.create_ss_warning(

434: p_lookup_type => 'ENROLMENT_STEP_TYPE_EXT');
435: -- Set message to IGS_SS_EN_ATT_TYP_WARN
436: -- Create a warnign record in the warnings table with message_icon as "WARN" , message_for as the lookup_code of the step.
437: --create a warning record with message_icon set to "W" IGS_SS_EN_MINIMUM_CP_WARN
438: igs_en_drop_units_api.create_ss_warning(
439: p_person_id => p_person_id,
440: p_course_cd => p_course_cd,
441: p_term_cal_type => p_load_cal_type,
442: p_term_ci_sequence_number => p_load_sequence_number,

Line 522: igs_en_drop_units_api.create_ss_warning(

518: OPEN get_unit_dtls(v_ref_cur_rec.uoo_id);
519: FETCH get_unit_dtls INTO l_unit_rec;
520: CLOSE get_unit_dtls;
521:
522: igs_en_drop_units_api.create_ss_warning(
523: p_person_id => p_person_id,
524: p_course_cd => p_course_cd,
525: p_Term_cal_type=>p_load_cal_type,
526: p_term_ci_sequence_number => p_load_sequence_number,

Line 590: igs_en_drop_units_api.create_ss_warning(

586: FETCH get_unit_dtls INTO l_unit_rec;
587: CLOSE get_unit_dtls;
588:
589: -- Create the warning record.
590: igs_en_drop_units_api.create_ss_warning(
591: p_person_id => p_person_id,
592: p_course_cd => p_course_cd,
593: p_Term_cal_type=>p_load_cal_type,
594: p_term_ci_sequence_number => p_load_sequence_number,

Line 649: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_units');

645:
646: WHEN OTHERS THEN
647:
648: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
649: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_units');
650: IGS_GE_MSG_STACK.ADD;
651: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
652: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_units :',SQLERRM);
653: END IF;

Line 652: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_units :',SQLERRM);

648: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
649: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_units');
650: IGS_GE_MSG_STACK.ADD;
651: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
652: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_units :',SQLERRM);
653: END IF;
654: RAISE;
655:
656: END drop_units ;

Line 725: igs_en_drop_units_api.reorder_drop_units (

721:
722: BEGIN
723:
724: l_credit_points := 0;
725: igs_en_drop_units_api.reorder_drop_units (
726: p_person_id => p_person_id ,
727: p_course_cd => p_course_cd,
728: p_start_uoo_id => p_start_uoo_id,
729: p_load_cal_type => p_load_cal_type,

Line 912: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_student_unit_attempts');

908: RAISE;
909:
910: WHEN OTHERS THEN
911: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
912: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_student_unit_attempts');
913: IGS_GE_MSG_STACK.ADD;
914: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
915: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_student_unit_attempts :',SQLERRM);
916: END IF;

Line 915: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_student_unit_attempts :',SQLERRM);

911: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
912: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_student_unit_attempts');
913: IGS_GE_MSG_STACK.ADD;
914: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
915: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_student_unit_attempts :',SQLERRM);
916: END IF;
917: RAISE;
918:
919: END drop_student_unit_attempts;

Line 1003: igs_en_drop_units_api.create_ss_warning(

999: l_grep_uoo_ids := l_grep_uoo_ids||','||l_sub_uooid;
1000:
1001: END IF;
1002:
1003: igs_en_drop_units_api.create_ss_warning(
1004: p_person_id => p_person_id,
1005: p_course_cd => p_course_cd,
1006: p_term_cal_type => p_load_cal_type,
1007: p_term_ci_sequence_number => p_load_ci_seq_num,

Line 1061: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.reorder_drop_units');

1057: RAISE;
1058:
1059: WHEN OTHERS THEN
1060: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1061: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.reorder_drop_units');
1062: IGS_GE_MSG_STACK.ADD;
1063: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1064: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.reorder_drop_units :',SQLERRM);
1065: END IF;

Line 1064: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.reorder_drop_units :',SQLERRM);

1060: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1061: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.reorder_drop_units');
1062: IGS_GE_MSG_STACK.ADD;
1063: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1064: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.reorder_drop_units :',SQLERRM);
1065: END IF;
1066: ROLLBACK;
1067: RAISE;
1068:

Line 1211: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.create_ss_warning');

1207:
1208: WHEN OTHERS THEN
1209:
1210: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1211: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.create_ss_warning');
1212: IGS_GE_MSG_STACK.ADD;
1213: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1214: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.create_ss_warning :',SQLERRM);
1215: END IF;

Line 1214: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.create_ss_warning :',SQLERRM);

1210: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1211: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.create_ss_warning');
1212: IGS_GE_MSG_STACK.ADD;
1213: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1214: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.create_ss_warning :',SQLERRM);
1215: END IF;
1216: ROLLBACK;
1217: RAISE;
1218:

Line 1690: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_ss_unit_attempt');

1686: WHEN OTHERS THEN
1687: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1688: igs_en_add_units_api.g_ss_session_id := NULL;
1689: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1690: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_ss_unit_attempt');
1691: IGS_GE_MSG_STACK.ADD;
1692: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1693: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_ss_unit_attempt :',SQLERRM);
1694: END IF;

Line 1693: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_ss_unit_attempt :',SQLERRM);

1689: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1690: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_ss_unit_attempt');
1691: IGS_GE_MSG_STACK.ADD;
1692: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1693: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.drop_ss_unit_attempt :',SQLERRM);
1694: END IF;
1695: ROLLBACK;
1696: RAISE;
1697:

Line 1837: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.update_dropped_units');

1833: RAISE;
1834: WHEN OTHERS THEN
1835:
1836: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1837: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.update_dropped_units');
1838: IGS_GE_MSG_STACK.ADD;
1839: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1840: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.update_dropped_units:',SQLERRM);
1841: END IF;

Line 1840: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.update_dropped_units:',SQLERRM);

1836: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1837: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.update_dropped_units');
1838: IGS_GE_MSG_STACK.ADD;
1839: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1840: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_drop_units_api.update_dropped_units:',SQLERRM);
1841: END IF;
1842: ROLLBACK;
1843: RAISE;
1844:

Line 1847: END igs_en_drop_units_api;

1843: RAISE;
1844:
1845: END update_dropped_units;
1846:
1847: END igs_en_drop_units_api;