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.IGF_AP_MK_PROF_ACT_PKG dependencies on FND_MESSAGE

Line 510: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');

506:
507: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
508: l_chk_profile := igf_ap_gen.check_profile;
509: IF l_chk_profile = 'N' THEN
510: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
511: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
512: RETURN;
513: END IF;
514:

Line 511: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

507: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
508: l_chk_profile := igf_ap_gen.check_profile;
509: IF l_chk_profile = 'N' THEN
510: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
511: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
512: RETURN;
513: END IF;
514:
515: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'PROFILE');

Line 517: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');

513: END IF;
514:
515: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'PROFILE');
516: IF l_chk_batch = 'N' THEN
517: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
518: add_log_table_process(NULL,l_error,fnd_message.get);
519: l_terminate_flag := TRUE;
520: END IF;
521: -- this is to get the alternate code

Line 518: add_log_table_process(NULL,l_error,fnd_message.get);

514:
515: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'PROFILE');
516: IF l_chk_batch = 'N' THEN
517: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
518: add_log_table_process(NULL,l_error,fnd_message.get);
519: l_terminate_flag := TRUE;
520: END IF;
521: -- this is to get the alternate code
522: l_get_alternate_code := NULL;

Line 534: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');

530: FETCH c_get_status INTO l_get_status;
531: CLOSE c_get_status;
532:
533: IF l_get_status.award_year_status_code NOT IN ('O','LD') THEN
534: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
535: fnd_message.set_token('AWARD_STATUS',l_get_status.award_year_status_code);
536: add_log_table_process(NULL,l_error,fnd_message.get);
537: l_terminate_flag := TRUE;
538: END IF;

Line 535: fnd_message.set_token('AWARD_STATUS',l_get_status.award_year_status_code);

531: CLOSE c_get_status;
532:
533: IF l_get_status.award_year_status_code NOT IN ('O','LD') THEN
534: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
535: fnd_message.set_token('AWARD_STATUS',l_get_status.award_year_status_code);
536: add_log_table_process(NULL,l_error,fnd_message.get);
537: l_terminate_flag := TRUE;
538: END IF;
539: IF l_terminate_flag = TRUE THEN

Line 536: add_log_table_process(NULL,l_error,fnd_message.get);

532:
533: IF l_get_status.award_year_status_code NOT IN ('O','LD') THEN
534: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
535: fnd_message.set_token('AWARD_STATUS',l_get_status.award_year_status_code);
536: add_log_table_process(NULL,l_error,fnd_message.get);
537: l_terminate_flag := TRUE;
538: END IF;
539: IF l_terminate_flag = TRUE THEN
540: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind);

Line 568: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

564: lv_base_id := NULL;
565: lv_person_id := NULL;
566: igf_ap_gen.check_person(l_get_records.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
567: IF lv_person_id IS NULL THEN
568: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
569: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
570: l_error_flag := TRUE;
571: ELSE
572: IF lv_base_id IS NULL THEN

Line 569: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

565: lv_person_id := NULL;
566: igf_ap_gen.check_person(l_get_records.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
567: IF lv_person_id IS NULL THEN
568: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
569: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
570: l_error_flag := TRUE;
571: ELSE
572: IF lv_base_id IS NULL THEN
573: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');

Line 573: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');

569: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
570: l_error_flag := TRUE;
571: ELSE
572: IF lv_base_id IS NULL THEN
573: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
574: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
575: l_error_flag := TRUE;
576: ELSE
577: l_debug_str := l_debug_str || ' Person and Base ID check passed';

Line 574: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

570: l_error_flag := TRUE;
571: ELSE
572: IF lv_base_id IS NULL THEN
573: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
574: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
575: l_error_flag := TRUE;
576: ELSE
577: l_debug_str := l_debug_str || ' Person and Base ID check passed';
578: -- here the academic year validation is done it shd correspond to the award year

Line 580: fnd_message.set_name('IGF','IGF_AP_AW_BATCH_NOT_EXISTS');

576: ELSE
577: l_debug_str := l_debug_str || ' Person and Base ID check passed';
578: -- here the academic year validation is done it shd correspond to the award year
579: IF l_get_records.academic_year_txt <> NVL(l_get_status.css_academic_year,-1) THEN
580: fnd_message.set_name('IGF','IGF_AP_AW_BATCH_NOT_EXISTS');
581: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
582: l_error_flag := TRUE;
583:
584: ELSE

Line 581: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

577: l_debug_str := l_debug_str || ' Person and Base ID check passed';
578: -- here the academic year validation is done it shd correspond to the award year
579: IF l_get_records.academic_year_txt <> NVL(l_get_status.css_academic_year,-1) THEN
580: fnd_message.set_name('IGF','IGF_AP_AW_BATCH_NOT_EXISTS');
581: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
582: l_error_flag := TRUE;
583:
584: ELSE
585: l_chk_prof_rec_legacy := NULL;

Line 590: fnd_message.set_name('IGF','IGF_AP_NON_LI_PROF_EXISTS');

586: OPEN c_chk_prof_rec_legacy(lv_base_id,l_get_records.academic_year_txt);
587: FETCH c_chk_prof_rec_legacy INTO l_chk_prof_rec_legacy;
588: CLOSE c_chk_prof_rec_legacy;
589: IF l_chk_prof_rec_legacy.row_id IS NOT NULL THEN
590: fnd_message.set_name('IGF','IGF_AP_NON_LI_PROF_EXISTS');
591: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
592: l_error_flag := TRUE;
593: ELSE -- THIS MEANS THE THERE IS PROFILE IS IMPORTED BY LEGACY ONLY
594: l_debug_str := l_debug_str || ' Legacy PROFILE check passed';

Line 591: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

587: FETCH c_chk_prof_rec_legacy INTO l_chk_prof_rec_legacy;
588: CLOSE c_chk_prof_rec_legacy;
589: IF l_chk_prof_rec_legacy.row_id IS NOT NULL THEN
590: fnd_message.set_name('IGF','IGF_AP_NON_LI_PROF_EXISTS');
591: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
592: l_error_flag := TRUE;
593: ELSE -- THIS MEANS THE THERE IS PROFILE IS IMPORTED BY LEGACY ONLY
594: l_debug_str := l_debug_str || ' Legacy PROFILE check passed';
595: l_get_prof_rec := NULL;

Line 600: fnd_message.set_name('IGF','IGF_AP_NO_PROF_RECS_EXIST');

596: OPEN c_get_prof_rec(lv_base_id,l_get_records.academic_year_txt,l_get_records.css_id_number_txt,'ORIGINAL');
597: FETCH c_get_prof_rec INTO l_get_prof_rec;
598: CLOSE c_get_prof_rec;
599: IF l_get_prof_rec.row_id IS NULL THEN
600: fnd_message.set_name('IGF','IGF_AP_NO_PROF_RECS_EXIST');
601: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
602: l_error_flag := TRUE;
603: ELSE
604: l_debug_str := l_debug_str || ' PROFILE record exists check passed';

Line 601: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

597: FETCH c_get_prof_rec INTO l_get_prof_rec;
598: CLOSE c_get_prof_rec;
599: IF l_get_prof_rec.row_id IS NULL THEN
600: fnd_message.set_name('IGF','IGF_AP_NO_PROF_RECS_EXIST');
601: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
602: l_error_flag := TRUE;
603: ELSE
604: l_debug_str := l_debug_str || ' PROFILE record exists check passed';
605: -- HERE GET THE VALUE OF THE EFC FROM THE OTHER PROFILE TABLE IGF_AP_CSS_FNAR

Line 611: fnd_message.set_name('IGF','IGF_AP_PROF_INVALID_EFC');

607: OPEN c_get_efc(l_get_prof_rec.cssp_id);
608: FETCH c_get_efc INTO l_get_efc;
609: CLOSE c_get_efc;
610: IF l_get_efc.fm_inst_1_federal_efc IS NULL THEN
611: fnd_message.set_name('IGF','IGF_AP_PROF_INVALID_EFC');
612: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
613: l_error_flag := TRUE;
614: ELSE
615: l_debug_str := l_debug_str || ' FM_INST_FEDERAL_EFC check passed';

Line 612: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

608: FETCH c_get_efc INTO l_get_efc;
609: CLOSE c_get_efc;
610: IF l_get_efc.fm_inst_1_federal_efc IS NULL THEN
611: fnd_message.set_name('IGF','IGF_AP_PROF_INVALID_EFC');
612: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
613: l_error_flag := TRUE;
614: ELSE
615: l_debug_str := l_debug_str || ' FM_INST_FEDERAL_EFC check passed';
616: l_old_act_prof := NULL;

Line 621: fnd_message.set_name('IGF','IGF_AP_REC_ALREADY_ACT');

617: OPEN c_old_act_prof(lv_base_id,'ORIGINAL');
618: FETCH c_old_act_prof INTO l_old_act_prof;
619: CLOSE c_old_act_prof;
620: IF l_old_act_prof.row_id IS NOT NULL THEN
621: fnd_message.set_name('IGF','IGF_AP_REC_ALREADY_ACT');
622: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
623: l_error_flag := TRUE;
624: ELSE
625: -- update_profile_rec(l_get_prof_rec);

Line 622: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

618: FETCH c_old_act_prof INTO l_old_act_prof;
619: CLOSE c_old_act_prof;
620: IF l_old_act_prof.row_id IS NOT NULL THEN
621: fnd_message.set_name('IGF','IGF_AP_REC_ALREADY_ACT');
622: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
623: l_error_flag := TRUE;
624: ELSE
625: -- update_profile_rec(l_get_prof_rec);
626: igf_ap_css_profile_pkg.update_row (

Line 974: fnd_message.set_name('IGF','IGF_AP_MK_ACT_PROF_SKIP');

970: END IF; -- BASE ID EXISTS OR NOT
971: END IF; -- PERSON EXISTS OR NOT
972:
973: ELSE
974: fnd_message.set_name('IGF','IGF_AP_MK_ACT_PROF_SKIP');
975: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
976: l_error_flag := TRUE;
977: END IF; -- if the person is not duplicate
978: IF l_error_flag = TRUE THEN

Line 975: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

971: END IF; -- PERSON EXISTS OR NOT
972:
973: ELSE
974: fnd_message.set_name('IGF','IGF_AP_MK_ACT_PROF_SKIP');
975: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
976: l_error_flag := TRUE;
977: END IF; -- if the person is not duplicate
978: IF l_error_flag = TRUE THEN
979: l_error_flag := FALSE;

Line 1007: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1003: WHEN others THEN
1004: l_process_flag := FALSE;
1005: l_debug_str := NULL;
1006: l_error_flag := FALSE;
1007: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1008: fnd_message.set_token('NAME','IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE');
1009: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
1010: ROLLBACK TO sp1;
1011: END;

Line 1008: fnd_message.set_token('NAME','IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE');

1004: l_process_flag := FALSE;
1005: l_debug_str := NULL;
1006: l_error_flag := FALSE;
1007: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1008: fnd_message.set_token('NAME','IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE');
1009: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
1010: ROLLBACK TO sp1;
1011: END;
1012: COMMIT;

Line 1009: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

1005: l_debug_str := NULL;
1006: l_error_flag := FALSE;
1007: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1008: fnd_message.set_token('NAME','IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE');
1009: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
1010: ROLLBACK TO sp1;
1011: END;
1012: COMMIT;
1013: END LOOP;

Line 1017: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');

1013: END LOOP;
1014: CLOSE c_get_records;
1015:
1016: IF l_success_record_cnt = 0 AND l_error_record_cnt = 0 THEN
1017: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');
1018: add_log_table_process(NULL,l_error,fnd_message.get);
1019: END IF;
1020:
1021: -- CALL THE PRINT LOG PROCESS

Line 1018: add_log_table_process(NULL,l_error,fnd_message.get);

1014: CLOSE c_get_records;
1015:
1016: IF l_success_record_cnt = 0 AND l_error_record_cnt = 0 THEN
1017: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');
1018: add_log_table_process(NULL,l_error,fnd_message.get);
1019: END IF;
1020:
1021: -- CALL THE PRINT LOG PROCESS
1022: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind);

Line 1025: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');

1021: -- CALL THE PRINT LOG PROCESS
1022: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind);
1023:
1024: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
1025: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');

Line 1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);

1022: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind);
1023:
1024: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
1025: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

Line 1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');

1023:
1024: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
1025: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
1031: EXCEPTION

Line 1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);

1024: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
1025: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
1031: EXCEPTION
1032: WHEN others THEN

Line 1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');

1025: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
1031: EXCEPTION
1032: WHEN others THEN
1033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

1026: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
1027: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
1028: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
1029: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1030: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
1031: EXCEPTION
1032: WHEN others THEN
1033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_mk_prof_act_pkg.lg_make_active_profile.exception','Unhandled exception error:'||SQLERRM);

Line 1036: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1032: WHEN others THEN
1033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_mk_prof_act_pkg.lg_make_active_profile.exception','Unhandled exception error:'||SQLERRM);
1035: END IF;
1036: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1037: fnd_message.set_token('NAME','IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE');
1038: errbuf := fnd_message.get;
1039: igs_ge_msg_stack.conc_exception_hndl;
1040:

Line 1037: fnd_message.set_token('NAME','IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE');

1033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_mk_prof_act_pkg.lg_make_active_profile.exception','Unhandled exception error:'||SQLERRM);
1035: END IF;
1036: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1037: fnd_message.set_token('NAME','IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE');
1038: errbuf := fnd_message.get;
1039: igs_ge_msg_stack.conc_exception_hndl;
1040:
1041: END lg_make_active_profile;

Line 1038: errbuf := fnd_message.get;

1034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_mk_prof_act_pkg.lg_make_active_profile.exception','Unhandled exception error:'||SQLERRM);
1035: END IF;
1036: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1037: fnd_message.set_token('NAME','IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE');
1038: errbuf := fnd_message.get;
1039: igs_ge_msg_stack.conc_exception_hndl;
1040:
1041: END lg_make_active_profile;
1042:

Line 1133: fnd_message.set_name('IGS','IGS_DA_JOB');

1129: CLOSE c_get_batch_desc;
1130: l_batch_desc := l_get_batch_desc.batch_desc ;
1131:
1132: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
1133: fnd_message.set_name('IGS','IGS_DA_JOB');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');

Line 1134: fnd_file.put_line(fnd_file.log,fnd_message.get);

1130: l_batch_desc := l_get_batch_desc.batch_desc ;
1131:
1132: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
1133: fnd_message.set_name('IGS','IGS_DA_JOB');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);

Line 1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');

1133: fnd_message.set_name('IGS','IGS_DA_JOB');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);
1139: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
1140:
1141: FOR i IN 1..l_count LOOP

Line 1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);

1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
1136: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
1137: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
1138: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,50) || ' : ' || l_yes_no);
1139: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
1140:
1141: FOR i IN 1..l_count LOOP
1142: IF g_log_tab(i).person_number IS NOT NULL THEN