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

Line 176: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

172: fnd_message.set_token('TABLE', 'fnd_objects');
173: fnd_msg_pub.add;
174: x_return_status := fnd_api.g_ret_sts_error;
175: END;
176: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
177: hz_utility_v2pub.debug(p_message=>'parent_table_name has foreign key fnd_objects.obj_name. ' ||
178: 'x_return_status = ' || x_return_status,
179: p_prefix =>l_debug_prefix,
180: p_msg_level=>fnd_log.level_statement);

Line 180: p_msg_level=>fnd_log.level_statement);

176: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
177: hz_utility_v2pub.debug(p_message=>'parent_table_name has foreign key fnd_objects.obj_name. ' ||
178: 'x_return_status = ' || x_return_status,
179: p_prefix =>l_debug_prefix,
180: p_msg_level=>fnd_log.level_statement);
181: END IF;
182: END IF;
183:
184: ------------------------------

Line 206: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

202: fnd_msg_pub.add;
203: x_return_status := fnd_api.g_ret_sts_error;
204: END;
205:
206: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'parent_object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
208: 'x_return_status = ' || x_return_status,
209: p_prefix =>l_debug_prefix,
210: p_msg_level=>fnd_log.level_statement);

Line 210: p_msg_level=>fnd_log.level_statement);

206: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'parent_object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
208: 'x_return_status = ' || x_return_status,
209: p_prefix =>l_debug_prefix,
210: p_msg_level=>fnd_log.level_statement);
211: END IF;
212:
213: END IF;
214:

Line 235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

231: fnd_msg_pub.add;
232: x_return_status := fnd_api.g_ret_sts_error;
233: END;
234:
235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'child_table_name has foreign key fnd_objects.obj_name. ' ||
237: 'x_return_status = ' || x_return_status,
238: p_prefix =>l_debug_prefix,
239: p_msg_level=>fnd_log.level_statement);

Line 239: p_msg_level=>fnd_log.level_statement);

235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'child_table_name has foreign key fnd_objects.obj_name. ' ||
237: 'x_return_status = ' || x_return_status,
238: p_prefix =>l_debug_prefix,
239: p_msg_level=>fnd_log.level_statement);
240: END IF;
241: END IF;
242:
243: ------------------------------

Line 264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

260: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
261: fnd_msg_pub.add;
262: x_return_status := fnd_api.g_ret_sts_error;
263: END;
264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
265: hz_utility_v2pub.debug(p_message=>'child_object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
266: 'x_return_status = ' || x_return_status,
267: p_prefix =>l_debug_prefix,
268: p_msg_level=>fnd_log.level_statement);

Line 268: p_msg_level=>fnd_log.level_statement);

264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
265: hz_utility_v2pub.debug(p_message=>'child_object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
266: 'x_return_status = ' || x_return_status,
267: p_prefix =>l_debug_prefix,
268: p_msg_level=>fnd_log.level_statement);
269: END IF;
270:
271: END IF;
272:

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

284: FND_MESSAGE.SET_TOKEN( 'VALUE2', '100' );
285: FND_MSG_PUB.ADD;
286: x_return_status := FND_API.G_RET_STS_ERROR;
287:
288: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
289: hz_utility_v2pub.debug(p_message=>'p_no_of_records should be between 1 and 100 .' ||
290: 'x_return_status = ' || x_return_status,
291: p_prefix =>l_debug_prefix,
292: p_msg_level=>fnd_log.level_statement);

Line 292: p_msg_level=>fnd_log.level_statement);

288: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
289: hz_utility_v2pub.debug(p_message=>'p_no_of_records should be between 1 and 100 .' ||
290: 'x_return_status = ' || x_return_status,
291: p_prefix =>l_debug_prefix,
292: p_msg_level=>fnd_log.level_statement);
293: END IF;
294: END IF;
295:
296:

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

337: -- Check if API is called in debug mode. If yes, enable debug.
338: --enable_debug;
339:
340: -- Debug info.
341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
342: hz_utility_v2pub.debug(p_message=>'is_top_parent (+)',
343: p_prefix=>l_debug_prefix,
344: p_msg_level=>fnd_log.level_procedure);
345: END IF;

Line 344: p_msg_level=>fnd_log.level_procedure);

340: -- Debug info.
341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
342: hz_utility_v2pub.debug(p_message=>'is_top_parent (+)',
343: p_prefix=>l_debug_prefix,
344: p_msg_level=>fnd_log.level_procedure);
345: END IF;
346:
347: --Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 400: p_msg_level=>fnd_log.level_exception);

396: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
398: p_msg_data=>x_msg_data,
399: p_msg_type=>'WARNING',
400: p_msg_level=>fnd_log.level_exception);
401: END IF;
402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',
404: p_prefix=>l_debug_prefix,

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

398: p_msg_data=>x_msg_data,
399: p_msg_type=>'WARNING',
400: p_msg_level=>fnd_log.level_exception);
401: END IF;
402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',
404: p_prefix=>l_debug_prefix,
405: p_msg_level=>fnd_log.level_procedure);
406: END IF;

Line 405: p_msg_level=>fnd_log.level_procedure);

401: END IF;
402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',
404: p_prefix=>l_debug_prefix,
405: p_msg_level=>fnd_log.level_procedure);
406: END IF;
407:
408: -- Check if API is called in debug mode. If yes, disable debug.
409: --disable_debug;

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

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

Line 426: p_msg_level=>fnd_log.level_error);

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

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

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

Line 431: p_msg_level=>fnd_log.level_procedure);

427: END IF;
428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
429: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',
430: p_prefix=>l_debug_prefix,
431: p_msg_level=>fnd_log.level_procedure);
432: END IF;
433:
434: -- Check if API is called in debug mode. If yes, disable debug.
435: --disable_debug;

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

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

Line 451: p_msg_level=>fnd_log.level_error);

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

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

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

Line 456: p_msg_level=>fnd_log.level_procedure);

452: END IF;
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:
459: -- Check if API is called in debug mode. If yes, disable debug.
460: --disable_debug;

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

472: p_count => x_msg_count,
473: p_data => x_msg_data );
474:
475: -- Debug info.
476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
478: p_msg_data=>x_msg_data,
479: p_msg_type=>'SQL ERROR',
480: p_msg_level=>fnd_log.level_error);

Line 480: p_msg_level=>fnd_log.level_error);

476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
478: p_msg_data=>x_msg_data,
479: p_msg_type=>'SQL ERROR',
480: p_msg_level=>fnd_log.level_error);
481: END IF;
482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',
484: p_prefix=>l_debug_prefix,

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

478: p_msg_data=>x_msg_data,
479: p_msg_type=>'SQL ERROR',
480: p_msg_level=>fnd_log.level_error);
481: END IF;
482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',
484: p_prefix=>l_debug_prefix,
485: p_msg_level=>fnd_log.level_procedure);
486: END IF;

Line 485: p_msg_level=>fnd_log.level_procedure);

481: END IF;
482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',
484: p_prefix=>l_debug_prefix,
485: p_msg_level=>fnd_log.level_procedure);
486: END IF;
487:
488: -- Check if API is called in debug mode. If yes, disable debug.
489: --disable_debug;

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

517: -- Check if API is called in debug mode. If yes, enable debug.
518: --enable_debug;
519:
520: -- Debug info.
521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
522: hz_utility_v2pub.debug(p_message=>'check_parent_child (+)',
523: p_prefix=>l_debug_prefix,
524: p_msg_level=>fnd_log.level_procedure);
525: END IF;

Line 524: p_msg_level=>fnd_log.level_procedure);

520: -- Debug info.
521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
522: hz_utility_v2pub.debug(p_message=>'check_parent_child (+)',
523: p_prefix=>l_debug_prefix,
524: p_msg_level=>fnd_log.level_procedure);
525: END IF;
526:
527: --Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

580: p_count => x_msg_count,
581: p_data => x_msg_data );
582:
583: -- Debug info.
584: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
585: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
586: p_msg_data=>x_msg_data,
587: p_msg_type=>'WARNING',
588: p_msg_level=>fnd_log.level_exception);

Line 588: p_msg_level=>fnd_log.level_exception);

584: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
585: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
586: p_msg_data=>x_msg_data,
587: p_msg_type=>'WARNING',
588: p_msg_level=>fnd_log.level_exception);
589: END IF;
590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
591: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
592: p_prefix=>l_debug_prefix,

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

586: p_msg_data=>x_msg_data,
587: p_msg_type=>'WARNING',
588: p_msg_level=>fnd_log.level_exception);
589: END IF;
590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
591: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
592: p_prefix=>l_debug_prefix,
593: p_msg_level=>fnd_log.level_procedure);
594: END IF;

Line 593: p_msg_level=>fnd_log.level_procedure);

589: END IF;
590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
591: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
592: p_prefix=>l_debug_prefix,
593: p_msg_level=>fnd_log.level_procedure);
594: END IF;
595:
596: -- Check if API is called in debug mode. If yes, disable debug.
597: --disable_debug;

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

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

Line 615: p_msg_level=>fnd_log.level_error);

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

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

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

Line 620: p_msg_level=>fnd_log.level_procedure);

616: END IF;
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;
622:
623: -- Check if API is called in debug mode. If yes, disable debug.
624: --disable_debug;

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

633: p_count => x_msg_count,
634: p_data => x_msg_data );
635:
636: -- Debug info.
637: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
638: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
639: p_msg_data=>x_msg_data,
640: p_msg_type=>'UNEXPECTED ERROR',
641: p_msg_level=>fnd_log.level_error);

Line 641: p_msg_level=>fnd_log.level_error);

637: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
638: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
639: p_msg_data=>x_msg_data,
640: p_msg_type=>'UNEXPECTED ERROR',
641: p_msg_level=>fnd_log.level_error);
642: END IF;
643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
644: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
645: p_prefix=>l_debug_prefix,

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

639: p_msg_data=>x_msg_data,
640: p_msg_type=>'UNEXPECTED ERROR',
641: p_msg_level=>fnd_log.level_error);
642: END IF;
643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
644: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
645: p_prefix=>l_debug_prefix,
646: p_msg_level=>fnd_log.level_procedure);
647: END IF;

Line 646: p_msg_level=>fnd_log.level_procedure);

642: END IF;
643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
644: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
645: p_prefix=>l_debug_prefix,
646: p_msg_level=>fnd_log.level_procedure);
647: END IF;
648:
649: -- Check if API is called in debug mode. If yes, disable debug.
650: --disable_debug;

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

663: p_count => x_msg_count,
664: p_data => x_msg_data );
665:
666: -- Debug info.
667: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
668: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
669: p_msg_data=>x_msg_data,
670: p_msg_type=>'SQL ERROR',
671: p_msg_level=>fnd_log.level_error);

Line 671: p_msg_level=>fnd_log.level_error);

667: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
668: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
669: p_msg_data=>x_msg_data,
670: p_msg_type=>'SQL ERROR',
671: p_msg_level=>fnd_log.level_error);
672: END IF;
673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
674: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
675: p_prefix=>l_debug_prefix,

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

669: p_msg_data=>x_msg_data,
670: p_msg_type=>'SQL ERROR',
671: p_msg_level=>fnd_log.level_error);
672: END IF;
673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
674: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
675: p_prefix=>l_debug_prefix,
676: p_msg_level=>fnd_log.level_procedure);
677: END IF;

Line 676: p_msg_level=>fnd_log.level_procedure);

672: END IF;
673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
674: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',
675: p_prefix=>l_debug_prefix,
676: p_msg_level=>fnd_log.level_procedure);
677: END IF;
678:
679: -- Check if API is called in debug mode. If yes, disable debug.
680: --disable_debug;

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

746: -- Check if API is called in debug mode. If yes, enable debug.
747: --enable_debug;
748:
749: -- Debug info.
750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
751: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (+)',
752: p_prefix=>l_debug_prefix,
753: p_msg_level=>fnd_log.level_procedure);
754: END IF;

Line 753: p_msg_level=>fnd_log.level_procedure);

749: -- Debug info.
750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
751: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (+)',
752: p_prefix=>l_debug_prefix,
753: p_msg_level=>fnd_log.level_procedure);
754: END IF;
755:
756: --Initialize message list if p_init_msg_list is set to TRUE.
757: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

827: p_count => x_msg_count,
828: p_data => x_msg_data );
829:
830: -- Debug info.
831: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
832: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
833: p_msg_data=>x_msg_data,
834: p_msg_type=>'WARNING',
835: p_msg_level=>fnd_log.level_exception);

Line 835: p_msg_level=>fnd_log.level_exception);

831: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
832: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
833: p_msg_data=>x_msg_data,
834: p_msg_type=>'WARNING',
835: p_msg_level=>fnd_log.level_exception);
836: END IF;
837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
839: p_prefix=>l_debug_prefix,

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

833: p_msg_data=>x_msg_data,
834: p_msg_type=>'WARNING',
835: p_msg_level=>fnd_log.level_exception);
836: END IF;
837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
839: p_prefix=>l_debug_prefix,
840: p_msg_level=>fnd_log.level_procedure);
841: END IF;

Line 840: p_msg_level=>fnd_log.level_procedure);

836: END IF;
837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
839: p_prefix=>l_debug_prefix,
840: p_msg_level=>fnd_log.level_procedure);
841: END IF;
842:
843: -- Check if API is called in debug mode. If yes, disable debug.
844: --disable_debug;

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

852: p_count => x_msg_count,
853: p_data => x_msg_data );
854:
855: -- Debug info.
856: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
858: p_msg_data=>x_msg_data,
859: p_msg_type=>'ERROR',
860: p_msg_level=>fnd_log.level_error);

Line 860: p_msg_level=>fnd_log.level_error);

856: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
858: p_msg_data=>x_msg_data,
859: p_msg_type=>'ERROR',
860: p_msg_level=>fnd_log.level_error);
861: END IF;
862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
863: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
864: p_prefix=>l_debug_prefix,

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

858: p_msg_data=>x_msg_data,
859: p_msg_type=>'ERROR',
860: p_msg_level=>fnd_log.level_error);
861: END IF;
862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
863: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
864: p_prefix=>l_debug_prefix,
865: p_msg_level=>fnd_log.level_procedure);
866: END IF;

Line 865: p_msg_level=>fnd_log.level_procedure);

861: END IF;
862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
863: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
864: p_prefix=>l_debug_prefix,
865: p_msg_level=>fnd_log.level_procedure);
866: END IF;
867:
868: -- Check if API is called in debug mode. If yes, disable debug.
869: --disable_debug;

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

876: p_count => x_msg_count,
877: p_data => x_msg_data );
878:
879: -- Debug info.
880: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
881: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
882: p_msg_data=>x_msg_data,
883: p_msg_type=>'UNEXPECTED ERROR',
884: p_msg_level=>fnd_log.level_error);

Line 884: p_msg_level=>fnd_log.level_error);

880: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
881: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
882: p_msg_data=>x_msg_data,
883: p_msg_type=>'UNEXPECTED ERROR',
884: p_msg_level=>fnd_log.level_error);
885: END IF;
886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
887: hz_utility_v2pub.debug(p_message=> 'get_parent_nodes (-)' ,
888: p_prefix=>l_debug_prefix,

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

882: p_msg_data=>x_msg_data,
883: p_msg_type=>'UNEXPECTED ERROR',
884: p_msg_level=>fnd_log.level_error);
885: END IF;
886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
887: hz_utility_v2pub.debug(p_message=> 'get_parent_nodes (-)' ,
888: p_prefix=>l_debug_prefix,
889: p_msg_level=>fnd_log.level_procedure);
890: END IF;

Line 889: p_msg_level=>fnd_log.level_procedure);

885: END IF;
886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
887: hz_utility_v2pub.debug(p_message=> 'get_parent_nodes (-)' ,
888: p_prefix=>l_debug_prefix,
889: p_msg_level=>fnd_log.level_procedure);
890: END IF;
891:
892: -- Check if API is called in debug mode. If yes, disable debug.
893: --disable_debug;

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

904: p_count => x_msg_count,
905: p_data => x_msg_data );
906:
907: -- Debug info.
908: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
909: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
910: p_msg_data=>x_msg_data,
911: p_msg_type=>'SQL ERROR',
912: p_msg_level=>fnd_log.level_error);

Line 912: p_msg_level=>fnd_log.level_error);

908: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
909: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
910: p_msg_data=>x_msg_data,
911: p_msg_type=>'SQL ERROR',
912: p_msg_level=>fnd_log.level_error);
913: END IF;
914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
915: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
916: p_prefix=>l_debug_prefix,

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

910: p_msg_data=>x_msg_data,
911: p_msg_type=>'SQL ERROR',
912: p_msg_level=>fnd_log.level_error);
913: END IF;
914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
915: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
916: p_prefix=>l_debug_prefix,
917: p_msg_level=>fnd_log.level_procedure);
918: END IF;

Line 917: p_msg_level=>fnd_log.level_procedure);

913: END IF;
914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
915: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',
916: p_prefix=>l_debug_prefix,
917: p_msg_level=>fnd_log.level_procedure);
918: END IF;
919:
920: -- Check if API is called in debug mode. If yes, disable debug.
921: --disable_debug;

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

987: -- Check if API is called in debug mode. If yes, enable debug.
988: --enable_debug;
989:
990: -- Debug info.
991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
992: hz_utility_v2pub.debug(p_message=>'get_child_nodes (+)',
993: p_prefix=>l_debug_prefix,
994: p_msg_level=>fnd_log.level_procedure);
995: END IF;

Line 994: p_msg_level=>fnd_log.level_procedure);

990: -- Debug info.
991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
992: hz_utility_v2pub.debug(p_message=>'get_child_nodes (+)',
993: p_prefix=>l_debug_prefix,
994: p_msg_level=>fnd_log.level_procedure);
995: END IF;
996:
997: --Initialize message list if p_init_msg_list is set to TRUE.
998: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1068: p_count => x_msg_count,
1069: p_data => x_msg_data );
1070:
1071: -- Debug info.
1072: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1074: p_msg_data=>x_msg_data,
1075: p_msg_type=>'WARNING',
1076: p_msg_level=>fnd_log.level_exception);

Line 1076: p_msg_level=>fnd_log.level_exception);

1072: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1074: p_msg_data=>x_msg_data,
1075: p_msg_type=>'WARNING',
1076: p_msg_level=>fnd_log.level_exception);
1077: END IF;
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',
1080: p_prefix=>l_debug_prefix,

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

1074: p_msg_data=>x_msg_data,
1075: p_msg_type=>'WARNING',
1076: p_msg_level=>fnd_log.level_exception);
1077: END IF;
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',
1080: p_prefix=>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_procedure);
1082: END IF;

Line 1081: p_msg_level=>fnd_log.level_procedure);

1077: END IF;
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',
1080: p_prefix=>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_procedure);
1082: END IF;
1083:
1084: -- Check if API is called in debug mode. If yes, disable debug.
1085: --disable_debug;

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

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

Line 1101: p_msg_level=>fnd_log.level_error);

1097: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1098: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1099: p_msg_data=>x_msg_data,
1100: p_msg_type=>'ERROR',
1101: p_msg_level=>fnd_log.level_error);
1102: END IF;
1103: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1104: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',
1105: p_prefix=>l_debug_prefix,

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

1099: p_msg_data=>x_msg_data,
1100: p_msg_type=>'ERROR',
1101: p_msg_level=>fnd_log.level_error);
1102: END IF;
1103: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1104: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',
1105: p_prefix=>l_debug_prefix,
1106: p_msg_level=>fnd_log.level_procedure);
1107: END IF;

Line 1106: p_msg_level=>fnd_log.level_procedure);

1102: END IF;
1103: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1104: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',
1105: p_prefix=>l_debug_prefix,
1106: p_msg_level=>fnd_log.level_procedure);
1107: END IF;
1108:
1109: -- Check if API is called in debug mode. If yes, disable debug.
1110: --disable_debug;

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

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

Line 1125: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1130: p_msg_level=>fnd_log.level_procedure);

1126: END IF;
1127: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1128: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',
1129: p_prefix=>l_debug_prefix,
1130: p_msg_level=>fnd_log.level_procedure);
1131: END IF;
1132:
1133: -- Check if API is called in debug mode. If yes, disable debug.
1134: --disable_debug;

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

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

Line 1153: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1158: p_msg_level=>fnd_log.level_procedure);

1154: END IF;
1155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',
1157: p_prefix=>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_procedure);
1159: END IF;
1160:
1161: -- Check if API is called in debug mode. If yes, disable debug.
1162: --disable_debug;

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

1245: -- Check if API is called in debug mode. If yes, enable debug.
1246: --enable_debug;
1247:
1248: -- Debug info.
1249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (+)',
1251: p_prefix=>l_debug_prefix,
1252: p_msg_level=>fnd_log.level_procedure);
1253: END IF;

Line 1252: p_msg_level=>fnd_log.level_procedure);

1248: -- Debug info.
1249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (+)',
1251: p_prefix=>l_debug_prefix,
1252: p_msg_level=>fnd_log.level_procedure);
1253: END IF;
1254:
1255: --Initialize message list if p_init_msg_list is set to TRUE.
1256: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1344: p_count => x_msg_count,
1345: p_data => x_msg_data );
1346:
1347: -- Debug info.
1348: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1349: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1350: p_msg_data=>x_msg_data,
1351: p_msg_type=>'WARNING',
1352: p_msg_level=>fnd_log.level_exception);

Line 1352: p_msg_level=>fnd_log.level_exception);

1348: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1349: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1350: p_msg_data=>x_msg_data,
1351: p_msg_type=>'WARNING',
1352: p_msg_level=>fnd_log.level_exception);
1353: END IF;
1354: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1355: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1356: p_prefix=>l_debug_prefix,

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

1350: p_msg_data=>x_msg_data,
1351: p_msg_type=>'WARNING',
1352: p_msg_level=>fnd_log.level_exception);
1353: END IF;
1354: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1355: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1356: p_prefix=>l_debug_prefix,
1357: p_msg_level=>fnd_log.level_procedure);
1358: END IF;

Line 1357: p_msg_level=>fnd_log.level_procedure);

1353: END IF;
1354: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1355: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1356: p_prefix=>l_debug_prefix,
1357: p_msg_level=>fnd_log.level_procedure);
1358: END IF;
1359:
1360: -- Check if API is called in debug mode. If yes, disable debug.
1361: --disable_debug;

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

1369: p_count => x_msg_count,
1370: p_data => x_msg_data );
1371:
1372: -- Debug info.
1373: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1374: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1375: p_msg_data=>x_msg_data,
1376: p_msg_type=>'ERROR',
1377: p_msg_level=>fnd_log.level_error);

Line 1377: p_msg_level=>fnd_log.level_error);

1373: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1374: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1375: p_msg_data=>x_msg_data,
1376: p_msg_type=>'ERROR',
1377: p_msg_level=>fnd_log.level_error);
1378: END IF;
1379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1380: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1381: p_prefix=>l_debug_prefix,

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

1375: p_msg_data=>x_msg_data,
1376: p_msg_type=>'ERROR',
1377: p_msg_level=>fnd_log.level_error);
1378: END IF;
1379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1380: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1381: p_prefix=>l_debug_prefix,
1382: p_msg_level=>fnd_log.level_procedure);
1383: END IF;

Line 1382: p_msg_level=>fnd_log.level_procedure);

1378: END IF;
1379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1380: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1381: p_prefix=>l_debug_prefix,
1382: p_msg_level=>fnd_log.level_procedure);
1383: END IF;
1384:
1385: -- Check if API is called in debug mode. If yes, disable debug.
1386: --disable_debug;

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

1393: p_count => x_msg_count,
1394: p_data => x_msg_data );
1395:
1396: -- Debug info.
1397: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1399: p_msg_data=>x_msg_data,
1400: p_msg_type=>'UNEXPECTED ERROR',
1401: p_msg_level=>fnd_log.level_error);

Line 1401: p_msg_level=>fnd_log.level_error);

1397: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1399: p_msg_data=>x_msg_data,
1400: p_msg_type=>'UNEXPECTED ERROR',
1401: p_msg_level=>fnd_log.level_error);
1402: END IF;
1403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1404: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1405: p_prefix=>l_debug_prefix,

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

1399: p_msg_data=>x_msg_data,
1400: p_msg_type=>'UNEXPECTED ERROR',
1401: p_msg_level=>fnd_log.level_error);
1402: END IF;
1403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1404: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1405: p_prefix=>l_debug_prefix,
1406: p_msg_level=>fnd_log.level_procedure);
1407: END IF;

Line 1406: p_msg_level=>fnd_log.level_procedure);

1402: END IF;
1403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1404: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1405: p_prefix=>l_debug_prefix,
1406: p_msg_level=>fnd_log.level_procedure);
1407: END IF;
1408:
1409: -- Check if API is called in debug mode. If yes, disable debug.
1410: --disable_debug;

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

1421: p_count => x_msg_count,
1422: p_data => x_msg_data );
1423:
1424: -- Debug info.
1425: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1426: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1427: p_msg_data=>x_msg_data,
1428: p_msg_type=>'SQL ERROR',
1429: p_msg_level=>fnd_log.level_error);

Line 1429: p_msg_level=>fnd_log.level_error);

1425: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1426: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1427: p_msg_data=>x_msg_data,
1428: p_msg_type=>'SQL ERROR',
1429: p_msg_level=>fnd_log.level_error);
1430: END IF;
1431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1432: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1433: p_prefix=>l_debug_prefix,

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

1427: p_msg_data=>x_msg_data,
1428: p_msg_type=>'SQL ERROR',
1429: p_msg_level=>fnd_log.level_error);
1430: END IF;
1431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1432: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1433: p_prefix=>l_debug_prefix,
1434: p_msg_level=>fnd_log.level_procedure);
1435: END IF;

Line 1434: p_msg_level=>fnd_log.level_procedure);

1430: END IF;
1431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1432: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',
1433: p_prefix=>l_debug_prefix,
1434: p_msg_level=>fnd_log.level_procedure);
1435: END IF;
1436: -- Check if API is called in debug mode. If yes, disable debug.
1437: --disable_debug;
1438: