DBA Data[Home] [Help]

APPS.CZ_CONFIG_API_PVT dependencies on FND_API

Line 1141: IF (NOT FND_API.compatible_api_call(l_api_version

1137: BEGIN
1138: SAVEPOINT start_transaction;
1139:
1140: -- standard call to check for call compatibility
1141: IF (NOT FND_API.compatible_api_call(l_api_version
1142: ,p_api_version
1143: ,l_api_name
1144: ,G_PKG_NAME
1145: )) THEN

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1142: ,p_api_version
1143: ,l_api_name
1144: ,G_PKG_NAME
1145: )) THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: IF ((p_copy_mode IS NULL) OR (p_copy_mode <> CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND
1150: p_copy_mode <> CZ_API_PUB.G_NEW_REVISION_COPY_MODE)) THEN

Line 1157: RAISE FND_API.G_EXC_ERROR;

1153: FND_MESSAGE.SET_TOKEN('PROC', l_api_name);
1154: FND_MSG_PUB.ADD;
1155: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1156: p_data => x_msg_data);
1157: RAISE FND_API.G_EXC_ERROR;
1158: END IF;
1159:
1160: BEGIN
1161: SELECT model_instantiation_type, component_instance_type, deleted_flag

Line 1171: RAISE FND_API.G_EXC_ERROR;

1167: EXCEPTION
1168: WHEN NO_DATA_FOUND THEN
1169: fnd_message.set_name('CZ', 'CZ_CFG_COPY_NO_CONFIG');
1170: fnd_msg_pub.add;
1171: RAISE FND_API.G_EXC_ERROR;
1172: END;
1173:
1174: IF( l_deleted_flag = '1') THEN
1175: IF (p_handle_deleted_flag IS NULL) THEN

Line 1178: RAISE FND_API.G_EXC_ERROR;

1174: IF( l_deleted_flag = '1') THEN
1175: IF (p_handle_deleted_flag IS NULL) THEN
1176: fnd_message.set_name('CZ', 'CZ_CFG_COPY_DELETED_CONFIG');
1177: fnd_msg_pub.add;
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSIF (p_handle_deleted_flag = '0') THEN
1180: UPDATE CZ_CONFIG_HDRS SET DELETED_FLAG = '0'
1181: WHERE CONFIG_HDR_ID = p_config_hdr_id
1182: AND CONFIG_REV_NBR = p_config_rev_nbr;

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190: fnd_message.set_token('id', p_config_hdr_id);
1191: fnd_message.set_token('revision', p_config_rev_nbr);
1192: fnd_message.set_token('type', l_component_instance_type);
1193: fnd_msg_pub.add;
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: IF (p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1198: l_new_config_hdr_id := p_config_hdr_id;

Line 1283: RAISE FND_API.G_EXC_ERROR;

1279: fnd_message.set_name('CZ', 'CZ_CFG_COPY_IB');
1280: fnd_message.set_token('id', l_new_config_hdr_id);
1281: fnd_message.set_token('revision', l_new_config_rev_nbr);
1282: fnd_msg_pub.add;
1283: RAISE FND_API.G_EXC_ERROR;
1284: END IF;
1285: END IF;
1286:
1287: x_config_hdr_id := l_new_config_hdr_id;

Line 1305: x_return_status := FND_API.G_RET_STS_SUCCESS;

1301: l_index := l_item_id_map.NEXT(l_index);
1302: END LOOP;
1303: END IF;
1304:
1305: x_return_status := FND_API.G_RET_STS_SUCCESS;
1306: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1307: p_data => x_msg_data);
1308:
1309: EXCEPTION

Line 1310: WHEN FND_API.G_EXC_ERROR THEN

1306: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1307: p_data => x_msg_data);
1308:
1309: EXCEPTION
1310: WHEN FND_API.G_EXC_ERROR THEN
1311: x_return_status := FND_API.G_RET_STS_ERROR;
1312: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1313: p_data => x_msg_data);
1314: ROLLBACK TO start_transaction;

Line 1311: x_return_status := FND_API.G_RET_STS_ERROR;

1307: p_data => x_msg_data);
1308:
1309: EXCEPTION
1310: WHEN FND_API.G_EXC_ERROR THEN
1311: x_return_status := FND_API.G_RET_STS_ERROR;
1312: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1313: p_data => x_msg_data);
1314: ROLLBACK TO start_transaction;
1315:

Line 1316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1312: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1313: p_data => x_msg_data);
1314: ROLLBACK TO start_transaction;
1315:
1316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1319: p_data => x_msg_data);
1320: ROLLBACK TO start_transaction;

Line 1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1313: p_data => x_msg_data);
1314: ROLLBACK TO start_transaction;
1315:
1316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1319: p_data => x_msg_data);
1320: ROLLBACK TO start_transaction;
1321:

Line 1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1319: p_data => x_msg_data);
1320: ROLLBACK TO start_transaction;
1321:
1322: WHEN OTHERS THEN
1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1325: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1326: END IF;
1327:

Line 1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1369: COMMIT;
1370:
1371: EXCEPTION
1372: WHEN OTHERS THEN
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1375: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1376: END IF;
1377: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1402: IF (NOT FND_API.compatible_api_call(l_api_version

1398: l_config_status cz_config_hdrs.config_status%TYPE;
1399: l_dummy INTEGER;
1400:
1401: BEGIN
1402: IF (NOT FND_API.compatible_api_call(l_api_version
1403: ,p_api_version
1404: ,l_api_name
1405: ,G_PKG_NAME
1406: )) THEN

Line 1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1403: ,p_api_version
1404: ,l_api_name
1405: ,G_PKG_NAME
1406: )) THEN
1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1408: END IF;
1409:
1410: BEGIN
1411: SELECT component_instance_type, config_status

Line 1425: RAISE FND_API.G_EXC_ERROR;

1421: fnd_message.set_token('id', p_config_hdr_id);
1422: fnd_message.set_token('revision', p_config_rev_nbr);
1423: fnd_message.set_token('type', l_component_instance_type);
1424: fnd_msg_pub.add;
1425: RAISE FND_API.G_EXC_ERROR;
1426: END IF;
1427:
1428: x_exists_flag := FND_API.G_TRUE;
1429: x_complete_flag := FND_API.G_TRUE;

Line 1428: x_exists_flag := FND_API.G_TRUE;

1424: fnd_msg_pub.add;
1425: RAISE FND_API.G_EXC_ERROR;
1426: END IF;
1427:
1428: x_exists_flag := FND_API.G_TRUE;
1429: x_complete_flag := FND_API.G_TRUE;
1430: IF (l_config_status <> CONFIG_STATUS_COMPLETE) THEN
1431: x_complete_flag := FND_API.G_FALSE;
1432: END IF;

Line 1429: x_complete_flag := FND_API.G_TRUE;

1425: RAISE FND_API.G_EXC_ERROR;
1426: END IF;
1427:
1428: x_exists_flag := FND_API.G_TRUE;
1429: x_complete_flag := FND_API.G_TRUE;
1430: IF (l_config_status <> CONFIG_STATUS_COMPLETE) THEN
1431: x_complete_flag := FND_API.G_FALSE;
1432: END IF;
1433:

Line 1431: x_complete_flag := FND_API.G_FALSE;

1427:
1428: x_exists_flag := FND_API.G_TRUE;
1429: x_complete_flag := FND_API.G_TRUE;
1430: IF (l_config_status <> CONFIG_STATUS_COMPLETE) THEN
1431: x_complete_flag := FND_API.G_FALSE;
1432: END IF;
1433:
1434: BEGIN
1435: SELECT 1 INTO l_dummy

Line 1458: x_valid_flag := FND_API.G_FALSE;

1454: G_CUSTOM_VAL_FAILURE
1455: )
1456: AND ROWNUM < 2;
1457:
1458: x_valid_flag := FND_API.G_FALSE;
1459:
1460: EXCEPTION
1461: WHEN NO_DATA_FOUND THEN
1462: x_valid_flag := FND_API.G_TRUE;

Line 1462: x_valid_flag := FND_API.G_TRUE;

1458: x_valid_flag := FND_API.G_FALSE;
1459:
1460: EXCEPTION
1461: WHEN NO_DATA_FOUND THEN
1462: x_valid_flag := FND_API.G_TRUE;
1463: END;
1464:
1465: EXCEPTION
1466: WHEN NO_DATA_FOUND THEN

Line 1467: x_exists_flag := FND_API.G_FALSE;

1463: END;
1464:
1465: EXCEPTION
1466: WHEN NO_DATA_FOUND THEN
1467: x_exists_flag := FND_API.G_FALSE;
1468:
1469: END;
1470:
1471: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1471: x_return_status := FND_API.G_RET_STS_SUCCESS;

1467: x_exists_flag := FND_API.G_FALSE;
1468:
1469: END;
1470:
1471: x_return_status := FND_API.G_RET_STS_SUCCESS;
1472:
1473: EXCEPTION
1474: WHEN FND_API.G_EXC_ERROR THEN
1475: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1474: WHEN FND_API.G_EXC_ERROR THEN

1470:
1471: x_return_status := FND_API.G_RET_STS_SUCCESS;
1472:
1473: EXCEPTION
1474: WHEN FND_API.G_EXC_ERROR THEN
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476:
1477: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1478: p_data => x_msg_data);

Line 1475: x_return_status := FND_API.G_RET_STS_ERROR;

1471: x_return_status := FND_API.G_RET_STS_SUCCESS;
1472:
1473: EXCEPTION
1474: WHEN FND_API.G_EXC_ERROR THEN
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476:
1477: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1478: p_data => x_msg_data);
1479:

Line 1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1476:
1477: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1478: p_data => x_msg_data);
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1483: p_data => x_msg_data);
1484:

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1477: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1478: p_data => x_msg_data);
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1483: p_data => x_msg_data);
1484:
1485: WHEN OTHERS THEN

Line 1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1482: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1483: p_data => x_msg_data);
1484:
1485: WHEN OTHERS THEN
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1488: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1489: END IF;
1490: