APPS.IGS_UC_APP_CHO_CNDS_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 100: app_exception.raise_exception;

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

Line 126: app_exception.raise_exception;

122: new_references.app_choice_id
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: END check_parent_existance;
130:

Line 234: app_exception.raise_exception;

230: IF (cur_rowid%FOUND) THEN
231: CLOSE cur_rowid;
232: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCC_UCAPCH_FK');
233: igs_ge_msg_stack.add;
234: app_exception.raise_exception;
235: RETURN;
236: END IF;
237: CLOSE cur_rowid;
238:

Line 295: app_exception.raise_exception;

291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: check_uniqueness;
298: check_parent_existance;
299: ELSIF (p_action = 'UPDATE') THEN

Line 311: app_exception.raise_exception;

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

Line 368: app_exception.raise_exception;

364: END IF;
365: ELSE
366: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370:
371: SELECT igs_uc_app_cho_cnds_s.NEXTVAL
372: INTO x_app_choice_cond_id

Line 472: app_exception.raise_exception;

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

Line 489: app_exception.raise_exception;

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

Line 539: app_exception.raise_exception;

535: END IF;
536: ELSE
537: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
538: igs_ge_msg_stack.add;
539: app_exception.raise_exception;
540: END IF;
541:
542: before_dml(
543: p_action => 'UPDATE',