299: open c;
300: fetch c into recinfo;
301: if (c%notfound) then
302: close c;
303: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
304: app_exception.raise_exception;
305: end if;
306: close c;
307: if ( (recinfo.SUBSTITUTION_NAME = X_SUBSTITUTION_NAME)
382: OR ((recinfo.ATTRIBUTE30 is null) AND (X_ATTRIBUTE30 is null)))
383: ) then
384: null;
385: else
386: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
387: app_exception.raise_exception;
388: end if;
389:
390: for tlinfo in c1 loop
392: if ( (tlinfo.SUBSTITUTION_DESCRIPTION = X_SUBSTITUTION_DESCRIPTION)
393: ) then
394: null;
395: else
396: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
397: app_exception.raise_exception;
398: end if;
399: end if;
400: end loop;