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

Line 39: App_Exception.Raise_Exception;

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

Line 77: APP_EXCEPTION.RAISE_EXCEPTION;

73: new_references.version_number,
74: v_message_name) = FALSE THEN
75: FND_MESSAGE.SET_NAME('IGS',v_message_name);
76: IGS_GE_MSG_STACK.ADD;
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: END IF;
79: ELSE
80: IF IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl(
81: old_references.course_cd,

Line 86: APP_EXCEPTION.RAISE_EXCEPTION;

82: old_references.version_number,
83: v_message_name) = FALSE THEN
84: FND_MESSAGE.SET_NAME('IGS',v_message_name);
85: IGS_GE_MSG_STACK.ADD;
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: END IF;
88: END IF;
89: -- Validate IGS_PS_COURSE Version IGS_RU_RULE
90: IF p_inserting OR p_updating THEN

Line 102: APP_EXCEPTION.RAISE_EXCEPTION;

98: new_references.rul_sequence_number,
99: v_message_name) = FALSE THEN
100: FND_MESSAGE.SET_NAME('IGS',v_message_name);
101: IGS_GE_MSG_STACK.ADD;
102: APP_EXCEPTION.RAISE_EXCEPTION;
103: END IF;
104: END IF;
105:
106:

Line 129: App_Exception.Raise_Exception;

125: IF new_references.course_cd <> UPPER(new_references.course_cd)
126: THEN
127: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132: IF upper(column_name)= 'S_RULE_CALL_CD' OR
133: column_name is null THEN

Line 138: App_Exception.Raise_Exception;

134: IF new_references.s_rule_call_cd <> UPPER(new_references.s_rule_call_cd)
135: THEN
136: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
141: IF upper(column_name)= 'RUL_SEQUENCE_NUMBER' OR
142: column_name is null THEN

Line 148: App_Exception.Raise_Exception;

144: new_references.rul_sequence_number > 999999
145: THEN
146: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151: END Check_Constraints;
152:

Line 168: App_Exception.Raise_Exception;

164: new_references.version_number
165: )THEN
166: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170: END IF;
171:
172: IF (((old_references.rul_sequence_number = new_references.rul_sequence_number)) OR

Line 181: App_Exception.Raise_Exception;

177: new_references.rul_sequence_number
178: )THEN
179: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184:
185: IF (((old_references.s_rule_call_cd = new_references.s_rule_call_cd)) OR

Line 194: App_Exception.Raise_Exception;

190: new_references.s_rule_call_cd
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: END Check_Parent_Existance;
198:

Line 250: App_Exception.Raise_Exception;

246: IF (cur_rowid%FOUND) THEN
247: Close cur_rowid;
248: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CVR_CRV_FK');
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: Return;
252: END IF;
253: Close cur_rowid;
254:

Line 276: App_Exception.Raise_Exception;

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

Line 302: App_Exception.Raise_Exception;

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

Line 348: App_Exception.Raise_Exception;

344: new_references.s_rule_call_cd
345: ) THEN
346: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
347: IGS_GE_MSG_STACK.ADD;
348: App_Exception.Raise_Exception;
349: END IF;
350: Check_Constraints;
351: Check_Parent_Existance;
352: ELSIF (p_action = 'UPDATE') THEN

Line 368: App_Exception.Raise_Exception;

364: new_references.s_rule_call_cd
365: ) THEN
366: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
367: IGS_GE_MSG_STACK.ADD;
368: App_Exception.Raise_Exception;
369: END IF;
370: Check_Constraints;
371: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
372: Check_Constraints;

Line 421: app_exception.raise_exception;

417: end if;
418: else
419: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
420: IGS_GE_MSG_STACK.ADD;
421: app_exception.raise_exception;
422: end if;
423:
424:
425: Before_DML(

Line 493: app_exception.raise_exception;

489: if (c1%notfound) then
490: close c1;
491: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: return;
495: end if;
496: close c1;
497:

Line 504: app_exception.raise_exception;

500: null;
501: else
502: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506: return;
507: end LOCK_ROW;
508:

Line 537: app_exception.raise_exception;

533: end if;
534: else
535: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
536: IGS_GE_MSG_STACK.ADD;
537: app_exception.raise_exception;
538: end if;
539: Before_DML(
540: p_action => 'UPDATE',
541: x_rowid => X_ROWID,