DBA Data[Home] [Help]

APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on FND_MESSAGE

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

1201: WHEN utl_file.invalid_path THEN
1202: IF (l_debug = 1) THEN
1203: trace('Invalid Path error in generate_xml_csv');
1204: END IF;
1205: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');
1206: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Path');
1207: FND_MSG_PUB.ADD;
1208: retval := -1;
1209: return retval;

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

1202: IF (l_debug = 1) THEN
1203: trace('Invalid Path error in generate_xml_csv');
1204: END IF;
1205: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');
1206: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Path');
1207: FND_MSG_PUB.ADD;
1208: retval := -1;
1209: return retval;
1210: WHEN utl_file.invalid_mode THEN

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

1210: WHEN utl_file.invalid_mode THEN
1211: IF (l_debug = 1) THEN
1212: trace('Invalid mode in generate_xml_csv: w');
1213: END IF;
1214: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');
1215: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Mode');
1216: FND_MSG_PUB.ADD;
1217: retval := -1;
1218: return retval;

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

1211: IF (l_debug = 1) THEN
1212: trace('Invalid mode in generate_xml_csv: w');
1213: END IF;
1214: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_SETUP_ERR');
1215: FND_MESSAGE.SET_TOKEN('ERROR_REASON', 'Invalid Mode');
1216: FND_MSG_PUB.ADD;
1217: retval := -1;
1218: return retval;
1219: WHEN FND_API.G_EXC_ERROR THEN

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

1565: x_return_status := 'E';
1566: IF (l_debug = 1) THEN
1567: trace('Invlid Business Event');
1568: END IF;
1569: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_INVALID');
1570: FND_MSG_PUB.ADD;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:

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

1584: x_return_status := 'E';
1585: IF (l_debug = 1) THEN
1586: trace('Either Task_id is null or orgid is NULL OR sub IS NULL');
1587: END IF;
1588: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
1589: FND_MSG_PUB.ADD;
1590: RAISE FND_API.G_EXC_ERROR;
1591: END IF;
1592:

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

1595: IF p_request_id IS NULL THEN
1596: IF (l_debug = 1) THEN
1597: trace('Error: p_request_id is null for Task Complete/skip/cancel bus event');
1598: END IF;
1599: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
1600: FND_MSG_PUB.ADD;
1601: RAISE FND_API.G_EXC_ERROR;
1602: ELSE
1603: BEGIN

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

1609: WHEN no_data_found THEN
1610: IF (l_debug = 1) THEN
1611: trace('Error: p_request_id is not valid for Task Complete/skip/cancel');
1612: END IF;
1613: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
1614: FND_MSG_PUB.ADD;
1615: RAISE FND_API.G_EXC_ERROR;
1616: END;
1617: END IF;

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

1688: ELSIF (x_return_status = 'E')THEN
1689: IF (l_debug = 1) THEN
1690: trace ('Could not retrieve Event Details');
1691: END IF;
1692: FND_MESSAGE.SET_NAME('WMS', 'WMS_PICKREL_ERR');
1693: FND_MSG_PUB.ADD;
1694: RAISE FND_API.G_EXC_ERROR;
1695: END IF;
1696:

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

1713: ELSIF (x_return_status = 'E')THEN
1714: IF (l_debug = 1) THEN
1715: trace('Could not retrieve Event Details');
1716: END IF;
1717: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_ERR');
1718: FND_MSG_PUB.ADD;
1719: RAISE FND_API.G_EXC_ERROR;
1720: END IF;
1721: END IF;

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

1729: IF (x_return_status = 'E')THEN
1730: IF (l_debug = 1) THEN
1731: trace('Could not retrieve ship confirm details');
1732: END IF;
1733: FND_MESSAGE.SET_NAME('WMS', 'WMS_SHIPCONFIRM_ERR');
1734: FND_MSG_PUB.ADD;
1735: RAISE FND_API.G_EXC_ERROR;
1736: END IF;
1737: end if;

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

1759: IF (x_return_status = 'E')THEN
1760: IF (l_debug = 1) THEN
1761: trace('Could not retrieve lot and or serial details');
1762: END IF;
1763: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_DETAIL_ERR');
1764: FND_MSG_PUB.ADD;
1765: RAISE FND_API.G_EXC_ERROR;
1766: END IF;
1767: l_lot_ser_ok:= NULL;

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

1916: IF (l_debug = 1) THEN
1917: trace('Error: G_EXC_ERR : Delete request rows');
1918: END IF;
1919: delete from wms_device_requests;
1920: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
1921: FND_MSG_PUB.ADD;
1922: ROLLBACK TO WMS_DEVICE_REQUESTS;
1923: x_return_status := FND_API.G_RET_STS_ERROR;
1924: FND_MSG_PUB.Count_And_Get

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

1930: IF (l_debug = 1) THEN
1931: trace('Error: G_EXC_UNEXP : Delete request rows');
1932: END IF;
1933: delete from wms_device_requests;
1934: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
1935: FND_MSG_PUB.ADD;
1936: ROLLBACK TO WMS_DEVICE_REQUESTS;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: FND_MSG_PUB.Count_And_Get

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

1944: IF (l_debug = 1) THEN
1945: trace('Error: '||substr(sqlerrm, 1, 100));
1946: END IF;
1947: delete from wms_device_requests;
1948: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
1949: FND_MSG_PUB.ADD;
1950: ROLLBACK TO WMS_DEVICE_REQUESTS;
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.Count_And_Get

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

2110: x_return_status := 'E';
2111: IF (l_debug = 1) THEN
2112: trace('Invlid Business Event');
2113: END IF;
2114: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_INVALID');
2115: FND_MSG_PUB.ADD;
2116: RAISE FND_API.G_EXC_ERROR;
2117: END IF;
2118:

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

2129: x_return_status := 'E';
2130: IF (l_debug = 1) THEN
2131: trace('Either Task_id is null or orgid is NULL OR sub IS NULL');
2132: END IF;
2133: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
2134: FND_MSG_PUB.ADD;
2135: RAISE FND_API.G_EXC_ERROR;
2136: END IF;
2137:

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

2140: IF p_request_id IS NULL THEN
2141: IF (l_debug = 1) THEN
2142: trace('Error: p_request_id is null for Task Complete/skip/cancel bus event');
2143: END IF;
2144: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
2145: FND_MSG_PUB.ADD;
2146: RAISE FND_API.G_EXC_ERROR;
2147: ELSE
2148: BEGIN

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

2154: WHEN no_data_found THEN
2155: IF (l_debug = 1) THEN
2156: trace('Error: p_request_id is not valid for Task Complete/skip/cancel');
2157: END IF;
2158: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVOKE_ERR');
2159: FND_MSG_PUB.ADD;
2160: RAISE FND_API.G_EXC_ERROR;
2161: END;
2162: END IF;

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

2217: ELSIF (x_return_status = 'E')THEN
2218: IF (l_debug = 1) THEN
2219: trace ('Could not retrieve Event Details');
2220: END IF;
2221: FND_MESSAGE.SET_NAME('WMS', 'WMS_PICKREL_ERR');
2222: FND_MSG_PUB.ADD;
2223: RAISE FND_API.G_EXC_ERROR;
2224: END IF;
2225:

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

2242: ELSIF (x_return_status = 'E')THEN
2243: IF (l_debug = 1) THEN
2244: trace('Could not retrieve Event Details');
2245: END IF;
2246: FND_MESSAGE.SET_NAME('WMS', 'WMS_BUSEVENT_ERR');
2247: FND_MSG_PUB.ADD;
2248: RAISE FND_API.G_EXC_ERROR;
2249: END IF;
2250: END IF;

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

2258: IF (x_return_status = 'E')THEN
2259: IF (l_debug = 1) THEN
2260: trace('Could not retrieve ship confirm details');
2261: END IF;
2262: FND_MESSAGE.SET_NAME('WMS', 'WMS_SHIPCONFIRM_ERR');
2263: FND_MSG_PUB.ADD;
2264: RAISE FND_API.G_EXC_ERROR;
2265: END IF;
2266: end if;

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

2294: IF (x_return_status = 'E')THEN
2295: IF (l_debug = 1) THEN
2296: trace('Could not retrieve lot and or serial details');
2297: END IF;
2298: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_DETAIL_ERR');
2299: FND_MSG_PUB.ADD;
2300: RAISE FND_API.G_EXC_ERROR;
2301: END IF;
2302: l_lot_ser_ok:= NULL;

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

2444: IF (l_debug = 1) THEN
2445: trace('Error: G_EXC_ERR : Delete request rows');
2446: END IF;
2447: delete from wms_device_requests;
2448: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2449: FND_MSG_PUB.ADD;
2450: ROLLBACK TO WMS_DEVICE_REQUESTS;
2451: x_return_status := FND_API.G_RET_STS_ERROR;
2452: FND_MSG_PUB.Count_And_Get

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

2458: IF (l_debug = 1) THEN
2459: trace('Error: G_EXC_UNEXP : Delete request rows');
2460: END IF;
2461: delete from wms_device_requests;
2462: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2463: FND_MSG_PUB.ADD;
2464: ROLLBACK TO WMS_DEVICE_REQUESTS;
2465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2466: FND_MSG_PUB.Count_And_Get

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

2472: IF (l_debug = 1) THEN
2473: trace('Error: '||substr(sqlerrm, 1, 100));
2474: END IF;
2475: delete from wms_device_requests;
2476: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_REQ_FAIL');
2477: FND_MSG_PUB.ADD;
2478: ROLLBACK TO WMS_DEVICE_REQUESTS;
2479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2480: FND_MSG_PUB.Count_And_Get

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

2630: AND Nvl(sequence_id,-1) = Nvl(p_sequence_id,nvl(sequence_id, -1));
2631:
2632: EXCEPTION
2633: WHEN FND_API.G_EXC_ERROR THEN
2634: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');
2635: FND_MSG_PUB.ADD;
2636: ROLLBACK TO WMS_DEVICE_REQUESTS;
2637: FND_MSG_PUB.Count_And_Get
2638: ( p_count => l_dev_req_type,

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

2647:
2648: COMMIT;
2649:
2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');
2652: FND_MSG_PUB.ADD;
2653: ROLLBACK TO WMS_DEVICE_REQUESTS;
2654: FND_MSG_PUB.Count_And_Get
2655: ( p_count => l_dev_req_type,

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

2666: COMMIT;
2667:
2668: WHEN OTHERS THEN
2669: trace('Resubmit_req SQL error :'||substr(sqlerrm, 1, 240));
2670: FND_MESSAGE.SET_NAME('WMS', 'WMS_DEV_RESUBMIT_FAIL');
2671: FND_MSG_PUB.ADD;
2672: ROLLBACK TO WMS_DEVICE_REQUESTS;
2673: FND_MSG_PUB.Count_And_Get
2674: ( p_count => l_dev_req_type,