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;
165: IF ( get_pk_for_validation(
166: new_references.curriculum_id
167: )
168: ) THEN
169: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: END IF;
173: ELSIF (p_action = 'DELETE') THEN
178: IF ( get_pk_for_validation (
179: new_references.curriculum_id
180: )
181: ) THEN
182: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: END IF;
186: ELSIF (p_action = 'VALIDATE_DELETE') THEN
230: IF (x_last_update_login IS NULL) THEN
231: x_last_update_login := -1;
232: END IF;
233: ELSE
234: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238:
320:
321: OPEN c1;
322: FETCH c1 INTO tlinfo;
323: IF (c1%notfound) THEN
324: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
325: igs_ge_msg_stack.add;
326: CLOSE c1;
327: app_exception.raise_exception;
328: RETURN;
334: AND (tlinfo.closed_ind = x_closed_ind)
335: ) THEN
336: NULL;
337: ELSE
338: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
339: igs_ge_msg_stack.add;
340: app_exception.raise_exception;
341: END IF;
342:
380: IF (x_last_update_login IS NULL) THEN
381: x_last_update_login := -1;
382: END IF;
383: ELSE
384: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388: