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