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_EXTRACT_ACCT_SITE_BO_PVT dependencies on FND_LOG

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

246: END IF;
247:
248:
249: -- Debug info.
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo(+)',
252: p_prefix=>l_debug_prefix,
253: p_msg_level=>fnd_log.level_procedure);
254: END IF;

Line 253: p_msg_level=>fnd_log.level_procedure);

249: -- Debug info.
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo(+)',
252: p_prefix=>l_debug_prefix,
253: p_msg_level=>fnd_log.level_procedure);
254: END IF;
255:
256: open c1;
257: fetch c1 into x_cust_profile_obj;

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

257: fetch c1 into x_cust_profile_obj;
258: close c1;
259:
260: -- Debug info.
261: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
263: p_msg_data=>x_msg_data,
264: p_msg_type=>'WARNING',
265: p_msg_level=>fnd_log.level_exception);

Line 265: p_msg_level=>fnd_log.level_exception);

261: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
263: p_msg_data=>x_msg_data,
264: p_msg_type=>'WARNING',
265: p_msg_level=>fnd_log.level_exception);
266: END IF;
267:
268: -- Debug info.
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

265: p_msg_level=>fnd_log.level_exception);
266: END IF;
267:
268: -- Debug info.
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;

Line 272: p_msg_level=>fnd_log.level_procedure);

268: -- Debug info.
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
274:
275:
276: EXCEPTION

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

282: p_count => x_msg_count,
283: p_data => x_msg_data);
284:
285: -- Debug info.
286: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
287: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
288: p_msg_data=>x_msg_data,
289: p_msg_type=>'ERROR',
290: p_msg_level=>fnd_log.level_error);

Line 290: p_msg_level=>fnd_log.level_error);

286: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
287: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
288: p_msg_data=>x_msg_data,
289: p_msg_type=>'ERROR',
290: p_msg_level=>fnd_log.level_error);
291: END IF;
292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
293: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
294: p_prefix=>l_debug_prefix,

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

288: p_msg_data=>x_msg_data,
289: p_msg_type=>'ERROR',
290: p_msg_level=>fnd_log.level_error);
291: END IF;
292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
293: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
294: p_prefix=>l_debug_prefix,
295: p_msg_level=>fnd_log.level_procedure);
296: END IF;

Line 295: p_msg_level=>fnd_log.level_procedure);

291: END IF;
292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
293: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
294: p_prefix=>l_debug_prefix,
295: p_msg_level=>fnd_log.level_procedure);
296: END IF;
297: WHEN fnd_api.g_exc_unexpected_error THEN
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299:

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

301: p_count => x_msg_count,
302: p_data => x_msg_data);
303:
304: -- Debug info.
305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
307: p_msg_data=>x_msg_data,
308: p_msg_type=>'UNEXPECTED ERROR',
309: p_msg_level=>fnd_log.level_error);

Line 309: p_msg_level=>fnd_log.level_error);

305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
307: p_msg_data=>x_msg_data,
308: p_msg_type=>'UNEXPECTED ERROR',
309: p_msg_level=>fnd_log.level_error);
310: END IF;
311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
312: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
313: p_prefix=>l_debug_prefix,

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

307: p_msg_data=>x_msg_data,
308: p_msg_type=>'UNEXPECTED ERROR',
309: p_msg_level=>fnd_log.level_error);
310: END IF;
311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
312: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
313: p_prefix=>l_debug_prefix,
314: p_msg_level=>fnd_log.level_procedure);
315: END IF;

Line 314: p_msg_level=>fnd_log.level_procedure);

310: END IF;
311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
312: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
313: p_prefix=>l_debug_prefix,
314: p_msg_level=>fnd_log.level_procedure);
315: END IF;
316: WHEN OTHERS THEN
317: x_return_status := fnd_api.g_ret_sts_unexp_error;
318:

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

324: p_count => x_msg_count,
325: p_data => x_msg_data);
326:
327: -- Debug info.
328: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
329: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
330: p_msg_data=>x_msg_data,
331: p_msg_type=>'SQL ERROR',
332: p_msg_level=>fnd_log.level_error);

Line 332: p_msg_level=>fnd_log.level_error);

328: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
329: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
330: p_msg_data=>x_msg_data,
331: p_msg_type=>'SQL ERROR',
332: p_msg_level=>fnd_log.level_error);
333: END IF;
334: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
335: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
336: p_prefix=>l_debug_prefix,

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

330: p_msg_data=>x_msg_data,
331: p_msg_type=>'SQL ERROR',
332: p_msg_level=>fnd_log.level_error);
333: END IF;
334: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
335: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
336: p_prefix=>l_debug_prefix,
337: p_msg_level=>fnd_log.level_procedure);
338: END IF;

Line 337: p_msg_level=>fnd_log.level_procedure);

333: END IF;
334: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
335: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
336: p_prefix=>l_debug_prefix,
337: p_msg_level=>fnd_log.level_procedure);
338: END IF;
339:
340: end;
341:

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

580: END IF;
581:
582:
583: -- Debug info.
584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
585: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos(+)',
586: p_prefix=>l_debug_prefix,
587: p_msg_level=>fnd_log.level_procedure);
588: END IF;

Line 587: p_msg_level=>fnd_log.level_procedure);

583: -- Debug info.
584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
585: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos(+)',
586: p_prefix=>l_debug_prefix,
587: p_msg_level=>fnd_log.level_procedure);
588: END IF;
589:
590: x_cust_site_use_objs := HZ_CUST_SITE_USE_BO_TBL();
591: open c1;

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

607: END IF;
608: end loop;
609:
610: -- Debug info.
611: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
612: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
613: p_msg_data=>x_msg_data,
614: p_msg_type=>'WARNING',
615: p_msg_level=>fnd_log.level_exception);

Line 615: p_msg_level=>fnd_log.level_exception);

611: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
612: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
613: p_msg_data=>x_msg_data,
614: p_msg_type=>'WARNING',
615: p_msg_level=>fnd_log.level_exception);
616: END IF;
617:
618: -- Debug info.
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

615: p_msg_level=>fnd_log.level_exception);
616: END IF;
617:
618: -- Debug info.
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
621: p_prefix=>l_debug_prefix,
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;

Line 622: p_msg_level=>fnd_log.level_procedure);

618: -- Debug info.
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
621: p_prefix=>l_debug_prefix,
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;
624:
625:
626: EXCEPTION

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

632: p_count => x_msg_count,
633: p_data => x_msg_data);
634:
635: -- Debug info.
636: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
637: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
638: p_msg_data=>x_msg_data,
639: p_msg_type=>'ERROR',
640: p_msg_level=>fnd_log.level_error);

Line 640: p_msg_level=>fnd_log.level_error);

636: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
637: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
638: p_msg_data=>x_msg_data,
639: p_msg_type=>'ERROR',
640: p_msg_level=>fnd_log.level_error);
641: END IF;
642: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
643: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
644: p_prefix=>l_debug_prefix,

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

638: p_msg_data=>x_msg_data,
639: p_msg_type=>'ERROR',
640: p_msg_level=>fnd_log.level_error);
641: END IF;
642: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
643: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
644: p_prefix=>l_debug_prefix,
645: p_msg_level=>fnd_log.level_procedure);
646: END IF;

Line 645: p_msg_level=>fnd_log.level_procedure);

641: END IF;
642: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
643: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
644: p_prefix=>l_debug_prefix,
645: p_msg_level=>fnd_log.level_procedure);
646: END IF;
647: WHEN fnd_api.g_exc_unexpected_error THEN
648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649:

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

651: p_count => x_msg_count,
652: p_data => x_msg_data);
653:
654: -- Debug info.
655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
657: p_msg_data=>x_msg_data,
658: p_msg_type=>'UNEXPECTED ERROR',
659: p_msg_level=>fnd_log.level_error);

Line 659: p_msg_level=>fnd_log.level_error);

655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
657: p_msg_data=>x_msg_data,
658: p_msg_type=>'UNEXPECTED ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
663: p_prefix=>l_debug_prefix,

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

657: p_msg_data=>x_msg_data,
658: p_msg_type=>'UNEXPECTED ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;

Line 664: p_msg_level=>fnd_log.level_procedure);

660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;
666: WHEN OTHERS THEN
667: x_return_status := fnd_api.g_ret_sts_unexp_error;
668:

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

674: p_count => x_msg_count,
675: p_data => x_msg_data);
676:
677: -- Debug info.
678: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
679: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
680: p_msg_data=>x_msg_data,
681: p_msg_type=>'SQL ERROR',
682: p_msg_level=>fnd_log.level_error);

Line 682: p_msg_level=>fnd_log.level_error);

678: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
679: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
680: p_msg_data=>x_msg_data,
681: p_msg_type=>'SQL ERROR',
682: p_msg_level=>fnd_log.level_error);
683: END IF;
684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
685: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
686: p_prefix=>l_debug_prefix,

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

680: p_msg_data=>x_msg_data,
681: p_msg_type=>'SQL ERROR',
682: p_msg_level=>fnd_log.level_error);
683: END IF;
684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
685: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
686: p_prefix=>l_debug_prefix,
687: p_msg_level=>fnd_log.level_procedure);
688: END IF;

Line 687: p_msg_level=>fnd_log.level_procedure);

683: END IF;
684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
685: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
686: p_prefix=>l_debug_prefix,
687: p_msg_level=>fnd_log.level_procedure);
688: END IF;
689:
690: end;
691:

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

951: END IF;
952:
953:
954: -- Debug info.
955: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
956: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos(+)',
957: p_prefix=>l_debug_prefix,
958: p_msg_level=>fnd_log.level_procedure);
959: END IF;

Line 958: p_msg_level=>fnd_log.level_procedure);

954: -- Debug info.
955: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
956: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos(+)',
957: p_prefix=>l_debug_prefix,
958: p_msg_level=>fnd_log.level_procedure);
959: END IF;
960:
961: x_cust_acct_site_objs := HZ_CUST_ACCT_SITE_BO_TBL();
962: open c1;

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

1006: */
1007: end loop;
1008:
1009: -- Debug info.
1010: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1011: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1012: p_msg_data=>x_msg_data,
1013: p_msg_type=>'WARNING',
1014: p_msg_level=>fnd_log.level_exception);

Line 1014: p_msg_level=>fnd_log.level_exception);

1010: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1011: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1012: p_msg_data=>x_msg_data,
1013: p_msg_type=>'WARNING',
1014: p_msg_level=>fnd_log.level_exception);
1015: END IF;
1016:
1017: -- Debug info.
1018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1014: p_msg_level=>fnd_log.level_exception);
1015: END IF;
1016:
1017: -- Debug info.
1018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1019: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1020: p_prefix=>l_debug_prefix,
1021: p_msg_level=>fnd_log.level_procedure);
1022: END IF;

Line 1021: p_msg_level=>fnd_log.level_procedure);

1017: -- Debug info.
1018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1019: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1020: p_prefix=>l_debug_prefix,
1021: p_msg_level=>fnd_log.level_procedure);
1022: END IF;
1023:
1024:
1025: EXCEPTION

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

1031: p_count => x_msg_count,
1032: p_data => x_msg_data);
1033:
1034: -- Debug info.
1035: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1036: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1037: p_msg_data=>x_msg_data,
1038: p_msg_type=>'ERROR',
1039: p_msg_level=>fnd_log.level_error);

Line 1039: p_msg_level=>fnd_log.level_error);

1035: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1036: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1037: p_msg_data=>x_msg_data,
1038: p_msg_type=>'ERROR',
1039: p_msg_level=>fnd_log.level_error);
1040: END IF;
1041: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1043: p_prefix=>l_debug_prefix,

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

1037: p_msg_data=>x_msg_data,
1038: p_msg_type=>'ERROR',
1039: p_msg_level=>fnd_log.level_error);
1040: END IF;
1041: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1043: p_prefix=>l_debug_prefix,
1044: p_msg_level=>fnd_log.level_procedure);
1045: END IF;

Line 1044: p_msg_level=>fnd_log.level_procedure);

1040: END IF;
1041: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1043: p_prefix=>l_debug_prefix,
1044: p_msg_level=>fnd_log.level_procedure);
1045: END IF;
1046: WHEN fnd_api.g_exc_unexpected_error THEN
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048:

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

1050: p_count => x_msg_count,
1051: p_data => x_msg_data);
1052:
1053: -- Debug info.
1054: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1056: p_msg_data=>x_msg_data,
1057: p_msg_type=>'UNEXPECTED ERROR',
1058: p_msg_level=>fnd_log.level_error);

Line 1058: p_msg_level=>fnd_log.level_error);

1054: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1056: p_msg_data=>x_msg_data,
1057: p_msg_type=>'UNEXPECTED ERROR',
1058: p_msg_level=>fnd_log.level_error);
1059: END IF;
1060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1061: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1062: p_prefix=>l_debug_prefix,

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

1056: p_msg_data=>x_msg_data,
1057: p_msg_type=>'UNEXPECTED ERROR',
1058: p_msg_level=>fnd_log.level_error);
1059: END IF;
1060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1061: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1062: p_prefix=>l_debug_prefix,
1063: p_msg_level=>fnd_log.level_procedure);
1064: END IF;

Line 1063: p_msg_level=>fnd_log.level_procedure);

1059: END IF;
1060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1061: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1062: p_prefix=>l_debug_prefix,
1063: p_msg_level=>fnd_log.level_procedure);
1064: END IF;
1065: WHEN OTHERS THEN
1066: x_return_status := fnd_api.g_ret_sts_unexp_error;
1067:

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

1073: p_count => x_msg_count,
1074: p_data => x_msg_data);
1075:
1076: -- Debug info.
1077: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1079: p_msg_data=>x_msg_data,
1080: p_msg_type=>'SQL ERROR',
1081: p_msg_level=>fnd_log.level_error);

Line 1081: p_msg_level=>fnd_log.level_error);

1077: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1079: p_msg_data=>x_msg_data,
1080: p_msg_type=>'SQL ERROR',
1081: p_msg_level=>fnd_log.level_error);
1082: END IF;
1083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1084: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1085: p_prefix=>l_debug_prefix,

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

1079: p_msg_data=>x_msg_data,
1080: p_msg_type=>'SQL ERROR',
1081: p_msg_level=>fnd_log.level_error);
1082: END IF;
1083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1084: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1085: p_prefix=>l_debug_prefix,
1086: p_msg_level=>fnd_log.level_procedure);
1087: END IF;

Line 1086: p_msg_level=>fnd_log.level_procedure);

1082: END IF;
1083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1084: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1085: p_prefix=>l_debug_prefix,
1086: p_msg_level=>fnd_log.level_procedure);
1087: END IF;
1088:
1089: end;
1090:

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

1326: END IF;
1327:
1328:
1329: -- Debug info.
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos(+)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;

Line 1333: p_msg_level=>fnd_log.level_procedure);

1329: -- Debug info.
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos(+)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;
1335:
1336: x_cust_site_use_v2_objs := HZ_CUST_SITE_USE_V2_BO_TBL();
1337: open c1;

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

1353: END IF;
1354: end loop;
1355:
1356: -- Debug info.
1357: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1358: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'WARNING',
1361: p_msg_level=>fnd_log.level_exception);

Line 1361: p_msg_level=>fnd_log.level_exception);

1357: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1358: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'WARNING',
1361: p_msg_level=>fnd_log.level_exception);
1362: END IF;
1363:
1364: -- Debug info.
1365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1361: p_msg_level=>fnd_log.level_exception);
1362: END IF;
1363:
1364: -- Debug info.
1365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1366: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1367: p_prefix=>l_debug_prefix,
1368: p_msg_level=>fnd_log.level_procedure);
1369: END IF;

Line 1368: p_msg_level=>fnd_log.level_procedure);

1364: -- Debug info.
1365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1366: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1367: p_prefix=>l_debug_prefix,
1368: p_msg_level=>fnd_log.level_procedure);
1369: END IF;
1370:
1371:
1372: EXCEPTION

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

1378: p_count => x_msg_count,
1379: p_data => x_msg_data);
1380:
1381: -- Debug info.
1382: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1383: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1384: p_msg_data=>x_msg_data,
1385: p_msg_type=>'ERROR',
1386: p_msg_level=>fnd_log.level_error);

Line 1386: p_msg_level=>fnd_log.level_error);

1382: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1383: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1384: p_msg_data=>x_msg_data,
1385: p_msg_type=>'ERROR',
1386: p_msg_level=>fnd_log.level_error);
1387: END IF;
1388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1389: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1390: p_prefix=>l_debug_prefix,

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

1384: p_msg_data=>x_msg_data,
1385: p_msg_type=>'ERROR',
1386: p_msg_level=>fnd_log.level_error);
1387: END IF;
1388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1389: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1390: p_prefix=>l_debug_prefix,
1391: p_msg_level=>fnd_log.level_procedure);
1392: END IF;

Line 1391: p_msg_level=>fnd_log.level_procedure);

1387: END IF;
1388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1389: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1390: p_prefix=>l_debug_prefix,
1391: p_msg_level=>fnd_log.level_procedure);
1392: END IF;
1393: WHEN fnd_api.g_exc_unexpected_error THEN
1394: x_return_status := fnd_api.g_ret_sts_unexp_error;
1395:

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

1397: p_count => x_msg_count,
1398: p_data => x_msg_data);
1399:
1400: -- Debug info.
1401: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1402: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1403: p_msg_data=>x_msg_data,
1404: p_msg_type=>'UNEXPECTED ERROR',
1405: p_msg_level=>fnd_log.level_error);

Line 1405: p_msg_level=>fnd_log.level_error);

1401: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1402: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1403: p_msg_data=>x_msg_data,
1404: p_msg_type=>'UNEXPECTED ERROR',
1405: p_msg_level=>fnd_log.level_error);
1406: END IF;
1407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1408: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1409: p_prefix=>l_debug_prefix,

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

1403: p_msg_data=>x_msg_data,
1404: p_msg_type=>'UNEXPECTED ERROR',
1405: p_msg_level=>fnd_log.level_error);
1406: END IF;
1407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1408: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1409: p_prefix=>l_debug_prefix,
1410: p_msg_level=>fnd_log.level_procedure);
1411: END IF;

Line 1410: p_msg_level=>fnd_log.level_procedure);

1406: END IF;
1407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1408: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1409: p_prefix=>l_debug_prefix,
1410: p_msg_level=>fnd_log.level_procedure);
1411: END IF;
1412: WHEN OTHERS THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414:

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

1420: p_count => x_msg_count,
1421: p_data => x_msg_data);
1422:
1423: -- Debug info.
1424: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1425: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1426: p_msg_data=>x_msg_data,
1427: p_msg_type=>'SQL ERROR',
1428: p_msg_level=>fnd_log.level_error);

Line 1428: p_msg_level=>fnd_log.level_error);

1424: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1425: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1426: p_msg_data=>x_msg_data,
1427: p_msg_type=>'SQL ERROR',
1428: p_msg_level=>fnd_log.level_error);
1429: END IF;
1430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
1432: p_prefix=>l_debug_prefix,

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

1426: p_msg_data=>x_msg_data,
1427: p_msg_type=>'SQL ERROR',
1428: p_msg_level=>fnd_log.level_error);
1429: END IF;
1430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
1432: p_prefix=>l_debug_prefix,
1433: p_msg_level=>fnd_log.level_procedure);
1434: END IF;

Line 1433: p_msg_level=>fnd_log.level_procedure);

1429: END IF;
1430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
1432: p_prefix=>l_debug_prefix,
1433: p_msg_level=>fnd_log.level_procedure);
1434: END IF;
1435:
1436: end;
1437:

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

1697: END IF;
1698:
1699:
1700: -- Debug info.
1701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1702: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos(+)',
1703: p_prefix=>l_debug_prefix,
1704: p_msg_level=>fnd_log.level_procedure);
1705: END IF;

Line 1704: p_msg_level=>fnd_log.level_procedure);

1700: -- Debug info.
1701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1702: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos(+)',
1703: p_prefix=>l_debug_prefix,
1704: p_msg_level=>fnd_log.level_procedure);
1705: END IF;
1706:
1707: x_cust_acct_site_v2_objs := HZ_CUST_ACCT_SITE_V2_BO_TBL();
1708: open c1;

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

1740:
1741: end loop;
1742:
1743: -- Debug info.
1744: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1745: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1746: p_msg_data=>x_msg_data,
1747: p_msg_type=>'WARNING',
1748: p_msg_level=>fnd_log.level_exception);

Line 1748: p_msg_level=>fnd_log.level_exception);

1744: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1745: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1746: p_msg_data=>x_msg_data,
1747: p_msg_type=>'WARNING',
1748: p_msg_level=>fnd_log.level_exception);
1749: END IF;
1750:
1751: -- Debug info.
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1748: p_msg_level=>fnd_log.level_exception);
1749: END IF;
1750:
1751: -- Debug info.
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos (-)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;

Line 1755: p_msg_level=>fnd_log.level_procedure);

1751: -- Debug info.
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos (-)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;
1757:
1758:
1759: EXCEPTION

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

1765: p_count => x_msg_count,
1766: p_data => x_msg_data);
1767:
1768: -- Debug info.
1769: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1770: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1771: p_msg_data=>x_msg_data,
1772: p_msg_type=>'ERROR',
1773: p_msg_level=>fnd_log.level_error);

Line 1773: p_msg_level=>fnd_log.level_error);

1769: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1770: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1771: p_msg_data=>x_msg_data,
1772: p_msg_type=>'ERROR',
1773: p_msg_level=>fnd_log.level_error);
1774: END IF;
1775: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1776: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos (-)',
1777: p_prefix=>l_debug_prefix,

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

1771: p_msg_data=>x_msg_data,
1772: p_msg_type=>'ERROR',
1773: p_msg_level=>fnd_log.level_error);
1774: END IF;
1775: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1776: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos (-)',
1777: p_prefix=>l_debug_prefix,
1778: p_msg_level=>fnd_log.level_procedure);
1779: END IF;

Line 1778: p_msg_level=>fnd_log.level_procedure);

1774: END IF;
1775: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1776: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos (-)',
1777: p_prefix=>l_debug_prefix,
1778: p_msg_level=>fnd_log.level_procedure);
1779: END IF;
1780: WHEN fnd_api.g_exc_unexpected_error THEN
1781: x_return_status := fnd_api.g_ret_sts_unexp_error;
1782:

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

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

Line 1792: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1797: p_msg_level=>fnd_log.level_procedure);

1793: END IF;
1794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1795: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos (-)',
1796: p_prefix=>l_debug_prefix,
1797: p_msg_level=>fnd_log.level_procedure);
1798: END IF;
1799: WHEN OTHERS THEN
1800: x_return_status := fnd_api.g_ret_sts_unexp_error;
1801:

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

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

Line 1815: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1820: p_msg_level=>fnd_log.level_procedure);

1816: END IF;
1817: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1818: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1819: p_prefix=>l_debug_prefix,
1820: p_msg_level=>fnd_log.level_procedure);
1821: END IF;
1822:
1823: end;
1824: