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

Line 100: fnd_file.new_line(fnd_file.log);

96: OPEN c_party(p_n_party_id);
97: FETCH c_party INTO l_n_party_num;
98: CLOSE c_party;
99:
100: fnd_file.new_line(fnd_file.log);
101:
102: fnd_file.put_line(fnd_file.log,
103: g_v_lbl_party||' : '||l_n_party_num);
104:

Line 102: fnd_file.put_line(fnd_file.log,

98: CLOSE c_party;
99:
100: fnd_file.new_line(fnd_file.log);
101:
102: fnd_file.put_line(fnd_file.log,
103: g_v_lbl_party||' : '||l_n_party_num);
104:
105: l_n_party_num := NULL;
106: OPEN c_party(p_n_payee_id);

Line 110: fnd_file.put_line(fnd_file.log,

106: OPEN c_party(p_n_payee_id);
107: FETCH c_party INTO l_n_party_num;
108: CLOSE c_party;
109:
110: fnd_file.put_line(fnd_file.log,
111: g_v_lbl_pay||' : '||l_n_party_num);
112: fnd_file.put_line(fnd_file.log,
113: g_v_lbl_vchr||' : '||p_n_refund_id);
114:

Line 112: fnd_file.put_line(fnd_file.log,

108: CLOSE c_party;
109:
110: fnd_file.put_line(fnd_file.log,
111: g_v_lbl_pay||' : '||l_n_party_num);
112: fnd_file.put_line(fnd_file.log,
113: g_v_lbl_vchr||' : '||p_n_refund_id);
114:
115: END log_transaction;
116:

Line 272: fnd_file.put_line(fnd_file.log,

268: -- If there are no active pay to usage addresses for the
269: -- party, then a supplier site cannot be created and hence is an error
270: -- condition
271: IF l_n_hz_cntr = 0 THEN
272: fnd_file.put_line(fnd_file.log,
273: g_v_lbl_status||' : '||g_v_lbl_todo);
274: fnd_message.set_name('IGS','IGS_FI_HZ_NO_PAY_ADD');
275: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
276: fnd_file.put_line(fnd_file.log,

Line 276: fnd_file.put_line(fnd_file.log,

272: fnd_file.put_line(fnd_file.log,
273: g_v_lbl_status||' : '||g_v_lbl_todo);
274: fnd_message.set_name('IGS','IGS_FI_HZ_NO_PAY_ADD');
275: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
276: fnd_file.put_line(fnd_file.log,
277: fnd_message.get);
278: p_b_status := FALSE;
279: RETURN;
280: END IF;

Line 286: fnd_file.put_line(fnd_file.log,

282: -- If there are more than one active pay to usage addresses for the
283: -- party, then a supplier site cannot be created and hence is an error
284: -- condition
285: IF l_n_hz_cntr > 1 THEN
286: fnd_file.put_line(fnd_file.log,
287: g_v_lbl_status||' : '||g_v_lbl_todo);
288: fnd_message.set_name('IGS','IGS_FI_HZ_UNQ_PAY_ADD');
289: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
290: fnd_file.put_line(fnd_file.log,

Line 290: fnd_file.put_line(fnd_file.log,

286: fnd_file.put_line(fnd_file.log,
287: g_v_lbl_status||' : '||g_v_lbl_todo);
288: fnd_message.set_name('IGS','IGS_FI_HZ_UNQ_PAY_ADD');
289: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
290: fnd_file.put_line(fnd_file.log,
291: fnd_message.get);
292: p_b_status := FALSE;
293: RETURN;
294: END IF;

Line 457: fnd_file.put_line(fnd_file.log,

453: CLOSE c_po_lkp;
454: END IF;
455:
456: -- Logging the parameters
457: fnd_file.put_line(fnd_file.log,
458: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PROCESS_PARM'));
459: fnd_file.put_line(fnd_file.log,
460: RPAD('-',80,'-'));
461: fnd_file.new_line(fnd_file.log);

Line 459: fnd_file.put_line(fnd_file.log,

455:
456: -- Logging the parameters
457: fnd_file.put_line(fnd_file.log,
458: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PROCESS_PARM'));
459: fnd_file.put_line(fnd_file.log,
460: RPAD('-',80,'-'));
461: fnd_file.new_line(fnd_file.log);
462:
463: fnd_file.put_line(fnd_file.log,

Line 461: fnd_file.new_line(fnd_file.log);

457: fnd_file.put_line(fnd_file.log,
458: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PROCESS_PARM'));
459: fnd_file.put_line(fnd_file.log,
460: RPAD('-',80,'-'));
461: fnd_file.new_line(fnd_file.log);
462:
463: fnd_file.put_line(fnd_file.log,
464: g_v_lbl_party||' : '||NVL(l_c_party.party_number, p_n_party_id));
465: fnd_file.put_line(fnd_file.log,

Line 463: fnd_file.put_line(fnd_file.log,

459: fnd_file.put_line(fnd_file.log,
460: RPAD('-',80,'-'));
461: fnd_file.new_line(fnd_file.log);
462:
463: fnd_file.put_line(fnd_file.log,
464: g_v_lbl_party||' : '||NVL(l_c_party.party_number, p_n_party_id));
465: fnd_file.put_line(fnd_file.log,
466: g_v_lbl_person_group||' : '||NVL(l_c_pers_id_grp.group_cd, p_n_person_group_id));
467: fnd_file.put_line(fnd_file.log,

Line 465: fnd_file.put_line(fnd_file.log,

461: fnd_file.new_line(fnd_file.log);
462:
463: fnd_file.put_line(fnd_file.log,
464: g_v_lbl_party||' : '||NVL(l_c_party.party_number, p_n_party_id));
465: fnd_file.put_line(fnd_file.log,
466: g_v_lbl_person_group||' : '||NVL(l_c_pers_id_grp.group_cd, p_n_person_group_id));
467: fnd_file.put_line(fnd_file.log,
468: g_v_lbl_create_suppl||' : '||NVL(igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_create_supplier),p_v_create_supplier));
469: fnd_file.put_line(fnd_file.log,

Line 467: fnd_file.put_line(fnd_file.log,

463: fnd_file.put_line(fnd_file.log,
464: g_v_lbl_party||' : '||NVL(l_c_party.party_number, p_n_party_id));
465: fnd_file.put_line(fnd_file.log,
466: g_v_lbl_person_group||' : '||NVL(l_c_pers_id_grp.group_cd, p_n_person_group_id));
467: fnd_file.put_line(fnd_file.log,
468: g_v_lbl_create_suppl||' : '||NVL(igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_create_supplier),p_v_create_supplier));
469: fnd_file.put_line(fnd_file.log,
470: g_v_lbl_suppl_type||' : '||NVL(l_c_sup_type.meaning,p_v_supplier_type));
471: fnd_file.put_line(fnd_file.log,

Line 469: fnd_file.put_line(fnd_file.log,

465: fnd_file.put_line(fnd_file.log,
466: g_v_lbl_person_group||' : '||NVL(l_c_pers_id_grp.group_cd, p_n_person_group_id));
467: fnd_file.put_line(fnd_file.log,
468: g_v_lbl_create_suppl||' : '||NVL(igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_create_supplier),p_v_create_supplier));
469: fnd_file.put_line(fnd_file.log,
470: g_v_lbl_suppl_type||' : '||NVL(l_c_sup_type.meaning,p_v_supplier_type));
471: fnd_file.put_line(fnd_file.log,
472: g_v_lbl_pay_grp||' : '||NVL(l_c_grp_type.meaning,g_v_lbl_pay_grp));
473: fnd_file.put_line(fnd_file.log,

Line 471: fnd_file.put_line(fnd_file.log,

467: fnd_file.put_line(fnd_file.log,
468: g_v_lbl_create_suppl||' : '||NVL(igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_create_supplier),p_v_create_supplier));
469: fnd_file.put_line(fnd_file.log,
470: g_v_lbl_suppl_type||' : '||NVL(l_c_sup_type.meaning,p_v_supplier_type));
471: fnd_file.put_line(fnd_file.log,
472: g_v_lbl_pay_grp||' : '||NVL(l_c_grp_type.meaning,g_v_lbl_pay_grp));
473: fnd_file.put_line(fnd_file.log,
474: g_v_lbl_inv_term||' : '||NVL(l_c_ap_term.name,p_n_inv_pay_term));
475: fnd_file.put_line(fnd_file.log,

Line 473: fnd_file.put_line(fnd_file.log,

469: fnd_file.put_line(fnd_file.log,
470: g_v_lbl_suppl_type||' : '||NVL(l_c_sup_type.meaning,p_v_supplier_type));
471: fnd_file.put_line(fnd_file.log,
472: g_v_lbl_pay_grp||' : '||NVL(l_c_grp_type.meaning,g_v_lbl_pay_grp));
473: fnd_file.put_line(fnd_file.log,
474: g_v_lbl_inv_term||' : '||NVL(l_c_ap_term.name,p_n_inv_pay_term));
475: fnd_file.put_line(fnd_file.log,
476: g_v_lbl_test_run||' : '||NVL(igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_test_run),p_v_test_run));
477:

Line 475: fnd_file.put_line(fnd_file.log,

471: fnd_file.put_line(fnd_file.log,
472: g_v_lbl_pay_grp||' : '||NVL(l_c_grp_type.meaning,g_v_lbl_pay_grp));
473: fnd_file.put_line(fnd_file.log,
474: g_v_lbl_inv_term||' : '||NVL(l_c_ap_term.name,p_n_inv_pay_term));
475: fnd_file.put_line(fnd_file.log,
476: g_v_lbl_test_run||' : '||NVL(igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_test_run),p_v_test_run));
477:
478: fnd_file.new_line(fnd_file.log);
479:

Line 478: fnd_file.new_line(fnd_file.log);

474: g_v_lbl_inv_term||' : '||NVL(l_c_ap_term.name,p_n_inv_pay_term));
475: fnd_file.put_line(fnd_file.log,
476: g_v_lbl_test_run||' : '||NVL(igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_test_run),p_v_test_run));
477:
478: fnd_file.new_line(fnd_file.log);
479:
480: -- If Manage Accounts validation fails then log the message and return false
481: IF NOT l_b_run_process THEN
482: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

Line 482: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

478: fnd_file.new_line(fnd_file.log);
479:
480: -- If Manage Accounts validation fails then log the message and return false
481: IF NOT l_b_run_process THEN
482: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
483: RETURN FALSE;
484: END IF;
485:
486: -- get the refund destination

Line 494: fnd_file.put_line(fnd_file.log,

490: IF l_v_rfnd_destination = g_v_other OR l_v_rfnd_destination IS NULL THEN
491: l_b_val_parm := FALSE;
492: fnd_message.set_name('IGS',
493: 'IGS_FI_RFND_DST_PAY');
494: fnd_file.put_line(fnd_file.log,
495: fnd_message.get);
496: l_b_val_parm := FALSE;
497: RETURN l_b_val_parm;
498: END IF;

Line 507: fnd_file.put_line(fnd_file.log,

503: IF c_ctrl%NOTFOUND THEN
504: l_b_val_parm := FALSE;
505: fnd_message.set_name('IGS',
506: 'IGS_FI_SYSTEM_OPT_SETUP');
507: fnd_file.put_line(fnd_file.log,
508: fnd_message.get);
509: END IF;
510: CLOSE c_ctrl;
511:

Line 525: fnd_file.put_line(fnd_file.log,

521: IF l_c_fnd_prod.multi_org_flag = 'Y' THEN
522: l_b_val_parm := FALSE;
523: fnd_message.set_name('IGS',
524: 'IGS_FI_AP_ORG_ID_NOTSETUP');
525: fnd_file.put_line(fnd_file.log,
526: fnd_message.get);
527: END IF;
528: END IF;
529:

Line 539: fnd_file.put_line(fnd_file.log,

535: IF p_v_create_supplier IS NULL OR p_v_test_run IS NULL OR p_n_inv_pay_term IS NULL THEN
536: l_b_val_parm := FALSE;
537: fnd_message.set_name('IGS',
538: 'IGS_FI_PARAMETER_NULL');
539: fnd_file.put_line(fnd_file.log,
540: fnd_message.get);
541: END IF;
542:
543: -- If the Supplier Type parameter is not null but the create supplier parameter

Line 549: fnd_file.put_line(fnd_file.log,

545: IF p_v_supplier_type IS NOT NULL and p_v_create_supplier = 'N' THEN
546: l_b_val_parm := FALSE;
547: fnd_message.set_name('IGS',
548: 'IGS_FI_INV_SUP_TYPE');
549: fnd_file.put_line(fnd_file.log,
550: fnd_message.get);
551: END IF;
552:
553: -- If party validation has failed earlier

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

553: -- If party validation has failed earlier
554: IF NOT l_b_party_flag THEN
555: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
556: fnd_message.set_token('PARAMETER',g_v_lbl_party);
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558: END IF;
559:
560: -- If the person group validation has failed earlier or the person group
561: -- is closed, then error message is logged

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

561: -- is closed, then error message is logged
562: IF NOT l_b_pers_grp_flag OR NVL(l_c_pers_id_grp.closed_ind,'N') = 'Y' THEN
563: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
564: fnd_message.set_token('PARAMETER',g_v_lbl_person_group);
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: END IF;
567:
568: -- If the Supplier Type validation has failed earlier or the inactive date of the
569: -- supplier type is less than System Date, then error message is logged

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

569: -- supplier type is less than System Date, then error message is logged
570: IF (NOT l_b_sup_type_flag) OR NOT (TRUNC(NVL(l_c_sup_type.inactive_date,sysdate)) >= TRUNC(sysdate)) THEN
571: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
572: fnd_message.set_token('PARAMETER',g_v_lbl_suppl_type);
573: fnd_file.put_line(fnd_file.log, fnd_message.get);
574: END IF;
575:
576: -- The Invoice Pay group parameter validation has failed earlier or the inactive date of the
577: -- Invoice Pay group is less than the current date, then error message is logged

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

577: -- Invoice Pay group is less than the current date, then error message is logged
578: IF (NOT l_b_inv_pay_grp_flag) OR NOT (TRUNC(NVL(l_c_grp_type.inactive_date,sysdate)) >= TRUNC(sysdate)) THEN
579: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
580: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);
581: fnd_file.put_line(fnd_file.log, fnd_message.get);
582: END IF;
583:
584: -- If the Term Id passed as input parameter does not exist
585: IF NOT l_b_term_flag THEN

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

584: -- If the Term Id passed as input parameter does not exist
585: IF NOT l_b_term_flag THEN
586: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
587: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);
588: fnd_file.put_line(fnd_file.log, fnd_message.get);
589: END IF;
590:
591: -- If the sysdate is not within the Start date active and end date active
592: -- of the Term passed as input, log an error message in the log file

Line 598: fnd_file.put_line(fnd_file.log,

594: TRUNC(NVL(l_c_ap_term.end_date_active, sysdate))) THEN
595: l_b_val_parm := FALSE;
596: fnd_message.set_name('IGS','IGS_FI_AP_TERM_INACTIVE');
597: fnd_message.set_token('TERM_NAME',l_c_ap_term.name);
598: fnd_file.put_line(fnd_file.log,
599: fnd_message.get);
600: END IF;
601:
602: -- If the create supplier parameter is not in Y/N, then log the

Line 608: fnd_file.put_line(fnd_file.log,

604: IF p_v_create_supplier NOT IN ('Y','N') THEN
605: l_b_val_parm := FALSE;
606: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
607: fnd_message.set_token('PARAMETER',g_v_lbl_create_suppl);
608: fnd_file.put_line(fnd_file.log,
609: fnd_message.get);
610: END IF;
611:
612: -- If the test run parameter is not in Y/N, then log the

Line 618: fnd_file.put_line(fnd_file.log,

614: IF p_v_test_run NOT IN ('Y','N') THEN
615: l_b_val_parm := FALSE;
616: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
617: fnd_message.set_token('PARAMETER',g_v_lbl_test_run);
618: fnd_file.put_line(fnd_file.log,
619: fnd_message.get);
620: END IF;
621:
622: -- call the procedure for getting the currency code

Line 632: fnd_file.put_line(fnd_file.log,

628: -- error message in the log file
629: IF g_v_cur_code IS NULL THEN
630: l_b_val_parm := FALSE;
631: fnd_message.set_name('IGS',l_v_message_name);
632: fnd_file.put_line(fnd_file.log,
633: fnd_message.get);
634: END IF;
635:
636: -- Get the value of the Supplier Number parameter

Line 652: fnd_file.put_line(fnd_file.log,

648: IF g_v_sup_num IS NULL THEN
649: IF NVL(g_v_ven_num_code,g_v_automatic) <> g_v_automatic THEN
650: l_b_val_parm := FALSE;
651: fnd_message.set_name('IGS','IGS_FI_PROFL_SUP_NUM_NOT_SET');
652: fnd_file.put_line(fnd_file.log,
653: fnd_message.get);
654: END IF;
655: END IF;
656:

Line 665: fnd_file.put_line(fnd_file.log,

661: -- then log the error message in the log file.
662: IF g_v_sup_name IS NULL THEN
663: l_b_val_parm := FALSE;
664: fnd_message.set_name('IGS','IGS_FI_PROFL_SUP_NAME_NOT_SET');
665: fnd_file.put_line(fnd_file.log,
666: fnd_message.get);
667: END IF;
668:
669: -- Get the value of the profile 'Student Finance Pay Voucher Alone'

Line 677: fnd_file.put_line(fnd_file.log,

673: -- in the log file
674: IF g_v_pay_rfnd_vchr IS NULL THEN
675: l_b_val_parm := FALSE;
676: fnd_message.set_name('IGS','IGS_FI_PROFL_PAY_RFND_NOT_SET');
677: fnd_file.put_line(fnd_file.log,
678: fnd_message.get);
679: END IF;
680:
681: -- If the Party Id and the Person Group both are passed as input to

Line 686: fnd_file.put_line(fnd_file.log,

682: -- the process, then log error message
683: IF p_n_party_id IS NOT NULL AND p_n_person_group_id IS NOT NULL THEN
684: l_b_val_parm := FALSE;
685: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
686: fnd_file.put_line(fnd_file.log,
687: fnd_message.get);
688: END IF;
689:
690: -- If any of the validations has failed, then RETURN False

Line 918: fnd_file.put_line(fnd_file.log,

914: OPEN c_po_active(l_c_prty_rel.vendor_id);
915: FETCH c_po_active INTO l_v_var;
916: IF c_po_active%NOTFOUND THEN
917: p_b_status := FALSE;
918: fnd_file.put_line(fnd_file.log,
919: g_v_lbl_status||' : '||g_v_lbl_todo);
920: fnd_message.set_name('IGS','IGS_FI_SUPPLIER_INACTIVE');
921: fnd_file.put_line(fnd_file.log,
922: fnd_message.get);

Line 921: fnd_file.put_line(fnd_file.log,

917: p_b_status := FALSE;
918: fnd_file.put_line(fnd_file.log,
919: g_v_lbl_status||' : '||g_v_lbl_todo);
920: fnd_message.set_name('IGS','IGS_FI_SUPPLIER_INACTIVE');
921: fnd_file.put_line(fnd_file.log,
922: fnd_message.get);
923: END IF;
924: CLOSE c_po_active;
925:

Line 987: fnd_file.put_line(fnd_file.log,

983: x_exception_msg => l_v_msg); */
984: EXCEPTION
985: WHEN OTHERS THEN
986: l_v_site_status := 'F';
987: fnd_file.put_line(fnd_file.log,
988: g_v_lbl_status||' : '||g_v_lbl_todo);
989: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
990: END;
991: IF l_v_site_status <> 'S' THEN

Line 989: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);

985: WHEN OTHERS THEN
986: l_v_site_status := 'F';
987: fnd_file.put_line(fnd_file.log,
988: g_v_lbl_status||' : '||g_v_lbl_todo);
989: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
990: END;
991: IF l_v_site_status <> 'S' THEN
992: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_UPD');
993: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);

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

990: END;
991: IF l_v_site_status <> 'S' THEN
992: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_UPD');
993: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
994: fnd_file.put_line(fnd_file.log, fnd_message.get);
995: p_b_status := FALSE;
996: RETURN;
997: END IF;
998: ELSE

Line 1035: fnd_file.put_line(fnd_file.log,

1031: */
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: l_v_site_status := 'F';
1035: fnd_file.put_line(fnd_file.log,
1036: g_v_lbl_status||' : '||g_v_lbl_todo);
1037: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1038: END;
1039: IF l_v_site_status <> 'S' THEN

Line 1037: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);

1033: WHEN OTHERS THEN
1034: l_v_site_status := 'F';
1035: fnd_file.put_line(fnd_file.log,
1036: g_v_lbl_status||' : '||g_v_lbl_todo);
1037: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1038: END;
1039: IF l_v_site_status <> 'S' THEN
1040: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1041: fnd_message.set_name('PARTY_NUM',l_c_hz_party.party_number);

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

1038: END;
1039: IF l_v_site_status <> 'S' THEN
1040: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1041: fnd_message.set_name('PARTY_NUM',l_c_hz_party.party_number);
1042: fnd_file.put_line(fnd_file.log, fnd_message.get);
1043: p_b_status := FALSE;
1044: RETURN;
1045: END IF;
1046:

Line 1059: fnd_file.put_line(fnd_file.log,

1055:
1056: -- For the party, if the vendor relationship does not exist and the
1057: -- create supplier parameter is N, then exit
1058: IF g_v_create_supplier = 'N' THEN
1059: fnd_file.put_line(fnd_file.log,
1060: g_v_lbl_status||' : '||g_v_lbl_todo);
1061: fnd_message.set_name('IGS','IGS_FI_CREATE_SUPL_NO');
1062: fnd_message.set_token('PAYEE_NUM',l_c_hz_party.party_number);
1063: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

1059: fnd_file.put_line(fnd_file.log,
1060: g_v_lbl_status||' : '||g_v_lbl_todo);
1061: fnd_message.set_name('IGS','IGS_FI_CREATE_SUPL_NO');
1062: fnd_message.set_token('PAYEE_NUM',l_c_hz_party.party_number);
1063: fnd_file.put_line(fnd_file.log, fnd_message.get);
1064: p_b_status := FALSE;
1065: RETURN;
1066: END IF;
1067:

Line 1103: fnd_file.put_line(fnd_file.log,

1099: p_b_status => l_b_status);
1100:
1101: -- If the vendor number cannot be derived, then exit.
1102: IF NOT l_b_status THEN
1103: fnd_file.put_line(fnd_file.log,
1104: g_v_lbl_status||' : '||g_v_lbl_todo);
1105: fnd_message.set_name('IGS','IGS_FI_SUP_NUM_NOT_DERIVED');
1106: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1107: fnd_file.put_line(fnd_file.log,

Line 1107: fnd_file.put_line(fnd_file.log,

1103: fnd_file.put_line(fnd_file.log,
1104: g_v_lbl_status||' : '||g_v_lbl_todo);
1105: fnd_message.set_name('IGS','IGS_FI_SUP_NUM_NOT_DERIVED');
1106: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1107: fnd_file.put_line(fnd_file.log,
1108: fnd_message.get);
1109: p_b_status := FALSE;
1110: RETURN;
1111: END IF;

Line 1133: fnd_file.put_line(fnd_file.log,

1129: x_exception_msg => l_v_msg); */
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: l_v_vendor_status := 'F';
1133: fnd_file.put_line(fnd_file.log,
1134: g_v_lbl_status||' : '||g_v_lbl_todo);
1135: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1136: END;
1137: IF l_v_vendor_status <> 'S' THEN

Line 1135: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);

1131: WHEN OTHERS THEN
1132: l_v_vendor_status := 'F';
1133: fnd_file.put_line(fnd_file.log,
1134: g_v_lbl_status||' : '||g_v_lbl_todo);
1135: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1136: END;
1137: IF l_v_vendor_status <> 'S' THEN
1138: fnd_message.set_name('IGS','IGS_FI_VENDOR_NOT_CREATED');
1139: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);

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

1136: END;
1137: IF l_v_vendor_status <> 'S' THEN
1138: fnd_message.set_name('IGS','IGS_FI_VENDOR_NOT_CREATED');
1139: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1140: fnd_file.put_line(fnd_file.log, fnd_message.get);
1141: p_b_status := FALSE;
1142: RETURN;
1143: END IF;
1144:

Line 1178: fnd_file.put_line(fnd_file.log,

1174: x_exception_msg => l_v_msg); */
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: l_v_site_status := 'F';
1178: fnd_file.put_line(fnd_file.log,
1179: g_v_lbl_status||' : '||g_v_lbl_todo);
1180: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1181: END;
1182: IF l_v_site_status <> 'S' THEN

Line 1180: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);

1176: WHEN OTHERS THEN
1177: l_v_site_status := 'F';
1178: fnd_file.put_line(fnd_file.log,
1179: g_v_lbl_status||' : '||g_v_lbl_todo);
1180: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1181: END;
1182: IF l_v_site_status <> 'S' THEN
1183: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1184: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);

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

1181: END;
1182: IF l_v_site_status <> 'S' THEN
1183: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1184: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1185: fnd_file.put_line(fnd_file.log, fnd_message.get);
1186: p_b_status := FALSE;
1187: RETURN;
1188: END IF;
1189:

Line 1374: fnd_file.put_line(fnd_file.log,

1370: l_c_rfnd_rec.transfer_status := g_v_offset;
1371: log_transaction(p_n_party_id => l_c_rfnd_rec.person_id,
1372: p_n_payee_id => l_c_rfnd_rec.pay_person_id,
1373: p_n_refund_id => l_c_rfnd_rec.refund_id);
1374: fnd_file.put_line(fnd_file.log,
1375: g_v_lbl_status||' : '||g_v_lbl_offset);
1376: fnd_file.new_line(fnd_file.log);
1377: update_refund_rec(l_c_rfnd_rec);
1378:

Line 1376: fnd_file.new_line(fnd_file.log);

1372: p_n_payee_id => l_c_rfnd_rec.pay_person_id,
1373: p_n_refund_id => l_c_rfnd_rec.refund_id);
1374: fnd_file.put_line(fnd_file.log,
1375: g_v_lbl_status||' : '||g_v_lbl_offset);
1376: fnd_file.new_line(fnd_file.log);
1377: update_refund_rec(l_c_rfnd_rec);
1378:
1379: l_c_rfnd_org.transfer_status := g_v_offset;
1380: log_transaction(p_n_party_id => l_c_rfnd_org.person_id,

Line 1383: fnd_file.put_line(fnd_file.log,

1379: l_c_rfnd_org.transfer_status := g_v_offset;
1380: log_transaction(p_n_party_id => l_c_rfnd_org.person_id,
1381: p_n_payee_id => l_c_rfnd_org.pay_person_id,
1382: p_n_refund_id => l_c_rfnd_org.refund_id);
1383: fnd_file.put_line(fnd_file.log,
1384: g_v_lbl_status||' : '||g_v_lbl_offset);
1385: fnd_file.new_line(fnd_file.log);
1386: update_refund_rec(l_c_rfnd_org);
1387:

Line 1385: fnd_file.new_line(fnd_file.log);

1381: p_n_payee_id => l_c_rfnd_org.pay_person_id,
1382: p_n_refund_id => l_c_rfnd_org.refund_id);
1383: fnd_file.put_line(fnd_file.log,
1384: g_v_lbl_status||' : '||g_v_lbl_offset);
1385: fnd_file.new_line(fnd_file.log);
1386: update_refund_rec(l_c_rfnd_org);
1387:
1388: ELSIF l_c_rfnd_org.transfer_status = 'TRANSFERRED' THEN
1389:

Line 1423: fnd_file.put_line(fnd_file.log,

1419: l_c_rfnd_rec.transfer_status := g_v_transferred;
1420:
1421: -- Update the refund transaction to TRANSFERRED status
1422: update_refund_rec(l_c_rfnd_rec);
1423: fnd_file.put_line(fnd_file.log,
1424: g_v_lbl_status||' : '||g_v_lbl_transferred);
1425: fnd_file.new_line(fnd_file.log);
1426: END IF;
1427: EXCEPTION

Line 1425: fnd_file.new_line(fnd_file.log);

1421: -- Update the refund transaction to TRANSFERRED status
1422: update_refund_rec(l_c_rfnd_rec);
1423: fnd_file.put_line(fnd_file.log,
1424: g_v_lbl_status||' : '||g_v_lbl_transferred);
1425: fnd_file.new_line(fnd_file.log);
1426: END IF;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: ROLLBACK TO SP_PROCESS;

Line 1430: fnd_file.put_line(fnd_file.log,

1426: END IF;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: ROLLBACK TO SP_PROCESS;
1430: fnd_file.put_line(fnd_file.log,
1431: g_v_lbl_status||' : '||g_v_lbl_todo);
1432: fnd_file.put_line(fnd_file.log,
1433: g_v_lbl_error||':'||sqlerrm);
1434: fnd_file.new_line(fnd_file.log);

Line 1432: fnd_file.put_line(fnd_file.log,

1428: WHEN OTHERS THEN
1429: ROLLBACK TO SP_PROCESS;
1430: fnd_file.put_line(fnd_file.log,
1431: g_v_lbl_status||' : '||g_v_lbl_todo);
1432: fnd_file.put_line(fnd_file.log,
1433: g_v_lbl_error||':'||sqlerrm);
1434: fnd_file.new_line(fnd_file.log);
1435: END;
1436: END IF;

Line 1434: fnd_file.new_line(fnd_file.log);

1430: fnd_file.put_line(fnd_file.log,
1431: g_v_lbl_status||' : '||g_v_lbl_todo);
1432: fnd_file.put_line(fnd_file.log,
1433: g_v_lbl_error||':'||sqlerrm);
1434: fnd_file.new_line(fnd_file.log);
1435: END;
1436: END IF;
1437: END LOOP;
1438:

Line 1473: fnd_file.put_line(fnd_file.log,

1469:
1470: -- Update the refund transaction to the status of Transferred
1471: l_c_rfnd_rec.transfer_status := g_v_transferred;
1472: update_refund_rec(l_c_rfnd_rec);
1473: fnd_file.put_line(fnd_file.log,
1474: g_v_lbl_status||' : '||g_v_lbl_transferred);
1475: END IF;
1476: EXCEPTION
1477: WHEN OTHERS THEN

Line 1479: fnd_file.put_line(fnd_file.log,

1475: END IF;
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: ROLLBACK TO SP_PROCESS;
1479: fnd_file.put_line(fnd_file.log,
1480: g_v_lbl_status||' : '||g_v_lbl_todo);
1481: fnd_file.put_line(fnd_file.log,
1482: g_v_lbl_error||':'||sqlerrm);
1483: fnd_file.new_line(fnd_file.log);

Line 1481: fnd_file.put_line(fnd_file.log,

1477: WHEN OTHERS THEN
1478: ROLLBACK TO SP_PROCESS;
1479: fnd_file.put_line(fnd_file.log,
1480: g_v_lbl_status||' : '||g_v_lbl_todo);
1481: fnd_file.put_line(fnd_file.log,
1482: g_v_lbl_error||':'||sqlerrm);
1483: fnd_file.new_line(fnd_file.log);
1484: END;
1485: END LOOP;

Line 1483: fnd_file.new_line(fnd_file.log);

1479: fnd_file.put_line(fnd_file.log,
1480: g_v_lbl_status||' : '||g_v_lbl_todo);
1481: fnd_file.put_line(fnd_file.log,
1482: g_v_lbl_error||':'||sqlerrm);
1483: fnd_file.new_line(fnd_file.log);
1484: END;
1485: END LOOP;
1486: END process_refunds;
1487:

Line 1575: fnd_file.put_line(fnd_file.log, l_v_stmnt);

1571: p_status => l_v_status,
1572: p_group_type => lv_group_type);
1573:
1574: IF l_v_status <> 'S' THEN
1575: fnd_file.put_line(fnd_file.log, l_v_stmnt);
1576: RETURN;
1577: END IF;
1578:
1579: -- Execute the query returned by the procedure and for all the person id

Line 1616: fnd_file.put_line(fnd_file.log,

1612: IF (p_v_test_run = 'Y' AND g_b_data_found) THEN
1613: ROLLBACK TO SP_TRANSFER;
1614: fnd_message.set_name('IGS',
1615: 'IGS_FI_PRC_TEST_RUN');
1616: fnd_file.put_line(fnd_file.log,
1617: fnd_message.get);
1618: ELSE
1619: COMMIT;
1620: END IF;

Line 1626: fnd_file.put_line(fnd_file.log,

1622: -- If there are no records found then log the message No Data Found
1623: IF NOT g_b_data_found THEN
1624: fnd_message.set_name('IGS',
1625: 'IGS_GE_NO_DATA_FOUND');
1626: fnd_file.put_line(fnd_file.log,
1627: fnd_message.get);
1628: END IF;
1629:
1630: EXCEPTION

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

1631: WHEN e_resource_busy THEN
1632: retcode := 2;
1633: fnd_message.set_name('IGS',
1634: 'IGS_FI_RFND_REC_LOCK');
1635: fnd_file.put_line(fnd_file.log, fnd_message.get);
1636: WHEN OTHERS THEN
1637: retcode := 2;
1638: ROLLBACK TO SP_TRANSFER;
1639: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 1640: fnd_file.put_line(fnd_file.log,

1636: WHEN OTHERS THEN
1637: retcode := 2;
1638: ROLLBACK TO SP_TRANSFER;
1639: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1640: fnd_file.put_line(fnd_file.log,
1641: fnd_message.get||' - '||sqlerrm);
1642: END transfer;
1643:
1644: END igs_fi_prc_apint;