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

Line 63: App_Exception.Raise_Exception;

59: Fetch cur_old_ref_values INTO old_references;
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: App_Exception.Raise_Exception;
64: Close cur_old_ref_values;
65: Return;
66: END IF;
67: Close cur_old_ref_values;

Line 128: APP_EXCEPTION.RAISE_EXCEPTION;

124: new_references.submission_number
125: )THEN
126: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
127: IGS_GE_MSG_STACK.ADD;
128: APP_EXCEPTION.RAISE_EXCEPTION;
129: END IF;
130: END IF;
131:
132: END Check_Parent_Existance;

Line 189: App_Exception.Raise_Exception;

185: IF (cur_rowid%FOUND) THEN
186: Close cur_rowid;
187: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSCH_GSC_FK');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: Return;
191: END IF;
192: Close cur_rowid;
193:

Line 245: APP_EXCEPTION.RAISE_EXCEPTION;

241: IF upper(column_name) = 'CHANGED_UPDATE_WHO' OR column_name IS NULL THEN
242: IF new_references.changed_update_who <> UPPER(new_references.changed_update_who) 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) = 'CITIZENSHIP_CD' OR column_name IS NULL THEN
249: IF new_references.citizenship_cd <> UPPER(new_references.citizenship_cd) THEN

Line 252: APP_EXCEPTION.RAISE_EXCEPTION;

248: IF upper(column_name) = 'CITIZENSHIP_CD' OR column_name IS NULL THEN
249: IF new_references.citizenship_cd <> UPPER(new_references.citizenship_cd) THEN
250: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
251: IGS_GE_MSG_STACK.ADD;
252: APP_EXCEPTION.RAISE_EXCEPTION;
253: END IF;
254: END IF;
255: IF upper(column_name) = 'COURSE_CD' OR column_name IS NULL THEN
256: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN

Line 259: APP_EXCEPTION.RAISE_EXCEPTION;

255: IF upper(column_name) = 'COURSE_CD' OR column_name IS NULL THEN
256: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
257: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
258: IGS_GE_MSG_STACK.ADD;
259: APP_EXCEPTION.RAISE_EXCEPTION;
260: END IF;
261: END IF;
262: IF upper(column_name) = 'DIFFERENTIAL_HECS_IND' OR column_name IS NULL THEN
263: IF new_references.differential_hecs_ind <> UPPER(new_references.differential_hecs_ind) THEN

Line 266: APP_EXCEPTION.RAISE_EXCEPTION;

262: IF upper(column_name) = 'DIFFERENTIAL_HECS_IND' OR column_name IS NULL THEN
263: IF new_references.differential_hecs_ind <> UPPER(new_references.differential_hecs_ind) THEN
264: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
265: IGS_GE_MSG_STACK.ADD;
266: APP_EXCEPTION.RAISE_EXCEPTION;
267: END IF;
268: END IF;
269: IF upper(column_name) = 'HECS_PAYMENT_OPTION' OR column_name IS NULL THEN
270: IF new_references.hecs_payment_option <> UPPER(new_references.hecs_payment_option) THEN

Line 273: APP_EXCEPTION.RAISE_EXCEPTION;

269: IF upper(column_name) = 'HECS_PAYMENT_OPTION' OR column_name IS NULL THEN
270: IF new_references.hecs_payment_option <> UPPER(new_references.hecs_payment_option) THEN
271: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
272: IGS_GE_MSG_STACK.ADD;
273: APP_EXCEPTION.RAISE_EXCEPTION;
274: END IF;
275: END IF;
276: IF upper(column_name) = 'OLD_CITIZENSHIP_CD' OR column_name IS NULL THEN
277: IF new_references.old_citizenship_cd <> UPPER(new_references.old_citizenship_cd) THEN

Line 280: APP_EXCEPTION.RAISE_EXCEPTION;

276: IF upper(column_name) = 'OLD_CITIZENSHIP_CD' OR column_name IS NULL THEN
277: IF new_references.old_citizenship_cd <> UPPER(new_references.old_citizenship_cd) THEN
278: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
279: IGS_GE_MSG_STACK.ADD;
280: APP_EXCEPTION.RAISE_EXCEPTION;
281: END IF;
282: END IF;
283: IF upper(column_name) = 'OLD_DIFFERENTIAL_HECS_IND' OR column_name IS NULL THEN
284: IF new_references.old_differential_hecs_ind <> UPPER(new_references.old_differential_hecs_ind) THEN

Line 287: APP_EXCEPTION.RAISE_EXCEPTION;

283: IF upper(column_name) = 'OLD_DIFFERENTIAL_HECS_IND' OR column_name IS NULL THEN
284: IF new_references.old_differential_hecs_ind <> UPPER(new_references.old_differential_hecs_ind) THEN
285: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
286: IGS_GE_MSG_STACK.ADD;
287: APP_EXCEPTION.RAISE_EXCEPTION;
288: END IF;
289: END IF;
290: IF upper(column_name) = 'OLD_HECS_PAYMENT_OPTION' OR column_name IS NULL THEN
291: IF new_references.old_hecs_payment_option <> UPPER(new_references.old_hecs_payment_option) THEN

Line 294: APP_EXCEPTION.RAISE_EXCEPTION;

290: IF upper(column_name) = 'OLD_HECS_PAYMENT_OPTION' OR column_name IS NULL THEN
291: IF new_references.old_hecs_payment_option <> UPPER(new_references.old_hecs_payment_option) THEN
292: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
293: IGS_GE_MSG_STACK.ADD;
294: APP_EXCEPTION.RAISE_EXCEPTION;
295: END IF;
296: END IF;
297: IF upper(column_name) = 'OLD_PERM_RESIDENT_CD' OR column_name IS NULL THEN
298: IF new_references.old_perm_resident_cd <> UPPER(new_references.old_perm_resident_cd) THEN

Line 301: APP_EXCEPTION.RAISE_EXCEPTION;

297: IF upper(column_name) = 'OLD_PERM_RESIDENT_CD' OR column_name IS NULL THEN
298: IF new_references.old_perm_resident_cd <> UPPER(new_references.old_perm_resident_cd) THEN
299: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
300: IGS_GE_MSG_STACK.ADD;
301: APP_EXCEPTION.RAISE_EXCEPTION;
302: END IF;
303: END IF;
304: IF upper(column_name) = 'OLD_PRIOR_DEGREE' OR column_name IS NULL THEN
305: IF new_references.old_prior_degree <> UPPER(new_references.old_prior_degree) THEN

Line 308: APP_EXCEPTION.RAISE_EXCEPTION;

304: IF upper(column_name) = 'OLD_PRIOR_DEGREE' OR column_name IS NULL THEN
305: IF new_references.old_prior_degree <> UPPER(new_references.old_prior_degree) THEN
306: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
307: IGS_GE_MSG_STACK.ADD;
308: APP_EXCEPTION.RAISE_EXCEPTION;
309: END IF;
310: END IF;
311: IF upper(column_name) = 'OLD_PRIOR_POST_GRAD' OR column_name IS NULL THEN
312: IF new_references.old_prior_post_grad <> UPPER(new_references.old_prior_post_grad) THEN

Line 315: APP_EXCEPTION.RAISE_EXCEPTION;

311: IF upper(column_name) = 'OLD_PRIOR_POST_GRAD' OR column_name IS NULL THEN
312: IF new_references.old_prior_post_grad <> UPPER(new_references.old_prior_post_grad) THEN
313: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
314: IGS_GE_MSG_STACK.ADD;
315: APP_EXCEPTION.RAISE_EXCEPTION;
316: END IF;
317: END IF;
318: IF upper(column_name) = 'OLD_UNIT_CD' OR column_name IS NULL THEN
319: IF new_references.old_unit_cd <> UPPER(new_references.old_unit_cd) THEN

Line 322: APP_EXCEPTION.RAISE_EXCEPTION;

318: IF upper(column_name) = 'OLD_UNIT_CD' OR column_name IS NULL THEN
319: IF new_references.old_unit_cd <> UPPER(new_references.old_unit_cd) THEN
320: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
321: IGS_GE_MSG_STACK.ADD;
322: APP_EXCEPTION.RAISE_EXCEPTION;
323: END IF;
324: END IF;
325: IF upper(column_name) = 'PERM_RESIDENT_CD' OR column_name IS NULL THEN
326: IF new_references.perm_resident_cd <> UPPER(new_references.perm_resident_cd) THEN

Line 329: APP_EXCEPTION.RAISE_EXCEPTION;

325: IF upper(column_name) = 'PERM_RESIDENT_CD' OR column_name IS NULL THEN
326: IF new_references.perm_resident_cd <> UPPER(new_references.perm_resident_cd) THEN
327: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
328: IGS_GE_MSG_STACK.ADD;
329: APP_EXCEPTION.RAISE_EXCEPTION;
330: END IF;
331: END IF;
332: IF upper(column_name) = 'PRIOR_DEGREE' OR column_name IS NULL THEN
333: IF new_references.prior_degree <> UPPER(new_references.prior_degree) THEN

Line 336: APP_EXCEPTION.RAISE_EXCEPTION;

332: IF upper(column_name) = 'PRIOR_DEGREE' OR column_name IS NULL THEN
333: IF new_references.prior_degree <> UPPER(new_references.prior_degree) THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
335: IGS_GE_MSG_STACK.ADD;
336: APP_EXCEPTION.RAISE_EXCEPTION;
337: END IF;
338: END IF;
339: IF upper(column_name) = 'PRIOR_POST_GRAD' OR column_name IS NULL THEN
340: IF new_references.prior_post_grad <> UPPER(new_references.prior_post_grad) THEN

Line 343: APP_EXCEPTION.RAISE_EXCEPTION;

339: IF upper(column_name) = 'PRIOR_POST_GRAD' OR column_name IS NULL THEN
340: IF new_references.prior_post_grad <> UPPER(new_references.prior_post_grad) THEN
341: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
342: IGS_GE_MSG_STACK.ADD;
343: APP_EXCEPTION.RAISE_EXCEPTION;
344: END IF;
345: END IF;
346: IF upper(column_name) = 'REPORTED_IND' OR column_name IS NULL THEN
347: IF new_references.reported_ind <> UPPER(new_references.reported_ind) THEN

Line 350: APP_EXCEPTION.RAISE_EXCEPTION;

346: IF upper(column_name) = 'REPORTED_IND' OR column_name IS NULL THEN
347: IF new_references.reported_ind <> UPPER(new_references.reported_ind) THEN
348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
349: IGS_GE_MSG_STACK.ADD;
350: APP_EXCEPTION.RAISE_EXCEPTION;
351: END IF;
352: END IF;
353: IF upper(column_name) = 'UNIT_CD' OR column_name IS NULL THEN
354: IF new_references.unit_cd <> UPPER(new_references.unit_cd) THEN

Line 357: APP_EXCEPTION.RAISE_EXCEPTION;

353: IF upper(column_name) = 'UNIT_CD' OR column_name IS NULL THEN
354: IF new_references.unit_cd <> UPPER(new_references.unit_cd) THEN
355: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
356: IGS_GE_MSG_STACK.ADD;
357: APP_EXCEPTION.RAISE_EXCEPTION;
358: END IF;
359: END IF;
360:
361: END CHECK_CONSTRAINTS;

Line 457: APP_EXCEPTION.RAISE_EXCEPTION;

453: new_references.sequence_number
454: )THEN
455: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
456: IGS_GE_MSG_STACK.ADD;
457: APP_EXCEPTION.RAISE_EXCEPTION;
458: END IF;
459: Check_Constraints;
460: Check_Parent_Existance;
461: ELSIF (p_action = 'UPDATE') THEN

Line 480: APP_EXCEPTION.RAISE_EXCEPTION;

476: new_references.sequence_number
477: )THEN
478: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
479: IGS_GE_MSG_STACK.ADD;
480: APP_EXCEPTION.RAISE_EXCEPTION;
481: END IF;
482: Check_Constraints;
483: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
484: -- Call all the procedures related to Before Delete.

Line 580: app_exception.raise_exception;

576: end if;
577: else
578: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
579: IGS_GE_MSG_STACK.ADD;
580: app_exception.raise_exception;
581: end if;
582:
583: Before_DML (
584: p_action => 'INSERT',

Line 787: app_exception.raise_exception;

783: fetch c1 into tlinfo;
784: if (c1%notfound) then
785: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
786: IGS_GE_MSG_STACK.ADD;
787: app_exception.raise_exception;
788: close c1;
789: return;
790: end if;
791: close c1;

Line 869: app_exception.raise_exception;

865: null;
866: else
867: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
868: IGS_GE_MSG_STACK.ADD;
869: app_exception.raise_exception;
870: end if;
871: return;
872: end LOCK_ROW;
873:

Line 932: app_exception.raise_exception;

928: end if;
929: else
930: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
931: IGS_GE_MSG_STACK.ADD;
932: app_exception.raise_exception;
933: end if;
934: Before_DML (
935: p_action => 'UPDATE',
936: x_rowid => X_ROWID,