[Home] [Help]
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: -- Debug info.
75: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
76: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(+)',
77: p_prefix=>l_debug_prefix,
78: p_msg_level=>fnd_log.level_procedure);
79: END IF;
74: -- Debug info.
75: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
76: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(+)',
77: p_prefix=>l_debug_prefix,
78: p_msg_level=>fnd_log.level_procedure);
79: END IF;
80:
81: -- Base on p_validate_bo_flag, check the completeness of business objects
82: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
189: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
190: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
191:
192: -- Debug info.
193: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
195: p_msg_data=>x_msg_data,
196: p_msg_type=>'WARNING',
197: p_msg_level=>fnd_log.level_exception);
193: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
195: p_msg_data=>x_msg_data,
196: p_msg_type=>'WARNING',
197: p_msg_level=>fnd_log.level_exception);
198: END IF;
199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
200: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
201: p_prefix=>l_debug_prefix,
195: p_msg_data=>x_msg_data,
196: p_msg_type=>'WARNING',
197: p_msg_level=>fnd_log.level_exception);
198: END IF;
199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
200: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
201: p_prefix=>l_debug_prefix,
202: p_msg_level=>fnd_log.level_procedure);
203: END IF;
198: END IF;
199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
200: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
201: p_prefix=>l_debug_prefix,
202: p_msg_level=>fnd_log.level_procedure);
203: END IF;
204: EXCEPTION
205: WHEN fnd_api.g_exc_error THEN
206: ROLLBACK TO do_create_org_cust_bo_pub;
219: p_count => x_msg_count,
220: p_data => x_msg_data);
221:
222: -- Debug info.
223: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
224: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
225: p_msg_data=>x_msg_data,
226: p_msg_type=>'ERROR',
227: p_msg_level=>fnd_log.level_error);
223: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
224: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
225: p_msg_data=>x_msg_data,
226: p_msg_type=>'ERROR',
227: p_msg_level=>fnd_log.level_error);
228: END IF;
229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
231: p_prefix=>l_debug_prefix,
225: p_msg_data=>x_msg_data,
226: p_msg_type=>'ERROR',
227: p_msg_level=>fnd_log.level_error);
228: END IF;
229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
231: p_prefix=>l_debug_prefix,
232: p_msg_level=>fnd_log.level_procedure);
233: END IF;
228: END IF;
229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
231: p_prefix=>l_debug_prefix,
232: p_msg_level=>fnd_log.level_procedure);
233: END IF;
234:
235: WHEN fnd_api.g_exc_unexpected_error THEN
236: ROLLBACK TO do_create_org_cust_bo_pub;
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251:
252: -- Debug info.
253: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
254: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
255: p_msg_data=>x_msg_data,
256: p_msg_type=>'UNEXPECTED ERROR',
257: p_msg_level=>fnd_log.level_error);
253: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
254: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
255: p_msg_data=>x_msg_data,
256: p_msg_type=>'UNEXPECTED ERROR',
257: p_msg_level=>fnd_log.level_error);
258: END IF;
259: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
261: p_prefix=>l_debug_prefix,
255: p_msg_data=>x_msg_data,
256: p_msg_type=>'UNEXPECTED ERROR',
257: p_msg_level=>fnd_log.level_error);
258: END IF;
259: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
261: p_prefix=>l_debug_prefix,
262: p_msg_level=>fnd_log.level_procedure);
263: END IF;
258: END IF;
259: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
261: p_prefix=>l_debug_prefix,
262: p_msg_level=>fnd_log.level_procedure);
263: END IF;
264:
265: WHEN OTHERS THEN
266: ROLLBACK TO do_create_org_cust_bo_pub;
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: -- Debug info.
287: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
289: p_msg_data=>x_msg_data,
290: p_msg_type=>'SQL ERROR',
291: p_msg_level=>fnd_log.level_error);
287: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
289: p_msg_data=>x_msg_data,
290: p_msg_type=>'SQL ERROR',
291: p_msg_level=>fnd_log.level_error);
292: END IF;
293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
294: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
295: p_prefix=>l_debug_prefix,
289: p_msg_data=>x_msg_data,
290: p_msg_type=>'SQL ERROR',
291: p_msg_level=>fnd_log.level_error);
292: END IF;
293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
294: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
295: p_prefix=>l_debug_prefix,
296: p_msg_level=>fnd_log.level_procedure);
297: END IF;
292: END IF;
293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
294: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
295: p_prefix=>l_debug_prefix,
296: p_msg_level=>fnd_log.level_procedure);
297: END IF;
298: END do_create_org_cust_bo;
299:
300: PROCEDURE create_org_cust_bo(
393: FND_MSG_PUB.initialize;
394: END IF;
395:
396: -- Debug info.
397: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
398: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
399: p_prefix=>l_debug_prefix,
400: p_msg_level=>fnd_log.level_procedure);
401: END IF;
396: -- Debug info.
397: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
398: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
399: p_prefix=>l_debug_prefix,
400: p_msg_level=>fnd_log.level_procedure);
401: END IF;
402:
403: -- initialize Global variable to indicate the caller of V2API is from BO API
404: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
524: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
525: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
526:
527: -- Debug info.
528: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
530: p_msg_data=>x_msg_data,
531: p_msg_type=>'WARNING',
532: p_msg_level=>fnd_log.level_exception);
528: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
530: p_msg_data=>x_msg_data,
531: p_msg_type=>'WARNING',
532: p_msg_level=>fnd_log.level_exception);
533: END IF;
534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
536: p_prefix=>l_debug_prefix,
530: p_msg_data=>x_msg_data,
531: p_msg_type=>'WARNING',
532: p_msg_level=>fnd_log.level_exception);
533: END IF;
534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
536: p_prefix=>l_debug_prefix,
537: p_msg_level=>fnd_log.level_procedure);
538: END IF;
533: END IF;
534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
536: p_prefix=>l_debug_prefix,
537: p_msg_level=>fnd_log.level_procedure);
538: END IF;
539:
540: EXCEPTION
541: WHEN fnd_api.g_exc_error THEN
556: p_count => x_msg_count,
557: p_data => x_msg_data);
558:
559: -- Debug info.
560: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
562: p_msg_data=>x_msg_data,
563: p_msg_type=>'ERROR',
564: p_msg_level=>fnd_log.level_error);
560: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
562: p_msg_data=>x_msg_data,
563: p_msg_type=>'ERROR',
564: p_msg_level=>fnd_log.level_error);
565: END IF;
566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
567: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
568: p_prefix=>l_debug_prefix,
562: p_msg_data=>x_msg_data,
563: p_msg_type=>'ERROR',
564: p_msg_level=>fnd_log.level_error);
565: END IF;
566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
567: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
568: p_prefix=>l_debug_prefix,
569: p_msg_level=>fnd_log.level_procedure);
570: END IF;
565: END IF;
566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
567: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
568: p_prefix=>l_debug_prefix,
569: p_msg_level=>fnd_log.level_procedure);
570: END IF;
571:
572: WHEN fnd_api.g_exc_unexpected_error THEN
573: ROLLBACK TO do_update_org_cust_bo_pub;
587: p_count => x_msg_count,
588: p_data => x_msg_data);
589:
590: -- Debug info.
591: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'UNEXPECTED ERROR',
595: p_msg_level=>fnd_log.level_error);
591: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'UNEXPECTED ERROR',
595: p_msg_level=>fnd_log.level_error);
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
599: p_prefix=>l_debug_prefix,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'UNEXPECTED ERROR',
595: p_msg_level=>fnd_log.level_error);
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;
602:
603: WHEN OTHERS THEN
604: ROLLBACK TO do_update_org_cust_bo_pub;
622: p_count => x_msg_count,
623: p_data => x_msg_data);
624:
625: -- Debug info.
626: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
627: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
628: p_msg_data=>x_msg_data,
629: p_msg_type=>'SQL ERROR',
630: p_msg_level=>fnd_log.level_error);
626: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
627: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
628: p_msg_data=>x_msg_data,
629: p_msg_type=>'SQL ERROR',
630: p_msg_level=>fnd_log.level_error);
631: END IF;
632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
634: p_prefix=>l_debug_prefix,
628: p_msg_data=>x_msg_data,
629: p_msg_type=>'SQL ERROR',
630: p_msg_level=>fnd_log.level_error);
631: END IF;
632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
634: p_prefix=>l_debug_prefix,
635: p_msg_level=>fnd_log.level_procedure);
636: END IF;
631: END IF;
632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
634: p_prefix=>l_debug_prefix,
635: p_msg_level=>fnd_log.level_procedure);
636: END IF;
637: END do_update_org_cust_bo;
638:
639: PROCEDURE update_org_cust_bo(
723: FND_MSG_PUB.initialize;
724: END IF;
725:
726: -- Debug info.
727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
728: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(+)',
729: p_prefix=>l_debug_prefix,
730: p_msg_level=>fnd_log.level_procedure);
731: END IF;
726: -- Debug info.
727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
728: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(+)',
729: p_prefix=>l_debug_prefix,
730: p_msg_level=>fnd_log.level_procedure);
731: END IF;
732:
733: l_organization_id := p_org_cust_obj.organization_obj.organization_id;
734: l_organization_os := p_org_cust_obj.organization_obj.orig_system;
782: RAISE fnd_api.g_exc_error;
783: END IF;
784:
785: -- Debug info.
786: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
787: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
788: p_msg_data=>x_msg_data,
789: p_msg_type=>'WARNING',
790: p_msg_level=>fnd_log.level_exception);
786: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
787: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
788: p_msg_data=>x_msg_data,
789: p_msg_type=>'WARNING',
790: p_msg_level=>fnd_log.level_exception);
791: END IF;
792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
793: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
794: p_prefix=>l_debug_prefix,
788: p_msg_data=>x_msg_data,
789: p_msg_type=>'WARNING',
790: p_msg_level=>fnd_log.level_exception);
791: END IF;
792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
793: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
794: p_prefix=>l_debug_prefix,
795: p_msg_level=>fnd_log.level_procedure);
796: END IF;
791: END IF;
792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
793: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
794: p_prefix=>l_debug_prefix,
795: p_msg_level=>fnd_log.level_procedure);
796: END IF;
797:
798: EXCEPTION
799: WHEN fnd_api.g_exc_error THEN
803: p_count => x_msg_count,
804: p_data => x_msg_data);
805:
806: -- Debug info.
807: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
808: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
809: p_msg_data=>x_msg_data,
810: p_msg_type=>'ERROR',
811: p_msg_level=>fnd_log.level_error);
807: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
808: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
809: p_msg_data=>x_msg_data,
810: p_msg_type=>'ERROR',
811: p_msg_level=>fnd_log.level_error);
812: END IF;
813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
814: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
815: p_prefix=>l_debug_prefix,
809: p_msg_data=>x_msg_data,
810: p_msg_type=>'ERROR',
811: p_msg_level=>fnd_log.level_error);
812: END IF;
813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
814: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
815: p_prefix=>l_debug_prefix,
816: p_msg_level=>fnd_log.level_procedure);
817: END IF;
812: END IF;
813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
814: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
815: p_prefix=>l_debug_prefix,
816: p_msg_level=>fnd_log.level_procedure);
817: END IF;
818:
819: WHEN fnd_api.g_exc_unexpected_error THEN
820: x_return_status := fnd_api.g_ret_sts_unexp_error;
823: p_count => x_msg_count,
824: p_data => x_msg_data);
825:
826: -- Debug info.
827: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
829: p_msg_data=>x_msg_data,
830: p_msg_type=>'UNEXPECTED ERROR',
831: p_msg_level=>fnd_log.level_error);
827: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
829: p_msg_data=>x_msg_data,
830: p_msg_type=>'UNEXPECTED ERROR',
831: p_msg_level=>fnd_log.level_error);
832: END IF;
833: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
834: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
835: p_prefix=>l_debug_prefix,
829: p_msg_data=>x_msg_data,
830: p_msg_type=>'UNEXPECTED ERROR',
831: p_msg_level=>fnd_log.level_error);
832: END IF;
833: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
834: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
835: p_prefix=>l_debug_prefix,
836: p_msg_level=>fnd_log.level_procedure);
837: END IF;
832: END IF;
833: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
834: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
835: p_prefix=>l_debug_prefix,
836: p_msg_level=>fnd_log.level_procedure);
837: END IF;
838: WHEN OTHERS THEN
839: x_return_status := fnd_api.g_ret_sts_unexp_error;
840:
846: p_count => x_msg_count,
847: p_data => x_msg_data);
848:
849: -- Debug info.
850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
852: p_msg_data=>x_msg_data,
853: p_msg_type=>'SQL ERROR',
854: p_msg_level=>fnd_log.level_error);
850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
852: p_msg_data=>x_msg_data,
853: p_msg_type=>'SQL ERROR',
854: p_msg_level=>fnd_log.level_error);
855: END IF;
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
858: p_prefix=>l_debug_prefix,
852: p_msg_data=>x_msg_data,
853: p_msg_type=>'SQL ERROR',
854: p_msg_level=>fnd_log.level_error);
855: END IF;
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
858: p_prefix=>l_debug_prefix,
859: p_msg_level=>fnd_log.level_procedure);
860: END IF;
855: END IF;
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
858: p_prefix=>l_debug_prefix,
859: p_msg_level=>fnd_log.level_procedure);
860: END IF;
861: END do_save_org_cust_bo;
862:
863: PROCEDURE save_org_cust_bo(
1001: END IF;
1002:
1003:
1004: -- Debug info.
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo(+)',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;
1004: -- Debug info.
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo(+)',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;
1010:
1011: -- check if pass in contact_point_id and/or os+osr
1012: -- extraction validation logic is same as update
1042: END IF;
1043:
1044:
1045: -- Debug info.
1046: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1047: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1048: p_msg_data=>x_msg_data,
1049: p_msg_type=>'WARNING',
1050: p_msg_level=>fnd_log.level_exception);
1046: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1047: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1048: p_msg_data=>x_msg_data,
1049: p_msg_type=>'WARNING',
1050: p_msg_level=>fnd_log.level_exception);
1051: END IF;
1052:
1053: -- Debug info.
1054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1050: p_msg_level=>fnd_log.level_exception);
1051: END IF;
1052:
1053: -- Debug info.
1054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1056: p_prefix=>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_procedure);
1058: END IF;
1053: -- Debug info.
1054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1056: p_prefix=>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_procedure);
1058: END IF;
1059:
1060:
1061: EXCEPTION
1067: p_count => x_msg_count,
1068: p_data => x_msg_data);
1069:
1070: -- Debug info.
1071: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1072: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1073: p_msg_data=>x_msg_data,
1074: p_msg_type=>'ERROR',
1075: p_msg_level=>fnd_log.level_error);
1071: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1072: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1073: p_msg_data=>x_msg_data,
1074: p_msg_type=>'ERROR',
1075: p_msg_level=>fnd_log.level_error);
1076: END IF;
1077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1079: p_prefix=>l_debug_prefix,
1073: p_msg_data=>x_msg_data,
1074: p_msg_type=>'ERROR',
1075: p_msg_level=>fnd_log.level_error);
1076: END IF;
1077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1079: p_prefix=>l_debug_prefix,
1080: p_msg_level=>fnd_log.level_procedure);
1081: END IF;
1076: END IF;
1077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1079: p_prefix=>l_debug_prefix,
1080: p_msg_level=>fnd_log.level_procedure);
1081: END IF;
1082: WHEN fnd_api.g_exc_unexpected_error THEN
1083: x_return_status := fnd_api.g_ret_sts_unexp_error;
1084:
1086: p_count => x_msg_count,
1087: p_data => x_msg_data);
1088:
1089: -- Debug info.
1090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1092: p_msg_data=>x_msg_data,
1093: p_msg_type=>'UNEXPECTED ERROR',
1094: p_msg_level=>fnd_log.level_error);
1090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1092: p_msg_data=>x_msg_data,
1093: p_msg_type=>'UNEXPECTED ERROR',
1094: p_msg_level=>fnd_log.level_error);
1095: END IF;
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1098: p_prefix=>l_debug_prefix,
1092: p_msg_data=>x_msg_data,
1093: p_msg_type=>'UNEXPECTED ERROR',
1094: p_msg_level=>fnd_log.level_error);
1095: END IF;
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1098: p_prefix=>l_debug_prefix,
1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;
1095: END IF;
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1098: p_prefix=>l_debug_prefix,
1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;
1101: WHEN OTHERS THEN
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103:
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:
1112: -- Debug info.
1113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1115: p_msg_data=>x_msg_data,
1116: p_msg_type=>'SQL ERROR',
1117: p_msg_level=>fnd_log.level_error);
1113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1115: p_msg_data=>x_msg_data,
1116: p_msg_type=>'SQL ERROR',
1117: p_msg_level=>fnd_log.level_error);
1118: END IF;
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1121: p_prefix=>l_debug_prefix,
1115: p_msg_data=>x_msg_data,
1116: p_msg_type=>'SQL ERROR',
1117: p_msg_level=>fnd_log.level_error);
1118: END IF;
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;
1118: END IF;
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;
1124:
1125: end;
1126:
1221: END IF;
1222:
1223:
1224: -- Debug info.
1225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1226: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(+)',
1227: p_prefix=>l_debug_prefix,
1228: p_msg_level=>fnd_log.level_procedure);
1229: END IF;
1224: -- Debug info.
1225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1226: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(+)',
1227: p_prefix=>l_debug_prefix,
1228: p_msg_level=>fnd_log.level_procedure);
1229: END IF;
1230:
1231: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1232: p_party_id => null,
1252:
1253:
1254:
1255: -- Debug info.
1256: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1258: p_msg_data=>x_msg_data,
1259: p_msg_type=>'WARNING',
1260: p_msg_level=>fnd_log.level_exception);
1256: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1258: p_msg_data=>x_msg_data,
1259: p_msg_type=>'WARNING',
1260: p_msg_level=>fnd_log.level_exception);
1261: END IF;
1262:
1263: -- Debug info.
1264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1260: p_msg_level=>fnd_log.level_exception);
1261: END IF;
1262:
1263: -- Debug info.
1264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1265: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created (-)',
1266: p_prefix=>l_debug_prefix,
1267: p_msg_level=>fnd_log.level_procedure);
1268: END IF;
1263: -- Debug info.
1264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1265: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created (-)',
1266: p_prefix=>l_debug_prefix,
1267: p_msg_level=>fnd_log.level_procedure);
1268: END IF;
1269:
1270:
1271: EXCEPTION
1277: p_count => x_msg_count,
1278: p_data => x_msg_data);
1279:
1280: -- Debug info.
1281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1283: p_msg_data=>x_msg_data,
1284: p_msg_type=>'ERROR',
1285: p_msg_level=>fnd_log.level_error);
1281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1283: p_msg_data=>x_msg_data,
1284: p_msg_type=>'ERROR',
1285: p_msg_level=>fnd_log.level_error);
1286: END IF;
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1289: p_prefix=>l_debug_prefix,
1283: p_msg_data=>x_msg_data,
1284: p_msg_type=>'ERROR',
1285: p_msg_level=>fnd_log.level_error);
1286: END IF;
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1289: p_prefix=>l_debug_prefix,
1290: p_msg_level=>fnd_log.level_procedure);
1291: END IF;
1286: END IF;
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1289: p_prefix=>l_debug_prefix,
1290: p_msg_level=>fnd_log.level_procedure);
1291: END IF;
1292: WHEN fnd_api.g_exc_unexpected_error THEN
1293: x_return_status := fnd_api.g_ret_sts_unexp_error;
1294:
1296: p_count => x_msg_count,
1297: p_data => x_msg_data);
1298:
1299: -- Debug info.
1300: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1301: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1302: p_msg_data=>x_msg_data,
1303: p_msg_type=>'UNEXPECTED ERROR',
1304: p_msg_level=>fnd_log.level_error);
1300: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1301: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1302: p_msg_data=>x_msg_data,
1303: p_msg_type=>'UNEXPECTED ERROR',
1304: p_msg_level=>fnd_log.level_error);
1305: END IF;
1306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1307: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1308: p_prefix=>l_debug_prefix,
1302: p_msg_data=>x_msg_data,
1303: p_msg_type=>'UNEXPECTED ERROR',
1304: p_msg_level=>fnd_log.level_error);
1305: END IF;
1306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1307: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1308: p_prefix=>l_debug_prefix,
1309: p_msg_level=>fnd_log.level_procedure);
1310: END IF;
1305: END IF;
1306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1307: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1308: p_prefix=>l_debug_prefix,
1309: p_msg_level=>fnd_log.level_procedure);
1310: END IF;
1311: WHEN OTHERS THEN
1312: x_return_status := fnd_api.g_ret_sts_unexp_error;
1313:
1319: p_count => x_msg_count,
1320: p_data => x_msg_data);
1321:
1322: -- Debug info.
1323: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1324: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1325: p_msg_data=>x_msg_data,
1326: p_msg_type=>'SQL ERROR',
1327: p_msg_level=>fnd_log.level_error);
1323: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1324: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1325: p_msg_data=>x_msg_data,
1326: p_msg_type=>'SQL ERROR',
1327: p_msg_level=>fnd_log.level_error);
1328: END IF;
1329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1330: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1331: p_prefix=>l_debug_prefix,
1325: p_msg_data=>x_msg_data,
1326: p_msg_type=>'SQL ERROR',
1327: p_msg_level=>fnd_log.level_error);
1328: END IF;
1329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1330: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1331: p_prefix=>l_debug_prefix,
1332: p_msg_level=>fnd_log.level_procedure);
1333: END IF;
1328: END IF;
1329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1330: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1331: p_prefix=>l_debug_prefix,
1332: p_msg_level=>fnd_log.level_procedure);
1333: END IF;
1334:
1335: end;
1336:
1428: END IF;
1429:
1430:
1431: -- Debug info.
1432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1433: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(+)',
1434: p_prefix=>l_debug_prefix,
1435: p_msg_level=>fnd_log.level_procedure);
1436: END IF;
1431: -- Debug info.
1432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1433: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(+)',
1434: p_prefix=>l_debug_prefix,
1435: p_msg_level=>fnd_log.level_procedure);
1436: END IF;
1437:
1438: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1439: p_party_id => null,
1459:
1460:
1461:
1462: -- Debug info.
1463: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1464: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1465: p_msg_data=>x_msg_data,
1466: p_msg_type=>'WARNING',
1467: p_msg_level=>fnd_log.level_exception);
1463: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1464: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1465: p_msg_data=>x_msg_data,
1466: p_msg_type=>'WARNING',
1467: p_msg_level=>fnd_log.level_exception);
1468: END IF;
1469:
1470: -- Debug info.
1471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1467: p_msg_level=>fnd_log.level_exception);
1468: END IF;
1469:
1470: -- Debug info.
1471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1472: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated (-)',
1473: p_prefix=>l_debug_prefix,
1474: p_msg_level=>fnd_log.level_procedure);
1475: END IF;
1470: -- Debug info.
1471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1472: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated (-)',
1473: p_prefix=>l_debug_prefix,
1474: p_msg_level=>fnd_log.level_procedure);
1475: END IF;
1476:
1477:
1478: EXCEPTION
1484: p_count => x_msg_count,
1485: p_data => x_msg_data);
1486:
1487: -- Debug info.
1488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1490: p_msg_data=>x_msg_data,
1491: p_msg_type=>'ERROR',
1492: p_msg_level=>fnd_log.level_error);
1488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1490: p_msg_data=>x_msg_data,
1491: p_msg_type=>'ERROR',
1492: p_msg_level=>fnd_log.level_error);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1496: p_prefix=>l_debug_prefix,
1490: p_msg_data=>x_msg_data,
1491: p_msg_type=>'ERROR',
1492: p_msg_level=>fnd_log.level_error);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1496: p_prefix=>l_debug_prefix,
1497: p_msg_level=>fnd_log.level_procedure);
1498: END IF;
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1496: p_prefix=>l_debug_prefix,
1497: p_msg_level=>fnd_log.level_procedure);
1498: END IF;
1499: WHEN fnd_api.g_exc_unexpected_error THEN
1500: x_return_status := fnd_api.g_ret_sts_unexp_error;
1501:
1503: p_count => x_msg_count,
1504: p_data => x_msg_data);
1505:
1506: -- Debug info.
1507: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1508: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1509: p_msg_data=>x_msg_data,
1510: p_msg_type=>'UNEXPECTED ERROR',
1511: p_msg_level=>fnd_log.level_error);
1507: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1508: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1509: p_msg_data=>x_msg_data,
1510: p_msg_type=>'UNEXPECTED ERROR',
1511: p_msg_level=>fnd_log.level_error);
1512: END IF;
1513: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1514: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1515: p_prefix=>l_debug_prefix,
1509: p_msg_data=>x_msg_data,
1510: p_msg_type=>'UNEXPECTED ERROR',
1511: p_msg_level=>fnd_log.level_error);
1512: END IF;
1513: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1514: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1515: p_prefix=>l_debug_prefix,
1516: p_msg_level=>fnd_log.level_procedure);
1517: END IF;
1512: END IF;
1513: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1514: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1515: p_prefix=>l_debug_prefix,
1516: p_msg_level=>fnd_log.level_procedure);
1517: END IF;
1518: WHEN OTHERS THEN
1519: x_return_status := fnd_api.g_ret_sts_unexp_error;
1520:
1526: p_count => x_msg_count,
1527: p_data => x_msg_data);
1528:
1529: -- Debug info.
1530: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1532: p_msg_data=>x_msg_data,
1533: p_msg_type=>'SQL ERROR',
1534: p_msg_level=>fnd_log.level_error);
1530: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1532: p_msg_data=>x_msg_data,
1533: p_msg_type=>'SQL ERROR',
1534: p_msg_level=>fnd_log.level_error);
1535: END IF;
1536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1537: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1538: p_prefix=>l_debug_prefix,
1532: p_msg_data=>x_msg_data,
1533: p_msg_type=>'SQL ERROR',
1534: p_msg_level=>fnd_log.level_error);
1535: END IF;
1536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1537: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1538: p_prefix=>l_debug_prefix,
1539: p_msg_level=>fnd_log.level_procedure);
1540: END IF;
1535: END IF;
1536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1537: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1538: p_prefix=>l_debug_prefix,
1539: p_msg_level=>fnd_log.level_procedure);
1540: END IF;
1541:
1542: end;
1543:
1587: END IF;
1588:
1589:
1590: -- Debug info.
1591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1592: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(+)',
1593: p_prefix=>l_debug_prefix,
1594: p_msg_level=>fnd_log.level_procedure);
1595: END IF;
1590: -- Debug info.
1591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1592: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(+)',
1593: p_prefix=>l_debug_prefix,
1594: p_msg_level=>fnd_log.level_procedure);
1595: END IF;
1596:
1597: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1598: p_party_id => p_org_cust_id,
1619:
1620:
1621:
1622: -- Debug info.
1623: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1624: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1625: p_msg_data=>x_msg_data,
1626: p_msg_type=>'WARNING',
1627: p_msg_level=>fnd_log.level_exception);
1623: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1624: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1625: p_msg_data=>x_msg_data,
1626: p_msg_type=>'WARNING',
1627: p_msg_level=>fnd_log.level_exception);
1628: END IF;
1629:
1630: -- Debug info.
1631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1627: p_msg_level=>fnd_log.level_exception);
1628: END IF;
1629:
1630: -- Debug info.
1631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1632: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated (-)',
1633: p_prefix=>l_debug_prefix,
1634: p_msg_level=>fnd_log.level_procedure);
1635: END IF;
1630: -- Debug info.
1631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1632: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated (-)',
1633: p_prefix=>l_debug_prefix,
1634: p_msg_level=>fnd_log.level_procedure);
1635: END IF;
1636:
1637:
1638: EXCEPTION
1644: p_count => x_msg_count,
1645: p_data => x_msg_data);
1646:
1647: -- Debug info.
1648: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1649: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1650: p_msg_data=>x_msg_data,
1651: p_msg_type=>'ERROR',
1652: p_msg_level=>fnd_log.level_error);
1648: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1649: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1650: p_msg_data=>x_msg_data,
1651: p_msg_type=>'ERROR',
1652: p_msg_level=>fnd_log.level_error);
1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1656: p_prefix=>l_debug_prefix,
1650: p_msg_data=>x_msg_data,
1651: p_msg_type=>'ERROR',
1652: p_msg_level=>fnd_log.level_error);
1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1656: p_prefix=>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_procedure);
1658: END IF;
1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1656: p_prefix=>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_procedure);
1658: END IF;
1659: WHEN fnd_api.g_exc_unexpected_error THEN
1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661:
1663: p_count => x_msg_count,
1664: p_data => x_msg_data);
1665:
1666: -- Debug info.
1667: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1668: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1669: p_msg_data=>x_msg_data,
1670: p_msg_type=>'UNEXPECTED ERROR',
1671: p_msg_level=>fnd_log.level_error);
1667: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1668: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1669: p_msg_data=>x_msg_data,
1670: p_msg_type=>'UNEXPECTED ERROR',
1671: p_msg_level=>fnd_log.level_error);
1672: END IF;
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1675: p_prefix=>l_debug_prefix,
1669: p_msg_data=>x_msg_data,
1670: p_msg_type=>'UNEXPECTED ERROR',
1671: p_msg_level=>fnd_log.level_error);
1672: END IF;
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;
1672: END IF;
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;
1678: WHEN OTHERS THEN
1679: x_return_status := fnd_api.g_ret_sts_unexp_error;
1680:
1686: p_count => x_msg_count,
1687: p_data => x_msg_data);
1688:
1689: -- Debug info.
1690: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1692: p_msg_data=>x_msg_data,
1693: p_msg_type=>'SQL ERROR',
1694: p_msg_level=>fnd_log.level_error);
1690: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1692: p_msg_data=>x_msg_data,
1693: p_msg_type=>'SQL ERROR',
1694: p_msg_level=>fnd_log.level_error);
1695: END IF;
1696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1697: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1698: p_prefix=>l_debug_prefix,
1692: p_msg_data=>x_msg_data,
1693: p_msg_type=>'SQL ERROR',
1694: p_msg_level=>fnd_log.level_error);
1695: END IF;
1696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1697: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1698: p_prefix=>l_debug_prefix,
1699: p_msg_level=>fnd_log.level_procedure);
1700: END IF;
1695: END IF;
1696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1697: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1698: p_prefix=>l_debug_prefix,
1699: p_msg_level=>fnd_log.level_procedure);
1700: END IF;
1701:
1702: end;
1703:
1748: END IF;
1749:
1750:
1751: -- Debug info.
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(+)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;
1751: -- Debug info.
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(+)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;
1757:
1758: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1759: p_party_id => null,
1778: END IF;
1779:
1780:
1781: -- Debug info.
1782: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1784: p_msg_data=>x_msg_data,
1785: p_msg_type=>'WARNING',
1786: p_msg_level=>fnd_log.level_exception);
1782: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1784: p_msg_data=>x_msg_data,
1785: p_msg_type=>'WARNING',
1786: p_msg_level=>fnd_log.level_exception);
1787: END IF;
1788:
1789: -- Debug info.
1790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1786: p_msg_level=>fnd_log.level_exception);
1787: END IF;
1788:
1789: -- Debug info.
1790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1791: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created (-)',
1792: p_prefix=>l_debug_prefix,
1793: p_msg_level=>fnd_log.level_procedure);
1794: END IF;
1789: -- Debug info.
1790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1791: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created (-)',
1792: p_prefix=>l_debug_prefix,
1793: p_msg_level=>fnd_log.level_procedure);
1794: END IF;
1795:
1796:
1797: EXCEPTION
1803: p_count => x_msg_count,
1804: p_data => x_msg_data);
1805:
1806: -- Debug info.
1807: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1808: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1809: p_msg_data=>x_msg_data,
1810: p_msg_type=>'ERROR',
1811: p_msg_level=>fnd_log.level_error);
1807: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1808: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1809: p_msg_data=>x_msg_data,
1810: p_msg_type=>'ERROR',
1811: p_msg_level=>fnd_log.level_error);
1812: END IF;
1813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1814: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1815: p_prefix=>l_debug_prefix,
1809: p_msg_data=>x_msg_data,
1810: p_msg_type=>'ERROR',
1811: p_msg_level=>fnd_log.level_error);
1812: END IF;
1813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1814: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1815: p_prefix=>l_debug_prefix,
1816: p_msg_level=>fnd_log.level_procedure);
1817: END IF;
1812: END IF;
1813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1814: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1815: p_prefix=>l_debug_prefix,
1816: p_msg_level=>fnd_log.level_procedure);
1817: END IF;
1818: WHEN fnd_api.g_exc_unexpected_error THEN
1819: x_return_status := fnd_api.g_ret_sts_unexp_error;
1820:
1822: p_count => x_msg_count,
1823: p_data => x_msg_data);
1824:
1825: -- Debug info.
1826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1828: p_msg_data=>x_msg_data,
1829: p_msg_type=>'UNEXPECTED ERROR',
1830: p_msg_level=>fnd_log.level_error);
1826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1828: p_msg_data=>x_msg_data,
1829: p_msg_type=>'UNEXPECTED ERROR',
1830: p_msg_level=>fnd_log.level_error);
1831: END IF;
1832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1833: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1834: p_prefix=>l_debug_prefix,
1828: p_msg_data=>x_msg_data,
1829: p_msg_type=>'UNEXPECTED ERROR',
1830: p_msg_level=>fnd_log.level_error);
1831: END IF;
1832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1833: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1834: p_prefix=>l_debug_prefix,
1835: p_msg_level=>fnd_log.level_procedure);
1836: END IF;
1831: END IF;
1832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1833: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1834: p_prefix=>l_debug_prefix,
1835: p_msg_level=>fnd_log.level_procedure);
1836: END IF;
1837: WHEN OTHERS THEN
1838: x_return_status := fnd_api.g_ret_sts_unexp_error;
1839:
1845: p_count => x_msg_count,
1846: p_data => x_msg_data);
1847:
1848: -- Debug info.
1849: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1850: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1851: p_msg_data=>x_msg_data,
1852: p_msg_type=>'SQL ERROR',
1853: p_msg_level=>fnd_log.level_error);
1849: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1850: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1851: p_msg_data=>x_msg_data,
1852: p_msg_type=>'SQL ERROR',
1853: p_msg_level=>fnd_log.level_error);
1854: END IF;
1855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1856: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1857: p_prefix=>l_debug_prefix,
1851: p_msg_data=>x_msg_data,
1852: p_msg_type=>'SQL ERROR',
1853: p_msg_level=>fnd_log.level_error);
1854: END IF;
1855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1856: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1857: p_prefix=>l_debug_prefix,
1858: p_msg_level=>fnd_log.level_procedure);
1859: END IF;
1854: END IF;
1855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1856: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1857: p_prefix=>l_debug_prefix,
1858: p_msg_level=>fnd_log.level_procedure);
1859: END IF;
1860:
1861: end;
1862:
1882: END IF;
1883:
1884:
1885: -- Debug info.
1886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1887: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(+)',
1888: p_prefix=>l_debug_prefix,
1889: p_msg_level=>fnd_log.level_procedure);
1890: END IF;
1885: -- Debug info.
1886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1887: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(+)',
1888: p_prefix=>l_debug_prefix,
1889: p_msg_level=>fnd_log.level_procedure);
1890: END IF;
1891:
1892: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1893: p_party_id => null,
1913: END IF;
1914:
1915:
1916: -- Debug info.
1917: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'WARNING',
1921: p_msg_level=>fnd_log.level_exception);
1917: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'WARNING',
1921: p_msg_level=>fnd_log.level_exception);
1922: END IF;
1923:
1924: -- Debug info.
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: p_msg_level=>fnd_log.level_exception);
1922: END IF;
1923:
1924: -- Debug info.
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated (-)',
1927: p_prefix=>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_procedure);
1929: END IF;
1924: -- Debug info.
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated (-)',
1927: p_prefix=>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_procedure);
1929: END IF;
1930:
1931:
1932: EXCEPTION
1938: p_count => x_msg_count,
1939: p_data => x_msg_data);
1940:
1941: -- Debug info.
1942: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1943: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1944: p_msg_data=>x_msg_data,
1945: p_msg_type=>'ERROR',
1946: p_msg_level=>fnd_log.level_error);
1942: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1943: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1944: p_msg_data=>x_msg_data,
1945: p_msg_type=>'ERROR',
1946: p_msg_level=>fnd_log.level_error);
1947: END IF;
1948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1949: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1950: p_prefix=>l_debug_prefix,
1944: p_msg_data=>x_msg_data,
1945: p_msg_type=>'ERROR',
1946: p_msg_level=>fnd_log.level_error);
1947: END IF;
1948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1949: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1950: p_prefix=>l_debug_prefix,
1951: p_msg_level=>fnd_log.level_procedure);
1952: END IF;
1947: END IF;
1948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1949: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1950: p_prefix=>l_debug_prefix,
1951: p_msg_level=>fnd_log.level_procedure);
1952: END IF;
1953: WHEN fnd_api.g_exc_unexpected_error THEN
1954: x_return_status := fnd_api.g_ret_sts_unexp_error;
1955:
1957: p_count => x_msg_count,
1958: p_data => x_msg_data);
1959:
1960: -- Debug info.
1961: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1962: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1963: p_msg_data=>x_msg_data,
1964: p_msg_type=>'UNEXPECTED ERROR',
1965: p_msg_level=>fnd_log.level_error);
1961: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1962: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1963: p_msg_data=>x_msg_data,
1964: p_msg_type=>'UNEXPECTED ERROR',
1965: p_msg_level=>fnd_log.level_error);
1966: END IF;
1967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1968: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1969: p_prefix=>l_debug_prefix,
1963: p_msg_data=>x_msg_data,
1964: p_msg_type=>'UNEXPECTED ERROR',
1965: p_msg_level=>fnd_log.level_error);
1966: END IF;
1967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1968: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1969: p_prefix=>l_debug_prefix,
1970: p_msg_level=>fnd_log.level_procedure);
1971: END IF;
1966: END IF;
1967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1968: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1969: p_prefix=>l_debug_prefix,
1970: p_msg_level=>fnd_log.level_procedure);
1971: END IF;
1972: WHEN OTHERS THEN
1973: x_return_status := fnd_api.g_ret_sts_unexp_error;
1974:
1980: p_count => x_msg_count,
1981: p_data => x_msg_data);
1982:
1983: -- Debug info.
1984: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1985: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1986: p_msg_data=>x_msg_data,
1987: p_msg_type=>'SQL ERROR',
1988: p_msg_level=>fnd_log.level_error);
1984: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1985: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1986: p_msg_data=>x_msg_data,
1987: p_msg_type=>'SQL ERROR',
1988: p_msg_level=>fnd_log.level_error);
1989: END IF;
1990: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1991: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1992: p_prefix=>l_debug_prefix,
1986: p_msg_data=>x_msg_data,
1987: p_msg_type=>'SQL ERROR',
1988: p_msg_level=>fnd_log.level_error);
1989: END IF;
1990: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1991: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1992: p_prefix=>l_debug_prefix,
1993: p_msg_level=>fnd_log.level_procedure);
1994: END IF;
1989: END IF;
1990: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1991: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1992: p_prefix=>l_debug_prefix,
1993: p_msg_level=>fnd_log.level_procedure);
1994: END IF;
1995:
1996: end;
1997:
2032: FND_MSG_PUB.initialize;
2033: END IF;
2034:
2035: -- Debug info.
2036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2037: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(+)',
2038: p_prefix=>l_debug_prefix,
2039: p_msg_level=>fnd_log.level_procedure);
2040: END IF;
2035: -- Debug info.
2036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2037: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(+)',
2038: p_prefix=>l_debug_prefix,
2039: p_msg_level=>fnd_log.level_procedure);
2040: END IF;
2041:
2042: -- Base on p_validate_bo_flag, check the completeness of business objects
2043: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
2150: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2151: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2152:
2153: -- Debug info.
2154: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2155: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2156: p_msg_data=>x_msg_data,
2157: p_msg_type=>'WARNING',
2158: p_msg_level=>fnd_log.level_exception);
2154: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2155: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2156: p_msg_data=>x_msg_data,
2157: p_msg_type=>'WARNING',
2158: p_msg_level=>fnd_log.level_exception);
2159: END IF;
2160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2161: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2162: p_prefix=>l_debug_prefix,
2156: p_msg_data=>x_msg_data,
2157: p_msg_type=>'WARNING',
2158: p_msg_level=>fnd_log.level_exception);
2159: END IF;
2160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2161: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2162: p_prefix=>l_debug_prefix,
2163: p_msg_level=>fnd_log.level_procedure);
2164: END IF;
2159: END IF;
2160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2161: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2162: p_prefix=>l_debug_prefix,
2163: p_msg_level=>fnd_log.level_procedure);
2164: END IF;
2165: EXCEPTION
2166: WHEN fnd_api.g_exc_error THEN
2167: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2180: p_count => x_msg_count,
2181: p_data => x_msg_data);
2182:
2183: -- Debug info.
2184: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2185: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2186: p_msg_data=>x_msg_data,
2187: p_msg_type=>'ERROR',
2188: p_msg_level=>fnd_log.level_error);
2184: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2185: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2186: p_msg_data=>x_msg_data,
2187: p_msg_type=>'ERROR',
2188: p_msg_level=>fnd_log.level_error);
2189: END IF;
2190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2191: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2192: p_prefix=>l_debug_prefix,
2186: p_msg_data=>x_msg_data,
2187: p_msg_type=>'ERROR',
2188: p_msg_level=>fnd_log.level_error);
2189: END IF;
2190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2191: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2192: p_prefix=>l_debug_prefix,
2193: p_msg_level=>fnd_log.level_procedure);
2194: END IF;
2189: END IF;
2190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2191: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2192: p_prefix=>l_debug_prefix,
2193: p_msg_level=>fnd_log.level_procedure);
2194: END IF;
2195:
2196: WHEN fnd_api.g_exc_unexpected_error THEN
2197: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2210: p_count => x_msg_count,
2211: p_data => x_msg_data);
2212:
2213: -- Debug info.
2214: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2215: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2216: p_msg_data=>x_msg_data,
2217: p_msg_type=>'UNEXPECTED ERROR',
2218: p_msg_level=>fnd_log.level_error);
2214: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2215: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2216: p_msg_data=>x_msg_data,
2217: p_msg_type=>'UNEXPECTED ERROR',
2218: p_msg_level=>fnd_log.level_error);
2219: END IF;
2220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2221: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2222: p_prefix=>l_debug_prefix,
2216: p_msg_data=>x_msg_data,
2217: p_msg_type=>'UNEXPECTED ERROR',
2218: p_msg_level=>fnd_log.level_error);
2219: END IF;
2220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2221: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2222: p_prefix=>l_debug_prefix,
2223: p_msg_level=>fnd_log.level_procedure);
2224: END IF;
2219: END IF;
2220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2221: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2222: p_prefix=>l_debug_prefix,
2223: p_msg_level=>fnd_log.level_procedure);
2224: END IF;
2225:
2226: WHEN OTHERS THEN
2227: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2244: p_count => x_msg_count,
2245: p_data => x_msg_data);
2246:
2247: -- Debug info.
2248: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2249: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2250: p_msg_data=>x_msg_data,
2251: p_msg_type=>'SQL ERROR',
2252: p_msg_level=>fnd_log.level_error);
2248: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2249: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2250: p_msg_data=>x_msg_data,
2251: p_msg_type=>'SQL ERROR',
2252: p_msg_level=>fnd_log.level_error);
2253: END IF;
2254: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2255: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2256: p_prefix=>l_debug_prefix,
2250: p_msg_data=>x_msg_data,
2251: p_msg_type=>'SQL ERROR',
2252: p_msg_level=>fnd_log.level_error);
2253: END IF;
2254: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2255: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2256: p_prefix=>l_debug_prefix,
2257: p_msg_level=>fnd_log.level_procedure);
2258: END IF;
2253: END IF;
2254: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2255: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',
2256: p_prefix=>l_debug_prefix,
2257: p_msg_level=>fnd_log.level_procedure);
2258: END IF;
2259: END do_create_org_cust_v2_bo;
2260:
2261:
2329: FND_MSG_PUB.initialize;
2330: END IF;
2331:
2332: -- Debug info.
2333: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2334: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2335: p_prefix=>l_debug_prefix,
2336: p_msg_level=>fnd_log.level_procedure);
2337: END IF;
2332: -- Debug info.
2333: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2334: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2335: p_prefix=>l_debug_prefix,
2336: p_msg_level=>fnd_log.level_procedure);
2337: END IF;
2338:
2339: -- initialize Global variable to indicate the caller of V2API is from BO API
2340: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2460: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2461: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2462:
2463: -- Debug info.
2464: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2466: p_msg_data=>x_msg_data,
2467: p_msg_type=>'WARNING',
2468: p_msg_level=>fnd_log.level_exception);
2464: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2466: p_msg_data=>x_msg_data,
2467: p_msg_type=>'WARNING',
2468: p_msg_level=>fnd_log.level_exception);
2469: END IF;
2470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2471: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2472: p_prefix=>l_debug_prefix,
2466: p_msg_data=>x_msg_data,
2467: p_msg_type=>'WARNING',
2468: p_msg_level=>fnd_log.level_exception);
2469: END IF;
2470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2471: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2472: p_prefix=>l_debug_prefix,
2473: p_msg_level=>fnd_log.level_procedure);
2474: END IF;
2469: END IF;
2470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2471: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2472: p_prefix=>l_debug_prefix,
2473: p_msg_level=>fnd_log.level_procedure);
2474: END IF;
2475:
2476: EXCEPTION
2477: WHEN fnd_api.g_exc_error THEN
2492: p_count => x_msg_count,
2493: p_data => x_msg_data);
2494:
2495: -- Debug info.
2496: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2497: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2498: p_msg_data=>x_msg_data,
2499: p_msg_type=>'ERROR',
2500: p_msg_level=>fnd_log.level_error);
2496: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2497: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2498: p_msg_data=>x_msg_data,
2499: p_msg_type=>'ERROR',
2500: p_msg_level=>fnd_log.level_error);
2501: END IF;
2502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2503: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2504: p_prefix=>l_debug_prefix,
2498: p_msg_data=>x_msg_data,
2499: p_msg_type=>'ERROR',
2500: p_msg_level=>fnd_log.level_error);
2501: END IF;
2502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2503: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2504: p_prefix=>l_debug_prefix,
2505: p_msg_level=>fnd_log.level_procedure);
2506: END IF;
2501: END IF;
2502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2503: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2504: p_prefix=>l_debug_prefix,
2505: p_msg_level=>fnd_log.level_procedure);
2506: END IF;
2507:
2508: WHEN fnd_api.g_exc_unexpected_error THEN
2509: ROLLBACK TO do_update_org_cust_v2_bo_pub;
2523: p_count => x_msg_count,
2524: p_data => x_msg_data);
2525:
2526: -- Debug info.
2527: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2528: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2529: p_msg_data=>x_msg_data,
2530: p_msg_type=>'UNEXPECTED ERROR',
2531: p_msg_level=>fnd_log.level_error);
2527: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2528: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2529: p_msg_data=>x_msg_data,
2530: p_msg_type=>'UNEXPECTED ERROR',
2531: p_msg_level=>fnd_log.level_error);
2532: END IF;
2533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2534: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2535: p_prefix=>l_debug_prefix,
2529: p_msg_data=>x_msg_data,
2530: p_msg_type=>'UNEXPECTED ERROR',
2531: p_msg_level=>fnd_log.level_error);
2532: END IF;
2533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2534: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2535: p_prefix=>l_debug_prefix,
2536: p_msg_level=>fnd_log.level_procedure);
2537: END IF;
2532: END IF;
2533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2534: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2535: p_prefix=>l_debug_prefix,
2536: p_msg_level=>fnd_log.level_procedure);
2537: END IF;
2538:
2539: WHEN OTHERS THEN
2540: ROLLBACK TO do_update_org_cust_v2_bo_pub;
2558: p_count => x_msg_count,
2559: p_data => x_msg_data);
2560:
2561: -- Debug info.
2562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2563: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2564: p_msg_data=>x_msg_data,
2565: p_msg_type=>'SQL ERROR',
2566: p_msg_level=>fnd_log.level_error);
2562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2563: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2564: p_msg_data=>x_msg_data,
2565: p_msg_type=>'SQL ERROR',
2566: p_msg_level=>fnd_log.level_error);
2567: END IF;
2568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2569: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2570: p_prefix=>l_debug_prefix,
2564: p_msg_data=>x_msg_data,
2565: p_msg_type=>'SQL ERROR',
2566: p_msg_level=>fnd_log.level_error);
2567: END IF;
2568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2569: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2570: p_prefix=>l_debug_prefix,
2571: p_msg_level=>fnd_log.level_procedure);
2572: END IF;
2567: END IF;
2568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2569: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2570: p_prefix=>l_debug_prefix,
2571: p_msg_level=>fnd_log.level_procedure);
2572: END IF;
2573: END do_update_org_cust_v2_bo;
2574:
2575:
2636: FND_MSG_PUB.initialize;
2637: END IF;
2638:
2639: -- Debug info.
2640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2641: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(+)',
2642: p_prefix=>l_debug_prefix,
2643: p_msg_level=>fnd_log.level_procedure);
2644: END IF;
2639: -- Debug info.
2640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2641: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(+)',
2642: p_prefix=>l_debug_prefix,
2643: p_msg_level=>fnd_log.level_procedure);
2644: END IF;
2645:
2646: l_organization_id := p_org_cust_v2_obj.organization_obj.organization_id;
2647: l_organization_os := p_org_cust_v2_obj.organization_obj.orig_system;
2695: RAISE fnd_api.g_exc_error;
2696: END IF;
2697:
2698: -- Debug info.
2699: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2700: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2701: p_msg_data=>x_msg_data,
2702: p_msg_type=>'WARNING',
2703: p_msg_level=>fnd_log.level_exception);
2699: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2700: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2701: p_msg_data=>x_msg_data,
2702: p_msg_type=>'WARNING',
2703: p_msg_level=>fnd_log.level_exception);
2704: END IF;
2705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2706: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2707: p_prefix=>l_debug_prefix,
2701: p_msg_data=>x_msg_data,
2702: p_msg_type=>'WARNING',
2703: p_msg_level=>fnd_log.level_exception);
2704: END IF;
2705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2706: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2707: p_prefix=>l_debug_prefix,
2708: p_msg_level=>fnd_log.level_procedure);
2709: END IF;
2704: END IF;
2705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2706: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2707: p_prefix=>l_debug_prefix,
2708: p_msg_level=>fnd_log.level_procedure);
2709: END IF;
2710:
2711: EXCEPTION
2712: WHEN fnd_api.g_exc_error THEN
2716: p_count => x_msg_count,
2717: p_data => x_msg_data);
2718:
2719: -- Debug info.
2720: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2721: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2722: p_msg_data=>x_msg_data,
2723: p_msg_type=>'ERROR',
2724: p_msg_level=>fnd_log.level_error);
2720: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2721: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2722: p_msg_data=>x_msg_data,
2723: p_msg_type=>'ERROR',
2724: p_msg_level=>fnd_log.level_error);
2725: END IF;
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2728: p_prefix=>l_debug_prefix,
2722: p_msg_data=>x_msg_data,
2723: p_msg_type=>'ERROR',
2724: p_msg_level=>fnd_log.level_error);
2725: END IF;
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2725: END IF;
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2731:
2732: WHEN fnd_api.g_exc_unexpected_error THEN
2733: x_return_status := fnd_api.g_ret_sts_unexp_error;
2736: p_count => x_msg_count,
2737: p_data => x_msg_data);
2738:
2739: -- Debug info.
2740: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2741: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2742: p_msg_data=>x_msg_data,
2743: p_msg_type=>'UNEXPECTED ERROR',
2744: p_msg_level=>fnd_log.level_error);
2740: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2741: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2742: p_msg_data=>x_msg_data,
2743: p_msg_type=>'UNEXPECTED ERROR',
2744: p_msg_level=>fnd_log.level_error);
2745: END IF;
2746: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2747: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2748: p_prefix=>l_debug_prefix,
2742: p_msg_data=>x_msg_data,
2743: p_msg_type=>'UNEXPECTED ERROR',
2744: p_msg_level=>fnd_log.level_error);
2745: END IF;
2746: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2747: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2748: p_prefix=>l_debug_prefix,
2749: p_msg_level=>fnd_log.level_procedure);
2750: END IF;
2745: END IF;
2746: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2747: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2748: p_prefix=>l_debug_prefix,
2749: p_msg_level=>fnd_log.level_procedure);
2750: END IF;
2751: WHEN OTHERS THEN
2752: x_return_status := fnd_api.g_ret_sts_unexp_error;
2753:
2759: p_count => x_msg_count,
2760: p_data => x_msg_data);
2761:
2762: -- Debug info.
2763: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2764: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2765: p_msg_data=>x_msg_data,
2766: p_msg_type=>'SQL ERROR',
2767: p_msg_level=>fnd_log.level_error);
2763: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2764: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2765: p_msg_data=>x_msg_data,
2766: p_msg_type=>'SQL ERROR',
2767: p_msg_level=>fnd_log.level_error);
2768: END IF;
2769: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2770: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2771: p_prefix=>l_debug_prefix,
2765: p_msg_data=>x_msg_data,
2766: p_msg_type=>'SQL ERROR',
2767: p_msg_level=>fnd_log.level_error);
2768: END IF;
2769: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2770: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2771: p_prefix=>l_debug_prefix,
2772: p_msg_level=>fnd_log.level_procedure);
2773: END IF;
2768: END IF;
2769: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2770: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2771: p_prefix=>l_debug_prefix,
2772: p_msg_level=>fnd_log.level_procedure);
2773: END IF;
2774: END do_save_org_cust_v2_bo;
2775:
2776:
2889: END IF;
2890:
2891:
2892: -- Debug info.
2893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2894: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo(+)',
2895: p_prefix=>l_debug_prefix,
2896: p_msg_level=>fnd_log.level_procedure);
2897: END IF;
2892: -- Debug info.
2893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2894: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo(+)',
2895: p_prefix=>l_debug_prefix,
2896: p_msg_level=>fnd_log.level_procedure);
2897: END IF;
2898:
2899: -- check if pass in contact_point_id and/or os+osr
2900: -- extraction validation logic is same as update
2930: END IF;
2931:
2932:
2933: -- Debug info.
2934: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2936: p_msg_data=>x_msg_data,
2937: p_msg_type=>'WARNING',
2938: p_msg_level=>fnd_log.level_exception);
2934: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2936: p_msg_data=>x_msg_data,
2937: p_msg_type=>'WARNING',
2938: p_msg_level=>fnd_log.level_exception);
2939: END IF;
2940:
2941: -- Debug info.
2942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2938: p_msg_level=>fnd_log.level_exception);
2939: END IF;
2940:
2941: -- Debug info.
2942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2943: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2944: p_prefix=>l_debug_prefix,
2945: p_msg_level=>fnd_log.level_procedure);
2946: END IF;
2941: -- Debug info.
2942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2943: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2944: p_prefix=>l_debug_prefix,
2945: p_msg_level=>fnd_log.level_procedure);
2946: END IF;
2947:
2948:
2949: EXCEPTION
2955: p_count => x_msg_count,
2956: p_data => x_msg_data);
2957:
2958: -- Debug info.
2959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2960: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2961: p_msg_data=>x_msg_data,
2962: p_msg_type=>'ERROR',
2963: p_msg_level=>fnd_log.level_error);
2959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2960: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2961: p_msg_data=>x_msg_data,
2962: p_msg_type=>'ERROR',
2963: p_msg_level=>fnd_log.level_error);
2964: END IF;
2965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2967: p_prefix=>l_debug_prefix,
2961: p_msg_data=>x_msg_data,
2962: p_msg_type=>'ERROR',
2963: p_msg_level=>fnd_log.level_error);
2964: END IF;
2965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2967: p_prefix=>l_debug_prefix,
2968: p_msg_level=>fnd_log.level_procedure);
2969: END IF;
2964: END IF;
2965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2967: p_prefix=>l_debug_prefix,
2968: p_msg_level=>fnd_log.level_procedure);
2969: END IF;
2970: WHEN fnd_api.g_exc_unexpected_error THEN
2971: x_return_status := fnd_api.g_ret_sts_unexp_error;
2972:
2974: p_count => x_msg_count,
2975: p_data => x_msg_data);
2976:
2977: -- Debug info.
2978: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2979: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2980: p_msg_data=>x_msg_data,
2981: p_msg_type=>'UNEXPECTED ERROR',
2982: p_msg_level=>fnd_log.level_error);
2978: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2979: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2980: p_msg_data=>x_msg_data,
2981: p_msg_type=>'UNEXPECTED ERROR',
2982: p_msg_level=>fnd_log.level_error);
2983: END IF;
2984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2985: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2986: p_prefix=>l_debug_prefix,
2980: p_msg_data=>x_msg_data,
2981: p_msg_type=>'UNEXPECTED ERROR',
2982: p_msg_level=>fnd_log.level_error);
2983: END IF;
2984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2985: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2986: p_prefix=>l_debug_prefix,
2987: p_msg_level=>fnd_log.level_procedure);
2988: END IF;
2983: END IF;
2984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2985: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2986: p_prefix=>l_debug_prefix,
2987: p_msg_level=>fnd_log.level_procedure);
2988: END IF;
2989: WHEN OTHERS THEN
2990: x_return_status := fnd_api.g_ret_sts_unexp_error;
2991:
2997: p_count => x_msg_count,
2998: p_data => x_msg_data);
2999:
3000: -- Debug info.
3001: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3002: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3003: p_msg_data=>x_msg_data,
3004: p_msg_type=>'SQL ERROR',
3005: p_msg_level=>fnd_log.level_error);
3001: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3002: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3003: p_msg_data=>x_msg_data,
3004: p_msg_type=>'SQL ERROR',
3005: p_msg_level=>fnd_log.level_error);
3006: END IF;
3007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3008: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
3009: p_prefix=>l_debug_prefix,
3003: p_msg_data=>x_msg_data,
3004: p_msg_type=>'SQL ERROR',
3005: p_msg_level=>fnd_log.level_error);
3006: END IF;
3007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3008: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
3009: p_prefix=>l_debug_prefix,
3010: p_msg_level=>fnd_log.level_procedure);
3011: END IF;
3006: END IF;
3007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3008: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
3009: p_prefix=>l_debug_prefix,
3010: p_msg_level=>fnd_log.level_procedure);
3011: END IF;
3012:
3013: end;
3014:
3108: END IF;
3109:
3110:
3111: -- Debug info.
3112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3113: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(+)',
3114: p_prefix=>l_debug_prefix,
3115: p_msg_level=>fnd_log.level_procedure);
3116: END IF;
3111: -- Debug info.
3112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3113: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(+)',
3114: p_prefix=>l_debug_prefix,
3115: p_msg_level=>fnd_log.level_procedure);
3116: END IF;
3117:
3118: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3119: p_party_id => null,
3139:
3140:
3141:
3142: -- Debug info.
3143: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3144: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3145: p_msg_data=>x_msg_data,
3146: p_msg_type=>'WARNING',
3147: p_msg_level=>fnd_log.level_exception);
3143: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3144: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3145: p_msg_data=>x_msg_data,
3146: p_msg_type=>'WARNING',
3147: p_msg_level=>fnd_log.level_exception);
3148: END IF;
3149:
3150: -- Debug info.
3151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3147: p_msg_level=>fnd_log.level_exception);
3148: END IF;
3149:
3150: -- Debug info.
3151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3152: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created (-)',
3153: p_prefix=>l_debug_prefix,
3154: p_msg_level=>fnd_log.level_procedure);
3155: END IF;
3150: -- Debug info.
3151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3152: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created (-)',
3153: p_prefix=>l_debug_prefix,
3154: p_msg_level=>fnd_log.level_procedure);
3155: END IF;
3156:
3157:
3158: EXCEPTION
3164: p_count => x_msg_count,
3165: p_data => x_msg_data);
3166:
3167: -- Debug info.
3168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3170: p_msg_data=>x_msg_data,
3171: p_msg_type=>'ERROR',
3172: p_msg_level=>fnd_log.level_error);
3168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3170: p_msg_data=>x_msg_data,
3171: p_msg_type=>'ERROR',
3172: p_msg_level=>fnd_log.level_error);
3173: END IF;
3174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3175: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3176: p_prefix=>l_debug_prefix,
3170: p_msg_data=>x_msg_data,
3171: p_msg_type=>'ERROR',
3172: p_msg_level=>fnd_log.level_error);
3173: END IF;
3174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3175: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3176: p_prefix=>l_debug_prefix,
3177: p_msg_level=>fnd_log.level_procedure);
3178: END IF;
3173: END IF;
3174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3175: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3176: p_prefix=>l_debug_prefix,
3177: p_msg_level=>fnd_log.level_procedure);
3178: END IF;
3179: WHEN fnd_api.g_exc_unexpected_error THEN
3180: x_return_status := fnd_api.g_ret_sts_unexp_error;
3181:
3183: p_count => x_msg_count,
3184: p_data => x_msg_data);
3185:
3186: -- Debug info.
3187: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3188: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3189: p_msg_data=>x_msg_data,
3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3187: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3188: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3189: p_msg_data=>x_msg_data,
3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3195: p_prefix=>l_debug_prefix,
3189: p_msg_data=>x_msg_data,
3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3195: p_prefix=>l_debug_prefix,
3196: p_msg_level=>fnd_log.level_procedure);
3197: END IF;
3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3195: p_prefix=>l_debug_prefix,
3196: p_msg_level=>fnd_log.level_procedure);
3197: END IF;
3198: WHEN OTHERS THEN
3199: x_return_status := fnd_api.g_ret_sts_unexp_error;
3200:
3206: p_count => x_msg_count,
3207: p_data => x_msg_data);
3208:
3209: -- Debug info.
3210: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3211: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3212: p_msg_data=>x_msg_data,
3213: p_msg_type=>'SQL ERROR',
3214: p_msg_level=>fnd_log.level_error);
3210: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3211: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3212: p_msg_data=>x_msg_data,
3213: p_msg_type=>'SQL ERROR',
3214: p_msg_level=>fnd_log.level_error);
3215: END IF;
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3218: p_prefix=>l_debug_prefix,
3212: p_msg_data=>x_msg_data,
3213: p_msg_type=>'SQL ERROR',
3214: p_msg_level=>fnd_log.level_error);
3215: END IF;
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3218: p_prefix=>l_debug_prefix,
3219: p_msg_level=>fnd_log.level_procedure);
3220: END IF;
3215: END IF;
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3218: p_prefix=>l_debug_prefix,
3219: p_msg_level=>fnd_log.level_procedure);
3220: END IF;
3221:
3222: end;
3223:
3310: END IF;
3311:
3312:
3313: -- Debug info.
3314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3315: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(+)',
3316: p_prefix=>l_debug_prefix,
3317: p_msg_level=>fnd_log.level_procedure);
3318: END IF;
3313: -- Debug info.
3314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3315: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(+)',
3316: p_prefix=>l_debug_prefix,
3317: p_msg_level=>fnd_log.level_procedure);
3318: END IF;
3319:
3320: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3321: p_party_id => null,
3341:
3342:
3343:
3344: -- Debug info.
3345: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3346: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3347: p_msg_data=>x_msg_data,
3348: p_msg_type=>'WARNING',
3349: p_msg_level=>fnd_log.level_exception);
3345: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3346: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3347: p_msg_data=>x_msg_data,
3348: p_msg_type=>'WARNING',
3349: p_msg_level=>fnd_log.level_exception);
3350: END IF;
3351:
3352: -- Debug info.
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3349: p_msg_level=>fnd_log.level_exception);
3350: END IF;
3351:
3352: -- Debug info.
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated (-)',
3355: p_prefix=>l_debug_prefix,
3356: p_msg_level=>fnd_log.level_procedure);
3357: END IF;
3352: -- Debug info.
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated (-)',
3355: p_prefix=>l_debug_prefix,
3356: p_msg_level=>fnd_log.level_procedure);
3357: END IF;
3358:
3359:
3360: EXCEPTION
3366: p_count => x_msg_count,
3367: p_data => x_msg_data);
3368:
3369: -- Debug info.
3370: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3371: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3372: p_msg_data=>x_msg_data,
3373: p_msg_type=>'ERROR',
3374: p_msg_level=>fnd_log.level_error);
3370: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3371: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3372: p_msg_data=>x_msg_data,
3373: p_msg_type=>'ERROR',
3374: p_msg_level=>fnd_log.level_error);
3375: END IF;
3376: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3377: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3378: p_prefix=>l_debug_prefix,
3372: p_msg_data=>x_msg_data,
3373: p_msg_type=>'ERROR',
3374: p_msg_level=>fnd_log.level_error);
3375: END IF;
3376: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3377: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3378: p_prefix=>l_debug_prefix,
3379: p_msg_level=>fnd_log.level_procedure);
3380: END IF;
3375: END IF;
3376: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3377: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3378: p_prefix=>l_debug_prefix,
3379: p_msg_level=>fnd_log.level_procedure);
3380: END IF;
3381: WHEN fnd_api.g_exc_unexpected_error THEN
3382: x_return_status := fnd_api.g_ret_sts_unexp_error;
3383:
3385: p_count => x_msg_count,
3386: p_data => x_msg_data);
3387:
3388: -- Debug info.
3389: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3390: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3391: p_msg_data=>x_msg_data,
3392: p_msg_type=>'UNEXPECTED ERROR',
3393: p_msg_level=>fnd_log.level_error);
3389: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3390: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3391: p_msg_data=>x_msg_data,
3392: p_msg_type=>'UNEXPECTED ERROR',
3393: p_msg_level=>fnd_log.level_error);
3394: END IF;
3395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3396: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3397: p_prefix=>l_debug_prefix,
3391: p_msg_data=>x_msg_data,
3392: p_msg_type=>'UNEXPECTED ERROR',
3393: p_msg_level=>fnd_log.level_error);
3394: END IF;
3395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3396: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3397: p_prefix=>l_debug_prefix,
3398: p_msg_level=>fnd_log.level_procedure);
3399: END IF;
3394: END IF;
3395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3396: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3397: p_prefix=>l_debug_prefix,
3398: p_msg_level=>fnd_log.level_procedure);
3399: END IF;
3400: WHEN OTHERS THEN
3401: x_return_status := fnd_api.g_ret_sts_unexp_error;
3402:
3408: p_count => x_msg_count,
3409: p_data => x_msg_data);
3410:
3411: -- Debug info.
3412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3414: p_msg_data=>x_msg_data,
3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);
3412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3414: p_msg_data=>x_msg_data,
3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);
3417: END IF;
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3420: p_prefix=>l_debug_prefix,
3414: p_msg_data=>x_msg_data,
3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);
3417: END IF;
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;
3417: END IF;
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;
3423:
3424: end;
3425:
3468: END IF;
3469:
3470:
3471: -- Debug info.
3472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3473: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(+)',
3474: p_prefix=>l_debug_prefix,
3475: p_msg_level=>fnd_log.level_procedure);
3476: END IF;
3471: -- Debug info.
3472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3473: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(+)',
3474: p_prefix=>l_debug_prefix,
3475: p_msg_level=>fnd_log.level_procedure);
3476: END IF;
3477:
3478: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3479: p_party_id => p_org_cust_id,
3500:
3501:
3502:
3503: -- Debug info.
3504: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3505: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3506: p_msg_data=>x_msg_data,
3507: p_msg_type=>'WARNING',
3508: p_msg_level=>fnd_log.level_exception);
3504: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3505: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3506: p_msg_data=>x_msg_data,
3507: p_msg_type=>'WARNING',
3508: p_msg_level=>fnd_log.level_exception);
3509: END IF;
3510:
3511: -- Debug info.
3512: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3508: p_msg_level=>fnd_log.level_exception);
3509: END IF;
3510:
3511: -- Debug info.
3512: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3513: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated (-)',
3514: p_prefix=>l_debug_prefix,
3515: p_msg_level=>fnd_log.level_procedure);
3516: END IF;
3511: -- Debug info.
3512: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3513: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated (-)',
3514: p_prefix=>l_debug_prefix,
3515: p_msg_level=>fnd_log.level_procedure);
3516: END IF;
3517:
3518:
3519: EXCEPTION
3525: p_count => x_msg_count,
3526: p_data => x_msg_data);
3527:
3528: -- Debug info.
3529: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3530: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3531: p_msg_data=>x_msg_data,
3532: p_msg_type=>'ERROR',
3533: p_msg_level=>fnd_log.level_error);
3529: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3530: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3531: p_msg_data=>x_msg_data,
3532: p_msg_type=>'ERROR',
3533: p_msg_level=>fnd_log.level_error);
3534: END IF;
3535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3536: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3537: p_prefix=>l_debug_prefix,
3531: p_msg_data=>x_msg_data,
3532: p_msg_type=>'ERROR',
3533: p_msg_level=>fnd_log.level_error);
3534: END IF;
3535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3536: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3537: p_prefix=>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_procedure);
3539: END IF;
3534: END IF;
3535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3536: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3537: p_prefix=>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_procedure);
3539: END IF;
3540: WHEN fnd_api.g_exc_unexpected_error THEN
3541: x_return_status := fnd_api.g_ret_sts_unexp_error;
3542:
3544: p_count => x_msg_count,
3545: p_data => x_msg_data);
3546:
3547: -- Debug info.
3548: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3549: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3550: p_msg_data=>x_msg_data,
3551: p_msg_type=>'UNEXPECTED ERROR',
3552: p_msg_level=>fnd_log.level_error);
3548: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3549: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3550: p_msg_data=>x_msg_data,
3551: p_msg_type=>'UNEXPECTED ERROR',
3552: p_msg_level=>fnd_log.level_error);
3553: END IF;
3554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3555: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3556: p_prefix=>l_debug_prefix,
3550: p_msg_data=>x_msg_data,
3551: p_msg_type=>'UNEXPECTED ERROR',
3552: p_msg_level=>fnd_log.level_error);
3553: END IF;
3554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3555: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3556: p_prefix=>l_debug_prefix,
3557: p_msg_level=>fnd_log.level_procedure);
3558: END IF;
3553: END IF;
3554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3555: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3556: p_prefix=>l_debug_prefix,
3557: p_msg_level=>fnd_log.level_procedure);
3558: END IF;
3559: WHEN OTHERS THEN
3560: x_return_status := fnd_api.g_ret_sts_unexp_error;
3561:
3567: p_count => x_msg_count,
3568: p_data => x_msg_data);
3569:
3570: -- Debug info.
3571: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3572: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3573: p_msg_data=>x_msg_data,
3574: p_msg_type=>'SQL ERROR',
3575: p_msg_level=>fnd_log.level_error);
3571: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3572: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3573: p_msg_data=>x_msg_data,
3574: p_msg_type=>'SQL ERROR',
3575: p_msg_level=>fnd_log.level_error);
3576: END IF;
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3579: p_prefix=>l_debug_prefix,
3573: p_msg_data=>x_msg_data,
3574: p_msg_type=>'SQL ERROR',
3575: p_msg_level=>fnd_log.level_error);
3576: END IF;
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3579: p_prefix=>l_debug_prefix,
3580: p_msg_level=>fnd_log.level_procedure);
3581: END IF;
3576: END IF;
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3579: p_prefix=>l_debug_prefix,
3580: p_msg_level=>fnd_log.level_procedure);
3581: END IF;
3582:
3583: end;
3584: