APPS.IGF_SP_PRG_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
54:

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;
102:

Line 124: app_exception.raise_exception;

120: new_references.fee_cls_id
121: ) THEN
122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126:
127: IF (((old_references.course_cd = new_references.course_cd) AND
128: (old_references.version_number = new_references.version_number)) OR

Line 138: app_exception.raise_exception;

134: new_references.version_number
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:
141: END check_parent_existance;
142:

Line 264: app_exception.raise_exception;

260: IF (cur_rowid%FOUND) THEN
261: CLOSE cur_rowid;
262: fnd_message.set_name ('IGF', 'IGF_SP_SFCLP_SFCL_FK');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: RETURN;
266: END IF;
267: CLOSE cur_rowid;
268:

Line 300: app_exception.raise_exception;

296: IF (cur_rowid%FOUND) THEN
297: CLOSE cur_rowid;
298: fnd_message.set_name ('IGF', 'IGF_SP_SFCLP_CRV_FK');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: RETURN;
302: END IF;
303: CLOSE cur_rowid;
304:

Line 360: app_exception.raise_exception;

356: )
357: ) THEN
358: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
359: igs_ge_msg_stack.add;
360: app_exception.raise_exception;
361: END IF;
362: check_uniqueness;
363: check_parent_existance;
364: ELSIF (p_action = 'UPDATE') THEN

Line 379: app_exception.raise_exception;

375: )
376: ) THEN
377: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
378: igs_ge_msg_stack.add;
379: app_exception.raise_exception;
380: END IF;
381: check_uniqueness;
382: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
383: check_uniqueness;

Line 437: app_exception.raise_exception;

433: END IF;
434: ELSE
435: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: END IF;
439:
440: SELECT igf_sp_prg_s.NEXTVAL
441: INTO x_fee_cls_prg_id

Line 540: app_exception.raise_exception;

536: IF (c1%notfound) THEN
537: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
538: igs_ge_msg_stack.add;
539: CLOSE c1;
540: app_exception.raise_exception;
541: RETURN;
542: END IF;
543: CLOSE c1;
544:

Line 556: app_exception.raise_exception;

552: NULL;
553: ELSE
554: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
555: igs_ge_msg_stack.add;
556: app_exception.raise_exception;
557: END IF;
558:
559: RETURN;
560:

Line 605: app_exception.raise_exception;

601: END IF;
602: ELSE
603: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
604: igs_ge_msg_stack.add;
605: app_exception.raise_exception;
606: END IF;
607:
608: before_dml(
609: p_action => 'UPDATE',