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.IGS_FI_UPG_RETENTION dependencies on FND_FILE

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

249: l_org_id := NULL;
250: igs_ge_gen_003.set_org_id(l_org_id);
251: EXCEPTION
252: WHEN OTHERS THEN
253: fnd_file.put_line (fnd_file.log, fnd_message.get);
254: retcode:=2;
255: RETURN;
256: END;
257: l_b_no_ftci_setup := FALSE;

Line 304: fnd_file.new_line(fnd_file.LOG );

300:
301: IF l_b_rec_setup OR l_b_ret_setup THEN
302: l_b_no_ftci_setup := TRUE;
303:
304: fnd_file.new_line(fnd_file.LOG );
305: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_charges.fee_type );
306: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_charges.fee_cal_type );
307: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_charges.start_dt );
308: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_charges.end_dt );

Line 305: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_charges.fee_type );

301: IF l_b_rec_setup OR l_b_ret_setup THEN
302: l_b_no_ftci_setup := TRUE;
303:
304: fnd_file.new_line(fnd_file.LOG );
305: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_charges.fee_type );
306: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_charges.fee_cal_type );
307: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_charges.start_dt );
308: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_charges.end_dt );
309:

Line 306: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_charges.fee_cal_type );

302: l_b_no_ftci_setup := TRUE;
303:
304: fnd_file.new_line(fnd_file.LOG );
305: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_charges.fee_type );
306: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_charges.fee_cal_type );
307: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_charges.start_dt );
308: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_charges.end_dt );
309:
310: IF l_b_rec_setup THEN

Line 307: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_charges.start_dt );

303:
304: fnd_file.new_line(fnd_file.LOG );
305: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_charges.fee_type );
306: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_charges.fee_cal_type );
307: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_charges.start_dt );
308: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_charges.end_dt );
309:
310: IF l_b_rec_setup THEN
311: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );

Line 308: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_charges.end_dt );

304: fnd_file.new_line(fnd_file.LOG );
305: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_charges.fee_type );
306: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_charges.fee_cal_type );
307: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_charges.start_dt );
308: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_charges.end_dt );
309:
310: IF l_b_rec_setup THEN
311: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );
312: END IF;

Line 311: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );

307: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_charges.start_dt );
308: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_charges.end_dt );
309:
310: IF l_b_rec_setup THEN
311: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );
312: END IF;
313:
314: IF l_b_ret_setup THEN
315: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_RETENTION_ACC') );

Line 315: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_RETENTION_ACC') );

311: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );
312: END IF;
313:
314: IF l_b_ret_setup THEN
315: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_RETENTION_ACC') );
316: END IF;
317: END IF;
318: l_b_ret_setup := FALSE;
319: l_b_rec_setup := FALSE;

Line 365: fnd_file.new_line(fnd_file.LOG );

361:
362: IF l_b_rec_setup OR l_b_ret_setup THEN
363: l_b_no_ftci_setup := TRUE;
364:
365: fnd_file.new_line(fnd_file.LOG );
366: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_applications.fee_type );
367: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_applications.fee_cal_type );
368: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_applications.start_dt );
369: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_applications.end_dt );

Line 366: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_applications.fee_type );

362: IF l_b_rec_setup OR l_b_ret_setup THEN
363: l_b_no_ftci_setup := TRUE;
364:
365: fnd_file.new_line(fnd_file.LOG );
366: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_applications.fee_type );
367: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_applications.fee_cal_type );
368: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_applications.start_dt );
369: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_applications.end_dt );
370:

Line 367: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_applications.fee_cal_type );

363: l_b_no_ftci_setup := TRUE;
364:
365: fnd_file.new_line(fnd_file.LOG );
366: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_applications.fee_type );
367: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_applications.fee_cal_type );
368: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_applications.start_dt );
369: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_applications.end_dt );
370:
371: IF l_b_rec_setup THEN

Line 368: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_applications.start_dt );

364:
365: fnd_file.new_line(fnd_file.LOG );
366: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_applications.fee_type );
367: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_applications.fee_cal_type );
368: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_applications.start_dt );
369: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_applications.end_dt );
370:
371: IF l_b_rec_setup THEN
372: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );

Line 369: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_applications.end_dt );

365: fnd_file.new_line(fnd_file.LOG );
366: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_type || ' : ' || rec_upd_applications.fee_type );
367: fnd_file.put_line(fnd_file.LOG, l_v_lkp_fee_cal_type || ' : ' || rec_upd_applications.fee_cal_type );
368: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_applications.start_dt );
369: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_applications.end_dt );
370:
371: IF l_b_rec_setup THEN
372: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );
373: END IF;

Line 372: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );

368: fnd_file.put_line(fnd_file.LOG, l_v_lkp_start_dt || ' : ' || rec_upd_applications.start_dt );
369: fnd_file.put_line(fnd_file.LOG, l_v_lkp_end_dt || ' : ' || rec_upd_applications.end_dt );
370:
371: IF l_b_rec_setup THEN
372: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );
373: END IF;
374:
375: IF l_b_ret_setup THEN
376: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_RETENTION_ACC') );

Line 376: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_RETENTION_ACC') );

372: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_REC_ACCT_CD_FTCI') );
373: END IF;
374:
375: IF l_b_ret_setup THEN
376: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_FI_NO_RETENTION_ACC') );
377: END IF;
378: END IF;
379: l_b_ret_setup := FALSE;
380: l_b_rec_setup := FALSE;

Line 399: fnd_file.new_line(fnd_file.LOG );

395:
396: -- See whether you have any records to Upgrade
397: IF ret_invoice_tab.COUNT = 0 THEN
398: l_b_upgrade_done := TRUE;
399: fnd_file.new_line(fnd_file.LOG );
400: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_GE_NO_DATA_FOUND'));
401: fnd_file.new_line(fnd_file.LOG );
402: END IF;
403:

Line 400: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_GE_NO_DATA_FOUND'));

396: -- See whether you have any records to Upgrade
397: IF ret_invoice_tab.COUNT = 0 THEN
398: l_b_upgrade_done := TRUE;
399: fnd_file.new_line(fnd_file.LOG );
400: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_GE_NO_DATA_FOUND'));
401: fnd_file.new_line(fnd_file.LOG );
402: END IF;
403:
404: -----------------------

Line 401: fnd_file.new_line(fnd_file.LOG );

397: IF ret_invoice_tab.COUNT = 0 THEN
398: l_b_upgrade_done := TRUE;
399: fnd_file.new_line(fnd_file.LOG );
400: fnd_file.put_line( fnd_file.LOG, fnd_message.get_string('IGS', 'IGS_GE_NO_DATA_FOUND'));
401: fnd_file.new_line(fnd_file.LOG );
402: END IF;
403:
404: -----------------------
405: -- Actual Upgrade Logic

Line 490: fnd_file.new_line(fnd_file.LOG );

486: x_unit_type_id => rec_invoice_details.unit_type_id,
487: x_unit_level => rec_invoice_details.unit_level
488: );
489:
490: fnd_file.new_line(fnd_file.LOG );
491: fnd_file.put_line(fnd_file.LOG, l_v_lkp_charge_number || ': ' || igs_fi_gen_008.get_invoice_number(rec_invoice_details.invoice_id) );
492: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rec_gl_ccid), l_v_upd_rec_account_cd) );
493: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rev_gl_ccid), l_v_upd_rev_account_cd) );
494: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );

Line 491: fnd_file.put_line(fnd_file.LOG, l_v_lkp_charge_number || ': ' || igs_fi_gen_008.get_invoice_number(rec_invoice_details.invoice_id) );

487: x_unit_level => rec_invoice_details.unit_level
488: );
489:
490: fnd_file.new_line(fnd_file.LOG );
491: fnd_file.put_line(fnd_file.LOG, l_v_lkp_charge_number || ': ' || igs_fi_gen_008.get_invoice_number(rec_invoice_details.invoice_id) );
492: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rec_gl_ccid), l_v_upd_rec_account_cd) );
493: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rev_gl_ccid), l_v_upd_rev_account_cd) );
494: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
495:

Line 492: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rec_gl_ccid), l_v_upd_rec_account_cd) );

488: );
489:
490: fnd_file.new_line(fnd_file.LOG );
491: fnd_file.put_line(fnd_file.LOG, l_v_lkp_charge_number || ': ' || igs_fi_gen_008.get_invoice_number(rec_invoice_details.invoice_id) );
492: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rec_gl_ccid), l_v_upd_rec_account_cd) );
493: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rev_gl_ccid), l_v_upd_rev_account_cd) );
494: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
495:
496: -- Check if this charge has been posted to GL Interface or Posting Interface

Line 493: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rev_gl_ccid), l_v_upd_rev_account_cd) );

489:
490: fnd_file.new_line(fnd_file.LOG );
491: fnd_file.put_line(fnd_file.LOG, l_v_lkp_charge_number || ': ' || igs_fi_gen_008.get_invoice_number(rec_invoice_details.invoice_id) );
492: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rec_gl_ccid), l_v_upd_rec_account_cd) );
493: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rev_gl_ccid), l_v_upd_rev_account_cd) );
494: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
495:
496: -- Check if this charge has been posted to GL Interface or Posting Interface
497: IF rec_invoice_details.posting_control_id IS NOT NULL THEN

Line 494: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );

490: fnd_file.new_line(fnd_file.LOG );
491: fnd_file.put_line(fnd_file.LOG, l_v_lkp_charge_number || ': ' || igs_fi_gen_008.get_invoice_number(rec_invoice_details.invoice_id) );
492: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rec_gl_ccid), l_v_upd_rec_account_cd) );
493: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rev_gl_ccid), l_v_upd_rev_account_cd) );
494: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
495:
496: -- Check if this charge has been posted to GL Interface or Posting Interface
497: IF rec_invoice_details.posting_control_id IS NOT NULL THEN
498: IF l_v_rec_installed = 'Y' THEN

Line 614: fnd_file.new_line(fnd_file.LOG );

610: x_gl_date => rec_application_details.gl_date,
611: x_gl_posted_date => rec_application_details.gl_posted_date,
612: x_posting_control_id => rec_application_details.posting_control_id);
613:
614: fnd_file.new_line(fnd_file.LOG );
615: fnd_file.put_line(fnd_file.LOG, l_v_lkp_application_id || ': ' || rec_application_details.application_id );
616: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_application_details.dr_gl_code_ccid), rec_application_details.dr_account_cd) );
617: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_cr_gl_code_ccid), l_v_upd_cr_account_cd) );
618: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );

Line 615: fnd_file.put_line(fnd_file.LOG, l_v_lkp_application_id || ': ' || rec_application_details.application_id );

611: x_gl_posted_date => rec_application_details.gl_posted_date,
612: x_posting_control_id => rec_application_details.posting_control_id);
613:
614: fnd_file.new_line(fnd_file.LOG );
615: fnd_file.put_line(fnd_file.LOG, l_v_lkp_application_id || ': ' || rec_application_details.application_id );
616: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_application_details.dr_gl_code_ccid), rec_application_details.dr_account_cd) );
617: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_cr_gl_code_ccid), l_v_upd_cr_account_cd) );
618: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
619:

Line 616: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_application_details.dr_gl_code_ccid), rec_application_details.dr_account_cd) );

612: x_posting_control_id => rec_application_details.posting_control_id);
613:
614: fnd_file.new_line(fnd_file.LOG );
615: fnd_file.put_line(fnd_file.LOG, l_v_lkp_application_id || ': ' || rec_application_details.application_id );
616: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_application_details.dr_gl_code_ccid), rec_application_details.dr_account_cd) );
617: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_cr_gl_code_ccid), l_v_upd_cr_account_cd) );
618: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
619:
620: -- Check if this Application Record has been posted to GL Interface or Posting Interface

Line 617: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_cr_gl_code_ccid), l_v_upd_cr_account_cd) );

613:
614: fnd_file.new_line(fnd_file.LOG );
615: fnd_file.put_line(fnd_file.LOG, l_v_lkp_application_id || ': ' || rec_application_details.application_id );
616: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_application_details.dr_gl_code_ccid), rec_application_details.dr_account_cd) );
617: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_cr_gl_code_ccid), l_v_upd_cr_account_cd) );
618: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
619:
620: -- Check if this Application Record has been posted to GL Interface or Posting Interface
621: IF rec_application_details.posting_control_id IS NOT NULL THEN

Line 618: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );

614: fnd_file.new_line(fnd_file.LOG );
615: fnd_file.put_line(fnd_file.LOG, l_v_lkp_application_id || ': ' || rec_application_details.application_id );
616: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_application_details.dr_gl_code_ccid), rec_application_details.dr_account_cd) );
617: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_cr_gl_code_ccid), l_v_upd_cr_account_cd) );
618: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
619:
620: -- Check if this Application Record has been posted to GL Interface or Posting Interface
621: IF rec_application_details.posting_control_id IS NOT NULL THEN
622: IF l_v_rec_installed = 'Y' THEN

Line 721: fnd_file.new_line(fnd_file.LOG );

717: x_gl_date => rec_cr_act_details.gl_date,
718: x_gl_posted_date => rec_cr_act_details.gl_posted_date);
719:
720:
721: fnd_file.new_line(fnd_file.LOG );
722: fnd_file.put_line(fnd_file.LOG, l_v_lkp_credit_number || ': ' || get_credit_number(rec_cr_act_details.credit_id) );
723: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_dr_gl_ccid), l_v_upd_dr_account_cd) );
724: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_cr_act_details.cr_gl_ccid), rec_cr_act_details.cr_account_cd) );
725: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );

Line 722: fnd_file.put_line(fnd_file.LOG, l_v_lkp_credit_number || ': ' || get_credit_number(rec_cr_act_details.credit_id) );

718: x_gl_posted_date => rec_cr_act_details.gl_posted_date);
719:
720:
721: fnd_file.new_line(fnd_file.LOG );
722: fnd_file.put_line(fnd_file.LOG, l_v_lkp_credit_number || ': ' || get_credit_number(rec_cr_act_details.credit_id) );
723: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_dr_gl_ccid), l_v_upd_dr_account_cd) );
724: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_cr_act_details.cr_gl_ccid), rec_cr_act_details.cr_account_cd) );
725: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
726:

Line 723: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_dr_gl_ccid), l_v_upd_dr_account_cd) );

719:
720:
721: fnd_file.new_line(fnd_file.LOG );
722: fnd_file.put_line(fnd_file.LOG, l_v_lkp_credit_number || ': ' || get_credit_number(rec_cr_act_details.credit_id) );
723: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_dr_gl_ccid), l_v_upd_dr_account_cd) );
724: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_cr_act_details.cr_gl_ccid), rec_cr_act_details.cr_account_cd) );
725: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
726:
727: -- Check if this Credit Activity Record has been posted to GL Interface or Posting Interface

Line 724: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_cr_act_details.cr_gl_ccid), rec_cr_act_details.cr_account_cd) );

720:
721: fnd_file.new_line(fnd_file.LOG );
722: fnd_file.put_line(fnd_file.LOG, l_v_lkp_credit_number || ': ' || get_credit_number(rec_cr_act_details.credit_id) );
723: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_dr_gl_ccid), l_v_upd_dr_account_cd) );
724: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_cr_act_details.cr_gl_ccid), rec_cr_act_details.cr_account_cd) );
725: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
726:
727: -- Check if this Credit Activity Record has been posted to GL Interface or Posting Interface
728: IF rec_cr_act_details.posting_control_id IS NOT NULL THEN

Line 725: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );

721: fnd_file.new_line(fnd_file.LOG );
722: fnd_file.put_line(fnd_file.LOG, l_v_lkp_credit_number || ': ' || get_credit_number(rec_cr_act_details.credit_id) );
723: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_dr_gl_ccid), l_v_upd_dr_account_cd) );
724: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_cr_act_details.cr_gl_ccid), rec_cr_act_details.cr_account_cd) );
725: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
726:
727: -- Check if this Credit Activity Record has been posted to GL Interface or Posting Interface
728: IF rec_cr_act_details.posting_control_id IS NOT NULL THEN
729: IF l_v_rec_installed = 'Y' THEN

Line 784: fnd_file.put_line( fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_error );

780: RETURN;
781: END IF; /* l_b_no_ftci_setup = FALSE AND ret_invoice_tab.COUNT > 0 */
782:
783: IF l_b_upgrade_done = FALSE THEN
784: fnd_file.put_line( fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_error );
785: END IF;
786:
787: EXCEPTION
788: