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 1225: l_otm_ifp_del_ids wsh_util_core.id_tab_type;

1221: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
1222: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
1223: l_exception_text WSH_EXCEPTIONS.MESSAGE%TYPE;
1224:
1225: l_otm_ifp_del_ids wsh_util_core.id_tab_type;
1226:
1227: l_num_warn NUMBER :=0;
1228: l_num_error NUMBER :=0;
1229:

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

1364: the stage_lpn() API. At this time, we will always have the delivery - either existing or created in stage_LPN()
1365: there is no check on exception severity in stage_lpn().
1366:
1367: -- Glog Changes
1368: IF WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' AND nvl(l_ignore_for_planning, 'N') = 'N' THEN
1369:
1370: l_otm_trip_id := 0;
1371: l_otm_carrier_id := 0;
1372: l_otm_ship_method_code := NULL;

Line 1873: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1869: p_dock_door_id IN NUMBER,
1870: p_delivery_id IN NUMBER,
1871: p_direct_ship_flag IN VARCHAR2 DEFAULT 'N'
1872: ) IS
1873: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1874: l_auto_trip_del WSH_UTIL_CORE.ID_TAB_TYPE;
1875: l_auto_trip_index NUMBER:=1;
1876: --l_delivery_id NUMBER;
1877: l_return_Status VARCHAR2(1);

Line 1874: l_auto_trip_del WSH_UTIL_CORE.ID_TAB_TYPE;

1870: p_delivery_id IN NUMBER,
1871: p_direct_ship_flag IN VARCHAR2 DEFAULT 'N'
1872: ) IS
1873: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1874: l_auto_trip_del WSH_UTIL_CORE.ID_TAB_TYPE;
1875: l_auto_trip_index NUMBER:=1;
1876: --l_delivery_id NUMBER;
1877: l_return_Status VARCHAR2(1);
1878: l_del_index NUMBER;

Line 2068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2064: ( p_count => l_msg_count,
2065: p_data => l_msg_data
2066: );
2067: WHEN others THEN
2068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2069: wms_globals.g_ship_confirm_method := NULL;
2070: IF (l_debug = 1) THEN
2071: debug('Exception When Others'||SQLERRM,'WMS_DIRECT_SHIP.Create_Trips');
2072: END IF;

Line 2425: l_trip_id wsh_util_core.id_tab_type;

2421: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2422: l_msg_count NUMBER;
2423: l_msg_data VARCHAR2(20000);
2424: l_report_set_id NUMBER;
2425: l_trip_id wsh_util_core.id_tab_type;
2426: l_stop_id wsh_util_core.id_tab_type;
2427: l_delivery_id wsh_util_core.id_tab_type;
2428: l_document_param_info wsh_document_sets.document_set_tab_type;
2429: l_count1 NUMBER;

Line 2426: l_stop_id wsh_util_core.id_tab_type;

2422: l_msg_count NUMBER;
2423: l_msg_data VARCHAR2(20000);
2424: l_report_set_id NUMBER;
2425: l_trip_id wsh_util_core.id_tab_type;
2426: l_stop_id wsh_util_core.id_tab_type;
2427: l_delivery_id wsh_util_core.id_tab_type;
2428: l_document_param_info wsh_document_sets.document_set_tab_type;
2429: l_count1 NUMBER;
2430: l_count2 NUMBER;

Line 2427: l_delivery_id wsh_util_core.id_tab_type;

2423: l_msg_data VARCHAR2(20000);
2424: l_report_set_id NUMBER;
2425: l_trip_id wsh_util_core.id_tab_type;
2426: l_stop_id wsh_util_core.id_tab_type;
2427: l_delivery_id wsh_util_core.id_tab_type;
2428: l_document_param_info wsh_document_sets.document_set_tab_type;
2429: l_count1 NUMBER;
2430: l_count2 NUMBER;
2431: l_dummy VARCHAR2(20000);

Line 2646: l_delivery_details_tab wsh_util_core.id_tab_type;

2642: l_trip_id NUMBER;
2643: l_outermost_lpn VARCHAR2(30);
2644: l_loaded_dock_door VARCHAR2(2000);
2645: l_name VARCHAR2(30);
2646: l_delivery_details_tab wsh_util_core.id_tab_type;
2647: l_delivery_id NUMBER;
2648: l_del_index NUMBER;
2649: l_enforce_ship_method VARCHAR2(1);
2650: no_ship_method_code EXCEPTION;

Line 3122: l_lpn_del_det_tab wsh_util_core.id_tab_type;

3118: INDEX BY BINARY_INTEGER;
3119:
3120: l_delivery_detail_tab delivery_detail_t;
3121:
3122: l_lpn_del_det_tab wsh_util_core.id_tab_type;
3123:
3124: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
3125:
3126: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 4215: x_return_status := wsh_util_core.g_ret_sts_success;

4211:
4212: -- Update group_mark_id to reflect newly created transaction_temp_id
4213: l_group_mark_id := x_transaction_temp_id;
4214:
4215: x_return_status := wsh_util_core.g_ret_sts_success;
4216: l_split_const := 1;
4217:
4218: OPEN c_explode_detail;
4219: m := 1;

Line 4771: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

4767: x_return_status := fnd_api.g_ret_sts_unexp_error;
4768: ROLLBACK;
4769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4770: WHEN OTHERS THEN
4771: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4772: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_ACTIONS.EXPLODE_DELIVERY_DETAILS');
4773: END explode_delivery_details;
4774:
4775:

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

4768: ROLLBACK;
4769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4770: WHEN OTHERS THEN
4771: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4772: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_ACTIONS.EXPLODE_DELIVERY_DETAILS');
4773: END explode_delivery_details;
4774:
4775:
4776: /* Function overship_staged_lines

Line 4800: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;

4796: l_delivery_detail_tab DELIVERY_DETAIL_TAB;
4797: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4798: l_mtl_reservation_tbl_count NUMBER;
4799: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4800: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4801: l_return_status VARCHAR2(1);
4802: l_msg_data VARCHAR2(3000);
4803: l_msg_count NUMBER;
4804: l_error_code VARCHAR2(20000);

Line 5353: l_delivery_tab wsh_util_core.id_tab_type;

5349: l_cont_instance_id NUMBER;
5350: l_cont_name VARCHAR2(50);
5351: l_delivery_detail_id NUMBER;
5352: l_delivery_id NUMBER;
5353: l_delivery_tab wsh_util_core.id_tab_type;
5354:
5355: l_trip_id NUMBER;
5356: l_trip_name VARCHAR2(30);
5357: /* Patchset I */

Line 5375: l_delivery_id_tab wsh_util_core.id_tab_type;

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

Line 5496: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN

5492: , p_container_instance_id => l_cont_instance_id
5493: , x_return_status => l_return_status
5494: );
5495:
5496: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5497: fnd_message.set_name('WSH', 'WSH_CONT_UPD_ATTR_ERROR');
5498: fnd_message.set_token('CONT_NAME', l_cont_name);
5499: --x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5500: END IF;

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

5495:
5496: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5497: fnd_message.set_name('WSH', 'WSH_CONT_UPD_ATTR_ERROR');
5498: fnd_message.set_token('CONT_NAME', l_cont_name);
5499: --x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5500: END IF;
5501:
5502: IF (l_debug = 1) THEN
5503: DEBUG('The Update container_Hierarchy was successful for outer-lpn ' || l_outer_lpn.lpn_id, 'STAGE_LPN');

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

7480:
7481:
7482: -- g-log changes
7483:
7484: IF WSH_UTIL_CORE.GC3_IS_INSTALLED = 'Y' THEN
7485: IF (l_debug = 1) THEN
7486: debug('G-Log Changes: G-Log installed', 'LPN_CHECK');
7487: END IF;
7488:

Line 7570: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

7566:
7567: -- ROLLBACK;
7568: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7569: WHEN OTHERS THEN
7570: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
7571:
7572: IF (l_debug = 1) THEN
7573: DEBUG('Exception When Others ' || SQLERRM, 'Stage_LPNS');
7574: END IF;

Line 7987: l_lpn_ids wsh_util_core.id_tab_type;

7983: FROM wms_license_plate_numbers
7984: WHERE organization_id = p_org_id
7985: AND outermost_lpn_id = p_outermost_lpn_id;
7986:
7987: l_lpn_ids wsh_util_core.id_tab_type;
7988: l_container_ids wsh_util_core.id_tab_type;
7989: l_lpn_id NUMBER;
7990: l_segmentarray fnd_flex_ext.segmentarray;
7991: l_count NUMBER := 0;

Line 7988: l_container_ids wsh_util_core.id_tab_type;

7984: WHERE organization_id = p_org_id
7985: AND outermost_lpn_id = p_outermost_lpn_id;
7986:
7987: l_lpn_ids wsh_util_core.id_tab_type;
7988: l_container_ids wsh_util_core.id_tab_type;
7989: l_lpn_id NUMBER;
7990: l_segmentarray fnd_flex_ext.segmentarray;
7991: l_count NUMBER := 0;
7992: l_net_weight NUMBER;

Line 8478: l_child_del_det_tab wsh_util_core.id_tab_type;

8474: l_child_lpn_id NUMBER;
8475: l_parent_lpn_id NUMBER;
8476: l_par_del_det_id NUMBER;
8477: l_child_del_det_id NUMBER;
8478: l_child_del_det_tab wsh_util_core.id_tab_type;
8479: l_par_del_det_tab wsh_util_core.id_tab_type;
8480:
8481: l_count NUMBER := 0;
8482: l_parent_counter NUMBER := 0;

Line 8479: l_par_del_det_tab wsh_util_core.id_tab_type;

8475: l_parent_lpn_id NUMBER;
8476: l_par_del_det_id NUMBER;
8477: l_child_del_det_id NUMBER;
8478: l_child_del_det_tab wsh_util_core.id_tab_type;
8479: l_par_del_det_tab wsh_util_core.id_tab_type;
8480:
8481: l_count NUMBER := 0;
8482: l_parent_counter NUMBER := 0;
8483: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 8491: l_delivery_id_tab wsh_util_core.id_tab_type;

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

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

Line 8499: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;

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;
8500: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
8501: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
8502: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
8503: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

Line 8500: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;

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;
8500: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
8501: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
8502: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
8503: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
8504: