APPS.IGS_AS_SUA_SES_ATTS_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 201: app_exception.raise_exception;

197: )
198: ) THEN
199: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
200: igs_ge_msg_stack.add;
201: app_exception.raise_exception;
202: END IF;
203: check_parent_existance;
204: ELSIF (p_action = 'VALIDATE_INSERT') THEN
205: -- Call all the procedures related to Before Insert.

Line 215: app_exception.raise_exception;

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

Line 270: app_exception.raise_exception;

266: ELSE
267: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
268: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.INSERT_ROW');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: END IF;
272:
273: before_dml(
274: 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 419: app_exception.raise_exception;

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

Line 506: app_exception.raise_exception;

502: ELSE
503: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
504: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.UPDATE_ROW');
505: igs_ge_msg_stack.add;
506: app_exception.raise_exception;
507: END IF;
508:
509: before_dml(
510: p_action => 'UPDATE',

Line 539: app_exception.raise_exception;

535: IF (SQL%NOTFOUND) THEN
536: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
537: igs_ge_msg_stack.add;
538: igs_sc_gen_001.unset_ctx('R');
539: app_exception.raise_exception;
540: END IF;
541: IF (x_mode = 'S') THEN
542: igs_sc_gen_001.unset_ctx('R');
543: END IF;

Line 734: app_exception.raise_exception;

730: IF (SQL%NOTFOUND) THEN
731: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
732: igs_ge_msg_stack.add;
733: igs_sc_gen_001.unset_ctx('R');
734: app_exception.raise_exception;
735: END IF;
736: IF (x_mode = 'S') THEN
737: igs_sc_gen_001.unset_ctx('R');
738: END IF;

Line 807: APP_EXCEPTION.RAISE_EXCEPTION;

803: IF (cur_rowid%FOUND) THEN
804: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SES_ATTS_USEC_SESS_FK');
805: IGS_GE_MSG_STACK.ADD;
806: CLOSE cur_rowid;
807: APP_EXCEPTION.RAISE_EXCEPTION;
808: RETURN;
809: END IF;
810: CLOSE cur_rowid;
811:

Line 846: APP_EXCEPTION.RAISE_EXCEPTION;

842: IF (cur_rowid%FOUND) THEN
843: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SES_ATTS_SUA_FK');
844: IGS_GE_MSG_STACK.ADD;
845: CLOSE cur_rowid;
846: APP_EXCEPTION.RAISE_EXCEPTION;
847: RETURN;
848: END IF;
849: CLOSE cur_rowid;
850: