42: OPEN cur_old_ref_values;
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
89: new_references.ci_sequence_number,
90: new_references.org_id
91: )
92: ) THEN
93: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
118: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
119: new_references.cal_type,
120: new_references.ci_sequence_number
121: ) THEN
122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
126: new_references.person_id
124: app_exception.raise_exception;
125: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
126: new_references.person_id
127: ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132:
256: OPEN cur_rowid;
257: FETCH cur_rowid INTO lv_rowid;
258: IF (cur_rowid%FOUND) THEN
259: CLOSE cur_rowid;
260: fnd_message.set_name ('IGS', 'IGS_EN_EOA_CI_FK');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: RETURN;
264: END IF;
290: OPEN cur_rowid;
291: FETCH cur_rowid INTO lv_rowid;
292: IF (cur_rowid%FOUND) THEN
293: CLOSE cur_rowid;
294: fnd_message.set_name ('IGS', 'IGS_EN_EOA_PE_FK');
295: igs_ge_msg_stack.add;
296: app_exception.raise_exception;
297: RETURN;
298: END IF;
345: IF ( get_pk_for_validation(
346: new_references.elgb_override_id
347: )
348: ) THEN
349: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END IF;
353: check_uniqueness;
364: IF ( get_pk_for_validation (
365: new_references.elgb_override_id
366: )
367: ) THEN
368: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: END IF;
372: check_uniqueness;
436: ELSE
437: x_program_update_date := SYSDATE;
438: END IF;
439: ELSE
440: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:
536:
537: OPEN c1;
538: FETCH c1 INTO tlinfo;
539: IF (c1%notfound) THEN
540: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
541: igs_ge_msg_stack.add;
542: CLOSE c1;
543: app_exception.raise_exception;
544: RETURN;
551: AND (tlinfo.ci_sequence_number = x_ci_sequence_number)
552: ) THEN
553: NULL;
554: ELSE
555: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
556: igs_ge_msg_stack.add;
557: app_exception.raise_exception;
558: END IF;
559:
602: IF (x_last_update_login IS NULL) THEN
603: x_last_update_login := -1;
604: END IF;
605: ELSE
606: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610: