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 389: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XMLDATA');

385: --
386: x_msg_data := l_msg_data;
387: x_msg_count := l_msg_count;
388: --
389: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XMLDATA');
390: FND_MSG_PUB.Add;
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;

Line 429: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOXMLDATA_ADDQRY');

425:
426: x_msg_data := l_msg_data;
427: x_msg_count := l_msg_count;
428:
429: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOXMLDATA_ADDQRY');
430: FND_MSG_PUB.Add;
431: x_return_status := FND_API.G_RET_STS_ERROR;
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;

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

453: OPEN C_GET_TEMPCODE (p_template_id);
454: FETCH C_GET_TEMPCODE INTO l_tempcode;
455:
456: IF (C_GET_TEMPCODE%NOTFOUND) THEN
457: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
458: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
459: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XDOTEMP');
460: FND_MSG_PUB.Add;
461: x_return_status := FND_API.G_RET_STS_ERROR;

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

454: FETCH C_GET_TEMPCODE INTO l_tempcode;
455:
456: IF (C_GET_TEMPCODE%NOTFOUND) THEN
457: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
458: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
459: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XDOTEMP');
460: FND_MSG_PUB.Add;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: RAISE FND_API.G_EXC_ERROR;

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

455:
456: IF (C_GET_TEMPCODE%NOTFOUND) THEN
457: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
458: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
459: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_XDOTEMP');
460: FND_MSG_PUB.Add;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;

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

471: OPEN C_GET_TEMPCODE (p_addt_template_id);
472: FETCH C_GET_TEMPCODE INTO l_addt_tempcode;
473:
474: IF (C_GET_TEMPCODE%NOTFOUND) THEN
475: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
476: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
477: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOXDOTEMP_ADDQRY');
478: FND_MSG_PUB.Add;
479: x_return_status := FND_API.G_RET_STS_ERROR;

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

472: FETCH C_GET_TEMPCODE INTO l_addt_tempcode;
473:
474: IF (C_GET_TEMPCODE%NOTFOUND) THEN
475: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
476: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
477: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOXDOTEMP_ADDQRY');
478: FND_MSG_PUB.Add;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480:

Line 477: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOXDOTEMP_ADDQRY');

473:
474: IF (C_GET_TEMPCODE%NOTFOUND) THEN
475: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
476: --FND_MESSAGE.Set_Token ('INFO', 'Cannot find xdo template code');
477: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOXDOTEMP_ADDQRY');
478: FND_MSG_PUB.Add;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480:
481: l_dunn_rec.ADDT_DELIVERY_STATUS := 'IEX_SEND_FAIL_NOXDOTEMP_ADDQRY';

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

765: WriteLog('begin RetrieveXmlData()');
766: WriteLog('RetrieveXmlData: p_request_id = '||p_request_id);
767:
768: if (p_request_id is null) then
769: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
770: FND_MESSAGE.Set_Token ('INFO', 'No Request_Id');
771: FND_MSG_PUB.Add;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: RAISE FND_API.G_EXC_ERROR;

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

766: WriteLog('RetrieveXmlData: p_request_id = '||p_request_id);
767:
768: if (p_request_id is null) then
769: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
770: FND_MESSAGE.Set_Token ('INFO', 'No Request_Id');
771: FND_MSG_PUB.Add;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: RAISE FND_API.G_EXC_ERROR;
774: end if;

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

776: OPEN C_GET_XML (p_request_id);
777: FETCH C_GET_XML INTO l_xml, l_addt_xml;
778:
779: IF (C_GET_XML%NOTFOUND) THEN
780: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
781: FND_MESSAGE.Set_Token ('INFO', 'Cannot find xmldata');
782: FND_MSG_PUB.Add;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: RAISE FND_API.G_EXC_ERROR;

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

777: FETCH C_GET_XML INTO l_xml, l_addt_xml;
778:
779: IF (C_GET_XML%NOTFOUND) THEN
780: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
781: FND_MESSAGE.Set_Token ('INFO', 'Cannot find xmldata');
782: FND_MSG_PUB.Add;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;

Line 933: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NOQUERY_ADDQRY');

929: FETCH C_GET_QUERY INTO l_query, l_query_stmt;
930:
931: IF (C_GET_QUERY%NOTFOUND) THEN
932: if l_is_this_addt_query = 'Y' then
933: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NOQUERY_ADDQRY');
934: l_addt_delivery_status := 'IEX_SEND_FAILED_NOQUERY_ADDQRY';
935: else
936: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_QUERY');
937: end if;

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

932: if l_is_this_addt_query = 'Y' then
933: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NOQUERY_ADDQRY');
934: l_addt_delivery_status := 'IEX_SEND_FAILED_NOQUERY_ADDQRY';
935: else
936: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_QUERY');
937: end if;
938: FND_MSG_PUB.Add;
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: RAISE FND_API.G_EXC_ERROR;

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

1015: WriteLog('GetXmlData: l_found=' || l_found);
1016: WriteLog('GetXmlData: var='||substr(l_chk_query, l_found, 12));
1017: -- cannot execute the query; the bind variables are not enough;
1018: WriteLog('GetXmlData: bind var and query are not matched');
1019: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
1020: --FND_MESSAGE.Set_Token ('INFO', 'Bind Variables are not enough for query_id: ' || p_query_id);
1021: if l_is_this_addt_query = 'Y' then
1022: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY');
1023: l_addt_delivery_status := 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY';

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

1016: WriteLog('GetXmlData: var='||substr(l_chk_query, l_found, 12));
1017: -- cannot execute the query; the bind variables are not enough;
1018: WriteLog('GetXmlData: bind var and query are not matched');
1019: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
1020: --FND_MESSAGE.Set_Token ('INFO', 'Bind Variables are not enough for query_id: ' || p_query_id);
1021: if l_is_this_addt_query = 'Y' then
1022: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY');
1023: l_addt_delivery_status := 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY';
1024: else

Line 1022: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY');

1018: WriteLog('GetXmlData: bind var and query are not matched');
1019: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
1020: --FND_MESSAGE.Set_Token ('INFO', 'Bind Variables are not enough for query_id: ' || p_query_id);
1021: if l_is_this_addt_query = 'Y' then
1022: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY');
1023: l_addt_delivery_status := 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY';
1024: else
1025: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_BINDVAR');
1026: end if;

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

1021: if l_is_this_addt_query = 'Y' then
1022: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY');
1023: l_addt_delivery_status := 'IEX_SEND_FAIL_NOBINDVAR_ADDQRY';
1024: else
1025: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_BINDVAR');
1026: end if;
1027: FND_MSG_PUB.Add;
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: RAISE FND_API.G_EXC_ERROR;

Line 1066: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_CANTEXEQY_ADDQRY');

1062: DBMS_SQL.CLOSE_CURSOR( v_cursor);
1063: EXCEPTION
1064: when others then
1065: if l_is_this_addt_query = 'Y' then
1066: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_CANTEXEQY_ADDQRY');
1067: l_addt_delivery_status := 'IEX_SEND_FAIL_CANTEXEQY_ADDQRY';
1068: else
1069: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_CANT_EXEC_QRY');
1070: end if;

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

1065: if l_is_this_addt_query = 'Y' then
1066: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAIL_CANTEXEQY_ADDQRY');
1067: l_addt_delivery_status := 'IEX_SEND_FAIL_CANTEXEQY_ADDQRY';
1068: else
1069: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_CANT_EXEC_QRY');
1070: end if;
1071: FND_MESSAGE.Set_Token ('ID', p_query_id);
1072: FND_MSG_PUB.Add;
1073: x_return_status := FND_API.G_RET_STS_ERROR;

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

1067: l_addt_delivery_status := 'IEX_SEND_FAIL_CANTEXEQY_ADDQRY';
1068: else
1069: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_CANT_EXEC_QRY');
1070: end if;
1071: FND_MESSAGE.Set_Token ('ID', p_query_id);
1072: FND_MSG_PUB.Add;
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: RAISE FND_API.G_EXC_ERROR;
1075: END;

Line 1082: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA_ADDQRY');

1078: WriteLog('GetXmlData: execute query, numrows > 0');
1079: else
1080: WriteLog('GetXmlData: execute query, no rows');
1081: if l_is_this_addt_query = 'Y' then
1082: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA_ADDQRY');
1083: l_addt_delivery_status := 'IEX_SEND_FAILED_NO_DATA_ADDQRY';
1084: else
1085: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');
1086: end if;

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

1081: if l_is_this_addt_query = 'Y' then
1082: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA_ADDQRY');
1083: l_addt_delivery_status := 'IEX_SEND_FAILED_NO_DATA_ADDQRY';
1084: else
1085: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');
1086: end if;
1087: FND_MSG_PUB.Add;
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: RAISE FND_API.G_EXC_ERROR;

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

1208: x_xml := result;
1209:
1210: if (result is null) then
1211: WriteLog('GetXmlData: no result');
1212: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
1213: --FND_MESSAGE.Set_Token ('INFO', 'No XML result');
1214: if l_is_this_addt_query = 'Y' then
1215: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA_ADDQRY');
1216: l_addt_delivery_status := 'IEX_SEND_FAILED_NO_DATA_ADDQRY';

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

1209:
1210: if (result is null) then
1211: WriteLog('GetXmlData: no result');
1212: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
1213: --FND_MESSAGE.Set_Token ('INFO', 'No XML result');
1214: if l_is_this_addt_query = 'Y' then
1215: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA_ADDQRY');
1216: l_addt_delivery_status := 'IEX_SEND_FAILED_NO_DATA_ADDQRY';
1217: else

Line 1215: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA_ADDQRY');

1211: WriteLog('GetXmlData: no result');
1212: --FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
1213: --FND_MESSAGE.Set_Token ('INFO', 'No XML result');
1214: if l_is_this_addt_query = 'Y' then
1215: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA_ADDQRY');
1216: l_addt_delivery_status := 'IEX_SEND_FAILED_NO_DATA_ADDQRY';
1217: else
1218: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');
1219: end if;

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

1214: if l_is_this_addt_query = 'Y' then
1215: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA_ADDQRY');
1216: l_addt_delivery_status := 'IEX_SEND_FAILED_NO_DATA_ADDQRY';
1217: else
1218: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DATA');
1219: end if;
1220: FND_MSG_PUB.Add;
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: RAISE FND_API.G_EXC_ERROR;