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