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 1456: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

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

Line 1481: x_ret_code := fnd_api.g_ret_sts_success;

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

Line 1581: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1684: RAISE fnd_api.g_exc_unexpected_error;

1680: AND organization_id = mmtt_table(cnt).organization_id;
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: mydebug('Exception getting the item information');
1684: RAISE fnd_api.g_exc_unexpected_error;
1685: END;
1686:
1687: /***** Bug 2999296 Updating locator capacity ***********/
1688:

Line 1703: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1699: , p_transaction_uom_code => NULL
1700: , p_quantity => mmtt_row.primary_quantity
1701: );
1702:
1703: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1704: mydebug('Unexpected error in update_loc_suggested_capacity');
1705: -- Bug 5393727: do not raise an exception if revert API returns an error
1706: -- RAISE fnd_api.g_exc_unexpected_error;
1707: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 1706: -- RAISE fnd_api.g_exc_unexpected_error;

1702:
1703: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1704: mydebug('Unexpected error in update_loc_suggested_capacity');
1705: -- Bug 5393727: do not raise an exception if revert API returns an error
1706: -- RAISE fnd_api.g_exc_unexpected_error;
1707: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1708: mydebug('Error in update_loc_suggested_capacity');
1709: -- Bug 5393727: do not raise an exception if revert API returns an error
1710: -- RAISE fnd_api.g_exc_error;

Line 1707: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1703: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1704: mydebug('Unexpected error in update_loc_suggested_capacity');
1705: -- Bug 5393727: do not raise an exception if revert API returns an error
1706: -- RAISE fnd_api.g_exc_unexpected_error;
1707: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1708: mydebug('Error in update_loc_suggested_capacity');
1709: -- Bug 5393727: do not raise an exception if revert API returns an error
1710: -- RAISE fnd_api.g_exc_error;
1711: END IF;

Line 1710: -- RAISE fnd_api.g_exc_error;

1706: -- RAISE fnd_api.g_exc_unexpected_error;
1707: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1708: mydebug('Error in update_loc_suggested_capacity');
1709: -- Bug 5393727: do not raise an exception if revert API returns an error
1710: -- RAISE fnd_api.g_exc_error;
1711: END IF;
1712:
1713: /***** Bug 2999296 Updating locator capacity ***********/
1714:

Line 1726: RAISE fnd_api.g_exc_unexpected_error;

1722: line_id = mmtt_row.move_order_line_id;
1723: EXCEPTION
1724: WHEN others THEN
1725: mydebug('Exception getting the move order line information');
1726: RAISE fnd_api.g_exc_unexpected_error;
1727: END;
1728:
1729: l_trohdr_rec.request_number := FND_API.G_MISS_CHAR ; --5984021
1730: l_trohdr_rec.header_id := FND_API.G_MISS_NUM;

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

1725: mydebug('Exception getting the move order line information');
1726: RAISE fnd_api.g_exc_unexpected_error;
1727: END;
1728:
1729: l_trohdr_rec.request_number := FND_API.G_MISS_CHAR ; --5984021
1730: l_trohdr_rec.header_id := FND_API.G_MISS_NUM;
1731: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1732: l_trohdr_rec.creation_date := sysdate;
1733: l_trohdr_rec.date_required := sysdate;

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

1726: RAISE fnd_api.g_exc_unexpected_error;
1727: END;
1728:
1729: l_trohdr_rec.request_number := FND_API.G_MISS_CHAR ; --5984021
1730: l_trohdr_rec.header_id := FND_API.G_MISS_NUM;
1731: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1732: l_trohdr_rec.creation_date := sysdate;
1733: l_trohdr_rec.date_required := sysdate;
1734: l_trohdr_rec.from_subinventory_code := mmtt_row.subinventory_code;

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

1739: l_trohdr_rec.organization_id := mmtt_row.organization_id;
1740: l_trohdr_rec.status_date := sysdate;
1741: l_trohdr_rec.to_subinventory_code := mmtt_row.transfer_subinventory;
1742: l_trohdr_rec. move_order_type := INV_GLOBALS.g_move_order_replenishment;
1743: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1744: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1745:
1746: l_line_num := 1;
1747: l_trolin_tbl(1).header_id := l_trohdr_rec.header_id;

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

1755: l_trolin_tbl(1).last_update_date := sysdate;
1756: l_trolin_tbl(1).last_updated_by := FND_GLOBAL.USER_ID;
1757: l_trolin_tbl(1).last_update_date := sysdate;
1758: l_trolin_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;
1759: l_trolin_tbl(1).line_id := FND_API.G_MISS_NUM;
1760: l_trolin_tbl(1).line_number := l_line_num;
1761: l_trolin_tbl(1).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1762: l_trolin_tbl(1).organization_id := mmtt_row.organization_id;
1763: l_trolin_tbl(1).quantity := mmtt_row.primary_quantity;

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

1766:
1767: l_trolin_tbl(1).status_date := sysdate;
1768: l_trolin_tbl(1).to_subinventory_code := mmtt_row.transfer_subinventory;
1769: l_trolin_tbl(1).uom_code := l_uom;
1770: l_trolin_tbl(1).db_flag := FND_API.G_TRUE;
1771: l_trolin_tbl(1).operation := INV_GLOBALS.G_OPR_CREATE;
1772:
1773: l_trolin_tbl(1).lpn_id := NULL;
1774: l_trolin_tbl(1).reference:=l_ref;

Line 1793: p_commit => FND_API.G_FALSE,

1789:
1790: INV_Move_Order_PUB.Process_Move_Order
1791: ( p_api_version_number => 1.0 ,
1792: p_init_msg_list => 'F',
1793: p_commit => FND_API.G_FALSE,
1794: x_return_status => l_return_status,
1795: x_msg_count => l_msg_count,
1796: x_msg_data => l_msg_data,
1797: p_trohdr_rec => l_trohdr_rec,

Line 1834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1830: END LOOP;
1831: END IF;
1832:
1833:
1834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1835: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR' );
1836: FND_MSG_PUB.ADD;
1837: RAISE FND_API.g_exc_unexpected_error;
1838:

Line 1837: RAISE FND_API.g_exc_unexpected_error;

1833:
1834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1835: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR' );
1836: FND_MSG_PUB.ADD;
1837: RAISE FND_API.g_exc_unexpected_error;
1838:
1839: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1840: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');
1841: FND_MSG_PUB.ADD;

Line 1839: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1835: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR' );
1836: FND_MSG_PUB.ADD;
1837: RAISE FND_API.g_exc_unexpected_error;
1838:
1839: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1840: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;

Line 1842: RAISE FND_API.G_EXC_ERROR;

1838:
1839: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1840: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845:
1846: /* Get header and line ids */

Line 1967: RAISE fnd_api.g_exc_unexpected_error;

1963: l_already_used := 'N';
1964: WHEN OTHERS THEN
1965: mydebug('Error occurred '||Sqlerrm);
1966: l_already_used := NULL;
1967: RAISE fnd_api.g_exc_unexpected_error;
1968: END;
1969:
1970: IF l_already_used = 'Y' then
1971: mydebug('failed quantity check ');

Line 2080: RAISE fnd_api.g_exc_unexpected_error;

2076: l_already_used := 'N';
2077: WHEN OTHERS THEN
2078: mydebug('Error occurred '||Sqlerrm);
2079: l_already_used := NULL;
2080: RAISE fnd_api.g_exc_unexpected_error;
2081: END;
2082:
2083: IF l_already_used = 'Y' then
2084: mydebug('failed quantity check ');

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

2184: IF (l_debug = 1) THEN
2185: mydebug('After calling wms_rule_pvt.assigntt l_return_status :'||x_return_status||' new_txn_temp_id :'||new_txn_temp_id);
2186: END IF;
2187:
2188: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2189: IF (l_debug = 1) THEN
2190: mydebug(' error returned from wms_rule_pvt.assigntt ');
2191: mydebug(x_msg_data);
2192: END IF;

Line 2194: RAISE fnd_api.g_exc_error;

2190: mydebug(' error returned from wms_rule_pvt.assigntt ');
2191: mydebug(x_msg_data);
2192: END IF;
2193:
2194: RAISE fnd_api.g_exc_error;
2195: ELSE
2196: IF (l_debug = 1) THEN
2197: mydebug(' success returned from wms_rule_pvt.assigntt ');
2198: END IF;

Line 2205: x_return_status := fnd_api.g_ret_sts_error;

2201: END LOOP;
2202: EXCEPTION
2203: WHEN g_qty_not_avail THEN
2204: ROLLBACK TO generate_next_task;
2205: x_return_status := fnd_api.g_ret_sts_error;
2206: x_ret_code := 'QTY_NOT_AVAIL';
2207: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2208: -- IF (x_msg_count = 0) THEN
2209: -- dbms_output.put_line('Successful');

Line 2221: WHEN fnd_api.g_exc_error THEN

2217: -- dbms_output.put_line(replace(x_msg_data,chr(0),' '));
2218: -- END LOOP;
2219: -- END IF;
2220:
2221: WHEN fnd_api.g_exc_error THEN
2222: ROLLBACK TO generate_next_task;
2223: x_return_status := fnd_api.g_ret_sts_error;
2224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2225: -- IF (x_msg_count = 0) THEN

Line 2223: x_return_status := fnd_api.g_ret_sts_error;

2219: -- END IF;
2220:
2221: WHEN fnd_api.g_exc_error THEN
2222: ROLLBACK TO generate_next_task;
2223: x_return_status := fnd_api.g_ret_sts_error;
2224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2225: -- IF (x_msg_count = 0) THEN
2226: -- dbms_output.put_line('Successful');
2227: -- ELSIF (x_msg_count = 1) THEN

Line 2239: WHEN fnd_api.g_exc_unexpected_error THEN

2235: -- END LOOP;
2236: -- END IF;
2237:
2238:
2239: WHEN fnd_api.g_exc_unexpected_error THEN
2240: ROLLBACK TO generate_next_task;
2241: x_return_status := fnd_api.g_ret_sts_unexp_error;
2242: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2243: WHEN OTHERS THEN

Line 2241: x_return_status := fnd_api.g_ret_sts_unexp_error;

2237:
2238:
2239: WHEN fnd_api.g_exc_unexpected_error THEN
2240: ROLLBACK TO generate_next_task;
2241: x_return_status := fnd_api.g_ret_sts_unexp_error;
2242: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2243: WHEN OTHERS THEN
2244: ROLLBACK TO generate_next_task;
2245: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2245: x_return_status := fnd_api.g_ret_sts_unexp_error;

2241: x_return_status := fnd_api.g_ret_sts_unexp_error;
2242: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2243: WHEN OTHERS THEN
2244: ROLLBACK TO generate_next_task;
2245: x_return_status := fnd_api.g_ret_sts_unexp_error;
2246:
2247: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2248: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2249: END IF;

Line 2312: x_return_status := fnd_api.g_ret_sts_success;

2308: IF (l_debug = 1) THEN
2309: mydebug('Cancelling the Task: TxnTempID = ' || p_temp_id || ' : EmployeeID = ' || p_emp_id);
2310: END IF;
2311:
2312: x_return_status := fnd_api.g_ret_sts_success;
2313:
2314: -- Call device request for task cancel
2315: OPEN c_wdt_dispatched;
2316: LOOP

Line 2374: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2370: , x_msg_data => x_msg_data
2371: , x_msg_count => x_msg_count
2372: , p_transaction_temp_id => l_txn_temp_id
2373: );
2374: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2375: IF l_debug = 1 THEN
2376: mydebug('Not able to delete the Txn = ' || l_txn_temp_id);
2377: END IF;
2378: RAISE fnd_api.g_exc_unexpected_error;

Line 2378: RAISE fnd_api.g_exc_unexpected_error;

2374: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2375: IF l_debug = 1 THEN
2376: mydebug('Not able to delete the Txn = ' || l_txn_temp_id);
2377: END IF;
2378: RAISE fnd_api.g_exc_unexpected_error;
2379: END IF;
2380:
2381: l_deleted_quantity := l_deleted_quantity + l_txn_quantity;
2382: END LOOP;

Line 2399: x_return_status := fnd_api.g_ret_sts_unexp_error;

2395:
2396: COMMIT;
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2401: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');
2402: END IF;
2403: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2425: RAISE fnd_api.g_exc_unexpected_error;

2421: mydebug(' In CAN_UNLOAD for transaction_temp_id ' || p_temp_id);
2422: END IF;
2423:
2424: IF (p_temp_id IS NULL) THEN
2425: RAISE fnd_api.g_exc_unexpected_error;
2426: END IF;
2427:
2428: BEGIN
2429: IF (l_debug = 1) THEN

Line 2456: RAISE fnd_api.g_exc_unexpected_error;

2452: IF (l_debug = 1) THEN
2453: mydebug('ERROR: transfer_lpn passed is null');
2454: END IF;
2455:
2456: RAISE fnd_api.g_exc_unexpected_error;
2457: END IF;
2458:
2459: IF (l_debug = 1) THEN
2460: mydebug(' checking if the lpn has multiple allocations ');

Line 2488: WHEN fnd_api.g_exc_error THEN

2484: fnd_message.set_name('WMS', 'WMS_LPN_MULTIPLE_ALLOC_ERR');
2485: fnd_msg_pub.ADD;
2486: RETURN 'M';
2487: EXCEPTION
2488: WHEN fnd_api.g_exc_error THEN
2489: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2490: fnd_msg_pub.ADD;
2491: RETURN fnd_api.g_ret_sts_error;
2492: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2491: RETURN fnd_api.g_ret_sts_error;

2487: EXCEPTION
2488: WHEN fnd_api.g_exc_error THEN
2489: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2490: fnd_msg_pub.ADD;
2491: RETURN fnd_api.g_ret_sts_error;
2492: WHEN fnd_api.g_exc_unexpected_error THEN
2493: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2494: fnd_msg_pub.ADD;
2495: RETURN fnd_api.g_ret_sts_unexp_error;

Line 2492: WHEN fnd_api.g_exc_unexpected_error THEN

2488: WHEN fnd_api.g_exc_error THEN
2489: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2490: fnd_msg_pub.ADD;
2491: RETURN fnd_api.g_ret_sts_error;
2492: WHEN fnd_api.g_exc_unexpected_error THEN
2493: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2494: fnd_msg_pub.ADD;
2495: RETURN fnd_api.g_ret_sts_unexp_error;
2496: WHEN OTHERS THEN

Line 2495: RETURN fnd_api.g_ret_sts_unexp_error;

2491: RETURN fnd_api.g_ret_sts_error;
2492: WHEN fnd_api.g_exc_unexpected_error THEN
2493: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2494: fnd_msg_pub.ADD;
2495: RETURN fnd_api.g_ret_sts_unexp_error;
2496: WHEN OTHERS THEN
2497: IF (l_debug = 1) THEN
2498: mydebug('Exception occurred in can_unload api' || SQLERRM);
2499: END IF;

Line 2503: RETURN fnd_api.g_ret_sts_unexp_error;

2499: END IF;
2500:
2501: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2502: fnd_msg_pub.ADD;
2503: RETURN fnd_api.g_ret_sts_unexp_error;
2504: END can_unload;
2505:
2506: /* over loaded the procedure can_unload to resolve the JDBC error */
2507: PROCEDURE can_unload(x_can_unload out NOCOPY VARCHAR2, p_temp_id IN NUMBER)