APPS.IGS_HE_CODE_VALUES_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 89: app_exception.raise_exception;

85: BEGIN
86: IF get_uk_for_validation(new_references.code_type, new_references.value) Then
87: fnd_message.set_name('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
88: igs_ge_msg_stack.add;
89: app_exception.raise_exception;
90: END IF;
91: END check_uniqueness;
92:
93: PROCEDURE check_parent_existance AS

Line 113: app_exception.raise_exception;

109: new_references.code_type
110: ) THEN
111: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
112: igs_ge_msg_stack.add;
113: app_exception.raise_exception;
114: END IF;
115:
116: END check_parent_existance;
117:

Line 218: app_exception.raise_exception;

214: IF (cur_rowid%FOUND) THEN
215: CLOSE cur_rowid;
216: fnd_message.set_name ('IGS', 'IGS_HE_HECDVAL_HECDTY_FK');
217: igs_ge_msg_stack.add;
218: app_exception.raise_exception;
219: RETURN;
220: END IF;
221: CLOSE cur_rowid;
222:

Line 274: app_exception.raise_exception;

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

Line 291: app_exception.raise_exception;

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

Line 346: app_exception.raise_exception;

342: END IF;
343: ELSE
344: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
345: igs_ge_msg_stack.add;
346: app_exception.raise_exception;
347: END IF;
348:
349: before_dml(
350: p_action => 'INSERT',

Line 429: app_exception.raise_exception;

425: IF (c1%notfound) THEN
426: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
427: igs_ge_msg_stack.add;
428: CLOSE c1;
429: app_exception.raise_exception;
430: RETURN;
431: END IF;
432: CLOSE c1;
433:

Line 442: app_exception.raise_exception;

438: NULL;
439: ELSE
440: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:
445: RETURN;
446:

Line 489: app_exception.raise_exception;

485: END IF;
486: ELSE
487: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END IF;
491:
492: before_dml(
493: p_action => 'UPDATE',