DBA Data[Home] [Help]

APPS.IGS_UC_APP_RESULTS_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 117: app_exception.raise_exception;

113: new_references.app_id
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF (((old_references.subject_id = new_references.subject_id)) OR
121: ((new_references.subject_id IS NULL))) THEN

Line 128: app_exception.raise_exception;

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

Line 195: app_exception.raise_exception;

191: IF (cur_rowid%FOUND) THEN
192: CLOSE cur_rowid;
193: fnd_message.set_name ('IGS', 'IGS_UC_UCAPRE_UCAP_FK');
194: igs_ge_msg_stack.add;
195: app_exception.raise_exception;
196: RETURN;
197: END IF;
198: CLOSE cur_rowid;
199:

Line 230: app_exception.raise_exception;

226: IF (cur_rowid%FOUND) THEN
227: CLOSE cur_rowid;
228: fnd_message.set_name ('IGS', 'IGS_UC_UCAPRE_UCCOES_FK');
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: RETURN;
232: END IF;
233: CLOSE cur_rowid;
234:

Line 308: app_exception.raise_exception;

304: )
305: ) THEN
306: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310: check_parent_existance;
311: ELSIF (p_action = 'UPDATE') THEN
312: -- Call all the procedures related to Before Update.

Line 322: app_exception.raise_exception;

318: )
319: ) THEN
320: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324: END IF;
325:
326: END before_dml;

Line 385: app_exception.raise_exception;

381: END IF;
382: ELSE
383: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
384: igs_ge_msg_stack.add;
385: app_exception.raise_exception;
386: END IF;
387:
388: SELECT igs_uc_app_results_s.NEXTVAL
389: INTO x_app_result_id

Line 530: app_exception.raise_exception;

526: IF (c1%notfound) THEN
527: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
528: igs_ge_msg_stack.add;
529: CLOSE c1;
530: app_exception.raise_exception;
531: RETURN;
532: END IF;
533: CLOSE c1;
534:

Line 555: app_exception.raise_exception;

551: NULL;
552: ELSE
553: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
554: igs_ge_msg_stack.add;
555: app_exception.raise_exception;
556: END IF;
557:
558: RETURN;
559:

Line 614: app_exception.raise_exception;

610: END IF;
611: ELSE
612: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
613: igs_ge_msg_stack.add;
614: app_exception.raise_exception;
615: END IF;
616:
617: before_dml(
618: p_action => 'UPDATE',