eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on FND_API

Line 23: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN

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;

Line 28: RAISE FND_API.G_EXC_ERROR;

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: /*-----------------------------------------------------------*/

Line 44: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN

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;

Line 49: RAISE FND_API.G_EXC_ERROR;

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: /*-----------------------------------------------------------*/

Line 65: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN

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;

Line 70: RAISE FND_API.G_EXC_ERROR;

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: /*-----------------------------------------------------*/

Line 161: (p_item_instance_id = FND_API.G_MISS_NUM)) THEN

157: BEGIN
158: IF p_mode='CREATE'
159: THEN
160: IF ((p_item_instance_id IS NULL) OR
161: (p_item_instance_id = FND_API.G_MISS_NUM)) THEN
162: l_return_value := FALSE;
163: ELSE
164: IF ((p_instance_number IS NULL) OR
165: (p_instance_number = FND_API.G_MISS_CHAR)) THEN

Line 165: (p_instance_number = FND_API.G_MISS_CHAR)) THEN

161: (p_item_instance_id = FND_API.G_MISS_NUM)) THEN
162: l_return_value := FALSE;
163: ELSE
164: IF ((p_instance_number IS NULL) OR
165: (p_instance_number = FND_API.G_MISS_CHAR)) THEN
166: l_return_value := TRUE;
167: ELSE
168: -- Added for eam integration
169: BEGIN

Line 265: If p_trackable_flag <> FND_API.G_MISS_CHAR then

261: AND nvl (end_date_active, sysdate+1) > sysdate;
262:
263:
264:
265: If p_trackable_flag <> FND_API.G_MISS_CHAR then
266: if nvl(p_trackable_flag,'N') <> 'Y' then
267: l_return_value := FALSE;
268: IF (p_stack_err_msg = TRUE) THEN
269: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_TRACKABLE');

Line 283: IF ((p_inv_item_id IS NOT NULL) AND (p_inv_item_id <> FND_API.G_MISS_NUM)) AND

279: RETURN l_return_value;
280: End if;
281: --
282: -- Check for inventory item id and Org id values
283: IF ((p_inv_item_id IS NOT NULL) AND (p_inv_item_id <> FND_API.G_MISS_NUM)) AND
284: ((p_org_id IS NOT NULL) AND (p_org_id <> FND_API.G_MISS_NUM)) THEN
285:
286:
287: IF UPPER(l_temp_string) = 'Y' THEN

Line 284: ((p_org_id IS NOT NULL) AND (p_org_id <> FND_API.G_MISS_NUM)) THEN

280: End if;
281: --
282: -- Check for inventory item id and Org id values
283: IF ((p_inv_item_id IS NOT NULL) AND (p_inv_item_id <> FND_API.G_MISS_NUM)) AND
284: ((p_org_id IS NOT NULL) AND (p_org_id <> FND_API.G_MISS_NUM)) THEN
285:
286:
287: IF UPPER(l_temp_string) = 'Y' THEN
288: l_return_value := TRUE;

Line 331: IF p_instance_rec.serial_number <> fnd_api.g_miss_char

327: l_return_value IN OUT NOCOPY BOOLEAN
328: ) IS
329:
330: BEGIN
331: IF p_instance_rec.serial_number <> fnd_api.g_miss_char
332: AND p_instance_rec.serial_number IS NOT NULL
333: THEN
334: csi_item_instance_vld_pvt.Validate_Serial_Number
335: (

Line 349: IF p_instance_rec.lot_number <> fnd_api.g_miss_char

345: l_return_value => l_return_value
346: );
347: END IF;
348:
349: IF p_instance_rec.lot_number <> fnd_api.g_miss_char
350: AND p_instance_rec.lot_number IS NOT NULL
351: AND l_return_value
352: THEN
353: csi_item_instance_vld_pvt.Validate_Lot_Number

Line 365: IF p_instance_rec.inventory_revision <> fnd_api.g_miss_char

361: l_return_value => l_return_value
362: );
363: END IF;
364:
365: IF p_instance_rec.inventory_revision <> fnd_api.g_miss_char
366: AND p_instance_rec.inventory_revision IS NOT NULL
367: AND l_return_value
368: THEN
369: csi_item_instance_vld_pvt.Validate_Revision

Line 410: If p_rev_control_code <> FND_API.G_MISS_NUM Then

406: AND nvl (start_date_active, sysdate) <= sysdate
407: AND nvl (end_date_active, sysdate+1) > sysdate;
408:
409: BEGIN
410: If p_rev_control_code <> FND_API.G_MISS_NUM Then
411: l_dummy := p_rev_control_code;
412: else
413: OPEN c1;
414: FETCH c1 into l_dummy;

Line 424: (p_revision = FND_API.G_MISS_CHAR)) THEN

420: -- '1' stands for - No revision control
421: -- '2' stands for - Full revision control
422: IF NVL(l_dummy,0) = 2 THEN
423: IF ((p_revision IS NULL) OR
424: (p_revision = FND_API.G_MISS_CHAR)) THEN
425: IF (p_creation_complete_flag = 'Y') THEN
426: l_return_value := FALSE;
427: IF ( l_stack_err_msg = TRUE ) THEN
428: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REVISION');

Line 458: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN

454: END;
455: END IF;
456: ELSE
457: -- Item is not under revision control but inventory_revision is not NULL
458: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN
459: BEGIN
460: SELECT 1
461: INTO l_dummy
462: FROM mtl_item_revisions

Line 517: If p_rev_control_code <> FND_API.G_MISS_NUM Then

513: AND nvl (end_date_active, sysdate+1) > sysdate;
514:
515: BEGIN
516: l_return_value := TRUE;
517: If p_rev_control_code <> FND_API.G_MISS_NUM Then
518: l_dummy := p_rev_control_code;
519: else
520: OPEN c1;
521: FETCH c1 into l_dummy;

Line 531: (p_revision = FND_API.G_MISS_CHAR)) THEN

527: -- '1' stands for - No revision control
528: -- '2' stands for - Full revision control
529: IF NVL(l_dummy,0) = 2 THEN
530: IF ((p_revision IS NULL) OR
531: (p_revision = FND_API.G_MISS_CHAR)) THEN
532: l_return_value := FALSE;
533: IF ( l_stack_err_msg = TRUE ) THEN
534: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REVISION');
535: FND_MESSAGE.SET_TOKEN('INVENTORY_REVISION',p_revision);

Line 559: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN

555: END;
556: END IF;
557: ELSE
558: -- Item is not under revision control but inventory_revision is not NULL
559: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN
560: BEGIN
561: SELECT 1
562: INTO l_dummy
563: FROM mtl_item_revisions

Line 708: p_ins_flag := FND_API.G_FALSE;

704: -- Across organizations (status = 3)
705: --
706: --
707: l_return_value := TRUE;
708: p_ins_flag := FND_API.G_FALSE;
709: --
710:
711: IF nvl(p_lot_number,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
712: l_lot_number := NULL;

Line 711: IF nvl(p_lot_number,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

707: l_return_value := TRUE;
708: p_ins_flag := FND_API.G_FALSE;
709: --
710:
711: IF nvl(p_lot_number,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
712: l_lot_number := NULL;
713: ELSE
714: l_lot_number := p_lot_number;
715: END IF;

Line 738: IF ((p_location_type_code IS NOT NULL) AND (p_location_type_code <> FND_API.G_MISS_CHAR))

734: -- the same should get created with current_status = 4 (out of stores). All other statuses should be
735: -- driven by Inventory.
736: --
737: /****** COMMENTED
738: IF ((p_location_type_code IS NOT NULL) AND (p_location_type_code <> FND_API.G_MISS_CHAR))
739: THEN
740: IF p_location_type_code = 'IN_TRANSIT'
741: THEN
742: l_current_status := 5;

Line 809: ,p_init_msg_list => fnd_api.g_false

805: CLOSE ser_upd_csr;
806: csi_gen_utility_pvt.put_line('Calling INV API to update Serial Number...');
807: inv_serial_number_pub.updateserial(
808: p_api_version => 1.0
809: ,p_init_msg_list => fnd_api.g_false
810: ,p_commit => fnd_api.g_false
811: ,p_validation_level => fnd_api.g_valid_level_full
812: ,p_inventory_item_id => p_inv_item_id
813: ,p_organization_id => p_inv_org_id

Line 810: ,p_commit => fnd_api.g_false

806: csi_gen_utility_pvt.put_line('Calling INV API to update Serial Number...');
807: inv_serial_number_pub.updateserial(
808: p_api_version => 1.0
809: ,p_init_msg_list => fnd_api.g_false
810: ,p_commit => fnd_api.g_false
811: ,p_validation_level => fnd_api.g_valid_level_full
812: ,p_inventory_item_id => p_inv_item_id
813: ,p_organization_id => p_inv_org_id
814: ,p_serial_number => p_serial_number

Line 811: ,p_validation_level => fnd_api.g_valid_level_full

807: inv_serial_number_pub.updateserial(
808: p_api_version => 1.0
809: ,p_init_msg_list => fnd_api.g_false
810: ,p_commit => fnd_api.g_false
811: ,p_validation_level => fnd_api.g_valid_level_full
812: ,p_inventory_item_id => p_inv_item_id
813: ,p_organization_id => p_inv_org_id
814: ,p_serial_number => p_serial_number
815: ,p_initialization_date => l_ser_upd_csr.initialization_date

Line 848: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

844: ,p_planning_tp_type => NULL
845: ,p_transaction_action_id => NULL
846: );
847: p_gen_object_id := l_object_id;
848: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
849: l_return_value := FALSE;
850: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_UPD_SERIAL');
851: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from inv_serial_number_pub.updateserial');
852: FND_MSG_PUB.ADD;

Line 1017: p_init_msg_list => fnd_api.g_false,

1013: -- call the Inventory API to insert serial no. into the MSN table
1014: csi_gen_utility_pvt.put_line('Calling INV API to create Serial Number...');
1015: inv_serial_number_pub.insertSerial(
1016: p_api_version => 1.0,
1017: p_init_msg_list => fnd_api.g_false,
1018: p_commit => fnd_api.g_false,
1019: p_validation_level => fnd_api.g_valid_level_full,
1020: p_inventory_item_id => p_inv_item_id,
1021: p_organization_id => p_inv_org_id,

Line 1018: p_commit => fnd_api.g_false,

1014: csi_gen_utility_pvt.put_line('Calling INV API to create Serial Number...');
1015: inv_serial_number_pub.insertSerial(
1016: p_api_version => 1.0,
1017: p_init_msg_list => fnd_api.g_false,
1018: p_commit => fnd_api.g_false,
1019: p_validation_level => fnd_api.g_valid_level_full,
1020: p_inventory_item_id => p_inv_item_id,
1021: p_organization_id => p_inv_org_id,
1022: p_serial_number => p_serial_number,

Line 1019: p_validation_level => fnd_api.g_valid_level_full,

1015: inv_serial_number_pub.insertSerial(
1016: p_api_version => 1.0,
1017: p_init_msg_list => fnd_api.g_false,
1018: p_commit => fnd_api.g_false,
1019: p_validation_level => fnd_api.g_valid_level_full,
1020: p_inventory_item_id => p_inv_item_id,
1021: p_organization_id => p_inv_org_id,
1022: p_serial_number => p_serial_number,
1023: p_initialization_date => SYSDATE,

Line 1060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1056: p_operation_seq_num => NULL,
1057: p_intraoperation_step_type => NULL );
1058:
1059: p_gen_object_id := l_object_id;
1060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: l_return_value := FALSE;
1062: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_INV_SERIAL');
1063: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from inv_serial_number_pub.insertserial');
1064: FND_MSG_PUB.ADD;

Line 1067: p_ins_flag := FND_API.G_TRUE;

1063: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from inv_serial_number_pub.insertserial');
1064: FND_MSG_PUB.ADD;
1065: ELSE
1066: l_return_value := TRUE;
1067: p_ins_flag := FND_API.G_TRUE;
1068: csi_gen_utility_pvt.put_line('Serial Number created successfully in MTL_SERIAL_NUMBERS..');
1069: END IF;
1070: END IF; -- (l_temp is null)
1071: END IF;

Line 1123: If p_srl_control_code <> FND_API.G_MISS_NUM then

1119: Serialized NUMBER;
1120: l_found VARCHAR2(1);
1121: BEGIN
1122: l_return_value := TRUE;
1123: If p_srl_control_code <> FND_API.G_MISS_NUM then
1124: serialized := p_srl_control_code;
1125: else
1126: OPEN c1;
1127: FETCH c1 into serialized;

Line 1134: IF NVL(p_txn_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR) = 'FIELD_SERVICE_TXN' THEN

1130:
1131: -- Bug 12574008
1132: -- If the transaction is a Field Service Transaction
1133: -- Then assign p_txn_rec.ATTRIBUTE15
1134: IF NVL(p_txn_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR) = 'FIELD_SERVICE_TXN' THEN
1135: l_inv_txn_typeid_from_cs := to_number(p_txn_rec.ATTRIBUTE15);
1136: END IF;
1137:
1138: -- Get serial tagging control 9977630

Line 1164: (p_serial_number = FND_API.G_MISS_CHAR)) THEN

1160: )
1161: OR NVL(l_serial_tagged,'N') = 'Y' --Modified to OR from AND for Bug 12631458
1162: THEN
1163: IF ((p_serial_number IS NULL) OR
1164: (p_serial_number = FND_API.G_MISS_CHAR)) THEN
1165: IF (p_creation_complete_flag = 'Y') THEN
1166: l_return_value := FALSE;
1167: IF (p_stack_err_msg = TRUE) THEN
1168: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SERIAL_NUM');

Line 1188: IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR))

1184: ,p_transaction_type_id => p_txn_rec.transaction_type_id
1185: )
1186: AND NVL(l_serial_tagged,'N') <> 'Y'
1187: THEN
1188: IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR))
1189: THEN
1190: l_found := NULL;
1191: IF serialized IS NOT NULL
1192: AND serialized=6

Line 1230: p_serial_number <> fnd_api.g_miss_char

1226: END IF;
1227:
1228: IF l_return_value = TRUE AND
1229: p_serial_number IS NOT NULL AND
1230: p_serial_number <> fnd_api.g_miss_char
1231: THEN
1232: Validate_ser_uniqueness
1233: ( p_inv_org_id => p_inv_org_id
1234: ,p_inv_item_id => p_inv_item_id

Line 1284: p_instance_id = FND_API.G_MISS_NUM THEN

1280: -- API. This is basically to validate the serial number when the vld_organization_id changes.
1281: -- In this, the uniqueness check should ignore the current instance.
1282: --
1283: IF p_instance_id IS NULL OR
1284: p_instance_id = FND_API.G_MISS_NUM THEN
1285: l_instance_id := -99999;
1286: ELSE
1287: l_instance_id := p_instance_id;
1288: END IF;

Line 1551: (p_instance_id = FND_API.G_MISS_NUM)) THEN

1547: --
1548: BEGIN
1549: --
1550: IF ((p_instance_id IS NULL) OR
1551: (p_instance_id = FND_API.G_MISS_NUM)) THEN
1552: l_instance_id := -99999;
1553: ELSE
1554: l_instance_id := p_instance_id;
1555: END IF;

Line 1647: p_init_msg_list => fnd_api.g_false,

1643: --
1644: -- Call the Inventory API to insert the lot number
1645: inv_lot_api_pub.insertlot (
1646: p_api_version => 1.0,
1647: p_init_msg_list => fnd_api.g_false,
1648: p_commit => fnd_api.g_false,
1649: p_validation_level => fnd_api.g_valid_level_full,
1650: p_inventory_item_id => p_inv_item_id,
1651: p_organization_id => p_inv_org_id,

Line 1648: p_commit => fnd_api.g_false,

1644: -- Call the Inventory API to insert the lot number
1645: inv_lot_api_pub.insertlot (
1646: p_api_version => 1.0,
1647: p_init_msg_list => fnd_api.g_false,
1648: p_commit => fnd_api.g_false,
1649: p_validation_level => fnd_api.g_valid_level_full,
1650: p_inventory_item_id => p_inv_item_id,
1651: p_organization_id => p_inv_org_id,
1652: p_lot_number => p_lot_number,

Line 1649: p_validation_level => fnd_api.g_valid_level_full,

1645: inv_lot_api_pub.insertlot (
1646: p_api_version => 1.0,
1647: p_init_msg_list => fnd_api.g_false,
1648: p_commit => fnd_api.g_false,
1649: p_validation_level => fnd_api.g_valid_level_full,
1650: p_inventory_item_id => p_inv_item_id,
1651: p_organization_id => p_inv_org_id,
1652: p_lot_number => p_lot_number,
1653: p_expiration_date => l_expiration_date,

Line 1662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1658: x_return_status => l_return_status,
1659: x_msg_count => l_msg_count,
1660: x_msg_data => l_msg_data);
1661:
1662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1663: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_INV_LOT_NUM');
1664: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from inv_lot_api_pub.InsertLot Procedure');
1665: FND_MSG_PUB.ADD;
1666: RAISE comp_error;

Line 1709: IF p_lot_control_code <> FND_API.G_MISS_NUM

1705: AND nvl (start_date_active, sysdate) <= sysdate
1706: AND nvl (end_date_active, sysdate+1) > sysdate;
1707:
1708: BEGIN
1709: IF p_lot_control_code <> FND_API.G_MISS_NUM
1710: THEN
1711: l_dummy := p_lot_control_code;
1712: ELSE
1713: OPEN c1;

Line 1727: (p_lot_number = FND_API.G_MISS_CHAR))

1723: IF l_dummy = 2 -- Lot Controlled
1724: THEN
1725: --
1726: IF ((p_lot_number IS NULL) OR
1727: (p_lot_number = FND_API.G_MISS_CHAR))
1728: THEN
1729: IF (p_creation_complete_flag = 'Y')
1730: THEN
1731: l_return_value := FALSE;

Line 1746: (p_lot_number <> FND_API.G_MISS_CHAR))

1742: --
1743: ELSE -- Item is not under lot control but lot_number is NOT NULL
1744: --
1745: IF ((p_lot_number IS NOT NULL) AND
1746: (p_lot_number <> FND_API.G_MISS_CHAR))
1747: THEN
1748: l_return_value := FALSE;
1749: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_LOT_CONTROLLED');
1750: FND_MESSAGE.SET_TOKEN('LOT_NUMBER',p_lot_number);

Line 1799: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN

1795: WHERE organization_id = p_inv_organization_id;
1796:
1797: BEGIN
1798:
1799: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
1800: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized
1801: ( p_serial_control_code => p_serial_control_code
1802: ,p_location_type_code => p_location_type_code
1803: ,p_transaction_type_id => p_csi_txn_type_id

Line 1862: p_instance_id <> fnd_api.g_miss_num)

1858: END IF;
1859: CLOSE C1;
1860: ELSIF p_quantity > 1 AND
1861: (p_instance_id IS NOT NULL AND
1862: p_instance_id <> fnd_api.g_miss_num)
1863: THEN
1864: BEGIN
1865: SELECT subject_id
1866: INTO l_dummy

Line 1982: (p_uom_code = FND_API.G_MISS_CHAR)) THEN

1978: to_unit VARCHAR2(3);
1979: BEGIN
1980: -- check whether the uom class exists for the unit of measure code passed
1981: IF ((p_uom_code IS NULL) OR
1982: (p_uom_code = FND_API.G_MISS_CHAR)) THEN
1983: IF (p_creation_complete_flag = 'Y') THEN
1984: l_return_value := FALSE;
1985: ELSE
1986: p_creation_complete_flag := 'N';

Line 2015: IF ((to_unit IS NOT NULL) AND (to_unit <> FND_API.G_MISS_CHAR)) THEN

2011: FND_MSG_PUB.Add;
2012: l_return_value := FALSE;
2013: END;
2014: -- if primary uom code exists, then check whether it is same as the uom code passed
2015: IF ((to_unit IS NOT NULL) AND (to_unit <> FND_API.G_MISS_CHAR)) THEN
2016: IF to_unit = p_uom_code THEN
2017: p_quantity := p_quantity;
2018: p_uom_code := to_unit;
2019: l_return_value := TRUE;

Line 2063: (p_instance_condition_id = FND_API.G_MISS_NUM)) THEN

2059: -- Verify that the Instance Condition is valid i.e.
2060: -- it exists in inventory material status codes (MTL_MATERIAL_STATUSES_B)
2061:
2062: IF ((p_instance_condition_id IS NULL) OR
2063: (p_instance_condition_id = FND_API.G_MISS_NUM)) THEN
2064: l_return_value := TRUE;
2065: ELSE
2066: BEGIN
2067: SELECT '1'

Line 2105: (p_instance_status_id = FND_API.G_MISS_NUM))THEN

2101: -- raise the CSI_API_INVALID_INST_STATUS exception.
2102: BEGIN
2103:
2104: IF ((p_instance_status_id IS NULL) OR
2105: (p_instance_status_id = FND_API.G_MISS_NUM))THEN
2106: IF (p_creation_complete_flag = 'Y') THEN
2107: l_return_value := FALSE;
2108: IF ( l_stack_err_msg = TRUE ) THEN
2109: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_STATUS');

Line 2154: IF ((p_end_date IS NOT NULL) AND (p_end_date = FND_API.G_MISS_DATE)) THEN

2150:
2151: l_return_value BOOLEAN := TRUE;
2152:
2153: BEGIN
2154: IF ((p_end_date IS NOT NULL) AND (p_end_date = FND_API.G_MISS_DATE)) THEN
2155:
2156: IF to_date(p_start_date,'DD-MM-YY HH24:MI') > to_date(p_end_date,'DD-MM-YY HH24:MI') THEN -- Bug 8586745
2157: l_return_value := FALSE;
2158: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_START_DATE');

Line 2194: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

2190: l_return_value BOOLEAN := TRUE;
2191:
2192: BEGIN
2193:
2194: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
2195:
2196: IF to_date(p_start_date,'DD-MM-YY HH24:MI') > to_date(p_end_date,'DD-MM-YY HH24:MI') THEN -- Bug 8586745
2197: l_return_value := FALSE;
2198: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_END_DATE');

Line 2237: (p_system_id = FND_API.G_MISS_NUM)) THEN

2233: -- Validate the System ID against CSI_SYSTEMS_VL table .
2234: BEGIN
2235:
2236: IF ((p_system_id IS NULL) OR
2237: (p_system_id = FND_API.G_MISS_NUM)) THEN
2238: l_return_value := TRUE;
2239: ELSE
2240: BEGIN
2241: SELECT '1'

Line 2282: (p_instance_type_code = FND_API.G_MISS_CHAR)) THEN

2278: -- Validate the Instance Type Code against CSI_LOOKUPS table .
2279: BEGIN
2280:
2281: IF ((p_instance_type_code IS NULL) OR
2282: (p_instance_type_code = FND_API.G_MISS_CHAR)) THEN
2283: l_return_value := TRUE;
2284: ELSE
2285: BEGIN
2286: SELECT '1'

Line 2326: (p_inst_usage_code = FND_API.G_MISS_CHAR)) THEN

2322: -- Validate the System ID against CSI_LOOKUPS table .
2323: BEGIN
2324:
2325: IF ((p_inst_usage_code IS NULL) OR
2326: (p_inst_usage_code = FND_API.G_MISS_CHAR)) THEN
2327: l_return_value := TRUE;
2328: ELSE
2329: BEGIN
2330: SELECT '1'

Line 2368: (p_operational_status = FND_API.G_MISS_CHAR))

2364:
2365: -- Validate the System ID against CSI_LOOKUPS table .
2366: BEGIN
2367: IF ((p_operational_status IS NULL) OR
2368: (p_operational_status = FND_API.G_MISS_CHAR))
2369: THEN
2370: l_return_value := TRUE;
2371: ELSE
2372: BEGIN

Line 2406: (p_currency_code = FND_API.G_MISS_CHAR))

2402: l_dummy VARCHAR2(30);
2403: l_return_value BOOLEAN := TRUE;
2404: BEGIN
2405: IF ((p_currency_code IS NULL) OR
2406: (p_currency_code = FND_API.G_MISS_CHAR))
2407: THEN
2408: l_return_value := TRUE;
2409: ELSE
2410: BEGIN

Line 2485: p_srl_control_code <> FND_API.G_MISS_NUM then

2481: l_count NUMBER;
2482:
2483: BEGIN
2484: If p_srl_control_code is not null AND
2485: p_srl_control_code <> FND_API.G_MISS_NUM then
2486: l_serial_code := p_srl_control_code;
2487: l_return_value := TRUE;
2488: Else
2489: select serial_number_control_code

Line 2527: (a.inventory_revision IS NULL AND p_instance_rec.inventory_revision = FND_API.G_MISS_CHAR) OR

2523: AND a.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
2524: AND a.active_end_date IS NULL --code added for bug 5702911 --
2525: AND (
2526: (a.inventory_revision IS NULL AND p_instance_rec.inventory_revision IS NULL) OR
2527: (a.inventory_revision IS NULL AND p_instance_rec.inventory_revision = FND_API.G_MISS_CHAR) OR
2528: (a.inventory_revision = p_instance_rec.inventory_revision)
2529: )
2530: AND (
2531: (a.lot_number IS NULL AND p_instance_rec.lot_number IS NULL) OR

Line 2532: (a.lot_number IS NULL AND p_instance_rec.lot_number = FND_API.G_MISS_CHAR) OR

2528: (a.inventory_revision = p_instance_rec.inventory_revision)
2529: )
2530: AND (
2531: (a.lot_number IS NULL AND p_instance_rec.lot_number IS NULL) OR
2532: (a.lot_number IS NULL AND p_instance_rec.lot_number = FND_API.G_MISS_CHAR) OR
2533: (a.lot_number = p_instance_rec.lot_number)
2534: )
2535: AND (
2536: (a.inv_locator_id IS NULL AND p_instance_rec.inv_locator_id IS NULL) OR

Line 2537: (a.inv_locator_id IS NULL AND p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM) OR

2533: (a.lot_number = p_instance_rec.lot_number)
2534: )
2535: AND (
2536: (a.inv_locator_id IS NULL AND p_instance_rec.inv_locator_id IS NULL) OR
2537: (a.inv_locator_id IS NULL AND p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM) OR
2538: (a.inv_locator_id = p_instance_rec.inv_locator_id)
2539: )
2540: AND (
2541: (a.INSTANCE_STATUS_ID IS NULL AND p_instance_rec.INSTANCE_STATUS_ID IS NULL) OR

Line 2542: (a.INSTANCE_STATUS_ID IS NULL AND p_instance_rec.INSTANCE_STATUS_ID = FND_API.G_MISS_NUM) OR

2538: (a.inv_locator_id = p_instance_rec.inv_locator_id)
2539: )
2540: AND (
2541: (a.INSTANCE_STATUS_ID IS NULL AND p_instance_rec.INSTANCE_STATUS_ID IS NULL) OR
2542: (a.INSTANCE_STATUS_ID IS NULL AND p_instance_rec.INSTANCE_STATUS_ID = FND_API.G_MISS_NUM) OR
2543: (a.INSTANCE_STATUS_ID = p_instance_rec.INSTANCE_STATUS_ID)
2544: )
2545: AND a.owner_party_id = p_party_rec.party_id
2546: AND a.owner_party_source_table = p_party_rec.party_source_table

Line 2598: (p_loc_source_table = FND_API.G_MISS_CHAR)) THEN

2594:
2595: BEGIN
2596:
2597: IF ((p_loc_source_table IS NULL) OR
2598: (p_loc_source_table = FND_API.G_MISS_CHAR)) THEN
2599: l_return_value := TRUE;
2600: ELSE
2601: BEGIN
2602: SELECT '1'

Line 2635: IF ( p_instance_rec.instance_id = fnd_api.g_miss_num )

2631: IS
2632: BEGIN
2633:
2634: --
2635: IF ( p_instance_rec.instance_id = fnd_api.g_miss_num )
2636: THEN l_get_instance_rec.instance_id := l_curr_instance_rec.instance_id;
2637: ELSE l_get_instance_rec.instance_id := p_instance_rec.instance_id;
2638: END IF;
2639:

Line 2640: IF ( p_instance_rec.instance_number = fnd_api.g_miss_char )

2636: THEN l_get_instance_rec.instance_id := l_curr_instance_rec.instance_id;
2637: ELSE l_get_instance_rec.instance_id := p_instance_rec.instance_id;
2638: END IF;
2639:
2640: IF ( p_instance_rec.instance_number = fnd_api.g_miss_char )
2641: THEN l_get_instance_rec.instance_number := l_curr_instance_rec.instance_number;
2642: ELSE l_get_instance_rec.instance_number := p_instance_rec.instance_number;
2643: END IF;
2644:

Line 2645: IF ( p_instance_rec.external_reference = fnd_api.g_miss_char )

2641: THEN l_get_instance_rec.instance_number := l_curr_instance_rec.instance_number;
2642: ELSE l_get_instance_rec.instance_number := p_instance_rec.instance_number;
2643: END IF;
2644:
2645: IF ( p_instance_rec.external_reference = fnd_api.g_miss_char )
2646: THEN l_get_instance_rec.external_reference := l_curr_instance_rec.external_reference;
2647: ELSE l_get_instance_rec.external_reference := p_instance_rec.external_reference;
2648: END IF;
2649: --

Line 2650: IF ( p_instance_rec.inventory_item_id = fnd_api.g_miss_num )

2646: THEN l_get_instance_rec.external_reference := l_curr_instance_rec.external_reference;
2647: ELSE l_get_instance_rec.external_reference := p_instance_rec.external_reference;
2648: END IF;
2649: --
2650: IF ( p_instance_rec.inventory_item_id = fnd_api.g_miss_num )
2651: THEN l_get_instance_rec.inventory_item_id := l_curr_instance_rec.inventory_item_id;
2652: ELSE l_get_instance_rec.inventory_item_id := p_instance_rec.inventory_item_id;
2653: END IF;
2654: --

Line 2655: IF ( p_instance_rec.inventory_revision = fnd_api.g_miss_char )

2651: THEN l_get_instance_rec.inventory_item_id := l_curr_instance_rec.inventory_item_id;
2652: ELSE l_get_instance_rec.inventory_item_id := p_instance_rec.inventory_item_id;
2653: END IF;
2654: --
2655: IF ( p_instance_rec.inventory_revision = fnd_api.g_miss_char )
2656: THEN l_get_instance_rec.inventory_revision := l_curr_instance_rec.inventory_revision;
2657: ELSE l_get_instance_rec.inventory_revision := p_instance_rec.inventory_revision;
2658: END IF;
2659: --

Line 2660: IF ( p_instance_rec.inv_master_organization_id = fnd_api.g_miss_num )

2656: THEN l_get_instance_rec.inventory_revision := l_curr_instance_rec.inventory_revision;
2657: ELSE l_get_instance_rec.inventory_revision := p_instance_rec.inventory_revision;
2658: END IF;
2659: --
2660: IF ( p_instance_rec.inv_master_organization_id = fnd_api.g_miss_num )
2661: THEN l_get_instance_rec.inv_master_organization_id := l_curr_instance_rec.inv_master_organization_id;
2662: ELSE l_get_instance_rec.inv_master_organization_id := p_instance_rec.inv_master_organization_id;
2663: END IF;
2664: --

Line 2665: IF ( p_instance_rec.serial_number = fnd_api.g_miss_char )

2661: THEN l_get_instance_rec.inv_master_organization_id := l_curr_instance_rec.inv_master_organization_id;
2662: ELSE l_get_instance_rec.inv_master_organization_id := p_instance_rec.inv_master_organization_id;
2663: END IF;
2664: --
2665: IF ( p_instance_rec.serial_number = fnd_api.g_miss_char )
2666: THEN l_get_instance_rec.serial_number := l_curr_instance_rec.serial_number;
2667: ELSE l_get_instance_rec.serial_number := p_instance_rec.serial_number;
2668: END IF;
2669: --

Line 2670: IF ( p_instance_rec.mfg_serial_number_flag = fnd_api.g_miss_char )

2666: THEN l_get_instance_rec.serial_number := l_curr_instance_rec.serial_number;
2667: ELSE l_get_instance_rec.serial_number := p_instance_rec.serial_number;
2668: END IF;
2669: --
2670: IF ( p_instance_rec.mfg_serial_number_flag = fnd_api.g_miss_char )
2671: THEN l_get_instance_rec.mfg_serial_number_flag := l_curr_instance_rec.mfg_serial_number_flag;
2672: ELSE l_get_instance_rec.mfg_serial_number_flag := p_instance_rec.mfg_serial_number_flag;
2673: END IF;
2674: --

Line 2675: IF ( p_instance_rec.lot_number = fnd_api.g_miss_char )

2671: THEN l_get_instance_rec.mfg_serial_number_flag := l_curr_instance_rec.mfg_serial_number_flag;
2672: ELSE l_get_instance_rec.mfg_serial_number_flag := p_instance_rec.mfg_serial_number_flag;
2673: END IF;
2674: --
2675: IF ( p_instance_rec.lot_number = fnd_api.g_miss_char )
2676: THEN l_get_instance_rec.lot_number := l_curr_instance_rec.lot_number;
2677: ELSE l_get_instance_rec.lot_number := p_instance_rec.lot_number;
2678: END IF;
2679: --

Line 2680: IF ( p_instance_rec.quantity = fnd_api.g_miss_num )

2676: THEN l_get_instance_rec.lot_number := l_curr_instance_rec.lot_number;
2677: ELSE l_get_instance_rec.lot_number := p_instance_rec.lot_number;
2678: END IF;
2679: --
2680: IF ( p_instance_rec.quantity = fnd_api.g_miss_num )
2681: THEN l_get_instance_rec.quantity := l_curr_instance_rec.quantity;
2682: ELSE l_get_instance_rec.quantity := p_instance_rec.quantity;
2683: END IF;
2684: --

Line 2685: IF ( p_instance_rec.unit_of_measure = fnd_api.g_miss_char )

2681: THEN l_get_instance_rec.quantity := l_curr_instance_rec.quantity;
2682: ELSE l_get_instance_rec.quantity := p_instance_rec.quantity;
2683: END IF;
2684: --
2685: IF ( p_instance_rec.unit_of_measure = fnd_api.g_miss_char )
2686: THEN l_get_instance_rec.unit_of_measure := l_curr_instance_rec.unit_of_measure;
2687: ELSE l_get_instance_rec.unit_of_measure := p_instance_rec.unit_of_measure;
2688: END IF;
2689: --

Line 2690: IF ( p_instance_rec.accounting_class_code = fnd_api.g_miss_char )

2686: THEN l_get_instance_rec.unit_of_measure := l_curr_instance_rec.unit_of_measure;
2687: ELSE l_get_instance_rec.unit_of_measure := p_instance_rec.unit_of_measure;
2688: END IF;
2689: --
2690: IF ( p_instance_rec.accounting_class_code = fnd_api.g_miss_char )
2691: THEN l_get_instance_rec.accounting_class_code := l_curr_instance_rec.accounting_class_code;
2692: ELSE l_get_instance_rec.accounting_class_code := p_instance_rec.accounting_class_code;
2693: END IF;
2694: --

Line 2695: IF ( p_instance_rec.instance_condition_id = fnd_api.g_miss_num )

2691: THEN l_get_instance_rec.accounting_class_code := l_curr_instance_rec.accounting_class_code;
2692: ELSE l_get_instance_rec.accounting_class_code := p_instance_rec.accounting_class_code;
2693: END IF;
2694: --
2695: IF ( p_instance_rec.instance_condition_id = fnd_api.g_miss_num )
2696: THEN l_get_instance_rec.instance_condition_id := l_curr_instance_rec.instance_condition_id;
2697: ELSE l_get_instance_rec.instance_condition_id := p_instance_rec.instance_condition_id;
2698: END IF;
2699: --

Line 2700: IF ( p_instance_rec.instance_status_id = fnd_api.g_miss_num )

2696: THEN l_get_instance_rec.instance_condition_id := l_curr_instance_rec.instance_condition_id;
2697: ELSE l_get_instance_rec.instance_condition_id := p_instance_rec.instance_condition_id;
2698: END IF;
2699: --
2700: IF ( p_instance_rec.instance_status_id = fnd_api.g_miss_num )
2701: THEN l_get_instance_rec.instance_status_id := l_curr_instance_rec.instance_status_id;
2702: ELSE l_get_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
2703: END IF;
2704: --

Line 2705: IF ( p_instance_rec.customer_view_flag = fnd_api.g_miss_char )

2701: THEN l_get_instance_rec.instance_status_id := l_curr_instance_rec.instance_status_id;
2702: ELSE l_get_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
2703: END IF;
2704: --
2705: IF ( p_instance_rec.customer_view_flag = fnd_api.g_miss_char )
2706: THEN l_get_instance_rec.customer_view_flag := l_curr_instance_rec.customer_view_flag;
2707: ELSE l_get_instance_rec.customer_view_flag := p_instance_rec.customer_view_flag;
2708: END IF;
2709: --

Line 2710: IF ( p_instance_rec.merchant_view_flag = fnd_api.g_miss_char )

2706: THEN l_get_instance_rec.customer_view_flag := l_curr_instance_rec.customer_view_flag;
2707: ELSE l_get_instance_rec.customer_view_flag := p_instance_rec.customer_view_flag;
2708: END IF;
2709: --
2710: IF ( p_instance_rec.merchant_view_flag = fnd_api.g_miss_char )
2711: THEN l_get_instance_rec.merchant_view_flag := l_curr_instance_rec.merchant_view_flag;
2712: ELSE l_get_instance_rec.merchant_view_flag := p_instance_rec.merchant_view_flag;
2713: END IF;
2714: --

Line 2715: IF ( p_instance_rec.sellable_flag = fnd_api.g_miss_char )

2711: THEN l_get_instance_rec.merchant_view_flag := l_curr_instance_rec.merchant_view_flag;
2712: ELSE l_get_instance_rec.merchant_view_flag := p_instance_rec.merchant_view_flag;
2713: END IF;
2714: --
2715: IF ( p_instance_rec.sellable_flag = fnd_api.g_miss_char )
2716: THEN l_get_instance_rec.sellable_flag := l_curr_instance_rec.sellable_flag;
2717: ELSE l_get_instance_rec.sellable_flag := p_instance_rec.sellable_flag;
2718: END IF;
2719: --

Line 2720: IF ( p_instance_rec.system_id = fnd_api.g_miss_num )

2716: THEN l_get_instance_rec.sellable_flag := l_curr_instance_rec.sellable_flag;
2717: ELSE l_get_instance_rec.sellable_flag := p_instance_rec.sellable_flag;
2718: END IF;
2719: --
2720: IF ( p_instance_rec.system_id = fnd_api.g_miss_num )
2721: THEN l_get_instance_rec.system_id := l_curr_instance_rec.system_id;
2722: ELSE l_get_instance_rec.system_id := p_instance_rec.system_id;
2723: END IF;
2724: --

Line 2725: IF ( p_instance_rec.instance_type_code = fnd_api.g_miss_char )

2721: THEN l_get_instance_rec.system_id := l_curr_instance_rec.system_id;
2722: ELSE l_get_instance_rec.system_id := p_instance_rec.system_id;
2723: END IF;
2724: --
2725: IF ( p_instance_rec.instance_type_code = fnd_api.g_miss_char )
2726: THEN l_get_instance_rec.instance_type_code := l_curr_instance_rec.instance_type_code;
2727: ELSE l_get_instance_rec.instance_type_code := p_instance_rec.instance_type_code;
2728: END IF;
2729: --

Line 2730: IF ( p_instance_rec.active_start_date = fnd_api.g_miss_date )

2726: THEN l_get_instance_rec.instance_type_code := l_curr_instance_rec.instance_type_code;
2727: ELSE l_get_instance_rec.instance_type_code := p_instance_rec.instance_type_code;
2728: END IF;
2729: --
2730: IF ( p_instance_rec.active_start_date = fnd_api.g_miss_date )
2731: THEN l_get_instance_rec.active_start_date := l_curr_instance_rec.active_start_date;
2732: ELSE l_get_instance_rec.active_start_date := p_instance_rec.active_start_date;
2733: END IF;
2734: --

Line 2735: IF ( p_instance_rec.active_end_date = fnd_api.g_miss_date )

2731: THEN l_get_instance_rec.active_start_date := l_curr_instance_rec.active_start_date;
2732: ELSE l_get_instance_rec.active_start_date := p_instance_rec.active_start_date;
2733: END IF;
2734: --
2735: IF ( p_instance_rec.active_end_date = fnd_api.g_miss_date )
2736: THEN l_get_instance_rec.active_end_date := l_curr_instance_rec.active_end_date;
2737: ELSE l_get_instance_rec.active_end_date := p_instance_rec.active_end_date;
2738: END IF;
2739: --

Line 2740: IF ( p_instance_rec.location_type_code = fnd_api.g_miss_char )

2736: THEN l_get_instance_rec.active_end_date := l_curr_instance_rec.active_end_date;
2737: ELSE l_get_instance_rec.active_end_date := p_instance_rec.active_end_date;
2738: END IF;
2739: --
2740: IF ( p_instance_rec.location_type_code = fnd_api.g_miss_char )
2741: THEN l_get_instance_rec.location_type_code := l_curr_instance_rec.location_type_code;
2742: ELSE l_get_instance_rec.location_type_code := p_instance_rec.location_type_code;
2743: END IF;
2744: --

Line 2745: IF ( p_instance_rec.location_id = fnd_api.g_miss_num )

2741: THEN l_get_instance_rec.location_type_code := l_curr_instance_rec.location_type_code;
2742: ELSE l_get_instance_rec.location_type_code := p_instance_rec.location_type_code;
2743: END IF;
2744: --
2745: IF ( p_instance_rec.location_id = fnd_api.g_miss_num )
2746: THEN l_get_instance_rec.location_id := l_curr_instance_rec.location_id;
2747: ELSE l_get_instance_rec.location_id := p_instance_rec.location_id;
2748: END IF;
2749: --

Line 2750: IF ( p_instance_rec.inv_organization_id = fnd_api.g_miss_num )

2746: THEN l_get_instance_rec.location_id := l_curr_instance_rec.location_id;
2747: ELSE l_get_instance_rec.location_id := p_instance_rec.location_id;
2748: END IF;
2749: --
2750: IF ( p_instance_rec.inv_organization_id = fnd_api.g_miss_num )
2751: THEN l_get_instance_rec.inv_organization_id := l_curr_instance_rec.inv_organization_id;
2752: ELSE l_get_instance_rec.inv_organization_id := p_instance_rec.inv_organization_id;
2753: END IF;
2754: --

Line 2755: IF ( p_instance_rec.inv_subinventory_name = fnd_api.g_miss_char )

2751: THEN l_get_instance_rec.inv_organization_id := l_curr_instance_rec.inv_organization_id;
2752: ELSE l_get_instance_rec.inv_organization_id := p_instance_rec.inv_organization_id;
2753: END IF;
2754: --
2755: IF ( p_instance_rec.inv_subinventory_name = fnd_api.g_miss_char )
2756: THEN l_get_instance_rec.inv_subinventory_name := l_curr_instance_rec.inv_subinventory_name;
2757: ELSE l_get_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;
2758: END IF;
2759: --

Line 2760: IF ( p_instance_rec.inv_locator_id = fnd_api.g_miss_num )

2756: THEN l_get_instance_rec.inv_subinventory_name := l_curr_instance_rec.inv_subinventory_name;
2757: ELSE l_get_instance_rec.inv_subinventory_name := p_instance_rec.inv_subinventory_name;
2758: END IF;
2759: --
2760: IF ( p_instance_rec.inv_locator_id = fnd_api.g_miss_num )
2761: THEN l_get_instance_rec.inv_locator_id := l_curr_instance_rec.inv_locator_id;
2762: ELSE l_get_instance_rec.inv_locator_id := p_instance_rec.inv_locator_id;
2763: END IF;
2764: --

Line 2765: IF ( p_instance_rec.pa_project_id = fnd_api.g_miss_num )

2761: THEN l_get_instance_rec.inv_locator_id := l_curr_instance_rec.inv_locator_id;
2762: ELSE l_get_instance_rec.inv_locator_id := p_instance_rec.inv_locator_id;
2763: END IF;
2764: --
2765: IF ( p_instance_rec.pa_project_id = fnd_api.g_miss_num )
2766: THEN l_get_instance_rec.pa_project_id := l_curr_instance_rec.pa_project_id;
2767: ELSE l_get_instance_rec.pa_project_id := p_instance_rec.pa_project_id;
2768: END IF;
2769: --

Line 2770: IF ( p_instance_rec.pa_project_task_id = fnd_api.g_miss_num )

2766: THEN l_get_instance_rec.pa_project_id := l_curr_instance_rec.pa_project_id;
2767: ELSE l_get_instance_rec.pa_project_id := p_instance_rec.pa_project_id;
2768: END IF;
2769: --
2770: IF ( p_instance_rec.pa_project_task_id = fnd_api.g_miss_num )
2771: THEN l_get_instance_rec.pa_project_task_id := l_curr_instance_rec.pa_project_task_id;
2772: ELSE l_get_instance_rec.pa_project_task_id := p_instance_rec.pa_project_task_id;
2773: END IF;
2774: --

Line 2775: IF ( p_instance_rec.in_transit_order_line_id = fnd_api.g_miss_num )

2771: THEN l_get_instance_rec.pa_project_task_id := l_curr_instance_rec.pa_project_task_id;
2772: ELSE l_get_instance_rec.pa_project_task_id := p_instance_rec.pa_project_task_id;
2773: END IF;
2774: --
2775: IF ( p_instance_rec.in_transit_order_line_id = fnd_api.g_miss_num )
2776: THEN l_get_instance_rec.in_transit_order_line_id := l_curr_instance_rec.in_transit_order_line_id;
2777: ELSE l_get_instance_rec.in_transit_order_line_id := p_instance_rec.in_transit_order_line_id;
2778: END IF;
2779: --

Line 2780: IF ( p_instance_rec.wip_job_id = fnd_api.g_miss_num )

2776: THEN l_get_instance_rec.in_transit_order_line_id := l_curr_instance_rec.in_transit_order_line_id;
2777: ELSE l_get_instance_rec.in_transit_order_line_id := p_instance_rec.in_transit_order_line_id;
2778: END IF;
2779: --
2780: IF ( p_instance_rec.wip_job_id = fnd_api.g_miss_num )
2781: THEN l_get_instance_rec.wip_job_id := l_curr_instance_rec.wip_job_id;
2782: ELSE l_get_instance_rec.wip_job_id := p_instance_rec.wip_job_id;
2783: END IF;
2784: --

Line 2785: IF ( p_instance_rec.po_order_line_id = fnd_api.g_miss_num )

2781: THEN l_get_instance_rec.wip_job_id := l_curr_instance_rec.wip_job_id;
2782: ELSE l_get_instance_rec.wip_job_id := p_instance_rec.wip_job_id;
2783: END IF;
2784: --
2785: IF ( p_instance_rec.po_order_line_id = fnd_api.g_miss_num )
2786: THEN l_get_instance_rec.po_order_line_id := l_curr_instance_rec.po_order_line_id;
2787: ELSE l_get_instance_rec.po_order_line_id := p_instance_rec.po_order_line_id;
2788: END IF;
2789: --

Line 2790: IF ( p_instance_rec.last_oe_order_line_id = fnd_api.g_miss_num )

2786: THEN l_get_instance_rec.po_order_line_id := l_curr_instance_rec.po_order_line_id;
2787: ELSE l_get_instance_rec.po_order_line_id := p_instance_rec.po_order_line_id;
2788: END IF;
2789: --
2790: IF ( p_instance_rec.last_oe_order_line_id = fnd_api.g_miss_num )
2791: THEN l_get_instance_rec.last_oe_order_line_id := l_curr_instance_rec.last_oe_order_line_id;
2792: ELSE l_get_instance_rec.last_oe_order_line_id := p_instance_rec.last_oe_order_line_id;
2793: END IF;
2794: --

Line 2795: IF ( p_instance_rec.last_oe_rma_line_id = fnd_api.g_miss_num )

2791: THEN l_get_instance_rec.last_oe_order_line_id := l_curr_instance_rec.last_oe_order_line_id;
2792: ELSE l_get_instance_rec.last_oe_order_line_id := p_instance_rec.last_oe_order_line_id;
2793: END IF;
2794: --
2795: IF ( p_instance_rec.last_oe_rma_line_id = fnd_api.g_miss_num )
2796: THEN l_get_instance_rec.last_oe_rma_line_id := l_curr_instance_rec.last_oe_rma_line_id;
2797: ELSE l_get_instance_rec.last_oe_rma_line_id := p_instance_rec.last_oe_rma_line_id;
2798: END IF;
2799: --

Line 2800: IF ( p_instance_rec.last_po_po_line_id = fnd_api.g_miss_num )

2796: THEN l_get_instance_rec.last_oe_rma_line_id := l_curr_instance_rec.last_oe_rma_line_id;
2797: ELSE l_get_instance_rec.last_oe_rma_line_id := p_instance_rec.last_oe_rma_line_id;
2798: END IF;
2799: --
2800: IF ( p_instance_rec.last_po_po_line_id = fnd_api.g_miss_num )
2801: THEN l_get_instance_rec.last_po_po_line_id := l_curr_instance_rec.last_po_po_line_id;
2802: ELSE l_get_instance_rec.last_po_po_line_id := p_instance_rec.last_po_po_line_id;
2803: END IF;
2804: --

Line 2805: IF ( p_instance_rec.last_oe_po_number = fnd_api.g_miss_char )

2801: THEN l_get_instance_rec.last_po_po_line_id := l_curr_instance_rec.last_po_po_line_id;
2802: ELSE l_get_instance_rec.last_po_po_line_id := p_instance_rec.last_po_po_line_id;
2803: END IF;
2804: --
2805: IF ( p_instance_rec.last_oe_po_number = fnd_api.g_miss_char )
2806: THEN l_get_instance_rec.last_oe_po_number := l_curr_instance_rec.last_oe_po_number;
2807: ELSE l_get_instance_rec.last_oe_po_number := p_instance_rec.last_oe_po_number;
2808: END IF;
2809: --

Line 2810: IF ( p_instance_rec.last_wip_job_id = fnd_api.g_miss_num )

2806: THEN l_get_instance_rec.last_oe_po_number := l_curr_instance_rec.last_oe_po_number;
2807: ELSE l_get_instance_rec.last_oe_po_number := p_instance_rec.last_oe_po_number;
2808: END IF;
2809: --
2810: IF ( p_instance_rec.last_wip_job_id = fnd_api.g_miss_num )
2811: THEN l_get_instance_rec.last_wip_job_id := l_curr_instance_rec.last_wip_job_id;
2812: ELSE l_get_instance_rec.last_wip_job_id := p_instance_rec.last_wip_job_id;
2813: END IF;
2814: --

Line 2815: IF ( p_instance_rec.last_pa_project_id = fnd_api.g_miss_num )

2811: THEN l_get_instance_rec.last_wip_job_id := l_curr_instance_rec.last_wip_job_id;
2812: ELSE l_get_instance_rec.last_wip_job_id := p_instance_rec.last_wip_job_id;
2813: END IF;
2814: --
2815: IF ( p_instance_rec.last_pa_project_id = fnd_api.g_miss_num )
2816: THEN l_get_instance_rec.last_pa_project_id := l_curr_instance_rec.last_pa_project_id;
2817: ELSE l_get_instance_rec.last_pa_project_id := p_instance_rec.last_pa_project_id;
2818: END IF;
2819: --

Line 2820: IF ( p_instance_rec.last_pa_task_id = fnd_api.g_miss_num )

2816: THEN l_get_instance_rec.last_pa_project_id := l_curr_instance_rec.last_pa_project_id;
2817: ELSE l_get_instance_rec.last_pa_project_id := p_instance_rec.last_pa_project_id;
2818: END IF;
2819: --
2820: IF ( p_instance_rec.last_pa_task_id = fnd_api.g_miss_num )
2821: THEN l_get_instance_rec.last_pa_task_id := l_curr_instance_rec.last_pa_task_id;
2822: ELSE l_get_instance_rec.last_pa_task_id := p_instance_rec.last_pa_task_id;
2823: END IF;
2824: --

Line 2825: IF ( p_instance_rec.last_oe_agreement_id = fnd_api.g_miss_num )

2821: THEN l_get_instance_rec.last_pa_task_id := l_curr_instance_rec.last_pa_task_id;
2822: ELSE l_get_instance_rec.last_pa_task_id := p_instance_rec.last_pa_task_id;
2823: END IF;
2824: --
2825: IF ( p_instance_rec.last_oe_agreement_id = fnd_api.g_miss_num )
2826: THEN l_get_instance_rec.last_oe_agreement_id := l_curr_instance_rec.last_oe_agreement_id;
2827: ELSE l_get_instance_rec.last_oe_agreement_id := p_instance_rec.last_oe_agreement_id;
2828: END IF;
2829: --

Line 2830: IF ( p_instance_rec.install_date = fnd_api.g_miss_date )

2826: THEN l_get_instance_rec.last_oe_agreement_id := l_curr_instance_rec.last_oe_agreement_id;
2827: ELSE l_get_instance_rec.last_oe_agreement_id := p_instance_rec.last_oe_agreement_id;
2828: END IF;
2829: --
2830: IF ( p_instance_rec.install_date = fnd_api.g_miss_date )
2831: THEN l_get_instance_rec.install_date := l_curr_instance_rec.install_date;
2832: ELSE l_get_instance_rec.install_date := p_instance_rec.install_date;
2833: END IF;
2834: --

Line 2835: IF ( p_instance_rec.manually_created_flag = fnd_api.g_miss_char )

2831: THEN l_get_instance_rec.install_date := l_curr_instance_rec.install_date;
2832: ELSE l_get_instance_rec.install_date := p_instance_rec.install_date;
2833: END IF;
2834: --
2835: IF ( p_instance_rec.manually_created_flag = fnd_api.g_miss_char )
2836: THEN l_get_instance_rec.manually_created_flag := l_curr_instance_rec.manually_created_flag;
2837: ELSE l_get_instance_rec.manually_created_flag := p_instance_rec.manually_created_flag;
2838: END IF;
2839: --

Line 2840: IF ( p_instance_rec.return_by_date = fnd_api.g_miss_date )

2836: THEN l_get_instance_rec.manually_created_flag := l_curr_instance_rec.manually_created_flag;
2837: ELSE l_get_instance_rec.manually_created_flag := p_instance_rec.manually_created_flag;
2838: END IF;
2839: --
2840: IF ( p_instance_rec.return_by_date = fnd_api.g_miss_date )
2841: THEN l_get_instance_rec.return_by_date := l_curr_instance_rec.return_by_date;
2842: ELSE l_get_instance_rec.return_by_date := p_instance_rec.return_by_date;
2843: END IF;
2844: --

Line 2845: IF ( p_instance_rec.actual_return_date = fnd_api.g_miss_date )

2841: THEN l_get_instance_rec.return_by_date := l_curr_instance_rec.return_by_date;
2842: ELSE l_get_instance_rec.return_by_date := p_instance_rec.return_by_date;
2843: END IF;
2844: --
2845: IF ( p_instance_rec.actual_return_date = fnd_api.g_miss_date )
2846: THEN l_get_instance_rec.actual_return_date := l_curr_instance_rec.actual_return_date;
2847: ELSE l_get_instance_rec.actual_return_date := p_instance_rec.actual_return_date;
2848: END IF;
2849: --

Line 2850: IF ( p_instance_rec.creation_complete_flag = fnd_api.g_miss_char )

2846: THEN l_get_instance_rec.actual_return_date := l_curr_instance_rec.actual_return_date;
2847: ELSE l_get_instance_rec.actual_return_date := p_instance_rec.actual_return_date;
2848: END IF;
2849: --
2850: IF ( p_instance_rec.creation_complete_flag = fnd_api.g_miss_char )
2851: THEN l_get_instance_rec.creation_complete_flag := l_curr_instance_rec.creation_complete_flag;
2852: ELSE l_get_instance_rec.creation_complete_flag := p_instance_rec.creation_complete_flag;
2853: END IF;
2854: --

Line 2855: IF ( p_instance_rec.completeness_flag = fnd_api.g_miss_char )

2851: THEN l_get_instance_rec.creation_complete_flag := l_curr_instance_rec.creation_complete_flag;
2852: ELSE l_get_instance_rec.creation_complete_flag := p_instance_rec.creation_complete_flag;
2853: END IF;
2854: --
2855: IF ( p_instance_rec.completeness_flag = fnd_api.g_miss_char )
2856: THEN l_get_instance_rec.completeness_flag := l_curr_instance_rec.completeness_flag;
2857: ELSE l_get_instance_rec.completeness_flag := p_instance_rec.completeness_flag;
2858: END IF;
2859: --

Line 2860: IF ( p_instance_rec.context = fnd_api.g_miss_char )

2856: THEN l_get_instance_rec.completeness_flag := l_curr_instance_rec.completeness_flag;
2857: ELSE l_get_instance_rec.completeness_flag := p_instance_rec.completeness_flag;
2858: END IF;
2859: --
2860: IF ( p_instance_rec.context = fnd_api.g_miss_char )
2861: THEN l_get_instance_rec.context := l_curr_instance_rec.context;
2862: ELSE l_get_instance_rec.context := p_instance_rec.context;
2863: END IF;
2864: --

Line 2865: IF ( p_instance_rec.attribute1 = fnd_api.g_miss_char )

2861: THEN l_get_instance_rec.context := l_curr_instance_rec.context;
2862: ELSE l_get_instance_rec.context := p_instance_rec.context;
2863: END IF;
2864: --
2865: IF ( p_instance_rec.attribute1 = fnd_api.g_miss_char )
2866: THEN l_get_instance_rec.attribute1 := l_curr_instance_rec.attribute1;
2867: ELSE l_get_instance_rec.attribute1 := p_instance_rec.attribute1;
2868: END IF;
2869: --

Line 2870: IF ( p_instance_rec.attribute2 = fnd_api.g_miss_char )

2866: THEN l_get_instance_rec.attribute1 := l_curr_instance_rec.attribute1;
2867: ELSE l_get_instance_rec.attribute1 := p_instance_rec.attribute1;
2868: END IF;
2869: --
2870: IF ( p_instance_rec.attribute2 = fnd_api.g_miss_char )
2871: THEN l_get_instance_rec.attribute2 := l_curr_instance_rec.attribute2;
2872: ELSE l_get_instance_rec.attribute2 := p_instance_rec.attribute2;
2873: END IF;
2874: --

Line 2875: IF ( p_instance_rec.attribute3 = fnd_api.g_miss_char )

2871: THEN l_get_instance_rec.attribute2 := l_curr_instance_rec.attribute2;
2872: ELSE l_get_instance_rec.attribute2 := p_instance_rec.attribute2;
2873: END IF;
2874: --
2875: IF ( p_instance_rec.attribute3 = fnd_api.g_miss_char )
2876: THEN l_get_instance_rec.attribute3 := l_curr_instance_rec.attribute3;
2877: ELSE l_get_instance_rec.attribute3 := p_instance_rec.attribute3;
2878: END IF;
2879: --

Line 2880: IF ( p_instance_rec.attribute4 = fnd_api.g_miss_char )

2876: THEN l_get_instance_rec.attribute3 := l_curr_instance_rec.attribute3;
2877: ELSE l_get_instance_rec.attribute3 := p_instance_rec.attribute3;
2878: END IF;
2879: --
2880: IF ( p_instance_rec.attribute4 = fnd_api.g_miss_char )
2881: THEN l_get_instance_rec.attribute4 := l_curr_instance_rec.attribute4;
2882: ELSE l_get_instance_rec.attribute4 := p_instance_rec.attribute4;
2883: END IF;
2884: --

Line 2885: IF ( p_instance_rec.attribute5 = fnd_api.g_miss_char )

2881: THEN l_get_instance_rec.attribute4 := l_curr_instance_rec.attribute4;
2882: ELSE l_get_instance_rec.attribute4 := p_instance_rec.attribute4;
2883: END IF;
2884: --
2885: IF ( p_instance_rec.attribute5 = fnd_api.g_miss_char )
2886: THEN l_get_instance_rec.attribute5 := l_curr_instance_rec.attribute5;
2887: ELSE l_get_instance_rec.attribute5 := p_instance_rec.attribute5;
2888: END IF;
2889: --

Line 2890: IF ( p_instance_rec.attribute6 = fnd_api.g_miss_char )

2886: THEN l_get_instance_rec.attribute5 := l_curr_instance_rec.attribute5;
2887: ELSE l_get_instance_rec.attribute5 := p_instance_rec.attribute5;
2888: END IF;
2889: --
2890: IF ( p_instance_rec.attribute6 = fnd_api.g_miss_char )
2891: THEN l_get_instance_rec.attribute6 := l_curr_instance_rec.attribute6;
2892: ELSE l_get_instance_rec.attribute6 := p_instance_rec.attribute6;
2893: END IF;
2894: --

Line 2895: IF ( p_instance_rec.attribute7 = fnd_api.g_miss_char )

2891: THEN l_get_instance_rec.attribute6 := l_curr_instance_rec.attribute6;
2892: ELSE l_get_instance_rec.attribute6 := p_instance_rec.attribute6;
2893: END IF;
2894: --
2895: IF ( p_instance_rec.attribute7 = fnd_api.g_miss_char )
2896: THEN l_get_instance_rec.attribute7 := l_curr_instance_rec.attribute7;
2897: ELSE l_get_instance_rec.attribute7 := p_instance_rec.attribute7;
2898: END IF;
2899: --

Line 2900: IF ( p_instance_rec.attribute8 = fnd_api.g_miss_char )

2896: THEN l_get_instance_rec.attribute7 := l_curr_instance_rec.attribute7;
2897: ELSE l_get_instance_rec.attribute7 := p_instance_rec.attribute7;
2898: END IF;
2899: --
2900: IF ( p_instance_rec.attribute8 = fnd_api.g_miss_char )
2901: THEN l_get_instance_rec.attribute8 := l_curr_instance_rec.attribute8;
2902: ELSE l_get_instance_rec.attribute8 := p_instance_rec.attribute8;
2903: END IF;
2904: --

Line 2905: IF ( p_instance_rec.attribute9 = fnd_api.g_miss_char )

2901: THEN l_get_instance_rec.attribute8 := l_curr_instance_rec.attribute8;
2902: ELSE l_get_instance_rec.attribute8 := p_instance_rec.attribute8;
2903: END IF;
2904: --
2905: IF ( p_instance_rec.attribute9 = fnd_api.g_miss_char )
2906: THEN l_get_instance_rec.attribute9 := l_curr_instance_rec.attribute9;
2907: ELSE l_get_instance_rec.attribute9 := p_instance_rec.attribute9;
2908: END IF;
2909: --

Line 2910: IF ( p_instance_rec.attribute10 = fnd_api.g_miss_char )

2906: THEN l_get_instance_rec.attribute9 := l_curr_instance_rec.attribute9;
2907: ELSE l_get_instance_rec.attribute9 := p_instance_rec.attribute9;
2908: END IF;
2909: --
2910: IF ( p_instance_rec.attribute10 = fnd_api.g_miss_char )
2911: THEN l_get_instance_rec.attribute10 := l_curr_instance_rec.attribute10;
2912: ELSE l_get_instance_rec.attribute10 := p_instance_rec.attribute10;
2913: END IF;
2914: --

Line 2915: IF ( p_instance_rec.attribute11 = fnd_api.g_miss_char )

2911: THEN l_get_instance_rec.attribute10 := l_curr_instance_rec.attribute10;
2912: ELSE l_get_instance_rec.attribute10 := p_instance_rec.attribute10;
2913: END IF;
2914: --
2915: IF ( p_instance_rec.attribute11 = fnd_api.g_miss_char )
2916: THEN l_get_instance_rec.attribute11 := l_curr_instance_rec.attribute11;
2917: ELSE l_get_instance_rec.attribute11 := p_instance_rec.attribute11;
2918: END IF;
2919: --

Line 2920: IF ( p_instance_rec.attribute12 = fnd_api.g_miss_char )

2916: THEN l_get_instance_rec.attribute11 := l_curr_instance_rec.attribute11;
2917: ELSE l_get_instance_rec.attribute11 := p_instance_rec.attribute11;
2918: END IF;
2919: --
2920: IF ( p_instance_rec.attribute12 = fnd_api.g_miss_char )
2921: THEN l_get_instance_rec.attribute12 := l_curr_instance_rec.attribute12;
2922: ELSE l_get_instance_rec.attribute12 := p_instance_rec.attribute12;
2923: END IF;
2924: --

Line 2925: IF ( p_instance_rec.attribute13 = fnd_api.g_miss_char )

2921: THEN l_get_instance_rec.attribute12 := l_curr_instance_rec.attribute12;
2922: ELSE l_get_instance_rec.attribute12 := p_instance_rec.attribute12;
2923: END IF;
2924: --
2925: IF ( p_instance_rec.attribute13 = fnd_api.g_miss_char )
2926: THEN l_get_instance_rec.attribute13 := l_curr_instance_rec.attribute13;
2927: ELSE l_get_instance_rec.attribute13 := p_instance_rec.attribute13;
2928: END IF;
2929: --

Line 2930: IF ( p_instance_rec.attribute14 = fnd_api.g_miss_char )

2926: THEN l_get_instance_rec.attribute13 := l_curr_instance_rec.attribute13;
2927: ELSE l_get_instance_rec.attribute13 := p_instance_rec.attribute13;
2928: END IF;
2929: --
2930: IF ( p_instance_rec.attribute14 = fnd_api.g_miss_char )
2931: THEN l_get_instance_rec.attribute14 := l_curr_instance_rec.attribute14;
2932: ELSE l_get_instance_rec.attribute14 := p_instance_rec.attribute14;
2933: END IF;
2934: --

Line 2935: IF ( p_instance_rec.attribute15 = fnd_api.g_miss_char )

2931: THEN l_get_instance_rec.attribute14 := l_curr_instance_rec.attribute14;
2932: ELSE l_get_instance_rec.attribute14 := p_instance_rec.attribute14;
2933: END IF;
2934: --
2935: IF ( p_instance_rec.attribute15 = fnd_api.g_miss_char )
2936: THEN l_get_instance_rec.attribute15 := l_curr_instance_rec.attribute15;
2937: ELSE l_get_instance_rec.attribute15 := p_instance_rec.attribute15;
2938: END IF;
2939: --

Line 2940: IF ( p_instance_rec.object_version_number = fnd_api.g_miss_num )

2936: THEN l_get_instance_rec.attribute15 := l_curr_instance_rec.attribute15;
2937: ELSE l_get_instance_rec.attribute15 := p_instance_rec.attribute15;
2938: END IF;
2939: --
2940: IF ( p_instance_rec.object_version_number = fnd_api.g_miss_num )
2941: THEN l_get_instance_rec.object_version_number := l_curr_instance_rec.object_version_number;
2942: ELSE l_get_instance_rec.object_version_number := p_instance_rec.object_version_number;
2943: END IF;
2944: --

Line 2945: IF ( p_instance_rec.last_txn_line_detail_id = fnd_api.g_miss_num )

2941: THEN l_get_instance_rec.object_version_number := l_curr_instance_rec.object_version_number;
2942: ELSE l_get_instance_rec.object_version_number := p_instance_rec.object_version_number;
2943: END IF;
2944: --
2945: IF ( p_instance_rec.last_txn_line_detail_id = fnd_api.g_miss_num )
2946: THEN l_get_instance_rec.last_txn_line_detail_id := l_curr_instance_rec.last_txn_line_detail_id;
2947: ELSE l_get_instance_rec.last_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
2948: END IF;
2949: --

Line 2950: IF ( p_instance_rec.install_location_type_code = fnd_api.g_miss_char )

2946: THEN l_get_instance_rec.last_txn_line_detail_id := l_curr_instance_rec.last_txn_line_detail_id;
2947: ELSE l_get_instance_rec.last_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
2948: END IF;
2949: --
2950: IF ( p_instance_rec.install_location_type_code = fnd_api.g_miss_char )
2951: THEN l_get_instance_rec.install_location_type_code := l_curr_instance_rec.install_location_type_code;
2952: ELSE l_get_instance_rec.install_location_type_code := p_instance_rec.install_location_type_code;
2953: END IF;
2954: --

Line 2955: IF ( p_instance_rec.install_location_id = fnd_api.g_miss_num )

2951: THEN l_get_instance_rec.install_location_type_code := l_curr_instance_rec.install_location_type_code;
2952: ELSE l_get_instance_rec.install_location_type_code := p_instance_rec.install_location_type_code;
2953: END IF;
2954: --
2955: IF ( p_instance_rec.install_location_id = fnd_api.g_miss_num )
2956: THEN l_get_instance_rec.install_location_id := l_curr_instance_rec.install_location_id;
2957: ELSE l_get_instance_rec.install_location_id := p_instance_rec.install_location_id;
2958: END IF;
2959: --

Line 2960: IF ( p_instance_rec.instance_usage_code = fnd_api.g_miss_char )

2956: THEN l_get_instance_rec.install_location_id := l_curr_instance_rec.install_location_id;
2957: ELSE l_get_instance_rec.install_location_id := p_instance_rec.install_location_id;
2958: END IF;
2959: --
2960: IF ( p_instance_rec.instance_usage_code = fnd_api.g_miss_char )
2961: THEN l_get_instance_rec.instance_usage_code := l_curr_instance_rec.instance_usage_code;
2962: ELSE l_get_instance_rec.instance_usage_code := p_instance_rec.instance_usage_code;
2963: END IF;
2964: --

Line 2966: /* IF ( p_instance_rec.vld_organization_id = fnd_api.g_miss_num )

2962: ELSE l_get_instance_rec.instance_usage_code := p_instance_rec.instance_usage_code;
2963: END IF;
2964: --
2965:
2966: /* IF ( p_instance_rec.vld_organization_id = fnd_api.g_miss_num )
2967: THEN l_get_instance_rec.vld_organization_id := l_curr_instance_rec.last_vld_organization_id;
2968: ELSE l_get_instance_rec.vld_organization_id := p_instance_rec.vld_organization_id;
2969: END IF;
2970: --

Line 2973: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR

2969: END IF;
2970: --
2971: */
2972:
2973: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2974: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2975: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR

Line 2974: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR

2970: --
2971: */
2972:
2973: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2974: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2975: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR

Line 2975: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR

2971: */
2972:
2973: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2974: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2975: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR

Line 2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR

2972:
2973: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2974: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2975: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2980: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR

Line 2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR

2973: IF ( (p_instance_rec.location_type_code <> FND_API.G_MISS_CHAR) OR
2974: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2975: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2980: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2981: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR

Line 2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR

2974: (p_instance_rec.location_id <> FND_API.G_MISS_NUM) OR
2975: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2980: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2981: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2982: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)

Line 2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR

2975: (p_instance_rec.inv_organization_id <> FND_API.G_MISS_NUM) OR
2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2980: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2981: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2982: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2983: ) THEN

Line 2980: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR

2976: (p_instance_rec.inv_subinventory_name <> FND_API.G_MISS_CHAR) OR
2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2980: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2981: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2982: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2983: ) THEN
2984:

Line 2981: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR

2977: (p_instance_rec.inv_locator_id <> FND_API.G_MISS_NUM) OR
2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2980: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2981: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2982: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2983: ) THEN
2984:
2985: IF l_get_instance_rec.location_type_code = 'INVENTORY' THEN

Line 2982: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)

2978: (p_instance_rec.pa_project_id <> FND_API.G_MISS_NUM) OR
2979: (p_instance_rec.pa_project_task_id <> FND_API.G_MISS_NUM) OR
2980: (p_instance_rec.in_transit_order_line_id <> FND_API.G_MISS_NUM) OR
2981: (p_instance_rec.wip_job_id <> FND_API.G_MISS_NUM) OR
2982: (p_instance_rec.po_order_line_id <> FND_API.G_MISS_NUM)
2983: ) THEN
2984:
2985: IF l_get_instance_rec.location_type_code = 'INVENTORY' THEN
2986:

Line 2987: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

2983: ) THEN
2984:
2985: IF l_get_instance_rec.location_type_code = 'INVENTORY' THEN
2986:
2987: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
2988: p_instance_rec.pa_project_id := NULL;
2989: l_get_instance_rec.pa_project_id := NULL;
2990: END IF;
2991: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

Line 2991: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

2987: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
2988: p_instance_rec.pa_project_id := NULL;
2989: l_get_instance_rec.pa_project_id := NULL;
2990: END IF;
2991: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
2992: p_instance_rec.pa_project_task_id := NULL;
2993: l_get_instance_rec.pa_project_task_id := NULL;
2994: END IF;
2995: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

Line 2995: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

2991: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
2992: p_instance_rec.pa_project_task_id := NULL;
2993: l_get_instance_rec.pa_project_task_id := NULL;
2994: END IF;
2995: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
2996: p_instance_rec.wip_job_id := NULL;
2997: l_get_instance_rec.wip_job_id := NULL;
2998: END IF;
2999: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

Line 2999: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

2995: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
2996: p_instance_rec.wip_job_id := NULL;
2997: l_get_instance_rec.wip_job_id := NULL;
2998: END IF;
2999: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3000: p_instance_rec.in_transit_order_line_id := NULL;
3001: l_get_instance_rec.in_transit_order_line_id := NULL;
3002: END IF;
3003: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

Line 3003: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

2999: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3000: p_instance_rec.in_transit_order_line_id := NULL;
3001: l_get_instance_rec.in_transit_order_line_id := NULL;
3002: END IF;
3003: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3004: p_instance_rec.po_order_line_id := NULL;
3005: l_get_instance_rec.po_order_line_id := NULL;
3006: END IF;
3007:

Line 3012: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN

3008: ELSIF
3009:
3010: l_get_instance_rec.location_type_code = 'PROJECT' THEN
3011:
3012: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3013: p_instance_rec.inv_organization_id := NULL;
3014: l_get_instance_rec.inv_organization_id := NULL;
3015: END IF;
3016: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

Line 3016: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

3012: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3013: p_instance_rec.inv_organization_id := NULL;
3014: l_get_instance_rec.inv_organization_id := NULL;
3015: END IF;
3016: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3017: p_instance_rec.inv_subinventory_name := NULL;
3018: l_get_instance_rec.inv_subinventory_name := NULL;
3019: END IF;
3020: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

Line 3020: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

3016: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3017: p_instance_rec.inv_subinventory_name := NULL;
3018: l_get_instance_rec.inv_subinventory_name := NULL;
3019: END IF;
3020: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3021: p_instance_rec.inv_locator_id := NULL;
3022: l_get_instance_rec.inv_locator_id := NULL;
3023: END IF;
3024: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

Line 3024: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

3020: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3021: p_instance_rec.inv_locator_id := NULL;
3022: l_get_instance_rec.inv_locator_id := NULL;
3023: END IF;
3024: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3025: p_instance_rec.wip_job_id := NULL;
3026: l_get_instance_rec.wip_job_id := NULL;
3027: END IF;
3028: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

Line 3028: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

3024: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3025: p_instance_rec.wip_job_id := NULL;
3026: l_get_instance_rec.wip_job_id := NULL;
3027: END IF;
3028: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3029: p_instance_rec.in_transit_order_line_id := NULL;
3030: l_get_instance_rec.in_transit_order_line_id := NULL;
3031: END IF;
3032: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

Line 3032: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

3028: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3029: p_instance_rec.in_transit_order_line_id := NULL;
3030: l_get_instance_rec.in_transit_order_line_id := NULL;
3031: END IF;
3032: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3033: p_instance_rec.po_order_line_id := NULL;
3034: l_get_instance_rec.po_order_line_id := NULL;
3035: END IF;
3036:

Line 3041: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN

3037: ELSIF
3038:
3039: l_get_instance_rec.location_type_code = 'WIP' THEN
3040:
3041: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3042: p_instance_rec.inv_organization_id := NULL;
3043: l_get_instance_rec.inv_organization_id := NULL;
3044: END IF;
3045: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

Line 3045: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

3041: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3042: p_instance_rec.inv_organization_id := NULL;
3043: l_get_instance_rec.inv_organization_id := NULL;
3044: END IF;
3045: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3046: p_instance_rec.inv_subinventory_name := NULL;
3047: l_get_instance_rec.inv_subinventory_name := NULL;
3048: END IF;
3049: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

Line 3049: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

3045: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3046: p_instance_rec.inv_subinventory_name := NULL;
3047: l_get_instance_rec.inv_subinventory_name := NULL;
3048: END IF;
3049: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3050: p_instance_rec.inv_locator_id := NULL;
3051: l_get_instance_rec.inv_locator_id := NULL;
3052: END IF;
3053: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

Line 3053: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

3049: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3050: p_instance_rec.inv_locator_id := NULL;
3051: l_get_instance_rec.inv_locator_id := NULL;
3052: END IF;
3053: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3054: p_instance_rec.pa_project_id := NULL;
3055: l_get_instance_rec.pa_project_id := NULL;
3056: END IF;
3057: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

Line 3057: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

3053: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3054: p_instance_rec.pa_project_id := NULL;
3055: l_get_instance_rec.pa_project_id := NULL;
3056: END IF;
3057: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3058: p_instance_rec.pa_project_task_id := NULL;
3059: l_get_instance_rec.pa_project_task_id := NULL;
3060: END IF;
3061: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

Line 3061: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

3057: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3058: p_instance_rec.pa_project_task_id := NULL;
3059: l_get_instance_rec.pa_project_task_id := NULL;
3060: END IF;
3061: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3062: p_instance_rec.in_transit_order_line_id := NULL;
3063: l_get_instance_rec.in_transit_order_line_id := NULL;
3064: END IF;
3065: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

Line 3065: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

3061: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3062: p_instance_rec.in_transit_order_line_id := NULL;
3063: l_get_instance_rec.in_transit_order_line_id := NULL;
3064: END IF;
3065: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3066: p_instance_rec.po_order_line_id := NULL;
3067: l_get_instance_rec.po_order_line_id := NULL;
3068: END IF;
3069:

Line 3074: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN

3070: ELSIF
3071:
3072: l_get_instance_rec.location_type_code = 'IN_TRANSIT' THEN
3073:
3074: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3075: p_instance_rec.inv_organization_id := NULL;
3076: l_get_instance_rec.inv_organization_id := NULL;
3077: END IF;
3078: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

Line 3078: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

3074: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3075: p_instance_rec.inv_organization_id := NULL;
3076: l_get_instance_rec.inv_organization_id := NULL;
3077: END IF;
3078: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3079: p_instance_rec.inv_subinventory_name := NULL;
3080: l_get_instance_rec.inv_subinventory_name := NULL;
3081: END IF;
3082: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

Line 3082: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

3078: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3079: p_instance_rec.inv_subinventory_name := NULL;
3080: l_get_instance_rec.inv_subinventory_name := NULL;
3081: END IF;
3082: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3083: p_instance_rec.inv_locator_id := NULL;
3084: l_get_instance_rec.inv_locator_id := NULL;
3085: END IF;
3086: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

Line 3086: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

3082: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3083: p_instance_rec.inv_locator_id := NULL;
3084: l_get_instance_rec.inv_locator_id := NULL;
3085: END IF;
3086: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3087: p_instance_rec.pa_project_id := NULL;
3088: l_get_instance_rec.pa_project_id := NULL;
3089: END IF;
3090: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

Line 3090: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

3086: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3087: p_instance_rec.pa_project_id := NULL;
3088: l_get_instance_rec.pa_project_id := NULL;
3089: END IF;
3090: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3091: p_instance_rec.pa_project_task_id := NULL;
3092: l_get_instance_rec.pa_project_task_id := NULL;
3093: END IF;
3094: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

Line 3094: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

3090: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3091: p_instance_rec.pa_project_task_id := NULL;
3092: l_get_instance_rec.pa_project_task_id := NULL;
3093: END IF;
3094: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3095: p_instance_rec.wip_job_id := NULL;
3096: l_get_instance_rec.wip_job_id := NULL;
3097: END IF;
3098: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

Line 3098: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

3094: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3095: p_instance_rec.wip_job_id := NULL;
3096: l_get_instance_rec.wip_job_id := NULL;
3097: END IF;
3098: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3099: p_instance_rec.po_order_line_id := NULL;
3100: l_get_instance_rec.po_order_line_id := NULL;
3101: END IF;
3102:

Line 3107: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN

3103: ELSIF
3104:
3105: l_get_instance_rec.location_type_code = 'PO' THEN
3106:
3107: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3108: p_instance_rec.inv_organization_id := NULL;
3109: l_get_instance_rec.inv_organization_id := NULL;
3110: END IF;
3111: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

Line 3111: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

3107: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3108: p_instance_rec.inv_organization_id := NULL;
3109: l_get_instance_rec.inv_organization_id := NULL;
3110: END IF;
3111: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3112: p_instance_rec.inv_subinventory_name := NULL;
3113: l_get_instance_rec.inv_subinventory_name := NULL;
3114: END IF;
3115: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

Line 3115: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

3111: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3112: p_instance_rec.inv_subinventory_name := NULL;
3113: l_get_instance_rec.inv_subinventory_name := NULL;
3114: END IF;
3115: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3116: p_instance_rec.inv_locator_id := NULL;
3117: l_get_instance_rec.inv_locator_id := NULL;
3118: END IF;
3119: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

Line 3119: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

3115: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3116: p_instance_rec.inv_locator_id := NULL;
3117: l_get_instance_rec.inv_locator_id := NULL;
3118: END IF;
3119: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3120: p_instance_rec.pa_project_id := NULL;
3121: l_get_instance_rec.pa_project_id := NULL;
3122: END IF;
3123: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

Line 3123: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

3119: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3120: p_instance_rec.pa_project_id := NULL;
3121: l_get_instance_rec.pa_project_id := NULL;
3122: END IF;
3123: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3124: p_instance_rec.pa_project_task_id := NULL;
3125: l_get_instance_rec.pa_project_task_id := NULL;
3126: END IF;
3127: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

Line 3127: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

3123: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3124: p_instance_rec.pa_project_task_id := NULL;
3125: l_get_instance_rec.pa_project_task_id := NULL;
3126: END IF;
3127: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3128: p_instance_rec.wip_job_id := NULL;
3129: l_get_instance_rec.wip_job_id := NULL;
3130: END IF;
3131: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

Line 3131: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

3127: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3128: p_instance_rec.wip_job_id := NULL;
3129: l_get_instance_rec.wip_job_id := NULL;
3130: END IF;
3131: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3132: p_instance_rec.in_transit_order_line_id := NULL;
3133: l_get_instance_rec.in_transit_order_line_id := NULL;
3134: END IF;
3135:

Line 3140: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN

3136: ELSIF
3137:
3138: l_get_instance_rec.location_type_code = 'HZ_LOCATIONS' THEN
3139:
3140: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3141: p_instance_rec.inv_organization_id := NULL;
3142: l_get_instance_rec.inv_organization_id := NULL;
3143: END IF;
3144: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

Line 3144: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

3140: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3141: p_instance_rec.inv_organization_id := NULL;
3142: l_get_instance_rec.inv_organization_id := NULL;
3143: END IF;
3144: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3145: p_instance_rec.inv_subinventory_name := NULL;
3146: l_get_instance_rec.inv_subinventory_name := NULL;
3147: END IF;
3148: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

Line 3148: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

3144: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3145: p_instance_rec.inv_subinventory_name := NULL;
3146: l_get_instance_rec.inv_subinventory_name := NULL;
3147: END IF;
3148: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3149: p_instance_rec.inv_locator_id := NULL;
3150: l_get_instance_rec.inv_locator_id := NULL;
3151: END IF;
3152: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

Line 3152: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

3148: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3149: p_instance_rec.inv_locator_id := NULL;
3150: l_get_instance_rec.inv_locator_id := NULL;
3151: END IF;
3152: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3153: p_instance_rec.wip_job_id := NULL;
3154: l_get_instance_rec.wip_job_id := NULL;
3155: END IF;
3156: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

Line 3156: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

3152: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3153: p_instance_rec.wip_job_id := NULL;
3154: l_get_instance_rec.wip_job_id := NULL;
3155: END IF;
3156: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3157: p_instance_rec.in_transit_order_line_id := NULL;
3158: l_get_instance_rec.in_transit_order_line_id := NULL;
3159: END IF;
3160: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

Line 3160: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

3156: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3157: p_instance_rec.in_transit_order_line_id := NULL;
3158: l_get_instance_rec.in_transit_order_line_id := NULL;
3159: END IF;
3160: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3161: p_instance_rec.po_order_line_id := NULL;
3162: l_get_instance_rec.po_order_line_id := NULL;
3163: END IF;
3164: /*

Line 3165: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

3161: p_instance_rec.po_order_line_id := NULL;
3162: l_get_instance_rec.po_order_line_id := NULL;
3163: END IF;
3164: /*
3165: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3166: p_instance_rec.pa_project_id := NULL;
3167: l_get_instance_rec.pa_project_id := NULL;
3168: END IF;
3169: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

Line 3169: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

3165: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3166: p_instance_rec.pa_project_id := NULL;
3167: l_get_instance_rec.pa_project_id := NULL;
3168: END IF;
3169: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3170: p_instance_rec.pa_project_task_id := NULL;
3171: l_get_instance_rec.pa_project_task_id := NULL;
3172: END IF;
3173: */

Line 3178: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN

3174: ELSIF
3175:
3176: l_get_instance_rec.location_type_code = 'HZ_PARTY_SITES' THEN
3177:
3178: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3179: p_instance_rec.inv_organization_id := NULL;
3180: l_get_instance_rec.inv_organization_id := NULL;
3181: END IF;
3182: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

Line 3182: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

3178: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3179: p_instance_rec.inv_organization_id := NULL;
3180: l_get_instance_rec.inv_organization_id := NULL;
3181: END IF;
3182: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3183: p_instance_rec.inv_subinventory_name := NULL;
3184: l_get_instance_rec.inv_subinventory_name := NULL;
3185: END IF;
3186: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

Line 3186: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

3182: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3183: p_instance_rec.inv_subinventory_name := NULL;
3184: l_get_instance_rec.inv_subinventory_name := NULL;
3185: END IF;
3186: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3187: p_instance_rec.inv_locator_id := NULL;
3188: l_get_instance_rec.inv_locator_id := NULL;
3189: END IF;
3190: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

Line 3190: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

3186: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3187: p_instance_rec.inv_locator_id := NULL;
3188: l_get_instance_rec.inv_locator_id := NULL;
3189: END IF;
3190: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3191: p_instance_rec.wip_job_id := NULL;
3192: l_get_instance_rec.wip_job_id := NULL;
3193: END IF;
3194: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

Line 3194: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

3190: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3191: p_instance_rec.wip_job_id := NULL;
3192: l_get_instance_rec.wip_job_id := NULL;
3193: END IF;
3194: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3195: p_instance_rec.in_transit_order_line_id := NULL;
3196: l_get_instance_rec.in_transit_order_line_id := NULL;
3197: END IF;
3198: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

Line 3198: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

3194: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3195: p_instance_rec.in_transit_order_line_id := NULL;
3196: l_get_instance_rec.in_transit_order_line_id := NULL;
3197: END IF;
3198: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3199: p_instance_rec.po_order_line_id := NULL;
3200: l_get_instance_rec.po_order_line_id := NULL;
3201: END IF;
3202: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

Line 3202: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

3198: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3199: p_instance_rec.po_order_line_id := NULL;
3200: l_get_instance_rec.po_order_line_id := NULL;
3201: END IF;
3202: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3203: p_instance_rec.pa_project_id := NULL;
3204: l_get_instance_rec.pa_project_id := NULL;
3205: END IF;
3206: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

Line 3206: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

3202: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3203: p_instance_rec.pa_project_id := NULL;
3204: l_get_instance_rec.pa_project_id := NULL;
3205: END IF;
3206: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3207: p_instance_rec.pa_project_task_id := NULL;
3208: l_get_instance_rec.pa_project_task_id := NULL;
3209: END IF;
3210:

Line 3215: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN

3211: ELSIF
3212:
3213: l_get_instance_rec.location_type_code = 'VENDOR_SITE' THEN
3214:
3215: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3216: p_instance_rec.inv_organization_id := NULL;
3217: l_get_instance_rec.inv_organization_id := NULL;
3218: END IF;
3219: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

Line 3219: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

3215: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3216: p_instance_rec.inv_organization_id := NULL;
3217: l_get_instance_rec.inv_organization_id := NULL;
3218: END IF;
3219: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3220: p_instance_rec.inv_subinventory_name := NULL;
3221: l_get_instance_rec.inv_subinventory_name := NULL;
3222: END IF;
3223: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

Line 3223: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

3219: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3220: p_instance_rec.inv_subinventory_name := NULL;
3221: l_get_instance_rec.inv_subinventory_name := NULL;
3222: END IF;
3223: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3224: p_instance_rec.inv_locator_id := NULL;
3225: l_get_instance_rec.inv_locator_id := NULL;
3226: END IF;
3227: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

Line 3227: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

3223: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3224: p_instance_rec.inv_locator_id := NULL;
3225: l_get_instance_rec.inv_locator_id := NULL;
3226: END IF;
3227: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3228: p_instance_rec.wip_job_id := NULL;
3229: l_get_instance_rec.wip_job_id := NULL;
3230: END IF;
3231: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

Line 3231: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

3227: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3228: p_instance_rec.wip_job_id := NULL;
3229: l_get_instance_rec.wip_job_id := NULL;
3230: END IF;
3231: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3232: p_instance_rec.in_transit_order_line_id := NULL;
3233: l_get_instance_rec.in_transit_order_line_id := NULL;
3234: END IF;
3235: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

Line 3235: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

3231: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3232: p_instance_rec.in_transit_order_line_id := NULL;
3233: l_get_instance_rec.in_transit_order_line_id := NULL;
3234: END IF;
3235: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3236: p_instance_rec.po_order_line_id := NULL;
3237: l_get_instance_rec.po_order_line_id := NULL;
3238: END IF;
3239: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

Line 3239: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

3235: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3236: p_instance_rec.po_order_line_id := NULL;
3237: l_get_instance_rec.po_order_line_id := NULL;
3238: END IF;
3239: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3240: p_instance_rec.pa_project_id := NULL;
3241: l_get_instance_rec.pa_project_id := NULL;
3242: END IF;
3243: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

Line 3243: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

3239: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3240: p_instance_rec.pa_project_id := NULL;
3241: l_get_instance_rec.pa_project_id := NULL;
3242: END IF;
3243: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3244: p_instance_rec.pa_project_task_id := NULL;
3245: l_get_instance_rec.pa_project_task_id := NULL;
3246: END IF;
3247:

Line 3252: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN

3248: ELSIF
3249:
3250: l_get_instance_rec.location_type_code = 'INTERNAL_SITE' THEN
3251:
3252: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3253: p_instance_rec.inv_organization_id := NULL;
3254: l_get_instance_rec.inv_organization_id := NULL;
3255: END IF;
3256: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

Line 3256: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN

3252: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3253: p_instance_rec.inv_organization_id := NULL;
3254: l_get_instance_rec.inv_organization_id := NULL;
3255: END IF;
3256: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3257: p_instance_rec.inv_subinventory_name := NULL;
3258: l_get_instance_rec.inv_subinventory_name := NULL;
3259: END IF;
3260: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

Line 3260: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN

3256: IF p_instance_rec.inv_subinventory_name = FND_API.G_MISS_CHAR THEN
3257: p_instance_rec.inv_subinventory_name := NULL;
3258: l_get_instance_rec.inv_subinventory_name := NULL;
3259: END IF;
3260: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3261: p_instance_rec.inv_locator_id := NULL;
3262: l_get_instance_rec.inv_locator_id := NULL;
3263: END IF;
3264: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

Line 3264: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN

3260: IF p_instance_rec.inv_locator_id = FND_API.G_MISS_NUM THEN
3261: p_instance_rec.inv_locator_id := NULL;
3262: l_get_instance_rec.inv_locator_id := NULL;
3263: END IF;
3264: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3265: p_instance_rec.wip_job_id := NULL;
3266: l_get_instance_rec.wip_job_id := NULL;
3267: END IF;
3268: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

Line 3268: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN

3264: IF p_instance_rec.wip_job_id = FND_API.G_MISS_NUM THEN
3265: p_instance_rec.wip_job_id := NULL;
3266: l_get_instance_rec.wip_job_id := NULL;
3267: END IF;
3268: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3269: p_instance_rec.in_transit_order_line_id := NULL;
3270: l_get_instance_rec.in_transit_order_line_id := NULL;
3271: END IF;
3272: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

Line 3272: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN

3268: IF p_instance_rec.in_transit_order_line_id = FND_API.G_MISS_NUM THEN
3269: p_instance_rec.in_transit_order_line_id := NULL;
3270: l_get_instance_rec.in_transit_order_line_id := NULL;
3271: END IF;
3272: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3273: p_instance_rec.po_order_line_id := NULL;
3274: l_get_instance_rec.po_order_line_id := NULL;
3275: END IF;
3276: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

Line 3276: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN

3272: IF p_instance_rec.po_order_line_id = FND_API.G_MISS_NUM THEN
3273: p_instance_rec.po_order_line_id := NULL;
3274: l_get_instance_rec.po_order_line_id := NULL;
3275: END IF;
3276: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3277: p_instance_rec.pa_project_id := NULL;
3278: l_get_instance_rec.pa_project_id := NULL;
3279: END IF;
3280: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

Line 3280: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN

3276: IF p_instance_rec.pa_project_id = FND_API.G_MISS_NUM THEN
3277: p_instance_rec.pa_project_id := NULL;
3278: l_get_instance_rec.pa_project_id := NULL;
3279: END IF;
3280: IF p_instance_rec.pa_project_task_id = FND_API.G_MISS_NUM THEN
3281: p_instance_rec.pa_project_task_id := NULL;
3282: l_get_instance_rec.pa_project_task_id := NULL;
3283: END IF;
3284:

Line 3438: p_srl_control_code <> FND_API.G_MISS_NUM THEN

3434: BEGIN
3435: l_return_value := TRUE;
3436: --
3437: IF p_srl_control_code is not NULL AND
3438: p_srl_control_code <> FND_API.G_MISS_NUM THEN
3439: Serialized := p_srl_control_code;
3440: ELSE
3441: OPEN c1;
3442: FETCH c1 into serialized;

Line 3451: IF NVL(p_txn_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR) = 'FIELD_SERVICE_TXN' THEN

3447: --
3448: -- Bug 12574008
3449: -- If the transaction is a Field Service Transaction
3450: -- Then assign p_txn_rec.ATTRIBUTE15
3451: IF NVL(p_txn_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR) = 'FIELD_SERVICE_TXN' THEN
3452: l_inv_txn_typeid_from_cs := to_number(p_txn_rec.ATTRIBUTE15);
3453: END IF;
3454:
3455: -- Get serial tagging control 9977630

Line 3482: (p_serial_number = FND_API.G_MISS_CHAR)) THEN

3478: )
3479: AND NVL(l_serial_tagged,'N') = 'Y'
3480: THEN
3481: IF ((p_serial_number IS NULL) OR
3482: (p_serial_number = FND_API.G_MISS_CHAR)) THEN
3483: l_return_value := FALSE;
3484: IF (p_stack_err_msg = TRUE) THEN
3485: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SERIAL_NUM');
3486: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',p_serial_number);

Line 3501: IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN

3497: ,p_transaction_type_id => p_txn_rec.transaction_type_id
3498: )
3499: AND NVL(l_serial_tagged,'N') <> 'Y'
3500: THEN
3501: IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
3502: l_found := NULL;
3503: IF serialized IS NOT NULL
3504: AND serialized=6
3505: AND p_instance_usage_code='RETURNED'

Line 3590: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN

3586: SELECT negative_inv_receipt_code
3587: FROM mtl_parameters
3588: WHERE organization_id = p_inv_organization_id;
3589: BEGIN
3590: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
3591: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized
3592: ( p_serial_control_code => p_serial_control_code
3593: ,p_location_type_code => p_location_type_code
3594: )) --Added by sk on 09/14/01

Line 3710: (p_curr_acct_class_code = FND_API.G_MISS_CHAR)) THEN

3706: x_acct_class_code := 'INV';
3707: END IF;
3708: ELSE
3709: IF ((p_curr_acct_class_code IS NULL) OR
3710: (p_curr_acct_class_code = FND_API.G_MISS_CHAR)) THEN
3711: x_acct_class_code := 'CUST_PROD';
3712: ELSE
3713: IF (p_curr_acct_class_code = 'WIP') OR
3714: (p_curr_acct_class_code = 'PROJECT') THEN

Line 3787: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) THEN

3783: FROM csi_item_instances
3784: WHERE instance_id = p_instance_id;
3785:
3786: BEGIN
3787: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) THEN
3788: OPEN c1;
3789: FETCH c1 INTO l_instance_end_date ,l_instance_start_date;
3790: IF trunc(p_end_date) < trunc(l_instance_start_date) THEN
3791: l_return_value := FALSE;

Line 4042: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)

4038:
4039: l_dummy VARCHAR2(2);
4040:
4041: BEGIN
4042: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)
4043: OR (p_ORGANIZATION_ID IS NULL)
4044: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)
4045: OR (p_INVENTORY_ITEM_ID IS NULL))
4046: THEN

Line 4044: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)

4040:
4041: BEGIN
4042: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)
4043: OR (p_ORGANIZATION_ID IS NULL)
4044: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)
4045: OR (p_INVENTORY_ITEM_ID IS NULL))
4046: THEN
4047: IF ( p_stack_err_msg = TRUE ) THEN
4048: FND_MESSAGE.SET_NAME('CSI','CSI_API_NULL_ITEM_ORG');

Line 4087: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)

4083:
4084: l_dummy VARCHAR2(2);
4085:
4086: BEGIN
4087: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)
4088: OR (p_ORGANIZATION_ID IS NULL)
4089: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)
4090: OR (p_INVENTORY_ITEM_ID IS NULL))
4091: THEN

Line 4089: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)

4085:
4086: BEGIN
4087: IF ((p_ORGANIZATION_ID = FND_API.G_MISS_NUM)
4088: OR (p_ORGANIZATION_ID IS NULL)
4089: OR (p_INVENTORY_ITEM_ID = FND_API.G_MISS_NUM)
4090: OR (p_INVENTORY_ITEM_ID IS NULL))
4091: THEN
4092: IF ( p_stack_err_msg = TRUE ) THEN
4093: FND_MESSAGE.SET_NAME('CSI','CSI_API_NULL_ITEM_ORG');

Line 4210: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

4206: WHERE instance_id = p_instance_id
4207: and ((active_end_date is null) OR (To_Date(active_end_date,'DD-MM-RRRR HH24:MI') >= To_Date(sysdate,'DD-MM-RRRR HH24:MI'))); -- Bug 8586745
4208:
4209: BEGIN
4210: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
4211: IF To_Date(p_start_date,'DD-MM-RRRR HH24:MI') > To_Date(p_end_date,'DD-MM-RRRR HH24:MI') THEN -- Bug 8586745
4212: l_return_value := FALSE;
4213: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_VER_START_DATE');
4214: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);

Line 4333: IF ((p_location_source_table IS NULL) OR (p_location_source_table = FND_API.G_MISS_CHAR) OR

4329: --
4330: -- Validate the Location Type and check if exists in csi_lookups table with type
4331: -- CSI_INST_LOCATION_SOURCE_CODE. If not raise the CSI_API_INVALID_LOCATION_TYPE exception
4332: -- Added the following code for R12
4333: IF ((p_location_source_table IS NULL) OR (p_location_source_table = FND_API.G_MISS_CHAR) OR
4334: (p_location_id IS NULL) OR (p_location_id = FND_API.G_MISS_NUM) )
4335: THEN
4336: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
4337: FND_MSG_PUB.ADD;

Line 4334: (p_location_id IS NULL) OR (p_location_id = FND_API.G_MISS_NUM) )

4330: -- Validate the Location Type and check if exists in csi_lookups table with type
4331: -- CSI_INST_LOCATION_SOURCE_CODE. If not raise the CSI_API_INVALID_LOCATION_TYPE exception
4332: -- Added the following code for R12
4333: IF ((p_location_source_table IS NULL) OR (p_location_source_table = FND_API.G_MISS_CHAR) OR
4334: (p_location_id IS NULL) OR (p_location_id = FND_API.G_MISS_NUM) )
4335: THEN
4336: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
4337: FND_MSG_PUB.ADD;
4338: l_return_value := FALSE;

Line 4510: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND

4506: BEGIN
4507:
4508: -- Get the values of installation parameters
4509: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4510: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4511: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

Line 4511: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

4507:
4508: -- Get the values of installation parameters
4509: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4510: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4511: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4515: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

Line 4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

4508: -- Get the values of installation parameters
4509: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4510: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4511: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4515: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4516: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND

Line 4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND

4509: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4510: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4511: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4515: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4516: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4517: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

Line 4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

4510: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4511: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4515: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4516: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4517: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4518: l_return_value:= TRUE;

Line 4515: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

4511: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4515: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4516: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4517: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4518: l_return_value:= TRUE;
4519: ELSE

Line 4516: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND

4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4515: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4516: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4517: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4518: l_return_value:= TRUE;
4519: ELSE
4520: l_return_value:= FALSE;

Line 4517: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4514: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4515: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4516: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4517: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4518: l_return_value:= TRUE;
4519: ELSE
4520: l_return_value:= FALSE;
4521: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');

Line 4529: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND

4525: END IF;
4526: --
4527: IF (p_location_source_table = 'HZ_LOCATIONS') THEN
4528:
4529: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4530: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

Line 4530: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

4526: --
4527: IF (p_location_source_table = 'HZ_LOCATIONS') THEN
4528:
4529: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4530: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4534: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

Line 4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

4527: IF (p_location_source_table = 'HZ_LOCATIONS') THEN
4528:
4529: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4530: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4534: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4535: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND

Line 4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND

4528:
4529: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4530: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4534: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4535: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4536: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

Line 4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

4529: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4530: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4534: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4535: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4536: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4537: l_return_value:= TRUE;

Line 4534: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

4530: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4534: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4535: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4536: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4537: l_return_value:= TRUE;
4538: ELSE

Line 4535: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND

4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4534: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4535: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4536: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4537: l_return_value:= TRUE;
4538: ELSE
4539: l_return_value:= FALSE;

Line 4536: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

4532: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4533: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4534: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4535: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4536: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4537: l_return_value:= TRUE;
4538: ELSE
4539: l_return_value:= FALSE;
4540: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');

Line 4545: IF ( (p_project_id IS NOT NULL AND p_project_id <> FND_API.G_MISS_NUM) OR

4541: FND_MSG_PUB.Add;
4542: RETURN l_return_value;
4543: END IF;
4544: -----------
4545: IF ( (p_project_id IS NOT NULL AND p_project_id <> FND_API.G_MISS_NUM) OR
4546: (p_task_id IS NOT NULL AND p_task_id <> FND_API.G_MISS_NUM) ) THEN
4547: -- Modified for tracking FP bug 7276773 from base bug 6330298
4548: IF (p_inst_usage_code = 'INSTALLED' OR p_inst_usage_code = 'IN_PROCESS') THEN
4549: BEGIN

Line 4546: (p_task_id IS NOT NULL AND p_task_id <> FND_API.G_MISS_NUM) ) THEN

4542: RETURN l_return_value;
4543: END IF;
4544: -----------
4545: IF ( (p_project_id IS NOT NULL AND p_project_id <> FND_API.G_MISS_NUM) OR
4546: (p_task_id IS NOT NULL AND p_task_id <> FND_API.G_MISS_NUM) ) THEN
4547: -- Modified for tracking FP bug 7276773 from base bug 6330298
4548: IF (p_inst_usage_code = 'INSTALLED' OR p_inst_usage_code = 'IN_PROCESS') THEN
4549: BEGIN
4550: SELECT '1'

Line 4575: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND

4571: END IF; -- location type is HZ_LOCATIONS
4572: --
4573: IF (p_location_source_table = 'VENDOR_SITE') THEN
4574:
4575: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4576: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4577: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

Line 4576: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

4572: --
4573: IF (p_location_source_table = 'VENDOR_SITE') THEN
4574:
4575: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4576: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4577: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4580: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

Line 4577: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

4573: IF (p_location_source_table = 'VENDOR_SITE') THEN
4574:
4575: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4576: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4577: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4580: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4581: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND

Line 4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND

4574:
4575: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4576: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4577: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4580: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4581: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4582: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

Line 4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

4575: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4576: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4577: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4580: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4581: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4582: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4583: l_return_value:= TRUE;

Line 4580: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

4576: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4577: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4580: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4581: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4582: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4583: l_return_value:= TRUE;
4584: ELSE

Line 4581: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND

4577: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4580: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4581: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4582: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4583: l_return_value:= TRUE;
4584: ELSE
4585: l_return_value:= FALSE;

Line 4582: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

4578: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4579: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4580: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4581: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4582: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4583: l_return_value:= TRUE;
4584: ELSE
4585: l_return_value:= FALSE;
4586: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');

Line 4596: IF ((p_organization_id IS NOT NULL) AND (p_organization_id <> FND_API.G_MISS_NUM)) AND

4592: IF (p_location_source_table = 'INVENTORY') THEN
4593:
4594: IF (p_location_id IS NOT NULL) THEN
4595: IF p_inst_usage_code <> 'IN_TRANSIT' THEN
4596: IF ((p_organization_id IS NOT NULL) AND (p_organization_id <> FND_API.G_MISS_NUM)) AND
4597: ((p_subinventory IS NOT NULL) AND (p_subinventory <> FND_API.G_MISS_CHAR)) THEN
4598: -- l_return_value := TRUE;
4599: BEGIN
4600: SELECT '1'

Line 4597: ((p_subinventory IS NOT NULL) AND (p_subinventory <> FND_API.G_MISS_CHAR)) THEN

4593:
4594: IF (p_location_id IS NOT NULL) THEN
4595: IF p_inst_usage_code <> 'IN_TRANSIT' THEN
4596: IF ((p_organization_id IS NOT NULL) AND (p_organization_id <> FND_API.G_MISS_NUM)) AND
4597: ((p_subinventory IS NOT NULL) AND (p_subinventory <> FND_API.G_MISS_CHAR)) THEN
4598: -- l_return_value := TRUE;
4599: BEGIN
4600: SELECT '1'
4601: INTO l_temp_id

Line 4616: IF ((p_locator_id IS NOT NULL) AND (p_locator_id <> FND_API.G_MISS_NUM)) THEN

4612: l_return_value := FALSE;
4613: RETURN l_return_value;
4614: END;
4615: -- Validate Locator_ID srramakr
4616: IF ((p_locator_id IS NOT NULL) AND (p_locator_id <> FND_API.G_MISS_NUM)) THEN
4617: BEGIN
4618: SELECT '1'
4619: INTO l_temp_id
4620: FROM MTL_ITEM_LOCATIONS

Line 4644: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND

4640: END IF;
4641: END IF;
4642: END IF;
4643:
4644: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4645: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4646: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4647: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4648: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

Line 4645: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

4641: END IF;
4642: END IF;
4643:
4644: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4645: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4646: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4647: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4648: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4649: l_return_value:= TRUE;

Line 4646: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

4642: END IF;
4643:
4644: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4645: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4646: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4647: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4648: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4649: l_return_value:= TRUE;
4650: ELSE

Line 4647: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND

4643:
4644: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4645: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4646: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4647: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4648: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4649: l_return_value:= TRUE;
4650: ELSE
4651: l_return_value:= FALSE;

Line 4648: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

4644: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4645: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4646: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4647: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4648: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4649: l_return_value:= TRUE;
4650: ELSE
4651: l_return_value:= FALSE;
4652: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');

Line 4660: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND

4656: END IF; -- INVENTORY
4657: --
4658: IF (p_location_source_table = 'INTERNAL_SITE') THEN
4659: l_return_value := TRUE;
4660: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4661: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4662: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_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_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

Line 4661: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

4657: --
4658: IF (p_location_source_table = 'INTERNAL_SITE') THEN
4659: l_return_value := TRUE;
4660: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4661: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4662: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_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_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4665: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

Line 4662: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

4658: IF (p_location_source_table = 'INTERNAL_SITE') THEN
4659: l_return_value := TRUE;
4660: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4661: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4662: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_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_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4665: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4666: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND

Line 4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND

4659: l_return_value := TRUE;
4660: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4661: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4662: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_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_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4665: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4666: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4667: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

Line 4664: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

4660: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4661: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4662: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_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_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4665: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4666: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4667: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4668: l_return_value:= TRUE;

Line 4665: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

4661: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4662: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_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_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4665: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4666: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4667: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4668: l_return_value:= TRUE;
4669: ELSE

Line 4666: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND

4662: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_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_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4665: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4666: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4667: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN
4668: l_return_value:= TRUE;
4669: ELSE
4670: l_return_value:= FALSE;

Line 4667: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) THEN

4663: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4664: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4665: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4666: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) AND
4667: ((p_wip_job_id IS NULL) OR (p_wip_job_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');

Line 4684: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND

4680: INTO l_temp_id
4681: FROM wip_entities
4682: WHERE wip_entity_id = p_wip_job_id;
4683:
4684: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4685: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4686: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4687: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4688: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

Line 4685: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

4681: FROM wip_entities
4682: WHERE wip_entity_id = p_wip_job_id;
4683:
4684: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4685: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4686: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4687: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4688: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4689: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

Line 4686: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

4682: WHERE wip_entity_id = p_wip_job_id;
4683:
4684: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4685: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4686: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4687: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4688: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4689: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4690: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN

Line 4687: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND

4683:
4684: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4685: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4686: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4687: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4688: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4689: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4690: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4691: l_return_value:= TRUE;

Line 4688: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

4684: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4685: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4686: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4687: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4688: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4689: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4690: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4691: l_return_value:= TRUE;
4692: ELSE

Line 4689: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

4685: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4686: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4687: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4688: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4689: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4690: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4691: l_return_value:= TRUE;
4692: ELSE
4693: l_return_value:= FALSE;

Line 4690: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN

4686: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4687: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4688: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4689: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4690: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4691: l_return_value:= TRUE;
4692: ELSE
4693: l_return_value:= FALSE;
4694: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');

Line 4717: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

4713: FROM pa_tasks
4714: WHERE project_id = p_project_id
4715: AND task_id = p_task_id;
4716:
4717: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4718: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4719: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4720: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4721: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

Line 4718: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND

4714: WHERE project_id = p_project_id
4715: AND task_id = p_task_id;
4716:
4717: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4718: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4719: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4720: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4721: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4722: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN

Line 4719: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND

4715: AND task_id = p_task_id;
4716:
4717: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4718: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4719: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4720: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4721: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4722: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4723: l_return_value:= TRUE;

Line 4720: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

4716:
4717: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4718: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4719: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4720: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4721: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4722: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4723: l_return_value:= TRUE;
4724: ELSE

Line 4721: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

4717: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4718: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4719: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4720: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4721: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4722: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4723: l_return_value:= TRUE;
4724: ELSE
4725: l_return_value:= FALSE;

Line 4722: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN

4718: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4719: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4720: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4721: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4722: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4723: l_return_value:= TRUE;
4724: ELSE
4725: l_return_value:= FALSE;
4726: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');

Line 4747: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND

4743: INTO l_temp_id
4744: FROM oe_order_lines_all
4745: WHERE line_id = p_sales_ord_line_id;
4746:
4747: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4748: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4749: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4750: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4751: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

Line 4748: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

4744: FROM oe_order_lines_all
4745: WHERE line_id = p_sales_ord_line_id;
4746:
4747: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4748: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4749: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4750: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4751: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4752: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

Line 4749: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND

4745: WHERE line_id = p_sales_ord_line_id;
4746:
4747: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4748: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4749: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4750: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4751: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4752: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4753: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN

Line 4750: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND

4746:
4747: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4748: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4749: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4750: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4751: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4752: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4753: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4754: l_return_value:= TRUE;

Line 4751: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

4747: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4748: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4749: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4750: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4751: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4752: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4753: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4754: l_return_value:= TRUE;
4755: ELSE

Line 4752: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

4748: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4749: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4750: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4751: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4752: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4753: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4754: l_return_value:= TRUE;
4755: ELSE
4756: l_return_value:= FALSE;

Line 4753: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN

4749: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND
4750: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4751: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4752: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4753: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4754: l_return_value:= TRUE;
4755: ELSE
4756: l_return_value:= FALSE;
4757: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');

Line 4778: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

4774: INTO l_temp_id
4775: FROM po_lines_all
4776: WHERE po_line_id = p_po_line_id;
4777:
4778: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4779: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4780: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4781: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4782: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

Line 4779: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND

4775: FROM po_lines_all
4776: WHERE po_line_id = p_po_line_id;
4777:
4778: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4779: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4780: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4781: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4782: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4783: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

Line 4780: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

4776: WHERE po_line_id = p_po_line_id;
4777:
4778: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4779: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4780: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4781: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4782: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4783: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4784: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN

Line 4781: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND

4777:
4778: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4779: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4780: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4781: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4782: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4783: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4784: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4785: l_return_value:= TRUE;

Line 4782: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND

4778: IF ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4779: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4780: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4781: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4782: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4783: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4784: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4785: l_return_value:= TRUE;
4786: ELSE

Line 4783: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND

4779: ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4780: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4781: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4782: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4783: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4784: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4785: l_return_value:= TRUE;
4786: ELSE
4787: l_return_value:= FALSE;

Line 4784: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN

4780: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4781: ((p_wip_job_id IS NULL) OR (p_wip_job_id = FND_API.G_MISS_NUM)) AND
4782: ((p_organization_id IS NULL) OR (p_organization_id = FND_API.G_MISS_NUM)) AND
4783: ((p_subinventory IS NULL) OR (p_subinventory = FND_API.G_MISS_CHAR)) AND
4784: ((p_locator_id IS NULL) OR (p_locator_id = FND_API.G_MISS_NUM)) THEN
4785: l_return_value:= TRUE;
4786: ELSE
4787: l_return_value:= FALSE;
4788: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOC_PARAMS');

Line 4832: x_return_status := FND_API.G_RET_STS_SUCCESS;

4828: OR object_id=p_instance_id)
4829: AND relationship_type_code ='CONNECTED-TO'
4830: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE);
4831: BEGIN
4832: x_return_status := FND_API.G_RET_STS_SUCCESS;
4833: -- Need to get the schema name using FND API. Refer Bug # 3431768
4834: --
4835: FOR l_link IN p_instance_header_tbl.FIRST..p_instance_header_tbl.LAST
4836: LOOP

Line 4833: -- Need to get the schema name using FND API. Refer Bug # 3431768

4829: AND relationship_type_code ='CONNECTED-TO'
4830: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE);
4831: BEGIN
4832: x_return_status := FND_API.G_RET_STS_SUCCESS;
4833: -- Need to get the schema name using FND API. Refer Bug # 3431768
4834: --
4835: FOR l_link IN p_instance_header_tbl.FIRST..p_instance_header_tbl.LAST
4836: LOOP
4837: SELECT nvl(ib_item_instance_class,'X')

Line 4864: l_header_tbl(1).instance_id <> FND_API.G_MISS_NUM

4860:
4861: IF l_header_tbl.COUNT>0
4862: THEN
4863: IF l_header_tbl(1).instance_id IS NOT NULL AND
4864: l_header_tbl(1).instance_id <> FND_API.G_MISS_NUM
4865: THEN
4866: BEGIN
4867: SELECT location_id,
4868: location_type_code

Line 4881: l_header_tbl(2).instance_id <> FND_API.G_MISS_NUM

4877: --
4878: IF l_header_tbl.COUNT>1
4879: THEN
4880: IF l_header_tbl(2).instance_id IS NOT NULL AND
4881: l_header_tbl(2).instance_id <> FND_API.G_MISS_NUM
4882: THEN
4883:
4884: BEGIN
4885: SELECT location_id,

Line 4939: x_return_status:= FND_API.G_RET_STS_SUCCESS;

4935: l_xml_hdr VARCHAR2(2000);
4936: l_xml_message LONG := NULL;
4937:
4938: BEGIN
4939: x_return_status:= FND_API.G_RET_STS_SUCCESS;
4940:
4941: Create_hdr_xml
4942: ( p_config_hdr_id => p_config_hdr_id,
4943: p_config_rev_nbr => p_config_rev_nbr,

Line 4950: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4946: x_return_status => x_return_status);
4947:
4948: csi_gen_utility_pvt.put_line('Status after calling Create_hdr_xml is '||x_return_status);
4949:
4950: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;
4953:
4954: Send_Input_xml

Line 4951: RAISE FND_API.G_EXC_ERROR;

4947:
4948: csi_gen_utility_pvt.put_line('Status after calling Create_hdr_xml is '||x_return_status);
4949:
4950: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;
4953:
4954: Send_Input_xml
4955: ( p_xml_hdr => l_xml_hdr,

Line 4961: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4957: x_return_status => x_return_status);
4958:
4959: csi_gen_utility_pvt.put_line('Status after calling Send_Input_xml is '||x_return_status);
4960:
4961: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4962: RAISE FND_API.G_EXC_ERROR;
4963: END IF;
4964:
4965: Parse_output_xml

Line 4962: RAISE FND_API.G_EXC_ERROR;

4958:
4959: csi_gen_utility_pvt.put_line('Status after calling Send_Input_xml is '||x_return_status);
4960:
4961: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4962: RAISE FND_API.G_EXC_ERROR;
4963: END IF;
4964:
4965: Parse_output_xml
4966: ( p_xml => l_xml_message,

Line 4974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4970:
4971:
4972: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);
4973:
4974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4975: RAISE FND_API.G_EXC_ERROR;
4976: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4978: END IF;

Line 4975: RAISE FND_API.G_EXC_ERROR;

4971:
4972: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);
4973:
4974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4975: RAISE FND_API.G_EXC_ERROR;
4976: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4978: END IF;
4979:

Line 4976: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4972: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);
4973:
4974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4975: RAISE FND_API.G_EXC_ERROR;
4976: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4978: END IF;
4979:
4980: EXCEPTION

Line 4977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4973:
4974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4975: RAISE FND_API.G_EXC_ERROR;
4976: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4978: END IF;
4979:
4980: EXCEPTION
4981: WHEN FND_API.G_EXC_ERROR THEN

Line 4981: WHEN FND_API.G_EXC_ERROR THEN

4977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4978: END IF;
4979:
4980: EXCEPTION
4981: WHEN FND_API.G_EXC_ERROR THEN
4982: x_return_status := FND_API.G_RET_STS_ERROR;
4983: csi_gen_utility_pvt.put_line('An exp error raised');
4984:
4985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4982: x_return_status := FND_API.G_RET_STS_ERROR;

4978: END IF;
4979:
4980: EXCEPTION
4981: WHEN FND_API.G_EXC_ERROR THEN
4982: x_return_status := FND_API.G_RET_STS_ERROR;
4983: csi_gen_utility_pvt.put_line('An exp error raised');
4984:
4985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4981: WHEN FND_API.G_EXC_ERROR THEN
4982: x_return_status := FND_API.G_RET_STS_ERROR;
4983: csi_gen_utility_pvt.put_line('An exp error raised');
4984:
4985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4987: csi_gen_utility_pvt.put_line('An unexp error raised');
4988:
4989: WHEN OTHERS THEN

Line 4986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4982: x_return_status := FND_API.G_RET_STS_ERROR;
4983: csi_gen_utility_pvt.put_line('An exp error raised');
4984:
4985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4987: csi_gen_utility_pvt.put_line('An unexp error raised');
4988:
4989: WHEN OTHERS THEN
4990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4987: csi_gen_utility_pvt.put_line('An unexp error raised');
4988:
4989: WHEN OTHERS THEN
4990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4991: csi_gen_utility_pvt.put_line( 'Send_input_xml error: ' ||substr(sqlerrm,1,100));
4992:
4993: END Call_batch_validate;
4994: --

Line 5178: l_prev_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;

5174: l_err_mtl_txn_date DATE;
5175: l_temp_count number := 0; -- 14712665
5176:
5177: -- Added for bug 9198245, FP of bug 7148814
5178: l_prev_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5179: l_min_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5180: l_max_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5181: BEGIN
5182: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5179: l_min_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;

5175: l_temp_count number := 0; -- 14712665
5176:
5177: -- Added for bug 9198245, FP of bug 7148814
5178: l_prev_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5179: l_min_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5180: l_max_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5181: BEGIN
5182: x_return_status := FND_API.G_RET_STS_SUCCESS;
5183: --

Line 5180: l_max_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;

5176:
5177: -- Added for bug 9198245, FP of bug 7148814
5178: l_prev_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5179: l_min_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5180: l_max_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5181: BEGIN
5182: x_return_status := FND_API.G_RET_STS_SUCCESS;
5183: --
5184: csi_gen_utility_pvt.put_line('inside check_prior_txn');

Line 5182: x_return_status := FND_API.G_RET_STS_SUCCESS;

5178: l_prev_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5179: l_min_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5180: l_max_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5181: BEGIN
5182: x_return_status := FND_API.G_RET_STS_SUCCESS;
5183: --
5184: csi_gen_utility_pvt.put_line('inside check_prior_txn');
5185:
5186: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM

Line 5186: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM

5182: x_return_status := FND_API.G_RET_STS_SUCCESS;
5183: --
5184: csi_gen_utility_pvt.put_line('inside check_prior_txn');
5185:
5186: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5187: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5188: THEN
5189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5190: csi_gen_utility_pvt.populate_install_param_rec;

Line 5187: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR

5183: --
5184: csi_gen_utility_pvt.put_line('inside check_prior_txn');
5185:
5186: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5187: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5188: THEN
5189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5190: csi_gen_utility_pvt.populate_install_param_rec;
5191: END IF;

Line 5199: raise fnd_api.g_exc_error;

5195:
5196: IF l_txn_seq_start_date IS NULL THEN
5197: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5198: FND_MSG_PUB.ADD;
5199: raise fnd_api.g_exc_error;
5200: END IF;
5201:
5202: IF p_instance_rec.last_txn_line_detail_id IS NULL OR
5203: p_instance_rec.last_txn_line_detail_id = FND_API.G_MISS_NUM THEN

Line 5203: p_instance_rec.last_txn_line_detail_id = FND_API.G_MISS_NUM THEN

5199: raise fnd_api.g_exc_error;
5200: END IF;
5201:
5202: IF p_instance_rec.last_txn_line_detail_id IS NULL OR
5203: p_instance_rec.last_txn_line_detail_id = FND_API.G_MISS_NUM THEN
5204: l_txn_line_detail_id := -9999;
5205: ELSE
5206: l_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
5207: END IF;

Line 5209: l_cur_mtl_txn_id := NVL(p_txn_rec.inv_material_transaction_id,FND_API.G_MISS_NUM);

5205: ELSE
5206: l_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
5207: END IF;
5208: --
5209: l_cur_mtl_txn_id := NVL(p_txn_rec.inv_material_transaction_id,FND_API.G_MISS_NUM);
5210: IF l_cur_mtl_txn_id <> FND_API.G_MISS_NUM THEN
5211: Begin
5212: select creation_date
5213: into l_cur_mtl_txn_date

Line 5210: IF l_cur_mtl_txn_id <> FND_API.G_MISS_NUM THEN

5206: l_txn_line_detail_id := p_instance_rec.last_txn_line_detail_id;
5207: END IF;
5208: --
5209: l_cur_mtl_txn_id := NVL(p_txn_rec.inv_material_transaction_id,FND_API.G_MISS_NUM);
5210: IF l_cur_mtl_txn_id <> FND_API.G_MISS_NUM THEN
5211: Begin
5212: select creation_date
5213: into l_cur_mtl_txn_date
5214: from MTL_MATERIAL_TRANSACTIONS

Line 5360: raise fnd_api.g_exc_error;

5356: fnd_message.set_name('CSI','CSI_PENDING_PRIOR_TXN');
5357: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5358: fnd_msg_pub.add;
5359: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transaction_id;
5360: raise fnd_api.g_exc_error;
5361: END IF;
5362: IF l_mtl_txn_tbl(l_ind).transfer_transaction_id is not null THEN
5363: IF l_pending_txn_tbl.exists(l_mtl_txn_tbl(l_ind).transfer_transaction_id) THEN
5364: fnd_message.set_name('CSI','CSI_PENDING_PRIOR_TXN');

Line 5368: RAISE fnd_api.g_exc_error;

5364: fnd_message.set_name('CSI','CSI_PENDING_PRIOR_TXN');
5365: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transfer_transaction_id);
5366: fnd_msg_pub.add;
5367: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transfer_transaction_id;
5368: RAISE fnd_api.g_exc_error;
5369: END IF;
5370: END IF;
5371: END IF;
5372: END IF;

Line 5387: IF l_err_mtl_txn_id <> FND_API.G_MISS_NUM

5383: p_transfer_transaction_id => l_xfer_mtl_txn_id)
5384: LOOP
5385: l_err_mtl_txn_id := err_txn_rec.inv_material_transaction_id;
5386:
5387: IF l_err_mtl_txn_id <> FND_API.G_MISS_NUM
5388: AND l_err_mtl_txn_id <> l_cur_mtl_txn_id THEN -- The errorred transaction is not the transaction currently being reprocessed
5389: BEGIN
5390: SELECT creation_date
5391: INTO l_err_mtl_txn_date

Line 5402: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE

5398:
5399: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_id : '||l_err_mtl_txn_id);
5400: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);
5401:
5402: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE
5403: AND l_err_mtl_txn_date <= l_cur_mtl_txn_date)
5404: OR (l_err_mtl_txn_date = FND_API.G_MISS_DATE) THEN
5405: fnd_message.set_name('CSI','CSI_ERROR_PRIOR_TXN');
5406: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);

Line 5404: OR (l_err_mtl_txn_date = FND_API.G_MISS_DATE) THEN

5400: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);
5401:
5402: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE
5403: AND l_err_mtl_txn_date <= l_cur_mtl_txn_date)
5404: OR (l_err_mtl_txn_date = FND_API.G_MISS_DATE) THEN
5405: fnd_message.set_name('CSI','CSI_ERROR_PRIOR_TXN');
5406: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5407: fnd_msg_pub.add;
5408: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transaction_id;

Line 5409: RAISE fnd_api.g_exc_error;

5405: fnd_message.set_name('CSI','CSI_ERROR_PRIOR_TXN');
5406: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5407: fnd_msg_pub.add;
5408: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transaction_id;
5409: RAISE fnd_api.g_exc_error;
5410: END IF;
5411: END IF;
5412: END LOOP;
5413:

Line 5422: IF l_min_inv_mtl_txn_id <> FND_API.G_MISS_NUM AND l_max_inv_mtl_txn_id <> FND_API.G_MISS_NUM

5418: -- Added condition for bug9198245, FP of bug 7294792
5419:
5420: l_prev_mtl_txn_id:=l_mtl_txn_tbl(l_ind).transaction_id;
5421:
5422: IF l_min_inv_mtl_txn_id <> FND_API.G_MISS_NUM AND l_max_inv_mtl_txn_id <> FND_API.G_MISS_NUM
5423: AND l_min_inv_mtl_txn_id 5424: THEN
5425: SELECT 'Y'
5426: INTO l_txn_found

Line 5438: RAISE fnd_api.g_exc_error;

5434: fnd_message.set_name('CSI','CSI_PENDING_PRIOR_TXN');
5435: fnd_message.set_token('MAT_TXN_ID',l_mtl_txn_tbl(l_ind).transaction_id);
5436: fnd_msg_pub.add;
5437: p_prior_txn_id := l_mtl_txn_tbl(l_ind).transaction_id;
5438: RAISE fnd_api.g_exc_error;
5439: END;
5440: END IF;
5441: END IF;
5442: END LOOP;

Line 5483: RAISE fnd_api.g_exc_error;

5479: FND_MESSAGE.SET_NAME('CSI','CSI_ERROR_INST_DETAILS');
5480: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number);
5481: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5482: FND_MSG_PUB.Add;
5483: RAISE fnd_api.g_exc_error;
5484: END IF;
5485: END IF; -- Item-srl# not null check
5486: EXCEPTION
5487: WHEN fnd_api.g_exc_error THEN

Line 5487: WHEN fnd_api.g_exc_error THEN

5483: RAISE fnd_api.g_exc_error;
5484: END IF;
5485: END IF; -- Item-srl# not null check
5486: EXCEPTION
5487: WHEN fnd_api.g_exc_error THEN
5488: x_return_status := FND_API.G_RET_STS_ERROR;
5489: END Check_Prior_Txn;
5490: --
5491: FUNCTION Is_Forward_Synch

Line 5488: x_return_status := FND_API.G_RET_STS_ERROR;

5484: END IF;
5485: END IF; -- Item-srl# not null check
5486: EXCEPTION
5487: WHEN fnd_api.g_exc_error THEN
5488: x_return_status := FND_API.G_RET_STS_ERROR;
5489: END Check_Prior_Txn;
5490: --
5491: FUNCTION Is_Forward_Synch
5492: ( p_instance_id IN NUMBER,

Line 5500: l_mtl_txn_id NUMBER := NVL(p_mtl_txn_id,fnd_api.g_miss_num);

5496: --
5497: l_return_value BOOLEAN;
5498: l_recount NUMBER;
5499: l_process_flag VARCHAR2(1) := 'P';
5500: l_mtl_txn_id NUMBER := NVL(p_mtl_txn_id,fnd_api.g_miss_num);
5501: l_def_cr_date DATE := sysdate;
5502: l_mtl_txn_cr_date DATE;
5503: BEGIN
5504: l_return_value := TRUE;

Line 5507: p_instance_id <> FND_API.G_MISS_NUM THEN

5503: BEGIN
5504: l_return_value := TRUE;
5505: --
5506: IF p_instance_id IS NOT NULL AND
5507: p_instance_id <> FND_API.G_MISS_NUM THEN
5508: l_recount := 0;
5509: IF nvl(p_stop_all_txn,FND_API.G_TRUE) = FND_API.G_TRUE THEN
5510: csi_gen_utility_pvt.put_line('Stop All Txns..');
5511: BEGIN

Line 5509: IF nvl(p_stop_all_txn,FND_API.G_TRUE) = FND_API.G_TRUE THEN

5505: --
5506: IF p_instance_id IS NOT NULL AND
5507: p_instance_id <> FND_API.G_MISS_NUM THEN
5508: l_recount := 0;
5509: IF nvl(p_stop_all_txn,FND_API.G_TRUE) = FND_API.G_TRUE THEN
5510: csi_gen_utility_pvt.put_line('Stop All Txns..');
5511: BEGIN
5512: select count(*)
5513: into l_recount

Line 5525: IF l_mtl_txn_id <> fnd_api.g_miss_num THEN

5521: END;
5522: --
5523: ELSE
5524: csi_gen_utility_pvt.put_line('Stop Later Txns..');
5525: IF l_mtl_txn_id <> fnd_api.g_miss_num THEN
5526: Begin
5527: select creation_date
5528: into l_mtl_txn_cr_date
5529: from MTL_MATERIAL_TRANSACTIONS

Line 5573: p_master_org_id = FND_API.G_MISS_NUM THEN

5569: l_exists VARCHAR2(1);
5570: BEGIN
5571: l_return_value := TRUE;
5572: IF p_master_org_id IS NULL OR
5573: p_master_org_id = FND_API.G_MISS_NUM THEN
5574: l_return_value := FALSE;
5575: RETURN l_return_value;
5576: END IF;
5577: --

Line 5626: x_return_status:= FND_API.G_RET_STS_SUCCESS;

5622: l_dummy VARCHAR2(500) := NULL;
5623: l_debug_level NUMBER;
5624: l_icx_session_ticket VARCHAR2(200);
5625: BEGIN
5626: x_return_status:= FND_API.G_RET_STS_SUCCESS;
5627:
5628:
5629:
5630: -- Now set the values from model_rec and org_id

Line 5716: ,p_init_msg_list => fnd_api.g_false

5712:
5713: IF (l_debug_level > 1) THEN
5714: csi_gen_utility_pvt.dump_call_batch_val
5715: ( p_api_version => 1.0
5716: ,p_init_msg_list => fnd_api.g_false
5717: ,p_parameter_name => param_name
5718: ,p_parameter_value => param_value
5719: );
5720: END IF;

Line 5751: x_return_status := FND_API.G_RET_STS_ERROR;

5747: csi_gen_utility_pvt.put_line('------------------------------------- ');
5748: EXCEPTION
5749: WHEN OTHERS THEN
5750: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);
5751: x_return_status := FND_API.G_RET_STS_ERROR;
5752: END Create_hdr_xml;
5753:
5754:
5755:

Line 5788: l_return_status := FND_API.G_RET_STS_SUCCESS;

5784: l_long_xml LONG := NULL;
5785: l_return_status VARCHAR2(1);
5786:
5787: BEGIN
5788: l_return_status := FND_API.G_RET_STS_SUCCESS;
5789:
5790: csi_gen_utility_pvt.put_line('Entering Send_input_xml');
5791: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );
5792:

Line 5814: l_return_status := FND_API.G_RET_STS_ERROR;

5810: csi_gen_utility_pvt.put_line('After call to batch validation the status is : '||l_validation_status );
5811:
5812:
5813: IF l_validation_status <> 0 THEN
5814: l_return_status := FND_API.G_RET_STS_ERROR;
5815: FND_MESSAGE.Set_Name('CSI', 'CSI_BATCH_VALIDATE');
5816: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from cz_network_api_pub.Validate, validation_status is: '||l_validation_status);
5817: FND_MSG_PUB.ADD;
5818: END IF;

Line 5821: l_return_status := FND_API.G_RET_STS_ERROR;

5817: FND_MSG_PUB.ADD;
5818: END IF;
5819:
5820: IF (l_html_pieces.COUNT <= 0) THEN
5821: l_return_status := FND_API.G_RET_STS_ERROR;
5822: FND_MESSAGE.Set_Name('CSI', 'CSI_BATCH_VALIDATE');
5823: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from cz_network_api_pub.Validate, html_pieces count is <= 0' );
5824: FND_MSG_PUB.ADD;
5825: END IF;

Line 5849: x_return_status := FND_API.G_RET_STS_ERROR;

5845: x_return_status := l_return_status;
5846: csi_gen_utility_pvt.put_line('Exiting csi_config_util.Send_input_xml');
5847: EXCEPTION
5848: WHEN OTHERS THEN
5849: x_return_status := FND_API.G_RET_STS_ERROR;
5850: csi_gen_utility_pvt.put_line( 'Inside Send_input_xml when others exception: ' ||substr(sqlerrm,1,100));
5851: END Send_input_xml;
5852:
5853: PROCEDURE Parse_output_xml

Line 5912: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

5908: l_selection_line_id NUMBER;
5909: l_valid_config VARCHAR2(10);
5910: l_complete_config VARCHAR2(10);
5911: l_header_id NUMBER;
5912: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
5913: l_return_status_del VARCHAR2(1);
5914: l_msg VARCHAR2(2000);
5915: l_constraint VARCHAR2(16);
5916: l_flag VARCHAR2(1) := 'N';

Line 6052: l_return_status:=FND_API.G_RET_STS_ERROR;

6048: /*
6049: IF nvl(l_valid_config, 'false') = 'false'
6050: OR l_exit = 'error'
6051: THEN
6052: l_return_status:=FND_API.G_RET_STS_ERROR;
6053: FND_MESSAGE.Set_Name('CSI', 'CSI_BATCH_VALIDATE');
6054: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from cz_network_api_pub.Validate, from Parse_output_xml ' );
6055: FND_MSG_PUB.ADD;
6056: csi_gen_utility_pvt.put_line('Configuration is invalid/incomplete');

Line 6075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6071: csi_gen_utility_pvt.put_line('Exiting parse_output_xml');
6072:
6073: EXCEPTION
6074: WHEN OTHERS THEN
6075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6076: csi_gen_utility_pvt.put_line( 'Parse_Output_xml error: ' || substr(sqlerrm,1,100));
6077:
6078: END Parse_output_xml;
6079:

Line 6090: IF nvl(p_eam_item_type,-99) <> FND_API.G_MISS_NUM

6086: RETURN BOOLEAN
6087: IS
6088: l_eam NUMBER;
6089: BEGIN
6090: IF nvl(p_eam_item_type,-99) <> FND_API.G_MISS_NUM
6091: THEN
6092: IF p_eam_item_type in (1,3) THEN
6093: RETURN TRUE;
6094: ELSE

Line 6160: RAISE fnd_api.g_exc_error;

6156: fnd_message.set_name('CSI','CSI_SRL_PENDING_IN_TLD');
6157: fnd_message.set_token('SRC_TBL', tld_rec.source_transaction_table);
6158: fnd_message.set_token('SRC_ID', tld_rec.source_transaction_id);
6159: fnd_msg_pub.add;
6160: RAISE fnd_api.g_exc_error;
6161: END IF;
6162: EXCEPTION
6163: WHEN OTHERS THEN
6164: fnd_message.set_name('CSI','CSI_SRL_PENDING_IN_TLD');

Line 6168: RAISE fnd_api.g_exc_error;

6164: fnd_message.set_name('CSI','CSI_SRL_PENDING_IN_TLD');
6165: fnd_message.set_token('SRC_TBL', tld_rec.source_transaction_table);
6166: fnd_message.set_token('SRC_ID', tld_rec.source_transaction_id);
6167: fnd_msg_pub.add;
6168: RAISE fnd_api.g_exc_error;
6169: END;
6170: -- End of Bug#12599234
6171: ELSE
6172: fnd_message.set_name('CSI','CSI_SRL_PENDING_IN_TLD');

Line 6176: RAISE fnd_api.g_exc_error;

6172: fnd_message.set_name('CSI','CSI_SRL_PENDING_IN_TLD');
6173: fnd_message.set_token('SRC_TBL', tld_rec.source_transaction_table);
6174: fnd_message.set_token('SRC_ID', tld_rec.source_transaction_id);
6175: fnd_msg_pub.add;
6176: RAISE fnd_api.g_exc_error;
6177: END IF;
6178: END LOOP;
6179:
6180: FOR oi_rec IN oi_cur

Line 6184: RAISE fnd_api.g_exc_error;

6180: FOR oi_rec IN oi_cur
6181: LOOP
6182: fnd_message.set_name('CSI','CSI_SRL_PENDING_IN_OI');
6183: fnd_msg_pub.add;
6184: RAISE fnd_api.g_exc_error;
6185: END LOOP;
6186:
6187: RETURN FALSE;
6188:

Line 6190: WHEN fnd_api.g_exc_error THEN

6186:
6187: RETURN FALSE;
6188:
6189: EXCEPTION
6190: WHEN fnd_api.g_exc_error THEN
6191: RETURN TRUE;
6192: END pending_in_oi_or_tld;
6193:
6194: PROCEDURE validate_serial_for_upd(

Line 6202: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

6198: x_return_status OUT nocopy varchar2)
6199: IS
6200:
6201: l_gen_object_id number;
6202: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6203: l_current_txn_id NUMBER; --uncommented code for 6965008
6204: l_rec_count NUMBER;
6205:
6206: l_current_status NUMBER; -- added for 6176621

Line 6242: x_return_status := fnd_api.g_ret_sts_success;

6238: AND ROWNUM = 1;
6239: --
6240: BEGIN
6241:
6242: x_return_status := fnd_api.g_ret_sts_success;
6243: csi_gen_utility_pvt.put_line('p_txn_rec.transaction_type_id : ' ||p_txn_rec.transaction_type_id);
6244: IF p_txn_rec.transaction_type_id not in (205,127,10082) THEN --Added condition and uncommented the code for bug 6965008
6245: IF p_txn_rec.inv_material_transaction_id IS NULL OR
6246: p_txn_rec.inv_material_transaction_id = FND_API.G_MISS_NUM THEN

Line 6246: p_txn_rec.inv_material_transaction_id = FND_API.G_MISS_NUM THEN

6242: x_return_status := fnd_api.g_ret_sts_success;
6243: csi_gen_utility_pvt.put_line('p_txn_rec.transaction_type_id : ' ||p_txn_rec.transaction_type_id);
6244: IF p_txn_rec.transaction_type_id not in (205,127,10082) THEN --Added condition and uncommented the code for bug 6965008
6245: IF p_txn_rec.inv_material_transaction_id IS NULL OR
6246: p_txn_rec.inv_material_transaction_id = FND_API.G_MISS_NUM THEN
6247: l_current_txn_id := -99999;
6248: ELSE
6249: l_current_txn_id := p_txn_rec.inv_material_transaction_id;
6250: END IF;

Line 6259: RAISE fnd_api.g_exc_error;

6255: fnd_message.set_name('CSI', 'CSI_SRL_IN_INT_CANNOT_UPD');
6256: fnd_message.set_token('INST_NUM', p_instance_rec.instance_number);
6257: fnd_message.set_token('LOC_TYPE_CODE', p_instance_rec.location_type_code);
6258: fnd_msg_pub.add;
6259: RAISE fnd_api.g_exc_error;
6260: END IF;
6261: END IF;
6262:
6263: -- Added the following IF to handle NULL to NOT NULL serial update

Line 6265: p_old_serial_number <> fnd_api.g_miss_char THEN

6261: END IF;
6262:
6263: -- Added the following IF to handle NULL to NOT NULL serial update
6264: IF p_old_serial_number IS NOT NULL AND
6265: p_old_serial_number <> fnd_api.g_miss_char THEN
6266:
6267: IF p_txn_rec.transaction_type_id not in (205,127,10082) THEN --Added condition and uncommented the code for bug 6965008
6268: -- check for existence in mut and error
6269: FOR all_txn_rec IN all_txn_cur(p_instance_rec.inventory_item_id,p_old_serial_number,-9999)

Line 6274: RAISE fnd_api.g_exc_error;

6270: LOOP
6271: fnd_message.set_name('CSI', 'CSI_OLD_SRL_HAS_TXN_CANNOT_UPD');
6272: fnd_message.set_token('SERIAL_NUM', p_old_serial_number);
6273: fnd_msg_pub.add;
6274: RAISE fnd_api.g_exc_error;
6275: END LOOP;
6276:
6277: --uncommented the code and brought the code up for bug 6965008
6278:

Line 6304: RAISE fnd_api.g_exc_error;

6300: IF l_rec_count > 0 THEN
6301: fnd_message.set_name('CSI', 'CSI_OLD_SRL_HAS_EAM_CANNOT_UPD');
6302: fnd_message.set_token('SERIAL_NUM', p_old_serial_number);
6303: fnd_msg_pub.add;
6304: RAISE fnd_api.g_exc_error;
6305: END IF;
6306: END IF;
6307:
6308: BEGIN

Line 6321: RAISE fnd_api.g_exc_error;

6317: IF l_current_status <> 4 THEN
6318: fnd_message.set_name('CSI', 'CSI_SRL_IN_USE_CANNOT_UPD');
6319: fnd_message.set_token('SERIAL_NUM',p_old_serial_number);
6320: fnd_msg_pub.add;
6321: RAISE fnd_api.g_exc_error;
6322: END IF;
6323: --code fix end for 6176621
6324: --
6325: FOR mog_rec IN mog_cur(l_gen_object_id)

Line 6330: RAISE fnd_api.g_exc_error;

6326: LOOP
6327: fnd_message.set_name('CSI', 'CSI_SRL_IN_MOG_CANNOT_UPD');
6328: fnd_message.set_token('SERIAL_NUM',p_old_serial_number);
6329: fnd_msg_pub.add;
6330: RAISE fnd_api.g_exc_error;
6331: END LOOP;
6332:
6333: -- check pending transaction in open interface and installation detail references
6334: IF pending_in_oi_or_tld(p_instance_rec.inventory_item_id, p_old_serial_number) THEN

Line 6335: RAISE fnd_api.g_exc_error;

6331: END LOOP;
6332:
6333: -- check pending transaction in open interface and installation detail references
6334: IF pending_in_oi_or_tld(p_instance_rec.inventory_item_id, p_old_serial_number) THEN
6335: RAISE fnd_api.g_exc_error;
6336: END IF;
6337: --
6338: EXCEPTION
6339: WHEN no_data_found THEN

Line 6354: IF nvl(p_old_serial_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char

6350: -- we should ignore the current material transaction as the current txn is one that is updating it.
6351: -- Whenever we filter the serial records based on transaction_id, we cannot use MUT always.
6352: -- If the item is lot-serial controlled then it needs to be joined with MTLN.
6353: --
6354: IF nvl(p_old_serial_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char
6355: AND p_txn_rec.transaction_type_id not in (205,127,10082) --Added condition and uncommented the code for bug 6965008
6356: THEN
6357: FOR all_txn_rec IN all_txn_cur(p_instance_rec.inventory_item_id,
6358: p_instance_rec.serial_number,

Line 6364: RAISE fnd_api.g_exc_error;

6360: LOOP
6361: fnd_message.set_name('CSI', 'CSI_SRL_HAS_TXN_CANNOT_UPD');
6362: fnd_message.set_token('SERIAL_NUM', p_instance_rec.serial_number);
6363: fnd_msg_pub.add;
6364: RAISE fnd_api.g_exc_error;
6365: END LOOP;
6366: END IF;
6367: ----uncommented code for 6965008
6368: fnd_message.set_name('CSI', 'CSI_SERIAL_UPD_WARNING');

Line 6376: WHEN fnd_api.g_exc_error THEN

6372: --
6373: -- Warning Status should be handled by Public API based ont Serial Number Update Event
6374: -- x_return_status := 'W';
6375: EXCEPTION
6376: WHEN fnd_api.g_exc_error THEN
6377: x_return_status := fnd_api.g_ret_sts_error;
6378: END validate_serial_for_upd;
6379: --
6380: /*-----------------------------------------------------------*/

Line 6377: x_return_status := fnd_api.g_ret_sts_error;

6373: -- Warning Status should be handled by Public API based ont Serial Number Update Event
6374: -- x_return_status := 'W';
6375: EXCEPTION
6376: WHEN fnd_api.g_exc_error THEN
6377: x_return_status := fnd_api.g_ret_sts_error;
6378: END validate_serial_for_upd;
6379: --
6380: /*-----------------------------------------------------------*/
6381: /* This function gets the version label of an item instance */

Line 6401: p_time_stamp = FND_API.G_MISS_DATE THEN

6397: and date_time_stamp <= l_time_stamp
6398: order by date_time_stamp desc;
6399: BEGIN
6400: IF p_time_stamp IS NULL OR
6401: p_time_stamp = FND_API.G_MISS_DATE THEN
6402: l_time_stamp := sysdate + 1;
6403: ELSE
6404: l_time_stamp := p_time_stamp;
6405: END IF;

Line 6464: raise fnd_api.g_exc_error;

6460:
6461: IF l_txn_seq_start_date is null THEN
6462: fnd_message.set_name('CSI','CSI_API_UNINSTALLED_PARAMETER');
6463: fnd_msg_pub.add;
6464: raise fnd_api.g_exc_error;
6465: END IF;
6466:
6467: FOR unit_txn_rec IN unit_txn_cur
6468: LOOP