DBA Data[Home] [Help]

APPS.CZ_CONFIG_API_PUB dependencies on FND_API

Line 1029: IF (NOT FND_API.compatible_api_call(l_api_version

1025: BEGIN
1026: SAVEPOINT start_transaction;
1027:
1028: -- standard call to check for call compatibility
1029: IF (NOT FND_API.compatible_api_call(l_api_version
1030: ,p_api_version
1031: ,l_api_name
1032: ,G_PKG_NAME
1033: )) THEN

Line 1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1030: ,p_api_version
1031: ,l_api_name
1032: ,G_PKG_NAME
1033: )) THEN
1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1035: END IF;
1036:
1037: IF ((p_copy_mode IS NULL) OR (p_copy_mode <> CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND
1038: p_copy_mode <> CZ_API_PUB.G_NEW_REVISION_COPY_MODE)) THEN

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041: FND_MESSAGE.SET_TOKEN('PROC', l_api_name);
1042: FND_MSG_PUB.ADD;
1043: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1044: p_data => x_msg_data);
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048: BEGIN
1049: SELECT model_instantiation_type, component_instance_type, deleted_flag

Line 1059: RAISE FND_API.G_EXC_ERROR;

1055: EXCEPTION
1056: WHEN NO_DATA_FOUND THEN
1057: fnd_message.set_name('CZ', 'CZ_CFG_COPY_NO_CONFIG');
1058: fnd_msg_pub.add;
1059: RAISE FND_API.G_EXC_ERROR;
1060: END;
1061:
1062: IF( l_deleted_flag = '1') THEN
1063: IF (p_handle_deleted_flag IS NULL) THEN

Line 1066: RAISE FND_API.G_EXC_ERROR;

1062: IF( l_deleted_flag = '1') THEN
1063: IF (p_handle_deleted_flag IS NULL) THEN
1064: fnd_message.set_name('CZ', 'CZ_CFG_COPY_DELETED_CONFIG');
1065: fnd_msg_pub.add;
1066: RAISE FND_API.G_EXC_ERROR;
1067: ELSIF (p_handle_deleted_flag = '0') THEN
1068: UPDATE CZ_CONFIG_HDRS SET DELETED_FLAG = '0'
1069: WHERE CONFIG_HDR_ID = p_config_hdr_id
1070: AND CONFIG_REV_NBR = p_config_rev_nbr;

Line 1082: RAISE FND_API.G_EXC_ERROR;

1078: fnd_message.set_token('id', p_config_hdr_id);
1079: fnd_message.set_token('revision', p_config_rev_nbr);
1080: fnd_message.set_token('type', l_component_instance_type);
1081: fnd_msg_pub.add;
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084:
1085: IF (p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1086: l_new_config_hdr_id := p_config_hdr_id;

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157: fnd_message.set_name('CZ', 'CZ_CFG_COPY_IB');
1158: fnd_message.set_token('id', l_new_config_hdr_id);
1159: fnd_message.set_token('revision', l_new_config_rev_nbr);
1160: fnd_msg_pub.add;
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163: END IF;
1164:
1165: x_config_hdr_id := l_new_config_hdr_id;

Line 1183: x_return_status := FND_API.G_RET_STS_SUCCESS;

1179: l_index := l_item_id_map.NEXT(l_index);
1180: END LOOP;
1181: END IF;
1182:
1183: x_return_status := FND_API.G_RET_STS_SUCCESS;
1184: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1185: p_data => x_msg_data);
1186:
1187: EXCEPTION

Line 1188: WHEN FND_API.G_EXC_ERROR THEN

1184: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1185: p_data => x_msg_data);
1186:
1187: EXCEPTION
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: x_return_status := FND_API.G_RET_STS_ERROR;
1190: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1191: p_data => x_msg_data);
1192: ROLLBACK TO start_transaction;

Line 1189: x_return_status := FND_API.G_RET_STS_ERROR;

1185: p_data => x_msg_data);
1186:
1187: EXCEPTION
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: x_return_status := FND_API.G_RET_STS_ERROR;
1190: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1191: p_data => x_msg_data);
1192: ROLLBACK TO start_transaction;
1193:

Line 1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1190: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1191: p_data => x_msg_data);
1192: ROLLBACK TO start_transaction;
1193:
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1197: p_data => x_msg_data);
1198: ROLLBACK TO start_transaction;

Line 1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1191: p_data => x_msg_data);
1192: ROLLBACK TO start_transaction;
1193:
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1197: p_data => x_msg_data);
1198: ROLLBACK TO start_transaction;
1199:

Line 1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1197: p_data => x_msg_data);
1198: ROLLBACK TO start_transaction;
1199:
1200: WHEN OTHERS THEN
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1202: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1203: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1204: END IF;
1205:

Line 1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1247: COMMIT;
1248:
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1252: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1253: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1254: END IF;
1255: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1280: IF (NOT FND_API.compatible_api_call(l_api_version

1276: l_config_status cz_config_hdrs.config_status%TYPE;
1277: l_dummy INTEGER;
1278:
1279: BEGIN
1280: IF (NOT FND_API.compatible_api_call(l_api_version
1281: ,p_api_version
1282: ,l_api_name
1283: ,G_PKG_NAME
1284: )) THEN

Line 1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1281: ,p_api_version
1282: ,l_api_name
1283: ,G_PKG_NAME
1284: )) THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: END IF;
1287:
1288: BEGIN
1289: SELECT component_instance_type, config_status

Line 1303: RAISE FND_API.G_EXC_ERROR;

1299: fnd_message.set_token('id', p_config_hdr_id);
1300: fnd_message.set_token('revision', p_config_rev_nbr);
1301: fnd_message.set_token('type', l_component_instance_type);
1302: fnd_msg_pub.add;
1303: RAISE FND_API.G_EXC_ERROR;
1304: END IF;
1305:
1306: x_exists_flag := FND_API.G_TRUE;
1307: x_complete_flag := FND_API.G_TRUE;

Line 1306: x_exists_flag := FND_API.G_TRUE;

1302: fnd_msg_pub.add;
1303: RAISE FND_API.G_EXC_ERROR;
1304: END IF;
1305:
1306: x_exists_flag := FND_API.G_TRUE;
1307: x_complete_flag := FND_API.G_TRUE;
1308: IF (l_config_status <> CONFIG_STATUS_COMPLETE) THEN
1309: x_complete_flag := FND_API.G_FALSE;
1310: END IF;

Line 1307: x_complete_flag := FND_API.G_TRUE;

1303: RAISE FND_API.G_EXC_ERROR;
1304: END IF;
1305:
1306: x_exists_flag := FND_API.G_TRUE;
1307: x_complete_flag := FND_API.G_TRUE;
1308: IF (l_config_status <> CONFIG_STATUS_COMPLETE) THEN
1309: x_complete_flag := FND_API.G_FALSE;
1310: END IF;
1311:

Line 1309: x_complete_flag := FND_API.G_FALSE;

1305:
1306: x_exists_flag := FND_API.G_TRUE;
1307: x_complete_flag := FND_API.G_TRUE;
1308: IF (l_config_status <> CONFIG_STATUS_COMPLETE) THEN
1309: x_complete_flag := FND_API.G_FALSE;
1310: END IF;
1311:
1312: BEGIN
1313: SELECT 1 INTO l_dummy

Line 1320: x_valid_flag := FND_API.G_FALSE;

1316: AND config_rev_nbr = p_config_rev_nbr
1317: AND deleted_flag = '0'
1318: AND ROWNUM < 2;
1319:
1320: x_valid_flag := FND_API.G_FALSE;
1321:
1322: EXCEPTION
1323: WHEN NO_DATA_FOUND THEN
1324: x_valid_flag := FND_API.G_TRUE;

Line 1324: x_valid_flag := FND_API.G_TRUE;

1320: x_valid_flag := FND_API.G_FALSE;
1321:
1322: EXCEPTION
1323: WHEN NO_DATA_FOUND THEN
1324: x_valid_flag := FND_API.G_TRUE;
1325: END;
1326:
1327: EXCEPTION
1328: WHEN NO_DATA_FOUND THEN

Line 1329: x_exists_flag := FND_API.G_FALSE;

1325: END;
1326:
1327: EXCEPTION
1328: WHEN NO_DATA_FOUND THEN
1329: x_exists_flag := FND_API.G_FALSE;
1330:
1331: END;
1332:
1333: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1333: x_return_status := FND_API.G_RET_STS_SUCCESS;

1329: x_exists_flag := FND_API.G_FALSE;
1330:
1331: END;
1332:
1333: x_return_status := FND_API.G_RET_STS_SUCCESS;
1334:
1335: EXCEPTION
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1336: WHEN FND_API.G_EXC_ERROR THEN

1332:
1333: x_return_status := FND_API.G_RET_STS_SUCCESS;
1334:
1335: EXCEPTION
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338:
1339: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1340: p_data => x_msg_data);

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333: x_return_status := FND_API.G_RET_STS_SUCCESS;
1334:
1335: EXCEPTION
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338:
1339: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1340: p_data => x_msg_data);
1341:

Line 1342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1338:
1339: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1340: p_data => x_msg_data);
1341:
1342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1344: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1345: p_data => x_msg_data);
1346:

Line 1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1339: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1340: p_data => x_msg_data);
1341:
1342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1344: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1345: p_data => x_msg_data);
1346:
1347: WHEN OTHERS THEN

Line 1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1344: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1345: p_data => x_msg_data);
1346:
1347: WHEN OTHERS THEN
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1350: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1351: END IF;
1352: