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 1010: l_validation_level NUMBER := fnd_api.g_valid_level_full; --bug 5068433

1006: IS
1007:
1008: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1009: l_transactable_flag VARCHAR2(1) := NULL; --bug 5068433
1010: l_validation_level NUMBER := fnd_api.g_valid_level_full; --bug 5068433
1011: BEGIN
1012:
1013: IF (l_debug = 1) THEN
1014: print_debug('=== Calling WMS_Container_PUB.PackUnpack_Container ===');

Line 1049: l_validation_level := fnd_api.g_valid_level_none;

1045: print_debug('l_transactable_flag =>' || l_transactable_flag);
1046: END IF;
1047:
1048: IF l_transactable_flag = 'N' THEN --bug 5048633
1049: l_validation_level := fnd_api.g_valid_level_none;
1050: END IF;
1051:
1052:
1053: WMS_Container_PUB.PackUnpack_Container(

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

1079: print_debug('x_msg_count =>' || x_msg_count);
1080: print_debug('x_msg_data =>' || x_msg_data);
1081: END IF;
1082:
1083: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS or x_msg_count > 0) THEN
1084: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1085: x_return_status := 'E';
1086: IF (l_debug = 1) THEN
1087: print_debug('Errored out...');

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

1080: print_debug('x_msg_data =>' || x_msg_data);
1081: END IF;
1082:
1083: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS or x_msg_count > 0) THEN
1084: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1085: x_return_status := 'E';
1086: IF (l_debug = 1) THEN
1087: print_debug('Errored out...');
1088: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

Line 1398: x_return_status := FND_API.G_RET_STS_SUCCESS;

1394: WHERE group_id = p_group_id;
1395: l_interface_txn_id NUMBER;
1396: BEGIN
1397:
1398: x_return_status := FND_API.G_RET_STS_SUCCESS;
1399: IF (l_debug = 1) THEN
1400: print_debug('======== Start txn_complete =========');
1401: print_debug(' p_group_id => ' || p_group_id);
1402: print_debug(' p_txn_status => ' || p_txn_status);

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

1467: p_source_header_id => i.interface_transaction_id,
1468: p_source_name => i.transaction_type,
1469: p_cost_group_id => i.cg_id
1470: );
1471: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1472: IF (l_debug = 1) THEN
1473: print_debug('Error while unpacking for rtv/rtc from receiving');
1474: END IF;
1475: RAISE fnd_api.g_exc_error; --return;

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

1471: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1472: IF (l_debug = 1) THEN
1473: print_debug('Error while unpacking for rtv/rtc from receiving');
1474: END IF;
1475: RAISE fnd_api.g_exc_error; --return;
1476: END IF;
1477:
1478: ELSIF i.transaction_type = 'CORRECT' THEN -- <> CORRECT
1479: IF (l_debug = 1) THEN

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

1531: p_source_name => i.transaction_type,
1532: p_cost_group_id => i.cg_id
1533: );
1534:
1535: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1536: IF (l_debug = 1) THEN
1537: print_debug('Error while unpacking in txn_complete for correction OF ACCEPT/REJECT');
1538: END IF;
1539: RAISE fnd_api.g_exc_error; --return;

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

1535: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1536: IF (l_debug = 1) THEN
1537: print_debug('Error while unpacking in txn_complete for correction OF ACCEPT/REJECT');
1538: END IF;
1539: RAISE fnd_api.g_exc_error; --return;
1540: END IF;
1541:
1542: PackUnpack_Container(
1543: x_return_status => x_return_status,

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

1559: p_source_name => NULL,
1560: p_cost_group_id => NULL
1561: );
1562:
1563: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1564: IF (l_debug = 1) THEN
1565: print_debug('Error while packing in txn_complete for correction OF ACCEPT/REJECT');
1566: END IF;
1567: RAISE fnd_api.g_exc_error; --return;

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

1563: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1564: IF (l_debug = 1) THEN
1565: print_debug('Error while packing in txn_complete for correction OF ACCEPT/REJECT');
1566: END IF;
1567: RAISE fnd_api.g_exc_error; --return;
1568: END IF;
1569:
1570: -- Update the context for the pack lpn to 'resides in
1571: -- receiving' as packunpack api may have changed it to

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

1615: p_source_name => i.transaction_type,
1616: p_cost_group_id => i.cg_id
1617: );
1618:
1619: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1620: IF (l_debug = 1) THEN
1621: print_debug('Error in unpacking for Correct Txn = +ve Correct RTV/RTC or -ve on Receive Txns');
1622: END IF;
1623: RAISE fnd_api.g_exc_error; --return;

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

1619: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1620: IF (l_debug = 1) THEN
1621: print_debug('Error in unpacking for Correct Txn = +ve Correct RTV/RTC or -ve on Receive Txns');
1622: END IF;
1623: RAISE fnd_api.g_exc_error; --return;
1624: END IF;
1625:
1626: --ELSIF i.lpn_id IS NULL AND i.transfer_lpn_id IS NOT NULL THEN
1627: ELSIF (l_parent_transaction_type IN ('RETURN TO VENDOR','RETURN TO CUSTOMER')

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

1894: x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count,
1895: x_error_code => l_error_code
1896: );
1897:
1898: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1899: IF (l_debug = 1) THEN
1900: print_debug('TXN_COMPLETE: Error while calling query_reservations');
1901: END IF;
1902: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);

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

1899: IF (l_debug = 1) THEN
1900: print_debug('TXN_COMPLETE: Error while calling query_reservations');
1901: END IF;
1902: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);
1903: RAISE fnd_api.g_exc_error; --return;
1904: END IF;
1905:
1906: IF (l_debug = 1) THEN
1907: print_debug('TXN_COMPLETE: No. of reservation recs found:'||l_mtl_reservation_tbl_count);

Line 1926: p_init_msg_lst => FND_API.G_FALSE,

1922: print_debug('TXN_COMPLETE: Deleting the reservation...');
1923: END IF;
1924: INV_RESERVATION_PUB.DELETE_RESERVATION(
1925: p_api_version_number => 1.0,
1926: p_init_msg_lst => FND_API.G_FALSE,
1927: x_return_status => x_return_status,
1928: x_msg_count => x_msg_count,
1929: x_msg_data => x_msg_data,
1930: p_rsv_rec => l_res_rec_to_delete,

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

1929: x_msg_data => x_msg_data,
1930: p_rsv_rec => l_res_rec_to_delete,
1931: p_serial_number => l_dummy_sn
1932: );
1933: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1934: IF (l_debug = 1) THEN
1935: print_debug('TXN_COMPLETE: Error while deleting reservations');
1936: END IF;
1937: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);

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

1934: IF (l_debug = 1) THEN
1935: print_debug('TXN_COMPLETE: Error while deleting reservations');
1936: END IF;
1937: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);
1938: RAISE fnd_api.g_exc_error; --return;
1939: END IF;
1940: IF (l_debug = 1) THEN
1941: print_debug('TXN_COMPLETE: Deleted the reservation record successfully');
1942: END IF;

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

2139: p_source_header_id => NULL,
2140: p_source_name => NULL,
2141: P_COST_GROUP_ID => NULL);
2142:
2143: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2144: IF (l_debug = 1) THEN
2145: print_debug('Error in txn_complete while unpacking for txn failure');
2146: END IF;
2147: RAISE fnd_api.g_exc_error; --return; -- error while unpacking

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

2143: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2144: IF (l_debug = 1) THEN
2145: print_debug('Error in txn_complete while unpacking for txn failure');
2146: END IF;
2147: RAISE fnd_api.g_exc_error; --return; -- error while unpacking
2148: end if;
2149:
2150: END LOOP;
2151:

Line 2191: WHEN FND_API.g_exc_error THEN

2187: print_debug('Exiting txn_complete');
2188: END IF;
2189:
2190: EXCEPTION
2191: WHEN FND_API.g_exc_error THEN
2192: IF (l_debug = 1) THEN
2193: print_debug('txn_complete : execution error');
2194: END IF;
2195:

Line 2196: x_return_status := FND_API.G_RET_STS_ERROR;

2192: IF (l_debug = 1) THEN
2193: print_debug('txn_complete : execution error');
2194: END IF;
2195:
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2198: WHEN OTHERS THEN
2199: IF (l_debug = 1) THEN
2200: print_debug('In exception when others: ' || sqlerrm || ':' || sqlcode);

Line 2202: x_return_status := FND_API.G_RET_STS_ERROR;

2198: WHEN OTHERS THEN
2199: IF (l_debug = 1) THEN
2200: print_debug('In exception when others: ' || sqlerrm || ':' || sqlcode);
2201: END IF;
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2204: x_msg_data := x_msg_data||sqlerrm;
2205: END txn_complete;
2206:

Line 2353: x_return_status := FND_API.G_RET_STS_SUCCESS;

2349: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2350: BEGIN
2351:
2352: l_position := '0010';
2353: x_return_status := FND_API.G_RET_STS_SUCCESS;
2354: IF (l_debug = 1) THEN
2355: print_debug('Enter MARK_RETURNS');
2356: print_debug('p_serial_controlled => ' || p_serial_controlled);
2357: print_debug('p_lot_controlled => ' || p_lot_controlled);

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

2496: P_COST_GROUP_ID => l_cost_group_id
2497: );
2498: l_position := '0100';
2499:
2500: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2501: IF (l_debug = 1) THEN
2502: print_debug('Error in mark_returns while unpacking');
2503: END IF;
2504: RAISE fnd_api.g_exc_error; --return; -- error while unpacking

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

2500: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2501: IF (l_debug = 1) THEN
2502: print_debug('Error in mark_returns while unpacking');
2503: END IF;
2504: RAISE fnd_api.g_exc_error; --return; -- error while unpacking
2505: end if;
2506:
2507: PackUnpack_Container(
2508: x_return_status => x_return_status,

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

2524: p_source_name => p_ret_transaction_type,
2525: P_COST_GROUP_ID => l_cost_group_id
2526: );
2527:
2528: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2529: IF (l_debug = 1) THEN
2530: print_debug('Error in mark_returns while packing');
2531: END IF;
2532: RAISE fnd_api.g_exc_error; --return; -- error while packing

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

2528: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2529: IF (l_debug = 1) THEN
2530: print_debug('Error in mark_returns while packing');
2531: END IF;
2532: RAISE fnd_api.g_exc_error; --return; -- error while packing
2533: end if;
2534:
2535: END LOOP;
2536:

Line 2548: , p_validation_level => fnd_api.g_valid_level_none

2544:
2545: wms_container_pvt.Modify_LPN
2546: (
2547: p_api_version => 1.0
2548: , p_validation_level => fnd_api.g_valid_level_none
2549: , x_return_status => l_return_status
2550: , x_msg_count => l_msg_count
2551: , x_msg_data => l_msg_data
2552: , p_lpn => l_lpn_update

Line 2575: WHEN FND_API.g_exc_error THEN

2571: print_debug('Exit MARK_RETURNS');
2572: END IF;
2573:
2574: EXCEPTION
2575: WHEN FND_API.g_exc_error THEN
2576: IF (l_debug = 1) THEN
2577: print_debug('mark_returns : execution error');
2578: END IF;
2579:

Line 2580: x_return_status := FND_API.G_RET_STS_ERROR;

2576: IF (l_debug = 1) THEN
2577: print_debug('mark_returns : execution error');
2578: END IF;
2579:
2580: x_return_status := FND_API.G_RET_STS_ERROR;
2581: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2582: when others then
2583: IF (l_debug = 1) THEN
2584: print_debug('Error(' || l_position || '):' || sqlerrm);

Line 2586: x_return_status := FND_API.G_RET_STS_ERROR;

2582: when others then
2583: IF (l_debug = 1) THEN
2584: print_debug('Error(' || l_position || '):' || sqlerrm);
2585: END IF;
2586: x_return_status := FND_API.G_RET_STS_ERROR;
2587: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2588: x_msg_data := x_msg_data||sqlerrm;
2589: END MARK_RETURNS;
2590:

Line 2629: x_return_status := FND_API.G_RET_STS_SUCCESS;

2625: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2626: BEGIN
2627:
2628: l_position := '0010';
2629: x_return_status := FND_API.G_RET_STS_SUCCESS;
2630:
2631: /* FP-J Lot/Serial Support Enhancement
2632: * Read the currentand PO patch levels and set the flag (that would be used to
2633: * match the Lot Number and the LPN) accordingly

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

2739: p_source_name => p_ret_transaction_type,
2740: P_COST_GROUP_ID => NULL
2741: );
2742:
2743: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2744: IF (l_debug = 1) THEN
2745: print_debug('Error in PACK_INTO_RECEIVING while packing');
2746: END IF;
2747: RAISE fnd_api.g_exc_error; --return; -- error while packing

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

2743: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2744: IF (l_debug = 1) THEN
2745: print_debug('Error in PACK_INTO_RECEIVING while packing');
2746: END IF;
2747: RAISE fnd_api.g_exc_error; --return; -- error while packing
2748: end if;
2749:
2750: END LOOP;
2751:

Line 2768: WHEN FND_API.g_exc_error THEN

2764: END IF;
2765: END IF;--IF (l_wms_po_j_higher = FALSE) THEN
2766:
2767: EXCEPTION
2768: WHEN FND_API.g_exc_error THEN
2769: IF (l_debug = 1) THEN
2770: print_debug('maintain_move_orders : execution error');
2771: END IF;
2772:

Line 2773: x_return_status := FND_API.G_RET_STS_ERROR;

2769: IF (l_debug = 1) THEN
2770: print_debug('maintain_move_orders : execution error');
2771: END IF;
2772:
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2775: when others then
2776: x_return_status := FND_API.G_RET_STS_ERROR;
2777: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

Line 2776: x_return_status := FND_API.G_RET_STS_ERROR;

2772:
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2775: when others then
2776: x_return_status := FND_API.G_RET_STS_ERROR;
2777: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2778: x_msg_data := x_msg_data||sqlerrm;
2779: IF (l_debug = 1) THEN
2780: print_debug('Error(' || l_position || '):' || sqlerrm);

Line 2819: x_return_status := fnd_api.g_ret_sts_success;

2815: print_debug('p_txn_proc_mode =>' || p_txn_proc_mode);
2816: print_debug('p_group_id =>' || p_group_id);
2817: END IF;
2818:
2819: x_return_status := fnd_api.g_ret_sts_success;
2820:
2821: open c_ref for SELECT SOURCE_HEADER_ID
2822: FROM WMS_LPN_CONTENTS WLPNC
2823: WHERE WLPNC.ORGANIZATION_ID = p_org_id

Line 2876: WHEN fnd_api.g_exc_error THEN

2872: print_debug('END OF LOOP PROCESS WHOLE LPN RETURN - Serial Records');
2873: END IF;
2874:
2875: EXCEPTION
2876: WHEN fnd_api.g_exc_error THEN
2877:
2878: x_return_status := fnd_api.g_ret_sts_error;
2879: IF (l_debug = 1) THEN
2880: print_debug('x_return_status =>' || x_return_status);

Line 2878: x_return_status := fnd_api.g_ret_sts_error;

2874:
2875: EXCEPTION
2876: WHEN fnd_api.g_exc_error THEN
2877:
2878: x_return_status := fnd_api.g_ret_sts_error;
2879: IF (l_debug = 1) THEN
2880: print_debug('x_return_status =>' || x_return_status);
2881: END IF;
2882:

Line 2897: WHEN fnd_api.g_exc_unexpected_error THEN

2893: CLOSE c_ref_ser;
2894: END IF;
2895:
2896:
2897: WHEN fnd_api.g_exc_unexpected_error THEN
2898:
2899: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2900: IF (l_debug = 1) THEN
2901: print_debug('x_return_status =>' || x_return_status);

Line 2899: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2895:
2896:
2897: WHEN fnd_api.g_exc_unexpected_error THEN
2898:
2899: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2900: IF (l_debug = 1) THEN
2901: print_debug('x_return_status =>' || x_return_status);
2902: END IF;
2903:

Line 2920: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2916:
2917:
2918: WHEN others THEN
2919:
2920: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2921: IF (l_debug = 1) THEN
2922: print_debug('x_return_status =>' || x_return_status);
2923: END IF;
2924: --

Line 2980: x_return_status := fnd_api.g_ret_sts_success;

2976:
2977: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2978: BEGIN
2979:
2980: x_return_status := fnd_api.g_ret_sts_success;
2981:
2982: IF (l_debug = 1) THEN
2983: print_debug('Enter PROCESS_RETURNS');
2984: print_debug('Called PROCESS_RETURNS with the parameters');

Line 3077: WHEN fnd_api.g_exc_error THEN

3073: print_debug('END OF LOOP PROCESS RETURNS');
3074: END IF;
3075:
3076: EXCEPTION
3077: WHEN fnd_api.g_exc_error THEN
3078:
3079: x_return_status := fnd_api.g_ret_sts_error;
3080: IF (l_debug = 1) THEN
3081: print_debug('x_return_status =>' || x_return_status);

Line 3079: x_return_status := fnd_api.g_ret_sts_error;

3075:
3076: EXCEPTION
3077: WHEN fnd_api.g_exc_error THEN
3078:
3079: x_return_status := fnd_api.g_ret_sts_error;
3080: IF (l_debug = 1) THEN
3081: print_debug('x_return_status =>' || x_return_status);
3082: END IF;
3083:

Line 3095: WHEN fnd_api.g_exc_unexpected_error THEN

3091: CLOSE c_ref;
3092: END IF;
3093:
3094:
3095: WHEN fnd_api.g_exc_unexpected_error THEN
3096:
3097: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3098: IF (l_debug = 1) THEN
3099: print_debug('x_return_status =>' || x_return_status);

Line 3097: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3093:
3094:
3095: WHEN fnd_api.g_exc_unexpected_error THEN
3096:
3097: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3098: IF (l_debug = 1) THEN
3099: print_debug('x_return_status =>' || x_return_status);
3100: END IF;
3101:

Line 3115: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3111:
3112:
3113: WHEN others THEN
3114:
3115: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3116: IF (l_debug = 1) THEN
3117: print_debug('x_return_status =>' || x_return_status);
3118: END IF;
3119: --

Line 3302: x_return_status := fnd_api.g_ret_sts_success;

3298: l_wms_po_j_higher BOOLEAN;
3299:
3300: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3301: BEGIN
3302: x_return_status := fnd_api.g_ret_sts_success;
3303:
3304: IF (l_debug = 1) THEN
3305: print_debug('CREATE_RETURN_RESV:Interface Transaction ID:'||p_intf_txn_id,1);
3306: END IF;

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

3398: x_mtl_reservation_tbl_count => l_upd_reservation_tbl_cnt,
3399: x_error_code => l_error_code
3400: );
3401:
3402: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3403: IF (l_debug = 1) THEN
3404: print_debug('CREATE_RETURN_RESV:Error while calling query_reservations');
3405: END IF;
3406: RAISE FND_API.G_EXC_ERROR;

Line 3406: RAISE FND_API.G_EXC_ERROR;

3402: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3403: IF (l_debug = 1) THEN
3404: print_debug('CREATE_RETURN_RESV:Error while calling query_reservations');
3405: END IF;
3406: RAISE FND_API.G_EXC_ERROR;
3407: END IF;
3408:
3409: IF (l_debug = 1) THEN
3410: print_debug('CREATE_RETURN_RESV:There are ' || l_upd_reservation_tbl_cnt || ' reservation records');

Line 3442: RAISE fnd_api.g_exc_error;

3438: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3439: fnd_message.set_token('UOM', l_item_primary_uom);
3440: fnd_message.set_token('ROUTINE', 'Create Reservation');
3441: fnd_msg_pub.ADD;
3442: RAISE fnd_api.g_exc_error;
3443: END IF;
3444: ELSE --IF l_uom_code <> l_item_primary_uom THEN
3445: l_primary_res_qty := p_reservation_qty;
3446: END IF; --IF l_uom_code <> l_item_primary_uom THEN

Line 3462: p_init_msg_lst => FND_API.G_FALSE,

3458:
3459: --Update the reservation record with the new quantity
3460: INV_RESERVATION_PUB.UPDATE_RESERVATION(
3461: p_api_version_number => 1.0,
3462: p_init_msg_lst => FND_API.G_FALSE,
3463: x_return_status => x_return_status,
3464: x_msg_count => x_msg_count,
3465: x_msg_data => x_msg_data,
3466: p_original_rsv_rec => l_upd_reservation_tbl(l_count),

Line 3470: p_validation_flag => FND_API.G_TRUE);

3466: p_original_rsv_rec => l_upd_reservation_tbl(l_count),
3467: p_to_rsv_rec => l_upd_reservation_record,
3468: p_original_serial_number => l_dummy_sn,
3469: p_to_serial_number => l_dummy_sn,
3470: p_validation_flag => FND_API.G_TRUE);
3471:
3472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3473: IF (l_debug = 1) THEN
3474: print_debug('CREATE_RETURN_RESV:error in update_reservation');

Line 3472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3468: p_original_serial_number => l_dummy_sn,
3469: p_to_serial_number => l_dummy_sn,
3470: p_validation_flag => FND_API.G_TRUE);
3471:
3472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3473: IF (l_debug = 1) THEN
3474: print_debug('CREATE_RETURN_RESV:error in update_reservation');
3475: END IF;
3476: FND_MESSAGE.SET_NAME('INB', 'INV_UPD_RSV_FAILED');

Line 3478: RAISE fnd_api.g_exc_error;

3474: print_debug('CREATE_RETURN_RESV:error in update_reservation');
3475: END IF;
3476: FND_MESSAGE.SET_NAME('INB', 'INV_UPD_RSV_FAILED');
3477: FND_MSG_PUB.ADD;
3478: RAISE fnd_api.g_exc_error;
3479: END IF;
3480: IF (l_debug = 1) THEN
3481: print_debug('CREATE_RETURN_RESV:successfully updated a reservation record: ' ||sql%rowcount);
3482: END IF;

Line 3515: RAISE fnd_api.g_exc_error;

3511: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3512: fnd_message.set_token('UOM', l_item_primary_uom);
3513: fnd_message.set_token('ROUTINE', 'Create Reservation');
3514: fnd_msg_pub.add;
3515: RAISE fnd_api.g_exc_error;
3516: END IF;
3517: ELSE --IF l_uom_code <> l_item_primary_uom THEN
3518: l_primary_res_qty := p_reservation_qty;
3519: END IF; --IF l_uom_code <> l_item_primary_uom THEN

Line 3598: p_init_msg_lst => FND_API.G_FALSE,

3594: x_serial_number => l_dummy_sn,
3595: x_quantity_reserved => l_quantity_reserved,
3596: x_reservation_id => l_reservation_id,
3597: p_api_version_number => 1.0,
3598: p_init_msg_lst => FND_API.G_FALSE,
3599: p_rsv_rec => l_reservation_record,
3600: p_partial_reservation_flag => FND_API.G_TRUE,
3601: p_force_reservation_flag => FND_API.G_TRUE,
3602: p_serial_number => l_dummy_sn,

Line 3600: p_partial_reservation_flag => FND_API.G_TRUE,

3596: x_reservation_id => l_reservation_id,
3597: p_api_version_number => 1.0,
3598: p_init_msg_lst => FND_API.G_FALSE,
3599: p_rsv_rec => l_reservation_record,
3600: p_partial_reservation_flag => FND_API.G_TRUE,
3601: p_force_reservation_flag => FND_API.G_TRUE,
3602: p_serial_number => l_dummy_sn,
3603: p_validation_flag => FND_API.G_TRUE);
3604:

Line 3601: p_force_reservation_flag => FND_API.G_TRUE,

3597: p_api_version_number => 1.0,
3598: p_init_msg_lst => FND_API.G_FALSE,
3599: p_rsv_rec => l_reservation_record,
3600: p_partial_reservation_flag => FND_API.G_TRUE,
3601: p_force_reservation_flag => FND_API.G_TRUE,
3602: p_serial_number => l_dummy_sn,
3603: p_validation_flag => FND_API.G_TRUE);
3604:
3605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3603: p_validation_flag => FND_API.G_TRUE);

3599: p_rsv_rec => l_reservation_record,
3600: p_partial_reservation_flag => FND_API.G_TRUE,
3601: p_force_reservation_flag => FND_API.G_TRUE,
3602: p_serial_number => l_dummy_sn,
3603: p_validation_flag => FND_API.G_TRUE);
3604:
3605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3606: IF (l_debug = 1) THEN
3607: print_debug('CREATE_RETURN_RESV:error creating reservation: status:' || x_return_status || 'mess:' || sqlerrm);

Line 3605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3601: p_force_reservation_flag => FND_API.G_TRUE,
3602: p_serial_number => l_dummy_sn,
3603: p_validation_flag => FND_API.G_TRUE);
3604:
3605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3606: IF (l_debug = 1) THEN
3607: print_debug('CREATE_RETURN_RESV:error creating reservation: status:' || x_return_status || 'mess:' || sqlerrm);
3608: END IF;
3609: RAISE FND_API.G_EXC_ERROR;

Line 3609: RAISE FND_API.G_EXC_ERROR;

3605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3606: IF (l_debug = 1) THEN
3607: print_debug('CREATE_RETURN_RESV:error creating reservation: status:' || x_return_status || 'mess:' || sqlerrm);
3608: END IF;
3609: RAISE FND_API.G_EXC_ERROR;
3610: END IF;
3611: IF (l_debug = 1) THEN
3612: print_debug('CREATE_RETURN_RESV:Reservation created successfully. Reservation Id: ' || l_reservation_id || ' . Quantity Reserved: ' || l_quantity_reserved);
3613: END IF;

Line 3628: WHEN fnd_api.g_exc_error THEN

3624: CLOSE c_lots_old;
3625: END IF;
3626:
3627: EXCEPTION
3628: WHEN fnd_api.g_exc_error THEN
3629: x_return_status := fnd_api.g_ret_sts_error;
3630: fnd_msg_pub.count_and_get
3631: ( p_count => x_msg_count,
3632: p_data => x_msg_data

Line 3629: x_return_status := fnd_api.g_ret_sts_error;

3625: END IF;
3626:
3627: EXCEPTION
3628: WHEN fnd_api.g_exc_error THEN
3629: x_return_status := fnd_api.g_ret_sts_error;
3630: fnd_msg_pub.count_and_get
3631: ( p_count => x_msg_count,
3632: p_data => x_msg_data
3633: );

Line 3634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3630: fnd_msg_pub.count_and_get
3631: ( p_count => x_msg_count,
3632: p_data => x_msg_data
3633: );
3634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3635: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3636: IF (l_debug = 1) THEN
3637: print_debug('unxp:' || sqlerrm);
3638: END IF;

Line 3635: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3631: ( p_count => x_msg_count,
3632: p_data => x_msg_data
3633: );
3634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3635: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3636: IF (l_debug = 1) THEN
3637: print_debug('unxp:' || sqlerrm);
3638: END IF;
3639: fnd_msg_pub.count_and_get

Line 3644: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3640: ( p_count => x_msg_count,
3641: p_data => x_msg_data
3642: );
3643: WHEN OTHERS THEN
3644: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3645: fnd_msg_pub.count_and_get
3646: ( p_count => x_msg_count,
3647: p_data => x_msg_data
3648: );