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

Line 32: app_Exception.Raise_Exception;

28: CLOSE check_issuedate;
29: IF l_temp IS NOT NULL THEN
30: Fnd_Message.Set_Name('IGS','IGS_AD_DUP_DATE_OF_ISSUE');
31: IGS_GE_MSG_STACK.ADD;
32: app_Exception.Raise_Exception;
33: END IF;
34:
35: END check_uniqueness;
36:

Line 68: app_Exception.Raise_Exception;

64:
65: IF l_temp IS NOT NULL THEN
66: Fnd_Message.Set_Name('IGS','IGS_AD_INACTIVE_ACAD_HIST');
67: IGS_GE_MSG_STACK.ADD;
68: app_Exception.Raise_Exception;
69: END IF;
70:
71: END Check_Status;
72:

Line 141: App_Exception.Raise_Exception;

137: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
138: Close cur_old_ref_values;
139: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: Return;
143: END IF;
144: Close cur_old_ref_values;
145:

Line 239: App_Exception.Raise_Exception;

235: IF NOT ( (new_references.percentile_rank >= 0) AND (new_references.percentile_rank <= 100) ) THEN
236: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERCENTILE_RANK'));
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;
241: END IF;
242:
243: -- The following code checks for check constraints on the Columns.

Line 250: App_Exception.Raise_Exception;

246: IF NOT ( (new_references.quartile_rank >0) AND (new_references.quartile_rank <= 4) ) THEN
247: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
248: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_QUARTILE_RANK'));
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252: END IF;
253:
254: -- The following code checks for check constraints on the Columns.

Line 261: App_Exception.Raise_Exception;

257: IF NOT ( (new_references.quintile_rank > 0) AND (new_references.quintile_rank <= 5) ) THEN
258: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_QUINTILE_RANK'));
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
264:
265: -- The following code checks for check constraints on the Columns.

Line 272: App_Exception.Raise_Exception;

268: IF NOT ( (new_references.decile_rank > 0) AND (new_references.decile_rank <= 10) ) THEN
269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DECILE_RANK'));
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: END IF;
275:
276: -- The following code checks for check constraints on the Columns.

Line 283: App_Exception.Raise_Exception;

279: IF NOT (new_references.approximate_rank in ('Y','N')) THEN
280: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPROXIMATE_RANK'));
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: END IF;
286:
287: -- The following code checks for check constraints on the Columns.

Line 294: App_Exception.Raise_Exception;

290: IF NOT (new_references.weighted_rank in ('Y','N')) THEN
291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_WEIGHTED_RANK'));
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: END IF;
296: END IF;
297:
298: -- The following code checks for check constraints on the Columns.

Line 304: App_Exception.Raise_Exception;

300: Column_Name IS NULL THEN
301: IF NOT (new_references.rank_in_class > 0) THEN
302: FND_MESSAGE.SET_NAME('IGS','IGS_SS_DSRD_RANK_NONEGATE');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: END IF;
307:
308: -- The following code checks for check constraints on the Columns.

Line 314: App_Exception.Raise_Exception;

310: Column_Name IS NULL THEN
311: IF NOT (new_references.class_size > 0) THEN
312: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CLASS_SIZE');
313: IGS_GE_MSG_STACK.ADD;
314: App_Exception.Raise_Exception;
315: END IF;
316: END IF;
317:
318: IF Upper(Column_Name) = 'TRANSCRIPT_TYPE' OR

Line 324: App_Exception.Raise_Exception;

320: IF NOT (new_references.transcript_type in ('OFFICIAL','UNOFFICIAL')) THEN
321: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));
323: IGS_GE_MSG_STACK.ADD;
324: App_Exception.Raise_Exception;
325: END IF;
326: END IF;
327:
328: -- The following code checks for check constraints on the Columns.

Line 335: App_Exception.Raise_Exception;

331: IF NOT (new_references.override in ('Y','N')) THEN
332: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_OVERRIDE'));
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337: END IF;
338:
339: -- The following code checks for check constraints on the Columns.

Line 345: App_Exception.Raise_Exception;

341: Column_Name IS NULL THEN
342: IF (new_references.date_of_issue > SYSDATE ) THEN
343: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DATOFISSUE');
344: IGS_GE_MSG_STACK.ADD;
345: App_Exception.Raise_Exception;
346: END IF;
347: IF (new_references.date_of_issue > new_references.date_of_receipt ) THEN
348: Fnd_Message.Set_Name('IGS','IGS_AD_INV_DATOFISSUE');
349: IGS_GE_MSG_STACK.ADD;

Line 350: app_Exception.Raise_Exception;

346: END IF;
347: IF (new_references.date_of_issue > new_references.date_of_receipt ) THEN
348: Fnd_Message.Set_Name('IGS','IGS_AD_INV_DATOFISSUE');
349: IGS_GE_MSG_STACK.ADD;
350: app_Exception.Raise_Exception;
351: END IF;
352: END IF;
353: END Check_Constraints;
354:

Line 381: App_Exception.Raise_Exception;*/ -- not needed after TCA changes

377: new_references.education_id
378: ) THEN
379: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;*/ -- not needed after TCA changes
382: END IF;
383:
384: IF (((old_references.conv_gs_id = new_references.conv_gs_id)) OR
385: ((new_references.conv_gs_id IS NULL))) THEN

Line 395: App_Exception.Raise_Exception;

391: ) THEN
392: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CONV_GRAD_SCALE'));
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;
397:
398: IF (((old_references.transcript_source = new_references.transcript_source)) OR
399: ((new_references.transcript_source IS NULL))) THEN

Line 409: App_Exception.Raise_Exception;

405: ) THEN
406: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_SOURCE'));
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception;
410: END IF;
411:
412: IF (((old_references.entered_gs_id = new_references.entered_gs_id)) OR
413: ((new_references.entered_gs_id IS NULL))) THEN

Line 423: App_Exception.Raise_Exception;

419: ) THEN
420: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENTERED_GRAD_SCALE'));
422: IGS_GE_MSG_STACK.ADD;
423: App_Exception.Raise_Exception;
424: END IF;
425:
426: IF (((old_references.term_type = new_references.term_type)) OR
427: ((new_references.term_type IS NULL))) THEN

Line 436: App_Exception.Raise_Exception;

432: ) THEN
433: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_TYPE'));
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END IF;
438:
439: IF (((old_references.transcript_status = new_references.transcript_status)) OR
440: ((new_references.transcript_status IS NULL))) THEN

Line 449: App_Exception.Raise_Exception;

445: ) THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_STATUS'));
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;
451:
452:
453: IF (((old_references.transcript_type = new_references.transcript_type)) OR

Line 463: App_Exception.Raise_Exception;

459: ) THEN
460: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));
462: IGS_GE_MSG_STACK.ADD;
463: App_Exception.Raise_Exception;
464: END IF;
465:
466: END Check_Parent_Existance;
467:

Line 554: App_Exception.Raise_Exception;

550: IF (cur_rowid%FOUND) THEN
551: Close cur_rowid;
552: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_AAHST_FK');
553: IGS_GE_MSG_STACK.ADD;
554: App_Exception.Raise_Exception;
555: Return;
556: END IF;
557: Close cur_rowid;
558:

Line 606: App_Exception.Raise_Exception;

602: IF (cur_rowid%FOUND) THEN
603: Close cur_rowid;
604: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK1');
605: IGS_GE_MSG_STACK.ADD;
606: App_Exception.Raise_Exception;
607: Return;
608: END IF;
609: Close cur_rowid;
610: Open cur_rowid2;

Line 616: App_Exception.Raise_Exception;

612: IF (cur_rowid2%FOUND) THEN
613: Close cur_rowid2;
614: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK3');
615: IGS_GE_MSG_STACK.ADD;
616: App_Exception.Raise_Exception;
617: Return;
618: END IF;
619: Close cur_rowid2;
620: Open cur_rowid3;

Line 626: App_Exception.Raise_Exception;

622: IF (cur_rowid3%FOUND) THEN
623: Close cur_rowid3;
624: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK2');
625: IGS_GE_MSG_STACK.ADD;
626: App_Exception.Raise_Exception;
627: Return;
628: END IF;
629: Close cur_rowid3;
630: END Get_FK_Igs_Ad_Code_Classes;

Line 729: App_Exception.Raise_Exception;

725: IF Get_Pk_For_Validation(
726: new_references.transcript_id) THEN
727: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
728: IGS_GE_MSG_STACK.ADD;
729: App_Exception.Raise_Exception;
730: END IF;
731: Check_Constraints;
732: Check_Parent_Existance;
733: check_uniqueness;

Line 752: App_Exception.Raise_Exception;

748: IF Get_PK_For_Validation (
749: new_references.transcript_id) THEN
750: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
751: IGS_GE_MSG_STACK.ADD;
752: App_Exception.Raise_Exception;
753: END IF;
754: Check_Constraints;
755: check_uniqueness;
756: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 913: app_exception.raise_exception;

909: end if;
910: else
911: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
912: IGS_GE_MSG_STACK.ADD;
913: app_exception.raise_exception;
914: end if;
915: -- X_TRANSCRIPT_ID := -1;
916: Before_DML(
917: p_action=>'INSERT',

Line 1055: app_exception.raise_exception;

1051: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1052: fnd_message.set_token ('ERR_CD', SQLCODE);
1053: igs_ge_msg_stack.add;
1054: igs_sc_gen_001.unset_ctx('R');
1055: app_exception.raise_exception;
1056: ELSE
1057: igs_sc_gen_001.unset_ctx('R');
1058: RAISE;
1059: END IF;

Line 1144: app_exception.raise_exception;

1140: if (c1%notfound) then
1141: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1142: IGS_GE_MSG_STACK.ADD;
1143: close c1;
1144: app_exception.raise_exception;
1145: return;
1146: end if;
1147: close c1;
1148: if ( ( (tlinfo.QUINTILE_RANK = X_QUINTILE_RANK)

Line 1209: app_exception.raise_exception;

1205: then null;
1206: else
1207: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1208: IGS_GE_MSG_STACK.ADD;
1209: app_exception.raise_exception;
1210: end if;
1211: return;
1212: end LOCK_ROW;
1213: Procedure UPDATE_ROW (

Line 1286: app_exception.raise_exception;

1282: end if;
1283: else
1284: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1285: IGS_GE_MSG_STACK.ADD;
1286: app_exception.raise_exception;
1287: end if;
1288: Before_DML(
1289: p_action=>'UPDATE',
1290: x_rowid=>X_ROWID,

Line 1377: app_exception.raise_exception;

1373: if (sql%notfound) then
1374: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1375: igs_ge_msg_stack.add;
1376: igs_sc_gen_001.unset_ctx('R');
1377: app_exception.raise_exception;
1378: end if;
1379: IF (x_mode = 'S') THEN
1380: igs_sc_gen_001.unset_ctx('R');
1381: END IF;

Line 1395: app_exception.raise_exception;

1391: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1392: fnd_message.set_token ('ERR_CD', SQLCODE);
1393: igs_ge_msg_stack.add;
1394: igs_sc_gen_001.unset_ctx('R');
1395: app_exception.raise_exception;
1396: ELSE
1397: igs_sc_gen_001.unset_ctx('R');
1398: RAISE;
1399: END IF;

Line 1551: app_exception.raise_exception;

1547: if (sql%notfound) then
1548: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1549: igs_ge_msg_stack.add;
1550: igs_sc_gen_001.unset_ctx('R');
1551: app_exception.raise_exception;
1552: end if;
1553: IF (x_mode = 'S') THEN
1554: igs_sc_gen_001.unset_ctx('R');
1555: END IF;