DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_INTERFACE

Line 463: l_detail_attributes wsh_interface.ChangedAttributeTabType;

459: l_lot_number VARCHAR2(80);
460: l_serial_number VARCHAR2(30);
461: l_num_serial_record NUMBER := 0;
462:
463: l_detail_attributes wsh_interface.ChangedAttributeTabType;
464: l_InvPCInRecType wsh_integration.InvPCInRecType;
465: l_return_status VARCHAR2(1);
466: l_msg_count NUMBER;
467: l_msg_data VARCHAR2(2000);

Line 510: --Passing picked_quantity also because wsh_interface.update_shipping_attributes

506:
507: l_detail_attributes(1).action_flag := 'U';
508: l_detail_attributes(1).delivery_detail_id :=
509: p_delivery_detail_id;
510: --Passing picked_quantity also because wsh_interface.update_shipping_attributes
511: --will null it out if we do not
512: l_detail_attributes(1).picked_quantity := l_picked_quantity;
513:
514: debug('About to call wsh_interface.update_shipping_attributes',

Line 514: debug('About to call wsh_interface.update_shipping_attributes',

510: --Passing picked_quantity also because wsh_interface.update_shipping_attributes
511: --will null it out if we do not
512: l_detail_attributes(1).picked_quantity := l_picked_quantity;
513:
514: debug('About to call wsh_interface.update_shipping_attributes',
515: 'GET_DELIVERY_LINE_SERIAL_INFO');
516: debug('picked_quantity: ' || l_picked_quantity,'GET_DELIVERY_LINE_SERIAL_INFO');
517:
518: wsh_interface.update_shipping_attributes

Line 518: wsh_interface.update_shipping_attributes

514: debug('About to call wsh_interface.update_shipping_attributes',
515: 'GET_DELIVERY_LINE_SERIAL_INFO');
516: debug('picked_quantity: ' || l_picked_quantity,'GET_DELIVERY_LINE_SERIAL_INFO');
517:
518: wsh_interface.update_shipping_attributes
519: (x_return_status => l_return_status,
520: p_changed_attributes => l_detail_attributes,
521: p_source_code => 'INV');
522:

Line 524: debug('wsh_interface.update_shipping_attributes failed'

520: p_changed_attributes => l_detail_attributes,
521: p_source_code => 'INV');
522:
523: IF l_return_status IN (G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR) THEN
524: debug('wsh_interface.update_shipping_attributes failed'
525: || ' with status: ' || l_return_status,'GET_DELIVERY_LINE_SERIAL_INFO');
526: --check where to handle this error
527: RAISE fnd_api.g_exc_unexpected_error;
528: END IF;

Line 2362: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

2358:
2359: l_msg_count NUMBER;
2360:
2361: l_wms_org_flag BOOLEAN;
2362: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
2363: l_delivery_id_tab wsh_util_core.id_tab_type;
2364: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2365:
2366: --Added for Bug 14696492

Line 2364: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

2360:
2361: l_wms_org_flag BOOLEAN;
2362: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
2363: l_delivery_id_tab wsh_util_core.id_tab_type;
2364: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2365:
2366: --Added for Bug 14696492
2367: CURSOR get_dlvy_trip(p_delivery_id NUMBER) IS
2368: SELECT wts.trip_id, wt.name

Line 2507: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;

2503:
2504: IF (NOT l_wms_org_flag AND g_inv_current_release_level >= g_j_release_level)
2505: OR (l_wms_org_flag AND g_wms_current_release_level >= g_j_release_level) THEN
2506: l_action_prms.caller := 'WMS_DLMG';
2507: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
2508: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
2509:
2510: l_delivery_id_tab(1) := p_delivery_id;
2511:

Line 2512: wsh_interface_ext_grp.Delivery_Action

2508: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
2509:
2510: l_delivery_id_tab(1) := p_delivery_id;
2511:
2512: wsh_interface_ext_grp.Delivery_Action
2513: (p_api_version_number => 1.0,
2514: p_init_msg_list => fnd_api.g_false,
2515: p_commit => fnd_api.g_false,
2516: p_action_prms => l_action_prms,

Line 2754: l_detail_attributes wsh_interface.ChangedAttributeTabType;

2750: l_delivery_id NUMBER;
2751: l_delay_quantity NUMBER;
2752:
2753:
2754: l_detail_attributes wsh_interface.ChangedAttributeTabType;
2755: l_InvPCInRecType wsh_integration.InvPCInRecType;
2756: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2757: BEGIN
2758: IF l_debug = 1 THEN

Line 2839: wsh_interface.update_shipping_attributes

2835: l_detail_attributes(1).shipped_quantity := 0;
2836: l_detail_attributes(1).delivery_detail_id := l_new_delivery_line_id;
2837: l_detail_attributes(1).action_flag := 'U';
2838:
2839: wsh_interface.update_shipping_attributes
2840: (x_return_status => l_return_status,
2841: p_changed_attributes => l_detail_attributes,
2842: p_source_code => 'INV');
2843:

Line 2846: debug('wsh_interface.update_shipping_attributes failed'

2842: p_source_code => 'INV');
2843:
2844: IF l_return_status IN (G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR) THEN
2845: IF l_debug = 1 THEN
2846: debug('wsh_interface.update_shipping_attributes failed'
2847: || ' with status: ' || l_return_status,'INV_SPLIT_DELIVERY_LINE');
2848: END IF;
2849: --check where to handle this error
2850: RAISE fnd_api.g_exc_unexpected_error;

Line 2895: l_detail_attributes wsh_interface.ChangedAttributeTabType;

2891: l_delivery_id NUMBER;
2892: l_delay_quantity NUMBER;
2893:
2894:
2895: l_detail_attributes wsh_interface.ChangedAttributeTabType;
2896: l_InvPCInRecType wsh_integration.InvPCInRecType;
2897: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2898:
2899: --Bug No 3952081

Line 3007: wsh_interface.update_shipping_attributes

3003: l_detail_attributes(1).shipped_quantity := 0;
3004: l_detail_attributes(1).delivery_detail_id := l_new_delivery_line_id;
3005: l_detail_attributes(1).action_flag := 'U';
3006:
3007: wsh_interface.update_shipping_attributes
3008: (x_return_status => l_return_status,
3009: p_changed_attributes => l_detail_attributes,
3010: p_source_code => 'INV');
3011:

Line 3014: debug('wsh_interface.update_shipping_attributes failed'

3010: p_source_code => 'INV');
3011:
3012: IF l_return_status IN (G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR) THEN
3013: IF l_debug = 1 THEN
3014: debug('wsh_interface.update_shipping_attributes failed'
3015: || ' with status: ' || l_return_status,'INV_SPLIT_DELIVERY_LINE');
3016: END IF;
3017: --check where to handle this error
3018: RAISE fnd_api.g_exc_unexpected_error;