294: OPEN C1;
295: FETCH C1 INTO Recinfo;
296: IF (C1%NOTFOUND) THEN
297: CLOSE C1;
298: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
299: APP_EXCEPTION.RAISE_EXCEPTION;
300: END IF;
301: CLOSE C1;
302:
302:
303: IF (Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) THEN
304: return;
305: ELSE
306: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
307: APP_EXCEPTION.RAISE_EXCEPTION;
308: END IF;
309:
310: FOR tlinfo IN C2 LOOP
314: OR ((tlinfo.description IS NULL) AND (p_description IS NULL))))
315: THEN
316: null;
317: ELSE
318: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
319: APP_EXCEPTION.RAISE_EXCEPTION;
320: END IF;
321: END IF;
322: END LOOP;