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.RRS_HIERARCHY_INFO dependencies on FND_MESSAGE

Line 44: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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;
48: END;

Line 94: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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;
98: END;

Line 135: fnd_message.set_name('RRS', 'RRS_NO_HIER_FOUND');

131:
132:
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;

Line 136: fnd_message.set_token('HIERARCHY_NAME', p_hier_name);

132:
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

Line 142: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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;
146: END;

Line 209: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');

205: WHERE NODE_IDENTIFICATION_NUMBER = p_parent_member_id_num;
206: END IF;
207:
208: IF l_parent_id IS NULL THEN
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;

Line 210: fnd_message.set_token('PARENT_TYPE', p_parent_member_type);

206: END IF;
207:
208: IF l_parent_id IS NULL THEN
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;

Line 211: fnd_message.set_token('PARENT_ID_NUM', p_parent_member_id_num);

207:
208: IF l_parent_id IS NULL THEN
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;

Line 212: fnd_message.set_token('HIERARCHY_NAME', p_hier_version_id);

208: IF l_parent_id IS NULL THEN
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;

Line 219: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');

215: x_return_status := G_RET_STS_ERROR;
216: END IF;
217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN
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;

Line 220: fnd_message.set_token('PARENT_TYPE', p_parent_member_type);

216: END IF;
217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN
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;

Line 221: fnd_message.set_token('PARENT_ID_NUM', p_parent_member_id_num);

217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN
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;

Line 222: fnd_message.set_token('HIERARCHY_NAME', p_hier_version_id);

218: WHEN NO_DATA_FOUND THEN
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;

Line 228: fnd_message.set_name('RRS', 'RRS_MISS_PARENT_TYPE_OR_ID_NUM');

224: x_msg_count := x_msg_count + 1;
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;

Line 295: fnd_message.set_name('RRS', 'RRS_HIER_NO_CHILD_MBR_FOUND');

291: CONNECT BY PRIOR CHILD_MEMBER_ID = PARENT_MEMBER_ID AND SiteGroupMembers.SITE_GROUP_ID = l_site_group_id AND SiteGroupMembers.SITE_GROUP_VERSION_ID = p_hier_version_id
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;

Line 310: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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

Line 391: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');

387: ,x_msg_data => x_msg_data);
388:
389: EXCEPTION
390: WHEN e_no_parent_member_found THEN
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;

Line 392: fnd_message.set_token('PARENT_TYPE', p_parent_member_type);

388:
389: EXCEPTION
390: WHEN e_no_parent_member_found THEN
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;

Line 393: fnd_message.set_token('PARENT_ID_NUM', p_parent_member_id_num);

389: EXCEPTION
390: WHEN e_no_parent_member_found THEN
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;

Line 394: fnd_message.set_token('HIERARCHY_NAME', p_hier_id);

390: WHEN e_no_parent_member_found THEN
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:

Line 401: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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

Line 479: fnd_message.set_name('RRS', 'RRS_NO_HIER_FOUND');

475:
476:
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;

Line 480: fnd_message.set_token('HIERARCHY_NAME', p_hier_name);

476:
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

Line 485: fnd_message.set_name('RRS', 'RRS_HIER_NO_PARENT_MBR_FOUND');

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

Line 486: fnd_message.set_token('PARENT_TYPE', p_parent_member_type);

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

Line 487: fnd_message.set_token('PARENT_ID_NUM', p_parent_member_id_num);

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

Line 488: fnd_message.set_token('HIERARCHY_NAME', p_hier_name);

484: WHEN e_no_parent_member_found THEN
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

Line 494: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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

Line 556: fnd_message.set_name('RRS', 'RRS_NO_HIER_FOUND');

552: WHERE RSG.SITE_GROUP_ID = RSGV.SITE_GROUP_ID
553: AND RSGV.SITE_GROUP_VERSION_ID = p_hier_version_id;
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;

Line 557: fnd_message.set_token('HIERARCHY_NAME', p_hier_version_id);

553: AND RSGV.SITE_GROUP_VERSION_ID = p_hier_version_id;
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;

Line 603: fnd_message.set_name('RRS', 'RRS_NO_PAGE_FOUND');

599: ORDER BY SEQUENCE;
600:
601: EXCEPTION
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;

Line 604: fnd_message.set_token('PAGE_NAME', p_page_name);

600:
601: EXCEPTION
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;

Line 605: fnd_message.set_token('CLASSIFICATION_CODE', l_group_purpose_code);

601: EXCEPTION
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;

Line 630: fnd_message.set_name('RRS', 'RRS_NO_PAGE_ENTRY_FOUND');

626:
627: EXCEPTION
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;

Line 631: fnd_message.set_token('PAGE_NAME', p_page_name);

627: EXCEPTION
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;

Line 725: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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

Line 775: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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;
779: END;

Line 823: fnd_message.set_name('RRS', 'RRS_NO_HIER_FOUND');

819: ,x_msg_data => x_msg_data);
820:
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;

Line 824: fnd_message.set_token('HIERARCHY_NAME', p_hier_name);

820:
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

Line 830: fnd_message.set_name('RRS', 'RRS_UNEXPECTED_ERROR');

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