DBA Data[Home] [Help]

APPS.RRS_HIERARCHY_INFO dependencies on FND_MSG_PUB

Line 45: fnd_msg_pub.add;

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:

Line 95: fnd_msg_pub.add;

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:

Line 137: fnd_msg_pub.add;

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;

Line 143: fnd_msg_pub.add;

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:

Line 213: fnd_msg_pub.add;

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

Line 223: fnd_msg_pub.add;

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

Line 229: fnd_msg_pub.add;

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:

Line 296: fnd_msg_pub.add;

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:

Line 311: fnd_msg_pub.add;

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;

Line 395: fnd_msg_pub.add;

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

Line 402: fnd_msg_pub.add;

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;

Line 481: fnd_msg_pub.add;

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

Line 489: fnd_msg_pub.add;

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;

Line 495: fnd_msg_pub.add;

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;

Line 558: fnd_msg_pub.add;

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:

Line 606: fnd_msg_pub.add;

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:

Line 632: fnd_msg_pub.add;

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:

Line 726: fnd_msg_pub.add;

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;

Line 776: fnd_msg_pub.add;

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:

Line 825: fnd_msg_pub.add;

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;

Line 831: fnd_msg_pub.add;

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;