[Home] [Help]
928: -- Initialize return status.
929: x_return_status := FND_API.G_RET_STS_SUCCESS;
930:
931: -- Get the currency conversion type from profile option
932: l_conversion_type := FND_PROFILE.Value (L_CONVERSION_TYPE_PROFILE);
933:
934: -- Call the proper GL API to convert the amount.
935: GL_Currency_API.Convert_Closest_Amount (
936: x_from_currency => p_from_currency,
1037:
1038: BEGIN
1039: -- Initialize API return status to success
1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041: l_sys_time_id := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');
1042: OPEN c_get_name(l_sys_time_id);
1043: FETCH c_get_name into l_sys_name;
1044: IF (c_get_name%NOTFOUND) THEN
1045: CLOSE c_get_name;
1085:
1086: BEGIN
1087: -- Initialize API return status to success
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;
1089: l_user_time_id := FND_PROFILE.VALUE('CLIENT_TIMEZONE_ID');
1090: OPEN get_name(l_user_time_id);
1091: FETCH get_name into l_user_time_name;
1092: IF (get_name%NOTFOUND) THEN
1093: CLOSE get_name;
2151: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
2152: -- Mumu Pande 09/20/2000 Updated the following
2153: -- Get the currency conversion type from profile option
2154: IF x_exchange_rate_type IS NULL THEN
2155: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2156: ELSE
2157: l_conversion_type := x_exchange_rate_type;
2158: END IF;
2159:
2308:
2309: -- condition added to pass conversion types
2310: IF p_conv_type = FND_API.G_MISS_CHAR THEN
2311: -- Get the currency conversion type from profile option
2312: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2313: -- Conversion type cannot be null in profile
2314: IF l_conversion_type IS NULL THEN
2315: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2316: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');