DBA Data[Home] [Help]

APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on FND_MESSAGE

Line 1227: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');

1223: WHEN utl_file.invalid_path THEN
1224: IF (l_debug = 1) THEN
1225: trace('Invalid Path error in generate_xml_csv');
1226: END IF;
1227: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');
1228: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Path');
1229: FND_MSG_PUB.ADD;
1230: retval := -1;
1231: return retval;

Line 1228: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Path');

1224: IF (l_debug = 1) THEN
1225: trace('Invalid Path error in generate_xml_csv');
1226: END IF;
1227: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');
1228: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Path');
1229: FND_MSG_PUB.ADD;
1230: retval := -1;
1231: return retval;
1232: WHEN utl_file.invalid_mode THEN

Line 1236: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');

1232: WHEN utl_file.invalid_mode THEN
1233: IF (l_debug = 1) THEN
1234: trace('Invalid mode in generate_xml_csv: w');
1235: END IF;
1236: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');
1237: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Mode');
1238: FND_MSG_PUB.ADD;
1239: retval := -1;
1240: return retval;

Line 1237: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Mode');

1233: IF (l_debug = 1) THEN
1234: trace('Invalid mode in generate_xml_csv: w');
1235: END IF;
1236: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');
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

Line 1608: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_INVALID');

1604: x_return_status := 'E';
1605: IF (l_debug = 1) THEN
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:

Line 1627: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');

1623: x_return_status := 'E';
1624: IF (l_debug = 1) THEN
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:

Line 1638: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');

1634: IF p_request_id IS NULL THEN
1635: IF (l_debug = 1) THEN
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

Line 1652: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');

1648: WHEN no_data_found THEN
1649: IF (l_debug = 1) THEN
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;

Line 1774: FND_MESSAGE.SET_NAME('WMS', 'WMS_PICKREL_ERR');

1770: ELSIF (x_return_status = 'E')THEN
1771: IF (l_debug = 1) THEN
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:

Line 1799: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_ERR');

1795: ELSIF (x_return_status = 'E')THEN
1796: IF (l_debug = 1) THEN
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;

Line 1815: FND_MESSAGE.SET_NAME('WMS', 'WMS_SHIPCONFIRM_ERR');

1811: IF (x_return_status = 'E')THEN
1812: IF (l_debug = 1) THEN
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;

Line 1845: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_DETAIL_ERR');

1841: IF (x_return_status = 'E')THEN
1842: IF (l_debug = 1) THEN
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;

Line 2002: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');

1998: IF (l_debug = 1) THEN
1999: trace('Error: G_EXC_ERR : Delete request rows');
2000: END IF;
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

Line 2016: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');

2012: IF (l_debug = 1) THEN
2013: trace('Error: G_EXC_UNEXP : Delete request rows');
2014: END IF;
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

Line 2030: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');

2026: IF (l_debug = 1) THEN
2027: trace('Error: '||substr(sqlerrm, 1, 100));
2028: END IF;
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

Line 2198: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_INVALID');

2194: x_return_status := 'E';
2195: IF (l_debug = 1) THEN
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:

Line 2217: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');

2213: x_return_status := 'E';
2214: IF (l_debug = 1) THEN
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:

Line 2228: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');

2224: IF p_request_id IS NULL THEN
2225: IF (l_debug = 1) THEN
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

Line 2242: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');

2238: WHEN no_data_found THEN
2239: IF (l_debug = 1) THEN
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;

Line 2305: FND_MESSAGE.SET_NAME('WMS', 'WMS_PICKREL_ERR');

2301: ELSIF (x_return_status = 'E')THEN
2302: IF (l_debug = 1) THEN
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:

Line 2330: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_ERR');

2326: ELSIF (x_return_status = 'E')THEN
2327: IF (l_debug = 1) THEN
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;

Line 2346: FND_MESSAGE.SET_NAME('WMS', 'WMS_SHIPCONFIRM_ERR');

2342: IF (x_return_status = 'E')THEN
2343: IF (l_debug = 1) THEN
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;

Line 2382: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_DETAIL_ERR');

2378: IF (x_return_status = 'E')THEN
2379: IF (l_debug = 1) THEN
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;

Line 2532: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');

2528: IF (l_debug = 1) THEN
2529: trace('Error: G_EXC_ERR : Delete request rows');
2530: END IF;
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

Line 2546: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');

2542: IF (l_debug = 1) THEN
2543: trace('Error: G_EXC_UNEXP : Delete request rows');
2544: END IF;
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

Line 2560: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');

2556: IF (l_debug = 1) THEN
2557: trace('Error: '||substr(sqlerrm, 1, 100));
2558: END IF;
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

Line 2718: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');

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
2722: ( p_count => l_dev_req_type,

Line 2735: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');

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
2739: ( p_count => l_dev_req_type,

Line 2754: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');

2750: COMMIT;
2751:
2752: WHEN OTHERS THEN
2753: trace('Resubmit_req SQL error :'||substr(sqlerrm, 1, 240));
2754: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');
2755: FND_MSG_PUB.ADD;
2756: ROLLBACK TO WMS_DEVICE_REQUESTS;
2757: FND_MSG_PUB.Count_And_Get
2758: ( p_count => l_dev_req_type,