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;
48: END;
49:
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;
98: END;
99:
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: fnd_message.set_name('RRS', 'RRS_NO_HIER_FOUND');
136: fnd_message.set_token('HIERARCHY_NAME', p_hier_name);
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;
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;
146: END;
147:
209: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');
210: fnd_message.set_token('PARENT_TYPE', p_parent_member_type);
211: fnd_message.set_token('PARENT_ID_NUM', p_parent_member_id_num);
212: fnd_message.set_token('HIERARCHY_NAME', p_hier_version_id);
213: fnd_msg_pub.add;
214: x_msg_count := x_msg_count + 1;
215: x_return_status := G_RET_STS_ERROR;
216: END IF;
217: EXCEPTION
219: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');
220: fnd_message.set_token('PARENT_TYPE', p_parent_member_type);
221: fnd_message.set_token('PARENT_ID_NUM', p_parent_member_id_num);
222: fnd_message.set_token('HIERARCHY_NAME', p_hier_version_id);
223: fnd_msg_pub.add;
224: x_msg_count := x_msg_count + 1;
225: x_return_status := G_RET_STS_ERROR;
226: END;
227: ELSE
225: x_return_status := G_RET_STS_ERROR;
226: END;
227: ELSE
228: fnd_message.set_name('RRS', 'RRS_MISS_PARENT_TYPE_OR_ID_NUM');
229: fnd_msg_pub.add;
230: x_msg_count := x_msg_count + 1;
231: x_return_status := G_RET_STS_ERROR;
232: END IF;
233:
292: ORDER SIBLINGS BY SEQUENCE_NUMBER;
293:
294: IF x_hier_members_tab IS NULL OR x_hier_members_tab.count = 0 THEN
295: fnd_message.set_name('RRS', 'RRS_HIER_NO_CHILD_MBR_FOUND');
296: fnd_msg_pub.add;
297: x_msg_count := x_msg_count + 1;
298: x_return_status := G_RET_STS_ERROR;
299: END IF;
300:
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;
314:
315: END;
391: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');
392: fnd_message.set_token('PARENT_TYPE', p_parent_member_type);
393: fnd_message.set_token('PARENT_ID_NUM', p_parent_member_id_num);
394: fnd_message.set_token('HIERARCHY_NAME', p_hier_id);
395: fnd_msg_pub.add;
396: x_msg_count := x_msg_count + 1;
397: x_return_status := G_RET_STS_ERROR;
398:
399: WHEN OTHERS THEN
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;
405:
406: END;
477: EXCEPTION
478: WHEN e_no_hierarchy_found THEN
479: fnd_message.set_name('RRS', 'RRS_NO_HIER_FOUND');
480: fnd_message.set_token('HIERARCHY_NAME', p_hier_name);
481: fnd_msg_pub.add;
482: x_msg_count := x_msg_count + 1;
483: x_return_status := G_RET_STS_ERROR;
484: WHEN e_no_parent_member_found THEN
485: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');
485: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');
486: fnd_message.set_token('PARENT_TYPE', p_parent_member_type);
487: fnd_message.set_token('PARENT_ID_NUM', p_parent_member_id_num);
488: fnd_message.set_token('HIERARCHY_NAME', p_hier_name);
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;
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;
498:
499: END;
554: EXCEPTION
555: WHEN NO_DATA_FOUND THEN
556: fnd_message.set_name('RRS', 'RRS_NO_HIER_FOUND');
557: fnd_message.set_token('HIERARCHY_NAME', p_hier_version_id);
558: fnd_msg_pub.add;
559: x_msg_count := x_msg_count + 1;
560: x_return_status := G_RET_STS_ERROR;
561: END;
562:
602: WHEN NO_DATA_FOUND THEN
603: fnd_message.set_name('RRS', 'RRS_NO_PAGE_FOUND');
604: fnd_message.set_token('PAGE_NAME', p_page_name);
605: fnd_message.set_token('CLASSIFICATION_CODE', l_group_purpose_code);
606: fnd_msg_pub.add;
607: x_msg_count := x_msg_count + 1;
608: x_return_status := G_RET_STS_ERROR;
609: END;
610:
628:
629: WHEN NO_DATA_FOUND THEN
630: fnd_message.set_name('RRS', 'RRS_NO_PAGE_ENTRY_FOUND');
631: fnd_message.set_token('PAGE_NAME', p_page_name);
632: fnd_msg_pub.add;
633: x_msg_count := x_msg_count + 1;
634: x_return_status := G_RET_STS_ERROR;
635: END;
636:
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;
729:
730: END;
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;
779: END;
780:
821: EXCEPTION
822: WHEN e_no_hierarchy_found THEN
823: fnd_message.set_name('RRS', 'RRS_NO_HIER_FOUND');
824: fnd_message.set_token('HIERARCHY_NAME', p_hier_name);
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;
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;
834:
835: END;