109: open c;
110: fetch c into recinfo;
111: if (c%notfound) then
112: close c;
113: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
114: app_exception.raise_exception;
115: end if;
116: close c;
117: if ( ((recinfo.END_DATE = X_END_DATE)
120: AND (recinfo.START_DATE = X_START_DATE)
121: ) then
122: null;
123: else
124: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
125: app_exception.raise_exception;
126: end if;
127:
128: for tlinfo in c1 loop
132: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
133: ) then
134: null;
135: else
136: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
137: app_exception.raise_exception;
138: end if;
139: end if;
140: end loop;