378: open c;
379: fetch c into recinfo;
380: if (c%notfound) then
381: close c;
382: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
383: app_exception.raise_exception;
384: end if;
385: close c;
386: if ( ((recinfo.USER_STATUS_ID = X_USER_STATUS_ID)
495: OR ((recinfo.SUBMTD_BY_FOR_SUPP_APPROVAL is null) AND (X_SUBMTD_BY_FOR_SUPP_APPROVAL is null)))
496: ) then
497: null;
498: else
499: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
500: app_exception.raise_exception;
501: end if;
502:
503: for tlinfo in c1 loop
506: OR ((tlinfo.REQUEST_DESCRIPTION is null) AND (X_REQUEST_DESCRIPTION is null)))
507: ) then
508: null;
509: else
510: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
511: app_exception.raise_exception;
512: end if;
513: end if;
514: end loop;