APPS.IGS_DA_RQST_PKG dependencies on APP_EXCEPTION

Line 76: app_exception.raise_exception;

72: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
73: CLOSE cur_old_ref_values;
74: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
75: igs_ge_msg_stack.add;
76: app_exception.raise_exception;
77: RETURN;
78: END IF;
79: CLOSE cur_old_ref_values;
80:

Line 150: app_exception.raise_exception;

146: new_references.request_type_id
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: IF (((old_references.person_id_group_id = new_references.person_id_group_id)) OR
154: ((new_references.person_id_group_id IS NULL))) THEN

Line 161: app_exception.raise_exception;

157: new_references.person_id_group_id
158: ) THEN
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: END IF;
163:
164: END check_parent_existance;
165:

Line 252: app_exception.raise_exception;

248: IF (cur_rowid%FOUND) THEN
249: CLOSE cur_rowid;
250: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_RQST_FK');
251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: RETURN;
254: END IF;
255: CLOSE cur_rowid;
256:

Line 287: app_exception.raise_exception;

283: IF (cur_rowid%FOUND) THEN
284: CLOSE cur_rowid;
285: fnd_message.set_name ('IGS', 'IGS_DA_PERSON_RQST_FK');
286: igs_ge_msg_stack.add;
287: app_exception.raise_exception;
288: RETURN;
289: END IF;
290: CLOSE cur_rowid;
291:

Line 396: app_exception.raise_exception;

392: )
393: ) THEN
394: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398: check_parent_existance;
399: ELSIF (p_action = 'UPDATE') THEN
400: -- Call all the procedures related to Before Update.

Line 413: app_exception.raise_exception;

409: )
410: ) THEN
411: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414: END IF;
415: ELSIF (p_action = 'VALIDATE_DELETE') THEN
416: check_child_existance;
417: END IF;

Line 493: app_exception.raise_exception;

489: ELSE
490: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
491: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.INSERT_ROW');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495: -- x_batch_id := NULL;
496:
497: before_dml(

Line 749: app_exception.raise_exception;

745: IF (c1%notfound) THEN
746: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
747: igs_ge_msg_stack.add;
748: CLOSE c1;
749: app_exception.raise_exception;
750: RETURN;
751: END IF;
752: CLOSE c1;
753:

Line 903: app_exception.raise_exception;

899: ELSE
900: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
901: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.UPDATE_ROW');
902: igs_ge_msg_stack.add;
903: app_exception.raise_exception;
904: END IF;
905:
906: -- x_batch_id := NULL;
907: