eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_GNR_UTIL_PKG dependencies on HZ_LOCATIONS

Line 410: HZ_POPULATE_BOT_PKG.pop_hz_locations(

406: END IF;
407:
408: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
409: -- populate function for integration service
410: HZ_POPULATE_BOT_PKG.pop_hz_locations(
411: p_operation => 'U',
412: p_location_id => p_new_location_rec.location_id );
413: END IF;
414:

Line 717: * x_hzl rec type for hz_locations

713: *
714: * x_cntry country code
715: * x_addrstyle address style
716: * x_hrla rec type for hr_locations_all
717: * x_hzl rec type for hz_locations
718: * x_po rec type for po_vendor_sites_all
719: *
720: * exceptions raised
721: *

Line 887: l_sql_2 := 'select country, address_style from hz_locations where location_id = :id and rownum =1 ';

883: -- three sql statements are necessary depending for three location tables.
884: -- the three tables are:
885: --
886: l_sql_3 := 'select country, style from hr_locations_all where location_id = :id and rownum = 1 ';
887: l_sql_2 := 'select country, address_style from hz_locations where location_id = :id and rownum =1 ';
888: -- l_sql_1 := 'select country, address_style from po_vendor_sites_all where vendor_site_id = :id and rownum =1 ';
889:
890: l_sql_4 := 'select 1 from fnd_territories f where f.territory_code = :code';
891:

Line 901: IF p_loctbl = 'HZ_LOCATIONS' THEN

897: -- p_prefix =>l_debug_prefix,
898: -- p_msg_level=>fnd_log.level_statement);
899: -- END IF;
900: -- execute IMMEDIATE l_sql_1 INTO x_cntry, x_addrstyle USING IN p_locid;
901: IF p_loctbl = 'HZ_LOCATIONS' THEN
902: -- Debug info.
903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
904: hz_utility_v2pub.debug(p_message=>'***sql for hz_locations'||l_sql_2,
905: p_prefix =>l_debug_prefix,

Line 904: hz_utility_v2pub.debug(p_message=>'***sql for hz_locations'||l_sql_2,

900: -- execute IMMEDIATE l_sql_1 INTO x_cntry, x_addrstyle USING IN p_locid;
901: IF p_loctbl = 'HZ_LOCATIONS' THEN
902: -- Debug info.
903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
904: hz_utility_v2pub.debug(p_message=>'***sql for hz_locations'||l_sql_2,
905: p_prefix =>l_debug_prefix,
906: p_msg_level=>fnd_log.level_statement);
907: END IF;
908: execute IMMEDIATE l_sql_2 INTO x_cntry, x_addrstyle USING IN p_locid;

Line 2261: FROM HZ_LOCATIONS

2257: l_loc_components_rec.attribute7,l_loc_components_rec.attribute8,
2258: l_loc_components_rec.attribute9,l_loc_components_rec.attribute10,
2259: l_wh_update_date, l_address1, l_address2, l_address3, l_address4
2260: , l_actual_content_source, l_time_zone_id, l_address_key
2261: FROM HZ_LOCATIONS
2262: WHERE LOCATION_ID = p_location_id
2263: FOR UPDATE OF LOCATION_ID NOWAIT;
2264: EXCEPTION
2265: WHEN NO_DATA_FOUND THEN

Line 2267: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');

2263: FOR UPDATE OF LOCATION_ID NOWAIT;
2264: EXCEPTION
2265: WHEN NO_DATA_FOUND THEN
2266: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2267: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
2268: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
2269: FND_MSG_PUB.ADD;
2270: x_status := FND_API.G_RET_STS_ERROR;
2271: END; -- end of SELECT

Line 2291: FROM HZ_LOCATIONS

2287: l_loc_components_rec.attribute7,l_loc_components_rec.attribute8,
2288: l_loc_components_rec.attribute9,l_loc_components_rec.attribute10,
2289: l_wh_update_date, l_address1, l_address2, l_address3, l_address4
2290: , l_actual_content_source, l_time_zone_id, l_address_key
2291: FROM HZ_LOCATIONS
2292: WHERE LOCATION_ID = p_location_id;
2293: EXCEPTION
2294: WHEN NO_DATA_FOUND THEN
2295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

Line 2296: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');

2292: WHERE LOCATION_ID = p_location_id;
2293: EXCEPTION
2294: WHEN NO_DATA_FOUND THEN
2295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2296: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
2297: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
2298: FND_MSG_PUB.ADD;
2299: x_status := FND_API.G_RET_STS_ERROR;
2300: END; -- end of SELECT ;

Line 2325: -- location rec as part of GNR creation, just because fetched value from hz_locations is in different case

2321:
2322: putLocCompValues(p_map_dtls_tbl,l_loc_components_rec);
2323:
2324: -- Fix for Bug 5231893. Added UPPER to make case insensitive comaprison. It does not make sense to update
2325: -- location rec as part of GNR creation, just because fetched value from hz_locations is in different case
2326: -- than that derived from HZ_GEOGRAPHIES. It also improves performance by not updating that location rec
2327: -- and doing subsequent processes related to update_location. (18-MAY-2006 Nishant)
2328: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)

Line 2430: UPDATE HZ_LOCATIONS

2426: exception when others then
2427: null;
2428: end;
2429:
2430: UPDATE HZ_LOCATIONS
2431: SET
2432: COUNTRY = l_loc_components_rec.country,
2433: CITY = l_loc_components_rec.city ,
2434: STATE = l_loc_components_rec.state ,

Line 2607: P_loc_table => 'HZ_LOCATIONS',

2603: BEGIN
2604: l_return := 'N';
2605: l_map_dtls_tbl := p_map_dtls_tbl; -- This will populate all the derived Geography IDs
2606: getLocCompValues(
2607: P_loc_table => 'HZ_LOCATIONS',
2608: p_loc_components_rec => p_loc_components_rec,
2609: x_map_dtls_tbl => l_map_dtls_tbl,
2610: x_status => l_status);
2611:

Line 2964: (p_location_table_name = 'HZ_LOCATIONS'

2960:
2961: -- Update Location not to be done for GNR calls, only for Online Validate API
2962: IF ((NVL(l_api_purpose,'xxya') NOT IN ('R12UPGRADE','GNR'))
2963: AND
2964: (p_location_table_name = 'HZ_LOCATIONS'
2965: AND
2966: update_loc_yn(p_loc_components_rec,l_map_dtls_tbl) = 'Y')) THEN
2967:
2968: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN