141: open c;
142: fetch c into recinfo;
143: if (c%notfound) then
144: close c;
145: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
146: app_exception.raise_exception;
147: end if;
148: close c;
149: if ( ((recinfo.DEFAULT_FLAG = X_DEFAULT_FLAG)
164: OR ((recinfo.END_DATE_ACTIVE is null) AND (X_END_DATE_ACTIVE is null)))
165: ) then
166: null;
167: else
168: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
169: app_exception.raise_exception;
170: end if;
171:
172: for tlinfo in c1 loop
177: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
178: ) then
179: null;
180: else
181: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
182: app_exception.raise_exception;
183: end if;
184: end if;
185: end loop;