DBA Data[Home] [Help]

APPS.RRS_HIERARCHY_INFO dependencies on RRS_HIERARCHY_INFO

Line 1: PACKAGE BODY RRS_HIERARCHY_INFO as

1: PACKAGE BODY RRS_HIERARCHY_INFO as
2: /* $Header: RRSGHDTB.pls 120.5 2011/03/03 21:47:38 sunarang noship $ */
3: ------------------------
4: --Get Hierarchy Header--
5: ------------------------

Line 43: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Header: ' || dbms_utility.format_error_backtrace;

39: x_return_status := G_RET_STS_SUCCESS;
40:
41: EXCEPTION
42: WHEN OTHERS THEN
43: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Header: ' || dbms_utility.format_error_backtrace;
44: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
45: fnd_msg_pub.add;
46: x_msg_count := x_msg_count + 1;
47: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 93: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Header: ' || dbms_utility.format_error_backtrace;

89: ,x_msg_count => x_msg_count
90: ,x_msg_data => x_msg_data);
91: EXCEPTION
92: WHEN OTHERS THEN
93: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Header: ' || dbms_utility.format_error_backtrace;
94: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
95: fnd_msg_pub.add;
96: x_msg_count := x_msg_count + 1;
97: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 141: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Header: ' || dbms_utility.format_error_backtrace;

137: fnd_msg_pub.add;
138: x_msg_count := x_msg_count + 1;
139: x_return_status := G_RET_STS_ERROR;
140: WHEN OTHERS THEN
141: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Header: ' || dbms_utility.format_error_backtrace;
142: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
143: fnd_msg_pub.add;
144: x_msg_count := x_msg_count + 1;
145: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 309: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Members: ' || dbms_utility.format_error_backtrace;

305: END IF;
306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Members: ' || dbms_utility.format_error_backtrace;
310: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
311: fnd_msg_pub.add;
312: x_msg_count := x_msg_count + 1;
313: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 400: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Members: ' || dbms_utility.format_error_backtrace;

396: x_msg_count := x_msg_count + 1;
397: x_return_status := G_RET_STS_ERROR;
398:
399: WHEN OTHERS THEN
400: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Members: ' || dbms_utility.format_error_backtrace;
401: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
402: fnd_msg_pub.add;
403: x_msg_count := x_msg_count + 1;
404: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 493: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Members: ' || dbms_utility.format_error_backtrace;

489: fnd_msg_pub.add;
490: x_msg_count := x_msg_count + 1;
491: x_return_status := G_RET_STS_ERROR;
492: WHEN OTHERS THEN
493: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Members: ' || dbms_utility.format_error_backtrace;
494: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
495: fnd_msg_pub.add;
496: x_msg_count := x_msg_count + 1;
497: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 724: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Attributes: ' || dbms_utility.format_error_backtrace;

720:
721:
722: EXCEPTION
723: WHEN OTHERS THEN
724: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Attributes: ' || dbms_utility.format_error_backtrace;
725: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
726: fnd_msg_pub.add;
727: x_msg_count := x_msg_count + 1;
728: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 774: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Attributes: ' || dbms_utility.format_error_backtrace;

770: ,x_msg_count => x_msg_count
771: ,x_msg_data => x_msg_data);
772: EXCEPTION
773: WHEN OTHERS THEN
774: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Attributes: ' || dbms_utility.format_error_backtrace;
775: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
776: fnd_msg_pub.add;
777: x_msg_count := x_msg_count + 1;
778: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 829: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Attributes: ' || dbms_utility.format_error_backtrace;

825: fnd_msg_pub.add;
826: x_msg_count := x_msg_count + 1;
827: x_return_status := G_RET_STS_ERROR;
828: WHEN OTHERS THEN
829: x_msg_data := 'RRS_HIERARCHY_INFO.Get_Hierarchy_Attributes: ' || dbms_utility.format_error_backtrace;
830: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');
831: fnd_msg_pub.add;
832: x_msg_count := x_msg_count + 1;
833: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1002: RRS_HIERARCHY_INFO.Get_Hierarchy_Header(p_api_version => '1.0'

998: x_error_msg varchar2(200);
999:
1000: BEGIN
1001:
1002: RRS_HIERARCHY_INFO.Get_Hierarchy_Header(p_api_version => '1.0'
1003: ,p_hier_name => 'Unit Hierarchy'
1004: ,x_hier_header_rec => x_hier_header_rec
1005: ,x_return_status => x_return_status
1006: ,x_msg_count => x_error_msg_count

Line 1039: RRS_HIERARCHY_INFO.Get_Hierarchy_Members(

1035: x_error_msg_count number;
1036: x_error_msg varchar2(200);
1037:
1038: BEGIN
1039: RRS_HIERARCHY_INFO.Get_Hierarchy_Members(
1040: p_api_version => '1.0'
1041: ,p_hier_name => 'WS Hierarchy1'
1042: ,p_hier_version_number => NULL
1043: ,p_parent_member_type => 'NODE'

Line 1101: RRS_HIERARCHY_INFO.Get_Hierarchy_Attributes(

1097: data_index number;
1098:
1099: BEGIN
1100:
1101: RRS_HIERARCHY_INFO.Get_Hierarchy_Attributes(
1102: p_api_version => 1.0
1103: ,p_hier_name => 'Unit Hierarchy'
1104: ,p_hier_version_number => NULL
1105: ,p_page_name => 'Hierarchy UDA Page Sample'

Line 1164: RRS_HIERARCHY_INFO.Get_Complete_Hierarchy_Details(

1160: x_error_msg_count number;
1161: x_error_msg varchar2(200);
1162:
1163: BEGIN
1164: RRS_HIERARCHY_INFO.Get_Complete_Hierarchy_Details(
1165: p_api_version => 1.0
1166: ,p_hier_name => 'Unit Hierarchy'
1167: ,p_hier_version_number => 1
1168: ,p_page_name => NULL

Line 1261: END RRS_HIERARCHY_INFO;

1257: END IF;
1258: END;*/
1259:
1260:
1261: END RRS_HIERARCHY_INFO;