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_LG_COA_IMP dependencies on FND_FILE

Line 60: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

56: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
57: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
58: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
59:
60: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
61: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
62: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
63:
64: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

Line 61: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

57: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
58: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
59:
60: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
61: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
62: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
63:
64: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
65: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed

Line 62: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

58: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
59:
60: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
61: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
62: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
63:
64: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
65: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
66: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

Line 64: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

60: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
61: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
62: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
63:
64: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
65: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
66: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
67:
68: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;

Line 65: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed

61: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
62: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
63:
64: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
65: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
66: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
67:
68: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
69:

Line 66: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

62: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
63:
64: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
65: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
66: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
67:
68: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
69:
70: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;

Line 68: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;

64: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
65: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
66: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
67:
68: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
69:
70: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
71:
72: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;

Line 70: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;

66: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
67:
68: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
69:
70: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
71:
72: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
73: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
74: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

Line 72: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;

68: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
69:
70: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
71:
72: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
73: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
74: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
75: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
76:

Line 73: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

69:
70: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
71:
72: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
73: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
74: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
75: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
76:
77: EXCEPTION

Line 74: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

70: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
71:
72: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
73: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
74: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
75: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
76:
77: EXCEPTION
78: WHEN OTHERS THEN

Line 75: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

71:
72: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
73: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
74: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
75: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
76:
77: EXCEPTION
78: WHEN OTHERS THEN
79: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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

100: BEGIN
101:
102: FOR i IN 1..l_count LOOP
103: IF l_old_person <> g_log_tab(i).person_number THEN
104: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
105: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
106: END IF;
107: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
108: l_old_person := g_log_tab(i).person_number;

Line 105: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);

101:
102: FOR i IN 1..l_count LOOP
103: IF l_old_person <> g_log_tab(i).person_number THEN
104: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
105: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
106: END IF;
107: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
108: l_old_person := g_log_tab(i).person_number;
109: END LOOP;

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

103: IF l_old_person <> g_log_tab(i).person_number THEN
104: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
105: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
106: END IF;
107: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
108: l_old_person := g_log_tab(i).person_number;
109: END LOOP;
110:
111: EXCEPTION

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

577: IF c_get_stat%NOTFOUND THEN
578: -- Award Year setup tampered .... Log a message
579: FND_MESSAGE.SET_NAME('IGF','IGF_AP_AWD_YR_NOT_FOUND');
580: FND_MESSAGE.SET_TOKEN('P_AWARD_YEAR', l_alternate_code);
581: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
582: g_terminate_process := TRUE ;
583: ELSE
584: -- Award year exists but is it Open/Legacy Details .... check
585: IF g_award_year_status NOT IN ('O','LD') THEN

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

584: -- Award year exists but is it Open/Legacy Details .... check
585: IF g_award_year_status NOT IN ('O','LD') THEN
586: FND_MESSAGE.SET_NAME('IGF','IGF_AP_LG_INVALID_STAT');
587: FND_MESSAGE.SET_TOKEN('AWARD_STATUS', g_award_year_status);
588: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
589: g_terminate_process := TRUE ;
590: END IF ; -- awd ye open or legacy detail chk
591: END IF ; -- award year invalid check
592: CLOSE c_get_stat ;

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

596: FETCH c_chk_coa INTO l_coa_exist ;
597: -- if no COA Item found
598: IF c_chk_coa%NOTFOUND THEN
599: FND_MESSAGE.SET_NAME('IGF','IGF_AP_COA_SETUP_INCOM');
600: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
601: -- set terminate flag
602: g_terminate_process := TRUE ;
603: END IF ; -- setup check in interface table
604: CLOSE c_chk_coa ;

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

606: -- check validity of batch
607: l_batch_valid := igf_ap_gen.check_batch ( p_batch_num, 'COA') ;
608: IF NVL(l_batch_valid,'N') <> 'Y' THEN
609: FND_MESSAGE.SET_NAME('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
610: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
611: g_terminate_process := TRUE ;
612: END IF;
613:
614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

1145:
1146:
1147: IF l_rec_processed = 0 THEN
1148: FND_MESSAGE.SET_NAME('IGF','IGF_AP_AWDYR_STAT_NOT_EXISTS');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1150: ELSE
1151: -- CALL THE PRINT LOG PROCESS
1152: print_log_process(l_person_number,l_error);
1153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );

Line 1153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );

1149: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1150: ELSE
1151: -- CALL THE PRINT LOG PROCESS
1152: print_log_process(l_person_number,l_error);
1153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_FAILED'),50)|| TO_CHAR(l_rec_processed - l_rec_imported));
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC'),50)|| TO_CHAR(l_rec_imported));
1156:
1157: IF l_rec_imported = 0 THEN

Line 1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_FAILED'),50)|| TO_CHAR(l_rec_processed - l_rec_imported));

1150: ELSE
1151: -- CALL THE PRINT LOG PROCESS
1152: print_log_process(l_person_number,l_error);
1153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_FAILED'),50)|| TO_CHAR(l_rec_processed - l_rec_imported));
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC'),50)|| TO_CHAR(l_rec_imported));
1156:
1157: IF l_rec_imported = 0 THEN
1158: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');

Line 1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC'),50)|| TO_CHAR(l_rec_imported));

1151: -- CALL THE PRINT LOG PROCESS
1152: print_log_process(l_person_number,l_error);
1153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_FAILED'),50)|| TO_CHAR(l_rec_processed - l_rec_imported));
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC'),50)|| TO_CHAR(l_rec_imported));
1156:
1157: IF l_rec_imported = 0 THEN
1158: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1159: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');

Line 1158: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');

1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_FAILED'),50)|| TO_CHAR(l_rec_processed - l_rec_imported));
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC'),50)|| TO_CHAR(l_rec_imported));
1156:
1157: IF l_rec_imported = 0 THEN
1158: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1159: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');
1160: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1161: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_DATA_IMP' );
1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);

Line 1159: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');

1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC'),50)|| TO_CHAR(l_rec_imported));
1156:
1157: IF l_rec_imported = 0 THEN
1158: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1159: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');
1160: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1161: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_DATA_IMP' );
1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);
1163: END IF ;

Line 1160: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');

1156:
1157: IF l_rec_imported = 0 THEN
1158: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1159: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');
1160: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1161: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_DATA_IMP' );
1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);
1163: END IF ;
1164: END IF ;

Line 1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);

1158: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1159: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');
1160: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
1161: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_DATA_IMP' );
1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);
1163: END IF ;
1164: END IF ;
1165:
1166: END IF ; -- terminate flag check

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

1168: ELSE -- profile check
1169: -- error message
1170: -- terminate the process .. no further processing
1171: FND_MESSAGE.SET_NAME('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
1172: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1173: END IF ; -- profile check ends
1174:
1175: EXCEPTION
1176: WHEN OTHERS THEN