230: OPEN cb;
231: FETCH cb INTO binfo;
232: IF (cb%notfound) THEN
233: CLOSE cb;
234: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
235: app_exception.raise_exception;
236: END IF;
237: CLOSE cb;
238:
240: OPEN c;
241: FETCH c INTO recinfo;
242: IF (c%notfound) THEN
243: CLOSE c;
244: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
245: app_exception.raise_exception;
246: END IF;
247: CLOSE c;
248:
250: AND (recinfo.ORG_ID = X_ORG_ID)
251: ) THEN
252: NULL;
253: ELSE
254: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
255: app_exception.raise_exception;
256: END IF;
257: */
258:
270: (X_PROD_CAT_SET_ID is null)))
271: ) THEN
272: NULL;
273: ELSE
274: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
275: app_exception.raise_exception;
276: END IF;
277:
278: FOR tlinfo IN c1 LOOP
282: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
283: ) THEN
284: NULL;
285: ELSE
286: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
287: app_exception.raise_exception;
288: END IF;
289: END IF;
290: END LOOP;