APPS.IGS_EN_ELGB_OVR_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 95: app_exception.raise_exception;

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

Line 124: app_exception.raise_exception;

120: new_references.ci_sequence_number
121: ) THEN
122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
126: new_references.person_id
127: ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 130: app_exception.raise_exception;

126: new_references.person_id
127: ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132:
133: END check_parent_existance;
134:

Line 262: app_exception.raise_exception;

258: IF (cur_rowid%FOUND) THEN
259: CLOSE cur_rowid;
260: fnd_message.set_name ('IGS', 'IGS_EN_EOA_CI_FK');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: RETURN;
264: END IF;
265: CLOSE cur_rowid;
266:

Line 296: app_exception.raise_exception;

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

Line 351: app_exception.raise_exception;

347: )
348: ) THEN
349: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END IF;
353: check_uniqueness;
354: check_parent_existance;
355: ELSIF (p_action = 'UPDATE') THEN

Line 370: app_exception.raise_exception;

366: )
367: ) THEN
368: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: END IF;
372: check_uniqueness;
373: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
374: check_uniqueness;

Line 442: app_exception.raise_exception;

438: END IF;
439: ELSE
440: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:
445: SELECT igs_en_elgb_ovr_s.NEXTVAL
446: INTO x_elgb_override_id

Line 543: app_exception.raise_exception;

539: IF (c1%notfound) THEN
540: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
541: igs_ge_msg_stack.add;
542: CLOSE c1;
543: app_exception.raise_exception;
544: RETURN;
545: END IF;
546: CLOSE c1;
547:

Line 557: app_exception.raise_exception;

553: NULL;
554: ELSE
555: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
556: igs_ge_msg_stack.add;
557: app_exception.raise_exception;
558: END IF;
559:
560: RETURN;
561:

Line 608: app_exception.raise_exception;

604: END IF;
605: ELSE
606: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610:
611: before_dml(
612: p_action => 'UPDATE',