107:
108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
109:
110: FTE_FPA_UTIL.LOG_FAILURE_REASON(
111: p_init_msg_list => FND_API.G_FALSE,
112: p_parent_name => 'FTE_SHIPMENT_STATUS_HEADERS',
113: p_parent_id => P_SHIPMENT_STATUS_ID,
114: p_failure_type => 'FTE_TENDER_XML_FAILURE',
115: p_failure_reason => 'FTE_XML_INVALID_TENDER',
124:
125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
126:
127: FTE_FPA_UTIL.LOG_FAILURE_REASON(
128: p_init_msg_list => FND_API.G_FALSE,
129: p_parent_name => 'FTE_SHIPMENT_STATUS_HEADERS',
130: p_parent_id => P_SHIPMENT_STATUS_ID,
131: p_failure_type => 'FTE_TENDER_XML_FAILURE',
132: p_failure_reason => 'FTE_XML_OLD_MESSAGE',
153:
154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
155:
156: FTE_FPA_UTIL.LOG_FAILURE_REASON(
157: p_init_msg_list => FND_API.G_FALSE,
158: p_parent_name => 'FTE_SHIPMENT_STATUS_HEADERS',
159: p_parent_id => P_SHIPMENT_STATUS_ID,
160: p_failure_type => 'FTE_TENDER_XML_FAILURE',
161: p_failure_reason => 'FTE_XML_INVALID_TENDER_STATUS',
170: FND_MSG_PUB.Count_And_Get
171: (
172: p_count => l_msg_count,
173: p_data => l_msg_data,
174: p_encoded => FND_API.G_FALSE
175: );
176:
177: --}
178: EXCEPTION
176:
177: --}
178: EXCEPTION
179: --{
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO VALIDATE_XML_INFO_PUB;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get
184: (
178: EXCEPTION
179: --{
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO VALIDATE_XML_INFO_PUB;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get
184: (
185: p_count => l_msg_count,
186: p_data => l_msg_data,
183: FND_MSG_PUB.Count_And_Get
184: (
185: p_count => l_msg_count,
186: p_data => l_msg_data,
187: p_encoded => FND_API.G_FALSE
188: );
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO VALIDATE_XML_INFO_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
185: p_count => l_msg_count,
186: p_data => l_msg_data,
187: p_encoded => FND_API.G_FALSE
188: );
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO VALIDATE_XML_INFO_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: FND_MSG_PUB.Count_And_Get
193: (
187: p_encoded => FND_API.G_FALSE
188: );
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO VALIDATE_XML_INFO_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: FND_MSG_PUB.Count_And_Get
193: (
194: p_count => l_msg_count,
195: p_data => l_msg_data,
192: FND_MSG_PUB.Count_And_Get
193: (
194: p_count => l_msg_count,
195: p_data => l_msg_data,
196: p_encoded => FND_API.G_FALSE
197: );
198: WHEN OTHERS THEN
199: ROLLBACK TO VALIDATE_XML_INFO_PUB;
200: wsh_util_core.default_handler('FTE_TENDER_WF.VALIDATE_XML_INFO_PUB');
202: FND_MSG_PUB.Count_And_Get
203: (
204: p_count => l_msg_count,
205: p_data => l_msg_data,
206: p_encoded => FND_API.G_FALSE
207: );
208:
209: --}
210:
239:
240:
241:
242: PROCEDURE GET_SERVICE_VEHICLE_INFO(
243: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
244: p_tender_id IN NUMBER,
245: x_vehicle_type OUT NOCOPY VARCHAR2,
246: x_vehicle_class OUT NOCOPY VARCHAR2,
247: x_service_level OUT NOCOPY VARCHAR2) IS
287:
288: END GET_SERVICE_VEHICLE_INFO;
289:
290: PROCEDURE GET_MBOL_NUMBER(
291: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: p_tender_id IN NUMBER,
293: p_generate_mbol IN BOOLEAN,
294: x_mbol_number OUT NOCOPY VARCHAR2) IS
295:
677:
678:
679: -- org and shipment info
680: FTE_TRIPS_PVT.GET_SHIPMENT_INFORMATION
681: (p_init_msg_list => FND_API.G_FALSE,
682: p_tender_number => l_tender_id,
683: x_return_status => l_return_status,
684: x_msg_count => l_msg_count,
685: x_msg_data => l_msg_data,
838: -- 2005 SHRAVISA Updated --
839: -- ------------------------------------------------------------------------------- --
840:
841: PROCEDURE UPDATE_CARRIER_RESPONSE(
842: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
843: p_tender_id IN NUMBER,
844: p_tender_status IN VARCHAR2,
845: p_wf_item_key IN VARCHAR2,
846: p_remarks IN VARCHAR2,
886: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
887:
888: SAVEPOINT UPDATE_CARRIER_RESPONSE_PUB;
889:
890: IF FND_API.to_Boolean( p_init_msg_list )
891: THEN
892: FND_MSG_PUB.initialize;
893: END IF;
894: --
943: null,null);
944:
945:
946: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
947: p_init_msg_list => FND_API.G_TRUE,
948: x_return_status => x_return_status,
949: x_msg_count => x_msg_count,
950: x_msg_data => x_msg_data,
951: x_action_out_rec => l_action_out_rec,
960: FND_MSG_PUB.Count_And_Get
961: (
962: p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => FND_API.G_FALSE
965: );
966: --
967: --
968:
973:
974:
975: EXCEPTION
976:
977: WHEN FND_API.G_EXC_ERROR THEN
978: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: FND_MSG_PUB.Count_And_Get
981: (
975: EXCEPTION
976:
977: WHEN FND_API.G_EXC_ERROR THEN
978: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: FND_MSG_PUB.Count_And_Get
981: (
982: p_count => x_msg_count,
983: p_data => x_msg_data,
980: FND_MSG_PUB.Count_And_Get
981: (
982: p_count => x_msg_count,
983: p_data => x_msg_data,
984: p_encoded => FND_API.G_FALSE
985: );
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
982: p_count => x_msg_count,
983: p_data => x_msg_data,
984: p_encoded => FND_API.G_FALSE
985: );
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
989: FND_MSG_PUB.Count_And_Get
990: (
984: p_encoded => FND_API.G_FALSE
985: );
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
989: FND_MSG_PUB.Count_And_Get
990: (
991: p_count => x_msg_count,
992: p_data => x_msg_data,
989: FND_MSG_PUB.Count_And_Get
990: (
991: p_count => x_msg_count,
992: p_data => x_msg_data,
993: p_encoded => FND_API.G_FALSE
994: );
995:
996: WHEN OTHERS THEN
997: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
1000: FND_MSG_PUB.Count_And_Get
1001: (
1002: p_count => x_msg_count,
1003: p_data => x_msg_data,
1004: p_encoded => FND_API.G_FALSE
1005: );
1006:
1007:
1008: END UPDATE_CARRIER_RESPONSE;
1141: null,null);
1142:
1143:
1144: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
1145: p_init_msg_list => FND_API.G_TRUE,
1146: x_return_status => l_return_status,
1147: x_msg_count => l_msg_count,
1148: x_msg_data => l_msg_data,
1149: x_action_out_rec => l_action_out_rec,
1303: null,null);
1304:
1305:
1306: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
1307: p_init_msg_list => FND_API.G_TRUE,
1308: x_return_status => l_return_status,
1309: x_msg_count => l_msg_count,
1310: x_msg_data => l_msg_data,
1311: x_action_out_rec => l_action_out_rec,
2076: END IF;
2077:
2078:
2079: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
2080: p_init_msg_list => FND_API.G_TRUE,
2081: x_return_status => l_return_status,
2082: x_msg_count => l_msg_count,
2083: x_msg_data => l_msg_data,
2084: x_action_out_rec => l_action_out_rec,
2239: null,null);
2240:
2241:
2242: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
2243: p_init_msg_list => FND_API.G_TRUE,
2244: x_return_status => l_return_status,
2245: x_msg_count => l_msg_count,
2246: x_msg_data => l_msg_data,
2247: x_action_out_rec => l_action_out_rec,
2379: -- Get response by date, tendered date, handling info pickup date from GET_TENDER_INFO
2380: -- Reminder time
2381:
2382: PROCEDURE GET_TENDER_INFO(
2383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2384: p_tender_id IN NUMBER,
2385: x_return_status OUT NOCOPY VARCHAR2,
2386: x_msg_count OUT NOCOPY NUMBER,
2387: x_msg_data OUT NOCOPY VARCHAR2,
2425: --
2426: -- Initialize message list if p_init_msg_list is set to TRUE.
2427: --
2428: --
2429: IF FND_API.to_Boolean( p_init_msg_list )
2430: THEN
2431: FND_MSG_PUB.initialize;
2432: END IF;
2433: --
2482: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
2483: FND_MESSAGE.SET_TOKEN('WAIT_TIME',l_wait_time_days);
2484: FND_MESSAGE.SET_TOKEN('WAIT_TIME_UOM','DAY');
2485: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2486: RAISE FND_API.G_EXC_ERROR;
2487: END IF;
2488:
2489: x_response_by := (x_tendered_date+l_wait_time_days);
2490: --l_respond_by_text := x_tendered_date + l_wait_time_days/(60*24);
2510: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
2511: FND_MESSAGE.SET_TOKEN('WAIT_TIME',l_temp_value);
2512: FND_MESSAGE.SET_TOKEN('WAIT_TIME_UOM','MIN');
2513: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2514: RAISE FND_API.G_EXC_ERROR;
2515: END IF;
2516:
2517: l_rem_days := trunc(l_temp_value/(60*24),0);
2518: l_temp_value := l_temp_value - (l_rem_days*60*24);
2535: FND_MSG_PUB.Count_And_Get
2536: (
2537: p_count => x_msg_count,
2538: p_data => x_msg_data,
2539: p_encoded => FND_API.G_FALSE
2540: );
2541: --
2542: --
2543: IF l_debug_on THEN
2546:
2547: --}
2548: EXCEPTION
2549: --{
2550: WHEN FND_API.G_EXC_ERROR THEN
2551: ROLLBACK TO GET_TENDER_INFO_PUB;
2552: x_return_status := FND_API.G_RET_STS_ERROR ;
2553: FND_MSG_PUB.Count_And_Get
2554: (
2548: EXCEPTION
2549: --{
2550: WHEN FND_API.G_EXC_ERROR THEN
2551: ROLLBACK TO GET_TENDER_INFO_PUB;
2552: x_return_status := FND_API.G_RET_STS_ERROR ;
2553: FND_MSG_PUB.Count_And_Get
2554: (
2555: p_count => x_msg_count,
2556: p_data => x_msg_data,
2553: FND_MSG_PUB.Count_And_Get
2554: (
2555: p_count => x_msg_count,
2556: p_data => x_msg_data,
2557: p_encoded => FND_API.G_FALSE
2558: );
2559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2560: ROLLBACK TO GET_TENDER_INFO_PUB;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2555: p_count => x_msg_count,
2556: p_data => x_msg_data,
2557: p_encoded => FND_API.G_FALSE
2558: );
2559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2560: ROLLBACK TO GET_TENDER_INFO_PUB;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: FND_MSG_PUB.Count_And_Get
2563: (
2557: p_encoded => FND_API.G_FALSE
2558: );
2559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2560: ROLLBACK TO GET_TENDER_INFO_PUB;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: FND_MSG_PUB.Count_And_Get
2563: (
2564: p_count => x_msg_count,
2565: p_data => x_msg_data,
2562: FND_MSG_PUB.Count_And_Get
2563: (
2564: p_count => x_msg_count,
2565: p_data => x_msg_data,
2566: p_encoded => FND_API.G_FALSE
2567: );
2568: WHEN OTHERS THEN
2569: ROLLBACK TO GET_TENDER_INFO_PUB;
2570: wsh_util_core.default_handler('FTE_TENDER_WF.GET_TENDER_INFO');
2572: FND_MSG_PUB.Count_And_Get
2573: (
2574: p_count => x_msg_count,
2575: p_data => x_msg_data,
2576: p_encoded => FND_API.G_FALSE
2577: );
2578:
2579: --}
2580:
2754: l_delivery_leg_activity_rec.rank_version := l_rank_version;
2755:
2756:
2757: FTE_DELIVERY_ACTIVITY.ADD_HISTORY(
2758: p_init_msg_list => FND_API.G_FALSE,
2759: p_trip_id => l_trip_id,
2760: p_delivery_leg_activity_rec => l_delivery_leg_activity_rec,
2761: x_return_status => l_return_status,
2762: x_msg_count => l_msg_count,
2980: null,l_appendFlag);
2981:
2982:
2983: FTE_SS_INTERFACE.SEARCH_SERVICES(
2984: P_INIT_MSG_LIST => FND_API.G_FALSE,
2985: P_API_VERSION_NUMBER => 1.0,
2986: P_COMMIT => FND_API.G_FALSE,
2987: P_CALLER => FTE_SS_INTERFACE.S_CALLER_WF,
2988: P_FTE_SS_ATTR_REC => p_FTE_SS_ATTR_REC,
2982:
2983: FTE_SS_INTERFACE.SEARCH_SERVICES(
2984: P_INIT_MSG_LIST => FND_API.G_FALSE,
2985: P_API_VERSION_NUMBER => 1.0,
2986: P_COMMIT => FND_API.G_FALSE,
2987: P_CALLER => FTE_SS_INTERFACE.S_CALLER_WF,
2988: P_FTE_SS_ATTR_REC => p_FTE_SS_ATTR_REC,
2989: X_RATING_REQUEST_ID => l_rating_request_id,
2990: X_LIST_CREATE_TYPE => l_LIST_CREATE_TYPE,
3105: END IF;
3106:
3107:
3108: FTE_CARRIER_RANK_LIST_PVT.IS_RANK_LIST_EXHAUSTED(
3109: p_init_msg_list => FND_API.G_TRUE,
3110: x_is_exhausted => l_is_exhausted,
3111: x_return_status => l_return_status,
3112: x_msg_count => l_msg_count,
3113: x_msg_data => l_msg_data,
3224: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
3225: l_priceRequestId := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PRICE_REQUEST_ID');
3226:
3227: FTE_CARRIER_RANK_LIST_PVT.REMOVE_SERVICE_APPLY_NEXT(
3228: p_init_msg_list => FND_API.G_TRUE,
3229: x_return_status => l_return_status,
3230: x_msg_count => l_msg_count,
3231: x_msg_data => l_msg_data,
3232: p_trip_id => l_trip_id,
3344: null,null);
3345:
3346: FTE_MLS_WRAPPER.Trip_Action (
3347: p_api_version_number => 1.0,
3348: p_init_msg_list => FND_API.G_TRUE,
3349: x_return_status => l_return_status,
3350: x_msg_count => l_msg_count,
3351: x_msg_data => l_msg_data,
3352: x_action_out_rec => l_action_out_rec,