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 1315: WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM(

1311: -- This update for the ignore_for_plan to 'Y' is needed to autocreate the trip
1312: -- for this delivery during ship conform.
1313: --
1314:
1315: WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM(
1316: p_delivery_id => p_delivery_id,
1317: p_tms_interface_flag => l_tms_interface_flag,
1318: p_trip_id => l_otm_trip_id,
1319: x_return_status => l_return_status);

Line 4605: l_shipping_attr_tab wsh_interface.changedattributetabtype;

4601: l_error_code VARCHAR2(20000);
4602: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4603: l_transaction_temp_id NUMBER;
4604: l_shipping_attr WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
4605: l_shipping_attr_tab wsh_interface.changedattributetabtype;
4606: l_delivery_detail_id NUMBER;
4607: l_picked_qty NUMBER;
4608: l_shipped_qty NUMBER;
4609: l_primary_uom_code VARCHAR2(3);

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

4719: l_shipping_attr_tab(1).delivery_detail_id := l_delivery_detail_id;
4720: l_shipping_attr_tab(1).action_flag := 'U';
4721: l_shipping_attr_tab(1).released_status := 'R';
4722:
4723: wsh_interface.update_shipping_attributes(p_source_code => 'INV',
4724: p_changed_attributes => l_shipping_attr_tab
4725: ,x_return_status => l_return_status);
4726:
4727: l_shipping_attr_tab.DELETE;

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

4732: l_shipping_attr_tab(1).released_status := 'Y';
4733: DEBUG('Before calling Update_shipping_attributes to update qty'||
4734: l_shipping_attr_tab(1).shipped_quantity , 'Overship Staged Lines');
4735:
4736: wsh_interface.update_shipping_attributes(p_source_code => 'INV',
4737: p_changed_attributes => l_shipping_attr_tab
4738: ,x_return_status => l_return_status);
4739:
4740: IF (l_debug = 1) THEN

Line 4852: wsh_interface.update_shipping_attributes(

4848: l_shipping_attr_tab(1).released_status ,'Overship Staged Lines');
4849: END IF;
4850: /*Verify the Action Flag*/
4851:
4852: wsh_interface.update_shipping_attributes(
4853: p_source_code => 'INV',
4854: p_changed_attributes => l_shipping_attr_tab,
4855: x_return_status => l_return_status);
4856:

Line 5045: l_shipping_attr wsh_interface.changedattributetabtype;

5041: l_sub_reservable NUMBER;
5042: l_item_reservable NUMBER;
5043: l_lot_control_code NUMBER;
5044: l_serial_number_control_code NUMBER;
5045: l_shipping_attr wsh_interface.changedattributetabtype;
5046: l_invpcinrectype wsh_integration.invpcinrectype;
5047: l_rsv_index NUMBER;
5048: l_rsv_qty NUMBER;
5049: i NUMBER;

Line 5074: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

5070: else check if existing delivery_details have a trip already associated else
5071: create new trip
5072: */
5073:
5074: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5075: l_delivery_id_tab wsh_util_core.id_tab_type;
5076: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5077:
5078: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 5076: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

5072: */
5073:
5074: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
5075: l_delivery_id_tab wsh_util_core.id_tab_type;
5076: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
5077:
5078: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5079: -- Bug# 3464013: Replaced the static cursor with dynamic ref cursor
5080: l_sql_query VARCHAR2(10000);

Line 5816: wsh_interface.update_shipping_attributes

5812: ,l_shipping_attr(1).lot_number
5813: ,l_shipping_attr(1).picked_quantity);
5814: END IF;
5815:
5816: wsh_interface.update_shipping_attributes
5817: ( p_source_code => 'INV'
5818: , p_changed_attributes => l_shipping_attr
5819: , x_return_status => l_return_status);
5820:

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

6170: END IF;
6171: IF (l_debug = 1) THEN
6172: DEBUG('Call update shipping attributes', 'stage_lpns');
6173: END IF;
6174: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr
6175: , x_return_status => l_return_status);
6176:
6177: IF (l_debug = 1) THEN
6178: DEBUG('after update shipping attributes', 'stage_lpns');

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

6230: FOR i IN 1 .. l_delivery_detail_tab.COUNT LOOP
6231: l_shipping_attr.DELETE;
6232: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_tab(i).delivery_detail_id;
6233: l_shipping_attr(1).released_status := 'Y';
6234: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr
6235: , x_return_status => l_return_status);
6236:
6237: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
6238: IF (l_debug = 1) THEN

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

6348: ---
6349: IF g_wms_current_release_level >= g_j_release_level THEN
6350:
6351: l_action_prms.caller := 'WMS_DLMG';
6352: l_action_prms.event := wsh_interface_ext_grp.g_start_of_shipping;
6353: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
6354:
6355: l_delivery_id_tab(1) := l_delivery_id;
6356:

Line 6357: wsh_interface_ext_grp.delivery_action

6353: l_action_prms.action_code := 'ADJUST-PLANNED-FLAG';
6354:
6355: l_delivery_id_tab(1) := l_delivery_id;
6356:
6357: wsh_interface_ext_grp.delivery_action
6358: (p_api_version_number => 1.0,
6359: p_init_msg_list => fnd_api.g_false,
6360: p_commit => fnd_api.g_false,
6361: p_action_prms => l_action_prms,

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

6395:
6396: --Important Note: Irrespective of the severity level of 'CR' exception for the delivery just
6397: --created, we have to mark the delivery to ignore_for_planning so that the
6398: --transaction goes through fine.
6399: -- Hence there is no call to WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM().
6400: -- Here delivery was created in the backend for the line that the use
6401: -- chose to ship confirm. it IS ALL happening in the backend.
6402:
6403: IF l_ignore_for_planning = 'N' AND l_tms_interface_flag = 'CR' THEN

Line 6405: wsh_interface_ext_grp.delivery_action

6401: -- chose to ship confirm. it IS ALL happening in the backend.
6402:
6403: IF l_ignore_for_planning = 'N' AND l_tms_interface_flag = 'CR' THEN
6404: l_action_prms.action_code := 'IGNORE_PLAN';
6405: wsh_interface_ext_grp.delivery_action
6406: (p_api_version_number => 1.0,
6407: p_init_msg_list => fnd_api.g_false,
6408: p_commit => fnd_api.g_false,
6409: p_action_prms => l_action_prms,

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

6413: x_msg_count => l_msg_count,
6414: x_msg_data => l_msg_data);
6415:
6416: IF (l_debug = 1) THEN
6417: debug('Called wsh_interface_ext_grp.delivery_action with action_code IGNORE_PLAN and return status: ' || l_return_status, 'stage_lpns');
6418: END IF;
6419:
6420: IF l_return_status = fnd_api.g_ret_sts_error THEN
6421: x_msg_data := 'WMS_DELIVERY_ACTION_FAIL';

Line 7393: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

7389: l_container_flag VARCHAR2(1);
7390:
7391: l_delivery_id NUMBER;
7392: l_delivery_planned_flag VARCHAR2(1);
7393: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
7394: l_delivery_id_tab wsh_util_core.id_tab_type;
7395: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
7396:
7397: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;

Line 7395: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;

7391: l_delivery_id NUMBER;
7392: l_delivery_planned_flag VARCHAR2(1);
7393: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
7394: l_delivery_id_tab wsh_util_core.id_tab_type;
7395: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
7396:
7397: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;
7398: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;
7399: l_trip_id_tab wsh_util_core.id_tab_type;

Line 7397: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;

7393: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
7394: l_delivery_id_tab wsh_util_core.id_tab_type;
7395: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
7396:
7397: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;
7398: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;
7399: l_trip_id_tab wsh_util_core.id_tab_type;
7400:
7401: -- Release 12 : LPN SyncUp

Line 7398: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;

7394: l_delivery_id_tab wsh_util_core.id_tab_type;
7395: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
7396:
7397: l_trip_action_prms WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype;
7398: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;
7399: l_trip_id_tab wsh_util_core.id_tab_type;
7400:
7401: -- Release 12 : LPN SyncUp
7402: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;

Line 7634: wsh_interface_ext_grp.trip_action

7630: debug(SQLERRM,'Container_Nesting');
7631: RAISE fnd_api.g_exc_unexpected_error;
7632: END;
7633:
7634: wsh_interface_ext_grp.trip_action
7635: (p_api_version_number => 1.0,
7636: p_init_msg_list => fnd_api.g_false,
7637: p_commit => fnd_api.g_false,
7638: p_action_prms => l_trip_action_prms,

Line 7659: wsh_interface_ext_grp.delivery_action

7655:
7656: l_delivery_id_tab(1) := l_delivery_id;
7657:
7658: DEBUG('Unfirm delivery','Container_Nesting');
7659: wsh_interface_ext_grp.delivery_action
7660: (p_api_version_number => 1.0,
7661: p_init_msg_list => fnd_api.g_false,
7662: p_commit => fnd_api.g_false,
7663: p_action_prms => l_action_prms,

Line 7699: wsh_interface_ext_grp.delivery_action

7695: IF l_delivery_planned_flag = 'Y' THEN
7696:
7697: l_action_prms.action_code := 'PLAN';
7698: DEBUG('Planned flag is Y need to firm back the delivery','Container_Nesting');
7699: wsh_interface_ext_grp.delivery_action
7700: (p_api_version_number => 1.0,
7701: p_init_msg_list => fnd_api.g_false,
7702: p_commit => fnd_api.g_false,
7703: p_action_prms => l_action_prms,

Line 7720: wsh_interface_ext_grp.trip_action

7716: else
7717: debug('Planned flag is F. Firm back the trip: ' || l_trip_id_tab(1),'Container_Nesting');
7718: l_trip_action_prms.action_code := 'FIRM';
7719:
7720: wsh_interface_ext_grp.trip_action
7721: (p_api_version_number => 1.0,
7722: p_init_msg_list => fnd_api.g_false,
7723: p_commit => fnd_api.g_false,
7724: p_action_prms => l_trip_action_prms,