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

APPS.HZ_EXTRACT_PERSON_CUST_BO_PVT dependencies on FND_LOG

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

83: END IF;
84:
85:
86: -- Debug info.
87: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
88: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo(+)',
89: p_prefix=>l_debug_prefix,
90: p_msg_level=>fnd_log.level_procedure);
91: END IF;

Line 90: p_msg_level=>fnd_log.level_procedure);

86: -- Debug info.
87: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
88: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo(+)',
89: p_prefix=>l_debug_prefix,
90: p_msg_level=>fnd_log.level_procedure);
91: END IF;
92:
93: x_person_cust_obj := HZ_PERSON_CUST_BO(p_action_type, NULL, NULL);
94:

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

121: END IF;
122:
123:
124: -- Debug info.
125: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
126: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
127: p_msg_data=>x_msg_data,
128: p_msg_type=>'WARNING',
129: p_msg_level=>fnd_log.level_exception);

Line 129: p_msg_level=>fnd_log.level_exception);

125: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
126: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
127: p_msg_data=>x_msg_data,
128: p_msg_type=>'WARNING',
129: p_msg_level=>fnd_log.level_exception);
130: END IF;
131:
132: -- Debug info.
133: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

129: p_msg_level=>fnd_log.level_exception);
130: END IF;
131:
132: -- Debug info.
133: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
134: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
135: p_prefix=>l_debug_prefix,
136: p_msg_level=>fnd_log.level_procedure);
137: END IF;

Line 136: p_msg_level=>fnd_log.level_procedure);

132: -- Debug info.
133: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
134: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
135: p_prefix=>l_debug_prefix,
136: p_msg_level=>fnd_log.level_procedure);
137: END IF;
138:
139:
140: EXCEPTION

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

146: p_count => x_msg_count,
147: p_data => x_msg_data);
148:
149: -- Debug info.
150: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
151: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
152: p_msg_data=>x_msg_data,
153: p_msg_type=>'ERROR',
154: p_msg_level=>fnd_log.level_error);

Line 154: p_msg_level=>fnd_log.level_error);

150: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
151: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
152: p_msg_data=>x_msg_data,
153: p_msg_type=>'ERROR',
154: p_msg_level=>fnd_log.level_error);
155: END IF;
156: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
157: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
158: p_prefix=>l_debug_prefix,

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

152: p_msg_data=>x_msg_data,
153: p_msg_type=>'ERROR',
154: p_msg_level=>fnd_log.level_error);
155: END IF;
156: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
157: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
158: p_prefix=>l_debug_prefix,
159: p_msg_level=>fnd_log.level_procedure);
160: END IF;

Line 159: p_msg_level=>fnd_log.level_procedure);

155: END IF;
156: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
157: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
158: p_prefix=>l_debug_prefix,
159: p_msg_level=>fnd_log.level_procedure);
160: END IF;
161: WHEN fnd_api.g_exc_unexpected_error THEN
162: x_return_status := fnd_api.g_ret_sts_unexp_error;
163:

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

165: p_count => x_msg_count,
166: p_data => x_msg_data);
167:
168: -- Debug info.
169: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
170: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
171: p_msg_data=>x_msg_data,
172: p_msg_type=>'UNEXPECTED ERROR',
173: p_msg_level=>fnd_log.level_error);

Line 173: p_msg_level=>fnd_log.level_error);

169: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
170: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
171: p_msg_data=>x_msg_data,
172: p_msg_type=>'UNEXPECTED ERROR',
173: p_msg_level=>fnd_log.level_error);
174: END IF;
175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
176: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
177: p_prefix=>l_debug_prefix,

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

171: p_msg_data=>x_msg_data,
172: p_msg_type=>'UNEXPECTED ERROR',
173: p_msg_level=>fnd_log.level_error);
174: END IF;
175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
176: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
177: p_prefix=>l_debug_prefix,
178: p_msg_level=>fnd_log.level_procedure);
179: END IF;

Line 178: p_msg_level=>fnd_log.level_procedure);

174: END IF;
175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
176: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
177: p_prefix=>l_debug_prefix,
178: p_msg_level=>fnd_log.level_procedure);
179: END IF;
180: WHEN OTHERS THEN
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182:

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

188: p_count => x_msg_count,
189: p_data => x_msg_data);
190:
191: -- Debug info.
192: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
194: p_msg_data=>x_msg_data,
195: p_msg_type=>'SQL ERROR',
196: p_msg_level=>fnd_log.level_error);

Line 196: p_msg_level=>fnd_log.level_error);

192: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
194: p_msg_data=>x_msg_data,
195: p_msg_type=>'SQL ERROR',
196: p_msg_level=>fnd_log.level_error);
197: END IF;
198: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
199: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
200: p_prefix=>l_debug_prefix,

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

194: p_msg_data=>x_msg_data,
195: p_msg_type=>'SQL ERROR',
196: p_msg_level=>fnd_log.level_error);
197: END IF;
198: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
199: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
200: p_prefix=>l_debug_prefix,
201: p_msg_level=>fnd_log.level_procedure);
202: END IF;

Line 201: p_msg_level=>fnd_log.level_procedure);

197: END IF;
198: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
199: hz_utility_v2pub.debug(p_message=>'get_person_cust_bo (-)',
200: p_prefix=>l_debug_prefix,
201: p_msg_level=>fnd_log.level_procedure);
202: END IF;
203:
204: end;
205:

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

297: END IF;
298:
299:
300: -- Debug info.
301: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
302: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(+)',
303: p_prefix=>l_debug_prefix,
304: p_msg_level=>fnd_log.level_procedure);
305: END IF;

Line 304: p_msg_level=>fnd_log.level_procedure);

300: -- Debug info.
301: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
302: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(+)',
303: p_prefix=>l_debug_prefix,
304: p_msg_level=>fnd_log.level_procedure);
305: END IF;
306:
307:
308: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

375: end if;
376: end loop;
377:
378: -- Debug info.
379: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
380: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
381: p_msg_data=>x_msg_data,
382: p_msg_type=>'WARNING',
383: p_msg_level=>fnd_log.level_exception);

Line 383: p_msg_level=>fnd_log.level_exception);

379: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
380: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
381: p_msg_data=>x_msg_data,
382: p_msg_type=>'WARNING',
383: p_msg_level=>fnd_log.level_exception);
384: END IF;
385:
386: -- Debug info.
387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

383: p_msg_level=>fnd_log.level_exception);
384: END IF;
385:
386: -- Debug info.
387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
388: hz_utility_v2pub.debug(p_message=>'get_person_cust_created (-)',
389: p_prefix=>l_debug_prefix,
390: p_msg_level=>fnd_log.level_procedure);
391: END IF;

Line 390: p_msg_level=>fnd_log.level_procedure);

386: -- Debug info.
387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
388: hz_utility_v2pub.debug(p_message=>'get_person_cust_created (-)',
389: p_prefix=>l_debug_prefix,
390: p_msg_level=>fnd_log.level_procedure);
391: END IF;
392:
393:
394: EXCEPTION

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

400: p_count => x_msg_count,
401: p_data => x_msg_data);
402:
403: -- Debug info.
404: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
405: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
406: p_msg_data=>x_msg_data,
407: p_msg_type=>'ERROR',
408: p_msg_level=>fnd_log.level_error);

Line 408: p_msg_level=>fnd_log.level_error);

404: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
405: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
406: p_msg_data=>x_msg_data,
407: p_msg_type=>'ERROR',
408: p_msg_level=>fnd_log.level_error);
409: END IF;
410: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
411: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
412: p_prefix=>l_debug_prefix,

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

406: p_msg_data=>x_msg_data,
407: p_msg_type=>'ERROR',
408: p_msg_level=>fnd_log.level_error);
409: END IF;
410: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
411: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
412: p_prefix=>l_debug_prefix,
413: p_msg_level=>fnd_log.level_procedure);
414: END IF;

Line 413: p_msg_level=>fnd_log.level_procedure);

409: END IF;
410: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
411: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
412: p_prefix=>l_debug_prefix,
413: p_msg_level=>fnd_log.level_procedure);
414: END IF;
415: WHEN fnd_api.g_exc_unexpected_error THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417:

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

419: p_count => x_msg_count,
420: p_data => x_msg_data);
421:
422: -- Debug info.
423: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
425: p_msg_data=>x_msg_data,
426: p_msg_type=>'UNEXPECTED ERROR',
427: p_msg_level=>fnd_log.level_error);

Line 427: p_msg_level=>fnd_log.level_error);

423: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
425: p_msg_data=>x_msg_data,
426: p_msg_type=>'UNEXPECTED ERROR',
427: p_msg_level=>fnd_log.level_error);
428: END IF;
429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
430: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
431: p_prefix=>l_debug_prefix,

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

425: p_msg_data=>x_msg_data,
426: p_msg_type=>'UNEXPECTED ERROR',
427: p_msg_level=>fnd_log.level_error);
428: END IF;
429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
430: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
431: p_prefix=>l_debug_prefix,
432: p_msg_level=>fnd_log.level_procedure);
433: END IF;

Line 432: p_msg_level=>fnd_log.level_procedure);

428: END IF;
429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
430: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
431: p_prefix=>l_debug_prefix,
432: p_msg_level=>fnd_log.level_procedure);
433: END IF;
434: WHEN OTHERS THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436:

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

442: p_count => x_msg_count,
443: p_data => x_msg_data);
444:
445: -- Debug info.
446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
448: p_msg_data=>x_msg_data,
449: p_msg_type=>'SQL ERROR',
450: p_msg_level=>fnd_log.level_error);

Line 450: p_msg_level=>fnd_log.level_error);

446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
448: p_msg_data=>x_msg_data,
449: p_msg_type=>'SQL ERROR',
450: p_msg_level=>fnd_log.level_error);
451: END IF;
452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
453: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
454: p_prefix=>l_debug_prefix,

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

448: p_msg_data=>x_msg_data,
449: p_msg_type=>'SQL ERROR',
450: p_msg_level=>fnd_log.level_error);
451: END IF;
452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
453: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
454: p_prefix=>l_debug_prefix,
455: p_msg_level=>fnd_log.level_procedure);
456: END IF;

Line 455: p_msg_level=>fnd_log.level_procedure);

451: END IF;
452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
453: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
454: p_prefix=>l_debug_prefix,
455: p_msg_level=>fnd_log.level_procedure);
456: END IF;
457:
458: end;
459:

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

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

Line 533: p_msg_level=>fnd_log.level_procedure);

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

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

570: end loop;
571:
572:
573: -- Debug info.
574: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
576: p_msg_data=>x_msg_data,
577: p_msg_type=>'WARNING',
578: p_msg_level=>fnd_log.level_exception);

Line 578: p_msg_level=>fnd_log.level_exception);

574: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
576: p_msg_data=>x_msg_data,
577: p_msg_type=>'WARNING',
578: p_msg_level=>fnd_log.level_exception);
579: END IF;
580:
581: -- Debug info.
582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

578: p_msg_level=>fnd_log.level_exception);
579: END IF;
580:
581: -- Debug info.
582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
583: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated (-)',
584: p_prefix=>l_debug_prefix,
585: p_msg_level=>fnd_log.level_procedure);
586: END IF;

Line 585: p_msg_level=>fnd_log.level_procedure);

581: -- Debug info.
582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
583: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated (-)',
584: p_prefix=>l_debug_prefix,
585: p_msg_level=>fnd_log.level_procedure);
586: END IF;
587:
588:
589: EXCEPTION

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

595: p_count => x_msg_count,
596: p_data => x_msg_data);
597:
598: -- Debug info.
599: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
601: p_msg_data=>x_msg_data,
602: p_msg_type=>'ERROR',
603: p_msg_level=>fnd_log.level_error);

Line 603: p_msg_level=>fnd_log.level_error);

599: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
601: p_msg_data=>x_msg_data,
602: p_msg_type=>'ERROR',
603: p_msg_level=>fnd_log.level_error);
604: END IF;
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
607: p_prefix=>l_debug_prefix,

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

601: p_msg_data=>x_msg_data,
602: p_msg_type=>'ERROR',
603: p_msg_level=>fnd_log.level_error);
604: END IF;
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;

Line 608: p_msg_level=>fnd_log.level_procedure);

604: END IF;
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;
610: WHEN fnd_api.g_exc_unexpected_error THEN
611: x_return_status := fnd_api.g_ret_sts_unexp_error;
612:

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

614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617: -- Debug info.
618: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
620: p_msg_data=>x_msg_data,
621: p_msg_type=>'UNEXPECTED ERROR',
622: p_msg_level=>fnd_log.level_error);

Line 622: p_msg_level=>fnd_log.level_error);

618: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
620: p_msg_data=>x_msg_data,
621: p_msg_type=>'UNEXPECTED ERROR',
622: p_msg_level=>fnd_log.level_error);
623: END IF;
624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
625: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
626: p_prefix=>l_debug_prefix,

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

620: p_msg_data=>x_msg_data,
621: p_msg_type=>'UNEXPECTED ERROR',
622: p_msg_level=>fnd_log.level_error);
623: END IF;
624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
625: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;

Line 627: p_msg_level=>fnd_log.level_procedure);

623: END IF;
624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
625: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;
629: WHEN OTHERS THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631:

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

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

Line 645: p_msg_level=>fnd_log.level_error);

641: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
643: p_msg_data=>x_msg_data,
644: p_msg_type=>'SQL ERROR',
645: p_msg_level=>fnd_log.level_error);
646: END IF;
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
649: p_prefix=>l_debug_prefix,

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

643: p_msg_data=>x_msg_data,
644: p_msg_type=>'SQL ERROR',
645: p_msg_level=>fnd_log.level_error);
646: END IF;
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;

Line 650: p_msg_level=>fnd_log.level_procedure);

646: END IF;
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;
652:
653: end;
654:

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

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

Line 1053: p_msg_level=>fnd_log.level_procedure);

1049: -- Debug info.
1050: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1051: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(+)',
1052: p_prefix=>l_debug_prefix,
1053: p_msg_level=>fnd_log.level_procedure);
1054: END IF;
1055: /* moved to public api
1056: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1057: p_party_id => p_person_cust_id,

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

1093:
1094:
1095:
1096: -- Debug info.
1097: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1098: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1099: p_msg_data=>x_msg_data,
1100: p_msg_type=>'WARNING',
1101: p_msg_level=>fnd_log.level_exception);

Line 1101: p_msg_level=>fnd_log.level_exception);

1097: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1098: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1099: p_msg_data=>x_msg_data,
1100: p_msg_type=>'WARNING',
1101: p_msg_level=>fnd_log.level_exception);
1102: END IF;
1103:
1104: -- Debug info.
1105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1101: p_msg_level=>fnd_log.level_exception);
1102: END IF;
1103:
1104: -- Debug info.
1105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1106: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated (-)',
1107: p_prefix=>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_procedure);
1109: END IF;

Line 1108: p_msg_level=>fnd_log.level_procedure);

1104: -- Debug info.
1105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1106: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated (-)',
1107: p_prefix=>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_procedure);
1109: END IF;
1110:
1111:
1112: EXCEPTION

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

1118: p_count => x_msg_count,
1119: p_data => x_msg_data);
1120:
1121: -- Debug info.
1122: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1123: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1124: p_msg_data=>x_msg_data,
1125: p_msg_type=>'ERROR',
1126: p_msg_level=>fnd_log.level_error);

Line 1126: p_msg_level=>fnd_log.level_error);

1122: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1123: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1124: p_msg_data=>x_msg_data,
1125: p_msg_type=>'ERROR',
1126: p_msg_level=>fnd_log.level_error);
1127: END IF;
1128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1129: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1130: p_prefix=>l_debug_prefix,

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

1124: p_msg_data=>x_msg_data,
1125: p_msg_type=>'ERROR',
1126: p_msg_level=>fnd_log.level_error);
1127: END IF;
1128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1129: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1130: p_prefix=>l_debug_prefix,
1131: p_msg_level=>fnd_log.level_procedure);
1132: END IF;

Line 1131: p_msg_level=>fnd_log.level_procedure);

1127: END IF;
1128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1129: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1130: p_prefix=>l_debug_prefix,
1131: p_msg_level=>fnd_log.level_procedure);
1132: END IF;
1133: WHEN fnd_api.g_exc_unexpected_error THEN
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135:

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

1137: p_count => x_msg_count,
1138: p_data => x_msg_data);
1139:
1140: -- Debug info.
1141: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1143: p_msg_data=>x_msg_data,
1144: p_msg_type=>'UNEXPECTED ERROR',
1145: p_msg_level=>fnd_log.level_error);

Line 1145: p_msg_level=>fnd_log.level_error);

1141: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1143: p_msg_data=>x_msg_data,
1144: p_msg_type=>'UNEXPECTED ERROR',
1145: p_msg_level=>fnd_log.level_error);
1146: END IF;
1147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1148: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1149: p_prefix=>l_debug_prefix,

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

1143: p_msg_data=>x_msg_data,
1144: p_msg_type=>'UNEXPECTED ERROR',
1145: p_msg_level=>fnd_log.level_error);
1146: END IF;
1147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1148: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1149: p_prefix=>l_debug_prefix,
1150: p_msg_level=>fnd_log.level_procedure);
1151: END IF;

Line 1150: p_msg_level=>fnd_log.level_procedure);

1146: END IF;
1147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1148: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1149: p_prefix=>l_debug_prefix,
1150: p_msg_level=>fnd_log.level_procedure);
1151: END IF;
1152: WHEN OTHERS THEN
1153: x_return_status := fnd_api.g_ret_sts_unexp_error;
1154:

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

1160: p_count => x_msg_count,
1161: p_data => x_msg_data);
1162:
1163: -- Debug info.
1164: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1165: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1166: p_msg_data=>x_msg_data,
1167: p_msg_type=>'SQL ERROR',
1168: p_msg_level=>fnd_log.level_error);

Line 1168: p_msg_level=>fnd_log.level_error);

1164: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1165: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1166: p_msg_data=>x_msg_data,
1167: p_msg_type=>'SQL ERROR',
1168: p_msg_level=>fnd_log.level_error);
1169: END IF;
1170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1172: p_prefix=>l_debug_prefix,

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

1166: p_msg_data=>x_msg_data,
1167: p_msg_type=>'SQL ERROR',
1168: p_msg_level=>fnd_log.level_error);
1169: END IF;
1170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1172: p_prefix=>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_procedure);
1174: END IF;

Line 1173: p_msg_level=>fnd_log.level_procedure);

1169: END IF;
1170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1172: p_prefix=>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_procedure);
1174: END IF;
1175:
1176: end;
1177:

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

1248: END IF;
1249:
1250:
1251: -- Debug info.
1252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1253: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo(+)',
1254: p_prefix=>l_debug_prefix,
1255: p_msg_level=>fnd_log.level_procedure);
1256: END IF;

Line 1255: p_msg_level=>fnd_log.level_procedure);

1251: -- Debug info.
1252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1253: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo(+)',
1254: p_prefix=>l_debug_prefix,
1255: p_msg_level=>fnd_log.level_procedure);
1256: END IF;
1257:
1258: x_person_cust_v2_obj := HZ_PERSON_CUST_V2_BO(p_action_type, NULL, NULL);
1259:

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

1286: END IF;
1287:
1288:
1289: -- Debug info.
1290: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1291: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1292: p_msg_data=>x_msg_data,
1293: p_msg_type=>'WARNING',
1294: p_msg_level=>fnd_log.level_exception);

Line 1294: p_msg_level=>fnd_log.level_exception);

1290: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1291: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1292: p_msg_data=>x_msg_data,
1293: p_msg_type=>'WARNING',
1294: p_msg_level=>fnd_log.level_exception);
1295: END IF;
1296:
1297: -- Debug info.
1298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1294: p_msg_level=>fnd_log.level_exception);
1295: END IF;
1296:
1297: -- Debug info.
1298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1300: p_prefix=>l_debug_prefix,
1301: p_msg_level=>fnd_log.level_procedure);
1302: END IF;

Line 1301: p_msg_level=>fnd_log.level_procedure);

1297: -- Debug info.
1298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1300: p_prefix=>l_debug_prefix,
1301: p_msg_level=>fnd_log.level_procedure);
1302: END IF;
1303:
1304:
1305: EXCEPTION

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

1311: p_count => x_msg_count,
1312: p_data => x_msg_data);
1313:
1314: -- Debug info.
1315: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1317: p_msg_data=>x_msg_data,
1318: p_msg_type=>'ERROR',
1319: p_msg_level=>fnd_log.level_error);

Line 1319: p_msg_level=>fnd_log.level_error);

1315: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1317: p_msg_data=>x_msg_data,
1318: p_msg_type=>'ERROR',
1319: p_msg_level=>fnd_log.level_error);
1320: END IF;
1321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1322: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1323: p_prefix=>l_debug_prefix,

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

1317: p_msg_data=>x_msg_data,
1318: p_msg_type=>'ERROR',
1319: p_msg_level=>fnd_log.level_error);
1320: END IF;
1321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1322: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1323: p_prefix=>l_debug_prefix,
1324: p_msg_level=>fnd_log.level_procedure);
1325: END IF;

Line 1324: p_msg_level=>fnd_log.level_procedure);

1320: END IF;
1321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1322: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1323: p_prefix=>l_debug_prefix,
1324: p_msg_level=>fnd_log.level_procedure);
1325: END IF;
1326: WHEN fnd_api.g_exc_unexpected_error THEN
1327: x_return_status := fnd_api.g_ret_sts_unexp_error;
1328:

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

1330: p_count => x_msg_count,
1331: p_data => x_msg_data);
1332:
1333: -- Debug info.
1334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1335: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1336: p_msg_data=>x_msg_data,
1337: p_msg_type=>'UNEXPECTED ERROR',
1338: p_msg_level=>fnd_log.level_error);

Line 1338: p_msg_level=>fnd_log.level_error);

1334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1335: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1336: p_msg_data=>x_msg_data,
1337: p_msg_type=>'UNEXPECTED ERROR',
1338: p_msg_level=>fnd_log.level_error);
1339: END IF;
1340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1341: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1342: p_prefix=>l_debug_prefix,

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

1336: p_msg_data=>x_msg_data,
1337: p_msg_type=>'UNEXPECTED ERROR',
1338: p_msg_level=>fnd_log.level_error);
1339: END IF;
1340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1341: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1342: p_prefix=>l_debug_prefix,
1343: p_msg_level=>fnd_log.level_procedure);
1344: END IF;

Line 1343: p_msg_level=>fnd_log.level_procedure);

1339: END IF;
1340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1341: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1342: p_prefix=>l_debug_prefix,
1343: p_msg_level=>fnd_log.level_procedure);
1344: END IF;
1345: WHEN OTHERS THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:

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

1353: p_count => x_msg_count,
1354: p_data => x_msg_data);
1355:
1356: -- Debug info.
1357: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1358: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'SQL ERROR',
1361: p_msg_level=>fnd_log.level_error);

Line 1361: p_msg_level=>fnd_log.level_error);

1357: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1358: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'SQL ERROR',
1361: p_msg_level=>fnd_log.level_error);
1362: END IF;
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1365: p_prefix=>l_debug_prefix,

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

1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'SQL ERROR',
1361: p_msg_level=>fnd_log.level_error);
1362: END IF;
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;

Line 1366: p_msg_level=>fnd_log.level_procedure);

1362: END IF;
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;
1368:
1369: end;
1370:

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

1443: END IF;
1444:
1445:
1446: -- Debug info.
1447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1448: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(+)',
1449: p_prefix=>l_debug_prefix,
1450: p_msg_level=>fnd_log.level_procedure);
1451: END IF;

Line 1450: p_msg_level=>fnd_log.level_procedure);

1446: -- Debug info.
1447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1448: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(+)',
1449: p_prefix=>l_debug_prefix,
1450: p_msg_level=>fnd_log.level_procedure);
1451: END IF;
1452:
1453:
1454: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

1521: end if;
1522: end loop;
1523:
1524: -- Debug info.
1525: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1526: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1527: p_msg_data=>x_msg_data,
1528: p_msg_type=>'WARNING',
1529: p_msg_level=>fnd_log.level_exception);

Line 1529: p_msg_level=>fnd_log.level_exception);

1525: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1526: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1527: p_msg_data=>x_msg_data,
1528: p_msg_type=>'WARNING',
1529: p_msg_level=>fnd_log.level_exception);
1530: END IF;
1531:
1532: -- Debug info.
1533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

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

Line 1536: p_msg_level=>fnd_log.level_procedure);

1532: -- Debug info.
1533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1534: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created (-)',
1535: p_prefix=>l_debug_prefix,
1536: p_msg_level=>fnd_log.level_procedure);
1537: END IF;
1538:
1539:
1540: EXCEPTION

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

1546: p_count => x_msg_count,
1547: p_data => x_msg_data);
1548:
1549: -- Debug info.
1550: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1551: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1552: p_msg_data=>x_msg_data,
1553: p_msg_type=>'ERROR',
1554: p_msg_level=>fnd_log.level_error);

Line 1554: p_msg_level=>fnd_log.level_error);

1550: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1551: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1552: p_msg_data=>x_msg_data,
1553: p_msg_type=>'ERROR',
1554: p_msg_level=>fnd_log.level_error);
1555: END IF;
1556: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1557: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1558: p_prefix=>l_debug_prefix,

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

1552: p_msg_data=>x_msg_data,
1553: p_msg_type=>'ERROR',
1554: p_msg_level=>fnd_log.level_error);
1555: END IF;
1556: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1557: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1558: p_prefix=>l_debug_prefix,
1559: p_msg_level=>fnd_log.level_procedure);
1560: END IF;

Line 1559: p_msg_level=>fnd_log.level_procedure);

1555: END IF;
1556: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1557: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1558: p_prefix=>l_debug_prefix,
1559: p_msg_level=>fnd_log.level_procedure);
1560: END IF;
1561: WHEN fnd_api.g_exc_unexpected_error THEN
1562: x_return_status := fnd_api.g_ret_sts_unexp_error;
1563:

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

1565: p_count => x_msg_count,
1566: p_data => x_msg_data);
1567:
1568: -- Debug info.
1569: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1570: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1571: p_msg_data=>x_msg_data,
1572: p_msg_type=>'UNEXPECTED ERROR',
1573: p_msg_level=>fnd_log.level_error);

Line 1573: p_msg_level=>fnd_log.level_error);

1569: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1570: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1571: p_msg_data=>x_msg_data,
1572: p_msg_type=>'UNEXPECTED ERROR',
1573: p_msg_level=>fnd_log.level_error);
1574: END IF;
1575: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1576: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1577: p_prefix=>l_debug_prefix,

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

1571: p_msg_data=>x_msg_data,
1572: p_msg_type=>'UNEXPECTED ERROR',
1573: p_msg_level=>fnd_log.level_error);
1574: END IF;
1575: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1576: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1577: p_prefix=>l_debug_prefix,
1578: p_msg_level=>fnd_log.level_procedure);
1579: END IF;

Line 1578: p_msg_level=>fnd_log.level_procedure);

1574: END IF;
1575: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1576: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1577: p_prefix=>l_debug_prefix,
1578: p_msg_level=>fnd_log.level_procedure);
1579: END IF;
1580: WHEN OTHERS THEN
1581: x_return_status := fnd_api.g_ret_sts_unexp_error;
1582:

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

1588: p_count => x_msg_count,
1589: p_data => x_msg_data);
1590:
1591: -- Debug info.
1592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1594: p_msg_data=>x_msg_data,
1595: p_msg_type=>'SQL ERROR',
1596: p_msg_level=>fnd_log.level_error);

Line 1596: p_msg_level=>fnd_log.level_error);

1592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1594: p_msg_data=>x_msg_data,
1595: p_msg_type=>'SQL ERROR',
1596: p_msg_level=>fnd_log.level_error);
1597: END IF;
1598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1599: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1600: p_prefix=>l_debug_prefix,

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

1594: p_msg_data=>x_msg_data,
1595: p_msg_type=>'SQL ERROR',
1596: p_msg_level=>fnd_log.level_error);
1597: END IF;
1598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1599: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1600: p_prefix=>l_debug_prefix,
1601: p_msg_level=>fnd_log.level_procedure);
1602: END IF;

Line 1601: p_msg_level=>fnd_log.level_procedure);

1597: END IF;
1598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1599: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1600: p_prefix=>l_debug_prefix,
1601: p_msg_level=>fnd_log.level_procedure);
1602: END IF;
1603:
1604: end;
1605:

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

1673: END IF;
1674:
1675:
1676: -- Debug info.
1677: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1678: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(+)',
1679: p_prefix=>l_debug_prefix,
1680: p_msg_level=>fnd_log.level_procedure);
1681: END IF;

Line 1680: p_msg_level=>fnd_log.level_procedure);

1676: -- Debug info.
1677: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1678: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(+)',
1679: p_prefix=>l_debug_prefix,
1680: p_msg_level=>fnd_log.level_procedure);
1681: END IF;
1682:
1683:
1684: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

1717: end loop;
1718:
1719:
1720: -- Debug info.
1721: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1722: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1723: p_msg_data=>x_msg_data,
1724: p_msg_type=>'WARNING',
1725: p_msg_level=>fnd_log.level_exception);

Line 1725: p_msg_level=>fnd_log.level_exception);

1721: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1722: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1723: p_msg_data=>x_msg_data,
1724: p_msg_type=>'WARNING',
1725: p_msg_level=>fnd_log.level_exception);
1726: END IF;
1727:
1728: -- Debug info.
1729: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1725: p_msg_level=>fnd_log.level_exception);
1726: END IF;
1727:
1728: -- Debug info.
1729: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1730: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated (-)',
1731: p_prefix=>l_debug_prefix,
1732: p_msg_level=>fnd_log.level_procedure);
1733: END IF;

Line 1732: p_msg_level=>fnd_log.level_procedure);

1728: -- Debug info.
1729: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1730: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated (-)',
1731: p_prefix=>l_debug_prefix,
1732: p_msg_level=>fnd_log.level_procedure);
1733: END IF;
1734:
1735:
1736: EXCEPTION

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

1742: p_count => x_msg_count,
1743: p_data => x_msg_data);
1744:
1745: -- Debug info.
1746: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1747: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1748: p_msg_data=>x_msg_data,
1749: p_msg_type=>'ERROR',
1750: p_msg_level=>fnd_log.level_error);

Line 1750: p_msg_level=>fnd_log.level_error);

1746: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1747: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1748: p_msg_data=>x_msg_data,
1749: p_msg_type=>'ERROR',
1750: p_msg_level=>fnd_log.level_error);
1751: END IF;
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1754: p_prefix=>l_debug_prefix,

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

1748: p_msg_data=>x_msg_data,
1749: p_msg_type=>'ERROR',
1750: p_msg_level=>fnd_log.level_error);
1751: END IF;
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;

Line 1755: p_msg_level=>fnd_log.level_procedure);

1751: END IF;
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;
1757: WHEN fnd_api.g_exc_unexpected_error THEN
1758: x_return_status := fnd_api.g_ret_sts_unexp_error;
1759:

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

1761: p_count => x_msg_count,
1762: p_data => x_msg_data);
1763:
1764: -- Debug info.
1765: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1766: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1767: p_msg_data=>x_msg_data,
1768: p_msg_type=>'UNEXPECTED ERROR',
1769: p_msg_level=>fnd_log.level_error);

Line 1769: p_msg_level=>fnd_log.level_error);

1765: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1766: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1767: p_msg_data=>x_msg_data,
1768: p_msg_type=>'UNEXPECTED ERROR',
1769: p_msg_level=>fnd_log.level_error);
1770: END IF;
1771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1772: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1773: p_prefix=>l_debug_prefix,

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

1767: p_msg_data=>x_msg_data,
1768: p_msg_type=>'UNEXPECTED ERROR',
1769: p_msg_level=>fnd_log.level_error);
1770: END IF;
1771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1772: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1773: p_prefix=>l_debug_prefix,
1774: p_msg_level=>fnd_log.level_procedure);
1775: END IF;

Line 1774: p_msg_level=>fnd_log.level_procedure);

1770: END IF;
1771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1772: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1773: p_prefix=>l_debug_prefix,
1774: p_msg_level=>fnd_log.level_procedure);
1775: END IF;
1776: WHEN OTHERS THEN
1777: x_return_status := fnd_api.g_ret_sts_unexp_error;
1778:

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

1784: p_count => x_msg_count,
1785: p_data => x_msg_data);
1786:
1787: -- Debug info.
1788: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1789: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1790: p_msg_data=>x_msg_data,
1791: p_msg_type=>'SQL ERROR',
1792: p_msg_level=>fnd_log.level_error);

Line 1792: p_msg_level=>fnd_log.level_error);

1788: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1789: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1790: p_msg_data=>x_msg_data,
1791: p_msg_type=>'SQL ERROR',
1792: p_msg_level=>fnd_log.level_error);
1793: END IF;
1794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1795: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1796: p_prefix=>l_debug_prefix,

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

1790: p_msg_data=>x_msg_data,
1791: p_msg_type=>'SQL ERROR',
1792: p_msg_level=>fnd_log.level_error);
1793: END IF;
1794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1795: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1796: p_prefix=>l_debug_prefix,
1797: p_msg_level=>fnd_log.level_procedure);
1798: END IF;

Line 1797: p_msg_level=>fnd_log.level_procedure);

1793: END IF;
1794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1795: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1796: p_prefix=>l_debug_prefix,
1797: p_msg_level=>fnd_log.level_procedure);
1798: END IF;
1799:
1800: end;
1801:

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

2198: END IF;
2199:
2200:
2201: -- Debug info.
2202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2203: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(+)',
2204: p_prefix=>l_debug_prefix,
2205: p_msg_level=>fnd_log.level_procedure);
2206: END IF;

Line 2205: p_msg_level=>fnd_log.level_procedure);

2201: -- Debug info.
2202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2203: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(+)',
2204: p_prefix=>l_debug_prefix,
2205: p_msg_level=>fnd_log.level_procedure);
2206: END IF;
2207: /* moved to public api
2208: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
2209: p_party_id => p_person_cust_id,

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

2245:
2246:
2247:
2248: -- Debug info.
2249: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2250: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2251: p_msg_data=>x_msg_data,
2252: p_msg_type=>'WARNING',
2253: p_msg_level=>fnd_log.level_exception);

Line 2253: p_msg_level=>fnd_log.level_exception);

2249: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2250: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2251: p_msg_data=>x_msg_data,
2252: p_msg_type=>'WARNING',
2253: p_msg_level=>fnd_log.level_exception);
2254: END IF;
2255:
2256: -- Debug info.
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2253: p_msg_level=>fnd_log.level_exception);
2254: END IF;
2255:
2256: -- Debug info.
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated (-)',
2259: p_prefix=>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_procedure);
2261: END IF;

Line 2260: p_msg_level=>fnd_log.level_procedure);

2256: -- Debug info.
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated (-)',
2259: p_prefix=>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_procedure);
2261: END IF;
2262:
2263:
2264: EXCEPTION

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

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

Line 2278: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2283: p_msg_level=>fnd_log.level_procedure);

2279: END IF;
2280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2281: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
2282: p_prefix=>l_debug_prefix,
2283: p_msg_level=>fnd_log.level_procedure);
2284: END IF;
2285: WHEN fnd_api.g_exc_unexpected_error THEN
2286: x_return_status := fnd_api.g_ret_sts_unexp_error;
2287:

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

2289: p_count => x_msg_count,
2290: p_data => x_msg_data);
2291:
2292: -- Debug info.
2293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2295: p_msg_data=>x_msg_data,
2296: p_msg_type=>'UNEXPECTED ERROR',
2297: p_msg_level=>fnd_log.level_error);

Line 2297: p_msg_level=>fnd_log.level_error);

2293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2295: p_msg_data=>x_msg_data,
2296: p_msg_type=>'UNEXPECTED ERROR',
2297: p_msg_level=>fnd_log.level_error);
2298: END IF;
2299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2300: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
2301: p_prefix=>l_debug_prefix,

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

2295: p_msg_data=>x_msg_data,
2296: p_msg_type=>'UNEXPECTED ERROR',
2297: p_msg_level=>fnd_log.level_error);
2298: END IF;
2299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2300: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
2301: p_prefix=>l_debug_prefix,
2302: p_msg_level=>fnd_log.level_procedure);
2303: END IF;

Line 2302: p_msg_level=>fnd_log.level_procedure);

2298: END IF;
2299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2300: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
2301: p_prefix=>l_debug_prefix,
2302: p_msg_level=>fnd_log.level_procedure);
2303: END IF;
2304: WHEN OTHERS THEN
2305: x_return_status := fnd_api.g_ret_sts_unexp_error;
2306:

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

2312: p_count => x_msg_count,
2313: p_data => x_msg_data);
2314:
2315: -- Debug info.
2316: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2317: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2318: p_msg_data=>x_msg_data,
2319: p_msg_type=>'SQL ERROR',
2320: p_msg_level=>fnd_log.level_error);

Line 2320: p_msg_level=>fnd_log.level_error);

2316: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2317: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2318: p_msg_data=>x_msg_data,
2319: p_msg_type=>'SQL ERROR',
2320: p_msg_level=>fnd_log.level_error);
2321: END IF;
2322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2323: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
2324: p_prefix=>l_debug_prefix,

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

2318: p_msg_data=>x_msg_data,
2319: p_msg_type=>'SQL ERROR',
2320: p_msg_level=>fnd_log.level_error);
2321: END IF;
2322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2323: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
2324: p_prefix=>l_debug_prefix,
2325: p_msg_level=>fnd_log.level_procedure);
2326: END IF;

Line 2325: p_msg_level=>fnd_log.level_procedure);

2321: END IF;
2322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2323: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
2324: p_prefix=>l_debug_prefix,
2325: p_msg_level=>fnd_log.level_procedure);
2326: END IF;
2327:
2328: end;
2329: