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_API

Line 126: IF NOT FND_API.Compatible_API_Call ( l_api_version,

122: WriteLog(l_msg || 'Start...');
123:
124:
125: -- Standard call to check for call compatibility.
126: IF NOT FND_API.Compatible_API_Call ( l_api_version,
127: p_api_version_number,
128: l_api_name,
129: G_PKG_NAME )
130: THEN

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: p_api_version_number,
128: l_api_name,
129: G_PKG_NAME )
130: THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133:
134: -- Initialize message list IF p_init_msg_list is set to TRUE.
135: IF FND_API.to_Boolean( p_init_msg_list )

Line 135: IF FND_API.to_Boolean( p_init_msg_list )

131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
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:

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138: END IF;
139:
140:
141: -- Initialize API return status to SUCCESS
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144: --
145: -- API body
146: --

Line 217: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

213: WriteLog(l_msg || ' End GetXmlData...' );
214: end if;
215:
216: WriteLog(l_msg || ' GetXmlData status=' || l_return_status );
217: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: WriteLog(l_msg || ' error to get XML data');
219: --
220: x_msg_data := l_msg_data;
221: x_msg_count := l_msg_count;

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

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:
229: --WriteLog(l_msg || ' xml= ' || l_content_xml );

Line 226: RAISE FND_API.G_EXC_ERROR;

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:
229: --WriteLog(l_msg || ' xml= ' || l_content_xml );
230: l_request_id := null;

Line 284: x_return_status := FND_API.G_RET_STS_ERROR;

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;
288: WriteLog(l_msg || ' Template Code = ' || l_tempcode);

Line 285: RAISE FND_API.G_EXC_ERROR;

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;
288: WriteLog(l_msg || ' Template Code = ' || l_tempcode);
289: WriteLog(l_msg || ' Default Lang = ' || l_lang);

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

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;
456: WriteLog(l_msg || ' delivery xml : concurrent request id= ' || l_submit_request_id );

Line 453: RAISE FND_API.G_EXC_ERROR;

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;
456: WriteLog(l_msg || ' delivery xml : concurrent request id= ' || l_submit_request_id );
457:

Line 474: /* IF FND_API.to_Boolean( p_commit )

470: -- END of API body
471: --
472:
473: -- Standard check for p_commit
474: /* IF FND_API.to_Boolean( p_commit )
475: THEN
476: COMMIT WORK;
477: END IF;
478: */

Line 487: WHEN FND_API.G_EXC_ERROR THEN

483: ( p_count => x_msg_count,
484: p_data => x_msg_data );
485:
486: EXCEPTION
487: WHEN FND_API.G_EXC_ERROR THEN
488: COMMIT WORK;
489: -- ROLLBACK TO SEND_COPY_PUB;
490: WriteLog(l_msg || ' Exc_Error:'|| SQLERRM);
491: x_return_status := FND_API.G_RET_STS_ERROR;

Line 491: x_return_status := FND_API.G_RET_STS_ERROR;

487: WHEN FND_API.G_EXC_ERROR THEN
488: COMMIT WORK;
489: -- ROLLBACK TO SEND_COPY_PUB;
490: WriteLog(l_msg || ' Exc_Error:'|| SQLERRM);
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: -- Update Table with Status
493: l_status := 'FAILURE';
494: IEX_XML_PKG.update_row (
495: p_xml_request_id => l_request_id

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: ( p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: COMMIT WORK;
505: -- ROLLBACK TO SEND_COPY_PUB;
506: WriteLog(l_msg || ' UnExc_Error:'|| SQLERRM);
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: COMMIT WORK;
505: -- ROLLBACK TO SEND_COPY_PUB;
506: WriteLog(l_msg || ' UnExc_Error:'|| SQLERRM);
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: -- Update Table with Status
509: l_status := 'FAILURE';
510: IEX_XML_PKG.update_row (
511: p_xml_request_id => l_request_id

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

519: WHEN OTHERS THEN
520: COMMIT WORK;
521: -- ROLLBACK TO SEND_COPY_PUB;
522: WriteLog(l_msg || ' Other:'|| SQLERRM);
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: -- Update Table with Status
525: l_status := 'FAILURE';
526: IEX_XML_PKG.update_row (
527: p_xml_request_id => l_request_id

Line 567: x_return_status := FND_API.G_RET_STS_ERROR;

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:
571: OPEN C_GET_XML (p_request_id);

Line 568: RAISE FND_API.G_EXC_ERROR;

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:
571: OPEN C_GET_XML (p_request_id);
572: FETCH C_GET_XML INTO l_xml;

Line 578: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 579: RAISE FND_API.G_EXC_ERROR;

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;
582:
583: x_xml := l_xml;

Line 585: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 593: WHEN FND_API.G_EXC_ERROR THEN

589:
590:
591: EXCEPTION
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,

Line 595: x_return_status := FND_API.G_RET_STS_ERROR;

591: EXCEPTION
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

Line 599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MSG_PUB.Count_And_Get
603: ( p_count => x_msg_count,

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

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);
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

Line 607: x_return_status := FND_API.G_RET_STS_ERROR;

603: ( p_count => x_msg_count,
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:

Line 709: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 710: RAISE FND_API.G_EXC_ERROR;

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;
713:
714: -- begin to check the query and bind var are matched or not;

Line 797: x_return_status := FND_API.G_RET_STS_ERROR;

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');
801:

Line 798: RAISE FND_API.G_EXC_ERROR;

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');
801:
802: WriteLog('GetXmlData: end to chk the bind var and query');

Line 835: x_return_status := FND_API.G_RET_STS_ERROR;

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
839: WriteLog('GetXmlData: execute query, numrows > 0');

Line 836: RAISE FND_API.G_EXC_ERROR;

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
839: WriteLog('GetXmlData: execute query, numrows > 0');
840: else

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

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:
848: /* end bug 4732366 - ctlee - use set bind variables 11/28/2005 */

Line 845: RAISE FND_API.G_EXC_ERROR;

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:
848: /* end bug 4732366 - ctlee - use set bind variables 11/28/2005 */
849:

Line 960: x_return_status := FND_API.G_RET_STS_ERROR;

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:
964: --close context

Line 961: RAISE FND_API.G_EXC_ERROR;

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:
964: --close context
965: WriteLog('GetXmlData: close context ');

Line 971: x_return_status := FND_API.G_RET_STS_SUCCESS;

967:
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:

Line 979: WHEN FND_API.G_EXC_ERROR THEN

975:
976:
977: EXCEPTION
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,

Line 981: x_return_status := FND_API.G_RET_STS_ERROR;

977: EXCEPTION
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

Line 985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: FND_MSG_PUB.Count_And_Get
989: ( p_count => x_msg_count,

Line 987: x_return_status := FND_API.G_RET_STS_ERROR;

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);
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

Line 993: x_return_status := FND_API.G_RET_STS_ERROR;

989: ( p_count => x_msg_count,
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;