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_MSG_PUB

Line 1207: FND_MSG_PUB.ADD;

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
1211: IF (l_debug = 1) THEN

Line 1216: FND_MSG_PUB.ADD;

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
1220: IF (l_debug = 1) THEN

Line 1447: fnd_msg_pub.count_And_get(

1443: l_msg_count number;
1444: l_msg_data varchar2(240);
1445: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1446: BEGIN
1447: fnd_msg_pub.count_And_get(
1448: p_count => l_msg_count,
1449: p_data => l_msg_data,
1450: p_encoded => 'F'
1451: );

Line 1460: l_msg_data := fnd_msg_pub.get(l_msg_count,'F');

1456: l_msg_data := '';
1457: ELSIF l_msg_count =1 THEN
1458: null;
1459: ELSE
1460: l_msg_data := fnd_msg_pub.get(l_msg_count,'F');
1461:
1462: /*l_msg_data := '';
1463: FOR i IN 1..l_msg_count LOOP
1464: l_msg_data := l_msg_data || fnd_msg_pub.get(I,'F');

Line 1464: l_msg_data := l_msg_data || fnd_msg_pub.get(I,'F');

1460: l_msg_data := fnd_msg_pub.get(l_msg_count,'F');
1461:
1462: /*l_msg_data := '';
1463: FOR i IN 1..l_msg_count LOOP
1464: l_msg_data := l_msg_data || fnd_msg_pub.get(I,'F');
1465: END LOOP;
1466: */
1467: END IF;
1468: FND_MSG_PUB.initialize;

Line 1468: FND_MSG_PUB.initialize;

1464: l_msg_data := l_msg_data || fnd_msg_pub.get(I,'F');
1465: END LOOP;
1466: */
1467: END IF;
1468: FND_MSG_PUB.initialize;
1469: RETURN l_msg_data;
1470: END GET_MSG_STACK;
1471:
1472: ---------------------------------------------------------

Line 1555: FND_MSG_PUB.initialize;

1551:
1552: SAVEPOINT WMS_DEVICE_REQUESTS;
1553: -- Initialize message list if p_init_msg_list is set to TRUE.
1554: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1555: FND_MSG_PUB.initialize;
1556: END IF;
1557: -- Initialize API return status to success
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;
1559:

Line 1570: FND_MSG_PUB.ADD;

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:
1574: -- Verify parameters passed . Either TaskId should be not NULL or

Line 1589: FND_MSG_PUB.ADD;

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:
1593: -- Validate p_request_id when the busniess event is Task Complete

Line 1600: FND_MSG_PUB.ADD;

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
1604: SELECT request_id INTO l_parent_request_id

Line 1614: FND_MSG_PUB.ADD;

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;
1618: IF (l_debug = 1) THEN

Line 1693: FND_MSG_PUB.ADD;

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:
1697: ELSIF (p_task_trx_id IS NOT NULL) THEN

Line 1718: FND_MSG_PUB.ADD;

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;
1722: ELSIF (p_task_trx_id IS NOT NULL AND p_bus_event = wms_be_ship_confirm) THEN

Line 1734: FND_MSG_PUB.ADD;

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

Line 1764: FND_MSG_PUB.ADD;

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;
1768: END IF;

Line 1921: FND_MSG_PUB.ADD;

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
1925: ( p_count => x_msg_count,

Line 1924: FND_MSG_PUB.Count_And_Get

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
1925: ( p_count => x_msg_count,
1926: p_data => x_msg_data
1927: );
1928:

Line 1935: FND_MSG_PUB.ADD;

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
1939: ( p_count => x_msg_count,

Line 1938: FND_MSG_PUB.Count_And_Get

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
1939: ( p_count => x_msg_count,
1940: p_data => x_msg_data
1941: );
1942:

Line 1949: FND_MSG_PUB.ADD;

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
1953: ( p_count => x_msg_count,

Line 1952: FND_MSG_PUB.Count_And_Get

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
1953: ( p_count => x_msg_count,
1954: p_data => x_msg_data
1955: );
1956:

Line 2100: FND_MSG_PUB.initialize;

2096:
2097: SAVEPOINT WMS_DEVICE_REQUESTS;
2098: -- Initialize message list if p_init_msg_list is set to TRUE.
2099: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2100: FND_MSG_PUB.initialize;
2101: END IF;
2102: -- Initialize API return status to success
2103: x_return_status := FND_API.G_RET_STS_SUCCESS;
2104:

Line 2115: FND_MSG_PUB.ADD;

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:
2119: -- Verify parameters passed . Either TaskId should be not NULL or

Line 2134: FND_MSG_PUB.ADD;

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:
2138: -- Validate p_request_id when the busniess event is Task Complete

Line 2145: FND_MSG_PUB.ADD;

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
2149: SELECT request_id INTO l_parent_request_id

Line 2159: FND_MSG_PUB.ADD;

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;
2163: IF (l_debug = 1) THEN

Line 2222: FND_MSG_PUB.ADD;

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:
2226: ELSIF (p_task_trx_id IS NOT NULL) THEN

Line 2247: FND_MSG_PUB.ADD;

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;
2251: ELSIF (p_task_trx_id IS NOT NULL AND p_bus_event = wms_be_ship_confirm) THEN

Line 2263: FND_MSG_PUB.ADD;

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

Line 2299: FND_MSG_PUB.ADD;

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;
2303: END IF;

Line 2449: FND_MSG_PUB.ADD;

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
2453: ( p_count => x_msg_count,

Line 2452: FND_MSG_PUB.Count_And_Get

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
2453: ( p_count => x_msg_count,
2454: p_data => x_msg_data
2455: );
2456:

Line 2463: FND_MSG_PUB.ADD;

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
2467: ( p_count => x_msg_count,

Line 2466: FND_MSG_PUB.Count_And_Get

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
2467: ( p_count => x_msg_count,
2468: p_data => x_msg_data
2469: );
2470:

Line 2477: FND_MSG_PUB.ADD;

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
2481: ( p_count => x_msg_count,

Line 2480: FND_MSG_PUB.Count_And_Get

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
2481: ( p_count => x_msg_count,
2482: p_data => x_msg_data
2483: );
2484:

Line 2635: FND_MSG_PUB.ADD;

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,
2639: p_data => l_req_stat

Line 2637: FND_MSG_PUB.Count_And_Get

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,
2639: p_data => l_req_stat
2640: );
2641: --this is set to P in the form while making call to concurrent req

Line 2652: FND_MSG_PUB.ADD;

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,
2656: p_data => l_req_stat

Line 2654: FND_MSG_PUB.Count_And_Get

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,
2656: p_data => l_req_stat
2657: );
2658:

Line 2671: FND_MSG_PUB.ADD;

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,
2675: p_data => l_req_stat

Line 2673: FND_MSG_PUB.Count_And_Get

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,
2675: p_data => l_req_stat
2676: );
2677: --this is set to P in the form while making call to concurrent req