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_TASK_UTILS_PVT dependencies on FND_API

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: mydebug('Exception occurred: ' || sqlerrm);
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END;
76:
77:
78:

Line 272: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

268: , p_transaction_temp_id => l_temp_id
269: , p_quantity_to_delete => l_quantity
270: );
271:
272: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
273: IF (l_debug = 1) THEN
274: mydebug(' error returned from inv_mo_cancel_pvt.reduce_rsv_allocation');
275: mydebug(x_message);
276: END IF;

Line 278: RAISE fnd_api.g_exc_error;

274: mydebug(' error returned from inv_mo_cancel_pvt.reduce_rsv_allocation');
275: mydebug(x_message);
276: END IF;
277:
278: RAISE fnd_api.g_exc_error;
279: ELSE
280: IF (l_debug = 1) THEN
281: mydebug(' Successful from inv_mo_cancel_pvt.reduce_rsv_allocation Call');
282: END IF;

Line 477: , p_validation_level => fnd_api.g_valid_level_none

473:
474: wms_container_pvt.Modify_LPN
475: (
476: p_api_version => 1.0
477: , p_validation_level => fnd_api.g_valid_level_none
478: , x_return_status => l_return_status
479: , x_msg_count => l_msg_count
480: , x_msg_data => l_msg_data
481: , p_lpn => l_lpn

Line 549: , p_validation_level => fnd_api.g_valid_level_none

545:
546: wms_container_pvt.Modify_LPN
547: (
548: p_api_version => 1.0
549: , p_validation_level => fnd_api.g_valid_level_none
550: , x_return_status => l_return_status
551: , x_msg_count => l_msg_count
552: , x_msg_data => l_msg_data
553: , p_lpn => l_lpn

Line 571: , p_validation_level => fnd_api.g_valid_level_none

567:
568: wms_container_pvt.Modify_LPN
569: (
570: p_api_version => 1.0
571: , p_validation_level => fnd_api.g_valid_level_none
572: , x_return_status => l_return_status
573: , x_msg_count => l_msg_count
574: , x_msg_data => l_msg_data
575: , p_lpn => l_lpn

Line 727: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

723: l_is_serial_control BOOLEAN := FALSE;
724: l_tree_mode NUMBER;
725: l_api_version_number CONSTANT NUMBER := 1.0;
726: l_api_name CONSTANT VARCHAR2(30) := 'check_qty_avail';
727: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
728: l_tree_id INTEGER;
729: l_rqoh NUMBER;
730: l_qr NUMBER;
731: l_qs NUMBER;

Line 780: , p_init_msg_lst => fnd_api.g_false

776: END IF;
777:
778: inv_quantity_tree_pub.query_quantities(
779: p_api_version_number => 1.0
780: , p_init_msg_lst => fnd_api.g_false
781: , x_return_status => l_return_status
782: , x_msg_count => l_msg_count
783: , x_msg_data => l_msg_data
784: , p_organization_id => mmtt_row.organization_id

Line 846: WHEN fnd_api.g_exc_unexpected_error THEN

842: END IF;
843:
844: RETURN l_ret;
845: EXCEPTION
846: WHEN fnd_api.g_exc_unexpected_error THEN
847: IF (l_debug = 1) THEN
848: mydebug('unexpected error in check_qty_avail');
849: END IF;
850:

Line 852: RAISE fnd_api.g_exc_unexpected_error;

848: mydebug('unexpected error in check_qty_avail');
849: END IF;
850:
851: l_ret := FALSE;
852: RAISE fnd_api.g_exc_unexpected_error;
853: RETURN l_ret;
854: WHEN OTHERS THEN
855: IF (l_debug = 1) THEN
856: mydebug('Exception in check_qty_avail');

Line 1459: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

1455: --BUG 2698630 fix
1456: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1457: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
1458: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
1459: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1460: l_msg_count NUMBER;
1461: l_msg_data VARCHAR2(2000);
1462: l_line_num Number := 0;
1463: l_uom VARCHAR2(60);

Line 1484: x_ret_code := fnd_api.g_ret_sts_success;

1480:
1481: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1482: BEGIN
1483: SAVEPOINT generate_next_task;
1484: x_ret_code := fnd_api.g_ret_sts_success;
1485:
1486: IF (l_debug = 1) THEN
1487: mydebug('In generate_next_task');
1488: END IF;

Line 1584: RAISE fnd_api.g_exc_unexpected_error;

1580: IF (l_debug = 1) THEN
1581: mydebug('ERROR - Number of rows for this header are more than one ');
1582: mydebug('Raising an unexpected error ');
1583: END IF;
1584: RAISE fnd_api.g_exc_unexpected_error;
1585:
1586: END IF;
1587: */
1588: FOR cnt IN 1 .. mmtt_table.COUNT LOOP

Line 1693: RAISE fnd_api.g_exc_unexpected_error;

1689: AND organization_id = mmtt_table(cnt).organization_id;
1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: mydebug('Exception getting the item information');
1693: RAISE fnd_api.g_exc_unexpected_error;
1694: END;
1695:
1696: /***** Bug 2999296 Updating locator capacity ***********/
1697:

Line 1712: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1708: , p_transaction_uom_code => NULL
1709: , p_quantity => mmtt_row.primary_quantity
1710: );
1711:
1712: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1713: mydebug('Unexpected error in update_loc_suggested_capacity');
1714: -- Bug 5393727: do not raise an exception if revert API returns an error
1715: -- RAISE fnd_api.g_exc_unexpected_error;
1716: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 1715: -- RAISE fnd_api.g_exc_unexpected_error;

1711:
1712: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1713: mydebug('Unexpected error in update_loc_suggested_capacity');
1714: -- Bug 5393727: do not raise an exception if revert API returns an error
1715: -- RAISE fnd_api.g_exc_unexpected_error;
1716: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1717: mydebug('Error in update_loc_suggested_capacity');
1718: -- Bug 5393727: do not raise an exception if revert API returns an error
1719: -- RAISE fnd_api.g_exc_error;

Line 1716: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1712: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1713: mydebug('Unexpected error in update_loc_suggested_capacity');
1714: -- Bug 5393727: do not raise an exception if revert API returns an error
1715: -- RAISE fnd_api.g_exc_unexpected_error;
1716: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1717: mydebug('Error in update_loc_suggested_capacity');
1718: -- Bug 5393727: do not raise an exception if revert API returns an error
1719: -- RAISE fnd_api.g_exc_error;
1720: END IF;

Line 1719: -- RAISE fnd_api.g_exc_error;

1715: -- RAISE fnd_api.g_exc_unexpected_error;
1716: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1717: mydebug('Error in update_loc_suggested_capacity');
1718: -- Bug 5393727: do not raise an exception if revert API returns an error
1719: -- RAISE fnd_api.g_exc_error;
1720: END IF;
1721:
1722: /***** Bug 2999296 Updating locator capacity ***********/
1723:

Line 1735: RAISE fnd_api.g_exc_unexpected_error;

1731: line_id = mmtt_row.move_order_line_id;
1732: EXCEPTION
1733: WHEN others THEN
1734: mydebug('Exception getting the move order line information');
1735: RAISE fnd_api.g_exc_unexpected_error;
1736: END;
1737:
1738: l_trohdr_rec.request_number := FND_API.G_MISS_CHAR ; --5984021
1739: l_trohdr_rec.header_id := FND_API.G_MISS_NUM;

Line 1738: l_trohdr_rec.request_number := FND_API.G_MISS_CHAR ; --5984021

1734: mydebug('Exception getting the move order line information');
1735: RAISE fnd_api.g_exc_unexpected_error;
1736: END;
1737:
1738: l_trohdr_rec.request_number := FND_API.G_MISS_CHAR ; --5984021
1739: l_trohdr_rec.header_id := FND_API.G_MISS_NUM;
1740: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1741: l_trohdr_rec.creation_date := sysdate;
1742: l_trohdr_rec.date_required := sysdate;

Line 1739: l_trohdr_rec.header_id := FND_API.G_MISS_NUM;

1735: RAISE fnd_api.g_exc_unexpected_error;
1736: END;
1737:
1738: l_trohdr_rec.request_number := FND_API.G_MISS_CHAR ; --5984021
1739: l_trohdr_rec.header_id := FND_API.G_MISS_NUM;
1740: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1741: l_trohdr_rec.creation_date := sysdate;
1742: l_trohdr_rec.date_required := sysdate;
1743: l_trohdr_rec.from_subinventory_code := mmtt_row.subinventory_code;

Line 1752: l_trohdr_rec.db_flag := FND_API.G_TRUE;

1748: l_trohdr_rec.organization_id := mmtt_row.organization_id;
1749: l_trohdr_rec.status_date := sysdate;
1750: l_trohdr_rec.to_subinventory_code := mmtt_row.transfer_subinventory;
1751: l_trohdr_rec. move_order_type := INV_GLOBALS.g_move_order_replenishment;
1752: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1753: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1754:
1755: l_line_num := 1;
1756: l_trolin_tbl(1).header_id := l_trohdr_rec.header_id;

Line 1768: l_trolin_tbl(1).line_id := FND_API.G_MISS_NUM;

1764: l_trolin_tbl(1).last_update_date := sysdate;
1765: l_trolin_tbl(1).last_updated_by := FND_GLOBAL.USER_ID;
1766: l_trolin_tbl(1).last_update_date := sysdate;
1767: l_trolin_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;
1768: l_trolin_tbl(1).line_id := FND_API.G_MISS_NUM;
1769: l_trolin_tbl(1).line_number := l_line_num;
1770: l_trolin_tbl(1).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1771: l_trolin_tbl(1).organization_id := mmtt_row.organization_id;
1772: l_trolin_tbl(1).quantity := mmtt_row.primary_quantity;

Line 1780: l_trolin_tbl(1).db_flag := FND_API.G_TRUE;

1776: l_trolin_tbl(1).status_date := sysdate;
1777: l_trolin_tbl(1).to_subinventory_code := mmtt_row.transfer_subinventory;
1778: l_trolin_tbl(1).to_locator_id := mmtt_row.transfer_to_location; --14801304
1779: l_trolin_tbl(1).uom_code := l_uom;
1780: l_trolin_tbl(1).db_flag := FND_API.G_TRUE;
1781: l_trolin_tbl(1).operation := INV_GLOBALS.G_OPR_CREATE;
1782:
1783: l_trolin_tbl(1).lpn_id := NULL;
1784: l_trolin_tbl(1).reference:=l_ref;

Line 1808: p_commit => FND_API.G_FALSE,

1804:
1805: INV_Move_Order_PUB.Process_Move_Order
1806: ( p_api_version_number => 1.0 ,
1807: p_init_msg_list => 'F',
1808: p_commit => FND_API.G_FALSE,
1809: x_return_status => l_return_status,
1810: x_msg_count => l_msg_count,
1811: x_msg_data => l_msg_data,
1812: p_trohdr_rec => l_trohdr_rec,

Line 1849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1845: END LOOP;
1846: END IF;
1847:
1848:
1849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1850: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR' );
1851: FND_MSG_PUB.ADD;
1852: RAISE FND_API.g_exc_unexpected_error;
1853:

Line 1852: RAISE FND_API.g_exc_unexpected_error;

1848:
1849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1850: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR' );
1851: FND_MSG_PUB.ADD;
1852: RAISE FND_API.g_exc_unexpected_error;
1853:
1854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1855: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');
1856: FND_MSG_PUB.ADD;

Line 1854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1850: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR' );
1851: FND_MSG_PUB.ADD;
1852: RAISE FND_API.g_exc_unexpected_error;
1853:
1854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1855: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');
1856: FND_MSG_PUB.ADD;
1857: RAISE FND_API.G_EXC_ERROR;
1858: END IF;

Line 1857: RAISE FND_API.G_EXC_ERROR;

1853:
1854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1855: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');
1856: FND_MSG_PUB.ADD;
1857: RAISE FND_API.G_EXC_ERROR;
1858: END IF;
1859:
1860:
1861: /* Get header and line ids */

Line 1982: RAISE fnd_api.g_exc_unexpected_error;

1978: l_already_used := 'N';
1979: WHEN OTHERS THEN
1980: mydebug('Error occurred '||Sqlerrm);
1981: l_already_used := NULL;
1982: RAISE fnd_api.g_exc_unexpected_error;
1983: END;
1984:
1985: IF l_already_used = 'Y' then
1986: mydebug('failed quantity check ');

Line 2095: RAISE fnd_api.g_exc_unexpected_error;

2091: l_already_used := 'N';
2092: WHEN OTHERS THEN
2093: mydebug('Error occurred '||Sqlerrm);
2094: l_already_used := NULL;
2095: RAISE fnd_api.g_exc_unexpected_error;
2096: END;
2097:
2098: IF l_already_used = 'Y' then
2099: mydebug('failed quantity check ');

Line 2203: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

2199: IF (l_debug = 1) THEN
2200: mydebug('After calling wms_rule_pvt.assigntt l_return_status :'||x_return_status||' new_txn_temp_id :'||new_txn_temp_id);
2201: END IF;
2202:
2203: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2204: IF (l_debug = 1) THEN
2205: mydebug(' error returned from wms_rule_pvt.assigntt ');
2206: mydebug(x_msg_data);
2207: END IF;

Line 2209: RAISE fnd_api.g_exc_error;

2205: mydebug(' error returned from wms_rule_pvt.assigntt ');
2206: mydebug(x_msg_data);
2207: END IF;
2208:
2209: RAISE fnd_api.g_exc_error;
2210: ELSE
2211: IF (l_debug = 1) THEN
2212: mydebug(' success returned from wms_rule_pvt.assigntt ');
2213: END IF;

Line 2220: x_return_status := fnd_api.g_ret_sts_error;

2216: END LOOP;
2217: EXCEPTION
2218: WHEN g_qty_not_avail THEN
2219: ROLLBACK TO generate_next_task;
2220: x_return_status := fnd_api.g_ret_sts_error;
2221: x_ret_code := 'QTY_NOT_AVAIL';
2222: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2223: -- IF (x_msg_count = 0) THEN
2224: -- dbms_output.put_line('Successful');

Line 2236: WHEN fnd_api.g_exc_error THEN

2232: -- dbms_output.put_line(replace(x_msg_data,chr(0),' '));
2233: -- END LOOP;
2234: -- END IF;
2235:
2236: WHEN fnd_api.g_exc_error THEN
2237: ROLLBACK TO generate_next_task;
2238: x_return_status := fnd_api.g_ret_sts_error;
2239: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2240: -- IF (x_msg_count = 0) THEN

Line 2238: x_return_status := fnd_api.g_ret_sts_error;

2234: -- END IF;
2235:
2236: WHEN fnd_api.g_exc_error THEN
2237: ROLLBACK TO generate_next_task;
2238: x_return_status := fnd_api.g_ret_sts_error;
2239: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2240: -- IF (x_msg_count = 0) THEN
2241: -- dbms_output.put_line('Successful');
2242: -- ELSIF (x_msg_count = 1) THEN

Line 2254: WHEN fnd_api.g_exc_unexpected_error THEN

2250: -- END LOOP;
2251: -- END IF;
2252:
2253:
2254: WHEN fnd_api.g_exc_unexpected_error THEN
2255: ROLLBACK TO generate_next_task;
2256: x_return_status := fnd_api.g_ret_sts_unexp_error;
2257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2258: WHEN OTHERS THEN

Line 2256: x_return_status := fnd_api.g_ret_sts_unexp_error;

2252:
2253:
2254: WHEN fnd_api.g_exc_unexpected_error THEN
2255: ROLLBACK TO generate_next_task;
2256: x_return_status := fnd_api.g_ret_sts_unexp_error;
2257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2258: WHEN OTHERS THEN
2259: ROLLBACK TO generate_next_task;
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2260: x_return_status := fnd_api.g_ret_sts_unexp_error;

2256: x_return_status := fnd_api.g_ret_sts_unexp_error;
2257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2258: WHEN OTHERS THEN
2259: ROLLBACK TO generate_next_task;
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;
2261:
2262: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2263: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2264: END IF;

Line 2327: x_return_status := fnd_api.g_ret_sts_success;

2323: IF (l_debug = 1) THEN
2324: mydebug('Cancelling the Task: TxnTempID = ' || p_temp_id || ' : EmployeeID = ' || p_emp_id);
2325: END IF;
2326:
2327: x_return_status := fnd_api.g_ret_sts_success;
2328:
2329: -- Call device request for task cancel
2330: OPEN c_wdt_dispatched;
2331: LOOP

Line 2389: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2385: , x_msg_data => x_msg_data
2386: , x_msg_count => x_msg_count
2387: , p_transaction_temp_id => l_txn_temp_id
2388: );
2389: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2390: IF l_debug = 1 THEN
2391: mydebug('Not able to delete the Txn = ' || l_txn_temp_id);
2392: END IF;
2393: RAISE fnd_api.g_exc_unexpected_error;

Line 2393: RAISE fnd_api.g_exc_unexpected_error;

2389: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2390: IF l_debug = 1 THEN
2391: mydebug('Not able to delete the Txn = ' || l_txn_temp_id);
2392: END IF;
2393: RAISE fnd_api.g_exc_unexpected_error;
2394: END IF;
2395:
2396: l_deleted_quantity := l_deleted_quantity + l_txn_quantity;
2397: END LOOP;

Line 2414: x_return_status := fnd_api.g_ret_sts_unexp_error;

2410:
2411: COMMIT;
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: x_return_status := fnd_api.g_ret_sts_unexp_error;
2415: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2416: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');
2417: END IF;
2418: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2440: RAISE fnd_api.g_exc_unexpected_error;

2436: mydebug(' In CAN_UNLOAD for transaction_temp_id ' || p_temp_id);
2437: END IF;
2438:
2439: IF (p_temp_id IS NULL) THEN
2440: RAISE fnd_api.g_exc_unexpected_error;
2441: END IF;
2442:
2443: BEGIN
2444: IF (l_debug = 1) THEN

Line 2471: RAISE fnd_api.g_exc_unexpected_error;

2467: IF (l_debug = 1) THEN
2468: mydebug('ERROR: transfer_lpn passed is null');
2469: END IF;
2470:
2471: RAISE fnd_api.g_exc_unexpected_error;
2472: END IF;
2473:
2474: IF (l_debug = 1) THEN
2475: mydebug(' checking if the lpn has multiple allocations ');

Line 2503: WHEN fnd_api.g_exc_error THEN

2499: fnd_message.set_name('WMS', 'WMS_LPN_MULTIPLE_ALLOC_ERR');
2500: fnd_msg_pub.ADD;
2501: RETURN 'M';
2502: EXCEPTION
2503: WHEN fnd_api.g_exc_error THEN
2504: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2505: fnd_msg_pub.ADD;
2506: RETURN fnd_api.g_ret_sts_error;
2507: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2506: RETURN fnd_api.g_ret_sts_error;

2502: EXCEPTION
2503: WHEN fnd_api.g_exc_error THEN
2504: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2505: fnd_msg_pub.ADD;
2506: RETURN fnd_api.g_ret_sts_error;
2507: WHEN fnd_api.g_exc_unexpected_error THEN
2508: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2509: fnd_msg_pub.ADD;
2510: RETURN fnd_api.g_ret_sts_unexp_error;

Line 2507: WHEN fnd_api.g_exc_unexpected_error THEN

2503: WHEN fnd_api.g_exc_error THEN
2504: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2505: fnd_msg_pub.ADD;
2506: RETURN fnd_api.g_ret_sts_error;
2507: WHEN fnd_api.g_exc_unexpected_error THEN
2508: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2509: fnd_msg_pub.ADD;
2510: RETURN fnd_api.g_ret_sts_unexp_error;
2511: WHEN OTHERS THEN

Line 2510: RETURN fnd_api.g_ret_sts_unexp_error;

2506: RETURN fnd_api.g_ret_sts_error;
2507: WHEN fnd_api.g_exc_unexpected_error THEN
2508: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2509: fnd_msg_pub.ADD;
2510: RETURN fnd_api.g_ret_sts_unexp_error;
2511: WHEN OTHERS THEN
2512: IF (l_debug = 1) THEN
2513: mydebug('Exception occurred in can_unload api' || SQLERRM);
2514: END IF;

Line 2518: RETURN fnd_api.g_ret_sts_unexp_error;

2514: END IF;
2515:
2516: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2517: fnd_msg_pub.ADD;
2518: RETURN fnd_api.g_ret_sts_unexp_error;
2519: END can_unload;
2520:
2521: /* over loaded the procedure can_unload to resolve the JDBC error */
2522: PROCEDURE can_unload(x_can_unload out NOCOPY VARCHAR2, p_temp_id IN NUMBER)