eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_DROP_UNITS_API dependencies on FND_LOG

Line 5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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;
6:
7:
8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

Line 75: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

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;
78: RAISE;
79: END is_unit_subordinate;

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 651: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) 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;
654: RAISE;
655:

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 914: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

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;
917: RAISE;
918:

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 1063: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

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;
1066: ROLLBACK;
1067: RAISE;

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 1213: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) 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;
1216: ROLLBACK;
1217: RAISE;

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 1692: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

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;
1695: ROLLBACK;
1696: RAISE;

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 1839: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) 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;
1842: ROLLBACK;
1843: RAISE;

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: