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_CRUD_PKG dependencies on FND_MESSAGE

Line 33: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_FLAG');

29:
30: IF p_nullify_flag <> FND_API.G_FALSE
31: AND p_nullify_flag <> FND_API.G_TRUE THEN
32: --RRS_INVALID_FLAG
33: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_FLAG');
34: FND_MSG_PUB.add;
35: RAISE FND_API.G_EXC_ERROR;
36: END IF;
37:

Line 46: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');

42: WHERE NAME = p_name;
43: EXCEPTION
44: WHEN NO_DATA_FOUND THEN
45: --RRS_NO_HIER_FOUND
46: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');
47: FND_MESSAGE.set_token('HIERARCHY_NAME', p_name);
48: FND_MSG_PUB.add;
49: --dbms_output.put_line('invalid hier name: '||p_name);
50: RAISE FND_API.G_EXC_ERROR;

Line 47: FND_MESSAGE.set_token('HIERARCHY_NAME', p_name);

43: EXCEPTION
44: WHEN NO_DATA_FOUND THEN
45: --RRS_NO_HIER_FOUND
46: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');
47: FND_MESSAGE.set_token('HIERARCHY_NAME', p_name);
48: FND_MSG_PUB.add;
49: --dbms_output.put_line('invalid hier name: '||p_name);
50: RAISE FND_API.G_EXC_ERROR;
51: END;

Line 70: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');

66: AND nvl(end_date_active, sysdate) >= sysdate;
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: --RRS_NO_PURPOSE_FOUND
70: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');
71: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);
72: FND_MSG_PUB.add;
73: --dbms_output.put_line('invalid purpose: '||p_purpose_code);
74: RAISE FND_API.G_EXC_ERROR;

Line 71: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);

67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: --RRS_NO_PURPOSE_FOUND
70: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');
71: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);
72: FND_MSG_PUB.add;
73: --dbms_output.put_line('invalid purpose: '||p_purpose_code);
74: RAISE FND_API.G_EXC_ERROR;
75: END;

Line 86: FND_MESSAGE.set_name('RRS', 'RRS_HIER_EXISTS');

82: WHERE NAME = p_new_name
83: AND SITE_GROUP_ID <> v_hier_id;
84: IF v_count <> 0 THEN
85: --RRS_HIER_EXISTS
86: FND_MESSAGE.set_name('RRS', 'RRS_HIER_EXISTS');
87: FND_MESSAGE.set_token('HIERARCHY_NAME', p_new_name);
88: FND_MSG_PUB.add;
89: --dbms_output.put_line('invalid hier new name:'|| p_new_name);
90: RAISE FND_API.G_EXC_ERROR;

Line 87: FND_MESSAGE.set_token('HIERARCHY_NAME', p_new_name);

83: AND SITE_GROUP_ID <> v_hier_id;
84: IF v_count <> 0 THEN
85: --RRS_HIER_EXISTS
86: FND_MESSAGE.set_name('RRS', 'RRS_HIER_EXISTS');
87: FND_MESSAGE.set_token('HIERARCHY_NAME', p_new_name);
88: FND_MSG_PUB.add;
89: --dbms_output.put_line('invalid hier new name:'|| p_new_name);
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;

Line 96: FND_MESSAGE.set_name('RRS', 'RRS_NULL_NAME');

92: END IF;
93:
94: IF FND_API.To_Boolean(p_nullify_flag) AND p_new_name IS NULL THEN
95: --RRS_NULL_NAME
96: FND_MESSAGE.set_name('RRS', 'RRS_NULL_NAME');
97: FND_MSG_PUB.add;
98: --dbms_output.put_line('new name cannot be null');
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;

Line 128: FND_MESSAGE.set_name('RRS', 'RRS_START_DATE_PAST_ERR');

124:
125: IF p_start_date IS NOT NULL
126: AND p_start_date < sysdate THEN
127: --RRS_START_DATE_PAST_ERR
128: FND_MESSAGE.set_name('RRS', 'RRS_START_DATE_PAST_ERR');
129: FND_MSG_PUB.add;
130: RAISE FND_API.G_EXC_ERROR;
131: ELSIF p_end_date IS NOT NULL
132: AND p_end_date < sysdate THEN

Line 134: FND_MESSAGE.set_name('RRS', 'RRS_END_DATE_PAST_ERR');

130: RAISE FND_API.G_EXC_ERROR;
131: ELSIF p_end_date IS NOT NULL
132: AND p_end_date < sysdate THEN
133: --RRS_END_DATE_PAST_ERR
134: FND_MESSAGE.set_name('RRS', 'RRS_END_DATE_PAST_ERR');
135: FND_MSG_PUB.add;
136: RAISE FND_API.G_EXC_ERROR;
137: ELSIF v_start_date IS NOT NULL
138: AND v_end_date IS NOT NULL

Line 141: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_DATE_RANGE');

137: ELSIF v_start_date IS NOT NULL
138: AND v_end_date IS NOT NULL
139: AND v_start_date > v_end_date THEN
140: --RRS_INVALID_DATE_RANGE
141: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_DATE_RANGE');
142: FND_MSG_PUB.add;
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:

Line 225: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_FLAG');

221:
222: IF p_nullify_flag <> FND_API.G_FALSE
223: AND p_nullify_flag <> FND_API.G_TRUE THEN
224: --RRS_INVALID_FLAG
225: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_FLAG');
226: FND_MSG_PUB.add;
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229:

Line 238: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');

234: WHERE RSGNV.NODE_IDENTIFICATION_NUMBER = p_number;
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: --RRS_NO_NODE_FOUND
238: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');
239: FND_MESSAGE.set_token('NODE_ID_NUM', p_number);
240: FND_MSG_PUB.add;
241: --dbms_output.put_line('no node found for:'||p_number);
242: RAISE FND_API.G_EXC_ERROR;

Line 239: FND_MESSAGE.set_token('NODE_ID_NUM', p_number);

235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: --RRS_NO_NODE_FOUND
238: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');
239: FND_MESSAGE.set_token('NODE_ID_NUM', p_number);
240: FND_MSG_PUB.add;
241: --dbms_output.put_line('no node found for:'||p_number);
242: RAISE FND_API.G_EXC_ERROR;
243: END;

Line 247: FND_MESSAGE.set_name('RRS', 'RRS_TRANSACT_ROOT');

243: END;
244:
245: IF v_purpose_code = 'ROOT' THEN
246: --RRS_TRANSACT_ROOT
247: FND_MESSAGE.set_name('RRS', 'RRS_TRANSACT_ROOT');
248: FND_MSG_PUB.add;
249: --dbms_output.put_line('cannot transact a root node');
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;

Line 268: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');

264: AND nvl(end_date_active, sysdate) >= sysdate;
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: --RRS_NO_PURPOSE_FOUND
268: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');
269: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);
270: FND_MSG_PUB.add;
271: --dbms_output.put_line('no purpose code found '||p_purpose_code);
272: RAISE FND_API.G_EXC_ERROR;

Line 269: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);

265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: --RRS_NO_PURPOSE_FOUND
268: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');
269: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);
270: FND_MSG_PUB.add;
271: --dbms_output.put_line('no purpose code found '||p_purpose_code);
272: RAISE FND_API.G_EXC_ERROR;
273: END;

Line 278: FND_MESSAGE.set_name('RRS', 'RRS_NULL_NAME');

274: END IF;
275:
276: IF FND_API.To_Boolean(p_nullify_flag) AND p_name IS NULL THEN
277: --RRS_NULL_NAME
278: FND_MESSAGE.set_name('RRS', 'RRS_NULL_NAME');
279: FND_MSG_PUB.add;
280: --dbms_output.put_line('new name cannot be null');
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;

Line 343: FND_MESSAGE.set_name('RRS', 'RRS_ID_NUMBER_BOTH_NULL');

339: SAVEPOINT Create_Hierarchy_Node;
340:
341: IF p_number IS NULL THEN
342: --RRS_ID_NUMBER_BOTH_NULL
343: FND_MESSAGE.set_name('RRS', 'RRS_ID_NUMBER_BOTH_NULL');
344: FND_MSG_PUB.add;
345: --dbms_output.put_line('Id and number cannot both be NULL');
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;

Line 356: FND_MESSAGE.set_name('RRS', 'RRS_NODE_EXISTS');

352: WHERE RSGNV.NODE_IDENTIFICATION_NUMBER = p_number;
353:
354: IF v_count <> 0 THEN
355: --RRS_NODE_EXISTS
356: FND_MESSAGE.set_name('RRS', 'RRS_NODE_EXISTS');
357: FND_MESSAGE.set_token('NODE_ID_NUM', p_number);
358: FND_MSG_PUB.add;
359: --dbms_output.put_line('node already exists '||p_number);
360: RAISE FND_API.G_EXC_ERROR;

Line 357: FND_MESSAGE.set_token('NODE_ID_NUM', p_number);

353:
354: IF v_count <> 0 THEN
355: --RRS_NODE_EXISTS
356: FND_MESSAGE.set_name('RRS', 'RRS_NODE_EXISTS');
357: FND_MESSAGE.set_token('NODE_ID_NUM', p_number);
358: FND_MSG_PUB.add;
359: --dbms_output.put_line('node already exists '||p_number);
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;

Line 376: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');

372: AND nvl(end_date_active, sysdate) >= sysdate;
373: EXCEPTION
374: WHEN NO_DATA_FOUND THEN
375: --RRS_NO_PURPOSE_FOUND
376: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');
377: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);
378: FND_MSG_PUB.add;
379: --dbms_output.put_line('invalid purpose '||p_purpose_code);
380: RAISE FND_API.G_EXC_ERROR;

Line 377: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);

373: EXCEPTION
374: WHEN NO_DATA_FOUND THEN
375: --RRS_NO_PURPOSE_FOUND
376: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');
377: FND_MESSAGE.set_token('PURPOSE_CODE', p_purpose_code);
378: FND_MSG_PUB.add;
379: --dbms_output.put_line('invalid purpose '||p_purpose_code);
380: RAISE FND_API.G_EXC_ERROR;
381: END;

Line 387: FND_MESSAGE.set_name('RRS', 'RRS_NULL_NAME');

383:
384: --dbms_output.put_line(p_name);
385: IF p_name IS NULL THEN
386: --RRS_NULL_NAME
387: FND_MESSAGE.set_name('RRS', 'RRS_NULL_NAME');
388: FND_MSG_PUB.add;
389: --dbms_output.put_line('null name');
390: RAISE FND_API.G_EXC_ERROR;
391: END IF;

Line 503: FND_MESSAGE.set_name('RRS', 'RRS_NULL_NAME');

499:
500: --check if the hier name is null
501: IF p_hier_name IS NULL THEN
502: --RRS_NULL_NAME
503: FND_MESSAGE.set_name('RRS', 'RRS_NULL_NAME');
504: FND_MSG_PUB.add;
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507:

Line 516: FND_MESSAGE.set_name('RRS', 'RRS_HIER_EXISTS');

512: WHERE NAME = p_hier_name;
513:
514: IF v_count <> 0 THEN
515: --RRS_HIER_EXISTS
516: FND_MESSAGE.set_name('RRS', 'RRS_HIER_EXISTS');
517: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);
518: FND_MSG_PUB.add;
519: --dbms_output.put_line('hier name already exists');
520: RAISE FND_API.G_EXC_ERROR;

Line 517: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);

513:
514: IF v_count <> 0 THEN
515: --RRS_HIER_EXISTS
516: FND_MESSAGE.set_name('RRS', 'RRS_HIER_EXISTS');
517: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);
518: FND_MSG_PUB.add;
519: --dbms_output.put_line('hier name already exists');
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;

Line 536: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');

532: AND nvl(end_date_active, sysdate) >= sysdate;
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: --RRS_NO_PURPOSE_FOUND
536: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');
537: FND_MESSAGE.set_token('PURPOSE_CODE', p_hier_purpose_code);
538: FND_MSG_PUB.add;
539: RAISE FND_API.G_EXC_ERROR;
540: END;

Line 537: FND_MESSAGE.set_token('PURPOSE_CODE', p_hier_purpose_code);

533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: --RRS_NO_PURPOSE_FOUND
536: FND_MESSAGE.set_name('RRS', 'RRS_NO_PURPOSE_FOUND');
537: FND_MESSAGE.set_token('PURPOSE_CODE', p_hier_purpose_code);
538: FND_MSG_PUB.add;
539: RAISE FND_API.G_EXC_ERROR;
540: END;
541: END IF;

Line 547: FND_MESSAGE.set_name('RRS', 'RRS_START_DATE_PAST_ERR');

543: --validate start/end date
544: IF p_hier_start_date IS NOT NULL
545: AND p_hier_start_date < sysdate THEN
546: --RRS_START_DATE_PAST_ERR
547: FND_MESSAGE.set_name('RRS', 'RRS_START_DATE_PAST_ERR');
548: FND_MSG_PUB.add;
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF p_hier_end_date IS NOT NULL
551: AND p_hier_end_date < sysdate THEN

Line 553: FND_MESSAGE.set_name('RRS', 'RRS_END_DATE_PAST_ERR');

549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF p_hier_end_date IS NOT NULL
551: AND p_hier_end_date < sysdate THEN
552: --RRS_END_DATE_PAST_ERR
553: FND_MESSAGE.set_name('RRS', 'RRS_END_DATE_PAST_ERR');
554: FND_MSG_PUB.add;
555: RAISE FND_API.G_EXC_ERROR;
556: ELSIF p_hier_start_date IS NOT NULL
557: AND p_hier_end_date IS NOT NULL

Line 560: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_DATE_RANGE');

556: ELSIF p_hier_start_date IS NOT NULL
557: AND p_hier_end_date IS NOT NULL
558: AND p_hier_start_date > p_hier_end_date THEN
559: --RRS_INVALID_DATE_RANGE
560: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_DATE_RANGE');
561: FND_MSG_PUB.add;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564:

Line 818: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');

814: LOOP
815: FETCH validate_rules_cursor INTO v_p_type, v_p_num, v_c_type, v_c_num;
816: EXIT WHEN validate_rules_cursor%NOTFOUND OR validate_rules_cursor%NOTFOUND IS NULL;
817: --RRS_NO_RULE_FOUND
818: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
819: FND_MESSAGE.set_token('P_TYPE', v_p_type);
820: FND_MESSAGE.set_token('P_NUM', v_p_num);
821: FND_MESSAGE.set_token('C_TYPE', v_c_type);
822: FND_MESSAGE.set_token('C_NUM', v_c_num);

Line 819: FND_MESSAGE.set_token('P_TYPE', v_p_type);

815: FETCH validate_rules_cursor INTO v_p_type, v_p_num, v_c_type, v_c_num;
816: EXIT WHEN validate_rules_cursor%NOTFOUND OR validate_rules_cursor%NOTFOUND IS NULL;
817: --RRS_NO_RULE_FOUND
818: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
819: FND_MESSAGE.set_token('P_TYPE', v_p_type);
820: FND_MESSAGE.set_token('P_NUM', v_p_num);
821: FND_MESSAGE.set_token('C_TYPE', v_c_type);
822: FND_MESSAGE.set_token('C_NUM', v_c_num);
823: FND_MSG_PUB.add;

Line 820: FND_MESSAGE.set_token('P_NUM', v_p_num);

816: EXIT WHEN validate_rules_cursor%NOTFOUND OR validate_rules_cursor%NOTFOUND IS NULL;
817: --RRS_NO_RULE_FOUND
818: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
819: FND_MESSAGE.set_token('P_TYPE', v_p_type);
820: FND_MESSAGE.set_token('P_NUM', v_p_num);
821: FND_MESSAGE.set_token('C_TYPE', v_c_type);
822: FND_MESSAGE.set_token('C_NUM', v_c_num);
823: FND_MSG_PUB.add;
824: --dbms_output.put_line('The following member violates the RulesFwk: '||v_p_type||'/'||v_p_num||'/'||v_c_type||'/'||v_c_num);

Line 821: FND_MESSAGE.set_token('C_TYPE', v_c_type);

817: --RRS_NO_RULE_FOUND
818: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
819: FND_MESSAGE.set_token('P_TYPE', v_p_type);
820: FND_MESSAGE.set_token('P_NUM', v_p_num);
821: FND_MESSAGE.set_token('C_TYPE', v_c_type);
822: FND_MESSAGE.set_token('C_NUM', v_c_num);
823: FND_MSG_PUB.add;
824: --dbms_output.put_line('The following member violates the RulesFwk: '||v_p_type||'/'||v_p_num||'/'||v_c_type||'/'||v_c_num);
825: x_return_status := FND_API.G_RET_STS_ERROR;

Line 822: FND_MESSAGE.set_token('C_NUM', v_c_num);

818: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
819: FND_MESSAGE.set_token('P_TYPE', v_p_type);
820: FND_MESSAGE.set_token('P_NUM', v_p_num);
821: FND_MESSAGE.set_token('C_TYPE', v_c_type);
822: FND_MESSAGE.set_token('C_NUM', v_c_num);
823: FND_MSG_PUB.add;
824: --dbms_output.put_line('The following member violates the RulesFwk: '||v_p_type||'/'||v_p_num||'/'||v_c_type||'/'||v_c_num);
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: END LOOP;

Line 881: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');

877: AND RGR.OBJECT2 = p_child_object_type
878: AND RGR.CLASSIFICATION_CODE2 = p_child_purpose_code;
879: IF v_count = 0 THEN
880: --RRS_NO_RULE_FOUND
881: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
882: FND_MESSAGE.set_token('P_TYPE', p_parent_object_type);
883: FND_MESSAGE.set_token('P_NUM', p_parent_id_number);
884: FND_MESSAGE.set_token('C_TYPE', p_child_object_type);
885: FND_MESSAGE.set_token('C_NUM', p_child_id_number);

Line 882: FND_MESSAGE.set_token('P_TYPE', p_parent_object_type);

878: AND RGR.CLASSIFICATION_CODE2 = p_child_purpose_code;
879: IF v_count = 0 THEN
880: --RRS_NO_RULE_FOUND
881: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
882: FND_MESSAGE.set_token('P_TYPE', p_parent_object_type);
883: FND_MESSAGE.set_token('P_NUM', p_parent_id_number);
884: FND_MESSAGE.set_token('C_TYPE', p_child_object_type);
885: FND_MESSAGE.set_token('C_NUM', p_child_id_number);
886: FND_MSG_PUB.add;

Line 883: FND_MESSAGE.set_token('P_NUM', p_parent_id_number);

879: IF v_count = 0 THEN
880: --RRS_NO_RULE_FOUND
881: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
882: FND_MESSAGE.set_token('P_TYPE', p_parent_object_type);
883: FND_MESSAGE.set_token('P_NUM', p_parent_id_number);
884: FND_MESSAGE.set_token('C_TYPE', p_child_object_type);
885: FND_MESSAGE.set_token('C_NUM', p_child_id_number);
886: FND_MSG_PUB.add;
887: --dbms_output.put_line('Rules validation failed');

Line 884: FND_MESSAGE.set_token('C_TYPE', p_child_object_type);

880: --RRS_NO_RULE_FOUND
881: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
882: FND_MESSAGE.set_token('P_TYPE', p_parent_object_type);
883: FND_MESSAGE.set_token('P_NUM', p_parent_id_number);
884: FND_MESSAGE.set_token('C_TYPE', p_child_object_type);
885: FND_MESSAGE.set_token('C_NUM', p_child_id_number);
886: FND_MSG_PUB.add;
887: --dbms_output.put_line('Rules validation failed');
888: RAISE FND_API.G_EXC_ERROR;

Line 885: FND_MESSAGE.set_token('C_NUM', p_child_id_number);

881: FND_MESSAGE.set_name('RRS', 'RRS_NO_RULE_FOUND');
882: FND_MESSAGE.set_token('P_TYPE', p_parent_object_type);
883: FND_MESSAGE.set_token('P_NUM', p_parent_id_number);
884: FND_MESSAGE.set_token('C_TYPE', p_child_object_type);
885: FND_MESSAGE.set_token('C_NUM', p_child_id_number);
886: FND_MSG_PUB.add;
887: --dbms_output.put_line('Rules validation failed');
888: RAISE FND_API.G_EXC_ERROR;
889: END IF;

Line 1083: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');

1079:
1080: IF p_hier_members_tab(i).child_object_type <> 'SITE' AND
1081: p_hier_members_tab(i).child_object_type <> 'NODE' THEN
1082: --RRS_INVALID_TYPE
1083: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
1084: FND_MESSAGE.set_token('TYPE', p_hier_members_tab(i).child_object_type);
1085: FND_MSG_PUB.add;
1086: --dbms_output.put_line('invalid transaction type');
1087: RAISE FND_API.G_EXC_ERROR;

Line 1084: FND_MESSAGE.set_token('TYPE', p_hier_members_tab(i).child_object_type);

1080: IF p_hier_members_tab(i).child_object_type <> 'SITE' AND
1081: p_hier_members_tab(i).child_object_type <> 'NODE' THEN
1082: --RRS_INVALID_TYPE
1083: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
1084: FND_MESSAGE.set_token('TYPE', p_hier_members_tab(i).child_object_type);
1085: FND_MSG_PUB.add;
1086: --dbms_output.put_line('invalid transaction type');
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;

Line 1133: FND_MESSAGE.set_name('RRS', 'RRS_NO_ROOT_FOUND');

1129: AND RSGMT.CHILD_TYPE = 'NODE';
1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN
1132: --RRS_NO_ROOT_FOUND
1133: FND_MESSAGE.set_name('RRS', 'RRS_NO_ROOT_FOUND');
1134: FND_MSG_PUB.add;
1135: --dbms_output.put_line('no root found');
1136: RAISE FND_API.G_EXC_ERROR;
1137: WHEN TOO_MANY_ROWS THEN

Line 1139: FND_MESSAGE.set_name('RRS', 'RRS_MANY_ROOTS_FOUND');

1135: --dbms_output.put_line('no root found');
1136: RAISE FND_API.G_EXC_ERROR;
1137: WHEN TOO_MANY_ROWS THEN
1138: --RRS_MANY_ROOTS_FOUND
1139: FND_MESSAGE.set_name('RRS', 'RRS_MANY_ROOTS_FOUND');
1140: FND_MSG_PUB.add;
1141: --dbms_output.put_line('too many roots found');
1142: RAISE FND_API.G_EXC_ERROR;
1143: END;

Line 1149: FND_MESSAGE.set_name('RRS', 'RRS_NO_ROOT_FOUND');

1145: --validate the root number user input with the one in DB
1146: IF (p_root_number IS NOT NULL AND v_root_number IS NOT NULL)
1147: AND p_root_number <> v_root_number THEN
1148: --RRS_NO_ROOT_FOUND
1149: FND_MESSAGE.set_name('RRS', 'RRS_NO_ROOT_FOUND');
1150: FND_MSG_PUB.add;
1151: --dbms_output.put_line('no root found');
1152: RAISE FND_API.G_EXC_ERROR;
1153: END IF;

Line 1157: FND_MESSAGE.set_name('RRS', 'RRS_NO_ROOT_FOUND');

1153: END IF;
1154:
1155: IF v_root_id IS NOT NULL AND p_root_id <> v_root_id THEN
1156: --RRS_NO_ROOT_FOUND
1157: FND_MESSAGE.set_name('RRS', 'RRS_NO_ROOT_FOUND');
1158: FND_MSG_PUB.add;
1159: --dbms_output.put_line('no root found');
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;

Line 1172: FND_MESSAGE.set_name('RRS', 'RRS_NODE_EXISTS');

1168: AND SITE_GROUP_NODE_ID <> p_root_id;
1169:
1170: IF v_count <> 0 THEN
1171: --RRS_NODE_EXISTS
1172: FND_MESSAGE.set_name('RRS', 'RRS_NODE_EXISTS');
1173: FND_MESSAGE.set_token('NODE_ID_NUM', v_root_number);
1174: FND_MSG_PUB.add;
1175: --dbms_output.put_line('node number already exists '||v_root_number);
1176: RAISE FND_API.G_EXC_ERROR;

Line 1173: FND_MESSAGE.set_token('NODE_ID_NUM', v_root_number);

1169:
1170: IF v_count <> 0 THEN
1171: --RRS_NODE_EXISTS
1172: FND_MESSAGE.set_name('RRS', 'RRS_NODE_EXISTS');
1173: FND_MESSAGE.set_token('NODE_ID_NUM', v_root_number);
1174: FND_MSG_PUB.add;
1175: --dbms_output.put_line('node number already exists '||v_root_number);
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;

Line 1201: FND_MESSAGE.set_name('RRS', 'RRS_ID_NUMBER_BOTH_NULL');

1197: OR (CHILD_ID IS NULL AND CHILD_NUMBER IS NULL);
1198:
1199: IF v_count <> 0 THEN
1200: --RRS_ID_NUMBER_BOTH_NULL
1201: FND_MESSAGE.set_name('RRS', 'RRS_ID_NUMBER_BOTH_NULL');
1202: FND_MSG_PUB.add;
1203: --dbms_output.put_line('Id and number cannot both be NULL');
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;

Line 1215: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_ID_NUMBER_PAIR');

1211: LOOP
1212: FETCH validate_p_id_num_cursor INTO v_id, v_num;
1213: EXIT WHEN validate_p_id_num_cursor%NOTFOUND OR validate_p_id_num_cursor%NOTFOUND IS NULL;
1214: --RRS_INVALID_ID_NUMBER_PAIR
1215: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_ID_NUMBER_PAIR');
1216: FND_MESSAGE.set_token('ID', v_id);
1217: FND_MESSAGE.set_token('NUM', v_num);
1218: FND_MSG_PUB.add;
1219: --dbms_output.put_line('Invalid pair of id/number: '||v_id||'/'||v_num);

Line 1216: FND_MESSAGE.set_token('ID', v_id);

1212: FETCH validate_p_id_num_cursor INTO v_id, v_num;
1213: EXIT WHEN validate_p_id_num_cursor%NOTFOUND OR validate_p_id_num_cursor%NOTFOUND IS NULL;
1214: --RRS_INVALID_ID_NUMBER_PAIR
1215: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_ID_NUMBER_PAIR');
1216: FND_MESSAGE.set_token('ID', v_id);
1217: FND_MESSAGE.set_token('NUM', v_num);
1218: FND_MSG_PUB.add;
1219: --dbms_output.put_line('Invalid pair of id/number: '||v_id||'/'||v_num);
1220: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1217: FND_MESSAGE.set_token('NUM', v_num);

1213: EXIT WHEN validate_p_id_num_cursor%NOTFOUND OR validate_p_id_num_cursor%NOTFOUND IS NULL;
1214: --RRS_INVALID_ID_NUMBER_PAIR
1215: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_ID_NUMBER_PAIR');
1216: FND_MESSAGE.set_token('ID', v_id);
1217: FND_MESSAGE.set_token('NUM', v_num);
1218: FND_MSG_PUB.add;
1219: --dbms_output.put_line('Invalid pair of id/number: '||v_id||'/'||v_num);
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221: END LOOP;

Line 1229: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_ID_NUMBER_PAIR');

1225: LOOP
1226: FETCH validate_c_id_num_cursor INTO v_id, v_num;
1227: EXIT WHEN validate_c_id_num_cursor%NOTFOUND OR validate_c_id_num_cursor%NOTFOUND IS NULL;
1228: --RRS_INVALID_ID_NUMBER_PAIR
1229: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_ID_NUMBER_PAIR');
1230: FND_MESSAGE.set_token('ID', v_id);
1231: FND_MESSAGE.set_token('NUM', v_num);
1232: FND_MSG_PUB.add;
1233: --dbms_output.put_line('Invalid pair of id/number: '||v_id||'/'||v_num);

Line 1230: FND_MESSAGE.set_token('ID', v_id);

1226: FETCH validate_c_id_num_cursor INTO v_id, v_num;
1227: EXIT WHEN validate_c_id_num_cursor%NOTFOUND OR validate_c_id_num_cursor%NOTFOUND IS NULL;
1228: --RRS_INVALID_ID_NUMBER_PAIR
1229: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_ID_NUMBER_PAIR');
1230: FND_MESSAGE.set_token('ID', v_id);
1231: FND_MESSAGE.set_token('NUM', v_num);
1232: FND_MSG_PUB.add;
1233: --dbms_output.put_line('Invalid pair of id/number: '||v_id||'/'||v_num);
1234: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1231: FND_MESSAGE.set_token('NUM', v_num);

1227: EXIT WHEN validate_c_id_num_cursor%NOTFOUND OR validate_c_id_num_cursor%NOTFOUND IS NULL;
1228: --RRS_INVALID_ID_NUMBER_PAIR
1229: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_ID_NUMBER_PAIR');
1230: FND_MESSAGE.set_token('ID', v_id);
1231: FND_MESSAGE.set_token('NUM', v_num);
1232: FND_MSG_PUB.add;
1233: --dbms_output.put_line('Invalid pair of id/number: '||v_id||'/'||v_num);
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: END LOOP;

Line 1253: FND_MESSAGE.set_name('RRS', 'RRS_NO_ID_FOUND');

1249: LOOP
1250: FETCH validate_p_id_cursor INTO v_type, v_id, v_num;
1251: EXIT WHEN validate_p_id_cursor%NOTFOUND OR validate_p_id_cursor%NOTFOUND IS NULL;
1252: --RRS_NO_ID_FOUND
1253: FND_MESSAGE.set_name('RRS', 'RRS_NO_ID_FOUND');
1254: FND_MESSAGE.set_token('ID', v_id);
1255: FND_MESSAGE.set_token('TYPE', v_type);
1256: FND_MSG_PUB.add;
1257: --dbms_output.put_line('Non-existing type/id: '||v_type||'/'||v_id);

Line 1254: FND_MESSAGE.set_token('ID', v_id);

1250: FETCH validate_p_id_cursor INTO v_type, v_id, v_num;
1251: EXIT WHEN validate_p_id_cursor%NOTFOUND OR validate_p_id_cursor%NOTFOUND IS NULL;
1252: --RRS_NO_ID_FOUND
1253: FND_MESSAGE.set_name('RRS', 'RRS_NO_ID_FOUND');
1254: FND_MESSAGE.set_token('ID', v_id);
1255: FND_MESSAGE.set_token('TYPE', v_type);
1256: FND_MSG_PUB.add;
1257: --dbms_output.put_line('Non-existing type/id: '||v_type||'/'||v_id);
1258: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1255: FND_MESSAGE.set_token('TYPE', v_type);

1251: EXIT WHEN validate_p_id_cursor%NOTFOUND OR validate_p_id_cursor%NOTFOUND IS NULL;
1252: --RRS_NO_ID_FOUND
1253: FND_MESSAGE.set_name('RRS', 'RRS_NO_ID_FOUND');
1254: FND_MESSAGE.set_token('ID', v_id);
1255: FND_MESSAGE.set_token('TYPE', v_type);
1256: FND_MSG_PUB.add;
1257: --dbms_output.put_line('Non-existing type/id: '||v_type||'/'||v_id);
1258: x_return_status := FND_API.G_RET_STS_ERROR;
1259: END LOOP;

Line 1267: FND_MESSAGE.set_name('RRS', 'RRS_NO_ID_FOUND');

1263: LOOP
1264: FETCH validate_c_id_cursor INTO v_type, v_id, v_num;
1265: EXIT WHEN validate_c_id_cursor%NOTFOUND OR validate_c_id_cursor%NOTFOUND IS NULL;
1266: --RRS_NO_ID_FOUND
1267: FND_MESSAGE.set_name('RRS', 'RRS_NO_ID_FOUND');
1268: FND_MESSAGE.set_token('ID', v_id);
1269: FND_MESSAGE.set_token('TYPE', v_type);
1270: FND_MSG_PUB.add;
1271: --dbms_output.put_line('Non-existing type/id: '||v_type||'/'||v_id);

Line 1268: FND_MESSAGE.set_token('ID', v_id);

1264: FETCH validate_c_id_cursor INTO v_type, v_id, v_num;
1265: EXIT WHEN validate_c_id_cursor%NOTFOUND OR validate_c_id_cursor%NOTFOUND IS NULL;
1266: --RRS_NO_ID_FOUND
1267: FND_MESSAGE.set_name('RRS', 'RRS_NO_ID_FOUND');
1268: FND_MESSAGE.set_token('ID', v_id);
1269: FND_MESSAGE.set_token('TYPE', v_type);
1270: FND_MSG_PUB.add;
1271: --dbms_output.put_line('Non-existing type/id: '||v_type||'/'||v_id);
1272: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1269: FND_MESSAGE.set_token('TYPE', v_type);

1265: EXIT WHEN validate_c_id_cursor%NOTFOUND OR validate_c_id_cursor%NOTFOUND IS NULL;
1266: --RRS_NO_ID_FOUND
1267: FND_MESSAGE.set_name('RRS', 'RRS_NO_ID_FOUND');
1268: FND_MESSAGE.set_token('ID', v_id);
1269: FND_MESSAGE.set_token('TYPE', v_type);
1270: FND_MSG_PUB.add;
1271: --dbms_output.put_line('Non-existing type/id: '||v_type||'/'||v_id);
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: END LOOP;

Line 1361: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NUMBER');

1357: LOOP
1358: FETCH validate_dup_number_cursor INTO v_type, v_num;
1359: EXIT WHEN validate_dup_number_cursor%NOTFOUND OR validate_dup_number_cursor%NOTFOUND IS NULL;
1360: --RRS_DUPLICATED_NUMBER
1361: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NUMBER');
1362: FND_MESSAGE.set_token('NUM', v_num);
1363: FND_MESSAGE.set_token('TYPE', v_type);
1364: FND_MSG_PUB.add;
1365: --dbms_output.put_line('Duplicated type/num: '||v_type||'/'||v_num);

Line 1362: FND_MESSAGE.set_token('NUM', v_num);

1358: FETCH validate_dup_number_cursor INTO v_type, v_num;
1359: EXIT WHEN validate_dup_number_cursor%NOTFOUND OR validate_dup_number_cursor%NOTFOUND IS NULL;
1360: --RRS_DUPLICATED_NUMBER
1361: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NUMBER');
1362: FND_MESSAGE.set_token('NUM', v_num);
1363: FND_MESSAGE.set_token('TYPE', v_type);
1364: FND_MSG_PUB.add;
1365: --dbms_output.put_line('Duplicated type/num: '||v_type||'/'||v_num);
1366: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1363: FND_MESSAGE.set_token('TYPE', v_type);

1359: EXIT WHEN validate_dup_number_cursor%NOTFOUND OR validate_dup_number_cursor%NOTFOUND IS NULL;
1360: --RRS_DUPLICATED_NUMBER
1361: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NUMBER');
1362: FND_MESSAGE.set_token('NUM', v_num);
1363: FND_MESSAGE.set_token('TYPE', v_type);
1364: FND_MSG_PUB.add;
1365: --dbms_output.put_line('Duplicated type/num: '||v_type||'/'||v_num);
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END LOOP;

Line 1381: FND_MESSAGE.set_name('RRS', 'RRS_NO_NUM_FOUND');

1377: LOOP
1378: FETCH validate_num_cursor INTO v_num, v_type;
1379: EXIT WHEN validate_num_cursor%NOTFOUND OR validate_num_cursor%NOTFOUND IS NULL;
1380: --RRS_NO_NUM_FOUND
1381: FND_MESSAGE.set_name('RRS', 'RRS_NO_NUM_FOUND');
1382: FND_MESSAGE.set_token('NUM', v_num);
1383: FND_MESSAGE.set_token('TYPE', v_type);
1384: FND_MSG_PUB.add;
1385: --dbms_output.put_line('Invalid num: '||v_num);

Line 1382: FND_MESSAGE.set_token('NUM', v_num);

1378: FETCH validate_num_cursor INTO v_num, v_type;
1379: EXIT WHEN validate_num_cursor%NOTFOUND OR validate_num_cursor%NOTFOUND IS NULL;
1380: --RRS_NO_NUM_FOUND
1381: FND_MESSAGE.set_name('RRS', 'RRS_NO_NUM_FOUND');
1382: FND_MESSAGE.set_token('NUM', v_num);
1383: FND_MESSAGE.set_token('TYPE', v_type);
1384: FND_MSG_PUB.add;
1385: --dbms_output.put_line('Invalid num: '||v_num);
1386: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1383: FND_MESSAGE.set_token('TYPE', v_type);

1379: EXIT WHEN validate_num_cursor%NOTFOUND OR validate_num_cursor%NOTFOUND IS NULL;
1380: --RRS_NO_NUM_FOUND
1381: FND_MESSAGE.set_name('RRS', 'RRS_NO_NUM_FOUND');
1382: FND_MESSAGE.set_token('NUM', v_num);
1383: FND_MESSAGE.set_token('TYPE', v_type);
1384: FND_MSG_PUB.add;
1385: --dbms_output.put_line('Invalid num: '||v_num);
1386: x_return_status := FND_API.G_RET_STS_ERROR;
1387: END LOOP;

Line 1401: FND_MESSAGE.set_name('RRS', 'RRS_SITE_TEMPLATE');

1397: LOOP
1398: FETCH validate_site_template_cursor INTO v_num;
1399: EXIT WHEN validate_site_template_cursor%NOTFOUND OR validate_site_template_cursor%NOTFOUND IS NULL;
1400: --RRS_SITE_TEMPLATE
1401: FND_MESSAGE.set_name('RRS', 'RRS_SITE_TEMPLATE');
1402: FND_MESSAGE.set_token('SITE_ID_NUM', v_num);
1403: FND_MSG_PUB.add;
1404: --dbms_output.put_line('site is a template: '||v_num);
1405: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1402: FND_MESSAGE.set_token('SITE_ID_NUM', v_num);

1398: FETCH validate_site_template_cursor INTO v_num;
1399: EXIT WHEN validate_site_template_cursor%NOTFOUND OR validate_site_template_cursor%NOTFOUND IS NULL;
1400: --RRS_SITE_TEMPLATE
1401: FND_MESSAGE.set_name('RRS', 'RRS_SITE_TEMPLATE');
1402: FND_MESSAGE.set_token('SITE_ID_NUM', v_num);
1403: FND_MSG_PUB.add;
1404: --dbms_output.put_line('site is a template: '||v_num);
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: END LOOP;

Line 1419: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NOT_CONNECTED');

1415: LOOP
1416: FETCH validate_p_in_hier_curosr INTO v_type, v_num;
1417: EXIT WHEN validate_p_in_hier_curosr%NOTFOUND OR validate_p_in_hier_curosr%NOTFOUND IS NULL;
1418: --RRS_HIER_NOT_CONNECTED
1419: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NOT_CONNECTED');
1420: FND_MESSAGE.set_token('NUM', v_num);
1421: FND_MESSAGE.set_token('TYPE', v_type);
1422: FND_MSG_PUB.add;
1423: --dbms_output.put_line('No parent found type/num: '||v_type||'/'||v_num);

Line 1420: FND_MESSAGE.set_token('NUM', v_num);

1416: FETCH validate_p_in_hier_curosr INTO v_type, v_num;
1417: EXIT WHEN validate_p_in_hier_curosr%NOTFOUND OR validate_p_in_hier_curosr%NOTFOUND IS NULL;
1418: --RRS_HIER_NOT_CONNECTED
1419: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NOT_CONNECTED');
1420: FND_MESSAGE.set_token('NUM', v_num);
1421: FND_MESSAGE.set_token('TYPE', v_type);
1422: FND_MSG_PUB.add;
1423: --dbms_output.put_line('No parent found type/num: '||v_type||'/'||v_num);
1424: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1421: FND_MESSAGE.set_token('TYPE', v_type);

1417: EXIT WHEN validate_p_in_hier_curosr%NOTFOUND OR validate_p_in_hier_curosr%NOTFOUND IS NULL;
1418: --RRS_HIER_NOT_CONNECTED
1419: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NOT_CONNECTED');
1420: FND_MESSAGE.set_token('NUM', v_num);
1421: FND_MESSAGE.set_token('TYPE', v_type);
1422: FND_MSG_PUB.add;
1423: --dbms_output.put_line('No parent found type/num: '||v_type||'/'||v_num);
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END LOOP;

Line 1439: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NODE_NAME');

1435: LOOP
1436: FETCH validate_node_name_cursor INTO v_node_name;
1437: EXIT WHEN validate_node_name_cursor%NOTFOUND OR validate_node_name_cursor%NOTFOUND IS NULL;
1438: --RRS_DUPLICATED_NODE_NAME
1439: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NODE_NAME');
1440: FND_MESSAGE.set_token('NODE_NAME', v_node_name);
1441: FND_MSG_PUB.add;
1442: --dbms_output.put_line('Duplicated node name under a same parent: '||v_node_name);
1443: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1440: FND_MESSAGE.set_token('NODE_NAME', v_node_name);

1436: FETCH validate_node_name_cursor INTO v_node_name;
1437: EXIT WHEN validate_node_name_cursor%NOTFOUND OR validate_node_name_cursor%NOTFOUND IS NULL;
1438: --RRS_DUPLICATED_NODE_NAME
1439: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NODE_NAME');
1440: FND_MESSAGE.set_token('NODE_NAME', v_node_name);
1441: FND_MSG_PUB.add;
1442: --dbms_output.put_line('Duplicated node name under a same parent: '||v_node_name);
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: END LOOP;

Line 1593: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_FLAG');

1589:
1590: IF p_nullify_flag <> FND_API.G_FALSE
1591: AND p_nullify_flag <> FND_API.G_TRUE THEN
1592: --RRS_INVALID_FLAG
1593: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_FLAG');
1594: FND_MSG_PUB.add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597:

Line 1606: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');

1602: WHERE RSGV.NAME = p_hier_name;
1603: EXCEPTION
1604: WHEN NO_DATA_FOUND THEN
1605: --RRS_NO_HIER_FOUND
1606: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');
1607: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);
1608: FND_MSG_PUB.add;
1609: --dbms_output.put_line('invalid hier name');
1610: RAISE FND_API.G_EXC_ERROR;

Line 1607: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);

1603: EXCEPTION
1604: WHEN NO_DATA_FOUND THEN
1605: --RRS_NO_HIER_FOUND
1606: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');
1607: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);
1608: FND_MSG_PUB.add;
1609: --dbms_output.put_line('invalid hier name');
1610: RAISE FND_API.G_EXC_ERROR;
1611: END;

Line 1624: FND_MESSAGE.set_name('RRS', 'RRS_NO_ROOT_FOUND');

1620: AND RSGNV.NODE_PURPOSE_CODE = 'ROOT';
1621: EXCEPTION
1622: WHEN NO_DATA_FOUND THEN
1623: --RRS_NO_ROOT_FOUND
1624: FND_MESSAGE.set_name('RRS', 'RRS_NO_ROOT_FOUND');
1625: FND_MSG_PUB.add;
1626: --dbms_output.put_line('root node not found in members table');
1627: RAISE FND_API.G_EXC_ERROR;
1628: END;

Line 1638: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_VERSION_FOUND');

1634: WHERE SITE_GROUP_ID = v_hier_id;
1635: EXCEPTION
1636: WHEN NO_DATA_FOUND THEN
1637: --RRS_NO_HIER_VERSION_FOUND
1638: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_VERSION_FOUND');
1639: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);
1640: FND_MSG_PUB.add;
1641: --dbms_output.put_line('hier version id not found');
1642: RAISE FND_API.G_EXC_ERROR;

Line 1639: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);

1635: EXCEPTION
1636: WHEN NO_DATA_FOUND THEN
1637: --RRS_NO_HIER_VERSION_FOUND
1638: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_VERSION_FOUND');
1639: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_name);
1640: FND_MSG_PUB.add;
1641: --dbms_output.put_line('hier version id not found');
1642: RAISE FND_API.G_EXC_ERROR;
1643: END;

Line 1815: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');

1811: WHERE RSGV.NAME = p_hier_members_rec.dest_hier_name;
1812: EXCEPTION
1813: WHEN NO_DATA_FOUND THEN
1814: --RRS_NO_HIER_FOUND
1815: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');
1816: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1817: FND_MSG_PUB.add;
1818: --dbms_output.put_line('invalid dest hier name: '||p_hier_members_rec.dest_hier_name);
1819: RAISE FND_API.G_EXC_ERROR;

Line 1816: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);

1812: EXCEPTION
1813: WHEN NO_DATA_FOUND THEN
1814: --RRS_NO_HIER_FOUND
1815: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');
1816: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1817: FND_MSG_PUB.add;
1818: --dbms_output.put_line('invalid dest hier name: '||p_hier_members_rec.dest_hier_name);
1819: RAISE FND_API.G_EXC_ERROR;
1820: END;

Line 1831: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_VERSION_FOUND');

1827: WHERE SITE_GROUP_ID = v_dest_hier_id;
1828: EXCEPTION
1829: WHEN NO_DATA_FOUND THEN
1830: --RRS_NO_HIER_VERSION_FOUND
1831: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_VERSION_FOUND');
1832: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1833: FND_MSG_PUB.add;
1834: --dbms_output.put_line('version id not found: '||p_hier_members_rec.dest_hier_name);
1835: RAISE FND_API.G_EXC_ERROR;

Line 1832: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);

1828: EXCEPTION
1829: WHEN NO_DATA_FOUND THEN
1830: --RRS_NO_HIER_VERSION_FOUND
1831: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_VERSION_FOUND');
1832: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1833: FND_MSG_PUB.add;
1834: --dbms_output.put_line('version id not found: '||p_hier_members_rec.dest_hier_name);
1835: RAISE FND_API.G_EXC_ERROR;
1836: END;

Line 1846: FND_MESSAGE.set_name('RRS', 'RRS_NULL_CHILD_NUMBER');

1842: --4. cannot be a site template
1843: --dbms_output.put_line('before validate child number');
1844: IF p_hier_members_rec.child_id_number IS NULL THEN
1845: --RRS_NULL_CHILD_NUMBER
1846: FND_MESSAGE.set_name('RRS', 'RRS_NULL_CHILD_NUMBER');
1847: FND_MSG_PUB.add;
1848: --dbms_output.put_line('child number cannot be null');
1849: RAISE FND_API.G_EXC_ERROR;
1850: END IF;

Line 1861: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');

1857: WHERE NODE_IDENTIFICATION_NUMBER = p_hier_members_rec.child_id_number;
1858: EXCEPTION
1859: WHEN NO_DATA_FOUND THEN
1860: --RRS_NO_NODE_FOUND
1861: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');
1862: FND_MESSAGE.set_token('NODE_ID_NUM', p_hier_members_rec.child_id_number);
1863: FND_MSG_PUB.add;
1864: --dbms_output.put_line('invalid node number: '|| p_hier_members_rec.child_id_number);
1865: RAISE FND_API.G_EXC_ERROR;

Line 1862: FND_MESSAGE.set_token('NODE_ID_NUM', p_hier_members_rec.child_id_number);

1858: EXCEPTION
1859: WHEN NO_DATA_FOUND THEN
1860: --RRS_NO_NODE_FOUND
1861: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');
1862: FND_MESSAGE.set_token('NODE_ID_NUM', p_hier_members_rec.child_id_number);
1863: FND_MSG_PUB.add;
1864: --dbms_output.put_line('invalid node number: '|| p_hier_members_rec.child_id_number);
1865: RAISE FND_API.G_EXC_ERROR;
1866: END;

Line 1869: FND_MESSAGE.set_name('RRS', 'RRS_TRANSACT_ROOT');

1865: RAISE FND_API.G_EXC_ERROR;
1866: END;
1867: IF v_child_purpose_code = 'ROOT' THEN
1868: --RRS_TRANSACT_ROOT
1869: FND_MESSAGE.set_name('RRS', 'RRS_TRANSACT_ROOT');
1870: FND_MSG_PUB.add;
1871: --dbms_output.put_line('cannot transact on root node');
1872: RAISE FND_API.G_EXC_ERROR;
1873: END IF;

Line 1885: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');

1881: AND RSU.IS_PRIMARY_FLAG(+) = 'Y';
1882: EXCEPTION
1883: WHEN NO_DATA_FOUND THEN
1884: --RRS_NO_SITE_FOUND
1885: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');
1886: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.child_id_number);
1887: FND_MSG_PUB.add;
1888: --dbms_output.put_line('invalid site number: '|| p_hier_members_rec.child_id_number);
1889: RAISE FND_API.G_EXC_ERROR;

Line 1886: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.child_id_number);

1882: EXCEPTION
1883: WHEN NO_DATA_FOUND THEN
1884: --RRS_NO_SITE_FOUND
1885: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');
1886: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.child_id_number);
1887: FND_MSG_PUB.add;
1888: --dbms_output.put_line('invalid site number: '|| p_hier_members_rec.child_id_number);
1889: RAISE FND_API.G_EXC_ERROR;
1890: END;

Line 1893: FND_MESSAGE.set_name('RRS', 'RRS_SITE_TEMPLATE');

1889: RAISE FND_API.G_EXC_ERROR;
1890: END;
1891: IF v_flag = 'Y' THEN
1892: --RRS_SITE_TEMPLATE
1893: FND_MESSAGE.set_name('RRS', 'RRS_SITE_TEMPLATE');
1894: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.child_id_number);
1895: FND_MSG_PUB.add;
1896: --dbms_output.put_line('site is a template: '||p_hier_members_rec.child_id_number);
1897: RAISE FND_API.G_EXC_ERROR;

Line 1894: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.child_id_number);

1890: END;
1891: IF v_flag = 'Y' THEN
1892: --RRS_SITE_TEMPLATE
1893: FND_MESSAGE.set_name('RRS', 'RRS_SITE_TEMPLATE');
1894: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.child_id_number);
1895: FND_MSG_PUB.add;
1896: --dbms_output.put_line('site is a template: '||p_hier_members_rec.child_id_number);
1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;

Line 1901: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');

1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;
1899: ELSE
1900: --RRS_INVALID_TYPE
1901: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
1902: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
1903: FND_MSG_PUB.add;
1904: --dbms_output.put_line('Invalid child type: '||p_hier_members_rec.child_object_type);
1905: RAISE FND_API.G_EXC_ERROR;

Line 1902: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);

1898: END IF;
1899: ELSE
1900: --RRS_INVALID_TYPE
1901: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
1902: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
1903: FND_MSG_PUB.add;
1904: --dbms_output.put_line('Invalid child type: '||p_hier_members_rec.child_object_type);
1905: RAISE FND_API.G_EXC_ERROR;
1906: END IF;

Line 1920: FND_MESSAGE.set_name('RRS', 'RRS_NULL_DEST_PARENT_NUMBER');

1916: --3. site/node shuld appear in the hierarchy
1917: --dbms_output.put_line('before validate dest parent number');
1918: IF p_hier_members_rec.dest_parent_id_number IS NULL THEN
1919: --RRS_NULL_DEST_PARENT_NUMBER
1920: FND_MESSAGE.set_name('RRS', 'RRS_NULL_DEST_PARENT_NUMBER');
1921: FND_MSG_PUB.add;
1922: --dbms_output.put_line('dest parent number cannot be null');
1923: RAISE FND_API.G_EXC_ERROR;
1924: END IF;

Line 1937: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_NODE_FOUND');

1933: AND RSGM.SITE_GROUP_ID = v_dest_hier_id;
1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN
1936: --RRS_HIER_NO_NODE_FOUND
1937: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_NODE_FOUND');
1938: FND_MESSAGE.set_token('NODE_ID_NUM', p_hier_members_rec.dest_parent_id_number);
1939: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1940: FND_MSG_PUB.add;
1941: --dbms_output.put_line('node does not exist or appear in the hierarchy: '|| p_hier_members_rec.dest_parent_id_number);

Line 1938: FND_MESSAGE.set_token('NODE_ID_NUM', p_hier_members_rec.dest_parent_id_number);

1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN
1936: --RRS_HIER_NO_NODE_FOUND
1937: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_NODE_FOUND');
1938: FND_MESSAGE.set_token('NODE_ID_NUM', p_hier_members_rec.dest_parent_id_number);
1939: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1940: FND_MSG_PUB.add;
1941: --dbms_output.put_line('node does not exist or appear in the hierarchy: '|| p_hier_members_rec.dest_parent_id_number);
1942: RAISE FND_API.G_EXC_ERROR;

Line 1939: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);

1935: WHEN NO_DATA_FOUND THEN
1936: --RRS_HIER_NO_NODE_FOUND
1937: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_NODE_FOUND');
1938: FND_MESSAGE.set_token('NODE_ID_NUM', p_hier_members_rec.dest_parent_id_number);
1939: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1940: FND_MSG_PUB.add;
1941: --dbms_output.put_line('node does not exist or appear in the hierarchy: '|| p_hier_members_rec.dest_parent_id_number);
1942: RAISE FND_API.G_EXC_ERROR;
1943: END;

Line 1957: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_SITE_FOUND');

1953: AND RSGM.SITE_GROUP_ID = v_dest_hier_id;
1954: EXCEPTION
1955: WHEN NO_DATA_FOUND THEN
1956: --RRS_HIER_NO_SITE_FOUND
1957: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_SITE_FOUND');
1958: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.dest_parent_id_number);
1959: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1960: FND_MSG_PUB.add;
1961: --dbms_output.put_line('site does not exist or appear in the hierarchy: '|| p_hier_members_rec.dest_parent_id_number);

Line 1958: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.dest_parent_id_number);

1954: EXCEPTION
1955: WHEN NO_DATA_FOUND THEN
1956: --RRS_HIER_NO_SITE_FOUND
1957: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_SITE_FOUND');
1958: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.dest_parent_id_number);
1959: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1960: FND_MSG_PUB.add;
1961: --dbms_output.put_line('site does not exist or appear in the hierarchy: '|| p_hier_members_rec.dest_parent_id_number);
1962: RAISE FND_API.G_EXC_ERROR;

Line 1959: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);

1955: WHEN NO_DATA_FOUND THEN
1956: --RRS_HIER_NO_SITE_FOUND
1957: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_SITE_FOUND');
1958: FND_MESSAGE.set_token('SITE_ID_NUM', p_hier_members_rec.dest_parent_id_number);
1959: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1960: FND_MSG_PUB.add;
1961: --dbms_output.put_line('site does not exist or appear in the hierarchy: '|| p_hier_members_rec.dest_parent_id_number);
1962: RAISE FND_API.G_EXC_ERROR;
1963: END;

Line 1966: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');

1962: RAISE FND_API.G_EXC_ERROR;
1963: END;
1964: ELSE
1965: --RRS_INVALID_TYPE
1966: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
1967: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.dest_parent_object_type);
1968: FND_MSG_PUB.add;
1969: --dbms_output.put_line('Invalid parent type: '||p_hier_members_rec.dest_parent_object_type);
1970: RAISE FND_API.G_EXC_ERROR;

Line 1967: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.dest_parent_object_type);

1963: END;
1964: ELSE
1965: --RRS_INVALID_TYPE
1966: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
1967: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.dest_parent_object_type);
1968: FND_MSG_PUB.add;
1969: --dbms_output.put_line('Invalid parent type: '||p_hier_members_rec.dest_parent_object_type);
1970: RAISE FND_API.G_EXC_ERROR;
1971: END IF;

Line 1986: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');

1982: WHERE CHILD_MEMBER_ID = v_child_id
1983: AND SITE_GROUP_ID = v_dest_hier_id;
1984: IF v_count <> 0 THEN
1985: --RRS_HIER_CHILD_EXISTS
1986: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
1987: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
1988: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
1989: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1990: FND_MSG_PUB.add;

Line 1987: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);

1983: AND SITE_GROUP_ID = v_dest_hier_id;
1984: IF v_count <> 0 THEN
1985: --RRS_HIER_CHILD_EXISTS
1986: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
1987: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
1988: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
1989: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1990: FND_MSG_PUB.add;
1991: --dbms_output.put_line('Child already exists in the destination hierarchy: '||p_hier_members_rec.child_id_number);

Line 1988: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);

1984: IF v_count <> 0 THEN
1985: --RRS_HIER_CHILD_EXISTS
1986: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
1987: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
1988: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
1989: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1990: FND_MSG_PUB.add;
1991: --dbms_output.put_line('Child already exists in the destination hierarchy: '||p_hier_members_rec.child_id_number);
1992: RAISE FND_API.G_EXC_ERROR;

Line 1989: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);

1985: --RRS_HIER_CHILD_EXISTS
1986: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
1987: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
1988: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
1989: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
1990: FND_MSG_PUB.add;
1991: --dbms_output.put_line('Child already exists in the destination hierarchy: '||p_hier_members_rec.child_id_number);
1992: RAISE FND_API.G_EXC_ERROR;
1993: END IF;

Line 2065: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');

2061: AND CHILD_MEMBER_ID = v_child_id;
2062:
2063: IF v_count = 0 THEN
2064: --RRS_HIER_NO_CHILD_FOUND
2065: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');
2066: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2067: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2068: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
2069: FND_MSG_PUB.add;

Line 2066: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);

2062:
2063: IF v_count = 0 THEN
2064: --RRS_HIER_NO_CHILD_FOUND
2065: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');
2066: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2067: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2068: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
2069: FND_MSG_PUB.add;
2070: --dbms_output.put_line('Child does not appear in the destination hierarchy');

Line 2067: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);

2063: IF v_count = 0 THEN
2064: --RRS_HIER_NO_CHILD_FOUND
2065: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');
2066: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2067: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2068: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
2069: FND_MSG_PUB.add;
2070: --dbms_output.put_line('Child does not appear in the destination hierarchy');
2071: RAISE FND_API.G_EXC_ERROR;

Line 2068: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);

2064: --RRS_HIER_NO_CHILD_FOUND
2065: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');
2066: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2067: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2068: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
2069: FND_MSG_PUB.add;
2070: --dbms_output.put_line('Child does not appear in the destination hierarchy');
2071: RAISE FND_API.G_EXC_ERROR;
2072: END IF;

Line 2098: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');

2094: WHERE NAME = p_hier_members_rec.source_hier_name;
2095: EXCEPTION
2096: WHEN NO_DATA_FOUND THEN
2097: --RRS_NO_HIER_FOUND
2098: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');
2099: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.source_hier_name);
2100: FND_MSG_PUB.add;
2101: --dbms_output.put_line('invalid source hier name: '||p_hier_members_rec.source_hier_name);
2102: RAISE FND_API.G_EXC_ERROR;

Line 2099: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.source_hier_name);

2095: EXCEPTION
2096: WHEN NO_DATA_FOUND THEN
2097: --RRS_NO_HIER_FOUND
2098: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_FOUND');
2099: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.source_hier_name);
2100: FND_MSG_PUB.add;
2101: --dbms_output.put_line('invalid source hier name: '||p_hier_members_rec.source_hier_name);
2102: RAISE FND_API.G_EXC_ERROR;
2103: END;

Line 2116: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');

2112: AND CHILD_MEMBER_ID = v_child_id;
2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN
2115: --RRS_HIER_NO_CHILD_FOUND
2116: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');
2117: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2118: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2119: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.source_hier_name);
2120: FND_MSG_PUB.add;

Line 2117: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);

2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN
2115: --RRS_HIER_NO_CHILD_FOUND
2116: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');
2117: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2118: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2119: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.source_hier_name);
2120: FND_MSG_PUB.add;
2121: --dbms_output.put_line('Child does not appear in the source hierarchy');

Line 2118: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);

2114: WHEN NO_DATA_FOUND THEN
2115: --RRS_HIER_NO_CHILD_FOUND
2116: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');
2117: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2118: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2119: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.source_hier_name);
2120: FND_MSG_PUB.add;
2121: --dbms_output.put_line('Child does not appear in the source hierarchy');
2122: RAISE FND_API.G_EXC_ERROR;

Line 2119: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.source_hier_name);

2115: --RRS_HIER_NO_CHILD_FOUND
2116: FND_MESSAGE.set_name('RRS', 'RRS_HIER_NO_CHILD_FOUND');
2117: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2118: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2119: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.source_hier_name);
2120: FND_MSG_PUB.add;
2121: --dbms_output.put_line('Child does not appear in the source hierarchy');
2122: RAISE FND_API.G_EXC_ERROR;
2123: END;

Line 2129: FND_MESSAGE.set_name('RRS', 'RRS_HIER_SAME_DEST_SOURCE');

2125: --source and dest hier cannot be the same for COPY transaction
2126: IF p_hier_members_rec.transaction_type = 'COPY'
2127: AND v_source_hier_id = v_dest_hier_id THEN
2128: --RRS_HIER_SAME_DEST_SOURCE
2129: FND_MESSAGE.set_name('RRS', 'RRS_HIER_SAME_DEST_SOURCE');
2130: FND_MSG_PUB.add;
2131: --dbms_output.put_line('dest hier cannot be the same as source hier');
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;

Line 2150: FND_MESSAGE.set_name('RRS', 'RRS_PARENT_DEST_UNDER_SOURCE');

2146: WHERE CHILD_MEMBER_ID = v_dest_parent_id;
2147:
2148: IF v_count <> 0 THEN
2149: --RRS_PARENT_DEST_UNDER_SOURCE
2150: FND_MESSAGE.set_name('RRS', 'RRS_PARENT_DEST_UNDER_SOURCE');
2151: FND_MSG_PUB.add;
2152: --dbms_output.put_line('Cannot move a site/node under its child');
2153: RAISE FND_API.G_EXC_ERROR;
2154: END IF;

Line 2172: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');

2168: AND SITE_GROUP_ID = v_dest_hier_id;
2169:
2170: IF v_count <> 0 THEN
2171: --RRS_HIER_CHILD_EXISTS
2172: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
2173: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2174: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2175: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
2176: FND_MSG_PUB.add;

Line 2173: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);

2169:
2170: IF v_count <> 0 THEN
2171: --RRS_HIER_CHILD_EXISTS
2172: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
2173: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2174: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2175: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
2176: FND_MSG_PUB.add;
2177: --dbms_output.put_line('Child already exists in the destination hierarchy ');

Line 2174: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);

2170: IF v_count <> 0 THEN
2171: --RRS_HIER_CHILD_EXISTS
2172: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
2173: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2174: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2175: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
2176: FND_MSG_PUB.add;
2177: --dbms_output.put_line('Child already exists in the destination hierarchy ');
2178: RAISE FND_API.G_EXC_ERROR;

Line 2175: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);

2171: --RRS_HIER_CHILD_EXISTS
2172: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
2173: FND_MESSAGE.set_token('NUM', p_hier_members_rec.child_id_number);
2174: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.child_object_type);
2175: FND_MESSAGE.set_token('HIERARCHY_NAME', p_hier_members_rec.dest_hier_name);
2176: FND_MSG_PUB.add;
2177: --dbms_output.put_line('Child already exists in the destination hierarchy ');
2178: RAISE FND_API.G_EXC_ERROR;
2179: END IF;

Line 2198: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NODE_NAME');

2194: AND RSGNV.NAME = v_child_name;
2195:
2196: IF v_count <> 0 THEN
2197: --RRS_DUPLICATED_NODE_NAME
2198: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NODE_NAME');
2199: FND_MESSAGE.set_token('NODE_NAME', v_child_name);
2200: FND_MSG_PUB.add;
2201: --dbms_output.put_line('Duplicated node names under the dest parent');
2202: RAISE FND_API.G_EXC_ERROR;

Line 2199: FND_MESSAGE.set_token('NODE_NAME', v_child_name);

2195:
2196: IF v_count <> 0 THEN
2197: --RRS_DUPLICATED_NODE_NAME
2198: FND_MESSAGE.set_name('RRS', 'RRS_DUPLICATED_NODE_NAME');
2199: FND_MESSAGE.set_token('NODE_NAME', v_child_name);
2200: FND_MSG_PUB.add;
2201: --dbms_output.put_line('Duplicated node names under the dest parent');
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;

Line 2333: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');

2329: END LOOP;
2330:
2331: ELSE
2332: --RRS_INVALID_TYPE
2333: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
2334: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.transaction_type);
2335: FND_MSG_PUB.add;
2336: --dbms_output.put_line('invalid transaction type');
2337: RAISE FND_API.G_EXC_ERROR;

Line 2334: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.transaction_type);

2330:
2331: ELSE
2332: --RRS_INVALID_TYPE
2333: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
2334: FND_MESSAGE.set_token('TYPE', p_hier_members_rec.transaction_type);
2335: FND_MSG_PUB.add;
2336: --dbms_output.put_line('invalid transaction type');
2337: RAISE FND_API.G_EXC_ERROR;
2338: END IF;

Line 2411: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_ID_FOUND');

2407: WHERE RSGV.SITE_GROUP_ID = p_hier_id;
2408: EXCEPTION
2409: WHEN NO_DATA_FOUND THEN
2410: --RRS_NO_HIER_ID_FOUND
2411: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_ID_FOUND');
2412: FND_MESSAGE.set_token('ID', p_hier_id);
2413: FND_MSG_PUB.add;
2414: --dbms_output.put_line('invalid dest hier id: '||p_hier_id);
2415: RAISE FND_API.G_EXC_ERROR;

Line 2412: FND_MESSAGE.set_token('ID', p_hier_id);

2408: EXCEPTION
2409: WHEN NO_DATA_FOUND THEN
2410: --RRS_NO_HIER_ID_FOUND
2411: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_ID_FOUND');
2412: FND_MESSAGE.set_token('ID', p_hier_id);
2413: FND_MSG_PUB.add;
2414: --dbms_output.put_line('invalid dest hier id: '||p_hier_id);
2415: RAISE FND_API.G_EXC_ERROR;
2416: END;

Line 2517: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_ID_FOUND');

2513: WHERE RSGV.SITE_GROUP_ID = p_hier_id;
2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN
2516: --RRS_NO_HIER_ID_FOUND
2517: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_ID_FOUND');
2518: FND_MESSAGE.set_token('ID', p_hier_id);
2519: FND_MSG_PUB.add;
2520: --dbms_output.put_line('invalid dest hier id: '||p_hier_id);
2521: RAISE FND_API.G_EXC_ERROR;

Line 2518: FND_MESSAGE.set_token('ID', p_hier_id);

2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN
2516: --RRS_NO_HIER_ID_FOUND
2517: FND_MESSAGE.set_name('RRS', 'RRS_NO_HIER_ID_FOUND');
2518: FND_MESSAGE.set_token('ID', p_hier_id);
2519: FND_MSG_PUB.add;
2520: --dbms_output.put_line('invalid dest hier id: '||p_hier_id);
2521: RAISE FND_API.G_EXC_ERROR;
2522: END;

Line 2536: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');

2532: AND RSU.IS_PRIMARY_FLAG(+) = 'Y';
2533: EXCEPTION
2534: WHEN NO_DATA_FOUND THEN
2535: --RRS_NO_SITE_FOUND
2536: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');
2537: FND_MESSAGE.set_token('SITE_ID_NUM', p_parent_id);
2538: FND_MSG_PUB.add;
2539: RAISE FND_API.G_EXC_ERROR;
2540: END;

Line 2537: FND_MESSAGE.set_token('SITE_ID_NUM', p_parent_id);

2533: EXCEPTION
2534: WHEN NO_DATA_FOUND THEN
2535: --RRS_NO_SITE_FOUND
2536: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');
2537: FND_MESSAGE.set_token('SITE_ID_NUM', p_parent_id);
2538: FND_MSG_PUB.add;
2539: RAISE FND_API.G_EXC_ERROR;
2540: END;
2541: ELSIF p_parent_object_type = 'NODE' THEN

Line 2550: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');

2546: WHERE SITE_GROUP_NODE_ID = p_parent_id;
2547: EXCEPTION
2548: WHEN NO_DATA_FOUND THEN
2549: --RRS_NO_NODE_FOUND
2550: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');
2551: FND_MESSAGE.set_token('NODE_ID_NUM', p_parent_id);
2552: FND_MSG_PUB.add;
2553: RAISE FND_API.G_EXC_ERROR;
2554: END;

Line 2551: FND_MESSAGE.set_token('NODE_ID_NUM', p_parent_id);

2547: EXCEPTION
2548: WHEN NO_DATA_FOUND THEN
2549: --RRS_NO_NODE_FOUND
2550: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');
2551: FND_MESSAGE.set_token('NODE_ID_NUM', p_parent_id);
2552: FND_MSG_PUB.add;
2553: RAISE FND_API.G_EXC_ERROR;
2554: END;
2555: ELSE

Line 2557: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');

2553: RAISE FND_API.G_EXC_ERROR;
2554: END;
2555: ELSE
2556: --RRS_INVALID_TYPE
2557: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
2558: FND_MESSAGE.set_token('TYPE', p_parent_object_type);
2559: FND_MSG_PUB.add;
2560: RAISE FND_API.G_EXC_ERROR;
2561: END IF;

Line 2558: FND_MESSAGE.set_token('TYPE', p_parent_object_type);

2554: END;
2555: ELSE
2556: --RRS_INVALID_TYPE
2557: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
2558: FND_MESSAGE.set_token('TYPE', p_parent_object_type);
2559: FND_MSG_PUB.add;
2560: RAISE FND_API.G_EXC_ERROR;
2561: END IF;
2562:

Line 2574: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');

2570: AND RSU.IS_PRIMARY_FLAG(+) = 'Y';
2571: EXCEPTION
2572: WHEN NO_DATA_FOUND THEN
2573: --RRS_NO_SITE_FOUND
2574: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');
2575: FND_MESSAGE.set_token('SITE_ID_NUM', p_child_id);
2576: FND_MSG_PUB.add;
2577: RAISE FND_API.G_EXC_ERROR;
2578: END;

Line 2575: FND_MESSAGE.set_token('SITE_ID_NUM', p_child_id);

2571: EXCEPTION
2572: WHEN NO_DATA_FOUND THEN
2573: --RRS_NO_SITE_FOUND
2574: FND_MESSAGE.set_name('RRS', 'RRS_NO_SITE_FOUND');
2575: FND_MESSAGE.set_token('SITE_ID_NUM', p_child_id);
2576: FND_MSG_PUB.add;
2577: RAISE FND_API.G_EXC_ERROR;
2578: END;
2579: ELSIF p_child_object_type = 'NODE' THEN

Line 2588: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');

2584: WHERE SITE_GROUP_NODE_ID = p_child_id;
2585: EXCEPTION
2586: WHEN NO_DATA_FOUND THEN
2587: --RRS_NO_NODE_FOUND
2588: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');
2589: FND_MESSAGE.set_token('NODE_ID_NUM', p_child_id);
2590: FND_MSG_PUB.add;
2591: RAISE FND_API.G_EXC_ERROR;
2592: END;

Line 2589: FND_MESSAGE.set_token('NODE_ID_NUM', p_child_id);

2585: EXCEPTION
2586: WHEN NO_DATA_FOUND THEN
2587: --RRS_NO_NODE_FOUND
2588: FND_MESSAGE.set_name('RRS', 'RRS_NO_NODE_FOUND');
2589: FND_MESSAGE.set_token('NODE_ID_NUM', p_child_id);
2590: FND_MSG_PUB.add;
2591: RAISE FND_API.G_EXC_ERROR;
2592: END;
2593: ELSE

Line 2595: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');

2591: RAISE FND_API.G_EXC_ERROR;
2592: END;
2593: ELSE
2594: --RRS_INVALID_TYPE
2595: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
2596: FND_MESSAGE.set_token('TYPE', p_child_object_type);
2597: FND_MSG_PUB.add;
2598: RAISE FND_API.G_EXC_ERROR;
2599: END IF;

Line 2596: FND_MESSAGE.set_token('TYPE', p_child_object_type);

2592: END;
2593: ELSE
2594: --RRS_INVALID_TYPE
2595: FND_MESSAGE.set_name('RRS', 'RRS_INVALID_TYPE');
2596: FND_MESSAGE.set_token('TYPE', p_child_object_type);
2597: FND_MSG_PUB.add;
2598: RAISE FND_API.G_EXC_ERROR;
2599: END IF;
2600:

Line 2609: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');

2605: WHERE CHILD_MEMBER_ID = p_child_id
2606: AND SITE_GROUP_ID = p_hier_id;
2607: IF v_count <> 0 THEN
2608: --RRS_HIER_CHILD_EXISTS
2609: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
2610: FND_MESSAGE.set_token('NUM', v_child_id_number);
2611: FND_MESSAGE.set_token('TYPE', p_child_object_type);
2612: FND_MESSAGE.set_token('HIERARCHY_NAME', v_hier_name);
2613: FND_MSG_PUB.add;

Line 2610: FND_MESSAGE.set_token('NUM', v_child_id_number);

2606: AND SITE_GROUP_ID = p_hier_id;
2607: IF v_count <> 0 THEN
2608: --RRS_HIER_CHILD_EXISTS
2609: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
2610: FND_MESSAGE.set_token('NUM', v_child_id_number);
2611: FND_MESSAGE.set_token('TYPE', p_child_object_type);
2612: FND_MESSAGE.set_token('HIERARCHY_NAME', v_hier_name);
2613: FND_MSG_PUB.add;
2614: --dbms_output.put_line('Child already exists in the destination hierarchy: '||v_child_id_number);

Line 2611: FND_MESSAGE.set_token('TYPE', p_child_object_type);

2607: IF v_count <> 0 THEN
2608: --RRS_HIER_CHILD_EXISTS
2609: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
2610: FND_MESSAGE.set_token('NUM', v_child_id_number);
2611: FND_MESSAGE.set_token('TYPE', p_child_object_type);
2612: FND_MESSAGE.set_token('HIERARCHY_NAME', v_hier_name);
2613: FND_MSG_PUB.add;
2614: --dbms_output.put_line('Child already exists in the destination hierarchy: '||v_child_id_number);
2615: RAISE FND_API.G_EXC_ERROR;

Line 2612: FND_MESSAGE.set_token('HIERARCHY_NAME', v_hier_name);

2608: --RRS_HIER_CHILD_EXISTS
2609: FND_MESSAGE.set_name('RRS', 'RRS_HIER_CHILD_EXISTS');
2610: FND_MESSAGE.set_token('NUM', v_child_id_number);
2611: FND_MESSAGE.set_token('TYPE', p_child_object_type);
2612: FND_MESSAGE.set_token('HIERARCHY_NAME', v_hier_name);
2613: FND_MSG_PUB.add;
2614: --dbms_output.put_line('Child already exists in the destination hierarchy: '||v_child_id_number);
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;