[Home] [Help]
1071: -- p_source_header_id - optional
1072: -- p_init_flag - 'Y' initializes the table of bad header ids
1073: -- x_return_status
1074: -- Description: Checks if there are any credit checks or holds on a line.
1075: -- Returns a status of FND_API.G_RET_STS_SUCCESS if no such
1076: -- checks or holds exist
1077: --
1078: -----------------------------------------------------------------------------
1079:
1315: p_msg_count => l_msg_count,
1316: p_msg_data => l_msg_data,
1317: p_return_status => x_return_status);
1318:
1319: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1320: g_bad_header_ids(l_bad_index) := l_header_id;
1321: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1322: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1323: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1353: x_msg_data => l_msg_data);
1354:
1355: -- If hold is found return back
1356:
1357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_result_out = FND_API.G_TRUE) THEN
1358: g_bad_header_ids(l_bad_index) := l_header_id;
1359: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1360: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1361: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1480: x_return_status => x_return_status,
1481: x_msg_count => l_msg_count,
1482: x_msg_data => l_msg_data);
1483:
1484: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_result_out = FND_API.G_TRUE) THEN
1485: --
1486: -- Debug Statements
1487: --
1488: IF l_debug_on THEN
1917: WSH_DEBUG_SV.log(l_module_name,'Min Qty'||l_min_quantity);
1918: WSH_DEBUG_SV.log(l_module_name,'Qty UOM'||l_quantity_uom);
1919: END IF;
1920:
1921: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1922: raise others ;
1923: END IF;
1924:
1925:
2344: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2345: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
2346: END IF;
2347: --
2348: x_return_status := FND_API.G_RET_STS_SUCCESS;
2349: -- clear the disabled list first
2350: x_disabled_list.delete;
2351: -- OPM 09/11/00
2352: OPEN dd_info;
2777: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
2778: END IF;
2779:
2780: WHEN wsh_dp_no_entity THEN
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: -- Bug fix 2650464
2783: -- new message for invalid delivery details
2784: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_NOT_EXIST');
2785: IF p_delivery_detail_id = FND_API.G_MISS_NUM THEN
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: -- Bug fix 2650464
2783: -- new message for invalid delivery details
2784: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_NOT_EXIST');
2785: IF p_delivery_detail_id = FND_API.G_MISS_NUM THEN
2786: l_delivery_detail_id := NULL;
2787: ELSE
2788: l_delivery_detail_id := p_delivery_detail_id;
2789: END IF;
2804: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
2805: END IF;
2806: --
2807: WHEN wsh_del_not_exist THEN -- Bug fix 2650464
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELIVERY_NOT_EXIST');
2810: IF p_delivery_id = FND_API.G_MISS_NUM THEN
2811: l_delivery_id := NULL;
2812: ELSE
2806: --
2807: WHEN wsh_del_not_exist THEN -- Bug fix 2650464
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELIVERY_NOT_EXIST');
2810: IF p_delivery_id = FND_API.G_MISS_NUM THEN
2811: l_delivery_id := NULL;
2812: ELSE
2813: l_delivery_id := p_delivery_id;
2814: END IF;
2826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
2827: END IF;
2828:
2829: WHEN wsh_inv_list_type THEN
2830: x_return_status := FND_API.G_RET_STS_ERROR;
2831: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
2832: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2833: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2834: IF x_msg_count > 1 then
3066: THEN
3067: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3068: END IF;
3069: --
3070: x_return_status := FND_API.G_RET_STS_SUCCESS;
3071:
3072: l_del_shipping_quantity := 0;
3073: l_del_shipping_quantity2 := 0;
3074:
3084:
3085: IF ( p_in_attributes.source_code IS NULL ) THEN
3086: x_msg_count := 1;
3087: x_msg_data := 'INVALID SOURCE_CODE';
3088: x_return_status := FND_API.G_RET_STS_ERROR;
3089: END IF;
3090:
3091: IF p_in_attributes.ship_tolerance_above IS NULL OR
3092: p_in_attributes.action_flag IN ('C', 'I') THEN
3562: IF l_debug_on THEN
3563: wsh_debug_sv.log(l_module_name, 'Return status after wsh_util_validate.get_org_type', l_return_status);
3564: END IF;
3565: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
3566: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3567: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
3568: raise e_record_ineligible;
3569: exit;
3570: END IF;
3762: IF l_debug_on THEN
3763: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
3764: END IF;
3765:
3766: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
3767: IF ( p_del_detail_rec_tab(j).source_code = 'WSH' and p_del_detail_rec_tab(j).container_flag = 'N' ) THEN
3768: x_valid_ids(x_valid_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
3769: x_valid_index_tab(j) := j;
3770: ELSE
3967: IF l_debug_on THEN
3968: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
3969: END IF;
3970:
3971: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ('CMS','TPW')) THEN
3972: IF (p_del_detail_rec_tab(j).source_code = 'WSH' and p_del_detail_rec_tab(j).container_flag = 'N' ) THEN
3973: x_valid_ids(x_valid_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
3974: x_valid_index_tab(j) := j;
3975: ELSE
4003: IF l_debug_on THEN
4004: wsh_debug_sv.log(l_module_name, 'Error Id', p_del_detail_rec_tab(j).delivery_detail_id);
4005: END IF;
4006: x_error_ids(x_error_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
4007: IF nvl(p_caller, FND_API.G_MISS_CHAR) = 'WSH_PUB'
4008: OR p_caller like 'FTE%' THEN
4009: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_ACTION_INELIGIBLE');
4010: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_del_detail_rec_tab(j).delivery_detail_id);
4011: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('DLVB',p_action));
4019: IF l_debug_on THEN
4020: wsh_debug_sv.log(l_module_name, 'Error Id', p_del_detail_rec_tab(j).delivery_detail_id);
4021: END IF;
4022: x_error_ids(x_error_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
4023: IF nvl(p_caller, FND_API.G_MISS_CHAR) = 'WSH_PUB'
4024: OR p_caller like 'FTE%' THEN
4025: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_ACTION_INELIGIBLE');
4026: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_del_detail_rec_tab(j).delivery_detail_id);
4027: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('DLVB',p_action));
4035: IF l_debug_on THEN
4036: wsh_debug_sv.log(l_module_name, 'Error Id', p_del_detail_rec_tab(j).delivery_detail_id);
4037: END IF;
4038: x_error_ids(x_error_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
4039: IF nvl(p_caller, FND_API.G_MISS_CHAR) = 'WSH_PUB'
4040: OR p_caller like 'FTE%' THEN
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_ASSIGN_FIRMDEL_ERROR');
4042: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_del_detail_rec_tab(j).delivery_detail_id);
4043: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_deliveryid));
4047: WHEN others THEN
4048: IF det_to_del_cur%ISOPEN THEN
4049: CLOSE det_to_del_cur;
4050: END IF;
4051: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4052: END; -- Local BEGIN
4053:
4054: END LOOP;
4055:
4091: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4092: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
4093: END IF;
4094:
4095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4097: wsh_util_core.add_message(x_return_status, l_module_name);
4098: IF l_debug_on THEN
4099: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4092: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
4093: END IF;
4094:
4095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4097: wsh_util_core.add_message(x_return_status, l_module_name);
4098: IF l_debug_on THEN
4099: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4097: wsh_util_core.add_message(x_return_status, l_module_name);
4098: IF l_debug_on THEN
4099: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4101: END IF;
4102: IF c_staged_content%ISOPEN THEN
4103: CLOSE c_staged_content;
4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4097: wsh_util_core.add_message(x_return_status, l_module_name);
4098: IF l_debug_on THEN
4099: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4101: END IF;
4102: IF c_staged_content%ISOPEN THEN
4103: CLOSE c_staged_content;
4104: END IF;
4144: permanently disabled.
4145: */
4146:
4147: --
4148: IF p_delivery_detail_rec.container_name <> FND_API.G_MISS_CHAR
4149: OR p_delivery_detail_rec.container_name IS NULL THEN
4150: x_delivery_detail_rec.container_name :=
4151: p_delivery_detail_rec.container_name;
4152: END IF;
4149: OR p_delivery_detail_rec.container_name IS NULL THEN
4150: x_delivery_detail_rec.container_name :=
4151: p_delivery_detail_rec.container_name;
4152: END IF;
4153: IF p_delivery_detail_rec.shipped_quantity <> FND_API.G_MISS_NUM
4154: OR p_delivery_detail_rec.shipped_quantity IS NULL THEN
4155: x_delivery_detail_rec.shipped_quantity :=
4156: p_delivery_detail_rec.shipped_quantity;
4157: END IF;
4154: OR p_delivery_detail_rec.shipped_quantity IS NULL THEN
4155: x_delivery_detail_rec.shipped_quantity :=
4156: p_delivery_detail_rec.shipped_quantity;
4157: END IF;
4158: IF p_delivery_detail_rec.shipped_quantity2 <> FND_API.G_MISS_NUM
4159: OR p_delivery_detail_rec.shipped_quantity2 IS NULL THEN
4160: x_delivery_detail_rec.shipped_quantity2 :=
4161: p_delivery_detail_rec.shipped_quantity2;
4162: END IF;
4159: OR p_delivery_detail_rec.shipped_quantity2 IS NULL THEN
4160: x_delivery_detail_rec.shipped_quantity2 :=
4161: p_delivery_detail_rec.shipped_quantity2;
4162: END IF;
4163: IF p_delivery_detail_rec.cycle_count_quantity <> FND_API.G_MISS_NUM
4164: OR p_delivery_detail_rec.cycle_count_quantity IS NULL THEN
4165: x_delivery_detail_rec.cycle_count_quantity :=
4166: p_delivery_detail_rec.cycle_count_quantity;
4167: END IF;
4164: OR p_delivery_detail_rec.cycle_count_quantity IS NULL THEN
4165: x_delivery_detail_rec.cycle_count_quantity :=
4166: p_delivery_detail_rec.cycle_count_quantity;
4167: END IF;
4168: IF p_delivery_detail_rec.cycle_count_quantity2 <> FND_API.G_MISS_NUM
4169: OR p_delivery_detail_rec.cycle_count_quantity2 IS NULL THEN
4170: x_delivery_detail_rec.cycle_count_quantity2 :=
4171: p_delivery_detail_rec.cycle_count_quantity2;
4172: END IF;
4169: OR p_delivery_detail_rec.cycle_count_quantity2 IS NULL THEN
4170: x_delivery_detail_rec.cycle_count_quantity2 :=
4171: p_delivery_detail_rec.cycle_count_quantity2;
4172: END IF;
4173: IF p_delivery_detail_rec.delivered_quantity <> FND_API.G_MISS_NUM
4174: OR p_delivery_detail_rec.delivered_quantity IS NULL THEN
4175: x_delivery_detail_rec.delivered_quantity :=
4176: p_delivery_detail_rec.delivered_quantity;
4177: END IF;
4174: OR p_delivery_detail_rec.delivered_quantity IS NULL THEN
4175: x_delivery_detail_rec.delivered_quantity :=
4176: p_delivery_detail_rec.delivered_quantity;
4177: END IF;
4178: IF p_delivery_detail_rec.delivered_quantity2 <> FND_API.G_MISS_NUM
4179: OR p_delivery_detail_rec.delivered_quantity2 IS NULL THEN
4180: x_delivery_detail_rec.delivered_quantity2 :=
4181: p_delivery_detail_rec.delivered_quantity2;
4182: END IF;
4179: OR p_delivery_detail_rec.delivered_quantity2 IS NULL THEN
4180: x_delivery_detail_rec.delivered_quantity2 :=
4181: p_delivery_detail_rec.delivered_quantity2;
4182: END IF;
4183: IF p_delivery_detail_rec.cancelled_quantity <> FND_API.G_MISS_NUM
4184: OR p_delivery_detail_rec.cancelled_quantity IS NULL THEN
4185: x_delivery_detail_rec.cancelled_quantity :=
4186: p_delivery_detail_rec.cancelled_quantity;
4187: END IF;
4184: OR p_delivery_detail_rec.cancelled_quantity IS NULL THEN
4185: x_delivery_detail_rec.cancelled_quantity :=
4186: p_delivery_detail_rec.cancelled_quantity;
4187: END IF;
4188: IF p_delivery_detail_rec.cancelled_quantity2 <> FND_API.G_MISS_NUM
4189: OR p_delivery_detail_rec.cancelled_quantity2 IS NULL THEN
4190: x_delivery_detail_rec.cancelled_quantity2 :=
4191: p_delivery_detail_rec.cancelled_quantity2;
4192: END IF;
4189: OR p_delivery_detail_rec.cancelled_quantity2 IS NULL THEN
4190: x_delivery_detail_rec.cancelled_quantity2 :=
4191: p_delivery_detail_rec.cancelled_quantity2;
4192: END IF;
4193: IF p_delivery_detail_rec.load_seq_number <> FND_API.G_MISS_NUM
4194: OR p_delivery_detail_rec.load_seq_number IS NULL THEN
4195: x_delivery_detail_rec.load_seq_number :=
4196: p_delivery_detail_rec.load_seq_number;
4197: END IF;
4194: OR p_delivery_detail_rec.load_seq_number IS NULL THEN
4195: x_delivery_detail_rec.load_seq_number :=
4196: p_delivery_detail_rec.load_seq_number;
4197: END IF;
4198: IF p_delivery_detail_rec.gross_weight <> FND_API.G_MISS_NUM
4199: OR p_delivery_detail_rec.gross_weight IS NULL THEN
4200: x_delivery_detail_rec.gross_weight :=
4201: p_delivery_detail_rec.gross_weight;
4202: END IF;
4199: OR p_delivery_detail_rec.gross_weight IS NULL THEN
4200: x_delivery_detail_rec.gross_weight :=
4201: p_delivery_detail_rec.gross_weight;
4202: END IF;
4203: IF p_delivery_detail_rec.net_weight <> FND_API.G_MISS_NUM
4204: OR p_delivery_detail_rec.net_weight IS NULL THEN
4205: x_delivery_detail_rec.net_weight :=
4206: p_delivery_detail_rec.net_weight;
4207: END IF;
4204: OR p_delivery_detail_rec.net_weight IS NULL THEN
4205: x_delivery_detail_rec.net_weight :=
4206: p_delivery_detail_rec.net_weight;
4207: END IF;
4208: IF p_delivery_detail_rec.volume <> FND_API.G_MISS_NUM
4209: OR p_delivery_detail_rec.volume IS NULL THEN
4210: x_delivery_detail_rec.volume :=
4211: p_delivery_detail_rec.volume;
4212: END IF;
4212: END IF;
4213:
4214: -- Update of UOM Codes is allowed only if they are Null and new codes are Valid UOM Codes
4215: IF p_in_rec.action_code = 'UPDATE' THEN
4216: IF p_delivery_detail_rec.weight_uom_code <> FND_API.G_MISS_CHAR
4217: AND p_delivery_detail_rec.weight_uom_code IS NOT NULL
4218: AND x_delivery_detail_rec.weight_uom_code IS NULL THEN
4219: OPEN c_isvalidUOM_Code(p_delivery_detail_rec.weight_uom_code);
4220: FETCH c_isvalidUOM_Code INTO l_uom_code;
4223: p_delivery_detail_rec.weight_uom_code;
4224: END IF;
4225: CLOSE c_isvalidUOM_Code;
4226: END IF;
4227: IF p_delivery_detail_rec.volume_uom_code <> FND_API.G_MISS_CHAR
4228: AND p_delivery_detail_rec.volume_uom_code IS NOT NULL
4229: AND x_delivery_detail_rec.volume_uom_code IS NULL THEN
4230: OPEN c_isvalidUOM_Code(p_delivery_detail_rec.volume_uom_code);
4231: FETCH c_isvalidUOM_Code INTO l_uom_code;
4236: CLOSE c_isvalidUOM_Code;
4237: END IF;
4238: END IF;
4239:
4240: IF p_delivery_detail_rec.fill_percent <> FND_API.G_MISS_NUM
4241: OR p_delivery_detail_rec.fill_percent IS NULL THEN
4242: x_delivery_detail_rec.fill_percent :=
4243: p_delivery_detail_rec.fill_percent;
4244: END IF;
4241: OR p_delivery_detail_rec.fill_percent IS NULL THEN
4242: x_delivery_detail_rec.fill_percent :=
4243: p_delivery_detail_rec.fill_percent;
4244: END IF;
4245: IF p_delivery_detail_rec.master_serial_number <> FND_API.G_MISS_CHAR
4246: OR p_delivery_detail_rec.master_serial_number IS NULL THEN
4247: x_delivery_detail_rec.master_serial_number :=
4248: p_delivery_detail_rec.master_serial_number;
4249: END IF;
4246: OR p_delivery_detail_rec.master_serial_number IS NULL THEN
4247: x_delivery_detail_rec.master_serial_number :=
4248: p_delivery_detail_rec.master_serial_number;
4249: END IF;
4250: IF p_delivery_detail_rec.master_container_item_id <> FND_API.G_MISS_NUM
4251: OR p_delivery_detail_rec.master_container_item_id IS NULL THEN
4252: x_delivery_detail_rec.master_container_item_id :=
4253: p_delivery_detail_rec.master_container_item_id;
4254: END IF;
4251: OR p_delivery_detail_rec.master_container_item_id IS NULL THEN
4252: x_delivery_detail_rec.master_container_item_id :=
4253: p_delivery_detail_rec.master_container_item_id;
4254: END IF;
4255: IF p_delivery_detail_rec.detail_container_item_id <> FND_API.G_MISS_NUM
4256: OR p_delivery_detail_rec.detail_container_item_id IS NULL THEN
4257: x_delivery_detail_rec.detail_container_item_id :=
4258: p_delivery_detail_rec.detail_container_item_id;
4259: END IF;
4256: OR p_delivery_detail_rec.detail_container_item_id IS NULL THEN
4257: x_delivery_detail_rec.detail_container_item_id :=
4258: p_delivery_detail_rec.detail_container_item_id;
4259: END IF;
4260: IF p_delivery_detail_rec.shipping_instructions <> FND_API.G_MISS_CHAR
4261: OR p_delivery_detail_rec.shipping_instructions IS NULL THEN
4262: x_delivery_detail_rec.shipping_instructions :=
4263: p_delivery_detail_rec.shipping_instructions;
4264: END IF;
4261: OR p_delivery_detail_rec.shipping_instructions IS NULL THEN
4262: x_delivery_detail_rec.shipping_instructions :=
4263: p_delivery_detail_rec.shipping_instructions;
4264: END IF;
4265: IF p_delivery_detail_rec.packing_instructions <> FND_API.G_MISS_CHAR
4266: OR p_delivery_detail_rec.packing_instructions IS NULL THEN
4267: x_delivery_detail_rec.packing_instructions :=
4268: p_delivery_detail_rec.packing_instructions;
4269: END IF;
4266: OR p_delivery_detail_rec.packing_instructions IS NULL THEN
4267: x_delivery_detail_rec.packing_instructions :=
4268: p_delivery_detail_rec.packing_instructions;
4269: END IF;
4270: IF p_delivery_detail_rec.revision <> FND_API.G_MISS_CHAR
4271: OR p_delivery_detail_rec.revision IS NULL THEN
4272: x_delivery_detail_rec.revision :=
4273: p_delivery_detail_rec.revision;
4274: END IF;
4271: OR p_delivery_detail_rec.revision IS NULL THEN
4272: x_delivery_detail_rec.revision :=
4273: p_delivery_detail_rec.revision;
4274: END IF;
4275: IF p_delivery_detail_rec.subinventory <> FND_API.G_MISS_CHAR
4276: OR p_delivery_detail_rec.subinventory IS NULL THEN
4277: x_delivery_detail_rec.subinventory :=
4278: p_delivery_detail_rec.subinventory;
4279: END IF;
4276: OR p_delivery_detail_rec.subinventory IS NULL THEN
4277: x_delivery_detail_rec.subinventory :=
4278: p_delivery_detail_rec.subinventory;
4279: END IF;
4280: IF p_delivery_detail_rec.lot_number <> FND_API.G_MISS_CHAR
4281: OR p_delivery_detail_rec.lot_number IS NULL THEN
4282: x_delivery_detail_rec.lot_number :=
4283: p_delivery_detail_rec.lot_number;
4284: END IF;
4283: p_delivery_detail_rec.lot_number;
4284: END IF;
4285: -- HW OPMCONV - No need for sublot_number
4286:
4287: IF p_delivery_detail_rec.locator_id <> FND_API.G_MISS_NUM
4288: OR p_delivery_detail_rec.locator_id IS NULL THEN
4289: x_delivery_detail_rec.locator_id :=
4290: p_delivery_detail_rec.locator_id;
4291: END IF;
4288: OR p_delivery_detail_rec.locator_id IS NULL THEN
4289: x_delivery_detail_rec.locator_id :=
4290: p_delivery_detail_rec.locator_id;
4291: END IF;
4292: IF p_delivery_detail_rec.serial_number <> FND_API.G_MISS_CHAR
4293: OR p_delivery_detail_rec.serial_number IS NULL THEN
4294: x_delivery_detail_rec.serial_number :=
4295: p_delivery_detail_rec.serial_number;
4296: END IF;
4295: p_delivery_detail_rec.serial_number;
4296: END IF;
4297: -- Bug Fix: 2651882. KVENKATE.
4298: -- Need to enable 'to_serial_number'
4299: IF p_delivery_detail_rec.to_serial_number <> FND_API.G_MISS_CHAR
4300: OR p_delivery_detail_rec.to_serial_number IS NULL THEN
4301: x_delivery_detail_rec.to_serial_number :=
4302: p_delivery_detail_rec.to_serial_number;
4303: END IF;
4302: p_delivery_detail_rec.to_serial_number;
4303: END IF;
4304: -- Bug Fix: 2651882. KVENKATE.
4305:
4306: IF p_delivery_detail_rec.preferred_grade <> FND_API.G_MISS_CHAR
4307: OR p_delivery_detail_rec.preferred_grade IS NULL THEN
4308: x_delivery_detail_rec.preferred_grade :=
4309: p_delivery_detail_rec.preferred_grade;
4310: END IF;
4307: OR p_delivery_detail_rec.preferred_grade IS NULL THEN
4308: x_delivery_detail_rec.preferred_grade :=
4309: p_delivery_detail_rec.preferred_grade;
4310: END IF;
4311: IF p_delivery_detail_rec.seal_code <> FND_API.G_MISS_CHAR
4312: OR p_delivery_detail_rec.seal_code IS NULL THEN
4313: x_delivery_detail_rec.seal_code :=
4314: p_delivery_detail_rec.seal_code;
4315: END IF;
4312: OR p_delivery_detail_rec.seal_code IS NULL THEN
4313: x_delivery_detail_rec.seal_code :=
4314: p_delivery_detail_rec.seal_code;
4315: END IF;
4316: IF p_delivery_detail_rec.inspection_flag <> FND_API.G_MISS_CHAR
4317: OR p_delivery_detail_rec.inspection_flag IS NULL THEN
4318: x_delivery_detail_rec.inspection_flag :=
4319: p_delivery_detail_rec.inspection_flag;
4320: END IF;
4317: OR p_delivery_detail_rec.inspection_flag IS NULL THEN
4318: x_delivery_detail_rec.inspection_flag :=
4319: p_delivery_detail_rec.inspection_flag;
4320: END IF;
4321: IF p_delivery_detail_rec.transaction_temp_id <> FND_API.G_MISS_NUM
4322: OR p_delivery_detail_rec.transaction_temp_id IS NULL THEN
4323: x_delivery_detail_rec.transaction_temp_id :=
4324: p_delivery_detail_rec.transaction_temp_id;
4325: END IF;
4324: p_delivery_detail_rec.transaction_temp_id;
4325: END IF;
4326:
4327:
4328: IF p_delivery_detail_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
4329: OR p_delivery_detail_rec.tp_attribute1 IS NULL THEN
4330: x_delivery_detail_rec.tp_attribute1 :=
4331: p_delivery_detail_rec.tp_attribute1;
4332: END IF;
4329: OR p_delivery_detail_rec.tp_attribute1 IS NULL THEN
4330: x_delivery_detail_rec.tp_attribute1 :=
4331: p_delivery_detail_rec.tp_attribute1;
4332: END IF;
4333: IF p_delivery_detail_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
4334: OR p_delivery_detail_rec.tp_attribute2 IS NULL THEN
4335: x_delivery_detail_rec.tp_attribute2 :=
4336: p_delivery_detail_rec.tp_attribute2;
4337: END IF;
4334: OR p_delivery_detail_rec.tp_attribute2 IS NULL THEN
4335: x_delivery_detail_rec.tp_attribute2 :=
4336: p_delivery_detail_rec.tp_attribute2;
4337: END IF;
4338: IF p_delivery_detail_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
4339: OR p_delivery_detail_rec.tp_attribute3 IS NULL THEN
4340: x_delivery_detail_rec.tp_attribute3 :=
4341: p_delivery_detail_rec.tp_attribute3;
4342: END IF;
4339: OR p_delivery_detail_rec.tp_attribute3 IS NULL THEN
4340: x_delivery_detail_rec.tp_attribute3 :=
4341: p_delivery_detail_rec.tp_attribute3;
4342: END IF;
4343: IF p_delivery_detail_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
4344: OR p_delivery_detail_rec.tp_attribute4 IS NULL THEN
4345: x_delivery_detail_rec.tp_attribute4 :=
4346: p_delivery_detail_rec.tp_attribute4;
4347: END IF;
4344: OR p_delivery_detail_rec.tp_attribute4 IS NULL THEN
4345: x_delivery_detail_rec.tp_attribute4 :=
4346: p_delivery_detail_rec.tp_attribute4;
4347: END IF;
4348: IF p_delivery_detail_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
4349: OR p_delivery_detail_rec.tp_attribute5 IS NULL THEN
4350: x_delivery_detail_rec.tp_attribute5 :=
4351: p_delivery_detail_rec.tp_attribute5;
4352: END IF;
4349: OR p_delivery_detail_rec.tp_attribute5 IS NULL THEN
4350: x_delivery_detail_rec.tp_attribute5 :=
4351: p_delivery_detail_rec.tp_attribute5;
4352: END IF;
4353: IF p_delivery_detail_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
4354: OR p_delivery_detail_rec.tp_attribute6 IS NULL THEN
4355: x_delivery_detail_rec.tp_attribute6 :=
4356: p_delivery_detail_rec.tp_attribute6;
4357: END IF;
4354: OR p_delivery_detail_rec.tp_attribute6 IS NULL THEN
4355: x_delivery_detail_rec.tp_attribute6 :=
4356: p_delivery_detail_rec.tp_attribute6;
4357: END IF;
4358: IF p_delivery_detail_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
4359: OR p_delivery_detail_rec.tp_attribute7 IS NULL THEN
4360: x_delivery_detail_rec.tp_attribute7 :=
4361: p_delivery_detail_rec.tp_attribute7;
4362: END IF;
4359: OR p_delivery_detail_rec.tp_attribute7 IS NULL THEN
4360: x_delivery_detail_rec.tp_attribute7 :=
4361: p_delivery_detail_rec.tp_attribute7;
4362: END IF;
4363: IF p_delivery_detail_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
4364: OR p_delivery_detail_rec.tp_attribute8 IS NULL THEN
4365: x_delivery_detail_rec.tp_attribute8 :=
4366: p_delivery_detail_rec.tp_attribute8;
4367: END IF;
4364: OR p_delivery_detail_rec.tp_attribute8 IS NULL THEN
4365: x_delivery_detail_rec.tp_attribute8 :=
4366: p_delivery_detail_rec.tp_attribute8;
4367: END IF;
4368: IF p_delivery_detail_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
4369: OR p_delivery_detail_rec.tp_attribute9 IS NULL THEN
4370: x_delivery_detail_rec.tp_attribute9 :=
4371: p_delivery_detail_rec.tp_attribute9;
4372: END IF;
4369: OR p_delivery_detail_rec.tp_attribute9 IS NULL THEN
4370: x_delivery_detail_rec.tp_attribute9 :=
4371: p_delivery_detail_rec.tp_attribute9;
4372: END IF;
4373: IF p_delivery_detail_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
4374: OR p_delivery_detail_rec.tp_attribute10 IS NULL THEN
4375: x_delivery_detail_rec.tp_attribute10 :=
4376: p_delivery_detail_rec.tp_attribute10;
4377: END IF;
4374: OR p_delivery_detail_rec.tp_attribute10 IS NULL THEN
4375: x_delivery_detail_rec.tp_attribute10 :=
4376: p_delivery_detail_rec.tp_attribute10;
4377: END IF;
4378: IF p_delivery_detail_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
4379: OR p_delivery_detail_rec.tp_attribute11 IS NULL THEN
4380: x_delivery_detail_rec.tp_attribute11 :=
4381: p_delivery_detail_rec.tp_attribute11;
4382: END IF;
4379: OR p_delivery_detail_rec.tp_attribute11 IS NULL THEN
4380: x_delivery_detail_rec.tp_attribute11 :=
4381: p_delivery_detail_rec.tp_attribute11;
4382: END IF;
4383: IF p_delivery_detail_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
4384: OR p_delivery_detail_rec.tp_attribute12 IS NULL THEN
4385: x_delivery_detail_rec.tp_attribute12 :=
4386: p_delivery_detail_rec.tp_attribute12;
4387: END IF;
4384: OR p_delivery_detail_rec.tp_attribute12 IS NULL THEN
4385: x_delivery_detail_rec.tp_attribute12 :=
4386: p_delivery_detail_rec.tp_attribute12;
4387: END IF;
4388: IF p_delivery_detail_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
4389: OR p_delivery_detail_rec.tp_attribute13 IS NULL THEN
4390: x_delivery_detail_rec.tp_attribute13 :=
4391: p_delivery_detail_rec.tp_attribute13;
4392: END IF;
4389: OR p_delivery_detail_rec.tp_attribute13 IS NULL THEN
4390: x_delivery_detail_rec.tp_attribute13 :=
4391: p_delivery_detail_rec.tp_attribute13;
4392: END IF;
4393: IF p_delivery_detail_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
4394: OR p_delivery_detail_rec.tp_attribute14 IS NULL THEN
4395: x_delivery_detail_rec.tp_attribute14 :=
4396: p_delivery_detail_rec.tp_attribute14;
4397: END IF;
4394: OR p_delivery_detail_rec.tp_attribute14 IS NULL THEN
4395: x_delivery_detail_rec.tp_attribute14 :=
4396: p_delivery_detail_rec.tp_attribute14;
4397: END IF;
4398: IF p_delivery_detail_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
4399: OR p_delivery_detail_rec.tp_attribute15 IS NULL THEN
4400: x_delivery_detail_rec.tp_attribute15 :=
4401: p_delivery_detail_rec.tp_attribute15;
4402: END IF;
4399: OR p_delivery_detail_rec.tp_attribute15 IS NULL THEN
4400: x_delivery_detail_rec.tp_attribute15 :=
4401: p_delivery_detail_rec.tp_attribute15;
4402: END IF;
4403: IF p_delivery_detail_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
4404: OR p_delivery_detail_rec.tp_attribute_category IS NULL THEN
4405: x_delivery_detail_rec.tp_attribute_category :=
4406: p_delivery_detail_rec.tp_attribute_category;
4407: END IF;
4404: OR p_delivery_detail_rec.tp_attribute_category IS NULL THEN
4405: x_delivery_detail_rec.tp_attribute_category :=
4406: p_delivery_detail_rec.tp_attribute_category;
4407: END IF;
4408: IF p_delivery_detail_rec.attribute1 <> FND_API.G_MISS_CHAR
4409: OR p_delivery_detail_rec.attribute1 IS NULL THEN
4410:
4411: x_delivery_detail_rec.attribute1 :=
4412: p_delivery_detail_rec.attribute1;
4410:
4411: x_delivery_detail_rec.attribute1 :=
4412: p_delivery_detail_rec.attribute1;
4413: END IF;
4414: IF p_delivery_detail_rec.attribute2 <> FND_API.G_MISS_CHAR
4415: OR p_delivery_detail_rec.attribute2 IS NULL THEN
4416: x_delivery_detail_rec.attribute2 :=
4417: p_delivery_detail_rec.attribute2;
4418: END IF;
4415: OR p_delivery_detail_rec.attribute2 IS NULL THEN
4416: x_delivery_detail_rec.attribute2 :=
4417: p_delivery_detail_rec.attribute2;
4418: END IF;
4419: IF p_delivery_detail_rec.attribute3 <> FND_API.G_MISS_CHAR
4420: OR p_delivery_detail_rec.attribute3 IS NULL THEN
4421: x_delivery_detail_rec.attribute3 :=
4422: p_delivery_detail_rec.attribute3;
4423: END IF;
4420: OR p_delivery_detail_rec.attribute3 IS NULL THEN
4421: x_delivery_detail_rec.attribute3 :=
4422: p_delivery_detail_rec.attribute3;
4423: END IF;
4424: IF p_delivery_detail_rec.attribute4 <> FND_API.G_MISS_CHAR
4425: OR p_delivery_detail_rec.attribute4 IS NULL THEN
4426: x_delivery_detail_rec.attribute4 :=
4427: p_delivery_detail_rec.attribute4;
4428: END IF;
4425: OR p_delivery_detail_rec.attribute4 IS NULL THEN
4426: x_delivery_detail_rec.attribute4 :=
4427: p_delivery_detail_rec.attribute4;
4428: END IF;
4429: IF p_delivery_detail_rec.attribute5 <> FND_API.G_MISS_CHAR
4430: OR p_delivery_detail_rec.attribute5 IS NULL THEN
4431: x_delivery_detail_rec.attribute5 :=
4432: p_delivery_detail_rec.attribute5;
4433: END IF;
4430: OR p_delivery_detail_rec.attribute5 IS NULL THEN
4431: x_delivery_detail_rec.attribute5 :=
4432: p_delivery_detail_rec.attribute5;
4433: END IF;
4434: IF p_delivery_detail_rec.attribute6 <> FND_API.G_MISS_CHAR
4435: OR p_delivery_detail_rec.attribute6 IS NULL THEN
4436: x_delivery_detail_rec.attribute6 :=
4437: p_delivery_detail_rec.attribute6;
4438: END IF;
4435: OR p_delivery_detail_rec.attribute6 IS NULL THEN
4436: x_delivery_detail_rec.attribute6 :=
4437: p_delivery_detail_rec.attribute6;
4438: END IF;
4439: IF p_delivery_detail_rec.attribute7 <> FND_API.G_MISS_CHAR
4440: OR p_delivery_detail_rec.attribute7 IS NULL THEN
4441: x_delivery_detail_rec.attribute7 :=
4442: p_delivery_detail_rec.attribute7;
4443: END IF;
4440: OR p_delivery_detail_rec.attribute7 IS NULL THEN
4441: x_delivery_detail_rec.attribute7 :=
4442: p_delivery_detail_rec.attribute7;
4443: END IF;
4444: IF p_delivery_detail_rec.attribute8 <> FND_API.G_MISS_CHAR
4445: OR p_delivery_detail_rec.attribute8 IS NULL THEN
4446: x_delivery_detail_rec.attribute8 :=
4447: p_delivery_detail_rec.attribute8;
4448: END IF;
4445: OR p_delivery_detail_rec.attribute8 IS NULL THEN
4446: x_delivery_detail_rec.attribute8 :=
4447: p_delivery_detail_rec.attribute8;
4448: END IF;
4449: IF p_delivery_detail_rec.attribute9 <> FND_API.G_MISS_CHAR
4450: OR p_delivery_detail_rec.attribute9 IS NULL THEN
4451: x_delivery_detail_rec.attribute9 :=
4452: p_delivery_detail_rec.attribute9;
4453: END IF;
4450: OR p_delivery_detail_rec.attribute9 IS NULL THEN
4451: x_delivery_detail_rec.attribute9 :=
4452: p_delivery_detail_rec.attribute9;
4453: END IF;
4454: IF p_delivery_detail_rec.attribute10 <> FND_API.G_MISS_CHAR
4455: OR p_delivery_detail_rec.attribute10 IS NULL THEN
4456: x_delivery_detail_rec.attribute10 :=
4457: p_delivery_detail_rec.attribute10;
4458: END IF;
4455: OR p_delivery_detail_rec.attribute10 IS NULL THEN
4456: x_delivery_detail_rec.attribute10 :=
4457: p_delivery_detail_rec.attribute10;
4458: END IF;
4459: IF p_delivery_detail_rec.attribute11 <> FND_API.G_MISS_CHAR
4460: OR p_delivery_detail_rec.attribute11 IS NULL THEN
4461: x_delivery_detail_rec.attribute11 :=
4462: p_delivery_detail_rec.attribute11;
4463: END IF;
4460: OR p_delivery_detail_rec.attribute11 IS NULL THEN
4461: x_delivery_detail_rec.attribute11 :=
4462: p_delivery_detail_rec.attribute11;
4463: END IF;
4464: IF p_delivery_detail_rec.attribute12 <> FND_API.G_MISS_CHAR
4465: OR p_delivery_detail_rec.attribute12 IS NULL THEN
4466: x_delivery_detail_rec.attribute12 :=
4467: p_delivery_detail_rec.attribute12;
4468: END IF;
4465: OR p_delivery_detail_rec.attribute12 IS NULL THEN
4466: x_delivery_detail_rec.attribute12 :=
4467: p_delivery_detail_rec.attribute12;
4468: END IF;
4469: IF p_delivery_detail_rec.attribute13 <> FND_API.G_MISS_CHAR
4470: OR p_delivery_detail_rec.attribute13 IS NULL THEN
4471: x_delivery_detail_rec.attribute13 :=
4472: p_delivery_detail_rec.attribute13;
4473: END IF;
4470: OR p_delivery_detail_rec.attribute13 IS NULL THEN
4471: x_delivery_detail_rec.attribute13 :=
4472: p_delivery_detail_rec.attribute13;
4473: END IF;
4474: IF p_delivery_detail_rec.attribute14 <> FND_API.G_MISS_CHAR
4475: OR p_delivery_detail_rec.attribute14 IS NULL THEN
4476: x_delivery_detail_rec.attribute14 :=
4477: p_delivery_detail_rec.attribute14;
4478: END IF;
4475: OR p_delivery_detail_rec.attribute14 IS NULL THEN
4476: x_delivery_detail_rec.attribute14 :=
4477: p_delivery_detail_rec.attribute14;
4478: END IF;
4479: IF p_delivery_detail_rec.attribute15 <> FND_API.G_MISS_CHAR
4480: OR p_delivery_detail_rec.attribute15 IS NULL THEN
4481: x_delivery_detail_rec.attribute15 :=
4482: p_delivery_detail_rec.attribute15;
4483: END IF;
4480: OR p_delivery_detail_rec.attribute15 IS NULL THEN
4481: x_delivery_detail_rec.attribute15 :=
4482: p_delivery_detail_rec.attribute15;
4483: END IF;
4484: IF p_delivery_detail_rec.attribute_category <> FND_API.G_MISS_CHAR
4485: OR p_delivery_detail_rec.attribute_category IS NULL THEN
4486: x_delivery_detail_rec.attribute_category :=
4487: p_delivery_detail_rec.attribute_category;
4488: END IF;
4487: p_delivery_detail_rec.attribute_category;
4488: END IF;
4489:
4490: -- Need to enable 'Tracking Number'. This is not a permanently disabled field
4491: IF p_delivery_detail_rec.tracking_number <> FND_API.G_MISS_CHAR
4492: OR p_delivery_detail_rec.tracking_number IS NULL THEN
4493: x_delivery_detail_rec.tracking_number :=
4494: p_delivery_detail_rec.tracking_number;
4495: END IF;
4494: p_delivery_detail_rec.tracking_number;
4495: END IF;
4496:
4497: -- J: W/V Changes
4498: IF p_delivery_detail_rec.filled_volume <> FND_API.G_MISS_NUM
4499: OR p_delivery_detail_rec.filled_volume IS NULL THEN
4500: x_delivery_detail_rec.filled_volume :=
4501: p_delivery_detail_rec.filled_volume;
4502: END IF;
4501: p_delivery_detail_rec.filled_volume;
4502: END IF;
4503:
4504: IF p_in_rec.caller='WSH_TP_RELEASE' THEN
4505: IF p_delivery_detail_rec.tp_delivery_detail_id <> FND_API.G_MISS_NUM
4506: OR p_delivery_detail_rec.tp_delivery_detail_id IS NULL THEN
4507: x_delivery_detail_rec.tp_delivery_detail_id :=
4508: p_delivery_detail_rec.tp_delivery_detail_id;
4509: END IF;
4707: --
4708: FOR i IN 2..p_disabled_list.COUNT
4709: LOOP
4710: IF p_disabled_list(i) = 'CONTAINER_NAME' THEN
4711: IF p_in_rec.CONTAINER_NAME <> FND_API.G_MISS_CHAR
4712: OR p_in_rec.CONTAINER_NAME IS NULL THEN
4713: x_out_rec.container_name := p_in_rec.container_name ;
4714: END IF;
4715: ELSIF p_disabled_list(i) = 'CYCLE_COUNT_QUANTITY' THEN
4712: OR p_in_rec.CONTAINER_NAME IS NULL THEN
4713: x_out_rec.container_name := p_in_rec.container_name ;
4714: END IF;
4715: ELSIF p_disabled_list(i) = 'CYCLE_COUNT_QUANTITY' THEN
4716: IF p_in_rec.cycle_count_quantity <> FND_API.G_MISS_NUM
4717: OR p_in_rec.cycle_count_quantity IS NULL THEN
4718: x_out_rec.cycle_count_quantity := p_in_rec.cycle_count_quantity ;
4719: END IF;
4720: ELSIF p_disabled_list(i) = 'INSPECTION_FLAG' THEN
4717: OR p_in_rec.cycle_count_quantity IS NULL THEN
4718: x_out_rec.cycle_count_quantity := p_in_rec.cycle_count_quantity ;
4719: END IF;
4720: ELSIF p_disabled_list(i) = 'INSPECTION_FLAG' THEN
4721: IF p_in_rec.INSPECTION_FLAG <> FND_API.G_MISS_CHAR
4722: OR p_in_rec.INSPECTION_FLAG IS NULL THEN
4723: x_out_rec.INSPECTION_FLAG := p_in_rec.INSPECTION_FLAG ;
4724: END IF;
4725: ELSIF p_disabled_list(i) = 'CYCLE_COUNT_QUANTITY2' THEN
4722: OR p_in_rec.INSPECTION_FLAG IS NULL THEN
4723: x_out_rec.INSPECTION_FLAG := p_in_rec.INSPECTION_FLAG ;
4724: END IF;
4725: ELSIF p_disabled_list(i) = 'CYCLE_COUNT_QUANTITY2' THEN
4726: IF p_in_rec.cycle_count_quantity2 <> FND_API.G_MISS_NUM
4727: OR p_in_rec.cycle_count_quantity2 IS NULL THEN
4728: x_out_rec.cycle_count_quantity2 := p_in_rec.cycle_count_quantity2 ;
4729: END IF;
4730: ELSIF p_disabled_list(i) = 'CANCELLED_QUANTITY2' THEN
4727: OR p_in_rec.cycle_count_quantity2 IS NULL THEN
4728: x_out_rec.cycle_count_quantity2 := p_in_rec.cycle_count_quantity2 ;
4729: END IF;
4730: ELSIF p_disabled_list(i) = 'CANCELLED_QUANTITY2' THEN
4731: IF p_in_rec.cancelled_quantity2 <> FND_API.G_MISS_NUM
4732: OR p_in_rec.cancelled_quantity2 IS NULL THEN
4733: x_out_rec.cancelled_quantity2 := p_in_rec.cancelled_quantity2 ;
4734: END IF;
4735: ELSIF p_disabled_list(i) = 'CANCELLED_QUANTITY' THEN
4732: OR p_in_rec.cancelled_quantity2 IS NULL THEN
4733: x_out_rec.cancelled_quantity2 := p_in_rec.cancelled_quantity2 ;
4734: END IF;
4735: ELSIF p_disabled_list(i) = 'CANCELLED_QUANTITY' THEN
4736: IF p_in_rec.cancelled_quantity <> FND_API.G_MISS_NUM
4737: OR p_in_rec.cancelled_quantity IS NULL THEN
4738: x_out_rec.cancelled_quantity := p_in_rec.cancelled_quantity ;
4739: END IF;
4740: ELSIF p_disabled_list(i) = 'DELIVERED_QUANTITY2' THEN
4737: OR p_in_rec.cancelled_quantity IS NULL THEN
4738: x_out_rec.cancelled_quantity := p_in_rec.cancelled_quantity ;
4739: END IF;
4740: ELSIF p_disabled_list(i) = 'DELIVERED_QUANTITY2' THEN
4741: IF p_in_rec.delivered_quantity2 <> FND_API.G_MISS_NUM
4742: OR p_in_rec.delivered_quantity2 IS NULL THEN
4743: x_out_rec.delivered_quantity2 := p_in_rec.delivered_quantity2 ;
4744: END IF;
4745: ELSIF p_disabled_list(i) = 'DELIVERED_QUANTITY' THEN
4742: OR p_in_rec.delivered_quantity2 IS NULL THEN
4743: x_out_rec.delivered_quantity2 := p_in_rec.delivered_quantity2 ;
4744: END IF;
4745: ELSIF p_disabled_list(i) = 'DELIVERED_QUANTITY' THEN
4746: IF p_in_rec.delivered_quantity <> FND_API.G_MISS_NUM
4747: OR p_in_rec.delivered_quantity IS NULL THEN
4748: x_out_rec.delivered_quantity := p_in_rec.delivered_quantity ;
4749: END IF;
4750: ELSIF p_disabled_list(i) = 'DETAIL_CONTAINER_ITEM_NAME' THEN
4747: OR p_in_rec.delivered_quantity IS NULL THEN
4748: x_out_rec.delivered_quantity := p_in_rec.delivered_quantity ;
4749: END IF;
4750: ELSIF p_disabled_list(i) = 'DETAIL_CONTAINER_ITEM_NAME' THEN
4751: IF p_in_rec.detail_container_item_id <> FND_API.G_MISS_NUM
4752: OR p_in_rec.detail_container_item_id IS NULL THEN
4753: x_out_rec.detail_container_item_id := p_in_rec.detail_container_item_id ;
4754: END IF;
4755: -- for X-dock
4753: x_out_rec.detail_container_item_id := p_in_rec.detail_container_item_id ;
4754: END IF;
4755: -- for X-dock
4756: ELSIF p_disabled_list(i) = 'RELEASED_STATUS' THEN
4757: IF p_in_rec.released_status <> FND_API.G_MISS_CHAR
4758: OR p_in_rec.released_status IS NULL THEN
4759: x_out_rec.released_status := p_in_rec.released_status;
4760: END IF;
4761: ELSIF p_disabled_list(i) = 'MOVE_ORDER_LINE_ID' THEN
4758: OR p_in_rec.released_status IS NULL THEN
4759: x_out_rec.released_status := p_in_rec.released_status;
4760: END IF;
4761: ELSIF p_disabled_list(i) = 'MOVE_ORDER_LINE_ID' THEN
4762: IF p_in_rec.move_order_line_id <> FND_API.G_MISS_NUM
4763: OR p_in_rec.move_order_line_id IS NULL THEN
4764: x_out_rec.move_order_line_id := p_in_rec.move_order_line_id;
4765: END IF;
4766: --bug# 6689448 (replenishment project)
4764: x_out_rec.move_order_line_id := p_in_rec.move_order_line_id;
4765: END IF;
4766: --bug# 6689448 (replenishment project)
4767: ELSIF p_disabled_list(i) = 'REPLENISHMENT_STATUS' THEN
4768: IF p_in_rec.REPLENISHMENT_STATUS <> FND_API.G_MISS_CHAR
4769: OR p_in_rec. REPLENISHMENT_STATUS IS NULL THEN
4770: x_out_rec.REPLENISHMENT_STATUS:= p_in_rec.REPLENISHMENT_STATUS;
4771: END IF;
4772: ELSIF p_disabled_list(i) = 'BATCH_ID' THEN
4769: OR p_in_rec. REPLENISHMENT_STATUS IS NULL THEN
4770: x_out_rec.REPLENISHMENT_STATUS:= p_in_rec.REPLENISHMENT_STATUS;
4771: END IF;
4772: ELSIF p_disabled_list(i) = 'BATCH_ID' THEN
4773: IF p_in_rec.batch_id <> FND_API.G_MISS_NUM
4774: OR p_in_rec.batch_id IS NULL THEN
4775: x_out_rec.batch_id := p_in_rec.batch_id;
4776: END IF;
4777: -- end of X-dock changes
4775: x_out_rec.batch_id := p_in_rec.batch_id;
4776: END IF;
4777: -- end of X-dock changes
4778: ELSIF p_disabled_list(i) = 'GROSS_WEIGHT' THEN
4779: IF p_in_rec.gross_weight <> FND_API.G_MISS_NUM
4780: OR p_in_rec.gross_weight IS NULL THEN
4781: x_out_rec.gross_weight := p_in_rec.gross_weight ;
4782: END IF;
4783: ELSIF p_disabled_list(i) = 'TARE_WEIGHT' THEN
4783: ELSIF p_disabled_list(i) = 'TARE_WEIGHT' THEN
4784: null;
4785: -- J-IB-NPARIKH-{ --I-bug-fix
4786: ELSIF p_disabled_list(i) = 'NET_WEIGHT' THEN
4787: IF p_in_rec.net_weight <> FND_API.G_MISS_NUM
4788: OR p_in_rec.net_weight IS NULL THEN
4789: x_out_rec.net_weight := p_in_rec.net_weight ;
4790: END IF;
4791: ELSIF p_disabled_list(i) = 'VOLUME' THEN
4788: OR p_in_rec.net_weight IS NULL THEN
4789: x_out_rec.net_weight := p_in_rec.net_weight ;
4790: END IF;
4791: ELSIF p_disabled_list(i) = 'VOLUME' THEN
4792: IF p_in_rec.VOLUME <> FND_API.G_MISS_NUM
4793: OR p_in_rec.VOLUME IS NULL THEN
4794: x_out_rec.VOLUME := p_in_rec.VOLUME ;
4795: END IF;
4796: -- J-IB-NPARIKH-}
4795: END IF;
4796: -- J-IB-NPARIKH-}
4797: -- bug 5077108
4798: ELSIF p_disabled_list(i) = 'INVENTORY_ITEM_ID' THEN
4799: IF p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM
4800: OR p_in_rec.inventory_item_id IS NULL THEN
4801: x_out_rec.inventory_item_id := p_in_rec.inventory_item_id ;
4802: END IF;
4803: -- end bug 5077108
4803: -- end bug 5077108
4804:
4805: --Bug 5212632 Start
4806: ELSIF p_disabled_list(i) = 'CONTAINER_TYPE_CODE' THEN
4807: IF p_in_rec.container_type_code <> FND_API.G_MISS_CHAR
4808: OR p_in_rec.container_type_code IS NULL THEN
4809:
4810: x_out_rec.container_type_code := p_in_rec.container_type_code;
4811: ELSIF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
4807: IF p_in_rec.container_type_code <> FND_API.G_MISS_CHAR
4808: OR p_in_rec.container_type_code IS NULL THEN
4809:
4810: x_out_rec.container_type_code := p_in_rec.container_type_code;
4811: ELSIF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
4812: IF l_cursor_opened_flag = 1 THEN
4813: x_out_rec.container_type_code:=l_container_type_code;
4814: ELSE
4815: OPEN get_MSI_details (p_in_rec.inventory_item_id,p_in_rec.delivery_detail_id);
4824: --Bug 5212632 End
4825: --Bug 7165744
4826: --requested_quantity_uom can be updated for WMS LPNs.
4827: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM' THEN
4828: IF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
4829: IF l_cursor_opened_flag = 1 THEN
4830: x_out_rec.requested_quantity_uom:=l_requested_quantity_uom;
4831: ELSE
4832: OPEN get_MSI_details (p_in_rec.inventory_item_id,p_in_rec.delivery_detail_id);
4840: END IF;
4841: -- end Bug 7165744
4842: --Added the following code as part of fix for bug 6082324
4843: ELSIF p_disabled_list(i) = 'MAXIMUM_LOAD_WEIGHT' THEN
4844: IF p_in_rec.MAXIMUM_LOAD_WEIGHT <> FND_API.G_MISS_NUM
4845: OR p_in_rec.MAXIMUM_LOAD_WEIGHT IS NULL THEN
4846: x_out_rec.MAXIMUM_LOAD_WEIGHT := p_in_rec.MAXIMUM_LOAD_WEIGHT;
4847: ELSIF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
4848: IF l_cursor_opened_flag = 1 THEN
4843: ELSIF p_disabled_list(i) = 'MAXIMUM_LOAD_WEIGHT' THEN
4844: IF p_in_rec.MAXIMUM_LOAD_WEIGHT <> FND_API.G_MISS_NUM
4845: OR p_in_rec.MAXIMUM_LOAD_WEIGHT IS NULL THEN
4846: x_out_rec.MAXIMUM_LOAD_WEIGHT := p_in_rec.MAXIMUM_LOAD_WEIGHT;
4847: ELSIF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
4848: IF l_cursor_opened_flag = 1 THEN
4849: x_out_rec.MAXIMUM_LOAD_WEIGHT:=l_maximum_load_weight;
4850: ELSE
4851: OPEN get_MSI_details (p_in_rec.inventory_item_id,p_in_rec.delivery_detail_id);
4860: --End of fix for bug # 6082324
4861:
4862:
4863: ELSIF p_disabled_list(i) = 'LOCATOR_NAME' THEN
4864: IF p_in_rec.locator_id <> FND_API.G_MISS_NUM
4865: OR p_in_rec.locator_id IS NULL THEN
4866: x_out_rec.locator_id := p_in_rec.locator_id ;
4867: END IF;
4868: ELSIF p_disabled_list(i) = 'LOAD_SEQ_NUMBER' THEN
4865: OR p_in_rec.locator_id IS NULL THEN
4866: x_out_rec.locator_id := p_in_rec.locator_id ;
4867: END IF;
4868: ELSIF p_disabled_list(i) = 'LOAD_SEQ_NUMBER' THEN
4869: IF p_in_rec.load_seq_number <> FND_API.G_MISS_NUM
4870: OR p_in_rec.load_seq_number IS NULL THEN
4871: x_out_rec.load_seq_number := p_in_rec.load_seq_number ;
4872: END IF;
4873: ELSIF p_disabled_list(i) = 'LPN_ID' THEN
4870: OR p_in_rec.load_seq_number IS NULL THEN
4871: x_out_rec.load_seq_number := p_in_rec.load_seq_number ;
4872: END IF;
4873: ELSIF p_disabled_list(i) = 'LPN_ID' THEN
4874: IF p_in_rec.lpn_id <> FND_API.G_MISS_NUM
4875: OR p_in_rec.lpn_id IS NULL THEN
4876: x_out_rec.lpn_id := p_in_rec.lpn_id ;
4877: END IF;
4878: ELSIF p_disabled_list(i) = 'MASTER_CONTAINER_ITEM_NAME' THEN
4875: OR p_in_rec.lpn_id IS NULL THEN
4876: x_out_rec.lpn_id := p_in_rec.lpn_id ;
4877: END IF;
4878: ELSIF p_disabled_list(i) = 'MASTER_CONTAINER_ITEM_NAME' THEN
4879: IF p_in_rec.master_container_item_id <> FND_API.G_MISS_NUM
4880: OR p_in_rec.master_container_item_id IS NULL THEN
4881: x_out_rec.master_container_item_id := p_in_rec.master_container_item_id ;
4882: END IF;
4883: ELSIF p_disabled_list(i) = 'PACKING_INSTRUCTIONS' THEN
4880: OR p_in_rec.master_container_item_id IS NULL THEN
4881: x_out_rec.master_container_item_id := p_in_rec.master_container_item_id ;
4882: END IF;
4883: ELSIF p_disabled_list(i) = 'PACKING_INSTRUCTIONS' THEN
4884: IF p_in_rec.PACKING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
4885: OR p_in_rec.PACKING_INSTRUCTIONS IS NULL THEN
4886: x_out_rec.PACKING_INSTRUCTIONS := p_in_rec.PACKING_INSTRUCTIONS ;
4887: END IF;
4888: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY2' THEN
4885: OR p_in_rec.PACKING_INSTRUCTIONS IS NULL THEN
4886: x_out_rec.PACKING_INSTRUCTIONS := p_in_rec.PACKING_INSTRUCTIONS ;
4887: END IF;
4888: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY2' THEN
4889: IF p_in_rec.PICKED_QUANTITY2 <> FND_API.G_MISS_NUM
4890: OR p_in_rec.PICKED_QUANTITY2 IS NULL THEN
4891: x_out_rec.picked_quantity2 := p_in_rec.picked_quantity2 ;
4892: END IF;
4893: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM2' THEN
4890: OR p_in_rec.PICKED_QUANTITY2 IS NULL THEN
4891: x_out_rec.picked_quantity2 := p_in_rec.picked_quantity2 ;
4892: END IF;
4893: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM2' THEN
4894: IF p_in_rec.REQUESTED_QUANTITY_UOM2 <> FND_API.G_MISS_CHAR
4895: OR p_in_rec.REQUESTED_QUANTITY_UOM2 IS NULL THEN
4896: x_out_rec.REQUESTED_QUANTITY_UOM2 := p_in_rec.REQUESTED_QUANTITY_UOM2 ;
4897: END IF;
4898:
4897: END IF;
4898:
4899: -- bmso
4900: ELSIF p_disabled_list(i) = 'PREFERED_GRADE' THEN
4901: IF p_in_rec.PREFERRED_GRADE <> FND_API.G_MISS_CHAR
4902: OR p_in_rec.PREFERRED_GRADE IS NULL THEN
4903: x_out_rec.PREFERRED_GRADE := p_in_rec.PREFERRED_GRADE ;
4904: END IF;
4905: ELSIF p_disabled_list(i) = 'SRC_REQUESTED_QUANTITY2' THEN
4902: OR p_in_rec.PREFERRED_GRADE IS NULL THEN
4903: x_out_rec.PREFERRED_GRADE := p_in_rec.PREFERRED_GRADE ;
4904: END IF;
4905: ELSIF p_disabled_list(i) = 'SRC_REQUESTED_QUANTITY2' THEN
4906: IF p_in_rec.SRC_REQUESTED_QUANTITY2 <> FND_API.G_MISS_NUM
4907: OR p_in_rec.SRC_REQUESTED_QUANTITY2 IS NULL THEN
4908: x_out_rec.SRC_REQUESTED_QUANTITY2 := p_in_rec.SRC_REQUESTED_QUANTITY2 ;
4909: END IF;
4910: ELSIF p_disabled_list(i) = 'SRC_REQUESTED_QUANTITY_UOM2' THEN
4907: OR p_in_rec.SRC_REQUESTED_QUANTITY2 IS NULL THEN
4908: x_out_rec.SRC_REQUESTED_QUANTITY2 := p_in_rec.SRC_REQUESTED_QUANTITY2 ;
4909: END IF;
4910: ELSIF p_disabled_list(i) = 'SRC_REQUESTED_QUANTITY_UOM2' THEN
4911: IF p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 <> FND_API.G_MISS_CHAR
4912: OR p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 IS NULL THEN
4913: x_out_rec.SRC_REQUESTED_QUANTITY_UOM2 := p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 ;
4914: END IF;
4915: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY2' THEN
4912: OR p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 IS NULL THEN
4913: x_out_rec.SRC_REQUESTED_QUANTITY_UOM2 := p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 ;
4914: END IF;
4915: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY2' THEN
4916: IF p_in_rec.REQUESTED_QUANTITY2 <> FND_API.G_MISS_NUM
4917: OR p_in_rec.REQUESTED_QUANTITY2 IS NULL THEN
4918: x_out_rec.REQUESTED_QUANTITY2 := p_in_rec.REQUESTED_QUANTITY2 ;
4919: END IF;
4920: ELSIF p_disabled_list(i) = 'QUALITY_CONTROL_QUANTITY2' THEN
4917: OR p_in_rec.REQUESTED_QUANTITY2 IS NULL THEN
4918: x_out_rec.REQUESTED_QUANTITY2 := p_in_rec.REQUESTED_QUANTITY2 ;
4919: END IF;
4920: ELSIF p_disabled_list(i) = 'QUALITY_CONTROL_QUANTITY2' THEN
4921: IF p_in_rec.QUALITY_CONTROL_QUANTITY2 <> FND_API.G_MISS_NUM
4922: OR p_in_rec.QUALITY_CONTROL_QUANTITY2 IS NULL THEN
4923: x_out_rec.QUALITY_CONTROL_QUANTITY2 := p_in_rec.QUALITY_CONTROL_QUANTITY2 ;
4924: END IF;
4925: ELSIF p_disabled_list(i) = 'SUBLOT_NUMBER' THEN
4923: x_out_rec.QUALITY_CONTROL_QUANTITY2 := p_in_rec.QUALITY_CONTROL_QUANTITY2 ;
4924: END IF;
4925: ELSIF p_disabled_list(i) = 'SUBLOT_NUMBER' THEN
4926: NULL;
4927: --IF p_in_rec.SUBLOT_NUMBER <> FND_API.G_MISS_CHAR
4928: --OR p_in_rec.SUBLOT_NUMBER IS NULL THEN
4929: --x_out_rec.SUBLOT_NUMBER := p_in_rec.SUBLOT_NUMBER ;
4930: --END IF;
4931: ELSIF p_disabled_list(i) = 'RETURNED_QUANTITY2' THEN
4928: --OR p_in_rec.SUBLOT_NUMBER IS NULL THEN
4929: --x_out_rec.SUBLOT_NUMBER := p_in_rec.SUBLOT_NUMBER ;
4930: --END IF;
4931: ELSIF p_disabled_list(i) = 'RETURNED_QUANTITY2' THEN
4932: IF p_in_rec.RETURNED_QUANTITY2 <> FND_API.G_MISS_NUM
4933: OR p_in_rec.RETURNED_QUANTITY2 IS NULL THEN
4934: x_out_rec.RETURNED_QUANTITY2 := p_in_rec.RETURNED_QUANTITY2 ;
4935: END IF;
4936: ELSIF p_disabled_list(i) = 'RECEIVED_QUANTITY2' THEN
4933: OR p_in_rec.RETURNED_QUANTITY2 IS NULL THEN
4934: x_out_rec.RETURNED_QUANTITY2 := p_in_rec.RETURNED_QUANTITY2 ;
4935: END IF;
4936: ELSIF p_disabled_list(i) = 'RECEIVED_QUANTITY2' THEN
4937: IF p_in_rec.RECEIVED_QUANTITY2 <> FND_API.G_MISS_NUM
4938: OR p_in_rec.RECEIVED_QUANTITY2 IS NULL THEN
4939: x_out_rec.RECEIVED_QUANTITY2 := p_in_rec.RECEIVED_QUANTITY2 ;
4940: END IF;
4941: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY2' THEN
4938: OR p_in_rec.RECEIVED_QUANTITY2 IS NULL THEN
4939: x_out_rec.RECEIVED_QUANTITY2 := p_in_rec.RECEIVED_QUANTITY2 ;
4940: END IF;
4941: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY2' THEN
4942: IF p_in_rec.PICKED_QUANTITY2 <> FND_API.G_MISS_NUM
4943: OR p_in_rec.PICKED_QUANTITY2 IS NULL THEN
4944: x_out_rec.PICKED_QUANTITY2 := p_in_rec.PICKED_QUANTITY2 ;
4945: END IF;
4946: ELSIF p_disabled_list(i) = 'TO_SERIAL_NUMBER' THEN
4943: OR p_in_rec.PICKED_QUANTITY2 IS NULL THEN
4944: x_out_rec.PICKED_QUANTITY2 := p_in_rec.PICKED_QUANTITY2 ;
4945: END IF;
4946: ELSIF p_disabled_list(i) = 'TO_SERIAL_NUMBER' THEN
4947: IF p_in_rec.TO_SERIAL_NUMBER <> FND_API.G_MISS_CHAR
4948: OR p_in_rec.TO_SERIAL_NUMBER IS NULL THEN
4949: x_out_rec.TO_SERIAL_NUMBER := p_in_rec.TO_SERIAL_NUMBER ;
4950: END IF;
4951: ELSIF p_disabled_list(i) = 'SERIAL_NUMBER' THEN
4948: OR p_in_rec.TO_SERIAL_NUMBER IS NULL THEN
4949: x_out_rec.TO_SERIAL_NUMBER := p_in_rec.TO_SERIAL_NUMBER ;
4950: END IF;
4951: ELSIF p_disabled_list(i) = 'SERIAL_NUMBER' THEN
4952: IF p_in_rec.SERIAL_NUMBER <> FND_API.G_MISS_CHAR
4953: OR p_in_rec.SERIAL_NUMBER IS NULL THEN
4954: x_out_rec.SERIAL_NUMBER := p_in_rec.SERIAL_NUMBER ;
4955: END IF;
4956: ELSIF p_disabled_list(i) = 'TRANSACTION_TEMP_ID' THEN
4953: OR p_in_rec.SERIAL_NUMBER IS NULL THEN
4954: x_out_rec.SERIAL_NUMBER := p_in_rec.SERIAL_NUMBER ;
4955: END IF;
4956: ELSIF p_disabled_list(i) = 'TRANSACTION_TEMP_ID' THEN
4957: IF p_in_rec.TRANSACTION_TEMP_ID <> FND_API.G_MISS_NUM
4958: OR p_in_rec.TRANSACTION_TEMP_ID IS NULL THEN
4959: x_out_rec.TRANSACTION_TEMP_ID := p_in_rec.TRANSACTION_TEMP_ID ;
4960: END IF;
4961: ELSIF p_disabled_list(i) = 'REVISION' THEN
4958: OR p_in_rec.TRANSACTION_TEMP_ID IS NULL THEN
4959: x_out_rec.TRANSACTION_TEMP_ID := p_in_rec.TRANSACTION_TEMP_ID ;
4960: END IF;
4961: ELSIF p_disabled_list(i) = 'REVISION' THEN
4962: IF p_in_rec.REVISION <> FND_API.G_MISS_CHAR
4963: OR p_in_rec.REVISION IS NULL THEN
4964: x_out_rec.REVISION := p_in_rec.REVISION ;
4965: END IF;
4966: ELSIF p_disabled_list(i) = 'LOT_NUMBER' THEN
4963: OR p_in_rec.REVISION IS NULL THEN
4964: x_out_rec.REVISION := p_in_rec.REVISION ;
4965: END IF;
4966: ELSIF p_disabled_list(i) = 'LOT_NUMBER' THEN
4967: IF p_in_rec.LOT_NUMBER <> FND_API.G_MISS_CHAR
4968: OR p_in_rec.LOT_NUMBER IS NULL THEN
4969: x_out_rec.LOT_NUMBER := p_in_rec.LOT_NUMBER ;
4970: END IF;
4971: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM' THEN
4968: OR p_in_rec.LOT_NUMBER IS NULL THEN
4969: x_out_rec.LOT_NUMBER := p_in_rec.LOT_NUMBER ;
4970: END IF;
4971: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM' THEN
4972: IF p_in_rec.REQUESTED_QUANTITY_UOM <> FND_API.G_MISS_CHAR
4973: OR p_in_rec.REQUESTED_QUANTITY_UOM IS NULL THEN
4974: x_out_rec.REQUESTED_QUANTITY_UOM := p_in_rec.REQUESTED_QUANTITY_UOM ;
4975: END IF;
4976: --
4974: x_out_rec.REQUESTED_QUANTITY_UOM := p_in_rec.REQUESTED_QUANTITY_UOM ;
4975: END IF;
4976: --
4977: ELSIF p_disabled_list(i) = 'SHIPPING_INSTRUCTIONS' THEN
4978: IF p_in_rec.shipping_instructions <> FND_API.G_MISS_CHAR
4979: OR p_in_rec.shipping_instructions IS NULL THEN
4980: x_out_rec.shipping_instructions := p_in_rec.shipping_instructions ;
4981: END IF;
4982: ELSIF p_disabled_list(i) = 'SHIPPED_QUANTITY' THEN
4979: OR p_in_rec.shipping_instructions IS NULL THEN
4980: x_out_rec.shipping_instructions := p_in_rec.shipping_instructions ;
4981: END IF;
4982: ELSIF p_disabled_list(i) = 'SHIPPED_QUANTITY' THEN
4983: IF p_in_rec.shipped_quantity <> FND_API.G_MISS_NUM
4984: OR p_in_rec.shipped_quantity IS NULL THEN
4985: x_out_rec.shipped_quantity := p_in_rec.shipped_quantity ;
4986: END IF;
4987: ELSIF p_disabled_list(i) = 'SEAL_CODE' THEN
4984: OR p_in_rec.shipped_quantity IS NULL THEN
4985: x_out_rec.shipped_quantity := p_in_rec.shipped_quantity ;
4986: END IF;
4987: ELSIF p_disabled_list(i) = 'SEAL_CODE' THEN
4988: IF p_in_rec.seal_code <> FND_API.G_MISS_CHAR
4989: OR p_in_rec.seal_code IS NULL THEN
4990: x_out_rec.seal_code := p_in_rec.seal_code ;
4991: END IF;
4992: ELSIF p_disabled_list(i) = 'SHIPPED_QUANTITY2' THEN
4989: OR p_in_rec.seal_code IS NULL THEN
4990: x_out_rec.seal_code := p_in_rec.seal_code ;
4991: END IF;
4992: ELSIF p_disabled_list(i) = 'SHIPPED_QUANTITY2' THEN
4993: IF p_in_rec.shipped_quantity2 <> FND_API.G_MISS_NUM
4994: OR p_in_rec.shipped_quantity2 IS NULL THEN
4995: x_out_rec.shipped_quantity2 := p_in_rec.shipped_quantity2 ;
4996: END IF;
4997: ELSIF p_disabled_list(i) = 'SUBINVENTORY' THEN
4994: OR p_in_rec.shipped_quantity2 IS NULL THEN
4995: x_out_rec.shipped_quantity2 := p_in_rec.shipped_quantity2 ;
4996: END IF;
4997: ELSIF p_disabled_list(i) = 'SUBINVENTORY' THEN
4998: IF p_in_rec.subinventory <> FND_API.G_MISS_CHAR
4999: OR p_in_rec.subinventory IS NULL THEN
5000: x_out_rec.subinventory := p_in_rec.subinventory ;
5001: END IF;
5002: --Bugfix 6939348 start
5000: x_out_rec.subinventory := p_in_rec.subinventory ;
5001: END IF;
5002: --Bugfix 6939348 start
5003: ELSIF p_disabled_list(i) = 'LOT_NUMBER' THEN
5004: IF p_in_rec.lot_number <> FND_API.G_MISS_CHAR
5005: OR p_in_rec.lot_number IS NULL THEN
5006: x_out_rec.lot_number := p_in_rec.lot_number;
5007: END IF;
5008: -- Bugfix 6939348 end
5006: x_out_rec.lot_number := p_in_rec.lot_number;
5007: END IF;
5008: -- Bugfix 6939348 end
5009: ELSIF p_disabled_list(i) = 'TRACKING_NUMBER' THEN
5010: IF p_in_rec.tracking_number <> FND_API.G_MISS_CHAR
5011: OR p_in_rec.tracking_number IS NULL THEN
5012: x_out_rec.tracking_number := p_in_rec.tracking_number ;
5013: END IF;
5014: ELSIF p_disabled_list(i) = 'SHIP_METHOD_CODE' THEN
5011: OR p_in_rec.tracking_number IS NULL THEN
5012: x_out_rec.tracking_number := p_in_rec.tracking_number ;
5013: END IF;
5014: ELSIF p_disabled_list(i) = 'SHIP_METHOD_CODE' THEN
5015: IF p_in_rec.ship_method_code <> FND_API.G_MISS_CHAR
5016: OR p_in_rec.ship_method_code IS NULL THEN
5017: x_out_rec.ship_method_code := p_in_rec.ship_method_code ;
5018: END IF;
5019: ELSIF p_disabled_list(i) = 'CARRIER_ID' THEN
5016: OR p_in_rec.ship_method_code IS NULL THEN
5017: x_out_rec.ship_method_code := p_in_rec.ship_method_code ;
5018: END IF;
5019: ELSIF p_disabled_list(i) = 'CARRIER_ID' THEN
5020: IF p_in_rec.carrier_id <> FND_API.G_MISS_NUM
5021: OR p_in_rec.carrier_id IS NULL THEN
5022: x_out_rec.carrier_id := p_in_rec.carrier_id ;
5023: END IF;
5024: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT' THEN
5021: OR p_in_rec.carrier_id IS NULL THEN
5022: x_out_rec.carrier_id := p_in_rec.carrier_id ;
5023: END IF;
5024: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT' THEN
5025: IF p_in_rec.ship_method_code <> FND_API.G_MISS_CHAR
5026: OR p_in_rec.mode_of_transport IS NULL THEN
5027: x_out_rec.mode_of_transport := p_in_rec.mode_of_transport ;
5028: END IF;
5029: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL' THEN
5026: OR p_in_rec.mode_of_transport IS NULL THEN
5027: x_out_rec.mode_of_transport := p_in_rec.mode_of_transport ;
5028: END IF;
5029: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL' THEN
5030: IF p_in_rec.service_level <> FND_API.G_MISS_CHAR
5031: OR p_in_rec.service_level IS NULL THEN
5032: x_out_rec.service_level := p_in_rec.service_level ;
5033: END IF;
5034: ELSIF p_disabled_list(i) = 'ITEM_NUMBER' THEN
5031: OR p_in_rec.service_level IS NULL THEN
5032: x_out_rec.service_level := p_in_rec.service_level ;
5033: END IF;
5034: ELSIF p_disabled_list(i) = 'ITEM_NUMBER' THEN
5035: IF nvl(p_in_rec.inventory_item_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
5036: THEN
5037: x_out_rec.inventory_item_id := p_in_rec.inventory_item_id ;
5038: END IF;
5039: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
5036: THEN
5037: x_out_rec.inventory_item_id := p_in_rec.inventory_item_id ;
5038: END IF;
5039: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
5040: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
5041: OR p_in_rec.attribute1 IS NULL THEN
5042: x_out_rec.attribute1 := p_in_rec.attribute1 ;
5043: END IF;
5044: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
5040: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
5041: OR p_in_rec.attribute1 IS NULL THEN
5042: x_out_rec.attribute1 := p_in_rec.attribute1 ;
5043: END IF;
5044: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
5045: OR p_in_rec.attribute2 IS NULL THEN
5046: x_out_rec.attribute2 := p_in_rec.attribute2 ;
5047: END IF;
5048: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
5044: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
5045: OR p_in_rec.attribute2 IS NULL THEN
5046: x_out_rec.attribute2 := p_in_rec.attribute2 ;
5047: END IF;
5048: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
5049: OR p_in_rec.attribute3 IS NULL THEN
5050: x_out_rec.attribute3 := p_in_rec.attribute3 ;
5051: END IF;
5052: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
5048: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
5049: OR p_in_rec.attribute3 IS NULL THEN
5050: x_out_rec.attribute3 := p_in_rec.attribute3 ;
5051: END IF;
5052: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
5053: OR p_in_rec.attribute4 IS NULL THEN
5054: x_out_rec.attribute4 := p_in_rec.attribute4 ;
5055: END IF;
5056: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
5052: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
5053: OR p_in_rec.attribute4 IS NULL THEN
5054: x_out_rec.attribute4 := p_in_rec.attribute4 ;
5055: END IF;
5056: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
5057: OR p_in_rec.attribute5 IS NULL THEN
5058: x_out_rec.attribute5 := p_in_rec.attribute5 ;
5059: END IF;
5060: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
5056: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
5057: OR p_in_rec.attribute5 IS NULL THEN
5058: x_out_rec.attribute5 := p_in_rec.attribute5 ;
5059: END IF;
5060: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
5061: OR p_in_rec.attribute6 IS NULL THEN
5062: x_out_rec.attribute6 := p_in_rec.attribute6 ;
5063: END IF;
5064: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
5060: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
5061: OR p_in_rec.attribute6 IS NULL THEN
5062: x_out_rec.attribute6 := p_in_rec.attribute6 ;
5063: END IF;
5064: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
5065: OR p_in_rec.attribute7 IS NULL THEN
5066: x_out_rec.attribute7 := p_in_rec.attribute7 ;
5067: END IF;
5068: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
5064: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
5065: OR p_in_rec.attribute7 IS NULL THEN
5066: x_out_rec.attribute7 := p_in_rec.attribute7 ;
5067: END IF;
5068: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
5069: OR p_in_rec.attribute8 IS NULL THEN
5070: x_out_rec.attribute8 := p_in_rec.attribute8 ;
5071: END IF;
5072: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
5068: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
5069: OR p_in_rec.attribute8 IS NULL THEN
5070: x_out_rec.attribute8 := p_in_rec.attribute8 ;
5071: END IF;
5072: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
5073: OR p_in_rec.attribute9 IS NULL THEN
5074: x_out_rec.attribute9 := p_in_rec.attribute9 ;
5075: END IF;
5076: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
5072: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
5073: OR p_in_rec.attribute9 IS NULL THEN
5074: x_out_rec.attribute9 := p_in_rec.attribute9 ;
5075: END IF;
5076: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
5077: OR p_in_rec.attribute10 IS NULL THEN
5078: x_out_rec.attribute10 := p_in_rec.attribute10 ;
5079: END IF;
5080: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
5076: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
5077: OR p_in_rec.attribute10 IS NULL THEN
5078: x_out_rec.attribute10 := p_in_rec.attribute10 ;
5079: END IF;
5080: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
5081: OR p_in_rec.attribute11 IS NULL THEN
5082: x_out_rec.attribute11 := p_in_rec.attribute11 ;
5083: END IF;
5084: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
5080: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
5081: OR p_in_rec.attribute11 IS NULL THEN
5082: x_out_rec.attribute11 := p_in_rec.attribute11 ;
5083: END IF;
5084: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
5085: OR p_in_rec.attribute12 IS NULL THEN
5086: x_out_rec.attribute12 := p_in_rec.attribute12 ;
5087: END IF;
5088: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
5084: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
5085: OR p_in_rec.attribute12 IS NULL THEN
5086: x_out_rec.attribute12 := p_in_rec.attribute12 ;
5087: END IF;
5088: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
5089: OR p_in_rec.attribute13 IS NULL THEN
5090: x_out_rec.attribute13 := p_in_rec.attribute13 ;
5091: END IF;
5092: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
5088: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
5089: OR p_in_rec.attribute13 IS NULL THEN
5090: x_out_rec.attribute13 := p_in_rec.attribute13 ;
5091: END IF;
5092: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
5093: OR p_in_rec.attribute14 IS NULL THEN
5094: x_out_rec.attribute14 := p_in_rec.attribute14 ;
5095: END IF;
5096: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
5092: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
5093: OR p_in_rec.attribute14 IS NULL THEN
5094: x_out_rec.attribute14 := p_in_rec.attribute14 ;
5095: END IF;
5096: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
5097: OR p_in_rec.attribute15 IS NULL THEN
5098: x_out_rec.attribute15 := p_in_rec.attribute15 ;
5099: END IF;
5100: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
5096: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
5097: OR p_in_rec.attribute15 IS NULL THEN
5098: x_out_rec.attribute15 := p_in_rec.attribute15 ;
5099: END IF;
5100: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
5101: OR p_in_rec.attribute_category IS NULL THEN
5102: x_out_rec.attribute_category := p_in_rec.attribute_category ;
5103: END IF;
5104: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
5101: OR p_in_rec.attribute_category IS NULL THEN
5102: x_out_rec.attribute_category := p_in_rec.attribute_category ;
5103: END IF;
5104: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
5105: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
5106: OR p_in_rec.tp_attribute1 IS NULL THEN
5107: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
5108: END IF;
5109: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
5105: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
5106: OR p_in_rec.tp_attribute1 IS NULL THEN
5107: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
5108: END IF;
5109: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
5110: OR p_in_rec.tp_attribute2 IS NULL THEN
5111: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
5112: END IF;
5113: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
5109: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
5110: OR p_in_rec.tp_attribute2 IS NULL THEN
5111: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
5112: END IF;
5113: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
5114: OR p_in_rec.tp_attribute3 IS NULL THEN
5115: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
5116: END IF;
5117: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
5113: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
5114: OR p_in_rec.tp_attribute3 IS NULL THEN
5115: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
5116: END IF;
5117: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
5118: OR p_in_rec.tp_attribute4 IS NULL THEN
5119: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
5120: END IF;
5121: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
5117: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
5118: OR p_in_rec.tp_attribute4 IS NULL THEN
5119: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
5120: END IF;
5121: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
5122: OR p_in_rec.tp_attribute5 IS NULL THEN
5123: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
5124: END IF;
5125: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
5121: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
5122: OR p_in_rec.tp_attribute5 IS NULL THEN
5123: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
5124: END IF;
5125: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
5126: OR p_in_rec.tp_attribute6 IS NULL THEN
5127: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
5128: END IF;
5129: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
5125: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
5126: OR p_in_rec.tp_attribute6 IS NULL THEN
5127: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
5128: END IF;
5129: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
5130: OR p_in_rec.tp_attribute7 IS NULL THEN
5131: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
5132: END IF;
5133: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
5129: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
5130: OR p_in_rec.tp_attribute7 IS NULL THEN
5131: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
5132: END IF;
5133: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
5134: OR p_in_rec.tp_attribute8 IS NULL THEN
5135: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
5136: END IF;
5137: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
5133: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
5134: OR p_in_rec.tp_attribute8 IS NULL THEN
5135: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
5136: END IF;
5137: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
5138: OR p_in_rec.tp_attribute9 IS NULL THEN
5139: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
5140: END IF;
5141: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
5137: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
5138: OR p_in_rec.tp_attribute9 IS NULL THEN
5139: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
5140: END IF;
5141: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
5142: OR p_in_rec.tp_attribute10 IS NULL THEN
5143: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
5144: END IF;
5145: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
5141: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
5142: OR p_in_rec.tp_attribute10 IS NULL THEN
5143: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
5144: END IF;
5145: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
5146: OR p_in_rec.tp_attribute11 IS NULL THEN
5147: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
5148: END IF;
5149: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
5145: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
5146: OR p_in_rec.tp_attribute11 IS NULL THEN
5147: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
5148: END IF;
5149: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
5150: OR p_in_rec.tp_attribute12 IS NULL THEN
5151: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
5152: END IF;
5153: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
5149: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
5150: OR p_in_rec.tp_attribute12 IS NULL THEN
5151: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
5152: END IF;
5153: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
5154: OR p_in_rec.tp_attribute13 IS NULL THEN
5155: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
5156: END IF;
5157: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
5153: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
5154: OR p_in_rec.tp_attribute13 IS NULL THEN
5155: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
5156: END IF;
5157: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
5158: OR p_in_rec.tp_attribute14 IS NULL THEN
5159: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
5160: END IF;
5161: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
5157: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
5158: OR p_in_rec.tp_attribute14 IS NULL THEN
5159: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
5160: END IF;
5161: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
5162: OR p_in_rec.tp_attribute15 IS NULL THEN
5163: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
5164: END IF;
5165: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
5161: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
5162: OR p_in_rec.tp_attribute15 IS NULL THEN
5163: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
5164: END IF;
5165: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
5166: OR p_in_rec.tp_attribute_category IS NULL THEN
5167: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
5168: END IF;
5169: -- Commenting out Tare Weight field to make it enable for
5451: WSH_DEBUG_SV.log(l_module_name,'p_action',p_in_rec.action_code);
5452: wsh_debug_sv.log(l_module_name, 'Caller', p_in_rec.caller);
5453: END IF;
5454: --
5455: x_return_status := FND_API.G_RET_STS_SUCCESS;
5456: --
5457: IF p_in_rec.action_code = 'CREATE' THEN
5458: IF l_debug_on THEN
5459: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
5477:
5478: -- Added for bug 4399278, 4418754
5479: IF ( p_in_rec.caller = 'WSH_PUB' and
5480: p_delivery_detail_rec.subinventory is not null and
5481: p_delivery_detail_rec.subinventory <> FND_API.G_MISS_CHAR ) THEN
5482: G_SUBINVENTORY := p_delivery_detail_rec.subinventory;
5483: END IF;
5484:
5485: Get_Disabled_List( p_delivery_detail_rec.DELIVERY_DETAIL_ID
5529: i := l_disabled_list.COUNT;
5530:
5531: IF (l_released_status = 'Y') THEN
5532:
5533: IF p_delivery_detail_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
5534:
5535: l_inventory_item_id := x_delivery_detail_rec.inventory_item_id;
5536:
5537: ELSE
5538:
5539: l_inventory_item_id := p_delivery_detail_rec.inventory_item_id;
5540:
5541: END IF;
5542: IF p_delivery_detail_rec.organization_id = FND_API.G_MISS_NUM THEN
5543:
5544: l_organization_id := x_delivery_detail_rec.organization_id;
5545:
5546: ELSE
5547:
5548: l_organization_id := p_delivery_detail_rec.organization_id;
5549:
5550: END IF;
5551: IF p_delivery_detail_rec.pickable_flag = FND_API.G_MISS_CHAR THEN
5552:
5553: l_pickable_flag := x_delivery_detail_rec.pickable_flag;
5554:
5555: ELSE
5556:
5557: l_pickable_flag := p_delivery_detail_rec.pickable_flag;
5558:
5559: END IF;
5560: IF p_delivery_detail_rec.subinventory = FND_API.G_MISS_CHAR THEN
5561:
5562: l_subinventory := x_delivery_detail_rec.subinventory;
5563:
5564:
5673: close get_delivery_status;
5674: END IF;
5675: --
5676: -- lpn conv.
5677: IF (nvl(l_organization_id, fnd_api.g_miss_num) = fnd_api.g_miss_num) THEN
5678: l_organization_id := x_delivery_detail_rec.organization_id;
5679: END IF;
5680:
5681: IF l_debug_on THEN
6298: l_field_name := 'cycle_count_quantity';
6299: --
6300: ELSE
6301: -- invalid flag
6302: raise fnd_api.g_exc_error;
6303: END IF;
6304:
6305: --1.a) if entered, enable backordered quantity and update it as max(requested_quantity - shipped_quantity),0)
6306: --1.b) if null, clear cycle count and secondary quantity
6325: x_return_status => l_return_status );
6326: --
6327:
6328: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6329: RAISE FND_API.G_EXC_ERROR;
6330: END IF;
6331:
6332:
6333: -- 3) check for decimal
6359: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
6360: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6361: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6362: ELSE
6363: RAISE FND_API.G_EXC_ERROR;
6364: END IF;
6365: END IF;
6366:
6367: -- HW OPM bug 2677054
6382: p_cycle_count_quantity => NVL(x_det_rec.cycle_count_quantity, 0),
6383: x_return_status => l_return_status);
6384:
6385: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6386: RAISE FND_API.G_EXC_ERROR;
6387: END IF;
6388:
6389:
6390: ELSIF(p_flag = 'CCQ') THEN
6401: p_cycle_count_quantity => NVL(l_quantity, 0),
6402: x_return_status => l_return_status);
6403:
6404: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6405: RAISE FND_API.G_EXC_ERROR;
6406: END IF;
6407: END IF;
6408:
6409: -- 5) clear and unmark serial numbers based on quantity checks
6446: wsh_debug_sv.log(l_module_name, 'Return status after Unmark serial', l_return_status);
6447: END IF;
6448:
6449: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6450: RAISE FND_API.G_EXC_ERROR;
6451: END IF;
6452: END IF; -- if serial_quantity > 0
6453:
6454: x_det_rec.serial_quantity := 0;
6490: wsh_debug_sv.log(l_module_name, 'Return status after Unmark serial', l_return_status);
6491: END IF;
6492:
6493: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6494: RAISE FND_API.G_EXC_ERROR;
6495: END IF;
6496: END IF; -- if serial_quantity > 0
6497:
6498: x_det_rec.serial_quantity := 0;
6526: WSH_DEBUG_SV.pop(l_module_name);
6527: END IF;
6528:
6529: EXCEPTION
6530: WHEN FND_API.G_EXC_ERROR THEN
6531: x_return_status := FND_API.G_RET_STS_ERROR ;
6532: wsh_util_core.add_message(x_return_status, l_module_name);
6533: FND_MSG_PUB.Count_And_Get
6534: (
6527: END IF;
6528:
6529: EXCEPTION
6530: WHEN FND_API.G_EXC_ERROR THEN
6531: x_return_status := FND_API.G_RET_STS_ERROR ;
6532: wsh_util_core.add_message(x_return_status, l_module_name);
6533: FND_MSG_PUB.Count_And_Get
6534: (
6535: p_count => x_msg_count,
6533: FND_MSG_PUB.Count_And_Get
6534: (
6535: p_count => x_msg_count,
6536: p_data => x_msg_data,
6537: p_encoded => FND_API.G_FALSE
6538: );
6539:
6540: IF l_debug_on THEN
6541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6537: p_encoded => FND_API.G_FALSE
6538: );
6539:
6540: IF l_debug_on THEN
6541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6543: END IF;
6544: --
6545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6538: );
6539:
6540: IF l_debug_on THEN
6541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6543: END IF;
6544: --
6545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6546: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6548: FND_MSG_PUB.Count_And_Get
6549: (
6550: p_count => x_msg_count,
6551: p_data => x_msg_data,
6552: p_encoded => FND_API.G_FALSE
6553: );
6554: --
6555: IF l_debug_on THEN
6556: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6556: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
6558: END IF;
6559:
6560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6562: FND_MSG_PUB.Count_And_Get
6563: (
6564: p_count => x_msg_count,
6557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
6558: END IF;
6559:
6560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6562: FND_MSG_PUB.Count_And_Get
6563: (
6564: p_count => x_msg_count,
6565: p_data => x_msg_data,
6562: FND_MSG_PUB.Count_And_Get
6563: (
6564: p_count => x_msg_count,
6565: p_data => x_msg_data,
6566: p_encoded => FND_API.G_FALSE
6567: );
6568:
6569: IF l_debug_on THEN
6570: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6566: p_encoded => FND_API.G_FALSE
6567: );
6568:
6569: IF l_debug_on THEN
6570: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6571: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6572: END IF;
6573: --
6574: WHEN OTHERS THEN
6567: );
6568:
6569: IF l_debug_on THEN
6570: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6571: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6572: END IF;
6573: --
6574: WHEN OTHERS THEN
6575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6571: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6572: END IF;
6573: --
6574: WHEN OTHERS THEN
6575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6576: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY');
6577: --
6578: IF l_debug_on THEN
6579: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6660: l_field_name := 'cycle_count_quantity2';
6661: --
6662: ELSE
6663: -- invalid flag
6664: raise fnd_api.g_exc_error;
6665: END IF;
6666:
6667: --1.a) if entered, enable backordered quantity and update it as max(requested_quantity2 - shipped_quantity2),0)
6668: --1.b) if null, clear cycle count and secondary quantity
6694: x_return_status => l_return_status );
6695: --
6696:
6697: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6698: RAISE FND_API.G_EXC_ERROR;
6699: END IF;
6700:
6701: -- HW OPM BUG#:2677054
6702: IF(p_flag = 'SQ') THEN
6725: p_cycle_count_quantity => NVL(x_det_rec.cycle_count_quantity2, 0),
6726: x_return_status => l_return_status);
6727:
6728: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6729: RAISE FND_API.G_EXC_ERROR;
6730: END IF;
6731: ELSIF(p_flag = 'CCQ') THEN
6732:
6733: IF l_debug_on THEN
6741: p_cycle_count_quantity => NVL(l_quantity, 0),
6742: x_return_status => l_return_status);
6743:
6744: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6745: RAISE FND_API.G_EXC_ERROR;
6746: END IF;
6747: END IF;
6748: */
6749:
6762: WSH_DEBUG_SV.pop(l_module_name);
6763: END IF;
6764:
6765: EXCEPTION
6766: WHEN FND_API.G_EXC_ERROR THEN
6767: x_return_status := FND_API.G_RET_STS_ERROR ;
6768: FND_MSG_PUB.Count_And_Get
6769: (
6770: p_count => x_msg_count,
6763: END IF;
6764:
6765: EXCEPTION
6766: WHEN FND_API.G_EXC_ERROR THEN
6767: x_return_status := FND_API.G_RET_STS_ERROR ;
6768: FND_MSG_PUB.Count_And_Get
6769: (
6770: p_count => x_msg_count,
6771: p_data => x_msg_data,
6768: FND_MSG_PUB.Count_And_Get
6769: (
6770: p_count => x_msg_count,
6771: p_data => x_msg_data,
6772: p_encoded => FND_API.G_FALSE
6773: );
6774:
6775: IF l_debug_on THEN
6776: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6772: p_encoded => FND_API.G_FALSE
6773: );
6774:
6775: IF l_debug_on THEN
6776: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6777: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6778: END IF;
6779: --
6780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6773: );
6774:
6775: IF l_debug_on THEN
6776: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6777: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6778: END IF;
6779: --
6780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6776: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6777: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6778: END IF;
6779: --
6780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6782: FND_MSG_PUB.Count_And_Get
6783: (
6784: p_count => x_msg_count,
6777: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6778: END IF;
6779: --
6780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6782: FND_MSG_PUB.Count_And_Get
6783: (
6784: p_count => x_msg_count,
6785: p_data => x_msg_data,
6782: FND_MSG_PUB.Count_And_Get
6783: (
6784: p_count => x_msg_count,
6785: p_data => x_msg_data,
6786: p_encoded => FND_API.G_FALSE
6787: );
6788:
6789: IF l_debug_on THEN
6790: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6786: p_encoded => FND_API.G_FALSE
6787: );
6788:
6789: IF l_debug_on THEN
6790: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6792: END IF;
6793: --
6794: WHEN OTHERS THEN
6787: );
6788:
6789: IF l_debug_on THEN
6790: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6792: END IF;
6793: --
6794: WHEN OTHERS THEN
6795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6792: END IF;
6793: --
6794: WHEN OTHERS THEN
6795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6796: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2');
6797: --
6798: IF l_debug_on THEN
6799: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7043: THEN
7044: --{
7045: fnd_message.set_name('WSH', 'WSH_REQUIRED_FIELD_NULL');
7046: fnd_message.set_token('FIELD_NAME','x_quantity');
7047: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7048: RAISE FND_API.G_EXC_ERROR;
7049: --}
7050: /* HW BUG 4548713- Removed checking for Qty being 0
7051: ELSIF x_quantity = 0
7044: --{
7045: fnd_message.set_name('WSH', 'WSH_REQUIRED_FIELD_NULL');
7046: fnd_message.set_token('FIELD_NAME','x_quantity');
7047: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7048: RAISE FND_API.G_EXC_ERROR;
7049: --}
7050: /* HW BUG 4548713- Removed checking for Qty being 0
7051: ELSIF x_quantity = 0
7052: THEN
7052: THEN
7053: --{
7054: --
7055: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
7056: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7057: RAISE FND_API.G_EXC_ERROR;
7058: --}
7059: */
7060: ELSIF x_quantity < 0
7053: --{
7054: --
7055: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
7056: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7057: RAISE FND_API.G_EXC_ERROR;
7058: --}
7059: */
7060: ELSIF x_quantity < 0
7061: THEN
7060: ELSIF x_quantity < 0
7061: THEN
7062: --{
7063: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
7064: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7065: RAISE FND_API.G_EXC_ERROR;
7066: --}
7067: END IF;
7068: --
7061: THEN
7062: --{
7063: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
7064: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7065: RAISE FND_API.G_EXC_ERROR;
7066: --}
7067: END IF;
7068: --
7069: --
7076: THEN
7077: --{
7078: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
7079: fnd_message.set_token('DETAIL_ID',p_delivery_detail_id);
7080: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7081: RAISE FND_API.G_EXC_ERROR;
7082: --}
7083: END IF;
7084: --
7077: --{
7078: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
7079: fnd_message.set_token('DETAIL_ID',p_delivery_detail_id);
7080: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7081: RAISE FND_API.G_EXC_ERROR;
7082: --}
7083: END IF;
7084: --
7085: --
7139: AND l_item_info.secondary_default_ind in ('F','D','N')
7140: THEN
7141: --{
7142: fnd_message.set_name('WSH', 'WSH_OPM_SEC_QTY_REQD_ERROR');
7143: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7144: RAISE FND_API.G_EXC_ERROR;
7145: --}
7146: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7147: -- HW BUG 4548713 - Added check for x_quantity
7140: THEN
7141: --{
7142: fnd_message.set_name('WSH', 'WSH_OPM_SEC_QTY_REQD_ERROR');
7143: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7144: RAISE FND_API.G_EXC_ERROR;
7145: --}
7146: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7147: -- HW BUG 4548713 - Added check for x_quantity
7148: ELSIF x_quantity2 = 0
7153: --
7154:
7155:
7156: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
7157: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7158: RAISE FND_API.G_EXC_ERROR;
7159: --}
7160: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7161: ELSIF x_quantity2 < 0
7154:
7155:
7156: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
7157: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7158: RAISE FND_API.G_EXC_ERROR;
7159: --}
7160: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7161: ELSIF x_quantity2 < 0
7162: AND l_item_info.secondary_default_ind in ('F','D','N')
7162: AND l_item_info.secondary_default_ind in ('F','D','N')
7163: THEN
7164: --{
7165: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
7166: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7167: RAISE FND_API.G_EXC_ERROR;
7168: --}
7169: END IF;
7170: --
7163: THEN
7164: --{
7165: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
7166: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7167: RAISE FND_API.G_EXC_ERROR;
7168: --}
7169: END IF;
7170: --
7171: --
7184: IF lot_csr%NOTFOUND
7185: THEN
7186: --{
7187: --fnd_message.set_name('GMI', 'IC_INVALID_LOT');
7188: --wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7189: RAISE INVALID_LOT;
7190: --}
7191: END IF;
7192: --
7262: );
7263: --
7264: IF ( l_qty2 <= 0 ) THEN
7265: FND_MESSAGE.SET_NAME('wsh','WSH_UPDATE_CANNOT_SPLIT');
7266: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7267: RAISE FND_API.G_EXC_ERROR;
7268: END IF;
7269: --
7270: IF l_qty2 <> x_quantity2
7263: --
7264: IF ( l_qty2 <= 0 ) THEN
7265: FND_MESSAGE.SET_NAME('wsh','WSH_UPDATE_CANNOT_SPLIT');
7266: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7267: RAISE FND_API.G_EXC_ERROR;
7268: END IF;
7269: --
7270: IF l_qty2 <> x_quantity2
7271: THEN
7272: --{
7273: FND_MESSAGE.SET_NAME('WSH','WSH_OPM_QTY_ERROR');
7274: FND_MESSAGE.SET_TOKEN('QUANTITY2',x_quantity2);
7275: FND_MESSAGE.SET_TOKEN('CONV_QUANTITY2',l_qty2);
7276: --wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7277: --RAISE FND_API.G_EXC_ERROR;
7278: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);
7279: l_number_of_warnings := NVL(l_number_of_warnings,0) + 1;
7280: --}
7273: FND_MESSAGE.SET_NAME('WSH','WSH_OPM_QTY_ERROR');
7274: FND_MESSAGE.SET_TOKEN('QUANTITY2',x_quantity2);
7275: FND_MESSAGE.SET_TOKEN('CONV_QUANTITY2',l_qty2);
7276: --wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7277: --RAISE FND_API.G_EXC_ERROR;
7278: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);
7279: l_number_of_warnings := NVL(l_number_of_warnings,0) + 1;
7280: --}
7281: END IF;
7294: --
7295: fnd_msg_pub.count_and_get(
7296: p_count => x_msg_count,
7297: p_data => x_msg_data,
7298: p_encoded => fnd_api.g_false);
7299:
7300: IF l_debug_on THEN
7301: wsh_debug_sv.LOG(l_module_name, 'X_QUANTITY2', x_quantity2);
7302: wsh_debug_sv.pop(l_module_name);
7304: --
7305: --}
7306: EXCEPTION
7307: WHEN e_end_of_api THEN
7308: x_return_status := fnd_api.g_ret_sts_success;
7309: fnd_msg_pub.count_and_get(
7310: p_count => x_msg_count,
7311: p_data => x_msg_data,
7312: p_encoded => fnd_api.g_false);
7308: x_return_status := fnd_api.g_ret_sts_success;
7309: fnd_msg_pub.count_and_get(
7310: p_count => x_msg_count,
7311: p_data => x_msg_data,
7312: p_encoded => fnd_api.g_false);
7313: --
7314: IF l_debug_on THEN
7315: wsh_debug_sv.pop(l_module_name);
7316: END IF;
7316: END IF;
7317: --
7318:
7319: WHEN INVALID_LOT THEN
7320: x_return_status := fnd_api.g_ret_sts_error;
7321: IF l_debug_on THEN
7322: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7323: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Lot Number');
7324: END IF;
7318:
7319: WHEN INVALID_LOT THEN
7320: x_return_status := fnd_api.g_ret_sts_error;
7321: IF l_debug_on THEN
7322: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7323: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Lot Number');
7324: END IF;
7325:
7326: WHEN OUT_OF_DEVIATION THEN
7323: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Lot Number');
7324: END IF;
7325:
7326: WHEN OUT_OF_DEVIATION THEN
7327: x_return_status := fnd_api.g_ret_sts_error;
7328: IF l_debug_on THEN
7329: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7330: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7331: END IF;
7325:
7326: WHEN OUT_OF_DEVIATION THEN
7327: x_return_status := fnd_api.g_ret_sts_error;
7328: IF l_debug_on THEN
7329: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7330: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7331: END IF;
7332:
7333: WHEN fnd_api.g_exc_error THEN
7326: WHEN OUT_OF_DEVIATION THEN
7327: x_return_status := fnd_api.g_ret_sts_error;
7328: IF l_debug_on THEN
7329: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7330: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7331: END IF;
7332:
7333: WHEN fnd_api.g_exc_error THEN
7334: x_return_status := fnd_api.g_ret_sts_error;
7329: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7330: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7331: END IF;
7332:
7333: WHEN fnd_api.g_exc_error THEN
7334: x_return_status := fnd_api.g_ret_sts_error;
7335: fnd_msg_pub.count_and_get(
7336: p_count => x_msg_count,
7337: p_data => x_msg_data,
7330: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7331: END IF;
7332:
7333: WHEN fnd_api.g_exc_error THEN
7334: x_return_status := fnd_api.g_ret_sts_error;
7335: fnd_msg_pub.count_and_get(
7336: p_count => x_msg_count,
7337: p_data => x_msg_data,
7338: p_encoded => fnd_api.g_false);
7334: x_return_status := fnd_api.g_ret_sts_error;
7335: fnd_msg_pub.count_and_get(
7336: p_count => x_msg_count,
7337: p_data => x_msg_data,
7338: p_encoded => fnd_api.g_false);
7339: --
7340: IF l_debug_on THEN
7341: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7342: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7337: p_data => x_msg_data,
7338: p_encoded => fnd_api.g_false);
7339: --
7340: IF l_debug_on THEN
7341: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7342: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7343: END IF;
7344: --
7345: WHEN fnd_api.g_exc_unexpected_error THEN
7338: p_encoded => fnd_api.g_false);
7339: --
7340: IF l_debug_on THEN
7341: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7342: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7343: END IF;
7344: --
7345: WHEN fnd_api.g_exc_unexpected_error THEN
7346: x_return_status := fnd_api.g_ret_sts_unexp_error;
7341: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7342: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7343: END IF;
7344: --
7345: WHEN fnd_api.g_exc_unexpected_error THEN
7346: x_return_status := fnd_api.g_ret_sts_unexp_error;
7347: fnd_msg_pub.count_and_get(
7348: p_count => x_msg_count,
7349: p_data => x_msg_data,
7342: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7343: END IF;
7344: --
7345: WHEN fnd_api.g_exc_unexpected_error THEN
7346: x_return_status := fnd_api.g_ret_sts_unexp_error;
7347: fnd_msg_pub.count_and_get(
7348: p_count => x_msg_count,
7349: p_data => x_msg_data,
7350: p_encoded => fnd_api.g_false);
7346: x_return_status := fnd_api.g_ret_sts_unexp_error;
7347: fnd_msg_pub.count_and_get(
7348: p_count => x_msg_count,
7349: p_data => x_msg_data,
7350: p_encoded => fnd_api.g_false);
7351: --
7352: IF l_debug_on THEN
7353: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7354: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7349: p_data => x_msg_data,
7350: p_encoded => fnd_api.g_false);
7351: --
7352: IF l_debug_on THEN
7353: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7354: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7355: END IF;
7356: --
7357: WHEN wsh_util_core.g_exc_warning THEN
7350: p_encoded => fnd_api.g_false);
7351: --
7352: IF l_debug_on THEN
7353: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7354: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7355: END IF;
7356: --
7357: WHEN wsh_util_core.g_exc_warning THEN
7358: x_return_status := wsh_util_core.g_ret_sts_warning;
7358: x_return_status := wsh_util_core.g_ret_sts_warning;
7359: fnd_msg_pub.count_and_get(
7360: p_count => x_msg_count,
7361: p_data => x_msg_data,
7362: p_encoded => fnd_api.g_false);
7363: --
7364: IF l_debug_on THEN
7365: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
7366: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7365: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
7366: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7367: END IF;
7368: WHEN OTHERS THEN
7369: x_return_status := fnd_api.g_ret_sts_unexp_error;
7370: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',l_module_name);
7371: --
7372: fnd_msg_pub.count_and_get(
7373: p_count => x_msg_count,
7371: --
7372: fnd_msg_pub.count_and_get(
7373: p_count => x_msg_count,
7374: p_data => x_msg_data,
7375: p_encoded => fnd_api.g_false);
7376: --
7377: IF l_debug_on THEN
7378: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
7379: END IF;
7409: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
7410: --
7411: END IF;
7412: --
7413: x_return_status := FND_API.G_RET_STS_SUCCESS;
7414: --
7415: IF p_user_in_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM
7416: AND NVL(p_user_in_rec.DELIVERY_DETAIL_ID,-99) <> NVL(p_out_rec.DELIVERY_DETAIL_ID,-99)
7417: THEN
7411: END IF;
7412: --
7413: x_return_status := FND_API.G_RET_STS_SUCCESS;
7414: --
7415: IF p_user_in_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM
7416: AND NVL(p_user_in_rec.DELIVERY_DETAIL_ID,-99) <> NVL(p_out_rec.DELIVERY_DETAIL_ID,-99)
7417: THEN
7418: l_attributes := l_attributes || 'DELIVERY_DETAIL_ID, ';
7419: END IF;
7417: THEN
7418: l_attributes := l_attributes || 'DELIVERY_DETAIL_ID, ';
7419: END IF;
7420:
7421: IF p_user_in_rec.SOURCE_CODE <> FND_API.G_MISS_CHAR
7422: AND NVL(p_user_in_rec.SOURCE_CODE,'!!!') <> NVL(p_out_rec.SOURCE_CODE,'!!!')
7423: THEN
7424: l_attributes := l_attributes || 'SOURCE_CODE, ';
7425: END IF;
7423: THEN
7424: l_attributes := l_attributes || 'SOURCE_CODE, ';
7425: END IF;
7426:
7427: IF p_user_in_rec.SOURCE_HEADER_ID <> FND_API.G_MISS_NUM
7428: AND NVL(p_user_in_rec.SOURCE_HEADER_ID,-99) <> NVL(p_out_rec.SOURCE_HEADER_ID,-99)
7429: THEN
7430: l_attributes := l_attributes || 'SOURCE_HEADER_ID, ';
7431: END IF;
7429: THEN
7430: l_attributes := l_attributes || 'SOURCE_HEADER_ID, ';
7431: END IF;
7432:
7433: IF p_user_in_rec.SOURCE_LINE_ID <> FND_API.G_MISS_NUM
7434: AND NVL(p_user_in_rec.SOURCE_LINE_ID,-99) <> NVL(p_out_rec.SOURCE_LINE_ID,-99)
7435: THEN
7436: l_attributes := l_attributes || 'SOURCE_LINE_ID, ';
7437: END IF;
7435: THEN
7436: l_attributes := l_attributes || 'SOURCE_LINE_ID, ';
7437: END IF;
7438:
7439: IF p_user_in_rec.CUSTOMER_ID <> FND_API.G_MISS_NUM
7440: AND NVL(p_user_in_rec.CUSTOMER_ID,-99) <> NVL(p_out_rec.CUSTOMER_ID,-99)
7441: THEN
7442: l_attributes := l_attributes || 'CUSTOMER_ID, ';
7443: END IF;
7441: THEN
7442: l_attributes := l_attributes || 'CUSTOMER_ID, ';
7443: END IF;
7444:
7445: IF p_user_in_rec.SOLD_TO_CONTACT_ID <> FND_API.G_MISS_NUM
7446: AND NVL(p_user_in_rec.SOLD_TO_CONTACT_ID,-99) <> NVL(p_out_rec.SOLD_TO_CONTACT_ID,-99)
7447: THEN
7448: l_attributes := l_attributes || 'SOLD_TO_CONTACT_ID, ';
7449: END IF;
7447: THEN
7448: l_attributes := l_attributes || 'SOLD_TO_CONTACT_ID, ';
7449: END IF;
7450:
7451: IF p_user_in_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM
7452: AND NVL(p_user_in_rec.INVENTORY_ITEM_ID,-99) <> NVL(p_out_rec.INVENTORY_ITEM_ID,-99)
7453: THEN
7454: l_attributes := l_attributes || 'INVENTORY_ITEM_ID, ';
7455: END IF;
7453: THEN
7454: l_attributes := l_attributes || 'INVENTORY_ITEM_ID, ';
7455: END IF;
7456:
7457: IF p_user_in_rec.ITEM_DESCRIPTION <> FND_API.G_MISS_CHAR
7458: AND NVL(p_user_in_rec.ITEM_DESCRIPTION,'!!!') <> NVL(p_out_rec.ITEM_DESCRIPTION,'!!!')
7459: THEN
7460: l_attributes := l_attributes || 'ITEM_DESCRIPTION, ';
7461: END IF;
7459: THEN
7460: l_attributes := l_attributes || 'ITEM_DESCRIPTION, ';
7461: END IF;
7462:
7463: IF p_user_in_rec.HAZARD_CLASS_ID <> FND_API.G_MISS_NUM
7464: AND NVL(p_user_in_rec.HAZARD_CLASS_ID,-99) <> NVL(p_out_rec.HAZARD_CLASS_ID,-99)
7465: THEN
7466: l_attributes := l_attributes || 'HAZARD_CLASS_ID, ';
7467: END IF;
7465: THEN
7466: l_attributes := l_attributes || 'HAZARD_CLASS_ID, ';
7467: END IF;
7468:
7469: IF p_user_in_rec.COUNTRY_OF_ORIGIN <> FND_API.G_MISS_CHAR
7470: AND NVL(p_user_in_rec.COUNTRY_OF_ORIGIN,'!!!') <> NVL(p_out_rec.COUNTRY_OF_ORIGIN,'!!!')
7471: THEN
7472: l_attributes := l_attributes || 'COUNTRY_OF_ORIGIN, ';
7473: END IF;
7471: THEN
7472: l_attributes := l_attributes || 'COUNTRY_OF_ORIGIN, ';
7473: END IF;
7474:
7475: IF p_user_in_rec.CLASSIFICATION <> FND_API.G_MISS_CHAR
7476: AND NVL(p_user_in_rec.CLASSIFICATION,'!!!') <> NVL(p_out_rec.CLASSIFICATION,'!!!')
7477: THEN
7478: l_attributes := l_attributes || 'CLASSIFICATION, ';
7479: END IF;
7477: THEN
7478: l_attributes := l_attributes || 'CLASSIFICATION, ';
7479: END IF;
7480:
7481: IF p_user_in_rec.SHIP_FROM_LOCATION_ID <> FND_API.G_MISS_NUM
7482: AND NVL(p_user_in_rec.SHIP_FROM_LOCATION_ID,-99) <> NVL(p_out_rec.SHIP_FROM_LOCATION_ID,-99)
7483: THEN
7484: l_attributes := l_attributes || 'SHIP_FROM_LOCATION_ID, ';
7485: END IF;
7483: THEN
7484: l_attributes := l_attributes || 'SHIP_FROM_LOCATION_ID, ';
7485: END IF;
7486:
7487: IF p_user_in_rec.SHIP_TO_LOCATION_ID <> FND_API.G_MISS_NUM
7488: AND NVL(p_user_in_rec.SHIP_TO_LOCATION_ID,-99) <> NVL(p_out_rec.SHIP_TO_LOCATION_ID,-99)
7489: THEN
7490: l_attributes := l_attributes || 'SHIP_TO_LOCATION_ID, ';
7491: END IF;
7489: THEN
7490: l_attributes := l_attributes || 'SHIP_TO_LOCATION_ID, ';
7491: END IF;
7492:
7493: IF p_user_in_rec.SHIP_TO_CONTACT_ID <> FND_API.G_MISS_NUM
7494: AND NVL(p_user_in_rec.SHIP_TO_CONTACT_ID,-99) <> NVL(p_out_rec.SHIP_TO_CONTACT_ID,-99)
7495: THEN
7496: l_attributes := l_attributes || 'SHIP_TO_CONTACT_ID, ';
7497: END IF;
7495: THEN
7496: l_attributes := l_attributes || 'SHIP_TO_CONTACT_ID, ';
7497: END IF;
7498:
7499: IF p_user_in_rec.SHIP_TO_SITE_USE_ID <> FND_API.G_MISS_NUM
7500: AND NVL(p_user_in_rec.SHIP_TO_SITE_USE_ID,-99) <> NVL(p_out_rec.SHIP_TO_SITE_USE_ID,-99)
7501: THEN
7502: l_attributes := l_attributes || 'SHIP_TO_SITE_USE_ID, ';
7503: END IF;
7501: THEN
7502: l_attributes := l_attributes || 'SHIP_TO_SITE_USE_ID, ';
7503: END IF;
7504:
7505: IF p_user_in_rec.DELIVER_TO_LOCATION_ID <> FND_API.G_MISS_NUM
7506: AND NVL(p_user_in_rec.DELIVER_TO_LOCATION_ID,-99) <> NVL(p_out_rec.DELIVER_TO_LOCATION_ID,-99)
7507: THEN
7508: l_attributes := l_attributes || 'DELIVER_TO_LOCATION_ID, ';
7509: END IF;
7507: THEN
7508: l_attributes := l_attributes || 'DELIVER_TO_LOCATION_ID, ';
7509: END IF;
7510:
7511: IF p_user_in_rec.DELIVER_TO_CONTACT_ID <> FND_API.G_MISS_NUM
7512: AND NVL(p_user_in_rec.DELIVER_TO_CONTACT_ID,-99) <> NVL(p_out_rec.DELIVER_TO_CONTACT_ID,-99)
7513: THEN
7514: l_attributes := l_attributes || 'DELIVER_TO_CONTACT_ID, ';
7515: END IF;
7513: THEN
7514: l_attributes := l_attributes || 'DELIVER_TO_CONTACT_ID, ';
7515: END IF;
7516:
7517: IF p_user_in_rec.DELIVER_TO_SITE_USE_ID <> FND_API.G_MISS_NUM
7518: AND NVL(p_user_in_rec.DELIVER_TO_SITE_USE_ID,-99) <> NVL(p_out_rec.DELIVER_TO_SITE_USE_ID,-99)
7519: THEN
7520: l_attributes := l_attributes || 'DELIVER_TO_SITE_USE_ID, ';
7521: END IF;
7519: THEN
7520: l_attributes := l_attributes || 'DELIVER_TO_SITE_USE_ID, ';
7521: END IF;
7522:
7523: IF p_user_in_rec.INTMED_SHIP_TO_LOCATION_ID <> FND_API.G_MISS_NUM
7524: AND NVL(p_user_in_rec.INTMED_SHIP_TO_LOCATION_ID,-99) <> NVL(p_out_rec.INTMED_SHIP_TO_LOCATION_ID,-99)
7525: THEN
7526: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_ID, ';
7527: END IF;
7525: THEN
7526: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_ID, ';
7527: END IF;
7528:
7529: IF p_user_in_rec.INTMED_SHIP_TO_CONTACT_ID <> FND_API.G_MISS_NUM
7530: AND NVL(p_user_in_rec.INTMED_SHIP_TO_CONTACT_ID,-99) <> NVL(p_out_rec.INTMED_SHIP_TO_CONTACT_ID,-99)
7531: THEN
7532: l_attributes := l_attributes || 'INTMED_SHIP_TO_CONTACT_ID, ';
7533: END IF;
7531: THEN
7532: l_attributes := l_attributes || 'INTMED_SHIP_TO_CONTACT_ID, ';
7533: END IF;
7534:
7535: IF p_user_in_rec.HOLD_CODE <> FND_API.G_MISS_CHAR
7536: AND NVL(p_user_in_rec.HOLD_CODE,'!!!') <> NVL(p_out_rec.HOLD_CODE,'!!!')
7537: THEN
7538: l_attributes := l_attributes || 'HOLD_CODE, ';
7539: END IF;
7537: THEN
7538: l_attributes := l_attributes || 'HOLD_CODE, ';
7539: END IF;
7540:
7541: IF p_user_in_rec.SHIP_TOLERANCE_ABOVE <> FND_API.G_MISS_NUM
7542: AND NVL(p_user_in_rec.SHIP_TOLERANCE_ABOVE,-99) <> NVL(p_out_rec.SHIP_TOLERANCE_ABOVE,-99)
7543: THEN
7544: l_attributes := l_attributes || 'SHIP_TOLERANCE_ABOVE, ';
7545: END IF;
7543: THEN
7544: l_attributes := l_attributes || 'SHIP_TOLERANCE_ABOVE, ';
7545: END IF;
7546:
7547: IF p_user_in_rec.SHIP_TOLERANCE_BELOW <> FND_API.G_MISS_NUM
7548: AND NVL(p_user_in_rec.SHIP_TOLERANCE_BELOW,-99) <> NVL(p_out_rec.SHIP_TOLERANCE_BELOW,-99)
7549: THEN
7550: l_attributes := l_attributes || 'SHIP_TOLERANCE_BELOW, ';
7551: END IF;
7549: THEN
7550: l_attributes := l_attributes || 'SHIP_TOLERANCE_BELOW, ';
7551: END IF;
7552:
7553: IF p_user_in_rec.REQUESTED_QUANTITY <> FND_API.G_MISS_NUM
7554: AND NVL(p_user_in_rec.REQUESTED_QUANTITY,-99) <> NVL(p_out_rec.REQUESTED_QUANTITY,-99)
7555: THEN
7556: l_attributes := l_attributes || 'REQUESTED_QUANTITY, ';
7557: END IF;
7555: THEN
7556: l_attributes := l_attributes || 'REQUESTED_QUANTITY, ';
7557: END IF;
7558:
7559: IF p_user_in_rec.SHIPPED_QUANTITY <> FND_API.G_MISS_NUM
7560: AND NVL(p_user_in_rec.SHIPPED_QUANTITY,-99) <> NVL(p_out_rec.SHIPPED_QUANTITY,-99)
7561: THEN
7562: l_attributes := l_attributes || 'SHIPPED_QUANTITY, ';
7563: END IF;
7561: THEN
7562: l_attributes := l_attributes || 'SHIPPED_QUANTITY, ';
7563: END IF;
7564:
7565: IF p_user_in_rec.DELIVERED_QUANTITY <> FND_API.G_MISS_NUM
7566: AND NVL(p_user_in_rec.DELIVERED_QUANTITY,-99) <> NVL(p_out_rec.DELIVERED_QUANTITY,-99)
7567: THEN
7568: l_attributes := l_attributes || 'DELIVERED_QUANTITY, ';
7569: END IF;
7567: THEN
7568: l_attributes := l_attributes || 'DELIVERED_QUANTITY, ';
7569: END IF;
7570:
7571: IF p_user_in_rec.REQUESTED_QUANTITY_UOM <> FND_API.G_MISS_CHAR
7572: AND NVL(p_user_in_rec.REQUESTED_QUANTITY_UOM,'!!!') <> NVL(p_out_rec.REQUESTED_QUANTITY_UOM,'!!!')
7573: THEN
7574: l_attributes := l_attributes || 'REQUESTED_QUANTITY_UOM, ';
7575: END IF;
7573: THEN
7574: l_attributes := l_attributes || 'REQUESTED_QUANTITY_UOM, ';
7575: END IF;
7576:
7577: IF p_user_in_rec.SUBINVENTORY <> FND_API.G_MISS_CHAR
7578: AND NVL(p_user_in_rec.SUBINVENTORY,'!!!') <> NVL(p_out_rec.SUBINVENTORY,'!!!')
7579: THEN
7580: l_attributes := l_attributes || 'SUBINVENTORY, ';
7581: END IF;
7579: THEN
7580: l_attributes := l_attributes || 'SUBINVENTORY, ';
7581: END IF;
7582:
7583: IF p_user_in_rec.REVISION <> FND_API.G_MISS_CHAR
7584: AND NVL(p_user_in_rec.REVISION,'!!!') <> NVL(p_out_rec.REVISION,'!!!')
7585: THEN
7586: l_attributes := l_attributes || 'REVISION, ';
7587: END IF;
7585: THEN
7586: l_attributes := l_attributes || 'REVISION, ';
7587: END IF;
7588:
7589: IF p_user_in_rec.LOT_NUMBER <> FND_API.G_MISS_CHAR
7590: AND NVL(p_user_in_rec.LOT_NUMBER,'!!!') <> NVL(p_out_rec.LOT_NUMBER,'!!!')
7591: THEN
7592: l_attributes := l_attributes || 'LOT_NUMBER, ';
7593: END IF;
7591: THEN
7592: l_attributes := l_attributes || 'LOT_NUMBER, ';
7593: END IF;
7594:
7595: IF p_user_in_rec.CUSTOMER_REQUESTED_LOT_FLAG <> FND_API.G_MISS_CHAR
7596: AND NVL(p_user_in_rec.CUSTOMER_REQUESTED_LOT_FLAG,'!!!') <> NVL(p_out_rec.CUSTOMER_REQUESTED_LOT_FLAG,'!!!')
7597: THEN
7598: l_attributes := l_attributes || 'CUSTOMER_REQUESTED_LOT_FLAG, ';
7599: END IF;
7597: THEN
7598: l_attributes := l_attributes || 'CUSTOMER_REQUESTED_LOT_FLAG, ';
7599: END IF;
7600:
7601: IF p_user_in_rec.SERIAL_NUMBER <> FND_API.G_MISS_CHAR
7602: AND NVL(p_user_in_rec.SERIAL_NUMBER,'!!!') <> NVL(p_out_rec.SERIAL_NUMBER,'!!!')
7603: THEN
7604: l_attributes := l_attributes || 'SERIAL_NUMBER, ';
7605: END IF;
7603: THEN
7604: l_attributes := l_attributes || 'SERIAL_NUMBER, ';
7605: END IF;
7606:
7607: IF p_user_in_rec.LOCATOR_ID <> FND_API.G_MISS_NUM
7608: AND NVL(p_user_in_rec.LOCATOR_ID,-99) <> NVL(p_out_rec.LOCATOR_ID,-99)
7609: THEN
7610: l_attributes := l_attributes || 'LOCATOR_ID, ';
7611: END IF;
7609: THEN
7610: l_attributes := l_attributes || 'LOCATOR_ID, ';
7611: END IF;
7612:
7613: IF p_user_in_rec.DATE_REQUESTED <> FND_API.G_MISS_DATE
7614: AND NVL(p_user_in_rec.DATE_REQUESTED,TO_DATE('2','j')) <> NVL(p_out_rec.DATE_REQUESTED,TO_DATE('2','j'))
7615: THEN
7616: l_attributes := l_attributes || 'DATE_REQUESTED, ';
7617: END IF;
7615: THEN
7616: l_attributes := l_attributes || 'DATE_REQUESTED, ';
7617: END IF;
7618:
7619: IF p_user_in_rec.DATE_SCHEDULED <> FND_API.G_MISS_DATE
7620: AND NVL(p_user_in_rec.DATE_SCHEDULED,TO_DATE('2','j')) <> NVL(p_out_rec.DATE_SCHEDULED,TO_DATE('2','j'))
7621: THEN
7622: l_attributes := l_attributes || 'DATE_SCHEDULED, ';
7623: END IF;
7621: THEN
7622: l_attributes := l_attributes || 'DATE_SCHEDULED, ';
7623: END IF;
7624:
7625: IF p_user_in_rec.MASTER_CONTAINER_ITEM_ID <> FND_API.G_MISS_NUM
7626: AND NVL(p_user_in_rec.MASTER_CONTAINER_ITEM_ID,-99) <> NVL(p_out_rec.MASTER_CONTAINER_ITEM_ID,-99)
7627: THEN
7628: l_attributes := l_attributes || 'MASTER_CONTAINER_ITEM_ID, ';
7629: END IF;
7627: THEN
7628: l_attributes := l_attributes || 'MASTER_CONTAINER_ITEM_ID, ';
7629: END IF;
7630:
7631: IF p_user_in_rec.DETAIL_CONTAINER_ITEM_ID <> FND_API.G_MISS_NUM
7632: AND NVL(p_user_in_rec.DETAIL_CONTAINER_ITEM_ID,-99) <> NVL(p_out_rec.DETAIL_CONTAINER_ITEM_ID,-99)
7633: THEN
7634: l_attributes := l_attributes || 'DETAIL_CONTAINER_ITEM_ID, ';
7635: END IF;
7633: THEN
7634: l_attributes := l_attributes || 'DETAIL_CONTAINER_ITEM_ID, ';
7635: END IF;
7636:
7637: IF p_user_in_rec.LOAD_SEQ_NUMBER <> FND_API.G_MISS_NUM
7638: AND NVL(p_user_in_rec.LOAD_SEQ_NUMBER,-99) <> NVL(p_out_rec.LOAD_SEQ_NUMBER,-99)
7639: THEN
7640: l_attributes := l_attributes || 'LOAD_SEQ_NUMBER, ';
7641: END IF;
7639: THEN
7640: l_attributes := l_attributes || 'LOAD_SEQ_NUMBER, ';
7641: END IF;
7642:
7643: IF p_user_in_rec.SHIP_METHOD_CODE <> FND_API.G_MISS_CHAR
7644: AND NVL(p_user_in_rec.SHIP_METHOD_CODE,'!!!') <> NVL(p_out_rec.SHIP_METHOD_CODE,'!!!')
7645: THEN
7646: l_attributes := l_attributes || 'SHIP_METHOD_CODE, ';
7647: END IF;
7645: THEN
7646: l_attributes := l_attributes || 'SHIP_METHOD_CODE, ';
7647: END IF;
7648:
7649: IF p_user_in_rec.CARRIER_ID <> FND_API.G_MISS_NUM
7650: AND NVL(p_user_in_rec.CARRIER_ID,-99) <> NVL(p_out_rec.CARRIER_ID,-99)
7651: THEN
7652: l_attributes := l_attributes || 'CARRIER_ID, ';
7653: END IF;
7651: THEN
7652: l_attributes := l_attributes || 'CARRIER_ID, ';
7653: END IF;
7654:
7655: IF p_user_in_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
7656: AND NVL(p_user_in_rec.FREIGHT_TERMS_CODE,'!!!') <> NVL(p_out_rec.FREIGHT_TERMS_CODE,'!!!')
7657: THEN
7658: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE, ';
7659: END IF;
7657: THEN
7658: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE, ';
7659: END IF;
7660:
7661: IF p_user_in_rec.SHIPMENT_PRIORITY_CODE <> FND_API.G_MISS_CHAR
7662: AND NVL(p_user_in_rec.SHIPMENT_PRIORITY_CODE,'!!!') <> NVL(p_out_rec.SHIPMENT_PRIORITY_CODE,'!!!')
7663: THEN
7664: l_attributes := l_attributes || 'SHIPMENT_PRIORITY_CODE, ';
7665: END IF;
7663: THEN
7664: l_attributes := l_attributes || 'SHIPMENT_PRIORITY_CODE, ';
7665: END IF;
7666:
7667: IF p_user_in_rec.FOB_CODE <> FND_API.G_MISS_CHAR
7668: AND NVL(p_user_in_rec.FOB_CODE,'!!!') <> NVL(p_out_rec.FOB_CODE,'!!!')
7669: THEN
7670: l_attributes := l_attributes || 'FOB_CODE, ';
7671: END IF;
7669: THEN
7670: l_attributes := l_attributes || 'FOB_CODE, ';
7671: END IF;
7672:
7673: IF p_user_in_rec.CUSTOMER_ITEM_ID <> FND_API.G_MISS_NUM
7674: AND NVL(p_user_in_rec.CUSTOMER_ITEM_ID,-99) <> NVL(p_out_rec.CUSTOMER_ITEM_ID,-99)
7675: THEN
7676: l_attributes := l_attributes || 'CUSTOMER_ITEM_ID, ';
7677: END IF;
7675: THEN
7676: l_attributes := l_attributes || 'CUSTOMER_ITEM_ID, ';
7677: END IF;
7678:
7679: IF p_user_in_rec.DEP_PLAN_REQUIRED_FLAG <> FND_API.G_MISS_CHAR
7680: AND NVL(p_user_in_rec.DEP_PLAN_REQUIRED_FLAG,'!!!') <> NVL(p_out_rec.DEP_PLAN_REQUIRED_FLAG,'!!!')
7681: THEN
7682: l_attributes := l_attributes || 'DEP_PLAN_REQUIRED_FLAG, ';
7683: END IF;
7681: THEN
7682: l_attributes := l_attributes || 'DEP_PLAN_REQUIRED_FLAG, ';
7683: END IF;
7684:
7685: IF p_user_in_rec.CUSTOMER_PROD_SEQ <> FND_API.G_MISS_CHAR
7686: AND NVL(p_user_in_rec.CUSTOMER_PROD_SEQ,'!!!') <> NVL(p_out_rec.CUSTOMER_PROD_SEQ,'!!!')
7687: THEN
7688: l_attributes := l_attributes || 'CUSTOMER_PROD_SEQ, ';
7689: END IF;
7687: THEN
7688: l_attributes := l_attributes || 'CUSTOMER_PROD_SEQ, ';
7689: END IF;
7690:
7691: IF p_user_in_rec.CUSTOMER_DOCK_CODE <> FND_API.G_MISS_CHAR
7692: AND NVL(p_user_in_rec.CUSTOMER_DOCK_CODE,'!!!') <> NVL(p_out_rec.CUSTOMER_DOCK_CODE,'!!!')
7693: THEN
7694: l_attributes := l_attributes || 'CUSTOMER_DOCK_CODE, ';
7695: END IF;
7693: THEN
7694: l_attributes := l_attributes || 'CUSTOMER_DOCK_CODE, ';
7695: END IF;
7696:
7697: IF p_user_in_rec.CUST_MODEL_SERIAL_NUMBER <> FND_API.G_MISS_CHAR
7698: AND NVL(p_user_in_rec.CUST_MODEL_SERIAL_NUMBER,'!!!') <> NVL(p_out_rec.CUST_MODEL_SERIAL_NUMBER,'!!!')
7699: THEN
7700: l_attributes := l_attributes || 'CUST_MODEL_SERIAL_NUMBER, ';
7701: END IF;
7699: THEN
7700: l_attributes := l_attributes || 'CUST_MODEL_SERIAL_NUMBER, ';
7701: END IF;
7702:
7703: IF p_user_in_rec.CUSTOMER_JOB <> FND_API.G_MISS_CHAR
7704: AND NVL(p_user_in_rec.CUSTOMER_JOB,'!!!') <> NVL(p_out_rec.CUSTOMER_JOB,'!!!')
7705: THEN
7706: l_attributes := l_attributes || 'CUSTOMER_JOB, ';
7707: END IF;
7705: THEN
7706: l_attributes := l_attributes || 'CUSTOMER_JOB, ';
7707: END IF;
7708:
7709: IF p_user_in_rec.CUSTOMER_PRODUCTION_LINE <> FND_API.G_MISS_CHAR
7710: AND NVL(p_user_in_rec.CUSTOMER_PRODUCTION_LINE,'!!!') <> NVL(p_out_rec.CUSTOMER_PRODUCTION_LINE,'!!!')
7711: THEN
7712: l_attributes := l_attributes || 'CUSTOMER_PRODUCTION_LINE, ';
7713: END IF;
7711: THEN
7712: l_attributes := l_attributes || 'CUSTOMER_PRODUCTION_LINE, ';
7713: END IF;
7714:
7715: IF p_user_in_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
7716: AND NVL(p_user_in_rec.NET_WEIGHT,-99) <> NVL(p_out_rec.NET_WEIGHT,-99)
7717: THEN
7718: l_attributes := l_attributes || 'NET_WEIGHT, ';
7719: END IF;
7717: THEN
7718: l_attributes := l_attributes || 'NET_WEIGHT, ';
7719: END IF;
7720:
7721: IF p_user_in_rec.WEIGHT_UOM_CODE <> FND_API.G_MISS_CHAR
7722: AND NVL(p_user_in_rec.WEIGHT_UOM_CODE,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_CODE,'!!!')
7723: THEN
7724: IF (NVL(p_in_rec.caller,'WSH') LIKE 'WMS%')
7725: AND (NVL(p_in_rec.action_code,'CREATE') = 'UPDATE') THEN
7728: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
7729: END IF;
7730: END IF;
7731:
7732: IF p_user_in_rec.VOLUME <> FND_API.G_MISS_NUM
7733: AND NVL(p_user_in_rec.VOLUME,-99) <> NVL(p_out_rec.VOLUME,-99)
7734: THEN
7735: l_attributes := l_attributes || 'VOLUME, ';
7736: END IF;
7734: THEN
7735: l_attributes := l_attributes || 'VOLUME, ';
7736: END IF;
7737:
7738: IF p_user_in_rec.VOLUME_UOM_CODE <> FND_API.G_MISS_CHAR
7739: AND NVL(p_user_in_rec.VOLUME_UOM_CODE,'!!!') <> NVL(p_out_rec.VOLUME_UOM_CODE,'!!!')
7740: THEN
7741: IF (NVL(p_in_rec.caller,'WSH') LIKE 'WMS%')
7742: AND (NVL(p_in_rec.action_code,'CREATE') = 'UPDATE') THEN
7745: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
7746: END IF;
7747: END IF;
7748:
7749: IF p_user_in_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
7750: AND NVL(p_user_in_rec.TP_ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE_CATEGORY,'!!!')
7751: THEN
7752: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
7753: END IF;
7751: THEN
7752: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
7753: END IF;
7754:
7755: IF p_user_in_rec.TP_ATTRIBUTE1 <> FND_API.G_MISS_CHAR
7756: AND NVL(p_user_in_rec.TP_ATTRIBUTE1,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE1,'!!!')
7757: THEN
7758: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
7759: END IF;
7757: THEN
7758: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
7759: END IF;
7760:
7761: IF p_user_in_rec.TP_ATTRIBUTE2 <> FND_API.G_MISS_CHAR
7762: AND NVL(p_user_in_rec.TP_ATTRIBUTE2,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE2,'!!!')
7763: THEN
7764: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
7765: END IF;
7763: THEN
7764: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
7765: END IF;
7766:
7767: IF p_user_in_rec.TP_ATTRIBUTE3 <> FND_API.G_MISS_CHAR
7768: AND NVL(p_user_in_rec.TP_ATTRIBUTE3,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE3,'!!!')
7769: THEN
7770: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
7771: END IF;
7769: THEN
7770: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
7771: END IF;
7772:
7773: IF p_user_in_rec.TP_ATTRIBUTE4 <> FND_API.G_MISS_CHAR
7774: AND NVL(p_user_in_rec.TP_ATTRIBUTE4,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE4,'!!!')
7775: THEN
7776: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
7777: END IF;
7775: THEN
7776: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
7777: END IF;
7778:
7779: IF p_user_in_rec.TP_ATTRIBUTE5 <> FND_API.G_MISS_CHAR
7780: AND NVL(p_user_in_rec.TP_ATTRIBUTE5,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE5,'!!!')
7781: THEN
7782: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
7783: END IF;
7781: THEN
7782: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
7783: END IF;
7784:
7785: IF p_user_in_rec.TP_ATTRIBUTE6 <> FND_API.G_MISS_CHAR
7786: AND NVL(p_user_in_rec.TP_ATTRIBUTE6,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE6,'!!!')
7787: THEN
7788: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
7789: END IF;
7787: THEN
7788: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
7789: END IF;
7790:
7791: IF p_user_in_rec.TP_ATTRIBUTE7 <> FND_API.G_MISS_CHAR
7792: AND NVL(p_user_in_rec.TP_ATTRIBUTE7,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE7,'!!!')
7793: THEN
7794: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
7795: END IF;
7793: THEN
7794: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
7795: END IF;
7796:
7797: IF p_user_in_rec.TP_ATTRIBUTE8 <> FND_API.G_MISS_CHAR
7798: AND NVL(p_user_in_rec.TP_ATTRIBUTE8,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE8,'!!!')
7799: THEN
7800: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
7801: END IF;
7799: THEN
7800: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
7801: END IF;
7802:
7803: IF p_user_in_rec.TP_ATTRIBUTE9 <> FND_API.G_MISS_CHAR
7804: AND NVL(p_user_in_rec.TP_ATTRIBUTE9,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE9,'!!!')
7805: THEN
7806: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
7807: END IF;
7805: THEN
7806: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
7807: END IF;
7808:
7809: IF p_user_in_rec.TP_ATTRIBUTE10 <> FND_API.G_MISS_CHAR
7810: AND NVL(p_user_in_rec.TP_ATTRIBUTE10,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE10,'!!!')
7811: THEN
7812: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
7813: END IF;
7811: THEN
7812: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
7813: END IF;
7814:
7815: IF p_user_in_rec.TP_ATTRIBUTE11 <> FND_API.G_MISS_CHAR
7816: AND NVL(p_user_in_rec.TP_ATTRIBUTE11,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE11,'!!!')
7817: THEN
7818: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
7819: END IF;
7817: THEN
7818: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
7819: END IF;
7820:
7821: IF p_user_in_rec.TP_ATTRIBUTE12 <> FND_API.G_MISS_CHAR
7822: AND NVL(p_user_in_rec.TP_ATTRIBUTE12,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE12,'!!!')
7823: THEN
7824: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
7825: END IF;
7823: THEN
7824: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
7825: END IF;
7826:
7827: IF p_user_in_rec.TP_ATTRIBUTE13 <> FND_API.G_MISS_CHAR
7828: AND NVL(p_user_in_rec.TP_ATTRIBUTE13,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE13,'!!!')
7829: THEN
7830: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
7831: END IF;
7829: THEN
7830: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
7831: END IF;
7832:
7833: IF p_user_in_rec.TP_ATTRIBUTE14 <> FND_API.G_MISS_CHAR
7834: AND NVL(p_user_in_rec.TP_ATTRIBUTE14,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE14,'!!!')
7835: THEN
7836: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
7837: END IF;
7835: THEN
7836: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
7837: END IF;
7838:
7839: IF p_user_in_rec.TP_ATTRIBUTE15 <> FND_API.G_MISS_CHAR
7840: AND NVL(p_user_in_rec.TP_ATTRIBUTE15,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE15,'!!!')
7841: THEN
7842: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
7843: END IF;
7841: THEN
7842: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
7843: END IF;
7844:
7845: IF p_user_in_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
7846: AND NVL(p_user_in_rec.ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.ATTRIBUTE_CATEGORY,'!!!')
7847: THEN
7848: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
7849: END IF;
7847: THEN
7848: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
7849: END IF;
7850:
7851: IF p_user_in_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
7852: AND NVL(p_user_in_rec.ATTRIBUTE1,'!!!') <> NVL(p_out_rec.ATTRIBUTE1,'!!!')
7853: THEN
7854: l_attributes := l_attributes || 'ATTRIBUTE1, ';
7855: END IF;
7853: THEN
7854: l_attributes := l_attributes || 'ATTRIBUTE1, ';
7855: END IF;
7856:
7857: IF p_user_in_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
7858: AND NVL(p_user_in_rec.ATTRIBUTE2,'!!!') <> NVL(p_out_rec.ATTRIBUTE2,'!!!')
7859: THEN
7860: l_attributes := l_attributes || 'ATTRIBUTE2, ';
7861: END IF;
7859: THEN
7860: l_attributes := l_attributes || 'ATTRIBUTE2, ';
7861: END IF;
7862:
7863: IF p_user_in_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
7864: AND NVL(p_user_in_rec.ATTRIBUTE3,'!!!') <> NVL(p_out_rec.ATTRIBUTE3,'!!!')
7865: THEN
7866: l_attributes := l_attributes || 'ATTRIBUTE3, ';
7867: END IF;
7865: THEN
7866: l_attributes := l_attributes || 'ATTRIBUTE3, ';
7867: END IF;
7868:
7869: IF p_user_in_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
7870: AND NVL(p_user_in_rec.ATTRIBUTE4,'!!!') <> NVL(p_out_rec.ATTRIBUTE4,'!!!')
7871: THEN
7872: l_attributes := l_attributes || 'ATTRIBUTE4, ';
7873: END IF;
7871: THEN
7872: l_attributes := l_attributes || 'ATTRIBUTE4, ';
7873: END IF;
7874:
7875: IF p_user_in_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
7876: AND NVL(p_user_in_rec.ATTRIBUTE5,'!!!') <> NVL(p_out_rec.ATTRIBUTE5,'!!!')
7877: THEN
7878: l_attributes := l_attributes || 'ATTRIBUTE5, ';
7879: END IF;
7877: THEN
7878: l_attributes := l_attributes || 'ATTRIBUTE5, ';
7879: END IF;
7880:
7881: IF p_user_in_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
7882: AND NVL(p_user_in_rec.ATTRIBUTE6,'!!!') <> NVL(p_out_rec.ATTRIBUTE6,'!!!')
7883: THEN
7884: l_attributes := l_attributes || 'ATTRIBUTE6, ';
7885: END IF;
7883: THEN
7884: l_attributes := l_attributes || 'ATTRIBUTE6, ';
7885: END IF;
7886:
7887: IF p_user_in_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
7888: AND NVL(p_user_in_rec.ATTRIBUTE7,'!!!') <> NVL(p_out_rec.ATTRIBUTE7,'!!!')
7889: THEN
7890: l_attributes := l_attributes || 'ATTRIBUTE7, ';
7891: END IF;
7889: THEN
7890: l_attributes := l_attributes || 'ATTRIBUTE7, ';
7891: END IF;
7892:
7893: IF p_user_in_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
7894: AND NVL(p_user_in_rec.ATTRIBUTE8,'!!!') <> NVL(p_out_rec.ATTRIBUTE8,'!!!')
7895: THEN
7896: l_attributes := l_attributes || 'ATTRIBUTE8, ';
7897: END IF;
7895: THEN
7896: l_attributes := l_attributes || 'ATTRIBUTE8, ';
7897: END IF;
7898:
7899: IF p_user_in_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
7900: AND NVL(p_user_in_rec.ATTRIBUTE9,'!!!') <> NVL(p_out_rec.ATTRIBUTE9,'!!!')
7901: THEN
7902: l_attributes := l_attributes || 'ATTRIBUTE9, ';
7903: END IF;
7901: THEN
7902: l_attributes := l_attributes || 'ATTRIBUTE9, ';
7903: END IF;
7904:
7905: IF p_user_in_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
7906: AND NVL(p_user_in_rec.ATTRIBUTE10,'!!!') <> NVL(p_out_rec.ATTRIBUTE10,'!!!')
7907: THEN
7908: l_attributes := l_attributes || 'ATTRIBUTE10, ';
7909: END IF;
7907: THEN
7908: l_attributes := l_attributes || 'ATTRIBUTE10, ';
7909: END IF;
7910:
7911: IF p_user_in_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
7912: AND NVL(p_user_in_rec.ATTRIBUTE11,'!!!') <> NVL(p_out_rec.ATTRIBUTE11,'!!!')
7913: THEN
7914: l_attributes := l_attributes || 'ATTRIBUTE11, ';
7915: END IF;
7913: THEN
7914: l_attributes := l_attributes || 'ATTRIBUTE11, ';
7915: END IF;
7916:
7917: IF p_user_in_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
7918: AND NVL(p_user_in_rec.ATTRIBUTE12,'!!!') <> NVL(p_out_rec.ATTRIBUTE12,'!!!')
7919: THEN
7920: l_attributes := l_attributes || 'ATTRIBUTE12, ';
7921: END IF;
7919: THEN
7920: l_attributes := l_attributes || 'ATTRIBUTE12, ';
7921: END IF;
7922:
7923: IF p_user_in_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
7924: AND NVL(p_user_in_rec.ATTRIBUTE13,'!!!') <> NVL(p_out_rec.ATTRIBUTE13,'!!!')
7925: THEN
7926: l_attributes := l_attributes || 'ATTRIBUTE13, ';
7927: END IF;
7925: THEN
7926: l_attributes := l_attributes || 'ATTRIBUTE13, ';
7927: END IF;
7928:
7929: IF p_user_in_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
7930: AND NVL(p_user_in_rec.ATTRIBUTE14,'!!!') <> NVL(p_out_rec.ATTRIBUTE14,'!!!')
7931: THEN
7932: l_attributes := l_attributes || 'ATTRIBUTE14, ';
7933: END IF;
7931: THEN
7932: l_attributes := l_attributes || 'ATTRIBUTE14, ';
7933: END IF;
7934:
7935: IF p_user_in_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
7936: AND NVL(p_user_in_rec.ATTRIBUTE15,'!!!') <> NVL(p_out_rec.ATTRIBUTE15,'!!!')
7937: THEN
7938: l_attributes := l_attributes || 'ATTRIBUTE15, ';
7939: END IF;
7940:
7941: /**
7942: -- Bug 3613650 : Need not compare WHO columns
7943: --
7944: IF p_user_in_rec.CREATED_BY <> FND_API.G_MISS_NUM
7945: AND NVL(p_user_in_rec.CREATED_BY,-99) <> NVL(p_out_rec.CREATED_BY,-99)
7946: THEN
7947: l_attributes := l_attributes || 'CREATED_BY, ';
7948: END IF;
7946: THEN
7947: l_attributes := l_attributes || 'CREATED_BY, ';
7948: END IF;
7949:
7950: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE
7951: AND NVL(p_user_in_rec.CREATION_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CREATION_DATE,TO_DATE('2','j'))
7952: THEN
7953: l_attributes := l_attributes || 'CREATION_DATE, ';
7954: END IF;
7952: THEN
7953: l_attributes := l_attributes || 'CREATION_DATE, ';
7954: END IF;
7955:
7956: IF p_user_in_rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE
7957: AND NVL(p_user_in_rec.LAST_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LAST_UPDATE_DATE,TO_DATE('2','j'))
7958: THEN
7959: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
7960: END IF;
7958: THEN
7959: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
7960: END IF;
7961:
7962: IF p_user_in_rec.LAST_UPDATE_LOGIN <> FND_API.G_MISS_NUM
7963: AND NVL(p_user_in_rec.LAST_UPDATE_LOGIN,-99) <> NVL(p_out_rec.LAST_UPDATE_LOGIN,-99)
7964: THEN
7965: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
7966: END IF;
7964: THEN
7965: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
7966: END IF;
7967:
7968: IF p_user_in_rec.LAST_UPDATED_BY <> FND_API.G_MISS_NUM
7969: AND NVL(p_user_in_rec.LAST_UPDATED_BY,-99) <> NVL(p_out_rec.LAST_UPDATED_BY,-99)
7970: THEN
7971: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
7972: END IF;
7970: THEN
7971: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
7972: END IF;
7973:
7974: IF p_user_in_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
7975: AND NVL(p_user_in_rec.PROGRAM_APPLICATION_ID,-99) <> NVL(p_out_rec.PROGRAM_APPLICATION_ID,-99)
7976: THEN
7977: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
7978: END IF;
7976: THEN
7977: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
7978: END IF;
7979:
7980: IF p_user_in_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
7981: AND NVL(p_user_in_rec.PROGRAM_ID,-99) <> NVL(p_out_rec.PROGRAM_ID,-99)
7982: THEN
7983: l_attributes := l_attributes || 'PROGRAM_ID, ';
7984: END IF;
7982: THEN
7983: l_attributes := l_attributes || 'PROGRAM_ID, ';
7984: END IF;
7985:
7986: IF p_user_in_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
7987: AND NVL(p_user_in_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j'))
7988: THEN
7989: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
7990: END IF;
7988: THEN
7989: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
7990: END IF;
7991:
7992: IF p_user_in_rec.REQUEST_ID <> FND_API.G_MISS_NUM
7993: AND NVL(p_user_in_rec.REQUEST_ID,-99) <> NVL(p_out_rec.REQUEST_ID,-99)
7994: THEN
7995: l_attributes := l_attributes || 'REQUEST_ID, ';
7996: END IF;
7995: l_attributes := l_attributes || 'REQUEST_ID, ';
7996: END IF;
7997: **/
7998:
7999: IF p_user_in_rec.MVT_STAT_STATUS <> FND_API.G_MISS_CHAR
8000: AND NVL(p_user_in_rec.MVT_STAT_STATUS,'!!!') <> NVL(p_out_rec.MVT_STAT_STATUS,'!!!')
8001: THEN
8002: l_attributes := l_attributes || 'MVT_STAT_STATUS, ';
8003: END IF;
8001: THEN
8002: l_attributes := l_attributes || 'MVT_STAT_STATUS, ';
8003: END IF;
8004:
8005: IF p_user_in_rec.RELEASED_FLAG <> FND_API.G_MISS_CHAR
8006: AND NVL(p_user_in_rec.RELEASED_FLAG,'!!!') <> NVL(p_out_rec.RELEASED_FLAG,'!!!')
8007: THEN
8008: l_attributes := l_attributes || 'RELEASED_FLAG, ';
8009: END IF;
8007: THEN
8008: l_attributes := l_attributes || 'RELEASED_FLAG, ';
8009: END IF;
8010:
8011: IF p_user_in_rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM
8012: AND NVL(p_user_in_rec.ORGANIZATION_ID,-99) <> NVL(p_out_rec.ORGANIZATION_ID,-99)
8013: THEN
8014: l_attributes := l_attributes || 'ORGANIZATION_ID, ';
8015: END IF;
8013: THEN
8014: l_attributes := l_attributes || 'ORGANIZATION_ID, ';
8015: END IF;
8016:
8017: IF p_user_in_rec.TRANSACTION_TEMP_ID <> FND_API.G_MISS_NUM
8018: AND NVL(p_user_in_rec.TRANSACTION_TEMP_ID,-99) <> NVL(p_out_rec.TRANSACTION_TEMP_ID,-99)
8019: THEN
8020: l_attributes := l_attributes || 'TRANSACTION_TEMP_ID, ';
8021: END IF;
8019: THEN
8020: l_attributes := l_attributes || 'TRANSACTION_TEMP_ID, ';
8021: END IF;
8022:
8023: IF p_user_in_rec.SHIP_SET_ID <> FND_API.G_MISS_NUM
8024: AND NVL(p_user_in_rec.SHIP_SET_ID,-99) <> NVL(p_out_rec.SHIP_SET_ID,-99)
8025: THEN
8026: l_attributes := l_attributes || 'SHIP_SET_ID, ';
8027: END IF;
8025: THEN
8026: l_attributes := l_attributes || 'SHIP_SET_ID, ';
8027: END IF;
8028:
8029: IF p_user_in_rec.ARRIVAL_SET_ID <> FND_API.G_MISS_NUM
8030: AND NVL(p_user_in_rec.ARRIVAL_SET_ID,-99) <> NVL(p_out_rec.ARRIVAL_SET_ID,-99)
8031: THEN
8032: l_attributes := l_attributes || 'ARRIVAL_SET_ID, ';
8033: END IF;
8031: THEN
8032: l_attributes := l_attributes || 'ARRIVAL_SET_ID, ';
8033: END IF;
8034:
8035: IF p_user_in_rec.SHIP_MODEL_COMPLETE_FLAG <> FND_API.G_MISS_CHAR
8036: AND NVL(p_user_in_rec.SHIP_MODEL_COMPLETE_FLAG,'!!!') <> NVL(p_out_rec.SHIP_MODEL_COMPLETE_FLAG,'!!!')
8037: THEN
8038: l_attributes := l_attributes || 'SHIP_MODEL_COMPLETE_FLAG, ';
8039: END IF;
8037: THEN
8038: l_attributes := l_attributes || 'SHIP_MODEL_COMPLETE_FLAG, ';
8039: END IF;
8040:
8041: IF p_user_in_rec.TOP_MODEL_LINE_ID <> FND_API.G_MISS_NUM
8042: AND NVL(p_user_in_rec.TOP_MODEL_LINE_ID,-99) <> NVL(p_out_rec.TOP_MODEL_LINE_ID,-99)
8043: THEN
8044: l_attributes := l_attributes || 'TOP_MODEL_LINE_ID, ';
8045: END IF;
8043: THEN
8044: l_attributes := l_attributes || 'TOP_MODEL_LINE_ID, ';
8045: END IF;
8046:
8047: IF p_user_in_rec.SOURCE_HEADER_NUMBER <> FND_API.G_MISS_CHAR
8048: AND NVL(p_user_in_rec.SOURCE_HEADER_NUMBER,'!!!') <> NVL(p_out_rec.SOURCE_HEADER_NUMBER,'!!!')
8049: THEN
8050: l_attributes := l_attributes || 'SOURCE_HEADER_NUMBER, ';
8051: END IF;
8049: THEN
8050: l_attributes := l_attributes || 'SOURCE_HEADER_NUMBER, ';
8051: END IF;
8052:
8053: IF p_user_in_rec.SOURCE_HEADER_TYPE_ID <> FND_API.G_MISS_NUM
8054: AND NVL(p_user_in_rec.SOURCE_HEADER_TYPE_ID,-99) <> NVL(p_out_rec.SOURCE_HEADER_TYPE_ID,-99)
8055: THEN
8056: l_attributes := l_attributes || 'SOURCE_HEADER_TYPE_ID, ';
8057: END IF;
8055: THEN
8056: l_attributes := l_attributes || 'SOURCE_HEADER_TYPE_ID, ';
8057: END IF;
8058:
8059: IF p_user_in_rec.SOURCE_HEADER_TYPE_NAME <> FND_API.G_MISS_CHAR
8060: AND NVL(p_user_in_rec.SOURCE_HEADER_TYPE_NAME,'!!!') <> NVL(p_out_rec.SOURCE_HEADER_TYPE_NAME,'!!!')
8061: THEN
8062: l_attributes := l_attributes || 'SOURCE_HEADER_TYPE_NAME, ';
8063: END IF;
8061: THEN
8062: l_attributes := l_attributes || 'SOURCE_HEADER_TYPE_NAME, ';
8063: END IF;
8064:
8065: IF p_user_in_rec.CUST_PO_NUMBER <> FND_API.G_MISS_CHAR
8066: AND NVL(p_user_in_rec.CUST_PO_NUMBER,'!!!') <> NVL(p_out_rec.CUST_PO_NUMBER,'!!!')
8067: THEN
8068: l_attributes := l_attributes || 'CUST_PO_NUMBER, ';
8069: END IF;
8067: THEN
8068: l_attributes := l_attributes || 'CUST_PO_NUMBER, ';
8069: END IF;
8070:
8071: IF p_user_in_rec.ATO_LINE_ID <> FND_API.G_MISS_NUM
8072: AND NVL(p_user_in_rec.ATO_LINE_ID,-99) <> NVL(p_out_rec.ATO_LINE_ID,-99)
8073: THEN
8074: l_attributes := l_attributes || 'ATO_LINE_ID, ';
8075: END IF;
8073: THEN
8074: l_attributes := l_attributes || 'ATO_LINE_ID, ';
8075: END IF;
8076:
8077: IF p_user_in_rec.SRC_REQUESTED_QUANTITY <> FND_API.G_MISS_NUM
8078: AND NVL(p_user_in_rec.SRC_REQUESTED_QUANTITY,-99) <> NVL(p_out_rec.SRC_REQUESTED_QUANTITY,-99)
8079: THEN
8080: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY, ';
8081: END IF;
8079: THEN
8080: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY, ';
8081: END IF;
8082:
8083: IF p_user_in_rec.SRC_REQUESTED_QUANTITY_UOM <> FND_API.G_MISS_CHAR
8084: AND NVL(p_user_in_rec.SRC_REQUESTED_QUANTITY_UOM,'!!!') <> NVL(p_out_rec.SRC_REQUESTED_QUANTITY_UOM,'!!!')
8085: THEN
8086: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY_UOM, ';
8087: END IF;
8085: THEN
8086: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY_UOM, ';
8087: END IF;
8088:
8089: IF p_user_in_rec.MOVE_ORDER_LINE_ID <> FND_API.G_MISS_NUM
8090: AND NVL(p_user_in_rec.MOVE_ORDER_LINE_ID,-99) <> NVL(p_out_rec.MOVE_ORDER_LINE_ID,-99)
8091: THEN
8092: l_attributes := l_attributes || 'MOVE_ORDER_LINE_ID, ';
8093: END IF;
8091: THEN
8092: l_attributes := l_attributes || 'MOVE_ORDER_LINE_ID, ';
8093: END IF;
8094: --bug# 6689448 (replenishment project)
8095: IF p_user_in_rec.REPLENISHMENT_STATUS <> FND_API.G_MISS_CHAR
8096: AND NVL(p_user_in_rec.REPLENISHMENT_STATUS,'!!!') <> NVL(p_out_rec.REPLENISHMENT_STATUS,'!!!')
8097: THEN
8098: l_attributes := l_attributes || 'REPLENISHMENT_STATUS, ';
8099: END IF;
8097: THEN
8098: l_attributes := l_attributes || 'REPLENISHMENT_STATUS, ';
8099: END IF;
8100:
8101: IF p_user_in_rec.CANCELLED_QUANTITY <> FND_API.G_MISS_NUM
8102: AND NVL(p_user_in_rec.CANCELLED_QUANTITY,-99) <> NVL(p_out_rec.CANCELLED_QUANTITY,-99)
8103: THEN
8104: l_attributes := l_attributes || 'CANCELLED_QUANTITY, ';
8105: END IF;
8103: THEN
8104: l_attributes := l_attributes || 'CANCELLED_QUANTITY, ';
8105: END IF;
8106:
8107: IF p_user_in_rec.QUALITY_CONTROL_QUANTITY <> FND_API.G_MISS_NUM
8108: AND NVL(p_user_in_rec.QUALITY_CONTROL_QUANTITY,-99) <> NVL(p_out_rec.QUALITY_CONTROL_QUANTITY,-99)
8109: THEN
8110: l_attributes := l_attributes || 'QUALITY_CONTROL_QUANTITY, ';
8111: END IF;
8109: THEN
8110: l_attributes := l_attributes || 'QUALITY_CONTROL_QUANTITY, ';
8111: END IF;
8112:
8113: IF p_user_in_rec.CYCLE_COUNT_QUANTITY <> FND_API.G_MISS_NUM
8114: AND NVL(p_user_in_rec.CYCLE_COUNT_QUANTITY,-99) <> NVL(p_out_rec.CYCLE_COUNT_QUANTITY,-99)
8115: THEN
8116: l_attributes := l_attributes || 'CYCLE_COUNT_QUANTITY, ';
8117: END IF;
8115: THEN
8116: l_attributes := l_attributes || 'CYCLE_COUNT_QUANTITY, ';
8117: END IF;
8118:
8119: IF p_user_in_rec.TRACKING_NUMBER <> FND_API.G_MISS_CHAR
8120: AND NVL(p_user_in_rec.TRACKING_NUMBER,'!!!') <> NVL(p_out_rec.TRACKING_NUMBER,'!!!')
8121: THEN
8122: l_attributes := l_attributes || 'TRACKING_NUMBER, ';
8123: END IF;
8121: THEN
8122: l_attributes := l_attributes || 'TRACKING_NUMBER, ';
8123: END IF;
8124:
8125: IF p_user_in_rec.MOVEMENT_ID <> FND_API.G_MISS_NUM
8126: AND NVL(p_user_in_rec.MOVEMENT_ID,-99) <> NVL(p_out_rec.MOVEMENT_ID,-99)
8127: THEN
8128: l_attributes := l_attributes || 'MOVEMENT_ID, ';
8129: END IF;
8127: THEN
8128: l_attributes := l_attributes || 'MOVEMENT_ID, ';
8129: END IF;
8130:
8131: IF p_user_in_rec.SHIPPING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
8132: AND NVL(p_user_in_rec.SHIPPING_INSTRUCTIONS,'!!!') <> NVL(p_out_rec.SHIPPING_INSTRUCTIONS,'!!!')
8133: THEN
8134: l_attributes := l_attributes || 'SHIPPING_INSTRUCTIONS, ';
8135: END IF;
8133: THEN
8134: l_attributes := l_attributes || 'SHIPPING_INSTRUCTIONS, ';
8135: END IF;
8136:
8137: IF p_user_in_rec.PACKING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
8138: AND NVL(p_user_in_rec.PACKING_INSTRUCTIONS,'!!!') <> NVL(p_out_rec.PACKING_INSTRUCTIONS,'!!!')
8139: THEN
8140: l_attributes := l_attributes || 'PACKING_INSTRUCTIONS, ';
8141: END IF;
8139: THEN
8140: l_attributes := l_attributes || 'PACKING_INSTRUCTIONS, ';
8141: END IF;
8142:
8143: IF p_user_in_rec.PROJECT_ID <> FND_API.G_MISS_NUM
8144: AND NVL(p_user_in_rec.PROJECT_ID,-99) <> NVL(p_out_rec.PROJECT_ID,-99)
8145: THEN
8146: l_attributes := l_attributes || 'PROJECT_ID, ';
8147: END IF;
8145: THEN
8146: l_attributes := l_attributes || 'PROJECT_ID, ';
8147: END IF;
8148:
8149: IF p_user_in_rec.TASK_ID <> FND_API.G_MISS_NUM
8150: AND NVL(p_user_in_rec.TASK_ID,-99) <> NVL(p_out_rec.TASK_ID,-99)
8151: THEN
8152: l_attributes := l_attributes || 'TASK_ID, ';
8153: END IF;
8151: THEN
8152: l_attributes := l_attributes || 'TASK_ID, ';
8153: END IF;
8154:
8155: IF p_user_in_rec.ORG_ID <> FND_API.G_MISS_NUM
8156: AND NVL(p_user_in_rec.ORG_ID,-99) <> NVL(p_out_rec.ORG_ID,-99)
8157: THEN
8158: l_attributes := l_attributes || 'ORG_ID, ';
8159: END IF;
8157: THEN
8158: l_attributes := l_attributes || 'ORG_ID, ';
8159: END IF;
8160:
8161: IF p_user_in_rec.OE_INTERFACED_FLAG <> FND_API.G_MISS_CHAR
8162: AND NVL(p_user_in_rec.OE_INTERFACED_FLAG,'!!!') <> NVL(p_out_rec.OE_INTERFACED_FLAG,'!!!')
8163: THEN
8164: l_attributes := l_attributes || 'OE_INTERFACED_FLAG, ';
8165: END IF;
8163: THEN
8164: l_attributes := l_attributes || 'OE_INTERFACED_FLAG, ';
8165: END IF;
8166:
8167: IF p_user_in_rec.SPLIT_FROM_DETAIL_ID <> FND_API.G_MISS_NUM
8168: AND NVL(p_user_in_rec.SPLIT_FROM_DETAIL_ID,-99) <> NVL(p_out_rec.SPLIT_FROM_DETAIL_ID,-99)
8169: THEN
8170: l_attributes := l_attributes || 'SPLIT_FROM_DETAIL_ID, ';
8171: END IF;
8169: THEN
8170: l_attributes := l_attributes || 'SPLIT_FROM_DETAIL_ID, ';
8171: END IF;
8172:
8173: IF p_user_in_rec.INV_INTERFACED_FLAG <> FND_API.G_MISS_CHAR
8174: AND NVL(p_user_in_rec.INV_INTERFACED_FLAG,'!!!') <> NVL(p_out_rec.INV_INTERFACED_FLAG,'!!!')
8175: THEN
8176: l_attributes := l_attributes || 'INV_INTERFACED_FLAG, ';
8177: END IF;
8175: THEN
8176: l_attributes := l_attributes || 'INV_INTERFACED_FLAG, ';
8177: END IF;
8178:
8179: IF p_user_in_rec.SOURCE_LINE_NUMBER <> FND_API.G_MISS_CHAR
8180: AND NVL(p_user_in_rec.SOURCE_LINE_NUMBER,'!!!') <> NVL(p_out_rec.SOURCE_LINE_NUMBER,'!!!')
8181: THEN
8182: l_attributes := l_attributes || 'SOURCE_LINE_NUMBER, ';
8183: END IF;
8181: THEN
8182: l_attributes := l_attributes || 'SOURCE_LINE_NUMBER, ';
8183: END IF;
8184:
8185: IF p_user_in_rec.INSPECTION_FLAG <> FND_API.G_MISS_CHAR
8186: AND NVL(p_user_in_rec.INSPECTION_FLAG,'!!!') <> NVL(p_out_rec.INSPECTION_FLAG,'!!!')
8187: THEN
8188: l_attributes := l_attributes || 'INSPECTION_FLAG, ';
8189: END IF;
8187: THEN
8188: l_attributes := l_attributes || 'INSPECTION_FLAG, ';
8189: END IF;
8190:
8191: IF p_user_in_rec.RELEASED_STATUS <> FND_API.G_MISS_CHAR
8192: AND NVL(p_user_in_rec.RELEASED_STATUS,'!!!') <> NVL(p_out_rec.RELEASED_STATUS,'!!!')
8193: THEN
8194: l_attributes := l_attributes || 'RELEASED_STATUS, ';
8195: END IF;
8193: THEN
8194: l_attributes := l_attributes || 'RELEASED_STATUS, ';
8195: END IF;
8196:
8197: IF p_user_in_rec.CONTAINER_FLAG <> FND_API.G_MISS_CHAR
8198: AND NVL(p_user_in_rec.CONTAINER_FLAG,'!!!') <> NVL(p_out_rec.CONTAINER_FLAG,'!!!')
8199: THEN
8200: l_attributes := l_attributes || 'CONTAINER_FLAG, ';
8201: END IF;
8199: THEN
8200: l_attributes := l_attributes || 'CONTAINER_FLAG, ';
8201: END IF;
8202:
8203: IF p_user_in_rec.CONTAINER_TYPE_CODE <> FND_API.G_MISS_CHAR
8204: AND NVL(p_user_in_rec.CONTAINER_TYPE_CODE,'!!!') <> NVL(p_out_rec.CONTAINER_TYPE_CODE,'!!!')
8205: THEN
8206: l_attributes := l_attributes || 'CONTAINER_TYPE_CODE, ';
8207: END IF;
8205: THEN
8206: l_attributes := l_attributes || 'CONTAINER_TYPE_CODE, ';
8207: END IF;
8208:
8209: IF p_user_in_rec.CONTAINER_NAME <> FND_API.G_MISS_CHAR
8210: AND NVL(p_user_in_rec.CONTAINER_NAME,'!!!') <> NVL(p_out_rec.CONTAINER_NAME,'!!!')
8211: THEN
8212: l_attributes := l_attributes || 'CONTAINER_NAME, ';
8213: END IF;
8211: THEN
8212: l_attributes := l_attributes || 'CONTAINER_NAME, ';
8213: END IF;
8214:
8215: IF p_user_in_rec.FILL_PERCENT <> FND_API.G_MISS_NUM
8216: AND NVL(p_user_in_rec.FILL_PERCENT,-99) <> NVL(p_out_rec.FILL_PERCENT,-99)
8217: THEN
8218: l_attributes := l_attributes || 'FILL_PERCENT, ';
8219: END IF;
8217: THEN
8218: l_attributes := l_attributes || 'FILL_PERCENT, ';
8219: END IF;
8220:
8221: IF p_user_in_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
8222: AND NVL(p_user_in_rec.GROSS_WEIGHT,-99) <> NVL(p_out_rec.GROSS_WEIGHT,-99)
8223: THEN
8224: l_attributes := l_attributes || 'GROSS_WEIGHT, ';
8225: END IF;
8223: THEN
8224: l_attributes := l_attributes || 'GROSS_WEIGHT, ';
8225: END IF;
8226:
8227: IF p_user_in_rec.MASTER_SERIAL_NUMBER <> FND_API.G_MISS_CHAR
8228: AND NVL(p_user_in_rec.MASTER_SERIAL_NUMBER,'!!!') <> NVL(p_out_rec.MASTER_SERIAL_NUMBER,'!!!')
8229: THEN
8230: l_attributes := l_attributes || 'MASTER_SERIAL_NUMBER, ';
8231: END IF;
8229: THEN
8230: l_attributes := l_attributes || 'MASTER_SERIAL_NUMBER, ';
8231: END IF;
8232:
8233: IF p_user_in_rec.MAXIMUM_LOAD_WEIGHT <> FND_API.G_MISS_NUM
8234: AND NVL(p_user_in_rec.MAXIMUM_LOAD_WEIGHT,-99) <> NVL(p_out_rec.MAXIMUM_LOAD_WEIGHT,-99)
8235: THEN
8236: l_attributes := l_attributes || 'MAXIMUM_LOAD_WEIGHT, ';
8237: END IF;
8235: THEN
8236: l_attributes := l_attributes || 'MAXIMUM_LOAD_WEIGHT, ';
8237: END IF;
8238:
8239: IF p_user_in_rec.MAXIMUM_VOLUME <> FND_API.G_MISS_NUM
8240: AND NVL(p_user_in_rec.MAXIMUM_VOLUME,-99) <> NVL(p_out_rec.MAXIMUM_VOLUME,-99)
8241: THEN
8242: l_attributes := l_attributes || 'MAXIMUM_VOLUME, ';
8243: END IF;
8241: THEN
8242: l_attributes := l_attributes || 'MAXIMUM_VOLUME, ';
8243: END IF;
8244:
8245: IF p_user_in_rec.MINIMUM_FILL_PERCENT <> FND_API.G_MISS_NUM
8246: AND NVL(p_user_in_rec.MINIMUM_FILL_PERCENT,-99) <> NVL(p_out_rec.MINIMUM_FILL_PERCENT,-99)
8247: THEN
8248: l_attributes := l_attributes || 'MINIMUM_FILL_PERCENT, ';
8249: END IF;
8247: THEN
8248: l_attributes := l_attributes || 'MINIMUM_FILL_PERCENT, ';
8249: END IF;
8250:
8251: IF p_user_in_rec.SEAL_CODE <> FND_API.G_MISS_CHAR
8252: AND NVL(p_user_in_rec.SEAL_CODE,'!!!') <> NVL(p_out_rec.SEAL_CODE,'!!!')
8253: THEN
8254: l_attributes := l_attributes || 'SEAL_CODE, ';
8255: END IF;
8253: THEN
8254: l_attributes := l_attributes || 'SEAL_CODE, ';
8255: END IF;
8256:
8257: IF p_user_in_rec.UNIT_NUMBER <> FND_API.G_MISS_CHAR
8258: AND NVL(p_user_in_rec.UNIT_NUMBER,'!!!') <> NVL(p_out_rec.UNIT_NUMBER,'!!!')
8259: THEN
8260: l_attributes := l_attributes || 'UNIT_NUMBER, ';
8261: END IF;
8259: THEN
8260: l_attributes := l_attributes || 'UNIT_NUMBER, ';
8261: END IF;
8262:
8263: IF p_user_in_rec.UNIT_PRICE <> FND_API.G_MISS_NUM
8264: AND NVL(p_user_in_rec.UNIT_PRICE,-99) <> NVL(p_out_rec.UNIT_PRICE,-99)
8265: THEN
8266: l_attributes := l_attributes || 'UNIT_PRICE, ';
8267: END IF;
8265: THEN
8266: l_attributes := l_attributes || 'UNIT_PRICE, ';
8267: END IF;
8268:
8269: IF p_user_in_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR
8270: AND NVL(p_user_in_rec.CURRENCY_CODE,'!!!') <> NVL(p_out_rec.CURRENCY_CODE,'!!!')
8271: THEN
8272: l_attributes := l_attributes || 'CURRENCY_CODE, ';
8273: END IF;
8271: THEN
8272: l_attributes := l_attributes || 'CURRENCY_CODE, ';
8273: END IF;
8274:
8275: IF p_user_in_rec.FREIGHT_CLASS_CAT_ID <> FND_API.G_MISS_NUM
8276: AND NVL(p_user_in_rec.FREIGHT_CLASS_CAT_ID,-99) <> NVL(p_out_rec.FREIGHT_CLASS_CAT_ID,-99)
8277: THEN
8278: l_attributes := l_attributes || 'FREIGHT_CLASS_CAT_ID, ';
8279: END IF;
8277: THEN
8278: l_attributes := l_attributes || 'FREIGHT_CLASS_CAT_ID, ';
8279: END IF;
8280:
8281: IF p_user_in_rec.COMMODITY_CODE_CAT_ID <> FND_API.G_MISS_NUM
8282: AND NVL(p_user_in_rec.COMMODITY_CODE_CAT_ID,-99) <> NVL(p_out_rec.COMMODITY_CODE_CAT_ID,-99)
8283: THEN
8284: l_attributes := l_attributes || 'COMMODITY_CODE_CAT_ID, ';
8285: END IF;
8283: THEN
8284: l_attributes := l_attributes || 'COMMODITY_CODE_CAT_ID, ';
8285: END IF;
8286:
8287: IF p_user_in_rec.PREFERRED_GRADE <> FND_API.G_MISS_CHAR
8288: AND NVL(p_user_in_rec.PREFERRED_GRADE,'!!!') <> NVL(p_out_rec.PREFERRED_GRADE,'!!!')
8289: THEN
8290: l_attributes := l_attributes || 'PREFERRED_GRADE, ';
8291: END IF;
8289: THEN
8290: l_attributes := l_attributes || 'PREFERRED_GRADE, ';
8291: END IF;
8292:
8293: IF p_user_in_rec.SRC_REQUESTED_QUANTITY2 <> FND_API.G_MISS_NUM
8294: AND NVL(p_user_in_rec.SRC_REQUESTED_QUANTITY2,-99) <> NVL(p_out_rec.SRC_REQUESTED_QUANTITY2,-99)
8295: THEN
8296: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY2, ';
8297: END IF;
8295: THEN
8296: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY2, ';
8297: END IF;
8298:
8299: IF p_user_in_rec.SRC_REQUESTED_QUANTITY_UOM2 <> FND_API.G_MISS_CHAR
8300: AND NVL(p_user_in_rec.SRC_REQUESTED_QUANTITY_UOM2,'!!!') <> NVL(p_out_rec.SRC_REQUESTED_QUANTITY_UOM2,'!!!')
8301: THEN
8302: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY_UOM2, ';
8303: END IF;
8301: THEN
8302: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY_UOM2, ';
8303: END IF;
8304:
8305: IF p_user_in_rec.REQUESTED_QUANTITY2 <> FND_API.G_MISS_NUM
8306: AND NVL(p_user_in_rec.REQUESTED_QUANTITY2,-99) <> NVL(p_out_rec.REQUESTED_QUANTITY2,-99)
8307: THEN
8308: l_attributes := l_attributes || 'REQUESTED_QUANTITY2, ';
8309: END IF;
8307: THEN
8308: l_attributes := l_attributes || 'REQUESTED_QUANTITY2, ';
8309: END IF;
8310:
8311: IF p_user_in_rec.SHIPPED_QUANTITY2 <> FND_API.G_MISS_NUM
8312: AND NVL(p_user_in_rec.SHIPPED_QUANTITY2,-99) <> NVL(p_out_rec.SHIPPED_QUANTITY2,-99)
8313: THEN
8314: l_attributes := l_attributes || 'SHIPPED_QUANTITY2, ';
8315: END IF;
8313: THEN
8314: l_attributes := l_attributes || 'SHIPPED_QUANTITY2, ';
8315: END IF;
8316:
8317: IF p_user_in_rec.DELIVERED_QUANTITY2 <> FND_API.G_MISS_NUM
8318: AND NVL(p_user_in_rec.DELIVERED_QUANTITY2,-99) <> NVL(p_out_rec.DELIVERED_QUANTITY2,-99)
8319: THEN
8320: l_attributes := l_attributes || 'DELIVERED_QUANTITY2, ';
8321: END IF;
8319: THEN
8320: l_attributes := l_attributes || 'DELIVERED_QUANTITY2, ';
8321: END IF;
8322:
8323: IF p_user_in_rec.CANCELLED_QUANTITY2 <> FND_API.G_MISS_NUM
8324: AND NVL(p_user_in_rec.CANCELLED_QUANTITY2,-99) <> NVL(p_out_rec.CANCELLED_QUANTITY2,-99)
8325: THEN
8326: l_attributes := l_attributes || 'CANCELLED_QUANTITY2, ';
8327: END IF;
8325: THEN
8326: l_attributes := l_attributes || 'CANCELLED_QUANTITY2, ';
8327: END IF;
8328:
8329: IF p_user_in_rec.QUALITY_CONTROL_QUANTITY2 <> FND_API.G_MISS_NUM
8330: AND NVL(p_user_in_rec.QUALITY_CONTROL_QUANTITY2,-99) <> NVL(p_out_rec.QUALITY_CONTROL_QUANTITY2,-99)
8331: THEN
8332: l_attributes := l_attributes || 'QUALITY_CONTROL_QUANTITY2, ';
8333: END IF;
8331: THEN
8332: l_attributes := l_attributes || 'QUALITY_CONTROL_QUANTITY2, ';
8333: END IF;
8334:
8335: IF p_user_in_rec.CYCLE_COUNT_QUANTITY2 <> FND_API.G_MISS_NUM
8336: AND NVL(p_user_in_rec.CYCLE_COUNT_QUANTITY2,-99) <> NVL(p_out_rec.CYCLE_COUNT_QUANTITY2,-99)
8337: THEN
8338: l_attributes := l_attributes || 'CYCLE_COUNT_QUANTITY2, ';
8339: END IF;
8337: THEN
8338: l_attributes := l_attributes || 'CYCLE_COUNT_QUANTITY2, ';
8339: END IF;
8340:
8341: IF p_user_in_rec.REQUESTED_QUANTITY_UOM2 <> FND_API.G_MISS_CHAR
8342: AND NVL(p_user_in_rec.REQUESTED_QUANTITY_UOM2,'!!!') <> NVL(p_out_rec.REQUESTED_QUANTITY_UOM2,'!!!')
8343: THEN
8344: l_attributes := l_attributes || 'REQUESTED_QUANTITY_UOM2, ';
8345: END IF;
8345: END IF;
8346:
8347: -- HW OPMCONV - No need for sublot_number
8348:
8349: IF p_user_in_rec.LPN_ID <> FND_API.G_MISS_NUM
8350: AND NVL(p_user_in_rec.LPN_ID,-99) <> NVL(p_out_rec.LPN_ID,-99)
8351: THEN
8352: l_attributes := l_attributes || 'LPN_ID, ';
8353: END IF;
8351: THEN
8352: l_attributes := l_attributes || 'LPN_ID, ';
8353: END IF;
8354:
8355: IF p_user_in_rec.PICKABLE_FLAG <> FND_API.G_MISS_CHAR
8356: AND NVL(p_user_in_rec.PICKABLE_FLAG,'!!!') <> NVL(p_out_rec.PICKABLE_FLAG,'!!!')
8357: THEN
8358: l_attributes := l_attributes || 'PICKABLE_FLAG, ';
8359: END IF;
8357: THEN
8358: l_attributes := l_attributes || 'PICKABLE_FLAG, ';
8359: END IF;
8360:
8361: IF p_user_in_rec.ORIGINAL_SUBINVENTORY <> FND_API.G_MISS_CHAR
8362: AND NVL(p_user_in_rec.ORIGINAL_SUBINVENTORY,'!!!') <> NVL(p_out_rec.ORIGINAL_SUBINVENTORY,'!!!')
8363: THEN
8364: l_attributes := l_attributes || 'ORIGINAL_SUBINVENTORY, ';
8365: END IF;
8363: THEN
8364: l_attributes := l_attributes || 'ORIGINAL_SUBINVENTORY, ';
8365: END IF;
8366:
8367: IF p_user_in_rec.TO_SERIAL_NUMBER <> FND_API.G_MISS_CHAR
8368: AND NVL(p_user_in_rec.TO_SERIAL_NUMBER,'!!!') <> NVL(p_out_rec.TO_SERIAL_NUMBER,'!!!')
8369: THEN
8370: l_attributes := l_attributes || 'TO_SERIAL_NUMBER, ';
8371: END IF;
8369: THEN
8370: l_attributes := l_attributes || 'TO_SERIAL_NUMBER, ';
8371: END IF;
8372:
8373: IF p_user_in_rec.PICKED_QUANTITY <> FND_API.G_MISS_NUM
8374: AND NVL(p_user_in_rec.PICKED_QUANTITY,-99) <> NVL(p_out_rec.PICKED_QUANTITY,-99)
8375: THEN
8376: l_attributes := l_attributes || 'PICKED_QUANTITY, ';
8377: END IF;
8375: THEN
8376: l_attributes := l_attributes || 'PICKED_QUANTITY, ';
8377: END IF;
8378:
8379: IF p_user_in_rec.PICKED_QUANTITY2 <> FND_API.G_MISS_NUM
8380: AND NVL(p_user_in_rec.PICKED_QUANTITY2,-99) <> NVL(p_out_rec.PICKED_QUANTITY2,-99)
8381: THEN
8382: l_attributes := l_attributes || 'PICKED_QUANTITY2, ';
8383: END IF;
8381: THEN
8382: l_attributes := l_attributes || 'PICKED_QUANTITY2, ';
8383: END IF;
8384:
8385: IF p_user_in_rec.RECEIVED_QUANTITY <> FND_API.G_MISS_NUM
8386: AND NVL(p_user_in_rec.RECEIVED_QUANTITY,-99) <> NVL(p_out_rec.RECEIVED_QUANTITY,-99)
8387: THEN
8388: l_attributes := l_attributes || 'RECEIVED_QUANTITY, ';
8389: END IF;
8387: THEN
8388: l_attributes := l_attributes || 'RECEIVED_QUANTITY, ';
8389: END IF;
8390:
8391: IF p_user_in_rec.RECEIVED_QUANTITY2 <> FND_API.G_MISS_NUM
8392: AND NVL(p_user_in_rec.RECEIVED_QUANTITY2,-99) <> NVL(p_out_rec.RECEIVED_QUANTITY2,-99)
8393: THEN
8394: l_attributes := l_attributes || 'RECEIVED_QUANTITY2, ';
8395: END IF;
8393: THEN
8394: l_attributes := l_attributes || 'RECEIVED_QUANTITY2, ';
8395: END IF;
8396:
8397: IF p_user_in_rec.SOURCE_LINE_SET_ID <> FND_API.G_MISS_NUM
8398: AND NVL(p_user_in_rec.SOURCE_LINE_SET_ID,-99) <> NVL(p_out_rec.SOURCE_LINE_SET_ID,-99)
8399: THEN
8400: l_attributes := l_attributes || 'SOURCE_LINE_SET_ID, ';
8401: END IF;
8399: THEN
8400: l_attributes := l_attributes || 'SOURCE_LINE_SET_ID, ';
8401: END IF;
8402:
8403: IF p_user_in_rec.BATCH_ID <> FND_API.G_MISS_NUM
8404: AND NVL(p_user_in_rec.BATCH_ID,-99) <> NVL(p_out_rec.BATCH_ID,-99)
8405: THEN
8406: l_attributes := l_attributes || 'BATCH_ID, ';
8407: END IF;
8405: THEN
8406: l_attributes := l_attributes || 'BATCH_ID, ';
8407: END IF;
8408:
8409: IF p_user_in_rec.ROWID <> FND_API.G_MISS_CHAR
8410: AND NVL(p_user_in_rec.ROWID,'!!!') <> NVL(p_out_rec.ROWID,'!!!')
8411: THEN
8412: l_attributes := l_attributes || 'ROWID, ';
8413: END IF;
8411: THEN
8412: l_attributes := l_attributes || 'ROWID, ';
8413: END IF;
8414:
8415: IF p_user_in_rec.TRANSACTION_ID <> FND_API.G_MISS_NUM
8416: AND NVL(p_user_in_rec.TRANSACTION_ID,-99) <> NVL(p_out_rec.TRANSACTION_ID,-99)
8417: THEN
8418: l_attributes := l_attributes || 'TRANSACTION_ID, ';
8419: END IF;
8417: THEN
8418: l_attributes := l_attributes || 'TRANSACTION_ID, ';
8419: END IF;
8420:
8421: IF p_user_in_rec.VENDOR_ID <> FND_API.G_MISS_NUM
8422: AND NVL(p_user_in_rec.VENDOR_ID,-99) <> NVL(p_out_rec.VENDOR_ID,-99)
8423: THEN
8424: l_attributes := l_attributes || 'VENDOR_ID, ';
8425: END IF;
8423: THEN
8424: l_attributes := l_attributes || 'VENDOR_ID, ';
8425: END IF;
8426:
8427: IF p_user_in_rec.SHIP_FROM_SITE_ID <> FND_API.G_MISS_NUM
8428: AND NVL(p_user_in_rec.SHIP_FROM_SITE_ID,-99) <> NVL(p_out_rec.SHIP_FROM_SITE_ID,-99)
8429: THEN
8430: l_attributes := l_attributes || 'SHIP_FROM_SITE_ID, ';
8431: END IF;
8429: THEN
8430: l_attributes := l_attributes || 'SHIP_FROM_SITE_ID, ';
8431: END IF;
8432:
8433: IF p_user_in_rec.LINE_DIRECTION <> FND_API.G_MISS_CHAR
8434: AND NVL(p_user_in_rec.LINE_DIRECTION,'!!!') <> NVL(p_out_rec.LINE_DIRECTION,'!!!')
8435: THEN
8436: l_attributes := l_attributes || 'LINE_DIRECTION, ';
8437: END IF;
8435: THEN
8436: l_attributes := l_attributes || 'LINE_DIRECTION, ';
8437: END IF;
8438:
8439: IF p_user_in_rec.PARTY_ID <> FND_API.G_MISS_NUM
8440: AND NVL(p_user_in_rec.PARTY_ID,-99) <> NVL(p_out_rec.PARTY_ID,-99)
8441: THEN
8442: l_attributes := l_attributes || 'PARTY_ID, ';
8443: END IF;
8441: THEN
8442: l_attributes := l_attributes || 'PARTY_ID, ';
8443: END IF;
8444:
8445: IF p_user_in_rec.ROUTING_REQ_ID <> FND_API.G_MISS_NUM
8446: AND NVL(p_user_in_rec.ROUTING_REQ_ID,-99) <> NVL(p_out_rec.ROUTING_REQ_ID,-99)
8447: THEN
8448: l_attributes := l_attributes || 'ROUTING_REQ_ID, ';
8449: END IF;
8447: THEN
8448: l_attributes := l_attributes || 'ROUTING_REQ_ID, ';
8449: END IF;
8450:
8451: IF p_user_in_rec.SHIPPING_CONTROL <> FND_API.G_MISS_CHAR
8452: AND NVL(p_user_in_rec.SHIPPING_CONTROL,'!!!') <> NVL(p_out_rec.SHIPPING_CONTROL,'!!!')
8453: THEN
8454: l_attributes := l_attributes || 'SHIPPING_CONTROL, ';
8455: END IF;
8453: THEN
8454: l_attributes := l_attributes || 'SHIPPING_CONTROL, ';
8455: END IF;
8456:
8457: IF p_user_in_rec.SOURCE_BLANKET_REFERENCE_ID <> FND_API.G_MISS_NUM
8458: AND NVL(p_user_in_rec.SOURCE_BLANKET_REFERENCE_ID,-99) <> NVL(p_out_rec.SOURCE_BLANKET_REFERENCE_ID,-99)
8459: THEN
8460: l_attributes := l_attributes || 'SOURCE_BLANKET_REFERENCE_ID, ';
8461: END IF;
8459: THEN
8460: l_attributes := l_attributes || 'SOURCE_BLANKET_REFERENCE_ID, ';
8461: END IF;
8462:
8463: IF p_user_in_rec.SOURCE_BLANKET_REFERENCE_NUM <> FND_API.G_MISS_NUM
8464: AND NVL(p_user_in_rec.SOURCE_BLANKET_REFERENCE_NUM,-99) <> NVL(p_out_rec.SOURCE_BLANKET_REFERENCE_NUM,-99)
8465: THEN
8466: l_attributes := l_attributes || 'SOURCE_BLANKET_REFERENCE_NUM, ';
8467: END IF;
8465: THEN
8466: l_attributes := l_attributes || 'SOURCE_BLANKET_REFERENCE_NUM, ';
8467: END IF;
8468:
8469: IF p_user_in_rec.PO_SHIPMENT_LINE_ID <> FND_API.G_MISS_NUM
8470: AND NVL(p_user_in_rec.PO_SHIPMENT_LINE_ID,-99) <> NVL(p_out_rec.PO_SHIPMENT_LINE_ID,-99)
8471: THEN
8472: l_attributes := l_attributes || 'PO_SHIPMENT_LINE_ID, ';
8473: END IF;
8471: THEN
8472: l_attributes := l_attributes || 'PO_SHIPMENT_LINE_ID, ';
8473: END IF;
8474:
8475: IF p_user_in_rec.PO_SHIPMENT_LINE_NUMBER <> FND_API.G_MISS_NUM
8476: AND NVL(p_user_in_rec.PO_SHIPMENT_LINE_NUMBER,-99) <> NVL(p_out_rec.PO_SHIPMENT_LINE_NUMBER,-99)
8477: THEN
8478: l_attributes := l_attributes || 'PO_SHIPMENT_LINE_NUMBER, ';
8479: END IF;
8477: THEN
8478: l_attributes := l_attributes || 'PO_SHIPMENT_LINE_NUMBER, ';
8479: END IF;
8480:
8481: IF p_user_in_rec.RETURNED_QUANTITY <> FND_API.G_MISS_NUM
8482: AND NVL(p_user_in_rec.RETURNED_QUANTITY,-99) <> NVL(p_out_rec.RETURNED_QUANTITY,-99)
8483: THEN
8484: l_attributes := l_attributes || 'RETURNED_QUANTITY, ';
8485: END IF;
8483: THEN
8484: l_attributes := l_attributes || 'RETURNED_QUANTITY, ';
8485: END IF;
8486:
8487: IF p_user_in_rec.RETURNED_QUANTITY2 <> FND_API.G_MISS_NUM
8488: AND NVL(p_user_in_rec.RETURNED_QUANTITY2,-99) <> NVL(p_out_rec.RETURNED_QUANTITY2,-99)
8489: THEN
8490: l_attributes := l_attributes || 'RETURNED_QUANTITY2, ';
8491: END IF;
8489: THEN
8490: l_attributes := l_attributes || 'RETURNED_QUANTITY2, ';
8491: END IF;
8492:
8493: IF p_user_in_rec.RCV_SHIPMENT_LINE_ID <> FND_API.G_MISS_NUM
8494: AND NVL(p_user_in_rec.RCV_SHIPMENT_LINE_ID,-99) <> NVL(p_out_rec.RCV_SHIPMENT_LINE_ID,-99)
8495: THEN
8496: l_attributes := l_attributes || 'RCV_SHIPMENT_LINE_ID, ';
8497: END IF;
8495: THEN
8496: l_attributes := l_attributes || 'RCV_SHIPMENT_LINE_ID, ';
8497: END IF;
8498:
8499: IF p_user_in_rec.SOURCE_LINE_TYPE_CODE <> FND_API.G_MISS_CHAR
8500: AND NVL(p_user_in_rec.SOURCE_LINE_TYPE_CODE,'!!!') <> NVL(p_out_rec.SOURCE_LINE_TYPE_CODE,'!!!')
8501: THEN
8502: l_attributes := l_attributes || 'SOURCE_LINE_TYPE_CODE, ';
8503: END IF;
8501: THEN
8502: l_attributes := l_attributes || 'SOURCE_LINE_TYPE_CODE, ';
8503: END IF;
8504:
8505: IF p_user_in_rec.SUPPLIER_ITEM_NUMBER <> FND_API.G_MISS_CHAR
8506: AND NVL(p_user_in_rec.SUPPLIER_ITEM_NUMBER,'!!!') <> NVL(p_out_rec.SUPPLIER_ITEM_NUMBER,'!!!')
8507: THEN
8508: l_attributes := l_attributes || 'SUPPLIER_ITEM_NUMBER, ';
8509: END IF;
8507: THEN
8508: l_attributes := l_attributes || 'SUPPLIER_ITEM_NUMBER, ';
8509: END IF;
8510:
8511: IF p_user_in_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR
8512: AND NVL(p_user_in_rec.IGNORE_FOR_PLANNING,'!!!') <> NVL(p_out_rec.IGNORE_FOR_PLANNING,'!!!')
8513: THEN
8514: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING, ';
8515: END IF;
8513: THEN
8514: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING, ';
8515: END IF;
8516:
8517: IF p_user_in_rec.EARLIEST_PICKUP_DATE <> FND_API.G_MISS_DATE
8518: AND NVL(p_user_in_rec.EARLIEST_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.EARLIEST_PICKUP_DATE,TO_DATE('2','j'))
8519: THEN
8520: l_attributes := l_attributes || 'EARLIEST_PICKUP_DATE, ';
8521: END IF;
8519: THEN
8520: l_attributes := l_attributes || 'EARLIEST_PICKUP_DATE, ';
8521: END IF;
8522:
8523: IF p_user_in_rec.LATEST_PICKUP_DATE <> FND_API.G_MISS_DATE
8524: AND NVL(p_user_in_rec.LATEST_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LATEST_PICKUP_DATE,TO_DATE('2','j'))
8525: THEN
8526: l_attributes := l_attributes || 'LATEST_PICKUP_DATE, ';
8527: END IF;
8525: THEN
8526: l_attributes := l_attributes || 'LATEST_PICKUP_DATE, ';
8527: END IF;
8528:
8529: IF p_user_in_rec.EARLIEST_DROPOFF_DATE <> FND_API.G_MISS_DATE
8530: AND NVL(p_user_in_rec.EARLIEST_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.EARLIEST_DROPOFF_DATE,TO_DATE('2','j'))
8531: THEN
8532: l_attributes := l_attributes || 'EARLIEST_DROPOFF_DATE, ';
8533: END IF;
8531: THEN
8532: l_attributes := l_attributes || 'EARLIEST_DROPOFF_DATE, ';
8533: END IF;
8534:
8535: IF p_user_in_rec.LATEST_DROPOFF_DATE <> FND_API.G_MISS_DATE
8536: AND NVL(p_user_in_rec.LATEST_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LATEST_DROPOFF_DATE,TO_DATE('2','j'))
8537: THEN
8538: l_attributes := l_attributes || 'LATEST_DROPOFF_DATE, ';
8539: END IF;
8537: THEN
8538: l_attributes := l_attributes || 'LATEST_DROPOFF_DATE, ';
8539: END IF;
8540:
8541: IF p_user_in_rec.REQUEST_DATE_TYPE_CODE <> FND_API.G_MISS_CHAR
8542: AND NVL(p_user_in_rec.REQUEST_DATE_TYPE_CODE,'!!!') <> NVL(p_out_rec.REQUEST_DATE_TYPE_CODE,'!!!')
8543: THEN
8544: l_attributes := l_attributes || 'REQUEST_DATE_TYPE_CODE, ';
8545: END IF;
8543: THEN
8544: l_attributes := l_attributes || 'REQUEST_DATE_TYPE_CODE, ';
8545: END IF;
8546:
8547: IF p_user_in_rec.TP_DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM
8548: AND NVL(p_user_in_rec.TP_DELIVERY_DETAIL_ID,-99) <> NVL(p_out_rec.TP_DELIVERY_DETAIL_ID,-99)
8549: THEN
8550: l_attributes := l_attributes || 'TP_DELIVERY_DETAIL_ID, ';
8551: END IF;
8549: THEN
8550: l_attributes := l_attributes || 'TP_DELIVERY_DETAIL_ID, ';
8551: END IF;
8552:
8553: IF p_user_in_rec.SOURCE_DOCUMENT_TYPE_ID <> FND_API.G_MISS_NUM
8554: AND NVL(p_user_in_rec.SOURCE_DOCUMENT_TYPE_ID,-99) <> NVL(p_out_rec.SOURCE_DOCUMENT_TYPE_ID,-99)
8555: THEN
8556: l_attributes := l_attributes || 'SOURCE_DOCUMENT_TYPE_ID, ';
8557: END IF;
8555: THEN
8556: l_attributes := l_attributes || 'SOURCE_DOCUMENT_TYPE_ID, ';
8557: END IF;
8558:
8559: IF p_user_in_rec.UNIT_WEIGHT <> FND_API.G_MISS_NUM
8560: AND NVL(p_user_in_rec.UNIT_WEIGHT,-99) <> NVL(p_out_rec.UNIT_WEIGHT,-99)
8561: THEN
8562: l_attributes := l_attributes || 'UNIT_WEIGHT, ';
8563: END IF;
8561: THEN
8562: l_attributes := l_attributes || 'UNIT_WEIGHT, ';
8563: END IF;
8564:
8565: IF p_user_in_rec.UNIT_VOLUME <> FND_API.G_MISS_NUM
8566: AND NVL(p_user_in_rec.UNIT_VOLUME,-99) <> NVL(p_out_rec.UNIT_VOLUME,-99)
8567: THEN
8568: l_attributes := l_attributes || 'UNIT_VOLUME, ';
8569: END IF;
8567: THEN
8568: l_attributes := l_attributes || 'UNIT_VOLUME, ';
8569: END IF;
8570:
8571: IF p_user_in_rec.FILLED_VOLUME <> FND_API.G_MISS_NUM
8572: AND NVL(p_user_in_rec.FILLED_VOLUME,-99) <> NVL(p_out_rec.FILLED_VOLUME,-99)
8573: THEN
8574: l_attributes := l_attributes || 'FILLED_VOLUME, ';
8575: END IF;
8573: THEN
8574: l_attributes := l_attributes || 'FILLED_VOLUME, ';
8575: END IF;
8576:
8577: IF p_user_in_rec.WV_FROZEN_FLAG <> FND_API.G_MISS_CHAR
8578: AND NVL(p_user_in_rec.WV_FROZEN_FLAG,'!!!') <> NVL(p_out_rec.WV_FROZEN_FLAG,'!!!')
8579: THEN
8580: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
8581: END IF;
8579: THEN
8580: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
8581: END IF;
8582:
8583: IF p_user_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
8584: AND NVL(p_user_in_rec.MODE_OF_TRANSPORT,'!!!') <> NVL(p_out_rec.MODE_OF_TRANSPORT,'!!!')
8585: THEN
8586: l_attributes := l_attributes || 'MODE_OF_TRANSPORT, ';
8587: END IF;
8585: THEN
8586: l_attributes := l_attributes || 'MODE_OF_TRANSPORT, ';
8587: END IF;
8588:
8589: IF p_user_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
8590: AND NVL(p_user_in_rec.SERVICE_LEVEL,'!!!') <> NVL(p_out_rec.SERVICE_LEVEL,'!!!')
8591: THEN
8592: l_attributes := l_attributes || 'SERVICE_LEVEL, ';
8593: END IF;
8591: THEN
8592: l_attributes := l_attributes || 'SERVICE_LEVEL, ';
8593: END IF;
8594:
8595: IF p_user_in_rec.PO_REVISION_NUMBER <> FND_API.G_MISS_NUM
8596: AND NVL(p_user_in_rec.PO_REVISION_NUMBER,-99) <> NVL(p_out_rec.PO_REVISION_NUMBER,-99)
8597: THEN
8598: l_attributes := l_attributes || 'PO_REVISION_NUMBER, ';
8599: END IF;
8597: THEN
8598: l_attributes := l_attributes || 'PO_REVISION_NUMBER, ';
8599: END IF;
8600:
8601: IF p_user_in_rec.RELEASE_REVISION_NUMBER <> FND_API.G_MISS_NUM
8602: AND NVL(p_user_in_rec.RELEASE_REVISION_NUMBER,-99) <> NVL(p_out_rec.RELEASE_REVISION_NUMBER,-99)
8603: THEN
8604: l_attributes := l_attributes || 'RELEASE_REVISION_NUMBER, ';
8605: END IF;