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

Line 226: x_return_status := FND_API.G_RET_STS_SUCCESS;

222: l_pregen_putaway_tasks_flag NUMBER;
223: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
224: BEGIN
225:
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227: l_return_status := fnd_api.g_ret_sts_success;
228: x_msg_count := 0;
229:
230: l_progress := '10';

Line 227: l_return_status := fnd_api.g_ret_sts_success;

223: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
224: BEGIN
225:
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227: l_return_status := fnd_api.g_ret_sts_success;
228: x_msg_count := 0;
229:
230: l_progress := '10';
231: IF (l_debug = 1) THEN

Line 891: x_return_status := FND_API.G_RET_STS_ERROR;

887: IF (l_debug = 1) THEN
888: print_debug('Should not have happened. Not enough quantity in MOL');
889: END IF;
890: /* There is no enought qty in all the MO Lines and hence through an exception */
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: RAISE fnd_api.g_exc_error; --return;
893: END IF;
894:
895: UPDATE mtl_txn_request_lines

Line 892: RAISE fnd_api.g_exc_error; --return;

888: print_debug('Should not have happened. Not enough quantity in MOL');
889: END IF;
890: /* There is no enought qty in all the MO Lines and hence through an exception */
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: RAISE fnd_api.g_exc_error; --return;
893: END IF;
894:
895: UPDATE mtl_txn_request_lines
896: SET wms_process_flag = 1

Line 927: IF l_return_status = fnd_api.g_ret_sts_error THEN

923: x_msg_data => l_msg_data);
924: IF (l_debug = 1) THEN
925: print_debug('After calling the suggestion clean up API'||l_return_status||':'||l_msg_data||':'||l_msg_count,4);
926: END IF;
927: IF l_return_status = fnd_api.g_ret_sts_error THEN
928: IF (l_debug = 1) THEN
929: print_debug('Error while cleaning up the suggestions',2);
930: print_debug('Not calling to pregenerate the suggestions',4);
931: END IF;

Line 970: WHEN FND_API.g_exc_error THEN

966: IF (l_debug = 1) THEN
967: print_debug('Finished updating mol');
968: END IF;
969: EXCEPTION
970: WHEN FND_API.g_exc_error THEN
971: IF (l_debug = 1) THEN
972: print_debug('maintain_move_orders : execution error');
973: END IF;
974:

Line 975: x_return_status := FND_API.G_RET_STS_ERROR;

971: IF (l_debug = 1) THEN
972: print_debug('maintain_move_orders : execution error');
973: END IF;
974:
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
977: WHEN OTHERS THEN
978: IF (l_debug = 1) THEN
979: print_debug('Maintain MO - exception when others at:'||l_progress||': ' || sqlerrm || ':' || sqlcode);

Line 981: x_return_status := FND_API.G_RET_STS_ERROR;

977: WHEN OTHERS THEN
978: IF (l_debug = 1) THEN
979: print_debug('Maintain MO - exception when others at:'||l_progress||': ' || sqlerrm || ':' || sqlcode);
980: END IF;
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
983: x_msg_data := x_msg_data||sqlerrm;
984: END maintain_move_orders;
985:

Line 1011: l_validation_level NUMBER := fnd_api.g_valid_level_full; --bug 5068433

1007: IS
1008:
1009: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1010: l_transactable_flag VARCHAR2(1) := NULL; --bug 5068433
1011: l_validation_level NUMBER := fnd_api.g_valid_level_full; --bug 5068433
1012: l_sec_qty NUMBER := null; -- 12621897
1013: l_sec_uom_code VARCHAR2(50) := null; -- 12621897
1014:
1015: BEGIN

Line 1052: l_validation_level := fnd_api.g_valid_level_none;

1048: print_debug('l_transactable_flag =>' || l_transactable_flag);
1049: END IF;
1050:
1051: IF l_transactable_flag = 'N' THEN --bug 5048633
1052: l_validation_level := fnd_api.g_valid_level_none;
1053: END IF;
1054:
1055: IF (l_debug = 1) THEN
1056: print_debug('l_sec_uom_code =>' || l_sec_uom_code);--bug13011555

Line 1102: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS or x_msg_count > 0) THEN

1098: print_debug('x_msg_count =>' || x_msg_count);
1099: print_debug('x_msg_data =>' || x_msg_data);
1100: END IF;
1101:
1102: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS or x_msg_count > 0) THEN
1103: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1104: x_return_status := 'E';
1105: IF (l_debug = 1) THEN
1106: print_debug('Errored out...');

Line 1103: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1099: print_debug('x_msg_data =>' || x_msg_data);
1100: END IF;
1101:
1102: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS or x_msg_count > 0) THEN
1103: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1104: x_return_status := 'E';
1105: IF (l_debug = 1) THEN
1106: print_debug('Errored out...');
1107: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

Line 1417: x_return_status := FND_API.G_RET_STS_SUCCESS;

1413: WHERE group_id = p_group_id;
1414: l_interface_txn_id NUMBER;
1415: BEGIN
1416:
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418: IF (l_debug = 1) THEN
1419: print_debug('======== Start txn_complete =========');
1420: print_debug(' p_group_id => ' || p_group_id);
1421: print_debug(' p_txn_status => ' || p_txn_status);

Line 1490: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1486: p_source_header_id => i.interface_transaction_id,
1487: p_source_name => i.transaction_type,
1488: p_cost_group_id => i.cg_id
1489: );
1490: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: IF (l_debug = 1) THEN
1492: print_debug('Error while unpacking for rtv/rtc from receiving');
1493: END IF;
1494: RAISE fnd_api.g_exc_error; --return;

Line 1494: RAISE fnd_api.g_exc_error; --return;

1490: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: IF (l_debug = 1) THEN
1492: print_debug('Error while unpacking for rtv/rtc from receiving');
1493: END IF;
1494: RAISE fnd_api.g_exc_error; --return;
1495: END IF;
1496:
1497: ELSIF i.transaction_type = 'CORRECT' THEN -- <> CORRECT
1498: IF (l_debug = 1) THEN

Line 1554: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1550: p_source_name => i.transaction_type,
1551: p_cost_group_id => i.cg_id
1552: );
1553:
1554: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1555: IF (l_debug = 1) THEN
1556: print_debug('Error while unpacking in txn_complete for correction OF ACCEPT/REJECT');
1557: END IF;
1558: RAISE fnd_api.g_exc_error; --return;

Line 1558: RAISE fnd_api.g_exc_error; --return;

1554: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1555: IF (l_debug = 1) THEN
1556: print_debug('Error while unpacking in txn_complete for correction OF ACCEPT/REJECT');
1557: END IF;
1558: RAISE fnd_api.g_exc_error; --return;
1559: END IF;
1560:
1561: PackUnpack_Container(
1562: x_return_status => x_return_status,

Line 1582: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1578: p_source_name => NULL,
1579: p_cost_group_id => NULL
1580: );
1581:
1582: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1583: IF (l_debug = 1) THEN
1584: print_debug('Error while packing in txn_complete for correction OF ACCEPT/REJECT');
1585: END IF;
1586: RAISE fnd_api.g_exc_error; --return;

Line 1586: RAISE fnd_api.g_exc_error; --return;

1582: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1583: IF (l_debug = 1) THEN
1584: print_debug('Error while packing in txn_complete for correction OF ACCEPT/REJECT');
1585: END IF;
1586: RAISE fnd_api.g_exc_error; --return;
1587: END IF;
1588:
1589: -- Update the context for the pack lpn to 'resides in
1590: -- receiving' as packunpack api may have changed it to

Line 1638: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1634: p_source_name => i.transaction_type,
1635: p_cost_group_id => i.cg_id
1636: );
1637:
1638: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1639: IF (l_debug = 1) THEN
1640: print_debug('Error in unpacking for Correct Txn = +ve Correct RTV/RTC or -ve on Receive Txns');
1641: END IF;
1642: RAISE fnd_api.g_exc_error; --return;

Line 1642: RAISE fnd_api.g_exc_error; --return;

1638: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1639: IF (l_debug = 1) THEN
1640: print_debug('Error in unpacking for Correct Txn = +ve Correct RTV/RTC or -ve on Receive Txns');
1641: END IF;
1642: RAISE fnd_api.g_exc_error; --return;
1643: END IF;
1644:
1645: --ELSIF i.lpn_id IS NULL AND i.transfer_lpn_id IS NOT NULL THEN
1646: ELSIF (l_parent_transaction_type IN ('RETURN TO VENDOR','RETURN TO CUSTOMER')

Line 1917: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1913: x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count,
1914: x_error_code => l_error_code
1915: );
1916:
1917: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1918: IF (l_debug = 1) THEN
1919: print_debug('TXN_COMPLETE: Error while calling query_reservations');
1920: END IF;
1921: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);

Line 1922: RAISE fnd_api.g_exc_error; --return;

1918: IF (l_debug = 1) THEN
1919: print_debug('TXN_COMPLETE: Error while calling query_reservations');
1920: END IF;
1921: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);
1922: RAISE fnd_api.g_exc_error; --return;
1923: END IF;
1924:
1925: IF (l_debug = 1) THEN
1926: print_debug('TXN_COMPLETE: No. of reservation recs found:'||l_mtl_reservation_tbl_count);

Line 1945: p_init_msg_lst => FND_API.G_FALSE,

1941: print_debug('TXN_COMPLETE: Deleting the reservation...');
1942: END IF;
1943: INV_RESERVATION_PUB.DELETE_RESERVATION(
1944: p_api_version_number => 1.0,
1945: p_init_msg_lst => FND_API.G_FALSE,
1946: x_return_status => x_return_status,
1947: x_msg_count => x_msg_count,
1948: x_msg_data => x_msg_data,
1949: p_rsv_rec => l_res_rec_to_delete,

Line 1952: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1948: x_msg_data => x_msg_data,
1949: p_rsv_rec => l_res_rec_to_delete,
1950: p_serial_number => l_dummy_sn
1951: );
1952: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1953: IF (l_debug = 1) THEN
1954: print_debug('TXN_COMPLETE: Error while deleting reservations');
1955: END IF;
1956: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);

Line 1957: RAISE fnd_api.g_exc_error; --return;

1953: IF (l_debug = 1) THEN
1954: print_debug('TXN_COMPLETE: Error while deleting reservations');
1955: END IF;
1956: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);
1957: RAISE fnd_api.g_exc_error; --return;
1958: END IF;
1959: IF (l_debug = 1) THEN
1960: print_debug('TXN_COMPLETE: Deleted the reservation record successfully');
1961: END IF;

Line 2162: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2158: p_source_header_id => NULL,
2159: p_source_name => NULL,
2160: P_COST_GROUP_ID => NULL);
2161:
2162: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2163: IF (l_debug = 1) THEN
2164: print_debug('Error in txn_complete while unpacking for txn failure');
2165: END IF;
2166: RAISE fnd_api.g_exc_error; --return; -- error while unpacking

Line 2166: RAISE fnd_api.g_exc_error; --return; -- error while unpacking

2162: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2163: IF (l_debug = 1) THEN
2164: print_debug('Error in txn_complete while unpacking for txn failure');
2165: END IF;
2166: RAISE fnd_api.g_exc_error; --return; -- error while unpacking
2167: end if;
2168:
2169: END LOOP;
2170:

Line 2210: WHEN FND_API.g_exc_error THEN

2206: print_debug('Exiting txn_complete');
2207: END IF;
2208:
2209: EXCEPTION
2210: WHEN FND_API.g_exc_error THEN
2211: IF (l_debug = 1) THEN
2212: print_debug('txn_complete : execution error');
2213: END IF;
2214:

Line 2215: x_return_status := FND_API.G_RET_STS_ERROR;

2211: IF (l_debug = 1) THEN
2212: print_debug('txn_complete : execution error');
2213: END IF;
2214:
2215: x_return_status := FND_API.G_RET_STS_ERROR;
2216: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2217: WHEN OTHERS THEN
2218: IF (l_debug = 1) THEN
2219: print_debug('In exception when others: ' || sqlerrm || ':' || sqlcode);

Line 2221: x_return_status := FND_API.G_RET_STS_ERROR;

2217: WHEN OTHERS THEN
2218: IF (l_debug = 1) THEN
2219: print_debug('In exception when others: ' || sqlerrm || ':' || sqlcode);
2220: END IF;
2221: x_return_status := FND_API.G_RET_STS_ERROR;
2222: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2223: x_msg_data := x_msg_data||sqlerrm;
2224: END txn_complete;
2225:

Line 2406: x_return_status := FND_API.G_RET_STS_SUCCESS;

2402: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2403: BEGIN
2404:
2405: l_position := '0010';
2406: x_return_status := FND_API.G_RET_STS_SUCCESS;
2407: IF (l_debug = 1) THEN
2408: print_debug('Enter MARK_RETURNS');
2409: print_debug('p_serial_controlled => ' || p_serial_controlled);
2410: print_debug('p_lot_controlled => ' || p_lot_controlled);

Line 2598: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2594: p_secondary_quantity => abs(l_sec_qty) --13399743
2595: );
2596: l_position := '0100';
2597:
2598: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2599: IF (l_debug = 1) THEN
2600: print_debug('Error in mark_returns while unpacking');
2601: END IF;
2602: RAISE fnd_api.g_exc_error; --return; -- error while unpacking

Line 2602: RAISE fnd_api.g_exc_error; --return; -- error while unpacking

2598: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2599: IF (l_debug = 1) THEN
2600: print_debug('Error in mark_returns while unpacking');
2601: END IF;
2602: RAISE fnd_api.g_exc_error; --return; -- error while unpacking
2603: end if;
2604:
2605: PackUnpack_Container(
2606: x_return_status => x_return_status,

Line 2627: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2623: P_COST_GROUP_ID => l_cost_group_id,
2624: p_secondary_quantity => abs(l_sec_qty) --13399743
2625: );
2626:
2627: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2628: IF (l_debug = 1) THEN
2629: print_debug('Error in mark_returns while packing');
2630: END IF;
2631: RAISE fnd_api.g_exc_error; --return; -- error while packing

Line 2631: RAISE fnd_api.g_exc_error; --return; -- error while packing

2627: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2628: IF (l_debug = 1) THEN
2629: print_debug('Error in mark_returns while packing');
2630: END IF;
2631: RAISE fnd_api.g_exc_error; --return; -- error while packing
2632: end if;
2633:
2634: END LOOP;
2635:

Line 2647: , p_validation_level => fnd_api.g_valid_level_none

2643:
2644: wms_container_pvt.Modify_LPN
2645: (
2646: p_api_version => 1.0
2647: , p_validation_level => fnd_api.g_valid_level_none
2648: , x_return_status => l_return_status
2649: , x_msg_count => l_msg_count
2650: , x_msg_data => l_msg_data
2651: , p_lpn => l_lpn_update

Line 2674: WHEN FND_API.g_exc_error THEN

2670: print_debug('Exit MARK_RETURNS');
2671: END IF;
2672:
2673: EXCEPTION
2674: WHEN FND_API.g_exc_error THEN
2675: IF (l_debug = 1) THEN
2676: print_debug('mark_returns : execution error');
2677: END IF;
2678:

Line 2679: x_return_status := FND_API.G_RET_STS_ERROR;

2675: IF (l_debug = 1) THEN
2676: print_debug('mark_returns : execution error');
2677: END IF;
2678:
2679: x_return_status := FND_API.G_RET_STS_ERROR;
2680: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2681: when others then
2682: IF (l_debug = 1) THEN
2683: print_debug('Error(' || l_position || '):' || sqlerrm);

Line 2685: x_return_status := FND_API.G_RET_STS_ERROR;

2681: when others then
2682: IF (l_debug = 1) THEN
2683: print_debug('Error(' || l_position || '):' || sqlerrm);
2684: END IF;
2685: x_return_status := FND_API.G_RET_STS_ERROR;
2686: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2687: x_msg_data := x_msg_data||sqlerrm;
2688: END MARK_RETURNS;
2689:

Line 2733: x_return_status := FND_API.G_RET_STS_SUCCESS;

2729:
2730: BEGIN
2731:
2732: l_position := '0010';
2733: x_return_status := FND_API.G_RET_STS_SUCCESS;
2734:
2735: IF (l_debug = 1) THEN
2736: print_debug('RTV ER:Inside Unmark API ' || p_rcv_trx_interface_id );
2737: print_debug('RTV ER:Inside Unmark API ' || p_lpn_id );

Line 2781: x_return_status := FND_API.G_RET_STS_ERROR;

2777: IF (l_debug = 1) THEN
2778: l_position := '0040';
2779: print_debug('Error(' || l_position || '):' || sqlerrm);
2780: END IF;
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2783: x_msg_data := x_msg_data||sqlerrm;
2784:
2785: END unmark_returns;

Line 2830: x_return_status := FND_API.G_RET_STS_SUCCESS;

2826:
2827: BEGIN
2828:
2829: l_position := '0010';
2830: x_return_status := FND_API.G_RET_STS_SUCCESS;
2831:
2832: SELECT transfer_lpn_id INTO l_lpn_id FROM rcv_transactions_interface
2833: WHERE interface_transaction_id = p_interface_txn_id;
2834:

Line 2937: RAISE fnd_api.g_exc_error;

2933: EXCEPTION
2934: WHEN NO_DATA_FOUND THEN
2935: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2936: fnd_msg_pub.ADD;
2937: RAISE fnd_api.g_exc_error;
2938: END;
2939:
2940:
2941:

Line 2955: , p_init_msg_list => fnd_api.g_false

2951: l_IN_rec.action_code := 'CREATE';
2952:
2953: WSH_WMS_LPN_GRP.Create_Update_Containers (
2954: p_api_version => 1.0
2955: , p_init_msg_list => fnd_api.g_false
2956: , p_commit => fnd_api.g_false
2957: , x_return_status => x_return_status
2958: , x_msg_count => x_msg_count
2959: , x_msg_data => x_msg_data

Line 2956: , p_commit => fnd_api.g_false

2952:
2953: WSH_WMS_LPN_GRP.Create_Update_Containers (
2954: p_api_version => 1.0
2955: , p_init_msg_list => fnd_api.g_false
2956: , p_commit => fnd_api.g_false
2957: , x_return_status => x_return_status
2958: , x_msg_count => x_msg_count
2959: , x_msg_data => x_msg_data
2960: , p_detail_info_tab => wsh_create_tbl

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

2961: , p_IN_rec => l_IN_rec
2962: , x_OUT_rec => l_OUT_rec );
2963:
2964:
2965: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
2966: IF (l_debug = 1) THEN
2967: print_debug('Create_Update_Containers Failed');
2968: END IF ;
2969:

Line 3022: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

3018:
3019: END LOOP ;
3020:
3021:
3022: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3023: IF (l_debug = 1) THEN
3024: print_debug('return error from update shipping attributes');
3025: END IF;
3026: RAISE fnd_api.g_exc_error;

Line 3026: RAISE fnd_api.g_exc_error;

3022: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3023: IF (l_debug = 1) THEN
3024: print_debug('return error from update shipping attributes');
3025: END IF;
3026: RAISE fnd_api.g_exc_error;
3027: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3028: IF (l_debug = 1) THEN
3029: print_debug('return error from update shipping attributes');
3030: END IF;

Line 3027: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3023: IF (l_debug = 1) THEN
3024: print_debug('return error from update shipping attributes');
3025: END IF;
3026: RAISE fnd_api.g_exc_error;
3027: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3028: IF (l_debug = 1) THEN
3029: print_debug('return error from update shipping attributes');
3030: END IF;
3031: RAISE fnd_api.g_exc_unexpected_error;

Line 3031: RAISE fnd_api.g_exc_unexpected_error;

3027: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3028: IF (l_debug = 1) THEN
3029: print_debug('return error from update shipping attributes');
3030: END IF;
3031: RAISE fnd_api.g_exc_unexpected_error;
3032: END IF;
3033:
3034:
3035: EXCEPTION

Line 3041: x_return_status := FND_API.G_RET_STS_ERROR;

3037: IF (l_debug = 1) THEN
3038: l_position := '0040';
3039: print_debug('Error(' || l_position || '):' || sqlerrm);
3040: END IF;
3041: x_return_status := FND_API.G_RET_STS_ERROR;
3042: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3043: x_msg_data := x_msg_data||sqlerrm;
3044:
3045: END Create_Update_Containers_RTV;

Line 3073: x_return_status := FND_API.G_RET_STS_SUCCESS;

3069: BEGIN
3070:
3071:
3072: l_position := '0011';
3073: x_return_status := FND_API.G_RET_STS_SUCCESS;
3074:
3075: IF (l_debug = 1) THEN
3076: print_debug('RTV ER: perform_post_TM_wms_updates ::' || p_rcv_trx_interface_id );
3077: END IF;

Line 3133: x_return_status := FND_API.G_RET_STS_ERROR;

3129: IF (l_debug = 1) THEN
3130: l_position := '0013';
3131: print_debug('Error(' || l_position || '):' || sqlerrm);
3132: END IF;
3133: x_return_status := FND_API.G_RET_STS_ERROR;
3134: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3135: x_msg_data := x_msg_data||sqlerrm;
3136:
3137:

Line 3293: x_return_status := FND_API.G_RET_STS_ERROR;

3289: , p_secondary_uom => l_secondary_unit_of_measure );
3290:
3291: IF (l_return_status = -1) THEN
3292: l_position := '0040';
3293: x_return_status := FND_API.G_RET_STS_ERROR;
3294: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3295: END IF;
3296:
3297: IF (l_debug = 1) THEN

Line 3325: x_return_status := FND_API.G_RET_STS_ERROR;

3321: IF (l_debug = 1) THEN
3322: print_debug('Error While inserting lot transaction ' || l_unpack_rec.lot_number);
3323: END IF;
3324: l_position := '0040';
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3327: END IF;
3328:
3329: --Review Comments

Line 3356: x_return_status := FND_API.G_RET_STS_ERROR;

3352: IF (l_debug = 1) THEN
3353: print_debug('Error occured while inserting Serial transaction ' || l_unpack_rec.lpn_id);
3354: END IF;
3355: l_position := '0040';
3356: x_return_status := FND_API.G_RET_STS_ERROR;
3357: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3358: END IF;
3359: --fnd_message.debug('Created MSNT Successfully.');
3360: IF (l_debug = 1) THEN

Line 3372: x_return_status := FND_API.G_RET_STS_ERROR;

3368: IF (l_debug = 1) THEN
3369: l_position := '0040';
3370: print_debug('Error(' || l_position || '):' || sqlerrm);
3371: END IF;
3372: x_return_status := FND_API.G_RET_STS_ERROR;
3373: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3374: x_msg_data := x_msg_data||sqlerrm;
3375: END callUnpack;
3376:

Line 3420: x_return_status := FND_API.G_RET_STS_SUCCESS;

3416: l_lpnrti_rec c_get_lpnrti%ROWTYPE ;
3417: l_lpn_id NUMBER;
3418: BEGIN
3419: l_position := '0010';
3420: x_return_status := FND_API.G_RET_STS_SUCCESS;
3421: IF (l_debug = 1) THEN
3422: print_debug('Enter cancel_return_order_RTV ' || p_rtv_order);
3423: END IF;
3424: OPEN c_get_lpnrti;

Line 3478: x_return_status := FND_API.G_RET_STS_ERROR;

3474: IF (l_debug = 1) THEN
3475: print_debug('Error occured while processing LPN ' || l_lpn_id);
3476: END IF;
3477: l_position := '0040';
3478: x_return_status := FND_API.G_RET_STS_ERROR;
3479: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3480: END IF;
3481: IF (l_debug = 1) THEN
3482: print_debug('LPN Processed for LPN' || l_lpn_id);

Line 3496: x_return_status := FND_API.G_RET_STS_ERROR;

3492: IF (l_debug = 1) THEN
3493: l_position := '0040';
3494: print_debug('Error(' || l_position || '):' || sqlerrm);
3495: END IF;
3496: x_return_status := FND_API.G_RET_STS_ERROR;
3497: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3498: x_msg_data := x_msg_data||sqlerrm;
3499:
3500: END cancel_return_order_RTV;

Line 3541: x_return_status := FND_API.G_RET_STS_SUCCESS;

3537: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3538: BEGIN
3539:
3540: l_position := '0010';
3541: x_return_status := FND_API.G_RET_STS_SUCCESS;
3542:
3543: /* FP-J Lot/Serial Support Enhancement
3544: * Read the currentand PO patch levels and set the flag (that would be used to
3545: * match the Lot Number and the LPN) accordingly

Line 3655: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

3651: p_source_name => p_ret_transaction_type,
3652: P_COST_GROUP_ID => NULL
3653: );
3654:
3655: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
3656: IF (l_debug = 1) THEN
3657: print_debug('Error in PACK_INTO_RECEIVING while packing');
3658: END IF;
3659: RAISE fnd_api.g_exc_error; --return; -- error while packing

Line 3659: RAISE fnd_api.g_exc_error; --return; -- error while packing

3655: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
3656: IF (l_debug = 1) THEN
3657: print_debug('Error in PACK_INTO_RECEIVING while packing');
3658: END IF;
3659: RAISE fnd_api.g_exc_error; --return; -- error while packing
3660: end if;
3661:
3662: END LOOP;
3663:

Line 3680: WHEN FND_API.g_exc_error THEN

3676: END IF;
3677: END IF;--IF (l_wms_po_j_higher = FALSE) THEN
3678:
3679: EXCEPTION
3680: WHEN FND_API.g_exc_error THEN
3681: IF (l_debug = 1) THEN
3682: print_debug('maintain_move_orders : execution error');
3683: END IF;
3684:

Line 3685: x_return_status := FND_API.G_RET_STS_ERROR;

3681: IF (l_debug = 1) THEN
3682: print_debug('maintain_move_orders : execution error');
3683: END IF;
3684:
3685: x_return_status := FND_API.G_RET_STS_ERROR;
3686: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3687: when others then
3688: x_return_status := FND_API.G_RET_STS_ERROR;
3689: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

Line 3688: x_return_status := FND_API.G_RET_STS_ERROR;

3684:
3685: x_return_status := FND_API.G_RET_STS_ERROR;
3686: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3687: when others then
3688: x_return_status := FND_API.G_RET_STS_ERROR;
3689: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3690: x_msg_data := x_msg_data||sqlerrm;
3691: IF (l_debug = 1) THEN
3692: print_debug('Error(' || l_position || '):' || sqlerrm);

Line 3731: x_return_status := fnd_api.g_ret_sts_success;

3727: print_debug('p_txn_proc_mode =>' || p_txn_proc_mode);
3728: print_debug('p_group_id =>' || p_group_id);
3729: END IF;
3730:
3731: x_return_status := fnd_api.g_ret_sts_success;
3732:
3733: open c_ref for SELECT SOURCE_HEADER_ID
3734: FROM WMS_LPN_CONTENTS WLPNC
3735: WHERE WLPNC.ORGANIZATION_ID = p_org_id

Line 3788: WHEN fnd_api.g_exc_error THEN

3784: print_debug('END OF LOOP PROCESS WHOLE LPN RETURN - Serial Records');
3785: END IF;
3786:
3787: EXCEPTION
3788: WHEN fnd_api.g_exc_error THEN
3789:
3790: x_return_status := fnd_api.g_ret_sts_error;
3791: IF (l_debug = 1) THEN
3792: print_debug('x_return_status =>' || x_return_status);

Line 3790: x_return_status := fnd_api.g_ret_sts_error;

3786:
3787: EXCEPTION
3788: WHEN fnd_api.g_exc_error THEN
3789:
3790: x_return_status := fnd_api.g_ret_sts_error;
3791: IF (l_debug = 1) THEN
3792: print_debug('x_return_status =>' || x_return_status);
3793: END IF;
3794:

Line 3809: WHEN fnd_api.g_exc_unexpected_error THEN

3805: CLOSE c_ref_ser;
3806: END IF;
3807:
3808:
3809: WHEN fnd_api.g_exc_unexpected_error THEN
3810:
3811: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3812: IF (l_debug = 1) THEN
3813: print_debug('x_return_status =>' || x_return_status);

Line 3811: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3807:
3808:
3809: WHEN fnd_api.g_exc_unexpected_error THEN
3810:
3811: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3812: IF (l_debug = 1) THEN
3813: print_debug('x_return_status =>' || x_return_status);
3814: END IF;
3815:

Line 3832: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3828:
3829:
3830: WHEN others THEN
3831:
3832: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3833: IF (l_debug = 1) THEN
3834: print_debug('x_return_status =>' || x_return_status);
3835: END IF;
3836: --

Line 3892: x_return_status := fnd_api.g_ret_sts_success;

3888:
3889: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3890: BEGIN
3891:
3892: x_return_status := fnd_api.g_ret_sts_success;
3893:
3894: IF (l_debug = 1) THEN
3895: print_debug('Enter PROCESS_RETURNS');
3896: print_debug('Called PROCESS_RETURNS with the parameters');

Line 3989: WHEN fnd_api.g_exc_error THEN

3985: print_debug('END OF LOOP PROCESS RETURNS');
3986: END IF;
3987:
3988: EXCEPTION
3989: WHEN fnd_api.g_exc_error THEN
3990:
3991: x_return_status := fnd_api.g_ret_sts_error;
3992: IF (l_debug = 1) THEN
3993: print_debug('x_return_status =>' || x_return_status);

Line 3991: x_return_status := fnd_api.g_ret_sts_error;

3987:
3988: EXCEPTION
3989: WHEN fnd_api.g_exc_error THEN
3990:
3991: x_return_status := fnd_api.g_ret_sts_error;
3992: IF (l_debug = 1) THEN
3993: print_debug('x_return_status =>' || x_return_status);
3994: END IF;
3995:

Line 4007: WHEN fnd_api.g_exc_unexpected_error THEN

4003: CLOSE c_ref;
4004: END IF;
4005:
4006:
4007: WHEN fnd_api.g_exc_unexpected_error THEN
4008:
4009: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4010: IF (l_debug = 1) THEN
4011: print_debug('x_return_status =>' || x_return_status);

Line 4009: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4005:
4006:
4007: WHEN fnd_api.g_exc_unexpected_error THEN
4008:
4009: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4010: IF (l_debug = 1) THEN
4011: print_debug('x_return_status =>' || x_return_status);
4012: END IF;
4013:

Line 4027: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4023:
4024:
4025: WHEN others THEN
4026:
4027: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4028: IF (l_debug = 1) THEN
4029: print_debug('x_return_status =>' || x_return_status);
4030: END IF;
4031: --

Line 4214: x_return_status := fnd_api.g_ret_sts_success;

4210: l_wms_po_j_higher BOOLEAN;
4211:
4212: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4213: BEGIN
4214: x_return_status := fnd_api.g_ret_sts_success;
4215:
4216: IF (l_debug = 1) THEN
4217: print_debug('CREATE_RETURN_RESV:Interface Transaction ID:'||p_intf_txn_id,1);
4218: END IF;

Line 4314: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4310: x_mtl_reservation_tbl_count => l_upd_reservation_tbl_cnt,
4311: x_error_code => l_error_code
4312: );
4313:
4314: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4315: IF (l_debug = 1) THEN
4316: print_debug('CREATE_RETURN_RESV:Error while calling query_reservations');
4317: END IF;
4318: RAISE FND_API.G_EXC_ERROR;

Line 4318: RAISE FND_API.G_EXC_ERROR;

4314: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4315: IF (l_debug = 1) THEN
4316: print_debug('CREATE_RETURN_RESV:Error while calling query_reservations');
4317: END IF;
4318: RAISE FND_API.G_EXC_ERROR;
4319: END IF;
4320:
4321: IF (l_debug = 1) THEN
4322: print_debug('CREATE_RETURN_RESV:There are ' || l_upd_reservation_tbl_cnt || ' reservation records');

Line 4354: RAISE fnd_api.g_exc_error;

4350: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
4351: fnd_message.set_token('UOM', l_item_primary_uom);
4352: fnd_message.set_token('ROUTINE', 'Create Reservation');
4353: fnd_msg_pub.ADD;
4354: RAISE fnd_api.g_exc_error;
4355: END IF;
4356: ELSE --IF l_uom_code <> l_item_primary_uom THEN
4357: l_primary_res_qty := p_reservation_qty;
4358: END IF; --IF l_uom_code <> l_item_primary_uom THEN

Line 4374: p_init_msg_lst => FND_API.G_FALSE,

4370:
4371: --Update the reservation record with the new quantity
4372: INV_RESERVATION_PUB.UPDATE_RESERVATION(
4373: p_api_version_number => 1.0,
4374: p_init_msg_lst => FND_API.G_FALSE,
4375: x_return_status => x_return_status,
4376: x_msg_count => x_msg_count,
4377: x_msg_data => x_msg_data,
4378: p_original_rsv_rec => l_upd_reservation_tbl(l_count),

Line 4382: p_validation_flag => FND_API.G_TRUE);

4378: p_original_rsv_rec => l_upd_reservation_tbl(l_count),
4379: p_to_rsv_rec => l_upd_reservation_record,
4380: p_original_serial_number => l_dummy_sn,
4381: p_to_serial_number => l_dummy_sn,
4382: p_validation_flag => FND_API.G_TRUE);
4383:
4384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4385: IF (l_debug = 1) THEN
4386: print_debug('CREATE_RETURN_RESV:error in update_reservation');

Line 4384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4380: p_original_serial_number => l_dummy_sn,
4381: p_to_serial_number => l_dummy_sn,
4382: p_validation_flag => FND_API.G_TRUE);
4383:
4384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4385: IF (l_debug = 1) THEN
4386: print_debug('CREATE_RETURN_RESV:error in update_reservation');
4387: END IF;
4388: FND_MESSAGE.SET_NAME('INB', 'INV_UPD_RSV_FAILED');

Line 4390: RAISE fnd_api.g_exc_error;

4386: print_debug('CREATE_RETURN_RESV:error in update_reservation');
4387: END IF;
4388: FND_MESSAGE.SET_NAME('INB', 'INV_UPD_RSV_FAILED');
4389: FND_MSG_PUB.ADD;
4390: RAISE fnd_api.g_exc_error;
4391: END IF;
4392: IF (l_debug = 1) THEN
4393: print_debug('CREATE_RETURN_RESV:successfully updated a reservation record: ' ||sql%rowcount);
4394: END IF;

Line 4427: RAISE fnd_api.g_exc_error;

4423: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
4424: fnd_message.set_token('UOM', l_item_primary_uom);
4425: fnd_message.set_token('ROUTINE', 'Create Reservation');
4426: fnd_msg_pub.add;
4427: RAISE fnd_api.g_exc_error;
4428: END IF;
4429: ELSE --IF l_uom_code <> l_item_primary_uom THEN
4430: l_primary_res_qty := p_reservation_qty;
4431: END IF; --IF l_uom_code <> l_item_primary_uom THEN

Line 4510: p_init_msg_lst => FND_API.G_FALSE,

4506: x_serial_number => l_dummy_sn,
4507: x_quantity_reserved => l_quantity_reserved,
4508: x_reservation_id => l_reservation_id,
4509: p_api_version_number => 1.0,
4510: p_init_msg_lst => FND_API.G_FALSE,
4511: p_rsv_rec => l_reservation_record,
4512: p_partial_reservation_flag => FND_API.G_TRUE,
4513: p_force_reservation_flag => FND_API.G_TRUE,
4514: p_serial_number => l_dummy_sn,

Line 4512: p_partial_reservation_flag => FND_API.G_TRUE,

4508: x_reservation_id => l_reservation_id,
4509: p_api_version_number => 1.0,
4510: p_init_msg_lst => FND_API.G_FALSE,
4511: p_rsv_rec => l_reservation_record,
4512: p_partial_reservation_flag => FND_API.G_TRUE,
4513: p_force_reservation_flag => FND_API.G_TRUE,
4514: p_serial_number => l_dummy_sn,
4515: p_validation_flag => FND_API.G_TRUE);
4516:

Line 4513: p_force_reservation_flag => FND_API.G_TRUE,

4509: p_api_version_number => 1.0,
4510: p_init_msg_lst => FND_API.G_FALSE,
4511: p_rsv_rec => l_reservation_record,
4512: p_partial_reservation_flag => FND_API.G_TRUE,
4513: p_force_reservation_flag => FND_API.G_TRUE,
4514: p_serial_number => l_dummy_sn,
4515: p_validation_flag => FND_API.G_TRUE);
4516:
4517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4515: p_validation_flag => FND_API.G_TRUE);

4511: p_rsv_rec => l_reservation_record,
4512: p_partial_reservation_flag => FND_API.G_TRUE,
4513: p_force_reservation_flag => FND_API.G_TRUE,
4514: p_serial_number => l_dummy_sn,
4515: p_validation_flag => FND_API.G_TRUE);
4516:
4517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4518: IF (l_debug = 1) THEN
4519: print_debug('CREATE_RETURN_RESV:error creating reservation: status:' || x_return_status || 'mess:' || sqlerrm);

Line 4517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4513: p_force_reservation_flag => FND_API.G_TRUE,
4514: p_serial_number => l_dummy_sn,
4515: p_validation_flag => FND_API.G_TRUE);
4516:
4517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4518: IF (l_debug = 1) THEN
4519: print_debug('CREATE_RETURN_RESV:error creating reservation: status:' || x_return_status || 'mess:' || sqlerrm);
4520: END IF;
4521: RAISE FND_API.G_EXC_ERROR;

Line 4521: RAISE FND_API.G_EXC_ERROR;

4517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4518: IF (l_debug = 1) THEN
4519: print_debug('CREATE_RETURN_RESV:error creating reservation: status:' || x_return_status || 'mess:' || sqlerrm);
4520: END IF;
4521: RAISE FND_API.G_EXC_ERROR;
4522: END IF;
4523: IF (l_debug = 1) THEN
4524: print_debug('CREATE_RETURN_RESV:Reservation created successfully. Reservation Id: ' || l_reservation_id || ' . Quantity Reserved: ' || l_quantity_reserved);
4525: END IF;

Line 4540: WHEN fnd_api.g_exc_error THEN

4536: CLOSE c_lots_old;
4537: END IF;
4538:
4539: EXCEPTION
4540: WHEN fnd_api.g_exc_error THEN
4541: x_return_status := fnd_api.g_ret_sts_error;
4542: fnd_msg_pub.count_and_get
4543: ( p_count => x_msg_count,
4544: p_data => x_msg_data

Line 4541: x_return_status := fnd_api.g_ret_sts_error;

4537: END IF;
4538:
4539: EXCEPTION
4540: WHEN fnd_api.g_exc_error THEN
4541: x_return_status := fnd_api.g_ret_sts_error;
4542: fnd_msg_pub.count_and_get
4543: ( p_count => x_msg_count,
4544: p_data => x_msg_data
4545: );

Line 4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4542: fnd_msg_pub.count_and_get
4543: ( p_count => x_msg_count,
4544: p_data => x_msg_data
4545: );
4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4548: IF (l_debug = 1) THEN
4549: print_debug('unxp:' || sqlerrm);
4550: END IF;

Line 4547: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4543: ( p_count => x_msg_count,
4544: p_data => x_msg_data
4545: );
4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4548: IF (l_debug = 1) THEN
4549: print_debug('unxp:' || sqlerrm);
4550: END IF;
4551: fnd_msg_pub.count_and_get

Line 4556: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4552: ( p_count => x_msg_count,
4553: p_data => x_msg_data
4554: );
4555: WHEN OTHERS THEN
4556: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4557: fnd_msg_pub.count_and_get
4558: ( p_count => x_msg_count,
4559: p_data => x_msg_data
4560: );