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

Line 55: App_Exception.Raise_Exception;

51: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: Close cur_old_ref_values;
55: App_Exception.Raise_Exception;
56: Return;
57: END IF;
58: Close cur_old_ref_values;
59:

Line 112: App_Exception.Raise_Exception;

108: (p_updating AND
109: new_references.allow_stnd_req_ind <> old_references.allow_stnd_req_ind) THEN
110: Fnd_Message.Set_Name('IGS', 'IGS_AV_INSUFICIENT_PRIV');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114:
115:
116:

Line 164: App_Exception.Raise_Exception;

160: column_name is null Then
161: IF new_references.adm_acad_cal_type <>UPPER(new_references.adm_acad_cal_type )Then
162: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: END IF;
167:
168: IF upper(column_name) = 'ADM_ADMISSION_CAT' OR

Line 173: App_Exception.Raise_Exception;

169: column_name is null Then
170: IF new_references.adm_admission_cat <>UPPER(new_references.adm_admission_cat)Then
171: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176: IF upper(column_name) = 'ADM_ADM_CAL_TYPE' OR
177: column_name is null Then

Line 181: App_Exception.Raise_Exception;

177: column_name is null Then
178: IF new_references.adm_adm_cal_type <>UPPER(new_references.adm_adm_cal_type ) Then
179: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184: IF upper(column_name) = 'ADM_S_ADMISSION_PROCESS_TYPE' OR
185: column_name is null Then

Line 189: App_Exception.Raise_Exception;

185: column_name is null Then
186: IF new_references.adm_s_admission_process_type <>UPPER(new_references.adm_s_admission_process_type) 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: IF upper(column_name) = 'ENR_ACAD_CAL_TYPE' OR
193: column_name is null Then

Line 197: App_Exception.Raise_Exception;

193: column_name is null Then
194: IF new_references.enr_acad_cal_type <>UPPER(new_references.enr_acad_cal_type)Then
195: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199: END IF;
200: IF upper(column_name) = 'ENR_ENROLMENT_CAT' OR
201: column_name is null Then

Line 205: App_Exception.Raise_Exception;

201: column_name is null Then
202: IF new_references.enr_enrolment_cat <>UPPER(new_references.enr_enrolment_cat ) Then
203: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: END IF;
208: IF upper(column_name) = 'ENR_ENR_METHOD_TYPE' OR
209: column_name is null Then

Line 213: App_Exception.Raise_Exception;

209: column_name is null Then
210: IF new_references.enr_enr_method_type <>UPPER(new_references.enr_enr_method_type) Then
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215: END IF;
216: IF upper(column_name) = 'ADM_ADM_CI_SEQUENCE_NUMBER' OR
217: column_name is null Then

Line 221: App_Exception.Raise_Exception;

217: column_name is null Then
218: IF new_references.adm_adm_ci_sequence_number < 0 OR new_references.adm_adm_ci_sequence_number > 999999 Then
219: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: END IF;
223: END IF;
224: IF upper(column_name) = 'ALLOW_STND_REQ_IND' OR
225: column_name is null Then

Line 229: App_Exception.Raise_Exception;

225: column_name is null Then
226: IF new_references.allow_stnd_req_ind NOT IN ( 'Y' , 'N' ) Then
227: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
228: IGS_GE_MSG_STACK.ADD;
229: App_Exception.Raise_Exception;
230: END IF;
231: END IF;
232: IF upper(column_name) = 'ADM_ACAD_CI_SEQUENCE_NUMBER' OR
233: column_name is null Then

Line 237: App_Exception.Raise_Exception;

233: column_name is null Then
234: IF new_references.adm_acad_ci_sequence_number < 0 OR new_references.adm_acad_ci_sequence_number > 999999 Then
235: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: END IF;
239: END IF;
240: IF upper(column_name) = 'ENR_ACAD_SEQUENCE_NUMBER' OR
241: column_name is null Then

Line 245: App_Exception.Raise_Exception;

241: column_name is null Then
242: IF new_references.enr_acad_sequence_number < 0 OR new_references.enr_acad_sequence_number > 999999 Then
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
248: IF upper(column_name) = 'ENR_ACAD_CI_SEQUENCE_NUMBER' OR
249: column_name is null Then

Line 253: App_Exception.Raise_Exception;

249: column_name is null Then
250: IF new_references.enq_acad_ci_sequence_number < 0 OR new_references.enq_acad_ci_sequence_number > 999999 Then
251: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
252: IGS_GE_MSG_STACK.ADD;
253: App_Exception.Raise_Exception;
254: END IF;
255: END IF;
256: IF upper(column_name) = 'ENQ_ADM_CI_SEQUENCE_NUMBER' OR
257: column_name is null Then

Line 261: App_Exception.Raise_Exception;

257: column_name is null Then
258: IF new_references.enq_adm_ci_sequence_number < 0 OR new_references.enq_adm_ci_sequence_number > 999999 Then
259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
264:
265: END Check_Constraints;

Line 281: App_Exception.Raise_Exception;

277: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
278: new_references.person_id) THEN
279: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: END IF;
284:
285: END Check_Parent_Existance;

Line 333: App_Exception.Raise_Exception;

329: IF (cur_rowid%FOUND) THEN
330: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PP_PE_FK');
331: IGS_GE_MSG_STACK.ADD;
332: Close cur_rowid;
333: App_Exception.Raise_Exception;
334: Return;
335: END IF;
336: Close cur_rowid;
337:

Line 404: App_Exception.Raise_Exception;

400: IF Get_PK_For_Validation (
401: new_references.person_id ) THEN
402: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
403: IGS_GE_MSG_STACK.ADD;
404: App_Exception.Raise_Exception;
405: END IF;
406:
407: Check_Constraints; -- if procedure present
408: -- Check_Parent_Existance; for Oracle username issue

Line 425: App_Exception.Raise_Exception;

421: IF Get_PK_For_Validation (
422: new_references.person_id ) THEN
423: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
424: IGS_GE_MSG_STACK.ADD;
425: App_Exception.Raise_Exception;
426: END IF;
427:
428: Check_Constraints; -- if procedure present
429: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 504: app_exception.raise_exception;

500: end if;
501: else
502: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506: Before_DML(
507: p_action=>'INSERT',
508: x_rowid=>X_ROWID,

Line 645: App_Exception.Raise_Exception;

641: if (c1%notfound) then
642: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
643:
644: close c1;
645: App_Exception.Raise_Exception;
646: return;
647: end if;
648: close c1;
649:

Line 700: app_exception.raise_exception;

696: ) then
697: null;
698: else
699: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
700: app_exception.raise_exception;
701: end if;
702: return;
703: end LOCK_ROW;
704:

Line 746: app_exception.raise_exception;

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