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 FND_FILE

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

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;
313: END IF;
314:
315: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'BASE');

Line 654: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

650: FETCH ssn_cur INTO rec_ssn_cur;
651: IF ssn_cur%NOTFOUND THEN
652: CLOSE ssn_cur;
653: fnd_message.set_name('IGF','IGF_AP_SSN_REQD');
654: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
655: l_create_base_rec := FALSE;
656: l_error_flag := FALSE;
657: ELSE
658: CLOSE ssn_cur;

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

857: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind,l_get_status.award_year_status_code);
858:
859: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
860: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

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

859: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
860: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
866: EXCEPTION
867: WHEN others THEN

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

861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
866: EXCEPTION
867: WHEN others THEN
868: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
869: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_ap_li_base_rec_import.main.exception',SQLERRM);

Line 952: fnd_file.put_line(fnd_file.log,l_param_passed);

948: CLOSE c_get_batch_desc;
949: l_batch_desc := l_get_batch_desc.batch_desc ;
950:
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,'------------------------------------------------------------------------------');

Line 953: fnd_file.put_line(fnd_file.log,RPAD(l_award_yr,50) || ' : ' || p_alternate_code);

949: l_batch_desc := l_get_batch_desc.batch_desc ;
950:
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);

Line 954: fnd_file.put_line(fnd_file.log,RPAD(l_batch_id,50) || ' : ' || p_batch_id || ' - ' || l_batch_desc);

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

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 956: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------------');

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
960: IF g_log_tab(i).person_number IS NOT NULL THEN

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

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

960: IF g_log_tab(i).person_number IS NOT NULL THEN
961: IF l_old_person <> g_log_tab(i).person_number THEN
962: IF i <> 1 AND l_print_message_flag THEN
963: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');
964: fnd_file.put_line(fnd_file.log,fnd_message.get);
965: END IF;
966: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
967: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
968:

Line 966: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');

962: IF i <> 1 AND l_print_message_flag THEN
963: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');
964: fnd_file.put_line(fnd_file.log,fnd_message.get);
965: END IF;
966: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
967: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
968:
969: END IF;
970: l_old_person := g_log_tab(i).person_number;

Line 967: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);

963: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');
964: fnd_file.put_line(fnd_file.log,fnd_message.get);
965: END IF;
966: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
967: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
968:
969: END IF;
970: l_old_person := g_log_tab(i).person_number;
971: END IF;

Line 973: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);

969: END IF;
970: l_old_person := g_log_tab(i).person_number;
971: END IF;
972: l_print_message_flag := TRUE;
973: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
974: IF g_log_tab(i).message_text = 'Record Successfully imported' THEN
975: l_print_message_flag := FALSE;
976: END IF;
977: END LOOP;

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

976: END IF;
977: END LOOP;
978: IF l_print_message_flag THEN
979: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');
980: fnd_file.put_line(fnd_file.log,fnd_message.get);
981: END IF;
982:
983: END print_log_process;
984: