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 IGS_GE_MSG_STACK

Line 78: IGS_GE_MSG_STACK.ADD;

74: Fetch cur_old_ref_values INTO old_references;
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;

Line 158: IGS_GE_MSG_STACK.ADD;

154: CLOSE validate_brth_dt;
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');

Line 163: 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;
164: APP_EXCEPTION.RAISE_EXCEPTION;
165: END IF;
166:
167: END IF;

Line 222: IGS_GE_MSG_STACK.ADD;

218: ,new_references.start_date
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:

Line 254: IGS_GE_MSG_STACK.ADD;

250: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
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

Line 266: IGS_GE_MSG_STACK.ADD;

262: 'PE_INS_TYPE',
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;

Line 389: IGS_GE_MSG_STACK.ADD;

385: Fetch cur_rowid INTO lv_rowid;
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;

Line 430: IGS_GE_MSG_STACK.ADD;

426: Fetch cur_rowid INTO lv_rowid;
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;

Line 539: IGS_GE_MSG_STACK.ADD;

535: Null;
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;

Line 560: IGS_GE_MSG_STACK.ADD;

556: -- Call all the procedures related to Before Insert.
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;

Line 680: IGS_GE_MSG_STACK.ADD;

676: X_LAST_UPDATE_LOGIN := -1;
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;

Line 816: igs_ge_msg_stack.add;

812: WHEN OTHERS THEN
813: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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');

Line 909: IGS_GE_MSG_STACK.ADD;

905: open c1;
906: fetch c1 into tlinfo;
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;

Line 992: IGS_GE_MSG_STACK.ADD;

988: ) then
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;

Line 1064: IGS_GE_MSG_STACK.ADD;

1060: X_LAST_UPDATE_LOGIN := -1;
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',

Line 1140: igs_ge_msg_stack.add;

1136: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
1137: where ROWID = X_ROWID;
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

Line 1158: igs_ge_msg_stack.add;

1154: WHEN OTHERS THEN
1155: IF (SQLCODE = (-28115)) THEN
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');

Line 1323: igs_ge_msg_stack.add;

1319: delete from IGS_PE_HLTH_INS_ALL
1320: where ROWID = X_ROWID;
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