APPS.IGS_PE_HZ_REL_PKG dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

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

Line 331: app_exception.raise_exception;

327: BEGIN
328: IF new_references.primary = 'Y' AND new_references.secondary = 'Y' THEN
329: fnd_message.set_name('IGS', 'IGS_AD_NOT_BOTH_PRIM_SEC');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: END before_row_insert_update;
334:
335: PROCEDURE check_parent_existance AS

Line 365: app_exception.raise_exception;

361: IF rel_pk%NOTFOUND THEN
362: CLOSE rel_pk;
363: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
364: igs_ge_msg_stack.add;
365: app_exception.raise_exception;
366: END IF;
367: CLOSE rel_pk;
368: END IF;
369:

Line 471: app_exception.raise_exception;

467: )
468: ) THEN
469: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: END IF;
473: check_parent_existance;
474: before_row_insert_update;
475: ELSIF (p_action = 'UPDATE') THEN

Line 488: app_exception.raise_exception;

484: )
485: ) THEN
486: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: before_row_insert_update;
491: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
492: before_row_insert_update;

Line 585: app_exception.raise_exception;

581: ELSE
582: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
583: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.INSERT_ROW');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;
587:
588: before_dml(
589: p_action => 'INSERT',

Line 704: app_exception.raise_exception;

700: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
701: fnd_message.set_token ('ERR_CD', SQLCODE);
702: igs_ge_msg_stack.add;
703: igs_sc_gen_001.unset_ctx('R');
704: app_exception.raise_exception;
705: ELSE
706: igs_sc_gen_001.unset_ctx('R');
707: RAISE;
708: END IF;

Line 760: app_exception.raise_exception;

756: IF (c1%notfound) THEN
757: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
758: igs_ge_msg_stack.add;
759: CLOSE c1;
760: app_exception.raise_exception;
761: RETURN;
762: END IF;
763: CLOSE c1;
764:

Line 780: app_exception.raise_exception;

776: NULL;
777: ELSE
778: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
779: igs_ge_msg_stack.add;
780: app_exception.raise_exception;
781: END IF;
782:
783: RETURN;
784:

Line 835: app_exception.raise_exception;

831: ELSE
832: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
833: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.UPDATE_ROW');
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836: END IF;
837:
838: before_dml(
839: p_action => 'UPDATE',

Line 902: app_exception.raise_exception;

898: IF (SQL%NOTFOUND) THEN
899: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
900: igs_ge_msg_stack.add;
901: igs_sc_gen_001.unset_ctx('R');
902: app_exception.raise_exception;
903: END IF;
904: IF (x_mode = 'S') THEN
905: igs_sc_gen_001.unset_ctx('R');
906: END IF;

Line 919: app_exception.raise_exception;

915: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
916: fnd_message.set_token ('ERR_CD', SQLCODE);
917: igs_ge_msg_stack.add;
918: igs_sc_gen_001.unset_ctx('R');
919: app_exception.raise_exception;
920: ELSE
921: igs_sc_gen_001.unset_ctx('R');
922: RAISE;
923: END IF;

Line 1032: app_exception.raise_exception;

1028: IF (SQL%NOTFOUND) THEN
1029: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1030: igs_ge_msg_stack.add;
1031: igs_sc_gen_001.unset_ctx('R');
1032: app_exception.raise_exception;
1033: END IF;
1034: IF (x_mode = 'S') THEN
1035: igs_sc_gen_001.unset_ctx('R');
1036: END IF;