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 1229: FND_MSG_PUB.ADD;

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

Line 1238: FND_MSG_PUB.ADD;

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

Line 1479: fnd_msg_pub.count_And_get(

1475: l_msg_count number;
1476: l_msg_data varchar2(240);
1477: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1478: BEGIN
1479: fnd_msg_pub.count_And_get(
1480: p_count => l_msg_count,
1481: p_data => l_msg_data,
1482: p_encoded => 'F'
1483: );

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

1488: l_msg_data := '';
1489: ELSIF l_msg_count =1 THEN
1490: null;
1491: ELSE
1492: l_msg_data := fnd_msg_pub.get(l_msg_count,'F');
1493:
1494: /*l_msg_data := '';
1495: FOR i IN 1..l_msg_count LOOP
1496: l_msg_data := l_msg_data || fnd_msg_pub.get(I,'F');

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

1492: l_msg_data := fnd_msg_pub.get(l_msg_count,'F');
1493:
1494: /*l_msg_data := '';
1495: FOR i IN 1..l_msg_count LOOP
1496: l_msg_data := l_msg_data || fnd_msg_pub.get(I,'F');
1497: END LOOP;
1498: */
1499: END IF;
1500: FND_MSG_PUB.initialize;

Line 1500: FND_MSG_PUB.initialize;

1496: l_msg_data := l_msg_data || fnd_msg_pub.get(I,'F');
1497: END LOOP;
1498: */
1499: END IF;
1500: FND_MSG_PUB.initialize;
1501: RETURN l_msg_data;
1502: END GET_MSG_STACK;
1503:
1504: ---------------------------------------------------------

Line 1594: FND_MSG_PUB.initialize;

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

Line 1609: FND_MSG_PUB.ADD;

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

Line 1628: FND_MSG_PUB.ADD;

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

Line 1639: FND_MSG_PUB.ADD;

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

Line 1653: FND_MSG_PUB.ADD;

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

Line 1775: FND_MSG_PUB.ADD;

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

Line 1800: FND_MSG_PUB.ADD;

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

Line 1816: FND_MSG_PUB.ADD;

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

Line 1846: FND_MSG_PUB.ADD;

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

Line 2003: FND_MSG_PUB.ADD;

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

Line 2006: FND_MSG_PUB.Count_And_Get

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: );
2010:

Line 2017: FND_MSG_PUB.ADD;

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

Line 2020: FND_MSG_PUB.Count_And_Get

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: );
2024:

Line 2031: FND_MSG_PUB.ADD;

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

Line 2034: FND_MSG_PUB.Count_And_Get

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: );
2038:

Line 2184: FND_MSG_PUB.initialize;

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

Line 2199: FND_MSG_PUB.ADD;

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

Line 2218: FND_MSG_PUB.ADD;

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

Line 2229: FND_MSG_PUB.ADD;

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

Line 2243: FND_MSG_PUB.ADD;

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

Line 2306: FND_MSG_PUB.ADD;

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

Line 2331: FND_MSG_PUB.ADD;

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

Line 2347: FND_MSG_PUB.ADD;

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

Line 2383: FND_MSG_PUB.ADD;

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

Line 2533: FND_MSG_PUB.ADD;

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

Line 2536: FND_MSG_PUB.Count_And_Get

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: );
2540:

Line 2547: FND_MSG_PUB.ADD;

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

Line 2550: FND_MSG_PUB.Count_And_Get

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: );
2554:

Line 2561: FND_MSG_PUB.ADD;

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

Line 2564: FND_MSG_PUB.Count_And_Get

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: );
2568:

Line 2719: FND_MSG_PUB.ADD;

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

Line 2721: FND_MSG_PUB.Count_And_Get

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

Line 2736: FND_MSG_PUB.ADD;

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

Line 2738: FND_MSG_PUB.Count_And_Get

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,
2740: p_data => l_req_stat
2741: );
2742:

Line 2755: FND_MSG_PUB.ADD;

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

Line 2757: FND_MSG_PUB.Count_And_Get

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