DBA Data[Home] [Help]

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on GL_CURRENCY_API

Line 1477: --- API to convert the amount using GL currency API

1473:
1474:
1475:
1476: -----------------------------------------------------------------
1477: --- API to convert the amount using GL currency API
1478: -- with Traingulation
1479: ----------------------------------------------------------------
1480: FUNCTION convert_currency_amount
1481: ( p_amount IN NUMBER

Line 1500: WHEN GL_CURRENCY_API.NO_RATE OR

1496: , p_conversion_date => SYSDATE
1497: , p_conversion_type => g_conversion_type
1498: );
1499: EXCEPTION
1500: WHEN GL_CURRENCY_API.NO_RATE OR
1501: GL_CURRENCY_API.INVALID_CURRENCY
1502: THEN
1503: oe_debug_pub.add( 'conversion exception for '
1504: || p_transactional_currency, 1 );

Line 1501: GL_CURRENCY_API.INVALID_CURRENCY

1497: , p_conversion_type => g_conversion_type
1498: );
1499: EXCEPTION
1500: WHEN GL_CURRENCY_API.NO_RATE OR
1501: GL_CURRENCY_API.INVALID_CURRENCY
1502: THEN
1503: oe_debug_pub.add( 'conversion exception for '
1504: || p_transactional_currency, 1 );
1505: add_error_currency( g_error_curr_tbl, p_transactional_currency );

Line 2591: WHEN GL_CURRENCY_API.NO_RATE OR

2587: );
2588: l_total := l_total + NVL( l_term, 0 );
2589:
2590: EXCEPTION
2591: WHEN GL_CURRENCY_API.NO_RATE OR
2592: GL_CURRENCY_API.INVALID_CURRENCY THEN
2593: add_error_currency( x_error_curr_tbl, l_currency_code );
2594:
2595: IF G_debug_flag = 'Y'

Line 2592: GL_CURRENCY_API.INVALID_CURRENCY THEN

2588: l_total := l_total + NVL( l_term, 0 );
2589:
2590: EXCEPTION
2591: WHEN GL_CURRENCY_API.NO_RATE OR
2592: GL_CURRENCY_API.INVALID_CURRENCY THEN
2593: add_error_currency( x_error_curr_tbl, l_currency_code );
2594:
2595: IF G_debug_flag = 'Y'
2596: THEN

Line 2667: WHEN GL_CURRENCY_API.NO_RATE OR

2663: );
2664: l_total := l_total + NVL( l_term, 0 );
2665:
2666: EXCEPTION
2667: WHEN GL_CURRENCY_API.NO_RATE OR
2668: GL_CURRENCY_API.INVALID_CURRENCY THEN
2669: oe_debug_pub.add( 'conversion exception for '
2670: || l_currency_code, 1 );
2671: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 2668: GL_CURRENCY_API.INVALID_CURRENCY THEN

2664: l_total := l_total + NVL( l_term, 0 );
2665:
2666: EXCEPTION
2667: WHEN GL_CURRENCY_API.NO_RATE OR
2668: GL_CURRENCY_API.INVALID_CURRENCY THEN
2669: oe_debug_pub.add( 'conversion exception for '
2670: || l_currency_code, 1 );
2671: add_error_currency( x_error_curr_tbl, l_currency_code );
2672: END;

Line 2735: WHEN GL_CURRENCY_API.NO_RATE OR

2731: );
2732: l_total := l_total + NVL( l_term, 0 );
2733:
2734: EXCEPTION
2735: WHEN GL_CURRENCY_API.NO_RATE OR
2736: GL_CURRENCY_API.INVALID_CURRENCY THEN
2737: oe_debug_pub.add( 'conversion exception for '
2738: || l_currency_code, 1 );
2739: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 2736: GL_CURRENCY_API.INVALID_CURRENCY THEN

2732: l_total := l_total + NVL( l_term, 0 );
2733:
2734: EXCEPTION
2735: WHEN GL_CURRENCY_API.NO_RATE OR
2736: GL_CURRENCY_API.INVALID_CURRENCY THEN
2737: oe_debug_pub.add( 'conversion exception for '
2738: || l_currency_code, 1 );
2739: add_error_currency( x_error_curr_tbl, l_currency_code );
2740: END;

Line 2811: WHEN GL_CURRENCY_API.NO_RATE OR

2807: );
2808: l_total := l_total + NVL( l_term, 0 );
2809:
2810: EXCEPTION
2811: WHEN GL_CURRENCY_API.NO_RATE OR
2812: GL_CURRENCY_API.INVALID_CURRENCY THEN
2813: oe_debug_pub.add( 'conversion exception for '
2814: || l_currency_code, 1 );
2815: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 2812: GL_CURRENCY_API.INVALID_CURRENCY THEN

2808: l_total := l_total + NVL( l_term, 0 );
2809:
2810: EXCEPTION
2811: WHEN GL_CURRENCY_API.NO_RATE OR
2812: GL_CURRENCY_API.INVALID_CURRENCY THEN
2813: oe_debug_pub.add( 'conversion exception for '
2814: || l_currency_code, 1 );
2815: add_error_currency( x_error_curr_tbl, l_currency_code );
2816: END;

Line 2881: WHEN GL_CURRENCY_API.NO_RATE OR

2877: );
2878: l_total := l_total + NVL( l_term, 0 );
2879:
2880: EXCEPTION
2881: WHEN GL_CURRENCY_API.NO_RATE OR
2882: GL_CURRENCY_API.INVALID_CURRENCY THEN
2883: oe_debug_pub.add( 'conversion exception for '
2884: || l_currency_code, 1 );
2885: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 2882: GL_CURRENCY_API.INVALID_CURRENCY THEN

2878: l_total := l_total + NVL( l_term, 0 );
2879:
2880: EXCEPTION
2881: WHEN GL_CURRENCY_API.NO_RATE OR
2882: GL_CURRENCY_API.INVALID_CURRENCY THEN
2883: oe_debug_pub.add( 'conversion exception for '
2884: || l_currency_code, 1 );
2885: add_error_currency( x_error_curr_tbl, l_currency_code );
2886: END;

Line 2939: WHEN GL_CURRENCY_API.NO_RATE OR

2935: );
2936: l_total := l_total + NVL( l_term, 0 );
2937:
2938: EXCEPTION
2939: WHEN GL_CURRENCY_API.NO_RATE OR
2940: GL_CURRENCY_API.INVALID_CURRENCY THEN
2941: oe_debug_pub.add( 'conversion exception for '
2942: || l_currency_code, 1 );
2943: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 2940: GL_CURRENCY_API.INVALID_CURRENCY THEN

2936: l_total := l_total + NVL( l_term, 0 );
2937:
2938: EXCEPTION
2939: WHEN GL_CURRENCY_API.NO_RATE OR
2940: GL_CURRENCY_API.INVALID_CURRENCY THEN
2941: oe_debug_pub.add( 'conversion exception for '
2942: || l_currency_code, 1 );
2943: add_error_currency( x_error_curr_tbl, l_currency_code );
2944: END;

Line 3042: WHEN GL_CURRENCY_API.NO_RATE OR

3038: );
3039: l_total := l_total + NVL( l_term, 0 );
3040:
3041: EXCEPTION
3042: WHEN GL_CURRENCY_API.NO_RATE OR
3043: GL_CURRENCY_API.INVALID_CURRENCY THEN
3044: oe_debug_pub.add( 'conversion exception for '
3045: || l_currency_code, 1 );
3046: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3043: GL_CURRENCY_API.INVALID_CURRENCY THEN

3039: l_total := l_total + NVL( l_term, 0 );
3040:
3041: EXCEPTION
3042: WHEN GL_CURRENCY_API.NO_RATE OR
3043: GL_CURRENCY_API.INVALID_CURRENCY THEN
3044: oe_debug_pub.add( 'conversion exception for '
3045: || l_currency_code, 1 );
3046: add_error_currency( x_error_curr_tbl, l_currency_code );
3047: END;

Line 3096: WHEN GL_CURRENCY_API.NO_RATE OR

3092: );
3093: l_total := l_total + NVL( l_term, 0 );
3094:
3095: EXCEPTION
3096: WHEN GL_CURRENCY_API.NO_RATE OR
3097: GL_CURRENCY_API.INVALID_CURRENCY THEN
3098: oe_debug_pub.add( 'conversion exception for '
3099: || l_currency_code, 1 );
3100: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3097: GL_CURRENCY_API.INVALID_CURRENCY THEN

3093: l_total := l_total + NVL( l_term, 0 );
3094:
3095: EXCEPTION
3096: WHEN GL_CURRENCY_API.NO_RATE OR
3097: GL_CURRENCY_API.INVALID_CURRENCY THEN
3098: oe_debug_pub.add( 'conversion exception for '
3099: || l_currency_code, 1 );
3100: add_error_currency( x_error_curr_tbl, l_currency_code );
3101: END;

Line 3166: WHEN GL_CURRENCY_API.NO_RATE OR

3162: , p_conversion_type => g_conversion_type
3163: );
3164: l_total := l_total + NVL( l_term, 0 );
3165: EXCEPTION
3166: WHEN GL_CURRENCY_API.NO_RATE OR
3167: GL_CURRENCY_API.INVALID_CURRENCY THEN
3168: oe_debug_pub.add( 'conversion exception for '
3169: || l_currency_code, 1 );
3170: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3167: GL_CURRENCY_API.INVALID_CURRENCY THEN

3163: );
3164: l_total := l_total + NVL( l_term, 0 );
3165: EXCEPTION
3166: WHEN GL_CURRENCY_API.NO_RATE OR
3167: GL_CURRENCY_API.INVALID_CURRENCY THEN
3168: oe_debug_pub.add( 'conversion exception for '
3169: || l_currency_code, 1 );
3170: add_error_currency( x_error_curr_tbl, l_currency_code );
3171: END;

Line 3222: WHEN GL_CURRENCY_API.NO_RATE OR

3218: );
3219: l_total := l_total + NVL( l_term, 0 );
3220:
3221: EXCEPTION
3222: WHEN GL_CURRENCY_API.NO_RATE OR
3223: GL_CURRENCY_API.INVALID_CURRENCY THEN
3224: oe_debug_pub.add( 'conversion exception for '
3225: || l_currency_code, 1 );
3226: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3223: GL_CURRENCY_API.INVALID_CURRENCY THEN

3219: l_total := l_total + NVL( l_term, 0 );
3220:
3221: EXCEPTION
3222: WHEN GL_CURRENCY_API.NO_RATE OR
3223: GL_CURRENCY_API.INVALID_CURRENCY THEN
3224: oe_debug_pub.add( 'conversion exception for '
3225: || l_currency_code, 1 );
3226: add_error_currency( x_error_curr_tbl, l_currency_code );
3227: END;

Line 3307: WHEN GL_CURRENCY_API.NO_RATE

3303: );
3304: l_total := l_total + NVL( l_term, 0 );
3305:
3306: EXCEPTION
3307: WHEN GL_CURRENCY_API.NO_RATE
3308: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3309: oe_debug_pub.add( 'conversion exception for '
3310: || l_currency_code, 1 );
3311: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3308: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3304: l_total := l_total + NVL( l_term, 0 );
3305:
3306: EXCEPTION
3307: WHEN GL_CURRENCY_API.NO_RATE
3308: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3309: oe_debug_pub.add( 'conversion exception for '
3310: || l_currency_code, 1 );
3311: add_error_currency( x_error_curr_tbl, l_currency_code );
3312: END;

Line 3362: WHEN GL_CURRENCY_API.NO_RATE

3358: );
3359: l_total := l_total + NVL( l_term, 0 );
3360:
3361: EXCEPTION
3362: WHEN GL_CURRENCY_API.NO_RATE
3363: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3364: oe_debug_pub.add( 'conversion exception for '
3365: || l_currency_code, 1 );
3366: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3363: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3359: l_total := l_total + NVL( l_term, 0 );
3360:
3361: EXCEPTION
3362: WHEN GL_CURRENCY_API.NO_RATE
3363: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3364: oe_debug_pub.add( 'conversion exception for '
3365: || l_currency_code, 1 );
3366: add_error_currency( x_error_curr_tbl, l_currency_code );
3367: END;

Line 3437: WHEN GL_CURRENCY_API.NO_RATE

3433: );
3434: l_total := l_total + NVL( l_term, 0 );
3435:
3436: EXCEPTION
3437: WHEN GL_CURRENCY_API.NO_RATE
3438: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3439: oe_debug_pub.add( 'conversion exception for '
3440: || l_currency_code, 1 );
3441: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3438: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3434: l_total := l_total + NVL( l_term, 0 );
3435:
3436: EXCEPTION
3437: WHEN GL_CURRENCY_API.NO_RATE
3438: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3439: oe_debug_pub.add( 'conversion exception for '
3440: || l_currency_code, 1 );
3441: add_error_currency( x_error_curr_tbl, l_currency_code );
3442: END;

Line 3507: WHEN GL_CURRENCY_API.NO_RATE OR

3503: );
3504: l_total := l_total + NVL( l_term, 0 );
3505:
3506: EXCEPTION
3507: WHEN GL_CURRENCY_API.NO_RATE OR
3508: GL_CURRENCY_API.INVALID_CURRENCY THEN
3509: oe_debug_pub.add( 'conversion exception for ' ||
3510: l_currency_code, 1 );
3511: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3508: GL_CURRENCY_API.INVALID_CURRENCY THEN

3504: l_total := l_total + NVL( l_term, 0 );
3505:
3506: EXCEPTION
3507: WHEN GL_CURRENCY_API.NO_RATE OR
3508: GL_CURRENCY_API.INVALID_CURRENCY THEN
3509: oe_debug_pub.add( 'conversion exception for ' ||
3510: l_currency_code, 1 );
3511: add_error_currency( x_error_curr_tbl, l_currency_code );
3512: END;

Line 3563: WHEN GL_CURRENCY_API.NO_RATE OR

3559: );
3560: l_total := l_total + NVL( l_term, 0 );
3561:
3562: EXCEPTION
3563: WHEN GL_CURRENCY_API.NO_RATE OR
3564: GL_CURRENCY_API.INVALID_CURRENCY THEN
3565: oe_debug_pub.add( 'conversion exception for ' ||
3566: l_currency_code, 1 );
3567: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3564: GL_CURRENCY_API.INVALID_CURRENCY THEN

3560: l_total := l_total + NVL( l_term, 0 );
3561:
3562: EXCEPTION
3563: WHEN GL_CURRENCY_API.NO_RATE OR
3564: GL_CURRENCY_API.INVALID_CURRENCY THEN
3565: oe_debug_pub.add( 'conversion exception for ' ||
3566: l_currency_code, 1 );
3567: add_error_currency( x_error_curr_tbl, l_currency_code );
3568: END;

Line 3632: WHEN GL_CURRENCY_API.NO_RATE

3628: );
3629: l_total := l_total + NVL( l_term, 0 );
3630:
3631: EXCEPTION
3632: WHEN GL_CURRENCY_API.NO_RATE
3633: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3634: oe_debug_pub.add( 'conversion exception for '
3635: || l_currency_code, 1 );
3636: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3633: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3629: l_total := l_total + NVL( l_term, 0 );
3630:
3631: EXCEPTION
3632: WHEN GL_CURRENCY_API.NO_RATE
3633: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3634: oe_debug_pub.add( 'conversion exception for '
3635: || l_currency_code, 1 );
3636: add_error_currency( x_error_curr_tbl, l_currency_code );
3637: END;

Line 3690: WHEN GL_CURRENCY_API.NO_RATE

3686: );
3687: l_total := l_total + NVL( l_term, 0 );
3688:
3689: EXCEPTION
3690: WHEN GL_CURRENCY_API.NO_RATE
3691: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3692: oe_debug_pub.add( 'conversion exception for '
3693: || l_currency_code, 1 );
3694: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3691: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3687: l_total := l_total + NVL( l_term, 0 );
3688:
3689: EXCEPTION
3690: WHEN GL_CURRENCY_API.NO_RATE
3691: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3692: oe_debug_pub.add( 'conversion exception for '
3693: || l_currency_code, 1 );
3694: add_error_currency( x_error_curr_tbl, l_currency_code );
3695: END;

Line 3753: WHEN GL_CURRENCY_API.NO_RATE

3749: );
3750: l_total := l_total + NVL( l_term, 0 );
3751:
3752: EXCEPTION
3753: WHEN GL_CURRENCY_API.NO_RATE
3754: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3755: oe_debug_pub.add( 'conversion exception for '
3756: || l_currency_code, 1 );
3757: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3754: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3750: l_total := l_total + NVL( l_term, 0 );
3751:
3752: EXCEPTION
3753: WHEN GL_CURRENCY_API.NO_RATE
3754: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3755: oe_debug_pub.add( 'conversion exception for '
3756: || l_currency_code, 1 );
3757: add_error_currency( x_error_curr_tbl, l_currency_code );
3758: END;

Line 3822: WHEN GL_CURRENCY_API.NO_RATE OR

3818: );
3819: l_total := l_total + NVL( l_term, 0 );
3820:
3821: EXCEPTION
3822: WHEN GL_CURRENCY_API.NO_RATE OR
3823: GL_CURRENCY_API.INVALID_CURRENCY THEN
3824:
3825: oe_debug_pub.add( 'conversion exception for '
3826: || l_currency_code, 1 );

Line 3823: GL_CURRENCY_API.INVALID_CURRENCY THEN

3819: l_total := l_total + NVL( l_term, 0 );
3820:
3821: EXCEPTION
3822: WHEN GL_CURRENCY_API.NO_RATE OR
3823: GL_CURRENCY_API.INVALID_CURRENCY THEN
3824:
3825: oe_debug_pub.add( 'conversion exception for '
3826: || l_currency_code, 1 );
3827: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3879: WHEN GL_CURRENCY_API.NO_RATE OR

3875: );
3876: l_total := l_total + NVL( l_term, 0 );
3877:
3878: EXCEPTION
3879: WHEN GL_CURRENCY_API.NO_RATE OR
3880: GL_CURRENCY_API.INVALID_CURRENCY THEN
3881:
3882: oe_debug_pub.add( 'conversion exception for '
3883: || l_currency_code, 1 );

Line 3880: GL_CURRENCY_API.INVALID_CURRENCY THEN

3876: l_total := l_total + NVL( l_term, 0 );
3877:
3878: EXCEPTION
3879: WHEN GL_CURRENCY_API.NO_RATE OR
3880: GL_CURRENCY_API.INVALID_CURRENCY THEN
3881:
3882: oe_debug_pub.add( 'conversion exception for '
3883: || l_currency_code, 1 );
3884: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3986: WHEN GL_CURRENCY_API.NO_RATE OR

3982: );
3983: l_total := l_total + NVL( l_term, 0 );
3984:
3985: EXCEPTION
3986: WHEN GL_CURRENCY_API.NO_RATE OR
3987: GL_CURRENCY_API.INVALID_CURRENCY THEN
3988: oe_debug_pub.add( 'conversion exception for '
3989: || l_currency_code, 1 );
3990: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3987: GL_CURRENCY_API.INVALID_CURRENCY THEN

3983: l_total := l_total + NVL( l_term, 0 );
3984:
3985: EXCEPTION
3986: WHEN GL_CURRENCY_API.NO_RATE OR
3987: GL_CURRENCY_API.INVALID_CURRENCY THEN
3988: oe_debug_pub.add( 'conversion exception for '
3989: || l_currency_code, 1 );
3990: add_error_currency( x_error_curr_tbl, l_currency_code );
3991: END;

Line 4046: WHEN GL_CURRENCY_API.NO_RATE OR

4042: );
4043: l_total := l_total + NVL( l_term, 0 );
4044:
4045: EXCEPTION
4046: WHEN GL_CURRENCY_API.NO_RATE OR
4047: GL_CURRENCY_API.INVALID_CURRENCY THEN
4048: oe_debug_pub.add( 'conversion exception for '
4049: || l_currency_code, 1 );
4050: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4047: GL_CURRENCY_API.INVALID_CURRENCY THEN

4043: l_total := l_total + NVL( l_term, 0 );
4044:
4045: EXCEPTION
4046: WHEN GL_CURRENCY_API.NO_RATE OR
4047: GL_CURRENCY_API.INVALID_CURRENCY THEN
4048: oe_debug_pub.add( 'conversion exception for '
4049: || l_currency_code, 1 );
4050: add_error_currency( x_error_curr_tbl, l_currency_code );
4051: END;

Line 4131: WHEN GL_CURRENCY_API.NO_RATE OR

4127: );
4128: l_total := l_total + NVL( l_term, 0 );
4129:
4130: EXCEPTION
4131: WHEN GL_CURRENCY_API.NO_RATE OR
4132: GL_CURRENCY_API.INVALID_CURRENCY THEN
4133: oe_debug_pub.add( 'conversion exception for '
4134: || l_currency_code, 1 );
4135: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4132: GL_CURRENCY_API.INVALID_CURRENCY THEN

4128: l_total := l_total + NVL( l_term, 0 );
4129:
4130: EXCEPTION
4131: WHEN GL_CURRENCY_API.NO_RATE OR
4132: GL_CURRENCY_API.INVALID_CURRENCY THEN
4133: oe_debug_pub.add( 'conversion exception for '
4134: || l_currency_code, 1 );
4135: add_error_currency( x_error_curr_tbl, l_currency_code );
4136: END;

Line 4188: WHEN GL_CURRENCY_API.NO_RATE OR

4184: );
4185: l_total := l_total + NVL( l_term, 0 );
4186:
4187: EXCEPTION
4188: WHEN GL_CURRENCY_API.NO_RATE OR
4189: GL_CURRENCY_API.INVALID_CURRENCY THEN
4190: oe_debug_pub.add( 'conversion exception for '
4191: || l_currency_code, 1 );
4192: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4189: GL_CURRENCY_API.INVALID_CURRENCY THEN

4185: l_total := l_total + NVL( l_term, 0 );
4186:
4187: EXCEPTION
4188: WHEN GL_CURRENCY_API.NO_RATE OR
4189: GL_CURRENCY_API.INVALID_CURRENCY THEN
4190: oe_debug_pub.add( 'conversion exception for '
4191: || l_currency_code, 1 );
4192: add_error_currency( x_error_curr_tbl, l_currency_code );
4193: END;

Line 4274: WHEN GL_CURRENCY_API.NO_RATE

4270: );
4271: l_total := l_total + NVL( l_term, 0 );
4272:
4273: EXCEPTION
4274: WHEN GL_CURRENCY_API.NO_RATE
4275: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4276: oe_debug_pub.add( 'conversion exception for '
4277: || l_currency_code, 1 );
4278: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4275: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

4271: l_total := l_total + NVL( l_term, 0 );
4272:
4273: EXCEPTION
4274: WHEN GL_CURRENCY_API.NO_RATE
4275: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4276: oe_debug_pub.add( 'conversion exception for '
4277: || l_currency_code, 1 );
4278: add_error_currency( x_error_curr_tbl, l_currency_code );
4279: END;

Line 4331: WHEN GL_CURRENCY_API.NO_RATE

4327: );
4328: l_total := l_total + NVL( l_term, 0 );
4329:
4330: EXCEPTION
4331: WHEN GL_CURRENCY_API.NO_RATE
4332: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4333: oe_debug_pub.add( 'conversion exception for '
4334: || l_currency_code, 1 );
4335: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4332: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

4328: l_total := l_total + NVL( l_term, 0 );
4329:
4330: EXCEPTION
4331: WHEN GL_CURRENCY_API.NO_RATE
4332: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4333: oe_debug_pub.add( 'conversion exception for '
4334: || l_currency_code, 1 );
4335: add_error_currency( x_error_curr_tbl, l_currency_code );
4336: END;

Line 4395: WHEN GL_CURRENCY_API.NO_RATE

4391: );
4392: l_total := l_total + NVL( l_term, 0 );
4393:
4394: EXCEPTION
4395: WHEN GL_CURRENCY_API.NO_RATE
4396: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4397: oe_debug_pub.add( 'conversion exception for '
4398: || l_currency_code, 1 );
4399: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4396: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

4392: l_total := l_total + NVL( l_term, 0 );
4393:
4394: EXCEPTION
4395: WHEN GL_CURRENCY_API.NO_RATE
4396: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4397: oe_debug_pub.add( 'conversion exception for '
4398: || l_currency_code, 1 );
4399: add_error_currency( x_error_curr_tbl, l_currency_code );
4400: END;

Line 4467: WHEN GL_CURRENCY_API.NO_RATE OR

4463: );
4464: l_total := l_total + NVL( l_term, 0 );
4465:
4466: EXCEPTION
4467: WHEN GL_CURRENCY_API.NO_RATE OR
4468: GL_CURRENCY_API.INVALID_CURRENCY THEN
4469: oe_debug_pub.add( 'conversion exception for ' ||
4470: l_currency_code, 1 );
4471: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4468: GL_CURRENCY_API.INVALID_CURRENCY THEN

4464: l_total := l_total + NVL( l_term, 0 );
4465:
4466: EXCEPTION
4467: WHEN GL_CURRENCY_API.NO_RATE OR
4468: GL_CURRENCY_API.INVALID_CURRENCY THEN
4469: oe_debug_pub.add( 'conversion exception for ' ||
4470: l_currency_code, 1 );
4471: add_error_currency( x_error_curr_tbl, l_currency_code );
4472: END;

Line 4526: WHEN GL_CURRENCY_API.NO_RATE OR

4522: );
4523: l_total := l_total + NVL( l_term, 0 );
4524:
4525: EXCEPTION
4526: WHEN GL_CURRENCY_API.NO_RATE OR
4527: GL_CURRENCY_API.INVALID_CURRENCY THEN
4528: oe_debug_pub.add( 'conversion exception for ' ||
4529: l_currency_code, 1 );
4530: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4527: GL_CURRENCY_API.INVALID_CURRENCY THEN

4523: l_total := l_total + NVL( l_term, 0 );
4524:
4525: EXCEPTION
4526: WHEN GL_CURRENCY_API.NO_RATE OR
4527: GL_CURRENCY_API.INVALID_CURRENCY THEN
4528: oe_debug_pub.add( 'conversion exception for ' ||
4529: l_currency_code, 1 );
4530: add_error_currency( x_error_curr_tbl, l_currency_code );
4531: END;

Line 4599: WHEN GL_CURRENCY_API.NO_RATE

4595: );
4596: l_total := l_total + NVL( l_term, 0 );
4597:
4598: EXCEPTION
4599: WHEN GL_CURRENCY_API.NO_RATE
4600: OR GL_CURRENCY_API.INVALID_CURRENCY
4601: THEN
4602: oe_debug_pub.add( 'conversion exception for '
4603: || l_currency_code, 1 );

Line 4600: OR GL_CURRENCY_API.INVALID_CURRENCY

4596: l_total := l_total + NVL( l_term, 0 );
4597:
4598: EXCEPTION
4599: WHEN GL_CURRENCY_API.NO_RATE
4600: OR GL_CURRENCY_API.INVALID_CURRENCY
4601: THEN
4602: oe_debug_pub.add( 'conversion exception for '
4603: || l_currency_code, 1 );
4604: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4658: WHEN GL_CURRENCY_API.NO_RATE

4654: );
4655: l_total := l_total + NVL( l_term, 0 );
4656:
4657: EXCEPTION
4658: WHEN GL_CURRENCY_API.NO_RATE
4659: OR GL_CURRENCY_API.INVALID_CURRENCY
4660: THEN
4661: oe_debug_pub.add( 'conversion exception for '
4662: || l_currency_code, 1 );

Line 4659: OR GL_CURRENCY_API.INVALID_CURRENCY

4655: l_total := l_total + NVL( l_term, 0 );
4656:
4657: EXCEPTION
4658: WHEN GL_CURRENCY_API.NO_RATE
4659: OR GL_CURRENCY_API.INVALID_CURRENCY
4660: THEN
4661: oe_debug_pub.add( 'conversion exception for '
4662: || l_currency_code, 1 );
4663: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4720: WHEN GL_CURRENCY_API.NO_RATE

4716: );
4717: l_total := l_total + NVL( l_term, 0 );
4718:
4719: EXCEPTION
4720: WHEN GL_CURRENCY_API.NO_RATE
4721: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4722: oe_debug_pub.add( 'conversion exception for '
4723: || l_currency_code, 1 );
4724: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4721: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

4717: l_total := l_total + NVL( l_term, 0 );
4718:
4719: EXCEPTION
4720: WHEN GL_CURRENCY_API.NO_RATE
4721: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4722: oe_debug_pub.add( 'conversion exception for '
4723: || l_currency_code, 1 );
4724: add_error_currency( x_error_curr_tbl, l_currency_code );
4725: END;

Line 4787: WHEN GL_CURRENCY_API.NO_RATE OR

4783: );
4784: l_total := l_total + NVL( l_term, 0 );
4785:
4786: EXCEPTION
4787: WHEN GL_CURRENCY_API.NO_RATE OR
4788: GL_CURRENCY_API.INVALID_CURRENCY
4789: THEN
4790:
4791: oe_debug_pub.add( 'conversion exception for '

Line 4788: GL_CURRENCY_API.INVALID_CURRENCY

4784: l_total := l_total + NVL( l_term, 0 );
4785:
4786: EXCEPTION
4787: WHEN GL_CURRENCY_API.NO_RATE OR
4788: GL_CURRENCY_API.INVALID_CURRENCY
4789: THEN
4790:
4791: oe_debug_pub.add( 'conversion exception for '
4792: || l_currency_code, 1 );

Line 4846: WHEN GL_CURRENCY_API.NO_RATE OR

4842: );
4843: l_total := l_total + NVL( l_term, 0 );
4844:
4845: EXCEPTION
4846: WHEN GL_CURRENCY_API.NO_RATE OR
4847: GL_CURRENCY_API.INVALID_CURRENCY
4848: THEN
4849:
4850: oe_debug_pub.add( 'conversion exception for '

Line 4847: GL_CURRENCY_API.INVALID_CURRENCY

4843: l_total := l_total + NVL( l_term, 0 );
4844:
4845: EXCEPTION
4846: WHEN GL_CURRENCY_API.NO_RATE OR
4847: GL_CURRENCY_API.INVALID_CURRENCY
4848: THEN
4849:
4850: oe_debug_pub.add( 'conversion exception for '
4851: || l_currency_code, 1 );