303: open c;
304: fetch c into recinfo;
305: if (c%notfound) then
306: close c;
307: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
308: app_exception.raise_exception;
309: end if;
310: close c;
311: if ( ((recinfo.VARIABLE_DEFAULT_VALUE = X_VARIABLE_DEFAULT_VALUE)
372: OR ((recinfo.VARIABLE_SOURCE is null) AND (X_VARIABLE_SOURCE is null)))
373: ) then
374: null;
375: else
376: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
377: app_exception.raise_exception;
378: end if;
379:
380: for tlinfo in c1 loop
384: AND (tlinfo.VARIABLE_NAME = X_VARIABLE_NAME)
385: ) then
386: null;
387: else
388: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
389: app_exception.raise_exception;
390: end if;
391: end if;
392: end loop;