APPS.IGR_I_INQUIRY_TYPES_PKG dependencies on APP_EXCEPTION

Line 63: app_exception.raise_exception;

59: )
60: ) THEN
61: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
62: igs_ge_msg_stack.add;
63: app_exception.raise_exception;
64: END IF;
65:
66: END check_uniqueness;
67:

Line 131: app_exception.raise_exception;

127: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
128: CLOSE cur_old_ref_values;
129: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: RETURN;
133: END IF;
134: CLOSE cur_old_ref_values;
135:

Line 180: app_exception.raise_exception;

176: new_references.imp_source_type_id
177: ) THEN
178: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182:
183: IF (((old_references.info_type_id = new_references.info_type_id)) OR
184: ((new_references.info_type_id IS NULL))) THEN

Line 191: app_exception.raise_exception;

187: new_references.info_type_id
188: ) THEN
189: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193:
194: END check_parent_existance;
195:

Line 259: app_exception.raise_exception;

255: IF (cur_rowid%FOUND) THEN
256: CLOSE cur_rowid;
257: fnd_message.set_name ('IGS', 'IGR_INQSRC_INQTYP_FK');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: RETURN;
261: END IF;
262: CLOSE cur_rowid;
263:

Line 294: app_exception.raise_exception;

290: IF (cur_rowid%FOUND) THEN
291: CLOSE cur_rowid;
292: fnd_message.set_name ('IGS', 'IGR_ITYP_INQTYP_FK');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: RETURN;
296: END IF;
297: CLOSE cur_rowid;
298:

Line 355: app_exception.raise_exception;

351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357: check_uniqueness;
358: check_parent_existance;
359: ELSIF (p_action = 'UPDATE') THEN

Line 372: app_exception.raise_exception;

368: )
369: ) THEN
370: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374: -- code begin -- To call all procedures realted to Before delete - Apadegal- 7-March-2005
375: ELSIF (p_action = 'DELETE') THEN
376: Check_Child_Existance;

Line 428: app_exception.raise_exception;

424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:
431: x_inquiry_type_id := NULL;
432:

Line 522: app_exception.raise_exception;

518: IF (c1%notfound) THEN
519: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
520: igs_ge_msg_stack.add;
521: CLOSE c1;
522: app_exception.raise_exception;
523: RETURN;
524: END IF;
525: CLOSE c1;
526:

Line 539: app_exception.raise_exception;

535: NULL;
536: ELSE
537: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
538: igs_ge_msg_stack.add;
539: app_exception.raise_exception;
540: END IF;
541:
542: RETURN;
543:

Line 590: app_exception.raise_exception;

586: ELSE
587: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
588: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.UPDATE_ROW');
589: igs_ge_msg_stack.add;
590: app_exception.raise_exception;
591: END IF;
592:
593: before_dml(
594: p_action => 'UPDATE',