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.WMS_DEVICE_INTEGRATION_PVT dependencies on FND_API

Line 109: RAISE fnd_api.g_exc_unexpected_error;

105: x_return_status := 'E';
106: IF (l_debug = 1) THEN
107: trace('Error retrieve in ship confirm details, no data found');
108: END IF;
109: RAISE fnd_api.g_exc_unexpected_error;
110: WHEN others THEN
111: x_return_status := 'E';
112: IF (l_debug = 1) THEN
113: trace('Other error in retrieve ship confirm details');

Line 254: RAISE fnd_api.g_exc_unexpected_error;

250: x_return_status := 'E';
251: IF (l_debug = 1) THEN
252: trace('Error retrieve in business event details, no data found');
253: END IF;
254: RAISE fnd_api.g_exc_unexpected_error;
255: WHEN others THEN
256: x_return_status := 'E';
257: IF (l_debug = 1) THEN
258: trace('Other error in retrieve business event details');

Line 382: RAISE fnd_api.g_exc_unexpected_error;

378: x_return_status := 'E';
379: IF (l_debug = 1) THEN
380: trace('Error in retrieve business event details, no data found');
381: END IF;
382: RAISE fnd_api.g_exc_unexpected_error;
383: WHEN others THEN
384: x_return_status := 'E';
385: IF (l_debug = 1) THEN
386: trace('Other error in retrieve business event details');

Line 499: RAISE fnd_api.g_exc_unexpected_error;

495: x_return_status := 'E';
496: IF (l_debug = 1) THEN
497: trace('Error in retrieve business event details, no data found');
498: END IF;
499: RAISE fnd_api.g_exc_unexpected_error;
500: WHEN others THEN
501: x_return_status := 'E';
502: IF (l_debug = 1) THEN
503: trace('Other error in retrieve business event details');

Line 908: WHEN fnd_api.g_exc_error THEN

904: WHEN utl_file.invalid_mode THEN
905: IF (l_debug = 1) THEN
906: trace('Invalid mode in WriteToFile: w');
907: END IF;
908: WHEN fnd_api.g_exc_error THEN
909: IF (l_debug = 1) THEN
910: trace(' Expected Error in WriteXmlFile');
911: END IF;
912: WHEN fnd_api.g_exc_unexpected_error THEN

Line 912: WHEN fnd_api.g_exc_unexpected_error THEN

908: WHEN fnd_api.g_exc_error THEN
909: IF (l_debug = 1) THEN
910: trace(' Expected Error in WriteXmlFile');
911: END IF;
912: WHEN fnd_api.g_exc_unexpected_error THEN
913: IF (l_debug = 1) THEN
914: trace(' Unexpected Error in WriteXmlFile');
915: END IF;
916: WHEN OTHERS THEN

Line 1042: RAISE fnd_api.g_exc_unexpected_error;

1038: WHEN no_data_found THEN
1039: IF (l_debug = 1) THEN
1040: trace('Error in getting device property, no data found');
1041: END IF;
1042: RAISE fnd_api.g_exc_unexpected_error;
1043: WHEN others THEN
1044: IF (l_debug = 1) THEN
1045: trace('Other error in getting device property');
1046: trace('SQL error :'||substr(sqlerrm, 1, 240));

Line 1209: RAISE fnd_api.g_exc_unexpected_error;

1205: ELSE
1206: IF (l_debug = 1) THEN
1207: trace('Invalid iotype value passed to generate_xml_csv:'||p_iotype);
1208: END IF;
1209: RAISE fnd_api.g_exc_unexpected_error;
1210: END IF;
1211:
1212: -- update outfile_name
1213: IF (l_debug = 1) THEN

Line 1241: WHEN FND_API.G_EXC_ERROR THEN

1237: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Mode');
1238: FND_MSG_PUB.ADD;
1239: retval := -1;
1240: return retval;
1241: WHEN FND_API.G_EXC_ERROR THEN
1242: IF (l_debug = 1) THEN
1243: trace(' Expected error in generate XML ');
1244: END IF;
1245: RAISE FND_API.G_EXC_ERROR;

Line 1245: RAISE FND_API.G_EXC_ERROR;

1241: WHEN FND_API.G_EXC_ERROR THEN
1242: IF (l_debug = 1) THEN
1243: trace(' Expected error in generate XML ');
1244: END IF;
1245: RAISE FND_API.G_EXC_ERROR;
1246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1247: IF (l_debug = 1) THEN
1248: trace(' UnExpected error in generate XML ');
1249: END IF;

Line 1246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1242: IF (l_debug = 1) THEN
1243: trace(' Expected error in generate XML ');
1244: END IF;
1245: RAISE FND_API.G_EXC_ERROR;
1246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1247: IF (l_debug = 1) THEN
1248: trace(' UnExpected error in generate XML ');
1249: END IF;
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1247: IF (l_debug = 1) THEN
1248: trace(' UnExpected error in generate XML ');
1249: END IF;
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1251: WHEN OTHERS THEN
1252: IF (l_debug = 1) THEN
1253: trace(' Other error in generate XML ');
1254: trace('SQL error :'||substr(sqlerrm, 1, 240));

Line 1256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1252: IF (l_debug = 1) THEN
1253: trace(' Other error in generate XML ');
1254: trace('SQL error :'||substr(sqlerrm, 1, 240));
1255: END IF;
1256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1257: END generate_xml_csv;
1258:
1259:
1260:

Line 1509: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1505: -- DEVICE_REQUEST
1506: --
1507: ---------------------------------------------------------
1508: PROCEDURE DEVICE_REQUEST(
1509: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1510: p_bus_event IN NUMBER,
1511: p_call_ctx IN VARCHAR2 ,
1512: p_task_trx_id IN NUMBER := NULL,
1513: p_org_id IN NUMBER := NULL,

Line 1587: x_return_status := FND_API.G_RET_STS_SUCCESS;

1583: l_setup_row_cnt:=0;
1584: END;
1585:
1586: IF (l_setup_row_cnt = 0 AND p_bus_event < 50) THEN
1587: x_return_status := FND_API.G_RET_STS_SUCCESS;
1588: RETURN;
1589: END IF;
1590:
1591: SAVEPOINT WMS_DEVICE_REQUESTS;

Line 1593: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1589: END IF;
1590:
1591: SAVEPOINT WMS_DEVICE_REQUESTS;
1592: -- Initialize message list if p_init_msg_list is set to TRUE.
1593: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1594: FND_MSG_PUB.initialize;
1595: END IF;
1596: -- Initialize API return status to success
1597: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1597: x_return_status := FND_API.G_RET_STS_SUCCESS;

1593: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1594: FND_MSG_PUB.initialize;
1595: END IF;
1596: -- Initialize API return status to success
1597: x_return_status := FND_API.G_RET_STS_SUCCESS;
1598:
1599: IF (l_debug = 1) THEN
1600: trace('******* Device Request *********');
1601: END IF;

Line 1610: RAISE FND_API.G_EXC_ERROR;

1606: trace('Invlid Business Event');
1607: END IF;
1608: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_INVALID');
1609: FND_MSG_PUB.ADD;
1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;
1612:
1613: -- Verify parameters passed . Either TaskId should be not NULL or
1614: -- Org and Sub should be Not NULL

Line 1629: RAISE FND_API.G_EXC_ERROR;

1625: trace('Either Task_id is null or orgid is NULL OR sub IS NULL');
1626: END IF;
1627: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
1628: FND_MSG_PUB.ADD;
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1631:
1632: -- Validate p_request_id when the busniess event is Task Complete
1633: IF(p_bus_event in (wms_be_task_complete, wms_be_task_skip, wms_be_task_cancel)) THEN

Line 1640: RAISE FND_API.G_EXC_ERROR;

1636: trace('Error: p_request_id is null for Task Complete/skip/cancel bus event');
1637: END IF;
1638: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: ELSE
1642: BEGIN
1643: SELECT request_id INTO l_parent_request_id
1644: FROM wms_device_requests_hist

Line 1654: RAISE FND_API.G_EXC_ERROR;

1650: trace('Error: p_request_id is not valid for Task Complete/skip/cancel');
1651: END IF;
1652: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
1653: FND_MSG_PUB.ADD;
1654: RAISE FND_API.G_EXC_ERROR;
1655: END;
1656: END IF;
1657: IF (l_debug = 1) THEN
1658: trace('Passed validation for Task Complete/skip/cancel, l_parent_request_id='||l_parent_request_id);

Line 1776: RAISE FND_API.G_EXC_ERROR;

1772: trace ('Could not retrieve Event Details');
1773: END IF;
1774: FND_MESSAGE.SET_NAME('WMS', 'WMS_PICKREL_ERR');
1775: FND_MSG_PUB.ADD;
1776: RAISE FND_API.G_EXC_ERROR;
1777: END IF;
1778:
1779: ELSIF (p_task_trx_id IS NOT NULL) THEN
1780: IF (l_debug = 1) THEN

Line 1801: RAISE FND_API.G_EXC_ERROR;

1797: trace('Could not retrieve Event Details');
1798: END IF;
1799: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_ERR');
1800: FND_MSG_PUB.ADD;
1801: RAISE FND_API.G_EXC_ERROR;
1802: END IF;
1803: END IF;
1804: ELSIF (p_task_trx_id IS NOT NULL AND p_bus_event = wms_be_ship_confirm) THEN
1805: IF (l_debug = 1) THEN

Line 1817: RAISE FND_API.G_EXC_ERROR;

1813: trace('Could not retrieve ship confirm details');
1814: END IF;
1815: FND_MESSAGE.SET_NAME('WMS', 'WMS_SHIPCONFIRM_ERR');
1816: FND_MSG_PUB.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: end if;
1820:
1821: -- Loop on WMS_DEVICE_REQUESTS per device

Line 1847: RAISE FND_API.G_EXC_ERROR;

1843: trace('Could not retrieve lot and or serial details');
1844: END IF;
1845: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_DETAIL_ERR');
1846: FND_MSG_PUB.ADD;
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;
1849: l_lot_ser_ok:= NULL;
1850: END IF;
1851: end if;

Line 1890: RAISE FND_API.G_EXC_ERROR;

1886: IF (l_debug = 1) THEN
1887: trace('Error in updating relation_id on the request table for task complete/skip/cancel, dev_id='||l_cur_dev.device_id);
1888: trace('SQL error :'||substr(sqlerrm, 1, 240));
1889: END IF;
1890: RAISE FND_API.G_EXC_ERROR;
1891: END;
1892: END IF;
1893: END IF;
1894:

Line 1959: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN

1955: x_status_msg => l_req_stat_msg );
1956: END IF;
1957:
1958:
1959: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN
1960: UPDATE wms_device_requests
1961: SET status_code = l_req_stat,
1962: status_msg = l_req_stat_msg
1963: WHERE device_id = l_cur_dev.device_id;

Line 1997: WHEN FND_API.G_EXC_ERROR THEN

1993: END IF;
1994: delete from wms_device_requests;
1995:
1996: EXCEPTION
1997: WHEN FND_API.G_EXC_ERROR THEN
1998: IF (l_debug = 1) THEN
1999: trace('Error: G_EXC_ERR : Delete request rows');
2000: END IF;
2001: delete from wms_device_requests;

Line 2005: x_return_status := FND_API.G_RET_STS_ERROR;

2001: delete from wms_device_requests;
2002: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2003: FND_MSG_PUB.ADD;
2004: ROLLBACK TO WMS_DEVICE_REQUESTS;
2005: x_return_status := FND_API.G_RET_STS_ERROR;
2006: FND_MSG_PUB.Count_And_Get
2007: ( p_count => x_msg_count,
2008: p_data => x_msg_data
2009: );

Line 2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2007: ( p_count => x_msg_count,
2008: p_data => x_msg_data
2009: );
2010:
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: IF (l_debug = 1) THEN
2013: trace('Error: G_EXC_UNEXP : Delete request rows');
2014: END IF;
2015: delete from wms_device_requests;

Line 2019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2015: delete from wms_device_requests;
2016: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2017: FND_MSG_PUB.ADD;
2018: ROLLBACK TO WMS_DEVICE_REQUESTS;
2019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2020: FND_MSG_PUB.Count_And_Get
2021: ( p_count => x_msg_count,
2022: p_data => x_msg_data
2023: );

Line 2033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2029: delete from wms_device_requests;
2030: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2031: FND_MSG_PUB.ADD;
2032: ROLLBACK TO WMS_DEVICE_REQUESTS;
2033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2034: FND_MSG_PUB.Count_And_Get
2035: ( p_count => x_msg_count,
2036: p_data => x_msg_data
2037: );

Line 2042: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2038:
2039: END;
2040:
2041: PROCEDURE DEVICE_REQUEST(
2042: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2043: p_bus_event IN NUMBER,
2044: p_call_ctx IN VARCHAR2 ,
2045: p_task_trx_id IN NUMBER := NULL,
2046: p_org_id IN NUMBER := NULL,

Line 2105: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2101: The request traffic will get logged in the wms_device_requests_hist table
2102: in addition to being captured in wms_carousel_log
2103: */
2104: PROCEDURE DEVICE_REQUEST(
2105: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2106: p_bus_event IN NUMBER,
2107: p_call_ctx IN VARCHAR2 ,
2108: p_task_trx_id IN NUMBER := NULL,
2109: p_org_id IN NUMBER := NULL,

Line 2177: x_return_status := FND_API.G_RET_STS_SUCCESS;

2173: l_setup_row_cnt:=0;
2174: END;
2175:
2176: IF (l_setup_row_cnt = 0 AND p_bus_event < 50) THEN
2177: x_return_status := FND_API.G_RET_STS_SUCCESS;
2178: RETURN;
2179: END IF;
2180:
2181: SAVEPOINT WMS_DEVICE_REQUESTS;

Line 2183: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2179: END IF;
2180:
2181: SAVEPOINT WMS_DEVICE_REQUESTS;
2182: -- Initialize message list if p_init_msg_list is set to TRUE.
2183: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2184: FND_MSG_PUB.initialize;
2185: END IF;
2186: -- Initialize API return status to success
2187: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2187: x_return_status := FND_API.G_RET_STS_SUCCESS;

2183: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2184: FND_MSG_PUB.initialize;
2185: END IF;
2186: -- Initialize API return status to success
2187: x_return_status := FND_API.G_RET_STS_SUCCESS;
2188:
2189: IF (l_debug = 1) THEN
2190: trace('******* Device Request *********');
2191: END IF;

Line 2200: RAISE FND_API.G_EXC_ERROR;

2196: trace('Invlid Business Event');
2197: END IF;
2198: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_INVALID');
2199: FND_MSG_PUB.ADD;
2200: RAISE FND_API.G_EXC_ERROR;
2201: END IF;
2202:
2203: -- Verify parameters passed . Either TaskId should be not NULL or
2204: -- Org and Sub should be Not NULL

Line 2219: RAISE FND_API.G_EXC_ERROR;

2215: trace('Either Task_id is null or orgid is NULL OR sub IS NULL');
2216: END IF;
2217: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
2218: FND_MSG_PUB.ADD;
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;
2221:
2222: -- Validate p_request_id when the busniess event is Task Complete
2223: IF(p_bus_event in (wms_be_task_complete, wms_be_task_skip, wms_be_task_cancel)) THEN

Line 2230: RAISE FND_API.G_EXC_ERROR;

2226: trace('Error: p_request_id is null for Task Complete/skip/cancel bus event');
2227: END IF;
2228: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
2229: FND_MSG_PUB.ADD;
2230: RAISE FND_API.G_EXC_ERROR;
2231: ELSE
2232: BEGIN
2233: SELECT request_id INTO l_parent_request_id
2234: FROM wms_device_requests_hist

Line 2244: RAISE FND_API.G_EXC_ERROR;

2240: trace('Error: p_request_id is not valid for Task Complete/skip/cancel');
2241: END IF;
2242: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
2243: FND_MSG_PUB.ADD;
2244: RAISE FND_API.G_EXC_ERROR;
2245: END;
2246: END IF;
2247: IF (l_debug = 1) THEN
2248: trace('Passed validation for Task Complete/skip/cancel, l_parent_request_id='||l_parent_request_id);

Line 2307: RAISE FND_API.G_EXC_ERROR;

2303: trace ('Could not retrieve Event Details');
2304: END IF;
2305: FND_MESSAGE.SET_NAME('WMS', 'WMS_PICKREL_ERR');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309:
2310: ELSIF (p_task_trx_id IS NOT NULL) THEN
2311: IF (l_debug = 1) THEN

Line 2332: RAISE FND_API.G_EXC_ERROR;

2328: trace('Could not retrieve Event Details');
2329: END IF;
2330: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_ERR');
2331: FND_MSG_PUB.ADD;
2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;
2334: END IF;
2335: ELSIF (p_task_trx_id IS NOT NULL AND p_bus_event = wms_be_ship_confirm) THEN
2336: IF (l_debug = 1) THEN

Line 2348: RAISE FND_API.G_EXC_ERROR;

2344: trace('Could not retrieve ship confirm details');
2345: END IF;
2346: FND_MESSAGE.SET_NAME('WMS', 'WMS_SHIPCONFIRM_ERR');
2347: FND_MSG_PUB.ADD;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: end if;
2351:
2352: -- Loop on WMS_DEVICE_REQUESTS per device

Line 2384: RAISE FND_API.G_EXC_ERROR;

2380: trace('Could not retrieve lot and or serial details');
2381: END IF;
2382: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_DETAIL_ERR');
2383: FND_MSG_PUB.ADD;
2384: RAISE FND_API.G_EXC_ERROR;
2385: END IF;
2386: l_lot_ser_ok:= NULL;
2387: END IF;
2388: end if;

Line 2427: RAISE FND_API.G_EXC_ERROR;

2423: IF (l_debug = 1) THEN
2424: trace('Error in updating relation_id on the request table for task complete/skip/cancel, dev_id='||l_cur_dev.device_id);
2425: trace('SQL error :'||substr(sqlerrm, 1, 240));
2426: END IF;
2427: RAISE FND_API.G_EXC_ERROR;
2428: END;
2429: END IF;
2430: END IF;
2431:

Line 2496: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN

2492: x_status_msg => l_req_stat_msg );
2493: END IF;
2494:
2495:
2496: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN
2497: UPDATE wms_device_requests
2498: SET status_code = l_req_stat,
2499: status_msg = l_req_stat_msg
2500: WHERE device_id = l_cur_dev.device_id;

Line 2527: WHEN FND_API.G_EXC_ERROR THEN

2523: END IF;
2524: delete from wms_device_requests;
2525:
2526: EXCEPTION
2527: WHEN FND_API.G_EXC_ERROR THEN
2528: IF (l_debug = 1) THEN
2529: trace('Error: G_EXC_ERR : Delete request rows');
2530: END IF;
2531: delete from wms_device_requests;

Line 2535: x_return_status := FND_API.G_RET_STS_ERROR;

2531: delete from wms_device_requests;
2532: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2533: FND_MSG_PUB.ADD;
2534: ROLLBACK TO WMS_DEVICE_REQUESTS;
2535: x_return_status := FND_API.G_RET_STS_ERROR;
2536: FND_MSG_PUB.Count_And_Get
2537: ( p_count => x_msg_count,
2538: p_data => x_msg_data
2539: );

Line 2541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2537: ( p_count => x_msg_count,
2538: p_data => x_msg_data
2539: );
2540:
2541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2542: IF (l_debug = 1) THEN
2543: trace('Error: G_EXC_UNEXP : Delete request rows');
2544: END IF;
2545: delete from wms_device_requests;

Line 2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2545: delete from wms_device_requests;
2546: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2547: FND_MSG_PUB.ADD;
2548: ROLLBACK TO WMS_DEVICE_REQUESTS;
2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2550: FND_MSG_PUB.Count_And_Get
2551: ( p_count => x_msg_count,
2552: p_data => x_msg_data
2553: );

Line 2563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2559: delete from wms_device_requests;
2560: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2561: FND_MSG_PUB.ADD;
2562: ROLLBACK TO WMS_DEVICE_REQUESTS;
2563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2564: FND_MSG_PUB.Count_And_Get
2565: ( p_count => x_msg_count,
2566: p_data => x_msg_data
2567: );

Line 2643: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN

2639: ,p_request_id
2640: ,l_successful_row_cnt
2641: );
2642:
2643: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN
2644: IF (l_debug = 1) THEN
2645: trace('device Confirmation returned:Unexpected error:l_msg_count'||l_msg_count||'::l_msg_data:'||l_msg_data);
2646: END IF;
2647: RAISE FND_API.g_exc_unexpected_error;

Line 2647: RAISE FND_API.g_exc_unexpected_error;

2643: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN
2644: IF (l_debug = 1) THEN
2645: trace('device Confirmation returned:Unexpected error:l_msg_count'||l_msg_count||'::l_msg_data:'||l_msg_data);
2646: END IF;
2647: RAISE FND_API.g_exc_unexpected_error;
2648: ELSE
2649: IF (l_debug = 1) THEN
2650: trace('device Confirmation returned:Success:Number of successful rows ::'||l_successful_row_cnt);
2651: END IF;

Line 2692: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN

2688: x_device_status => l_dev_stat,
2689: x_status_msg => l_stat_msg );
2690: END IF;
2691:
2692: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN
2693: UPDATE wms_device_requests_hist
2694: SET status_code = l_req_stat,
2695: status_msg = l_stat_msg
2696: WHERE device_id = l_rec.dev_id

Line 2717: WHEN FND_API.G_EXC_ERROR THEN

2713: AND Nvl(business_event_id,-1) = Nvl(p_business_event_id,-1)
2714: AND Nvl(sequence_id,-1) = Nvl(p_sequence_id,nvl(sequence_id, -1));
2715:
2716: EXCEPTION
2717: WHEN FND_API.G_EXC_ERROR THEN
2718: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');
2719: FND_MSG_PUB.ADD;
2720: ROLLBACK TO WMS_DEVICE_REQUESTS;
2721: FND_MSG_PUB.Count_And_Get

Line 2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2730: AND status_code = 'P';
2731:
2732: COMMIT;
2733:
2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2735: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');
2736: FND_MSG_PUB.ADD;
2737: ROLLBACK TO WMS_DEVICE_REQUESTS;
2738: FND_MSG_PUB.Count_And_Get

Line 2801: x_return_status := FND_API.G_RET_STS_SUCCESS;

2797: IF l_device_cnt = 0 THEN
2798: IF (l_debug = 1) THEN
2799: trace(' No device exist in this Org'||p_org_id);
2800: END IF;
2801: x_return_status := FND_API.G_RET_STS_SUCCESS;
2802: RETURN;
2803: ELSIF p_bus_event_id IS NOT NULL THEN --check in the association table between device and bus_event
2804:
2805: BEGIN

Line 2823: x_return_status := FND_API.G_RET_STS_SUCCESS;

2819: IF (l_setup_row_cnt = 0 AND (p_bus_event_id < 50 )) THEN
2820: IF (l_debug = 1) THEN
2821: trace(' Device Request is not being used for business event='||p_bus_event_id);
2822: END IF;
2823: x_return_status := FND_API.G_RET_STS_SUCCESS;
2824: RETURN;
2825: END IF;
2826:
2827: END IF ;

Line 2846: x_return_status := FND_API.G_RET_STS_SUCCESS;

2842:
2843: IF (l_debug = 1) THEN
2844: trace('wms_call_device_request:::'||wms_call_device_request);
2845: END IF;
2846: x_return_status := FND_API.G_RET_STS_SUCCESS;
2847:
2848: END is_device_set_up;
2849:
2850: