[Home] [Help]
614: l_num_warning := l_num_warning + 1;
615: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
616: ELSE
617: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620:
621: --}
622: END IF;
636: END IF;
637: --
638: EXCEPTION
639: -- Pack J IB: KVENKATE
640: WHEN FND_API.G_EXC_ERROR THEN
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: IF l_debug_on THEN
643: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
644: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
639: -- Pack J IB: KVENKATE
640: WHEN FND_API.G_EXC_ERROR THEN
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: IF l_debug_on THEN
643: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
644: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
645: END IF;
646: --
647:
640: WHEN FND_API.G_EXC_ERROR THEN
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: IF l_debug_on THEN
643: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
644: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
645: END IF;
646: --
647:
648: WHEN others THEN
1920: IF get_trip_status%ISOPEN THEN
1921: CLOSE get_trip_status;
1922: END IF;
1923: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
1924: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR);
1925: x_return_status := FND_API.G_RET_STS_ERROR;
1926: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1927: if x_msg_count > 1 then
1928: x_msg_data := l_msg_summary || l_msg_details;
1921: CLOSE get_trip_status;
1922: END IF;
1923: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
1924: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR);
1925: x_return_status := FND_API.G_RET_STS_ERROR;
1926: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1927: if x_msg_count > 1 then
1928: x_msg_data := l_msg_summary || l_msg_details;
1929: else
1944: IF get_trip_status%ISOPEN THEN
1945: CLOSE get_trip_status;
1946: END IF;
1947: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
1948: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR);
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1951: if x_msg_count > 1 then
1952: x_msg_data := l_msg_summary || l_msg_details;
1945: CLOSE get_trip_status;
1946: END IF;
1947: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
1948: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR);
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1951: if x_msg_count > 1 then
1952: x_msg_data := l_msg_summary || l_msg_details;
1953: else
2462: END IF;
2463:
2464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2465:
2466: IF ((p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num)
2467: OR ((p_arr_after_trip_id IS NULL OR p_arr_after_trip_id=fnd_api.g_miss_num)
2468: and (p_arr_after_trip_name IS NULL or p_arr_after_trip_name=fnd_api.g_miss_char)
2469: )
2470: ) THEN
2463:
2464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2465:
2466: IF ((p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num)
2467: OR ((p_arr_after_trip_id IS NULL OR p_arr_after_trip_id=fnd_api.g_miss_num)
2468: and (p_arr_after_trip_name IS NULL or p_arr_after_trip_name=fnd_api.g_miss_char)
2469: )
2470: ) THEN
2471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2465:
2466: IF ((p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num)
2467: OR ((p_arr_after_trip_id IS NULL OR p_arr_after_trip_id=fnd_api.g_miss_num)
2468: and (p_arr_after_trip_name IS NULL or p_arr_after_trip_name=fnd_api.g_miss_char)
2469: )
2470: ) THEN
2471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2472: IF l_debug_on THEN
2486: OPEN get_trip_name(p_arr_after_trip_name);
2487: FETCH get_trip_name INTO l_status,p_arr_after_trip_id;
2488: CLOSE get_trip_name;
2489: ELSE
2490: l_status := FND_API.G_MISS_CHAR;
2491: END IF;
2492:
2493: IF (l_status IS NULL OR p_trip_id = p_arr_after_trip_id) THEN
2494: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2586:
2587: --if lane_id, carrier_id, ship_method_code, service_level, mode_of_transport are changed
2588: --or if mode is truck and vehicle item or vehicle org is changed, then mark leg for reprice
2589: IF (
2590: (nvl(p_trip_info.lane_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.lane_id,-99) <> nvl(l_lane_id,-99)))
2591: OR (nvl(p_trip_info.carrier_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.carrier_id,-99) <> nvl(l_carrier_id,-99)))
2592: OR (nvl(p_trip_info.ship_method_code,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.ship_method_code,'-99') <> nvl(l_ship_method_code,'-99')))
2593: OR (nvl(p_trip_info.service_level,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.service_level,'-99') <> nvl(l_service_level,'-99')))
2594: OR (nvl(p_trip_info.mode_of_transport,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.mode_of_transport,'-99') <> nvl(l_mode_of_transport,'-99')))
2587: --if lane_id, carrier_id, ship_method_code, service_level, mode_of_transport are changed
2588: --or if mode is truck and vehicle item or vehicle org is changed, then mark leg for reprice
2589: IF (
2590: (nvl(p_trip_info.lane_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.lane_id,-99) <> nvl(l_lane_id,-99)))
2591: OR (nvl(p_trip_info.carrier_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.carrier_id,-99) <> nvl(l_carrier_id,-99)))
2592: OR (nvl(p_trip_info.ship_method_code,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.ship_method_code,'-99') <> nvl(l_ship_method_code,'-99')))
2593: OR (nvl(p_trip_info.service_level,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.service_level,'-99') <> nvl(l_service_level,'-99')))
2594: OR (nvl(p_trip_info.mode_of_transport,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.mode_of_transport,'-99') <> nvl(l_mode_of_transport,'-99')))
2595: OR (
2588: --or if mode is truck and vehicle item or vehicle org is changed, then mark leg for reprice
2589: IF (
2590: (nvl(p_trip_info.lane_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.lane_id,-99) <> nvl(l_lane_id,-99)))
2591: OR (nvl(p_trip_info.carrier_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.carrier_id,-99) <> nvl(l_carrier_id,-99)))
2592: OR (nvl(p_trip_info.ship_method_code,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.ship_method_code,'-99') <> nvl(l_ship_method_code,'-99')))
2593: OR (nvl(p_trip_info.service_level,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.service_level,'-99') <> nvl(l_service_level,'-99')))
2594: OR (nvl(p_trip_info.mode_of_transport,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.mode_of_transport,'-99') <> nvl(l_mode_of_transport,'-99')))
2595: OR (
2596: (p_trip_info.mode_of_transport=l_c_truck OR l_mode_of_transport=l_c_truck)
2589: IF (
2590: (nvl(p_trip_info.lane_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.lane_id,-99) <> nvl(l_lane_id,-99)))
2591: OR (nvl(p_trip_info.carrier_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.carrier_id,-99) <> nvl(l_carrier_id,-99)))
2592: OR (nvl(p_trip_info.ship_method_code,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.ship_method_code,'-99') <> nvl(l_ship_method_code,'-99')))
2593: OR (nvl(p_trip_info.service_level,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.service_level,'-99') <> nvl(l_service_level,'-99')))
2594: OR (nvl(p_trip_info.mode_of_transport,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.mode_of_transport,'-99') <> nvl(l_mode_of_transport,'-99')))
2595: OR (
2596: (p_trip_info.mode_of_transport=l_c_truck OR l_mode_of_transport=l_c_truck)
2597: AND (
2590: (nvl(p_trip_info.lane_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.lane_id,-99) <> nvl(l_lane_id,-99)))
2591: OR (nvl(p_trip_info.carrier_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.carrier_id,-99) <> nvl(l_carrier_id,-99)))
2592: OR (nvl(p_trip_info.ship_method_code,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.ship_method_code,'-99') <> nvl(l_ship_method_code,'-99')))
2593: OR (nvl(p_trip_info.service_level,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.service_level,'-99') <> nvl(l_service_level,'-99')))
2594: OR (nvl(p_trip_info.mode_of_transport,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.mode_of_transport,'-99') <> nvl(l_mode_of_transport,'-99')))
2595: OR (
2596: (p_trip_info.mode_of_transport=l_c_truck OR l_mode_of_transport=l_c_truck)
2597: AND (
2598: (nvl(p_trip_info.vehicle_item_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.vehicle_item_id,-99) <> nvl(l_vehicle_item_id,-99)))
2594: OR (nvl(p_trip_info.mode_of_transport,'-99') <> FND_API.G_MISS_CHAR AND (nvl(p_trip_info.mode_of_transport,'-99') <> nvl(l_mode_of_transport,'-99')))
2595: OR (
2596: (p_trip_info.mode_of_transport=l_c_truck OR l_mode_of_transport=l_c_truck)
2597: AND (
2598: (nvl(p_trip_info.vehicle_item_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.vehicle_item_id,-99) <> nvl(l_vehicle_item_id,-99)))
2599: OR (nvl(p_trip_info.vehicle_organization_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.vehicle_organization_id,-99) <> nvl(l_vehicle_organization_id,-99)))
2600: )
2601: )
2602: ) THEN
2595: OR (
2596: (p_trip_info.mode_of_transport=l_c_truck OR l_mode_of_transport=l_c_truck)
2597: AND (
2598: (nvl(p_trip_info.vehicle_item_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.vehicle_item_id,-99) <> nvl(l_vehicle_item_id,-99)))
2599: OR (nvl(p_trip_info.vehicle_organization_id,-99) <> FND_API.G_MISS_NUM AND (nvl(p_trip_info.vehicle_organization_id,-99) <> nvl(l_vehicle_organization_id,-99)))
2600: )
2601: )
2602: ) THEN
2603: l_entity_ids(1):=p_trip_info.trip_id;
2640: )
2641: IS
2642: BEGIN
2643:
2644: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
2645: x_internal := p_internal;
2646: IF p_internal IS NULL THEN
2647: x_external := NULL;
2648: ELSE
2647: x_external := NULL;
2648: ELSE
2649: x_external := p_external;
2650: END IF;
2651: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
2652: x_external := p_external;
2653: IF x_external IS NULL THEN
2654: x_internal := NULL;
2655: ELSE
2675: )
2676: IS
2677: BEGIN
2678:
2679: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
2680: x_internal := p_internal;
2681: IF p_internal IS NULL THEN
2682: x_external := NULL;
2683: ELSE
2682: x_external := NULL;
2683: ELSE
2684: x_external := p_external;
2685: END IF;
2686: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
2687: x_external := p_external;
2688: IF x_external IS NULL THEN
2689: x_internal := NULL;
2690: ELSE
2707: /*
2708: Enable the x_delivery_detail_rec, with the columns that are not
2709: permanently disabled.
2710: */
2711: IF p_trip_rec.NAME <> FND_API.G_MISS_CHAR
2712: OR p_trip_rec.NAME IS NULL THEN
2713: x_trip_rec.NAME := p_trip_rec.NAME;
2714: END IF;
2715:
2717: p_trip_rec.ship_method_name,
2718: x_trip_rec.ship_method_code,
2719: x_trip_rec.ship_method_name);
2720:
2721: IF p_trip_rec.CARRIER_ID <> FND_API.G_MISS_NUM
2722: OR p_trip_rec.CARRIER_ID IS NULL THEN
2723: x_trip_rec.CARRIER_ID := p_trip_rec.CARRIER_ID;
2724: END IF;
2725:
2722: OR p_trip_rec.CARRIER_ID IS NULL THEN
2723: x_trip_rec.CARRIER_ID := p_trip_rec.CARRIER_ID;
2724: END IF;
2725:
2726: IF p_trip_rec.ROUTE_ID <> FND_API.G_MISS_NUM
2727: OR p_trip_rec.ROUTE_ID IS NULL THEN
2728: x_trip_rec.ROUTE_ID := p_trip_rec.ROUTE_ID;
2729: END IF;
2730: IF p_trip_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
2726: IF p_trip_rec.ROUTE_ID <> FND_API.G_MISS_NUM
2727: OR p_trip_rec.ROUTE_ID IS NULL THEN
2728: x_trip_rec.ROUTE_ID := p_trip_rec.ROUTE_ID;
2729: END IF;
2730: IF p_trip_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
2731: OR p_trip_rec.FREIGHT_TERMS_CODE IS NULL THEN
2732: x_trip_rec.FREIGHT_TERMS_CODE := p_trip_rec.FREIGHT_TERMS_CODE;
2733: END IF;
2734: IF p_trip_rec.LOAD_TENDER_STATUS <> FND_API.G_MISS_CHAR
2730: IF p_trip_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
2731: OR p_trip_rec.FREIGHT_TERMS_CODE IS NULL THEN
2732: x_trip_rec.FREIGHT_TERMS_CODE := p_trip_rec.FREIGHT_TERMS_CODE;
2733: END IF;
2734: IF p_trip_rec.LOAD_TENDER_STATUS <> FND_API.G_MISS_CHAR
2735: OR p_trip_rec.LOAD_TENDER_STATUS IS NULL THEN
2736: x_trip_rec.LOAD_TENDER_STATUS := p_trip_rec.LOAD_TENDER_STATUS;
2737: END IF;
2738: IF p_trip_rec.LOAD_TENDER_NUMBER <> FND_API.G_MISS_NUM
2734: IF p_trip_rec.LOAD_TENDER_STATUS <> FND_API.G_MISS_CHAR
2735: OR p_trip_rec.LOAD_TENDER_STATUS IS NULL THEN
2736: x_trip_rec.LOAD_TENDER_STATUS := p_trip_rec.LOAD_TENDER_STATUS;
2737: END IF;
2738: IF p_trip_rec.LOAD_TENDER_NUMBER <> FND_API.G_MISS_NUM
2739: OR p_trip_rec.LOAD_TENDER_NUMBER IS NULL THEN
2740: x_trip_rec.LOAD_TENDER_NUMBER := p_trip_rec.LOAD_TENDER_NUMBER;
2741: END IF;
2742: IF p_trip_rec.VESSEL <> FND_API.G_MISS_CHAR
2738: IF p_trip_rec.LOAD_TENDER_NUMBER <> FND_API.G_MISS_NUM
2739: OR p_trip_rec.LOAD_TENDER_NUMBER IS NULL THEN
2740: x_trip_rec.LOAD_TENDER_NUMBER := p_trip_rec.LOAD_TENDER_NUMBER;
2741: END IF;
2742: IF p_trip_rec.VESSEL <> FND_API.G_MISS_CHAR
2743: OR p_trip_rec.VESSEL IS NULL THEN
2744: x_trip_rec.VESSEL := p_trip_rec.VESSEL;
2745: END IF;
2746: IF p_trip_rec.VOYAGE_NUMBER <> FND_API.G_MISS_CHAR
2742: IF p_trip_rec.VESSEL <> FND_API.G_MISS_CHAR
2743: OR p_trip_rec.VESSEL IS NULL THEN
2744: x_trip_rec.VESSEL := p_trip_rec.VESSEL;
2745: END IF;
2746: IF p_trip_rec.VOYAGE_NUMBER <> FND_API.G_MISS_CHAR
2747: OR p_trip_rec.VOYAGE_NUMBER IS NULL THEN
2748: x_trip_rec.VOYAGE_NUMBER := p_trip_rec.VOYAGE_NUMBER;
2749: END IF;
2750: IF p_trip_rec.PORT_OF_LOADING <> FND_API.G_MISS_CHAR
2746: IF p_trip_rec.VOYAGE_NUMBER <> FND_API.G_MISS_CHAR
2747: OR p_trip_rec.VOYAGE_NUMBER IS NULL THEN
2748: x_trip_rec.VOYAGE_NUMBER := p_trip_rec.VOYAGE_NUMBER;
2749: END IF;
2750: IF p_trip_rec.PORT_OF_LOADING <> FND_API.G_MISS_CHAR
2751: OR p_trip_rec.PORT_OF_LOADING IS NULL THEN
2752: x_trip_rec.PORT_OF_LOADING:= p_trip_rec.PORT_OF_LOADING;
2753: END IF;
2754: IF p_trip_rec.PORT_OF_DISCHARGE <> FND_API.G_MISS_CHAR
2750: IF p_trip_rec.PORT_OF_LOADING <> FND_API.G_MISS_CHAR
2751: OR p_trip_rec.PORT_OF_LOADING IS NULL THEN
2752: x_trip_rec.PORT_OF_LOADING:= p_trip_rec.PORT_OF_LOADING;
2753: END IF;
2754: IF p_trip_rec.PORT_OF_DISCHARGE <> FND_API.G_MISS_CHAR
2755: OR p_trip_rec.PORT_OF_DISCHARGE IS NULL THEN
2756: x_trip_rec.PORT_OF_DISCHARGE := p_trip_rec.PORT_OF_DISCHARGE;
2757: END IF;
2758: IF p_trip_rec.WF_NAME <> FND_API.G_MISS_CHAR
2754: IF p_trip_rec.PORT_OF_DISCHARGE <> FND_API.G_MISS_CHAR
2755: OR p_trip_rec.PORT_OF_DISCHARGE IS NULL THEN
2756: x_trip_rec.PORT_OF_DISCHARGE := p_trip_rec.PORT_OF_DISCHARGE;
2757: END IF;
2758: IF p_trip_rec.WF_NAME <> FND_API.G_MISS_CHAR
2759: OR p_trip_rec.WF_NAME IS NULL THEN
2760: x_trip_rec.WF_NAME := p_trip_rec.WF_NAME;
2761: END IF;
2762: IF p_trip_rec.WF_PROCESS_NAME <> FND_API.G_MISS_CHAR
2758: IF p_trip_rec.WF_NAME <> FND_API.G_MISS_CHAR
2759: OR p_trip_rec.WF_NAME IS NULL THEN
2760: x_trip_rec.WF_NAME := p_trip_rec.WF_NAME;
2761: END IF;
2762: IF p_trip_rec.WF_PROCESS_NAME <> FND_API.G_MISS_CHAR
2763: OR p_trip_rec.WF_PROCESS_NAME IS NULL THEN
2764: x_trip_rec.WF_PROCESS_NAME := p_trip_rec.WF_PROCESS_NAME;
2765: END IF;
2766: IF p_trip_rec.WF_ITEM_KEY <> FND_API.G_MISS_CHAR
2762: IF p_trip_rec.WF_PROCESS_NAME <> FND_API.G_MISS_CHAR
2763: OR p_trip_rec.WF_PROCESS_NAME IS NULL THEN
2764: x_trip_rec.WF_PROCESS_NAME := p_trip_rec.WF_PROCESS_NAME;
2765: END IF;
2766: IF p_trip_rec.WF_ITEM_KEY <> FND_API.G_MISS_CHAR
2767: OR p_trip_rec.WF_ITEM_KEY IS NULL THEN
2768: x_trip_rec.WF_ITEM_KEY := p_trip_rec.WF_ITEM_KEY;
2769: END IF;
2770: IF p_trip_rec.CARRIER_CONTACT_ID <> FND_API.G_MISS_NUM
2766: IF p_trip_rec.WF_ITEM_KEY <> FND_API.G_MISS_CHAR
2767: OR p_trip_rec.WF_ITEM_KEY IS NULL THEN
2768: x_trip_rec.WF_ITEM_KEY := p_trip_rec.WF_ITEM_KEY;
2769: END IF;
2770: IF p_trip_rec.CARRIER_CONTACT_ID <> FND_API.G_MISS_NUM
2771: OR p_trip_rec.CARRIER_CONTACT_ID IS NULL THEN
2772: x_trip_rec.CARRIER_CONTACT_ID := p_trip_rec.CARRIER_CONTACT_ID;
2773: END IF;
2774: IF p_trip_rec.SHIPPER_WAIT_TIME <> FND_API.G_MISS_NUM
2770: IF p_trip_rec.CARRIER_CONTACT_ID <> FND_API.G_MISS_NUM
2771: OR p_trip_rec.CARRIER_CONTACT_ID IS NULL THEN
2772: x_trip_rec.CARRIER_CONTACT_ID := p_trip_rec.CARRIER_CONTACT_ID;
2773: END IF;
2774: IF p_trip_rec.SHIPPER_WAIT_TIME <> FND_API.G_MISS_NUM
2775: OR p_trip_rec.SHIPPER_WAIT_TIME IS NULL THEN
2776: x_trip_rec.SHIPPER_WAIT_TIME := p_trip_rec.SHIPPER_WAIT_TIME;
2777: END IF;
2778: IF p_trip_rec.WAIT_TIME_UOM <> FND_API.G_MISS_CHAR
2774: IF p_trip_rec.SHIPPER_WAIT_TIME <> FND_API.G_MISS_NUM
2775: OR p_trip_rec.SHIPPER_WAIT_TIME IS NULL THEN
2776: x_trip_rec.SHIPPER_WAIT_TIME := p_trip_rec.SHIPPER_WAIT_TIME;
2777: END IF;
2778: IF p_trip_rec.WAIT_TIME_UOM <> FND_API.G_MISS_CHAR
2779: OR p_trip_rec.WAIT_TIME_UOM IS NULL THEN
2780: x_trip_rec.WAIT_TIME_UOM := p_trip_rec.WAIT_TIME_UOM;
2781: END IF;
2782: IF p_trip_rec.LOAD_TENDERED_TIME <> FND_API.G_MISS_DATE
2778: IF p_trip_rec.WAIT_TIME_UOM <> FND_API.G_MISS_CHAR
2779: OR p_trip_rec.WAIT_TIME_UOM IS NULL THEN
2780: x_trip_rec.WAIT_TIME_UOM := p_trip_rec.WAIT_TIME_UOM;
2781: END IF;
2782: IF p_trip_rec.LOAD_TENDERED_TIME <> FND_API.G_MISS_DATE
2783: OR p_trip_rec.LOAD_TENDERED_TIME IS NULL THEN
2784: x_trip_rec.LOAD_TENDERED_TIME := p_trip_rec.LOAD_TENDERED_TIME;
2785: END IF;
2786: IF p_trip_rec.CARRIER_RESPONSE <> FND_API.G_MISS_CHAR
2782: IF p_trip_rec.LOAD_TENDERED_TIME <> FND_API.G_MISS_DATE
2783: OR p_trip_rec.LOAD_TENDERED_TIME IS NULL THEN
2784: x_trip_rec.LOAD_TENDERED_TIME := p_trip_rec.LOAD_TENDERED_TIME;
2785: END IF;
2786: IF p_trip_rec.CARRIER_RESPONSE <> FND_API.G_MISS_CHAR
2787: OR p_trip_rec.CARRIER_RESPONSE IS NULL THEN
2788: x_trip_rec.CARRIER_RESPONSE := p_trip_rec.CARRIER_RESPONSE;
2789: END IF;
2790:
2787: OR p_trip_rec.CARRIER_RESPONSE IS NULL THEN
2788: x_trip_rec.CARRIER_RESPONSE := p_trip_rec.CARRIER_RESPONSE;
2789: END IF;
2790:
2791: IF p_trip_rec.ROUTE_LANE_ID <> FND_API.G_MISS_NUM
2792: OR p_trip_rec.ROUTE_LANE_ID IS NULL THEN
2793: x_trip_rec.ROUTE_LANE_ID := p_trip_rec.ROUTE_LANE_ID;
2794: END IF;
2795: IF p_trip_rec.LANE_ID <> FND_API.G_MISS_NUM
2791: IF p_trip_rec.ROUTE_LANE_ID <> FND_API.G_MISS_NUM
2792: OR p_trip_rec.ROUTE_LANE_ID IS NULL THEN
2793: x_trip_rec.ROUTE_LANE_ID := p_trip_rec.ROUTE_LANE_ID;
2794: END IF;
2795: IF p_trip_rec.LANE_ID <> FND_API.G_MISS_NUM
2796: OR p_trip_rec.LANE_ID IS NULL THEN
2797: x_trip_rec.LANE_ID := p_trip_rec.LANE_ID;
2798: END IF;
2799: IF p_trip_rec.SCHEDULE_ID <> FND_API.G_MISS_NUM
2795: IF p_trip_rec.LANE_ID <> FND_API.G_MISS_NUM
2796: OR p_trip_rec.LANE_ID IS NULL THEN
2797: x_trip_rec.LANE_ID := p_trip_rec.LANE_ID;
2798: END IF;
2799: IF p_trip_rec.SCHEDULE_ID <> FND_API.G_MISS_NUM
2800: OR p_trip_rec.SCHEDULE_ID IS NULL THEN
2801: x_trip_rec.SCHEDULE_ID := p_trip_rec.SCHEDULE_ID;
2802: END IF;
2803: IF p_trip_rec.BOOKING_NUMBER <> FND_API.G_MISS_CHAR
2799: IF p_trip_rec.SCHEDULE_ID <> FND_API.G_MISS_NUM
2800: OR p_trip_rec.SCHEDULE_ID IS NULL THEN
2801: x_trip_rec.SCHEDULE_ID := p_trip_rec.SCHEDULE_ID;
2802: END IF;
2803: IF p_trip_rec.BOOKING_NUMBER <> FND_API.G_MISS_CHAR
2804: OR p_trip_rec.BOOKING_NUMBER IS NULL THEN
2805: x_trip_rec.BOOKING_NUMBER := p_trip_rec.BOOKING_NUMBER;
2806: END IF;
2807:
2804: OR p_trip_rec.BOOKING_NUMBER IS NULL THEN
2805: x_trip_rec.BOOKING_NUMBER := p_trip_rec.BOOKING_NUMBER;
2806: END IF;
2807:
2808: IF p_trip_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
2809: OR p_trip_rec.SERVICE_LEVEL IS NULL THEN
2810: x_trip_rec.SERVICE_LEVEL := p_trip_rec.SERVICE_LEVEL;
2811: END IF;
2812: IF p_trip_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
2808: IF p_trip_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
2809: OR p_trip_rec.SERVICE_LEVEL IS NULL THEN
2810: x_trip_rec.SERVICE_LEVEL := p_trip_rec.SERVICE_LEVEL;
2811: END IF;
2812: IF p_trip_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
2813: OR p_trip_rec.MODE_OF_TRANSPORT IS NULL THEN
2814: x_trip_rec.MODE_OF_TRANSPORT := p_trip_rec.MODE_OF_TRANSPORT;
2815: END IF;
2816: IF p_trip_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR
2812: IF p_trip_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
2813: OR p_trip_rec.MODE_OF_TRANSPORT IS NULL THEN
2814: x_trip_rec.MODE_OF_TRANSPORT := p_trip_rec.MODE_OF_TRANSPORT;
2815: END IF;
2816: IF p_trip_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR
2817: AND (p_in_rec.CALLER LIKE 'FTE%' OR p_in_rec.CALLER LIKE 'WSH_CONSOL%')
2818: AND p_in_rec.ACTION_CODE = 'CREATE' THEN
2819: -- bug 3694794: FTE needs to create trip with ignore = Y
2820: x_trip_rec.IGNORE_FOR_PLANNING := p_trip_rec.IGNORE_FOR_PLANNING;
2828: p_trip_rec.VEHICLE_ITEM_DESC,
2829: x_trip_rec.VEHICLE_ITEM_ID,
2830: x_trip_rec.VEHICLE_ITEM_DESC);
2831:
2832: IF p_trip_rec.VEHICLE_NUM_PREFIX <> FND_API.G_MISS_CHAR
2833: OR p_trip_rec.VEHICLE_NUM_PREFIX IS NULL THEN
2834: x_trip_rec.VEHICLE_NUM_PREFIX := p_trip_rec.VEHICLE_NUM_PREFIX;
2835: END IF;
2836: IF p_trip_rec.VEHICLE_NUMBER <> FND_API.G_MISS_CHAR
2832: IF p_trip_rec.VEHICLE_NUM_PREFIX <> FND_API.G_MISS_CHAR
2833: OR p_trip_rec.VEHICLE_NUM_PREFIX IS NULL THEN
2834: x_trip_rec.VEHICLE_NUM_PREFIX := p_trip_rec.VEHICLE_NUM_PREFIX;
2835: END IF;
2836: IF p_trip_rec.VEHICLE_NUMBER <> FND_API.G_MISS_CHAR
2837: OR p_trip_rec.VEHICLE_NUMBER IS NULL THEN
2838: x_trip_rec.VEHICLE_NUMBER := p_trip_rec.VEHICLE_NUMBER;
2839: END IF;
2840:
2842: p_trip_rec.ARRIVE_AFTER_TRIP_NAME,
2843: x_trip_rec.ARRIVE_AFTER_TRIP_ID,
2844: x_trip_rec.ARRIVE_AFTER_TRIP_NAME);
2845:
2846: IF p_trip_rec.ROUTING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
2847: OR p_trip_rec.ROUTING_INSTRUCTIONS IS NULL THEN
2848: x_trip_rec.ROUTING_INSTRUCTIONS := p_trip_rec.ROUTING_INSTRUCTIONS;
2849: END IF;
2850: IF p_trip_rec.CONSOLIDATION_ALLOWED <> FND_API.G_MISS_CHAR
2846: IF p_trip_rec.ROUTING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
2847: OR p_trip_rec.ROUTING_INSTRUCTIONS IS NULL THEN
2848: x_trip_rec.ROUTING_INSTRUCTIONS := p_trip_rec.ROUTING_INSTRUCTIONS;
2849: END IF;
2850: IF p_trip_rec.CONSOLIDATION_ALLOWED <> FND_API.G_MISS_CHAR
2851: OR p_trip_rec.CONSOLIDATION_ALLOWED IS NULL THEN
2852: x_trip_rec.CONSOLIDATION_ALLOWED := p_trip_rec.CONSOLIDATION_ALLOWED;
2853: END IF;
2854: IF p_trip_rec.OPERATOR <> FND_API.G_MISS_CHAR
2850: IF p_trip_rec.CONSOLIDATION_ALLOWED <> FND_API.G_MISS_CHAR
2851: OR p_trip_rec.CONSOLIDATION_ALLOWED IS NULL THEN
2852: x_trip_rec.CONSOLIDATION_ALLOWED := p_trip_rec.CONSOLIDATION_ALLOWED;
2853: END IF;
2854: IF p_trip_rec.OPERATOR <> FND_API.G_MISS_CHAR
2855: OR p_trip_rec.OPERATOR IS NULL THEN
2856: x_trip_rec.OPERATOR := p_trip_rec.OPERATOR;
2857: END IF;
2858:
2855: OR p_trip_rec.OPERATOR IS NULL THEN
2856: x_trip_rec.OPERATOR := p_trip_rec.OPERATOR;
2857: END IF;
2858:
2859: IF p_trip_rec.attribute1 <> FND_API.G_MISS_CHAR
2860: OR p_trip_rec.attribute1 IS NULL THEN
2861: x_trip_rec.attribute1 := p_trip_rec.attribute1;
2862: END IF;
2863: IF p_trip_rec.attribute2 <> FND_API.G_MISS_CHAR
2859: IF p_trip_rec.attribute1 <> FND_API.G_MISS_CHAR
2860: OR p_trip_rec.attribute1 IS NULL THEN
2861: x_trip_rec.attribute1 := p_trip_rec.attribute1;
2862: END IF;
2863: IF p_trip_rec.attribute2 <> FND_API.G_MISS_CHAR
2864: OR p_trip_rec.attribute2 IS NULL THEN
2865: x_trip_rec.attribute2 := p_trip_rec.attribute2;
2866: END IF;
2867: IF p_trip_rec.attribute3 <> FND_API.G_MISS_CHAR
2863: IF p_trip_rec.attribute2 <> FND_API.G_MISS_CHAR
2864: OR p_trip_rec.attribute2 IS NULL THEN
2865: x_trip_rec.attribute2 := p_trip_rec.attribute2;
2866: END IF;
2867: IF p_trip_rec.attribute3 <> FND_API.G_MISS_CHAR
2868: OR p_trip_rec.attribute3 IS NULL THEN
2869: x_trip_rec.attribute3 := p_trip_rec.attribute3;
2870: END IF;
2871: IF p_trip_rec.attribute4 <> FND_API.G_MISS_CHAR
2867: IF p_trip_rec.attribute3 <> FND_API.G_MISS_CHAR
2868: OR p_trip_rec.attribute3 IS NULL THEN
2869: x_trip_rec.attribute3 := p_trip_rec.attribute3;
2870: END IF;
2871: IF p_trip_rec.attribute4 <> FND_API.G_MISS_CHAR
2872: OR p_trip_rec.attribute4 IS NULL THEN
2873: x_trip_rec.attribute4 := p_trip_rec.attribute4;
2874: END IF;
2875: IF p_trip_rec.attribute5 <> FND_API.G_MISS_CHAR
2871: IF p_trip_rec.attribute4 <> FND_API.G_MISS_CHAR
2872: OR p_trip_rec.attribute4 IS NULL THEN
2873: x_trip_rec.attribute4 := p_trip_rec.attribute4;
2874: END IF;
2875: IF p_trip_rec.attribute5 <> FND_API.G_MISS_CHAR
2876: OR p_trip_rec.attribute5 IS NULL THEN
2877: x_trip_rec.attribute5 := p_trip_rec.attribute5;
2878: END IF;
2879: IF p_trip_rec.attribute6 <> FND_API.G_MISS_CHAR
2875: IF p_trip_rec.attribute5 <> FND_API.G_MISS_CHAR
2876: OR p_trip_rec.attribute5 IS NULL THEN
2877: x_trip_rec.attribute5 := p_trip_rec.attribute5;
2878: END IF;
2879: IF p_trip_rec.attribute6 <> FND_API.G_MISS_CHAR
2880: OR p_trip_rec.attribute6 IS NULL THEN
2881: x_trip_rec.attribute6 := p_trip_rec.attribute6;
2882: END IF;
2883: IF p_trip_rec.attribute7 <> FND_API.G_MISS_CHAR
2879: IF p_trip_rec.attribute6 <> FND_API.G_MISS_CHAR
2880: OR p_trip_rec.attribute6 IS NULL THEN
2881: x_trip_rec.attribute6 := p_trip_rec.attribute6;
2882: END IF;
2883: IF p_trip_rec.attribute7 <> FND_API.G_MISS_CHAR
2884: OR p_trip_rec.attribute7 IS NULL THEN
2885: x_trip_rec.attribute7 := p_trip_rec.attribute7;
2886: END IF;
2887: IF p_trip_rec.attribute8 <> FND_API.G_MISS_CHAR
2883: IF p_trip_rec.attribute7 <> FND_API.G_MISS_CHAR
2884: OR p_trip_rec.attribute7 IS NULL THEN
2885: x_trip_rec.attribute7 := p_trip_rec.attribute7;
2886: END IF;
2887: IF p_trip_rec.attribute8 <> FND_API.G_MISS_CHAR
2888: OR p_trip_rec.attribute8 IS NULL THEN
2889: x_trip_rec.attribute8 := p_trip_rec.attribute8;
2890: END IF;
2891: IF p_trip_rec.attribute9 <> FND_API.G_MISS_CHAR
2887: IF p_trip_rec.attribute8 <> FND_API.G_MISS_CHAR
2888: OR p_trip_rec.attribute8 IS NULL THEN
2889: x_trip_rec.attribute8 := p_trip_rec.attribute8;
2890: END IF;
2891: IF p_trip_rec.attribute9 <> FND_API.G_MISS_CHAR
2892: OR p_trip_rec.attribute9 IS NULL THEN
2893: x_trip_rec.attribute9 := p_trip_rec.attribute9;
2894: END IF;
2895: IF p_trip_rec.attribute10 <> FND_API.G_MISS_CHAR
2891: IF p_trip_rec.attribute9 <> FND_API.G_MISS_CHAR
2892: OR p_trip_rec.attribute9 IS NULL THEN
2893: x_trip_rec.attribute9 := p_trip_rec.attribute9;
2894: END IF;
2895: IF p_trip_rec.attribute10 <> FND_API.G_MISS_CHAR
2896: OR p_trip_rec.attribute10 IS NULL THEN
2897: x_trip_rec.attribute10 := p_trip_rec.attribute10;
2898: END IF;
2899: IF p_trip_rec.attribute11 <> FND_API.G_MISS_CHAR
2895: IF p_trip_rec.attribute10 <> FND_API.G_MISS_CHAR
2896: OR p_trip_rec.attribute10 IS NULL THEN
2897: x_trip_rec.attribute10 := p_trip_rec.attribute10;
2898: END IF;
2899: IF p_trip_rec.attribute11 <> FND_API.G_MISS_CHAR
2900: OR p_trip_rec.attribute11 IS NULL THEN
2901: x_trip_rec.attribute11 := p_trip_rec.attribute11;
2902: END IF;
2903: IF p_trip_rec.attribute12 <> FND_API.G_MISS_CHAR
2899: IF p_trip_rec.attribute11 <> FND_API.G_MISS_CHAR
2900: OR p_trip_rec.attribute11 IS NULL THEN
2901: x_trip_rec.attribute11 := p_trip_rec.attribute11;
2902: END IF;
2903: IF p_trip_rec.attribute12 <> FND_API.G_MISS_CHAR
2904: OR p_trip_rec.attribute12 IS NULL THEN
2905: x_trip_rec.attribute12 := p_trip_rec.attribute12;
2906: END IF;
2907: IF p_trip_rec.attribute13 <> FND_API.G_MISS_CHAR
2903: IF p_trip_rec.attribute12 <> FND_API.G_MISS_CHAR
2904: OR p_trip_rec.attribute12 IS NULL THEN
2905: x_trip_rec.attribute12 := p_trip_rec.attribute12;
2906: END IF;
2907: IF p_trip_rec.attribute13 <> FND_API.G_MISS_CHAR
2908: OR p_trip_rec.attribute13 IS NULL THEN
2909: x_trip_rec.attribute13 := p_trip_rec.attribute13;
2910: END IF;
2911: IF p_trip_rec.attribute14 <> FND_API.G_MISS_CHAR
2907: IF p_trip_rec.attribute13 <> FND_API.G_MISS_CHAR
2908: OR p_trip_rec.attribute13 IS NULL THEN
2909: x_trip_rec.attribute13 := p_trip_rec.attribute13;
2910: END IF;
2911: IF p_trip_rec.attribute14 <> FND_API.G_MISS_CHAR
2912: OR p_trip_rec.attribute14 IS NULL THEN
2913: x_trip_rec.attribute14 := p_trip_rec.attribute14;
2914: END IF;
2915: IF p_trip_rec.attribute15 <> FND_API.G_MISS_CHAR
2911: IF p_trip_rec.attribute14 <> FND_API.G_MISS_CHAR
2912: OR p_trip_rec.attribute14 IS NULL THEN
2913: x_trip_rec.attribute14 := p_trip_rec.attribute14;
2914: END IF;
2915: IF p_trip_rec.attribute15 <> FND_API.G_MISS_CHAR
2916: OR p_trip_rec.attribute15 IS NULL THEN
2917: x_trip_rec.attribute15 := p_trip_rec.attribute15;
2918: END IF;
2919: IF p_trip_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
2915: IF p_trip_rec.attribute15 <> FND_API.G_MISS_CHAR
2916: OR p_trip_rec.attribute15 IS NULL THEN
2917: x_trip_rec.attribute15 := p_trip_rec.attribute15;
2918: END IF;
2919: IF p_trip_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
2920: OR p_trip_rec.ATTRIBUTE_CATEGORY IS NULL THEN
2921: x_trip_rec.ATTRIBUTE_CATEGORY := p_trip_rec.ATTRIBUTE_CATEGORY;
2922: END IF;
2923: -- OTM R12, glog project, allow GC3 Inbound Message to update tp_plan_name
2921: x_trip_rec.ATTRIBUTE_CATEGORY := p_trip_rec.ATTRIBUTE_CATEGORY;
2922: END IF;
2923: -- OTM R12, glog project, allow GC3 Inbound Message to update tp_plan_name
2924: IF p_in_rec.caller IN ('WSH_TP_RELEASE','FTE_TMS_INTEGRATION') THEN
2925: IF p_trip_rec.tp_plan_name <> FND_API.G_MISS_CHAR
2926: OR p_trip_rec.tp_plan_name IS NULL THEN
2927: x_trip_rec.tp_plan_name := p_trip_rec.tp_plan_name;
2928: END IF;
2929: IF p_trip_rec.tp_trip_number <> FND_API.G_MISS_NUM
2925: IF p_trip_rec.tp_plan_name <> FND_API.G_MISS_CHAR
2926: OR p_trip_rec.tp_plan_name IS NULL THEN
2927: x_trip_rec.tp_plan_name := p_trip_rec.tp_plan_name;
2928: END IF;
2929: IF p_trip_rec.tp_trip_number <> FND_API.G_MISS_NUM
2930: OR p_trip_rec.tp_trip_number IS NULL THEN
2931: x_trip_rec.tp_trip_number := p_trip_rec.tp_trip_number;
2932: END IF;
2933: END IF;
2936: 'FTE_RATING',
2937: 'FTE_LOAD_TENDER',
2938: 'FTE_MLS_WRAPPER') THEN
2939:
2940: IF p_trip_rec.rank_id <> FND_API.G_MISS_NUM
2941: OR p_trip_rec.rank_id IS NULL THEN
2942: x_trip_rec.rank_id := p_trip_rec.rank_id;
2943: END IF;
2944:
2947: IF p_in_rec.caller IN ('FTE_ROUTING_GUIDE',
2948: 'FTE_RATING',
2949: 'FTE_LOAD_TENDER') THEN
2950:
2951: IF p_trip_rec.routing_rule_id <> FND_API.G_MISS_NUM
2952: OR p_trip_rec.routing_rule_id IS NULL THEN
2953: x_trip_rec.routing_rule_id := p_trip_rec.routing_rule_id;
2954: END IF;
2955:
2952: OR p_trip_rec.routing_rule_id IS NULL THEN
2953: x_trip_rec.routing_rule_id := p_trip_rec.routing_rule_id;
2954: END IF;
2955:
2956: IF p_trip_rec.append_flag <> FND_API.G_MISS_CHAR
2957: OR p_trip_rec.append_flag IS NULL THEN
2958: x_trip_rec.append_flag := p_trip_rec.append_flag;
2959: END IF;
2960:
2959: END IF;
2960:
2961: END IF;
2962:
2963: IF p_trip_rec.consignee_carrier_ac_no <> FND_API.G_MISS_CHAR
2964: OR p_trip_rec.consignee_carrier_ac_no IS NULL THEN
2965: x_trip_rec.consignee_carrier_ac_no := p_trip_rec.consignee_carrier_ac_no;
2966: END IF;
2967:
2964: OR p_trip_rec.consignee_carrier_ac_no IS NULL THEN
2965: x_trip_rec.consignee_carrier_ac_no := p_trip_rec.consignee_carrier_ac_no;
2966: END IF;
2967:
2968: IF p_trip_rec.carrier_reference_number <> FND_API.G_MISS_CHAR
2969: OR p_trip_rec.carrier_reference_number IS NULL THEN
2970: x_trip_rec.carrier_reference_number := p_trip_rec.carrier_reference_number;
2971: END IF;
2972:
2969: OR p_trip_rec.carrier_reference_number IS NULL THEN
2970: x_trip_rec.carrier_reference_number := p_trip_rec.carrier_reference_number;
2971: END IF;
2972:
2973: IF p_trip_rec.seal_code <> FND_API.G_MISS_CHAR
2974: OR p_trip_rec.seal_code IS NULL THEN
2975: x_trip_rec.seal_code := p_trip_rec.seal_code;
2976: END IF;
2977:
3058: BEGIN
3059:
3060: IF p_mode = '+' THEN
3061: IF x_internal IS NULL THEN
3062: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
3063: x_internal := p_internal ;
3064: IF p_internal IS NULL THEN
3065: x_external := NULL;
3066: ELSE
3065: x_external := NULL;
3066: ELSE
3067: x_external := p_external;
3068: END IF;
3069: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
3070: x_external := p_external;
3071: IF p_external IS NULL THEN
3072: x_internal := NULL;
3073: ELSE
3075: END IF;
3076: END IF;
3077: END IF;
3078: ELSE --p_mode <> +
3079: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
3080: x_internal := p_internal ;
3081: IF p_internal IS NULL THEN
3082: x_external := NULL;
3083: ELSE
3082: x_external := NULL;
3083: ELSE
3084: x_external := p_external;
3085: END IF;
3086: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
3087: x_external := p_external;
3088: IF p_external IS NULL THEN
3089: x_internal := NULL;
3090: ELSE
3112: BEGIN
3113:
3114: IF p_mode = '+' THEN
3115: IF x_internal IS NULL THEN
3116: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
3117: x_internal := p_internal ;
3118: IF p_internal IS NULL THEN
3119: x_external := NULL;
3120: ELSE
3119: x_external := NULL;
3120: ELSE
3121: x_external := p_external;
3122: END IF;
3123: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
3124: x_external := p_external;
3125: IF p_external IS NULL THEN
3126: x_internal := NULL;
3127: ELSE
3129: END IF;
3130: END IF;
3131: END IF;
3132: ELSE --p_mode <> +
3133: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
3134: x_internal := p_internal ;
3135: IF p_internal IS NULL THEN
3136: x_external := NULL;
3137: ELSE
3136: x_external := NULL;
3137: ELSE
3138: x_external := p_external;
3139: END IF;
3140: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
3141: x_external := p_external;
3142: IF p_external IS NULL THEN
3143: x_internal := NULL;
3144: ELSE
3164: BEGIN
3165: FOR i IN 2..p_disabled_list.COUNT
3166: LOOP
3167: IF p_disabled_list(i) = 'ROUTING_INSTRUCTIONS' THEN
3168: IF p_in_rec.ROUTING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
3169: OR p_in_rec.ROUTING_INSTRUCTIONS IS NULL THEN
3170: x_out_rec.ROUTING_INSTRUCTIONS := p_in_rec.ROUTING_INSTRUCTIONS ;
3171: END IF;
3172: -- J-IB-NPARIKH-{ ---I-bug-fix
3170: x_out_rec.ROUTING_INSTRUCTIONS := p_in_rec.ROUTING_INSTRUCTIONS ;
3171: END IF;
3172: -- J-IB-NPARIKH-{ ---I-bug-fix
3173: ELSIF p_disabled_list(i) = 'FREIGHT_CODE' THEN
3174: IF p_in_rec.CARRIER_ID <> FND_API.G_MISS_NUM
3175: OR p_in_rec.CARRIER_ID IS NULL THEN
3176: x_out_rec.CARRIER_ID := p_in_rec.CARRIER_ID ;
3177: END IF;
3178: ELSIF p_disabled_list(i) = '+FREIGHT_CODE' THEN
3175: OR p_in_rec.CARRIER_ID IS NULL THEN
3176: x_out_rec.CARRIER_ID := p_in_rec.CARRIER_ID ;
3177: END IF;
3178: ELSIF p_disabled_list(i) = '+FREIGHT_CODE' THEN
3179: IF p_in_rec.CARRIER_ID <> FND_API.G_MISS_NUM
3180: OR p_in_rec.CARRIER_ID IS NULL THEN
3181: IF x_out_rec.CARRIER_ID IS NULL THEN
3182: x_out_rec.CARRIER_ID := p_in_rec.CARRIER_ID ;
3183: END IF;
3197:
3198: -- J-IB-NPARIKH-}
3199:
3200: /*
3201: IF p_in_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
3202: OR p_in_rec.FREIGHT_TERMS_CODE IS NULL THEN
3203: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE ;
3204: END IF;
3205: */
3203: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE ;
3204: END IF;
3205: */
3206: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL_NAME' THEN
3207: IF p_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
3208: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
3209: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
3210: END IF;
3211: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT_NAME' THEN
3208: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
3209: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
3210: END IF;
3211: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT_NAME' THEN
3212: IF p_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
3213: OR p_in_rec.MODE_OF_TRANSPORT IS NULL THEN
3214: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
3215: END IF;
3216: -- J-IB-NPARIKH-{
3214: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
3215: END IF;
3216: -- J-IB-NPARIKH-{
3217: ELSIF p_disabled_list(i) = '+SERVICE_LEVEL_NAME' THEN
3218: IF p_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
3219: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
3220: IF x_out_rec.SERVICE_LEVEL IS NULL THEN
3221: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
3222: END IF;
3221: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
3222: END IF;
3223: END IF;
3224: ELSIF p_disabled_list(i) = '+MODE_OF_TRANSPORT_NAME' THEN
3225: IF p_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
3226: OR p_in_rec.MODE_OF_TRANSPORT IS NULL THEN
3227: IF x_out_rec.MODE_OF_TRANSPORT IS NULL THEN
3228: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
3229: END IF;
3228: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
3229: END IF;
3230: END IF;
3231: ELSIF p_disabled_list(i) = '+LANE_ID' THEN
3232: IF p_in_rec.LANE_ID <> FND_API.G_MISS_NUM
3233: OR p_in_rec.LANE_ID IS NULL THEN
3234: IF x_out_rec.LANE_ID IS NULL THEN
3235: x_out_rec.LANE_ID := p_in_rec.LANE_ID ;
3236: END IF;
3235: x_out_rec.LANE_ID := p_in_rec.LANE_ID ;
3236: END IF;
3237: END IF;
3238: ELSIF p_disabled_list(i) = 'VEHICLE_NUMBER' THEN
3239: IF p_in_rec.VEHICLE_NUMBER <> FND_API.G_MISS_CHAR
3240: OR p_in_rec.VEHICLE_NUMBER IS NULL THEN
3241: x_out_rec.VEHICLE_NUMBER := p_in_rec.VEHICLE_NUMBER ;
3242: END IF;
3243: ELSIF p_disabled_list(i) = 'VEHICLE_NUM_PREFIX' THEN
3240: OR p_in_rec.VEHICLE_NUMBER IS NULL THEN
3241: x_out_rec.VEHICLE_NUMBER := p_in_rec.VEHICLE_NUMBER ;
3242: END IF;
3243: ELSIF p_disabled_list(i) = 'VEHICLE_NUM_PREFIX' THEN
3244: IF p_in_rec.VEHICLE_NUM_PREFIX <> FND_API.G_MISS_CHAR
3245: OR p_in_rec.VEHICLE_NUM_PREFIX IS NULL THEN
3246: x_out_rec.VEHICLE_NUM_PREFIX := p_in_rec.VEHICLE_NUM_PREFIX ;
3247: END IF;
3248: -- OTM R12, glog project
3246: x_out_rec.VEHICLE_NUM_PREFIX := p_in_rec.VEHICLE_NUM_PREFIX ;
3247: END IF;
3248: -- OTM R12, glog project
3249: ELSIF p_disabled_list(i) = 'SEAL_CODE' THEN
3250: IF p_in_rec.SEAL_CODE <> FND_API.G_MISS_CHAR
3251: OR p_in_rec.SEAL_CODE IS NULL THEN
3252: x_out_rec.SEAL_CODE := p_in_rec.SEAL_CODE;
3253: END IF;
3254: ELSIF p_disabled_list(i) = 'NAME' THEN
3251: OR p_in_rec.SEAL_CODE IS NULL THEN
3252: x_out_rec.SEAL_CODE := p_in_rec.SEAL_CODE;
3253: END IF;
3254: ELSIF p_disabled_list(i) = 'NAME' THEN
3255: IF p_in_rec.NAME <> FND_API.G_MISS_CHAR
3256: OR p_in_rec.NAME IS NULL THEN
3257: x_out_rec.NAME := p_in_rec.NAME;
3258: END IF;
3259: -- OTM R12, end of glog project
3257: x_out_rec.NAME := p_in_rec.NAME;
3258: END IF;
3259: -- OTM R12, end of glog project
3260: ELSIF p_disabled_list(i) = 'OPERATOR' THEN
3261: IF p_in_rec.OPERATOR <> FND_API.G_MISS_CHAR
3262: OR p_in_rec.OPERATOR IS NULL THEN
3263: x_out_rec.OPERATOR := p_in_rec.OPERATOR ;
3264: END IF;
3265: -- bug 3507047: Enable update of lane on firmed trip.
3263: x_out_rec.OPERATOR := p_in_rec.OPERATOR ;
3264: END IF;
3265: -- bug 3507047: Enable update of lane on firmed trip.
3266: ELSIF p_disabled_list(i) = 'LANE_ID' THEN
3267: IF p_in_rec.LANE_ID <> FND_API.G_MISS_NUM
3268: OR p_in_rec.LANE_ID IS NULL THEN
3269: x_out_rec.LANE_ID := p_in_rec.LANE_ID ;
3270: END IF;
3271: -- J-IB-NPARIKH-}
3269: x_out_rec.LANE_ID := p_in_rec.LANE_ID ;
3270: END IF;
3271: -- J-IB-NPARIKH-}
3272: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
3273: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
3274: OR p_in_rec.attribute1 IS NULL THEN
3275: x_out_rec.attribute1 := p_in_rec.attribute1 ;
3276: END IF;
3277: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
3273: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
3274: OR p_in_rec.attribute1 IS NULL THEN
3275: x_out_rec.attribute1 := p_in_rec.attribute1 ;
3276: END IF;
3277: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
3278: OR p_in_rec.attribute2 IS NULL THEN
3279: x_out_rec.attribute2 := p_in_rec.attribute2 ;
3280: END IF;
3281: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
3277: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
3278: OR p_in_rec.attribute2 IS NULL THEN
3279: x_out_rec.attribute2 := p_in_rec.attribute2 ;
3280: END IF;
3281: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
3282: OR p_in_rec.attribute3 IS NULL THEN
3283: x_out_rec.attribute3 := p_in_rec.attribute3 ;
3284: END IF;
3285: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
3281: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
3282: OR p_in_rec.attribute3 IS NULL THEN
3283: x_out_rec.attribute3 := p_in_rec.attribute3 ;
3284: END IF;
3285: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
3286: OR p_in_rec.attribute4 IS NULL THEN
3287: x_out_rec.attribute4 := p_in_rec.attribute4 ;
3288: END IF;
3289: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
3285: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
3286: OR p_in_rec.attribute4 IS NULL THEN
3287: x_out_rec.attribute4 := p_in_rec.attribute4 ;
3288: END IF;
3289: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
3290: OR p_in_rec.attribute5 IS NULL THEN
3291: x_out_rec.attribute5 := p_in_rec.attribute5 ;
3292: END IF;
3293: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
3289: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
3290: OR p_in_rec.attribute5 IS NULL THEN
3291: x_out_rec.attribute5 := p_in_rec.attribute5 ;
3292: END IF;
3293: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
3294: OR p_in_rec.attribute6 IS NULL THEN
3295: x_out_rec.attribute6 := p_in_rec.attribute6 ;
3296: END IF;
3297: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
3293: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
3294: OR p_in_rec.attribute6 IS NULL THEN
3295: x_out_rec.attribute6 := p_in_rec.attribute6 ;
3296: END IF;
3297: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
3298: OR p_in_rec.attribute7 IS NULL THEN
3299: x_out_rec.attribute7 := p_in_rec.attribute7 ;
3300: END IF;
3301: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
3297: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
3298: OR p_in_rec.attribute7 IS NULL THEN
3299: x_out_rec.attribute7 := p_in_rec.attribute7 ;
3300: END IF;
3301: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
3302: OR p_in_rec.attribute8 IS NULL THEN
3303: x_out_rec.attribute8 := p_in_rec.attribute8 ;
3304: END IF;
3305: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
3301: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
3302: OR p_in_rec.attribute8 IS NULL THEN
3303: x_out_rec.attribute8 := p_in_rec.attribute8 ;
3304: END IF;
3305: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
3306: OR p_in_rec.attribute9 IS NULL THEN
3307: x_out_rec.attribute9 := p_in_rec.attribute9 ;
3308: END IF;
3309: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
3305: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
3306: OR p_in_rec.attribute9 IS NULL THEN
3307: x_out_rec.attribute9 := p_in_rec.attribute9 ;
3308: END IF;
3309: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
3310: OR p_in_rec.attribute10 IS NULL THEN
3311: x_out_rec.attribute10 := p_in_rec.attribute10 ;
3312: END IF;
3313: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
3309: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
3310: OR p_in_rec.attribute10 IS NULL THEN
3311: x_out_rec.attribute10 := p_in_rec.attribute10 ;
3312: END IF;
3313: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
3314: OR p_in_rec.attribute11 IS NULL THEN
3315: x_out_rec.attribute11 := p_in_rec.attribute11 ;
3316: END IF;
3317: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
3313: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
3314: OR p_in_rec.attribute11 IS NULL THEN
3315: x_out_rec.attribute11 := p_in_rec.attribute11 ;
3316: END IF;
3317: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
3318: OR p_in_rec.attribute12 IS NULL THEN
3319: x_out_rec.attribute12 := p_in_rec.attribute12 ;
3320: END IF;
3321: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
3317: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
3318: OR p_in_rec.attribute12 IS NULL THEN
3319: x_out_rec.attribute12 := p_in_rec.attribute12 ;
3320: END IF;
3321: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
3322: OR p_in_rec.attribute13 IS NULL THEN
3323: x_out_rec.attribute13 := p_in_rec.attribute13 ;
3324: END IF;
3325: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
3321: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
3322: OR p_in_rec.attribute13 IS NULL THEN
3323: x_out_rec.attribute13 := p_in_rec.attribute13 ;
3324: END IF;
3325: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
3326: OR p_in_rec.attribute14 IS NULL THEN
3327: x_out_rec.attribute14 := p_in_rec.attribute14 ;
3328: END IF;
3329: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
3325: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
3326: OR p_in_rec.attribute14 IS NULL THEN
3327: x_out_rec.attribute14 := p_in_rec.attribute14 ;
3328: END IF;
3329: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
3330: OR p_in_rec.attribute15 IS NULL THEN
3331: x_out_rec.attribute15 := p_in_rec.attribute15 ;
3332: END IF;
3333: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
3329: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
3330: OR p_in_rec.attribute15 IS NULL THEN
3331: x_out_rec.attribute15 := p_in_rec.attribute15 ;
3332: END IF;
3333: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
3334: OR p_in_rec.attribute_category IS NULL THEN
3335: x_out_rec.attribute_category := p_in_rec.attribute_category ;
3336: END IF;
3337: --ELSIF p_disabled_list(i) = 'FULL' THEN
3337: --ELSIF p_disabled_list(i) = 'FULL' THEN
3338: --NULL;
3339: --bug 3257612 : load tender needs to update fields even if firm
3340: ELSIF p_disabled_list(i) = 'LOAD_TENDER_STATUS' THEN
3341: IF p_in_rec.LOAD_TENDER_STATUS <> FND_API.G_MISS_CHAR
3342: OR p_in_rec.LOAD_TENDER_STATUS IS NULL THEN
3343: x_out_rec.LOAD_TENDER_STATUS := p_in_rec.LOAD_TENDER_STATUS;
3344: END IF;
3345: ELSIF p_disabled_list(i) = 'WF_NAME' THEN
3342: OR p_in_rec.LOAD_TENDER_STATUS IS NULL THEN
3343: x_out_rec.LOAD_TENDER_STATUS := p_in_rec.LOAD_TENDER_STATUS;
3344: END IF;
3345: ELSIF p_disabled_list(i) = 'WF_NAME' THEN
3346: IF p_in_rec.WF_NAME <> FND_API.G_MISS_CHAR
3347: OR p_in_rec.WF_NAME IS NULL THEN
3348: x_out_rec.WF_NAME := p_in_rec.WF_NAME;
3349: END IF;
3350: ELSIF p_disabled_list(i) = 'WF_PROCESS_NAME' THEN
3347: OR p_in_rec.WF_NAME IS NULL THEN
3348: x_out_rec.WF_NAME := p_in_rec.WF_NAME;
3349: END IF;
3350: ELSIF p_disabled_list(i) = 'WF_PROCESS_NAME' THEN
3351: IF p_in_rec.WF_PROCESS_NAME <> FND_API.G_MISS_CHAR
3352: OR p_in_rec.WF_PROCESS_NAME IS NULL THEN
3353: x_out_rec.WF_PROCESS_NAME := p_in_rec.WF_PROCESS_NAME;
3354: END IF;
3355: ELSIF p_disabled_list(i) = 'WF_ITEM_KEY' THEN
3352: OR p_in_rec.WF_PROCESS_NAME IS NULL THEN
3353: x_out_rec.WF_PROCESS_NAME := p_in_rec.WF_PROCESS_NAME;
3354: END IF;
3355: ELSIF p_disabled_list(i) = 'WF_ITEM_KEY' THEN
3356: IF p_in_rec.WF_ITEM_KEY <> FND_API.G_MISS_CHAR
3357: OR p_in_rec.WF_ITEM_KEY IS NULL THEN
3358: x_out_rec.WF_ITEM_KEY := p_in_rec.WF_ITEM_KEY;
3359: END IF;
3360: ELSIF p_disabled_list(i) = 'CARRIER_CONTACT_ID' THEN
3357: OR p_in_rec.WF_ITEM_KEY IS NULL THEN
3358: x_out_rec.WF_ITEM_KEY := p_in_rec.WF_ITEM_KEY;
3359: END IF;
3360: ELSIF p_disabled_list(i) = 'CARRIER_CONTACT_ID' THEN
3361: IF p_in_rec.CARRIER_CONTACT_ID <> FND_API.G_MISS_NUM
3362: OR p_in_rec.CARRIER_CONTACT_ID IS NULL THEN
3363: x_out_rec.CARRIER_CONTACT_ID := p_in_rec.CARRIER_CONTACT_ID;
3364: END IF;
3365: ELSIF p_disabled_list(i) = 'SHIPPER_WAIT_TIME' THEN
3362: OR p_in_rec.CARRIER_CONTACT_ID IS NULL THEN
3363: x_out_rec.CARRIER_CONTACT_ID := p_in_rec.CARRIER_CONTACT_ID;
3364: END IF;
3365: ELSIF p_disabled_list(i) = 'SHIPPER_WAIT_TIME' THEN
3366: IF p_in_rec.SHIPPER_WAIT_TIME <> FND_API.G_MISS_NUM
3367: OR p_in_rec.SHIPPER_WAIT_TIME IS NULL THEN
3368: x_out_rec.SHIPPER_WAIT_TIME := p_in_rec.SHIPPER_WAIT_TIME ;
3369: END IF;
3370: ELSIF p_disabled_list(i) = 'WAIT_TIME_UOM' THEN
3367: OR p_in_rec.SHIPPER_WAIT_TIME IS NULL THEN
3368: x_out_rec.SHIPPER_WAIT_TIME := p_in_rec.SHIPPER_WAIT_TIME ;
3369: END IF;
3370: ELSIF p_disabled_list(i) = 'WAIT_TIME_UOM' THEN
3371: IF p_in_rec.WAIT_TIME_UOM <> FND_API.G_MISS_CHAR
3372: OR p_in_rec.WAIT_TIME_UOM IS NULL THEN
3373: x_out_rec.WAIT_TIME_UOM := p_in_rec.WAIT_TIME_UOM ;
3374: END IF;
3375: ELSIF p_disabled_list(i) = 'LOAD_TENDERED_TIME' THEN
3372: OR p_in_rec.WAIT_TIME_UOM IS NULL THEN
3373: x_out_rec.WAIT_TIME_UOM := p_in_rec.WAIT_TIME_UOM ;
3374: END IF;
3375: ELSIF p_disabled_list(i) = 'LOAD_TENDERED_TIME' THEN
3376: IF p_in_rec.LOAD_TENDERED_TIME <> FND_API.G_MISS_DATE
3377: OR p_in_rec.LOAD_TENDERED_TIME IS NULL THEN
3378: x_out_rec.LOAD_TENDERED_TIME := p_in_rec.LOAD_TENDERED_TIME;
3379: END IF;
3380: ELSIF p_disabled_list(i) = 'CARRIER_RESPONSE' THEN
3377: OR p_in_rec.LOAD_TENDERED_TIME IS NULL THEN
3378: x_out_rec.LOAD_TENDERED_TIME := p_in_rec.LOAD_TENDERED_TIME;
3379: END IF;
3380: ELSIF p_disabled_list(i) = 'CARRIER_RESPONSE' THEN
3381: IF p_in_rec.CARRIER_RESPONSE <> FND_API.G_MISS_CHAR
3382: OR p_in_rec.CARRIER_RESPONSE IS NULL THEN
3383: x_out_rec.CARRIER_RESPONSE := p_in_rec.CARRIER_RESPONSE;
3384: END IF;
3385: --Bug 3309150 {
3392:
3393:
3394: --Bug 3599626: If veh. org is enabled, enable the veh. item as well {
3395: IF x_out_rec.VEHICLE_ORGANIZATION_ID IS NOT NULL THEN
3396: IF p_in_rec.VEHICLE_ITEM_ID <> FND_API.G_MISS_NUM
3397: OR p_in_rec.VEHICLE_ITEM_ID IS NULL THEN
3398: x_out_rec.VEHICLE_ITEM_ID := p_in_rec.VEHICLE_ITEM_ID;
3399: END IF;
3400: END IF;
3406: -- but we do not want to raise the below error.
3407: NULL;
3408: --}
3409: ELSIF p_disabled_list(i) = 'CARRIER_REFERENCE_NUMBER' THEN
3410: IF p_in_rec.CARRIER_REFERENCE_NUMBER <> FND_API.G_MISS_CHAR
3411: OR p_in_rec.CARRIER_REFERENCE_NUMBER IS NULL THEN
3412: x_out_rec.CARRIER_REFERENCE_NUMBER := p_in_rec.CARRIER_REFERENCE_NUMBER;
3413: END IF;
3414: ELSIF p_disabled_list(i) = '+CARRIER_REFERENCE_NUMBER' THEN
3411: OR p_in_rec.CARRIER_REFERENCE_NUMBER IS NULL THEN
3412: x_out_rec.CARRIER_REFERENCE_NUMBER := p_in_rec.CARRIER_REFERENCE_NUMBER;
3413: END IF;
3414: ELSIF p_disabled_list(i) = '+CARRIER_REFERENCE_NUMBER' THEN
3415: IF p_in_rec.CARRIER_REFERENCE_NUMBER <> FND_API.G_MISS_CHAR
3416: OR p_in_rec.CARRIER_REFERENCE_NUMBER IS NULL THEN
3417: IF x_out_rec.CARRIER_REFERENCE_NUMBER IS NULL THEN
3418: x_out_rec.CARRIER_REFERENCE_NUMBER := p_in_rec.CARRIER_REFERENCE_NUMBER;
3419: END IF;
3418: x_out_rec.CARRIER_REFERENCE_NUMBER := p_in_rec.CARRIER_REFERENCE_NUMBER;
3419: END IF;
3420: END IF;
3421: ELSIF p_disabled_list(i) = 'CONSIGNEE_CARRIER_AC_NO' THEN
3422: IF p_in_rec.CONSIGNEE_CARRIER_AC_NO <> FND_API.G_MISS_CHAR
3423: OR p_in_rec.CONSIGNEE_CARRIER_AC_NO IS NULL THEN
3424: x_out_rec.CONSIGNEE_CARRIER_AC_NO := p_in_rec.CONSIGNEE_CARRIER_AC_NO;
3425: END IF;
3426: ELSIF p_disabled_list(i) = '+CONSIGNEE_CARRIER_AC_NO' THEN
3423: OR p_in_rec.CONSIGNEE_CARRIER_AC_NO IS NULL THEN
3424: x_out_rec.CONSIGNEE_CARRIER_AC_NO := p_in_rec.CONSIGNEE_CARRIER_AC_NO;
3425: END IF;
3426: ELSIF p_disabled_list(i) = '+CONSIGNEE_CARRIER_AC_NO' THEN
3427: IF p_in_rec.CONSIGNEE_CARRIER_AC_NO <> FND_API.G_MISS_CHAR
3428: OR p_in_rec.CONSIGNEE_CARRIER_AC_NO IS NULL THEN
3429: IF x_out_rec.CONSIGNEE_CARRIER_AC_NO IS NULL THEN
3430: x_out_rec.CONSIGNEE_CARRIER_AC_NO := p_in_rec.CONSIGNEE_CARRIER_AC_NO;
3431: END IF;
3430: x_out_rec.CONSIGNEE_CARRIER_AC_NO := p_in_rec.CONSIGNEE_CARRIER_AC_NO;
3431: END IF;
3432: END IF;
3433: ELSIF p_disabled_list(i) IN ('+FREIGHT_TERMS_CODE', '+FREIGHT_TERMS_NAME') THEN
3434: IF p_in_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
3435: OR p_in_rec.FREIGHT_TERMS_CODE IS NULL THEN
3436: IF x_out_rec.FREIGHT_TERMS_CODE IS NULL THEN
3437: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE;
3438: END IF;
3501: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3502: --
3503: END IF;
3504: --
3505: x_return_status := FND_API.G_RET_STS_SUCCESS;
3506: --
3507: IF p_in_rec.action_code = 'CREATE' THEN
3508: --
3509: IF l_debug_on THEN
3574:
3575: -- OTM R12, glog project, allow GC3 Inbound Message to update tp_plan_name
3576: -- no change required for CREATE, caller = FTE_TMS_INTEGRATION
3577: IF p_in_rec.caller IN ('WSH_TP_RELEASE','FTE_TMS_INTEGRATION') THEN--{
3578: IF p_trip_rec.tp_plan_name <> FND_API.G_MISS_CHAR
3579: OR p_trip_rec.tp_plan_name IS NULL THEN
3580: x_trip_rec.tp_plan_name := p_trip_rec.tp_plan_name;
3581: END IF;
3582: IF p_trip_rec.tp_trip_number <> FND_API.G_MISS_NUM
3578: IF p_trip_rec.tp_plan_name <> FND_API.G_MISS_CHAR
3579: OR p_trip_rec.tp_plan_name IS NULL THEN
3580: x_trip_rec.tp_plan_name := p_trip_rec.tp_plan_name;
3581: END IF;
3582: IF p_trip_rec.tp_trip_number <> FND_API.G_MISS_NUM
3583: OR p_trip_rec.tp_trip_number IS NULL THEN
3584: x_trip_rec.tp_trip_number := p_trip_rec.tp_trip_number;
3585: END IF;
3586: END IF;--}
3586: END IF;--}
3587: -- OTM R12, glog proj,GC3 inbound message can also update Mode, Service, Carrier,Freight
3588: -- Ship Method Code, Vehicle Item id + Organization
3589: IF p_in_rec.caller = 'FTE_TMS_INTEGRATION' THEN --{
3590: IF p_trip_rec.mode_of_transport <> FND_API.G_MISS_CHAR
3591: OR p_trip_rec.mode_of_transport IS NULL THEN
3592: x_trip_rec.mode_of_transport := p_trip_rec.mode_of_transport;
3593: END IF;
3594: IF p_trip_rec.service_level <> FND_API.G_MISS_CHAR
3590: IF p_trip_rec.mode_of_transport <> FND_API.G_MISS_CHAR
3591: OR p_trip_rec.mode_of_transport IS NULL THEN
3592: x_trip_rec.mode_of_transport := p_trip_rec.mode_of_transport;
3593: END IF;
3594: IF p_trip_rec.service_level <> FND_API.G_MISS_CHAR
3595: OR p_trip_rec.service_level IS NULL THEN
3596: x_trip_rec.service_level := p_trip_rec.service_level;
3597: END IF;
3598: IF p_trip_rec.carrier_id <> FND_API.G_MISS_NUM
3594: IF p_trip_rec.service_level <> FND_API.G_MISS_CHAR
3595: OR p_trip_rec.service_level IS NULL THEN
3596: x_trip_rec.service_level := p_trip_rec.service_level;
3597: END IF;
3598: IF p_trip_rec.carrier_id <> FND_API.G_MISS_NUM
3599: OR p_trip_rec.carrier_id IS NULL THEN
3600: x_trip_rec.carrier_id := p_trip_rec.carrier_id;
3601: END IF;
3602: IF p_trip_rec.freight_terms_code <> FND_API.G_MISS_CHAR
3598: IF p_trip_rec.carrier_id <> FND_API.G_MISS_NUM
3599: OR p_trip_rec.carrier_id IS NULL THEN
3600: x_trip_rec.carrier_id := p_trip_rec.carrier_id;
3601: END IF;
3602: IF p_trip_rec.freight_terms_code <> FND_API.G_MISS_CHAR
3603: OR p_trip_rec.freight_terms_code IS NULL THEN
3604: x_trip_rec.freight_terms_code := p_trip_rec.freight_terms_code;
3605: END IF;
3606: IF p_trip_rec.ship_method_code <> FND_API.G_MISS_CHAR
3602: IF p_trip_rec.freight_terms_code <> FND_API.G_MISS_CHAR
3603: OR p_trip_rec.freight_terms_code IS NULL THEN
3604: x_trip_rec.freight_terms_code := p_trip_rec.freight_terms_code;
3605: END IF;
3606: IF p_trip_rec.ship_method_code <> FND_API.G_MISS_CHAR
3607: OR p_trip_rec.ship_method_code IS NULL THEN
3608: x_trip_rec.ship_method_code := p_trip_rec.ship_method_code;
3609: END IF;
3610: IF p_trip_rec.vehicle_item_id <> FND_API.G_MISS_NUM
3606: IF p_trip_rec.ship_method_code <> FND_API.G_MISS_CHAR
3607: OR p_trip_rec.ship_method_code IS NULL THEN
3608: x_trip_rec.ship_method_code := p_trip_rec.ship_method_code;
3609: END IF;
3610: IF p_trip_rec.vehicle_item_id <> FND_API.G_MISS_NUM
3611: OR p_trip_rec.vehicle_item_id IS NULL THEN
3612: x_trip_rec.vehicle_item_id := p_trip_rec.vehicle_item_id;
3613: END IF;
3614: IF p_trip_rec.vehicle_organization_id <> FND_API.G_MISS_NUM
3610: IF p_trip_rec.vehicle_item_id <> FND_API.G_MISS_NUM
3611: OR p_trip_rec.vehicle_item_id IS NULL THEN
3612: x_trip_rec.vehicle_item_id := p_trip_rec.vehicle_item_id;
3613: END IF;
3614: IF p_trip_rec.vehicle_organization_id <> FND_API.G_MISS_NUM
3615: OR p_trip_rec.vehicle_organization_id IS NULL THEN
3616: x_trip_rec.vehicle_organization_id := p_trip_rec.vehicle_organization_id;
3617: END IF;
3618: END IF;--}
4115: );
4116: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
4117: x_return_status := l_return_status;
4118: wsh_util_core.add_message(x_return_status);
4119: RAISE FND_API.G_EXC_ERROR;
4120: END IF;
4121: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
4122: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
4123: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4135: l_out_status);
4136:
4137: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
4138: wsh_util_core.add_message(l_out_status);
4139: RAISE FND_API.G_EXC_ERROR;
4140: END IF;
4141: -- End of code BugFix #3947506
4142:
4143: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4173: l_out_status);
4174:
4175: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
4176: wsh_util_core.add_message(l_out_status);
4177: RAISE FND_API.G_EXC_ERROR;
4178: END IF;
4179: -- End of code BugFix #3947506
4180: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4181: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4250: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4252: END IF;
4253: --
4254: WHEN FND_API.G_EXC_ERROR THEN
4255:
4256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4257: --
4258: IF l_debug_on THEN
4255:
4256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4257: --
4258: IF l_debug_on THEN
4259: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4261: END IF;
4262: --
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4257: --
4258: IF l_debug_on THEN
4259: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4261: END IF;
4262: --
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264:
4259: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4261: END IF;
4262: --
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264:
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4266: --
4267: IF l_debug_on THEN
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4266: --
4267: IF l_debug_on THEN
4268: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4270: END IF;
4271: --
4272: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4273: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4414: );
4415: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
4416: x_return_status := l_return_status;
4417: wsh_util_core.add_message(x_return_status);
4418: RAISE FND_API.G_EXC_ERROR;
4419: END IF;
4420: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
4421: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
4422: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4434: l_out_status);
4435:
4436: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
4437: wsh_util_core.add_message(l_out_status);
4438: RAISE FND_API.G_EXC_ERROR;
4439: END IF;
4440: -- End of code BugFix #3947506
4441:
4442: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4466: l_out_status);
4467:
4468: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
4469: wsh_util_core.add_message(l_out_status);
4470: RAISE FND_API.G_EXC_ERROR;
4471: END IF;
4472: -- End of code BugFix #3947506
4473:
4474: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4544: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4546: END IF;
4547: --
4548: WHEN FND_API.G_EXC_ERROR THEN
4549:
4550: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4551: --
4552: IF l_debug_on THEN
4549:
4550: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4551: --
4552: IF l_debug_on THEN
4553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4555: END IF;
4556: --
4557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4551: --
4552: IF l_debug_on THEN
4553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4555: END IF;
4556: --
4557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4558:
4553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4555: END IF;
4556: --
4557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4558:
4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4560: --
4561: IF l_debug_on THEN
4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4560: --
4561: IF l_debug_on THEN
4562: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4564: END IF;
4565: --
4566: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5064: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5065: --
5066: END IF;
5067: --
5068: x_return_status := FND_API.G_RET_STS_SUCCESS;
5069: --
5070: IF p_user_in_rec.TRIP_ID <> FND_API.G_MISS_NUM
5071: AND NVL(p_user_in_rec.TRIP_ID,-99) <> NVL(p_out_rec.TRIP_ID,-99)
5072: THEN
5066: END IF;
5067: --
5068: x_return_status := FND_API.G_RET_STS_SUCCESS;
5069: --
5070: IF p_user_in_rec.TRIP_ID <> FND_API.G_MISS_NUM
5071: AND NVL(p_user_in_rec.TRIP_ID,-99) <> NVL(p_out_rec.TRIP_ID,-99)
5072: THEN
5073: IF l_attributes IS NOT NULL THEN
5074: l_attributes := l_attributes || ', ';
5075: END IF;
5076: l_attributes := l_attributes || 'TRIP_ID';
5077: END IF;
5078:
5079: IF p_user_in_rec.NAME <> FND_API.G_MISS_CHAR
5080: AND NVL(p_user_in_rec.NAME,'!!!') <> NVL(p_out_rec.NAME,'!!!')
5081: THEN
5082: IF l_attributes IS NOT NULL THEN
5083: l_attributes := l_attributes || ', ';
5084: END IF;
5085: l_attributes := l_attributes || 'NAME';
5086: END IF;
5087:
5088: IF p_user_in_rec.PLANNED_FLAG <> FND_API.G_MISS_CHAR
5089: AND NVL(p_user_in_rec.PLANNED_FLAG,'!!!') <> NVL(p_out_rec.PLANNED_FLAG,'!!!')
5090: THEN
5091: IF l_attributes IS NOT NULL THEN
5092: l_attributes := l_attributes || ', ';
5093: END IF;
5094: l_attributes := l_attributes || 'PLANNED_FLAG';
5095: END IF;
5096:
5097: IF p_user_in_rec.ARRIVE_AFTER_TRIP_ID <> FND_API.G_MISS_NUM
5098: AND NVL(p_user_in_rec.ARRIVE_AFTER_TRIP_ID,-99) <> NVL(p_out_rec.ARRIVE_AFTER_TRIP_ID,-99)
5099: THEN
5100: IF l_attributes IS NOT NULL THEN
5101: l_attributes := l_attributes || ', ';
5102: END IF;
5103: l_attributes := l_attributes || 'ARRIVE_AFTER_TRIP_ID';
5104: END IF;
5105:
5106: IF p_user_in_rec.STATUS_CODE <> FND_API.G_MISS_CHAR
5107: AND NVL(p_user_in_rec.STATUS_CODE,'!!!') <> NVL(p_out_rec.STATUS_CODE,'!!!')
5108: THEN
5109: IF l_attributes IS NOT NULL THEN
5110: l_attributes := l_attributes || ', ';
5111: END IF;
5112: l_attributes := l_attributes || 'STATUS_CODE';
5113: END IF;
5114:
5115: IF p_user_in_rec.VEHICLE_ITEM_ID <> FND_API.G_MISS_NUM
5116: AND NVL(p_user_in_rec.VEHICLE_ITEM_ID,-99) <> NVL(p_out_rec.VEHICLE_ITEM_ID,-99)
5117: THEN
5118: IF l_attributes IS NOT NULL THEN
5119: l_attributes := l_attributes || ', ';
5120: END IF;
5121: l_attributes := l_attributes || 'VEHICLE_ITEM_ID';
5122: END IF;
5123:
5124: IF p_user_in_rec.VEHICLE_ORGANIZATION_ID <> FND_API.G_MISS_NUM
5125: AND NVL(p_user_in_rec.VEHICLE_ORGANIZATION_ID,-99) <> NVL(p_out_rec.VEHICLE_ORGANIZATION_ID,-99)
5126: THEN
5127: IF l_attributes IS NOT NULL THEN
5128: l_attributes := l_attributes || ', ';
5129: END IF;
5130: l_attributes := l_attributes || 'VEHICLE_ORGANIZATION_ID';
5131: END IF;
5132:
5133: IF p_user_in_rec.VEHICLE_NUMBER <> FND_API.G_MISS_CHAR
5134: AND NVL(p_user_in_rec.VEHICLE_NUMBER,'!!!') <> NVL(p_out_rec.VEHICLE_NUMBER,'!!!')
5135: THEN
5136: IF l_attributes IS NOT NULL THEN
5137: l_attributes := l_attributes || ', ';
5138: END IF;
5139: l_attributes := l_attributes || 'VEHICLE_NUMBER';
5140: END IF;
5141:
5142: IF p_user_in_rec.VEHICLE_NUM_PREFIX <> FND_API.G_MISS_CHAR
5143: AND NVL(p_user_in_rec.VEHICLE_NUM_PREFIX,'!!!') <> NVL(p_out_rec.VEHICLE_NUM_PREFIX,'!!!')
5144: THEN
5145: IF l_attributes IS NOT NULL THEN
5146: l_attributes := l_attributes || ', ';
5147: END IF;
5148: l_attributes := l_attributes || 'VEHICLE_NUM_PREFIX';
5149: END IF;
5150:
5151: IF p_user_in_rec.CARRIER_ID <> FND_API.G_MISS_NUM
5152: AND NVL(p_user_in_rec.CARRIER_ID,-99) <> NVL(p_out_rec.CARRIER_ID,-99)
5153: THEN
5154: IF l_attributes IS NOT NULL THEN
5155: l_attributes := l_attributes || ', ';
5156: END IF;
5157: l_attributes := l_attributes || 'CARRIER_ID';
5158: END IF;
5159:
5160: IF p_user_in_rec.SHIP_METHOD_CODE <> FND_API.G_MISS_CHAR
5161: AND NVL(p_user_in_rec.SHIP_METHOD_CODE,'!!!') <> NVL(p_out_rec.SHIP_METHOD_CODE,'!!!')
5162: THEN
5163: IF l_attributes IS NOT NULL THEN
5164: l_attributes := l_attributes || ', ';
5165: END IF;
5166: l_attributes := l_attributes || 'SHIP_METHOD_CODE';
5167: END IF;
5168:
5169: IF p_user_in_rec.ROUTE_ID <> FND_API.G_MISS_NUM
5170: AND NVL(p_user_in_rec.ROUTE_ID,-99) <> NVL(p_out_rec.ROUTE_ID,-99)
5171: THEN
5172: IF l_attributes IS NOT NULL THEN
5173: l_attributes := l_attributes || ', ';
5174: END IF;
5175: l_attributes := l_attributes || 'ROUTE_ID';
5176: END IF;
5177:
5178: IF p_user_in_rec.ROUTING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
5179: AND NVL(p_user_in_rec.ROUTING_INSTRUCTIONS,'!!!') <> NVL(p_out_rec.ROUTING_INSTRUCTIONS,'!!!')
5180: THEN
5181: IF l_attributes IS NOT NULL THEN
5182: l_attributes := l_attributes || ', ';
5183: END IF;
5184: l_attributes := l_attributes || 'ROUTING_INSTRUCTIONS';
5185: END IF;
5186:
5187: IF p_user_in_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
5188: AND NVL(p_user_in_rec.ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.ATTRIBUTE_CATEGORY,'!!!')
5189: THEN
5190: IF l_attributes IS NOT NULL THEN
5191: l_attributes := l_attributes || ', ';
5192: END IF;
5193: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY';
5194: END IF;
5195:
5196: IF p_user_in_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
5197: AND NVL(p_user_in_rec.ATTRIBUTE1,'!!!') <> NVL(p_out_rec.ATTRIBUTE1,'!!!')
5198: THEN
5199: IF l_attributes IS NOT NULL THEN
5200: l_attributes := l_attributes || ', ';
5201: END IF;
5202: l_attributes := l_attributes || 'ATTRIBUTE1';
5203: END IF;
5204:
5205: IF p_user_in_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
5206: AND NVL(p_user_in_rec.ATTRIBUTE2,'!!!') <> NVL(p_out_rec.ATTRIBUTE2,'!!!')
5207: THEN
5208: IF l_attributes IS NOT NULL THEN
5209: l_attributes := l_attributes || ', ';
5210: END IF;
5211: l_attributes := l_attributes || 'ATTRIBUTE2';
5212: END IF;
5213:
5214: IF p_user_in_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
5215: AND NVL(p_user_in_rec.ATTRIBUTE3,'!!!') <> NVL(p_out_rec.ATTRIBUTE3,'!!!')
5216: THEN
5217: IF l_attributes IS NOT NULL THEN
5218: l_attributes := l_attributes || ', ';
5219: END IF;
5220: l_attributes := l_attributes || 'ATTRIBUTE3';
5221: END IF;
5222:
5223: IF p_user_in_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
5224: AND NVL(p_user_in_rec.ATTRIBUTE4,'!!!') <> NVL(p_out_rec.ATTRIBUTE4,'!!!')
5225: THEN
5226: IF l_attributes IS NOT NULL THEN
5227: l_attributes := l_attributes || ', ';
5228: END IF;
5229: l_attributes := l_attributes || 'ATTRIBUTE4';
5230: END IF;
5231:
5232: IF p_user_in_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
5233: AND NVL(p_user_in_rec.ATTRIBUTE5,'!!!') <> NVL(p_out_rec.ATTRIBUTE5,'!!!')
5234: THEN
5235: IF l_attributes IS NOT NULL THEN
5236: l_attributes := l_attributes || ', ';
5237: END IF;
5238: l_attributes := l_attributes || 'ATTRIBUTE5';
5239: END IF;
5240:
5241: IF p_user_in_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
5242: AND NVL(p_user_in_rec.ATTRIBUTE6,'!!!') <> NVL(p_out_rec.ATTRIBUTE6,'!!!')
5243: THEN
5244: IF l_attributes IS NOT NULL THEN
5245: l_attributes := l_attributes || ', ';
5246: END IF;
5247: l_attributes := l_attributes || 'ATTRIBUTE6';
5248: END IF;
5249:
5250: IF p_user_in_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
5251: AND NVL(p_user_in_rec.ATTRIBUTE7,'!!!') <> NVL(p_out_rec.ATTRIBUTE7,'!!!')
5252: THEN
5253: IF l_attributes IS NOT NULL THEN
5254: l_attributes := l_attributes || ', ';
5255: END IF;
5256: l_attributes := l_attributes || 'ATTRIBUTE7';
5257: END IF;
5258:
5259: IF p_user_in_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
5260: AND NVL(p_user_in_rec.ATTRIBUTE8,'!!!') <> NVL(p_out_rec.ATTRIBUTE8,'!!!')
5261: THEN
5262: IF l_attributes IS NOT NULL THEN
5263: l_attributes := l_attributes || ', ';
5264: END IF;
5265: l_attributes := l_attributes || 'ATTRIBUTE8';
5266: END IF;
5267:
5268: IF p_user_in_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
5269: AND NVL(p_user_in_rec.ATTRIBUTE9,'!!!') <> NVL(p_out_rec.ATTRIBUTE9,'!!!')
5270: THEN
5271: IF l_attributes IS NOT NULL THEN
5272: l_attributes := l_attributes || ', ';
5273: END IF;
5274: l_attributes := l_attributes || 'ATTRIBUTE9';
5275: END IF;
5276:
5277: IF p_user_in_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
5278: AND NVL(p_user_in_rec.ATTRIBUTE10,'!!!') <> NVL(p_out_rec.ATTRIBUTE10,'!!!')
5279: THEN
5280: IF l_attributes IS NOT NULL THEN
5281: l_attributes := l_attributes || ', ';
5282: END IF;
5283: l_attributes := l_attributes || 'ATTRIBUTE10';
5284: END IF;
5285:
5286: IF p_user_in_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
5287: AND NVL(p_user_in_rec.ATTRIBUTE11,'!!!') <> NVL(p_out_rec.ATTRIBUTE11,'!!!')
5288: THEN
5289: IF l_attributes IS NOT NULL THEN
5290: l_attributes := l_attributes || ', ';
5291: END IF;
5292: l_attributes := l_attributes || 'ATTRIBUTE11';
5293: END IF;
5294:
5295: IF p_user_in_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
5296: AND NVL(p_user_in_rec.ATTRIBUTE12,'!!!') <> NVL(p_out_rec.ATTRIBUTE12,'!!!')
5297: THEN
5298: IF l_attributes IS NOT NULL THEN
5299: l_attributes := l_attributes || ', ';
5300: END IF;
5301: l_attributes := l_attributes || 'ATTRIBUTE12';
5302: END IF;
5303:
5304: IF p_user_in_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
5305: AND NVL(p_user_in_rec.ATTRIBUTE13,'!!!') <> NVL(p_out_rec.ATTRIBUTE13,'!!!')
5306: THEN
5307: IF l_attributes IS NOT NULL THEN
5308: l_attributes := l_attributes || ', ';
5309: END IF;
5310: l_attributes := l_attributes || 'ATTRIBUTE13';
5311: END IF;
5312:
5313: IF p_user_in_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
5314: AND NVL(p_user_in_rec.ATTRIBUTE14,'!!!') <> NVL(p_out_rec.ATTRIBUTE14,'!!!')
5315: THEN
5316: IF l_attributes IS NOT NULL THEN
5317: l_attributes := l_attributes || ', ';
5318: END IF;
5319: l_attributes := l_attributes || 'ATTRIBUTE14';
5320: END IF;
5321:
5322: IF p_user_in_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
5323: AND NVL(p_user_in_rec.ATTRIBUTE15,'!!!') <> NVL(p_out_rec.ATTRIBUTE15,'!!!')
5324: THEN
5325: IF l_attributes IS NOT NULL THEN
5326: l_attributes := l_attributes || ', ';
5330:
5331: /**
5332: -- bug 3613650
5333: -- Need not compare against standard WHO columns
5334: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE
5335: AND NVL(p_user_in_rec.CREATION_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CREATION_DATE,TO_DATE('2','j'))
5336: THEN
5337: IF l_attributes IS NOT NULL THEN
5338: l_attributes := l_attributes || ', ';
5339: END IF;
5340: l_attributes := l_attributes || 'CREATION_DATE';
5341: END IF;
5342:
5343: IF p_user_in_rec.CREATED_BY <> FND_API.G_MISS_NUM
5344: AND NVL(p_user_in_rec.CREATED_BY,-99) <> NVL(p_out_rec.CREATED_BY,-99)
5345: THEN
5346: IF l_attributes IS NOT NULL THEN
5347: l_attributes := l_attributes || ', ';
5348: END IF;
5349: l_attributes := l_attributes || 'CREATED_BY';
5350: END IF;
5351:
5352: IF p_user_in_rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE
5353: AND NVL(p_user_in_rec.LAST_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LAST_UPDATE_DATE,TO_DATE('2','j'))
5354: THEN
5355: IF l_attributes IS NOT NULL THEN
5356: l_attributes := l_attributes || ', ';
5357: END IF;
5358: l_attributes := l_attributes || 'LAST_UPDATE_DATE';
5359: END IF;
5360:
5361: IF p_user_in_rec.LAST_UPDATED_BY <> FND_API.G_MISS_NUM
5362: AND NVL(p_user_in_rec.LAST_UPDATED_BY,-99) <> NVL(p_out_rec.LAST_UPDATED_BY,-99)
5363: THEN
5364: IF l_attributes IS NOT NULL THEN
5365: l_attributes := l_attributes || ', ';
5366: END IF;
5367: l_attributes := l_attributes || 'LAST_UPDATED_BY';
5368: END IF;
5369:
5370: IF p_user_in_rec.LAST_UPDATE_LOGIN <> FND_API.G_MISS_NUM
5371: AND NVL(p_user_in_rec.LAST_UPDATE_LOGIN,-99) <> NVL(p_out_rec.LAST_UPDATE_LOGIN,-99)
5372: THEN
5373: IF l_attributes IS NOT NULL THEN
5374: l_attributes := l_attributes || ', ';
5375: END IF;
5376: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN';
5377: END IF;
5378:
5379: IF p_user_in_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
5380: AND NVL(p_user_in_rec.PROGRAM_APPLICATION_ID,-99) <> NVL(p_out_rec.PROGRAM_APPLICATION_ID,-99)
5381: THEN
5382: IF l_attributes IS NOT NULL THEN
5383: l_attributes := l_attributes || ', ';
5384: END IF;
5385: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID';
5386: END IF;
5387:
5388: IF p_user_in_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
5389: AND NVL(p_user_in_rec.PROGRAM_ID,-99) <> NVL(p_out_rec.PROGRAM_ID,-99)
5390: THEN
5391: IF l_attributes IS NOT NULL THEN
5392: l_attributes := l_attributes || ', ';
5393: END IF;
5394: l_attributes := l_attributes || 'PROGRAM_ID';
5395: END IF;
5396:
5397: IF p_user_in_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
5398: AND NVL(p_user_in_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j'))
5399: THEN
5400: IF l_attributes IS NOT NULL THEN
5401: l_attributes := l_attributes || ', ';
5402: END IF;
5403: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE';
5404: END IF;
5405:
5406: IF p_user_in_rec.REQUEST_ID <> FND_API.G_MISS_NUM
5407: AND NVL(p_user_in_rec.REQUEST_ID,-99) <> NVL(p_out_rec.REQUEST_ID,-99)
5408: THEN
5409: IF l_attributes IS NOT NULL THEN
5410: l_attributes := l_attributes || ', ';
5413: END IF;
5414:
5415: bug 3613650 */
5416:
5417: IF p_user_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
5418: AND NVL(p_user_in_rec.SERVICE_LEVEL,'!!!') <> NVL(p_out_rec.SERVICE_LEVEL,'!!!')
5419: THEN
5420: IF l_attributes IS NOT NULL THEN
5421: l_attributes := l_attributes || ', ';
5422: END IF;
5423: l_attributes := l_attributes || 'SERVICE_LEVEL';
5424: END IF;
5425:
5426: IF p_user_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
5427: AND NVL(p_user_in_rec.MODE_OF_TRANSPORT,'!!!') <> NVL(p_out_rec.MODE_OF_TRANSPORT,'!!!')
5428: THEN
5429: IF l_attributes IS NOT NULL THEN
5430: l_attributes := l_attributes || ', ';
5431: END IF;
5432: l_attributes := l_attributes || 'MODE_OF_TRANSPORT';
5433: END IF;
5434:
5435: IF p_user_in_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
5436: AND NVL(p_user_in_rec.FREIGHT_TERMS_CODE,'!!!') <> NVL(p_out_rec.FREIGHT_TERMS_CODE,'!!!')
5437: THEN
5438: IF l_attributes IS NOT NULL THEN
5439: l_attributes := l_attributes || ', ';
5440: END IF;
5441: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE';
5442: END IF;
5443:
5444: IF p_user_in_rec.CONSOLIDATION_ALLOWED <> FND_API.G_MISS_CHAR
5445: AND NVL(p_user_in_rec.CONSOLIDATION_ALLOWED,'!!!') <> NVL(p_out_rec.CONSOLIDATION_ALLOWED,'!!!')
5446: THEN
5447: IF l_attributes IS NOT NULL THEN
5448: l_attributes := l_attributes || ', ';
5449: END IF;
5450: l_attributes := l_attributes || 'CONSOLIDATION_ALLOWED';
5451: END IF;
5452:
5453: IF p_user_in_rec.LOAD_TENDER_STATUS <> FND_API.G_MISS_CHAR
5454: AND NVL(p_user_in_rec.LOAD_TENDER_STATUS,'!!!') <> NVL(p_out_rec.LOAD_TENDER_STATUS,'!!!')
5455: THEN
5456: IF l_attributes IS NOT NULL THEN
5457: l_attributes := l_attributes || ', ';
5458: END IF;
5459: l_attributes := l_attributes || 'LOAD_TENDER_STATUS';
5460: END IF;
5461:
5462: IF p_user_in_rec.ROUTE_LANE_ID <> FND_API.G_MISS_NUM
5463: AND NVL(p_user_in_rec.ROUTE_LANE_ID,-99) <> NVL(p_out_rec.ROUTE_LANE_ID,-99)
5464: THEN
5465: IF l_attributes IS NOT NULL THEN
5466: l_attributes := l_attributes || ', ';
5467: END IF;
5468: l_attributes := l_attributes || 'ROUTE_LANE_ID';
5469: END IF;
5470:
5471: IF p_user_in_rec.LANE_ID <> FND_API.G_MISS_NUM
5472: AND NVL(p_user_in_rec.LANE_ID,-99) <> NVL(p_out_rec.LANE_ID,-99)
5473: THEN
5474: IF l_attributes IS NOT NULL THEN
5475: l_attributes := l_attributes || ', ';
5476: END IF;
5477: l_attributes := l_attributes || 'LANE_ID';
5478: END IF;
5479:
5480: IF p_user_in_rec.SCHEDULE_ID <> FND_API.G_MISS_NUM
5481: AND NVL(p_user_in_rec.SCHEDULE_ID,-99) <> NVL(p_out_rec.SCHEDULE_ID,-99)
5482: THEN
5483: IF l_attributes IS NOT NULL THEN
5484: l_attributes := l_attributes || ', ';
5485: END IF;
5486: l_attributes := l_attributes || 'SCHEDULE_ID';
5487: END IF;
5488:
5489: IF p_user_in_rec.BOOKING_NUMBER <> FND_API.G_MISS_CHAR
5490: AND NVL(p_user_in_rec.BOOKING_NUMBER,'!!!') <> NVL(p_out_rec.BOOKING_NUMBER,'!!!')
5491: THEN
5492: IF l_attributes IS NOT NULL THEN
5493: l_attributes := l_attributes || ', ';
5494: END IF;
5495: l_attributes := l_attributes || 'BOOKING_NUMBER';
5496: END IF;
5497:
5498: IF p_user_in_rec.ROWID <> FND_API.G_MISS_CHAR
5499: AND NVL(p_user_in_rec.ROWID,'!!!') <> NVL(p_out_rec.ROWID,'!!!')
5500: THEN
5501: IF l_attributes IS NOT NULL THEN
5502: l_attributes := l_attributes || ', ';
5503: END IF;
5504: l_attributes := l_attributes || 'ROWID';
5505: END IF;
5506:
5507: IF p_user_in_rec.ARRIVE_AFTER_TRIP_NAME <> FND_API.G_MISS_CHAR
5508: AND NVL(p_user_in_rec.ARRIVE_AFTER_TRIP_NAME,'!!!') <> NVL(p_out_rec.ARRIVE_AFTER_TRIP_NAME,'!!!')
5509: THEN
5510: IF l_attributes IS NOT NULL THEN
5511: l_attributes := l_attributes || ', ';
5512: END IF;
5513: l_attributes := l_attributes || 'ARRIVE_AFTER_TRIP_NAME';
5514: END IF;
5515:
5516: IF p_user_in_rec.SHIP_METHOD_NAME <> FND_API.G_MISS_CHAR
5517: AND NVL(p_user_in_rec.SHIP_METHOD_NAME,'!!!') <> NVL(p_out_rec.SHIP_METHOD_NAME,'!!!')
5518: THEN
5519: IF l_attributes IS NOT NULL THEN
5520: l_attributes := l_attributes || ', ';
5521: END IF;
5522: l_attributes := l_attributes || 'SHIP_METHOD_NAME';
5523: END IF;
5524:
5525: IF p_user_in_rec.VEHICLE_ITEM_DESC <> FND_API.G_MISS_CHAR
5526: AND NVL(p_user_in_rec.VEHICLE_ITEM_DESC,'!!!') <> NVL(p_out_rec.VEHICLE_ITEM_DESC,'!!!')
5527: THEN
5528: IF l_attributes IS NOT NULL THEN
5529: l_attributes := l_attributes || ', ';
5530: END IF;
5531: l_attributes := l_attributes || 'VEHICLE_ITEM_DESC';
5532: END IF;
5533:
5534: IF p_user_in_rec.VEHICLE_ORGANIZATION_CODE <> FND_API.G_MISS_CHAR
5535: AND NVL(p_user_in_rec.VEHICLE_ORGANIZATION_CODE,'!!!') <> NVL(p_out_rec.VEHICLE_ORGANIZATION_CODE,'!!!')
5536: THEN
5537: IF l_attributes IS NOT NULL THEN
5538: l_attributes := l_attributes || ', ';
5539: END IF;
5540: l_attributes := l_attributes || 'VEHICLE_ORGANIZATION_CODE';
5541: END IF;
5542:
5543: IF p_user_in_rec.LOAD_TENDER_NUMBER <> FND_API.G_MISS_NUM
5544: AND NVL(p_user_in_rec.LOAD_TENDER_NUMBER,-99) <> NVL(p_out_rec.LOAD_TENDER_NUMBER,-99)
5545: THEN
5546: IF l_attributes IS NOT NULL THEN
5547: l_attributes := l_attributes || ', ';
5548: END IF;
5549: l_attributes := l_attributes || 'LOAD_TENDER_NUMBER';
5550: END IF;
5551:
5552: IF p_user_in_rec.VESSEL <> FND_API.G_MISS_CHAR
5553: AND NVL(p_user_in_rec.VESSEL,'!!!') <> NVL(p_out_rec.VESSEL,'!!!')
5554: THEN
5555: IF l_attributes IS NOT NULL THEN
5556: l_attributes := l_attributes || ', ';
5557: END IF;
5558: l_attributes := l_attributes || 'VESSEL';
5559: END IF;
5560:
5561: IF p_user_in_rec.VOYAGE_NUMBER <> FND_API.G_MISS_CHAR
5562: AND NVL(p_user_in_rec.VOYAGE_NUMBER,'!!!') <> NVL(p_out_rec.VOYAGE_NUMBER,'!!!')
5563: THEN
5564: IF l_attributes IS NOT NULL THEN
5565: l_attributes := l_attributes || ', ';
5566: END IF;
5567: l_attributes := l_attributes || 'VOYAGE_NUMBER';
5568: END IF;
5569:
5570: IF p_user_in_rec.PORT_OF_LOADING <> FND_API.G_MISS_CHAR
5571: AND NVL(p_user_in_rec.PORT_OF_LOADING,'!!!') <> NVL(p_out_rec.PORT_OF_LOADING,'!!!')
5572: THEN
5573: IF l_attributes IS NOT NULL THEN
5574: l_attributes := l_attributes || ', ';
5575: END IF;
5576: l_attributes := l_attributes || 'PORT_OF_LOADING';
5577: END IF;
5578:
5579: IF p_user_in_rec.PORT_OF_DISCHARGE <> FND_API.G_MISS_CHAR
5580: AND NVL(p_user_in_rec.PORT_OF_DISCHARGE,'!!!') <> NVL(p_out_rec.PORT_OF_DISCHARGE,'!!!')
5581: THEN
5582: IF l_attributes IS NOT NULL THEN
5583: l_attributes := l_attributes || ', ';
5584: END IF;
5585: l_attributes := l_attributes || 'PORT_OF_DISCHARGE';
5586: END IF;
5587:
5588: IF p_user_in_rec.WF_NAME <> FND_API.G_MISS_CHAR
5589: AND NVL(p_user_in_rec.WF_NAME,'!!!') <> NVL(p_out_rec.WF_NAME,'!!!')
5590: THEN
5591: IF l_attributes IS NOT NULL THEN
5592: l_attributes := l_attributes || ', ';
5593: END IF;
5594: l_attributes := l_attributes || 'WF_NAME';
5595: END IF;
5596:
5597: IF p_user_in_rec.WF_PROCESS_NAME <> FND_API.G_MISS_CHAR
5598: AND NVL(p_user_in_rec.WF_PROCESS_NAME,'!!!') <> NVL(p_out_rec.WF_PROCESS_NAME,'!!!')
5599: THEN
5600: IF l_attributes IS NOT NULL THEN
5601: l_attributes := l_attributes || ', ';
5602: END IF;
5603: l_attributes := l_attributes || 'WF_PROCESS_NAME';
5604: END IF;
5605:
5606: IF p_user_in_rec.WF_ITEM_KEY <> FND_API.G_MISS_CHAR
5607: AND NVL(p_user_in_rec.WF_ITEM_KEY,'!!!') <> NVL(p_out_rec.WF_ITEM_KEY,'!!!')
5608: THEN
5609: IF l_attributes IS NOT NULL THEN
5610: l_attributes := l_attributes || ', ';
5611: END IF;
5612: l_attributes := l_attributes || 'WF_ITEM_KEY';
5613: END IF;
5614:
5615: IF p_user_in_rec.CARRIER_CONTACT_ID <> FND_API.G_MISS_NUM
5616: AND NVL(p_user_in_rec.CARRIER_CONTACT_ID,-99) <> NVL(p_out_rec.CARRIER_CONTACT_ID,-99)
5617: THEN
5618: IF l_attributes IS NOT NULL THEN
5619: l_attributes := l_attributes || ', ';
5620: END IF;
5621: l_attributes := l_attributes || 'CARRIER_CONTACT_ID';
5622: END IF;
5623:
5624: IF p_user_in_rec.SHIPPER_WAIT_TIME <> FND_API.G_MISS_NUM
5625: AND NVL(p_user_in_rec.SHIPPER_WAIT_TIME,-99) <> NVL(p_out_rec.SHIPPER_WAIT_TIME,-99)
5626: THEN
5627: IF l_attributes IS NOT NULL THEN
5628: l_attributes := l_attributes || ', ';
5629: END IF;
5630: l_attributes := l_attributes || 'SHIPPER_WAIT_TIME';
5631: END IF;
5632:
5633: IF p_user_in_rec.WAIT_TIME_UOM <> FND_API.G_MISS_CHAR
5634: AND NVL(p_user_in_rec.WAIT_TIME_UOM,'!!!') <> NVL(p_out_rec.WAIT_TIME_UOM,'!!!')
5635: THEN
5636: IF l_attributes IS NOT NULL THEN
5637: l_attributes := l_attributes || ', ';
5638: END IF;
5639: l_attributes := l_attributes || 'WAIT_TIME_UOM';
5640: END IF;
5641:
5642: IF p_user_in_rec.LOAD_TENDERED_TIME <> FND_API.G_MISS_DATE
5643: AND NVL(p_user_in_rec.LOAD_TENDERED_TIME,TO_DATE('2','j')) <> NVL(p_out_rec.LOAD_TENDERED_TIME,TO_DATE('2','j'))
5644: THEN
5645: IF l_attributes IS NOT NULL THEN
5646: l_attributes := l_attributes || ', ';
5647: END IF;
5648: l_attributes := l_attributes || 'LOAD_TENDERED_TIME';
5649: END IF;
5650:
5651: IF p_user_in_rec.CARRIER_RESPONSE <> FND_API.G_MISS_CHAR
5652: AND NVL(p_user_in_rec.CARRIER_RESPONSE,'!!!') <> NVL(p_out_rec.CARRIER_RESPONSE,'!!!')
5653: THEN
5654: IF l_attributes IS NOT NULL THEN
5655: l_attributes := l_attributes || ', ';
5656: END IF;
5657: l_attributes := l_attributes || 'CARRIER_RESPONSE';
5658: END IF;
5659:
5660: IF p_user_in_rec.SHIPMENTS_TYPE_FLAG <> FND_API.G_MISS_CHAR
5661: AND NVL(p_user_in_rec.SHIPMENTS_TYPE_FLAG,'!!!') <> NVL(p_out_rec.SHIPMENTS_TYPE_FLAG,'!!!')
5662: THEN
5663: IF l_attributes IS NOT NULL THEN
5664: l_attributes := l_attributes || ', ';
5665: END IF;
5666: l_attributes := l_attributes || 'SHIPMENTS_TYPE_FLAG';
5667: END IF;
5668:
5669: IF p_user_in_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR
5670: AND NVL(p_user_in_rec.IGNORE_FOR_PLANNING,'!!!') <> NVL(p_out_rec.IGNORE_FOR_PLANNING,'!!!')
5671: THEN
5672: IF l_attributes IS NOT NULL THEN
5673: l_attributes := l_attributes || ', ';
5674: END IF;
5675: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING';
5676: END IF;
5677:
5678: IF p_user_in_rec.TP_PLAN_NAME <> FND_API.G_MISS_CHAR
5679: AND NVL(p_user_in_rec.TP_PLAN_NAME,'!!!') <> NVL(p_out_rec.TP_PLAN_NAME,'!!!')
5680: THEN
5681: IF l_attributes IS NOT NULL THEN
5682: l_attributes := l_attributes || ', ';
5683: END IF;
5684: l_attributes := l_attributes || 'TP_PLAN_NAME';
5685: END IF;
5686:
5687: IF p_user_in_rec.TP_TRIP_NUMBER <> FND_API.G_MISS_NUM
5688: AND NVL(p_user_in_rec.TP_TRIP_NUMBER,-99) <> NVL(p_out_rec.TP_TRIP_NUMBER,-99)
5689: THEN
5690: IF l_attributes IS NOT NULL THEN
5691: l_attributes := l_attributes || ', ';
5692: END IF;
5693: l_attributes := l_attributes || 'TP_TRIP_NUMBER';
5694: END IF;
5695:
5696: IF p_user_in_rec.SEAL_CODE <> FND_API.G_MISS_CHAR
5697: AND NVL(p_user_in_rec.SEAL_CODE,'!!!') <> NVL(p_out_rec.SEAL_CODE,'!!!')
5698: THEN
5699: IF l_attributes IS NOT NULL THEN
5700: l_attributes := l_attributes || ', ';
5701: END IF;
5702: l_attributes := l_attributes || 'SEAL_CODE';
5703: END IF;
5704:
5705: IF p_user_in_rec.OPERATOR <> FND_API.G_MISS_CHAR
5706: AND NVL(p_user_in_rec.OPERATOR,'!!!') <> NVL(p_out_rec.OPERATOR,'!!!')
5707: THEN
5708: IF l_attributes IS NOT NULL THEN
5709: l_attributes := l_attributes || ', ';
5711: l_attributes := l_attributes || 'OPERATOR';
5712: END IF;
5713:
5714:
5715: IF p_user_in_rec.CONSIGNEE_CARRIER_AC_NO <> FND_API.G_MISS_CHAR
5716: AND NVL(p_user_in_rec.CONSIGNEE_CARRIER_AC_NO,'!!!') <> NVL(p_out_rec.CONSIGNEE_CARRIER_AC_NO,'!!!')
5717: THEN
5718: IF l_attributes IS NOT NULL THEN
5719: l_attributes := l_attributes || ', ';
5720: END IF;
5721: l_attributes := l_attributes || 'CONSIGNEE_CARRIER_AC_NO';
5722: END IF;
5723:
5724: IF p_user_in_rec.CARRIER_REFERENCE_NUMBER <> FND_API.G_MISS_CHAR
5725: AND NVL(p_user_in_rec.CARRIER_REFERENCE_NUMBER,'!!!') <> NVL(p_out_rec.CARRIER_REFERENCE_NUMBER,'!!!')
5726: THEN
5727: IF l_attributes IS NOT NULL THEN
5728: l_attributes := l_attributes || ', ';
5729: END IF;
5730: l_attributes := l_attributes || 'CARRIER_REFERENCE_NUMBER';
5731: END IF;
5732:
5733: IF p_user_in_rec.APPEND_FLAG <> FND_API.G_MISS_CHAR
5734: AND NVL(p_user_in_rec.APPEND_FLAG,'!!!') <> NVL(p_out_rec.APPEND_FLAG,'!!!')
5735: THEN
5736: IF l_attributes IS NOT NULL THEN
5737: l_attributes := l_attributes || ', ';
5739: l_attributes := l_attributes || 'APPEND_FLAG';
5740: END IF;
5741:
5742:
5743: IF p_user_in_rec.RANK_ID <> FND_API.G_MISS_NUM
5744: AND NVL(p_user_in_rec.RANK_ID, -99) <> NVL(p_out_rec.RANK_ID,-99)
5745: THEN
5746: IF l_attributes IS NOT NULL THEN
5747: l_attributes := l_attributes || ', ';
5748: END IF;
5749: l_attributes := l_attributes || 'RANK_ID';
5750: END IF;
5751:
5752: IF p_user_in_rec.ROUTING_RULE_ID <> FND_API.G_MISS_NUM
5753: AND NVL(p_user_in_rec.ROUTING_RULE_ID, -99) <> NVL(p_out_rec.ROUTING_RULE_ID,-99)
5754: THEN
5755: IF l_attributes IS NOT NULL THEN
5756: l_attributes := l_attributes || ', ';