DBA Data[Home] [Help]

APPS.IGS_EN_SPLACEMENTS_PKG dependencies on APP_EXCEPTION

Line 60: app_exception.raise_exception;

56: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
57: CLOSE cur_old_ref_values;
58: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
59: igs_ge_msg_stack.add;
60: app_exception.raise_exception;
61: RETURN;
62: END IF;
63: CLOSE cur_old_ref_values;
64:

Line 119: app_exception.raise_exception;

115: )
116: ) THEN
117: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
122: IF ( get_uk2_for_validation (
123: new_references.person_id,

Line 131: app_exception.raise_exception;

127: )
128: ) THEN
129: fnd_message.set_name ('IGS', 'IGS_EN_PLACMNT_DTLS_EXISTS');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133:
134: END check_uniqueness;
135:

Line 323: app_exception.raise_exception;

319: )
320: ) THEN
321: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: check_uniqueness;
326: ELSIF (p_action = 'UPDATE') THEN
327: -- Call all the procedures related to Before Update.

Line 337: app_exception.raise_exception;

333: )
334: ) THEN
335: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339: check_uniqueness;
340: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
341: check_uniqueness;

Line 400: app_exception.raise_exception;

396: ELSE
397: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
398: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPLACEMENTS_PKG.INSERT_ROW');
399: igs_ge_msg_stack.add;
400: app_exception.raise_exception;
401: END IF;
402:
403: x_splacement_id := NULL;
404:

Line 539: app_exception.raise_exception;

535: IF (c1%notfound) THEN
536: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
537: igs_ge_msg_stack.add;
538: CLOSE c1;
539: app_exception.raise_exception;
540: RETURN;
541: END IF;
542: CLOSE c1;
543:

Line 565: app_exception.raise_exception;

561: NULL;
562: ELSE
563: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
564: igs_ge_msg_stack.add;
565: app_exception.raise_exception;
566: END IF;
567:
568: RETURN;
569:

Line 625: app_exception.raise_exception;

621: ELSE
622: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
623: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPLACEMENTS_PKG.UPDATE_ROW');
624: igs_ge_msg_stack.add;
625: app_exception.raise_exception;
626: END IF;
627:
628: before_dml(
629: p_action => 'UPDATE',