DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_TRIPS_PVT

Line 2918: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

2914: l_confirm_del_cnt NUMBER := 0;
2915:
2916: /*new variable */
2917: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2918: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
2919: -- bug 2263249
2920: l_wms_enabled_flag BOOLEAN;
2921: -- bug 2343058
2922: l_check_credit_init_flag BOOLEAN;

Line 2940: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2936: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
2937: l_cc_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
2938: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
2939:
2940: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2941: l_trip_id_tab_temp wsh_util_core.id_tab_type;
2942: l_cc_count_success NUMBER;
2943: b_cc_linefailed BOOLEAN;
2944: l_target_trip_id NUMBER;

Line 2951: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2947:
2948: --dummy tables for calling validate_constraint_wrapper
2949: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2950: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2951: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2952: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2953: l_cc_in_ids wsh_util_core.id_tab_type;
2954: l_cc_fail_ids wsh_util_core.id_tab_type;
2955: l_cc_carrier_id NUMBER;

Line 5879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);

5875: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
5876: IF l_cc_fail_ids.COUNT>0 THEN
5877:
5878: IF l_debug_on THEN
5879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
5880: END IF;
5881:
5882: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_COMP_FAILED');
5883: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));

Line 5883: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));

5879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
5880: END IF;
5881:
5882: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_COMP_FAILED');
5883: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));
5884: x_return_status := l_return_status;
5885: wsh_util_core.add_message(x_return_status);
5886: goto confirm_error;
5887: ELSE

Line 5942: WSH_TRIPS_PVT.lock_trip_no_compare(l_del_first_trip);

5938: END IF;
5939:
5940: BEGIN
5941:
5942: WSH_TRIPS_PVT.lock_trip_no_compare(l_del_first_trip);
5943:
5944: EXCEPTION
5945:
5946: WHEN app_exception.application_exception OR app_exception.record_lock_exception THEN

Line 9840: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

9836: l_success_trip_ids wsh_util_core.id_tab_type;
9837: -- End of J+ Internal Location
9838: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
9839: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
9840: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
9841: --
9842: l_debug_on BOOLEAN;
9843: --
9844: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'update_ship_from_location';

Line 11061: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type

11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11059: -- --
11060: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11061: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type
11062: --
11063: --
11064: -- RETURN: none --
11065: -- --

Line 11092: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

11088: PROCEDURE FORMAT_DEL_UPDATE_TABLE(--p_cs_result_tab IN FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
11089: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
11090: p_caller IN VARCHAR2 DEFAULT NULL,
11091: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11092: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
11093: x_return_message OUT NOCOPY VARCHAR2,
11094: x_return_status OUT NOCOPY VARCHAR2) IS
11095:
11096: fmc NUMBER;

Line 11660: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

11656:
11657: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11658: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11659: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11660: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11661: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11662: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
11663: l_msg_count NUMBER;
11664: l_msg_data VARCHAR2(2000);

Line 14391: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

14387: l_commit VARCHAR2(10);
14388: l_return_status VARCHAR2(1);
14389: l_msg_count NUMBER;
14390: l_msg_data VARCHAR2(2000);
14391: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14392: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14393: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14394: l_num_warnings NUMBER := 0;
14395: l_num_errors NUMBER := 0;

Line 14392: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;

14388: l_return_status VARCHAR2(1);
14389: l_msg_count NUMBER;
14390: l_msg_data VARCHAR2(2000);
14391: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14392: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14393: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14394: l_num_warnings NUMBER := 0;
14395: l_num_errors NUMBER := 0;
14396: l_do_date DATE;