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 FND_MESSAGE

Line 71: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

67: -- Populate Old Values.
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;

Line 171: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PID_MASK');

167: CLOSE format_mask_cur;
168:
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;

Line 172: FND_MESSAGE.SET_TOKEN('FORMAT',format_mask_rec.format_mask);

168:
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;

Line 189: Fnd_Message.Set_Name('IGS', v_message_name);

185: IF IGS_EN_VAL_PAL.enrp_val_api_end_dt (
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:

Line 200: FND_MESSAGE.SET_NAME('IGS', v_message_name);

196: IF igs_ad_val_edtl.genp_val_strt_end_dt (
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;

Line 212: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_STRT_DT_LESS_BIRTH_DT');

208: CLOSE birth_date_cur;
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;

Line 223: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_ALT_END_DT_VAL');

219:
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:

Line 290: Fnd_Message.Set_Name('IGS', v_message_name);

286: IF IGS_EN_VAL_API.enrp_val_api_pan (
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

Line 302: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERS_ID_PRD_OVRLP');

298:
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

Line 308: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SSN_PERS_ID_PRD_OVRLP');

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
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;

Line 369: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_UNIQUE_PID');

365: Open cptu;
366: FETCH cptu INTO l_person_number;
367: IF (cptu%FOUND) THEN
368: Close cptu;
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;

Line 370: FND_MESSAGE.SET_TOKEN ('PREF_ALTERNATE_ID1', new_references.person_id_type);

366: FETCH cptu INTO l_person_number;
367: IF (cptu%FOUND) THEN
368: Close cptu;
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;

Line 371: FND_MESSAGE.SET_TOKEN ('PREF_ALTERNATE_ID2', new_references.person_id_type);

367: IF (cptu%FOUND) THEN
368: Close cptu;
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;

Line 372: FND_MESSAGE.SET_TOKEN ('PERSON_NUMBER', l_person_number);

368: Close cptu;
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;

Line 398: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

394:
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;

Line 408: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

404: IF upper(column_name) = 'PERSON_ID_TYPE' OR
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;

Line 423: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

419: NULL;
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;

Line 434: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

430: NULL;
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;

Line 491: Fnd_Message.Set_Name ('IGS', 'IGS_PE_API_PE_FK');

487: BEGIN
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;

Line 589: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_ALT_DUP_EXISTS');

585: new_references.api_person_id ,
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:

Line 627: Fnd_Message.Set_Name ('IGS', 'IGS_PE_ALT_DUP_EXISTS');

623: new_references.api_person_id ,
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:

Line 746: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

742: else
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(

Line 886: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

882: );
883: EXCEPTION
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;

Line 887: fnd_message.set_token ('ERR_CD', SQLCODE);

883: EXCEPTION
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

Line 963: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

959: begin
960: open c1;
961: fetch c1 into tlinfo;
962: if (c1%notfound) then
963: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
964:
965: close c1;
966: App_Exception.Raise_Exception;
967: return;

Line 1003: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

999:
1000: ) then
1001: null;
1002: else
1003: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1004: app_exception.raise_exception;
1005: end if;
1006: return;
1007: end LOCK_ROW;

Line 1062: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

1058: if X_LAST_UPDATE_LOGIN is NULL then
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(

Line 1159: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1155:
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;

Line 1175: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

1171: );
1172: EXCEPTION
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;

Line 1176: fnd_message.set_token ('ERR_CD', SQLCODE);

1172: EXCEPTION
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

Line 1310: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1306: END IF;
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;