[Home] [Help]
2667: ,x_msg_count OUT nocopy number) IS
2668:
2669: l_trip_id NUMBER := null;
2670: l_trip_name VARCHAR2(30);
2671: l_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2672: BEGIN
2673: x_return_status := 'S';
2674:
2675: debug('p_delivery_id: ' || p_delivery_id
2707: END IF;
2708:
2709: debug('Trip id to be updated: ' || l_trip_id,'update_trip');
2710: debug('ship method code: ' || p_ship_method_code,'update_trip');
2711: debug('Calling WSH_TRIPS_PUB.create_update_trip','update_trip');
2712:
2713: l_trip_info.trip_id := l_trip_id;
2714: l_trip_info.last_update_date := SYSDATE;
2715: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2715: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2716: l_trip_info.last_update_login :=FND_GLOBAL.USER_ID;
2717: l_trip_info.ship_method_code :=p_ship_method_code;
2718:
2719: WSH_TRIPS_PUB.Create_Update_Trip
2720: (p_api_version_number => 1.0
2721: ,p_init_msg_list => FND_API.G_TRUE
2722: ,x_return_status => x_return_status
2723: ,x_msg_count => x_msg_count
2726: ,p_trip_info => l_trip_info
2727: ,x_trip_id => l_trip_id
2728: ,x_trip_name => l_trip_name);
2729:
2730: debug('return status from WSH_TRIPS_PUB.create_update_trip: ' || x_return_status,'update_trip');
2731:
2732: IF x_return_status NOT IN ('S','W') THEN
2733: debug('Shipping msg count: ' || x_msg_count,'update_trip');
2734: debug('Shipping error msg: ' || x_msg_data,'update_trip');
2768:
2769: l_trip_id NUMBER := null;
2770: l_trip_ship_method_code VARCHAR2(30) := null;
2771: l_trip_name VARCHAR2(30);
2772: l_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2773:
2774: l_msg_count NUMBER;
2775: l_msg_data VARCHAR2(2000);
2776: l_summary_buffer VARCHAR2(2000);