DBA Data[Home] [Help]

APPS.CS_KB_SOLUTION_PVT dependencies on FND_MESSAGE

Line 264: FND_MESSAGE.set_name('CS', 'CS_KB_C_SOL_LOCKED_BY_USER');

260:
261: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
262: ELSE
263: FND_MSG_PUB.initialize;
264: FND_MESSAGE.set_name('CS', 'CS_KB_C_SOL_LOCKED_BY_USER');
265: FND_MSG_PUB.ADD;
266: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
268: p_count => X_MSG_COUNT,

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

271:
272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277:
278: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
279: p_data => x_msg_data);

Line 764: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SOLN_VIS');

760: CLOSE Check_Visibility;
761:
762: IF l_vis_count = 0 THEN
763: FND_MSG_PUB.initialize;
764: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SOLN_VIS');
765: FND_MSG_PUB.ADD;
766: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
767: X_SET_ID := -1;
768: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 775: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

771: ELSE
772: -- check params
773: IF(p_set_type_id IS NULL OR p_name IS NULL) THEN
774: FND_MSG_PUB.initialize;
775: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
776: FND_MSG_PUB.ADD;
777: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
778: X_SET_ID := -1;
779: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 791: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');

787: WHERE set_type_id = p_set_type_id;
788:
789: IF(l_count <1) THEN
790: FND_MSG_PUB.initialize;
791: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');
792: FND_MSG_PUB.ADD;
793: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
794: X_SET_ID := -2;
795: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 806: FND_MESSAGE.set_name('CS', 'CS_KB_EXPIRED_SOLUTION_TYPE');

802: Close check_active_type_csr;
803:
804: IF l_dummy Is Null Then
805: FND_MSG_PUB.initialize;
806: FND_MESSAGE.set_name('CS', 'CS_KB_EXPIRED_SOLUTION_TYPE');
807: FND_MSG_PUB.ADD;
808: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
809: X_SET_ID := -4;
810: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 827: FND_MESSAGE.set_name('CS', 'CS_KB_C_DUP_SET_NAME');

823: AND status = 'PUB';
824:
825: IF(l_count >0) THEN
826: FND_MSG_PUB.initialize;
827: FND_MESSAGE.set_name('CS', 'CS_KB_C_DUP_SET_NAME');
828: FND_MSG_PUB.ADD;
829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
830: X_SET_ID := -3;
831: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 851: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

847: END LOOP;
848:
849: IF x_set_id is NULL OR x_set_number is null THEN
850: FND_MSG_PUB.initialize;
851: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
852: FND_MSG_PUB.ADD;
853: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
854: X_SET_ID := -1;
855: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

936: END IF; -- Security Check
937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942:
943: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
944: p_data => x_msg_data);

Line 1015: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SOLN_VIS');

1011: CLOSE Check_Visibility;
1012:
1013: IF l_vis_count = 0 THEN
1014: FND_MSG_PUB.initialize;
1015: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SOLN_VIS');
1016: FND_MSG_PUB.ADD;
1017: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1018: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1019: p_count => X_MSG_COUNT,

Line 1025: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

1021: ELSE
1022: -- validate params
1023: IF(p_set_number IS NULL OR p_set_id IS NULL OR p_set_type_id IS NULL ) THEN
1024: FND_MSG_PUB.initialize;
1025: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
1026: FND_MSG_PUB.ADD;
1027: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1028: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1029: p_count => X_MSG_COUNT,

Line 1039: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');

1035: WHERE set_type_id = p_set_type_id;
1036:
1037: IF(l_count <1) THEN
1038: FND_MSG_PUB.initialize;
1039: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');
1040: FND_MSG_PUB.ADD;
1041: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1042: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1043: p_count => X_MSG_COUNT,

Line 1061: FND_MESSAGE.set_name('CS', 'CS_KB_END_DATED_TYPE');

1057: Fetch validate_old_type_used_csr Into l_dummy;
1058: Close validate_old_type_used_csr;
1059: If l_dummy Is Null Then
1060: FND_MSG_PUB.initialize;
1061: FND_MESSAGE.set_name('CS', 'CS_KB_END_DATED_TYPE');
1062: FND_MSG_PUB.ADD;
1063: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1064: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1065: p_count => X_MSG_COUNT,

Line 1075: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_STATUS');

1071:
1072: -- IF status valid
1073: IF(Is_Status_Valid(p_status) = FND_API.g_false) THEN
1074: FND_MSG_PUB.initialize;
1075: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_STATUS');
1076: FND_MSG_PUB.ADD;
1077: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1078: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1079: p_count => X_MSG_COUNT,

Line 1092: FND_MESSAGE.set_name('CS', 'CS_KB_C_DUP_SET_NAME');

1088: AND set_number <> p_set_number;
1089:
1090: IF(l_count >0) THEN
1091: FND_MSG_PUB.initialize;
1092: FND_MESSAGE.set_name('CS', 'CS_KB_C_DUP_SET_NAME');
1093: FND_MSG_PUB.ADD;
1094: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1095: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1096: p_count => X_MSG_COUNT,

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

1157: END IF; -- Security Visibility Check
1158:
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
1162: FND_MSG_PUB.ADD;
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1164: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1165: p_count => X_MSG_COUNT,

Line 1276: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');

1272: IF l_results < 1 THEN
1273: ROLLBACK TO START_OF_SUBMIT;
1274: X_RETURN := -1; -- 'CS_KB_C_MISS_PARAM'
1275: FND_MSG_PUB.initialize;
1276: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');
1277: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',
1278: VALUE => l_errormsg,
1279: TRANSLATE => true);
1280: FND_MSG_PUB.ADD;

Line 1277: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',

1273: ROLLBACK TO START_OF_SUBMIT;
1274: X_RETURN := -1; -- 'CS_KB_C_MISS_PARAM'
1275: FND_MSG_PUB.initialize;
1276: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');
1277: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',
1278: VALUE => l_errormsg,
1279: TRANSLATE => true);
1280: FND_MSG_PUB.ADD;
1281: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1305: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');

1301: 'Unexpected Exception for set id- '||P_SET_ID||' '||substrb(sqlerrm,1,200) );
1302: END IF;
1303:
1304: FND_MSG_PUB.initialize;
1305: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');
1306: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',
1307: VALUE => SQLERRM,
1308: TRANSLATE => true);
1309: FND_MSG_PUB.ADD;

Line 1306: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',

1302: END IF;
1303:
1304: FND_MSG_PUB.initialize;
1305: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');
1306: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',
1307: VALUE => SQLERRM,
1308: TRANSLATE => true);
1309: FND_MSG_PUB.ADD;
1310: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1525: FND_MESSAGE.set_name('CS', 'CS_KB_C_SOL_LOCKED_BY_USER');

1521: ELSE
1522: -- Another user has locked the Solution
1523: -- return unsuccessful
1524: FND_MSG_PUB.initialize;
1525: FND_MESSAGE.set_name('CS', 'CS_KB_C_SOL_LOCKED_BY_USER');
1526: FND_MSG_PUB.ADD;
1527: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1528: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1529: p_count => X_MSG_COUNT,

Line 1539: FND_MESSAGE.set_name('CS', 'CS_KB_CHECK_OUT_CHANGED');

1535:
1536: ELSE
1537: -- return unsuccessful
1538: FND_MSG_PUB.initialize;
1539: FND_MESSAGE.set_name('CS', 'CS_KB_CHECK_OUT_CHANGED');
1540: FND_MSG_PUB.ADD;
1541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1542: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1543: p_count => X_MSG_COUNT,

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

1544: p_data => X_MSG_DATA);
1545: END IF;
1546: EXCEPTION
1547: WHEN OTHERS THEN
1548: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1550: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1551: p_data => x_msg_data);
1552: END CheckOut_Solution;

Line 1683: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_CAT_ID');

1679: 'Invalid category ID:'||l_cat_id);
1680: END IF;
1681:
1682: FND_MSG_PUB.initialize;
1683: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_CAT_ID');
1684: FND_MSG_PUB.ADD;
1685: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1687: p_count => X_MSG_COUNT,

Line 1697: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SET_CAT_LINK');

1693: 'Invalid link (set_id,category_id): ('||l_set_id||','||l_cat_id||')');
1694: END IF;
1695:
1696: FND_MSG_PUB.initialize;
1697: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SET_CAT_LINK');
1698: FND_MSG_PUB.ADD;
1699: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1700: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1701: p_count => X_MSG_COUNT,

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

1701: p_count => X_MSG_COUNT,
1702: p_data => X_MSG_DATA);
1703: WHEN OTHERS THEN
1704: ROLLBACK TO MOVE_SOLUTIONS;
1705: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1708: p_data => x_msg_data);
1709: END Move_Solutions;

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

1770: END IF;
1771: x_return_status := 'S';
1772: EXCEPTION
1773: WHEN OTHERS THEN
1774: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1776: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1777: p_data => x_msg_data);
1778: ROLLBACK TO CS_KB_ULOCK_SOLUTION;