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

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

69: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
70: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
71: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
72:
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: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

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

70: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
71: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
72:
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: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
78: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed

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

71: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
72:
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: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
78: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
79: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

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

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: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
78: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
79: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
80:
81: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;

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

74: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
75: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
76:
77: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
78: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
79: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
80:
81: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
82:

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

75: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
76:
77: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
78: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
79: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
80:
81: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
82:
83: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;

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

77: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
78: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
79: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
80:
81: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
82:
83: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
84:
85: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;

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

79: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
80:
81: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
82:
83: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
84:
85: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
86: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
87: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

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

81: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
82:
83: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
84:
85: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
86: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
87: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
88: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
89:

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

82:
83: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
84:
85: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
86: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
87: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
88: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
89:
90: EXCEPTION

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

83: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| TO_CHAR(p_batch_num) || '-' || l_batch_desc ) ;
84:
85: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
86: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
87: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
88: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
89:
90: EXCEPTION
91: WHEN OTHERS THEN

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

84:
85: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( FND_MESSAGE.GET_STRING('IGS','IGS_GE_ASK_DEL_REC'), 40) || ' : '|| l_yes_no ) ;
86: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
87: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
88: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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

113: BEGIN
114:
115: FOR i IN 1..l_count LOOP
116: IF l_old_person <> g_log_tab(i).person_number THEN
117: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
118: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
119: END IF;
120: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
121: l_old_person := g_log_tab(i).person_number;

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

114:
115: FOR i IN 1..l_count LOOP
116: IF l_old_person <> g_log_tab(i).person_number THEN
117: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
118: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
119: END IF;
120: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
121: l_old_person := g_log_tab(i).person_number;
122: END LOOP;

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

116: IF l_old_person <> g_log_tab(i).person_number THEN
117: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
118: fnd_file.put_line(fnd_file.log,p_person_number || ' : ' || g_log_tab(i).person_number);
119: END IF;
120: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
121: l_old_person := g_log_tab(i).person_number;
122: END LOOP;
123:
124: EXCEPTION

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

543: IF c_get_stat%NOTFOUND THEN
544: -- Award Year setup tampered .... Log a message
545: FND_MESSAGE.SET_NAME('IGF','IGF_AP_AWD_YR_NOT_FOUND');
546: FND_MESSAGE.SET_TOKEN('P_AWARD_YEAR', l_alternate_code);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
548: g_terminate_process := TRUE ;
549: ELSE
550: -- Award year exists but is it Open/Legacy Details .... check
551: IF g_award_year_status NOT IN ('O','LD') THEN

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

550: -- Award year exists but is it Open/Legacy Details .... check
551: IF g_award_year_status NOT IN ('O','LD') THEN
552: FND_MESSAGE.SET_NAME('IGF','IGF_AP_LG_INVALID_STAT');
553: FND_MESSAGE.SET_TOKEN('AWARD_STATUS', g_award_year_status);
554: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
555: g_terminate_process := TRUE ;
556: END IF ; -- awd ye open or legacy detail chk
557: END IF ; -- award year invalid check
558: CLOSE c_get_stat ;

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

560: -- check validity of batch
561: l_batch_valid := igf_ap_gen.check_batch ( p_batch_num, 'VERIF') ;
562: IF NVL(l_batch_valid,'N') <> 'Y' THEN
563: FND_MESSAGE.SET_NAME('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
564: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
565: g_terminate_process := TRUE ;
566: END IF;
567:
568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

913: END IF ; -- award year check ...
914:
915: IF l_rec_processed = 0 THEN
916: FND_MESSAGE.SET_NAME('IGF','IGF_AP_AWDYR_STAT_NOT_EXISTS');
917: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
918: ELSE
919: -- CALL THE PRINT LOG PROCESS
920: print_log_process(l_person_number,l_error);
921: 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 921: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );

917: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
918: ELSE
919: -- CALL THE PRINT LOG PROCESS
920: print_log_process(l_person_number,l_error);
921: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );
922: 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));
923: 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));
924:
925: IF l_rec_imported = 0 THEN

Line 922: 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));

918: ELSE
919: -- CALL THE PRINT LOG PROCESS
920: print_log_process(l_person_number,l_error);
921: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );
922: 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));
923: 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));
924:
925: IF l_rec_imported = 0 THEN
926: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');

Line 923: 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));

919: -- CALL THE PRINT LOG PROCESS
920: print_log_process(l_person_number,l_error);
921: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('IGS','IGS_GE_TOTAL_REC_PROCESSED'),50)|| TO_CHAR(l_rec_processed) );
922: 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));
923: 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));
924:
925: IF l_rec_imported = 0 THEN
926: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
927: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');

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

922: 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));
923: 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));
924:
925: IF l_rec_imported = 0 THEN
926: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
927: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');
928: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
929: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_DATA_IMP' );
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);

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

923: 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));
924:
925: IF l_rec_imported = 0 THEN
926: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
927: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');
928: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
929: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_DATA_IMP' );
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);
931: END IF ;

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

924:
925: IF l_rec_imported = 0 THEN
926: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
927: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');
928: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
929: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_DATA_IMP' );
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);
931: END IF ;
932: END IF ;

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

926: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
927: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '-------------------------------------------------------------');
928: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
929: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_DATA_IMP' );
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);
931: END IF ;
932: END IF ;
933:
934: END IF ; -- terminate flag check

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

936: ELSE -- profile check
937: -- error message
938: -- terminate the process .. no further processing
939: FND_MESSAGE.SET_NAME('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
940: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
941: END IF ; -- profile check ends
942:
943: EXCEPTION
944: WHEN OTHERS THEN