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 286: FND_MSG_PUB.initialize;

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:
289:
290: -- Initialize API return status to SUCCESS

Line 390: FND_MSG_PUB.Add;

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

Line 430: FND_MSG_PUB.Add;

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

Line 460: FND_MSG_PUB.Add;

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

Line 478: FND_MSG_PUB.Add;

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';
482:

Line 685: FND_MSG_PUB.Count_And_Get

681:
682: COMMIT WORK;
683:
684: -- Standard call to get message count and IF count is 1, get message info.
685: FND_MSG_PUB.Count_And_Get
686: ( p_count => x_msg_count,
687: p_data => x_msg_data );
688:
689: EXCEPTION

Line 701: FND_MSG_PUB.Count_And_Get

697: IEX_XML_PKG.update_row (
698: p_xml_request_id => l_request_id
699: ,p_status => l_status
700: );
701: FND_MSG_PUB.Count_And_Get
702: ( p_count => x_msg_count,
703: p_data => x_msg_data
704: );
705:

Line 717: FND_MSG_PUB.Count_And_Get

713: IEX_XML_PKG.update_row (
714: p_xml_request_id => l_request_id
715: ,p_status => l_status
716: );
717: FND_MSG_PUB.Count_And_Get
718: ( p_count => x_msg_count,
719: p_data => x_msg_data
720: );
721:

Line 733: FND_MSG_PUB.Count_And_Get

729: IEX_XML_PKG.update_row (
730: p_xml_request_id => l_request_id
731: ,p_status => l_status
732: );
733: FND_MSG_PUB.Count_And_Get
734: ( p_count => x_msg_count,
735: p_data => x_msg_data
736: );
737:

Line 771: FND_MSG_PUB.Add;

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

Line 782: FND_MSG_PUB.Add;

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

Line 792: FND_MSG_PUB.Count_And_Get

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

Line 802: FND_MSG_PUB.Count_And_Get

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
806: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);

Line 808: FND_MSG_PUB.Count_And_Get

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
812: WriteLog('RetrieveXmlData: Exc_Error:'|| SQLERRM);

Line 814: FND_MSG_PUB.Count_And_Get

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:
818: END RetrieveXmlData;

Line 938: FND_MSG_PUB.Add;

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

Line 1027: FND_MSG_PUB.Add;

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;
1030: end if;
1031:

Line 1072: FND_MSG_PUB.Add;

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

Line 1087: FND_MSG_PUB.Add;

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;
1090: end if;
1091: */

Line 1220: FND_MSG_PUB.Add;

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

Line 1235: FND_MSG_PUB.Count_And_Get

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

Line 1277: FND_MSG_PUB.Count_And_Get

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:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1284: FND_MSG_PUB.Count_And_Get

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
1288: WriteLog('GetXmlData: Exc_Error:'|| SQLERRM);

Line 1290: FND_MSG_PUB.Count_And_Get

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