DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_TRIPS_PVT

Line 2956: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

2952: l_confirm_del_cnt NUMBER := 0;
2953:
2954: /*new variable */
2955: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2956: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
2957: -- bug 2263249
2958: l_wms_enabled_flag BOOLEAN;
2959: -- bug 2343058
2960: l_check_credit_init_flag BOOLEAN;

Line 2978: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2974: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
2975: l_cc_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
2976: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
2977:
2978: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2979: l_trip_id_tab_temp wsh_util_core.id_tab_type;
2980: l_cc_count_success NUMBER;
2981: b_cc_linefailed BOOLEAN;
2982: l_target_trip_id NUMBER;

Line 2989: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2985:
2986: --dummy tables for calling validate_constraint_wrapper
2987: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2988: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2989: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2990: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2991: l_cc_in_ids wsh_util_core.id_tab_type;
2992: l_cc_fail_ids wsh_util_core.id_tab_type;
2993: l_cc_carrier_id NUMBER;

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

5976: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
5977: IF l_cc_fail_ids.COUNT>0 THEN
5978:
5979: IF l_debug_on THEN
5980: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
5981: END IF;
5982:
5983: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_COMP_FAILED');
5984: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));

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

5980: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
5981: END IF;
5982:
5983: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_COMP_FAILED');
5984: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));
5985: x_return_status := l_return_status;
5986: wsh_util_core.add_message(x_return_status);
5987: goto confirm_error;
5988: ELSE

Line 6043: WSH_TRIPS_PVT.lock_trip_no_compare(l_del_first_trip);

6039: END IF;
6040:
6041: BEGIN
6042:
6043: WSH_TRIPS_PVT.lock_trip_no_compare(l_del_first_trip);
6044:
6045: EXCEPTION
6046:
6047: WHEN app_exception.application_exception OR app_exception.record_lock_exception THEN

Line 10036: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

10032: l_success_trip_ids wsh_util_core.id_tab_type;
10033: -- End of J+ Internal Location
10034: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
10035: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
10036: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
10037: --
10038: l_debug_on BOOLEAN;
10039: --
10040: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'update_ship_from_location';

Line 11257: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type

11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11254: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11255: -- --
11256: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11257: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type
11258: --
11259: --
11260: -- RETURN: none --
11261: -- --

Line 11288: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

11284: PROCEDURE FORMAT_DEL_UPDATE_TABLE(--p_cs_result_tab IN FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
11285: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
11286: p_caller IN VARCHAR2 DEFAULT NULL,
11287: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11288: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
11289: x_return_message OUT NOCOPY VARCHAR2,
11290: x_return_status OUT NOCOPY VARCHAR2) IS
11291:
11292: fmc NUMBER;

Line 11856: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

11852:
11853: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11854: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11855: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11856: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11857: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11858: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
11859: l_msg_count NUMBER;
11860: l_msg_data VARCHAR2(2000);

Line 14588: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

14584: l_commit VARCHAR2(10);
14585: l_return_status VARCHAR2(1);
14586: l_msg_count NUMBER;
14587: l_msg_data VARCHAR2(2000);
14588: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14589: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14590: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14591: l_num_warnings NUMBER := 0;
14592: l_num_errors NUMBER := 0;

Line 14589: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;

14585: l_return_status VARCHAR2(1);
14586: l_msg_count NUMBER;
14587: l_msg_data VARCHAR2(2000);
14588: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14589: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14590: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14591: l_num_warnings NUMBER := 0;
14592: l_num_errors NUMBER := 0;
14593: l_do_date DATE;