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

Line 82: APP_EXCEPTION.RAISE_EXCEPTION;

78:
79: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
80: IGS_GE_MSG_STACK.ADD;
81: Close cur_old_ref_values;
82: APP_EXCEPTION.RAISE_EXCEPTION;
83:
84: Return;
85: END IF;
86: Close cur_old_ref_values;

Line 179: APP_EXCEPTION.RAISE_EXCEPTION;

175: new_references.version_number,
176: v_message_name) = FALSE THEN
177: FND_MESSAGE.SET_NAME('IGS',v_message_name);
178: IGS_GE_MSG_STACK.ADD;
179: APP_EXCEPTION.RAISE_EXCEPTION;
180: END IF;
181: END IF;
182: -- Validate upper mark range >= lower mark range and both set if one is set
183: IF p_inserting OR p_updating THEN

Line 190: APP_EXCEPTION.RAISE_EXCEPTION;

186: new_references.upper_mark_range,
187: v_message_name) = FALSE THEN
188: FND_MESSAGE.SET_NAME('IGS',v_message_name);
189: IGS_GE_MSG_STACK.ADD;
190: APP_EXCEPTION.RAISE_EXCEPTION;
191: END IF;
192: END IF;
193: -- Validate max percentage >= min percentage
194: IF p_inserting OR p_updating THEN

Line 201: APP_EXCEPTION.RAISE_EXCEPTION;

197: new_references.max_percentage,
198: v_message_name) = FALSE THEN
199: FND_MESSAGE.SET_NAME('IGS',v_message_name);
200: IGS_GE_MSG_STACK.ADD;
201: APP_EXCEPTION.RAISE_EXCEPTION;
202: END IF;
203: END IF;
204:
205: -- Validate result type can not be changed when translations exist for the

Line 224: APP_EXCEPTION.RAISE_EXCEPTION;

220: new_references.grade,
221: v_message_name) = FALSE THEN
222: FND_MESSAGE.SET_NAME('IGS',v_message_name);
223: IGS_GE_MSG_STACK.ADD;
224: APP_EXCEPTION.RAISE_EXCEPTION;
225: END IF;
226: END IF;
227:
228: -- Validate if s_special_grade_type is 'CONCEDED-PASS' then

Line 236: APP_EXCEPTION.RAISE_EXCEPTION;

232: new_references.s_result_type,
233: v_message_name) = FALSE THEN
234: FND_MESSAGE.SET_NAME('IGS',v_message_name);
235: IGS_GE_MSG_STACK.ADD;
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: END IF;
238: END IF;
239: END BeforeRowInsertUpdate1;
240: PROCEDURE AfterRowInsertUpdate2(

Line 257: APP_EXCEPTION.RAISE_EXCEPTION;

253: new_references.upper_mark_range,
254: v_message_name) = FALSE THEN
255: FND_MESSAGE.SET_NAME('IGS',v_message_name);
256: IGS_GE_MSG_STACK.ADD;
257: APP_EXCEPTION.RAISE_EXCEPTION;
258: END IF;
259: -- Validate dflt outstanding indicator only set for 1 grade
260: IF new_references.dflt_outstanding_ind = 'Y' THEN
261: IF IGS_AS_VAL_GSG.assp_val_gsg_dflt (

Line 268: APP_EXCEPTION.RAISE_EXCEPTION;

264: new_references.grade,
265: v_message_name) = FALSE THEN
266: FND_MESSAGE.SET_NAME('IGS',v_message_name);
267: IGS_GE_MSG_STACK.ADD;
268: APP_EXCEPTION.RAISE_EXCEPTION;
269: END IF;
270: END IF;
271: END IF;
272: END AfterRowInsertUpdate2;

Line 339: APP_EXCEPTION.RAISE_EXCEPTION;

335: IF ((UPPER (column_name) = 'S_SPECIAL_GRADE_TYPE ') OR (column_name IS NULL)) THEN
336: IF new_references.s_special_grade_type NOT IN ( 'SUPP-EXAM' , 'SPECIAL-EXAM' , 'REPLACEABLE' , 'CONCEDED-PASS' ) THEN
337: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
338: IGS_GE_MSG_STACK.ADD;
339: APP_EXCEPTION.RAISE_EXCEPTION;
340: END IF;
341: END IF;
342:
343: IF ((UPPER (column_name) = 'DFLT_OUTSTANDING_IND') OR (column_name IS NULL)) THEN

Line 347: APP_EXCEPTION.RAISE_EXCEPTION;

343: IF ((UPPER (column_name) = 'DFLT_OUTSTANDING_IND') OR (column_name IS NULL)) THEN
344: IF new_references.dflt_outstanding_ind NOT IN ( 'Y' , 'N' ) THEN
345: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
346: IGS_GE_MSG_STACK.ADD;
347: APP_EXCEPTION.RAISE_EXCEPTION;
348: END IF;
349: END IF;
350:
351: IF ((UPPER (column_name) = 'SYSTEM_ONLY_IND') OR (column_name IS NULL)) THEN

Line 355: APP_EXCEPTION.RAISE_EXCEPTION;

351: IF ((UPPER (column_name) = 'SYSTEM_ONLY_IND') OR (column_name IS NULL)) THEN
352: IF new_references.system_only_ind NOT IN ( 'Y' , 'N' ) THEN
353: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
354: IGS_GE_MSG_STACK.ADD;
355: APP_EXCEPTION.RAISE_EXCEPTION;
356: END IF;
357: END IF;
358:
359: IF ((UPPER (column_name) = 'SHOW_INTERNALLY_IND ') OR (column_name IS NULL)) THEN

Line 363: APP_EXCEPTION.RAISE_EXCEPTION;

359: IF ((UPPER (column_name) = 'SHOW_INTERNALLY_IND ') OR (column_name IS NULL)) THEN
360: IF new_references.show_internally_ind NOT IN ( 'Y' , 'N' ) THEN
361: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
362: IGS_GE_MSG_STACK.ADD;
363: APP_EXCEPTION.RAISE_EXCEPTION;
364: END IF;
365: END IF;
366:
367: IF ((UPPER (column_name) = 'SHOW_IN_NEWSPAPER_IND ') OR (column_name IS NULL)) THEN

Line 371: APP_EXCEPTION.RAISE_EXCEPTION;

367: IF ((UPPER (column_name) = 'SHOW_IN_NEWSPAPER_IND ') OR (column_name IS NULL)) THEN
368: IF new_references.show_in_newspaper_ind NOT IN ( 'Y' , 'N' ) THEN
369: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
370: IGS_GE_MSG_STACK.ADD;
371: APP_EXCEPTION.RAISE_EXCEPTION;
372: END IF;
373: END IF;
374:
375: IF ((UPPER (column_name) = 'SHOW_ON_OFFICIAL_NTFCTN_IND ') OR (column_name IS NULL)) THEN

Line 379: APP_EXCEPTION.RAISE_EXCEPTION;

375: IF ((UPPER (column_name) = 'SHOW_ON_OFFICIAL_NTFCTN_IND ') OR (column_name IS NULL)) THEN
376: IF new_references.show_on_official_ntfctn_ind NOT IN ( 'Y' , 'N' ) THEN
377: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
378: IGS_GE_MSG_STACK.ADD;
379: APP_EXCEPTION.RAISE_EXCEPTION;
380: END IF;
381: END IF;
382:
383: IF ((UPPER (column_name) = 'SHOW_ON_NOTICEBOARD_IND ') OR (column_name IS NULL)) THEN

Line 387: APP_EXCEPTION.RAISE_EXCEPTION;

383: IF ((UPPER (column_name) = 'SHOW_ON_NOTICEBOARD_IND ') OR (column_name IS NULL)) THEN
384: IF new_references.show_on_noticeboard_ind NOT IN ( 'Y' , 'N' ) THEN
385: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
386: IGS_GE_MSG_STACK.ADD;
387: APP_EXCEPTION.RAISE_EXCEPTION;
388: END IF;
389: END IF;
390:
391: IF ((UPPER (column_name) = 'VERSION_NUMBER ') OR (column_name IS NULL)) THEN

Line 396: APP_EXCEPTION.RAISE_EXCEPTION;

392: IF new_references.version_number < 0 OR
393: new_references.version_number > 999 THEN
394: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
395: IGS_GE_MSG_STACK.ADD;
396: APP_EXCEPTION.RAISE_EXCEPTION;
397: END IF;
398: END IF;
399:
400: IF ((UPPER (column_name) = 'EXTERNAL_GRADE') OR (column_name IS NULL)) THEN

Line 404: APP_EXCEPTION.RAISE_EXCEPTION;

400: IF ((UPPER (column_name) = 'EXTERNAL_GRADE') OR (column_name IS NULL)) THEN
401: IF (new_references.external_grade <> UPPER (new_references.external_grade)) THEN
402: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
403: IGS_GE_MSG_STACK.ADD;
404: APP_EXCEPTION.RAISE_EXCEPTION;
405: END IF;
406: END IF;
407:
408: IF ((UPPER (column_name) = 'GRADE') OR (column_name IS NULL)) THEN

Line 412: APP_EXCEPTION.RAISE_EXCEPTION;

408: IF ((UPPER (column_name) = 'GRADE') OR (column_name IS NULL)) THEN
409: IF (new_references.grade <> UPPER (new_references.grade)) THEN
410: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
411: IGS_GE_MSG_STACK.ADD;
412: APP_EXCEPTION.RAISE_EXCEPTION;
413: END IF;
414: END IF;
415:
416: IF ((UPPER (column_name) = 'GRADING_SCHEMA_CD') OR (column_name IS NULL)) THEN

Line 420: APP_EXCEPTION.RAISE_EXCEPTION;

416: IF ((UPPER (column_name) = 'GRADING_SCHEMA_CD') OR (column_name IS NULL)) THEN
417: IF (new_references.grading_schema_cd <> UPPER (new_references.grading_schema_cd)) THEN
418: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
419: IGS_GE_MSG_STACK.ADD;
420: APP_EXCEPTION.RAISE_EXCEPTION;
421: END IF;
422: END IF;
423:
424:

Line 429: APP_EXCEPTION.RAISE_EXCEPTION;

425: IF ((UPPER (column_name) = 'S_RESULT_TYPE') OR (column_name IS NULL)) THEN
426: IF (new_references.s_result_type <> UPPER (new_references.s_result_type)) THEN
427: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
428: IGS_GE_MSG_STACK.ADD;
429: APP_EXCEPTION.RAISE_EXCEPTION;
430: END IF;
431: END IF;
432:
433:

Line 439: APP_EXCEPTION.RAISE_EXCEPTION;

435: IF new_references.min_percentage < 0 OR
436: new_references.min_percentage > 100 THEN
437: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
438: IGS_GE_MSG_STACK.ADD;
439: APP_EXCEPTION.RAISE_EXCEPTION;
440: END IF;
441: END IF;
442:
443: IF ((UPPER (column_name) = 'MAX_PERCENTAGE ') OR (column_name IS NULL)) THEN

Line 448: APP_EXCEPTION.RAISE_EXCEPTION;

444: IF new_references.max_percentage < 0 OR
445: new_references.max_percentage > 100 THEN
446: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
447: IGS_GE_MSG_STACK.ADD;
448: APP_EXCEPTION.RAISE_EXCEPTION;
449: END IF;
450: END IF;
451:
452: IF ((UPPER (column_name) = 'GPA_VAL ') OR (column_name IS NULL)) THEN

Line 457: APP_EXCEPTION.RAISE_EXCEPTION;

453: IF new_references.gpa_val < 0 OR
454: new_references.gpa_val > 999.99 THEN
455: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
456: IGS_GE_MSG_STACK.ADD;
457: APP_EXCEPTION.RAISE_EXCEPTION;
458: END IF;
459: END IF;
460:
461:

Line 480: APP_EXCEPTION.RAISE_EXCEPTION;

476: ) THEN
477:
478: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
479: IGS_GE_MSG_STACK.ADD;
480: APP_EXCEPTION.RAISE_EXCEPTION;
481:
482: END IF;
483: END IF;
484: -- Has to be changed.

Line 495: APP_EXCEPTION.RAISE_EXCEPTION;

491: ) THEN
492:
493: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
494: IGS_GE_MSG_STACK.ADD;
495: APP_EXCEPTION.RAISE_EXCEPTION;
496: END IF;
497:
498: END Check_Parent_Existance;
499: PROCEDURE Check_Child_Existance AS

Line 604: APP_EXCEPTION.RAISE_EXCEPTION;

600: IF (cur_rowid%FOUND) THEN
601: Fnd_Message.Set_Name ('IGS', 'IGS_AS_GSG_GS_FK');
602: IGS_GE_MSG_STACK.ADD;
603: Close cur_rowid;
604: APP_EXCEPTION.RAISE_EXCEPTION;
605:
606: Return;
607: END IF;
608: Close cur_rowid;

Line 625: APP_EXCEPTION.RAISE_EXCEPTION;

621: IF (cur_rowid%FOUND) THEN
622: Fnd_Message.Set_Name ('IGS', 'IGS_AS_GSG_SLV_FK');
623: IGS_GE_MSG_STACK.ADD;
624: Close cur_rowid;
625: APP_EXCEPTION.RAISE_EXCEPTION;
626:
627: Return;
628: END IF;
629: Close cur_rowid;

Line 753: APP_EXCEPTION.RAISE_EXCEPTION;

749: ) THEN
750:
751: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
752: IGS_GE_MSG_STACK.ADD;
753: APP_EXCEPTION.RAISE_EXCEPTION;
754:
755: END IF;
756:
757: Check_Constraints;

Line 776: APP_EXCEPTION.RAISE_EXCEPTION;

772: new_references.grade
773: ) THEN
774: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
775: IGS_GE_MSG_STACK.ADD;
776: APP_EXCEPTION.RAISE_EXCEPTION;
777: END IF;
778: Check_Constraints;
779: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
780: Check_Constraints;

Line 875: APP_EXCEPTION.RAISE_EXCEPTION;

871: end if;
872: else
873: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
874: IGS_GE_MSG_STACK.ADD;
875: APP_EXCEPTION.RAISE_EXCEPTION;
876: end if;
877: Before_DML(
878: p_action=>'INSERT',
879: x_rowid=>X_ROWID,

Line 1151: APP_EXCEPTION.RAISE_EXCEPTION;

1147: fetch c1 into tlinfo;
1148: if (c1%notfound) then
1149: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1150: IGS_GE_MSG_STACK.ADD;
1151: APP_EXCEPTION.RAISE_EXCEPTION;
1152: close c1;
1153: return;
1154: end if;
1155: close c1;

Line 1203: APP_EXCEPTION.RAISE_EXCEPTION;

1199: null;
1200: else
1201: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1202: IGS_GE_MSG_STACK.ADD;
1203: APP_EXCEPTION.RAISE_EXCEPTION;
1204: end if;
1205: return;
1206: end LOCK_ROW;
1207: procedure UPDATE_ROW (

Line 1277: APP_EXCEPTION.RAISE_EXCEPTION;

1273: end if;
1274: else
1275: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1276: IGS_GE_MSG_STACK.ADD;
1277: APP_EXCEPTION.RAISE_EXCEPTION;
1278: end if;
1279: Before_DML(
1280: p_action=>'UPDATE',
1281: x_rowid=>X_ROWID,