APPS.IGS_HE_USR_RTN_CLAS_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

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

Line 102: app_exception.raise_exception;

98: new_references.system_return_class_type
99: ) THEN
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:
105: END check_parent_existance;
106:

Line 193: app_exception.raise_exception;

189: IF (cur_rowid%FOUND) THEN
190: CLOSE cur_rowid;
191: fnd_message.set_name ('IGS', 'IGS_HE_HEURCD_HESRCD_FK');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: RETURN;
195: END IF;
196: CLOSE cur_rowid;
197:

Line 256: app_exception.raise_exception;

252: )
253: ) THEN
254: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258: check_parent_existance;
259: ELSIF (p_action = 'UPDATE') THEN
260: -- Call all the procedures related to Before Update.

Line 273: app_exception.raise_exception;

269: )
270: ) THEN
271: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: END IF;
275: ELSIF (p_action = 'VALIDATE_DELETE') THEN
276: check_child_existance;
277: END IF;

Line 330: app_exception.raise_exception;

326: END IF;
327: ELSE
328: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: END IF;
332:
333: SELECT igs_he_usr_rtn_clas_s.NEXTVAL
334: INTO x_usr_rtn_clas_id

Line 439: app_exception.raise_exception;

435: IF (c1%notfound) THEN
436: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
437: igs_ge_msg_stack.add;
438: CLOSE c1;
439: app_exception.raise_exception;
440: RETURN;
441: END IF;
442: CLOSE c1;
443:

Line 457: app_exception.raise_exception;

453: NULL;
454: ELSE
455: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
456: igs_ge_msg_stack.add;
457: app_exception.raise_exception;
458: END IF;
459:
460: RETURN;
461:

Line 508: app_exception.raise_exception;

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