[Home] [Help]
562: END IF;
563:
564:
565: -- Calculate Shipper Cutoff time
566: l_shipper_cutoff_time := FTE_MLS_UTIL.FTE_UOM_CONV(l_shipper_wait_time, l_wait_time_uom,'MIN');
567:
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.logmsg(l_module_name,'Gettting shipper cuttoff time in MIN ' || l_shipper_cutoff_time,
570: WSH_DEBUG_SV.C_PROC_LEVEL);
583: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
584: FND_MESSAGE.SET_TOKEN('WAIT_TIME',l_shipper_wait_time);
585: FND_MESSAGE.SET_TOKEN('WAIT_TIME_UOM',l_wait_time_uom);
586: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
587: l_msg_string := FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
588:
589:
590: wf_core.TOKEN('ERROR_STRING',l_msg_string);
591: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
593: END IF;
594:
595:
596:
597: l_shipper_cutoff_time_days := FTE_MLS_UTIL.FTE_UOM_CONV(l_shipper_wait_time,
598: l_wait_time_uom,'DAY');
599:
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.logmsg(l_module_name,
688:
689: IF ( (l_return_status = 'E')
690: OR (l_return_status = 'U') )
691: THEN
692: l_msg_string := FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
693: wf_core.TOKEN('ERROR_STRING',l_msg_string);
694: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
695: END IF;
696:
1152:
1153:
1154:
1155: IF ( (l_return_status = 'E') OR (l_return_status = 'U') ) THEN
1156: l_msg_string := FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
1157: wf_core.TOKEN('ERROR_STRING',l_msg_string);
1158: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
1159: END IF;
1160:
1314:
1315:
1316:
1317: IF ( (l_return_status = 'E') OR (l_return_status = 'U') ) THEN
1318: l_msg_string := FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
1319: wf_core.TOKEN('ERROR_STRING',l_msg_string);
1320: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
1321: END IF;
1322:
2087:
2088:
2089:
2090: IF ( (l_return_status = 'E') OR (l_return_status = 'U') ) THEN
2091: l_msg_string := FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
2092: wf_core.TOKEN('ERROR_STRING',l_msg_string);
2093: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
2094: END IF;
2095:
2265:
2266: IF ( (l_return_status = 'E')
2267: OR (l_return_status = 'U') )
2268: THEN
2269: l_msg_string := 'FINALIZE_AUTO_ACCEPT :-> Tender Id ='||to_char(l_tender_id)||' :'||FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
2270: wf_core.TOKEN('ERROR_STRING',l_msg_string);
2271: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
2272: END IF;
2273:
2472: x_shipper_wait_time := to_char(l_wait_time)||':'||l_wait_time_uom;
2473: ------------------------------------------------------------------
2474:
2475:
2476: l_wait_time_days := FTE_MLS_UTIL.FTE_UOM_CONV(l_wait_time, l_wait_time_uom,'DAY');
2477:
2478: --l_wait_time_days := FTE_MLS_UTIL.FTE_UOM_CONV(l_wait_time, l_wait_time_uom,'MIN');
2479:
2480: IF (l_wait_time_days = -9999)
2474:
2475:
2476: l_wait_time_days := FTE_MLS_UTIL.FTE_UOM_CONV(l_wait_time, l_wait_time_uom,'DAY');
2477:
2478: --l_wait_time_days := FTE_MLS_UTIL.FTE_UOM_CONV(l_wait_time, l_wait_time_uom,'MIN');
2479:
2480: IF (l_wait_time_days = -9999)
2481: THEN
2482: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
2502: --l_temp_value := INV_CONVERT.inv_um_convert(null,2,
2503: -- l_temp_value,
2504: -- 'DAY','MIN',
2505: -- NULL,NULL);
2506: l_temp_value := FTE_MLS_UTIL.FTE_UOM_CONV(l_temp_value, 'DAY','MIN');
2507:
2508: IF (l_temp_value = -9999)
2509: THEN
2510: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
2766: IF ( (l_return_status = 'E')
2767: OR (l_return_status = 'U') )
2768: THEN
2769: l_msg_string := 'LOG_HISTORY :-> Tender Id ='||to_char(l_trip_id)||' :'||
2770: FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
2771: wf_core.TOKEN('ERROR_STRING',l_msg_string);
2772: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
2773: END IF;
2774:
2936: WHERE TRIP_ID = l_trip_id;
2937:
2938: -- We have to query first stop, last stop information to populate on to
2939: -- trip
2940: FTE_MLS_UTIL.GET_FIRST_LAST_STOP_INFO(x_return_status => l_return_status,
2941: x_arrival_date => l_arr_date,
2942: x_departure_date => l_dept_date,
2943: x_first_stop_id => l_first_stop_id,
2944: x_last_stop_id => l_last_stop_id,
2955: IF ( (l_return_status = 'E')
2956: OR (l_return_status = 'U') )
2957: THEN
2958: l_msg_string := 'FTE_MSL_UTIL.GET_FIRST_LAST_STOP_INFO :-> Tender Id ='||to_char(l_trip_id)||
2959: ' :'||FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
2960: wf_core.TOKEN('ERROR_STRING',l_msg_string);
2961: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
2962: END IF;
2963:
3002: IF ( (l_return_status = 'E')
3003: OR (l_return_status = 'U') )
3004: THEN
3005: l_msg_string := 'FTE_SS_INTERFACE.SEARCH_SERIVCE :-> Tender Id ='||to_char(l_trip_id)||
3006: ' :'||FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
3007: wf_core.TOKEN('ERROR_STRING',l_msg_string);
3008: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
3009: END IF;
3010:
3124: IF ( (l_return_status = 'E')
3125: OR (l_return_status = 'U') )
3126: THEN
3127: l_msg_string := 'FTE_SS_INTERFACE.IS_RANK_LIST_EXHAUSTED :-> Tender Id ='||to_char(l_trip_id)||
3128: ' :'||FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
3129: wf_core.TOKEN('ERROR_STRING',l_msg_string);
3130: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
3131: END IF;
3132:
3235: IF ( (l_return_status = 'E')
3236: OR (l_return_status = 'U') )
3237: THEN
3238: l_msg_string := 'FTE_CARRIER_RANK_LIST_PVT.REMOVE_SERVICE_APPLY_NEXT :-> Tender Id ='||to_char(l_trip_id)||
3239: ' :'||FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
3240: wf_core.TOKEN('ERROR_STRING',l_msg_string);
3241: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
3242: END IF;
3243:
3357: IF ( (l_return_status = 'E')
3358: OR (l_return_status = 'U') )
3359: THEN
3360: l_msg_string := 'FTE_MLS_WRAPPER.TRIP_ACTION :-> Tender Id ='||to_char(l_trip_id)||
3361: ' :'||FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
3362: wf_core.TOKEN('ERROR_STRING',l_msg_string);
3363: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
3364: END IF;
3365: