DBA Data[Home] [Help]

APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_EN_TRANSFER_APIS

Line 1: PACKAGE BODY IGS_EN_TRANSFER_APIS AS

1: PACKAGE BODY IGS_EN_TRANSFER_APIS AS
2: /* $Header: IGSEN82B.pls 120.18 2006/09/15 09:00:19 bdeviset noship $ */
3: /*-------------------------------------------------------------------------------------------
4: Created by : Chandrasekhar Kasu, Oracle Student Systems Oracle IDC
5:

Line 34: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_EN_TRANSFER_APIS';

30:
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: -------------------------------------------------------------------------------------------

Line 347: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_destination_prgm');

343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
344: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
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;

Line 455: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.set_dest_prgm_att_params');

451: WHEN FND_API.G_EXC_ERROR THEN
452: RAISE;
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;

Line 535: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_set_att');

531: WHEN FND_API.G_EXC_ERROR THEN
532: RAISE;
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;

Line 629: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_is_dest_prgm_actv_confrm');

625: WHEN FND_API.G_EXC_ERROR THEN
626: RAISE;
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;

Line 697: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_for_debt');

693: WHEN FND_API.G_EXC_ERROR THEN
694: RAISE;
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;

Line 816: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.check_for_holds');

812: WHEN FND_API.G_EXC_ERROR THEN
813: RAISE;
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;

Line 898: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.enrp_val_excld_unit_pt');

894: WHEN FND_API.G_EXC_ERROR THEN
895: RAISE;
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;

Line 958: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.upd_or_create_dest_term_rec');

954: WHEN FND_API.G_EXC_ERROR THEN
955: RAISE;
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;

Line 1071: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.getunits_in_src_notin_dest_prg');

1067: WHEN FND_API.G_EXC_ERROR THEN
1068: RAISE;
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;

Line 1138: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.val_unchk_sub_units');

1134: WHEN FND_API.G_EXC_ERROR THEN
1135: RAISE;
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;

Line 1252: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_person_steps');

1248: WHEN FND_API.G_EXC_ERROR THEN
1249: RAISE;
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;

Line 1360: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_candidacy_tran_dtls');

1356: WHEN FND_API.G_EXC_ERROR THEN
1357: RAISE;
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;

Line 1430: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_advance_st_tran_dtls');

1426: WHEN FND_API.G_EXC_ERROR THEN
1427: RAISE;
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;

Line 2027: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_attempts');

2023: WHEN FND_API.G_EXC_ERROR THEN
2024: RAISE;
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;

Line 2337: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_prgm_attend_type_step');

2333: WHEN FND_API.G_EXC_ERROR THEN
2334: RAISE;
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;

Line 2739: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.validate_src_prgm_unt_set_att');

2735: WHEN FND_API.G_EXC_ERROR THEN
2736: RAISE;
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;

Line 2978: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_source_prgm');

2974: RAISE;
2975: WHEN OTHERS 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;

Line 3909: END IGS_EN_TRANSFER_APIS;

3905: END arrange_selected_unitsets;
3906:
3907:
3908:
3909: END IGS_EN_TRANSFER_APIS;