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 FND_LOG

Line 157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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
158: hz_utility_v2pub.debug(p_message=>'do_create_location (+)',
159: p_prefix=>l_debug_prefix,
160: p_msg_level=>fnd_log.level_procedure);
161: END IF;

Line 160: p_msg_level=>fnd_log.level_procedure);

156: -- Debug info.
157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
158: hz_utility_v2pub.debug(p_message=>'do_create_location (+)',
159: p_prefix=>l_debug_prefix,
160: p_msg_level=>fnd_log.level_procedure);
161: END IF;
162:
163: --If primary key value is passed, check for uniqueness.
164: IF p_location_rec.location_id IS NOT NULL AND

Line 207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

203: NULL
204: );
205:
206: -- Debug info.
207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug(p_message=>'Key Generated : '||l_key,
209: p_prefix =>l_debug_prefix,
210: p_msg_level=>fnd_log.level_statement);
211: END IF;

Line 210: p_msg_level=>fnd_log.level_statement);

206: -- Debug info.
207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug(p_message=>'Key Generated : '||l_key,
209: p_prefix =>l_debug_prefix,
210: p_msg_level=>fnd_log.level_statement);
211: END IF;
212:
213: p_location_rec.address_key := l_key;
214:

Line 216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

212:
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;

Line 219: p_msg_level=>fnd_log.level_procedure);

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:
222: -- this is for handling orig_system_reference defaulting
223: IF p_location_rec.location_id = fnd_api.g_miss_num THEN

Line 228: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

224: p_location_rec.location_id := NULL;
225: END IF;
226:
227: -- Debug info.
228: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
229: hz_utility_v2pub.debug(p_message=>'p_location_rec.actual_content_source = '||
230: p_location_rec.actual_content_source,
231: p_prefix =>l_debug_prefix,
232: p_msg_level=>fnd_log.level_statement);

Line 232: p_msg_level=>fnd_log.level_statement);

228: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
229: hz_utility_v2pub.debug(p_message=>'p_location_rec.actual_content_source = '||
230: p_location_rec.actual_content_source,
231: p_prefix =>l_debug_prefix,
232: p_msg_level=>fnd_log.level_statement);
233: END IF;
234: --Bug#8616119
235: --When Timezone Id not found then we don't raise error
236: --While removing messages for loop index is not crrect

Line 261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

257: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
258: END LOOP;
259: */
260: --Bug#8616119
261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',
263: p_prefix =>l_debug_prefix,
264: p_msg_level=>fnd_log.level_statement);
265: END IF;

Line 264: p_msg_level=>fnd_log.level_statement);

260: --Bug#8616119
261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',
263: p_prefix =>l_debug_prefix,
264: p_msg_level=>fnd_log.level_statement);
265: END IF;
266: FOR i IN REVERSE (l_message_count + 1)..l_msg_count LOOP
267: fnd_msg_pub.delete_msg(i);
268: END LOOP;

Line 386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

382: );
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);

Line 390: p_msg_level=>fnd_log.level_procedure);

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
392: hz_utility_v2pub.debug(p_message=>'hz_location_profiles_pkg.insert_row (-) ' ||
393: 'l_location_profile_id = ' || l_location_profile_id,
394: p_prefix=>l_debug_prefix,

Line 395: p_msg_level=>fnd_log.level_procedure);

391: -- ACNG add call to location profile: BEGIN
392: hz_utility_v2pub.debug(p_message=>'hz_location_profiles_pkg.insert_row (-) ' ||
393: 'l_location_profile_id = ' || l_location_profile_id,
394: p_prefix=>l_debug_prefix,
395: p_msg_level=>fnd_log.level_procedure);
396: -- ACNG add call to location profile: END
397: hz_utility_v2pub.debug(p_message=>'do_create_location (-)',
398: p_prefix=>l_debug_prefix,
399: p_msg_level=>fnd_log.level_procedure);

Line 399: p_msg_level=>fnd_log.level_procedure);

395: p_msg_level=>fnd_log.level_procedure);
396: -- ACNG add call to location profile: END
397: hz_utility_v2pub.debug(p_message=>'do_create_location (-)',
398: p_prefix=>l_debug_prefix,
399: p_msg_level=>fnd_log.level_procedure);
400:
401: END IF;
402:
403: if p_location_rec.orig_system is not null

Line 476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

472:
473:
474: BEGIN
475: -- Debug info.
476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
477: hz_utility_v2pub.debug(p_message=>'do_update_location (+)',
478: p_prefix=>l_debug_prefix,
479: p_msg_level=>fnd_log.level_procedure);
480: END IF;

Line 479: p_msg_level=>fnd_log.level_procedure);

475: -- Debug info.
476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
477: hz_utility_v2pub.debug(p_message=>'do_update_location (+)',
478: p_prefix=>l_debug_prefix,
479: p_msg_level=>fnd_log.level_procedure);
480: END IF;
481:
482: -- if party_site_id is not passed in, but orig system parameters are passed in
483: -- get party_site_id

Line 630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

626: NULL
627: );
628:
629: -- Debug info.
630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
631: hz_utility_v2pub.debug(p_message=>'Key generated : '||l_key,
632: p_prefix =>l_debug_prefix,
633: p_msg_level=>fnd_log.level_statement);
634: END IF;

Line 633: p_msg_level=>fnd_log.level_statement);

629: -- Debug info.
630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
631: hz_utility_v2pub.debug(p_message=>'Key generated : '||l_key,
632: p_prefix =>l_debug_prefix,
633: p_msg_level=>fnd_log.level_statement);
634: END IF;
635:
636:
637: p_location_rec.address_key := l_key;

Line 641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

637: p_location_rec.address_key := l_key;
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;

Line 644: p_msg_level=>fnd_log.level_procedure);

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:
647: -- Bug 4693719 : pass NULL if the secure data is not updated
648: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

Line 819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

815:
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;

Line 822: p_msg_level=>fnd_log.level_procedure);

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:
825: -- update de-normalized location components in HZ_PARTIES for parties
826: -- having this location as an identifying location. There can be multiple

Line 872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

868: FETCH c1 INTO l_party_id;
869: EXIT WHEN c1%NOTFOUND;
870:
871: -- Debug info.
872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
873: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
874: l_party_id,
875: p_prefix =>l_debug_prefix,
876: p_msg_level=>fnd_log.level_statement);

Line 876: p_msg_level=>fnd_log.level_statement);

872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
873: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
874: l_party_id,
875: p_prefix =>l_debug_prefix,
876: p_msg_level=>fnd_log.level_statement);
877: END IF;
878:
879: -- Bug 2246041: Denormalization should not be done for Remit To
880: -- Addresses.

Line 976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

972:
973:
974:
975: -- Debug info.
976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
977: hz_utility_v2pub.debug(p_message=>'do_update_location (-)',
978: p_prefix=>l_debug_prefix,
979: p_msg_level=>fnd_log.level_procedure);
980: END IF;

Line 979: p_msg_level=>fnd_log.level_procedure);

975: -- Debug info.
976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
977: hz_utility_v2pub.debug(p_message=>'do_update_location (-)',
978: p_prefix=>l_debug_prefix,
979: p_msg_level=>fnd_log.level_procedure);
980: END IF;
981:
982: END do_update_location;
983:

Line 1076: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1072: -- Check if API is called in debug mode. If yes, enable debug.
1073: --enable_debug;
1074:
1075: -- Debug info.
1076: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1077: hz_utility_v2pub.debug(p_message=>'create_location (+)',
1078: p_prefix=>l_debug_prefix,
1079: p_msg_level=>fnd_log.level_procedure);
1080: END IF;

Line 1079: p_msg_level=>fnd_log.level_procedure);

1075: -- Debug info.
1076: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1077: hz_utility_v2pub.debug(p_message=>'create_location (+)',
1078: p_prefix=>l_debug_prefix,
1079: p_msg_level=>fnd_log.level_procedure);
1080: END IF;
1081:
1082: -- initialize message list if p_init_msg_list is set to TRUE.
1083: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1227: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1223: p_encoded => FND_API.G_FALSE,
1224: p_count => x_msg_count,
1225: p_data => x_msg_data);
1226: -- Debug info.
1227: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1229: p_msg_data=>x_msg_data,
1230: p_msg_type=>'WARNING',
1231: p_msg_level=>fnd_log.level_exception);

Line 1231: p_msg_level=>fnd_log.level_exception);

1227: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1229: p_msg_data=>x_msg_data,
1230: p_msg_type=>'WARNING',
1231: p_msg_level=>fnd_log.level_exception);
1232: END IF;
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1235: p_prefix=>l_debug_prefix,

Line 1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1229: p_msg_data=>x_msg_data,
1230: p_msg_type=>'WARNING',
1231: p_msg_level=>fnd_log.level_exception);
1232: END IF;
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;

Line 1236: p_msg_level=>fnd_log.level_procedure);

1232: END IF;
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;
1238:
1239: -- Check if API is called in debug mode. If yes, disable debug.
1240: --disable_debug;

Line 1252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1248: p_count => x_msg_count,
1249: p_data => x_msg_data);
1250:
1251: -- Debug info.
1252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1254: p_msg_data=>x_msg_data,
1255: p_msg_type=>'ERROR',
1256: p_msg_level=>fnd_log.level_error);

Line 1256: p_msg_level=>fnd_log.level_error);

1252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1254: p_msg_data=>x_msg_data,
1255: p_msg_type=>'ERROR',
1256: p_msg_level=>fnd_log.level_error);
1257: END IF;
1258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1259: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1260: p_prefix=>l_debug_prefix,

Line 1258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1254: p_msg_data=>x_msg_data,
1255: p_msg_type=>'ERROR',
1256: p_msg_level=>fnd_log.level_error);
1257: END IF;
1258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1259: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1260: p_prefix=>l_debug_prefix,
1261: p_msg_level=>fnd_log.level_procedure);
1262: END IF;

Line 1261: p_msg_level=>fnd_log.level_procedure);

1257: END IF;
1258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1259: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1260: p_prefix=>l_debug_prefix,
1261: p_msg_level=>fnd_log.level_procedure);
1262: END IF;
1263:
1264: -- Check if API is called in debug mode. If yes, disable debug.
1265: --disable_debug;

Line 1276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1272: p_count => x_msg_count,
1273: p_data => x_msg_data);
1274:
1275: -- Debug info.
1276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1277: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1278: p_msg_data=>x_msg_data,
1279: p_msg_type=>'UNEXPECTED ERROR',
1280: p_msg_level=>fnd_log.level_error);

Line 1280: p_msg_level=>fnd_log.level_error);

1276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1277: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1278: p_msg_data=>x_msg_data,
1279: p_msg_type=>'UNEXPECTED ERROR',
1280: p_msg_level=>fnd_log.level_error);
1281: END IF;
1282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1284: p_prefix=>l_debug_prefix,

Line 1282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1278: p_msg_data=>x_msg_data,
1279: p_msg_type=>'UNEXPECTED ERROR',
1280: p_msg_level=>fnd_log.level_error);
1281: END IF;
1282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1284: p_prefix=>l_debug_prefix,
1285: p_msg_level=>fnd_log.level_procedure);
1286: END IF;

Line 1285: p_msg_level=>fnd_log.level_procedure);

1281: END IF;
1282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1284: p_prefix=>l_debug_prefix,
1285: p_msg_level=>fnd_log.level_procedure);
1286: END IF;
1287:
1288: -- Check if API is called in debug mode. If yes, disable debug.
1289: --disable_debug;

Line 1305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1301: p_count => x_msg_count,
1302: p_data => x_msg_data);
1303:
1304: -- Debug info.
1305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'SQL ERROR',
1309: p_msg_level=>fnd_log.level_error);

Line 1309: p_msg_level=>fnd_log.level_error);

1305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'SQL ERROR',
1309: p_msg_level=>fnd_log.level_error);
1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1313: p_prefix=>l_debug_prefix,

Line 1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'SQL ERROR',
1309: p_msg_level=>fnd_log.level_error);
1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;

Line 1314: p_msg_level=>fnd_log.level_procedure);

1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;
1316:
1317: -- Check if API is called in debug mode. If yes, disable debug.
1318: --disable_debug;

Line 1476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1472: -- Check if API is called in debug mode. If yes, enable debug.
1473: --enable_debug;
1474:
1475: -- Debug info.
1476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1477: hz_utility_v2pub.debug(p_message=>'update_location (+)',
1478: p_prefix=>l_debug_prefix,
1479: p_msg_level=>fnd_log.level_procedure);
1480: END IF;

Line 1479: p_msg_level=>fnd_log.level_procedure);

1475: -- Debug info.
1476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1477: hz_utility_v2pub.debug(p_message=>'update_location (+)',
1478: p_prefix=>l_debug_prefix,
1479: p_msg_level=>fnd_log.level_procedure);
1480: END IF;
1481:
1482: -- initialize message list if p_init_msg_list is set to TRUE.
1483: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1647: x_timezone_id => l_location_rec.timezone_id,
1648: x_return_status => l_return_status ,
1649: x_msg_count =>l_msg_count ,
1650: x_msg_data => l_msg_data);
1651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1652: hz_utility_v2pub.debug(p_message=>'In Location Upate TimeZone Id : '|| l_location_rec.timezone_id,
1653: p_prefix =>l_debug_prefix,
1654: p_msg_level=>fnd_log.level_statement);
1655: END IF;

Line 1654: p_msg_level=>fnd_log.level_statement);

1650: x_msg_data => l_msg_data);
1651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1652: hz_utility_v2pub.debug(p_message=>'In Location Upate TimeZone Id : '|| l_location_rec.timezone_id,
1653: p_prefix =>l_debug_prefix,
1654: p_msg_level=>fnd_log.level_statement);
1655: END IF;
1656: if l_return_status <> fnd_api.g_ret_sts_success
1657: then -- we don't raise error
1658: l_location_rec.timezone_id := fnd_api.g_miss_num;

Line 1663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1659: /* FOR i IN 1..(l_msg_count - l_message_count) LOOP
1660: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
1661: END LOOP;
1662: */--Bug#8616119
1663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',
1665: p_prefix =>l_debug_prefix,
1666: p_msg_level=>fnd_log.level_statement);
1667: END IF;

Line 1666: p_msg_level=>fnd_log.level_statement);

1662: */--Bug#8616119
1663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',
1665: p_prefix =>l_debug_prefix,
1666: p_msg_level=>fnd_log.level_statement);
1667: END IF;
1668: FOR i IN REVERSE (l_message_count + 1)..l_msg_count LOOP
1669: fnd_msg_pub.delete_msg(i);
1670: END LOOP;

Line 1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1698: x_addr_val_status,
1699: x_addr_warn_msg,
1700: x_return_status);
1701:
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',
1704: p_msg_level=>fnd_log.level_procedure);
1705: END IF;
1706:

Line 1704: p_msg_level=>fnd_log.level_procedure);

1700: x_return_status);
1701:
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',
1704: p_msg_level=>fnd_log.level_procedure);
1705: END IF;
1706:
1707: AP_TCA_SUPPLIER_SYNC_PKG.SYNC_Supplier_Sites(x_return_status => x_return_status,
1708: x_msg_count => x_msg_count,

Line 1719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1715: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1716: RAISE fnd_api.g_exc_unexpected_error;
1717: END IF;
1718:
1719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1720: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',
1721: p_msg_level=>fnd_log.level_procedure);
1722: END IF;
1723:

Line 1721: p_msg_level=>fnd_log.level_procedure);

1717: END IF;
1718:
1719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1720: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',
1721: p_msg_level=>fnd_log.level_procedure);
1722: END IF;
1723:
1724: -- Call to indicate location update to DQM
1725: HZ_DQM_SYNC.sync_location(l_location_rec.location_id,'U');

Line 1764: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1760: p_count => x_msg_count,
1761: p_data => x_msg_data);
1762:
1763: -- Debug info.
1764: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1766: p_msg_data=>x_msg_data,
1767: p_msg_type=>'WARNING',
1768: p_msg_level=>fnd_log.level_exception);

Line 1768: p_msg_level=>fnd_log.level_exception);

1764: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1766: p_msg_data=>x_msg_data,
1767: p_msg_type=>'WARNING',
1768: p_msg_level=>fnd_log.level_exception);
1769: END IF;
1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1772: p_prefix=>l_debug_prefix,

Line 1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1766: p_msg_data=>x_msg_data,
1767: p_msg_type=>'WARNING',
1768: p_msg_level=>fnd_log.level_exception);
1769: END IF;
1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1772: p_prefix=>l_debug_prefix,
1773: p_msg_level=>fnd_log.level_procedure);
1774: END IF;

Line 1773: p_msg_level=>fnd_log.level_procedure);

1769: END IF;
1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1772: p_prefix=>l_debug_prefix,
1773: p_msg_level=>fnd_log.level_procedure);
1774: END IF;
1775:
1776:
1777: -- Check if API is called in debug mode. If yes, disable debug.

Line 1791: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1787: p_count => x_msg_count,
1788: p_data => x_msg_data);
1789:
1790: -- Debug info.
1791: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1792: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1793: p_msg_data=>x_msg_data,
1794: p_msg_type=>'ERROR',
1795: p_msg_level=>fnd_log.level_error);

Line 1795: p_msg_level=>fnd_log.level_error);

1791: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1792: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1793: p_msg_data=>x_msg_data,
1794: p_msg_type=>'ERROR',
1795: p_msg_level=>fnd_log.level_error);
1796: END IF;
1797: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1798: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1799: p_prefix=>l_debug_prefix,

Line 1797: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1793: p_msg_data=>x_msg_data,
1794: p_msg_type=>'ERROR',
1795: p_msg_level=>fnd_log.level_error);
1796: END IF;
1797: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1798: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1799: p_prefix=>l_debug_prefix,
1800: p_msg_level=>fnd_log.level_procedure);
1801: END IF;

Line 1800: p_msg_level=>fnd_log.level_procedure);

1796: END IF;
1797: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1798: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1799: p_prefix=>l_debug_prefix,
1800: p_msg_level=>fnd_log.level_procedure);
1801: END IF;
1802:
1803: -- Check if API is called in debug mode. If yes, disable debug.
1804: --disable_debug;

Line 1816: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1812: p_count => x_msg_count,
1813: p_data => x_msg_data);
1814:
1815: -- Debug info.
1816: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1817: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1818: p_msg_data=>x_msg_data,
1819: p_msg_type=>'UNEXPECTED ERROR',
1820: p_msg_level=>fnd_log.level_error);

Line 1820: p_msg_level=>fnd_log.level_error);

1816: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1817: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1818: p_msg_data=>x_msg_data,
1819: p_msg_type=>'UNEXPECTED ERROR',
1820: p_msg_level=>fnd_log.level_error);
1821: END IF;
1822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1823: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1824: p_prefix=>l_debug_prefix,

Line 1822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1818: p_msg_data=>x_msg_data,
1819: p_msg_type=>'UNEXPECTED ERROR',
1820: p_msg_level=>fnd_log.level_error);
1821: END IF;
1822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1823: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1824: p_prefix=>l_debug_prefix,
1825: p_msg_level=>fnd_log.level_procedure);
1826: END IF;

Line 1825: p_msg_level=>fnd_log.level_procedure);

1821: END IF;
1822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1823: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1824: p_prefix=>l_debug_prefix,
1825: p_msg_level=>fnd_log.level_procedure);
1826: END IF;
1827:
1828: -- Check if API is called in debug mode. If yes, disable debug.
1829: --disable_debug;

Line 1846: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1842: p_count => x_msg_count,
1843: p_data => x_msg_data);
1844:
1845: -- Debug info.
1846: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1847: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1848: p_msg_data=>x_msg_data,
1849: p_msg_type=>'SQL ERROR',
1850: p_msg_level=>fnd_log.level_error);

Line 1850: p_msg_level=>fnd_log.level_error);

1846: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1847: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1848: p_msg_data=>x_msg_data,
1849: p_msg_type=>'SQL ERROR',
1850: p_msg_level=>fnd_log.level_error);
1851: END IF;
1852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1854: p_prefix=>l_debug_prefix,

Line 1852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1848: p_msg_data=>x_msg_data,
1849: p_msg_type=>'SQL ERROR',
1850: p_msg_level=>fnd_log.level_error);
1851: END IF;
1852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1854: p_prefix=>l_debug_prefix,
1855: p_msg_level=>fnd_log.level_procedure);
1856: END IF;

Line 1855: p_msg_level=>fnd_log.level_procedure);

1851: END IF;
1852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1854: p_prefix=>l_debug_prefix,
1855: p_msg_level=>fnd_log.level_procedure);
1856: END IF;
1857:
1858: -- Check if API is called in debug mode. If yes, disable debug.
1859: --disable_debug;

Line 1984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1980: -- Check if API is called in debug mode. If yes, enable debug.
1981: --enable_debug;
1982:
1983: -- Debug info.
1984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1985: hz_utility_v2pub.debug(p_message=>'get_location_rec (+)',
1986: p_prefix=>l_debug_prefix,
1987: p_msg_level=>fnd_log.level_procedure);
1988: END IF;

Line 1987: p_msg_level=>fnd_log.level_procedure);

1983: -- Debug info.
1984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1985: hz_utility_v2pub.debug(p_message=>'get_location_rec (+)',
1986: p_prefix=>l_debug_prefix,
1987: p_msg_level=>fnd_log.level_procedure);
1988: END IF;
1989:
1990: -- Initialize message list if p_init_msg_list is set to TRUE.
1991: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2006:
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;

Line 2013: p_msg_level=>fnd_log.level_procedure);

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:
2016: hz_locations_pkg.select_row (
2017: x_location_id => x_location_rec.location_id,

Line 2086: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2082: x_delivery_point_code => x_location_rec.delivery_point_code
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;

Line 2089: p_msg_level=>fnd_log.level_procedure);

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:
2092: --Standard call to get message count and if count is 1, get message info.
2093: fnd_msg_pub.count_and_get(

Line 2100: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2096: p_data => x_msg_data
2097: );
2098:
2099: -- Debug info.
2100: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2102: p_msg_data=>x_msg_data,
2103: p_msg_type=>'WARNING',
2104: p_msg_level=>fnd_log.level_exception);

Line 2104: p_msg_level=>fnd_log.level_exception);

2100: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2102: p_msg_data=>x_msg_data,
2103: p_msg_type=>'WARNING',
2104: p_msg_level=>fnd_log.level_exception);
2105: END IF;
2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2108: p_prefix=>l_debug_prefix,

Line 2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2102: p_msg_data=>x_msg_data,
2103: p_msg_type=>'WARNING',
2104: p_msg_level=>fnd_log.level_exception);
2105: END IF;
2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2108: p_prefix=>l_debug_prefix,
2109: p_msg_level=>fnd_log.level_procedure);
2110: END IF;

Line 2109: p_msg_level=>fnd_log.level_procedure);

2105: END IF;
2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2108: p_prefix=>l_debug_prefix,
2109: p_msg_level=>fnd_log.level_procedure);
2110: END IF;
2111:
2112: -- Check if API is called in debug mode. If yes, disable debug.
2113: --disable_debug;

Line 2124: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2120: p_data => x_msg_data
2121: );
2122:
2123: -- Debug info.
2124: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2125: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2126: p_msg_data=>x_msg_data,
2127: p_msg_type=>'ERROR',
2128: p_msg_level=>fnd_log.level_error);

Line 2128: p_msg_level=>fnd_log.level_error);

2124: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2125: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2126: p_msg_data=>x_msg_data,
2127: p_msg_type=>'ERROR',
2128: p_msg_level=>fnd_log.level_error);
2129: END IF;
2130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2131: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2132: p_prefix=>l_debug_prefix,

Line 2130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2126: p_msg_data=>x_msg_data,
2127: p_msg_type=>'ERROR',
2128: p_msg_level=>fnd_log.level_error);
2129: END IF;
2130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2131: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2132: p_prefix=>l_debug_prefix,
2133: p_msg_level=>fnd_log.level_procedure);
2134: END IF;

Line 2133: p_msg_level=>fnd_log.level_procedure);

2129: END IF;
2130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2131: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2132: p_prefix=>l_debug_prefix,
2133: p_msg_level=>fnd_log.level_procedure);
2134: END IF;
2135:
2136: -- Check if API is called in debug mode. If yes, disable debug.
2137: --disable_debug;

Line 2149: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2145: p_data => x_msg_data
2146: );
2147:
2148: -- Debug info.
2149: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2151: p_msg_data=>x_msg_data,
2152: p_msg_type=>'UNEXPECTED ERROR',
2153: p_msg_level=>fnd_log.level_error);

Line 2153: p_msg_level=>fnd_log.level_error);

2149: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2151: p_msg_data=>x_msg_data,
2152: p_msg_type=>'UNEXPECTED ERROR',
2153: p_msg_level=>fnd_log.level_error);
2154: END IF;
2155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2156: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2157: p_prefix=>l_debug_prefix,

Line 2155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2151: p_msg_data=>x_msg_data,
2152: p_msg_type=>'UNEXPECTED ERROR',
2153: p_msg_level=>fnd_log.level_error);
2154: END IF;
2155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2156: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2157: p_prefix=>l_debug_prefix,
2158: p_msg_level=>fnd_log.level_procedure);
2159: END IF;

Line 2158: p_msg_level=>fnd_log.level_procedure);

2154: END IF;
2155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2156: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2157: p_prefix=>l_debug_prefix,
2158: p_msg_level=>fnd_log.level_procedure);
2159: END IF;
2160:
2161: -- Check if API is called in debug mode. If yes, disable debug.
2162: --disable_debug;

Line 2178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2174: p_data => x_msg_data
2175: );
2176:
2177: -- Debug info.
2178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2179: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2180: p_msg_data=>x_msg_data,
2181: p_msg_type=>'SQL ERROR',
2182: p_msg_level=>fnd_log.level_error);

Line 2182: p_msg_level=>fnd_log.level_error);

2178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2179: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2180: p_msg_data=>x_msg_data,
2181: p_msg_type=>'SQL ERROR',
2182: p_msg_level=>fnd_log.level_error);
2183: END IF;
2184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2185: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2186: p_prefix=>l_debug_prefix,

Line 2184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2180: p_msg_data=>x_msg_data,
2181: p_msg_type=>'SQL ERROR',
2182: p_msg_level=>fnd_log.level_error);
2183: END IF;
2184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2185: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2186: p_prefix=>l_debug_prefix,
2187: p_msg_level=>fnd_log.level_procedure);
2188: END IF;

Line 2187: p_msg_level=>fnd_log.level_procedure);

2183: END IF;
2184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2185: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2186: p_prefix=>l_debug_prefix,
2187: p_msg_level=>fnd_log.level_procedure);
2188: END IF;
2189:
2190: -- Check if API is called in debug mode. If yes, disable debug.
2191: --disable_debug;