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

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

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

Line 89: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 128: p_msg_level=>fnd_log.level_exception);

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

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

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

Line 135: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 153: p_msg_level=>fnd_log.level_error);

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

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

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

Line 158: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 172: p_msg_level=>fnd_log.level_error);

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

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

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

Line 177: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 195: p_msg_level=>fnd_log.level_error);

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

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

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

Line 200: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 303: p_msg_level=>fnd_log.level_procedure);

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

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

394:
395: end loop;
396:
397: -- Debug info.
398: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
400: p_msg_data=>x_msg_data,
401: p_msg_type=>'WARNING',
402: p_msg_level=>fnd_log.level_exception);

Line 402: p_msg_level=>fnd_log.level_exception);

398: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
400: p_msg_data=>x_msg_data,
401: p_msg_type=>'WARNING',
402: p_msg_level=>fnd_log.level_exception);
403: END IF;
404:
405: -- Debug info.
406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

402: p_msg_level=>fnd_log.level_exception);
403: END IF;
404:
405: -- Debug info.
406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
407: hz_utility_v2pub.debug(p_message=>'get_org_cust_created (-)',
408: p_prefix=>l_debug_prefix,
409: p_msg_level=>fnd_log.level_procedure);
410: END IF;

Line 409: p_msg_level=>fnd_log.level_procedure);

405: -- Debug info.
406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
407: hz_utility_v2pub.debug(p_message=>'get_org_cust_created (-)',
408: p_prefix=>l_debug_prefix,
409: p_msg_level=>fnd_log.level_procedure);
410: END IF;
411:
412:
413: EXCEPTION

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=>'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=>'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_org_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=>'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_org_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_org_cust_created(-)',
431: p_prefix=>l_debug_prefix,
432: p_msg_level=>fnd_log.level_procedure);
433: END IF;
434: WHEN fnd_api.g_exc_unexpected_error THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436:

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

438: p_count => x_msg_count,
439: p_data => x_msg_data);
440:
441: -- Debug info.
442: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
444: p_msg_data=>x_msg_data,
445: p_msg_type=>'UNEXPECTED ERROR',
446: p_msg_level=>fnd_log.level_error);

Line 446: p_msg_level=>fnd_log.level_error);

442: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
444: p_msg_data=>x_msg_data,
445: p_msg_type=>'UNEXPECTED ERROR',
446: p_msg_level=>fnd_log.level_error);
447: END IF;
448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
449: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
450: p_prefix=>l_debug_prefix,

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

444: p_msg_data=>x_msg_data,
445: p_msg_type=>'UNEXPECTED ERROR',
446: p_msg_level=>fnd_log.level_error);
447: END IF;
448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
449: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
450: p_prefix=>l_debug_prefix,
451: p_msg_level=>fnd_log.level_procedure);
452: END IF;

Line 451: p_msg_level=>fnd_log.level_procedure);

447: END IF;
448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
449: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
450: p_prefix=>l_debug_prefix,
451: p_msg_level=>fnd_log.level_procedure);
452: END IF;
453: WHEN OTHERS THEN
454: x_return_status := fnd_api.g_ret_sts_unexp_error;
455:

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

461: p_count => x_msg_count,
462: p_data => x_msg_data);
463:
464: -- Debug info.
465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
467: p_msg_data=>x_msg_data,
468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);

Line 469: p_msg_level=>fnd_log.level_error);

465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
467: p_msg_data=>x_msg_data,
468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
473: p_prefix=>l_debug_prefix,

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

467: p_msg_data=>x_msg_data,
468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;

Line 474: p_msg_level=>fnd_log.level_procedure);

470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;
476:
477: end;
478:

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

546: END IF;
547:
548:
549: -- Debug info.
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(+)',
552: p_prefix=>l_debug_prefix,
553: p_msg_level=>fnd_log.level_procedure);
554: END IF;

Line 553: p_msg_level=>fnd_log.level_procedure);

549: -- Debug info.
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(+)',
552: p_prefix=>l_debug_prefix,
553: p_msg_level=>fnd_log.level_procedure);
554: END IF;
555:
556:
557: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

584: end loop;
585:
586:
587: -- Debug info.
588: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
590: p_msg_data=>x_msg_data,
591: p_msg_type=>'WARNING',
592: p_msg_level=>fnd_log.level_exception);

Line 592: p_msg_level=>fnd_log.level_exception);

588: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
590: p_msg_data=>x_msg_data,
591: p_msg_type=>'WARNING',
592: p_msg_level=>fnd_log.level_exception);
593: END IF;
594:
595: -- Debug info.
596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

592: p_msg_level=>fnd_log.level_exception);
593: END IF;
594:
595: -- Debug info.
596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
597: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated (-)',
598: p_prefix=>l_debug_prefix,
599: p_msg_level=>fnd_log.level_procedure);
600: END IF;

Line 599: p_msg_level=>fnd_log.level_procedure);

595: -- Debug info.
596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
597: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated (-)',
598: p_prefix=>l_debug_prefix,
599: p_msg_level=>fnd_log.level_procedure);
600: END IF;
601:
602:
603: EXCEPTION

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

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

Line 617: p_msg_level=>fnd_log.level_error);

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

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

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

Line 622: p_msg_level=>fnd_log.level_procedure);

618: END IF;
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
621: p_prefix=>l_debug_prefix,
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;
624: WHEN fnd_api.g_exc_unexpected_error THEN
625: x_return_status := fnd_api.g_ret_sts_unexp_error;
626:

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

628: p_count => x_msg_count,
629: p_data => x_msg_data);
630:
631: -- Debug info.
632: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
634: p_msg_data=>x_msg_data,
635: p_msg_type=>'UNEXPECTED ERROR',
636: p_msg_level=>fnd_log.level_error);

Line 636: p_msg_level=>fnd_log.level_error);

632: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
634: p_msg_data=>x_msg_data,
635: p_msg_type=>'UNEXPECTED ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;
638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
640: p_prefix=>l_debug_prefix,

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

634: p_msg_data=>x_msg_data,
635: p_msg_type=>'UNEXPECTED ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;
638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
640: p_prefix=>l_debug_prefix,
641: p_msg_level=>fnd_log.level_procedure);
642: END IF;

Line 641: p_msg_level=>fnd_log.level_procedure);

637: END IF;
638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
640: p_prefix=>l_debug_prefix,
641: p_msg_level=>fnd_log.level_procedure);
642: END IF;
643: WHEN OTHERS THEN
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645:

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

651: p_count => x_msg_count,
652: p_data => x_msg_data);
653:
654: -- Debug info.
655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
657: p_msg_data=>x_msg_data,
658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);

Line 659: p_msg_level=>fnd_log.level_error);

655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
657: p_msg_data=>x_msg_data,
658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
663: p_prefix=>l_debug_prefix,

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

657: p_msg_data=>x_msg_data,
658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;

Line 664: p_msg_level=>fnd_log.level_procedure);

660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;
666:
667: end;
668:

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

1063: END IF;
1064:
1065:
1066: -- Debug info.
1067: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1068: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(+)',
1069: p_prefix=>l_debug_prefix,
1070: p_msg_level=>fnd_log.level_procedure);
1071: END IF;

Line 1070: p_msg_level=>fnd_log.level_procedure);

1066: -- Debug info.
1067: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1068: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(+)',
1069: p_prefix=>l_debug_prefix,
1070: p_msg_level=>fnd_log.level_procedure);
1071: END IF;
1072:
1073: /* moved to public api
1074: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,

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

1103: x_org_cust_obj := l_org_cust_obj;
1104:
1105:
1106: -- Debug info.
1107: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1108: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1109: p_msg_data=>x_msg_data,
1110: p_msg_type=>'WARNING',
1111: p_msg_level=>fnd_log.level_exception);

Line 1111: p_msg_level=>fnd_log.level_exception);

1107: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1108: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1109: p_msg_data=>x_msg_data,
1110: p_msg_type=>'WARNING',
1111: p_msg_level=>fnd_log.level_exception);
1112: END IF;
1113:
1114: -- Debug info.
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1111: p_msg_level=>fnd_log.level_exception);
1112: END IF;
1113:
1114: -- Debug info.
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated (-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;

Line 1118: p_msg_level=>fnd_log.level_procedure);

1114: -- Debug info.
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated (-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120:
1121:
1122: EXCEPTION

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

1128: p_count => x_msg_count,
1129: p_data => x_msg_data);
1130:
1131: -- Debug info.
1132: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1134: p_msg_data=>x_msg_data,
1135: p_msg_type=>'ERROR',
1136: p_msg_level=>fnd_log.level_error);

Line 1136: p_msg_level=>fnd_log.level_error);

1132: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1134: p_msg_data=>x_msg_data,
1135: p_msg_type=>'ERROR',
1136: p_msg_level=>fnd_log.level_error);
1137: END IF;
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1140: p_prefix=>l_debug_prefix,

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

1134: p_msg_data=>x_msg_data,
1135: p_msg_type=>'ERROR',
1136: p_msg_level=>fnd_log.level_error);
1137: END IF;
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;

Line 1141: p_msg_level=>fnd_log.level_procedure);

1137: END IF;
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;
1143: WHEN fnd_api.g_exc_unexpected_error THEN
1144: x_return_status := fnd_api.g_ret_sts_unexp_error;
1145:

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

1147: p_count => x_msg_count,
1148: p_data => x_msg_data);
1149:
1150: -- Debug info.
1151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'UNEXPECTED ERROR',
1155: p_msg_level=>fnd_log.level_error);

Line 1155: p_msg_level=>fnd_log.level_error);

1151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'UNEXPECTED ERROR',
1155: p_msg_level=>fnd_log.level_error);
1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1159: p_prefix=>l_debug_prefix,

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

1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'UNEXPECTED ERROR',
1155: p_msg_level=>fnd_log.level_error);
1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1159: p_prefix=>l_debug_prefix,
1160: p_msg_level=>fnd_log.level_procedure);
1161: END IF;

Line 1160: p_msg_level=>fnd_log.level_procedure);

1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1159: p_prefix=>l_debug_prefix,
1160: p_msg_level=>fnd_log.level_procedure);
1161: END IF;
1162: WHEN OTHERS THEN
1163: x_return_status := fnd_api.g_ret_sts_unexp_error;
1164:

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

1170: p_count => x_msg_count,
1171: p_data => x_msg_data);
1172:
1173: -- Debug info.
1174: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1176: p_msg_data=>x_msg_data,
1177: p_msg_type=>'SQL ERROR',
1178: p_msg_level=>fnd_log.level_error);

Line 1178: p_msg_level=>fnd_log.level_error);

1174: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1176: p_msg_data=>x_msg_data,
1177: p_msg_type=>'SQL ERROR',
1178: p_msg_level=>fnd_log.level_error);
1179: END IF;
1180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1181: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1182: p_prefix=>l_debug_prefix,

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

1176: p_msg_data=>x_msg_data,
1177: p_msg_type=>'SQL ERROR',
1178: p_msg_level=>fnd_log.level_error);
1179: END IF;
1180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1181: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1182: p_prefix=>l_debug_prefix,
1183: p_msg_level=>fnd_log.level_procedure);
1184: END IF;

Line 1183: p_msg_level=>fnd_log.level_procedure);

1179: END IF;
1180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1181: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1182: p_prefix=>l_debug_prefix,
1183: p_msg_level=>fnd_log.level_procedure);
1184: END IF;
1185:
1186: end;
1187:

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

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

Line 1264: p_msg_level=>fnd_log.level_procedure);

1260: -- Debug info.
1261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo(+)',
1263: p_prefix=>l_debug_prefix,
1264: p_msg_level=>fnd_log.level_procedure);
1265: END IF;
1266:
1267: x_org_cust_v2_obj := HZ_ORG_CUST_V2_BO(p_action_type, NULL, NULL);
1268:

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

1295: END IF;
1296:
1297:
1298: -- Debug info.
1299: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1301: p_msg_data=>x_msg_data,
1302: p_msg_type=>'WARNING',
1303: p_msg_level=>fnd_log.level_exception);

Line 1303: p_msg_level=>fnd_log.level_exception);

1299: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1301: p_msg_data=>x_msg_data,
1302: p_msg_type=>'WARNING',
1303: p_msg_level=>fnd_log.level_exception);
1304: END IF;
1305:
1306: -- Debug info.
1307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1303: p_msg_level=>fnd_log.level_exception);
1304: END IF;
1305:
1306: -- Debug info.
1307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1308: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1309: p_prefix=>l_debug_prefix,
1310: p_msg_level=>fnd_log.level_procedure);
1311: END IF;

Line 1310: p_msg_level=>fnd_log.level_procedure);

1306: -- Debug info.
1307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1308: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1309: p_prefix=>l_debug_prefix,
1310: p_msg_level=>fnd_log.level_procedure);
1311: END IF;
1312:
1313:
1314: EXCEPTION

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

1320: p_count => x_msg_count,
1321: p_data => x_msg_data);
1322:
1323: -- Debug info.
1324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'ERROR',
1328: p_msg_level=>fnd_log.level_error);

Line 1328: p_msg_level=>fnd_log.level_error);

1324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'ERROR',
1328: p_msg_level=>fnd_log.level_error);
1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1332: p_prefix=>l_debug_prefix,

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

1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'ERROR',
1328: p_msg_level=>fnd_log.level_error);
1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;

Line 1333: p_msg_level=>fnd_log.level_procedure);

1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;
1335: WHEN fnd_api.g_exc_unexpected_error THEN
1336: x_return_status := fnd_api.g_ret_sts_unexp_error;
1337:

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

1339: p_count => x_msg_count,
1340: p_data => x_msg_data);
1341:
1342: -- Debug info.
1343: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1344: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1345: p_msg_data=>x_msg_data,
1346: p_msg_type=>'UNEXPECTED ERROR',
1347: p_msg_level=>fnd_log.level_error);

Line 1347: p_msg_level=>fnd_log.level_error);

1343: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1344: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1345: p_msg_data=>x_msg_data,
1346: p_msg_type=>'UNEXPECTED ERROR',
1347: p_msg_level=>fnd_log.level_error);
1348: END IF;
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1351: p_prefix=>l_debug_prefix,

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

1345: p_msg_data=>x_msg_data,
1346: p_msg_type=>'UNEXPECTED ERROR',
1347: p_msg_level=>fnd_log.level_error);
1348: END IF;
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);
1353: END IF;

Line 1352: p_msg_level=>fnd_log.level_procedure);

1348: END IF;
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);
1353: END IF;
1354: WHEN OTHERS THEN
1355: x_return_status := fnd_api.g_ret_sts_unexp_error;
1356:

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

1362: p_count => x_msg_count,
1363: p_data => x_msg_data);
1364:
1365: -- Debug info.
1366: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1367: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1368: p_msg_data=>x_msg_data,
1369: p_msg_type=>'SQL ERROR',
1370: p_msg_level=>fnd_log.level_error);

Line 1370: p_msg_level=>fnd_log.level_error);

1366: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1367: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1368: p_msg_data=>x_msg_data,
1369: p_msg_type=>'SQL ERROR',
1370: p_msg_level=>fnd_log.level_error);
1371: END IF;
1372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1373: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1374: p_prefix=>l_debug_prefix,

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

1368: p_msg_data=>x_msg_data,
1369: p_msg_type=>'SQL ERROR',
1370: p_msg_level=>fnd_log.level_error);
1371: END IF;
1372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1373: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1374: p_prefix=>l_debug_prefix,
1375: p_msg_level=>fnd_log.level_procedure);
1376: END IF;

Line 1375: p_msg_level=>fnd_log.level_procedure);

1371: END IF;
1372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1373: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1374: p_prefix=>l_debug_prefix,
1375: p_msg_level=>fnd_log.level_procedure);
1376: END IF;
1377:
1378: end;
1379:

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

1451: END IF;
1452:
1453:
1454: -- Debug info.
1455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1456: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(+)',
1457: p_prefix=>l_debug_prefix,
1458: p_msg_level=>fnd_log.level_procedure);
1459: END IF;

Line 1458: p_msg_level=>fnd_log.level_procedure);

1454: -- Debug info.
1455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1456: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(+)',
1457: p_prefix=>l_debug_prefix,
1458: p_msg_level=>fnd_log.level_procedure);
1459: END IF;
1460:
1461:
1462: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

1536:
1537: end loop;
1538:
1539: -- Debug info.
1540: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1541: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1542: p_msg_data=>x_msg_data,
1543: p_msg_type=>'WARNING',
1544: p_msg_level=>fnd_log.level_exception);

Line 1544: p_msg_level=>fnd_log.level_exception);

1540: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1541: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1542: p_msg_data=>x_msg_data,
1543: p_msg_type=>'WARNING',
1544: p_msg_level=>fnd_log.level_exception);
1545: END IF;
1546:
1547: -- Debug info.
1548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1544: p_msg_level=>fnd_log.level_exception);
1545: END IF;
1546:
1547: -- Debug info.
1548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1549: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created (-)',
1550: p_prefix=>l_debug_prefix,
1551: p_msg_level=>fnd_log.level_procedure);
1552: END IF;

Line 1551: p_msg_level=>fnd_log.level_procedure);

1547: -- Debug info.
1548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1549: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created (-)',
1550: p_prefix=>l_debug_prefix,
1551: p_msg_level=>fnd_log.level_procedure);
1552: END IF;
1553:
1554:
1555: EXCEPTION

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

1561: p_count => x_msg_count,
1562: p_data => x_msg_data);
1563:
1564: -- Debug info.
1565: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1566: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1567: p_msg_data=>x_msg_data,
1568: p_msg_type=>'ERROR',
1569: p_msg_level=>fnd_log.level_error);

Line 1569: p_msg_level=>fnd_log.level_error);

1565: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1566: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1567: p_msg_data=>x_msg_data,
1568: p_msg_type=>'ERROR',
1569: p_msg_level=>fnd_log.level_error);
1570: END IF;
1571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1572: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1573: p_prefix=>l_debug_prefix,

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

1567: p_msg_data=>x_msg_data,
1568: p_msg_type=>'ERROR',
1569: p_msg_level=>fnd_log.level_error);
1570: END IF;
1571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1572: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1573: p_prefix=>l_debug_prefix,
1574: p_msg_level=>fnd_log.level_procedure);
1575: END IF;

Line 1574: p_msg_level=>fnd_log.level_procedure);

1570: END IF;
1571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1572: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1573: p_prefix=>l_debug_prefix,
1574: p_msg_level=>fnd_log.level_procedure);
1575: END IF;
1576: WHEN fnd_api.g_exc_unexpected_error THEN
1577: x_return_status := fnd_api.g_ret_sts_unexp_error;
1578:

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

1580: p_count => x_msg_count,
1581: p_data => x_msg_data);
1582:
1583: -- Debug info.
1584: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1585: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1586: p_msg_data=>x_msg_data,
1587: p_msg_type=>'UNEXPECTED ERROR',
1588: p_msg_level=>fnd_log.level_error);

Line 1588: p_msg_level=>fnd_log.level_error);

1584: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1585: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1586: p_msg_data=>x_msg_data,
1587: p_msg_type=>'UNEXPECTED ERROR',
1588: p_msg_level=>fnd_log.level_error);
1589: END IF;
1590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1591: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1592: p_prefix=>l_debug_prefix,

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

1586: p_msg_data=>x_msg_data,
1587: p_msg_type=>'UNEXPECTED ERROR',
1588: p_msg_level=>fnd_log.level_error);
1589: END IF;
1590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1591: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1592: p_prefix=>l_debug_prefix,
1593: p_msg_level=>fnd_log.level_procedure);
1594: END IF;

Line 1593: p_msg_level=>fnd_log.level_procedure);

1589: END IF;
1590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1591: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1592: p_prefix=>l_debug_prefix,
1593: p_msg_level=>fnd_log.level_procedure);
1594: END IF;
1595: WHEN OTHERS THEN
1596: x_return_status := fnd_api.g_ret_sts_unexp_error;
1597:

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

1603: p_count => x_msg_count,
1604: p_data => x_msg_data);
1605:
1606: -- Debug info.
1607: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1608: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1609: p_msg_data=>x_msg_data,
1610: p_msg_type=>'SQL ERROR',
1611: p_msg_level=>fnd_log.level_error);

Line 1611: p_msg_level=>fnd_log.level_error);

1607: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1608: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1609: p_msg_data=>x_msg_data,
1610: p_msg_type=>'SQL ERROR',
1611: p_msg_level=>fnd_log.level_error);
1612: END IF;
1613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1614: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1615: p_prefix=>l_debug_prefix,

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

1609: p_msg_data=>x_msg_data,
1610: p_msg_type=>'SQL ERROR',
1611: p_msg_level=>fnd_log.level_error);
1612: END IF;
1613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1614: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1615: p_prefix=>l_debug_prefix,
1616: p_msg_level=>fnd_log.level_procedure);
1617: END IF;

Line 1616: p_msg_level=>fnd_log.level_procedure);

1612: END IF;
1613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1614: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1615: p_prefix=>l_debug_prefix,
1616: p_msg_level=>fnd_log.level_procedure);
1617: END IF;
1618:
1619: end;
1620:

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

1688: END IF;
1689:
1690:
1691: -- Debug info.
1692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1693: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(+)',
1694: p_prefix=>l_debug_prefix,
1695: p_msg_level=>fnd_log.level_procedure);
1696: END IF;

Line 1695: p_msg_level=>fnd_log.level_procedure);

1691: -- Debug info.
1692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1693: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(+)',
1694: p_prefix=>l_debug_prefix,
1695: p_msg_level=>fnd_log.level_procedure);
1696: END IF;
1697:
1698:
1699: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

1726: end loop;
1727:
1728:
1729: -- Debug info.
1730: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1731: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1732: p_msg_data=>x_msg_data,
1733: p_msg_type=>'WARNING',
1734: p_msg_level=>fnd_log.level_exception);

Line 1734: p_msg_level=>fnd_log.level_exception);

1730: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1731: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1732: p_msg_data=>x_msg_data,
1733: p_msg_type=>'WARNING',
1734: p_msg_level=>fnd_log.level_exception);
1735: END IF;
1736:
1737: -- Debug info.
1738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1734: p_msg_level=>fnd_log.level_exception);
1735: END IF;
1736:
1737: -- Debug info.
1738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1739: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated (-)',
1740: p_prefix=>l_debug_prefix,
1741: p_msg_level=>fnd_log.level_procedure);
1742: END IF;

Line 1741: p_msg_level=>fnd_log.level_procedure);

1737: -- Debug info.
1738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1739: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated (-)',
1740: p_prefix=>l_debug_prefix,
1741: p_msg_level=>fnd_log.level_procedure);
1742: END IF;
1743:
1744:
1745: EXCEPTION

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

1751: p_count => x_msg_count,
1752: p_data => x_msg_data);
1753:
1754: -- Debug info.
1755: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1756: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1757: p_msg_data=>x_msg_data,
1758: p_msg_type=>'ERROR',
1759: p_msg_level=>fnd_log.level_error);

Line 1759: p_msg_level=>fnd_log.level_error);

1755: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1756: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1757: p_msg_data=>x_msg_data,
1758: p_msg_type=>'ERROR',
1759: p_msg_level=>fnd_log.level_error);
1760: END IF;
1761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1762: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1763: p_prefix=>l_debug_prefix,

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

1757: p_msg_data=>x_msg_data,
1758: p_msg_type=>'ERROR',
1759: p_msg_level=>fnd_log.level_error);
1760: END IF;
1761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1762: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1763: p_prefix=>l_debug_prefix,
1764: p_msg_level=>fnd_log.level_procedure);
1765: END IF;

Line 1764: p_msg_level=>fnd_log.level_procedure);

1760: END IF;
1761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1762: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1763: p_prefix=>l_debug_prefix,
1764: p_msg_level=>fnd_log.level_procedure);
1765: END IF;
1766: WHEN fnd_api.g_exc_unexpected_error THEN
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768:

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

1770: p_count => x_msg_count,
1771: p_data => x_msg_data);
1772:
1773: -- Debug info.
1774: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1776: p_msg_data=>x_msg_data,
1777: p_msg_type=>'UNEXPECTED ERROR',
1778: p_msg_level=>fnd_log.level_error);

Line 1778: p_msg_level=>fnd_log.level_error);

1774: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1776: p_msg_data=>x_msg_data,
1777: p_msg_type=>'UNEXPECTED ERROR',
1778: p_msg_level=>fnd_log.level_error);
1779: END IF;
1780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1781: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1782: p_prefix=>l_debug_prefix,

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

1776: p_msg_data=>x_msg_data,
1777: p_msg_type=>'UNEXPECTED ERROR',
1778: p_msg_level=>fnd_log.level_error);
1779: END IF;
1780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1781: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1782: p_prefix=>l_debug_prefix,
1783: p_msg_level=>fnd_log.level_procedure);
1784: END IF;

Line 1783: p_msg_level=>fnd_log.level_procedure);

1779: END IF;
1780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1781: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1782: p_prefix=>l_debug_prefix,
1783: p_msg_level=>fnd_log.level_procedure);
1784: END IF;
1785: WHEN OTHERS THEN
1786: x_return_status := fnd_api.g_ret_sts_unexp_error;
1787:

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

1793: p_count => x_msg_count,
1794: p_data => x_msg_data);
1795:
1796: -- Debug info.
1797: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1798: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1799: p_msg_data=>x_msg_data,
1800: p_msg_type=>'SQL ERROR',
1801: p_msg_level=>fnd_log.level_error);

Line 1801: p_msg_level=>fnd_log.level_error);

1797: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1798: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1799: p_msg_data=>x_msg_data,
1800: p_msg_type=>'SQL ERROR',
1801: p_msg_level=>fnd_log.level_error);
1802: END IF;
1803: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1804: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1805: p_prefix=>l_debug_prefix,

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

1799: p_msg_data=>x_msg_data,
1800: p_msg_type=>'SQL ERROR',
1801: p_msg_level=>fnd_log.level_error);
1802: END IF;
1803: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1804: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1805: p_prefix=>l_debug_prefix,
1806: p_msg_level=>fnd_log.level_procedure);
1807: END IF;

Line 1806: p_msg_level=>fnd_log.level_procedure);

1802: END IF;
1803: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1804: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1805: p_prefix=>l_debug_prefix,
1806: p_msg_level=>fnd_log.level_procedure);
1807: END IF;
1808:
1809: end;
1810:

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

2209: END IF;
2210:
2211:
2212: -- Debug info.
2213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(+)',
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: -- Debug info.
2213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(+)',
2215: p_prefix=>l_debug_prefix,
2216: p_msg_level=>fnd_log.level_procedure);
2217: END IF;
2218:
2219: -- Set action type to 'UNCHANGED' by default
2220:

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

2240: x_org_cust_v2_obj := l_org_cust_obj;
2241:
2242:
2243: -- Debug info.
2244: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2246: p_msg_data=>x_msg_data,
2247: p_msg_type=>'WARNING',
2248: p_msg_level=>fnd_log.level_exception);

Line 2248: p_msg_level=>fnd_log.level_exception);

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

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

2248: p_msg_level=>fnd_log.level_exception);
2249: END IF;
2250:
2251: -- Debug info.
2252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2253: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated (-)',
2254: p_prefix=>l_debug_prefix,
2255: p_msg_level=>fnd_log.level_procedure);
2256: END IF;

Line 2255: p_msg_level=>fnd_log.level_procedure);

2251: -- Debug info.
2252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2253: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated (-)',
2254: p_prefix=>l_debug_prefix,
2255: p_msg_level=>fnd_log.level_procedure);
2256: END IF;
2257:
2258:
2259: EXCEPTION

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

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

Line 2273: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2278: p_msg_level=>fnd_log.level_procedure);

2274: END IF;
2275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2276: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2277: p_prefix=>l_debug_prefix,
2278: p_msg_level=>fnd_log.level_procedure);
2279: END IF;
2280: WHEN fnd_api.g_exc_unexpected_error THEN
2281: x_return_status := fnd_api.g_ret_sts_unexp_error;
2282:

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

2284: p_count => x_msg_count,
2285: p_data => x_msg_data);
2286:
2287: -- Debug info.
2288: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2289: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2290: p_msg_data=>x_msg_data,
2291: p_msg_type=>'UNEXPECTED ERROR',
2292: p_msg_level=>fnd_log.level_error);

Line 2292: p_msg_level=>fnd_log.level_error);

2288: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2289: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2290: p_msg_data=>x_msg_data,
2291: p_msg_type=>'UNEXPECTED ERROR',
2292: p_msg_level=>fnd_log.level_error);
2293: END IF;
2294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2296: p_prefix=>l_debug_prefix,

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

2290: p_msg_data=>x_msg_data,
2291: p_msg_type=>'UNEXPECTED ERROR',
2292: p_msg_level=>fnd_log.level_error);
2293: END IF;
2294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2296: p_prefix=>l_debug_prefix,
2297: p_msg_level=>fnd_log.level_procedure);
2298: END IF;

Line 2297: p_msg_level=>fnd_log.level_procedure);

2293: END IF;
2294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2296: p_prefix=>l_debug_prefix,
2297: p_msg_level=>fnd_log.level_procedure);
2298: END IF;
2299: WHEN OTHERS THEN
2300: x_return_status := fnd_api.g_ret_sts_unexp_error;
2301:

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

2307: p_count => x_msg_count,
2308: p_data => x_msg_data);
2309:
2310: -- Debug info.
2311: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2312: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2313: p_msg_data=>x_msg_data,
2314: p_msg_type=>'SQL ERROR',
2315: p_msg_level=>fnd_log.level_error);

Line 2315: p_msg_level=>fnd_log.level_error);

2311: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2312: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2313: p_msg_data=>x_msg_data,
2314: p_msg_type=>'SQL ERROR',
2315: p_msg_level=>fnd_log.level_error);
2316: END IF;
2317: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2318: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2319: p_prefix=>l_debug_prefix,

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

2313: p_msg_data=>x_msg_data,
2314: p_msg_type=>'SQL ERROR',
2315: p_msg_level=>fnd_log.level_error);
2316: END IF;
2317: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2318: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2319: p_prefix=>l_debug_prefix,
2320: p_msg_level=>fnd_log.level_procedure);
2321: END IF;

Line 2320: p_msg_level=>fnd_log.level_procedure);

2316: END IF;
2317: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2318: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2319: p_prefix=>l_debug_prefix,
2320: p_msg_level=>fnd_log.level_procedure);
2321: END IF;
2322:
2323: end;
2324: