DBA Data[Home] [Help]

APPS.HZ_LOCATION_BO_PUB dependencies on HZ_UTILITY_V2PUB

Line 131: px_location_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

127: px_location_rec.timezone_id:= p_location_obj.timezone_id;
128: IF(p_create_or_update = 'C') THEN
129: px_location_rec.orig_system:= p_loc_os;
130: px_location_rec.orig_system_reference:= p_loc_osr;
131: px_location_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
132: END IF;
133: px_location_rec.actual_content_source:= p_location_obj.actual_content_source;
134: px_location_rec.delivery_point_code:= p_location_obj.delivery_point_code;
135: END assign_location_rec;

Line 174: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

170: FND_MSG_PUB.initialize;
171: END IF;
172:
173: -- initialize Global variable
174: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
175: IF(p_created_by_module IS NULL) THEN
176: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
177: ELSE
178: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 176: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

172:
173: -- initialize Global variable
174: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
175: IF(p_created_by_module IS NULL) THEN
176: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
177: ELSE
178: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
179: END IF;
180:

Line 178: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

174: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
175: IF(p_created_by_module IS NULL) THEN
176: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
177: ELSE
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

Line 183: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(+)',

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

Line 269: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

265: END IF;
266: END IF;
267:
268: -- reset Global variable
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

Line 270: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

266: END IF;
267:
268: -- reset Global variable
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,

Line 274: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
278: END IF;

Line 280: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',

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

Line 290: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

286: WHEN fnd_api.g_exc_error THEN
287: ROLLBACK TO do_create_location_bo_pub;
288:
289: -- reset Global variable
290: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
291: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
292:
293: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
294: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');

Line 291: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

287: ROLLBACK TO do_create_location_bo_pub;
288:
289: -- reset Global variable
290: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
291: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
292:
293: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
294: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
295: FND_MSG_PUB.ADD;

Line 305: hz_utility_v2pub.debug_return_messages(p_msg_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);
309: END IF;

Line 311: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',

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

Line 320: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

316: WHEN fnd_api.g_exc_unexpected_error THEN
317: ROLLBACK TO do_create_location_bo_pub;
318:
319: -- reset Global variable
320: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
321: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
322:
323: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
324: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');

Line 321: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

317: ROLLBACK TO do_create_location_bo_pub;
318:
319: -- reset Global variable
320: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
321: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
322:
323: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
324: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
325: FND_MSG_PUB.ADD;

Line 335: hz_utility_v2pub.debug_return_messages(p_msg_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);
339: END IF;

Line 341: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',

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

Line 350: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

346: WHEN OTHERS THEN
347: ROLLBACK TO do_create_location_bo_pub;
348:
349: -- reset Global variable
350: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
351: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
352:
353: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
354: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');

Line 351: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

347: ROLLBACK TO do_create_location_bo_pub;
348:
349: -- reset Global variable
350: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
351: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
352:
353: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
354: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
355: FND_MSG_PUB.ADD;

Line 369: hz_utility_v2pub.debug_return_messages(p_msg_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);
373: END IF;

Line 375: hz_utility_v2pub.debug(p_message=>'do_create_location_bo(-)',

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;
379: END do_create_location_bo;

Line 492: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: -- initialize Global variable
492: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
493: IF(p_created_by_module IS NULL) THEN
494: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
495: ELSE
496: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 494: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

490:
491: -- initialize Global variable
492: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
493: IF(p_created_by_module IS NULL) THEN
494: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
495: ELSE
496: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
497: END IF;
498:

Line 496: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

492: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
493: IF(p_created_by_module IS NULL) THEN
494: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
495: ELSE
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

Line 501: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(+)',

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

Line 579: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

575: END IF;
576: END IF;
577:
578: -- reset Global variable
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

Line 580: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

576: END IF;
577:
578: -- reset Global variable
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,

Line 584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
588: END IF;

Line 590: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',

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

Line 600: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

596: WHEN fnd_api.g_exc_error THEN
597: ROLLBACK TO do_update_location_bo_pub;
598:
599: -- reset Global variable
600: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
601: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
602:
603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
604: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');

Line 601: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

597: ROLLBACK TO do_update_location_bo_pub;
598:
599: -- reset Global variable
600: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
601: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
602:
603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
604: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
605: FND_MSG_PUB.ADD;

Line 615: hz_utility_v2pub.debug_return_messages(p_msg_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);
619: END IF;

Line 621: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',

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

Line 630: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

626: WHEN fnd_api.g_exc_unexpected_error THEN
627: ROLLBACK TO do_update_location_bo_pub;
628:
629: -- reset Global variable
630: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
631: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
632:
633: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
634: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');

Line 631: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

627: ROLLBACK TO do_update_location_bo_pub;
628:
629: -- reset Global variable
630: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
631: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
632:
633: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
634: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
635: FND_MSG_PUB.ADD;

Line 645: hz_utility_v2pub.debug_return_messages(p_msg_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);
649: END IF;

Line 651: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',

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

Line 660: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

656: WHEN OTHERS THEN
657: ROLLBACK TO do_update_location_bo_pub;
658:
659: -- reset Global variable
660: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
661: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
662:
663: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
664: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');

Line 661: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

657: ROLLBACK TO do_update_location_bo_pub;
658:
659: -- reset Global variable
660: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
661: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
662:
663: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
664: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
665: FND_MSG_PUB.ADD;

Line 679: hz_utility_v2pub.debug_return_messages(p_msg_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);
683: END IF;

Line 685: hz_utility_v2pub.debug(p_message=>'do_update_location_bo(-)',

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;
689: END do_update_location_bo;

Line 790: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(+)',

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

Line 849: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
853: END IF;

Line 855: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',

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

Line 870: hz_utility_v2pub.debug_return_messages(p_msg_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);
874: END IF;

Line 876: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',

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

Line 890: hz_utility_v2pub.debug_return_messages(p_msg_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);
894: END IF;

Line 896: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',

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;
900: WHEN OTHERS THEN

Line 913: hz_utility_v2pub.debug_return_messages(p_msg_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);
917: END IF;

Line 919: hz_utility_v2pub.debug(p_message=>'do_save_location_bo(-)',

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;
923: END do_save_location_bo;

Line 1132: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo(+)',

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

Line 1177: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1181: END IF;

Line 1185: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',

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;
1189: EXCEPTION

Line 1198: hz_utility_v2pub.debug_return_messages(p_msg_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);
1202: END IF;

Line 1204: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',

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;
1208: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1216: hz_utility_v2pub.debug_return_messages(p_msg_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);
1220: END IF;

Line 1222: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',

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;
1226: WHEN OTHERS THEN

Line 1238: hz_utility_v2pub.debug_return_messages(p_msg_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);
1242: END IF;

Line 1244: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',

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;
1248: END get_location_bo;