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

Line 38: IGS_GE_MSG_STACK.ADD;

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

Line 81: IGS_GE_MSG_STACK.ADD;

77: new_references.course_cd,
78: new_references.spo_sequence_number
79: )THEN
80: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83:
84: END IF;
85:

Line 96: IGS_GE_MSG_STACK.ADD;

92: IF NOT IGS_PS_UNIT_PKG.Get_PK_For_Validation (
93: new_references.unit_cd
94: )THEN
95: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98:
99: END IF;
100:

Line 158: IGS_GE_MSG_STACK.ADD;

154: Open cur_rowid;
155: Fetch cur_rowid INTO lv_rowid;
156: IF (cur_rowid%FOUND) THEN
157: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPU_SPO_FK');
158: IGS_GE_MSG_STACK.ADD;
159: Close cur_rowid;
160: App_Exception.Raise_Exception;
161:
162: Return;

Line 185: IGS_GE_MSG_STACK.ADD;

181: Open cur_rowid;
182: Fetch cur_rowid INTO lv_rowid;
183: IF (cur_rowid%FOUND) THEN
184: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPU_UN_FK');
185: IGS_GE_MSG_STACK.ADD;
186: Close cur_rowid;
187: App_Exception.Raise_Exception;
188:
189: Return;

Line 235: IGS_GE_MSG_STACK.ADD;

231: new_references.course_cd,
232: new_references.spo_sequence_number,
233: new_references.unit_cd) THEN
234: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: CHECK_CONSTRAINTS;
239:

Line 253: IGS_GE_MSG_STACK.ADD;

249: new_references.course_cd,
250: new_references.spo_sequence_number,
251: new_references.unit_cd) THEN
252: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: CHECK_CONSTRAINTS;
257:

Line 298: IGS_GE_MSG_STACK.ADD;

294: X_LAST_UPDATE_LOGIN := -1;
295: end if;
296: else
297: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
298: IGS_GE_MSG_STACK.ADD;
299: app_exception.raise_exception;
300: end if;
301: Before_DML (
302: p_action => 'INSERT',

Line 359: igs_ge_msg_stack.add;

355: WHEN OTHERS THEN
356: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
357: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
358: fnd_message.set_token ('ERR_CD', SQLCODE);
359: igs_ge_msg_stack.add;
360: igs_sc_gen_001.unset_ctx('R');
361: app_exception.raise_exception;
362: ELSE
363: igs_sc_gen_001.unset_ctx('R');

Line 393: IGS_GE_MSG_STACK.ADD;

389: open c1;
390: fetch c1 into tlinfo;
391: if (c1%notfound) then
392: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
393: IGS_GE_MSG_STACK.ADD;
394: close c1;
395: app_exception.raise_exception;
396:
397: return;

Line 411: IGS_GE_MSG_STACK.ADD;

407: ) then
408: null;
409: else
410: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
411: IGS_GE_MSG_STACK.ADD;
412: app_exception.raise_exception;
413: end if;
414: return;
415: end LOCK_ROW;

Line 445: IGS_GE_MSG_STACK.ADD;

441: X_LAST_UPDATE_LOGIN := -1;
442: end if;
443: else
444: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
445: IGS_GE_MSG_STACK.ADD;
446: app_exception.raise_exception;
447: end if;
448: Before_DML (
449: p_action => 'UPDATE',

Line 473: igs_ge_msg_stack.add;

469: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
470: where ROWID = X_ROWID;
471: if (sql%notfound) then
472: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
473: igs_ge_msg_stack.add;
474: igs_sc_gen_001.unset_ctx('R');
475: app_exception.raise_exception;
476: end if;
477: IF (x_mode = 'S') THEN

Line 486: igs_ge_msg_stack.add;

482: WHEN OTHERS THEN
483: IF (SQLCODE = (-28115)) THEN
484: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
485: fnd_message.set_token ('ERR_CD', SQLCODE);
486: igs_ge_msg_stack.add;
487: igs_sc_gen_001.unset_ctx('R');
488: app_exception.raise_exception;
489: ELSE
490: igs_sc_gen_001.unset_ctx('R');

Line 554: igs_ge_msg_stack.add;

550: delete from IGS_PR_STDNT_PR_UNIT
551: where ROWID = X_ROWID;
552: if (sql%notfound) then
553: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
554: igs_ge_msg_stack.add;
555: igs_sc_gen_001.unset_ctx('R');
556: app_exception.raise_exception;
557: end if;
558: IF (x_mode = 'S') THEN

Line 586: IGS_GE_MSG_STACK.ADD;

582:
583: IF upper(Column_name) = 'SPO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
584: IF new_references.SPO_SEQUENCE_NUMBER < 1 or new_references.SPO_SEQUENCE_NUMBER > 999999 then
585: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
586: IGS_GE_MSG_STACK.ADD;
587: App_Exception.Raise_Exception ;
588: END IF;
589:
590: END IF ;

Line 595: IGS_GE_MSG_STACK.ADD;

591:
592: IF upper(Column_name) = 'S_UNIT_TYPE' OR COLUMN_NAME IS NULL THEN
593: IF new_references.S_UNIT_TYPE<> upper(new_references.S_UNIT_TYPE) then
594: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
595: IGS_GE_MSG_STACK.ADD;
596: App_Exception.Raise_Exception ;
597: END IF;
598:
599: IF new_references.S_UNIT_TYPE not in ('EXCLUDED','REQUIRED') then

Line 601: IGS_GE_MSG_STACK.ADD;

597: END IF;
598:
599: IF new_references.S_UNIT_TYPE not in ('EXCLUDED','REQUIRED') then
600: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
601: IGS_GE_MSG_STACK.ADD;
602: App_Exception.Raise_Exception ;
603: END IF;
604:
605: END IF ;

Line 610: IGS_GE_MSG_STACK.ADD;

606:
607: IF upper(Column_name) = 'UNIT_CD' OR COLUMN_NAME IS NULL THEN
608: IF new_references.UNIT_CD<> upper(new_references.UNIT_CD) then
609: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
610: IGS_GE_MSG_STACK.ADD;
611: App_Exception.Raise_Exception ;
612: END IF;
613:
614: END IF ;