DBA Data[Home] [Help]

APPS.CS_KB_SOLUTION_PVT dependencies on FND_MESSAGE

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

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

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

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

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

774: CLOSE Check_Visibility;
775:
776: IF l_vis_count = 0 THEN
777: FND_MSG_PUB.initialize;
778: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SOLN_VIS');
779: FND_MSG_PUB.ADD;
780: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
781: X_SET_ID := -1;
782: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

785: ELSE
786: -- check params
787: IF(p_set_type_id IS NULL OR p_name IS NULL) THEN
788: FND_MSG_PUB.initialize;
789: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
790: FND_MSG_PUB.ADD;
791: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
792: X_SET_ID := -1;
793: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

801: WHERE set_type_id = p_set_type_id;
802:
803: IF(l_count <1) THEN
804: FND_MSG_PUB.initialize;
805: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');
806: FND_MSG_PUB.ADD;
807: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
808: X_SET_ID := -2;
809: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

816: Close check_active_type_csr;
817:
818: IF l_dummy Is Null Then
819: FND_MSG_PUB.initialize;
820: FND_MESSAGE.set_name('CS', 'CS_KB_EXPIRED_SOLUTION_TYPE');
821: FND_MSG_PUB.ADD;
822: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
823: X_SET_ID := -4;
824: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

837: AND status = 'PUB';
838:
839: IF(l_count >0) THEN
840: FND_MSG_PUB.initialize;
841: FND_MESSAGE.set_name('CS', 'CS_KB_C_DUP_SET_NAME');
842: FND_MSG_PUB.ADD;
843: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
844: X_SET_ID := -3;
845: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

861: END LOOP;
862:
863: IF x_set_id is NULL OR x_set_number is null THEN
864: FND_MSG_PUB.initialize;
865: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
866: FND_MSG_PUB.ADD;
867: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
868: X_SET_ID := -1;
869: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

950: END IF; -- Security Check
951:
952: EXCEPTION
953: WHEN OTHERS THEN
954: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956:
957: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
958: p_data => x_msg_data);

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

1025: CLOSE Check_Visibility;
1026:
1027: IF l_vis_count = 0 THEN
1028: FND_MSG_PUB.initialize;
1029: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SOLN_VIS');
1030: FND_MSG_PUB.ADD;
1031: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1033: p_count => X_MSG_COUNT,

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

1035: ELSE
1036: -- validate params
1037: IF(p_set_number IS NULL OR p_set_id IS NULL OR p_set_type_id IS NULL ) THEN
1038: FND_MSG_PUB.initialize;
1039: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
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 1053: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');

1049: WHERE set_type_id = p_set_type_id;
1050:
1051: IF(l_count <1) THEN
1052: FND_MSG_PUB.initialize;
1053: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');
1054: FND_MSG_PUB.ADD;
1055: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1056: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1057: p_count => X_MSG_COUNT,

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

1071: Fetch validate_old_type_used_csr Into l_dummy;
1072: Close validate_old_type_used_csr;
1073: If l_dummy Is Null Then
1074: FND_MSG_PUB.initialize;
1075: FND_MESSAGE.set_name('CS', 'CS_KB_END_DATED_TYPE');
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 1089: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_STATUS');

1085:
1086: -- IF status valid
1087: IF(Is_Status_Valid(p_status) = FND_API.g_false) THEN
1088: FND_MSG_PUB.initialize;
1089: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_SET_STATUS');
1090: FND_MSG_PUB.ADD;
1091: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1092: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1093: p_count => X_MSG_COUNT,

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

1102: AND set_number <> p_set_number;
1103:
1104: IF(l_count >0) THEN
1105: FND_MSG_PUB.initialize;
1106: FND_MESSAGE.set_name('CS', 'CS_KB_C_DUP_SET_NAME');
1107: FND_MSG_PUB.ADD;
1108: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1110: p_count => X_MSG_COUNT,

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

1171: END IF; -- Security Visibility Check
1172:
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
1176: FND_MSG_PUB.ADD;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1179: p_count => X_MSG_COUNT,

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

1286: IF l_results < 1 THEN
1287: ROLLBACK TO START_OF_SUBMIT;
1288: X_RETURN := -1; -- 'CS_KB_C_MISS_PARAM'
1289: FND_MSG_PUB.initialize;
1290: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');
1291: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',
1292: VALUE => l_errormsg,
1293: TRANSLATE => true);
1294: FND_MSG_PUB.ADD;

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

1287: ROLLBACK TO START_OF_SUBMIT;
1288: X_RETURN := -1; -- 'CS_KB_C_MISS_PARAM'
1289: FND_MSG_PUB.initialize;
1290: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');
1291: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',
1292: VALUE => l_errormsg,
1293: TRANSLATE => true);
1294: FND_MSG_PUB.ADD;
1295: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

1315: 'Unexpected Exception for set id- '||P_SET_ID||' '||substrb(sqlerrm,1,200) );
1316: END IF;
1317:
1318: FND_MSG_PUB.initialize;
1319: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');
1320: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',
1321: VALUE => SQLERRM,
1322: TRANSLATE => true);
1323: FND_MSG_PUB.ADD;

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

1316: END IF;
1317:
1318: FND_MSG_PUB.initialize;
1319: FND_MESSAGE.set_name('CS', 'CS_KB_C_ERROR_WF_API');
1320: FND_MESSAGE.SET_TOKEN(TOKEN => 'ERROR_MSG',
1321: VALUE => SQLERRM,
1322: TRANSLATE => true);
1323: FND_MSG_PUB.ADD;
1324: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

1535: ELSE
1536: -- Another user has locked the Solution
1537: -- return unsuccessful
1538: FND_MSG_PUB.initialize;
1539: FND_MESSAGE.set_name('CS', 'CS_KB_C_SOL_LOCKED_BY_USER');
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 1553: FND_MESSAGE.set_name('CS', 'CS_KB_CHECK_OUT_CHANGED');

1549:
1550: ELSE
1551: -- return unsuccessful
1552: FND_MSG_PUB.initialize;
1553: FND_MESSAGE.set_name('CS', 'CS_KB_CHECK_OUT_CHANGED');
1554: FND_MSG_PUB.ADD;
1555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1557: p_count => X_MSG_COUNT,

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

1558: p_data => X_MSG_DATA);
1559: END IF;
1560: EXCEPTION
1561: WHEN OTHERS THEN
1562: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1564: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1565: p_data => x_msg_data);
1566: END CheckOut_Solution;

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

1693: 'Invalid category ID:'||l_cat_id);
1694: END IF;
1695:
1696: FND_MSG_PUB.initialize;
1697: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_CAT_ID');
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 1711: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SET_CAT_LINK');

1707: 'Invalid link (set_id,category_id): ('||l_set_id||','||l_cat_id||')');
1708: END IF;
1709:
1710: FND_MSG_PUB.initialize;
1711: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SET_CAT_LINK');
1712: FND_MSG_PUB.ADD;
1713: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1714: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1715: p_count => X_MSG_COUNT,

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

1715: p_count => X_MSG_COUNT,
1716: p_data => X_MSG_DATA);
1717: WHEN OTHERS THEN
1718: ROLLBACK TO MOVE_SOLUTIONS;
1719: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1721: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1722: p_data => x_msg_data);
1723: END Move_Solutions;

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

1784: END IF;
1785: x_return_status := 'S';
1786: EXCEPTION
1787: WHEN OTHERS THEN
1788: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1790: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1791: p_data => x_msg_data);
1792: ROLLBACK TO CS_KB_ULOCK_SOLUTION;