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_PERSON_ID_TYP_PKG dependencies on IGS_GE_MSG_STACK

Line 74: IGS_GE_MSG_STACK.ADD;

70: Fetch cur_old_ref_values INTO old_references;
71: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
72: Close cur_old_ref_values;
73: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76: Return;
77: END IF;
78: Close cur_old_ref_values;

Line 132: IGS_GE_MSG_STACK.ADD;

128: IF IGS_EN_VAL_PIT.enrp_val_pit_inst_cd (
129: new_references.institution_cd,
130: v_message_name) = FALSE THEN
131: Fnd_Message.Set_Name('IGS', v_message_name);
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136: END BeforeRowInsertUpdate1;

Line 178: IGS_GE_MSG_STACK.ADD;

174: IF Upper(Column_Name) = 'PREFERRED_IND' OR
175: Column_Name IS NULL THEN
176: IF NOT (new_references.preferred_ind IN ('Y', 'N')) THEN
177: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181: END IF;
182:

Line 188: IGS_GE_MSG_STACK.ADD;

184: IF Upper(Column_Name) = 'UNIQUE_IND' OR
185: Column_Name IS NULL THEN
186: IF NOT (new_references.unique_ind IN ('N', 'Y')) THEN
187: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192:

Line 198: IGS_GE_MSG_STACK.ADD;

194: IF Upper(Column_Name) = 'REGION_IND' OR
195: Column_Name IS NULL THEN
196: IF NOT (new_references.region_ind IN ('N', 'Y')) THEN
197: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202:

Line 207: IGS_GE_MSG_STACK.ADD;

203: IF UPPER(Column_Name) = 'PERSON_ID_TYPE' OR
204: Column_Name IS NULL THEN
205: IF new_references.PERSON_ID_TYPE <> UPPER(new_references.person_id_type) THEN
206: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;
211:

Line 216: IGS_GE_MSG_STACK.ADD;

212: IF UPPER(Column_Name) = 'S_PERSON_ID_TYPE' OR
213: Column_Name IS NULL THEN
214: IF new_references.S_PERSON_ID_TYPE <> UPPER(new_references.s_person_id_type) THEN
215: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: END IF;
219: END IF;
220:

Line 247: IGS_GE_MSG_STACK.ADD;

243:
244: IF NOT IGS_OR_INSTITUTION_PKG.Get_PK_For_Validation (
245: new_references.institution_cd) THEN
246: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
247: IGS_GE_MSG_STACK.ADD;
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;
251: END IF;

Line 248: IGS_GE_MSG_STACK.ADD;

244: IF NOT IGS_OR_INSTITUTION_PKG.Get_PK_For_Validation (
245: new_references.institution_cd) THEN
246: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
247: IGS_GE_MSG_STACK.ADD;
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;
251: END IF;
252: IF (((old_references.s_person_id_type = new_references.s_person_id_type)) OR

Line 259: IGS_GE_MSG_STACK.ADD;

255: ELSE
256: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
257: 'PERSON_ID_TYPE',new_references.s_person_id_type) THEN
258: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262:
263: END IF;

Line 366: IGS_GE_MSG_STACK.ADD;

362: Open cur_rowid;
363: Fetch cur_rowid INTO lv_rowid;
364: IF (cur_rowid%FOUND) THEN
365: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PIT_INS_FK');
366: IGS_GE_MSG_STACK.ADD;
367: Close cur_rowid;
368: App_Exception.Raise_Exception;
369: Return;
370: END IF;

Line 450: IGS_GE_MSG_STACK.ADD;

446: p_deleting => FALSE);
447: IF Get_PK_For_Validation (
448: new_references.person_id_type ) THEN
449: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END IF;
453:
454: Check_Constraints; -- if procedure present

Line 469: IGS_GE_MSG_STACK.ADD;

465: ELSIF (p_action = 'VALIDATE_INSERT') THEN
466: IF Get_PK_For_Validation (
467: new_references.person_id_type ) THEN
468: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471: END IF;
472:
473: Check_Constraints; -- if procedure present

Line 555: IGS_GE_MSG_STACK.ADD;

551: X_LAST_UPDATE_LOGIN := -1;
552: end if;
553: else
554: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
555: IGS_GE_MSG_STACK.ADD;
556: app_exception.raise_exception;
557: end if;
558: Before_DML(
559: p_action=>'INSERT',

Line 657: IGS_GE_MSG_STACK.ADD;

653: open c1;
654: fetch c1 into tlinfo;
655: if (c1%notfound) then
656: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
657: IGS_GE_MSG_STACK.ADD;
658: close c1;
659: app_exception.raise_exception;
660: return;
661: end if;

Line 690: IGS_GE_MSG_STACK.ADD;

686: )then
687: null;
688: else
689: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
690: IGS_GE_MSG_STACK.ADD;
691: app_exception.raise_exception;
692: end if;
693: return;
694: end LOCK_ROW;

Line 739: IGS_GE_MSG_STACK.ADD;

735: X_LAST_UPDATE_LOGIN := -1;
736: end if;
737: else
738: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
739: IGS_GE_MSG_STACK.ADD;
740: app_exception.raise_exception;
741: end if;
742: Before_DML(
743: p_action=>'UPDATE',