[Home] [Help]
1112: -- p_source_header_id - optional
1113: -- p_init_flag - 'Y' initializes the table of bad header ids
1114: -- x_return_status
1115: -- Description: Checks if there are any credit checks or holds on a line.
1116: -- Returns a status of FND_API.G_RET_STS_SUCCESS if no such
1117: -- checks or holds exist
1118: --
1119: -----------------------------------------------------------------------------
1120:
1368: p_msg_count => l_msg_count,
1369: p_msg_data => l_msg_data,
1370: p_return_status => x_return_status);
1371:
1372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1373: g_bad_header_ids(l_bad_index) := l_header_id;
1374: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1375: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1376: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1406: x_msg_data => l_msg_data);
1407:
1408: -- If hold is found return back
1409:
1410: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_result_out = FND_API.G_TRUE) THEN
1411: g_bad_header_ids(l_bad_index) := l_header_id;
1412: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1413: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1414: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1539: x_return_status => x_return_status,
1540: x_msg_count => l_msg_count,
1541: x_msg_data => l_msg_data);
1542:
1543: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_result_out = FND_API.G_TRUE) THEN
1544: --
1545: -- Debug Statements
1546: --
1547: IF l_debug_on THEN
1986: WSH_DEBUG_SV.log(l_module_name,'Min Qty'||l_min_quantity);
1987: WSH_DEBUG_SV.log(l_module_name,'Qty UOM'||l_quantity_uom);
1988: END IF;
1989:
1990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1991: raise others ;
1992: END IF;
1993:
1994:
2453: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2454: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
2455: END IF;
2456: --
2457: x_return_status := FND_API.G_RET_STS_SUCCESS;
2458: -- clear the disabled list first
2459: x_disabled_list.delete;
2460: -- OPM 09/11/00
2461: OPEN dd_info;
2894: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
2895: END IF;
2896:
2897: WHEN wsh_dp_no_entity THEN
2898: x_return_status := FND_API.G_RET_STS_ERROR;
2899: -- Bug fix 2650464
2900: -- new message for invalid delivery details
2901: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_NOT_EXIST');
2902: IF p_delivery_detail_id = FND_API.G_MISS_NUM THEN
2898: x_return_status := FND_API.G_RET_STS_ERROR;
2899: -- Bug fix 2650464
2900: -- new message for invalid delivery details
2901: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_NOT_EXIST');
2902: IF p_delivery_detail_id = FND_API.G_MISS_NUM THEN
2903: l_delivery_detail_id := NULL;
2904: ELSE
2905: l_delivery_detail_id := p_delivery_detail_id;
2906: END IF;
2921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
2922: END IF;
2923: --
2924: WHEN wsh_del_not_exist THEN -- Bug fix 2650464
2925: x_return_status := FND_API.G_RET_STS_ERROR;
2926: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELIVERY_NOT_EXIST');
2927: IF p_delivery_id = FND_API.G_MISS_NUM THEN
2928: l_delivery_id := NULL;
2929: ELSE
2923: --
2924: WHEN wsh_del_not_exist THEN -- Bug fix 2650464
2925: x_return_status := FND_API.G_RET_STS_ERROR;
2926: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELIVERY_NOT_EXIST');
2927: IF p_delivery_id = FND_API.G_MISS_NUM THEN
2928: l_delivery_id := NULL;
2929: ELSE
2930: l_delivery_id := p_delivery_id;
2931: END IF;
2943: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
2944: END IF;
2945:
2946: WHEN wsh_inv_list_type THEN
2947: x_return_status := FND_API.G_RET_STS_ERROR;
2948: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
2949: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2950: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2951: IF x_msg_count > 1 then
3186: THEN
3187: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3188: END IF;
3189: --
3190: x_return_status := FND_API.G_RET_STS_SUCCESS;
3191:
3192: l_del_shipping_quantity := 0;
3193: l_del_shipping_quantity2 := 0;
3194:
3204:
3205: IF ( p_in_attributes.source_code IS NULL ) THEN
3206: x_msg_count := 1;
3207: x_msg_data := 'INVALID SOURCE_CODE';
3208: x_return_status := FND_API.G_RET_STS_ERROR;
3209: END IF;
3210:
3211: IF p_in_attributes.ship_tolerance_above IS NULL OR
3212: p_in_attributes.action_flag IN ('C', 'I') THEN
3694: IF l_debug_on THEN
3695: wsh_debug_sv.log(l_module_name, 'Return status after wsh_util_validate.get_org_type', l_return_status);
3696: END IF;
3697: IF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
3698: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = wsh_util_core.g_ret_sts_error THEN
3700: raise e_record_ineligible;
3701: exit;
3702: END IF;
3890: WSH_DEBUG_SV.log(l_module_name, 'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
3891: END IF;
3892: --
3893:
3894: IF nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TW2' THEN
3895: --
3896: IF l_debug_on THEN
3897: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Cannot perform action Auto-create Deliveries/Assign to Delivery in Distributed Enabled Organization');
3898: END IF;
3923: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
3924: END IF;
3925:
3926: -- TPW - Distributed Organization Changes
3927: --IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
3928: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ( 'TPW', 'TW2' ) ) THEN
3929: IF ( p_del_detail_rec_tab(j).source_code = 'WSH' and p_del_detail_rec_tab(j).container_flag = 'N' ) THEN
3930: x_valid_ids(x_valid_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
3931: x_valid_index_tab(j) := j;
3924: END IF;
3925:
3926: -- TPW - Distributed Organization Changes
3927: --IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TPW' ) THEN
3928: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ( 'TPW', 'TW2' ) ) THEN
3929: IF ( p_del_detail_rec_tab(j).source_code = 'WSH' and p_del_detail_rec_tab(j).container_flag = 'N' ) THEN
3930: x_valid_ids(x_valid_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
3931: x_valid_index_tab(j) := j;
3932: ELSE
4141: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type l_wh_type,l_return_status',l_wh_type||l_return_status);
4142: END IF;
4143:
4144: -- TPW - Distributed Organization Changes
4145: --IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ('CMS','TPW')) THEN
4146: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ('CMS','TPW','TW2')) THEN
4147: IF (p_del_detail_rec_tab(j).source_code = 'WSH' and p_del_detail_rec_tab(j).container_flag = 'N' ) THEN
4148: x_valid_ids(x_valid_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
4149: x_valid_index_tab(j) := j;
4142: END IF;
4143:
4144: -- TPW - Distributed Organization Changes
4145: --IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ('CMS','TPW')) THEN
4146: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) in ('CMS','TPW','TW2')) THEN
4147: IF (p_del_detail_rec_tab(j).source_code = 'WSH' and p_del_detail_rec_tab(j).container_flag = 'N' ) THEN
4148: x_valid_ids(x_valid_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
4149: x_valid_index_tab(j) := j;
4150: ELSE
4178: IF l_debug_on THEN
4179: wsh_debug_sv.log(l_module_name, 'Error Id', p_del_detail_rec_tab(j).delivery_detail_id);
4180: END IF;
4181: x_error_ids(x_error_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
4182: IF nvl(p_caller, FND_API.G_MISS_CHAR) = 'WSH_PUB'
4183: OR p_caller like 'FTE%' THEN
4184: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_ACTION_INELIGIBLE');
4185: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_del_detail_rec_tab(j).delivery_detail_id);
4186: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('DLVB',p_action));
4194: IF l_debug_on THEN
4195: wsh_debug_sv.log(l_module_name, 'Error Id', p_del_detail_rec_tab(j).delivery_detail_id);
4196: END IF;
4197: x_error_ids(x_error_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
4198: IF nvl(p_caller, FND_API.G_MISS_CHAR) = 'WSH_PUB'
4199: OR p_caller like 'FTE%' THEN
4200: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_ACTION_INELIGIBLE');
4201: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_del_detail_rec_tab(j).delivery_detail_id);
4202: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('DLVB',p_action));
4210: IF l_debug_on THEN
4211: wsh_debug_sv.log(l_module_name, 'Error Id', p_del_detail_rec_tab(j).delivery_detail_id);
4212: END IF;
4213: x_error_ids(x_error_ids.COUNT + 1) := p_del_detail_rec_tab(j).delivery_detail_id;
4214: IF nvl(p_caller, FND_API.G_MISS_CHAR) = 'WSH_PUB'
4215: OR p_caller like 'FTE%' THEN
4216: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_ASSIGN_FIRMDEL_ERROR');
4217: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_del_detail_rec_tab(j).delivery_detail_id);
4218: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_deliveryid));
4222: WHEN others THEN
4223: IF det_to_del_cur%ISOPEN THEN
4224: CLOSE det_to_del_cur;
4225: END IF;
4226: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4227: END; -- Local BEGIN
4228:
4229: END LOOP;
4230:
4266: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4267: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
4268: END IF;
4269:
4270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4272: wsh_util_core.add_message(x_return_status, l_module_name);
4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4267: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
4268: END IF;
4269:
4270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4272: wsh_util_core.add_message(x_return_status, l_module_name);
4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4272: wsh_util_core.add_message(x_return_status, l_module_name);
4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4276: END IF;
4277: IF c_staged_content%ISOPEN THEN
4278: CLOSE c_staged_content;
4271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4272: wsh_util_core.add_message(x_return_status, l_module_name);
4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4276: END IF;
4277: IF c_staged_content%ISOPEN THEN
4278: CLOSE c_staged_content;
4279: END IF;
4319: permanently disabled.
4320: */
4321:
4322: --
4323: IF p_delivery_detail_rec.container_name <> FND_API.G_MISS_CHAR
4324: OR p_delivery_detail_rec.container_name IS NULL THEN
4325: x_delivery_detail_rec.container_name :=
4326: p_delivery_detail_rec.container_name;
4327: END IF;
4324: OR p_delivery_detail_rec.container_name IS NULL THEN
4325: x_delivery_detail_rec.container_name :=
4326: p_delivery_detail_rec.container_name;
4327: END IF;
4328: IF p_delivery_detail_rec.shipped_quantity <> FND_API.G_MISS_NUM
4329: OR p_delivery_detail_rec.shipped_quantity IS NULL THEN
4330: x_delivery_detail_rec.shipped_quantity :=
4331: p_delivery_detail_rec.shipped_quantity;
4332: END IF;
4329: OR p_delivery_detail_rec.shipped_quantity IS NULL THEN
4330: x_delivery_detail_rec.shipped_quantity :=
4331: p_delivery_detail_rec.shipped_quantity;
4332: END IF;
4333: IF p_delivery_detail_rec.shipped_quantity2 <> FND_API.G_MISS_NUM
4334: OR p_delivery_detail_rec.shipped_quantity2 IS NULL THEN
4335: x_delivery_detail_rec.shipped_quantity2 :=
4336: p_delivery_detail_rec.shipped_quantity2;
4337: END IF;
4334: OR p_delivery_detail_rec.shipped_quantity2 IS NULL THEN
4335: x_delivery_detail_rec.shipped_quantity2 :=
4336: p_delivery_detail_rec.shipped_quantity2;
4337: END IF;
4338: IF p_delivery_detail_rec.cycle_count_quantity <> FND_API.G_MISS_NUM
4339: OR p_delivery_detail_rec.cycle_count_quantity IS NULL THEN
4340: x_delivery_detail_rec.cycle_count_quantity :=
4341: p_delivery_detail_rec.cycle_count_quantity;
4342: END IF;
4339: OR p_delivery_detail_rec.cycle_count_quantity IS NULL THEN
4340: x_delivery_detail_rec.cycle_count_quantity :=
4341: p_delivery_detail_rec.cycle_count_quantity;
4342: END IF;
4343: IF p_delivery_detail_rec.cycle_count_quantity2 <> FND_API.G_MISS_NUM
4344: OR p_delivery_detail_rec.cycle_count_quantity2 IS NULL THEN
4345: x_delivery_detail_rec.cycle_count_quantity2 :=
4346: p_delivery_detail_rec.cycle_count_quantity2;
4347: END IF;
4344: OR p_delivery_detail_rec.cycle_count_quantity2 IS NULL THEN
4345: x_delivery_detail_rec.cycle_count_quantity2 :=
4346: p_delivery_detail_rec.cycle_count_quantity2;
4347: END IF;
4348: IF p_delivery_detail_rec.delivered_quantity <> FND_API.G_MISS_NUM
4349: OR p_delivery_detail_rec.delivered_quantity IS NULL THEN
4350: x_delivery_detail_rec.delivered_quantity :=
4351: p_delivery_detail_rec.delivered_quantity;
4352: END IF;
4349: OR p_delivery_detail_rec.delivered_quantity IS NULL THEN
4350: x_delivery_detail_rec.delivered_quantity :=
4351: p_delivery_detail_rec.delivered_quantity;
4352: END IF;
4353: IF p_delivery_detail_rec.delivered_quantity2 <> FND_API.G_MISS_NUM
4354: OR p_delivery_detail_rec.delivered_quantity2 IS NULL THEN
4355: x_delivery_detail_rec.delivered_quantity2 :=
4356: p_delivery_detail_rec.delivered_quantity2;
4357: END IF;
4354: OR p_delivery_detail_rec.delivered_quantity2 IS NULL THEN
4355: x_delivery_detail_rec.delivered_quantity2 :=
4356: p_delivery_detail_rec.delivered_quantity2;
4357: END IF;
4358: IF p_delivery_detail_rec.cancelled_quantity <> FND_API.G_MISS_NUM
4359: OR p_delivery_detail_rec.cancelled_quantity IS NULL THEN
4360: x_delivery_detail_rec.cancelled_quantity :=
4361: p_delivery_detail_rec.cancelled_quantity;
4362: END IF;
4359: OR p_delivery_detail_rec.cancelled_quantity IS NULL THEN
4360: x_delivery_detail_rec.cancelled_quantity :=
4361: p_delivery_detail_rec.cancelled_quantity;
4362: END IF;
4363: IF p_delivery_detail_rec.cancelled_quantity2 <> FND_API.G_MISS_NUM
4364: OR p_delivery_detail_rec.cancelled_quantity2 IS NULL THEN
4365: x_delivery_detail_rec.cancelled_quantity2 :=
4366: p_delivery_detail_rec.cancelled_quantity2;
4367: END IF;
4364: OR p_delivery_detail_rec.cancelled_quantity2 IS NULL THEN
4365: x_delivery_detail_rec.cancelled_quantity2 :=
4366: p_delivery_detail_rec.cancelled_quantity2;
4367: END IF;
4368: IF p_delivery_detail_rec.load_seq_number <> FND_API.G_MISS_NUM
4369: OR p_delivery_detail_rec.load_seq_number IS NULL THEN
4370: x_delivery_detail_rec.load_seq_number :=
4371: p_delivery_detail_rec.load_seq_number;
4372: END IF;
4369: OR p_delivery_detail_rec.load_seq_number IS NULL THEN
4370: x_delivery_detail_rec.load_seq_number :=
4371: p_delivery_detail_rec.load_seq_number;
4372: END IF;
4373: IF p_delivery_detail_rec.gross_weight <> FND_API.G_MISS_NUM
4374: OR p_delivery_detail_rec.gross_weight IS NULL THEN
4375: x_delivery_detail_rec.gross_weight :=
4376: p_delivery_detail_rec.gross_weight;
4377: END IF;
4374: OR p_delivery_detail_rec.gross_weight IS NULL THEN
4375: x_delivery_detail_rec.gross_weight :=
4376: p_delivery_detail_rec.gross_weight;
4377: END IF;
4378: IF p_delivery_detail_rec.net_weight <> FND_API.G_MISS_NUM
4379: OR p_delivery_detail_rec.net_weight IS NULL THEN
4380: x_delivery_detail_rec.net_weight :=
4381: p_delivery_detail_rec.net_weight;
4382: END IF;
4379: OR p_delivery_detail_rec.net_weight IS NULL THEN
4380: x_delivery_detail_rec.net_weight :=
4381: p_delivery_detail_rec.net_weight;
4382: END IF;
4383: IF p_delivery_detail_rec.volume <> FND_API.G_MISS_NUM
4384: OR p_delivery_detail_rec.volume IS NULL THEN
4385: x_delivery_detail_rec.volume :=
4386: p_delivery_detail_rec.volume;
4387: END IF;
4387: END IF;
4388:
4389: -- Update of UOM Codes is allowed only if they are Null and new codes are Valid UOM Codes
4390: IF p_in_rec.action_code = 'UPDATE' THEN
4391: IF p_delivery_detail_rec.weight_uom_code <> FND_API.G_MISS_CHAR
4392: AND p_delivery_detail_rec.weight_uom_code IS NOT NULL
4393: AND x_delivery_detail_rec.weight_uom_code IS NULL THEN
4394: OPEN c_isvalidUOM_Code(p_delivery_detail_rec.weight_uom_code);
4395: FETCH c_isvalidUOM_Code INTO l_uom_code;
4398: p_delivery_detail_rec.weight_uom_code;
4399: END IF;
4400: CLOSE c_isvalidUOM_Code;
4401: END IF;
4402: IF p_delivery_detail_rec.volume_uom_code <> FND_API.G_MISS_CHAR
4403: AND p_delivery_detail_rec.volume_uom_code IS NOT NULL
4404: AND x_delivery_detail_rec.volume_uom_code IS NULL THEN
4405: OPEN c_isvalidUOM_Code(p_delivery_detail_rec.volume_uom_code);
4406: FETCH c_isvalidUOM_Code INTO l_uom_code;
4411: CLOSE c_isvalidUOM_Code;
4412: END IF;
4413: END IF;
4414:
4415: IF p_delivery_detail_rec.fill_percent <> FND_API.G_MISS_NUM
4416: OR p_delivery_detail_rec.fill_percent IS NULL THEN
4417: x_delivery_detail_rec.fill_percent :=
4418: p_delivery_detail_rec.fill_percent;
4419: END IF;
4416: OR p_delivery_detail_rec.fill_percent IS NULL THEN
4417: x_delivery_detail_rec.fill_percent :=
4418: p_delivery_detail_rec.fill_percent;
4419: END IF;
4420: IF p_delivery_detail_rec.master_serial_number <> FND_API.G_MISS_CHAR
4421: OR p_delivery_detail_rec.master_serial_number IS NULL THEN
4422: x_delivery_detail_rec.master_serial_number :=
4423: p_delivery_detail_rec.master_serial_number;
4424: END IF;
4421: OR p_delivery_detail_rec.master_serial_number IS NULL THEN
4422: x_delivery_detail_rec.master_serial_number :=
4423: p_delivery_detail_rec.master_serial_number;
4424: END IF;
4425: IF p_delivery_detail_rec.master_container_item_id <> FND_API.G_MISS_NUM
4426: OR p_delivery_detail_rec.master_container_item_id IS NULL THEN
4427: x_delivery_detail_rec.master_container_item_id :=
4428: p_delivery_detail_rec.master_container_item_id;
4429: END IF;
4426: OR p_delivery_detail_rec.master_container_item_id IS NULL THEN
4427: x_delivery_detail_rec.master_container_item_id :=
4428: p_delivery_detail_rec.master_container_item_id;
4429: END IF;
4430: IF p_delivery_detail_rec.detail_container_item_id <> FND_API.G_MISS_NUM
4431: OR p_delivery_detail_rec.detail_container_item_id IS NULL THEN
4432: x_delivery_detail_rec.detail_container_item_id :=
4433: p_delivery_detail_rec.detail_container_item_id;
4434: END IF;
4431: OR p_delivery_detail_rec.detail_container_item_id IS NULL THEN
4432: x_delivery_detail_rec.detail_container_item_id :=
4433: p_delivery_detail_rec.detail_container_item_id;
4434: END IF;
4435: IF p_delivery_detail_rec.shipping_instructions <> FND_API.G_MISS_CHAR
4436: OR p_delivery_detail_rec.shipping_instructions IS NULL THEN
4437: x_delivery_detail_rec.shipping_instructions :=
4438: p_delivery_detail_rec.shipping_instructions;
4439: END IF;
4436: OR p_delivery_detail_rec.shipping_instructions IS NULL THEN
4437: x_delivery_detail_rec.shipping_instructions :=
4438: p_delivery_detail_rec.shipping_instructions;
4439: END IF;
4440: IF p_delivery_detail_rec.packing_instructions <> FND_API.G_MISS_CHAR
4441: OR p_delivery_detail_rec.packing_instructions IS NULL THEN
4442: x_delivery_detail_rec.packing_instructions :=
4443: p_delivery_detail_rec.packing_instructions;
4444: END IF;
4441: OR p_delivery_detail_rec.packing_instructions IS NULL THEN
4442: x_delivery_detail_rec.packing_instructions :=
4443: p_delivery_detail_rec.packing_instructions;
4444: END IF;
4445: IF p_delivery_detail_rec.revision <> FND_API.G_MISS_CHAR
4446: OR p_delivery_detail_rec.revision IS NULL THEN
4447: x_delivery_detail_rec.revision :=
4448: p_delivery_detail_rec.revision;
4449: END IF;
4446: OR p_delivery_detail_rec.revision IS NULL THEN
4447: x_delivery_detail_rec.revision :=
4448: p_delivery_detail_rec.revision;
4449: END IF;
4450: IF p_delivery_detail_rec.subinventory <> FND_API.G_MISS_CHAR
4451: OR p_delivery_detail_rec.subinventory IS NULL THEN
4452: x_delivery_detail_rec.subinventory :=
4453: p_delivery_detail_rec.subinventory;
4454: END IF;
4451: OR p_delivery_detail_rec.subinventory IS NULL THEN
4452: x_delivery_detail_rec.subinventory :=
4453: p_delivery_detail_rec.subinventory;
4454: END IF;
4455: IF p_delivery_detail_rec.lot_number <> FND_API.G_MISS_CHAR
4456: OR p_delivery_detail_rec.lot_number IS NULL THEN
4457: x_delivery_detail_rec.lot_number :=
4458: p_delivery_detail_rec.lot_number;
4459: END IF;
4458: p_delivery_detail_rec.lot_number;
4459: END IF;
4460: -- HW OPMCONV - No need for sublot_number
4461:
4462: IF p_delivery_detail_rec.locator_id <> FND_API.G_MISS_NUM
4463: OR p_delivery_detail_rec.locator_id IS NULL THEN
4464: x_delivery_detail_rec.locator_id :=
4465: p_delivery_detail_rec.locator_id;
4466: END IF;
4463: OR p_delivery_detail_rec.locator_id IS NULL THEN
4464: x_delivery_detail_rec.locator_id :=
4465: p_delivery_detail_rec.locator_id;
4466: END IF;
4467: IF p_delivery_detail_rec.serial_number <> FND_API.G_MISS_CHAR
4468: OR p_delivery_detail_rec.serial_number IS NULL THEN
4469: x_delivery_detail_rec.serial_number :=
4470: p_delivery_detail_rec.serial_number;
4471: END IF;
4470: p_delivery_detail_rec.serial_number;
4471: END IF;
4472: -- Bug Fix: 2651882. KVENKATE.
4473: -- Need to enable 'to_serial_number'
4474: IF p_delivery_detail_rec.to_serial_number <> FND_API.G_MISS_CHAR
4475: OR p_delivery_detail_rec.to_serial_number IS NULL THEN
4476: x_delivery_detail_rec.to_serial_number :=
4477: p_delivery_detail_rec.to_serial_number;
4478: END IF;
4477: p_delivery_detail_rec.to_serial_number;
4478: END IF;
4479: -- Bug Fix: 2651882. KVENKATE.
4480:
4481: IF p_delivery_detail_rec.preferred_grade <> FND_API.G_MISS_CHAR
4482: OR p_delivery_detail_rec.preferred_grade IS NULL THEN
4483: x_delivery_detail_rec.preferred_grade :=
4484: p_delivery_detail_rec.preferred_grade;
4485: END IF;
4482: OR p_delivery_detail_rec.preferred_grade IS NULL THEN
4483: x_delivery_detail_rec.preferred_grade :=
4484: p_delivery_detail_rec.preferred_grade;
4485: END IF;
4486: IF p_delivery_detail_rec.seal_code <> FND_API.G_MISS_CHAR
4487: OR p_delivery_detail_rec.seal_code IS NULL THEN
4488: x_delivery_detail_rec.seal_code :=
4489: p_delivery_detail_rec.seal_code;
4490: END IF;
4487: OR p_delivery_detail_rec.seal_code IS NULL THEN
4488: x_delivery_detail_rec.seal_code :=
4489: p_delivery_detail_rec.seal_code;
4490: END IF;
4491: IF p_delivery_detail_rec.inspection_flag <> FND_API.G_MISS_CHAR
4492: OR p_delivery_detail_rec.inspection_flag IS NULL THEN
4493: x_delivery_detail_rec.inspection_flag :=
4494: p_delivery_detail_rec.inspection_flag;
4495: END IF;
4492: OR p_delivery_detail_rec.inspection_flag IS NULL THEN
4493: x_delivery_detail_rec.inspection_flag :=
4494: p_delivery_detail_rec.inspection_flag;
4495: END IF;
4496: IF p_delivery_detail_rec.transaction_temp_id <> FND_API.G_MISS_NUM
4497: OR p_delivery_detail_rec.transaction_temp_id IS NULL THEN
4498: x_delivery_detail_rec.transaction_temp_id :=
4499: p_delivery_detail_rec.transaction_temp_id;
4500: END IF;
4499: p_delivery_detail_rec.transaction_temp_id;
4500: END IF;
4501:
4502:
4503: IF p_delivery_detail_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
4504: OR p_delivery_detail_rec.tp_attribute1 IS NULL THEN
4505: x_delivery_detail_rec.tp_attribute1 :=
4506: p_delivery_detail_rec.tp_attribute1;
4507: END IF;
4504: OR p_delivery_detail_rec.tp_attribute1 IS NULL THEN
4505: x_delivery_detail_rec.tp_attribute1 :=
4506: p_delivery_detail_rec.tp_attribute1;
4507: END IF;
4508: IF p_delivery_detail_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
4509: OR p_delivery_detail_rec.tp_attribute2 IS NULL THEN
4510: x_delivery_detail_rec.tp_attribute2 :=
4511: p_delivery_detail_rec.tp_attribute2;
4512: END IF;
4509: OR p_delivery_detail_rec.tp_attribute2 IS NULL THEN
4510: x_delivery_detail_rec.tp_attribute2 :=
4511: p_delivery_detail_rec.tp_attribute2;
4512: END IF;
4513: IF p_delivery_detail_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
4514: OR p_delivery_detail_rec.tp_attribute3 IS NULL THEN
4515: x_delivery_detail_rec.tp_attribute3 :=
4516: p_delivery_detail_rec.tp_attribute3;
4517: END IF;
4514: OR p_delivery_detail_rec.tp_attribute3 IS NULL THEN
4515: x_delivery_detail_rec.tp_attribute3 :=
4516: p_delivery_detail_rec.tp_attribute3;
4517: END IF;
4518: IF p_delivery_detail_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
4519: OR p_delivery_detail_rec.tp_attribute4 IS NULL THEN
4520: x_delivery_detail_rec.tp_attribute4 :=
4521: p_delivery_detail_rec.tp_attribute4;
4522: END IF;
4519: OR p_delivery_detail_rec.tp_attribute4 IS NULL THEN
4520: x_delivery_detail_rec.tp_attribute4 :=
4521: p_delivery_detail_rec.tp_attribute4;
4522: END IF;
4523: IF p_delivery_detail_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
4524: OR p_delivery_detail_rec.tp_attribute5 IS NULL THEN
4525: x_delivery_detail_rec.tp_attribute5 :=
4526: p_delivery_detail_rec.tp_attribute5;
4527: END IF;
4524: OR p_delivery_detail_rec.tp_attribute5 IS NULL THEN
4525: x_delivery_detail_rec.tp_attribute5 :=
4526: p_delivery_detail_rec.tp_attribute5;
4527: END IF;
4528: IF p_delivery_detail_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
4529: OR p_delivery_detail_rec.tp_attribute6 IS NULL THEN
4530: x_delivery_detail_rec.tp_attribute6 :=
4531: p_delivery_detail_rec.tp_attribute6;
4532: END IF;
4529: OR p_delivery_detail_rec.tp_attribute6 IS NULL THEN
4530: x_delivery_detail_rec.tp_attribute6 :=
4531: p_delivery_detail_rec.tp_attribute6;
4532: END IF;
4533: IF p_delivery_detail_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
4534: OR p_delivery_detail_rec.tp_attribute7 IS NULL THEN
4535: x_delivery_detail_rec.tp_attribute7 :=
4536: p_delivery_detail_rec.tp_attribute7;
4537: END IF;
4534: OR p_delivery_detail_rec.tp_attribute7 IS NULL THEN
4535: x_delivery_detail_rec.tp_attribute7 :=
4536: p_delivery_detail_rec.tp_attribute7;
4537: END IF;
4538: IF p_delivery_detail_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
4539: OR p_delivery_detail_rec.tp_attribute8 IS NULL THEN
4540: x_delivery_detail_rec.tp_attribute8 :=
4541: p_delivery_detail_rec.tp_attribute8;
4542: END IF;
4539: OR p_delivery_detail_rec.tp_attribute8 IS NULL THEN
4540: x_delivery_detail_rec.tp_attribute8 :=
4541: p_delivery_detail_rec.tp_attribute8;
4542: END IF;
4543: IF p_delivery_detail_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
4544: OR p_delivery_detail_rec.tp_attribute9 IS NULL THEN
4545: x_delivery_detail_rec.tp_attribute9 :=
4546: p_delivery_detail_rec.tp_attribute9;
4547: END IF;
4544: OR p_delivery_detail_rec.tp_attribute9 IS NULL THEN
4545: x_delivery_detail_rec.tp_attribute9 :=
4546: p_delivery_detail_rec.tp_attribute9;
4547: END IF;
4548: IF p_delivery_detail_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
4549: OR p_delivery_detail_rec.tp_attribute10 IS NULL THEN
4550: x_delivery_detail_rec.tp_attribute10 :=
4551: p_delivery_detail_rec.tp_attribute10;
4552: END IF;
4549: OR p_delivery_detail_rec.tp_attribute10 IS NULL THEN
4550: x_delivery_detail_rec.tp_attribute10 :=
4551: p_delivery_detail_rec.tp_attribute10;
4552: END IF;
4553: IF p_delivery_detail_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
4554: OR p_delivery_detail_rec.tp_attribute11 IS NULL THEN
4555: x_delivery_detail_rec.tp_attribute11 :=
4556: p_delivery_detail_rec.tp_attribute11;
4557: END IF;
4554: OR p_delivery_detail_rec.tp_attribute11 IS NULL THEN
4555: x_delivery_detail_rec.tp_attribute11 :=
4556: p_delivery_detail_rec.tp_attribute11;
4557: END IF;
4558: IF p_delivery_detail_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
4559: OR p_delivery_detail_rec.tp_attribute12 IS NULL THEN
4560: x_delivery_detail_rec.tp_attribute12 :=
4561: p_delivery_detail_rec.tp_attribute12;
4562: END IF;
4559: OR p_delivery_detail_rec.tp_attribute12 IS NULL THEN
4560: x_delivery_detail_rec.tp_attribute12 :=
4561: p_delivery_detail_rec.tp_attribute12;
4562: END IF;
4563: IF p_delivery_detail_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
4564: OR p_delivery_detail_rec.tp_attribute13 IS NULL THEN
4565: x_delivery_detail_rec.tp_attribute13 :=
4566: p_delivery_detail_rec.tp_attribute13;
4567: END IF;
4564: OR p_delivery_detail_rec.tp_attribute13 IS NULL THEN
4565: x_delivery_detail_rec.tp_attribute13 :=
4566: p_delivery_detail_rec.tp_attribute13;
4567: END IF;
4568: IF p_delivery_detail_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
4569: OR p_delivery_detail_rec.tp_attribute14 IS NULL THEN
4570: x_delivery_detail_rec.tp_attribute14 :=
4571: p_delivery_detail_rec.tp_attribute14;
4572: END IF;
4569: OR p_delivery_detail_rec.tp_attribute14 IS NULL THEN
4570: x_delivery_detail_rec.tp_attribute14 :=
4571: p_delivery_detail_rec.tp_attribute14;
4572: END IF;
4573: IF p_delivery_detail_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
4574: OR p_delivery_detail_rec.tp_attribute15 IS NULL THEN
4575: x_delivery_detail_rec.tp_attribute15 :=
4576: p_delivery_detail_rec.tp_attribute15;
4577: END IF;
4574: OR p_delivery_detail_rec.tp_attribute15 IS NULL THEN
4575: x_delivery_detail_rec.tp_attribute15 :=
4576: p_delivery_detail_rec.tp_attribute15;
4577: END IF;
4578: IF p_delivery_detail_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
4579: OR p_delivery_detail_rec.tp_attribute_category IS NULL THEN
4580: x_delivery_detail_rec.tp_attribute_category :=
4581: p_delivery_detail_rec.tp_attribute_category;
4582: END IF;
4579: OR p_delivery_detail_rec.tp_attribute_category IS NULL THEN
4580: x_delivery_detail_rec.tp_attribute_category :=
4581: p_delivery_detail_rec.tp_attribute_category;
4582: END IF;
4583: IF p_delivery_detail_rec.attribute1 <> FND_API.G_MISS_CHAR
4584: OR p_delivery_detail_rec.attribute1 IS NULL THEN
4585:
4586: x_delivery_detail_rec.attribute1 :=
4587: p_delivery_detail_rec.attribute1;
4585:
4586: x_delivery_detail_rec.attribute1 :=
4587: p_delivery_detail_rec.attribute1;
4588: END IF;
4589: IF p_delivery_detail_rec.attribute2 <> FND_API.G_MISS_CHAR
4590: OR p_delivery_detail_rec.attribute2 IS NULL THEN
4591: x_delivery_detail_rec.attribute2 :=
4592: p_delivery_detail_rec.attribute2;
4593: END IF;
4590: OR p_delivery_detail_rec.attribute2 IS NULL THEN
4591: x_delivery_detail_rec.attribute2 :=
4592: p_delivery_detail_rec.attribute2;
4593: END IF;
4594: IF p_delivery_detail_rec.attribute3 <> FND_API.G_MISS_CHAR
4595: OR p_delivery_detail_rec.attribute3 IS NULL THEN
4596: x_delivery_detail_rec.attribute3 :=
4597: p_delivery_detail_rec.attribute3;
4598: END IF;
4595: OR p_delivery_detail_rec.attribute3 IS NULL THEN
4596: x_delivery_detail_rec.attribute3 :=
4597: p_delivery_detail_rec.attribute3;
4598: END IF;
4599: IF p_delivery_detail_rec.attribute4 <> FND_API.G_MISS_CHAR
4600: OR p_delivery_detail_rec.attribute4 IS NULL THEN
4601: x_delivery_detail_rec.attribute4 :=
4602: p_delivery_detail_rec.attribute4;
4603: END IF;
4600: OR p_delivery_detail_rec.attribute4 IS NULL THEN
4601: x_delivery_detail_rec.attribute4 :=
4602: p_delivery_detail_rec.attribute4;
4603: END IF;
4604: IF p_delivery_detail_rec.attribute5 <> FND_API.G_MISS_CHAR
4605: OR p_delivery_detail_rec.attribute5 IS NULL THEN
4606: x_delivery_detail_rec.attribute5 :=
4607: p_delivery_detail_rec.attribute5;
4608: END IF;
4605: OR p_delivery_detail_rec.attribute5 IS NULL THEN
4606: x_delivery_detail_rec.attribute5 :=
4607: p_delivery_detail_rec.attribute5;
4608: END IF;
4609: IF p_delivery_detail_rec.attribute6 <> FND_API.G_MISS_CHAR
4610: OR p_delivery_detail_rec.attribute6 IS NULL THEN
4611: x_delivery_detail_rec.attribute6 :=
4612: p_delivery_detail_rec.attribute6;
4613: END IF;
4610: OR p_delivery_detail_rec.attribute6 IS NULL THEN
4611: x_delivery_detail_rec.attribute6 :=
4612: p_delivery_detail_rec.attribute6;
4613: END IF;
4614: IF p_delivery_detail_rec.attribute7 <> FND_API.G_MISS_CHAR
4615: OR p_delivery_detail_rec.attribute7 IS NULL THEN
4616: x_delivery_detail_rec.attribute7 :=
4617: p_delivery_detail_rec.attribute7;
4618: END IF;
4615: OR p_delivery_detail_rec.attribute7 IS NULL THEN
4616: x_delivery_detail_rec.attribute7 :=
4617: p_delivery_detail_rec.attribute7;
4618: END IF;
4619: IF p_delivery_detail_rec.attribute8 <> FND_API.G_MISS_CHAR
4620: OR p_delivery_detail_rec.attribute8 IS NULL THEN
4621: x_delivery_detail_rec.attribute8 :=
4622: p_delivery_detail_rec.attribute8;
4623: END IF;
4620: OR p_delivery_detail_rec.attribute8 IS NULL THEN
4621: x_delivery_detail_rec.attribute8 :=
4622: p_delivery_detail_rec.attribute8;
4623: END IF;
4624: IF p_delivery_detail_rec.attribute9 <> FND_API.G_MISS_CHAR
4625: OR p_delivery_detail_rec.attribute9 IS NULL THEN
4626: x_delivery_detail_rec.attribute9 :=
4627: p_delivery_detail_rec.attribute9;
4628: END IF;
4625: OR p_delivery_detail_rec.attribute9 IS NULL THEN
4626: x_delivery_detail_rec.attribute9 :=
4627: p_delivery_detail_rec.attribute9;
4628: END IF;
4629: IF p_delivery_detail_rec.attribute10 <> FND_API.G_MISS_CHAR
4630: OR p_delivery_detail_rec.attribute10 IS NULL THEN
4631: x_delivery_detail_rec.attribute10 :=
4632: p_delivery_detail_rec.attribute10;
4633: END IF;
4630: OR p_delivery_detail_rec.attribute10 IS NULL THEN
4631: x_delivery_detail_rec.attribute10 :=
4632: p_delivery_detail_rec.attribute10;
4633: END IF;
4634: IF p_delivery_detail_rec.attribute11 <> FND_API.G_MISS_CHAR
4635: OR p_delivery_detail_rec.attribute11 IS NULL THEN
4636: x_delivery_detail_rec.attribute11 :=
4637: p_delivery_detail_rec.attribute11;
4638: END IF;
4635: OR p_delivery_detail_rec.attribute11 IS NULL THEN
4636: x_delivery_detail_rec.attribute11 :=
4637: p_delivery_detail_rec.attribute11;
4638: END IF;
4639: IF p_delivery_detail_rec.attribute12 <> FND_API.G_MISS_CHAR
4640: OR p_delivery_detail_rec.attribute12 IS NULL THEN
4641: x_delivery_detail_rec.attribute12 :=
4642: p_delivery_detail_rec.attribute12;
4643: END IF;
4640: OR p_delivery_detail_rec.attribute12 IS NULL THEN
4641: x_delivery_detail_rec.attribute12 :=
4642: p_delivery_detail_rec.attribute12;
4643: END IF;
4644: IF p_delivery_detail_rec.attribute13 <> FND_API.G_MISS_CHAR
4645: OR p_delivery_detail_rec.attribute13 IS NULL THEN
4646: x_delivery_detail_rec.attribute13 :=
4647: p_delivery_detail_rec.attribute13;
4648: END IF;
4645: OR p_delivery_detail_rec.attribute13 IS NULL THEN
4646: x_delivery_detail_rec.attribute13 :=
4647: p_delivery_detail_rec.attribute13;
4648: END IF;
4649: IF p_delivery_detail_rec.attribute14 <> FND_API.G_MISS_CHAR
4650: OR p_delivery_detail_rec.attribute14 IS NULL THEN
4651: x_delivery_detail_rec.attribute14 :=
4652: p_delivery_detail_rec.attribute14;
4653: END IF;
4650: OR p_delivery_detail_rec.attribute14 IS NULL THEN
4651: x_delivery_detail_rec.attribute14 :=
4652: p_delivery_detail_rec.attribute14;
4653: END IF;
4654: IF p_delivery_detail_rec.attribute15 <> FND_API.G_MISS_CHAR
4655: OR p_delivery_detail_rec.attribute15 IS NULL THEN
4656: x_delivery_detail_rec.attribute15 :=
4657: p_delivery_detail_rec.attribute15;
4658: END IF;
4655: OR p_delivery_detail_rec.attribute15 IS NULL THEN
4656: x_delivery_detail_rec.attribute15 :=
4657: p_delivery_detail_rec.attribute15;
4658: END IF;
4659: IF p_delivery_detail_rec.attribute_category <> FND_API.G_MISS_CHAR
4660: OR p_delivery_detail_rec.attribute_category IS NULL THEN
4661: x_delivery_detail_rec.attribute_category :=
4662: p_delivery_detail_rec.attribute_category;
4663: END IF;
4662: p_delivery_detail_rec.attribute_category;
4663: END IF;
4664:
4665: -- Need to enable 'Tracking Number'. This is not a permanently disabled field
4666: IF p_delivery_detail_rec.tracking_number <> FND_API.G_MISS_CHAR
4667: OR p_delivery_detail_rec.tracking_number IS NULL THEN
4668: x_delivery_detail_rec.tracking_number :=
4669: p_delivery_detail_rec.tracking_number;
4670: END IF;
4669: p_delivery_detail_rec.tracking_number;
4670: END IF;
4671:
4672: -- J: W/V Changes
4673: IF p_delivery_detail_rec.filled_volume <> FND_API.G_MISS_NUM
4674: OR p_delivery_detail_rec.filled_volume IS NULL THEN
4675: x_delivery_detail_rec.filled_volume :=
4676: p_delivery_detail_rec.filled_volume;
4677: END IF;
4676: p_delivery_detail_rec.filled_volume;
4677: END IF;
4678:
4679: IF p_in_rec.caller='WSH_TP_RELEASE' THEN
4680: IF p_delivery_detail_rec.tp_delivery_detail_id <> FND_API.G_MISS_NUM
4681: OR p_delivery_detail_rec.tp_delivery_detail_id IS NULL THEN
4682: x_delivery_detail_rec.tp_delivery_detail_id :=
4683: p_delivery_detail_rec.tp_delivery_detail_id;
4684: END IF;
4882: --
4883: FOR i IN 2..p_disabled_list.COUNT
4884: LOOP
4885: IF p_disabled_list(i) = 'CONTAINER_NAME' THEN
4886: IF p_in_rec.CONTAINER_NAME <> FND_API.G_MISS_CHAR
4887: OR p_in_rec.CONTAINER_NAME IS NULL THEN
4888: x_out_rec.container_name := p_in_rec.container_name ;
4889: END IF;
4890: ELSIF p_disabled_list(i) = 'CYCLE_COUNT_QUANTITY' THEN
4887: OR p_in_rec.CONTAINER_NAME IS NULL THEN
4888: x_out_rec.container_name := p_in_rec.container_name ;
4889: END IF;
4890: ELSIF p_disabled_list(i) = 'CYCLE_COUNT_QUANTITY' THEN
4891: IF p_in_rec.cycle_count_quantity <> FND_API.G_MISS_NUM
4892: OR p_in_rec.cycle_count_quantity IS NULL THEN
4893: x_out_rec.cycle_count_quantity := p_in_rec.cycle_count_quantity ;
4894: END IF;
4895: ELSIF p_disabled_list(i) = 'INSPECTION_FLAG' THEN
4892: OR p_in_rec.cycle_count_quantity IS NULL THEN
4893: x_out_rec.cycle_count_quantity := p_in_rec.cycle_count_quantity ;
4894: END IF;
4895: ELSIF p_disabled_list(i) = 'INSPECTION_FLAG' THEN
4896: IF p_in_rec.INSPECTION_FLAG <> FND_API.G_MISS_CHAR
4897: OR p_in_rec.INSPECTION_FLAG IS NULL THEN
4898: x_out_rec.INSPECTION_FLAG := p_in_rec.INSPECTION_FLAG ;
4899: END IF;
4900: ELSIF p_disabled_list(i) = 'CYCLE_COUNT_QUANTITY2' THEN
4897: OR p_in_rec.INSPECTION_FLAG IS NULL THEN
4898: x_out_rec.INSPECTION_FLAG := p_in_rec.INSPECTION_FLAG ;
4899: END IF;
4900: ELSIF p_disabled_list(i) = 'CYCLE_COUNT_QUANTITY2' THEN
4901: IF p_in_rec.cycle_count_quantity2 <> FND_API.G_MISS_NUM
4902: OR p_in_rec.cycle_count_quantity2 IS NULL THEN
4903: x_out_rec.cycle_count_quantity2 := p_in_rec.cycle_count_quantity2 ;
4904: END IF;
4905: ELSIF p_disabled_list(i) = 'CANCELLED_QUANTITY2' THEN
4902: OR p_in_rec.cycle_count_quantity2 IS NULL THEN
4903: x_out_rec.cycle_count_quantity2 := p_in_rec.cycle_count_quantity2 ;
4904: END IF;
4905: ELSIF p_disabled_list(i) = 'CANCELLED_QUANTITY2' THEN
4906: IF p_in_rec.cancelled_quantity2 <> FND_API.G_MISS_NUM
4907: OR p_in_rec.cancelled_quantity2 IS NULL THEN
4908: x_out_rec.cancelled_quantity2 := p_in_rec.cancelled_quantity2 ;
4909: END IF;
4910: ELSIF p_disabled_list(i) = 'CANCELLED_QUANTITY' THEN
4907: OR p_in_rec.cancelled_quantity2 IS NULL THEN
4908: x_out_rec.cancelled_quantity2 := p_in_rec.cancelled_quantity2 ;
4909: END IF;
4910: ELSIF p_disabled_list(i) = 'CANCELLED_QUANTITY' THEN
4911: IF p_in_rec.cancelled_quantity <> FND_API.G_MISS_NUM
4912: OR p_in_rec.cancelled_quantity IS NULL THEN
4913: x_out_rec.cancelled_quantity := p_in_rec.cancelled_quantity ;
4914: END IF;
4915: ELSIF p_disabled_list(i) = 'DELIVERED_QUANTITY2' THEN
4912: OR p_in_rec.cancelled_quantity IS NULL THEN
4913: x_out_rec.cancelled_quantity := p_in_rec.cancelled_quantity ;
4914: END IF;
4915: ELSIF p_disabled_list(i) = 'DELIVERED_QUANTITY2' THEN
4916: IF p_in_rec.delivered_quantity2 <> FND_API.G_MISS_NUM
4917: OR p_in_rec.delivered_quantity2 IS NULL THEN
4918: x_out_rec.delivered_quantity2 := p_in_rec.delivered_quantity2 ;
4919: END IF;
4920: ELSIF p_disabled_list(i) = 'DELIVERED_QUANTITY' THEN
4917: OR p_in_rec.delivered_quantity2 IS NULL THEN
4918: x_out_rec.delivered_quantity2 := p_in_rec.delivered_quantity2 ;
4919: END IF;
4920: ELSIF p_disabled_list(i) = 'DELIVERED_QUANTITY' THEN
4921: IF p_in_rec.delivered_quantity <> FND_API.G_MISS_NUM
4922: OR p_in_rec.delivered_quantity IS NULL THEN
4923: x_out_rec.delivered_quantity := p_in_rec.delivered_quantity ;
4924: END IF;
4925: ELSIF p_disabled_list(i) = 'DETAIL_CONTAINER_ITEM_NAME' THEN
4922: OR p_in_rec.delivered_quantity IS NULL THEN
4923: x_out_rec.delivered_quantity := p_in_rec.delivered_quantity ;
4924: END IF;
4925: ELSIF p_disabled_list(i) = 'DETAIL_CONTAINER_ITEM_NAME' THEN
4926: IF p_in_rec.detail_container_item_id <> FND_API.G_MISS_NUM
4927: OR p_in_rec.detail_container_item_id IS NULL THEN
4928: x_out_rec.detail_container_item_id := p_in_rec.detail_container_item_id ;
4929: END IF;
4930: -- for X-dock
4928: x_out_rec.detail_container_item_id := p_in_rec.detail_container_item_id ;
4929: END IF;
4930: -- for X-dock
4931: ELSIF p_disabled_list(i) = 'RELEASED_STATUS' THEN
4932: IF p_in_rec.released_status <> FND_API.G_MISS_CHAR
4933: OR p_in_rec.released_status IS NULL THEN
4934: x_out_rec.released_status := p_in_rec.released_status;
4935: END IF;
4936: ELSIF p_disabled_list(i) = 'MOVE_ORDER_LINE_ID' THEN
4933: OR p_in_rec.released_status IS NULL THEN
4934: x_out_rec.released_status := p_in_rec.released_status;
4935: END IF;
4936: ELSIF p_disabled_list(i) = 'MOVE_ORDER_LINE_ID' THEN
4937: IF p_in_rec.move_order_line_id <> FND_API.G_MISS_NUM
4938: OR p_in_rec.move_order_line_id IS NULL THEN
4939: x_out_rec.move_order_line_id := p_in_rec.move_order_line_id;
4940: END IF;
4941: --bug# 6689448 (replenishment project)
4939: x_out_rec.move_order_line_id := p_in_rec.move_order_line_id;
4940: END IF;
4941: --bug# 6689448 (replenishment project)
4942: ELSIF p_disabled_list(i) = 'REPLENISHMENT_STATUS' THEN
4943: IF p_in_rec.REPLENISHMENT_STATUS <> FND_API.G_MISS_CHAR
4944: OR p_in_rec. REPLENISHMENT_STATUS IS NULL THEN
4945: x_out_rec.REPLENISHMENT_STATUS:= p_in_rec.REPLENISHMENT_STATUS;
4946: END IF;
4947: ELSIF p_disabled_list(i) = 'BATCH_ID' THEN
4944: OR p_in_rec. REPLENISHMENT_STATUS IS NULL THEN
4945: x_out_rec.REPLENISHMENT_STATUS:= p_in_rec.REPLENISHMENT_STATUS;
4946: END IF;
4947: ELSIF p_disabled_list(i) = 'BATCH_ID' THEN
4948: IF p_in_rec.batch_id <> FND_API.G_MISS_NUM
4949: OR p_in_rec.batch_id IS NULL THEN
4950: x_out_rec.batch_id := p_in_rec.batch_id;
4951: END IF;
4952: -- end of X-dock changes
4950: x_out_rec.batch_id := p_in_rec.batch_id;
4951: END IF;
4952: -- end of X-dock changes
4953: ELSIF p_disabled_list(i) = 'GROSS_WEIGHT' THEN
4954: IF p_in_rec.gross_weight <> FND_API.G_MISS_NUM
4955: OR p_in_rec.gross_weight IS NULL THEN
4956: x_out_rec.gross_weight := p_in_rec.gross_weight ;
4957: END IF;
4958: ELSIF p_disabled_list(i) = 'TARE_WEIGHT' THEN
4958: ELSIF p_disabled_list(i) = 'TARE_WEIGHT' THEN
4959: null;
4960: -- J-IB-NPARIKH-{ --I-bug-fix
4961: ELSIF p_disabled_list(i) = 'NET_WEIGHT' THEN
4962: IF p_in_rec.net_weight <> FND_API.G_MISS_NUM
4963: OR p_in_rec.net_weight IS NULL THEN
4964: x_out_rec.net_weight := p_in_rec.net_weight ;
4965: END IF;
4966: ELSIF p_disabled_list(i) = 'VOLUME' THEN
4963: OR p_in_rec.net_weight IS NULL THEN
4964: x_out_rec.net_weight := p_in_rec.net_weight ;
4965: END IF;
4966: ELSIF p_disabled_list(i) = 'VOLUME' THEN
4967: IF p_in_rec.VOLUME <> FND_API.G_MISS_NUM
4968: OR p_in_rec.VOLUME IS NULL THEN
4969: x_out_rec.VOLUME := p_in_rec.VOLUME ;
4970: END IF;
4971: -- J-IB-NPARIKH-}
4970: END IF;
4971: -- J-IB-NPARIKH-}
4972: -- bug 5077108
4973: ELSIF p_disabled_list(i) = 'INVENTORY_ITEM_ID' THEN
4974: IF p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM
4975: OR p_in_rec.inventory_item_id IS NULL THEN
4976: x_out_rec.inventory_item_id := p_in_rec.inventory_item_id ;
4977: END IF;
4978: -- end bug 5077108
4978: -- end bug 5077108
4979:
4980: --Bug 5212632 Start
4981: ELSIF p_disabled_list(i) = 'CONTAINER_TYPE_CODE' THEN
4982: IF p_in_rec.container_type_code <> FND_API.G_MISS_CHAR
4983: OR p_in_rec.container_type_code IS NULL THEN
4984:
4985: x_out_rec.container_type_code := p_in_rec.container_type_code;
4986: ELSIF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
4982: IF p_in_rec.container_type_code <> FND_API.G_MISS_CHAR
4983: OR p_in_rec.container_type_code IS NULL THEN
4984:
4985: x_out_rec.container_type_code := p_in_rec.container_type_code;
4986: ELSIF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
4987: IF l_cursor_opened_flag = 1 THEN
4988: x_out_rec.container_type_code:=l_container_type_code;
4989: ELSE
4990: OPEN get_MSI_details (p_in_rec.inventory_item_id,p_in_rec.delivery_detail_id);
4999: --Bug 5212632 End
5000: --Bug 7165744
5001: --requested_quantity_uom can be updated for WMS LPNs.
5002: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM' THEN
5003: IF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
5004: IF l_cursor_opened_flag = 1 THEN
5005: x_out_rec.requested_quantity_uom:=l_requested_quantity_uom;
5006: ELSE
5007: OPEN get_MSI_details (p_in_rec.inventory_item_id,p_in_rec.delivery_detail_id);
5015: END IF;
5016: -- end Bug 7165744
5017: --Added the following code as part of fix for bug 6082324
5018: ELSIF p_disabled_list(i) = 'MAXIMUM_LOAD_WEIGHT' THEN
5019: IF p_in_rec.MAXIMUM_LOAD_WEIGHT <> FND_API.G_MISS_NUM
5020: OR p_in_rec.MAXIMUM_LOAD_WEIGHT IS NULL THEN
5021: x_out_rec.MAXIMUM_LOAD_WEIGHT := p_in_rec.MAXIMUM_LOAD_WEIGHT;
5022: ELSIF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
5023: IF l_cursor_opened_flag = 1 THEN
5018: ELSIF p_disabled_list(i) = 'MAXIMUM_LOAD_WEIGHT' THEN
5019: IF p_in_rec.MAXIMUM_LOAD_WEIGHT <> FND_API.G_MISS_NUM
5020: OR p_in_rec.MAXIMUM_LOAD_WEIGHT IS NULL THEN
5021: x_out_rec.MAXIMUM_LOAD_WEIGHT := p_in_rec.MAXIMUM_LOAD_WEIGHT;
5022: ELSIF (p_in_rec.inventory_item_id <> FND_API.G_MISS_NUM ) THEN
5023: IF l_cursor_opened_flag = 1 THEN
5024: x_out_rec.MAXIMUM_LOAD_WEIGHT:=l_maximum_load_weight;
5025: ELSE
5026: OPEN get_MSI_details (p_in_rec.inventory_item_id,p_in_rec.delivery_detail_id);
5035: --End of fix for bug # 6082324
5036:
5037:
5038: ELSIF p_disabled_list(i) = 'LOCATOR_NAME' THEN
5039: IF p_in_rec.locator_id <> FND_API.G_MISS_NUM
5040: OR p_in_rec.locator_id IS NULL THEN
5041: x_out_rec.locator_id := p_in_rec.locator_id ;
5042: END IF;
5043: ELSIF p_disabled_list(i) = 'LOAD_SEQ_NUMBER' THEN
5040: OR p_in_rec.locator_id IS NULL THEN
5041: x_out_rec.locator_id := p_in_rec.locator_id ;
5042: END IF;
5043: ELSIF p_disabled_list(i) = 'LOAD_SEQ_NUMBER' THEN
5044: IF p_in_rec.load_seq_number <> FND_API.G_MISS_NUM
5045: OR p_in_rec.load_seq_number IS NULL THEN
5046: x_out_rec.load_seq_number := p_in_rec.load_seq_number ;
5047: END IF;
5048: ELSIF p_disabled_list(i) = 'LPN_ID' THEN
5045: OR p_in_rec.load_seq_number IS NULL THEN
5046: x_out_rec.load_seq_number := p_in_rec.load_seq_number ;
5047: END IF;
5048: ELSIF p_disabled_list(i) = 'LPN_ID' THEN
5049: IF p_in_rec.lpn_id <> FND_API.G_MISS_NUM
5050: OR p_in_rec.lpn_id IS NULL THEN
5051: x_out_rec.lpn_id := p_in_rec.lpn_id ;
5052: END IF;
5053: ELSIF p_disabled_list(i) = 'MASTER_CONTAINER_ITEM_NAME' THEN
5050: OR p_in_rec.lpn_id IS NULL THEN
5051: x_out_rec.lpn_id := p_in_rec.lpn_id ;
5052: END IF;
5053: ELSIF p_disabled_list(i) = 'MASTER_CONTAINER_ITEM_NAME' THEN
5054: IF p_in_rec.master_container_item_id <> FND_API.G_MISS_NUM
5055: OR p_in_rec.master_container_item_id IS NULL THEN
5056: x_out_rec.master_container_item_id := p_in_rec.master_container_item_id ;
5057: END IF;
5058: ELSIF p_disabled_list(i) = 'PACKING_INSTRUCTIONS' THEN
5055: OR p_in_rec.master_container_item_id IS NULL THEN
5056: x_out_rec.master_container_item_id := p_in_rec.master_container_item_id ;
5057: END IF;
5058: ELSIF p_disabled_list(i) = 'PACKING_INSTRUCTIONS' THEN
5059: IF p_in_rec.PACKING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
5060: OR p_in_rec.PACKING_INSTRUCTIONS IS NULL THEN
5061: x_out_rec.PACKING_INSTRUCTIONS := p_in_rec.PACKING_INSTRUCTIONS ;
5062: END IF;
5063: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY2' THEN
5060: OR p_in_rec.PACKING_INSTRUCTIONS IS NULL THEN
5061: x_out_rec.PACKING_INSTRUCTIONS := p_in_rec.PACKING_INSTRUCTIONS ;
5062: END IF;
5063: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY2' THEN
5064: IF p_in_rec.PICKED_QUANTITY2 <> FND_API.G_MISS_NUM
5065: OR p_in_rec.PICKED_QUANTITY2 IS NULL THEN
5066: x_out_rec.picked_quantity2 := p_in_rec.picked_quantity2 ;
5067: END IF;
5068: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM2' THEN
5065: OR p_in_rec.PICKED_QUANTITY2 IS NULL THEN
5066: x_out_rec.picked_quantity2 := p_in_rec.picked_quantity2 ;
5067: END IF;
5068: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM2' THEN
5069: IF p_in_rec.REQUESTED_QUANTITY_UOM2 <> FND_API.G_MISS_CHAR
5070: OR p_in_rec.REQUESTED_QUANTITY_UOM2 IS NULL THEN
5071: x_out_rec.REQUESTED_QUANTITY_UOM2 := p_in_rec.REQUESTED_QUANTITY_UOM2 ;
5072: END IF;
5073:
5072: END IF;
5073:
5074: -- bmso
5075: ELSIF p_disabled_list(i) = 'PREFERED_GRADE' THEN
5076: IF p_in_rec.PREFERRED_GRADE <> FND_API.G_MISS_CHAR
5077: OR p_in_rec.PREFERRED_GRADE IS NULL THEN
5078: x_out_rec.PREFERRED_GRADE := p_in_rec.PREFERRED_GRADE ;
5079: END IF;
5080: ELSIF p_disabled_list(i) = 'SRC_REQUESTED_QUANTITY2' THEN
5077: OR p_in_rec.PREFERRED_GRADE IS NULL THEN
5078: x_out_rec.PREFERRED_GRADE := p_in_rec.PREFERRED_GRADE ;
5079: END IF;
5080: ELSIF p_disabled_list(i) = 'SRC_REQUESTED_QUANTITY2' THEN
5081: IF p_in_rec.SRC_REQUESTED_QUANTITY2 <> FND_API.G_MISS_NUM
5082: OR p_in_rec.SRC_REQUESTED_QUANTITY2 IS NULL THEN
5083: x_out_rec.SRC_REQUESTED_QUANTITY2 := p_in_rec.SRC_REQUESTED_QUANTITY2 ;
5084: END IF;
5085: ELSIF p_disabled_list(i) = 'SRC_REQUESTED_QUANTITY_UOM2' THEN
5082: OR p_in_rec.SRC_REQUESTED_QUANTITY2 IS NULL THEN
5083: x_out_rec.SRC_REQUESTED_QUANTITY2 := p_in_rec.SRC_REQUESTED_QUANTITY2 ;
5084: END IF;
5085: ELSIF p_disabled_list(i) = 'SRC_REQUESTED_QUANTITY_UOM2' THEN
5086: IF p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 <> FND_API.G_MISS_CHAR
5087: OR p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 IS NULL THEN
5088: x_out_rec.SRC_REQUESTED_QUANTITY_UOM2 := p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 ;
5089: END IF;
5090: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY2' THEN
5087: OR p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 IS NULL THEN
5088: x_out_rec.SRC_REQUESTED_QUANTITY_UOM2 := p_in_rec.SRC_REQUESTED_QUANTITY_UOM2 ;
5089: END IF;
5090: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY2' THEN
5091: IF p_in_rec.REQUESTED_QUANTITY2 <> FND_API.G_MISS_NUM
5092: OR p_in_rec.REQUESTED_QUANTITY2 IS NULL THEN
5093: x_out_rec.REQUESTED_QUANTITY2 := p_in_rec.REQUESTED_QUANTITY2 ;
5094: END IF;
5095: ELSIF p_disabled_list(i) = 'QUALITY_CONTROL_QUANTITY2' THEN
5092: OR p_in_rec.REQUESTED_QUANTITY2 IS NULL THEN
5093: x_out_rec.REQUESTED_QUANTITY2 := p_in_rec.REQUESTED_QUANTITY2 ;
5094: END IF;
5095: ELSIF p_disabled_list(i) = 'QUALITY_CONTROL_QUANTITY2' THEN
5096: IF p_in_rec.QUALITY_CONTROL_QUANTITY2 <> FND_API.G_MISS_NUM
5097: OR p_in_rec.QUALITY_CONTROL_QUANTITY2 IS NULL THEN
5098: x_out_rec.QUALITY_CONTROL_QUANTITY2 := p_in_rec.QUALITY_CONTROL_QUANTITY2 ;
5099: END IF;
5100: ELSIF p_disabled_list(i) = 'SUBLOT_NUMBER' THEN
5098: x_out_rec.QUALITY_CONTROL_QUANTITY2 := p_in_rec.QUALITY_CONTROL_QUANTITY2 ;
5099: END IF;
5100: ELSIF p_disabled_list(i) = 'SUBLOT_NUMBER' THEN
5101: NULL;
5102: --IF p_in_rec.SUBLOT_NUMBER <> FND_API.G_MISS_CHAR
5103: --OR p_in_rec.SUBLOT_NUMBER IS NULL THEN
5104: --x_out_rec.SUBLOT_NUMBER := p_in_rec.SUBLOT_NUMBER ;
5105: --END IF;
5106: ELSIF p_disabled_list(i) = 'RETURNED_QUANTITY2' THEN
5103: --OR p_in_rec.SUBLOT_NUMBER IS NULL THEN
5104: --x_out_rec.SUBLOT_NUMBER := p_in_rec.SUBLOT_NUMBER ;
5105: --END IF;
5106: ELSIF p_disabled_list(i) = 'RETURNED_QUANTITY2' THEN
5107: IF p_in_rec.RETURNED_QUANTITY2 <> FND_API.G_MISS_NUM
5108: OR p_in_rec.RETURNED_QUANTITY2 IS NULL THEN
5109: x_out_rec.RETURNED_QUANTITY2 := p_in_rec.RETURNED_QUANTITY2 ;
5110: END IF;
5111: ELSIF p_disabled_list(i) = 'RECEIVED_QUANTITY2' THEN
5108: OR p_in_rec.RETURNED_QUANTITY2 IS NULL THEN
5109: x_out_rec.RETURNED_QUANTITY2 := p_in_rec.RETURNED_QUANTITY2 ;
5110: END IF;
5111: ELSIF p_disabled_list(i) = 'RECEIVED_QUANTITY2' THEN
5112: IF p_in_rec.RECEIVED_QUANTITY2 <> FND_API.G_MISS_NUM
5113: OR p_in_rec.RECEIVED_QUANTITY2 IS NULL THEN
5114: x_out_rec.RECEIVED_QUANTITY2 := p_in_rec.RECEIVED_QUANTITY2 ;
5115: END IF;
5116: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY2' THEN
5113: OR p_in_rec.RECEIVED_QUANTITY2 IS NULL THEN
5114: x_out_rec.RECEIVED_QUANTITY2 := p_in_rec.RECEIVED_QUANTITY2 ;
5115: END IF;
5116: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY2' THEN
5117: IF p_in_rec.PICKED_QUANTITY2 <> FND_API.G_MISS_NUM
5118: OR p_in_rec.PICKED_QUANTITY2 IS NULL THEN
5119: x_out_rec.PICKED_QUANTITY2 := p_in_rec.PICKED_QUANTITY2 ;
5120: END IF;
5121: ELSIF p_disabled_list(i) = 'TO_SERIAL_NUMBER' THEN
5118: OR p_in_rec.PICKED_QUANTITY2 IS NULL THEN
5119: x_out_rec.PICKED_QUANTITY2 := p_in_rec.PICKED_QUANTITY2 ;
5120: END IF;
5121: ELSIF p_disabled_list(i) = 'TO_SERIAL_NUMBER' THEN
5122: IF p_in_rec.TO_SERIAL_NUMBER <> FND_API.G_MISS_CHAR
5123: OR p_in_rec.TO_SERIAL_NUMBER IS NULL THEN
5124: x_out_rec.TO_SERIAL_NUMBER := p_in_rec.TO_SERIAL_NUMBER ;
5125: END IF;
5126: ELSIF p_disabled_list(i) = 'SERIAL_NUMBER' THEN
5123: OR p_in_rec.TO_SERIAL_NUMBER IS NULL THEN
5124: x_out_rec.TO_SERIAL_NUMBER := p_in_rec.TO_SERIAL_NUMBER ;
5125: END IF;
5126: ELSIF p_disabled_list(i) = 'SERIAL_NUMBER' THEN
5127: IF p_in_rec.SERIAL_NUMBER <> FND_API.G_MISS_CHAR
5128: OR p_in_rec.SERIAL_NUMBER IS NULL THEN
5129: x_out_rec.SERIAL_NUMBER := p_in_rec.SERIAL_NUMBER ;
5130: END IF;
5131: ELSIF p_disabled_list(i) = 'TRANSACTION_TEMP_ID' THEN
5128: OR p_in_rec.SERIAL_NUMBER IS NULL THEN
5129: x_out_rec.SERIAL_NUMBER := p_in_rec.SERIAL_NUMBER ;
5130: END IF;
5131: ELSIF p_disabled_list(i) = 'TRANSACTION_TEMP_ID' THEN
5132: IF p_in_rec.TRANSACTION_TEMP_ID <> FND_API.G_MISS_NUM
5133: OR p_in_rec.TRANSACTION_TEMP_ID IS NULL THEN
5134: x_out_rec.TRANSACTION_TEMP_ID := p_in_rec.TRANSACTION_TEMP_ID ;
5135: END IF;
5136: ELSIF p_disabled_list(i) = 'REVISION' THEN
5133: OR p_in_rec.TRANSACTION_TEMP_ID IS NULL THEN
5134: x_out_rec.TRANSACTION_TEMP_ID := p_in_rec.TRANSACTION_TEMP_ID ;
5135: END IF;
5136: ELSIF p_disabled_list(i) = 'REVISION' THEN
5137: IF p_in_rec.REVISION <> FND_API.G_MISS_CHAR
5138: OR p_in_rec.REVISION IS NULL THEN
5139: x_out_rec.REVISION := p_in_rec.REVISION ;
5140: END IF;
5141: ELSIF p_disabled_list(i) = 'LOT_NUMBER' THEN
5138: OR p_in_rec.REVISION IS NULL THEN
5139: x_out_rec.REVISION := p_in_rec.REVISION ;
5140: END IF;
5141: ELSIF p_disabled_list(i) = 'LOT_NUMBER' THEN
5142: IF p_in_rec.LOT_NUMBER <> FND_API.G_MISS_CHAR
5143: OR p_in_rec.LOT_NUMBER IS NULL THEN
5144: x_out_rec.LOT_NUMBER := p_in_rec.LOT_NUMBER ;
5145: END IF;
5146: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM' THEN
5143: OR p_in_rec.LOT_NUMBER IS NULL THEN
5144: x_out_rec.LOT_NUMBER := p_in_rec.LOT_NUMBER ;
5145: END IF;
5146: ELSIF p_disabled_list(i) = 'REQUESTED_QUANTITY_UOM' THEN
5147: IF p_in_rec.REQUESTED_QUANTITY_UOM <> FND_API.G_MISS_CHAR
5148: OR p_in_rec.REQUESTED_QUANTITY_UOM IS NULL THEN
5149: x_out_rec.REQUESTED_QUANTITY_UOM := p_in_rec.REQUESTED_QUANTITY_UOM ;
5150: END IF;
5151: --
5149: x_out_rec.REQUESTED_QUANTITY_UOM := p_in_rec.REQUESTED_QUANTITY_UOM ;
5150: END IF;
5151: --
5152: ELSIF p_disabled_list(i) = 'SHIPPING_INSTRUCTIONS' THEN
5153: IF p_in_rec.shipping_instructions <> FND_API.G_MISS_CHAR
5154: OR p_in_rec.shipping_instructions IS NULL THEN
5155: x_out_rec.shipping_instructions := p_in_rec.shipping_instructions ;
5156: END IF;
5157: ELSIF p_disabled_list(i) = 'SHIPPED_QUANTITY' THEN
5154: OR p_in_rec.shipping_instructions IS NULL THEN
5155: x_out_rec.shipping_instructions := p_in_rec.shipping_instructions ;
5156: END IF;
5157: ELSIF p_disabled_list(i) = 'SHIPPED_QUANTITY' THEN
5158: IF p_in_rec.shipped_quantity <> FND_API.G_MISS_NUM
5159: OR p_in_rec.shipped_quantity IS NULL THEN
5160: x_out_rec.shipped_quantity := p_in_rec.shipped_quantity ;
5161: END IF;
5162: -- muom: Allow updation of picked quantity (when fulfillment base is secondary)
5160: x_out_rec.shipped_quantity := p_in_rec.shipped_quantity ;
5161: END IF;
5162: -- muom: Allow updation of picked quantity (when fulfillment base is secondary)
5163: ELSIF p_disabled_list(i) = 'PICKED_QUANTITY' THEN
5164: IF p_in_rec.PICKED_quantity <> FND_API.G_MISS_NUM
5165: OR p_in_rec.PICKED_quantity IS NULL THEN
5166: x_out_rec.PICKED_quantity := p_in_rec.PICKED_quantity ;
5167: END IF;
5168: ELSIF p_disabled_list(i) = 'SEAL_CODE' THEN
5165: OR p_in_rec.PICKED_quantity IS NULL THEN
5166: x_out_rec.PICKED_quantity := p_in_rec.PICKED_quantity ;
5167: END IF;
5168: ELSIF p_disabled_list(i) = 'SEAL_CODE' THEN
5169: IF p_in_rec.seal_code <> FND_API.G_MISS_CHAR
5170: OR p_in_rec.seal_code IS NULL THEN
5171: x_out_rec.seal_code := p_in_rec.seal_code ;
5172: END IF;
5173: ELSIF p_disabled_list(i) = 'SHIPPED_QUANTITY2' THEN
5170: OR p_in_rec.seal_code IS NULL THEN
5171: x_out_rec.seal_code := p_in_rec.seal_code ;
5172: END IF;
5173: ELSIF p_disabled_list(i) = 'SHIPPED_QUANTITY2' THEN
5174: IF p_in_rec.shipped_quantity2 <> FND_API.G_MISS_NUM
5175: OR p_in_rec.shipped_quantity2 IS NULL THEN
5176: x_out_rec.shipped_quantity2 := p_in_rec.shipped_quantity2 ;
5177: END IF;
5178: ELSIF p_disabled_list(i) = 'SUBINVENTORY' THEN
5175: OR p_in_rec.shipped_quantity2 IS NULL THEN
5176: x_out_rec.shipped_quantity2 := p_in_rec.shipped_quantity2 ;
5177: END IF;
5178: ELSIF p_disabled_list(i) = 'SUBINVENTORY' THEN
5179: IF p_in_rec.subinventory <> FND_API.G_MISS_CHAR
5180: OR p_in_rec.subinventory IS NULL THEN
5181: x_out_rec.subinventory := p_in_rec.subinventory ;
5182: END IF;
5183: -- TPW - Distributed changes
5181: x_out_rec.subinventory := p_in_rec.subinventory ;
5182: END IF;
5183: -- TPW - Distributed changes
5184: ELSIF p_disabled_list(i) = 'REVISION' THEN
5185: IF p_in_rec.revision <> FND_API.G_MISS_CHAR
5186: OR p_in_rec.revision IS NULL THEN
5187: x_out_rec.revision := p_in_rec.revision ;
5188: END IF;
5189: --Bugfix 6939348 start
5187: x_out_rec.revision := p_in_rec.revision ;
5188: END IF;
5189: --Bugfix 6939348 start
5190: ELSIF p_disabled_list(i) = 'LOT_NUMBER' THEN
5191: IF p_in_rec.lot_number <> FND_API.G_MISS_CHAR
5192: OR p_in_rec.lot_number IS NULL THEN
5193: x_out_rec.lot_number := p_in_rec.lot_number;
5194: END IF;
5195: -- Bugfix 6939348 end
5193: x_out_rec.lot_number := p_in_rec.lot_number;
5194: END IF;
5195: -- Bugfix 6939348 end
5196: ELSIF p_disabled_list(i) = 'TRACKING_NUMBER' THEN
5197: IF p_in_rec.tracking_number <> FND_API.G_MISS_CHAR
5198: OR p_in_rec.tracking_number IS NULL THEN
5199: x_out_rec.tracking_number := p_in_rec.tracking_number ;
5200: END IF;
5201: ELSIF p_disabled_list(i) = 'SHIP_METHOD_CODE' THEN
5198: OR p_in_rec.tracking_number IS NULL THEN
5199: x_out_rec.tracking_number := p_in_rec.tracking_number ;
5200: END IF;
5201: ELSIF p_disabled_list(i) = 'SHIP_METHOD_CODE' THEN
5202: IF p_in_rec.ship_method_code <> FND_API.G_MISS_CHAR
5203: OR p_in_rec.ship_method_code IS NULL THEN
5204: x_out_rec.ship_method_code := p_in_rec.ship_method_code ;
5205: END IF;
5206: ELSIF p_disabled_list(i) = 'CARRIER_ID' THEN
5203: OR p_in_rec.ship_method_code IS NULL THEN
5204: x_out_rec.ship_method_code := p_in_rec.ship_method_code ;
5205: END IF;
5206: ELSIF p_disabled_list(i) = 'CARRIER_ID' THEN
5207: IF p_in_rec.carrier_id <> FND_API.G_MISS_NUM
5208: OR p_in_rec.carrier_id IS NULL THEN
5209: x_out_rec.carrier_id := p_in_rec.carrier_id ;
5210: END IF;
5211: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT' THEN
5208: OR p_in_rec.carrier_id IS NULL THEN
5209: x_out_rec.carrier_id := p_in_rec.carrier_id ;
5210: END IF;
5211: ELSIF p_disabled_list(i) = 'MODE_OF_TRANSPORT' THEN
5212: IF p_in_rec.ship_method_code <> FND_API.G_MISS_CHAR
5213: OR p_in_rec.mode_of_transport IS NULL THEN
5214: x_out_rec.mode_of_transport := p_in_rec.mode_of_transport ;
5215: END IF;
5216: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL' THEN
5213: OR p_in_rec.mode_of_transport IS NULL THEN
5214: x_out_rec.mode_of_transport := p_in_rec.mode_of_transport ;
5215: END IF;
5216: ELSIF p_disabled_list(i) = 'SERVICE_LEVEL' THEN
5217: IF p_in_rec.service_level <> FND_API.G_MISS_CHAR
5218: OR p_in_rec.service_level IS NULL THEN
5219: x_out_rec.service_level := p_in_rec.service_level ;
5220: END IF;
5221: ELSIF p_disabled_list(i) = 'ITEM_NUMBER' THEN
5218: OR p_in_rec.service_level IS NULL THEN
5219: x_out_rec.service_level := p_in_rec.service_level ;
5220: END IF;
5221: ELSIF p_disabled_list(i) = 'ITEM_NUMBER' THEN
5222: IF nvl(p_in_rec.inventory_item_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
5223: THEN
5224: x_out_rec.inventory_item_id := p_in_rec.inventory_item_id ;
5225: END IF;
5226: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
5223: THEN
5224: x_out_rec.inventory_item_id := p_in_rec.inventory_item_id ;
5225: END IF;
5226: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
5227: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
5228: OR p_in_rec.attribute1 IS NULL THEN
5229: x_out_rec.attribute1 := p_in_rec.attribute1 ;
5230: END IF;
5231: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
5227: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
5228: OR p_in_rec.attribute1 IS NULL THEN
5229: x_out_rec.attribute1 := p_in_rec.attribute1 ;
5230: END IF;
5231: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
5232: OR p_in_rec.attribute2 IS NULL THEN
5233: x_out_rec.attribute2 := p_in_rec.attribute2 ;
5234: END IF;
5235: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
5231: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
5232: OR p_in_rec.attribute2 IS NULL THEN
5233: x_out_rec.attribute2 := p_in_rec.attribute2 ;
5234: END IF;
5235: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
5236: OR p_in_rec.attribute3 IS NULL THEN
5237: x_out_rec.attribute3 := p_in_rec.attribute3 ;
5238: END IF;
5239: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
5235: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
5236: OR p_in_rec.attribute3 IS NULL THEN
5237: x_out_rec.attribute3 := p_in_rec.attribute3 ;
5238: END IF;
5239: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
5240: OR p_in_rec.attribute4 IS NULL THEN
5241: x_out_rec.attribute4 := p_in_rec.attribute4 ;
5242: END IF;
5243: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
5239: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
5240: OR p_in_rec.attribute4 IS NULL THEN
5241: x_out_rec.attribute4 := p_in_rec.attribute4 ;
5242: END IF;
5243: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
5244: OR p_in_rec.attribute5 IS NULL THEN
5245: x_out_rec.attribute5 := p_in_rec.attribute5 ;
5246: END IF;
5247: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
5243: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
5244: OR p_in_rec.attribute5 IS NULL THEN
5245: x_out_rec.attribute5 := p_in_rec.attribute5 ;
5246: END IF;
5247: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
5248: OR p_in_rec.attribute6 IS NULL THEN
5249: x_out_rec.attribute6 := p_in_rec.attribute6 ;
5250: END IF;
5251: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
5247: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
5248: OR p_in_rec.attribute6 IS NULL THEN
5249: x_out_rec.attribute6 := p_in_rec.attribute6 ;
5250: END IF;
5251: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
5252: OR p_in_rec.attribute7 IS NULL THEN
5253: x_out_rec.attribute7 := p_in_rec.attribute7 ;
5254: END IF;
5255: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
5251: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
5252: OR p_in_rec.attribute7 IS NULL THEN
5253: x_out_rec.attribute7 := p_in_rec.attribute7 ;
5254: END IF;
5255: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
5256: OR p_in_rec.attribute8 IS NULL THEN
5257: x_out_rec.attribute8 := p_in_rec.attribute8 ;
5258: END IF;
5259: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
5255: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
5256: OR p_in_rec.attribute8 IS NULL THEN
5257: x_out_rec.attribute8 := p_in_rec.attribute8 ;
5258: END IF;
5259: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
5260: OR p_in_rec.attribute9 IS NULL THEN
5261: x_out_rec.attribute9 := p_in_rec.attribute9 ;
5262: END IF;
5263: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
5259: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
5260: OR p_in_rec.attribute9 IS NULL THEN
5261: x_out_rec.attribute9 := p_in_rec.attribute9 ;
5262: END IF;
5263: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
5264: OR p_in_rec.attribute10 IS NULL THEN
5265: x_out_rec.attribute10 := p_in_rec.attribute10 ;
5266: END IF;
5267: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
5263: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
5264: OR p_in_rec.attribute10 IS NULL THEN
5265: x_out_rec.attribute10 := p_in_rec.attribute10 ;
5266: END IF;
5267: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
5268: OR p_in_rec.attribute11 IS NULL THEN
5269: x_out_rec.attribute11 := p_in_rec.attribute11 ;
5270: END IF;
5271: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
5267: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
5268: OR p_in_rec.attribute11 IS NULL THEN
5269: x_out_rec.attribute11 := p_in_rec.attribute11 ;
5270: END IF;
5271: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
5272: OR p_in_rec.attribute12 IS NULL THEN
5273: x_out_rec.attribute12 := p_in_rec.attribute12 ;
5274: END IF;
5275: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
5271: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
5272: OR p_in_rec.attribute12 IS NULL THEN
5273: x_out_rec.attribute12 := p_in_rec.attribute12 ;
5274: END IF;
5275: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
5276: OR p_in_rec.attribute13 IS NULL THEN
5277: x_out_rec.attribute13 := p_in_rec.attribute13 ;
5278: END IF;
5279: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
5275: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
5276: OR p_in_rec.attribute13 IS NULL THEN
5277: x_out_rec.attribute13 := p_in_rec.attribute13 ;
5278: END IF;
5279: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
5280: OR p_in_rec.attribute14 IS NULL THEN
5281: x_out_rec.attribute14 := p_in_rec.attribute14 ;
5282: END IF;
5283: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
5279: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
5280: OR p_in_rec.attribute14 IS NULL THEN
5281: x_out_rec.attribute14 := p_in_rec.attribute14 ;
5282: END IF;
5283: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
5284: OR p_in_rec.attribute15 IS NULL THEN
5285: x_out_rec.attribute15 := p_in_rec.attribute15 ;
5286: END IF;
5287: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
5283: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
5284: OR p_in_rec.attribute15 IS NULL THEN
5285: x_out_rec.attribute15 := p_in_rec.attribute15 ;
5286: END IF;
5287: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
5288: OR p_in_rec.attribute_category IS NULL THEN
5289: x_out_rec.attribute_category := p_in_rec.attribute_category ;
5290: END IF;
5291: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
5288: OR p_in_rec.attribute_category IS NULL THEN
5289: x_out_rec.attribute_category := p_in_rec.attribute_category ;
5290: END IF;
5291: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
5292: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
5293: OR p_in_rec.tp_attribute1 IS NULL THEN
5294: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
5295: END IF;
5296: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
5292: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
5293: OR p_in_rec.tp_attribute1 IS NULL THEN
5294: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
5295: END IF;
5296: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
5297: OR p_in_rec.tp_attribute2 IS NULL THEN
5298: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
5299: END IF;
5300: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
5296: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
5297: OR p_in_rec.tp_attribute2 IS NULL THEN
5298: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
5299: END IF;
5300: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
5301: OR p_in_rec.tp_attribute3 IS NULL THEN
5302: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
5303: END IF;
5304: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
5300: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
5301: OR p_in_rec.tp_attribute3 IS NULL THEN
5302: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
5303: END IF;
5304: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
5305: OR p_in_rec.tp_attribute4 IS NULL THEN
5306: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
5307: END IF;
5308: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
5304: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
5305: OR p_in_rec.tp_attribute4 IS NULL THEN
5306: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
5307: END IF;
5308: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
5309: OR p_in_rec.tp_attribute5 IS NULL THEN
5310: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
5311: END IF;
5312: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
5308: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
5309: OR p_in_rec.tp_attribute5 IS NULL THEN
5310: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
5311: END IF;
5312: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
5313: OR p_in_rec.tp_attribute6 IS NULL THEN
5314: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
5315: END IF;
5316: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
5312: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
5313: OR p_in_rec.tp_attribute6 IS NULL THEN
5314: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
5315: END IF;
5316: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
5317: OR p_in_rec.tp_attribute7 IS NULL THEN
5318: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
5319: END IF;
5320: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
5316: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
5317: OR p_in_rec.tp_attribute7 IS NULL THEN
5318: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
5319: END IF;
5320: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
5321: OR p_in_rec.tp_attribute8 IS NULL THEN
5322: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
5323: END IF;
5324: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
5320: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
5321: OR p_in_rec.tp_attribute8 IS NULL THEN
5322: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
5323: END IF;
5324: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
5325: OR p_in_rec.tp_attribute9 IS NULL THEN
5326: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
5327: END IF;
5328: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
5324: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
5325: OR p_in_rec.tp_attribute9 IS NULL THEN
5326: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
5327: END IF;
5328: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
5329: OR p_in_rec.tp_attribute10 IS NULL THEN
5330: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
5331: END IF;
5332: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
5328: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
5329: OR p_in_rec.tp_attribute10 IS NULL THEN
5330: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
5331: END IF;
5332: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
5333: OR p_in_rec.tp_attribute11 IS NULL THEN
5334: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
5335: END IF;
5336: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
5332: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
5333: OR p_in_rec.tp_attribute11 IS NULL THEN
5334: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
5335: END IF;
5336: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
5337: OR p_in_rec.tp_attribute12 IS NULL THEN
5338: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
5339: END IF;
5340: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
5336: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
5337: OR p_in_rec.tp_attribute12 IS NULL THEN
5338: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
5339: END IF;
5340: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
5341: OR p_in_rec.tp_attribute13 IS NULL THEN
5342: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
5343: END IF;
5344: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
5340: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
5341: OR p_in_rec.tp_attribute13 IS NULL THEN
5342: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
5343: END IF;
5344: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
5345: OR p_in_rec.tp_attribute14 IS NULL THEN
5346: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
5347: END IF;
5348: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
5344: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
5345: OR p_in_rec.tp_attribute14 IS NULL THEN
5346: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
5347: END IF;
5348: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
5349: OR p_in_rec.tp_attribute15 IS NULL THEN
5350: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
5351: END IF;
5352: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
5348: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
5349: OR p_in_rec.tp_attribute15 IS NULL THEN
5350: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
5351: END IF;
5352: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
5353: OR p_in_rec.tp_attribute_category IS NULL THEN
5354: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
5355: END IF;
5356: -- Commenting out Tare Weight field to make it enable for
5655: WSH_DEBUG_SV.log(l_module_name,'p_action',p_in_rec.action_code);
5656: wsh_debug_sv.log(l_module_name, 'Caller', p_in_rec.caller);
5657: END IF;
5658: --
5659: x_return_status := FND_API.G_RET_STS_SUCCESS;
5660: --
5661: IF p_in_rec.action_code = 'CREATE' THEN
5662: IF l_debug_on THEN
5663: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
5681:
5682: -- Added for bug 4399278, 4418754
5683: IF ( p_in_rec.caller = 'WSH_PUB' and
5684: p_delivery_detail_rec.subinventory is not null and
5685: p_delivery_detail_rec.subinventory <> FND_API.G_MISS_CHAR ) THEN
5686: G_SUBINVENTORY := p_delivery_detail_rec.subinventory;
5687: END IF;
5688:
5689: Get_Disabled_List( p_delivery_detail_rec.DELIVERY_DETAIL_ID
5733: i := l_disabled_list.COUNT;
5734:
5735: IF (l_released_status = 'Y') THEN
5736:
5737: IF p_delivery_detail_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
5738:
5739: l_inventory_item_id := x_delivery_detail_rec.inventory_item_id;
5740:
5741: ELSE
5742:
5743: l_inventory_item_id := p_delivery_detail_rec.inventory_item_id;
5744:
5745: END IF;
5746: IF p_delivery_detail_rec.organization_id = FND_API.G_MISS_NUM THEN
5747:
5748: l_organization_id := x_delivery_detail_rec.organization_id;
5749:
5750: ELSE
5751:
5752: l_organization_id := p_delivery_detail_rec.organization_id;
5753:
5754: END IF;
5755: IF p_delivery_detail_rec.pickable_flag = FND_API.G_MISS_CHAR THEN
5756:
5757: l_pickable_flag := x_delivery_detail_rec.pickable_flag;
5758:
5759: ELSE
5760:
5761: l_pickable_flag := p_delivery_detail_rec.pickable_flag;
5762:
5763: END IF;
5764: IF p_delivery_detail_rec.subinventory = FND_API.G_MISS_CHAR THEN
5765:
5766: l_subinventory := x_delivery_detail_rec.subinventory;
5767:
5768:
5877: close get_delivery_status;
5878: END IF;
5879: --
5880: -- lpn conv.
5881: IF (nvl(l_organization_id, fnd_api.g_miss_num) = fnd_api.g_miss_num) THEN
5882: l_organization_id := x_delivery_detail_rec.organization_id;
5883: END IF;
5884:
5885: IF l_debug_on THEN
6556: l_field_name := 'cycle_count_quantity';
6557: --
6558: ELSE
6559: -- invalid flag
6560: raise fnd_api.g_exc_error;
6561: END IF;
6562: open c_detail_info(x_det_rec.delivery_detail_id);
6563: fetch c_detail_info INTO l_det_source_code, l_det_source_line_id;
6564: close c_detail_info;
6591: x_return_status => l_return_status );
6592: --
6593:
6594: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6595: RAISE FND_API.G_EXC_ERROR;
6596: END IF;
6597:
6598:
6599: -- 3) check for decimal
6624: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
6625: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6626: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6627: ELSE
6628: RAISE FND_API.G_EXC_ERROR;
6629: END IF;
6630: END IF;
6631:
6632: -- HW OPM bug 2677054
6651: p_fulfill_base => 'P',
6652: x_return_status => l_return_status);
6653:
6654: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;
6657:
6658:
6659: ELSIF(p_flag = 'CCQ') THEN
6672: p_fulfill_base => 'P',
6673: x_return_status => l_return_status);
6674:
6675: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6676: RAISE FND_API.G_EXC_ERROR;
6677: END IF;
6678: END IF;
6679: END IF;-- }
6680:
6718: wsh_debug_sv.log(l_module_name, 'Return status after Unmark serial', l_return_status);
6719: END IF;
6720:
6721: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6722: RAISE FND_API.G_EXC_ERROR;
6723: END IF;
6724: END IF; -- if serial_quantity > 0
6725:
6726: x_det_rec.serial_quantity := 0;
6762: wsh_debug_sv.log(l_module_name, 'Return status after Unmark serial', l_return_status);
6763: END IF;
6764:
6765: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6766: RAISE FND_API.G_EXC_ERROR;
6767: END IF;
6768: END IF; -- if serial_quantity > 0
6769:
6770: x_det_rec.serial_quantity := 0;
6798: WSH_DEBUG_SV.pop(l_module_name);
6799: END IF;
6800:
6801: EXCEPTION
6802: WHEN FND_API.G_EXC_ERROR THEN
6803: x_return_status := FND_API.G_RET_STS_ERROR ;
6804: wsh_util_core.add_message(x_return_status, l_module_name);
6805: FND_MSG_PUB.Count_And_Get
6806: (
6799: END IF;
6800:
6801: EXCEPTION
6802: WHEN FND_API.G_EXC_ERROR THEN
6803: x_return_status := FND_API.G_RET_STS_ERROR ;
6804: wsh_util_core.add_message(x_return_status, l_module_name);
6805: FND_MSG_PUB.Count_And_Get
6806: (
6807: p_count => x_msg_count,
6805: FND_MSG_PUB.Count_And_Get
6806: (
6807: p_count => x_msg_count,
6808: p_data => x_msg_data,
6809: p_encoded => FND_API.G_FALSE
6810: );
6811:
6812: IF l_debug_on THEN
6813: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6809: p_encoded => FND_API.G_FALSE
6810: );
6811:
6812: IF l_debug_on THEN
6813: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6815: END IF;
6816: --
6817: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6810: );
6811:
6812: IF l_debug_on THEN
6813: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6815: END IF;
6816: --
6817: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6818: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6820: FND_MSG_PUB.Count_And_Get
6821: (
6822: p_count => x_msg_count,
6823: p_data => x_msg_data,
6824: p_encoded => FND_API.G_FALSE
6825: );
6826: --
6827: IF l_debug_on THEN
6828: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6828: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
6830: END IF;
6831:
6832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6834: FND_MSG_PUB.Count_And_Get
6835: (
6836: p_count => x_msg_count,
6829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
6830: END IF;
6831:
6832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6834: FND_MSG_PUB.Count_And_Get
6835: (
6836: p_count => x_msg_count,
6837: p_data => x_msg_data,
6834: FND_MSG_PUB.Count_And_Get
6835: (
6836: p_count => x_msg_count,
6837: p_data => x_msg_data,
6838: p_encoded => FND_API.G_FALSE
6839: );
6840:
6841: IF l_debug_on THEN
6842: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6838: p_encoded => FND_API.G_FALSE
6839: );
6840:
6841: IF l_debug_on THEN
6842: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6843: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6844: END IF;
6845: --
6846: WHEN OTHERS THEN
6839: );
6840:
6841: IF l_debug_on THEN
6842: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6843: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6844: END IF;
6845: --
6846: WHEN OTHERS THEN
6847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6843: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6844: END IF;
6845: --
6846: WHEN OTHERS THEN
6847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6848: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY');
6849: --
6850: IF l_debug_on THEN
6851: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6936: l_field_name := 'cycle_count_quantity2';
6937: --
6938: ELSE
6939: -- invalid flag
6940: raise fnd_api.g_exc_error;
6941: END IF;
6942:
6943: --1.a) if entered, enable backordered quantity and update it as max(requested_quantity2 - shipped_quantity2),0)
6944: --1.b) if null, clear cycle count and secondary quantity
6979: x_return_status => l_return_status );
6980: --
6981:
6982: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6983: RAISE FND_API.G_EXC_ERROR;
6984: END IF;
6985:
6986: -- HW OPM BUG#:2677054
6987: IF(p_flag = 'SQ') THEN
7013: p_fulfill_base => 'S',
7014: x_return_status => l_return_status);
7015:
7016: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
7017: RAISE FND_API.G_EXC_ERROR;
7018: END IF;
7019: ELSIF(p_flag = 'CCQ') THEN
7020:
7021: IF l_debug_on THEN
7031: p_fulfill_base => 'S',
7032: x_return_status => l_return_status);
7033:
7034: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
7035: RAISE FND_API.G_EXC_ERROR;
7036: END IF;
7037: END IF;
7038: END IF;
7039:
7052: WSH_DEBUG_SV.pop(l_module_name);
7053: END IF;
7054:
7055: EXCEPTION
7056: WHEN FND_API.G_EXC_ERROR THEN
7057: x_return_status := FND_API.G_RET_STS_ERROR ;
7058: FND_MSG_PUB.Count_And_Get
7059: (
7060: p_count => x_msg_count,
7053: END IF;
7054:
7055: EXCEPTION
7056: WHEN FND_API.G_EXC_ERROR THEN
7057: x_return_status := FND_API.G_RET_STS_ERROR ;
7058: FND_MSG_PUB.Count_And_Get
7059: (
7060: p_count => x_msg_count,
7061: p_data => x_msg_data,
7058: FND_MSG_PUB.Count_And_Get
7059: (
7060: p_count => x_msg_count,
7061: p_data => x_msg_data,
7062: p_encoded => FND_API.G_FALSE
7063: );
7064:
7065: IF l_debug_on THEN
7066: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7062: p_encoded => FND_API.G_FALSE
7063: );
7064:
7065: IF l_debug_on THEN
7066: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7067: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7068: END IF;
7069: --
7070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7063: );
7064:
7065: IF l_debug_on THEN
7066: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7067: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7068: END IF;
7069: --
7070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7066: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7067: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7068: END IF;
7069: --
7070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7072: FND_MSG_PUB.Count_And_Get
7073: (
7074: p_count => x_msg_count,
7067: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7068: END IF;
7069: --
7070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7072: FND_MSG_PUB.Count_And_Get
7073: (
7074: p_count => x_msg_count,
7075: p_data => x_msg_data,
7072: FND_MSG_PUB.Count_And_Get
7073: (
7074: p_count => x_msg_count,
7075: p_data => x_msg_data,
7076: p_encoded => FND_API.G_FALSE
7077: );
7078:
7079: IF l_debug_on THEN
7080: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7076: p_encoded => FND_API.G_FALSE
7077: );
7078:
7079: IF l_debug_on THEN
7080: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7082: END IF;
7083: --
7084: WHEN OTHERS THEN
7077: );
7078:
7079: IF l_debug_on THEN
7080: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7082: END IF;
7083: --
7084: WHEN OTHERS THEN
7085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7082: END IF;
7083: --
7084: WHEN OTHERS THEN
7085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7086: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2');
7087: --
7088: IF l_debug_on THEN
7089: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7333: THEN
7334: --{
7335: fnd_message.set_name('WSH', 'WSH_REQUIRED_FIELD_NULL');
7336: fnd_message.set_token('FIELD_NAME','x_quantity');
7337: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7338: RAISE FND_API.G_EXC_ERROR;
7339: --}
7340: /* HW BUG 4548713- Removed checking for Qty being 0
7341: ELSIF x_quantity = 0
7334: --{
7335: fnd_message.set_name('WSH', 'WSH_REQUIRED_FIELD_NULL');
7336: fnd_message.set_token('FIELD_NAME','x_quantity');
7337: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7338: RAISE FND_API.G_EXC_ERROR;
7339: --}
7340: /* HW BUG 4548713- Removed checking for Qty being 0
7341: ELSIF x_quantity = 0
7342: THEN
7342: THEN
7343: --{
7344: --
7345: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
7346: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7347: RAISE FND_API.G_EXC_ERROR;
7348: --}
7349: */
7350: ELSIF x_quantity < 0
7343: --{
7344: --
7345: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
7346: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7347: RAISE FND_API.G_EXC_ERROR;
7348: --}
7349: */
7350: ELSIF x_quantity < 0
7351: THEN
7350: ELSIF x_quantity < 0
7351: THEN
7352: --{
7353: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
7354: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7355: RAISE FND_API.G_EXC_ERROR;
7356: --}
7357: END IF;
7358: --
7351: THEN
7352: --{
7353: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
7354: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7355: RAISE FND_API.G_EXC_ERROR;
7356: --}
7357: END IF;
7358: --
7359: --
7366: THEN
7367: --{
7368: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
7369: fnd_message.set_token('DETAIL_ID',p_delivery_detail_id);
7370: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7371: RAISE FND_API.G_EXC_ERROR;
7372: --}
7373: END IF;
7374: --
7367: --{
7368: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
7369: fnd_message.set_token('DETAIL_ID',p_delivery_detail_id);
7370: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7371: RAISE FND_API.G_EXC_ERROR;
7372: --}
7373: END IF;
7374: --
7375: --
7429: AND l_item_info.secondary_default_ind in ('F','D','N')
7430: THEN
7431: --{
7432: fnd_message.set_name('WSH', 'WSH_OPM_SEC_QTY_REQD_ERROR');
7433: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7434: RAISE FND_API.G_EXC_ERROR;
7435: --}
7436: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7437: -- HW BUG 4548713 - Added check for x_quantity
7430: THEN
7431: --{
7432: fnd_message.set_name('WSH', 'WSH_OPM_SEC_QTY_REQD_ERROR');
7433: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7434: RAISE FND_API.G_EXC_ERROR;
7435: --}
7436: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7437: -- HW BUG 4548713 - Added check for x_quantity
7438: ELSIF x_quantity2 = 0
7443: --
7444:
7445:
7446: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
7447: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7448: RAISE FND_API.G_EXC_ERROR;
7449: --}
7450: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7451: ELSIF x_quantity2 < 0
7444:
7445:
7446: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
7447: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7448: RAISE FND_API.G_EXC_ERROR;
7449: --}
7450: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7451: ELSIF x_quantity2 < 0
7452: AND l_item_info.secondary_default_ind in ('F','D','N')
7452: AND l_item_info.secondary_default_ind in ('F','D','N')
7453: THEN
7454: --{
7455: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
7456: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7457: RAISE FND_API.G_EXC_ERROR;
7458: --}
7459: END IF;
7460: --
7453: THEN
7454: --{
7455: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
7456: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7457: RAISE FND_API.G_EXC_ERROR;
7458: --}
7459: END IF;
7460: --
7461: --
7474: IF lot_csr%NOTFOUND
7475: THEN
7476: --{
7477: --fnd_message.set_name('GMI', 'IC_INVALID_LOT');
7478: --wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7479: RAISE INVALID_LOT;
7480: --}
7481: END IF;
7482: --
7552: );
7553: --
7554: IF ( l_qty2 <= 0 ) THEN
7555: FND_MESSAGE.SET_NAME('wsh','WSH_UPDATE_CANNOT_SPLIT');
7556: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7557: RAISE FND_API.G_EXC_ERROR;
7558: END IF;
7559: --
7560: IF l_qty2 <> x_quantity2
7553: --
7554: IF ( l_qty2 <= 0 ) THEN
7555: FND_MESSAGE.SET_NAME('wsh','WSH_UPDATE_CANNOT_SPLIT');
7556: wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7557: RAISE FND_API.G_EXC_ERROR;
7558: END IF;
7559: --
7560: IF l_qty2 <> x_quantity2
7561: THEN
7562: --{
7563: FND_MESSAGE.SET_NAME('WSH','WSH_OPM_QTY_ERROR');
7564: FND_MESSAGE.SET_TOKEN('QUANTITY2',x_quantity2);
7565: FND_MESSAGE.SET_TOKEN('CONV_QUANTITY2',l_qty2);
7566: --wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7567: --RAISE FND_API.G_EXC_ERROR;
7568: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);
7569: l_number_of_warnings := NVL(l_number_of_warnings,0) + 1;
7570: --}
7563: FND_MESSAGE.SET_NAME('WSH','WSH_OPM_QTY_ERROR');
7564: FND_MESSAGE.SET_TOKEN('QUANTITY2',x_quantity2);
7565: FND_MESSAGE.SET_TOKEN('CONV_QUANTITY2',l_qty2);
7566: --wsh_util_core.add_message(FND_API.G_RET_STS_ERROR, l_module_name);
7567: --RAISE FND_API.G_EXC_ERROR;
7568: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);
7569: l_number_of_warnings := NVL(l_number_of_warnings,0) + 1;
7570: --}
7571: END IF;
7584: --
7585: fnd_msg_pub.count_and_get(
7586: p_count => x_msg_count,
7587: p_data => x_msg_data,
7588: p_encoded => fnd_api.g_false);
7589:
7590: IF l_debug_on THEN
7591: wsh_debug_sv.LOG(l_module_name, 'X_QUANTITY2', x_quantity2);
7592: wsh_debug_sv.pop(l_module_name);
7594: --
7595: --}
7596: EXCEPTION
7597: WHEN e_end_of_api THEN
7598: x_return_status := fnd_api.g_ret_sts_success;
7599: fnd_msg_pub.count_and_get(
7600: p_count => x_msg_count,
7601: p_data => x_msg_data,
7602: p_encoded => fnd_api.g_false);
7598: x_return_status := fnd_api.g_ret_sts_success;
7599: fnd_msg_pub.count_and_get(
7600: p_count => x_msg_count,
7601: p_data => x_msg_data,
7602: p_encoded => fnd_api.g_false);
7603: --
7604: IF l_debug_on THEN
7605: wsh_debug_sv.pop(l_module_name);
7606: END IF;
7606: END IF;
7607: --
7608:
7609: WHEN INVALID_LOT THEN
7610: x_return_status := fnd_api.g_ret_sts_error;
7611: IF l_debug_on THEN
7612: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7613: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Lot Number');
7614: END IF;
7608:
7609: WHEN INVALID_LOT THEN
7610: x_return_status := fnd_api.g_ret_sts_error;
7611: IF l_debug_on THEN
7612: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7613: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Lot Number');
7614: END IF;
7615:
7616: WHEN OUT_OF_DEVIATION THEN
7613: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Lot Number');
7614: END IF;
7615:
7616: WHEN OUT_OF_DEVIATION THEN
7617: x_return_status := fnd_api.g_ret_sts_error;
7618: IF l_debug_on THEN
7619: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7620: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7621: END IF;
7615:
7616: WHEN OUT_OF_DEVIATION THEN
7617: x_return_status := fnd_api.g_ret_sts_error;
7618: IF l_debug_on THEN
7619: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7620: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7621: END IF;
7622:
7623: WHEN fnd_api.g_exc_error THEN
7616: WHEN OUT_OF_DEVIATION THEN
7617: x_return_status := fnd_api.g_ret_sts_error;
7618: IF l_debug_on THEN
7619: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7620: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7621: END IF;
7622:
7623: WHEN fnd_api.g_exc_error THEN
7624: x_return_status := fnd_api.g_ret_sts_error;
7619: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7620: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7621: END IF;
7622:
7623: WHEN fnd_api.g_exc_error THEN
7624: x_return_status := fnd_api.g_ret_sts_error;
7625: fnd_msg_pub.count_and_get(
7626: p_count => x_msg_count,
7627: p_data => x_msg_data,
7620: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7621: END IF;
7622:
7623: WHEN fnd_api.g_exc_error THEN
7624: x_return_status := fnd_api.g_ret_sts_error;
7625: fnd_msg_pub.count_and_get(
7626: p_count => x_msg_count,
7627: p_data => x_msg_data,
7628: p_encoded => fnd_api.g_false);
7624: x_return_status := fnd_api.g_ret_sts_error;
7625: fnd_msg_pub.count_and_get(
7626: p_count => x_msg_count,
7627: p_data => x_msg_data,
7628: p_encoded => fnd_api.g_false);
7629: --
7630: IF l_debug_on THEN
7631: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7632: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7627: p_data => x_msg_data,
7628: p_encoded => fnd_api.g_false);
7629: --
7630: IF l_debug_on THEN
7631: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7632: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7633: END IF;
7634: --
7635: WHEN fnd_api.g_exc_unexpected_error THEN
7628: p_encoded => fnd_api.g_false);
7629: --
7630: IF l_debug_on THEN
7631: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7632: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7633: END IF;
7634: --
7635: WHEN fnd_api.g_exc_unexpected_error THEN
7636: x_return_status := fnd_api.g_ret_sts_unexp_error;
7631: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7632: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7633: END IF;
7634: --
7635: WHEN fnd_api.g_exc_unexpected_error THEN
7636: x_return_status := fnd_api.g_ret_sts_unexp_error;
7637: fnd_msg_pub.count_and_get(
7638: p_count => x_msg_count,
7639: p_data => x_msg_data,
7632: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
7633: END IF;
7634: --
7635: WHEN fnd_api.g_exc_unexpected_error THEN
7636: x_return_status := fnd_api.g_ret_sts_unexp_error;
7637: fnd_msg_pub.count_and_get(
7638: p_count => x_msg_count,
7639: p_data => x_msg_data,
7640: p_encoded => fnd_api.g_false);
7636: x_return_status := fnd_api.g_ret_sts_unexp_error;
7637: fnd_msg_pub.count_and_get(
7638: p_count => x_msg_count,
7639: p_data => x_msg_data,
7640: p_encoded => fnd_api.g_false);
7641: --
7642: IF l_debug_on THEN
7643: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7644: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7639: p_data => x_msg_data,
7640: p_encoded => fnd_api.g_false);
7641: --
7642: IF l_debug_on THEN
7643: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7644: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7645: END IF;
7646: --
7647: WHEN wsh_util_core.g_exc_warning THEN
7640: p_encoded => fnd_api.g_false);
7641: --
7642: IF l_debug_on THEN
7643: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
7644: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7645: END IF;
7646: --
7647: WHEN wsh_util_core.g_exc_warning THEN
7648: x_return_status := wsh_util_core.g_ret_sts_warning;
7648: x_return_status := wsh_util_core.g_ret_sts_warning;
7649: fnd_msg_pub.count_and_get(
7650: p_count => x_msg_count,
7651: p_data => x_msg_data,
7652: p_encoded => fnd_api.g_false);
7653: --
7654: IF l_debug_on THEN
7655: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
7656: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7655: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
7656: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7657: END IF;
7658: WHEN OTHERS THEN
7659: x_return_status := fnd_api.g_ret_sts_unexp_error;
7660: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',l_module_name);
7661: --
7662: fnd_msg_pub.count_and_get(
7663: p_count => x_msg_count,
7661: --
7662: fnd_msg_pub.count_and_get(
7663: p_count => x_msg_count,
7664: p_data => x_msg_data,
7665: p_encoded => fnd_api.g_false);
7666: --
7667: IF l_debug_on THEN
7668: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
7669: END IF;
7699: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
7700: --
7701: END IF;
7702: --
7703: x_return_status := FND_API.G_RET_STS_SUCCESS;
7704: --
7705: IF p_user_in_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM
7706: AND NVL(p_user_in_rec.DELIVERY_DETAIL_ID,-99) <> NVL(p_out_rec.DELIVERY_DETAIL_ID,-99)
7707: THEN
7701: END IF;
7702: --
7703: x_return_status := FND_API.G_RET_STS_SUCCESS;
7704: --
7705: IF p_user_in_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM
7706: AND NVL(p_user_in_rec.DELIVERY_DETAIL_ID,-99) <> NVL(p_out_rec.DELIVERY_DETAIL_ID,-99)
7707: THEN
7708: l_attributes := l_attributes || 'DELIVERY_DETAIL_ID, ';
7709: END IF;
7707: THEN
7708: l_attributes := l_attributes || 'DELIVERY_DETAIL_ID, ';
7709: END IF;
7710:
7711: IF p_user_in_rec.SOURCE_CODE <> FND_API.G_MISS_CHAR
7712: AND NVL(p_user_in_rec.SOURCE_CODE,'!!!') <> NVL(p_out_rec.SOURCE_CODE,'!!!')
7713: THEN
7714: l_attributes := l_attributes || 'SOURCE_CODE, ';
7715: END IF;
7713: THEN
7714: l_attributes := l_attributes || 'SOURCE_CODE, ';
7715: END IF;
7716:
7717: IF p_user_in_rec.SOURCE_HEADER_ID <> FND_API.G_MISS_NUM
7718: AND NVL(p_user_in_rec.SOURCE_HEADER_ID,-99) <> NVL(p_out_rec.SOURCE_HEADER_ID,-99)
7719: THEN
7720: l_attributes := l_attributes || 'SOURCE_HEADER_ID, ';
7721: END IF;
7719: THEN
7720: l_attributes := l_attributes || 'SOURCE_HEADER_ID, ';
7721: END IF;
7722:
7723: IF p_user_in_rec.SOURCE_LINE_ID <> FND_API.G_MISS_NUM
7724: AND NVL(p_user_in_rec.SOURCE_LINE_ID,-99) <> NVL(p_out_rec.SOURCE_LINE_ID,-99)
7725: THEN
7726: l_attributes := l_attributes || 'SOURCE_LINE_ID, ';
7727: END IF;
7725: THEN
7726: l_attributes := l_attributes || 'SOURCE_LINE_ID, ';
7727: END IF;
7728:
7729: IF p_user_in_rec.CUSTOMER_ID <> FND_API.G_MISS_NUM
7730: AND NVL(p_user_in_rec.CUSTOMER_ID,-99) <> NVL(p_out_rec.CUSTOMER_ID,-99)
7731: THEN
7732: l_attributes := l_attributes || 'CUSTOMER_ID, ';
7733: END IF;
7731: THEN
7732: l_attributes := l_attributes || 'CUSTOMER_ID, ';
7733: END IF;
7734:
7735: IF p_user_in_rec.SOLD_TO_CONTACT_ID <> FND_API.G_MISS_NUM
7736: AND NVL(p_user_in_rec.SOLD_TO_CONTACT_ID,-99) <> NVL(p_out_rec.SOLD_TO_CONTACT_ID,-99)
7737: THEN
7738: l_attributes := l_attributes || 'SOLD_TO_CONTACT_ID, ';
7739: END IF;
7737: THEN
7738: l_attributes := l_attributes || 'SOLD_TO_CONTACT_ID, ';
7739: END IF;
7740:
7741: IF p_user_in_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM
7742: AND NVL(p_user_in_rec.INVENTORY_ITEM_ID,-99) <> NVL(p_out_rec.INVENTORY_ITEM_ID,-99)
7743: THEN
7744: l_attributes := l_attributes || 'INVENTORY_ITEM_ID, ';
7745: END IF;
7743: THEN
7744: l_attributes := l_attributes || 'INVENTORY_ITEM_ID, ';
7745: END IF;
7746:
7747: IF p_user_in_rec.ITEM_DESCRIPTION <> FND_API.G_MISS_CHAR
7748: AND NVL(p_user_in_rec.ITEM_DESCRIPTION,'!!!') <> NVL(p_out_rec.ITEM_DESCRIPTION,'!!!')
7749: THEN
7750: l_attributes := l_attributes || 'ITEM_DESCRIPTION, ';
7751: END IF;
7749: THEN
7750: l_attributes := l_attributes || 'ITEM_DESCRIPTION, ';
7751: END IF;
7752:
7753: IF p_user_in_rec.HAZARD_CLASS_ID <> FND_API.G_MISS_NUM
7754: AND NVL(p_user_in_rec.HAZARD_CLASS_ID,-99) <> NVL(p_out_rec.HAZARD_CLASS_ID,-99)
7755: THEN
7756: l_attributes := l_attributes || 'HAZARD_CLASS_ID, ';
7757: END IF;
7755: THEN
7756: l_attributes := l_attributes || 'HAZARD_CLASS_ID, ';
7757: END IF;
7758:
7759: IF p_user_in_rec.COUNTRY_OF_ORIGIN <> FND_API.G_MISS_CHAR
7760: AND NVL(p_user_in_rec.COUNTRY_OF_ORIGIN,'!!!') <> NVL(p_out_rec.COUNTRY_OF_ORIGIN,'!!!')
7761: THEN
7762: l_attributes := l_attributes || 'COUNTRY_OF_ORIGIN, ';
7763: END IF;
7761: THEN
7762: l_attributes := l_attributes || 'COUNTRY_OF_ORIGIN, ';
7763: END IF;
7764:
7765: IF p_user_in_rec.CLASSIFICATION <> FND_API.G_MISS_CHAR
7766: AND NVL(p_user_in_rec.CLASSIFICATION,'!!!') <> NVL(p_out_rec.CLASSIFICATION,'!!!')
7767: THEN
7768: l_attributes := l_attributes || 'CLASSIFICATION, ';
7769: END IF;
7767: THEN
7768: l_attributes := l_attributes || 'CLASSIFICATION, ';
7769: END IF;
7770:
7771: IF p_user_in_rec.SHIP_FROM_LOCATION_ID <> FND_API.G_MISS_NUM
7772: AND NVL(p_user_in_rec.SHIP_FROM_LOCATION_ID,-99) <> NVL(p_out_rec.SHIP_FROM_LOCATION_ID,-99)
7773: THEN
7774: l_attributes := l_attributes || 'SHIP_FROM_LOCATION_ID, ';
7775: END IF;
7773: THEN
7774: l_attributes := l_attributes || 'SHIP_FROM_LOCATION_ID, ';
7775: END IF;
7776:
7777: IF p_user_in_rec.SHIP_TO_LOCATION_ID <> FND_API.G_MISS_NUM
7778: AND NVL(p_user_in_rec.SHIP_TO_LOCATION_ID,-99) <> NVL(p_out_rec.SHIP_TO_LOCATION_ID,-99)
7779: THEN
7780: l_attributes := l_attributes || 'SHIP_TO_LOCATION_ID, ';
7781: END IF;
7779: THEN
7780: l_attributes := l_attributes || 'SHIP_TO_LOCATION_ID, ';
7781: END IF;
7782:
7783: IF p_user_in_rec.SHIP_TO_CONTACT_ID <> FND_API.G_MISS_NUM
7784: AND NVL(p_user_in_rec.SHIP_TO_CONTACT_ID,-99) <> NVL(p_out_rec.SHIP_TO_CONTACT_ID,-99)
7785: THEN
7786: l_attributes := l_attributes || 'SHIP_TO_CONTACT_ID, ';
7787: END IF;
7785: THEN
7786: l_attributes := l_attributes || 'SHIP_TO_CONTACT_ID, ';
7787: END IF;
7788:
7789: IF p_user_in_rec.SHIP_TO_SITE_USE_ID <> FND_API.G_MISS_NUM
7790: AND NVL(p_user_in_rec.SHIP_TO_SITE_USE_ID,-99) <> NVL(p_out_rec.SHIP_TO_SITE_USE_ID,-99)
7791: THEN
7792: l_attributes := l_attributes || 'SHIP_TO_SITE_USE_ID, ';
7793: END IF;
7791: THEN
7792: l_attributes := l_attributes || 'SHIP_TO_SITE_USE_ID, ';
7793: END IF;
7794:
7795: IF p_user_in_rec.DELIVER_TO_LOCATION_ID <> FND_API.G_MISS_NUM
7796: AND NVL(p_user_in_rec.DELIVER_TO_LOCATION_ID,-99) <> NVL(p_out_rec.DELIVER_TO_LOCATION_ID,-99)
7797: THEN
7798: l_attributes := l_attributes || 'DELIVER_TO_LOCATION_ID, ';
7799: END IF;
7797: THEN
7798: l_attributes := l_attributes || 'DELIVER_TO_LOCATION_ID, ';
7799: END IF;
7800:
7801: IF p_user_in_rec.DELIVER_TO_CONTACT_ID <> FND_API.G_MISS_NUM
7802: AND NVL(p_user_in_rec.DELIVER_TO_CONTACT_ID,-99) <> NVL(p_out_rec.DELIVER_TO_CONTACT_ID,-99)
7803: THEN
7804: l_attributes := l_attributes || 'DELIVER_TO_CONTACT_ID, ';
7805: END IF;
7803: THEN
7804: l_attributes := l_attributes || 'DELIVER_TO_CONTACT_ID, ';
7805: END IF;
7806:
7807: IF p_user_in_rec.DELIVER_TO_SITE_USE_ID <> FND_API.G_MISS_NUM
7808: AND NVL(p_user_in_rec.DELIVER_TO_SITE_USE_ID,-99) <> NVL(p_out_rec.DELIVER_TO_SITE_USE_ID,-99)
7809: THEN
7810: l_attributes := l_attributes || 'DELIVER_TO_SITE_USE_ID, ';
7811: END IF;
7809: THEN
7810: l_attributes := l_attributes || 'DELIVER_TO_SITE_USE_ID, ';
7811: END IF;
7812:
7813: IF p_user_in_rec.INTMED_SHIP_TO_LOCATION_ID <> FND_API.G_MISS_NUM
7814: AND NVL(p_user_in_rec.INTMED_SHIP_TO_LOCATION_ID,-99) <> NVL(p_out_rec.INTMED_SHIP_TO_LOCATION_ID,-99)
7815: THEN
7816: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_ID, ';
7817: END IF;
7815: THEN
7816: l_attributes := l_attributes || 'INTMED_SHIP_TO_LOCATION_ID, ';
7817: END IF;
7818:
7819: IF p_user_in_rec.INTMED_SHIP_TO_CONTACT_ID <> FND_API.G_MISS_NUM
7820: AND NVL(p_user_in_rec.INTMED_SHIP_TO_CONTACT_ID,-99) <> NVL(p_out_rec.INTMED_SHIP_TO_CONTACT_ID,-99)
7821: THEN
7822: l_attributes := l_attributes || 'INTMED_SHIP_TO_CONTACT_ID, ';
7823: END IF;
7821: THEN
7822: l_attributes := l_attributes || 'INTMED_SHIP_TO_CONTACT_ID, ';
7823: END IF;
7824:
7825: IF p_user_in_rec.HOLD_CODE <> FND_API.G_MISS_CHAR
7826: AND NVL(p_user_in_rec.HOLD_CODE,'!!!') <> NVL(p_out_rec.HOLD_CODE,'!!!')
7827: THEN
7828: l_attributes := l_attributes || 'HOLD_CODE, ';
7829: END IF;
7827: THEN
7828: l_attributes := l_attributes || 'HOLD_CODE, ';
7829: END IF;
7830:
7831: IF p_user_in_rec.SHIP_TOLERANCE_ABOVE <> FND_API.G_MISS_NUM
7832: AND NVL(p_user_in_rec.SHIP_TOLERANCE_ABOVE,-99) <> NVL(p_out_rec.SHIP_TOLERANCE_ABOVE,-99)
7833: THEN
7834: l_attributes := l_attributes || 'SHIP_TOLERANCE_ABOVE, ';
7835: END IF;
7833: THEN
7834: l_attributes := l_attributes || 'SHIP_TOLERANCE_ABOVE, ';
7835: END IF;
7836:
7837: IF p_user_in_rec.SHIP_TOLERANCE_BELOW <> FND_API.G_MISS_NUM
7838: AND NVL(p_user_in_rec.SHIP_TOLERANCE_BELOW,-99) <> NVL(p_out_rec.SHIP_TOLERANCE_BELOW,-99)
7839: THEN
7840: l_attributes := l_attributes || 'SHIP_TOLERANCE_BELOW, ';
7841: END IF;
7839: THEN
7840: l_attributes := l_attributes || 'SHIP_TOLERANCE_BELOW, ';
7841: END IF;
7842:
7843: IF p_user_in_rec.REQUESTED_QUANTITY <> FND_API.G_MISS_NUM
7844: AND NVL(p_user_in_rec.REQUESTED_QUANTITY,-99) <> NVL(p_out_rec.REQUESTED_QUANTITY,-99)
7845: THEN
7846: l_attributes := l_attributes || 'REQUESTED_QUANTITY, ';
7847: END IF;
7845: THEN
7846: l_attributes := l_attributes || 'REQUESTED_QUANTITY, ';
7847: END IF;
7848:
7849: IF p_user_in_rec.SHIPPED_QUANTITY <> FND_API.G_MISS_NUM
7850: AND NVL(p_user_in_rec.SHIPPED_QUANTITY,-99) <> NVL(p_out_rec.SHIPPED_QUANTITY,-99)
7851: THEN
7852: l_attributes := l_attributes || 'SHIPPED_QUANTITY, ';
7853: END IF;
7851: THEN
7852: l_attributes := l_attributes || 'SHIPPED_QUANTITY, ';
7853: END IF;
7854:
7855: IF p_user_in_rec.DELIVERED_QUANTITY <> FND_API.G_MISS_NUM
7856: AND NVL(p_user_in_rec.DELIVERED_QUANTITY,-99) <> NVL(p_out_rec.DELIVERED_QUANTITY,-99)
7857: THEN
7858: l_attributes := l_attributes || 'DELIVERED_QUANTITY, ';
7859: END IF;
7857: THEN
7858: l_attributes := l_attributes || 'DELIVERED_QUANTITY, ';
7859: END IF;
7860:
7861: IF p_user_in_rec.REQUESTED_QUANTITY_UOM <> FND_API.G_MISS_CHAR
7862: AND NVL(p_user_in_rec.REQUESTED_QUANTITY_UOM,'!!!') <> NVL(p_out_rec.REQUESTED_QUANTITY_UOM,'!!!')
7863: THEN
7864: l_attributes := l_attributes || 'REQUESTED_QUANTITY_UOM, ';
7865: END IF;
7863: THEN
7864: l_attributes := l_attributes || 'REQUESTED_QUANTITY_UOM, ';
7865: END IF;
7866:
7867: IF p_user_in_rec.SUBINVENTORY <> FND_API.G_MISS_CHAR
7868: AND NVL(p_user_in_rec.SUBINVENTORY,'!!!') <> NVL(p_out_rec.SUBINVENTORY,'!!!')
7869: THEN
7870: l_attributes := l_attributes || 'SUBINVENTORY, ';
7871: END IF;
7869: THEN
7870: l_attributes := l_attributes || 'SUBINVENTORY, ';
7871: END IF;
7872:
7873: IF p_user_in_rec.REVISION <> FND_API.G_MISS_CHAR
7874: AND NVL(p_user_in_rec.REVISION,'!!!') <> NVL(p_out_rec.REVISION,'!!!')
7875: THEN
7876: l_attributes := l_attributes || 'REVISION, ';
7877: END IF;
7875: THEN
7876: l_attributes := l_attributes || 'REVISION, ';
7877: END IF;
7878:
7879: IF p_user_in_rec.LOT_NUMBER <> FND_API.G_MISS_CHAR
7880: AND NVL(p_user_in_rec.LOT_NUMBER,'!!!') <> NVL(p_out_rec.LOT_NUMBER,'!!!')
7881: THEN
7882: l_attributes := l_attributes || 'LOT_NUMBER, ';
7883: END IF;
7881: THEN
7882: l_attributes := l_attributes || 'LOT_NUMBER, ';
7883: END IF;
7884:
7885: IF p_user_in_rec.CUSTOMER_REQUESTED_LOT_FLAG <> FND_API.G_MISS_CHAR
7886: AND NVL(p_user_in_rec.CUSTOMER_REQUESTED_LOT_FLAG,'!!!') <> NVL(p_out_rec.CUSTOMER_REQUESTED_LOT_FLAG,'!!!')
7887: THEN
7888: l_attributes := l_attributes || 'CUSTOMER_REQUESTED_LOT_FLAG, ';
7889: END IF;
7887: THEN
7888: l_attributes := l_attributes || 'CUSTOMER_REQUESTED_LOT_FLAG, ';
7889: END IF;
7890:
7891: IF p_user_in_rec.SERIAL_NUMBER <> FND_API.G_MISS_CHAR
7892: AND NVL(p_user_in_rec.SERIAL_NUMBER,'!!!') <> NVL(p_out_rec.SERIAL_NUMBER,'!!!')
7893: THEN
7894: l_attributes := l_attributes || 'SERIAL_NUMBER, ';
7895: END IF;
7893: THEN
7894: l_attributes := l_attributes || 'SERIAL_NUMBER, ';
7895: END IF;
7896:
7897: IF p_user_in_rec.LOCATOR_ID <> FND_API.G_MISS_NUM
7898: AND NVL(p_user_in_rec.LOCATOR_ID,-99) <> NVL(p_out_rec.LOCATOR_ID,-99)
7899: THEN
7900: l_attributes := l_attributes || 'LOCATOR_ID, ';
7901: END IF;
7899: THEN
7900: l_attributes := l_attributes || 'LOCATOR_ID, ';
7901: END IF;
7902:
7903: IF p_user_in_rec.DATE_REQUESTED <> FND_API.G_MISS_DATE
7904: AND NVL(p_user_in_rec.DATE_REQUESTED,TO_DATE('2','j')) <> NVL(p_out_rec.DATE_REQUESTED,TO_DATE('2','j'))
7905: THEN
7906: l_attributes := l_attributes || 'DATE_REQUESTED, ';
7907: END IF;
7905: THEN
7906: l_attributes := l_attributes || 'DATE_REQUESTED, ';
7907: END IF;
7908:
7909: IF p_user_in_rec.DATE_SCHEDULED <> FND_API.G_MISS_DATE
7910: AND NVL(p_user_in_rec.DATE_SCHEDULED,TO_DATE('2','j')) <> NVL(p_out_rec.DATE_SCHEDULED,TO_DATE('2','j'))
7911: THEN
7912: l_attributes := l_attributes || 'DATE_SCHEDULED, ';
7913: END IF;
7911: THEN
7912: l_attributes := l_attributes || 'DATE_SCHEDULED, ';
7913: END IF;
7914:
7915: IF p_user_in_rec.MASTER_CONTAINER_ITEM_ID <> FND_API.G_MISS_NUM
7916: AND NVL(p_user_in_rec.MASTER_CONTAINER_ITEM_ID,-99) <> NVL(p_out_rec.MASTER_CONTAINER_ITEM_ID,-99)
7917: THEN
7918: l_attributes := l_attributes || 'MASTER_CONTAINER_ITEM_ID, ';
7919: END IF;
7917: THEN
7918: l_attributes := l_attributes || 'MASTER_CONTAINER_ITEM_ID, ';
7919: END IF;
7920:
7921: IF p_user_in_rec.DETAIL_CONTAINER_ITEM_ID <> FND_API.G_MISS_NUM
7922: AND NVL(p_user_in_rec.DETAIL_CONTAINER_ITEM_ID,-99) <> NVL(p_out_rec.DETAIL_CONTAINER_ITEM_ID,-99)
7923: THEN
7924: l_attributes := l_attributes || 'DETAIL_CONTAINER_ITEM_ID, ';
7925: END IF;
7923: THEN
7924: l_attributes := l_attributes || 'DETAIL_CONTAINER_ITEM_ID, ';
7925: END IF;
7926:
7927: IF p_user_in_rec.LOAD_SEQ_NUMBER <> FND_API.G_MISS_NUM
7928: AND NVL(p_user_in_rec.LOAD_SEQ_NUMBER,-99) <> NVL(p_out_rec.LOAD_SEQ_NUMBER,-99)
7929: THEN
7930: l_attributes := l_attributes || 'LOAD_SEQ_NUMBER, ';
7931: END IF;
7929: THEN
7930: l_attributes := l_attributes || 'LOAD_SEQ_NUMBER, ';
7931: END IF;
7932:
7933: IF p_user_in_rec.SHIP_METHOD_CODE <> FND_API.G_MISS_CHAR
7934: AND NVL(p_user_in_rec.SHIP_METHOD_CODE,'!!!') <> NVL(p_out_rec.SHIP_METHOD_CODE,'!!!')
7935: THEN
7936: l_attributes := l_attributes || 'SHIP_METHOD_CODE, ';
7937: END IF;
7935: THEN
7936: l_attributes := l_attributes || 'SHIP_METHOD_CODE, ';
7937: END IF;
7938:
7939: IF p_user_in_rec.CARRIER_ID <> FND_API.G_MISS_NUM
7940: AND NVL(p_user_in_rec.CARRIER_ID,-99) <> NVL(p_out_rec.CARRIER_ID,-99)
7941: THEN
7942: l_attributes := l_attributes || 'CARRIER_ID, ';
7943: END IF;
7941: THEN
7942: l_attributes := l_attributes || 'CARRIER_ID, ';
7943: END IF;
7944:
7945: IF p_user_in_rec.FREIGHT_TERMS_CODE <> FND_API.G_MISS_CHAR
7946: AND NVL(p_user_in_rec.FREIGHT_TERMS_CODE,'!!!') <> NVL(p_out_rec.FREIGHT_TERMS_CODE,'!!!')
7947: THEN
7948: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE, ';
7949: END IF;
7947: THEN
7948: l_attributes := l_attributes || 'FREIGHT_TERMS_CODE, ';
7949: END IF;
7950:
7951: IF p_user_in_rec.SHIPMENT_PRIORITY_CODE <> FND_API.G_MISS_CHAR
7952: AND NVL(p_user_in_rec.SHIPMENT_PRIORITY_CODE,'!!!') <> NVL(p_out_rec.SHIPMENT_PRIORITY_CODE,'!!!')
7953: THEN
7954: l_attributes := l_attributes || 'SHIPMENT_PRIORITY_CODE, ';
7955: END IF;
7953: THEN
7954: l_attributes := l_attributes || 'SHIPMENT_PRIORITY_CODE, ';
7955: END IF;
7956:
7957: IF p_user_in_rec.FOB_CODE <> FND_API.G_MISS_CHAR
7958: AND NVL(p_user_in_rec.FOB_CODE,'!!!') <> NVL(p_out_rec.FOB_CODE,'!!!')
7959: THEN
7960: l_attributes := l_attributes || 'FOB_CODE, ';
7961: END IF;
7959: THEN
7960: l_attributes := l_attributes || 'FOB_CODE, ';
7961: END IF;
7962:
7963: IF p_user_in_rec.CUSTOMER_ITEM_ID <> FND_API.G_MISS_NUM
7964: AND NVL(p_user_in_rec.CUSTOMER_ITEM_ID,-99) <> NVL(p_out_rec.CUSTOMER_ITEM_ID,-99)
7965: THEN
7966: l_attributes := l_attributes || 'CUSTOMER_ITEM_ID, ';
7967: END IF;
7965: THEN
7966: l_attributes := l_attributes || 'CUSTOMER_ITEM_ID, ';
7967: END IF;
7968:
7969: IF p_user_in_rec.DEP_PLAN_REQUIRED_FLAG <> FND_API.G_MISS_CHAR
7970: AND NVL(p_user_in_rec.DEP_PLAN_REQUIRED_FLAG,'!!!') <> NVL(p_out_rec.DEP_PLAN_REQUIRED_FLAG,'!!!')
7971: THEN
7972: l_attributes := l_attributes || 'DEP_PLAN_REQUIRED_FLAG, ';
7973: END IF;
7971: THEN
7972: l_attributes := l_attributes || 'DEP_PLAN_REQUIRED_FLAG, ';
7973: END IF;
7974:
7975: IF p_user_in_rec.CUSTOMER_PROD_SEQ <> FND_API.G_MISS_CHAR
7976: AND NVL(p_user_in_rec.CUSTOMER_PROD_SEQ,'!!!') <> NVL(p_out_rec.CUSTOMER_PROD_SEQ,'!!!')
7977: THEN
7978: l_attributes := l_attributes || 'CUSTOMER_PROD_SEQ, ';
7979: END IF;
7977: THEN
7978: l_attributes := l_attributes || 'CUSTOMER_PROD_SEQ, ';
7979: END IF;
7980:
7981: IF p_user_in_rec.CUSTOMER_DOCK_CODE <> FND_API.G_MISS_CHAR
7982: AND NVL(p_user_in_rec.CUSTOMER_DOCK_CODE,'!!!') <> NVL(p_out_rec.CUSTOMER_DOCK_CODE,'!!!')
7983: THEN
7984: l_attributes := l_attributes || 'CUSTOMER_DOCK_CODE, ';
7985: END IF;
7983: THEN
7984: l_attributes := l_attributes || 'CUSTOMER_DOCK_CODE, ';
7985: END IF;
7986:
7987: IF p_user_in_rec.CUST_MODEL_SERIAL_NUMBER <> FND_API.G_MISS_CHAR
7988: AND NVL(p_user_in_rec.CUST_MODEL_SERIAL_NUMBER,'!!!') <> NVL(p_out_rec.CUST_MODEL_SERIAL_NUMBER,'!!!')
7989: THEN
7990: l_attributes := l_attributes || 'CUST_MODEL_SERIAL_NUMBER, ';
7991: END IF;
7989: THEN
7990: l_attributes := l_attributes || 'CUST_MODEL_SERIAL_NUMBER, ';
7991: END IF;
7992:
7993: IF p_user_in_rec.CUSTOMER_JOB <> FND_API.G_MISS_CHAR
7994: AND NVL(p_user_in_rec.CUSTOMER_JOB,'!!!') <> NVL(p_out_rec.CUSTOMER_JOB,'!!!')
7995: THEN
7996: l_attributes := l_attributes || 'CUSTOMER_JOB, ';
7997: END IF;
7995: THEN
7996: l_attributes := l_attributes || 'CUSTOMER_JOB, ';
7997: END IF;
7998:
7999: IF p_user_in_rec.CUSTOMER_PRODUCTION_LINE <> FND_API.G_MISS_CHAR
8000: AND NVL(p_user_in_rec.CUSTOMER_PRODUCTION_LINE,'!!!') <> NVL(p_out_rec.CUSTOMER_PRODUCTION_LINE,'!!!')
8001: THEN
8002: l_attributes := l_attributes || 'CUSTOMER_PRODUCTION_LINE, ';
8003: END IF;
8001: THEN
8002: l_attributes := l_attributes || 'CUSTOMER_PRODUCTION_LINE, ';
8003: END IF;
8004:
8005: IF p_user_in_rec.NET_WEIGHT <> FND_API.G_MISS_NUM
8006: AND NVL(p_user_in_rec.NET_WEIGHT,-99) <> NVL(p_out_rec.NET_WEIGHT,-99)
8007: THEN
8008: l_attributes := l_attributes || 'NET_WEIGHT, ';
8009: END IF;
8007: THEN
8008: l_attributes := l_attributes || 'NET_WEIGHT, ';
8009: END IF;
8010:
8011: IF p_user_in_rec.WEIGHT_UOM_CODE <> FND_API.G_MISS_CHAR
8012: AND NVL(p_user_in_rec.WEIGHT_UOM_CODE,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_CODE,'!!!')
8013: THEN
8014: IF (NVL(p_in_rec.caller,'WSH') LIKE 'WMS%')
8015: AND (NVL(p_in_rec.action_code,'CREATE') = 'UPDATE') THEN
8018: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
8019: END IF;
8020: END IF;
8021:
8022: IF p_user_in_rec.VOLUME <> FND_API.G_MISS_NUM
8023: AND NVL(p_user_in_rec.VOLUME,-99) <> NVL(p_out_rec.VOLUME,-99)
8024: THEN
8025: l_attributes := l_attributes || 'VOLUME, ';
8026: END IF;
8024: THEN
8025: l_attributes := l_attributes || 'VOLUME, ';
8026: END IF;
8027:
8028: IF p_user_in_rec.VOLUME_UOM_CODE <> FND_API.G_MISS_CHAR
8029: AND NVL(p_user_in_rec.VOLUME_UOM_CODE,'!!!') <> NVL(p_out_rec.VOLUME_UOM_CODE,'!!!')
8030: THEN
8031: IF (NVL(p_in_rec.caller,'WSH') LIKE 'WMS%')
8032: AND (NVL(p_in_rec.action_code,'CREATE') = 'UPDATE') THEN
8035: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
8036: END IF;
8037: END IF;
8038:
8039: IF p_user_in_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
8040: AND NVL(p_user_in_rec.TP_ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE_CATEGORY,'!!!')
8041: THEN
8042: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
8043: END IF;
8041: THEN
8042: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
8043: END IF;
8044:
8045: IF p_user_in_rec.TP_ATTRIBUTE1 <> FND_API.G_MISS_CHAR
8046: AND NVL(p_user_in_rec.TP_ATTRIBUTE1,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE1,'!!!')
8047: THEN
8048: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
8049: END IF;
8047: THEN
8048: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
8049: END IF;
8050:
8051: IF p_user_in_rec.TP_ATTRIBUTE2 <> FND_API.G_MISS_CHAR
8052: AND NVL(p_user_in_rec.TP_ATTRIBUTE2,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE2,'!!!')
8053: THEN
8054: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
8055: END IF;
8053: THEN
8054: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
8055: END IF;
8056:
8057: IF p_user_in_rec.TP_ATTRIBUTE3 <> FND_API.G_MISS_CHAR
8058: AND NVL(p_user_in_rec.TP_ATTRIBUTE3,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE3,'!!!')
8059: THEN
8060: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
8061: END IF;
8059: THEN
8060: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
8061: END IF;
8062:
8063: IF p_user_in_rec.TP_ATTRIBUTE4 <> FND_API.G_MISS_CHAR
8064: AND NVL(p_user_in_rec.TP_ATTRIBUTE4,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE4,'!!!')
8065: THEN
8066: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
8067: END IF;
8065: THEN
8066: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
8067: END IF;
8068:
8069: IF p_user_in_rec.TP_ATTRIBUTE5 <> FND_API.G_MISS_CHAR
8070: AND NVL(p_user_in_rec.TP_ATTRIBUTE5,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE5,'!!!')
8071: THEN
8072: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
8073: END IF;
8071: THEN
8072: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
8073: END IF;
8074:
8075: IF p_user_in_rec.TP_ATTRIBUTE6 <> FND_API.G_MISS_CHAR
8076: AND NVL(p_user_in_rec.TP_ATTRIBUTE6,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE6,'!!!')
8077: THEN
8078: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
8079: END IF;
8077: THEN
8078: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
8079: END IF;
8080:
8081: IF p_user_in_rec.TP_ATTRIBUTE7 <> FND_API.G_MISS_CHAR
8082: AND NVL(p_user_in_rec.TP_ATTRIBUTE7,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE7,'!!!')
8083: THEN
8084: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
8085: END IF;
8083: THEN
8084: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
8085: END IF;
8086:
8087: IF p_user_in_rec.TP_ATTRIBUTE8 <> FND_API.G_MISS_CHAR
8088: AND NVL(p_user_in_rec.TP_ATTRIBUTE8,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE8,'!!!')
8089: THEN
8090: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
8091: END IF;
8089: THEN
8090: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
8091: END IF;
8092:
8093: IF p_user_in_rec.TP_ATTRIBUTE9 <> FND_API.G_MISS_CHAR
8094: AND NVL(p_user_in_rec.TP_ATTRIBUTE9,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE9,'!!!')
8095: THEN
8096: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
8097: END IF;
8095: THEN
8096: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
8097: END IF;
8098:
8099: IF p_user_in_rec.TP_ATTRIBUTE10 <> FND_API.G_MISS_CHAR
8100: AND NVL(p_user_in_rec.TP_ATTRIBUTE10,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE10,'!!!')
8101: THEN
8102: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
8103: END IF;
8101: THEN
8102: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
8103: END IF;
8104:
8105: IF p_user_in_rec.TP_ATTRIBUTE11 <> FND_API.G_MISS_CHAR
8106: AND NVL(p_user_in_rec.TP_ATTRIBUTE11,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE11,'!!!')
8107: THEN
8108: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
8109: END IF;
8107: THEN
8108: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
8109: END IF;
8110:
8111: IF p_user_in_rec.TP_ATTRIBUTE12 <> FND_API.G_MISS_CHAR
8112: AND NVL(p_user_in_rec.TP_ATTRIBUTE12,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE12,'!!!')
8113: THEN
8114: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
8115: END IF;
8113: THEN
8114: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
8115: END IF;
8116:
8117: IF p_user_in_rec.TP_ATTRIBUTE13 <> FND_API.G_MISS_CHAR
8118: AND NVL(p_user_in_rec.TP_ATTRIBUTE13,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE13,'!!!')
8119: THEN
8120: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
8121: END IF;
8119: THEN
8120: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
8121: END IF;
8122:
8123: IF p_user_in_rec.TP_ATTRIBUTE14 <> FND_API.G_MISS_CHAR
8124: AND NVL(p_user_in_rec.TP_ATTRIBUTE14,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE14,'!!!')
8125: THEN
8126: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
8127: END IF;
8125: THEN
8126: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
8127: END IF;
8128:
8129: IF p_user_in_rec.TP_ATTRIBUTE15 <> FND_API.G_MISS_CHAR
8130: AND NVL(p_user_in_rec.TP_ATTRIBUTE15,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE15,'!!!')
8131: THEN
8132: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
8133: END IF;
8131: THEN
8132: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
8133: END IF;
8134:
8135: IF p_user_in_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
8136: AND NVL(p_user_in_rec.ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.ATTRIBUTE_CATEGORY,'!!!')
8137: THEN
8138: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
8139: END IF;
8137: THEN
8138: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
8139: END IF;
8140:
8141: IF p_user_in_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
8142: AND NVL(p_user_in_rec.ATTRIBUTE1,'!!!') <> NVL(p_out_rec.ATTRIBUTE1,'!!!')
8143: THEN
8144: l_attributes := l_attributes || 'ATTRIBUTE1, ';
8145: END IF;
8143: THEN
8144: l_attributes := l_attributes || 'ATTRIBUTE1, ';
8145: END IF;
8146:
8147: IF p_user_in_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
8148: AND NVL(p_user_in_rec.ATTRIBUTE2,'!!!') <> NVL(p_out_rec.ATTRIBUTE2,'!!!')
8149: THEN
8150: l_attributes := l_attributes || 'ATTRIBUTE2, ';
8151: END IF;
8149: THEN
8150: l_attributes := l_attributes || 'ATTRIBUTE2, ';
8151: END IF;
8152:
8153: IF p_user_in_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
8154: AND NVL(p_user_in_rec.ATTRIBUTE3,'!!!') <> NVL(p_out_rec.ATTRIBUTE3,'!!!')
8155: THEN
8156: l_attributes := l_attributes || 'ATTRIBUTE3, ';
8157: END IF;
8155: THEN
8156: l_attributes := l_attributes || 'ATTRIBUTE3, ';
8157: END IF;
8158:
8159: IF p_user_in_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
8160: AND NVL(p_user_in_rec.ATTRIBUTE4,'!!!') <> NVL(p_out_rec.ATTRIBUTE4,'!!!')
8161: THEN
8162: l_attributes := l_attributes || 'ATTRIBUTE4, ';
8163: END IF;
8161: THEN
8162: l_attributes := l_attributes || 'ATTRIBUTE4, ';
8163: END IF;
8164:
8165: IF p_user_in_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
8166: AND NVL(p_user_in_rec.ATTRIBUTE5,'!!!') <> NVL(p_out_rec.ATTRIBUTE5,'!!!')
8167: THEN
8168: l_attributes := l_attributes || 'ATTRIBUTE5, ';
8169: END IF;
8167: THEN
8168: l_attributes := l_attributes || 'ATTRIBUTE5, ';
8169: END IF;
8170:
8171: IF p_user_in_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
8172: AND NVL(p_user_in_rec.ATTRIBUTE6,'!!!') <> NVL(p_out_rec.ATTRIBUTE6,'!!!')
8173: THEN
8174: l_attributes := l_attributes || 'ATTRIBUTE6, ';
8175: END IF;
8173: THEN
8174: l_attributes := l_attributes || 'ATTRIBUTE6, ';
8175: END IF;
8176:
8177: IF p_user_in_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
8178: AND NVL(p_user_in_rec.ATTRIBUTE7,'!!!') <> NVL(p_out_rec.ATTRIBUTE7,'!!!')
8179: THEN
8180: l_attributes := l_attributes || 'ATTRIBUTE7, ';
8181: END IF;
8179: THEN
8180: l_attributes := l_attributes || 'ATTRIBUTE7, ';
8181: END IF;
8182:
8183: IF p_user_in_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
8184: AND NVL(p_user_in_rec.ATTRIBUTE8,'!!!') <> NVL(p_out_rec.ATTRIBUTE8,'!!!')
8185: THEN
8186: l_attributes := l_attributes || 'ATTRIBUTE8, ';
8187: END IF;
8185: THEN
8186: l_attributes := l_attributes || 'ATTRIBUTE8, ';
8187: END IF;
8188:
8189: IF p_user_in_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
8190: AND NVL(p_user_in_rec.ATTRIBUTE9,'!!!') <> NVL(p_out_rec.ATTRIBUTE9,'!!!')
8191: THEN
8192: l_attributes := l_attributes || 'ATTRIBUTE9, ';
8193: END IF;
8191: THEN
8192: l_attributes := l_attributes || 'ATTRIBUTE9, ';
8193: END IF;
8194:
8195: IF p_user_in_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
8196: AND NVL(p_user_in_rec.ATTRIBUTE10,'!!!') <> NVL(p_out_rec.ATTRIBUTE10,'!!!')
8197: THEN
8198: l_attributes := l_attributes || 'ATTRIBUTE10, ';
8199: END IF;
8197: THEN
8198: l_attributes := l_attributes || 'ATTRIBUTE10, ';
8199: END IF;
8200:
8201: IF p_user_in_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
8202: AND NVL(p_user_in_rec.ATTRIBUTE11,'!!!') <> NVL(p_out_rec.ATTRIBUTE11,'!!!')
8203: THEN
8204: l_attributes := l_attributes || 'ATTRIBUTE11, ';
8205: END IF;
8203: THEN
8204: l_attributes := l_attributes || 'ATTRIBUTE11, ';
8205: END IF;
8206:
8207: IF p_user_in_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
8208: AND NVL(p_user_in_rec.ATTRIBUTE12,'!!!') <> NVL(p_out_rec.ATTRIBUTE12,'!!!')
8209: THEN
8210: l_attributes := l_attributes || 'ATTRIBUTE12, ';
8211: END IF;
8209: THEN
8210: l_attributes := l_attributes || 'ATTRIBUTE12, ';
8211: END IF;
8212:
8213: IF p_user_in_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
8214: AND NVL(p_user_in_rec.ATTRIBUTE13,'!!!') <> NVL(p_out_rec.ATTRIBUTE13,'!!!')
8215: THEN
8216: l_attributes := l_attributes || 'ATTRIBUTE13, ';
8217: END IF;
8215: THEN
8216: l_attributes := l_attributes || 'ATTRIBUTE13, ';
8217: END IF;
8218:
8219: IF p_user_in_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
8220: AND NVL(p_user_in_rec.ATTRIBUTE14,'!!!') <> NVL(p_out_rec.ATTRIBUTE14,'!!!')
8221: THEN
8222: l_attributes := l_attributes || 'ATTRIBUTE14, ';
8223: END IF;
8221: THEN
8222: l_attributes := l_attributes || 'ATTRIBUTE14, ';
8223: END IF;
8224:
8225: IF p_user_in_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
8226: AND NVL(p_user_in_rec.ATTRIBUTE15,'!!!') <> NVL(p_out_rec.ATTRIBUTE15,'!!!')
8227: THEN
8228: l_attributes := l_attributes || 'ATTRIBUTE15, ';
8229: END IF;
8230:
8231: /**
8232: -- Bug 3613650 : Need not compare WHO columns
8233: --
8234: IF p_user_in_rec.CREATED_BY <> FND_API.G_MISS_NUM
8235: AND NVL(p_user_in_rec.CREATED_BY,-99) <> NVL(p_out_rec.CREATED_BY,-99)
8236: THEN
8237: l_attributes := l_attributes || 'CREATED_BY, ';
8238: END IF;
8236: THEN
8237: l_attributes := l_attributes || 'CREATED_BY, ';
8238: END IF;
8239:
8240: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE
8241: AND NVL(p_user_in_rec.CREATION_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CREATION_DATE,TO_DATE('2','j'))
8242: THEN
8243: l_attributes := l_attributes || 'CREATION_DATE, ';
8244: END IF;
8242: THEN
8243: l_attributes := l_attributes || 'CREATION_DATE, ';
8244: END IF;
8245:
8246: IF p_user_in_rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE
8247: AND NVL(p_user_in_rec.LAST_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LAST_UPDATE_DATE,TO_DATE('2','j'))
8248: THEN
8249: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
8250: END IF;
8248: THEN
8249: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
8250: END IF;
8251:
8252: IF p_user_in_rec.LAST_UPDATE_LOGIN <> FND_API.G_MISS_NUM
8253: AND NVL(p_user_in_rec.LAST_UPDATE_LOGIN,-99) <> NVL(p_out_rec.LAST_UPDATE_LOGIN,-99)
8254: THEN
8255: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
8256: END IF;
8254: THEN
8255: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
8256: END IF;
8257:
8258: IF p_user_in_rec.LAST_UPDATED_BY <> FND_API.G_MISS_NUM
8259: AND NVL(p_user_in_rec.LAST_UPDATED_BY,-99) <> NVL(p_out_rec.LAST_UPDATED_BY,-99)
8260: THEN
8261: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
8262: END IF;
8260: THEN
8261: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
8262: END IF;
8263:
8264: IF p_user_in_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
8265: AND NVL(p_user_in_rec.PROGRAM_APPLICATION_ID,-99) <> NVL(p_out_rec.PROGRAM_APPLICATION_ID,-99)
8266: THEN
8267: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
8268: END IF;
8266: THEN
8267: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
8268: END IF;
8269:
8270: IF p_user_in_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
8271: AND NVL(p_user_in_rec.PROGRAM_ID,-99) <> NVL(p_out_rec.PROGRAM_ID,-99)
8272: THEN
8273: l_attributes := l_attributes || 'PROGRAM_ID, ';
8274: END IF;
8272: THEN
8273: l_attributes := l_attributes || 'PROGRAM_ID, ';
8274: END IF;
8275:
8276: IF p_user_in_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
8277: AND NVL(p_user_in_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j'))
8278: THEN
8279: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
8280: END IF;
8278: THEN
8279: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
8280: END IF;
8281:
8282: IF p_user_in_rec.REQUEST_ID <> FND_API.G_MISS_NUM
8283: AND NVL(p_user_in_rec.REQUEST_ID,-99) <> NVL(p_out_rec.REQUEST_ID,-99)
8284: THEN
8285: l_attributes := l_attributes || 'REQUEST_ID, ';
8286: END IF;
8285: l_attributes := l_attributes || 'REQUEST_ID, ';
8286: END IF;
8287: **/
8288:
8289: IF p_user_in_rec.MVT_STAT_STATUS <> FND_API.G_MISS_CHAR
8290: AND NVL(p_user_in_rec.MVT_STAT_STATUS,'!!!') <> NVL(p_out_rec.MVT_STAT_STATUS,'!!!')
8291: THEN
8292: l_attributes := l_attributes || 'MVT_STAT_STATUS, ';
8293: END IF;
8291: THEN
8292: l_attributes := l_attributes || 'MVT_STAT_STATUS, ';
8293: END IF;
8294:
8295: IF p_user_in_rec.RELEASED_FLAG <> FND_API.G_MISS_CHAR
8296: AND NVL(p_user_in_rec.RELEASED_FLAG,'!!!') <> NVL(p_out_rec.RELEASED_FLAG,'!!!')
8297: THEN
8298: l_attributes := l_attributes || 'RELEASED_FLAG, ';
8299: END IF;
8297: THEN
8298: l_attributes := l_attributes || 'RELEASED_FLAG, ';
8299: END IF;
8300:
8301: IF p_user_in_rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM
8302: AND NVL(p_user_in_rec.ORGANIZATION_ID,-99) <> NVL(p_out_rec.ORGANIZATION_ID,-99)
8303: THEN
8304: l_attributes := l_attributes || 'ORGANIZATION_ID, ';
8305: END IF;
8303: THEN
8304: l_attributes := l_attributes || 'ORGANIZATION_ID, ';
8305: END IF;
8306:
8307: IF p_user_in_rec.TRANSACTION_TEMP_ID <> FND_API.G_MISS_NUM
8308: AND NVL(p_user_in_rec.TRANSACTION_TEMP_ID,-99) <> NVL(p_out_rec.TRANSACTION_TEMP_ID,-99)
8309: THEN
8310: l_attributes := l_attributes || 'TRANSACTION_TEMP_ID, ';
8311: END IF;
8309: THEN
8310: l_attributes := l_attributes || 'TRANSACTION_TEMP_ID, ';
8311: END IF;
8312:
8313: IF p_user_in_rec.SHIP_SET_ID <> FND_API.G_MISS_NUM
8314: AND NVL(p_user_in_rec.SHIP_SET_ID,-99) <> NVL(p_out_rec.SHIP_SET_ID,-99)
8315: THEN
8316: l_attributes := l_attributes || 'SHIP_SET_ID, ';
8317: END IF;
8315: THEN
8316: l_attributes := l_attributes || 'SHIP_SET_ID, ';
8317: END IF;
8318:
8319: IF p_user_in_rec.ARRIVAL_SET_ID <> FND_API.G_MISS_NUM
8320: AND NVL(p_user_in_rec.ARRIVAL_SET_ID,-99) <> NVL(p_out_rec.ARRIVAL_SET_ID,-99)
8321: THEN
8322: l_attributes := l_attributes || 'ARRIVAL_SET_ID, ';
8323: END IF;
8321: THEN
8322: l_attributes := l_attributes || 'ARRIVAL_SET_ID, ';
8323: END IF;
8324:
8325: IF p_user_in_rec.SHIP_MODEL_COMPLETE_FLAG <> FND_API.G_MISS_CHAR
8326: AND NVL(p_user_in_rec.SHIP_MODEL_COMPLETE_FLAG,'!!!') <> NVL(p_out_rec.SHIP_MODEL_COMPLETE_FLAG,'!!!')
8327: THEN
8328: l_attributes := l_attributes || 'SHIP_MODEL_COMPLETE_FLAG, ';
8329: END IF;
8327: THEN
8328: l_attributes := l_attributes || 'SHIP_MODEL_COMPLETE_FLAG, ';
8329: END IF;
8330:
8331: IF p_user_in_rec.TOP_MODEL_LINE_ID <> FND_API.G_MISS_NUM
8332: AND NVL(p_user_in_rec.TOP_MODEL_LINE_ID,-99) <> NVL(p_out_rec.TOP_MODEL_LINE_ID,-99)
8333: THEN
8334: l_attributes := l_attributes || 'TOP_MODEL_LINE_ID, ';
8335: END IF;
8333: THEN
8334: l_attributes := l_attributes || 'TOP_MODEL_LINE_ID, ';
8335: END IF;
8336:
8337: IF p_user_in_rec.SOURCE_HEADER_NUMBER <> FND_API.G_MISS_CHAR
8338: AND NVL(p_user_in_rec.SOURCE_HEADER_NUMBER,'!!!') <> NVL(p_out_rec.SOURCE_HEADER_NUMBER,'!!!')
8339: THEN
8340: l_attributes := l_attributes || 'SOURCE_HEADER_NUMBER, ';
8341: END IF;
8339: THEN
8340: l_attributes := l_attributes || 'SOURCE_HEADER_NUMBER, ';
8341: END IF;
8342:
8343: IF p_user_in_rec.SOURCE_HEADER_TYPE_ID <> FND_API.G_MISS_NUM
8344: AND NVL(p_user_in_rec.SOURCE_HEADER_TYPE_ID,-99) <> NVL(p_out_rec.SOURCE_HEADER_TYPE_ID,-99)
8345: THEN
8346: l_attributes := l_attributes || 'SOURCE_HEADER_TYPE_ID, ';
8347: END IF;
8345: THEN
8346: l_attributes := l_attributes || 'SOURCE_HEADER_TYPE_ID, ';
8347: END IF;
8348:
8349: IF p_user_in_rec.SOURCE_HEADER_TYPE_NAME <> FND_API.G_MISS_CHAR
8350: AND NVL(p_user_in_rec.SOURCE_HEADER_TYPE_NAME,'!!!') <> NVL(p_out_rec.SOURCE_HEADER_TYPE_NAME,'!!!')
8351: THEN
8352: l_attributes := l_attributes || 'SOURCE_HEADER_TYPE_NAME, ';
8353: END IF;
8351: THEN
8352: l_attributes := l_attributes || 'SOURCE_HEADER_TYPE_NAME, ';
8353: END IF;
8354:
8355: IF p_user_in_rec.CUST_PO_NUMBER <> FND_API.G_MISS_CHAR
8356: AND NVL(p_user_in_rec.CUST_PO_NUMBER,'!!!') <> NVL(p_out_rec.CUST_PO_NUMBER,'!!!')
8357: THEN
8358: l_attributes := l_attributes || 'CUST_PO_NUMBER, ';
8359: END IF;
8357: THEN
8358: l_attributes := l_attributes || 'CUST_PO_NUMBER, ';
8359: END IF;
8360:
8361: IF p_user_in_rec.ATO_LINE_ID <> FND_API.G_MISS_NUM
8362: AND NVL(p_user_in_rec.ATO_LINE_ID,-99) <> NVL(p_out_rec.ATO_LINE_ID,-99)
8363: THEN
8364: l_attributes := l_attributes || 'ATO_LINE_ID, ';
8365: END IF;
8363: THEN
8364: l_attributes := l_attributes || 'ATO_LINE_ID, ';
8365: END IF;
8366:
8367: IF p_user_in_rec.SRC_REQUESTED_QUANTITY <> FND_API.G_MISS_NUM
8368: AND NVL(p_user_in_rec.SRC_REQUESTED_QUANTITY,-99) <> NVL(p_out_rec.SRC_REQUESTED_QUANTITY,-99)
8369: THEN
8370: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY, ';
8371: END IF;
8369: THEN
8370: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY, ';
8371: END IF;
8372:
8373: IF p_user_in_rec.SRC_REQUESTED_QUANTITY_UOM <> FND_API.G_MISS_CHAR
8374: AND NVL(p_user_in_rec.SRC_REQUESTED_QUANTITY_UOM,'!!!') <> NVL(p_out_rec.SRC_REQUESTED_QUANTITY_UOM,'!!!')
8375: THEN
8376: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY_UOM, ';
8377: END IF;
8375: THEN
8376: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY_UOM, ';
8377: END IF;
8378:
8379: IF p_user_in_rec.MOVE_ORDER_LINE_ID <> FND_API.G_MISS_NUM
8380: AND NVL(p_user_in_rec.MOVE_ORDER_LINE_ID,-99) <> NVL(p_out_rec.MOVE_ORDER_LINE_ID,-99)
8381: THEN
8382: l_attributes := l_attributes || 'MOVE_ORDER_LINE_ID, ';
8383: END IF;
8381: THEN
8382: l_attributes := l_attributes || 'MOVE_ORDER_LINE_ID, ';
8383: END IF;
8384: --bug# 6689448 (replenishment project)
8385: IF p_user_in_rec.REPLENISHMENT_STATUS <> FND_API.G_MISS_CHAR
8386: AND NVL(p_user_in_rec.REPLENISHMENT_STATUS,'!!!') <> NVL(p_out_rec.REPLENISHMENT_STATUS,'!!!')
8387: THEN
8388: l_attributes := l_attributes || 'REPLENISHMENT_STATUS, ';
8389: END IF;
8387: THEN
8388: l_attributes := l_attributes || 'REPLENISHMENT_STATUS, ';
8389: END IF;
8390:
8391: IF p_user_in_rec.CANCELLED_QUANTITY <> FND_API.G_MISS_NUM
8392: AND NVL(p_user_in_rec.CANCELLED_QUANTITY,-99) <> NVL(p_out_rec.CANCELLED_QUANTITY,-99)
8393: THEN
8394: l_attributes := l_attributes || 'CANCELLED_QUANTITY, ';
8395: END IF;
8393: THEN
8394: l_attributes := l_attributes || 'CANCELLED_QUANTITY, ';
8395: END IF;
8396:
8397: IF p_user_in_rec.QUALITY_CONTROL_QUANTITY <> FND_API.G_MISS_NUM
8398: AND NVL(p_user_in_rec.QUALITY_CONTROL_QUANTITY,-99) <> NVL(p_out_rec.QUALITY_CONTROL_QUANTITY,-99)
8399: THEN
8400: l_attributes := l_attributes || 'QUALITY_CONTROL_QUANTITY, ';
8401: END IF;
8399: THEN
8400: l_attributes := l_attributes || 'QUALITY_CONTROL_QUANTITY, ';
8401: END IF;
8402:
8403: IF p_user_in_rec.CYCLE_COUNT_QUANTITY <> FND_API.G_MISS_NUM
8404: AND NVL(p_user_in_rec.CYCLE_COUNT_QUANTITY,-99) <> NVL(p_out_rec.CYCLE_COUNT_QUANTITY,-99)
8405: THEN
8406: l_attributes := l_attributes || 'CYCLE_COUNT_QUANTITY, ';
8407: END IF;
8405: THEN
8406: l_attributes := l_attributes || 'CYCLE_COUNT_QUANTITY, ';
8407: END IF;
8408:
8409: IF p_user_in_rec.TRACKING_NUMBER <> FND_API.G_MISS_CHAR
8410: AND NVL(p_user_in_rec.TRACKING_NUMBER,'!!!') <> NVL(p_out_rec.TRACKING_NUMBER,'!!!')
8411: THEN
8412: l_attributes := l_attributes || 'TRACKING_NUMBER, ';
8413: END IF;
8411: THEN
8412: l_attributes := l_attributes || 'TRACKING_NUMBER, ';
8413: END IF;
8414:
8415: IF p_user_in_rec.MOVEMENT_ID <> FND_API.G_MISS_NUM
8416: AND NVL(p_user_in_rec.MOVEMENT_ID,-99) <> NVL(p_out_rec.MOVEMENT_ID,-99)
8417: THEN
8418: l_attributes := l_attributes || 'MOVEMENT_ID, ';
8419: END IF;
8417: THEN
8418: l_attributes := l_attributes || 'MOVEMENT_ID, ';
8419: END IF;
8420:
8421: IF p_user_in_rec.SHIPPING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
8422: AND NVL(p_user_in_rec.SHIPPING_INSTRUCTIONS,'!!!') <> NVL(p_out_rec.SHIPPING_INSTRUCTIONS,'!!!')
8423: THEN
8424: l_attributes := l_attributes || 'SHIPPING_INSTRUCTIONS, ';
8425: END IF;
8423: THEN
8424: l_attributes := l_attributes || 'SHIPPING_INSTRUCTIONS, ';
8425: END IF;
8426:
8427: IF p_user_in_rec.PACKING_INSTRUCTIONS <> FND_API.G_MISS_CHAR
8428: AND NVL(p_user_in_rec.PACKING_INSTRUCTIONS,'!!!') <> NVL(p_out_rec.PACKING_INSTRUCTIONS,'!!!')
8429: THEN
8430: l_attributes := l_attributes || 'PACKING_INSTRUCTIONS, ';
8431: END IF;
8429: THEN
8430: l_attributes := l_attributes || 'PACKING_INSTRUCTIONS, ';
8431: END IF;
8432:
8433: IF p_user_in_rec.PROJECT_ID <> FND_API.G_MISS_NUM
8434: AND NVL(p_user_in_rec.PROJECT_ID,-99) <> NVL(p_out_rec.PROJECT_ID,-99)
8435: THEN
8436: l_attributes := l_attributes || 'PROJECT_ID, ';
8437: END IF;
8435: THEN
8436: l_attributes := l_attributes || 'PROJECT_ID, ';
8437: END IF;
8438:
8439: IF p_user_in_rec.TASK_ID <> FND_API.G_MISS_NUM
8440: AND NVL(p_user_in_rec.TASK_ID,-99) <> NVL(p_out_rec.TASK_ID,-99)
8441: THEN
8442: l_attributes := l_attributes || 'TASK_ID, ';
8443: END IF;
8441: THEN
8442: l_attributes := l_attributes || 'TASK_ID, ';
8443: END IF;
8444:
8445: IF p_user_in_rec.ORG_ID <> FND_API.G_MISS_NUM
8446: AND NVL(p_user_in_rec.ORG_ID,-99) <> NVL(p_out_rec.ORG_ID,-99)
8447: THEN
8448: l_attributes := l_attributes || 'ORG_ID, ';
8449: END IF;
8447: THEN
8448: l_attributes := l_attributes || 'ORG_ID, ';
8449: END IF;
8450:
8451: IF p_user_in_rec.OE_INTERFACED_FLAG <> FND_API.G_MISS_CHAR
8452: AND NVL(p_user_in_rec.OE_INTERFACED_FLAG,'!!!') <> NVL(p_out_rec.OE_INTERFACED_FLAG,'!!!')
8453: THEN
8454: l_attributes := l_attributes || 'OE_INTERFACED_FLAG, ';
8455: END IF;
8453: THEN
8454: l_attributes := l_attributes || 'OE_INTERFACED_FLAG, ';
8455: END IF;
8456:
8457: IF p_user_in_rec.SPLIT_FROM_DETAIL_ID <> FND_API.G_MISS_NUM
8458: AND NVL(p_user_in_rec.SPLIT_FROM_DETAIL_ID,-99) <> NVL(p_out_rec.SPLIT_FROM_DETAIL_ID,-99)
8459: THEN
8460: l_attributes := l_attributes || 'SPLIT_FROM_DETAIL_ID, ';
8461: END IF;
8459: THEN
8460: l_attributes := l_attributes || 'SPLIT_FROM_DETAIL_ID, ';
8461: END IF;
8462:
8463: IF p_user_in_rec.INV_INTERFACED_FLAG <> FND_API.G_MISS_CHAR
8464: AND NVL(p_user_in_rec.INV_INTERFACED_FLAG,'!!!') <> NVL(p_out_rec.INV_INTERFACED_FLAG,'!!!')
8465: THEN
8466: l_attributes := l_attributes || 'INV_INTERFACED_FLAG, ';
8467: END IF;
8465: THEN
8466: l_attributes := l_attributes || 'INV_INTERFACED_FLAG, ';
8467: END IF;
8468:
8469: IF p_user_in_rec.SOURCE_LINE_NUMBER <> FND_API.G_MISS_CHAR
8470: AND NVL(p_user_in_rec.SOURCE_LINE_NUMBER,'!!!') <> NVL(p_out_rec.SOURCE_LINE_NUMBER,'!!!')
8471: THEN
8472: l_attributes := l_attributes || 'SOURCE_LINE_NUMBER, ';
8473: END IF;
8471: THEN
8472: l_attributes := l_attributes || 'SOURCE_LINE_NUMBER, ';
8473: END IF;
8474:
8475: IF p_user_in_rec.INSPECTION_FLAG <> FND_API.G_MISS_CHAR
8476: AND NVL(p_user_in_rec.INSPECTION_FLAG,'!!!') <> NVL(p_out_rec.INSPECTION_FLAG,'!!!')
8477: THEN
8478: l_attributes := l_attributes || 'INSPECTION_FLAG, ';
8479: END IF;
8477: THEN
8478: l_attributes := l_attributes || 'INSPECTION_FLAG, ';
8479: END IF;
8480:
8481: IF p_user_in_rec.RELEASED_STATUS <> FND_API.G_MISS_CHAR
8482: AND NVL(p_user_in_rec.RELEASED_STATUS,'!!!') <> NVL(p_out_rec.RELEASED_STATUS,'!!!')
8483: THEN
8484: l_attributes := l_attributes || 'RELEASED_STATUS, ';
8485: END IF;
8483: THEN
8484: l_attributes := l_attributes || 'RELEASED_STATUS, ';
8485: END IF;
8486:
8487: IF p_user_in_rec.CONTAINER_FLAG <> FND_API.G_MISS_CHAR
8488: AND NVL(p_user_in_rec.CONTAINER_FLAG,'!!!') <> NVL(p_out_rec.CONTAINER_FLAG,'!!!')
8489: THEN
8490: l_attributes := l_attributes || 'CONTAINER_FLAG, ';
8491: END IF;
8489: THEN
8490: l_attributes := l_attributes || 'CONTAINER_FLAG, ';
8491: END IF;
8492:
8493: IF p_user_in_rec.CONTAINER_TYPE_CODE <> FND_API.G_MISS_CHAR
8494: AND NVL(p_user_in_rec.CONTAINER_TYPE_CODE,'!!!') <> NVL(p_out_rec.CONTAINER_TYPE_CODE,'!!!')
8495: THEN
8496: l_attributes := l_attributes || 'CONTAINER_TYPE_CODE, ';
8497: END IF;
8495: THEN
8496: l_attributes := l_attributes || 'CONTAINER_TYPE_CODE, ';
8497: END IF;
8498:
8499: IF p_user_in_rec.CONTAINER_NAME <> FND_API.G_MISS_CHAR
8500: AND NVL(p_user_in_rec.CONTAINER_NAME,'!!!') <> NVL(p_out_rec.CONTAINER_NAME,'!!!')
8501: THEN
8502: l_attributes := l_attributes || 'CONTAINER_NAME, ';
8503: END IF;
8501: THEN
8502: l_attributes := l_attributes || 'CONTAINER_NAME, ';
8503: END IF;
8504:
8505: IF p_user_in_rec.FILL_PERCENT <> FND_API.G_MISS_NUM
8506: AND NVL(p_user_in_rec.FILL_PERCENT,-99) <> NVL(p_out_rec.FILL_PERCENT,-99)
8507: THEN
8508: l_attributes := l_attributes || 'FILL_PERCENT, ';
8509: END IF;
8507: THEN
8508: l_attributes := l_attributes || 'FILL_PERCENT, ';
8509: END IF;
8510:
8511: IF p_user_in_rec.GROSS_WEIGHT <> FND_API.G_MISS_NUM
8512: AND NVL(p_user_in_rec.GROSS_WEIGHT,-99) <> NVL(p_out_rec.GROSS_WEIGHT,-99)
8513: THEN
8514: l_attributes := l_attributes || 'GROSS_WEIGHT, ';
8515: END IF;
8513: THEN
8514: l_attributes := l_attributes || 'GROSS_WEIGHT, ';
8515: END IF;
8516:
8517: IF p_user_in_rec.MASTER_SERIAL_NUMBER <> FND_API.G_MISS_CHAR
8518: AND NVL(p_user_in_rec.MASTER_SERIAL_NUMBER,'!!!') <> NVL(p_out_rec.MASTER_SERIAL_NUMBER,'!!!')
8519: THEN
8520: l_attributes := l_attributes || 'MASTER_SERIAL_NUMBER, ';
8521: END IF;
8519: THEN
8520: l_attributes := l_attributes || 'MASTER_SERIAL_NUMBER, ';
8521: END IF;
8522:
8523: IF p_user_in_rec.MAXIMUM_LOAD_WEIGHT <> FND_API.G_MISS_NUM
8524: AND NVL(p_user_in_rec.MAXIMUM_LOAD_WEIGHT,-99) <> NVL(p_out_rec.MAXIMUM_LOAD_WEIGHT,-99)
8525: THEN
8526: l_attributes := l_attributes || 'MAXIMUM_LOAD_WEIGHT, ';
8527: END IF;
8525: THEN
8526: l_attributes := l_attributes || 'MAXIMUM_LOAD_WEIGHT, ';
8527: END IF;
8528:
8529: IF p_user_in_rec.MAXIMUM_VOLUME <> FND_API.G_MISS_NUM
8530: AND NVL(p_user_in_rec.MAXIMUM_VOLUME,-99) <> NVL(p_out_rec.MAXIMUM_VOLUME,-99)
8531: THEN
8532: l_attributes := l_attributes || 'MAXIMUM_VOLUME, ';
8533: END IF;
8531: THEN
8532: l_attributes := l_attributes || 'MAXIMUM_VOLUME, ';
8533: END IF;
8534:
8535: IF p_user_in_rec.MINIMUM_FILL_PERCENT <> FND_API.G_MISS_NUM
8536: AND NVL(p_user_in_rec.MINIMUM_FILL_PERCENT,-99) <> NVL(p_out_rec.MINIMUM_FILL_PERCENT,-99)
8537: THEN
8538: l_attributes := l_attributes || 'MINIMUM_FILL_PERCENT, ';
8539: END IF;
8537: THEN
8538: l_attributes := l_attributes || 'MINIMUM_FILL_PERCENT, ';
8539: END IF;
8540:
8541: IF p_user_in_rec.SEAL_CODE <> FND_API.G_MISS_CHAR
8542: AND NVL(p_user_in_rec.SEAL_CODE,'!!!') <> NVL(p_out_rec.SEAL_CODE,'!!!')
8543: THEN
8544: l_attributes := l_attributes || 'SEAL_CODE, ';
8545: END IF;
8543: THEN
8544: l_attributes := l_attributes || 'SEAL_CODE, ';
8545: END IF;
8546:
8547: IF p_user_in_rec.UNIT_NUMBER <> FND_API.G_MISS_CHAR
8548: AND NVL(p_user_in_rec.UNIT_NUMBER,'!!!') <> NVL(p_out_rec.UNIT_NUMBER,'!!!')
8549: THEN
8550: l_attributes := l_attributes || 'UNIT_NUMBER, ';
8551: END IF;
8549: THEN
8550: l_attributes := l_attributes || 'UNIT_NUMBER, ';
8551: END IF;
8552:
8553: IF p_user_in_rec.UNIT_PRICE <> FND_API.G_MISS_NUM
8554: AND NVL(p_user_in_rec.UNIT_PRICE,-99) <> NVL(p_out_rec.UNIT_PRICE,-99)
8555: THEN
8556: l_attributes := l_attributes || 'UNIT_PRICE, ';
8557: END IF;
8555: THEN
8556: l_attributes := l_attributes || 'UNIT_PRICE, ';
8557: END IF;
8558:
8559: IF p_user_in_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR
8560: AND NVL(p_user_in_rec.CURRENCY_CODE,'!!!') <> NVL(p_out_rec.CURRENCY_CODE,'!!!')
8561: THEN
8562: l_attributes := l_attributes || 'CURRENCY_CODE, ';
8563: END IF;
8561: THEN
8562: l_attributes := l_attributes || 'CURRENCY_CODE, ';
8563: END IF;
8564:
8565: IF p_user_in_rec.FREIGHT_CLASS_CAT_ID <> FND_API.G_MISS_NUM
8566: AND NVL(p_user_in_rec.FREIGHT_CLASS_CAT_ID,-99) <> NVL(p_out_rec.FREIGHT_CLASS_CAT_ID,-99)
8567: THEN
8568: l_attributes := l_attributes || 'FREIGHT_CLASS_CAT_ID, ';
8569: END IF;
8567: THEN
8568: l_attributes := l_attributes || 'FREIGHT_CLASS_CAT_ID, ';
8569: END IF;
8570:
8571: IF p_user_in_rec.COMMODITY_CODE_CAT_ID <> FND_API.G_MISS_NUM
8572: AND NVL(p_user_in_rec.COMMODITY_CODE_CAT_ID,-99) <> NVL(p_out_rec.COMMODITY_CODE_CAT_ID,-99)
8573: THEN
8574: l_attributes := l_attributes || 'COMMODITY_CODE_CAT_ID, ';
8575: END IF;
8573: THEN
8574: l_attributes := l_attributes || 'COMMODITY_CODE_CAT_ID, ';
8575: END IF;
8576:
8577: IF p_user_in_rec.PREFERRED_GRADE <> FND_API.G_MISS_CHAR
8578: AND NVL(p_user_in_rec.PREFERRED_GRADE,'!!!') <> NVL(p_out_rec.PREFERRED_GRADE,'!!!')
8579: THEN
8580: l_attributes := l_attributes || 'PREFERRED_GRADE, ';
8581: END IF;
8579: THEN
8580: l_attributes := l_attributes || 'PREFERRED_GRADE, ';
8581: END IF;
8582:
8583: IF p_user_in_rec.SRC_REQUESTED_QUANTITY2 <> FND_API.G_MISS_NUM
8584: AND NVL(p_user_in_rec.SRC_REQUESTED_QUANTITY2,-99) <> NVL(p_out_rec.SRC_REQUESTED_QUANTITY2,-99)
8585: THEN
8586: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY2, ';
8587: END IF;
8585: THEN
8586: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY2, ';
8587: END IF;
8588:
8589: IF p_user_in_rec.SRC_REQUESTED_QUANTITY_UOM2 <> FND_API.G_MISS_CHAR
8590: AND NVL(p_user_in_rec.SRC_REQUESTED_QUANTITY_UOM2,'!!!') <> NVL(p_out_rec.SRC_REQUESTED_QUANTITY_UOM2,'!!!')
8591: THEN
8592: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY_UOM2, ';
8593: END IF;
8591: THEN
8592: l_attributes := l_attributes || 'SRC_REQUESTED_QUANTITY_UOM2, ';
8593: END IF;
8594:
8595: IF p_user_in_rec.REQUESTED_QUANTITY2 <> FND_API.G_MISS_NUM
8596: AND NVL(p_user_in_rec.REQUESTED_QUANTITY2,-99) <> NVL(p_out_rec.REQUESTED_QUANTITY2,-99)
8597: THEN
8598: l_attributes := l_attributes || 'REQUESTED_QUANTITY2, ';
8599: END IF;
8597: THEN
8598: l_attributes := l_attributes || 'REQUESTED_QUANTITY2, ';
8599: END IF;
8600:
8601: IF p_user_in_rec.SHIPPED_QUANTITY2 <> FND_API.G_MISS_NUM
8602: AND NVL(p_user_in_rec.SHIPPED_QUANTITY2,-99) <> NVL(p_out_rec.SHIPPED_QUANTITY2,-99)
8603: THEN
8604: l_attributes := l_attributes || 'SHIPPED_QUANTITY2, ';
8605: END IF;
8603: THEN
8604: l_attributes := l_attributes || 'SHIPPED_QUANTITY2, ';
8605: END IF;
8606:
8607: IF p_user_in_rec.DELIVERED_QUANTITY2 <> FND_API.G_MISS_NUM
8608: AND NVL(p_user_in_rec.DELIVERED_QUANTITY2,-99) <> NVL(p_out_rec.DELIVERED_QUANTITY2,-99)
8609: THEN
8610: l_attributes := l_attributes || 'DELIVERED_QUANTITY2, ';
8611: END IF;
8609: THEN
8610: l_attributes := l_attributes || 'DELIVERED_QUANTITY2, ';
8611: END IF;
8612:
8613: IF p_user_in_rec.CANCELLED_QUANTITY2 <> FND_API.G_MISS_NUM
8614: AND NVL(p_user_in_rec.CANCELLED_QUANTITY2,-99) <> NVL(p_out_rec.CANCELLED_QUANTITY2,-99)
8615: THEN
8616: l_attributes := l_attributes || 'CANCELLED_QUANTITY2, ';
8617: END IF;
8615: THEN
8616: l_attributes := l_attributes || 'CANCELLED_QUANTITY2, ';
8617: END IF;
8618:
8619: IF p_user_in_rec.QUALITY_CONTROL_QUANTITY2 <> FND_API.G_MISS_NUM
8620: AND NVL(p_user_in_rec.QUALITY_CONTROL_QUANTITY2,-99) <> NVL(p_out_rec.QUALITY_CONTROL_QUANTITY2,-99)
8621: THEN
8622: l_attributes := l_attributes || 'QUALITY_CONTROL_QUANTITY2, ';
8623: END IF;
8621: THEN
8622: l_attributes := l_attributes || 'QUALITY_CONTROL_QUANTITY2, ';
8623: END IF;
8624:
8625: IF p_user_in_rec.CYCLE_COUNT_QUANTITY2 <> FND_API.G_MISS_NUM
8626: AND NVL(p_user_in_rec.CYCLE_COUNT_QUANTITY2,-99) <> NVL(p_out_rec.CYCLE_COUNT_QUANTITY2,-99)
8627: THEN
8628: l_attributes := l_attributes || 'CYCLE_COUNT_QUANTITY2, ';
8629: END IF;
8627: THEN
8628: l_attributes := l_attributes || 'CYCLE_COUNT_QUANTITY2, ';
8629: END IF;
8630:
8631: IF p_user_in_rec.REQUESTED_QUANTITY_UOM2 <> FND_API.G_MISS_CHAR
8632: AND NVL(p_user_in_rec.REQUESTED_QUANTITY_UOM2,'!!!') <> NVL(p_out_rec.REQUESTED_QUANTITY_UOM2,'!!!')
8633: THEN
8634: l_attributes := l_attributes || 'REQUESTED_QUANTITY_UOM2, ';
8635: END IF;
8635: END IF;
8636:
8637: -- HW OPMCONV - No need for sublot_number
8638:
8639: IF p_user_in_rec.LPN_ID <> FND_API.G_MISS_NUM
8640: AND NVL(p_user_in_rec.LPN_ID,-99) <> NVL(p_out_rec.LPN_ID,-99)
8641: THEN
8642: l_attributes := l_attributes || 'LPN_ID, ';
8643: END IF;
8641: THEN
8642: l_attributes := l_attributes || 'LPN_ID, ';
8643: END IF;
8644:
8645: IF p_user_in_rec.PICKABLE_FLAG <> FND_API.G_MISS_CHAR
8646: AND NVL(p_user_in_rec.PICKABLE_FLAG,'!!!') <> NVL(p_out_rec.PICKABLE_FLAG,'!!!')
8647: THEN
8648: l_attributes := l_attributes || 'PICKABLE_FLAG, ';
8649: END IF;
8647: THEN
8648: l_attributes := l_attributes || 'PICKABLE_FLAG, ';
8649: END IF;
8650:
8651: IF p_user_in_rec.ORIGINAL_SUBINVENTORY <> FND_API.G_MISS_CHAR
8652: AND NVL(p_user_in_rec.ORIGINAL_SUBINVENTORY,'!!!') <> NVL(p_out_rec.ORIGINAL_SUBINVENTORY,'!!!')
8653: THEN
8654: l_attributes := l_attributes || 'ORIGINAL_SUBINVENTORY, ';
8655: END IF;
8653: THEN
8654: l_attributes := l_attributes || 'ORIGINAL_SUBINVENTORY, ';
8655: END IF;
8656:
8657: IF p_user_in_rec.TO_SERIAL_NUMBER <> FND_API.G_MISS_CHAR
8658: AND NVL(p_user_in_rec.TO_SERIAL_NUMBER,'!!!') <> NVL(p_out_rec.TO_SERIAL_NUMBER,'!!!')
8659: THEN
8660: l_attributes := l_attributes || 'TO_SERIAL_NUMBER, ';
8661: END IF;
8659: THEN
8660: l_attributes := l_attributes || 'TO_SERIAL_NUMBER, ';
8661: END IF;
8662:
8663: IF p_user_in_rec.PICKED_QUANTITY <> FND_API.G_MISS_NUM
8664: AND NVL(p_user_in_rec.PICKED_QUANTITY,-99) <> NVL(p_out_rec.PICKED_QUANTITY,-99)
8665: THEN
8666: l_attributes := l_attributes || 'PICKED_QUANTITY, ';
8667: END IF;
8665: THEN
8666: l_attributes := l_attributes || 'PICKED_QUANTITY, ';
8667: END IF;
8668:
8669: IF p_user_in_rec.PICKED_QUANTITY2 <> FND_API.G_MISS_NUM
8670: AND NVL(p_user_in_rec.PICKED_QUANTITY2,-99) <> NVL(p_out_rec.PICKED_QUANTITY2,-99)
8671: THEN
8672: l_attributes := l_attributes || 'PICKED_QUANTITY2, ';
8673: END IF;
8671: THEN
8672: l_attributes := l_attributes || 'PICKED_QUANTITY2, ';
8673: END IF;
8674:
8675: IF p_user_in_rec.RECEIVED_QUANTITY <> FND_API.G_MISS_NUM
8676: AND NVL(p_user_in_rec.RECEIVED_QUANTITY,-99) <> NVL(p_out_rec.RECEIVED_QUANTITY,-99)
8677: THEN
8678: l_attributes := l_attributes || 'RECEIVED_QUANTITY, ';
8679: END IF;
8677: THEN
8678: l_attributes := l_attributes || 'RECEIVED_QUANTITY, ';
8679: END IF;
8680:
8681: IF p_user_in_rec.RECEIVED_QUANTITY2 <> FND_API.G_MISS_NUM
8682: AND NVL(p_user_in_rec.RECEIVED_QUANTITY2,-99) <> NVL(p_out_rec.RECEIVED_QUANTITY2,-99)
8683: THEN
8684: l_attributes := l_attributes || 'RECEIVED_QUANTITY2, ';
8685: END IF;
8683: THEN
8684: l_attributes := l_attributes || 'RECEIVED_QUANTITY2, ';
8685: END IF;
8686:
8687: IF p_user_in_rec.SOURCE_LINE_SET_ID <> FND_API.G_MISS_NUM
8688: AND NVL(p_user_in_rec.SOURCE_LINE_SET_ID,-99) <> NVL(p_out_rec.SOURCE_LINE_SET_ID,-99)
8689: THEN
8690: l_attributes := l_attributes || 'SOURCE_LINE_SET_ID, ';
8691: END IF;
8689: THEN
8690: l_attributes := l_attributes || 'SOURCE_LINE_SET_ID, ';
8691: END IF;
8692:
8693: IF p_user_in_rec.BATCH_ID <> FND_API.G_MISS_NUM
8694: AND NVL(p_user_in_rec.BATCH_ID,-99) <> NVL(p_out_rec.BATCH_ID,-99)
8695: THEN
8696: l_attributes := l_attributes || 'BATCH_ID, ';
8697: END IF;
8695: THEN
8696: l_attributes := l_attributes || 'BATCH_ID, ';
8697: END IF;
8698:
8699: IF p_user_in_rec.ROWID <> FND_API.G_MISS_CHAR
8700: AND NVL(p_user_in_rec.ROWID,'!!!') <> NVL(p_out_rec.ROWID,'!!!')
8701: THEN
8702: l_attributes := l_attributes || 'ROWID, ';
8703: END IF;
8701: THEN
8702: l_attributes := l_attributes || 'ROWID, ';
8703: END IF;
8704:
8705: IF p_user_in_rec.TRANSACTION_ID <> FND_API.G_MISS_NUM
8706: AND NVL(p_user_in_rec.TRANSACTION_ID,-99) <> NVL(p_out_rec.TRANSACTION_ID,-99)
8707: THEN
8708: l_attributes := l_attributes || 'TRANSACTION_ID, ';
8709: END IF;
8707: THEN
8708: l_attributes := l_attributes || 'TRANSACTION_ID, ';
8709: END IF;
8710:
8711: IF p_user_in_rec.VENDOR_ID <> FND_API.G_MISS_NUM
8712: AND NVL(p_user_in_rec.VENDOR_ID,-99) <> NVL(p_out_rec.VENDOR_ID,-99)
8713: THEN
8714: l_attributes := l_attributes || 'VENDOR_ID, ';
8715: END IF;
8713: THEN
8714: l_attributes := l_attributes || 'VENDOR_ID, ';
8715: END IF;
8716:
8717: IF p_user_in_rec.SHIP_FROM_SITE_ID <> FND_API.G_MISS_NUM
8718: AND NVL(p_user_in_rec.SHIP_FROM_SITE_ID,-99) <> NVL(p_out_rec.SHIP_FROM_SITE_ID,-99)
8719: THEN
8720: l_attributes := l_attributes || 'SHIP_FROM_SITE_ID, ';
8721: END IF;
8719: THEN
8720: l_attributes := l_attributes || 'SHIP_FROM_SITE_ID, ';
8721: END IF;
8722:
8723: IF p_user_in_rec.LINE_DIRECTION <> FND_API.G_MISS_CHAR
8724: AND NVL(p_user_in_rec.LINE_DIRECTION,'!!!') <> NVL(p_out_rec.LINE_DIRECTION,'!!!')
8725: THEN
8726: l_attributes := l_attributes || 'LINE_DIRECTION, ';
8727: END IF;
8725: THEN
8726: l_attributes := l_attributes || 'LINE_DIRECTION, ';
8727: END IF;
8728:
8729: IF p_user_in_rec.PARTY_ID <> FND_API.G_MISS_NUM
8730: AND NVL(p_user_in_rec.PARTY_ID,-99) <> NVL(p_out_rec.PARTY_ID,-99)
8731: THEN
8732: l_attributes := l_attributes || 'PARTY_ID, ';
8733: END IF;
8731: THEN
8732: l_attributes := l_attributes || 'PARTY_ID, ';
8733: END IF;
8734:
8735: IF p_user_in_rec.ROUTING_REQ_ID <> FND_API.G_MISS_NUM
8736: AND NVL(p_user_in_rec.ROUTING_REQ_ID,-99) <> NVL(p_out_rec.ROUTING_REQ_ID,-99)
8737: THEN
8738: l_attributes := l_attributes || 'ROUTING_REQ_ID, ';
8739: END IF;
8737: THEN
8738: l_attributes := l_attributes || 'ROUTING_REQ_ID, ';
8739: END IF;
8740:
8741: IF p_user_in_rec.SHIPPING_CONTROL <> FND_API.G_MISS_CHAR
8742: AND NVL(p_user_in_rec.SHIPPING_CONTROL,'!!!') <> NVL(p_out_rec.SHIPPING_CONTROL,'!!!')
8743: THEN
8744: l_attributes := l_attributes || 'SHIPPING_CONTROL, ';
8745: END IF;
8743: THEN
8744: l_attributes := l_attributes || 'SHIPPING_CONTROL, ';
8745: END IF;
8746:
8747: IF p_user_in_rec.SOURCE_BLANKET_REFERENCE_ID <> FND_API.G_MISS_NUM
8748: AND NVL(p_user_in_rec.SOURCE_BLANKET_REFERENCE_ID,-99) <> NVL(p_out_rec.SOURCE_BLANKET_REFERENCE_ID,-99)
8749: THEN
8750: l_attributes := l_attributes || 'SOURCE_BLANKET_REFERENCE_ID, ';
8751: END IF;
8749: THEN
8750: l_attributes := l_attributes || 'SOURCE_BLANKET_REFERENCE_ID, ';
8751: END IF;
8752:
8753: IF p_user_in_rec.SOURCE_BLANKET_REFERENCE_NUM <> FND_API.G_MISS_NUM
8754: AND NVL(p_user_in_rec.SOURCE_BLANKET_REFERENCE_NUM,-99) <> NVL(p_out_rec.SOURCE_BLANKET_REFERENCE_NUM,-99)
8755: THEN
8756: l_attributes := l_attributes || 'SOURCE_BLANKET_REFERENCE_NUM, ';
8757: END IF;
8755: THEN
8756: l_attributes := l_attributes || 'SOURCE_BLANKET_REFERENCE_NUM, ';
8757: END IF;
8758:
8759: IF p_user_in_rec.PO_SHIPMENT_LINE_ID <> FND_API.G_MISS_NUM
8760: AND NVL(p_user_in_rec.PO_SHIPMENT_LINE_ID,-99) <> NVL(p_out_rec.PO_SHIPMENT_LINE_ID,-99)
8761: THEN
8762: l_attributes := l_attributes || 'PO_SHIPMENT_LINE_ID, ';
8763: END IF;
8761: THEN
8762: l_attributes := l_attributes || 'PO_SHIPMENT_LINE_ID, ';
8763: END IF;
8764:
8765: IF p_user_in_rec.PO_SHIPMENT_LINE_NUMBER <> FND_API.G_MISS_NUM
8766: AND NVL(p_user_in_rec.PO_SHIPMENT_LINE_NUMBER,-99) <> NVL(p_out_rec.PO_SHIPMENT_LINE_NUMBER,-99)
8767: THEN
8768: l_attributes := l_attributes || 'PO_SHIPMENT_LINE_NUMBER, ';
8769: END IF;
8767: THEN
8768: l_attributes := l_attributes || 'PO_SHIPMENT_LINE_NUMBER, ';
8769: END IF;
8770:
8771: IF p_user_in_rec.RETURNED_QUANTITY <> FND_API.G_MISS_NUM
8772: AND NVL(p_user_in_rec.RETURNED_QUANTITY,-99) <> NVL(p_out_rec.RETURNED_QUANTITY,-99)
8773: THEN
8774: l_attributes := l_attributes || 'RETURNED_QUANTITY, ';
8775: END IF;
8773: THEN
8774: l_attributes := l_attributes || 'RETURNED_QUANTITY, ';
8775: END IF;
8776:
8777: IF p_user_in_rec.RETURNED_QUANTITY2 <> FND_API.G_MISS_NUM
8778: AND NVL(p_user_in_rec.RETURNED_QUANTITY2,-99) <> NVL(p_out_rec.RETURNED_QUANTITY2,-99)
8779: THEN
8780: l_attributes := l_attributes || 'RETURNED_QUANTITY2, ';
8781: END IF;
8779: THEN
8780: l_attributes := l_attributes || 'RETURNED_QUANTITY2, ';
8781: END IF;
8782:
8783: IF p_user_in_rec.RCV_SHIPMENT_LINE_ID <> FND_API.G_MISS_NUM
8784: AND NVL(p_user_in_rec.RCV_SHIPMENT_LINE_ID,-99) <> NVL(p_out_rec.RCV_SHIPMENT_LINE_ID,-99)
8785: THEN
8786: l_attributes := l_attributes || 'RCV_SHIPMENT_LINE_ID, ';
8787: END IF;
8785: THEN
8786: l_attributes := l_attributes || 'RCV_SHIPMENT_LINE_ID, ';
8787: END IF;
8788:
8789: IF p_user_in_rec.SOURCE_LINE_TYPE_CODE <> FND_API.G_MISS_CHAR
8790: AND NVL(p_user_in_rec.SOURCE_LINE_TYPE_CODE,'!!!') <> NVL(p_out_rec.SOURCE_LINE_TYPE_CODE,'!!!')
8791: THEN
8792: l_attributes := l_attributes || 'SOURCE_LINE_TYPE_CODE, ';
8793: END IF;
8791: THEN
8792: l_attributes := l_attributes || 'SOURCE_LINE_TYPE_CODE, ';
8793: END IF;
8794:
8795: IF p_user_in_rec.SUPPLIER_ITEM_NUMBER <> FND_API.G_MISS_CHAR
8796: AND NVL(p_user_in_rec.SUPPLIER_ITEM_NUMBER,'!!!') <> NVL(p_out_rec.SUPPLIER_ITEM_NUMBER,'!!!')
8797: THEN
8798: l_attributes := l_attributes || 'SUPPLIER_ITEM_NUMBER, ';
8799: END IF;
8797: THEN
8798: l_attributes := l_attributes || 'SUPPLIER_ITEM_NUMBER, ';
8799: END IF;
8800:
8801: IF p_user_in_rec.IGNORE_FOR_PLANNING <> FND_API.G_MISS_CHAR
8802: AND NVL(p_user_in_rec.IGNORE_FOR_PLANNING,'!!!') <> NVL(p_out_rec.IGNORE_FOR_PLANNING,'!!!')
8803: THEN
8804: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING, ';
8805: END IF;
8803: THEN
8804: l_attributes := l_attributes || 'IGNORE_FOR_PLANNING, ';
8805: END IF;
8806:
8807: IF p_user_in_rec.EARLIEST_PICKUP_DATE <> FND_API.G_MISS_DATE
8808: AND NVL(p_user_in_rec.EARLIEST_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.EARLIEST_PICKUP_DATE,TO_DATE('2','j'))
8809: THEN
8810: l_attributes := l_attributes || 'EARLIEST_PICKUP_DATE, ';
8811: END IF;
8809: THEN
8810: l_attributes := l_attributes || 'EARLIEST_PICKUP_DATE, ';
8811: END IF;
8812:
8813: IF p_user_in_rec.LATEST_PICKUP_DATE <> FND_API.G_MISS_DATE
8814: AND NVL(p_user_in_rec.LATEST_PICKUP_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LATEST_PICKUP_DATE,TO_DATE('2','j'))
8815: THEN
8816: l_attributes := l_attributes || 'LATEST_PICKUP_DATE, ';
8817: END IF;
8815: THEN
8816: l_attributes := l_attributes || 'LATEST_PICKUP_DATE, ';
8817: END IF;
8818:
8819: IF p_user_in_rec.EARLIEST_DROPOFF_DATE <> FND_API.G_MISS_DATE
8820: AND NVL(p_user_in_rec.EARLIEST_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.EARLIEST_DROPOFF_DATE,TO_DATE('2','j'))
8821: THEN
8822: l_attributes := l_attributes || 'EARLIEST_DROPOFF_DATE, ';
8823: END IF;
8821: THEN
8822: l_attributes := l_attributes || 'EARLIEST_DROPOFF_DATE, ';
8823: END IF;
8824:
8825: IF p_user_in_rec.LATEST_DROPOFF_DATE <> FND_API.G_MISS_DATE
8826: AND NVL(p_user_in_rec.LATEST_DROPOFF_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LATEST_DROPOFF_DATE,TO_DATE('2','j'))
8827: THEN
8828: l_attributes := l_attributes || 'LATEST_DROPOFF_DATE, ';
8829: END IF;
8827: THEN
8828: l_attributes := l_attributes || 'LATEST_DROPOFF_DATE, ';
8829: END IF;
8830:
8831: IF p_user_in_rec.REQUEST_DATE_TYPE_CODE <> FND_API.G_MISS_CHAR
8832: AND NVL(p_user_in_rec.REQUEST_DATE_TYPE_CODE,'!!!') <> NVL(p_out_rec.REQUEST_DATE_TYPE_CODE,'!!!')
8833: THEN
8834: l_attributes := l_attributes || 'REQUEST_DATE_TYPE_CODE, ';
8835: END IF;
8833: THEN
8834: l_attributes := l_attributes || 'REQUEST_DATE_TYPE_CODE, ';
8835: END IF;
8836:
8837: IF p_user_in_rec.TP_DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM
8838: AND NVL(p_user_in_rec.TP_DELIVERY_DETAIL_ID,-99) <> NVL(p_out_rec.TP_DELIVERY_DETAIL_ID,-99)
8839: THEN
8840: l_attributes := l_attributes || 'TP_DELIVERY_DETAIL_ID, ';
8841: END IF;
8839: THEN
8840: l_attributes := l_attributes || 'TP_DELIVERY_DETAIL_ID, ';
8841: END IF;
8842:
8843: IF p_user_in_rec.SOURCE_DOCUMENT_TYPE_ID <> FND_API.G_MISS_NUM
8844: AND NVL(p_user_in_rec.SOURCE_DOCUMENT_TYPE_ID,-99) <> NVL(p_out_rec.SOURCE_DOCUMENT_TYPE_ID,-99)
8845: THEN
8846: l_attributes := l_attributes || 'SOURCE_DOCUMENT_TYPE_ID, ';
8847: END IF;
8845: THEN
8846: l_attributes := l_attributes || 'SOURCE_DOCUMENT_TYPE_ID, ';
8847: END IF;
8848:
8849: IF p_user_in_rec.UNIT_WEIGHT <> FND_API.G_MISS_NUM
8850: AND NVL(p_user_in_rec.UNIT_WEIGHT,-99) <> NVL(p_out_rec.UNIT_WEIGHT,-99)
8851: THEN
8852: l_attributes := l_attributes || 'UNIT_WEIGHT, ';
8853: END IF;
8851: THEN
8852: l_attributes := l_attributes || 'UNIT_WEIGHT, ';
8853: END IF;
8854:
8855: IF p_user_in_rec.UNIT_VOLUME <> FND_API.G_MISS_NUM
8856: AND NVL(p_user_in_rec.UNIT_VOLUME,-99) <> NVL(p_out_rec.UNIT_VOLUME,-99)
8857: THEN
8858: l_attributes := l_attributes || 'UNIT_VOLUME, ';
8859: END IF;
8857: THEN
8858: l_attributes := l_attributes || 'UNIT_VOLUME, ';
8859: END IF;
8860:
8861: IF p_user_in_rec.FILLED_VOLUME <> FND_API.G_MISS_NUM
8862: AND NVL(p_user_in_rec.FILLED_VOLUME,-99) <> NVL(p_out_rec.FILLED_VOLUME,-99)
8863: THEN
8864: l_attributes := l_attributes || 'FILLED_VOLUME, ';
8865: END IF;
8863: THEN
8864: l_attributes := l_attributes || 'FILLED_VOLUME, ';
8865: END IF;
8866:
8867: IF p_user_in_rec.WV_FROZEN_FLAG <> FND_API.G_MISS_CHAR
8868: AND NVL(p_user_in_rec.WV_FROZEN_FLAG,'!!!') <> NVL(p_out_rec.WV_FROZEN_FLAG,'!!!')
8869: THEN
8870: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
8871: END IF;
8869: THEN
8870: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
8871: END IF;
8872:
8873: IF p_user_in_rec.MODE_OF_TRANSPORT <> FND_API.G_MISS_CHAR
8874: AND NVL(p_user_in_rec.MODE_OF_TRANSPORT,'!!!') <> NVL(p_out_rec.MODE_OF_TRANSPORT,'!!!')
8875: THEN
8876: l_attributes := l_attributes || 'MODE_OF_TRANSPORT, ';
8877: END IF;
8875: THEN
8876: l_attributes := l_attributes || 'MODE_OF_TRANSPORT, ';
8877: END IF;
8878:
8879: IF p_user_in_rec.SERVICE_LEVEL <> FND_API.G_MISS_CHAR
8880: AND NVL(p_user_in_rec.SERVICE_LEVEL,'!!!') <> NVL(p_out_rec.SERVICE_LEVEL,'!!!')
8881: THEN
8882: l_attributes := l_attributes || 'SERVICE_LEVEL, ';
8883: END IF;
8881: THEN
8882: l_attributes := l_attributes || 'SERVICE_LEVEL, ';
8883: END IF;
8884:
8885: IF p_user_in_rec.PO_REVISION_NUMBER <> FND_API.G_MISS_NUM
8886: AND NVL(p_user_in_rec.PO_REVISION_NUMBER,-99) <> NVL(p_out_rec.PO_REVISION_NUMBER,-99)
8887: THEN
8888: l_attributes := l_attributes || 'PO_REVISION_NUMBER, ';
8889: END IF;
8887: THEN
8888: l_attributes := l_attributes || 'PO_REVISION_NUMBER, ';
8889: END IF;
8890:
8891: IF p_user_in_rec.RELEASE_REVISION_NUMBER <> FND_API.G_MISS_NUM
8892: AND NVL(p_user_in_rec.RELEASE_REVISION_NUMBER,-99) <> NVL(p_out_rec.RELEASE_REVISION_NUMBER,-99)
8893: THEN
8894: l_attributes := l_attributes || 'RELEASE_REVISION_NUMBER, ';
8895: END IF;