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_DIRECT_SHIP_PVT dependencies on WSH_INTERFACE

Line 1399: WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM(

1395: -- This update for the ignore_for_plan to 'Y' is needed to autocreate the trip
1396: -- for this delivery during ship conform.
1397: --
1398:
1399: WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM(
1400: p_delivery_id => p_delivery_id,
1401: p_tms_interface_flag => l_tms_interface_flag,
1402: p_trip_id => l_otm_trip_id,
1403: x_return_status => l_return_status);

Line 4807: l_shipping_attr_tab wsh_interface.changedattributetabtype;

4803: l_msg_count NUMBER;
4804: l_error_code VARCHAR2(20000);
4805: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4806: l_shipping_attr WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
4807: l_shipping_attr_tab wsh_interface.changedattributetabtype;
4808: l_delivery_detail_id NUMBER;
4809: l_picked_qty NUMBER;
4810: l_sec_picked_qty NUMBER;
4811: l_shipped_qty NUMBER;

Line 4967: wsh_interface.update_shipping_attributes(p_source_code => 'INV',

4963: l_shipping_attr_tab(1).delivery_detail_id := l_delivery_detail_id;
4964: l_shipping_attr_tab(1).action_flag := 'U';
4965: l_shipping_attr_tab(1).released_status := 'R';
4966:
4967: wsh_interface.update_shipping_attributes(p_source_code => 'INV',
4968: p_changed_attributes => l_shipping_attr_tab
4969: ,x_return_status => l_return_status);
4970:
4971: l_shipping_attr_tab.DELETE;

Line 4995: wsh_interface.update_shipping_attributes(p_source_code => 'INV',

4991: DEBUG('delivery_detail_id: '|| l_shipping_attr_tab(1).delivery_detail_id, 'Overship Staged Lines');
4992: DEBUG('Before calling Update_shipping_attributes to update qty', 'Overship Staged Lines');
4993: END IF;
4994:
4995: wsh_interface.update_shipping_attributes(p_source_code => 'INV',
4996: p_changed_attributes => l_shipping_attr_tab
4997: ,x_return_status => l_return_status);
4998:
4999: IF (l_debug = 1) THEN

Line 5125: wsh_interface.update_shipping_attributes(

5121: l_shipping_attr_tab(1).released_status ,'Overship Staged Lines');
5122: END IF;
5123: /*Verify the Action Flag*/
5124:
5125: wsh_interface.update_shipping_attributes(
5126: p_source_code => 'INV',
5127: p_changed_attributes => l_shipping_attr_tab,
5128: x_return_status => l_return_status);
5129:

Line 5342: l_shipping_attr wsh_interface.changedattributetabtype;

5338: l_inventory_item_id NUMBER;
5339: l_item_reservable NUMBER;
5340: l_lot_control_code NUMBER;
5341: l_serial_number_control_code NUMBER;
5342: l_shipping_attr wsh_interface.changedattributetabtype;
5343: l_invpcinrectype wsh_integration.invpcinrectype;
5344: l_rsv_index NUMBER;
5345: l_rsv_qty NUMBER;
5346: l_rsv_sec_qty NUMBER;

Line 5374: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

5370: else check if existing delivery_details have a trip already associated else
5371: create new trip
5372: */
5373:
5374: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5375: l_delivery_id_tab wsh_util_core.id_tab_type;
5376: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5377:
5378: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 5376: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

5372: */
5373:
5374: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5375: l_delivery_id_tab wsh_util_core.id_tab_type;
5376: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5377:
5378: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5379: -- Bug# 3464013: Replaced the static cursor with dynamic ref cursor
5380: l_sql_query VARCHAR2(10000);

Line 6213: wsh_interface.update_shipping_attributes(

6209:
6210: IF(l_debug = 1) THEN
6211: DEBUG('Before call to update shipping attributes l_shipping_attr(1).picked_quantity2 :=' || l_shipping_attr(1).picked_quantity2, 'STAGE_LPNS');
6212: END IF;
6213: wsh_interface.update_shipping_attributes(
6214: p_source_code => 'INV'
6215: , p_changed_attributes => l_shipping_attr
6216: , x_return_status => l_return_status);
6217:

Line 6617: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr

6613:
6614: IF (l_debug = 1) THEN
6615: DEBUG('Call update shipping attributes', 'stage_lpns');
6616: END IF;
6617: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr
6618: , x_return_status => l_return_status);
6619:
6620: IF (l_debug = 1) THEN
6621: DEBUG('after update shipping attributes', 'stage_lpns');

Line 6951: wsh_interface.update_shipping_attributes(

6947: END;
6948: END IF;
6949: END IF;
6950:
6951: wsh_interface.update_shipping_attributes(
6952: p_source_code => 'INV'
6953: , p_changed_attributes => l_shipping_attr
6954: , x_return_status => l_return_status);
6955:

Line 7280: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr

7276:
7277: IF (l_debug = 1) THEN
7278: DEBUG('Call update shipping attributes', 'stage_lpns');
7279: END IF;
7280: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr
7281: , x_return_status => l_return_status);
7282:
7283: IF (l_debug = 1) THEN
7284: DEBUG('after update shipping attributes', 'stage_lpns');

Line 7341: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr

7337: FOR i IN 1 .. l_delivery_detail_tab.COUNT LOOP
7338: l_shipping_attr.DELETE;
7339: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_tab(i).delivery_detail_id;
7340: l_shipping_attr(1).released_status := 'Y';
7341: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr
7342: , x_return_status => l_return_status);
7343:
7344: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
7345: IF (l_debug = 1) THEN

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

7455: ---
7456: IF g_wms_current_release_level >= g_j_release_level THEN
7457:
7458: l_action_prms.caller := 'WMS_DLMG';
7459: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
7460: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
7461:
7462: l_delivery_id_tab(1) := l_delivery_id;
7463:

Line 7464: wsh_interface_ext_grp.delivery_action

7460: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
7461:
7462: l_delivery_id_tab(1) := l_delivery_id;
7463:
7464: wsh_interface_ext_grp.delivery_action
7465: (p_api_version_number => 1.0,
7466: p_init_msg_list => fnd_api.g_false,
7467: p_commit => fnd_api.g_false,
7468: p_action_prms => l_action_prms,

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

7502:
7503: --Important Note: Irrespective of the severity level of 'CR' exception for the delivery just
7504: --created, we have to mark the delivery to ignore_for_planning so that the
7505: --transaction goes through fine.
7506: -- Hence there is no call to WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM().
7507: -- Here delivery was created in the backend for the line that the use
7508: -- chose to ship confirm. it IS ALL happening in the backend.
7509:
7510: IF l_ignore_for_planning = 'N' AND l_tms_interface_flag = 'CR' THEN

Line 7512: wsh_interface_ext_grp.delivery_action

7508: -- chose to ship confirm. it IS ALL happening in the backend.
7509:
7510: IF l_ignore_for_planning = 'N' AND l_tms_interface_flag = 'CR' THEN
7511: l_action_prms.action_code := 'IGNORE_PLAN';
7512: wsh_interface_ext_grp.delivery_action
7513: (p_api_version_number => 1.0,
7514: p_init_msg_list => fnd_api.g_false,
7515: p_commit => fnd_api.g_false,
7516: p_action_prms => l_action_prms,

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

7520: x_msg_count => l_msg_count,
7521: x_msg_data => l_msg_data);
7522:
7523: IF (l_debug = 1) THEN
7524: debug('Called wsh_interface_ext_grp.delivery_action with action_code IGNORE_PLAN and return status: ' || l_return_status, 'stage_lpns');
7525: END IF;
7526:
7527: IF l_return_status = fnd_api.g_ret_sts_error THEN
7528: x_msg_data := 'WMS_DELIVERY_ACTION_FAIL';

Line 8490: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

8486: l_container_flag VARCHAR2(1);
8487:
8488: l_delivery_id NUMBER;
8489: l_delivery_planned_flag VARCHAR2(1);
8490: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
8491: l_delivery_id_tab wsh_util_core.id_tab_type;
8492: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
8493:
8494: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;

Line 8492: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

8488: l_delivery_id NUMBER;
8489: l_delivery_planned_flag VARCHAR2(1);
8490: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
8491: l_delivery_id_tab wsh_util_core.id_tab_type;
8492: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
8493:
8494: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;
8495: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;
8496: l_trip_id_tab wsh_util_core.id_tab_type;

Line 8494: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;

8490: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
8491: l_delivery_id_tab wsh_util_core.id_tab_type;
8492: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
8493:
8494: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;
8495: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;
8496: l_trip_id_tab wsh_util_core.id_tab_type;
8497:
8498: -- Release 12 : LPN SyncUp

Line 8495: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;

8491: l_delivery_id_tab wsh_util_core.id_tab_type;
8492: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
8493:
8494: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;
8495: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;
8496: l_trip_id_tab wsh_util_core.id_tab_type;
8497:
8498: -- Release 12 : LPN SyncUp
8499: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;

Line 8731: wsh_interface_ext_grp.trip_action

8727: debug(SQLERRM,'Container_Nesting');
8728: RAISE fnd_api.g_exc_unexpected_error;
8729: END;
8730:
8731: wsh_interface_ext_grp.trip_action
8732: (p_api_version_number => 1.0,
8733: p_init_msg_list => fnd_api.g_false,
8734: p_commit => fnd_api.g_false,
8735: p_action_prms => l_trip_action_prms,

Line 8756: wsh_interface_ext_grp.delivery_action

8752:
8753: l_delivery_id_tab(1) := l_delivery_id;
8754:
8755: DEBUG('Unfirm delivery','Container_Nesting');
8756: wsh_interface_ext_grp.delivery_action
8757: (p_api_version_number => 1.0,
8758: p_init_msg_list => fnd_api.g_false,
8759: p_commit => fnd_api.g_false,
8760: p_action_prms => l_action_prms,

Line 8796: wsh_interface_ext_grp.delivery_action

8792: IF l_delivery_planned_flag = 'Y' THEN
8793:
8794: l_action_prms.action_code := 'PLAN';
8795: DEBUG('Planned flag is Y need to firm back the delivery','Container_Nesting');
8796: wsh_interface_ext_grp.delivery_action
8797: (p_api_version_number => 1.0,
8798: p_init_msg_list => fnd_api.g_false,
8799: p_commit => fnd_api.g_false,
8800: p_action_prms => l_action_prms,

Line 8817: wsh_interface_ext_grp.trip_action

8813: else
8814: debug('Planned flag is F. Firm back the trip: ' || l_trip_id_tab(1),'Container_Nesting');
8815: l_trip_action_prms.action_code := 'FIRM';
8816:
8817: wsh_interface_ext_grp.trip_action
8818: (p_api_version_number => 1.0,
8819: p_init_msg_list => fnd_api.g_false,
8820: p_commit => fnd_api.g_false,
8821: p_action_prms => l_trip_action_prms,