166: l_header_status VARCHAR2(30);
167:
168: BEGIN
169:
170: -- Standard start of API savepoint
171: SAVEPOINT Create_Node_SP;
172:
173: -- Standard call to check for call compatibility
174: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
169:
170: -- Standard start of API savepoint
171: SAVEPOINT Create_Node_SP;
172:
173: -- Standard call to check for call compatibility
174: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
175: THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
459: IF x_msg_count > 0 THEN
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: -- Standard check for p_commit
464: IF FND_API.TO_BOOLEAN (p_commit)
465: THEN
466: COMMIT WORK;
467: END IF;
465: THEN
466: COMMIT WORK;
467: END IF;
468:
469: -- Standard call to get message count and if count is 1, get message info
470: FND_MSG_PUB.count_and_get
471: (
472: p_count => x_msg_count,
473: p_data => x_msg_data,
620: l_get_ata_leaf_node_rec get_ata_for_leaf_node%rowtype;
621:
622: BEGIN
623:
624: -- Standard start of API savepoint
625: SAVEPOINT Modify_Node_SP;
626:
627: -- Standard call to check for call compatibility
628: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
623:
624: -- Standard start of API savepoint
625: SAVEPOINT Modify_Node_SP;
626:
627: -- Standard call to check for call compatibility
628: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
629: THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
1019: END IF;
1020: CLOSE check_leaf_node;
1021: END IF; -- condition for DML Update
1022:
1023: -- Standard check for p_commit
1024: IF FND_API.TO_BOOLEAN (p_commit)
1025: THEN
1026: COMMIT WORK;
1027: END IF;
1032: IF ( x_msg_count > 0 and x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035:
1036: -- Standard call to get message count and if count is 1, get message info
1037: FND_MSG_PUB.count_and_get
1038: (
1039: p_count => x_msg_count,
1040: p_data => x_msg_data,
1120: l_header_status VARCHAR2(30);
1121:
1122: BEGIN
1123:
1124: -- Standard start of API savepoint
1125: SAVEPOINT Delete_Node_SP;
1126:
1127: -- Standard call to check for call compatibility
1128: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1123:
1124: -- Standard start of API savepoint
1125: SAVEPOINT Delete_Node_SP;
1126:
1127: -- Standard call to check for call compatibility
1128: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1129: THEN
1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1257: IF x_msg_count > 0 THEN
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260:
1261: -- Standard check for p_commit
1262: IF FND_API.TO_BOOLEAN (p_commit)
1263: THEN
1264: COMMIT WORK;
1265: END IF;
1263: THEN
1264: COMMIT WORK;
1265: END IF;
1266:
1267: -- Standard call to get message count and if count is 1, get message info
1268: FND_MSG_PUB.count_and_get
1269: (
1270: p_count => x_msg_count,
1271: p_data => x_msg_data,
1339: l_header_status VARCHAR2(30);
1340:
1341: BEGIN
1342:
1343: -- Standard start of API savepoint
1344: SAVEPOINT Copy_Node_SP;
1345:
1346: -- Standard call to check for call compatibility
1347: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1342:
1343: -- Standard start of API savepoint
1344: SAVEPOINT Copy_Node_SP;
1345:
1346: -- Standard call to check for call compatibility
1347: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1348: THEN
1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1350: END IF;
1459: IF x_msg_count > 0 THEN
1460: RAISE FND_API.G_EXC_ERROR;
1461: END IF;
1462:
1463: -- Standard check for p_commit
1464: IF FND_API.TO_BOOLEAN (p_commit)
1465: THEN
1466: COMMIT WORK;
1467: END IF;
1465: THEN
1466: COMMIT WORK;
1467: END IF;
1468:
1469: -- Standard call to get message count and if count is 1, get message info
1470: FND_MSG_PUB.count_and_get
1471: (
1472: p_count => x_msg_count,
1473: p_data => x_msg_data,
1628: l_max_dispord NUMBER;
1629:
1630: BEGIN
1631:
1632: -- Standard start of API savepoint
1633: SAVEPOINT Copy_MC_Nodes_SP;
1634:
1635: -- Standard call to check for call compatibility
1636: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1631:
1632: -- Standard start of API savepoint
1633: SAVEPOINT Copy_MC_Nodes_SP;
1634:
1635: -- Standard call to check for call compatibility
1636: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1637: THEN
1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
2035: IF x_msg_count > 0 THEN
2036: RAISE FND_API.G_EXC_ERROR;
2037: END IF;
2038:
2039: -- Standard check for p_commit
2040: IF FND_API.TO_BOOLEAN (p_commit)
2041: THEN
2042: COMMIT WORK;
2043: END IF;
2041: THEN
2042: COMMIT WORK;
2043: END IF;
2044:
2045: -- Standard call to get message count and if count is 1, get message info
2046: FND_MSG_PUB.count_and_get
2047: (
2048: p_count => x_msg_count,
2049: p_data => x_msg_data,
2116: l_header_status VARCHAR2(30);
2117:
2118: BEGIN
2119:
2120: -- Standard start of API savepoint
2121: SAVEPOINT Process_Documents_SP;
2122:
2123: -- Standard call to check for call compatibility
2124: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2119:
2120: -- Standard start of API savepoint
2121: SAVEPOINT Process_Documents_SP;
2122:
2123: -- Standard call to check for call compatibility
2124: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2125: THEN
2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2127: END IF;
2259: IF x_msg_count > 0 THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;
2262:
2263: -- Standard check for p_commit
2264: IF FND_API.TO_BOOLEAN (p_commit)
2265: THEN
2266: COMMIT WORK;
2267: END IF;
2265: THEN
2266: COMMIT WORK;
2267: END IF;
2268:
2269: -- Standard call to get message count and if count is 1, get message info
2270: FND_MSG_PUB.count_and_get
2271: (
2272: p_count => x_msg_count,
2273: p_data => x_msg_data,
2360: l_item_group_name VARCHAR2(80);
2361:
2362: BEGIN
2363:
2364: -- Standard start of API savepoint
2365: SAVEPOINT Associate_Item_Group_SP;
2366:
2367: -- Standard call to check for call compatibility
2368: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2363:
2364: -- Standard start of API savepoint
2365: SAVEPOINT Associate_Item_Group_SP;
2366:
2367: -- Standard call to check for call compatibility
2368: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2369: THEN
2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371: END IF;
2535: IF x_msg_count > 0 THEN
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;
2538:
2539: -- Standard check for p_commit
2540: IF FND_API.TO_BOOLEAN (p_commit)
2541: THEN
2542: COMMIT WORK;
2543: END IF;
2541: THEN
2542: COMMIT WORK;
2543: END IF;
2544:
2545: -- Standard call to get message count and if count is 1, get message info
2546: FND_MSG_PUB.count_and_get
2547: (
2548: p_count => x_msg_count,
2549: p_data => x_msg_data,