180: OPEN C;
181: FETCH C INTO Recinfo;
182: If (C%NOTFOUND) then
183: CLOSE C;
184: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
185: APP_EXCEPTION.RAISE_EXCEPTION;
186: End If;
187: CLOSE C;
188: if (
230: AND ( x_STATUS = NULL )))
231: ) then
232: return;
233: else
234: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
235: APP_EXCEPTION.RAISE_EXCEPTION;
236: End If;
237: END Lock_Row;
238:
267: WHERE work_class_id = x_work_class_id;
268:
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
272: --2890664, Changed this token
273: FND_MESSAGE.SET_TOKEN('RECORD', 'WORK_CLASS_REC');
274: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_work_class_id));
275: FND_MSG_PUB.ADD;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
272: --2890664, Changed this token
273: FND_MESSAGE.SET_TOKEN('RECORD', 'WORK_CLASS_REC');
274: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_work_class_id));
275: FND_MSG_PUB.ADD;
276: RAISE FND_API.G_EXC_ERROR;
277:
270: WHEN NO_DATA_FOUND THEN
271: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
272: --2890664, Changed this token
273: FND_MESSAGE.SET_TOKEN('RECORD', 'WORK_CLASS_REC');
274: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_work_class_id));
275: FND_MSG_PUB.ADD;
276: RAISE FND_API.G_EXC_ERROR;
277:
278: END Select_Row;