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

Line 59: App_Exception.Raise_Exception;

55: Fetch cur_old_ref_values INTO old_references;
56: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
57: Close cur_old_ref_values;
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: App_Exception.Raise_Exception;
60: Return;
61: END IF;
62: Close cur_old_ref_values;
63:

Line 202: App_Exception.Raise_Exception ;

198:
199: IF upper(Column_name) = 'AWARD_CD' OR COLUMN_NAME IS NULL THEN
200: IF new_references.AWARD_CD<> upper(new_references.AWARD_CD) then
201: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
202: App_Exception.Raise_Exception ;
203: END IF;
204:
205: END IF ;
206:

Line 210: App_Exception.Raise_Exception ;

206:
207: IF upper(Column_name) = 'AWARD_COURSE_CD' OR COLUMN_NAME IS NULL THEN
208: IF new_references.AWARD_COURSE_CD<> upper(new_references.AWARD_COURSE_CD) then
209: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
210: App_Exception.Raise_Exception ;
211: END IF;
212:
213: END IF ;
214:

Line 219: App_Exception.Raise_Exception ;

215:
216: IF upper(Column_name) = 'CONVOCATION_MEMBERSHIP_IND' OR COLUMN_NAME IS NULL THEN
217: IF new_references.CONVOCATION_MEMBERSHIP_IND<> upper(new_references.CONVOCATION_MEMBERSHIP_IND) then
218: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
219: App_Exception.Raise_Exception ;
220: END IF;
221:
222: END IF ;
223:

Line 227: App_Exception.Raise_Exception ;

223:
224: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
225: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
226: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
227: App_Exception.Raise_Exception ;
228: END IF;
229:
230: END IF ;
231:

Line 235: App_Exception.Raise_Exception ;

231:
232: IF upper(Column_name) = 'GRADUAND_APPR_STATUS' OR COLUMN_NAME IS NULL THEN
233: IF new_references.GRADUAND_APPR_STATUS<> upper(new_references.GRADUAND_APPR_STATUS) then
234: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
235: App_Exception.Raise_Exception ;
236: END IF;
237:
238: END IF ;
239:

Line 243: App_Exception.Raise_Exception ;

239:
240: IF upper(Column_name) = 'GRADUAND_STATUS' OR COLUMN_NAME IS NULL THEN
241: IF new_references.GRADUAND_STATUS<> upper(new_references.GRADUAND_STATUS) then
242: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
243: App_Exception.Raise_Exception ;
244: END IF;
245:
246: END IF ;
247:

Line 251: App_Exception.Raise_Exception ;

247:
248: IF upper(Column_name) = 'S_GRADUAND_TYPE' OR COLUMN_NAME IS NULL THEN
249: IF new_references.S_GRADUAND_TYPE<> upper(new_references.S_GRADUAND_TYPE) then
250: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
251: App_Exception.Raise_Exception ;
252: END IF;
253:
254: END IF ;
255:

Line 259: App_Exception.Raise_Exception ;

255:
256: IF upper(Column_name) = 'HIST_WHO' OR COLUMN_NAME IS NULL THEN
257: IF new_references.HIST_WHO<> upper(new_references.HIST_WHO) then
258: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
259: App_Exception.Raise_Exception ;
260: END IF;
261:
262: END IF ;
263:

Line 268: App_Exception.Raise_Exception ;

264:
265: IF upper(Column_name) = 'PROXY_AWARD_IND' OR COLUMN_NAME IS NULL THEN
266: IF new_references.PROXY_AWARD_IND<> upper(new_references.PROXY_AWARD_IND) then
267: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
268: App_Exception.Raise_Exception ;
269: END IF;
270:
271: END IF ;
272:

Line 276: App_Exception.Raise_Exception ;

272:
273: IF upper(Column_name) = 'SUR_FOR_AWARD_CD' OR COLUMN_NAME IS NULL THEN
274: IF new_references.SUR_FOR_AWARD_CD<> upper(new_references.SUR_FOR_AWARD_CD) then
275: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
276: App_Exception.Raise_Exception ;
277: END IF;
278:
279: END IF ;
280:

Line 284: App_Exception.Raise_Exception ;

280:
281: IF upper(Column_name) = 'SUR_FOR_COURSE_CD' OR COLUMN_NAME IS NULL THEN
282: IF new_references.SUR_FOR_COURSE_CD<> upper(new_references.SUR_FOR_COURSE_CD) then
283: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
284: App_Exception.Raise_Exception ;
285: END IF;
286:
287: END IF ;
288:

Line 292: App_Exception.Raise_Exception ;

288:
289: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
290: IF new_references.GRD_CAL_TYPE<> upper(new_references.GRD_CAL_TYPE) then
291: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
292: App_Exception.Raise_Exception ;
293: END IF;
294:
295: END IF ;
296:

Line 300: App_Exception.Raise_Exception ;

296:
297: IF upper(Column_name) = 'PERSON_ID' OR COLUMN_NAME IS NULL THEN
298: IF new_references.PERSON_ID < 0 OR new_references.PERSON_ID > 9999999999 then
299: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
300: App_Exception.Raise_Exception ;
301: END IF;
302:
303: END IF ;
304:

Line 308: App_Exception.Raise_Exception ;

304:
305: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
306: IF new_references.GRD_CI_SEQUENCE_NUMBER < 1 OR new_references.GRD_CI_SEQUENCE_NUMBER > 999999 then
307: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
308: App_Exception.Raise_Exception ;
309: END IF;
310:
311: END IF ;
312:

Line 316: App_Exception.Raise_Exception ;

312:
313: IF upper(Column_name) = 'AWARD_CRS_VERSION_NUMBER' OR COLUMN_NAME IS NULL THEN
314: IF new_references.AWARD_CRS_VERSION_NUMBER < 0 OR new_references.AWARD_CRS_VERSION_NUMBER > 999 then
315: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
316: App_Exception.Raise_Exception ;
317: END IF;
318:
319: END IF ;
320:

Line 324: App_Exception.Raise_Exception ;

320:
321: IF upper(Column_name) = 'S_GRADUAND_TYPE' OR COLUMN_NAME IS NULL THEN
322: IF new_references.S_GRADUAND_TYPE not in ( 'ATTENDING' , 'INABSENTIA' , 'ARTICULATE' , 'DEFERRED' , 'UNKNOWN' , 'DECLINED' ) then
323: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
324: App_Exception.Raise_Exception ;
325: END IF;
326: END IF ;
327:
328: IF upper(Column_name) = 'PROXY_AWARD_IND' OR COLUMN_NAME IS NULL THEN

Line 331: App_Exception.Raise_Exception ;

327:
328: IF upper(Column_name) = 'PROXY_AWARD_IND' OR COLUMN_NAME IS NULL THEN
329: IF new_references.PROXY_AWARD_IND not in ('Y','N') then
330: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
331: App_Exception.Raise_Exception ;
332: END IF;
333:
334: END IF ;
335:

Line 339: App_Exception.Raise_Exception ;

335:
336: IF upper(Column_name) = 'PROXY_AWARD_PERSON_ID' OR COLUMN_NAME IS NULL THEN
337: IF new_references.PROXY_AWARD_PERSON_ID < 0 or new_references.PROXY_AWARD_PERSON_ID > 9999999999 then
338: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
339: App_Exception.Raise_Exception ;
340: END IF;
341:
342: END IF ;
343:

Line 347: App_Exception.Raise_Exception ;

343:
344: IF upper(Column_name) = 'CONVOCATION_MEMBERSHIP_IND' OR COLUMN_NAME IS NULL THEN
345: IF new_references.CONVOCATION_MEMBERSHIP_IND not in ('Y','N') then
346: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
347: App_Exception.Raise_Exception ;
348: END IF;
349:
350: END IF ;
351: END CHECK_CONSTRAINTS;

Line 434: App_Exception.Raise_Exception;

430: NEW_REFERENCES.create_dt,
431: NEW_REFERENCES.hist_start_dt
432: ) THEN
433: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
434: App_Exception.Raise_Exception;
435: END IF;
436:
437: check_constraints;
438: ELSIF (p_action = 'UPDATE') THEN

Line 449: App_Exception.Raise_Exception;

445: NEW_REFERENCES.create_dt,
446: NEW_REFERENCES.hist_start_dt
447: ) THEN
448: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
449: App_Exception.Raise_Exception;
450: END IF;
451:
452: check_constraints;
453: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 513: app_exception.raise_exception;

509: X_LAST_UPDATE_LOGIN := -1;
510: end if;
511: else
512: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
513: app_exception.raise_exception;
514: end if;
515:
516: Before_DML (
517: p_action => 'INSERT',

Line 681: app_exception.raise_exception;

677: fetch c1 into tlinfo;
678: if (c1%notfound) then
679: close c1;
680: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
681: app_exception.raise_exception;
682: return;
683: end if;
684: close c1;
685:

Line 747: app_exception.raise_exception;

743: ) then
744: null;
745: else
746: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
747: app_exception.raise_exception;
748: end if;
749: return;
750: end LOCK_ROW;
751:

Line 800: app_exception.raise_exception;

796: X_LAST_UPDATE_LOGIN := -1;
797: end if;
798: else
799: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
800: app_exception.raise_exception;
801: end if;
802:
803: Before_DML (
804: p_action => 'UPDATE',