[Home] [Help]
1025: END IF;
1026: --
1027: wsh_cal_asg_validations.transport_dates(
1028: p_api_version_number => 1.0
1029: , p_init_msg_list => FND_API.G_FALSE
1030: , x_return_status => x_return_status
1031: , x_msg_count => l_msg_count
1032: , x_msg_data => l_msg_data
1033: , p_priority => 'SHIP'
2035: END IF;
2036: --
2037: --
2038: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
2039: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2040: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
2041: raise FND_API.G_EXC_ERROR;
2042: END IF;
2043: --
2037: --
2038: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
2039: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2040: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
2041: raise FND_API.G_EXC_ERROR;
2042: END IF;
2043: --
2044: --}
2045: END IF;
2253: --
2254: EXCEPTION
2255: -- J-IB-NPARIKH-{
2256: --
2257: WHEN FND_API.G_EXC_ERROR THEN
2258:
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2260: --
2261: IF l_debug_on THEN
2258:
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2260: --
2261: IF l_debug_on THEN
2262: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2263: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2264: END IF;
2265: --
2266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2260: --
2261: IF l_debug_on THEN
2262: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2263: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2264: END IF;
2265: --
2266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2267:
2262: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2263: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2264: END IF;
2265: --
2266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2267:
2268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2269: --
2270: IF l_debug_on THEN
2268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2269: --
2270: IF l_debug_on THEN
2271: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2272: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2273: END IF;
2274: --
2275: -- J-IB-NPARIKH-}
2276:
4504: );
4505: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
4506: x_return_status := l_return_status;
4507: wsh_util_core.add_message(x_return_status);
4508: RAISE FND_API.G_EXC_ERROR;
4509: END IF;
4510: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
4511: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
4512: IF l_exceptions_tab(exp_cnt).entity_name = 'DELIVERY' THEN
4602: x_allowed := 'NW';
4603: --
4604: --
4605: IF l_debug_on THEN
4606: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4608: END IF;
4609: --
4610: WHEN FND_API.G_EXC_ERROR THEN
4603: --
4604: --
4605: IF l_debug_on THEN
4606: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4608: END IF;
4609: --
4610: WHEN FND_API.G_EXC_ERROR THEN
4611:
4606: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4608: END IF;
4609: --
4610: WHEN FND_API.G_EXC_ERROR THEN
4611:
4612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4613: --
4614: IF l_debug_on THEN
4611:
4612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4613: --
4614: IF l_debug_on THEN
4615: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4617: END IF;
4618: --
4619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4613: --
4614: IF l_debug_on THEN
4615: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4617: END IF;
4618: --
4619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4620:
4615: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4617: END IF;
4618: --
4619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4620:
4621: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4622: --
4623: IF l_debug_on THEN
4621: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4622: --
4623: IF l_debug_on THEN
4624: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4625: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4626: END IF;
4627: --
4628: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4629: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5572: END IF;
5573: --
5574: --
5575: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
5576: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5577: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
5578: raise FND_API.G_EXC_ERROR;
5579: END IF;
5580: --
5574: --
5575: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
5576: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5577: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
5578: raise FND_API.G_EXC_ERROR;
5579: END IF;
5580: --
5581: --
5582: IF l_shipping_control = 'SUPPLIER'
5625: END IF;
5626:
5627:
5628: WHEN wsh_dp_no_entity THEN
5629: x_return_status := FND_API.G_RET_STS_ERROR;
5630: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
5631: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
5632: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
5633: IF x_msg_count > 1 then
5644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
5645: END IF;
5646: --
5647: WHEN wsh_inv_list_type THEN
5648: x_return_status := FND_API.G_RET_STS_ERROR;
5649: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
5650: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
5651: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
5652: IF x_msg_count > 1 then
6040: l_min_quantity2 := l_minmaxoutrectype.min_remaining_quantity2;
6041: l_max_quantity2 := l_minmaxoutrectype.max_remaining_quantity2;
6042:
6043:
6044: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6045: raise others ;
6046: END IF;
6047:
6048:
6072: -- line to have one detail with secondary uom populated and one without
6073: -- depending on the released status. We should handle this case w/o
6074: -- erroring out.
6075:
6076: IF NVL(l_bad_quantities.requested_quantity_uom2, NVL(l_total_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6077: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6078: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6079: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6080: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
6073: -- depending on the released status. We should handle this case w/o
6074: -- erroring out.
6075:
6076: IF NVL(l_bad_quantities.requested_quantity_uom2, NVL(l_total_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6077: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6078: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6079: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6080: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
6081: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6074: -- erroring out.
6075:
6076: IF NVL(l_bad_quantities.requested_quantity_uom2, NVL(l_total_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6077: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6078: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6079: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6080: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
6081: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6082: = NVL(l_bad_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6075:
6076: IF NVL(l_bad_quantities.requested_quantity_uom2, NVL(l_total_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6077: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6078: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6079: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6080: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
6081: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6082: = NVL(l_bad_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6083: THEN
6077: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
6078: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6079: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6080: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
6081: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6082: = NVL(l_bad_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6083: THEN
6084: l_total_quantities.expected_quantity := l_total_quantities.expected_quantity
6085: + l_bad_quantities.expected_quantity;
6078: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6079: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
6080: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
6081: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6082: = NVL(l_bad_quantities.inventory_item_id, FND_API.G_MISS_NUM)
6083: THEN
6084: l_total_quantities.expected_quantity := l_total_quantities.expected_quantity
6085: + l_bad_quantities.expected_quantity;
6086: ELSE
6085: + l_bad_quantities.expected_quantity;
6086: ELSE
6087: CLOSE c_total_line_quantities;
6088: FND_MESSAGE.SET_NAME('WSH','WSH_DATA_CORRUPTION');
6089: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR);
6090: raise others ;
6091: END IF;
6092:
6093: END LOOP;
6262: END IF;
6263:
6264: END IF;
6265:
6266: x_return_status := FND_API.G_RET_STS_ERROR;
6267: -- Add_message is not needed because the caller Confirm_Delivery does this.
6268: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
6269:
6270: --
6626: wsh_debug_sv.log(l_module_name, 'l_org_type is: ', l_org_type);
6627: END IF;
6628: --
6629: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
6630: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6631: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
6632: raise e_record_ineligible;
6633: END IF;
6634: --
6756: END IF;
6757: --
6758: --
6759: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
6760: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6761: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
6762: raise e_record_ineligible;
6763: END IF;
6764: --
6877: IF l_debug_on THEN
6878: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6879: END IF;
6880:
6881: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
6882: open del_to_det_cur(p_dlvy_rec_tab(j).delivery_id);
6883: Fetch del_to_det_cur into l_tpw_temp;
6884: close del_to_det_cur;
6885: IF ( l_tpw_temp is null ) THEN
6908: IF l_debug_on THEN
6909: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6910: END IF;
6911:
6912: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
6913: raise e_record_ineligible;
6914: ELSE
6915: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6916: x_valid_index_tab(j) := j;
6936: IF l_debug_on THEN
6937: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type|| l_return_status);
6938: END IF;
6939:
6940: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN
6941: raise e_record_ineligible;
6942: ELSE
6943: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6944: x_valid_index_tab(j) := j;
6957: IF l_debug_on THEN
6958: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6959: END IF;
6960:
6961: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN
6962: raise e_record_ineligible;
6963: ELSE
6964: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6965: x_valid_index_tab(j) := j;
6976: IF l_debug_on THEN
6977: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6978: END IF;
6979:
6980: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS') ) THEN
6981: open del_to_det_cur(p_dlvy_rec_tab(j).delivery_id);
6982: Fetch del_to_det_cur into l_tpw_temp;
6983: close del_to_det_cur;
6984:
7024: IF l_debug_on THEN
7025: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
7026: END IF;
7027:
7028: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR ) THEN
7029: open det_stat_cur(p_dlvy_rec_tab(j).delivery_id);
7030: fetch det_stat_cur into l_atd_tpw_temp;
7031: close det_stat_cur;
7032:
7035: ELSE
7036: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
7037: x_valid_index_tab(j) := j;
7038: END IF;
7039: ELSIF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('CMS','TPW') ) THEN
7040: --RTV changes
7041: open del_to_det_sc_cur(p_dlvy_rec_tab(j).delivery_id);
7042: fetch del_to_det_sc_cur into l_x_sc_wdd;
7043: close del_to_det_sc_cur;
7100: IF l_debug_on THEN
7101: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
7102: END IF;
7103:
7104: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ( 'CMS','TPW') )
7105:
7106: THEN
7107: open del_to_det_cur(p_dlvy_rec_tab(j).delivery_id);
7108: fetch del_to_det_cur into l_tpw_temp;
7146: IF l_debug_on THEN
7147: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
7148: END IF;
7149:
7150: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS') ) THEN
7151: raise e_record_ineligible;
7152: ELSE
7153: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
7154: x_valid_index_tab(j) := j;
7266: )
7267: IS
7268: BEGIN
7269:
7270: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
7271: x_internal := p_internal;
7272: IF p_internal IS NULL THEN
7273: x_external := NULL;
7274: ELSE
7273: x_external := NULL;
7274: ELSE
7275: x_external := p_external;
7276: END IF;
7277: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
7278: x_external := p_external;
7279: IF x_external IS NULL THEN
7280: x_internal := NULL;
7281: ELSE
7300: )
7301: IS
7302: BEGIN
7303:
7304: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
7305: x_internal := p_internal;
7306: IF p_internal IS NULL THEN
7307: x_external := NULL;
7308: ELSE
7307: x_external := NULL;
7308: ELSE
7309: x_external := p_external;
7310: END IF;
7311: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
7312: x_external := p_external;
7313: IF x_external IS NULL THEN
7314: x_internal := NULL;
7315: ELSE
7334: permanently disabled.
7335: */
7336: --
7337:
7338: IF p_delivery_rec.NAME <> FND_API.G_MISS_CHAR
7339: OR p_delivery_rec.NAME IS NULL THEN
7340: x_delivery_rec.NAME :=
7341: p_delivery_rec.NAME;
7342: END IF;
7341: p_delivery_rec.NAME;
7342: END IF;
7343:
7344: -- RTV changes
7345: IF ( p_delivery_rec.CONSIGNEE_flag <> FND_API.G_MISS_CHAR
7346: OR p_delivery_rec.CONSIGNEE_flag IS NULL ) THEN
7347: x_delivery_rec.CONSIGNEE_flag :=
7348: p_delivery_rec.CONSIGNEE_flag;
7349: END IF;
7369: p_delivery_rec.POOLED_SHIP_TO_LOCATION_CODE,
7370: x_delivery_rec.POOLED_SHIP_TO_LOCATION_ID,
7371: x_delivery_rec.POOLED_SHIP_TO_LOCATION_CODE );
7372:
7373: IF p_delivery_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE
7374: OR p_delivery_rec.INITIAL_PICKUP_DATE IS NULL THEN
7375: x_delivery_rec.INITIAL_PICKUP_DATE :=
7376: p_delivery_rec.INITIAL_PICKUP_DATE;
7377: END IF;
7377: END IF;
7378:
7379: --Bug 3458160
7380: IF p_in_rec.caller = 'WSH_TPW_INBOUND' THEN
7381: IF p_delivery_rec.SHIPMENT_DIRECTION <> FND_API.G_MISS_CHAR THEN
7382: x_delivery_rec.SHIPMENT_DIRECTION :=
7383: p_delivery_rec.SHIPMENT_DIRECTION;
7384: END IF;
7385: IF p_delivery_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR THEN
7381: IF p_delivery_rec.SHIPMENT_DIRECTION <> FND_API.G_MISS_CHAR THEN
7382: x_delivery_rec.SHIPMENT_DIRECTION :=
7383: p_delivery_rec.SHIPMENT_DIRECTION;
7384: END IF;
7385: IF p_delivery_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR THEN
7386: x_delivery_rec.IGNORE_FOR_PLANNING :=
7387: p_delivery_rec.IGNORE_FOR_PLANNING;
7388: END IF;
7389: ELSIF p_in_rec.caller = 'WSH_INBOUND' THEN
7386: x_delivery_rec.IGNORE_FOR_PLANNING :=
7387: p_delivery_rec.IGNORE_FOR_PLANNING;
7388: END IF;
7389: ELSIF p_in_rec.caller = 'WSH_INBOUND' THEN
7390: IF p_delivery_rec.DELIVERED_DATE <> FND_API.G_MISS_DATE
7391: OR p_delivery_rec.DELIVERED_DATE IS NULL THEN
7392: x_delivery_rec.DELIVERED_DATE :=
7393: p_delivery_rec.DELIVERED_DATE;
7394: END IF;
7399: p_delivery_rec.ULTIMATE_DROPOFF_LOCATION_CODE,
7400: x_delivery_rec.ULTIMATE_DROPOFF_LOCATION_ID,
7401: x_delivery_rec.ULTIMATE_DROPOFF_LOCATION_CODE );
7402:
7403: IF p_delivery_rec.NUMBER_OF_LPN <> FND_API.G_MISS_NUM
7404: OR p_delivery_rec.NUMBER_OF_LPN IS NULL THEN
7405: x_delivery_rec.NUMBER_OF_LPN :=
7406: p_delivery_rec.NUMBER_OF_LPN;
7407: END IF;
7404: OR p_delivery_rec.NUMBER_OF_LPN IS NULL THEN
7405: x_delivery_rec.NUMBER_OF_LPN :=
7406: p_delivery_rec.NUMBER_OF_LPN;
7407: END IF;
7408: IF p_delivery_rec.WAYBILL <> FND_API.G_MISS_CHAR
7409: OR p_delivery_rec.WAYBILL IS NULL THEN
7410: x_delivery_rec.WAYBILL :=
7411: p_delivery_rec.WAYBILL;
7412: END IF;
7415: p_delivery_rec.CUSTOMER_NUMBER,
7416: x_delivery_rec.CUSTOMER_ID,
7417: x_delivery_rec.CUSTOMER_NUMBER );
7418: --Modified R12.1.1 LSP PROJECT (anvarshn)
7419: /*IF p_delivery_rec.client_id <> FND_API.G_MISS_NUM
7420: OR p_delivery_rec.client_id IS NULL THEN
7421: x_delivery_rec.client_id :=
7422: p_delivery_rec.client_id;
7423: END IF;*/
7442: p_delivery_rec.CARRIER_CODE,
7443: x_delivery_rec.CARRIER_ID,
7444: x_delivery_rec.CARRIER_CODE );
7445:
7446: IF p_delivery_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
7447: OR p_delivery_rec.SERVICE_LEVEL IS NULL THEN
7448: x_delivery_rec.SERVICE_LEVEL :=
7449: p_delivery_rec.SERVICE_LEVEL;
7450: END IF;
7447: OR p_delivery_rec.SERVICE_LEVEL IS NULL THEN
7448: x_delivery_rec.SERVICE_LEVEL :=
7449: p_delivery_rec.SERVICE_LEVEL;
7450: END IF;
7451: IF p_delivery_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
7452: OR p_delivery_rec.MODE_OF_TRANSPORT IS NULL THEN
7453: x_delivery_rec.MODE_OF_TRANSPORT :=
7454: p_delivery_rec.MODE_OF_TRANSPORT;
7455: END IF;
7463: p_delivery_rec.FOB_LOCATION_CODE,
7464: x_delivery_rec.FOB_LOCATION_ID,
7465: x_delivery_rec.FOB_LOCATION_CODE );
7466:
7467: IF p_delivery_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
7468: OR p_delivery_rec.GROSS_WEIGHT IS NULL THEN
7469: x_delivery_rec.GROSS_WEIGHT :=
7470: p_delivery_rec.GROSS_WEIGHT;
7471: END IF;
7468: OR p_delivery_rec.GROSS_WEIGHT IS NULL THEN
7469: x_delivery_rec.GROSS_WEIGHT :=
7470: p_delivery_rec.GROSS_WEIGHT;
7471: END IF;
7472: IF p_delivery_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
7473: OR p_delivery_rec.NET_WEIGHT IS NULL THEN
7474: x_delivery_rec.NET_WEIGHT :=
7475: p_delivery_rec.NET_WEIGHT;
7476: END IF;
7479: p_delivery_rec.WEIGHT_UOM_DESC,
7480: x_delivery_rec.WEIGHT_UOM_CODE,
7481: x_delivery_rec.WEIGHT_UOM_DESC );
7482:
7483: IF p_delivery_rec.VOLUME <> FND_API.G_MISS_NUM
7484: OR p_delivery_rec.VOLUME IS NULL THEN
7485: x_delivery_rec.VOLUME :=
7486: p_delivery_rec.VOLUME;
7487: END IF;
7491: x_delivery_rec.VOLUME_UOM_CODE,
7492: x_delivery_rec.VOLUME_UOM_DESC );
7493:
7494: -- bug 3666967 - need wv_frozen_flag when creating new delivery through public api.
7495: IF p_delivery_rec.wv_frozen_flag <> FND_API.G_MISS_CHAR THEN
7496: x_delivery_rec.wv_frozen_flag :=
7497: p_delivery_rec.wv_frozen_flag;
7498: END IF;
7499: -- end bug 3666967
7498: END IF;
7499: -- end bug 3666967
7500:
7501: -- Bug#4539613 : Consider the Prorate weight flag while populating output record.
7502: IF p_delivery_rec.prorate_wt_flag <> FND_API.G_MISS_CHAR
7503: OR p_delivery_rec.prorate_wt_flag IS NULL THEN
7504: x_delivery_rec.prorate_wt_flag :=
7505: p_delivery_rec.prorate_wt_flag;
7506: END IF;
7504: x_delivery_rec.prorate_wt_flag :=
7505: p_delivery_rec.prorate_wt_flag;
7506: END IF;
7507:
7508: IF p_delivery_rec.LOADING_SEQUENCE <> FND_API.G_MISS_NUM
7509: OR p_delivery_rec.LOADING_SEQUENCE IS NULL THEN
7510: x_delivery_rec.LOADING_SEQUENCE :=
7511: p_delivery_rec.LOADING_SEQUENCE;
7512: END IF;
7515: p_delivery_rec.LOADING_ORDER_DESC,
7516: x_delivery_rec.LOADING_ORDER_FLAG,
7517: x_delivery_rec.LOADING_ORDER_DESC );
7518:
7519: IF p_delivery_rec.ADDITIONAL_SHIPMENT_INFO <> FND_API.G_MISS_CHAR
7520: OR p_delivery_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
7521: x_delivery_rec.ADDITIONAL_SHIPMENT_INFO :=
7522: p_delivery_rec.ADDITIONAL_SHIPMENT_INFO;
7523: END IF;
7520: OR p_delivery_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
7521: x_delivery_rec.ADDITIONAL_SHIPMENT_INFO :=
7522: p_delivery_rec.ADDITIONAL_SHIPMENT_INFO;
7523: END IF;
7524: IF p_delivery_rec.PORT_OF_LOADING <> FND_API.G_MISS_CHAR
7525: OR p_delivery_rec.PORT_OF_LOADING IS NULL THEN
7526: x_delivery_rec.PORT_OF_LOADING :=
7527: p_delivery_rec.PORT_OF_LOADING;
7528: END IF;
7525: OR p_delivery_rec.PORT_OF_LOADING IS NULL THEN
7526: x_delivery_rec.PORT_OF_LOADING :=
7527: p_delivery_rec.PORT_OF_LOADING;
7528: END IF;
7529: IF p_delivery_rec.ROUTED_EXPORT_TXN <> FND_API.G_MISS_CHAR
7530: OR p_delivery_rec.ROUTED_EXPORT_TXN IS NULL THEN
7531: x_delivery_rec.ROUTED_EXPORT_TXN :=
7532: p_delivery_rec.ROUTED_EXPORT_TXN;
7533: END IF;
7530: OR p_delivery_rec.ROUTED_EXPORT_TXN IS NULL THEN
7531: x_delivery_rec.ROUTED_EXPORT_TXN :=
7532: p_delivery_rec.ROUTED_EXPORT_TXN;
7533: END IF;
7534: IF p_delivery_rec.FTZ_NUMBER <> FND_API.G_MISS_CHAR
7535: OR p_delivery_rec.FTZ_NUMBER IS NULL THEN
7536: x_delivery_rec.FTZ_NUMBER :=
7537: p_delivery_rec.FTZ_NUMBER;
7538: END IF;
7535: OR p_delivery_rec.FTZ_NUMBER IS NULL THEN
7536: x_delivery_rec.FTZ_NUMBER :=
7537: p_delivery_rec.FTZ_NUMBER;
7538: END IF;
7539: IF p_delivery_rec.ENTRY_NUMBER <> FND_API.G_MISS_CHAR
7540: OR p_delivery_rec.ENTRY_NUMBER IS NULL THEN
7541: x_delivery_rec.ENTRY_NUMBER :=
7542: p_delivery_rec.ENTRY_NUMBER;
7543: END IF;
7540: OR p_delivery_rec.ENTRY_NUMBER IS NULL THEN
7541: x_delivery_rec.ENTRY_NUMBER :=
7542: p_delivery_rec.ENTRY_NUMBER;
7543: END IF;
7544: IF p_delivery_rec.IN_BOND_CODE <> FND_API.G_MISS_CHAR
7545: OR p_delivery_rec.IN_BOND_CODE IS NULL THEN
7546: x_delivery_rec.IN_BOND_CODE :=
7547: p_delivery_rec.IN_BOND_CODE;
7548: END IF;
7545: OR p_delivery_rec.IN_BOND_CODE IS NULL THEN
7546: x_delivery_rec.IN_BOND_CODE :=
7547: p_delivery_rec.IN_BOND_CODE;
7548: END IF;
7549: IF p_delivery_rec.SHIPPING_MARKS <> FND_API.G_MISS_CHAR
7550: OR p_delivery_rec.SHIPPING_MARKS IS NULL THEN
7551: x_delivery_rec.SHIPPING_MARKS :=
7552: p_delivery_rec.SHIPPING_MARKS;
7553: END IF;
7550: OR p_delivery_rec.SHIPPING_MARKS IS NULL THEN
7551: x_delivery_rec.SHIPPING_MARKS :=
7552: p_delivery_rec.SHIPPING_MARKS;
7553: END IF;
7554: IF p_delivery_rec.PROBLEM_CONTACT_REFERENCE <> FND_API.G_MISS_CHAR
7555: OR p_delivery_rec.PROBLEM_CONTACT_REFERENCE IS NULL THEN
7556: x_delivery_rec.PROBLEM_CONTACT_REFERENCE :=
7557: p_delivery_rec.PROBLEM_CONTACT_REFERENCE;
7558: END IF;
7555: OR p_delivery_rec.PROBLEM_CONTACT_REFERENCE IS NULL THEN
7556: x_delivery_rec.PROBLEM_CONTACT_REFERENCE :=
7557: p_delivery_rec.PROBLEM_CONTACT_REFERENCE;
7558: END IF;
7559: IF p_delivery_rec.COD_AMOUNT <> FND_API.G_MISS_NUM
7560: OR p_delivery_rec.COD_AMOUNT IS NULL THEN
7561: x_delivery_rec.COD_AMOUNT :=
7562: p_delivery_rec.COD_AMOUNT;
7563: END IF;
7560: OR p_delivery_rec.COD_AMOUNT IS NULL THEN
7561: x_delivery_rec.COD_AMOUNT :=
7562: p_delivery_rec.COD_AMOUNT;
7563: END IF;
7564: IF p_delivery_rec.COD_CURRENCY_CODE <> FND_API.G_MISS_CHAR
7565: OR p_delivery_rec.COD_CURRENCY_CODE IS NULL THEN
7566: x_delivery_rec.COD_CURRENCY_CODE :=
7567: p_delivery_rec.COD_CURRENCY_CODE;
7568: END IF;
7565: OR p_delivery_rec.COD_CURRENCY_CODE IS NULL THEN
7566: x_delivery_rec.COD_CURRENCY_CODE :=
7567: p_delivery_rec.COD_CURRENCY_CODE;
7568: END IF;
7569: IF p_delivery_rec.COD_REMIT_TO <> FND_API.G_MISS_CHAR
7570: OR p_delivery_rec.COD_REMIT_TO IS NULL THEN
7571: x_delivery_rec.COD_REMIT_TO :=
7572: p_delivery_rec.COD_REMIT_TO;
7573: END IF;
7570: OR p_delivery_rec.COD_REMIT_TO IS NULL THEN
7571: x_delivery_rec.COD_REMIT_TO :=
7572: p_delivery_rec.COD_REMIT_TO;
7573: END IF;
7574: IF p_delivery_rec.COD_CHARGE_PAID_BY <> FND_API.G_MISS_CHAR
7575: OR p_delivery_rec.COD_CHARGE_PAID_BY IS NULL THEN
7576: x_delivery_rec.COD_CHARGE_PAID_BY :=
7577: p_delivery_rec.COD_CHARGE_PAID_BY;
7578: END IF;
7575: OR p_delivery_rec.COD_CHARGE_PAID_BY IS NULL THEN
7576: x_delivery_rec.COD_CHARGE_PAID_BY :=
7577: p_delivery_rec.COD_CHARGE_PAID_BY;
7578: END IF;
7579: IF p_delivery_rec.AUTO_SC_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
7580: OR p_delivery_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
7581: x_delivery_rec.AUTO_SC_EXCLUDE_FLAG :=
7582: p_delivery_rec.AUTO_SC_EXCLUDE_FLAG;
7583: END IF;
7580: OR p_delivery_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
7581: x_delivery_rec.AUTO_SC_EXCLUDE_FLAG :=
7582: p_delivery_rec.AUTO_SC_EXCLUDE_FLAG;
7583: END IF;
7584: IF p_delivery_rec.AUTO_AP_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
7585: OR p_delivery_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
7586: x_delivery_rec.AUTO_AP_EXCLUDE_FLAG :=
7587: p_delivery_rec.AUTO_AP_EXCLUDE_FLAG;
7588: END IF;
7585: OR p_delivery_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
7586: x_delivery_rec.AUTO_AP_EXCLUDE_FLAG :=
7587: p_delivery_rec.AUTO_AP_EXCLUDE_FLAG;
7588: END IF;
7589: IF p_delivery_rec.attribute1 <> FND_API.G_MISS_CHAR
7590: OR p_delivery_rec.attribute1 IS NULL THEN
7591: x_delivery_rec.attribute1 :=
7592: p_delivery_rec.attribute1;
7593: END IF;
7590: OR p_delivery_rec.attribute1 IS NULL THEN
7591: x_delivery_rec.attribute1 :=
7592: p_delivery_rec.attribute1;
7593: END IF;
7594: IF p_delivery_rec.attribute2 <> FND_API.G_MISS_CHAR
7595: OR p_delivery_rec.attribute2 IS NULL THEN
7596: x_delivery_rec.attribute2 :=
7597: p_delivery_rec.attribute2;
7598: END IF;
7595: OR p_delivery_rec.attribute2 IS NULL THEN
7596: x_delivery_rec.attribute2 :=
7597: p_delivery_rec.attribute2;
7598: END IF;
7599: IF p_delivery_rec.attribute3 <> FND_API.G_MISS_CHAR
7600: OR p_delivery_rec.attribute3 IS NULL THEN
7601: x_delivery_rec.attribute3 :=
7602: p_delivery_rec.attribute3;
7603: END IF;
7600: OR p_delivery_rec.attribute3 IS NULL THEN
7601: x_delivery_rec.attribute3 :=
7602: p_delivery_rec.attribute3;
7603: END IF;
7604: IF p_delivery_rec.attribute4 <> FND_API.G_MISS_CHAR
7605: OR p_delivery_rec.attribute4 IS NULL THEN
7606: x_delivery_rec.attribute4 :=
7607: p_delivery_rec.attribute4;
7608: END IF;
7605: OR p_delivery_rec.attribute4 IS NULL THEN
7606: x_delivery_rec.attribute4 :=
7607: p_delivery_rec.attribute4;
7608: END IF;
7609: IF p_delivery_rec.attribute5 <> FND_API.G_MISS_CHAR
7610: OR p_delivery_rec.attribute5 IS NULL THEN
7611: x_delivery_rec.attribute5 :=
7612: p_delivery_rec.attribute5;
7613: END IF;
7610: OR p_delivery_rec.attribute5 IS NULL THEN
7611: x_delivery_rec.attribute5 :=
7612: p_delivery_rec.attribute5;
7613: END IF;
7614: IF p_delivery_rec.attribute6 <> FND_API.G_MISS_CHAR
7615: OR p_delivery_rec.attribute6 IS NULL THEN
7616: x_delivery_rec.attribute6 :=
7617: p_delivery_rec.attribute6;
7618: END IF;
7615: OR p_delivery_rec.attribute6 IS NULL THEN
7616: x_delivery_rec.attribute6 :=
7617: p_delivery_rec.attribute6;
7618: END IF;
7619: IF p_delivery_rec.attribute7 <> FND_API.G_MISS_CHAR
7620: OR p_delivery_rec.attribute7 IS NULL THEN
7621: x_delivery_rec.attribute7 :=
7622: p_delivery_rec.attribute7;
7623: END IF;
7620: OR p_delivery_rec.attribute7 IS NULL THEN
7621: x_delivery_rec.attribute7 :=
7622: p_delivery_rec.attribute7;
7623: END IF;
7624: IF p_delivery_rec.attribute8 <> FND_API.G_MISS_CHAR
7625: OR p_delivery_rec.attribute8 IS NULL THEN
7626: x_delivery_rec.attribute8 :=
7627: p_delivery_rec.attribute8;
7628: END IF;
7625: OR p_delivery_rec.attribute8 IS NULL THEN
7626: x_delivery_rec.attribute8 :=
7627: p_delivery_rec.attribute8;
7628: END IF;
7629: IF p_delivery_rec.attribute9 <> FND_API.G_MISS_CHAR
7630: OR p_delivery_rec.attribute9 IS NULL THEN
7631: x_delivery_rec.attribute9 :=
7632: p_delivery_rec.attribute9;
7633: END IF;
7630: OR p_delivery_rec.attribute9 IS NULL THEN
7631: x_delivery_rec.attribute9 :=
7632: p_delivery_rec.attribute9;
7633: END IF;
7634: IF p_delivery_rec.attribute10 <> FND_API.G_MISS_CHAR
7635: OR p_delivery_rec.attribute10 IS NULL THEN
7636: x_delivery_rec.attribute10 :=
7637: p_delivery_rec.attribute10;
7638: END IF;
7635: OR p_delivery_rec.attribute10 IS NULL THEN
7636: x_delivery_rec.attribute10 :=
7637: p_delivery_rec.attribute10;
7638: END IF;
7639: IF p_delivery_rec.attribute11 <> FND_API.G_MISS_CHAR
7640: OR p_delivery_rec.attribute11 IS NULL THEN
7641: x_delivery_rec.attribute11 :=
7642: p_delivery_rec.attribute11;
7643: END IF;
7640: OR p_delivery_rec.attribute11 IS NULL THEN
7641: x_delivery_rec.attribute11 :=
7642: p_delivery_rec.attribute11;
7643: END IF;
7644: IF p_delivery_rec.attribute12 <> FND_API.G_MISS_CHAR
7645: OR p_delivery_rec.attribute12 IS NULL THEN
7646: x_delivery_rec.attribute12 :=
7647: p_delivery_rec.attribute12;
7648: END IF;
7645: OR p_delivery_rec.attribute12 IS NULL THEN
7646: x_delivery_rec.attribute12 :=
7647: p_delivery_rec.attribute12;
7648: END IF;
7649: IF p_delivery_rec.attribute13 <> FND_API.G_MISS_CHAR
7650: OR p_delivery_rec.attribute13 IS NULL THEN
7651: x_delivery_rec.attribute13 :=
7652: p_delivery_rec.attribute13;
7653: END IF;
7650: OR p_delivery_rec.attribute13 IS NULL THEN
7651: x_delivery_rec.attribute13 :=
7652: p_delivery_rec.attribute13;
7653: END IF;
7654: IF p_delivery_rec.attribute14 <> FND_API.G_MISS_CHAR
7655: OR p_delivery_rec.attribute14 IS NULL THEN
7656: x_delivery_rec.attribute14 :=
7657: p_delivery_rec.attribute14;
7658: END IF;
7655: OR p_delivery_rec.attribute14 IS NULL THEN
7656: x_delivery_rec.attribute14 :=
7657: p_delivery_rec.attribute14;
7658: END IF;
7659: IF p_delivery_rec.attribute15 <> FND_API.G_MISS_CHAR
7660: OR p_delivery_rec.attribute15 IS NULL THEN
7661: x_delivery_rec.attribute15 :=
7662: p_delivery_rec.attribute15;
7663: END IF;
7660: OR p_delivery_rec.attribute15 IS NULL THEN
7661: x_delivery_rec.attribute15 :=
7662: p_delivery_rec.attribute15;
7663: END IF;
7664: IF p_delivery_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
7665: OR p_delivery_rec.ATTRIBUTE_CATEGORY IS NULL THEN
7666: x_delivery_rec.ATTRIBUTE_CATEGORY :=
7667: p_delivery_rec.ATTRIBUTE_CATEGORY;
7668: END IF;
7665: OR p_delivery_rec.ATTRIBUTE_CATEGORY IS NULL THEN
7666: x_delivery_rec.ATTRIBUTE_CATEGORY :=
7667: p_delivery_rec.ATTRIBUTE_CATEGORY;
7668: END IF;
7669: IF p_delivery_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
7670: OR p_delivery_rec.tp_attribute1 IS NULL THEN
7671: x_delivery_rec.tp_attribute1 :=
7672: p_delivery_rec.tp_attribute1;
7673: END IF;
7670: OR p_delivery_rec.tp_attribute1 IS NULL THEN
7671: x_delivery_rec.tp_attribute1 :=
7672: p_delivery_rec.tp_attribute1;
7673: END IF;
7674: IF p_delivery_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
7675: OR p_delivery_rec.tp_attribute2 IS NULL THEN
7676: x_delivery_rec.tp_attribute2 :=
7677: p_delivery_rec.tp_attribute2;
7678: END IF;
7675: OR p_delivery_rec.tp_attribute2 IS NULL THEN
7676: x_delivery_rec.tp_attribute2 :=
7677: p_delivery_rec.tp_attribute2;
7678: END IF;
7679: IF p_delivery_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
7680: OR p_delivery_rec.tp_attribute3 IS NULL THEN
7681: x_delivery_rec.tp_attribute3 :=
7682: p_delivery_rec.tp_attribute3;
7683: END IF;
7680: OR p_delivery_rec.tp_attribute3 IS NULL THEN
7681: x_delivery_rec.tp_attribute3 :=
7682: p_delivery_rec.tp_attribute3;
7683: END IF;
7684: IF p_delivery_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
7685: OR p_delivery_rec.tp_attribute4 IS NULL THEN
7686: x_delivery_rec.tp_attribute4 :=
7687: p_delivery_rec.tp_attribute4;
7688: END IF;
7685: OR p_delivery_rec.tp_attribute4 IS NULL THEN
7686: x_delivery_rec.tp_attribute4 :=
7687: p_delivery_rec.tp_attribute4;
7688: END IF;
7689: IF p_delivery_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
7690: OR p_delivery_rec.tp_attribute5 IS NULL THEN
7691: x_delivery_rec.tp_attribute5 :=
7692: p_delivery_rec.tp_attribute5;
7693: END IF;
7690: OR p_delivery_rec.tp_attribute5 IS NULL THEN
7691: x_delivery_rec.tp_attribute5 :=
7692: p_delivery_rec.tp_attribute5;
7693: END IF;
7694: IF p_delivery_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
7695: OR p_delivery_rec.tp_attribute6 IS NULL THEN
7696: x_delivery_rec.tp_attribute6 :=
7697: p_delivery_rec.tp_attribute6;
7698: END IF;
7695: OR p_delivery_rec.tp_attribute6 IS NULL THEN
7696: x_delivery_rec.tp_attribute6 :=
7697: p_delivery_rec.tp_attribute6;
7698: END IF;
7699: IF p_delivery_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
7700: OR p_delivery_rec.tp_attribute7 IS NULL THEN
7701: x_delivery_rec.tp_attribute7 :=
7702: p_delivery_rec.tp_attribute7;
7703: END IF;
7700: OR p_delivery_rec.tp_attribute7 IS NULL THEN
7701: x_delivery_rec.tp_attribute7 :=
7702: p_delivery_rec.tp_attribute7;
7703: END IF;
7704: IF p_delivery_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
7705: OR p_delivery_rec.tp_attribute8 IS NULL THEN
7706: x_delivery_rec.tp_attribute8 :=
7707: p_delivery_rec.tp_attribute8;
7708: END IF;
7705: OR p_delivery_rec.tp_attribute8 IS NULL THEN
7706: x_delivery_rec.tp_attribute8 :=
7707: p_delivery_rec.tp_attribute8;
7708: END IF;
7709: IF p_delivery_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
7710: OR p_delivery_rec.tp_attribute9 IS NULL THEN
7711: x_delivery_rec.tp_attribute9 :=
7712: p_delivery_rec.tp_attribute9;
7713: END IF;
7710: OR p_delivery_rec.tp_attribute9 IS NULL THEN
7711: x_delivery_rec.tp_attribute9 :=
7712: p_delivery_rec.tp_attribute9;
7713: END IF;
7714: IF p_delivery_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
7715: OR p_delivery_rec.tp_attribute10 IS NULL THEN
7716: x_delivery_rec.tp_attribute10 :=
7717: p_delivery_rec.tp_attribute10;
7718: END IF;
7715: OR p_delivery_rec.tp_attribute10 IS NULL THEN
7716: x_delivery_rec.tp_attribute10 :=
7717: p_delivery_rec.tp_attribute10;
7718: END IF;
7719: IF p_delivery_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
7720: OR p_delivery_rec.tp_attribute11 IS NULL THEN
7721: x_delivery_rec.tp_attribute11 :=
7722: p_delivery_rec.tp_attribute11;
7723: END IF;
7720: OR p_delivery_rec.tp_attribute11 IS NULL THEN
7721: x_delivery_rec.tp_attribute11 :=
7722: p_delivery_rec.tp_attribute11;
7723: END IF;
7724: IF p_delivery_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
7725: OR p_delivery_rec.tp_attribute12 IS NULL THEN
7726: x_delivery_rec.tp_attribute12 :=
7727: p_delivery_rec.tp_attribute12;
7728: END IF;
7725: OR p_delivery_rec.tp_attribute12 IS NULL THEN
7726: x_delivery_rec.tp_attribute12 :=
7727: p_delivery_rec.tp_attribute12;
7728: END IF;
7729: IF p_delivery_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
7730: OR p_delivery_rec.tp_attribute13 IS NULL THEN
7731: x_delivery_rec.tp_attribute13 :=
7732: p_delivery_rec.tp_attribute13;
7733: END IF;
7730: OR p_delivery_rec.tp_attribute13 IS NULL THEN
7731: x_delivery_rec.tp_attribute13 :=
7732: p_delivery_rec.tp_attribute13;
7733: END IF;
7734: IF p_delivery_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
7735: OR p_delivery_rec.tp_attribute14 IS NULL THEN
7736: x_delivery_rec.tp_attribute14 :=
7737: p_delivery_rec.tp_attribute14;
7738: END IF;
7735: OR p_delivery_rec.tp_attribute14 IS NULL THEN
7736: x_delivery_rec.tp_attribute14 :=
7737: p_delivery_rec.tp_attribute14;
7738: END IF;
7739: IF p_delivery_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
7740: OR p_delivery_rec.tp_attribute15 IS NULL THEN
7741: x_delivery_rec.tp_attribute15 :=
7742: p_delivery_rec.tp_attribute15;
7743: END IF;
7740: OR p_delivery_rec.tp_attribute15 IS NULL THEN
7741: x_delivery_rec.tp_attribute15 :=
7742: p_delivery_rec.tp_attribute15;
7743: END IF;
7744: IF p_delivery_rec.tp_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
7745: OR p_delivery_rec.tp_ATTRIBUTE_CATEGORY IS NULL THEN
7746: x_delivery_rec.tp_ATTRIBUTE_CATEGORY :=
7747: p_delivery_rec.tp_ATTRIBUTE_CATEGORY;
7748: END IF;
7745: OR p_delivery_rec.tp_ATTRIBUTE_CATEGORY IS NULL THEN
7746: x_delivery_rec.tp_ATTRIBUTE_CATEGORY :=
7747: p_delivery_rec.tp_ATTRIBUTE_CATEGORY;
7748: END IF;
7749: IF p_delivery_rec.global_attribute1 <> FND_API.G_MISS_CHAR
7750: OR p_delivery_rec.global_attribute1 IS NULL THEN
7751: x_delivery_rec.global_attribute1 :=
7752: p_delivery_rec.global_attribute1;
7753: END IF;
7750: OR p_delivery_rec.global_attribute1 IS NULL THEN
7751: x_delivery_rec.global_attribute1 :=
7752: p_delivery_rec.global_attribute1;
7753: END IF;
7754: IF p_delivery_rec.global_attribute2 <> FND_API.G_MISS_CHAR
7755: OR p_delivery_rec.global_attribute2 IS NULL THEN
7756: x_delivery_rec.global_attribute2 :=
7757: p_delivery_rec.global_attribute2;
7758: END IF;
7755: OR p_delivery_rec.global_attribute2 IS NULL THEN
7756: x_delivery_rec.global_attribute2 :=
7757: p_delivery_rec.global_attribute2;
7758: END IF;
7759: IF p_delivery_rec.global_attribute3 <> FND_API.G_MISS_CHAR
7760: OR p_delivery_rec.global_attribute3 IS NULL THEN
7761: x_delivery_rec.global_attribute3 :=
7762: p_delivery_rec.global_attribute3;
7763: END IF;
7760: OR p_delivery_rec.global_attribute3 IS NULL THEN
7761: x_delivery_rec.global_attribute3 :=
7762: p_delivery_rec.global_attribute3;
7763: END IF;
7764: IF p_delivery_rec.global_attribute4 <> FND_API.G_MISS_CHAR
7765: OR p_delivery_rec.global_attribute4 IS NULL THEN
7766: x_delivery_rec.global_attribute4 :=
7767: p_delivery_rec.global_attribute4;
7768: END IF;
7765: OR p_delivery_rec.global_attribute4 IS NULL THEN
7766: x_delivery_rec.global_attribute4 :=
7767: p_delivery_rec.global_attribute4;
7768: END IF;
7769: IF p_delivery_rec.global_attribute5 <> FND_API.G_MISS_CHAR
7770: OR p_delivery_rec.global_attribute5 IS NULL THEN
7771: x_delivery_rec.global_attribute5 :=
7772: p_delivery_rec.global_attribute5;
7773: END IF;
7770: OR p_delivery_rec.global_attribute5 IS NULL THEN
7771: x_delivery_rec.global_attribute5 :=
7772: p_delivery_rec.global_attribute5;
7773: END IF;
7774: IF p_delivery_rec.global_attribute6 <> FND_API.G_MISS_CHAR
7775: OR p_delivery_rec.global_attribute6 IS NULL THEN
7776: x_delivery_rec.global_attribute6 :=
7777: p_delivery_rec.global_attribute6;
7778: END IF;
7775: OR p_delivery_rec.global_attribute6 IS NULL THEN
7776: x_delivery_rec.global_attribute6 :=
7777: p_delivery_rec.global_attribute6;
7778: END IF;
7779: IF p_delivery_rec.global_attribute7 <> FND_API.G_MISS_CHAR
7780: OR p_delivery_rec.global_attribute7 IS NULL THEN
7781: x_delivery_rec.global_attribute7 :=
7782: p_delivery_rec.global_attribute7;
7783: END IF;
7780: OR p_delivery_rec.global_attribute7 IS NULL THEN
7781: x_delivery_rec.global_attribute7 :=
7782: p_delivery_rec.global_attribute7;
7783: END IF;
7784: IF p_delivery_rec.global_attribute8 <> FND_API.G_MISS_CHAR
7785: OR p_delivery_rec.global_attribute8 IS NULL THEN
7786: x_delivery_rec.global_attribute8 :=
7787: p_delivery_rec.global_attribute8;
7788: END IF;
7785: OR p_delivery_rec.global_attribute8 IS NULL THEN
7786: x_delivery_rec.global_attribute8 :=
7787: p_delivery_rec.global_attribute8;
7788: END IF;
7789: IF p_delivery_rec.global_attribute9 <> FND_API.G_MISS_CHAR
7790: OR p_delivery_rec.global_attribute9 IS NULL THEN
7791: x_delivery_rec.global_attribute9 :=
7792: p_delivery_rec.global_attribute9;
7793: END IF;
7790: OR p_delivery_rec.global_attribute9 IS NULL THEN
7791: x_delivery_rec.global_attribute9 :=
7792: p_delivery_rec.global_attribute9;
7793: END IF;
7794: IF p_delivery_rec.global_attribute10 <> FND_API.G_MISS_CHAR
7795: OR p_delivery_rec.global_attribute10 IS NULL THEN
7796: x_delivery_rec.global_attribute10 :=
7797: p_delivery_rec.global_attribute10;
7798: END IF;
7795: OR p_delivery_rec.global_attribute10 IS NULL THEN
7796: x_delivery_rec.global_attribute10 :=
7797: p_delivery_rec.global_attribute10;
7798: END IF;
7799: IF p_delivery_rec.global_attribute11 <> FND_API.G_MISS_CHAR
7800: OR p_delivery_rec.global_attribute11 IS NULL THEN
7801: x_delivery_rec.global_attribute11 :=
7802: p_delivery_rec.global_attribute11;
7803: END IF;
7800: OR p_delivery_rec.global_attribute11 IS NULL THEN
7801: x_delivery_rec.global_attribute11 :=
7802: p_delivery_rec.global_attribute11;
7803: END IF;
7804: IF p_delivery_rec.global_attribute12 <> FND_API.G_MISS_CHAR
7805: OR p_delivery_rec.global_attribute12 IS NULL THEN
7806: x_delivery_rec.global_attribute12 :=
7807: p_delivery_rec.global_attribute12;
7808: END IF;
7805: OR p_delivery_rec.global_attribute12 IS NULL THEN
7806: x_delivery_rec.global_attribute12 :=
7807: p_delivery_rec.global_attribute12;
7808: END IF;
7809: IF p_delivery_rec.global_attribute13 <> FND_API.G_MISS_CHAR
7810: OR p_delivery_rec.global_attribute13 IS NULL THEN
7811: x_delivery_rec.global_attribute13 :=
7812: p_delivery_rec.global_attribute13;
7813: END IF;
7810: OR p_delivery_rec.global_attribute13 IS NULL THEN
7811: x_delivery_rec.global_attribute13 :=
7812: p_delivery_rec.global_attribute13;
7813: END IF;
7814: IF p_delivery_rec.global_attribute14 <> FND_API.G_MISS_CHAR
7815: OR p_delivery_rec.global_attribute14 IS NULL THEN
7816: x_delivery_rec.global_attribute14 :=
7817: p_delivery_rec.global_attribute14;
7818: END IF;
7815: OR p_delivery_rec.global_attribute14 IS NULL THEN
7816: x_delivery_rec.global_attribute14 :=
7817: p_delivery_rec.global_attribute14;
7818: END IF;
7819: IF p_delivery_rec.global_attribute15 <> FND_API.G_MISS_CHAR
7820: OR p_delivery_rec.global_attribute15 IS NULL THEN
7821: x_delivery_rec.global_attribute15 :=
7822: p_delivery_rec.global_attribute15;
7823: END IF;
7820: OR p_delivery_rec.global_attribute15 IS NULL THEN
7821: x_delivery_rec.global_attribute15 :=
7822: p_delivery_rec.global_attribute15;
7823: END IF;
7824: IF p_delivery_rec.global_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
7825: OR p_delivery_rec.global_ATTRIBUTE_CATEGORY IS NULL THEN
7826: x_delivery_rec.global_ATTRIBUTE_CATEGORY :=
7827: p_delivery_rec.global_ATTRIBUTE_CATEGORY;
7828: END IF;
7825: OR p_delivery_rec.global_ATTRIBUTE_CATEGORY IS NULL THEN
7826: x_delivery_rec.global_ATTRIBUTE_CATEGORY :=
7827: p_delivery_rec.global_ATTRIBUTE_CATEGORY;
7828: END IF;
7829: IF p_delivery_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE
7830: OR p_delivery_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
7831: x_delivery_rec.ULTIMATE_DROPOFF_DATE :=
7832: p_delivery_rec.ULTIMATE_DROPOFF_DATE;
7833: END IF;
7830: OR p_delivery_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
7831: x_delivery_rec.ULTIMATE_DROPOFF_DATE :=
7832: p_delivery_rec.ULTIMATE_DROPOFF_DATE;
7833: END IF;
7834: IF p_delivery_rec.DOCK_CODE <> FND_API.G_MISS_CHAR
7835: OR p_delivery_rec.DOCK_CODE IS NULL THEN
7836: x_delivery_rec.DOCK_CODE :=
7837: p_delivery_rec.DOCK_CODE;
7838: END IF;
7835: OR p_delivery_rec.DOCK_CODE IS NULL THEN
7836: x_delivery_rec.DOCK_CODE :=
7837: p_delivery_rec.DOCK_CODE;
7838: END IF;
7839: IF p_delivery_rec.ACCEPTANCE_FLAG <> FND_API.G_MISS_CHAR
7840: OR p_delivery_rec.ACCEPTANCE_FLAG IS NULL THEN
7841: x_delivery_rec.ACCEPTANCE_FLAG :=
7842: p_delivery_rec.ACCEPTANCE_FLAG;
7843: END IF;
7840: OR p_delivery_rec.ACCEPTANCE_FLAG IS NULL THEN
7841: x_delivery_rec.ACCEPTANCE_FLAG :=
7842: p_delivery_rec.ACCEPTANCE_FLAG;
7843: END IF;
7844: IF p_delivery_rec.ACCEPTED_BY <> FND_API.G_MISS_CHAR
7845: OR p_delivery_rec.ACCEPTED_BY IS NULL THEN
7846: x_delivery_rec.ACCEPTED_BY :=
7847: p_delivery_rec.ACCEPTED_BY;
7848: END IF;
7845: OR p_delivery_rec.ACCEPTED_BY IS NULL THEN
7846: x_delivery_rec.ACCEPTED_BY :=
7847: p_delivery_rec.ACCEPTED_BY;
7848: END IF;
7849: IF p_delivery_rec.ACCEPTED_DATE <> FND_API.G_MISS_DATE
7850: OR p_delivery_rec.ACCEPTED_DATE IS NULL THEN
7851: x_delivery_rec.ACCEPTED_DATE :=
7852: p_delivery_rec.ACCEPTED_DATE;
7853: END IF;
7850: OR p_delivery_rec.ACCEPTED_DATE IS NULL THEN
7851: x_delivery_rec.ACCEPTED_DATE :=
7852: p_delivery_rec.ACCEPTED_DATE;
7853: END IF;
7854: IF p_delivery_rec.ACKNOWLEDGED_BY <> FND_API.G_MISS_CHAR
7855: OR p_delivery_rec.ACKNOWLEDGED_BY IS NULL THEN
7856: x_delivery_rec.ACKNOWLEDGED_BY :=
7857: p_delivery_rec.ACKNOWLEDGED_BY;
7858: END IF;
7855: OR p_delivery_rec.ACKNOWLEDGED_BY IS NULL THEN
7856: x_delivery_rec.ACKNOWLEDGED_BY :=
7857: p_delivery_rec.ACKNOWLEDGED_BY;
7858: END IF;
7859: IF p_delivery_rec.CONFIRMED_BY <> FND_API.G_MISS_CHAR
7860: OR p_delivery_rec.CONFIRMED_BY IS NULL THEN
7861: x_delivery_rec.CONFIRMED_BY :=
7862: p_delivery_rec.CONFIRMED_BY;
7863: END IF;
7860: OR p_delivery_rec.CONFIRMED_BY IS NULL THEN
7861: x_delivery_rec.CONFIRMED_BY :=
7862: p_delivery_rec.CONFIRMED_BY;
7863: END IF;
7864: IF p_delivery_rec.CONFIRM_DATE <> FND_API.G_MISS_DATE
7865: OR p_delivery_rec.CONFIRM_DATE IS NULL THEN
7866: x_delivery_rec.CONFIRM_DATE :=
7867: p_delivery_rec.CONFIRM_DATE;
7868: END IF;
7865: OR p_delivery_rec.CONFIRM_DATE IS NULL THEN
7866: x_delivery_rec.CONFIRM_DATE :=
7867: p_delivery_rec.CONFIRM_DATE;
7868: END IF;
7869: IF p_delivery_rec.PORT_OF_DISCHARGE <> FND_API.G_MISS_CHAR
7870: OR p_delivery_rec.PORT_OF_DISCHARGE IS NULL THEN
7871: x_delivery_rec.PORT_OF_DISCHARGE :=
7872: p_delivery_rec.PORT_OF_DISCHARGE;
7873: END IF;
7870: OR p_delivery_rec.PORT_OF_DISCHARGE IS NULL THEN
7871: x_delivery_rec.PORT_OF_DISCHARGE :=
7872: p_delivery_rec.PORT_OF_DISCHARGE;
7873: END IF;
7874: IF p_delivery_rec.ROUTING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
7875: OR p_delivery_rec.ROUTING_INSTRUCTIONS IS NULL THEN
7876: x_delivery_rec.ROUTING_INSTRUCTIONS :=
7877: p_delivery_rec.ROUTING_INSTRUCTIONS;
7878: END IF;
7875: OR p_delivery_rec.ROUTING_INSTRUCTIONS IS NULL THEN
7876: x_delivery_rec.ROUTING_INSTRUCTIONS :=
7877: p_delivery_rec.ROUTING_INSTRUCTIONS;
7878: END IF;
7879: IF p_delivery_rec.ASSIGNED_TO_FTE_TRIPS <> FND_API.G_MISS_CHAR
7880: OR p_delivery_rec.ASSIGNED_TO_FTE_TRIPS IS NULL THEN
7881: x_delivery_rec.ASSIGNED_TO_FTE_TRIPS :=
7882: p_delivery_rec.ASSIGNED_TO_FTE_TRIPS;
7883: END IF;
7883: END IF;
7884:
7885: --tkt
7886: IF p_in_rec.caller='WSH_TP_RELEASE' THEN
7887: IF p_delivery_rec.tp_plan_name <> FND_API.G_MISS_CHAR
7888: OR p_delivery_rec.tp_plan_name IS NULL THEN
7889: x_delivery_rec.tp_plan_name :=
7890: p_delivery_rec.tp_plan_name;
7891: END IF;
7888: OR p_delivery_rec.tp_plan_name IS NULL THEN
7889: x_delivery_rec.tp_plan_name :=
7890: p_delivery_rec.tp_plan_name;
7891: END IF;
7892: IF p_delivery_rec.tp_delivery_number <> FND_API.G_MISS_NUM
7893: OR p_delivery_rec.tp_delivery_number IS NULL THEN
7894: x_delivery_rec.tp_delivery_number :=
7895: p_delivery_rec.tp_delivery_number;
7896: END IF;
7896: END IF;
7897: END IF;
7898:
7899: /*3667348*/
7900: IF p_delivery_rec.REASON_OF_TRANSPORT <> FND_API.G_MISS_CHAR
7901: OR p_delivery_rec.REASON_OF_TRANSPORT IS NULL THEN
7902: x_delivery_rec.REASON_OF_TRANSPORT := p_delivery_rec.REASON_OF_TRANSPORT;
7903: END IF;
7904: IF p_delivery_rec.DESCRIPTION <> FND_API.G_MISS_CHAR
7900: IF p_delivery_rec.REASON_OF_TRANSPORT <> FND_API.G_MISS_CHAR
7901: OR p_delivery_rec.REASON_OF_TRANSPORT IS NULL THEN
7902: x_delivery_rec.REASON_OF_TRANSPORT := p_delivery_rec.REASON_OF_TRANSPORT;
7903: END IF;
7904: IF p_delivery_rec.DESCRIPTION <> FND_API.G_MISS_CHAR
7905: OR p_delivery_rec.DESCRIPTION IS NULL THEN
7906: x_delivery_rec.DESCRIPTION := p_delivery_rec.DESCRIPTION;
7907: END IF;
7908:
7945: ELSIF p_disabled_list(i) = '+INITIAL_PICKUP_LOCATION_CODE' THEN
7946: IF p_in_rec.INITIAL_PICKUP_LOCATION_ID IS NOT NULL THEN
7947: x_out_rec.INITIAL_PICKUP_LOCATION_ID :=
7948: p_in_rec.INITIAL_PICKUP_LOCATION_ID ;
7949: x_out_rec.INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
7950: END IF;
7951: ELSIF p_disabled_list(i) = '+ULTIMATE_DROPOFF_LOCATION_CODE' THEN
7952: IF p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID IS NOT NULL THEN
7953: x_out_rec.ULTIMATE_DROPOFF_LOCATION_ID :=
7951: ELSIF p_disabled_list(i) = '+ULTIMATE_DROPOFF_LOCATION_CODE' THEN
7952: IF p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID IS NOT NULL THEN
7953: x_out_rec.ULTIMATE_DROPOFF_LOCATION_ID :=
7954: p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID ;
7955: x_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE := FND_API.G_MISS_CHAR;
7956: END IF;
7957: ELSIF p_disabled_list(i) = '+CUSTOMER_NAME' THEN
7958: IF p_in_rec.CUSTOMER_ID IS NOT NULL THEN
7959: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
7956: END IF;
7957: ELSIF p_disabled_list(i) = '+CUSTOMER_NAME' THEN
7958: IF p_in_rec.CUSTOMER_ID IS NOT NULL THEN
7959: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
7960: x_out_rec.CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
7961: END IF;
7962: -- LSP PROJECT
7963: ELSIF p_disabled_list(i) = '+CLIENT_NAME' THEN
7964: IF p_in_rec.client_ID IS NOT NULL THEN
7962: -- LSP PROJECT
7963: ELSIF p_disabled_list(i) = '+CLIENT_NAME' THEN
7964: IF p_in_rec.client_ID IS NOT NULL THEN
7965: x_out_rec.client_ID := p_in_rec.client_ID ;
7966: x_out_rec.client_code := FND_API.G_MISS_CHAR;
7967: END IF;
7968: -- LSP PROJECT
7969: ELSIF p_disabled_list(i) = '+ORGANIZATION_CODE' THEN
7970: IF p_in_rec.ORGANIZATION_ID IS NOT NULL THEN
7968: -- LSP PROJECT
7969: ELSIF p_disabled_list(i) = '+ORGANIZATION_CODE' THEN
7970: IF p_in_rec.ORGANIZATION_ID IS NOT NULL THEN
7971: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
7972: x_out_rec.organization_code := FND_API.G_MISS_CHAR;
7973: END IF;
7974: ELSIF p_disabled_list(i) = '+LOADING_ORDER_FLAG' THEN
7975: IF p_in_rec.LOADING_ORDER_FLAG IS NOT NULL THEN
7976: x_out_rec.LOADING_ORDER_FLAG := p_in_rec.LOADING_ORDER_FLAG ;
7973: END IF;
7974: ELSIF p_disabled_list(i) = '+LOADING_ORDER_FLAG' THEN
7975: IF p_in_rec.LOADING_ORDER_FLAG IS NOT NULL THEN
7976: x_out_rec.LOADING_ORDER_FLAG := p_in_rec.LOADING_ORDER_FLAG ;
7977: x_out_rec.LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
7978: END IF;
7979: ELSIF p_disabled_list(i) = '+ACCEPTANCE_FLAG' THEN
7980: IF p_in_rec.ACCEPTANCE_FLAG IS NOT NULL THEN
7981: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
7994: END IF;
7995: ELSIF p_disabled_list(i) = '+CURRENCY_CODE' THEN
7996: IF p_in_rec.CURRENCY_CODE IS NOT NULL THEN
7997: x_out_rec.CURRENCY_CODE := p_in_rec.CURRENCY_CODE ;
7998: x_out_rec.currency_name := FND_API.G_MISS_CHAR;
7999: END IF;
8000: ELSIF p_disabled_list(i) = '+INITIAL_PICKUP_DATE' THEN
8001: IF p_in_rec.INITIAL_PICKUP_DATE IS NOT NULL THEN
8002: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8011: END IF;
8012: ELSIF p_disabled_list(i) = '+SHIP_METHOD_NAME' THEN
8013: IF p_in_rec.SHIP_METHOD_CODE IS NOT NULL THEN
8014: x_out_rec.SHIP_METHOD_CODE := p_in_rec.SHIP_METHOD_CODE ;
8015: x_out_rec.ship_method_name := FND_API.G_MISS_CHAR;
8016: END IF;
8017: ELSIF p_disabled_list(i) = '+FREIGHT_CODE' THEN
8018: NULL ;
8019: -- J-IB-NPARIKH-{ --I-bugfix
8018: NULL ;
8019: -- J-IB-NPARIKH-{ --I-bugfix
8020: IF p_in_rec.CARRIER_CODE IS NOT NULL THEN
8021: x_out_rec.carrier_id := p_in_rec.carrier_id ;
8022: x_out_rec.CARRIER_CODE := FND_API.G_MISS_CHAR;
8023: END IF;
8024: -- J-IB-NPARIKH-}
8025:
8026: ELSIF p_disabled_list(i) = '+SERVICE_LEVEL_NAME' THEN
8038: ELSIF p_disabled_list(i) = '+INTMED_SHIP_TO_LOCATION_CODE' THEN
8039: IF p_in_rec.INTMED_SHIP_TO_LOCATION_ID IS NOT NULL THEN
8040: x_out_rec.INTMED_SHIP_TO_LOCATION_ID :=
8041: p_in_rec.INTMED_SHIP_TO_LOCATION_ID ;
8042: x_out_rec.INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8043: END IF;
8044: ELSIF p_disabled_list(i) = '+POOLED_SHIP_TO_LOCATION_CODE' THEN
8045: IF p_in_rec.POOLED_SHIP_TO_LOCATION_ID IS NOT NULL THEN
8046: x_out_rec.POOLED_SHIP_TO_LOCATION_ID :=
8044: ELSIF p_disabled_list(i) = '+POOLED_SHIP_TO_LOCATION_CODE' THEN
8045: IF p_in_rec.POOLED_SHIP_TO_LOCATION_ID IS NOT NULL THEN
8046: x_out_rec.POOLED_SHIP_TO_LOCATION_ID :=
8047: p_in_rec.POOLED_SHIP_TO_LOCATION_ID ;
8048: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8049: END IF;
8050: ELSIF p_disabled_list(i) = '+WAYBILL' THEN
8051: IF p_in_rec.WAYBILL IS NOT NULL THEN
8052: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
8053: END IF;
8054: ELSIF p_disabled_list(i) = '+FREIGHT_TERMS_NAME' THEN
8055: IF p_in_rec.FREIGHT_TERMS_CODE IS NOT NULL THEN
8056: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE ;
8057: x_out_rec.FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
8058: END IF;
8059: ELSIF p_disabled_list(i) = '+GROSS_WEIGHT' THEN
8060: IF p_in_rec.GROSS_WEIGHT IS NOT NULL THEN
8061: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
8074: END IF;
8075: ELSIF p_disabled_list(i) = '+VOLUME_UOM_CODE' THEN
8076: IF p_in_rec.VOLUME_UOM_CODE IS NOT NULL THEN
8077: x_out_rec.VOLUME_UOM_CODE := p_in_rec.VOLUME_UOM_CODE ;
8078: x_out_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
8079: END IF;
8080: ELSIF p_disabled_list(i) = '+FOB_NAME' THEN
8081: IF p_in_rec.FOB_CODE IS NOT NULL THEN
8082: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
8079: END IF;
8080: ELSIF p_disabled_list(i) = '+FOB_NAME' THEN
8081: IF p_in_rec.FOB_CODE IS NOT NULL THEN
8082: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
8083: x_out_rec.FOB_NAME := FND_API.G_MISS_CHAR;
8084: END IF;
8085: ELSIF p_disabled_list(i) = '+FOB_LOCATION_CODE' THEN
8086: IF p_in_rec.FOB_LOCATION_ID IS NOT NULL THEN
8087: x_out_rec.FOB_LOCATION_ID := p_in_rec.FOB_LOCATION_ID ;
8084: END IF;
8085: ELSIF p_disabled_list(i) = '+FOB_LOCATION_CODE' THEN
8086: IF p_in_rec.FOB_LOCATION_ID IS NOT NULL THEN
8087: x_out_rec.FOB_LOCATION_ID := p_in_rec.FOB_LOCATION_ID ;
8088: x_out_rec.FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
8089: END IF;
8090: ELSIF p_disabled_list(i) = '+AUTO_SC_EXCLUDE_FLAG' THEN
8091: IF p_in_rec.AUTO_SC_EXCLUDE_FLAG IS NOT NULL THEN
8092: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
8264: x_out_rec.CONFIRMED_BY := p_in_rec.CONFIRMED_BY ;
8265: ELSIF p_disabled_list(i) = 'INITIAL_PICKUP_LOCATION_CODE' THEN
8266: x_out_rec.INITIAL_PICKUP_LOCATION_ID :=
8267: p_in_rec.INITIAL_PICKUP_LOCATION_ID ;
8268: x_out_rec.INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
8269: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_LOCATION_CODE' THEN
8270: x_out_rec.ULTIMATE_DROPOFF_LOCATION_ID :=
8271: p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID ;
8272: x_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE := FND_API.G_MISS_CHAR;
8268: x_out_rec.INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
8269: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_LOCATION_CODE' THEN
8270: x_out_rec.ULTIMATE_DROPOFF_LOCATION_ID :=
8271: p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID ;
8272: x_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE := FND_API.G_MISS_CHAR;
8273: ELSIF p_disabled_list(i) = 'CUSTOMER_NAME' THEN
8274: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
8275: x_out_rec.customer_number := FND_API.G_MISS_CHAR;
8276: -- LSP PROJECT
8271: p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID ;
8272: x_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE := FND_API.G_MISS_CHAR;
8273: ELSIF p_disabled_list(i) = 'CUSTOMER_NAME' THEN
8274: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
8275: x_out_rec.customer_number := FND_API.G_MISS_CHAR;
8276: -- LSP PROJECT
8277: ELSIF p_disabled_list(i) = 'CLIENT_NAME' THEN
8278: x_out_rec.CLIENT_ID := p_in_rec.CLIENT_ID ;
8279: x_out_rec.CLIENT_CODE := FND_API.G_MISS_CHAR;
8275: x_out_rec.customer_number := FND_API.G_MISS_CHAR;
8276: -- LSP PROJECT
8277: ELSIF p_disabled_list(i) = 'CLIENT_NAME' THEN
8278: x_out_rec.CLIENT_ID := p_in_rec.CLIENT_ID ;
8279: x_out_rec.CLIENT_CODE := FND_API.G_MISS_CHAR;
8280: -- LSP PROJECT
8281: ELSIF p_disabled_list(i) = 'ORGANIZATION_CODE' THEN
8282: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
8283: x_out_rec.ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
8279: x_out_rec.CLIENT_CODE := FND_API.G_MISS_CHAR;
8280: -- LSP PROJECT
8281: ELSIF p_disabled_list(i) = 'ORGANIZATION_CODE' THEN
8282: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
8283: x_out_rec.ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
8284: ELSIF p_disabled_list(i) = 'LOADING_ORDER_FLAG' THEN
8285: x_out_rec.LOADING_ORDER_FLAG := p_in_rec.LOADING_ORDER_FLAG ;
8286: x_out_rec.LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
8287: ELSIF p_disabled_list(i) = 'ACCEPTANCE_FLAG' THEN
8282: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
8283: x_out_rec.ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
8284: ELSIF p_disabled_list(i) = 'LOADING_ORDER_FLAG' THEN
8285: x_out_rec.LOADING_ORDER_FLAG := p_in_rec.LOADING_ORDER_FLAG ;
8286: x_out_rec.LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
8287: ELSIF p_disabled_list(i) = 'ACCEPTANCE_FLAG' THEN
8288: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
8289: ELSIF p_disabled_list(i) = 'ACCEPTED_BY' THEN
8290: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
8293: ELSIF p_disabled_list(i) = 'ACKNOWLEDGED_BY' THEN
8294: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
8295: ELSIF p_disabled_list(i) = 'CURRENCY_CODE' THEN
8296: x_out_rec.CURRENCY_CODE := p_in_rec.CURRENCY_CODE ;
8297: x_out_rec.currency_name := FND_API.G_MISS_CHAR;
8298: ELSIF p_disabled_list(i) = 'INITIAL_PICKUP_DATE' THEN
8299: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8300: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_DATE' THEN
8301: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
8302: ELSIF p_disabled_list(i) = 'LOADING_SEQUENCE' THEN
8303: x_out_rec.LOADING_SEQUENCE := p_in_rec.LOADING_SEQUENCE ;
8304: ELSIF p_disabled_list(i) = 'SHIP_METHOD_NAME' THEN
8305: x_out_rec.SHIP_METHOD_CODE := p_in_rec.SHIP_METHOD_CODE ;
8306: x_out_rec.SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
8307: ELSIF p_disabled_list(i) = 'FREIGHT_CODE' THEN
8308: IF (nvl(p_caller, '!!!!') <> 'WSH_INBOUND') THEN
8309: --x_out_rec.carrier_code := p_in_rec.carrier_code ; -- J-IB-NPARIKH--I-bug-fix
8310: x_out_rec.carrier_id := p_in_rec.carrier_id ; -- J-IB-NPARIKH--I-bug-fix
8307: ELSIF p_disabled_list(i) = 'FREIGHT_CODE' THEN
8308: IF (nvl(p_caller, '!!!!') <> 'WSH_INBOUND') THEN
8309: --x_out_rec.carrier_code := p_in_rec.carrier_code ; -- J-IB-NPARIKH--I-bug-fix
8310: x_out_rec.carrier_id := p_in_rec.carrier_id ; -- J-IB-NPARIKH--I-bug-fix
8311: x_out_rec.CARRIER_CODE := FND_API.G_MISS_CHAR; -- J-IB-NPARIKH--I-bug-fix
8312: END IF;
8313: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL_NAME' THEN
8314: IF (nvl(p_caller, '!!!!') <> 'WSH_INBOUND') THEN
8315: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
8322: x_out_rec.NAME := p_in_rec.NAME ;
8323: ELSIF p_disabled_list(i) = 'INTMED_SHIP_TO_LOCATION_CODE' THEN
8324: x_out_rec.INTMED_SHIP_TO_LOCATION_ID :=
8325: p_in_rec.INTMED_SHIP_TO_LOCATION_ID ;
8326: x_out_rec.INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8327: ELSIF p_disabled_list(i) = 'POOLED_SHIP_TO_LOCATION_CODE' THEN
8328: x_out_rec.POOLED_SHIP_TO_LOCATION_ID :=
8329: p_in_rec.POOLED_SHIP_TO_LOCATION_ID ;
8330: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8326: x_out_rec.INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8327: ELSIF p_disabled_list(i) = 'POOLED_SHIP_TO_LOCATION_CODE' THEN
8328: x_out_rec.POOLED_SHIP_TO_LOCATION_ID :=
8329: p_in_rec.POOLED_SHIP_TO_LOCATION_ID ;
8330: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8331: ELSIF p_disabled_list(i) = 'WAYBILL' THEN
8332: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
8333: ELSIF p_disabled_list(i) = 'FREIGHT_TERMS_NAME' THEN
8334: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE ;
8331: ELSIF p_disabled_list(i) = 'WAYBILL' THEN
8332: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
8333: ELSIF p_disabled_list(i) = 'FREIGHT_TERMS_NAME' THEN
8334: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE ;
8335: x_out_rec.FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
8336: ELSIF p_disabled_list(i) = 'GROSS_WEIGHT' THEN
8337: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
8338: ELSIF p_disabled_list(i) = 'NET_WEIGHT' THEN
8339: x_out_rec.NET_WEIGHT := p_in_rec.NET_WEIGHT ;
8342: x_out_rec.PRORATE_WT_FLAG := p_in_rec.PRORATE_WT_FLAG ;
8343: --
8344: ELSIF p_disabled_list(i) = 'WEIGHT_UOM_CODE' THEN
8345: x_out_rec.WEIGHT_UOM_CODE := p_in_rec.WEIGHT_UOM_CODE ;
8346: x_out_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
8347: ELSIF p_disabled_list(i) = 'VOLUME' THEN
8348: x_out_rec.VOLUME := p_in_rec.VOLUME ;
8349: ELSIF p_disabled_list(i) = 'VOLUME_UOM_CODE' THEN
8350: x_out_rec.VOLUME_UOM_CODE := p_in_rec.VOLUME_UOM_CODE ;
8347: ELSIF p_disabled_list(i) = 'VOLUME' THEN
8348: x_out_rec.VOLUME := p_in_rec.VOLUME ;
8349: ELSIF p_disabled_list(i) = 'VOLUME_UOM_CODE' THEN
8350: x_out_rec.VOLUME_UOM_CODE := p_in_rec.VOLUME_UOM_CODE ;
8351: x_out_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
8352: ELSIF p_disabled_list(i) = 'FOB_NAME' THEN
8353: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
8354: x_out_rec.FOB_NAME := FND_API.G_MISS_CHAR;
8355: ELSIF p_disabled_list(i) = 'FOB_LOCATION_CODE' THEN
8350: x_out_rec.VOLUME_UOM_CODE := p_in_rec.VOLUME_UOM_CODE ;
8351: x_out_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
8352: ELSIF p_disabled_list(i) = 'FOB_NAME' THEN
8353: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
8354: x_out_rec.FOB_NAME := FND_API.G_MISS_CHAR;
8355: ELSIF p_disabled_list(i) = 'FOB_LOCATION_CODE' THEN
8356: x_out_rec.FOB_LOCATION_ID := p_in_rec.FOB_LOCATION_ID ;
8357: x_out_rec.FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
8358: ELSIF p_disabled_list(i) = 'NUMBER_OF_LPN' THEN
8353: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
8354: x_out_rec.FOB_NAME := FND_API.G_MISS_CHAR;
8355: ELSIF p_disabled_list(i) = 'FOB_LOCATION_CODE' THEN
8356: x_out_rec.FOB_LOCATION_ID := p_in_rec.FOB_LOCATION_ID ;
8357: x_out_rec.FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
8358: ELSIF p_disabled_list(i) = 'NUMBER_OF_LPN' THEN
8359: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
8360: ELSIF p_disabled_list(i) = 'AUTO_SC_EXCLUDE_FLAG' THEN
8361: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
8443: BEGIN
8444:
8445: IF p_mode = '+' THEN
8446: IF x_internal IS NULL THEN
8447: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
8448: x_internal := p_internal ;
8449: IF p_internal IS NULL THEN
8450: x_external := NULL;
8451: ELSE
8450: x_external := NULL;
8451: ELSE
8452: x_external := p_external;
8453: END IF;
8454: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
8455: x_external := p_external;
8456: IF p_external IS NULL THEN
8457: x_internal := NULL;
8458: ELSE
8460: END IF;
8461: END IF;
8462: END IF;
8463: ELSE --p_mode <> +
8464: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
8465: x_internal := p_internal ;
8466: IF p_internal IS NULL THEN
8467: x_external := NULL;
8468: ELSE
8467: x_external := NULL;
8468: ELSE
8469: x_external := p_external;
8470: END IF;
8471: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
8472: x_external := p_external;
8473: IF p_external IS NULL THEN
8474: x_internal := NULL;
8475: ELSE
8497: BEGIN
8498:
8499: IF p_mode = '+' THEN
8500: IF x_internal IS NULL THEN
8501: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
8502: x_internal := p_internal ;
8503: IF p_internal IS NULL THEN
8504: x_external := NULL;
8505: ELSE
8504: x_external := NULL;
8505: ELSE
8506: x_external := p_external;
8507: END IF;
8508: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
8509: x_external := p_external;
8510: IF p_external IS NULL THEN
8511: x_internal := NULL;
8512: ELSE
8514: END IF;
8515: END IF;
8516: END IF;
8517: ELSE --p_mode <> +
8518: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
8519: x_internal := p_internal ;
8520: IF p_internal IS NULL THEN
8521: x_external := NULL;
8522: ELSE
8521: x_external := NULL;
8522: ELSE
8523: x_external := p_external;
8524: END IF;
8525: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
8526: x_external := p_external;
8527: IF p_external IS NULL THEN
8528: x_internal := NULL;
8529: ELSE
8554: LOOP
8555: l_prefix := SUBSTR(p_disabled_list(i),1,1);
8556: IF l_prefix = '+' THEN
8557: IF p_disabled_list(i) = '+ADDITIONAL_SHIPMENT_INFO' THEN
8558: IF p_in_rec.ADDITIONAL_SHIPMENT_INFO <> FND_API.G_MISS_CHAR
8559: OR p_in_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
8560: IF x_out_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
8561: x_out_rec.ADDITIONAL_SHIPMENT_INFO := p_in_rec.ADDITIONAL_SHIPMENT_INFO ;
8562: END IF;
8561: x_out_rec.ADDITIONAL_SHIPMENT_INFO := p_in_rec.ADDITIONAL_SHIPMENT_INFO ;
8562: END IF;
8563: END IF;
8564: ELSIF p_disabled_list(i) = '+DOCK_CODE' THEN
8565: IF p_in_rec.DOCK_CODE <> FND_API.G_MISS_CHAR
8566: OR p_in_rec.DOCK_CODE IS NULL THEN
8567: IF x_out_rec.DOCK_CODE IS NULL THEN
8568: x_out_rec.DOCK_CODE := p_in_rec.DOCK_CODE ;
8569: END IF;
8612: x_out_rec.loading_order_flag,
8613: x_out_rec.loading_order_desc);
8614:
8615: ELSIF p_disabled_list(i) = '+ACCEPTANCE_FLAG' THEN
8616: IF p_in_rec.ACCEPTANCE_FLAG <> FND_API.G_MISS_CHAR
8617: OR p_in_rec.ACCEPTANCE_FLAG IS NULL THEN
8618: IF x_out_rec.ACCEPTANCE_FLAG IS NULL THEN
8619: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
8620: END IF;
8619: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
8620: END IF;
8621: END IF;
8622: ELSIF p_disabled_list(i) = '+ACCEPTED_BY' THEN
8623: IF p_in_rec.ACCEPTED_BY <> FND_API.G_MISS_CHAR
8624: OR p_in_rec.ACCEPTED_BY IS NULL THEN
8625: IF x_out_rec.ACCEPTED_BY IS NULL THEN
8626: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
8627: END IF;
8626: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
8627: END IF;
8628: END IF;
8629: ELSIF p_disabled_list(i) = '+ACCEPTED_DATE' THEN
8630: IF p_in_rec.ACCEPTED_DATE <> FND_API.G_MISS_DATE
8631: OR p_in_rec.ACCEPTED_DATE IS NULL THEN
8632: IF x_out_rec.ACCEPTED_DATE IS NULL THEN
8633: x_out_rec.ACCEPTED_DATE := p_in_rec.ACCEPTED_DATE ;
8634: END IF;
8633: x_out_rec.ACCEPTED_DATE := p_in_rec.ACCEPTED_DATE ;
8634: END IF;
8635: END IF;
8636: ELSIF p_disabled_list(i) = '+ACKNOWLEDGED_BY' THEN
8637: IF p_in_rec.ACKNOWLEDGED_BY <> FND_API.G_MISS_CHAR
8638: OR p_in_rec.ACKNOWLEDGED_BY IS NULL THEN
8639: IF x_out_rec.ACKNOWLEDGED_BY IS NULL THEN
8640: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
8641: END IF;
8640: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
8641: END IF;
8642: END IF;
8643: ELSIF p_disabled_list(i) = '+CONFIRMED_BY' THEN
8644: IF p_in_rec.CONFIRMED_BY <> FND_API.G_MISS_CHAR
8645: OR p_in_rec.CONFIRMED_BY IS NULL THEN
8646: IF x_out_rec.CONFIRMED_BY IS NULL THEN
8647: x_out_rec.CONFIRMED_BY := p_in_rec.CONFIRMED_BY ;
8648: END IF;
8654: x_out_rec.currency_code,
8655: x_out_rec.currency_name);
8656:
8657: ELSIF p_disabled_list(i) = '+INITIAL_PICKUP_DATE' THEN
8658: IF p_in_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE
8659: OR p_in_rec.INITIAL_PICKUP_DATE IS NULL THEN
8660: IF x_out_rec.INITIAL_PICKUP_DATE IS NULL THEN
8661: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8662: END IF;
8661: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8662: END IF;
8663: END IF;
8664: ELSIF p_disabled_list(i) = '+ULTIMATE_DROPOFF_DATE' THEN
8665: IF p_in_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE
8666: OR p_in_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
8667: IF x_out_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
8668: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
8669: END IF;
8668: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
8669: END IF;
8670: END IF;
8671: ELSIF p_disabled_list(i) = '+LOADING_SEQUENCE' THEN
8672: IF p_in_rec.LOADING_SEQUENCE <> FND_API.G_MISS_NUM
8673: OR p_in_rec.LOADING_SEQUENCE IS NULL THEN
8674: IF x_out_rec.LOADING_SEQUENCE IS NULL THEN
8675: x_out_rec.LOADING_SEQUENCE := p_in_rec.LOADING_SEQUENCE ;
8676: END IF;
8691: x_out_rec.carrier_code);
8692: -- J-IB-NPARIKH-}
8693:
8694: ELSIF p_disabled_list(i) = '+SERVICE_LEVEL_NAME' THEN
8695: IF p_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
8696: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
8697: IF x_out_rec.SERVICE_LEVEL IS NULL THEN
8698: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
8699: END IF;
8698: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
8699: END IF;
8700: END IF;
8701: ELSIF p_disabled_list(i) = '+MODE_OF_TRANSPORT_NAME' THEN
8702: IF p_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
8703: OR p_in_rec.MODE_OF_TRANSPORT IS NULL THEN
8704: IF x_out_rec.MODE_OF_TRANSPORT IS NULL THEN
8705: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
8706: END IF;
8705: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
8706: END IF;
8707: END IF;
8708: ELSIF p_disabled_list(i) = '+NAME' THEN
8709: IF p_in_rec.NAME <> FND_API.G_MISS_CHAR
8710: OR p_in_rec.NAME IS NULL THEN
8711: IF x_out_rec.NAME IS NULL THEN
8712: x_out_rec.NAME := p_in_rec.NAME ;
8713: END IF;
8726: x_out_rec.POOLED_SHIP_TO_LOCATION_ID,
8727: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE);
8728:
8729: ELSIF p_disabled_list(i) = '+WAYBILL' THEN
8730: IF p_in_rec.WAYBILL <> FND_API.G_MISS_CHAR
8731: OR p_in_rec.WAYBILL IS NULL THEN
8732: IF x_out_rec.WAYBILL IS NULL THEN
8733: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
8734: END IF;
8740: x_out_rec.FREIGHT_TERMS_CODE,
8741: x_out_rec.FREIGHT_TERMS_NAME);
8742:
8743: ELSIF p_disabled_list(i) = '+GROSS_WEIGHT' THEN
8744: IF p_in_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
8745: OR p_in_rec.GROSS_WEIGHT IS NULL THEN
8746: IF x_out_rec.GROSS_WEIGHT IS NULL THEN
8747: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
8748: END IF;
8747: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
8748: END IF;
8749: END IF;
8750: ELSIF p_disabled_list(i) = '+NET_WEIGHT' THEN
8751: IF p_in_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
8752: OR p_in_rec.NET_WEIGHT IS NULL THEN
8753: IF x_out_rec.NET_WEIGHT IS NULL THEN
8754: x_out_rec.NET_WEIGHT := p_in_rec.NET_WEIGHT ;
8755: END IF;
8761: x_out_rec.WEIGHT_UOM_CODE,
8762: x_out_rec.WEIGHT_UOM_DESC);
8763:
8764: ELSIF p_disabled_list(i) = '+VOLUME' THEN
8765: IF p_in_rec.VOLUME <> FND_API.G_MISS_NUM
8766: OR p_in_rec.VOLUME IS NULL THEN
8767: IF x_out_rec.VOLUME IS NULL THEN
8768: x_out_rec.VOLUME := p_in_rec.VOLUME ;
8769: END IF;
8789: x_out_rec.FOB_LOCATION_ID,
8790: x_out_rec.FOB_LOCATION_CODE);
8791:
8792: ELSIF p_disabled_list(i) = '+NUMBER_OF_LPN' THEN
8793: IF p_in_rec.NUMBER_OF_LPN <> FND_API.G_MISS_NUM
8794: OR p_in_rec.NUMBER_OF_LPN IS NULL THEN
8795: IF x_out_rec.NUMBER_OF_LPN IS NULL THEN
8796: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
8797: END IF;
8796: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
8797: END IF;
8798: END IF;
8799: ELSIF p_disabled_list(i) = '+AUTO_SC_EXCLUDE_FLAG' THEN
8800: IF p_in_rec.AUTO_SC_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
8801: OR p_in_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
8802: IF x_out_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
8803: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
8804: END IF;
8803: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
8804: END IF;
8805: END IF;
8806: ELSIF p_disabled_list(i) = '+AUTO_AP_EXCLUDE_FLAG' THEN
8807: IF p_in_rec.AUTO_AP_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
8808: OR p_in_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
8809: IF x_out_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
8810: x_out_rec.AUTO_AP_EXCLUDE_FLAG := p_in_rec.AUTO_AP_EXCLUDE_FLAG ;
8811: END IF;
8810: x_out_rec.AUTO_AP_EXCLUDE_FLAG := p_in_rec.AUTO_AP_EXCLUDE_FLAG ;
8811: END IF;
8812: END IF;
8813: ELSIF p_disabled_list(i) = '+DESC_FLEX' THEN
8814: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
8815: OR p_in_rec.attribute1 IS NULL THEN
8816: IF x_out_rec.attribute1 IS NULL THEN
8817: x_out_rec.attribute1 := p_in_rec.attribute1 ;
8818: END IF;
8816: IF x_out_rec.attribute1 IS NULL THEN
8817: x_out_rec.attribute1 := p_in_rec.attribute1 ;
8818: END IF;
8819: END IF;
8820: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
8821: OR p_in_rec.attribute2 IS NULL THEN
8822: IF x_out_rec.attribute2 IS NULL THEN
8823: x_out_rec.attribute2 := p_in_rec.attribute2 ;
8824: END IF;
8822: IF x_out_rec.attribute2 IS NULL THEN
8823: x_out_rec.attribute2 := p_in_rec.attribute2 ;
8824: END IF;
8825: END IF;
8826: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
8827: OR p_in_rec.attribute3 IS NULL THEN
8828: IF x_out_rec.attribute3 IS NULL THEN
8829: x_out_rec.attribute3 := p_in_rec.attribute3 ;
8830: END IF;
8828: IF x_out_rec.attribute3 IS NULL THEN
8829: x_out_rec.attribute3 := p_in_rec.attribute3 ;
8830: END IF;
8831: END IF;
8832: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
8833: OR p_in_rec.attribute4 IS NULL THEN
8834: IF x_out_rec.attribute4 IS NULL THEN
8835: x_out_rec.attribute4 := p_in_rec.attribute4 ;
8836: END IF;
8834: IF x_out_rec.attribute4 IS NULL THEN
8835: x_out_rec.attribute4 := p_in_rec.attribute4 ;
8836: END IF;
8837: END IF;
8838: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
8839: OR p_in_rec.attribute5 IS NULL THEN
8840: IF x_out_rec.attribute5 IS NULL THEN
8841: x_out_rec.attribute5 := p_in_rec.attribute5 ;
8842: END IF;
8840: IF x_out_rec.attribute5 IS NULL THEN
8841: x_out_rec.attribute5 := p_in_rec.attribute5 ;
8842: END IF;
8843: END IF;
8844: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
8845: OR p_in_rec.attribute6 IS NULL THEN
8846: IF x_out_rec.attribute6 IS NULL THEN
8847: x_out_rec.attribute6 := p_in_rec.attribute6 ;
8848: END IF;
8846: IF x_out_rec.attribute6 IS NULL THEN
8847: x_out_rec.attribute6 := p_in_rec.attribute6 ;
8848: END IF;
8849: END IF;
8850: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
8851: OR p_in_rec.attribute7 IS NULL THEN
8852: IF x_out_rec.attribute7 IS NULL THEN
8853: x_out_rec.attribute7 := p_in_rec.attribute7 ;
8854: END IF;
8852: IF x_out_rec.attribute7 IS NULL THEN
8853: x_out_rec.attribute7 := p_in_rec.attribute7 ;
8854: END IF;
8855: END IF;
8856: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
8857: OR p_in_rec.attribute8 IS NULL THEN
8858: IF x_out_rec.attribute8 IS NULL THEN
8859: x_out_rec.attribute8 := p_in_rec.attribute8 ;
8860: END IF;
8858: IF x_out_rec.attribute8 IS NULL THEN
8859: x_out_rec.attribute8 := p_in_rec.attribute8 ;
8860: END IF;
8861: END IF;
8862: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
8863: OR p_in_rec.attribute9 IS NULL THEN
8864: IF x_out_rec.attribute9 IS NULL THEN
8865: x_out_rec.attribute9 := p_in_rec.attribute9 ;
8866: END IF;
8864: IF x_out_rec.attribute9 IS NULL THEN
8865: x_out_rec.attribute9 := p_in_rec.attribute9 ;
8866: END IF;
8867: END IF;
8868: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
8869: OR p_in_rec.attribute10 IS NULL THEN
8870: IF x_out_rec.attribute10 IS NULL THEN
8871: x_out_rec.attribute10 := p_in_rec.attribute10 ;
8872: END IF;
8870: IF x_out_rec.attribute10 IS NULL THEN
8871: x_out_rec.attribute10 := p_in_rec.attribute10 ;
8872: END IF;
8873: END IF;
8874: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
8875: OR p_in_rec.attribute11 IS NULL THEN
8876: IF x_out_rec.attribute11 IS NULL THEN
8877: x_out_rec.attribute11 := p_in_rec.attribute11 ;
8878: END IF;
8876: IF x_out_rec.attribute11 IS NULL THEN
8877: x_out_rec.attribute11 := p_in_rec.attribute11 ;
8878: END IF;
8879: END IF;
8880: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
8881: OR p_in_rec.attribute12 IS NULL THEN
8882: IF x_out_rec.attribute12 IS NULL THEN
8883: x_out_rec.attribute12 := p_in_rec.attribute12 ;
8884: END IF;
8882: IF x_out_rec.attribute12 IS NULL THEN
8883: x_out_rec.attribute12 := p_in_rec.attribute12 ;
8884: END IF;
8885: END IF;
8886: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
8887: OR p_in_rec.attribute13 IS NULL THEN
8888: IF x_out_rec.attribute13 IS NULL THEN
8889: x_out_rec.attribute13 := p_in_rec.attribute13 ;
8890: END IF;
8888: IF x_out_rec.attribute13 IS NULL THEN
8889: x_out_rec.attribute13 := p_in_rec.attribute13 ;
8890: END IF;
8891: END IF;
8892: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
8893: OR p_in_rec.attribute14 IS NULL THEN
8894: IF x_out_rec.attribute14 IS NULL THEN
8895: x_out_rec.attribute14 := p_in_rec.attribute14 ;
8896: END IF;
8894: IF x_out_rec.attribute14 IS NULL THEN
8895: x_out_rec.attribute14 := p_in_rec.attribute14 ;
8896: END IF;
8897: END IF;
8898: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
8899: OR p_in_rec.attribute15 IS NULL THEN
8900: IF x_out_rec.attribute15 IS NULL THEN
8901: x_out_rec.attribute15 := p_in_rec.attribute15 ;
8902: END IF;
8900: IF x_out_rec.attribute15 IS NULL THEN
8901: x_out_rec.attribute15 := p_in_rec.attribute15 ;
8902: END IF;
8903: END IF;
8904: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
8905: OR p_in_rec.attribute_category IS NULL THEN
8906: IF x_out_rec.attribute_category IS NULL THEN
8907: x_out_rec.attribute_category := p_in_rec.attribute_category ;
8908: END IF;
8907: x_out_rec.attribute_category := p_in_rec.attribute_category ;
8908: END IF;
8909: END IF;
8910: ELSIF p_disabled_list(i) = '+TP_FLEXFIELD' THEN
8911: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
8912: OR p_in_rec.tp_attribute1 IS NULL THEN
8913: IF x_out_rec.tp_attribute1 IS NULL THEN
8914: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
8915: END IF;
8913: IF x_out_rec.tp_attribute1 IS NULL THEN
8914: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
8915: END IF;
8916: END IF;
8917: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
8918: OR p_in_rec.tp_attribute2 IS NULL THEN
8919: IF x_out_rec.tp_attribute2 IS NULL THEN
8920: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
8921: END IF;
8919: IF x_out_rec.tp_attribute2 IS NULL THEN
8920: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
8921: END IF;
8922: END IF;
8923: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
8924: OR p_in_rec.tp_attribute3 IS NULL THEN
8925: IF x_out_rec.tp_attribute3 IS NULL THEN
8926: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
8927: END IF;
8925: IF x_out_rec.tp_attribute3 IS NULL THEN
8926: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
8927: END IF;
8928: END IF;
8929: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
8930: OR p_in_rec.tp_attribute4 IS NULL THEN
8931: IF x_out_rec.tp_attribute4 IS NULL THEN
8932: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
8933: END IF;
8931: IF x_out_rec.tp_attribute4 IS NULL THEN
8932: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
8933: END IF;
8934: END IF;
8935: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
8936: OR p_in_rec.tp_attribute5 IS NULL THEN
8937: IF x_out_rec.tp_attribute5 IS NULL THEN
8938: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
8939: END IF;
8937: IF x_out_rec.tp_attribute5 IS NULL THEN
8938: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
8939: END IF;
8940: END IF;
8941: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
8942: OR p_in_rec.tp_attribute6 IS NULL THEN
8943: IF x_out_rec.tp_attribute6 IS NULL THEN
8944: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
8945: END IF;
8943: IF x_out_rec.tp_attribute6 IS NULL THEN
8944: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
8945: END IF;
8946: END IF;
8947: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
8948: OR p_in_rec.tp_attribute7 IS NULL THEN
8949: IF x_out_rec.tp_attribute7 IS NULL THEN
8950: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
8951: END IF;
8949: IF x_out_rec.tp_attribute7 IS NULL THEN
8950: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
8951: END IF;
8952: END IF;
8953: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
8954: OR p_in_rec.tp_attribute8 IS NULL THEN
8955: IF x_out_rec.tp_attribute8 IS NULL THEN
8956: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
8957: END IF;
8955: IF x_out_rec.tp_attribute8 IS NULL THEN
8956: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
8957: END IF;
8958: END IF;
8959: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
8960: OR p_in_rec.tp_attribute9 IS NULL THEN
8961: IF x_out_rec.tp_attribute9 IS NULL THEN
8962: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
8963: END IF;
8961: IF x_out_rec.tp_attribute9 IS NULL THEN
8962: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
8963: END IF;
8964: END IF;
8965: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
8966: OR p_in_rec.tp_attribute10 IS NULL THEN
8967: IF x_out_rec.tp_attribute10 IS NULL THEN
8968: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
8969: END IF;
8967: IF x_out_rec.tp_attribute10 IS NULL THEN
8968: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
8969: END IF;
8970: END IF;
8971: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
8972: OR p_in_rec.tp_attribute11 IS NULL THEN
8973: IF x_out_rec.tp_attribute11 IS NULL THEN
8974: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
8975: END IF;
8973: IF x_out_rec.tp_attribute11 IS NULL THEN
8974: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
8975: END IF;
8976: END IF;
8977: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
8978: OR p_in_rec.tp_attribute12 IS NULL THEN
8979: IF x_out_rec.tp_attribute12 IS NULL THEN
8980: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
8981: END IF;
8979: IF x_out_rec.tp_attribute12 IS NULL THEN
8980: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
8981: END IF;
8982: END IF;
8983: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
8984: OR p_in_rec.tp_attribute13 IS NULL THEN
8985: IF x_out_rec.tp_attribute13 IS NULL THEN
8986: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
8987: END IF;
8985: IF x_out_rec.tp_attribute13 IS NULL THEN
8986: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
8987: END IF;
8988: END IF;
8989: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
8990: OR p_in_rec.tp_attribute14 IS NULL THEN
8991: IF x_out_rec.tp_attribute14 IS NULL THEN
8992: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
8993: END IF;
8991: IF x_out_rec.tp_attribute14 IS NULL THEN
8992: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
8993: END IF;
8994: END IF;
8995: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
8996: OR p_in_rec.tp_attribute15 IS NULL THEN
8997: IF x_out_rec.tp_attribute15 IS NULL THEN
8998: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
8999: END IF;
8997: IF x_out_rec.tp_attribute15 IS NULL THEN
8998: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
8999: END IF;
9000: END IF;
9001: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
9002: OR p_in_rec.tp_attribute_category IS NULL THEN
9003: IF x_out_rec.tp_attribute_category IS NULL THEN
9004: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
9005: END IF;
9004: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
9005: END IF;
9006: END IF;
9007: ELSIF p_disabled_list(i) = '+GLOBALIZATION_FLEXFIELD' THEN
9008: IF p_in_rec.global_attribute1 <> FND_API.G_MISS_CHAR
9009: OR p_in_rec.global_attribute1 IS NULL THEN
9010: IF x_out_rec.global_attribute1 IS NULL THEN
9011: x_out_rec.global_attribute1 := p_in_rec.global_attribute1 ;
9012: END IF;
9010: IF x_out_rec.global_attribute1 IS NULL THEN
9011: x_out_rec.global_attribute1 := p_in_rec.global_attribute1 ;
9012: END IF;
9013: END IF;
9014: IF p_in_rec.global_attribute2 <> FND_API.G_MISS_CHAR
9015: OR p_in_rec.global_attribute2 IS NULL THEN
9016: IF x_out_rec.global_attribute2 IS NULL THEN
9017: x_out_rec.global_attribute2 := p_in_rec.global_attribute2 ;
9018: END IF;
9016: IF x_out_rec.global_attribute2 IS NULL THEN
9017: x_out_rec.global_attribute2 := p_in_rec.global_attribute2 ;
9018: END IF;
9019: END IF;
9020: IF p_in_rec.global_attribute3 <> FND_API.G_MISS_CHAR
9021: OR p_in_rec.global_attribute3 IS NULL THEN
9022: IF x_out_rec.global_attribute3 IS NULL THEN
9023: x_out_rec.global_attribute3 := p_in_rec.global_attribute3 ;
9024: END IF;
9022: IF x_out_rec.global_attribute3 IS NULL THEN
9023: x_out_rec.global_attribute3 := p_in_rec.global_attribute3 ;
9024: END IF;
9025: END IF;
9026: IF p_in_rec.global_attribute4 <> FND_API.G_MISS_CHAR
9027: OR p_in_rec.global_attribute4 IS NULL THEN
9028: IF x_out_rec.global_attribute4 IS NULL THEN
9029: x_out_rec.global_attribute4 := p_in_rec.global_attribute4 ;
9030: END IF;
9028: IF x_out_rec.global_attribute4 IS NULL THEN
9029: x_out_rec.global_attribute4 := p_in_rec.global_attribute4 ;
9030: END IF;
9031: END IF;
9032: IF p_in_rec.global_attribute5 <> FND_API.G_MISS_CHAR
9033: OR p_in_rec.global_attribute5 IS NULL THEN
9034: IF x_out_rec.global_attribute5 IS NULL THEN
9035: x_out_rec.global_attribute5 := p_in_rec.global_attribute5 ;
9036: END IF;
9034: IF x_out_rec.global_attribute5 IS NULL THEN
9035: x_out_rec.global_attribute5 := p_in_rec.global_attribute5 ;
9036: END IF;
9037: END IF;
9038: IF p_in_rec.global_attribute6 <> FND_API.G_MISS_CHAR
9039: OR p_in_rec.global_attribute6 IS NULL THEN
9040: IF x_out_rec.global_attribute6 IS NULL THEN
9041: x_out_rec.global_attribute6 := p_in_rec.global_attribute6 ;
9042: END IF;
9040: IF x_out_rec.global_attribute6 IS NULL THEN
9041: x_out_rec.global_attribute6 := p_in_rec.global_attribute6 ;
9042: END IF;
9043: END IF;
9044: IF p_in_rec.global_attribute7 <> FND_API.G_MISS_CHAR
9045: OR p_in_rec.global_attribute7 IS NULL THEN
9046: IF x_out_rec.global_attribute7 IS NULL THEN
9047: x_out_rec.global_attribute7 := p_in_rec.global_attribute7 ;
9048: END IF;
9046: IF x_out_rec.global_attribute7 IS NULL THEN
9047: x_out_rec.global_attribute7 := p_in_rec.global_attribute7 ;
9048: END IF;
9049: END IF;
9050: IF p_in_rec.global_attribute8 <> FND_API.G_MISS_CHAR
9051: OR p_in_rec.global_attribute8 IS NULL THEN
9052: IF x_out_rec.global_attribute8 IS NULL THEN
9053: x_out_rec.global_attribute8 := p_in_rec.global_attribute8 ;
9054: END IF;
9052: IF x_out_rec.global_attribute8 IS NULL THEN
9053: x_out_rec.global_attribute8 := p_in_rec.global_attribute8 ;
9054: END IF;
9055: END IF;
9056: IF p_in_rec.global_attribute9 <> FND_API.G_MISS_CHAR
9057: OR p_in_rec.global_attribute9 IS NULL THEN
9058: IF x_out_rec.global_attribute9 IS NULL THEN
9059: x_out_rec.global_attribute9 := p_in_rec.global_attribute9 ;
9060: END IF;
9058: IF x_out_rec.global_attribute9 IS NULL THEN
9059: x_out_rec.global_attribute9 := p_in_rec.global_attribute9 ;
9060: END IF;
9061: END IF;
9062: IF p_in_rec.global_attribute10 <> FND_API.G_MISS_CHAR
9063: OR p_in_rec.global_attribute10 IS NULL THEN
9064: IF x_out_rec.global_attribute10 IS NULL THEN
9065: x_out_rec.global_attribute10 := p_in_rec.global_attribute10 ;
9066: END IF;
9064: IF x_out_rec.global_attribute10 IS NULL THEN
9065: x_out_rec.global_attribute10 := p_in_rec.global_attribute10 ;
9066: END IF;
9067: END IF;
9068: IF p_in_rec.global_attribute11 <> FND_API.G_MISS_CHAR
9069: OR p_in_rec.global_attribute11 IS NULL THEN
9070: IF x_out_rec.global_attribute11 IS NULL THEN
9071: x_out_rec.global_attribute11 := p_in_rec.global_attribute11 ;
9072: END IF;
9070: IF x_out_rec.global_attribute11 IS NULL THEN
9071: x_out_rec.global_attribute11 := p_in_rec.global_attribute11 ;
9072: END IF;
9073: END IF;
9074: IF p_in_rec.global_attribute12 <> FND_API.G_MISS_CHAR
9075: OR p_in_rec.global_attribute12 IS NULL THEN
9076: IF x_out_rec.global_attribute12 IS NULL THEN
9077: x_out_rec.global_attribute12 := p_in_rec.global_attribute12 ;
9078: END IF;
9076: IF x_out_rec.global_attribute12 IS NULL THEN
9077: x_out_rec.global_attribute12 := p_in_rec.global_attribute12 ;
9078: END IF;
9079: END IF;
9080: IF p_in_rec.global_attribute13 <> FND_API.G_MISS_CHAR
9081: OR p_in_rec.global_attribute13 IS NULL THEN
9082: IF x_out_rec.global_attribute13 IS NULL THEN
9083: x_out_rec.global_attribute13 := p_in_rec.global_attribute13 ;
9084: END IF;
9082: IF x_out_rec.global_attribute13 IS NULL THEN
9083: x_out_rec.global_attribute13 := p_in_rec.global_attribute13 ;
9084: END IF;
9085: END IF;
9086: IF p_in_rec.global_attribute14 <> FND_API.G_MISS_CHAR
9087: OR p_in_rec.global_attribute14 IS NULL THEN
9088: IF x_out_rec.global_attribute14 IS NULL THEN
9089: x_out_rec.global_attribute14 := p_in_rec.global_attribute14 ;
9090: END IF;
9088: IF x_out_rec.global_attribute14 IS NULL THEN
9089: x_out_rec.global_attribute14 := p_in_rec.global_attribute14 ;
9090: END IF;
9091: END IF;
9092: IF p_in_rec.global_attribute15 <> FND_API.G_MISS_CHAR
9093: OR p_in_rec.global_attribute15 IS NULL THEN
9094: IF x_out_rec.global_attribute15 IS NULL THEN
9095: x_out_rec.global_attribute15 := p_in_rec.global_attribute15 ;
9096: END IF;
9094: IF x_out_rec.global_attribute15 IS NULL THEN
9095: x_out_rec.global_attribute15 := p_in_rec.global_attribute15 ;
9096: END IF;
9097: END IF;
9098: IF p_in_rec.global_attribute_category <> FND_API.G_MISS_CHAR
9099: OR p_in_rec.global_attribute_category IS NULL THEN
9100: IF x_out_rec.global_attribute_category IS NULL THEN
9101: x_out_rec.global_attribute_category := p_in_rec.global_attribute_category ;
9102: END IF;
9110: RETURN;
9111: END IF;
9112: ELSE -- if the prefix is not +
9113: IF p_disabled_list(i) = 'ADDITIONAL_SHIPMENT_INFO' THEN
9114: IF p_in_rec.ADDITIONAL_SHIPMENT_INFO <> FND_API.G_MISS_CHAR
9115: OR p_in_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
9116: x_out_rec.ADDITIONAL_SHIPMENT_INFO := p_in_rec.ADDITIONAL_SHIPMENT_INFO ;
9117: END IF;
9118: ELSIF p_disabled_list(i) = 'DOCK_CODE' THEN
9115: OR p_in_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
9116: x_out_rec.ADDITIONAL_SHIPMENT_INFO := p_in_rec.ADDITIONAL_SHIPMENT_INFO ;
9117: END IF;
9118: ELSIF p_disabled_list(i) = 'DOCK_CODE' THEN
9119: IF p_in_rec.DOCK_CODE <> FND_API.G_MISS_CHAR
9120: OR p_in_rec.DOCK_CODE IS NULL THEN
9121: x_out_rec.DOCK_CODE := p_in_rec.DOCK_CODE ;
9122: END IF;
9123: ELSIF p_disabled_list(i) = 'INITIAL_PICKUP_LOCATION_CODE' THEN
9158: NULL,
9159: x_out_rec.loading_order_flag,
9160: x_out_rec.loading_order_desc);
9161: ELSIF p_disabled_list(i) = 'ACCEPTANCE_FLAG' THEN
9162: IF p_in_rec.ACCEPTANCE_FLAG <> FND_API.G_MISS_CHAR
9163: OR p_in_rec.ACCEPTANCE_FLAG IS NULL THEN
9164: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
9165: END IF;
9166: ELSIF p_disabled_list(i) = 'ACCEPTED_BY' THEN
9163: OR p_in_rec.ACCEPTANCE_FLAG IS NULL THEN
9164: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
9165: END IF;
9166: ELSIF p_disabled_list(i) = 'ACCEPTED_BY' THEN
9167: IF p_in_rec.ACCEPTED_BY <> FND_API.G_MISS_CHAR
9168: OR p_in_rec.ACCEPTED_BY IS NULL THEN
9169: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
9170: END IF;
9171: ELSIF p_disabled_list(i) = 'ACCEPTED_DATE' THEN
9168: OR p_in_rec.ACCEPTED_BY IS NULL THEN
9169: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
9170: END IF;
9171: ELSIF p_disabled_list(i) = 'ACCEPTED_DATE' THEN
9172: IF p_in_rec.ACCEPTED_DATE <> FND_API.G_MISS_DATE
9173: OR p_in_rec.ACCEPTED_DATE IS NULL THEN
9174: x_out_rec.ACCEPTED_DATE := p_in_rec.ACCEPTED_DATE ;
9175: END IF;
9176: ELSIF p_disabled_list(i) = 'ACKNOWLEDGED_BY' THEN
9173: OR p_in_rec.ACCEPTED_DATE IS NULL THEN
9174: x_out_rec.ACCEPTED_DATE := p_in_rec.ACCEPTED_DATE ;
9175: END IF;
9176: ELSIF p_disabled_list(i) = 'ACKNOWLEDGED_BY' THEN
9177: IF p_in_rec.ACKNOWLEDGED_BY <> FND_API.G_MISS_CHAR
9178: OR p_in_rec.ACKNOWLEDGED_BY IS NULL THEN
9179: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
9180: END IF;
9181: ELSIF p_disabled_list(i) = 'CONFIRMED_BY' THEN
9178: OR p_in_rec.ACKNOWLEDGED_BY IS NULL THEN
9179: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
9180: END IF;
9181: ELSIF p_disabled_list(i) = 'CONFIRMED_BY' THEN
9182: IF p_in_rec.CONFIRMED_BY <> FND_API.G_MISS_CHAR
9183: OR p_in_rec.CONFIRMED_BY IS NULL THEN
9184: x_out_rec.CONFIRMED_BY := p_in_rec.CONFIRMED_BY ;
9185: END IF;
9186: ELSIF p_disabled_list(i) = 'CURRENCY_CODE' THEN
9189: NULL,
9190: x_out_rec.currency_code,
9191: x_out_rec.currency_name);
9192: ELSIF p_disabled_list(i) = 'INITIAL_PICKUP_DATE' THEN
9193: IF p_in_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE
9194: OR p_in_rec.INITIAL_PICKUP_DATE IS NULL THEN
9195: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
9196: END IF;
9197: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_DATE' THEN
9194: OR p_in_rec.INITIAL_PICKUP_DATE IS NULL THEN
9195: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
9196: END IF;
9197: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_DATE' THEN
9198: IF p_in_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE
9199: OR p_in_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
9200: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
9201: END IF;
9202: ELSIF p_disabled_list(i) = 'LOADING_SEQUENCE' THEN
9199: OR p_in_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
9200: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
9201: END IF;
9202: ELSIF p_disabled_list(i) = 'LOADING_SEQUENCE' THEN
9203: IF p_in_rec.LOADING_SEQUENCE <> FND_API.G_MISS_NUM
9204: OR p_in_rec.LOADING_SEQUENCE IS NULL THEN
9205: x_out_rec.LOADING_SEQUENCE := p_in_rec.LOADING_SEQUENCE ;
9206: END IF;
9207: ELSIF p_disabled_list(i) = 'SHIP_METHOD_NAME' THEN
9220: x_out_rec.carrier_id,
9221: x_out_rec.carrier_code);
9222: -- J-IB-NPARIKH-}
9223: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL_NAME' THEN
9224: IF p_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
9225: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
9226: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
9227: END IF;
9228: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT_NAME' THEN
9225: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
9226: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
9227: END IF;
9228: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT_NAME' THEN
9229: IF p_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
9230: OR p_in_rec.MODE_OF_TRANSPORT IS NULL THEN
9231: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
9232: END IF;
9233: ELSIF p_disabled_list(i) = 'NAME' THEN
9230: OR p_in_rec.MODE_OF_TRANSPORT IS NULL THEN
9231: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
9232: END IF;
9233: ELSIF p_disabled_list(i) = 'NAME' THEN
9234: IF p_in_rec.NAME <> FND_API.G_MISS_CHAR
9235: OR p_in_rec.NAME IS NULL THEN
9236: x_out_rec.NAME := p_in_rec.NAME ;
9237: END IF;
9238: ELSIF p_disabled_list(i) = 'INTMED_SHIP_TO_LOCATION_CODE' THEN
9247: NULL,
9248: x_out_rec.POOLED_SHIP_TO_LOCATION_ID,
9249: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE);
9250: ELSIF p_disabled_list(i) = 'WAYBILL' THEN
9251: IF p_in_rec.WAYBILL <> FND_API.G_MISS_CHAR
9252: OR p_in_rec.WAYBILL IS NULL THEN
9253: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
9254: END IF;
9255: ELSIF p_disabled_list(i) = 'FREIGHT_TERMS_NAME' THEN
9258: NULL,
9259: x_out_rec.FREIGHT_TERMS_CODE,
9260: x_out_rec.FREIGHT_TERMS_NAME);
9261: ELSIF p_disabled_list(i) = 'GROSS_WEIGHT' THEN
9262: IF p_in_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
9263: OR p_in_rec.GROSS_WEIGHT IS NULL THEN
9264: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
9265: END IF;
9266: ELSIF p_disabled_list(i) = 'NET_WEIGHT' THEN
9263: OR p_in_rec.GROSS_WEIGHT IS NULL THEN
9264: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
9265: END IF;
9266: ELSIF p_disabled_list(i) = 'NET_WEIGHT' THEN
9267: IF p_in_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
9268: OR p_in_rec.NET_WEIGHT IS NULL THEN
9269: x_out_rec.NET_WEIGHT := p_in_rec.NET_WEIGHT ;
9270: END IF;
9271: -- Non Database field prorate_wt_flag added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
9269: x_out_rec.NET_WEIGHT := p_in_rec.NET_WEIGHT ;
9270: END IF;
9271: -- Non Database field prorate_wt_flag added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
9272: ELSIF p_disabled_list(i) = 'PRORATE_WT_FLAG' THEN
9273: -- Bug#4539613 : replaced FND_API.G_MISS_NUM by FND_API.G_MISS_CHAR
9274: IF p_in_rec.PRORATE_WT_FLAG <> FND_API.G_MISS_CHAR OR p_in_rec.PRORATE_WT_FLAG IS NULL THEN
9275: x_out_rec.PRORATE_WT_FLAG := p_in_rec.PRORATE_WT_FLAG ;
9276: END IF;
9277: --
9270: END IF;
9271: -- Non Database field prorate_wt_flag added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
9272: ELSIF p_disabled_list(i) = 'PRORATE_WT_FLAG' THEN
9273: -- Bug#4539613 : replaced FND_API.G_MISS_NUM by FND_API.G_MISS_CHAR
9274: IF p_in_rec.PRORATE_WT_FLAG <> FND_API.G_MISS_CHAR OR p_in_rec.PRORATE_WT_FLAG IS NULL THEN
9275: x_out_rec.PRORATE_WT_FLAG := p_in_rec.PRORATE_WT_FLAG ;
9276: END IF;
9277: --
9278: ELSIF p_disabled_list(i) = 'WEIGHT_UOM_CODE' THEN
9282: x_out_rec.WEIGHT_UOM_CODE,
9283: x_out_rec.WEIGHT_UOM_DESC);
9284:
9285: ELSIF p_disabled_list(i) = 'VOLUME' THEN
9286: IF p_in_rec.VOLUME <> FND_API.G_MISS_NUM
9287: OR p_in_rec.VOLUME IS NULL THEN
9288: x_out_rec.VOLUME := p_in_rec.VOLUME ;
9289: END IF;
9290: ELSIF p_disabled_list(i) = 'VOLUME_UOM_CODE' THEN
9305: NULL,
9306: x_out_rec.FOB_LOCATION_ID,
9307: x_out_rec.FOB_LOCATION_CODE);
9308: ELSIF p_disabled_list(i) = 'NUMBER_OF_LPN' THEN
9309: IF p_in_rec.NUMBER_OF_LPN <> FND_API.G_MISS_NUM
9310: OR p_in_rec.NUMBER_OF_LPN IS NULL THEN
9311: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
9312: END IF;
9313: ELSIF p_disabled_list(i) = 'AUTO_SC_EXCLUDE_FLAG' THEN
9310: OR p_in_rec.NUMBER_OF_LPN IS NULL THEN
9311: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
9312: END IF;
9313: ELSIF p_disabled_list(i) = 'AUTO_SC_EXCLUDE_FLAG' THEN
9314: IF p_in_rec.AUTO_SC_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
9315: OR p_in_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
9316: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
9317: END IF;
9318: ELSIF p_disabled_list(i) = 'AUTO_AP_EXCLUDE_FLAG' THEN
9315: OR p_in_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
9316: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
9317: END IF;
9318: ELSIF p_disabled_list(i) = 'AUTO_AP_EXCLUDE_FLAG' THEN
9319: IF p_in_rec.AUTO_AP_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
9320: OR p_in_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
9321: x_out_rec.AUTO_AP_EXCLUDE_FLAG := p_in_rec.AUTO_AP_EXCLUDE_FLAG ;
9322: END IF;
9323: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
9320: OR p_in_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
9321: x_out_rec.AUTO_AP_EXCLUDE_FLAG := p_in_rec.AUTO_AP_EXCLUDE_FLAG ;
9322: END IF;
9323: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
9324: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
9325: OR p_in_rec.attribute1 IS NULL THEN
9326: x_out_rec.attribute1 := p_in_rec.attribute1 ;
9327: END IF;
9328: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
9324: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
9325: OR p_in_rec.attribute1 IS NULL THEN
9326: x_out_rec.attribute1 := p_in_rec.attribute1 ;
9327: END IF;
9328: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
9329: OR p_in_rec.attribute2 IS NULL THEN
9330: x_out_rec.attribute2 := p_in_rec.attribute2 ;
9331: END IF;
9332: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
9328: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
9329: OR p_in_rec.attribute2 IS NULL THEN
9330: x_out_rec.attribute2 := p_in_rec.attribute2 ;
9331: END IF;
9332: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
9333: OR p_in_rec.attribute3 IS NULL THEN
9334: x_out_rec.attribute3 := p_in_rec.attribute3 ;
9335: END IF;
9336: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
9332: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
9333: OR p_in_rec.attribute3 IS NULL THEN
9334: x_out_rec.attribute3 := p_in_rec.attribute3 ;
9335: END IF;
9336: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
9337: OR p_in_rec.attribute4 IS NULL THEN
9338: x_out_rec.attribute4 := p_in_rec.attribute4 ;
9339: END IF;
9340: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
9336: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
9337: OR p_in_rec.attribute4 IS NULL THEN
9338: x_out_rec.attribute4 := p_in_rec.attribute4 ;
9339: END IF;
9340: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
9341: OR p_in_rec.attribute5 IS NULL THEN
9342: x_out_rec.attribute5 := p_in_rec.attribute5 ;
9343: END IF;
9344: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
9340: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
9341: OR p_in_rec.attribute5 IS NULL THEN
9342: x_out_rec.attribute5 := p_in_rec.attribute5 ;
9343: END IF;
9344: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
9345: OR p_in_rec.attribute6 IS NULL THEN
9346: x_out_rec.attribute6 := p_in_rec.attribute6 ;
9347: END IF;
9348: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
9344: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
9345: OR p_in_rec.attribute6 IS NULL THEN
9346: x_out_rec.attribute6 := p_in_rec.attribute6 ;
9347: END IF;
9348: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
9349: OR p_in_rec.attribute7 IS NULL THEN
9350: x_out_rec.attribute7 := p_in_rec.attribute7 ;
9351: END IF;
9352: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
9348: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
9349: OR p_in_rec.attribute7 IS NULL THEN
9350: x_out_rec.attribute7 := p_in_rec.attribute7 ;
9351: END IF;
9352: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
9353: OR p_in_rec.attribute8 IS NULL THEN
9354: x_out_rec.attribute8 := p_in_rec.attribute8 ;
9355: END IF;
9356: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
9352: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
9353: OR p_in_rec.attribute8 IS NULL THEN
9354: x_out_rec.attribute8 := p_in_rec.attribute8 ;
9355: END IF;
9356: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
9357: OR p_in_rec.attribute9 IS NULL THEN
9358: x_out_rec.attribute9 := p_in_rec.attribute9 ;
9359: END IF;
9360: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
9356: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
9357: OR p_in_rec.attribute9 IS NULL THEN
9358: x_out_rec.attribute9 := p_in_rec.attribute9 ;
9359: END IF;
9360: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
9361: OR p_in_rec.attribute10 IS NULL THEN
9362: x_out_rec.attribute10 := p_in_rec.attribute10 ;
9363: END IF;
9364: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
9360: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
9361: OR p_in_rec.attribute10 IS NULL THEN
9362: x_out_rec.attribute10 := p_in_rec.attribute10 ;
9363: END IF;
9364: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
9365: OR p_in_rec.attribute11 IS NULL THEN
9366: x_out_rec.attribute11 := p_in_rec.attribute11 ;
9367: END IF;
9368: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
9364: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
9365: OR p_in_rec.attribute11 IS NULL THEN
9366: x_out_rec.attribute11 := p_in_rec.attribute11 ;
9367: END IF;
9368: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
9369: OR p_in_rec.attribute12 IS NULL THEN
9370: x_out_rec.attribute12 := p_in_rec.attribute12 ;
9371: END IF;
9372: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
9368: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
9369: OR p_in_rec.attribute12 IS NULL THEN
9370: x_out_rec.attribute12 := p_in_rec.attribute12 ;
9371: END IF;
9372: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
9373: OR p_in_rec.attribute13 IS NULL THEN
9374: x_out_rec.attribute13 := p_in_rec.attribute13 ;
9375: END IF;
9376: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
9372: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
9373: OR p_in_rec.attribute13 IS NULL THEN
9374: x_out_rec.attribute13 := p_in_rec.attribute13 ;
9375: END IF;
9376: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
9377: OR p_in_rec.attribute14 IS NULL THEN
9378: x_out_rec.attribute14 := p_in_rec.attribute14 ;
9379: END IF;
9380: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
9376: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
9377: OR p_in_rec.attribute14 IS NULL THEN
9378: x_out_rec.attribute14 := p_in_rec.attribute14 ;
9379: END IF;
9380: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
9381: OR p_in_rec.attribute15 IS NULL THEN
9382: x_out_rec.attribute15 := p_in_rec.attribute15 ;
9383: END IF;
9384: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
9380: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
9381: OR p_in_rec.attribute15 IS NULL THEN
9382: x_out_rec.attribute15 := p_in_rec.attribute15 ;
9383: END IF;
9384: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
9385: OR p_in_rec.attribute_category IS NULL THEN
9386: x_out_rec.attribute_category := p_in_rec.attribute_category ;
9387: END IF;
9388: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
9385: OR p_in_rec.attribute_category IS NULL THEN
9386: x_out_rec.attribute_category := p_in_rec.attribute_category ;
9387: END IF;
9388: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
9389: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
9390: OR p_in_rec.tp_attribute1 IS NULL THEN
9391: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
9392: END IF;
9393: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
9389: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
9390: OR p_in_rec.tp_attribute1 IS NULL THEN
9391: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
9392: END IF;
9393: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
9394: OR p_in_rec.tp_attribute2 IS NULL THEN
9395: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
9396: END IF;
9397: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
9393: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
9394: OR p_in_rec.tp_attribute2 IS NULL THEN
9395: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
9396: END IF;
9397: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
9398: OR p_in_rec.tp_attribute3 IS NULL THEN
9399: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
9400: END IF;
9401: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
9397: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
9398: OR p_in_rec.tp_attribute3 IS NULL THEN
9399: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
9400: END IF;
9401: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
9402: OR p_in_rec.tp_attribute4 IS NULL THEN
9403: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
9404: END IF;
9405: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
9401: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
9402: OR p_in_rec.tp_attribute4 IS NULL THEN
9403: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
9404: END IF;
9405: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
9406: OR p_in_rec.tp_attribute5 IS NULL THEN
9407: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
9408: END IF;
9409: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
9405: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
9406: OR p_in_rec.tp_attribute5 IS NULL THEN
9407: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
9408: END IF;
9409: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
9410: OR p_in_rec.tp_attribute6 IS NULL THEN
9411: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
9412: END IF;
9413: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
9409: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
9410: OR p_in_rec.tp_attribute6 IS NULL THEN
9411: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
9412: END IF;
9413: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
9414: OR p_in_rec.tp_attribute7 IS NULL THEN
9415: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
9416: END IF;
9417: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
9413: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
9414: OR p_in_rec.tp_attribute7 IS NULL THEN
9415: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
9416: END IF;
9417: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
9418: OR p_in_rec.tp_attribute8 IS NULL THEN
9419: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
9420: END IF;
9421: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
9417: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
9418: OR p_in_rec.tp_attribute8 IS NULL THEN
9419: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
9420: END IF;
9421: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
9422: OR p_in_rec.tp_attribute9 IS NULL THEN
9423: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
9424: END IF;
9425: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
9421: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
9422: OR p_in_rec.tp_attribute9 IS NULL THEN
9423: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
9424: END IF;
9425: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
9426: OR p_in_rec.tp_attribute10 IS NULL THEN
9427: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
9428: END IF;
9429: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
9425: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
9426: OR p_in_rec.tp_attribute10 IS NULL THEN
9427: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
9428: END IF;
9429: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
9430: OR p_in_rec.tp_attribute11 IS NULL THEN
9431: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
9432: END IF;
9433: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
9429: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
9430: OR p_in_rec.tp_attribute11 IS NULL THEN
9431: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
9432: END IF;
9433: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
9434: OR p_in_rec.tp_attribute12 IS NULL THEN
9435: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
9436: END IF;
9437: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
9433: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
9434: OR p_in_rec.tp_attribute12 IS NULL THEN
9435: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
9436: END IF;
9437: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
9438: OR p_in_rec.tp_attribute13 IS NULL THEN
9439: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
9440: END IF;
9441: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
9437: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
9438: OR p_in_rec.tp_attribute13 IS NULL THEN
9439: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
9440: END IF;
9441: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
9442: OR p_in_rec.tp_attribute14 IS NULL THEN
9443: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
9444: END IF;
9445: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
9441: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
9442: OR p_in_rec.tp_attribute14 IS NULL THEN
9443: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
9444: END IF;
9445: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
9446: OR p_in_rec.tp_attribute15 IS NULL THEN
9447: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
9448: END IF;
9449: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
9445: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
9446: OR p_in_rec.tp_attribute15 IS NULL THEN
9447: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
9448: END IF;
9449: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
9450: OR p_in_rec.tp_attribute_category IS NULL THEN
9451: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
9452: END IF;
9453: ELSIF p_disabled_list(i) = 'GLOBALIZATION_FLEXFIELD' THEN
9450: OR p_in_rec.tp_attribute_category IS NULL THEN
9451: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
9452: END IF;
9453: ELSIF p_disabled_list(i) = 'GLOBALIZATION_FLEXFIELD' THEN
9454: IF p_in_rec.global_attribute1 <> FND_API.G_MISS_CHAR
9455: OR p_in_rec.global_attribute1 IS NULL THEN
9456: x_out_rec.global_attribute1 := p_in_rec.global_attribute1 ;
9457: END IF;
9458: IF p_in_rec.global_attribute2 <> FND_API.G_MISS_CHAR
9454: IF p_in_rec.global_attribute1 <> FND_API.G_MISS_CHAR
9455: OR p_in_rec.global_attribute1 IS NULL THEN
9456: x_out_rec.global_attribute1 := p_in_rec.global_attribute1 ;
9457: END IF;
9458: IF p_in_rec.global_attribute2 <> FND_API.G_MISS_CHAR
9459: OR p_in_rec.global_attribute2 IS NULL THEN
9460: x_out_rec.global_attribute2 := p_in_rec.global_attribute2 ;
9461: END IF;
9462: IF p_in_rec.global_attribute3 <> FND_API.G_MISS_CHAR
9458: IF p_in_rec.global_attribute2 <> FND_API.G_MISS_CHAR
9459: OR p_in_rec.global_attribute2 IS NULL THEN
9460: x_out_rec.global_attribute2 := p_in_rec.global_attribute2 ;
9461: END IF;
9462: IF p_in_rec.global_attribute3 <> FND_API.G_MISS_CHAR
9463: OR p_in_rec.global_attribute3 IS NULL THEN
9464: x_out_rec.global_attribute3 := p_in_rec.global_attribute3 ;
9465: END IF;
9466: IF p_in_rec.global_attribute4 <> FND_API.G_MISS_CHAR
9462: IF p_in_rec.global_attribute3 <> FND_API.G_MISS_CHAR
9463: OR p_in_rec.global_attribute3 IS NULL THEN
9464: x_out_rec.global_attribute3 := p_in_rec.global_attribute3 ;
9465: END IF;
9466: IF p_in_rec.global_attribute4 <> FND_API.G_MISS_CHAR
9467: OR p_in_rec.global_attribute4 IS NULL THEN
9468: x_out_rec.global_attribute4 := p_in_rec.global_attribute4 ;
9469: END IF;
9470: IF p_in_rec.global_attribute5 <> FND_API.G_MISS_CHAR
9466: IF p_in_rec.global_attribute4 <> FND_API.G_MISS_CHAR
9467: OR p_in_rec.global_attribute4 IS NULL THEN
9468: x_out_rec.global_attribute4 := p_in_rec.global_attribute4 ;
9469: END IF;
9470: IF p_in_rec.global_attribute5 <> FND_API.G_MISS_CHAR
9471: OR p_in_rec.global_attribute5 IS NULL THEN
9472: x_out_rec.global_attribute5 := p_in_rec.global_attribute5 ;
9473: END IF;
9474: IF p_in_rec.global_attribute6 <> FND_API.G_MISS_CHAR
9470: IF p_in_rec.global_attribute5 <> FND_API.G_MISS_CHAR
9471: OR p_in_rec.global_attribute5 IS NULL THEN
9472: x_out_rec.global_attribute5 := p_in_rec.global_attribute5 ;
9473: END IF;
9474: IF p_in_rec.global_attribute6 <> FND_API.G_MISS_CHAR
9475: OR p_in_rec.global_attribute6 IS NULL THEN
9476: x_out_rec.global_attribute6 := p_in_rec.global_attribute6 ;
9477: END IF;
9478: IF p_in_rec.global_attribute7 <> FND_API.G_MISS_CHAR
9474: IF p_in_rec.global_attribute6 <> FND_API.G_MISS_CHAR
9475: OR p_in_rec.global_attribute6 IS NULL THEN
9476: x_out_rec.global_attribute6 := p_in_rec.global_attribute6 ;
9477: END IF;
9478: IF p_in_rec.global_attribute7 <> FND_API.G_MISS_CHAR
9479: OR p_in_rec.global_attribute7 IS NULL THEN
9480: x_out_rec.global_attribute7 := p_in_rec.global_attribute7 ;
9481: END IF;
9482: IF p_in_rec.global_attribute8 <> FND_API.G_MISS_CHAR
9478: IF p_in_rec.global_attribute7 <> FND_API.G_MISS_CHAR
9479: OR p_in_rec.global_attribute7 IS NULL THEN
9480: x_out_rec.global_attribute7 := p_in_rec.global_attribute7 ;
9481: END IF;
9482: IF p_in_rec.global_attribute8 <> FND_API.G_MISS_CHAR
9483: OR p_in_rec.global_attribute8 IS NULL THEN
9484: x_out_rec.global_attribute8 := p_in_rec.global_attribute8 ;
9485: END IF;
9486: IF p_in_rec.global_attribute9 <> FND_API.G_MISS_CHAR
9482: IF p_in_rec.global_attribute8 <> FND_API.G_MISS_CHAR
9483: OR p_in_rec.global_attribute8 IS NULL THEN
9484: x_out_rec.global_attribute8 := p_in_rec.global_attribute8 ;
9485: END IF;
9486: IF p_in_rec.global_attribute9 <> FND_API.G_MISS_CHAR
9487: OR p_in_rec.global_attribute9 IS NULL THEN
9488: x_out_rec.global_attribute9 := p_in_rec.global_attribute9 ;
9489: END IF;
9490: IF p_in_rec.global_attribute10 <> FND_API.G_MISS_CHAR
9486: IF p_in_rec.global_attribute9 <> FND_API.G_MISS_CHAR
9487: OR p_in_rec.global_attribute9 IS NULL THEN
9488: x_out_rec.global_attribute9 := p_in_rec.global_attribute9 ;
9489: END IF;
9490: IF p_in_rec.global_attribute10 <> FND_API.G_MISS_CHAR
9491: OR p_in_rec.global_attribute10 IS NULL THEN
9492: x_out_rec.global_attribute10 := p_in_rec.global_attribute10 ;
9493: END IF;
9494: IF p_in_rec.global_attribute11 <> FND_API.G_MISS_CHAR
9490: IF p_in_rec.global_attribute10 <> FND_API.G_MISS_CHAR
9491: OR p_in_rec.global_attribute10 IS NULL THEN
9492: x_out_rec.global_attribute10 := p_in_rec.global_attribute10 ;
9493: END IF;
9494: IF p_in_rec.global_attribute11 <> FND_API.G_MISS_CHAR
9495: OR p_in_rec.global_attribute11 IS NULL THEN
9496: x_out_rec.global_attribute11 := p_in_rec.global_attribute11 ;
9497: END IF;
9498: IF p_in_rec.global_attribute12 <> FND_API.G_MISS_CHAR
9494: IF p_in_rec.global_attribute11 <> FND_API.G_MISS_CHAR
9495: OR p_in_rec.global_attribute11 IS NULL THEN
9496: x_out_rec.global_attribute11 := p_in_rec.global_attribute11 ;
9497: END IF;
9498: IF p_in_rec.global_attribute12 <> FND_API.G_MISS_CHAR
9499: OR p_in_rec.global_attribute12 IS NULL THEN
9500: x_out_rec.global_attribute12 := p_in_rec.global_attribute12 ;
9501: END IF;
9502: IF p_in_rec.global_attribute13 <> FND_API.G_MISS_CHAR
9498: IF p_in_rec.global_attribute12 <> FND_API.G_MISS_CHAR
9499: OR p_in_rec.global_attribute12 IS NULL THEN
9500: x_out_rec.global_attribute12 := p_in_rec.global_attribute12 ;
9501: END IF;
9502: IF p_in_rec.global_attribute13 <> FND_API.G_MISS_CHAR
9503: OR p_in_rec.global_attribute13 IS NULL THEN
9504: x_out_rec.global_attribute13 := p_in_rec.global_attribute13 ;
9505: END IF;
9506: IF p_in_rec.global_attribute14 <> FND_API.G_MISS_CHAR
9502: IF p_in_rec.global_attribute13 <> FND_API.G_MISS_CHAR
9503: OR p_in_rec.global_attribute13 IS NULL THEN
9504: x_out_rec.global_attribute13 := p_in_rec.global_attribute13 ;
9505: END IF;
9506: IF p_in_rec.global_attribute14 <> FND_API.G_MISS_CHAR
9507: OR p_in_rec.global_attribute14 IS NULL THEN
9508: x_out_rec.global_attribute14 := p_in_rec.global_attribute14 ;
9509: END IF;
9510: IF p_in_rec.global_attribute15 <> FND_API.G_MISS_CHAR
9506: IF p_in_rec.global_attribute14 <> FND_API.G_MISS_CHAR
9507: OR p_in_rec.global_attribute14 IS NULL THEN
9508: x_out_rec.global_attribute14 := p_in_rec.global_attribute14 ;
9509: END IF;
9510: IF p_in_rec.global_attribute15 <> FND_API.G_MISS_CHAR
9511: OR p_in_rec.global_attribute15 IS NULL THEN
9512: x_out_rec.global_attribute15 := p_in_rec.global_attribute15 ;
9513: END IF;
9514: IF p_in_rec.global_attribute_category <> FND_API.G_MISS_CHAR
9510: IF p_in_rec.global_attribute15 <> FND_API.G_MISS_CHAR
9511: OR p_in_rec.global_attribute15 IS NULL THEN
9512: x_out_rec.global_attribute15 := p_in_rec.global_attribute15 ;
9513: END IF;
9514: IF p_in_rec.global_attribute_category <> FND_API.G_MISS_CHAR
9515: OR p_in_rec.global_attribute_category IS NULL THEN
9516: x_out_rec.attribute_category := p_in_rec.attribute_category ;
9517: END IF;
9518: ELSIF p_disabled_list(i) = 'TARE_WEIGHT' THEN
9754: WSH_DEBUG_SV.log(l_module_name,'Action Code', p_in_rec.action_code);
9755: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
9756: END IF;
9757: --
9758: x_return_status := FND_API.G_RET_STS_SUCCESS;
9759: --
9760: IF p_in_rec.action_code = 'CREATE' THEN
9761: --
9762: IF l_debug_on THEN
9836: -- bug 3371077: need to overwrite these dates even
9837: -- if delivery has contents.
9838: -- (technically equivalent to emptying the delivery,
9839: -- updating the dates, and re-assigning its contents)
9840: IF p_delivery_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE THEN
9841: x_delivery_rec.INITIAL_PICKUP_DATE := p_delivery_rec.INITIAL_PICKUP_DATE ;
9842: END IF;
9843: IF p_delivery_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE THEN
9844: x_delivery_rec.ULTIMATE_DROPOFF_DATE := p_delivery_rec.ULTIMATE_DROPOFF_DATE ;
9839: -- updating the dates, and re-assigning its contents)
9840: IF p_delivery_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE THEN
9841: x_delivery_rec.INITIAL_PICKUP_DATE := p_delivery_rec.INITIAL_PICKUP_DATE ;
9842: END IF;
9843: IF p_delivery_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE THEN
9844: x_delivery_rec.ULTIMATE_DROPOFF_DATE := p_delivery_rec.ULTIMATE_DROPOFF_DATE ;
9845: END IF;
9846: END IF;
9847: --
9977: ,l_field_name);
9978: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');
9979: END IF;
9980: --
9981: WHEN FND_API.G_EXC_ERROR THEN
9982: IF (c_tbl_rec%ISOPEN) THEN
9983: CLOSE c_tbl_rec;
9984: END IF;
9985:
9985:
9986: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9987: --
9988: IF l_debug_on THEN
9989: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9990: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9991: END IF;
9992: --
9993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9986: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9987: --
9988: IF l_debug_on THEN
9989: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9990: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9991: END IF;
9992: --
9993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9994: IF (c_tbl_rec%ISOPEN) THEN
9989: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9990: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9991: END IF;
9992: --
9993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9994: IF (c_tbl_rec%ISOPEN) THEN
9995: CLOSE c_tbl_rec;
9996: END IF;
9997:
9998: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
9999: --
10000: IF l_debug_on THEN
10001: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10002: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10003: END IF;
10004:
10005: WHEN OTHERS THEN
10006: IF (c_tbl_rec%ISOPEN) THEN
10524: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERY_ID');
10525: x_return_status := wsh_util_core.g_ret_sts_error;
10526: wsh_util_core.add_message(x_return_status,l_module_name);
10527: close l_del_org_csr;
10528: RAISE FND_API.G_EXC_ERROR;
10529: END IF;
10530: close l_del_org_csr;
10531: --
10532: IF l_organization_id <> p_organization_id THEN
10549: open l_check_uom_csr(l_vol_uom_class, l_vol_uom_code);
10550: fetch l_check_uom_csr into l_vol_uom_code;
10551: close l_check_uom_csr;
10552: --
10553: IF nvl(l_wt_uom_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
10554: x_weight_uom_code := l_wt_uom_code;
10555: ELSE
10556: --
10557: -- Bug# 8446283 : First consider the wt UOM code value on shipping parameters.
10566: x_wt_nullify_flag := TRUE;
10567: --
10568: END IF;
10569: --
10570: IF nvl(l_wt_uom_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
10571: x_volume_uom_code := l_vol_uom_code;
10572: ELSE
10573: --
10574: -- Bug# 8446283 : First consider the vol UOM code value on shipping parameters.
10596: WSH_DEBUG_SV.pop(l_module_name);
10597: END IF;
10598: --
10599: EXCEPTION
10600: WHEN FND_API.G_EXC_ERROR THEN
10601: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10602: --
10603: IF l_debug_on THEN
10604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10600: WHEN FND_API.G_EXC_ERROR THEN
10601: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10602: --
10603: IF l_debug_on THEN
10604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10606: END IF;
10607: --
10608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10601: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10602: --
10603: IF l_debug_on THEN
10604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10606: END IF;
10607: --
10608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10606: END IF;
10607: --
10608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10610: --
10611: IF l_debug_on THEN
10612: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10610: --
10611: IF l_debug_on THEN
10612: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10614: END IF;
10615: --
10616: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10617: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10663: END IF;
10664: --
10665: SAVEPOINT VALIDATE_ROUTED_EXPORT_TXN;
10666: --
10667: IF nvl(x_rtd_expt_txn_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10668: OR nvl(p_rtd_expt_txn_meaning,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10669: THEN
10670: IF x_rtd_expt_txn_code = FND_API.G_MISS_CHAR THEN
10671: x_rtd_expt_txn_code := NULL;
10664: --
10665: SAVEPOINT VALIDATE_ROUTED_EXPORT_TXN;
10666: --
10667: IF nvl(x_rtd_expt_txn_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10668: OR nvl(p_rtd_expt_txn_meaning,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10669: THEN
10670: IF x_rtd_expt_txn_code = FND_API.G_MISS_CHAR THEN
10671: x_rtd_expt_txn_code := NULL;
10672: END IF;
10666: --
10667: IF nvl(x_rtd_expt_txn_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10668: OR nvl(p_rtd_expt_txn_meaning,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10669: THEN
10670: IF x_rtd_expt_txn_code = FND_API.G_MISS_CHAR THEN
10671: x_rtd_expt_txn_code := NULL;
10672: END IF;
10673: WSH_UTIL_VALIDATE.validate_lookup(
10674: p_lookup_type => 'YES_NO',
10693: WSH_DEBUG_SV.pop(l_module_name);
10694: END IF;
10695: --
10696: EXCEPTION
10697: WHEN FND_API.G_EXC_ERROR THEN
10698: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10699: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10700: --
10701: IF l_debug_on THEN
10698: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10699: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10700: --
10701: IF l_debug_on THEN
10702: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10703: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10704: END IF;
10705: --
10706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10699: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10700: --
10701: IF l_debug_on THEN
10702: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10703: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10704: END IF;
10705: --
10706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10707: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10702: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10703: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10704: END IF;
10705: --
10706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10707: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10708: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10709: --
10710: IF l_debug_on THEN
10708: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10709: --
10710: IF l_debug_on THEN
10711: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10713: END IF;
10714: --
10715: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10716: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10771: END IF;
10772: --
10773: SAVEPOINT DERIVE_NUMBER_OF_LPN;
10774: --
10775: IF nvl(x_number_of_lpn,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
10776: --
10777: open lpn_cur;
10778: fetch lpn_cur into x_number_of_lpn;
10779: close lpn_cur;
10790: WSH_DEBUG_SV.pop(l_module_name);
10791: END IF;
10792: --
10793: EXCEPTION
10794: WHEN FND_API.G_EXC_ERROR THEN
10795: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10796: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10797: --
10798: IF l_debug_on THEN
10795: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10796: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10797: --
10798: IF l_debug_on THEN
10799: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10800: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10801: END IF;
10802: --
10803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10796: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10797: --
10798: IF l_debug_on THEN
10799: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10800: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10801: END IF;
10802: --
10803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10804: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10799: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10800: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10801: END IF;
10802: --
10803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10804: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10805: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10806: --
10807: IF l_debug_on THEN
10805: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10806: --
10807: IF l_debug_on THEN
10808: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10809: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10810: END IF;
10811: --
10812: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10901: WSH_DEBUG_SV.log(l_module_name,'p_pickup_location_id',p_pickup_location_id);
10902: WSH_DEBUG_SV.log(l_module_name,'p_dropoff_location_id',p_dropoff_location_id);
10903: --
10904: END IF;
10905: IF nvl(p_delivery_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
10906: --
10907: open l_pick_up_leg_csr(p_delivery_id, p_pickup_location_id);
10908: fetch l_pick_up_leg_csr into l_trip_name, l_del_name;
10909: close l_pick_up_leg_csr;
10920: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
10921: FND_MESSAGE.SET_TOKEN('PICKUP_LOC',l_loc_description);
10922: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10923: wsh_util_core.add_message(x_return_status);
10924: RAISE FND_API.G_EXC_ERROR;
10925: END IF;
10926: --
10927: l_trip_name := NULL;
10928: open l_drop_off_leg_csr(p_delivery_id, p_dropoff_location_id);
10941: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
10942: FND_MESSAGE.SET_TOKEN('DROPOFF_LOC',l_loc_description);
10943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10944: wsh_util_core.add_message(x_return_status);
10945: RAISE FND_API.G_EXC_ERROR;
10946: END IF;
10947: --
10948: END IF;
10949:
10954: WSH_DEBUG_SV.pop(l_module_name);
10955: END IF;
10956: --
10957: EXCEPTION
10958: WHEN FND_API.G_EXC_ERROR THEN
10959: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10960: --
10961: IF l_debug_on THEN
10962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10958: WHEN FND_API.G_EXC_ERROR THEN
10959: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10960: --
10961: IF l_debug_on THEN
10962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10964: END IF;
10965: --
10966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10959: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10960: --
10961: IF l_debug_on THEN
10962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10964: END IF;
10965: --
10966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10967: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10964: END IF;
10965: --
10966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10967: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10968: --
10969: IF l_debug_on THEN
10970: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10967: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10968: --
10969: IF l_debug_on THEN
10970: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10971: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10972: END IF;
10973: --
10974: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10975: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
11484: );
11485: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
11486: x_return_status := l_return_status;
11487: wsh_util_core.add_message(x_return_status);
11488: RAISE FND_API.G_EXC_ERROR;
11489: END IF;
11490: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
11491: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
11492: IF l_exceptions_tab(exp_cnt).entity_name = 'DELIVERY' THEN
11586: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11587: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed_warning');
11588: END IF;
11589: --
11590: WHEN FND_API.G_EXC_ERROR THEN
11591:
11592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11593: --
11594: IF l_debug_on THEN
11591:
11592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11593: --
11594: IF l_debug_on THEN
11595: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11597: END IF;
11598: --
11599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11593: --
11594: IF l_debug_on THEN
11595: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11597: END IF;
11598: --
11599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11600:
11595: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11597: END IF;
11598: --
11599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11600:
11601: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11602: --
11603: IF l_debug_on THEN
11601: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11602: --
11603: IF l_debug_on THEN
11604: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
11606: END IF;
11607: --
11608: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
11609: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
11709: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERY');
11710: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',p_delivery_id);
11711: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
11712: --CLOSE dlvy_csr;
11713: RAISE FND_API.G_EXC_ERROR;
11714: --}
11715: END IF;
11716: --
11717: CLOSE dlvy_csr;
11766: --
11767: --}
11768: EXCEPTION
11769: --{
11770: WHEN FND_API.G_EXC_ERROR THEN
11771:
11772: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11773: --
11774: IF l_debug_on THEN
11771:
11772: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11773: --
11774: IF l_debug_on THEN
11775: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11776: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11777: END IF;
11778: --
11779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11772: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11773: --
11774: IF l_debug_on THEN
11775: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11776: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11777: END IF;
11778: --
11779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11780:
11775: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11776: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11777: END IF;
11778: --
11779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11780:
11781: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11782: --
11783: IF l_debug_on THEN
11781: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11782: --
11783: IF l_debug_on THEN
11784: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
11786: END IF;
11787: --
11788: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
11789: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
11837: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
11838: --
11839: END IF;
11840: --
11841: x_return_status := FND_API.G_RET_STS_SUCCESS;
11842: --
11843: IF p_user_in_rec.DELIVERY_ID <> FND_API.G_MISS_NUM
11844: AND NVL(p_user_in_rec.DELIVERY_ID,-99) <> NVL(p_out_rec.DELIVERY_ID,-99)
11845: THEN
11839: END IF;
11840: --
11841: x_return_status := FND_API.G_RET_STS_SUCCESS;
11842: --
11843: IF p_user_in_rec.DELIVERY_ID <> FND_API.G_MISS_NUM
11844: AND NVL(p_user_in_rec.DELIVERY_ID,-99) <> NVL(p_out_rec.DELIVERY_ID,-99)
11845: THEN
11846: l_attributes := l_attributes || 'DELIVERY_ID, ';
11847: END IF;
11845: THEN
11846: l_attributes := l_attributes || 'DELIVERY_ID, ';
11847: END IF;
11848:
11849: IF p_user_in_rec.NAME <> FND_API.G_MISS_CHAR
11850: AND NVL(p_user_in_rec.NAME,'!!!') <> NVL(p_out_rec.NAME,'!!!')
11851: THEN
11852: l_attributes := l_attributes || 'NAME, ';
11853: END IF;
11851: THEN
11852: l_attributes := l_attributes || 'NAME, ';
11853: END IF;
11854:
11855: IF p_user_in_rec.PLANNED_FLAG <> FND_API.G_MISS_CHAR
11856: AND NVL(p_user_in_rec.PLANNED_FLAG,'!!!') <> NVL(p_out_rec.PLANNED_FLAG,'!!!')
11857: THEN
11858: l_attributes := l_attributes || 'PLANNED_FLAG, ';
11859: END IF;
11857: THEN
11858: l_attributes := l_attributes || 'PLANNED_FLAG, ';
11859: END IF;
11860:
11861: IF p_user_in_rec.STATUS_CODE <> FND_API.G_MISS_CHAR
11862: AND NVL(p_user_in_rec.STATUS_CODE,'!!!') <> NVL(p_out_rec.STATUS_CODE,'!!!')
11863: THEN
11864: l_attributes := l_attributes || 'STATUS_CODE, ';
11865: END IF;
11863: THEN
11864: l_attributes := l_attributes || 'STATUS_CODE, ';
11865: END IF;
11866:
11867: IF p_user_in_rec.DELIVERY_TYPE <> FND_API.G_MISS_CHAR
11868: AND NVL(p_user_in_rec.DELIVERY_TYPE,'!!!') <> NVL(p_out_rec.DELIVERY_TYPE,'!!!')
11869: THEN
11870: l_attributes := l_attributes || 'DELIVERY_TYPE, ';
11871: END IF;
11869: THEN
11870: l_attributes := l_attributes || 'DELIVERY_TYPE, ';
11871: END IF;
11872:
11873: IF p_user_in_rec.LOADING_SEQUENCE <> FND_API.G_MISS_NUM
11874: AND NVL(p_user_in_rec.LOADING_SEQUENCE,-99) <> NVL(p_out_rec.LOADING_SEQUENCE,-99)
11875: THEN
11876: l_attributes := l_attributes || 'LOADING_SEQUENCE, ';
11877: END IF;
11875: THEN
11876: l_attributes := l_attributes || 'LOADING_SEQUENCE, ';
11877: END IF;
11878:
11879: IF p_user_in_rec.LOADING_ORDER_FLAG <> FND_API.G_MISS_CHAR
11880: AND NVL(p_user_in_rec.LOADING_ORDER_FLAG,'!!!') <> NVL(p_out_rec.LOADING_ORDER_FLAG,'!!!')
11881: THEN
11882: l_attributes := l_attributes || 'LOADING_ORDER_FLAG, ';
11883: END IF;
11881: THEN
11882: l_attributes := l_attributes || 'LOADING_ORDER_FLAG, ';
11883: END IF;
11884:
11885: IF p_user_in_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE
11886: AND NVL(p_user_in_rec.INITIAL_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.INITIAL_PICKUP_DATE,TO_DATE('2','j'))
11887: THEN
11888: l_attributes := l_attributes || 'INITIAL_PICKUP_DATE, ';
11889: END IF;
11887: THEN
11888: l_attributes := l_attributes || 'INITIAL_PICKUP_DATE, ';
11889: END IF;
11890:
11891: IF p_user_in_rec.INITIAL_PICKUP_LOCATION_ID <> FND_API.G_MISS_NUM
11892: AND NVL(p_user_in_rec.INITIAL_PICKUP_LOCATION_ID,-99) <> NVL(p_out_rec.INITIAL_PICKUP_LOCATION_ID,-99)
11893: THEN
11894: l_attributes := l_attributes || 'INITIAL_PICKUP_LOCATION_ID, ';
11895: END IF;
11893: THEN
11894: l_attributes := l_attributes || 'INITIAL_PICKUP_LOCATION_ID, ';
11895: END IF;
11896:
11897: IF p_user_in_rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM
11898: AND NVL(p_user_in_rec.ORGANIZATION_ID,-99) <> NVL(p_out_rec.ORGANIZATION_ID,-99)
11899: THEN
11900: l_attributes := l_attributes || 'ORGANIZATION_ID, ';
11901: END IF;
11899: THEN
11900: l_attributes := l_attributes || 'ORGANIZATION_ID, ';
11901: END IF;
11902:
11903: IF p_user_in_rec.ULTIMATE_DROPOFF_LOCATION_ID <> FND_API.G_MISS_NUM
11904: AND NVL(p_user_in_rec.ULTIMATE_DROPOFF_LOCATION_ID,-99) <> NVL(p_out_rec.ULTIMATE_DROPOFF_LOCATION_ID,-99)
11905: THEN
11906: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_LOCATION_ID, ';
11907: END IF;
11905: THEN
11906: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_LOCATION_ID, ';
11907: END IF;
11908:
11909: IF p_user_in_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE
11910: AND NVL(p_user_in_rec.ULTIMATE_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.ULTIMATE_DROPOFF_DATE,TO_DATE('2','j'))
11911: THEN
11912: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_DATE, ';
11913: END IF;
11911: THEN
11912: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_DATE, ';
11913: END IF;
11914:
11915: IF p_user_in_rec.CUSTOMER_ID <> FND_API.G_MISS_NUM
11916: AND NVL(p_user_in_rec.CUSTOMER_ID,-99) <> NVL(p_out_rec.CUSTOMER_ID,-99)
11917: THEN
11918: l_attributes := l_attributes || 'CUSTOMER_ID, ';
11919: END IF;
11917: THEN
11918: l_attributes := l_attributes || 'CUSTOMER_ID, ';
11919: END IF;
11920:
11921: IF p_user_in_rec.INTMED_SHIP_TO_LOCATION_ID <> FND_API.G_MISS_NUM
11922: AND NVL(p_user_in_rec.INTMED_SHIP_TO_LOCATION_ID,-99) <> NVL(p_out_rec.INTMED_SHIP_TO_LOCATION_ID,-99)
11923: THEN
11924: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_ID, ';
11925: END IF;
11923: THEN
11924: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_ID, ';
11925: END IF;
11926:
11927: IF p_user_in_rec.POOLED_SHIP_TO_LOCATION_ID <> FND_API.G_MISS_NUM
11928: AND NVL(p_user_in_rec.POOLED_SHIP_TO_LOCATION_ID,-99) <> NVL(p_out_rec.POOLED_SHIP_TO_LOCATION_ID,-99)
11929: THEN
11930: l_attributes := l_attributes || 'POOLED_SHIP_TO_LOCATION_ID, ';
11931: END IF;
11929: THEN
11930: l_attributes := l_attributes || 'POOLED_SHIP_TO_LOCATION_ID, ';
11931: END IF;
11932:
11933: IF p_user_in_rec.CARRIER_ID <> FND_API.G_MISS_NUM
11934: AND NVL(p_user_in_rec.CARRIER_ID,-99) <> NVL(p_out_rec.CARRIER_ID,-99)
11935: THEN
11936: l_attributes := l_attributes || 'CARRIER_ID, ';
11937: END IF;
11935: THEN
11936: l_attributes := l_attributes || 'CARRIER_ID, ';
11937: END IF;
11938:
11939: IF p_user_in_rec.SHIP_METHOD_CODE <> FND_API.G_MISS_CHAR
11940: AND NVL(p_user_in_rec.SHIP_METHOD_CODE,'!!!') <> NVL(p_out_rec.SHIP_METHOD_CODE,'!!!')
11941: THEN
11942: l_attributes := l_attributes || 'SHIP_METHOD_CODE, ';
11943: END IF;
11941: THEN
11942: l_attributes := l_attributes || 'SHIP_METHOD_CODE, ';
11943: END IF;
11944:
11945: IF p_user_in_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
11946: AND NVL(p_user_in_rec.FREIGHT_TERMS_CODE,'!!!') <> NVL(p_out_rec.FREIGHT_TERMS_CODE,'!!!')
11947: THEN
11948: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE, ';
11949: END IF;
11947: THEN
11948: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE, ';
11949: END IF;
11950:
11951: IF p_user_in_rec.FOB_CODE <> FND_API.G_MISS_CHAR
11952: AND NVL(p_user_in_rec.FOB_CODE,'!!!') <> NVL(p_out_rec.FOB_CODE,'!!!')
11953: THEN
11954: l_attributes := l_attributes || 'FOB_CODE, ';
11955: END IF;
11953: THEN
11954: l_attributes := l_attributes || 'FOB_CODE, ';
11955: END IF;
11956:
11957: IF p_user_in_rec.FOB_LOCATION_ID <> FND_API.G_MISS_NUM
11958: AND NVL(p_user_in_rec.FOB_LOCATION_ID,-99) <> NVL(p_out_rec.FOB_LOCATION_ID,-99)
11959: THEN
11960: l_attributes := l_attributes || 'FOB_LOCATION_ID, ';
11961: END IF;
11959: THEN
11960: l_attributes := l_attributes || 'FOB_LOCATION_ID, ';
11961: END IF;
11962:
11963: IF p_user_in_rec.WAYBILL <> FND_API.G_MISS_CHAR
11964: AND NVL(p_user_in_rec.WAYBILL,'!!!') <> NVL(p_out_rec.WAYBILL,'!!!')
11965: THEN
11966: l_attributes := l_attributes || 'WAYBILL, ';
11967: END IF;
11965: THEN
11966: l_attributes := l_attributes || 'WAYBILL, ';
11967: END IF;
11968:
11969: IF p_user_in_rec.DOCK_CODE <> FND_API.G_MISS_CHAR
11970: AND NVL(p_user_in_rec.DOCK_CODE,'!!!') <> NVL(p_out_rec.DOCK_CODE,'!!!')
11971: THEN
11972: l_attributes := l_attributes || 'DOCK_CODE, ';
11973: END IF;
11971: THEN
11972: l_attributes := l_attributes || 'DOCK_CODE, ';
11973: END IF;
11974:
11975: IF p_user_in_rec.ACCEPTANCE_FLAG <> FND_API.G_MISS_CHAR
11976: AND NVL(p_user_in_rec.ACCEPTANCE_FLAG,'!!!') <> NVL(p_out_rec.ACCEPTANCE_FLAG,'!!!')
11977: THEN
11978: l_attributes := l_attributes || 'ACCEPTANCE_FLAG, ';
11979: END IF;
11977: THEN
11978: l_attributes := l_attributes || 'ACCEPTANCE_FLAG, ';
11979: END IF;
11980:
11981: IF p_user_in_rec.ACCEPTED_BY <> FND_API.G_MISS_CHAR
11982: AND NVL(p_user_in_rec.ACCEPTED_BY,'!!!') <> NVL(p_out_rec.ACCEPTED_BY,'!!!')
11983: THEN
11984: l_attributes := l_attributes || 'ACCEPTED_BY, ';
11985: END IF;
11983: THEN
11984: l_attributes := l_attributes || 'ACCEPTED_BY, ';
11985: END IF;
11986:
11987: IF p_user_in_rec.ACCEPTED_DATE <> FND_API.G_MISS_DATE
11988: AND NVL(p_user_in_rec.ACCEPTED_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.ACCEPTED_DATE,TO_DATE('2','j'))
11989: THEN
11990: l_attributes := l_attributes || 'ACCEPTED_DATE, ';
11991: END IF;
11989: THEN
11990: l_attributes := l_attributes || 'ACCEPTED_DATE, ';
11991: END IF;
11992:
11993: IF p_user_in_rec.ACKNOWLEDGED_BY <> FND_API.G_MISS_CHAR
11994: AND NVL(p_user_in_rec.ACKNOWLEDGED_BY,'!!!') <> NVL(p_out_rec.ACKNOWLEDGED_BY,'!!!')
11995: THEN
11996: l_attributes := l_attributes || 'ACKNOWLEDGED_BY, ';
11997: END IF;
11995: THEN
11996: l_attributes := l_attributes || 'ACKNOWLEDGED_BY, ';
11997: END IF;
11998:
11999: IF p_user_in_rec.CONFIRMED_BY <> FND_API.G_MISS_CHAR
12000: AND NVL(p_user_in_rec.CONFIRMED_BY,'!!!') <> NVL(p_out_rec.CONFIRMED_BY,'!!!')
12001: THEN
12002: l_attributes := l_attributes || 'CONFIRMED_BY, ';
12003: END IF;
12001: THEN
12002: l_attributes := l_attributes || 'CONFIRMED_BY, ';
12003: END IF;
12004:
12005: IF p_user_in_rec.CONFIRM_DATE <> FND_API.G_MISS_DATE
12006: AND NVL(p_user_in_rec.CONFIRM_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CONFIRM_DATE,TO_DATE('2','j'))
12007: THEN
12008: l_attributes := l_attributes || 'CONFIRM_DATE, ';
12009: END IF;
12007: THEN
12008: l_attributes := l_attributes || 'CONFIRM_DATE, ';
12009: END IF;
12010:
12011: IF p_user_in_rec.ASN_DATE_SENT <> FND_API.G_MISS_DATE
12012: AND NVL(p_user_in_rec.ASN_DATE_SENT,TO_DATE('2','j')) <> NVL(p_out_rec.ASN_DATE_SENT,TO_DATE('2','j'))
12013: THEN
12014: l_attributes := l_attributes || 'ASN_DATE_SENT, ';
12015: END IF;
12013: THEN
12014: l_attributes := l_attributes || 'ASN_DATE_SENT, ';
12015: END IF;
12016:
12017: IF p_user_in_rec.ASN_STATUS_CODE <> FND_API.G_MISS_CHAR
12018: AND NVL(p_user_in_rec.ASN_STATUS_CODE,'!!!') <> NVL(p_out_rec.ASN_STATUS_CODE,'!!!')
12019: THEN
12020: l_attributes := l_attributes || 'ASN_STATUS_CODE, ';
12021: END IF;
12019: THEN
12020: l_attributes := l_attributes || 'ASN_STATUS_CODE, ';
12021: END IF;
12022:
12023: IF p_user_in_rec.ASN_SEQ_NUMBER <> FND_API.G_MISS_NUM
12024: AND NVL(p_user_in_rec.ASN_SEQ_NUMBER,-99) <> NVL(p_out_rec.ASN_SEQ_NUMBER,-99)
12025: THEN
12026: l_attributes := l_attributes || 'ASN_SEQ_NUMBER, ';
12027: END IF;
12025: THEN
12026: l_attributes := l_attributes || 'ASN_SEQ_NUMBER, ';
12027: END IF;
12028:
12029: IF p_user_in_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
12030: AND NVL(p_user_in_rec.GROSS_WEIGHT,-99) <> NVL(p_out_rec.GROSS_WEIGHT,-99)
12031: THEN
12032: l_attributes := l_attributes || 'GROSS_WEIGHT, ';
12033: END IF;
12031: THEN
12032: l_attributes := l_attributes || 'GROSS_WEIGHT, ';
12033: END IF;
12034:
12035: IF p_user_in_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
12036: AND NVL(p_user_in_rec.NET_WEIGHT,-99) <> NVL(p_out_rec.NET_WEIGHT,-99)
12037: THEN
12038: l_attributes := l_attributes || 'NET_WEIGHT, ';
12039: END IF;
12037: THEN
12038: l_attributes := l_attributes || 'NET_WEIGHT, ';
12039: END IF;
12040: -- Non Database field prorate_wt_flag added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
12041: IF p_user_in_rec.PRORATE_WT_FLAG <> FND_API.G_MISS_CHAR
12042: AND NVL(p_user_in_rec.PRORATE_WT_FLAG,'!!!') <> NVL(p_out_rec.PRORATE_WT_FLAG,'!!!')
12043: THEN
12044: l_attributes := l_attributes || 'PRORATE_WT_FLAG, ';
12045: END IF;
12043: THEN
12044: l_attributes := l_attributes || 'PRORATE_WT_FLAG, ';
12045: END IF;
12046: --
12047: IF p_user_in_rec.WEIGHT_UOM_CODE <> FND_API.G_MISS_CHAR
12048: AND NVL(p_user_in_rec.WEIGHT_UOM_CODE,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_CODE,'!!!')
12049: THEN
12050: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
12051: END IF;
12049: THEN
12050: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
12051: END IF;
12052:
12053: IF p_user_in_rec.VOLUME <> FND_API.G_MISS_NUM
12054: AND NVL(p_user_in_rec.VOLUME,-99) <> NVL(p_out_rec.VOLUME,-99)
12055: THEN
12056: l_attributes := l_attributes || 'VOLUME, ';
12057: END IF;
12055: THEN
12056: l_attributes := l_attributes || 'VOLUME, ';
12057: END IF;
12058:
12059: IF p_user_in_rec.VOLUME_UOM_CODE <> FND_API.G_MISS_CHAR
12060: AND NVL(p_user_in_rec.VOLUME_UOM_CODE,'!!!') <> NVL(p_out_rec.VOLUME_UOM_CODE,'!!!')
12061: THEN
12062: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
12063: END IF;
12061: THEN
12062: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
12063: END IF;
12064:
12065: IF p_user_in_rec.ADDITIONAL_SHIPMENT_INFO <> FND_API.G_MISS_CHAR
12066: AND NVL(p_user_in_rec.ADDITIONAL_SHIPMENT_INFO,'!!!') <> NVL(p_out_rec.ADDITIONAL_SHIPMENT_INFO,'!!!')
12067: THEN
12068: l_attributes := l_attributes || 'ADDITIONAL_SHIPMENT_INFO, ';
12069: END IF;
12067: THEN
12068: l_attributes := l_attributes || 'ADDITIONAL_SHIPMENT_INFO, ';
12069: END IF;
12070:
12071: IF p_user_in_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR
12072: AND NVL(p_user_in_rec.CURRENCY_CODE,'!!!') <> NVL(p_out_rec.CURRENCY_CODE,'!!!')
12073: THEN
12074: l_attributes := l_attributes || 'CURRENCY_CODE, ';
12075: END IF;
12073: THEN
12074: l_attributes := l_attributes || 'CURRENCY_CODE, ';
12075: END IF;
12076:
12077: IF p_user_in_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
12078: AND NVL(p_user_in_rec.ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.ATTRIBUTE_CATEGORY,'!!!')
12079: THEN
12080: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
12081: END IF;
12079: THEN
12080: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
12081: END IF;
12082:
12083: IF p_user_in_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
12084: AND NVL(p_user_in_rec.ATTRIBUTE1,'!!!') <> NVL(p_out_rec.ATTRIBUTE1,'!!!')
12085: THEN
12086: l_attributes := l_attributes || 'ATTRIBUTE1, ';
12087: END IF;
12085: THEN
12086: l_attributes := l_attributes || 'ATTRIBUTE1, ';
12087: END IF;
12088:
12089: IF p_user_in_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
12090: AND NVL(p_user_in_rec.ATTRIBUTE2,'!!!') <> NVL(p_out_rec.ATTRIBUTE2,'!!!')
12091: THEN
12092: l_attributes := l_attributes || 'ATTRIBUTE2, ';
12093: END IF;
12091: THEN
12092: l_attributes := l_attributes || 'ATTRIBUTE2, ';
12093: END IF;
12094:
12095: IF p_user_in_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
12096: AND NVL(p_user_in_rec.ATTRIBUTE3,'!!!') <> NVL(p_out_rec.ATTRIBUTE3,'!!!')
12097: THEN
12098: l_attributes := l_attributes || 'ATTRIBUTE3, ';
12099: END IF;
12097: THEN
12098: l_attributes := l_attributes || 'ATTRIBUTE3, ';
12099: END IF;
12100:
12101: IF p_user_in_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
12102: AND NVL(p_user_in_rec.ATTRIBUTE4,'!!!') <> NVL(p_out_rec.ATTRIBUTE4,'!!!')
12103: THEN
12104: l_attributes := l_attributes || 'ATTRIBUTE4, ';
12105: END IF;
12103: THEN
12104: l_attributes := l_attributes || 'ATTRIBUTE4, ';
12105: END IF;
12106:
12107: IF p_user_in_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
12108: AND NVL(p_user_in_rec.ATTRIBUTE5,'!!!') <> NVL(p_out_rec.ATTRIBUTE5,'!!!')
12109: THEN
12110: l_attributes := l_attributes || 'ATTRIBUTE5, ';
12111: END IF;
12109: THEN
12110: l_attributes := l_attributes || 'ATTRIBUTE5, ';
12111: END IF;
12112:
12113: IF p_user_in_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
12114: AND NVL(p_user_in_rec.ATTRIBUTE6,'!!!') <> NVL(p_out_rec.ATTRIBUTE6,'!!!')
12115: THEN
12116: l_attributes := l_attributes || 'ATTRIBUTE6, ';
12117: END IF;
12115: THEN
12116: l_attributes := l_attributes || 'ATTRIBUTE6, ';
12117: END IF;
12118:
12119: IF p_user_in_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
12120: AND NVL(p_user_in_rec.ATTRIBUTE7,'!!!') <> NVL(p_out_rec.ATTRIBUTE7,'!!!')
12121: THEN
12122: l_attributes := l_attributes || 'ATTRIBUTE7, ';
12123: END IF;
12121: THEN
12122: l_attributes := l_attributes || 'ATTRIBUTE7, ';
12123: END IF;
12124:
12125: IF p_user_in_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
12126: AND NVL(p_user_in_rec.ATTRIBUTE8,'!!!') <> NVL(p_out_rec.ATTRIBUTE8,'!!!')
12127: THEN
12128: l_attributes := l_attributes || 'ATTRIBUTE8, ';
12129: END IF;
12127: THEN
12128: l_attributes := l_attributes || 'ATTRIBUTE8, ';
12129: END IF;
12130:
12131: IF p_user_in_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
12132: AND NVL(p_user_in_rec.ATTRIBUTE9,'!!!') <> NVL(p_out_rec.ATTRIBUTE9,'!!!')
12133: THEN
12134: l_attributes := l_attributes || 'ATTRIBUTE9, ';
12135: END IF;
12133: THEN
12134: l_attributes := l_attributes || 'ATTRIBUTE9, ';
12135: END IF;
12136:
12137: IF p_user_in_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
12138: AND NVL(p_user_in_rec.ATTRIBUTE10,'!!!') <> NVL(p_out_rec.ATTRIBUTE10,'!!!')
12139: THEN
12140: l_attributes := l_attributes || 'ATTRIBUTE10, ';
12141: END IF;
12139: THEN
12140: l_attributes := l_attributes || 'ATTRIBUTE10, ';
12141: END IF;
12142:
12143: IF p_user_in_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
12144: AND NVL(p_user_in_rec.ATTRIBUTE11,'!!!') <> NVL(p_out_rec.ATTRIBUTE11,'!!!')
12145: THEN
12146: l_attributes := l_attributes || 'ATTRIBUTE11, ';
12147: END IF;
12145: THEN
12146: l_attributes := l_attributes || 'ATTRIBUTE11, ';
12147: END IF;
12148:
12149: IF p_user_in_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
12150: AND NVL(p_user_in_rec.ATTRIBUTE12,'!!!') <> NVL(p_out_rec.ATTRIBUTE12,'!!!')
12151: THEN
12152: l_attributes := l_attributes || 'ATTRIBUTE12, ';
12153: END IF;
12151: THEN
12152: l_attributes := l_attributes || 'ATTRIBUTE12, ';
12153: END IF;
12154:
12155: IF p_user_in_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
12156: AND NVL(p_user_in_rec.ATTRIBUTE13,'!!!') <> NVL(p_out_rec.ATTRIBUTE13,'!!!')
12157: THEN
12158: l_attributes := l_attributes || 'ATTRIBUTE13, ';
12159: END IF;
12157: THEN
12158: l_attributes := l_attributes || 'ATTRIBUTE13, ';
12159: END IF;
12160:
12161: IF p_user_in_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
12162: AND NVL(p_user_in_rec.ATTRIBUTE14,'!!!') <> NVL(p_out_rec.ATTRIBUTE14,'!!!')
12163: THEN
12164: l_attributes := l_attributes || 'ATTRIBUTE14, ';
12165: END IF;
12163: THEN
12164: l_attributes := l_attributes || 'ATTRIBUTE14, ';
12165: END IF;
12166:
12167: IF p_user_in_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
12168: AND NVL(p_user_in_rec.ATTRIBUTE15,'!!!') <> NVL(p_out_rec.ATTRIBUTE15,'!!!')
12169: THEN
12170: l_attributes := l_attributes || 'ATTRIBUTE15, ';
12171: END IF;
12169: THEN
12170: l_attributes := l_attributes || 'ATTRIBUTE15, ';
12171: END IF;
12172:
12173: IF p_user_in_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
12174: AND NVL(p_user_in_rec.TP_ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE_CATEGORY,'!!!')
12175: THEN
12176: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
12177: END IF;
12175: THEN
12176: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
12177: END IF;
12178:
12179: IF p_user_in_rec.TP_ATTRIBUTE1 <> FND_API.G_MISS_CHAR
12180: AND NVL(p_user_in_rec.TP_ATTRIBUTE1,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE1,'!!!')
12181: THEN
12182: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
12183: END IF;
12181: THEN
12182: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
12183: END IF;
12184:
12185: IF p_user_in_rec.TP_ATTRIBUTE2 <> FND_API.G_MISS_CHAR
12186: AND NVL(p_user_in_rec.TP_ATTRIBUTE2,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE2,'!!!')
12187: THEN
12188: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
12189: END IF;
12187: THEN
12188: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
12189: END IF;
12190:
12191: IF p_user_in_rec.TP_ATTRIBUTE3 <> FND_API.G_MISS_CHAR
12192: AND NVL(p_user_in_rec.TP_ATTRIBUTE3,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE3,'!!!')
12193: THEN
12194: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
12195: END IF;
12193: THEN
12194: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
12195: END IF;
12196:
12197: IF p_user_in_rec.TP_ATTRIBUTE4 <> FND_API.G_MISS_CHAR
12198: AND NVL(p_user_in_rec.TP_ATTRIBUTE4,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE4,'!!!')
12199: THEN
12200: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
12201: END IF;
12199: THEN
12200: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
12201: END IF;
12202:
12203: IF p_user_in_rec.TP_ATTRIBUTE5 <> FND_API.G_MISS_CHAR
12204: AND NVL(p_user_in_rec.TP_ATTRIBUTE5,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE5,'!!!')
12205: THEN
12206: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
12207: END IF;
12205: THEN
12206: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
12207: END IF;
12208:
12209: IF p_user_in_rec.TP_ATTRIBUTE6 <> FND_API.G_MISS_CHAR
12210: AND NVL(p_user_in_rec.TP_ATTRIBUTE6,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE6,'!!!')
12211: THEN
12212: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
12213: END IF;
12211: THEN
12212: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
12213: END IF;
12214:
12215: IF p_user_in_rec.TP_ATTRIBUTE7 <> FND_API.G_MISS_CHAR
12216: AND NVL(p_user_in_rec.TP_ATTRIBUTE7,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE7,'!!!')
12217: THEN
12218: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
12219: END IF;
12217: THEN
12218: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
12219: END IF;
12220:
12221: IF p_user_in_rec.TP_ATTRIBUTE8 <> FND_API.G_MISS_CHAR
12222: AND NVL(p_user_in_rec.TP_ATTRIBUTE8,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE8,'!!!')
12223: THEN
12224: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
12225: END IF;
12223: THEN
12224: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
12225: END IF;
12226:
12227: IF p_user_in_rec.TP_ATTRIBUTE9 <> FND_API.G_MISS_CHAR
12228: AND NVL(p_user_in_rec.TP_ATTRIBUTE9,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE9,'!!!')
12229: THEN
12230: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
12231: END IF;
12229: THEN
12230: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
12231: END IF;
12232:
12233: IF p_user_in_rec.TP_ATTRIBUTE10 <> FND_API.G_MISS_CHAR
12234: AND NVL(p_user_in_rec.TP_ATTRIBUTE10,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE10,'!!!')
12235: THEN
12236: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
12237: END IF;
12235: THEN
12236: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
12237: END IF;
12238:
12239: IF p_user_in_rec.TP_ATTRIBUTE11 <> FND_API.G_MISS_CHAR
12240: AND NVL(p_user_in_rec.TP_ATTRIBUTE11,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE11,'!!!')
12241: THEN
12242: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
12243: END IF;
12241: THEN
12242: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
12243: END IF;
12244:
12245: IF p_user_in_rec.TP_ATTRIBUTE12 <> FND_API.G_MISS_CHAR
12246: AND NVL(p_user_in_rec.TP_ATTRIBUTE12,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE12,'!!!')
12247: THEN
12248: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
12249: END IF;
12247: THEN
12248: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
12249: END IF;
12250:
12251: IF p_user_in_rec.TP_ATTRIBUTE13 <> FND_API.G_MISS_CHAR
12252: AND NVL(p_user_in_rec.TP_ATTRIBUTE13,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE13,'!!!')
12253: THEN
12254: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
12255: END IF;
12253: THEN
12254: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
12255: END IF;
12256:
12257: IF p_user_in_rec.TP_ATTRIBUTE14 <> FND_API.G_MISS_CHAR
12258: AND NVL(p_user_in_rec.TP_ATTRIBUTE14,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE14,'!!!')
12259: THEN
12260: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
12261: END IF;
12259: THEN
12260: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
12261: END IF;
12262:
12263: IF p_user_in_rec.TP_ATTRIBUTE15 <> FND_API.G_MISS_CHAR
12264: AND NVL(p_user_in_rec.TP_ATTRIBUTE15,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE15,'!!!')
12265: THEN
12266: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
12267: END IF;
12265: THEN
12266: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
12267: END IF;
12268:
12269: IF p_user_in_rec.GLOBAL_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
12270: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE_CATEGORY,'!!!')
12271: THEN
12272: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE_CATEGORY, ';
12273: END IF;
12271: THEN
12272: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE_CATEGORY, ';
12273: END IF;
12274:
12275: IF p_user_in_rec.GLOBAL_ATTRIBUTE1 <> FND_API.G_MISS_CHAR
12276: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE1,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE1,'!!!')
12277: THEN
12278: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE1, ';
12279: END IF;
12277: THEN
12278: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE1, ';
12279: END IF;
12280:
12281: IF p_user_in_rec.GLOBAL_ATTRIBUTE2 <> FND_API.G_MISS_CHAR
12282: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE2,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE2,'!!!')
12283: THEN
12284: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE2, ';
12285: END IF;
12283: THEN
12284: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE2, ';
12285: END IF;
12286:
12287: IF p_user_in_rec.GLOBAL_ATTRIBUTE3 <> FND_API.G_MISS_CHAR
12288: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE3,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE3,'!!!')
12289: THEN
12290: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE3, ';
12291: END IF;
12289: THEN
12290: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE3, ';
12291: END IF;
12292:
12293: IF p_user_in_rec.GLOBAL_ATTRIBUTE4 <> FND_API.G_MISS_CHAR
12294: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE4,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE4,'!!!')
12295: THEN
12296: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE4, ';
12297: END IF;
12295: THEN
12296: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE4, ';
12297: END IF;
12298:
12299: IF p_user_in_rec.GLOBAL_ATTRIBUTE5 <> FND_API.G_MISS_CHAR
12300: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE5,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE5,'!!!')
12301: THEN
12302: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE5, ';
12303: END IF;
12301: THEN
12302: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE5, ';
12303: END IF;
12304:
12305: IF p_user_in_rec.GLOBAL_ATTRIBUTE6 <> FND_API.G_MISS_CHAR
12306: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE6,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE6,'!!!')
12307: THEN
12308: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE6, ';
12309: END IF;
12307: THEN
12308: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE6, ';
12309: END IF;
12310:
12311: IF p_user_in_rec.GLOBAL_ATTRIBUTE7 <> FND_API.G_MISS_CHAR
12312: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE7,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE7,'!!!')
12313: THEN
12314: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE7, ';
12315: END IF;
12313: THEN
12314: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE7, ';
12315: END IF;
12316:
12317: IF p_user_in_rec.GLOBAL_ATTRIBUTE8 <> FND_API.G_MISS_CHAR
12318: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE8,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE8,'!!!')
12319: THEN
12320: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE8, ';
12321: END IF;
12319: THEN
12320: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE8, ';
12321: END IF;
12322:
12323: IF p_user_in_rec.GLOBAL_ATTRIBUTE9 <> FND_API.G_MISS_CHAR
12324: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE9,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE9,'!!!')
12325: THEN
12326: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE9, ';
12327: END IF;
12325: THEN
12326: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE9, ';
12327: END IF;
12328:
12329: IF p_user_in_rec.GLOBAL_ATTRIBUTE10 <> FND_API.G_MISS_CHAR
12330: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE10,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE10,'!!!')
12331: THEN
12332: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE10, ';
12333: END IF;
12331: THEN
12332: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE10, ';
12333: END IF;
12334:
12335: IF p_user_in_rec.GLOBAL_ATTRIBUTE11 <> FND_API.G_MISS_CHAR
12336: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE11,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE11,'!!!')
12337: THEN
12338: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE11, ';
12339: END IF;
12337: THEN
12338: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE11, ';
12339: END IF;
12340:
12341: IF p_user_in_rec.GLOBAL_ATTRIBUTE12 <> FND_API.G_MISS_CHAR
12342: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE12,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE12,'!!!')
12343: THEN
12344: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE12, ';
12345: END IF;
12343: THEN
12344: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE12, ';
12345: END IF;
12346:
12347: IF p_user_in_rec.GLOBAL_ATTRIBUTE13 <> FND_API.G_MISS_CHAR
12348: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE13,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE13,'!!!')
12349: THEN
12350: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE13, ';
12351: END IF;
12349: THEN
12350: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE13, ';
12351: END IF;
12352:
12353: IF p_user_in_rec.GLOBAL_ATTRIBUTE14 <> FND_API.G_MISS_CHAR
12354: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE14,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE14,'!!!')
12355: THEN
12356: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE14, ';
12357: END IF;
12355: THEN
12356: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE14, ';
12357: END IF;
12358:
12359: IF p_user_in_rec.GLOBAL_ATTRIBUTE15 <> FND_API.G_MISS_CHAR
12360: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE15,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE15,'!!!')
12361: THEN
12362: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE15, ';
12363: END IF;
12361: THEN
12362: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE15, ';
12363: END IF;
12364:
12365: IF p_user_in_rec.GLOBAL_ATTRIBUTE16 <> FND_API.G_MISS_CHAR
12366: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE16,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE16,'!!!')
12367: THEN
12368: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE16, ';
12369: END IF;
12367: THEN
12368: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE16, ';
12369: END IF;
12370:
12371: IF p_user_in_rec.GLOBAL_ATTRIBUTE17 <> FND_API.G_MISS_CHAR
12372: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE17,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE17,'!!!')
12373: THEN
12374: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE17, ';
12375: END IF;
12373: THEN
12374: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE17, ';
12375: END IF;
12376:
12377: IF p_user_in_rec.GLOBAL_ATTRIBUTE18 <> FND_API.G_MISS_CHAR
12378: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE18,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE18,'!!!')
12379: THEN
12380: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE18, ';
12381: END IF;
12379: THEN
12380: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE18, ';
12381: END IF;
12382:
12383: IF p_user_in_rec.GLOBAL_ATTRIBUTE19 <> FND_API.G_MISS_CHAR
12384: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE19,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE19,'!!!')
12385: THEN
12386: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE19, ';
12387: END IF;
12385: THEN
12386: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE19, ';
12387: END IF;
12388:
12389: IF p_user_in_rec.GLOBAL_ATTRIBUTE20 <> FND_API.G_MISS_CHAR
12390: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE20,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE20,'!!!')
12391: THEN
12392: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE20, ';
12393: END IF;
12394:
12395: /**
12396: -- Bug 3613650 - Need not compare standard WHO columns
12397: --
12398: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE
12399: AND NVL(p_user_in_rec.CREATION_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CREATION_DATE,TO_DATE('2','j'))
12400: THEN
12401: l_attributes := l_attributes || 'CREATION_DATE, ';
12402: END IF;
12400: THEN
12401: l_attributes := l_attributes || 'CREATION_DATE, ';
12402: END IF;
12403:
12404: IF p_user_in_rec.CREATED_BY <> FND_API.G_MISS_NUM
12405: AND NVL(p_user_in_rec.CREATED_BY,-99) <> NVL(p_out_rec.CREATED_BY,-99)
12406: THEN
12407: l_attributes := l_attributes || 'CREATED_BY, ';
12408: END IF;
12406: THEN
12407: l_attributes := l_attributes || 'CREATED_BY, ';
12408: END IF;
12409:
12410: IF p_user_in_rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE
12411: AND NVL(p_user_in_rec.LAST_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LAST_UPDATE_DATE,TO_DATE('2','j'))
12412: THEN
12413: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
12414: END IF;
12412: THEN
12413: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
12414: END IF;
12415:
12416: IF p_user_in_rec.LAST_UPDATED_BY <> FND_API.G_MISS_NUM
12417: AND NVL(p_user_in_rec.LAST_UPDATED_BY,-99) <> NVL(p_out_rec.LAST_UPDATED_BY,-99)
12418: THEN
12419: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
12420: END IF;
12418: THEN
12419: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
12420: END IF;
12421:
12422: IF p_user_in_rec.LAST_UPDATE_LOGIN <> FND_API.G_MISS_NUM
12423: AND NVL(p_user_in_rec.LAST_UPDATE_LOGIN,-99) <> NVL(p_out_rec.LAST_UPDATE_LOGIN,-99)
12424: THEN
12425: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
12426: END IF;
12424: THEN
12425: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
12426: END IF;
12427:
12428: IF p_user_in_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
12429: AND NVL(p_user_in_rec.PROGRAM_APPLICATION_ID,-99) <> NVL(p_out_rec.PROGRAM_APPLICATION_ID,-99)
12430: THEN
12431: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
12432: END IF;
12430: THEN
12431: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
12432: END IF;
12433:
12434: IF p_user_in_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
12435: AND NVL(p_user_in_rec.PROGRAM_ID,-99) <> NVL(p_out_rec.PROGRAM_ID,-99)
12436: THEN
12437: l_attributes := l_attributes || 'PROGRAM_ID, ';
12438: END IF;
12436: THEN
12437: l_attributes := l_attributes || 'PROGRAM_ID, ';
12438: END IF;
12439:
12440: IF p_user_in_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
12441: AND NVL(p_user_in_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j'))
12442: THEN
12443: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
12444: END IF;
12442: THEN
12443: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
12444: END IF;
12445:
12446: IF p_user_in_rec.REQUEST_ID <> FND_API.G_MISS_NUM
12447: AND NVL(p_user_in_rec.REQUEST_ID,-99) <> NVL(p_out_rec.REQUEST_ID,-99)
12448: THEN
12449: l_attributes := l_attributes || 'REQUEST_ID, ';
12450: END IF;
12449: l_attributes := l_attributes || 'REQUEST_ID, ';
12450: END IF;
12451: **/
12452:
12453: IF p_user_in_rec.BATCH_ID <> FND_API.G_MISS_NUM
12454: AND NVL(p_user_in_rec.BATCH_ID,-99) <> NVL(p_out_rec.BATCH_ID,-99)
12455: THEN
12456: l_attributes := l_attributes || 'BATCH_ID, ';
12457: END IF;
12455: THEN
12456: l_attributes := l_attributes || 'BATCH_ID, ';
12457: END IF;
12458:
12459: IF p_user_in_rec.HASH_VALUE <> FND_API.G_MISS_NUM
12460: AND NVL(p_user_in_rec.HASH_VALUE,-99) <> NVL(p_out_rec.HASH_VALUE,-99)
12461: THEN
12462: l_attributes := l_attributes || 'HASH_VALUE, ';
12463: END IF;
12461: THEN
12462: l_attributes := l_attributes || 'HASH_VALUE, ';
12463: END IF;
12464:
12465: IF p_user_in_rec.SOURCE_HEADER_ID <> FND_API.G_MISS_NUM
12466: AND NVL(p_user_in_rec.SOURCE_HEADER_ID,-99) <> NVL(p_out_rec.SOURCE_HEADER_ID,-99)
12467: THEN
12468: l_attributes := l_attributes || 'SOURCE_HEADER_ID, ';
12469: END IF;
12467: THEN
12468: l_attributes := l_attributes || 'SOURCE_HEADER_ID, ';
12469: END IF;
12470:
12471: IF p_user_in_rec.NUMBER_OF_LPN <> FND_API.G_MISS_NUM
12472: AND NVL(p_user_in_rec.NUMBER_OF_LPN,-99) <> NVL(p_out_rec.NUMBER_OF_LPN,-99)
12473: THEN
12474: l_attributes := l_attributes || 'NUMBER_OF_LPN, ';
12475: END IF;
12473: THEN
12474: l_attributes := l_attributes || 'NUMBER_OF_LPN, ';
12475: END IF;
12476:
12477: IF p_user_in_rec.COD_AMOUNT <> FND_API.G_MISS_NUM
12478: AND NVL(p_user_in_rec.COD_AMOUNT,-99) <> NVL(p_out_rec.COD_AMOUNT,-99)
12479: THEN
12480: l_attributes := l_attributes || 'COD_AMOUNT, ';
12481: END IF;
12479: THEN
12480: l_attributes := l_attributes || 'COD_AMOUNT, ';
12481: END IF;
12482:
12483: IF p_user_in_rec.COD_CURRENCY_CODE <> FND_API.G_MISS_CHAR
12484: AND NVL(p_user_in_rec.COD_CURRENCY_CODE,'!!!') <> NVL(p_out_rec.COD_CURRENCY_CODE,'!!!')
12485: THEN
12486: l_attributes := l_attributes || 'COD_CURRENCY_CODE, ';
12487: END IF;
12485: THEN
12486: l_attributes := l_attributes || 'COD_CURRENCY_CODE, ';
12487: END IF;
12488:
12489: IF p_user_in_rec.COD_REMIT_TO <> FND_API.G_MISS_CHAR
12490: AND NVL(p_user_in_rec.COD_REMIT_TO,'!!!') <> NVL(p_out_rec.COD_REMIT_TO,'!!!')
12491: THEN
12492: l_attributes := l_attributes || 'COD_REMIT_TO, ';
12493: END IF;
12491: THEN
12492: l_attributes := l_attributes || 'COD_REMIT_TO, ';
12493: END IF;
12494:
12495: IF p_user_in_rec.COD_CHARGE_PAID_BY <> FND_API.G_MISS_CHAR
12496: AND NVL(p_user_in_rec.COD_CHARGE_PAID_BY,'!!!') <> NVL(p_out_rec.COD_CHARGE_PAID_BY,'!!!')
12497: THEN
12498: l_attributes := l_attributes || 'COD_CHARGE_PAID_BY, ';
12499: END IF;
12497: THEN
12498: l_attributes := l_attributes || 'COD_CHARGE_PAID_BY, ';
12499: END IF;
12500:
12501: IF p_user_in_rec.PROBLEM_CONTACT_REFERENCE <> FND_API.G_MISS_CHAR
12502: AND NVL(p_user_in_rec.PROBLEM_CONTACT_REFERENCE,'!!!') <> NVL(p_out_rec.PROBLEM_CONTACT_REFERENCE,'!!!')
12503: THEN
12504: l_attributes := l_attributes || 'PROBLEM_CONTACT_REFERENCE, ';
12505: END IF;
12503: THEN
12504: l_attributes := l_attributes || 'PROBLEM_CONTACT_REFERENCE, ';
12505: END IF;
12506:
12507: IF p_user_in_rec.PORT_OF_LOADING <> FND_API.G_MISS_CHAR
12508: AND NVL(p_user_in_rec.PORT_OF_LOADING,'!!!') <> NVL(p_out_rec.PORT_OF_LOADING,'!!!')
12509: THEN
12510: l_attributes := l_attributes || 'PORT_OF_LOADING, ';
12511: END IF;
12509: THEN
12510: l_attributes := l_attributes || 'PORT_OF_LOADING, ';
12511: END IF;
12512:
12513: IF p_user_in_rec.PORT_OF_DISCHARGE <> FND_API.G_MISS_CHAR
12514: AND NVL(p_user_in_rec.PORT_OF_DISCHARGE,'!!!') <> NVL(p_out_rec.PORT_OF_DISCHARGE,'!!!')
12515: THEN
12516: l_attributes := l_attributes || 'PORT_OF_DISCHARGE, ';
12517: END IF;
12515: THEN
12516: l_attributes := l_attributes || 'PORT_OF_DISCHARGE, ';
12517: END IF;
12518:
12519: IF p_user_in_rec.FTZ_NUMBER <> FND_API.G_MISS_CHAR
12520: AND NVL(p_user_in_rec.FTZ_NUMBER,'!!!') <> NVL(p_out_rec.FTZ_NUMBER,'!!!')
12521: THEN
12522: l_attributes := l_attributes || 'FTZ_NUMBER, ';
12523: END IF;
12521: THEN
12522: l_attributes := l_attributes || 'FTZ_NUMBER, ';
12523: END IF;
12524:
12525: IF p_user_in_rec.ROUTED_EXPORT_TXN <> FND_API.G_MISS_CHAR
12526: AND NVL(p_user_in_rec.ROUTED_EXPORT_TXN,'!!!') <> NVL(p_out_rec.ROUTED_EXPORT_TXN,'!!!')
12527: THEN
12528: l_attributes := l_attributes || 'ROUTED_EXPORT_TXN, ';
12529: END IF;
12527: THEN
12528: l_attributes := l_attributes || 'ROUTED_EXPORT_TXN, ';
12529: END IF;
12530:
12531: IF p_user_in_rec.ENTRY_NUMBER <> FND_API.G_MISS_CHAR
12532: AND NVL(p_user_in_rec.ENTRY_NUMBER,'!!!') <> NVL(p_out_rec.ENTRY_NUMBER,'!!!')
12533: THEN
12534: l_attributes := l_attributes || 'ENTRY_NUMBER, ';
12535: END IF;
12533: THEN
12534: l_attributes := l_attributes || 'ENTRY_NUMBER, ';
12535: END IF;
12536:
12537: IF p_user_in_rec.ROUTING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
12538: AND NVL(p_user_in_rec.ROUTING_INSTRUCTIONS,'!!!') <> NVL(p_out_rec.ROUTING_INSTRUCTIONS,'!!!')
12539: THEN
12540: l_attributes := l_attributes || 'ROUTING_INSTRUCTIONS, ';
12541: END IF;
12539: THEN
12540: l_attributes := l_attributes || 'ROUTING_INSTRUCTIONS, ';
12541: END IF;
12542:
12543: IF p_user_in_rec.IN_BOND_CODE <> FND_API.G_MISS_CHAR
12544: AND NVL(p_user_in_rec.IN_BOND_CODE,'!!!') <> NVL(p_out_rec.IN_BOND_CODE,'!!!')
12545: THEN
12546: l_attributes := l_attributes || 'IN_BOND_CODE, ';
12547: END IF;
12545: THEN
12546: l_attributes := l_attributes || 'IN_BOND_CODE, ';
12547: END IF;
12548:
12549: IF p_user_in_rec.SHIPPING_MARKS <> FND_API.G_MISS_CHAR
12550: AND NVL(p_user_in_rec.SHIPPING_MARKS,'!!!') <> NVL(p_out_rec.SHIPPING_MARKS,'!!!')
12551: THEN
12552: l_attributes := l_attributes || 'SHIPPING_MARKS, ';
12553: END IF;
12551: THEN
12552: l_attributes := l_attributes || 'SHIPPING_MARKS, ';
12553: END IF;
12554:
12555: IF p_user_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
12556: AND NVL(p_user_in_rec.SERVICE_LEVEL,'!!!') <> NVL(p_out_rec.SERVICE_LEVEL,'!!!')
12557: THEN
12558: l_attributes := l_attributes || 'SERVICE_LEVEL, ';
12559: END IF;
12557: THEN
12558: l_attributes := l_attributes || 'SERVICE_LEVEL, ';
12559: END IF;
12560:
12561: IF p_user_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
12562: AND NVL(p_user_in_rec.MODE_OF_TRANSPORT,'!!!') <> NVL(p_out_rec.MODE_OF_TRANSPORT,'!!!')
12563: THEN
12564: l_attributes := l_attributes || 'MODE_OF_TRANSPORT, ';
12565: END IF;
12563: THEN
12564: l_attributes := l_attributes || 'MODE_OF_TRANSPORT, ';
12565: END IF;
12566:
12567: IF p_user_in_rec.ASSIGNED_TO_FTE_TRIPS <> FND_API.G_MISS_CHAR
12568: AND NVL(p_user_in_rec.ASSIGNED_TO_FTE_TRIPS,'!!!') <> NVL(p_out_rec.ASSIGNED_TO_FTE_TRIPS,'!!!')
12569: THEN
12570: l_attributes := l_attributes || 'ASSIGNED_TO_FTE_TRIPS, ';
12571: END IF;
12569: THEN
12570: l_attributes := l_attributes || 'ASSIGNED_TO_FTE_TRIPS, ';
12571: END IF;
12572:
12573: IF p_user_in_rec.AUTO_SC_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
12574: AND NVL(p_user_in_rec.AUTO_SC_EXCLUDE_FLAG,'!!!') <> NVL(p_out_rec.AUTO_SC_EXCLUDE_FLAG,'!!!')
12575: THEN
12576: l_attributes := l_attributes || 'AUTO_SC_EXCLUDE_FLAG, ';
12577: END IF;
12575: THEN
12576: l_attributes := l_attributes || 'AUTO_SC_EXCLUDE_FLAG, ';
12577: END IF;
12578:
12579: IF p_user_in_rec.AUTO_AP_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
12580: AND NVL(p_user_in_rec.AUTO_AP_EXCLUDE_FLAG,'!!!') <> NVL(p_out_rec.AUTO_AP_EXCLUDE_FLAG,'!!!')
12581: THEN
12582: l_attributes := l_attributes || 'AUTO_AP_EXCLUDE_FLAG, ';
12583: END IF;
12581: THEN
12582: l_attributes := l_attributes || 'AUTO_AP_EXCLUDE_FLAG, ';
12583: END IF;
12584:
12585: IF p_user_in_rec.AP_BATCH_ID <> FND_API.G_MISS_NUM
12586: AND NVL(p_user_in_rec.AP_BATCH_ID,-99) <> NVL(p_out_rec.AP_BATCH_ID,-99)
12587: THEN
12588: l_attributes := l_attributes || 'AP_BATCH_ID, ';
12589: END IF;
12587: THEN
12588: l_attributes := l_attributes || 'AP_BATCH_ID, ';
12589: END IF;
12590:
12591: IF p_user_in_rec.ROWID <> FND_API.G_MISS_CHAR
12592: AND NVL(p_user_in_rec.ROWID,'!!!') <> NVL(p_out_rec.ROWID,'!!!')
12593: THEN
12594: l_attributes := l_attributes || 'ROWID, ';
12595: END IF;
12593: THEN
12594: l_attributes := l_attributes || 'ROWID, ';
12595: END IF;
12596:
12597: IF p_user_in_rec.LOADING_ORDER_DESC <> FND_API.G_MISS_CHAR
12598: AND NVL(p_user_in_rec.LOADING_ORDER_DESC,'!!!') <> NVL(p_out_rec.LOADING_ORDER_DESC,'!!!')
12599: THEN
12600: l_attributes := l_attributes || 'LOADING_ORDER_DESC, ';
12601: END IF;
12599: THEN
12600: l_attributes := l_attributes || 'LOADING_ORDER_DESC, ';
12601: END IF;
12602:
12603: IF p_user_in_rec.ORGANIZATION_CODE <> FND_API.G_MISS_CHAR
12604: AND NVL(p_user_in_rec.ORGANIZATION_CODE,'!!!') <> NVL(p_out_rec.ORGANIZATION_CODE,'!!!')
12605: THEN
12606: l_attributes := l_attributes || 'ORGANIZATION_CODE, ';
12607: END IF;
12605: THEN
12606: l_attributes := l_attributes || 'ORGANIZATION_CODE, ';
12607: END IF;
12608:
12609: IF p_user_in_rec.ULTIMATE_DROPOFF_LOCATION_CODE <> FND_API.G_MISS_CHAR
12610: AND NVL(p_user_in_rec.ULTIMATE_DROPOFF_LOCATION_CODE,'!!!') <> NVL(p_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE,'!!!')
12611: THEN
12612: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_LOCATION_CODE, ';
12613: END IF;
12611: THEN
12612: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_LOCATION_CODE, ';
12613: END IF;
12614:
12615: IF p_user_in_rec.INITIAL_PICKUP_LOCATION_CODE <> FND_API.G_MISS_CHAR
12616: AND NVL(p_user_in_rec.INITIAL_PICKUP_LOCATION_CODE,'!!!') <> NVL(p_out_rec.INITIAL_PICKUP_LOCATION_CODE,'!!!')
12617: THEN
12618: l_attributes := l_attributes || 'INITIAL_PICKUP_LOCATION_CODE, ';
12619: END IF;
12617: THEN
12618: l_attributes := l_attributes || 'INITIAL_PICKUP_LOCATION_CODE, ';
12619: END IF;
12620:
12621: IF p_user_in_rec.CUSTOMER_NUMBER <> FND_API.G_MISS_CHAR
12622: AND NVL(p_user_in_rec.CUSTOMER_NUMBER,'!!!') <> NVL(p_out_rec.CUSTOMER_NUMBER,'!!!')
12623: THEN
12624: l_attributes := l_attributes || 'CUSTOMER_NUMBER, ';
12625: END IF;
12623: THEN
12624: l_attributes := l_attributes || 'CUSTOMER_NUMBER, ';
12625: END IF;
12626: -- LSP PROJECT
12627: IF p_user_in_rec.CLIENT_CODE <> FND_API.G_MISS_CHAR
12628: AND NVL(p_user_in_rec.CLIENT_CODE,'!!!') <> NVL(p_out_rec.CLIENT_CODE,'!!!')
12629: THEN
12630: l_attributes := l_attributes || 'CLIENT_CODE, ';
12631: END IF;
12630: l_attributes := l_attributes || 'CLIENT_CODE, ';
12631: END IF;
12632: -- LSP PROJECT.
12633:
12634: IF p_user_in_rec.INTMED_SHIP_TO_LOCATION_CODE <> FND_API.G_MISS_CHAR
12635: AND NVL(p_user_in_rec.INTMED_SHIP_TO_LOCATION_CODE,'!!!') <> NVL(p_out_rec.INTMED_SHIP_TO_LOCATION_CODE,'!!!')
12636: THEN
12637: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_CODE, ';
12638: END IF;
12636: THEN
12637: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_CODE, ';
12638: END IF;
12639:
12640: IF p_user_in_rec.POOLED_SHIP_TO_LOCATION_CODE <> FND_API.G_MISS_CHAR
12641: AND NVL(p_user_in_rec.POOLED_SHIP_TO_LOCATION_CODE,'!!!') <> NVL(p_out_rec.POOLED_SHIP_TO_LOCATION_CODE,'!!!')
12642: THEN
12643: l_attributes := l_attributes || 'POOLED_SHIP_TO_LOCATION_CODE, ';
12644: END IF;
12642: THEN
12643: l_attributes := l_attributes || 'POOLED_SHIP_TO_LOCATION_CODE, ';
12644: END IF;
12645:
12646: IF p_user_in_rec.CARRIER_CODE <> FND_API.G_MISS_CHAR
12647: AND NVL(p_user_in_rec.CARRIER_CODE,'!!!') <> NVL(p_out_rec.CARRIER_CODE,'!!!')
12648: THEN
12649: l_attributes := l_attributes || 'CARRIER_CODE, ';
12650: END IF;
12648: THEN
12649: l_attributes := l_attributes || 'CARRIER_CODE, ';
12650: END IF;
12651:
12652: IF p_user_in_rec.SHIP_METHOD_NAME <> FND_API.G_MISS_CHAR
12653: AND NVL(p_user_in_rec.SHIP_METHOD_NAME,'!!!') <> NVL(p_out_rec.SHIP_METHOD_NAME,'!!!')
12654: THEN
12655: l_attributes := l_attributes || 'SHIP_METHOD_NAME, ';
12656: END IF;
12654: THEN
12655: l_attributes := l_attributes || 'SHIP_METHOD_NAME, ';
12656: END IF;
12657:
12658: IF p_user_in_rec.FREIGHT_TERMS_NAME <> FND_API.G_MISS_CHAR
12659: AND NVL(p_user_in_rec.FREIGHT_TERMS_NAME,'!!!') <> NVL(p_out_rec.FREIGHT_TERMS_NAME,'!!!')
12660: THEN
12661: l_attributes := l_attributes || 'FREIGHT_TERMS_NAME, ';
12662: END IF;
12660: THEN
12661: l_attributes := l_attributes || 'FREIGHT_TERMS_NAME, ';
12662: END IF;
12663:
12664: IF p_user_in_rec.FOB_NAME <> FND_API.G_MISS_CHAR
12665: AND NVL(p_user_in_rec.FOB_NAME,'!!!') <> NVL(p_out_rec.FOB_NAME,'!!!')
12666: THEN
12667: l_attributes := l_attributes || 'FOB_NAME, ';
12668: END IF;
12666: THEN
12667: l_attributes := l_attributes || 'FOB_NAME, ';
12668: END IF;
12669:
12670: IF p_user_in_rec.FOB_LOCATION_CODE <> FND_API.G_MISS_CHAR
12671: AND NVL(p_user_in_rec.FOB_LOCATION_CODE,'!!!') <> NVL(p_out_rec.FOB_LOCATION_CODE,'!!!')
12672: THEN
12673: l_attributes := l_attributes || 'FOB_LOCATION_CODE, ';
12674: END IF;
12672: THEN
12673: l_attributes := l_attributes || 'FOB_LOCATION_CODE, ';
12674: END IF;
12675:
12676: IF p_user_in_rec.WEIGHT_UOM_DESC <> FND_API.G_MISS_CHAR
12677: AND NVL(p_user_in_rec.WEIGHT_UOM_DESC,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_DESC,'!!!')
12678: THEN
12679: l_attributes := l_attributes || 'WEIGHT_UOM_DESC, ';
12680: END IF;
12678: THEN
12679: l_attributes := l_attributes || 'WEIGHT_UOM_DESC, ';
12680: END IF;
12681:
12682: IF p_user_in_rec.VOLUME_UOM_DESC <> FND_API.G_MISS_CHAR
12683: AND NVL(p_user_in_rec.VOLUME_UOM_DESC,'!!!') <> NVL(p_out_rec.VOLUME_UOM_DESC,'!!!')
12684: THEN
12685: l_attributes := l_attributes || 'VOLUME_UOM_DESC, ';
12686: END IF;
12684: THEN
12685: l_attributes := l_attributes || 'VOLUME_UOM_DESC, ';
12686: END IF;
12687:
12688: IF p_user_in_rec.CURRENCY_NAME <> FND_API.G_MISS_CHAR
12689: AND NVL(p_user_in_rec.CURRENCY_NAME,'!!!') <> NVL(p_out_rec.CURRENCY_NAME,'!!!')
12690: THEN
12691: l_attributes := l_attributes || 'CURRENCY_NAME, ';
12692: END IF;
12690: THEN
12691: l_attributes := l_attributes || 'CURRENCY_NAME, ';
12692: END IF;
12693:
12694: IF p_user_in_rec.SHIPMENT_DIRECTION <> FND_API.G_MISS_CHAR
12695: AND NVL(p_user_in_rec.SHIPMENT_DIRECTION,'!!!') <> NVL(p_out_rec.SHIPMENT_DIRECTION,'!!!')
12696: THEN
12697: l_attributes := l_attributes || 'SHIPMENT_DIRECTION, ';
12698: END IF;
12696: THEN
12697: l_attributes := l_attributes || 'SHIPMENT_DIRECTION, ';
12698: END IF;
12699:
12700: IF p_user_in_rec.VENDOR_ID <> FND_API.G_MISS_NUM
12701: AND NVL(p_user_in_rec.VENDOR_ID,-99) <> NVL(p_out_rec.VENDOR_ID,-99)
12702: THEN
12703: l_attributes := l_attributes || 'VENDOR_ID, ';
12704: END IF;
12702: THEN
12703: l_attributes := l_attributes || 'VENDOR_ID, ';
12704: END IF;
12705:
12706: IF p_user_in_rec.PARTY_ID <> FND_API.G_MISS_NUM
12707: AND NVL(p_user_in_rec.PARTY_ID,-99) <> NVL(p_out_rec.PARTY_ID,-99)
12708: THEN
12709: l_attributes := l_attributes || 'PARTY_ID, ';
12710: END IF;
12708: THEN
12709: l_attributes := l_attributes || 'PARTY_ID, ';
12710: END IF;
12711:
12712: IF p_user_in_rec.ROUTING_RESPONSE_ID <> FND_API.G_MISS_NUM
12713: AND NVL(p_user_in_rec.ROUTING_RESPONSE_ID,-99) <> NVL(p_out_rec.ROUTING_RESPONSE_ID,-99)
12714: THEN
12715: l_attributes := l_attributes || 'ROUTING_RESPONSE_ID, ';
12716: END IF;
12714: THEN
12715: l_attributes := l_attributes || 'ROUTING_RESPONSE_ID, ';
12716: END IF;
12717:
12718: IF p_user_in_rec.RCV_SHIPMENT_HEADER_ID <> FND_API.G_MISS_NUM
12719: AND NVL(p_user_in_rec.RCV_SHIPMENT_HEADER_ID,-99) <> NVL(p_out_rec.RCV_SHIPMENT_HEADER_ID,-99)
12720: THEN
12721: l_attributes := l_attributes || 'RCV_SHIPMENT_HEADER_ID, ';
12722: END IF;
12720: THEN
12721: l_attributes := l_attributes || 'RCV_SHIPMENT_HEADER_ID, ';
12722: END IF;
12723:
12724: IF p_user_in_rec.ASN_SHIPMENT_HEADER_ID <> FND_API.G_MISS_NUM
12725: AND NVL(p_user_in_rec.ASN_SHIPMENT_HEADER_ID,-99) <> NVL(p_out_rec.ASN_SHIPMENT_HEADER_ID,-99)
12726: THEN
12727: l_attributes := l_attributes || 'ASN_SHIPMENT_HEADER_ID, ';
12728: END IF;
12726: THEN
12727: l_attributes := l_attributes || 'ASN_SHIPMENT_HEADER_ID, ';
12728: END IF;
12729:
12730: IF p_user_in_rec.SHIPPING_CONTROL <> FND_API.G_MISS_CHAR
12731: AND NVL(p_user_in_rec.SHIPPING_CONTROL,'!!!') <> NVL(p_out_rec.SHIPPING_CONTROL,'!!!')
12732: THEN
12733: l_attributes := l_attributes || 'SHIPPING_CONTROL, ';
12734: END IF;
12732: THEN
12733: l_attributes := l_attributes || 'SHIPPING_CONTROL, ';
12734: END IF;
12735:
12736: IF p_user_in_rec.TP_DELIVERY_NUMBER <> FND_API.G_MISS_NUM
12737: AND NVL(p_user_in_rec.TP_DELIVERY_NUMBER,-99) <> NVL(p_out_rec.TP_DELIVERY_NUMBER,-99)
12738: THEN
12739: l_attributes := l_attributes || 'TP_DELIVERY_NUMBER, ';
12740: END IF;
12738: THEN
12739: l_attributes := l_attributes || 'TP_DELIVERY_NUMBER, ';
12740: END IF;
12741:
12742: IF p_user_in_rec.EARLIEST_PICKUP_DATE <> FND_API.G_MISS_DATE
12743: AND NVL(p_user_in_rec.EARLIEST_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.EARLIEST_PICKUP_DATE,TO_DATE('2','j'))
12744: THEN
12745: l_attributes := l_attributes || 'EARLIEST_PICKUP_DATE, ';
12746: END IF;
12744: THEN
12745: l_attributes := l_attributes || 'EARLIEST_PICKUP_DATE, ';
12746: END IF;
12747:
12748: IF p_user_in_rec.LATEST_PICKUP_DATE <> FND_API.G_MISS_DATE
12749: AND NVL(p_user_in_rec.LATEST_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LATEST_PICKUP_DATE,TO_DATE('2','j'))
12750: THEN
12751: l_attributes := l_attributes || 'LATEST_PICKUP_DATE, ';
12752: END IF;
12750: THEN
12751: l_attributes := l_attributes || 'LATEST_PICKUP_DATE, ';
12752: END IF;
12753:
12754: IF p_user_in_rec.EARLIEST_DROPOFF_DATE <> FND_API.G_MISS_DATE
12755: AND NVL(p_user_in_rec.EARLIEST_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.EARLIEST_DROPOFF_DATE,TO_DATE('2','j'))
12756: THEN
12757: l_attributes := l_attributes || 'EARLIEST_DROPOFF_DATE, ';
12758: END IF;
12756: THEN
12757: l_attributes := l_attributes || 'EARLIEST_DROPOFF_DATE, ';
12758: END IF;
12759:
12760: IF p_user_in_rec.LATEST_DROPOFF_DATE <> FND_API.G_MISS_DATE
12761: AND NVL(p_user_in_rec.LATEST_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LATEST_DROPOFF_DATE,TO_DATE('2','j'))
12762: THEN
12763: l_attributes := l_attributes || 'LATEST_DROPOFF_DATE, ';
12764: END IF;
12762: THEN
12763: l_attributes := l_attributes || 'LATEST_DROPOFF_DATE, ';
12764: END IF;
12765:
12766: IF p_user_in_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR
12767: AND NVL(p_user_in_rec.IGNORE_FOR_PLANNING,'!!!') <> NVL(p_out_rec.IGNORE_FOR_PLANNING,'!!!')
12768: THEN
12769: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING, ';
12770: END IF;
12768: THEN
12769: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING, ';
12770: END IF;
12771:
12772: IF p_user_in_rec.TP_PLAN_NAME <> FND_API.G_MISS_CHAR
12773: AND NVL(p_user_in_rec.TP_PLAN_NAME,'!!!') <> NVL(p_out_rec.TP_PLAN_NAME,'!!!')
12774: THEN
12775: l_attributes := l_attributes || 'TP_PLAN_NAME, ';
12776: END IF;
12774: THEN
12775: l_attributes := l_attributes || 'TP_PLAN_NAME, ';
12776: END IF;
12777:
12778: IF p_user_in_rec.WV_FROZEN_FLAG <> FND_API.G_MISS_CHAR
12779: AND NVL(p_user_in_rec.WV_FROZEN_FLAG,'!!!') <> NVL(p_out_rec.WV_FROZEN_FLAG,'!!!')
12780: THEN
12781: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
12782: END IF;
12780: THEN
12781: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
12782: END IF;
12783:
12784: IF p_user_in_rec.HASH_STRING <> FND_API.G_MISS_CHAR
12785: AND NVL(p_user_in_rec.HASH_STRING,'!!!') <> NVL(p_out_rec.HASH_STRING,'!!!')
12786: THEN
12787: l_attributes := l_attributes || 'HASH_STRING, ';
12788: END IF;
12786: THEN
12787: l_attributes := l_attributes || 'HASH_STRING, ';
12788: END IF;
12789:
12790: IF p_user_in_rec.DELIVERED_DATE <> FND_API.G_MISS_DATE
12791: AND NVL(p_user_in_rec.DELIVERED_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.DELIVERED_DATE,TO_DATE('2','j'))
12792: THEN
12793: l_attributes := l_attributes || 'DELIVERED_DATE, ';
12794: END IF;
12792: THEN
12793: l_attributes := l_attributes || 'DELIVERED_DATE, ';
12794: END IF;
12795:
12796: IF p_user_in_rec.PACKING_SLIP <> FND_API.G_MISS_CHAR
12797: AND NVL(p_user_in_rec.PACKING_SLIP,'!!!') <> NVL(p_out_rec.PACKING_SLIP,'!!!')
12798: THEN
12799: l_attributes := l_attributes || 'PACKING_SLIP, ';
12800: END IF;
12916: RETURN l_is_del_eligible;
12917:
12918: EXCEPTION
12919: WHEN OTHERS THEN
12920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12921: WSH_UTIL_CORE.default_handler('WSH_DELIVERIES_GRP.is_del_eligible_pick');
12922: IF l_debug_on THEN
12923: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
12924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
12920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12921: WSH_UTIL_CORE.default_handler('WSH_DELIVERIES_GRP.is_del_eligible_pick');
12922: IF l_debug_on THEN
12923: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
12924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
12925: END IF;
12926: RETURN FALSE;
12927:
12928: END Is_del_eligible_pick;