47: OPEN cur_old_ref_values;
48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
103: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
104: new_references.ci_cal_type,
105: new_references.ci_sequence_number
106: ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
206: OPEN cur_rowid;
207: FETCH cur_rowid INTO lv_rowid;
208: IF (cur_rowid%FOUND) THEN
209: CLOSE cur_rowid;
210: fnd_message.set_name ('IGF', 'IGF_AW_COAG_CI_FK');
211: igs_ge_msg_stack.add;
212: app_exception.raise_exception;
213: RETURN;
214: END IF;
274: new_references.ci_cal_type,
275: new_references.ci_sequence_number
276: )
277: ) THEN
278: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
279: igs_ge_msg_stack.add;
280: app_exception.raise_exception;
281: END IF;
282: check_parent_existance;
293: new_references.ci_cal_type,
294: new_references.ci_sequence_number
295: )
296: ) THEN
297: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
298: igs_ge_msg_stack.add;
299: app_exception.raise_exception;
300: END IF;
301: ELSIF (p_action = 'VALIDATE_DELETE') THEN
358: IF (x_last_update_login IS NULL) THEN
359: x_last_update_login := -1;
360: END IF;
361: ELSE
362: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
363: igs_ge_msg_stack.add;
364: app_exception.raise_exception;
365: END IF;
366:
453:
454: OPEN c1;
455: FETCH c1 INTO tlinfo;
456: IF (c1%notfound) THEN
457: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
458: igs_ge_msg_stack.add;
459: CLOSE c1;
460: app_exception.raise_exception;
461: RETURN;
466: ((tlinfo.coa_grp_desc = x_coa_grp_desc) OR ((tlinfo.coa_grp_desc IS NULL) AND (x_coa_grp_desc IS NULL)))
467: ) THEN
468: NULL;
469: ELSE
470: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
471: igs_ge_msg_stack.add;
472: app_exception.raise_exception;
473: END IF;
474:
520: IF (x_last_update_login IS NULL) THEN
521: x_last_update_login := -1;
522: END IF;
523: ELSE
524: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
525: igs_ge_msg_stack.add;
526: app_exception.raise_exception;
527: END IF;
528: