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

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

178: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
179: END IF;
180:
181: -- Debug info.
182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
183: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(+)',
184: p_prefix=>l_debug_prefix,
185: p_msg_level=>fnd_log.level_procedure);
186: END IF;

Line 185: p_msg_level=>fnd_log.level_procedure);

181: -- Debug info.
182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
183: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(+)',
184: p_prefix=>l_debug_prefix,
185: p_msg_level=>fnd_log.level_procedure);
186: END IF;
187:
188: /* Currently, business object definition cannot be altered. The seeded completeness
189: for LOCATION business object has no mandatory embedded objects. So, comment out

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

269: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
270: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
271:
272: -- Debug info.
273: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
274: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
275: p_msg_data=>x_msg_data,
276: p_msg_type=>'WARNING',
277: p_msg_level=>fnd_log.level_exception);

Line 277: p_msg_level=>fnd_log.level_exception);

273: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
274: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
275: p_msg_data=>x_msg_data,
276: p_msg_type=>'WARNING',
277: p_msg_level=>fnd_log.level_exception);
278: END IF;
279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
280: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
281: p_prefix=>l_debug_prefix,

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

275: p_msg_data=>x_msg_data,
276: p_msg_type=>'WARNING',
277: p_msg_level=>fnd_log.level_exception);
278: END IF;
279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
280: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
281: p_prefix=>l_debug_prefix,
282: p_msg_level=>fnd_log.level_procedure);
283: END IF;

Line 282: p_msg_level=>fnd_log.level_procedure);

278: END IF;
279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
280: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
281: p_prefix=>l_debug_prefix,
282: p_msg_level=>fnd_log.level_procedure);
283: END IF;
284:
285: EXCEPTION
286: WHEN fnd_api.g_exc_error THEN

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

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

Line 308: p_msg_level=>fnd_log.level_error);

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

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

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

Line 313: p_msg_level=>fnd_log.level_procedure);

309: END IF;
310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
311: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
312: p_prefix=>l_debug_prefix,
313: p_msg_level=>fnd_log.level_procedure);
314: END IF;
315:
316: WHEN fnd_api.g_exc_unexpected_error THEN
317: ROLLBACK TO do_create_location_bo_pub;

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

330: p_count => x_msg_count,
331: p_data => x_msg_data);
332:
333: -- Debug info.
334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
335: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
336: p_msg_data=>x_msg_data,
337: p_msg_type=>'UNEXPECTED ERROR',
338: p_msg_level=>fnd_log.level_error);

Line 338: p_msg_level=>fnd_log.level_error);

334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
335: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
336: p_msg_data=>x_msg_data,
337: p_msg_type=>'UNEXPECTED ERROR',
338: p_msg_level=>fnd_log.level_error);
339: END IF;
340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
341: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
342: p_prefix=>l_debug_prefix,

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

336: p_msg_data=>x_msg_data,
337: p_msg_type=>'UNEXPECTED ERROR',
338: p_msg_level=>fnd_log.level_error);
339: END IF;
340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
341: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
342: p_prefix=>l_debug_prefix,
343: p_msg_level=>fnd_log.level_procedure);
344: END IF;

Line 343: p_msg_level=>fnd_log.level_procedure);

339: END IF;
340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
341: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
342: p_prefix=>l_debug_prefix,
343: p_msg_level=>fnd_log.level_procedure);
344: END IF;
345:
346: WHEN OTHERS THEN
347: ROLLBACK TO do_create_location_bo_pub;

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

364: p_count => x_msg_count,
365: p_data => x_msg_data);
366:
367: -- Debug info.
368: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
370: p_msg_data=>x_msg_data,
371: p_msg_type=>'SQL ERROR',
372: p_msg_level=>fnd_log.level_error);

Line 372: p_msg_level=>fnd_log.level_error);

368: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
370: p_msg_data=>x_msg_data,
371: p_msg_type=>'SQL ERROR',
372: p_msg_level=>fnd_log.level_error);
373: END IF;
374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
375: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
376: p_prefix=>l_debug_prefix,

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

370: p_msg_data=>x_msg_data,
371: p_msg_type=>'SQL ERROR',
372: p_msg_level=>fnd_log.level_error);
373: END IF;
374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
375: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
376: p_prefix=>l_debug_prefix,
377: p_msg_level=>fnd_log.level_procedure);
378: END IF;

Line 377: p_msg_level=>fnd_log.level_procedure);

373: END IF;
374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
375: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',
376: p_prefix=>l_debug_prefix,
377: p_msg_level=>fnd_log.level_procedure);
378: END IF;
379: END do_create_location_bo;
380:
381: PROCEDURE create_location_bo(

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

496: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
497: END IF;
498:
499: -- Debug info.
500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
501: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(+)',
502: p_prefix=>l_debug_prefix,
503: p_msg_level=>fnd_log.level_procedure);
504: END IF;

Line 503: p_msg_level=>fnd_log.level_procedure);

499: -- Debug info.
500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
501: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(+)',
502: p_prefix=>l_debug_prefix,
503: p_msg_level=>fnd_log.level_procedure);
504: END IF;
505:
506: x_location_id := p_location_obj.location_id;
507: x_location_os := p_location_obj.orig_system;

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

579: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
580: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
581:
582: -- Debug info.
583: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
585: p_msg_data=>x_msg_data,
586: p_msg_type=>'WARNING',
587: p_msg_level=>fnd_log.level_exception);

Line 587: p_msg_level=>fnd_log.level_exception);

583: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
585: p_msg_data=>x_msg_data,
586: p_msg_type=>'WARNING',
587: p_msg_level=>fnd_log.level_exception);
588: END IF;
589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
590: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
591: p_prefix=>l_debug_prefix,

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

585: p_msg_data=>x_msg_data,
586: p_msg_type=>'WARNING',
587: p_msg_level=>fnd_log.level_exception);
588: END IF;
589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
590: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
591: p_prefix=>l_debug_prefix,
592: p_msg_level=>fnd_log.level_procedure);
593: END IF;

Line 592: p_msg_level=>fnd_log.level_procedure);

588: END IF;
589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
590: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
591: p_prefix=>l_debug_prefix,
592: p_msg_level=>fnd_log.level_procedure);
593: END IF;
594:
595: EXCEPTION
596: WHEN fnd_api.g_exc_error THEN

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

610: p_count => x_msg_count,
611: p_data => x_msg_data);
612:
613: -- Debug info.
614: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
615: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
616: p_msg_data=>x_msg_data,
617: p_msg_type=>'ERROR',
618: p_msg_level=>fnd_log.level_error);

Line 618: p_msg_level=>fnd_log.level_error);

614: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
615: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
616: p_msg_data=>x_msg_data,
617: p_msg_type=>'ERROR',
618: p_msg_level=>fnd_log.level_error);
619: END IF;
620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
622: p_prefix=>l_debug_prefix,

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

616: p_msg_data=>x_msg_data,
617: p_msg_type=>'ERROR',
618: p_msg_level=>fnd_log.level_error);
619: END IF;
620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
622: p_prefix=>l_debug_prefix,
623: p_msg_level=>fnd_log.level_procedure);
624: END IF;

Line 623: p_msg_level=>fnd_log.level_procedure);

619: END IF;
620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
622: p_prefix=>l_debug_prefix,
623: p_msg_level=>fnd_log.level_procedure);
624: END IF;
625:
626: WHEN fnd_api.g_exc_unexpected_error THEN
627: ROLLBACK TO do_update_location_bo_pub;

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

640: p_count => x_msg_count,
641: p_data => x_msg_data);
642:
643: -- Debug info.
644: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
646: p_msg_data=>x_msg_data,
647: p_msg_type=>'UNEXPECTED ERROR',
648: p_msg_level=>fnd_log.level_error);

Line 648: p_msg_level=>fnd_log.level_error);

644: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
646: p_msg_data=>x_msg_data,
647: p_msg_type=>'UNEXPECTED ERROR',
648: p_msg_level=>fnd_log.level_error);
649: END IF;
650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
651: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
652: p_prefix=>l_debug_prefix,

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

646: p_msg_data=>x_msg_data,
647: p_msg_type=>'UNEXPECTED ERROR',
648: p_msg_level=>fnd_log.level_error);
649: END IF;
650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
651: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
652: p_prefix=>l_debug_prefix,
653: p_msg_level=>fnd_log.level_procedure);
654: END IF;

Line 653: p_msg_level=>fnd_log.level_procedure);

649: END IF;
650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
651: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',
652: p_prefix=>l_debug_prefix,
653: p_msg_level=>fnd_log.level_procedure);
654: END IF;
655:
656: WHEN OTHERS THEN
657: ROLLBACK TO do_update_location_bo_pub;

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=>'do_update_location_bo(-)',
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=>'do_update_location_bo(-)',
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=>'do_update_location_bo(-)',
686: p_prefix=>l_debug_prefix,
687: p_msg_level=>fnd_log.level_procedure);
688: END IF;
689: END do_update_location_bo;
690:
691: PROCEDURE update_location_bo(

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

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

Line 792: p_msg_level=>fnd_log.level_procedure);

788: -- Debug info.
789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
790: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(+)',
791: p_prefix=>l_debug_prefix,
792: p_msg_level=>fnd_log.level_procedure);
793: END IF;
794:
795: x_location_id := p_location_obj.location_id;
796: x_location_os := p_location_obj.orig_system;

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

844: RAISE FND_API.G_EXC_ERROR;
845: END IF;
846:
847: -- Debug info.
848: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
849: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
850: p_msg_data=>x_msg_data,
851: p_msg_type=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);

Line 852: p_msg_level=>fnd_log.level_exception);

848: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
849: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
850: p_msg_data=>x_msg_data,
851: p_msg_type=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);
853: END IF;
854: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
855: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
856: p_prefix=>l_debug_prefix,

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

850: p_msg_data=>x_msg_data,
851: p_msg_type=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);
853: END IF;
854: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
855: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
856: p_prefix=>l_debug_prefix,
857: p_msg_level=>fnd_log.level_procedure);
858: END IF;

Line 857: p_msg_level=>fnd_log.level_procedure);

853: END IF;
854: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
855: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
856: p_prefix=>l_debug_prefix,
857: p_msg_level=>fnd_log.level_procedure);
858: END IF;
859:
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN

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

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

Line 873: p_msg_level=>fnd_log.level_error);

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

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

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

Line 878: p_msg_level=>fnd_log.level_procedure);

874: END IF;
875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
876: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
877: p_prefix=>l_debug_prefix,
878: p_msg_level=>fnd_log.level_procedure);
879: END IF;
880:
881: WHEN fnd_api.g_exc_unexpected_error THEN
882: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

885: p_count => x_msg_count,
886: p_data => x_msg_data);
887:
888: -- Debug info.
889: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
890: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
891: p_msg_data=>x_msg_data,
892: p_msg_type=>'UNEXPECTED ERROR',
893: p_msg_level=>fnd_log.level_error);

Line 893: p_msg_level=>fnd_log.level_error);

889: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
890: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
891: p_msg_data=>x_msg_data,
892: p_msg_type=>'UNEXPECTED ERROR',
893: p_msg_level=>fnd_log.level_error);
894: END IF;
895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
896: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
897: p_prefix=>l_debug_prefix,

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

891: p_msg_data=>x_msg_data,
892: p_msg_type=>'UNEXPECTED ERROR',
893: p_msg_level=>fnd_log.level_error);
894: END IF;
895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
896: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
897: p_prefix=>l_debug_prefix,
898: p_msg_level=>fnd_log.level_procedure);
899: END IF;

Line 898: p_msg_level=>fnd_log.level_procedure);

894: END IF;
895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
896: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
897: p_prefix=>l_debug_prefix,
898: p_msg_level=>fnd_log.level_procedure);
899: END IF;
900: WHEN OTHERS THEN
901: x_return_status := fnd_api.g_ret_sts_unexp_error;
902:

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

908: p_count => x_msg_count,
909: p_data => x_msg_data);
910:
911: -- Debug info.
912: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
914: p_msg_data=>x_msg_data,
915: p_msg_type=>'SQL ERROR',
916: p_msg_level=>fnd_log.level_error);

Line 916: p_msg_level=>fnd_log.level_error);

912: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
914: p_msg_data=>x_msg_data,
915: p_msg_type=>'SQL ERROR',
916: p_msg_level=>fnd_log.level_error);
917: END IF;
918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
919: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
920: p_prefix=>l_debug_prefix,

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

914: p_msg_data=>x_msg_data,
915: p_msg_type=>'SQL ERROR',
916: p_msg_level=>fnd_log.level_error);
917: END IF;
918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
919: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
920: p_prefix=>l_debug_prefix,
921: p_msg_level=>fnd_log.level_procedure);
922: END IF;

Line 921: p_msg_level=>fnd_log.level_procedure);

917: END IF;
918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
919: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',
920: p_prefix=>l_debug_prefix,
921: p_msg_level=>fnd_log.level_procedure);
922: END IF;
923: END do_save_location_bo;
924:
925: PROCEDURE save_location_bo(

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

1127: FND_MSG_PUB.initialize;
1128: END IF;
1129:
1130: -- Debug info.
1131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo(+)',
1133: p_prefix=>l_debug_prefix,
1134: p_msg_level=>fnd_log.level_procedure);
1135: END IF;

Line 1134: p_msg_level=>fnd_log.level_procedure);

1130: -- Debug info.
1131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo(+)',
1133: p_prefix=>l_debug_prefix,
1134: p_msg_level=>fnd_log.level_procedure);
1135: END IF;
1136:
1137: -- check if pass in contact_point_id and/or os+osr
1138: -- extraction validation logic is same as update

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

1172: RAISE FND_API.G_EXC_ERROR;
1173: END IF;
1174:
1175: -- Debug info.
1176: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1177: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1178: p_msg_data=>x_msg_data,
1179: p_msg_type=>'WARNING',
1180: p_msg_level=>fnd_log.level_exception);

Line 1180: p_msg_level=>fnd_log.level_exception);

1176: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1177: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1178: p_msg_data=>x_msg_data,
1179: p_msg_type=>'WARNING',
1180: p_msg_level=>fnd_log.level_exception);
1181: END IF;
1182:
1183: -- Debug info.
1184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1180: p_msg_level=>fnd_log.level_exception);
1181: END IF;
1182:
1183: -- Debug info.
1184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1185: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1186: p_prefix=>l_debug_prefix,
1187: p_msg_level=>fnd_log.level_procedure);
1188: END IF;

Line 1187: p_msg_level=>fnd_log.level_procedure);

1183: -- Debug info.
1184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1185: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1186: p_prefix=>l_debug_prefix,
1187: p_msg_level=>fnd_log.level_procedure);
1188: END IF;
1189: EXCEPTION
1190: WHEN fnd_api.g_exc_error THEN
1191: x_return_status := fnd_api.g_ret_sts_error;

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

1193: p_count => x_msg_count,
1194: p_data => x_msg_data);
1195:
1196: -- Debug info.
1197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1199: p_msg_data=>x_msg_data,
1200: p_msg_type=>'ERROR',
1201: p_msg_level=>fnd_log.level_error);

Line 1201: p_msg_level=>fnd_log.level_error);

1197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1199: p_msg_data=>x_msg_data,
1200: p_msg_type=>'ERROR',
1201: p_msg_level=>fnd_log.level_error);
1202: END IF;
1203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1204: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1205: p_prefix=>l_debug_prefix,

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

1199: p_msg_data=>x_msg_data,
1200: p_msg_type=>'ERROR',
1201: p_msg_level=>fnd_log.level_error);
1202: END IF;
1203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1204: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1205: p_prefix=>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_procedure);
1207: END IF;

Line 1206: p_msg_level=>fnd_log.level_procedure);

1202: END IF;
1203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1204: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1205: p_prefix=>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_procedure);
1207: END IF;
1208: WHEN fnd_api.g_exc_unexpected_error THEN
1209: x_return_status := fnd_api.g_ret_sts_unexp_error;
1210: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1211: p_count => x_msg_count,
1212: p_data => x_msg_data);
1213:
1214: -- Debug info.
1215: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1216: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1217: p_msg_data=>x_msg_data,
1218: p_msg_type=>'UNEXPECTED ERROR',
1219: p_msg_level=>fnd_log.level_error);

Line 1219: p_msg_level=>fnd_log.level_error);

1215: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1216: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1217: p_msg_data=>x_msg_data,
1218: p_msg_type=>'UNEXPECTED ERROR',
1219: p_msg_level=>fnd_log.level_error);
1220: END IF;
1221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1222: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1223: p_prefix=>l_debug_prefix,

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

1217: p_msg_data=>x_msg_data,
1218: p_msg_type=>'UNEXPECTED ERROR',
1219: p_msg_level=>fnd_log.level_error);
1220: END IF;
1221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1222: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1223: p_prefix=>l_debug_prefix,
1224: p_msg_level=>fnd_log.level_procedure);
1225: END IF;

Line 1224: p_msg_level=>fnd_log.level_procedure);

1220: END IF;
1221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1222: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1223: p_prefix=>l_debug_prefix,
1224: p_msg_level=>fnd_log.level_procedure);
1225: END IF;
1226: WHEN OTHERS THEN
1227: x_return_status := fnd_api.g_ret_sts_unexp_error;
1228: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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

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

Line 1241: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1246: p_msg_level=>fnd_log.level_procedure);

1242: END IF;
1243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1244: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1245: p_prefix=>l_debug_prefix,
1246: p_msg_level=>fnd_log.level_procedure);
1247: END IF;
1248: END get_location_bo;
1249:
1250: PROCEDURE get_location_bo (