189: open c;
190: fetch c into recinfo;
191: if (c%notfound) then
192: close c;
193: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
194: app_exception.raise_exception;
195: end if;
196: close c;
197: if ( (recinfo.GROUP_ID = X_GROUP_ID)
229: OR ((recinfo.OLD_TIME_ZONE is null) AND (X_OLD_TIME_ZONE is null)))
230: ) then
231: null;
232: else
233: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
234: app_exception.raise_exception;
235: end if;
236:
237: for tlinfo in c1 loop
246: OR ((tlinfo.OLD_GROUP_DESC is null) AND (X_OLD_GROUP_DESC is null)))
247: ) then
248: null;
249: else
250: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
251: app_exception.raise_exception;
252: end if;
253: end if;
254: end loop;