45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
159: new_references.dbpays_id
160: )
161: ) THEN
162: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: END IF;
166: ELSIF (p_action = 'VALIDATE_INSERT') THEN
167: -- Call all the procedures related to Before Insert.
169: new_references.dbpays_id
170: )
171: ) THEN
172: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: END IF;
176: END IF;
177:
222: x_last_update_login := -1;
223: END IF;
224: ELSE
225: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229:
230: SELECT igf_db_pays_prg_t_s.NEXTVAL
320: OPEN c1;
321: FETCH c1 INTO tlinfo;
322: IF (c1%notfound) THEN
323: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
324: igs_ge_msg_stack.add;
325: CLOSE c1;
326: app_exception.raise_exception;
327: RETURN;
328: END IF;
337: ) THEN
338: NULL;
339: ELSE
340: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344:
345: RETURN;
386: x_last_update_login := -1;
387: END IF;
388: ELSE
389: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: END IF;
393:
394: before_dml(