161: open c;
162: fetch c into recinfo;
163: if (c%notfound) then
164: close c;
165: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
166: app_exception.raise_exception;
167: end if;
168: close c;
169: if ( ((recinfo.EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE)
175: AND (recinfo.APPLICATION_ID = X_APPLICATION_ID)
176: ) then
177: null;
178: else
179: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
180: app_exception.raise_exception;
181: end if;
182:
183: for tlinfo in c1 loop
187: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
188: ) then
189: null;
190: else
191: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
192: app_exception.raise_exception;
193: end if;
194: end if;
195: end loop;