APPS.RRS_HIERARCHY_CRUD_PKG dependencies on FND_MSG_PUB

Line 34: FND_MSG_PUB.add;

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:
38: BEGIN

Line 48: FND_MSG_PUB.add;

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

Line 72: FND_MSG_PUB.add;

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;
76: END IF;

Line 88: FND_MSG_PUB.add;

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;
92: END IF;

Line 97: FND_MSG_PUB.add;

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

Line 129: FND_MSG_PUB.add;

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
133: --RRS_END_DATE_PAST_ERR

Line 135: FND_MSG_PUB.add;

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
139: AND v_start_date > v_end_date THEN

Line 142: FND_MSG_PUB.add;

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:
146: --dbms_output.put_line('before update site group');

Line 193: x_msg_count := FND_MSG_PUB.Count_Msg;

189:
190: EXCEPTION
191: WHEN FND_API.G_EXC_ERROR THEN
192: ROLLBACK TO Update_Hierarchy_Header;
193: x_msg_count := FND_MSG_PUB.Count_Msg;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: WHEN OTHERS THEN
196: ROLLBACK TO Update_Hierarchy_Header;
197: x_msg_data := G_PKG_NAME || '.Update_Hierarchy_Header:' || SQLERRM;

Line 226: FND_MSG_PUB.add;

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:
230: BEGIN

Line 240: FND_MSG_PUB.add;

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

Line 248: FND_MSG_PUB.add;

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

Line 270: FND_MSG_PUB.add;

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;
274: END IF;

Line 279: FND_MSG_PUB.add;

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

Line 314: x_msg_count := FND_MSG_PUB.Count_Msg;

310:
311: EXCEPTION
312: WHEN FND_API.G_EXC_ERROR THEN
313: ROLLBACK TO Update_Hierarchy_Node;
314: x_msg_count := FND_MSG_PUB.Count_Msg;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: WHEN OTHERS THEN
317: ROLLBACK TO Update_Hierarchy_Node;
318: x_msg_data := G_PKG_NAME || '.Update_Hierarchy_Node:' || SQLERRM;

Line 344: FND_MSG_PUB.add;

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

Line 358: FND_MSG_PUB.add;

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

Line 378: FND_MSG_PUB.add;

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;
382: END IF;

Line 388: FND_MSG_PUB.add;

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

Line 464: --x_msg_count := FND_MSG_PUB.Count_Msg;

460: COMMIT;
461: END IF;
462:
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464: --x_msg_count := FND_MSG_PUB.Count_Msg;
465:
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO Create_Hierarchy_Node;

Line 469: x_msg_count := FND_MSG_PUB.Count_Msg;

465:
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO Create_Hierarchy_Node;
469: x_msg_count := FND_MSG_PUB.Count_Msg;
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: WHEN OTHERS THEN
472: ROLLBACK TO Create_Hierarchy_Node;
473: x_msg_data := G_PKG_NAME || '.Create_Hierarchy_Node:' || SQLERRM;

Line 504: FND_MSG_PUB.add;

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:
508: --check if the hierarchy already exists

Line 518: FND_MSG_PUB.add;

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;
522: --validate the hierarchy purpose code

Line 538: FND_MSG_PUB.add;

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

Line 548: FND_MSG_PUB.add;

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
552: --RRS_END_DATE_PAST_ERR

Line 554: FND_MSG_PUB.add;

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
558: AND p_hier_start_date > p_hier_end_date THEN

Line 561: FND_MSG_PUB.add;

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:
565: --retrieve new site group id from the sequence

Line 762: x_msg_count := FND_MSG_PUB.Count_Msg;

758:
759: EXCEPTION
760: WHEN FND_API.G_EXC_ERROR THEN
761: ROLLBACK TO Create_Hierarchy_Coarse;
762: x_msg_count := FND_MSG_PUB.Count_Msg;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO Create_Hierarchy_Coarse;
766: x_msg_data := G_PKG_NAME || '.Create_Hierarchy_Coarse:' || x_msg_data;

Line 823: FND_MSG_PUB.add;

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;
827: CLOSE validate_rules_cursor;

Line 886: FND_MSG_PUB.add;

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;
890: END IF;

Line 1085: FND_MSG_PUB.add;

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

Line 1134: FND_MSG_PUB.add;

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
1138: --RRS_MANY_ROOTS_FOUND

Line 1140: FND_MSG_PUB.add;

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

Line 1150: FND_MSG_PUB.add;

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

Line 1158: FND_MSG_PUB.add;

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

Line 1174: FND_MSG_PUB.add;

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

Line 1202: FND_MSG_PUB.add;

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

Line 1218: FND_MSG_PUB.add;

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;
1222: CLOSE validate_p_id_num_cursor;

Line 1232: FND_MSG_PUB.add;

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;
1236: CLOSE validate_c_id_num_cursor;

Line 1256: FND_MSG_PUB.add;

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;
1260: CLOSE validate_p_id_cursor;

Line 1270: FND_MSG_PUB.add;

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;
1274: CLOSE validate_c_id_cursor;

Line 1364: FND_MSG_PUB.add;

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;
1368: CLOSE validate_dup_number_cursor;

Line 1384: FND_MSG_PUB.add;

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;
1388: CLOSE validate_num_cursor;

Line 1403: FND_MSG_PUB.add;

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;
1407: CLOSE validate_site_template_cursor;

Line 1422: FND_MSG_PUB.add;

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;
1426: CLOSE validate_p_in_hier_curosr;

Line 1441: FND_MSG_PUB.add;

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;
1445: CLOSE validate_node_name_cursor;

Line 1553: x_msg_count := FND_MSG_PUB.Count_Msg;

1549:
1550: EXCEPTION
1551: WHEN FND_API.G_EXC_ERROR THEN
1552: ROLLBACK TO Create_Hierarchy_Members;
1553: x_msg_count := FND_MSG_PUB.Count_Msg;
1554: x_return_status := FND_API.G_RET_STS_ERROR;
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: ROLLBACK TO Create_Hierarchy_Members;
1557: x_msg_data := G_PKG_NAME || '.Create_Hierarchy_Members:' || x_msg_data;

Line 1594: FND_MSG_PUB.add;

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:
1598: BEGIN

Line 1608: FND_MSG_PUB.add;

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

Line 1625: FND_MSG_PUB.add;

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

Line 1640: FND_MSG_PUB.add;

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

Line 1716: x_msg_count := FND_MSG_PUB.Count_Msg;

1712:
1713: EXCEPTION
1714: WHEN FND_API.G_EXC_ERROR THEN
1715: ROLLBACK TO Update_Hierarchy_Coarse;
1716: x_msg_count := FND_MSG_PUB.Count_Msg;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1719: ROLLBACK TO Update_Hierarchy_Coarse;
1720: x_msg_data := G_PKG_NAME || '.Update_Hierarchy_Coarse:' || x_msg_data;

Line 1817: FND_MSG_PUB.add;

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;
1821: --get dest hier version id

Line 1833: FND_MSG_PUB.add;

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

Line 1847: FND_MSG_PUB.add;

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

Line 1863: FND_MSG_PUB.add;

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;
1867: IF v_child_purpose_code = 'ROOT' THEN

Line 1870: FND_MSG_PUB.add;

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;
1874: ELSIF p_hier_members_rec.child_object_type = 'SITE' THEN

Line 1887: FND_MSG_PUB.add;

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;
1891: IF v_flag = 'Y' THEN

Line 1895: FND_MSG_PUB.add;

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;
1899: ELSE

Line 1903: FND_MSG_PUB.add;

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

Line 1921: FND_MSG_PUB.add;

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

Line 1940: FND_MSG_PUB.add;

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;
1944: ELSIF p_hier_members_rec.dest_parent_object_type = 'SITE' THEN

Line 1960: FND_MSG_PUB.add;

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;
1964: ELSE

Line 1968: FND_MSG_PUB.add;

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

Line 1990: FND_MSG_PUB.add;

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

Line 2069: FND_MSG_PUB.add;

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

Line 2100: FND_MSG_PUB.add;

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

Line 2120: FND_MSG_PUB.add;

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

Line 2130: FND_MSG_PUB.add;

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

Line 2151: FND_MSG_PUB.add;

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;
2155: END IF;

Line 2176: FND_MSG_PUB.add;

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;
2180: END IF;

Line 2200: FND_MSG_PUB.add;

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;
2204: END IF;

Line 2335: FND_MSG_PUB.add;

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

Line 2349: x_msg_count := FND_MSG_PUB.Count_Msg;

2345:
2346: EXCEPTION
2347: WHEN FND_API.G_EXC_ERROR THEN
2348: ROLLBACK TO Update_Hierarchy_Fine;
2349: x_msg_count := FND_MSG_PUB.Count_Msg;
2350: x_return_status := FND_API.G_RET_STS_ERROR;
2351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2352: ROLLBACK TO Update_Hierarchy_Fine;
2353: x_msg_data := G_PKG_NAME || '.Update_Hierarchy_Fine:' || x_msg_data;

Line 2413: FND_MSG_PUB.add;

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

Line 2477: x_msg_count := FND_MSG_PUB.Count_Msg;

2473: x_return_status := FND_API.G_RET_STS_SUCCESS;
2474:
2475: EXCEPTION
2476: WHEN FND_API.G_EXC_ERROR THEN
2477: x_msg_count := FND_MSG_PUB.Count_Msg;
2478: x_return_status := FND_API.G_RET_STS_ERROR;
2479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2480: x_msg_data := G_PKG_NAME || '.Validate_Hierarchy_Status:' || x_msg_data;
2481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2519: FND_MSG_PUB.add;

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

Line 2538: FND_MSG_PUB.add;

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
2542: BEGIN

Line 2552: FND_MSG_PUB.add;

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
2556: --RRS_INVALID_TYPE

Line 2559: FND_MSG_PUB.add;

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:
2563: IF p_child_object_type = 'SITE' THEN

Line 2576: FND_MSG_PUB.add;

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
2580: BEGIN

Line 2590: FND_MSG_PUB.add;

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
2594: --RRS_INVALID_TYPE

Line 2597: FND_MSG_PUB.add;

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:
2601: --child id should not appear in the dest hier

Line 2613: FND_MSG_PUB.add;

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

Line 2650: x_msg_count := FND_MSG_PUB.Count_Msg;

2646: x_return_status := FND_API.G_RET_STS_SUCCESS;
2647:
2648: EXCEPTION
2649: WHEN FND_API.G_EXC_ERROR THEN
2650: x_msg_count := FND_MSG_PUB.Count_Msg;
2651: x_return_status := FND_API.G_RET_STS_ERROR;
2652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2653: x_msg_data := G_PKG_NAME || '.Validate_Hierarchy_Association:' || x_msg_data;
2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;