138: open c;
139: fetch c into recinfo;
140: if (c%notfound) then
141: close c;
142: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
143: app_exception.raise_exception;
144: end if;
145: close c;
146: if ( ((recinfo.EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE)
155: AND (recinfo.USERTYPE_KEY = X_USERTYPE_KEY)
156: ) then
157: null;
158: else
159: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
160: app_exception.raise_exception;
161: end if;
162:
163: for tlinfo in c1 loop
166: AND (tlinfo.DESCRIPTION = X_DESCRIPTION)
167: ) then
168: null;
169: else
170: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
171: app_exception.raise_exception;
172: end if;
173: end if;
174: end loop;