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_LI_BASE_REC_IMPORT dependencies on IGF_AP_GEN

Line 307: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');

303: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_cal_type:'||l_cal_type);
304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_seq_number:'||l_seq_number);
305: END IF;
306:
307: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
308: l_chk_profile := igf_ap_gen.check_profile;
309: IF l_chk_profile = 'N' THEN
310: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
311: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

Line 308: l_chk_profile := igf_ap_gen.check_profile;

304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_seq_number:'||l_seq_number);
305: END IF;
306:
307: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
308: l_chk_profile := igf_ap_gen.check_profile;
309: IF l_chk_profile = 'N' THEN
310: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
311: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
312: RETURN;

Line 315: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'BASE');

311: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
312: RETURN;
313: END IF;
314:
315: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'BASE');
316: IF l_chk_batch = 'N' THEN
317: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
318: add_log_table_process(NULL,l_error,fnd_message.get);
319: l_terminate_flag := TRUE;

Line 360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Calling igf_ap_gen.check_person');

356: lv_base_id := NULL;
357: lv_person_id := NULL;
358: l_create_flag := FALSE;
359: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Calling igf_ap_gen.check_person');
361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_get_records.person_number:'||l_get_records.person_number);
362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_cal_type:'||l_cal_type);
363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_seq_number:'||l_seq_number);
364: END IF;

Line 365: igf_ap_gen.check_person(l_get_records.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);

361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_get_records.person_number:'||l_get_records.person_number);
362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_cal_type:'||l_cal_type);
363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_seq_number:'||l_seq_number);
364: END IF;
365: igf_ap_gen.check_person(l_get_records.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','lv_person_id:'||lv_person_id);
368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','lv_base_id:'||lv_base_id);
369: END IF;

Line 939: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');

935: l_get_batch_desc c_get_batch_desc%ROWTYPE;
936:
937: BEGIN
938:
939: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
940: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
941: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
942: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
943: l_param_passed := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');

Line 940: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');

936:
937: BEGIN
938:
939: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
940: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
941: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
942: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
943: l_param_passed := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
944: l_award_yr_status := igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',p_awd_yr_status);

Line 941: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');

937: BEGIN
938:
939: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
940: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
941: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
942: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
943: l_param_passed := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
944: l_award_yr_status := igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',p_awd_yr_status);
945:

Line 942: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);

938:
939: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
940: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
941: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
942: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
943: l_param_passed := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
944: l_award_yr_status := igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',p_awd_yr_status);
945:
946: OPEN c_get_batch_desc(p_batch_id);

Line 943: l_param_passed := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');

939: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
940: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
941: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
942: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
943: l_param_passed := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
944: l_award_yr_status := igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',p_awd_yr_status);
945:
946: OPEN c_get_batch_desc(p_batch_id);
947: FETCH c_get_batch_desc INTO l_get_batch_desc;

Line 944: l_award_yr_status := igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',p_awd_yr_status);

940: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
941: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
942: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
943: l_param_passed := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
944: l_award_yr_status := igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',p_awd_yr_status);
945:
946: OPEN c_get_batch_desc(p_batch_id);
947: FETCH c_get_batch_desc INTO l_get_batch_desc;
948: CLOSE c_get_batch_desc;

Line 955: fnd_file.put_line(fnd_file.log,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),50) || ' : ' || l_yes_no);

951: -- HERE THE INPUT PARAMETERS ARE TO BE LOGGED TO THE LOG FILE
952: fnd_file.put_line(fnd_file.log,l_param_passed);
953: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
954: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
955: fnd_file.put_line(fnd_file.log,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),50) || ' : ' || l_yes_no);
956: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
957: fnd_file.put_line(fnd_file.log,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YR_STATUS'),50) || ' : ' || l_award_yr_status);
958:
959: FOR i IN 1..l_count LOOP

Line 957: fnd_file.put_line(fnd_file.log,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YR_STATUS'),50) || ' : ' || l_award_yr_status);

953: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);
954: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);
955: fnd_file.put_line(fnd_file.log,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),50) || ' : ' || l_yes_no);
956: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');
957: fnd_file.put_line(fnd_file.log,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YR_STATUS'),50) || ' : ' || l_award_yr_status);
958:
959: FOR i IN 1..l_count LOOP
960: IF g_log_tab(i).person_number IS NOT NULL THEN
961: IF l_old_person <> g_log_tab(i).person_number THEN