DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_INTERFACE_EXT_GRP

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