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_UTIL_CORE

Line 1142: l_otm_ifp_del_ids wsh_util_core.id_tab_type;

1138: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
1139: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
1140: l_exception_text WSH_EXCEPTIONS.MESSAGE%TYPE;
1141:
1142: l_otm_ifp_del_ids wsh_util_core.id_tab_type;
1143:
1144: l_num_warn NUMBER :=0;
1145: l_num_error NUMBER :=0;
1146:

Line 1284: IF WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' AND nvl(l_ignore_for_planning, 'N') = 'N' THEN

1280: the stage_lpn() API. At this time, we will always have the delivery - either existing or created in stage_LPN()
1281: there is no check on exception severity in stage_lpn().
1282:
1283: -- Glog Changes
1284: IF WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' AND nvl(l_ignore_for_planning, 'N') = 'N' THEN
1285:
1286: l_otm_trip_id := 0;
1287: l_otm_carrier_id := 0;
1288: l_otm_ship_method_code := NULL;

Line 1778: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1774: p_dock_door_id IN NUMBER,
1775: p_delivery_id IN NUMBER,
1776: p_direct_ship_flag IN VARCHAR2 DEFAULT 'N'
1777: ) IS
1778: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1779: l_auto_trip_del WSH_UTIL_CORE.ID_TAB_TYPE;
1780: l_auto_trip_index NUMBER:=1;
1781: --l_delivery_id NUMBER;
1782: l_return_Status VARCHAR2(1);

Line 1779: l_auto_trip_del WSH_UTIL_CORE.ID_TAB_TYPE;

1775: p_delivery_id IN NUMBER,
1776: p_direct_ship_flag IN VARCHAR2 DEFAULT 'N'
1777: ) IS
1778: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1779: l_auto_trip_del WSH_UTIL_CORE.ID_TAB_TYPE;
1780: l_auto_trip_index NUMBER:=1;
1781: --l_delivery_id NUMBER;
1782: l_return_Status VARCHAR2(1);
1783: l_del_index NUMBER;

Line 1972: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1968: ( p_count => l_msg_count,
1969: p_data => l_msg_data
1970: );
1971: WHEN others THEN
1972: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1973: wms_globals.g_ship_confirm_method := NULL;
1974: IF (l_debug = 1) THEN
1975: debug('Exception When Others'||SQLERRM,'WMS_DIRECT_SHIP.Create_Trips');
1976: END IF;

Line 2329: l_trip_id wsh_util_core.id_tab_type;

2325: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2326: l_msg_count NUMBER;
2327: l_msg_data VARCHAR2(20000);
2328: l_report_set_id NUMBER;
2329: l_trip_id wsh_util_core.id_tab_type;
2330: l_stop_id wsh_util_core.id_tab_type;
2331: l_delivery_id wsh_util_core.id_tab_type;
2332: l_document_param_info wsh_document_sets.document_set_tab_type;
2333: l_count1 NUMBER;

Line 2330: l_stop_id wsh_util_core.id_tab_type;

2326: l_msg_count NUMBER;
2327: l_msg_data VARCHAR2(20000);
2328: l_report_set_id NUMBER;
2329: l_trip_id wsh_util_core.id_tab_type;
2330: l_stop_id wsh_util_core.id_tab_type;
2331: l_delivery_id wsh_util_core.id_tab_type;
2332: l_document_param_info wsh_document_sets.document_set_tab_type;
2333: l_count1 NUMBER;
2334: l_count2 NUMBER;

Line 2331: l_delivery_id wsh_util_core.id_tab_type;

2327: l_msg_data VARCHAR2(20000);
2328: l_report_set_id NUMBER;
2329: l_trip_id wsh_util_core.id_tab_type;
2330: l_stop_id wsh_util_core.id_tab_type;
2331: l_delivery_id wsh_util_core.id_tab_type;
2332: l_document_param_info wsh_document_sets.document_set_tab_type;
2333: l_count1 NUMBER;
2334: l_count2 NUMBER;
2335: l_dummy VARCHAR2(20000);

Line 2544: l_delivery_details_tab wsh_util_core.id_tab_type;

2540: l_trip_id NUMBER;
2541: l_outermost_lpn VARCHAR2(30);
2542: l_loaded_dock_door VARCHAR2(2000);
2543: l_name VARCHAR2(30);
2544: l_delivery_details_tab wsh_util_core.id_tab_type;
2545: l_delivery_id NUMBER;
2546: l_del_index NUMBER;
2547: l_enforce_ship_method VARCHAR2(1);
2548: no_ship_method_code EXCEPTION;

Line 2965: l_lpn_del_det_tab wsh_util_core.id_tab_type;

2961: INDEX BY BINARY_INTEGER;
2962:
2963: l_delivery_detail_tab delivery_detail_t;
2964:
2965: l_lpn_del_det_tab wsh_util_core.id_tab_type;
2966:
2967: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
2968:
2969: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 4013: x_return_status := wsh_util_core.g_ret_sts_success;

4009:
4010: -- Update group_mark_id to reflect newly created transaction_temp_id
4011: l_group_mark_id := x_transaction_temp_id;
4012:
4013: x_return_status := wsh_util_core.g_ret_sts_success;
4014: l_split_const := 1;
4015:
4016: OPEN c_explode_detail;
4017: m := 1;

Line 4569: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

4565: x_return_status := fnd_api.g_ret_sts_unexp_error;
4566: ROLLBACK;
4567: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4568: WHEN OTHERS THEN
4569: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4570: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_ACTIONS.EXPLODE_DELIVERY_DETAILS');
4571: END explode_delivery_details;
4572:
4573:

Line 4570: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_ACTIONS.EXPLODE_DELIVERY_DETAILS');

4566: ROLLBACK;
4567: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4568: WHEN OTHERS THEN
4569: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4570: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_ACTIONS.EXPLODE_DELIVERY_DETAILS');
4571: END explode_delivery_details;
4572:
4573:
4574: /* Function overship_staged_lines

Line 4597: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;

4593: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
4594: l_delivery_detail_tab DELIVERY_DETAIL_TAB;
4595: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4596: l_mtl_reservation_tbl_count NUMBER;
4597: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4598: l_return_status VARCHAR2(1);
4599: l_msg_data VARCHAR2(3000);
4600: l_msg_count NUMBER;
4601: l_error_code VARCHAR2(20000);

Line 5056: l_delivery_tab wsh_util_core.id_tab_type;

5052: l_cont_instance_id NUMBER;
5053: l_cont_name VARCHAR2(50);
5054: l_delivery_detail_id NUMBER;
5055: l_delivery_id NUMBER;
5056: l_delivery_tab wsh_util_core.id_tab_type;
5057:
5058: l_trip_id NUMBER;
5059: l_trip_name VARCHAR2(30);
5060: /* Patchset I */

Line 5075: l_delivery_id_tab wsh_util_core.id_tab_type;

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);
5079: -- Bug# 3464013: Replaced the static cursor with dynamic ref cursor

Line 5196: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN

5192: , p_container_instance_id => l_cont_instance_id
5193: , x_return_status => l_return_status
5194: );
5195:
5196: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5197: fnd_message.set_name('WSH', 'WSH_CONT_UPD_ATTR_ERROR');
5198: fnd_message.set_token('CONT_NAME', l_cont_name);
5199: --x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5200: END IF;

Line 5199: --x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5195:
5196: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5197: fnd_message.set_name('WSH', 'WSH_CONT_UPD_ATTR_ERROR');
5198: fnd_message.set_token('CONT_NAME', l_cont_name);
5199: --x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5200: END IF;
5201:
5202: IF (l_debug = 1) THEN
5203: DEBUG('The Update container_Hierarchy was successful for outer-lpn ' || l_outer_lpn.lpn_id, 'STAGE_LPN');

Line 6377: IF WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' THEN

6373:
6374:
6375: -- g-log changes
6376:
6377: IF WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' THEN
6378: IF (l_debug = 1) THEN
6379: debug('G-Log Changes: G-Log installed', 'LPN_CHECK');
6380: END IF;
6381:

Line 6463: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

6459:
6460: -- ROLLBACK;
6461: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6462: WHEN OTHERS THEN
6463: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
6464:
6465: IF (l_debug = 1) THEN
6466: DEBUG('Exception When Others ' || SQLERRM, 'Stage_LPNS');
6467: END IF;

Line 6890: l_lpn_ids wsh_util_core.id_tab_type;

6886: FROM wms_license_plate_numbers
6887: WHERE organization_id = p_org_id
6888: AND outermost_lpn_id = p_outermost_lpn_id;
6889:
6890: l_lpn_ids wsh_util_core.id_tab_type;
6891: l_container_ids wsh_util_core.id_tab_type;
6892: l_lpn_id NUMBER;
6893: l_segmentarray fnd_flex_ext.segmentarray;
6894: l_count NUMBER := 0;

Line 6891: l_container_ids wsh_util_core.id_tab_type;

6887: WHERE organization_id = p_org_id
6888: AND outermost_lpn_id = p_outermost_lpn_id;
6889:
6890: l_lpn_ids wsh_util_core.id_tab_type;
6891: l_container_ids wsh_util_core.id_tab_type;
6892: l_lpn_id NUMBER;
6893: l_segmentarray fnd_flex_ext.segmentarray;
6894: l_count NUMBER := 0;
6895: l_net_weight NUMBER;

Line 7381: l_child_del_det_tab wsh_util_core.id_tab_type;

7377: l_child_lpn_id NUMBER;
7378: l_parent_lpn_id NUMBER;
7379: l_par_del_det_id NUMBER;
7380: l_child_del_det_id NUMBER;
7381: l_child_del_det_tab wsh_util_core.id_tab_type;
7382: l_par_del_det_tab wsh_util_core.id_tab_type;
7383:
7384: l_count NUMBER := 0;
7385: l_parent_counter NUMBER := 0;

Line 7382: l_par_del_det_tab wsh_util_core.id_tab_type;

7378: l_parent_lpn_id NUMBER;
7379: l_par_del_det_id NUMBER;
7380: l_child_del_det_id NUMBER;
7381: l_child_del_det_tab wsh_util_core.id_tab_type;
7382: l_par_del_det_tab wsh_util_core.id_tab_type;
7383:
7384: l_count NUMBER := 0;
7385: l_parent_counter NUMBER := 0;
7386: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 7394: l_delivery_id_tab wsh_util_core.id_tab_type;

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;
7398: l_trip_out_rec WSH_INTERFACE_EXT_GRP.tripactionoutrectype;

Line 7399: l_trip_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;
7403: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;

Line 7402: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;

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;
7403: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
7404: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
7405: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
7406: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

Line 7403: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;

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;
7403: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
7404: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
7405: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
7406: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
7407: