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 275: IF NOT FND_API.Compatible_API_Call ( l_api_version,

271: WriteLog(l_msg || 'Start...');
272:
273:
274: -- Standard call to check for call compatibility.
275: IF NOT FND_API.Compatible_API_Call ( l_api_version,
276: p_api_version_number,
277: l_api_name,
278: G_PKG_NAME )
279: THEN

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: p_api_version_number,
277: l_api_name,
278: G_PKG_NAME )
279: THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: -- Initialize message list IF p_init_msg_list is set to TRUE.
284: IF FND_API.to_Boolean( p_init_msg_list )

Line 284: IF FND_API.to_Boolean( p_init_msg_list )

280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: -- Initialize message list IF p_init_msg_list is set to TRUE.
284: IF FND_API.to_Boolean( p_init_msg_list )
285: THEN
286: FND_MSG_PUB.initialize;
287: END IF;
288:

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287: END IF;
288:
289:
290: -- Initialize API return status to SUCCESS
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292:
293: --
294: -- API body
295: --

Line 383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

379: x_msg_data => l_msg_data,
380: x_xml => l_content_xml);
381:
382: WriteLog(l_msg || ' GetXmlData status=' || l_return_status );
383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
384: WriteLog(l_msg || ' error to get XML data');
385: --
386: x_msg_data := l_msg_data;
387: x_msg_count := l_msg_count;

Line 391: x_return_status := FND_API.G_RET_STS_ERROR;

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;
394:
395: if p_addt_query_id is not null then

Line 392: RAISE FND_API.G_EXC_ERROR;

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;
394:
395: if p_addt_query_id is not null then
396: for i in 1..p_bind_tbl.count loop

Line 423: IF l_return_status2 <> FND_API.G_RET_STS_SUCCESS THEN

419: x_msg_data => l_msg_data,
420: x_xml => l_addt_content_xml);
421:
422: WriteLog(l_msg || ' GetXmlData status for additional query =' || l_return_status2 );
423: IF l_return_status2 <> FND_API.G_RET_STS_SUCCESS THEN
424: WriteLog(l_msg || ' error to get XML data for additional query');
425:
426: x_msg_data := l_msg_data;
427: x_msg_count := l_msg_count;

Line 431: x_return_status := FND_API.G_RET_STS_ERROR;

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;
434: --pass addt status as XMLDATA only when addt query executed successfully.
435: l_addt_status := 'XMLDATA';

Line 432: RAISE FND_API.G_EXC_ERROR;

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;
434: --pass addt status as XMLDATA only when addt query executed successfully.
435: l_addt_status := 'XMLDATA';
436: else

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

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;
464: CLOSE C_GET_TEMPCODE;
465: WriteLog(l_msg || ' Template Code = ' || l_tempcode);

Line 462: RAISE FND_API.G_EXC_ERROR;

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;
464: CLOSE C_GET_TEMPCODE;
465: WriteLog(l_msg || ' Template Code = ' || l_tempcode);
466:

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

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';
482:
483: if l_dunn_rec.ADDT_DELIVERY_STATUS is not null then

Line 497: , p_init_msg_list => FND_API.G_FALSE

493: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateRow');
494:
495: IEX_DUNNING_PVT.Update_DUNNING(
496: p_api_version => 1.0
497: , p_init_msg_list => FND_API.G_FALSE
498: , p_commit => FND_API.G_TRUE
499: , p_dunning_rec => l_dunn_rec
500: , x_return_status => l_return_status1
501: , x_msg_count => l_msg_count1

Line 498: , p_commit => FND_API.G_TRUE

494:
495: IEX_DUNNING_PVT.Update_DUNNING(
496: p_api_version => 1.0
497: , p_init_msg_list => FND_API.G_FALSE
498: , p_commit => FND_API.G_TRUE
499: , p_dunning_rec => l_dunn_rec
500: , x_return_status => l_return_status1
501: , x_msg_count => l_msg_count1
502: , x_msg_data => l_msg_data1);

Line 509: RAISE FND_API.G_EXC_ERROR;

505: end if;
506:
507: end if;
508:
509: RAISE FND_API.G_EXC_ERROR;
510: END IF;
511: CLOSE C_GET_TEMPCODE;
512: WriteLog(l_msg || ' Additional Template Code = ' || l_addt_tempcode);
513: end if;

Line 690: WHEN FND_API.G_EXC_ERROR THEN

686: ( p_count => x_msg_count,
687: p_data => x_msg_data );
688:
689: EXCEPTION
690: WHEN FND_API.G_EXC_ERROR THEN
691: COMMIT WORK;
692: -- ROLLBACK TO SEND_COPY_PUB;
693: WriteLog(l_msg || ' Exc_Error:'|| SQLERRM);
694: x_return_status := FND_API.G_RET_STS_ERROR;

Line 694: x_return_status := FND_API.G_RET_STS_ERROR;

690: WHEN FND_API.G_EXC_ERROR THEN
691: COMMIT WORK;
692: -- ROLLBACK TO SEND_COPY_PUB;
693: WriteLog(l_msg || ' Exc_Error:'|| SQLERRM);
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: -- Update Table with Status
696: l_status := 'FAILURE';
697: IEX_XML_PKG.update_row (
698: p_xml_request_id => l_request_id

Line 706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

702: ( p_count => x_msg_count,
703: p_data => x_msg_data
704: );
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: COMMIT WORK;
708: -- ROLLBACK TO SEND_COPY_PUB;
709: WriteLog(l_msg || ' UnExc_Error:'|| SQLERRM);
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: COMMIT WORK;
708: -- ROLLBACK TO SEND_COPY_PUB;
709: WriteLog(l_msg || ' UnExc_Error:'|| SQLERRM);
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: -- Update Table with Status
712: l_status := 'FAILURE';
713: IEX_XML_PKG.update_row (
714: p_xml_request_id => l_request_id

Line 726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

722: WHEN OTHERS THEN
723: COMMIT WORK;
724: -- ROLLBACK TO SEND_COPY_PUB;
725: WriteLog(l_msg || ' Other:'|| SQLERRM);
726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
727: -- Update Table with Status
728: l_status := 'FAILURE';
729: IEX_XML_PKG.update_row (
730: p_xml_request_id => l_request_id

Line 772: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 773: RAISE FND_API.G_EXC_ERROR;

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;
775:
776: OPEN C_GET_XML (p_request_id);
777: FETCH C_GET_XML INTO l_xml, l_addt_xml;

Line 783: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 784: RAISE FND_API.G_EXC_ERROR;

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;
786: CLOSE C_GET_XML;
787:
788: x_xml := l_xml;

Line 791: x_return_status := FND_API.G_RET_STS_SUCCESS;

787:
788: x_xml := l_xml;
789: x_addt_xml := l_addt_xml;
790: WriteLog('get XmlData');
791: x_return_status := FND_API.G_RET_STS_SUCCESS;
792: FND_MSG_PUB.Count_And_Get
793: ( p_count => x_msg_count,
794: p_data => x_msg_data );
795:

Line 799: WHEN FND_API.G_EXC_ERROR THEN

795:
796:
797: EXCEPTION
798:
799: WHEN FND_API.G_EXC_ERROR THEN
800: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: FND_MSG_PUB.Count_And_Get
803: ( p_count => x_msg_count,

Line 801: x_return_status := FND_API.G_RET_STS_ERROR;

797: EXCEPTION
798:
799: WHEN FND_API.G_EXC_ERROR THEN
800: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: FND_MSG_PUB.Count_And_Get
803: ( p_count => x_msg_count,
804: p_data => x_msg_data);
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

801: x_return_status := FND_API.G_RET_STS_ERROR;
802: FND_MSG_PUB.Count_And_Get
803: ( p_count => x_msg_count,
804: p_data => x_msg_data);
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);
807: x_return_status := FND_API.G_RET_STS_ERROR;
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,

Line 807: x_return_status := FND_API.G_RET_STS_ERROR;

803: ( p_count => x_msg_count,
804: p_data => x_msg_data);
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);
807: x_return_status := FND_API.G_RET_STS_ERROR;
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data);
811: when others then

Line 813: x_return_status := FND_API.G_RET_STS_ERROR;

809: ( p_count => x_msg_count,
810: p_data => x_msg_data);
811: when others then
812: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: FND_MSG_PUB.Count_And_Get
815: ( p_count => x_msg_count,
816: p_data => x_msg_data);
817:

Line 939: x_return_status := FND_API.G_RET_STS_ERROR;

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;
941: END IF;
942: CLOSE C_GET_QUERY;
943:

Line 940: RAISE FND_API.G_EXC_ERROR;

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;
941: END IF;
942: CLOSE C_GET_QUERY;
943:
944: -- begin to check the query and bind var are matched or not;

Line 1028: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1030: end if;
1031:
1032: WriteLog('GetXmlData: bind var and query are matched');

Line 1029: RAISE FND_API.G_EXC_ERROR;

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;
1030: end if;
1031:
1032: WriteLog('GetXmlData: bind var and query are matched');
1033: WriteLog('GetXmlData: end to chk the bind var and query');

Line 1073: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1074: RAISE FND_API.G_EXC_ERROR;

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;
1076:
1077: if (v_numrows > 0 ) then
1078: WriteLog('GetXmlData: execute query, numrows > 0');

Line 1088: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1090: end if;
1091: */
1092: -- end bug 4732366 - ctlee - use set bind variables 11/28/2005

Line 1089: RAISE FND_API.G_EXC_ERROR;

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;
1090: end if;
1091: */
1092: -- end bug 4732366 - ctlee - use set bind variables 11/28/2005
1093:

Line 1221: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1223: end if;
1224:
1225: --close context

Line 1222: RAISE FND_API.G_EXC_ERROR;

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;
1223: end if;
1224:
1225: --close context
1226: WriteLog('GetXmlData: close context ');

Line 1234: x_return_status := FND_API.G_RET_STS_SUCCESS;

1230:
1231:
1232: WriteLog('GetXmlData: end GetXmlData()');
1233:
1234: x_return_status := FND_API.G_RET_STS_SUCCESS;
1235: FND_MSG_PUB.Count_And_Get
1236: ( p_count => x_msg_count,
1237: p_data => x_msg_data );
1238:

Line 1242: WHEN FND_API.G_EXC_ERROR THEN

1238:
1239:
1240: EXCEPTION
1241:
1242: WHEN FND_API.G_EXC_ERROR THEN
1243: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);
1244:
1245: if l_is_this_addt_query = 'Y' then
1246: l_dunn_rec.ADDT_DELIVERY_STATUS := l_addt_delivery_status;

Line 1264: , p_init_msg_list => FND_API.G_FALSE

1260: WriteLog('GetXmlData: Update dunning Row');
1261:
1262: IEX_DUNNING_PVT.Update_DUNNING(
1263: p_api_version => 1.0
1264: , p_init_msg_list => FND_API.G_FALSE
1265: , p_commit => FND_API.G_TRUE
1266: , p_dunning_rec => l_dunn_rec
1267: , x_return_status => l_return_status1
1268: , x_msg_count => l_msg_count1

Line 1265: , p_commit => FND_API.G_TRUE

1261:
1262: IEX_DUNNING_PVT.Update_DUNNING(
1263: p_api_version => 1.0
1264: , p_init_msg_list => FND_API.G_FALSE
1265: , p_commit => FND_API.G_TRUE
1266: , p_dunning_rec => l_dunn_rec
1267: , x_return_status => l_return_status1
1268: , x_msg_count => l_msg_count1
1269: , x_msg_data => l_msg_data1);

Line 1276: x_return_status := FND_API.G_RET_STS_ERROR;

1272: end if;
1273: end if;
1274: end if;
1275:
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: FND_MSG_PUB.Count_And_Get
1278: ( p_count => x_msg_count,
1279: p_data => x_msg_data);
1280:

Line 1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1277: FND_MSG_PUB.Count_And_Get
1278: ( p_count => x_msg_count,
1279: p_data => x_msg_data);
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: FND_MSG_PUB.Count_And_Get
1285: ( p_count => x_msg_count,

Line 1283: x_return_status := FND_API.G_RET_STS_ERROR;

1279: p_data => x_msg_data);
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: FND_MSG_PUB.Count_And_Get
1285: ( p_count => x_msg_count,
1286: p_data => x_msg_data);
1287: when others then

Line 1289: x_return_status := FND_API.G_RET_STS_ERROR;

1285: ( p_count => x_msg_count,
1286: p_data => x_msg_data);
1287: when others then
1288: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: FND_MSG_PUB.Count_And_Get
1291: ( p_count => x_msg_count,
1292: p_data => x_msg_data);
1293: End GetXmlData;