219: END IF;
220:
221:
222: if(l_repair_group_id is null) then
223: FND_MESSAGE.Set_Name('CSD', 'CSD_API_REPAIR_GROUP_ID');
224: FND_MESSAGE.Set_Token('REPAIR_GROUP_ID',l_repair_group_id);
225: FND_MSG_PUB.ADD;
226: RAISE FND_API.G_EXC_ERROR;
227: end if;
220:
221:
222: if(l_repair_group_id is null) then
223: FND_MESSAGE.Set_Name('CSD', 'CSD_API_REPAIR_GROUP_ID');
224: FND_MESSAGE.Set_Token('REPAIR_GROUP_ID',l_repair_group_id);
225: FND_MSG_PUB.ADD;
226: RAISE FND_API.G_EXC_ERROR;
227: end if;
228: -----------------------
464: INTO l_repair_group_id,
465: l_obj_ver_num;
466:
467: IF repair_order_group%NOTFOUND THEN
468: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GROUP_MISSING');
469: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',l_repair_group_id);
470: FND_MSG_PUB.ADD;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
465: l_obj_ver_num;
466:
467: IF repair_order_group%NOTFOUND THEN
468: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GROUP_MISSING');
469: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',l_repair_group_id);
470: FND_MSG_PUB.ADD;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:
491: csd_gen_utility_pvt.ADD('object version number does not match');
492: END IF;
493:
494:
495: FND_MESSAGE.SET_NAME('CSD','CSD_GRP_OBJ_VER_MISMATCH');
496: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',l_repair_group_id);
497: FND_MSG_PUB.ADD;
498: RAISE FND_API.G_EXC_ERROR;
499:
492: END IF;
493:
494:
495: FND_MESSAGE.SET_NAME('CSD','CSD_GRP_OBJ_VER_MISMATCH');
496: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',l_repair_group_id);
497: FND_MSG_PUB.ADD;
498: RAISE FND_API.G_EXC_ERROR;
499:
500: END IF;
553: (l_repair_type_id <> x_repair_order_group_rec.repair_type_id ) OR
554: (l_unit_of_measure <> x_repair_order_group_rec.unit_of_measure) OR
555: (l_group_quantity <> x_repair_order_group_rec.group_quantity)) THEN
556:
557: FND_MESSAGE.SET_NAME('CSD','CSD_API_UPDATE_NOT_ALLOWED');
558: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',x_repair_order_group_rec.repair_group_id);
559: FND_MSG_PUB.ADD;
560:
561: RAISE FND_API.G_EXC_ERROR;
554: (l_unit_of_measure <> x_repair_order_group_rec.unit_of_measure) OR
555: (l_group_quantity <> x_repair_order_group_rec.group_quantity)) THEN
556:
557: FND_MESSAGE.SET_NAME('CSD','CSD_API_UPDATE_NOT_ALLOWED');
558: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',x_repair_order_group_rec.repair_group_id);
559: FND_MSG_PUB.ADD;
560:
561: RAISE FND_API.G_EXC_ERROR;
562:
774: null;
775: END;
776:
777: IF ( l_count > 0 ) then
778: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_ORDER_EXISTS');
779: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
780: FND_MSG_PUB.ADD;
781:
782: RAISE FND_API.G_EXC_ERROR;
775: END;
776:
777: IF ( l_count > 0 ) then
778: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_ORDER_EXISTS');
779: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
780: FND_MSG_PUB.ADD;
781:
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
1097: WHERE resource_id = p_resource_id;
1098:
1099: EXCEPTION
1100: WHEN NO_DATA_FOUND THEN
1101: FND_MESSAGE.SET_NAME('CSD','CSD_API_INVALID_RESOURCE');
1102: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',p_resource_id);
1103: FND_MSG_PUB.ADD;
1104:
1105: RAISE FND_API.G_EXC_ERROR;
1098:
1099: EXCEPTION
1100: WHEN NO_DATA_FOUND THEN
1101: FND_MESSAGE.SET_NAME('CSD','CSD_API_INVALID_RESOURCE');
1102: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',p_resource_id);
1103: FND_MSG_PUB.ADD;
1104:
1105: RAISE FND_API.G_EXC_ERROR;
1106: WHEN OTHERS THEN
1150: X_Msg_Data => l_msg_data
1151: );
1152:
1153: If ( l_return_status <> 'S') then
1154: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_ORDER_UPD_FAIL');
1155: FND_MSG_PUB.ADD;
1156:
1157: RAISE FND_API.G_EXC_ERROR;
1158:
1310:
1311:
1312: IF l_return_status <> 'S' THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR ;
1314: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GROUP_EST_FAIL');
1315: FND_MSG_PUB.ADD;
1316: ELSIF l_return_status = 'S' THEN
1317: x_object_version_number := l_group_ro_rec.object_version_number;
1318: END IF;