[Home] [Help]
1019: END IF;
1020: --
1021: wsh_cal_asg_validations.transport_dates(
1022: p_api_version_number => 1.0
1023: , p_init_msg_list => FND_API.G_FALSE
1024: , x_return_status => x_return_status
1025: , x_msg_count => l_msg_count
1026: , x_msg_data => l_msg_data
1027: , p_priority => 'SHIP'
1995: END IF;
1996: --
1997: --
1998: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
1999: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2000: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
2001: raise FND_API.G_EXC_ERROR;
2002: END IF;
2003: --
1997: --
1998: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
1999: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2000: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
2001: raise FND_API.G_EXC_ERROR;
2002: END IF;
2003: --
2004: --}
2005: END IF;
2213: --
2214: EXCEPTION
2215: -- J-IB-NPARIKH-{
2216: --
2217: WHEN FND_API.G_EXC_ERROR THEN
2218:
2219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2220: --
2221: IF l_debug_on THEN
2218:
2219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2220: --
2221: IF l_debug_on THEN
2222: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2224: END IF;
2225: --
2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2220: --
2221: IF l_debug_on THEN
2222: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2224: END IF;
2225: --
2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2227:
2222: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2224: END IF;
2225: --
2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2227:
2228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2229: --
2230: IF l_debug_on THEN
2228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2229: --
2230: IF l_debug_on THEN
2231: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2233: END IF;
2234: --
2235: -- J-IB-NPARIKH-}
2236:
4414: );
4415: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
4416: x_return_status := l_return_status;
4417: wsh_util_core.add_message(x_return_status);
4418: RAISE FND_API.G_EXC_ERROR;
4419: END IF;
4420: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
4421: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
4422: IF l_exceptions_tab(exp_cnt).entity_name = 'DELIVERY' THEN
4512: x_allowed := 'NW';
4513: --
4514: --
4515: IF l_debug_on THEN
4516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4518: END IF;
4519: --
4520: WHEN FND_API.G_EXC_ERROR THEN
4513: --
4514: --
4515: IF l_debug_on THEN
4516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4518: END IF;
4519: --
4520: WHEN FND_API.G_EXC_ERROR THEN
4521:
4516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4518: END IF;
4519: --
4520: WHEN FND_API.G_EXC_ERROR THEN
4521:
4522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4523: --
4524: IF l_debug_on THEN
4521:
4522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4523: --
4524: IF l_debug_on THEN
4525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4527: END IF;
4528: --
4529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4523: --
4524: IF l_debug_on THEN
4525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4527: END IF;
4528: --
4529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4530:
4525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4527: END IF;
4528: --
4529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4530:
4531: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4532: --
4533: IF l_debug_on THEN
4531: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4532: --
4533: IF l_debug_on THEN
4534: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4535: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4536: END IF;
4537: --
4538: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4539: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5469: END IF;
5470: --
5471: --
5472: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
5473: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5474: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
5475: raise FND_API.G_EXC_ERROR;
5476: END IF;
5477: --
5471: --
5472: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
5473: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5474: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
5475: raise FND_API.G_EXC_ERROR;
5476: END IF;
5477: --
5478: --
5479: IF l_shipping_control = 'SUPPLIER'
5522: END IF;
5523:
5524:
5525: WHEN wsh_dp_no_entity THEN
5526: x_return_status := FND_API.G_RET_STS_ERROR;
5527: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
5528: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
5529: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
5530: IF x_msg_count > 1 then
5541: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
5542: END IF;
5543: --
5544: WHEN wsh_inv_list_type THEN
5545: x_return_status := FND_API.G_RET_STS_ERROR;
5546: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
5547: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
5548: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
5549: IF x_msg_count > 1 then
5935: l_min_quantity2 := l_minmaxoutrectype.min_remaining_quantity2;
5936: l_max_quantity2 := l_minmaxoutrectype.max_remaining_quantity2;
5937:
5938:
5939: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5940: raise others ;
5941: END IF;
5942:
5943:
5966: -- line to have one detail with secondary uom populated and one without
5967: -- depending on the released status. We should handle this case w/o
5968: -- erroring out.
5969:
5970: IF NVL(l_bad_quantities.requested_quantity_uom2, NVL(l_total_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5971: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5972: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5973: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5974: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
5967: -- depending on the released status. We should handle this case w/o
5968: -- erroring out.
5969:
5970: IF NVL(l_bad_quantities.requested_quantity_uom2, NVL(l_total_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5971: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5972: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5973: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5974: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
5975: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5968: -- erroring out.
5969:
5970: IF NVL(l_bad_quantities.requested_quantity_uom2, NVL(l_total_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5971: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5972: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5973: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5974: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
5975: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5976: = NVL(l_bad_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5969:
5970: IF NVL(l_bad_quantities.requested_quantity_uom2, NVL(l_total_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5971: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5972: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5973: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5974: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
5975: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5976: = NVL(l_bad_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5977: THEN
5971: = NVL(l_total_quantities.requested_quantity_uom2, NVL(l_bad_quantities.requested_quantity_uom2, FND_API.G_MISS_CHAR))
5972: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5973: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5974: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
5975: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5976: = NVL(l_bad_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5977: THEN
5978: l_total_quantities.expected_quantity := l_total_quantities.expected_quantity
5979: + l_bad_quantities.expected_quantity;
5972: AND NVL(l_total_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5973: = NVL(l_bad_quantities.src_requested_quantity_uom, FND_API.G_MISS_CHAR)
5974: AND l_total_quantities.requested_quantity_uom = l_bad_quantities.requested_quantity_uom
5975: AND NVL(l_total_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5976: = NVL(l_bad_quantities.inventory_item_id, FND_API.G_MISS_NUM)
5977: THEN
5978: l_total_quantities.expected_quantity := l_total_quantities.expected_quantity
5979: + l_bad_quantities.expected_quantity;
5980: ELSE
5979: + l_bad_quantities.expected_quantity;
5980: ELSE
5981: CLOSE c_total_line_quantities;
5982: FND_MESSAGE.SET_NAME('WSH','WSH_DATA_CORRUPTION');
5983: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR);
5984: raise others ;
5985: END IF;
5986:
5987: END LOOP;
6103: FND_MESSAGE.SET_TOKEN('MAX_QTY',l_line_max_quantity);
6104:
6105: END IF;
6106:
6107: x_return_status := FND_API.G_RET_STS_ERROR;
6108: -- Add_message is not needed because the caller Confirm_Delivery does this.
6109: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
6110:
6111: --
6452: wsh_debug_sv.log(l_module_name, 'l_org_type is: ', l_org_type);
6453: END IF;
6454: --
6455: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
6456: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6457: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
6458: raise e_record_ineligible;
6459: END IF;
6460: --
6581: END IF;
6582: --
6583: --
6584: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
6585: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6586: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
6587: raise e_record_ineligible;
6588: END IF;
6589: --
6702: IF l_debug_on THEN
6703: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6704: END IF;
6705:
6706: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
6707: open del_to_det_cur(p_dlvy_rec_tab(j).delivery_id);
6708: Fetch del_to_det_cur into l_tpw_temp;
6709: close del_to_det_cur;
6710: IF ( l_tpw_temp is null ) THEN
6733: IF l_debug_on THEN
6734: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6735: END IF;
6736:
6737: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
6738: raise e_record_ineligible;
6739: ELSE
6740: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6741: x_valid_index_tab(j) := j;
6761: IF l_debug_on THEN
6762: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type|| l_return_status);
6763: END IF;
6764:
6765: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN
6766: raise e_record_ineligible;
6767: ELSE
6768: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6769: x_valid_index_tab(j) := j;
6782: IF l_debug_on THEN
6783: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6784: END IF;
6785:
6786: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'CMS' ) THEN
6787: raise e_record_ineligible;
6788: ELSE
6789: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6790: x_valid_index_tab(j) := j;
6801: IF l_debug_on THEN
6802: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6803: END IF;
6804:
6805: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS') ) THEN
6806: open del_to_det_cur(p_dlvy_rec_tab(j).delivery_id);
6807: Fetch del_to_det_cur into l_tpw_temp;
6808: close del_to_det_cur;
6809:
6840: IF l_debug_on THEN
6841: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6842: END IF;
6843:
6844: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR ) THEN
6845: open det_stat_cur(p_dlvy_rec_tab(j).delivery_id);
6846: fetch det_stat_cur into l_atd_tpw_temp;
6847: close det_stat_cur;
6848:
6851: ELSE
6852: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6853: x_valid_index_tab(j) := j;
6854: END IF;
6855: ELSIF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('CMS','TPW') ) THEN
6856: IF ( l_status_code = 'OP' ) THEN
6857: open valid_shpmnt_advice_cur(p_dlvy_rec_tab(j).delivery_id, l_organization_id);
6858: fetch valid_shpmnt_advice_cur into l_valid_shpt_advc_tmp;
6859: close valid_shpmnt_advice_cur;
6900: IF l_debug_on THEN
6901: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6902: END IF;
6903:
6904: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ( 'CMS','TPW') )
6905:
6906: THEN
6907: open del_to_det_cur(p_dlvy_rec_tab(j).delivery_id);
6908: fetch del_to_det_cur into l_tpw_temp;
6946: IF l_debug_on THEN
6947: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
6948: END IF;
6949:
6950: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS') ) THEN
6951: raise e_record_ineligible;
6952: ELSE
6953: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6954: x_valid_index_tab(j) := j;
7066: )
7067: IS
7068: BEGIN
7069:
7070: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
7071: x_internal := p_internal;
7072: IF p_internal IS NULL THEN
7073: x_external := NULL;
7074: ELSE
7073: x_external := NULL;
7074: ELSE
7075: x_external := p_external;
7076: END IF;
7077: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
7078: x_external := p_external;
7079: IF x_external IS NULL THEN
7080: x_internal := NULL;
7081: ELSE
7100: )
7101: IS
7102: BEGIN
7103:
7104: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
7105: x_internal := p_internal;
7106: IF p_internal IS NULL THEN
7107: x_external := NULL;
7108: ELSE
7107: x_external := NULL;
7108: ELSE
7109: x_external := p_external;
7110: END IF;
7111: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
7112: x_external := p_external;
7113: IF x_external IS NULL THEN
7114: x_internal := NULL;
7115: ELSE
7134: permanently disabled.
7135: */
7136: --
7137:
7138: IF p_delivery_rec.NAME <> FND_API.G_MISS_CHAR
7139: OR p_delivery_rec.NAME IS NULL THEN
7140: x_delivery_rec.NAME :=
7141: p_delivery_rec.NAME;
7142: END IF;
7160: p_delivery_rec.POOLED_SHIP_TO_LOCATION_CODE,
7161: x_delivery_rec.POOLED_SHIP_TO_LOCATION_ID,
7162: x_delivery_rec.POOLED_SHIP_TO_LOCATION_CODE );
7163:
7164: IF p_delivery_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE
7165: OR p_delivery_rec.INITIAL_PICKUP_DATE IS NULL THEN
7166: x_delivery_rec.INITIAL_PICKUP_DATE :=
7167: p_delivery_rec.INITIAL_PICKUP_DATE;
7168: END IF;
7168: END IF;
7169:
7170: --Bug 3458160
7171: IF p_in_rec.caller = 'WSH_TPW_INBOUND' THEN
7172: IF p_delivery_rec.SHIPMENT_DIRECTION <> FND_API.G_MISS_CHAR THEN
7173: x_delivery_rec.SHIPMENT_DIRECTION :=
7174: p_delivery_rec.SHIPMENT_DIRECTION;
7175: END IF;
7176: IF p_delivery_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR THEN
7172: IF p_delivery_rec.SHIPMENT_DIRECTION <> FND_API.G_MISS_CHAR THEN
7173: x_delivery_rec.SHIPMENT_DIRECTION :=
7174: p_delivery_rec.SHIPMENT_DIRECTION;
7175: END IF;
7176: IF p_delivery_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR THEN
7177: x_delivery_rec.IGNORE_FOR_PLANNING :=
7178: p_delivery_rec.IGNORE_FOR_PLANNING;
7179: END IF;
7180: ELSIF p_in_rec.caller = 'WSH_INBOUND' THEN
7177: x_delivery_rec.IGNORE_FOR_PLANNING :=
7178: p_delivery_rec.IGNORE_FOR_PLANNING;
7179: END IF;
7180: ELSIF p_in_rec.caller = 'WSH_INBOUND' THEN
7181: IF p_delivery_rec.DELIVERED_DATE <> FND_API.G_MISS_DATE
7182: OR p_delivery_rec.DELIVERED_DATE IS NULL THEN
7183: x_delivery_rec.DELIVERED_DATE :=
7184: p_delivery_rec.DELIVERED_DATE;
7185: END IF;
7190: p_delivery_rec.ULTIMATE_DROPOFF_LOCATION_CODE,
7191: x_delivery_rec.ULTIMATE_DROPOFF_LOCATION_ID,
7192: x_delivery_rec.ULTIMATE_DROPOFF_LOCATION_CODE );
7193:
7194: IF p_delivery_rec.NUMBER_OF_LPN <> FND_API.G_MISS_NUM
7195: OR p_delivery_rec.NUMBER_OF_LPN IS NULL THEN
7196: x_delivery_rec.NUMBER_OF_LPN :=
7197: p_delivery_rec.NUMBER_OF_LPN;
7198: END IF;
7195: OR p_delivery_rec.NUMBER_OF_LPN IS NULL THEN
7196: x_delivery_rec.NUMBER_OF_LPN :=
7197: p_delivery_rec.NUMBER_OF_LPN;
7198: END IF;
7199: IF p_delivery_rec.WAYBILL <> FND_API.G_MISS_CHAR
7200: OR p_delivery_rec.WAYBILL IS NULL THEN
7201: x_delivery_rec.WAYBILL :=
7202: p_delivery_rec.WAYBILL;
7203: END IF;
7221: p_delivery_rec.CARRIER_CODE,
7222: x_delivery_rec.CARRIER_ID,
7223: x_delivery_rec.CARRIER_CODE );
7224:
7225: IF p_delivery_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
7226: OR p_delivery_rec.SERVICE_LEVEL IS NULL THEN
7227: x_delivery_rec.SERVICE_LEVEL :=
7228: p_delivery_rec.SERVICE_LEVEL;
7229: END IF;
7226: OR p_delivery_rec.SERVICE_LEVEL IS NULL THEN
7227: x_delivery_rec.SERVICE_LEVEL :=
7228: p_delivery_rec.SERVICE_LEVEL;
7229: END IF;
7230: IF p_delivery_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
7231: OR p_delivery_rec.MODE_OF_TRANSPORT IS NULL THEN
7232: x_delivery_rec.MODE_OF_TRANSPORT :=
7233: p_delivery_rec.MODE_OF_TRANSPORT;
7234: END IF;
7242: p_delivery_rec.FOB_LOCATION_CODE,
7243: x_delivery_rec.FOB_LOCATION_ID,
7244: x_delivery_rec.FOB_LOCATION_CODE );
7245:
7246: IF p_delivery_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
7247: OR p_delivery_rec.GROSS_WEIGHT IS NULL THEN
7248: x_delivery_rec.GROSS_WEIGHT :=
7249: p_delivery_rec.GROSS_WEIGHT;
7250: END IF;
7247: OR p_delivery_rec.GROSS_WEIGHT IS NULL THEN
7248: x_delivery_rec.GROSS_WEIGHT :=
7249: p_delivery_rec.GROSS_WEIGHT;
7250: END IF;
7251: IF p_delivery_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
7252: OR p_delivery_rec.NET_WEIGHT IS NULL THEN
7253: x_delivery_rec.NET_WEIGHT :=
7254: p_delivery_rec.NET_WEIGHT;
7255: END IF;
7258: p_delivery_rec.WEIGHT_UOM_DESC,
7259: x_delivery_rec.WEIGHT_UOM_CODE,
7260: x_delivery_rec.WEIGHT_UOM_DESC );
7261:
7262: IF p_delivery_rec.VOLUME <> FND_API.G_MISS_NUM
7263: OR p_delivery_rec.VOLUME IS NULL THEN
7264: x_delivery_rec.VOLUME :=
7265: p_delivery_rec.VOLUME;
7266: END IF;
7270: x_delivery_rec.VOLUME_UOM_CODE,
7271: x_delivery_rec.VOLUME_UOM_DESC );
7272:
7273: -- bug 3666967 - need wv_frozen_flag when creating new delivery through public api.
7274: IF p_delivery_rec.wv_frozen_flag <> FND_API.G_MISS_CHAR THEN
7275: x_delivery_rec.wv_frozen_flag :=
7276: p_delivery_rec.wv_frozen_flag;
7277: END IF;
7278: -- end bug 3666967
7277: END IF;
7278: -- end bug 3666967
7279:
7280: -- Bug#4539613 : Consider the Prorate weight flag while populating output record.
7281: IF p_delivery_rec.prorate_wt_flag <> FND_API.G_MISS_CHAR
7282: OR p_delivery_rec.prorate_wt_flag IS NULL THEN
7283: x_delivery_rec.prorate_wt_flag :=
7284: p_delivery_rec.prorate_wt_flag;
7285: END IF;
7283: x_delivery_rec.prorate_wt_flag :=
7284: p_delivery_rec.prorate_wt_flag;
7285: END IF;
7286:
7287: IF p_delivery_rec.LOADING_SEQUENCE <> FND_API.G_MISS_NUM
7288: OR p_delivery_rec.LOADING_SEQUENCE IS NULL THEN
7289: x_delivery_rec.LOADING_SEQUENCE :=
7290: p_delivery_rec.LOADING_SEQUENCE;
7291: END IF;
7294: p_delivery_rec.LOADING_ORDER_DESC,
7295: x_delivery_rec.LOADING_ORDER_FLAG,
7296: x_delivery_rec.LOADING_ORDER_DESC );
7297:
7298: IF p_delivery_rec.ADDITIONAL_SHIPMENT_INFO <> FND_API.G_MISS_CHAR
7299: OR p_delivery_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
7300: x_delivery_rec.ADDITIONAL_SHIPMENT_INFO :=
7301: p_delivery_rec.ADDITIONAL_SHIPMENT_INFO;
7302: END IF;
7299: OR p_delivery_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
7300: x_delivery_rec.ADDITIONAL_SHIPMENT_INFO :=
7301: p_delivery_rec.ADDITIONAL_SHIPMENT_INFO;
7302: END IF;
7303: IF p_delivery_rec.PORT_OF_LOADING <> FND_API.G_MISS_CHAR
7304: OR p_delivery_rec.PORT_OF_LOADING IS NULL THEN
7305: x_delivery_rec.PORT_OF_LOADING :=
7306: p_delivery_rec.PORT_OF_LOADING;
7307: END IF;
7304: OR p_delivery_rec.PORT_OF_LOADING IS NULL THEN
7305: x_delivery_rec.PORT_OF_LOADING :=
7306: p_delivery_rec.PORT_OF_LOADING;
7307: END IF;
7308: IF p_delivery_rec.ROUTED_EXPORT_TXN <> FND_API.G_MISS_CHAR
7309: OR p_delivery_rec.ROUTED_EXPORT_TXN IS NULL THEN
7310: x_delivery_rec.ROUTED_EXPORT_TXN :=
7311: p_delivery_rec.ROUTED_EXPORT_TXN;
7312: END IF;
7309: OR p_delivery_rec.ROUTED_EXPORT_TXN IS NULL THEN
7310: x_delivery_rec.ROUTED_EXPORT_TXN :=
7311: p_delivery_rec.ROUTED_EXPORT_TXN;
7312: END IF;
7313: IF p_delivery_rec.FTZ_NUMBER <> FND_API.G_MISS_CHAR
7314: OR p_delivery_rec.FTZ_NUMBER IS NULL THEN
7315: x_delivery_rec.FTZ_NUMBER :=
7316: p_delivery_rec.FTZ_NUMBER;
7317: END IF;
7314: OR p_delivery_rec.FTZ_NUMBER IS NULL THEN
7315: x_delivery_rec.FTZ_NUMBER :=
7316: p_delivery_rec.FTZ_NUMBER;
7317: END IF;
7318: IF p_delivery_rec.ENTRY_NUMBER <> FND_API.G_MISS_CHAR
7319: OR p_delivery_rec.ENTRY_NUMBER IS NULL THEN
7320: x_delivery_rec.ENTRY_NUMBER :=
7321: p_delivery_rec.ENTRY_NUMBER;
7322: END IF;
7319: OR p_delivery_rec.ENTRY_NUMBER IS NULL THEN
7320: x_delivery_rec.ENTRY_NUMBER :=
7321: p_delivery_rec.ENTRY_NUMBER;
7322: END IF;
7323: IF p_delivery_rec.IN_BOND_CODE <> FND_API.G_MISS_CHAR
7324: OR p_delivery_rec.IN_BOND_CODE IS NULL THEN
7325: x_delivery_rec.IN_BOND_CODE :=
7326: p_delivery_rec.IN_BOND_CODE;
7327: END IF;
7324: OR p_delivery_rec.IN_BOND_CODE IS NULL THEN
7325: x_delivery_rec.IN_BOND_CODE :=
7326: p_delivery_rec.IN_BOND_CODE;
7327: END IF;
7328: IF p_delivery_rec.SHIPPING_MARKS <> FND_API.G_MISS_CHAR
7329: OR p_delivery_rec.SHIPPING_MARKS IS NULL THEN
7330: x_delivery_rec.SHIPPING_MARKS :=
7331: p_delivery_rec.SHIPPING_MARKS;
7332: END IF;
7329: OR p_delivery_rec.SHIPPING_MARKS IS NULL THEN
7330: x_delivery_rec.SHIPPING_MARKS :=
7331: p_delivery_rec.SHIPPING_MARKS;
7332: END IF;
7333: IF p_delivery_rec.PROBLEM_CONTACT_REFERENCE <> FND_API.G_MISS_CHAR
7334: OR p_delivery_rec.PROBLEM_CONTACT_REFERENCE IS NULL THEN
7335: x_delivery_rec.PROBLEM_CONTACT_REFERENCE :=
7336: p_delivery_rec.PROBLEM_CONTACT_REFERENCE;
7337: END IF;
7334: OR p_delivery_rec.PROBLEM_CONTACT_REFERENCE IS NULL THEN
7335: x_delivery_rec.PROBLEM_CONTACT_REFERENCE :=
7336: p_delivery_rec.PROBLEM_CONTACT_REFERENCE;
7337: END IF;
7338: IF p_delivery_rec.COD_AMOUNT <> FND_API.G_MISS_NUM
7339: OR p_delivery_rec.COD_AMOUNT IS NULL THEN
7340: x_delivery_rec.COD_AMOUNT :=
7341: p_delivery_rec.COD_AMOUNT;
7342: END IF;
7339: OR p_delivery_rec.COD_AMOUNT IS NULL THEN
7340: x_delivery_rec.COD_AMOUNT :=
7341: p_delivery_rec.COD_AMOUNT;
7342: END IF;
7343: IF p_delivery_rec.COD_CURRENCY_CODE <> FND_API.G_MISS_CHAR
7344: OR p_delivery_rec.COD_CURRENCY_CODE IS NULL THEN
7345: x_delivery_rec.COD_CURRENCY_CODE :=
7346: p_delivery_rec.COD_CURRENCY_CODE;
7347: END IF;
7344: OR p_delivery_rec.COD_CURRENCY_CODE IS NULL THEN
7345: x_delivery_rec.COD_CURRENCY_CODE :=
7346: p_delivery_rec.COD_CURRENCY_CODE;
7347: END IF;
7348: IF p_delivery_rec.COD_REMIT_TO <> FND_API.G_MISS_CHAR
7349: OR p_delivery_rec.COD_REMIT_TO IS NULL THEN
7350: x_delivery_rec.COD_REMIT_TO :=
7351: p_delivery_rec.COD_REMIT_TO;
7352: END IF;
7349: OR p_delivery_rec.COD_REMIT_TO IS NULL THEN
7350: x_delivery_rec.COD_REMIT_TO :=
7351: p_delivery_rec.COD_REMIT_TO;
7352: END IF;
7353: IF p_delivery_rec.COD_CHARGE_PAID_BY <> FND_API.G_MISS_CHAR
7354: OR p_delivery_rec.COD_CHARGE_PAID_BY IS NULL THEN
7355: x_delivery_rec.COD_CHARGE_PAID_BY :=
7356: p_delivery_rec.COD_CHARGE_PAID_BY;
7357: END IF;
7354: OR p_delivery_rec.COD_CHARGE_PAID_BY IS NULL THEN
7355: x_delivery_rec.COD_CHARGE_PAID_BY :=
7356: p_delivery_rec.COD_CHARGE_PAID_BY;
7357: END IF;
7358: IF p_delivery_rec.AUTO_SC_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
7359: OR p_delivery_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
7360: x_delivery_rec.AUTO_SC_EXCLUDE_FLAG :=
7361: p_delivery_rec.AUTO_SC_EXCLUDE_FLAG;
7362: END IF;
7359: OR p_delivery_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
7360: x_delivery_rec.AUTO_SC_EXCLUDE_FLAG :=
7361: p_delivery_rec.AUTO_SC_EXCLUDE_FLAG;
7362: END IF;
7363: IF p_delivery_rec.AUTO_AP_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
7364: OR p_delivery_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
7365: x_delivery_rec.AUTO_AP_EXCLUDE_FLAG :=
7366: p_delivery_rec.AUTO_AP_EXCLUDE_FLAG;
7367: END IF;
7364: OR p_delivery_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
7365: x_delivery_rec.AUTO_AP_EXCLUDE_FLAG :=
7366: p_delivery_rec.AUTO_AP_EXCLUDE_FLAG;
7367: END IF;
7368: IF p_delivery_rec.attribute1 <> FND_API.G_MISS_CHAR
7369: OR p_delivery_rec.attribute1 IS NULL THEN
7370: x_delivery_rec.attribute1 :=
7371: p_delivery_rec.attribute1;
7372: END IF;
7369: OR p_delivery_rec.attribute1 IS NULL THEN
7370: x_delivery_rec.attribute1 :=
7371: p_delivery_rec.attribute1;
7372: END IF;
7373: IF p_delivery_rec.attribute2 <> FND_API.G_MISS_CHAR
7374: OR p_delivery_rec.attribute2 IS NULL THEN
7375: x_delivery_rec.attribute2 :=
7376: p_delivery_rec.attribute2;
7377: END IF;
7374: OR p_delivery_rec.attribute2 IS NULL THEN
7375: x_delivery_rec.attribute2 :=
7376: p_delivery_rec.attribute2;
7377: END IF;
7378: IF p_delivery_rec.attribute3 <> FND_API.G_MISS_CHAR
7379: OR p_delivery_rec.attribute3 IS NULL THEN
7380: x_delivery_rec.attribute3 :=
7381: p_delivery_rec.attribute3;
7382: END IF;
7379: OR p_delivery_rec.attribute3 IS NULL THEN
7380: x_delivery_rec.attribute3 :=
7381: p_delivery_rec.attribute3;
7382: END IF;
7383: IF p_delivery_rec.attribute4 <> FND_API.G_MISS_CHAR
7384: OR p_delivery_rec.attribute4 IS NULL THEN
7385: x_delivery_rec.attribute4 :=
7386: p_delivery_rec.attribute4;
7387: END IF;
7384: OR p_delivery_rec.attribute4 IS NULL THEN
7385: x_delivery_rec.attribute4 :=
7386: p_delivery_rec.attribute4;
7387: END IF;
7388: IF p_delivery_rec.attribute5 <> FND_API.G_MISS_CHAR
7389: OR p_delivery_rec.attribute5 IS NULL THEN
7390: x_delivery_rec.attribute5 :=
7391: p_delivery_rec.attribute5;
7392: END IF;
7389: OR p_delivery_rec.attribute5 IS NULL THEN
7390: x_delivery_rec.attribute5 :=
7391: p_delivery_rec.attribute5;
7392: END IF;
7393: IF p_delivery_rec.attribute6 <> FND_API.G_MISS_CHAR
7394: OR p_delivery_rec.attribute6 IS NULL THEN
7395: x_delivery_rec.attribute6 :=
7396: p_delivery_rec.attribute6;
7397: END IF;
7394: OR p_delivery_rec.attribute6 IS NULL THEN
7395: x_delivery_rec.attribute6 :=
7396: p_delivery_rec.attribute6;
7397: END IF;
7398: IF p_delivery_rec.attribute7 <> FND_API.G_MISS_CHAR
7399: OR p_delivery_rec.attribute7 IS NULL THEN
7400: x_delivery_rec.attribute7 :=
7401: p_delivery_rec.attribute7;
7402: END IF;
7399: OR p_delivery_rec.attribute7 IS NULL THEN
7400: x_delivery_rec.attribute7 :=
7401: p_delivery_rec.attribute7;
7402: END IF;
7403: IF p_delivery_rec.attribute8 <> FND_API.G_MISS_CHAR
7404: OR p_delivery_rec.attribute8 IS NULL THEN
7405: x_delivery_rec.attribute8 :=
7406: p_delivery_rec.attribute8;
7407: END IF;
7404: OR p_delivery_rec.attribute8 IS NULL THEN
7405: x_delivery_rec.attribute8 :=
7406: p_delivery_rec.attribute8;
7407: END IF;
7408: IF p_delivery_rec.attribute9 <> FND_API.G_MISS_CHAR
7409: OR p_delivery_rec.attribute9 IS NULL THEN
7410: x_delivery_rec.attribute9 :=
7411: p_delivery_rec.attribute9;
7412: END IF;
7409: OR p_delivery_rec.attribute9 IS NULL THEN
7410: x_delivery_rec.attribute9 :=
7411: p_delivery_rec.attribute9;
7412: END IF;
7413: IF p_delivery_rec.attribute10 <> FND_API.G_MISS_CHAR
7414: OR p_delivery_rec.attribute10 IS NULL THEN
7415: x_delivery_rec.attribute10 :=
7416: p_delivery_rec.attribute10;
7417: END IF;
7414: OR p_delivery_rec.attribute10 IS NULL THEN
7415: x_delivery_rec.attribute10 :=
7416: p_delivery_rec.attribute10;
7417: END IF;
7418: IF p_delivery_rec.attribute11 <> FND_API.G_MISS_CHAR
7419: OR p_delivery_rec.attribute11 IS NULL THEN
7420: x_delivery_rec.attribute11 :=
7421: p_delivery_rec.attribute11;
7422: END IF;
7419: OR p_delivery_rec.attribute11 IS NULL THEN
7420: x_delivery_rec.attribute11 :=
7421: p_delivery_rec.attribute11;
7422: END IF;
7423: IF p_delivery_rec.attribute12 <> FND_API.G_MISS_CHAR
7424: OR p_delivery_rec.attribute12 IS NULL THEN
7425: x_delivery_rec.attribute12 :=
7426: p_delivery_rec.attribute12;
7427: END IF;
7424: OR p_delivery_rec.attribute12 IS NULL THEN
7425: x_delivery_rec.attribute12 :=
7426: p_delivery_rec.attribute12;
7427: END IF;
7428: IF p_delivery_rec.attribute13 <> FND_API.G_MISS_CHAR
7429: OR p_delivery_rec.attribute13 IS NULL THEN
7430: x_delivery_rec.attribute13 :=
7431: p_delivery_rec.attribute13;
7432: END IF;
7429: OR p_delivery_rec.attribute13 IS NULL THEN
7430: x_delivery_rec.attribute13 :=
7431: p_delivery_rec.attribute13;
7432: END IF;
7433: IF p_delivery_rec.attribute14 <> FND_API.G_MISS_CHAR
7434: OR p_delivery_rec.attribute14 IS NULL THEN
7435: x_delivery_rec.attribute14 :=
7436: p_delivery_rec.attribute14;
7437: END IF;
7434: OR p_delivery_rec.attribute14 IS NULL THEN
7435: x_delivery_rec.attribute14 :=
7436: p_delivery_rec.attribute14;
7437: END IF;
7438: IF p_delivery_rec.attribute15 <> FND_API.G_MISS_CHAR
7439: OR p_delivery_rec.attribute15 IS NULL THEN
7440: x_delivery_rec.attribute15 :=
7441: p_delivery_rec.attribute15;
7442: END IF;
7439: OR p_delivery_rec.attribute15 IS NULL THEN
7440: x_delivery_rec.attribute15 :=
7441: p_delivery_rec.attribute15;
7442: END IF;
7443: IF p_delivery_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
7444: OR p_delivery_rec.ATTRIBUTE_CATEGORY IS NULL THEN
7445: x_delivery_rec.ATTRIBUTE_CATEGORY :=
7446: p_delivery_rec.ATTRIBUTE_CATEGORY;
7447: END IF;
7444: OR p_delivery_rec.ATTRIBUTE_CATEGORY IS NULL THEN
7445: x_delivery_rec.ATTRIBUTE_CATEGORY :=
7446: p_delivery_rec.ATTRIBUTE_CATEGORY;
7447: END IF;
7448: IF p_delivery_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
7449: OR p_delivery_rec.tp_attribute1 IS NULL THEN
7450: x_delivery_rec.tp_attribute1 :=
7451: p_delivery_rec.tp_attribute1;
7452: END IF;
7449: OR p_delivery_rec.tp_attribute1 IS NULL THEN
7450: x_delivery_rec.tp_attribute1 :=
7451: p_delivery_rec.tp_attribute1;
7452: END IF;
7453: IF p_delivery_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
7454: OR p_delivery_rec.tp_attribute2 IS NULL THEN
7455: x_delivery_rec.tp_attribute2 :=
7456: p_delivery_rec.tp_attribute2;
7457: END IF;
7454: OR p_delivery_rec.tp_attribute2 IS NULL THEN
7455: x_delivery_rec.tp_attribute2 :=
7456: p_delivery_rec.tp_attribute2;
7457: END IF;
7458: IF p_delivery_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
7459: OR p_delivery_rec.tp_attribute3 IS NULL THEN
7460: x_delivery_rec.tp_attribute3 :=
7461: p_delivery_rec.tp_attribute3;
7462: END IF;
7459: OR p_delivery_rec.tp_attribute3 IS NULL THEN
7460: x_delivery_rec.tp_attribute3 :=
7461: p_delivery_rec.tp_attribute3;
7462: END IF;
7463: IF p_delivery_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
7464: OR p_delivery_rec.tp_attribute4 IS NULL THEN
7465: x_delivery_rec.tp_attribute4 :=
7466: p_delivery_rec.tp_attribute4;
7467: END IF;
7464: OR p_delivery_rec.tp_attribute4 IS NULL THEN
7465: x_delivery_rec.tp_attribute4 :=
7466: p_delivery_rec.tp_attribute4;
7467: END IF;
7468: IF p_delivery_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
7469: OR p_delivery_rec.tp_attribute5 IS NULL THEN
7470: x_delivery_rec.tp_attribute5 :=
7471: p_delivery_rec.tp_attribute5;
7472: END IF;
7469: OR p_delivery_rec.tp_attribute5 IS NULL THEN
7470: x_delivery_rec.tp_attribute5 :=
7471: p_delivery_rec.tp_attribute5;
7472: END IF;
7473: IF p_delivery_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
7474: OR p_delivery_rec.tp_attribute6 IS NULL THEN
7475: x_delivery_rec.tp_attribute6 :=
7476: p_delivery_rec.tp_attribute6;
7477: END IF;
7474: OR p_delivery_rec.tp_attribute6 IS NULL THEN
7475: x_delivery_rec.tp_attribute6 :=
7476: p_delivery_rec.tp_attribute6;
7477: END IF;
7478: IF p_delivery_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
7479: OR p_delivery_rec.tp_attribute7 IS NULL THEN
7480: x_delivery_rec.tp_attribute7 :=
7481: p_delivery_rec.tp_attribute7;
7482: END IF;
7479: OR p_delivery_rec.tp_attribute7 IS NULL THEN
7480: x_delivery_rec.tp_attribute7 :=
7481: p_delivery_rec.tp_attribute7;
7482: END IF;
7483: IF p_delivery_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
7484: OR p_delivery_rec.tp_attribute8 IS NULL THEN
7485: x_delivery_rec.tp_attribute8 :=
7486: p_delivery_rec.tp_attribute8;
7487: END IF;
7484: OR p_delivery_rec.tp_attribute8 IS NULL THEN
7485: x_delivery_rec.tp_attribute8 :=
7486: p_delivery_rec.tp_attribute8;
7487: END IF;
7488: IF p_delivery_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
7489: OR p_delivery_rec.tp_attribute9 IS NULL THEN
7490: x_delivery_rec.tp_attribute9 :=
7491: p_delivery_rec.tp_attribute9;
7492: END IF;
7489: OR p_delivery_rec.tp_attribute9 IS NULL THEN
7490: x_delivery_rec.tp_attribute9 :=
7491: p_delivery_rec.tp_attribute9;
7492: END IF;
7493: IF p_delivery_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
7494: OR p_delivery_rec.tp_attribute10 IS NULL THEN
7495: x_delivery_rec.tp_attribute10 :=
7496: p_delivery_rec.tp_attribute10;
7497: END IF;
7494: OR p_delivery_rec.tp_attribute10 IS NULL THEN
7495: x_delivery_rec.tp_attribute10 :=
7496: p_delivery_rec.tp_attribute10;
7497: END IF;
7498: IF p_delivery_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
7499: OR p_delivery_rec.tp_attribute11 IS NULL THEN
7500: x_delivery_rec.tp_attribute11 :=
7501: p_delivery_rec.tp_attribute11;
7502: END IF;
7499: OR p_delivery_rec.tp_attribute11 IS NULL THEN
7500: x_delivery_rec.tp_attribute11 :=
7501: p_delivery_rec.tp_attribute11;
7502: END IF;
7503: IF p_delivery_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
7504: OR p_delivery_rec.tp_attribute12 IS NULL THEN
7505: x_delivery_rec.tp_attribute12 :=
7506: p_delivery_rec.tp_attribute12;
7507: END IF;
7504: OR p_delivery_rec.tp_attribute12 IS NULL THEN
7505: x_delivery_rec.tp_attribute12 :=
7506: p_delivery_rec.tp_attribute12;
7507: END IF;
7508: IF p_delivery_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
7509: OR p_delivery_rec.tp_attribute13 IS NULL THEN
7510: x_delivery_rec.tp_attribute13 :=
7511: p_delivery_rec.tp_attribute13;
7512: END IF;
7509: OR p_delivery_rec.tp_attribute13 IS NULL THEN
7510: x_delivery_rec.tp_attribute13 :=
7511: p_delivery_rec.tp_attribute13;
7512: END IF;
7513: IF p_delivery_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
7514: OR p_delivery_rec.tp_attribute14 IS NULL THEN
7515: x_delivery_rec.tp_attribute14 :=
7516: p_delivery_rec.tp_attribute14;
7517: END IF;
7514: OR p_delivery_rec.tp_attribute14 IS NULL THEN
7515: x_delivery_rec.tp_attribute14 :=
7516: p_delivery_rec.tp_attribute14;
7517: END IF;
7518: IF p_delivery_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
7519: OR p_delivery_rec.tp_attribute15 IS NULL THEN
7520: x_delivery_rec.tp_attribute15 :=
7521: p_delivery_rec.tp_attribute15;
7522: END IF;
7519: OR p_delivery_rec.tp_attribute15 IS NULL THEN
7520: x_delivery_rec.tp_attribute15 :=
7521: p_delivery_rec.tp_attribute15;
7522: END IF;
7523: IF p_delivery_rec.tp_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
7524: OR p_delivery_rec.tp_ATTRIBUTE_CATEGORY IS NULL THEN
7525: x_delivery_rec.tp_ATTRIBUTE_CATEGORY :=
7526: p_delivery_rec.tp_ATTRIBUTE_CATEGORY;
7527: END IF;
7524: OR p_delivery_rec.tp_ATTRIBUTE_CATEGORY IS NULL THEN
7525: x_delivery_rec.tp_ATTRIBUTE_CATEGORY :=
7526: p_delivery_rec.tp_ATTRIBUTE_CATEGORY;
7527: END IF;
7528: IF p_delivery_rec.global_attribute1 <> FND_API.G_MISS_CHAR
7529: OR p_delivery_rec.global_attribute1 IS NULL THEN
7530: x_delivery_rec.global_attribute1 :=
7531: p_delivery_rec.global_attribute1;
7532: END IF;
7529: OR p_delivery_rec.global_attribute1 IS NULL THEN
7530: x_delivery_rec.global_attribute1 :=
7531: p_delivery_rec.global_attribute1;
7532: END IF;
7533: IF p_delivery_rec.global_attribute2 <> FND_API.G_MISS_CHAR
7534: OR p_delivery_rec.global_attribute2 IS NULL THEN
7535: x_delivery_rec.global_attribute2 :=
7536: p_delivery_rec.global_attribute2;
7537: END IF;
7534: OR p_delivery_rec.global_attribute2 IS NULL THEN
7535: x_delivery_rec.global_attribute2 :=
7536: p_delivery_rec.global_attribute2;
7537: END IF;
7538: IF p_delivery_rec.global_attribute3 <> FND_API.G_MISS_CHAR
7539: OR p_delivery_rec.global_attribute3 IS NULL THEN
7540: x_delivery_rec.global_attribute3 :=
7541: p_delivery_rec.global_attribute3;
7542: END IF;
7539: OR p_delivery_rec.global_attribute3 IS NULL THEN
7540: x_delivery_rec.global_attribute3 :=
7541: p_delivery_rec.global_attribute3;
7542: END IF;
7543: IF p_delivery_rec.global_attribute4 <> FND_API.G_MISS_CHAR
7544: OR p_delivery_rec.global_attribute4 IS NULL THEN
7545: x_delivery_rec.global_attribute4 :=
7546: p_delivery_rec.global_attribute4;
7547: END IF;
7544: OR p_delivery_rec.global_attribute4 IS NULL THEN
7545: x_delivery_rec.global_attribute4 :=
7546: p_delivery_rec.global_attribute4;
7547: END IF;
7548: IF p_delivery_rec.global_attribute5 <> FND_API.G_MISS_CHAR
7549: OR p_delivery_rec.global_attribute5 IS NULL THEN
7550: x_delivery_rec.global_attribute5 :=
7551: p_delivery_rec.global_attribute5;
7552: END IF;
7549: OR p_delivery_rec.global_attribute5 IS NULL THEN
7550: x_delivery_rec.global_attribute5 :=
7551: p_delivery_rec.global_attribute5;
7552: END IF;
7553: IF p_delivery_rec.global_attribute6 <> FND_API.G_MISS_CHAR
7554: OR p_delivery_rec.global_attribute6 IS NULL THEN
7555: x_delivery_rec.global_attribute6 :=
7556: p_delivery_rec.global_attribute6;
7557: END IF;
7554: OR p_delivery_rec.global_attribute6 IS NULL THEN
7555: x_delivery_rec.global_attribute6 :=
7556: p_delivery_rec.global_attribute6;
7557: END IF;
7558: IF p_delivery_rec.global_attribute7 <> FND_API.G_MISS_CHAR
7559: OR p_delivery_rec.global_attribute7 IS NULL THEN
7560: x_delivery_rec.global_attribute7 :=
7561: p_delivery_rec.global_attribute7;
7562: END IF;
7559: OR p_delivery_rec.global_attribute7 IS NULL THEN
7560: x_delivery_rec.global_attribute7 :=
7561: p_delivery_rec.global_attribute7;
7562: END IF;
7563: IF p_delivery_rec.global_attribute8 <> FND_API.G_MISS_CHAR
7564: OR p_delivery_rec.global_attribute8 IS NULL THEN
7565: x_delivery_rec.global_attribute8 :=
7566: p_delivery_rec.global_attribute8;
7567: END IF;
7564: OR p_delivery_rec.global_attribute8 IS NULL THEN
7565: x_delivery_rec.global_attribute8 :=
7566: p_delivery_rec.global_attribute8;
7567: END IF;
7568: IF p_delivery_rec.global_attribute9 <> FND_API.G_MISS_CHAR
7569: OR p_delivery_rec.global_attribute9 IS NULL THEN
7570: x_delivery_rec.global_attribute9 :=
7571: p_delivery_rec.global_attribute9;
7572: END IF;
7569: OR p_delivery_rec.global_attribute9 IS NULL THEN
7570: x_delivery_rec.global_attribute9 :=
7571: p_delivery_rec.global_attribute9;
7572: END IF;
7573: IF p_delivery_rec.global_attribute10 <> FND_API.G_MISS_CHAR
7574: OR p_delivery_rec.global_attribute10 IS NULL THEN
7575: x_delivery_rec.global_attribute10 :=
7576: p_delivery_rec.global_attribute10;
7577: END IF;
7574: OR p_delivery_rec.global_attribute10 IS NULL THEN
7575: x_delivery_rec.global_attribute10 :=
7576: p_delivery_rec.global_attribute10;
7577: END IF;
7578: IF p_delivery_rec.global_attribute11 <> FND_API.G_MISS_CHAR
7579: OR p_delivery_rec.global_attribute11 IS NULL THEN
7580: x_delivery_rec.global_attribute11 :=
7581: p_delivery_rec.global_attribute11;
7582: END IF;
7579: OR p_delivery_rec.global_attribute11 IS NULL THEN
7580: x_delivery_rec.global_attribute11 :=
7581: p_delivery_rec.global_attribute11;
7582: END IF;
7583: IF p_delivery_rec.global_attribute12 <> FND_API.G_MISS_CHAR
7584: OR p_delivery_rec.global_attribute12 IS NULL THEN
7585: x_delivery_rec.global_attribute12 :=
7586: p_delivery_rec.global_attribute12;
7587: END IF;
7584: OR p_delivery_rec.global_attribute12 IS NULL THEN
7585: x_delivery_rec.global_attribute12 :=
7586: p_delivery_rec.global_attribute12;
7587: END IF;
7588: IF p_delivery_rec.global_attribute13 <> FND_API.G_MISS_CHAR
7589: OR p_delivery_rec.global_attribute13 IS NULL THEN
7590: x_delivery_rec.global_attribute13 :=
7591: p_delivery_rec.global_attribute13;
7592: END IF;
7589: OR p_delivery_rec.global_attribute13 IS NULL THEN
7590: x_delivery_rec.global_attribute13 :=
7591: p_delivery_rec.global_attribute13;
7592: END IF;
7593: IF p_delivery_rec.global_attribute14 <> FND_API.G_MISS_CHAR
7594: OR p_delivery_rec.global_attribute14 IS NULL THEN
7595: x_delivery_rec.global_attribute14 :=
7596: p_delivery_rec.global_attribute14;
7597: END IF;
7594: OR p_delivery_rec.global_attribute14 IS NULL THEN
7595: x_delivery_rec.global_attribute14 :=
7596: p_delivery_rec.global_attribute14;
7597: END IF;
7598: IF p_delivery_rec.global_attribute15 <> FND_API.G_MISS_CHAR
7599: OR p_delivery_rec.global_attribute15 IS NULL THEN
7600: x_delivery_rec.global_attribute15 :=
7601: p_delivery_rec.global_attribute15;
7602: END IF;
7599: OR p_delivery_rec.global_attribute15 IS NULL THEN
7600: x_delivery_rec.global_attribute15 :=
7601: p_delivery_rec.global_attribute15;
7602: END IF;
7603: IF p_delivery_rec.global_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
7604: OR p_delivery_rec.global_ATTRIBUTE_CATEGORY IS NULL THEN
7605: x_delivery_rec.global_ATTRIBUTE_CATEGORY :=
7606: p_delivery_rec.global_ATTRIBUTE_CATEGORY;
7607: END IF;
7604: OR p_delivery_rec.global_ATTRIBUTE_CATEGORY IS NULL THEN
7605: x_delivery_rec.global_ATTRIBUTE_CATEGORY :=
7606: p_delivery_rec.global_ATTRIBUTE_CATEGORY;
7607: END IF;
7608: IF p_delivery_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE
7609: OR p_delivery_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
7610: x_delivery_rec.ULTIMATE_DROPOFF_DATE :=
7611: p_delivery_rec.ULTIMATE_DROPOFF_DATE;
7612: END IF;
7609: OR p_delivery_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
7610: x_delivery_rec.ULTIMATE_DROPOFF_DATE :=
7611: p_delivery_rec.ULTIMATE_DROPOFF_DATE;
7612: END IF;
7613: IF p_delivery_rec.DOCK_CODE <> FND_API.G_MISS_CHAR
7614: OR p_delivery_rec.DOCK_CODE IS NULL THEN
7615: x_delivery_rec.DOCK_CODE :=
7616: p_delivery_rec.DOCK_CODE;
7617: END IF;
7614: OR p_delivery_rec.DOCK_CODE IS NULL THEN
7615: x_delivery_rec.DOCK_CODE :=
7616: p_delivery_rec.DOCK_CODE;
7617: END IF;
7618: IF p_delivery_rec.ACCEPTANCE_FLAG <> FND_API.G_MISS_CHAR
7619: OR p_delivery_rec.ACCEPTANCE_FLAG IS NULL THEN
7620: x_delivery_rec.ACCEPTANCE_FLAG :=
7621: p_delivery_rec.ACCEPTANCE_FLAG;
7622: END IF;
7619: OR p_delivery_rec.ACCEPTANCE_FLAG IS NULL THEN
7620: x_delivery_rec.ACCEPTANCE_FLAG :=
7621: p_delivery_rec.ACCEPTANCE_FLAG;
7622: END IF;
7623: IF p_delivery_rec.ACCEPTED_BY <> FND_API.G_MISS_CHAR
7624: OR p_delivery_rec.ACCEPTED_BY IS NULL THEN
7625: x_delivery_rec.ACCEPTED_BY :=
7626: p_delivery_rec.ACCEPTED_BY;
7627: END IF;
7624: OR p_delivery_rec.ACCEPTED_BY IS NULL THEN
7625: x_delivery_rec.ACCEPTED_BY :=
7626: p_delivery_rec.ACCEPTED_BY;
7627: END IF;
7628: IF p_delivery_rec.ACCEPTED_DATE <> FND_API.G_MISS_DATE
7629: OR p_delivery_rec.ACCEPTED_DATE IS NULL THEN
7630: x_delivery_rec.ACCEPTED_DATE :=
7631: p_delivery_rec.ACCEPTED_DATE;
7632: END IF;
7629: OR p_delivery_rec.ACCEPTED_DATE IS NULL THEN
7630: x_delivery_rec.ACCEPTED_DATE :=
7631: p_delivery_rec.ACCEPTED_DATE;
7632: END IF;
7633: IF p_delivery_rec.ACKNOWLEDGED_BY <> FND_API.G_MISS_CHAR
7634: OR p_delivery_rec.ACKNOWLEDGED_BY IS NULL THEN
7635: x_delivery_rec.ACKNOWLEDGED_BY :=
7636: p_delivery_rec.ACKNOWLEDGED_BY;
7637: END IF;
7634: OR p_delivery_rec.ACKNOWLEDGED_BY IS NULL THEN
7635: x_delivery_rec.ACKNOWLEDGED_BY :=
7636: p_delivery_rec.ACKNOWLEDGED_BY;
7637: END IF;
7638: IF p_delivery_rec.CONFIRMED_BY <> FND_API.G_MISS_CHAR
7639: OR p_delivery_rec.CONFIRMED_BY IS NULL THEN
7640: x_delivery_rec.CONFIRMED_BY :=
7641: p_delivery_rec.CONFIRMED_BY;
7642: END IF;
7639: OR p_delivery_rec.CONFIRMED_BY IS NULL THEN
7640: x_delivery_rec.CONFIRMED_BY :=
7641: p_delivery_rec.CONFIRMED_BY;
7642: END IF;
7643: IF p_delivery_rec.CONFIRM_DATE <> FND_API.G_MISS_DATE
7644: OR p_delivery_rec.CONFIRM_DATE IS NULL THEN
7645: x_delivery_rec.CONFIRM_DATE :=
7646: p_delivery_rec.CONFIRM_DATE;
7647: END IF;
7644: OR p_delivery_rec.CONFIRM_DATE IS NULL THEN
7645: x_delivery_rec.CONFIRM_DATE :=
7646: p_delivery_rec.CONFIRM_DATE;
7647: END IF;
7648: IF p_delivery_rec.PORT_OF_DISCHARGE <> FND_API.G_MISS_CHAR
7649: OR p_delivery_rec.PORT_OF_DISCHARGE IS NULL THEN
7650: x_delivery_rec.PORT_OF_DISCHARGE :=
7651: p_delivery_rec.PORT_OF_DISCHARGE;
7652: END IF;
7649: OR p_delivery_rec.PORT_OF_DISCHARGE IS NULL THEN
7650: x_delivery_rec.PORT_OF_DISCHARGE :=
7651: p_delivery_rec.PORT_OF_DISCHARGE;
7652: END IF;
7653: IF p_delivery_rec.ROUTING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
7654: OR p_delivery_rec.ROUTING_INSTRUCTIONS IS NULL THEN
7655: x_delivery_rec.ROUTING_INSTRUCTIONS :=
7656: p_delivery_rec.ROUTING_INSTRUCTIONS;
7657: END IF;
7654: OR p_delivery_rec.ROUTING_INSTRUCTIONS IS NULL THEN
7655: x_delivery_rec.ROUTING_INSTRUCTIONS :=
7656: p_delivery_rec.ROUTING_INSTRUCTIONS;
7657: END IF;
7658: IF p_delivery_rec.ASSIGNED_TO_FTE_TRIPS <> FND_API.G_MISS_CHAR
7659: OR p_delivery_rec.ASSIGNED_TO_FTE_TRIPS IS NULL THEN
7660: x_delivery_rec.ASSIGNED_TO_FTE_TRIPS :=
7661: p_delivery_rec.ASSIGNED_TO_FTE_TRIPS;
7662: END IF;
7662: END IF;
7663:
7664: --tkt
7665: IF p_in_rec.caller='WSH_TP_RELEASE' THEN
7666: IF p_delivery_rec.tp_plan_name <> FND_API.G_MISS_CHAR
7667: OR p_delivery_rec.tp_plan_name IS NULL THEN
7668: x_delivery_rec.tp_plan_name :=
7669: p_delivery_rec.tp_plan_name;
7670: END IF;
7667: OR p_delivery_rec.tp_plan_name IS NULL THEN
7668: x_delivery_rec.tp_plan_name :=
7669: p_delivery_rec.tp_plan_name;
7670: END IF;
7671: IF p_delivery_rec.tp_delivery_number <> FND_API.G_MISS_NUM
7672: OR p_delivery_rec.tp_delivery_number IS NULL THEN
7673: x_delivery_rec.tp_delivery_number :=
7674: p_delivery_rec.tp_delivery_number;
7675: END IF;
7675: END IF;
7676: END IF;
7677:
7678: /*3667348*/
7679: IF p_delivery_rec.REASON_OF_TRANSPORT <> FND_API.G_MISS_CHAR
7680: OR p_delivery_rec.REASON_OF_TRANSPORT IS NULL THEN
7681: x_delivery_rec.REASON_OF_TRANSPORT := p_delivery_rec.REASON_OF_TRANSPORT;
7682: END IF;
7683: IF p_delivery_rec.DESCRIPTION <> FND_API.G_MISS_CHAR
7679: IF p_delivery_rec.REASON_OF_TRANSPORT <> FND_API.G_MISS_CHAR
7680: OR p_delivery_rec.REASON_OF_TRANSPORT IS NULL THEN
7681: x_delivery_rec.REASON_OF_TRANSPORT := p_delivery_rec.REASON_OF_TRANSPORT;
7682: END IF;
7683: IF p_delivery_rec.DESCRIPTION <> FND_API.G_MISS_CHAR
7684: OR p_delivery_rec.DESCRIPTION IS NULL THEN
7685: x_delivery_rec.DESCRIPTION := p_delivery_rec.DESCRIPTION;
7686: END IF;
7687:
7723: ELSIF p_disabled_list(i) = '+INITIAL_PICKUP_LOCATION_CODE' THEN
7724: IF p_in_rec.INITIAL_PICKUP_LOCATION_ID IS NOT NULL THEN
7725: x_out_rec.INITIAL_PICKUP_LOCATION_ID :=
7726: p_in_rec.INITIAL_PICKUP_LOCATION_ID ;
7727: x_out_rec.INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
7728: END IF;
7729: ELSIF p_disabled_list(i) = '+ULTIMATE_DROPOFF_LOCATION_CODE' THEN
7730: IF p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID IS NOT NULL THEN
7731: x_out_rec.ULTIMATE_DROPOFF_LOCATION_ID :=
7729: ELSIF p_disabled_list(i) = '+ULTIMATE_DROPOFF_LOCATION_CODE' THEN
7730: IF p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID IS NOT NULL THEN
7731: x_out_rec.ULTIMATE_DROPOFF_LOCATION_ID :=
7732: p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID ;
7733: x_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE := FND_API.G_MISS_CHAR;
7734: END IF;
7735: ELSIF p_disabled_list(i) = '+CUSTOMER_NAME' THEN
7736: IF p_in_rec.CUSTOMER_ID IS NOT NULL THEN
7737: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
7734: END IF;
7735: ELSIF p_disabled_list(i) = '+CUSTOMER_NAME' THEN
7736: IF p_in_rec.CUSTOMER_ID IS NOT NULL THEN
7737: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
7738: x_out_rec.CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
7739: END IF;
7740: ELSIF p_disabled_list(i) = '+ORGANIZATION_CODE' THEN
7741: IF p_in_rec.ORGANIZATION_ID IS NOT NULL THEN
7742: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
7739: END IF;
7740: ELSIF p_disabled_list(i) = '+ORGANIZATION_CODE' THEN
7741: IF p_in_rec.ORGANIZATION_ID IS NOT NULL THEN
7742: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
7743: x_out_rec.organization_code := FND_API.G_MISS_CHAR;
7744: END IF;
7745: ELSIF p_disabled_list(i) = '+LOADING_ORDER_FLAG' THEN
7746: IF p_in_rec.LOADING_ORDER_FLAG IS NOT NULL THEN
7747: x_out_rec.LOADING_ORDER_FLAG := p_in_rec.LOADING_ORDER_FLAG ;
7744: END IF;
7745: ELSIF p_disabled_list(i) = '+LOADING_ORDER_FLAG' THEN
7746: IF p_in_rec.LOADING_ORDER_FLAG IS NOT NULL THEN
7747: x_out_rec.LOADING_ORDER_FLAG := p_in_rec.LOADING_ORDER_FLAG ;
7748: x_out_rec.LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
7749: END IF;
7750: ELSIF p_disabled_list(i) = '+ACCEPTANCE_FLAG' THEN
7751: IF p_in_rec.ACCEPTANCE_FLAG IS NOT NULL THEN
7752: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
7765: END IF;
7766: ELSIF p_disabled_list(i) = '+CURRENCY_CODE' THEN
7767: IF p_in_rec.CURRENCY_CODE IS NOT NULL THEN
7768: x_out_rec.CURRENCY_CODE := p_in_rec.CURRENCY_CODE ;
7769: x_out_rec.currency_name := FND_API.G_MISS_CHAR;
7770: END IF;
7771: ELSIF p_disabled_list(i) = '+INITIAL_PICKUP_DATE' THEN
7772: IF p_in_rec.INITIAL_PICKUP_DATE IS NOT NULL THEN
7773: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
7782: END IF;
7783: ELSIF p_disabled_list(i) = '+SHIP_METHOD_NAME' THEN
7784: IF p_in_rec.SHIP_METHOD_CODE IS NOT NULL THEN
7785: x_out_rec.SHIP_METHOD_CODE := p_in_rec.SHIP_METHOD_CODE ;
7786: x_out_rec.ship_method_name := FND_API.G_MISS_CHAR;
7787: END IF;
7788: ELSIF p_disabled_list(i) = '+FREIGHT_CODE' THEN
7789: NULL ;
7790: -- J-IB-NPARIKH-{ --I-bugfix
7789: NULL ;
7790: -- J-IB-NPARIKH-{ --I-bugfix
7791: IF p_in_rec.CARRIER_CODE IS NOT NULL THEN
7792: x_out_rec.carrier_id := p_in_rec.carrier_id ;
7793: x_out_rec.CARRIER_CODE := FND_API.G_MISS_CHAR;
7794: END IF;
7795: -- J-IB-NPARIKH-}
7796:
7797: ELSIF p_disabled_list(i) = '+SERVICE_LEVEL_NAME' THEN
7809: ELSIF p_disabled_list(i) = '+INTMED_SHIP_TO_LOCATION_CODE' THEN
7810: IF p_in_rec.INTMED_SHIP_TO_LOCATION_ID IS NOT NULL THEN
7811: x_out_rec.INTMED_SHIP_TO_LOCATION_ID :=
7812: p_in_rec.INTMED_SHIP_TO_LOCATION_ID ;
7813: x_out_rec.INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
7814: END IF;
7815: ELSIF p_disabled_list(i) = '+POOLED_SHIP_TO_LOCATION_CODE' THEN
7816: IF p_in_rec.POOLED_SHIP_TO_LOCATION_ID IS NOT NULL THEN
7817: x_out_rec.POOLED_SHIP_TO_LOCATION_ID :=
7815: ELSIF p_disabled_list(i) = '+POOLED_SHIP_TO_LOCATION_CODE' THEN
7816: IF p_in_rec.POOLED_SHIP_TO_LOCATION_ID IS NOT NULL THEN
7817: x_out_rec.POOLED_SHIP_TO_LOCATION_ID :=
7818: p_in_rec.POOLED_SHIP_TO_LOCATION_ID ;
7819: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
7820: END IF;
7821: ELSIF p_disabled_list(i) = '+WAYBILL' THEN
7822: IF p_in_rec.WAYBILL IS NOT NULL THEN
7823: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
7824: END IF;
7825: ELSIF p_disabled_list(i) = '+FREIGHT_TERMS_NAME' THEN
7826: IF p_in_rec.FREIGHT_TERMS_CODE IS NOT NULL THEN
7827: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE ;
7828: x_out_rec.FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
7829: END IF;
7830: ELSIF p_disabled_list(i) = '+GROSS_WEIGHT' THEN
7831: IF p_in_rec.GROSS_WEIGHT IS NOT NULL THEN
7832: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
7845: END IF;
7846: ELSIF p_disabled_list(i) = '+VOLUME_UOM_CODE' THEN
7847: IF p_in_rec.VOLUME_UOM_CODE IS NOT NULL THEN
7848: x_out_rec.VOLUME_UOM_CODE := p_in_rec.VOLUME_UOM_CODE ;
7849: x_out_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
7850: END IF;
7851: ELSIF p_disabled_list(i) = '+FOB_NAME' THEN
7852: IF p_in_rec.FOB_CODE IS NOT NULL THEN
7853: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
7850: END IF;
7851: ELSIF p_disabled_list(i) = '+FOB_NAME' THEN
7852: IF p_in_rec.FOB_CODE IS NOT NULL THEN
7853: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
7854: x_out_rec.FOB_NAME := FND_API.G_MISS_CHAR;
7855: END IF;
7856: ELSIF p_disabled_list(i) = '+FOB_LOCATION_CODE' THEN
7857: IF p_in_rec.FOB_LOCATION_ID IS NOT NULL THEN
7858: x_out_rec.FOB_LOCATION_ID := p_in_rec.FOB_LOCATION_ID ;
7855: END IF;
7856: ELSIF p_disabled_list(i) = '+FOB_LOCATION_CODE' THEN
7857: IF p_in_rec.FOB_LOCATION_ID IS NOT NULL THEN
7858: x_out_rec.FOB_LOCATION_ID := p_in_rec.FOB_LOCATION_ID ;
7859: x_out_rec.FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
7860: END IF;
7861: ELSIF p_disabled_list(i) = '+AUTO_SC_EXCLUDE_FLAG' THEN
7862: IF p_in_rec.AUTO_SC_EXCLUDE_FLAG IS NOT NULL THEN
7863: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
8035: x_out_rec.CONFIRMED_BY := p_in_rec.CONFIRMED_BY ;
8036: ELSIF p_disabled_list(i) = 'INITIAL_PICKUP_LOCATION_CODE' THEN
8037: x_out_rec.INITIAL_PICKUP_LOCATION_ID :=
8038: p_in_rec.INITIAL_PICKUP_LOCATION_ID ;
8039: x_out_rec.INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
8040: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_LOCATION_CODE' THEN
8041: x_out_rec.ULTIMATE_DROPOFF_LOCATION_ID :=
8042: p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID ;
8043: x_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE := FND_API.G_MISS_CHAR;
8039: x_out_rec.INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
8040: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_LOCATION_CODE' THEN
8041: x_out_rec.ULTIMATE_DROPOFF_LOCATION_ID :=
8042: p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID ;
8043: x_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE := FND_API.G_MISS_CHAR;
8044: ELSIF p_disabled_list(i) = 'CUSTOMER_NAME' THEN
8045: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
8046: x_out_rec.customer_number := FND_API.G_MISS_CHAR;
8047: ELSIF p_disabled_list(i) = 'ORGANIZATION_CODE' THEN
8042: p_in_rec.ULTIMATE_DROPOFF_LOCATION_ID ;
8043: x_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE := FND_API.G_MISS_CHAR;
8044: ELSIF p_disabled_list(i) = 'CUSTOMER_NAME' THEN
8045: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
8046: x_out_rec.customer_number := FND_API.G_MISS_CHAR;
8047: ELSIF p_disabled_list(i) = 'ORGANIZATION_CODE' THEN
8048: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
8049: x_out_rec.ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
8050: ELSIF p_disabled_list(i) = 'LOADING_ORDER_FLAG' THEN
8045: x_out_rec.CUSTOMER_ID := p_in_rec.CUSTOMER_ID ;
8046: x_out_rec.customer_number := FND_API.G_MISS_CHAR;
8047: ELSIF p_disabled_list(i) = 'ORGANIZATION_CODE' THEN
8048: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
8049: x_out_rec.ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
8050: ELSIF p_disabled_list(i) = 'LOADING_ORDER_FLAG' THEN
8051: x_out_rec.LOADING_ORDER_FLAG := p_in_rec.LOADING_ORDER_FLAG ;
8052: x_out_rec.LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
8053: ELSIF p_disabled_list(i) = 'ACCEPTANCE_FLAG' THEN
8048: x_out_rec.ORGANIZATION_ID := p_in_rec.ORGANIZATION_ID ;
8049: x_out_rec.ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
8050: ELSIF p_disabled_list(i) = 'LOADING_ORDER_FLAG' THEN
8051: x_out_rec.LOADING_ORDER_FLAG := p_in_rec.LOADING_ORDER_FLAG ;
8052: x_out_rec.LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
8053: ELSIF p_disabled_list(i) = 'ACCEPTANCE_FLAG' THEN
8054: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
8055: ELSIF p_disabled_list(i) = 'ACCEPTED_BY' THEN
8056: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
8059: ELSIF p_disabled_list(i) = 'ACKNOWLEDGED_BY' THEN
8060: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
8061: ELSIF p_disabled_list(i) = 'CURRENCY_CODE' THEN
8062: x_out_rec.CURRENCY_CODE := p_in_rec.CURRENCY_CODE ;
8063: x_out_rec.currency_name := FND_API.G_MISS_CHAR;
8064: ELSIF p_disabled_list(i) = 'INITIAL_PICKUP_DATE' THEN
8065: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8066: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_DATE' THEN
8067: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
8068: ELSIF p_disabled_list(i) = 'LOADING_SEQUENCE' THEN
8069: x_out_rec.LOADING_SEQUENCE := p_in_rec.LOADING_SEQUENCE ;
8070: ELSIF p_disabled_list(i) = 'SHIP_METHOD_NAME' THEN
8071: x_out_rec.SHIP_METHOD_CODE := p_in_rec.SHIP_METHOD_CODE ;
8072: x_out_rec.SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
8073: ELSIF p_disabled_list(i) = 'FREIGHT_CODE' THEN
8074: IF (nvl(p_caller, '!!!!') <> 'WSH_INBOUND') THEN
8075: --x_out_rec.carrier_code := p_in_rec.carrier_code ; -- J-IB-NPARIKH--I-bug-fix
8076: x_out_rec.carrier_id := p_in_rec.carrier_id ; -- J-IB-NPARIKH--I-bug-fix
8073: ELSIF p_disabled_list(i) = 'FREIGHT_CODE' THEN
8074: IF (nvl(p_caller, '!!!!') <> 'WSH_INBOUND') THEN
8075: --x_out_rec.carrier_code := p_in_rec.carrier_code ; -- J-IB-NPARIKH--I-bug-fix
8076: x_out_rec.carrier_id := p_in_rec.carrier_id ; -- J-IB-NPARIKH--I-bug-fix
8077: x_out_rec.CARRIER_CODE := FND_API.G_MISS_CHAR; -- J-IB-NPARIKH--I-bug-fix
8078: END IF;
8079: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL_NAME' THEN
8080: IF (nvl(p_caller, '!!!!') <> 'WSH_INBOUND') THEN
8081: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
8088: x_out_rec.NAME := p_in_rec.NAME ;
8089: ELSIF p_disabled_list(i) = 'INTMED_SHIP_TO_LOCATION_CODE' THEN
8090: x_out_rec.INTMED_SHIP_TO_LOCATION_ID :=
8091: p_in_rec.INTMED_SHIP_TO_LOCATION_ID ;
8092: x_out_rec.INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8093: ELSIF p_disabled_list(i) = 'POOLED_SHIP_TO_LOCATION_CODE' THEN
8094: x_out_rec.POOLED_SHIP_TO_LOCATION_ID :=
8095: p_in_rec.POOLED_SHIP_TO_LOCATION_ID ;
8096: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8092: x_out_rec.INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8093: ELSIF p_disabled_list(i) = 'POOLED_SHIP_TO_LOCATION_CODE' THEN
8094: x_out_rec.POOLED_SHIP_TO_LOCATION_ID :=
8095: p_in_rec.POOLED_SHIP_TO_LOCATION_ID ;
8096: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
8097: ELSIF p_disabled_list(i) = 'WAYBILL' THEN
8098: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
8099: ELSIF p_disabled_list(i) = 'FREIGHT_TERMS_NAME' THEN
8100: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE ;
8097: ELSIF p_disabled_list(i) = 'WAYBILL' THEN
8098: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
8099: ELSIF p_disabled_list(i) = 'FREIGHT_TERMS_NAME' THEN
8100: x_out_rec.FREIGHT_TERMS_CODE := p_in_rec.FREIGHT_TERMS_CODE ;
8101: x_out_rec.FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
8102: ELSIF p_disabled_list(i) = 'GROSS_WEIGHT' THEN
8103: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
8104: ELSIF p_disabled_list(i) = 'NET_WEIGHT' THEN
8105: x_out_rec.NET_WEIGHT := p_in_rec.NET_WEIGHT ;
8108: x_out_rec.PRORATE_WT_FLAG := p_in_rec.PRORATE_WT_FLAG ;
8109: --
8110: ELSIF p_disabled_list(i) = 'WEIGHT_UOM_CODE' THEN
8111: x_out_rec.WEIGHT_UOM_CODE := p_in_rec.WEIGHT_UOM_CODE ;
8112: x_out_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
8113: ELSIF p_disabled_list(i) = 'VOLUME' THEN
8114: x_out_rec.VOLUME := p_in_rec.VOLUME ;
8115: ELSIF p_disabled_list(i) = 'VOLUME_UOM_CODE' THEN
8116: x_out_rec.VOLUME_UOM_CODE := p_in_rec.VOLUME_UOM_CODE ;
8113: ELSIF p_disabled_list(i) = 'VOLUME' THEN
8114: x_out_rec.VOLUME := p_in_rec.VOLUME ;
8115: ELSIF p_disabled_list(i) = 'VOLUME_UOM_CODE' THEN
8116: x_out_rec.VOLUME_UOM_CODE := p_in_rec.VOLUME_UOM_CODE ;
8117: x_out_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
8118: ELSIF p_disabled_list(i) = 'FOB_NAME' THEN
8119: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
8120: x_out_rec.FOB_NAME := FND_API.G_MISS_CHAR;
8121: ELSIF p_disabled_list(i) = 'FOB_LOCATION_CODE' THEN
8116: x_out_rec.VOLUME_UOM_CODE := p_in_rec.VOLUME_UOM_CODE ;
8117: x_out_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
8118: ELSIF p_disabled_list(i) = 'FOB_NAME' THEN
8119: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
8120: x_out_rec.FOB_NAME := FND_API.G_MISS_CHAR;
8121: ELSIF p_disabled_list(i) = 'FOB_LOCATION_CODE' THEN
8122: x_out_rec.FOB_LOCATION_ID := p_in_rec.FOB_LOCATION_ID ;
8123: x_out_rec.FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
8124: ELSIF p_disabled_list(i) = 'NUMBER_OF_LPN' THEN
8119: x_out_rec.FOB_CODE := p_in_rec.FOB_CODE ;
8120: x_out_rec.FOB_NAME := FND_API.G_MISS_CHAR;
8121: ELSIF p_disabled_list(i) = 'FOB_LOCATION_CODE' THEN
8122: x_out_rec.FOB_LOCATION_ID := p_in_rec.FOB_LOCATION_ID ;
8123: x_out_rec.FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
8124: ELSIF p_disabled_list(i) = 'NUMBER_OF_LPN' THEN
8125: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
8126: ELSIF p_disabled_list(i) = 'AUTO_SC_EXCLUDE_FLAG' THEN
8127: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
8209: BEGIN
8210:
8211: IF p_mode = '+' THEN
8212: IF x_internal IS NULL THEN
8213: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
8214: x_internal := p_internal ;
8215: IF p_internal IS NULL THEN
8216: x_external := NULL;
8217: ELSE
8216: x_external := NULL;
8217: ELSE
8218: x_external := p_external;
8219: END IF;
8220: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
8221: x_external := p_external;
8222: IF p_external IS NULL THEN
8223: x_internal := NULL;
8224: ELSE
8226: END IF;
8227: END IF;
8228: END IF;
8229: ELSE --p_mode <> +
8230: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
8231: x_internal := p_internal ;
8232: IF p_internal IS NULL THEN
8233: x_external := NULL;
8234: ELSE
8233: x_external := NULL;
8234: ELSE
8235: x_external := p_external;
8236: END IF;
8237: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
8238: x_external := p_external;
8239: IF p_external IS NULL THEN
8240: x_internal := NULL;
8241: ELSE
8263: BEGIN
8264:
8265: IF p_mode = '+' THEN
8266: IF x_internal IS NULL THEN
8267: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
8268: x_internal := p_internal ;
8269: IF p_internal IS NULL THEN
8270: x_external := NULL;
8271: ELSE
8270: x_external := NULL;
8271: ELSE
8272: x_external := p_external;
8273: END IF;
8274: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
8275: x_external := p_external;
8276: IF p_external IS NULL THEN
8277: x_internal := NULL;
8278: ELSE
8280: END IF;
8281: END IF;
8282: END IF;
8283: ELSE --p_mode <> +
8284: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
8285: x_internal := p_internal ;
8286: IF p_internal IS NULL THEN
8287: x_external := NULL;
8288: ELSE
8287: x_external := NULL;
8288: ELSE
8289: x_external := p_external;
8290: END IF;
8291: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
8292: x_external := p_external;
8293: IF p_external IS NULL THEN
8294: x_internal := NULL;
8295: ELSE
8320: LOOP
8321: l_prefix := SUBSTR(p_disabled_list(i),1,1);
8322: IF l_prefix = '+' THEN
8323: IF p_disabled_list(i) = '+ADDITIONAL_SHIPMENT_INFO' THEN
8324: IF p_in_rec.ADDITIONAL_SHIPMENT_INFO <> FND_API.G_MISS_CHAR
8325: OR p_in_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
8326: IF x_out_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
8327: x_out_rec.ADDITIONAL_SHIPMENT_INFO := p_in_rec.ADDITIONAL_SHIPMENT_INFO ;
8328: END IF;
8327: x_out_rec.ADDITIONAL_SHIPMENT_INFO := p_in_rec.ADDITIONAL_SHIPMENT_INFO ;
8328: END IF;
8329: END IF;
8330: ELSIF p_disabled_list(i) = '+DOCK_CODE' THEN
8331: IF p_in_rec.DOCK_CODE <> FND_API.G_MISS_CHAR
8332: OR p_in_rec.DOCK_CODE IS NULL THEN
8333: IF x_out_rec.DOCK_CODE IS NULL THEN
8334: x_out_rec.DOCK_CODE := p_in_rec.DOCK_CODE ;
8335: END IF;
8369: x_out_rec.loading_order_flag,
8370: x_out_rec.loading_order_desc);
8371:
8372: ELSIF p_disabled_list(i) = '+ACCEPTANCE_FLAG' THEN
8373: IF p_in_rec.ACCEPTANCE_FLAG <> FND_API.G_MISS_CHAR
8374: OR p_in_rec.ACCEPTANCE_FLAG IS NULL THEN
8375: IF x_out_rec.ACCEPTANCE_FLAG IS NULL THEN
8376: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
8377: END IF;
8376: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
8377: END IF;
8378: END IF;
8379: ELSIF p_disabled_list(i) = '+ACCEPTED_BY' THEN
8380: IF p_in_rec.ACCEPTED_BY <> FND_API.G_MISS_CHAR
8381: OR p_in_rec.ACCEPTED_BY IS NULL THEN
8382: IF x_out_rec.ACCEPTED_BY IS NULL THEN
8383: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
8384: END IF;
8383: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
8384: END IF;
8385: END IF;
8386: ELSIF p_disabled_list(i) = '+ACCEPTED_DATE' THEN
8387: IF p_in_rec.ACCEPTED_DATE <> FND_API.G_MISS_DATE
8388: OR p_in_rec.ACCEPTED_DATE IS NULL THEN
8389: IF x_out_rec.ACCEPTED_DATE IS NULL THEN
8390: x_out_rec.ACCEPTED_DATE := p_in_rec.ACCEPTED_DATE ;
8391: END IF;
8390: x_out_rec.ACCEPTED_DATE := p_in_rec.ACCEPTED_DATE ;
8391: END IF;
8392: END IF;
8393: ELSIF p_disabled_list(i) = '+ACKNOWLEDGED_BY' THEN
8394: IF p_in_rec.ACKNOWLEDGED_BY <> FND_API.G_MISS_CHAR
8395: OR p_in_rec.ACKNOWLEDGED_BY IS NULL THEN
8396: IF x_out_rec.ACKNOWLEDGED_BY IS NULL THEN
8397: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
8398: END IF;
8397: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
8398: END IF;
8399: END IF;
8400: ELSIF p_disabled_list(i) = '+CONFIRMED_BY' THEN
8401: IF p_in_rec.CONFIRMED_BY <> FND_API.G_MISS_CHAR
8402: OR p_in_rec.CONFIRMED_BY IS NULL THEN
8403: IF x_out_rec.CONFIRMED_BY IS NULL THEN
8404: x_out_rec.CONFIRMED_BY := p_in_rec.CONFIRMED_BY ;
8405: END IF;
8411: x_out_rec.currency_code,
8412: x_out_rec.currency_name);
8413:
8414: ELSIF p_disabled_list(i) = '+INITIAL_PICKUP_DATE' THEN
8415: IF p_in_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE
8416: OR p_in_rec.INITIAL_PICKUP_DATE IS NULL THEN
8417: IF x_out_rec.INITIAL_PICKUP_DATE IS NULL THEN
8418: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8419: END IF;
8418: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8419: END IF;
8420: END IF;
8421: ELSIF p_disabled_list(i) = '+ULTIMATE_DROPOFF_DATE' THEN
8422: IF p_in_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE
8423: OR p_in_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
8424: IF x_out_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
8425: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
8426: END IF;
8425: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
8426: END IF;
8427: END IF;
8428: ELSIF p_disabled_list(i) = '+LOADING_SEQUENCE' THEN
8429: IF p_in_rec.LOADING_SEQUENCE <> FND_API.G_MISS_NUM
8430: OR p_in_rec.LOADING_SEQUENCE IS NULL THEN
8431: IF x_out_rec.LOADING_SEQUENCE IS NULL THEN
8432: x_out_rec.LOADING_SEQUENCE := p_in_rec.LOADING_SEQUENCE ;
8433: END IF;
8448: x_out_rec.carrier_code);
8449: -- J-IB-NPARIKH-}
8450:
8451: ELSIF p_disabled_list(i) = '+SERVICE_LEVEL_NAME' THEN
8452: IF p_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
8453: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
8454: IF x_out_rec.SERVICE_LEVEL IS NULL THEN
8455: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
8456: END IF;
8455: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
8456: END IF;
8457: END IF;
8458: ELSIF p_disabled_list(i) = '+MODE_OF_TRANSPORT_NAME' THEN
8459: IF p_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
8460: OR p_in_rec.MODE_OF_TRANSPORT IS NULL THEN
8461: IF x_out_rec.MODE_OF_TRANSPORT IS NULL THEN
8462: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
8463: END IF;
8462: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
8463: END IF;
8464: END IF;
8465: ELSIF p_disabled_list(i) = '+NAME' THEN
8466: IF p_in_rec.NAME <> FND_API.G_MISS_CHAR
8467: OR p_in_rec.NAME IS NULL THEN
8468: IF x_out_rec.NAME IS NULL THEN
8469: x_out_rec.NAME := p_in_rec.NAME ;
8470: END IF;
8483: x_out_rec.POOLED_SHIP_TO_LOCATION_ID,
8484: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE);
8485:
8486: ELSIF p_disabled_list(i) = '+WAYBILL' THEN
8487: IF p_in_rec.WAYBILL <> FND_API.G_MISS_CHAR
8488: OR p_in_rec.WAYBILL IS NULL THEN
8489: IF x_out_rec.WAYBILL IS NULL THEN
8490: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
8491: END IF;
8497: x_out_rec.FREIGHT_TERMS_CODE,
8498: x_out_rec.FREIGHT_TERMS_NAME);
8499:
8500: ELSIF p_disabled_list(i) = '+GROSS_WEIGHT' THEN
8501: IF p_in_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
8502: OR p_in_rec.GROSS_WEIGHT IS NULL THEN
8503: IF x_out_rec.GROSS_WEIGHT IS NULL THEN
8504: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
8505: END IF;
8504: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
8505: END IF;
8506: END IF;
8507: ELSIF p_disabled_list(i) = '+NET_WEIGHT' THEN
8508: IF p_in_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
8509: OR p_in_rec.NET_WEIGHT IS NULL THEN
8510: IF x_out_rec.NET_WEIGHT IS NULL THEN
8511: x_out_rec.NET_WEIGHT := p_in_rec.NET_WEIGHT ;
8512: END IF;
8518: x_out_rec.WEIGHT_UOM_CODE,
8519: x_out_rec.WEIGHT_UOM_DESC);
8520:
8521: ELSIF p_disabled_list(i) = '+VOLUME' THEN
8522: IF p_in_rec.VOLUME <> FND_API.G_MISS_NUM
8523: OR p_in_rec.VOLUME IS NULL THEN
8524: IF x_out_rec.VOLUME IS NULL THEN
8525: x_out_rec.VOLUME := p_in_rec.VOLUME ;
8526: END IF;
8546: x_out_rec.FOB_LOCATION_ID,
8547: x_out_rec.FOB_LOCATION_CODE);
8548:
8549: ELSIF p_disabled_list(i) = '+NUMBER_OF_LPN' THEN
8550: IF p_in_rec.NUMBER_OF_LPN <> FND_API.G_MISS_NUM
8551: OR p_in_rec.NUMBER_OF_LPN IS NULL THEN
8552: IF x_out_rec.NUMBER_OF_LPN IS NULL THEN
8553: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
8554: END IF;
8553: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
8554: END IF;
8555: END IF;
8556: ELSIF p_disabled_list(i) = '+AUTO_SC_EXCLUDE_FLAG' THEN
8557: IF p_in_rec.AUTO_SC_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
8558: OR p_in_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
8559: IF x_out_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
8560: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
8561: END IF;
8560: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
8561: END IF;
8562: END IF;
8563: ELSIF p_disabled_list(i) = '+AUTO_AP_EXCLUDE_FLAG' THEN
8564: IF p_in_rec.AUTO_AP_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
8565: OR p_in_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
8566: IF x_out_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
8567: x_out_rec.AUTO_AP_EXCLUDE_FLAG := p_in_rec.AUTO_AP_EXCLUDE_FLAG ;
8568: END IF;
8567: x_out_rec.AUTO_AP_EXCLUDE_FLAG := p_in_rec.AUTO_AP_EXCLUDE_FLAG ;
8568: END IF;
8569: END IF;
8570: ELSIF p_disabled_list(i) = '+DESC_FLEX' THEN
8571: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
8572: OR p_in_rec.attribute1 IS NULL THEN
8573: IF x_out_rec.attribute1 IS NULL THEN
8574: x_out_rec.attribute1 := p_in_rec.attribute1 ;
8575: END IF;
8573: IF x_out_rec.attribute1 IS NULL THEN
8574: x_out_rec.attribute1 := p_in_rec.attribute1 ;
8575: END IF;
8576: END IF;
8577: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
8578: OR p_in_rec.attribute2 IS NULL THEN
8579: IF x_out_rec.attribute2 IS NULL THEN
8580: x_out_rec.attribute2 := p_in_rec.attribute2 ;
8581: END IF;
8579: IF x_out_rec.attribute2 IS NULL THEN
8580: x_out_rec.attribute2 := p_in_rec.attribute2 ;
8581: END IF;
8582: END IF;
8583: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
8584: OR p_in_rec.attribute3 IS NULL THEN
8585: IF x_out_rec.attribute3 IS NULL THEN
8586: x_out_rec.attribute3 := p_in_rec.attribute3 ;
8587: END IF;
8585: IF x_out_rec.attribute3 IS NULL THEN
8586: x_out_rec.attribute3 := p_in_rec.attribute3 ;
8587: END IF;
8588: END IF;
8589: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
8590: OR p_in_rec.attribute4 IS NULL THEN
8591: IF x_out_rec.attribute4 IS NULL THEN
8592: x_out_rec.attribute4 := p_in_rec.attribute4 ;
8593: END IF;
8591: IF x_out_rec.attribute4 IS NULL THEN
8592: x_out_rec.attribute4 := p_in_rec.attribute4 ;
8593: END IF;
8594: END IF;
8595: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
8596: OR p_in_rec.attribute5 IS NULL THEN
8597: IF x_out_rec.attribute5 IS NULL THEN
8598: x_out_rec.attribute5 := p_in_rec.attribute5 ;
8599: END IF;
8597: IF x_out_rec.attribute5 IS NULL THEN
8598: x_out_rec.attribute5 := p_in_rec.attribute5 ;
8599: END IF;
8600: END IF;
8601: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
8602: OR p_in_rec.attribute6 IS NULL THEN
8603: IF x_out_rec.attribute6 IS NULL THEN
8604: x_out_rec.attribute6 := p_in_rec.attribute6 ;
8605: END IF;
8603: IF x_out_rec.attribute6 IS NULL THEN
8604: x_out_rec.attribute6 := p_in_rec.attribute6 ;
8605: END IF;
8606: END IF;
8607: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
8608: OR p_in_rec.attribute7 IS NULL THEN
8609: IF x_out_rec.attribute7 IS NULL THEN
8610: x_out_rec.attribute7 := p_in_rec.attribute7 ;
8611: END IF;
8609: IF x_out_rec.attribute7 IS NULL THEN
8610: x_out_rec.attribute7 := p_in_rec.attribute7 ;
8611: END IF;
8612: END IF;
8613: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
8614: OR p_in_rec.attribute8 IS NULL THEN
8615: IF x_out_rec.attribute8 IS NULL THEN
8616: x_out_rec.attribute8 := p_in_rec.attribute8 ;
8617: END IF;
8615: IF x_out_rec.attribute8 IS NULL THEN
8616: x_out_rec.attribute8 := p_in_rec.attribute8 ;
8617: END IF;
8618: END IF;
8619: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
8620: OR p_in_rec.attribute9 IS NULL THEN
8621: IF x_out_rec.attribute9 IS NULL THEN
8622: x_out_rec.attribute9 := p_in_rec.attribute9 ;
8623: END IF;
8621: IF x_out_rec.attribute9 IS NULL THEN
8622: x_out_rec.attribute9 := p_in_rec.attribute9 ;
8623: END IF;
8624: END IF;
8625: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
8626: OR p_in_rec.attribute10 IS NULL THEN
8627: IF x_out_rec.attribute10 IS NULL THEN
8628: x_out_rec.attribute10 := p_in_rec.attribute10 ;
8629: END IF;
8627: IF x_out_rec.attribute10 IS NULL THEN
8628: x_out_rec.attribute10 := p_in_rec.attribute10 ;
8629: END IF;
8630: END IF;
8631: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
8632: OR p_in_rec.attribute11 IS NULL THEN
8633: IF x_out_rec.attribute11 IS NULL THEN
8634: x_out_rec.attribute11 := p_in_rec.attribute11 ;
8635: END IF;
8633: IF x_out_rec.attribute11 IS NULL THEN
8634: x_out_rec.attribute11 := p_in_rec.attribute11 ;
8635: END IF;
8636: END IF;
8637: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
8638: OR p_in_rec.attribute12 IS NULL THEN
8639: IF x_out_rec.attribute12 IS NULL THEN
8640: x_out_rec.attribute12 := p_in_rec.attribute12 ;
8641: END IF;
8639: IF x_out_rec.attribute12 IS NULL THEN
8640: x_out_rec.attribute12 := p_in_rec.attribute12 ;
8641: END IF;
8642: END IF;
8643: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
8644: OR p_in_rec.attribute13 IS NULL THEN
8645: IF x_out_rec.attribute13 IS NULL THEN
8646: x_out_rec.attribute13 := p_in_rec.attribute13 ;
8647: END IF;
8645: IF x_out_rec.attribute13 IS NULL THEN
8646: x_out_rec.attribute13 := p_in_rec.attribute13 ;
8647: END IF;
8648: END IF;
8649: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
8650: OR p_in_rec.attribute14 IS NULL THEN
8651: IF x_out_rec.attribute14 IS NULL THEN
8652: x_out_rec.attribute14 := p_in_rec.attribute14 ;
8653: END IF;
8651: IF x_out_rec.attribute14 IS NULL THEN
8652: x_out_rec.attribute14 := p_in_rec.attribute14 ;
8653: END IF;
8654: END IF;
8655: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
8656: OR p_in_rec.attribute15 IS NULL THEN
8657: IF x_out_rec.attribute15 IS NULL THEN
8658: x_out_rec.attribute15 := p_in_rec.attribute15 ;
8659: END IF;
8657: IF x_out_rec.attribute15 IS NULL THEN
8658: x_out_rec.attribute15 := p_in_rec.attribute15 ;
8659: END IF;
8660: END IF;
8661: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
8662: OR p_in_rec.attribute_category IS NULL THEN
8663: IF x_out_rec.attribute_category IS NULL THEN
8664: x_out_rec.attribute_category := p_in_rec.attribute_category ;
8665: END IF;
8664: x_out_rec.attribute_category := p_in_rec.attribute_category ;
8665: END IF;
8666: END IF;
8667: ELSIF p_disabled_list(i) = '+TP_FLEXFIELD' THEN
8668: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
8669: OR p_in_rec.tp_attribute1 IS NULL THEN
8670: IF x_out_rec.tp_attribute1 IS NULL THEN
8671: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
8672: END IF;
8670: IF x_out_rec.tp_attribute1 IS NULL THEN
8671: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
8672: END IF;
8673: END IF;
8674: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
8675: OR p_in_rec.tp_attribute2 IS NULL THEN
8676: IF x_out_rec.tp_attribute2 IS NULL THEN
8677: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
8678: END IF;
8676: IF x_out_rec.tp_attribute2 IS NULL THEN
8677: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
8678: END IF;
8679: END IF;
8680: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
8681: OR p_in_rec.tp_attribute3 IS NULL THEN
8682: IF x_out_rec.tp_attribute3 IS NULL THEN
8683: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
8684: END IF;
8682: IF x_out_rec.tp_attribute3 IS NULL THEN
8683: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
8684: END IF;
8685: END IF;
8686: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
8687: OR p_in_rec.tp_attribute4 IS NULL THEN
8688: IF x_out_rec.tp_attribute4 IS NULL THEN
8689: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
8690: END IF;
8688: IF x_out_rec.tp_attribute4 IS NULL THEN
8689: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
8690: END IF;
8691: END IF;
8692: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
8693: OR p_in_rec.tp_attribute5 IS NULL THEN
8694: IF x_out_rec.tp_attribute5 IS NULL THEN
8695: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
8696: END IF;
8694: IF x_out_rec.tp_attribute5 IS NULL THEN
8695: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
8696: END IF;
8697: END IF;
8698: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
8699: OR p_in_rec.tp_attribute6 IS NULL THEN
8700: IF x_out_rec.tp_attribute6 IS NULL THEN
8701: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
8702: END IF;
8700: IF x_out_rec.tp_attribute6 IS NULL THEN
8701: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
8702: END IF;
8703: END IF;
8704: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
8705: OR p_in_rec.tp_attribute7 IS NULL THEN
8706: IF x_out_rec.tp_attribute7 IS NULL THEN
8707: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
8708: END IF;
8706: IF x_out_rec.tp_attribute7 IS NULL THEN
8707: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
8708: END IF;
8709: END IF;
8710: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
8711: OR p_in_rec.tp_attribute8 IS NULL THEN
8712: IF x_out_rec.tp_attribute8 IS NULL THEN
8713: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
8714: END IF;
8712: IF x_out_rec.tp_attribute8 IS NULL THEN
8713: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
8714: END IF;
8715: END IF;
8716: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
8717: OR p_in_rec.tp_attribute9 IS NULL THEN
8718: IF x_out_rec.tp_attribute9 IS NULL THEN
8719: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
8720: END IF;
8718: IF x_out_rec.tp_attribute9 IS NULL THEN
8719: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
8720: END IF;
8721: END IF;
8722: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
8723: OR p_in_rec.tp_attribute10 IS NULL THEN
8724: IF x_out_rec.tp_attribute10 IS NULL THEN
8725: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
8726: END IF;
8724: IF x_out_rec.tp_attribute10 IS NULL THEN
8725: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
8726: END IF;
8727: END IF;
8728: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
8729: OR p_in_rec.tp_attribute11 IS NULL THEN
8730: IF x_out_rec.tp_attribute11 IS NULL THEN
8731: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
8732: END IF;
8730: IF x_out_rec.tp_attribute11 IS NULL THEN
8731: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
8732: END IF;
8733: END IF;
8734: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
8735: OR p_in_rec.tp_attribute12 IS NULL THEN
8736: IF x_out_rec.tp_attribute12 IS NULL THEN
8737: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
8738: END IF;
8736: IF x_out_rec.tp_attribute12 IS NULL THEN
8737: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
8738: END IF;
8739: END IF;
8740: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
8741: OR p_in_rec.tp_attribute13 IS NULL THEN
8742: IF x_out_rec.tp_attribute13 IS NULL THEN
8743: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
8744: END IF;
8742: IF x_out_rec.tp_attribute13 IS NULL THEN
8743: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
8744: END IF;
8745: END IF;
8746: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
8747: OR p_in_rec.tp_attribute14 IS NULL THEN
8748: IF x_out_rec.tp_attribute14 IS NULL THEN
8749: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
8750: END IF;
8748: IF x_out_rec.tp_attribute14 IS NULL THEN
8749: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
8750: END IF;
8751: END IF;
8752: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
8753: OR p_in_rec.tp_attribute15 IS NULL THEN
8754: IF x_out_rec.tp_attribute15 IS NULL THEN
8755: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
8756: END IF;
8754: IF x_out_rec.tp_attribute15 IS NULL THEN
8755: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
8756: END IF;
8757: END IF;
8758: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
8759: OR p_in_rec.tp_attribute_category IS NULL THEN
8760: IF x_out_rec.tp_attribute_category IS NULL THEN
8761: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
8762: END IF;
8761: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
8762: END IF;
8763: END IF;
8764: ELSIF p_disabled_list(i) = '+GLOBALIZATION_FLEXFIELD' THEN
8765: IF p_in_rec.global_attribute1 <> FND_API.G_MISS_CHAR
8766: OR p_in_rec.global_attribute1 IS NULL THEN
8767: IF x_out_rec.global_attribute1 IS NULL THEN
8768: x_out_rec.global_attribute1 := p_in_rec.global_attribute1 ;
8769: END IF;
8767: IF x_out_rec.global_attribute1 IS NULL THEN
8768: x_out_rec.global_attribute1 := p_in_rec.global_attribute1 ;
8769: END IF;
8770: END IF;
8771: IF p_in_rec.global_attribute2 <> FND_API.G_MISS_CHAR
8772: OR p_in_rec.global_attribute2 IS NULL THEN
8773: IF x_out_rec.global_attribute2 IS NULL THEN
8774: x_out_rec.global_attribute2 := p_in_rec.global_attribute2 ;
8775: END IF;
8773: IF x_out_rec.global_attribute2 IS NULL THEN
8774: x_out_rec.global_attribute2 := p_in_rec.global_attribute2 ;
8775: END IF;
8776: END IF;
8777: IF p_in_rec.global_attribute3 <> FND_API.G_MISS_CHAR
8778: OR p_in_rec.global_attribute3 IS NULL THEN
8779: IF x_out_rec.global_attribute3 IS NULL THEN
8780: x_out_rec.global_attribute3 := p_in_rec.global_attribute3 ;
8781: END IF;
8779: IF x_out_rec.global_attribute3 IS NULL THEN
8780: x_out_rec.global_attribute3 := p_in_rec.global_attribute3 ;
8781: END IF;
8782: END IF;
8783: IF p_in_rec.global_attribute4 <> FND_API.G_MISS_CHAR
8784: OR p_in_rec.global_attribute4 IS NULL THEN
8785: IF x_out_rec.global_attribute4 IS NULL THEN
8786: x_out_rec.global_attribute4 := p_in_rec.global_attribute4 ;
8787: END IF;
8785: IF x_out_rec.global_attribute4 IS NULL THEN
8786: x_out_rec.global_attribute4 := p_in_rec.global_attribute4 ;
8787: END IF;
8788: END IF;
8789: IF p_in_rec.global_attribute5 <> FND_API.G_MISS_CHAR
8790: OR p_in_rec.global_attribute5 IS NULL THEN
8791: IF x_out_rec.global_attribute5 IS NULL THEN
8792: x_out_rec.global_attribute5 := p_in_rec.global_attribute5 ;
8793: END IF;
8791: IF x_out_rec.global_attribute5 IS NULL THEN
8792: x_out_rec.global_attribute5 := p_in_rec.global_attribute5 ;
8793: END IF;
8794: END IF;
8795: IF p_in_rec.global_attribute6 <> FND_API.G_MISS_CHAR
8796: OR p_in_rec.global_attribute6 IS NULL THEN
8797: IF x_out_rec.global_attribute6 IS NULL THEN
8798: x_out_rec.global_attribute6 := p_in_rec.global_attribute6 ;
8799: END IF;
8797: IF x_out_rec.global_attribute6 IS NULL THEN
8798: x_out_rec.global_attribute6 := p_in_rec.global_attribute6 ;
8799: END IF;
8800: END IF;
8801: IF p_in_rec.global_attribute7 <> FND_API.G_MISS_CHAR
8802: OR p_in_rec.global_attribute7 IS NULL THEN
8803: IF x_out_rec.global_attribute7 IS NULL THEN
8804: x_out_rec.global_attribute7 := p_in_rec.global_attribute7 ;
8805: END IF;
8803: IF x_out_rec.global_attribute7 IS NULL THEN
8804: x_out_rec.global_attribute7 := p_in_rec.global_attribute7 ;
8805: END IF;
8806: END IF;
8807: IF p_in_rec.global_attribute8 <> FND_API.G_MISS_CHAR
8808: OR p_in_rec.global_attribute8 IS NULL THEN
8809: IF x_out_rec.global_attribute8 IS NULL THEN
8810: x_out_rec.global_attribute8 := p_in_rec.global_attribute8 ;
8811: END IF;
8809: IF x_out_rec.global_attribute8 IS NULL THEN
8810: x_out_rec.global_attribute8 := p_in_rec.global_attribute8 ;
8811: END IF;
8812: END IF;
8813: IF p_in_rec.global_attribute9 <> FND_API.G_MISS_CHAR
8814: OR p_in_rec.global_attribute9 IS NULL THEN
8815: IF x_out_rec.global_attribute9 IS NULL THEN
8816: x_out_rec.global_attribute9 := p_in_rec.global_attribute9 ;
8817: END IF;
8815: IF x_out_rec.global_attribute9 IS NULL THEN
8816: x_out_rec.global_attribute9 := p_in_rec.global_attribute9 ;
8817: END IF;
8818: END IF;
8819: IF p_in_rec.global_attribute10 <> FND_API.G_MISS_CHAR
8820: OR p_in_rec.global_attribute10 IS NULL THEN
8821: IF x_out_rec.global_attribute10 IS NULL THEN
8822: x_out_rec.global_attribute10 := p_in_rec.global_attribute10 ;
8823: END IF;
8821: IF x_out_rec.global_attribute10 IS NULL THEN
8822: x_out_rec.global_attribute10 := p_in_rec.global_attribute10 ;
8823: END IF;
8824: END IF;
8825: IF p_in_rec.global_attribute11 <> FND_API.G_MISS_CHAR
8826: OR p_in_rec.global_attribute11 IS NULL THEN
8827: IF x_out_rec.global_attribute11 IS NULL THEN
8828: x_out_rec.global_attribute11 := p_in_rec.global_attribute11 ;
8829: END IF;
8827: IF x_out_rec.global_attribute11 IS NULL THEN
8828: x_out_rec.global_attribute11 := p_in_rec.global_attribute11 ;
8829: END IF;
8830: END IF;
8831: IF p_in_rec.global_attribute12 <> FND_API.G_MISS_CHAR
8832: OR p_in_rec.global_attribute12 IS NULL THEN
8833: IF x_out_rec.global_attribute12 IS NULL THEN
8834: x_out_rec.global_attribute12 := p_in_rec.global_attribute12 ;
8835: END IF;
8833: IF x_out_rec.global_attribute12 IS NULL THEN
8834: x_out_rec.global_attribute12 := p_in_rec.global_attribute12 ;
8835: END IF;
8836: END IF;
8837: IF p_in_rec.global_attribute13 <> FND_API.G_MISS_CHAR
8838: OR p_in_rec.global_attribute13 IS NULL THEN
8839: IF x_out_rec.global_attribute13 IS NULL THEN
8840: x_out_rec.global_attribute13 := p_in_rec.global_attribute13 ;
8841: END IF;
8839: IF x_out_rec.global_attribute13 IS NULL THEN
8840: x_out_rec.global_attribute13 := p_in_rec.global_attribute13 ;
8841: END IF;
8842: END IF;
8843: IF p_in_rec.global_attribute14 <> FND_API.G_MISS_CHAR
8844: OR p_in_rec.global_attribute14 IS NULL THEN
8845: IF x_out_rec.global_attribute14 IS NULL THEN
8846: x_out_rec.global_attribute14 := p_in_rec.global_attribute14 ;
8847: END IF;
8845: IF x_out_rec.global_attribute14 IS NULL THEN
8846: x_out_rec.global_attribute14 := p_in_rec.global_attribute14 ;
8847: END IF;
8848: END IF;
8849: IF p_in_rec.global_attribute15 <> FND_API.G_MISS_CHAR
8850: OR p_in_rec.global_attribute15 IS NULL THEN
8851: IF x_out_rec.global_attribute15 IS NULL THEN
8852: x_out_rec.global_attribute15 := p_in_rec.global_attribute15 ;
8853: END IF;
8851: IF x_out_rec.global_attribute15 IS NULL THEN
8852: x_out_rec.global_attribute15 := p_in_rec.global_attribute15 ;
8853: END IF;
8854: END IF;
8855: IF p_in_rec.global_attribute_category <> FND_API.G_MISS_CHAR
8856: OR p_in_rec.global_attribute_category IS NULL THEN
8857: IF x_out_rec.global_attribute_category IS NULL THEN
8858: x_out_rec.global_attribute_category := p_in_rec.global_attribute_category ;
8859: END IF;
8867: RETURN;
8868: END IF;
8869: ELSE -- if the prefix is not +
8870: IF p_disabled_list(i) = 'ADDITIONAL_SHIPMENT_INFO' THEN
8871: IF p_in_rec.ADDITIONAL_SHIPMENT_INFO <> FND_API.G_MISS_CHAR
8872: OR p_in_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
8873: x_out_rec.ADDITIONAL_SHIPMENT_INFO := p_in_rec.ADDITIONAL_SHIPMENT_INFO ;
8874: END IF;
8875: ELSIF p_disabled_list(i) = 'DOCK_CODE' THEN
8872: OR p_in_rec.ADDITIONAL_SHIPMENT_INFO IS NULL THEN
8873: x_out_rec.ADDITIONAL_SHIPMENT_INFO := p_in_rec.ADDITIONAL_SHIPMENT_INFO ;
8874: END IF;
8875: ELSIF p_disabled_list(i) = 'DOCK_CODE' THEN
8876: IF p_in_rec.DOCK_CODE <> FND_API.G_MISS_CHAR
8877: OR p_in_rec.DOCK_CODE IS NULL THEN
8878: x_out_rec.DOCK_CODE := p_in_rec.DOCK_CODE ;
8879: END IF;
8880: ELSIF p_disabled_list(i) = 'INITIAL_PICKUP_LOCATION_CODE' THEN
8908: NULL,
8909: x_out_rec.loading_order_flag,
8910: x_out_rec.loading_order_desc);
8911: ELSIF p_disabled_list(i) = 'ACCEPTANCE_FLAG' THEN
8912: IF p_in_rec.ACCEPTANCE_FLAG <> FND_API.G_MISS_CHAR
8913: OR p_in_rec.ACCEPTANCE_FLAG IS NULL THEN
8914: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
8915: END IF;
8916: ELSIF p_disabled_list(i) = 'ACCEPTED_BY' THEN
8913: OR p_in_rec.ACCEPTANCE_FLAG IS NULL THEN
8914: x_out_rec.ACCEPTANCE_FLAG := p_in_rec.ACCEPTANCE_FLAG ;
8915: END IF;
8916: ELSIF p_disabled_list(i) = 'ACCEPTED_BY' THEN
8917: IF p_in_rec.ACCEPTED_BY <> FND_API.G_MISS_CHAR
8918: OR p_in_rec.ACCEPTED_BY IS NULL THEN
8919: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
8920: END IF;
8921: ELSIF p_disabled_list(i) = 'ACCEPTED_DATE' THEN
8918: OR p_in_rec.ACCEPTED_BY IS NULL THEN
8919: x_out_rec.ACCEPTED_BY := p_in_rec.ACCEPTED_BY ;
8920: END IF;
8921: ELSIF p_disabled_list(i) = 'ACCEPTED_DATE' THEN
8922: IF p_in_rec.ACCEPTED_DATE <> FND_API.G_MISS_DATE
8923: OR p_in_rec.ACCEPTED_DATE IS NULL THEN
8924: x_out_rec.ACCEPTED_DATE := p_in_rec.ACCEPTED_DATE ;
8925: END IF;
8926: ELSIF p_disabled_list(i) = 'ACKNOWLEDGED_BY' THEN
8923: OR p_in_rec.ACCEPTED_DATE IS NULL THEN
8924: x_out_rec.ACCEPTED_DATE := p_in_rec.ACCEPTED_DATE ;
8925: END IF;
8926: ELSIF p_disabled_list(i) = 'ACKNOWLEDGED_BY' THEN
8927: IF p_in_rec.ACKNOWLEDGED_BY <> FND_API.G_MISS_CHAR
8928: OR p_in_rec.ACKNOWLEDGED_BY IS NULL THEN
8929: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
8930: END IF;
8931: ELSIF p_disabled_list(i) = 'CONFIRMED_BY' THEN
8928: OR p_in_rec.ACKNOWLEDGED_BY IS NULL THEN
8929: x_out_rec.ACKNOWLEDGED_BY := p_in_rec.ACKNOWLEDGED_BY ;
8930: END IF;
8931: ELSIF p_disabled_list(i) = 'CONFIRMED_BY' THEN
8932: IF p_in_rec.CONFIRMED_BY <> FND_API.G_MISS_CHAR
8933: OR p_in_rec.CONFIRMED_BY IS NULL THEN
8934: x_out_rec.CONFIRMED_BY := p_in_rec.CONFIRMED_BY ;
8935: END IF;
8936: ELSIF p_disabled_list(i) = 'CURRENCY_CODE' THEN
8939: NULL,
8940: x_out_rec.currency_code,
8941: x_out_rec.currency_name);
8942: ELSIF p_disabled_list(i) = 'INITIAL_PICKUP_DATE' THEN
8943: IF p_in_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE
8944: OR p_in_rec.INITIAL_PICKUP_DATE IS NULL THEN
8945: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8946: END IF;
8947: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_DATE' THEN
8944: OR p_in_rec.INITIAL_PICKUP_DATE IS NULL THEN
8945: x_out_rec.INITIAL_PICKUP_DATE := p_in_rec.INITIAL_PICKUP_DATE ;
8946: END IF;
8947: ELSIF p_disabled_list(i) = 'ULTIMATE_DROPOFF_DATE' THEN
8948: IF p_in_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE
8949: OR p_in_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
8950: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
8951: END IF;
8952: ELSIF p_disabled_list(i) = 'LOADING_SEQUENCE' THEN
8949: OR p_in_rec.ULTIMATE_DROPOFF_DATE IS NULL THEN
8950: x_out_rec.ULTIMATE_DROPOFF_DATE := p_in_rec.ULTIMATE_DROPOFF_DATE ;
8951: END IF;
8952: ELSIF p_disabled_list(i) = 'LOADING_SEQUENCE' THEN
8953: IF p_in_rec.LOADING_SEQUENCE <> FND_API.G_MISS_NUM
8954: OR p_in_rec.LOADING_SEQUENCE IS NULL THEN
8955: x_out_rec.LOADING_SEQUENCE := p_in_rec.LOADING_SEQUENCE ;
8956: END IF;
8957: ELSIF p_disabled_list(i) = 'SHIP_METHOD_NAME' THEN
8970: x_out_rec.carrier_id,
8971: x_out_rec.carrier_code);
8972: -- J-IB-NPARIKH-}
8973: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL_NAME' THEN
8974: IF p_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
8975: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
8976: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
8977: END IF;
8978: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT_NAME' THEN
8975: OR p_in_rec.SERVICE_LEVEL IS NULL THEN
8976: x_out_rec.SERVICE_LEVEL := p_in_rec.SERVICE_LEVEL ;
8977: END IF;
8978: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT_NAME' THEN
8979: IF p_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
8980: OR p_in_rec.MODE_OF_TRANSPORT IS NULL THEN
8981: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
8982: END IF;
8983: ELSIF p_disabled_list(i) = 'NAME' THEN
8980: OR p_in_rec.MODE_OF_TRANSPORT IS NULL THEN
8981: x_out_rec.MODE_OF_TRANSPORT := p_in_rec.MODE_OF_TRANSPORT ;
8982: END IF;
8983: ELSIF p_disabled_list(i) = 'NAME' THEN
8984: IF p_in_rec.NAME <> FND_API.G_MISS_CHAR
8985: OR p_in_rec.NAME IS NULL THEN
8986: x_out_rec.NAME := p_in_rec.NAME ;
8987: END IF;
8988: ELSIF p_disabled_list(i) = 'INTMED_SHIP_TO_LOCATION_CODE' THEN
8997: NULL,
8998: x_out_rec.POOLED_SHIP_TO_LOCATION_ID,
8999: x_out_rec.POOLED_SHIP_TO_LOCATION_CODE);
9000: ELSIF p_disabled_list(i) = 'WAYBILL' THEN
9001: IF p_in_rec.WAYBILL <> FND_API.G_MISS_CHAR
9002: OR p_in_rec.WAYBILL IS NULL THEN
9003: x_out_rec.WAYBILL := p_in_rec.WAYBILL ;
9004: END IF;
9005: ELSIF p_disabled_list(i) = 'FREIGHT_TERMS_NAME' THEN
9008: NULL,
9009: x_out_rec.FREIGHT_TERMS_CODE,
9010: x_out_rec.FREIGHT_TERMS_NAME);
9011: ELSIF p_disabled_list(i) = 'GROSS_WEIGHT' THEN
9012: IF p_in_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
9013: OR p_in_rec.GROSS_WEIGHT IS NULL THEN
9014: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
9015: END IF;
9016: ELSIF p_disabled_list(i) = 'NET_WEIGHT' THEN
9013: OR p_in_rec.GROSS_WEIGHT IS NULL THEN
9014: x_out_rec.GROSS_WEIGHT := p_in_rec.GROSS_WEIGHT ;
9015: END IF;
9016: ELSIF p_disabled_list(i) = 'NET_WEIGHT' THEN
9017: IF p_in_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
9018: OR p_in_rec.NET_WEIGHT IS NULL THEN
9019: x_out_rec.NET_WEIGHT := p_in_rec.NET_WEIGHT ;
9020: END IF;
9021: -- Non Database field prorate_wt_flag added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
9019: x_out_rec.NET_WEIGHT := p_in_rec.NET_WEIGHT ;
9020: END IF;
9021: -- Non Database field prorate_wt_flag added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
9022: ELSIF p_disabled_list(i) = 'PRORATE_WT_FLAG' THEN
9023: -- Bug#4539613 : replaced FND_API.G_MISS_NUM by FND_API.G_MISS_CHAR
9024: IF p_in_rec.PRORATE_WT_FLAG <> FND_API.G_MISS_CHAR OR p_in_rec.PRORATE_WT_FLAG IS NULL THEN
9025: x_out_rec.PRORATE_WT_FLAG := p_in_rec.PRORATE_WT_FLAG ;
9026: END IF;
9027: --
9020: END IF;
9021: -- Non Database field prorate_wt_flag added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
9022: ELSIF p_disabled_list(i) = 'PRORATE_WT_FLAG' THEN
9023: -- Bug#4539613 : replaced FND_API.G_MISS_NUM by FND_API.G_MISS_CHAR
9024: IF p_in_rec.PRORATE_WT_FLAG <> FND_API.G_MISS_CHAR OR p_in_rec.PRORATE_WT_FLAG IS NULL THEN
9025: x_out_rec.PRORATE_WT_FLAG := p_in_rec.PRORATE_WT_FLAG ;
9026: END IF;
9027: --
9028: ELSIF p_disabled_list(i) = 'WEIGHT_UOM_CODE' THEN
9032: x_out_rec.WEIGHT_UOM_CODE,
9033: x_out_rec.WEIGHT_UOM_DESC);
9034:
9035: ELSIF p_disabled_list(i) = 'VOLUME' THEN
9036: IF p_in_rec.VOLUME <> FND_API.G_MISS_NUM
9037: OR p_in_rec.VOLUME IS NULL THEN
9038: x_out_rec.VOLUME := p_in_rec.VOLUME ;
9039: END IF;
9040: ELSIF p_disabled_list(i) = 'VOLUME_UOM_CODE' THEN
9055: NULL,
9056: x_out_rec.FOB_LOCATION_ID,
9057: x_out_rec.FOB_LOCATION_CODE);
9058: ELSIF p_disabled_list(i) = 'NUMBER_OF_LPN' THEN
9059: IF p_in_rec.NUMBER_OF_LPN <> FND_API.G_MISS_NUM
9060: OR p_in_rec.NUMBER_OF_LPN IS NULL THEN
9061: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
9062: END IF;
9063: ELSIF p_disabled_list(i) = 'AUTO_SC_EXCLUDE_FLAG' THEN
9060: OR p_in_rec.NUMBER_OF_LPN IS NULL THEN
9061: x_out_rec.NUMBER_OF_LPN := p_in_rec.NUMBER_OF_LPN ;
9062: END IF;
9063: ELSIF p_disabled_list(i) = 'AUTO_SC_EXCLUDE_FLAG' THEN
9064: IF p_in_rec.AUTO_SC_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
9065: OR p_in_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
9066: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
9067: END IF;
9068: ELSIF p_disabled_list(i) = 'AUTO_AP_EXCLUDE_FLAG' THEN
9065: OR p_in_rec.AUTO_SC_EXCLUDE_FLAG IS NULL THEN
9066: x_out_rec.AUTO_SC_EXCLUDE_FLAG := p_in_rec.AUTO_SC_EXCLUDE_FLAG ;
9067: END IF;
9068: ELSIF p_disabled_list(i) = 'AUTO_AP_EXCLUDE_FLAG' THEN
9069: IF p_in_rec.AUTO_AP_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
9070: OR p_in_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
9071: x_out_rec.AUTO_AP_EXCLUDE_FLAG := p_in_rec.AUTO_AP_EXCLUDE_FLAG ;
9072: END IF;
9073: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
9070: OR p_in_rec.AUTO_AP_EXCLUDE_FLAG IS NULL THEN
9071: x_out_rec.AUTO_AP_EXCLUDE_FLAG := p_in_rec.AUTO_AP_EXCLUDE_FLAG ;
9072: END IF;
9073: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
9074: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
9075: OR p_in_rec.attribute1 IS NULL THEN
9076: x_out_rec.attribute1 := p_in_rec.attribute1 ;
9077: END IF;
9078: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
9074: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
9075: OR p_in_rec.attribute1 IS NULL THEN
9076: x_out_rec.attribute1 := p_in_rec.attribute1 ;
9077: END IF;
9078: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
9079: OR p_in_rec.attribute2 IS NULL THEN
9080: x_out_rec.attribute2 := p_in_rec.attribute2 ;
9081: END IF;
9082: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
9078: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
9079: OR p_in_rec.attribute2 IS NULL THEN
9080: x_out_rec.attribute2 := p_in_rec.attribute2 ;
9081: END IF;
9082: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
9083: OR p_in_rec.attribute3 IS NULL THEN
9084: x_out_rec.attribute3 := p_in_rec.attribute3 ;
9085: END IF;
9086: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
9082: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
9083: OR p_in_rec.attribute3 IS NULL THEN
9084: x_out_rec.attribute3 := p_in_rec.attribute3 ;
9085: END IF;
9086: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
9087: OR p_in_rec.attribute4 IS NULL THEN
9088: x_out_rec.attribute4 := p_in_rec.attribute4 ;
9089: END IF;
9090: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
9086: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
9087: OR p_in_rec.attribute4 IS NULL THEN
9088: x_out_rec.attribute4 := p_in_rec.attribute4 ;
9089: END IF;
9090: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
9091: OR p_in_rec.attribute5 IS NULL THEN
9092: x_out_rec.attribute5 := p_in_rec.attribute5 ;
9093: END IF;
9094: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
9090: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
9091: OR p_in_rec.attribute5 IS NULL THEN
9092: x_out_rec.attribute5 := p_in_rec.attribute5 ;
9093: END IF;
9094: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
9095: OR p_in_rec.attribute6 IS NULL THEN
9096: x_out_rec.attribute6 := p_in_rec.attribute6 ;
9097: END IF;
9098: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
9094: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
9095: OR p_in_rec.attribute6 IS NULL THEN
9096: x_out_rec.attribute6 := p_in_rec.attribute6 ;
9097: END IF;
9098: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
9099: OR p_in_rec.attribute7 IS NULL THEN
9100: x_out_rec.attribute7 := p_in_rec.attribute7 ;
9101: END IF;
9102: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
9098: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
9099: OR p_in_rec.attribute7 IS NULL THEN
9100: x_out_rec.attribute7 := p_in_rec.attribute7 ;
9101: END IF;
9102: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
9103: OR p_in_rec.attribute8 IS NULL THEN
9104: x_out_rec.attribute8 := p_in_rec.attribute8 ;
9105: END IF;
9106: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
9102: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
9103: OR p_in_rec.attribute8 IS NULL THEN
9104: x_out_rec.attribute8 := p_in_rec.attribute8 ;
9105: END IF;
9106: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
9107: OR p_in_rec.attribute9 IS NULL THEN
9108: x_out_rec.attribute9 := p_in_rec.attribute9 ;
9109: END IF;
9110: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
9106: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
9107: OR p_in_rec.attribute9 IS NULL THEN
9108: x_out_rec.attribute9 := p_in_rec.attribute9 ;
9109: END IF;
9110: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
9111: OR p_in_rec.attribute10 IS NULL THEN
9112: x_out_rec.attribute10 := p_in_rec.attribute10 ;
9113: END IF;
9114: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
9110: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
9111: OR p_in_rec.attribute10 IS NULL THEN
9112: x_out_rec.attribute10 := p_in_rec.attribute10 ;
9113: END IF;
9114: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
9115: OR p_in_rec.attribute11 IS NULL THEN
9116: x_out_rec.attribute11 := p_in_rec.attribute11 ;
9117: END IF;
9118: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
9114: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
9115: OR p_in_rec.attribute11 IS NULL THEN
9116: x_out_rec.attribute11 := p_in_rec.attribute11 ;
9117: END IF;
9118: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
9119: OR p_in_rec.attribute12 IS NULL THEN
9120: x_out_rec.attribute12 := p_in_rec.attribute12 ;
9121: END IF;
9122: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
9118: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
9119: OR p_in_rec.attribute12 IS NULL THEN
9120: x_out_rec.attribute12 := p_in_rec.attribute12 ;
9121: END IF;
9122: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
9123: OR p_in_rec.attribute13 IS NULL THEN
9124: x_out_rec.attribute13 := p_in_rec.attribute13 ;
9125: END IF;
9126: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
9122: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
9123: OR p_in_rec.attribute13 IS NULL THEN
9124: x_out_rec.attribute13 := p_in_rec.attribute13 ;
9125: END IF;
9126: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
9127: OR p_in_rec.attribute14 IS NULL THEN
9128: x_out_rec.attribute14 := p_in_rec.attribute14 ;
9129: END IF;
9130: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
9126: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
9127: OR p_in_rec.attribute14 IS NULL THEN
9128: x_out_rec.attribute14 := p_in_rec.attribute14 ;
9129: END IF;
9130: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
9131: OR p_in_rec.attribute15 IS NULL THEN
9132: x_out_rec.attribute15 := p_in_rec.attribute15 ;
9133: END IF;
9134: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
9130: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
9131: OR p_in_rec.attribute15 IS NULL THEN
9132: x_out_rec.attribute15 := p_in_rec.attribute15 ;
9133: END IF;
9134: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
9135: OR p_in_rec.attribute_category IS NULL THEN
9136: x_out_rec.attribute_category := p_in_rec.attribute_category ;
9137: END IF;
9138: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
9135: OR p_in_rec.attribute_category IS NULL THEN
9136: x_out_rec.attribute_category := p_in_rec.attribute_category ;
9137: END IF;
9138: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
9139: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
9140: OR p_in_rec.tp_attribute1 IS NULL THEN
9141: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
9142: END IF;
9143: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
9139: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
9140: OR p_in_rec.tp_attribute1 IS NULL THEN
9141: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
9142: END IF;
9143: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
9144: OR p_in_rec.tp_attribute2 IS NULL THEN
9145: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
9146: END IF;
9147: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
9143: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
9144: OR p_in_rec.tp_attribute2 IS NULL THEN
9145: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
9146: END IF;
9147: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
9148: OR p_in_rec.tp_attribute3 IS NULL THEN
9149: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
9150: END IF;
9151: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
9147: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
9148: OR p_in_rec.tp_attribute3 IS NULL THEN
9149: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
9150: END IF;
9151: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
9152: OR p_in_rec.tp_attribute4 IS NULL THEN
9153: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
9154: END IF;
9155: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
9151: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
9152: OR p_in_rec.tp_attribute4 IS NULL THEN
9153: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
9154: END IF;
9155: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
9156: OR p_in_rec.tp_attribute5 IS NULL THEN
9157: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
9158: END IF;
9159: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
9155: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
9156: OR p_in_rec.tp_attribute5 IS NULL THEN
9157: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
9158: END IF;
9159: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
9160: OR p_in_rec.tp_attribute6 IS NULL THEN
9161: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
9162: END IF;
9163: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
9159: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
9160: OR p_in_rec.tp_attribute6 IS NULL THEN
9161: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
9162: END IF;
9163: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
9164: OR p_in_rec.tp_attribute7 IS NULL THEN
9165: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
9166: END IF;
9167: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
9163: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
9164: OR p_in_rec.tp_attribute7 IS NULL THEN
9165: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
9166: END IF;
9167: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
9168: OR p_in_rec.tp_attribute8 IS NULL THEN
9169: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
9170: END IF;
9171: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
9167: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
9168: OR p_in_rec.tp_attribute8 IS NULL THEN
9169: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
9170: END IF;
9171: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
9172: OR p_in_rec.tp_attribute9 IS NULL THEN
9173: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
9174: END IF;
9175: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
9171: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
9172: OR p_in_rec.tp_attribute9 IS NULL THEN
9173: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
9174: END IF;
9175: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
9176: OR p_in_rec.tp_attribute10 IS NULL THEN
9177: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
9178: END IF;
9179: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
9175: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
9176: OR p_in_rec.tp_attribute10 IS NULL THEN
9177: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
9178: END IF;
9179: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
9180: OR p_in_rec.tp_attribute11 IS NULL THEN
9181: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
9182: END IF;
9183: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
9179: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
9180: OR p_in_rec.tp_attribute11 IS NULL THEN
9181: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
9182: END IF;
9183: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
9184: OR p_in_rec.tp_attribute12 IS NULL THEN
9185: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
9186: END IF;
9187: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
9183: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
9184: OR p_in_rec.tp_attribute12 IS NULL THEN
9185: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
9186: END IF;
9187: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
9188: OR p_in_rec.tp_attribute13 IS NULL THEN
9189: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
9190: END IF;
9191: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
9187: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
9188: OR p_in_rec.tp_attribute13 IS NULL THEN
9189: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
9190: END IF;
9191: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
9192: OR p_in_rec.tp_attribute14 IS NULL THEN
9193: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
9194: END IF;
9195: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
9191: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
9192: OR p_in_rec.tp_attribute14 IS NULL THEN
9193: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
9194: END IF;
9195: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
9196: OR p_in_rec.tp_attribute15 IS NULL THEN
9197: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
9198: END IF;
9199: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
9195: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
9196: OR p_in_rec.tp_attribute15 IS NULL THEN
9197: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
9198: END IF;
9199: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
9200: OR p_in_rec.tp_attribute_category IS NULL THEN
9201: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
9202: END IF;
9203: ELSIF p_disabled_list(i) = 'GLOBALIZATION_FLEXFIELD' THEN
9200: OR p_in_rec.tp_attribute_category IS NULL THEN
9201: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
9202: END IF;
9203: ELSIF p_disabled_list(i) = 'GLOBALIZATION_FLEXFIELD' THEN
9204: IF p_in_rec.global_attribute1 <> FND_API.G_MISS_CHAR
9205: OR p_in_rec.global_attribute1 IS NULL THEN
9206: x_out_rec.global_attribute1 := p_in_rec.global_attribute1 ;
9207: END IF;
9208: IF p_in_rec.global_attribute2 <> FND_API.G_MISS_CHAR
9204: IF p_in_rec.global_attribute1 <> FND_API.G_MISS_CHAR
9205: OR p_in_rec.global_attribute1 IS NULL THEN
9206: x_out_rec.global_attribute1 := p_in_rec.global_attribute1 ;
9207: END IF;
9208: IF p_in_rec.global_attribute2 <> FND_API.G_MISS_CHAR
9209: OR p_in_rec.global_attribute2 IS NULL THEN
9210: x_out_rec.global_attribute2 := p_in_rec.global_attribute2 ;
9211: END IF;
9212: IF p_in_rec.global_attribute3 <> FND_API.G_MISS_CHAR
9208: IF p_in_rec.global_attribute2 <> FND_API.G_MISS_CHAR
9209: OR p_in_rec.global_attribute2 IS NULL THEN
9210: x_out_rec.global_attribute2 := p_in_rec.global_attribute2 ;
9211: END IF;
9212: IF p_in_rec.global_attribute3 <> FND_API.G_MISS_CHAR
9213: OR p_in_rec.global_attribute3 IS NULL THEN
9214: x_out_rec.global_attribute3 := p_in_rec.global_attribute3 ;
9215: END IF;
9216: IF p_in_rec.global_attribute4 <> FND_API.G_MISS_CHAR
9212: IF p_in_rec.global_attribute3 <> FND_API.G_MISS_CHAR
9213: OR p_in_rec.global_attribute3 IS NULL THEN
9214: x_out_rec.global_attribute3 := p_in_rec.global_attribute3 ;
9215: END IF;
9216: IF p_in_rec.global_attribute4 <> FND_API.G_MISS_CHAR
9217: OR p_in_rec.global_attribute4 IS NULL THEN
9218: x_out_rec.global_attribute4 := p_in_rec.global_attribute4 ;
9219: END IF;
9220: IF p_in_rec.global_attribute5 <> FND_API.G_MISS_CHAR
9216: IF p_in_rec.global_attribute4 <> FND_API.G_MISS_CHAR
9217: OR p_in_rec.global_attribute4 IS NULL THEN
9218: x_out_rec.global_attribute4 := p_in_rec.global_attribute4 ;
9219: END IF;
9220: IF p_in_rec.global_attribute5 <> FND_API.G_MISS_CHAR
9221: OR p_in_rec.global_attribute5 IS NULL THEN
9222: x_out_rec.global_attribute5 := p_in_rec.global_attribute5 ;
9223: END IF;
9224: IF p_in_rec.global_attribute6 <> FND_API.G_MISS_CHAR
9220: IF p_in_rec.global_attribute5 <> FND_API.G_MISS_CHAR
9221: OR p_in_rec.global_attribute5 IS NULL THEN
9222: x_out_rec.global_attribute5 := p_in_rec.global_attribute5 ;
9223: END IF;
9224: IF p_in_rec.global_attribute6 <> FND_API.G_MISS_CHAR
9225: OR p_in_rec.global_attribute6 IS NULL THEN
9226: x_out_rec.global_attribute6 := p_in_rec.global_attribute6 ;
9227: END IF;
9228: IF p_in_rec.global_attribute7 <> FND_API.G_MISS_CHAR
9224: IF p_in_rec.global_attribute6 <> FND_API.G_MISS_CHAR
9225: OR p_in_rec.global_attribute6 IS NULL THEN
9226: x_out_rec.global_attribute6 := p_in_rec.global_attribute6 ;
9227: END IF;
9228: IF p_in_rec.global_attribute7 <> FND_API.G_MISS_CHAR
9229: OR p_in_rec.global_attribute7 IS NULL THEN
9230: x_out_rec.global_attribute7 := p_in_rec.global_attribute7 ;
9231: END IF;
9232: IF p_in_rec.global_attribute8 <> FND_API.G_MISS_CHAR
9228: IF p_in_rec.global_attribute7 <> FND_API.G_MISS_CHAR
9229: OR p_in_rec.global_attribute7 IS NULL THEN
9230: x_out_rec.global_attribute7 := p_in_rec.global_attribute7 ;
9231: END IF;
9232: IF p_in_rec.global_attribute8 <> FND_API.G_MISS_CHAR
9233: OR p_in_rec.global_attribute8 IS NULL THEN
9234: x_out_rec.global_attribute8 := p_in_rec.global_attribute8 ;
9235: END IF;
9236: IF p_in_rec.global_attribute9 <> FND_API.G_MISS_CHAR
9232: IF p_in_rec.global_attribute8 <> FND_API.G_MISS_CHAR
9233: OR p_in_rec.global_attribute8 IS NULL THEN
9234: x_out_rec.global_attribute8 := p_in_rec.global_attribute8 ;
9235: END IF;
9236: IF p_in_rec.global_attribute9 <> FND_API.G_MISS_CHAR
9237: OR p_in_rec.global_attribute9 IS NULL THEN
9238: x_out_rec.global_attribute9 := p_in_rec.global_attribute9 ;
9239: END IF;
9240: IF p_in_rec.global_attribute10 <> FND_API.G_MISS_CHAR
9236: IF p_in_rec.global_attribute9 <> FND_API.G_MISS_CHAR
9237: OR p_in_rec.global_attribute9 IS NULL THEN
9238: x_out_rec.global_attribute9 := p_in_rec.global_attribute9 ;
9239: END IF;
9240: IF p_in_rec.global_attribute10 <> FND_API.G_MISS_CHAR
9241: OR p_in_rec.global_attribute10 IS NULL THEN
9242: x_out_rec.global_attribute10 := p_in_rec.global_attribute10 ;
9243: END IF;
9244: IF p_in_rec.global_attribute11 <> FND_API.G_MISS_CHAR
9240: IF p_in_rec.global_attribute10 <> FND_API.G_MISS_CHAR
9241: OR p_in_rec.global_attribute10 IS NULL THEN
9242: x_out_rec.global_attribute10 := p_in_rec.global_attribute10 ;
9243: END IF;
9244: IF p_in_rec.global_attribute11 <> FND_API.G_MISS_CHAR
9245: OR p_in_rec.global_attribute11 IS NULL THEN
9246: x_out_rec.global_attribute11 := p_in_rec.global_attribute11 ;
9247: END IF;
9248: IF p_in_rec.global_attribute12 <> FND_API.G_MISS_CHAR
9244: IF p_in_rec.global_attribute11 <> FND_API.G_MISS_CHAR
9245: OR p_in_rec.global_attribute11 IS NULL THEN
9246: x_out_rec.global_attribute11 := p_in_rec.global_attribute11 ;
9247: END IF;
9248: IF p_in_rec.global_attribute12 <> FND_API.G_MISS_CHAR
9249: OR p_in_rec.global_attribute12 IS NULL THEN
9250: x_out_rec.global_attribute12 := p_in_rec.global_attribute12 ;
9251: END IF;
9252: IF p_in_rec.global_attribute13 <> FND_API.G_MISS_CHAR
9248: IF p_in_rec.global_attribute12 <> FND_API.G_MISS_CHAR
9249: OR p_in_rec.global_attribute12 IS NULL THEN
9250: x_out_rec.global_attribute12 := p_in_rec.global_attribute12 ;
9251: END IF;
9252: IF p_in_rec.global_attribute13 <> FND_API.G_MISS_CHAR
9253: OR p_in_rec.global_attribute13 IS NULL THEN
9254: x_out_rec.global_attribute13 := p_in_rec.global_attribute13 ;
9255: END IF;
9256: IF p_in_rec.global_attribute14 <> FND_API.G_MISS_CHAR
9252: IF p_in_rec.global_attribute13 <> FND_API.G_MISS_CHAR
9253: OR p_in_rec.global_attribute13 IS NULL THEN
9254: x_out_rec.global_attribute13 := p_in_rec.global_attribute13 ;
9255: END IF;
9256: IF p_in_rec.global_attribute14 <> FND_API.G_MISS_CHAR
9257: OR p_in_rec.global_attribute14 IS NULL THEN
9258: x_out_rec.global_attribute14 := p_in_rec.global_attribute14 ;
9259: END IF;
9260: IF p_in_rec.global_attribute15 <> FND_API.G_MISS_CHAR
9256: IF p_in_rec.global_attribute14 <> FND_API.G_MISS_CHAR
9257: OR p_in_rec.global_attribute14 IS NULL THEN
9258: x_out_rec.global_attribute14 := p_in_rec.global_attribute14 ;
9259: END IF;
9260: IF p_in_rec.global_attribute15 <> FND_API.G_MISS_CHAR
9261: OR p_in_rec.global_attribute15 IS NULL THEN
9262: x_out_rec.global_attribute15 := p_in_rec.global_attribute15 ;
9263: END IF;
9264: IF p_in_rec.global_attribute_category <> FND_API.G_MISS_CHAR
9260: IF p_in_rec.global_attribute15 <> FND_API.G_MISS_CHAR
9261: OR p_in_rec.global_attribute15 IS NULL THEN
9262: x_out_rec.global_attribute15 := p_in_rec.global_attribute15 ;
9263: END IF;
9264: IF p_in_rec.global_attribute_category <> FND_API.G_MISS_CHAR
9265: OR p_in_rec.global_attribute_category IS NULL THEN
9266: x_out_rec.attribute_category := p_in_rec.attribute_category ;
9267: END IF;
9268: ELSIF p_disabled_list(i) = 'TARE_WEIGHT' THEN
9500: WSH_DEBUG_SV.log(l_module_name,'Action Code', p_in_rec.action_code);
9501: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
9502: END IF;
9503: --
9504: x_return_status := FND_API.G_RET_STS_SUCCESS;
9505: --
9506: IF p_in_rec.action_code = 'CREATE' THEN
9507: --
9508: IF l_debug_on THEN
9582: -- bug 3371077: need to overwrite these dates even
9583: -- if delivery has contents.
9584: -- (technically equivalent to emptying the delivery,
9585: -- updating the dates, and re-assigning its contents)
9586: IF p_delivery_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE THEN
9587: x_delivery_rec.INITIAL_PICKUP_DATE := p_delivery_rec.INITIAL_PICKUP_DATE ;
9588: END IF;
9589: IF p_delivery_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE THEN
9590: x_delivery_rec.ULTIMATE_DROPOFF_DATE := p_delivery_rec.ULTIMATE_DROPOFF_DATE ;
9585: -- updating the dates, and re-assigning its contents)
9586: IF p_delivery_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE THEN
9587: x_delivery_rec.INITIAL_PICKUP_DATE := p_delivery_rec.INITIAL_PICKUP_DATE ;
9588: END IF;
9589: IF p_delivery_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE THEN
9590: x_delivery_rec.ULTIMATE_DROPOFF_DATE := p_delivery_rec.ULTIMATE_DROPOFF_DATE ;
9591: END IF;
9592: END IF;
9593: --
9723: ,l_field_name);
9724: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');
9725: END IF;
9726: --
9727: WHEN FND_API.G_EXC_ERROR THEN
9728: IF (c_tbl_rec%ISOPEN) THEN
9729: CLOSE c_tbl_rec;
9730: END IF;
9731:
9731:
9732: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9733: --
9734: IF l_debug_on THEN
9735: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9737: END IF;
9738: --
9739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9732: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9733: --
9734: IF l_debug_on THEN
9735: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9737: END IF;
9738: --
9739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9740: IF (c_tbl_rec%ISOPEN) THEN
9735: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9737: END IF;
9738: --
9739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9740: IF (c_tbl_rec%ISOPEN) THEN
9741: CLOSE c_tbl_rec;
9742: END IF;
9743:
9744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
9745: --
9746: IF l_debug_on THEN
9747: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
9748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9749: END IF;
9750:
9751: WHEN OTHERS THEN
9752: IF (c_tbl_rec%ISOPEN) THEN
10265: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERY_ID');
10266: x_return_status := wsh_util_core.g_ret_sts_error;
10267: wsh_util_core.add_message(x_return_status,l_module_name);
10268: close l_del_org_csr;
10269: RAISE FND_API.G_EXC_ERROR;
10270: END IF;
10271: close l_del_org_csr;
10272: --
10273: IF l_organization_id <> p_organization_id THEN
10287: open l_check_uom_csr(l_vol_uom_class, l_vol_uom_code);
10288: fetch l_check_uom_csr into l_vol_uom_code;
10289: close l_check_uom_csr;
10290: --
10291: IF nvl(l_wt_uom_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
10292: x_weight_uom_code := l_wt_uom_code;
10293: ELSE
10294: --
10295: open l_get_base_uom_csr(l_wt_uom_class);
10299: x_wt_nullify_flag := TRUE;
10300: --
10301: END IF;
10302: --
10303: IF nvl(l_wt_uom_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
10304: x_volume_uom_code := l_vol_uom_code;
10305: ELSE
10306: --
10307: open l_get_base_uom_csr(l_vol_uom_class);
10324: WSH_DEBUG_SV.pop(l_module_name);
10325: END IF;
10326: --
10327: EXCEPTION
10328: WHEN FND_API.G_EXC_ERROR THEN
10329: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10330: --
10331: IF l_debug_on THEN
10332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10328: WHEN FND_API.G_EXC_ERROR THEN
10329: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10330: --
10331: IF l_debug_on THEN
10332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10334: END IF;
10335: --
10336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10329: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10330: --
10331: IF l_debug_on THEN
10332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10334: END IF;
10335: --
10336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10337: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10334: END IF;
10335: --
10336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10337: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10338: --
10339: IF l_debug_on THEN
10340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10337: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10338: --
10339: IF l_debug_on THEN
10340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10341: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10342: END IF;
10343: --
10344: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10345: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10391: END IF;
10392: --
10393: SAVEPOINT VALIDATE_ROUTED_EXPORT_TXN;
10394: --
10395: IF nvl(x_rtd_expt_txn_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10396: OR nvl(p_rtd_expt_txn_meaning,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10397: THEN
10398: IF x_rtd_expt_txn_code = FND_API.G_MISS_CHAR THEN
10399: x_rtd_expt_txn_code := NULL;
10392: --
10393: SAVEPOINT VALIDATE_ROUTED_EXPORT_TXN;
10394: --
10395: IF nvl(x_rtd_expt_txn_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10396: OR nvl(p_rtd_expt_txn_meaning,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10397: THEN
10398: IF x_rtd_expt_txn_code = FND_API.G_MISS_CHAR THEN
10399: x_rtd_expt_txn_code := NULL;
10400: END IF;
10394: --
10395: IF nvl(x_rtd_expt_txn_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10396: OR nvl(p_rtd_expt_txn_meaning,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
10397: THEN
10398: IF x_rtd_expt_txn_code = FND_API.G_MISS_CHAR THEN
10399: x_rtd_expt_txn_code := NULL;
10400: END IF;
10401: WSH_UTIL_VALIDATE.validate_lookup(
10402: p_lookup_type => 'YES_NO',
10421: WSH_DEBUG_SV.pop(l_module_name);
10422: END IF;
10423: --
10424: EXCEPTION
10425: WHEN FND_API.G_EXC_ERROR THEN
10426: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10428: --
10429: IF l_debug_on THEN
10426: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10428: --
10429: IF l_debug_on THEN
10430: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10431: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10432: END IF;
10433: --
10434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10428: --
10429: IF l_debug_on THEN
10430: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10431: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10432: END IF;
10433: --
10434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10435: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10430: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10431: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10432: END IF;
10433: --
10434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10435: ROLLBACK TO VALIDATE_ROUTED_EXPORT_TXN;
10436: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10437: --
10438: IF l_debug_on THEN
10436: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10437: --
10438: IF l_debug_on THEN
10439: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10440: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10441: END IF;
10442: --
10443: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10444: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10499: END IF;
10500: --
10501: SAVEPOINT DERIVE_NUMBER_OF_LPN;
10502: --
10503: IF nvl(x_number_of_lpn,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
10504: --
10505: open lpn_cur;
10506: fetch lpn_cur into x_number_of_lpn;
10507: close lpn_cur;
10518: WSH_DEBUG_SV.pop(l_module_name);
10519: END IF;
10520: --
10521: EXCEPTION
10522: WHEN FND_API.G_EXC_ERROR THEN
10523: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10524: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10525: --
10526: IF l_debug_on THEN
10523: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10524: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10525: --
10526: IF l_debug_on THEN
10527: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10529: END IF;
10530: --
10531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10524: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10525: --
10526: IF l_debug_on THEN
10527: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10529: END IF;
10530: --
10531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10532: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10527: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10529: END IF;
10530: --
10531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10532: ROLLBACK TO DERIVE_NUMBER_OF_LPN;
10533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10534: --
10535: IF l_debug_on THEN
10533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10534: --
10535: IF l_debug_on THEN
10536: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10537: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10538: END IF;
10539: --
10540: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10541: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10629: WSH_DEBUG_SV.log(l_module_name,'p_pickup_location_id',p_pickup_location_id);
10630: WSH_DEBUG_SV.log(l_module_name,'p_dropoff_location_id',p_dropoff_location_id);
10631: --
10632: END IF;
10633: IF nvl(p_delivery_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
10634: --
10635: open l_pick_up_leg_csr(p_delivery_id, p_pickup_location_id);
10636: fetch l_pick_up_leg_csr into l_trip_name, l_del_name;
10637: close l_pick_up_leg_csr;
10648: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
10649: FND_MESSAGE.SET_TOKEN('PICKUP_LOC',l_loc_description);
10650: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10651: wsh_util_core.add_message(x_return_status);
10652: RAISE FND_API.G_EXC_ERROR;
10653: END IF;
10654: --
10655: l_trip_name := NULL;
10656: open l_drop_off_leg_csr(p_delivery_id, p_dropoff_location_id);
10669: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
10670: FND_MESSAGE.SET_TOKEN('DROPOFF_LOC',l_loc_description);
10671: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10672: wsh_util_core.add_message(x_return_status);
10673: RAISE FND_API.G_EXC_ERROR;
10674: END IF;
10675: --
10676: END IF;
10677:
10682: WSH_DEBUG_SV.pop(l_module_name);
10683: END IF;
10684: --
10685: EXCEPTION
10686: WHEN FND_API.G_EXC_ERROR THEN
10687: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10688: --
10689: IF l_debug_on THEN
10690: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10686: WHEN FND_API.G_EXC_ERROR THEN
10687: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10688: --
10689: IF l_debug_on THEN
10690: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10691: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10692: END IF;
10693: --
10694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10687: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10688: --
10689: IF l_debug_on THEN
10690: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10691: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10692: END IF;
10693: --
10694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10690: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10691: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10692: END IF;
10693: --
10694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10696: --
10697: IF l_debug_on THEN
10698: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10696: --
10697: IF l_debug_on THEN
10698: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10700: END IF;
10701: --
10702: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10703: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
11212: );
11213: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
11214: x_return_status := l_return_status;
11215: wsh_util_core.add_message(x_return_status);
11216: RAISE FND_API.G_EXC_ERROR;
11217: END IF;
11218: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
11219: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
11220: IF l_exceptions_tab(exp_cnt).entity_name = 'DELIVERY' THEN
11314: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11315: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed_warning');
11316: END IF;
11317: --
11318: WHEN FND_API.G_EXC_ERROR THEN
11319:
11320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11321: --
11322: IF l_debug_on THEN
11319:
11320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11321: --
11322: IF l_debug_on THEN
11323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11324: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11325: END IF;
11326: --
11327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11321: --
11322: IF l_debug_on THEN
11323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11324: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11325: END IF;
11326: --
11327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11328:
11323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11324: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11325: END IF;
11326: --
11327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11328:
11329: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11330: --
11331: IF l_debug_on THEN
11329: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11330: --
11331: IF l_debug_on THEN
11332: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
11334: END IF;
11335: --
11336: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
11337: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
11437: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERY');
11438: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',p_delivery_id);
11439: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
11440: --CLOSE dlvy_csr;
11441: RAISE FND_API.G_EXC_ERROR;
11442: --}
11443: END IF;
11444: --
11445: CLOSE dlvy_csr;
11494: --
11495: --}
11496: EXCEPTION
11497: --{
11498: WHEN FND_API.G_EXC_ERROR THEN
11499:
11500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11501: --
11502: IF l_debug_on THEN
11499:
11500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11501: --
11502: IF l_debug_on THEN
11503: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11504: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11505: END IF;
11506: --
11507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11501: --
11502: IF l_debug_on THEN
11503: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11504: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11505: END IF;
11506: --
11507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11508:
11503: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11504: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
11505: END IF;
11506: --
11507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11508:
11509: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11510: --
11511: IF l_debug_on THEN
11509: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
11510: --
11511: IF l_debug_on THEN
11512: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
11514: END IF;
11515: --
11516: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
11517: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
11565: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
11566: --
11567: END IF;
11568: --
11569: x_return_status := FND_API.G_RET_STS_SUCCESS;
11570: --
11571: IF p_user_in_rec.DELIVERY_ID <> FND_API.G_MISS_NUM
11572: AND NVL(p_user_in_rec.DELIVERY_ID,-99) <> NVL(p_out_rec.DELIVERY_ID,-99)
11573: THEN
11567: END IF;
11568: --
11569: x_return_status := FND_API.G_RET_STS_SUCCESS;
11570: --
11571: IF p_user_in_rec.DELIVERY_ID <> FND_API.G_MISS_NUM
11572: AND NVL(p_user_in_rec.DELIVERY_ID,-99) <> NVL(p_out_rec.DELIVERY_ID,-99)
11573: THEN
11574: l_attributes := l_attributes || 'DELIVERY_ID, ';
11575: END IF;
11573: THEN
11574: l_attributes := l_attributes || 'DELIVERY_ID, ';
11575: END IF;
11576:
11577: IF p_user_in_rec.NAME <> FND_API.G_MISS_CHAR
11578: AND NVL(p_user_in_rec.NAME,'!!!') <> NVL(p_out_rec.NAME,'!!!')
11579: THEN
11580: l_attributes := l_attributes || 'NAME, ';
11581: END IF;
11579: THEN
11580: l_attributes := l_attributes || 'NAME, ';
11581: END IF;
11582:
11583: IF p_user_in_rec.PLANNED_FLAG <> FND_API.G_MISS_CHAR
11584: AND NVL(p_user_in_rec.PLANNED_FLAG,'!!!') <> NVL(p_out_rec.PLANNED_FLAG,'!!!')
11585: THEN
11586: l_attributes := l_attributes || 'PLANNED_FLAG, ';
11587: END IF;
11585: THEN
11586: l_attributes := l_attributes || 'PLANNED_FLAG, ';
11587: END IF;
11588:
11589: IF p_user_in_rec.STATUS_CODE <> FND_API.G_MISS_CHAR
11590: AND NVL(p_user_in_rec.STATUS_CODE,'!!!') <> NVL(p_out_rec.STATUS_CODE,'!!!')
11591: THEN
11592: l_attributes := l_attributes || 'STATUS_CODE, ';
11593: END IF;
11591: THEN
11592: l_attributes := l_attributes || 'STATUS_CODE, ';
11593: END IF;
11594:
11595: IF p_user_in_rec.DELIVERY_TYPE <> FND_API.G_MISS_CHAR
11596: AND NVL(p_user_in_rec.DELIVERY_TYPE,'!!!') <> NVL(p_out_rec.DELIVERY_TYPE,'!!!')
11597: THEN
11598: l_attributes := l_attributes || 'DELIVERY_TYPE, ';
11599: END IF;
11597: THEN
11598: l_attributes := l_attributes || 'DELIVERY_TYPE, ';
11599: END IF;
11600:
11601: IF p_user_in_rec.LOADING_SEQUENCE <> FND_API.G_MISS_NUM
11602: AND NVL(p_user_in_rec.LOADING_SEQUENCE,-99) <> NVL(p_out_rec.LOADING_SEQUENCE,-99)
11603: THEN
11604: l_attributes := l_attributes || 'LOADING_SEQUENCE, ';
11605: END IF;
11603: THEN
11604: l_attributes := l_attributes || 'LOADING_SEQUENCE, ';
11605: END IF;
11606:
11607: IF p_user_in_rec.LOADING_ORDER_FLAG <> FND_API.G_MISS_CHAR
11608: AND NVL(p_user_in_rec.LOADING_ORDER_FLAG,'!!!') <> NVL(p_out_rec.LOADING_ORDER_FLAG,'!!!')
11609: THEN
11610: l_attributes := l_attributes || 'LOADING_ORDER_FLAG, ';
11611: END IF;
11609: THEN
11610: l_attributes := l_attributes || 'LOADING_ORDER_FLAG, ';
11611: END IF;
11612:
11613: IF p_user_in_rec.INITIAL_PICKUP_DATE <> FND_API.G_MISS_DATE
11614: AND NVL(p_user_in_rec.INITIAL_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.INITIAL_PICKUP_DATE,TO_DATE('2','j'))
11615: THEN
11616: l_attributes := l_attributes || 'INITIAL_PICKUP_DATE, ';
11617: END IF;
11615: THEN
11616: l_attributes := l_attributes || 'INITIAL_PICKUP_DATE, ';
11617: END IF;
11618:
11619: IF p_user_in_rec.INITIAL_PICKUP_LOCATION_ID <> FND_API.G_MISS_NUM
11620: AND NVL(p_user_in_rec.INITIAL_PICKUP_LOCATION_ID,-99) <> NVL(p_out_rec.INITIAL_PICKUP_LOCATION_ID,-99)
11621: THEN
11622: l_attributes := l_attributes || 'INITIAL_PICKUP_LOCATION_ID, ';
11623: END IF;
11621: THEN
11622: l_attributes := l_attributes || 'INITIAL_PICKUP_LOCATION_ID, ';
11623: END IF;
11624:
11625: IF p_user_in_rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM
11626: AND NVL(p_user_in_rec.ORGANIZATION_ID,-99) <> NVL(p_out_rec.ORGANIZATION_ID,-99)
11627: THEN
11628: l_attributes := l_attributes || 'ORGANIZATION_ID, ';
11629: END IF;
11627: THEN
11628: l_attributes := l_attributes || 'ORGANIZATION_ID, ';
11629: END IF;
11630:
11631: IF p_user_in_rec.ULTIMATE_DROPOFF_LOCATION_ID <> FND_API.G_MISS_NUM
11632: AND NVL(p_user_in_rec.ULTIMATE_DROPOFF_LOCATION_ID,-99) <> NVL(p_out_rec.ULTIMATE_DROPOFF_LOCATION_ID,-99)
11633: THEN
11634: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_LOCATION_ID, ';
11635: END IF;
11633: THEN
11634: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_LOCATION_ID, ';
11635: END IF;
11636:
11637: IF p_user_in_rec.ULTIMATE_DROPOFF_DATE <> FND_API.G_MISS_DATE
11638: AND NVL(p_user_in_rec.ULTIMATE_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.ULTIMATE_DROPOFF_DATE,TO_DATE('2','j'))
11639: THEN
11640: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_DATE, ';
11641: END IF;
11639: THEN
11640: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_DATE, ';
11641: END IF;
11642:
11643: IF p_user_in_rec.CUSTOMER_ID <> FND_API.G_MISS_NUM
11644: AND NVL(p_user_in_rec.CUSTOMER_ID,-99) <> NVL(p_out_rec.CUSTOMER_ID,-99)
11645: THEN
11646: l_attributes := l_attributes || 'CUSTOMER_ID, ';
11647: END IF;
11645: THEN
11646: l_attributes := l_attributes || 'CUSTOMER_ID, ';
11647: END IF;
11648:
11649: IF p_user_in_rec.INTMED_SHIP_TO_LOCATION_ID <> FND_API.G_MISS_NUM
11650: AND NVL(p_user_in_rec.INTMED_SHIP_TO_LOCATION_ID,-99) <> NVL(p_out_rec.INTMED_SHIP_TO_LOCATION_ID,-99)
11651: THEN
11652: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_ID, ';
11653: END IF;
11651: THEN
11652: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_ID, ';
11653: END IF;
11654:
11655: IF p_user_in_rec.POOLED_SHIP_TO_LOCATION_ID <> FND_API.G_MISS_NUM
11656: AND NVL(p_user_in_rec.POOLED_SHIP_TO_LOCATION_ID,-99) <> NVL(p_out_rec.POOLED_SHIP_TO_LOCATION_ID,-99)
11657: THEN
11658: l_attributes := l_attributes || 'POOLED_SHIP_TO_LOCATION_ID, ';
11659: END IF;
11657: THEN
11658: l_attributes := l_attributes || 'POOLED_SHIP_TO_LOCATION_ID, ';
11659: END IF;
11660:
11661: IF p_user_in_rec.CARRIER_ID <> FND_API.G_MISS_NUM
11662: AND NVL(p_user_in_rec.CARRIER_ID,-99) <> NVL(p_out_rec.CARRIER_ID,-99)
11663: THEN
11664: l_attributes := l_attributes || 'CARRIER_ID, ';
11665: END IF;
11663: THEN
11664: l_attributes := l_attributes || 'CARRIER_ID, ';
11665: END IF;
11666:
11667: IF p_user_in_rec.SHIP_METHOD_CODE <> FND_API.G_MISS_CHAR
11668: AND NVL(p_user_in_rec.SHIP_METHOD_CODE,'!!!') <> NVL(p_out_rec.SHIP_METHOD_CODE,'!!!')
11669: THEN
11670: l_attributes := l_attributes || 'SHIP_METHOD_CODE, ';
11671: END IF;
11669: THEN
11670: l_attributes := l_attributes || 'SHIP_METHOD_CODE, ';
11671: END IF;
11672:
11673: IF p_user_in_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
11674: AND NVL(p_user_in_rec.FREIGHT_TERMS_CODE,'!!!') <> NVL(p_out_rec.FREIGHT_TERMS_CODE,'!!!')
11675: THEN
11676: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE, ';
11677: END IF;
11675: THEN
11676: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE, ';
11677: END IF;
11678:
11679: IF p_user_in_rec.FOB_CODE <> FND_API.G_MISS_CHAR
11680: AND NVL(p_user_in_rec.FOB_CODE,'!!!') <> NVL(p_out_rec.FOB_CODE,'!!!')
11681: THEN
11682: l_attributes := l_attributes || 'FOB_CODE, ';
11683: END IF;
11681: THEN
11682: l_attributes := l_attributes || 'FOB_CODE, ';
11683: END IF;
11684:
11685: IF p_user_in_rec.FOB_LOCATION_ID <> FND_API.G_MISS_NUM
11686: AND NVL(p_user_in_rec.FOB_LOCATION_ID,-99) <> NVL(p_out_rec.FOB_LOCATION_ID,-99)
11687: THEN
11688: l_attributes := l_attributes || 'FOB_LOCATION_ID, ';
11689: END IF;
11687: THEN
11688: l_attributes := l_attributes || 'FOB_LOCATION_ID, ';
11689: END IF;
11690:
11691: IF p_user_in_rec.WAYBILL <> FND_API.G_MISS_CHAR
11692: AND NVL(p_user_in_rec.WAYBILL,'!!!') <> NVL(p_out_rec.WAYBILL,'!!!')
11693: THEN
11694: l_attributes := l_attributes || 'WAYBILL, ';
11695: END IF;
11693: THEN
11694: l_attributes := l_attributes || 'WAYBILL, ';
11695: END IF;
11696:
11697: IF p_user_in_rec.DOCK_CODE <> FND_API.G_MISS_CHAR
11698: AND NVL(p_user_in_rec.DOCK_CODE,'!!!') <> NVL(p_out_rec.DOCK_CODE,'!!!')
11699: THEN
11700: l_attributes := l_attributes || 'DOCK_CODE, ';
11701: END IF;
11699: THEN
11700: l_attributes := l_attributes || 'DOCK_CODE, ';
11701: END IF;
11702:
11703: IF p_user_in_rec.ACCEPTANCE_FLAG <> FND_API.G_MISS_CHAR
11704: AND NVL(p_user_in_rec.ACCEPTANCE_FLAG,'!!!') <> NVL(p_out_rec.ACCEPTANCE_FLAG,'!!!')
11705: THEN
11706: l_attributes := l_attributes || 'ACCEPTANCE_FLAG, ';
11707: END IF;
11705: THEN
11706: l_attributes := l_attributes || 'ACCEPTANCE_FLAG, ';
11707: END IF;
11708:
11709: IF p_user_in_rec.ACCEPTED_BY <> FND_API.G_MISS_CHAR
11710: AND NVL(p_user_in_rec.ACCEPTED_BY,'!!!') <> NVL(p_out_rec.ACCEPTED_BY,'!!!')
11711: THEN
11712: l_attributes := l_attributes || 'ACCEPTED_BY, ';
11713: END IF;
11711: THEN
11712: l_attributes := l_attributes || 'ACCEPTED_BY, ';
11713: END IF;
11714:
11715: IF p_user_in_rec.ACCEPTED_DATE <> FND_API.G_MISS_DATE
11716: AND NVL(p_user_in_rec.ACCEPTED_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.ACCEPTED_DATE,TO_DATE('2','j'))
11717: THEN
11718: l_attributes := l_attributes || 'ACCEPTED_DATE, ';
11719: END IF;
11717: THEN
11718: l_attributes := l_attributes || 'ACCEPTED_DATE, ';
11719: END IF;
11720:
11721: IF p_user_in_rec.ACKNOWLEDGED_BY <> FND_API.G_MISS_CHAR
11722: AND NVL(p_user_in_rec.ACKNOWLEDGED_BY,'!!!') <> NVL(p_out_rec.ACKNOWLEDGED_BY,'!!!')
11723: THEN
11724: l_attributes := l_attributes || 'ACKNOWLEDGED_BY, ';
11725: END IF;
11723: THEN
11724: l_attributes := l_attributes || 'ACKNOWLEDGED_BY, ';
11725: END IF;
11726:
11727: IF p_user_in_rec.CONFIRMED_BY <> FND_API.G_MISS_CHAR
11728: AND NVL(p_user_in_rec.CONFIRMED_BY,'!!!') <> NVL(p_out_rec.CONFIRMED_BY,'!!!')
11729: THEN
11730: l_attributes := l_attributes || 'CONFIRMED_BY, ';
11731: END IF;
11729: THEN
11730: l_attributes := l_attributes || 'CONFIRMED_BY, ';
11731: END IF;
11732:
11733: IF p_user_in_rec.CONFIRM_DATE <> FND_API.G_MISS_DATE
11734: AND NVL(p_user_in_rec.CONFIRM_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CONFIRM_DATE,TO_DATE('2','j'))
11735: THEN
11736: l_attributes := l_attributes || 'CONFIRM_DATE, ';
11737: END IF;
11735: THEN
11736: l_attributes := l_attributes || 'CONFIRM_DATE, ';
11737: END IF;
11738:
11739: IF p_user_in_rec.ASN_DATE_SENT <> FND_API.G_MISS_DATE
11740: AND NVL(p_user_in_rec.ASN_DATE_SENT,TO_DATE('2','j')) <> NVL(p_out_rec.ASN_DATE_SENT,TO_DATE('2','j'))
11741: THEN
11742: l_attributes := l_attributes || 'ASN_DATE_SENT, ';
11743: END IF;
11741: THEN
11742: l_attributes := l_attributes || 'ASN_DATE_SENT, ';
11743: END IF;
11744:
11745: IF p_user_in_rec.ASN_STATUS_CODE <> FND_API.G_MISS_CHAR
11746: AND NVL(p_user_in_rec.ASN_STATUS_CODE,'!!!') <> NVL(p_out_rec.ASN_STATUS_CODE,'!!!')
11747: THEN
11748: l_attributes := l_attributes || 'ASN_STATUS_CODE, ';
11749: END IF;
11747: THEN
11748: l_attributes := l_attributes || 'ASN_STATUS_CODE, ';
11749: END IF;
11750:
11751: IF p_user_in_rec.ASN_SEQ_NUMBER <> FND_API.G_MISS_NUM
11752: AND NVL(p_user_in_rec.ASN_SEQ_NUMBER,-99) <> NVL(p_out_rec.ASN_SEQ_NUMBER,-99)
11753: THEN
11754: l_attributes := l_attributes || 'ASN_SEQ_NUMBER, ';
11755: END IF;
11753: THEN
11754: l_attributes := l_attributes || 'ASN_SEQ_NUMBER, ';
11755: END IF;
11756:
11757: IF p_user_in_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
11758: AND NVL(p_user_in_rec.GROSS_WEIGHT,-99) <> NVL(p_out_rec.GROSS_WEIGHT,-99)
11759: THEN
11760: l_attributes := l_attributes || 'GROSS_WEIGHT, ';
11761: END IF;
11759: THEN
11760: l_attributes := l_attributes || 'GROSS_WEIGHT, ';
11761: END IF;
11762:
11763: IF p_user_in_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
11764: AND NVL(p_user_in_rec.NET_WEIGHT,-99) <> NVL(p_out_rec.NET_WEIGHT,-99)
11765: THEN
11766: l_attributes := l_attributes || 'NET_WEIGHT, ';
11767: END IF;
11765: THEN
11766: l_attributes := l_attributes || 'NET_WEIGHT, ';
11767: END IF;
11768: -- Non Database field prorate_wt_flag added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
11769: IF p_user_in_rec.PRORATE_WT_FLAG <> FND_API.G_MISS_CHAR
11770: AND NVL(p_user_in_rec.PRORATE_WT_FLAG,'!!!') <> NVL(p_out_rec.PRORATE_WT_FLAG,'!!!')
11771: THEN
11772: l_attributes := l_attributes || 'PRORATE_WT_FLAG, ';
11773: END IF;
11771: THEN
11772: l_attributes := l_attributes || 'PRORATE_WT_FLAG, ';
11773: END IF;
11774: --
11775: IF p_user_in_rec.WEIGHT_UOM_CODE <> FND_API.G_MISS_CHAR
11776: AND NVL(p_user_in_rec.WEIGHT_UOM_CODE,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_CODE,'!!!')
11777: THEN
11778: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
11779: END IF;
11777: THEN
11778: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
11779: END IF;
11780:
11781: IF p_user_in_rec.VOLUME <> FND_API.G_MISS_NUM
11782: AND NVL(p_user_in_rec.VOLUME,-99) <> NVL(p_out_rec.VOLUME,-99)
11783: THEN
11784: l_attributes := l_attributes || 'VOLUME, ';
11785: END IF;
11783: THEN
11784: l_attributes := l_attributes || 'VOLUME, ';
11785: END IF;
11786:
11787: IF p_user_in_rec.VOLUME_UOM_CODE <> FND_API.G_MISS_CHAR
11788: AND NVL(p_user_in_rec.VOLUME_UOM_CODE,'!!!') <> NVL(p_out_rec.VOLUME_UOM_CODE,'!!!')
11789: THEN
11790: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
11791: END IF;
11789: THEN
11790: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
11791: END IF;
11792:
11793: IF p_user_in_rec.ADDITIONAL_SHIPMENT_INFO <> FND_API.G_MISS_CHAR
11794: AND NVL(p_user_in_rec.ADDITIONAL_SHIPMENT_INFO,'!!!') <> NVL(p_out_rec.ADDITIONAL_SHIPMENT_INFO,'!!!')
11795: THEN
11796: l_attributes := l_attributes || 'ADDITIONAL_SHIPMENT_INFO, ';
11797: END IF;
11795: THEN
11796: l_attributes := l_attributes || 'ADDITIONAL_SHIPMENT_INFO, ';
11797: END IF;
11798:
11799: IF p_user_in_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR
11800: AND NVL(p_user_in_rec.CURRENCY_CODE,'!!!') <> NVL(p_out_rec.CURRENCY_CODE,'!!!')
11801: THEN
11802: l_attributes := l_attributes || 'CURRENCY_CODE, ';
11803: END IF;
11801: THEN
11802: l_attributes := l_attributes || 'CURRENCY_CODE, ';
11803: END IF;
11804:
11805: IF p_user_in_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
11806: AND NVL(p_user_in_rec.ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.ATTRIBUTE_CATEGORY,'!!!')
11807: THEN
11808: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
11809: END IF;
11807: THEN
11808: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
11809: END IF;
11810:
11811: IF p_user_in_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
11812: AND NVL(p_user_in_rec.ATTRIBUTE1,'!!!') <> NVL(p_out_rec.ATTRIBUTE1,'!!!')
11813: THEN
11814: l_attributes := l_attributes || 'ATTRIBUTE1, ';
11815: END IF;
11813: THEN
11814: l_attributes := l_attributes || 'ATTRIBUTE1, ';
11815: END IF;
11816:
11817: IF p_user_in_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
11818: AND NVL(p_user_in_rec.ATTRIBUTE2,'!!!') <> NVL(p_out_rec.ATTRIBUTE2,'!!!')
11819: THEN
11820: l_attributes := l_attributes || 'ATTRIBUTE2, ';
11821: END IF;
11819: THEN
11820: l_attributes := l_attributes || 'ATTRIBUTE2, ';
11821: END IF;
11822:
11823: IF p_user_in_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
11824: AND NVL(p_user_in_rec.ATTRIBUTE3,'!!!') <> NVL(p_out_rec.ATTRIBUTE3,'!!!')
11825: THEN
11826: l_attributes := l_attributes || 'ATTRIBUTE3, ';
11827: END IF;
11825: THEN
11826: l_attributes := l_attributes || 'ATTRIBUTE3, ';
11827: END IF;
11828:
11829: IF p_user_in_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
11830: AND NVL(p_user_in_rec.ATTRIBUTE4,'!!!') <> NVL(p_out_rec.ATTRIBUTE4,'!!!')
11831: THEN
11832: l_attributes := l_attributes || 'ATTRIBUTE4, ';
11833: END IF;
11831: THEN
11832: l_attributes := l_attributes || 'ATTRIBUTE4, ';
11833: END IF;
11834:
11835: IF p_user_in_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
11836: AND NVL(p_user_in_rec.ATTRIBUTE5,'!!!') <> NVL(p_out_rec.ATTRIBUTE5,'!!!')
11837: THEN
11838: l_attributes := l_attributes || 'ATTRIBUTE5, ';
11839: END IF;
11837: THEN
11838: l_attributes := l_attributes || 'ATTRIBUTE5, ';
11839: END IF;
11840:
11841: IF p_user_in_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
11842: AND NVL(p_user_in_rec.ATTRIBUTE6,'!!!') <> NVL(p_out_rec.ATTRIBUTE6,'!!!')
11843: THEN
11844: l_attributes := l_attributes || 'ATTRIBUTE6, ';
11845: END IF;
11843: THEN
11844: l_attributes := l_attributes || 'ATTRIBUTE6, ';
11845: END IF;
11846:
11847: IF p_user_in_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
11848: AND NVL(p_user_in_rec.ATTRIBUTE7,'!!!') <> NVL(p_out_rec.ATTRIBUTE7,'!!!')
11849: THEN
11850: l_attributes := l_attributes || 'ATTRIBUTE7, ';
11851: END IF;
11849: THEN
11850: l_attributes := l_attributes || 'ATTRIBUTE7, ';
11851: END IF;
11852:
11853: IF p_user_in_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
11854: AND NVL(p_user_in_rec.ATTRIBUTE8,'!!!') <> NVL(p_out_rec.ATTRIBUTE8,'!!!')
11855: THEN
11856: l_attributes := l_attributes || 'ATTRIBUTE8, ';
11857: END IF;
11855: THEN
11856: l_attributes := l_attributes || 'ATTRIBUTE8, ';
11857: END IF;
11858:
11859: IF p_user_in_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
11860: AND NVL(p_user_in_rec.ATTRIBUTE9,'!!!') <> NVL(p_out_rec.ATTRIBUTE9,'!!!')
11861: THEN
11862: l_attributes := l_attributes || 'ATTRIBUTE9, ';
11863: END IF;
11861: THEN
11862: l_attributes := l_attributes || 'ATTRIBUTE9, ';
11863: END IF;
11864:
11865: IF p_user_in_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
11866: AND NVL(p_user_in_rec.ATTRIBUTE10,'!!!') <> NVL(p_out_rec.ATTRIBUTE10,'!!!')
11867: THEN
11868: l_attributes := l_attributes || 'ATTRIBUTE10, ';
11869: END IF;
11867: THEN
11868: l_attributes := l_attributes || 'ATTRIBUTE10, ';
11869: END IF;
11870:
11871: IF p_user_in_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
11872: AND NVL(p_user_in_rec.ATTRIBUTE11,'!!!') <> NVL(p_out_rec.ATTRIBUTE11,'!!!')
11873: THEN
11874: l_attributes := l_attributes || 'ATTRIBUTE11, ';
11875: END IF;
11873: THEN
11874: l_attributes := l_attributes || 'ATTRIBUTE11, ';
11875: END IF;
11876:
11877: IF p_user_in_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
11878: AND NVL(p_user_in_rec.ATTRIBUTE12,'!!!') <> NVL(p_out_rec.ATTRIBUTE12,'!!!')
11879: THEN
11880: l_attributes := l_attributes || 'ATTRIBUTE12, ';
11881: END IF;
11879: THEN
11880: l_attributes := l_attributes || 'ATTRIBUTE12, ';
11881: END IF;
11882:
11883: IF p_user_in_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
11884: AND NVL(p_user_in_rec.ATTRIBUTE13,'!!!') <> NVL(p_out_rec.ATTRIBUTE13,'!!!')
11885: THEN
11886: l_attributes := l_attributes || 'ATTRIBUTE13, ';
11887: END IF;
11885: THEN
11886: l_attributes := l_attributes || 'ATTRIBUTE13, ';
11887: END IF;
11888:
11889: IF p_user_in_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
11890: AND NVL(p_user_in_rec.ATTRIBUTE14,'!!!') <> NVL(p_out_rec.ATTRIBUTE14,'!!!')
11891: THEN
11892: l_attributes := l_attributes || 'ATTRIBUTE14, ';
11893: END IF;
11891: THEN
11892: l_attributes := l_attributes || 'ATTRIBUTE14, ';
11893: END IF;
11894:
11895: IF p_user_in_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
11896: AND NVL(p_user_in_rec.ATTRIBUTE15,'!!!') <> NVL(p_out_rec.ATTRIBUTE15,'!!!')
11897: THEN
11898: l_attributes := l_attributes || 'ATTRIBUTE15, ';
11899: END IF;
11897: THEN
11898: l_attributes := l_attributes || 'ATTRIBUTE15, ';
11899: END IF;
11900:
11901: IF p_user_in_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
11902: AND NVL(p_user_in_rec.TP_ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE_CATEGORY,'!!!')
11903: THEN
11904: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
11905: END IF;
11903: THEN
11904: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
11905: END IF;
11906:
11907: IF p_user_in_rec.TP_ATTRIBUTE1 <> FND_API.G_MISS_CHAR
11908: AND NVL(p_user_in_rec.TP_ATTRIBUTE1,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE1,'!!!')
11909: THEN
11910: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
11911: END IF;
11909: THEN
11910: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
11911: END IF;
11912:
11913: IF p_user_in_rec.TP_ATTRIBUTE2 <> FND_API.G_MISS_CHAR
11914: AND NVL(p_user_in_rec.TP_ATTRIBUTE2,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE2,'!!!')
11915: THEN
11916: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
11917: END IF;
11915: THEN
11916: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
11917: END IF;
11918:
11919: IF p_user_in_rec.TP_ATTRIBUTE3 <> FND_API.G_MISS_CHAR
11920: AND NVL(p_user_in_rec.TP_ATTRIBUTE3,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE3,'!!!')
11921: THEN
11922: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
11923: END IF;
11921: THEN
11922: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
11923: END IF;
11924:
11925: IF p_user_in_rec.TP_ATTRIBUTE4 <> FND_API.G_MISS_CHAR
11926: AND NVL(p_user_in_rec.TP_ATTRIBUTE4,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE4,'!!!')
11927: THEN
11928: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
11929: END IF;
11927: THEN
11928: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
11929: END IF;
11930:
11931: IF p_user_in_rec.TP_ATTRIBUTE5 <> FND_API.G_MISS_CHAR
11932: AND NVL(p_user_in_rec.TP_ATTRIBUTE5,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE5,'!!!')
11933: THEN
11934: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
11935: END IF;
11933: THEN
11934: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
11935: END IF;
11936:
11937: IF p_user_in_rec.TP_ATTRIBUTE6 <> FND_API.G_MISS_CHAR
11938: AND NVL(p_user_in_rec.TP_ATTRIBUTE6,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE6,'!!!')
11939: THEN
11940: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
11941: END IF;
11939: THEN
11940: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
11941: END IF;
11942:
11943: IF p_user_in_rec.TP_ATTRIBUTE7 <> FND_API.G_MISS_CHAR
11944: AND NVL(p_user_in_rec.TP_ATTRIBUTE7,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE7,'!!!')
11945: THEN
11946: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
11947: END IF;
11945: THEN
11946: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
11947: END IF;
11948:
11949: IF p_user_in_rec.TP_ATTRIBUTE8 <> FND_API.G_MISS_CHAR
11950: AND NVL(p_user_in_rec.TP_ATTRIBUTE8,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE8,'!!!')
11951: THEN
11952: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
11953: END IF;
11951: THEN
11952: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
11953: END IF;
11954:
11955: IF p_user_in_rec.TP_ATTRIBUTE9 <> FND_API.G_MISS_CHAR
11956: AND NVL(p_user_in_rec.TP_ATTRIBUTE9,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE9,'!!!')
11957: THEN
11958: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
11959: END IF;
11957: THEN
11958: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
11959: END IF;
11960:
11961: IF p_user_in_rec.TP_ATTRIBUTE10 <> FND_API.G_MISS_CHAR
11962: AND NVL(p_user_in_rec.TP_ATTRIBUTE10,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE10,'!!!')
11963: THEN
11964: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
11965: END IF;
11963: THEN
11964: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
11965: END IF;
11966:
11967: IF p_user_in_rec.TP_ATTRIBUTE11 <> FND_API.G_MISS_CHAR
11968: AND NVL(p_user_in_rec.TP_ATTRIBUTE11,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE11,'!!!')
11969: THEN
11970: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
11971: END IF;
11969: THEN
11970: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
11971: END IF;
11972:
11973: IF p_user_in_rec.TP_ATTRIBUTE12 <> FND_API.G_MISS_CHAR
11974: AND NVL(p_user_in_rec.TP_ATTRIBUTE12,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE12,'!!!')
11975: THEN
11976: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
11977: END IF;
11975: THEN
11976: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
11977: END IF;
11978:
11979: IF p_user_in_rec.TP_ATTRIBUTE13 <> FND_API.G_MISS_CHAR
11980: AND NVL(p_user_in_rec.TP_ATTRIBUTE13,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE13,'!!!')
11981: THEN
11982: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
11983: END IF;
11981: THEN
11982: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
11983: END IF;
11984:
11985: IF p_user_in_rec.TP_ATTRIBUTE14 <> FND_API.G_MISS_CHAR
11986: AND NVL(p_user_in_rec.TP_ATTRIBUTE14,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE14,'!!!')
11987: THEN
11988: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
11989: END IF;
11987: THEN
11988: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
11989: END IF;
11990:
11991: IF p_user_in_rec.TP_ATTRIBUTE15 <> FND_API.G_MISS_CHAR
11992: AND NVL(p_user_in_rec.TP_ATTRIBUTE15,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE15,'!!!')
11993: THEN
11994: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
11995: END IF;
11993: THEN
11994: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
11995: END IF;
11996:
11997: IF p_user_in_rec.GLOBAL_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
11998: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE_CATEGORY,'!!!')
11999: THEN
12000: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE_CATEGORY, ';
12001: END IF;
11999: THEN
12000: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE_CATEGORY, ';
12001: END IF;
12002:
12003: IF p_user_in_rec.GLOBAL_ATTRIBUTE1 <> FND_API.G_MISS_CHAR
12004: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE1,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE1,'!!!')
12005: THEN
12006: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE1, ';
12007: END IF;
12005: THEN
12006: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE1, ';
12007: END IF;
12008:
12009: IF p_user_in_rec.GLOBAL_ATTRIBUTE2 <> FND_API.G_MISS_CHAR
12010: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE2,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE2,'!!!')
12011: THEN
12012: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE2, ';
12013: END IF;
12011: THEN
12012: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE2, ';
12013: END IF;
12014:
12015: IF p_user_in_rec.GLOBAL_ATTRIBUTE3 <> FND_API.G_MISS_CHAR
12016: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE3,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE3,'!!!')
12017: THEN
12018: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE3, ';
12019: END IF;
12017: THEN
12018: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE3, ';
12019: END IF;
12020:
12021: IF p_user_in_rec.GLOBAL_ATTRIBUTE4 <> FND_API.G_MISS_CHAR
12022: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE4,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE4,'!!!')
12023: THEN
12024: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE4, ';
12025: END IF;
12023: THEN
12024: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE4, ';
12025: END IF;
12026:
12027: IF p_user_in_rec.GLOBAL_ATTRIBUTE5 <> FND_API.G_MISS_CHAR
12028: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE5,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE5,'!!!')
12029: THEN
12030: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE5, ';
12031: END IF;
12029: THEN
12030: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE5, ';
12031: END IF;
12032:
12033: IF p_user_in_rec.GLOBAL_ATTRIBUTE6 <> FND_API.G_MISS_CHAR
12034: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE6,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE6,'!!!')
12035: THEN
12036: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE6, ';
12037: END IF;
12035: THEN
12036: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE6, ';
12037: END IF;
12038:
12039: IF p_user_in_rec.GLOBAL_ATTRIBUTE7 <> FND_API.G_MISS_CHAR
12040: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE7,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE7,'!!!')
12041: THEN
12042: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE7, ';
12043: END IF;
12041: THEN
12042: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE7, ';
12043: END IF;
12044:
12045: IF p_user_in_rec.GLOBAL_ATTRIBUTE8 <> FND_API.G_MISS_CHAR
12046: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE8,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE8,'!!!')
12047: THEN
12048: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE8, ';
12049: END IF;
12047: THEN
12048: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE8, ';
12049: END IF;
12050:
12051: IF p_user_in_rec.GLOBAL_ATTRIBUTE9 <> FND_API.G_MISS_CHAR
12052: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE9,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE9,'!!!')
12053: THEN
12054: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE9, ';
12055: END IF;
12053: THEN
12054: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE9, ';
12055: END IF;
12056:
12057: IF p_user_in_rec.GLOBAL_ATTRIBUTE10 <> FND_API.G_MISS_CHAR
12058: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE10,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE10,'!!!')
12059: THEN
12060: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE10, ';
12061: END IF;
12059: THEN
12060: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE10, ';
12061: END IF;
12062:
12063: IF p_user_in_rec.GLOBAL_ATTRIBUTE11 <> FND_API.G_MISS_CHAR
12064: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE11,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE11,'!!!')
12065: THEN
12066: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE11, ';
12067: END IF;
12065: THEN
12066: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE11, ';
12067: END IF;
12068:
12069: IF p_user_in_rec.GLOBAL_ATTRIBUTE12 <> FND_API.G_MISS_CHAR
12070: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE12,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE12,'!!!')
12071: THEN
12072: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE12, ';
12073: END IF;
12071: THEN
12072: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE12, ';
12073: END IF;
12074:
12075: IF p_user_in_rec.GLOBAL_ATTRIBUTE13 <> FND_API.G_MISS_CHAR
12076: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE13,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE13,'!!!')
12077: THEN
12078: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE13, ';
12079: END IF;
12077: THEN
12078: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE13, ';
12079: END IF;
12080:
12081: IF p_user_in_rec.GLOBAL_ATTRIBUTE14 <> FND_API.G_MISS_CHAR
12082: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE14,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE14,'!!!')
12083: THEN
12084: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE14, ';
12085: END IF;
12083: THEN
12084: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE14, ';
12085: END IF;
12086:
12087: IF p_user_in_rec.GLOBAL_ATTRIBUTE15 <> FND_API.G_MISS_CHAR
12088: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE15,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE15,'!!!')
12089: THEN
12090: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE15, ';
12091: END IF;
12089: THEN
12090: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE15, ';
12091: END IF;
12092:
12093: IF p_user_in_rec.GLOBAL_ATTRIBUTE16 <> FND_API.G_MISS_CHAR
12094: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE16,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE16,'!!!')
12095: THEN
12096: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE16, ';
12097: END IF;
12095: THEN
12096: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE16, ';
12097: END IF;
12098:
12099: IF p_user_in_rec.GLOBAL_ATTRIBUTE17 <> FND_API.G_MISS_CHAR
12100: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE17,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE17,'!!!')
12101: THEN
12102: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE17, ';
12103: END IF;
12101: THEN
12102: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE17, ';
12103: END IF;
12104:
12105: IF p_user_in_rec.GLOBAL_ATTRIBUTE18 <> FND_API.G_MISS_CHAR
12106: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE18,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE18,'!!!')
12107: THEN
12108: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE18, ';
12109: END IF;
12107: THEN
12108: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE18, ';
12109: END IF;
12110:
12111: IF p_user_in_rec.GLOBAL_ATTRIBUTE19 <> FND_API.G_MISS_CHAR
12112: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE19,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE19,'!!!')
12113: THEN
12114: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE19, ';
12115: END IF;
12113: THEN
12114: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE19, ';
12115: END IF;
12116:
12117: IF p_user_in_rec.GLOBAL_ATTRIBUTE20 <> FND_API.G_MISS_CHAR
12118: AND NVL(p_user_in_rec.GLOBAL_ATTRIBUTE20,'!!!') <> NVL(p_out_rec.GLOBAL_ATTRIBUTE20,'!!!')
12119: THEN
12120: l_attributes := l_attributes || 'GLOBAL_ATTRIBUTE20, ';
12121: END IF;
12122:
12123: /**
12124: -- Bug 3613650 - Need not compare standard WHO columns
12125: --
12126: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE
12127: AND NVL(p_user_in_rec.CREATION_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CREATION_DATE,TO_DATE('2','j'))
12128: THEN
12129: l_attributes := l_attributes || 'CREATION_DATE, ';
12130: END IF;
12128: THEN
12129: l_attributes := l_attributes || 'CREATION_DATE, ';
12130: END IF;
12131:
12132: IF p_user_in_rec.CREATED_BY <> FND_API.G_MISS_NUM
12133: AND NVL(p_user_in_rec.CREATED_BY,-99) <> NVL(p_out_rec.CREATED_BY,-99)
12134: THEN
12135: l_attributes := l_attributes || 'CREATED_BY, ';
12136: END IF;
12134: THEN
12135: l_attributes := l_attributes || 'CREATED_BY, ';
12136: END IF;
12137:
12138: IF p_user_in_rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE
12139: AND NVL(p_user_in_rec.LAST_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LAST_UPDATE_DATE,TO_DATE('2','j'))
12140: THEN
12141: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
12142: END IF;
12140: THEN
12141: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
12142: END IF;
12143:
12144: IF p_user_in_rec.LAST_UPDATED_BY <> FND_API.G_MISS_NUM
12145: AND NVL(p_user_in_rec.LAST_UPDATED_BY,-99) <> NVL(p_out_rec.LAST_UPDATED_BY,-99)
12146: THEN
12147: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
12148: END IF;
12146: THEN
12147: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
12148: END IF;
12149:
12150: IF p_user_in_rec.LAST_UPDATE_LOGIN <> FND_API.G_MISS_NUM
12151: AND NVL(p_user_in_rec.LAST_UPDATE_LOGIN,-99) <> NVL(p_out_rec.LAST_UPDATE_LOGIN,-99)
12152: THEN
12153: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
12154: END IF;
12152: THEN
12153: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
12154: END IF;
12155:
12156: IF p_user_in_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
12157: AND NVL(p_user_in_rec.PROGRAM_APPLICATION_ID,-99) <> NVL(p_out_rec.PROGRAM_APPLICATION_ID,-99)
12158: THEN
12159: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
12160: END IF;
12158: THEN
12159: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
12160: END IF;
12161:
12162: IF p_user_in_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
12163: AND NVL(p_user_in_rec.PROGRAM_ID,-99) <> NVL(p_out_rec.PROGRAM_ID,-99)
12164: THEN
12165: l_attributes := l_attributes || 'PROGRAM_ID, ';
12166: END IF;
12164: THEN
12165: l_attributes := l_attributes || 'PROGRAM_ID, ';
12166: END IF;
12167:
12168: IF p_user_in_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
12169: AND NVL(p_user_in_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j'))
12170: THEN
12171: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
12172: END IF;
12170: THEN
12171: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
12172: END IF;
12173:
12174: IF p_user_in_rec.REQUEST_ID <> FND_API.G_MISS_NUM
12175: AND NVL(p_user_in_rec.REQUEST_ID,-99) <> NVL(p_out_rec.REQUEST_ID,-99)
12176: THEN
12177: l_attributes := l_attributes || 'REQUEST_ID, ';
12178: END IF;
12177: l_attributes := l_attributes || 'REQUEST_ID, ';
12178: END IF;
12179: **/
12180:
12181: IF p_user_in_rec.BATCH_ID <> FND_API.G_MISS_NUM
12182: AND NVL(p_user_in_rec.BATCH_ID,-99) <> NVL(p_out_rec.BATCH_ID,-99)
12183: THEN
12184: l_attributes := l_attributes || 'BATCH_ID, ';
12185: END IF;
12183: THEN
12184: l_attributes := l_attributes || 'BATCH_ID, ';
12185: END IF;
12186:
12187: IF p_user_in_rec.HASH_VALUE <> FND_API.G_MISS_NUM
12188: AND NVL(p_user_in_rec.HASH_VALUE,-99) <> NVL(p_out_rec.HASH_VALUE,-99)
12189: THEN
12190: l_attributes := l_attributes || 'HASH_VALUE, ';
12191: END IF;
12189: THEN
12190: l_attributes := l_attributes || 'HASH_VALUE, ';
12191: END IF;
12192:
12193: IF p_user_in_rec.SOURCE_HEADER_ID <> FND_API.G_MISS_NUM
12194: AND NVL(p_user_in_rec.SOURCE_HEADER_ID,-99) <> NVL(p_out_rec.SOURCE_HEADER_ID,-99)
12195: THEN
12196: l_attributes := l_attributes || 'SOURCE_HEADER_ID, ';
12197: END IF;
12195: THEN
12196: l_attributes := l_attributes || 'SOURCE_HEADER_ID, ';
12197: END IF;
12198:
12199: IF p_user_in_rec.NUMBER_OF_LPN <> FND_API.G_MISS_NUM
12200: AND NVL(p_user_in_rec.NUMBER_OF_LPN,-99) <> NVL(p_out_rec.NUMBER_OF_LPN,-99)
12201: THEN
12202: l_attributes := l_attributes || 'NUMBER_OF_LPN, ';
12203: END IF;
12201: THEN
12202: l_attributes := l_attributes || 'NUMBER_OF_LPN, ';
12203: END IF;
12204:
12205: IF p_user_in_rec.COD_AMOUNT <> FND_API.G_MISS_NUM
12206: AND NVL(p_user_in_rec.COD_AMOUNT,-99) <> NVL(p_out_rec.COD_AMOUNT,-99)
12207: THEN
12208: l_attributes := l_attributes || 'COD_AMOUNT, ';
12209: END IF;
12207: THEN
12208: l_attributes := l_attributes || 'COD_AMOUNT, ';
12209: END IF;
12210:
12211: IF p_user_in_rec.COD_CURRENCY_CODE <> FND_API.G_MISS_CHAR
12212: AND NVL(p_user_in_rec.COD_CURRENCY_CODE,'!!!') <> NVL(p_out_rec.COD_CURRENCY_CODE,'!!!')
12213: THEN
12214: l_attributes := l_attributes || 'COD_CURRENCY_CODE, ';
12215: END IF;
12213: THEN
12214: l_attributes := l_attributes || 'COD_CURRENCY_CODE, ';
12215: END IF;
12216:
12217: IF p_user_in_rec.COD_REMIT_TO <> FND_API.G_MISS_CHAR
12218: AND NVL(p_user_in_rec.COD_REMIT_TO,'!!!') <> NVL(p_out_rec.COD_REMIT_TO,'!!!')
12219: THEN
12220: l_attributes := l_attributes || 'COD_REMIT_TO, ';
12221: END IF;
12219: THEN
12220: l_attributes := l_attributes || 'COD_REMIT_TO, ';
12221: END IF;
12222:
12223: IF p_user_in_rec.COD_CHARGE_PAID_BY <> FND_API.G_MISS_CHAR
12224: AND NVL(p_user_in_rec.COD_CHARGE_PAID_BY,'!!!') <> NVL(p_out_rec.COD_CHARGE_PAID_BY,'!!!')
12225: THEN
12226: l_attributes := l_attributes || 'COD_CHARGE_PAID_BY, ';
12227: END IF;
12225: THEN
12226: l_attributes := l_attributes || 'COD_CHARGE_PAID_BY, ';
12227: END IF;
12228:
12229: IF p_user_in_rec.PROBLEM_CONTACT_REFERENCE <> FND_API.G_MISS_CHAR
12230: AND NVL(p_user_in_rec.PROBLEM_CONTACT_REFERENCE,'!!!') <> NVL(p_out_rec.PROBLEM_CONTACT_REFERENCE,'!!!')
12231: THEN
12232: l_attributes := l_attributes || 'PROBLEM_CONTACT_REFERENCE, ';
12233: END IF;
12231: THEN
12232: l_attributes := l_attributes || 'PROBLEM_CONTACT_REFERENCE, ';
12233: END IF;
12234:
12235: IF p_user_in_rec.PORT_OF_LOADING <> FND_API.G_MISS_CHAR
12236: AND NVL(p_user_in_rec.PORT_OF_LOADING,'!!!') <> NVL(p_out_rec.PORT_OF_LOADING,'!!!')
12237: THEN
12238: l_attributes := l_attributes || 'PORT_OF_LOADING, ';
12239: END IF;
12237: THEN
12238: l_attributes := l_attributes || 'PORT_OF_LOADING, ';
12239: END IF;
12240:
12241: IF p_user_in_rec.PORT_OF_DISCHARGE <> FND_API.G_MISS_CHAR
12242: AND NVL(p_user_in_rec.PORT_OF_DISCHARGE,'!!!') <> NVL(p_out_rec.PORT_OF_DISCHARGE,'!!!')
12243: THEN
12244: l_attributes := l_attributes || 'PORT_OF_DISCHARGE, ';
12245: END IF;
12243: THEN
12244: l_attributes := l_attributes || 'PORT_OF_DISCHARGE, ';
12245: END IF;
12246:
12247: IF p_user_in_rec.FTZ_NUMBER <> FND_API.G_MISS_CHAR
12248: AND NVL(p_user_in_rec.FTZ_NUMBER,'!!!') <> NVL(p_out_rec.FTZ_NUMBER,'!!!')
12249: THEN
12250: l_attributes := l_attributes || 'FTZ_NUMBER, ';
12251: END IF;
12249: THEN
12250: l_attributes := l_attributes || 'FTZ_NUMBER, ';
12251: END IF;
12252:
12253: IF p_user_in_rec.ROUTED_EXPORT_TXN <> FND_API.G_MISS_CHAR
12254: AND NVL(p_user_in_rec.ROUTED_EXPORT_TXN,'!!!') <> NVL(p_out_rec.ROUTED_EXPORT_TXN,'!!!')
12255: THEN
12256: l_attributes := l_attributes || 'ROUTED_EXPORT_TXN, ';
12257: END IF;
12255: THEN
12256: l_attributes := l_attributes || 'ROUTED_EXPORT_TXN, ';
12257: END IF;
12258:
12259: IF p_user_in_rec.ENTRY_NUMBER <> FND_API.G_MISS_CHAR
12260: AND NVL(p_user_in_rec.ENTRY_NUMBER,'!!!') <> NVL(p_out_rec.ENTRY_NUMBER,'!!!')
12261: THEN
12262: l_attributes := l_attributes || 'ENTRY_NUMBER, ';
12263: END IF;
12261: THEN
12262: l_attributes := l_attributes || 'ENTRY_NUMBER, ';
12263: END IF;
12264:
12265: IF p_user_in_rec.ROUTING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
12266: AND NVL(p_user_in_rec.ROUTING_INSTRUCTIONS,'!!!') <> NVL(p_out_rec.ROUTING_INSTRUCTIONS,'!!!')
12267: THEN
12268: l_attributes := l_attributes || 'ROUTING_INSTRUCTIONS, ';
12269: END IF;
12267: THEN
12268: l_attributes := l_attributes || 'ROUTING_INSTRUCTIONS, ';
12269: END IF;
12270:
12271: IF p_user_in_rec.IN_BOND_CODE <> FND_API.G_MISS_CHAR
12272: AND NVL(p_user_in_rec.IN_BOND_CODE,'!!!') <> NVL(p_out_rec.IN_BOND_CODE,'!!!')
12273: THEN
12274: l_attributes := l_attributes || 'IN_BOND_CODE, ';
12275: END IF;
12273: THEN
12274: l_attributes := l_attributes || 'IN_BOND_CODE, ';
12275: END IF;
12276:
12277: IF p_user_in_rec.SHIPPING_MARKS <> FND_API.G_MISS_CHAR
12278: AND NVL(p_user_in_rec.SHIPPING_MARKS,'!!!') <> NVL(p_out_rec.SHIPPING_MARKS,'!!!')
12279: THEN
12280: l_attributes := l_attributes || 'SHIPPING_MARKS, ';
12281: END IF;
12279: THEN
12280: l_attributes := l_attributes || 'SHIPPING_MARKS, ';
12281: END IF;
12282:
12283: IF p_user_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
12284: AND NVL(p_user_in_rec.SERVICE_LEVEL,'!!!') <> NVL(p_out_rec.SERVICE_LEVEL,'!!!')
12285: THEN
12286: l_attributes := l_attributes || 'SERVICE_LEVEL, ';
12287: END IF;
12285: THEN
12286: l_attributes := l_attributes || 'SERVICE_LEVEL, ';
12287: END IF;
12288:
12289: IF p_user_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
12290: AND NVL(p_user_in_rec.MODE_OF_TRANSPORT,'!!!') <> NVL(p_out_rec.MODE_OF_TRANSPORT,'!!!')
12291: THEN
12292: l_attributes := l_attributes || 'MODE_OF_TRANSPORT, ';
12293: END IF;
12291: THEN
12292: l_attributes := l_attributes || 'MODE_OF_TRANSPORT, ';
12293: END IF;
12294:
12295: IF p_user_in_rec.ASSIGNED_TO_FTE_TRIPS <> FND_API.G_MISS_CHAR
12296: AND NVL(p_user_in_rec.ASSIGNED_TO_FTE_TRIPS,'!!!') <> NVL(p_out_rec.ASSIGNED_TO_FTE_TRIPS,'!!!')
12297: THEN
12298: l_attributes := l_attributes || 'ASSIGNED_TO_FTE_TRIPS, ';
12299: END IF;
12297: THEN
12298: l_attributes := l_attributes || 'ASSIGNED_TO_FTE_TRIPS, ';
12299: END IF;
12300:
12301: IF p_user_in_rec.AUTO_SC_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
12302: AND NVL(p_user_in_rec.AUTO_SC_EXCLUDE_FLAG,'!!!') <> NVL(p_out_rec.AUTO_SC_EXCLUDE_FLAG,'!!!')
12303: THEN
12304: l_attributes := l_attributes || 'AUTO_SC_EXCLUDE_FLAG, ';
12305: END IF;
12303: THEN
12304: l_attributes := l_attributes || 'AUTO_SC_EXCLUDE_FLAG, ';
12305: END IF;
12306:
12307: IF p_user_in_rec.AUTO_AP_EXCLUDE_FLAG <> FND_API.G_MISS_CHAR
12308: AND NVL(p_user_in_rec.AUTO_AP_EXCLUDE_FLAG,'!!!') <> NVL(p_out_rec.AUTO_AP_EXCLUDE_FLAG,'!!!')
12309: THEN
12310: l_attributes := l_attributes || 'AUTO_AP_EXCLUDE_FLAG, ';
12311: END IF;
12309: THEN
12310: l_attributes := l_attributes || 'AUTO_AP_EXCLUDE_FLAG, ';
12311: END IF;
12312:
12313: IF p_user_in_rec.AP_BATCH_ID <> FND_API.G_MISS_NUM
12314: AND NVL(p_user_in_rec.AP_BATCH_ID,-99) <> NVL(p_out_rec.AP_BATCH_ID,-99)
12315: THEN
12316: l_attributes := l_attributes || 'AP_BATCH_ID, ';
12317: END IF;
12315: THEN
12316: l_attributes := l_attributes || 'AP_BATCH_ID, ';
12317: END IF;
12318:
12319: IF p_user_in_rec.ROWID <> FND_API.G_MISS_CHAR
12320: AND NVL(p_user_in_rec.ROWID,'!!!') <> NVL(p_out_rec.ROWID,'!!!')
12321: THEN
12322: l_attributes := l_attributes || 'ROWID, ';
12323: END IF;
12321: THEN
12322: l_attributes := l_attributes || 'ROWID, ';
12323: END IF;
12324:
12325: IF p_user_in_rec.LOADING_ORDER_DESC <> FND_API.G_MISS_CHAR
12326: AND NVL(p_user_in_rec.LOADING_ORDER_DESC,'!!!') <> NVL(p_out_rec.LOADING_ORDER_DESC,'!!!')
12327: THEN
12328: l_attributes := l_attributes || 'LOADING_ORDER_DESC, ';
12329: END IF;
12327: THEN
12328: l_attributes := l_attributes || 'LOADING_ORDER_DESC, ';
12329: END IF;
12330:
12331: IF p_user_in_rec.ORGANIZATION_CODE <> FND_API.G_MISS_CHAR
12332: AND NVL(p_user_in_rec.ORGANIZATION_CODE,'!!!') <> NVL(p_out_rec.ORGANIZATION_CODE,'!!!')
12333: THEN
12334: l_attributes := l_attributes || 'ORGANIZATION_CODE, ';
12335: END IF;
12333: THEN
12334: l_attributes := l_attributes || 'ORGANIZATION_CODE, ';
12335: END IF;
12336:
12337: IF p_user_in_rec.ULTIMATE_DROPOFF_LOCATION_CODE <> FND_API.G_MISS_CHAR
12338: AND NVL(p_user_in_rec.ULTIMATE_DROPOFF_LOCATION_CODE,'!!!') <> NVL(p_out_rec.ULTIMATE_DROPOFF_LOCATION_CODE,'!!!')
12339: THEN
12340: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_LOCATION_CODE, ';
12341: END IF;
12339: THEN
12340: l_attributes := l_attributes || 'ULTIMATE_DROPOFF_LOCATION_CODE, ';
12341: END IF;
12342:
12343: IF p_user_in_rec.INITIAL_PICKUP_LOCATION_CODE <> FND_API.G_MISS_CHAR
12344: AND NVL(p_user_in_rec.INITIAL_PICKUP_LOCATION_CODE,'!!!') <> NVL(p_out_rec.INITIAL_PICKUP_LOCATION_CODE,'!!!')
12345: THEN
12346: l_attributes := l_attributes || 'INITIAL_PICKUP_LOCATION_CODE, ';
12347: END IF;
12345: THEN
12346: l_attributes := l_attributes || 'INITIAL_PICKUP_LOCATION_CODE, ';
12347: END IF;
12348:
12349: IF p_user_in_rec.CUSTOMER_NUMBER <> FND_API.G_MISS_CHAR
12350: AND NVL(p_user_in_rec.CUSTOMER_NUMBER,'!!!') <> NVL(p_out_rec.CUSTOMER_NUMBER,'!!!')
12351: THEN
12352: l_attributes := l_attributes || 'CUSTOMER_NUMBER, ';
12353: END IF;
12351: THEN
12352: l_attributes := l_attributes || 'CUSTOMER_NUMBER, ';
12353: END IF;
12354:
12355: IF p_user_in_rec.INTMED_SHIP_TO_LOCATION_CODE <> FND_API.G_MISS_CHAR
12356: AND NVL(p_user_in_rec.INTMED_SHIP_TO_LOCATION_CODE,'!!!') <> NVL(p_out_rec.INTMED_SHIP_TO_LOCATION_CODE,'!!!')
12357: THEN
12358: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_CODE, ';
12359: END IF;
12357: THEN
12358: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_CODE, ';
12359: END IF;
12360:
12361: IF p_user_in_rec.POOLED_SHIP_TO_LOCATION_CODE <> FND_API.G_MISS_CHAR
12362: AND NVL(p_user_in_rec.POOLED_SHIP_TO_LOCATION_CODE,'!!!') <> NVL(p_out_rec.POOLED_SHIP_TO_LOCATION_CODE,'!!!')
12363: THEN
12364: l_attributes := l_attributes || 'POOLED_SHIP_TO_LOCATION_CODE, ';
12365: END IF;
12363: THEN
12364: l_attributes := l_attributes || 'POOLED_SHIP_TO_LOCATION_CODE, ';
12365: END IF;
12366:
12367: IF p_user_in_rec.CARRIER_CODE <> FND_API.G_MISS_CHAR
12368: AND NVL(p_user_in_rec.CARRIER_CODE,'!!!') <> NVL(p_out_rec.CARRIER_CODE,'!!!')
12369: THEN
12370: l_attributes := l_attributes || 'CARRIER_CODE, ';
12371: END IF;
12369: THEN
12370: l_attributes := l_attributes || 'CARRIER_CODE, ';
12371: END IF;
12372:
12373: IF p_user_in_rec.SHIP_METHOD_NAME <> FND_API.G_MISS_CHAR
12374: AND NVL(p_user_in_rec.SHIP_METHOD_NAME,'!!!') <> NVL(p_out_rec.SHIP_METHOD_NAME,'!!!')
12375: THEN
12376: l_attributes := l_attributes || 'SHIP_METHOD_NAME, ';
12377: END IF;
12375: THEN
12376: l_attributes := l_attributes || 'SHIP_METHOD_NAME, ';
12377: END IF;
12378:
12379: IF p_user_in_rec.FREIGHT_TERMS_NAME <> FND_API.G_MISS_CHAR
12380: AND NVL(p_user_in_rec.FREIGHT_TERMS_NAME,'!!!') <> NVL(p_out_rec.FREIGHT_TERMS_NAME,'!!!')
12381: THEN
12382: l_attributes := l_attributes || 'FREIGHT_TERMS_NAME, ';
12383: END IF;
12381: THEN
12382: l_attributes := l_attributes || 'FREIGHT_TERMS_NAME, ';
12383: END IF;
12384:
12385: IF p_user_in_rec.FOB_NAME <> FND_API.G_MISS_CHAR
12386: AND NVL(p_user_in_rec.FOB_NAME,'!!!') <> NVL(p_out_rec.FOB_NAME,'!!!')
12387: THEN
12388: l_attributes := l_attributes || 'FOB_NAME, ';
12389: END IF;
12387: THEN
12388: l_attributes := l_attributes || 'FOB_NAME, ';
12389: END IF;
12390:
12391: IF p_user_in_rec.FOB_LOCATION_CODE <> FND_API.G_MISS_CHAR
12392: AND NVL(p_user_in_rec.FOB_LOCATION_CODE,'!!!') <> NVL(p_out_rec.FOB_LOCATION_CODE,'!!!')
12393: THEN
12394: l_attributes := l_attributes || 'FOB_LOCATION_CODE, ';
12395: END IF;
12393: THEN
12394: l_attributes := l_attributes || 'FOB_LOCATION_CODE, ';
12395: END IF;
12396:
12397: IF p_user_in_rec.WEIGHT_UOM_DESC <> FND_API.G_MISS_CHAR
12398: AND NVL(p_user_in_rec.WEIGHT_UOM_DESC,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_DESC,'!!!')
12399: THEN
12400: l_attributes := l_attributes || 'WEIGHT_UOM_DESC, ';
12401: END IF;
12399: THEN
12400: l_attributes := l_attributes || 'WEIGHT_UOM_DESC, ';
12401: END IF;
12402:
12403: IF p_user_in_rec.VOLUME_UOM_DESC <> FND_API.G_MISS_CHAR
12404: AND NVL(p_user_in_rec.VOLUME_UOM_DESC,'!!!') <> NVL(p_out_rec.VOLUME_UOM_DESC,'!!!')
12405: THEN
12406: l_attributes := l_attributes || 'VOLUME_UOM_DESC, ';
12407: END IF;
12405: THEN
12406: l_attributes := l_attributes || 'VOLUME_UOM_DESC, ';
12407: END IF;
12408:
12409: IF p_user_in_rec.CURRENCY_NAME <> FND_API.G_MISS_CHAR
12410: AND NVL(p_user_in_rec.CURRENCY_NAME,'!!!') <> NVL(p_out_rec.CURRENCY_NAME,'!!!')
12411: THEN
12412: l_attributes := l_attributes || 'CURRENCY_NAME, ';
12413: END IF;
12411: THEN
12412: l_attributes := l_attributes || 'CURRENCY_NAME, ';
12413: END IF;
12414:
12415: IF p_user_in_rec.SHIPMENT_DIRECTION <> FND_API.G_MISS_CHAR
12416: AND NVL(p_user_in_rec.SHIPMENT_DIRECTION,'!!!') <> NVL(p_out_rec.SHIPMENT_DIRECTION,'!!!')
12417: THEN
12418: l_attributes := l_attributes || 'SHIPMENT_DIRECTION, ';
12419: END IF;
12417: THEN
12418: l_attributes := l_attributes || 'SHIPMENT_DIRECTION, ';
12419: END IF;
12420:
12421: IF p_user_in_rec.VENDOR_ID <> FND_API.G_MISS_NUM
12422: AND NVL(p_user_in_rec.VENDOR_ID,-99) <> NVL(p_out_rec.VENDOR_ID,-99)
12423: THEN
12424: l_attributes := l_attributes || 'VENDOR_ID, ';
12425: END IF;
12423: THEN
12424: l_attributes := l_attributes || 'VENDOR_ID, ';
12425: END IF;
12426:
12427: IF p_user_in_rec.PARTY_ID <> FND_API.G_MISS_NUM
12428: AND NVL(p_user_in_rec.PARTY_ID,-99) <> NVL(p_out_rec.PARTY_ID,-99)
12429: THEN
12430: l_attributes := l_attributes || 'PARTY_ID, ';
12431: END IF;
12429: THEN
12430: l_attributes := l_attributes || 'PARTY_ID, ';
12431: END IF;
12432:
12433: IF p_user_in_rec.ROUTING_RESPONSE_ID <> FND_API.G_MISS_NUM
12434: AND NVL(p_user_in_rec.ROUTING_RESPONSE_ID,-99) <> NVL(p_out_rec.ROUTING_RESPONSE_ID,-99)
12435: THEN
12436: l_attributes := l_attributes || 'ROUTING_RESPONSE_ID, ';
12437: END IF;
12435: THEN
12436: l_attributes := l_attributes || 'ROUTING_RESPONSE_ID, ';
12437: END IF;
12438:
12439: IF p_user_in_rec.RCV_SHIPMENT_HEADER_ID <> FND_API.G_MISS_NUM
12440: AND NVL(p_user_in_rec.RCV_SHIPMENT_HEADER_ID,-99) <> NVL(p_out_rec.RCV_SHIPMENT_HEADER_ID,-99)
12441: THEN
12442: l_attributes := l_attributes || 'RCV_SHIPMENT_HEADER_ID, ';
12443: END IF;
12441: THEN
12442: l_attributes := l_attributes || 'RCV_SHIPMENT_HEADER_ID, ';
12443: END IF;
12444:
12445: IF p_user_in_rec.ASN_SHIPMENT_HEADER_ID <> FND_API.G_MISS_NUM
12446: AND NVL(p_user_in_rec.ASN_SHIPMENT_HEADER_ID,-99) <> NVL(p_out_rec.ASN_SHIPMENT_HEADER_ID,-99)
12447: THEN
12448: l_attributes := l_attributes || 'ASN_SHIPMENT_HEADER_ID, ';
12449: END IF;
12447: THEN
12448: l_attributes := l_attributes || 'ASN_SHIPMENT_HEADER_ID, ';
12449: END IF;
12450:
12451: IF p_user_in_rec.SHIPPING_CONTROL <> FND_API.G_MISS_CHAR
12452: AND NVL(p_user_in_rec.SHIPPING_CONTROL,'!!!') <> NVL(p_out_rec.SHIPPING_CONTROL,'!!!')
12453: THEN
12454: l_attributes := l_attributes || 'SHIPPING_CONTROL, ';
12455: END IF;
12453: THEN
12454: l_attributes := l_attributes || 'SHIPPING_CONTROL, ';
12455: END IF;
12456:
12457: IF p_user_in_rec.TP_DELIVERY_NUMBER <> FND_API.G_MISS_NUM
12458: AND NVL(p_user_in_rec.TP_DELIVERY_NUMBER,-99) <> NVL(p_out_rec.TP_DELIVERY_NUMBER,-99)
12459: THEN
12460: l_attributes := l_attributes || 'TP_DELIVERY_NUMBER, ';
12461: END IF;
12459: THEN
12460: l_attributes := l_attributes || 'TP_DELIVERY_NUMBER, ';
12461: END IF;
12462:
12463: IF p_user_in_rec.EARLIEST_PICKUP_DATE <> FND_API.G_MISS_DATE
12464: AND NVL(p_user_in_rec.EARLIEST_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.EARLIEST_PICKUP_DATE,TO_DATE('2','j'))
12465: THEN
12466: l_attributes := l_attributes || 'EARLIEST_PICKUP_DATE, ';
12467: END IF;
12465: THEN
12466: l_attributes := l_attributes || 'EARLIEST_PICKUP_DATE, ';
12467: END IF;
12468:
12469: IF p_user_in_rec.LATEST_PICKUP_DATE <> FND_API.G_MISS_DATE
12470: AND NVL(p_user_in_rec.LATEST_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LATEST_PICKUP_DATE,TO_DATE('2','j'))
12471: THEN
12472: l_attributes := l_attributes || 'LATEST_PICKUP_DATE, ';
12473: END IF;
12471: THEN
12472: l_attributes := l_attributes || 'LATEST_PICKUP_DATE, ';
12473: END IF;
12474:
12475: IF p_user_in_rec.EARLIEST_DROPOFF_DATE <> FND_API.G_MISS_DATE
12476: AND NVL(p_user_in_rec.EARLIEST_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.EARLIEST_DROPOFF_DATE,TO_DATE('2','j'))
12477: THEN
12478: l_attributes := l_attributes || 'EARLIEST_DROPOFF_DATE, ';
12479: END IF;
12477: THEN
12478: l_attributes := l_attributes || 'EARLIEST_DROPOFF_DATE, ';
12479: END IF;
12480:
12481: IF p_user_in_rec.LATEST_DROPOFF_DATE <> FND_API.G_MISS_DATE
12482: AND NVL(p_user_in_rec.LATEST_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LATEST_DROPOFF_DATE,TO_DATE('2','j'))
12483: THEN
12484: l_attributes := l_attributes || 'LATEST_DROPOFF_DATE, ';
12485: END IF;
12483: THEN
12484: l_attributes := l_attributes || 'LATEST_DROPOFF_DATE, ';
12485: END IF;
12486:
12487: IF p_user_in_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR
12488: AND NVL(p_user_in_rec.IGNORE_FOR_PLANNING,'!!!') <> NVL(p_out_rec.IGNORE_FOR_PLANNING,'!!!')
12489: THEN
12490: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING, ';
12491: END IF;
12489: THEN
12490: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING, ';
12491: END IF;
12492:
12493: IF p_user_in_rec.TP_PLAN_NAME <> FND_API.G_MISS_CHAR
12494: AND NVL(p_user_in_rec.TP_PLAN_NAME,'!!!') <> NVL(p_out_rec.TP_PLAN_NAME,'!!!')
12495: THEN
12496: l_attributes := l_attributes || 'TP_PLAN_NAME, ';
12497: END IF;
12495: THEN
12496: l_attributes := l_attributes || 'TP_PLAN_NAME, ';
12497: END IF;
12498:
12499: IF p_user_in_rec.WV_FROZEN_FLAG <> FND_API.G_MISS_CHAR
12500: AND NVL(p_user_in_rec.WV_FROZEN_FLAG,'!!!') <> NVL(p_out_rec.WV_FROZEN_FLAG,'!!!')
12501: THEN
12502: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
12503: END IF;
12501: THEN
12502: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
12503: END IF;
12504:
12505: IF p_user_in_rec.HASH_STRING <> FND_API.G_MISS_CHAR
12506: AND NVL(p_user_in_rec.HASH_STRING,'!!!') <> NVL(p_out_rec.HASH_STRING,'!!!')
12507: THEN
12508: l_attributes := l_attributes || 'HASH_STRING, ';
12509: END IF;
12507: THEN
12508: l_attributes := l_attributes || 'HASH_STRING, ';
12509: END IF;
12510:
12511: IF p_user_in_rec.DELIVERED_DATE <> FND_API.G_MISS_DATE
12512: AND NVL(p_user_in_rec.DELIVERED_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.DELIVERED_DATE,TO_DATE('2','j'))
12513: THEN
12514: l_attributes := l_attributes || 'DELIVERED_DATE, ';
12515: END IF;
12513: THEN
12514: l_attributes := l_attributes || 'DELIVERED_DATE, ';
12515: END IF;
12516:
12517: IF p_user_in_rec.PACKING_SLIP <> FND_API.G_MISS_CHAR
12518: AND NVL(p_user_in_rec.PACKING_SLIP,'!!!') <> NVL(p_out_rec.PACKING_SLIP,'!!!')
12519: THEN
12520: l_attributes := l_attributes || 'PACKING_SLIP, ';
12521: END IF;
12637: RETURN l_is_del_eligible;
12638:
12639: EXCEPTION
12640: WHEN OTHERS THEN
12641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12642: WSH_UTIL_CORE.default_handler('WSH_DELIVERIES_GRP.is_del_eligible_pick');
12643: IF l_debug_on THEN
12644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
12645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
12641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12642: WSH_UTIL_CORE.default_handler('WSH_DELIVERIES_GRP.is_del_eligible_pick');
12643: IF l_debug_on THEN
12644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
12645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
12646: END IF;
12647: RETURN FALSE;
12648:
12649: END Is_del_eligible_pick;