APPS.HZ_ELOCATION_PKG dependencies on HZ_LOCATIONS_PKG

Line 122: -- Call the HZ_LOCATIONS_PKG Table handler to update location

118: ': ' || SUBSTRB(msg, 1, 240));
119: END time_put_line;
120:
121: -------------------------------------------------------------
122: -- Call the HZ_LOCATIONS_PKG Table handler to update location
123: -------------------------------------------------------------
124: PROCEDURE update_geo_location (
125: p_location_id IN NUMBER,
126: p_geo IN mdsys.sdo_geometry,

Line 141: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'||

137: FROM hz_locations
138: WHERE location_id = p_location_id;
139: BEGIN
140: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
141: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'||
142: TO_CHAR(p_location_id)||'(+)',
143: p_prefix=>l_debug_prefix,
144: p_msg_level=>fnd_log.level_procedure);
145: END IF;

Line 160: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||

156: p_msg_level=>fnd_log.level_error);
157: END IF;
158: ELSE
159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||
161: TO_CHAR(p_location_id)||'(+)',
162: p_prefix=>l_debug_prefix,
163: p_msg_level=>fnd_log.level_procedure);
164: END IF;

Line 165: hz_locations_pkg.update_row (

161: TO_CHAR(p_location_id)||'(+)',
162: p_prefix=>l_debug_prefix,
163: p_msg_level=>fnd_log.level_procedure);
164: END IF;
165: hz_locations_pkg.update_row (
166: x_rowid => l_rowid,
167: x_location_id => p_location_id,
168: x_attribute_category => NULL,
169: x_attribute1 => NULL,

Line 243: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||

239: p_prefix =>l_debug_prefix,
240: p_msg_level=>fnd_log.level_statement);
241: END IF;
242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
243: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||
244: TO_CHAR(p_location_id)||'(-)',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: END IF;

Line 264: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'

260: p_count => x_msg_count,
261: p_data => x_msg_data
262: );
263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'
265: || TO_CHAR(p_location_id)||'(-)',
266: p_prefix=>l_debug_prefix,
267: p_msg_level=>fnd_log.level_procedure);
268: END IF;