eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PERSON_CUST_BO_PUB dependencies on FND_LOG

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

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_person_cust_bo(+)',
77: p_prefix=>l_debug_prefix,
78: p_msg_level=>fnd_log.level_procedure);
79: END IF;

Line 78: p_msg_level=>fnd_log.level_procedure);

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_person_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

Line 193: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level 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);

Line 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_person_cust_bo(-)',
201: p_prefix=>l_debug_prefix,

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

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_person_cust_bo(-)',
201: p_prefix=>l_debug_prefix,
202: p_msg_level=>fnd_log.level_procedure);
203: END IF;

Line 202: p_msg_level=>fnd_log.level_procedure);

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_person_cust_bo(-)',
201: p_prefix=>l_debug_prefix,
202: p_msg_level=>fnd_log.level_procedure);
203: END IF;
204:
205: EXCEPTION
206: WHEN fnd_api.g_exc_error THEN

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

220: p_count => x_msg_count,
221: p_data => x_msg_data);
222:
223: -- Debug info.
224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
226: p_msg_data=>x_msg_data,
227: p_msg_type=>'ERROR',
228: p_msg_level=>fnd_log.level_error);

Line 228: p_msg_level=>fnd_log.level_error);

224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
226: p_msg_data=>x_msg_data,
227: p_msg_type=>'ERROR',
228: p_msg_level=>fnd_log.level_error);
229: END IF;
230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
231: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_bo(-)',
232: p_prefix=>l_debug_prefix,

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

226: p_msg_data=>x_msg_data,
227: p_msg_type=>'ERROR',
228: p_msg_level=>fnd_log.level_error);
229: END IF;
230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
231: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_bo(-)',
232: p_prefix=>l_debug_prefix,
233: p_msg_level=>fnd_log.level_procedure);
234: END IF;

Line 233: p_msg_level=>fnd_log.level_procedure);

229: END IF;
230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
231: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_bo(-)',
232: p_prefix=>l_debug_prefix,
233: p_msg_level=>fnd_log.level_procedure);
234: END IF;
235:
236: WHEN fnd_api.g_exc_unexpected_error THEN
237: ROLLBACK TO do_create_person_cust_pub;

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

250: p_count => x_msg_count,
251: p_data => x_msg_data);
252:
253: -- Debug info.
254: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
255: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
256: p_msg_data=>x_msg_data,
257: p_msg_type=>'UNEXPECTED ERROR',
258: p_msg_level=>fnd_log.level_error);

Line 258: p_msg_level=>fnd_log.level_error);

254: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
255: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
256: p_msg_data=>x_msg_data,
257: p_msg_type=>'UNEXPECTED ERROR',
258: p_msg_level=>fnd_log.level_error);
259: END IF;
260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
261: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_bo(-)',
262: p_prefix=>l_debug_prefix,

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

256: p_msg_data=>x_msg_data,
257: p_msg_type=>'UNEXPECTED ERROR',
258: p_msg_level=>fnd_log.level_error);
259: END IF;
260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
261: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_bo(-)',
262: p_prefix=>l_debug_prefix,
263: p_msg_level=>fnd_log.level_procedure);
264: END IF;

Line 263: p_msg_level=>fnd_log.level_procedure);

259: END IF;
260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
261: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_bo(-)',
262: p_prefix=>l_debug_prefix,
263: p_msg_level=>fnd_log.level_procedure);
264: END IF;
265:
266: WHEN OTHERS THEN
267: ROLLBACK TO do_create_person_cust_pub;

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

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

Line 292: p_msg_level=>fnd_log.level_error);

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

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

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

Line 297: p_msg_level=>fnd_log.level_procedure);

293: END IF;
294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
295: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_bo(-)',
296: p_prefix=>l_debug_prefix,
297: p_msg_level=>fnd_log.level_procedure);
298: END IF;
299: END do_create_person_cust_bo;
300:
301: PROCEDURE create_person_cust_bo(

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

394: FND_MSG_PUB.initialize;
395: END IF;
396:
397: -- Debug info.
398: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(+)',
400: p_prefix=>l_debug_prefix,
401: p_msg_level=>fnd_log.level_procedure);
402: END IF;

Line 401: p_msg_level=>fnd_log.level_procedure);

397: -- Debug info.
398: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(+)',
400: p_prefix=>l_debug_prefix,
401: p_msg_level=>fnd_log.level_procedure);
402: END IF;
403:
404: -- initialize Global variable
405: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

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

525: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
526: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
527:
528: -- Debug info.
529: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
530: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
531: p_msg_data=>x_msg_data,
532: p_msg_type=>'WARNING',
533: p_msg_level=>fnd_log.level_exception);

Line 533: p_msg_level=>fnd_log.level_exception);

529: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
530: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
531: p_msg_data=>x_msg_data,
532: p_msg_type=>'WARNING',
533: p_msg_level=>fnd_log.level_exception);
534: END IF;
535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
536: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(-)',
537: p_prefix=>l_debug_prefix,

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

531: p_msg_data=>x_msg_data,
532: p_msg_type=>'WARNING',
533: p_msg_level=>fnd_log.level_exception);
534: END IF;
535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
536: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(-)',
537: p_prefix=>l_debug_prefix,
538: p_msg_level=>fnd_log.level_procedure);
539: END IF;

Line 538: p_msg_level=>fnd_log.level_procedure);

534: END IF;
535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
536: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(-)',
537: p_prefix=>l_debug_prefix,
538: p_msg_level=>fnd_log.level_procedure);
539: END IF;
540: EXCEPTION
541: WHEN fnd_api.g_exc_error THEN
542: ROLLBACK TO do_update_person_cust_pub;

Line 560: IF fnd_log.level_error>=fnd_log.g_current_runtime_level 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);

Line 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_person_cust_bo(-)',
568: p_prefix=>l_debug_prefix,

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

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_person_cust_bo(-)',
568: p_prefix=>l_debug_prefix,
569: p_msg_level=>fnd_log.level_procedure);
570: END IF;

Line 569: p_msg_level=>fnd_log.level_procedure);

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_person_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_person_cust_pub;

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

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);

Line 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_person_cust_bo(-)',
599: p_prefix=>l_debug_prefix,

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

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_person_cust_bo(-)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;

Line 600: p_msg_level=>fnd_log.level_procedure);

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_person_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_person_cust_pub;

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

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);

Line 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_person_cust_bo(-)',
634: p_prefix=>l_debug_prefix,

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

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_person_cust_bo(-)',
634: p_prefix=>l_debug_prefix,
635: p_msg_level=>fnd_log.level_procedure);
636: END IF;

Line 635: p_msg_level=>fnd_log.level_procedure);

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_person_cust_bo(-)',
634: p_prefix=>l_debug_prefix,
635: p_msg_level=>fnd_log.level_procedure);
636: END IF;
637: END do_update_person_cust_bo;
638:
639: PROCEDURE update_person_cust_bo(

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

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_person_cust_bo(+)',
729: p_prefix=>l_debug_prefix,
730: p_msg_level=>fnd_log.level_procedure);
731: END IF;

Line 730: p_msg_level=>fnd_log.level_procedure);

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_person_cust_bo(+)',
729: p_prefix=>l_debug_prefix,
730: p_msg_level=>fnd_log.level_procedure);
731: END IF;
732:
733: l_person_id := p_person_cust_obj.person_obj.person_id;
734: l_person_os := p_person_cust_obj.person_obj.orig_system;

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

780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782:
783: -- Debug info.
784: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
785: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
786: p_msg_data=>x_msg_data,
787: p_msg_type=>'WARNING',
788: p_msg_level=>fnd_log.level_exception);

Line 788: p_msg_level=>fnd_log.level_exception);

784: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
785: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
786: p_msg_data=>x_msg_data,
787: p_msg_type=>'WARNING',
788: p_msg_level=>fnd_log.level_exception);
789: END IF;
790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
791: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_bo(-)',
792: p_prefix=>l_debug_prefix,

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

786: p_msg_data=>x_msg_data,
787: p_msg_type=>'WARNING',
788: p_msg_level=>fnd_log.level_exception);
789: END IF;
790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
791: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_bo(-)',
792: p_prefix=>l_debug_prefix,
793: p_msg_level=>fnd_log.level_procedure);
794: END IF;

Line 793: p_msg_level=>fnd_log.level_procedure);

789: END IF;
790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
791: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_bo(-)',
792: p_prefix=>l_debug_prefix,
793: p_msg_level=>fnd_log.level_procedure);
794: END IF;
795: EXCEPTION
796: WHEN fnd_api.g_exc_error THEN
797: x_return_status := fnd_api.g_ret_sts_error;

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

800: p_count => x_msg_count,
801: p_data => x_msg_data);
802:
803: -- Debug info.
804: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
805: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
806: p_msg_data=>x_msg_data,
807: p_msg_type=>'ERROR',
808: p_msg_level=>fnd_log.level_error);

Line 808: p_msg_level=>fnd_log.level_error);

804: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
805: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
806: p_msg_data=>x_msg_data,
807: p_msg_type=>'ERROR',
808: p_msg_level=>fnd_log.level_error);
809: END IF;
810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_bo(-)',
812: p_prefix=>l_debug_prefix,

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

806: p_msg_data=>x_msg_data,
807: p_msg_type=>'ERROR',
808: p_msg_level=>fnd_log.level_error);
809: END IF;
810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_bo(-)',
812: p_prefix=>l_debug_prefix,
813: p_msg_level=>fnd_log.level_procedure);
814: END IF;

Line 813: p_msg_level=>fnd_log.level_procedure);

809: END IF;
810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_bo(-)',
812: p_prefix=>l_debug_prefix,
813: p_msg_level=>fnd_log.level_procedure);
814: END IF;
815:
816: WHEN fnd_api.g_exc_unexpected_error THEN
817: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 828: p_msg_level=>fnd_log.level_error);

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

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

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

Line 833: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 851: p_msg_level=>fnd_log.level_error);

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

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

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

Line 856: p_msg_level=>fnd_log.level_procedure);

852: END IF;
853: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
854: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_bo(-)',
855: p_prefix=>l_debug_prefix,
856: p_msg_level=>fnd_log.level_procedure);
857: END IF;
858: END do_save_person_cust_bo;
859:
860: PROCEDURE save_person_cust_bo(

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

998: END IF;
999:
1000:
1001: -- Debug info.
1002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1003: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo(+)',
1004: p_prefix=>l_debug_prefix,
1005: p_msg_level=>fnd_log.level_procedure);
1006: END IF;

Line 1005: p_msg_level=>fnd_log.level_procedure);

1001: -- Debug info.
1002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1003: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo(+)',
1004: p_prefix=>l_debug_prefix,
1005: p_msg_level=>fnd_log.level_procedure);
1006: END IF;
1007:
1008: -- check if pass in contact_point_id and/or os+osr
1009: -- extraction validation logic is same as update

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

1039: END IF;
1040:
1041:
1042: -- Debug info.
1043: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1044: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1045: p_msg_data=>x_msg_data,
1046: p_msg_type=>'WARNING',
1047: p_msg_level=>fnd_log.level_exception);

Line 1047: p_msg_level=>fnd_log.level_exception);

1043: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1044: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1045: p_msg_data=>x_msg_data,
1046: p_msg_type=>'WARNING',
1047: p_msg_level=>fnd_log.level_exception);
1048: END IF;
1049:
1050: -- Debug info.
1051: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1047: p_msg_level=>fnd_log.level_exception);
1048: END IF;
1049:
1050: -- Debug info.
1051: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1052: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1053: p_prefix=>l_debug_prefix,
1054: p_msg_level=>fnd_log.level_procedure);
1055: END IF;

Line 1054: p_msg_level=>fnd_log.level_procedure);

1050: -- Debug info.
1051: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1052: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1053: p_prefix=>l_debug_prefix,
1054: p_msg_level=>fnd_log.level_procedure);
1055: END IF;
1056:
1057:
1058: EXCEPTION

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

1064: p_count => x_msg_count,
1065: p_data => x_msg_data);
1066:
1067: -- Debug info.
1068: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1070: p_msg_data=>x_msg_data,
1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);

Line 1072: p_msg_level=>fnd_log.level_error);

1068: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1070: p_msg_data=>x_msg_data,
1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);
1073: END IF;
1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1075: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1076: p_prefix=>l_debug_prefix,

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

1070: p_msg_data=>x_msg_data,
1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);
1073: END IF;
1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1075: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1076: p_prefix=>l_debug_prefix,
1077: p_msg_level=>fnd_log.level_procedure);
1078: END IF;

Line 1077: p_msg_level=>fnd_log.level_procedure);

1073: END IF;
1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1075: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1076: p_prefix=>l_debug_prefix,
1077: p_msg_level=>fnd_log.level_procedure);
1078: END IF;
1079: WHEN fnd_api.g_exc_unexpected_error THEN
1080: x_return_status := fnd_api.g_ret_sts_unexp_error;
1081:

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

1083: p_count => x_msg_count,
1084: p_data => x_msg_data);
1085:
1086: -- Debug info.
1087: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1089: p_msg_data=>x_msg_data,
1090: p_msg_type=>'UNEXPECTED ERROR',
1091: p_msg_level=>fnd_log.level_error);

Line 1091: p_msg_level=>fnd_log.level_error);

1087: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1089: p_msg_data=>x_msg_data,
1090: p_msg_type=>'UNEXPECTED ERROR',
1091: p_msg_level=>fnd_log.level_error);
1092: END IF;
1093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1094: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1095: p_prefix=>l_debug_prefix,

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

1089: p_msg_data=>x_msg_data,
1090: p_msg_type=>'UNEXPECTED ERROR',
1091: p_msg_level=>fnd_log.level_error);
1092: END IF;
1093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1094: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1095: p_prefix=>l_debug_prefix,
1096: p_msg_level=>fnd_log.level_procedure);
1097: END IF;

Line 1096: p_msg_level=>fnd_log.level_procedure);

1092: END IF;
1093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1094: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1095: p_prefix=>l_debug_prefix,
1096: p_msg_level=>fnd_log.level_procedure);
1097: END IF;
1098: WHEN OTHERS THEN
1099: x_return_status := fnd_api.g_ret_sts_unexp_error;
1100:

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

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

Line 1114: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1119: p_msg_level=>fnd_log.level_procedure);

1115: END IF;
1116: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1117: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_bo (-)',
1118: p_prefix=>l_debug_prefix,
1119: p_msg_level=>fnd_log.level_procedure);
1120: END IF;
1121:
1122: end;
1123:

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

1217: END IF;
1218:
1219:
1220: -- Debug info.
1221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1222: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(+)',
1223: p_prefix=>l_debug_prefix,
1224: p_msg_level=>fnd_log.level_procedure);
1225: END IF;

Line 1224: p_msg_level=>fnd_log.level_procedure);

1220: -- Debug info.
1221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1222: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(+)',
1223: p_prefix=>l_debug_prefix,
1224: p_msg_level=>fnd_log.level_procedure);
1225: END IF;
1226:
1227: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1228: p_party_id => null,

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

1248:
1249:
1250:
1251: -- Debug info.
1252: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1254: p_msg_data=>x_msg_data,
1255: p_msg_type=>'WARNING',
1256: p_msg_level=>fnd_log.level_exception);

Line 1256: p_msg_level=>fnd_log.level_exception);

1252: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1254: p_msg_data=>x_msg_data,
1255: p_msg_type=>'WARNING',
1256: p_msg_level=>fnd_log.level_exception);
1257: END IF;
1258:
1259: -- Debug info.
1260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1256: p_msg_level=>fnd_log.level_exception);
1257: END IF;
1258:
1259: -- Debug info.
1260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1261: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created (-)',
1262: p_prefix=>l_debug_prefix,
1263: p_msg_level=>fnd_log.level_procedure);
1264: END IF;

Line 1263: p_msg_level=>fnd_log.level_procedure);

1259: -- Debug info.
1260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1261: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created (-)',
1262: p_prefix=>l_debug_prefix,
1263: p_msg_level=>fnd_log.level_procedure);
1264: END IF;
1265:
1266:
1267: EXCEPTION

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

1273: p_count => x_msg_count,
1274: p_data => x_msg_data);
1275:
1276: -- Debug info.
1277: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1278: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1279: p_msg_data=>x_msg_data,
1280: p_msg_type=>'ERROR',
1281: p_msg_level=>fnd_log.level_error);

Line 1281: p_msg_level=>fnd_log.level_error);

1277: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1278: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1279: p_msg_data=>x_msg_data,
1280: p_msg_type=>'ERROR',
1281: p_msg_level=>fnd_log.level_error);
1282: END IF;
1283: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1284: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1285: p_prefix=>l_debug_prefix,

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

1279: p_msg_data=>x_msg_data,
1280: p_msg_type=>'ERROR',
1281: p_msg_level=>fnd_log.level_error);
1282: END IF;
1283: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1284: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1285: p_prefix=>l_debug_prefix,
1286: p_msg_level=>fnd_log.level_procedure);
1287: END IF;

Line 1286: p_msg_level=>fnd_log.level_procedure);

1282: END IF;
1283: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1284: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1285: p_prefix=>l_debug_prefix,
1286: p_msg_level=>fnd_log.level_procedure);
1287: END IF;
1288: WHEN fnd_api.g_exc_unexpected_error THEN
1289: x_return_status := fnd_api.g_ret_sts_unexp_error;
1290:

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

1292: p_count => x_msg_count,
1293: p_data => x_msg_data);
1294:
1295: -- Debug info.
1296: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1297: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1298: p_msg_data=>x_msg_data,
1299: p_msg_type=>'UNEXPECTED ERROR',
1300: p_msg_level=>fnd_log.level_error);

Line 1300: p_msg_level=>fnd_log.level_error);

1296: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1297: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1298: p_msg_data=>x_msg_data,
1299: p_msg_type=>'UNEXPECTED ERROR',
1300: p_msg_level=>fnd_log.level_error);
1301: END IF;
1302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1303: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1304: p_prefix=>l_debug_prefix,

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

1298: p_msg_data=>x_msg_data,
1299: p_msg_type=>'UNEXPECTED ERROR',
1300: p_msg_level=>fnd_log.level_error);
1301: END IF;
1302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1303: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1304: p_prefix=>l_debug_prefix,
1305: p_msg_level=>fnd_log.level_procedure);
1306: END IF;

Line 1305: p_msg_level=>fnd_log.level_procedure);

1301: END IF;
1302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1303: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1304: p_prefix=>l_debug_prefix,
1305: p_msg_level=>fnd_log.level_procedure);
1306: END IF;
1307: WHEN OTHERS THEN
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309:

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

1315: p_count => x_msg_count,
1316: p_data => x_msg_data);
1317:
1318: -- Debug info.
1319: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1320: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1321: p_msg_data=>x_msg_data,
1322: p_msg_type=>'SQL ERROR',
1323: p_msg_level=>fnd_log.level_error);

Line 1323: p_msg_level=>fnd_log.level_error);

1319: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1320: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1321: p_msg_data=>x_msg_data,
1322: p_msg_type=>'SQL ERROR',
1323: p_msg_level=>fnd_log.level_error);
1324: END IF;
1325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1326: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1327: p_prefix=>l_debug_prefix,

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

1321: p_msg_data=>x_msg_data,
1322: p_msg_type=>'SQL ERROR',
1323: p_msg_level=>fnd_log.level_error);
1324: END IF;
1325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1326: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1327: p_prefix=>l_debug_prefix,
1328: p_msg_level=>fnd_log.level_procedure);
1329: END IF;

Line 1328: p_msg_level=>fnd_log.level_procedure);

1324: END IF;
1325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1326: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_created(-)',
1327: p_prefix=>l_debug_prefix,
1328: p_msg_level=>fnd_log.level_procedure);
1329: END IF;
1330:
1331: end;
1332:

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

1422: END IF;
1423:
1424:
1425: -- Debug info.
1426: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1427: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(+)',
1428: p_prefix=>l_debug_prefix,
1429: p_msg_level=>fnd_log.level_procedure);
1430: END IF;

Line 1429: p_msg_level=>fnd_log.level_procedure);

1425: -- Debug info.
1426: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1427: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(+)',
1428: p_prefix=>l_debug_prefix,
1429: p_msg_level=>fnd_log.level_procedure);
1430: END IF;
1431:
1432: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1433: p_party_id => null,

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

1453:
1454:
1455:
1456: -- Debug info.
1457: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1458: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1459: p_msg_data=>x_msg_data,
1460: p_msg_type=>'WARNING',
1461: p_msg_level=>fnd_log.level_exception);

Line 1461: p_msg_level=>fnd_log.level_exception);

1457: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1458: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1459: p_msg_data=>x_msg_data,
1460: p_msg_type=>'WARNING',
1461: p_msg_level=>fnd_log.level_exception);
1462: END IF;
1463:
1464: -- Debug info.
1465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1461: p_msg_level=>fnd_log.level_exception);
1462: END IF;
1463:
1464: -- Debug info.
1465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1466: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated (-)',
1467: p_prefix=>l_debug_prefix,
1468: p_msg_level=>fnd_log.level_procedure);
1469: END IF;

Line 1468: p_msg_level=>fnd_log.level_procedure);

1464: -- Debug info.
1465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1466: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated (-)',
1467: p_prefix=>l_debug_prefix,
1468: p_msg_level=>fnd_log.level_procedure);
1469: END IF;
1470:
1471:
1472: EXCEPTION

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

1478: p_count => x_msg_count,
1479: p_data => x_msg_data);
1480:
1481: -- Debug info.
1482: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1484: p_msg_data=>x_msg_data,
1485: p_msg_type=>'ERROR',
1486: p_msg_level=>fnd_log.level_error);

Line 1486: p_msg_level=>fnd_log.level_error);

1482: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1484: p_msg_data=>x_msg_data,
1485: p_msg_type=>'ERROR',
1486: p_msg_level=>fnd_log.level_error);
1487: END IF;
1488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1490: p_prefix=>l_debug_prefix,

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

1484: p_msg_data=>x_msg_data,
1485: p_msg_type=>'ERROR',
1486: p_msg_level=>fnd_log.level_error);
1487: END IF;
1488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1490: p_prefix=>l_debug_prefix,
1491: p_msg_level=>fnd_log.level_procedure);
1492: END IF;

Line 1491: p_msg_level=>fnd_log.level_procedure);

1487: END IF;
1488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1490: p_prefix=>l_debug_prefix,
1491: p_msg_level=>fnd_log.level_procedure);
1492: END IF;
1493: WHEN fnd_api.g_exc_unexpected_error THEN
1494: x_return_status := fnd_api.g_ret_sts_unexp_error;
1495:

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

1497: p_count => x_msg_count,
1498: p_data => x_msg_data);
1499:
1500: -- Debug info.
1501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1503: p_msg_data=>x_msg_data,
1504: p_msg_type=>'UNEXPECTED ERROR',
1505: p_msg_level=>fnd_log.level_error);

Line 1505: p_msg_level=>fnd_log.level_error);

1501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1503: p_msg_data=>x_msg_data,
1504: p_msg_type=>'UNEXPECTED ERROR',
1505: p_msg_level=>fnd_log.level_error);
1506: END IF;
1507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1508: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1509: p_prefix=>l_debug_prefix,

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

1503: p_msg_data=>x_msg_data,
1504: p_msg_type=>'UNEXPECTED ERROR',
1505: p_msg_level=>fnd_log.level_error);
1506: END IF;
1507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1508: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1509: p_prefix=>l_debug_prefix,
1510: p_msg_level=>fnd_log.level_procedure);
1511: END IF;

Line 1510: p_msg_level=>fnd_log.level_procedure);

1506: END IF;
1507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1508: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1509: p_prefix=>l_debug_prefix,
1510: p_msg_level=>fnd_log.level_procedure);
1511: END IF;
1512: WHEN OTHERS THEN
1513: x_return_status := fnd_api.g_ret_sts_unexp_error;
1514:

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

1520: p_count => x_msg_count,
1521: p_data => x_msg_data);
1522:
1523: -- Debug info.
1524: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1526: p_msg_data=>x_msg_data,
1527: p_msg_type=>'SQL ERROR',
1528: p_msg_level=>fnd_log.level_error);

Line 1528: p_msg_level=>fnd_log.level_error);

1524: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1526: p_msg_data=>x_msg_data,
1527: p_msg_type=>'SQL ERROR',
1528: p_msg_level=>fnd_log.level_error);
1529: END IF;
1530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1531: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1532: p_prefix=>l_debug_prefix,

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

1526: p_msg_data=>x_msg_data,
1527: p_msg_type=>'SQL ERROR',
1528: p_msg_level=>fnd_log.level_error);
1529: END IF;
1530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1531: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1532: p_prefix=>l_debug_prefix,
1533: p_msg_level=>fnd_log.level_procedure);
1534: END IF;

Line 1533: p_msg_level=>fnd_log.level_procedure);

1529: END IF;
1530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1531: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
1532: p_prefix=>l_debug_prefix,
1533: p_msg_level=>fnd_log.level_procedure);
1534: END IF;
1535:
1536: end;
1537:

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

1611: END IF;
1612:
1613:
1614: -- Debug info.
1615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1616: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(+)',
1617: p_prefix=>l_debug_prefix,
1618: p_msg_level=>fnd_log.level_procedure);
1619: END IF;

Line 1618: p_msg_level=>fnd_log.level_procedure);

1614: -- Debug info.
1615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1616: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(+)',
1617: p_prefix=>l_debug_prefix,
1618: p_msg_level=>fnd_log.level_procedure);
1619: END IF;
1620:
1621: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1622: p_party_id => p_person_cust_id,

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

1643:
1644:
1645:
1646: -- Debug info.
1647: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1649: p_msg_data=>x_msg_data,
1650: p_msg_type=>'WARNING',
1651: p_msg_level=>fnd_log.level_exception);

Line 1651: p_msg_level=>fnd_log.level_exception);

1647: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1649: p_msg_data=>x_msg_data,
1650: p_msg_type=>'WARNING',
1651: p_msg_level=>fnd_log.level_exception);
1652: END IF;
1653:
1654: -- Debug info.
1655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1651: p_msg_level=>fnd_log.level_exception);
1652: END IF;
1653:
1654: -- Debug info.
1655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1656: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated (-)',
1657: p_prefix=>l_debug_prefix,
1658: p_msg_level=>fnd_log.level_procedure);
1659: END IF;

Line 1658: p_msg_level=>fnd_log.level_procedure);

1654: -- Debug info.
1655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1656: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated (-)',
1657: p_prefix=>l_debug_prefix,
1658: p_msg_level=>fnd_log.level_procedure);
1659: END IF;
1660:
1661:
1662: EXCEPTION

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

1668: p_count => x_msg_count,
1669: p_data => x_msg_data);
1670:
1671: -- Debug info.
1672: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1673: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1674: p_msg_data=>x_msg_data,
1675: p_msg_type=>'ERROR',
1676: p_msg_level=>fnd_log.level_error);

Line 1676: p_msg_level=>fnd_log.level_error);

1672: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1673: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1674: p_msg_data=>x_msg_data,
1675: p_msg_type=>'ERROR',
1676: p_msg_level=>fnd_log.level_error);
1677: END IF;
1678: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1679: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1680: p_prefix=>l_debug_prefix,

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

1674: p_msg_data=>x_msg_data,
1675: p_msg_type=>'ERROR',
1676: p_msg_level=>fnd_log.level_error);
1677: END IF;
1678: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1679: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1680: p_prefix=>l_debug_prefix,
1681: p_msg_level=>fnd_log.level_procedure);
1682: END IF;

Line 1681: p_msg_level=>fnd_log.level_procedure);

1677: END IF;
1678: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1679: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1680: p_prefix=>l_debug_prefix,
1681: p_msg_level=>fnd_log.level_procedure);
1682: END IF;
1683: WHEN fnd_api.g_exc_unexpected_error THEN
1684: x_return_status := fnd_api.g_ret_sts_unexp_error;
1685:

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

1687: p_count => x_msg_count,
1688: p_data => x_msg_data);
1689:
1690: -- Debug info.
1691: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1692: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1693: p_msg_data=>x_msg_data,
1694: p_msg_type=>'UNEXPECTED ERROR',
1695: p_msg_level=>fnd_log.level_error);

Line 1695: p_msg_level=>fnd_log.level_error);

1691: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1692: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1693: p_msg_data=>x_msg_data,
1694: p_msg_type=>'UNEXPECTED ERROR',
1695: p_msg_level=>fnd_log.level_error);
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1699: p_prefix=>l_debug_prefix,

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

1693: p_msg_data=>x_msg_data,
1694: p_msg_type=>'UNEXPECTED ERROR',
1695: p_msg_level=>fnd_log.level_error);
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;

Line 1700: p_msg_level=>fnd_log.level_procedure);

1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;
1702: WHEN OTHERS THEN
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704:

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

1710: p_count => x_msg_count,
1711: p_data => x_msg_data);
1712:
1713: -- Debug info.
1714: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1716: p_msg_data=>x_msg_data,
1717: p_msg_type=>'SQL ERROR',
1718: p_msg_level=>fnd_log.level_error);

Line 1718: p_msg_level=>fnd_log.level_error);

1714: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1716: p_msg_data=>x_msg_data,
1717: p_msg_type=>'SQL ERROR',
1718: p_msg_level=>fnd_log.level_error);
1719: END IF;
1720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1721: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1722: p_prefix=>l_debug_prefix,

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

1716: p_msg_data=>x_msg_data,
1717: p_msg_type=>'SQL ERROR',
1718: p_msg_level=>fnd_log.level_error);
1719: END IF;
1720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1721: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1722: p_prefix=>l_debug_prefix,
1723: p_msg_level=>fnd_log.level_procedure);
1724: END IF;

Line 1723: p_msg_level=>fnd_log.level_procedure);

1719: END IF;
1720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1721: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
1722: p_prefix=>l_debug_prefix,
1723: p_msg_level=>fnd_log.level_procedure);
1724: END IF;
1725:
1726: end;
1727:

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

1772: END IF;
1773:
1774:
1775: -- Debug info.
1776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1777: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(+)',
1778: p_prefix=>l_debug_prefix,
1779: p_msg_level=>fnd_log.level_procedure);
1780: END IF;

Line 1779: p_msg_level=>fnd_log.level_procedure);

1775: -- Debug info.
1776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1777: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(+)',
1778: p_prefix=>l_debug_prefix,
1779: p_msg_level=>fnd_log.level_procedure);
1780: END IF;
1781:
1782: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1783: p_party_id => null,

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

1802: END IF;
1803:
1804:
1805: -- Debug info.
1806: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1807: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1808: p_msg_data=>x_msg_data,
1809: p_msg_type=>'WARNING',
1810: p_msg_level=>fnd_log.level_exception);

Line 1810: p_msg_level=>fnd_log.level_exception);

1806: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1807: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1808: p_msg_data=>x_msg_data,
1809: p_msg_type=>'WARNING',
1810: p_msg_level=>fnd_log.level_exception);
1811: END IF;
1812:
1813: -- Debug info.
1814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1810: p_msg_level=>fnd_log.level_exception);
1811: END IF;
1812:
1813: -- Debug info.
1814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1815: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created (-)',
1816: p_prefix=>l_debug_prefix,
1817: p_msg_level=>fnd_log.level_procedure);
1818: END IF;

Line 1817: p_msg_level=>fnd_log.level_procedure);

1813: -- Debug info.
1814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1815: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created (-)',
1816: p_prefix=>l_debug_prefix,
1817: p_msg_level=>fnd_log.level_procedure);
1818: END IF;
1819:
1820:
1821: EXCEPTION

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

1827: p_count => x_msg_count,
1828: p_data => x_msg_data);
1829:
1830: -- Debug info.
1831: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1832: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1833: p_msg_data=>x_msg_data,
1834: p_msg_type=>'ERROR',
1835: p_msg_level=>fnd_log.level_error);

Line 1835: p_msg_level=>fnd_log.level_error);

1831: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1832: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1833: p_msg_data=>x_msg_data,
1834: p_msg_type=>'ERROR',
1835: p_msg_level=>fnd_log.level_error);
1836: END IF;
1837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1838: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1839: p_prefix=>l_debug_prefix,

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

1833: p_msg_data=>x_msg_data,
1834: p_msg_type=>'ERROR',
1835: p_msg_level=>fnd_log.level_error);
1836: END IF;
1837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1838: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1839: p_prefix=>l_debug_prefix,
1840: p_msg_level=>fnd_log.level_procedure);
1841: END IF;

Line 1840: p_msg_level=>fnd_log.level_procedure);

1836: END IF;
1837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1838: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1839: p_prefix=>l_debug_prefix,
1840: p_msg_level=>fnd_log.level_procedure);
1841: END IF;
1842: WHEN fnd_api.g_exc_unexpected_error THEN
1843: x_return_status := fnd_api.g_ret_sts_unexp_error;
1844:

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

1846: p_count => x_msg_count,
1847: p_data => x_msg_data);
1848:
1849: -- Debug info.
1850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1852: p_msg_data=>x_msg_data,
1853: p_msg_type=>'UNEXPECTED ERROR',
1854: p_msg_level=>fnd_log.level_error);

Line 1854: p_msg_level=>fnd_log.level_error);

1850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1852: p_msg_data=>x_msg_data,
1853: p_msg_type=>'UNEXPECTED ERROR',
1854: p_msg_level=>fnd_log.level_error);
1855: END IF;
1856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1857: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1858: p_prefix=>l_debug_prefix,

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

1852: p_msg_data=>x_msg_data,
1853: p_msg_type=>'UNEXPECTED ERROR',
1854: p_msg_level=>fnd_log.level_error);
1855: END IF;
1856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1857: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1858: p_prefix=>l_debug_prefix,
1859: p_msg_level=>fnd_log.level_procedure);
1860: END IF;

Line 1859: p_msg_level=>fnd_log.level_procedure);

1855: END IF;
1856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1857: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1858: p_prefix=>l_debug_prefix,
1859: p_msg_level=>fnd_log.level_procedure);
1860: END IF;
1861: WHEN OTHERS THEN
1862: x_return_status := fnd_api.g_ret_sts_unexp_error;
1863:

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

1869: p_count => x_msg_count,
1870: p_data => x_msg_data);
1871:
1872: -- Debug info.
1873: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1874: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1875: p_msg_data=>x_msg_data,
1876: p_msg_type=>'SQL ERROR',
1877: p_msg_level=>fnd_log.level_error);

Line 1877: p_msg_level=>fnd_log.level_error);

1873: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1874: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1875: p_msg_data=>x_msg_data,
1876: p_msg_type=>'SQL ERROR',
1877: p_msg_level=>fnd_log.level_error);
1878: END IF;
1879: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1880: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1881: p_prefix=>l_debug_prefix,

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

1875: p_msg_data=>x_msg_data,
1876: p_msg_type=>'SQL ERROR',
1877: p_msg_level=>fnd_log.level_error);
1878: END IF;
1879: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1880: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1881: p_prefix=>l_debug_prefix,
1882: p_msg_level=>fnd_log.level_procedure);
1883: END IF;

Line 1882: p_msg_level=>fnd_log.level_procedure);

1878: END IF;
1879: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1880: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_created(-)',
1881: p_prefix=>l_debug_prefix,
1882: p_msg_level=>fnd_log.level_procedure);
1883: END IF;
1884:
1885: end;
1886:

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

1906: END IF;
1907:
1908:
1909: -- Debug info.
1910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1911: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(+)',
1912: p_prefix=>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_procedure);
1914: END IF;

Line 1913: p_msg_level=>fnd_log.level_procedure);

1909: -- Debug info.
1910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1911: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(+)',
1912: p_prefix=>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_procedure);
1914: END IF;
1915:
1916: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1917: p_party_id => null,

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

1936: END IF;
1937:
1938:
1939: -- Debug info.
1940: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1942: p_msg_data=>x_msg_data,
1943: p_msg_type=>'WARNING',
1944: p_msg_level=>fnd_log.level_exception);

Line 1944: p_msg_level=>fnd_log.level_exception);

1940: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1942: p_msg_data=>x_msg_data,
1943: p_msg_type=>'WARNING',
1944: p_msg_level=>fnd_log.level_exception);
1945: END IF;
1946:
1947: -- Debug info.
1948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1944: p_msg_level=>fnd_log.level_exception);
1945: END IF;
1946:
1947: -- Debug info.
1948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1949: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated (-)',
1950: p_prefix=>l_debug_prefix,
1951: p_msg_level=>fnd_log.level_procedure);
1952: END IF;

Line 1951: p_msg_level=>fnd_log.level_procedure);

1947: -- Debug info.
1948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1949: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated (-)',
1950: p_prefix=>l_debug_prefix,
1951: p_msg_level=>fnd_log.level_procedure);
1952: END IF;
1953:
1954:
1955: EXCEPTION

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

1961: p_count => x_msg_count,
1962: p_data => x_msg_data);
1963:
1964: -- Debug info.
1965: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1966: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1967: p_msg_data=>x_msg_data,
1968: p_msg_type=>'ERROR',
1969: p_msg_level=>fnd_log.level_error);

Line 1969: p_msg_level=>fnd_log.level_error);

1965: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1966: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1967: p_msg_data=>x_msg_data,
1968: p_msg_type=>'ERROR',
1969: p_msg_level=>fnd_log.level_error);
1970: END IF;
1971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1972: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
1973: p_prefix=>l_debug_prefix,

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

1967: p_msg_data=>x_msg_data,
1968: p_msg_type=>'ERROR',
1969: p_msg_level=>fnd_log.level_error);
1970: END IF;
1971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1972: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
1973: p_prefix=>l_debug_prefix,
1974: p_msg_level=>fnd_log.level_procedure);
1975: END IF;

Line 1974: p_msg_level=>fnd_log.level_procedure);

1970: END IF;
1971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1972: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
1973: p_prefix=>l_debug_prefix,
1974: p_msg_level=>fnd_log.level_procedure);
1975: END IF;
1976: WHEN fnd_api.g_exc_unexpected_error THEN
1977: x_return_status := fnd_api.g_ret_sts_unexp_error;
1978:

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

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=>'UNEXPECTED ERROR',
1988: p_msg_level=>fnd_log.level_error);

Line 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=>'UNEXPECTED 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_person_custs_updated(-)',
1992: p_prefix=>l_debug_prefix,

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

1986: p_msg_data=>x_msg_data,
1987: p_msg_type=>'UNEXPECTED 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_person_custs_updated(-)',
1992: p_prefix=>l_debug_prefix,
1993: p_msg_level=>fnd_log.level_procedure);
1994: END IF;

Line 1993: p_msg_level=>fnd_log.level_procedure);

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_person_custs_updated(-)',
1992: p_prefix=>l_debug_prefix,
1993: p_msg_level=>fnd_log.level_procedure);
1994: END IF;
1995: WHEN OTHERS THEN
1996: x_return_status := fnd_api.g_ret_sts_unexp_error;
1997:

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

2003: p_count => x_msg_count,
2004: p_data => x_msg_data);
2005:
2006: -- Debug info.
2007: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2008: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2009: p_msg_data=>x_msg_data,
2010: p_msg_type=>'SQL ERROR',
2011: p_msg_level=>fnd_log.level_error);

Line 2011: p_msg_level=>fnd_log.level_error);

2007: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2008: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2009: p_msg_data=>x_msg_data,
2010: p_msg_type=>'SQL ERROR',
2011: p_msg_level=>fnd_log.level_error);
2012: END IF;
2013: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2014: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
2015: p_prefix=>l_debug_prefix,

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

2009: p_msg_data=>x_msg_data,
2010: p_msg_type=>'SQL ERROR',
2011: p_msg_level=>fnd_log.level_error);
2012: END IF;
2013: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2014: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
2015: p_prefix=>l_debug_prefix,
2016: p_msg_level=>fnd_log.level_procedure);
2017: END IF;

Line 2016: p_msg_level=>fnd_log.level_procedure);

2012: END IF;
2013: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2014: hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
2015: p_prefix=>l_debug_prefix,
2016: p_msg_level=>fnd_log.level_procedure);
2017: END IF;
2018:
2019: end;
2020:

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

2054: FND_MSG_PUB.initialize;
2055: END IF;
2056:
2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(+)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;

Line 2061: p_msg_level=>fnd_log.level_procedure);

2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(+)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;
2063:
2064: -- Base on p_validate_bo_flag, check the completeness of business objects
2065: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

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

2172: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2173: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2174:
2175: -- Debug info.
2176: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2178: p_msg_data=>x_msg_data,
2179: p_msg_type=>'WARNING',
2180: p_msg_level=>fnd_log.level_exception);

Line 2180: p_msg_level=>fnd_log.level_exception);

2176: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2178: p_msg_data=>x_msg_data,
2179: p_msg_type=>'WARNING',
2180: p_msg_level=>fnd_log.level_exception);
2181: END IF;
2182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2183: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2184: p_prefix=>l_debug_prefix,

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

2178: p_msg_data=>x_msg_data,
2179: p_msg_type=>'WARNING',
2180: p_msg_level=>fnd_log.level_exception);
2181: END IF;
2182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2183: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2184: p_prefix=>l_debug_prefix,
2185: p_msg_level=>fnd_log.level_procedure);
2186: END IF;

Line 2185: p_msg_level=>fnd_log.level_procedure);

2181: END IF;
2182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2183: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2184: p_prefix=>l_debug_prefix,
2185: p_msg_level=>fnd_log.level_procedure);
2186: END IF;
2187:
2188: EXCEPTION
2189: WHEN fnd_api.g_exc_error THEN

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

2203: p_count => x_msg_count,
2204: p_data => x_msg_data);
2205:
2206: -- Debug info.
2207: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2209: p_msg_data=>x_msg_data,
2210: p_msg_type=>'ERROR',
2211: p_msg_level=>fnd_log.level_error);

Line 2211: p_msg_level=>fnd_log.level_error);

2207: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2209: p_msg_data=>x_msg_data,
2210: p_msg_type=>'ERROR',
2211: p_msg_level=>fnd_log.level_error);
2212: END IF;
2213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2215: p_prefix=>l_debug_prefix,

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

2209: p_msg_data=>x_msg_data,
2210: p_msg_type=>'ERROR',
2211: p_msg_level=>fnd_log.level_error);
2212: END IF;
2213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2215: p_prefix=>l_debug_prefix,
2216: p_msg_level=>fnd_log.level_procedure);
2217: END IF;

Line 2216: p_msg_level=>fnd_log.level_procedure);

2212: END IF;
2213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2215: p_prefix=>l_debug_prefix,
2216: p_msg_level=>fnd_log.level_procedure);
2217: END IF;
2218:
2219: WHEN fnd_api.g_exc_unexpected_error THEN
2220: ROLLBACK TO do_create_person_cust_v2_pub;

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

2233: p_count => x_msg_count,
2234: p_data => x_msg_data);
2235:
2236: -- Debug info.
2237: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2238: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2239: p_msg_data=>x_msg_data,
2240: p_msg_type=>'UNEXPECTED ERROR',
2241: p_msg_level=>fnd_log.level_error);

Line 2241: p_msg_level=>fnd_log.level_error);

2237: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2238: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2239: p_msg_data=>x_msg_data,
2240: p_msg_type=>'UNEXPECTED ERROR',
2241: p_msg_level=>fnd_log.level_error);
2242: END IF;
2243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2244: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2245: p_prefix=>l_debug_prefix,

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

2239: p_msg_data=>x_msg_data,
2240: p_msg_type=>'UNEXPECTED ERROR',
2241: p_msg_level=>fnd_log.level_error);
2242: END IF;
2243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2244: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2245: p_prefix=>l_debug_prefix,
2246: p_msg_level=>fnd_log.level_procedure);
2247: END IF;

Line 2246: p_msg_level=>fnd_log.level_procedure);

2242: END IF;
2243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2244: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2245: p_prefix=>l_debug_prefix,
2246: p_msg_level=>fnd_log.level_procedure);
2247: END IF;
2248:
2249: WHEN OTHERS THEN
2250: ROLLBACK TO do_create_person_cust_v2_pub;

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

2267: p_count => x_msg_count,
2268: p_data => x_msg_data);
2269:
2270: -- Debug info.
2271: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2272: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2273: p_msg_data=>x_msg_data,
2274: p_msg_type=>'SQL ERROR',
2275: p_msg_level=>fnd_log.level_error);

Line 2275: p_msg_level=>fnd_log.level_error);

2271: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2272: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2273: p_msg_data=>x_msg_data,
2274: p_msg_type=>'SQL ERROR',
2275: p_msg_level=>fnd_log.level_error);
2276: END IF;
2277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2278: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2279: p_prefix=>l_debug_prefix,

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

2273: p_msg_data=>x_msg_data,
2274: p_msg_type=>'SQL ERROR',
2275: p_msg_level=>fnd_log.level_error);
2276: END IF;
2277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2278: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2279: p_prefix=>l_debug_prefix,
2280: p_msg_level=>fnd_log.level_procedure);
2281: END IF;

Line 2280: p_msg_level=>fnd_log.level_procedure);

2276: END IF;
2277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2278: hz_utility_v2pub.debug(p_message=>'do_create_person_cust_v2_bo(-)',
2279: p_prefix=>l_debug_prefix,
2280: p_msg_level=>fnd_log.level_procedure);
2281: END IF;
2282: END do_create_person_cust_v2_bo;
2283:
2284:

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

2352: FND_MSG_PUB.initialize;
2353: END IF;
2354:
2355: -- Debug info.
2356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2357: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(+)',
2358: p_prefix=>l_debug_prefix,
2359: p_msg_level=>fnd_log.level_procedure);
2360: END IF;

Line 2359: p_msg_level=>fnd_log.level_procedure);

2355: -- Debug info.
2356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2357: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(+)',
2358: p_prefix=>l_debug_prefix,
2359: p_msg_level=>fnd_log.level_procedure);
2360: END IF;
2361:
2362: -- initialize Global variable
2363: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

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

2483: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2484: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2485:
2486: -- Debug info.
2487: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2488: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2489: p_msg_data=>x_msg_data,
2490: p_msg_type=>'WARNING',
2491: p_msg_level=>fnd_log.level_exception);

Line 2491: p_msg_level=>fnd_log.level_exception);

2487: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2488: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2489: p_msg_data=>x_msg_data,
2490: p_msg_type=>'WARNING',
2491: p_msg_level=>fnd_log.level_exception);
2492: END IF;
2493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2494: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2495: p_prefix=>l_debug_prefix,

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

2489: p_msg_data=>x_msg_data,
2490: p_msg_type=>'WARNING',
2491: p_msg_level=>fnd_log.level_exception);
2492: END IF;
2493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2494: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2495: p_prefix=>l_debug_prefix,
2496: p_msg_level=>fnd_log.level_procedure);
2497: END IF;

Line 2496: p_msg_level=>fnd_log.level_procedure);

2492: END IF;
2493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2494: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2495: p_prefix=>l_debug_prefix,
2496: p_msg_level=>fnd_log.level_procedure);
2497: END IF;
2498: EXCEPTION
2499: WHEN fnd_api.g_exc_error THEN
2500: ROLLBACK TO do_update_person_cust_v2_pub;

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

2514: p_count => x_msg_count,
2515: p_data => x_msg_data);
2516:
2517: -- Debug info.
2518: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2520: p_msg_data=>x_msg_data,
2521: p_msg_type=>'ERROR',
2522: p_msg_level=>fnd_log.level_error);

Line 2522: p_msg_level=>fnd_log.level_error);

2518: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2520: p_msg_data=>x_msg_data,
2521: p_msg_type=>'ERROR',
2522: p_msg_level=>fnd_log.level_error);
2523: END IF;
2524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2525: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2526: p_prefix=>l_debug_prefix,

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

2520: p_msg_data=>x_msg_data,
2521: p_msg_type=>'ERROR',
2522: p_msg_level=>fnd_log.level_error);
2523: END IF;
2524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2525: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2526: p_prefix=>l_debug_prefix,
2527: p_msg_level=>fnd_log.level_procedure);
2528: END IF;

Line 2527: p_msg_level=>fnd_log.level_procedure);

2523: END IF;
2524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2525: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2526: p_prefix=>l_debug_prefix,
2527: p_msg_level=>fnd_log.level_procedure);
2528: END IF;
2529:
2530: WHEN fnd_api.g_exc_unexpected_error THEN
2531: ROLLBACK TO do_update_person_cust_v2_pub;

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

2545: p_count => x_msg_count,
2546: p_data => x_msg_data);
2547:
2548: -- Debug info.
2549: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2550: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2551: p_msg_data=>x_msg_data,
2552: p_msg_type=>'UNEXPECTED ERROR',
2553: p_msg_level=>fnd_log.level_error);

Line 2553: p_msg_level=>fnd_log.level_error);

2549: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2550: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2551: p_msg_data=>x_msg_data,
2552: p_msg_type=>'UNEXPECTED ERROR',
2553: p_msg_level=>fnd_log.level_error);
2554: END IF;
2555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2556: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2557: p_prefix=>l_debug_prefix,

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

2551: p_msg_data=>x_msg_data,
2552: p_msg_type=>'UNEXPECTED ERROR',
2553: p_msg_level=>fnd_log.level_error);
2554: END IF;
2555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2556: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2557: p_prefix=>l_debug_prefix,
2558: p_msg_level=>fnd_log.level_procedure);
2559: END IF;

Line 2558: p_msg_level=>fnd_log.level_procedure);

2554: END IF;
2555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2556: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2557: p_prefix=>l_debug_prefix,
2558: p_msg_level=>fnd_log.level_procedure);
2559: END IF;
2560:
2561: WHEN OTHERS THEN
2562: ROLLBACK TO do_update_person_cust_v2_pub;

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

2580: p_count => x_msg_count,
2581: p_data => x_msg_data);
2582:
2583: -- Debug info.
2584: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2585: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2586: p_msg_data=>x_msg_data,
2587: p_msg_type=>'SQL ERROR',
2588: p_msg_level=>fnd_log.level_error);

Line 2588: p_msg_level=>fnd_log.level_error);

2584: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2585: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2586: p_msg_data=>x_msg_data,
2587: p_msg_type=>'SQL ERROR',
2588: p_msg_level=>fnd_log.level_error);
2589: END IF;
2590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2591: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2592: p_prefix=>l_debug_prefix,

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

2586: p_msg_data=>x_msg_data,
2587: p_msg_type=>'SQL ERROR',
2588: p_msg_level=>fnd_log.level_error);
2589: END IF;
2590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2591: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2592: p_prefix=>l_debug_prefix,
2593: p_msg_level=>fnd_log.level_procedure);
2594: END IF;

Line 2593: p_msg_level=>fnd_log.level_procedure);

2589: END IF;
2590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2591: hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
2592: p_prefix=>l_debug_prefix,
2593: p_msg_level=>fnd_log.level_procedure);
2594: END IF;
2595: END do_update_person_cust_v2_bo;
2596:
2597: PROCEDURE update_person_cust_v2_bo(

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

2657: FND_MSG_PUB.initialize;
2658: END IF;
2659:
2660: -- Debug info.
2661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2662: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(+)',
2663: p_prefix=>l_debug_prefix,
2664: p_msg_level=>fnd_log.level_procedure);
2665: END IF;

Line 2664: p_msg_level=>fnd_log.level_procedure);

2660: -- Debug info.
2661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2662: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(+)',
2663: p_prefix=>l_debug_prefix,
2664: p_msg_level=>fnd_log.level_procedure);
2665: END IF;
2666:
2667: l_person_id := p_person_cust_v2_obj.person_obj.person_id;
2668: l_person_os := p_person_cust_v2_obj.person_obj.orig_system;

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

2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;
2716:
2717: -- Debug info.
2718: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2719: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2720: p_msg_data=>x_msg_data,
2721: p_msg_type=>'WARNING',
2722: p_msg_level=>fnd_log.level_exception);

Line 2722: p_msg_level=>fnd_log.level_exception);

2718: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2719: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2720: p_msg_data=>x_msg_data,
2721: p_msg_type=>'WARNING',
2722: p_msg_level=>fnd_log.level_exception);
2723: END IF;
2724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2725: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2726: p_prefix=>l_debug_prefix,

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

2720: p_msg_data=>x_msg_data,
2721: p_msg_type=>'WARNING',
2722: p_msg_level=>fnd_log.level_exception);
2723: END IF;
2724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2725: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2726: p_prefix=>l_debug_prefix,
2727: p_msg_level=>fnd_log.level_procedure);
2728: END IF;

Line 2727: p_msg_level=>fnd_log.level_procedure);

2723: END IF;
2724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2725: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2726: p_prefix=>l_debug_prefix,
2727: p_msg_level=>fnd_log.level_procedure);
2728: END IF;
2729: EXCEPTION
2730: WHEN fnd_api.g_exc_error THEN
2731: x_return_status := fnd_api.g_ret_sts_error;

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

2734: p_count => x_msg_count,
2735: p_data => x_msg_data);
2736:
2737: -- Debug info.
2738: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2739: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2740: p_msg_data=>x_msg_data,
2741: p_msg_type=>'ERROR',
2742: p_msg_level=>fnd_log.level_error);

Line 2742: p_msg_level=>fnd_log.level_error);

2738: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2739: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2740: p_msg_data=>x_msg_data,
2741: p_msg_type=>'ERROR',
2742: p_msg_level=>fnd_log.level_error);
2743: END IF;
2744: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2745: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2746: p_prefix=>l_debug_prefix,

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

2740: p_msg_data=>x_msg_data,
2741: p_msg_type=>'ERROR',
2742: p_msg_level=>fnd_log.level_error);
2743: END IF;
2744: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2745: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2746: p_prefix=>l_debug_prefix,
2747: p_msg_level=>fnd_log.level_procedure);
2748: END IF;

Line 2747: p_msg_level=>fnd_log.level_procedure);

2743: END IF;
2744: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2745: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2746: p_prefix=>l_debug_prefix,
2747: p_msg_level=>fnd_log.level_procedure);
2748: END IF;
2749:
2750: WHEN fnd_api.g_exc_unexpected_error THEN
2751: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2754: p_count => x_msg_count,
2755: p_data => x_msg_data);
2756:
2757: -- Debug info.
2758: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2760: p_msg_data=>x_msg_data,
2761: p_msg_type=>'UNEXPECTED ERROR',
2762: p_msg_level=>fnd_log.level_error);

Line 2762: p_msg_level=>fnd_log.level_error);

2758: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2760: p_msg_data=>x_msg_data,
2761: p_msg_type=>'UNEXPECTED ERROR',
2762: p_msg_level=>fnd_log.level_error);
2763: END IF;
2764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2765: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2766: p_prefix=>l_debug_prefix,

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

2760: p_msg_data=>x_msg_data,
2761: p_msg_type=>'UNEXPECTED ERROR',
2762: p_msg_level=>fnd_log.level_error);
2763: END IF;
2764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2765: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2766: p_prefix=>l_debug_prefix,
2767: p_msg_level=>fnd_log.level_procedure);
2768: END IF;

Line 2767: p_msg_level=>fnd_log.level_procedure);

2763: END IF;
2764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2765: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2766: p_prefix=>l_debug_prefix,
2767: p_msg_level=>fnd_log.level_procedure);
2768: END IF;
2769: WHEN OTHERS THEN
2770: x_return_status := fnd_api.g_ret_sts_unexp_error;
2771:

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

2777: p_count => x_msg_count,
2778: p_data => x_msg_data);
2779:
2780: -- Debug info.
2781: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2782: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2783: p_msg_data=>x_msg_data,
2784: p_msg_type=>'SQL ERROR',
2785: p_msg_level=>fnd_log.level_error);

Line 2785: p_msg_level=>fnd_log.level_error);

2781: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2782: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2783: p_msg_data=>x_msg_data,
2784: p_msg_type=>'SQL ERROR',
2785: p_msg_level=>fnd_log.level_error);
2786: END IF;
2787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2788: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2789: p_prefix=>l_debug_prefix,

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

2783: p_msg_data=>x_msg_data,
2784: p_msg_type=>'SQL ERROR',
2785: p_msg_level=>fnd_log.level_error);
2786: END IF;
2787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2788: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2789: p_prefix=>l_debug_prefix,
2790: p_msg_level=>fnd_log.level_procedure);
2791: END IF;

Line 2790: p_msg_level=>fnd_log.level_procedure);

2786: END IF;
2787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2788: hz_utility_v2pub.debug(p_message=>'do_save_person_cust_v2_bo(-)',
2789: p_prefix=>l_debug_prefix,
2790: p_msg_level=>fnd_log.level_procedure);
2791: END IF;
2792: END do_save_person_cust_v2_bo;
2793:
2794: PROCEDURE save_person_cust_v2_bo(

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

2906: END IF;
2907:
2908:
2909: -- Debug info.
2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2911: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo(+)',
2912: p_prefix=>l_debug_prefix,
2913: p_msg_level=>fnd_log.level_procedure);
2914: END IF;

Line 2913: p_msg_level=>fnd_log.level_procedure);

2909: -- Debug info.
2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2911: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo(+)',
2912: p_prefix=>l_debug_prefix,
2913: p_msg_level=>fnd_log.level_procedure);
2914: END IF;
2915:
2916: -- check if pass in contact_point_id and/or os+osr
2917: -- extraction validation logic is same as update

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

2947: END IF;
2948:
2949:
2950: -- Debug info.
2951: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2952: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2953: p_msg_data=>x_msg_data,
2954: p_msg_type=>'WARNING',
2955: p_msg_level=>fnd_log.level_exception);

Line 2955: p_msg_level=>fnd_log.level_exception);

2951: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2952: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2953: p_msg_data=>x_msg_data,
2954: p_msg_type=>'WARNING',
2955: p_msg_level=>fnd_log.level_exception);
2956: END IF;
2957:
2958: -- Debug info.
2959: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2955: p_msg_level=>fnd_log.level_exception);
2956: END IF;
2957:
2958: -- Debug info.
2959: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2960: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
2961: p_prefix=>l_debug_prefix,
2962: p_msg_level=>fnd_log.level_procedure);
2963: END IF;

Line 2962: p_msg_level=>fnd_log.level_procedure);

2958: -- Debug info.
2959: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2960: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
2961: p_prefix=>l_debug_prefix,
2962: p_msg_level=>fnd_log.level_procedure);
2963: END IF;
2964:
2965:
2966: EXCEPTION

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

2972: p_count => x_msg_count,
2973: p_data => x_msg_data);
2974:
2975: -- Debug info.
2976: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2977: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2978: p_msg_data=>x_msg_data,
2979: p_msg_type=>'ERROR',
2980: p_msg_level=>fnd_log.level_error);

Line 2980: p_msg_level=>fnd_log.level_error);

2976: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2977: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2978: p_msg_data=>x_msg_data,
2979: p_msg_type=>'ERROR',
2980: p_msg_level=>fnd_log.level_error);
2981: END IF;
2982: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2983: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
2984: p_prefix=>l_debug_prefix,

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

2978: p_msg_data=>x_msg_data,
2979: p_msg_type=>'ERROR',
2980: p_msg_level=>fnd_log.level_error);
2981: END IF;
2982: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2983: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
2984: p_prefix=>l_debug_prefix,
2985: p_msg_level=>fnd_log.level_procedure);
2986: END IF;

Line 2985: p_msg_level=>fnd_log.level_procedure);

2981: END IF;
2982: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2983: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
2984: p_prefix=>l_debug_prefix,
2985: p_msg_level=>fnd_log.level_procedure);
2986: END IF;
2987: WHEN fnd_api.g_exc_unexpected_error THEN
2988: x_return_status := fnd_api.g_ret_sts_unexp_error;
2989:

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

2991: p_count => x_msg_count,
2992: p_data => x_msg_data);
2993:
2994: -- Debug info.
2995: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2996: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2997: p_msg_data=>x_msg_data,
2998: p_msg_type=>'UNEXPECTED ERROR',
2999: p_msg_level=>fnd_log.level_error);

Line 2999: p_msg_level=>fnd_log.level_error);

2995: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2996: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2997: p_msg_data=>x_msg_data,
2998: p_msg_type=>'UNEXPECTED ERROR',
2999: p_msg_level=>fnd_log.level_error);
3000: END IF;
3001: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3002: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
3003: p_prefix=>l_debug_prefix,

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

2997: p_msg_data=>x_msg_data,
2998: p_msg_type=>'UNEXPECTED ERROR',
2999: p_msg_level=>fnd_log.level_error);
3000: END IF;
3001: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3002: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
3003: p_prefix=>l_debug_prefix,
3004: p_msg_level=>fnd_log.level_procedure);
3005: END IF;

Line 3004: p_msg_level=>fnd_log.level_procedure);

3000: END IF;
3001: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3002: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
3003: p_prefix=>l_debug_prefix,
3004: p_msg_level=>fnd_log.level_procedure);
3005: END IF;
3006: WHEN OTHERS THEN
3007: x_return_status := fnd_api.g_ret_sts_unexp_error;
3008:

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

3014: p_count => x_msg_count,
3015: p_data => x_msg_data);
3016:
3017: -- Debug info.
3018: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3019: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3020: p_msg_data=>x_msg_data,
3021: p_msg_type=>'SQL ERROR',
3022: p_msg_level=>fnd_log.level_error);

Line 3022: p_msg_level=>fnd_log.level_error);

3018: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3019: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3020: p_msg_data=>x_msg_data,
3021: p_msg_type=>'SQL ERROR',
3022: p_msg_level=>fnd_log.level_error);
3023: END IF;
3024: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3025: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
3026: p_prefix=>l_debug_prefix,

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

3020: p_msg_data=>x_msg_data,
3021: p_msg_type=>'SQL ERROR',
3022: p_msg_level=>fnd_log.level_error);
3023: END IF;
3024: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3025: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
3026: p_prefix=>l_debug_prefix,
3027: p_msg_level=>fnd_log.level_procedure);
3028: END IF;

Line 3027: p_msg_level=>fnd_log.level_procedure);

3023: END IF;
3024: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3025: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_v2_bo (-)',
3026: p_prefix=>l_debug_prefix,
3027: p_msg_level=>fnd_log.level_procedure);
3028: END IF;
3029:
3030: end;
3031:

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

3125: END IF;
3126:
3127:
3128: -- Debug info.
3129: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3130: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(+)',
3131: p_prefix=>l_debug_prefix,
3132: p_msg_level=>fnd_log.level_procedure);
3133: END IF;

Line 3132: p_msg_level=>fnd_log.level_procedure);

3128: -- Debug info.
3129: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3130: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(+)',
3131: p_prefix=>l_debug_prefix,
3132: p_msg_level=>fnd_log.level_procedure);
3133: END IF;
3134:
3135: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3136: p_party_id => null,

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

3156:
3157:
3158:
3159: -- Debug info.
3160: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3161: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3162: p_msg_data=>x_msg_data,
3163: p_msg_type=>'WARNING',
3164: p_msg_level=>fnd_log.level_exception);

Line 3164: p_msg_level=>fnd_log.level_exception);

3160: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3161: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3162: p_msg_data=>x_msg_data,
3163: p_msg_type=>'WARNING',
3164: p_msg_level=>fnd_log.level_exception);
3165: END IF;
3166:
3167: -- Debug info.
3168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3164: p_msg_level=>fnd_log.level_exception);
3165: END IF;
3166:
3167: -- Debug info.
3168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created (-)',
3170: p_prefix=>l_debug_prefix,
3171: p_msg_level=>fnd_log.level_procedure);
3172: END IF;

Line 3171: p_msg_level=>fnd_log.level_procedure);

3167: -- Debug info.
3168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created (-)',
3170: p_prefix=>l_debug_prefix,
3171: p_msg_level=>fnd_log.level_procedure);
3172: END IF;
3173:
3174:
3175: EXCEPTION

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

3181: p_count => x_msg_count,
3182: p_data => x_msg_data);
3183:
3184: -- Debug info.
3185: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3186: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3187: p_msg_data=>x_msg_data,
3188: p_msg_type=>'ERROR',
3189: p_msg_level=>fnd_log.level_error);

Line 3189: p_msg_level=>fnd_log.level_error);

3185: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3186: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3187: p_msg_data=>x_msg_data,
3188: p_msg_type=>'ERROR',
3189: p_msg_level=>fnd_log.level_error);
3190: END IF;
3191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3192: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3193: p_prefix=>l_debug_prefix,

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

3187: p_msg_data=>x_msg_data,
3188: p_msg_type=>'ERROR',
3189: p_msg_level=>fnd_log.level_error);
3190: END IF;
3191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3192: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3193: p_prefix=>l_debug_prefix,
3194: p_msg_level=>fnd_log.level_procedure);
3195: END IF;

Line 3194: p_msg_level=>fnd_log.level_procedure);

3190: END IF;
3191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3192: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3193: p_prefix=>l_debug_prefix,
3194: p_msg_level=>fnd_log.level_procedure);
3195: END IF;
3196: WHEN fnd_api.g_exc_unexpected_error THEN
3197: x_return_status := fnd_api.g_ret_sts_unexp_error;
3198:

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

3200: p_count => x_msg_count,
3201: p_data => x_msg_data);
3202:
3203: -- Debug info.
3204: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3205: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3206: p_msg_data=>x_msg_data,
3207: p_msg_type=>'UNEXPECTED ERROR',
3208: p_msg_level=>fnd_log.level_error);

Line 3208: p_msg_level=>fnd_log.level_error);

3204: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3205: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3206: p_msg_data=>x_msg_data,
3207: p_msg_type=>'UNEXPECTED ERROR',
3208: p_msg_level=>fnd_log.level_error);
3209: END IF;
3210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3211: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3212: p_prefix=>l_debug_prefix,

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

3206: p_msg_data=>x_msg_data,
3207: p_msg_type=>'UNEXPECTED ERROR',
3208: p_msg_level=>fnd_log.level_error);
3209: END IF;
3210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3211: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3212: p_prefix=>l_debug_prefix,
3213: p_msg_level=>fnd_log.level_procedure);
3214: END IF;

Line 3213: p_msg_level=>fnd_log.level_procedure);

3209: END IF;
3210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3211: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3212: p_prefix=>l_debug_prefix,
3213: p_msg_level=>fnd_log.level_procedure);
3214: END IF;
3215: WHEN OTHERS THEN
3216: x_return_status := fnd_api.g_ret_sts_unexp_error;
3217:

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

3223: p_count => x_msg_count,
3224: p_data => x_msg_data);
3225:
3226: -- Debug info.
3227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3229: p_msg_data=>x_msg_data,
3230: p_msg_type=>'SQL ERROR',
3231: p_msg_level=>fnd_log.level_error);

Line 3231: p_msg_level=>fnd_log.level_error);

3227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3229: p_msg_data=>x_msg_data,
3230: p_msg_type=>'SQL ERROR',
3231: p_msg_level=>fnd_log.level_error);
3232: END IF;
3233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3234: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3235: p_prefix=>l_debug_prefix,

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

3229: p_msg_data=>x_msg_data,
3230: p_msg_type=>'SQL ERROR',
3231: p_msg_level=>fnd_log.level_error);
3232: END IF;
3233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3234: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3235: p_prefix=>l_debug_prefix,
3236: p_msg_level=>fnd_log.level_procedure);
3237: END IF;

Line 3236: p_msg_level=>fnd_log.level_procedure);

3232: END IF;
3233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3234: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_created(-)',
3235: p_prefix=>l_debug_prefix,
3236: p_msg_level=>fnd_log.level_procedure);
3237: END IF;
3238:
3239: end;
3240:

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

3328: END IF;
3329:
3330:
3331: -- Debug info.
3332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3333: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(+)',
3334: p_prefix=>l_debug_prefix,
3335: p_msg_level=>fnd_log.level_procedure);
3336: END IF;

Line 3335: p_msg_level=>fnd_log.level_procedure);

3331: -- Debug info.
3332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3333: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(+)',
3334: p_prefix=>l_debug_prefix,
3335: p_msg_level=>fnd_log.level_procedure);
3336: END IF;
3337:
3338: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3339: p_party_id => null,

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

3359:
3360:
3361:
3362: -- Debug info.
3363: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3364: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3365: p_msg_data=>x_msg_data,
3366: p_msg_type=>'WARNING',
3367: p_msg_level=>fnd_log.level_exception);

Line 3367: p_msg_level=>fnd_log.level_exception);

3363: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3364: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3365: p_msg_data=>x_msg_data,
3366: p_msg_type=>'WARNING',
3367: p_msg_level=>fnd_log.level_exception);
3368: END IF;
3369:
3370: -- Debug info.
3371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3367: p_msg_level=>fnd_log.level_exception);
3368: END IF;
3369:
3370: -- Debug info.
3371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3372: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated (-)',
3373: p_prefix=>l_debug_prefix,
3374: p_msg_level=>fnd_log.level_procedure);
3375: END IF;

Line 3374: p_msg_level=>fnd_log.level_procedure);

3370: -- Debug info.
3371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3372: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated (-)',
3373: p_prefix=>l_debug_prefix,
3374: p_msg_level=>fnd_log.level_procedure);
3375: END IF;
3376:
3377:
3378: EXCEPTION

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

3384: p_count => x_msg_count,
3385: p_data => x_msg_data);
3386:
3387: -- Debug info.
3388: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3389: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3390: p_msg_data=>x_msg_data,
3391: p_msg_type=>'ERROR',
3392: p_msg_level=>fnd_log.level_error);

Line 3392: p_msg_level=>fnd_log.level_error);

3388: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3389: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3390: p_msg_data=>x_msg_data,
3391: p_msg_type=>'ERROR',
3392: p_msg_level=>fnd_log.level_error);
3393: END IF;
3394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3395: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3396: p_prefix=>l_debug_prefix,

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

3390: p_msg_data=>x_msg_data,
3391: p_msg_type=>'ERROR',
3392: p_msg_level=>fnd_log.level_error);
3393: END IF;
3394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3395: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3396: p_prefix=>l_debug_prefix,
3397: p_msg_level=>fnd_log.level_procedure);
3398: END IF;

Line 3397: p_msg_level=>fnd_log.level_procedure);

3393: END IF;
3394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3395: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3396: p_prefix=>l_debug_prefix,
3397: p_msg_level=>fnd_log.level_procedure);
3398: END IF;
3399: WHEN fnd_api.g_exc_unexpected_error THEN
3400: x_return_status := fnd_api.g_ret_sts_unexp_error;
3401:

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

3403: p_count => x_msg_count,
3404: p_data => x_msg_data);
3405:
3406: -- Debug info.
3407: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3408: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3409: p_msg_data=>x_msg_data,
3410: p_msg_type=>'UNEXPECTED ERROR',
3411: p_msg_level=>fnd_log.level_error);

Line 3411: p_msg_level=>fnd_log.level_error);

3407: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3408: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3409: p_msg_data=>x_msg_data,
3410: p_msg_type=>'UNEXPECTED ERROR',
3411: p_msg_level=>fnd_log.level_error);
3412: END IF;
3413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3414: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3415: p_prefix=>l_debug_prefix,

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

3409: p_msg_data=>x_msg_data,
3410: p_msg_type=>'UNEXPECTED ERROR',
3411: p_msg_level=>fnd_log.level_error);
3412: END IF;
3413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3414: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3415: p_prefix=>l_debug_prefix,
3416: p_msg_level=>fnd_log.level_procedure);
3417: END IF;

Line 3416: p_msg_level=>fnd_log.level_procedure);

3412: END IF;
3413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3414: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3415: p_prefix=>l_debug_prefix,
3416: p_msg_level=>fnd_log.level_procedure);
3417: END IF;
3418: WHEN OTHERS THEN
3419: x_return_status := fnd_api.g_ret_sts_unexp_error;
3420:

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

3426: p_count => x_msg_count,
3427: p_data => x_msg_data);
3428:
3429: -- Debug info.
3430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3432: p_msg_data=>x_msg_data,
3433: p_msg_type=>'SQL ERROR',
3434: p_msg_level=>fnd_log.level_error);

Line 3434: p_msg_level=>fnd_log.level_error);

3430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3432: p_msg_data=>x_msg_data,
3433: p_msg_type=>'SQL ERROR',
3434: p_msg_level=>fnd_log.level_error);
3435: END IF;
3436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3437: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3438: p_prefix=>l_debug_prefix,

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

3432: p_msg_data=>x_msg_data,
3433: p_msg_type=>'SQL ERROR',
3434: p_msg_level=>fnd_log.level_error);
3435: END IF;
3436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3437: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3438: p_prefix=>l_debug_prefix,
3439: p_msg_level=>fnd_log.level_procedure);
3440: END IF;

Line 3439: p_msg_level=>fnd_log.level_procedure);

3435: END IF;
3436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3437: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
3438: p_prefix=>l_debug_prefix,
3439: p_msg_level=>fnd_log.level_procedure);
3440: END IF;
3441:
3442: end;
3443:

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

3517: END IF;
3518:
3519:
3520: -- Debug info.
3521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3522: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(+)',
3523: p_prefix=>l_debug_prefix,
3524: p_msg_level=>fnd_log.level_procedure);
3525: END IF;

Line 3524: p_msg_level=>fnd_log.level_procedure);

3520: -- Debug info.
3521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3522: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(+)',
3523: p_prefix=>l_debug_prefix,
3524: p_msg_level=>fnd_log.level_procedure);
3525: END IF;
3526:
3527: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3528: p_party_id => p_person_cust_id,

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

3549:
3550:
3551:
3552: -- Debug info.
3553: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3554: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3555: p_msg_data=>x_msg_data,
3556: p_msg_type=>'WARNING',
3557: p_msg_level=>fnd_log.level_exception);

Line 3557: p_msg_level=>fnd_log.level_exception);

3553: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3554: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3555: p_msg_data=>x_msg_data,
3556: p_msg_type=>'WARNING',
3557: p_msg_level=>fnd_log.level_exception);
3558: END IF;
3559:
3560: -- Debug info.
3561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3557: p_msg_level=>fnd_log.level_exception);
3558: END IF;
3559:
3560: -- Debug info.
3561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3562: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated (-)',
3563: p_prefix=>l_debug_prefix,
3564: p_msg_level=>fnd_log.level_procedure);
3565: END IF;

Line 3564: p_msg_level=>fnd_log.level_procedure);

3560: -- Debug info.
3561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3562: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated (-)',
3563: p_prefix=>l_debug_prefix,
3564: p_msg_level=>fnd_log.level_procedure);
3565: END IF;
3566:
3567:
3568: EXCEPTION

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

3574: p_count => x_msg_count,
3575: p_data => x_msg_data);
3576:
3577: -- Debug info.
3578: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3579: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3580: p_msg_data=>x_msg_data,
3581: p_msg_type=>'ERROR',
3582: p_msg_level=>fnd_log.level_error);

Line 3582: p_msg_level=>fnd_log.level_error);

3578: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3579: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3580: p_msg_data=>x_msg_data,
3581: p_msg_type=>'ERROR',
3582: p_msg_level=>fnd_log.level_error);
3583: END IF;
3584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3585: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3586: p_prefix=>l_debug_prefix,

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

3580: p_msg_data=>x_msg_data,
3581: p_msg_type=>'ERROR',
3582: p_msg_level=>fnd_log.level_error);
3583: END IF;
3584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3585: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3586: p_prefix=>l_debug_prefix,
3587: p_msg_level=>fnd_log.level_procedure);
3588: END IF;

Line 3587: p_msg_level=>fnd_log.level_procedure);

3583: END IF;
3584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3585: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3586: p_prefix=>l_debug_prefix,
3587: p_msg_level=>fnd_log.level_procedure);
3588: END IF;
3589: WHEN fnd_api.g_exc_unexpected_error THEN
3590: x_return_status := fnd_api.g_ret_sts_unexp_error;
3591:

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

3593: p_count => x_msg_count,
3594: p_data => x_msg_data);
3595:
3596: -- Debug info.
3597: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3598: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3599: p_msg_data=>x_msg_data,
3600: p_msg_type=>'UNEXPECTED ERROR',
3601: p_msg_level=>fnd_log.level_error);

Line 3601: p_msg_level=>fnd_log.level_error);

3597: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3598: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3599: p_msg_data=>x_msg_data,
3600: p_msg_type=>'UNEXPECTED ERROR',
3601: p_msg_level=>fnd_log.level_error);
3602: END IF;
3603: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3604: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3605: p_prefix=>l_debug_prefix,

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

3599: p_msg_data=>x_msg_data,
3600: p_msg_type=>'UNEXPECTED ERROR',
3601: p_msg_level=>fnd_log.level_error);
3602: END IF;
3603: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3604: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3605: p_prefix=>l_debug_prefix,
3606: p_msg_level=>fnd_log.level_procedure);
3607: END IF;

Line 3606: p_msg_level=>fnd_log.level_procedure);

3602: END IF;
3603: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3604: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3605: p_prefix=>l_debug_prefix,
3606: p_msg_level=>fnd_log.level_procedure);
3607: END IF;
3608: WHEN OTHERS THEN
3609: x_return_status := fnd_api.g_ret_sts_unexp_error;
3610:

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

3616: p_count => x_msg_count,
3617: p_data => x_msg_data);
3618:
3619: -- Debug info.
3620: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3621: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3622: p_msg_data=>x_msg_data,
3623: p_msg_type=>'SQL ERROR',
3624: p_msg_level=>fnd_log.level_error);

Line 3624: p_msg_level=>fnd_log.level_error);

3620: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3621: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3622: p_msg_data=>x_msg_data,
3623: p_msg_type=>'SQL ERROR',
3624: p_msg_level=>fnd_log.level_error);
3625: END IF;
3626: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3627: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3628: p_prefix=>l_debug_prefix,

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

3622: p_msg_data=>x_msg_data,
3623: p_msg_type=>'SQL ERROR',
3624: p_msg_level=>fnd_log.level_error);
3625: END IF;
3626: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3627: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3628: p_prefix=>l_debug_prefix,
3629: p_msg_level=>fnd_log.level_procedure);
3630: END IF;

Line 3629: p_msg_level=>fnd_log.level_procedure);

3625: END IF;
3626: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3627: hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
3628: p_prefix=>l_debug_prefix,
3629: p_msg_level=>fnd_log.level_procedure);
3630: END IF;
3631:
3632: end;
3633: