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 IGS_GE_MSG_STACK

Line 80: IGS_GE_MSG_STACK.ADD;

76:
77: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
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;

Line 178: IGS_GE_MSG_STACK.ADD;

174: new_references.grading_schema_cd,
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

Line 189: IGS_GE_MSG_STACK.ADD;

185: new_references.lower_mark_range,
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

Line 200: IGS_GE_MSG_STACK.ADD;

196: new_references.min_percentage,
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:

Line 223: IGS_GE_MSG_STACK.ADD;

219: new_references.version_number,
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:

Line 235: IGS_GE_MSG_STACK.ADD;

231: new_references.s_special_grade_type,
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;

Line 256: IGS_GE_MSG_STACK.ADD;

252: new_references.lower_mark_range,
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

Line 267: IGS_GE_MSG_STACK.ADD;

263: new_references.version_number,
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;

Line 338: IGS_GE_MSG_STACK.ADD;

334:
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:

Line 346: IGS_GE_MSG_STACK.ADD;

342:
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:

Line 354: IGS_GE_MSG_STACK.ADD;

350:
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:

Line 362: IGS_GE_MSG_STACK.ADD;

358:
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:

Line 370: IGS_GE_MSG_STACK.ADD;

366:
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:

Line 378: IGS_GE_MSG_STACK.ADD;

374:
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:

Line 386: IGS_GE_MSG_STACK.ADD;

382:
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:

Line 395: IGS_GE_MSG_STACK.ADD;

391: IF ((UPPER (column_name) = 'VERSION_NUMBER ') OR (column_name IS NULL)) THEN
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:

Line 403: IGS_GE_MSG_STACK.ADD;

399:
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:

Line 411: IGS_GE_MSG_STACK.ADD;

407:
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:

Line 419: IGS_GE_MSG_STACK.ADD;

415:
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:

Line 428: IGS_GE_MSG_STACK.ADD;

424:
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:

Line 438: IGS_GE_MSG_STACK.ADD;

434: IF ((UPPER (column_name) = 'MIN_PERCENTAGE') OR (column_name IS NULL)) THEN
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:

Line 447: IGS_GE_MSG_STACK.ADD;

443: IF ((UPPER (column_name) = 'MAX_PERCENTAGE ') OR (column_name IS NULL)) THEN
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:

Line 456: IGS_GE_MSG_STACK.ADD;

452: IF ((UPPER (column_name) = 'GPA_VAL ') OR (column_name IS NULL)) THEN
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:

Line 479: IGS_GE_MSG_STACK.ADD;

475: new_references.version_number
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;

Line 494: IGS_GE_MSG_STACK.ADD;

490: new_references.s_result_type
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;

Line 602: IGS_GE_MSG_STACK.ADD;

598: Open cur_rowid;
599: Fetch cur_rowid INTO lv_rowid;
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;

Line 623: IGS_GE_MSG_STACK.ADD;

619: Open cur_rowid;
620: Fetch cur_rowid INTO lv_rowid;
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;

Line 752: IGS_GE_MSG_STACK.ADD;

748: new_references.grade
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:

Line 775: IGS_GE_MSG_STACK.ADD;

771: new_references.version_number,
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

Line 874: IGS_GE_MSG_STACK.ADD;

870: X_LAST_UPDATE_LOGIN := -1;
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',

Line 1150: IGS_GE_MSG_STACK.ADD;

1146: open c1;
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;

Line 1202: IGS_GE_MSG_STACK.ADD;

1198: ) then
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;

Line 1276: IGS_GE_MSG_STACK.ADD;

1272: X_LAST_UPDATE_LOGIN := -1;
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',