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.AP_CALC_WITHHOLDING_PKG dependencies on AP_UTILITIES_PKG

Line 400: -- base_WT_amount := Ap_Utilities_Pkg.ap_round_currency(WithheldAmount,BaseCurrCode); -- R11: Xcurr

396: /* bug3589682 we always pass withheld amt in base currency code only
397: Values passed to CurrCode and BaseCurrCode is always base currency code
398: convertion is not required. Hence delete the if condition below */
399: /* Bug 4721994 commented the below code as rounding should be done after prorating the awt amount*/
400: -- base_WT_amount := Ap_Utilities_Pkg.ap_round_currency(WithheldAmount,BaseCurrCode); -- R11: Xcurr
401:
402: base_WT_amount := WithheldAmount; --Bug 4721994
403:
404:

Line 453: l_prorated_base_withheld_amt := ap_utilities_pkg.ap_round_currency(

449: EXIT WHEN c_prorate_awt_lines%NOTFOUND;
450:
451: l_prorated_withheld_amt := rec_prorate_awt_lines.prorated_awt_amt; --bug 3589682
452:
453: l_prorated_base_withheld_amt := ap_utilities_pkg.ap_round_currency(
454: rec_prorate_awt_lines.prorated_base_awt_amt,BaseCurrCode);
455:
456: l_total_pro_withheld_amt := l_total_pro_withheld_amt +
457: l_prorated_withheld_amt;

Line 593: base_WT_amount := Ap_Utilities_Pkg.ap_round_currency(WithheldAmount,BaseCurrCode);

589:
590: --bugfix:4716059
591: ELSE
592: /* Bug 4721994 Prorating not done here. so rounding the base_wt_amount*/
593: base_WT_amount := Ap_Utilities_Pkg.ap_round_currency(WithheldAmount,BaseCurrCode);
594:
595:
596: debug_info := 'Insert into ap_awt_temp_distributions';
597: insert into ap_awt_temp_distributions_all

Line 987: -- proportional_value := Ap_Utilities_Pkg.Ap_Round_Currency

983: proportional_value := (Amount * (Numerator / Denominator));
984:
985: end if;
986:
987: -- proportional_value := Ap_Utilities_Pkg.Ap_Round_Currency
988: -- (Amount * (Numerator / Denominator) ,CurrCode);
989: RETURN(proportional_value);
990: END Proportional_Amount;
991:

Line 1223: -- amt := Ap_Utilities_Pkg.Ap_Round_Currency(amt, CurrCode);

1219: ELSE
1220: Rate := rt;
1221: amt := AmtSubject * (rt / 100);
1222:
1223: -- amt := Ap_Utilities_Pkg.Ap_Round_Currency(amt, CurrCode);
1224: Amount := amt;
1225:
1226: END IF;
1227: debug_info := 'Close CURSOR c_normal_rate';

Line 1552: tab_end_amount(j) := Ap_Utilities_Pkg.Ap_Round_Currency

1548: tab_start_amount(j) := new_start_amount;
1549: new_end_amount := tab_start_amount(j) +
1550: (range_width * 100 /
1551: tab_tax_rate(j));
1552: tab_end_amount(j) := Ap_Utilities_Pkg.Ap_Round_Currency
1553: (new_end_amount ,CurrCode);
1554: new_start_amount := tab_end_amount(j);
1555:
1556: END LOOP;

Line 1647: current_amount_withheld := Ap_Utilities_Pkg.Ap_Round_Currency

1643: amount_subject_for_ranges := 0;
1644: END IF;
1645: current_amount_withheld := (current_amount_to_withhold / 100) *
1646: tab_tax_rate(k);
1647: current_amount_withheld := Ap_Utilities_Pkg.Ap_Round_Currency
1648: (current_amount_withheld ,CurrCode);
1649:
1650: -- Apply Cut Off to this amount:
1651: current_amount_withheld := Do_AWT_Cut_Off (

Line 1807: ap_utilities_pkg.get_OPEN_gl_date(P_Awt_Date, gl_period_name, gl_awt_date);

1803: AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG, 'N') = 'N'
1804: AND ASP.ORG_ID = nvl(P_ORG_ID, asp.org_id); --4742265
1805: EXCEPTION
1806: WHEN NO_DATA_FOUND THEN
1807: ap_utilities_pkg.get_OPEN_gl_date(P_Awt_Date, gl_period_name, gl_awt_date);
1808:
1809: IF gl_awt_date IS NULL THEN
1810: RAISE NOT_AN_OPEN_GL_PERIOD;
1811: END IF;

Line 2375: custom_wt_amount := Ap_Utilities_Pkg.Ap_Round_Currency

2371: RAISE INVALID_TAX_RATE_ID;
2372: ELSE
2373: custom_wt_amount := current_amount_subject_for_tax *
2374: (custom_wt_rate / 100);
2375: custom_wt_amount := Ap_Utilities_Pkg.Ap_Round_Currency
2376: (custom_wt_amount
2377: ,currency_code);
2378: END IF;
2379: -- Apply cut off:

Line 2774: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR',

2770: WHEN NOT_AN_OPEN_GL_PERIOD THEN
2771: DECLARE
2772: error_text VARCHAR2(2000);
2773: BEGIN
2774: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR',
2775: 'GL PERIOD NOT OPEN');
2776: P_AWT_Success := error_text;
2777: END;
2778:

Line 2787: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'

2783: BEGIN
2784:
2785: invalid_group_name := Get_Group_Name(invalid_group
2786: ,current_calling_sequence);
2787: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2788: ,'AWT TAX RANGE INVALID')||
2789: ' - '||
2790: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2791: ,'TAX')||

Line 2790: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2786: ,current_calling_sequence);
2787: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2788: ,'AWT TAX RANGE INVALID')||
2789: ' - '||
2790: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2791: ,'TAX')||
2792: ' '||invalid_tax||' '||
2793: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2794: ,'GROUP')||

Line 2793: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2789: ' - '||
2790: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2791: ,'TAX')||
2792: ' '||invalid_tax||' '||
2793: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2794: ,'GROUP')||
2795: ' '||invalid_group_name;
2796: P_AWT_Success := error_text;
2797: END;

Line 2806: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR',

2802: error_text VARCHAR2(2000);
2803: BEGIN
2804: invalid_group_name := Get_Group_Name(invalid_group
2805: ,current_calling_sequence);
2806: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR',
2807: 'AWT GROUP INACTIVE')||
2808: ' - '||invalid_group_name;
2809: P_AWT_Success := error_text;
2810: END;

Line 2819: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'

2815: error_text VARCHAR2(2000);
2816: BEGIN
2817: invalid_group_name := Get_Group_Name(invalid_group
2818: ,current_calling_sequence);
2819: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2820: ,'AWT TAX INACTIVE')||
2821: ' - '||
2822: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2823: ,'TAX')||

Line 2822: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2818: ,current_calling_sequence);
2819: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2820: ,'AWT TAX INACTIVE')||
2821: ' - '||
2822: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2823: ,'TAX')||
2824: ' '||invalid_tax||' '||
2825: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2826: ,'GROUP')||

Line 2825: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2821: ' - '||
2822: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2823: ,'TAX')||
2824: ' '||invalid_tax||' '||
2825: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2826: ,'GROUP')||
2827: ' '||invalid_group_name;
2828: P_AWT_Success := error_text;
2829: END;

Line 2838: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'

2834: error_text VARCHAR2(2000);
2835: BEGIN
2836: invalid_group_name := Get_Group_Name(invalid_group
2837: ,current_calling_sequence);
2838: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2839: ,'AWT TAX ACCOUNT INVALID')||
2840: ' - '||
2841: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2842: ,'TAX')||

Line 2841: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2837: ,current_calling_sequence);
2838: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2839: ,'AWT TAX ACCOUNT INVALID')||
2840: ' - '||
2841: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2842: ,'TAX')||
2843: ' '||invalid_tax||' '||
2844: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2845: ,'GROUP')||

Line 2844: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2840: ' - '||
2841: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2842: ,'TAX')||
2843: ' '||invalid_tax||' '||
2844: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2845: ,'GROUP')||
2846: ' '||invalid_group_name;
2847: P_AWT_Success := error_text;
2848: END;

Line 2857: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'

2853: error_text VARCHAR2(2000);
2854: BEGIN
2855: invalid_group_name := Get_Group_Name(invalid_group
2856: ,current_calling_sequence);
2857: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2858: ,'NO AWT PERIOD')||
2859: ' - '||
2860: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2861: ,'TAX')||

Line 2860: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2856: ,current_calling_sequence);
2857: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2858: ,'NO AWT PERIOD')||
2859: ' - '||
2860: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2861: ,'TAX')||
2862: ' '||invalid_tax||' '||
2863: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2864: ,'GROUP')||

Line 2863: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2859: ' - '||
2860: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2861: ,'TAX')||
2862: ' '||invalid_tax||' '||
2863: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2864: ,'GROUP')||
2865: ' '||invalid_group_name;
2866: P_AWT_Success := error_text;
2867: END;

Line 2876: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'

2872: error_text VARCHAR2(2000);
2873: BEGIN
2874: invalid_group_name := Get_Group_Name(invalid_group
2875: ,current_calling_sequence);
2876: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2877: ,'NO AWT RATE')||
2878: ' - '||
2879: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2880: ,'TAX')||

Line 2879: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2875: ,current_calling_sequence);
2876: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2877: ,'NO AWT RATE')||
2878: ' - '||
2879: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2880: ,'TAX')||
2881: ' '||invalid_tax||' '||
2882: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2883: ,'GROUP')||

Line 2882: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2878: ' - '||
2879: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2880: ,'TAX')||
2881: ' '||invalid_tax||' '||
2882: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2883: ,'GROUP')||
2884: ' '||invalid_group_name;
2885: P_AWT_Success := error_text;
2886: END;

Line 2895: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'

2891: error_text VARCHAR2(2000);
2892: BEGIN
2893: invalid_group_name := Get_Group_Name(invalid_group
2894: ,current_calling_sequence);
2895: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2896: ,'INVALID RANGE DATES')||
2897: ' - '||
2898: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2899: ,'TAX')||

Line 2898: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2894: ,current_calling_sequence);
2895: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2896: ,'INVALID RANGE DATES')||
2897: ' - '||
2898: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2899: ,'TAX')||
2900: ' '||invalid_tax||' '||
2901: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2902: ,'GROUP')||

Line 2901: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2897: ' - '||
2898: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2899: ,'TAX')||
2900: ' '||invalid_tax||' '||
2901: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2902: ,'GROUP')||
2903: ' '||invalid_group_name;
2904: P_AWT_Success := error_text;
2905: END;

Line 2914: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'

2910: error_text VARCHAR2(2000);
2911: BEGIN
2912: invalid_group_name := Get_Group_Name(invalid_group
2913: ,current_calling_sequence);
2914: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2915: ,'INV CURR MUST BE BASE')||
2916: ' - '||
2917: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2918: ,'TAX')||

Line 2917: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2913: ,current_calling_sequence);
2914: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
2915: ,'INV CURR MUST BE BASE')||
2916: ' - '||
2917: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2918: ,'TAX')||
2919: ' '||invalid_tax||' '||
2920: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2921: ,'GROUP')||

Line 2920: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

2916: ' - '||
2917: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2918: ,'TAX')||
2919: ' '||invalid_tax||' '||
2920: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
2921: ,'GROUP')||
2922: ' '||invalid_group_name;
2923: P_AWT_Success := error_text;
2924: END;