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_AD_TRANSCRIPT_PKG dependencies on FND_MESSAGE

Line 30: Fnd_Message.Set_Name('IGS','IGS_AD_DUP_DATE_OF_ISSUE');

26: OPEN check_issuedate(new_references.education_id,new_references.date_of_issue);
27: FETCH check_issuedate INTO l_temp;
28: CLOSE check_issuedate;
29: IF l_temp IS NOT NULL THEN
30: Fnd_Message.Set_Name('IGS','IGS_AD_DUP_DATE_OF_ISSUE');
31: IGS_GE_MSG_STACK.ADD;
32: app_Exception.Raise_Exception;
33: END IF;
34:

Line 66: Fnd_Message.Set_Name('IGS','IGS_AD_INACTIVE_ACAD_HIST');

62: FETCH check_status INTO l_temp;
63: CLOSE check_status;
64:
65: IF l_temp IS NOT NULL THEN
66: Fnd_Message.Set_Name('IGS','IGS_AD_INACTIVE_ACAD_HIST');
67: IGS_GE_MSG_STACK.ADD;
68: app_Exception.Raise_Exception;
69: END IF;
70:

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

135: Open cur_old_ref_values;
136: Fetch cur_old_ref_values INTO old_references;
137: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
138: Close cur_old_ref_values;
139: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: Return;
143: END IF;

Line 236: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

232: -- The following code checks for check constraints on the Columns.
233: IF Upper(Column_Name) = 'PERCENTILE_RANK' OR
234: Column_Name IS NULL THEN
235: IF NOT ( (new_references.percentile_rank >= 0) AND (new_references.percentile_rank <= 100) ) THEN
236: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERCENTILE_RANK'));
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;

Line 237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERCENTILE_RANK'));

233: IF Upper(Column_Name) = 'PERCENTILE_RANK' OR
234: Column_Name IS NULL THEN
235: IF NOT ( (new_references.percentile_rank >= 0) AND (new_references.percentile_rank <= 100) ) THEN
236: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERCENTILE_RANK'));
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;
241: END IF;

Line 247: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

243: -- The following code checks for check constraints on the Columns.
244: IF Upper(Column_Name) = 'QUARTILE_RANK' OR
245: Column_Name IS NULL THEN
246: IF NOT ( (new_references.quartile_rank >0) AND (new_references.quartile_rank <= 4) ) THEN
247: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
248: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_QUARTILE_RANK'));
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;

Line 248: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_QUARTILE_RANK'));

244: IF Upper(Column_Name) = 'QUARTILE_RANK' OR
245: Column_Name IS NULL THEN
246: IF NOT ( (new_references.quartile_rank >0) AND (new_references.quartile_rank <= 4) ) THEN
247: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
248: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_QUARTILE_RANK'));
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252: END IF;

Line 258: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

254: -- The following code checks for check constraints on the Columns.
255: IF Upper(Column_Name) = 'QUINTILE_RANK' OR
256: Column_Name IS NULL THEN
257: IF NOT ( (new_references.quintile_rank > 0) AND (new_references.quintile_rank <= 5) ) THEN
258: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_QUINTILE_RANK'));
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;

Line 259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_QUINTILE_RANK'));

255: IF Upper(Column_Name) = 'QUINTILE_RANK' OR
256: Column_Name IS NULL THEN
257: IF NOT ( (new_references.quintile_rank > 0) AND (new_references.quintile_rank <= 5) ) THEN
258: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_QUINTILE_RANK'));
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;

Line 269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

265: -- The following code checks for check constraints on the Columns.
266: IF Upper(Column_Name) = 'DECILE_RANK' OR
267: Column_Name IS NULL THEN
268: IF NOT ( (new_references.decile_rank > 0) AND (new_references.decile_rank <= 10) ) THEN
269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DECILE_RANK'));
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;

Line 270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DECILE_RANK'));

266: IF Upper(Column_Name) = 'DECILE_RANK' OR
267: Column_Name IS NULL THEN
268: IF NOT ( (new_references.decile_rank > 0) AND (new_references.decile_rank <= 10) ) THEN
269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DECILE_RANK'));
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: END IF;

Line 280: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

276: -- The following code checks for check constraints on the Columns.
277: IF Upper(Column_Name) = 'APPROXIMATE_RANK' OR
278: Column_Name IS NULL THEN
279: IF NOT (new_references.approximate_rank in ('Y','N')) THEN
280: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPROXIMATE_RANK'));
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;

Line 281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPROXIMATE_RANK'));

277: IF Upper(Column_Name) = 'APPROXIMATE_RANK' OR
278: Column_Name IS NULL THEN
279: IF NOT (new_references.approximate_rank in ('Y','N')) THEN
280: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPROXIMATE_RANK'));
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: END IF;

Line 291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

287: -- The following code checks for check constraints on the Columns.
288: IF Upper(Column_Name) = 'WEIGHTED_RANK' OR
289: Column_Name IS NULL THEN
290: IF NOT (new_references.weighted_rank in ('Y','N')) THEN
291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_WEIGHTED_RANK'));
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: END IF;

Line 292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_WEIGHTED_RANK'));

288: IF Upper(Column_Name) = 'WEIGHTED_RANK' OR
289: Column_Name IS NULL THEN
290: IF NOT (new_references.weighted_rank in ('Y','N')) THEN
291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_WEIGHTED_RANK'));
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: END IF;
296: END IF;

Line 302: FND_MESSAGE.SET_NAME('IGS','IGS_SS_DSRD_RANK_NONEGATE');

298: -- The following code checks for check constraints on the Columns.
299: IF Upper(Column_Name) = 'RANK_IN_CLASS' OR
300: Column_Name IS NULL THEN
301: IF NOT (new_references.rank_in_class > 0) THEN
302: FND_MESSAGE.SET_NAME('IGS','IGS_SS_DSRD_RANK_NONEGATE');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: END IF;

Line 312: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CLASS_SIZE');

308: -- The following code checks for check constraints on the Columns.
309: IF Upper(Column_Name) = 'CLASS_SIZE' OR
310: Column_Name IS NULL THEN
311: IF NOT (new_references.class_size > 0) THEN
312: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CLASS_SIZE');
313: IGS_GE_MSG_STACK.ADD;
314: App_Exception.Raise_Exception;
315: END IF;
316: END IF;

Line 321: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

317:
318: IF Upper(Column_Name) = 'TRANSCRIPT_TYPE' OR
319: Column_Name IS NULL THEN
320: IF NOT (new_references.transcript_type in ('OFFICIAL','UNOFFICIAL')) THEN
321: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));
323: IGS_GE_MSG_STACK.ADD;
324: App_Exception.Raise_Exception;
325: END IF;

Line 322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));

318: IF Upper(Column_Name) = 'TRANSCRIPT_TYPE' OR
319: Column_Name IS NULL THEN
320: IF NOT (new_references.transcript_type in ('OFFICIAL','UNOFFICIAL')) THEN
321: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));
323: IGS_GE_MSG_STACK.ADD;
324: App_Exception.Raise_Exception;
325: END IF;
326: END IF;

Line 332: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

328: -- The following code checks for check constraints on the Columns.
329: IF Upper(Column_Name) = 'OVERRIDE' OR
330: Column_Name IS NULL THEN
331: IF NOT (new_references.override in ('Y','N')) THEN
332: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_OVERRIDE'));
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;

Line 333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_OVERRIDE'));

329: IF Upper(Column_Name) = 'OVERRIDE' OR
330: Column_Name IS NULL THEN
331: IF NOT (new_references.override in ('Y','N')) THEN
332: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_OVERRIDE'));
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337: END IF;

Line 343: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DATOFISSUE');

339: -- The following code checks for check constraints on the Columns.
340: IF Upper(Column_Name) = 'DATE_OF_ISSUE' OR
341: Column_Name IS NULL THEN
342: IF (new_references.date_of_issue > SYSDATE ) THEN
343: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DATOFISSUE');
344: IGS_GE_MSG_STACK.ADD;
345: App_Exception.Raise_Exception;
346: END IF;
347: IF (new_references.date_of_issue > new_references.date_of_receipt ) THEN

Line 348: Fnd_Message.Set_Name('IGS','IGS_AD_INV_DATOFISSUE');

344: IGS_GE_MSG_STACK.ADD;
345: App_Exception.Raise_Exception;
346: END IF;
347: IF (new_references.date_of_issue > new_references.date_of_receipt ) THEN
348: Fnd_Message.Set_Name('IGS','IGS_AD_INV_DATOFISSUE');
349: IGS_GE_MSG_STACK.ADD;
350: app_Exception.Raise_Exception;
351: END IF;
352: END IF;

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

375:
376: /* ELSIF NOT Igs_Ad_Acad_History_Pkg.Get_PK_For_Validation (
377: new_references.education_id
378: ) THEN
379: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;*/ -- not needed after TCA changes
382: END IF;
383:

Line 392: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

388: new_references.conv_gs_id,
389: 'GRADING_SCALE_TYPES',
390: 'N'
391: ) THEN
392: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CONV_GRAD_SCALE'));
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;

Line 393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CONV_GRAD_SCALE'));

389: 'GRADING_SCALE_TYPES',
390: 'N'
391: ) THEN
392: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CONV_GRAD_SCALE'));
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;
397:

Line 406: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

402: new_references.transcript_source,
403: 'TRANSCRIPT_SOURCE',
404: 'N'
405: ) THEN
406: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_SOURCE'));
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception;
410: END IF;

Line 407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_SOURCE'));

403: 'TRANSCRIPT_SOURCE',
404: 'N'
405: ) THEN
406: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_SOURCE'));
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception;
410: END IF;
411:

Line 420: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

416: new_references.entered_gs_id,
417: 'GRADING_SCALE_TYPES',
418: 'N'
419: ) THEN
420: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENTERED_GRAD_SCALE'));
422: IGS_GE_MSG_STACK.ADD;
423: App_Exception.Raise_Exception;
424: END IF;

Line 421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENTERED_GRAD_SCALE'));

417: 'GRADING_SCALE_TYPES',
418: 'N'
419: ) THEN
420: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENTERED_GRAD_SCALE'));
422: IGS_GE_MSG_STACK.ADD;
423: App_Exception.Raise_Exception;
424: END IF;
425:

Line 433: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

429: ELSIF NOT Igs_LookUps_View_Pkg.Get_PK_For_Validation (
430: 'TERM_TYPE',
431: new_references.term_type
432: ) THEN
433: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_TYPE'));
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END IF;

Line 434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_TYPE'));

430: 'TERM_TYPE',
431: new_references.term_type
432: ) THEN
433: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_TYPE'));
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END IF;
438:

Line 446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

442: ELSIF NOT Igs_LookUps_View_Pkg.Get_PK_For_Validation (
443: 'TRANSCRIPT_STATUS',
444: new_references.transcript_status
445: ) THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_STATUS'));
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;

Line 447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_STATUS'));

443: 'TRANSCRIPT_STATUS',
444: new_references.transcript_status
445: ) THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_STATUS'));
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;
451:

Line 460: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

456: ELSIF NOT Igs_LookUps_View_Pkg.Get_PK_For_Validation (
457: 'TRANSCRIPT_TYPE',
458: new_references.transcript_type
459: ) THEN
460: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));
462: IGS_GE_MSG_STACK.ADD;
463: App_Exception.Raise_Exception;
464: END IF;

Line 461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));

457: 'TRANSCRIPT_TYPE',
458: new_references.transcript_type
459: ) THEN
460: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));
462: IGS_GE_MSG_STACK.ADD;
463: App_Exception.Raise_Exception;
464: END IF;
465:

Line 552: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_AAHST_FK');

548: Open cur_rowid;
549: Fetch cur_rowid INTO lv_rowid;
550: IF (cur_rowid%FOUND) THEN
551: Close cur_rowid;
552: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_AAHST_FK');
553: IGS_GE_MSG_STACK.ADD;
554: App_Exception.Raise_Exception;
555: Return;
556: END IF;

Line 604: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK1');

600: Open cur_rowid;
601: Fetch cur_rowid INTO lv_rowid;
602: IF (cur_rowid%FOUND) THEN
603: Close cur_rowid;
604: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK1');
605: IGS_GE_MSG_STACK.ADD;
606: App_Exception.Raise_Exception;
607: Return;
608: END IF;

Line 614: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK3');

610: Open cur_rowid2;
611: Fetch cur_rowid2 INTO lv_rowid2;
612: IF (cur_rowid2%FOUND) THEN
613: Close cur_rowid2;
614: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK3');
615: IGS_GE_MSG_STACK.ADD;
616: App_Exception.Raise_Exception;
617: Return;
618: END IF;

Line 624: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK2');

620: Open cur_rowid3;
621: Fetch cur_rowid3 INTO lv_rowid3;
622: IF (cur_rowid3%FOUND) THEN
623: Close cur_rowid3;
624: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRN_ACDC_FK2');
625: IGS_GE_MSG_STACK.ADD;
626: App_Exception.Raise_Exception;
627: Return;
628: END IF;

Line 727: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

723: -- Call all the procedures related to Before Insert.
724: Null;
725: IF Get_Pk_For_Validation(
726: new_references.transcript_id) THEN
727: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
728: IGS_GE_MSG_STACK.ADD;
729: App_Exception.Raise_Exception;
730: END IF;
731: Check_Constraints;

Line 750: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

746: ELSIF (p_action = 'VALIDATE_INSERT') THEN
747: -- Call all the procedures related to Before Insert.
748: IF Get_PK_For_Validation (
749: new_references.transcript_id) THEN
750: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
751: IGS_GE_MSG_STACK.ADD;
752: App_Exception.Raise_Exception;
753: END IF;
754: Check_Constraints;

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

907: else
908: X_PROGRAM_UPDATE_DATE := SYSDATE;
909: end if;
910: else
911: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
912: IGS_GE_MSG_STACK.ADD;
913: app_exception.raise_exception;
914: end if;
915: -- X_TRANSCRIPT_ID := -1;

Line 1051: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

1047: x_rowid => X_ROWID );
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1051: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1052: fnd_message.set_token ('ERR_CD', SQLCODE);
1053: igs_ge_msg_stack.add;
1054: igs_sc_gen_001.unset_ctx('R');
1055: app_exception.raise_exception;

Line 1052: fnd_message.set_token ('ERR_CD', SQLCODE);

1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1051: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1052: fnd_message.set_token ('ERR_CD', SQLCODE);
1053: igs_ge_msg_stack.add;
1054: igs_sc_gen_001.unset_ctx('R');
1055: app_exception.raise_exception;
1056: ELSE

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

1137: begin
1138: open c1;
1139: fetch c1 into tlinfo;
1140: if (c1%notfound) then
1141: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1142: IGS_GE_MSG_STACK.ADD;
1143: close c1;
1144: app_exception.raise_exception;
1145: return;

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

1203: OR ((tlinfo.CORE_CURRICULUM_VALUE is null)
1204: AND (X_CORE_CURRICULUM_VALUE is null)))
1205: then null;
1206: else
1207: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1208: IGS_GE_MSG_STACK.ADD;
1209: app_exception.raise_exception;
1210: end if;
1211: return;

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

1280: if X_LAST_UPDATE_LOGIN is NULL then
1281: X_LAST_UPDATE_LOGIN := -1;
1282: end if;
1283: else
1284: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1285: IGS_GE_MSG_STACK.ADD;
1286: app_exception.raise_exception;
1287: end if;
1288: Before_DML(

Line 1374: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1370: -- Added for new field Ravishar / 14-sep-2004
1371: CORE_CURRICULUM_VALUE = X_CORE_CURRICULUM_VALUE
1372: where ROWID = X_ROWID;
1373: if (sql%notfound) then
1374: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1375: igs_ge_msg_stack.add;
1376: igs_sc_gen_001.unset_ctx('R');
1377: app_exception.raise_exception;
1378: end if;

Line 1391: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

1387: );
1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: IF (SQLCODE = (-28115)) THEN
1391: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1392: fnd_message.set_token ('ERR_CD', SQLCODE);
1393: igs_ge_msg_stack.add;
1394: igs_sc_gen_001.unset_ctx('R');
1395: app_exception.raise_exception;

Line 1392: fnd_message.set_token ('ERR_CD', SQLCODE);

1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: IF (SQLCODE = (-28115)) THEN
1391: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1392: fnd_message.set_token ('ERR_CD', SQLCODE);
1393: igs_ge_msg_stack.add;
1394: igs_sc_gen_001.unset_ctx('R');
1395: app_exception.raise_exception;
1396: ELSE

Line 1548: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1544: END IF;
1545: delete from IGS_AD_TRANSCRIPT
1546: where ROWID = X_ROWID;
1547: if (sql%notfound) then
1548: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1549: igs_ge_msg_stack.add;
1550: igs_sc_gen_001.unset_ctx('R');
1551: app_exception.raise_exception;
1552: end if;