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_API

Line 143: x_return_status := fnd_api.g_ret_sts_error;

139: IF l_dummy <> 'Y' THEN
140: -- relationship type is not hierarchical, give error
141: FND_MESSAGE.SET_NAME('AR', 'HZ_NON_HIER_REL_TYPE');
142: FND_MSG_PUB.ADD;
143: x_return_status := fnd_api.g_ret_sts_error;
144: END IF;
145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN

Line 154: x_return_status := fnd_api.g_ret_sts_error;

150: FND_MESSAGE.SET_TOKEN('FK', 'hierarchy_type');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type');
152: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
153: FND_MSG_PUB.ADD;
154: x_return_status := fnd_api.g_ret_sts_error;
155: END;
156:
157: -----------------------------
158: -- validate parent_table_name

Line 174: x_return_status := fnd_api.g_ret_sts_error;

170: fnd_message.set_token('FK', 'parent_table_name');
171: fnd_message.set_token('COLUMN', 'obj_name');
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,

Line 203: x_return_status := fnd_api.g_ret_sts_error;

199: fnd_message.set_token('FK', 'parent_object_type');
200: fnd_message.set_token('COLUMN', 'instance_set_name');
201: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
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. ' ||

Line 232: x_return_status := fnd_api.g_ret_sts_error;

228: fnd_message.set_token('FK', 'child_table_name');
229: fnd_message.set_token('COLUMN', 'obj_name');
230: fnd_message.set_token('TABLE', 'fnd_objects');
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. ' ||

Line 262: x_return_status := fnd_api.g_ret_sts_error;

258: fnd_message.set_token('FK', 'child_object_type');
259: fnd_message.set_token('COLUMN', 'instance_set_name');
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,

Line 286: x_return_status := FND_API.G_RET_STS_ERROR;

282: FND_MESSAGE.SET_TOKEN( 'COLUMN','p_no_of_records');
283: FND_MESSAGE.SET_TOKEN( 'VALUE1', '1' );
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,

Line 307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

303: ----------------------------------
304: ----------------------------------
305:
306: PROCEDURE is_top_parent(
307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308: p_hierarchy_type IN VARCHAR2,
309: p_parent_id IN NUMBER,
310: p_parent_table_name IN VARCHAR2 := 'HZ_PARTIES',
311: p_parent_object_type IN VARCHAR2 := 'ORGANIZATION',

Line 348: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: --Initialize API return status to success.

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: --Initialize API return status to success.
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:
355: validate_input (
356: p_hierarchy_type => p_hierarchy_type,
357: p_parent_table_name => p_parent_table_name,

Line 363: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

359: p_no_of_records => 1,
360: x_return_status => x_return_status
361: );
362:
363: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: -- check whether it is a top parent in the given hierarchy

Line 364: RAISE FND_API.G_EXC_ERROR;

360: x_return_status => x_return_status
361: );
362:
363: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: -- check whether it is a top parent in the given hierarchy
368: OPEN c_top_in_hierarchy;

Line 391: p_encoded => FND_API.G_FALSE,

387: x_result := l_result;
388:
389: --Standard call to get message count and if count is 1, get message info.
390: FND_MSG_PUB.Count_And_Get(
391: p_encoded => FND_API.G_FALSE,
392: p_count => x_msg_count,
393: p_data => x_msg_data );
394:
395: -- Debug info.

Line 412: WHEN FND_API.G_EXC_ERROR THEN

408: -- Check if API is called in debug mode. If yes, disable debug.
409: --disable_debug;
410:
411: EXCEPTION
412: WHEN FND_API.G_EXC_ERROR THEN
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: x_result := 'N';
415:
416: FND_MSG_PUB.Count_And_Get(

Line 413: x_return_status := FND_API.G_RET_STS_ERROR;

409: --disable_debug;
410:
411: EXCEPTION
412: WHEN FND_API.G_EXC_ERROR THEN
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: x_result := 'N';
415:
416: FND_MSG_PUB.Count_And_Get(
417: p_encoded => FND_API.G_FALSE,

Line 417: p_encoded => FND_API.G_FALSE,

413: x_return_status := FND_API.G_RET_STS_ERROR;
414: x_result := 'N';
415:
416: FND_MSG_PUB.Count_And_Get(
417: p_encoded => FND_API.G_FALSE,
418: p_count => x_msg_count,
419: p_data => x_msg_data );
420:
421: -- Debug info.

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433:
434: -- Check if API is called in debug mode. If yes, disable debug.
435: --disable_debug;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: x_result := 'N';
440:
441: FND_MSG_PUB.Count_And_Get(

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: -- Check if API is called in debug mode. If yes, disable debug.
435: --disable_debug;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: x_result := 'N';
440:
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,

Line 442: p_encoded => FND_API.G_FALSE,

438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: x_result := 'N';
440:
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data );
445:
446: -- Debug info.

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459: -- Check if API is called in debug mode. If yes, disable debug.
460: --disable_debug;
461:
462: WHEN OTHERS THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: x_result := 'N';
465:
466: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
467: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

Line 471: p_encoded => FND_API.G_FALSE,

467: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
468: FND_MSG_PUB.ADD;
469:
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data );
474:
475: -- Debug info.

Line 495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

491: END is_top_parent;
492:
493:
494: PROCEDURE check_parent_child(
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_hierarchy_type IN VARCHAR2,
497: p_parent_id IN NUMBER,
498: p_parent_table_name IN VARCHAR2 := 'HZ_PARTIES',
499: p_parent_object_type IN VARCHAR2 := 'ORGANIZATION',

Line 528: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
529: FND_MSG_PUB.initialize;
530: END IF;
531:
532: --Initialize API return status to success.

Line 533: x_return_status := FND_API.G_RET_STS_SUCCESS;

529: FND_MSG_PUB.initialize;
530: END IF;
531:
532: --Initialize API return status to success.
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534:
535: validate_input (
536: p_hierarchy_type => p_hierarchy_type,
537: p_parent_table_name => p_parent_table_name,

Line 545: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

541: p_no_of_records => 1,
542: x_return_status => x_return_status
543: );
544:
545: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548:
549: BEGIN

Line 546: RAISE FND_API.G_EXC_ERROR;

542: x_return_status => x_return_status
543: );
544:
545: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548:
549: BEGIN
550: SELECT 'Y', LEVEL_NUMBER

Line 579: p_encoded => FND_API.G_FALSE,

575: END IF;
576:
577: --Standard call to get message count and if count is 1, get message info.
578: FND_MSG_PUB.Count_And_Get(
579: p_encoded => FND_API.G_FALSE,
580: p_count => x_msg_count,
581: p_data => x_msg_data );
582:
583: -- Debug info.

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596: -- Check if API is called in debug mode. If yes, disable debug.
597: --disable_debug;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: x_result := 'N';
603: x_level_number := -1;
604:

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: --disable_debug;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: x_result := 'N';
603: x_level_number := -1;
604:
605: FND_MSG_PUB.Count_And_Get(

Line 606: p_encoded => FND_API.G_FALSE,

602: x_result := 'N';
603: x_level_number := -1;
604:
605: FND_MSG_PUB.Count_And_Get(
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,
608: p_data => x_msg_data );
609:
610: -- Debug info.

Line 626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

622:
623: -- Check if API is called in debug mode. If yes, disable debug.
624: --disable_debug;
625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: x_result := 'N';
629: x_level_number := -1;
630:

Line 627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

623: -- Check if API is called in debug mode. If yes, disable debug.
624: --disable_debug;
625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: x_result := 'N';
629: x_level_number := -1;
630:
631: FND_MSG_PUB.Count_And_Get(

Line 632: p_encoded => FND_API.G_FALSE,

628: x_result := 'N';
629: x_level_number := -1;
630:
631: FND_MSG_PUB.Count_And_Get(
632: p_encoded => FND_API.G_FALSE,
633: p_count => x_msg_count,
634: p_data => x_msg_data );
635:
636: -- Debug info.

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: -- Check if API is called in debug mode. If yes, disable debug.
650: --disable_debug;
651:
652: WHEN OTHERS THEN
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: x_result := 'N';
655: x_level_number := -1;
656:
657: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

Line 662: p_encoded => FND_API.G_FALSE,

658: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
659: FND_MSG_PUB.ADD;
660:
661: FND_MSG_PUB.Count_And_Get(
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data );
665:
666: -- Debug info.

Line 685: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

681:
682: END check_parent_child;
683:
684: PROCEDURE get_parent_nodes(
685: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
686: p_hierarchy_type IN VARCHAR2,
687: p_child_id IN NUMBER,
688: p_child_table_name IN VARCHAR2,
689: p_child_object_type IN VARCHAR2,

Line 757: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
758: FND_MSG_PUB.initialize;
759: END IF;
760:
761: --Initialize API return status to success.

Line 762: x_return_status := FND_API.G_RET_STS_SUCCESS;

758: FND_MSG_PUB.initialize;
759: END IF;
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',

Line 792: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

788: p_no_of_records => p_no_of_records,
789: x_return_status => x_return_status
790: );
791:
792: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795:
796: OPEN c1;

Line 793: RAISE FND_API.G_EXC_ERROR;

789: x_return_status => x_return_status
790: );
791:
792: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795:
796: OPEN c1;
797:

Line 826: p_encoded => FND_API.G_FALSE,

822: CLOSE c1;
823:
824: --Standard call to get message count and if count is 1, get message info.
825: FND_MSG_PUB.Count_And_Get(
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data );
829:
830: -- Debug info.

Line 847: WHEN FND_API.G_EXC_ERROR THEN

843: -- Check if API is called in debug mode. If yes, disable debug.
844: --disable_debug;
845:
846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: x_return_status := FND_API.G_RET_STS_ERROR;
849:
850: FND_MSG_PUB.Count_And_Get(
851: p_encoded => FND_API.G_FALSE,

Line 848: x_return_status := FND_API.G_RET_STS_ERROR;

844: --disable_debug;
845:
846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: x_return_status := FND_API.G_RET_STS_ERROR;
849:
850: FND_MSG_PUB.Count_And_Get(
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,

Line 851: p_encoded => FND_API.G_FALSE,

847: WHEN FND_API.G_EXC_ERROR THEN
848: x_return_status := FND_API.G_RET_STS_ERROR;
849:
850: FND_MSG_PUB.Count_And_Get(
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data );
854:
855: -- Debug info.

Line 871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

867:
868: -- Check if API is called in debug mode. If yes, disable debug.
869: --disable_debug;
870:
871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: FND_MSG_PUB.Count_And_Get(
875: p_encoded => FND_API.G_FALSE,

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

868: -- Check if API is called in debug mode. If yes, disable debug.
869: --disable_debug;
870:
871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: FND_MSG_PUB.Count_And_Get(
875: p_encoded => FND_API.G_FALSE,
876: p_count => x_msg_count,

Line 875: p_encoded => FND_API.G_FALSE,

871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: FND_MSG_PUB.Count_And_Get(
875: p_encoded => FND_API.G_FALSE,
876: p_count => x_msg_count,
877: p_data => x_msg_data );
878:
879: -- Debug info.

Line 896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

892: -- Check if API is called in debug mode. If yes, disable debug.
893: --disable_debug;
894:
895: WHEN OTHERS THEN
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897:
898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
899: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
900: FND_MSG_PUB.ADD;

Line 903: p_encoded => FND_API.G_FALSE,

899: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
900: FND_MSG_PUB.ADD;
901:
902: FND_MSG_PUB.Count_And_Get(
903: p_encoded => FND_API.G_FALSE,
904: p_count => x_msg_count,
905: p_data => x_msg_data );
906:
907: -- Debug info.

Line 927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

923: END get_parent_nodes;
924:
925:
926: PROCEDURE get_child_nodes(
927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
928: p_hierarchy_type IN VARCHAR2,
929: p_parent_id IN NUMBER,
930: p_parent_table_name IN VARCHAR2,
931: p_parent_object_type IN VARCHAR2,

Line 998: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
999: FND_MSG_PUB.initialize;
1000: END IF;
1001:
1002: --Initialize API return status to success.

Line 1003: x_return_status := FND_API.G_RET_STS_SUCCESS;

999: FND_MSG_PUB.initialize;
1000: END IF;
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',

Line 1033: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1029: p_no_of_records => p_no_of_records,
1030: x_return_status => x_return_status
1031: );
1032:
1033: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036:
1037: OPEN c1;

Line 1034: RAISE FND_API.G_EXC_ERROR;

1030: x_return_status => x_return_status
1031: );
1032:
1033: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036:
1037: OPEN c1;
1038:

Line 1067: p_encoded => FND_API.G_FALSE,

1063: CLOSE c1;
1064:
1065: --Standard call to get message count and if count is 1, get message info.
1066: FND_MSG_PUB.Count_And_Get(
1067: p_encoded => FND_API.G_FALSE,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data );
1070:
1071: -- Debug info.

Line 1088: WHEN FND_API.G_EXC_ERROR THEN

1084: -- Check if API is called in debug mode. If yes, disable debug.
1085: --disable_debug;
1086:
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090:
1091: FND_MSG_PUB.Count_And_Get(
1092: p_encoded => FND_API.G_FALSE,

Line 1089: x_return_status := FND_API.G_RET_STS_ERROR;

1085: --disable_debug;
1086:
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090:
1091: FND_MSG_PUB.Count_And_Get(
1092: p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,

Line 1092: p_encoded => FND_API.G_FALSE,

1088: WHEN FND_API.G_EXC_ERROR THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090:
1091: FND_MSG_PUB.Count_And_Get(
1092: p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,
1094: p_data => x_msg_data );
1095:
1096: -- Debug info.

Line 1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1108:
1109: -- Check if API is called in debug mode. If yes, disable debug.
1110: --disable_debug;
1111:
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1114:
1115: FND_MSG_PUB.Count_And_Get(
1116: p_encoded => FND_API.G_FALSE,

Line 1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1109: -- Check if API is called in debug mode. If yes, disable debug.
1110: --disable_debug;
1111:
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1114:
1115: FND_MSG_PUB.Count_And_Get(
1116: p_encoded => FND_API.G_FALSE,
1117: p_count => x_msg_count,

Line 1116: p_encoded => FND_API.G_FALSE,

1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1114:
1115: FND_MSG_PUB.Count_And_Get(
1116: p_encoded => FND_API.G_FALSE,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data );
1119:
1120: -- Debug info.

Line 1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1133: -- Check if API is called in debug mode. If yes, disable debug.
1134: --disable_debug;
1135:
1136: WHEN OTHERS THEN
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138:
1139: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1140: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1141: FND_MSG_PUB.ADD;

Line 1144: p_encoded => FND_API.G_FALSE,

1140: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1141: FND_MSG_PUB.ADD;
1142:
1143: FND_MSG_PUB.Count_And_Get(
1144: p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data );
1147:
1148: -- Debug info.

Line 1167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1163:
1164: END get_child_nodes;
1165:
1166: PROCEDURE get_top_parent_nodes(
1167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1168: p_hierarchy_type IN VARCHAR2,
1169: p_parent_table_name IN VARCHAR2 := 'HZ_PARTIES',
1170: p_parent_object_type IN VARCHAR2 := 'ALL',
1171: p_effective_date IN DATE := SYSDATE,

Line 1256: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260: --Initialize API return status to success.

Line 1261: x_return_status := FND_API.G_RET_STS_SUCCESS;

1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260: --Initialize API return status to success.
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: validate_input (
1264: p_hierarchy_type => p_hierarchy_type,
1265: p_parent_table_name => p_parent_table_name,

Line 1271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1267: p_no_of_records => p_no_of_records,
1268: x_return_status => x_return_status
1269: );
1270:
1271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274:
1275: OPEN c2;

Line 1272: RAISE FND_API.G_EXC_ERROR;

1268: x_return_status => x_return_status
1269: );
1270:
1271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274:
1275: OPEN c2;
1276:

Line 1343: p_encoded => FND_API.G_FALSE,

1339: END IF;
1340:
1341: --Standard call to get message count and if count is 1, get message info.
1342: FND_MSG_PUB.Count_And_Get(
1343: p_encoded => FND_API.G_FALSE,
1344: p_count => x_msg_count,
1345: p_data => x_msg_data );
1346:
1347: -- Debug info.

Line 1364: WHEN FND_API.G_EXC_ERROR THEN

1360: -- Check if API is called in debug mode. If yes, disable debug.
1361: --disable_debug;
1362:
1363: EXCEPTION
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366:
1367: FND_MSG_PUB.Count_And_Get(
1368: p_encoded => FND_API.G_FALSE,

Line 1365: x_return_status := FND_API.G_RET_STS_ERROR;

1361: --disable_debug;
1362:
1363: EXCEPTION
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366:
1367: FND_MSG_PUB.Count_And_Get(
1368: p_encoded => FND_API.G_FALSE,
1369: p_count => x_msg_count,

Line 1368: p_encoded => FND_API.G_FALSE,

1364: WHEN FND_API.G_EXC_ERROR THEN
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366:
1367: FND_MSG_PUB.Count_And_Get(
1368: p_encoded => FND_API.G_FALSE,
1369: p_count => x_msg_count,
1370: p_data => x_msg_data );
1371:
1372: -- Debug info.

Line 1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1384:
1385: -- Check if API is called in debug mode. If yes, disable debug.
1386: --disable_debug;
1387:
1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390:
1391: FND_MSG_PUB.Count_And_Get(
1392: p_encoded => FND_API.G_FALSE,

Line 1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1385: -- Check if API is called in debug mode. If yes, disable debug.
1386: --disable_debug;
1387:
1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390:
1391: FND_MSG_PUB.Count_And_Get(
1392: p_encoded => FND_API.G_FALSE,
1393: p_count => x_msg_count,

Line 1392: p_encoded => FND_API.G_FALSE,

1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390:
1391: FND_MSG_PUB.Count_And_Get(
1392: p_encoded => FND_API.G_FALSE,
1393: p_count => x_msg_count,
1394: p_data => x_msg_data );
1395:
1396: -- Debug info.

Line 1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1409: -- Check if API is called in debug mode. If yes, disable debug.
1410: --disable_debug;
1411:
1412: WHEN OTHERS THEN
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414:
1415: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1416: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1417: FND_MSG_PUB.ADD;

Line 1420: p_encoded => FND_API.G_FALSE,

1416: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1417: FND_MSG_PUB.ADD;
1418:
1419: FND_MSG_PUB.Count_And_Get(
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data );
1423:
1424: -- Debug info.