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:
235: if p_location_rec.timezone_id is null or
236: p_location_rec.timezone_id = fnd_api.g_miss_num

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

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

Line 377: p_msg_level=>fnd_log.level_procedure);

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
379: hz_utility_v2pub.debug(p_message=>'hz_location_profiles_pkg.insert_row (-) ' ||
380: 'l_location_profile_id = ' || l_location_profile_id,
381: p_prefix=>l_debug_prefix,

Line 382: p_msg_level=>fnd_log.level_procedure);

378: -- ACNG add call to location profile: BEGIN
379: hz_utility_v2pub.debug(p_message=>'hz_location_profiles_pkg.insert_row (-) ' ||
380: 'l_location_profile_id = ' || l_location_profile_id,
381: p_prefix=>l_debug_prefix,
382: p_msg_level=>fnd_log.level_procedure);
383: -- ACNG add call to location profile: END
384: hz_utility_v2pub.debug(p_message=>'do_create_location (-)',
385: p_prefix=>l_debug_prefix,
386: p_msg_level=>fnd_log.level_procedure);

Line 386: p_msg_level=>fnd_log.level_procedure);

382: p_msg_level=>fnd_log.level_procedure);
383: -- ACNG add call to location profile: END
384: hz_utility_v2pub.debug(p_message=>'do_create_location (-)',
385: p_prefix=>l_debug_prefix,
386: p_msg_level=>fnd_log.level_procedure);
387:
388: END IF;
389:
390: if p_location_rec.orig_system is not null

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

459:
460:
461: BEGIN
462: -- Debug info.
463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
464: hz_utility_v2pub.debug(p_message=>'do_update_location (+)',
465: p_prefix=>l_debug_prefix,
466: p_msg_level=>fnd_log.level_procedure);
467: END IF;

Line 466: p_msg_level=>fnd_log.level_procedure);

462: -- Debug info.
463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
464: hz_utility_v2pub.debug(p_message=>'do_update_location (+)',
465: p_prefix=>l_debug_prefix,
466: p_msg_level=>fnd_log.level_procedure);
467: END IF;
468:
469: -- if party_site_id is not passed in, but orig system parameters are passed in
470: -- get party_site_id

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

613: NULL
614: );
615:
616: -- Debug info.
617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'Key generated : '||l_key,
619: p_prefix =>l_debug_prefix,
620: p_msg_level=>fnd_log.level_statement);
621: END IF;

Line 620: p_msg_level=>fnd_log.level_statement);

616: -- Debug info.
617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'Key generated : '||l_key,
619: p_prefix =>l_debug_prefix,
620: p_msg_level=>fnd_log.level_statement);
621: END IF;
622:
623:
624: p_location_rec.address_key := l_key;

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

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

Line 631: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 809: p_msg_level=>fnd_log.level_procedure);

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

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

855: FETCH c1 INTO l_party_id;
856: EXIT WHEN c1%NOTFOUND;
857:
858: -- Debug info.
859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
860: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
861: l_party_id,
862: p_prefix =>l_debug_prefix,
863: p_msg_level=>fnd_log.level_statement);

Line 863: p_msg_level=>fnd_log.level_statement);

859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
860: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
861: l_party_id,
862: p_prefix =>l_debug_prefix,
863: p_msg_level=>fnd_log.level_statement);
864: END IF;
865:
866: -- Bug 2246041: Denormalization should not be done for Remit To
867: -- Addresses.

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

959:
960:
961:
962: -- Debug info.
963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
964: hz_utility_v2pub.debug(p_message=>'do_update_location (-)',
965: p_prefix=>l_debug_prefix,
966: p_msg_level=>fnd_log.level_procedure);
967: END IF;

Line 966: p_msg_level=>fnd_log.level_procedure);

962: -- Debug info.
963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
964: hz_utility_v2pub.debug(p_message=>'do_update_location (-)',
965: p_prefix=>l_debug_prefix,
966: p_msg_level=>fnd_log.level_procedure);
967: END IF;
968:
969: END do_update_location;
970:

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

1059: -- Check if API is called in debug mode. If yes, enable debug.
1060: --enable_debug;
1061:
1062: -- Debug info.
1063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1064: hz_utility_v2pub.debug(p_message=>'create_location (+)',
1065: p_prefix=>l_debug_prefix,
1066: p_msg_level=>fnd_log.level_procedure);
1067: END IF;

Line 1066: p_msg_level=>fnd_log.level_procedure);

1062: -- Debug info.
1063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1064: hz_utility_v2pub.debug(p_message=>'create_location (+)',
1065: p_prefix=>l_debug_prefix,
1066: p_msg_level=>fnd_log.level_procedure);
1067: END IF;
1068:
1069: -- initialize message list if p_init_msg_list is set to TRUE.
1070: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1210: p_encoded => FND_API.G_FALSE,
1211: p_count => x_msg_count,
1212: p_data => x_msg_data);
1213: -- Debug info.
1214: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1215: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1216: p_msg_data=>x_msg_data,
1217: p_msg_type=>'WARNING',
1218: p_msg_level=>fnd_log.level_exception);

Line 1218: p_msg_level=>fnd_log.level_exception);

1214: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1215: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1216: p_msg_data=>x_msg_data,
1217: p_msg_type=>'WARNING',
1218: p_msg_level=>fnd_log.level_exception);
1219: END IF;
1220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1221: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1222: p_prefix=>l_debug_prefix,

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

1216: p_msg_data=>x_msg_data,
1217: p_msg_type=>'WARNING',
1218: p_msg_level=>fnd_log.level_exception);
1219: END IF;
1220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1221: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1222: p_prefix=>l_debug_prefix,
1223: p_msg_level=>fnd_log.level_procedure);
1224: END IF;

Line 1223: p_msg_level=>fnd_log.level_procedure);

1219: END IF;
1220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1221: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1222: p_prefix=>l_debug_prefix,
1223: p_msg_level=>fnd_log.level_procedure);
1224: END IF;
1225:
1226: -- Check if API is called in debug mode. If yes, disable debug.
1227: --disable_debug;

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

1235: p_count => x_msg_count,
1236: p_data => x_msg_data);
1237:
1238: -- Debug info.
1239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1241: p_msg_data=>x_msg_data,
1242: p_msg_type=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);

Line 1243: p_msg_level=>fnd_log.level_error);

1239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1241: p_msg_data=>x_msg_data,
1242: p_msg_type=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);
1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1247: p_prefix=>l_debug_prefix,

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

1241: p_msg_data=>x_msg_data,
1242: p_msg_type=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);
1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1247: p_prefix=>l_debug_prefix,
1248: p_msg_level=>fnd_log.level_procedure);
1249: END IF;

Line 1248: p_msg_level=>fnd_log.level_procedure);

1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1247: p_prefix=>l_debug_prefix,
1248: p_msg_level=>fnd_log.level_procedure);
1249: END IF;
1250:
1251: -- Check if API is called in debug mode. If yes, disable debug.
1252: --disable_debug;

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

1259: p_count => x_msg_count,
1260: p_data => x_msg_data);
1261:
1262: -- Debug info.
1263: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1264: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1265: p_msg_data=>x_msg_data,
1266: p_msg_type=>'UNEXPECTED ERROR',
1267: p_msg_level=>fnd_log.level_error);

Line 1267: p_msg_level=>fnd_log.level_error);

1263: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1264: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1265: p_msg_data=>x_msg_data,
1266: p_msg_type=>'UNEXPECTED ERROR',
1267: p_msg_level=>fnd_log.level_error);
1268: END IF;
1269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1271: p_prefix=>l_debug_prefix,

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

1265: p_msg_data=>x_msg_data,
1266: p_msg_type=>'UNEXPECTED ERROR',
1267: p_msg_level=>fnd_log.level_error);
1268: END IF;
1269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1271: p_prefix=>l_debug_prefix,
1272: p_msg_level=>fnd_log.level_procedure);
1273: END IF;

Line 1272: p_msg_level=>fnd_log.level_procedure);

1268: END IF;
1269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1271: p_prefix=>l_debug_prefix,
1272: p_msg_level=>fnd_log.level_procedure);
1273: END IF;
1274:
1275: -- Check if API is called in debug mode. If yes, disable debug.
1276: --disable_debug;

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

1288: p_count => x_msg_count,
1289: p_data => x_msg_data);
1290:
1291: -- Debug info.
1292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1294: p_msg_data=>x_msg_data,
1295: p_msg_type=>'SQL ERROR',
1296: p_msg_level=>fnd_log.level_error);

Line 1296: p_msg_level=>fnd_log.level_error);

1292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1294: p_msg_data=>x_msg_data,
1295: p_msg_type=>'SQL ERROR',
1296: p_msg_level=>fnd_log.level_error);
1297: END IF;
1298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1300: p_prefix=>l_debug_prefix,

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

1294: p_msg_data=>x_msg_data,
1295: p_msg_type=>'SQL ERROR',
1296: p_msg_level=>fnd_log.level_error);
1297: END IF;
1298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1300: p_prefix=>l_debug_prefix,
1301: p_msg_level=>fnd_log.level_procedure);
1302: END IF;

Line 1301: p_msg_level=>fnd_log.level_procedure);

1297: END IF;
1298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1300: p_prefix=>l_debug_prefix,
1301: p_msg_level=>fnd_log.level_procedure);
1302: END IF;
1303:
1304: -- Check if API is called in debug mode. If yes, disable debug.
1305: --disable_debug;

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

1459: -- Check if API is called in debug mode. If yes, enable debug.
1460: --enable_debug;
1461:
1462: -- Debug info.
1463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1464: hz_utility_v2pub.debug(p_message=>'update_location (+)',
1465: p_prefix=>l_debug_prefix,
1466: p_msg_level=>fnd_log.level_procedure);
1467: END IF;

Line 1466: p_msg_level=>fnd_log.level_procedure);

1462: -- Debug info.
1463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1464: hz_utility_v2pub.debug(p_message=>'update_location (+)',
1465: p_prefix=>l_debug_prefix,
1466: p_msg_level=>fnd_log.level_procedure);
1467: END IF;
1468:
1469: -- initialize message list if p_init_msg_list is set to TRUE.
1470: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1666: x_addr_val_status,
1667: x_addr_warn_msg,
1668: x_return_status);
1669:
1670: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1671: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',
1672: p_msg_level=>fnd_log.level_procedure);
1673: END IF;
1674:

Line 1672: p_msg_level=>fnd_log.level_procedure);

1668: x_return_status);
1669:
1670: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1671: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',
1672: p_msg_level=>fnd_log.level_procedure);
1673: END IF;
1674:
1675: AP_TCA_SUPPLIER_SYNC_PKG.SYNC_Supplier_Sites(x_return_status => x_return_status,
1676: x_msg_count => x_msg_count,

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

1683: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1684: RAISE fnd_api.g_exc_unexpected_error;
1685: END IF;
1686:
1687: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1688: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',
1689: p_msg_level=>fnd_log.level_procedure);
1690: END IF;
1691:

Line 1689: p_msg_level=>fnd_log.level_procedure);

1685: END IF;
1686:
1687: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1688: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',
1689: p_msg_level=>fnd_log.level_procedure);
1690: END IF;
1691:
1692: -- Call to indicate location update to DQM
1693: HZ_DQM_SYNC.sync_location(l_location_rec.location_id,'U');

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

1728: p_count => x_msg_count,
1729: p_data => x_msg_data);
1730:
1731: -- Debug info.
1732: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1734: p_msg_data=>x_msg_data,
1735: p_msg_type=>'WARNING',
1736: p_msg_level=>fnd_log.level_exception);

Line 1736: p_msg_level=>fnd_log.level_exception);

1732: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1734: p_msg_data=>x_msg_data,
1735: p_msg_type=>'WARNING',
1736: p_msg_level=>fnd_log.level_exception);
1737: END IF;
1738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1739: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1740: p_prefix=>l_debug_prefix,

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

1734: p_msg_data=>x_msg_data,
1735: p_msg_type=>'WARNING',
1736: p_msg_level=>fnd_log.level_exception);
1737: END IF;
1738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1739: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1740: p_prefix=>l_debug_prefix,
1741: p_msg_level=>fnd_log.level_procedure);
1742: END IF;

Line 1741: p_msg_level=>fnd_log.level_procedure);

1737: END IF;
1738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1739: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1740: p_prefix=>l_debug_prefix,
1741: p_msg_level=>fnd_log.level_procedure);
1742: END IF;
1743:
1744:
1745: -- Check if API is called in debug mode. If yes, disable debug.

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

1755: p_count => x_msg_count,
1756: p_data => x_msg_data);
1757:
1758: -- Debug info.
1759: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1761: p_msg_data=>x_msg_data,
1762: p_msg_type=>'ERROR',
1763: p_msg_level=>fnd_log.level_error);

Line 1763: p_msg_level=>fnd_log.level_error);

1759: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1761: p_msg_data=>x_msg_data,
1762: p_msg_type=>'ERROR',
1763: p_msg_level=>fnd_log.level_error);
1764: END IF;
1765: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1766: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1767: p_prefix=>l_debug_prefix,

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

1761: p_msg_data=>x_msg_data,
1762: p_msg_type=>'ERROR',
1763: p_msg_level=>fnd_log.level_error);
1764: END IF;
1765: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1766: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1767: p_prefix=>l_debug_prefix,
1768: p_msg_level=>fnd_log.level_procedure);
1769: END IF;

Line 1768: p_msg_level=>fnd_log.level_procedure);

1764: END IF;
1765: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1766: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1767: p_prefix=>l_debug_prefix,
1768: p_msg_level=>fnd_log.level_procedure);
1769: END IF;
1770:
1771: -- Check if API is called in debug mode. If yes, disable debug.
1772: --disable_debug;

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

1780: p_count => x_msg_count,
1781: p_data => x_msg_data);
1782:
1783: -- Debug info.
1784: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1785: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1786: p_msg_data=>x_msg_data,
1787: p_msg_type=>'UNEXPECTED ERROR',
1788: p_msg_level=>fnd_log.level_error);

Line 1788: p_msg_level=>fnd_log.level_error);

1784: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1785: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1786: p_msg_data=>x_msg_data,
1787: p_msg_type=>'UNEXPECTED ERROR',
1788: p_msg_level=>fnd_log.level_error);
1789: END IF;
1790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1791: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1792: p_prefix=>l_debug_prefix,

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

1786: p_msg_data=>x_msg_data,
1787: p_msg_type=>'UNEXPECTED ERROR',
1788: p_msg_level=>fnd_log.level_error);
1789: END IF;
1790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1791: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1792: p_prefix=>l_debug_prefix,
1793: p_msg_level=>fnd_log.level_procedure);
1794: END IF;

Line 1793: p_msg_level=>fnd_log.level_procedure);

1789: END IF;
1790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1791: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1792: p_prefix=>l_debug_prefix,
1793: p_msg_level=>fnd_log.level_procedure);
1794: END IF;
1795:
1796: -- Check if API is called in debug mode. If yes, disable debug.
1797: --disable_debug;

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

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

Line 1818: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1823: p_msg_level=>fnd_log.level_procedure);

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

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

1948: -- Check if API is called in debug mode. If yes, enable debug.
1949: --enable_debug;
1950:
1951: -- Debug info.
1952: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1953: hz_utility_v2pub.debug(p_message=>'get_location_rec (+)',
1954: p_prefix=>l_debug_prefix,
1955: p_msg_level=>fnd_log.level_procedure);
1956: END IF;

Line 1955: p_msg_level=>fnd_log.level_procedure);

1951: -- Debug info.
1952: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1953: hz_utility_v2pub.debug(p_message=>'get_location_rec (+)',
1954: p_prefix=>l_debug_prefix,
1955: p_msg_level=>fnd_log.level_procedure);
1956: END IF;
1957:
1958: -- Initialize message list if p_init_msg_list is set to TRUE.
1959: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

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

Line 1981: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 2057: p_msg_level=>fnd_log.level_procedure);

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

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

2064: p_data => x_msg_data
2065: );
2066:
2067: -- Debug info.
2068: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2069: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2070: p_msg_data=>x_msg_data,
2071: p_msg_type=>'WARNING',
2072: p_msg_level=>fnd_log.level_exception);

Line 2072: p_msg_level=>fnd_log.level_exception);

2068: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2069: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2070: p_msg_data=>x_msg_data,
2071: p_msg_type=>'WARNING',
2072: p_msg_level=>fnd_log.level_exception);
2073: END IF;
2074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2075: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2076: p_prefix=>l_debug_prefix,

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

2070: p_msg_data=>x_msg_data,
2071: p_msg_type=>'WARNING',
2072: p_msg_level=>fnd_log.level_exception);
2073: END IF;
2074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2075: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2076: p_prefix=>l_debug_prefix,
2077: p_msg_level=>fnd_log.level_procedure);
2078: END IF;

Line 2077: p_msg_level=>fnd_log.level_procedure);

2073: END IF;
2074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2075: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2076: p_prefix=>l_debug_prefix,
2077: p_msg_level=>fnd_log.level_procedure);
2078: END IF;
2079:
2080: -- Check if API is called in debug mode. If yes, disable debug.
2081: --disable_debug;

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

2088: p_data => x_msg_data
2089: );
2090:
2091: -- Debug info.
2092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'ERROR',
2096: p_msg_level=>fnd_log.level_error);

Line 2096: p_msg_level=>fnd_log.level_error);

2092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'ERROR',
2096: p_msg_level=>fnd_log.level_error);
2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2100: p_prefix=>l_debug_prefix,

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

2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'ERROR',
2096: p_msg_level=>fnd_log.level_error);
2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;

Line 2101: p_msg_level=>fnd_log.level_procedure);

2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;
2103:
2104: -- Check if API is called in debug mode. If yes, disable debug.
2105: --disable_debug;

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

2113: p_data => x_msg_data
2114: );
2115:
2116: -- Debug info.
2117: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2118: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2119: p_msg_data=>x_msg_data,
2120: p_msg_type=>'UNEXPECTED ERROR',
2121: p_msg_level=>fnd_log.level_error);

Line 2121: p_msg_level=>fnd_log.level_error);

2117: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2118: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2119: p_msg_data=>x_msg_data,
2120: p_msg_type=>'UNEXPECTED ERROR',
2121: p_msg_level=>fnd_log.level_error);
2122: END IF;
2123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2124: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2125: p_prefix=>l_debug_prefix,

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

2119: p_msg_data=>x_msg_data,
2120: p_msg_type=>'UNEXPECTED ERROR',
2121: p_msg_level=>fnd_log.level_error);
2122: END IF;
2123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2124: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2125: p_prefix=>l_debug_prefix,
2126: p_msg_level=>fnd_log.level_procedure);
2127: END IF;

Line 2126: p_msg_level=>fnd_log.level_procedure);

2122: END IF;
2123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2124: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2125: p_prefix=>l_debug_prefix,
2126: p_msg_level=>fnd_log.level_procedure);
2127: END IF;
2128:
2129: -- Check if API is called in debug mode. If yes, disable debug.
2130: --disable_debug;

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

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

Line 2150: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2155: p_msg_level=>fnd_log.level_procedure);

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