238: if p_location_rec.timezone_id is null or
239: p_location_rec.timezone_id = fnd_api.g_miss_num
240: then
241: l_message_count := fnd_msg_pub.count_msg();
242: hz_timezone_pub.get_timezone_id(
243: p_api_version => 1.0,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_postal_code => p_location_rec.postal_code,
246: p_city => p_location_rec.city,
1615: --Bug#8616119
1616: --When Timezone Id not found then we don't raise error
1617: --While removing messages for loop index is not crrect
1618: --Corrected the Index
1619: -- Bug13444575 - hz_timezone_pub.get_timezone_id will be called when
1620: -- address changed OR timezone_id is null or g_miss_num
1621: if l_changed_flag = 'Y' or (p_location_rec.timezone_id is null or p_location_rec.timezone_id = fnd_api.g_miss_num)
1622: then
1623: if p_location_rec.country IS NULL
1636: then
1637: l_location_rec.state := l_old_location_rec.state;
1638: end if;
1639: l_message_count := fnd_msg_pub.count_msg();
1640: hz_timezone_pub.get_timezone_id(
1641: p_api_version => 1.0,
1642: p_init_msg_list => FND_API.G_FALSE,
1643: p_postal_code => l_location_rec.postal_code,
1644: p_city => l_location_rec.city,