97: OPEN cur_old_ref_values;
98: FETCH cur_old_ref_values INTO old_references;
99: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
100: CLOSE cur_old_ref_values;
101: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: RETURN;
105: END IF;
269: new_references.process_id,
270: new_references.sl_number
271: )
272: ) THEN
273: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
274: igs_ge_msg_stack.add;
275: app_exception.raise_exception;
276: END IF;
277: ELSIF (p_action = 'VALIDATE_INSERT') THEN
280: new_references.process_id,
281: new_references.sl_number
282: )
283: ) THEN
284: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288: END IF;
372: ELSE
373: x_program_update_date := SYSDATE;
374: END IF;
375: ELSE
376: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380:
567:
568: OPEN c1;
569: FETCH c1 INTO tlinfo;
570: IF (c1%notfound) THEN
571: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
572: igs_ge_msg_stack.add;
573: CLOSE c1;
574: app_exception.raise_exception;
575: RETURN;
601: AND ((tlinfo.temp_char3_txt = x_temp_char3_txt) OR ((tlinfo.temp_char3_txt IS NULL) AND (x_temp_char3_txt IS NULL)))
602: ) THEN
603: NULL;
604: ELSE
605: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
606: igs_ge_msg_stack.add;
607: app_exception.raise_exception;
608: END IF;
609:
675: IF (x_last_update_login IS NULL) THEN
676: x_last_update_login := -1;
677: END IF;
678: ELSE
679: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
680: igs_ge_msg_stack.add;
681: app_exception.raise_exception;
682: END IF;
683: before_dml(