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

Line 37: IGS_GE_MSG_STACK.ADD;

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

Line 78: IGS_GE_MSG_STACK.ADD;

74: column_name is null THEN
75: IF new_references.course_cd <> UPPER(new_references.course_cd)
76: THEN
77: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END IF;
82:

Line 88: IGS_GE_MSG_STACK.ADD;

84: column_name is null THEN
85: IF new_references.s_rule_call_cd <> UPPER(new_references.s_rule_call_cd)
86: THEN
87: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;
92: END Check_Constraints;

Line 105: IGS_GE_MSG_STACK.ADD;

101: IF NOT IGS_PS_COURSE_PKG.Get_PK_For_Validation (
102: new_references.course_cd
103: )THEN
104: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109:

Line 118: IGS_GE_MSG_STACK.ADD;

114: IF NOT IGS_RU_RULE_PKG.Get_PK_For_Validation (
115: new_references.rul_sequence_number
116: )THEN
117: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END IF;
122:

Line 131: IGS_GE_MSG_STACK.ADD;

127: IF NOT IGS_RU_CALL_PKG.Get_PK_For_Validation (
128: new_references.s_rule_call_cd
129: )THEN
130: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135:

Line 184: IGS_GE_MSG_STACK.ADD;

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

Line 210: IGS_GE_MSG_STACK.ADD;

206: Fetch cur_rowid INTO lv_rowid;
207: IF (cur_rowid%FOUND) THEN
208: Close cur_rowid;
209: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CR_RUL_FK');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: Return;
213: END IF;
214: Close cur_rowid;

Line 236: IGS_GE_MSG_STACK.ADD;

232: Fetch cur_rowid INTO lv_rowid;
233: IF (cur_rowid%FOUND) THEN
234: Close cur_rowid;
235: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CR_SRC_FK');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: Return;
239: END IF;
240: Close cur_rowid;

Line 278: IGS_GE_MSG_STACK.ADD;

274: new_references.course_cd ,
275: new_references.s_rule_call_cd
276: ) THEN
277: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: END IF;
281: Check_Constraints;
282: Check_Parent_Existance;

Line 295: IGS_GE_MSG_STACK.ADD;

291: new_references.course_cd ,
292: new_references.s_rule_call_cd
293: ) THEN
294: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298: Check_Constraints;
299: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 345: IGS_GE_MSG_STACK.ADD;

341: X_LAST_UPDATE_LOGIN := -1;
342: end if;
343: else
344: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: end if;
348: Before_DML (
349: p_action => 'INSERT',

Line 413: IGS_GE_MSG_STACK.ADD;

409: fetch c1 into tlinfo;
410: if (c1%notfound) then
411: close c1;
412: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
413: IGS_GE_MSG_STACK.ADD;
414: app_exception.raise_exception;
415: return;
416: end if;
417: close c1;

Line 424: IGS_GE_MSG_STACK.ADD;

420: ) then
421: null;
422: else
423: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
424: IGS_GE_MSG_STACK.ADD;
425: app_exception.raise_exception;
426: end if;
427: return;
428: end LOCK_ROW;

Line 456: IGS_GE_MSG_STACK.ADD;

452: X_LAST_UPDATE_LOGIN := -1;
453: end if;
454: else
455: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
456: IGS_GE_MSG_STACK.ADD;
457: app_exception.raise_exception;
458: end if;
459: Before_DML (
460: p_action => 'UPDATE',