DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_INTERFACE

Line 684: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

680: l_delivery_status_code VARCHAR2(2);
681:
682: l_msg_count NUMBER;
683: l_msg_data VARCHAR2(2000);
684: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
685: l_delivery_id_tab wsh_util_core.id_tab_type;
686: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
687:
688: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 686: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

682: l_msg_count NUMBER;
683: l_msg_data VARCHAR2(2000);
684: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
685: l_delivery_id_tab wsh_util_core.id_tab_type;
686: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
687:
688: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
689: l_debug number;
690: BEGIN

Line 875: debug( 'Delivery merge call..wsh_interface_ext_grp.delivery_action ',

871: ---
872: IF g_wms_current_release_level >= g_j_release_level AND
873: l_delivery_id IS NOT NULL THEN -- mrana: 8/30/06: added this condition
874: IF (l_debug = 1) THEN
875: debug( 'Delivery merge call..wsh_interface_ext_grp.delivery_action ',
876: 'Populate_WSTT');
877: END IF;
878: l_action_prms.caller := 'WMS_DLMG';
879: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;

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

875: debug( 'Delivery merge call..wsh_interface_ext_grp.delivery_action ',
876: 'Populate_WSTT');
877: END IF;
878: l_action_prms.caller := 'WMS_DLMG';
879: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
880: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
881:
882: l_delivery_id_tab(1) := l_delivery_id;
883:

Line 884: wsh_interface_ext_grp.delivery_action

880: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
881:
882: l_delivery_id_tab(1) := l_delivery_id;
883:
884: wsh_interface_ext_grp.delivery_action
885: (p_api_version_number => 1.0,
886: p_init_msg_list => fnd_api.g_false,
887: p_commit => fnd_api.g_false,
888: p_action_prms => l_action_prms,

Line 1254: l_detail_attributes wsh_interface.ChangedAttributeTabType;

1250: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
1251: l_lot_number VARCHAR2(80);
1252: l_picked_quantity NUMBER := 0;
1253:
1254: l_detail_attributes wsh_interface.ChangedAttributeTabType;
1255: l_InvPCInRecType wsh_integration.InvPCInRecType;
1256: l_return_status VARCHAR2(1);
1257: l_msg_count NUMBER;
1258: l_msg_data VARCHAR2(2000);

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

1329:
1330: l_detail_attributes(1).delivery_detail_id :=
1331: l_delivery_detail_id;
1332: l_detail_attributes(1).action_flag := 'U';
1333: --Passing picked_quantity also because wsh_interface.update_shipping_attributes
1334: --will null it out if we do not
1335: l_detail_attributes(1).picked_quantity := l_picked_quantity;
1336:
1337: debug('About to call wsh_interface.update_shipping_attributes','nested_serial_check');

Line 1337: debug('About to call wsh_interface.update_shipping_attributes','nested_serial_check');

1333: --Passing picked_quantity also because wsh_interface.update_shipping_attributes
1334: --will null it out if we do not
1335: l_detail_attributes(1).picked_quantity := l_picked_quantity;
1336:
1337: debug('About to call wsh_interface.update_shipping_attributes','nested_serial_check');
1338: debug('delivery_detail_id : ' ||
1339: l_detail_attributes(1).delivery_detail_id,
1340: 'nested_serial_check');
1341:

Line 1343: wsh_interface.update_shipping_attributes

1339: l_detail_attributes(1).delivery_detail_id,
1340: 'nested_serial_check');
1341:
1342: --update transaction_temp_id in WDD
1343: wsh_interface.update_shipping_attributes
1344: (x_return_status => l_return_status,
1345: p_changed_attributes => l_detail_attributes,
1346: p_source_code => 'INV');
1347: --\Shipping API cleanup

Line 1349: debug('wsh_interface.update_shipping_attributes failed'

1345: p_changed_attributes => l_detail_attributes,
1346: p_source_code => 'INV');
1347: --\Shipping API cleanup
1348: IF l_return_status IN (G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR) THEN
1349: debug('wsh_interface.update_shipping_attributes failed'
1350: || ' with status: ' || l_return_status,'nested_serial_check');
1351: --check where to handle this error
1352: RAISE fnd_api.g_exc_unexpected_error;
1353: END IF;

Line 2109: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype; --g-log

2105: l_delivery_id NUMBER;
2106: l_dock_appoint_flag VARCHAR2(1);
2107: temp_val NUMBER;
2108:
2109: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype; --g-log
2110: l_delivery_id_tab wsh_util_core.id_tab_type;
2111: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2112: l_msg_count NUMBER;
2113: l_msg_data VARCHAR2(2000);

Line 2111: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

2107: temp_val NUMBER;
2108:
2109: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype; --g-log
2110: l_delivery_id_tab wsh_util_core.id_tab_type;
2111: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2112: l_msg_count NUMBER;
2113: l_msg_data VARCHAR2(2000);
2114:
2115: /**********************************

Line 2301: -- Hence there is no call to WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM().

2297:
2298: --Important Note: Irrespective of the severity level of 'CR' exception for the delivery just
2299: --created, we have to mark the delivery to ignore_for_planning so that the
2300: --transaction goes through fine.
2301: -- Hence there is no call to WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM().
2302: -- Here delivery was created in the backend for the line that the use
2303: -- chose to ship confirm. it IS ALL happening in the backend.
2304:
2305:

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

2308: debug('ignore_for_planning of WDD is N ', 'LPN_CHECK');
2309: END IF;
2310: l_delivery_id_tab(1) := l_delivery_id;
2311: l_action_prms.caller := 'WMS_LPNSHP';
2312: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
2313: l_action_prms.action_code := 'IGNORE_PLAN';
2314: wsh_interface_ext_grp.delivery_action
2315: (p_api_version_number => 1.0,
2316: p_init_msg_list => fnd_api.g_false,

Line 2314: wsh_interface_ext_grp.delivery_action

2310: l_delivery_id_tab(1) := l_delivery_id;
2311: l_action_prms.caller := 'WMS_LPNSHP';
2312: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
2313: l_action_prms.action_code := 'IGNORE_PLAN';
2314: wsh_interface_ext_grp.delivery_action
2315: (p_api_version_number => 1.0,
2316: p_init_msg_list => fnd_api.g_false,
2317: p_commit => fnd_api.g_false,
2318: p_action_prms => l_action_prms,

Line 2326: debug('Called wsh_interface_ext_grp.delivery_action with action_code IGNORE_PLAN and return status: ' || l_return_status, 'LPN_CHECK');

2322: x_msg_count => l_msg_count,
2323: x_msg_data => l_msg_data);
2324:
2325: IF (l_debug = 1) THEN
2326: debug('Called wsh_interface_ext_grp.delivery_action with action_code IGNORE_PLAN and return status: ' || l_return_status, 'LPN_CHECK');
2327: END IF;
2328: IF l_return_status = fnd_api.g_ret_sts_error THEN
2329: x_error_code := 7;
2330: return;

Line 5169: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

5165: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5166: l_debug number;
5167:
5168: /* Bug: 5585359: 10/09/06 Start*/
5169: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5170: l_delivery_id_tab wsh_util_core.id_tab_type;
5171: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5172: l_planned_flag VARCHAR2(1);
5173: /* Bug: 5585359: 10/09/06 - End*/

Line 5171: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

5167:
5168: /* Bug: 5585359: 10/09/06 Start*/
5169: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5170: l_delivery_id_tab wsh_util_core.id_tab_type;
5171: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5172: l_planned_flag VARCHAR2(1);
5173: /* Bug: 5585359: 10/09/06 - End*/
5174:
5175: l_delivery_details wsh_delivery_details_pub.id_tab_type;

Line 5246: wsh_interface_ext_grp.delivery_action

5242:
5243: IF l_debug = 1 THEN
5244: DEBUG('Unfirm delivery for unassignment','UNASSIGN_DELIVERY_LINE');
5245: END IF;
5246: wsh_interface_ext_grp.delivery_action
5247: (p_api_version_number => 1.0,
5248: p_init_msg_list => fnd_api.g_false,
5249: p_commit => fnd_api.g_false,
5250: p_action_prms => l_action_prms,

Line 5300: wsh_interface_ext_grp.delivery_action

5296: l_action_prms.action_code := 'PLAN';
5297: IF l_debug = 1 THEN
5298: DEBUG('firm delivery after unassignment','UNASSIGN_DELIVERY_LINE');
5299: END IF;
5300: wsh_interface_ext_grp.delivery_action
5301: (p_api_version_number => 1.0,
5302: p_init_msg_list => fnd_api.g_false,
5303: p_commit => p_commit_flag,
5304: p_action_prms => l_action_prms,

Line 5344: l_shipping_attr_tab WSH_INTERFACE.ChangedAttributeTabType;

5340: l_oe_order_line_id NUMBER;
5341: l_released_status VARCHAR2(1);
5342: l_organization_id NUMBER;
5343:
5344: l_shipping_attr_tab WSH_INTERFACE.ChangedAttributeTabType;
5345: l_wdd_counter NUMBER := 1;
5346:
5347: l_progress VARCHAR2(10);
5348: l_return_status VARCHAR2(1);

Line 5456: WSH_INTERFACE.Update_Shipping_Attributes

5452: END IF;
5453:
5454: l_progress := '50';
5455:
5456: WSH_INTERFACE.Update_Shipping_Attributes
5457: (p_source_code => 'INV',
5458: p_changed_attributes => l_shipping_attr_tab,
5459: x_return_status => l_return_status
5460: );

Line 5463: debug('update_wdd_loc_by_lpn 25 - WSH_INTERFACE.Update_Shipping_Attributes returns : '

5459: x_return_status => l_return_status
5460: );
5461:
5462: IF (l_debug = 1) THEN
5463: debug('update_wdd_loc_by_lpn 25 - WSH_INTERFACE.Update_Shipping_Attributes returns : '
5464: ||l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');
5465: END IF;
5466:
5467: IF l_return_status = FND_API.G_RET_STS_ERROR THEN