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.CS_KB_SECURITY_PVT dependencies on FND_MESSAGE

Line 349: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

345: 'P_ADD_BEFORE_POSITION='||P_ADD_BEFORE_VISIBILITY||
346: 'P_ADD_AFTER_POSITION='||P_ADD_AFTER_VISIBILITY);
347: END IF;
348: FND_MSG_PUB.initialize;
349: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
350: FND_MSG_PUB.ADD;
351: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
352: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
353: p_count => X_MSG_COUNT,

Line 363: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');

359: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.insertcheck',
360: 'Insert Row has failed='||l_check);
361: END IF;
362: FND_MSG_PUB.initialize;
363: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');
364: FND_MSG_PUB.ADD;
365: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
367: p_count => X_MSG_COUNT,

Line 376: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_DUP_ERROR');

372: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.dupcheck',
373: 'Visibility Name is a Duplicate='||P_NAME);
374: END IF;
375: FND_MSG_PUB.initialize;
376: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_DUP_ERROR');
377: FND_MSG_PUB.ADD;
378: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
380: p_count => X_MSG_COUNT,

Line 400: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

396: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.UNEXPECTED',
398: ' Error= '||sqlerrm);
399: END IF;
400: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
403: p_data => x_msg_data);
404: END CREATE_VISIBILITY;

Line 566: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

562: 'P_NAME='||P_NAME||
563: 'P_VISIBILITY='||P_VISIBILITY_ID);
564: END IF;
565: FND_MSG_PUB.initialize;
566: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
567: FND_MSG_PUB.ADD;
568: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
570: p_count => X_MSG_COUNT,

Line 579: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');

575: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.updcheck',
576: 'Update Row has failed='||l_check);
577: END IF;
578: FND_MSG_PUB.initialize;
579: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
580: FND_MSG_PUB.ADD;
581: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
583: p_count => X_MSG_COUNT,

Line 592: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_DUP_ERROR');

588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.dupcheck',
589: 'Visibility Name is a Duplicate='||P_NAME);
590: END IF;
591: FND_MSG_PUB.initialize;
592: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_DUP_ERROR');
593: FND_MSG_PUB.ADD;
594: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
596: p_count => X_MSG_COUNT,

Line 605: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

601: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.UNEXPECTED',
603: ' Error= '||sqlerrm);
604: END IF;
605: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
608: p_data => x_msg_data);
609: END UPDATE_VISIBILITY;

Line 761: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

757: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.invparam',
758: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
759: END IF;
760: FND_MSG_PUB.initialize;
761: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
762: FND_MSG_PUB.ADD;
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
765: p_count => X_MSG_COUNT,

Line 773: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_INV_DEL');

769: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.invdel',
770: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
771: END IF;
772: FND_MSG_PUB.initialize;
773: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_INV_DEL');
774: FND_MSG_PUB.ADD;
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
777: p_count => X_MSG_COUNT,

Line 786: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');

782: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.deletefail',
783: 'Delete Row has failed='||l_vis_count);
784: END IF;
785: FND_MSG_PUB.initialize;
786: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
787: FND_MSG_PUB.ADD;
788: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
790: p_count => X_MSG_COUNT,

Line 809: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

805: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.UNEXPECTED',
807: ' Error= '||sqlerrm);
808: END IF;
809: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
811: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
812: p_data => x_msg_data);
813: END DELETE_VISIBILITY;

Line 1031: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

1027: 'P_NAME='||P_NAME||
1028: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1029: END IF;
1030: FND_MSG_PUB.initialize;
1031: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1032: FND_MSG_PUB.ADD;
1033: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1035: p_count => X_MSG_COUNT,

Line 1044: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');

1040: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insertcheck',
1041: 'Insert Row has failed='||l_check);
1042: END IF;
1043: FND_MSG_PUB.initialize;
1044: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');
1045: FND_MSG_PUB.ADD;
1046: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1048: p_count => X_MSG_COUNT,

Line 1057: FND_MESSAGE.set_name('CS', 'CS_KB_CG_DUP_ERROR');

1053: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.dupcheck',
1054: 'Category Group Name is a Duplicate='||P_NAME);
1055: END IF;
1056: FND_MSG_PUB.initialize;
1057: FND_MESSAGE.set_name('CS', 'CS_KB_CG_DUP_ERROR');
1058: FND_MSG_PUB.ADD;
1059: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1060: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1061: p_count => X_MSG_COUNT,

Line 1070: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

1066: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1067: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.UNEXPECTED',
1068: ' Error= '||sqlerrm);
1069: END IF;
1070: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1072: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1073: p_data => x_msg_data);
1074:

Line 1220: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

1216: 'P_NAME='||P_NAME||
1217: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1218: END IF;
1219: FND_MSG_PUB.initialize;
1220: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1221: FND_MSG_PUB.ADD;
1222: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1223: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1224: p_count => X_MSG_COUNT,

Line 1233: FND_MESSAGE.set_name('CS', 'CS_KB_CG_DUP_ERROR');

1229: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.dupcheck',
1230: 'Update is Duplicate='||p_name);
1231: END IF;
1232: FND_MSG_PUB.initialize;
1233: FND_MESSAGE.set_name('CS', 'CS_KB_CG_DUP_ERROR');
1234: FND_MSG_PUB.ADD;
1235: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1236: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1237: p_count => X_MSG_COUNT,

Line 1246: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');

1242: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.updatecheck',
1243: 'Update Row has failed='||l_check);
1244: END IF;
1245: FND_MSG_PUB.initialize;
1246: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
1247: FND_MSG_PUB.ADD;
1248: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1250: p_count => X_MSG_COUNT,

Line 1258: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

1254: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1255: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.UNEXPECTED',
1256: ' Error= '||sqlerrm);
1257: END IF;
1258: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1260: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1261: p_data => x_msg_data);
1262: END UPDATE_CATEGORY_GROUP;

Line 1382: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

1378: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.invparam',
1379: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1380: END IF;
1381: FND_MSG_PUB.initialize;
1382: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1383: FND_MSG_PUB.ADD;
1384: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1385: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1386: p_count => X_MSG_COUNT,

Line 1395: FND_MESSAGE.set_name('CS', 'CS_KB_CG_NOT_FOUND');

1391: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.invdel',
1392: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1393: END IF;
1394: FND_MSG_PUB.initialize;
1395: FND_MESSAGE.set_name('CS', 'CS_KB_CG_NOT_FOUND');
1396: FND_MSG_PUB.ADD;
1397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1398: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1399: p_count => X_MSG_COUNT,

Line 1408: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');

1404: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.deletefail',
1405: 'Delete Row has failed='||l_valid);
1406: END IF;
1407: FND_MSG_PUB.initialize;
1408: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
1409: FND_MSG_PUB.ADD;
1410: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1412: p_count => X_MSG_COUNT,

Line 1422: FND_MESSAGE.set_name('CS', 'CS_KB_INV_DEL_CG');

1418: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.memexist',
1419: 'Members Exist for Cat Grp='||l_member_count);
1420: END IF;
1421: FND_MSG_PUB.initialize;
1422: FND_MESSAGE.set_name('CS', 'CS_KB_INV_DEL_CG');
1423: FND_MSG_PUB.ADD;
1424: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1425: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1426: p_count => X_MSG_COUNT,

Line 1436: FND_MESSAGE.set_name('CS', 'CS_KB_INV_DEL_CG');

1432: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.flowexist',
1433: 'Flows Exist for Cat Grp='||l_flow_count);
1434: END IF;
1435: FND_MSG_PUB.initialize;
1436: FND_MESSAGE.set_name('CS', 'CS_KB_INV_DEL_CG');
1437: FND_MSG_PUB.ADD;
1438: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1440: p_count => X_MSG_COUNT,

Line 1449: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

1445: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1446: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.UNEXPECTED',
1447: ' Error= '||sqlerrm);
1448: END IF;
1449: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1451: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1452: p_data => x_msg_data);
1453:

Line 1727: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

1723: 'P_CATEGORY_ID='||P_CATEGORY_ID||
1724: '+P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1725: END IF;
1726: FND_MSG_PUB.initialize;
1727: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1728: FND_MSG_PUB.ADD;
1729: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1731: p_count => X_MSG_COUNT,

Line 1741: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');

1737: 'Insert Row has failed='||l_check);
1738: END IF;
1739: ROLLBACK TO Create_Cat_Group_Member_PVT;
1740: FND_MSG_PUB.initialize;
1741: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');
1742: FND_MSG_PUB.ADD;
1743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1744: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1745: p_count => X_MSG_COUNT,

Line 1756: FND_MESSAGE.set_name('CS', 'CS_KB_CGM_DUP_ERROR');

1752: 'Member already included: P_CATEGORY_ID='||P_CATEGORY_ID||
1753: '+P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1754: END IF;
1755: FND_MSG_PUB.initialize;
1756: FND_MESSAGE.set_name('CS', 'CS_KB_CGM_DUP_ERROR');
1757: FND_MSG_PUB.ADD;
1758: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1759: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1760: p_count => X_MSG_COUNT,

Line 1780: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

1776: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1777: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.UNEXPECTED',
1778: ' Error= '||sqlerrm);
1779: END IF;
1780: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1782: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1783: p_data => x_msg_data);
1784:

Line 1903: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

1899: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID||
1900: ' P_CATEGORY_ID='||P_CATEGORY_ID);
1901: END IF;
1902: FND_MSG_PUB.initialize;
1903: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1904: FND_MSG_PUB.ADD;
1905: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1906: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1907: p_count => X_MSG_COUNT,

Line 1915: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');

1911: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.deletefail',
1912: 'Delete Row has failed='||l_valid);
1913: END IF;
1914: FND_MSG_PUB.initialize;
1915: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
1916: FND_MSG_PUB.ADD;
1917: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1918: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1919: p_count => X_MSG_COUNT,

Line 1939: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

1935: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1936: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP_MEMBER.UNEXPECTED',
1937: ' Error= '||sqlerrm);
1938: END IF;
1939: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1942: p_data => x_msg_data);
1943:

Line 2241: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

2237: 'P_PARENT_CATEGORY_ID='||P_PARENT_CATEGORY_ID||
2238: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
2239: END IF;
2240: FND_MSG_PUB.initialize;
2241: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2242: FND_MSG_PUB.ADD;
2243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2245: p_count => X_MSG_COUNT,

Line 2254: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

2250: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2251: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.ADD_CATEGORY_TO_DENORM.UNEXPECTED',
2252: ' Error= '||sqlerrm);
2253: END IF;
2254: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2257: p_data => x_msg_data);
2258: END ADD_CATEGORY_TO_DENORM;

Line 2355: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

2351: 'P_CATEGORY_ID='||P_CATEGORY_ID||
2352: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
2353: END IF;
2354: FND_MSG_PUB.initialize;
2355: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2356: FND_MSG_PUB.ADD;
2357: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2358: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2359: p_count => X_MSG_COUNT,

Line 2368: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

2364: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2365: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_TO_DENORM.UNEXPECTED',
2366: ' Error= '||sqlerrm);
2367: END IF;
2368: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2370: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2371: p_data => x_msg_data);
2372: END UPDATE_CATEGORY_TO_DENORM;

Line 2456: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

2452: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.invparam',
2453: 'P_CATEGORY_ID='||P_CATEGORY_ID);
2454: END IF;
2455: FND_MSG_PUB.initialize;
2456: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2457: FND_MSG_PUB.ADD;
2458: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2459: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2460: p_count => X_MSG_COUNT,

Line 2470: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');

2466: 'Member Count='||l_member_count||
2467: 'Denorm Count='||l_denorm_count);
2468: END IF;
2469: FND_MSG_PUB.initialize;
2470: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
2471: FND_MSG_PUB.ADD;
2472: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2474: p_count => X_MSG_COUNT,

Line 2483: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

2479: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2480: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.UNEXPECTED',
2481: ' Error= '||sqlerrm);
2482: END IF;
2483: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2486: p_data => x_msg_data);
2487: END REMOVE_CATEGORY_FROM_CAT_GROUP;

Line 2864: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_CG');

2860:
2861: EXCEPTION
2862: WHEN INV_SEC_CAT_GRP THEN
2863: FND_MSG_PUB.initialize;
2864: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_CG');
2865: FND_MSG_PUB.ADD;
2866: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2867: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2868: p_count => X_MSG_COUNT,

Line 2872: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_SOL_VIS');

2868: p_count => X_MSG_COUNT,
2869: p_data => X_MSG_DATA);
2870: WHEN INV_SEC_SOLN_VIS THEN
2871: FND_MSG_PUB.initialize;
2872: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_SOL_VIS');
2873: FND_MSG_PUB.ADD;
2874: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2875: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2876: p_count => X_MSG_COUNT,

Line 2880: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_STM_VIS');

2876: p_count => X_MSG_COUNT,
2877: p_data => X_MSG_DATA);
2878: WHEN INV_SEC_STMT_VIS THEN
2879: FND_MSG_PUB.initialize;
2880: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_STM_VIS');
2881: FND_MSG_PUB.ADD;
2882: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2884: p_count => X_MSG_COUNT,

Line 2888: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

2884: p_count => X_MSG_COUNT,
2885: p_data => X_MSG_DATA);
2886:
2887: WHEN OTHERS THEN
2888: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2889: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2890: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.GET_SECURITY_PROFILES.UNEXPECTED',
2891: ' Error= '||sqlerrm);
2892: END IF;

Line 3163: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

3159: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3160: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.MOVE_CATEGORY_IN_DENORM.UNEXPECTED',
3161: ' Error= '||sqlerrm);
3162: END IF;
3163: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3165: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3166: p_data => x_msg_data);
3167: END MOVE_CATEGORY_IN_DENORM;