45: OPEN cur_old_ref_values;
46: FETCH cur_old_ref_values INTO old_references;
47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
96: new_references.cost_centre,
97: new_references.subject
98: )
99: ) THEN
100: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:
128: new_references.course_cd,
129: new_references.version_number,
130: new_references.org_unit_cd
131: ) THEN
132: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
133: igs_ge_msg_stack.add;
134: app_exception.raise_exception;
135: END IF;
136:
243: OPEN cur_rowid;
244: FETCH cur_rowid INTO lv_rowid;
245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGS', 'IGS_HE_CC_OU_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;
304: IF ( get_pk_for_validation(
305: new_references.hesa_prog_cc_id
306: )
307: ) THEN
308: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
309: igs_ge_msg_stack.add;
310: app_exception.raise_exception;
311: END IF;
312: check_uniqueness;
320: IF ( get_pk_for_validation (
321: new_references.hesa_prog_cc_id
322: )
323: ) THEN
324: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
325: igs_ge_msg_stack.add;
326: app_exception.raise_exception;
327: END IF;
328: check_uniqueness;
373: IF (x_last_update_login IS NULL) THEN
374: x_last_update_login := -1;
375: END IF;
376: ELSE
377: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
378: fnd_message.set_token ('ROUTINE', 'IGS_HE_PROG_OU_CC_PKG.INSERT_ROW');
379: igs_ge_msg_stack.add;
380: app_exception.raise_exception;
381: END IF;
374: x_last_update_login := -1;
375: END IF;
376: ELSE
377: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
378: fnd_message.set_token ('ROUTINE', 'IGS_HE_PROG_OU_CC_PKG.INSERT_ROW');
379: igs_ge_msg_stack.add;
380: app_exception.raise_exception;
381: END IF;
382:
467:
468: OPEN c1;
469: FETCH c1 INTO tlinfo;
470: IF (c1%notfound) THEN
471: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
472: igs_ge_msg_stack.add;
473: CLOSE c1;
474: app_exception.raise_exception;
475: RETURN;
485: AND (tlinfo.proportion = x_proportion)
486: ) THEN
487: NULL;
488: ELSE
489: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493:
535: IF (x_last_update_login IS NULL) THEN
536: x_last_update_login := -1;
537: END IF;
538: ELSE
539: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
540: fnd_message.set_token ('ROUTINE', 'IGS_HE_PROG_OU_CC_PKG.UPDATE_ROW');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
536: x_last_update_login := -1;
537: END IF;
538: ELSE
539: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
540: fnd_message.set_token ('ROUTINE', 'IGS_HE_PROG_OU_CC_PKG.UPDATE_ROW');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544: