DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on GL_CURRENCY_API

Line 997: GL_Currency_API.Convert_Closest_Amount (

993: l_conv_date := p_conv_date;
994: END IF;
995:
996: -- Call the proper GL API to convert the amount.
997: GL_Currency_API.Convert_Closest_Amount (
998: x_from_currency => p_from_currency,
999: x_to_currency => p_to_currency,
1000: x_conversion_date => l_conv_date,
1001: x_conversion_type => l_conversion_type,

Line 1011: WHEN GL_Currency_API.NO_RATE THEN

1007: x_numerator => l_numerator,
1008: x_rate => l_rate
1009: );
1010: EXCEPTION
1011: WHEN GL_Currency_API.NO_RATE THEN
1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: FND_MESSAGE.Set_Name ('OZF', 'OZF_NO_RATE');
1014: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
1015: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);

Line 1019: WHEN GL_Currency_API.INVALID_CURRENCY THEN

1015: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
1016: FND_MSG_PUB.Add;
1017: END IF;
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: WHEN GL_Currency_API.INVALID_CURRENCY THEN
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.Set_Name ('OZF', 'OZF_INVALID_CURR');
1022: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
1023: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);

Line 2067: gl_currency_api.convert_closest_amount(

2063: l_conv_date := p_conversion_date;
2064: END IF;
2065:
2066: --
2067: gl_currency_api.convert_closest_amount(
2068: x_from_currency => p_from_currency
2069: ,x_to_currency => l_to_currency
2070: ,x_conversion_date => l_conv_date
2071: ,x_conversion_type => p_conversion_type

Line 2084: WHEN gl_currency_api.no_rate THEN

2080:
2081: EXCEPTION
2082: WHEN fnd_api.g_exc_error THEN
2083: x_return_status := fnd_api.g_ret_sts_error;
2084: WHEN gl_currency_api.no_rate THEN
2085: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2086: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2087: fnd_msg_pub.add;
2088: END IF;

Line 2091: WHEN gl_currency_api.invalid_currency THEN

2087: fnd_msg_pub.add;
2088: END IF;
2089:
2090: x_return_status := fnd_api.g_ret_sts_error;
2091: WHEN gl_currency_api.invalid_currency THEN
2092: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2093: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2094: fnd_msg_pub.add;
2095: END IF;

Line 2294: gl_currency_api.convert_closest_amount(

2290: END IF;
2291:
2292: CLOSE c_get_gl_info;
2293: -- Call the proper GL API to convert the amount.
2294: gl_currency_api.convert_closest_amount(
2295: x_from_currency => p_tc_currency_code
2296: ,x_to_currency => x_fc_currency_code
2297: ,x_conversion_date => p_conv_date
2298: ,x_conversion_type => l_conversion_type

Line 2313: WHEN gl_currency_api.no_rate THEN

2309:
2310: EXCEPTION
2311: WHEN fnd_api.g_exc_error THEN
2312: x_return_status := fnd_api.g_ret_sts_error;
2313: WHEN gl_currency_api.no_rate THEN
2314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2315: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2316: fnd_msg_pub.add;
2317: END IF;

Line 2320: WHEN gl_currency_api.invalid_currency THEN

2316: fnd_msg_pub.add;
2317: END IF;
2318:
2319: x_return_status := fnd_api.g_ret_sts_error;
2320: WHEN gl_currency_api.invalid_currency THEN
2321: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2322: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2323: fnd_msg_pub.add;
2324: END IF;

Line 2626: gl_currency_api.convert_closest_amount(

2622: FETCH c_get_gl_info INTO x_fc_currency_code;
2623: CLOSE c_get_gl_info;
2624:
2625: -- Call the proper GL API to convert the amount.
2626: gl_currency_api.convert_closest_amount(
2627: x_from_currency => p_tc_currency_code
2628: ,x_to_currency => x_fc_currency_code
2629: ,x_conversion_date => l_conv_date
2630: ,x_conversion_type => l_conversion_type

Line 2644: WHEN gl_currency_api.no_rate THEN

2640:
2641: EXCEPTION
2642: WHEN fnd_api.g_exc_error THEN
2643: x_return_status := fnd_api.g_ret_sts_error;
2644: WHEN gl_currency_api.no_rate THEN
2645: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2646: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2647: fnd_msg_pub.add;
2648: END IF;

Line 2651: WHEN gl_currency_api.invalid_currency THEN

2647: fnd_msg_pub.add;
2648: END IF;
2649:
2650: x_return_status := fnd_api.g_ret_sts_error;
2651: WHEN gl_currency_api.invalid_currency THEN
2652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2653: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2654: fnd_msg_pub.add;
2655: END IF;

Line 2738: gl_currency_api.convert_closest_amount(

2734: l_conv_date := p_conv_date;
2735: END IF;
2736:
2737: -- Call the proper GL API to convert the amount.
2738: gl_currency_api.convert_closest_amount(
2739: x_from_currency => p_from_currency
2740: ,x_to_currency => p_to_currency
2741: ,x_conversion_date => l_conv_date
2742: ,x_conversion_type => l_conversion_type

Line 2753: WHEN gl_currency_api.no_rate THEN

2749: ,x_rate => x_rate);
2750: --
2751:
2752: EXCEPTION
2753: WHEN gl_currency_api.no_rate THEN
2754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2755: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2756: fnd_msg_pub.add;
2757: END IF;

Line 2760: WHEN gl_currency_api.invalid_currency THEN

2756: fnd_msg_pub.add;
2757: END IF;
2758:
2759: x_return_status := fnd_api.g_ret_sts_error;
2760: WHEN gl_currency_api.invalid_currency THEN
2761: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2762: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2763: fnd_msg_pub.add;
2764: END IF;

Line 4353: l_conv_amt := gl_currency_api.convert_closest_amount_sql(

4349: ELSE
4350: l_conv_date := p_conv_date;
4351: END IF;
4352:
4353: l_conv_amt := gl_currency_api.convert_closest_amount_sql(
4354: x_from_currency => p_from_currency
4355: ,x_to_currency => p_to_currency
4356: ,x_conversion_date => l_conv_date
4357: ,x_conversion_type => l_conversion_type