198: open c;
199: fetch c into recinfo;
200: if (c%notfound) then
201: close c;
202: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
203: app_exception.raise_exception;
204: end if;
205: close c;
206: if ( ((recinfo.QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID)
245: OR ((recinfo.SECURITY_GROUP_ID is null) AND (X_SECURITY_GROUP_ID is null)))
246: ) then
247: null;
248: else
249: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
250: app_exception.raise_exception;
251: end if;
252:
253: for tlinfo in c1 loop
257: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
258: ) then
259: null;
260: else
261: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
262: app_exception.raise_exception;
263: end if;
264: end if;
265: end loop;