319: -- Validate Environment
320: -- ******************************************************************
321: IF FND_GLOBAL.User_Id IS NULL THEN
322: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
323: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
324: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
325: --FND_MSG_PUB.ADD;
326: END IF;
327: RAISE FND_API.G_EXC_ERROR;
320: -- ******************************************************************
321: IF FND_GLOBAL.User_Id IS NULL THEN
322: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
323: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
324: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
325: --FND_MSG_PUB.ADD;
326: END IF;
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: raise FND_API.G_EXC_ERROR;
376: END IF;
377: if ( l_party_id_tbl.count = 0 ) then
378: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
379: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
380: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
381: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
382: -- fnd_msg_pub.add;
375: raise FND_API.G_EXC_ERROR;
376: END IF;
377: if ( l_party_id_tbl.count = 0 ) then
378: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
379: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
380: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
381: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
382: -- fnd_msg_pub.add;
383: x_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;
377: if ( l_party_id_tbl.count = 0 ) then
378: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
379: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
380: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
381: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
382: -- fnd_msg_pub.add;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: RAISE FND_API.G_EXC_ERROR;
377: if ( l_party_id_tbl.count = 0 ) then
378: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
379: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
380: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
381: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
382: -- fnd_msg_pub.add;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: RAISE FND_API.G_EXC_ERROR;
385: else
390: -- OR l_party_id_tbl(i).cust_account_org is not NULL )
391: then
392: -- cannot allow update because parent plan is at account level and this
393: -- operation is trying to customize at party level.
394: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
395: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
396: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
397: fnd_message.set_token('VALUE', p_csc_plan_headers_b_rec.use_for_cust_account);
398: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
391: then
392: -- cannot allow update because parent plan is at account level and this
393: -- operation is trying to customize at party level.
394: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
395: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
396: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
397: fnd_message.set_token('VALUE', p_csc_plan_headers_b_rec.use_for_cust_account);
398: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
399: x_return_status := FND_API.G_RET_STS_ERROR;
392: -- cannot allow update because parent plan is at account level and this
393: -- operation is trying to customize at party level.
394: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
395: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
396: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
397: fnd_message.set_token('VALUE', p_csc_plan_headers_b_rec.use_for_cust_account);
398: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: RAISE FND_API.G_EXC_ERROR;
393: -- operation is trying to customize at party level.
394: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
395: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
396: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
397: fnd_message.set_token('VALUE', p_csc_plan_headers_b_rec.use_for_cust_account);
398: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: RAISE FND_API.G_EXC_ERROR;
401: end if;
394: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
395: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
396: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
397: fnd_message.set_token('VALUE', p_csc_plan_headers_b_rec.use_for_cust_account);
398: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: RAISE FND_API.G_EXC_ERROR;
401: end if;
402: end if;
909:
910: If ( c_get_csc_plan_headers%NOTFOUND) Then
911: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
912: --THEN
913: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
914: FND_MESSAGE.Set_Token ('INFO', 'csc_relationship_plans', FALSE);
915: -- FND_MSG_PUB.Add;
916: --END IF;
917: Close c_get_csc_plan_headers;
910: If ( c_get_csc_plan_headers%NOTFOUND) Then
911: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
912: --THEN
913: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
914: FND_MESSAGE.Set_Token ('INFO', 'csc_relationship_plans', FALSE);
915: -- FND_MSG_PUB.Add;
916: --END IF;
917: Close c_get_csc_plan_headers;
918: raise FND_API.G_EXC_ERROR;
927: If ( P_CSC_PLAN_HEADERS_B_rec.object_version_number <>
928: l_ref_PLAN_HEADER_rec.OBJECT_VERSION_NUMBER ) THEN
929: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
930: --THEN
931: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_RECORD_CHANGED');
932: FND_MESSAGE.Set_Token('INFO', 'csc_relationship_plans', FALSE);
933: -- FND_MSG_PUB.ADD;
934: --END IF;
935: raise FND_API.G_EXC_ERROR;
928: l_ref_PLAN_HEADER_rec.OBJECT_VERSION_NUMBER ) THEN
929: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
930: --THEN
931: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_RECORD_CHANGED');
932: FND_MESSAGE.Set_Token('INFO', 'csc_relationship_plans', FALSE);
933: -- FND_MSG_PUB.ADD;
934: --END IF;
935: raise FND_API.G_EXC_ERROR;
936: End if;
1341:
1342: -- validate NOT NULL column.
1343: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1344: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1345: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1346: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1347: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1348: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1349: -- fnd_msg_pub.add;
1342: -- validate NOT NULL column.
1343: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1344: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1345: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1346: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1347: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1348: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1349: -- fnd_msg_pub.add;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1343: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1344: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1345: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1346: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1347: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1348: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1349: -- fnd_msg_pub.add;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;
1344: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1345: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1346: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1347: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1348: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1349: -- fnd_msg_pub.add;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;
1352: end if;
1356: THEN
1357: open check_dup_plan_id;
1358: fetch check_dup_plan_id into l_plan_id;
1359: if check_dup_plan_id%FOUND then
1360: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1361: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1362: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1363: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_ID');
1364: -- fnd_msg_pub.add;
1357: open check_dup_plan_id;
1358: fetch check_dup_plan_id into l_plan_id;
1359: if check_dup_plan_id%FOUND then
1360: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1361: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1362: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1363: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_ID');
1364: -- fnd_msg_pub.add;
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1358: fetch check_dup_plan_id into l_plan_id;
1359: if check_dup_plan_id%FOUND then
1360: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1361: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1362: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1363: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_ID');
1364: -- fnd_msg_pub.add;
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: end if;
1359: if check_dup_plan_id%FOUND then
1360: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1361: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1362: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1363: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_ID');
1364: -- fnd_msg_pub.add;
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: end if;
1367: close check_dup_plan_id;
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403:
1404: -- validate NOT NULL column
1405: IF(p_NAME is NULL or p_name = FND_API.G_MISS_CHAR) then
1406: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1407: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1408: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1409: fnd_message.set_token('NULL_PARAM', 'PLAN_NAME');
1410: -- fnd_msg_pub.add;
1403:
1404: -- validate NOT NULL column
1405: IF(p_NAME is NULL or p_name = FND_API.G_MISS_CHAR) then
1406: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1407: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1408: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1409: fnd_message.set_token('NULL_PARAM', 'PLAN_NAME');
1410: -- fnd_msg_pub.add;
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1404: -- validate NOT NULL column
1405: IF(p_NAME is NULL or p_name = FND_API.G_MISS_CHAR) then
1406: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1407: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1408: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1409: fnd_message.set_token('NULL_PARAM', 'PLAN_NAME');
1410: -- fnd_msg_pub.add;
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: END IF;
1405: IF(p_NAME is NULL or p_name = FND_API.G_MISS_CHAR) then
1406: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1407: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1408: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1409: fnd_message.set_token('NULL_PARAM', 'PLAN_NAME');
1410: -- fnd_msg_pub.add;
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: END IF;
1413:
1423: fetch check_dup_plan_name into l_plan_id;
1424: close check_dup_plan_name;
1425:
1426: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE and l_plan_id <> 0 ) then
1427: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1428: -- fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1429: -- fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1430: -- fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1431: -- fnd_msg_pub.add;
1424: close check_dup_plan_name;
1425:
1426: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE and l_plan_id <> 0 ) then
1427: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1428: -- fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1429: -- fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1430: -- fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1431: -- fnd_msg_pub.add;
1432: fnd_message.set_name ('CSC', 'CSC_RSP_DUPLICATE_NAME');
1425:
1426: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE and l_plan_id <> 0 ) then
1427: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1428: -- fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1429: -- fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1430: -- fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1431: -- fnd_msg_pub.add;
1432: fnd_message.set_name ('CSC', 'CSC_RSP_DUPLICATE_NAME');
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1426: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE and l_plan_id <> 0 ) then
1427: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1428: -- fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1429: -- fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1430: -- fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1431: -- fnd_msg_pub.add;
1432: fnd_message.set_name ('CSC', 'CSC_RSP_DUPLICATE_NAME');
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: else
1428: -- fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1429: -- fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1430: -- fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1431: -- fnd_msg_pub.add;
1432: fnd_message.set_name ('CSC', 'CSC_RSP_DUPLICATE_NAME');
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: else
1435: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE and
1436: l_plan_id <> p_plan_id ) then -- some other plan exists with this name
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: else
1435: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE and
1436: l_plan_id <> p_plan_id ) then -- some other plan exists with this name
1437: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1438: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1439: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1440: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1441: -- fnd_msg_pub.add;
1434: else
1435: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE and
1436: l_plan_id <> p_plan_id ) then -- some other plan exists with this name
1437: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1438: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1439: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1440: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1441: -- fnd_msg_pub.add;
1442: x_return_status := FND_API.G_RET_STS_ERROR;
1435: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE and
1436: l_plan_id <> p_plan_id ) then -- some other plan exists with this name
1437: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1438: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1439: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1440: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1441: -- fnd_msg_pub.add;
1442: x_return_status := FND_API.G_RET_STS_ERROR;
1443: end if;
1436: l_plan_id <> p_plan_id ) then -- some other plan exists with this name
1437: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1438: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');
1439: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1440: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');
1441: -- fnd_msg_pub.add;
1442: x_return_status := FND_API.G_RET_STS_ERROR;
1443: end if;
1444: end if;
1484: IF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) OR
1485: ( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND
1486: p_customized_plan = 'Y' )
1487: THEN
1488: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1489: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1490: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1491: fnd_message.set_token('NULL_PARAM', 'ORIGINAL_PLAN_ID');
1492: -- fnd_msg_pub.add;
1485: ( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND
1486: p_customized_plan = 'Y' )
1487: THEN
1488: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1489: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1490: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1491: fnd_message.set_token('NULL_PARAM', 'ORIGINAL_PLAN_ID');
1492: -- fnd_msg_pub.add;
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1486: p_customized_plan = 'Y' )
1487: THEN
1488: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1489: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1490: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1491: fnd_message.set_token('NULL_PARAM', 'ORIGINAL_PLAN_ID');
1492: -- fnd_msg_pub.add;
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: APP_EXCEPTION.RAISE_EXCEPTION;
1487: THEN
1488: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1489: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1490: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1491: fnd_message.set_token('NULL_PARAM', 'ORIGINAL_PLAN_ID');
1492: -- fnd_msg_pub.add;
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: APP_EXCEPTION.RAISE_EXCEPTION;
1495: END IF;
1498: IF ( p_original_plan_id is not NULL and p_original_plan_id <> FND_API.G_MISS_NUM ) THEN
1499: open chk_original_plan_id;
1500: fetch chk_original_plan_id into l_plan_id;
1501: if ( chk_original_plan_id%notfound ) then
1502: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1503: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1504: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1505: fnd_message.set_token('VALUE', p_original_plan_id);
1506: fnd_message.set_token('PARAMETER', 'ORIGINAL_PLAN_ID');
1499: open chk_original_plan_id;
1500: fetch chk_original_plan_id into l_plan_id;
1501: if ( chk_original_plan_id%notfound ) then
1502: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1503: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1504: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1505: fnd_message.set_token('VALUE', p_original_plan_id);
1506: fnd_message.set_token('PARAMETER', 'ORIGINAL_PLAN_ID');
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1500: fetch chk_original_plan_id into l_plan_id;
1501: if ( chk_original_plan_id%notfound ) then
1502: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1503: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1504: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1505: fnd_message.set_token('VALUE', p_original_plan_id);
1506: fnd_message.set_token('PARAMETER', 'ORIGINAL_PLAN_ID');
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: end if;
1501: if ( chk_original_plan_id%notfound ) then
1502: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1503: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1504: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1505: fnd_message.set_token('VALUE', p_original_plan_id);
1506: fnd_message.set_token('PARAMETER', 'ORIGINAL_PLAN_ID');
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: end if;
1509: close chk_original_plan_id;
1502: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1503: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1504: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1505: fnd_message.set_token('VALUE', p_original_plan_id);
1506: fnd_message.set_token('PARAMETER', 'ORIGINAL_PLAN_ID');
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: end if;
1509: close chk_original_plan_id;
1510: END IF;
1547: x_return_status := FND_API.G_RET_STS_SUCCESS;
1548:
1549: -- validate NOT NULL column
1550: IF (p_PLAN_GROUP_CODE is NULL or p_PLAN_GROUP_CODE = FND_API.G_MISS_CHAR) then
1551: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1552: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1553: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1554: fnd_message.set_token('NULL_PARAM', 'PLAN_GROUP_CODE');
1555: -- fnd_msg_pub.add;
1548:
1549: -- validate NOT NULL column
1550: IF (p_PLAN_GROUP_CODE is NULL or p_PLAN_GROUP_CODE = FND_API.G_MISS_CHAR) then
1551: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1552: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1553: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1554: fnd_message.set_token('NULL_PARAM', 'PLAN_GROUP_CODE');
1555: -- fnd_msg_pub.add;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1549: -- validate NOT NULL column
1550: IF (p_PLAN_GROUP_CODE is NULL or p_PLAN_GROUP_CODE = FND_API.G_MISS_CHAR) then
1551: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1552: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1553: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1554: fnd_message.set_token('NULL_PARAM', 'PLAN_GROUP_CODE');
1555: -- fnd_msg_pub.add;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: else
1550: IF (p_PLAN_GROUP_CODE is NULL or p_PLAN_GROUP_CODE = FND_API.G_MISS_CHAR) then
1551: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1552: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1553: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1554: fnd_message.set_token('NULL_PARAM', 'PLAN_GROUP_CODE');
1555: -- fnd_msg_pub.add;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: else
1558: -- validate PLAN_GROUP_CODE exists in fnd_lookup_values.
1560: fetch group_in_lookup into l_rec_count;
1561: close group_in_lookup;
1562:
1563: if ( l_rec_count = 0 ) then
1564: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1565: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1566: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1567: fnd_message.set_token('VALUE', p_plan_group_code);
1568: fnd_message.set_token('PARAMETER', 'PLAN_GROUP_CODE');
1561: close group_in_lookup;
1562:
1563: if ( l_rec_count = 0 ) then
1564: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1565: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1566: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1567: fnd_message.set_token('VALUE', p_plan_group_code);
1568: fnd_message.set_token('PARAMETER', 'PLAN_GROUP_CODE');
1569: -- fnd_msg_pub.add;
1562:
1563: if ( l_rec_count = 0 ) then
1564: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1565: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1566: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1567: fnd_message.set_token('VALUE', p_plan_group_code);
1568: fnd_message.set_token('PARAMETER', 'PLAN_GROUP_CODE');
1569: -- fnd_msg_pub.add;
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1563: if ( l_rec_count = 0 ) then
1564: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1565: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1566: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1567: fnd_message.set_token('VALUE', p_plan_group_code);
1568: fnd_message.set_token('PARAMETER', 'PLAN_GROUP_CODE');
1569: -- fnd_msg_pub.add;
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: end if;
1564: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1565: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1566: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1567: fnd_message.set_token('VALUE', p_plan_group_code);
1568: fnd_message.set_token('PARAMETER', 'PLAN_GROUP_CODE');
1569: -- fnd_msg_pub.add;
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: end if;
1572: --end if;
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:
1610: -- validate NOT NULL column
1611: IF ( p_use_for_cust_account is NULL or p_use_for_cust_account = FND_API.G_MISS_CHAR ) then
1612: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1613: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1614: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1615: fnd_message.set_token('NULL_PARAM', 'USE_FOR_CUST_ACCOUNT');
1616: -- fnd_msg_pub.add;
1609:
1610: -- validate NOT NULL column
1611: IF ( p_use_for_cust_account is NULL or p_use_for_cust_account = FND_API.G_MISS_CHAR ) then
1612: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1613: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1614: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1615: fnd_message.set_token('NULL_PARAM', 'USE_FOR_CUST_ACCOUNT');
1616: -- fnd_msg_pub.add;
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1610: -- validate NOT NULL column
1611: IF ( p_use_for_cust_account is NULL or p_use_for_cust_account = FND_API.G_MISS_CHAR ) then
1612: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1613: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1614: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1615: fnd_message.set_token('NULL_PARAM', 'USE_FOR_CUST_ACCOUNT');
1616: -- fnd_msg_pub.add;
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: ELSIF ( p_use_for_cust_account <> 'Y' and p_use_for_cust_account <> 'N' ) then
1611: IF ( p_use_for_cust_account is NULL or p_use_for_cust_account = FND_API.G_MISS_CHAR ) then
1612: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1613: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1614: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1615: fnd_message.set_token('NULL_PARAM', 'USE_FOR_CUST_ACCOUNT');
1616: -- fnd_msg_pub.add;
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: ELSIF ( p_use_for_cust_account <> 'Y' and p_use_for_cust_account <> 'N' ) then
1619: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1615: fnd_message.set_token('NULL_PARAM', 'USE_FOR_CUST_ACCOUNT');
1616: -- fnd_msg_pub.add;
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: ELSIF ( p_use_for_cust_account <> 'Y' and p_use_for_cust_account <> 'N' ) then
1619: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1620: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1621: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1622: fnd_message.set_token('VALUE', p_use_for_cust_account);
1623: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
1616: -- fnd_msg_pub.add;
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: ELSIF ( p_use_for_cust_account <> 'Y' and p_use_for_cust_account <> 'N' ) then
1619: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1620: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1621: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1622: fnd_message.set_token('VALUE', p_use_for_cust_account);
1623: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
1624: -- fnd_msg_pub.add;
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: ELSIF ( p_use_for_cust_account <> 'Y' and p_use_for_cust_account <> 'N' ) then
1619: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1620: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1621: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1622: fnd_message.set_token('VALUE', p_use_for_cust_account);
1623: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
1624: -- fnd_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1618: ELSIF ( p_use_for_cust_account <> 'Y' and p_use_for_cust_account <> 'N' ) then
1619: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1620: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1621: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1622: fnd_message.set_token('VALUE', p_use_for_cust_account);
1623: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
1624: -- fnd_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) then
1619: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1620: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1621: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1622: fnd_message.set_token('VALUE', p_use_for_cust_account);
1623: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
1624: -- fnd_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) then
1627: if ( p_use_for_cust_account <> p_old_use_for_cust_account ) then
1632: close c1;
1633: if ( l_rec_count <> 0 ) then
1634: -- Use_for_cust_account cannot be updated. There are existing customers
1635: -- associated to this plan.
1636: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1637: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1638: -- Fixed bug# 3319977
1639: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1640: fnd_message.set_token('UPDATE_PARAM', 'PLAN_LEVEL');
1633: if ( l_rec_count <> 0 ) then
1634: -- Use_for_cust_account cannot be updated. There are existing customers
1635: -- associated to this plan.
1636: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1637: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1638: -- Fixed bug# 3319977
1639: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1640: fnd_message.set_token('UPDATE_PARAM', 'PLAN_LEVEL');
1641: -- fnd_msg_pub.add;
1635: -- associated to this plan.
1636: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1637: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1638: -- Fixed bug# 3319977
1639: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1640: fnd_message.set_token('UPDATE_PARAM', 'PLAN_LEVEL');
1641: -- fnd_msg_pub.add;
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: end if;
1636: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1637: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1638: -- Fixed bug# 3319977
1639: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1640: fnd_message.set_token('UPDATE_PARAM', 'PLAN_LEVEL');
1641: -- fnd_msg_pub.add;
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: end if;
1644: end if;
1688: fetch type_in_lookup into l_rec_count;
1689: close type_in_lookup;
1690:
1691: if ( l_rec_count = 0 ) then
1692: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1693: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1694: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1695: fnd_message.set_token('VALUE', p_end_user_type);
1696: fnd_message.set_token('PARAMETER', 'END_USER_TYPE');
1689: close type_in_lookup;
1690:
1691: if ( l_rec_count = 0 ) then
1692: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1693: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1694: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1695: fnd_message.set_token('VALUE', p_end_user_type);
1696: fnd_message.set_token('PARAMETER', 'END_USER_TYPE');
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1690:
1691: if ( l_rec_count = 0 ) then
1692: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1693: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1694: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1695: fnd_message.set_token('VALUE', p_end_user_type);
1696: fnd_message.set_token('PARAMETER', 'END_USER_TYPE');
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698: end if;
1691: if ( l_rec_count = 0 ) then
1692: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1693: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1694: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1695: fnd_message.set_token('VALUE', p_end_user_type);
1696: fnd_message.set_token('PARAMETER', 'END_USER_TYPE');
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698: end if;
1699: end if;
1692: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1693: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1694: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1695: fnd_message.set_token('VALUE', p_end_user_type);
1696: fnd_message.set_token('PARAMETER', 'END_USER_TYPE');
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698: end if;
1699: end if;
1700:
1725: x_return_status := FND_API.G_RET_STS_SUCCESS;
1726:
1727: -- validate NOT NULL column
1728: IF( p_CUSTOMIZED_PLAN is NULL or p_customized_plan = FND_API.G_MISS_CHAR ) then
1729: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1730: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1731: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1726:
1727: -- validate NOT NULL column
1728: IF( p_CUSTOMIZED_PLAN is NULL or p_customized_plan = FND_API.G_MISS_CHAR ) then
1729: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1730: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1731: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: ELSIF ( p_customized_plan <> 'Y' and p_customized_plan <> 'N' ) then
1727: -- validate NOT NULL column
1728: IF( p_CUSTOMIZED_PLAN is NULL or p_customized_plan = FND_API.G_MISS_CHAR ) then
1729: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1730: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1731: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: ELSIF ( p_customized_plan <> 'Y' and p_customized_plan <> 'N' ) then
1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1728: IF( p_CUSTOMIZED_PLAN is NULL or p_customized_plan = FND_API.G_MISS_CHAR ) then
1729: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1730: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1731: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: ELSIF ( p_customized_plan <> 'Y' and p_customized_plan <> 'N' ) then
1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1736: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1731: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: ELSIF ( p_customized_plan <> 'Y' and p_customized_plan <> 'N' ) then
1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1736: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1737: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1738: fnd_message.set_token('VALUE', p_customized_plan);
1739: fnd_message.set_token('PARAMETER', 'CUSTOMIZED_PLAN');
1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: ELSIF ( p_customized_plan <> 'Y' and p_customized_plan <> 'N' ) then
1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1736: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1737: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1738: fnd_message.set_token('VALUE', p_customized_plan);
1739: fnd_message.set_token('PARAMETER', 'CUSTOMIZED_PLAN');
1740: -- fnd_msg_pub.add;
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: ELSIF ( p_customized_plan <> 'Y' and p_customized_plan <> 'N' ) then
1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1736: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1737: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1738: fnd_message.set_token('VALUE', p_customized_plan);
1739: fnd_message.set_token('PARAMETER', 'CUSTOMIZED_PLAN');
1740: -- fnd_msg_pub.add;
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1734: ELSIF ( p_customized_plan <> 'Y' and p_customized_plan <> 'N' ) then
1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1736: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1737: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1738: fnd_message.set_token('VALUE', p_customized_plan);
1739: fnd_message.set_token('PARAMETER', 'CUSTOMIZED_PLAN');
1740: -- fnd_msg_pub.add;
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: END IF;
1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1736: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1737: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1738: fnd_message.set_token('VALUE', p_customized_plan);
1739: fnd_message.set_token('PARAMETER', 'CUSTOMIZED_PLAN');
1740: -- fnd_msg_pub.add;
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: END IF;
1743:
1784: x_return_status := FND_API.G_RET_STS_SUCCESS;
1785:
1786: -- validate NOT NULL column
1787: IF(p_PROFILE_CHECK_ID is NULL or p_profile_check_id = FND_API.G_MISS_NUM) then
1788: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1789: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1790: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1791: fnd_message.set_token('NULL_PARAM', 'PROFILE_CHECK_ID');
1792: -- fnd_msg_pub.add;
1785:
1786: -- validate NOT NULL column
1787: IF(p_PROFILE_CHECK_ID is NULL or p_profile_check_id = FND_API.G_MISS_NUM) then
1788: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1789: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1790: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1791: fnd_message.set_token('NULL_PARAM', 'PROFILE_CHECK_ID');
1792: -- fnd_msg_pub.add;
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1786: -- validate NOT NULL column
1787: IF(p_PROFILE_CHECK_ID is NULL or p_profile_check_id = FND_API.G_MISS_NUM) then
1788: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1789: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1790: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1791: fnd_message.set_token('NULL_PARAM', 'PROFILE_CHECK_ID');
1792: -- fnd_msg_pub.add;
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1787: IF(p_PROFILE_CHECK_ID is NULL or p_profile_check_id = FND_API.G_MISS_NUM) then
1788: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1789: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1790: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1791: fnd_message.set_token('NULL_PARAM', 'PROFILE_CHECK_ID');
1792: -- fnd_msg_pub.add;
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1795: p_profile_check_id <> p_old_profile_check_id ) then
1799: close c1;
1800: --end if;
1801: if ( l_rec_count <> 0 ) then
1802: -- Profile check id cannot be updated. There are customers attached to this plan.
1803: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1804: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1805: -- Fixed bug# 3319977
1806: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1807: fnd_message.set_token('UPDATE_PARAM', 'PROFILE_CHECK_ID');
1800: --end if;
1801: if ( l_rec_count <> 0 ) then
1802: -- Profile check id cannot be updated. There are customers attached to this plan.
1803: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1804: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1805: -- Fixed bug# 3319977
1806: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1807: fnd_message.set_token('UPDATE_PARAM', 'PROFILE_CHECK_ID');
1808: x_return_status := FND_API.G_RET_STS_ERROR;
1802: -- Profile check id cannot be updated. There are customers attached to this plan.
1803: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1804: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1805: -- Fixed bug# 3319977
1806: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1807: fnd_message.set_token('UPDATE_PARAM', 'PROFILE_CHECK_ID');
1808: x_return_status := FND_API.G_RET_STS_ERROR;
1809: end if;
1810: END IF;
1803: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1804: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1805: -- Fixed bug# 3319977
1806: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1807: fnd_message.set_token('UPDATE_PARAM', 'PROFILE_CHECK_ID');
1808: x_return_status := FND_API.G_RET_STS_ERROR;
1809: end if;
1810: END IF;
1811:
1820: close id_in_prof_checks;
1821:
1822: if ( l_rec_count = 0 or l_rec_count > 1 ) then
1823: -- Profile check id is not a valid condition id.
1824: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1825: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1826: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1827: fnd_message.set_token('VALUE', p_profile_check_id);
1828: fnd_message.set_token('PARAMETER', 'PROFILE_CHECK_ID');
1821:
1822: if ( l_rec_count = 0 or l_rec_count > 1 ) then
1823: -- Profile check id is not a valid condition id.
1824: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1825: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1826: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1827: fnd_message.set_token('VALUE', p_profile_check_id);
1828: fnd_message.set_token('PARAMETER', 'PROFILE_CHECK_ID');
1829: -- fnd_msg_pub.add;
1822: if ( l_rec_count = 0 or l_rec_count > 1 ) then
1823: -- Profile check id is not a valid condition id.
1824: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1825: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1826: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1827: fnd_message.set_token('VALUE', p_profile_check_id);
1828: fnd_message.set_token('PARAMETER', 'PROFILE_CHECK_ID');
1829: -- fnd_msg_pub.add;
1830: x_return_status := FND_API.G_RET_STS_ERROR;
1823: -- Profile check id is not a valid condition id.
1824: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1825: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1826: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1827: fnd_message.set_token('VALUE', p_profile_check_id);
1828: fnd_message.set_token('PARAMETER', 'PROFILE_CHECK_ID');
1829: -- fnd_msg_pub.add;
1830: x_return_status := FND_API.G_RET_STS_ERROR;
1831: end if;
1824: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1825: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1826: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1827: fnd_message.set_token('VALUE', p_profile_check_id);
1828: fnd_message.set_token('PARAMETER', 'PROFILE_CHECK_ID');
1829: -- fnd_msg_pub.add;
1830: x_return_status := FND_API.G_RET_STS_ERROR;
1831: end if;
1832: end if;
1867: x_return_status := FND_API.G_RET_STS_SUCCESS;
1868:
1869: -- validate NOT NULL column
1870: --IF(p_CRITERIA_VALUE_LOW is NULL or p_CRITERIA_VALUE_LOW = FND_API.G_MISS_CHAR ) then
1871: --fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1872: --fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1873: --fnd_message.set_token('NULL_PARAM', 'CRITERIA_VALUE_LOW');
1874: -- fnd_msg_pub.add;
1875: --x_return_status := FND_API.G_RET_STS_ERROR;
1868:
1869: -- validate NOT NULL column
1870: --IF(p_CRITERIA_VALUE_LOW is NULL or p_CRITERIA_VALUE_LOW = FND_API.G_MISS_CHAR ) then
1871: --fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1872: --fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1873: --fnd_message.set_token('NULL_PARAM', 'CRITERIA_VALUE_LOW');
1874: -- fnd_msg_pub.add;
1875: --x_return_status := FND_API.G_RET_STS_ERROR;
1876: IF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1869: -- validate NOT NULL column
1870: --IF(p_CRITERIA_VALUE_LOW is NULL or p_CRITERIA_VALUE_LOW = FND_API.G_MISS_CHAR ) then
1871: --fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1872: --fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1873: --fnd_message.set_token('NULL_PARAM', 'CRITERIA_VALUE_LOW');
1874: -- fnd_msg_pub.add;
1875: --x_return_status := FND_API.G_RET_STS_ERROR;
1876: IF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1877: p_criteria_value_low <> p_old_criteria_value_low ) then
1881: close c1;
1882: --end if;
1883: if ( l_rec_count <> 0 ) then
1884: -- Criteria_value_low cannot be updated. There are customers attached to this plan.
1885: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1886: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1887: -- Fixed bug# 3319977
1888: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1889: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_LOW');
1882: --end if;
1883: if ( l_rec_count <> 0 ) then
1884: -- Criteria_value_low cannot be updated. There are customers attached to this plan.
1885: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1886: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1887: -- Fixed bug# 3319977
1888: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1889: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_LOW');
1890: x_return_status := FND_API.G_RET_STS_ERROR;
1884: -- Criteria_value_low cannot be updated. There are customers attached to this plan.
1885: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1886: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1887: -- Fixed bug# 3319977
1888: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1889: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_LOW');
1890: x_return_status := FND_API.G_RET_STS_ERROR;
1891: end if;
1892: END IF;
1885: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1886: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1887: -- Fixed bug# 3319977
1888: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1889: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_LOW');
1890: x_return_status := FND_API.G_RET_STS_ERROR;
1891: end if;
1892: END IF;
1893:
1934: close c1;
1935: --end if;
1936: if ( l_rec_count <> 0 ) then
1937: -- Criteria_value_high cannot be updated. There are customers attached to this plan.
1938: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1939: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1940: -- Fixed bug# 3319977
1941: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1942: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_HIGH');
1935: --end if;
1936: if ( l_rec_count <> 0 ) then
1937: -- Criteria_value_high cannot be updated. There are customers attached to this plan.
1938: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1939: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1940: -- Fixed bug# 3319977
1941: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1942: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_HIGH');
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1937: -- Criteria_value_high cannot be updated. There are customers attached to this plan.
1938: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1939: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1940: -- Fixed bug# 3319977
1941: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1942: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_HIGH');
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: end if;
1945: END IF;
1938: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
1939: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
1940: -- Fixed bug# 3319977
1941: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
1942: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_HIGH');
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: end if;
1945: END IF;
1946:
1980: x_return_status := FND_API.G_RET_STS_SUCCESS;
1981:
1982: -- validate NOT NULL column
1983: IF(p_RELATIONAL_OPERATOR is NULL or p_RELATIONAL_OPERATOR = FND_API.G_MISS_CHAR ) then
1984: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1985: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1986: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1987: fnd_message.set_token('NULL_PARAM', 'RELATIONAL_OPERATOR');
1988: -- fnd_msg_pub.add;
1981:
1982: -- validate NOT NULL column
1983: IF(p_RELATIONAL_OPERATOR is NULL or p_RELATIONAL_OPERATOR = FND_API.G_MISS_CHAR ) then
1984: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1985: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1986: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1987: fnd_message.set_token('NULL_PARAM', 'RELATIONAL_OPERATOR');
1988: -- fnd_msg_pub.add;
1989: x_return_status := FND_API.G_RET_STS_ERROR;
1982: -- validate NOT NULL column
1983: IF(p_RELATIONAL_OPERATOR is NULL or p_RELATIONAL_OPERATOR = FND_API.G_MISS_CHAR ) then
1984: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1985: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1986: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1987: fnd_message.set_token('NULL_PARAM', 'RELATIONAL_OPERATOR');
1988: -- fnd_msg_pub.add;
1989: x_return_status := FND_API.G_RET_STS_ERROR;
1990: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1983: IF(p_RELATIONAL_OPERATOR is NULL or p_RELATIONAL_OPERATOR = FND_API.G_MISS_CHAR ) then
1984: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1985: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');
1986: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1987: fnd_message.set_token('NULL_PARAM', 'RELATIONAL_OPERATOR');
1988: -- fnd_msg_pub.add;
1989: x_return_status := FND_API.G_RET_STS_ERROR;
1990: ELSIF ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE AND
1991: p_relational_operator <> p_old_relational_operator ) then
1995: close c1;
1996: --end if;
1997: if ( l_rec_count <> 0 ) then
1998: -- Relational_operator cannot be updated. There are customers attached to this plan.
1999: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
2000: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
2001: -- Fixed bug# 3319977
2002: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
2003: fnd_message.set_token('UPDATE_PARAM', 'RELATIONAL_OPERATOR');
1996: --end if;
1997: if ( l_rec_count <> 0 ) then
1998: -- Relational_operator cannot be updated. There are customers attached to this plan.
1999: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
2000: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
2001: -- Fixed bug# 3319977
2002: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
2003: fnd_message.set_token('UPDATE_PARAM', 'RELATIONAL_OPERATOR');
2004: x_return_status := FND_API.G_RET_STS_ERROR;
1998: -- Relational_operator cannot be updated. There are customers attached to this plan.
1999: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
2000: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
2001: -- Fixed bug# 3319977
2002: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
2003: fnd_message.set_token('UPDATE_PARAM', 'RELATIONAL_OPERATOR');
2004: x_return_status := FND_API.G_RET_STS_ERROR;
2005: end if;
2006: END IF;
1999: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');
2000: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');
2001: -- Fixed bug# 3319977
2002: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');
2003: fnd_message.set_token('UPDATE_PARAM', 'RELATIONAL_OPERATOR');
2004: x_return_status := FND_API.G_RET_STS_ERROR;
2005: end if;
2006: END IF;
2007:
2045: THEN
2046: if ( p_criteria_value_low IS NULL AND p_criteria_value_high IS NOT NULL ) then
2047: -- Error in plan criteria. Criteria value low should be specified and criteria
2048: -- value high should not be specified.
2049: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2050: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2051: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2052: fnd_message.set_token('VALUE', p_relational_operator);
2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2046: if ( p_criteria_value_low IS NULL AND p_criteria_value_high IS NOT NULL ) then
2047: -- Error in plan criteria. Criteria value low should be specified and criteria
2048: -- value high should not be specified.
2049: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2050: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2051: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2052: fnd_message.set_token('VALUE', p_relational_operator);
2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2047: -- Error in plan criteria. Criteria value low should be specified and criteria
2048: -- value high should not be specified.
2049: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2050: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2051: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2052: fnd_message.set_token('VALUE', p_relational_operator);
2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: elsif ( p_criteria_value_low is NULL AND p_criteria_value_high IS NULL ) then
2048: -- value high should not be specified.
2049: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2050: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2051: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2052: fnd_message.set_token('VALUE', p_relational_operator);
2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: elsif ( p_criteria_value_low is NULL AND p_criteria_value_high IS NULL ) then
2056: -- Error in plan criteria. Criteria value low should be specified.
2049: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2050: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2051: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2052: fnd_message.set_token('VALUE', p_relational_operator);
2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: elsif ( p_criteria_value_low is NULL AND p_criteria_value_high IS NULL ) then
2056: -- Error in plan criteria. Criteria value low should be specified.
2057: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: elsif ( p_criteria_value_low is NULL AND p_criteria_value_high IS NULL ) then
2056: -- Error in plan criteria. Criteria value low should be specified.
2057: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2058: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2059: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2060: fnd_message.set_token('VALUE', p_criteria_value_low);
2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: elsif ( p_criteria_value_low is NULL AND p_criteria_value_high IS NULL ) then
2056: -- Error in plan criteria. Criteria value low should be specified.
2057: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2058: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2059: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2060: fnd_message.set_token('VALUE', p_criteria_value_low);
2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');
2062: x_return_status := FND_API.G_RET_STS_ERROR;
2055: elsif ( p_criteria_value_low is NULL AND p_criteria_value_high IS NULL ) then
2056: -- Error in plan criteria. Criteria value low should be specified.
2057: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2058: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2059: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2060: fnd_message.set_token('VALUE', p_criteria_value_low);
2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');
2062: x_return_status := FND_API.G_RET_STS_ERROR;
2063: elsif ( p_criteria_value_low IS NOT NULL AND p_criteria_value_high IS NOT NULL ) then
2056: -- Error in plan criteria. Criteria value low should be specified.
2057: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2058: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2059: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2060: fnd_message.set_token('VALUE', p_criteria_value_low);
2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');
2062: x_return_status := FND_API.G_RET_STS_ERROR;
2063: elsif ( p_criteria_value_low IS NOT NULL AND p_criteria_value_high IS NOT NULL ) then
2064: -- Error in plan criteria. Criteria value high should not be specified.
2057: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2058: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2059: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2060: fnd_message.set_token('VALUE', p_criteria_value_low);
2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');
2062: x_return_status := FND_API.G_RET_STS_ERROR;
2063: elsif ( p_criteria_value_low IS NOT NULL AND p_criteria_value_high IS NOT NULL ) then
2064: -- Error in plan criteria. Criteria value high should not be specified.
2065: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');
2062: x_return_status := FND_API.G_RET_STS_ERROR;
2063: elsif ( p_criteria_value_low IS NOT NULL AND p_criteria_value_high IS NOT NULL ) then
2064: -- Error in plan criteria. Criteria value high should not be specified.
2065: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2066: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2067: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2068: fnd_message.set_token('VALUE', p_criteria_value_high);
2069: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2062: x_return_status := FND_API.G_RET_STS_ERROR;
2063: elsif ( p_criteria_value_low IS NOT NULL AND p_criteria_value_high IS NOT NULL ) then
2064: -- Error in plan criteria. Criteria value high should not be specified.
2065: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2066: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2067: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2068: fnd_message.set_token('VALUE', p_criteria_value_high);
2069: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2063: elsif ( p_criteria_value_low IS NOT NULL AND p_criteria_value_high IS NOT NULL ) then
2064: -- Error in plan criteria. Criteria value high should not be specified.
2065: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2066: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2067: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2068: fnd_message.set_token('VALUE', p_criteria_value_high);
2069: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071: end if;
2064: -- Error in plan criteria. Criteria value high should not be specified.
2065: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2066: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2067: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2068: fnd_message.set_token('VALUE', p_criteria_value_high);
2069: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071: end if;
2072: ELSIF ( p_relational_operator = 'BETWEEN' OR
2065: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2066: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2067: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2068: fnd_message.set_token('VALUE', p_criteria_value_high);
2069: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071: end if;
2072: ELSIF ( p_relational_operator = 'BETWEEN' OR
2073: p_relational_operator = 'NOT BETWEEN' )
2073: p_relational_operator = 'NOT BETWEEN' )
2074: THEN
2075: if ( p_criteria_value_low IS NULL OR p_criteria_value_high IS NULL ) then
2076: -- Error in plan criteria. Criteria value low and high should be specified.
2077: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2078: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2079: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2080: fnd_message.set_token('VALUE', p_relational_operator);
2081: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2074: THEN
2075: if ( p_criteria_value_low IS NULL OR p_criteria_value_high IS NULL ) then
2076: -- Error in plan criteria. Criteria value low and high should be specified.
2077: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2078: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2079: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2080: fnd_message.set_token('VALUE', p_relational_operator);
2081: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2075: if ( p_criteria_value_low IS NULL OR p_criteria_value_high IS NULL ) then
2076: -- Error in plan criteria. Criteria value low and high should be specified.
2077: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2078: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2079: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2080: fnd_message.set_token('VALUE', p_relational_operator);
2081: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: elsif ( p_criteria_value_low > p_criteria_value_high ) then
2076: -- Error in plan criteria. Criteria value low and high should be specified.
2077: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2078: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2079: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2080: fnd_message.set_token('VALUE', p_relational_operator);
2081: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: elsif ( p_criteria_value_low > p_criteria_value_high ) then
2084: -- Error in plan criteria. Criteria value low should be less than criteria
2077: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2078: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2079: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2080: fnd_message.set_token('VALUE', p_relational_operator);
2081: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: elsif ( p_criteria_value_low > p_criteria_value_high ) then
2084: -- Error in plan criteria. Criteria value low should be less than criteria
2085: -- value high.
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: elsif ( p_criteria_value_low > p_criteria_value_high ) then
2084: -- Error in plan criteria. Criteria value low should be less than criteria
2085: -- value high.
2086: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2087: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2088: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2089: fnd_message.set_token('VALUE', p_criteria_value_high);
2090: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2083: elsif ( p_criteria_value_low > p_criteria_value_high ) then
2084: -- Error in plan criteria. Criteria value low should be less than criteria
2085: -- value high.
2086: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2087: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2088: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2089: fnd_message.set_token('VALUE', p_criteria_value_high);
2090: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2084: -- Error in plan criteria. Criteria value low should be less than criteria
2085: -- value high.
2086: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2087: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2088: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2089: fnd_message.set_token('VALUE', p_criteria_value_high);
2090: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: end if;
2085: -- value high.
2086: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2087: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2088: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2089: fnd_message.set_token('VALUE', p_criteria_value_high);
2090: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: end if;
2093: ELSIF ( p_relational_operator = 'IS NULL' OR
2086: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2087: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2088: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2089: fnd_message.set_token('VALUE', p_criteria_value_high);
2090: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: end if;
2093: ELSIF ( p_relational_operator = 'IS NULL' OR
2094: p_relational_operator = 'IS NOT NULL' )
2094: p_relational_operator = 'IS NOT NULL' )
2095: THEN
2096: if ( p_criteria_value_low IS NOT NULL OR p_criteria_value_high IS NOT NULL ) then
2097: -- Error in plan criteria. Criteria value low and high should not be specified.
2098: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2099: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2100: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2101: fnd_message.set_token('VALUE', p_relational_operator);
2102: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2095: THEN
2096: if ( p_criteria_value_low IS NOT NULL OR p_criteria_value_high IS NOT NULL ) then
2097: -- Error in plan criteria. Criteria value low and high should not be specified.
2098: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2099: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2100: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2101: fnd_message.set_token('VALUE', p_relational_operator);
2102: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2096: if ( p_criteria_value_low IS NOT NULL OR p_criteria_value_high IS NOT NULL ) then
2097: -- Error in plan criteria. Criteria value low and high should not be specified.
2098: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2099: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2100: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2101: fnd_message.set_token('VALUE', p_relational_operator);
2102: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: end if;
2097: -- Error in plan criteria. Criteria value low and high should not be specified.
2098: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2099: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2100: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2101: fnd_message.set_token('VALUE', p_relational_operator);
2102: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: end if;
2105: END IF;
2098: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2099: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2100: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2101: fnd_message.set_token('VALUE', p_relational_operator);
2102: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: end if;
2105: END IF;
2106:
2143:
2144: if ( trunc(p_start_date_active) > trunc(l_min_date) ) then
2145: -- START date cannot be updated to specified value. There are customers who are associated
2146: -- to this plan EARLIER than the specified date. Valid dates are LESS than MIN_DATE;
2147: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2148: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2149: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2150: fnd_message.set_token('VALUE', p_start_date_active);
2151: fnd_message.set_token('PARAMETER', 'START_DATE_ACTIVE');
2144: if ( trunc(p_start_date_active) > trunc(l_min_date) ) then
2145: -- START date cannot be updated to specified value. There are customers who are associated
2146: -- to this plan EARLIER than the specified date. Valid dates are LESS than MIN_DATE;
2147: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2148: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2149: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2150: fnd_message.set_token('VALUE', p_start_date_active);
2151: fnd_message.set_token('PARAMETER', 'START_DATE_ACTIVE');
2152: -- fnd_msg_pub.add;
2145: -- START date cannot be updated to specified value. There are customers who are associated
2146: -- to this plan EARLIER than the specified date. Valid dates are LESS than MIN_DATE;
2147: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2148: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2149: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2150: fnd_message.set_token('VALUE', p_start_date_active);
2151: fnd_message.set_token('PARAMETER', 'START_DATE_ACTIVE');
2152: -- fnd_msg_pub.add;
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2146: -- to this plan EARLIER than the specified date. Valid dates are LESS than MIN_DATE;
2147: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2148: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2149: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2150: fnd_message.set_token('VALUE', p_start_date_active);
2151: fnd_message.set_token('PARAMETER', 'START_DATE_ACTIVE');
2152: -- fnd_msg_pub.add;
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154: end if;
2147: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2148: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2149: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2150: fnd_message.set_token('VALUE', p_start_date_active);
2151: fnd_message.set_token('PARAMETER', 'START_DATE_ACTIVE');
2152: -- fnd_msg_pub.add;
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154: end if;
2155: end if;
2201: if ( trunc(p_end_date_active) < trunc(l_max_date) ) then
2202: -- DATE_TYPE date cannot be updated to specified value. There are customers who are associated
2203: -- to this plan EARLIER_LATER than the specified date. Valid dates are GREATER_LESSER than
2204: -- MAX_MIN_DATE;
2205: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CSC_RSP_INVALID_DATE_UPDATE');
2206: fnd_message.set_token ('DATE_TYPE', 'End Date Active');
2207: fnd_message.set_token('EARLIER_LATER', 'later');
2208: fnd_message.set_token('GREATER_LESSER', 'greater');
2209: fnd_message.set_token('MAX_MIN_DATE', l_max_date);
2202: -- DATE_TYPE date cannot be updated to specified value. There are customers who are associated
2203: -- to this plan EARLIER_LATER than the specified date. Valid dates are GREATER_LESSER than
2204: -- MAX_MIN_DATE;
2205: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CSC_RSP_INVALID_DATE_UPDATE');
2206: fnd_message.set_token ('DATE_TYPE', 'End Date Active');
2207: fnd_message.set_token('EARLIER_LATER', 'later');
2208: fnd_message.set_token('GREATER_LESSER', 'greater');
2209: fnd_message.set_token('MAX_MIN_DATE', l_max_date);
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2203: -- to this plan EARLIER_LATER than the specified date. Valid dates are GREATER_LESSER than
2204: -- MAX_MIN_DATE;
2205: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CSC_RSP_INVALID_DATE_UPDATE');
2206: fnd_message.set_token ('DATE_TYPE', 'End Date Active');
2207: fnd_message.set_token('EARLIER_LATER', 'later');
2208: fnd_message.set_token('GREATER_LESSER', 'greater');
2209: fnd_message.set_token('MAX_MIN_DATE', l_max_date);
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: end if;
2204: -- MAX_MIN_DATE;
2205: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CSC_RSP_INVALID_DATE_UPDATE');
2206: fnd_message.set_token ('DATE_TYPE', 'End Date Active');
2207: fnd_message.set_token('EARLIER_LATER', 'later');
2208: fnd_message.set_token('GREATER_LESSER', 'greater');
2209: fnd_message.set_token('MAX_MIN_DATE', l_max_date);
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: end if;
2212:
2205: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CSC_RSP_INVALID_DATE_UPDATE');
2206: fnd_message.set_token ('DATE_TYPE', 'End Date Active');
2207: fnd_message.set_token('EARLIER_LATER', 'later');
2208: fnd_message.set_token('GREATER_LESSER', 'greater');
2209: fnd_message.set_token('MAX_MIN_DATE', l_max_date);
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: end if;
2212:
2213: /*
2213: /*
2214: if ( trunc(p_end_date_active) < trunc(l_max_date) ) then
2215: -- END date cannot be updated to specified value. There are customers who are associated
2216: -- to this plan LATER than the specified date. Valid dates are GREATER than MAX_DATE;
2217: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2218: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2219: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2220: fnd_message.set_token('VALUE', p_end_date_active);
2221: fnd_message.set_token('PARAMETER', 'END_DATE_ACTIVE');
2214: if ( trunc(p_end_date_active) < trunc(l_max_date) ) then
2215: -- END date cannot be updated to specified value. There are customers who are associated
2216: -- to this plan LATER than the specified date. Valid dates are GREATER than MAX_DATE;
2217: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2218: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2219: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2220: fnd_message.set_token('VALUE', p_end_date_active);
2221: fnd_message.set_token('PARAMETER', 'END_DATE_ACTIVE');
2222: -- fnd_msg_pub.add;
2215: -- END date cannot be updated to specified value. There are customers who are associated
2216: -- to this plan LATER than the specified date. Valid dates are GREATER than MAX_DATE;
2217: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2218: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2219: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2220: fnd_message.set_token('VALUE', p_end_date_active);
2221: fnd_message.set_token('PARAMETER', 'END_DATE_ACTIVE');
2222: -- fnd_msg_pub.add;
2223: x_return_status := FND_API.G_RET_STS_ERROR;
2216: -- to this plan LATER than the specified date. Valid dates are GREATER than MAX_DATE;
2217: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2218: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2219: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2220: fnd_message.set_token('VALUE', p_end_date_active);
2221: fnd_message.set_token('PARAMETER', 'END_DATE_ACTIVE');
2222: -- fnd_msg_pub.add;
2223: x_return_status := FND_API.G_RET_STS_ERROR;
2224: end if;
2217: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
2218: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
2219: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
2220: fnd_message.set_token('VALUE', p_end_date_active);
2221: fnd_message.set_token('PARAMETER', 'END_DATE_ACTIVE');
2222: -- fnd_msg_pub.add;
2223: x_return_status := FND_API.G_RET_STS_ERROR;
2224: end if;
2225: */