APPS.IGS_PR_COHORT_PKG dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

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

Line 117: app_exception.raise_exception;

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:
121: IF (UPPER(column_name) = 'INCL_ON_TRANSCRIPT_IND' OR column_name IS NULL) THEN

Line 125: app_exception.raise_exception;

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:
129: IF (UPPER(column_name) = 'INCL_ON_STUD_ACAD_HIST_IND' OR column_name IS NULL) THEN

Line 133: app_exception.raise_exception;

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:
137: END check_constraints;

Line 160: app_exception.raise_exception;

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
164: ((new_references.rule_sequence_number IS NULL))) THEN

Line 171: app_exception.raise_exception;

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

Line 257: app_exception.raise_exception;

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

Line 292: app_exception.raise_exception;

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

Line 361: app_exception.raise_exception;

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

Line 380: app_exception.raise_exception;

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
384: check_constraints;

Line 439: app_exception.raise_exception;

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(
443: p_action => 'INSERT',

Line 551: app_exception.raise_exception;

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;
554: CLOSE c1;
555:

Line 572: app_exception.raise_exception;

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

Line 626: app_exception.raise_exception;

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(
630: p_action => 'UPDATE',