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 FND_MESSAGE

Line 58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

54: Open cur_old_ref_values;
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;

Line 201: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

197: END IF ;
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 ;

Line 209: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

205: END IF ;
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 ;

Line 218: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

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

Line 226: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

222: END IF ;
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 ;

Line 234: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

230: END IF ;
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 ;

Line 242: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

238: END IF ;
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 ;

Line 250: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

246: END IF ;
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 ;

Line 258: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

254: END IF ;
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 ;

Line 267: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

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

Line 275: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

271: END IF ;
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 ;

Line 283: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

279: END IF ;
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 ;

Line 291: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

287: END IF ;
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 ;

Line 299: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

295: END IF ;
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 ;

Line 307: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

303: END IF ;
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 ;

Line 315: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

311: END IF ;
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 ;

Line 323: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

319: END IF ;
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:

Line 330: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

326: END IF ;
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 ;

Line 338: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

334: END IF ;
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 ;

Line 346: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

342: END IF ;
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 ;

Line 433: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

429: NEW_REFERENCES.person_id,
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;

Line 448: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

444: NEW_REFERENCES.person_id,
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;

Line 512: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

508: if X_LAST_UPDATE_LOGIN is NULL then
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 (

Line 680: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

676: open c1;
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;

Line 746: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

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

Line 799: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

795: if X_LAST_UPDATE_LOGIN is NULL then
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 (