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_ADD_UNITS_API dependencies on IGS_EN_ADD_UNITS_API

Line 1: PACKAGE BODY igs_en_add_units_api AS

1: PACKAGE BODY igs_en_add_units_api AS
2: /* $Header: IGSEN93B.pls 120.39 2006/08/25 13:55:14 bdeviset noship $ */
3:
4: --package variables
5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 96: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.set_deny_warn :',SQLERRM);

92: EXCEPTION
93: WHEN OTHERS THEN
94:
95: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
96: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.set_deny_warn :',SQLERRM);
97: END IF;
98: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
99: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.set_deny_warn');
100: IGS_GE_MSG_STACK.ADD;

Line 99: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.set_deny_warn');

95: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
96: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.set_deny_warn :',SQLERRM);
97: END IF;
98: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
99: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.set_deny_warn');
100: IGS_GE_MSG_STACK.ADD;
101: RAISE;
102: END set_deny_warn;
103:

Line 196: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_exists');

192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
196: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_exists');
197: IGS_GE_MSG_STACK.ADD;
198: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
199: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_exists :',SQLERRM);
200: END IF;

Line 199: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_exists :',SQLERRM);

195: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
196: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_exists');
197: IGS_GE_MSG_STACK.ADD;
198: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
199: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_exists :',SQLERRM);
200: END IF;
201: ROLLBACK;
202: RAISE;
203:

Line 325: x_session_id => igs_en_add_units_api.g_ss_session_id,

321: x_message_action => l_warn_rec.message_action,
322: x_destination => l_warn_rec.destination,
323: x_p_parameters => l_warn_rec.p_parameters,
324: x_step_type => l_warn_rec.step_type,
325: x_session_id => igs_en_add_units_api.g_ss_session_id,
326: x_mode => 'R' );
327: END LOOP;
328:
329:

Line 339: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.update_warnings_table');

335:
336: EXCEPTION
337: WHEN OTHERS THEN
338: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
339: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.update_warnings_table');
340: IGS_GE_MSG_STACK.ADD;
341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.update_warnings_table :',SQLERRM);
343: END IF;

Line 342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.update_warnings_table :',SQLERRM);

338: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
339: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.update_warnings_table');
340: IGS_GE_MSG_STACK.ADD;
341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.update_warnings_table :',SQLERRM);
343: END IF;
344: ROLLBACK;
345: RAISE;
346:

Line 381: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_unit_sec :',SQLERRM);

377: EXCEPTION
378: WHEN OTHERS THEN
379:
380: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
381: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_unit_sec :',SQLERRM);
382: END IF;
383: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
384: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_unit_sec');
385: IGS_GE_MSG_STACK.ADD;

Line 384: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_unit_sec');

380: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
381: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_unit_sec :',SQLERRM);
382: END IF;
383: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
384: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_unit_sec');
385: IGS_GE_MSG_STACK.ADD;
386: RAISE;
387: END get_unit_sec;
388:

Line 426: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_person_type :',SQLERRM);

422: EXCEPTION
423: WHEN OTHERS THEN
424:
425: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
426: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_person_type :',SQLERRM);
427: END IF;
428: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
429: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_person_type');
430: IGS_GE_MSG_STACK.ADD;

Line 429: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_person_type');

425: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
426: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_person_type :',SQLERRM);
427: END IF;
428: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
429: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_person_type');
430: IGS_GE_MSG_STACK.ADD;
431: RAISE;
432: END get_person_type;
433:

Line 540: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_ss_warnings :',SQLERRM);

536: EXCEPTION
537: WHEN OTHERS THEN
538:
539: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
540: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_ss_warnings :',SQLERRM);
541: END IF;
542: ROLLBACK;
543: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
544: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_ss_warnings');

Line 544: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_ss_warnings');

540: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_ss_warnings :',SQLERRM);
541: END IF;
542: ROLLBACK;
543: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
544: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_ss_warnings');
545: IGS_GE_MSG_STACK.ADD;
546: RAISE;
547:
548: END delete_ss_warnings;

Line 699: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_creation_is_valid :',SQLERRM);

695: EXCEPTION
696:
697: WHEN OTHERS THEN
698: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
699: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_creation_is_valid :',SQLERRM);
700: END IF;
701: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
702: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_creation_is_valid');
703: IGS_GE_MSG_STACK.ADD;

Line 702: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_creation_is_valid');

698: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
699: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_creation_is_valid :',SQLERRM);
700: END IF;
701: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
702: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_creation_is_valid');
703: IGS_GE_MSG_STACK.ADD;
704: RAISE;
705: END chk_sua_creation_is_valid;
706:

Line 775: x_session_id => igs_en_add_units_api.g_ss_session_id,

771: x_gs_version_number => p_gs_version_number,--unit_dtls_rec,
772: x_core_indicator_code => NULL,--unit_dtls_rec,
773: x_alternative_title => NULL,--unit_dtls_rec,
774: x_cart_error_flag => p_cart_error_flag,
775: x_session_id => igs_en_add_units_api.g_ss_session_id,
776: x_mode => 'R'
777: );
778: ELSE
779: CLOSE c1;

Line 818: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_ps_record :',SQLERRM);

814:
815: WHEN OTHERS THEN
816:
817: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
818: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_ps_record :',SQLERRM);
819: END IF;
820: ROLLBACK;
821: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
822: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_ps_record');

Line 822: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_ps_record');

818: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_ps_record :',SQLERRM);
819: END IF;
820: ROLLBACK;
821: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
822: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_ps_record');
823: IGS_GE_MSG_STACK.ADD;
824: RAISE;
825:
826: END create_ps_record;

Line 883: x_session_id => igs_en_add_units_api.g_ss_session_id,

879: x_gs_version_number => p_gs_version_number,--unit_dtls_rec,
880: x_core_indicator_code => NULL,--unit_dtls_rec,
881: x_alternative_title => NULL,--unit_dtls_rec,
882: x_cart_error_flag => p_cart_error_flag,
883: x_session_id => igs_en_add_units_api.g_ss_session_id,
884: x_mode => 'R'
885: );
886:
887:

Line 920: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_cart_error :',SQLERRM);

916:
917: WHEN OTHERS THEN
918:
919: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
920: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_cart_error :',SQLERRM);
921: END IF;
922: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
923: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_cart_error');
924: IGS_GE_MSG_STACK.ADD;

Line 923: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_cart_error');

919: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
920: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_cart_error :',SQLERRM);
921: END IF;
922: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
923: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_cart_error');
924: IGS_GE_MSG_STACK.ADD;
925: RAISE;
926:
927: END create_cart_error;

Line 997: p_session_id => igs_en_add_units_api.g_ss_session_id,

993: (p_person_number => l_person_number,
994: p_course_cd => p_course_cd ,
995: p_uoo_id => p_uoo_id,
996: p_waitlist_ind => 'N',
997: p_session_id => igs_en_add_units_api.g_ss_session_id,
998: p_return_status => p_return_status,
999: p_message => p_message,
1000: p_cal_type => p_load_cal_type,
1001: p_ci_sequence_number => p_load_sequence_number,

Line 1071: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua :',SQLERRM);

1067:
1068: WHEN OTHERS THEN
1069:
1070: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1071: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua :',SQLERRM);
1072: END IF;
1073: ROLLBACK;
1074: IF SQLCODE = -1 THEN
1075: l_unit_sec := get_unit_sec(p_uoo_id);

Line 1081: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua');

1077: p_message := 'IGS_EN_SUA_EXISTS'||'*'||l_unit_sec;
1078: RETURN;
1079: ELSE
1080: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1081: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua');
1082: IGS_GE_MSG_STACK.ADD;
1083: RAISE;
1084: END IF;
1085:

Line 1157: p_session_id => igs_en_add_units_api.g_ss_session_id,

1153: (p_person_number => l_person_number,
1154: p_course_cd => p_course_cd ,
1155: p_uoo_id => p_uoo_id,
1156: p_waitlist_ind => p_waitlist_ind,
1157: p_session_id => igs_en_add_units_api.g_ss_session_id,
1158: p_return_status => p_return_status,
1159: p_message => p_message,
1160: p_cal_type => p_load_cal_type,
1161: p_ci_sequence_number => p_load_sequence_number,

Line 1233: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua_from_plan :',SQLERRM);

1229:
1230: WHEN OTHERS THEN
1231:
1232: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1233: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua_from_plan :',SQLERRM);
1234: END IF;
1235: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1236: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua_from_plan');
1237: IGS_GE_MSG_STACK.ADD;

Line 1236: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua_from_plan');

1232: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1233: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua_from_plan :',SQLERRM);
1234: END IF;
1235: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1236: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua_from_plan');
1237: IGS_GE_MSG_STACK.ADD;
1238: RAISE;
1239:
1240: END create_sua_from_plan;

Line 1411: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_perm_wlst_setup :',SQLERRM);

1407:
1408: WHEN OTHERS THEN
1409:
1410: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1411: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_perm_wlst_setup :',SQLERRM);
1412: END IF;
1413: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1414: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_perm_wlst_setup');
1415: IGS_GE_MSG_STACK.ADD;

Line 1414: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_perm_wlst_setup');

1410: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1411: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_perm_wlst_setup :',SQLERRM);
1412: END IF;
1413: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1414: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_perm_wlst_setup');
1415: IGS_GE_MSG_STACK.ADD;
1416: RAISE;
1417: END get_perm_wlst_setup;
1418:

Line 1770: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.permission_required :',SQLERRM);

1766: EXCEPTION
1767: WHEN OTHERS THEN
1768:
1769: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1770: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.permission_required :',SQLERRM);
1771: END IF;
1772: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1773: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.permission_required');
1774: IGS_GE_MSG_STACK.ADD;

Line 1773: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.permission_required');

1769: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1770: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.permission_required :',SQLERRM);
1771: END IF;
1772: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1773: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.permission_required');
1774: IGS_GE_MSG_STACK.ADD;
1775: RAISE;
1776: END permission_required;
1777:

Line 1939: p_session_id => igs_en_add_units_api.g_ss_session_id,

1935: p_person_number => l_person_number,
1936: p_course_cd => p_course_cd ,
1937: p_uoo_id => p_uoo_id,
1938: p_waitlist_ind => 'Y',
1939: p_session_id => igs_en_add_units_api.g_ss_session_id,
1940: p_return_status => l_return_status,
1941: p_message => p_message,
1942: p_cal_type => p_load_cal_type,
1943: p_ci_sequence_number => p_load_sequence_number,

Line 2067: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.waitlist_required :',SQLERRM);

2063: END IF;
2064:
2065: WHEN OTHERS THEN
2066: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2067: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.waitlist_required :',SQLERRM);
2068: END IF;
2069: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2070: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.waitlist_required');
2071: IGS_GE_MSG_STACK.ADD;

Line 2070: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.waitlist_required');

2066: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2067: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.waitlist_required :',SQLERRM);
2068: END IF;
2069: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2070: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.waitlist_required');
2071: IGS_GE_MSG_STACK.ADD;
2072: RAISE;
2073: END waitlist_required;
2074:

Line 2195: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.validate_enr_encb :',SQLERRM);

2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2195: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.validate_enr_encb :',SQLERRM);
2196: END IF;
2197: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2198: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.validate_enr_encb');
2199: IGS_GE_MSG_STACK.ADD;

Line 2198: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.validate_enr_encb');

2194: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2195: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.validate_enr_encb :',SQLERRM);
2196: END IF;
2197: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2198: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.validate_enr_encb');
2199: IGS_GE_MSG_STACK.ADD;
2200: RAISE;
2201:
2202: END validate_enr_encmb;

Line 2706: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.reorder_uoo_ids :',SQLERRM);

2702: END IF;
2703: EXCEPTION
2704: WHEN OTHERS THEN
2705: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2706: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.reorder_uoo_ids :',SQLERRM);
2707: END IF;
2708: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2709: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.reorder_uoo_ids');
2710: IGS_GE_MSG_STACK.ADD;

Line 2709: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.reorder_uoo_ids');

2705: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2706: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.reorder_uoo_ids :',SQLERRM);
2707: END IF;
2708: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2709: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.reorder_uoo_ids');
2710: IGS_GE_MSG_STACK.ADD;
2711: RAISE;
2712:
2713: END reorder_uoo_ids;

Line 3033: igs_en_add_units_api.g_ss_session_id, -- session_id,

3029: NULL, -- RSV_SEAT_EXT_ID ,
3030: NULL, -- ORG_UNIT_CD ,
3031: p_unit_params(i).grading_schema_cd, -- GRADING_SCHEMA_CODE ,
3032: NULL, -- subtitle,
3033: igs_en_add_units_api.g_ss_session_id, -- session_id,
3034: NULL, -- deg_aud_detail_id,
3035: NULL, -- student_career_transcript,
3036: NULL, -- student_career_statistics,
3037: NULL, -- waitlist_manual_ind ,--Bug ID: 2554109 added by adhawan

Line 3108: SESSION_ID = igs_en_add_units_api.g_ss_session_id,

3104: RSV_SEAT_EXT_ID = NULL,
3105: ORG_UNIT_CD = NULL,
3106: GRADING_SCHEMA_CODE = p_unit_params(i).grading_schema_cd,
3107: SUBTITLE = NULL,
3108: SESSION_ID = igs_en_add_units_api.g_ss_session_id,
3109: DEG_AUD_DETAIL_ID = NULL,
3110: STUDENT_CAREER_TRANSCRIPT = NULL,
3111: STUDENT_CAREER_STATISTICS = NULL,
3112: WAITLIST_MANUAL_IND = NULL,

Line 3266: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.eval_cart_max :',SQLERRM);

3262: EXCEPTION
3263: -- In case of exception rollback and return false.
3264: WHEN OTHERS THEN
3265: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
3266: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.eval_cart_max :',SQLERRM);
3267: END IF;
3268: ROLLBACK;
3269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3270: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.eval_cart_max');

Line 3270: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.eval_cart_max');

3266: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.eval_cart_max :',SQLERRM);
3267: END IF;
3268: ROLLBACK;
3269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3270: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.eval_cart_max');
3271: IGS_GE_MSG_STACK.ADD;
3272: RAISE;
3273: END eval_cart_max;
3274:

Line 3580: X_SESSION_ID => igs_en_add_units_api.g_ss_session_id ,

3576: X_CART => NULL ,
3577: X_RSV_SEAT_EXT_ID => NULL ,
3578: X_ORG_UNIT_CD => NULL ,
3579: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3580: X_SESSION_ID => igs_en_add_units_api.g_ss_session_id ,
3581: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
3582: X_GRADING_SCHEMA_CODE => p_unit_params(i).grading_schema_cd ,
3583: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208) - pradhakr
3584: X_DEG_AUD_DETAIL_ID => NULL,

Line 4093: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_planned_sua :',SQLERRM);

4089: EXCEPTION
4090: WHEN OTHERS THEN
4091: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
4092: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
4093: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_planned_sua :',SQLERRM);
4094: END IF;
4095: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4096: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_planned_sua');
4097: IGS_GE_MSG_STACK.ADD;

Line 4096: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_planned_sua');

4092: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
4093: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_planned_sua :',SQLERRM);
4094: END IF;
4095: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4096: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_planned_sua');
4097: IGS_GE_MSG_STACK.ADD;
4098: RAISE;
4099:
4100: END create_planned_sua;

Line 4342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_unconfirm_sua :',SQLERRM);

4338: EXCEPTION
4339: WHEN OTHERS THEN
4340:
4341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
4342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_unconfirm_sua :',SQLERRM);
4343: END IF;
4344: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4345: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_unconfirm_sua');
4346: IGS_GE_MSG_STACK.ADD;

Line 4345: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_unconfirm_sua');

4341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
4342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_unconfirm_sua :',SQLERRM);
4343: END IF;
4344: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4345: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_unconfirm_sua');
4346: IGS_GE_MSG_STACK.ADD;
4347: RAISE;
4348:
4349: END create_unconfirm_sua;

Line 4989: IF (INSTR(','||igs_en_add_units_api.g_swap_failed_uooids||',' , ','||l_uoo_id||',') <> 0) THEN

4985: END IF;
4986:
4987: -- if the uooid exists in the list of the uooids list failed prereq and coreq
4988: -- rules because of swapping the passed units
4989: IF (INSTR(','||igs_en_add_units_api.g_swap_failed_uooids||',' , ','||l_uoo_id||',') <> 0) THEN
4990:
4991: l_unit_sec := get_unit_sec(l_uoo_id);
4992: IF l_deny_warn_coreq IS NOT NULL THEN
4993:

Line 5073: END IF; --IF (INSTR(','||igs_en_add_units_api.g_swap_failed_uooids||',' , ','||l_uoo_id||',') = 0) THEN

5069: END IF; -- IF NOT IGS_EN_ELGBL_UNIT.eval_prereq
5070:
5071: END IF; --IF l_deny_warn_prereq IS NOT NULL THEN
5072:
5073: END IF; --IF (INSTR(','||igs_en_add_units_api.g_swap_failed_uooids||',' , ','||l_uoo_id||',') = 0) THEN
5074:
5075: END LOOP; -- WHILE TRUE LOOP
5076:
5077: END IF; -- IF p_calling_obj In ( 'SWAP','SUBMITSWAP') THEN

Line 5089: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_enroll_sua :',SQLERRM);

5085: RETURN;
5086:
5087: WHEN OTHERS THEN
5088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5089: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_enroll_sua :',SQLERRM);
5090: END IF;
5091: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5092: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_enroll_sua');
5093: IGS_GE_MSG_STACK.ADD;

Line 5092: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_enroll_sua');

5088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5089: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_enroll_sua :',SQLERRM);
5090: END IF;
5091: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5092: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_enroll_sua');
5093: IGS_GE_MSG_STACK.ADD;
5094: RAISE;
5095: END create_enroll_sua;
5096:

Line 5149: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_plan_error_records');

5145:
5146: EXCEPTION
5147: WHEN OTHERS THEN
5148: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5149: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_plan_error_records');
5150: IGS_GE_MSG_STACK.ADD;
5151: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5152: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_plan_error_records :',SQLERRM);
5153: END IF;

Line 5152: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_plan_error_records :',SQLERRM);

5148: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5149: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_plan_error_records');
5150: IGS_GE_MSG_STACK.ADD;
5151: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5152: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_plan_error_records :',SQLERRM);
5153: END IF;
5154: ROLLBACK;
5155: RAISE;
5156:

Line 5212: igs_en_add_units_api.g_ss_session_id := p_ss_session_id;

5208: BEGIN
5209:
5210: SAVEPOINT sp_add_units_api;
5211:
5212: igs_en_add_units_api.g_ss_session_id := p_ss_session_id;
5213:
5214: p_return_status := 'TRUE';
5215: IF p_calling_obj IS NULL OR p_calling_obj NOT IN ('SWAP', 'SUBMITSWAP','CART','SUBMITCART','ENROLPEND','SCHEDULE','PLAN','SUBMITPLAN') THEN
5216: p_message := 'IGS_EN_INVALID_CALLINGOBJ';

Line 5219: igs_en_add_units_api.g_ss_session_id := NULL;

5215: IF p_calling_obj IS NULL OR p_calling_obj NOT IN ('SWAP', 'SUBMITSWAP','CART','SUBMITCART','ENROLPEND','SCHEDULE','PLAN','SUBMITPLAN') THEN
5216: p_message := 'IGS_EN_INVALID_CALLINGOBJ';
5217: p_return_status := 'FALSE';
5218: p_deny_warn := 'D';
5219: igs_en_add_units_api.g_ss_session_id := NULL;
5220: RETURN;
5221: END IF;
5222:
5223: IF p_calling_obj NOT IN ('PLAN','SUBMITPLAN') THEN

Line 5233: igs_en_add_units_api.g_ss_session_id := NULL;

5229: p_message);
5230: IF p_message IS NOT NULL THEN
5231: p_return_status := 'FALSE';
5232: p_deny_warn := 'D';
5233: igs_en_add_units_api.g_ss_session_id := NULL;
5234: RETURN;
5235: END IF;
5236: END IF; -- end of IF p_calling_obj IS NOT IN ('PLAN','SUBMITPLAN') THEN
5237: -- get the person type

Line 5251: igs_en_add_units_api.g_ss_session_id := NULL;

5247:
5248: p_message := l_message_name;
5249: p_return_status := 'FALSE';
5250: p_deny_warn := 'D';
5251: igs_en_add_units_api.g_ss_session_id := NULL;
5252: RETURN;
5253:
5254: END IF ;
5255:

Line 5270: igs_en_add_units_api.g_ss_session_id := NULL;

5266:
5267: p_message := l_message_name;
5268: p_return_status := 'FALSE';
5269: p_deny_warn := 'D';
5270: igs_en_add_units_api.g_ss_session_id := NULL;
5271: RETURN;
5272:
5273: END IF;
5274:

Line 5318: igs_en_add_units_api.g_ss_session_id := NULL;

5314: IF l_message_name IS NOT NULL THEN
5315: p_message := l_message_name;
5316: p_return_status := 'FALSE';
5317: p_deny_warn := 'D';
5318: igs_en_add_units_api.g_ss_session_id := NULL;
5319: RETURN;
5320: END IF;
5321:
5322: END IF;

Line 5360: igs_en_add_units_api.g_ss_session_id := NULL;

5356: 'Y'); --chk wailist setup also
5357: IF l_return_status = 'FALSE' THEN
5358: p_return_status := 'FALSE';
5359: p_deny_warn := 'D';
5360: igs_en_add_units_api.g_ss_session_id := NULL;
5361: RETURN;
5362: END IF;
5363:
5364: IF p_calling_obj = 'PLAN' THEN

Line 5387: igs_en_add_units_api.g_ss_session_id := NULL;

5383:
5384: IF l_return_status = 'FALSE' THEN
5385: p_return_status := 'FALSE';
5386: p_deny_warn := 'D';
5387: igs_en_add_units_api.g_ss_session_id := NULL;
5388: RETURN;
5389: END IF;
5390:
5391: ELSE

Line 5413: igs_en_add_units_api.g_ss_session_id := NULL;

5409:
5410: p_return_status := 'FALSE';
5411: p_deny_warn := 'D';
5412: ROLLBACK TO sp_add_units_api;
5413: igs_en_add_units_api.g_ss_session_id := NULL;
5414: RETURN;
5415:
5416: END IF; -- IF NOT eval_cart_max(
5417:

Line 5442: igs_en_add_units_api.g_ss_session_id := NULL;

5438: IF l_return_status = 'FALSE' THEN
5439: p_return_status := 'FALSE';
5440: p_deny_warn := 'D';
5441: ROLLBACK TO sp_unconfirm_sua;
5442: igs_en_add_units_api.g_ss_session_id := NULL;
5443: RETURN;
5444: END IF;
5445:
5446:

Line 5481: igs_en_add_units_api.g_ss_session_id := NULL;

5477:
5478: IF l_return_status = 'FALSE' AND l_message_name IS NOT NULL THEN
5479: p_return_status := 'FALSE';
5480: p_message := l_message_name;
5481: igs_en_add_units_api.g_ss_session_id := NULL;
5482: RETURN;
5483: END IF;
5484:
5485: -- create warning record if waitlisted unit has been created succesfully.

Line 5546: igs_en_add_units_api.g_ss_session_id := NULL;

5542: IF l_return_status = 'FALSE' THEN
5543: p_return_status := 'FALSE';
5544: p_deny_warn := 'D';
5545: ROLLBACK TO sp_unconfirm_Sua;
5546: igs_en_add_units_api.g_ss_session_id := NULL;
5547: RETURN;
5548: END IF;
5549:
5550: -- Incase of cart and swap rollback till sp_unconfirm_sua

Line 5606: igs_en_add_units_api.g_ss_session_id := NULL;

5602: p_course_cd,
5603: p_load_cal_type,
5604: p_load_sequence_number);
5605:
5606: igs_en_add_units_api.g_ss_session_id := NULL;
5607: EXCEPTION
5608:
5609: WHEN OTHERS THEN
5610: igs_en_add_units_api.g_ss_session_id := NULL;

Line 5610: igs_en_add_units_api.g_ss_session_id := NULL;

5606: igs_en_add_units_api.g_ss_session_id := NULL;
5607: EXCEPTION
5608:
5609: WHEN OTHERS THEN
5610: igs_en_add_units_api.g_ss_session_id := NULL;
5611: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
5612: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5613: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.add_selected_units :',SQLERRM);
5614: END IF;

Line 5613: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.add_selected_units :',SQLERRM);

5609: WHEN OTHERS THEN
5610: igs_en_add_units_api.g_ss_session_id := NULL;
5611: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
5612: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5613: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.add_selected_units :',SQLERRM);
5614: END IF;
5615: ROLLBACK TO sp_add_units_api;
5616: p_deny_warn := 'D';
5617: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 5618: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.add_selected_units');

5614: END IF;
5615: ROLLBACK TO sp_add_units_api;
5616: p_deny_warn := 'D';
5617: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5618: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.add_selected_units');
5619: IGS_GE_MSG_STACK.ADD;
5620: RAISE;
5621: END add_selected_units;
5622:

Line 5649: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_unrelated_warnings :',SQLERRM);

5645: COMMIT;
5646: EXCEPTION
5647: WHEN OTHERS THEN
5648: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5649: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_unrelated_warnings :',SQLERRM);
5650: END IF;
5651: ROLLBACK;
5652: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5653: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_ADD_UNITS_API.delete_unrelated_warnings');

Line 5653: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_ADD_UNITS_API.delete_unrelated_warnings');

5649: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_unrelated_warnings :',SQLERRM);
5650: END IF;
5651: ROLLBACK;
5652: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5653: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_ADD_UNITS_API.delete_unrelated_warnings');
5654: IGS_GE_MSG_STACK.ADD;
5655: RAISE;
5656: END delete_unrelated_warnings;
5657:

Line 5658: END IGS_EN_ADD_UNITS_API;

5654: IGS_GE_MSG_STACK.ADD;
5655: RAISE;
5656: END delete_unrelated_warnings;
5657:
5658: END IGS_EN_ADD_UNITS_API;