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.

[Home] [Help]

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 278: hz_locations_pkg.insert_row (

274: end if;
275:
276:
277: -- call table-handler to insert the record
278: hz_locations_pkg.insert_row (
279: x_location_id => p_location_rec.location_id,
280: x_attribute_category => p_location_rec.attribute_category,
281: x_attribute1 => p_location_rec.attribute1,
282: x_attribute2 => p_location_rec.attribute2,

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

383: -- ACNG add call to location profile: END
384:
385: -- Debug info.
386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (-) ' ||
388: 'x_location_id = ' || p_location_rec.location_id,
389: p_prefix=>l_debug_prefix,
390: p_msg_level=>fnd_log.level_procedure);
391: -- ACNG add call to location profile: BEGIN

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

404: and p_location_rec.orig_system <>fnd_api.g_miss_char
405: then
406: l_orig_sys_reference_rec.orig_system := p_location_rec.orig_system;
407: l_orig_sys_reference_rec.orig_system_reference := p_location_rec.orig_system_reference;
408: l_orig_sys_reference_rec.owner_table_name := 'HZ_LOCATIONS';
409: l_orig_sys_reference_rec.owner_table_id := p_location_rec.location_id;
410: l_orig_sys_reference_rec.created_by_module := p_location_rec.created_by_module;
411:
412: hz_orig_system_ref_pub.create_orig_system_reference(

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

436: ) IS
437:
438: l_object_version_number NUMBER;
439: l_rowid ROWID;
440: l_geometry hz_locations.geometry%TYPE := hz_geometry_default;
441: l_key VARCHAR2(2000);
442: l_debug_prefix VARCHAR2(30) := '';
443: db_city hz_locations.city%TYPE;
444: db_state hz_locations.state%TYPE;

Line 443: db_city hz_locations.city%TYPE;

439: l_rowid ROWID;
440: l_geometry hz_locations.geometry%TYPE := hz_geometry_default;
441: l_key VARCHAR2(2000);
442: l_debug_prefix VARCHAR2(30) := '';
443: db_city hz_locations.city%TYPE;
444: db_state hz_locations.state%TYPE;
445: db_country hz_locations.country%TYPE;
446: db_county hz_locations.county%TYPE;
447: db_province hz_locations.province%TYPE;

Line 444: db_state hz_locations.state%TYPE;

440: l_geometry hz_locations.geometry%TYPE := hz_geometry_default;
441: l_key VARCHAR2(2000);
442: l_debug_prefix VARCHAR2(30) := '';
443: db_city hz_locations.city%TYPE;
444: db_state hz_locations.state%TYPE;
445: db_country hz_locations.country%TYPE;
446: db_county hz_locations.county%TYPE;
447: db_province hz_locations.province%TYPE;
448: db_postal_code hz_locations.postal_code%TYPE;

Line 445: db_country hz_locations.country%TYPE;

441: l_key VARCHAR2(2000);
442: l_debug_prefix VARCHAR2(30) := '';
443: db_city hz_locations.city%TYPE;
444: db_state hz_locations.state%TYPE;
445: db_country hz_locations.country%TYPE;
446: db_county hz_locations.county%TYPE;
447: db_province hz_locations.province%TYPE;
448: db_postal_code hz_locations.postal_code%TYPE;
449: db_address1 hz_locations.address1%TYPE;

Line 446: db_county hz_locations.county%TYPE;

442: l_debug_prefix VARCHAR2(30) := '';
443: db_city hz_locations.city%TYPE;
444: db_state hz_locations.state%TYPE;
445: db_country hz_locations.country%TYPE;
446: db_county hz_locations.county%TYPE;
447: db_province hz_locations.province%TYPE;
448: db_postal_code hz_locations.postal_code%TYPE;
449: db_address1 hz_locations.address1%TYPE;
450: db_address2 hz_locations.address2%TYPE;

Line 447: db_province hz_locations.province%TYPE;

443: db_city hz_locations.city%TYPE;
444: db_state hz_locations.state%TYPE;
445: db_country hz_locations.country%TYPE;
446: db_county hz_locations.county%TYPE;
447: db_province hz_locations.province%TYPE;
448: db_postal_code hz_locations.postal_code%TYPE;
449: db_address1 hz_locations.address1%TYPE;
450: db_address2 hz_locations.address2%TYPE;
451: db_address3 hz_locations.address3%TYPE;

Line 448: db_postal_code hz_locations.postal_code%TYPE;

444: db_state hz_locations.state%TYPE;
445: db_country hz_locations.country%TYPE;
446: db_county hz_locations.county%TYPE;
447: db_province hz_locations.province%TYPE;
448: db_postal_code hz_locations.postal_code%TYPE;
449: db_address1 hz_locations.address1%TYPE;
450: db_address2 hz_locations.address2%TYPE;
451: db_address3 hz_locations.address3%TYPE;
452: db_address4 hz_locations.address4%TYPE;

Line 449: db_address1 hz_locations.address1%TYPE;

445: db_country hz_locations.country%TYPE;
446: db_county hz_locations.county%TYPE;
447: db_province hz_locations.province%TYPE;
448: db_postal_code hz_locations.postal_code%TYPE;
449: db_address1 hz_locations.address1%TYPE;
450: db_address2 hz_locations.address2%TYPE;
451: db_address3 hz_locations.address3%TYPE;
452: db_address4 hz_locations.address4%TYPE;
453: db_content_source_type hz_locations.content_source_type%TYPE;

Line 450: db_address2 hz_locations.address2%TYPE;

446: db_county hz_locations.county%TYPE;
447: db_province hz_locations.province%TYPE;
448: db_postal_code hz_locations.postal_code%TYPE;
449: db_address1 hz_locations.address1%TYPE;
450: db_address2 hz_locations.address2%TYPE;
451: db_address3 hz_locations.address3%TYPE;
452: db_address4 hz_locations.address4%TYPE;
453: db_content_source_type hz_locations.content_source_type%TYPE;
454:

Line 451: db_address3 hz_locations.address3%TYPE;

447: db_province hz_locations.province%TYPE;
448: db_postal_code hz_locations.postal_code%TYPE;
449: db_address1 hz_locations.address1%TYPE;
450: db_address2 hz_locations.address2%TYPE;
451: db_address3 hz_locations.address3%TYPE;
452: db_address4 hz_locations.address4%TYPE;
453: db_content_source_type hz_locations.content_source_type%TYPE;
454:
455: -- ACNG add call to location profile: BEGIN

Line 452: db_address4 hz_locations.address4%TYPE;

448: db_postal_code hz_locations.postal_code%TYPE;
449: db_address1 hz_locations.address1%TYPE;
450: db_address2 hz_locations.address2%TYPE;
451: db_address3 hz_locations.address3%TYPE;
452: db_address4 hz_locations.address4%TYPE;
453: db_content_source_type hz_locations.content_source_type%TYPE;
454:
455: -- ACNG add call to location profile: BEGIN
456: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;

Line 453: db_content_source_type hz_locations.content_source_type%TYPE;

449: db_address1 hz_locations.address1%TYPE;
450: db_address2 hz_locations.address2%TYPE;
451: db_address3 hz_locations.address3%TYPE;
452: db_address4 hz_locations.address4%TYPE;
453: db_content_source_type hz_locations.content_source_type%TYPE;
454:
455: -- ACNG add call to location profile: BEGIN
456: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;
457: l_profile_content_source VARCHAR2(30);

Line 470: l_acs hz_locations.actual_content_source%TYPE;

466:
467: -- Bug 2983977
468: l_loc_id NUMBER;
469: -- Bug 4693719 : Added for local assignment
470: l_acs hz_locations.actual_content_source%TYPE;
471: db_actual_content_source hz_locations.actual_content_source%TYPE;
472:
473:
474: BEGIN

Line 471: db_actual_content_source hz_locations.actual_content_source%TYPE;

467: -- Bug 2983977
468: l_loc_id NUMBER;
469: -- Bug 4693719 : Added for local assignment
470: l_acs hz_locations.actual_content_source%TYPE;
471: db_actual_content_source hz_locations.actual_content_source%TYPE;
472:
473:
474: BEGIN
475: -- Debug info.

Line 493: p_owner_table_name => 'HZ_LOCATIONS',

489: and (p_location_rec.location_id = FND_API.G_MISS_NUM or p_location_rec.location_id is null) THEN
490: hz_orig_system_ref_pub.get_owner_table_id
491: (p_orig_system => p_location_rec.orig_system,
492: p_orig_system_reference => p_location_rec.orig_system_reference,
493: p_owner_table_name => 'HZ_LOCATIONS',
494: x_owner_table_id => p_location_rec.location_id,
495: x_return_status => x_return_status);
496: IF x_return_status <> fnd_api.g_ret_sts_success THEN
497: RAISE FND_API.G_EXC_ERROR;

Line 543: FROM hz_locations hl

539: l_profile_content_source,
540: db_actual_content_source,
541: l_date_validated,
542: l_validation_status_code
543: FROM hz_locations hl
544: WHERE hl.location_id = p_location_rec.location_id
545: FOR UPDATE OF hl.location_id NOWAIT;
546:
547: IF NOT ((p_object_version_number IS NULL

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

550: l_object_version_number IS NOT NULL AND
551: p_object_version_number = l_object_version_number))
552: THEN
553: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
554: fnd_message.set_token('TABLE', 'hz_locations');
555: fnd_msg_pub.add;
556: RAISE fnd_api.g_exc_error;
557: END IF;
558:

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

638: p_location_rec.geometry := l_geometry;
639:
640: -- Debug info.
641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Update_Row (+) ',
643: p_prefix=>l_debug_prefix,
644: p_msg_level=>fnd_log.level_procedure);
645: END IF;
646:

Line 655: hz_locations_pkg.update_row (

651: l_acs := NULL;
652: END IF;
653:
654: -- call to table-handler to update the record
655: hz_locations_pkg.update_row (
656: x_rowid => l_rowid,
657: x_location_id => p_location_rec.location_id,
658: x_attribute_category => p_location_rec.attribute_category,
659: x_attribute1 => p_location_rec.attribute1,

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

754: THEN
755:
756: l_location_profile_rec.location_profile_id := NULL;
757: l_location_profile_rec.location_id := p_location_rec.location_id;
758: -- Bug 4693719 : Keep ACS in sync with hz_locations
759: l_location_profile_rec.actual_content_source := nvl(l_acs, l_profile_content_source);
760: l_location_profile_rec.effective_start_date := NULL;
761: l_location_profile_rec.effective_end_date := NULL;
762: l_location_profile_rec.date_validated := NULL;

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

816: -- ACNG add call to location profile: END
817:
818: -- Debug info.
819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
820: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row (-) ',
821: p_prefix=>l_debug_prefix,
822: p_msg_level=>fnd_log.level_procedure);
823: END IF;
824:

Line 1108: p_entity_name => 'HZ_LOCATIONS',

1104: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1105:
1106: -- IF g_loc_mixnmatch_enabled IS NULL THEN
1107: HZ_MIXNM_UTILITY.LoadDataSources(
1108: p_entity_name => 'HZ_LOCATIONS',
1109: p_entity_attr_id => g_loc_entity_attr_id,
1110: p_mixnmatch_enabled => g_loc_mixnmatch_enabled,
1111: p_selected_datasources => g_loc_selected_datasources );
1112: -- END IF;

Line 1116: p_entity_name => 'HZ_LOCATIONS',

1112: -- END IF;
1113: */
1114:
1115: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
1116: p_entity_name => 'HZ_LOCATIONS',
1117: p_entity_attr_id => g_loc_entity_attr_id,
1118: p_mixnmatch_enabled => g_loc_mixnmatch_enabled,
1119: p_selected_datasources => g_loc_selected_datasources,
1120: p_content_source_type => l_location_rec.content_source_type,

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

1167: -- Bug 3711629: remove the dss check in create location API.
1168: /*
1169: -- Bug 3594731: fix the bug 3517181 in the main code line.
1170: -- IN A NUTSHELL THE DSS CHECK THAT IS NEEDED IN THE LOCATION API, FOR SECURING
1171: -- THE HZ_LOCATIONS ENTITY WAS INADVERTENTLY MISSED DURING THE CODING PHASE OF
1172: -- THE DSS PROJECT
1173:
1174: l_test_security :=
1175: hz_dss_util_pub.test_instance(

Line 1177: p_db_object_name => 'HZ_LOCATIONS',

1173:
1174: l_test_security :=
1175: hz_dss_util_pub.test_instance(
1176: p_operation_code => 'INSERT',
1177: p_db_object_name => 'HZ_LOCATIONS',
1178: p_instance_pk1_value => x_location_id,
1179: p_user_name => fnd_global.user_name,
1180: x_return_status => dss_return_status,
1181: x_msg_count => dss_msg_count,

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

1188: IF (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) THEN
1189: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_SECURITY_FAIL');
1190: FND_MESSAGE.SET_TOKEN('USER_NAME',fnd_global.user_name);
1191: FND_MESSAGE.SET_TOKEN('OPER_NAME','INSERT');
1192: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','HZ_LOCATIONS');
1193: FND_MSG_PUB.ADD;
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196: */

Line 1215: HZ_POPULATE_BOT_PKG.pop_hz_locations(

1211: END IF;
1212:
1213: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1214: -- populate function for integration service
1215: HZ_POPULATE_BOT_PKG.pop_hz_locations(
1216: p_operation => 'I',
1217: p_location_id => x_location_id );
1218: END IF;
1219: END IF;

Line 1501: p_owner_table_name => 'HZ_LOCATIONS',

1497: and (p_location_rec.location_id = FND_API.G_MISS_NUM or p_location_rec.location_id is null) THEN
1498: hz_orig_system_ref_pub.get_owner_table_id
1499: (p_orig_system => p_location_rec.orig_system,
1500: p_orig_system_reference => p_location_rec.orig_system_reference,
1501: p_owner_table_name => 'HZ_LOCATIONS',
1502: x_owner_table_id => l_location_rec.location_id,
1503: x_return_status => x_return_status);
1504: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1505: RAISE FND_API.G_EXC_ERROR;

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

1512: -- Bug 3818648: check dss profile before call test_instance.
1513: --
1514: -- Bug 3594731: fix the bug 3517181 in the main code line.
1515: -- IN A NUTSHELL THE DSS CHECK THAT IS NEEDED IN THE LOCATION API, FOR SECURING
1516: -- THE HZ_LOCATIONS ENTITY WAS INADVERTENTLY MISSED DURING THE CODING PHASE OF
1517: -- THE DSS PROJECT
1518:
1519: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
1520:

Line 1534: p_db_object_name => 'HZ_LOCATIONS',

1530: IF l_standalone_location = 'N' THEN
1531: l_test_security :=
1532: hz_dss_util_pub.test_instance(
1533: p_operation_code => 'UPDATE',
1534: p_db_object_name => 'HZ_LOCATIONS',
1535: p_instance_pk1_value => l_location_rec.location_id,
1536: p_user_name => fnd_global.user_name,
1537: x_return_status => dss_return_status,
1538: x_msg_count => dss_msg_count,

Line 1585: p_entity_name => 'HZ_LOCATIONS',

1581: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1582: * There is no need to check if the data-source is selected.
1583:
1584: HZ_MIXNM_UTILITY.LoadDataSources(
1585: p_entity_name => 'HZ_LOCATIONS',
1586: p_entity_attr_id => g_loc_entity_attr_id,
1587: p_mixnmatch_enabled => g_loc_mixnmatch_enabled,
1588: p_selected_datasources => g_loc_selected_datasources );
1589: */

Line 1749: HZ_POPULATE_BOT_PKG.pop_hz_locations(

1745: END IF;
1746:
1747: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1748: -- populate function for integration service
1749: HZ_POPULATE_BOT_PKG.pop_hz_locations(
1750: p_operation => 'U',
1751: p_location_id => l_location_rec.location_id );
1752: END IF;
1753: END IF;

Line 1941: * hz_locations_PKG.Select_Row

1937: * DESCRIPTION
1938: * Gets location record.
1939: *
1940: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1941: * hz_locations_PKG.Select_Row
1942: *
1943: * ARGUMENTS
1944: * IN:
1945: * p_init_msg_list Initialize message stack if it is set to

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

2007: x_location_rec.location_id := p_location_id;
2008:
2009: -- Debug info.
2010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2011: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Select_Row (+)',
2012: p_prefix=>l_debug_prefix,
2013: p_msg_level=>fnd_log.level_procedure);
2014: END IF;
2015:

Line 2016: hz_locations_pkg.select_row (

2012: p_prefix=>l_debug_prefix,
2013: p_msg_level=>fnd_log.level_procedure);
2014: END IF;
2015:
2016: hz_locations_pkg.select_row (
2017: x_location_id => x_location_rec.location_id,
2018: x_attribute_category => x_location_rec.attribute_category,
2019: x_attribute1 => x_location_rec.attribute1,
2020: x_attribute2 => x_location_rec.attribute2,

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

2083: );
2084:
2085: -- Debug info.
2086: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2087: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.select_row (-)',
2088: p_prefix=>l_debug_prefix,
2089: p_msg_level=>fnd_log.level_procedure);
2090: END IF;
2091:

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

2195: /**
2196: * PROCEDURE fill_geometry_for_locations
2197: *
2198: * DESCRIPTION
2199: * Concurrent program to fill geometry column in hz_locations.
2200: *
2201: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2202: *
2203: * ARGUMENTS

Line 2233: FROM hz_locations

2229: STREET,
2230: STREET_SUFFIX,
2231: STREET_NUMBER,
2232: HOUSE_NUMBER
2233: FROM hz_locations
2234: WHERE GEOMETRY IS NULL OR
2235: GEOMETRY = hz_geometry_default
2236: FOR UPDATE OF GEOMETRY;
2237:

Line 2259: UPDATE hz_locations SET GEOMETRY = l_loc_rec.geometry

2255:
2256: IF (l_status = 'E') THEN
2257: EXIT;
2258: ELSIF (l_status = 'Y') THEN
2259: UPDATE hz_locations SET GEOMETRY = l_loc_rec.geometry
2260: WHERE CURRENT OF c_locations;
2261: l_count := l_count + 1;
2262: END IF;
2263: END LOOP;

Line 2303: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,

2299: )
2300: IS
2301: Cursor c_locations(p_location_id NUMBER) IS
2302: SELECT ac.CUST_ACCT_SITE_ID
2303: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,
2304: HZ_CUST_ACCT_SITES_ALL ac
2305: WHERE loc.LOCATION_ID=p_location_id
2306: AND loc.LOCATION_ID = ps.LOCATION_ID
2307: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;