199: open c;
200: fetch c into recinfo;
201: if (c%notfound) then
202: close c;
203: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
204: app_exception.raise_exception;
205: end if;
206: close c;
207: if ( (recinfo.ENABLED_FLAG = X_ENABLED_FLAG)
242: AND ((recinfo.ATTRIBUTE_CATEGORY_CODE = X_ATTRIBUTE_CATEGORY_CODE)
243: OR ((recinfo.ATTRIBUTE_CATEGORY_CODE is null) AND (X_ATTRIBUTE_CATEGORY_CODE is null)))) then
244: null;
245: else
246: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
247: app_exception.raise_exception;
248: end if;
249:
250: for tlinfo in c1 loop
253: AND ((tlinfo.DESCRIPTION = X_DESCRIPTION)
254: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))) then
255: null;
256: else
257: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
258: app_exception.raise_exception;
259: end if;
260: end if;
261: end loop;