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

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

222: END IF;
223:
224:
225: -- Debug info.
226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(p_message=>'get_phone_bos(+)',
228: p_prefix=>l_debug_prefix,
229: p_msg_level=>fnd_log.level_procedure);
230: END IF;

Line 229: p_msg_level=>fnd_log.level_procedure);

225: -- Debug info.
226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(p_message=>'get_phone_bos(+)',
228: p_prefix=>l_debug_prefix,
229: p_msg_level=>fnd_log.level_procedure);
230: END IF;
231:
232: x_phone_objs := HZ_PHONE_CP_BO_TBL();
233: open c1;

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

234: fetch c1 BULK COLLECT into x_phone_objs;
235: close c1;
236:
237: -- Debug info.
238: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
239: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
240: p_msg_data=>x_msg_data,
241: p_msg_type=>'WARNING',
242: p_msg_level=>fnd_log.level_exception);

Line 242: p_msg_level=>fnd_log.level_exception);

238: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
239: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
240: p_msg_data=>x_msg_data,
241: p_msg_type=>'WARNING',
242: p_msg_level=>fnd_log.level_exception);
243: END IF;
244:
245: -- Debug info.
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

242: p_msg_level=>fnd_log.level_exception);
243: END IF;
244:
245: -- Debug info.
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;

Line 249: p_msg_level=>fnd_log.level_procedure);

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

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

259: p_count => x_msg_count,
260: p_data => x_msg_data);
261:
262: -- Debug info.
263: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
265: p_msg_data=>x_msg_data,
266: p_msg_type=>'ERROR',
267: p_msg_level=>fnd_log.level_error);

Line 267: p_msg_level=>fnd_log.level_error);

263: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
265: p_msg_data=>x_msg_data,
266: p_msg_type=>'ERROR',
267: p_msg_level=>fnd_log.level_error);
268: END IF;
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
271: p_prefix=>l_debug_prefix,

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

265: p_msg_data=>x_msg_data,
266: p_msg_type=>'ERROR',
267: p_msg_level=>fnd_log.level_error);
268: END IF;
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
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: END IF;
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
274: WHEN fnd_api.g_exc_unexpected_error THEN
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276:

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

278: p_count => x_msg_count,
279: p_data => x_msg_data);
280:
281: -- Debug info.
282: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
283: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
284: p_msg_data=>x_msg_data,
285: p_msg_type=>'UNEXPECTED ERROR',
286: p_msg_level=>fnd_log.level_error);

Line 286: p_msg_level=>fnd_log.level_error);

282: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
283: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
284: p_msg_data=>x_msg_data,
285: p_msg_type=>'UNEXPECTED ERROR',
286: p_msg_level=>fnd_log.level_error);
287: END IF;
288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
289: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
290: p_prefix=>l_debug_prefix,

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

284: p_msg_data=>x_msg_data,
285: p_msg_type=>'UNEXPECTED ERROR',
286: p_msg_level=>fnd_log.level_error);
287: END IF;
288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
289: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
290: p_prefix=>l_debug_prefix,
291: p_msg_level=>fnd_log.level_procedure);
292: END IF;

Line 291: p_msg_level=>fnd_log.level_procedure);

287: END IF;
288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
289: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
290: p_prefix=>l_debug_prefix,
291: p_msg_level=>fnd_log.level_procedure);
292: END IF;
293: WHEN OTHERS THEN
294: x_return_status := fnd_api.g_ret_sts_unexp_error;
295:

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=>'SQL 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=>'SQL 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_phone_bos (-)',
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=>'SQL 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_phone_bos (-)',
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_phone_bos (-)',
313: p_prefix=>l_debug_prefix,
314: p_msg_level=>fnd_log.level_procedure);
315: END IF;
316:
317: end;
318:

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

503: FND_MSG_PUB.initialize;
504: END IF;
505:
506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'get_telex_bos(+)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;

Line 510: p_msg_level=>fnd_log.level_procedure);

506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'get_telex_bos(+)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;
512:
513:
514: x_telex_objs := HZ_TELEX_CP_BO_TBL();

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

518: close c1;
519:
520:
521: -- Debug info.
522: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
523: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
524: p_msg_data=>x_msg_data,
525: p_msg_type=>'WARNING',
526: p_msg_level=>fnd_log.level_exception);

Line 526: p_msg_level=>fnd_log.level_exception);

522: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
523: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
524: p_msg_data=>x_msg_data,
525: p_msg_type=>'WARNING',
526: p_msg_level=>fnd_log.level_exception);
527: END IF;
528:
529: -- Debug info.
530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

526: p_msg_level=>fnd_log.level_exception);
527: END IF;
528:
529: -- Debug info.
530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
531: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',
532: p_prefix=>l_debug_prefix,
533: p_msg_level=>fnd_log.level_procedure);
534: END IF;

Line 533: p_msg_level=>fnd_log.level_procedure);

529: -- Debug info.
530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
531: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',
532: p_prefix=>l_debug_prefix,
533: p_msg_level=>fnd_log.level_procedure);
534: END IF;
535:
536: EXCEPTION
537:

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

542: p_count => x_msg_count,
543: p_data => x_msg_data);
544:
545: -- Debug info.
546: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
547: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
548: p_msg_data=>x_msg_data,
549: p_msg_type=>'ERROR',
550: p_msg_level=>fnd_log.level_error);

Line 550: p_msg_level=>fnd_log.level_error);

546: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
547: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
548: p_msg_data=>x_msg_data,
549: p_msg_type=>'ERROR',
550: p_msg_level=>fnd_log.level_error);
551: END IF;
552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
553: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
554: p_prefix=>l_debug_prefix,

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

548: p_msg_data=>x_msg_data,
549: p_msg_type=>'ERROR',
550: p_msg_level=>fnd_log.level_error);
551: END IF;
552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
553: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;

Line 555: p_msg_level=>fnd_log.level_procedure);

551: END IF;
552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
553: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;
557: WHEN fnd_api.g_exc_unexpected_error THEN
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559:

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

561: p_count => x_msg_count,
562: p_data => x_msg_data);
563:
564: -- Debug info.
565: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
567: p_msg_data=>x_msg_data,
568: p_msg_type=>'UNEXPECTED ERROR',
569: p_msg_level=>fnd_log.level_error);

Line 569: p_msg_level=>fnd_log.level_error);

565: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
567: p_msg_data=>x_msg_data,
568: p_msg_type=>'UNEXPECTED ERROR',
569: p_msg_level=>fnd_log.level_error);
570: END IF;
571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
572: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',
573: p_prefix=>l_debug_prefix,

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

567: p_msg_data=>x_msg_data,
568: p_msg_type=>'UNEXPECTED ERROR',
569: p_msg_level=>fnd_log.level_error);
570: END IF;
571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
572: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',
573: p_prefix=>l_debug_prefix,
574: p_msg_level=>fnd_log.level_procedure);
575: END IF;

Line 574: p_msg_level=>fnd_log.level_procedure);

570: END IF;
571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
572: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',
573: p_prefix=>l_debug_prefix,
574: p_msg_level=>fnd_log.level_procedure);
575: END IF;
576: WHEN OTHERS THEN
577: x_return_status := fnd_api.g_ret_sts_unexp_error;
578:

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

584: p_count => x_msg_count,
585: p_data => x_msg_data);
586:
587: -- Debug info.
588: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
590: p_msg_data=>x_msg_data,
591: p_msg_type=>'SQL ERROR',
592: p_msg_level=>fnd_log.level_error);

Line 592: p_msg_level=>fnd_log.level_error);

588: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
590: p_msg_data=>x_msg_data,
591: p_msg_type=>'SQL ERROR',
592: p_msg_level=>fnd_log.level_error);
593: END IF;
594: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
595: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
596: p_prefix=>l_debug_prefix,

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

590: p_msg_data=>x_msg_data,
591: p_msg_type=>'SQL ERROR',
592: p_msg_level=>fnd_log.level_error);
593: END IF;
594: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
595: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
596: p_prefix=>l_debug_prefix,
597: p_msg_level=>fnd_log.level_procedure);
598: END IF;

Line 597: p_msg_level=>fnd_log.level_procedure);

593: END IF;
594: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
595: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
596: p_prefix=>l_debug_prefix,
597: p_msg_level=>fnd_log.level_procedure);
598: END IF;
599:
600: end;
601:

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

784: FND_MSG_PUB.initialize;
785: END IF;
786:
787: -- Debug info.
788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
789: hz_utility_v2pub.debug(p_message=>'get_email_bos(+)',
790: p_prefix=>l_debug_prefix,
791: p_msg_level=>fnd_log.level_procedure);
792: END IF;

Line 791: p_msg_level=>fnd_log.level_procedure);

787: -- Debug info.
788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
789: hz_utility_v2pub.debug(p_message=>'get_email_bos(+)',
790: p_prefix=>l_debug_prefix,
791: p_msg_level=>fnd_log.level_procedure);
792: END IF;
793:
794:
795:

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

798: fetch c1 BULK COLLECT into x_email_objs;
799: close c1;
800:
801: -- Debug info.
802: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
803: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
804: p_msg_data=>x_msg_data,
805: p_msg_type=>'WARNING',
806: p_msg_level=>fnd_log.level_exception);

Line 806: p_msg_level=>fnd_log.level_exception);

802: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
803: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
804: p_msg_data=>x_msg_data,
805: p_msg_type=>'WARNING',
806: p_msg_level=>fnd_log.level_exception);
807: END IF;
808:
809: -- Debug info.
810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

806: p_msg_level=>fnd_log.level_exception);
807: END IF;
808:
809: -- Debug info.
810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
812: p_prefix=>l_debug_prefix,
813: p_msg_level=>fnd_log.level_procedure);
814: END IF;

Line 813: p_msg_level=>fnd_log.level_procedure);

809: -- Debug info.
810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
812: p_prefix=>l_debug_prefix,
813: p_msg_level=>fnd_log.level_procedure);
814: END IF;
815:
816: EXCEPTION
817:

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

822: p_count => x_msg_count,
823: p_data => x_msg_data);
824:
825: -- Debug info.
826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
828: p_msg_data=>x_msg_data,
829: p_msg_type=>'ERROR',
830: p_msg_level=>fnd_log.level_error);

Line 830: p_msg_level=>fnd_log.level_error);

826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
828: p_msg_data=>x_msg_data,
829: p_msg_type=>'ERROR',
830: p_msg_level=>fnd_log.level_error);
831: END IF;
832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
833: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
834: p_prefix=>l_debug_prefix,

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

828: p_msg_data=>x_msg_data,
829: p_msg_type=>'ERROR',
830: p_msg_level=>fnd_log.level_error);
831: END IF;
832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
833: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
834: p_prefix=>l_debug_prefix,
835: p_msg_level=>fnd_log.level_procedure);
836: END IF;

Line 835: p_msg_level=>fnd_log.level_procedure);

831: END IF;
832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
833: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
834: p_prefix=>l_debug_prefix,
835: p_msg_level=>fnd_log.level_procedure);
836: END IF;
837: WHEN fnd_api.g_exc_unexpected_error THEN
838: x_return_status := fnd_api.g_ret_sts_unexp_error;
839:

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

841: p_count => x_msg_count,
842: p_data => x_msg_data);
843:
844: -- Debug info.
845: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
846: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
847: p_msg_data=>x_msg_data,
848: p_msg_type=>'UNEXPECTED ERROR',
849: p_msg_level=>fnd_log.level_error);

Line 849: p_msg_level=>fnd_log.level_error);

845: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
846: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
847: p_msg_data=>x_msg_data,
848: p_msg_type=>'UNEXPECTED ERROR',
849: p_msg_level=>fnd_log.level_error);
850: END IF;
851: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
852: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
853: p_prefix=>l_debug_prefix,

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

847: p_msg_data=>x_msg_data,
848: p_msg_type=>'UNEXPECTED ERROR',
849: p_msg_level=>fnd_log.level_error);
850: END IF;
851: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
852: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
853: p_prefix=>l_debug_prefix,
854: p_msg_level=>fnd_log.level_procedure);
855: END IF;

Line 854: p_msg_level=>fnd_log.level_procedure);

850: END IF;
851: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
852: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
853: p_prefix=>l_debug_prefix,
854: p_msg_level=>fnd_log.level_procedure);
855: END IF;
856: WHEN OTHERS THEN
857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858:

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

864: p_count => x_msg_count,
865: p_data => x_msg_data);
866:
867: -- Debug info.
868: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
870: p_msg_data=>x_msg_data,
871: p_msg_type=>'SQL ERROR',
872: p_msg_level=>fnd_log.level_error);

Line 872: p_msg_level=>fnd_log.level_error);

868: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
870: p_msg_data=>x_msg_data,
871: p_msg_type=>'SQL ERROR',
872: p_msg_level=>fnd_log.level_error);
873: END IF;
874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
875: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
876: p_prefix=>l_debug_prefix,

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

870: p_msg_data=>x_msg_data,
871: p_msg_type=>'SQL ERROR',
872: p_msg_level=>fnd_log.level_error);
873: END IF;
874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
875: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
876: p_prefix=>l_debug_prefix,
877: p_msg_level=>fnd_log.level_procedure);
878: END IF;

Line 877: p_msg_level=>fnd_log.level_procedure);

873: END IF;
874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
875: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
876: p_prefix=>l_debug_prefix,
877: p_msg_level=>fnd_log.level_procedure);
878: END IF;
879:
880:
881: end;

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

1068: FND_MSG_PUB.initialize;
1069: END IF;
1070:
1071: -- Debug info.
1072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug(p_message=>'get_web_bos(+)',
1074: p_prefix=>l_debug_prefix,
1075: p_msg_level=>fnd_log.level_procedure);
1076: END IF;

Line 1075: p_msg_level=>fnd_log.level_procedure);

1071: -- Debug info.
1072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug(p_message=>'get_web_bos(+)',
1074: p_prefix=>l_debug_prefix,
1075: p_msg_level=>fnd_log.level_procedure);
1076: END IF;
1077:
1078:
1079:

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

1083: fetch c1 BULK COLLECT into x_web_objs;
1084: close c1;
1085:
1086: -- Debug info.
1087: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1089: p_msg_data=>x_msg_data,
1090: p_msg_type=>'WARNING',
1091: p_msg_level=>fnd_log.level_exception);

Line 1091: p_msg_level=>fnd_log.level_exception);

1087: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1089: p_msg_data=>x_msg_data,
1090: p_msg_type=>'WARNING',
1091: p_msg_level=>fnd_log.level_exception);
1092: END IF;
1093:
1094: -- Debug info.
1095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1091: p_msg_level=>fnd_log.level_exception);
1092: END IF;
1093:
1094: -- Debug info.
1095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1096: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1097: p_prefix=>l_debug_prefix,
1098: p_msg_level=>fnd_log.level_procedure);
1099: END IF;

Line 1098: p_msg_level=>fnd_log.level_procedure);

1094: -- Debug info.
1095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1096: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1097: p_prefix=>l_debug_prefix,
1098: p_msg_level=>fnd_log.level_procedure);
1099: END IF;
1100:
1101: EXCEPTION
1102:

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

1107: p_count => x_msg_count,
1108: p_data => x_msg_data);
1109:
1110: -- Debug info.
1111: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1112: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1113: p_msg_data=>x_msg_data,
1114: p_msg_type=>'ERROR',
1115: p_msg_level=>fnd_log.level_error);

Line 1115: p_msg_level=>fnd_log.level_error);

1111: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1112: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1113: p_msg_data=>x_msg_data,
1114: p_msg_type=>'ERROR',
1115: p_msg_level=>fnd_log.level_error);
1116: END IF;
1117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1118: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1119: p_prefix=>l_debug_prefix,

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

1113: p_msg_data=>x_msg_data,
1114: p_msg_type=>'ERROR',
1115: p_msg_level=>fnd_log.level_error);
1116: END IF;
1117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1118: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1119: p_prefix=>l_debug_prefix,
1120: p_msg_level=>fnd_log.level_procedure);
1121: END IF;

Line 1120: p_msg_level=>fnd_log.level_procedure);

1116: END IF;
1117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1118: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1119: p_prefix=>l_debug_prefix,
1120: p_msg_level=>fnd_log.level_procedure);
1121: END IF;
1122: WHEN fnd_api.g_exc_unexpected_error THEN
1123: x_return_status := fnd_api.g_ret_sts_unexp_error;
1124:

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

1126: p_count => x_msg_count,
1127: p_data => x_msg_data);
1128:
1129: -- Debug info.
1130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1132: p_msg_data=>x_msg_data,
1133: p_msg_type=>'UNEXPECTED ERROR',
1134: p_msg_level=>fnd_log.level_error);

Line 1134: p_msg_level=>fnd_log.level_error);

1130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1132: p_msg_data=>x_msg_data,
1133: p_msg_type=>'UNEXPECTED ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1138: p_prefix=>l_debug_prefix,

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

1132: p_msg_data=>x_msg_data,
1133: p_msg_type=>'UNEXPECTED ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;

Line 1139: p_msg_level=>fnd_log.level_procedure);

1135: END IF;
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141: WHEN OTHERS THEN
1142: x_return_status := fnd_api.g_ret_sts_unexp_error;
1143:

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

1149: p_count => x_msg_count,
1150: p_data => x_msg_data);
1151:
1152: -- Debug info.
1153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1155: p_msg_data=>x_msg_data,
1156: p_msg_type=>'SQL ERROR',
1157: p_msg_level=>fnd_log.level_error);

Line 1157: p_msg_level=>fnd_log.level_error);

1153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1155: p_msg_data=>x_msg_data,
1156: p_msg_type=>'SQL ERROR',
1157: p_msg_level=>fnd_log.level_error);
1158: END IF;
1159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1160: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1161: p_prefix=>l_debug_prefix,

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

1155: p_msg_data=>x_msg_data,
1156: p_msg_type=>'SQL ERROR',
1157: p_msg_level=>fnd_log.level_error);
1158: END IF;
1159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1160: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1161: p_prefix=>l_debug_prefix,
1162: p_msg_level=>fnd_log.level_procedure);
1163: END IF;

Line 1162: p_msg_level=>fnd_log.level_procedure);

1158: END IF;
1159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1160: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1161: p_prefix=>l_debug_prefix,
1162: p_msg_level=>fnd_log.level_procedure);
1163: END IF;
1164:
1165:
1166: end;

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

1359: FND_MSG_PUB.initialize;
1360: END IF;
1361:
1362: -- Debug info.
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'get_edi_bos(+)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;

Line 1366: p_msg_level=>fnd_log.level_procedure);

1362: -- Debug info.
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'get_edi_bos(+)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;
1368:
1369: x_edi_objs := HZ_EDI_CP_BO_TBL();
1370: open c1;

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

1372: close c1;
1373:
1374:
1375: -- Debug info.
1376: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1377: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1378: p_msg_data=>x_msg_data,
1379: p_msg_type=>'WARNING',
1380: p_msg_level=>fnd_log.level_exception);

Line 1380: p_msg_level=>fnd_log.level_exception);

1376: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1377: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1378: p_msg_data=>x_msg_data,
1379: p_msg_type=>'WARNING',
1380: p_msg_level=>fnd_log.level_exception);
1381: END IF;
1382:
1383: -- Debug info.
1384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1380: p_msg_level=>fnd_log.level_exception);
1381: END IF;
1382:
1383: -- Debug info.
1384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1385: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1386: p_prefix=>l_debug_prefix,
1387: p_msg_level=>fnd_log.level_procedure);
1388: END IF;

Line 1387: p_msg_level=>fnd_log.level_procedure);

1383: -- Debug info.
1384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1385: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1386: p_prefix=>l_debug_prefix,
1387: p_msg_level=>fnd_log.level_procedure);
1388: END IF;
1389:
1390: EXCEPTION
1391:

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

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

Line 1404: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1409: p_msg_level=>fnd_log.level_procedure);

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

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

1415: p_count => x_msg_count,
1416: p_data => x_msg_data);
1417:
1418: -- Debug info.
1419: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1420: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1421: p_msg_data=>x_msg_data,
1422: p_msg_type=>'UNEXPECTED ERROR',
1423: p_msg_level=>fnd_log.level_error);

Line 1423: p_msg_level=>fnd_log.level_error);

1419: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1420: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1421: p_msg_data=>x_msg_data,
1422: p_msg_type=>'UNEXPECTED ERROR',
1423: p_msg_level=>fnd_log.level_error);
1424: END IF;
1425: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1426: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1427: p_prefix=>l_debug_prefix,

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

1421: p_msg_data=>x_msg_data,
1422: p_msg_type=>'UNEXPECTED ERROR',
1423: p_msg_level=>fnd_log.level_error);
1424: END IF;
1425: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1426: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1427: p_prefix=>l_debug_prefix,
1428: p_msg_level=>fnd_log.level_procedure);
1429: END IF;

Line 1428: p_msg_level=>fnd_log.level_procedure);

1424: END IF;
1425: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1426: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1427: p_prefix=>l_debug_prefix,
1428: p_msg_level=>fnd_log.level_procedure);
1429: END IF;
1430: WHEN OTHERS THEN
1431: x_return_status := fnd_api.g_ret_sts_unexp_error;
1432:

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

1438: p_count => x_msg_count,
1439: p_data => x_msg_data);
1440:
1441: -- Debug info.
1442: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1443: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1444: p_msg_data=>x_msg_data,
1445: p_msg_type=>'SQL ERROR',
1446: p_msg_level=>fnd_log.level_error);

Line 1446: p_msg_level=>fnd_log.level_error);

1442: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1443: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1444: p_msg_data=>x_msg_data,
1445: p_msg_type=>'SQL ERROR',
1446: p_msg_level=>fnd_log.level_error);
1447: END IF;
1448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1449: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1450: p_prefix=>l_debug_prefix,

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

1444: p_msg_data=>x_msg_data,
1445: p_msg_type=>'SQL ERROR',
1446: p_msg_level=>fnd_log.level_error);
1447: END IF;
1448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1449: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1450: p_prefix=>l_debug_prefix,
1451: p_msg_level=>fnd_log.level_procedure);
1452: END IF;

Line 1451: p_msg_level=>fnd_log.level_procedure);

1447: END IF;
1448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1449: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1450: p_prefix=>l_debug_prefix,
1451: p_msg_level=>fnd_log.level_procedure);
1452: END IF;
1453:
1454:
1455: end;

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

1643: FND_MSG_PUB.initialize;
1644: END IF;
1645:
1646: -- Debug info.
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'get_eft_bos(+)',
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;

Line 1650: p_msg_level=>fnd_log.level_procedure);

1646: -- Debug info.
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'get_eft_bos(+)',
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;
1652:
1653:
1654: x_eft_objs := HZ_EFT_CP_BO_TBL();

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

1656: fetch c1 BULK COLLECT into x_eft_objs;
1657: close c1;
1658:
1659: -- Debug info.
1660: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1661: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1662: p_msg_data=>x_msg_data,
1663: p_msg_type=>'WARNING',
1664: p_msg_level=>fnd_log.level_exception);

Line 1664: p_msg_level=>fnd_log.level_exception);

1660: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1661: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1662: p_msg_data=>x_msg_data,
1663: p_msg_type=>'WARNING',
1664: p_msg_level=>fnd_log.level_exception);
1665: END IF;
1666:
1667: -- Debug info.
1668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1664: p_msg_level=>fnd_log.level_exception);
1665: END IF;
1666:
1667: -- Debug info.
1668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1669: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1670: p_prefix=>l_debug_prefix,
1671: p_msg_level=>fnd_log.level_procedure);
1672: END IF;

Line 1671: p_msg_level=>fnd_log.level_procedure);

1667: -- Debug info.
1668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1669: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1670: p_prefix=>l_debug_prefix,
1671: p_msg_level=>fnd_log.level_procedure);
1672: END IF;
1673:
1674: EXCEPTION
1675:

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

1680: p_count => x_msg_count,
1681: p_data => x_msg_data);
1682:
1683: -- Debug info.
1684: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1685: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1686: p_msg_data=>x_msg_data,
1687: p_msg_type=>'ERROR',
1688: p_msg_level=>fnd_log.level_error);

Line 1688: p_msg_level=>fnd_log.level_error);

1684: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1685: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1686: p_msg_data=>x_msg_data,
1687: p_msg_type=>'ERROR',
1688: p_msg_level=>fnd_log.level_error);
1689: END IF;
1690: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1692: p_prefix=>l_debug_prefix,

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

1686: p_msg_data=>x_msg_data,
1687: p_msg_type=>'ERROR',
1688: p_msg_level=>fnd_log.level_error);
1689: END IF;
1690: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1692: p_prefix=>l_debug_prefix,
1693: p_msg_level=>fnd_log.level_procedure);
1694: END IF;

Line 1693: p_msg_level=>fnd_log.level_procedure);

1689: END IF;
1690: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1692: p_prefix=>l_debug_prefix,
1693: p_msg_level=>fnd_log.level_procedure);
1694: END IF;
1695: WHEN fnd_api.g_exc_unexpected_error THEN
1696: x_return_status := fnd_api.g_ret_sts_unexp_error;
1697:

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

1699: p_count => x_msg_count,
1700: p_data => x_msg_data);
1701:
1702: -- Debug info.
1703: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1704: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1705: p_msg_data=>x_msg_data,
1706: p_msg_type=>'UNEXPECTED ERROR',
1707: p_msg_level=>fnd_log.level_error);

Line 1707: p_msg_level=>fnd_log.level_error);

1703: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1704: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1705: p_msg_data=>x_msg_data,
1706: p_msg_type=>'UNEXPECTED ERROR',
1707: p_msg_level=>fnd_log.level_error);
1708: END IF;
1709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1710: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1711: p_prefix=>l_debug_prefix,

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

1705: p_msg_data=>x_msg_data,
1706: p_msg_type=>'UNEXPECTED ERROR',
1707: p_msg_level=>fnd_log.level_error);
1708: END IF;
1709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1710: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1711: p_prefix=>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_procedure);
1713: END IF;

Line 1712: p_msg_level=>fnd_log.level_procedure);

1708: END IF;
1709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1710: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1711: p_prefix=>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_procedure);
1713: END IF;
1714: WHEN OTHERS THEN
1715: x_return_status := fnd_api.g_ret_sts_unexp_error;
1716:

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

1722: p_count => x_msg_count,
1723: p_data => x_msg_data);
1724:
1725: -- Debug info.
1726: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1727: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1728: p_msg_data=>x_msg_data,
1729: p_msg_type=>'SQL ERROR',
1730: p_msg_level=>fnd_log.level_error);

Line 1730: p_msg_level=>fnd_log.level_error);

1726: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1727: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1728: p_msg_data=>x_msg_data,
1729: p_msg_type=>'SQL ERROR',
1730: p_msg_level=>fnd_log.level_error);
1731: END IF;
1732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1734: p_prefix=>l_debug_prefix,

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

1728: p_msg_data=>x_msg_data,
1729: p_msg_type=>'SQL ERROR',
1730: p_msg_level=>fnd_log.level_error);
1731: END IF;
1732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1734: p_prefix=>l_debug_prefix,
1735: p_msg_level=>fnd_log.level_procedure);
1736: END IF;

Line 1735: p_msg_level=>fnd_log.level_procedure);

1731: END IF;
1732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1734: p_prefix=>l_debug_prefix,
1735: p_msg_level=>fnd_log.level_procedure);
1736: END IF;
1737:
1738:
1739: end;

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

1931: FND_MSG_PUB.initialize;
1932: END IF;
1933:
1934: -- Debug info.
1935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1936: hz_utility_v2pub.debug(p_message=>'get_sms_bos(+)',
1937: p_prefix=>l_debug_prefix,
1938: p_msg_level=>fnd_log.level_procedure);
1939: END IF;

Line 1938: p_msg_level=>fnd_log.level_procedure);

1934: -- Debug info.
1935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1936: hz_utility_v2pub.debug(p_message=>'get_sms_bos(+)',
1937: p_prefix=>l_debug_prefix,
1938: p_msg_level=>fnd_log.level_procedure);
1939: END IF;
1940:
1941:
1942:

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

1945: fetch c1 BULK COLLECT into x_sms_objs;
1946: close c1;
1947:
1948: -- Debug info.
1949: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1950: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1951: p_msg_data=>x_msg_data,
1952: p_msg_type=>'WARNING',
1953: p_msg_level=>fnd_log.level_exception);

Line 1953: p_msg_level=>fnd_log.level_exception);

1949: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1950: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1951: p_msg_data=>x_msg_data,
1952: p_msg_type=>'WARNING',
1953: p_msg_level=>fnd_log.level_exception);
1954: END IF;
1955:
1956: -- Debug info.
1957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1953: p_msg_level=>fnd_log.level_exception);
1954: END IF;
1955:
1956: -- Debug info.
1957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',
1959: p_prefix=>l_debug_prefix,
1960: p_msg_level=>fnd_log.level_procedure);
1961: END IF;

Line 1960: p_msg_level=>fnd_log.level_procedure);

1956: -- Debug info.
1957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',
1959: p_prefix=>l_debug_prefix,
1960: p_msg_level=>fnd_log.level_procedure);
1961: END IF;
1962:
1963: EXCEPTION
1964:

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

1969: p_count => x_msg_count,
1970: p_data => x_msg_data);
1971:
1972: -- Debug info.
1973: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1974: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1975: p_msg_data=>x_msg_data,
1976: p_msg_type=>'ERROR',
1977: p_msg_level=>fnd_log.level_error);

Line 1977: p_msg_level=>fnd_log.level_error);

1973: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1974: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1975: p_msg_data=>x_msg_data,
1976: p_msg_type=>'ERROR',
1977: p_msg_level=>fnd_log.level_error);
1978: END IF;
1979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1980: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1981: p_prefix=>l_debug_prefix,

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

1975: p_msg_data=>x_msg_data,
1976: p_msg_type=>'ERROR',
1977: p_msg_level=>fnd_log.level_error);
1978: END IF;
1979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1980: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1981: p_prefix=>l_debug_prefix,
1982: p_msg_level=>fnd_log.level_procedure);
1983: END IF;

Line 1982: p_msg_level=>fnd_log.level_procedure);

1978: END IF;
1979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1980: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1981: p_prefix=>l_debug_prefix,
1982: p_msg_level=>fnd_log.level_procedure);
1983: END IF;
1984: WHEN fnd_api.g_exc_unexpected_error THEN
1985: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986:

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

1988: p_count => x_msg_count,
1989: p_data => x_msg_data);
1990:
1991: -- Debug info.
1992: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1993: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1994: p_msg_data=>x_msg_data,
1995: p_msg_type=>'UNEXPECTED ERROR',
1996: p_msg_level=>fnd_log.level_error);

Line 1996: p_msg_level=>fnd_log.level_error);

1992: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1993: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1994: p_msg_data=>x_msg_data,
1995: p_msg_type=>'UNEXPECTED ERROR',
1996: p_msg_level=>fnd_log.level_error);
1997: END IF;
1998: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1999: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',
2000: p_prefix=>l_debug_prefix,

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

1994: p_msg_data=>x_msg_data,
1995: p_msg_type=>'UNEXPECTED ERROR',
1996: p_msg_level=>fnd_log.level_error);
1997: END IF;
1998: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1999: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',
2000: p_prefix=>l_debug_prefix,
2001: p_msg_level=>fnd_log.level_procedure);
2002: END IF;

Line 2001: p_msg_level=>fnd_log.level_procedure);

1997: END IF;
1998: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1999: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',
2000: p_prefix=>l_debug_prefix,
2001: p_msg_level=>fnd_log.level_procedure);
2002: END IF;
2003: WHEN OTHERS THEN
2004: x_return_status := fnd_api.g_ret_sts_unexp_error;
2005:

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

2011: p_count => x_msg_count,
2012: p_data => x_msg_data);
2013:
2014: -- Debug info.
2015: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2016: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2017: p_msg_data=>x_msg_data,
2018: p_msg_type=>'SQL ERROR',
2019: p_msg_level=>fnd_log.level_error);

Line 2019: p_msg_level=>fnd_log.level_error);

2015: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2016: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2017: p_msg_data=>x_msg_data,
2018: p_msg_type=>'SQL ERROR',
2019: p_msg_level=>fnd_log.level_error);
2020: END IF;
2021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2022: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
2023: p_prefix=>l_debug_prefix,

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

2017: p_msg_data=>x_msg_data,
2018: p_msg_type=>'SQL ERROR',
2019: p_msg_level=>fnd_log.level_error);
2020: END IF;
2021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2022: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
2023: p_prefix=>l_debug_prefix,
2024: p_msg_level=>fnd_log.level_procedure);
2025: END IF;

Line 2024: p_msg_level=>fnd_log.level_procedure);

2020: END IF;
2021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2022: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
2023: p_prefix=>l_debug_prefix,
2024: p_msg_level=>fnd_log.level_procedure);
2025: END IF;
2026:
2027:
2028: end;

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

2085: FND_MSG_PUB.initialize;
2086: END IF;
2087:
2088: -- Debug info.
2089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2090: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2091: p_prefix=>l_debug_prefix,
2092: p_msg_level=>fnd_log.level_procedure);
2093: END IF;

Line 2092: p_msg_level=>fnd_log.level_procedure);

2088: -- Debug info.
2089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2090: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2091: p_prefix=>l_debug_prefix,
2092: p_msg_level=>fnd_log.level_procedure);
2093: END IF;
2094:
2095: x_cont_pref_objs := HZ_CONTACT_PREF_OBJ_TBL();
2096:

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

2098: fetch c1 BULK COLLECT into x_cont_pref_objs;
2099: close c1;
2100:
2101: -- Debug info.
2102: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2103: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2104: p_msg_data=>x_msg_data,
2105: p_msg_type=>'WARNING',
2106: p_msg_level=>fnd_log.level_exception);

Line 2106: p_msg_level=>fnd_log.level_exception);

2102: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2103: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2104: p_msg_data=>x_msg_data,
2105: p_msg_type=>'WARNING',
2106: p_msg_level=>fnd_log.level_exception);
2107: END IF;
2108:
2109: -- Debug info.
2110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2106: p_msg_level=>fnd_log.level_exception);
2107: END IF;
2108:
2109: -- Debug info.
2110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2111: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2112: p_prefix=>l_debug_prefix,
2113: p_msg_level=>fnd_log.level_procedure);
2114: END IF;

Line 2113: p_msg_level=>fnd_log.level_procedure);

2109: -- Debug info.
2110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2111: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2112: p_prefix=>l_debug_prefix,
2113: p_msg_level=>fnd_log.level_procedure);
2114: END IF;
2115:
2116: EXCEPTION
2117:

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

2126: p_count => x_msg_count,
2127: p_data => x_msg_data);
2128:
2129: -- Debug info.
2130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2132: p_msg_data=>x_msg_data,
2133: p_msg_type=>'SQL ERROR',
2134: p_msg_level=>fnd_log.level_error);

Line 2134: p_msg_level=>fnd_log.level_error);

2130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2132: p_msg_data=>x_msg_data,
2133: p_msg_type=>'SQL ERROR',
2134: p_msg_level=>fnd_log.level_error);
2135: END IF;
2136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2137: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2138: p_prefix=>l_debug_prefix,

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

2132: p_msg_data=>x_msg_data,
2133: p_msg_type=>'SQL ERROR',
2134: p_msg_level=>fnd_log.level_error);
2135: END IF;
2136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2137: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2138: p_prefix=>l_debug_prefix,
2139: p_msg_level=>fnd_log.level_procedure);
2140: END IF;

Line 2139: p_msg_level=>fnd_log.level_procedure);

2135: END IF;
2136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2137: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2138: p_prefix=>l_debug_prefix,
2139: p_msg_level=>fnd_log.level_procedure);
2140: END IF;
2141:
2142: end;
2143: