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_MSG_PUB

Line 137: FND_MSG_PUB.initialize;

133:
134: -- Initialize message list IF p_init_msg_list is set to TRUE.
135: IF FND_API.to_Boolean( p_init_msg_list )
136: THEN
137: FND_MSG_PUB.initialize;
138: END IF;
139:
140:
141: -- Initialize API return status to SUCCESS

Line 224: FND_MSG_PUB.Add;

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;
228:

Line 283: FND_MSG_PUB.Add;

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;
287: CLOSE C_GET_TEMPCODE;

Line 451: FND_MSG_PUB.Add;

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:
455: END IF;

Line 482: FND_MSG_PUB.Count_And_Get

478: */
479: COMMIT WORK;
480:
481: -- Standard call to get message count and IF count is 1, get message info.
482: FND_MSG_PUB.Count_And_Get
483: ( p_count => x_msg_count,
484: p_data => x_msg_data );
485:
486: EXCEPTION

Line 498: FND_MSG_PUB.Count_And_Get

494: IEX_XML_PKG.update_row (
495: p_xml_request_id => l_request_id
496: ,p_status => l_status
497: );
498: FND_MSG_PUB.Count_And_Get
499: ( p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502:

Line 514: FND_MSG_PUB.Count_And_Get

510: IEX_XML_PKG.update_row (
511: p_xml_request_id => l_request_id
512: ,p_status => l_status
513: );
514: FND_MSG_PUB.Count_And_Get
515: ( p_count => x_msg_count,
516: p_data => x_msg_data
517: );
518:

Line 530: FND_MSG_PUB.Count_And_Get

526: IEX_XML_PKG.update_row (
527: p_xml_request_id => l_request_id
528: ,p_status => l_status
529: );
530: FND_MSG_PUB.Count_And_Get
531: ( p_count => x_msg_count,
532: p_data => x_msg_data
533: );
534:

Line 566: FND_MSG_PUB.Add;

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;
570:

Line 577: FND_MSG_PUB.Add;

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;
581: CLOSE C_GET_XML;

Line 586: FND_MSG_PUB.Count_And_Get

582:
583: x_xml := l_xml;
584: WriteLog('get XmlData');
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586: FND_MSG_PUB.Count_And_Get
587: ( p_count => x_msg_count,
588: p_data => x_msg_data );
589:
590:

Line 596: FND_MSG_PUB.Count_And_Get

592:
593: WHEN FND_API.G_EXC_ERROR THEN
594: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);
595: x_return_status := FND_API.G_RET_STS_ERROR;
596: FND_MSG_PUB.Count_And_Get
597: ( p_count => x_msg_count,
598: p_data => x_msg_data);
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);

Line 602: FND_MSG_PUB.Count_And_Get

598: p_data => x_msg_data);
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MSG_PUB.Count_And_Get
603: ( p_count => x_msg_count,
604: p_data => x_msg_data);
605: when others then
606: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);

Line 608: FND_MSG_PUB.Count_And_Get

604: p_data => x_msg_data);
605: when others then
606: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: FND_MSG_PUB.Count_And_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data);
611:
612: END RetrieveXmlData;

Line 708: FND_MSG_PUB.Add;

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;
712: CLOSE C_GET_QUERY;

Line 796: FND_MSG_PUB.Add;

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;
800: WriteLog('GetXmlData: bind var and query are matched');

Line 834: FND_MSG_PUB.Add;

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;
838: if (v_numrows > 0 ) then

Line 843: FND_MSG_PUB.Add;

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;
847:

Line 959: FND_MSG_PUB.Add;

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;
963:

Line 972: FND_MSG_PUB.Count_And_Get

968:
969: WriteLog('GetXmlData: end GetXmlData()');
970:
971: x_return_status := FND_API.G_RET_STS_SUCCESS;
972: FND_MSG_PUB.Count_And_Get
973: ( p_count => x_msg_count,
974: p_data => x_msg_data );
975:
976:

Line 982: FND_MSG_PUB.Count_And_Get

978:
979: WHEN FND_API.G_EXC_ERROR THEN
980: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: FND_MSG_PUB.Count_And_Get
983: ( p_count => x_msg_count,
984: p_data => x_msg_data);
985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
986: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);

Line 988: FND_MSG_PUB.Count_And_Get

984: p_data => x_msg_data);
985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
986: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: FND_MSG_PUB.Count_And_Get
989: ( p_count => x_msg_count,
990: p_data => x_msg_data);
991: when others then
992: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);

Line 994: FND_MSG_PUB.Count_And_Get

990: p_data => x_msg_data);
991: when others then
992: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: FND_MSG_PUB.Count_And_Get
995: ( p_count => x_msg_count,
996: p_data => x_msg_data);
997: End GetXmlData;
998: