DBA Data[Home] [Help]

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on GL_CURRENCY_API

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

1765:
1766:
1767:
1768: -----------------------------------------------------------------
1769: --- API to convert the amount using GL currency API
1770: -- with Traingulation
1771: ----------------------------------------------------------------
1772: FUNCTION convert_currency_amount
1773: ( p_amount IN NUMBER

Line 1792: WHEN GL_CURRENCY_API.NO_RATE OR

1788: , p_conversion_date => SYSDATE
1789: , p_conversion_type => g_conversion_type
1790: );
1791: EXCEPTION
1792: WHEN GL_CURRENCY_API.NO_RATE OR
1793: GL_CURRENCY_API.INVALID_CURRENCY
1794: THEN
1795: oe_debug_pub.add( 'conversion exception for '
1796: || p_transactional_currency, 1 );

Line 1793: GL_CURRENCY_API.INVALID_CURRENCY

1789: , p_conversion_type => g_conversion_type
1790: );
1791: EXCEPTION
1792: WHEN GL_CURRENCY_API.NO_RATE OR
1793: GL_CURRENCY_API.INVALID_CURRENCY
1794: THEN
1795: oe_debug_pub.add( 'conversion exception for '
1796: || p_transactional_currency, 1 );
1797: add_error_currency( g_error_curr_tbl, p_transactional_currency );

Line 2883: WHEN GL_CURRENCY_API.NO_RATE OR

2879: );
2880: l_total := l_total + NVL( l_term, 0 );
2881:
2882: EXCEPTION
2883: WHEN GL_CURRENCY_API.NO_RATE OR
2884: GL_CURRENCY_API.INVALID_CURRENCY THEN
2885: add_error_currency( x_error_curr_tbl, l_currency_code );
2886:
2887: IF G_debug_flag = 'Y'

Line 2884: GL_CURRENCY_API.INVALID_CURRENCY THEN

2880: l_total := l_total + NVL( l_term, 0 );
2881:
2882: EXCEPTION
2883: WHEN GL_CURRENCY_API.NO_RATE OR
2884: GL_CURRENCY_API.INVALID_CURRENCY THEN
2885: add_error_currency( x_error_curr_tbl, l_currency_code );
2886:
2887: IF G_debug_flag = 'Y'
2888: THEN

Line 2959: WHEN GL_CURRENCY_API.NO_RATE OR

2955: );
2956: l_total := l_total + NVL( l_term, 0 );
2957:
2958: EXCEPTION
2959: WHEN GL_CURRENCY_API.NO_RATE OR
2960: GL_CURRENCY_API.INVALID_CURRENCY THEN
2961: oe_debug_pub.add( 'conversion exception for '
2962: || l_currency_code, 1 );
2963: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 2960: GL_CURRENCY_API.INVALID_CURRENCY THEN

2956: l_total := l_total + NVL( l_term, 0 );
2957:
2958: EXCEPTION
2959: WHEN GL_CURRENCY_API.NO_RATE OR
2960: GL_CURRENCY_API.INVALID_CURRENCY THEN
2961: oe_debug_pub.add( 'conversion exception for '
2962: || l_currency_code, 1 );
2963: add_error_currency( x_error_curr_tbl, l_currency_code );
2964: END;

Line 3027: WHEN GL_CURRENCY_API.NO_RATE OR

3023: );
3024: l_total := l_total + NVL( l_term, 0 );
3025:
3026: EXCEPTION
3027: WHEN GL_CURRENCY_API.NO_RATE OR
3028: GL_CURRENCY_API.INVALID_CURRENCY THEN
3029: oe_debug_pub.add( 'conversion exception for '
3030: || l_currency_code, 1 );
3031: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3028: GL_CURRENCY_API.INVALID_CURRENCY THEN

3024: l_total := l_total + NVL( l_term, 0 );
3025:
3026: EXCEPTION
3027: WHEN GL_CURRENCY_API.NO_RATE OR
3028: GL_CURRENCY_API.INVALID_CURRENCY THEN
3029: oe_debug_pub.add( 'conversion exception for '
3030: || l_currency_code, 1 );
3031: add_error_currency( x_error_curr_tbl, l_currency_code );
3032: END;

Line 3103: WHEN GL_CURRENCY_API.NO_RATE OR

3099: );
3100: l_total := l_total + NVL( l_term, 0 );
3101:
3102: EXCEPTION
3103: WHEN GL_CURRENCY_API.NO_RATE OR
3104: GL_CURRENCY_API.INVALID_CURRENCY THEN
3105: oe_debug_pub.add( 'conversion exception for '
3106: || l_currency_code, 1 );
3107: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3104: GL_CURRENCY_API.INVALID_CURRENCY THEN

3100: l_total := l_total + NVL( l_term, 0 );
3101:
3102: EXCEPTION
3103: WHEN GL_CURRENCY_API.NO_RATE OR
3104: GL_CURRENCY_API.INVALID_CURRENCY THEN
3105: oe_debug_pub.add( 'conversion exception for '
3106: || l_currency_code, 1 );
3107: add_error_currency( x_error_curr_tbl, l_currency_code );
3108: END;

Line 3173: WHEN GL_CURRENCY_API.NO_RATE OR

3169: );
3170: l_total := l_total + NVL( l_term, 0 );
3171:
3172: EXCEPTION
3173: WHEN GL_CURRENCY_API.NO_RATE OR
3174: GL_CURRENCY_API.INVALID_CURRENCY THEN
3175: oe_debug_pub.add( 'conversion exception for '
3176: || l_currency_code, 1 );
3177: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3174: GL_CURRENCY_API.INVALID_CURRENCY THEN

3170: l_total := l_total + NVL( l_term, 0 );
3171:
3172: EXCEPTION
3173: WHEN GL_CURRENCY_API.NO_RATE OR
3174: GL_CURRENCY_API.INVALID_CURRENCY THEN
3175: oe_debug_pub.add( 'conversion exception for '
3176: || l_currency_code, 1 );
3177: add_error_currency( x_error_curr_tbl, l_currency_code );
3178: END;

Line 3231: WHEN GL_CURRENCY_API.NO_RATE OR

3227: );
3228: l_total := l_total + NVL( l_term, 0 );
3229:
3230: EXCEPTION
3231: WHEN GL_CURRENCY_API.NO_RATE OR
3232: GL_CURRENCY_API.INVALID_CURRENCY THEN
3233: oe_debug_pub.add( 'conversion exception for '
3234: || l_currency_code, 1 );
3235: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3232: GL_CURRENCY_API.INVALID_CURRENCY THEN

3228: l_total := l_total + NVL( l_term, 0 );
3229:
3230: EXCEPTION
3231: WHEN GL_CURRENCY_API.NO_RATE OR
3232: GL_CURRENCY_API.INVALID_CURRENCY THEN
3233: oe_debug_pub.add( 'conversion exception for '
3234: || l_currency_code, 1 );
3235: add_error_currency( x_error_curr_tbl, l_currency_code );
3236: END;

Line 3334: WHEN GL_CURRENCY_API.NO_RATE OR

3330: );
3331: l_total := l_total + NVL( l_term, 0 );
3332:
3333: EXCEPTION
3334: WHEN GL_CURRENCY_API.NO_RATE OR
3335: GL_CURRENCY_API.INVALID_CURRENCY THEN
3336: oe_debug_pub.add( 'conversion exception for '
3337: || l_currency_code, 1 );
3338: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3335: GL_CURRENCY_API.INVALID_CURRENCY THEN

3331: l_total := l_total + NVL( l_term, 0 );
3332:
3333: EXCEPTION
3334: WHEN GL_CURRENCY_API.NO_RATE OR
3335: GL_CURRENCY_API.INVALID_CURRENCY THEN
3336: oe_debug_pub.add( 'conversion exception for '
3337: || l_currency_code, 1 );
3338: add_error_currency( x_error_curr_tbl, l_currency_code );
3339: END;

Line 3388: WHEN GL_CURRENCY_API.NO_RATE OR

3384: );
3385: l_total := l_total + NVL( l_term, 0 );
3386:
3387: EXCEPTION
3388: WHEN GL_CURRENCY_API.NO_RATE OR
3389: GL_CURRENCY_API.INVALID_CURRENCY THEN
3390: oe_debug_pub.add( 'conversion exception for '
3391: || l_currency_code, 1 );
3392: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3389: GL_CURRENCY_API.INVALID_CURRENCY THEN

3385: l_total := l_total + NVL( l_term, 0 );
3386:
3387: EXCEPTION
3388: WHEN GL_CURRENCY_API.NO_RATE OR
3389: GL_CURRENCY_API.INVALID_CURRENCY THEN
3390: oe_debug_pub.add( 'conversion exception for '
3391: || l_currency_code, 1 );
3392: add_error_currency( x_error_curr_tbl, l_currency_code );
3393: END;

Line 3458: WHEN GL_CURRENCY_API.NO_RATE OR

3454: , p_conversion_type => g_conversion_type
3455: );
3456: l_total := l_total + NVL( l_term, 0 );
3457: EXCEPTION
3458: WHEN GL_CURRENCY_API.NO_RATE OR
3459: GL_CURRENCY_API.INVALID_CURRENCY THEN
3460: oe_debug_pub.add( 'conversion exception for '
3461: || l_currency_code, 1 );
3462: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3459: GL_CURRENCY_API.INVALID_CURRENCY THEN

3455: );
3456: l_total := l_total + NVL( l_term, 0 );
3457: EXCEPTION
3458: WHEN GL_CURRENCY_API.NO_RATE OR
3459: GL_CURRENCY_API.INVALID_CURRENCY THEN
3460: oe_debug_pub.add( 'conversion exception for '
3461: || l_currency_code, 1 );
3462: add_error_currency( x_error_curr_tbl, l_currency_code );
3463: END;

Line 3514: WHEN GL_CURRENCY_API.NO_RATE OR

3510: );
3511: l_total := l_total + NVL( l_term, 0 );
3512:
3513: EXCEPTION
3514: WHEN GL_CURRENCY_API.NO_RATE OR
3515: GL_CURRENCY_API.INVALID_CURRENCY THEN
3516: oe_debug_pub.add( 'conversion exception for '
3517: || l_currency_code, 1 );
3518: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3515: GL_CURRENCY_API.INVALID_CURRENCY THEN

3511: l_total := l_total + NVL( l_term, 0 );
3512:
3513: EXCEPTION
3514: WHEN GL_CURRENCY_API.NO_RATE OR
3515: GL_CURRENCY_API.INVALID_CURRENCY THEN
3516: oe_debug_pub.add( 'conversion exception for '
3517: || l_currency_code, 1 );
3518: add_error_currency( x_error_curr_tbl, l_currency_code );
3519: END;

Line 3599: WHEN GL_CURRENCY_API.NO_RATE

3595: );
3596: l_total := l_total + NVL( l_term, 0 );
3597:
3598: EXCEPTION
3599: WHEN GL_CURRENCY_API.NO_RATE
3600: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3601: oe_debug_pub.add( 'conversion exception for '
3602: || l_currency_code, 1 );
3603: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3600: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3596: l_total := l_total + NVL( l_term, 0 );
3597:
3598: EXCEPTION
3599: WHEN GL_CURRENCY_API.NO_RATE
3600: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3601: oe_debug_pub.add( 'conversion exception for '
3602: || l_currency_code, 1 );
3603: add_error_currency( x_error_curr_tbl, l_currency_code );
3604: END;

Line 3654: WHEN GL_CURRENCY_API.NO_RATE

3650: );
3651: l_total := l_total + NVL( l_term, 0 );
3652:
3653: EXCEPTION
3654: WHEN GL_CURRENCY_API.NO_RATE
3655: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3656: oe_debug_pub.add( 'conversion exception for '
3657: || l_currency_code, 1 );
3658: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3655: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3651: l_total := l_total + NVL( l_term, 0 );
3652:
3653: EXCEPTION
3654: WHEN GL_CURRENCY_API.NO_RATE
3655: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3656: oe_debug_pub.add( 'conversion exception for '
3657: || l_currency_code, 1 );
3658: add_error_currency( x_error_curr_tbl, l_currency_code );
3659: END;

Line 3729: WHEN GL_CURRENCY_API.NO_RATE

3725: );
3726: l_total := l_total + NVL( l_term, 0 );
3727:
3728: EXCEPTION
3729: WHEN GL_CURRENCY_API.NO_RATE
3730: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3731: oe_debug_pub.add( 'conversion exception for '
3732: || l_currency_code, 1 );
3733: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3730: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3726: l_total := l_total + NVL( l_term, 0 );
3727:
3728: EXCEPTION
3729: WHEN GL_CURRENCY_API.NO_RATE
3730: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3731: oe_debug_pub.add( 'conversion exception for '
3732: || l_currency_code, 1 );
3733: add_error_currency( x_error_curr_tbl, l_currency_code );
3734: END;

Line 3799: WHEN GL_CURRENCY_API.NO_RATE OR

3795: );
3796: l_total := l_total + NVL( l_term, 0 );
3797:
3798: EXCEPTION
3799: WHEN GL_CURRENCY_API.NO_RATE OR
3800: GL_CURRENCY_API.INVALID_CURRENCY THEN
3801: oe_debug_pub.add( 'conversion exception for ' ||
3802: l_currency_code, 1 );
3803: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3800: GL_CURRENCY_API.INVALID_CURRENCY THEN

3796: l_total := l_total + NVL( l_term, 0 );
3797:
3798: EXCEPTION
3799: WHEN GL_CURRENCY_API.NO_RATE OR
3800: GL_CURRENCY_API.INVALID_CURRENCY THEN
3801: oe_debug_pub.add( 'conversion exception for ' ||
3802: l_currency_code, 1 );
3803: add_error_currency( x_error_curr_tbl, l_currency_code );
3804: END;

Line 3855: WHEN GL_CURRENCY_API.NO_RATE OR

3851: );
3852: l_total := l_total + NVL( l_term, 0 );
3853:
3854: EXCEPTION
3855: WHEN GL_CURRENCY_API.NO_RATE OR
3856: GL_CURRENCY_API.INVALID_CURRENCY THEN
3857: oe_debug_pub.add( 'conversion exception for ' ||
3858: l_currency_code, 1 );
3859: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3856: GL_CURRENCY_API.INVALID_CURRENCY THEN

3852: l_total := l_total + NVL( l_term, 0 );
3853:
3854: EXCEPTION
3855: WHEN GL_CURRENCY_API.NO_RATE OR
3856: GL_CURRENCY_API.INVALID_CURRENCY THEN
3857: oe_debug_pub.add( 'conversion exception for ' ||
3858: l_currency_code, 1 );
3859: add_error_currency( x_error_curr_tbl, l_currency_code );
3860: END;

Line 3924: WHEN GL_CURRENCY_API.NO_RATE

3920: );
3921: l_total := l_total + NVL( l_term, 0 );
3922:
3923: EXCEPTION
3924: WHEN GL_CURRENCY_API.NO_RATE
3925: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3926: oe_debug_pub.add( 'conversion exception for '
3927: || l_currency_code, 1 );
3928: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 3925: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

3921: l_total := l_total + NVL( l_term, 0 );
3922:
3923: EXCEPTION
3924: WHEN GL_CURRENCY_API.NO_RATE
3925: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3926: oe_debug_pub.add( 'conversion exception for '
3927: || l_currency_code, 1 );
3928: add_error_currency( x_error_curr_tbl, l_currency_code );
3929: END;

Line 3982: WHEN GL_CURRENCY_API.NO_RATE

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

Line 3983: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

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

Line 4045: WHEN GL_CURRENCY_API.NO_RATE

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

Line 4046: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

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

Line 4114: WHEN GL_CURRENCY_API.NO_RATE OR

4110: );
4111: l_total := l_total + NVL( l_term, 0 );
4112:
4113: EXCEPTION
4114: WHEN GL_CURRENCY_API.NO_RATE OR
4115: GL_CURRENCY_API.INVALID_CURRENCY THEN
4116:
4117: oe_debug_pub.add( 'conversion exception for '
4118: || l_currency_code, 1 );

Line 4115: GL_CURRENCY_API.INVALID_CURRENCY THEN

4111: l_total := l_total + NVL( l_term, 0 );
4112:
4113: EXCEPTION
4114: WHEN GL_CURRENCY_API.NO_RATE OR
4115: GL_CURRENCY_API.INVALID_CURRENCY THEN
4116:
4117: oe_debug_pub.add( 'conversion exception for '
4118: || l_currency_code, 1 );
4119: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4171: WHEN GL_CURRENCY_API.NO_RATE OR

4167: );
4168: l_total := l_total + NVL( l_term, 0 );
4169:
4170: EXCEPTION
4171: WHEN GL_CURRENCY_API.NO_RATE OR
4172: GL_CURRENCY_API.INVALID_CURRENCY THEN
4173:
4174: oe_debug_pub.add( 'conversion exception for '
4175: || l_currency_code, 1 );

Line 4172: GL_CURRENCY_API.INVALID_CURRENCY THEN

4168: l_total := l_total + NVL( l_term, 0 );
4169:
4170: EXCEPTION
4171: WHEN GL_CURRENCY_API.NO_RATE OR
4172: GL_CURRENCY_API.INVALID_CURRENCY THEN
4173:
4174: oe_debug_pub.add( 'conversion exception for '
4175: || l_currency_code, 1 );
4176: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4278: WHEN GL_CURRENCY_API.NO_RATE OR

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

Line 4279: GL_CURRENCY_API.INVALID_CURRENCY THEN

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

Line 4338: WHEN GL_CURRENCY_API.NO_RATE OR

4334: );
4335: l_total := l_total + NVL( l_term, 0 );
4336:
4337: EXCEPTION
4338: WHEN GL_CURRENCY_API.NO_RATE OR
4339: GL_CURRENCY_API.INVALID_CURRENCY THEN
4340: oe_debug_pub.add( 'conversion exception for '
4341: || l_currency_code, 1 );
4342: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4339: GL_CURRENCY_API.INVALID_CURRENCY THEN

4335: l_total := l_total + NVL( l_term, 0 );
4336:
4337: EXCEPTION
4338: WHEN GL_CURRENCY_API.NO_RATE OR
4339: GL_CURRENCY_API.INVALID_CURRENCY THEN
4340: oe_debug_pub.add( 'conversion exception for '
4341: || l_currency_code, 1 );
4342: add_error_currency( x_error_curr_tbl, l_currency_code );
4343: END;

Line 4423: WHEN GL_CURRENCY_API.NO_RATE OR

4419: );
4420: l_total := l_total + NVL( l_term, 0 );
4421:
4422: EXCEPTION
4423: WHEN GL_CURRENCY_API.NO_RATE OR
4424: GL_CURRENCY_API.INVALID_CURRENCY THEN
4425: oe_debug_pub.add( 'conversion exception for '
4426: || l_currency_code, 1 );
4427: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4424: GL_CURRENCY_API.INVALID_CURRENCY THEN

4420: l_total := l_total + NVL( l_term, 0 );
4421:
4422: EXCEPTION
4423: WHEN GL_CURRENCY_API.NO_RATE OR
4424: GL_CURRENCY_API.INVALID_CURRENCY THEN
4425: oe_debug_pub.add( 'conversion exception for '
4426: || l_currency_code, 1 );
4427: add_error_currency( x_error_curr_tbl, l_currency_code );
4428: END;

Line 4480: WHEN GL_CURRENCY_API.NO_RATE OR

4476: );
4477: l_total := l_total + NVL( l_term, 0 );
4478:
4479: EXCEPTION
4480: WHEN GL_CURRENCY_API.NO_RATE OR
4481: GL_CURRENCY_API.INVALID_CURRENCY THEN
4482: oe_debug_pub.add( 'conversion exception for '
4483: || l_currency_code, 1 );
4484: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4481: GL_CURRENCY_API.INVALID_CURRENCY THEN

4477: l_total := l_total + NVL( l_term, 0 );
4478:
4479: EXCEPTION
4480: WHEN GL_CURRENCY_API.NO_RATE OR
4481: GL_CURRENCY_API.INVALID_CURRENCY THEN
4482: oe_debug_pub.add( 'conversion exception for '
4483: || l_currency_code, 1 );
4484: add_error_currency( x_error_curr_tbl, l_currency_code );
4485: END;

Line 4566: WHEN GL_CURRENCY_API.NO_RATE

4562: );
4563: l_total := l_total + NVL( l_term, 0 );
4564:
4565: EXCEPTION
4566: WHEN GL_CURRENCY_API.NO_RATE
4567: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4568: oe_debug_pub.add( 'conversion exception for '
4569: || l_currency_code, 1 );
4570: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4567: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

4563: l_total := l_total + NVL( l_term, 0 );
4564:
4565: EXCEPTION
4566: WHEN GL_CURRENCY_API.NO_RATE
4567: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4568: oe_debug_pub.add( 'conversion exception for '
4569: || l_currency_code, 1 );
4570: add_error_currency( x_error_curr_tbl, l_currency_code );
4571: END;

Line 4623: WHEN GL_CURRENCY_API.NO_RATE

4619: );
4620: l_total := l_total + NVL( l_term, 0 );
4621:
4622: EXCEPTION
4623: WHEN GL_CURRENCY_API.NO_RATE
4624: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4625: oe_debug_pub.add( 'conversion exception for '
4626: || l_currency_code, 1 );
4627: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4624: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

4620: l_total := l_total + NVL( l_term, 0 );
4621:
4622: EXCEPTION
4623: WHEN GL_CURRENCY_API.NO_RATE
4624: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4625: oe_debug_pub.add( 'conversion exception for '
4626: || l_currency_code, 1 );
4627: add_error_currency( x_error_curr_tbl, l_currency_code );
4628: END;

Line 4687: WHEN GL_CURRENCY_API.NO_RATE

4683: );
4684: l_total := l_total + NVL( l_term, 0 );
4685:
4686: EXCEPTION
4687: WHEN GL_CURRENCY_API.NO_RATE
4688: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4689: oe_debug_pub.add( 'conversion exception for '
4690: || l_currency_code, 1 );
4691: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4688: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

4684: l_total := l_total + NVL( l_term, 0 );
4685:
4686: EXCEPTION
4687: WHEN GL_CURRENCY_API.NO_RATE
4688: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4689: oe_debug_pub.add( 'conversion exception for '
4690: || l_currency_code, 1 );
4691: add_error_currency( x_error_curr_tbl, l_currency_code );
4692: END;

Line 4759: WHEN GL_CURRENCY_API.NO_RATE OR

4755: );
4756: l_total := l_total + NVL( l_term, 0 );
4757:
4758: EXCEPTION
4759: WHEN GL_CURRENCY_API.NO_RATE OR
4760: GL_CURRENCY_API.INVALID_CURRENCY THEN
4761: oe_debug_pub.add( 'conversion exception for ' ||
4762: l_currency_code, 1 );
4763: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4760: GL_CURRENCY_API.INVALID_CURRENCY THEN

4756: l_total := l_total + NVL( l_term, 0 );
4757:
4758: EXCEPTION
4759: WHEN GL_CURRENCY_API.NO_RATE OR
4760: GL_CURRENCY_API.INVALID_CURRENCY THEN
4761: oe_debug_pub.add( 'conversion exception for ' ||
4762: l_currency_code, 1 );
4763: add_error_currency( x_error_curr_tbl, l_currency_code );
4764: END;

Line 4818: WHEN GL_CURRENCY_API.NO_RATE OR

4814: );
4815: l_total := l_total + NVL( l_term, 0 );
4816:
4817: EXCEPTION
4818: WHEN GL_CURRENCY_API.NO_RATE OR
4819: GL_CURRENCY_API.INVALID_CURRENCY THEN
4820: oe_debug_pub.add( 'conversion exception for ' ||
4821: l_currency_code, 1 );
4822: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4819: GL_CURRENCY_API.INVALID_CURRENCY THEN

4815: l_total := l_total + NVL( l_term, 0 );
4816:
4817: EXCEPTION
4818: WHEN GL_CURRENCY_API.NO_RATE OR
4819: GL_CURRENCY_API.INVALID_CURRENCY THEN
4820: oe_debug_pub.add( 'conversion exception for ' ||
4821: l_currency_code, 1 );
4822: add_error_currency( x_error_curr_tbl, l_currency_code );
4823: END;

Line 4891: WHEN GL_CURRENCY_API.NO_RATE

4887: );
4888: l_total := l_total + NVL( l_term, 0 );
4889:
4890: EXCEPTION
4891: WHEN GL_CURRENCY_API.NO_RATE
4892: OR GL_CURRENCY_API.INVALID_CURRENCY
4893: THEN
4894: oe_debug_pub.add( 'conversion exception for '
4895: || l_currency_code, 1 );

Line 4892: OR GL_CURRENCY_API.INVALID_CURRENCY

4888: l_total := l_total + NVL( l_term, 0 );
4889:
4890: EXCEPTION
4891: WHEN GL_CURRENCY_API.NO_RATE
4892: OR GL_CURRENCY_API.INVALID_CURRENCY
4893: THEN
4894: oe_debug_pub.add( 'conversion exception for '
4895: || l_currency_code, 1 );
4896: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 4950: WHEN GL_CURRENCY_API.NO_RATE

4946: );
4947: l_total := l_total + NVL( l_term, 0 );
4948:
4949: EXCEPTION
4950: WHEN GL_CURRENCY_API.NO_RATE
4951: OR GL_CURRENCY_API.INVALID_CURRENCY
4952: THEN
4953: oe_debug_pub.add( 'conversion exception for '
4954: || l_currency_code, 1 );

Line 4951: OR GL_CURRENCY_API.INVALID_CURRENCY

4947: l_total := l_total + NVL( l_term, 0 );
4948:
4949: EXCEPTION
4950: WHEN GL_CURRENCY_API.NO_RATE
4951: OR GL_CURRENCY_API.INVALID_CURRENCY
4952: THEN
4953: oe_debug_pub.add( 'conversion exception for '
4954: || l_currency_code, 1 );
4955: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 5012: WHEN GL_CURRENCY_API.NO_RATE

5008: );
5009: l_total := l_total + NVL( l_term, 0 );
5010:
5011: EXCEPTION
5012: WHEN GL_CURRENCY_API.NO_RATE
5013: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
5014: oe_debug_pub.add( 'conversion exception for '
5015: || l_currency_code, 1 );
5016: add_error_currency( x_error_curr_tbl, l_currency_code );

Line 5013: OR GL_CURRENCY_API.INVALID_CURRENCY THEN

5009: l_total := l_total + NVL( l_term, 0 );
5010:
5011: EXCEPTION
5012: WHEN GL_CURRENCY_API.NO_RATE
5013: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
5014: oe_debug_pub.add( 'conversion exception for '
5015: || l_currency_code, 1 );
5016: add_error_currency( x_error_curr_tbl, l_currency_code );
5017: END;

Line 5079: WHEN GL_CURRENCY_API.NO_RATE OR

5075: );
5076: l_total := l_total + NVL( l_term, 0 );
5077:
5078: EXCEPTION
5079: WHEN GL_CURRENCY_API.NO_RATE OR
5080: GL_CURRENCY_API.INVALID_CURRENCY
5081: THEN
5082:
5083: oe_debug_pub.add( 'conversion exception for '

Line 5080: GL_CURRENCY_API.INVALID_CURRENCY

5076: l_total := l_total + NVL( l_term, 0 );
5077:
5078: EXCEPTION
5079: WHEN GL_CURRENCY_API.NO_RATE OR
5080: GL_CURRENCY_API.INVALID_CURRENCY
5081: THEN
5082:
5083: oe_debug_pub.add( 'conversion exception for '
5084: || l_currency_code, 1 );

Line 5139: WHEN GL_CURRENCY_API.NO_RATE OR

5135: );
5136: l_total := l_total + NVL( l_term, 0 );
5137:
5138: EXCEPTION
5139: WHEN GL_CURRENCY_API.NO_RATE OR
5140: GL_CURRENCY_API.INVALID_CURRENCY
5141: THEN
5142:
5143: oe_debug_pub.add( 'conversion exception for '

Line 5140: GL_CURRENCY_API.INVALID_CURRENCY

5136: l_total := l_total + NVL( l_term, 0 );
5137:
5138: EXCEPTION
5139: WHEN GL_CURRENCY_API.NO_RATE OR
5140: GL_CURRENCY_API.INVALID_CURRENCY
5141: THEN
5142:
5143: oe_debug_pub.add( 'conversion exception for '
5144: || l_currency_code, 1 );