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_API

Line 245: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

241: l_latest_set_id NUMBER;
242:
243: BEGIN
244:
245: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
246:
247: SELECT locked_by
248: INTO l_locked_by
249: FROM CS_KB_SETS_B

Line 263: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

259: UPDATE CS_KB_SETS_B
260: SET locked_by = P_USER_ID
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;

Line 268: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
272: END IF;

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 278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 702: RETURN fnd_api.g_false;

698: FROM cs_lookups
699: WHERE lookup_type = 'CS_KB_INTERNAL_CODES'
700: AND lookup_code = upper(p_status);
701: IF(l_count<1) THEN
702: RETURN fnd_api.g_false;
703: ELSE
704: RETURN fnd_api.g_true;
705: END IF;
706:

Line 704: RETURN fnd_api.g_true;

700: AND lookup_code = upper(p_status);
701: IF(l_count<1) THEN
702: RETURN fnd_api.g_false;
703: ELSE
704: RETURN fnd_api.g_true;
705: END IF;
706:
707: RETURN fnd_api.g_true;
708:

Line 707: RETURN fnd_api.g_true;

703: ELSE
704: RETURN fnd_api.g_true;
705: END IF;
706:
707: RETURN fnd_api.g_true;
708:
709: END Is_Status_Valid;
710:
711: -- Api's used in 11.5.10 by OAF:

Line 769: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

765: AND nvl(End_Date_Active, sysdate+1);
766:
767:
768: BEGIN
769: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
770:
771: -- Check Security
772: OPEN Check_Visibility;
773: FETCH Check_Visibility INTO l_vis_count;

Line 780: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 791: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 807: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 822: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 843: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 867: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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

914: x_end_active_date => NULL,
915: x_priority_code => 4,
916: x_visibility_id => p_visibility_id );
917:
918: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
919:
920: UPDATE CS_KB_SETS_B
921: SET LATEST_VERSION_FLAG = null --'N'
922: WHERE SET_NUMBER = x_set_number

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1020: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1016: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
1017: AND nvl(End_Date_Active, sysdate+1);
1018:
1019: BEGIN
1020: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1021:
1022: -- Check Security
1023: OPEN Check_Visibility;
1024: FETCH Check_Visibility INTO l_vis_count;

Line 1031: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1035: ELSE

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 1041: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1045: ELSE

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 1055: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 1077: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1081: End If;

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 1087: IF(Is_Status_Valid(p_status) = FND_API.g_false) THEN

1083:
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;

Line 1091: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1095: ELSE

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 1108: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1112: ELSE

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

1155: x_end_active_date => null,
1156: x_priority_code => 4,
1157: x_visibility_id => p_visibility_id );
1158:
1159: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1160:
1161: END IF; -- check unique solution title (except those with same set_number)
1162:
1163: END IF; --valid status

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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);
1181: END Update_Solution;

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 1223: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1219: -- test varchar2(10);
1220: l_dup_count NUMBER;
1221:
1222: BEGIN
1223: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1224: X_RETURN := -1;
1225: SAVEPOINT START_OF_SUBMIT;
1226:
1227: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1278: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1274: -- Start_Wf is an Internal api that performs the following:
1275: -- 1) Clone Solution
1276: -- 2) Send Notification via Oracle WorkFlow
1277:
1278: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1279:
1280: CS_KB_WF_PKG.Start_Wf( p_set_number => p_set_number,
1281: p_set_id => p_set_id,
1282: p_new_step => p_new_step,

Line 1295: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1299: END IF;

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 1324: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

1517: 'SAV',
1518: NULL, --p_flow_details_id
1519: l_current_user);
1520:
1521: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1522:
1523: ELSE
1524: -- If Not Published assign the lock to the current version for
1525: -- the current user

Line 1530: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1526:
1527: IF (l_locked_by = -1) THEN
1528: -- Soln is unlocked so lock with current user
1529: Set_Lock_Info(p_set_id, l_current_user, sysdate);
1530: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1531:
1532: ELSIF (l_locked_by = l_current_user) THEN
1533: -- Current User already has the lock, ignore - do nothing
1534: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 1534: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1530: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1531:
1532: ELSIF (l_locked_by = l_current_user) THEN
1533: -- Current User already has the lock, ignore - do nothing
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;

Line 1541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 1555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1559: END IF;

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 1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1567:

Line 1574: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1570: --category. Otherwise, the existing link to P_SRC_CAT_ID will be removed.
1571: --
1572: PROCEDURE Move_Solutions(
1573: p_api_version in number,
1574: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1575: p_commit in varchar2 := FND_API.G_FALSE,
1576: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1577: x_return_status OUT NOCOPY varchar2,
1578: x_msg_count OUT NOCOPY number,

Line 1575: p_commit in varchar2 := FND_API.G_FALSE,

1571: --
1572: PROCEDURE Move_Solutions(
1573: p_api_version in number,
1574: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1575: p_commit in varchar2 := FND_API.G_FALSE,
1576: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1577: x_return_status OUT NOCOPY varchar2,
1578: x_msg_count OUT NOCOPY number,
1579: x_msg_data OUT NOCOPY varchar2,

Line 1576: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1572: PROCEDURE Move_Solutions(
1573: p_api_version in number,
1574: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1575: p_commit in varchar2 := FND_API.G_FALSE,
1576: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1577: x_return_status OUT NOCOPY varchar2,
1578: x_msg_count OUT NOCOPY number,
1579: x_msg_data OUT NOCOPY varchar2,
1580: P_SET_IDS IN JTF_NUMBER_TABLE,

Line 1602: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1598: l_count NUMBER;
1599:
1600: BEGIN
1601: SAVEPOINT MOVE_SOLUTIONS;
1602: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1605: 'User='||fnd_global.user_id);
1606: END IF;

Line 1677: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1673: --Mark solution for index update.
1674: CS_KB_SYNC_INDEX_PKG.Mark_Idxs_For_Multi_Soln(P_SET_IDS);
1675:
1676: --Return.
1677: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1678:
1679: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1680: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1681: 'Status='||X_RETURN_STATUS);

Line 1684: if fnd_api.to_boolean( p_commit ) then

1680: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1681: 'Status='||X_RETURN_STATUS);
1682: END IF;
1683:
1684: if fnd_api.to_boolean( p_commit ) then
1685: commit;
1686: end if;
1687:
1688: EXCEPTION

Line 1699: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1703: WHEN INVALID_SET_CATEGORY_LINK THEN

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 1713: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1717: WHEN OTHERS THEN

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 1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1724:

Line 1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1793: END unlock_solution;