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_DA_REQ_WIF_PKG dependencies on FND_API

Line 520: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

516: x_last_updated_by,
517: x_last_update_login
518: ) RETURNING ROWID INTO x_rowid;
519: -- Initialize API return status to success.
520: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
521: -- Standard call to get message count and if count is 1, get message
522: -- info.
523: FND_MSG_PUB.Count_And_Get(
524: p_encoded => FND_API.G_FALSE,

Line 524: p_encoded => FND_API.G_FALSE,

520: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
521: -- Standard call to get message count and if count is 1, get message
522: -- info.
523: FND_MSG_PUB.Count_And_Get(
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_MSG_COUNT,
526: p_data => X_MSG_DATA);
527:
528: EXCEPTION

Line 529: WHEN FND_API.G_EXC_ERROR THEN

525: p_count => x_MSG_COUNT,
526: p_data => X_MSG_DATA);
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get(
532: p_encoded => FND_API.G_FALSE,
533: p_count => x_MSG_COUNT,

Line 530: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

526: p_data => X_MSG_DATA);
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get(
532: p_encoded => FND_API.G_FALSE,
533: p_count => x_MSG_COUNT,
534: p_data => X_MSG_DATA);

Line 532: p_encoded => FND_API.G_FALSE,

528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get(
532: p_encoded => FND_API.G_FALSE,
533: p_count => x_MSG_COUNT,
534: p_data => X_MSG_DATA);
535: RETURN;
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

532: p_encoded => FND_API.G_FALSE,
533: p_count => x_MSG_COUNT,
534: p_data => X_MSG_DATA);
535: RETURN;
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
538: FND_MSG_PUB.Count_And_Get(
539: p_encoded => FND_API.G_FALSE,
540: p_count => x_MSG_COUNT,

Line 537: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

533: p_count => x_MSG_COUNT,
534: p_data => X_MSG_DATA);
535: RETURN;
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
538: FND_MSG_PUB.Count_And_Get(
539: p_encoded => FND_API.G_FALSE,
540: p_count => x_MSG_COUNT,
541: p_data => X_MSG_DATA);

Line 539: p_encoded => FND_API.G_FALSE,

535: RETURN;
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
538: FND_MSG_PUB.Count_And_Get(
539: p_encoded => FND_API.G_FALSE,
540: p_count => x_MSG_COUNT,
541: p_data => X_MSG_DATA);
542: RETURN;
543: WHEN OTHERS THEN

Line 544: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

540: p_count => x_MSG_COUNT,
541: p_data => X_MSG_DATA);
542: RETURN;
543: WHEN OTHERS THEN
544: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
546: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
547: FND_MSG_PUB.ADD;
548: FND_MSG_PUB.Count_And_Get(

Line 549: p_encoded => FND_API.G_FALSE,

545: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
546: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
547: FND_MSG_PUB.ADD;
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,
550: p_count => x_MSG_COUNT,
551: p_data => X_MSG_DATA);
552: RETURN;
553:

Line 637: RAISE FND_API.G_EXC_ERROR;

633: NULL;
634: ELSE
635: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
636: igs_ge_msg_stack.add;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: -- Initialize API return status to success.
641: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 641: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: -- Initialize API return status to success.
641: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
642: -- Standard call to get message count and if count is 1, get message
643: -- info.
644: FND_MSG_PUB.Count_And_Get(
645: p_encoded => FND_API.G_FALSE,

Line 645: p_encoded => FND_API.G_FALSE,

641: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
642: -- Standard call to get message count and if count is 1, get message
643: -- info.
644: FND_MSG_PUB.Count_And_Get(
645: p_encoded => FND_API.G_FALSE,
646: p_count => x_MSG_COUNT,
647: p_data => X_MSG_DATA);
648: RETURN;
649: EXCEPTION

Line 650: WHEN FND_API.G_EXC_ERROR THEN

646: p_count => x_MSG_COUNT,
647: p_data => X_MSG_DATA);
648: RETURN;
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
652: FND_MSG_PUB.Count_And_Get(
653: p_encoded => FND_API.G_FALSE,
654: p_count => x_MSG_COUNT,

Line 651: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

647: p_data => X_MSG_DATA);
648: RETURN;
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
652: FND_MSG_PUB.Count_And_Get(
653: p_encoded => FND_API.G_FALSE,
654: p_count => x_MSG_COUNT,
655: p_data => X_MSG_DATA);

Line 653: p_encoded => FND_API.G_FALSE,

649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
652: FND_MSG_PUB.Count_And_Get(
653: p_encoded => FND_API.G_FALSE,
654: p_count => x_MSG_COUNT,
655: p_data => X_MSG_DATA);
656: RETURN;
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

653: p_encoded => FND_API.G_FALSE,
654: p_count => x_MSG_COUNT,
655: p_data => X_MSG_DATA);
656: RETURN;
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
659: FND_MSG_PUB.Count_And_Get(
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_MSG_COUNT,

Line 658: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

654: p_count => x_MSG_COUNT,
655: p_data => X_MSG_DATA);
656: RETURN;
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
659: FND_MSG_PUB.Count_And_Get(
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_MSG_COUNT,
662: p_data => X_MSG_DATA);

Line 660: p_encoded => FND_API.G_FALSE,

656: RETURN;
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
659: FND_MSG_PUB.Count_And_Get(
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_MSG_COUNT,
662: p_data => X_MSG_DATA);
663: RETURN;
664: WHEN OTHERS THEN

Line 665: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

661: p_count => x_MSG_COUNT,
662: p_data => X_MSG_DATA);
663: RETURN;
664: WHEN OTHERS THEN
665: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
666: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
667: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(

Line 670: p_encoded => FND_API.G_FALSE,

666: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
667: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_MSG_COUNT,
672: p_data => X_MSG_DATA);
673: RETURN;
674:

Line 782: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

778: IF (SQL%NOTFOUND) THEN
779: RAISE NO_DATA_FOUND;
780: END IF;
781: -- Initialize API return status to success.
782: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
783: -- Standard call to get message count and if count is 1, get message
784: -- info.
785: FND_MSG_PUB.Count_And_Get(
786: p_encoded => FND_API.G_FALSE,

Line 786: p_encoded => FND_API.G_FALSE,

782: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
783: -- Standard call to get message count and if count is 1, get message
784: -- info.
785: FND_MSG_PUB.Count_And_Get(
786: p_encoded => FND_API.G_FALSE,
787: p_count => x_MSG_COUNT,
788: p_data => X_MSG_DATA);
789:
790: EXCEPTION

Line 791: WHEN FND_API.G_EXC_ERROR THEN

787: p_count => x_MSG_COUNT,
788: p_data => X_MSG_DATA);
789:
790: EXCEPTION
791: WHEN FND_API.G_EXC_ERROR THEN
792: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
793: FND_MSG_PUB.Count_And_Get(
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_MSG_COUNT,

Line 792: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

788: p_data => X_MSG_DATA);
789:
790: EXCEPTION
791: WHEN FND_API.G_EXC_ERROR THEN
792: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
793: FND_MSG_PUB.Count_And_Get(
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_MSG_COUNT,
796: p_data => X_MSG_DATA);

Line 794: p_encoded => FND_API.G_FALSE,

790: EXCEPTION
791: WHEN FND_API.G_EXC_ERROR THEN
792: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
793: FND_MSG_PUB.Count_And_Get(
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_MSG_COUNT,
796: p_data => X_MSG_DATA);
797: RETURN;
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

794: p_encoded => FND_API.G_FALSE,
795: p_count => x_MSG_COUNT,
796: p_data => X_MSG_DATA);
797: RETURN;
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.Count_And_Get(
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_MSG_COUNT,

Line 799: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

795: p_count => x_MSG_COUNT,
796: p_data => X_MSG_DATA);
797: RETURN;
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.Count_And_Get(
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_MSG_COUNT,
803: p_data => X_MSG_DATA);

Line 801: p_encoded => FND_API.G_FALSE,

797: RETURN;
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.Count_And_Get(
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_MSG_COUNT,
803: p_data => X_MSG_DATA);
804: RETURN;
805: WHEN OTHERS THEN

Line 806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

802: p_count => x_MSG_COUNT,
803: p_data => X_MSG_DATA);
804: RETURN;
805: WHEN OTHERS THEN
806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
808: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.Count_And_Get(

Line 811: p_encoded => FND_API.G_FALSE,

807: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
808: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.Count_And_Get(
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_MSG_COUNT,
813: p_data => X_MSG_DATA);
814: RETURN;
815:

Line 940: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

936: IF (SQL%NOTFOUND) THEN
937: RAISE NO_DATA_FOUND;
938: END IF;
939: -- Initialize API return status to success.
940: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
941: -- Standard call to get message count and if count is 1, get message
942: -- info.
943: FND_MSG_PUB.Count_And_Get(
944: p_encoded => FND_API.G_FALSE,

Line 944: p_encoded => FND_API.G_FALSE,

940: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
941: -- Standard call to get message count and if count is 1, get message
942: -- info.
943: FND_MSG_PUB.Count_And_Get(
944: p_encoded => FND_API.G_FALSE,
945: p_count => x_MSG_COUNT,
946: p_data => X_MSG_DATA);
947:
948: EXCEPTION

Line 949: WHEN FND_API.G_EXC_ERROR THEN

945: p_count => x_MSG_COUNT,
946: p_data => X_MSG_DATA);
947:
948: EXCEPTION
949: WHEN FND_API.G_EXC_ERROR THEN
950: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
951: FND_MSG_PUB.Count_And_Get(
952: p_encoded => FND_API.G_FALSE,
953: p_count => x_MSG_COUNT,

Line 950: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

946: p_data => X_MSG_DATA);
947:
948: EXCEPTION
949: WHEN FND_API.G_EXC_ERROR THEN
950: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
951: FND_MSG_PUB.Count_And_Get(
952: p_encoded => FND_API.G_FALSE,
953: p_count => x_MSG_COUNT,
954: p_data => X_MSG_DATA);

Line 952: p_encoded => FND_API.G_FALSE,

948: EXCEPTION
949: WHEN FND_API.G_EXC_ERROR THEN
950: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
951: FND_MSG_PUB.Count_And_Get(
952: p_encoded => FND_API.G_FALSE,
953: p_count => x_MSG_COUNT,
954: p_data => X_MSG_DATA);
955: RETURN;
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

952: p_encoded => FND_API.G_FALSE,
953: p_count => x_MSG_COUNT,
954: p_data => X_MSG_DATA);
955: RETURN;
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
958: FND_MSG_PUB.Count_And_Get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_MSG_COUNT,

Line 957: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

953: p_count => x_MSG_COUNT,
954: p_data => X_MSG_DATA);
955: RETURN;
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
958: FND_MSG_PUB.Count_And_Get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_MSG_COUNT,
961: p_data => X_MSG_DATA);

Line 959: p_encoded => FND_API.G_FALSE,

955: RETURN;
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
958: FND_MSG_PUB.Count_And_Get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_MSG_COUNT,
961: p_data => X_MSG_DATA);
962: RETURN;
963: WHEN OTHERS THEN

Line 964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

960: p_count => x_MSG_COUNT,
961: p_data => X_MSG_DATA);
962: RETURN;
963: WHEN OTHERS THEN
964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
966: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
967: FND_MSG_PUB.ADD;
968: FND_MSG_PUB.Count_And_Get(

Line 969: p_encoded => FND_API.G_FALSE,

965: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
966: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
967: FND_MSG_PUB.ADD;
968: FND_MSG_PUB.Count_And_Get(
969: p_encoded => FND_API.G_FALSE,
970: p_count => x_MSG_COUNT,
971: p_data => X_MSG_DATA);
972: RETURN;
973: