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 APP_EXCEPTION

Line 74: App_Exception.Raise_Exception;

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;
77: Close cur_old_ref_values;
78: -- Populate New Values.

Line 174: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 191: App_Exception.Raise_Exception;

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.
195: IF (new_references.end_dt IS NOT NULL) THEN

Line 202: APP_EXCEPTION.RAISE_EXCEPTION;

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:
206: OPEN birth_date_cur(new_references.pe_person_id);

Line 214: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 225: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 292: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 304: APP_EXCEPTION.RAISE_EXCEPTION;

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
308: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SSN_PERS_ID_PRD_OVRLP');

Line 310: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 374: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 400: App_Exception.Raise_Exception;

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

Line 410: App_Exception.Raise_Exception;

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

Line 425: App_Exception.Raise_Exception;

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
429: ((new_references.person_id_type IS NULL))) THEN

Line 436: App_Exception.Raise_Exception;

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

Line 494: App_Exception.Raise_Exception;

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;
497: Close cur_rowid;
498: END GET_FK_IGS_PE_PERSON;

Line 591: APP_EXCEPTION.RAISE_EXCEPTION;

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
595: Check_Parent_Existance; -- if procedure present

Line 629: App_Exception.Raise_Exception;

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
633: BeforeInsert;

Line 748: app_exception.raise_exception;

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',
752: x_rowid=>X_ROWID,

Line 890: app_exception.raise_exception;

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');
893: RAISE;
894: END IF;

Line 966: App_Exception.Raise_Exception;

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;
968: end if;
969: close c1;
970:

Line 1004: app_exception.raise_exception;

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;
1008: procedure UPDATE_ROW (

Line 1064: app_exception.raise_exception;

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',
1068: x_rowid=>X_ROWID,

Line 1162: app_exception.raise_exception;

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
1165: igs_sc_gen_001.unset_ctx('R');
1166: END IF;

Line 1179: app_exception.raise_exception;

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');
1182: RAISE;
1183: END IF;

Line 1313: app_exception.raise_exception;

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
1316: igs_sc_gen_001.unset_ctx('R');
1317: END IF;