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

Line 37: IGS_GE_MSG_STACK.ADD;

33: Open cur_old_ref_values;
34: Fetch cur_old_ref_values INTO old_references;
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: Close cur_old_ref_values;
39: App_Exception.Raise_Exception;
40:
41: Return;

Line 73: IGS_GE_MSG_STACK.ADD;

69: IF NOT IGS_PS_COURSE_PKG.Get_PK_For_Validation (
70: new_references.course_cd
71: )THEN
72: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75:
76: END IF;
77:

Line 94: IGS_GE_MSG_STACK.ADD;

90: new_references.spo_course_cd,
91: new_references.spo_sequence_number
92: )THEN
93: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96:
97: END IF;
98:

Line 151: IGS_GE_MSG_STACK.ADD;

147: Open cur_rowid;
148: Fetch cur_rowid INTO lv_rowid;
149: IF (cur_rowid%FOUND) THEN
150: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPC_CRS_FK');
151: IGS_GE_MSG_STACK.ADD;
152: Close cur_rowid;
153: App_Exception.Raise_Exception;
154:
155: Return;

Line 181: IGS_GE_MSG_STACK.ADD;

177: Open cur_rowid;
178: Fetch cur_rowid INTO lv_rowid;
179: IF (cur_rowid%FOUND) THEN
180: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPC_SPO_FK');
181: IGS_GE_MSG_STACK.ADD;
182: Close cur_rowid;
183: App_Exception.Raise_Exception;
184:
185: Return;

Line 229: IGS_GE_MSG_STACK.ADD;

225: new_references.spo_course_cd,
226: new_references.spo_sequence_number,
227: new_references.course_cd)THEN
228: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: END IF;
232: CHECK_CONSTRAINTS;
233:

Line 245: IGS_GE_MSG_STACK.ADD;

241: new_references.spo_course_cd,
242: new_references.spo_sequence_number,
243: new_references.course_cd)THEN
244: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: END IF;
248: CHECK_CONSTRAINTS;
249:

Line 289: IGS_GE_MSG_STACK.ADD;

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

Line 346: igs_ge_msg_stack.add;

342: WHEN OTHERS THEN
343: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
344: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
345: fnd_message.set_token ('ERR_CD', SQLCODE);
346: igs_ge_msg_stack.add;
347: igs_sc_gen_001.unset_ctx('R');
348: app_exception.raise_exception;
349: ELSE
350: igs_sc_gen_001.unset_ctx('R');

Line 378: IGS_GE_MSG_STACK.ADD;

374: open c1;
375: fetch c1 into tlinfo;
376: if (c1%notfound) then
377: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
378: IGS_GE_MSG_STACK.ADD;
379: close c1;
380: app_exception.raise_exception;
381:
382: return;

Line 397: IGS_GE_MSG_STACK.ADD;

393: then
394: null;
395: else
396: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
397: IGS_GE_MSG_STACK.ADD;
398: app_exception.raise_exception;
399: end if;
400: return;
401:

Line 423: igs_ge_msg_stack.add;

419: delete from IGS_PR_STDNT_PR_PS
420: where ROWID = X_ROWID;
421: if (sql%notfound) then
422: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: end if;
427: IF (x_mode = 'S') THEN

Line 452: IGS_GE_MSG_STACK.ADD;

448:
449: IF upper(Column_name) = 'SPO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
450: IF new_references.SPO_SEQUENCE_NUMBER < 1 or new_references.SPO_SEQUENCE_NUMBER > 999999 then
451: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception ;
454: END IF;
455: END IF ;
456:

Line 460: IGS_GE_MSG_STACK.ADD;

456:
457: IF upper(Column_name) = 'SPO_COURSE_CD' OR COLUMN_NAME IS NULL THEN
458: IF new_references.SPO_COURSE_CD<> upper(new_references.SPO_COURSE_CD) then
459: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
460: IGS_GE_MSG_STACK.ADD;
461: App_Exception.Raise_Exception ;
462: END IF;
463: END IF;
464: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN

Line 467: IGS_GE_MSG_STACK.ADD;

463: END IF;
464: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
465: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
466: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
467: IGS_GE_MSG_STACK.ADD;
468: App_Exception.Raise_Exception ;
469: END IF;
470:
471: END IF ;