eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_HLTH_INS_PKG dependencies on APP_EXCEPTION

Line 79: App_Exception.Raise_Exception;

75: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
76: Close cur_old_ref_values;
77: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: Return;
81: END IF;
82: Close cur_old_ref_values;
83:

Line 159: APP_EXCEPTION.RAISE_EXCEPTION;

155:
156: IF new_references.END_DATE IS NOT NULL AND new_references.START_DATE > new_references.END_DATE THEN
157: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
158: IGS_GE_MSG_STACK.ADD;
159: APP_EXCEPTION.RAISE_EXCEPTION;
160:
161: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
162: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');
163: IGS_GE_MSG_STACK.ADD;

Line 164: APP_EXCEPTION.RAISE_EXCEPTION;

160:
161: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
162: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');
163: IGS_GE_MSG_STACK.ADD;
164: APP_EXCEPTION.RAISE_EXCEPTION;
165: END IF;
166:
167: END IF;
168:

Line 223: app_exception.raise_exception;

219: ,new_references.person_id
220: ) THEN
221: Fnd_Message.Set_Name ('IGS', 'IGS_PE_HLTH_INS_DUP_EXISTS');
222: IGS_GE_MSG_STACK.ADD;
223: app_exception.raise_exception;
224: END IF;
225: END Check_Uniqueness ;
226:
227:

Line 255: App_Exception.Raise_Exception;

251: new_references.person_id
252: ) THEN
253: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257:
258: IF (((old_references.insurance_cd = new_references.insurance_cd)) OR -- making id cd
259: ((new_references.insurance_cd IS NULL))) THEN

Line 267: App_Exception.Raise_Exception;

263: new_references.insurance_cd
264: ) THEN
265: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: END IF;
269:
270: END Check_Parent_Existance;
271:

Line 390: App_Exception.Raise_Exception;

386: IF (cur_rowid%FOUND) THEN
387: Close cur_rowid;
388: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PHI_PP_FK');
389: IGS_GE_MSG_STACK.ADD;
390: App_Exception.Raise_Exception;
391: Return;
392: END IF;
393: Close cur_rowid;
394:

Line 431: App_Exception.Raise_Exception;

427: IF (cur_rowid%FOUND) THEN
428: Close cur_rowid;
429: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PHI_PCC_FK');
430: IGS_GE_MSG_STACK.ADD;
431: App_Exception.Raise_Exception;
432: Return;
433: END IF;
434: Close cur_rowid;
435:

Line 540: App_Exception.Raise_Exception;

536: IF Get_Pk_For_Validation(
537: new_references.health_ins_id) THEN
538: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
539: IGS_GE_MSG_STACK.ADD;
540: App_Exception.Raise_Exception;
541: END IF;
542: Check_Constraints;
543: Check_Uniqueness;
544: Check_Parent_Existance;

Line 561: App_Exception.Raise_Exception;

557: IF Get_PK_For_Validation (
558: new_references.health_ins_id) THEN
559: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
560: IGS_GE_MSG_STACK.ADD;
561: App_Exception.Raise_Exception;
562: END IF;
563: Check_Constraints;
564: Check_Uniqueness;
565: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 681: app_exception.raise_exception;

677: end if;
678: else
679: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
680: IGS_GE_MSG_STACK.ADD;
681: app_exception.raise_exception;
682: end if;
683: SELECT IGS_PE_HLTH_INS_S.NEXTVAL INTO X_HEALTH_INS_ID
684: FROM DUAL;
685:

Line 818: app_exception.raise_exception;

814: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
815: fnd_message.set_token ('ERR_CD', SQLCODE);
816: igs_ge_msg_stack.add;
817: igs_sc_gen_001.unset_ctx('R');
818: app_exception.raise_exception;
819: ELSE
820: igs_sc_gen_001.unset_ctx('R');
821: RAISE;
822: END IF;

Line 911: app_exception.raise_exception;

907: if (c1%notfound) then
908: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
909: IGS_GE_MSG_STACK.ADD;
910: close c1;
911: app_exception.raise_exception;
912: return;
913: end if;
914: close c1;
915: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 993: app_exception.raise_exception;

989: null;
990: else
991: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
992: IGS_GE_MSG_STACK.ADD;
993: app_exception.raise_exception;
994: end if;
995: return;
996: end LOCK_ROW;
997:

Line 1065: app_exception.raise_exception;

1061: end if;
1062: else
1063: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1064: IGS_GE_MSG_STACK.ADD;
1065: app_exception.raise_exception;
1066: end if;
1067: Before_DML(
1068: p_action=>'UPDATE',
1069: x_rowid=>X_ROWID,

Line 1142: app_exception.raise_exception;

1138: if (sql%notfound) then
1139: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1140: igs_ge_msg_stack.add;
1141: igs_sc_gen_001.unset_ctx('R');
1142: app_exception.raise_exception;
1143: end if;
1144: IF (x_mode = 'S') THEN
1145: igs_sc_gen_001.unset_ctx('R');
1146: END IF;

Line 1160: app_exception.raise_exception;

1156: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1157: fnd_message.set_token ('ERR_CD', SQLCODE);
1158: igs_ge_msg_stack.add;
1159: igs_sc_gen_001.unset_ctx('R');
1160: app_exception.raise_exception;
1161: ELSE
1162: igs_sc_gen_001.unset_ctx('R');
1163: RAISE;
1164: END IF;

Line 1325: app_exception.raise_exception;

1321: if (sql%notfound) then
1322: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1323: igs_ge_msg_stack.add;
1324: igs_sc_gen_001.unset_ctx('R');
1325: app_exception.raise_exception;
1326: end if;
1327: IF (x_mode = 'S') THEN
1328: igs_sc_gen_001.unset_ctx('R');
1329: END IF;