[Home] [Help]
2728: ,x_msg_count OUT nocopy number) IS
2729:
2730: l_trip_id NUMBER := null;
2731: l_trip_name VARCHAR2(30);
2732: l_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2733: BEGIN
2734: x_return_status := 'S';
2735:
2736: debug('p_delivery_id: ' || p_delivery_id
2768: END IF;
2769:
2770: debug('Trip id to be updated: ' || l_trip_id,'update_trip');
2771: debug('ship method code: ' || p_ship_method_code,'update_trip');
2772: debug('Calling WSH_TRIPS_PUB.create_update_trip','update_trip');
2773:
2774: l_trip_info.trip_id := l_trip_id;
2775: l_trip_info.last_update_date := SYSDATE;
2776: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2776: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2777: l_trip_info.last_update_login :=FND_GLOBAL.USER_ID;
2778: l_trip_info.ship_method_code :=p_ship_method_code;
2779:
2780: WSH_TRIPS_PUB.Create_Update_Trip
2781: (p_api_version_number => 1.0
2782: ,p_init_msg_list => FND_API.G_TRUE
2783: ,x_return_status => x_return_status
2784: ,x_msg_count => x_msg_count
2787: ,p_trip_info => l_trip_info
2788: ,x_trip_id => l_trip_id
2789: ,x_trip_name => l_trip_name);
2790:
2791: debug('return status from WSH_TRIPS_PUB.create_update_trip: ' || x_return_status,'update_trip');
2792:
2793: IF x_return_status NOT IN ('S','W') THEN
2794: debug('Shipping msg count: ' || x_msg_count,'update_trip');
2795: debug('Shipping error msg: ' || x_msg_data,'update_trip');
2829:
2830: l_trip_id NUMBER := null;
2831: l_trip_ship_method_code VARCHAR2(30) := null;
2832: l_trip_name VARCHAR2(30);
2833: l_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2834:
2835: l_msg_count NUMBER;
2836: l_msg_data VARCHAR2(2000);
2837: l_summary_buffer VARCHAR2(2000);