APPS.IGF_SP_STDNT_REL_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 105: app_exception.raise_exception;

101: )
102: ) THEN
103: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
108: END check_uniqueness;
109:

Line 135: app_exception.raise_exception;

131: new_references.ld_sequence_number
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
138: IF (((old_references.base_id = new_references.base_id)) OR
139: ((new_references.base_id IS NULL))) THEN

Line 146: app_exception.raise_exception;

142: new_references.base_id
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.fund_id = new_references.fund_id)) OR
150: ((new_references.fund_id IS NULL))) THEN

Line 157: app_exception.raise_exception;

153: new_references.fund_id
154: ) THEN
155: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
156: igs_ge_msg_stack.add;
157: app_exception.raise_exception;
158: END IF;
159:
160: END check_parent_existance;
161:

Line 285: app_exception.raise_exception;

281: IF (cur_rowid%FOUND) THEN
282: CLOSE cur_rowid;
283: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_HZ_FK');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: RETURN;
287: END IF;
288: CLOSE cur_rowid;
289:

Line 322: app_exception.raise_exception;

318: IF (cur_rowid%FOUND) THEN
319: CLOSE cur_rowid;
320: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_CA_FK');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: RETURN;
324: END IF;
325: CLOSE cur_rowid;
326:

Line 357: app_exception.raise_exception;

353: IF (cur_rowid%FOUND) THEN
354: CLOSE cur_rowid;
355: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_FA_DETAIL_FK');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: RETURN;
359: END IF;
360: CLOSE cur_rowid;
361:

Line 392: app_exception.raise_exception;

388: IF (cur_rowid%FOUND) THEN
389: CLOSE cur_rowid;
390: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_FMAST_FK');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: RETURN;
394: END IF;
395: CLOSE cur_rowid;
396:

Line 458: app_exception.raise_exception;

454: )
455: ) THEN
456: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: END IF;
460: check_uniqueness;
461: check_parent_existance;
462: ELSIF (p_action = 'UPDATE') THEN

Line 477: app_exception.raise_exception;

473: )
474: ) THEN
475: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
476: igs_ge_msg_stack.add;
477: app_exception.raise_exception;
478: END IF;
479: check_uniqueness;
480: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
481: check_uniqueness;

Line 538: app_exception.raise_exception;

534: END IF;
535: ELSE
536: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540:
541: SELECT igf_sp_stdnt_rel_s.NEXTVAL
542: INTO x_spnsr_stdnt_id

Line 656: app_exception.raise_exception;

652: IF (c1%notfound) THEN
653: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
654: igs_ge_msg_stack.add;
655: CLOSE c1;
656: app_exception.raise_exception;
657: RETURN;
658: END IF;
659: CLOSE c1;
660:

Line 675: app_exception.raise_exception;

671: NULL;
672: ELSE
673: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
674: igs_ge_msg_stack.add;
675: app_exception.raise_exception;
676: END IF;
677:
678: RETURN;
679:

Line 727: app_exception.raise_exception;

723: END IF;
724: ELSE
725: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
726: igs_ge_msg_stack.add;
727: app_exception.raise_exception;
728: END IF;
729:
730: before_dml(
731: p_action => 'UPDATE',