APPS.IGR_I_E_TESTTYPS_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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

Line 94: app_exception.raise_exception;

90: )
91: ) THEN
92: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: END check_uniqueness;
98:

Line 123: app_exception.raise_exception;

119: new_references.inquiry_type_id
120: ) THEN
121: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125:
126: IF (((old_references.admission_test_type = new_references.admission_test_type)) OR
127: ((new_references.admission_test_type IS NULL))) THEN

Line 134: app_exception.raise_exception;

130: new_references.admission_test_type ,
131: 'N' ) THEN
132: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
133: igs_ge_msg_stack.add;
134: app_exception.raise_exception;
135: END IF;
136:
137: END check_parent_existance;
138:

Line 245: app_exception.raise_exception;

241: IF (cur_rowid%FOUND) THEN
242: CLOSE cur_rowid;
243: fnd_message.set_name ('IGS', 'IGS_AD_AIETT_ADTT_FK');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: RETURN;
247: END IF;
248: CLOSE cur_rowid;
249:

Line 300: app_exception.raise_exception;

296: )
297: ) THEN
298: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: END IF;
302: check_uniqueness;
303: check_parent_existance;
304: ELSIF (p_action = 'UPDATE') THEN

Line 316: app_exception.raise_exception;

312: )
313: ) THEN
314: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
315: igs_ge_msg_stack.add;
316: app_exception.raise_exception;
317: END IF;
318: check_uniqueness;
319: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
320: check_uniqueness;

Line 370: app_exception.raise_exception;

366: END IF;
367: ELSE
368: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: END IF;
372:
373: X_ENT_TEST_TYPE_ID := -1;
374: before_dml(

Line 457: app_exception.raise_exception;

453: IF (c1%notfound) THEN
454: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
455: igs_ge_msg_stack.add;
456: CLOSE c1;
457: app_exception.raise_exception;
458: RETURN;
459: END IF;
460: CLOSE c1;
461:

Line 471: app_exception.raise_exception;

467: NULL;
468: ELSE
469: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: END IF;
473:
474: RETURN;
475:

Line 518: app_exception.raise_exception;

514: END IF;
515: ELSE
516: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
517: igs_ge_msg_stack.add;
518: app_exception.raise_exception;
519: END IF;
520:
521: before_dml(
522: p_action => 'UPDATE',

Line 657: App_Exception.Raise_Exception;

653: IF (cur_rowid%FOUND) THEN
654: Close cur_rowid;
655: Fnd_Message.Set_Name ('IGS', 'IGR_INQTYP_TSTTYP_FK');
656: IGS_GE_MSG_STACK.ADD;
657: App_Exception.Raise_Exception;
658: Return;
659: END IF;
660: Close cur_rowid;
661: END get_fk_igr_i_inquiry_types;