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_ALIAS_PKG dependencies on APP_EXCEPTION

Line 64: App_Exception.Raise_Exception;

60: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
61: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
62: IGS_GE_MSG_STACK.ADD;
63: Close cur_old_ref_values;
64: App_Exception.Raise_Exception;
65: Return;
66: END IF;
67: Close cur_old_ref_values;
68:

Line 119: App_Exception.Raise_Exception;

115: new_references.end_dt,
116: v_message_name) = FALSE THEN
117: Fnd_Message.Set_Name('IGS', v_message_name);
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END IF;
122: -- Validate that if both are specified, then end is not greater than start.
123: IF (new_references.end_dt IS NOT NULL) AND

Line 132: App_Exception.Raise_Exception;

128: new_references.end_dt,
129: v_message_name) = FALSE THEN
130: Fnd_Message.Set_Name('IGS', v_message_name);
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135: -- Prevent the start date being set to null if the end date is specified.
136: IF p_updating AND (new_references.start_dt IS NULL AND new_references.end_dt IS NOT NULL) THEN

Line 139: App_Exception.Raise_Exception;

135: -- Prevent the start date being set to null if the end date is specified.
136: IF p_updating AND (new_references.start_dt IS NULL AND new_references.end_dt IS NOT NULL) THEN
137: Fnd_Message.Set_Name('IGS', 'IGS_EN_CANT_REMOVE_ST_DATE');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: -- Validate Surname and Given Names.
142: IF (p_inserting OR p_updating) THEN
143: IF IGS_EN_VAL_PAL.enrp_val_pal_names (

Line 149: App_Exception.Raise_Exception;

145: new_references.given_names,
146: v_message_name) = FALSE THEN
147: Fnd_Message.Set_Name('IGS', v_message_name);
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151: -- Validate that if both are specified, then the Effective start date must not be earlier than the person's year of birth.
152: OPEN get_dob_dt_cur(new_references.person_id);
153: FETCH get_dob_dt_cur INTO l_birth_dt;

Line 159: APP_EXCEPTION.RAISE_EXCEPTION;

155: IF l_birth_dt IS NOT NULL AND new_references.start_dt IS NOT NULL THEN
156: IF l_birth_dt > new_references.start_dt THEN
157: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_STDT_NOTLESS_BIRTHDT');
158: IGS_GE_MSG_STACK.ADD;
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: END IF;
161: END IF;
162: END IF;
163:

Line 174: App_Exception.Raise_Exception;

170: new_references.title,
171: v_message_name) = FALSE THEN
172: Fnd_Message.Set_Name('IGS', v_message_name);
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
177: */
178: END IF;

Line 202: App_Exception.Raise_Exception;

198: IF new_references.given_names <>
199: UPPER(new_references.given_names) Then
200: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: END IF;
204: END IF;
205: IF upper(column_name) = 'SURNAME' OR
206: column_name is null Then

Line 211: App_Exception.Raise_Exception;

207: IF new_references.surname<>
208: UPPER(new_references.surname) Then
209: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213: END IF;
214:
215: END Check_Constraints;

Line 229: App_Exception.Raise_Exception;

225: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
226: new_references.person_id ) THEN
227: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
228: IGS_GE_MSG_STACK.ADD;
229: App_Exception.Raise_Exception;
230: END IF;
231: END IF;
232:
233: END Check_Parent_Existance;

Line 282: App_Exception.Raise_Exception;

278: IF (cur_rowid%FOUND) THEN
279: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PAL_PE_FK');
280: IGS_GE_MSG_STACK.ADD;
281: Close cur_rowid;
282: App_Exception.Raise_Exception;
283: Return;
284: END IF;
285: Close cur_rowid;
286:

Line 336: App_Exception.Raise_Exception;

332: new_references.person_id ,
333: new_references.sequence_number) THEN
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338:
339: Check_Parent_Existance; -- if procedure present
340: ELSIF (p_action = 'UPDATE') THEN

Line 356: App_Exception.Raise_Exception;

352: new_references.person_id ,
353: new_references.sequence_number) THEN
354: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
355: IGS_GE_MSG_STACK.ADD;
356: App_Exception.Raise_Exception;
357: END IF;
358:
359: END IF;
360:

Line 420: app_exception.raise_exception;

416: end if;
417: else
418: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422:
423: Before_DML(
424: p_action=>'INSERT',

Line 500: app_exception.raise_exception;

496: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
497: fnd_message.set_token ('ERR_CD', SQLCODE);
498: igs_ge_msg_stack.add;
499: igs_sc_gen_001.unset_ctx('R');
500: app_exception.raise_exception;
501: ELSE
502: igs_sc_gen_001.unset_ctx('R');
503: RAISE;
504: END IF;

Line 539: App_Exception.Raise_Exception;

535: if (c1%notfound) then
536: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
537:
538: close c1;
539: App_Exception.Raise_Exception;
540: return;
541: end if;
542: close c1;
543:

Line 566: app_exception.raise_exception;

562: ) then
563: null;
564: else
565: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
566: app_exception.raise_exception;
567: end if;
568: return;
569: end LOCK_ROW;
570:

Line 604: app_exception.raise_exception;

600: end if;
601: else
602: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
603: IGS_GE_MSG_STACK.ADD;
604: app_exception.raise_exception;
605: end if;
606: Before_DML(
607: p_action=>'UPDATE',
608: x_rowid=>X_ROWID,

Line 643: app_exception.raise_exception;

639: if (sql%notfound) then
640: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
641: igs_ge_msg_stack.add;
642: igs_sc_gen_001.unset_ctx('R');
643: app_exception.raise_exception;
644: end if;
645: IF (x_mode = 'S') THEN
646: igs_sc_gen_001.unset_ctx('R');
647: END IF;

Line 660: app_exception.raise_exception;

656: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
657: fnd_message.set_token ('ERR_CD', SQLCODE);
658: igs_ge_msg_stack.add;
659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: ELSE
662: igs_sc_gen_001.unset_ctx('R');
663: RAISE;
664: END IF;

Line 738: app_exception.raise_exception;

734: if (sql%notfound) then
735: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
736: igs_ge_msg_stack.add;
737: igs_sc_gen_001.unset_ctx('R');
738: app_exception.raise_exception;
739: end if;
740: IF (x_mode = 'S') THEN
741: igs_sc_gen_001.unset_ctx('R');
742: END IF;