APPS.IGS_PR_COHORT_PKG dependencies on IGS_GE_MSG_STACK

Line 54: igs_ge_msg_stack.add;

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;
58: CLOSE cur_old_ref_values;

Line 116: igs_ge_msg_stack.add;

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;
120:

Line 124: igs_ge_msg_stack.add;

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;
128:

Line 132: igs_ge_msg_stack.add;

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;
136:

Line 159: igs_ge_msg_stack.add;

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:
163: IF (((old_references.rule_sequence_number = new_references.rule_sequence_number)) OR

Line 170: igs_ge_msg_stack.add;

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:
174: END check_parent_existance;

Line 256: igs_ge_msg_stack.add;

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;
260: CLOSE cur_rowid;

Line 291: igs_ge_msg_stack.add;

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;
295: CLOSE cur_rowid;

Line 360: igs_ge_msg_stack.add;

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;
364: check_parent_existance;

Line 379: igs_ge_msg_stack.add;

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;
383: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 438: igs_ge_msg_stack.add;

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:
442: before_dml(

Line 549: igs_ge_msg_stack.add;

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;
553: END IF;

Line 571: igs_ge_msg_stack.add;

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:
575: RETURN;

Line 625: igs_ge_msg_stack.add;

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:
629: before_dml(