163: OPEN c;
164: FETCH c INTO recinfo;
165: IF (c%NOTFOUND) THEN
166: CLOSE c;
167: fnd_message.set_name('fnd', 'form_record_deleted');
168: app_exception.raise_exception;
169: END IF;
170: CLOSE c;
171: IF ( (recinfo.data_type_code = p_data_type_code)
183:
184: ) THEN
185: NULL;
186: ELSE
187: fnd_message.set_name('fnd', 'form_record_changed');
188: app_exception.raise_exception;
189: END IF;
190:
191: FOR tlinfo IN c1 LOOP
195: OR ((tlinfo.description IS NULL) AND (p_description IS NULL)))
196: ) THEN
197: NULL;
198: ELSE
199: fnd_message.set_name('fnd', 'form_record_changed');
200: app_exception.raise_exception;
201: END IF;
202: END IF;
203: END LOOP;
748: OPEN c;
749: FETCH c INTO recinfo;
750: IF (c%NOTFOUND) THEN
751: CLOSE c;
752: Fnd_Message.set_name('FND', 'FORM_RECORD_DELETED');
753: App_Exception.raise_exception;
754: END IF;
755: CLOSE c;
756: IF ( (recinfo.MIN_INSTANCES = X_MIN_INSTANCES)
773: OR ((recinfo.DATA_LENGTH IS NULL) AND (X_DATA_LENGTH IS NULL)))
774: ) THEN
775: NULL;
776: ELSE
777: Fnd_Message.set_name('FND', 'FORM_RECORD_CHANGED');
778: App_Exception.raise_exception;
779: END IF;
780:
781: FOR tlinfo IN c1 LOOP
785: OR ((tlinfo.DESCRIPTION IS NULL) AND (X_DESCRIPTION IS NULL)))
786: ) THEN
787: NULL;
788: ELSE
789: Fnd_Message.set_name('FND', 'FORM_RECORD_CHANGED');
790: App_Exception.raise_exception;
791: END IF;
792: END IF;
793: END LOOP;