983: -- Initialize return status.
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
985:
986: -- Get the currency conversion type from profile option
987: l_conversion_type := FND_PROFILE.Value (L_CONVERSION_TYPE_PROFILE);
988:
989: --bug 8532055
990: IF p_conv_date = FND_API.G_MISS_DATE OR p_conv_date IS NULL THEN
991: l_conv_date := SYSDATE;
1098:
1099: BEGIN
1100: -- Initialize API return status to success
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102: l_sys_time_id := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');
1103: OPEN c_get_name(l_sys_time_id);
1104: FETCH c_get_name into l_sys_name;
1105: IF (c_get_name%NOTFOUND) THEN
1106: CLOSE c_get_name;
1145:
1146: BEGIN
1147: -- Initialize API return status to success
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;
1149: l_user_time_id := FND_PROFILE.VALUE('CLIENT_TIMEZONE_ID');
1150: OPEN get_name(l_user_time_id);
1151: FETCH get_name into l_user_time_name;
1152: IF (get_name%NOTFOUND) THEN
1153: CLOSE get_name;
2223: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
2224: -- Mumu Pande 09/20/2000 Updated the following
2225: -- Get the currency conversion type from profile option
2226: IF x_exchange_rate_type IS NULL THEN
2227: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2228: ELSE
2229: l_conversion_type := x_exchange_rate_type;
2230: END IF;
2231:
2581: -- Initialize return status.
2582: x_return_status := fnd_api.g_ret_sts_success;
2583:
2584: IF x_exchange_rate_type IS NULL OR x_exchange_rate_type=FND_API.G_MISS_CHAR THEN
2585: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2586: ELSE
2587: l_conversion_type := x_exchange_rate_type;
2588: END IF;
2589:
2712:
2713: -- condition added to pass conversion types
2714: IF p_conv_type = FND_API.G_MISS_CHAR OR p_conv_type IS NULL THEN --Added for bug 7030415
2715: -- Get the currency conversion type from profile option
2716: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2717: -- Conversion type cannot be null in profile
2718: IF l_conversion_type IS NULL THEN
2719: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2720: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
4336:
4337: -- condition added to pass conversion types
4338: IF p_conv_type = FND_API.G_MISS_CHAR OR p_conv_type IS NULL THEN --Added for bug 7030415
4339: -- Get the currency conversion type from profile option
4340: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
4341: -- Conversion type cannot be null in profile
4342: ELSE
4343: l_conversion_type := p_conv_type;
4344: END IF;