[Home] [Help]
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;
105: -- The following code checks for check constraints on the Columns.
106: IF UPPER(column_name) = 'ASSIGN_RANDOMLY' OR
107: column_name IS NULL THEN
108: IF NOT (new_references.assign_randomly IN ('Y','N')) THEN
109: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113: END IF;
133: ,new_references.cal_type
134: ,new_references.sequence_number
135: ,new_references.student_type
136: ) THEN
137: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141: END check_uniqueness ;
161: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
162: new_references.cal_type,
163: new_references.sequence_number
164: ) THEN
165: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169:
172: NULL;
173: ELSIF NOT igs_ps_type_grp_pkg.get_pk_for_validation (
174: new_references.program_type_group_cd
175: ) THEN
176: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
177: igs_ge_msg_stack.add;
178: app_exception.raise_exception;
179: END IF;
180:
306: OPEN cur_rowid;
307: FETCH cur_rowid INTO lv_rowid;
308: IF (cur_rowid%FOUND) THEN
309: CLOSE cur_rowid;
310: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: RETURN;
314: END IF;
343: OPEN cur_rowid;
344: FETCH cur_rowid INTO lv_rowid;
345: IF (cur_rowid%FOUND) THEN
346: CLOSE cur_rowid;
347: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: RETURN;
351: END IF;
406: -- Call all the procedures related to Before Insert.
407: Null;
408: IF get_pk_for_validation(
409: new_references.igs_en_timeslot_stup_id) THEN
410: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414: check_uniqueness;
427: ELSIF (p_action = 'VALIDATE_INSERT') THEN
428: -- Call all the procedures related to Before Insert.
429: IF get_pk_for_validation (
430: new_references.igs_en_timeslot_stup_id) THEN
431: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435: check_uniqueness;
521: IF x_last_update_login IS NULL THEN
522: x_last_update_login := -1;
523: END IF;
524: ELSE
525: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: end if;
529:
618: BEGIN
619: OPEN c1;
620: FETCH c1 INTO tlinfo;
621: IF (c1%notfound) THEN
622: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
623: igs_ge_msg_stack.add;
624: CLOSE c1;
625: app_exception.raise_exception;
626: RETURN;
636: AND (tlinfo.PROGRAM_TYPE_GROUP_CD = X_PROGRAM_TYPE_GROUP_CD)
637: ) THEN
638: NULL;
639: ELSE
640: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644: RETURN;
682: IF x_last_update_login IS NULL THEN
683: x_last_update_login := -1;
684: END IF;
685: ELSE
686: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
687: igs_ge_msg_stack.add;
688: app_exception.raise_exception;
689: END IF;
690: before_dml(