220: OPEN c;
221: FETCH c INTO recinfo;
222: IF (c%NOTFOUND) THEN
223: CLOSE c;
224: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
225: app_exception.raise_exception;
226: END IF;
227: CLOSE c;
228: IF ( (recinfo.MODULE_TYPE = X_MODULE_TYPE)
246: OR ((recinfo.COLLECT_FLAG IS NULL) AND (X_COLLECT_FLAG IS NULL)))
247: ) THEN
248: NULL;
249: ELSE
250: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
251: app_exception.raise_exception;
252: END IF;
253:
254: FOR tlinfo IN c1 LOOP
256: IF ( (tlinfo.NAME = X_NAME)
257: ) THEN
258: NULL;
259: ELSE
260: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
261: app_exception.raise_exception;
262: END IF;
263: END IF;
264: END LOOP;