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_OU_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: Return;
41: END IF;

Line 76: IGS_GE_MSG_STACK.ADD;

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

Line 95: IGS_GE_MSG_STACK.ADD;

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

Line 149: IGS_GE_MSG_STACK.ADD;

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

Line 179: IGS_GE_MSG_STACK.ADD;

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

Line 218: IGS_GE_MSG_STACK.ADD;

214: FETCH c_parent INTO l_dummy;
215: IF c_parent%NOTFOUND THEN
216: CLOSE c_parent;
217: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
218: IGS_GE_MSG_STACK.ADD;
219: APP_EXCEPTION.RAISE_EXCEPTION;
220: END IF;
221: CLOSE c_parent;
222: ELSIF(p_action = 'UPDATE') THEN

Line 231: IGS_GE_MSG_STACK.ADD;

227: FETCH c_parent INTO l_dummy;
228: IF c_parent%NOTFOUND THEN
229: CLOSE c_parent;
230: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
231: IGS_GE_MSG_STACK.ADD;
232: APP_EXCEPTION.RAISE_EXCEPTION;
233: END IF;
234: CLOSE c_parent;
235: END IF;

Line 280: IGS_GE_MSG_STACK.ADD;

276: new_references.pro_sequence_number,
277: new_references.course_cd
278: ) THEN
279: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: Check_Constraints;
284: Check_Parent_Existance;

Line 298: IGS_GE_MSG_STACK.ADD;

294: new_references.pro_sequence_number,
295: new_references.course_cd
296: ) THEN
297: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
298: IGS_GE_MSG_STACK.ADD;
299: App_Exception.Raise_Exception;
300: END IF;
301: Check_Constraints;
302: 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:
349: Before_DML (

Line 415: IGS_GE_MSG_STACK.ADD;

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

Line 467: IGS_GE_MSG_STACK.ADD;

463:
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 ;

Line 476: IGS_GE_MSG_STACK.ADD;

472:
473: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
474: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
475: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
476: IGS_GE_MSG_STACK.ADD;
477: App_Exception.Raise_Exception ;
478: END IF;
479:
480: END IF ;

Line 485: IGS_GE_MSG_STACK.ADD;

481:
482: IF upper(Column_name) = 'PRO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
483: IF new_references.PRO_SEQUENCE_NUMBER < 1 or new_references.PRO_SEQUENCE_NUMBER > 999999 then
484: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception ;
487: END IF;
488:
489: END IF ;

Line 494: IGS_GE_MSG_STACK.ADD;

490:
491: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
492: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 then
493: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception ;
496: END IF;
497:
498: END IF ;