APPS.IGS_AS_USEC_SESSNS_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 206: app_exception.raise_exception;

202: )
203: ) THEN
204: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
205: igs_ge_msg_stack.add;
206: app_exception.raise_exception;
207: END IF;
208: check_parent_existance;
209: ELSIF (p_action = 'VALIDATE_INSERT') THEN
210: -- Call all the procedures related to Before Insert.

Line 218: app_exception.raise_exception;

214: )
215: ) THEN
216: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
217: igs_ge_msg_stack.add;
218: app_exception.raise_exception;
219: END IF;
220:
221: ELSIF (p_action='UPDATE') THEN
222: check_parent_existance;

Line 276: app_exception.raise_exception;

272: ELSE
273: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
274: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.INSERT_ROW');
275: igs_ge_msg_stack.add;
276: app_exception.raise_exception;
277: END IF;
278:
279: before_dml(
280: p_action => 'INSERT',

Line 407: app_exception.raise_exception;

403: IF (c1%notfound) THEN
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: igs_ge_msg_stack.add;
406: CLOSE c1;
407: app_exception.raise_exception;
408: RETURN;
409: END IF;
410: CLOSE c1;
411:

Line 423: app_exception.raise_exception;

419: NULL;
420: ELSE
421: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
422: igs_ge_msg_stack.add;
423: app_exception.raise_exception;
424: END IF;
425:
426: -- Initialize API return status to success.
427: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 511: app_exception.raise_exception;

507: ELSE
508: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
509: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.UPDATE_ROW');
510: igs_ge_msg_stack.add;
511: app_exception.raise_exception;
512: END IF;
513:
514: before_dml(
515: p_action => 'UPDATE',

Line 818: APP_EXCEPTION.RAISE_EXCEPTION;

814: IF (cur_rowid%FOUND) THEN
815: Fnd_Message.Set_Name ('IGS', 'IGS_AS_USEC_ATT_OCCURS_FK');
816: IGS_GE_MSG_STACK.ADD;
817: CLOSE cur_rowid;
818: APP_EXCEPTION.RAISE_EXCEPTION;
819: RETURN;
820: END IF;
821: CLOSE cur_rowid;
822:

Line 853: APP_EXCEPTION.RAISE_EXCEPTION;

849: IF (cur_rowid%FOUND) THEN
850: Fnd_Message.Set_Name ('IGS', 'IGS_AS_USEC_ATT_OFR_OPT_FK');
851: IGS_GE_MSG_STACK.ADD;
852: CLOSE cur_rowid;
853: APP_EXCEPTION.RAISE_EXCEPTION;
854: RETURN;
855: END IF;
856: CLOSE cur_rowid;
857: