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_SOLUTION_PVT dependencies on FND_MSG_PUB

Line 265: FND_MSG_PUB.initialize;

261: WHERE set_id = P_SET_ID;
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 ,

Line 267: FND_MSG_PUB.ADD;

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,
271: p_data => X_MSG_DATA);

Line 269: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
271: p_data => X_MSG_DATA);
272: END IF;
273:

Line 280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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);
282: END Snatch_Lock_From_User;
283:
284:

Line 777: FND_MSG_PUB.initialize;

773: FETCH Check_Visibility INTO l_vis_count;
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;

Line 779: FND_MSG_PUB.ADD;

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 ,
783: p_count => X_MSG_COUNT,

Line 782: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
783: p_count => X_MSG_COUNT,
784: p_data => X_MSG_DATA);
785: ELSE
786: -- check params

Line 788: FND_MSG_PUB.initialize;

784: p_data => X_MSG_DATA);
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;

Line 790: FND_MSG_PUB.ADD;

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 ,
794: p_count => X_MSG_COUNT,

Line 793: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
794: p_count => X_MSG_COUNT,
795: p_data => X_MSG_DATA);
796:
797: ELSE

Line 804: FND_MSG_PUB.initialize;

800: FROM CS_KB_SET_TYPES_B
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;

Line 806: FND_MSG_PUB.ADD;

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 ,
810: p_count => X_MSG_COUNT,

Line 809: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
810: p_count => X_MSG_COUNT,
811: p_data => X_MSG_DATA);
812:
813: ELSE

Line 819: FND_MSG_PUB.initialize;

815: Fetch check_active_type_csr Into l_dummy;
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;

Line 821: FND_MSG_PUB.ADD;

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 ,
825: p_count => X_MSG_COUNT,

Line 824: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
825: p_count => X_MSG_COUNT,
826: p_data => X_MSG_DATA);
827: ELSE
828: --check status

Line 840: FND_MSG_PUB.initialize;

836: WHERE name = p_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;

Line 842: FND_MSG_PUB.ADD;

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 ,
846: p_count => X_MSG_COUNT,

Line 845: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
846: p_count => X_MSG_COUNT,
847: p_data => X_MSG_DATA);
848: ELSE
849:

Line 864: FND_MSG_PUB.initialize;

860: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
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;

Line 866: FND_MSG_PUB.ADD;

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 ,
870: p_count => X_MSG_COUNT,

Line 869: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
870: p_count => X_MSG_COUNT,
871: p_data => X_MSG_DATA);
872:
873: ELSE

Line 957: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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);
959: END Create_Solution;
960:
961:

Line 1028: FND_MSG_PUB.initialize;

1024: FETCH Check_Visibility INTO l_vis_count;
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 ,

Line 1030: FND_MSG_PUB.ADD;

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,
1034: p_data => X_MSG_DATA);

Line 1032: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1034: p_data => X_MSG_DATA);
1035: ELSE
1036: -- validate params

Line 1038: FND_MSG_PUB.initialize;

1034: p_data => X_MSG_DATA);
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 ,

Line 1040: FND_MSG_PUB.ADD;

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,
1044: p_data => X_MSG_DATA);

Line 1042: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1044: p_data => X_MSG_DATA);
1045: ELSE
1046:

Line 1052: FND_MSG_PUB.initialize;

1048: FROM CS_KB_SET_TYPES_B
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 ,

Line 1054: FND_MSG_PUB.ADD;

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,
1058: p_data => X_MSG_DATA);

Line 1056: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1058: p_data => X_MSG_DATA);
1059:
1060: ELSE

Line 1074: FND_MSG_PUB.initialize;

1070: Open validate_old_type_used_csr(p_set_type_id, p_set_id);
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 ,

Line 1076: FND_MSG_PUB.ADD;

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,
1080: p_data => X_MSG_DATA);

Line 1078: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1080: p_data => X_MSG_DATA);
1081: End If;
1082: End If;

Line 1088: FND_MSG_PUB.initialize;

1084: IF l_dummy is not null THEN
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 ,

Line 1090: FND_MSG_PUB.ADD;

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,
1094: p_data => X_MSG_DATA);

Line 1092: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1094: p_data => X_MSG_DATA);
1095: ELSE
1096:

Line 1105: FND_MSG_PUB.initialize;

1101: AND status = 'PUB'
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 ,

Line 1107: FND_MSG_PUB.ADD;

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,
1111: p_data => X_MSG_DATA);

Line 1109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1111: p_data => X_MSG_DATA);
1112: ELSE
1113:

Line 1176: FND_MSG_PUB.ADD;

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,
1180: p_data => X_MSG_DATA);

Line 1178: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1180: p_data => X_MSG_DATA);
1181: END Update_Solution;
1182:

Line 1289: FND_MSG_PUB.initialize;

1285:
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);

Line 1294: FND_MSG_PUB.ADD;

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;
1296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1297: p_count => X_MSG_COUNT,
1298: p_data => X_MSG_DATA);

Line 1296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1292: VALUE => l_errormsg,
1293: TRANSLATE => true);
1294: FND_MSG_PUB.ADD;
1295: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1297: p_count => X_MSG_COUNT,
1298: p_data => X_MSG_DATA);
1299: END IF;
1300:

Line 1318: FND_MSG_PUB.initialize;

1314: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Unexpected',
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);

Line 1323: FND_MSG_PUB.ADD;

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;
1325: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1326: p_count => X_MSG_COUNT,
1327: p_data => X_MSG_DATA);

Line 1325: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1321: VALUE => SQLERRM,
1322: TRANSLATE => true);
1323: FND_MSG_PUB.ADD;
1324: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1325: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1326: p_count => X_MSG_COUNT,
1327: p_data => X_MSG_DATA);
1328:
1329: END Submit_Solution;

Line 1538: FND_MSG_PUB.initialize;

1534: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
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 ,

Line 1540: FND_MSG_PUB.ADD;

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,
1544: p_data => X_MSG_DATA);

Line 1542: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1544: p_data => X_MSG_DATA);
1545:
1546: END IF;

Line 1552: FND_MSG_PUB.initialize;

1548: END IF;
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 ,

Line 1554: FND_MSG_PUB.ADD;

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,
1558: p_data => X_MSG_DATA);

Line 1556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1558: p_data => X_MSG_DATA);
1559: END IF;
1560: EXCEPTION

Line 1564: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
1567:
1568: --Move given solutions from source category to destnation category.

Line 1696: FND_MSG_PUB.initialize;

1692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.validate_parameters',
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 ,

Line 1698: FND_MSG_PUB.ADD;

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,
1702: p_data => X_MSG_DATA);

Line 1700: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1702: p_data => X_MSG_DATA);
1703: WHEN INVALID_SET_CATEGORY_LINK THEN
1704: ROLLBACK TO MOVE_SOLUTIONS;

Line 1710: FND_MSG_PUB.initialize;

1706: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.update_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 ,

Line 1712: FND_MSG_PUB.ADD;

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,
1716: p_data => X_MSG_DATA);

Line 1714: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
1716: p_data => X_MSG_DATA);
1717: WHEN OTHERS THEN
1718: ROLLBACK TO MOVE_SOLUTIONS;

Line 1721: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
1724:
1725: -- Unlock Locked Solutions in Draft Mode

Line 1790: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
1793: END unlock_solution;
1794: -- End Bugfix 7117546