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_STAGE_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:

Line 81: App_Exception.Raise_Exception;

77: new_references.version_number,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: -- Validate the IGS_PS_COURSE Stage Type is not closed
84: IF IGS_PS_VAL_CST.crsp_val_cstt_closed(
85: new_references.course_stage_type,

Line 89: App_Exception.Raise_Exception;

85: new_references.course_stage_type,
86: v_message_name) = FALSE THEN
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: ELSE
92: IF IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl(
93: old_references.course_cd,

Line 98: App_Exception.Raise_Exception;

94: old_references.version_number,
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:
102:

Line 124: App_Exception.Raise_Exception;

120: NEW_REFERENCES.course_stage_type,
121: v_message_name) = FALSE THEN
122: Fnd_Message.Set_Name('IGS',v_message_name);
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
127:
128:

Line 153: App_Exception.Raise_Exception;

149: IF new_references.course_cd <> UPPER(new_references.course_cd)
150: THEN
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156:
157: IF upper(column_name)= 'COURSE_STAGE_TYPE' OR

Line 163: App_Exception.Raise_Exception;

159: IF new_references.course_stage_type <> UPPER(new_references.course_stage_type)
160: THEN
161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: END IF;
166:
167: IF upper(column_name)= 'SEQUENCE_NUMBER' OR

Line 174: App_Exception.Raise_Exception;

170: new_references.sequence_number > 999999
171: THEN
172: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
177: END Check_Constraints;
178:

Line 194: App_Exception.Raise_Exception;

190: new_references.version_number
191: )THEN
192: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197:
198: IF (((old_references.course_stage_type = new_references.course_stage_type)) OR

Line 207: App_Exception.Raise_Exception;

203: new_references.course_stage_type
204: )THEN
205: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: END IF;
209: END IF;
210:
211: END Check_Parent_Existance;

Line 275: App_Exception.Raise_Exception;

271: IF (cur_rowid%FOUND) THEN
272: Close cur_rowid;
273: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CST_CRV_FK');
274: IGS_GE_MSG_STACK.ADD;
275: App_Exception.Raise_Exception;
276: Return;
277: END IF;
278: Close cur_rowid;
279:

Line 301: App_Exception.Raise_Exception;

297: IF (cur_rowid%FOUND) THEN
298: Close cur_rowid;
299: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CST_CSTT_FK');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: Return;
303: END IF;
304: Close cur_rowid;
305:

Line 351: App_Exception.Raise_Exception;

347: new_references.sequence_number
348: ) THEN
349: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
350: IGS_GE_MSG_STACK.ADD;
351: App_Exception.Raise_Exception;
352: END IF;
353: Check_Constraints;
354: Check_Parent_Existance;
355: ELSIF (p_action = 'UPDATE') THEN

Line 371: App_Exception.Raise_Exception;

367: new_references.course_cd ,
368: new_references.sequence_number ) THEN
369: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
370: IGS_GE_MSG_STACK.ADD;
371: App_Exception.Raise_Exception;
372: END IF;
373: Check_Constraints;
374: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
375: Check_Constraints;

Line 433: app_exception.raise_exception;

429: end if;
430: else
431: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
432: IGS_GE_MSG_STACK.ADD;
433: app_exception.raise_exception;
434: end if;
435:
436: Before_DML( p_action => 'INSERT',
437: x_rowid => X_ROWID,

Line 516: app_exception.raise_exception;

512: if (c1%notfound) then
513: close c1;
514: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
515: IGS_GE_MSG_STACK.ADD;
516: app_exception.raise_exception;
517: return;
518: end if;
519: close c1;
520:

Line 533: app_exception.raise_exception;

529: null;
530: else
531: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
532: IGS_GE_MSG_STACK.ADD;
533: app_exception.raise_exception;
534: end if;
535: return;
536: end LOCK_ROW;
537:

Line 568: app_exception.raise_exception;

564: end if;
565: else
566: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
567: IGS_GE_MSG_STACK.ADD;
568: app_exception.raise_exception;
569: end if;
570:
571: Before_DML( p_action => 'UPDATE',
572: x_rowid => X_ROWID,