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_LOCATION_V2PUB dependencies on HZ_LOCATIONS

Line 153: FROM hz_locations hl

149: -- ACNG add call to location profile: END
150:
151: CURSOR val IS
152: SELECT 'Y'
153: FROM hz_locations hl
154: WHERE hl.location_id = p_location_rec.location_id;
155: BEGIN
156: -- Debug info.
157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 217: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (+)',

213: p_location_rec.address_key := l_key;
214:
215: -- Debug info.
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (+)',
218: p_prefix=>l_debug_prefix,
219: p_msg_level=>fnd_log.level_procedure);
220: END IF;
221:

Line 265: hz_locations_pkg.insert_row (

261: end if;
262:
263:
264: -- call table-handler to insert the record
265: hz_locations_pkg.insert_row (
266: x_location_id => p_location_rec.location_id,
267: x_attribute_category => p_location_rec.attribute_category,
268: x_attribute1 => p_location_rec.attribute1,
269: x_attribute2 => p_location_rec.attribute2,

Line 374: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (-) ' ||

370: -- ACNG add call to location profile: END
371:
372: -- Debug info.
373: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
374: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (-) ' ||
375: 'x_location_id = ' || p_location_rec.location_id,
376: p_prefix=>l_debug_prefix,
377: p_msg_level=>fnd_log.level_procedure);
378: -- ACNG add call to location profile: BEGIN

Line 395: l_orig_sys_reference_rec.owner_table_name := 'HZ_LOCATIONS';

391: and p_location_rec.orig_system <>fnd_api.g_miss_char
392: then
393: l_orig_sys_reference_rec.orig_system := p_location_rec.orig_system;
394: l_orig_sys_reference_rec.orig_system_reference := p_location_rec.orig_system_reference;
395: l_orig_sys_reference_rec.owner_table_name := 'HZ_LOCATIONS';
396: l_orig_sys_reference_rec.owner_table_id := p_location_rec.location_id;
397: l_orig_sys_reference_rec.created_by_module := p_location_rec.created_by_module;
398:
399: hz_orig_system_ref_pub.create_orig_system_reference(

Line 427: l_geometry hz_locations.geometry%TYPE := hz_geometry_default;

423: ) IS
424:
425: l_object_version_number NUMBER;
426: l_rowid ROWID;
427: l_geometry hz_locations.geometry%TYPE := hz_geometry_default;
428: l_key VARCHAR2(2000);
429: l_debug_prefix VARCHAR2(30) := '';
430: db_city hz_locations.city%TYPE;
431: db_state hz_locations.state%TYPE;

Line 430: db_city hz_locations.city%TYPE;

426: l_rowid ROWID;
427: l_geometry hz_locations.geometry%TYPE := hz_geometry_default;
428: l_key VARCHAR2(2000);
429: l_debug_prefix VARCHAR2(30) := '';
430: db_city hz_locations.city%TYPE;
431: db_state hz_locations.state%TYPE;
432: db_country hz_locations.country%TYPE;
433: db_county hz_locations.county%TYPE;
434: db_province hz_locations.province%TYPE;

Line 431: db_state hz_locations.state%TYPE;

427: l_geometry hz_locations.geometry%TYPE := hz_geometry_default;
428: l_key VARCHAR2(2000);
429: l_debug_prefix VARCHAR2(30) := '';
430: db_city hz_locations.city%TYPE;
431: db_state hz_locations.state%TYPE;
432: db_country hz_locations.country%TYPE;
433: db_county hz_locations.county%TYPE;
434: db_province hz_locations.province%TYPE;
435: db_postal_code hz_locations.postal_code%TYPE;

Line 432: db_country hz_locations.country%TYPE;

428: l_key VARCHAR2(2000);
429: l_debug_prefix VARCHAR2(30) := '';
430: db_city hz_locations.city%TYPE;
431: db_state hz_locations.state%TYPE;
432: db_country hz_locations.country%TYPE;
433: db_county hz_locations.county%TYPE;
434: db_province hz_locations.province%TYPE;
435: db_postal_code hz_locations.postal_code%TYPE;
436: db_address1 hz_locations.address1%TYPE;

Line 433: db_county hz_locations.county%TYPE;

429: l_debug_prefix VARCHAR2(30) := '';
430: db_city hz_locations.city%TYPE;
431: db_state hz_locations.state%TYPE;
432: db_country hz_locations.country%TYPE;
433: db_county hz_locations.county%TYPE;
434: db_province hz_locations.province%TYPE;
435: db_postal_code hz_locations.postal_code%TYPE;
436: db_address1 hz_locations.address1%TYPE;
437: db_address2 hz_locations.address2%TYPE;

Line 434: db_province hz_locations.province%TYPE;

430: db_city hz_locations.city%TYPE;
431: db_state hz_locations.state%TYPE;
432: db_country hz_locations.country%TYPE;
433: db_county hz_locations.county%TYPE;
434: db_province hz_locations.province%TYPE;
435: db_postal_code hz_locations.postal_code%TYPE;
436: db_address1 hz_locations.address1%TYPE;
437: db_address2 hz_locations.address2%TYPE;
438: db_address3 hz_locations.address3%TYPE;

Line 435: db_postal_code hz_locations.postal_code%TYPE;

431: db_state hz_locations.state%TYPE;
432: db_country hz_locations.country%TYPE;
433: db_county hz_locations.county%TYPE;
434: db_province hz_locations.province%TYPE;
435: db_postal_code hz_locations.postal_code%TYPE;
436: db_address1 hz_locations.address1%TYPE;
437: db_address2 hz_locations.address2%TYPE;
438: db_address3 hz_locations.address3%TYPE;
439: db_address4 hz_locations.address4%TYPE;

Line 436: db_address1 hz_locations.address1%TYPE;

432: db_country hz_locations.country%TYPE;
433: db_county hz_locations.county%TYPE;
434: db_province hz_locations.province%TYPE;
435: db_postal_code hz_locations.postal_code%TYPE;
436: db_address1 hz_locations.address1%TYPE;
437: db_address2 hz_locations.address2%TYPE;
438: db_address3 hz_locations.address3%TYPE;
439: db_address4 hz_locations.address4%TYPE;
440: db_content_source_type hz_locations.content_source_type%TYPE;

Line 437: db_address2 hz_locations.address2%TYPE;

433: db_county hz_locations.county%TYPE;
434: db_province hz_locations.province%TYPE;
435: db_postal_code hz_locations.postal_code%TYPE;
436: db_address1 hz_locations.address1%TYPE;
437: db_address2 hz_locations.address2%TYPE;
438: db_address3 hz_locations.address3%TYPE;
439: db_address4 hz_locations.address4%TYPE;
440: db_content_source_type hz_locations.content_source_type%TYPE;
441:

Line 438: db_address3 hz_locations.address3%TYPE;

434: db_province hz_locations.province%TYPE;
435: db_postal_code hz_locations.postal_code%TYPE;
436: db_address1 hz_locations.address1%TYPE;
437: db_address2 hz_locations.address2%TYPE;
438: db_address3 hz_locations.address3%TYPE;
439: db_address4 hz_locations.address4%TYPE;
440: db_content_source_type hz_locations.content_source_type%TYPE;
441:
442: -- ACNG add call to location profile: BEGIN

Line 439: db_address4 hz_locations.address4%TYPE;

435: db_postal_code hz_locations.postal_code%TYPE;
436: db_address1 hz_locations.address1%TYPE;
437: db_address2 hz_locations.address2%TYPE;
438: db_address3 hz_locations.address3%TYPE;
439: db_address4 hz_locations.address4%TYPE;
440: db_content_source_type hz_locations.content_source_type%TYPE;
441:
442: -- ACNG add call to location profile: BEGIN
443: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;

Line 440: db_content_source_type hz_locations.content_source_type%TYPE;

436: db_address1 hz_locations.address1%TYPE;
437: db_address2 hz_locations.address2%TYPE;
438: db_address3 hz_locations.address3%TYPE;
439: db_address4 hz_locations.address4%TYPE;
440: db_content_source_type hz_locations.content_source_type%TYPE;
441:
442: -- ACNG add call to location profile: BEGIN
443: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;
444: l_profile_content_source VARCHAR2(30);

Line 457: l_acs hz_locations.actual_content_source%TYPE;

453:
454: -- Bug 2983977
455: l_loc_id NUMBER;
456: -- Bug 4693719 : Added for local assignment
457: l_acs hz_locations.actual_content_source%TYPE;
458: db_actual_content_source hz_locations.actual_content_source%TYPE;
459:
460:
461: BEGIN

Line 458: db_actual_content_source hz_locations.actual_content_source%TYPE;

454: -- Bug 2983977
455: l_loc_id NUMBER;
456: -- Bug 4693719 : Added for local assignment
457: l_acs hz_locations.actual_content_source%TYPE;
458: db_actual_content_source hz_locations.actual_content_source%TYPE;
459:
460:
461: BEGIN
462: -- Debug info.

Line 480: p_owner_table_name => 'HZ_LOCATIONS',

476: and (p_location_rec.location_id = FND_API.G_MISS_NUM or p_location_rec.location_id is null) THEN
477: hz_orig_system_ref_pub.get_owner_table_id
478: (p_orig_system => p_location_rec.orig_system,
479: p_orig_system_reference => p_location_rec.orig_system_reference,
480: p_owner_table_name => 'HZ_LOCATIONS',
481: x_owner_table_id => p_location_rec.location_id,
482: x_return_status => x_return_status);
483: IF x_return_status <> fnd_api.g_ret_sts_success THEN
484: RAISE FND_API.G_EXC_ERROR;

Line 530: FROM hz_locations hl

526: l_profile_content_source,
527: db_actual_content_source,
528: l_date_validated,
529: l_validation_status_code
530: FROM hz_locations hl
531: WHERE hl.location_id = p_location_rec.location_id
532: FOR UPDATE OF hl.location_id NOWAIT;
533:
534: IF NOT ((p_object_version_number IS NULL

Line 541: fnd_message.set_token('TABLE', 'hz_locations');

537: l_object_version_number IS NOT NULL AND
538: p_object_version_number = l_object_version_number))
539: THEN
540: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
541: fnd_message.set_token('TABLE', 'hz_locations');
542: fnd_msg_pub.add;
543: RAISE fnd_api.g_exc_error;
544: END IF;
545:

Line 629: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Update_Row (+) ',

625: p_location_rec.geometry := l_geometry;
626:
627: -- Debug info.
628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
629: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Update_Row (+) ',
630: p_prefix=>l_debug_prefix,
631: p_msg_level=>fnd_log.level_procedure);
632: END IF;
633:

Line 642: hz_locations_pkg.update_row (

638: l_acs := NULL;
639: END IF;
640:
641: -- call to table-handler to update the record
642: hz_locations_pkg.update_row (
643: x_rowid => l_rowid,
644: x_location_id => p_location_rec.location_id,
645: x_attribute_category => p_location_rec.attribute_category,
646: x_attribute1 => p_location_rec.attribute1,

Line 745: -- Bug 4693719 : Keep ACS in sync with hz_locations

741: THEN
742:
743: l_location_profile_rec.location_profile_id := NULL;
744: l_location_profile_rec.location_id := p_location_rec.location_id;
745: -- Bug 4693719 : Keep ACS in sync with hz_locations
746: l_location_profile_rec.actual_content_source := nvl(l_acs, l_profile_content_source);
747: l_location_profile_rec.effective_start_date := NULL;
748: l_location_profile_rec.effective_end_date := NULL;
749: l_location_profile_rec.date_validated := NULL;

Line 807: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row (-) ',

803: -- ACNG add call to location profile: END
804:
805: -- Debug info.
806: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
807: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row (-) ',
808: p_prefix=>l_debug_prefix,
809: p_msg_level=>fnd_log.level_procedure);
810: END IF;
811:

Line 1095: p_entity_name => 'HZ_LOCATIONS',

1091: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1092:
1093: -- IF g_loc_mixnmatch_enabled IS NULL THEN
1094: HZ_MIXNM_UTILITY.LoadDataSources(
1095: p_entity_name => 'HZ_LOCATIONS',
1096: p_entity_attr_id => g_loc_entity_attr_id,
1097: p_mixnmatch_enabled => g_loc_mixnmatch_enabled,
1098: p_selected_datasources => g_loc_selected_datasources );
1099: -- END IF;

Line 1103: p_entity_name => 'HZ_LOCATIONS',

1099: -- END IF;
1100: */
1101:
1102: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
1103: p_entity_name => 'HZ_LOCATIONS',
1104: p_entity_attr_id => g_loc_entity_attr_id,
1105: p_mixnmatch_enabled => g_loc_mixnmatch_enabled,
1106: p_selected_datasources => g_loc_selected_datasources,
1107: p_content_source_type => l_location_rec.content_source_type,

Line 1158: -- THE HZ_LOCATIONS ENTITY WAS INADVERTENTLY MISSED DURING THE CODING PHASE OF

1154: -- Bug 3711629: remove the dss check in create location API.
1155: /*
1156: -- Bug 3594731: fix the bug 3517181 in the main code line.
1157: -- IN A NUTSHELL THE DSS CHECK THAT IS NEEDED IN THE LOCATION API, FOR SECURING
1158: -- THE HZ_LOCATIONS ENTITY WAS INADVERTENTLY MISSED DURING THE CODING PHASE OF
1159: -- THE DSS PROJECT
1160:
1161: l_test_security :=
1162: hz_dss_util_pub.test_instance(

Line 1164: p_db_object_name => 'HZ_LOCATIONS',

1160:
1161: l_test_security :=
1162: hz_dss_util_pub.test_instance(
1163: p_operation_code => 'INSERT',
1164: p_db_object_name => 'HZ_LOCATIONS',
1165: p_instance_pk1_value => x_location_id,
1166: p_user_name => fnd_global.user_name,
1167: x_return_status => dss_return_status,
1168: x_msg_count => dss_msg_count,

Line 1179: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','HZ_LOCATIONS');

1175: IF (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) THEN
1176: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_SECURITY_FAIL');
1177: FND_MESSAGE.SET_TOKEN('USER_NAME',fnd_global.user_name);
1178: FND_MESSAGE.SET_TOKEN('OPER_NAME','INSERT');
1179: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','HZ_LOCATIONS');
1180: FND_MSG_PUB.ADD;
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183: */

Line 1202: HZ_POPULATE_BOT_PKG.pop_hz_locations(

1198: END IF;
1199:
1200: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1201: -- populate function for integration service
1202: HZ_POPULATE_BOT_PKG.pop_hz_locations(
1203: p_operation => 'I',
1204: p_location_id => x_location_id );
1205: END IF;
1206: END IF;

Line 1488: p_owner_table_name => 'HZ_LOCATIONS',

1484: and (p_location_rec.location_id = FND_API.G_MISS_NUM or p_location_rec.location_id is null) THEN
1485: hz_orig_system_ref_pub.get_owner_table_id
1486: (p_orig_system => p_location_rec.orig_system,
1487: p_orig_system_reference => p_location_rec.orig_system_reference,
1488: p_owner_table_name => 'HZ_LOCATIONS',
1489: x_owner_table_id => l_location_rec.location_id,
1490: x_return_status => x_return_status);
1491: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1492: RAISE FND_API.G_EXC_ERROR;

Line 1503: -- THE HZ_LOCATIONS ENTITY WAS INADVERTENTLY MISSED DURING THE CODING PHASE OF

1499: -- Bug 3818648: check dss profile before call test_instance.
1500: --
1501: -- Bug 3594731: fix the bug 3517181 in the main code line.
1502: -- IN A NUTSHELL THE DSS CHECK THAT IS NEEDED IN THE LOCATION API, FOR SECURING
1503: -- THE HZ_LOCATIONS ENTITY WAS INADVERTENTLY MISSED DURING THE CODING PHASE OF
1504: -- THE DSS PROJECT
1505:
1506: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
1507:

Line 1521: p_db_object_name => 'HZ_LOCATIONS',

1517: IF l_standalone_location = 'N' THEN
1518: l_test_security :=
1519: hz_dss_util_pub.test_instance(
1520: p_operation_code => 'UPDATE',
1521: p_db_object_name => 'HZ_LOCATIONS',
1522: p_instance_pk1_value => l_location_rec.location_id,
1523: p_user_name => fnd_global.user_name,
1524: x_return_status => dss_return_status,
1525: x_msg_count => dss_msg_count,

Line 1572: p_entity_name => 'HZ_LOCATIONS',

1568: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1569: * There is no need to check if the data-source is selected.
1570:
1571: HZ_MIXNM_UTILITY.LoadDataSources(
1572: p_entity_name => 'HZ_LOCATIONS',
1573: p_entity_attr_id => g_loc_entity_attr_id,
1574: p_mixnmatch_enabled => g_loc_mixnmatch_enabled,
1575: p_selected_datasources => g_loc_selected_datasources );
1576: */

Line 1717: HZ_POPULATE_BOT_PKG.pop_hz_locations(

1713: END IF;
1714:
1715: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1716: -- populate function for integration service
1717: HZ_POPULATE_BOT_PKG.pop_hz_locations(
1718: p_operation => 'U',
1719: p_location_id => l_location_rec.location_id );
1720: END IF;
1721: END IF;

Line 1909: * hz_locations_PKG.Select_Row

1905: * DESCRIPTION
1906: * Gets location record.
1907: *
1908: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1909: * hz_locations_PKG.Select_Row
1910: *
1911: * ARGUMENTS
1912: * IN:
1913: * p_init_msg_list Initialize message stack if it is set to

Line 1979: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Select_Row (+)',

1975: x_location_rec.location_id := p_location_id;
1976:
1977: -- Debug info.
1978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1979: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Select_Row (+)',
1980: p_prefix=>l_debug_prefix,
1981: p_msg_level=>fnd_log.level_procedure);
1982: END IF;
1983:

Line 1984: hz_locations_pkg.select_row (

1980: p_prefix=>l_debug_prefix,
1981: p_msg_level=>fnd_log.level_procedure);
1982: END IF;
1983:
1984: hz_locations_pkg.select_row (
1985: x_location_id => x_location_rec.location_id,
1986: x_attribute_category => x_location_rec.attribute_category,
1987: x_attribute1 => x_location_rec.attribute1,
1988: x_attribute2 => x_location_rec.attribute2,

Line 2055: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.select_row (-)',

2051: );
2052:
2053: -- Debug info.
2054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2055: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.select_row (-)',
2056: p_prefix=>l_debug_prefix,
2057: p_msg_level=>fnd_log.level_procedure);
2058: END IF;
2059:

Line 2167: * Concurrent program to fill geometry column in hz_locations.

2163: /**
2164: * PROCEDURE fill_geometry_for_locations
2165: *
2166: * DESCRIPTION
2167: * Concurrent program to fill geometry column in hz_locations.
2168: *
2169: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2170: *
2171: * ARGUMENTS

Line 2201: FROM hz_locations

2197: STREET,
2198: STREET_SUFFIX,
2199: STREET_NUMBER,
2200: HOUSE_NUMBER
2201: FROM hz_locations
2202: WHERE GEOMETRY IS NULL OR
2203: GEOMETRY = hz_geometry_default
2204: FOR UPDATE OF GEOMETRY;
2205:

Line 2227: UPDATE hz_locations SET GEOMETRY = l_loc_rec.geometry

2223:
2224: IF (l_status = 'E') THEN
2225: EXIT;
2226: ELSIF (l_status = 'Y') THEN
2227: UPDATE hz_locations SET GEOMETRY = l_loc_rec.geometry
2228: WHERE CURRENT OF c_locations;
2229: l_count := l_count + 1;
2230: END IF;
2231: END LOOP;

Line 2271: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,

2267: )
2268: IS
2269: Cursor c_locations(p_location_id NUMBER) IS
2270: SELECT ac.CUST_ACCT_SITE_ID
2271: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,
2272: HZ_CUST_ACCT_SITES_ALL ac
2273: WHERE loc.LOCATION_ID=p_location_id
2274: AND loc.LOCATION_ID = ps.LOCATION_ID
2275: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;