DBA Data[Home] [Help]

APPS.IGS_PE_EV_FORM_STAT_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
56: CLOSE cur_old_ref_values;
57:

Line 222: app_exception.raise_exception;

218: )
219: ) THEN
220: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
221: igs_ge_msg_stack.add;
222: app_exception.raise_exception;
223: END IF;
224:
225: END check_uniqueness;
226:

Line 248: app_exception.raise_exception;

244: new_references.ev_form_id
245: ) THEN
246: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
250:
251: END check_parent_existance;
252:

Line 355: app_exception.raise_exception;

351: IF (cur_rowid%FOUND) THEN
352: CLOSE cur_rowid;
353: fnd_message.set_name ('IGS', 'IGS_PE_PEFMS_PEVF_FK');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: RETURN;
357: END IF;
358: CLOSE cur_rowid;
359:

Line 420: app_exception.raise_exception;

416: )
417: ) THEN
418: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
419: igs_ge_msg_stack.add;
420: app_exception.raise_exception;
421: END IF;
422: check_uniqueness;
423: check_parent_existance;
424: ELSIF (p_action = 'UPDATE') THEN

Line 436: app_exception.raise_exception;

432: )
433: ) THEN
434: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438: check_uniqueness;
439: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
440: check_uniqueness;

Line 491: app_exception.raise_exception;

487: END IF;
488: ELSE
489: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493:
494: before_dml(
495: p_action => 'INSERT',

Line 562: app_exception.raise_exception;

558: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
559: fnd_message.set_token ('ERR_CD', SQLCODE);
560: igs_ge_msg_stack.add;
561: igs_sc_gen_001.unset_ctx('R');
562: app_exception.raise_exception;
563: ELSE
564: igs_sc_gen_001.unset_ctx('R');
565: RAISE;
566: END IF;

Line 615: app_exception.raise_exception;

611: IF (c1%notfound) THEN
612: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
613: igs_ge_msg_stack.add;
614: CLOSE c1;
615: app_exception.raise_exception;
616: RETURN;
617: END IF;
618: CLOSE c1;
619:

Line 634: app_exception.raise_exception;

630: NULL;
631: ELSE
632: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
633: igs_ge_msg_stack.add;
634: app_exception.raise_exception;
635: END IF;
636:
637: RETURN;
638:

Line 686: app_exception.raise_exception;

682: END IF;
683: ELSE
684: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
685: igs_ge_msg_stack.add;
686: app_exception.raise_exception;
687: END IF;
688:
689: before_dml(
690: p_action => 'UPDATE',

Line 730: app_exception.raise_exception;

726: IF (SQL%NOTFOUND) THEN
727: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
728: igs_ge_msg_stack.add;
729: igs_sc_gen_001.unset_ctx('R');
730: app_exception.raise_exception;
731: END IF;
732: IF (x_mode = 'S') THEN
733: igs_sc_gen_001.unset_ctx('R');
734: END IF;

Line 745: app_exception.raise_exception;

741: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
742: fnd_message.set_token ('ERR_CD', SQLCODE);
743: igs_ge_msg_stack.add;
744: igs_sc_gen_001.unset_ctx('R');
745: app_exception.raise_exception;
746: ELSE
747: igs_sc_gen_001.unset_ctx('R');
748: RAISE;
749: END IF;

Line 851: app_exception.raise_exception;

847: IF (SQL%NOTFOUND) THEN
848: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
849: igs_ge_msg_stack.add;
850: igs_sc_gen_001.unset_ctx('R');
851: app_exception.raise_exception;
852: END IF;
853: IF (x_mode = 'S') THEN
854: igs_sc_gen_001.unset_ctx('R');
855: END IF;