DBA Data[Home] [Help]

APPS.IGS_UC_TRANSACTIONS_PKG dependencies on APP_EXCEPTION

Line 74: app_exception.raise_exception;

70: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
71: CLOSE cur_old_ref_values;
72: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
73: igs_ge_msg_stack.add;
74: app_exception.raise_exception;
75: RETURN;
76: END IF;
77: CLOSE cur_old_ref_values;
78:

Line 149: app_exception.raise_exception;

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

Line 286: app_exception.raise_exception;

282: )
283: ) THEN
284: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288: check_parent_existance;
289: ELSIF (p_action = 'VALIDATE_INSERT') THEN
290: -- Call all the procedures related to Before Insert.

Line 297: app_exception.raise_exception;

293: )
294: ) THEN
295: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END IF;
299: END IF;
300:
301: END before_dml;

Line 374: app_exception.raise_exception;

370: END IF;
371: ELSE
372: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
373: igs_ge_msg_stack.add;
374: app_exception.raise_exception;
375: END IF;
376:
377: SELECT igs_uc_transactions_s.NEXTVAL
378: INTO x_uc_tran_id

Line 512: app_exception.raise_exception;

508: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE
514: igs_sc_gen_001.unset_ctx('R');
515: RAISE;
516: END IF;

Line 605: app_exception.raise_exception;

601: IF (c1%notfound) THEN
602: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
603: igs_ge_msg_stack.add;
604: CLOSE c1;
605: app_exception.raise_exception;
606: RETURN;
607: END IF;
608: CLOSE c1;
609:

Line 643: app_exception.raise_exception;

639: NULL;
640: ELSE
641: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
642: igs_ge_msg_stack.add;
643: app_exception.raise_exception;
644: END IF;
645:
646: RETURN;
647:

Line 716: app_exception.raise_exception;

712: END IF;
713: ELSE
714: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
715: igs_ge_msg_stack.add;
716: app_exception.raise_exception;
717: END IF;
718:
719: before_dml(
720: p_action => 'UPDATE',

Line 798: app_exception.raise_exception;

794: IF (SQL%NOTFOUND) THEN
795: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
796: igs_ge_msg_stack.add;
797: igs_sc_gen_001.unset_ctx('R');
798: app_exception.raise_exception;
799: END IF;
800: IF (x_mode = 'S') THEN
801: igs_sc_gen_001.unset_ctx('R');
802: END IF;

Line 811: app_exception.raise_exception;

807: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
808: fnd_message.set_token ('ERR_CD', SQLCODE);
809: igs_ge_msg_stack.add;
810: igs_sc_gen_001.unset_ctx('R');
811: app_exception.raise_exception;
812: ELSE
813: igs_sc_gen_001.unset_ctx('R');
814: RAISE;
815: END IF;

Line 977: app_exception.raise_exception;

973: IF (SQL%NOTFOUND) THEN
974: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
975: igs_ge_msg_stack.add;
976: igs_sc_gen_001.unset_ctx('R');
977: app_exception.raise_exception;
978: END IF;
979: IF (x_mode = 'S') THEN
980: igs_sc_gen_001.unset_ctx('R');
981: END IF;