DBA Data[Home] [Help]

APPS.IGF_SL_DL_SETUP_PKG dependencies on APP_EXCEPTION

Line 63: app_exception.raise_exception;

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

Line 121: app_exception.raise_exception;

117: )
118: ) THEN
119: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123:
124: END check_uniqueness;
125:

Line 150: app_exception.raise_exception;

146: new_references.ci_sequence_number
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: END check_parent_existance;
154:

Line 257: app_exception.raise_exception;

253: IF (cur_rowid%FOUND) THEN
254: CLOSE cur_rowid;
255: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: RETURN;
259: END IF;
260: CLOSE cur_rowid;
261:

Line 342: app_exception.raise_exception;

338: )
339: ) THEN
340: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344: check_uniqueness;
345: check_parent_existance;
346: ELSIF (p_action = 'UPDATE') THEN

Line 358: app_exception.raise_exception;

354: )
355: ) THEN
356: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: END IF;
360: check_uniqueness;
361: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
362: check_uniqueness;

Line 429: app_exception.raise_exception;

425: END IF;
426: ELSE
427: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
428: igs_ge_msg_stack.add;
429: app_exception.raise_exception;
430: END IF;
431:
432: SELECT igf_sl_dl_setup_s.nextval INTO x_dlset_id FROM DUAL;
433: before_dml(

Line 591: app_exception.raise_exception;

587: IF (c1%notfound) THEN
588: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
589: igs_ge_msg_stack.add;
590: CLOSE c1;
591: app_exception.raise_exception;
592: RETURN;
593: END IF;
594: CLOSE c1;
595:

Line 617: app_exception.raise_exception;

613: NULL;
614: ELSE
615: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
616: igs_ge_msg_stack.add;
617: app_exception.raise_exception;
618: END IF;
619:
620: RETURN;
621:

Line 680: app_exception.raise_exception;

676: END IF;
677: ELSE
678: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
679: igs_ge_msg_stack.add;
680: app_exception.raise_exception;
681: END IF;
682:
683: before_dml(
684: p_action => 'UPDATE',