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

Line 617: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

613: x_last_update_login
614: ) RETURNING ROWID, batch_id INTO x_rowid, x_batch_id;
615:
616: -- Initialize API return status to success.
617: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
618: -- Standard call to get message count and if count is 1, get message
619: -- info.
620: FND_MSG_PUB.Count_And_Get(
621: p_encoded => FND_API.G_FALSE,

Line 621: p_encoded => FND_API.G_FALSE,

617: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
618: -- Standard call to get message count and if count is 1, get message
619: -- info.
620: FND_MSG_PUB.Count_And_Get(
621: p_encoded => FND_API.G_FALSE,
622: p_count => x_MSG_COUNT,
623: p_data => X_MSG_DATA);
624:
625: EXCEPTION

Line 626: WHEN FND_API.G_EXC_ERROR THEN

622: p_count => x_MSG_COUNT,
623: p_data => X_MSG_DATA);
624:
625: EXCEPTION
626: WHEN FND_API.G_EXC_ERROR THEN
627: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
628: FND_MSG_PUB.Count_And_Get(
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_MSG_COUNT,

Line 627: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

623: p_data => X_MSG_DATA);
624:
625: EXCEPTION
626: WHEN FND_API.G_EXC_ERROR THEN
627: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
628: FND_MSG_PUB.Count_And_Get(
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_MSG_COUNT,
631: p_data => X_MSG_DATA);

Line 629: p_encoded => FND_API.G_FALSE,

625: EXCEPTION
626: WHEN FND_API.G_EXC_ERROR THEN
627: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
628: FND_MSG_PUB.Count_And_Get(
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_MSG_COUNT,
631: p_data => X_MSG_DATA);
632: RETURN;
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

629: p_encoded => FND_API.G_FALSE,
630: p_count => x_MSG_COUNT,
631: p_data => X_MSG_DATA);
632: RETURN;
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
635: FND_MSG_PUB.Count_And_Get(
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_MSG_COUNT,

Line 634: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

630: p_count => x_MSG_COUNT,
631: p_data => X_MSG_DATA);
632: RETURN;
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
635: FND_MSG_PUB.Count_And_Get(
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_MSG_COUNT,
638: p_data => X_MSG_DATA);

Line 636: p_encoded => FND_API.G_FALSE,

632: RETURN;
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
635: FND_MSG_PUB.Count_And_Get(
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_MSG_COUNT,
638: p_data => X_MSG_DATA);
639: RETURN;
640: WHEN OTHERS THEN

Line 641: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

637: p_count => x_MSG_COUNT,
638: p_data => X_MSG_DATA);
639: RETURN;
640: WHEN OTHERS THEN
641: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
643: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get(

Line 646: p_encoded => FND_API.G_FALSE,

642: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
643: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get(
646: p_encoded => FND_API.G_FALSE,
647: p_count => x_MSG_COUNT,
648: p_data => X_MSG_DATA);
649: RETURN;
650:

Line 791: RAISE FND_API.G_EXC_ERROR;

787: NULL;
788: ELSE
789: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
790: igs_ge_msg_stack.add;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794: -- Initialize API return status to success.
795: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 795: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794: -- Initialize API return status to success.
795: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
796: -- Standard call to get message count and if count is 1, get message
797: -- info.
798: FND_MSG_PUB.Count_And_Get(
799: p_encoded => FND_API.G_FALSE,

Line 799: p_encoded => FND_API.G_FALSE,

795: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
796: -- Standard call to get message count and if count is 1, get message
797: -- info.
798: FND_MSG_PUB.Count_And_Get(
799: p_encoded => FND_API.G_FALSE,
800: p_count => x_MSG_COUNT,
801: p_data => X_MSG_DATA);
802: RETURN;
803: EXCEPTION

Line 804: WHEN FND_API.G_EXC_ERROR THEN

800: p_count => x_MSG_COUNT,
801: p_data => X_MSG_DATA);
802: RETURN;
803: EXCEPTION
804: WHEN FND_API.G_EXC_ERROR THEN
805: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
806: FND_MSG_PUB.Count_And_Get(
807: p_encoded => FND_API.G_FALSE,
808: p_count => x_MSG_COUNT,

Line 805: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

801: p_data => X_MSG_DATA);
802: RETURN;
803: EXCEPTION
804: WHEN FND_API.G_EXC_ERROR THEN
805: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
806: FND_MSG_PUB.Count_And_Get(
807: p_encoded => FND_API.G_FALSE,
808: p_count => x_MSG_COUNT,
809: p_data => X_MSG_DATA);

Line 807: p_encoded => FND_API.G_FALSE,

803: EXCEPTION
804: WHEN FND_API.G_EXC_ERROR THEN
805: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
806: FND_MSG_PUB.Count_And_Get(
807: p_encoded => FND_API.G_FALSE,
808: p_count => x_MSG_COUNT,
809: p_data => X_MSG_DATA);
810: RETURN;
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

807: p_encoded => FND_API.G_FALSE,
808: p_count => x_MSG_COUNT,
809: p_data => X_MSG_DATA);
810: RETURN;
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
813: FND_MSG_PUB.Count_And_Get(
814: p_encoded => FND_API.G_FALSE,
815: p_count => x_MSG_COUNT,

Line 812: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

808: p_count => x_MSG_COUNT,
809: p_data => X_MSG_DATA);
810: RETURN;
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
813: FND_MSG_PUB.Count_And_Get(
814: p_encoded => FND_API.G_FALSE,
815: p_count => x_MSG_COUNT,
816: p_data => X_MSG_DATA);

Line 814: p_encoded => FND_API.G_FALSE,

810: RETURN;
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
813: FND_MSG_PUB.Count_And_Get(
814: p_encoded => FND_API.G_FALSE,
815: p_count => x_MSG_COUNT,
816: p_data => X_MSG_DATA);
817: RETURN;
818: WHEN OTHERS THEN

Line 819: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

815: p_count => x_MSG_COUNT,
816: p_data => X_MSG_DATA);
817: RETURN;
818: WHEN OTHERS THEN
819: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
820: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
821: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
822: FND_MSG_PUB.ADD;
823: FND_MSG_PUB.Count_And_Get(

Line 824: p_encoded => FND_API.G_FALSE,

820: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
821: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
822: FND_MSG_PUB.ADD;
823: FND_MSG_PUB.Count_And_Get(
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_MSG_COUNT,
826: p_data => X_MSG_DATA);
827: RETURN;
828:

Line 993: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

989: RAISE NO_DATA_FOUND;
990: END IF;
991:
992: -- Initialize API return status to success.
993: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
994: -- Standard call to get message count and if count is 1, get message
995: -- info.
996: FND_MSG_PUB.Count_And_Get(
997: p_encoded => FND_API.G_FALSE,

Line 997: p_encoded => FND_API.G_FALSE,

993: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
994: -- Standard call to get message count and if count is 1, get message
995: -- info.
996: FND_MSG_PUB.Count_And_Get(
997: p_encoded => FND_API.G_FALSE,
998: p_count => x_MSG_COUNT,
999: p_data => X_MSG_DATA);
1000:
1001: EXCEPTION

Line 1002: WHEN FND_API.G_EXC_ERROR THEN

998: p_count => x_MSG_COUNT,
999: p_data => X_MSG_DATA);
1000:
1001: EXCEPTION
1002: WHEN FND_API.G_EXC_ERROR THEN
1003: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1004: FND_MSG_PUB.Count_And_Get(
1005: p_encoded => FND_API.G_FALSE,
1006: p_count => x_MSG_COUNT,

Line 1003: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

999: p_data => X_MSG_DATA);
1000:
1001: EXCEPTION
1002: WHEN FND_API.G_EXC_ERROR THEN
1003: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1004: FND_MSG_PUB.Count_And_Get(
1005: p_encoded => FND_API.G_FALSE,
1006: p_count => x_MSG_COUNT,
1007: p_data => X_MSG_DATA);

Line 1005: p_encoded => FND_API.G_FALSE,

1001: EXCEPTION
1002: WHEN FND_API.G_EXC_ERROR THEN
1003: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1004: FND_MSG_PUB.Count_And_Get(
1005: p_encoded => FND_API.G_FALSE,
1006: p_count => x_MSG_COUNT,
1007: p_data => X_MSG_DATA);
1008: RETURN;
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1005: p_encoded => FND_API.G_FALSE,
1006: p_count => x_MSG_COUNT,
1007: p_data => X_MSG_DATA);
1008: RETURN;
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1011: FND_MSG_PUB.Count_And_Get(
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_MSG_COUNT,

Line 1010: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1006: p_count => x_MSG_COUNT,
1007: p_data => X_MSG_DATA);
1008: RETURN;
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1011: FND_MSG_PUB.Count_And_Get(
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_MSG_COUNT,
1014: p_data => X_MSG_DATA);

Line 1012: p_encoded => FND_API.G_FALSE,

1008: RETURN;
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1011: FND_MSG_PUB.Count_And_Get(
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_MSG_COUNT,
1014: p_data => X_MSG_DATA);
1015: RETURN;
1016: WHEN OTHERS THEN

Line 1017: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1013: p_count => x_MSG_COUNT,
1014: p_data => X_MSG_DATA);
1015: RETURN;
1016: WHEN OTHERS THEN
1017: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1019: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: FND_MSG_PUB.Count_And_Get(

Line 1022: p_encoded => FND_API.G_FALSE,

1018: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1019: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: FND_MSG_PUB.Count_And_Get(
1022: p_encoded => FND_API.G_FALSE,
1023: p_count => x_MSG_COUNT,
1024: p_data => X_MSG_DATA);
1025: RETURN;
1026:

Line 1205: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1201: RAISE NO_DATA_FOUND;
1202: END IF;
1203:
1204: -- Initialize API return status to success.
1205: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1206: -- Standard call to get message count and if count is 1, get message
1207: -- info.
1208: FND_MSG_PUB.Count_And_Get(
1209: p_encoded => FND_API.G_FALSE,

Line 1209: p_encoded => FND_API.G_FALSE,

1205: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1206: -- Standard call to get message count and if count is 1, get message
1207: -- info.
1208: FND_MSG_PUB.Count_And_Get(
1209: p_encoded => FND_API.G_FALSE,
1210: p_count => x_MSG_COUNT,
1211: p_data => X_MSG_DATA);
1212:
1213: EXCEPTION

Line 1214: WHEN FND_API.G_EXC_ERROR THEN

1210: p_count => x_MSG_COUNT,
1211: p_data => X_MSG_DATA);
1212:
1213: EXCEPTION
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1216: FND_MSG_PUB.Count_And_Get(
1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_MSG_COUNT,

Line 1215: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1211: p_data => X_MSG_DATA);
1212:
1213: EXCEPTION
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1216: FND_MSG_PUB.Count_And_Get(
1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_MSG_COUNT,
1219: p_data => X_MSG_DATA);

Line 1217: p_encoded => FND_API.G_FALSE,

1213: EXCEPTION
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1216: FND_MSG_PUB.Count_And_Get(
1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_MSG_COUNT,
1219: p_data => X_MSG_DATA);
1220: RETURN;
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_MSG_COUNT,
1219: p_data => X_MSG_DATA);
1220: RETURN;
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1223: FND_MSG_PUB.Count_And_Get(
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_MSG_COUNT,

Line 1222: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1218: p_count => x_MSG_COUNT,
1219: p_data => X_MSG_DATA);
1220: RETURN;
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1223: FND_MSG_PUB.Count_And_Get(
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_MSG_COUNT,
1226: p_data => X_MSG_DATA);

Line 1224: p_encoded => FND_API.G_FALSE,

1220: RETURN;
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1223: FND_MSG_PUB.Count_And_Get(
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_MSG_COUNT,
1226: p_data => X_MSG_DATA);
1227: RETURN;
1228: WHEN OTHERS THEN

Line 1229: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1225: p_count => x_MSG_COUNT,
1226: p_data => X_MSG_DATA);
1227: RETURN;
1228: WHEN OTHERS THEN
1229: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1230: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1231: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1232: FND_MSG_PUB.ADD;
1233: FND_MSG_PUB.Count_And_Get(

Line 1234: p_encoded => FND_API.G_FALSE,

1230: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1231: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1232: FND_MSG_PUB.ADD;
1233: FND_MSG_PUB.Count_And_Get(
1234: p_encoded => FND_API.G_FALSE,
1235: p_count => x_MSG_COUNT,
1236: p_data => X_MSG_DATA);
1237: RETURN;
1238: