DBA Data[Home] [Help]

APPS.IGS_PE_IMMU_DTLS_PKG dependencies on APP_EXCEPTION

Line 71: app_exception.raise_exception;

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

Line 151: APP_EXCEPTION.RAISE_EXCEPTION;

147:
148: IF new_references.END_DATE IS NOT NULL AND new_references.START_DATE > new_references.END_DATE THEN
149: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
150: IGS_GE_MSG_STACK.ADD;
151: APP_EXCEPTION.RAISE_EXCEPTION;
152:
153: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
154: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');
155: IGS_GE_MSG_STACK.ADD;

Line 156: APP_EXCEPTION.RAISE_EXCEPTION;

152:
153: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
154: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');
155: IGS_GE_MSG_STACK.ADD;
156: APP_EXCEPTION.RAISE_EXCEPTION;
157: END IF;
158:
159: END IF;
160:

Line 183: app_exception.raise_exception;

179: )
180: ) THEN
181: fnd_message.set_name ('IGS', 'IGS_PE_HLTH_IMM_DUP_EXISTS');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: END IF;
185:
186: END check_uniqueness;
187:

Line 209: app_exception.raise_exception;

205: new_references.person_id
206: ) THEN
207: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: END IF;
211:
212: END check_parent_existance;
213:

Line 316: app_exception.raise_exception;

312: IF (cur_rowid%FOUND) THEN
313: CLOSE cur_rowid;
314: fnd_message.set_name ('IGS', 'IGS_PE_PID_HZ_FK');
315: igs_ge_msg_stack.add;
316: app_exception.raise_exception;
317: RETURN;
318: END IF;
319: CLOSE cur_rowid;
320:

Line 419: app_exception.raise_exception;

415: )
416: ) THEN
417: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
418: igs_ge_msg_stack.add;
419: app_exception.raise_exception;
420: END IF;
421: check_uniqueness;
422: check_parent_existance;
423: 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 513: app_exception.raise_exception;

509: END IF;
510: ELSE
511: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
512: igs_ge_msg_stack.add;
513: app_exception.raise_exception;
514: END IF;
515:
516: SELECT igs_pe_immu_dtls_s.NEXTVAL
517: INTO x_immu_details_id

Line 648: app_exception.raise_exception;

644: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
645: fnd_message.set_token ('ERR_CD', SQLCODE);
646: igs_ge_msg_stack.add;
647: igs_sc_gen_001.unset_ctx('R');
648: app_exception.raise_exception;
649: ELSE
650: igs_sc_gen_001.unset_ctx('R');
651: RAISE;
652: END IF;

Line 738: app_exception.raise_exception;

734: IF (c1%notfound) THEN
735: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
736: igs_ge_msg_stack.add;
737: CLOSE c1;
738: app_exception.raise_exception;
739: RETURN;
740: END IF;
741: CLOSE c1;
742:

Line 816: app_exception.raise_exception;

812: NULL;
813: ELSE
814: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
815: igs_ge_msg_stack.add;
816: app_exception.raise_exception;
817: END IF;
818:
819: RETURN;
820:

Line 886: app_exception.raise_exception;

882: END IF;
883: ELSE
884: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
885: igs_ge_msg_stack.add;
886: app_exception.raise_exception;
887: END IF;
888:
889: before_dml(
890: p_action => 'UPDATE',

Line 966: app_exception.raise_exception;

962: IF (SQL%NOTFOUND) THEN
963: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
964: igs_ge_msg_stack.add;
965: igs_sc_gen_001.unset_ctx('R');
966: app_exception.raise_exception;
967: END IF;
968: IF (x_mode = 'S') THEN
969: igs_sc_gen_001.unset_ctx('R');
970: END IF;

Line 981: app_exception.raise_exception;

977: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
978: fnd_message.set_token ('ERR_CD', SQLCODE);
979: igs_ge_msg_stack.add;
980: igs_sc_gen_001.unset_ctx('R');
981: app_exception.raise_exception;
982: ELSE
983: igs_sc_gen_001.unset_ctx('R');
984: RAISE;
985: END IF;

Line 1141: app_exception.raise_exception;

1137: IF (SQL%NOTFOUND) THEN
1138: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1139: igs_ge_msg_stack.add;
1140: igs_sc_gen_001.unset_ctx('R');
1141: app_exception.raise_exception;
1142: END IF;
1143: IF (x_mode = 'S') THEN
1144: igs_sc_gen_001.unset_ctx('R');
1145: END IF;