APPS.IGS_PE_USR_AVAL_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;
102:

Line 124: app_exception.raise_exception;

120: new_references.person_type
121: ) THEN
122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126:
127: END check_parent_existance;
128:

Line 229: app_exception.raise_exception;

225: IF (cur_rowid%FOUND) THEN
226: CLOSE cur_rowid;
227: fnd_message.set_name ('IGS', 'IGS_PE_UAVV_PTY_FK');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: RETURN;
231: END IF;
232: CLOSE cur_rowid;
233:

Line 289: app_exception.raise_exception;

285: )
286: ) THEN
287: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: END IF;
291: check_uniqueness;
292: check_parent_existance;
293: ELSIF (p_action = 'UPDATE') THEN

Line 305: app_exception.raise_exception;

301: )
302: ) THEN
303: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
304: igs_ge_msg_stack.add;
305: app_exception.raise_exception;
306: END IF;
307: check_uniqueness;
308: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
309: check_uniqueness;

Line 362: app_exception.raise_exception;

358: END IF;
359: ELSE
360: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
361: igs_ge_msg_stack.add;
362: app_exception.raise_exception;
363: END IF;
364:
365: SELECT igs_pe_usr_aval_all_s.NEXTVAL
366: INTO x_usr_act_val_id

Line 463: app_exception.raise_exception;

459: IF (c1%notfound) THEN
460: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
461: igs_ge_msg_stack.add;
462: CLOSE c1;
463: app_exception.raise_exception;
464: RETURN;
465: END IF;
466: CLOSE c1;
467:

Line 476: app_exception.raise_exception;

472: NULL;
473: ELSE
474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
475: igs_ge_msg_stack.add;
476: app_exception.raise_exception;
477: END IF;
478:
479: RETURN;
480:

Line 526: app_exception.raise_exception;

522: END IF;
523: ELSE
524: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
525: igs_ge_msg_stack.add;
526: app_exception.raise_exception;
527: END IF;
528:
529: before_dml(
530: p_action => 'UPDATE',