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

Line 95: App_Exception.Raise_Exception;

91: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
92: Close cur_old_ref_values;
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: Return;
97: END IF;
98: Close cur_old_ref_values;
99:

Line 206: App_Exception.Raise_Exception;

202: IF new_references.generic_course_ind NOT IN ( 'Y' , 'N' )
203: THEN
204: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208: END IF;
209: IF upper(column_name)= 'COUNT_INTRMSN_IN_TIME_IND' OR
210: column_name is null THEN

Line 215: App_Exception.Raise_Exception;

211: IF new_references.count_intrmsn_in_time_ind NOT IN ( 'Y' , 'N' )
212: THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: END IF;
217: END IF;
218: IF upper(column_name)= 'EXTERNAL_ADV_STND_LIMIT' OR
219: column_name is null THEN

Line 225: App_Exception.Raise_Exception;

221: new_references.external_adv_stnd_limit > 9999.999
222: THEN
223: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227: END IF;
228: IF upper(column_name)= 'STD_ANNUAL_LOAD' OR
229: column_name is null THEN

Line 235: App_Exception.Raise_Exception;

231: new_references.std_annual_load > 9999.999
232: THEN
233: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
238: IF upper(column_name)= 'INTERNAL_ADV_STND_LIMIT' OR
239: column_name is null THEN

Line 245: App_Exception.Raise_Exception;

241: new_references.internal_adv_stnd_limit > 9999.999
242: THEN
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
248: IF upper(column_name)= 'INTRMSN_ALLOWED_IND' OR
249: column_name is null THEN

Line 254: App_Exception.Raise_Exception;

250: IF new_references.intrmsn_allowed_ind NOT IN ( 'Y' , 'N' )
251: THEN
252: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
257: IF upper(column_name)= 'GRADUATE_STUDENTS_IND' OR
258: column_name is null THEN

Line 263: App_Exception.Raise_Exception;

259: IF new_references.graduate_students_ind NOT IN ( 'Y' , 'N' )
260: THEN
261: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: END IF;
266: IF upper(column_name)= 'ABBREVIATION' OR
267: column_name is null THEN

Line 272: App_Exception.Raise_Exception;

268: IF new_references.abbreviation<> UPPER(new_references.abbreviation)
269: THEN
270: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: END IF;
275:
276: IF upper(column_name)= 'COURSE_CD' OR

Line 282: App_Exception.Raise_Exception;

278: IF new_references.course_cd <> UPPER(new_references.course_cd )
279: THEN
280: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END IF;
284: END IF;
285:
286: IF upper(column_name)= 'COURSE_STATUS' OR

Line 292: App_Exception.Raise_Exception;

288: IF new_references.course_status <> UPPER(new_references.course_status)
289: THEN
290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: END IF;
295:
296: IF upper(column_name)= 'COURSE_TYPE' OR

Line 302: App_Exception.Raise_Exception;

298: IF new_references.course_type <> UPPER(new_references.course_type)
299: THEN
300: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: END IF;
305: IF upper(column_name)= 'GOVT_SPECIAL_COURSE_TYPE' OR
306: column_name is null THEN

Line 311: App_Exception.Raise_Exception;

307: IF new_references.govt_special_course_type <> UPPER(new_references.govt_special_course_type )
308: THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: END IF;
314:
315: IF upper(column_name)= 'SUPP_EXAM_PERMITTED_IND' OR

Line 321: App_Exception.Raise_Exception;

317: IF new_references.supp_exam_permitted_ind <> UPPER(new_references.supp_exam_permitted_ind )
318: THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: END IF;
324:
325: IF upper(column_name)= 'MAX_WLST_PER_STUD' OR column_name is null THEN

Line 330: App_Exception.Raise_Exception;

326: IF new_references.max_wlst_per_stud < 0 OR
327: new_references.max_wlst_per_stud > 9999 THEN
328: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: END IF;
332: END IF;
333:
334: IF upper(column_name)= 'ANNUAL_INSTRUCTION_TIME' OR column_name is null THEN

Line 339: App_Exception.Raise_Exception;

335: IF new_references.annual_instruction_time < 1 OR
336: new_references.annual_instruction_time > 99.99 THEN
337: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
338: IGS_GE_MSG_STACK.ADD;
339: App_Exception.Raise_Exception;
340: END IF;
341: END IF;
342:
343:

Line 515: App_Exception.Raise_Exception;

511: new_references.hist_start_dt
512: ) THEN
513: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
514: IGS_GE_MSG_STACK.ADD;
515: App_Exception.Raise_Exception;
516: END IF;
517: Check_Constraints;
518: ELSIF (p_action = 'UPDATE') THEN
519: -- Call all the procedures related to Before Update.

Line 531: App_Exception.Raise_Exception;

527: new_references.hist_start_dt
528: ) THEN
529: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
530: IGS_GE_MSG_STACK.ADD;
531: App_Exception.Raise_Exception;
532: END IF;
533: Check_Constraints;
534: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
535: Check_Constraints;

Line 639: app_exception.raise_exception;

635: end if;
636: else
637: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
638: IGS_GE_MSG_STACK.ADD;
639: app_exception.raise_exception;
640: end if;
641: before_dml( p_action => 'INSERT',
642: x_rowid => X_ROWID,
643: x_course_cd => X_COURSE_CD,

Line 940: app_exception.raise_exception;

936: IF (c1%notfound) THEN
937: CLOSE c1;
938: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
939: IGS_GE_MSG_STACK.ADD;
940: app_exception.raise_exception;
941: RETURN;
942: END IF;
943: CLOSE c1;
944:

Line 1077: app_exception.raise_exception;

1073: NULL;
1074: ELSE
1075: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1076: IGS_GE_MSG_STACK.ADD;
1077: app_exception.raise_exception;
1078: END IF;
1079: RETURN;
1080: END lock_row;
1081:

Line 1165: app_exception.raise_exception;

1161: END IF;
1162: ELSE
1163: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1164: IGS_GE_MSG_STACK.ADD;
1165: app_exception.raise_exception;
1166: END IF;
1167: before_dml( p_action => 'UPDATE',
1168: x_rowid => X_ROWID,
1169: x_course_cd => X_COURSE_CD,