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_ITM_EXAM_MTRL_PKG dependencies on IGS_GE_MSG_STACK

Line 32: IGS_GE_MSG_STACK.ADD;

28: Open cur_old_ref_values;
29: Fetch cur_old_ref_values INTO old_references;
30: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
31: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
32: IGS_GE_MSG_STACK.ADD;
33: Close cur_old_ref_values;
34: APP_EXCEPTION.RAISE_EXCEPTION;
35: Return;
36: END IF;

Line 75: IGS_GE_MSG_STACK.ADD;

71: IF IGS_AS_VAL_AIEM.assp_val_exmt_closed(
72: new_references.exam_material_type,
73: v_message_name) = FALSE THEN
74: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
75: IGS_GE_MSG_STACK.ADD;
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: END IF;
78: --
79: -- Can only create against IGS_AS_ASSESSMNT_ITM records which are

Line 85: IGS_GE_MSG_STACK.ADD;

81: IF IGS_AS_VAL_AIEM.assp_val_ai_exmnbl(
82: new_references.ass_id,
83: v_message_name) = FALSE THEN
84: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
85: IGS_GE_MSG_STACK.ADD;
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: END IF;
88: END IF;
89: IF p_inserting OR p_updating THEN

Line 97: IGS_GE_MSG_STACK.ADD;

93: new_references.s_material_cat,
94: new_references.quantity_per_student,
95: v_message_name) = FALSE THEN
96: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
97: IGS_GE_MSG_STACK.ADD;
98: APP_EXCEPTION.RAISE_EXCEPTION;
99: END IF;
100: END IF;
101: END BeforeRowInsertUpdate1;

Line 112: IGS_GE_MSG_STACK.ADD;

108: ELSIF NOT IGS_AS_ASSESSMNT_ITM_PKG.Get_PK_For_Validation (
109: new_references.ass_id
110: )THEN
111: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
112: IGS_GE_MSG_STACK.ADD;
113: APP_EXCEPTION.RAISE_EXCEPTION;
114:
115: END IF;
116: IF (((old_references.exam_material_type = new_references.exam_material_type)) OR

Line 123: IGS_GE_MSG_STACK.ADD;

119: ELSIF NOT IGS_AS_EXM_MTRL_TYPE_PKG.Get_PK_For_Validation (
120: new_references.exam_material_type
121: )THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: APP_EXCEPTION.RAISE_EXCEPTION;
125:
126: END IF;
127: END Check_Parent_Existance;

Line 161: IGS_GE_MSG_STACK.ADD;

157: Open cur_rowid;
158: Fetch cur_rowid INTO lv_rowid;
159: IF (cur_rowid%FOUND) THEN
160: Fnd_Message.Set_Name ('IGS', 'IGS_AS_AIEM_AI_FK');
161: IGS_GE_MSG_STACK.ADD;
162: Close cur_rowid;
163: APP_EXCEPTION.RAISE_EXCEPTION;
164: Return;
165: END IF;

Line 182: IGS_GE_MSG_STACK.ADD;

178: Open cur_rowid;
179: Fetch cur_rowid INTO lv_rowid;
180: IF (cur_rowid%FOUND) THEN
181: Fnd_Message.Set_Name ('IGS', 'IGS_AS_AIEM_EXMT_FK');
182: IGS_GE_MSG_STACK.ADD;
183: Close cur_rowid;
184: APP_EXCEPTION.RAISE_EXCEPTION;
185: Return;
186: END IF;

Line 226: IGS_GE_MSG_STACK.ADD;

222: IF Get_PK_For_Validation (
223: new_references.ass_id ,
224: new_references.exam_material_type ) THEN
225: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
229: Check_Constraints;
230: Check_Parent_Existance;

Line 241: IGS_GE_MSG_STACK.ADD;

237: IF Get_PK_For_Validation (
238: new_references.ass_id ,
239: new_references.exam_material_type ) THEN
240: Fnd_Message.Set_Name ('IGS', 'IGS_AS_MATERIAL_ALREADY_EXISTS');
241: IGS_GE_MSG_STACK.ADD;
242: APP_EXCEPTION.RAISE_EXCEPTION;
243: END IF;
244: Check_Constraints;
245: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 288: IGS_GE_MSG_STACK.ADD;

284: X_LAST_UPDATE_LOGIN := -1;
285: end if;
286: else
287: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
288: IGS_GE_MSG_STACK.ADD;
289: APP_EXCEPTION.RAISE_EXCEPTION;
290: end if;
291: Before_DML(
292: p_action=>'INSERT',

Line 357: IGS_GE_MSG_STACK.ADD;

353: open c1;
354: fetch c1 into tlinfo;
355: if (c1%notfound) then
356: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
357: IGS_GE_MSG_STACK.ADD;
358: APP_EXCEPTION.RAISE_EXCEPTION;
359: close c1;
360: return;
361: end if;

Line 374: IGS_GE_MSG_STACK.ADD;

370: ) then
371: null;
372: else
373: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
374: IGS_GE_MSG_STACK.ADD;
375: APP_EXCEPTION.RAISE_EXCEPTION;
376: end if;
377: return;
378: end LOCK_ROW;

Line 407: IGS_GE_MSG_STACK.ADD;

403: X_LAST_UPDATE_LOGIN := -1;
404: end if;
405: else
406: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
407: IGS_GE_MSG_STACK.ADD;
408: APP_EXCEPTION.RAISE_EXCEPTION;
409: end if;
410: Before_DML(
411: p_action=>'UPDATE',

Line 507: IGS_GE_MSG_STACK.ADD;

503: IF upper(column_name) = 'EXAM_MATERIAL_TYPE' OR
504: column_name is null Then
505: IF new_references.EXAM_MATERIAL_TYPE <> UPPER(new_references.EXAM_MATERIAL_TYPE) Then
506: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
507: IGS_GE_MSG_STACK.ADD;
508: APP_EXCEPTION.RAISE_EXCEPTION;
509: END IF;
510: END IF;
511:

Line 516: IGS_GE_MSG_STACK.ADD;

512: IF upper(column_name) = 'S_MATERIAL_CAT' OR
513: column_name is null Then
514: IF new_references.S_MATERIAL_CAT NOT IN ( 'ALLOWABLE' , 'NON-ALLOW' , 'SUPPLIED' ) then
515: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
516: IGS_GE_MSG_STACK.ADD;
517: APP_EXCEPTION.RAISE_EXCEPTION;
518: END IF;
519: END IF;
520: