[Home] [Help]
308:
309: -- Initialize message list if p_init_msg_list is set to TRUE.
310: IF FND_API.to_Boolean( p_init_msg_list )
311: THEN
312: FND_MSG_PUB.initialize;
313: END IF;
314:
315: -- Initialize API return status to SUCCESS
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
318: -- ******************************************************************
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;
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;
329:
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
386: for i in 1..l_party_id_tbl.count
637: COMMIT WORK;
638: END IF;
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: FND_MSG_PUB.Count_And_Get
642: ( p_encoded => FND_API.G_FALSE,
643: p_count => x_msg_count,
644: p_data => x_msg_data );
645:
647: WHEN FND_API.G_EXC_ERROR THEN
648: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME,
650: P_PKG_NAME => G_PKG_NAME,
651: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
652: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
653: X_MSG_COUNT => X_MSG_COUNT,
654: X_MSG_DATA => X_MSG_DATA,
655: X_RETURN_STATUS => X_RETURN_STATUS);
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
660: P_API_NAME => L_API_NAME,
661: P_PKG_NAME => G_PKG_NAME,
662: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
663: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
664: X_MSG_COUNT => X_MSG_COUNT,
665: X_MSG_DATA => X_MSG_DATA,
666: X_RETURN_STATUS => X_RETURN_STATUS);
855:
856: -- Initialize message list if p_init_msg_list is set to TRUE.
857: IF FND_API.to_Boolean( p_init_msg_list )
858: THEN
859: FND_MSG_PUB.initialize;
860: END IF;
861:
862: -- Initialize API return status to SUCCESS
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
907: l_name,
908: l_description;
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;
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;
919: END IF;
925: -- record because the object_version_number would be different.
926:
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;
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;
937:
1141: COMMIT WORK;
1142: END IF;
1143:
1144: -- Standard call to get message count and if count is 1, get message info.
1145: FND_MSG_PUB.Count_And_Get
1146: ( p_encoded => FND_API.G_FALSE,
1147: p_count => x_msg_count,
1148: p_data => x_msg_data );
1149:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1153: P_API_NAME => L_API_NAME,
1154: P_PKG_NAME => G_PKG_NAME,
1155: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1156: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1157: X_MSG_COUNT => X_MSG_COUNT,
1158: X_MSG_DATA => X_MSG_DATA,
1159: X_RETURN_STATUS => X_RETURN_STATUS);
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1163: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1164: P_API_NAME => L_API_NAME,
1165: P_PKG_NAME => G_PKG_NAME,
1166: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1167: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1168: X_MSG_COUNT => X_MSG_COUNT,
1169: X_MSG_DATA => X_MSG_DATA,
1170: X_RETURN_STATUS => X_RETURN_STATUS);
1219:
1220: -- Initialize message list if p_init_msg_list is set to TRUE.
1221: IF FND_API.to_Boolean( p_init_msg_list )
1222: THEN
1223: FND_MSG_PUB.initialize;
1224: END IF;
1225:
1226: -- Initialize API return status to SUCCESS
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1270: COMMIT WORK;
1271: END IF;
1272:
1273: -- Standard call to get message count and if count is 1, get message info.
1274: FND_MSG_PUB.Count_And_Get
1275: ( p_encoded => FND_API.G_FALSE,
1276: p_count => x_msg_count,
1277: p_data => x_msg_data);
1278:
1280: WHEN FND_API.G_EXC_ERROR THEN
1281: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1282: P_API_NAME => L_API_NAME,
1283: P_PKG_NAME => G_PKG_NAME,
1284: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1285: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1286: X_MSG_COUNT => X_MSG_COUNT,
1287: X_MSG_DATA => X_MSG_DATA,
1288: X_RETURN_STATUS => X_RETURN_STATUS);
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1293: P_API_NAME => L_API_NAME,
1294: P_PKG_NAME => G_PKG_NAME,
1295: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1296: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1297: X_MSG_COUNT => X_MSG_COUNT,
1298: X_MSG_DATA => X_MSG_DATA,
1299: X_RETURN_STATUS => X_RETURN_STATUS);
1332: BEGIN
1333: -- Initialize message list if p_init_msg_list is set to TRUE.
1334: IF FND_API.to_Boolean( p_init_msg_list )
1335: THEN
1336: FND_MSG_PUB.initialize;
1337: END IF;
1338:
1339: -- Initialize API return status to SUCCESS
1340: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;
1353:
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;
1368: END IF;
1394: BEGIN
1395: -- Initialize message list if p_init_msg_list is set to TRUE.
1396: IF FND_API.to_Boolean( p_init_msg_list )
1397: THEN
1398: FND_MSG_PUB.initialize;
1399: END IF;
1400:
1401: -- Initialize API return status to SUCCESS
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:
1414: -- validate for duplicate plan_names.
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
1435: if ( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE and
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;
1445: end if;
1472: BEGIN
1473: -- Initialize message list if p_init_msg_list is set to TRUE.
1474: IF FND_API.to_Boolean( p_init_msg_list )
1475: THEN
1476: FND_MSG_PUB.initialize;
1477: END IF;
1478:
1479: -- Initialize API return status to SUCCESS
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;
1496: END IF;
1539: 01-26-2000
1540: -- Initialize message list if p_init_msg_list is set to TRUE.
1541: IF FND_API.to_Boolean( p_init_msg_list )
1542: THEN
1543: FND_MSG_PUB.initialize;
1544: END IF;
1545:
1546: -- Initialize API return status to SUCCESS
1547: x_return_status := FND_API.G_RET_STS_SUCCESS;
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.
1559: open group_in_lookup;
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;
1573:
1600: BEGIN
1601: -- Initialize message list if p_init_msg_list is set to TRUE.
1602: IF FND_API.to_Boolean( p_init_msg_list )
1603: THEN
1604: FND_MSG_PUB.initialize;
1605: END IF;
1606:
1607: -- Initialize API return status to SUCCESS
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
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');
1620: fnd_message.set_name ('CS', '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
1628: -- Check if there are any existing customer-to-plan associations for this particular
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;
1645: END IF;
1673: BEGIN
1674: -- Initialize message list if p_init_msg_list is set to TRUE.
1675: IF FND_API.to_Boolean( p_init_msg_list )
1676: THEN
1677: FND_MSG_PUB.initialize;
1678: END IF;
1679:
1680: -- Initialize API return status to SUCCESS
1681: x_return_status := FND_API.G_RET_STS_SUCCESS;
1717: BEGIN
1718: -- Initialize message list if p_init_msg_list is set to TRUE.
1719: IF FND_API.to_Boolean( p_init_msg_list )
1720: THEN
1721: FND_MSG_PUB.initialize;
1722: END IF;
1723:
1724: -- Initialize API return status to SUCCESS
1725: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:
1744: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1776:
1777: -- Initialize message list if p_init_msg_list is set to TRUE.
1778: IF FND_API.to_Boolean( p_init_msg_list )
1779: THEN
1780: FND_MSG_PUB.initialize;
1781: END IF;
1782:
1783: -- Initialize API return status to SUCCESS
1784: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
1796: --if ( G_CUST_PLANS_REC_CNT = FND_API.G_MISS_NUM ) then
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;
1833: END IF;
1859:
1860: -- Initialize message list if p_init_msg_list is set to TRUE.
1861: IF FND_API.to_Boolean( p_init_msg_list )
1862: THEN
1863: FND_MSG_PUB.initialize;
1864: END IF;
1865:
1866: -- Initialize API return status to SUCCESS
1867: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
1878: --if ( G_CUST_PLANS_REC_CNT = FND_API.G_MISS_NUM ) then
1919:
1920: -- Initialize message list if p_init_msg_list is set to TRUE.
1921: IF FND_API.to_Boolean( p_init_msg_list )
1922: THEN
1923: FND_MSG_PUB.initialize;
1924: END IF;
1925:
1926: -- Initialize API return status to SUCCESS
1927: x_return_status := FND_API.G_RET_STS_SUCCESS;
1972:
1973: -- Initialize message list if p_init_msg_list is set to TRUE.
1974: IF FND_API.to_Boolean( p_init_msg_list )
1975: THEN
1976: FND_MSG_PUB.initialize;
1977: END IF;
1978:
1979: -- Initialize API return status to SUCCESS
1980: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
1992: --if ( G_CUST_PLANS_REC_CNT = FND_API.G_MISS_NUM ) then
2027: BEGIN
2028: -- Initialize message list if p_init_msg_list is set to TRUE.
2029: IF FND_API.to_Boolean( p_init_msg_list )
2030: THEN
2031: FND_MSG_PUB.initialize;
2032: END IF;
2033:
2034: -- Initialize API return status to SUCCESS
2035: x_return_status := FND_API.G_RET_STS_SUCCESS;
2129:
2130: -- Initialize message list if p_init_msg_list is set to TRUE.
2131: IF FND_API.to_Boolean( p_init_msg_list )
2132: THEN
2133: FND_MSG_PUB.initialize;
2134: END IF;
2135:
2136: -- Initialize API return status to SUCCESS
2137: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;
2156:
2182: BEGIN
2183: -- Initialize message list if p_init_msg_list is set to TRUE.
2184: IF FND_API.to_Boolean( p_init_msg_list )
2185: THEN
2186: FND_MSG_PUB.initialize;
2187: END IF;
2188:
2189: -- Initialize API return status to SUCCESS
2190: x_return_status := FND_API.G_RET_STS_SUCCESS;
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: */
2226: end if;