88: END IF;
89: --
90: --
91: -- Initialize API return status to success
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
93: l_number_of_errors := 0;
94: l_number_of_warnings := 0;
95: --
96:
159: ROLLBACK TO SEARCH_SEGMENT_SAVE_PUB;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: --
162: --
163: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.search_segment_save');
164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
165: --
166: --
167: FND_MSG_PUB.Count_And_Get
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: --
162: --
163: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.search_segment_save');
164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
165: --
166: --
167: FND_MSG_PUB.Count_And_Get
168: (
359: END IF;
360: --
361: --
362: -- Initialize API return status to success
363: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
364: l_number_of_errors := 0;
365: l_number_of_warnings := 0;
366: --
367: IF p_ui_page_name = GK_DLEG_WB_PAGE
639: x_return_status => x_return_status
640: );
641: --
642: --
643: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
644: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
645: THEN
646: --{
647: RAISE FND_API.G_EXC_ERROR;
640: );
641: --
642: --
643: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
644: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
645: THEN
646: --{
647: RAISE FND_API.G_EXC_ERROR;
648: --RETURN;
717: x_return_status => x_return_status
718: );
719: --
720: --
721: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
722: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
723: THEN
724: --{
725: RAISE FND_API.G_EXC_ERROR;
718: );
719: --
720: --
721: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
722: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
723: THEN
724: --{
725: RAISE FND_API.G_EXC_ERROR;
726: --RETURN;
800: x_return_status => x_return_status
801: );
802: --
803: --
804: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
805: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
806: THEN
807: --{
808: RAISE FND_API.G_EXC_ERROR;
801: );
802: --
803: --
804: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
805: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
806: THEN
807: --{
808: RAISE FND_API.G_EXC_ERROR;
809: --RETURN;
859: x_return_status => x_return_status
860: );
861: --
862: --
863: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
864: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
865: THEN
866: --{
867: RAISE FND_API.G_EXC_ERROR;
860: );
861: --
862: --
863: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
864: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
865: THEN
866: --{
867: RAISE FND_API.G_EXC_ERROR;
868: --RETURN;
956: x_return_status => x_return_status
957: );
958: --
959: --
960: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
961: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
962: THEN
963: --{
964: RAISE FND_API.G_EXC_ERROR;
957: );
958: --
959: --
960: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
961: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
962: THEN
963: --{
964: RAISE FND_API.G_EXC_ERROR;
965: --RETURN;
1049: x_return_status => x_return_status
1050: );
1051: --
1052: --
1053: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1054: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1055: THEN
1056: --{
1057: RAISE FND_API.G_EXC_ERROR;
1050: );
1051: --
1052: --
1053: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1054: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1055: THEN
1056: --{
1057: RAISE FND_API.G_EXC_ERROR;
1058: --RETURN;
1110: x_return_status => x_return_status
1111: );
1112: --
1113: --
1114: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1115: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1116: THEN
1117: --{
1118: RAISE FND_API.G_EXC_ERROR;
1111: );
1112: --
1113: --
1114: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1115: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1116: THEN
1117: --{
1118: RAISE FND_API.G_EXC_ERROR;
1119: --RETURN;
1155: x_return_status => x_return_status
1156: );
1157: --
1158: --
1159: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1160: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1161: THEN
1162: --{
1163: RAISE FND_API.G_EXC_ERROR;
1156: );
1157: --
1158: --
1159: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1160: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1161: THEN
1162: --{
1163: RAISE FND_API.G_EXC_ERROR;
1164: --RETURN;
1192: x_return_status => x_return_status
1193: );
1194: --
1195: --
1196: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1197: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1198: THEN
1199: --{
1200: RAISE FND_API.G_EXC_ERROR;
1193: );
1194: --
1195: --
1196: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1197: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1198: THEN
1199: --{
1200: RAISE FND_API.G_EXC_ERROR;
1201: --RETURN;
1223: --
1224: IF SQL%NOTFOUND
1225: THEN
1226: --{
1227: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1228: --
1229: --
1230: FTE_MLS_UTIL.api_post_call
1231: (
1239: x_return_status => x_return_status
1240: );
1241: --
1242: --
1243: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1244: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1245: THEN
1246: --{
1247: RAISE FND_API.G_EXC_ERROR;
1240: );
1241: --
1242: --
1243: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1244: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1245: THEN
1246: --{
1247: RAISE FND_API.G_EXC_ERROR;
1248: --RETURN;
1273: --
1274: IF SQL%NOTFOUND
1275: THEN
1276: --{
1277: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1278: --
1279: --
1280: FTE_MLS_UTIL.api_post_call
1281: (
1289: x_return_status => x_return_status
1290: );
1291: --
1292: --
1293: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1294: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1295: THEN
1296: --{
1297: RAISE FND_API.G_EXC_ERROR;
1290: );
1291: --
1292: --
1293: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1294: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1295: THEN
1296: --{
1297: RAISE FND_API.G_EXC_ERROR;
1298: --RETURN;
1339: x_return_status => x_return_status
1340: );
1341: --
1342: --
1343: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1344: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1345: THEN
1346: --{
1347: RAISE FND_API.G_EXC_ERROR;
1340: );
1341: --
1342: --
1343: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1344: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1345: THEN
1346: --{
1347: RAISE FND_API.G_EXC_ERROR;
1348: --RETURN;
1372:
1373: IF l_number_of_errors > 0
1374: THEN
1375: ROLLBACK TO PROCESS_DELIVERY_LEG_PUB;
1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1377: ELSIF l_number_of_warnings > 0 THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1379: ELSE
1380: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1374: THEN
1375: ROLLBACK TO PROCESS_DELIVERY_LEG_PUB;
1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1377: ELSIF l_number_of_warnings > 0 THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1379: ELSE
1380: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1381: END IF;
1382: --
1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1377: ELSIF l_number_of_warnings > 0 THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1379: ELSE
1380: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1381: END IF;
1382: --
1383: --
1384: -- Standard call to get message count and if count is 1,get message info.
1426: l_api_name
1427: );
1428: END IF;
1429: */
1430: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.PROCESS_DELIVERY_LEG');
1431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1432: --
1433: --
1434: FND_MSG_PUB.Count_And_Get
1427: );
1428: END IF;
1429: */
1430: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.PROCESS_DELIVERY_LEG');
1431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1432: --
1433: --
1434: FND_MSG_PUB.Count_And_Get
1435: (
1562: --{
1563: FTE_MLS_UTIL.api_post_call
1564: (
1565: p_api_name => 'FIRST_LAST_ID_DATES_NULL',
1566: p_api_return_status => WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1567: p_message_name => 'FTE_SEGMENT_UNEXP_ERROR',
1568: p_trip_segment_id => p_wsh_trip_id,
1569: p_trip_segment_name => p_wsh_trip_name,
1570: x_number_of_errors => l_number_of_errors,
1580: END IF;
1581: --
1582: --
1583: -- Initialize API return status to success
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1585: l_number_of_errors := 0;
1586: l_number_of_warnings := 0;
1587: l_first_stop_id := NULL;
1588: l_last_stop_id := NULL;
1693: x_return_status => x_return_status
1694: );
1695: --
1696: --
1697: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1698: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1699: THEN
1700: --{
1701: RAISE FND_API.G_EXC_ERROR;
1694: );
1695: --
1696: --
1697: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1698: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1699: THEN
1700: --{
1701: RAISE FND_API.G_EXC_ERROR;
1702: --RETURN;
1749: x_return_status => x_return_status
1750: );
1751: --
1752: --
1753: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1754: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1755: THEN
1756: --{
1757: RAISE FND_API.G_EXC_ERROR;
1750: );
1751: --
1752: --
1753: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1754: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1755: THEN
1756: --{
1757: RAISE FND_API.G_EXC_ERROR;
1758: --RETURN;
1824: x_return_status => x_return_status
1825: );
1826: --
1827: --
1828: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1829: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1830: THEN
1831: --{
1832: RAISE FND_API.G_EXC_ERROR;
1825: );
1826: --
1827: --
1828: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1829: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1830: THEN
1831: --{
1832: RAISE FND_API.G_EXC_ERROR;
1833: --RETURN;
1838: --
1839: IF l_number_of_errors > 0
1840: THEN
1841: ROLLBACK TO ASSIGN_SERVICE_TO_SEGMENT_PUB;
1842: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1843: ELSIF l_number_of_warnings > 0
1844: THEN
1845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1846: ELSE
1841: ROLLBACK TO ASSIGN_SERVICE_TO_SEGMENT_PUB;
1842: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1843: ELSIF l_number_of_warnings > 0
1844: THEN
1845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1846: ELSE
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1848: END IF;
1849: --
1843: ELSIF l_number_of_warnings > 0
1844: THEN
1845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1846: ELSE
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1848: END IF;
1849: --
1850: --
1851: -- Standard call to get message count and if count is 1,get message info.
1883: ROLLBACK TO ASSIGN_SERVICE_TO_SEGMENT_PUB;
1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1885: --
1886: --
1887: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.assign_service_to_segment');
1888: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1889: --
1890: --
1891: FND_MSG_PUB.Count_And_Get
1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1885: --
1886: --
1887: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.assign_service_to_segment');
1888: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1889: --
1890: --
1891: FND_MSG_PUB.Count_And_Get
1892: (
2119:
2120: --}
2121: BEGIN
2122: --{
2123: X_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2124: --
2125: -- INITIALIZATION
2126:
2127: IF l_debug_on THEN
2571: --}
2572: EXCEPTION
2573: --{
2574: WHEN OTHERS THEN
2575: wsh_util_core.default_handler('FTE_DELIVERY_LEGS.build_delivery_leg_info');
2576: FND_MESSAGE.SET_NAME('FTE','FTE_BLD_DLEG_UNEXP_ERROR');
2577: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
2578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get
2573: --{
2574: WHEN OTHERS THEN
2575: wsh_util_core.default_handler('FTE_DELIVERY_LEGS.build_delivery_leg_info');
2576: FND_MESSAGE.SET_NAME('FTE','FTE_BLD_DLEG_UNEXP_ERROR');
2577: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
2578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get
2580: (
2581: p_count => x_msg_count,
2574: WHEN OTHERS THEN
2575: wsh_util_core.default_handler('FTE_DELIVERY_LEGS.build_delivery_leg_info');
2576: FND_MESSAGE.SET_NAME('FTE','FTE_BLD_DLEG_UNEXP_ERROR');
2577: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
2578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get
2580: (
2581: p_count => x_msg_count,
2582: p_data => x_msg_data,