DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_INTERFACE_EXT_GRP

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 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 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,