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.JL_ZZ_AP_WITHHOLDING_PKG dependencies on JL_ZZ_AP_EXT_AWT_UTIL

Line 565: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('ACCOUNTING_DATE_before1 = '||to_char(P_CODE_ACCOUNTING_DATE)); -- Argentina AWT ER 6624809

561: -- the supplier
562: -----------------------------------------------------------
563: l_debug_info := 'Obtain tax name attributes for the supplier';
564:
565: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('ACCOUNTING_DATE_before1 = '||to_char(P_CODE_ACCOUNTING_DATE)); -- Argentina AWT ER 6624809
566: --Bug 10060465 Start
567: SELECT *
568: INTO P_Rec_Suppl_AWT_Name
569: FROM jl_zz_ap_sup_awt_cd jlsc

Line 582: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('ACCOUNTING_DATE_before2 = '||to_char(P_CODE_ACCOUNTING_DATE));

578: and NVL(jlsc.effective_end_date,To_Date('31-12-9999', 'DD-MM-YYYY'));
579:
580: /* IF P_CODE_ACCOUNTING_DATE IS NOT NULL then
581:
582: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('ACCOUNTING_DATE_before2 = '||to_char(P_CODE_ACCOUNTING_DATE));
583:
584: SELECT *
585: INTO P_Rec_Suppl_AWT_Name
586: FROM jl_zz_ap_sup_awt_cd jlsc

Line 600: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('ACCOUNTING_DATE_after3 = '||to_char(P_CODE_ACCOUNTING_DATE));

596:
597:
598: ELSE
599:
600: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('ACCOUNTING_DATE_after3 = '||to_char(P_CODE_ACCOUNTING_DATE));
601:
602:
603: SELECT *
604: INTO P_Rec_Suppl_AWT_Name

Line 851: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

847: 'Process_Withholding_Name';
848:
849: -- Debug Information
850: IF (DEBUG_Var = 'Y') THEN
851: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
852: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
853: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);

Line 852: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');

848:
849: -- Debug Information
850: IF (DEBUG_Var = 'Y') THEN
851: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
852: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
853: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));

Line 853: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));

849: -- Debug Information
850: IF (DEBUG_Var = 'Y') THEN
851: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
852: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
853: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
857: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));

Line 854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);

850: IF (DEBUG_Var = 'Y') THEN
851: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
852: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
853: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
857: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
858: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));

Line 855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);

851: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
852: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
853: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
857: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
858: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
859: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));

Line 856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));

852: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
853: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
857: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
858: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
859: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));
860: END IF;

Line 857: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));

853: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
857: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
858: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
859: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));
860: END IF;
861: -- End Debug

Line 858: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));

854: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
857: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
858: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
859: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));
860: END IF;
861: -- End Debug
862:

Line 859: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));

855: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
856: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
857: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
858: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
859: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));
860: END IF;
861: -- End Debug
862:
863: -----------------------------------

Line 886: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);

882: P_AWT_Success);
883:
884: -- Debug Information
885: IF (DEBUG_Var = 'Y') THEN
886: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);
887: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);
888: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));
889: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
890: END IF;

Line 887: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);

883:
884: -- Debug Information
885: IF (DEBUG_Var = 'Y') THEN
886: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);
887: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);
888: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));
889: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
890: END IF;
891: -- End Debug

Line 888: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));

884: -- Debug Information
885: IF (DEBUG_Var = 'Y') THEN
886: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);
887: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);
888: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));
889: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
890: END IF;
891: -- End Debug
892:

Line 889: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));

885: IF (DEBUG_Var = 'Y') THEN
886: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);
887: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);
888: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));
889: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
890: END IF;
891: -- End Debug
892:
893: l_cum_exemption_amt := Get_Cumulative_Supp_Exemp

Line 904: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs After Get Exemption Amount');

900: l_cumulative_withheld_amount := l_cumulative_withheld_amount + l_cum_exemption_amt;
901:
902: -- Debug Information
903: IF (DEBUG_Var = 'Y') THEN
904: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs After Get Exemption Amount');
905: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
906: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cum_exemption_amt: '||to_char(l_cum_exemption_amt));
907: END IF;
908: -- End Debug

Line 905: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));

901:
902: -- Debug Information
903: IF (DEBUG_Var = 'Y') THEN
904: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs After Get Exemption Amount');
905: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
906: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cum_exemption_amt: '||to_char(l_cum_exemption_amt));
907: END IF;
908: -- End Debug
909:

Line 906: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cum_exemption_amt: '||to_char(l_cum_exemption_amt));

902: -- Debug Information
903: IF (DEBUG_Var = 'Y') THEN
904: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs After Get Exemption Amount');
905: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
906: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cum_exemption_amt: '||to_char(l_cum_exemption_amt));
907: END IF;
908: -- End Debug
909:
910: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 928: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Taxable base amount: l_taxable_base_amount = '||to_char(l_taxable_base_amount));

924: END LOOP;
925:
926: -- Debug Information
927: IF (DEBUG_Var = 'Y') THEN
928: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Taxable base amount: l_taxable_base_amount = '||to_char(l_taxable_base_amount));
929: END IF;
930: -- End Debug
931:
932: ------------------------------------------------

Line 940: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh: l_subject_amount = '||to_char(l_subject_amount));

936: l_subject_amount := l_taxable_base_amount + l_cumulative_gross_amount;
937:
938: -- Debug Information
939: IF (DEBUG_Var = 'Y') THEN
940: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh: l_subject_amount = '||to_char(l_subject_amount));
941: END IF;
942: -- End Debug
943:
944: ---------------------------------------------------------------------

Line 974: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh for multilateral contribution ');

970: P_Rec_Suppl_AWT_Type.multilateral_rate / 100;
971:
972: -- Debug Information
973: IF (DEBUG_Var = 'Y') THEN
974: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh for multilateral contribution ');
975: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh MC: l_subject_amount = '||to_char(l_subject_amount));
976: END IF;
977: -- End Debug
978:

Line 975: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh MC: l_subject_amount = '||to_char(l_subject_amount));

971:
972: -- Debug Information
973: IF (DEBUG_Var = 'Y') THEN
974: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh for multilateral contribution ');
975: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh MC: l_subject_amount = '||to_char(l_subject_amount));
976: END IF;
977: -- End Debug
978:
979: END IF;

Line 994: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount < P_Rec_AWT_Name.Min_Tax_Base_Amt');

990: IF (ABS(l_subject_amount) < P_Rec_AWT_Name.Min_Tax_Base_Amt) THEN
991:
992: -- Debug Information
993: IF (DEBUG_Var = 'Y') THEN
994: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount < P_Rec_AWT_Name.Min_Tax_Base_Amt');
995: END IF;
996: -- End Debug
997:
998: l_withholding_is_required := FALSE;

Line 1026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Subtract the minimum taxable base amount');

1022: P_Rec_AWT_Name.Min_Tax_Base_Amt;
1023:
1024: -- Debug Information
1025: IF (DEBUG_Var = 'Y') THEN
1026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Subtract the minimum taxable base amount');
1027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount = '||to_char(l_subject_amount));
1028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' P_Rec_AWT_Name.Min_Tax_Base_Amt = '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
1029: END IF;
1030: -- End Debug

Line 1027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount = '||to_char(l_subject_amount));

1023:
1024: -- Debug Information
1025: IF (DEBUG_Var = 'Y') THEN
1026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Subtract the minimum taxable base amount');
1027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount = '||to_char(l_subject_amount));
1028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' P_Rec_AWT_Name.Min_Tax_Base_Amt = '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
1029: END IF;
1030: -- End Debug
1031:

Line 1028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' P_Rec_AWT_Name.Min_Tax_Base_Amt = '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));

1024: -- Debug Information
1025: IF (DEBUG_Var = 'Y') THEN
1026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Subtract the minimum taxable base amount');
1027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount = '||to_char(l_subject_amount));
1028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' P_Rec_AWT_Name.Min_Tax_Base_Amt = '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
1029: END IF;
1030: -- End Debug
1031:
1032: END IF;

Line 1053: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));

1049: P_AWT_Success);
1050:
1051: -- Debug Information
1052: IF (DEBUG_Var = 'Y') THEN
1053: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1054: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1055: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1056: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1057: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));

Line 1054: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));

1050:
1051: -- Debug Information
1052: IF (DEBUG_Var = 'Y') THEN
1053: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1054: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1055: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1056: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1057: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1058: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 1055: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);

1051: -- Debug Information
1052: IF (DEBUG_Var = 'Y') THEN
1053: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1054: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1055: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1056: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1057: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1058: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1059: END IF;

Line 1056: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));

1052: IF (DEBUG_Var = 'Y') THEN
1053: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1054: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1055: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1056: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1057: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1058: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1059: END IF;
1060: -- End Debug

Line 1057: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));

1053: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1054: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1055: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1056: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1057: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1058: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1059: END IF;
1060: -- End Debug
1061:

Line 1058: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1054: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1055: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1056: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1057: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1058: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1059: END IF;
1060: -- End Debug
1061:
1062: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 1076: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld amount: '||to_char(l_withheld_amount));

1072: nvl(rec_tax_rate.amount_to_add, 0);
1073:
1074: -- Debug Information
1075: IF (DEBUG_Var = 'Y') THEN
1076: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld amount: '||to_char(l_withheld_amount));
1077: END IF;
1078: -- End Debug
1079:
1080: -- Added the changes for the bug 2211795 by zmohiudd..

Line 1091: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_withheld_amount := l_withheld_amount - l_cumulative_withheld_amount');

1087: l_withheld_amount := l_withheld_amount - l_cumulative_withheld_amount;
1088:
1089: -- Debug Information
1090: IF (DEBUG_Var = 'Y') THEN
1091: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_withheld_amount := l_withheld_amount - l_cumulative_withheld_amount');
1092: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld amount: '||to_char(l_withheld_amount));
1093: END IF;
1094: -- End Debug
1095:

Line 1092: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld amount: '||to_char(l_withheld_amount));

1088:
1089: -- Debug Information
1090: IF (DEBUG_Var = 'Y') THEN
1091: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_withheld_amount := l_withheld_amount - l_cumulative_withheld_amount');
1092: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld amount: '||to_char(l_withheld_amount));
1093: END IF;
1094: -- End Debug
1095:
1096: -------------------------------------------------

Line 1113: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');

1109: l_withheld_amount := l_tem_withheld_amount;
1110:
1111: -- Debug Information
1112: IF (DEBUG_Var = 'Y') THEN
1113: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1114: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1116: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1117: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));

Line 1114: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));

1110:
1111: -- Debug Information
1112: IF (DEBUG_Var = 'Y') THEN
1113: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1114: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1116: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1117: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1118: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));

Line 1115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));

1111: -- Debug Information
1112: IF (DEBUG_Var = 'Y') THEN
1113: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1114: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1116: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1117: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1118: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1119: END IF;

Line 1116: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));

1112: IF (DEBUG_Var = 'Y') THEN
1113: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1114: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1116: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1117: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1118: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1119: END IF;
1120: -- End Debug

Line 1117: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));

1113: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1114: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1116: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1117: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1118: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1119: END IF;
1120: -- End Debug
1121:

Line 1118: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));

1114: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1116: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1117: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1118: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1119: END IF;
1120: -- End Debug
1121:
1122: END IF;

Line 1142: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');

1138: l_withheld_amount := l_tem_withheld_amount;
1139:
1140: -- Debug Information
1141: IF (DEBUG_Var = 'Y') THEN
1142: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1143: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1144: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1145: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1146: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));

Line 1143: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));

1139:
1140: -- Debug Information
1141: IF (DEBUG_Var = 'Y') THEN
1142: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1143: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1144: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1145: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1146: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1147: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));

Line 1144: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));

1140: -- Debug Information
1141: IF (DEBUG_Var = 'Y') THEN
1142: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1143: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1144: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1145: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1146: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1147: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1148: END IF;

Line 1145: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));

1141: IF (DEBUG_Var = 'Y') THEN
1142: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1143: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1144: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1145: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1146: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1147: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1148: END IF;
1149: -- End Debug

Line 1146: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));

1142: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1143: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1144: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1145: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1146: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1147: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1148: END IF;
1149: -- End Debug
1150:

Line 1147: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));

1143: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1144: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1145: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1146: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1147: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1148: END IF;
1149: -- End Debug
1150:
1151: END IF;

Line 1177: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount is less that P_Rec_AWT_Name.Min_Withheld_Amt');

1173: IF (ABS(l_withheld_amount) < P_Rec_AWT_Name.Min_Withheld_Amt) THEN
1174:
1175: -- Debug Information
1176: IF (DEBUG_Var = 'Y') THEN
1177: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount is less that P_Rec_AWT_Name.Min_Withheld_Amt');
1178: END IF;
1179: -- End Debug
1180:
1181: l_withholding_is_required := FALSE;

Line 1446: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1442: 'Store_Into_Temporary_Table';
1443:
1444: -- Debug Information
1445: IF (DEBUG_Var = 'Y') THEN
1446: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1447: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Store_Into_Temporary_Table');
1448: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
1449: END IF;
1450: -- End Debug

Line 1447: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Store_Into_Temporary_Table');

1443:
1444: -- Debug Information
1445: IF (DEBUG_Var = 'Y') THEN
1446: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1447: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Store_Into_Temporary_Table');
1448: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
1449: END IF;
1450: -- End Debug
1451:

Line 1448: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);

1444: -- Debug Information
1445: IF (DEBUG_Var = 'Y') THEN
1446: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1447: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Store_Into_Temporary_Table');
1448: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
1449: END IF;
1450: -- End Debug
1451:
1452: -----------------------------------

Line 1543: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1539: l_gross_amount := P_Tab_Withhold(i).revised_tax_base_amount;
1540:
1541: -- Debug Information
1542: IF (DEBUG_Var = 'Y') THEN
1543: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1544: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Gross Amount if P_Revised_Amount_Flag');
1545: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1546: END IF;
1547: -- End Debug

Line 1544: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Gross Amount if P_Revised_Amount_Flag');

1540:
1541: -- Debug Information
1542: IF (DEBUG_Var = 'Y') THEN
1543: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1544: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Gross Amount if P_Revised_Amount_Flag');
1545: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1546: END IF;
1547: -- End Debug
1548:

Line 1545: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));

1541: -- Debug Information
1542: IF (DEBUG_Var = 'Y') THEN
1543: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1544: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Gross Amount if P_Revised_Amount_Flag');
1545: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1546: END IF;
1547: -- End Debug
1548:
1549: ELSE

Line 1554: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1550: l_gross_amount := P_Tab_Withhold(i).taxable_base_amount;
1551:
1552: -- Debug Information
1553: IF (DEBUG_Var = 'Y') THEN
1554: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1555: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores gross amount if NOT P_Revised_Amount_Flag');
1556: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1557: END IF;
1558: -- End Debug

Line 1555: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores gross amount if NOT P_Revised_Amount_Flag');

1551:
1552: -- Debug Information
1553: IF (DEBUG_Var = 'Y') THEN
1554: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1555: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores gross amount if NOT P_Revised_Amount_Flag');
1556: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1557: END IF;
1558: -- End Debug
1559:

Line 1556: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));

1552: -- Debug Information
1553: IF (DEBUG_Var = 'Y') THEN
1554: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1555: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores gross amount if NOT P_Revised_Amount_Flag');
1556: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1557: END IF;
1558: -- End Debug
1559:
1560: END IF;

Line 1570: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1566: l_withheld_amount := P_Tab_Withhold(i).prorated_amount;
1567:
1568: -- Debug Information
1569: IF (DEBUG_Var = 'Y') THEN
1570: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1571: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Withheld Amount if P_Prorated_Amount_Flag');
1572: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount = '||to_char(l_withheld_amount));
1573: END IF;
1574: -- End Debug

Line 1571: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Withheld Amount if P_Prorated_Amount_Flag');

1567:
1568: -- Debug Information
1569: IF (DEBUG_Var = 'Y') THEN
1570: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1571: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Withheld Amount if P_Prorated_Amount_Flag');
1572: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount = '||to_char(l_withheld_amount));
1573: END IF;
1574: -- End Debug
1575:

Line 1572: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount = '||to_char(l_withheld_amount));

1568: -- Debug Information
1569: IF (DEBUG_Var = 'Y') THEN
1570: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1571: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Withheld Amount if P_Prorated_Amount_Flag');
1572: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount = '||to_char(l_withheld_amount));
1573: END IF;
1574: -- End Debug
1575:
1576: ELSE

Line 1581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1577: l_withheld_amount := P_Tab_Withhold(i).withheld_amount;
1578:
1579: -- Debug Information
1580: IF (DEBUG_Var = 'Y') THEN
1581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Withheld Amount if NOT P_Prorated_Amount_Flag');
1583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount = '||to_char(l_withheld_amount));
1584: END IF;
1585: -- End Debug

Line 1582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Withheld Amount if NOT P_Prorated_Amount_Flag');

1578:
1579: -- Debug Information
1580: IF (DEBUG_Var = 'Y') THEN
1581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Withheld Amount if NOT P_Prorated_Amount_Flag');
1583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount = '||to_char(l_withheld_amount));
1584: END IF;
1585: -- End Debug
1586:

Line 1583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount = '||to_char(l_withheld_amount));

1579: -- Debug Information
1580: IF (DEBUG_Var = 'Y') THEN
1581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Stores Withheld Amount if NOT P_Prorated_Amount_Flag');
1583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount = '||to_char(l_withheld_amount));
1584: END IF;
1585: -- End Debug
1586:
1587: END IF;

Line 2174: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Inside Get_Period_Name - parameters, P_Tax_Name'||P_Tax_Name); -- Argentina AWT ER

2170: -------------------------------
2171: l_calling_sequence := 'JL_ZZ_AP_WITHHOLDING_PKG' || '.' ||
2172: 'Get_Period_Name<--' || P_Calling_Sequence;
2173:
2174: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Inside Get_Period_Name - parameters, P_Tax_Name'||P_Tax_Name); -- Argentina AWT ER
2175: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('P_Period_Type'||P_Period_Type||'P_AWT_Date'||P_AWT_Date||'P_AWT_Success'||P_AWT_Success);
2176:
2177: -----------------------------------
2178: -- Assumes successfully completion

Line 2175: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('P_Period_Type'||P_Period_Type||'P_AWT_Date'||P_AWT_Date||'P_AWT_Success'||P_AWT_Success);

2171: l_calling_sequence := 'JL_ZZ_AP_WITHHOLDING_PKG' || '.' ||
2172: 'Get_Period_Name<--' || P_Calling_Sequence;
2173:
2174: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Inside Get_Period_Name - parameters, P_Tax_Name'||P_Tax_Name); -- Argentina AWT ER
2175: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('P_Period_Type'||P_Period_Type||'P_AWT_Date'||P_AWT_Date||'P_AWT_Success'||P_AWT_Success);
2176:
2177: -----------------------------------
2178: -- Assumes successfully completion
2179: -----------------------------------

Line 2962: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

2958: 'Get_Cumulative_Supp_Exemp<--' || P_Calling_Sequence;
2959:
2960: -- Debug Information
2961: IF (DEBUG_Var = 'Y') THEN
2962: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
2964: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
2965: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
2966: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);

Line 2963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');

2959:
2960: -- Debug Information
2961: IF (DEBUG_Var = 'Y') THEN
2962: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
2964: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
2965: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
2966: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
2967: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));

Line 2964: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));

2960: -- Debug Information
2961: IF (DEBUG_Var = 'Y') THEN
2962: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
2964: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
2965: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
2966: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
2967: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2968: END IF;

Line 2965: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);

2961: IF (DEBUG_Var = 'Y') THEN
2962: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
2964: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
2965: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
2966: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
2967: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2968: END IF;
2969: -- End Debug

Line 2966: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);

2962: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
2964: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
2965: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
2966: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
2967: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2968: END IF;
2969: -- End Debug
2970:

Line 2967: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));

2963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
2964: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
2965: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
2966: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
2967: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2968: END IF;
2969: -- End Debug
2970:
2971: --------------------------------------

Line 2985: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Period Name '||l_period_name);

2981:
2982:
2983: -- Debug Information
2984: IF (DEBUG_Var = 'Y') THEN
2985: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Period Name '||l_period_name);
2986: END IF;
2987: -- End Debug
2988:
2989: -------------------------------------------------

Line 3002: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Start and End Dates for Withh Period '||to_char(l_start_date)||' '||

2998: AND period_name = l_period_name;
2999:
3000: -- Debug Information
3001: IF (DEBUG_Var = 'Y') THEN
3002: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Start and End Dates for Withh Period '||to_char(l_start_date)||' '||
3003: to_char(l_end_date));
3004: END IF;
3005: -- End Debug
3006:

Line 3017: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Tax ID : '||to_char(l_tax_id));

3013: WHERE name = P_Tax_Name;
3014:
3015: -- Debug Information
3016: IF (DEBUG_Var = 'Y') THEN
3017: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Tax ID : '||to_char(l_tax_id));
3018: END IF;
3019: -- End Debug
3020:
3021: --------------------------------------------------------------------------

Line 3042: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Return Cumulative Exemption Amount = '||to_char(l_exemption_amount));

3038: -- Sets output parameters
3039: --------------------------
3040: -- Debug Information
3041: IF (DEBUG_Var = 'Y') THEN
3042: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Return Cumulative Exemption Amount = '||to_char(l_exemption_amount));
3043: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3044: END IF;
3045: -- End Debug
3046:

Line 3043: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3039: --------------------------
3040: -- Debug Information
3041: IF (DEBUG_Var = 'Y') THEN
3042: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Return Cumulative Exemption Amount = '||to_char(l_exemption_amount));
3043: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3044: END IF;
3045: -- End Debug
3046:
3047: Return(l_exemption_amount);