APPS.IGS_HE_UNT_OU_CC_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 102: app_exception.raise_exception;

98: )
99: ) THEN
100: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:
105: END check_uniqueness;
106:

Line 134: app_exception.raise_exception;

130: new_references.org_unit_cd
131: ) 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 249: app_exception.raise_exception;

245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGS', 'IGS_HE_CC_OU_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;
252: CLOSE cur_rowid;
253:

Line 310: app_exception.raise_exception;

306: )
307: ) THEN
308: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
309: igs_ge_msg_stack.add;
310: app_exception.raise_exception;
311: END IF;
312: check_uniqueness;
313: check_parent_existance;
314: ELSIF (p_action = 'UPDATE') THEN

Line 326: app_exception.raise_exception;

322: )
323: ) THEN
324: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
325: igs_ge_msg_stack.add;
326: app_exception.raise_exception;
327: END IF;
328: check_uniqueness;
329: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
330: check_uniqueness;

Line 380: app_exception.raise_exception;

376: ELSE
377: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
378: fnd_message.set_token ('ROUTINE', 'IGS_HE_UNT_OU_CC_PKG.INSERT_ROW');
379: igs_ge_msg_stack.add;
380: app_exception.raise_exception;
381: END IF;
382:
383: x_hesa_unit_cc_id := NULL;
384:

Line 474: app_exception.raise_exception;

470: IF (c1%notfound) THEN
471: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
472: igs_ge_msg_stack.add;
473: CLOSE c1;
474: app_exception.raise_exception;
475: RETURN;
476: END IF;
477: CLOSE c1;
478:

Line 491: app_exception.raise_exception;

487: NULL;
488: ELSE
489: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493:
494: RETURN;
495:

Line 542: app_exception.raise_exception;

538: ELSE
539: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
540: fnd_message.set_token ('ROUTINE', 'IGS_HE_UNT_OU_CC_PKG.UPDATE_ROW');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544:
545: before_dml(
546: p_action => 'UPDATE',