DBA Data[Home] [Help]

APPS.IGS_EN_TRANSFER_APIS dependencies on FND_LOG

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

31: -------------------------------------------------------------------------------------------*/
32:
33:
34: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_EN_TRANSFER_APIS';
35: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
36: g_transfer_dt DATE;
37: FUNCTION is_career_model_enabled RETURN BOOLEAN AS
38: -------------------------------------------------------------------------------------------
39: --Created by : Chandrasekhar Kasu, Oracle IDC

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

345: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
346: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
347: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_destination_prgm');
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:

Line 350: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.update_destination_prgm :',SQLERRM);

346: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
347: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_destination_prgm');
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;

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

453: WHEN OTHERS THEN
454: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
455: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.set_dest_prgm_att_params');
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:

Line 458: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.set_dest_prgm_att_params :',SQLERRM);

454: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
455: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.set_dest_prgm_att_params');
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;

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

533: WHEN OTHERS THEN
534: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
535: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_set_att');
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:

Line 538: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.create_prgm_admin_record :',SQLERRM);

534: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
535: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_set_att');
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;

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

627: WHEN OTHERS THEN
628: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
629: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_is_dest_prgm_actv_confrm');
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:

Line 632: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.check_is_dest_prgm_actv_confrm :',SQLERRM);

628: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
629: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_is_dest_prgm_actv_confrm');
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;

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

695: WHEN OTHERS THEN
696: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
697: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_for_debt');
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:

Line 700: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.check_for_debt :',SQLERRM);

696: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
697: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_for_debt');
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;

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

814: WHEN OTHERS THEN
815: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
816: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_for_holds');
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:

Line 819: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.check_for_holds :',SQLERRM);

815: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
816: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_for_holds');
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;

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

896: WHEN OTHERS THEN
897: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
898: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.enrp_val_excld_unit_pt');
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:

Line 901: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.enrp_val_excld_unit_pt :',SQLERRM);

897: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
898: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.enrp_val_excld_unit_pt');
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;

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

956: WHEN OTHERS THEN
957: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
958: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.upd_or_create_dest_term_rec');
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:

Line 961: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.upd_or_create_dest_term_rec :',SQLERRM);

957: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
958: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.upd_or_create_dest_term_rec');
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;

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

1069: WHEN OTHERS THEN
1070: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1071: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.getunits_in_src_notin_dest_prg');
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:

Line 1074: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.getunits_in_src_notin_dest_prg :',SQLERRM);

1070: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1071: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.getunits_in_src_notin_dest_prg');
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;

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

1136: WHEN OTHERS THEN
1137: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1138: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.val_unchk_sub_units');
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:

Line 1141: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.val_unchk_sub_units :',SQLERRM);

1137: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1138: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.val_unchk_sub_units');
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;

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

1250: WHEN OTHERS THEN
1251: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1252: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_person_steps');
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:

Line 1255: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_person_steps :',SQLERRM);

1251: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1252: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_person_steps');
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;

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

1358: WHEN OTHERS THEN
1359: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1360: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_candidacy_tran_dtls');
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:

Line 1363: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_candidacy_tran_dtls :',SQLERRM);

1359: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1360: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_candidacy_tran_dtls');
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;

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

1428: WHEN OTHERS THEN
1429: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1430: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_advance_st_tran_dtls');
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:

Line 1433: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_advance_st_tran_dtls :',SQLERRM);

1429: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1430: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_advance_st_tran_dtls');
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;

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

2025: WHEN OTHERS THEN
2026: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2027: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_attempts');
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:

Line 2030: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_src_prgm_unt_attempts :',SQLERRM);

2026: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2027: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_attempts');
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;

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

2335: WHEN OTHERS THEN
2336: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2337: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_prgm_attend_type_step');
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;

Line 2340: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_prgm_attend_type_step :',SQLERRM);

2336: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2337: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_prgm_attend_type_step');
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:

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

2737: WHEN OTHERS THEN
2738: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2739: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_set_att');
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:

Line 2742: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.validate_src_prgm_unt_set_att :',SQLERRM);

2738: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2739: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_set_att');
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;

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

2976: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2977: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2978: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_source_prgm');
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:

Line 2981: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.update_source_prgm :',SQLERRM);

2977: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2978: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_source_prgm');
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;

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

3602: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3603: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3605: p_data => p_msg_data);
3606: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
3607: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.program_transfer_api :',SQLERRM);
3608: END IF;
3609: ROLLBACK TO TRANSFER_PRGM;
3610: WHEN OTHERS THEN

Line 3607: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.program_transfer_api :',SQLERRM);

3603: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3605: p_data => p_msg_data);
3606: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
3607: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.program_transfer_api :',SQLERRM);
3608: END IF;
3609: ROLLBACK TO TRANSFER_PRGM;
3610: WHEN OTHERS THEN
3611: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

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

3615: l_api_name);
3616: END IF;
3617: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3618: p_data => p_msg_data);
3619: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
3620: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.program_transfer_api :',SQLERRM);
3621: END IF;
3622: ROLLBACK TO TRANSFER_PRGM;
3623:

Line 3620: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.program_transfer_api :',SQLERRM);

3616: END IF;
3617: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3618: p_data => p_msg_data);
3619: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
3620: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.program_transfer_api :',SQLERRM);
3621: END IF;
3622: ROLLBACK TO TRANSFER_PRGM;
3623:
3624: END PROGRAM_TRANSFER_API;