DBA Data[Home] [Help]

APPS.IGS_EN_SPAA_HIST_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 114: app_exception.raise_exception;

110: x_award_cd => new_references.award_cd
111: ) THEN
112: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
113: igs_ge_msg_stack.add;
114: app_exception.raise_exception;
115: END IF;
116:
117: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND
118: (old_references.gs_version_number = new_references.gs_version_number)) OR

Line 128: app_exception.raise_exception;

124: new_references.gs_version_number
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: END check_parent_existance;
132:

Line 203: app_exception.raise_exception;

199: IF (cur_rowid%FOUND) THEN
200: CLOSE cur_rowid;
201: fnd_message.set_name ('IGS', 'IGS_GR_SPAAH_AGS_FK');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204: RETURN;
205: END IF;
206: CLOSE cur_rowid;
207:

Line 275: app_exception.raise_exception;

271: )
272: ) THEN
273: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
274: igs_ge_msg_stack.add;
275: app_exception.raise_exception;
276: END IF;
277: check_parent_existance;
278: ELSIF (p_action = 'UPDATE') THEN
279: -- Call all the procedures related to Before Update.

Line 292: app_exception.raise_exception;

288: )
289: ) THEN
290: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: END IF;
294: END IF;
295:
296: IF (p_action IN ('VALIDATE_INSERT', 'VALIDATE_UPDATE', 'VALIDATE_DELETE')) THEN

Line 351: app_exception.raise_exception;

347: ELSE
348: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
349: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPAA_HIST_PKG.INSERT_ROW');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END IF;
353:
354: before_dml(
355: p_action => 'INSERT',

Line 463: app_exception.raise_exception;

459: IF (c1%notfound) THEN
460: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
461: igs_ge_msg_stack.add;
462: CLOSE c1;
463: app_exception.raise_exception;
464: RETURN;
465: END IF;
466: CLOSE c1;
467:

Line 482: app_exception.raise_exception;

478: NULL;
479: ELSE
480: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
481: igs_ge_msg_stack.add;
482: app_exception.raise_exception;
483: END IF;
484:
485: RETURN;
486:

Line 537: app_exception.raise_exception;

533: ELSE
534: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
535: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPAA_HIST_PKG.UPDATE_ROW');
536: igs_ge_msg_stack.add;
537: app_exception.raise_exception;
538: END IF;
539:
540: before_dml(
541: p_action => 'UPDATE',