53: OPEN cur_old_ref_values;
54: FETCH cur_old_ref_values INTO old_references;
55: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
56: CLOSE cur_old_ref_values;
57: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
58: igs_ge_msg_stack.add;
59: app_exception.raise_exception;
60: RETURN;
61: END IF;
110: NULL;
111: ELSIF NOT igs_pe_person_id_typ_pkg.get_pk_for_validation (
112: new_references.default_student_id_type
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
121: NULL;
122: ELSIF NOT igs_en_unit_set_cat_pkg.get_pk_for_validation (
123: new_references.wif_major_unit_set_cat
124: ) THEN
125: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:
132: NULL;
133: ELSIF NOT igs_en_unit_set_cat_pkg.get_pk_for_validation (
134: new_references.wif_minor_unit_set_cat
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:
143: NULL;
144: ELSIF NOT igs_en_unit_set_cat_pkg.get_pk_for_validation (
145: new_references.wif_track_unit_set_cat
146: ) THEN
147: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151:
154: NULL;
155: ELSIF NOT igs_or_org_alt_idtyp_pkg.get_pk_for_validation (
156: new_references.default_inst_id_type
157: ) THEN
158: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162:
223: OPEN cur_rowid;
224: FETCH cur_rowid INTO lv_rowid;
225: IF (cur_rowid%FOUND) THEN
226: CLOSE cur_rowid;
227: fnd_message.set_name ('IGS', 'IGS_DA_SET_EUS_FK');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: RETURN;
231: END IF;
258: OPEN cur_rowid;
259: FETCH cur_rowid INTO lv_rowid;
260: IF (cur_rowid%FOUND) THEN
261: CLOSE cur_rowid;
262: fnd_message.set_name ('IGS', 'IGS_DA_SET_OAIT_FK');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: RETURN;
266: END IF;
335: IF ( get_pk_for_validation(
336: new_references.s_control_num
337: )
338: ) THEN
339: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
340: igs_ge_msg_stack.add;
341: app_exception.raise_exception;
342: END IF;
343: check_parent_existance;
349: IF ( get_pk_for_validation (
350: new_references.s_control_num
351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357: END IF;
407: IF (x_last_update_login IS NULL) THEN
408: x_last_update_login := -1;
409: END IF;
410: ELSE
411: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
412: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.INSERT_ROW');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
408: x_last_update_login := -1;
409: END IF;
410: ELSE
411: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
412: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.INSERT_ROW');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416:
539:
540: OPEN c1;
541: FETCH c1 INTO tlinfo;
542: IF (c1%notfound) THEN
543: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
544: igs_ge_msg_stack.add;
545: CLOSE c1;
546: app_exception.raise_exception;
547: RETURN;
565: AND ((tlinfo.link_url = x_link_url) OR ((tlinfo.link_url IS NULL) AND (X_link_url IS NULL)))
566: ) THEN
567: NULL;
568: ELSE
569: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:
623: IF (x_last_update_login IS NULL) THEN
624: x_last_update_login := -1;
625: END IF;
626: ELSE
627: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
628: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.UPDATE_ROW');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: END IF;
624: x_last_update_login := -1;
625: END IF;
626: ELSE
627: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
628: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.UPDATE_ROW');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: END IF;
632: