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

Line 72: IGS_GE_MSG_STACK.ADD;

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

Line 173: IGS_GE_MSG_STACK.ADD;

169: IF format_mask_rec.format_mask IS NOT NULL THEN
170: IF NOT igs_en_val_api.fm_equal(new_references.api_person_id, format_mask_rec.format_mask) THEN
171: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PID_MASK');
172: FND_MESSAGE.SET_TOKEN('FORMAT',format_mask_rec.format_mask);
173: IGS_GE_MSG_STACK.ADD;
174: APP_EXCEPTION.RAISE_EXCEPTION;
175: END IF;
176: END IF;
177:

Line 190: IGS_GE_MSG_STACK.ADD;

186: new_references.start_dt,
187: new_references.end_dt,
188: v_message_name) = FALSE THEN
189: Fnd_Message.Set_Name('IGS', v_message_name);
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193:
194: -- Validate that if both are specified, then end is not greater than start.

Line 201: IGS_GE_MSG_STACK.ADD;

197: new_references.start_dt,
198: new_references.end_dt,
199: v_message_name) = FALSE THEN
200: FND_MESSAGE.SET_NAME('IGS', v_message_name);
201: IGS_GE_MSG_STACK.ADD;
202: APP_EXCEPTION.RAISE_EXCEPTION;
203: END IF;
204: END IF;
205:

Line 213: IGS_GE_MSG_STACK.ADD;

209:
210: IF birth_date_rec.birth_date IS NOT NULL THEN
211: IF new_references.start_dt < birth_date_rec.birth_date THEN
212: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_STRT_DT_LESS_BIRTH_DT');
213: IGS_GE_MSG_STACK.ADD;
214: APP_EXCEPTION.RAISE_EXCEPTION;
215: END IF;
216: END IF;
217:

Line 224: IGS_GE_MSG_STACK.ADD;

220: IF (old_references.end_dt IS NOT NULL) AND
221: (trunc(new_references.end_dt) <> trunc(old_references.end_dt)) AND
222: (trunc(old_references.end_dt) = trunc(old_references.start_dt) ) THEN
223: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_ALT_END_DT_VAL');
224: IGS_GE_MSG_STACK.ADD;
225: APP_EXCEPTION.RAISE_EXCEPTION;
226: END IF;
227:
228: END BeforeRowInsertUpdate1;

Line 291: IGS_GE_MSG_STACK.ADD;

287: new_references.pe_person_id,
288: new_references.api_person_id,
289: v_message_name) = FALSE THEN
290: Fnd_Message.Set_Name('IGS', v_message_name);
291: IGS_GE_MSG_STACK.ADD;
292: APP_EXCEPTION.RAISE_EXCEPTION;
293: END IF;
294: ELSE
295: CLOSE c_pit;

Line 303: IGS_GE_MSG_STACK.ADD;

299:
300: IF l_s_person_id_type <> 'SSN' THEN
301: IF NOT igs_en_val_api.val_overlap_api(new_references.pe_person_id) THEN
302: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERS_ID_PRD_OVRLP');
303: IGS_GE_MSG_STACK.ADD;
304: APP_EXCEPTION.RAISE_EXCEPTION;
305: END IF;
306: ELSE
307: IF NOT igs_en_val_api.val_ssn_overlap_api(new_references.pe_person_id) THEN

Line 309: IGS_GE_MSG_STACK.ADD;

305: END IF;
306: ELSE
307: IF NOT igs_en_val_api.val_ssn_overlap_api(new_references.pe_person_id) THEN
308: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SSN_PERS_ID_PRD_OVRLP');
309: IGS_GE_MSG_STACK.ADD;
310: APP_EXCEPTION.RAISE_EXCEPTION;
311: END IF;
312: END IF;
313: END IF;

Line 373: IGS_GE_MSG_STACK.ADD;

369: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_UNIQUE_PID');
370: FND_MESSAGE.SET_TOKEN ('PREF_ALTERNATE_ID1', new_references.person_id_type);
371: FND_MESSAGE.SET_TOKEN ('PREF_ALTERNATE_ID2', new_references.person_id_type);
372: FND_MESSAGE.SET_TOKEN ('PERSON_NUMBER', l_person_number);
373: IGS_GE_MSG_STACK.ADD;
374: APP_EXCEPTION.RAISE_EXCEPTION;
375: END IF;
376: Close cptu;
377: END IF;

Line 399: IGS_GE_MSG_STACK.ADD;

395: IF upper(column_name) = 'API_PERSON_ID' OR
396: column_name is null Then
397: IF new_references.api_person_id <> UPPER(new_references.api_person_id) Then
398: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
399: IGS_GE_MSG_STACK.ADD;
400: App_Exception.Raise_Exception;
401: END IF;
402: END IF;
403:

Line 409: IGS_GE_MSG_STACK.ADD;

405: column_name is null Then
406: IF new_references.person_id_type <>
407: UPPER(new_references.person_id_type ) Then
408: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
409: IGS_GE_MSG_STACK.ADD;
410: App_Exception.Raise_Exception;
411: END IF;
412: END IF;
413: END Check_Constraints;

Line 424: IGS_GE_MSG_STACK.ADD;

420: ELSE
421: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
422: new_references.pe_person_id ) THEN
423: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
424: IGS_GE_MSG_STACK.ADD;
425: App_Exception.Raise_Exception;
426: END IF;
427: END IF;
428: IF (((old_references.person_id_type = new_references.person_id_type)) OR

Line 435: IGS_GE_MSG_STACK.ADD;

431: ELSE
432: IF NOT IGS_PE_PERSON_ID_TYP_PKG.Get_PID_Type_Validation (
433: new_references.person_id_type) THEN
434: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END IF;
438: END IF;
439: END Check_Parent_Existance;

Line 492: IGS_GE_MSG_STACK.ADD;

488: Open cur_rowid;
489: Fetch cur_rowid INTO lv_rowid;
490: IF (cur_rowid%FOUND) THEN
491: Fnd_Message.Set_Name ('IGS', 'IGS_PE_API_PE_FK');
492: IGS_GE_MSG_STACK.ADD;
493: Close cur_rowid;
494: App_Exception.Raise_Exception;
495: Return;
496: END IF;

Line 590: IGS_GE_MSG_STACK.ADD;

586: new_references.person_id_type,
587: new_references.start_dt )
588: THEN
589: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_ALT_DUP_EXISTS');
590: IGS_GE_MSG_STACK.ADD;
591: APP_EXCEPTION.RAISE_EXCEPTION;
592: END IF;
593:
594: Check_Constraints; -- if procedure present

Line 628: IGS_GE_MSG_STACK.ADD;

624: new_references.person_id_type,
625: new_references.start_dt
626: ) THEN
627: Fnd_Message.Set_Name ('IGS', 'IGS_PE_ALT_DUP_EXISTS');
628: IGS_GE_MSG_STACK.ADD;
629: App_Exception.Raise_Exception;
630: END IF;
631:
632: Check_Constraints; -- if procedure present

Line 747: IGS_GE_MSG_STACK.ADD;

743: X_PROGRAM_UPDATE_DATE := SYSDATE;
744: end if;
745: else
746: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
747: IGS_GE_MSG_STACK.ADD;
748: app_exception.raise_exception;
749: end if;
750: Before_DML(
751: p_action=>'INSERT',

Line 888: igs_ge_msg_stack.add;

884: WHEN OTHERS THEN
885: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
886: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
887: fnd_message.set_token ('ERR_CD', SQLCODE);
888: igs_ge_msg_stack.add;
889: igs_sc_gen_001.unset_ctx('R');
890: app_exception.raise_exception;
891: ELSE
892: igs_sc_gen_001.unset_ctx('R');

Line 1063: IGS_GE_MSG_STACK.ADD;

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

Line 1160: igs_ge_msg_stack.add;

1156: where ROWID = X_ROWID
1157: ;
1158: if (sql%notfound) then
1159: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1160: igs_ge_msg_stack.add;
1161: igs_sc_gen_001.unset_ctx('R');
1162: app_exception.raise_exception;
1163: end if;
1164: IF (x_mode = 'S') THEN

Line 1177: igs_ge_msg_stack.add;

1173: WHEN OTHERS THEN
1174: IF (SQLCODE = (-28115)) THEN
1175: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1176: fnd_message.set_token ('ERR_CD', SQLCODE);
1177: igs_ge_msg_stack.add;
1178: igs_sc_gen_001.unset_ctx('R');
1179: app_exception.raise_exception;
1180: ELSE
1181: igs_sc_gen_001.unset_ctx('R');

Line 1311: igs_ge_msg_stack.add;

1307: delete from IGS_PE_ALT_PERS_ID
1308: where ROWID = X_ROWID;
1309: if (sql%notfound) then
1310: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1311: igs_ge_msg_stack.add;
1312: igs_sc_gen_001.unset_ctx('R');
1313: app_exception.raise_exception;
1314: end if;
1315: IF (x_mode = 'S') THEN