[Home] [Help]
444: l_dummy_ids wsh_util_core.id_tab_type;
445: l_valid_index_tab wsh_util_core.id_tab_type;
446: l_error_ids wsh_util_core.id_tab_type;
447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
448: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
449: l_dummy_doc_param WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
450: l_api_version_number CONSTANT NUMBER := 1.0;
451: l_api_name CONSTANT VARCHAR2(30):= 'Trip_Action';
452: l_first NUMBER;
480: --dummy tables for calling validate_constraint_wrapper
481: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
482: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
483: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
484: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
485: l_cc_in_ids wsh_util_core.id_tab_type;
486: l_cc_fail_ids wsh_util_core.id_tab_type;
487:
488: --Compatibility Changes
497: -- J-IB-NPARIKH-{
498: CURSOR dlvy_csr(p_trip_id NUMBER)
499: IS
500: SELECT wdl.delivery_id, wt.name
501: FROM wsh_trip_stops wts,
502: wsh_Delivery_legs wdl,
503: wsh_new_deliveries wnd,
504: wsh_trips wt
505: WHERE wt.trip_id = p_trip_id
1840: l_return_status VARCHAR2(1);
1841: x_msg_count NUMBER;
1842: l_index NUMBER;
1843: x_msg_data varchar2(32764);
1844: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
1845: l_dummy VARCHAR2(3000);
1846: l_dummy_master_org_id NUMBER;
1847: l_seg_array FND_FLEX_EXT.SegmentArray;
1848: l_vehicle_org_id NUMBER;
2335: --ROLLBACK TO SAVEPOINT validate_trip_grp;
2336:
2337: WHEN OTHERS THEN
2338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2339: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.Validate_Trip');
2340: FND_MSG_PUB.Count_And_Get (
2341: p_count => x_msg_count,
2342: p_data => x_msg_data,
2343: p_encoded => FND_API.G_FALSE);
2411: --dummy tables for calling validate_constraint_wrapper
2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2417: l_cc_fail_ids wsh_util_core.id_tab_type;
2418:
2419: --Compatibility Changes
2418:
2419: --Compatibility Changes
2420: CURSOR c_getorgcarriersmc (p_tripid NUMBER) IS
2421: SELECT wnd.organization_id, wnd.name, wt.ship_method_code, wt.carrier_id
2422: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt
2423: WHERE wnd.delivery_id=wdl.delivery_id
2424: and wdl.pick_up_stop_id=wts.stop_id
2425: and wt.trip_id = p_tripid
2426: and wt.trip_id=wts.trip_id
2924: --ROLLBACK TO create_update_trip_grp;
2925:
2926: WHEN OTHERS THEN
2927: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2928: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
2929: FND_MSG_PUB.Count_And_Get (
2930: p_count => x_msg_count,
2931: p_data => x_msg_data,
2932: p_encoded => FND_API.G_FALSE);
3078: END IF;
3079:
3080: WHEN OTHERS THEN
3081: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3082: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3083: IF l_debug_on THEN
3084: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3085: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3236: END IF;
3237:
3238: WHEN OTHERS THEN
3239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3240: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3243: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');