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 2266: FROM HZ_LOCATIONS

2262: l_loc_components_rec.attribute7,l_loc_components_rec.attribute8,
2263: l_loc_components_rec.attribute9,l_loc_components_rec.attribute10,
2264: l_wh_update_date, l_address1, l_address2, l_address3, l_address4
2265: , l_actual_content_source, l_time_zone_id, l_address_key
2266: FROM HZ_LOCATIONS
2267: WHERE LOCATION_ID = p_location_id
2268: FOR UPDATE OF LOCATION_ID NOWAIT;
2269: EXCEPTION
2270: WHEN NO_DATA_FOUND THEN

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

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

Line 2296: FROM HZ_LOCATIONS

2292: l_loc_components_rec.attribute7,l_loc_components_rec.attribute8,
2293: l_loc_components_rec.attribute9,l_loc_components_rec.attribute10,
2294: l_wh_update_date, l_address1, l_address2, l_address3, l_address4
2295: , l_actual_content_source, l_time_zone_id, l_address_key
2296: FROM HZ_LOCATIONS
2297: WHERE LOCATION_ID = p_location_id;
2298: EXCEPTION
2299: WHEN NO_DATA_FOUND THEN
2300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

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

2297: WHERE LOCATION_ID = p_location_id;
2298: EXCEPTION
2299: WHEN NO_DATA_FOUND THEN
2300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2301: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
2302: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
2303: FND_MSG_PUB.ADD;
2304: x_status := FND_API.G_RET_STS_ERROR;
2305: END; -- end of SELECT ;

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

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

Line 2435: UPDATE HZ_LOCATIONS

2431: exception when others then
2432: null;
2433: end;
2434:
2435: UPDATE HZ_LOCATIONS
2436: SET
2437: COUNTRY = l_loc_components_rec.country,
2438: CITY = l_loc_components_rec.city ,
2439: STATE = l_loc_components_rec.state ,

Line 2612: P_loc_table => 'HZ_LOCATIONS',

2608: BEGIN
2609: l_return := 'N';
2610: l_map_dtls_tbl := p_map_dtls_tbl; -- This will populate all the derived Geography IDs
2611: getLocCompValues(
2612: P_loc_table => 'HZ_LOCATIONS',
2613: p_loc_components_rec => p_loc_components_rec,
2614: x_map_dtls_tbl => l_map_dtls_tbl,
2615: x_status => l_status);
2616:

Line 2969: (p_location_table_name = 'HZ_LOCATIONS'

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