[Home] [Help]
49: OPEN cur_old_ref_values;
50: FETCH cur_old_ref_values INTO old_references;
51: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
52: CLOSE cur_old_ref_values;
53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: RETURN;
57: END IF;
111: END IF;
112:
113: IF (UPPER(column_name) = 'DENSE_RANK_IND' OR column_name IS NULL) THEN
114: IF NOT (new_references.dense_rank_ind IN ('Y','N')) THEN
115: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119: END IF;
119: END IF;
120:
121: IF (UPPER(column_name) = 'INCL_ON_TRANSCRIPT_IND' OR column_name IS NULL) THEN
122: IF NOT (new_references.incl_on_transcript_ind IN ('Y','N')) THEN
123: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
124: igs_ge_msg_stack.add;
125: app_exception.raise_exception;
126: END IF;
127: END IF;
127: END IF;
128:
129: IF (UPPER(column_name) = 'INCL_ON_STUD_ACAD_HIST_IND' OR column_name IS NULL) THEN
130: IF NOT (new_references.incl_on_stud_acad_hist_ind IN ('Y','N')) THEN
131: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135: END IF;
154: NULL;
155: ELSIF NOT igs_pr_stat_type_pkg.get_pk_for_validation (
156: new_references.stat_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:
165: NULL;
166: ELSIF NOT igs_ru_rule_pkg.get_pk_for_validation (
167: new_references.rule_sequence_number
168: ) THEN
169: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: END IF;
173:
251: OPEN cur_rowid;
252: FETCH cur_rowid INTO lv_rowid;
253: IF (cur_rowid%FOUND) THEN
254: CLOSE cur_rowid;
255: fnd_message.set_name ('IGS', 'IGS_PR_COH_STAT_FK');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: RETURN;
259: END IF;
286: OPEN cur_rowid;
287: FETCH cur_rowid INTO lv_rowid;
288: IF (cur_rowid%FOUND) THEN
289: CLOSE cur_rowid;
290: fnd_message.set_name ('IGS', 'IGS_PR_COH_RU_FK');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: RETURN;
294: END IF;
355: IF ( get_pk_for_validation(
356: new_references.cohort_name
357: )
358: ) THEN
359: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
360: igs_ge_msg_stack.add;
361: app_exception.raise_exception;
362: END IF;
363: check_constraints;
374: IF ( get_pk_for_validation (
375: new_references.cohort_name
376: )
377: ) THEN
378: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
379: igs_ge_msg_stack.add;
380: app_exception.raise_exception;
381: END IF;
382: check_constraints;
433: IF (x_last_update_login IS NULL) THEN
434: x_last_update_login := -1;
435: END IF;
436: ELSE
437: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
438: igs_ge_msg_stack.add;
439: app_exception.raise_exception;
440: END IF;
441:
544:
545: OPEN c1;
546: FETCH c1 INTO tlinfo;
547: IF (c1%notfound) THEN
548: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
549: igs_ge_msg_stack.add;
550: CLOSE c1;
551: app_exception.raise_exception;
552: RETURN;
566: AND (tlinfo.closed_ind = x_closed_ind)
567: ) THEN
568: NULL;
569: ELSE
570: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
571: igs_ge_msg_stack.add;
572: app_exception.raise_exception;
573: END IF;
574:
620: IF (x_last_update_login IS NULL) THEN
621: x_last_update_login := -1;
622: END IF;
623: ELSE
624: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
625: igs_ge_msg_stack.add;
626: app_exception.raise_exception;
627: END IF;
628: