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_AS_SUA_SES_ATTS_PKG dependencies on FND_MSG_PUB

Line 92: FND_MSG_PUB.ADD;

88: x_session_name => new_references.session_name,
89: x_uoo_id => new_references.uoo_id
90: ) THEN
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
92: FND_MSG_PUB.ADD;
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:
96: IF NOT igs_en_su_Attempt_pkg.get_pk_for_validation(x_person_id => new_references.person_id ,

Line 101: FND_MSG_PUB.ADD;

97: x_course_cd => new_references.course_cd,
98: x_uoo_id => new_references.uoo_id)
99: THEN
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:
105: END check_parent_existance;

Line 251: FND_MSG_PUB.initialize;

247: x_last_updated_by NUMBER;
248: x_last_update_login NUMBER;
249:
250: BEGIN
251: FND_MSG_PUB.initialize;
252:
253: x_last_update_date := SYSDATE;
254: IF (x_mode = 'I') THEN
255: x_last_updated_by := 1;

Line 323: FND_MSG_PUB.Count_And_Get(

319: -- Initialize API return status to success.
320: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
321: -- Standard call to get message count and if count is 1, get message
322: -- info.
323: FND_MSG_PUB.Count_And_Get(
324: p_encoded => FND_API.G_FALSE,
325: p_count => x_MSG_COUNT,
326: p_data => X_MSG_DATA);
327:

Line 332: FND_MSG_PUB.Count_And_Get(

328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: igs_sc_gen_001.unset_ctx('R');
331: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get(
333: p_encoded => FND_API.G_FALSE,
334: p_count => x_MSG_COUNT,
335: p_data => X_MSG_DATA);
336: RETURN;

Line 340: FND_MSG_PUB.Count_And_Get(

336: RETURN;
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: igs_sc_gen_001.unset_ctx('R');
339: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get(
341: p_encoded => FND_API.G_FALSE,
342: p_count => x_MSG_COUNT,
343: p_data => X_MSG_DATA);
344: RETURN;

Line 350: FND_MSG_PUB.ADD;

346: igs_sc_gen_001.unset_ctx('R');
347: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
348: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
349: fnd_message.set_token ('ERR_CD', SQLCODE);
350: FND_MSG_PUB.ADD;
351: FND_MSG_PUB.Count_And_Get(
352: p_encoded => FND_API.G_FALSE,
353: p_count => x_MSG_COUNT,
354: p_data => X_MSG_DATA);

Line 351: FND_MSG_PUB.Count_And_Get(

347: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
348: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
349: fnd_message.set_token ('ERR_CD', SQLCODE);
350: FND_MSG_PUB.ADD;
351: FND_MSG_PUB.Count_And_Get(
352: p_encoded => FND_API.G_FALSE,
353: p_count => x_MSG_COUNT,
354: p_data => X_MSG_DATA);
355: ELSE

Line 359: FND_MSG_PUB.ADD;

355: ELSE
356: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
358: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
359: FND_MSG_PUB.ADD;
360: FND_MSG_PUB.Count_And_Get(
361: p_encoded => FND_API.G_FALSE,
362: p_count => x_MSG_COUNT,
363: p_data => X_MSG_DATA);

Line 360: FND_MSG_PUB.Count_And_Get(

356: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
358: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
359: FND_MSG_PUB.ADD;
360: FND_MSG_PUB.Count_And_Get(
361: p_encoded => FND_API.G_FALSE,
362: p_count => x_MSG_COUNT,
363: p_data => X_MSG_DATA);
364: END IF;

Line 399: FND_MSG_PUB.initialize;

395:
396: tlinfo c1%ROWTYPE;
397:
398: BEGIN
399: FND_MSG_PUB.initialize;
400:
401: OPEN c1;
402: FETCH c1 INTO tlinfo;
403: IF (c1%notfound) THEN

Line 426: FND_MSG_PUB.Count_And_Get(

422: -- Initialize API return status to success.
423: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
424: -- Standard call to get message count and if count is 1, get message
425: -- info.
426: FND_MSG_PUB.Count_And_Get(
427: p_encoded => FND_API.G_FALSE,
428: p_count => x_MSG_COUNT,
429: p_data => X_MSG_DATA);
430:

Line 434: FND_MSG_PUB.Count_And_Get(

430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
434: FND_MSG_PUB.Count_And_Get(
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_MSG_COUNT,
437: p_data => X_MSG_DATA);
438: RETURN;

Line 441: FND_MSG_PUB.Count_And_Get(

437: p_data => X_MSG_DATA);
438: RETURN;
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_MSG_COUNT,
444: p_data => X_MSG_DATA);
445: RETURN;

Line 450: FND_MSG_PUB.ADD;

446: WHEN OTHERS THEN
447: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
449: FND_MESSAGE.SET_TOKEN('NAME','lock_row : '||SQLERRM);
450: FND_MSG_PUB.ADD;
451: FND_MSG_PUB.Count_And_Get(
452: p_encoded => FND_API.G_FALSE,
453: p_count => x_MSG_COUNT,
454: p_data => X_MSG_DATA);

Line 451: FND_MSG_PUB.Count_And_Get(

447: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
449: FND_MESSAGE.SET_TOKEN('NAME','lock_row : '||SQLERRM);
450: FND_MSG_PUB.ADD;
451: FND_MSG_PUB.Count_And_Get(
452: p_encoded => FND_API.G_FALSE,
453: p_count => x_MSG_COUNT,
454: p_data => X_MSG_DATA);
455: RETURN;

Line 487: FND_MSG_PUB.initialize;

483: x_last_updated_by NUMBER;
484: x_last_update_login NUMBER;
485:
486: BEGIN
487: FND_MSG_PUB.initialize;
488:
489: x_last_update_date := SYSDATE;
490: IF (X_MODE = 'I') THEN
491: x_last_updated_by := 1;

Line 550: FND_MSG_PUB.Count_And_Get(

546: -- Initialize API return status to success.
547: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
548: -- Standard call to get message count and if count is 1, get message
549: -- info.
550: FND_MSG_PUB.Count_And_Get(
551: p_encoded => FND_API.G_FALSE,
552: p_count => x_MSG_COUNT,
553: p_data => X_MSG_DATA);
554:

Line 558: FND_MSG_PUB.Count_And_Get(

554:
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN
557: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
558: FND_MSG_PUB.Count_And_Get(
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_MSG_COUNT,
561: p_data => X_MSG_DATA);
562: RETURN;

Line 565: FND_MSG_PUB.Count_And_Get(

561: p_data => X_MSG_DATA);
562: RETURN;
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Count_And_Get(
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_MSG_COUNT,
568: p_data => X_MSG_DATA);
569: RETURN;

Line 575: FND_MSG_PUB.ADD;

571: igs_sc_gen_001.unset_ctx('R');
572: IF (SQLCODE = (-28115)) THEN
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
574: fnd_message.set_token ('ERR_CD', SQLCODE);
575: FND_MSG_PUB.ADD;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_MSG_COUNT,
579: p_data => X_MSG_DATA);

Line 576: FND_MSG_PUB.Count_And_Get(

572: IF (SQLCODE = (-28115)) THEN
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
574: fnd_message.set_token ('ERR_CD', SQLCODE);
575: FND_MSG_PUB.ADD;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_MSG_COUNT,
579: p_data => X_MSG_DATA);
580: ELSE

Line 584: FND_MSG_PUB.ADD;

580: ELSE
581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
582: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
584: FND_MSG_PUB.ADD;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);

Line 585: FND_MSG_PUB.Count_And_Get(

581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
582: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
584: FND_MSG_PUB.ADD;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589:

Line 625: FND_MSG_PUB.initialize;

621: AND uoo_id = x_uoo_id
622: AND session_name = x_session_name;
623:
624: BEGIN
625: FND_MSG_PUB.initialize;
626:
627: OPEN c1;
628: FETCH c1 INTO x_rowid;
629: IF (c1%NOTFOUND) THEN

Line 665: FND_MSG_PUB.Count_And_Get(

661: -- Initialize API return status to success.
662: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
663: -- Standard call to get message count and if count is 1, get message
664: -- info.
665: FND_MSG_PUB.Count_And_Get(
666: p_encoded => FND_API.G_FALSE,
667: p_count => x_MSG_COUNT,
668: p_data => X_MSG_DATA);
669:

Line 673: FND_MSG_PUB.Count_And_Get(

669:
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
673: FND_MSG_PUB.Count_And_Get(
674: p_encoded => FND_API.G_FALSE,
675: p_count => x_MSG_COUNT,
676: p_data => X_MSG_DATA);
677: RETURN;

Line 680: FND_MSG_PUB.Count_And_Get(

676: p_data => X_MSG_DATA);
677: RETURN;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.Count_And_Get(
681: p_encoded => FND_API.G_FALSE,
682: p_count => x_MSG_COUNT,
683: p_data => X_MSG_DATA);
684: RETURN;

Line 689: FND_MSG_PUB.ADD;

685: WHEN OTHERS THEN
686: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
687: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
688: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
689: FND_MSG_PUB.ADD;
690: FND_MSG_PUB.Count_And_Get(
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_MSG_COUNT,
693: p_data => X_MSG_DATA);

Line 690: FND_MSG_PUB.Count_And_Get(

686: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
687: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
688: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
689: FND_MSG_PUB.ADD;
690: FND_MSG_PUB.Count_And_Get(
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_MSG_COUNT,
693: p_data => X_MSG_DATA);
694: RETURN;

Line 717: FND_MSG_PUB.initialize;

713: || (reverse chronological order - newest change first)
714: */
715: BEGIN
716:
717: FND_MSG_PUB.initialize;
718:
719: before_dml (
720: p_action => 'DELETE',
721: x_rowid => x_rowid

Line 745: FND_MSG_PUB.Count_And_Get(

741: -- Initialize API return status to success.
742: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
743: -- Standard call to get message count and if count is 1, get message
744: -- info.
745: FND_MSG_PUB.Count_And_Get(
746: p_encoded => FND_API.G_FALSE,
747: p_count => x_MSG_COUNT,
748: p_data => X_MSG_DATA);
749:

Line 753: FND_MSG_PUB.Count_And_Get(

749:
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
753: FND_MSG_PUB.Count_And_Get(
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_MSG_COUNT,
756: p_data => X_MSG_DATA);
757: RETURN;

Line 760: FND_MSG_PUB.Count_And_Get(

756: p_data => X_MSG_DATA);
757: RETURN;
758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
759: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
760: FND_MSG_PUB.Count_And_Get(
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_MSG_COUNT,
763: p_data => X_MSG_DATA);
764: RETURN;

Line 769: FND_MSG_PUB.ADD;

765: WHEN OTHERS THEN
766: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
768: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
769: FND_MSG_PUB.ADD;
770: FND_MSG_PUB.Count_And_Get(
771: p_encoded => FND_API.G_FALSE,
772: p_count => x_MSG_COUNT,
773: p_data => X_MSG_DATA);

Line 770: FND_MSG_PUB.Count_And_Get(

766: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
768: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
769: FND_MSG_PUB.ADD;
770: FND_MSG_PUB.Count_And_Get(
771: p_encoded => FND_API.G_FALSE,
772: p_count => x_MSG_COUNT,
773: p_data => X_MSG_DATA);
774: RETURN;