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

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

3010: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
3013:
3014: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3015: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3016: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3017:
3018: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

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

3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
3013:
3014: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3015: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3016: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3017:
3018: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3019: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed

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

3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
3013:
3014: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3015: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3016: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3017:
3018: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3019: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
3020: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

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

3014: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3015: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3016: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3017:
3018: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3019: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
3020: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3021:
3022: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;

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

3015: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3016: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3017:
3018: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3019: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
3020: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3021:
3022: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
3023:

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

3016: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3017:
3018: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3019: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
3020: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3021:
3022: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
3023:
3024: IF l_css_log = 'N' THEN

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

3018: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3019: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
3020: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
3021:
3022: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
3023:
3024: IF l_css_log = 'N' THEN
3025: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;
3026:

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

3021:
3022: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
3023:
3024: IF l_css_log = 'N' THEN
3025: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;
3026:
3027: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
3028: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3029: END IF;

Line 3027: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;

3023:
3024: IF l_css_log = 'N' THEN
3025: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;
3026:
3027: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
3028: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3029: END IF;
3030: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3031: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

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

3024: IF l_css_log = 'N' THEN
3025: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;
3026:
3027: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
3028: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3029: END IF;
3030: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3031: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3032:

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

3026:
3027: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
3028: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3029: END IF;
3030: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3031: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3032:
3033: END log_input_params ;
3034:

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

3027: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
3028: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3029: END IF;
3030: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3031: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3032:
3033: END log_input_params ;
3034:
3035:

Line 3191: fnd_file.put(fnd_file.log, c_lkup_values_err_rec.meaning ||' ');

3187: CLOSE c_lkup_values;
3188:
3189: IF p_igf_ap_message_table.COUNT<>0 THEN
3190: FOR indx IN p_igf_ap_message_table.FIRST..p_igf_ap_message_table.LAST LOOP
3191: fnd_file.put(fnd_file.log, c_lkup_values_err_rec.meaning ||' ');
3192: fnd_file.put_line(fnd_file.log,p_igf_ap_message_table(indx).field_name||' '||p_igf_ap_message_table(indx).msg_text);
3193: END LOOP;
3194: END IF;
3195: END print_message;

Line 3192: fnd_file.put_line(fnd_file.log,p_igf_ap_message_table(indx).field_name||' '||p_igf_ap_message_table(indx).msg_text);

3188:
3189: IF p_igf_ap_message_table.COUNT<>0 THEN
3190: FOR indx IN p_igf_ap_message_table.FIRST..p_igf_ap_message_table.LAST LOOP
3191: fnd_file.put(fnd_file.log, c_lkup_values_err_rec.meaning ||' ');
3192: fnd_file.put_line(fnd_file.log,p_igf_ap_message_table(indx).field_name||' '||p_igf_ap_message_table(indx).msg_text);
3193: END LOOP;
3194: END IF;
3195: END print_message;
3196:

Line 4725: -- fnd_file.put_line(fnd_file.log,' validation : 6' );

4721: 25000);
4722: p_igf_ap_message_table(indx).field_name:='';
4723: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_4_ATTEND_COLLEGE_TYPE');
4724:
4725: -- fnd_file.put_line(fnd_file.log,' validation : 6' );
4726: END IF;
4727:
4728: END IF;
4729:

Line 4744: -- fnd_file.put_line(fnd_file.log,' validation : 8' );

4740: 25000);
4741: p_igf_ap_message_table(indx).field_name:='';
4742: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_5_ATTEND_COLLEGE_TYPE');
4743:
4744: -- fnd_file.put_line(fnd_file.log,' validation : 8' );
4745: END IF;
4746:
4747: END IF;
4748:

Line 4763: -- fnd_file.put_line(fnd_file.log,' validation : 10' );

4759: 25000);
4760: p_igf_ap_message_table(indx).field_name:='';
4761: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_6_ATTEND_COLLEGE_TYPE');
4762:
4763: -- fnd_file.put_line(fnd_file.log,' validation : 10' );
4764: END IF;
4765:
4766: END IF;
4767:

Line 4779: -- fnd_file.put_line(fnd_file.log,'l_hash_value :'||l_hash_value );

4775: indx:= indx+1;
4776: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',
4777: 1000,
4778: 25000);
4779: -- fnd_file.put_line(fnd_file.log,'l_hash_value :'||l_hash_value );
4780: p_igf_ap_message_table(indx).field_name:='';
4781: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_7_ATTEND_COLLEGE_TYPE');
4782:
4783:

Line 5954: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');

5950: l_ret_profile:=igf_ap_gen.check_profile;
5951: IF l_ret_profile <> 'Y' THEN
5952: -- check if country code is not'US' AND does not participate in financial aidprogram THEN
5953: -- write into the log file and exit process
5954: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
5955: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
5956: fnd_file.put_line(fnd_file.log, fnd_message.get);
5957: RETURN;
5958: END IF;

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

5952: -- check if country code is not'US' AND does not participate in financial aidprogram THEN
5953: -- write into the log file and exit process
5954: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
5955: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
5956: fnd_file.put_line(fnd_file.log, fnd_message.get);
5957: RETURN;
5958: END IF;
5959:
5960: OPEN c_award_det(l_ci_cal_type,l_ci_sequence_number);

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

5989: IF c_get_stat%NOTFOUND THEN
5990: -- Award Year setup tampered .... Log a message
5991: FND_MESSAGE.SET_NAME('IGF','IGF_AP_AWD_YR_NOT_FOUND');
5992: FND_MESSAGE.SET_TOKEN('P_AWARD_YEAR', l_alternate_code);
5993: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
5994: -- g_terminate_process := TRUE ;
5995: RETURN;
5996: ELSE -- Award year exists but is it Open/Legacy Details .... check
5997: IF l_award_year_status NOT IN ('O','LD') THEN

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

5996: ELSE -- Award year exists but is it Open/Legacy Details .... check
5997: IF l_award_year_status NOT IN ('O','LD') THEN
5998: FND_MESSAGE.SET_NAME('IGF','IGF_AP_LG_INVALID_STAT');
5999: FND_MESSAGE.SET_TOKEN('AWARD_STATUS', l_award_year_status);
6000: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
6001: --g_terminate_process := TRUE ;
6002: RETURN;
6003: END IF ; -- awd ye open or legacy detail chk
6004: END IF ; -- award year invalid check

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

6008:
6009: IF p_css_import <> 'Y' THEN
6010: IF NVL(l_batch_valid,'N') <> 'Y' THEN
6011: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
6012: fnd_file.put_line(fnd_file.log,fnd_message.get);
6013: RETURN;
6014: END IF;
6015: END IF;
6016: c_award_det_rec := NULL;

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

6022: BEGIN
6023: l_css_academic_year := TO_NUMBER(c_award_det_rec.css_academic_year);
6024: EXCEPTION WHEN OTHERS THEN
6025: fnd_message.set_name('IGF','IGF_AP_AW_CSS_NOT_EXISTS');
6026: fnd_file.put_line(fnd_file.log,fnd_message.get);
6027: RETURN;
6028: END;
6029: OPEN c_css_int_data(l_css_academic_year);
6030: ELSE

Line 6062: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);

6058: IF c_award_det_rec.css_academic_year=c_int_data_rec.academic_year_txt THEN
6059: EXIT;
6060: END IF;
6061: -- message IGF_AP_AW_BATCH_NOT_EXISTS
6062: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);
6063: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
6064: fnd_message.set_name('IGF','IGF_AP_AW_BATCH_NOT_EXISTS');
6065: fnd_file.put_line(fnd_file.log, fnd_message.get);
6066: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------');

Line 6063: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');

6059: EXIT;
6060: END IF;
6061: -- message IGF_AP_AW_BATCH_NOT_EXISTS
6062: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);
6063: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
6064: fnd_message.set_name('IGF','IGF_AP_AW_BATCH_NOT_EXISTS');
6065: fnd_file.put_line(fnd_file.log, fnd_message.get);
6066: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------');
6067: END LOOP;

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

6061: -- message IGF_AP_AW_BATCH_NOT_EXISTS
6062: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);
6063: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
6064: fnd_message.set_name('IGF','IGF_AP_AW_BATCH_NOT_EXISTS');
6065: fnd_file.put_line(fnd_file.log, fnd_message.get);
6066: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------');
6067: END LOOP;
6068: IF c_int_data%NOTFOUND THEN
6069: EXIT;

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

6062: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);
6063: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
6064: fnd_message.set_name('IGF','IGF_AP_AW_BATCH_NOT_EXISTS');
6065: fnd_file.put_line(fnd_file.log, fnd_message.get);
6066: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------');
6067: END LOOP;
6068: IF c_int_data%NOTFOUND THEN
6069: EXIT;
6070: END IF;

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

6100: ELSE
6101: -- Log a message in the logging table that Person does not exist in OSS (IGF_AP_PE_NOT_EXIST)
6102: --Update the Legacy Interface Table column IMPORT_STATUS_FLAG to "E" implying Error.
6103: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
6104: -- fnd_file.put_line(fnd_file.log, fnd_message.get);
6105: counter := counter+1;
6106: g_message_table(counter).msg_text:=fnd_message.get;
6107: l_debug_str := l_debug_str || lv_person_number || 'person idoes not exist';
6108:

Line 6170: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.social_security_num);

6166: END IF;
6167: --Print Error Messages
6168: IF l_valid_for_dml <> 'Y' THEN
6169: IF p_css_import = 'Y' THEN
6170: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.social_security_num);
6171: ELSE
6172: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);
6173: END IF;
6174: FOR indx_1 IN 1 .. counter LOOP

Line 6172: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);

6168: IF l_valid_for_dml <> 'Y' THEN
6169: IF p_css_import = 'Y' THEN
6170: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.social_security_num);
6171: ELSE
6172: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);
6173: END IF;
6174: FOR indx_1 IN 1 .. counter LOOP
6175: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
6176: fnd_file.put_line(fnd_file.log,g_message_table(indx_1).msg_text);

Line 6175: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');

6171: ELSE
6172: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);
6173: END IF;
6174: FOR indx_1 IN 1 .. counter LOOP
6175: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
6176: fnd_file.put_line(fnd_file.log,g_message_table(indx_1).msg_text);
6177: END LOOP;
6178:
6179: IF NOT p_validation_status THEN

Line 6176: fnd_file.put_line(fnd_file.log,g_message_table(indx_1).msg_text);

6172: fnd_file.put_line(fnd_file.log,c_lkup_values_pn_rec.meaning||' '|| c_int_data_rec.person_number);
6173: END IF;
6174: FOR indx_1 IN 1 .. counter LOOP
6175: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');
6176: fnd_file.put_line(fnd_file.log,g_message_table(indx_1).msg_text);
6177: END LOOP;
6178:
6179: IF NOT p_validation_status THEN
6180: print_message(l_igf_ap_message_table );

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

6178:
6179: IF NOT p_validation_status THEN
6180: print_message(l_igf_ap_message_table );
6181: END IF;
6182: fnd_file.put_line(fnd_file.log,'------------------------------------------------------------------------');
6183: END IF;
6184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6185: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_prof_imp_proc.main.debug',l_debug_str);
6186: END IF;

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

6190: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_li_prof_imp_proc.main.exception',l_debug_str || ' ' || SQLERRM);
6191: END IF;
6192: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6193: fnd_message.set_token('NAME','IGF_AP_LI_ISIR_IMP_PROC.MAIN'|| SQLERRM);
6194: fnd_file.put_line(fnd_file.log,fnd_message.get);
6195: ROLLBACK TO next_record;
6196: END;
6197: COMMIT;
6198: END LOOP;

Line 6209: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' ||l_num_recrd_processed);

6205: CLOSE c_int_data;
6206: END IF;
6207:
6208: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
6209: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' ||l_num_recrd_processed);
6210: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
6211: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' ||l_num_recrd_passed);
6212: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
6213: l_num_recrd_failed := l_num_recrd_processed - l_num_recrd_passed;

Line 6211: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' ||l_num_recrd_passed);

6207:
6208: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
6209: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' ||l_num_recrd_processed);
6210: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
6211: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' ||l_num_recrd_passed);
6212: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
6213: l_num_recrd_failed := l_num_recrd_processed - l_num_recrd_passed;
6214: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_num_recrd_failed);
6215: END MAIN;

Line 6214: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_num_recrd_failed);

6210: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
6211: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' ||l_num_recrd_passed);
6212: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
6213: l_num_recrd_failed := l_num_recrd_processed - l_num_recrd_passed;
6214: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_num_recrd_failed);
6215: END MAIN;
6216:
6217: PROCEDURE css_import( errbuf IN OUT NOCOPY VARCHAR2,
6218: retcode IN OUT NOCOPY NUMBER,