433: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);
434: END IF;
435: --
436: IF FND_API.to_Boolean( p_init_msg_list ) THEN
437: FND_MSG_PUB.initialize;
438: END IF;
439: --
440: Rtrim_deliveries_action(p_action_prms,l_action_prms);
441:
519: IF FND_API.To_Boolean( p_commit ) THEN
520: COMMIT WORK;
521: END IF;
522: --
523: FND_MSG_PUB.Count_And_Get (
524: p_count => x_msg_count,
525: p_data => x_msg_data);
526: --
527: IF l_debug_on THEN
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
534: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_And_Get
536: (
537: p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => FND_API.G_FALSE
546: --
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
550: FND_MSG_PUB.Count_And_Get
551: (
552: p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => FND_API.G_FALSE
560: END IF;
561: --
562: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
564: FND_MSG_PUB.Count_And_Get
565: (
566: p_count => x_msg_count,
567: p_data => x_msg_data,
568: p_encoded => FND_API.G_FALSE
576: WHEN OTHERS THEN
577: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
579: wsh_util_core.default_handler('WSH_INTERFACE_GRP.DELIVERY_ACTION');
580: FND_MSG_PUB.Count_And_Get
581: (
582: p_count => x_msg_count,
583: p_data => x_msg_data,
584: p_encoded => FND_API.G_FALSE
809: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
810: END IF;
811: --
812: IF FND_API.to_Boolean( p_init_msg_list ) THEN
813: FND_MSG_PUB.initialize;
814: END IF;
815: --
816: l_in_rec := p_in_rec;
817: l_in_rec.caller := RTRIM(p_in_rec.caller);
851: IF FND_API.To_Boolean( p_commit ) THEN
852: COMMIT WORK;
853: END IF;
854: --
855: FND_MSG_PUB.Count_And_Get (
856: p_count => x_msg_count,
857: p_data => x_msg_data);
858: --
859: IF l_debug_on THEN
863: EXCEPTION
864: WHEN FND_API.G_EXC_ERROR THEN
865: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
866: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
867: FND_MSG_PUB.Count_And_Get
868: (
869: p_count => x_msg_count,
870: p_data => x_msg_data,
871: p_encoded => FND_API.G_FALSE
878: --
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
882: FND_MSG_PUB.Count_And_Get
883: (
884: p_count => x_msg_count,
885: p_data => x_msg_data,
886: p_encoded => FND_API.G_FALSE
892: END IF;
893: --
894: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
895: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
896: FND_MSG_PUB.Count_And_Get
897: (
898: p_count => x_msg_count,
899: p_data => x_msg_data,
900: p_encoded => FND_API.G_FALSE
908: WHEN OTHERS THEN
909: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
911: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_DELIVERY');
912: FND_MSG_PUB.Count_And_Get
913: (
914: p_count => x_msg_count,
915: p_data => x_msg_data,
916: p_encoded => FND_API.G_FALSE
1034: --
1035:
1036: IF FND_API.to_Boolean( p_init_msg_list )
1037: THEN
1038: FND_MSG_PUB.initialize;
1039: END IF;
1040: --
1041: --
1042: -- Initialize API return status to success
1145: END IF;
1146: COMMIT WORK;
1147: END IF;
1148:
1149: FND_MSG_PUB.Count_And_Get
1150: (
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1162: x_return_status := FND_API.G_RET_STS_ERROR ;
1163: FND_MSG_PUB.Count_And_Get
1164: (
1165: p_count => x_msg_count,
1166: p_data => x_msg_data,
1167: p_encoded => FND_API.G_FALSE
1174: --
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178: FND_MSG_PUB.Count_And_Get
1179: (
1180: p_count => x_msg_count,
1181: p_data => x_msg_data,
1182: p_encoded => FND_API.G_FALSE
1188: END IF;
1189: --
1190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1192: FND_MSG_PUB.Count_And_Get
1193: (
1194: p_count => x_msg_count,
1195: p_data => x_msg_data,
1196: p_encoded => FND_API.G_FALSE
1204: WHEN OTHERS THEN
1205: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1206: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: FND_MSG_PUB.Count_And_Get
1209: (
1210: p_count => x_msg_count,
1211: p_data => x_msg_data,
1212: p_encoded => FND_API.G_FALSE
1431: --
1432: -- Initialize message list if p_init_msg_list is set to TRUE.
1433: IF FND_API.to_Boolean( p_init_msg_list )
1434: THEN
1435: FND_MSG_PUB.initialize;
1436: END IF;
1437: --
1438: --
1439: -- Initialize API return status to success
1499: END IF;
1500: COMMIT WORK;
1501: END IF;
1502:
1503: FND_MSG_PUB.Count_And_Get
1504: (
1505: p_count => x_msg_count,
1506: p_data => x_msg_data
1507: );
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1516: x_return_status := FND_API.G_RET_STS_ERROR ;
1517: FND_MSG_PUB.Count_And_Get
1518: (
1519: p_count => x_msg_count,
1520: p_data => x_msg_data,
1521: p_encoded => FND_API.G_FALSE
1528: --
1529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1530: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1532: FND_MSG_PUB.Count_And_Get
1533: (
1534: p_count => x_msg_count,
1535: p_data => x_msg_data,
1536: p_encoded => FND_API.G_FALSE
1543: END IF;
1544: --
1545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1546: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1547: FND_MSG_PUB.Count_And_Get
1548: (
1549: p_count => x_msg_count,
1550: p_data => x_msg_data,
1551: p_encoded => FND_API.G_FALSE
1559: WHEN OTHERS THEN
1560: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');
1561: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1563: FND_MSG_PUB.Count_And_Get
1564: (
1565: p_count => x_msg_count,
1566: p_data => x_msg_data,
1567: p_encoded => FND_API.G_FALSE
1724:
1725: IF l_num_warning > 0 THEN
1726: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1727: END IF;
1728: FND_MSG_PUB.Count_And_Get
1729: ( p_count => x_msg_count
1730: , p_data => x_msg_data
1731: );
1732:
1737:
1738: EXCEPTION
1739: WHEN FND_API.G_EXC_ERROR THEN
1740: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1741: FND_MSG_PUB.Count_And_Get
1742: ( p_count => x_msg_count
1743: , p_data => x_msg_data
1744: );
1745: IF l_debug_on THEN
1747: WSH_DEBUG_SV.pop(l_module_name);
1748: END IF;
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_count => x_msg_count
1753: , p_data => x_msg_data
1754: );
1755: IF l_debug_on THEN
1756: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1757: WSH_DEBUG_SV.pop(l_module_name);
1758: END IF;
1759: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1760: FND_MSG_PUB.Count_And_Get
1761: ( p_count => x_msg_count
1762: , p_data => x_msg_data
1763: );
1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1768: END IF;
1769: WHEN OTHERS THEN
1770: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1771: l_module_name);
1772: FND_MSG_PUB.Count_And_Get
1773: ( p_count => x_msg_count
1774: , p_data => x_msg_data
1775: );
1776:
1916: END IF;
1917:
1918: x_return_status := l_return_status;
1919:
1920: FND_MSG_PUB.Count_And_Get
1921: ( p_count => x_msg_count
1922: , p_data => x_msg_data
1923: );
1924:
1928:
1929: EXCEPTION
1930: WHEN FND_API.G_EXC_ERROR THEN
1931: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1932: FND_MSG_PUB.Count_And_Get
1933: ( p_count => x_msg_count
1934: , p_data => x_msg_data
1935: );
1936: IF l_debug_on THEN
1938: WSH_DEBUG_SV.pop(l_module_name);
1939: END IF;
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1942: FND_MSG_PUB.Count_And_Get
1943: ( p_count => x_msg_count
1944: , p_data => x_msg_data
1945: );
1946: IF l_debug_on THEN
1947: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1951: FND_MSG_PUB.Count_And_Get
1952: ( p_count => x_msg_count
1953: , p_data => x_msg_data
1954: );
1955: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1959: END IF;
1960: WHEN OTHERS THEN
1961: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',
1962: l_module_name);
1963: FND_MSG_PUB.Count_And_Get
1964: ( p_count => x_msg_count
1965: , p_data => x_msg_data
1966: );
1967:
2152: IF l_num_warnings > 0 THEN
2153: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2154: END IF;
2155: --
2156: FND_MSG_PUB.Count_And_Get (
2157: p_count => x_msg_count,
2158: p_data => x_msg_data);
2159: --
2160: IF l_debug_on THEN
2164: EXCEPTION
2165: WHEN FND_API.G_EXC_ERROR THEN
2166: ROLLBACK TO create_update_stop_wrap_grp;
2167: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2168: FND_MSG_PUB.Count_And_Get
2169: (
2170: p_count => x_msg_count,
2171: p_data => x_msg_data,
2172: p_encoded => FND_API.G_FALSE
2179: --
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: ROLLBACK TO create_update_stop_wrap_grp;
2182: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2183: FND_MSG_PUB.Count_And_Get
2184: (
2185: p_count => x_msg_count,
2186: p_data => x_msg_data,
2187: p_encoded => FND_API.G_FALSE
2193: END IF;
2194: --
2195: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2196: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2197: FND_MSG_PUB.Count_And_Get
2198: (
2199: p_count => x_msg_count,
2200: p_data => x_msg_data,
2201: p_encoded => FND_API.G_FALSE
2208: WHEN OTHERS THEN
2209: ROLLBACK TO create_update_stop_wrap_grp;
2210: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2211: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_STOP');
2212: FND_MSG_PUB.Count_And_Get
2213: (
2214: p_count => x_msg_count,
2215: p_data => x_msg_data,
2216: p_encoded => FND_API.G_FALSE
2396: IF l_num_warnings > 0 THEN
2397: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2398: END IF;
2399: --
2400: FND_MSG_PUB.Count_And_Get (
2401: p_count => x_msg_count,
2402: p_data => x_msg_data);
2403: --
2404: IF l_debug_on THEN
2408: EXCEPTION
2409: WHEN FND_API.G_EXC_ERROR THEN
2410: ROLLBACK TO create_update_trip_wrap_grp;
2411: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2412: FND_MSG_PUB.Count_And_Get
2413: (
2414: p_count => x_msg_count,
2415: p_data => x_msg_data,
2416: p_encoded => FND_API.G_FALSE
2423: --
2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2425: ROLLBACK TO create_update_trip_wrap_grp;
2426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
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
2437: END IF;
2438: --
2439: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2440: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2441: FND_MSG_PUB.Count_And_Get
2442: (
2443: p_count => x_msg_count,
2444: p_data => x_msg_data,
2445: p_encoded => FND_API.G_FALSE
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_update_trip_wrap_grp;
2454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2455: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP');
2456: FND_MSG_PUB.Count_And_Get
2457: (
2458: p_count => x_msg_count,
2459: p_data => x_msg_data,
2460: p_encoded => FND_API.G_FALSE
2608: IF l_num_warnings > 0 THEN
2609: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2610: END IF;
2611: --
2612: FND_MSG_PUB.Count_And_Get (
2613: p_count => x_msg_count,
2614: p_data => x_msg_data);
2615: --
2616: IF l_debug_on THEN
2620: EXCEPTION
2621: WHEN FND_API.G_EXC_ERROR THEN
2622: ROLLBACK TO Create_Update_Freight_Costs_WG;
2623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2624: FND_MSG_PUB.Count_And_Get
2625: (
2626: p_count => x_msg_count,
2627: p_data => x_msg_data,
2628: p_encoded => FND_API.G_FALSE
2635: --
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637: ROLLBACK TO Create_Update_Freight_Costs_WG;
2638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2639: FND_MSG_PUB.Count_And_Get
2640: (
2641: p_count => x_msg_count,
2642: p_data => x_msg_data,
2643: p_encoded => FND_API.G_FALSE
2649: END IF;
2650: --
2651: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2652: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2653: FND_MSG_PUB.Count_And_Get
2654: (
2655: p_count => x_msg_count,
2656: p_data => x_msg_data,
2657: p_encoded => FND_API.G_FALSE
2664: WHEN OTHERS THEN
2665: ROLLBACK TO Create_Update_Freight_Costs_WG;
2666: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2667: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_FREIGHT_COSTS');
2668: FND_MSG_PUB.Count_And_Get
2669: (
2670: p_count => x_msg_count,
2671: p_data => x_msg_data,
2672: p_encoded => FND_API.G_FALSE