DBA Data[Home] [Help]

APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_UTILITIES_PKG

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

461: /* bug3589682 we always pass withheld amt in base currency code only
462: Values passed to CurrCode and BaseCurrCode is always base currency code
463: convertion is not required. Hence delete the if condition below */
464: /* Bug 4721994 commented the below code as rounding should be done after prorating the awt amount*/
465: -- base_WT_amount := Ap_Utilities_Pkg.ap_round_currency(WithheldAmount,BaseCurrCode); -- R11: Xcurr
466:
467: base_WT_amount := WithheldAmount; --Bug 4721994
468:
469:

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

769:
770: --bugfix:4716059
771: ELSE
772: /* Bug 4721994 Prorating not done here. so rounding the base_wt_amount*/
773: base_WT_amount := Ap_Utilities_Pkg.ap_round_currency(WithheldAmount,BaseCurrCode);
774:
775: debug_info := 'Withheld_Amt -- '||Withheld_Amt;
776: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
777: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

Line 1202: -- proportional_value := Ap_Utilities_Pkg.Ap_Round_Currency

1198: proportional_value := (Amount * Numerator / Denominator );
1199:
1200: end if;
1201:
1202: -- proportional_value := Ap_Utilities_Pkg.Ap_Round_Currency
1203: -- (Amount * (Numerator / Denominator) ,CurrCode);
1204: RETURN(proportional_value);
1205: END Proportional_Amount;
1206:

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

1436: ELSE
1437: Rate := rt;
1438: amt := AmtSubject * (rt / 100);
1439:
1440: -- amt := Ap_Utilities_Pkg.Ap_Round_Currency(amt, CurrCode);
1441: Amount := amt;
1442:
1443: END IF;
1444: debug_info := 'Close CURSOR c_normal_rate';

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

1771: tab_start_amount(j) := new_start_amount;
1772: new_end_amount := tab_start_amount(j) +
1773: (range_width * 100 /
1774: tab_tax_rate(j));
1775: tab_end_amount(j) := Ap_Utilities_Pkg.Ap_Round_Currency
1776: (new_end_amount ,CurrCode);
1777: new_start_amount := tab_end_amount(j);
1778:
1779: END LOOP;

Line 1921: current_amount_withheld := Ap_Utilities_Pkg.Ap_Round_Currency

1917: current_amount_withheld := (current_amount_to_withhold / 100) *
1918: tab_tax_rate(k);
1919: Unrounded_Curr_Amt_Withheld := current_amount_withheld; -- Bug 10262174
1920:
1921: current_amount_withheld := Ap_Utilities_Pkg.Ap_Round_Currency
1922: (current_amount_withheld ,CurrCode);
1923:
1924:
1925: --bug14843528 , moved the code to increase/decrease amt prior to changing value of current_amount_withheld

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

2107: AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG, 'N') = 'N'
2108: AND ASP.ORG_ID = nvl(P_ORG_ID, asp.org_id); --4742265
2109: EXCEPTION
2110: WHEN NO_DATA_FOUND THEN
2111: ap_utilities_pkg.get_OPEN_gl_date(P_Awt_Date, gl_period_name, gl_awt_date);
2112:
2113: IF gl_awt_date IS NULL THEN
2114: RAISE NOT_AN_OPEN_GL_PERIOD;
2115: END IF;

Line 2253: ap_utilities_pkg.get_open_gl_date

2249: EXCEPTION
2250: WHEN NO_DATA_FOUND THEN
2251: /* If there is no period found then check for the next available open period and date */
2252: /* Bug 7175689, Added g_org_id */
2253: ap_utilities_pkg.get_open_gl_date
2254: (
2255: tab_max_gl_date(i),
2256: max_gl_date_period,
2257: max_gl_dist_date,

Line 2757: custom_wt_amount := Ap_Utilities_Pkg.Ap_Round_Currency

2753: ELSE
2754: custom_wt_amount := current_amount_subject_for_tax *
2755: (custom_wt_rate / 100);
2756: unrounded_custom_wt_amount := custom_wt_amount; -- bug 10262174
2757: custom_wt_amount := Ap_Utilities_Pkg.Ap_Round_Currency
2758: (custom_wt_amount
2759: ,currency_code);
2760: END IF;
2761: -- Apply cut off:

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

3181: WHEN NOT_AN_OPEN_GL_PERIOD THEN
3182: DECLARE
3183: error_text VARCHAR2(2000);
3184: BEGIN
3185: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR',
3186: 'GL PERIOD NOT OPEN');
3187: P_AWT_Success := error_text;
3188: END;
3189:

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

3194: BEGIN
3195:
3196: invalid_group_name := Get_Group_Name(invalid_group
3197: ,current_calling_sequence);
3198: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3199: ,'AWT TAX RANGE INVALID')||
3200: ' - '||
3201: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3202: ,'TAX')||

Line 3201: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3197: ,current_calling_sequence);
3198: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3199: ,'AWT TAX RANGE INVALID')||
3200: ' - '||
3201: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3202: ,'TAX')||
3203: ' '||invalid_tax||' '||
3204: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3205: ,'GROUP')||

Line 3204: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3200: ' - '||
3201: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3202: ,'TAX')||
3203: ' '||invalid_tax||' '||
3204: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3205: ,'GROUP')||
3206: ' '||invalid_group_name;
3207: P_AWT_Success := error_text;
3208: END;

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

3213: error_text VARCHAR2(2000);
3214: BEGIN
3215: invalid_group_name := Get_Group_Name(invalid_group
3216: ,current_calling_sequence);
3217: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR',
3218: 'AWT GROUP INACTIVE')||
3219: ' - '||invalid_group_name;
3220: P_AWT_Success := error_text;
3221: END;

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

3226: error_text VARCHAR2(2000);
3227: BEGIN
3228: invalid_group_name := Get_Group_Name(invalid_group
3229: ,current_calling_sequence);
3230: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3231: ,'AWT TAX INACTIVE')||
3232: ' - '||
3233: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3234: ,'TAX')||

Line 3233: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3229: ,current_calling_sequence);
3230: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3231: ,'AWT TAX INACTIVE')||
3232: ' - '||
3233: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3234: ,'TAX')||
3235: ' '||invalid_tax||' '||
3236: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3237: ,'GROUP')||

Line 3236: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3232: ' - '||
3233: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3234: ,'TAX')||
3235: ' '||invalid_tax||' '||
3236: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3237: ,'GROUP')||
3238: ' '||invalid_group_name;
3239: P_AWT_Success := error_text;
3240: END;

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

3245: error_text VARCHAR2(2000);
3246: BEGIN
3247: invalid_group_name := Get_Group_Name(invalid_group
3248: ,current_calling_sequence);
3249: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3250: ,'AWT TAX ACCOUNT INVALID')||
3251: ' - '||
3252: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3253: ,'TAX')||

Line 3252: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3248: ,current_calling_sequence);
3249: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3250: ,'AWT TAX ACCOUNT INVALID')||
3251: ' - '||
3252: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3253: ,'TAX')||
3254: ' '||invalid_tax||' '||
3255: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3256: ,'GROUP')||

Line 3255: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3251: ' - '||
3252: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3253: ,'TAX')||
3254: ' '||invalid_tax||' '||
3255: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3256: ,'GROUP')||
3257: ' '||invalid_group_name;
3258: P_AWT_Success := error_text;
3259: END;

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

3264: error_text VARCHAR2(2000);
3265: BEGIN
3266: invalid_group_name := Get_Group_Name(invalid_group
3267: ,current_calling_sequence);
3268: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3269: ,'NO AWT PERIOD')||
3270: ' - '||
3271: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3272: ,'TAX')||

Line 3271: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3267: ,current_calling_sequence);
3268: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3269: ,'NO AWT PERIOD')||
3270: ' - '||
3271: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3272: ,'TAX')||
3273: ' '||invalid_tax||' '||
3274: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3275: ,'GROUP')||

Line 3274: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3270: ' - '||
3271: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3272: ,'TAX')||
3273: ' '||invalid_tax||' '||
3274: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3275: ,'GROUP')||
3276: ' '||invalid_group_name;
3277: P_AWT_Success := error_text;
3278: END;

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

3283: error_text VARCHAR2(2000);
3284: BEGIN
3285: invalid_group_name := Get_Group_Name(invalid_group
3286: ,current_calling_sequence);
3287: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3288: ,'NO AWT RATE')||
3289: ' - '||
3290: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3291: ,'TAX')||

Line 3290: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3286: ,current_calling_sequence);
3287: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3288: ,'NO AWT RATE')||
3289: ' - '||
3290: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3291: ,'TAX')||
3292: ' '||invalid_tax||' '||
3293: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3294: ,'GROUP')||

Line 3293: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3289: ' - '||
3290: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3291: ,'TAX')||
3292: ' '||invalid_tax||' '||
3293: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3294: ,'GROUP')||
3295: ' '||invalid_group_name;
3296: P_AWT_Success := error_text;
3297: END;

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

3302: error_text VARCHAR2(2000);
3303: BEGIN
3304: invalid_group_name := Get_Group_Name(invalid_group
3305: ,current_calling_sequence);
3306: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3307: ,'INVALID RANGE DATES')||
3308: ' - '||
3309: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3310: ,'TAX')||

Line 3309: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3305: ,current_calling_sequence);
3306: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3307: ,'INVALID RANGE DATES')||
3308: ' - '||
3309: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3310: ,'TAX')||
3311: ' '||invalid_tax||' '||
3312: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3313: ,'GROUP')||

Line 3312: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3308: ' - '||
3309: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3310: ,'TAX')||
3311: ' '||invalid_tax||' '||
3312: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3313: ,'GROUP')||
3314: ' '||invalid_group_name;
3315: P_AWT_Success := error_text;
3316: END;

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

3321: error_text VARCHAR2(2000);
3322: BEGIN
3323: invalid_group_name := Get_Group_Name(invalid_group
3324: ,current_calling_sequence);
3325: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3326: ,'INV CURR MUST BE BASE')||
3327: ' - '||
3328: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3329: ,'TAX')||

Line 3328: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3324: ,current_calling_sequence);
3325: error_text := Ap_Utilities_Pkg.Ap_Get_Displayed_Field('AWT ERROR'
3326: ,'INV CURR MUST BE BASE')||
3327: ' - '||
3328: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3329: ,'TAX')||
3330: ' '||invalid_tax||' '||
3331: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3332: ,'GROUP')||

Line 3331: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'

3327: ' - '||
3328: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3329: ,'TAX')||
3330: ' '||invalid_tax||' '||
3331: Ap_Utilities_Pkg.Ap_Get_Displayed_Field('NLS TRANSLATION'
3332: ,'GROUP')||
3333: ' '||invalid_group_name;
3334: P_AWT_Success := error_text;
3335: END;