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.IEX_SEND_XML_PVT dependencies on FND_MESSAGE

Line 223: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XMLDATA');

219: --
220: x_msg_data := l_msg_data;
221: x_msg_count := l_msg_count;
222: --
223: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XMLDATA');
224: FND_MSG_PUB.Add;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;

Line 280: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

276: l_lang,
277: l_terr;
278:
279: IF (C_GET_TEMPCODE%NOTFOUND) THEN
280: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
281: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
282: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XDOTEMP');
283: FND_MSG_PUB.Add;
284: x_return_status := FND_API.G_RET_STS_ERROR;

Line 281: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');

277: l_terr;
278:
279: IF (C_GET_TEMPCODE%NOTFOUND) THEN
280: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
281: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
282: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XDOTEMP');
283: FND_MSG_PUB.Add;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: RAISE FND_API.G_EXC_ERROR;

Line 282: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XDOTEMP');

278:
279: IF (C_GET_TEMPCODE%NOTFOUND) THEN
280: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
281: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
282: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XDOTEMP');
283: FND_MSG_PUB.Add;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: RAISE FND_API.G_EXC_ERROR;
286: END IF;

Line 448: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

444: --
445: ELSE
446:
447: WriteLog(l_msg || ' Error to delivery xml...' );
448: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
449: --FND_MESSAGE.Set_Token ('INFO', 'error to delivery xml');
450: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DELIVERY');
451: FND_MSG_PUB.Add;
452: x_return_status := FND_API.G_RET_STS_ERROR;

Line 449: --FND_MESSAGE.Set_Token ('INFO', 'error to delivery xml');

445: ELSE
446:
447: WriteLog(l_msg || ' Error to delivery xml...' );
448: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
449: --FND_MESSAGE.Set_Token ('INFO', 'error to delivery xml');
450: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DELIVERY');
451: FND_MSG_PUB.Add;
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: RAISE FND_API.G_EXC_ERROR;

Line 450: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DELIVERY');

446:
447: WriteLog(l_msg || ' Error to delivery xml...' );
448: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
449: --FND_MESSAGE.Set_Token ('INFO', 'error to delivery xml');
450: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DELIVERY');
451: FND_MSG_PUB.Add;
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: RAISE FND_API.G_EXC_ERROR;
454:

Line 564: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

560: WriteLog('begin RetrieveXmlData()');
561: WriteLog('RetrieveXmlData: p_request_id = '||p_request_id);
562:
563: if (p_request_id is null) then
564: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
565: FND_MESSAGE.Set_Token ('INFO', 'No Request_Id');
566: FND_MSG_PUB.Add;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: RAISE FND_API.G_EXC_ERROR;

Line 565: FND_MESSAGE.Set_Token ('INFO', 'No Request_Id');

561: WriteLog('RetrieveXmlData: p_request_id = '||p_request_id);
562:
563: if (p_request_id is null) then
564: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
565: FND_MESSAGE.Set_Token ('INFO', 'No Request_Id');
566: FND_MSG_PUB.Add;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: RAISE FND_API.G_EXC_ERROR;
569: end if;

Line 575: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

571: OPEN C_GET_XML (p_request_id);
572: FETCH C_GET_XML INTO l_xml;
573:
574: IF (C_GET_XML%NOTFOUND) THEN
575: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
576: FND_MESSAGE.Set_Token ('INFO', 'Cannot find xmldata');
577: FND_MSG_PUB.Add;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: RAISE FND_API.G_EXC_ERROR;

Line 576: FND_MESSAGE.Set_Token ('INFO', 'Cannot find xmldata');

572: FETCH C_GET_XML INTO l_xml;
573:
574: IF (C_GET_XML%NOTFOUND) THEN
575: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
576: FND_MESSAGE.Set_Token ('INFO', 'Cannot find xmldata');
577: FND_MSG_PUB.Add;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;

Line 707: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_QUERY');

703: OPEN C_GET_QUERY (p_query_id);
704: FETCH C_GET_QUERY INTO l_query, l_query_stmt;
705:
706: IF (C_GET_QUERY%NOTFOUND) THEN
707: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_QUERY');
708: FND_MSG_PUB.Add;
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;

Line 793: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

789: WriteLog('GetXmlData: l_found=' || l_found);
790: WriteLog('GetXmlData: var='||substr(l_new_query, l_found, 3));
791: -- cannot execute the query; the bind variables are not enough;
792: WriteLog('GetXmlData: bind var and query are not matched');
793: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
794: --FND_MESSAGE.Set_Token ('INFO', 'Bind Variables are not enough for query_id: ' || p_query_id);
795: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_BINDVAR');
796: FND_MSG_PUB.Add;
797: x_return_status := FND_API.G_RET_STS_ERROR;

Line 794: --FND_MESSAGE.Set_Token ('INFO', 'Bind Variables are not enough for query_id: ' || p_query_id);

790: WriteLog('GetXmlData: var='||substr(l_new_query, l_found, 3));
791: -- cannot execute the query; the bind variables are not enough;
792: WriteLog('GetXmlData: bind var and query are not matched');
793: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
794: --FND_MESSAGE.Set_Token ('INFO', 'Bind Variables are not enough for query_id: ' || p_query_id);
795: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_BINDVAR');
796: FND_MSG_PUB.Add;
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: RAISE FND_API.G_EXC_ERROR;

Line 795: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_BINDVAR');

791: -- cannot execute the query; the bind variables are not enough;
792: WriteLog('GetXmlData: bind var and query are not matched');
793: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
794: --FND_MESSAGE.Set_Token ('INFO', 'Bind Variables are not enough for query_id: ' || p_query_id);
795: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_BINDVAR');
796: FND_MSG_PUB.Add;
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: RAISE FND_API.G_EXC_ERROR;
799: end if;

Line 832: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_CANT_EXEC_QRY');

828: v_numrows := DBMS_SQL.FETCH_ROWS( v_cursor);
829: DBMS_SQL.CLOSE_CURSOR( v_cursor);
830: EXCEPTION
831: when others then
832: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_CANT_EXEC_QRY');
833: FND_MESSAGE.Set_Token ('ID', p_query_id);
834: FND_MSG_PUB.Add;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: RAISE FND_API.G_EXC_ERROR;

Line 833: FND_MESSAGE.Set_Token ('ID', p_query_id);

829: DBMS_SQL.CLOSE_CURSOR( v_cursor);
830: EXCEPTION
831: when others then
832: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_CANT_EXEC_QRY');
833: FND_MESSAGE.Set_Token ('ID', p_query_id);
834: FND_MSG_PUB.Add;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: RAISE FND_API.G_EXC_ERROR;
837: END;

Line 842: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');

838: if (v_numrows > 0 ) then
839: WriteLog('GetXmlData: execute query, numrows > 0');
840: else
841: WriteLog('GetXmlData: execute query, no rows');
842: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');
843: FND_MSG_PUB.Add;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: RAISE FND_API.G_EXC_ERROR;
846: end if;

Line 956: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

952: x_xml := result;
953:
954: if (result is null) then
955: WriteLog('GetXmlData: no result');
956: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
957: --FND_MESSAGE.Set_Token ('INFO', 'No XML result');
958: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');
959: FND_MSG_PUB.Add;
960: x_return_status := FND_API.G_RET_STS_ERROR;

Line 957: --FND_MESSAGE.Set_Token ('INFO', 'No XML result');

953:
954: if (result is null) then
955: WriteLog('GetXmlData: no result');
956: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
957: --FND_MESSAGE.Set_Token ('INFO', 'No XML result');
958: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');
959: FND_MSG_PUB.Add;
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: RAISE FND_API.G_EXC_ERROR;

Line 958: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');

954: if (result is null) then
955: WriteLog('GetXmlData: no result');
956: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
957: --FND_MESSAGE.Set_Token ('INFO', 'No XML result');
958: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');
959: FND_MSG_PUB.Add;
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: RAISE FND_API.G_EXC_ERROR;
962: end if;