298: IF l_debug_on THEN
299: WSH_DEBUG_SV.push(l_module_name);
300: END IF;
301:
302: IF FND_API.to_Boolean( p_init_msg_list )
303: THEN
304: FND_MSG_PUB.initialize;
305: END IF;
306:
408:
409:
410: IF (l_return_status = 'E')
411: THEN
412: RAISE FND_API.G_EXC_ERROR;
413: ELSIF (l_return_status = 'U')
414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
411: THEN
412: RAISE FND_API.G_EXC_ERROR;
413: ELSIF (l_return_status = 'U')
414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418:
419:
564:
565: --}
566: END IF;
567:
568: X_SAVE_RANK_LIST := FND_API.G_TRUE;
569:
570:
571: -- Standard call to get message count and if count is 1,get message info.
572: --
573: FND_MSG_PUB.Count_And_Get
574: (
575: p_count => x_msg_count,
576: p_data => x_msg_data,
577: p_encoded => FND_API.G_FALSE
578: );
579:
580:
581: --
587:
588: --}
589: EXCEPTION
590: --{
591: WHEN FND_API.G_EXC_ERROR THEN
592: ROLLBACK TO CREATE_SEARCH_CRITERIA_WF_PUB;
593: x_return_status := FND_API.G_RET_STS_ERROR ;
594: FND_MSG_PUB.Count_And_Get
595: (
589: EXCEPTION
590: --{
591: WHEN FND_API.G_EXC_ERROR THEN
592: ROLLBACK TO CREATE_SEARCH_CRITERIA_WF_PUB;
593: x_return_status := FND_API.G_RET_STS_ERROR ;
594: FND_MSG_PUB.Count_And_Get
595: (
596: p_count => x_msg_count,
597: p_data => x_msg_data,
594: FND_MSG_PUB.Count_And_Get
595: (
596: p_count => x_msg_count,
597: p_data => x_msg_data,
598: p_encoded => FND_API.G_FALSE
599: );
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.pop(l_module_name);
602: END IF;
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.pop(l_module_name);
602: END IF;
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO CREATE_SEARCH_CRITERIA_WF_PUB;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: (
602: END IF;
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO CREATE_SEARCH_CRITERIA_WF_PUB;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: (
609: p_count => x_msg_count,
610: p_data => x_msg_data,
607: FND_MSG_PUB.Count_And_Get
608: (
609: p_count => x_msg_count,
610: p_data => x_msg_data,
611: p_encoded => FND_API.G_FALSE
612: );
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.pop(l_module_name);
615: END IF;
615: END IF;
616: WHEN OTHERS THEN
617: ROLLBACK TO CREATE_SEARCH_CRITERIA_WF_PUB;
618: wsh_util_core.default_handler('FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_WF');
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MSG_PUB.Count_And_Get
621: (
622: p_count => x_msg_count,
623: p_data => x_msg_data,
620: FND_MSG_PUB.Count_And_Get
621: (
622: p_count => x_msg_count,
623: p_data => x_msg_data,
624: p_encoded => FND_API.G_FALSE
625: );
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.pop(l_module_name);
628: END IF;
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.push(l_module_name);
707: END IF;
708:
709: IF FND_API.to_Boolean( p_init_msg_list )
710: THEN
711: FND_MSG_PUB.initialize;
712: END IF;
713:
770:
771: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) := l_new_rank_list_rec;
772:
773: X_LIST_CREATE_TYPE := 'USER';
774: X_SAVE_RANK_LIST := FND_API.G_FALSE;
775:
776: RETURN;
777:
778: --}
842:
843:
844: IF (l_return_status = 'E')
845: THEN
846: RAISE FND_API.G_EXC_ERROR;
847: ELSIF (l_return_status = 'U')
848: THEN
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END IF;
845: THEN
846: RAISE FND_API.G_EXC_ERROR;
847: ELSIF (l_return_status = 'U')
848: THEN
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END IF;
851:
852:
853:
871: END LOOP;
872: --}
873: END IF;
874:
875: X_SAVE_RANK_LIST := FND_API.G_TRUE;
876:
877: --}
878: ELSE
879: --{
894: l_rank_list_rec.SORT := 'RL';
895: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) :=
896: l_rank_list_rec;
897:
898: X_SAVE_RANK_LIST := FND_API.G_FALSE;
899: --}
900: END IF;
901:
902: --}
914:
915:
916: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')
917: THEN
918: X_SAVE_RANK_LIST := FND_API.G_TRUE;
919: l_rank_list_rec.SORT := 'RL';
920: l_rank_list_rec.RANK_ID := null;
921: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) := l_rank_list_rec;
922: ELSE
919: l_rank_list_rec.SORT := 'RL';
920: l_rank_list_rec.RANK_ID := null;
921: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) := l_rank_list_rec;
922: ELSE
923: X_SAVE_RANK_LIST := FND_API.G_FALSE;
924:
925: END IF;
926:
927:
932: -- what was the initial config anyway
933:
934: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
935: p_api_version_number => 1.0,
936: p_init_msg_list => FND_API.G_FALSE,
937: x_return_status => l_return_status,
938: x_msg_count => l_msg_count,
939: x_msg_data => l_msg_data,
940: p_action_code => FTE_CARRIER_RANK_LIST_PVT.S_DELETE,
973:
974: WSH_INTERFACE_GRP.Create_Update_Trip
975: (
976: p_api_version_number =>p_api_version_number,
977: p_init_msg_list =>FND_API.G_FALSE,
978: p_commit =>FND_API.G_FALSE,
979: x_return_status =>l_return_status,
980: x_msg_count =>l_msg_count,
981: x_msg_data =>l_msg_data,
974: WSH_INTERFACE_GRP.Create_Update_Trip
975: (
976: p_api_version_number =>p_api_version_number,
977: p_init_msg_list =>FND_API.G_FALSE,
978: p_commit =>FND_API.G_FALSE,
979: x_return_status =>l_return_status,
980: x_msg_count =>l_msg_count,
981: x_msg_data =>l_msg_data,
982: p_trip_info_tab =>p_trip_info_tab,
1000:
1001: IF l_number_of_errors > 0
1002: THEN
1003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1004: RAISE FND_API.G_EXC_ERROR;
1005: ELSIF l_number_of_warnings > 0
1006: THEN
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1008: ELSE
1046:
1047:
1048: IF (l_return_status = 'E')
1049: THEN
1050: RAISE FND_API.G_EXC_ERROR;
1051: ELSIF (l_return_status = 'U')
1052: THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1049: THEN
1050: RAISE FND_API.G_EXC_ERROR;
1051: ELSIF (l_return_status = 'U')
1052: THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055:
1056: IF l_debug_on
1057: THEN
1073: END LOOP;
1074: --}
1075: END IF;
1076:
1077: X_SAVE_RANK_LIST := FND_API.G_TRUE;
1078:
1079: --}
1080: ELSE
1081: --{
1084: LOG(l_module_name, ' Append flag is N Do not call RG ', WSH_DEBUG_SV.C_PROC_LEVEL);
1085: END IF;
1086:
1087:
1088: X_SAVE_RANK_LIST := FND_API.G_FALSE;
1089: --}
1090: END IF;
1091: --}
1092: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI)
1137:
1138: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) :=
1139: l_new_rank_list_rec;
1140:
1141: X_SAVE_RANK_LIST := FND_API.G_TRUE;
1142: X_LIST_CREATE_TYPE := 'SYSTEM';
1143:
1144: END IF;
1145:
1271:
1272: WSH_INTERFACE_GRP.Create_Update_Trip
1273: (
1274: p_api_version_number =>p_api_version_number,
1275: p_init_msg_list =>FND_API.G_FALSE,
1276: p_commit =>FND_API.G_FALSE,
1277: x_return_status =>l_return_status,
1278: x_msg_count =>l_msg_count,
1279: x_msg_data =>l_msg_data,
1272: WSH_INTERFACE_GRP.Create_Update_Trip
1273: (
1274: p_api_version_number =>p_api_version_number,
1275: p_init_msg_list =>FND_API.G_FALSE,
1276: p_commit =>FND_API.G_FALSE,
1277: x_return_status =>l_return_status,
1278: x_msg_count =>l_msg_count,
1279: x_msg_data =>l_msg_data,
1280: p_trip_info_tab =>p_trip_info_tab,
1297:
1298: IF l_number_of_errors > 0
1299: THEN
1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_number_of_warnings > 0
1303: THEN
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1305: ELSE
1360: l_new_rank_list_rec;
1361:
1362: END IF;
1363:
1364: X_SAVE_RANK_LIST := FND_API.G_TRUE;
1365:
1366:
1367: --}
1368: END IF;
1380: FND_MSG_PUB.Count_And_Get
1381: (
1382: p_count => x_msg_count,
1383: p_data => x_msg_data,
1384: p_encoded => FND_API.G_FALSE
1385: );
1386:
1387:
1388: --
1394:
1395: --}
1396: EXCEPTION
1397: --{
1398: WHEN FND_API.G_EXC_ERROR THEN
1399: ROLLBACK TO CREATE_SEARCH_CRITERIA_UI_PUB;
1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401: FND_MSG_PUB.Count_And_Get
1402: (
1396: EXCEPTION
1397: --{
1398: WHEN FND_API.G_EXC_ERROR THEN
1399: ROLLBACK TO CREATE_SEARCH_CRITERIA_UI_PUB;
1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401: FND_MSG_PUB.Count_And_Get
1402: (
1403: p_count => x_msg_count,
1404: p_data => x_msg_data,
1401: FND_MSG_PUB.Count_And_Get
1402: (
1403: p_count => x_msg_count,
1404: p_data => x_msg_data,
1405: p_encoded => FND_API.G_FALSE
1406: );
1407: IF l_debug_on THEN
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;
1407: IF l_debug_on THEN
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;
1410:
1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1412: ROLLBACK TO CREATE_SEARCH_CRITERIA_UI_PUB;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1414: FND_MSG_PUB.Count_And_Get
1415: (
1409: END IF;
1410:
1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1412: ROLLBACK TO CREATE_SEARCH_CRITERIA_UI_PUB;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1414: FND_MSG_PUB.Count_And_Get
1415: (
1416: p_count => x_msg_count,
1417: p_data => x_msg_data,
1414: FND_MSG_PUB.Count_And_Get
1415: (
1416: p_count => x_msg_count,
1417: p_data => x_msg_data,
1418: p_encoded => FND_API.G_FALSE
1419: );
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.pop(l_module_name);
1422: END IF;
1422: END IF;
1423: WHEN OTHERS THEN
1424: ROLLBACK TO CREATE_SEARCH_CRITERIA_UI_PUB;
1425: wsh_util_core.default_handler('FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_UI');
1426: x_return_status := FND_API.G_RET_STS_ERROR;
1427: FND_MSG_PUB.Count_And_Get
1428: (
1429: p_count => x_msg_count,
1430: p_data => x_msg_data,
1427: FND_MSG_PUB.Count_And_Get
1428: (
1429: p_count => x_msg_count,
1430: p_data => x_msg_data,
1431: p_encoded => FND_API.G_FALSE
1432: );
1433: IF l_debug_on THEN
1434: WSH_DEBUG_SV.pop(l_module_name);
1435: END IF;
1507: IF l_debug_on THEN
1508: WSH_DEBUG_SV.push(l_module_name);
1509: END IF;
1510:
1511: IF FND_API.to_Boolean( p_init_msg_list )
1512: THEN
1513: FND_MSG_PUB.initialize;
1514: END IF;
1515:
1556: END IF;
1557:
1558: CREATE_SEARCH_CRITERIA_WF(
1559: P_API_VERSION_NUMBER => 1.0,
1560: P_INIT_MSG_LIST => FND_API.G_FALSE,
1561: P_COMMIT => p_commit,
1562: P_CALLER => p_caller,
1563: P_FTE_SS_ATTR_REC => p_fte_ss_attr_rec,
1564: X_SS_RATE_SORT_TAB => l_search_criteria_tbl,
1597: END IF;
1598:
1599: CREATE_SEARCH_CRITERIA_UI(
1600: P_API_VERSION_NUMBER => 1.0,
1601: P_INIT_MSG_LIST => FND_API.G_FALSE,
1602: P_COMMIT => p_commit,
1603: P_CALLER => p_caller,
1604: P_FTE_SS_ATTR_REC => p_fte_ss_attr_rec,
1605: X_LIST_CREATE_TYPE => x_list_create_type,
1694:
1695:
1696: FTE_TRIP_RATING_GRP.Search_Rate_Sort(
1697: p_api_version => 1.0,
1698: p_init_msg_list => FND_API.G_FALSE,
1699: p_ss_rate_sort_tab => l_search_criteria_tbl,
1700: p_ss_rate_sort_atr_rec => P_FTE_SS_ATTR_REC,
1701: x_ss_rate_sort_tab => l_search_results_tbl,
1702: x_rating_request_id => x_rating_request_id,
1925: END LOOP;
1926:
1927:
1928:
1929: IF (l_save_rank_list = FND_API.G_TRUE AND
1930: l_rank_list_in_param_tbl.COUNT > 0)
1931: THEN
1932: --{
1933:
1953:
1954: -- Now call RANK_ACTION API to save information
1955: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
1956: p_api_version_number => 1.0,
1957: p_init_msg_list => FND_API.G_FALSE,
1958: x_return_status => l_return_status,
1959: x_msg_count => l_msg_count,
1960: x_msg_data => l_msg_data,
1961: p_action_code => l_rank_list_action,
1972:
1973: IF l_number_of_errors > 0
1974: THEN
1975: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1976: RAISE FND_API.G_EXC_ERROR;
1977: ELSIF l_number_of_warnings > 0
1978: THEN
1979: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1980: ELSE
2071:
2072: IF l_number_of_errors > 0
2073: THEN
2074: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2075: RAISE FND_API.G_EXC_ERROR;
2076: ELSIF l_number_of_warnings > 0
2077: THEN
2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2079: ELSE
2112:
2113: WSH_INTERFACE_GRP.Create_Update_Trip
2114: (
2115: p_api_version_number =>p_api_version_number,
2116: p_init_msg_list =>FND_API.G_FALSE,
2117: p_commit =>FND_API.G_FALSE,
2118: x_return_status =>l_return_status,
2119: x_msg_count =>l_msg_count,
2120: x_msg_data =>l_msg_data,
2113: WSH_INTERFACE_GRP.Create_Update_Trip
2114: (
2115: p_api_version_number =>p_api_version_number,
2116: p_init_msg_list =>FND_API.G_FALSE,
2117: p_commit =>FND_API.G_FALSE,
2118: x_return_status =>l_return_status,
2119: x_msg_count =>l_msg_count,
2120: x_msg_data =>l_msg_data,
2121: p_trip_info_tab =>p_trip_info_tab,
2139:
2140: IF l_number_of_errors > 0
2141: THEN
2142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2143: RAISE FND_API.G_EXC_ERROR;
2144: ELSIF l_number_of_warnings > 0
2145: THEN
2146: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2147: ELSE
2200: FND_MSG_PUB.Count_And_Get
2201: (
2202: p_count => x_msg_count,
2203: p_data => x_msg_data,
2204: p_encoded => FND_API.G_FALSE
2205: );
2206:
2207: --
2208: --
2213:
2214: --}
2215: EXCEPTION
2216: --{
2217: WHEN FND_API.G_EXC_ERROR THEN
2218: ROLLBACK TO SEARCH_SERVICES_PUB;
2219: x_return_status := FND_API.G_RET_STS_ERROR ;
2220: FND_MSG_PUB.Count_And_Get
2221: (
2215: EXCEPTION
2216: --{
2217: WHEN FND_API.G_EXC_ERROR THEN
2218: ROLLBACK TO SEARCH_SERVICES_PUB;
2219: x_return_status := FND_API.G_RET_STS_ERROR ;
2220: FND_MSG_PUB.Count_And_Get
2221: (
2222: p_count => x_msg_count,
2223: p_data => x_msg_data,
2220: FND_MSG_PUB.Count_And_Get
2221: (
2222: p_count => x_msg_count,
2223: p_data => x_msg_data,
2224: p_encoded => FND_API.G_FALSE
2225: );
2226: IF l_debug_on THEN
2227: WSH_DEBUG_SV.pop(l_module_name);
2228: END IF;
2226: IF l_debug_on THEN
2227: WSH_DEBUG_SV.pop(l_module_name);
2228: END IF;
2229:
2230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2231: ROLLBACK TO SEARCH_SERVICES_PUB;
2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2233: FND_MSG_PUB.Count_And_Get
2234: (
2228: END IF;
2229:
2230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2231: ROLLBACK TO SEARCH_SERVICES_PUB;
2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2233: FND_MSG_PUB.Count_And_Get
2234: (
2235: p_count => x_msg_count,
2236: p_data => x_msg_data,
2233: FND_MSG_PUB.Count_And_Get
2234: (
2235: p_count => x_msg_count,
2236: p_data => x_msg_data,
2237: p_encoded => FND_API.G_FALSE
2238: );
2239: IF l_debug_on THEN
2240: WSH_DEBUG_SV.pop(l_module_name);
2241: END IF;
2241: END IF;
2242: WHEN OTHERS THEN
2243: ROLLBACK TO SEARCH_SERVICES_PUB;
2244: wsh_util_core.default_handler('FTE_SS_INTERFACE.SEARCH_SERVICES');
2245: x_return_status := FND_API.G_RET_STS_ERROR;
2246: FND_MSG_PUB.Count_And_Get
2247: (
2248: p_count => x_msg_count,
2249: p_data => x_msg_data,
2246: FND_MSG_PUB.Count_And_Get
2247: (
2248: p_count => x_msg_count,
2249: p_data => x_msg_data,
2250: p_encoded => FND_API.G_FALSE
2251: );
2252: IF l_debug_on THEN
2253: WSH_DEBUG_SV.pop(l_module_name);
2254: END IF;
2304: IF l_debug_on THEN
2305: WSH_DEBUG_SV.push(l_module_name);
2306: END IF;
2307:
2308: IF FND_API.to_Boolean( p_init_msg_list )
2309: THEN
2310: FND_MSG_PUB.initialize;
2311: END IF;
2312:
2352:
2353: IF l_number_of_errors > 0
2354: THEN
2355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2356: RAISE FND_API.G_EXC_ERROR;
2357: ELSIF l_number_of_warnings > 0
2358: THEN
2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2360: ELSE
2427: FND_MSG_PUB.Count_And_Get
2428: (
2429: p_count => x_msg_count,
2430: p_data => x_msg_data,
2431: p_encoded => FND_API.G_FALSE
2432: );
2433:
2434: --
2435: --
2440:
2441: --}
2442: EXCEPTION
2443: --{
2444: WHEN FND_API.G_EXC_ERROR THEN
2445: ROLLBACK TO SEARCH_SERVICES_UIWRAPPER_PUB;
2446: x_return_status := FND_API.G_RET_STS_ERROR ;
2447: FND_MSG_PUB.Count_And_Get
2448: (
2442: EXCEPTION
2443: --{
2444: WHEN FND_API.G_EXC_ERROR THEN
2445: ROLLBACK TO SEARCH_SERVICES_UIWRAPPER_PUB;
2446: x_return_status := FND_API.G_RET_STS_ERROR ;
2447: FND_MSG_PUB.Count_And_Get
2448: (
2449: p_count => x_msg_count,
2450: p_data => x_msg_data,
2447: FND_MSG_PUB.Count_And_Get
2448: (
2449: p_count => x_msg_count,
2450: p_data => x_msg_data,
2451: p_encoded => FND_API.G_FALSE
2452: );
2453: IF l_debug_on THEN
2454: WSH_DEBUG_SV.pop(l_module_name);
2455: END IF;
2453: IF l_debug_on THEN
2454: WSH_DEBUG_SV.pop(l_module_name);
2455: END IF;
2456:
2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2458: ROLLBACK TO SEARCH_SERVICES_UIWRAPPER_PUB;
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2460: FND_MSG_PUB.Count_And_Get
2461: (
2455: END IF;
2456:
2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2458: ROLLBACK TO SEARCH_SERVICES_UIWRAPPER_PUB;
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2460: FND_MSG_PUB.Count_And_Get
2461: (
2462: p_count => x_msg_count,
2463: p_data => x_msg_data,
2460: FND_MSG_PUB.Count_And_Get
2461: (
2462: p_count => x_msg_count,
2463: p_data => x_msg_data,
2464: p_encoded => FND_API.G_FALSE
2465: );
2466: IF l_debug_on THEN
2467: WSH_DEBUG_SV.pop(l_module_name);
2468: END IF;
2468: END IF;
2469: WHEN OTHERS THEN
2470: ROLLBACK TO SEARCH_SERVICES_UIWRAPPER_PUB;
2471: wsh_util_core.default_handler('FTE_SS_INTERFACE.SEARCH_SERVICES_UIWRAPPER');
2472: x_return_status := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get
2474: (
2475: p_count => x_msg_count,
2476: p_data => x_msg_data,
2473: FND_MSG_PUB.Count_And_Get
2474: (
2475: p_count => x_msg_count,
2476: p_data => x_msg_data,
2477: p_encoded => FND_API.G_FALSE
2478: );
2479: IF l_debug_on THEN
2480: WSH_DEBUG_SV.pop(l_module_name);
2481: END IF;
2534: IF l_debug_on THEN
2535: WSH_DEBUG_SV.push(l_module_name);
2536: END IF;
2537:
2538: IF FND_API.to_Boolean( p_init_msg_list )
2539: THEN
2540: FND_MSG_PUB.initialize;
2541: END IF;
2542:
2633:
2634: IF l_number_of_errors > 0
2635: THEN
2636: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2637: RAISE FND_API.G_EXC_ERROR;
2638: ELSIF l_number_of_warnings > 0
2639: THEN
2640: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2641: ELSE
2649: FND_MSG_PUB.Count_And_Get
2650: (
2651: p_count => x_msg_count,
2652: p_data => x_msg_data,
2653: p_encoded => FND_API.G_FALSE
2654: );
2655:
2656: --
2657: --
2662:
2663: --}
2664: EXCEPTION
2665: --{
2666: WHEN FND_API.G_EXC_ERROR THEN
2667: ROLLBACK TO GET_RANKED_RESULTS_WRAPPER_PUB;
2668: x_return_status := FND_API.G_RET_STS_ERROR ;
2669: FND_MSG_PUB.Count_And_Get
2670: (
2664: EXCEPTION
2665: --{
2666: WHEN FND_API.G_EXC_ERROR THEN
2667: ROLLBACK TO GET_RANKED_RESULTS_WRAPPER_PUB;
2668: x_return_status := FND_API.G_RET_STS_ERROR ;
2669: FND_MSG_PUB.Count_And_Get
2670: (
2671: p_count => x_msg_count,
2672: p_data => x_msg_data,
2669: FND_MSG_PUB.Count_And_Get
2670: (
2671: p_count => x_msg_count,
2672: p_data => x_msg_data,
2673: p_encoded => FND_API.G_FALSE
2674: );
2675: IF l_debug_on THEN
2676: WSH_DEBUG_SV.pop(l_module_name);
2677: END IF;
2675: IF l_debug_on THEN
2676: WSH_DEBUG_SV.pop(l_module_name);
2677: END IF;
2678:
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO GET_RANKED_RESULTS_WRAPPER_PUB;
2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2682: FND_MSG_PUB.Count_And_Get
2683: (
2677: END IF;
2678:
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO GET_RANKED_RESULTS_WRAPPER_PUB;
2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2682: FND_MSG_PUB.Count_And_Get
2683: (
2684: p_count => x_msg_count,
2685: p_data => x_msg_data,
2682: FND_MSG_PUB.Count_And_Get
2683: (
2684: p_count => x_msg_count,
2685: p_data => x_msg_data,
2686: p_encoded => FND_API.G_FALSE
2687: );
2688: IF l_debug_on THEN
2689: WSH_DEBUG_SV.pop(l_module_name);
2690: END IF;
2690: END IF;
2691: WHEN OTHERS THEN
2692: ROLLBACK TO GET_RANKED_RESULTS_WRAPPER_PUB;
2693: wsh_util_core.default_handler('FTE_SS_INTERFACE.GET_RANKED_RESULTS_WRAPPER');
2694: x_return_status := FND_API.G_RET_STS_ERROR;
2695: FND_MSG_PUB.Count_And_Get
2696: (
2697: p_count => x_msg_count,
2698: p_data => x_msg_data,
2695: FND_MSG_PUB.Count_And_Get
2696: (
2697: p_count => x_msg_count,
2698: p_data => x_msg_data,
2699: p_encoded => FND_API.G_FALSE
2700: );
2701: IF l_debug_on THEN
2702: WSH_DEBUG_SV.pop(l_module_name);
2703: END IF;
2767: SAVEPOINT ASSIGN_SERVICE_TENDER_PUB;
2768:
2769: -- Initialize message list if p_init_msg_list is set to TRUE.
2770: --
2771: IF FND_API.to_Boolean( p_init_msg_list )
2772: THEN
2773: FND_MSG_PUB.initialize;
2774: END IF;
2775: --
2865: IF ( l_list_action IS NOT NULL AND l_trip_id IS NOT NULL) THEN
2866: IF ( p_list_action = 'SET_CURRENT' ) THEN
2867: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(
2868: p_API_VERSION_NUMBER => 1.0,
2869: p_INIT_MSG_LIST => FND_API.G_TRUE,
2870: p_ACTION_CODE => l_list_action,
2871: p_RANKLIST => p_ss_rate_sort_tab,
2872: p_RANK_ID => l_rank_id,
2873: p_TRIP_ID => l_trip_id,
2876: x_MSG_DATA => l_msg_data);
2877: ELSE
2878: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(
2879: p_API_VERSION_NUMBER => 1.0,
2880: p_INIT_MSG_LIST => FND_API.G_TRUE,
2881: p_ACTION_CODE => l_list_action,
2882: p_RANKLIST => p_ss_rate_sort_tab,
2883: p_RANK_ID => l_rank_id,
2884: p_TRIP_ID => l_trip_id,
2928: l_veh_org_id := p_ss_attr_rec.vehicle_org_id;
2929:
2930: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
2931: p_API_VERSION_NUMBER => 1.0,
2932: p_INIT_MSG_LIST => FND_API.G_TRUE,
2933: p_COMMIT => FND_API.G_FALSE,
2934: p_CALLER => 'FTE',
2935: p_SERVICE_ACTION => p_service_action,
2936: p_DELIVERY_ID => l_delivery_id,
2929:
2930: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
2931: p_API_VERSION_NUMBER => 1.0,
2932: p_INIT_MSG_LIST => FND_API.G_TRUE,
2933: p_COMMIT => FND_API.G_FALSE,
2934: p_CALLER => 'FTE',
2935: p_SERVICE_ACTION => p_service_action,
2936: p_DELIVERY_ID => l_delivery_id,
2937: p_DELIVERY_LEG_ID => l_delivery_leg_id,
2942: p_SERVICE_LEVEL => l_service_level,
2943: p_MODE_OF_TRANSPORT => l_mode,
2944: p_VEHICLE_ITEM_ID => l_veh_item_id,
2945: p_VEHICLE_ORG_ID => l_veh_org_id,
2946: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
2947: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
2948: x_RETURN_STATUS => l_return_status,
2949: x_MSG_COUNT => l_msg_count,
2950: x_MSG_DATA => l_msg_data);
2943: p_MODE_OF_TRANSPORT => l_mode,
2944: p_VEHICLE_ITEM_ID => l_veh_item_id,
2945: p_VEHICLE_ORG_ID => l_veh_org_id,
2946: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
2947: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
2948: x_RETURN_STATUS => l_return_status,
2949: x_MSG_COUNT => l_msg_count,
2950: x_MSG_DATA => l_msg_data);
2951:
2958: /* Hiding Project - Do not Raise Service Events
2959: ELSE -- Coming from DWB/MI
2960: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
2961: p_API_VERSION_NUMBER => 1.0,
2962: p_INIT_MSG_LIST => FND_API.G_TRUE,
2963: p_COMMIT => FND_API.G_FALSE,
2964: p_CALLER => 'FTE',
2965: p_SERVICE_ACTION => p_service_action,
2966: p_DELIVERY_ID => l_delivery_id,
2959: ELSE -- Coming from DWB/MI
2960: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
2961: p_API_VERSION_NUMBER => 1.0,
2962: p_INIT_MSG_LIST => FND_API.G_TRUE,
2963: p_COMMIT => FND_API.G_FALSE,
2964: p_CALLER => 'FTE',
2965: p_SERVICE_ACTION => p_service_action,
2966: p_DELIVERY_ID => l_delivery_id,
2967: p_DELIVERY_LEG_ID => l_delivery_leg_id,
2965: p_SERVICE_ACTION => p_service_action,
2966: p_DELIVERY_ID => l_delivery_id,
2967: p_DELIVERY_LEG_ID => l_delivery_leg_id,
2968: p_TRIP_ID => l_trip_id,
2969: p_LANE_ID => FND_API.G_MISS_NUM,
2970: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
2971: p_CARRIER_ID => FND_API.G_MISS_NUM,
2972: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2966: p_DELIVERY_ID => l_delivery_id,
2967: p_DELIVERY_LEG_ID => l_delivery_leg_id,
2968: p_TRIP_ID => l_trip_id,
2969: p_LANE_ID => FND_API.G_MISS_NUM,
2970: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
2971: p_CARRIER_ID => FND_API.G_MISS_NUM,
2972: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2974: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
2967: p_DELIVERY_LEG_ID => l_delivery_leg_id,
2968: p_TRIP_ID => l_trip_id,
2969: p_LANE_ID => FND_API.G_MISS_NUM,
2970: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
2971: p_CARRIER_ID => FND_API.G_MISS_NUM,
2972: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2974: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
2975: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
2968: p_TRIP_ID => l_trip_id,
2969: p_LANE_ID => FND_API.G_MISS_NUM,
2970: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
2971: p_CARRIER_ID => FND_API.G_MISS_NUM,
2972: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2974: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
2975: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
2976: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
2969: p_LANE_ID => FND_API.G_MISS_NUM,
2970: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
2971: p_CARRIER_ID => FND_API.G_MISS_NUM,
2972: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2974: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
2975: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
2976: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
2977: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
2970: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
2971: p_CARRIER_ID => FND_API.G_MISS_NUM,
2972: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2974: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
2975: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
2976: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
2977: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
2978: x_RETURN_STATUS => l_return_status,
2971: p_CARRIER_ID => FND_API.G_MISS_NUM,
2972: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2974: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
2975: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
2976: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
2977: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
2978: x_RETURN_STATUS => l_return_status,
2979: x_MSG_COUNT => l_msg_count,
2972: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2974: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
2975: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
2976: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
2977: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
2978: x_RETURN_STATUS => l_return_status,
2979: x_MSG_COUNT => l_msg_count,
2980: x_MSG_DATA => l_msg_data);
2973: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
2974: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
2975: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
2976: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
2977: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
2978: x_RETURN_STATUS => l_return_status,
2979: x_MSG_COUNT => l_msg_count,
2980: x_MSG_DATA => l_msg_data);
2981:
3018: /*
3019: ELSE -- Coming from DWB/MI
3020:
3021: FTE_FREIGHT_PRICING.MOVE_FC_TEMP_TO_MAIN(
3022: p_init_msg_list => FND_API.G_FALSE,
3023: p_request_id => p_request_id,
3024: p_trip_id => l_trip_id,
3025: p_lane_id => l_lane_id,
3026: p_schedule_id => l_schedule_id,
3059: null,null);
3060:
3061: FTE_MLS_WRAPPER.TRIP_ACTION(
3062: p_api_version_number => 1.0,
3063: p_init_msg_list => FND_API.G_TRUE,
3064: p_action_prms => l_trip_action_param,
3065: p_trip_info_rec => p_tender_attr_rec,
3066: x_action_out_rec => l_action_out_rec,
3067: x_return_status => l_return_status,
3077:
3078: IF l_number_of_errors > 0
3079: THEN
3080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3081: RAISE FND_API.G_EXC_ERROR;
3082: ELSIF l_number_of_warnings > 0 THEN
3083: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3084: ELSE
3085: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3089: FND_MSG_PUB.Count_And_Get
3090: (
3091: p_count => x_msg_count,
3092: p_data => x_msg_data,
3093: p_encoded => FND_API.G_FALSE
3094: );
3095:
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.POP(l_module_name);
3097: WSH_DEBUG_SV.POP(l_module_name);
3098: END IF;
3099:
3100: EXCEPTION
3101: WHEN FND_API.G_EXC_ERROR THEN
3102: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: FND_MSG_PUB.Count_And_Get
3105: (
3099:
3100: EXCEPTION
3101: WHEN FND_API.G_EXC_ERROR THEN
3102: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: FND_MSG_PUB.Count_And_Get
3105: (
3106: p_count => x_msg_count,
3107: p_data => x_msg_data,
3104: FND_MSG_PUB.Count_And_Get
3105: (
3106: p_count => x_msg_count,
3107: p_data => x_msg_data,
3108: p_encoded => FND_API.G_FALSE
3109: );
3110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3111: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3106: p_count => x_msg_count,
3107: p_data => x_msg_data,
3108: p_encoded => FND_API.G_FALSE
3109: );
3110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3111: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3113: FND_MSG_PUB.Count_And_Get
3114: (
3113: FND_MSG_PUB.Count_And_Get
3114: (
3115: p_count => x_msg_count,
3116: p_data => x_msg_data,
3117: p_encoded => FND_API.G_FALSE
3118: );
3119: WHEN OTHERS THEN
3120: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
3121: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3122: FND_MSG_PUB.Count_And_Get
3123: (
3124: p_count => x_msg_count,
3125: p_data => x_msg_data,
3126: p_encoded => FND_API.G_FALSE
3127: );
3128: END ASSIGN_SERVICE_TENDER;
3129:
3130: