DBA Data[Home] [Help]

APPS.IGS_AS_STU_TRN_CMTS_PKG dependencies on APP_EXCEPTION

Line 56: app_exception.raise_exception;

52: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
53: CLOSE cur_old_ref_values;
54: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
55: igs_ge_msg_stack.add;
56: app_exception.raise_exception;
57: RETURN;
58: END IF;
59: CLOSE cur_old_ref_values;
60:

Line 117: app_exception.raise_exception;

113: )
114: ) THEN
115: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: END check_uniqueness;
121:

Line 146: app_exception.raise_exception;

142: new_references.load_ci_sequence_number
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: END IF;
148:
149: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND
150: (old_references.us_version_number = new_references.us_version_number)) OR

Line 160: app_exception.raise_exception;

156: new_references.us_version_number
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.award_cd = new_references.award_cd)) OR
164: ((new_references.award_cd IS NULL))) THEN

Line 171: app_exception.raise_exception;

167: new_references.award_cd
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: IF (((old_references.course_type = new_references.course_type)) OR
175: ((new_references.course_type IS NULL))) THEN

Line 182: app_exception.raise_exception;

178: new_references.course_type
179: ) THEN
180: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184:
185: IF (((old_references.uoo_id = new_references.uoo_id)) OR
186: ((new_references.uoo_id IS NULL))) THEN

Line 193: app_exception.raise_exception;

189: new_references.uoo_id
190: ) THEN
191: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: END IF;
195:
196: IF (((old_references.person_id = new_references.person_id) AND
197: (old_references.course_cd = new_references.course_cd)) OR

Line 207: app_exception.raise_exception;

203: new_references.course_cd
204: ) THEN
205: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: END IF;
209:
210: END check_parent_existance;
211:

Line 330: app_exception.raise_exception;

326: IF (cur_rowid%FOUND) THEN
327: CLOSE cur_rowid;
328: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: RETURN;
332: END IF;
333: CLOSE cur_rowid;
334:

Line 367: app_exception.raise_exception;

363: IF (cur_rowid%FOUND) THEN
364: CLOSE cur_rowid;
365: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: RETURN;
369: END IF;
370: CLOSE cur_rowid;
371:

Line 402: app_exception.raise_exception;

398: IF (cur_rowid%FOUND) THEN
399: CLOSE cur_rowid;
400: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
401: igs_ge_msg_stack.add;
402: app_exception.raise_exception;
403: RETURN;
404: END IF;
405: CLOSE cur_rowid;
406:

Line 437: app_exception.raise_exception;

433: IF (cur_rowid%FOUND) THEN
434: CLOSE cur_rowid;
435: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: RETURN;
439: END IF;
440: CLOSE cur_rowid;
441:

Line 472: app_exception.raise_exception;

468: IF (cur_rowid%FOUND) THEN
469: CLOSE cur_rowid;
470: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
471: igs_ge_msg_stack.add;
472: app_exception.raise_exception;
473: RETURN;
474: END IF;
475: CLOSE cur_rowid;
476:

Line 509: app_exception.raise_exception;

505: IF (cur_rowid%FOUND) THEN
506: CLOSE cur_rowid;
507: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510: RETURN;
511: END IF;
512: CLOSE cur_rowid;
513:

Line 580: app_exception.raise_exception;

576: )
577: ) THEN
578: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
579: igs_ge_msg_stack.add;
580: app_exception.raise_exception;
581: END IF;
582: check_uniqueness;
583: check_parent_existance;
584: ELSIF (p_action = 'UPDATE') THEN

Line 596: app_exception.raise_exception;

592: )
593: ) THEN
594: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
595: igs_ge_msg_stack.add;
596: app_exception.raise_exception;
597: END IF;
598: check_uniqueness;
599: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
600: check_uniqueness;

Line 659: app_exception.raise_exception;

655: ELSE
656: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
657: fnd_message.set_token ('ROUTINE', 'IGS_AS_STU_TRN_CMTS_PKG.INSERT_ROW');
658: igs_ge_msg_stack.add;
659: app_exception.raise_exception;
660: END IF;
661:
662: x_comment_id := NULL;
663:

Line 780: app_exception.raise_exception;

776: IF (c1%notfound) THEN
777: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
778: igs_ge_msg_stack.add;
779: CLOSE c1;
780: app_exception.raise_exception;
781: RETURN;
782: END IF;
783: CLOSE c1;
784:

Line 802: app_exception.raise_exception;

798: NULL;
799: ELSE
800: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
801: igs_ge_msg_stack.add;
802: app_exception.raise_exception;
803: END IF;
804:
805: RETURN;
806:

Line 858: app_exception.raise_exception;

854: ELSE
855: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
856: fnd_message.set_token ('ROUTINE', 'IGS_AS_STU_TRN_CMTS_PKG.UPDATE_ROW');
857: igs_ge_msg_stack.add;
858: app_exception.raise_exception;
859: END IF;
860:
861: before_dml(
862: p_action => 'UPDATE',