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 263: FND_MSG_PUB.initialize;

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

Line 265: FND_MSG_PUB.ADD;

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

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

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

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

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);
280: END Snatch_Lock_From_User;
281:
282:

Line 763: FND_MSG_PUB.initialize;

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

Line 765: FND_MSG_PUB.ADD;

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

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

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 ,
769: p_count => X_MSG_COUNT,
770: p_data => X_MSG_DATA);
771: ELSE
772: -- check params

Line 774: FND_MSG_PUB.initialize;

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

Line 776: FND_MSG_PUB.ADD;

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

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

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 ,
780: p_count => X_MSG_COUNT,
781: p_data => X_MSG_DATA);
782:
783: ELSE

Line 790: FND_MSG_PUB.initialize;

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

Line 792: FND_MSG_PUB.ADD;

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

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

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

Line 805: FND_MSG_PUB.initialize;

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

Line 807: FND_MSG_PUB.ADD;

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

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

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

Line 826: FND_MSG_PUB.initialize;

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

Line 828: FND_MSG_PUB.ADD;

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

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

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 ,
832: p_count => X_MSG_COUNT,
833: p_data => X_MSG_DATA);
834: ELSE
835:

Line 850: FND_MSG_PUB.initialize;

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

Line 852: FND_MSG_PUB.ADD;

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

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

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 ,
856: p_count => X_MSG_COUNT,
857: p_data => X_MSG_DATA);
858:
859: ELSE

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

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);
945: END Create_Solution;
946:
947:

Line 1014: FND_MSG_PUB.initialize;

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

Line 1016: FND_MSG_PUB.ADD;

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

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

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,
1020: p_data => X_MSG_DATA);
1021: ELSE
1022: -- validate params

Line 1024: FND_MSG_PUB.initialize;

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

Line 1026: FND_MSG_PUB.ADD;

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

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

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,
1030: p_data => X_MSG_DATA);
1031: ELSE
1032:

Line 1038: FND_MSG_PUB.initialize;

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

Line 1040: FND_MSG_PUB.ADD;

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

Line 1060: FND_MSG_PUB.initialize;

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

Line 1062: FND_MSG_PUB.ADD;

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

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

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,
1066: p_data => X_MSG_DATA);
1067: End If;
1068: End If;

Line 1074: FND_MSG_PUB.initialize;

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

Line 1076: FND_MSG_PUB.ADD;

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

Line 1091: FND_MSG_PUB.initialize;

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

Line 1093: FND_MSG_PUB.ADD;

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

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

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,
1097: p_data => X_MSG_DATA);
1098: ELSE
1099:

Line 1162: FND_MSG_PUB.ADD;

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

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

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,
1166: p_data => X_MSG_DATA);
1167: END Update_Solution;
1168:

Line 1275: FND_MSG_PUB.initialize;

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

Line 1280: FND_MSG_PUB.ADD;

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

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

1278: VALUE => l_errormsg,
1279: TRANSLATE => true);
1280: FND_MSG_PUB.ADD;
1281: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1283: p_count => X_MSG_COUNT,
1284: p_data => X_MSG_DATA);
1285: END IF;
1286:

Line 1304: FND_MSG_PUB.initialize;

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

Line 1309: FND_MSG_PUB.ADD;

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

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

1307: VALUE => SQLERRM,
1308: TRANSLATE => true);
1309: FND_MSG_PUB.ADD;
1310: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1311: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1312: p_count => X_MSG_COUNT,
1313: p_data => X_MSG_DATA);
1314:
1315: END Submit_Solution;

Line 1524: FND_MSG_PUB.initialize;

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

Line 1526: FND_MSG_PUB.ADD;

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

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

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,
1530: p_data => X_MSG_DATA);
1531:
1532: END IF;

Line 1538: FND_MSG_PUB.initialize;

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

Line 1540: FND_MSG_PUB.ADD;

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

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

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

Line 1682: FND_MSG_PUB.initialize;

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

Line 1684: FND_MSG_PUB.ADD;

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

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

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,
1688: p_data => X_MSG_DATA);
1689: WHEN INVALID_SET_CATEGORY_LINK THEN
1690: ROLLBACK TO MOVE_SOLUTIONS;

Line 1696: FND_MSG_PUB.initialize;

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

Line 1698: FND_MSG_PUB.ADD;

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

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

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

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

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;
1779: END unlock_solution;
1780: -- End Bugfix 7117546