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_CUST_PLANS_PVT dependencies on FND_MESSAGE

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

278: IF FND_GLOBAL.User_Id IS NULL
279: THEN
280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
283: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
284: -- FND_MSG_PUB.ADD;
285: END IF;
286: RAISE FND_API.G_EXC_ERROR;

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

279: THEN
280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
283: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
284: -- FND_MSG_PUB.ADD;
285: END IF;
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;

Line 316: --FND_MESSAGE.SET_NAME(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, '

312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
314: FETCH c1 INTO l_start_date_active, l_end_date_active;
315: IF C1%NOTFOUND THEN
316: --FND_MESSAGE.SET_NAME(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, '
317: CLOSE c1;
318: RAISE NO_DATA_FOUND;
319: END IF;
320: CLOSE c1;

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

663: If ( C_Get_cust_plans%NOTFOUND) Then
664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
665: THEN
666: Close C_Get_cust_plans;
667: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
668: FND_MESSAGE.Set_Token ('INFO', 'cust_plans', FALSE);
669: -- FND_MSG_PUB.Add;
670: END IF;
671: raise FND_API.G_EXC_ERROR;

Line 668: FND_MESSAGE.Set_Token ('INFO', 'cust_plans', FALSE);

664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
665: THEN
666: Close C_Get_cust_plans;
667: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
668: FND_MESSAGE.Set_Token ('INFO', 'cust_plans', FALSE);
669: -- FND_MSG_PUB.Add;
670: END IF;
671: raise FND_API.G_EXC_ERROR;
672: END IF;

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

1112: fetch c1 into c1rec;
1113:
1114: if ( c1%NOTFOUND ) then
1115: close c1;
1116: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
1117: FND_MESSAGE.Set_Token ('INFO', 'CSC_CUST_PLANS', FALSE);
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: raise FND_API.G_EXC_ERROR;
1120: END IF;

Line 1117: FND_MESSAGE.Set_Token ('INFO', 'CSC_CUST_PLANS', FALSE);

1113:
1114: if ( c1%NOTFOUND ) then
1115: close c1;
1116: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
1117: FND_MESSAGE.Set_Token ('INFO', 'CSC_CUST_PLANS', FALSE);
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: raise FND_API.G_EXC_ERROR;
1120: END IF;
1121: close c1;

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

1430:
1431: -- validate NOT NULL column.
1432: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1433: IF(p_CUST_PLAN_ID is NULL or p_CUST_PLAN_ID = FND_API.G_MISS_NUM) then
1434: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1435: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1436: fnd_message.set_token('NULL_PARAM', 'CUST_PLAN_ID');
1437: -- fnd_msg_pub.add;
1438: x_return_status := FND_API.G_RET_STS_ERROR;

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

1431: -- validate NOT NULL column.
1432: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1433: IF(p_CUST_PLAN_ID is NULL or p_CUST_PLAN_ID = FND_API.G_MISS_NUM) then
1434: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1435: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1436: fnd_message.set_token('NULL_PARAM', 'CUST_PLAN_ID');
1437: -- fnd_msg_pub.add;
1438: x_return_status := FND_API.G_RET_STS_ERROR;
1439: END IF;

Line 1436: fnd_message.set_token('NULL_PARAM', 'CUST_PLAN_ID');

1432: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1433: IF(p_CUST_PLAN_ID is NULL or p_CUST_PLAN_ID = FND_API.G_MISS_NUM) then
1434: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1435: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1436: fnd_message.set_token('NULL_PARAM', 'CUST_PLAN_ID');
1437: -- fnd_msg_pub.add;
1438: x_return_status := FND_API.G_RET_STS_ERROR;
1439: END IF;
1440: end if;

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

1444: THEN
1445: open check_dup_id;
1446: fetch check_dup_id into l_cust_plan_id;
1447: if check_dup_id%FOUND then
1448: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1449: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1450: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CUST_PLAN_ID');
1451: -- fnd_msg_pub.add;
1452: x_return_status := FND_API.G_RET_STS_ERROR;

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

1445: open check_dup_id;
1446: fetch check_dup_id into l_cust_plan_id;
1447: if check_dup_id%FOUND then
1448: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1449: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1450: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CUST_PLAN_ID');
1451: -- fnd_msg_pub.add;
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: end if;

Line 1450: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CUST_PLAN_ID');

1446: fetch check_dup_id into l_cust_plan_id;
1447: if check_dup_id%FOUND then
1448: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1449: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1450: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CUST_PLAN_ID');
1451: -- fnd_msg_pub.add;
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: end if;
1454: close check_dup_id;

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

1489: x_return_status := FND_API.G_RET_STS_SUCCESS;
1490:
1491: -- validate NOT NULL column
1492: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1493: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1494: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1495: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1496: -- fnd_msg_pub.add;
1497: x_return_status := FND_API.G_RET_STS_ERROR;

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

1490:
1491: -- validate NOT NULL column
1492: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1493: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1494: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1495: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1496: -- fnd_msg_pub.add;
1497: x_return_status := FND_API.G_RET_STS_ERROR;
1498: END IF;

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

1491: -- validate NOT NULL column
1492: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1493: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1494: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1495: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1496: -- fnd_msg_pub.add;
1497: x_return_status := FND_API.G_RET_STS_ERROR;
1498: END IF;
1499:

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

1501: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1502: open c1;
1503: fetch c1 into l_plan_id;
1504: if c1%NOTFOUND then
1505: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1506: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1507: fnd_message.set_token('VALUE', p_plan_id);
1508: fnd_message.set_token('PARAMETER', 'PLAN_ID');
1509: -- fnd_msg_pub.add;

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

1502: open c1;
1503: fetch c1 into l_plan_id;
1504: if c1%NOTFOUND then
1505: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1506: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1507: fnd_message.set_token('VALUE', p_plan_id);
1508: fnd_message.set_token('PARAMETER', 'PLAN_ID');
1509: -- fnd_msg_pub.add;
1510: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1507: fnd_message.set_token('VALUE', p_plan_id);

1503: fetch c1 into l_plan_id;
1504: if c1%NOTFOUND then
1505: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1506: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1507: fnd_message.set_token('VALUE', p_plan_id);
1508: fnd_message.set_token('PARAMETER', 'PLAN_ID');
1509: -- fnd_msg_pub.add;
1510: x_return_status := FND_API.G_RET_STS_ERROR;
1511: end if;

Line 1508: fnd_message.set_token('PARAMETER', 'PLAN_ID');

1504: if c1%NOTFOUND then
1505: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1506: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1507: fnd_message.set_token('VALUE', p_plan_id);
1508: fnd_message.set_token('PARAMETER', 'PLAN_ID');
1509: -- fnd_msg_pub.add;
1510: x_return_status := FND_API.G_RET_STS_ERROR;
1511: end if;
1512: close c1;

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

1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547:
1548: -- validate NOT NULL column
1549: IF( p_PARTY_ID is NULL or p_party_id = FND_API.G_MISS_NUM ) then
1550: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1551: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1552: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
1553: -- fnd_msg_pub.add;
1554: x_return_status := FND_API.G_RET_STS_ERROR;

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

1547:
1548: -- validate NOT NULL column
1549: IF( p_PARTY_ID is NULL or p_party_id = FND_API.G_MISS_NUM ) then
1550: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1551: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1552: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
1553: -- fnd_msg_pub.add;
1554: x_return_status := FND_API.G_RET_STS_ERROR;
1555: END IF;

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

1548: -- validate NOT NULL column
1549: IF( p_PARTY_ID is NULL or p_party_id = FND_API.G_MISS_NUM ) then
1550: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1551: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1552: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
1553: -- fnd_msg_pub.add;
1554: x_return_status := FND_API.G_RET_STS_ERROR;
1555: END IF;
1556:

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

1558: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1559: open c1;
1560: fetch c1 into l_party_id;
1561: if c1%NOTFOUND then
1562: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1563: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1564: fnd_message.set_token('VALUE', p_party_id);
1565: fnd_message.set_token('PARAMETER', 'PARTY_ID');
1566: -- fnd_msg_pub.add;

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

1559: open c1;
1560: fetch c1 into l_party_id;
1561: if c1%NOTFOUND then
1562: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1563: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1564: fnd_message.set_token('VALUE', p_party_id);
1565: fnd_message.set_token('PARAMETER', 'PARTY_ID');
1566: -- fnd_msg_pub.add;
1567: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1564: fnd_message.set_token('VALUE', p_party_id);

1560: fetch c1 into l_party_id;
1561: if c1%NOTFOUND then
1562: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1563: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1564: fnd_message.set_token('VALUE', p_party_id);
1565: fnd_message.set_token('PARAMETER', 'PARTY_ID');
1566: -- fnd_msg_pub.add;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: end if;

Line 1565: fnd_message.set_token('PARAMETER', 'PARTY_ID');

1561: if c1%NOTFOUND then
1562: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1563: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1564: fnd_message.set_token('VALUE', p_party_id);
1565: fnd_message.set_token('PARAMETER', 'PARTY_ID');
1566: -- fnd_msg_pub.add;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: end if;
1569: close c1;

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

1611: -- Initialize API return status to SUCCESS
1612: x_return_status := FND_API.G_RET_STS_SUCCESS;
1613:
1614: if (p_cust_account_id is NULL or p_cust_account_org is NULL ) THEN
1615: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1616: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1617: if ( p_cust_account_id is NULL and p_cust_account_org is NULL ) then
1618: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID'||' and '||'P_CUST_ACCOUNT_ORG' );
1619: elsif ( p_cust_account_id is NULL and p_cust_account_org is not NULL ) then

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

1612: x_return_status := FND_API.G_RET_STS_SUCCESS;
1613:
1614: if (p_cust_account_id is NULL or p_cust_account_org is NULL ) THEN
1615: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1616: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1617: if ( p_cust_account_id is NULL and p_cust_account_org is NULL ) then
1618: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID'||' and '||'P_CUST_ACCOUNT_ORG' );
1619: elsif ( p_cust_account_id is NULL and p_cust_account_org is not NULL ) then
1620: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID');

Line 1618: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID'||' and '||'P_CUST_ACCOUNT_ORG' );

1614: if (p_cust_account_id is NULL or p_cust_account_org is NULL ) THEN
1615: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1616: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1617: if ( p_cust_account_id is NULL and p_cust_account_org is NULL ) then
1618: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID'||' and '||'P_CUST_ACCOUNT_ORG' );
1619: elsif ( p_cust_account_id is NULL and p_cust_account_org is not NULL ) then
1620: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID');
1621: else
1622: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ORG');

Line 1620: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID');

1616: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1617: if ( p_cust_account_id is NULL and p_cust_account_org is NULL ) then
1618: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID'||' and '||'P_CUST_ACCOUNT_ORG' );
1619: elsif ( p_cust_account_id is NULL and p_cust_account_org is not NULL ) then
1620: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID');
1621: else
1622: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ORG');
1623: end if;
1624: -- fnd_msg_pub.add;

Line 1622: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ORG');

1618: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID'||' and '||'P_CUST_ACCOUNT_ORG' );
1619: elsif ( p_cust_account_id is NULL and p_cust_account_org is not NULL ) then
1620: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID');
1621: else
1622: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ORG');
1623: end if;
1624: -- fnd_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: end if;

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

1628: if ( p_cust_account_id is not null and p_cust_account_org is not null ) then
1629: open c1;
1630: fetch c1 into l_cust_account_id, l_org_id;
1631: if c1%NOTFOUND then
1632: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1633: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1634: fnd_message.set_token('VALUE', p_cust_account_id ||', '|| p_cust_account_org);
1635: fnd_message.set_token('PARAMETER', 'CUST_ACCOUNT_ID, CUST_ACCOUNT_ORG');
1636: -- fnd_msg_pub.add;

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

1629: open c1;
1630: fetch c1 into l_cust_account_id, l_org_id;
1631: if c1%NOTFOUND then
1632: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1633: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1634: fnd_message.set_token('VALUE', p_cust_account_id ||', '|| p_cust_account_org);
1635: fnd_message.set_token('PARAMETER', 'CUST_ACCOUNT_ID, CUST_ACCOUNT_ORG');
1636: -- fnd_msg_pub.add;
1637: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1634: fnd_message.set_token('VALUE', p_cust_account_id ||', '|| p_cust_account_org);

1630: fetch c1 into l_cust_account_id, l_org_id;
1631: if c1%NOTFOUND then
1632: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1633: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1634: fnd_message.set_token('VALUE', p_cust_account_id ||', '|| p_cust_account_org);
1635: fnd_message.set_token('PARAMETER', 'CUST_ACCOUNT_ID, CUST_ACCOUNT_ORG');
1636: -- fnd_msg_pub.add;
1637: x_return_status := FND_API.G_RET_STS_ERROR;
1638: end if;

Line 1635: fnd_message.set_token('PARAMETER', 'CUST_ACCOUNT_ID, CUST_ACCOUNT_ORG');

1631: if c1%NOTFOUND then
1632: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1633: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1634: fnd_message.set_token('VALUE', p_cust_account_id ||', '|| p_cust_account_org);
1635: fnd_message.set_token('PARAMETER', 'CUST_ACCOUNT_ID, CUST_ACCOUNT_ORG');
1636: -- fnd_msg_pub.add;
1637: x_return_status := FND_API.G_RET_STS_ERROR;
1638: end if;
1639: close c1;

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

1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669:
1670: -- validate NOT NULL column
1671: IF( p_MANUAL_FLAG is NULL or p_MANUAL_FLAG = FND_API.G_MISS_CHAR ) then
1672: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1673: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1674: fnd_message.set_token('NULL_PARAM', 'MANUAL_FLAG');
1675: -- fnd_msg_pub.add;
1676: x_return_status := FND_API.G_RET_STS_ERROR;

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

1669:
1670: -- validate NOT NULL column
1671: IF( p_MANUAL_FLAG is NULL or p_MANUAL_FLAG = FND_API.G_MISS_CHAR ) then
1672: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1673: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1674: fnd_message.set_token('NULL_PARAM', 'MANUAL_FLAG');
1675: -- fnd_msg_pub.add;
1676: x_return_status := FND_API.G_RET_STS_ERROR;
1677: END IF;

Line 1674: fnd_message.set_token('NULL_PARAM', 'MANUAL_FLAG');

1670: -- validate NOT NULL column
1671: IF( p_MANUAL_FLAG is NULL or p_MANUAL_FLAG = FND_API.G_MISS_CHAR ) then
1672: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1673: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1674: fnd_message.set_token('NULL_PARAM', 'MANUAL_FLAG');
1675: -- fnd_msg_pub.add;
1676: x_return_status := FND_API.G_RET_STS_ERROR;
1677: END IF;
1678:

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

1677: END IF;
1678:
1679: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1680: if ( p_manual_flag <> 'Y' and p_manual_flag <> 'N' ) then
1681: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1682: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1683: fnd_message.set_token('VALUE', p_manual_flag);
1684: fnd_message.set_token('PARAMETER', 'P_MANUAL_FLAG');
1685: -- fnd_msg_pub.add;

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

1678:
1679: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1680: if ( p_manual_flag <> 'Y' and p_manual_flag <> 'N' ) then
1681: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1682: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1683: fnd_message.set_token('VALUE', p_manual_flag);
1684: fnd_message.set_token('PARAMETER', 'P_MANUAL_FLAG');
1685: -- fnd_msg_pub.add;
1686: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1683: fnd_message.set_token('VALUE', p_manual_flag);

1679: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1680: if ( p_manual_flag <> 'Y' and p_manual_flag <> 'N' ) then
1681: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1682: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1683: fnd_message.set_token('VALUE', p_manual_flag);
1684: fnd_message.set_token('PARAMETER', 'P_MANUAL_FLAG');
1685: -- fnd_msg_pub.add;
1686: x_return_status := FND_API.G_RET_STS_ERROR;
1687: end if;

Line 1684: fnd_message.set_token('PARAMETER', 'P_MANUAL_FLAG');

1680: if ( p_manual_flag <> 'Y' and p_manual_flag <> 'N' ) then
1681: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1682: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1683: fnd_message.set_token('VALUE', p_manual_flag);
1684: fnd_message.set_token('PARAMETER', 'P_MANUAL_FLAG');
1685: -- fnd_msg_pub.add;
1686: x_return_status := FND_API.G_RET_STS_ERROR;
1687: end if;
1688: end if;

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

1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725:
1726: -- validate NOT NULL column
1727: IF (p_PLAN_STATUS_CODE is NULL or p_PLAN_STATUS_CODE = FND_API.G_MISS_CHAR) then
1728: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1729: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1730: fnd_message.set_token('NULL_PARAM', 'PLAN_STATUS_CODE');
1731: -- fnd_msg_pub.add;
1732: x_return_status := FND_API.G_RET_STS_ERROR;

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

1725:
1726: -- validate NOT NULL column
1727: IF (p_PLAN_STATUS_CODE is NULL or p_PLAN_STATUS_CODE = FND_API.G_MISS_CHAR) then
1728: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1729: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1730: fnd_message.set_token('NULL_PARAM', 'PLAN_STATUS_CODE');
1731: -- fnd_msg_pub.add;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;

Line 1730: fnd_message.set_token('NULL_PARAM', 'PLAN_STATUS_CODE');

1726: -- validate NOT NULL column
1727: IF (p_PLAN_STATUS_CODE is NULL or p_PLAN_STATUS_CODE = FND_API.G_MISS_CHAR) then
1728: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1729: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1730: fnd_message.set_token('NULL_PARAM', 'PLAN_STATUS_CODE');
1731: -- fnd_msg_pub.add;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;
1734:

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

1738: fetch group_in_lookup into l_count;
1739: close group_in_lookup;
1740:
1741: if ( l_count = 0 or l_count > 1 ) then
1742: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1743: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1744: fnd_message.set_token('VALUE', p_plan_status_code);
1745: fnd_message.set_token('PARAMETER', 'P_STATUS_CODE');
1746: -- fnd_msg_pub.add;

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

1739: close group_in_lookup;
1740:
1741: if ( l_count = 0 or l_count > 1 ) then
1742: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1743: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1744: fnd_message.set_token('VALUE', p_plan_status_code);
1745: fnd_message.set_token('PARAMETER', 'P_STATUS_CODE');
1746: -- fnd_msg_pub.add;
1747: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1744: fnd_message.set_token('VALUE', p_plan_status_code);

1740:
1741: if ( l_count = 0 or l_count > 1 ) then
1742: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1743: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1744: fnd_message.set_token('VALUE', p_plan_status_code);
1745: fnd_message.set_token('PARAMETER', 'P_STATUS_CODE');
1746: -- fnd_msg_pub.add;
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748: end if;

Line 1745: fnd_message.set_token('PARAMETER', 'P_STATUS_CODE');

1741: if ( l_count = 0 or l_count > 1 ) then
1742: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1743: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1744: fnd_message.set_token('VALUE', p_plan_status_code);
1745: fnd_message.set_token('PARAMETER', 'P_STATUS_CODE');
1746: -- fnd_msg_pub.add;
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748: end if;
1749: end if;