245: open c;
246: fetch c into recinfo;
247: if (c%notfound) then
248: close c;
249: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
250: app_exception.raise_exception;
251: end if;
252: close c;
253:
310: OR ((recinfo.INVENTORY_ORG_ID is null) AND (X_INVENTORY_ORG_ID is null)))
311: ) then
312: null;
313: else
314: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
315: app_exception.raise_exception;
316: end if;
317:
318: for tlinfo in c1 loop
323: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null)))
324: ) then
325: null;
326: else
327: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
328: app_exception.raise_exception;
329: end if;
330: end if;
331: end loop;