41: OPEN cur_old_ref_values;
42: FETCH cur_old_ref_values INTO old_references;
43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
152: new_references.s_job_name,
153: new_references.output_num
154: )
155: ) THEN
156: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160: ELSIF (p_action = 'VALIDATE_INSERT') THEN
164: new_references.s_job_name,
165: new_references.output_num
166: )
167: ) THEN
168: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: END IF;
172: END IF;
216: IF (x_last_update_login IS NULL) THEN
217: x_last_update_login := -1;
218: END IF;
219: ELSE
220: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
221: igs_ge_msg_stack.add;
222: app_exception.raise_exception;
223: END IF;
224:
294:
295: OPEN c1;
296: FETCH c1 INTO tlinfo;
297: IF (c1%notfound) THEN
298: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
299: igs_ge_msg_stack.add;
300: CLOSE c1;
301: app_exception.raise_exception;
302: RETURN;