DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_INTERFACE

Line 631: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

627: l_delivery_status_code VARCHAR2(2);
628:
629: l_msg_count NUMBER;
630: l_msg_data VARCHAR2(2000);
631: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
632: l_delivery_id_tab wsh_util_core.id_tab_type;
633: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
634:
635: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 633: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

629: l_msg_count NUMBER;
630: l_msg_data VARCHAR2(2000);
631: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
632: l_delivery_id_tab wsh_util_core.id_tab_type;
633: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
634:
635: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
636: l_debug number;
637: BEGIN

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

818: ---
819: IF g_wms_current_release_level >= g_j_release_level AND
820: l_delivery_id IS NOT NULL THEN -- mrana: 8/30/06: added this condition
821: IF (l_debug = 1) THEN
822: debug( 'Delivery merge call..wsh_interface_ext_grp.delivery_action ',
823: 'Populate_WSTT');
824: END IF;
825: l_action_prms.caller := 'WMS_DLMG';
826: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;

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

822: debug( 'Delivery merge call..wsh_interface_ext_grp.delivery_action ',
823: 'Populate_WSTT');
824: END IF;
825: l_action_prms.caller := 'WMS_DLMG';
826: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
827: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
828:
829: l_delivery_id_tab(1) := l_delivery_id;
830:

Line 831: wsh_interface_ext_grp.delivery_action

827: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
828:
829: l_delivery_id_tab(1) := l_delivery_id;
830:
831: wsh_interface_ext_grp.delivery_action
832: (p_api_version_number => 1.0,
833: p_init_msg_list => fnd_api.g_false,
834: p_commit => fnd_api.g_false,
835: p_action_prms => l_action_prms,

Line 1201: l_detail_attributes wsh_interface.ChangedAttributeTabType;

1197: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
1198: l_lot_number VARCHAR2(80);
1199: l_picked_quantity NUMBER := 0;
1200:
1201: l_detail_attributes wsh_interface.ChangedAttributeTabType;
1202: l_InvPCInRecType wsh_integration.InvPCInRecType;
1203: l_return_status VARCHAR2(1);
1204: l_msg_count NUMBER;
1205: l_msg_data VARCHAR2(2000);

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

1271:
1272: l_detail_attributes(1).delivery_detail_id :=
1273: l_delivery_detail_id;
1274: l_detail_attributes(1).action_flag := 'U';
1275: --Passing picked_quantity also because wsh_interface.update_shipping_attributes
1276: --will null it out if we do not
1277: l_detail_attributes(1).picked_quantity := l_picked_quantity;
1278:
1279: debug('About to call wsh_interface.update_shipping_attributes','nested_serial_check');

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

1275: --Passing picked_quantity also because wsh_interface.update_shipping_attributes
1276: --will null it out if we do not
1277: l_detail_attributes(1).picked_quantity := l_picked_quantity;
1278:
1279: debug('About to call wsh_interface.update_shipping_attributes','nested_serial_check');
1280: debug('delivery_detail_id : ' ||
1281: l_detail_attributes(1).delivery_detail_id,
1282: 'nested_serial_check');
1283:

Line 1285: wsh_interface.update_shipping_attributes

1281: l_detail_attributes(1).delivery_detail_id,
1282: 'nested_serial_check');
1283:
1284: --update transaction_temp_id in WDD
1285: wsh_interface.update_shipping_attributes
1286: (x_return_status => l_return_status,
1287: p_changed_attributes => l_detail_attributes,
1288: p_source_code => 'INV');
1289: --\Shipping API cleanup

Line 1291: debug('wsh_interface.update_shipping_attributes failed'

1287: p_changed_attributes => l_detail_attributes,
1288: p_source_code => 'INV');
1289: --\Shipping API cleanup
1290: IF l_return_status IN (G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR) THEN
1291: debug('wsh_interface.update_shipping_attributes failed'
1292: || ' with status: ' || l_return_status,'nested_serial_check');
1293: --check where to handle this error
1294: RAISE fnd_api.g_exc_unexpected_error;
1295: END IF;

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

2044: l_delivery_id NUMBER;
2045: l_dock_appoint_flag VARCHAR2(1);
2046: temp_val NUMBER;
2047:
2048: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype; --g-log
2049: l_delivery_id_tab wsh_util_core.id_tab_type;
2050: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2051: l_msg_count NUMBER;
2052: l_msg_data VARCHAR2(2000);

Line 2050: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

2046: temp_val NUMBER;
2047:
2048: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype; --g-log
2049: l_delivery_id_tab wsh_util_core.id_tab_type;
2050: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
2051: l_msg_count NUMBER;
2052: l_msg_data VARCHAR2(2000);
2053:
2054: /**********************************

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

2236:
2237: --Important Note: Irrespective of the severity level of 'CR' exception for the delivery just
2238: --created, we have to mark the delivery to ignore_for_planning so that the
2239: --transaction goes through fine.
2240: -- Hence there is no call to WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM().
2241: -- Here delivery was created in the backend for the line that the use
2242: -- chose to ship confirm. it IS ALL happening in the backend.
2243:
2244:

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

2247: debug('ignore_for_planning of WDD is N ', 'LPN_CHECK');
2248: END IF;
2249: l_delivery_id_tab(1) := l_delivery_id;
2250: l_action_prms.caller := 'WMS_LPNSHP';
2251: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
2252: l_action_prms.action_code := 'IGNORE_PLAN';
2253: wsh_interface_ext_grp.delivery_action
2254: (p_api_version_number => 1.0,
2255: p_init_msg_list => fnd_api.g_false,

Line 2253: wsh_interface_ext_grp.delivery_action

2249: l_delivery_id_tab(1) := l_delivery_id;
2250: l_action_prms.caller := 'WMS_LPNSHP';
2251: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
2252: l_action_prms.action_code := 'IGNORE_PLAN';
2253: wsh_interface_ext_grp.delivery_action
2254: (p_api_version_number => 1.0,
2255: p_init_msg_list => fnd_api.g_false,
2256: p_commit => fnd_api.g_false,
2257: p_action_prms => l_action_prms,

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

2261: x_msg_count => l_msg_count,
2262: x_msg_data => l_msg_data);
2263:
2264: IF (l_debug = 1) THEN
2265: debug('Called wsh_interface_ext_grp.delivery_action with action_code IGNORE_PLAN and return status: ' || l_return_status, 'LPN_CHECK');
2266: END IF;
2267: IF l_return_status = fnd_api.g_ret_sts_error THEN
2268: x_error_code := 7;
2269: return;

Line 5009: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

5005: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5006: l_debug number;
5007:
5008: /* Bug: 5585359: 10/09/06 Start*/
5009: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5010: l_delivery_id_tab wsh_util_core.id_tab_type;
5011: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5012: l_planned_flag VARCHAR2(1);
5013: /* Bug: 5585359: 10/09/06 - End*/

Line 5011: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

5007:
5008: /* Bug: 5585359: 10/09/06 Start*/
5009: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5010: l_delivery_id_tab wsh_util_core.id_tab_type;
5011: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5012: l_planned_flag VARCHAR2(1);
5013: /* Bug: 5585359: 10/09/06 - End*/
5014:
5015: l_delivery_details wsh_delivery_details_pub.id_tab_type;

Line 5086: wsh_interface_ext_grp.delivery_action

5082:
5083: IF l_debug = 1 THEN
5084: DEBUG('Unfirm delivery for unassignment','UNASSIGN_DELIVERY_LINE');
5085: END IF;
5086: wsh_interface_ext_grp.delivery_action
5087: (p_api_version_number => 1.0,
5088: p_init_msg_list => fnd_api.g_false,
5089: p_commit => fnd_api.g_false,
5090: p_action_prms => l_action_prms,

Line 5140: wsh_interface_ext_grp.delivery_action

5136: l_action_prms.action_code := 'PLAN';
5137: IF l_debug = 1 THEN
5138: DEBUG('firm delivery after unassignment','UNASSIGN_DELIVERY_LINE');
5139: END IF;
5140: wsh_interface_ext_grp.delivery_action
5141: (p_api_version_number => 1.0,
5142: p_init_msg_list => fnd_api.g_false,
5143: p_commit => p_commit_flag,
5144: p_action_prms => l_action_prms,

Line 5184: l_shipping_attr_tab WSH_INTERFACE.ChangedAttributeTabType;

5180: l_oe_order_line_id NUMBER;
5181: l_released_status VARCHAR2(1);
5182: l_organization_id NUMBER;
5183:
5184: l_shipping_attr_tab WSH_INTERFACE.ChangedAttributeTabType;
5185: l_wdd_counter NUMBER := 1;
5186:
5187: l_progress VARCHAR2(10);
5188: l_return_status VARCHAR2(1);

Line 5296: WSH_INTERFACE.Update_Shipping_Attributes

5292: END IF;
5293:
5294: l_progress := '50';
5295:
5296: WSH_INTERFACE.Update_Shipping_Attributes
5297: (p_source_code => 'INV',
5298: p_changed_attributes => l_shipping_attr_tab,
5299: x_return_status => l_return_status
5300: );

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

5299: x_return_status => l_return_status
5300: );
5301:
5302: IF (l_debug = 1) THEN
5303: debug('update_wdd_loc_by_lpn 25 - WSH_INTERFACE.Update_Shipping_Attributes returns : '
5304: ||l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');
5305: END IF;
5306:
5307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN