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 808: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

804: 'Process_Withholding_Name';
805:
806: -- Debug Information
807: IF (DEBUG_Var = 'Y') THEN
808: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
809: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
810: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
811: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);

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

805:
806: -- Debug Information
807: IF (DEBUG_Var = 'Y') THEN
808: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
809: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
810: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
811: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
813: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));

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

806: -- Debug Information
807: IF (DEBUG_Var = 'Y') THEN
808: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
809: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
810: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
811: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
813: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
814: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));

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

807: IF (DEBUG_Var = 'Y') THEN
808: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
809: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
810: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
811: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
813: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
814: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
815: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));

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

808: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
809: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
810: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
811: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
813: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
814: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
815: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
816: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));

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

809: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholding_Name');
810: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
811: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
813: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
814: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
815: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
816: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));
817: END IF;

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

810: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
811: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
813: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
814: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
815: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
816: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));
817: END IF;
818: -- End Debug

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

811: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Rec_AWT_Name.Name);
812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
813: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
814: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
815: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
816: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));
817: END IF;
818: -- End Debug
819:

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

812: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Zone_Code: '||P_Rec_AWT_Name.Zone_Code);
813: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Tax_Base_Amt: '||to_char(P_Rec_AWT_Name.Min_Tax_Base_Amt));
814: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Min_Withheld_Amt: '||to_char(P_Rec_AWT_Name.Min_Withheld_Amt));
815: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_From: '||to_char(P_Tax_Name_From));
816: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Tax_Name_To: '||to_char(P_Tax_Name_To));
817: END IF;
818: -- End Debug
819:
820: -----------------------------------

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

839: P_AWT_Success);
840:
841: -- Debug Information
842: IF (DEBUG_Var = 'Y') THEN
843: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);
844: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);
845: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));
846: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
847: END IF;

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

840:
841: -- Debug Information
842: IF (DEBUG_Var = 'Y') THEN
843: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);
844: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);
845: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));
846: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
847: END IF;
848: -- End Debug

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

841: -- Debug Information
842: IF (DEBUG_Var = 'Y') THEN
843: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);
844: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);
845: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));
846: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
847: END IF;
848: -- End Debug
849:

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

842: IF (DEBUG_Var = 'Y') THEN
843: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.Name = '||P_Rec_AWT_Name.Name);
844: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs P_Rec_AWT_Name.AWT_Period_Type = '||P_Rec_AWT_Name.AWT_Period_Type);
845: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_gross_amount: '||to_char(l_cumulative_gross_amount));
846: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
847: END IF;
848: -- End Debug
849:
850: l_cum_exemption_amt := Get_Cumulative_Supp_Exemp

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

857: l_cumulative_withheld_amount := l_cumulative_withheld_amount + l_cum_exemption_amt;
858:
859: -- Debug Information
860: IF (DEBUG_Var = 'Y') THEN
861: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs After Get Exemption Amount');
862: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
863: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cum_exemption_amt: '||to_char(l_cum_exemption_amt));
864: END IF;
865: -- End Debug

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

858:
859: -- Debug Information
860: IF (DEBUG_Var = 'Y') THEN
861: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs After Get Exemption Amount');
862: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
863: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cum_exemption_amt: '||to_char(l_cum_exemption_amt));
864: END IF;
865: -- End Debug
866:

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

859: -- Debug Information
860: IF (DEBUG_Var = 'Y') THEN
861: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Cumulative_Figs After Get Exemption Amount');
862: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cumulative_withheld_amount: '||to_char(l_cumulative_withheld_amount));
863: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: l_cum_exemption_amt: '||to_char(l_cum_exemption_amt));
864: END IF;
865: -- End Debug
866:
867: IF (P_AWT_Success <> AWT_SUCCESS) THEN

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

881: END LOOP;
882:
883: -- Debug Information
884: IF (DEBUG_Var = 'Y') THEN
885: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Taxable base amount: l_taxable_base_amount = '||to_char(l_taxable_base_amount));
886: END IF;
887: -- End Debug
888:
889: ------------------------------------------------

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

893: l_subject_amount := l_taxable_base_amount + l_cumulative_gross_amount;
894:
895: -- Debug Information
896: IF (DEBUG_Var = 'Y') THEN
897: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh: l_subject_amount = '||to_char(l_subject_amount));
898: END IF;
899: -- End Debug
900:
901: ---------------------------------------------------------------------

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

927: P_Rec_Suppl_AWT_Type.multilateral_rate / 100;
928:
929: -- Debug Information
930: IF (DEBUG_Var = 'Y') THEN
931: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh for multilateral contribution ');
932: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh MC: l_subject_amount = '||to_char(l_subject_amount));
933: END IF;
934: -- End Debug
935:

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

928:
929: -- Debug Information
930: IF (DEBUG_Var = 'Y') THEN
931: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh for multilateral contribution ');
932: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Amount subject to withh MC: l_subject_amount = '||to_char(l_subject_amount));
933: END IF;
934: -- End Debug
935:
936: END IF;

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

947: IF (ABS(l_subject_amount) < P_Rec_AWT_Name.Min_Tax_Base_Amt) THEN
948:
949: -- Debug Information
950: IF (DEBUG_Var = 'Y') THEN
951: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount < P_Rec_AWT_Name.Min_Tax_Base_Amt');
952: END IF;
953: -- End Debug
954:
955: l_withholding_is_required := FALSE;

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

979: P_Rec_AWT_Name.Min_Tax_Base_Amt;
980:
981: -- Debug Information
982: IF (DEBUG_Var = 'Y') THEN
983: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Subtract the minimum taxable base amount');
984: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount = '||to_char(l_subject_amount));
985: 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));
986: END IF;
987: -- End Debug

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

980:
981: -- Debug Information
982: IF (DEBUG_Var = 'Y') THEN
983: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Subtract the minimum taxable base amount');
984: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount = '||to_char(l_subject_amount));
985: 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));
986: END IF;
987: -- End Debug
988:

Line 985: 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));

981: -- Debug Information
982: IF (DEBUG_Var = 'Y') THEN
983: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Subtract the minimum taxable base amount');
984: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_subject_amount = '||to_char(l_subject_amount));
985: 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));
986: END IF;
987: -- End Debug
988:
989: END IF;

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

1006: P_AWT_Success);
1007:
1008: -- Debug Information
1009: IF (DEBUG_Var = 'Y') THEN
1010: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1011: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1012: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1013: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1014: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));

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

1007:
1008: -- Debug Information
1009: IF (DEBUG_Var = 'Y') THEN
1010: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1011: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1012: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1013: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1014: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1015: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

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

1008: -- Debug Information
1009: IF (DEBUG_Var = 'Y') THEN
1010: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1011: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1012: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1013: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1014: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1015: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1016: END IF;

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

1009: IF (DEBUG_Var = 'Y') THEN
1010: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1011: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1012: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1013: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1014: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1015: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1016: END IF;
1017: -- End Debug

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

1010: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate_Id = '||to_char(rec_tax_rate.Tax_Rate_Id));
1011: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1012: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1013: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1014: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1015: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1016: END IF;
1017: -- End Debug
1018:

Line 1015: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1011: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Tax_Rate = '||to_char(rec_tax_rate.Tax_Rate));
1012: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Rate_Type = '||rec_tax_rate.Rate_Type);
1013: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Subtract = '||to_char(rec_tax_rate.Amount_To_Subtract));
1014: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Rate Information: Amount_To_Add = '||to_char(rec_tax_rate.Amount_To_Add));
1015: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1016: END IF;
1017: -- End Debug
1018:
1019: IF (P_AWT_Success <> AWT_SUCCESS) THEN

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

1029: nvl(rec_tax_rate.amount_to_add, 0);
1030:
1031: -- Debug Information
1032: IF (DEBUG_Var = 'Y') THEN
1033: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld amount: '||to_char(l_withheld_amount));
1034: END IF;
1035: -- End Debug
1036:
1037: -- Added the changes for the bug 2211795 by zmohiudd..

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

1044: l_withheld_amount := l_withheld_amount - l_cumulative_withheld_amount;
1045:
1046: -- Debug Information
1047: IF (DEBUG_Var = 'Y') THEN
1048: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_withheld_amount := l_withheld_amount - l_cumulative_withheld_amount');
1049: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld amount: '||to_char(l_withheld_amount));
1050: END IF;
1051: -- End Debug
1052:

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

1045:
1046: -- Debug Information
1047: IF (DEBUG_Var = 'Y') THEN
1048: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' l_withheld_amount := l_withheld_amount - l_cumulative_withheld_amount');
1049: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld amount: '||to_char(l_withheld_amount));
1050: END IF;
1051: -- End Debug
1052:
1053: -------------------------------------------------

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

1066: l_withheld_amount := l_tem_withheld_amount;
1067:
1068: -- Debug Information
1069: IF (DEBUG_Var = 'Y') THEN
1070: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1071: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1072: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1074: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));

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

1067:
1068: -- Debug Information
1069: IF (DEBUG_Var = 'Y') THEN
1070: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1071: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1072: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1074: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1075: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));

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

1068: -- Debug Information
1069: IF (DEBUG_Var = 'Y') THEN
1070: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1071: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1072: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1074: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1075: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1076: END IF;

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

1069: IF (DEBUG_Var = 'Y') THEN
1070: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1071: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1072: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1074: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1075: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1076: END IF;
1077: -- End Debug

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

1070: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies Supplier Exemptions at Tax NAME Level');
1071: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1072: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1074: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1075: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1076: END IF;
1077: -- End Debug
1078:

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

1071: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_start_date));
1072: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Name.exemption_end_date));
1073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Name.exemption_rate));
1074: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1075: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1076: END IF;
1077: -- End Debug
1078:
1079: END IF;

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

1095: l_withheld_amount := l_tem_withheld_amount;
1096:
1097: -- Debug Information
1098: IF (DEBUG_Var = 'Y') THEN
1099: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1100: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1101: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1102: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1103: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));

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

1096:
1097: -- Debug Information
1098: IF (DEBUG_Var = 'Y') THEN
1099: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1100: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1101: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1102: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1103: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1104: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));

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

1097: -- Debug Information
1098: IF (DEBUG_Var = 'Y') THEN
1099: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1100: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1101: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1102: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1103: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1104: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1105: END IF;

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

1098: IF (DEBUG_Var = 'Y') THEN
1099: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1100: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1101: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1102: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1103: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1104: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1105: END IF;
1106: -- End Debug

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

1099: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Applies supplier exemptions at tax TYPE level');
1100: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1101: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1102: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1103: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1104: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1105: END IF;
1106: -- End Debug
1107:

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

1100: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Start Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_start_date));
1101: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption End Date = '||to_char(P_Rec_Suppl_AWT_Type.exemption_end_date));
1102: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Rate = '||to_char(P_Rec_Suppl_AWT_Type.exemption_rate));
1103: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount: '||to_char(l_withheld_amount));
1104: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exemption Amount: '||to_char(l_exemption_amount));
1105: END IF;
1106: -- End Debug
1107:
1108: END IF;

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

1130: IF (ABS(l_withheld_amount) < P_Rec_AWT_Name.Min_Withheld_Amt) THEN
1131:
1132: -- Debug Information
1133: IF (DEBUG_Var = 'Y') THEN
1134: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withheld Amount is less that P_Rec_AWT_Name.Min_Withheld_Amt');
1135: END IF;
1136: -- End Debug
1137:
1138: l_withholding_is_required := FALSE;

Line 1401: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1397: 'Store_Into_Temporary_Table';
1398:
1399: -- Debug Information
1400: IF (DEBUG_Var = 'Y') THEN
1401: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1402: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Store_Into_Temporary_Table');
1403: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
1404: END IF;
1405: -- End Debug

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

1398:
1399: -- Debug Information
1400: IF (DEBUG_Var = 'Y') THEN
1401: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1402: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Store_Into_Temporary_Table');
1403: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
1404: END IF;
1405: -- End Debug
1406:

Line 1403: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);

1399: -- Debug Information
1400: IF (DEBUG_Var = 'Y') THEN
1401: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1402: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Store_Into_Temporary_Table');
1403: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
1404: END IF;
1405: -- End Debug
1406:
1407: -----------------------------------

Line 1469: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1465: l_gross_amount := P_Tab_Withhold(1).revised_tax_base_amount;
1466:
1467: -- Debug Information
1468: IF (DEBUG_Var = 'Y') THEN
1469: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1470: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount if P_Revised_Amount_Flag First Record');
1471: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1472: END IF;
1473: -- End Debug

Line 1470: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount if P_Revised_Amount_Flag First Record');

1466:
1467: -- Debug Information
1468: IF (DEBUG_Var = 'Y') THEN
1469: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1470: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount if P_Revised_Amount_Flag First Record');
1471: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1472: END IF;
1473: -- End Debug
1474:

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

1467: -- Debug Information
1468: IF (DEBUG_Var = 'Y') THEN
1469: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1470: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount if P_Revised_Amount_Flag First Record');
1471: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1472: END IF;
1473: -- End Debug
1474:
1475: ELSE

Line 1480: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount to Zero First Record ');

1476: l_gross_amount := 0;
1477:
1478: -- Debug Information
1479: IF (DEBUG_Var = 'Y') THEN
1480: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount to Zero First Record ');
1481: END IF;
1482: -- End Debug
1483:
1484: END IF;

Line 1590: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1586: l_gross_amount := P_Tab_Withhold(i).revised_tax_base_amount;
1587:
1588: -- Debug Information
1589: IF (DEBUG_Var = 'Y') THEN
1590: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1591: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount if P_Revised_Amount_Flag ');
1592: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1593: END IF;
1594: -- End Debug

Line 1591: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount if P_Revised_Amount_Flag ');

1587:
1588: -- Debug Information
1589: IF (DEBUG_Var = 'Y') THEN
1590: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1591: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount if P_Revised_Amount_Flag ');
1592: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1593: END IF;
1594: -- End Debug
1595: ELSE

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

1588: -- Debug Information
1589: IF (DEBUG_Var = 'Y') THEN
1590: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1591: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount if P_Revised_Amount_Flag ');
1592: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1593: END IF;
1594: -- End Debug
1595: ELSE
1596: l_gross_amount := 0;

Line 1600: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount to Zero First Record ');

1596: l_gross_amount := 0;
1597:
1598: -- Debug Information
1599: IF (DEBUG_Var = 'Y') THEN
1600: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes Gross Amount to Zero First Record ');
1601: END IF;
1602: -- End Debug
1603: END IF;
1604:

Line 1624: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1620: P_Tab_Withhold(i).taxable_base_amount;
1621:
1622: -- Debug Information
1623: IF (DEBUG_Var = 'Y') THEN
1624: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1625: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Calculates gross amount if NOT P_Revised_Amount_Flag');
1626: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1627: END IF;
1628: -- End Debug

Line 1625: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Calculates gross amount if NOT P_Revised_Amount_Flag');

1621:
1622: -- Debug Information
1623: IF (DEBUG_Var = 'Y') THEN
1624: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1625: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Calculates gross amount if NOT P_Revised_Amount_Flag');
1626: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1627: END IF;
1628: -- End Debug
1629:

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

1622: -- Debug Information
1623: IF (DEBUG_Var = 'Y') THEN
1624: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1625: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Calculates gross amount if NOT P_Revised_Amount_Flag');
1626: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Gross Amount = '||to_char(l_gross_amount));
1627: END IF;
1628: -- End Debug
1629:
1630: END IF;

Line 3004: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3000: 'Get_Cumulative_Supp_Exemp<--' || P_Calling_Sequence;
3001:
3002: -- Debug Information
3003: IF (DEBUG_Var = 'Y') THEN
3004: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3005: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
3006: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
3007: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
3008: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);

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

3001:
3002: -- Debug Information
3003: IF (DEBUG_Var = 'Y') THEN
3004: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3005: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
3006: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
3007: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
3008: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
3009: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));

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

3002: -- Debug Information
3003: IF (DEBUG_Var = 'Y') THEN
3004: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3005: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
3006: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
3007: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
3008: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
3009: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3010: END IF;

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

3003: IF (DEBUG_Var = 'Y') THEN
3004: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3005: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
3006: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
3007: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
3008: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
3009: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3010: END IF;
3011: -- End Debug

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

3004: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3005: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
3006: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
3007: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
3008: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
3009: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3010: END IF;
3011: -- End Debug
3012:

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

3005: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Function Get_Cumulative_Supp_Exemp');
3006: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_Vendor_Id: '||to_char(P_Vendor_Id));
3007: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: Tax Name: '||P_Tax_Name);
3008: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Period_Type: '||P_AWT_Period_Type);
3009: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Param: P_AWT_Date: '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3010: END IF;
3011: -- End Debug
3012:
3013: --------------------------------------

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

3023:
3024:
3025: -- Debug Information
3026: IF (DEBUG_Var = 'Y') THEN
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Period Name '||l_period_name);
3028: END IF;
3029: -- End Debug
3030:
3031: -------------------------------------------------

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

3040: AND period_name = l_period_name;
3041:
3042: -- Debug Information
3043: IF (DEBUG_Var = 'Y') THEN
3044: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Start and End Dates for Withh Period '||to_char(l_start_date)||' '||
3045: to_char(l_end_date));
3046: END IF;
3047: -- End Debug
3048:

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

3055: WHERE name = P_Tax_Name;
3056:
3057: -- Debug Information
3058: IF (DEBUG_Var = 'Y') THEN
3059: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Tax ID : '||to_char(l_tax_id));
3060: END IF;
3061: -- End Debug
3062:
3063: --------------------------------------------------------------------------

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

3078: -- Sets output parameters
3079: --------------------------
3080: -- Debug Information
3081: IF (DEBUG_Var = 'Y') THEN
3082: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Return Cumulative Exemption Amount = '||to_char(l_exemption_amount));
3083: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3084: END IF;
3085: -- End Debug
3086:

Line 3083: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3079: --------------------------
3080: -- Debug Information
3081: IF (DEBUG_Var = 'Y') THEN
3082: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Return Cumulative Exemption Amount = '||to_char(l_exemption_amount));
3083: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3084: END IF;
3085: -- End Debug
3086:
3087: Return(l_exemption_amount);