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

Line 41: FND_MSG_PUB.initialize;

37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:
41: FND_MSG_PUB.initialize;
42:
43: l_rowid := x_rowid;
44:
45: -- Code for setting the Old and New Reference Values.

Line 135: FND_MSG_PUB.ADD;

131: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (
132: x_uoo_id => new_references.uoo_id )
133: THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: FND_MSG_PUB.ADD;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138: END IF;
139: IF new_references.UNIT_SECTION_OCCURRENCE_ID IS NOT NULL THEN

Line 144: FND_MSG_PUB.ADD;

140: IF NOT igs_ps_usec_occurs_pkg.get_pk_for_validation(x_unit_section_occurrence_id =>
141: new_references.UNIT_SECTION_OCCURRENCE_ID)
142: THEN
143: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148: END IF;

Line 257: FND_MSG_PUB.initialize;

253: x_last_updated_by NUMBER;
254: x_last_update_login NUMBER;
255:
256: BEGIN
257: FND_MSG_PUB.initialize;
258:
259: x_last_update_date := SYSDATE;
260: IF (x_mode = 'I') THEN
261: x_last_updated_by := 1;

Line 328: FND_MSG_PUB.Count_And_Get(

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

Line 336: FND_MSG_PUB.Count_And_Get(

332:
333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get(
337: p_encoded => FND_API.G_FALSE,
338: p_count => x_MSG_COUNT,
339: p_data => X_MSG_DATA);
340: RETURN;

Line 343: FND_MSG_PUB.Count_And_Get(

339: p_data => X_MSG_DATA);
340: RETURN;
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get(
344: p_encoded => FND_API.G_FALSE,
345: p_count => x_MSG_COUNT,
346: p_data => X_MSG_DATA);
347: RETURN;

Line 352: FND_MSG_PUB.ADD;

348: WHEN OTHERS THEN
349: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
351: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
352: FND_MSG_PUB.ADD;
353: FND_MSG_PUB.Count_And_Get(
354: p_encoded => FND_API.G_FALSE,
355: p_count => x_MSG_COUNT,
356: p_data => X_MSG_DATA);

Line 353: FND_MSG_PUB.Count_And_Get(

349: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
351: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
352: FND_MSG_PUB.ADD;
353: FND_MSG_PUB.Count_And_Get(
354: p_encoded => FND_API.G_FALSE,
355: p_count => x_MSG_COUNT,
356: p_data => X_MSG_DATA);
357: RETURN;

Line 399: FND_MSG_PUB.initialize;

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

Line 430: FND_MSG_PUB.Count_And_Get(

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

Line 438: FND_MSG_PUB.Count_And_Get(

434:
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
438: FND_MSG_PUB.Count_And_Get(
439: p_encoded => FND_API.G_FALSE,
440: p_count => x_MSG_COUNT,
441: p_data => X_MSG_DATA);
442: RETURN;

Line 445: FND_MSG_PUB.Count_And_Get(

441: p_data => X_MSG_DATA);
442: RETURN;
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
445: FND_MSG_PUB.Count_And_Get(
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_MSG_COUNT,
448: p_data => X_MSG_DATA);
449: RETURN;

Line 454: FND_MSG_PUB.ADD;

450: WHEN OTHERS THEN
451: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
452: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
453: FND_MESSAGE.SET_TOKEN('NAME','Sessions_Lock_Row : '||SQLERRM);
454: FND_MSG_PUB.ADD;
455: FND_MSG_PUB.Count_And_Get(
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_MSG_COUNT,
458: p_data => X_MSG_DATA);

Line 455: FND_MSG_PUB.Count_And_Get(

451: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
452: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
453: FND_MESSAGE.SET_TOKEN('NAME','Sessions_Lock_Row : '||SQLERRM);
454: FND_MSG_PUB.ADD;
455: FND_MSG_PUB.Count_And_Get(
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_MSG_COUNT,
458: p_data => X_MSG_DATA);
459: RETURN;

Line 492: FND_MSG_PUB.initialize;

488: x_last_updated_by NUMBER;
489: x_last_update_login NUMBER;
490:
491: BEGIN
492: FND_MSG_PUB.initialize;
493:
494: x_last_update_date := SYSDATE;
495: IF (X_MODE = 'I') THEN
496: x_last_updated_by := 1;

Line 551: FND_MSG_PUB.Count_And_Get(

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

Line 559: FND_MSG_PUB.Count_And_Get(

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

Line 566: FND_MSG_PUB.Count_And_Get(

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

Line 575: FND_MSG_PUB.ADD;

571: WHEN OTHERS THEN
572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
574: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
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: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
574: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
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: RETURN;

Line 619: FND_MSG_PUB.initialize;

615: L_MSG_DATA VARCHAR2(2000);
616: L_MSG_COUNT NUMBER(10);
617:
618: BEGIN
619: FND_MSG_PUB.initialize;
620:
621: OPEN c1;
622: FETCH c1 INTO x_rowid;
623: IF (c1%NOTFOUND) THEN

Line 663: FND_MSG_PUB.Count_And_Get(

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

Line 671: FND_MSG_PUB.Count_And_Get(

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

Line 678: FND_MSG_PUB.Count_And_Get(

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

Line 687: FND_MSG_PUB.ADD;

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

Line 688: FND_MSG_PUB.Count_And_Get(

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

Line 723: FND_MSG_PUB.initialize;

719: WHERE session_name = p_session_name
720: AND uoo_id = p_uoo_id;
721:
722: BEGIN
723: FND_MSG_PUB.initialize;
724:
725: before_dml (
726: p_action => 'DELETE',
727: x_rowid => x_rowid

Line 764: FND_MSG_PUB.Count_And_Get(

760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get(
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_MSG_COUNT,
767: p_data => X_MSG_DATA);
768: RETURN;

Line 771: FND_MSG_PUB.Count_And_Get(

767: p_data => X_MSG_DATA);
768: RETURN;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
771: FND_MSG_PUB.Count_And_Get(
772: p_encoded => FND_API.G_FALSE,
773: p_count => x_MSG_COUNT,
774: p_data => X_MSG_DATA);
775: RETURN;

Line 780: FND_MSG_PUB.ADD;

776: WHEN OTHERS THEN
777: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
779: FND_MESSAGE.SET_TOKEN('NAME','delete_Row : '||SQLERRM);
780: FND_MSG_PUB.ADD;
781: FND_MSG_PUB.Count_And_Get(
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_MSG_COUNT,
784: p_data => X_MSG_DATA);

Line 781: FND_MSG_PUB.Count_And_Get(

777: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
779: FND_MESSAGE.SET_TOKEN('NAME','delete_Row : '||SQLERRM);
780: FND_MSG_PUB.ADD;
781: FND_MSG_PUB.Count_And_Get(
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_MSG_COUNT,
784: p_data => X_MSG_DATA);
785: RETURN;