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 HZ_UTILITY_V2PUB

Line 48: * HZ_UTILITY_V2PUB.enable_debug

44: * DESCRIPTION
45: * Turn on debug mode.
46: *
47: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
48: * HZ_UTILITY_V2PUB.enable_debug
49: *
50: * MODIFICATION HISTORY
51: *
52: * 31-Oct-2001 Anupam Bordia o Created.

Line 63: HZ_UTILITY_V2PUB.enable_debug;

59:
60: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
61: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
62: THEN
63: HZ_UTILITY_V2PUB.enable_debug;
64: G_DEBUG := TRUE;
65: END IF;
66:
67: END enable_debug;

Line 77: * HZ_UTILITY_V2PUB.disable_debug

73: * DESCRIPTION
74: * Turn off debug mode.
75: *
76: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
77: * HZ_UTILITY_V2PUB.disable_debug
78: *
79: * MODIFICATION HISTORY
80: *
81: * 31-Oct-2001 Anupam Bordia o Created.

Line 90: HZ_UTILITY_V2PUB.disable_debug;

86:
87: BEGIN
88:
89: IF G_DEBUG THEN
90: HZ_UTILITY_V2PUB.disable_debug;
91: G_DEBUG := FALSE;
92: END IF;
93:
94: END disable_debug;

Line 177: hz_utility_v2pub.debug(p_message=>'parent_table_name has foreign key fnd_objects.obj_name. ' ||

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);
181: END IF;

Line 207: hz_utility_v2pub.debug(p_message=>'parent_object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

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);
211: END IF;

Line 236: hz_utility_v2pub.debug(p_message=>'child_table_name has foreign key fnd_objects.obj_name. ' ||

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);
240: END IF;

Line 265: hz_utility_v2pub.debug(p_message=>'child_object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

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);
269: END IF;

Line 289: hz_utility_v2pub.debug(p_message=>'p_no_of_records should be between 1 and 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);
293: END IF;

Line 342: hz_utility_v2pub.debug(p_message=>'is_top_parent (+)',

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;
346:

Line 377: l_incl_unrelated := HZ_UTILITY_V2PUB.incl_unrelated_entities(p_hierarchy_type);

373: -- provided hierarchy_type is set up with incl_unrelated_entities = 'Y' and
374: -- the parent is a valid entity of the subject type
375:
376: IF l_result = 'N' THEN
377: l_incl_unrelated := HZ_UTILITY_V2PUB.incl_unrelated_entities(p_hierarchy_type);
378: IF l_incl_unrelated = 'Y' THEN
379: -- include the entity if it is valid
380: l_result := HZ_RELATIONSHIP_TYPE_V2PUB.in_instance_sets
381: (p_parent_object_type,

Line 397: hz_utility_v2pub.debug_return_messages(p_msg_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);
401: END IF;

Line 403: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',

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;
407:

Line 423: hz_utility_v2pub.debug_return_messages(p_msg_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);
427: END IF;

Line 429: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',

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;
433:

Line 448: hz_utility_v2pub.debug_return_messages(p_msg_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);
452: END IF;

Line 454: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',

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;
458:

Line 477: hz_utility_v2pub.debug_return_messages(p_msg_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);
481: END IF;

Line 483: hz_utility_v2pub.debug(p_message=>'is_top_parent (-)',

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;
487:

Line 522: hz_utility_v2pub.debug(p_message=>'check_parent_child (+)',

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;
526:

Line 585: hz_utility_v2pub.debug_return_messages(p_msg_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);
589: END IF;

Line 591: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',

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;
595:

Line 612: hz_utility_v2pub.debug_return_messages(p_msg_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);
616: END IF;

Line 618: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',

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;
622:

Line 638: hz_utility_v2pub.debug_return_messages(p_msg_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);
642: END IF;

Line 644: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',

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;
648:

Line 668: hz_utility_v2pub.debug_return_messages(p_msg_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);
672: END IF;

Line 674: hz_utility_v2pub.debug(p_message=>'check_parent_child (-)',

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;
678:

Line 751: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (+)',

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;
755:

Line 764: HZ_UTILITY_V2PUB.validate_mandatory (

760:
761: --Initialize API return status to success.
762: x_return_status := FND_API.G_RET_STS_SUCCESS;
763:
764: HZ_UTILITY_V2PUB.validate_mandatory (
765: p_create_update_flag => 'C',
766: p_column => 'p_child_id',
767: p_column_value => p_child_id,
768: x_return_status => x_return_status);

Line 770: HZ_UTILITY_V2PUB.validate_mandatory (

766: p_column => 'p_child_id',
767: p_column_value => p_child_id,
768: x_return_status => x_return_status);
769:
770: HZ_UTILITY_V2PUB.validate_mandatory (
771: p_create_update_flag => 'C',
772: p_column => 'p_child_table_name',
773: p_column_value => p_child_table_name,
774: x_return_status => x_return_status);

Line 776: HZ_UTILITY_V2PUB.validate_mandatory (

772: p_column => 'p_child_table_name',
773: p_column_value => p_child_table_name,
774: x_return_status => x_return_status);
775:
776: HZ_UTILITY_V2PUB.validate_mandatory (
777: p_create_update_flag => 'C',
778: p_column => 'p_child_object_type',
779: p_column_value => p_child_object_type,
780: x_return_status => x_return_status);

Line 832: hz_utility_v2pub.debug_return_messages(p_msg_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);
836: END IF;

Line 838: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',

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;
842:

Line 857: hz_utility_v2pub.debug_return_messages(p_msg_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);
861: END IF;

Line 863: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',

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;
867:

Line 881: hz_utility_v2pub.debug_return_messages(p_msg_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);
885: END IF;

Line 887: hz_utility_v2pub.debug(p_message=> 'get_parent_nodes (-)' ,

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;
891:

Line 909: hz_utility_v2pub.debug_return_messages(p_msg_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);
913: END IF;

Line 915: hz_utility_v2pub.debug(p_message=>'get_parent_nodes (-)',

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;
919:

Line 992: hz_utility_v2pub.debug(p_message=>'get_child_nodes (+)',

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;
996:

Line 1005: HZ_UTILITY_V2PUB.validate_mandatory (

1001:
1002: --Initialize API return status to success.
1003: x_return_status := FND_API.G_RET_STS_SUCCESS;
1004:
1005: HZ_UTILITY_V2PUB.validate_mandatory (
1006: p_create_update_flag => 'C',
1007: p_column => 'p_parent_id',
1008: p_column_value => p_parent_id,
1009: x_return_status => x_return_status);

Line 1011: HZ_UTILITY_V2PUB.validate_mandatory (

1007: p_column => 'p_parent_id',
1008: p_column_value => p_parent_id,
1009: x_return_status => x_return_status);
1010:
1011: HZ_UTILITY_V2PUB.validate_mandatory (
1012: p_create_update_flag => 'C',
1013: p_column => 'p_parent_table_name',
1014: p_column_value => p_parent_table_name,
1015: x_return_status => x_return_status);

Line 1017: HZ_UTILITY_V2PUB.validate_mandatory (

1013: p_column => 'p_parent_table_name',
1014: p_column_value => p_parent_table_name,
1015: x_return_status => x_return_status);
1016:
1017: HZ_UTILITY_V2PUB.validate_mandatory (
1018: p_create_update_flag => 'C',
1019: p_column => 'p_parent_object_type',
1020: p_column_value => p_parent_object_type,
1021: x_return_status => x_return_status);

Line 1073: hz_utility_v2pub.debug_return_messages(p_msg_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);
1077: END IF;

Line 1079: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',

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;
1083:

Line 1098: hz_utility_v2pub.debug_return_messages(p_msg_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);
1102: END IF;

Line 1104: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',

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;
1108:

Line 1122: hz_utility_v2pub.debug_return_messages(p_msg_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);
1126: END IF;

Line 1128: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',

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;
1132:

Line 1150: hz_utility_v2pub.debug_return_messages(p_msg_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);
1154: END IF;

Line 1156: hz_utility_v2pub.debug(p_message=>'get_child_nodes (-)',

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;
1160:

Line 1250: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (+)',

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;
1254:

Line 1304: l_incl_unrelated_entities := HZ_UTILITY_V2PUB.incl_unrelated_entities(p_hierarchy_type);

1300: l_count := i;
1301: END LOOP;
1302:
1303: -- now check if the relationship type tells to include unrelated entities
1304: l_incl_unrelated_entities := HZ_UTILITY_V2PUB.incl_unrelated_entities(p_hierarchy_type);
1305:
1306: IF l_incl_unrelated_entities = 'Y' THEN
1307: IF l_count < 100 THEN
1308: l_limit := l_limit - l_count;

Line 1349: hz_utility_v2pub.debug_return_messages(p_msg_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);
1353: END IF;

Line 1355: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',

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;
1359:

Line 1374: hz_utility_v2pub.debug_return_messages(p_msg_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);
1378: END IF;

Line 1380: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',

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;
1384:

Line 1398: hz_utility_v2pub.debug_return_messages(p_msg_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);
1402: END IF;

Line 1404: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',

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;
1408:

Line 1426: hz_utility_v2pub.debug_return_messages(p_msg_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);
1430: END IF;

Line 1432: hz_utility_v2pub.debug(p_message=>'get_top_parent_nodes (-)',

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;
1436: -- Check if API is called in debug mode. If yes, disable debug.