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 1105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1101: END IF;
1102:
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_org_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_org_cust_updated(+)',
1107: p_prefix=>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_procedure);
1109: END IF;
1110:
1111: /* moved to public api
1112: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,

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

1141: x_org_cust_obj := l_org_cust_obj;
1142:
1143:
1144: -- Debug info.
1145: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1147: p_msg_data=>x_msg_data,
1148: p_msg_type=>'WARNING',
1149: p_msg_level=>fnd_log.level_exception);

Line 1149: p_msg_level=>fnd_log.level_exception);

1145: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1147: p_msg_data=>x_msg_data,
1148: p_msg_type=>'WARNING',
1149: p_msg_level=>fnd_log.level_exception);
1150: END IF;
1151:
1152: -- Debug info.
1153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1149: p_msg_level=>fnd_log.level_exception);
1150: END IF;
1151:
1152: -- Debug info.
1153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated (-)',
1155: p_prefix=>l_debug_prefix,
1156: p_msg_level=>fnd_log.level_procedure);
1157: END IF;

Line 1156: p_msg_level=>fnd_log.level_procedure);

1152: -- Debug info.
1153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated (-)',
1155: p_prefix=>l_debug_prefix,
1156: p_msg_level=>fnd_log.level_procedure);
1157: END IF;
1158:
1159:
1160: EXCEPTION

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

1166: p_count => x_msg_count,
1167: p_data => x_msg_data);
1168:
1169: -- Debug info.
1170: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1172: p_msg_data=>x_msg_data,
1173: p_msg_type=>'ERROR',
1174: p_msg_level=>fnd_log.level_error);

Line 1174: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1179: p_msg_level=>fnd_log.level_procedure);

1175: END IF;
1176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1177: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1178: p_prefix=>l_debug_prefix,
1179: p_msg_level=>fnd_log.level_procedure);
1180: END IF;
1181: WHEN fnd_api.g_exc_unexpected_error THEN
1182: x_return_status := fnd_api.g_ret_sts_unexp_error;
1183:

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

1185: p_count => x_msg_count,
1186: p_data => x_msg_data);
1187:
1188: -- Debug info.
1189: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1190: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1191: p_msg_data=>x_msg_data,
1192: p_msg_type=>'UNEXPECTED ERROR',
1193: p_msg_level=>fnd_log.level_error);

Line 1193: p_msg_level=>fnd_log.level_error);

1189: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1190: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1191: p_msg_data=>x_msg_data,
1192: p_msg_type=>'UNEXPECTED ERROR',
1193: p_msg_level=>fnd_log.level_error);
1194: END IF;
1195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1196: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1197: p_prefix=>l_debug_prefix,

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

1191: p_msg_data=>x_msg_data,
1192: p_msg_type=>'UNEXPECTED ERROR',
1193: p_msg_level=>fnd_log.level_error);
1194: END IF;
1195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1196: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1197: p_prefix=>l_debug_prefix,
1198: p_msg_level=>fnd_log.level_procedure);
1199: END IF;

Line 1198: p_msg_level=>fnd_log.level_procedure);

1194: END IF;
1195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1196: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1197: p_prefix=>l_debug_prefix,
1198: p_msg_level=>fnd_log.level_procedure);
1199: END IF;
1200: WHEN OTHERS THEN
1201: x_return_status := fnd_api.g_ret_sts_unexp_error;
1202:

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

1208: p_count => x_msg_count,
1209: p_data => x_msg_data);
1210:
1211: -- Debug info.
1212: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1214: p_msg_data=>x_msg_data,
1215: p_msg_type=>'SQL ERROR',
1216: p_msg_level=>fnd_log.level_error);

Line 1216: p_msg_level=>fnd_log.level_error);

1212: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1214: p_msg_data=>x_msg_data,
1215: p_msg_type=>'SQL ERROR',
1216: p_msg_level=>fnd_log.level_error);
1217: END IF;
1218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1219: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1220: p_prefix=>l_debug_prefix,

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

1214: p_msg_data=>x_msg_data,
1215: p_msg_type=>'SQL ERROR',
1216: p_msg_level=>fnd_log.level_error);
1217: END IF;
1218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1219: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1220: p_prefix=>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_procedure);
1222: END IF;

Line 1221: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1302: p_msg_level=>fnd_log.level_procedure);

1298: -- Debug info.
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo(+)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304:
1305: x_org_cust_v2_obj := HZ_ORG_CUST_V2_BO(p_action_type, NULL, NULL);
1306:

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

1333: END IF;
1334:
1335:
1336: -- Debug info.
1337: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1338: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1339: p_msg_data=>x_msg_data,
1340: p_msg_type=>'WARNING',
1341: p_msg_level=>fnd_log.level_exception);

Line 1341: p_msg_level=>fnd_log.level_exception);

1337: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1338: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1339: p_msg_data=>x_msg_data,
1340: p_msg_type=>'WARNING',
1341: p_msg_level=>fnd_log.level_exception);
1342: END IF;
1343:
1344: -- Debug info.
1345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1341: p_msg_level=>fnd_log.level_exception);
1342: END IF;
1343:
1344: -- Debug info.
1345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1346: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1347: p_prefix=>l_debug_prefix,
1348: p_msg_level=>fnd_log.level_procedure);
1349: END IF;

Line 1348: p_msg_level=>fnd_log.level_procedure);

1344: -- Debug info.
1345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1346: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1347: p_prefix=>l_debug_prefix,
1348: p_msg_level=>fnd_log.level_procedure);
1349: END IF;
1350:
1351:
1352: EXCEPTION

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

1358: p_count => x_msg_count,
1359: p_data => x_msg_data);
1360:
1361: -- Debug info.
1362: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1363: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1364: p_msg_data=>x_msg_data,
1365: p_msg_type=>'ERROR',
1366: p_msg_level=>fnd_log.level_error);

Line 1366: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1371: p_msg_level=>fnd_log.level_procedure);

1367: END IF;
1368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1369: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1370: p_prefix=>l_debug_prefix,
1371: p_msg_level=>fnd_log.level_procedure);
1372: END IF;
1373: WHEN fnd_api.g_exc_unexpected_error THEN
1374: x_return_status := fnd_api.g_ret_sts_unexp_error;
1375:

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

1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:
1380: -- Debug info.
1381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1383: p_msg_data=>x_msg_data,
1384: p_msg_type=>'UNEXPECTED ERROR',
1385: p_msg_level=>fnd_log.level_error);

Line 1385: p_msg_level=>fnd_log.level_error);

1381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1383: p_msg_data=>x_msg_data,
1384: p_msg_type=>'UNEXPECTED ERROR',
1385: p_msg_level=>fnd_log.level_error);
1386: END IF;
1387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1388: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1389: p_prefix=>l_debug_prefix,

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

1383: p_msg_data=>x_msg_data,
1384: p_msg_type=>'UNEXPECTED ERROR',
1385: p_msg_level=>fnd_log.level_error);
1386: END IF;
1387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1388: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1389: p_prefix=>l_debug_prefix,
1390: p_msg_level=>fnd_log.level_procedure);
1391: END IF;

Line 1390: p_msg_level=>fnd_log.level_procedure);

1386: END IF;
1387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1388: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1389: p_prefix=>l_debug_prefix,
1390: p_msg_level=>fnd_log.level_procedure);
1391: END IF;
1392: WHEN OTHERS THEN
1393: x_return_status := fnd_api.g_ret_sts_unexp_error;
1394:

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

1400: p_count => x_msg_count,
1401: p_data => x_msg_data);
1402:
1403: -- Debug info.
1404: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1405: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1406: p_msg_data=>x_msg_data,
1407: p_msg_type=>'SQL ERROR',
1408: p_msg_level=>fnd_log.level_error);

Line 1408: p_msg_level=>fnd_log.level_error);

1404: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1405: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1406: p_msg_data=>x_msg_data,
1407: p_msg_type=>'SQL ERROR',
1408: p_msg_level=>fnd_log.level_error);
1409: END IF;
1410: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1411: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1412: p_prefix=>l_debug_prefix,

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

1406: p_msg_data=>x_msg_data,
1407: p_msg_type=>'SQL ERROR',
1408: p_msg_level=>fnd_log.level_error);
1409: END IF;
1410: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1411: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1412: p_prefix=>l_debug_prefix,
1413: p_msg_level=>fnd_log.level_procedure);
1414: END IF;

Line 1413: p_msg_level=>fnd_log.level_procedure);

1409: END IF;
1410: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1411: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1412: p_prefix=>l_debug_prefix,
1413: p_msg_level=>fnd_log.level_procedure);
1414: END IF;
1415:
1416: end;
1417:

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

1489: END IF;
1490:
1491:
1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;

Line 1496: p_msg_level=>fnd_log.level_procedure);

1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;
1498:
1499:
1500: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

1574:
1575: end loop;
1576:
1577: -- Debug info.
1578: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1579: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1580: p_msg_data=>x_msg_data,
1581: p_msg_type=>'WARNING',
1582: p_msg_level=>fnd_log.level_exception);

Line 1582: p_msg_level=>fnd_log.level_exception);

1578: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1579: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1580: p_msg_data=>x_msg_data,
1581: p_msg_type=>'WARNING',
1582: p_msg_level=>fnd_log.level_exception);
1583: END IF;
1584:
1585: -- Debug info.
1586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1582: p_msg_level=>fnd_log.level_exception);
1583: END IF;
1584:
1585: -- Debug info.
1586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1587: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created (-)',
1588: p_prefix=>l_debug_prefix,
1589: p_msg_level=>fnd_log.level_procedure);
1590: END IF;

Line 1589: p_msg_level=>fnd_log.level_procedure);

1585: -- Debug info.
1586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1587: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created (-)',
1588: p_prefix=>l_debug_prefix,
1589: p_msg_level=>fnd_log.level_procedure);
1590: END IF;
1591:
1592:
1593: EXCEPTION

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

1599: p_count => x_msg_count,
1600: p_data => x_msg_data);
1601:
1602: -- Debug info.
1603: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1604: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1605: p_msg_data=>x_msg_data,
1606: p_msg_type=>'ERROR',
1607: p_msg_level=>fnd_log.level_error);

Line 1607: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1612: p_msg_level=>fnd_log.level_procedure);

1608: END IF;
1609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1610: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1611: p_prefix=>l_debug_prefix,
1612: p_msg_level=>fnd_log.level_procedure);
1613: END IF;
1614: WHEN fnd_api.g_exc_unexpected_error THEN
1615: x_return_status := fnd_api.g_ret_sts_unexp_error;
1616:

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

1618: p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:
1621: -- Debug info.
1622: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1624: p_msg_data=>x_msg_data,
1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);

Line 1626: p_msg_level=>fnd_log.level_error);

1622: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1624: p_msg_data=>x_msg_data,
1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);
1627: END IF;
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1630: p_prefix=>l_debug_prefix,

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

1624: p_msg_data=>x_msg_data,
1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);
1627: END IF;
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;

Line 1631: p_msg_level=>fnd_log.level_procedure);

1627: END IF;
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;
1633: WHEN OTHERS THEN
1634: x_return_status := fnd_api.g_ret_sts_unexp_error;
1635:

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

1641: p_count => x_msg_count,
1642: p_data => x_msg_data);
1643:
1644: -- Debug info.
1645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1646: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1647: p_msg_data=>x_msg_data,
1648: p_msg_type=>'SQL ERROR',
1649: p_msg_level=>fnd_log.level_error);

Line 1649: p_msg_level=>fnd_log.level_error);

1645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1646: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1647: p_msg_data=>x_msg_data,
1648: p_msg_type=>'SQL ERROR',
1649: p_msg_level=>fnd_log.level_error);
1650: END IF;
1651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1652: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1653: p_prefix=>l_debug_prefix,

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

1647: p_msg_data=>x_msg_data,
1648: p_msg_type=>'SQL ERROR',
1649: p_msg_level=>fnd_log.level_error);
1650: END IF;
1651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1652: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1653: p_prefix=>l_debug_prefix,
1654: p_msg_level=>fnd_log.level_procedure);
1655: END IF;

Line 1654: p_msg_level=>fnd_log.level_procedure);

1650: END IF;
1651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1652: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1653: p_prefix=>l_debug_prefix,
1654: p_msg_level=>fnd_log.level_procedure);
1655: END IF;
1656:
1657: end;
1658:

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

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

Line 1733: p_msg_level=>fnd_log.level_procedure);

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

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

1764: end loop;
1765:
1766:
1767: -- Debug info.
1768: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1769: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1770: p_msg_data=>x_msg_data,
1771: p_msg_type=>'WARNING',
1772: p_msg_level=>fnd_log.level_exception);

Line 1772: p_msg_level=>fnd_log.level_exception);

1768: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1769: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1770: p_msg_data=>x_msg_data,
1771: p_msg_type=>'WARNING',
1772: p_msg_level=>fnd_log.level_exception);
1773: END IF;
1774:
1775: -- Debug info.
1776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

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

Line 1779: p_msg_level=>fnd_log.level_procedure);

1775: -- Debug info.
1776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1777: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated (-)',
1778: p_prefix=>l_debug_prefix,
1779: p_msg_level=>fnd_log.level_procedure);
1780: END IF;
1781:
1782:
1783: EXCEPTION

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

1789: p_count => x_msg_count,
1790: p_data => x_msg_data);
1791:
1792: -- Debug info.
1793: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1794: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1795: p_msg_data=>x_msg_data,
1796: p_msg_type=>'ERROR',
1797: p_msg_level=>fnd_log.level_error);

Line 1797: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1802: p_msg_level=>fnd_log.level_procedure);

1798: END IF;
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806:

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

1808: p_count => x_msg_count,
1809: p_data => x_msg_data);
1810:
1811: -- Debug info.
1812: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1813: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1814: p_msg_data=>x_msg_data,
1815: p_msg_type=>'UNEXPECTED ERROR',
1816: p_msg_level=>fnd_log.level_error);

Line 1816: p_msg_level=>fnd_log.level_error);

1812: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1813: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1814: p_msg_data=>x_msg_data,
1815: p_msg_type=>'UNEXPECTED ERROR',
1816: p_msg_level=>fnd_log.level_error);
1817: END IF;
1818: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1819: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1820: p_prefix=>l_debug_prefix,

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

1814: p_msg_data=>x_msg_data,
1815: p_msg_type=>'UNEXPECTED ERROR',
1816: p_msg_level=>fnd_log.level_error);
1817: END IF;
1818: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1819: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1820: p_prefix=>l_debug_prefix,
1821: p_msg_level=>fnd_log.level_procedure);
1822: END IF;

Line 1821: p_msg_level=>fnd_log.level_procedure);

1817: END IF;
1818: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1819: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1820: p_prefix=>l_debug_prefix,
1821: p_msg_level=>fnd_log.level_procedure);
1822: END IF;
1823: WHEN OTHERS THEN
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;
1825:

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

1831: p_count => x_msg_count,
1832: p_data => x_msg_data);
1833:
1834: -- Debug info.
1835: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1836: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1837: p_msg_data=>x_msg_data,
1838: p_msg_type=>'SQL ERROR',
1839: p_msg_level=>fnd_log.level_error);

Line 1839: p_msg_level=>fnd_log.level_error);

1835: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1836: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1837: p_msg_data=>x_msg_data,
1838: p_msg_type=>'SQL ERROR',
1839: p_msg_level=>fnd_log.level_error);
1840: END IF;
1841: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1842: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1843: p_prefix=>l_debug_prefix,

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

1837: p_msg_data=>x_msg_data,
1838: p_msg_type=>'SQL ERROR',
1839: p_msg_level=>fnd_log.level_error);
1840: END IF;
1841: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1842: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1843: p_prefix=>l_debug_prefix,
1844: p_msg_level=>fnd_log.level_procedure);
1845: END IF;

Line 1844: p_msg_level=>fnd_log.level_procedure);

1840: END IF;
1841: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1842: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1843: p_prefix=>l_debug_prefix,
1844: p_msg_level=>fnd_log.level_procedure);
1845: END IF;
1846:
1847: end;
1848:

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

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

Line 2254: p_msg_level=>fnd_log.level_procedure);

2250: -- Debug info.
2251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2252: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(+)',
2253: p_prefix=>l_debug_prefix,
2254: p_msg_level=>fnd_log.level_procedure);
2255: END IF;
2256:
2257: -- Set action type to 'UNCHANGED' by default
2258:

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

2278: x_org_cust_v2_obj := l_org_cust_obj;
2279:
2280:
2281: -- Debug info.
2282: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2284: p_msg_data=>x_msg_data,
2285: p_msg_type=>'WARNING',
2286: p_msg_level=>fnd_log.level_exception);

Line 2286: p_msg_level=>fnd_log.level_exception);

2282: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2284: p_msg_data=>x_msg_data,
2285: p_msg_type=>'WARNING',
2286: p_msg_level=>fnd_log.level_exception);
2287: END IF;
2288:
2289: -- Debug info.
2290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2286: p_msg_level=>fnd_log.level_exception);
2287: END IF;
2288:
2289: -- Debug info.
2290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2291: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated (-)',
2292: p_prefix=>l_debug_prefix,
2293: p_msg_level=>fnd_log.level_procedure);
2294: END IF;

Line 2293: p_msg_level=>fnd_log.level_procedure);

2289: -- Debug info.
2290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2291: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated (-)',
2292: p_prefix=>l_debug_prefix,
2293: p_msg_level=>fnd_log.level_procedure);
2294: END IF;
2295:
2296:
2297: EXCEPTION

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

2303: p_count => x_msg_count,
2304: p_data => x_msg_data);
2305:
2306: -- Debug info.
2307: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2308: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2309: p_msg_data=>x_msg_data,
2310: p_msg_type=>'ERROR',
2311: p_msg_level=>fnd_log.level_error);

Line 2311: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2316: p_msg_level=>fnd_log.level_procedure);

2312: END IF;
2313: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2314: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2315: p_prefix=>l_debug_prefix,
2316: p_msg_level=>fnd_log.level_procedure);
2317: END IF;
2318: WHEN fnd_api.g_exc_unexpected_error THEN
2319: x_return_status := fnd_api.g_ret_sts_unexp_error;
2320:

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

2322: p_count => x_msg_count,
2323: p_data => x_msg_data);
2324:
2325: -- Debug info.
2326: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2327: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2328: p_msg_data=>x_msg_data,
2329: p_msg_type=>'UNEXPECTED ERROR',
2330: p_msg_level=>fnd_log.level_error);

Line 2330: p_msg_level=>fnd_log.level_error);

2326: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2327: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2328: p_msg_data=>x_msg_data,
2329: p_msg_type=>'UNEXPECTED ERROR',
2330: p_msg_level=>fnd_log.level_error);
2331: END IF;
2332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2333: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2334: p_prefix=>l_debug_prefix,

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

2328: p_msg_data=>x_msg_data,
2329: p_msg_type=>'UNEXPECTED ERROR',
2330: p_msg_level=>fnd_log.level_error);
2331: END IF;
2332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2333: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2334: p_prefix=>l_debug_prefix,
2335: p_msg_level=>fnd_log.level_procedure);
2336: END IF;

Line 2335: p_msg_level=>fnd_log.level_procedure);

2331: END IF;
2332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2333: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2334: p_prefix=>l_debug_prefix,
2335: p_msg_level=>fnd_log.level_procedure);
2336: END IF;
2337: WHEN OTHERS THEN
2338: x_return_status := fnd_api.g_ret_sts_unexp_error;
2339:

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

2345: p_count => x_msg_count,
2346: p_data => x_msg_data);
2347:
2348: -- Debug info.
2349: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2350: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2351: p_msg_data=>x_msg_data,
2352: p_msg_type=>'SQL ERROR',
2353: p_msg_level=>fnd_log.level_error);

Line 2353: p_msg_level=>fnd_log.level_error);

2349: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2350: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2351: p_msg_data=>x_msg_data,
2352: p_msg_type=>'SQL ERROR',
2353: p_msg_level=>fnd_log.level_error);
2354: END IF;
2355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2356: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2357: p_prefix=>l_debug_prefix,

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

2351: p_msg_data=>x_msg_data,
2352: p_msg_type=>'SQL ERROR',
2353: p_msg_level=>fnd_log.level_error);
2354: END IF;
2355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2356: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2357: p_prefix=>l_debug_prefix,
2358: p_msg_level=>fnd_log.level_procedure);
2359: END IF;

Line 2358: p_msg_level=>fnd_log.level_procedure);

2354: END IF;
2355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2356: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2357: p_prefix=>l_debug_prefix,
2358: p_msg_level=>fnd_log.level_procedure);
2359: END IF;
2360:
2361: end;
2362: