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

Line 83: fnd_file.put_line (fnd_file.LOG, SQLERRM);

79:
80: EXCEPTION
81: WHEN NO_DATA_FOUND
82: THEN
83: fnd_file.put_line (fnd_file.LOG, SQLERRM);
84: END;
85:
86: /*------------------------------------------------------------------------------------------------------------------------------------------
87: -----------Getting the Commercial Number for the Input Parameter of Legal Entity Id

Line 136: fnd_file.put_line (fnd_file.LOG, SQLERRM);

132: WHERE currency_code = lc_functcurr;
133: EXCEPTION
134: WHEN NO_DATA_FOUND
135: THEN
136: fnd_file.put_line (fnd_file.LOG, SQLERRM);
137: END;
138:
139:
140: -----------------------------------------------------------------------------------------------------------------------------------------------------

Line 419: fnd_file.put_line(fnd_file.log,'cp_year_start_date:'||cp_year_start_date);

415:
416:
417: BEGIN
418:
419: fnd_file.put_line(fnd_file.log,'cp_year_start_date:'||cp_year_start_date);
420: fnd_file.put_line(fnd_file.log,'cp_year_end_date:'||cp_year_end_date);
421: fnd_file.put_line(fnd_file.log,'p_legal_entity_id:'||p_legal_entity_id);
422: fnd_file.put_line(fnd_file.log,'lp_order_by:'||lp_order_by);
423:

Line 420: fnd_file.put_line(fnd_file.log,'cp_year_end_date:'||cp_year_end_date);

416:
417: BEGIN
418:
419: fnd_file.put_line(fnd_file.log,'cp_year_start_date:'||cp_year_start_date);
420: fnd_file.put_line(fnd_file.log,'cp_year_end_date:'||cp_year_end_date);
421: fnd_file.put_line(fnd_file.log,'p_legal_entity_id:'||p_legal_entity_id);
422: fnd_file.put_line(fnd_file.log,'lp_order_by:'||lp_order_by);
423:
424:

Line 421: fnd_file.put_line(fnd_file.log,'p_legal_entity_id:'||p_legal_entity_id);

417: BEGIN
418:
419: fnd_file.put_line(fnd_file.log,'cp_year_start_date:'||cp_year_start_date);
420: fnd_file.put_line(fnd_file.log,'cp_year_end_date:'||cp_year_end_date);
421: fnd_file.put_line(fnd_file.log,'p_legal_entity_id:'||p_legal_entity_id);
422: fnd_file.put_line(fnd_file.log,'lp_order_by:'||lp_order_by);
423:
424:
425: OPEN cur_withholding_extract(p_legal_entity_id,cp_year_start_date,cp_year_end_date,lp_order_by);

Line 422: fnd_file.put_line(fnd_file.log,'lp_order_by:'||lp_order_by);

418:
419: fnd_file.put_line(fnd_file.log,'cp_year_start_date:'||cp_year_start_date);
420: fnd_file.put_line(fnd_file.log,'cp_year_end_date:'||cp_year_end_date);
421: fnd_file.put_line(fnd_file.log,'p_legal_entity_id:'||p_legal_entity_id);
422: fnd_file.put_line(fnd_file.log,'lp_order_by:'||lp_order_by);
423:
424:
425: OPEN cur_withholding_extract(p_legal_entity_id,cp_year_start_date,cp_year_end_date,lp_order_by);
426: LOOP

Line 442: fnd_file.put_line(fnd_file.log,'Starting Invoice Id..'||cur_withholding_extract_rec.invoice_id );

438: -- IF(cur_withholding_invoice_rec.rec_count > 1) THEN
439:
440: IF(cur_withholding_invoice_rec.rec_count >= 1) THEN
441:
442: fnd_file.put_line(fnd_file.log,'Starting Invoice Id..'||cur_withholding_extract_rec.invoice_id );
443:
444: BEGIN
445:
446: /* bug14369763

Line 476: fnd_file.put_line(fnd_file.log,'ln_ex_amount:'||ln_ex_amount);

472: --ln_ex_amount := nvl(ln_ex_amount1,0) + nvl(ln_ex_amount2,0);
473: ln_ex_amount := nvl(ln_ex_amount2,0);
474: --bug14369763 - end
475:
476: fnd_file.put_line(fnd_file.log,'ln_ex_amount:'||ln_ex_amount);
477:
478: EXCEPTION
479: WHEN NO_DATA_FOUND
480: THEN

Line 482: fnd_file.put_line(fnd_file.log,'no data found for ln_ex_amount'||ln_ex_amount);

478: EXCEPTION
479: WHEN NO_DATA_FOUND
480: THEN
481: ln_ex_amount := 0;
482: fnd_file.put_line(fnd_file.log,'no data found for ln_ex_amount'||ln_ex_amount);
483:
484: END;
485:
486: BEGIN

Line 524: fnd_file.put_line(fnd_file.log,'ln_tax_amount:'||ln_tax_amount);

520: --ln_tax_amount := NVL (ln_tax_amount_one, 0) + NVL (ln_tax_amount_two, 0);
521: ln_tax_amount := NVL (ln_tax_amount_two, 0);
522: --bug14369763 - end
523:
524: fnd_file.put_line(fnd_file.log,'ln_tax_amount:'||ln_tax_amount);
525:
526: EXCEPTION
527: WHEN NO_DATA_FOUND
528: THEN

Line 530: fnd_file.put_line(fnd_file.log,'no data found for ln_tax_amount'||ln_tax_amount);

526: EXCEPTION
527: WHEN NO_DATA_FOUND
528: THEN
529: ln_tax_amount := 0;
530: fnd_file.put_line(fnd_file.log,'no data found for ln_tax_amount'||ln_tax_amount);
531:
532: END;
533:
534:

Line 549: fnd_file.put_line(fnd_file.log,'l_amount_etrd:'||l_amount_etrd);

545: where invoice_id = cur_withholding_extract_rec.invoice_id
546: and accounting_date between cp_year_start_date AND cp_year_end_date
547: group by invoice_id;
548:
549: fnd_file.put_line(fnd_file.log,'l_amount_etrd:'||l_amount_etrd);
550: fnd_file.put_line(fnd_file.log,'l_amount_paid:'||l_amount_paid);
551:
552: EXCEPTION
553: WHEN NO_DATA_FOUND

Line 550: fnd_file.put_line(fnd_file.log,'l_amount_paid:'||l_amount_paid);

546: and accounting_date between cp_year_start_date AND cp_year_end_date
547: group by invoice_id;
548:
549: fnd_file.put_line(fnd_file.log,'l_amount_etrd:'||l_amount_etrd);
550: fnd_file.put_line(fnd_file.log,'l_amount_paid:'||l_amount_paid);
551:
552: EXCEPTION
553: WHEN NO_DATA_FOUND
554: THEN

Line 556: fnd_file.put_line(fnd_file.log,'exception and no data found for l_amount_etrd:'||l_amount_etrd);

552: EXCEPTION
553: WHEN NO_DATA_FOUND
554: THEN
555: null;
556: fnd_file.put_line(fnd_file.log,'exception and no data found for l_amount_etrd:'||l_amount_etrd);
557: fnd_file.put_line(fnd_file.log,'exception and no data found for l_amount_paid:'||l_amount_paid);
558: END;
559:
560: -- to get ratio paid --bug14369763

Line 557: fnd_file.put_line(fnd_file.log,'exception and no data found for l_amount_paid:'||l_amount_paid);

553: WHEN NO_DATA_FOUND
554: THEN
555: null;
556: fnd_file.put_line(fnd_file.log,'exception and no data found for l_amount_etrd:'||l_amount_etrd);
557: fnd_file.put_line(fnd_file.log,'exception and no data found for l_amount_paid:'||l_amount_paid);
558: END;
559:
560: -- to get ratio paid --bug14369763
561: BEGIN

Line 580: fnd_file.put_line(fnd_file.log,'l_inv_gctot_base:'||l_inv_gctot_base);

576: where pay.invoice_payment_id = decode(dist.line_type_lookup_code,'AWT',
577: dist.awt_invoice_payment_id,pay.invoice_payment_id)
578: and pay.accounting_date between cp_year_start_date AND cp_year_end_date);
579:
580: fnd_file.put_line(fnd_file.log,'l_inv_gctot_base:'||l_inv_gctot_base);
581: fnd_file.put_line(fnd_file.log,'l_inv_gctot_etrd:'||l_inv_gctot_etrd);
582: fnd_file.put_line(fnd_file.log,'l_inv_whtot_base:'||l_inv_whtot_base);
583: fnd_file.put_line(fnd_file.log,'l_inv_whtot_etrd:'||l_inv_whtot_etrd);
584:

Line 581: fnd_file.put_line(fnd_file.log,'l_inv_gctot_etrd:'||l_inv_gctot_etrd);

577: dist.awt_invoice_payment_id,pay.invoice_payment_id)
578: and pay.accounting_date between cp_year_start_date AND cp_year_end_date);
579:
580: fnd_file.put_line(fnd_file.log,'l_inv_gctot_base:'||l_inv_gctot_base);
581: fnd_file.put_line(fnd_file.log,'l_inv_gctot_etrd:'||l_inv_gctot_etrd);
582: fnd_file.put_line(fnd_file.log,'l_inv_whtot_base:'||l_inv_whtot_base);
583: fnd_file.put_line(fnd_file.log,'l_inv_whtot_etrd:'||l_inv_whtot_etrd);
584:
585:

Line 582: fnd_file.put_line(fnd_file.log,'l_inv_whtot_base:'||l_inv_whtot_base);

578: and pay.accounting_date between cp_year_start_date AND cp_year_end_date);
579:
580: fnd_file.put_line(fnd_file.log,'l_inv_gctot_base:'||l_inv_gctot_base);
581: fnd_file.put_line(fnd_file.log,'l_inv_gctot_etrd:'||l_inv_gctot_etrd);
582: fnd_file.put_line(fnd_file.log,'l_inv_whtot_base:'||l_inv_whtot_base);
583: fnd_file.put_line(fnd_file.log,'l_inv_whtot_etrd:'||l_inv_whtot_etrd);
584:
585:
586: select decode(inv.invoice_currency_code,inv.payment_currency_code,l_inv_gctot_etrd,l_inv_gctot_base),

Line 583: fnd_file.put_line(fnd_file.log,'l_inv_whtot_etrd:'||l_inv_whtot_etrd);

579:
580: fnd_file.put_line(fnd_file.log,'l_inv_gctot_base:'||l_inv_gctot_base);
581: fnd_file.put_line(fnd_file.log,'l_inv_gctot_etrd:'||l_inv_gctot_etrd);
582: fnd_file.put_line(fnd_file.log,'l_inv_whtot_base:'||l_inv_whtot_base);
583: fnd_file.put_line(fnd_file.log,'l_inv_whtot_etrd:'||l_inv_whtot_etrd);
584:
585:
586: select decode(inv.invoice_currency_code,inv.payment_currency_code,l_inv_gctot_etrd,l_inv_gctot_base),
587: decode(inv.invoice_currency_code,inv.payment_currency_code,l_inv_whtot_etrd,l_inv_whtot_base),

Line 595: fnd_file.put_line(fnd_file.log,'l_inv_gctot_amt:'||l_inv_gctot_amt);

591: l_pay_amount
592: from ap_invoices inv
593: where inv.invoice_id = cur_withholding_extract_rec.invoice_id;
594:
595: fnd_file.put_line(fnd_file.log,'l_inv_gctot_amt:'||l_inv_gctot_amt);
596: fnd_file.put_line(fnd_file.log,'l_inv_whtot_amt:'||l_inv_whtot_amt);
597: fnd_file.put_line(fnd_file.log,'l_pay_amount:'||l_pay_amount);
598:
599:

Line 596: fnd_file.put_line(fnd_file.log,'l_inv_whtot_amt:'||l_inv_whtot_amt);

592: from ap_invoices inv
593: where inv.invoice_id = cur_withholding_extract_rec.invoice_id;
594:
595: fnd_file.put_line(fnd_file.log,'l_inv_gctot_amt:'||l_inv_gctot_amt);
596: fnd_file.put_line(fnd_file.log,'l_inv_whtot_amt:'||l_inv_whtot_amt);
597: fnd_file.put_line(fnd_file.log,'l_pay_amount:'||l_pay_amount);
598:
599:
600: if nvl(l_inv_gctot_amt,0) <> 0 then

Line 597: fnd_file.put_line(fnd_file.log,'l_pay_amount:'||l_pay_amount);

593: where inv.invoice_id = cur_withholding_extract_rec.invoice_id;
594:
595: fnd_file.put_line(fnd_file.log,'l_inv_gctot_amt:'||l_inv_gctot_amt);
596: fnd_file.put_line(fnd_file.log,'l_inv_whtot_amt:'||l_inv_whtot_amt);
597: fnd_file.put_line(fnd_file.log,'l_pay_amount:'||l_pay_amount);
598:
599:
600: if nvl(l_inv_gctot_amt,0) <> 0 then
601: ln_ratio_paid := round((l_pay_amount + (-1) * l_inv_whtot_amt)/l_inv_gctot_amt,10);

Line 604: fnd_file.put_line(fnd_file.log,'ln_ratio_paid:'||ln_ratio_paid);

600: if nvl(l_inv_gctot_amt,0) <> 0 then
601: ln_ratio_paid := round((l_pay_amount + (-1) * l_inv_whtot_amt)/l_inv_gctot_amt,10);
602: end if;
603:
604: fnd_file.put_line(fnd_file.log,'ln_ratio_paid:'||ln_ratio_paid);
605:
606: EXCEPTION
607: WHEN NO_DATA_FOUND
608: THEN

Line 610: fnd_file.put_line(fnd_file.log,'exception and no data found for ratio paid'||ln_ratio_paid);

606: EXCEPTION
607: WHEN NO_DATA_FOUND
608: THEN
609: ln_ratio_paid := 1;
610: fnd_file.put_line(fnd_file.log,'exception and no data found for ratio paid'||ln_ratio_paid);
611:
612: END;
613:
614:

Line 630: fnd_file.put_line(fnd_file.log,'ln_awt_group_id:'||ln_awt_group_id);

626: AND dist.line_type_lookup_code ='AWT'
627: AND inv.invoice_id = cur_withholding_extract_rec.invoice_id
628: );
629:
630: fnd_file.put_line(fnd_file.log,'ln_awt_group_id:'||ln_awt_group_id);
631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: null;

Line 635: fnd_file.put_line(fnd_file.log,'EXCEPTION in getting group_id in ln_awt_group_id:'||ln_awt_group_id);

631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: null;
635: fnd_file.put_line(fnd_file.log,'EXCEPTION in getting group_id in ln_awt_group_id:'||ln_awt_group_id);
636: END;
637:
638: -- to get gross amount --bug14369763
639:

Line 667: fnd_file.put_line(fnd_file.log,'ln_gross_amount:'||ln_gross_amount);

663:
664:
665: ln_gross_amount := round(ln_ratio_paid * ln_gross_amount, cp_precision);
666:
667: fnd_file.put_line(fnd_file.log,'ln_gross_amount:'||ln_gross_amount);
668:
669: EXCEPTION
670: WHEN NO_DATA_FOUND
671: THEN

Line 673: fnd_file.put_line(fnd_file.log,'exception and no data found for gross amount'||ln_gross_amount);

669: EXCEPTION
670: WHEN NO_DATA_FOUND
671: THEN
672: ln_gross_amount := 0;
673: fnd_file.put_line(fnd_file.log,'exception and no data found for gross amount'||ln_gross_amount);
674: END;
675:
676:
677:

Line 682: fnd_file.put_line(fnd_file.log,'g_irpef:'||g_irpef);

678:
679:
680: BEGIN
681:
682: fnd_file.put_line(fnd_file.log,'g_irpef:'||g_irpef);
683:
684: SELECT awt.tax_rate, awt.tax_name,
685: ROUND (SUM (NVL (dist.base_amount, dist.amount)) * (-1),
686: cp_precision

Line 709: fnd_file.put_line(fnd_file.log,'ln_irpef_rate:'||ln_irpef_rate);

705: AND aps.vendor_name = g_irpef
706: AND aps.vendor_type_lookup_code = 'TAX AUTHORITY'
707: GROUP BY awt.tax_rate, awt.tax_name, aps.vendor_name;
708:
709: fnd_file.put_line(fnd_file.log,'ln_irpef_rate:'||ln_irpef_rate);
710: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname:'||lc_irpef_taxname);
711: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount:'||ln_irpef_wthamount);
712: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name:'||lc_irpef_vendor_name);
713:

Line 710: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname:'||lc_irpef_taxname);

706: AND aps.vendor_type_lookup_code = 'TAX AUTHORITY'
707: GROUP BY awt.tax_rate, awt.tax_name, aps.vendor_name;
708:
709: fnd_file.put_line(fnd_file.log,'ln_irpef_rate:'||ln_irpef_rate);
710: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname:'||lc_irpef_taxname);
711: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount:'||ln_irpef_wthamount);
712: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name:'||lc_irpef_vendor_name);
713:
714: EXCEPTION

Line 711: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount:'||ln_irpef_wthamount);

707: GROUP BY awt.tax_rate, awt.tax_name, aps.vendor_name;
708:
709: fnd_file.put_line(fnd_file.log,'ln_irpef_rate:'||ln_irpef_rate);
710: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname:'||lc_irpef_taxname);
711: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount:'||ln_irpef_wthamount);
712: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name:'||lc_irpef_vendor_name);
713:
714: EXCEPTION
715: WHEN NO_DATA_FOUND

Line 712: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name:'||lc_irpef_vendor_name);

708:
709: fnd_file.put_line(fnd_file.log,'ln_irpef_rate:'||ln_irpef_rate);
710: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname:'||lc_irpef_taxname);
711: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount:'||ln_irpef_wthamount);
712: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name:'||lc_irpef_vendor_name);
713:
714: EXCEPTION
715: WHEN NO_DATA_FOUND
716: THEN

Line 722: fnd_file.put_line(fnd_file.log,'no data found');

718: lc_irpef_taxname := NULL;
719: ln_irpef_wthamount := 0;
720: lc_irpef_vendor_name := NULL;
721:
722: fnd_file.put_line(fnd_file.log,'no data found');
723: fnd_file.put_line(fnd_file.log,'ln_irpef_rate2:'||ln_irpef_rate);
724: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname2:'||lc_irpef_taxname);
725: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount2:'||ln_irpef_wthamount);
726: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name2:'||lc_irpef_vendor_name);

Line 723: fnd_file.put_line(fnd_file.log,'ln_irpef_rate2:'||ln_irpef_rate);

719: ln_irpef_wthamount := 0;
720: lc_irpef_vendor_name := NULL;
721:
722: fnd_file.put_line(fnd_file.log,'no data found');
723: fnd_file.put_line(fnd_file.log,'ln_irpef_rate2:'||ln_irpef_rate);
724: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname2:'||lc_irpef_taxname);
725: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount2:'||ln_irpef_wthamount);
726: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name2:'||lc_irpef_vendor_name);
727:

Line 724: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname2:'||lc_irpef_taxname);

720: lc_irpef_vendor_name := NULL;
721:
722: fnd_file.put_line(fnd_file.log,'no data found');
723: fnd_file.put_line(fnd_file.log,'ln_irpef_rate2:'||ln_irpef_rate);
724: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname2:'||lc_irpef_taxname);
725: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount2:'||ln_irpef_wthamount);
726: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name2:'||lc_irpef_vendor_name);
727:
728:

Line 725: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount2:'||ln_irpef_wthamount);

721:
722: fnd_file.put_line(fnd_file.log,'no data found');
723: fnd_file.put_line(fnd_file.log,'ln_irpef_rate2:'||ln_irpef_rate);
724: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname2:'||lc_irpef_taxname);
725: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount2:'||ln_irpef_wthamount);
726: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name2:'||lc_irpef_vendor_name);
727:
728:
729: END;

Line 726: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name2:'||lc_irpef_vendor_name);

722: fnd_file.put_line(fnd_file.log,'no data found');
723: fnd_file.put_line(fnd_file.log,'ln_irpef_rate2:'||ln_irpef_rate);
724: fnd_file.put_line(fnd_file.log,'lc_irpef_taxname2:'||lc_irpef_taxname);
725: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount2:'||ln_irpef_wthamount);
726: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name2:'||lc_irpef_vendor_name);
727:
728:
729: END;
730:

Line 733: fnd_file.put_line(fnd_file.log,'g_inps:'||g_inps);

729: END;
730:
731: BEGIN
732:
733: fnd_file.put_line(fnd_file.log,'g_inps:'||g_inps);
734:
735:
736: SELECT awt.tax_rate, awt.tax_name,
737: ROUND (SUM (NVL (dist.base_amount, dist.amount)) * (-1),

Line 761: fnd_file.put_line(fnd_file.log,'ln_inps_rate:'||ln_inps_rate);

757: AND aps.vendor_name = g_inps
758: AND aps.vendor_type_lookup_code = 'TAX AUTHORITY'
759: GROUP BY awt.tax_rate, awt.tax_name, aps.vendor_name;
760:
761: fnd_file.put_line(fnd_file.log,'ln_inps_rate:'||ln_inps_rate);
762: fnd_file.put_line(fnd_file.log,'lc_inps_taxname:'||lc_inps_taxname);
763: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount:'||ln_inps_wthamount);
764: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name:'||lc_inps_vendor_name);
765:

Line 762: fnd_file.put_line(fnd_file.log,'lc_inps_taxname:'||lc_inps_taxname);

758: AND aps.vendor_type_lookup_code = 'TAX AUTHORITY'
759: GROUP BY awt.tax_rate, awt.tax_name, aps.vendor_name;
760:
761: fnd_file.put_line(fnd_file.log,'ln_inps_rate:'||ln_inps_rate);
762: fnd_file.put_line(fnd_file.log,'lc_inps_taxname:'||lc_inps_taxname);
763: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount:'||ln_inps_wthamount);
764: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name:'||lc_inps_vendor_name);
765:
766: EXCEPTION

Line 763: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount:'||ln_inps_wthamount);

759: GROUP BY awt.tax_rate, awt.tax_name, aps.vendor_name;
760:
761: fnd_file.put_line(fnd_file.log,'ln_inps_rate:'||ln_inps_rate);
762: fnd_file.put_line(fnd_file.log,'lc_inps_taxname:'||lc_inps_taxname);
763: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount:'||ln_inps_wthamount);
764: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name:'||lc_inps_vendor_name);
765:
766: EXCEPTION
767: WHEN NO_DATA_FOUND

Line 764: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name:'||lc_inps_vendor_name);

760:
761: fnd_file.put_line(fnd_file.log,'ln_inps_rate:'||ln_inps_rate);
762: fnd_file.put_line(fnd_file.log,'lc_inps_taxname:'||lc_inps_taxname);
763: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount:'||ln_inps_wthamount);
764: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name:'||lc_inps_vendor_name);
765:
766: EXCEPTION
767: WHEN NO_DATA_FOUND
768: THEN

Line 774: fnd_file.put_line(fnd_file.log,'no data found');

770: lc_inps_taxname := NULL;
771: ln_inps_wthamount := 0;
772: lc_inps_vendor_name := NULL;
773:
774: fnd_file.put_line(fnd_file.log,'no data found');
775: fnd_file.put_line(fnd_file.log,'ln_inps_rate2:'||ln_inps_rate);
776: fnd_file.put_line(fnd_file.log,'lc_inps_taxname2:'||lc_inps_taxname);
777: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount2:'||ln_inps_wthamount);
778: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name2:'||lc_inps_vendor_name);

Line 775: fnd_file.put_line(fnd_file.log,'ln_inps_rate2:'||ln_inps_rate);

771: ln_inps_wthamount := 0;
772: lc_inps_vendor_name := NULL;
773:
774: fnd_file.put_line(fnd_file.log,'no data found');
775: fnd_file.put_line(fnd_file.log,'ln_inps_rate2:'||ln_inps_rate);
776: fnd_file.put_line(fnd_file.log,'lc_inps_taxname2:'||lc_inps_taxname);
777: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount2:'||ln_inps_wthamount);
778: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name2:'||lc_inps_vendor_name);
779:

Line 776: fnd_file.put_line(fnd_file.log,'lc_inps_taxname2:'||lc_inps_taxname);

772: lc_inps_vendor_name := NULL;
773:
774: fnd_file.put_line(fnd_file.log,'no data found');
775: fnd_file.put_line(fnd_file.log,'ln_inps_rate2:'||ln_inps_rate);
776: fnd_file.put_line(fnd_file.log,'lc_inps_taxname2:'||lc_inps_taxname);
777: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount2:'||ln_inps_wthamount);
778: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name2:'||lc_inps_vendor_name);
779:
780: END;

Line 777: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount2:'||ln_inps_wthamount);

773:
774: fnd_file.put_line(fnd_file.log,'no data found');
775: fnd_file.put_line(fnd_file.log,'ln_inps_rate2:'||ln_inps_rate);
776: fnd_file.put_line(fnd_file.log,'lc_inps_taxname2:'||lc_inps_taxname);
777: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount2:'||ln_inps_wthamount);
778: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name2:'||lc_inps_vendor_name);
779:
780: END;
781:

Line 778: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name2:'||lc_inps_vendor_name);

774: fnd_file.put_line(fnd_file.log,'no data found');
775: fnd_file.put_line(fnd_file.log,'ln_inps_rate2:'||ln_inps_rate);
776: fnd_file.put_line(fnd_file.log,'lc_inps_taxname2:'||lc_inps_taxname);
777: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount2:'||ln_inps_wthamount);
778: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name2:'||lc_inps_vendor_name);
779:
780: END;
781:
782:

Line 787: fnd_file.put_line(fnd_file.log,'ln_net_amount:'||ln_net_amount);

783: -- to get net amount -- bug14369763
784: BEGIN
785: ln_net_amount := round(ln_gross_amount - ln_irpef_wthamount - ln_inps_wthamount, cp_precision);
786:
787: fnd_file.put_line(fnd_file.log,'ln_net_amount:'||ln_net_amount);
788:
789: EXCEPTION
790: WHEN NO_DATA_FOUND
791: THEN

Line 793: fnd_file.put_line(fnd_file.log,'EXCEPTION in getting ln_net_amount:'||ln_net_amount);

789: EXCEPTION
790: WHEN NO_DATA_FOUND
791: THEN
792: ln_net_amount := 0;
793: fnd_file.put_line(fnd_file.log,'EXCEPTION in getting ln_net_amount:'||ln_net_amount);
794: END;
795:
796: ----Prepayment
797: fnd_file.put_line(fnd_file.log,'Invoice Type Lookup Code...'||cur_withholding_extract_rec.invoice_type_lookup_code );

Line 797: fnd_file.put_line(fnd_file.log,'Invoice Type Lookup Code...'||cur_withholding_extract_rec.invoice_type_lookup_code );

793: fnd_file.put_line(fnd_file.log,'EXCEPTION in getting ln_net_amount:'||ln_net_amount);
794: END;
795:
796: ----Prepayment
797: fnd_file.put_line(fnd_file.log,'Invoice Type Lookup Code...'||cur_withholding_extract_rec.invoice_type_lookup_code );
798:
799: IF(cur_withholding_extract_rec.invoice_type_lookup_code = 'PREPAYMENT' ) THEN
800:
801: BEGIN

Line 814: fnd_file.put_line(fnd_file.log,'No Data Found.'||SQLERRM);

810: AND apdist1_sub.invoice_id = apinv_sub.invoice_id
811: AND apdist1_sub.reversal_flag <> 'Y';
812: EXCEPTION
813: WHEN NO_DATA_FOUND THEN
814: fnd_file.put_line(fnd_file.log,'No Data Found.'||SQLERRM);
815: ln_inv_num:=cur_withholding_extract_rec.invoice_num;
816:
817: WHEN TOO_MANY_ROWS THEN
818: fnd_file.put_line(fnd_file.log,'More Than One Invoice Record Found.'||SQLERRM);

Line 818: fnd_file.put_line(fnd_file.log,'More Than One Invoice Record Found.'||SQLERRM);

814: fnd_file.put_line(fnd_file.log,'No Data Found.'||SQLERRM);
815: ln_inv_num:=cur_withholding_extract_rec.invoice_num;
816:
817: WHEN TOO_MANY_ROWS THEN
818: fnd_file.put_line(fnd_file.log,'More Than One Invoice Record Found.'||SQLERRM);
819: ln_inv_num:= cur_withholding_extract_rec.invoice_num;
820: END;
821: ELSE
822: fnd_file.put_line(fnd_file.log,'Not a prepayment Invoice Type Lookup Code...'||cur_withholding_extract_rec.invoice_type_lookup_code );

Line 822: fnd_file.put_line(fnd_file.log,'Not a prepayment Invoice Type Lookup Code...'||cur_withholding_extract_rec.invoice_type_lookup_code );

818: fnd_file.put_line(fnd_file.log,'More Than One Invoice Record Found.'||SQLERRM);
819: ln_inv_num:= cur_withholding_extract_rec.invoice_num;
820: END;
821: ELSE
822: fnd_file.put_line(fnd_file.log,'Not a prepayment Invoice Type Lookup Code...'||cur_withholding_extract_rec.invoice_type_lookup_code );
823: ln_inv_num:= cur_withholding_extract_rec.invoice_num;
824: fnd_file.put_line(fnd_file.log,'ln_inv_num:'||ln_inv_num);
825: END IF;
826:

Line 824: fnd_file.put_line(fnd_file.log,'ln_inv_num:'||ln_inv_num);

820: END;
821: ELSE
822: fnd_file.put_line(fnd_file.log,'Not a prepayment Invoice Type Lookup Code...'||cur_withholding_extract_rec.invoice_type_lookup_code );
823: ln_inv_num:= cur_withholding_extract_rec.invoice_num;
824: fnd_file.put_line(fnd_file.log,'ln_inv_num:'||ln_inv_num);
825: END IF;
826:
827: --Checking for the Taxable amount in accordance with the Exempt Amount
828: --If Exempt Amount exits then Taxable amount should be 0

Line 833: --fnd_file.put_line(fnd_file.log,'I am in the > then condition so ln_tax_amount is now zero');

829:
830: --bug14369763
831: -- IF(ln_ex_amount > 0 ) THEN
832: -- ln_tax_amount := 0;
833: --fnd_file.put_line(fnd_file.log,'I am in the > then condition so ln_tax_amount is now zero');
834: -- END IF;
835:
836:
837:

Line 838: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_name'||cur_withholding_extract_rec.vendor_name);

834: -- END IF;
835:
836:
837:
838: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_name'||cur_withholding_extract_rec.vendor_name);
839: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_id'||cur_withholding_extract_rec.vendor_id);
840: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.taxpayer_id'||cur_withholding_extract_rec.taxpayer_id);
841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);
842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);

Line 839: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_id'||cur_withholding_extract_rec.vendor_id);

835:
836:
837:
838: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_name'||cur_withholding_extract_rec.vendor_name);
839: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_id'||cur_withholding_extract_rec.vendor_id);
840: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.taxpayer_id'||cur_withholding_extract_rec.taxpayer_id);
841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);
842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);
843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);

Line 840: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.taxpayer_id'||cur_withholding_extract_rec.taxpayer_id);

836:
837:
838: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_name'||cur_withholding_extract_rec.vendor_name);
839: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_id'||cur_withholding_extract_rec.vendor_id);
840: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.taxpayer_id'||cur_withholding_extract_rec.taxpayer_id);
841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);
842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);
843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);
844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);

Line 841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);

837:
838: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_name'||cur_withholding_extract_rec.vendor_name);
839: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_id'||cur_withholding_extract_rec.vendor_id);
840: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.taxpayer_id'||cur_withholding_extract_rec.taxpayer_id);
841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);
842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);
843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);
844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);
845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);

Line 842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);

838: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_name'||cur_withholding_extract_rec.vendor_name);
839: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_id'||cur_withholding_extract_rec.vendor_id);
840: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.taxpayer_id'||cur_withholding_extract_rec.taxpayer_id);
841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);
842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);
843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);
844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);
845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);
846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);

Line 843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);

839: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_id'||cur_withholding_extract_rec.vendor_id);
840: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.taxpayer_id'||cur_withholding_extract_rec.taxpayer_id);
841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);
842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);
843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);
844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);
845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);
846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);
847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);

Line 844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);

840: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.taxpayer_id'||cur_withholding_extract_rec.taxpayer_id);
841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);
842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);
843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);
844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);
845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);
846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);
847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);
848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);

Line 845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);

841: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.segment1'||cur_withholding_extract_rec.segment1);
842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);
843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);
844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);
845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);
846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);
847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);
848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);
849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);

Line 846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);

842: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_code'||cur_withholding_extract_rec.vendor_site_code);
843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);
844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);
845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);
846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);
847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);
848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);
849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);
850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);

Line 847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);

843: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vendor_site_id'||cur_withholding_extract_rec.vendor_site_id);
844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);
845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);
846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);
847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);
848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);
849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);
850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);
851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);

Line 848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);

844: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.vat_registration_num'||cur_withholding_extract_rec.vat_registration_num);
845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);
846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);
847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);
848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);
849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);
850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);
851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);
852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);

Line 849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);

845: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line1'||cur_withholding_extract_rec.address_line1);
846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);
847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);
848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);
849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);
850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);
851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);
852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);
853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);

Line 850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);

846: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line2'||cur_withholding_extract_rec.address_line2);
847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);
848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);
849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);
850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);
851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);
852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);
853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);
854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);

Line 851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);

847: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.address_line3'||cur_withholding_extract_rec.address_line3);
848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);
849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);
850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);
851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);
852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);
853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);
854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);
855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);

Line 852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);

848: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.supplier_address'||cur_withholding_extract_rec.supplier_address);
849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);
850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);
851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);
852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);
853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);
854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);
855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);

Line 853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);

849: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.city'||cur_withholding_extract_rec.city);
850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);
851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);
852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);
853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);
854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);
855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);
857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);

Line 854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);

850: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.zip'||cur_withholding_extract_rec.zip);
851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);
852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);
853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);
854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);
855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);
857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);
858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);

Line 855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);

851: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.province'||cur_withholding_extract_rec.province);
852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);
853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);
854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);
855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);
857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);
858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);
859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);

Line 856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);

852: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.country'||cur_withholding_extract_rec.country);
853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);
854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);
855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);
857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);
858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);
859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);

Line 857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);

853: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_id'||cur_withholding_extract_rec.invoice_id);
854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);
855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);
857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);
858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);
859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);
861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);

Line 858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);

854: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.invoice_amount'||cur_withholding_extract_rec.invoice_amount);
855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);
857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);
858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);
859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);
861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);
862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);

Line 859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);

855: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);
857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);
858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);
859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);
861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);
862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);
863: fnd_file.put_line(fnd_file.log,'p_legal_entity_id'||p_legal_entity_id);

Line 860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);

856: fnd_file.put_line(fnd_file.log,'ln_inv_num'||ln_inv_num);
857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);
858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);
859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);
861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);
862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);
863: fnd_file.put_line(fnd_file.log,'p_legal_entity_id'||p_legal_entity_id);
864: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name'||lc_inps_vendor_name);

Line 861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);

857: fnd_file.put_line(fnd_file.log,'ln_inps_wthamount'||ln_inps_wthamount);
858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);
859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);
861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);
862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);
863: fnd_file.put_line(fnd_file.log,'p_legal_entity_id'||p_legal_entity_id);
864: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name'||lc_inps_vendor_name);
865: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name'||lc_irpef_vendor_name);

Line 862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);

858: fnd_file.put_line(fnd_file.log,'ln_irpef_wthamount'||ln_irpef_wthamount);
859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);
861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);
862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);
863: fnd_file.put_line(fnd_file.log,'p_legal_entity_id'||p_legal_entity_id);
864: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name'||lc_inps_vendor_name);
865: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name'||lc_irpef_vendor_name);
866:

Line 863: fnd_file.put_line(fnd_file.log,'p_legal_entity_id'||p_legal_entity_id);

859: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.amount_paid'||cur_withholding_extract_rec.amount_paid);
860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);
861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);
862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);
863: fnd_file.put_line(fnd_file.log,'p_legal_entity_id'||p_legal_entity_id);
864: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name'||lc_inps_vendor_name);
865: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name'||lc_irpef_vendor_name);
866:
867:

Line 864: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name'||lc_inps_vendor_name);

860: fnd_file.put_line(fnd_file.log,'cur_withholding_extract_rec.exempt_amount'||cur_withholding_extract_rec.exempt_amount);
861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);
862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);
863: fnd_file.put_line(fnd_file.log,'p_legal_entity_id'||p_legal_entity_id);
864: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name'||lc_inps_vendor_name);
865: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name'||lc_irpef_vendor_name);
866:
867:
868:

Line 865: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name'||lc_irpef_vendor_name);

861: fnd_file.put_line(fnd_file.log,'ln_ex_amount'||ln_ex_amount);
862: fnd_file.put_line(fnd_file.log,'ln_tax_amount'||ln_tax_amount);
863: fnd_file.put_line(fnd_file.log,'p_legal_entity_id'||p_legal_entity_id);
864: fnd_file.put_line(fnd_file.log,'lc_inps_vendor_name'||lc_inps_vendor_name);
865: fnd_file.put_line(fnd_file.log,'lc_irpef_vendor_name'||lc_irpef_vendor_name);
866:
867:
868:
869: BEGIN

Line 922: fnd_file.put_line(fnd_file.log,'Unable to insert Record.'||SQLERRM);

918: );
919:
920: EXCEPTION
921: WHEN OTHERS THEN
922: fnd_file.put_line(fnd_file.log,'Unable to insert Record.'||SQLERRM);
923: END;
924: END IF;
925:
926: END LOOP;