eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_RELATIONSHIP_PLANS_PVT dependencies on FND_MESSAGE

Line 323: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');

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;

Line 324: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;

Line 378: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 379: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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;

Line 380: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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;

Line 381: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');

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

Line 394: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 395: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 396: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 397: fnd_message.set_token('VALUE', p_csc_plan_headers_b_rec.use_for_cust_account);

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;

Line 398: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');

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;

Line 913: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');

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;

Line 914: FND_MESSAGE.Set_Token ('INFO', 'csc_relationship_plans', FALSE);

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;

Line 931: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_RECORD_CHANGED');

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;

Line 932: FND_MESSAGE.Set_Token('INFO', 'csc_relationship_plans', FALSE);

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;

Line 1345: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1346: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1347: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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;

Line 1348: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');

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;

Line 1360: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

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;

Line 1361: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');

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;

Line 1362: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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;

Line 1363: fnd_message.set_token('DUPLICATE_VAL_PARAM', '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;
1367: close check_dup_plan_id;

Line 1406: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1407: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1408: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 1409: fnd_message.set_token('NULL_PARAM', 'PLAN_NAME');

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:

Line 1427: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

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;

Line 1428: -- fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');

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');

Line 1429: -- fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_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;

Line 1430: -- fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');

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

Line 1432: fnd_message.set_name ('CSC', 'CSC_RSP_DUPLICATE_NAME');

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

Line 1437: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

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;

Line 1438: fnd_message.set_name ('CS', 'CS_API_ALL_DUPLICATE_VALUE');

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;

Line 1439: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);

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;

Line 1440: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'PLAN_NAME');

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;

Line 1488: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1489: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1490: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 1491: fnd_message.set_token('NULL_PARAM', 'ORIGINAL_PLAN_ID');

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;

Line 1502: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 1503: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 1504: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 1505: fnd_message.set_token('VALUE', p_original_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;
1509: close chk_original_plan_id;

Line 1506: fnd_message.set_token('PARAMETER', '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;

Line 1551: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1552: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1553: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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

Line 1554: fnd_message.set_token('NULL_PARAM', 'PLAN_GROUP_CODE');

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.

Line 1564: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 1565: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 1566: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 1567: fnd_message.set_token('VALUE', p_plan_group_code);

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;

Line 1568: fnd_message.set_token('PARAMETER', 'PLAN_GROUP_CODE');

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;

Line 1612: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1613: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1614: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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

Line 1615: fnd_message.set_token('NULL_PARAM', 'USE_FOR_CUST_ACCOUNT');

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');

Line 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');

Line 1620: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 1621: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 1622: fnd_message.set_token('VALUE', p_use_for_cust_account);

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

Line 1623: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');

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

Line 1636: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');

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');

Line 1637: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');

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;

Line 1639: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');

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;

Line 1640: fnd_message.set_token('UPDATE_PARAM', 'PLAN_LEVEL');

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;

Line 1692: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 1693: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 1694: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 1695: fnd_message.set_token('VALUE', p_end_user_type);

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;

Line 1696: fnd_message.set_token('PARAMETER', 'END_USER_TYPE');

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:

Line 1729: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1730: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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

Line 1731: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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');

Line 1732: fnd_message.set_token('NULL_PARAM', 'CUSTOMIZED_PLAN');

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');

Line 1735: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, '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');

Line 1736: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 1737: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 1738: fnd_message.set_token('VALUE', p_customized_plan);

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;

Line 1739: fnd_message.set_token('PARAMETER', 'CUSTOMIZED_PLAN');

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:

Line 1788: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1789: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1790: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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

Line 1791: fnd_message.set_token('NULL_PARAM', 'PROFILE_CHECK_ID');

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

Line 1803: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');

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');

Line 1804: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');

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;

Line 1806: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');

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;

Line 1807: fnd_message.set_token('UPDATE_PARAM', 'PROFILE_CHECK_ID');

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:

Line 1824: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 1825: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 1826: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 1827: fnd_message.set_token('VALUE', p_profile_check_id);

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;

Line 1828: fnd_message.set_token('PARAMETER', 'PROFILE_CHECK_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;
1832: end if;

Line 1871: --fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1872: --fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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

Line 1873: --fnd_message.set_token('NULL_PARAM', 'CRITERIA_VALUE_LOW');

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

Line 1885: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');

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');

Line 1886: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');

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;

Line 1888: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');

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;

Line 1889: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_LOW');

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:

Line 1938: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');

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');

Line 1939: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');

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;

Line 1941: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');

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;

Line 1942: fnd_message.set_token('UPDATE_PARAM', 'CRITERIA_VALUE_HIGH');

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:

Line 1984: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1985: fnd_message.set_name ('CS', 'CS_API_ALL_NULL_PARAMETER');

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;

Line 1986: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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

Line 1987: fnd_message.set_token('NULL_PARAM', 'RELATIONAL_OPERATOR');

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

Line 1999: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_ALL_UPDATE_NOT_ALLOWED');

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');

Line 2000: -- fnd_message.set_name ('CS', 'CS_ALL_UPDATE_NOT_ALLOWED');

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;

Line 2002: fnd_message.set_name ('CSC', 'CSC_RSP_INVALID_UPDATE');

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;

Line 2003: fnd_message.set_token('UPDATE_PARAM', 'RELATIONAL_OPERATOR');

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:

Line 2049: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 2050: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 2051: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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

Line 2052: fnd_message.set_token('VALUE', p_relational_operator);

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.

Line 2053: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');

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');

Line 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');

Line 2058: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 2059: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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

Line 2060: fnd_message.set_token('VALUE', p_criteria_value_low);

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.

Line 2061: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE LOW');

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');

Line 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');

Line 2066: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 2067: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 2068: fnd_message.set_token('VALUE', p_criteria_value_high);

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

Line 2069: fnd_message.set_token('PARAMETER', 'CRITERIA VALUE HIGH');

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' )

Line 2077: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 2078: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 2079: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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

Line 2080: fnd_message.set_token('VALUE', p_relational_operator);

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

Line 2081: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');

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.

Line 2086: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 2087: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 2088: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 2089: fnd_message.set_token('VALUE', p_criteria_value_high);

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

Line 2090: fnd_message.set_token('PARAMETER', 'CRITERIA 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
2094: p_relational_operator = 'IS NOT NULL' )

Line 2098: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 2099: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 2100: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 2101: fnd_message.set_token('VALUE', p_relational_operator);

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;

Line 2102: fnd_message.set_token('PARAMETER', 'RELATIONAL OPERATOR');

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:

Line 2147: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 2148: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 2149: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 2150: fnd_message.set_token('VALUE', p_start_date_active);

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;

Line 2151: fnd_message.set_token('PARAMETER', 'START_DATE_ACTIVE');

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;

Line 2205: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CSC_RSP_INVALID_DATE_UPDATE');

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);

Line 2206: fnd_message.set_token ('DATE_TYPE', 'End Date Active');

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;

Line 2207: fnd_message.set_token('EARLIER_LATER', 'later');

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;

Line 2208: fnd_message.set_token('GREATER_LESSER', 'greater');

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:

Line 2209: fnd_message.set_token('MAX_MIN_DATE', l_max_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:
2213: /*

Line 2217: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

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');

Line 2218: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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;

Line 2219: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

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;

Line 2220: fnd_message.set_token('VALUE', p_end_date_active);

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;

Line 2221: fnd_message.set_token('PARAMETER', 'END_DATE_ACTIVE');

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: */