[Home] [Help]
19: p_param_name IN VARCHAR2,
20: p_api_name IN VARCHAR2
21: ) IS
22: BEGIN
23: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
24: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
25: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
26: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
27: FND_MSG_PUB.Add;
24: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
25: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
26: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
27: FND_MSG_PUB.Add;
28: RAISE FND_API.G_EXC_ERROR;
29: END IF;
30: END Check_Reqd_Param_num;
31:
32: /*-----------------------------------------------------------*/
40: p_param_name IN VARCHAR2,
41: p_api_name IN VARCHAR2
42: ) IS
43: BEGIN
44: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
45: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
46: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
47: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
48: FND_MSG_PUB.Add;
45: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
46: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
47: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
48: FND_MSG_PUB.Add;
49: RAISE FND_API.G_EXC_ERROR;
50: END IF;
51: END Check_Reqd_Param_char;
52:
53: /*-----------------------------------------------------------*/
61: p_param_name IN VARCHAR2,
62: p_api_name IN VARCHAR2
63: ) IS
64: BEGIN
65: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
66: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
67: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
68: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
69: FND_MSG_PUB.Add;
66: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
67: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
68: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
69: FND_MSG_PUB.Add;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: END Check_Reqd_Param_date;
73:
74: /*-----------------------------------------------------*/
156: BEGIN
157: IF p_mode='CREATE'
158: THEN
159: IF ((p_item_instance_id IS NULL) OR
160: (p_item_instance_id = FND_API.G_MISS_NUM)) THEN
161: l_return_value := FALSE;
162: ELSE
163: IF ((p_instance_number IS NULL) OR
164: (p_instance_number = FND_API.G_MISS_CHAR)) THEN
160: (p_item_instance_id = FND_API.G_MISS_NUM)) THEN
161: l_return_value := FALSE;
162: ELSE
163: IF ((p_instance_number IS NULL) OR
164: (p_instance_number = FND_API.G_MISS_CHAR)) THEN
165: l_return_value := TRUE;
166: ELSE
167: -- Added for eam integration
168: BEGIN
260: AND nvl (end_date_active, sysdate+1) > sysdate;
261:
262:
263:
264: If p_trackable_flag <> FND_API.G_MISS_CHAR then
265: if nvl(p_trackable_flag,'N') <> 'Y' then
266: l_return_value := FALSE;
267: IF (p_stack_err_msg = TRUE) THEN
268: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_TRACKABLE');
278: RETURN l_return_value;
279: End if;
280: --
281: -- Check for inventory item id and Org id values
282: IF ((p_inv_item_id IS NOT NULL) AND (p_inv_item_id <> FND_API.G_MISS_NUM)) AND
283: ((p_org_id IS NOT NULL) AND (p_org_id <> FND_API.G_MISS_NUM)) THEN
284:
285:
286: IF UPPER(l_temp_string) = 'Y' THEN
279: End if;
280: --
281: -- Check for inventory item id and Org id values
282: IF ((p_inv_item_id IS NOT NULL) AND (p_inv_item_id <> FND_API.G_MISS_NUM)) AND
283: ((p_org_id IS NOT NULL) AND (p_org_id <> FND_API.G_MISS_NUM)) THEN
284:
285:
286: IF UPPER(l_temp_string) = 'Y' THEN
287: l_return_value := TRUE;
326: l_return_value IN OUT NOCOPY BOOLEAN
327: ) IS
328:
329: BEGIN
330: IF p_instance_rec.serial_number <> fnd_api.g_miss_char
331: AND p_instance_rec.serial_number IS NOT NULL
332: THEN
333: csi_item_instance_vld_pvt.Validate_Serial_Number
334: (
344: l_return_value => l_return_value
345: );
346: END IF;
347:
348: IF p_instance_rec.lot_number <> fnd_api.g_miss_char
349: AND p_instance_rec.lot_number IS NOT NULL
350: AND l_return_value
351: THEN
352: csi_item_instance_vld_pvt.Validate_Lot_Number
360: l_return_value => l_return_value
361: );
362: END IF;
363:
364: IF p_instance_rec.inventory_revision <> fnd_api.g_miss_char
365: AND p_instance_rec.inventory_revision IS NOT NULL
366: AND l_return_value
367: THEN
368: csi_item_instance_vld_pvt.Validate_Revision
405: AND nvl (start_date_active, sysdate) <= sysdate
406: AND nvl (end_date_active, sysdate+1) > sysdate;
407:
408: BEGIN
409: If p_rev_control_code <> FND_API.G_MISS_NUM Then
410: l_dummy := p_rev_control_code;
411: else
412: OPEN c1;
413: FETCH c1 into l_dummy;
419: -- '1' stands for - No revision control
420: -- '2' stands for - Full revision control
421: IF NVL(l_dummy,0) = 2 THEN
422: IF ((p_revision IS NULL) OR
423: (p_revision = FND_API.G_MISS_CHAR)) THEN
424: IF (p_creation_complete_flag = 'Y') THEN
425: l_return_value := FALSE;
426: IF ( l_stack_err_msg = TRUE ) THEN
427: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REVISION');
453: END;
454: END IF;
455: ELSE
456: -- Item is not under revision control but inventory_revision is not NULL
457: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN
458: BEGIN
459: SELECT 1
460: INTO l_dummy
461: FROM mtl_item_revisions
512: AND nvl (end_date_active, sysdate+1) > sysdate;
513:
514: BEGIN
515: l_return_value := TRUE;
516: If p_rev_control_code <> FND_API.G_MISS_NUM Then
517: l_dummy := p_rev_control_code;
518: else
519: OPEN c1;
520: FETCH c1 into l_dummy;
526: -- '1' stands for - No revision control
527: -- '2' stands for - Full revision control
528: IF NVL(l_dummy,0) = 2 THEN
529: IF ((p_revision IS NULL) OR
530: (p_revision = FND_API.G_MISS_CHAR)) THEN
531: l_return_value := FALSE;
532: IF ( l_stack_err_msg = TRUE ) THEN
533: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REVISION');
534: FND_MESSAGE.SET_TOKEN('INVENTORY_REVISION',p_revision);
554: END;
555: END IF;
556: ELSE
557: -- Item is not under revision control but inventory_revision is not NULL
558: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN
559: BEGIN
560: SELECT 1
561: INTO l_dummy
562: FROM mtl_item_revisions
703: -- Across organizations (status = 3)
704: --
705: --
706: l_return_value := TRUE;
707: p_ins_flag := FND_API.G_FALSE;
708: --
709:
710: IF nvl(p_lot_number,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
711: l_lot_number := NULL;
706: l_return_value := TRUE;
707: p_ins_flag := FND_API.G_FALSE;
708: --
709:
710: IF nvl(p_lot_number,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
711: l_lot_number := NULL;
712: ELSE
713: l_lot_number := p_lot_number;
714: END IF;
733: -- the same should get created with current_status = 4 (out of stores). All other statuses should be
734: -- driven by Inventory.
735: --
736: /****** COMMENTED
737: IF ((p_location_type_code IS NOT NULL) AND (p_location_type_code <> FND_API.G_MISS_CHAR))
738: THEN
739: IF p_location_type_code = 'IN_TRANSIT'
740: THEN
741: l_current_status := 5;
804: CLOSE ser_upd_csr;
805: csi_gen_utility_pvt.put_line('Calling INV API to update Serial Number...');
806: inv_serial_number_pub.updateserial(
807: p_api_version => 1.0
808: ,p_init_msg_list => fnd_api.g_false
809: ,p_commit => fnd_api.g_false
810: ,p_validation_level => fnd_api.g_valid_level_full
811: ,p_inventory_item_id => p_inv_item_id
812: ,p_organization_id => p_inv_org_id
805: csi_gen_utility_pvt.put_line('Calling INV API to update Serial Number...');
806: inv_serial_number_pub.updateserial(
807: p_api_version => 1.0
808: ,p_init_msg_list => fnd_api.g_false
809: ,p_commit => fnd_api.g_false
810: ,p_validation_level => fnd_api.g_valid_level_full
811: ,p_inventory_item_id => p_inv_item_id
812: ,p_organization_id => p_inv_org_id
813: ,p_serial_number => p_serial_number
806: inv_serial_number_pub.updateserial(
807: p_api_version => 1.0
808: ,p_init_msg_list => fnd_api.g_false
809: ,p_commit => fnd_api.g_false
810: ,p_validation_level => fnd_api.g_valid_level_full
811: ,p_inventory_item_id => p_inv_item_id
812: ,p_organization_id => p_inv_org_id
813: ,p_serial_number => p_serial_number
814: ,p_initialization_date => l_ser_upd_csr.initialization_date
843: ,p_planning_tp_type => NULL
844: ,p_transaction_action_id => NULL
845: );
846: p_gen_object_id := l_object_id;
847: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: l_return_value := FALSE;
849: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_UPD_SERIAL');
850: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from inv_serial_number_pub.updateserial');
851: FND_MSG_PUB.ADD;
1012: -- call the Inventory API to insert serial no. into the MSN table
1013: csi_gen_utility_pvt.put_line('Calling INV API to create Serial Number...');
1014: inv_serial_number_pub.insertSerial(
1015: p_api_version => 1.0,
1016: p_init_msg_list => fnd_api.g_false,
1017: p_commit => fnd_api.g_false,
1018: p_validation_level => fnd_api.g_valid_level_full,
1019: p_inventory_item_id => p_inv_item_id,
1020: p_organization_id => p_inv_org_id,
1013: csi_gen_utility_pvt.put_line('Calling INV API to create Serial Number...');
1014: inv_serial_number_pub.insertSerial(
1015: p_api_version => 1.0,
1016: p_init_msg_list => fnd_api.g_false,
1017: p_commit => fnd_api.g_false,
1018: p_validation_level => fnd_api.g_valid_level_full,
1019: p_inventory_item_id => p_inv_item_id,
1020: p_organization_id => p_inv_org_id,
1021: p_serial_number => p_serial_number,
1014: inv_serial_number_pub.insertSerial(
1015: p_api_version => 1.0,
1016: p_init_msg_list => fnd_api.g_false,
1017: p_commit => fnd_api.g_false,
1018: p_validation_level => fnd_api.g_valid_level_full,
1019: p_inventory_item_id => p_inv_item_id,
1020: p_organization_id => p_inv_org_id,
1021: p_serial_number => p_serial_number,
1022: p_initialization_date => SYSDATE,
1055: p_operation_seq_num => NULL,
1056: p_intraoperation_step_type => NULL );
1057:
1058: p_gen_object_id := l_object_id;
1059: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1060: l_return_value := FALSE;
1061: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_INV_SERIAL');
1062: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from inv_serial_number_pub.insertserial');
1063: FND_MSG_PUB.ADD;
1062: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from inv_serial_number_pub.insertserial');
1063: FND_MSG_PUB.ADD;
1064: ELSE
1065: l_return_value := TRUE;
1066: p_ins_flag := FND_API.G_TRUE;
1067: csi_gen_utility_pvt.put_line('Serial Number created successfully in MTL_SERIAL_NUMBERS..');
1068: END IF;
1069: END IF; -- (l_temp is null)
1070: END IF;
1116: Serialized NUMBER;
1117: l_found VARCHAR2(1);
1118: BEGIN
1119: l_return_value := TRUE;
1120: If p_srl_control_code <> FND_API.G_MISS_NUM then
1121: serialized := p_srl_control_code;
1122: else
1123: OPEN c1;
1124: FETCH c1 into serialized;
1136: ,p_transaction_type_id => p_txn_rec.transaction_type_id
1137: )
1138: THEN
1139: IF ((p_serial_number IS NULL) OR
1140: (p_serial_number = FND_API.G_MISS_CHAR)) THEN
1141: IF (p_creation_complete_flag = 'Y') THEN
1142: l_return_value := FALSE;
1143: IF (p_stack_err_msg = TRUE) THEN
1144: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SERIAL_NUM');
1159: ,p_location_type_code => p_location_type_code
1160: ,p_transaction_type_id => p_txn_rec.transaction_type_id
1161: )
1162: THEN
1163: IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR))
1164: THEN
1165: l_found := NULL;
1166: IF serialized IS NOT NULL
1167: AND serialized=6
1201: END IF;
1202:
1203: IF l_return_value = TRUE AND
1204: p_serial_number IS NOT NULL AND
1205: p_serial_number <> fnd_api.g_miss_char
1206: THEN
1207: Validate_ser_uniqueness
1208: ( p_inv_org_id => p_inv_org_id
1209: ,p_inv_item_id => p_inv_item_id
1250: -- API. This is basically to validate the serial number when the vld_organization_id changes.
1251: -- In this, the uniqueness check should ignore the current instance.
1252: --
1253: IF p_instance_id IS NULL OR
1254: p_instance_id = FND_API.G_MISS_NUM THEN
1255: l_instance_id := -99999;
1256: ELSE
1257: l_instance_id := p_instance_id;
1258: END IF;
1503: --
1504: BEGIN
1505: --
1506: IF ((p_instance_id IS NULL) OR
1507: (p_instance_id = FND_API.G_MISS_NUM)) THEN
1508: l_instance_id := -99999;
1509: ELSE
1510: l_instance_id := p_instance_id;
1511: END IF;
1599: --
1600: -- Call the Inventory API to insert the lot number
1601: inv_lot_api_pub.insertlot (
1602: p_api_version => 1.0,
1603: p_init_msg_list => fnd_api.g_false,
1604: p_commit => fnd_api.g_false,
1605: p_validation_level => fnd_api.g_valid_level_full,
1606: p_inventory_item_id => p_inv_item_id,
1607: p_organization_id => p_inv_org_id,
1600: -- Call the Inventory API to insert the lot number
1601: inv_lot_api_pub.insertlot (
1602: p_api_version => 1.0,
1603: p_init_msg_list => fnd_api.g_false,
1604: p_commit => fnd_api.g_false,
1605: p_validation_level => fnd_api.g_valid_level_full,
1606: p_inventory_item_id => p_inv_item_id,
1607: p_organization_id => p_inv_org_id,
1608: p_lot_number => p_lot_number,
1601: inv_lot_api_pub.insertlot (
1602: p_api_version => 1.0,
1603: p_init_msg_list => fnd_api.g_false,
1604: p_commit => fnd_api.g_false,
1605: p_validation_level => fnd_api.g_valid_level_full,
1606: p_inventory_item_id => p_inv_item_id,
1607: p_organization_id => p_inv_org_id,
1608: p_lot_number => p_lot_number,
1609: p_expiration_date => l_expiration_date,
1614: x_return_status => l_return_status,
1615: x_msg_count => l_msg_count,
1616: x_msg_data => l_msg_data);
1617:
1618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1619: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_INV_LOT_NUM');
1620: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from inv_lot_api_pub.InsertLot Procedure');
1621: FND_MSG_PUB.ADD;
1622: RAISE comp_error;
1660: AND nvl (start_date_active, sysdate) <= sysdate
1661: AND nvl (end_date_active, sysdate+1) > sysdate;
1662:
1663: BEGIN
1664: IF p_lot_control_code <> FND_API.G_MISS_NUM
1665: THEN
1666: l_dummy := p_lot_control_code;
1667: ELSE
1668: OPEN c1;
1678: IF l_dummy = 2 -- Lot Controlled
1679: THEN
1680: --
1681: IF ((p_lot_number IS NULL) OR
1682: (p_lot_number = FND_API.G_MISS_CHAR))
1683: THEN
1684: IF (p_creation_complete_flag = 'Y')
1685: THEN
1686: l_return_value := FALSE;
1697: --
1698: ELSE -- Item is not under lot control but lot_number is NOT NULL
1699: --
1700: IF ((p_lot_number IS NOT NULL) AND
1701: (p_lot_number <> FND_API.G_MISS_CHAR))
1702: THEN
1703: l_return_value := FALSE;
1704: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_LOT_CONTROLLED');
1705: FND_MESSAGE.SET_TOKEN('LOT_NUMBER',p_lot_number);
1750: WHERE organization_id = p_inv_organization_id;
1751:
1752: BEGIN
1753:
1754: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
1755: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized
1756: ( p_serial_control_code => p_serial_control_code
1757: ,p_location_type_code => p_location_type_code
1758: ,p_transaction_type_id => p_csi_txn_type_id
1813: END IF;
1814: CLOSE C1;
1815: ELSIF p_quantity > 1 AND
1816: (p_instance_id IS NOT NULL AND
1817: p_instance_id <> fnd_api.g_miss_num)
1818: THEN
1819: BEGIN
1820: SELECT subject_id
1821: INTO l_dummy
1933: to_unit VARCHAR2(3);
1934: BEGIN
1935: -- check whether the uom class exists for the unit of measure code passed
1936: IF ((p_uom_code IS NULL) OR
1937: (p_uom_code = FND_API.G_MISS_CHAR)) THEN
1938: IF (p_creation_complete_flag = 'Y') THEN
1939: l_return_value := FALSE;
1940: ELSE
1941: p_creation_complete_flag := 'N';
1966: FND_MSG_PUB.Add;
1967: l_return_value := FALSE;
1968: END;
1969: -- if primary uom code exists, then check whether it is same as the uom code passed
1970: IF ((to_unit IS NOT NULL) AND (to_unit <> FND_API.G_MISS_CHAR)) THEN
1971: IF to_unit = p_uom_code THEN
1972: p_quantity := p_quantity;
1973: p_uom_code := to_unit;
1974: l_return_value := TRUE;
2014: -- Verify that the Instance Condition is valid i.e.
2015: -- it exists in inventory material status codes (MTL_MATERIAL_STATUSES_B)
2016:
2017: IF ((p_instance_condition_id IS NULL) OR
2018: (p_instance_condition_id = FND_API.G_MISS_NUM)) THEN
2019: l_return_value := TRUE;
2020: ELSE
2021: BEGIN
2022: SELECT '1'
2056: -- raise the CSI_API_INVALID_INST_STATUS exception.
2057: BEGIN
2058:
2059: IF ((p_instance_status_id IS NULL) OR
2060: (p_instance_status_id = FND_API.G_MISS_NUM))THEN
2061: IF (p_creation_complete_flag = 'Y') THEN
2062: l_return_value := FALSE;
2063: IF ( l_stack_err_msg = TRUE ) THEN
2064: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_STATUS');
2105:
2106: l_return_value BOOLEAN := TRUE;
2107:
2108: BEGIN
2109: IF ((p_end_date IS NOT NULL) AND (p_end_date = FND_API.G_MISS_DATE)) THEN
2110:
2111: IF p_start_date > p_end_date THEN
2112: l_return_value := FALSE;
2113: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_START_DATE');
2145: l_return_value BOOLEAN := TRUE;
2146:
2147: BEGIN
2148:
2149: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
2150:
2151: IF p_start_date > p_end_date THEN
2152: l_return_value := FALSE;
2153: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_END_DATE');
2188: -- Validate the System ID against CSI_SYSTEMS_VL table .
2189: BEGIN
2190:
2191: IF ((p_system_id IS NULL) OR
2192: (p_system_id = FND_API.G_MISS_NUM)) THEN
2193: l_return_value := TRUE;
2194: ELSE
2195: BEGIN
2196: SELECT '1'
2233: -- Validate the Instance Type Code against CSI_LOOKUPS table .
2234: BEGIN
2235:
2236: IF ((p_instance_type_code IS NULL) OR
2237: (p_instance_type_code = FND_API.G_MISS_CHAR)) THEN
2238: l_return_value := TRUE;
2239: ELSE
2240: BEGIN
2241: SELECT '1'
2277: -- Validate the System ID against CSI_LOOKUPS table .
2278: BEGIN
2279:
2280: IF ((p_inst_usage_code IS NULL) OR
2281: (p_inst_usage_code = FND_API.G_MISS_CHAR)) THEN
2282: l_return_value := TRUE;
2283: ELSE
2284: BEGIN
2285: SELECT '1'
2319:
2320: -- Validate the System ID against CSI_LOOKUPS table .
2321: BEGIN
2322: IF ((p_operational_status IS NULL) OR
2323: (p_operational_status = FND_API.G_MISS_CHAR))
2324: THEN
2325: l_return_value := TRUE;
2326: ELSE
2327: BEGIN
2357: l_dummy VARCHAR2(30);
2358: l_return_value BOOLEAN := TRUE;
2359: BEGIN
2360: IF ((p_currency_code IS NULL) OR
2361: (p_currency_code = FND_API.G_MISS_CHAR))
2362: THEN
2363: l_return_value := TRUE;
2364: ELSE
2365: BEGIN
2436: l_count NUMBER;
2437:
2438: BEGIN
2439: If p_srl_control_code is not null AND
2440: p_srl_control_code <> FND_API.G_MISS_NUM then
2441: l_serial_code := p_srl_control_code;
2442: l_return_value := TRUE;
2443: Else
2444: select serial_number_control_code
2477: AND a.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
2478: AND a.active_end_date IS NULL --code added for bug 5702911 --
2479: AND (
2480: (a.inventory_revision IS NULL AND p_instance_rec.inventory_revision IS NULL) OR
2481: (a.inventory_revision IS NULL AND p_instance_rec.inventory_revision = FND_API.G_MISS_CHAR) OR
2482: (a.inventory_revision = p_instance_rec.inventory_revision)
2483: )
2484: AND (
2485: (a.lot_number IS NULL AND p_instance_rec.lot_number IS NULL) OR
2482: (a.inventory_revision = p_instance_rec.inventory_revision)
2483: )
2484: AND (
2485: (a.lot_number IS NULL AND p_instance_rec.lot_number IS NULL) OR
2486: (a.lot_number IS NULL AND p_instance_rec.lot_number = FND_API.G_MISS_CHAR) OR
2487: (a.lot_number = p_instance_rec.lot_number)
2488: )
2489: AND (
2490: (a.inv_locator_id IS NULL AND p_instance_rec.inv_locator_id IS NULL) OR
2487: (a.lot_number = p_instance_rec.lot_number)
2488: )
2489: AND (
2490: (a.inv_locator_id IS NULL AND p_instance_rec.inv_locator_id IS NULL) OR
2491: (a.inv_locator_id IS NULL AND p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM) OR
2492: (a.inv_locator_id = p_instance_rec.inv_locator_id)
2493: )
2494: AND a.owner_party_id = p_party_rec.party_id
2495: AND a.owner_party_source_table = p_party_rec.party_source_table;
2542:
2543: BEGIN
2544:
2545: IF ((p_loc_source_table IS NULL) OR
2546: (p_loc_source_table = FND_API.G_MISS_CHAR)) THEN
2547: l_return_value := TRUE;
2548: ELSE
2549: BEGIN
2550: SELECT '1'
2579: IS
2580: BEGIN
2581:
2582: --
2583: IF ( p_instance_rec.instance_id = fnd_api.g_miss_num )
2584: THEN l_get_instance_rec.instance_id := l_curr_instance_rec.instance_id;
2585: ELSE l_get_instance_rec.instance_id := p_instance_rec.instance_id;
2586: END IF;
2587:
2584: THEN l_get_instance_rec.instance_id := l_curr_instance_rec.instance_id;
2585: ELSE l_get_instance_rec.instance_id := p_instance_rec.instance_id;
2586: END IF;
2587:
2588: IF ( p_instance_rec.instance_number = fnd_api.g_miss_char )
2589: THEN l_get_instance_rec.instance_number := l_curr_instance_rec.instance_number;
2590: ELSE l_get_instance_rec.instance_number := p_instance_rec.instance_number;
2591: END IF;
2592:
2589: THEN l_get_instance_rec.instance_number := l_curr_instance_rec.instance_number;
2590: ELSE l_get_instance_rec.instance_number := p_instance_rec.instance_number;
2591: END IF;
2592:
2593: IF ( p_instance_rec.external_reference = fnd_api.g_miss_char )
2594: THEN l_get_instance_rec.external_reference := l_curr_instance_rec.external_reference;
2595: ELSE l_get_instance_rec.external_reference := p_instance_rec.external_reference;
2596: END IF;
2597: --
2594: THEN l_get_instance_rec.external_reference := l_curr_instance_rec.external_reference;
2595: ELSE l_get_instance_rec.external_reference := p_instance_rec.external_reference;
2596: END IF;
2597: --
2598: IF ( p_instance_rec.inventory_item_id = fnd_api.g_miss_num )
2599: THEN l_get_instance_rec.inventory_item_id := l_curr_instance_rec.inventory_item_id;
2600: ELSE l_get_instance_rec.inventory_item_id := p_instance_rec.inventory_item_id;
2601: END IF;
2602: --
2599: THEN l_get_instance_rec.inventory_item_id := l_curr_instance_rec.inventory_item_id;
2600: ELSE l_get_instance_rec.inventory_item_id := p_instance_rec.inventory_item_id;
2601: END IF;
2602: --
2603: IF ( p_instance_rec.inventory_revision = fnd_api.g_miss_char )
2604: THEN l_get_instance_rec.inventory_revision := l_curr_instance_rec.inventory_revision;
2605: ELSE l_get_instance_rec.inventory_revision := p_instance_rec.inventory_revision;
2606: END IF;
2607: --
2604: THEN l_get_instance_rec.inventory_revision := l_curr_instance_rec.inventory_revision;
2605: ELSE l_get_instance_rec.inventory_revision := p_instance_rec.inventory_revision;
2606: END IF;
2607: --
2608: IF ( p_instance_rec.inv_master_organization_id = fnd_api.g_miss_num )
2609: THEN l_get_instance_rec.inv_master_organization_id := l_curr_instance_rec.inv_master_organization_id;
2610: ELSE l_get_instance_rec.inv_master_organization_id := p_instance_rec.inv_master_organization_id;
2611: END IF;
2612: --
2609: THEN l_get_instance_rec.inv_master_organization_id := l_curr_instance_rec.inv_master_organization_id;
2610: ELSE l_get_instance_rec.inv_master_organization_id := p_instance_rec.inv_master_organization_id;
2611: END IF;
2612: --
2613: IF ( p_instance_rec.serial_number = fnd_api.g_miss_char )
2614: THEN l_get_instance_rec.serial_number := l_curr_instance_rec.serial_number;
2615: ELSE l_get_instance_rec.serial_number := p_instance_rec.serial_number;
2616: END IF;
2617: --
2614: THEN l_get_instance_rec.serial_number := l_curr_instance_rec.serial_number;
2615: ELSE l_get_instance_rec.serial_number := p_instance_rec.serial_number;
2616: END IF;
2617: --
2618: IF ( p_instance_rec.mfg_serial_number_flag = fnd_api.g_miss_char )
2619: THEN l_get_instance_rec.mfg_serial_number_flag := l_curr_instance_rec.mfg_serial_number_flag;
2620: ELSE l_get_instance_rec.mfg_serial_number_flag := p_instance_rec.mfg_serial_number_flag;
2621: END IF;
2622: --
2619: THEN l_get_instance_rec.mfg_serial_number_flag := l_curr_instance_rec.mfg_serial_number_flag;
2620: ELSE l_get_instance_rec.mfg_serial_number_flag := p_instance_rec.mfg_serial_number_flag;
2621: END IF;
2622: --
2623: IF ( p_instance_rec.lot_number = fnd_api.g_miss_char )
2624: THEN l_get_instance_rec.lot_number := l_curr_instance_rec.lot_number;
2625: ELSE l_get_instance_rec.lot_number := p_instance_rec.lot_number;
2626: END IF;
2627: --
2624: THEN l_get_instance_rec.lot_number := l_curr_instance_rec.lot_number;
2625: ELSE l_get_instance_rec.lot_number := p_instance_rec.lot_number;
2626: END IF;
2627: --
2628: IF ( p_instance_rec.quantity = fnd_api.g_miss_num )
2629: THEN l_get_instance_rec.quantity := l_curr_instance_rec.quantity;
2630: ELSE l_get_instance_rec.quantity := p_instance_rec.quantity;
2631: END IF;
2632: --
2629: THEN l_get_instance_rec.quantity := l_curr_instance_rec.quantity;
2630: ELSE l_get_instance_rec.quantity := p_instance_rec.quantity;
2631: END IF;
2632: --
2633: IF ( p_instance_rec.unit_of_measure = fnd_api.g_miss_char )
2634: THEN l_get_instance_rec.unit_of_measure := l_curr_instance_rec.unit_of_measure;
2635: ELSE l_get_instance_rec.unit_of_measure := p_instance_rec.unit_of_measure;
2636: END IF;
2637: --
2634: THEN l_get_instance_rec.unit_of_measure := l_curr_instance_rec.unit_of_measure;
2635: ELSE l_get_instance_rec.unit_of_measure := p_instance_rec.unit_of_measure;
2636: END IF;
2637: --
2638: IF ( p_instance_rec.accounting_class_code = fnd_api.g_miss_char )
2639: THEN l_get_instance_rec.accounting_class_code := l_curr_instance_rec.accounting_class_code;
2640: ELSE l_get_instance_rec.accounting_class_code := p_instance_rec.accounting_class_code;
2641: END IF;
2642: --
2639: THEN l_get_instance_rec.accounting_class_code := l_curr_instance_rec.accounting_class_code;
2640: ELSE l_get_instance_rec.accounting_class_code := p_instance_rec.accounting_class_code;
2641: END IF;
2642: --
2643: IF ( p_instance_rec.instance_condition_id = fnd_api.g_miss_num )
2644: THEN l_get_instance_rec.instance_condition_id := l_curr_instance_rec.instance_condition_id;
2645: ELSE l_get_instance_rec.instance_condition_id := p_instance_rec.instance_condition_id;
2646: END IF;
2647: --
2644: THEN l_get_instance_rec.instance_condition_id := l_curr_instance_rec.instance_condition_id;
2645: ELSE l_get_instance_rec.instance_condition_id := p_instance_rec.instance_condition_id;
2646: END IF;
2647: --
2648: IF ( p_instance_rec.instance_status_id = fnd_api.g_miss_num )
2649: THEN l_get_instance_rec.instance_status_id := l_curr_instance_rec.instance_status_id;
2650: ELSE l_get_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
2651: END IF;
2652: --
2649: THEN l_get_instance_rec.instance_status_id := l_curr_instance_rec.instance_status_id;
2650: ELSE l_get_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
2651: END IF;
2652: --
2653: IF ( p_instance_rec.customer_view_flag = fnd_api.g_miss_char )
2654: THEN l_get_instance_rec.customer_view_flag := l_curr_instance_rec.customer_view_flag;
2655: ELSE l_get_instance_rec.customer_view_flag := p_instance_rec.customer_view_flag;
2656: END IF;
2657: --
2654: THEN l_get_instance_rec.customer_view_flag := l_curr_instance_rec.customer_view_flag;
2655: ELSE l_get_instance_rec.customer_view_flag := p_instance_rec.customer_view_flag;
2656: END IF;
2657: --
2658: IF ( p_instance_rec.merchant_view_flag = fnd_api.g_miss_char )
2659: THEN l_get_instance_rec.merchant_view_flag := l_curr_instance_rec.merchant_view_flag;
2660: ELSE l_get_instance_rec.merchant_view_flag := p_instance_rec.merchant_view_flag;
2661: END IF;
2662: --
2659: THEN l_get_instance_rec.merchant_view_flag := l_curr_instance_rec.merchant_view_flag;
2660: ELSE l_get_instance_rec.merchant_view_flag := p_instance_rec.merchant_view_flag;
2661: END IF;
2662: --
2663: IF ( p_instance_rec.sellable_flag = fnd_api.g_miss_char )
2664: THEN l_get_instance_rec.sellable_flag := l_curr_instance_rec.sellable_flag;
2665: ELSE l_get_instance_rec.sellable_flag := p_instance_rec.sellable_flag;
2666: END IF;
2667: --
2664: THEN l_get_instance_rec.sellable_flag := l_curr_instance_rec.sellable_flag;
2665: ELSE l_get_instance_rec.sellable_flag := p_instance_rec.sellable_flag;
2666: END IF;
2667: --
2668: IF ( p_instance_rec.system_id = fnd_api.g_miss_num )
2669: THEN l_get_instance_rec.system_id := l_curr_instance_rec.system_id;
2670: ELSE l_get_instance_rec.system_id := p_instance_rec.system_id;
2671: END IF;
2672: --
2669: THEN l_get_instance_rec.system_id := l_curr_instance_rec.system_id;
2670: ELSE l_get_instance_rec.system_id := p_instance_rec.system_id;
2671: END IF;
2672: --
2673: IF ( p_instance_rec.instance_type_code = fnd_api.g_miss_char )
2674: THEN l_get_instance_rec.instance_type_code := l_curr_instance_rec.instance_type_code;
2675: ELSE l_get_instance_rec.instance_type_code := p_instance_rec.instance_type_code;
2676: END IF;
2677: --
2674: THEN l_get_instance_rec.instance_type_code := l_curr_instance_rec.instance_type_code;
2675: ELSE l_get_instance_rec.instance_type_code := p_instance_rec.instance_type_code;
2676: END IF;
2677: --
2678: IF ( p_instance_rec.active_start_date = fnd_api.g_miss_date )
2679: THEN l_get_instance_rec.active_start_date := l_curr_instance_rec.active_start_date;
2680: ELSE l_get_instance_rec.active_start_date := p_instance_rec.active_start_date;
2681: END IF;
2682: --
2679: THEN l_get_instance_rec.active_start_date := l_curr_instance_rec.active_start_date;
2680: ELSE l_get_instance_rec.active_start_date := p_instance_rec.active_start_date;
2681: END IF;
2682: --
2683: IF ( p_instance_rec.active_end_date = fnd_api.g_miss_date )
2684: THEN l_get_instance_rec.active_end_date := l_curr_instance_rec.active_end_date;
2685: ELSE l_get_instance_rec.active_end_date := p_instance_rec.active_end_date;
2686: END IF;
2687: --
2684: THEN l_get_instance_rec.active_end_date := l_curr_instance_rec.active_end_date;
2685: ELSE l_get_instance_rec.active_end_date := p_instance_rec.active_end_date;
2686: END IF;
2687: --
2688: IF ( p_instance_rec.location_type_code = fnd_api.g_miss_char )
2689: THEN l_get_instance_rec.location_type_code := l_curr_instance_rec.location_type_code;
2690: ELSE l_get_instance_rec.location_type_code := p_instance_rec.location_type_code;
2691: END IF;
2692: --
2689: THEN l_get_instance_rec.location_type_code := l_curr_instance_rec.location_type_code;
2690: ELSE l_get_instance_rec.location_type_code := p_instance_rec.location_type_code;
2691: END IF;
2692: --
2693: IF ( p_instance_rec.location_id = fnd_api.g_miss_num )
2694: THEN l_get_instance_rec.location_id := l_curr_instance_rec.location_id;
2695: ELSE l_get_instance_rec.location_id := p_instance_rec.location_id;
2696: END IF;
2697: --
2694: THEN l_get_instance_rec.location_id := l_curr_instance_rec.location_id;
2695: ELSE l_get_instance_rec.location_id := p_instance_rec.location_id;
2696: END IF;
2697: --
2698: IF ( p_instance_rec.inv_organization_id = fnd_api.g_miss_num )
2699: THEN l_get_instance_rec.inv_organization_id := l_curr_instance_rec.inv_organization_id;
2700: ELSE l_get_instance_rec.inv_organization_id := p_instance_rec.inv_organization_id;
2701: END IF;
2702: --
2699: THEN l_get_instance_rec.inv_organization_id := l_curr_instance_rec.inv_organization_id;
2700: ELSE l_get_instance_rec.inv_organization_id := p_instance_rec.inv_organization_id;
2701: END IF;
2702: --
2703: IF ( p_instance_rec.inv_subinventory_name = fnd_api.g_miss_char )
2704: THEN l_get_instance_rec.inv_subinventory_name := l_curr_instance_rec.inv_subinventory_name;
2705: ELSE l_get_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;
2706: END IF;
2707: --
2704: THEN l_get_instance_rec.inv_subinventory_name := l_curr_instance_rec.inv_subinventory_name;
2705: ELSE l_get_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;
2706: END IF;
2707: --
2708: IF ( p_instance_rec.inv_locator_id = fnd_api.g_miss_num )
2709: THEN l_get_instance_rec.inv_locator_id := l_curr_instance_rec.inv_locator_id;
2710: ELSE l_get_instance_rec.inv_locator_id := p_instance_rec.inv_locator_id;
2711: END IF;
2712: --
2709: THEN l_get_instance_rec.inv_locator_id := l_curr_instance_rec.inv_locator_id;
2710: ELSE l_get_instance_rec.inv_locator_id := p_instance_rec.inv_locator_id;
2711: END IF;
2712: --
2713: IF ( p_instance_rec.pa_project_id = fnd_api.g_miss_num )
2714: THEN l_get_instance_rec.pa_project_id := l_curr_instance_rec.pa_project_id;
2715: ELSE l_get_instance_rec.pa_project_id := p_instance_rec.pa_project_id;
2716: END IF;
2717: --
2714: THEN l_get_instance_rec.pa_project_id := l_curr_instance_rec.pa_project_id;
2715: ELSE l_get_instance_rec.pa_project_id := p_instance_rec.pa_project_id;
2716: END IF;
2717: --
2718: IF ( p_instance_rec.pa_project_task_id = fnd_api.g_miss_num )
2719: THEN l_get_instance_rec.pa_project_task_id := l_curr_instance_rec.pa_project_task_id;
2720: ELSE l_get_instance_rec.pa_project_task_id := p_instance_rec.pa_project_task_id;
2721: END IF;
2722: --
2719: THEN l_get_instance_rec.pa_project_task_id := l_curr_instance_rec.pa_project_task_id;
2720: ELSE l_get_instance_rec.pa_project_task_id := p_instance_rec.pa_project_task_id;
2721: END IF;
2722: --
2723: IF ( p_instance_rec.in_transit_order_line_id = fnd_api.g_miss_num )
2724: THEN l_get_instance_rec.in_transit_order_line_id := l_curr_instance_rec.in_transit_order_line_id;
2725: ELSE l_get_instance_rec.in_transit_order_line_id := p_instance_rec.in_transit_order_line_id;
2726: END IF;
2727: --
2724: THEN l_get_instance_rec.in_transit_order_line_id := l_curr_instance_rec.in_transit_order_line_id;
2725: ELSE l_get_instance_rec.in_transit_order_line_id := p_instance_rec.in_transit_order_line_id;
2726: END IF;
2727: --
2728: IF ( p_instance_rec.wip_job_id = fnd_api.g_miss_num )
2729: THEN l_get_instance_rec.wip_job_id := l_curr_instance_rec.wip_job_id;
2730: ELSE l_get_instance_rec.wip_job_id := p_instance_rec.wip_job_id;
2731: END IF;
2732: --
2729: THEN l_get_instance_rec.wip_job_id := l_curr_instance_rec.wip_job_id;
2730: ELSE l_get_instance_rec.wip_job_id := p_instance_rec.wip_job_id;
2731: END IF;
2732: --
2733: IF ( p_instance_rec.po_order_line_id = fnd_api.g_miss_num )
2734: THEN l_get_instance_rec.po_order_line_id := l_curr_instance_rec.po_order_line_id;
2735: ELSE l_get_instance_rec.po_order_line_id := p_instance_rec.po_order_line_id;
2736: END IF;
2737: --
2734: THEN l_get_instance_rec.po_order_line_id := l_curr_instance_rec.po_order_line_id;
2735: ELSE l_get_instance_rec.po_order_line_id := p_instance_rec.po_order_line_id;
2736: END IF;
2737: --
2738: IF ( p_instance_rec.last_oe_order_line_id = fnd_api.g_miss_num )
2739: THEN l_get_instance_rec.last_oe_order_line_id := l_curr_instance_rec.last_oe_order_line_id;
2740: ELSE l_get_instance_rec.last_oe_order_line_id := p_instance_rec.last_oe_order_line_id;
2741: END IF;
2742: --
2739: THEN l_get_instance_rec.last_oe_order_line_id := l_curr_instance_rec.last_oe_order_line_id;
2740: ELSE l_get_instance_rec.last_oe_order_line_id := p_instance_rec.last_oe_order_line_id;
2741: END IF;
2742: --
2743: IF ( p_instance_rec.last_oe_rma_line_id = fnd_api.g_miss_num )
2744: THEN l_get_instance_rec.last_oe_rma_line_id := l_curr_instance_rec.last_oe_rma_line_id;
2745: ELSE l_get_instance_rec.last_oe_rma_line_id := p_instance_rec.last_oe_rma_line_id;
2746: END IF;
2747: --
2744: THEN l_get_instance_rec.last_oe_rma_line_id := l_curr_instance_rec.last_oe_rma_line_id;
2745: ELSE l_get_instance_rec.last_oe_rma_line_id := p_instance_rec.last_oe_rma_line_id;
2746: END IF;
2747: --
2748: IF ( p_instance_rec.last_po_po_line_id = fnd_api.g_miss_num )
2749: THEN l_get_instance_rec.last_po_po_line_id := l_curr_instance_rec.last_po_po_line_id;
2750: ELSE l_get_instance_rec.last_po_po_line_id := p_instance_rec.last_po_po_line_id;
2751: END IF;
2752: --
2749: THEN l_get_instance_rec.last_po_po_line_id := l_curr_instance_rec.last_po_po_line_id;
2750: ELSE l_get_instance_rec.last_po_po_line_id := p_instance_rec.last_po_po_line_id;
2751: END IF;
2752: --
2753: IF ( p_instance_rec.last_oe_po_number = fnd_api.g_miss_char )
2754: THEN l_get_instance_rec.last_oe_po_number := l_curr_instance_rec.last_oe_po_number;
2755: ELSE l_get_instance_rec.last_oe_po_number := p_instance_rec.last_oe_po_number;
2756: END IF;
2757: --
2754: THEN l_get_instance_rec.last_oe_po_number := l_curr_instance_rec.last_oe_po_number;
2755: ELSE l_get_instance_rec.last_oe_po_number := p_instance_rec.last_oe_po_number;
2756: END IF;
2757: --
2758: IF ( p_instance_rec.last_wip_job_id = fnd_api.g_miss_num )
2759: THEN l_get_instance_rec.last_wip_job_id := l_curr_instance_rec.last_wip_job_id;
2760: ELSE l_get_instance_rec.last_wip_job_id := p_instance_rec.last_wip_job_id;
2761: END IF;
2762: --
2759: THEN l_get_instance_rec.last_wip_job_id := l_curr_instance_rec.last_wip_job_id;
2760: ELSE l_get_instance_rec.last_wip_job_id := p_instance_rec.last_wip_job_id;
2761: END IF;
2762: --
2763: IF ( p_instance_rec.last_pa_project_id = fnd_api.g_miss_num )
2764: THEN l_get_instance_rec.last_pa_project_id := l_curr_instance_rec.last_pa_project_id;
2765: ELSE l_get_instance_rec.last_pa_project_id := p_instance_rec.last_pa_project_id;
2766: END IF;
2767: --
2764: THEN l_get_instance_rec.last_pa_project_id := l_curr_instance_rec.last_pa_project_id;
2765: ELSE l_get_instance_rec.last_pa_project_id := p_instance_rec.last_pa_project_id;
2766: END IF;
2767: --
2768: IF ( p_instance_rec.last_pa_task_id = fnd_api.g_miss_num )
2769: THEN l_get_instance_rec.last_pa_task_id := l_curr_instance_rec.last_pa_task_id;
2770: ELSE l_get_instance_rec.last_pa_task_id := p_instance_rec.last_pa_task_id;
2771: END IF;
2772: --
2769: THEN l_get_instance_rec.last_pa_task_id := l_curr_instance_rec.last_pa_task_id;
2770: ELSE l_get_instance_rec.last_pa_task_id := p_instance_rec.last_pa_task_id;
2771: END IF;
2772: --
2773: IF ( p_instance_rec.last_oe_agreement_id = fnd_api.g_miss_num )
2774: THEN l_get_instance_rec.last_oe_agreement_id := l_curr_instance_rec.last_oe_agreement_id;
2775: ELSE l_get_instance_rec.last_oe_agreement_id := p_instance_rec.last_oe_agreement_id;
2776: END IF;
2777: --
2774: THEN l_get_instance_rec.last_oe_agreement_id := l_curr_instance_rec.last_oe_agreement_id;
2775: ELSE l_get_instance_rec.last_oe_agreement_id := p_instance_rec.last_oe_agreement_id;
2776: END IF;
2777: --
2778: IF ( p_instance_rec.install_date = fnd_api.g_miss_date )
2779: THEN l_get_instance_rec.install_date := l_curr_instance_rec.install_date;
2780: ELSE l_get_instance_rec.install_date := p_instance_rec.install_date;
2781: END IF;
2782: --
2779: THEN l_get_instance_rec.install_date := l_curr_instance_rec.install_date;
2780: ELSE l_get_instance_rec.install_date := p_instance_rec.install_date;
2781: END IF;
2782: --
2783: IF ( p_instance_rec.manually_created_flag = fnd_api.g_miss_char )
2784: THEN l_get_instance_rec.manually_created_flag := l_curr_instance_rec.manually_created_flag;
2785: ELSE l_get_instance_rec.manually_created_flag := p_instance_rec.manually_created_flag;
2786: END IF;
2787: --
2784: THEN l_get_instance_rec.manually_created_flag := l_curr_instance_rec.manually_created_flag;
2785: ELSE l_get_instance_rec.manually_created_flag := p_instance_rec.manually_created_flag;
2786: END IF;
2787: --
2788: IF ( p_instance_rec.return_by_date = fnd_api.g_miss_date )
2789: THEN l_get_instance_rec.return_by_date := l_curr_instance_rec.return_by_date;
2790: ELSE l_get_instance_rec.return_by_date := p_instance_rec.return_by_date;
2791: END IF;
2792: --
2789: THEN l_get_instance_rec.return_by_date := l_curr_instance_rec.return_by_date;
2790: ELSE l_get_instance_rec.return_by_date := p_instance_rec.return_by_date;
2791: END IF;
2792: --
2793: IF ( p_instance_rec.actual_return_date = fnd_api.g_miss_date )
2794: THEN l_get_instance_rec.actual_return_date := l_curr_instance_rec.actual_return_date;
2795: ELSE l_get_instance_rec.actual_return_date := p_instance_rec.actual_return_date;
2796: END IF;
2797: --
2794: THEN l_get_instance_rec.actual_return_date := l_curr_instance_rec.actual_return_date;
2795: ELSE l_get_instance_rec.actual_return_date := p_instance_rec.actual_return_date;
2796: END IF;
2797: --
2798: IF ( p_instance_rec.creation_complete_flag = fnd_api.g_miss_char )
2799: THEN l_get_instance_rec.creation_complete_flag := l_curr_instance_rec.creation_complete_flag;
2800: ELSE l_get_instance_rec.creation_complete_flag := p_instance_rec.creation_complete_flag;
2801: END IF;
2802: --
2799: THEN l_get_instance_rec.creation_complete_flag := l_curr_instance_rec.creation_complete_flag;
2800: ELSE l_get_instance_rec.creation_complete_flag := p_instance_rec.creation_complete_flag;
2801: END IF;
2802: --
2803: IF ( p_instance_rec.completeness_flag = fnd_api.g_miss_char )
2804: THEN l_get_instance_rec.completeness_flag := l_curr_instance_rec.completeness_flag;
2805: ELSE l_get_instance_rec.completeness_flag := p_instance_rec.completeness_flag;
2806: END IF;
2807: --
2804: THEN l_get_instance_rec.completeness_flag := l_curr_instance_rec.completeness_flag;
2805: ELSE l_get_instance_rec.completeness_flag := p_instance_rec.completeness_flag;
2806: END IF;
2807: --
2808: IF ( p_instance_rec.context = fnd_api.g_miss_char )
2809: THEN l_get_instance_rec.context := l_curr_instance_rec.context;
2810: ELSE l_get_instance_rec.context := p_instance_rec.context;
2811: END IF;
2812: --
2809: THEN l_get_instance_rec.context := l_curr_instance_rec.context;
2810: ELSE l_get_instance_rec.context := p_instance_rec.context;
2811: END IF;
2812: --
2813: IF ( p_instance_rec.attribute1 = fnd_api.g_miss_char )
2814: THEN l_get_instance_rec.attribute1 := l_curr_instance_rec.attribute1;
2815: ELSE l_get_instance_rec.attribute1 := p_instance_rec.attribute1;
2816: END IF;
2817: --
2814: THEN l_get_instance_rec.attribute1 := l_curr_instance_rec.attribute1;
2815: ELSE l_get_instance_rec.attribute1 := p_instance_rec.attribute1;
2816: END IF;
2817: --
2818: IF ( p_instance_rec.attribute2 = fnd_api.g_miss_char )
2819: THEN l_get_instance_rec.attribute2 := l_curr_instance_rec.attribute2;
2820: ELSE l_get_instance_rec.attribute2 := p_instance_rec.attribute2;
2821: END IF;
2822: --
2819: THEN l_get_instance_rec.attribute2 := l_curr_instance_rec.attribute2;
2820: ELSE l_get_instance_rec.attribute2 := p_instance_rec.attribute2;
2821: END IF;
2822: --
2823: IF ( p_instance_rec.attribute3 = fnd_api.g_miss_char )
2824: THEN l_get_instance_rec.attribute3 := l_curr_instance_rec.attribute3;
2825: ELSE l_get_instance_rec.attribute3 := p_instance_rec.attribute3;
2826: END IF;
2827: --
2824: THEN l_get_instance_rec.attribute3 := l_curr_instance_rec.attribute3;
2825: ELSE l_get_instance_rec.attribute3 := p_instance_rec.attribute3;
2826: END IF;
2827: --
2828: IF ( p_instance_rec.attribute4 = fnd_api.g_miss_char )
2829: THEN l_get_instance_rec.attribute4 := l_curr_instance_rec.attribute4;
2830: ELSE l_get_instance_rec.attribute4 := p_instance_rec.attribute4;
2831: END IF;
2832: --
2829: THEN l_get_instance_rec.attribute4 := l_curr_instance_rec.attribute4;
2830: ELSE l_get_instance_rec.attribute4 := p_instance_rec.attribute4;
2831: END IF;
2832: --
2833: IF ( p_instance_rec.attribute5 = fnd_api.g_miss_char )
2834: THEN l_get_instance_rec.attribute5 := l_curr_instance_rec.attribute5;
2835: ELSE l_get_instance_rec.attribute5 := p_instance_rec.attribute5;
2836: END IF;
2837: --
2834: THEN l_get_instance_rec.attribute5 := l_curr_instance_rec.attribute5;
2835: ELSE l_get_instance_rec.attribute5 := p_instance_rec.attribute5;
2836: END IF;
2837: --
2838: IF ( p_instance_rec.attribute6 = fnd_api.g_miss_char )
2839: THEN l_get_instance_rec.attribute6 := l_curr_instance_rec.attribute6;
2840: ELSE l_get_instance_rec.attribute6 := p_instance_rec.attribute6;
2841: END IF;
2842: --
2839: THEN l_get_instance_rec.attribute6 := l_curr_instance_rec.attribute6;
2840: ELSE l_get_instance_rec.attribute6 := p_instance_rec.attribute6;
2841: END IF;
2842: --
2843: IF ( p_instance_rec.attribute7 = fnd_api.g_miss_char )
2844: THEN l_get_instance_rec.attribute7 := l_curr_instance_rec.attribute7;
2845: ELSE l_get_instance_rec.attribute7 := p_instance_rec.attribute7;
2846: END IF;
2847: --
2844: THEN l_get_instance_rec.attribute7 := l_curr_instance_rec.attribute7;
2845: ELSE l_get_instance_rec.attribute7 := p_instance_rec.attribute7;
2846: END IF;
2847: --
2848: IF ( p_instance_rec.attribute8 = fnd_api.g_miss_char )
2849: THEN l_get_instance_rec.attribute8 := l_curr_instance_rec.attribute8;
2850: ELSE l_get_instance_rec.attribute8 := p_instance_rec.attribute8;
2851: END IF;
2852: --
2849: THEN l_get_instance_rec.attribute8 := l_curr_instance_rec.attribute8;
2850: ELSE l_get_instance_rec.attribute8 := p_instance_rec.attribute8;
2851: END IF;
2852: --
2853: IF ( p_instance_rec.attribute9 = fnd_api.g_miss_char )
2854: THEN l_get_instance_rec.attribute9 := l_curr_instance_rec.attribute9;
2855: ELSE l_get_instance_rec.attribute9 := p_instance_rec.attribute9;
2856: END IF;
2857: --
2854: THEN l_get_instance_rec.attribute9 := l_curr_instance_rec.attribute9;
2855: ELSE l_get_instance_rec.attribute9 := p_instance_rec.attribute9;
2856: END IF;
2857: --
2858: IF ( p_instance_rec.attribute10 = fnd_api.g_miss_char )
2859: THEN l_get_instance_rec.attribute10 := l_curr_instance_rec.attribute10;
2860: ELSE l_get_instance_rec.attribute10 := p_instance_rec.attribute10;
2861: END IF;
2862: --
2859: THEN l_get_instance_rec.attribute10 := l_curr_instance_rec.attribute10;
2860: ELSE l_get_instance_rec.attribute10 := p_instance_rec.attribute10;
2861: END IF;
2862: --
2863: IF ( p_instance_rec.attribute11 = fnd_api.g_miss_char )
2864: THEN l_get_instance_rec.attribute11 := l_curr_instance_rec.attribute11;
2865: ELSE l_get_instance_rec.attribute11 := p_instance_rec.attribute11;
2866: END IF;
2867: --
2864: THEN l_get_instance_rec.attribute11 := l_curr_instance_rec.attribute11;
2865: ELSE l_get_instance_rec.attribute11 := p_instance_rec.attribute11;
2866: END IF;
2867: --
2868: IF ( p_instance_rec.attribute12 = fnd_api.g_miss_char )
2869: THEN l_get_instance_rec.attribute12 := l_curr_instance_rec.attribute12;
2870: ELSE l_get_instance_rec.attribute12 := p_instance_rec.attribute12;
2871: END IF;
2872: --
2869: THEN l_get_instance_rec.attribute12 := l_curr_instance_rec.attribute12;
2870: ELSE l_get_instance_rec.attribute12 := p_instance_rec.attribute12;
2871: END IF;
2872: --
2873: IF ( p_instance_rec.attribute13 = fnd_api.g_miss_char )
2874: THEN l_get_instance_rec.attribute13 := l_curr_instance_rec.attribute13;
2875: ELSE l_get_instance_rec.attribute13 := p_instance_rec.attribute13;
2876: END IF;
2877: --
2874: THEN l_get_instance_rec.attribute13 := l_curr_instance_rec.attribute13;
2875: ELSE l_get_instance_rec.attribute13 := p_instance_rec.attribute13;
2876: END IF;
2877: --
2878: IF ( p_instance_rec.attribute14 = fnd_api.g_miss_char )
2879: THEN l_get_instance_rec.attribute14 := l_curr_instance_rec.attribute14;
2880: ELSE l_get_instance_rec.attribute14 := p_instance_rec.attribute14;
2881: END IF;
2882: --
2879: THEN l_get_instance_rec.attribute14 := l_curr_instance_rec.attribute14;
2880: ELSE l_get_instance_rec.attribute14 := p_instance_rec.attribute14;
2881: END IF;
2882: --
2883: IF ( p_instance_rec.attribute15 = fnd_api.g_miss_char )
2884: THEN l_get_instance_rec.attribute15 := l_curr_instance_rec.attribute15;
2885: ELSE l_get_instance_rec.attribute15 := p_instance_rec.attribute15;
2886: END IF;
2887: --
2884: THEN l_get_instance_rec.attribute15 := l_curr_instance_rec.attribute15;
2885: ELSE l_get_instance_rec.attribute15 := p_instance_rec.attribute15;
2886: END IF;
2887: --
2888: IF ( p_instance_rec.object_version_number = fnd_api.g_miss_num )
2889: THEN l_get_instance_rec.object_version_number := l_curr_instance_rec.object_version_number;
2890: ELSE l_get_instance_rec.object_version_number := p_instance_rec.object_version_number;
2891: END IF;
2892: --
2889: THEN l_get_instance_rec.object_version_number := l_curr_instance_rec.object_version_number;
2890: ELSE l_get_instance_rec.object_version_number := p_instance_rec.object_version_number;
2891: END IF;
2892: --
2893: IF ( p_instance_rec.last_txn_line_detail_id = fnd_api.g_miss_num )
2894: THEN l_get_instance_rec.last_txn_line_detail_id := l_curr_instance_rec.last_txn_line_detail_id;
2895: ELSE l_get_instance_rec.last_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
2896: END IF;
2897: --
2894: THEN l_get_instance_rec.last_txn_line_detail_id := l_curr_instance_rec.last_txn_line_detail_id;
2895: ELSE l_get_instance_rec.last_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
2896: END IF;
2897: --
2898: IF ( p_instance_rec.install_location_type_code = fnd_api.g_miss_char )
2899: THEN l_get_instance_rec.install_location_type_code := l_curr_instance_rec.install_location_type_code;
2900: ELSE l_get_instance_rec.install_location_type_code := p_instance_rec.install_location_type_code;
2901: END IF;
2902: --
2899: THEN l_get_instance_rec.install_location_type_code := l_curr_instance_rec.install_location_type_code;
2900: ELSE l_get_instance_rec.install_location_type_code := p_instance_rec.install_location_type_code;
2901: END IF;
2902: --
2903: IF ( p_instance_rec.install_location_id = fnd_api.g_miss_num )
2904: THEN l_get_instance_rec.install_location_id := l_curr_instance_rec.install_location_id;
2905: ELSE l_get_instance_rec.install_location_id := p_instance_rec.install_location_id;
2906: END IF;
2907: --
2904: THEN l_get_instance_rec.install_location_id := l_curr_instance_rec.install_location_id;
2905: ELSE l_get_instance_rec.install_location_id := p_instance_rec.install_location_id;
2906: END IF;
2907: --
2908: IF ( p_instance_rec.instance_usage_code = fnd_api.g_miss_char )
2909: THEN l_get_instance_rec.instance_usage_code := l_curr_instance_rec.instance_usage_code;
2910: ELSE l_get_instance_rec.instance_usage_code := p_instance_rec.instance_usage_code;
2911: END IF;
2912: --
2910: ELSE l_get_instance_rec.instance_usage_code := p_instance_rec.instance_usage_code;
2911: END IF;
2912: --
2913:
2914: /* IF ( p_instance_rec.vld_organization_id = fnd_api.g_miss_num )
2915: THEN l_get_instance_rec.vld_organization_id := l_curr_instance_rec.last_vld_organization_id;
2916: ELSE l_get_instance_rec.vld_organization_id := p_instance_rec.vld_organization_id;
2917: END IF;
2918: --
2917: END IF;
2918: --
2919: */
2920:
2921: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2922: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2923: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2924: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2918: --
2919: */
2920:
2921: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2922: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2923: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2924: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2919: */
2920:
2921: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2922: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2923: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2924: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2927: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2920:
2921: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2922: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2923: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2924: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2927: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2928: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2921: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2922: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2923: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2924: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2927: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2928: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2929: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2922: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2923: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2924: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2927: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2928: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2929: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2930: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2923: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2924: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2927: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2928: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2929: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2930: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2931: ) THEN
2924: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2927: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2928: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2929: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2930: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2931: ) THEN
2932:
2925: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2927: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2928: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2929: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2930: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2931: ) THEN
2932:
2933: IF l_get_instance_rec.location_type_code = 'INVENTORY' THEN
2926: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2927: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2928: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2929: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2930: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2931: ) THEN
2932:
2933: IF l_get_instance_rec.location_type_code = 'INVENTORY' THEN
2934:
2931: ) THEN
2932:
2933: IF l_get_instance_rec.location_type_code = 'INVENTORY' THEN
2934:
2935: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
2936: p_instance_rec.pa_project_id := NULL;
2937: l_get_instance_rec.pa_project_id := NULL;
2938: END IF;
2939: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
2935: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
2936: p_instance_rec.pa_project_id := NULL;
2937: l_get_instance_rec.pa_project_id := NULL;
2938: END IF;
2939: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
2940: p_instance_rec.pa_project_task_id := NULL;
2941: l_get_instance_rec.pa_project_task_id := NULL;
2942: END IF;
2943: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
2939: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
2940: p_instance_rec.pa_project_task_id := NULL;
2941: l_get_instance_rec.pa_project_task_id := NULL;
2942: END IF;
2943: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
2944: p_instance_rec.wip_job_id := NULL;
2945: l_get_instance_rec.wip_job_id := NULL;
2946: END IF;
2947: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
2943: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
2944: p_instance_rec.wip_job_id := NULL;
2945: l_get_instance_rec.wip_job_id := NULL;
2946: END IF;
2947: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
2948: p_instance_rec.in_transit_order_line_id := NULL;
2949: l_get_instance_rec.in_transit_order_line_id := NULL;
2950: END IF;
2951: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
2947: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
2948: p_instance_rec.in_transit_order_line_id := NULL;
2949: l_get_instance_rec.in_transit_order_line_id := NULL;
2950: END IF;
2951: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
2952: p_instance_rec.po_order_line_id := NULL;
2953: l_get_instance_rec.po_order_line_id := NULL;
2954: END IF;
2955:
2956: ELSIF
2957:
2958: l_get_instance_rec.location_type_code = 'PROJECT' THEN
2959:
2960: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
2961: p_instance_rec.inv_organization_id := NULL;
2962: l_get_instance_rec.inv_organization_id := NULL;
2963: END IF;
2964: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
2960: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
2961: p_instance_rec.inv_organization_id := NULL;
2962: l_get_instance_rec.inv_organization_id := NULL;
2963: END IF;
2964: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
2965: p_instance_rec.inv_subinventory_name := NULL;
2966: l_get_instance_rec.inv_subinventory_name := NULL;
2967: END IF;
2968: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
2964: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
2965: p_instance_rec.inv_subinventory_name := NULL;
2966: l_get_instance_rec.inv_subinventory_name := NULL;
2967: END IF;
2968: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
2969: p_instance_rec.inv_locator_id := NULL;
2970: l_get_instance_rec.inv_locator_id := NULL;
2971: END IF;
2972: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
2968: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
2969: p_instance_rec.inv_locator_id := NULL;
2970: l_get_instance_rec.inv_locator_id := NULL;
2971: END IF;
2972: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
2973: p_instance_rec.wip_job_id := NULL;
2974: l_get_instance_rec.wip_job_id := NULL;
2975: END IF;
2976: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
2972: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
2973: p_instance_rec.wip_job_id := NULL;
2974: l_get_instance_rec.wip_job_id := NULL;
2975: END IF;
2976: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
2977: p_instance_rec.in_transit_order_line_id := NULL;
2978: l_get_instance_rec.in_transit_order_line_id := NULL;
2979: END IF;
2980: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
2976: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
2977: p_instance_rec.in_transit_order_line_id := NULL;
2978: l_get_instance_rec.in_transit_order_line_id := NULL;
2979: END IF;
2980: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
2981: p_instance_rec.po_order_line_id := NULL;
2982: l_get_instance_rec.po_order_line_id := NULL;
2983: END IF;
2984:
2985: ELSIF
2986:
2987: l_get_instance_rec.location_type_code = 'WIP' THEN
2988:
2989: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
2990: p_instance_rec.inv_organization_id := NULL;
2991: l_get_instance_rec.inv_organization_id := NULL;
2992: END IF;
2993: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
2989: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
2990: p_instance_rec.inv_organization_id := NULL;
2991: l_get_instance_rec.inv_organization_id := NULL;
2992: END IF;
2993: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
2994: p_instance_rec.inv_subinventory_name := NULL;
2995: l_get_instance_rec.inv_subinventory_name := NULL;
2996: END IF;
2997: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
2993: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
2994: p_instance_rec.inv_subinventory_name := NULL;
2995: l_get_instance_rec.inv_subinventory_name := NULL;
2996: END IF;
2997: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
2998: p_instance_rec.inv_locator_id := NULL;
2999: l_get_instance_rec.inv_locator_id := NULL;
3000: END IF;
3001: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
2997: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
2998: p_instance_rec.inv_locator_id := NULL;
2999: l_get_instance_rec.inv_locator_id := NULL;
3000: END IF;
3001: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3002: p_instance_rec.pa_project_id := NULL;
3003: l_get_instance_rec.pa_project_id := NULL;
3004: END IF;
3005: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3001: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3002: p_instance_rec.pa_project_id := NULL;
3003: l_get_instance_rec.pa_project_id := NULL;
3004: END IF;
3005: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3006: p_instance_rec.pa_project_task_id := NULL;
3007: l_get_instance_rec.pa_project_task_id := NULL;
3008: END IF;
3009: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3005: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3006: p_instance_rec.pa_project_task_id := NULL;
3007: l_get_instance_rec.pa_project_task_id := NULL;
3008: END IF;
3009: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3010: p_instance_rec.in_transit_order_line_id := NULL;
3011: l_get_instance_rec.in_transit_order_line_id := NULL;
3012: END IF;
3013: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3009: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3010: p_instance_rec.in_transit_order_line_id := NULL;
3011: l_get_instance_rec.in_transit_order_line_id := NULL;
3012: END IF;
3013: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3014: p_instance_rec.po_order_line_id := NULL;
3015: l_get_instance_rec.po_order_line_id := NULL;
3016: END IF;
3017:
3018: ELSIF
3019:
3020: l_get_instance_rec.location_type_code = 'IN_TRANSIT' THEN
3021:
3022: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3023: p_instance_rec.inv_organization_id := NULL;
3024: l_get_instance_rec.inv_organization_id := NULL;
3025: END IF;
3026: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3022: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3023: p_instance_rec.inv_organization_id := NULL;
3024: l_get_instance_rec.inv_organization_id := NULL;
3025: END IF;
3026: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3027: p_instance_rec.inv_subinventory_name := NULL;
3028: l_get_instance_rec.inv_subinventory_name := NULL;
3029: END IF;
3030: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3026: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3027: p_instance_rec.inv_subinventory_name := NULL;
3028: l_get_instance_rec.inv_subinventory_name := NULL;
3029: END IF;
3030: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3031: p_instance_rec.inv_locator_id := NULL;
3032: l_get_instance_rec.inv_locator_id := NULL;
3033: END IF;
3034: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3030: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3031: p_instance_rec.inv_locator_id := NULL;
3032: l_get_instance_rec.inv_locator_id := NULL;
3033: END IF;
3034: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3035: p_instance_rec.pa_project_id := NULL;
3036: l_get_instance_rec.pa_project_id := NULL;
3037: END IF;
3038: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3034: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3035: p_instance_rec.pa_project_id := NULL;
3036: l_get_instance_rec.pa_project_id := NULL;
3037: END IF;
3038: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3039: p_instance_rec.pa_project_task_id := NULL;
3040: l_get_instance_rec.pa_project_task_id := NULL;
3041: END IF;
3042: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3038: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3039: p_instance_rec.pa_project_task_id := NULL;
3040: l_get_instance_rec.pa_project_task_id := NULL;
3041: END IF;
3042: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3043: p_instance_rec.wip_job_id := NULL;
3044: l_get_instance_rec.wip_job_id := NULL;
3045: END IF;
3046: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3042: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3043: p_instance_rec.wip_job_id := NULL;
3044: l_get_instance_rec.wip_job_id := NULL;
3045: END IF;
3046: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3047: p_instance_rec.po_order_line_id := NULL;
3048: l_get_instance_rec.po_order_line_id := NULL;
3049: END IF;
3050:
3051: ELSIF
3052:
3053: l_get_instance_rec.location_type_code = 'PO' THEN
3054:
3055: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3056: p_instance_rec.inv_organization_id := NULL;
3057: l_get_instance_rec.inv_organization_id := NULL;
3058: END IF;
3059: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3055: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3056: p_instance_rec.inv_organization_id := NULL;
3057: l_get_instance_rec.inv_organization_id := NULL;
3058: END IF;
3059: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3060: p_instance_rec.inv_subinventory_name := NULL;
3061: l_get_instance_rec.inv_subinventory_name := NULL;
3062: END IF;
3063: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3059: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3060: p_instance_rec.inv_subinventory_name := NULL;
3061: l_get_instance_rec.inv_subinventory_name := NULL;
3062: END IF;
3063: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3064: p_instance_rec.inv_locator_id := NULL;
3065: l_get_instance_rec.inv_locator_id := NULL;
3066: END IF;
3067: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3063: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3064: p_instance_rec.inv_locator_id := NULL;
3065: l_get_instance_rec.inv_locator_id := NULL;
3066: END IF;
3067: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3068: p_instance_rec.pa_project_id := NULL;
3069: l_get_instance_rec.pa_project_id := NULL;
3070: END IF;
3071: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3067: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3068: p_instance_rec.pa_project_id := NULL;
3069: l_get_instance_rec.pa_project_id := NULL;
3070: END IF;
3071: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3072: p_instance_rec.pa_project_task_id := NULL;
3073: l_get_instance_rec.pa_project_task_id := NULL;
3074: END IF;
3075: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3071: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3072: p_instance_rec.pa_project_task_id := NULL;
3073: l_get_instance_rec.pa_project_task_id := NULL;
3074: END IF;
3075: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3076: p_instance_rec.wip_job_id := NULL;
3077: l_get_instance_rec.wip_job_id := NULL;
3078: END IF;
3079: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3075: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3076: p_instance_rec.wip_job_id := NULL;
3077: l_get_instance_rec.wip_job_id := NULL;
3078: END IF;
3079: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3080: p_instance_rec.in_transit_order_line_id := NULL;
3081: l_get_instance_rec.in_transit_order_line_id := NULL;
3082: END IF;
3083:
3084: ELSIF
3085:
3086: l_get_instance_rec.location_type_code = 'HZ_LOCATIONS' THEN
3087:
3088: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3089: p_instance_rec.inv_organization_id := NULL;
3090: l_get_instance_rec.inv_organization_id := NULL;
3091: END IF;
3092: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3088: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3089: p_instance_rec.inv_organization_id := NULL;
3090: l_get_instance_rec.inv_organization_id := NULL;
3091: END IF;
3092: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3093: p_instance_rec.inv_subinventory_name := NULL;
3094: l_get_instance_rec.inv_subinventory_name := NULL;
3095: END IF;
3096: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3092: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3093: p_instance_rec.inv_subinventory_name := NULL;
3094: l_get_instance_rec.inv_subinventory_name := NULL;
3095: END IF;
3096: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3097: p_instance_rec.inv_locator_id := NULL;
3098: l_get_instance_rec.inv_locator_id := NULL;
3099: END IF;
3100: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3096: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3097: p_instance_rec.inv_locator_id := NULL;
3098: l_get_instance_rec.inv_locator_id := NULL;
3099: END IF;
3100: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3101: p_instance_rec.wip_job_id := NULL;
3102: l_get_instance_rec.wip_job_id := NULL;
3103: END IF;
3104: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3100: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3101: p_instance_rec.wip_job_id := NULL;
3102: l_get_instance_rec.wip_job_id := NULL;
3103: END IF;
3104: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3105: p_instance_rec.in_transit_order_line_id := NULL;
3106: l_get_instance_rec.in_transit_order_line_id := NULL;
3107: END IF;
3108: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3104: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3105: p_instance_rec.in_transit_order_line_id := NULL;
3106: l_get_instance_rec.in_transit_order_line_id := NULL;
3107: END IF;
3108: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3109: p_instance_rec.po_order_line_id := NULL;
3110: l_get_instance_rec.po_order_line_id := NULL;
3111: END IF;
3112: /*
3109: p_instance_rec.po_order_line_id := NULL;
3110: l_get_instance_rec.po_order_line_id := NULL;
3111: END IF;
3112: /*
3113: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3114: p_instance_rec.pa_project_id := NULL;
3115: l_get_instance_rec.pa_project_id := NULL;
3116: END IF;
3117: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3113: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3114: p_instance_rec.pa_project_id := NULL;
3115: l_get_instance_rec.pa_project_id := NULL;
3116: END IF;
3117: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3118: p_instance_rec.pa_project_task_id := NULL;
3119: l_get_instance_rec.pa_project_task_id := NULL;
3120: END IF;
3121: */
3122: ELSIF
3123:
3124: l_get_instance_rec.location_type_code = 'HZ_PARTY_SITES' THEN
3125:
3126: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3127: p_instance_rec.inv_organization_id := NULL;
3128: l_get_instance_rec.inv_organization_id := NULL;
3129: END IF;
3130: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3126: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3127: p_instance_rec.inv_organization_id := NULL;
3128: l_get_instance_rec.inv_organization_id := NULL;
3129: END IF;
3130: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3131: p_instance_rec.inv_subinventory_name := NULL;
3132: l_get_instance_rec.inv_subinventory_name := NULL;
3133: END IF;
3134: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3130: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3131: p_instance_rec.inv_subinventory_name := NULL;
3132: l_get_instance_rec.inv_subinventory_name := NULL;
3133: END IF;
3134: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3135: p_instance_rec.inv_locator_id := NULL;
3136: l_get_instance_rec.inv_locator_id := NULL;
3137: END IF;
3138: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3134: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3135: p_instance_rec.inv_locator_id := NULL;
3136: l_get_instance_rec.inv_locator_id := NULL;
3137: END IF;
3138: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3139: p_instance_rec.wip_job_id := NULL;
3140: l_get_instance_rec.wip_job_id := NULL;
3141: END IF;
3142: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3138: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3139: p_instance_rec.wip_job_id := NULL;
3140: l_get_instance_rec.wip_job_id := NULL;
3141: END IF;
3142: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3143: p_instance_rec.in_transit_order_line_id := NULL;
3144: l_get_instance_rec.in_transit_order_line_id := NULL;
3145: END IF;
3146: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3142: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3143: p_instance_rec.in_transit_order_line_id := NULL;
3144: l_get_instance_rec.in_transit_order_line_id := NULL;
3145: END IF;
3146: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3147: p_instance_rec.po_order_line_id := NULL;
3148: l_get_instance_rec.po_order_line_id := NULL;
3149: END IF;
3150: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3146: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3147: p_instance_rec.po_order_line_id := NULL;
3148: l_get_instance_rec.po_order_line_id := NULL;
3149: END IF;
3150: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3151: p_instance_rec.pa_project_id := NULL;
3152: l_get_instance_rec.pa_project_id := NULL;
3153: END IF;
3154: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3150: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3151: p_instance_rec.pa_project_id := NULL;
3152: l_get_instance_rec.pa_project_id := NULL;
3153: END IF;
3154: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3155: p_instance_rec.pa_project_task_id := NULL;
3156: l_get_instance_rec.pa_project_task_id := NULL;
3157: END IF;
3158:
3159: ELSIF
3160:
3161: l_get_instance_rec.location_type_code = 'VENDOR_SITE' THEN
3162:
3163: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3164: p_instance_rec.inv_organization_id := NULL;
3165: l_get_instance_rec.inv_organization_id := NULL;
3166: END IF;
3167: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3163: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3164: p_instance_rec.inv_organization_id := NULL;
3165: l_get_instance_rec.inv_organization_id := NULL;
3166: END IF;
3167: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3168: p_instance_rec.inv_subinventory_name := NULL;
3169: l_get_instance_rec.inv_subinventory_name := NULL;
3170: END IF;
3171: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3167: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3168: p_instance_rec.inv_subinventory_name := NULL;
3169: l_get_instance_rec.inv_subinventory_name := NULL;
3170: END IF;
3171: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3172: p_instance_rec.inv_locator_id := NULL;
3173: l_get_instance_rec.inv_locator_id := NULL;
3174: END IF;
3175: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3171: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3172: p_instance_rec.inv_locator_id := NULL;
3173: l_get_instance_rec.inv_locator_id := NULL;
3174: END IF;
3175: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3176: p_instance_rec.wip_job_id := NULL;
3177: l_get_instance_rec.wip_job_id := NULL;
3178: END IF;
3179: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3175: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3176: p_instance_rec.wip_job_id := NULL;
3177: l_get_instance_rec.wip_job_id := NULL;
3178: END IF;
3179: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3180: p_instance_rec.in_transit_order_line_id := NULL;
3181: l_get_instance_rec.in_transit_order_line_id := NULL;
3182: END IF;
3183: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3179: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3180: p_instance_rec.in_transit_order_line_id := NULL;
3181: l_get_instance_rec.in_transit_order_line_id := NULL;
3182: END IF;
3183: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3184: p_instance_rec.po_order_line_id := NULL;
3185: l_get_instance_rec.po_order_line_id := NULL;
3186: END IF;
3187: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3183: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3184: p_instance_rec.po_order_line_id := NULL;
3185: l_get_instance_rec.po_order_line_id := NULL;
3186: END IF;
3187: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3188: p_instance_rec.pa_project_id := NULL;
3189: l_get_instance_rec.pa_project_id := NULL;
3190: END IF;
3191: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3187: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3188: p_instance_rec.pa_project_id := NULL;
3189: l_get_instance_rec.pa_project_id := NULL;
3190: END IF;
3191: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3192: p_instance_rec.pa_project_task_id := NULL;
3193: l_get_instance_rec.pa_project_task_id := NULL;
3194: END IF;
3195:
3196: ELSIF
3197:
3198: l_get_instance_rec.location_type_code = 'INTERNAL_SITE' THEN
3199:
3200: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3201: p_instance_rec.inv_organization_id := NULL;
3202: l_get_instance_rec.inv_organization_id := NULL;
3203: END IF;
3204: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3200: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3201: p_instance_rec.inv_organization_id := NULL;
3202: l_get_instance_rec.inv_organization_id := NULL;
3203: END IF;
3204: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3205: p_instance_rec.inv_subinventory_name := NULL;
3206: l_get_instance_rec.inv_subinventory_name := NULL;
3207: END IF;
3208: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3204: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3205: p_instance_rec.inv_subinventory_name := NULL;
3206: l_get_instance_rec.inv_subinventory_name := NULL;
3207: END IF;
3208: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3209: p_instance_rec.inv_locator_id := NULL;
3210: l_get_instance_rec.inv_locator_id := NULL;
3211: END IF;
3212: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3208: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3209: p_instance_rec.inv_locator_id := NULL;
3210: l_get_instance_rec.inv_locator_id := NULL;
3211: END IF;
3212: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3213: p_instance_rec.wip_job_id := NULL;
3214: l_get_instance_rec.wip_job_id := NULL;
3215: END IF;
3216: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3212: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3213: p_instance_rec.wip_job_id := NULL;
3214: l_get_instance_rec.wip_job_id := NULL;
3215: END IF;
3216: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3217: p_instance_rec.in_transit_order_line_id := NULL;
3218: l_get_instance_rec.in_transit_order_line_id := NULL;
3219: END IF;
3220: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3216: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3217: p_instance_rec.in_transit_order_line_id := NULL;
3218: l_get_instance_rec.in_transit_order_line_id := NULL;
3219: END IF;
3220: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3221: p_instance_rec.po_order_line_id := NULL;
3222: l_get_instance_rec.po_order_line_id := NULL;
3223: END IF;
3224: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3220: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3221: p_instance_rec.po_order_line_id := NULL;
3222: l_get_instance_rec.po_order_line_id := NULL;
3223: END IF;
3224: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3225: p_instance_rec.pa_project_id := NULL;
3226: l_get_instance_rec.pa_project_id := NULL;
3227: END IF;
3228: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3224: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3225: p_instance_rec.pa_project_id := NULL;
3226: l_get_instance_rec.pa_project_id := NULL;
3227: END IF;
3228: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3229: p_instance_rec.pa_project_task_id := NULL;
3230: l_get_instance_rec.pa_project_task_id := NULL;
3231: END IF;
3232:
3380: BEGIN
3381: l_return_value := TRUE;
3382: --
3383: IF p_srl_control_code is not NULL AND
3384: p_srl_control_code <> FND_API.G_MISS_NUM THEN
3385: Serialized := p_srl_control_code;
3386: ELSE
3387: OPEN c1;
3388: FETCH c1 into serialized;
3401: ,p_transaction_type_id => p_txn_rec.transaction_type_id
3402: )
3403: THEN
3404: IF ((p_serial_number IS NULL) OR
3405: (p_serial_number = FND_API.G_MISS_CHAR)) THEN
3406: l_return_value := FALSE;
3407: IF (p_stack_err_msg = TRUE) THEN
3408: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SERIAL_NUM');
3409: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',p_serial_number);
3419: ,p_location_type_code => p_location_type_code
3420: ,p_transaction_type_id => p_txn_rec.transaction_type_id
3421: )
3422: THEN
3423: IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
3424: l_found := NULL;
3425: IF serialized IS NOT NULL
3426: AND serialized=6
3427: AND p_instance_usage_code='RETURNED'
3507: SELECT negative_inv_receipt_code
3508: FROM mtl_parameters
3509: WHERE organization_id = p_inv_organization_id;
3510: BEGIN
3511: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
3512: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized
3513: ( p_serial_control_code => p_serial_control_code
3514: ,p_location_type_code => p_location_type_code
3515: )) --Added by sk on 09/14/01
3627: x_acct_class_code := 'INV';
3628: END IF;
3629: ELSE
3630: IF ((p_curr_acct_class_code IS NULL) OR
3631: (p_curr_acct_class_code = FND_API.G_MISS_CHAR)) THEN
3632: x_acct_class_code := 'CUST_PROD';
3633: ELSE
3634: IF (p_curr_acct_class_code = 'WIP') OR
3635: (p_curr_acct_class_code = 'PROJECT') THEN
3703: FROM csi_item_instances
3704: WHERE instance_id = p_instance_id;
3705:
3706: BEGIN
3707: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) THEN
3708: OPEN c1;
3709: FETCH c1 INTO l_instance_end_date ,l_instance_start_date;
3710: IF trunc(p_end_date) < trunc(l_instance_start_date) THEN
3711: l_return_value := FALSE;
3954:
3955: l_dummy VARCHAR2(2);
3956:
3957: BEGIN
3958: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)
3959: OR (p_ORGANIZATION_ID IS NULL)
3960: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)
3961: OR (p_INVENTORY_ITEM_ID IS NULL))
3962: THEN
3956:
3957: BEGIN
3958: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)
3959: OR (p_ORGANIZATION_ID IS NULL)
3960: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)
3961: OR (p_INVENTORY_ITEM_ID IS NULL))
3962: THEN
3963: IF ( p_stack_err_msg = TRUE ) THEN
3964: FND_MESSAGE.SET_NAME('CSI','CSI_API_NULL_ITEM_ORG');
3999:
4000: l_dummy VARCHAR2(2);
4001:
4002: BEGIN
4003: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)
4004: OR (p_ORGANIZATION_ID IS NULL)
4005: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)
4006: OR (p_INVENTORY_ITEM_ID IS NULL))
4007: THEN
4001:
4002: BEGIN
4003: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)
4004: OR (p_ORGANIZATION_ID IS NULL)
4005: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)
4006: OR (p_INVENTORY_ITEM_ID IS NULL))
4007: THEN
4008: IF ( p_stack_err_msg = TRUE ) THEN
4009: FND_MESSAGE.SET_NAME('CSI','CSI_API_NULL_ITEM_ORG');
4121: FROM csi_item_instances
4122: WHERE instance_id = p_instance_id
4123: and ((active_end_date is null) OR (active_end_date >= sysdate));
4124: BEGIN
4125: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
4126: IF p_start_date > p_end_date THEN
4127: l_return_value := FALSE;
4128: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_VER_START_DATE');
4129: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
4243: --
4244: -- Validate the Location Type and check if exists in csi_lookups table with type
4245: -- CSI_INST_LOCATION_SOURCE_CODE. If not raise the CSI_API_INVALID_LOCATION_TYPE exception
4246: -- Added the following code for R12
4247: IF ((p_location_source_table IS NULL) OR (p_location_source_table = FND_API.G_MISS_CHAR) OR
4248: (p_location_id IS NULL) OR (p_location_id = FND_API.G_MISS_NUM) )
4249: THEN
4250: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
4251: FND_MSG_PUB.ADD;
4244: -- Validate the Location Type and check if exists in csi_lookups table with type
4245: -- CSI_INST_LOCATION_SOURCE_CODE. If not raise the CSI_API_INVALID_LOCATION_TYPE exception
4246: -- Added the following code for R12
4247: IF ((p_location_source_table IS NULL) OR (p_location_source_table = FND_API.G_MISS_CHAR) OR
4248: (p_location_id IS NULL) OR (p_location_id = FND_API.G_MISS_NUM) )
4249: THEN
4250: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
4251: FND_MSG_PUB.ADD;
4252: l_return_value := FALSE;
4420: BEGIN
4421:
4422: -- Get the values of installation parameters
4423: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4424: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4425: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4426: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4428: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4421:
4422: -- Get the values of installation parameters
4423: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4424: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4425: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4426: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4428: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4429: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4422: -- Get the values of installation parameters
4423: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4424: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4425: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4426: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4428: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4429: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4430: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4423: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4424: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4425: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4426: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4428: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4429: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4430: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4431: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4424: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4425: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4426: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4428: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4429: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4430: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4431: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4432: l_return_value:= TRUE;
4425: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4426: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4428: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4429: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4430: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4431: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4432: l_return_value:= TRUE;
4433: ELSE
4426: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4428: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4429: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4430: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4431: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4432: l_return_value:= TRUE;
4433: ELSE
4434: l_return_value:= FALSE;
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4428: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4429: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4430: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4431: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4432: l_return_value:= TRUE;
4433: ELSE
4434: l_return_value:= FALSE;
4435: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4439: END IF;
4440: --
4441: IF (p_location_source_table = 'HZ_LOCATIONS') THEN
4442:
4443: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4444: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4445: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4446: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4447: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4440: --
4441: IF (p_location_source_table = 'HZ_LOCATIONS') THEN
4442:
4443: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4444: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4445: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4446: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4447: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4448: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4441: IF (p_location_source_table = 'HZ_LOCATIONS') THEN
4442:
4443: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4444: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4445: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4446: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4447: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4448: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4449: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4442:
4443: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4444: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4445: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4446: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4447: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4448: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4449: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4450: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4443: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4444: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4445: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4446: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4447: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4448: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4449: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4450: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4451: l_return_value:= TRUE;
4444: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4445: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4446: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4447: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4448: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4449: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4450: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4451: l_return_value:= TRUE;
4452: ELSE
4445: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4446: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4447: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4448: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4449: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4450: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4451: l_return_value:= TRUE;
4452: ELSE
4453: l_return_value:= FALSE;
4446: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4447: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4448: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4449: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4450: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4451: l_return_value:= TRUE;
4452: ELSE
4453: l_return_value:= FALSE;
4454: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4455: FND_MSG_PUB.Add;
4456: RETURN l_return_value;
4457: END IF;
4458: -----------
4459: IF ( (p_project_id IS NOT NULL AND p_project_id <> FND_API.G_MISS_NUM) OR
4460: (p_task_id IS NOT NULL AND p_task_id <> FND_API.G_MISS_NUM) ) THEN
4461: -- Modified for tracking FP bug 7276773 from base bug 6330298
4462: IF (p_inst_usage_code = 'INSTALLED' OR p_inst_usage_code = 'IN_PROCESS') THEN
4463: BEGIN
4456: RETURN l_return_value;
4457: END IF;
4458: -----------
4459: IF ( (p_project_id IS NOT NULL AND p_project_id <> FND_API.G_MISS_NUM) OR
4460: (p_task_id IS NOT NULL AND p_task_id <> FND_API.G_MISS_NUM) ) THEN
4461: -- Modified for tracking FP bug 7276773 from base bug 6330298
4462: IF (p_inst_usage_code = 'INSTALLED' OR p_inst_usage_code = 'IN_PROCESS') THEN
4463: BEGIN
4464: SELECT '1'
4485: END IF; -- location type is HZ_LOCATIONS
4486: --
4487: IF (p_location_source_table = 'VENDOR_SITE') THEN
4488:
4489: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4490: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4491: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4492: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4493: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4486: --
4487: IF (p_location_source_table = 'VENDOR_SITE') THEN
4488:
4489: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4490: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4491: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4492: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4493: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4494: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4487: IF (p_location_source_table = 'VENDOR_SITE') THEN
4488:
4489: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4490: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4491: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4492: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4493: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4494: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4495: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4488:
4489: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4490: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4491: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4492: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4493: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4494: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4495: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4496: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4489: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4490: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4491: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4492: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4493: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4494: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4495: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4496: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4497: l_return_value:= TRUE;
4490: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4491: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4492: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4493: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4494: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4495: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4496: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4497: l_return_value:= TRUE;
4498: ELSE
4491: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4492: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4493: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4494: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4495: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4496: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4497: l_return_value:= TRUE;
4498: ELSE
4499: l_return_value:= FALSE;
4492: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4493: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4494: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4495: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4496: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4497: l_return_value:= TRUE;
4498: ELSE
4499: l_return_value:= FALSE;
4500: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4506: IF (p_location_source_table = 'INVENTORY') THEN
4507:
4508: IF (p_location_id IS NOT NULL) THEN
4509: IF p_inst_usage_code <> 'IN_TRANSIT' THEN
4510: IF ((p_organization_id IS NOT NULL) AND (p_organization_id <> FND_API.G_MISS_NUM)) AND
4511: ((p_subinventory IS NOT NULL) AND (p_subinventory <> FND_API.G_MISS_CHAR)) THEN
4512: -- l_return_value := TRUE;
4513: BEGIN
4514: SELECT '1'
4507:
4508: IF (p_location_id IS NOT NULL) THEN
4509: IF p_inst_usage_code <> 'IN_TRANSIT' THEN
4510: IF ((p_organization_id IS NOT NULL) AND (p_organization_id <> FND_API.G_MISS_NUM)) AND
4511: ((p_subinventory IS NOT NULL) AND (p_subinventory <> FND_API.G_MISS_CHAR)) THEN
4512: -- l_return_value := TRUE;
4513: BEGIN
4514: SELECT '1'
4515: INTO l_temp_id
4526: l_return_value := FALSE;
4527: RETURN l_return_value;
4528: END;
4529: -- Validate Locator_ID srramakr
4530: IF ((p_locator_id IS NOT NULL) AND (p_locator_id <> FND_API.G_MISS_NUM)) THEN
4531: BEGIN
4532: SELECT '1'
4533: INTO l_temp_id
4534: FROM MTL_ITEM_LOCATIONS
4554: END IF;
4555: END IF;
4556: END IF;
4557:
4558: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4559: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4560: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4561: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4562: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4555: END IF;
4556: END IF;
4557:
4558: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4559: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4560: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4561: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4562: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4563: l_return_value:= TRUE;
4556: END IF;
4557:
4558: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4559: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4560: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4561: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4562: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4563: l_return_value:= TRUE;
4564: ELSE
4557:
4558: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4559: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4560: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4561: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4562: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4563: l_return_value:= TRUE;
4564: ELSE
4565: l_return_value:= FALSE;
4558: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4559: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4560: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4561: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4562: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4563: l_return_value:= TRUE;
4564: ELSE
4565: l_return_value:= FALSE;
4566: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4570: END IF; -- INVENTORY
4571: --
4572: IF (p_location_source_table = 'INTERNAL_SITE') THEN
4573: l_return_value := TRUE;
4574: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4575: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4576: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4577: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4571: --
4572: IF (p_location_source_table = 'INTERNAL_SITE') THEN
4573: l_return_value := TRUE;
4574: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4575: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4576: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4577: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4579: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4572: IF (p_location_source_table = 'INTERNAL_SITE') THEN
4573: l_return_value := TRUE;
4574: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4575: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4576: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4577: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4579: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4580: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4573: l_return_value := TRUE;
4574: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4575: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4576: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4577: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4579: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4580: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4581: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4574: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4575: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4576: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4577: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4579: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4580: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4581: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4582: l_return_value:= TRUE;
4575: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4576: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4577: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4579: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4580: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4581: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4582: l_return_value:= TRUE;
4583: ELSE
4576: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4577: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4579: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4580: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4581: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4582: l_return_value:= TRUE;
4583: ELSE
4584: l_return_value:= FALSE;
4577: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4579: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4580: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4581: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4582: l_return_value:= TRUE;
4583: ELSE
4584: l_return_value:= FALSE;
4585: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4594: INTO l_temp_id
4595: FROM wip_entities
4596: WHERE wip_entity_id = p_wip_job_id;
4597:
4598: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4599: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4600: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4601: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4602: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4595: FROM wip_entities
4596: WHERE wip_entity_id = p_wip_job_id;
4597:
4598: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4599: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4600: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4601: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4602: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4603: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4596: WHERE wip_entity_id = p_wip_job_id;
4597:
4598: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4599: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4600: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4601: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4602: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4603: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4604: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4597:
4598: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4599: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4600: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4601: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4602: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4603: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4604: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4605: l_return_value:= TRUE;
4598: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4599: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4600: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4601: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4602: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4603: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4604: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4605: l_return_value:= TRUE;
4606: ELSE
4599: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4600: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4601: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4602: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4603: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4604: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4605: l_return_value:= TRUE;
4606: ELSE
4607: l_return_value:= FALSE;
4600: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4601: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4602: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4603: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4604: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4605: l_return_value:= TRUE;
4606: ELSE
4607: l_return_value:= FALSE;
4608: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4627: FROM pa_tasks
4628: WHERE project_id = p_project_id
4629: AND task_id = p_task_id;
4630:
4631: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4632: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4633: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4634: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4635: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4628: WHERE project_id = p_project_id
4629: AND task_id = p_task_id;
4630:
4631: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4632: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4633: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4634: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4635: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4636: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4629: AND task_id = p_task_id;
4630:
4631: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4632: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4633: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4634: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4635: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4636: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4637: l_return_value:= TRUE;
4630:
4631: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4632: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4633: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4634: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4635: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4636: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4637: l_return_value:= TRUE;
4638: ELSE
4631: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4632: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4633: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4634: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4635: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4636: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4637: l_return_value:= TRUE;
4638: ELSE
4639: l_return_value:= FALSE;
4632: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4633: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4634: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4635: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4636: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4637: l_return_value:= TRUE;
4638: ELSE
4639: l_return_value:= FALSE;
4640: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4657: INTO l_temp_id
4658: FROM oe_order_lines_all
4659: WHERE line_id = p_sales_ord_line_id;
4660:
4661: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4662: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4664: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4665: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4658: FROM oe_order_lines_all
4659: WHERE line_id = p_sales_ord_line_id;
4660:
4661: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4662: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4664: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4665: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4666: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4659: WHERE line_id = p_sales_ord_line_id;
4660:
4661: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4662: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4664: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4665: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4666: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4667: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4660:
4661: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4662: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4664: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4665: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4666: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4667: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4668: l_return_value:= TRUE;
4661: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4662: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4664: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4665: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4666: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4667: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4668: l_return_value:= TRUE;
4669: ELSE
4662: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4664: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4665: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4666: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4667: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4668: l_return_value:= TRUE;
4669: ELSE
4670: l_return_value:= FALSE;
4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4664: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4665: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4666: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4667: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4668: l_return_value:= TRUE;
4669: ELSE
4670: l_return_value:= FALSE;
4671: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4688: INTO l_temp_id
4689: FROM po_lines_all
4690: WHERE po_line_id = p_po_line_id;
4691:
4692: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4693: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4694: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4695: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4696: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4689: FROM po_lines_all
4690: WHERE po_line_id = p_po_line_id;
4691:
4692: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4693: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4694: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4695: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4696: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4697: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4690: WHERE po_line_id = p_po_line_id;
4691:
4692: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4693: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4694: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4695: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4696: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4697: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4698: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4691:
4692: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4693: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4694: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4695: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4696: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4697: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4698: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4699: l_return_value:= TRUE;
4692: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4693: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4694: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4695: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4696: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4697: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4698: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4699: l_return_value:= TRUE;
4700: ELSE
4693: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4694: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4695: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4696: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4697: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4698: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4699: l_return_value:= TRUE;
4700: ELSE
4701: l_return_value:= FALSE;
4694: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4695: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4696: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4697: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4698: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4699: l_return_value:= TRUE;
4700: ELSE
4701: l_return_value:= FALSE;
4702: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');
4742: OR object_id=p_instance_id)
4743: AND relationship_type_code ='CONNECTED-TO'
4744: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE);
4745: BEGIN
4746: x_return_status := FND_API.G_RET_STS_SUCCESS;
4747: -- Need to get the schema name using FND API. Refer Bug # 3431768
4748: --
4749: FOR l_link IN p_instance_header_tbl.FIRST..p_instance_header_tbl.LAST
4750: LOOP
4743: AND relationship_type_code ='CONNECTED-TO'
4744: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE);
4745: BEGIN
4746: x_return_status := FND_API.G_RET_STS_SUCCESS;
4747: -- Need to get the schema name using FND API. Refer Bug # 3431768
4748: --
4749: FOR l_link IN p_instance_header_tbl.FIRST..p_instance_header_tbl.LAST
4750: LOOP
4751: SELECT nvl(ib_item_instance_class,'X')
4774:
4775: IF l_header_tbl.COUNT>0
4776: THEN
4777: IF l_header_tbl(1).instance_id IS NOT NULL AND
4778: l_header_tbl(1).instance_id <> FND_API.G_MISS_NUM
4779: THEN
4780: BEGIN
4781: SELECT location_id,
4782: location_type_code
4791: --
4792: IF l_header_tbl.COUNT>1
4793: THEN
4794: IF l_header_tbl(2).instance_id IS NOT NULL AND
4795: l_header_tbl(2).instance_id <> FND_API.G_MISS_NUM
4796: THEN
4797:
4798: BEGIN
4799: SELECT location_id,
4849: l_xml_hdr VARCHAR2(2000);
4850: l_xml_message LONG := NULL;
4851:
4852: BEGIN
4853: x_return_status:= FND_API.G_RET_STS_SUCCESS;
4854:
4855: Create_hdr_xml
4856: ( p_config_hdr_id => p_config_hdr_id,
4857: p_config_rev_nbr => p_config_rev_nbr,
4860: x_return_status => x_return_status);
4861:
4862: csi_gen_utility_pvt.put_line('Status after calling Create_hdr_xml is '||x_return_status);
4863:
4864: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4865: RAISE FND_API.G_EXC_ERROR;
4866: END IF;
4867:
4868: Send_Input_xml
4861:
4862: csi_gen_utility_pvt.put_line('Status after calling Create_hdr_xml is '||x_return_status);
4863:
4864: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4865: RAISE FND_API.G_EXC_ERROR;
4866: END IF;
4867:
4868: Send_Input_xml
4869: ( p_xml_hdr => l_xml_hdr,
4871: x_return_status => x_return_status);
4872:
4873: csi_gen_utility_pvt.put_line('Status after calling Send_Input_xml is '||x_return_status);
4874:
4875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4876: RAISE FND_API.G_EXC_ERROR;
4877: END IF;
4878:
4879: Parse_output_xml
4872:
4873: csi_gen_utility_pvt.put_line('Status after calling Send_Input_xml is '||x_return_status);
4874:
4875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4876: RAISE FND_API.G_EXC_ERROR;
4877: END IF;
4878:
4879: Parse_output_xml
4880: ( p_xml => l_xml_message,
4884:
4885:
4886: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);
4887:
4888: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4889: RAISE FND_API.G_EXC_ERROR;
4890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4892: END IF;
4885:
4886: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);
4887:
4888: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4889: RAISE FND_API.G_EXC_ERROR;
4890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4892: END IF;
4893:
4886: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);
4887:
4888: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4889: RAISE FND_API.G_EXC_ERROR;
4890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4892: END IF;
4893:
4894: EXCEPTION
4887:
4888: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4889: RAISE FND_API.G_EXC_ERROR;
4890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4892: END IF;
4893:
4894: EXCEPTION
4895: WHEN FND_API.G_EXC_ERROR THEN
4891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4892: END IF;
4893:
4894: EXCEPTION
4895: WHEN FND_API.G_EXC_ERROR THEN
4896: x_return_status := FND_API.G_RET_STS_ERROR;
4897: csi_gen_utility_pvt.put_line('An exp error raised');
4898:
4899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4892: END IF;
4893:
4894: EXCEPTION
4895: WHEN FND_API.G_EXC_ERROR THEN
4896: x_return_status := FND_API.G_RET_STS_ERROR;
4897: csi_gen_utility_pvt.put_line('An exp error raised');
4898:
4899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4895: WHEN FND_API.G_EXC_ERROR THEN
4896: x_return_status := FND_API.G_RET_STS_ERROR;
4897: csi_gen_utility_pvt.put_line('An exp error raised');
4898:
4899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4901: csi_gen_utility_pvt.put_line('An unexp error raised');
4902:
4903: WHEN OTHERS THEN
4896: x_return_status := FND_API.G_RET_STS_ERROR;
4897: csi_gen_utility_pvt.put_line('An exp error raised');
4898:
4899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4901: csi_gen_utility_pvt.put_line('An unexp error raised');
4902:
4903: WHEN OTHERS THEN
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4901: csi_gen_utility_pvt.put_line('An unexp error raised');
4902:
4903: WHEN OTHERS THEN
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4905: csi_gen_utility_pvt.put_line( 'Send_input_xml error: ' ||substr(sqlerrm,1,100));
4906:
4907: END Call_batch_validate;
4908: --
5007: -- Added variables for bug 6755879, FP of bug 6680634
5008: l_err_mtl_txn_id NUMBER;
5009: l_err_mtl_txn_date DATE;
5010: BEGIN
5011: x_return_status := FND_API.G_RET_STS_SUCCESS;
5012: --
5013: csi_gen_utility_pvt.put_line('inside check_prior_txn');
5014:
5015: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5011: x_return_status := FND_API.G_RET_STS_SUCCESS;
5012: --
5013: csi_gen_utility_pvt.put_line('inside check_prior_txn');
5014:
5015: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5016: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5017: THEN
5018: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5019: csi_gen_utility_pvt.populate_install_param_rec;
5012: --
5013: csi_gen_utility_pvt.put_line('inside check_prior_txn');
5014:
5015: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5016: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5017: THEN
5018: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5019: csi_gen_utility_pvt.populate_install_param_rec;
5020: END IF;
5024:
5025: IF l_txn_seq_start_date IS NULL THEN
5026: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5027: FND_MSG_PUB.ADD;
5028: raise fnd_api.g_exc_error;
5029: END IF;
5030:
5031: IF p_instance_rec.last_txn_line_detail_id IS NULL OR
5032: p_instance_rec.last_txn_line_detail_id = FND_API.G_MISS_NUM THEN
5028: raise fnd_api.g_exc_error;
5029: END IF;
5030:
5031: IF p_instance_rec.last_txn_line_detail_id IS NULL OR
5032: p_instance_rec.last_txn_line_detail_id = FND_API.G_MISS_NUM THEN
5033: l_txn_line_detail_id := -9999;
5034: ELSE
5035: l_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
5036: END IF;
5034: ELSE
5035: l_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
5036: END IF;
5037: --
5038: l_cur_mtl_txn_id := NVL(p_txn_rec.inv_material_transaction_id,FND_API.G_MISS_NUM);
5039: IF l_cur_mtl_txn_id <> FND_API.G_MISS_NUM THEN
5040: Begin
5041: select creation_date
5042: into l_cur_mtl_txn_date
5035: l_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
5036: END IF;
5037: --
5038: l_cur_mtl_txn_id := NVL(p_txn_rec.inv_material_transaction_id,FND_API.G_MISS_NUM);
5039: IF l_cur_mtl_txn_id <> FND_API.G_MISS_NUM THEN
5040: Begin
5041: select creation_date
5042: into l_cur_mtl_txn_date
5043: from MTL_MATERIAL_TRANSACTIONS
5113: fnd_message.set_name('CSI','CSI_PENDING_PRIOR_TXN');
5114: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5115: fnd_msg_pub.add;
5116: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transaction_id;
5117: raise fnd_api.g_exc_error;
5118: END IF;
5119: IF l_mtl_txn_tbl(l_ind).transfer_transaction_id is not null THEN
5120: IF l_pending_txn_tbl.exists(l_mtl_txn_tbl(l_ind).transfer_transaction_id) THEN
5121: fnd_message.set_name('CSI','CSI_PENDING_PRIOR_TXN');
5121: fnd_message.set_name('CSI','CSI_PENDING_PRIOR_TXN');
5122: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transfer_transaction_id);
5123: fnd_msg_pub.add;
5124: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transfer_transaction_id;
5125: RAISE fnd_api.g_exc_error;
5126: END IF;
5127: END IF;
5128: END IF;
5129: END IF;
5140: p_transfer_transaction_id => l_xfer_mtl_txn_id)
5141: LOOP
5142: l_err_mtl_txn_id := err_txn_rec.inv_material_transaction_id;
5143:
5144: IF l_err_mtl_txn_id <> FND_API.G_MISS_NUM
5145: AND l_err_mtl_txn_id <> l_cur_mtl_txn_id THEN -- The errorred transaction is not the transaction currently being reprocessed
5146: BEGIN
5147: SELECT creation_date
5148: INTO l_err_mtl_txn_date
5155:
5156: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_id : '||l_err_mtl_txn_id);
5157: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);
5158:
5159: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE
5160: AND l_err_mtl_txn_date <= l_cur_mtl_txn_date)
5161: OR (l_err_mtl_txn_date = FND_API.G_MISS_DATE) THEN
5162: fnd_message.set_name('CSI','CSI_ERROR_PRIOR_TXN');
5163: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5157: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);
5158:
5159: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE
5160: AND l_err_mtl_txn_date <= l_cur_mtl_txn_date)
5161: OR (l_err_mtl_txn_date = FND_API.G_MISS_DATE) THEN
5162: fnd_message.set_name('CSI','CSI_ERROR_PRIOR_TXN');
5163: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5164: fnd_msg_pub.add;
5165: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transaction_id;
5162: fnd_message.set_name('CSI','CSI_ERROR_PRIOR_TXN');
5163: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5164: fnd_msg_pub.add;
5165: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transaction_id;
5166: RAISE fnd_api.g_exc_error;
5167: END IF;
5168: END IF;
5169: END LOOP;
5170:
5181: fnd_message.set_name('CSI','CSI_PENDING_PRIOR_TXN');
5182: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5183: fnd_msg_pub.add;
5184: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transaction_id;
5185: RAISE fnd_api.g_exc_error;
5186: END;
5187: END IF;
5188: END IF;
5189: END LOOP;
5226: FND_MESSAGE.SET_NAME('CSI','CSI_ERROR_INST_DETAILS');
5227: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number);
5228: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5229: FND_MSG_PUB.Add;
5230: RAISE fnd_api.g_exc_error;
5231: END IF;
5232: END IF; -- Item-srl# not null check
5233: EXCEPTION
5234: WHEN fnd_api.g_exc_error THEN
5230: RAISE fnd_api.g_exc_error;
5231: END IF;
5232: END IF; -- Item-srl# not null check
5233: EXCEPTION
5234: WHEN fnd_api.g_exc_error THEN
5235: x_return_status := FND_API.G_RET_STS_ERROR;
5236: END Check_Prior_Txn;
5237: --
5238: FUNCTION Is_Forward_Synch
5231: END IF;
5232: END IF; -- Item-srl# not null check
5233: EXCEPTION
5234: WHEN fnd_api.g_exc_error THEN
5235: x_return_status := FND_API.G_RET_STS_ERROR;
5236: END Check_Prior_Txn;
5237: --
5238: FUNCTION Is_Forward_Synch
5239: ( p_instance_id IN NUMBER,
5243: --
5244: l_return_value BOOLEAN;
5245: l_recount NUMBER;
5246: l_process_flag VARCHAR2(1) := 'P';
5247: l_mtl_txn_id NUMBER := NVL(p_mtl_txn_id,fnd_api.g_miss_num);
5248: l_def_cr_date DATE := sysdate;
5249: l_mtl_txn_cr_date DATE;
5250: BEGIN
5251: l_return_value := TRUE;
5250: BEGIN
5251: l_return_value := TRUE;
5252: --
5253: IF p_instance_id IS NOT NULL AND
5254: p_instance_id <> FND_API.G_MISS_NUM THEN
5255: l_recount := 0;
5256: IF nvl(p_stop_all_txn,FND_API.G_TRUE) = FND_API.G_TRUE THEN
5257: csi_gen_utility_pvt.put_line('Stop All Txns..');
5258: BEGIN
5252: --
5253: IF p_instance_id IS NOT NULL AND
5254: p_instance_id <> FND_API.G_MISS_NUM THEN
5255: l_recount := 0;
5256: IF nvl(p_stop_all_txn,FND_API.G_TRUE) = FND_API.G_TRUE THEN
5257: csi_gen_utility_pvt.put_line('Stop All Txns..');
5258: BEGIN
5259: select count(*)
5260: into l_recount
5268: END;
5269: --
5270: ELSE
5271: csi_gen_utility_pvt.put_line('Stop Later Txns..');
5272: IF l_mtl_txn_id <> fnd_api.g_miss_num THEN
5273: Begin
5274: select creation_date
5275: into l_mtl_txn_cr_date
5276: from MTL_MATERIAL_TRANSACTIONS
5316: l_exists VARCHAR2(1);
5317: BEGIN
5318: l_return_value := TRUE;
5319: IF p_master_org_id IS NULL OR
5320: p_master_org_id = FND_API.G_MISS_NUM THEN
5321: l_return_value := FALSE;
5322: RETURN l_return_value;
5323: END IF;
5324: --
5369: l_dummy VARCHAR2(500) := NULL;
5370: l_debug_level NUMBER;
5371: l_icx_session_ticket VARCHAR2(200);
5372: BEGIN
5373: x_return_status:= FND_API.G_RET_STS_SUCCESS;
5374:
5375:
5376:
5377: -- Now set the values from model_rec and org_id
5459:
5460: IF (l_debug_level > 1) THEN
5461: csi_gen_utility_pvt.dump_call_batch_val
5462: ( p_api_version => 1.0
5463: ,p_init_msg_list => fnd_api.g_false
5464: ,p_parameter_name => param_name
5465: ,p_parameter_value => param_value
5466: );
5467: END IF;
5494: csi_gen_utility_pvt.put_line('------------------------------------- ');
5495: EXCEPTION
5496: WHEN OTHERS THEN
5497: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);
5498: x_return_status := FND_API.G_RET_STS_ERROR;
5499: END Create_hdr_xml;
5500:
5501:
5502:
5531: l_long_xml LONG := NULL;
5532: l_return_status VARCHAR2(1);
5533:
5534: BEGIN
5535: l_return_status := FND_API.G_RET_STS_SUCCESS;
5536:
5537: csi_gen_utility_pvt.put_line('Entering Send_input_xml');
5538: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );
5539:
5557: csi_gen_utility_pvt.put_line('After call to batch validation the status is : '||l_validation_status );
5558:
5559:
5560: IF l_validation_status <> 0 THEN
5561: l_return_status := FND_API.G_RET_STS_ERROR;
5562: FND_MESSAGE.Set_Name('CSI', 'CSI_BATCH_VALIDATE');
5563: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from cz_network_api_pub.Validate, validation_status is: '||l_validation_status);
5564: FND_MSG_PUB.ADD;
5565: END IF;
5564: FND_MSG_PUB.ADD;
5565: END IF;
5566:
5567: IF (l_html_pieces.COUNT <= 0) THEN
5568: l_return_status := FND_API.G_RET_STS_ERROR;
5569: FND_MESSAGE.Set_Name('CSI', 'CSI_BATCH_VALIDATE');
5570: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from cz_network_api_pub.Validate, html_pieces count is <= 0' );
5571: FND_MSG_PUB.ADD;
5572: END IF;
5592: x_return_status := l_return_status;
5593: csi_gen_utility_pvt.put_line('Exiting csi_config_util.Send_input_xml');
5594: EXCEPTION
5595: WHEN OTHERS THEN
5596: x_return_status := FND_API.G_RET_STS_ERROR;
5597: csi_gen_utility_pvt.put_line( 'Inside Send_input_xml when others exception: ' ||substr(sqlerrm,1,100));
5598: END Send_input_xml;
5599:
5600: PROCEDURE Parse_output_xml
5655: l_selection_line_id NUMBER;
5656: l_valid_config VARCHAR2(10);
5657: l_complete_config VARCHAR2(10);
5658: l_header_id NUMBER;
5659: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
5660: l_return_status_del VARCHAR2(1);
5661: l_msg VARCHAR2(2000);
5662: l_constraint VARCHAR2(16);
5663: l_flag VARCHAR2(1) := 'N';
5795: /*
5796: IF nvl(l_valid_config, 'false') = 'false'
5797: OR l_exit = 'error'
5798: THEN
5799: l_return_status:=FND_API.G_RET_STS_ERROR;
5800: FND_MESSAGE.Set_Name('CSI', 'CSI_BATCH_VALIDATE');
5801: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from cz_network_api_pub.Validate, from Parse_output_xml ' );
5802: FND_MSG_PUB.ADD;
5803: csi_gen_utility_pvt.put_line('Configuration is invalid/incomplete');
5818: csi_gen_utility_pvt.put_line('Exiting parse_output_xml');
5819:
5820: EXCEPTION
5821: WHEN OTHERS THEN
5822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5823: csi_gen_utility_pvt.put_line( 'Parse_Output_xml error: ' || substr(sqlerrm,1,100));
5824:
5825: END Parse_output_xml;
5826:
5833: RETURN BOOLEAN
5834: IS
5835: l_eam NUMBER;
5836: BEGIN
5837: IF nvl(p_eam_item_type,-99) <> FND_API.G_MISS_NUM
5838: THEN
5839: IF p_eam_item_type in (1,3) THEN
5840: RETURN TRUE;
5841: ELSE
5889: fnd_message.set_name('CSI','CSI_SRL_PENDING_IN_TLD');
5890: fnd_message.set_token('SRC_TBL', tld_rec.source_transaction_table);
5891: fnd_message.set_token('SRC_ID', tld_rec.source_transaction_id);
5892: fnd_msg_pub.add;
5893: RAISE fnd_api.g_exc_error;
5894: END LOOP;
5895:
5896: FOR oi_rec IN oi_cur
5897: LOOP
5896: FOR oi_rec IN oi_cur
5897: LOOP
5898: fnd_message.set_name('CSI','CSI_SRL_PENDING_IN_OI');
5899: fnd_msg_pub.add;
5900: RAISE fnd_api.g_exc_error;
5901: END LOOP;
5902:
5903: RETURN FALSE;
5904:
5902:
5903: RETURN FALSE;
5904:
5905: EXCEPTION
5906: WHEN fnd_api.g_exc_error THEN
5907: RETURN TRUE;
5908: END pending_in_oi_or_tld;
5909:
5910: PROCEDURE validate_serial_for_upd(
5914: x_return_status OUT nocopy varchar2)
5915: IS
5916:
5917: l_gen_object_id number;
5918: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5919: l_current_txn_id NUMBER; --uncommented code for 6965008
5920: l_rec_count NUMBER;
5921:
5922: l_current_status NUMBER; -- added for 6176621
5954: AND ROWNUM = 1;
5955: --
5956: BEGIN
5957:
5958: x_return_status := fnd_api.g_ret_sts_success;
5959:
5960: IF p_txn_rec.transaction_type_id <> 205 THEN --Added condition and uncommented the code for bug 6965008
5961: IF p_txn_rec.inv_material_transaction_id IS NULL OR
5962: p_txn_rec.inv_material_transaction_id = FND_API.G_MISS_NUM THEN
5958: x_return_status := fnd_api.g_ret_sts_success;
5959:
5960: IF p_txn_rec.transaction_type_id <> 205 THEN --Added condition and uncommented the code for bug 6965008
5961: IF p_txn_rec.inv_material_transaction_id IS NULL OR
5962: p_txn_rec.inv_material_transaction_id = FND_API.G_MISS_NUM THEN
5963: l_current_txn_id := -99999;
5964: ELSE
5965: l_current_txn_id := p_txn_rec.inv_material_transaction_id;
5966: END IF;
5971: fnd_message.set_name('CSI', 'CSI_SRL_IN_INT_CANNOT_UPD');
5972: fnd_message.set_token('INST_NUM', p_instance_rec.instance_number);
5973: fnd_message.set_token('LOC_TYPE_CODE', p_instance_rec.location_type_code);
5974: fnd_msg_pub.add;
5975: RAISE fnd_api.g_exc_error;
5976: END IF;
5977: END IF;
5978:
5979: -- Added the following IF to handle NULL to NOT NULL serial update
5977: END IF;
5978:
5979: -- Added the following IF to handle NULL to NOT NULL serial update
5980: IF p_old_serial_number IS NOT NULL AND
5981: p_old_serial_number <> fnd_api.g_miss_char THEN
5982:
5983: IF p_txn_rec.transaction_type_id <> 205 THEN --Added condition and uncommented the code for bug 6965008
5984: -- check for existence in mut and error
5985: FOR all_txn_rec IN all_txn_cur(p_instance_rec.inventory_item_id,p_old_serial_number,-9999)
5986: LOOP
5987: fnd_message.set_name('CSI', 'CSI_OLD_SRL_HAS_TXN_CANNOT_UPD');
5988: fnd_message.set_token('SERIAL_NUM', p_old_serial_number);
5989: fnd_msg_pub.add;
5990: RAISE fnd_api.g_exc_error;
5991: END LOOP;
5992:
5993: --uncommented the code and brought the code up for bug 6965008
5994:
6016: IF l_rec_count > 0 THEN
6017: fnd_message.set_name('CSI', 'CSI_OLD_SRL_HAS_EAM_CANNOT_UPD');
6018: fnd_message.set_token('SERIAL_NUM', p_old_serial_number);
6019: fnd_msg_pub.add;
6020: RAISE fnd_api.g_exc_error;
6021: END IF;
6022: END IF;
6023:
6024: BEGIN
6033: IF l_current_status <> 4 THEN
6034: fnd_message.set_name('CSI', 'CSI_SRL_IN_USE_CANNOT_UPD');
6035: fnd_message.set_token('SERIAL_NUM',p_old_serial_number);
6036: fnd_msg_pub.add;
6037: RAISE fnd_api.g_exc_error;
6038: END IF;
6039: --code fix end for 6176621
6040: --
6041: FOR mog_rec IN mog_cur(l_gen_object_id)
6042: LOOP
6043: fnd_message.set_name('CSI', 'CSI_SRL_IN_MOG_CANNOT_UPD');
6044: fnd_message.set_token('SERIAL_NUM',p_old_serial_number);
6045: fnd_msg_pub.add;
6046: RAISE fnd_api.g_exc_error;
6047: END LOOP;
6048:
6049: -- check pending transaction in open interface and installation detail references
6050: IF pending_in_oi_or_tld(p_instance_rec.inventory_item_id, p_old_serial_number) THEN
6047: END LOOP;
6048:
6049: -- check pending transaction in open interface and installation detail references
6050: IF pending_in_oi_or_tld(p_instance_rec.inventory_item_id, p_old_serial_number) THEN
6051: RAISE fnd_api.g_exc_error;
6052: END IF;
6053: --
6054: EXCEPTION
6055: WHEN no_data_found THEN
6066: -- we should ignore the current material transaction as the current txn is one that is updating it.
6067: -- Whenever we filter the serial records based on transaction_id, we cannot use MUT always.
6068: -- If the item is lot-serial controlled then it needs to be joined with MTLN.
6069: --
6070: IF nvl(p_old_serial_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char
6071: AND p_txn_rec.transaction_type_id <> 205 --Added condition and uncommented the code for bug 6965008
6072: THEN
6073: FOR all_txn_rec IN all_txn_cur(p_instance_rec.inventory_item_id,
6074: p_instance_rec.serial_number,
6076: LOOP
6077: fnd_message.set_name('CSI', 'CSI_SRL_HAS_TXN_CANNOT_UPD');
6078: fnd_message.set_token('SERIAL_NUM', p_instance_rec.serial_number);
6079: fnd_msg_pub.add;
6080: RAISE fnd_api.g_exc_error;
6081: END LOOP;
6082: END IF;
6083: ----uncommented code for 6965008
6084: fnd_message.set_name('CSI', 'CSI_SERIAL_UPD_WARNING');
6088: --
6089: -- Warning Status should be handled by Public API based ont Serial Number Update Event
6090: -- x_return_status := 'W';
6091: EXCEPTION
6092: WHEN fnd_api.g_exc_error THEN
6093: x_return_status := fnd_api.g_ret_sts_error;
6094: END validate_serial_for_upd;
6095: --
6096: /*-----------------------------------------------------------*/
6089: -- Warning Status should be handled by Public API based ont Serial Number Update Event
6090: -- x_return_status := 'W';
6091: EXCEPTION
6092: WHEN fnd_api.g_exc_error THEN
6093: x_return_status := fnd_api.g_ret_sts_error;
6094: END validate_serial_for_upd;
6095: --
6096: /*-----------------------------------------------------------*/
6097: /* This function gets the version label of an item instance */
6113: and date_time_stamp <= l_time_stamp
6114: order by date_time_stamp desc;
6115: BEGIN
6116: IF p_time_stamp IS NULL OR
6117: p_time_stamp = FND_API.G_MISS_DATE THEN
6118: l_time_stamp := sysdate + 1;
6119: ELSE
6120: l_time_stamp := p_time_stamp;
6121: END IF;
6173:
6174: IF l_txn_seq_start_date is null THEN
6175: fnd_message.set_name('CSI','CSI_API_UNINSTALLED_PARAMETER');
6176: fnd_msg_pub.add;
6177: raise fnd_api.g_exc_error;
6178: END IF;
6179:
6180: FOR unit_txn_rec IN unit_txn_cur
6181: LOOP