DBA Data[Home] [Help]

APPS.WMS_SHIPPING_INTERFACE_GRP dependencies on FND_API

Line 7: g_ret_status_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_SHIPPING_INTERFACE_GRP';
5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSGINTB.pls 120.9.12020000.2 2012/09/20 15:55:59 abasheer ship $';
6: g_debug_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7: g_ret_status_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
8: g_ret_status_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
9: g_ret_status_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
10:
11: G_WMS_RELEASE_LEVEL CONSTANT NUMBER := WMS_CONTROL.GET_CURRENT_RELEASE_LEVEL;

Line 8: g_ret_status_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_SHIPPING_INTERFACE_GRP';
5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSGINTB.pls 120.9.12020000.2 2012/09/20 15:55:59 abasheer ship $';
6: g_debug_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7: g_ret_status_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
8: g_ret_status_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
9: g_ret_status_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
10:
11: G_WMS_RELEASE_LEVEL CONSTANT NUMBER := WMS_CONTROL.GET_CURRENT_RELEASE_LEVEL;
12: G_J_RELEASE_LEVEL CONSTANT NUMBER := INV_RELEASE.G_J_RELEASE_LEVEL;

Line 9: g_ret_status_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;

5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSGINTB.pls 120.9.12020000.2 2012/09/20 15:55:59 abasheer ship $';
6: g_debug_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7: g_ret_status_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
8: g_ret_status_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
9: g_ret_status_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
10:
11: G_WMS_RELEASE_LEVEL CONSTANT NUMBER := WMS_CONTROL.GET_CURRENT_RELEASE_LEVEL;
12: G_J_RELEASE_LEVEL CONSTANT NUMBER := INV_RELEASE.G_J_RELEASE_LEVEL;
13:

Line 309: IF NOT FND_API.compatible_api_call(l_api_version,

305: l_pricing_ind VARCHAR2(30);
306: l_tolerance NUMBER;
307: l_source_type_id NUMBER;
308: BEGIN
309: IF NOT FND_API.compatible_api_call(l_api_version,
310: p_api_version,
311: l_procname,
312: G_PKG_NAME) THEN
313: RAISE g_exc_unexpected_error;

Line 317: IF fnd_api.to_boolean(p_init_msg_list) THEN

313: RAISE g_exc_unexpected_error;
314: END IF;
315:
316:
317: IF fnd_api.to_boolean(p_init_msg_list) THEN
318: fnd_msg_pub.initialize;
319: END IF;
320:
321: x_return_status := fnd_api.g_ret_sts_success;

Line 321: x_return_status := fnd_api.g_ret_sts_success;

317: IF fnd_api.to_boolean(p_init_msg_list) THEN
318: fnd_msg_pub.initialize;
319: END IF;
320:
321: x_return_status := fnd_api.g_ret_sts_success;
322:
323: print_debug(l_procname || ' Entered ' || g_pkg_version);
324: print_debug('action='||p_action||' deltblcnt='||p_delivery_detail_tbl.COUNT|| ' relvl='||G_WMS_RELEASE_LEVEL);
325:

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

380: , p_quantity => p_delivery_detail_tbl(i).picked_quantity
381: , p_uom_code => p_delivery_detail_tbl(i).requested_quantity_uom
382: , p_secondary_quantity => p_delivery_detail_tbl(i).picked_quantity2 );
383:
384: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
385: print_debug('Check_Secondary_Qty_Tolerance failed');
386:
387: fnd_message.set_name('WMS','WMS_CATCH_WT_API_ERR' );
388: fnd_msg_pub.add;

Line 389: raise fnd_api.g_exc_unexpected_error;

385: print_debug('Check_Secondary_Qty_Tolerance failed');
386:
387: fnd_message.set_name('WMS','WMS_CATCH_WT_API_ERR' );
388: fnd_msg_pub.add;
389: raise fnd_api.g_exc_unexpected_error;
390: END IF;
391:
392: IF ( l_tolerance <> 0 ) THEN
393: p_delivery_detail_tbl(i).return_status := 'E';

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

411: , x_ont_pricing_qty_source => l_pricing_ind
412: , x_secondary_uom_code => p_delivery_detail_tbl(i).requested_quantity_uom2
413: , x_secondary_quantity => p_delivery_detail_tbl(i).picked_quantity2 );
414:
415: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
416: print_debug('Get_Default_Secondary_Quantity failed priceind='||l_pricing_ind||' msg='|| x_msg_data||' cnt='||x_msg_count);
417:
418: IF ( l_pricing_ind = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
419: p_delivery_detail_tbl(i).return_status := 'E';

Line 430: x_return_status := fnd_api.g_ret_sts_success;

426: ELSE
427: p_delivery_detail_tbl(i).r_message_code := fnd_msg_pub.get(1,'F');
428: END IF;
429: -- do not need to fail batch reset to success
430: x_return_status := fnd_api.g_ret_sts_success;
431: ELSE -- General failure fail batch
432: fnd_message.set_name('WMS','WMS_CATCH_WT_API_ERR');
433: fnd_msg_pub.add;
434: raise fnd_api.g_exc_unexpected_error;

Line 434: raise fnd_api.g_exc_unexpected_error;

430: x_return_status := fnd_api.g_ret_sts_success;
431: ELSE -- General failure fail batch
432: fnd_message.set_name('WMS','WMS_CATCH_WT_API_ERR');
433: fnd_msg_pub.add;
434: raise fnd_api.g_exc_unexpected_error;
435: END IF;
436: ELSIF ( l_pricing_ind = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
437: IF ( p_delivery_detail_tbl(i).picked_quantity2 IS NULL OR
438: p_delivery_detail_tbl(i).requested_quantity_uom2 IS NULL ) THEN

Line 467: , p_init_msg_list => fnd_api.g_false

463: print_debug('Calling Create_Update_Delivery_Detail deldet count='||l_shipping_attr.COUNT );
464:
465: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (
466: p_api_version_number => 1.0
467: , p_init_msg_list => fnd_api.g_false
468: , p_commit => fnd_api.g_false
469: , x_return_status => x_return_status
470: , x_msg_count => x_msg_count
471: , x_msg_data => x_msg_data

Line 468: , p_commit => fnd_api.g_false

464:
465: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (
466: p_api_version_number => 1.0
467: , p_init_msg_list => fnd_api.g_false
468: , p_commit => fnd_api.g_false
469: , x_return_status => x_return_status
470: , x_msg_count => x_msg_count
471: , x_msg_data => x_msg_data
472: , p_detail_info_tab => l_shipping_attr

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

472: , p_detail_info_tab => l_shipping_attr
473: , p_IN_rec => l_shipping_in_rec
474: , x_OUT_rec => l_shipping_out_rec );
475:
476: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
477: wsh_util_core.get_messages('Y', x_msg_data, x_msg_details, x_msg_count);
478:
479: if x_msg_count > 1 then
480: x_msg_data := x_msg_data || x_msg_details;

Line 490: raise fnd_api.g_exc_unexpected_error;

486: print_debug('Error Msg: ' || x_msg_data);
487: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
488: FND_MESSAGE.SET_TOKEN('MSG1', x_msg_data);
489: FND_MSG_PUB.ADD;
490: raise fnd_api.g_exc_unexpected_error;
491: END IF;
492: END IF;
493: END IF;
494:

Line 563: IF NOT fnd_api.compatible_api_call(l_api_version

559: IF wms_globals.g_ship_confirm_method = 'DIRECT' THEN
560: RETURN;
561: END IF;
562:
563: IF NOT fnd_api.compatible_api_call(l_api_version
564: ,p_api_version
565: ,l_procname
566: ,g_pkg_name) THEN
567: IF g_debug_on = 1 THEN

Line 581: IF fnd_api.to_boolean(p_init_msg_list) THEN

577: END IF;
578: RAISE g_exc_unexpected_error;
579: END IF;
580:
581: IF fnd_api.to_boolean(p_init_msg_list) THEN
582: fnd_msg_pub.initialize;
583: END IF;
584:
585: IF g_debug_on = 1 THEN

Line 738: IF NOT fnd_api.compatible_api_call(1.0

734: x_msg_count := 0;
735: x_msg_data := '';
736:
737: IF p_action = wms_shipping_interface_grp.g_action_update THEN
738: IF NOT fnd_api.compatible_api_call(1.0
739: ,p_api_version
740: ,'PROCESS_SERIAL_NUMBER'
741: ,g_pkg_name) THEN
742: print_debug('PROCESS_SERIAL_NUMBER: Incompatible API call');

Line 931: x_return_status:=fnd_api.g_ret_sts_success;

927: and wwl.organization_id = wdd.organization_id
928: and nvl(remove_from_wave_flag, 'N') <> 'Y';
929:
930: begin
931: x_return_status:=fnd_api.g_ret_sts_success;
932:
933: for l_split_from_wave_line in c_orig_wave_lines loop
934:
935: --keep as much xdock qty on original wave line; only put some on new line if old line requestd quantity is less than old line xdock quantity