APPS.WMS_CROSS_DOCK_PVT dependencies on FND_API

Line 71: x_return_status := fnd_api.g_ret_sts_success;

67: l_user_id NUMBER;
68: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
69: BEGIN
70: -- Initialize API return status to success
71: x_return_status := fnd_api.g_ret_sts_success;
72:
73: l_user_id := fnd_global.user_id;
74:
75: IF (l_debug = 1) THEN

Line 250: x_return_status := fnd_api.g_ret_sts_unexp_error;

246: END IF;
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: IF (l_debug = 1) THEN
252: mydebug('insert_xdock_msnt:EXCEPTION !!!. ' );
253: END IF;
254: END insert_xdock_msnt;

Line 483: x_return_status := fnd_api.g_ret_sts_success;

479: l_progress := '20';
480: l_mol_criteria_tb.DELETE; --9695544
481:
482: -- Initialize API return status to success
483: x_return_status := fnd_api.g_ret_sts_success;
484: x_ret := 1;
485: l_progress := '30';
486:
487: l_lpn_id := p_lpn;

Line 686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

682:
683: l_mol_criteria_tb(l_line_id) := l_xdock_criterion_id;
684: END IF;
685:
686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
687: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR' );
688: FND_MSG_PUB.ADD;
689: RAISE FND_API.g_exc_unexpected_error;
690:

Line 689: RAISE FND_API.g_exc_unexpected_error;

685:
686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
687: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR' );
688: FND_MSG_PUB.ADD;
689: RAISE FND_API.g_exc_unexpected_error;
690:
691: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR');
693: FND_MSG_PUB.ADD;

Line 691: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

687: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR' );
688: FND_MSG_PUB.ADD;
689: RAISE FND_API.g_exc_unexpected_error;
690:
691: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.g_exc_error;
695: END IF;

Line 694: RAISE FND_API.g_exc_error;

690:
691: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.g_exc_error;
695: END IF;
696:
697: l_progress := '110';
698:

Line 736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

732: mydebug('l_msg_count = '||l_msg_count);
733: mydebug('l_msg_data = '||l_msg_data);
734: END IF;
735:
736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR' );
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.g_exc_unexpected_error;
740:

Line 739: RAISE FND_API.g_exc_unexpected_error;

735:
736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR' );
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.g_exc_unexpected_error;
740:
741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
742: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR');
743: FND_MSG_PUB.ADD;

Line 741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

737: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR' );
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.g_exc_unexpected_error;
740:
741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
742: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.g_exc_error;
745: END IF;

Line 744: RAISE FND_API.g_exc_error;

740:
741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
742: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.g_exc_error;
745: END IF;
746:
747: l_progress := '120';
748:

Line 888: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

884: IF (l_debug = 1) THEN
885: mydebug('l_return_status:-'||l_return_status);
886: END IF;
887:
888: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
889: IF (l_debug = 1) THEN
890: mydebug('Current Backorder/Scheduled SO line is on Hold.');
891: GOTO loop_end;
892: END IF;

Line 976: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

972: ,x_dock_mean_time => l_dummy2
973: ,x_dock_end_time => l_dummy3
974: ,x_expected_time => l_expected_delivery_time);
975:
976: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
977: IF (l_debug = 1) THEN
978: mydebug('Unexpected error, skip this move order line.');
979: END IF;
980:

Line 982: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

978: mydebug('Unexpected error, skip this move order line.');
979: END IF;
980:
981: GOTO loop_end;
982: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
983: IF (l_debug = 1) THEN
984: mydebug('Expected error, skip this move order line.');
985: END IF;
986:

Line 1111: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1107: mydebug('l_matched_entities.count = '||l_matched_entities.count);
1108: END IF;
1109:
1110:
1111: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1112: IF (l_debug = 1) THEN
1113: mydebug('Unexpected error, skip this move order line.');
1114: END IF;
1115:

Line 1117: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1113: mydebug('Unexpected error, skip this move order line.');
1114: END IF;
1115:
1116: GOTO loop_end;
1117: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1118: IF (l_debug = 1) THEN
1119: mydebug('Expected error, skip this move order line.');
1120: END IF;
1121:

Line 1158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1154: mydebug('x_dock_end_time = '||l_matched_dock_end_time);
1155: mydebug('x_expected_time = '||l_matched_expected_del_time);
1156: END IF;
1157:
1158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: IF (l_debug = 1) THEN
1160: mydebug('Unexpected error, skip this Delivery.');
1161: END IF;
1162:

Line 1164: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1160: mydebug('Unexpected error, skip this Delivery.');
1161: END IF;
1162:
1163: GOTO delivery_loop_end;
1164: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: IF (l_debug = 1) THEN
1166: mydebug('Expected error, skip this Delivery.');
1167: END IF;
1168:

Line 1249: p_init_msg_list => fnd_api.g_false,

1245: wsh_delivery_details_grp.delivery_detail_action
1246: (
1247: -- Standard Parameters
1248: p_api_version_number => 1.0,
1249: p_init_msg_list => fnd_api.g_false,
1250: p_commit => fnd_api.g_false,
1251: x_return_status => l_return_status,
1252: x_msg_count => l_msg_count,
1253: x_msg_data => l_msg_data,

Line 1250: p_commit => fnd_api.g_false,

1246: (
1247: -- Standard Parameters
1248: p_api_version_number => 1.0,
1249: p_init_msg_list => fnd_api.g_false,
1250: p_commit => fnd_api.g_false,
1251: x_return_status => l_return_status,
1252: x_msg_count => l_msg_count,
1253: x_msg_data => l_msg_data,
1254: -- Procedure specific Parameters

Line 1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1266: END IF;
1267:
1268:
1269:
1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: IF (l_debug = 1) THEN
1272: mydebug('Unexpected error, skip this move order line.');
1273: END IF;
1274:

Line 1276: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1272: mydebug('Unexpected error, skip this move order line.');
1273: END IF;
1274:
1275: GOTO loop_end;
1276: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1277: IF (l_debug = 1) THEN
1278: mydebug('Expected error, skip this move order line.');
1279: END IF;
1280:

Line 1323: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1319: mydebug('x_zone_id = ' || l_to_zone_id);
1320: mydebug('x_subinventory_code = ' || l_to_sub_code);
1321: END IF;
1322:
1323: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1324: IF (l_debug = 1) THEN
1325: mydebug('Unexpected error, skip this move order line.');
1326: END IF;
1327:

Line 1329: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1325: mydebug('Unexpected error, skip this move order line.');
1326: END IF;
1327:
1328: GOTO loop_end;
1329: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1330: IF (l_debug = 1) THEN
1331: mydebug('Expected error, skip this move order line.');
1332: END IF;
1333:

Line 1377: WHEN FND_API.G_EXC_ERROR THEN

1373: END IF;
1374:
1375:
1376: EXCEPTION
1377: WHEN FND_API.G_EXC_ERROR THEN
1378:
1379: IF (c_mol_opportunistic%ISOPEN) THEN
1380: CLOSE c_mol_opportunistic;
1381: END IF;

Line 1388: x_return_status := fnd_api.g_ret_sts_error;

1384: CLOSE c_mol_opp_and_planned;
1385: END IF;
1386:
1387: ROLLBACK TO check_crossdock_sp;
1388: x_return_status := fnd_api.g_ret_sts_error;
1389: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1390: p_data => x_msg_data);
1391: IF (l_debug = 1) THEN
1392: mydebug('Exiting check_crossdock - Execution error: ' ||

Line 1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1400:
1401: END IF;
1402:
1403: -- TODO: check cursor close
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405:
1406: IF (c_mol_opportunistic%ISOPEN) THEN
1407: CLOSE c_mol_opportunistic;
1408: END IF;

Line 1415: x_return_status := fnd_api.g_ret_sts_unexp_error;

1411: CLOSE c_mol_opp_and_planned;
1412: END IF;
1413:
1414: ROLLBACK TO check_crossdock_sp;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1417: p_data => x_msg_data);
1418: IF (l_debug = 1) THEN
1419: mydebug('Exiting Opportunistic_Cross_Dock - Unexpected error: ' ||

Line 1440: x_return_status := fnd_api.g_ret_sts_unexp_error;

1436: CLOSE c_mol_opp_and_planned;
1437: END IF;
1438:
1439: ROLLBACK TO check_crossdock_sp;
1440: x_return_status := fnd_api.g_ret_sts_unexp_error;
1441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1442: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1443: END IF;
1444: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1574: l_return_status:= FND_API.G_RET_STS_SUCCESS;

1570:
1571: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1572: BEGIN
1573:
1574: l_return_status:= FND_API.G_RET_STS_SUCCESS;
1575:
1576: -- patchset J change to set the local variable with the patch level
1577:
1578: IF (l_debug = 1) THEN

Line 1588: l_return_status:=fnd_api.g_ret_sts_success;

1584: -- l_del_id:=p_del_id;
1585: -- l_mo_line_id:=p_mo_line_id;
1586: --l_item_id:=p_item_id;
1587:
1588: l_return_status:=fnd_api.g_ret_sts_success;
1589: IF (l_debug = 1) THEN
1590: mydebug('Check if crossdock is necessary..');
1591: END IF;
1592:

Line 1733: RAISE fnd_api.g_exc_unexpected_error;

1729: END IF;
1730: IF l_mso_header_id IS NULL THEN
1731: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
1732: FND_MSG_PUB.Add;
1733: RAISE fnd_api.g_exc_unexpected_error;
1734: END IF;
1735: IF (l_debug = 1) THEN
1736: mydebug('Get Dem src');
1737: END IF;

Line 1791: p_init_msg_lst => fnd_api.g_false,

1787:
1788: -- Call query reservation
1789: inv_reservation_pub.query_reservation
1790: (p_api_version_number => 1.0,
1791: p_init_msg_lst => fnd_api.g_false,
1792: x_return_status => l_return_status,
1793: x_msg_count => l_msg_count,
1794: x_msg_data => l_msg_data,
1795: p_query_input => l_query_rsv_rec,

Line 1796: p_lock_records => fnd_api.g_true,

1792: x_return_status => l_return_status,
1793: x_msg_count => l_msg_count,
1794: x_msg_data => l_msg_data,
1795: p_query_input => l_query_rsv_rec,
1796: p_lock_records => fnd_api.g_true,
1797: p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc,
1798: x_mtl_reservation_tbl => l_reservation_tbl,
1799: x_mtl_reservation_tbl_count => l_rsv_tbl_count,
1800: x_error_code => l_error_code);

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

1798: x_mtl_reservation_tbl => l_reservation_tbl,
1799: x_mtl_reservation_tbl_count => l_rsv_tbl_count,
1800: x_error_code => l_error_code);
1801:
1802: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1803: x_msg_count := l_msg_count;
1804: x_msg_data := l_msg_data;
1805: x_return_status := l_return_status;
1806: IF (l_debug = 1) THEN

Line 1811: RAISE fnd_api.g_exc_unexpected_error;

1807: mydebug('Error in Query Reservation');
1808: END IF;
1809: FND_MESSAGE.SET_NAME('INV','INV_QRY_RSV_FAILED');
1810: FND_MSG_PUB.Add;
1811: RAISE fnd_api.g_exc_unexpected_error;
1812: END IF;
1813:
1814:
1815: IF (l_rsv_tbl_count > 0) THEN

Line 1858: p_init_msg_lst => fnd_api.g_false,

1854: l_update_rsv_rec.lpn_id := l_transfer_lpn_id;
1855:
1856: inv_reservation_pub.transfer_reservation
1857: (p_api_version_number => 1.0,
1858: p_init_msg_lst => fnd_api.g_false,
1859: x_return_status => l_return_status,
1860: x_msg_count => l_msg_count,
1861: x_msg_data => l_msg_data,
1862: p_is_transfer_supply => fnd_api.g_true,

Line 1862: p_is_transfer_supply => fnd_api.g_true,

1858: p_init_msg_lst => fnd_api.g_false,
1859: x_return_status => l_return_status,
1860: x_msg_count => l_msg_count,
1861: x_msg_data => l_msg_data,
1862: p_is_transfer_supply => fnd_api.g_true,
1863: p_original_rsv_rec => l_reservation_tbl(i),
1864: p_to_rsv_rec => l_update_rsv_rec,
1865: p_original_serial_number => l_dummy_sn,
1866: p_to_serial_number => l_dummy_sn,

Line 1867: p_validation_flag => fnd_api.g_true,

1863: p_original_rsv_rec => l_reservation_tbl(i),
1864: p_to_rsv_rec => l_update_rsv_rec,
1865: p_original_serial_number => l_dummy_sn,
1866: p_to_serial_number => l_dummy_sn,
1867: p_validation_flag => fnd_api.g_true,
1868: x_to_reservation_id => l_org_wide_res_id);
1869:
1870: -- Return an error if the transfer reservation call failed
1871: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

Line 1871: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1867: p_validation_flag => fnd_api.g_true,
1868: x_to_reservation_id => l_org_wide_res_id);
1869:
1870: -- Return an error if the transfer reservation call failed
1871: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1872: IF (l_debug = 1) THEN
1873: mydebug('error in transfer reservation');
1874: END IF;
1875: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');

Line 1877: RAISE fnd_api.g_exc_unexpected_error;

1873: mydebug('error in transfer reservation');
1874: END IF;
1875: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
1876: FND_MSG_PUB.Add;
1877: RAISE fnd_api.g_exc_unexpected_error;
1878: END IF;
1879:
1880: IF (l_primary_temp_qty <= 0) THEN
1881: exit;

Line 1958: , p_init_msg_lst => fnd_api.g_false

1954: inv_quantity_tree_pvt.clear_quantity_cache ;
1955: INV_Reservation_PUB.Create_Reservation
1956: (
1957: p_api_version_number => 1.0
1958: , p_init_msg_lst => fnd_api.g_false
1959: , x_return_status => l_api_return_status
1960: , x_msg_count => l_msg_cnt
1961: , x_msg_data => l_msg_data
1962: , p_rsv_rec => l_update_rsv_rec

Line 1965: , p_partial_reservation_flag => fnd_api.g_true

1961: , x_msg_data => l_msg_data
1962: , p_rsv_rec => l_update_rsv_rec
1963: , p_serial_number => l_dummy_sn
1964: , x_serial_number => l_dummy_sn
1965: , p_partial_reservation_flag => fnd_api.g_true
1966: , p_force_reservation_flag => fnd_api.g_false
1967: , p_validation_flag => fnd_api.g_true
1968: , x_quantity_reserved => l_qty_succ_reserved
1969: , x_reservation_id => l_org_wide_res_id

Line 1966: , p_force_reservation_flag => fnd_api.g_false

1962: , p_rsv_rec => l_update_rsv_rec
1963: , p_serial_number => l_dummy_sn
1964: , x_serial_number => l_dummy_sn
1965: , p_partial_reservation_flag => fnd_api.g_true
1966: , p_force_reservation_flag => fnd_api.g_false
1967: , p_validation_flag => fnd_api.g_true
1968: , x_quantity_reserved => l_qty_succ_reserved
1969: , x_reservation_id => l_org_wide_res_id
1970: );

Line 1967: , p_validation_flag => fnd_api.g_true

1963: , p_serial_number => l_dummy_sn
1964: , x_serial_number => l_dummy_sn
1965: , p_partial_reservation_flag => fnd_api.g_true
1966: , p_force_reservation_flag => fnd_api.g_false
1967: , p_validation_flag => fnd_api.g_true
1968: , x_quantity_reserved => l_qty_succ_reserved
1969: , x_reservation_id => l_org_wide_res_id
1970: );
1971:

Line 2002: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1998: END IF;
1999:
2000:
2001: -- Return an error if the create reservation call failed
2002: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2003: IF (l_debug = 1) THEN
2004: mydebug('error in create reservation');
2005: END IF;
2006: -- ROLLBACK TO Process_Line_PVT;

Line 2009: RAISE fnd_api.g_exc_unexpected_error;

2005: END IF;
2006: -- ROLLBACK TO Process_Line_PVT;
2007: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CR_RSV_ERROR');
2008: FND_MSG_PUB.Add;
2009: RAISE fnd_api.g_exc_unexpected_error;
2010: END IF;
2011: END IF;
2012:
2013:

Line 2034: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2030:
2031: END IF; -- l_lpn_context
2032:
2033:
2034: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2035: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR' );
2036: FND_MSG_PUB.ADD;
2037: RAISE FND_API.g_exc_unexpected_error;
2038:

Line 2037: RAISE FND_API.g_exc_unexpected_error;

2033:
2034: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2035: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR' );
2036: FND_MSG_PUB.ADD;
2037: RAISE FND_API.g_exc_unexpected_error;
2038:
2039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR');
2041: FND_MSG_PUB.ADD;

Line 2039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2035: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR' );
2036: FND_MSG_PUB.ADD;
2037: RAISE FND_API.g_exc_unexpected_error;
2038:
2039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;

Line 2042: RAISE FND_API.G_EXC_ERROR;

2038:
2039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044:
2045: IF (l_debug = 1) THEN
2046: mydebug('After calling API to update rsv as staged');

Line 2127: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2123: x_return_status => l_return_status,
2124: x_msg_count => x_msg_count,
2125: x_msg_data => x_msg_data
2126: );
2127: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2128: RAISE FND_API.g_exc_unexpected_error;
2129: END IF;
2130:
2131: l_wdd_staged_qty := l_wdd_staged_qty + l_ser_num_tab.COUNT; --9695544

Line 2128: RAISE FND_API.g_exc_unexpected_error;

2124: x_msg_count => x_msg_count,
2125: x_msg_data => x_msg_data
2126: );
2127: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2128: RAISE FND_API.g_exc_unexpected_error;
2129: END IF;
2130:
2131: l_wdd_staged_qty := l_wdd_staged_qty + l_ser_num_tab.COUNT; --9695544
2132: l_shipping_attr(1).lot_number := l_lot;

Line 2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2152: );
2153:
2154: IF (l_debug = 1) THEN mydebug('after update shipping attributes'); END IF;
2155:
2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2157: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2158: FND_MSG_PUB.ADD;
2159: RAISE FND_API.g_exc_unexpected_error;
2160:

Line 2159: RAISE FND_API.g_exc_unexpected_error;

2155:
2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2157: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2158: FND_MSG_PUB.ADD;
2159: RAISE FND_API.g_exc_unexpected_error;
2160:
2161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2162: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2163: FND_MSG_PUB.ADD;

Line 2161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2157: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2158: FND_MSG_PUB.ADD;
2159: RAISE FND_API.g_exc_unexpected_error;
2160:
2161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2162: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: END IF;

Line 2164: RAISE FND_API.G_EXC_ERROR;

2160:
2161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2162: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: END IF;
2166:
2167: ELSE
2168:

Line 2199: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2195: x_return_status => l_return_status,
2196: x_msg_count => x_msg_count,
2197: x_msg_data => x_msg_data
2198: );
2199: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2200: RAISE FND_API.g_exc_unexpected_error;
2201: END IF;
2202:
2203: l_wdd_staged_qty := l_wdd_staged_qty + l_ser_num_tab.COUNT; --9695544

Line 2200: RAISE FND_API.g_exc_unexpected_error;

2196: x_msg_count => x_msg_count,
2197: x_msg_data => x_msg_data
2198: );
2199: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2200: RAISE FND_API.g_exc_unexpected_error;
2201: END IF;
2202:
2203: l_wdd_staged_qty := l_wdd_staged_qty + l_ser_num_tab.COUNT; --9695544
2204: l_shipping_attr(1).lot_number := l_lot;

Line 2232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2228: mydebug('after update shipping attributes');
2229: END IF;
2230:
2231:
2232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2233: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2234: FND_MSG_PUB.ADD;
2235: RAISE FND_API.g_exc_unexpected_error;
2236:

Line 2235: RAISE FND_API.g_exc_unexpected_error;

2231:
2232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2233: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2234: FND_MSG_PUB.ADD;
2235: RAISE FND_API.g_exc_unexpected_error;
2236:
2237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2238: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2239: FND_MSG_PUB.ADD;

Line 2237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2233: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2234: FND_MSG_PUB.ADD;
2235: RAISE FND_API.g_exc_unexpected_error;
2236:
2237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2238: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2239: FND_MSG_PUB.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: END IF;

Line 2240: RAISE FND_API.G_EXC_ERROR;

2236:
2237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2238: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2239: FND_MSG_PUB.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: END IF;
2242:
2243: END IF;
2244:

Line 2282: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2278: x_msg_count => x_msg_count,
2279: x_msg_data => x_msg_data
2280: );
2281:
2282: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2283: RAISE FND_API.g_exc_unexpected_error;
2284: END IF;
2285:
2286: l_wdd_staged_qty := l_wdd_staged_qty + l_ser_num_tab.COUNT; --9695544

Line 2283: RAISE FND_API.g_exc_unexpected_error;

2279: x_msg_data => x_msg_data
2280: );
2281:
2282: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2283: RAISE FND_API.g_exc_unexpected_error;
2284: END IF;
2285:
2286: l_wdd_staged_qty := l_wdd_staged_qty + l_ser_num_tab.COUNT; --9695544
2287: l_shipping_attr(1).ordered_quantity := l_ser_num_tab.COUNT;

Line 2310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2306: x_return_status => l_return_status
2307: );
2308:
2309:
2310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2311: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.g_exc_unexpected_error;
2314:

Line 2313: RAISE FND_API.g_exc_unexpected_error;

2309:
2310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2311: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.g_exc_unexpected_error;
2314:
2315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2317: FND_MSG_PUB.ADD;

Line 2315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2311: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.g_exc_unexpected_error;
2314:
2315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2317: FND_MSG_PUB.ADD;
2318: RAISE FND_API.G_EXC_ERROR;
2319: END IF;

Line 2318: RAISE FND_API.G_EXC_ERROR;

2314:
2315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2317: FND_MSG_PUB.ADD;
2318: RAISE FND_API.G_EXC_ERROR;
2319: END IF;
2320:
2321:
2322: IF (l_debug = 1) THEN

Line 2355: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2351: x_return_status => l_return_status,
2352: x_msg_count => x_msg_count,
2353: x_msg_data => x_msg_data
2354: );
2355: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2356: RAISE FND_API.g_exc_unexpected_error;
2357: END IF;
2358:
2359: l_wdd_staged_qty := l_wdd_staged_qty + l_ser_num_tab.COUNT; --9695544

Line 2356: RAISE FND_API.g_exc_unexpected_error;

2352: x_msg_count => x_msg_count,
2353: x_msg_data => x_msg_data
2354: );
2355: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2356: RAISE FND_API.g_exc_unexpected_error;
2357: END IF;
2358:
2359: l_wdd_staged_qty := l_wdd_staged_qty + l_ser_num_tab.COUNT; --9695544
2360: l_shipping_attr(1).ordered_quantity := l_ser_num_tab.COUNT;

Line 2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2379: x_return_status => l_return_status
2380: );
2381:
2382:
2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2384: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2385: FND_MSG_PUB.ADD;
2386: RAISE FND_API.g_exc_unexpected_error;
2387:

Line 2386: RAISE FND_API.g_exc_unexpected_error;

2382:
2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2384: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2385: FND_MSG_PUB.ADD;
2386: RAISE FND_API.g_exc_unexpected_error;
2387:
2388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2390: FND_MSG_PUB.ADD;

Line 2388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2384: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2385: FND_MSG_PUB.ADD;
2386: RAISE FND_API.g_exc_unexpected_error;
2387:
2388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2390: FND_MSG_PUB.ADD;
2391: RAISE FND_API.G_EXC_ERROR;
2392: END IF;

Line 2391: RAISE FND_API.G_EXC_ERROR;

2387:
2388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2390: FND_MSG_PUB.ADD;
2391: RAISE FND_API.G_EXC_ERROR;
2392: END IF;
2393:
2394:
2395: IF (l_debug = 1) THEN

Line 2460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2456: IF (l_debug = 1) THEN
2457: mydebug('return status'|| l_return_status);
2458: END IF;
2459:
2460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2461: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2462: FND_MSG_PUB.ADD;
2463: RAISE FND_API.g_exc_unexpected_error;
2464:

Line 2463: RAISE FND_API.g_exc_unexpected_error;

2459:
2460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2461: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2462: FND_MSG_PUB.ADD;
2463: RAISE FND_API.g_exc_unexpected_error;
2464:
2465: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2466: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2467: FND_MSG_PUB.ADD;

Line 2465: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2461: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2462: FND_MSG_PUB.ADD;
2463: RAISE FND_API.g_exc_unexpected_error;
2464:
2465: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2466: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2467: FND_MSG_PUB.ADD;
2468: RAISE FND_API.G_EXC_ERROR;
2469: END IF;

Line 2468: RAISE FND_API.G_EXC_ERROR;

2464:
2465: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2466: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2467: FND_MSG_PUB.ADD;
2468: RAISE FND_API.G_EXC_ERROR;
2469: END IF;
2470:
2471: IF (l_debug = 1) THEN
2472: mydebug('after update shipping attributes');

Line 2491: RAISE FND_API.G_EXC_ERROR;

2487: EXCEPTION
2488: WHEN NO_DATA_FOUND THEN
2489: FND_MESSAGE.SET_NAME('WMS', 'WMS_TD_DEL_LPN_ERROR');
2490: FND_MSG_PUB.ADD;
2491: RAISE FND_API.G_EXC_ERROR;
2492: END;
2493:
2494: IF (l_debug = 1) THEN
2495: mydebug('Update LPN context to picked');

Line 2571: , p_init_msg_list => fnd_api.g_false

2567: mydebug('Call to WSH Delivery_Detail_Action to pack LPN heirarchy');
2568: END IF;
2569: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
2570: p_api_version_number => 1.0
2571: , p_init_msg_list => fnd_api.g_false
2572: , p_commit => fnd_api.g_false
2573: , x_return_status => x_return_status
2574: , x_msg_count => x_msg_count
2575: , x_msg_data => x_msg_data

Line 2572: , p_commit => fnd_api.g_false

2568: END IF;
2569: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
2570: p_api_version_number => 1.0
2571: , p_init_msg_list => fnd_api.g_false
2572: , p_commit => fnd_api.g_false
2573: , x_return_status => x_return_status
2574: , x_msg_count => x_msg_count
2575: , x_msg_data => x_msg_data
2576: , p_lpn_id_tbl => l_wsh_lpn_id_tbl

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

2578: , p_action_prms => l_wsh_action_prms
2579: , x_defaults => l_wsh_defaults
2580: , x_action_out_rec => l_wsh_action_out_rec );
2581:
2582: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2583: IF (l_debug = 1) THEN
2584: mydebug('Delivery_Detail_Action failed');
2585: END IF;
2586: RAISE fnd_api.g_exc_error;

Line 2586: RAISE fnd_api.g_exc_error;

2582: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2583: IF (l_debug = 1) THEN
2584: mydebug('Delivery_Detail_Action failed');
2585: END IF;
2586: RAISE fnd_api.g_exc_error;
2587: ELSIF (l_debug = 1) THEN
2588: mydebug('Done with call to WSH Create_Update_Containers');
2589: END IF;
2590: END IF;

Line 2617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2613: , p_transaction_id=>l_lpn_del_detail_id
2614: ) ;
2615:
2616:
2617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2618: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.g_exc_unexpected_error;
2621:

Line 2620: RAISE FND_API.g_exc_unexpected_error;

2616:
2617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2618: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.g_exc_unexpected_error;
2621:
2622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2623: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2624: FND_MSG_PUB.ADD;

Line 2622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2618: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.g_exc_unexpected_error;
2621:
2622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2623: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2624: FND_MSG_PUB.ADD;
2625: l_return_status :=FND_API.g_ret_sts_success;
2626: END IF;

Line 2625: l_return_status :=FND_API.g_ret_sts_success;

2621:
2622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2623: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2624: FND_MSG_PUB.ADD;
2625: l_return_status :=FND_API.g_ret_sts_success;
2626: END IF;
2627:
2628: x_return_status:=l_return_status;
2629:

Line 2635: x_return_status:= FND_API.g_ret_sts_success;

2631: -- End of crossdock loop
2632: END IF;
2633:
2634: -- Bug 2465491 The API completes successfully so returns success
2635: x_return_status:= FND_API.g_ret_sts_success;
2636:
2637: EXCEPTION
2638: WHEN FND_API.G_EXC_ERROR THEN
2639: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2638: WHEN FND_API.G_EXC_ERROR THEN

2634: -- Bug 2465491 The API completes successfully so returns success
2635: x_return_status:= FND_API.g_ret_sts_success;
2636:
2637: EXCEPTION
2638: WHEN FND_API.G_EXC_ERROR THEN
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640: -- Get message count and data
2641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2642:

Line 2639: x_return_status := FND_API.G_RET_STS_ERROR;

2635: x_return_status:= FND_API.g_ret_sts_success;
2636:
2637: EXCEPTION
2638: WHEN FND_API.G_EXC_ERROR THEN
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640: -- Get message count and data
2641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640: -- Get message count and data
2641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2645: -- Get message count and data
2646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2647:

Line 2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2640: -- Get message count and data
2641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2645: -- Get message count and data
2646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2647:
2648: WHEN OTHERS THEN

Line 2649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2645: -- Get message count and data
2646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2647:
2648: WHEN OTHERS THEN
2649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2650: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CCDOCK_ERROR' );
2651: FND_MSG_PUB.ADD;
2652: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2653:

Line 2697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2693: IF (l_debug = 1) THEN
2694: mydebug('return status'||l_ret);
2695: END IF;
2696:
2697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2698: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2699: FND_MSG_PUB.ADD;
2700: RAISE FND_API.g_exc_unexpected_error;
2701:

Line 2700: RAISE FND_API.g_exc_unexpected_error;

2696:
2697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2698: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2699: FND_MSG_PUB.ADD;
2700: RAISE FND_API.g_exc_unexpected_error;
2701:
2702: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2703: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2704: FND_MSG_PUB.ADD;

Line 2702: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2698: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2699: FND_MSG_PUB.ADD;
2700: RAISE FND_API.g_exc_unexpected_error;
2701:
2702: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2703: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2704: FND_MSG_PUB.ADD;
2705: RAISE FND_API.G_EXC_ERROR;
2706: END IF;

Line 2705: RAISE FND_API.G_EXC_ERROR;

2701:
2702: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2703: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2704: FND_MSG_PUB.ADD;
2705: RAISE FND_API.G_EXC_ERROR;
2706: END IF;
2707:
2708:
2709:

Line 2714: WHEN FND_API.G_EXC_ERROR THEN

2710: x_ret:=l_ret;
2711: x_return_status:=l_return_status;
2712:
2713: EXCEPTION
2714: WHEN FND_API.G_EXC_ERROR THEN
2715: x_ret := FND_API.G_RET_STS_ERROR;
2716: x_return_status:=l_return_status;
2717: -- Get message count and data
2718: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);

Line 2715: x_ret := FND_API.G_RET_STS_ERROR;

2711: x_return_status:=l_return_status;
2712:
2713: EXCEPTION
2714: WHEN FND_API.G_EXC_ERROR THEN
2715: x_ret := FND_API.G_RET_STS_ERROR;
2716: x_return_status:=l_return_status;
2717: -- Get message count and data
2718: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2719:

Line 2720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2716: x_return_status:=l_return_status;
2717: -- Get message count and data
2718: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2719:
2720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2721: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2722: x_return_status:=l_return_status;
2723: -- Get message count and data
2724: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);

Line 2721: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;

2717: -- Get message count and data
2718: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2719:
2720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2721: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2722: x_return_status:=l_return_status;
2723: -- Get message count and data
2724: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2725:

Line 2727: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;

2723: -- Get message count and data
2724: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2725:
2726: WHEN OTHERS THEN
2727: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2728: x_return_status:=l_return_status;
2729: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MD_ERROR');
2730: FND_MSG_PUB.ADD;
2731: fnd_msg_pub.count_and_get

Line 2754: x_return_status := fnd_api.g_ret_sts_success;

2750: mydebug('CANCEL_WIP_CROSSDOCK_TASK: Entering...');
2751: mydebug('CANCEL_WIP_CROSSDOCK_TASK: MMTT ID: '||p_transaction_temp_id);
2752: mydebug('CANCEL_WIP_CROSSDOCK_TASK: MOL ID: '||p_move_order_line_id);
2753:
2754: x_return_status := fnd_api.g_ret_sts_success;
2755:
2756: --Check to see if the task is loaded. If task is loaded and return an
2757: --error!!!
2758:

Line 2771: x_return_status := fnd_api.g_ret_sts_error;

2767: l_wdt_status := 0;
2768: END;
2769:
2770: IF l_wdt_status = 4 THEN
2771: x_return_status := fnd_api.g_ret_sts_error;
2772: mydebug('Task is loaded... Cannot be canceled ...');
2773: RETURN;
2774: END IF;
2775:

Line 2795: x_return_status := fnd_api.g_ret_sts_unexp_error;

2791: mydebug('CANCEL_WIP_CROSSDOCK_TASK: Exiting...: '||x_return_status);
2792: EXCEPTION
2793: WHEN OTHERS THEN
2794: mydebug('CANCEL_WIP_CROSSDOCK_TASK:ERROR! Unexpected Error:'||SQLCODE);
2795: x_return_status := fnd_api.g_ret_sts_unexp_error;
2796: fnd_msg_pub.count_and_get(p_count => x_msg_count
2797: , p_data => x_msg_data);
2798:
2799: END cancel_wip_crossdock_task;

Line 2816: x_return_status := fnd_api.g_ret_sts_success;

2812: l_move_order_line_id NUMBER;
2813: l_backorder_delivery_detail_id NUMBER;
2814:
2815: BEGIN
2816: x_return_status := fnd_api.g_ret_sts_success;
2817:
2818: mydebug('CANCEL_CROSSDOCK_TASK: Enter...');
2819: mydebug('CANCEL_CROSSDOCK_TASK: MMTT ID: '||p_transaction_temp_id);
2820:

Line 2844: RAISE fnd_api.g_exc_error;

2840: mydebug('CANCEL_CROSSDOCK_TASK: BODDID: '||l_backorder_delivery_detail_id);
2841:
2842: IF l_backorder_delivery_detail_id IS NULL THEN
2843: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Not a Crossdock Task');
2844: RAISE fnd_api.g_exc_error;
2845: END IF;
2846:
2847: --Check the transaction source type.
2848: --If the transaction type is WIP then write a new api to take care of

Line 2879: x_return_status := fnd_api.g_ret_sts_error;

2875:
2876: EXCEPTION
2877: WHEN no_data_found THEN
2878: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Invalid Transaction Temp ID: '||p_transaction_temp_id);
2879: x_return_status := fnd_api.g_ret_sts_error;
2880: fnd_msg_pub.count_and_get(p_count => x_msg_count
2881: , p_data => x_msg_data);
2882: WHEN fnd_api.g_exc_error THEN
2883: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Error raised by the API: '||SQLCODE);

Line 2882: WHEN fnd_api.g_exc_error THEN

2878: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Invalid Transaction Temp ID: '||p_transaction_temp_id);
2879: x_return_status := fnd_api.g_ret_sts_error;
2880: fnd_msg_pub.count_and_get(p_count => x_msg_count
2881: , p_data => x_msg_data);
2882: WHEN fnd_api.g_exc_error THEN
2883: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Error raised by the API: '||SQLCODE);
2884: x_return_status := fnd_api.g_ret_sts_error;
2885: fnd_msg_pub.count_and_get(p_count => x_msg_count
2886: , p_data => x_msg_data);

Line 2884: x_return_status := fnd_api.g_ret_sts_error;

2880: fnd_msg_pub.count_and_get(p_count => x_msg_count
2881: , p_data => x_msg_data);
2882: WHEN fnd_api.g_exc_error THEN
2883: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Error raised by the API: '||SQLCODE);
2884: x_return_status := fnd_api.g_ret_sts_error;
2885: fnd_msg_pub.count_and_get(p_count => x_msg_count
2886: , p_data => x_msg_data);
2887: WHEN OTHERS THEN
2888: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Unexpected Error: '||SQLCODE);

Line 2889: x_return_status := fnd_api.g_ret_sts_unexp_error;

2885: fnd_msg_pub.count_and_get(p_count => x_msg_count
2886: , p_data => x_msg_data);
2887: WHEN OTHERS THEN
2888: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Unexpected Error: '||SQLCODE);
2889: x_return_status := fnd_api.g_ret_sts_unexp_error;
2890: fnd_msg_pub.count_and_get(p_count => x_msg_count
2891: , p_data => x_msg_data);
2892:
2893: END cancel_crossdock_task;