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_TRANSFER_APIS dependencies on APP_EXCEPTION

Line 329: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

325: CLOSE c_get_stdnt_ps_att_dtls;
326:
327: EXCEPTION
328:
329: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);

Line 352: App_Exception.Raise_Exception;

348: IGS_GE_MSG_STACK.ADD;
349: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
350: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.update_destination_prgm :',SQLERRM);
351: END IF;
352: App_Exception.Raise_Exception;
353:
354: END update_destination_prgm;
355:
356:

Line 449: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

445: RETURN;
446: END IF;
447:
448: EXCEPTION
449: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
450: RAISE;
451: WHEN FND_API.G_EXC_ERROR THEN
452: RAISE;
453: WHEN OTHERS THEN

Line 460: App_Exception.Raise_Exception;

456: IGS_GE_MSG_STACK.ADD;
457: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
458: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.set_dest_prgm_att_params :',SQLERRM);
459: END IF;
460: App_Exception.Raise_Exception;
461:
462: END set_dest_prgm_att_params;
463:
464: PROCEDURE create_prgm_admin_record (

Line 529: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

525: CLOSE c_get_enrolment_cal_type;
526: END IF; -- end of c_get_enrolment_cal_type%FOUND IF THEN
527:
528: EXCEPTION
529: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
530: RAISE;
531: WHEN FND_API.G_EXC_ERROR THEN
532: RAISE;
533: WHEN OTHERS THEN

Line 540: App_Exception.Raise_Exception;

536: IGS_GE_MSG_STACK.ADD;
537: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
538: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.create_prgm_admin_record :',SQLERRM);
539: END IF;
540: App_Exception.Raise_Exception;
541:
542: END create_prgm_admin_record;
543:
544:

Line 623: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

619: p_dest_confirmed_ind := 'Y';
620:
621: EXCEPTION
622:
623: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
624: RAISE;
625: WHEN FND_API.G_EXC_ERROR THEN
626: RAISE;
627: WHEN OTHERS THEN

Line 634: App_Exception.Raise_Exception;

630: IGS_GE_MSG_STACK.ADD;
631: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
632: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.check_is_dest_prgm_actv_confrm :',SQLERRM);
633: END IF;
634: App_Exception.Raise_Exception;
635:
636: END check_is_dest_prgm_actv_confrm;
637:
638:

Line 691: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

687: CLOSE c_getdebt_for_all_prgms;
688: END IF;
689:
690: EXCEPTION
691: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
692: RAISE;
693: WHEN FND_API.G_EXC_ERROR THEN
694: RAISE;
695: WHEN OTHERS THEN

Line 702: App_Exception.Raise_Exception;

698: IGS_GE_MSG_STACK.ADD;
699: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
700: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.check_for_debt :',SQLERRM);
701: END IF;
702: App_Exception.Raise_Exception;
703:
704: END check_for_debt;
705:
706: PROCEDURE check_for_holds(

Line 810: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

806:
807:
808:
809: EXCEPTION
810: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
811: RAISE;
812: WHEN FND_API.G_EXC_ERROR THEN
813: RAISE;
814: WHEN OTHERS THEN

Line 821: App_Exception.Raise_Exception;

817: IGS_GE_MSG_STACK.ADD;
818: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
819: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.check_for_holds :',SQLERRM);
820: END IF;
821: App_Exception.Raise_Exception;
822:
823: END check_for_holds;
824:
825: FUNCTION enrp_val_excld_unit_pt(

Line 892: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

888: p_message_name := null;
889: RETURN TRUE;
890: END;
891: EXCEPTION
892: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
893: RAISE;
894: WHEN FND_API.G_EXC_ERROR THEN
895: RAISE;
896: WHEN OTHERS THEN

Line 903: App_Exception.Raise_Exception;

899: IGS_GE_MSG_STACK.ADD;
900: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
901: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.enrp_val_excld_unit_pt :',SQLERRM);
902: END IF;
903: App_Exception.Raise_Exception;
904:
905: END enrp_val_excld_unit_pt;
906:
907:

Line 952: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

948:
949: END IF;
950:
951: EXCEPTION
952: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
953: RAISE;
954: WHEN FND_API.G_EXC_ERROR THEN
955: RAISE;
956: WHEN OTHERS THEN

Line 963: App_Exception.Raise_Exception;

959: IGS_GE_MSG_STACK.ADD;
960: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
961: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.upd_or_create_dest_term_rec :',SQLERRM);
962: END IF;
963: App_Exception.Raise_Exception;
964:
965: END upd_or_create_dest_term_rec;
966:
967: FUNCTION is_tranfer_across_careers(

Line 1065: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1061: FND_MSG_PUB.ADD;
1062: END IF;
1063:
1064: EXCEPTION
1065: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1066: RAISE;
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: RAISE;
1069: WHEN OTHERS THEN

Line 1076: App_Exception.Raise_Exception;

1072: IGS_GE_MSG_STACK.ADD;
1073: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1074: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.getunits_in_src_notin_dest_prg :',SQLERRM);
1075: END IF;
1076: App_Exception.Raise_Exception;
1077:
1078: END getunits_in_src_notin_dest_prg;
1079:
1080:

Line 1132: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1128: FND_MSG_PUB.ADD;
1129: END IF;
1130:
1131: EXCEPTION
1132: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1133: RAISE;
1134: WHEN FND_API.G_EXC_ERROR THEN
1135: RAISE;
1136: WHEN OTHERS THEN

Line 1143: App_Exception.Raise_Exception;

1139: IGS_GE_MSG_STACK.ADD;
1140: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1141: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.val_unchk_sub_units :',SQLERRM);
1142: END IF;
1143: App_Exception.Raise_Exception;
1144:
1145: END val_unchk_sub_units;
1146:
1147:

Line 1246: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1242: END IF; -- end of l_personsteps_vald_status = 'FALSE' AND l_deny_warn = 'DENY' IF THEN
1243:
1244:
1245: EXCEPTION
1246: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1247: RAISE;
1248: WHEN FND_API.G_EXC_ERROR THEN
1249: RAISE;
1250: WHEN OTHERS THEN

Line 1257: App_Exception.Raise_Exception;

1253: IGS_GE_MSG_STACK.ADD;
1254: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1255: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_person_steps :',SQLERRM);
1256: END IF;
1257: App_Exception.Raise_Exception;
1258:
1259: END validate_person_steps;
1260:
1261:

Line 1354: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1350: END IF;
1351: END IF;
1352:
1353: EXCEPTION
1354: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1355: RAISE;
1356: WHEN FND_API.G_EXC_ERROR THEN
1357: RAISE;
1358: WHEN OTHERS THEN

Line 1365: App_Exception.Raise_Exception;

1361: IGS_GE_MSG_STACK.ADD;
1362: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1363: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_candidacy_tran_dtls :',SQLERRM);
1364: END IF;
1365: App_Exception.Raise_Exception;
1366:
1367: END validate_candidacy_tran_dtls;
1368:
1369:

Line 1424: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1420: FND_MSG_PUB.ADD;
1421: END IF;-- end of l_message_name IF THEN
1422:
1423: EXCEPTION
1424: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1425: RAISE;
1426: WHEN FND_API.G_EXC_ERROR THEN
1427: RAISE;
1428: WHEN OTHERS THEN

Line 1435: App_Exception.Raise_Exception;

1431: IGS_GE_MSG_STACK.ADD;
1432: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1433: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_advance_st_tran_dtls :',SQLERRM);
1434: END IF;
1435: App_Exception.Raise_Exception;
1436:
1437: END validate_advance_st_tran_dtls;
1438:
1439: FUNCTION is_sua_enroll_eff_fut_term( p_person_id IN NUMBER,

Line 2021: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

2017:
2018:
2019:
2020: EXCEPTION
2021: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2022: RAISE;
2023: WHEN FND_API.G_EXC_ERROR THEN
2024: RAISE;
2025: WHEN OTHERS THEN

Line 2032: App_Exception.Raise_Exception;

2028: IGS_GE_MSG_STACK.ADD;
2029: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2030: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_src_prgm_unt_attempts :',SQLERRM);
2031: END IF;
2032: App_Exception.Raise_Exception;
2033:
2034: END validate_src_prgm_unt_attempts;
2035:
2036:

Line 2331: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

2327:
2328:
2329:
2330: EXCEPTION
2331: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2332: RAISE;
2333: WHEN FND_API.G_EXC_ERROR THEN
2334: RAISE;
2335: WHEN OTHERS THEN

Line 2342: App_Exception.Raise_Exception;

2338: IGS_GE_MSG_STACK.ADD;
2339: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2340: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_prgm_attend_type_step :',SQLERRM);
2341: END IF;
2342: App_Exception.Raise_Exception;
2343: END validate_prgm_attend_type_step;
2344:
2345: PROCEDURE validate_src_prgm_unt_set_att(
2346: p_person_id IN NUMBER,

Line 2733: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

2729:
2730: END LOOP;-- end of WHILE LOOP
2731:
2732: EXCEPTION
2733: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2734: RAISE;
2735: WHEN FND_API.G_EXC_ERROR THEN
2736: RAISE;
2737: WHEN OTHERS THEN

Line 2744: App_Exception.Raise_Exception;

2740: IGS_GE_MSG_STACK.ADD;
2741: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2742: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_src_prgm_unt_set_att :',SQLERRM);
2743: END IF;
2744: App_Exception.Raise_Exception;
2745:
2746: END validate_src_prgm_unt_set_att;
2747:
2748: PROCEDURE update_source_prgm (

Line 2969: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

2965:
2966: END IF;-- end of p_discontinue_source = 'Y' AND p_dest_fut_dt_trans_flag = 'N' IF THEN
2967:
2968: EXCEPTION
2969: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2970: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2971: RAISE;
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

Line 2983: App_Exception.Raise_Exception;

2979: IGS_GE_MSG_STACK.ADD;
2980: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
2981: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.update_source_prgm :',SQLERRM);
2982: END IF;
2983: App_Exception.Raise_Exception;
2984:
2985: END update_source_prgm;
2986:
2987:

Line 3587: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

3583: ROLLBACK TO TRANSFER_PRGM;
3584: END IF;
3585:
3586: EXCEPTION
3587: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3588: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3589: p_return_status := FND_API.G_RET_STS_ERROR;
3590: FND_MESSAGE.SET_ENCODED(FND_MESSAGE.GET_ENCODED());
3591: FND_MSG_PUB.ADD;