460: csi_gen_utility_pvt.put_line (' Bom explosion error code > 0 '|| l_Error_Code ||' '||l_err_msg);
461: ELSIF l_Error_Code > 0 THEN
462: csi_gen_utility_pvt.put_line (' Bom explosion error code < 0'|| l_Error_Code ||' '||l_err_msg);
463: END IF;
464: FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');
465: FND_MSG_PUB.Add;
466: l_return_status := FALSE;
467: RETURN l_return_status;
468: END IF;
1199: l_nearest_full_dump := l_time_stamp;
1200: -- If the user chooses a date before the creation date of the instance
1201: -- then raise an error
1202: IF p_time_stamp < l_time_stamp THEN
1203: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
1204: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1205: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;
1200: -- If the user chooses a date before the creation date of the instance
1201: -- then raise an error
1202: IF p_time_stamp < l_time_stamp THEN
1203: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
1204: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1205: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;
1201: -- then raise an error
1202: IF p_time_stamp < l_time_stamp THEN
1203: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
1204: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1205: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;
1209: END IF;
1838: FROM hr_all_organization_units
1839: WHERE organization_id = x_instance_rec.vld_organization_id;
1840: EXCEPTION
1841: WHEN NO_DATA_FOUND THEN
1842: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
1843: fnd_message.set_token('ORGANIZATION_ID',x_instance_rec.vld_organization_id);
1844: fnd_msg_pub.ADD;
1845: RAISE fnd_api.g_exc_error;
1846: END;
1839: WHERE organization_id = x_instance_rec.vld_organization_id;
1840: EXCEPTION
1841: WHEN NO_DATA_FOUND THEN
1842: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
1843: fnd_message.set_token('ORGANIZATION_ID',x_instance_rec.vld_organization_id);
1844: fnd_msg_pub.ADD;
1845: RAISE fnd_api.g_exc_error;
1846: END;
1847: END IF;
4731: (p_instance_rec.inv_master_organization_id <> FND_API.G_MISS_NUM))
4732: THEN
4733: IF NOT (csi_Item_Instance_Vld_Pvt.Is_Valid_Master_Org
4734: (p_instance_rec.inv_master_organization_id)) THEN
4735: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_MAST_ORG');
4736: FND_MSG_PUB.Add;
4737: RAISE FND_API.G_EXC_ERROR;
4738: END IF;
4739: p_instance_rec.vld_organization_id := p_instance_rec.inv_master_organization_id;
4751: WHERE organization_id = p_instance_rec.vld_organization_id
4752: AND master_organization_id = p_instance_rec.inv_master_organization_id;
4753: EXCEPTION
4754: WHEN NO_DATA_FOUND THEN
4755: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_VLD_MAST_COMB');
4756: FND_MSG_PUB.Add;
4757: RAISE FND_API.G_EXC_ERROR;
4758: END;
4759: ELSE
4756: FND_MSG_PUB.Add;
4757: RAISE FND_API.G_EXC_ERROR;
4758: END;
4759: ELSE
4760: FND_MESSAGE.SET_NAME('CSI','CSI_NO_VLD_ORG');
4761: FND_MSG_PUB.Add;
4762: RAISE FND_API.G_EXC_ERROR;
4763: END IF;
4764: -- End of modifications by sk on 02/19/02 for bug 2198575
4797: FROM hr_all_organization_units
4798: WHERE organization_id = p_instance_rec.vld_organization_id;
4799: EXCEPTION
4800: WHEN NO_DATA_FOUND THEN
4801: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4802: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4803: fnd_msg_pub.ADD;
4804: RAISE fnd_api.g_exc_error;
4805: END;
4798: WHERE organization_id = p_instance_rec.vld_organization_id;
4799: EXCEPTION
4800: WHEN NO_DATA_FOUND THEN
4801: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4802: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4803: fnd_msg_pub.ADD;
4804: RAISE fnd_api.g_exc_error;
4805: END;
4806: IF p_instance_rec.location_id IS NULL
4804: RAISE fnd_api.g_exc_error;
4805: END;
4806: IF p_instance_rec.location_id IS NULL
4807: THEN
4808: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4809: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4810: fnd_msg_pub.ADD;
4811: RAISE fnd_api.g_exc_error;
4812: END IF;
4805: END;
4806: IF p_instance_rec.location_id IS NULL
4807: THEN
4808: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4809: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4810: fnd_msg_pub.ADD;
4811: RAISE fnd_api.g_exc_error;
4812: END IF;
4813: END IF;
4824: FROM hr_all_organization_units
4825: WHERE organization_id = p_instance_rec.vld_organization_id;
4826: EXCEPTION
4827: WHEN NO_DATA_FOUND THEN
4828: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4829: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4830: fnd_msg_pub.ADD;
4831: RAISE fnd_api.g_exc_error;
4832: END;
4825: WHERE organization_id = p_instance_rec.vld_organization_id;
4826: EXCEPTION
4827: WHEN NO_DATA_FOUND THEN
4828: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4829: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4830: fnd_msg_pub.ADD;
4831: RAISE fnd_api.g_exc_error;
4832: END;
4833: IF p_instance_rec.install_location_id IS NULL
4831: RAISE fnd_api.g_exc_error;
4832: END;
4833: IF p_instance_rec.install_location_id IS NULL
4834: THEN
4835: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4836: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4837: fnd_msg_pub.ADD;
4838: RAISE fnd_api.g_exc_error;
4839: END IF;
4832: END;
4833: IF p_instance_rec.install_location_id IS NULL
4834: THEN
4835: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4836: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4837: fnd_msg_pub.ADD;
4838: RAISE fnd_api.g_exc_error;
4839: END IF;
4840: END IF;
4879: END IF;
4880: END LOOP;
4881: IF l_valid_flag <> 'Y'
4882: THEN
4883: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4884: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4885: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4886: FND_MSG_PUB.Add;
4887: RAISE fnd_api.g_exc_error;
4880: END LOOP;
4881: IF l_valid_flag <> 'Y'
4882: THEN
4883: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4884: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4885: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4886: FND_MSG_PUB.Add;
4887: RAISE fnd_api.g_exc_error;
4888: END IF;
4881: IF l_valid_flag <> 'Y'
4882: THEN
4883: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4884: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4885: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4886: FND_MSG_PUB.Add;
4887: RAISE fnd_api.g_exc_error;
4888: END IF;
4889: END IF;
4909: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'Y';
4910: Exception
4911: when others then
4912: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4913: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4914: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4915: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4916: FND_MSG_PUB.Add;
4917: RAISE fnd_api.g_exc_error;
4910: Exception
4911: when others then
4912: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4913: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4914: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4915: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4916: FND_MSG_PUB.Add;
4917: RAISE fnd_api.g_exc_error;
4918: End;
4911: when others then
4912: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4913: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4914: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4915: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4916: FND_MSG_PUB.Add;
4917: RAISE fnd_api.g_exc_error;
4918: End;
4919: --
4946: p_item_attribute_tbl(p_ins_count_rec.inv_count).equipment_type := l_equipment_type;
4947: EXCEPTION
4948: WHEN OTHERS THEN
4949: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4950: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4951: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4952: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4953: FND_MSG_PUB.Add;
4954: RAISE fnd_api.g_exc_error;
4947: EXCEPTION
4948: WHEN OTHERS THEN
4949: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4950: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4951: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4952: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4953: FND_MSG_PUB.Add;
4954: RAISE fnd_api.g_exc_error;
4955: END;
4948: WHEN OTHERS THEN
4949: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4950: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4951: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4952: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4953: FND_MSG_PUB.Add;
4954: RAISE fnd_api.g_exc_error;
4955: END;
4956: End if;
5047: ,x_reason_failed => l_reason_failed
5048: ,x_token => l_token
5049: )
5050: THEN
5051: -- FND_MESSAGE.SET_NAME('CSI', l_reason_failed); -- commented for bug 5351886
5052: -- FND_MSG_PUB.Add; -- commented for bug 5351886
5053: csi_gen_utility_pvt.put_line('Call to eam_assetnumber_pub.validate_fields failed with following reason');
5054: csi_gen_utility_pvt.put_line(l_reason_failed);
5055: RAISE FND_API.G_EXC_ERROR;
5054: csi_gen_utility_pvt.put_line(l_reason_failed);
5055: RAISE FND_API.G_EXC_ERROR;
5056: END IF;
5057: ELSE
5058: FND_MESSAGE.SET_NAME('CSI', 'CSI_NON_EAM_ITEM');
5059: FND_MSG_PUB.Add;
5060: RAISE FND_API.G_EXC_ERROR;
5061: END IF;
5062: END IF;
5242: -- Validation for Location Source and Location ID
5243: IF p_instance_rec.location_type_code = FND_API.G_MISS_CHAR OR
5244: p_instance_rec.location_type_code IS NULL THEN
5245: IF p_instance_rec.creation_complete_flag = 'Y' THEN
5246: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOCATION');
5247: FND_MSG_PUB.ADD;
5248: RAISE fnd_api.g_exc_error;
5249: ELSE
5250: p_instance_rec.creation_complete_flag := 'N';
5251: END IF;
5252: ELSE
5253: IF p_instance_rec.location_id IS NULL OR
5254: p_instance_rec.location_id = FND_API.G_MISS_NUM THEN
5255: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
5256: FND_MSG_PUB.ADD;
5257: RAISE fnd_api.g_exc_error;
5258: ELSE
5259: -- Validate location_id
5270: END IF;
5271: End Loop;
5272: --
5273: IF l_valid_flag <> 'Y' THEN
5274: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
5275: FND_MSG_PUB.ADD;
5276: RAISE fnd_api.g_exc_error;
5277: END IF;
5278: END IF; -- p_location_tbl count
5325: RAISE fnd_api.g_exc_error;
5326: END IF;
5327: --validation for accounting classification_code
5328: IF (p_party_tbl.count < 1) THEN
5329: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_PARTY_RECORD');
5330: FND_MSG_PUB.Add;
5331: RAISE FND_API.G_EXC_ERROR;
5332: ELSE
5333: FOR l_count IN p_party_tbl.FIRST..p_party_tbl.LAST LOOP
5338: END IF;
5339: END IF;
5340: END LOOP;
5341: IF l_owner_count <> 1 THEN
5342: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_EXISTS');
5343: FND_MESSAGE.SET_TOKEN('OWNER',l_owner);
5344: FND_MSG_PUB.Add;
5345: RAISE fnd_api.g_exc_error;
5346: END IF;
5339: END IF;
5340: END LOOP;
5341: IF l_owner_count <> 1 THEN
5342: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_EXISTS');
5343: FND_MESSAGE.SET_TOKEN('OWNER',l_owner);
5344: FND_MSG_PUB.Add;
5345: RAISE fnd_api.g_exc_error;
5346: END IF;
5347: --
5351: --
5352: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5353: --
5354: IF l_int_party_id IS NULL THEN
5355: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5356: FND_MSG_PUB.ADD;
5357: RAISE FND_API.G_EXC_ERROR;
5358: END IF;
5359: --
5381: p_instance_rec.accounting_class_code := 'CUST_PROD';
5382: ELSE
5383: IF ((p_instance_rec.accounting_class_code = 'WIP') OR
5384: (p_instance_rec.accounting_class_code = 'PROJECT')) THEN
5385: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_CLASS');
5386: FND_MSG_PUB.Add;
5387: RAISE FND_API.G_EXC_ERROR;
5388: END IF;
5389: END IF;
5429: IF ((p_instance_rec.active_start_date IS NOT NULL) AND
5430: (p_instance_rec.active_start_date <> FND_API.G_MISS_DATE)) AND
5431: (p_instance_rec.active_start_date > SYSDATE)
5432: THEN
5433: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_START_DATE');
5434: FND_MSG_PUB.Add;
5435: RAISE FND_API.G_EXC_ERROR;
5436: END IF;
5437:
5459: END IF;
5460: END LOOP;
5461: --
5462: IF l_valid_flag <> 'Y' THEN
5463: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM_CONDITION');
5464: FND_MESSAGE.SET_TOKEN('INSTANCE_CONDITION_ID',p_instance_rec.instance_condition_id);
5465: FND_MSG_PUB.Add;
5466: RAISE fnd_api.g_exc_error;
5467: END IF;
5460: END LOOP;
5461: --
5462: IF l_valid_flag <> 'Y' THEN
5463: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM_CONDITION');
5464: FND_MESSAGE.SET_TOKEN('INSTANCE_CONDITION_ID',p_instance_rec.instance_condition_id);
5465: FND_MSG_PUB.Add;
5466: RAISE fnd_api.g_exc_error;
5467: END IF;
5468: END IF;
5499: FROM csi_instance_statuses
5500: WHERE name = l_instance_status;
5501: --
5502: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5503: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5504: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5505: FND_MSG_PUB.Add;
5506: RAISE FND_API.G_EXC_ERROR;
5507: END IF;
5500: WHERE name = l_instance_status;
5501: --
5502: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5503: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5504: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5505: FND_MSG_PUB.Add;
5506: RAISE FND_API.G_EXC_ERROR;
5507: END IF;
5508: EXCEPTION
5506: RAISE FND_API.G_EXC_ERROR;
5507: END IF;
5508: EXCEPTION
5509: WHEN NO_DATA_FOUND THEN
5510: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5511: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5512: FND_MSG_PUB.Add;
5513: RAISE FND_API.G_EXC_ERROR;
5514: END;
5507: END IF;
5508: EXCEPTION
5509: WHEN NO_DATA_FOUND THEN
5510: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5511: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5512: FND_MSG_PUB.Add;
5513: RAISE FND_API.G_EXC_ERROR;
5514: END;
5515: ELSIF (p_instance_rec.instance_status_id = 1) THEN
5512: FND_MSG_PUB.Add;
5513: RAISE FND_API.G_EXC_ERROR;
5514: END;
5515: ELSIF (p_instance_rec.instance_status_id = 1) THEN
5516: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5517: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5518: FND_MSG_PUB.Add;
5519: RAISE FND_API.G_EXC_ERROR;
5520: ELSE
5513: RAISE FND_API.G_EXC_ERROR;
5514: END;
5515: ELSIF (p_instance_rec.instance_status_id = 1) THEN
5516: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5517: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5518: FND_MSG_PUB.Add;
5519: RAISE FND_API.G_EXC_ERROR;
5520: ELSE
5521: IF p_generic_id_tbl.count > 0 THEN
5530: END IF;
5531: END LOOP;
5532: --
5533: IF l_valid_flag <> 'Y' THEN
5534: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5535: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5536: FND_MSG_PUB.Add;
5537: RAISE FND_API.G_EXC_ERROR;
5538: END IF;
5531: END LOOP;
5532: --
5533: IF l_valid_flag <> 'Y' THEN
5534: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5535: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5536: FND_MSG_PUB.Add;
5537: RAISE FND_API.G_EXC_ERROR;
5538: END IF;
5539: --
5537: RAISE FND_API.G_EXC_ERROR;
5538: END IF;
5539: --
5540: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5541: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5542: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5543: FND_MSG_PUB.Add;
5544: RAISE FND_API.G_EXC_ERROR;
5545: END IF;
5538: END IF;
5539: --
5540: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5541: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5542: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5543: FND_MSG_PUB.Add;
5544: RAISE FND_API.G_EXC_ERROR;
5545: END IF;
5546: END IF;
5558: p_generic_id_tbl(p_ins_count_rec.generic_count).valid_flag := 'Y';
5559: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := l_terminated_flag;
5560: --
5561: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5562: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5563: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5564: FND_MSG_PUB.Add;
5565: RAISE FND_API.G_EXC_ERROR;
5566: END IF;
5559: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := l_terminated_flag;
5560: --
5561: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5562: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5563: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5564: FND_MSG_PUB.Add;
5565: RAISE FND_API.G_EXC_ERROR;
5566: END IF;
5567: Exception
5567: Exception
5568: when others then
5569: p_generic_id_tbl(p_ins_count_rec.generic_count).valid_flag := 'N';
5570: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := NULL;
5571: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5572: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5573: FND_MSG_PUB.Add;
5574: RAISE FND_API.G_EXC_ERROR;
5575: End;
5568: when others then
5569: p_generic_id_tbl(p_ins_count_rec.generic_count).valid_flag := 'N';
5570: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := NULL;
5571: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5572: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5573: FND_MSG_PUB.Add;
5574: RAISE FND_API.G_EXC_ERROR;
5575: End;
5576: END IF;
5592: END IF;
5593: END LOOP;
5594: --
5595: IF l_valid_flag <> 'Y' THEN
5596: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SYSTEM_ID');
5597: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_instance_rec.system_id);
5598: FND_MSG_PUB.Add;
5599: RAISE fnd_api.g_exc_error;
5600: END IF;
5593: END LOOP;
5594: --
5595: IF l_valid_flag <> 'Y' THEN
5596: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SYSTEM_ID');
5597: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_instance_rec.system_id);
5598: FND_MSG_PUB.Add;
5599: RAISE fnd_api.g_exc_error;
5600: END IF;
5601: END IF;
5630: END IF;
5631: END LOOP;
5632: --
5633: IF l_valid_flag <> 'Y' THEN
5634: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_TYPE');
5635: FND_MESSAGE.SET_TOKEN('INSTANCE_TYPE_CODE',p_instance_rec.instance_type_code);
5636: FND_MSG_PUB.Add;
5637: RAISE fnd_api.g_exc_error;
5638: END IF;
5631: END LOOP;
5632: --
5633: IF l_valid_flag <> 'Y' THEN
5634: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_TYPE');
5635: FND_MESSAGE.SET_TOKEN('INSTANCE_TYPE_CODE',p_instance_rec.instance_type_code);
5636: FND_MSG_PUB.Add;
5637: RAISE fnd_api.g_exc_error;
5638: END IF;
5639: END IF;
5667: END IF;
5668: End Loop;
5669: --
5670: if l_valid_flag <> 'Y' then
5671: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_USAGE_CODE');
5672: FND_MESSAGE.SET_TOKEN('INSTANCE_USAGE_CODE',p_instance_rec.instance_usage_code);
5673: FND_MSG_PUB.Add;
5674: RAISE fnd_api.g_exc_error;
5675: end if;
5668: End Loop;
5669: --
5670: if l_valid_flag <> 'Y' then
5671: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_USAGE_CODE');
5672: FND_MESSAGE.SET_TOKEN('INSTANCE_USAGE_CODE',p_instance_rec.instance_usage_code);
5673: FND_MSG_PUB.Add;
5674: RAISE fnd_api.g_exc_error;
5675: end if;
5676: End if;
5706: END IF;
5707: End Loop;
5708: --
5709: if l_valid_flag <> 'Y' then
5710: FND_MESSAGE.SET_NAME('CSI','CSI_OPERATIONAL_STATUS_CODE');
5711: FND_MESSAGE.SET_TOKEN('OPERATIONAL_STATUS_CODE',p_instance_rec.operational_status_code);
5712: FND_MSG_PUB.Add;
5713: RAISE fnd_api.g_exc_error;
5714: end if;
5707: End Loop;
5708: --
5709: if l_valid_flag <> 'Y' then
5710: FND_MESSAGE.SET_NAME('CSI','CSI_OPERATIONAL_STATUS_CODE');
5711: FND_MESSAGE.SET_TOKEN('OPERATIONAL_STATUS_CODE',p_instance_rec.operational_status_code);
5712: FND_MSG_PUB.Add;
5713: RAISE fnd_api.g_exc_error;
5714: end if;
5715: End if;
5838: (p_instance_rec.sales_unit_price IS NOT NULL AND
5839: p_instance_rec.sales_unit_price <> FND_API.G_MISS_NUM))
5840: )
5841: THEN
5842: FND_MESSAGE.SET_NAME('CSI','CSI_NO_PRICE_OR_CODE');
5843: FND_MSG_PUB.Add;
5844: RAISE fnd_api.g_exc_error;
5845: END IF;
5846: -- End addition of columns for FA Integration
5926: p_instance_rec.install_location_type_code = 'HR_LOCATIONS'
5927: THEN
5928: IF p_instance_rec.install_location_id IS NULL OR
5929: p_instance_rec.install_location_id = FND_API.G_MISS_NUM THEN
5930: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
5931: FND_MSG_PUB.ADD;
5932: RAISE fnd_api.g_exc_error;
5933: END IF;
5934: --
5945: END IF;
5946: End Loop;
5947: --
5948: IF l_valid_flag <> 'Y' THEN
5949: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
5950: FND_MSG_PUB.ADD;
5951: RAISE fnd_api.g_exc_error;
5952: END IF;
5953: END IF;
5969: RAISE fnd_api.g_exc_error;
5970: END IF;
5971: END IF;
5972: ELSE
5973: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
5974: FND_MSG_PUB.Add;
5975: RAISE FND_API.G_EXC_ERROR;
5976: END IF;
5977: END IF;
6154: );
6155:
6156: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
6157: THEN
6158: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6159: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6160: FND_MSG_PUB.Add;
6161: RAISE FND_API.G_EXC_ERROR;
6162: END IF;
6155:
6156: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
6157: THEN
6158: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6159: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6160: FND_MSG_PUB.Add;
6161: RAISE FND_API.G_EXC_ERROR;
6162: END IF;
6163: -- srramakr Bug # 2255391. In CTO, since the configured item is created as a part of Sales Order
6219: ,x_ctr_grp_id_instance => l_ctr_grp_id_instance
6220: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
6221: );
6222: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6223: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6224: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6225: FND_MSG_PUB.Add;
6226: RAISE FND_API.G_EXC_ERROR;
6227: END IF; -- return status
6220: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
6221: );
6222: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6223: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6224: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6225: FND_MSG_PUB.Add;
6226: RAISE FND_API.G_EXC_ERROR;
6227: END IF; -- return status
6228: END IF; -- ctr. grp template exists1
6267: ,x_msg_data => x_msg_data
6268: );
6269:
6270: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6271: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
6272: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
6273: FND_MSG_PUB.Add;
6274: RAISE FND_API.G_EXC_ERROR;
6275: END IF;
6268: );
6269:
6270: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6271: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
6272: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
6273: FND_MSG_PUB.Add;
6274: RAISE FND_API.G_EXC_ERROR;
6275: END IF;
6276:
6499: );
6500:
6501:
6502: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6503: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_HISTORY');
6504: FND_MSG_PUB.Add;
6505: RAISE FND_API.G_EXC_ERROR;
6506: END IF;
6507:
6884: FROM csi_item_instances
6885: WHERE instance_id = l_instance_rec.instance_id;
6886: EXCEPTION
6887: WHEN NO_DATA_FOUND THEN
6888: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_NUM');
6889: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', l_instance_rec.instance_id);
6890: FND_MSG_PUB.Add;
6891: RAISE FND_API.G_EXC_ERROR;
6892: END;
6885: WHERE instance_id = l_instance_rec.instance_id;
6886: EXCEPTION
6887: WHEN NO_DATA_FOUND THEN
6888: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_NUM');
6889: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', l_instance_rec.instance_id);
6890: FND_MSG_PUB.Add;
6891: RAISE FND_API.G_EXC_ERROR;
6892: END;
6893:
7449: --
7450: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7451: --
7452: IF l_internal_party_id IS NULL THEN
7453: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
7454: FND_MSG_PUB.ADD;
7455: RAISE FND_API.G_EXC_ERROR;
7456: END IF;
7457: --
7495: x_msg_data => x_msg_data
7496: );
7497: --
7498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7499: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
7500: FND_MSG_PUB.Add;
7501: RAISE FND_API.G_EXC_ERROR;
7502: END IF;
7503: ELSE
7515: x_msg_data => x_msg_data
7516: );
7517: --
7518: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7519: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
7520: FND_MSG_PUB.Add;
7521: RAISE FND_API.G_EXC_ERROR;
7522: END IF;
7523: END IF;
7534: -- Opening Cursor to retrieve Child Id records Details
7535: OPEN curr_instance_rec(l_rel_tbl(j).subject_id);
7536: FETCH curr_instance_rec INTO l_curr_instance_rec;
7537: IF curr_instance_rec%NOTFOUND THEN
7538: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
7539: FND_MSG_PUB.ADD;
7540: RAISE FND_API.G_EXC_ERROR;
7541: END IF;
7542: CLOSE curr_instance_rec;
7785: --
7786: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
7787: --
7788: IF l_full_dump_frequency IS NULL THEN
7789: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
7790: FND_MSG_PUB.ADD;
7791: RAISE FND_API.G_EXC_ERROR;
7792: END IF;
7793: --
9996: -- Opening New Cursor to retrieve Child Id records Details
9997: OPEN new_instance_rec(l_rel_tbl(j).subject_id);
9998: FETCH new_instance_rec INTO l_new_instance_rec;
9999: IF new_instance_rec%NOTFOUND THEN
10000: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
10001: FND_MSG_PUB.ADD;
10002: RAISE FND_API.G_EXC_ERROR;
10003: END IF;
10004: CLOSE new_instance_rec;
10840: --
10841: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
10842: --
10843: IF l_internal_party_id IS NULL THEN
10844: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
10845: FND_MSG_PUB.ADD;
10846: RAISE FND_API.G_EXC_ERROR;
10847: END IF;
10848: --
10944:
10945: IF l_txn_exists IS NOT NULL AND p_txn_type_id <> 53 --End of:Added for bug 5615162
10946: THEN
10947: x_return_status := fnd_api.g_ret_sts_error ;
10948: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
10949: fnd_message.set_token('INSTANCE_ID',p_instance_id );
10950: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
10951: fnd_msg_pub.add;
10952: RAISE fnd_api.g_exc_error;
10945: IF l_txn_exists IS NOT NULL AND p_txn_type_id <> 53 --End of:Added for bug 5615162
10946: THEN
10947: x_return_status := fnd_api.g_ret_sts_error ;
10948: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
10949: fnd_message.set_token('INSTANCE_ID',p_instance_id );
10950: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
10951: fnd_msg_pub.add;
10952: RAISE fnd_api.g_exc_error;
10953: END IF;
10946: THEN
10947: x_return_status := fnd_api.g_ret_sts_error ;
10948: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
10949: fnd_message.set_token('INSTANCE_ID',p_instance_id );
10950: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
10951: fnd_msg_pub.add;
10952: RAISE fnd_api.g_exc_error;
10953: END IF;
10954: EXCEPTION
10959: END;
10960: ELSIF (( p_source_transaction_date IS NOT NULL) AND (p_source_transaction_date > SYSDATE)) AND
10961: p_source_transaction_date <> fnd_api.g_miss_date THEN
10962: x_return_status := fnd_api.g_ret_sts_error ;
10963: fnd_message.set_name('CSI', 'CSI_PASS_TXNS_GT_SYS');
10964: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
10965: fnd_msg_pub.add;
10966: RAISE fnd_api.g_exc_error;
10967: END IF;
10960: ELSIF (( p_source_transaction_date IS NOT NULL) AND (p_source_transaction_date > SYSDATE)) AND
10961: p_source_transaction_date <> fnd_api.g_miss_date THEN
10962: x_return_status := fnd_api.g_ret_sts_error ;
10963: fnd_message.set_name('CSI', 'CSI_PASS_TXNS_GT_SYS');
10964: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
10965: fnd_msg_pub.add;
10966: RAISE fnd_api.g_exc_error;
10967: END IF;
10968: p_oks_txn_inst_tbl(J).transfer_date := l_transaction_date;
11232: AND transaction_id <> p_transaction_id
11233: AND ROWNUM=1;
11234: IF l_temp IS NOT NULL THEN
11235: x_return_status := fnd_api.g_ret_sts_error ;
11236: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11237: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11238: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11239: fnd_msg_pub.add;
11240: RAISE fnd_api.g_exc_error;
11233: AND ROWNUM=1;
11234: IF l_temp IS NOT NULL THEN
11235: x_return_status := fnd_api.g_ret_sts_error ;
11236: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11237: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11238: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11239: fnd_msg_pub.add;
11240: RAISE fnd_api.g_exc_error;
11241: END IF;
11234: IF l_temp IS NOT NULL THEN
11235: x_return_status := fnd_api.g_ret_sts_error ;
11236: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11237: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11238: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11239: fnd_msg_pub.add;
11240: RAISE fnd_api.g_exc_error;
11241: END IF;
11242: EXCEPTION
11247: END;
11248: ELSIF (( p_source_transaction_date IS NOT NULL) AND (p_source_transaction_date > SYSDATE)) AND
11249: p_source_transaction_date <> fnd_api.g_miss_date THEN
11250: x_return_status := fnd_api.g_ret_sts_error ;
11251: fnd_message.set_name('CSI', 'CSI_PASS_TXNS_GT_SYS');
11252: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11253: fnd_msg_pub.add;
11254: RAISE fnd_api.g_exc_error;
11255: END IF;
11248: ELSIF (( p_source_transaction_date IS NOT NULL) AND (p_source_transaction_date > SYSDATE)) AND
11249: p_source_transaction_date <> fnd_api.g_miss_date THEN
11250: x_return_status := fnd_api.g_ret_sts_error ;
11251: fnd_message.set_name('CSI', 'CSI_PASS_TXNS_GT_SYS');
11252: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11253: fnd_msg_pub.add;
11254: RAISE fnd_api.g_exc_error;
11255: END IF;
11256: p_oks_txn_inst_tbl(l_oks_txn_count).transfer_date := l_transaction_date;
11304: EXCEPTION
11305: WHEN fnd_api.g_exc_error THEN
11306: RAISE fnd_api.g_exc_error;
11307: WHEN OTHERS THEN
11308: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
11309: FND_MESSAGE.Set_Token('API_NAME', 'Call_to_Contracts');
11310: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
11311: FND_MSG_PUB.Add;
11312: RAISE fnd_api.g_exc_error;
11305: WHEN fnd_api.g_exc_error THEN
11306: RAISE fnd_api.g_exc_error;
11307: WHEN OTHERS THEN
11308: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
11309: FND_MESSAGE.Set_Token('API_NAME', 'Call_to_Contracts');
11310: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
11311: FND_MSG_PUB.Add;
11312: RAISE fnd_api.g_exc_error;
11313: END Call_to_Contracts;
11306: RAISE fnd_api.g_exc_error;
11307: WHEN OTHERS THEN
11308: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
11309: FND_MESSAGE.Set_Token('API_NAME', 'Call_to_Contracts');
11310: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
11311: FND_MSG_PUB.Add;
11312: RAISE fnd_api.g_exc_error;
11313: END Call_to_Contracts;
11314:
11952: -- in the database else raise error
11953: OPEN curr_instance_rec(p_instance_rec.INSTANCE_ID);
11954: FETCH curr_instance_rec INTO l_curr_instance_rec;
11955: IF (l_curr_instance_rec.object_version_number <> nvl(p_instance_rec.OBJECT_VERSION_NUMBER,0)) THEN
11956: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
11957: FND_MSG_PUB.ADD;
11958: RAISE FND_API.G_EXC_ERROR;
11959: END IF;
11960: CLOSE curr_instance_rec;
11995: (l_lock_status = 0)
11996: THEN
11997: NULL;
11998: ELSE
11999: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_LOCKED');
12000: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
12001: FND_MSG_PUB.ADD;
12002: RAISE FND_API.G_EXC_ERROR;
12003: END IF;
11996: THEN
11997: NULL;
11998: ELSE
11999: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_LOCKED');
12000: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
12001: FND_MSG_PUB.ADD;
12002: RAISE FND_API.G_EXC_ERROR;
12003: END IF;
12004: END IF;
12142: IF l_get_instance_rec.location_type_code <> 'INVENTORY' AND
12143: l_cur_instance_rec.last_vld_organization_id <> l_get_instance_rec.vld_organization_id
12144: AND l_curr_instance_rec.instance_usage_code <> 'IN_TRANSIT' --Added for bug 6188180
12145: THEN
12146: FND_MESSAGE.Set_Name('CSI', 'CSI_CANNOT_MODIFY_VLD_ORG');
12147: FND_MSG_PUB.ADD;
12148: RAISE FND_API.G_EXC_ERROR;
12149: END IF;
12150:
12181: IF NOT(CSI_Item_Instance_vld_pvt.Is_Forward_Synch
12182: (p_instance_id => p_instance_rec.INSTANCE_ID,
12183: p_stop_all_txn => fnd_api.g_true,
12184: p_mtl_txn_id => fnd_api.g_miss_num)) THEN
12185: FND_MESSAGE.Set_Name('CSI', 'CSI_API_NO_FORWARD_SYNCH');
12186: FND_MESSAGE.Set_Token('INSTANCE', p_instance_rec.INSTANCE_ID);
12187: FND_MSG_PUB.ADD;
12188: RAISE FND_API.G_EXC_ERROR;
12189: END IF;
12182: (p_instance_id => p_instance_rec.INSTANCE_ID,
12183: p_stop_all_txn => fnd_api.g_true,
12184: p_mtl_txn_id => fnd_api.g_miss_num)) THEN
12185: FND_MESSAGE.Set_Name('CSI', 'CSI_API_NO_FORWARD_SYNCH');
12186: FND_MESSAGE.Set_Token('INSTANCE', p_instance_rec.INSTANCE_ID);
12187: FND_MSG_PUB.ADD;
12188: RAISE FND_API.G_EXC_ERROR;
12189: END IF;
12190: ELSE -- Even if seq exists, stop later txns
12191: IF NOT(CSI_Item_Instance_vld_pvt.Is_Forward_Synch
12192: (p_instance_id => p_instance_rec.INSTANCE_ID,
12193: p_stop_all_txn => fnd_api.g_false, -- Stop only later txns
12194: p_mtl_txn_id => p_txn_rec.inv_material_transaction_id)) THEN
12195: FND_MESSAGE.Set_Name('CSI', 'CSI_API_NO_FORWARD_SYNCH');
12196: FND_MESSAGE.Set_Token('INSTANCE', p_instance_rec.INSTANCE_ID);
12197: FND_MSG_PUB.ADD;
12198: RAISE FND_API.G_EXC_ERROR;
12199: END IF;
12192: (p_instance_id => p_instance_rec.INSTANCE_ID,
12193: p_stop_all_txn => fnd_api.g_false, -- Stop only later txns
12194: p_mtl_txn_id => p_txn_rec.inv_material_transaction_id)) THEN
12195: FND_MESSAGE.Set_Name('CSI', 'CSI_API_NO_FORWARD_SYNCH');
12196: FND_MESSAGE.Set_Token('INSTANCE', p_instance_rec.INSTANCE_ID);
12197: FND_MSG_PUB.ADD;
12198: RAISE FND_API.G_EXC_ERROR;
12199: END IF;
12200: END IF;
12203: IF ((p_instance_rec.instance_id IS NULL) OR
12204: (p_instance_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
12205: IF ((p_instance_rec.instance_id IS NULL) OR
12206: (p_instance_rec.instance_id <> l_curr_instance_rec.instance_id)) THEN
12207: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12208: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');
12209: FND_MSG_PUB.ADD;
12210: RAISE FND_API.G_EXC_ERROR;
12211: END IF;
12204: (p_instance_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
12205: IF ((p_instance_rec.instance_id IS NULL) OR
12206: (p_instance_rec.instance_id <> l_curr_instance_rec.instance_id)) THEN
12207: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12208: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');
12209: FND_MSG_PUB.ADD;
12210: RAISE FND_API.G_EXC_ERROR;
12211: END IF;
12212: END IF;
12225: RAISE fnd_api.g_exc_error;
12226: END IF;
12227: -- End addition for eam integration
12228: /*
12229: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12230: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_NUMBER');
12231: FND_MSG_PUB.ADD;
12232: RAISE FND_API.G_EXC_ERROR;
12233: */
12226: END IF;
12227: -- End addition for eam integration
12228: /*
12229: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12230: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_NUMBER');
12231: FND_MSG_PUB.ADD;
12232: RAISE FND_API.G_EXC_ERROR;
12233: */
12234: END IF;
12255: cptv.non_source_instance_id = p_instance_rec.instance_id)));
12256:
12257: IF(l_number_open_ro>0)
12258: THEN
12259: FND_MESSAGE.Set_Name('CSI', 'CSI_OPEN_RO_EXISTS');
12260: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID OR SERIAL_NUMBER');
12261: FND_MSG_PUB.ADD;
12262: RAISE FND_API.G_EXC_ERROR;
12263:
12256:
12257: IF(l_number_open_ro>0)
12258: THEN
12259: FND_MESSAGE.Set_Name('CSI', 'CSI_OPEN_RO_EXISTS');
12260: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID OR SERIAL_NUMBER');
12261: FND_MSG_PUB.ADD;
12262: RAISE FND_API.G_EXC_ERROR;
12263:
12264: END IF;
12266:
12267: --validation for open depot repair orders for CMRO
12268:
12269: IF p_instance_rec.inventory_item_id IS NULL THEN
12270: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_ITEM');
12271: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12272: fnd_message.set_token('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12273: FND_MSG_PUB.ADD;
12274: RAISE FND_API.G_EXC_ERROR;
12267: --validation for open depot repair orders for CMRO
12268:
12269: IF p_instance_rec.inventory_item_id IS NULL THEN
12270: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_ITEM');
12271: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12272: fnd_message.set_token('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12273: FND_MSG_PUB.ADD;
12274: RAISE FND_API.G_EXC_ERROR;
12275: ELSE
12268:
12269: IF p_instance_rec.inventory_item_id IS NULL THEN
12270: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_ITEM');
12271: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12272: fnd_message.set_token('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12273: FND_MSG_PUB.ADD;
12274: RAISE FND_API.G_EXC_ERROR;
12275: ELSE
12276: IF (p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM)
12281:
12282: THEN
12283: l_part_or_serial_change := TRUE;
12284: ELSE
12285: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12286: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID');
12287: FND_MSG_PUB.ADD;
12288: RAISE FND_API.G_EXC_ERROR;
12289: END IF;
12282: THEN
12283: l_part_or_serial_change := TRUE;
12284: ELSE
12285: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12286: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID');
12287: FND_MSG_PUB.ADD;
12288: RAISE FND_API.G_EXC_ERROR;
12289: END IF;
12290: END IF;
12307: p_inventory_item_id => p_instance_rec.inventory_item_id,
12308: p_serial_number => p_instance_rec.serial_number,
12309: x_mtl_txn_tbl => l_mtl_txn_tbl);
12310: IF NVL(l_mtl_txn_tbl.Count,0) > 0 THEN
12311: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12312: FND_MESSAGE.Set_Token('COLUMN', 'SERIAL_NUMBER');
12313: FND_MSG_PUB.ADD;
12314: RAISE FND_API.G_EXC_ERROR;
12315: END IF;
12308: p_serial_number => p_instance_rec.serial_number,
12309: x_mtl_txn_tbl => l_mtl_txn_tbl);
12310: IF NVL(l_mtl_txn_tbl.Count,0) > 0 THEN
12311: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12312: FND_MESSAGE.Set_Token('COLUMN', 'SERIAL_NUMBER');
12313: FND_MSG_PUB.ADD;
12314: RAISE FND_API.G_EXC_ERROR;
12315: END IF;
12316: ELSE
12313: FND_MSG_PUB.ADD;
12314: RAISE FND_API.G_EXC_ERROR;
12315: END IF;
12316: ELSE
12317: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12318: FND_MESSAGE.Set_Token('COLUMN', 'SERIAL_NUMBER');
12319: FND_MSG_PUB.ADD;
12320: RAISE FND_API.G_EXC_ERROR;
12321: END IF;
12314: RAISE FND_API.G_EXC_ERROR;
12315: END IF;
12316: ELSE
12317: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12318: FND_MESSAGE.Set_Token('COLUMN', 'SERIAL_NUMBER');
12319: FND_MSG_PUB.ADD;
12320: RAISE FND_API.G_EXC_ERROR;
12321: END IF;
12322: */ -- Commented for bug 6965008
12325: --end of code for 6176621
12326:
12327: --
12328: IF p_instance_rec.instance_status_id IS NULL THEN
12329: FND_MESSAGE.Set_Name('CSI','CSI_API_MANDATORY_STATUS');
12330: FND_MSG_PUB.ADD;
12331: RAISE FND_API.G_EXC_ERROR;
12332: END IF;
12333: --
12331: RAISE FND_API.G_EXC_ERROR;
12332: END IF;
12333: --
12334: IF p_instance_rec.quantity IS NULL THEN
12335: FND_MESSAGE.Set_Name('CSI','CSI_API_MANDATORY_QUANTITY');
12336: FND_MSG_PUB.ADD;
12337: RAISE FND_API.G_EXC_ERROR;
12338: END IF;
12339: --
12337: RAISE FND_API.G_EXC_ERROR;
12338: END IF;
12339: --
12340: IF p_instance_rec.unit_of_measure IS NULL THEN
12341: FND_MESSAGE.Set_Name('CSI','CSI_API_MANDATORY_UOM');
12342: FND_MSG_PUB.ADD;
12343: RAISE FND_API.G_EXC_ERROR;
12344: END IF;
12345: --
12362: WHERE organization_id = p_instance_rec.vld_organization_id
12363: AND master_organization_id = p_instance_rec.inv_master_organization_id;
12364: EXCEPTION
12365: WHEN NO_DATA_FOUND THEN
12366: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_VLD_MAST_COMB');
12367: FND_MSG_PUB.Add;
12368: RAISE FND_API.G_EXC_ERROR;
12369: END;
12370: /***** FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12366: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_VLD_MAST_COMB');
12367: FND_MSG_PUB.Add;
12368: RAISE FND_API.G_EXC_ERROR;
12369: END;
12370: /***** FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12371: FND_MESSAGE.Set_Token('COLUMN', 'INV_MASTER_ORGANIZATION_ID');
12372: FND_MSG_PUB.ADD;
12373: RAISE FND_API.G_EXC_ERROR; *****/
12374: END IF;
12367: FND_MSG_PUB.Add;
12368: RAISE FND_API.G_EXC_ERROR;
12369: END;
12370: /***** FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12371: FND_MESSAGE.Set_Token('COLUMN', 'INV_MASTER_ORGANIZATION_ID');
12372: FND_MSG_PUB.ADD;
12373: RAISE FND_API.G_EXC_ERROR; *****/
12374: END IF;
12375: END IF;
12390: l_get_instance_rec.location_id:=p_instance_rec.location_id;
12391:
12392: EXCEPTION
12393: WHEN NO_DATA_FOUND THEN
12394: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12395: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12396: fnd_msg_pub.ADD;
12397: RAISE fnd_api.g_exc_error;
12398: END;
12391:
12392: EXCEPTION
12393: WHEN NO_DATA_FOUND THEN
12394: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12395: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12396: fnd_msg_pub.ADD;
12397: RAISE fnd_api.g_exc_error;
12398: END;
12399: IF p_instance_rec.location_id IS NULL
12397: RAISE fnd_api.g_exc_error;
12398: END;
12399: IF p_instance_rec.location_id IS NULL
12400: THEN
12401: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12402: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12403: fnd_msg_pub.ADD;
12404: RAISE fnd_api.g_exc_error;
12405: END IF;
12398: END;
12399: IF p_instance_rec.location_id IS NULL
12400: THEN
12401: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12402: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12403: fnd_msg_pub.ADD;
12404: RAISE fnd_api.g_exc_error;
12405: END IF;
12406: END IF;
12417: FROM hr_all_organization_units
12418: WHERE organization_id = p_instance_rec.vld_organization_id;
12419: EXCEPTION
12420: WHEN NO_DATA_FOUND THEN
12421: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12422: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12423: fnd_msg_pub.ADD;
12424: RAISE fnd_api.g_exc_error;
12425: END;
12418: WHERE organization_id = p_instance_rec.vld_organization_id;
12419: EXCEPTION
12420: WHEN NO_DATA_FOUND THEN
12421: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12422: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12423: fnd_msg_pub.ADD;
12424: RAISE fnd_api.g_exc_error;
12425: END;
12426: IF p_instance_rec.install_location_id IS NULL
12424: RAISE fnd_api.g_exc_error;
12425: END;
12426: IF p_instance_rec.install_location_id IS NULL
12427: THEN
12428: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12429: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12430: fnd_msg_pub.ADD;
12431: RAISE fnd_api.g_exc_error;
12432: END IF;
12425: END;
12426: IF p_instance_rec.install_location_id IS NULL
12427: THEN
12428: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12429: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12430: fnd_msg_pub.ADD;
12431: RAISE fnd_api.g_exc_error;
12432: END IF;
12433: END IF;
12440: IF ((p_instance_rec.active_start_date IS NULL) OR
12441: (p_instance_rec.active_start_date <> FND_API.G_MISS_DATE)) THEN
12442: IF ((p_instance_rec.active_start_date IS NULL) OR
12443: (p_instance_rec.active_start_date <> l_curr_instance_rec.active_start_date)) THEN
12444: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12445: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
12446: FND_MSG_PUB.ADD;
12447: RAISE FND_API.G_EXC_ERROR;
12448: END IF;
12441: (p_instance_rec.active_start_date <> FND_API.G_MISS_DATE)) THEN
12442: IF ((p_instance_rec.active_start_date IS NULL) OR
12443: (p_instance_rec.active_start_date <> l_curr_instance_rec.active_start_date)) THEN
12444: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12445: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
12446: FND_MSG_PUB.ADD;
12447: RAISE FND_API.G_EXC_ERROR;
12448: END IF;
12449: END IF;
12454: (p_instance_rec.active_end_date < SYSDATE) THEN
12455: IF (p_instance_rec.check_for_instance_expiry = fnd_api.g_true) THEN
12456: IF NOT (p_called_from_rel = fnd_api.g_true OR p_txn_rec.transaction_type_id = 401)
12457: THEN
12458: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_UPD_EXP_ITEM');
12459: FND_MSG_PUB.ADD;
12460: RAISE FND_API.G_EXC_ERROR;
12461: END IF;
12462: END IF;
12487: (p_instance_rec.instance_status_id)))
12488: THEN
12489: IF ((p_instance_rec.ACTIVE_END_DATE IS NULL) OR
12490: (p_instance_rec.ACTIVE_END_DATE = FND_API.G_MISS_DATE)) THEN
12491: FND_MESSAGE.Set_Name('CSI', 'CSI_API_TER_DATE');
12492: FND_MSG_PUB.ADD;
12493: RAISE FND_API.G_EXC_ERROR;
12494: ELSIF p_instance_rec.ACTIVE_END_DATE < sysdate THEN
12495: IF NOT(CSI_Item_Instance_vld_pvt.EndDate_Valid
12499: RAISE FND_API.G_EXC_ERROR;
12500: END IF;
12501: ELSIF ((p_instance_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE) AND
12502: (p_instance_rec.ACTIVE_END_DATE > sysdate)) THEN
12503: FND_MESSAGE.Set_Name('CSI', 'CSI_API_FUTURE_DATE');
12504: FND_MSG_PUB.ADD;
12505: RAISE FND_API.G_EXC_ERROR;
12506: END IF;
12507: END IF;
12530: EXIT;
12531: END IF;
12532: END LOOP;
12533: IF l_valid_flag = 'N' then
12534: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12535: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12536: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12537: FND_MSG_PUB.Add;
12538: RAISE fnd_api.g_exc_error;
12531: END IF;
12532: END LOOP;
12533: IF l_valid_flag = 'N' then
12534: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12535: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12536: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12537: FND_MSG_PUB.Add;
12538: RAISE fnd_api.g_exc_error;
12539: END IF;
12532: END LOOP;
12533: IF l_valid_flag = 'N' then
12534: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12535: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12536: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12537: FND_MSG_PUB.Add;
12538: RAISE fnd_api.g_exc_error;
12539: END IF;
12540: END IF;
12562: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'Y';
12563: EXCEPTION
12564: WHEN OTHERS THEN
12565: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12566: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12567: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12568: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12569: FND_MSG_PUB.Add;
12570: RAISE fnd_api.g_exc_error;
12563: EXCEPTION
12564: WHEN OTHERS THEN
12565: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12566: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12567: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12568: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12569: FND_MSG_PUB.Add;
12570: RAISE fnd_api.g_exc_error;
12571: END;
12564: WHEN OTHERS THEN
12565: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12566: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12567: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12568: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12569: FND_MSG_PUB.Add;
12570: RAISE fnd_api.g_exc_error;
12571: END;
12572:
12600: p_item_attribute_tbl(p_ins_count_rec.inv_count).equipment_type := l_equipment_type;
12601: EXCEPTION
12602: WHEN OTHERS THEN
12603: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12604: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12605: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12606: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12607: FND_MSG_PUB.Add;
12608: RAISE fnd_api.g_exc_error;
12601: EXCEPTION
12602: WHEN OTHERS THEN
12603: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12604: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12605: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12606: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12607: FND_MSG_PUB.Add;
12608: RAISE fnd_api.g_exc_error;
12609: END;
12602: WHEN OTHERS THEN
12603: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12604: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12605: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12606: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12607: FND_MSG_PUB.Add;
12608: RAISE fnd_api.g_exc_error;
12609: END;
12610: END IF;
12702: ,x_reason_failed => l_reason_failed
12703: ,x_token => l_token
12704: )
12705: THEN
12706: -- FND_MESSAGE.SET_NAME('CSI', l_reason_failed); -- commented for bug 5351886
12707: -- FND_MSG_PUB.Add; -- commented for bug 5351886
12708: csi_gen_utility_pvt.put_line('Call to eam_assetnumber_pub.validate_fields failed with following reason');
12709: csi_gen_utility_pvt.put_line(l_reason_failed);
12710: RAISE FND_API.G_EXC_ERROR;
12709: csi_gen_utility_pvt.put_line(l_reason_failed);
12710: RAISE FND_API.G_EXC_ERROR;
12711: END IF;
12712: ELSE
12713: FND_MESSAGE.SET_NAME('CSI', 'CSI_NON_EAM_ITEM');
12714: FND_MSG_PUB.Add;
12715: RAISE FND_API.G_EXC_ERROR;
12716: END IF;
12717: END IF;
12720: IF l_get_instance_rec.system_id IS NOT NULL AND
12721: l_get_instance_rec.system_id <> FND_API.G_MISS_NUM THEN
12722: IF NOT csi_Item_Instance_Vld_pvt.Is_Valid_System_id(
12723: l_get_instance_rec.system_id) THEN
12724: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SYSTEM_ID');
12725: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',l_get_instance_rec.system_id);
12726: FND_MSG_PUB.Add;
12727: RAISE FND_API.G_EXC_ERROR;
12728: END IF;
12721: l_get_instance_rec.system_id <> FND_API.G_MISS_NUM THEN
12722: IF NOT csi_Item_Instance_Vld_pvt.Is_Valid_System_id(
12723: l_get_instance_rec.system_id) THEN
12724: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SYSTEM_ID');
12725: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',l_get_instance_rec.system_id);
12726: FND_MSG_PUB.Add;
12727: RAISE FND_API.G_EXC_ERROR;
12728: END IF;
12729: END IF;
12774:
12775: --start code fix for 6176621
12776:
12777: IF l_serial_control not in (2, 5) and l_part_or_serial_change THEN
12778: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_UPD_SRL');
12779: FND_MSG_PUB.Add;
12780: RAISE FND_API.g_exc_error;
12781: END IF;
12782:
12784:
12785: -- Updating a Serial Number to NULL is not allowed.
12786: IF l_curr_instance_rec.serial_number IS NOT NULL AND
12787: p_instance_rec.serial_number IS NULL THEN
12788: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_UPD_SRL_NULL');
12789: FND_MSG_PUB.Add;
12790: RAISE FND_API.G_EXC_ERROR;
12791: END IF;
12792: --
12925: ,p_instance_id => p_instance_rec.instance_id
12926: ,l_return_value => l_return_value
12927: );
12928: IF l_return_value = FALSE THEN
12929: fnd_message.set_name('CSI','CSI_FAIL_UNIQUENESS');
12930: fnd_msg_pub.add;
12931: RAISE fnd_api.g_exc_error;
12932: END IF;
12933: END IF;
13005: );
13006:
13007: IF l_return_value = FALSE
13008: THEN
13009: FND_MESSAGE.Set_Name('CSI', 'CSI_CHANGE_VLD_ORG');
13010: FND_MSG_PUB.ADD;
13011: RAISE FND_API.G_EXC_ERROR;
13012: END IF;
13013: END IF;
13055: p_instance_rec.accounting_class_code := l_acct_class_code;
13056: -- END IF;
13057: ELSE
13058: IF (p_instance_rec.accounting_class_code <> l_acct_class_code) THEN
13059: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_CLASS');
13060: FND_MSG_PUB.Add;
13061: RAISE FND_API.G_EXC_ERROR;
13062: END IF;
13063: END IF; -- not null
13095: IF (l_curr_instance_rec.quantity = 0)
13096: AND ((p_instance_rec.quantity = 0) OR (p_instance_rec.quantity = FND_API.G_MISS_NUM))
13097: AND ((p_instance_rec.active_end_date IS NULL) OR (p_instance_rec.active_end_date > SYSDATE))
13098: THEN
13099: FND_MESSAGE.Set_Name('CSI', 'CSI_API_CANNOT_UNEXPIRE');
13100: FND_MSG_PUB.ADD;
13101: RAISE FND_API.G_EXC_ERROR;
13102: END IF;
13103:
13118: THEN
13119: IF (CSI_Item_Instance_vld_pvt.val_inst_ter_flag --added first change
13120: (l_get_instance_rec.instance_status_id))
13121: THEN
13122: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_STATUS');
13123: FND_MSG_PUB.ADD;
13124: RAISE FND_API.G_EXC_ERROR;
13125: END IF;
13126: END IF;
13146: end if;
13147: End Loop;
13148: --
13149: if l_valid_flag <> 'Y' then
13150: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM_CONDITION');
13151: FND_MESSAGE.SET_TOKEN('INSTANCE_CONDITION_ID',p_instance_rec.instance_condition_id);
13152: FND_MSG_PUB.Add;
13153: RAISE fnd_api.g_exc_error;
13154: end if;
13147: End Loop;
13148: --
13149: if l_valid_flag <> 'Y' then
13150: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM_CONDITION');
13151: FND_MESSAGE.SET_TOKEN('INSTANCE_CONDITION_ID',p_instance_rec.instance_condition_id);
13152: FND_MSG_PUB.Add;
13153: RAISE fnd_api.g_exc_error;
13154: end if;
13155: end if;
13202: end if;
13203: End Loop;
13204: --
13205: if l_valid_flag <> 'Y' then
13206: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_TYPE');
13207: FND_MESSAGE.SET_TOKEN('INSTANCE_TYPE_CODE',p_instance_rec.instance_type_code);
13208: FND_MSG_PUB.Add;
13209: RAISE fnd_api.g_exc_error;
13210: end if;
13203: End Loop;
13204: --
13205: if l_valid_flag <> 'Y' then
13206: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_TYPE');
13207: FND_MESSAGE.SET_TOKEN('INSTANCE_TYPE_CODE',p_instance_rec.instance_type_code);
13208: FND_MSG_PUB.Add;
13209: RAISE fnd_api.g_exc_error;
13210: end if;
13211: End if;
13242: end if;
13243: End Loop;
13244: --
13245: if l_valid_flag <> 'Y' then
13246: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_USAGE_CODE');
13247: FND_MESSAGE.SET_TOKEN('INSTANCE_USAGE_CODE',p_instance_rec.instance_usage_code);
13248: FND_MSG_PUB.Add;
13249: RAISE fnd_api.g_exc_error;
13250: end if;
13243: End Loop;
13244: --
13245: if l_valid_flag <> 'Y' then
13246: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_USAGE_CODE');
13247: FND_MESSAGE.SET_TOKEN('INSTANCE_USAGE_CODE',p_instance_rec.instance_usage_code);
13248: FND_MSG_PUB.Add;
13249: RAISE fnd_api.g_exc_error;
13250: end if;
13251: End if;
13285: END IF;
13286: End Loop;
13287: --
13288: if l_valid_flag <> 'Y' then
13289: FND_MESSAGE.SET_NAME('CSI','CSI_OPERATIONAL_STATUS_CODE');
13290: FND_MESSAGE.SET_TOKEN('OPERATIONAL_STATUS_CODE',p_instance_rec.operational_status_code);
13291: FND_MSG_PUB.Add;
13292: RAISE fnd_api.g_exc_error;
13293: end if;
13286: End Loop;
13287: --
13288: if l_valid_flag <> 'Y' then
13289: FND_MESSAGE.SET_NAME('CSI','CSI_OPERATIONAL_STATUS_CODE');
13290: FND_MESSAGE.SET_TOKEN('OPERATIONAL_STATUS_CODE',p_instance_rec.operational_status_code);
13291: FND_MSG_PUB.Add;
13292: RAISE fnd_api.g_exc_error;
13293: end if;
13294: End if;
13321: into l_int_party_id
13322: from csi_install_parameters;
13323:
13324: IF l_int_party_id IS NULL THEN
13325: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
13326: FND_MSG_PUB.ADD;
13327: RAISE FND_API.G_EXC_ERROR;
13328: END IF;
13329: END IF;
13658: p_instance_rec.sales_unit_price <> FND_API.G_MISS_NUM)))
13659: )
13660: )
13661: THEN
13662: FND_MESSAGE.SET_NAME('CSI','CSI_NO_PRICE_OR_CODE');
13663: FND_MSG_PUB.Add;
13664: RAISE fnd_api.g_exc_error;
13665: END IF;
13666: -- End addition of columns for FA Integration
13693: l_get_instance_rec.instance_usage_code IS NULL OR
13694: l_get_instance_rec.instance_usage_code = fnd_api.g_miss_char) AND
13695: l_temp_rec IS NOT NULL
13696: THEN
13697: FND_MESSAGE.Set_Name('CSI', 'CSI_INVALID_USAGE_CODE');
13698: FND_MSG_PUB.ADD;
13699: RAISE fnd_api.g_exc_error;
13700: END IF;
13701:
13723: AND (active_end_date IS NULL OR active_end_date > SYSDATE);
13724:
13725: IF l_temp_rec1 IS NOT NULL
13726: THEN
13727: FND_MESSAGE.Set_Name('CSI', 'CSI_MODIFY_USAGE_CODE');
13728: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
13729: FND_MSG_PUB.ADD;
13730: RAISE fnd_api.g_exc_error;
13731: END IF;
13724:
13725: IF l_temp_rec1 IS NOT NULL
13726: THEN
13727: FND_MESSAGE.Set_Name('CSI', 'CSI_MODIFY_USAGE_CODE');
13728: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
13729: FND_MSG_PUB.ADD;
13730: RAISE fnd_api.g_exc_error;
13731: END IF;
13732: EXCEPTION
13826: --bring has parent logic here
13827: IF csi_Item_Instance_Vld_Pvt.Instance_has_Parent(
13828: p_instance_id => p_instance_rec.instance_id
13829: ) THEN
13830: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INSTANCE_HAS_PARENT');
13831: FND_MSG_PUB.ADD;
13832: RAISE fnd_api.g_exc_error;
13833: END IF;
13834: -- Validate Location ID
13835: IF l_get_instance_rec.location_type_code IS NULL OR
13836: l_get_instance_rec.location_type_code = FND_API.G_MISS_CHAR OR
13837: l_get_instance_rec.location_id IS NULL OR
13838: l_get_instance_rec.location_id = FND_API.G_MISS_NUM THEN
13839: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
13840: FND_MSG_PUB.ADD;
13841: RAISE fnd_api.g_exc_error;
13842: END IF;
13843: --
13854: END IF;
13855: End Loop;
13856: --
13857: IF l_valid_flag <> 'Y' THEN
13858: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
13859: FND_MSG_PUB.ADD;
13860: RAISE fnd_api.g_exc_error;
13861: END IF;
13862: END IF; -- p_location_tbl count
14012: THEN
14013: IF ((l_serial_control = 6) and (l_get_instance_rec.serial_number is null)) THEN
14014: p_instance_rec.creation_complete_flag := 'N';
14015: ELSE
14016: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTES');
14017: FND_MSG_PUB.Add;
14018: RAISE fnd_api.g_exc_error;
14019: END IF;
14020: ELSE
14057: WHERE csi.incident_status_id = csb.incident_status_id
14058: AND csi.customer_product_id = p_instance_rec.instance_id
14059: AND NVL(close_flag,'N')<>'Y';
14060:
14061: FND_MESSAGE.SET_NAME('CSI','CSI_IB_HAS_OPEN_SR');
14062: FND_MSG_PUB.ADD;
14063: RAISE FND_API.G_EXC_ERROR;
14064:
14065: EXCEPTION
14063: RAISE FND_API.G_EXC_ERROR;
14064:
14065: EXCEPTION
14066: WHEN TOO_MANY_ROWS THEN
14067: FND_MESSAGE.SET_NAME('CSI','CSI_IB_HAS_OPEN_SR');
14068: FND_MSG_PUB.ADD;
14069: RAISE FND_API.G_EXC_ERROR;
14070:
14071: WHEN NO_DATA_FOUND THEN -- modfied for bug 3693511
14086: p_instance_rec.install_location_type_code = 'HR_LOCATIONS' --4926773
14087: THEN
14088: IF p_instance_rec.install_location_id IS NULL OR
14089: p_instance_rec.install_location_id = FND_API.G_MISS_NUM THEN
14090: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
14091: FND_MSG_PUB.ADD;
14092: RAISE fnd_api.g_exc_error;
14093: END IF;
14094: --
14105: END IF;
14106: End Loop;
14107: --
14108: IF l_valid_flag <> 'Y' THEN
14109: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
14110: FND_MSG_PUB.ADD;
14111: RAISE fnd_api.g_exc_error;
14112: END IF;
14113: END IF;
14129: RAISE fnd_api.g_exc_error;
14130: END IF;
14131: END IF;
14132: ELSE
14133: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
14134: FND_MSG_PUB.Add;
14135: RAISE FND_API.G_EXC_ERROR;
14136: END IF;
14137: END IF;
14426: );
14427:
14428: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
14429: THEN
14430: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14431: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14432: FND_MSG_PUB.Add;
14433: RAISE FND_API.G_EXC_ERROR;
14434: END IF;
14427:
14428: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
14429: THEN
14430: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14431: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14432: FND_MSG_PUB.Add;
14433: RAISE FND_API.G_EXC_ERROR;
14434: END IF;
14435: END IF;
14494: ,x_ctr_grp_id_instance => l_ctr_grp_id_instance
14495: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
14496: );
14497: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
14498: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14499: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14500: FND_MSG_PUB.Add;
14501: RAISE FND_API.G_EXC_ERROR;
14502: END IF;
14495: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
14496: );
14497: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
14498: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14499: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14500: FND_MSG_PUB.Add;
14501: RAISE FND_API.G_EXC_ERROR;
14502: END IF;
14503: END IF; -- COunter template existance check for the new item
14629: ,x_msg_data => x_msg_data
14630: );
14631:
14632: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
14633: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
14634: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
14635: FND_MSG_PUB.Add;
14636: RAISE FND_API.G_EXC_ERROR;
14637: END IF;
14630: );
14631:
14632: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
14633: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
14634: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
14635: FND_MSG_PUB.Add;
14636: RAISE FND_API.G_EXC_ERROR;
14637: END IF;
14638:
14644: --
14645: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
14646: --
14647: IF l_full_dump_frequency IS NULL THEN
14648: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
14649: FND_MSG_PUB.ADD;
14650: RAISE FND_API.G_EXC_ERROR;
14651: END IF;
14652: --
19049: x_msg_count => x_msg_count,
19050: x_msg_data => x_msg_data
19051: );
19052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
19053: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
19054: FND_MSG_PUB.Add;
19055: RAISE FND_API.G_EXC_ERROR;
19056: END IF;
19057: END IF;
19065:
19066: OPEN curr_instance_rec(l_rel_tbl(j).subject_id);
19067: FETCH curr_instance_rec INTO l_curr_instance_rec;
19068: IF curr_instance_rec%NOTFOUND THEN
19069: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
19070: FND_MSG_PUB.ADD;
19071: RAISE FND_API.G_EXC_ERROR;
19072: END IF;
19073: CLOSE curr_instance_rec;
19087:
19088: IF l_temp IS NOT NULL
19089: THEN
19090: x_return_status := FND_API.G_RET_STS_ERROR ;
19091: FND_MESSAGE.Set_Name('CSI', 'CSI_CHILD_HAS_TXN');
19092: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number);
19093: FND_MSG_PUB.ADD;
19094: RAISE FND_API.G_EXC_ERROR;
19095: END IF;
19088: IF l_temp IS NOT NULL
19089: THEN
19090: x_return_status := FND_API.G_RET_STS_ERROR ;
19091: FND_MESSAGE.Set_Name('CSI', 'CSI_CHILD_HAS_TXN');
19092: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number);
19093: FND_MSG_PUB.ADD;
19094: RAISE FND_API.G_EXC_ERROR;
19095: END IF;
19096: EXCEPTION
19112: IF p_instance_rec.instance_status_id IS NOT NULL AND
19113: p_instance_rec.instance_status_id <> fnd_api.g_miss_num THEN
19114: IF NOT (CSI_Item_Instance_vld_pvt.val_inst_ter_flag(
19115: p_instance_rec.instance_status_id)) THEN
19116: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TERM_STATUS');
19117: FND_MSG_PUB.ADD;
19118: RAISE FND_API.G_EXC_ERROR;
19119: END IF;
19120: l_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
19138: FROM csi_item_instances
19139: WHERE instance_id = p_instance_rec.instance_id;
19140: EXCEPTION
19141: WHEN NO_DATA_FOUND THEN
19142: fnd_message.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
19143: fnd_message.set_token('INSTANCE_ID',p_instance_rec.instance_id);
19144: fnd_msg_pub.ADD;
19145: END;
19146: ELSE
19139: WHERE instance_id = p_instance_rec.instance_id;
19140: EXCEPTION
19141: WHEN NO_DATA_FOUND THEN
19142: fnd_message.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
19143: fnd_message.set_token('INSTANCE_ID',p_instance_rec.instance_id);
19144: fnd_msg_pub.ADD;
19145: END;
19146: ELSE
19147: l_vld_org := p_instance_rec.vld_organization_id;
19327: );
19328:
19329: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
19330:
19331: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
19332: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
19333: FND_MSG_PUB.Add;
19334: RAISE FND_API.G_EXC_ERROR;
19335: END IF;
19328:
19329: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
19330:
19331: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
19332: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
19333: FND_MSG_PUB.Add;
19334: RAISE FND_API.G_EXC_ERROR;
19335: END IF;
19336:
19341: --
19342: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
19343: --
19344: IF l_full_dump_frequency IS NULL THEN
19345: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
19346: FND_MSG_PUB.ADD;
19347: RAISE FND_API.G_EXC_ERROR;
19348: END IF;
19349:
20175: -- in the database else raise error
20176: OPEN get_instance_rec(p_instance_rec.instance_id);
20177: FETCH get_instance_rec INTO l_curr_instance_rec;
20178: IF (l_curr_instance_rec.object_version_number <> nvl(p_instance_rec.OBJECT_VERSION_NUMBER,0)) THEN
20179: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
20180: FND_MSG_PUB.ADD;
20181: RAISE FND_API.G_EXC_ERROR;
20182: END IF;
20183:
20181: RAISE FND_API.G_EXC_ERROR;
20182: END IF;
20183:
20184: IF get_instance_rec%NOTFOUND THEN
20185: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
20186: FND_MSG_PUB.ADD;
20187: RAISE FND_API.G_EXC_ERROR;
20188: END IF;
20189: CLOSE get_instance_rec;
20204:
20205: IF l_txn_date IS NOT NULL
20206: THEN
20207: x_return_status := FND_API.G_RET_STS_ERROR ;
20208: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
20209: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number );
20210: FND_MESSAGE.SET_TOKEN('TXN_DATE',to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
20211: FND_MSG_PUB.ADD;
20212: RAISE FND_API.G_EXC_ERROR;
20205: IF l_txn_date IS NOT NULL
20206: THEN
20207: x_return_status := FND_API.G_RET_STS_ERROR ;
20208: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
20209: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number );
20210: FND_MESSAGE.SET_TOKEN('TXN_DATE',to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
20211: FND_MSG_PUB.ADD;
20212: RAISE FND_API.G_EXC_ERROR;
20213: END IF;
20206: THEN
20207: x_return_status := FND_API.G_RET_STS_ERROR ;
20208: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
20209: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number );
20210: FND_MESSAGE.SET_TOKEN('TXN_DATE',to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
20211: FND_MSG_PUB.ADD;
20212: RAISE FND_API.G_EXC_ERROR;
20213: END IF;
20214: EXCEPTION
20247: x_msg_data => x_msg_data
20248: );
20249: --
20250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
20251: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
20252: FND_MSG_PUB.Add;
20253: RAISE FND_API.G_EXC_ERROR;
20254: END IF;
20255: END IF;
20263: END IF;
20264:
20265: IF l_has_unexpired_children = TRUE THEN
20266: IF p_expire_children = 'F' THEN
20267: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_EXPIRE_INSTANCE');
20268: FND_MSG_PUB.Add;
20269: RAISE FND_API.G_EXC_ERROR;
20270:
20271: ELSE
20293: IF p_instance_rec.instance_status_id IS NOT NULL AND
20294: p_instance_rec.instance_status_id <> fnd_api.g_miss_num THEN
20295: IF NOT (CSI_Item_Instance_vld_pvt.val_inst_ter_flag(
20296: p_instance_rec.instance_status_id)) THEN
20297: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TERM_STATUS');
20298: FND_MSG_PUB.ADD;
20299: RAISE FND_API.G_EXC_ERROR;
20300: END IF;
20301: l_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
20323: WHERE csi.incident_status_id = csb.incident_status_id
20324: AND csi.customer_product_id = p_instance_rec.instance_id
20325: AND NVL(close_flag,'N')<>'Y';
20326:
20327: FND_MESSAGE.SET_NAME('CSI','CSI_IB_HAS_OPEN_SR');
20328: FND_MSG_PUB.ADD;
20329: RAISE FND_API.G_EXC_ERROR;
20330:
20331: EXCEPTION
20329: RAISE FND_API.G_EXC_ERROR;
20330:
20331: EXCEPTION
20332: WHEN TOO_MANY_ROWS THEN
20333: FND_MESSAGE.SET_NAME('CSI','CSI_IB_HAS_OPEN_SR');
20334: FND_MSG_PUB.ADD;
20335: RAISE FND_API.G_EXC_ERROR;
20336:
20337: WHEN NO_DATA_FOUND THEN -- modfied for bug 3693511
20384: FROM csi_item_instances
20385: WHERE instance_id = p_instance_rec.instance_id;
20386: EXCEPTION
20387: WHEN NO_DATA_FOUND THEN
20388: fnd_message.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
20389: fnd_message.set_token('INSTANCE_ID',p_instance_rec.instance_id);
20390: fnd_msg_pub.ADD;
20391: END;
20392: ELSE
20385: WHERE instance_id = p_instance_rec.instance_id;
20386: EXCEPTION
20387: WHEN NO_DATA_FOUND THEN
20388: fnd_message.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
20389: fnd_message.set_token('INSTANCE_ID',p_instance_rec.instance_id);
20390: fnd_msg_pub.ADD;
20391: END;
20392: ELSE
20393: l_vld_org := p_instance_rec.vld_organization_id;
20578: );
20579:
20580: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
20581:
20582: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
20583: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
20584: FND_MSG_PUB.Add;
20585: RAISE FND_API.G_EXC_ERROR;
20586: END IF;
20579:
20580: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
20581:
20582: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
20583: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
20584: FND_MSG_PUB.Add;
20585: RAISE FND_API.G_EXC_ERROR;
20586: END IF;
20587: -- END IF;
20598: --
20599: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
20600: --
20601: IF l_full_dump_frequency IS NULL THEN
20602: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
20603: FND_MSG_PUB.ADD;
20604: RAISE FND_API.G_EXC_ERROR;
20605: END IF;
20606:
21543: IF p_source_instance_rec.location_type_code = 'INVENTORY'
21544: OR p_source_instance_rec.location_type_code = 'WIP'
21545: OR p_source_instance_rec.location_type_code = 'PROJECT'
21546: THEN
21547: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
21548: FND_MSG_PUB.ADD;
21549: RAISE FND_API.G_EXC_ERROR;
21550: END IF;
21551:
21554: INTO l_dummy
21555: FROM csi_i_assets
21556: WHERE instance_id =p_source_instance_rec.instance_id;
21557:
21558: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
21559: FND_MSG_PUB.ADD;
21560: RAISE FND_API.G_EXC_ERROR;
21561: EXCEPTION
21562: WHEN OTHERS THEN
21574: ,p_transaction_type_id => p_txn_rec.transaction_type_id
21575: ) -- Added by sk on 09/13/01
21576: THEN
21577: l_return_value := FALSE;
21578: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_BE_SERIALIZED');
21579: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER', 'serial_number');
21580: FND_MSG_PUB.ADD;
21581: RAISE FND_API.G_EXC_ERROR;
21582: END IF;
21575: ) -- Added by sk on 09/13/01
21576: THEN
21577: l_return_value := FALSE;
21578: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_BE_SERIALIZED');
21579: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER', 'serial_number');
21580: FND_MSG_PUB.ADD;
21581: RAISE FND_API.G_EXC_ERROR;
21582: END IF;
21583: END IF;
21591: FROM csi_item_instances
21592: WHERE instance_id = p_source_instance_rec.instance_id;
21593: EXCEPTION
21594: WHEN NO_DATA_FOUND THEN
21595: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANITY');
21596: FND_MSG_PUB.Add;
21597: RAISE FND_API.G_EXC_ERROR;
21598: END;
21599:
21598: END;
21599:
21600: --verifying the quantity
21601: IF (p_quantity1 + p_quantity2) <> l_quantity THEN
21602: FND_MESSAGE.SET_NAME('CSI','CSI_API_INCORRECT_QUANTITY');
21603: FND_MSG_PUB.Add;
21604: RAISE FND_API.G_EXC_ERROR;
21605: END IF;
21606:
21759: FROM csi_item_instances
21760: WHERE instance_id = p_source_instance_rec.instance_id;
21761: EXCEPTION
21762: WHEN NO_DATA_FOUND THEN
21763: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OBJ_NUM');
21764: FND_MSG_PUB.ADD;
21765: RAISE FND_API.G_EXC_ERROR;
21766: END;
21767: l_new_instance_rec.instance_id := p_source_instance_rec.instance_id;
22042: IF p_source_instance_rec.location_type_code = 'INVENTORY'
22043: OR p_source_instance_rec.location_type_code = 'WIP'
22044: OR p_source_instance_rec.location_type_code = 'PROJECT'
22045: THEN
22046: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
22047: FND_MSG_PUB.ADD;
22048: RAISE FND_API.G_EXC_ERROR;
22049: END IF;
22050:
22053: INTO l_dummy
22054: FROM csi_i_assets
22055: WHERE instance_id =p_source_instance_rec.instance_id;
22056:
22057: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
22058: FND_MSG_PUB.ADD;
22059: RAISE FND_API.G_EXC_ERROR;
22060: EXCEPTION
22061: WHEN OTHERS THEN
22072: ,p_transaction_type_id => p_txn_rec.transaction_type_id
22073: ) -- Added by sk on 09/13/01
22074: THEN
22075: l_return_value := FALSE;
22076: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_BE_SERIALIZED');
22077: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER', 'serial_number');
22078: FND_MSG_PUB.ADD;
22079: RAISE FND_API.G_EXC_ERROR;
22080: END IF;
22073: ) -- Added by sk on 09/13/01
22074: THEN
22075: l_return_value := FALSE;
22076: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_BE_SERIALIZED');
22077: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER', 'serial_number');
22078: FND_MSG_PUB.ADD;
22079: RAISE FND_API.G_EXC_ERROR;
22080: END IF;
22081: END IF;
22088: FROM csi_item_instances
22089: WHERE instance_id = p_source_instance_rec.instance_id;
22090: EXCEPTION
22091: WHEN NO_DATA_FOUND THEN
22092: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANITY');
22093: FND_MSG_PUB.Add;
22094: RAISE FND_API.G_EXC_ERROR;
22095: END;
22096: -- Added by sk for bug 2186683
22318: -- End of code addition for fixing bug 2139782.
22319: END LOOP;
22320: Else --l_quantity is <= 1
22321:
22322: FND_MESSAGE.SET_NAME('CSI','CSI_API_QUANTITY_NOT_VALID');
22323: FND_MESSAGE.SET_TOKEN('QUANTITY', l_quantity);
22324: FND_MSG_PUB.ADD;
22325: -- RAISE fnd_api.g_exc_error;
22326: End If;
22319: END LOOP;
22320: Else --l_quantity is <= 1
22321:
22322: FND_MESSAGE.SET_NAME('CSI','CSI_API_QUANTITY_NOT_VALID');
22323: FND_MESSAGE.SET_TOKEN('QUANTITY', l_quantity);
22324: FND_MSG_PUB.ADD;
22325: -- RAISE fnd_api.g_exc_error;
22326: End If;
22327:
22332: FROM csi_item_instances
22333: WHERE instance_id = p_source_instance_rec.instance_id;
22334: EXCEPTION
22335: WHEN NO_DATA_FOUND THEN
22336: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OBJ_NUM');
22337: FND_MSG_PUB.ADD;
22338: RAISE FND_API.G_EXC_ERROR;
22339: END;
22340: --
22673: l_nearest_full_dump := l_time_stamp;
22674: -- If the user chooses a date before the creation date of the instance
22675: -- then raise an error
22676: IF p_time_stamp < l_time_stamp THEN
22677: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
22678: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
22679: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
22680: FND_MSG_PUB.Add;
22681: RAISE FND_API.G_EXC_ERROR;
22674: -- If the user chooses a date before the creation date of the instance
22675: -- then raise an error
22676: IF p_time_stamp < l_time_stamp THEN
22677: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
22678: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
22679: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
22680: FND_MSG_PUB.Add;
22681: RAISE FND_API.G_EXC_ERROR;
22682: END IF;
22675: -- then raise an error
22676: IF p_time_stamp < l_time_stamp THEN
22677: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
22678: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
22679: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
22680: FND_MSG_PUB.Add;
22681: RAISE FND_API.G_EXC_ERROR;
22682: END IF;
22683:
23475: -- in the database else raise error
23476: OPEN get_curr_ver_label_rec(p_version_label_rec.VERSION_LABEL_ID);
23477: FETCH get_curr_ver_label_rec INTO l_curr_ver_label_rec;
23478: IF (l_curr_ver_label_rec.object_version_number <> nvl(p_version_label_rec.OBJECT_VERSION_NUMBER,-1)) THEN
23479: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
23480: FND_MSG_PUB.ADD;
23481: RAISE FND_API.G_EXC_ERROR;
23482: END IF;
23483: IF get_curr_ver_label_rec%NOTFOUND THEN
23480: FND_MSG_PUB.ADD;
23481: RAISE FND_API.G_EXC_ERROR;
23482: END IF;
23483: IF get_curr_ver_label_rec%NOTFOUND THEN
23484: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
23485: FND_MSG_PUB.ADD;
23486: RAISE FND_API.G_EXC_ERROR;
23487: END IF;
23488: CLOSE get_curr_ver_label_rec;
23560: --
23561: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
23562: --
23563: IF l_full_dump_frequency IS NULL THEN
23564: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
23565: FND_MSG_PUB.ADD;
23566: RAISE FND_API.G_EXC_ERROR;
23567: END IF;
23568: --
24589: -- in the database else raise error
24590: OPEN get_curr_ver_label_rec(p_version_label_rec.version_label_id);
24591: FETCH get_curr_ver_label_rec INTO l_curr_ver_label_rec;
24592: IF (l_curr_ver_label_rec.object_version_number <> nvl(p_version_label_rec.OBJECT_VERSION_NUMBER,-1)) THEN
24593: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
24594: FND_MSG_PUB.ADD;
24595: RAISE FND_API.G_EXC_ERROR;
24596: END IF;
24597:
24595: RAISE FND_API.G_EXC_ERROR;
24596: END IF;
24597:
24598: IF get_curr_ver_label_rec%NOTFOUND THEN
24599: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
24600: FND_MSG_PUB.ADD;
24601: RAISE FND_API.G_EXC_ERROR;
24602: END IF;
24603: CLOSE get_curr_ver_label_rec;
24671: --
24672: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
24673: --
24674: IF l_full_dump_frequency IS NULL THEN
24675: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
24676: FND_MSG_PUB.ADD;
24677: RAISE FND_API.G_EXC_ERROR;
24678: END IF;
24679:
25075: -- If the user chooses a date before the creation date of the instance
25076: -- then raise an error
25077: IF p_time_stamp < l_time_stamp THEN
25078: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
25079: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
25080: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25081: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25082: -- FND_MSG_PUB.Add;
25083: -- RAISE FND_API.G_EXC_ERROR;
25076: -- then raise an error
25077: IF p_time_stamp < l_time_stamp THEN
25078: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
25079: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
25080: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25081: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25082: -- FND_MSG_PUB.Add;
25083: -- RAISE FND_API.G_EXC_ERROR;
25084: l_ext_tbl.DELETE(i);
25077: IF p_time_stamp < l_time_stamp THEN
25078: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
25079: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
25080: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25081: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25082: -- FND_MSG_PUB.Add;
25083: -- RAISE FND_API.G_EXC_ERROR;
25084: l_ext_tbl.DELETE(i);
25085: RAISE Process_next;
25532: END LOOP;
25533: --
25534: IF l_valid_flag <> 'Y'
25535: THEN
25536: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
25537: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_ext_attrib_rec.instance_id);
25538: FND_MSG_PUB.Add;
25539: RAISE fnd_api.g_exc_error;
25540: END IF;
25533: --
25534: IF l_valid_flag <> 'Y'
25535: THEN
25536: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
25537: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_ext_attrib_rec.instance_id);
25538: FND_MSG_PUB.Add;
25539: RAISE fnd_api.g_exc_error;
25540: END IF;
25541: END IF;
25584: END LOOP;
25585: --
25586: IF l_valid_flag <> 'Y'
25587: THEN
25588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
25589: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_ext_attrib_rec.attribute_id);
25590: FND_MSG_PUB.Add;
25591: RAISE fnd_api.g_exc_error;
25592: END IF;
25585: --
25586: IF l_valid_flag <> 'Y'
25587: THEN
25588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
25589: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_ext_attrib_rec.attribute_id);
25590: FND_MSG_PUB.Add;
25591: RAISE fnd_api.g_exc_error;
25592: END IF;
25593: END IF;
25615: p_ext_attr_tbl(p_ext_count_rec.ext_attr_count).instance_id := l_instance_id;
25616: END IF;
25617: END IF;
25618: ELSE
25619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
25620: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_ext_attrib_rec.attribute_id);
25621: FND_MSG_PUB.Add;
25622: END IF;
25623: --
25616: END IF;
25617: END IF;
25618: ELSE
25619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
25620: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_ext_attrib_rec.attribute_id);
25621: FND_MSG_PUB.Add;
25622: END IF;
25623: --
25624:
25734: END LOOP;
25735: --
25736: IF l_valid_flag <> 'Y'
25737: THEN
25738: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
25739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',l_ori_inventory_item_id);
25740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',l_ori_master_org_id);
25741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',l_item_category_id);
25742: FND_MSG_PUB.Add;
25735: --
25736: IF l_valid_flag <> 'Y'
25737: THEN
25738: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
25739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',l_ori_inventory_item_id);
25740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',l_ori_master_org_id);
25741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',l_item_category_id);
25742: FND_MSG_PUB.Add;
25743: RAISE fnd_api.g_exc_error;
25736: IF l_valid_flag <> 'Y'
25737: THEN
25738: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
25739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',l_ori_inventory_item_id);
25740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',l_ori_master_org_id);
25741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',l_item_category_id);
25742: FND_MSG_PUB.Add;
25743: RAISE fnd_api.g_exc_error;
25744: END IF;
25737: THEN
25738: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
25739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',l_ori_inventory_item_id);
25740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',l_ori_master_org_id);
25741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',l_item_category_id);
25742: FND_MSG_PUB.Add;
25743: RAISE fnd_api.g_exc_error;
25744: END IF;
25745: END IF;
26127:
26128: -- Verify start effective date
26129: IF ( p_ext_attrib_rec.active_start_date <> FND_API.G_MISS_DATE) THEN
26130: IF (p_ext_attrib_rec.active_start_date <> l_ext_attrib_rec.active_start_date) THEN
26131: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
26132: FND_MESSAGE.Set_Token('COLUMN', 'EXTENDED ATTRIBUTE START_DATE');
26133: FND_MSG_PUB.ADD;
26134: RAISE FND_API.G_EXC_ERROR;
26135: END IF;
26128: -- Verify start effective date
26129: IF ( p_ext_attrib_rec.active_start_date <> FND_API.G_MISS_DATE) THEN
26130: IF (p_ext_attrib_rec.active_start_date <> l_ext_attrib_rec.active_start_date) THEN
26131: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
26132: FND_MESSAGE.Set_Token('COLUMN', 'EXTENDED ATTRIBUTE START_DATE');
26133: FND_MSG_PUB.ADD;
26134: RAISE FND_API.G_EXC_ERROR;
26135: END IF;
26136: END IF;
26153:
26154: -- Verify attribute id
26155: IF ( p_ext_attrib_rec.attribute_id <> FND_API.G_MISS_NUM) THEN
26156: IF (l_ext_attrib_rec.attribute_id <> l_ext_attrib_rec.attribute_id) THEN
26157: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
26158: FND_MESSAGE.Set_Token('COLUMN', 'EXTENDED ATTRIBUTE_ID');
26159: FND_MSG_PUB.ADD;
26160: RAISE FND_API.G_EXC_ERROR;
26161: END IF;
26154: -- Verify attribute id
26155: IF ( p_ext_attrib_rec.attribute_id <> FND_API.G_MISS_NUM) THEN
26156: IF (l_ext_attrib_rec.attribute_id <> l_ext_attrib_rec.attribute_id) THEN
26157: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
26158: FND_MESSAGE.Set_Token('COLUMN', 'EXTENDED ATTRIBUTE_ID');
26159: FND_MSG_PUB.ADD;
26160: RAISE FND_API.G_EXC_ERROR;
26161: END IF;
26162: END IF;
27406: -- into l_curr_instance_rec.
27407: /*
27408: IF ((p_source_instance_rec.VLD_ORGANIZATION_ID = FND_API.G_MISS_NUM)
27409: OR (p_source_instance_rec.VLD_ORGANIZATION_ID IS NULL)) THEN
27410: FND_MESSAGE.SET_NAME('CSI','CSI_API_VLD_ORG_ID_NULL');
27411: FND_MSG_PUB.Add;
27412: RAISE FND_API.G_EXC_ERROR;
27413: ELSE
27414: l_new_instance_rec.VLD_ORGANIZATION_ID := p_source_instance_rec.VLD_ORGANIZATION_ID;
27432: -- End addition by sk for bug 2186683
27433:
27434: IF (p_source_instance_rec.instance_id IS NULL) OR
27435: (p_source_instance_rec.instance_id = FND_API.G_MISS_NUM) THEN
27436: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_ID_NULL');
27437: FND_MSG_PUB.Add;
27438: RAISE FND_API.G_EXC_ERROR;
27439: ELSIF NOT (csi_Item_Instance_Vld_pvt.Val_and_get_inst_rec(
27440: p_source_instance_rec.instance_id ,
27444:
27445: -- Check if the user has not passed incorrect options for contacts
27446: IF ((p_copy_parties = fnd_api.g_false)
27447: AND (p_copy_contacts = fnd_api.g_true)) THEN
27448: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_PTY_CONTACT_OPT');
27449: FND_MSG_PUB.Add;
27450: RAISE FND_API.G_EXC_ERROR;
27451: END IF;
27452: -- If the user has passed p_copy_parties as false get only the owner, else get all the parties
28616: IF ((l_contact_tbl(tab_row_contact).contact_ip_id IS NULL) OR
28617: (l_contact_tbl(tab_row_contact).contact_ip_id
28618: = FND_API.G_MISS_NUM)
28619: OR NOT(l_contact_found_flag) ) THEN
28620: FND_MESSAGE.SET_NAME('CSI','CSI_API_CONTACT_IP_ID_NULL');
28621: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',
28622: l_contact_tbl(tab_row_contact).instance_party_id);
28623: FND_MSG_PUB.Add;
28624: RAISE FND_API.G_EXC_ERROR;
28617: (l_contact_tbl(tab_row_contact).contact_ip_id
28618: = FND_API.G_MISS_NUM)
28619: OR NOT(l_contact_found_flag) ) THEN
28620: FND_MESSAGE.SET_NAME('CSI','CSI_API_CONTACT_IP_ID_NULL');
28621: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',
28622: l_contact_tbl(tab_row_contact).instance_party_id);
28623: FND_MSG_PUB.Add;
28624: RAISE FND_API.G_EXC_ERROR;
28625: END IF;
28981: IF (p_source_instance_rec.VERSION_LABEL IS NULL ) OR
28982: (p_source_instance_rec.VERSION_LABEL = FND_API.G_MISS_CHAR) THEN
28983: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
28984: IF l_version_label IS NULL THEN
28985: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
28986: FND_MSG_PUB.ADD;
28987: RAISE FND_API.G_EXC_ERROR;
28988: ELSE
28989: l_new_instance_rec.version_label := l_version_label;
29015:
29016: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
29017: csi_gen_utility_pvt.put_line( ' Error from COPY_SINGLE_ITEM_INSTANCE.CREATE_VERSION_LABEL..');
29018: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
29019: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
29020: FND_MESSAGE.SET_TOKEN('API_ERROR','CREATE_VERSION_LABEL');
29021: FND_MSG_PUB.Add;
29022: RAISE FND_API.G_EXC_ERROR;
29023: END IF;
29016: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
29017: csi_gen_utility_pvt.put_line( ' Error from COPY_SINGLE_ITEM_INSTANCE.CREATE_VERSION_LABEL..');
29018: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
29019: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
29020: FND_MESSAGE.SET_TOKEN('API_ERROR','CREATE_VERSION_LABEL');
29021: FND_MSG_PUB.Add;
29022: RAISE FND_API.G_EXC_ERROR;
29023: END IF;
29024: -- End of Addition by rtalluri for Bug: 2420897 on 08/19/02
29036: --
29037: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
29038: --
29039: IF l_internal_party_id IS NULL THEN
29040: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
29041: FND_MSG_PUB.ADD;
29042: RAISE FND_API.G_EXC_ERROR;
29043: END IF;
29044: --
29320: -- Verify instance quantity
29321: IF ((p_source_instance_rec.QUANTITY IS NULL)
29322: OR (p_source_instance_rec.QUANTITY = FND_API.G_MISS_NUM )
29323: OR (p_source_instance_rec.QUANTITY <> 1)) THEN
29324: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');
29325: FND_MESSAGE.SET_TOKEN('QUANTITY',p_source_instance_rec.QUANTITY);
29326: FND_MSG_PUB.Add;
29327: RAISE FND_API.G_EXC_ERROR;
29328: END IF;
29321: IF ((p_source_instance_rec.QUANTITY IS NULL)
29322: OR (p_source_instance_rec.QUANTITY = FND_API.G_MISS_NUM )
29323: OR (p_source_instance_rec.QUANTITY <> 1)) THEN
29324: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');
29325: FND_MESSAGE.SET_TOKEN('QUANTITY',p_source_instance_rec.QUANTITY);
29326: FND_MSG_PUB.Add;
29327: RAISE FND_API.G_EXC_ERROR;
29328: END IF;
29329: -- Verify the Passed Inventory Item is Trackable
29350: --
29351: IF p_create_instance = FND_API.G_TRUE THEN
29352: IF (p_source_instance_rec.instance_id IS NULL) OR
29353: (p_source_instance_rec.instance_id = FND_API.G_MISS_NUM) THEN
29354: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_ID_NULL');
29355: FND_MSG_PUB.Add;
29356: RAISE FND_API.G_EXC_ERROR;
29357: END IF;
29358: --
29396: csi_gen_utility_pvt.put_line (' Bom explosion error code > 0 '|| l_Error_Code ||' '||l_err_msg);
29397: ELSIF l_Error_Code > 0 THEN
29398: csi_gen_utility_pvt.put_line (' Bom explosion error code < 0'|| l_Error_Code ||' '||l_err_msg);
29399: END IF;
29400: FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');
29401: FND_MSG_PUB.Add;
29402: RAISE FND_API.G_EXC_ERROR;
29403: END IF; -- error
29404: --
32249:
32250:
32251: IF (p_source_instance_rec.instance_id IS NULL) OR
32252: (p_source_instance_rec.instance_id = FND_API.G_MISS_NUM) THEN
32253: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_ID_NULL');
32254: FND_MSG_PUB.Add;
32255: RAISE FND_API.G_EXC_ERROR;
32256: ELSIF NOT (csi_Item_Instance_Vld_pvt.Val_and_get_inst_rec(
32257: p_source_instance_rec.instance_id ,
32262:
32263: -- Check if the user has not passed incorrect options for contacts
32264: IF ((p_copy_parties = fnd_api.g_false)
32265: AND (p_copy_contacts = fnd_api.g_true)) THEN
32266: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_PTY_CONTACT_OPT');
32267: FND_MSG_PUB.Add;
32268: RAISE FND_API.G_EXC_ERROR;
32269: END IF;
32270:
33380: IF ((l_contact_tbl(tab_row_contact).contact_ip_id IS NULL) OR
33381: (l_contact_tbl(tab_row_contact).contact_ip_id
33382: = FND_API.G_MISS_NUM)
33383: OR NOT(l_contact_found_flag) ) THEN
33384: FND_MESSAGE.SET_NAME('CSI','CSI_API_CONTACT_IP_ID_NULL');
33385: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',
33386: l_contact_tbl(tab_row_contact).instance_party_id);
33387: FND_MSG_PUB.Add;
33388: RAISE FND_API.G_EXC_ERROR;
33381: (l_contact_tbl(tab_row_contact).contact_ip_id
33382: = FND_API.G_MISS_NUM)
33383: OR NOT(l_contact_found_flag) ) THEN
33384: FND_MESSAGE.SET_NAME('CSI','CSI_API_CONTACT_IP_ID_NULL');
33385: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',
33386: l_contact_tbl(tab_row_contact).instance_party_id);
33387: FND_MSG_PUB.Add;
33388: RAISE FND_API.G_EXC_ERROR;
33389: END IF;
33737: IF (p_source_instance_rec.VERSION_LABEL IS NULL ) OR
33738: (p_source_instance_rec.VERSION_LABEL = FND_API.G_MISS_CHAR) THEN
33739: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
33740: IF l_version_label IS NULL THEN
33741: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
33742: FND_MSG_PUB.ADD;
33743: RAISE FND_API.G_EXC_ERROR;
33744: ELSE
33745: l_new_instance_rec.version_label := l_version_label;
33771:
33772: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
33773: csi_gen_utility_pvt.put_line( ' Error from COPY_ITEM_INSTANCE.CREATE_VERSION_LABEL..');
33774: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
33775: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
33776: FND_MESSAGE.SET_TOKEN('API_ERROR','CREATE_VERSION_LABEL');
33777: FND_MSG_PUB.Add;
33778: RAISE FND_API.G_EXC_ERROR;
33779: END IF;
33772: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
33773: csi_gen_utility_pvt.put_line( ' Error from COPY_ITEM_INSTANCE.CREATE_VERSION_LABEL..');
33774: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
33775: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
33776: FND_MESSAGE.SET_TOKEN('API_ERROR','CREATE_VERSION_LABEL');
33777: FND_MSG_PUB.Add;
33778: RAISE FND_API.G_EXC_ERROR;
33779: END IF;
33780: -- End of Addition by rtalluri for Bug: 2420897 on 08/19/02
33792: --
33793: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
33794: --
33795: IF l_internal_party_id IS NULL THEN
33796: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
33797: FND_MSG_PUB.ADD;
33798: RAISE FND_API.G_EXC_ERROR;
33799: END IF;
33800:
33916: x_msg_data => x_msg_data
33917: );
33918: --
33919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
33920: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
33921: FND_MSG_PUB.Add;
33922: RAISE FND_API.G_EXC_ERROR;
33923: END IF;
33924: END IF;
34509:
34510: -- Start API body
34511: IF (p_instance_id IS NULL)
34512: THEN
34513: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_INSTANCE_ID');
34514: FND_MESSAGE.Set_Token('INSTANCE_ID', p_instance_id);
34515: FND_MSG_PUB.ADD;
34516: RAISE FND_API.G_EXC_ERROR;
34517: END IF;
34510: -- Start API body
34511: IF (p_instance_id IS NULL)
34512: THEN
34513: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_INSTANCE_ID');
34514: FND_MESSAGE.Set_Token('INSTANCE_ID', p_instance_id);
34515: FND_MSG_PUB.ADD;
34516: RAISE FND_API.G_EXC_ERROR;
34517: END IF;
34518:
34915: END LOOP;
34916:
34917: IF l_dup_count > 1
34918: THEN
34919: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_INS_KEY');
34920: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
34921: FND_MSG_PUB.Add;
34922: RAISE FND_API.G_EXC_ERROR;
34923: END IF;
34916:
34917: IF l_dup_count > 1
34918: THEN
34919: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_INS_KEY');
34920: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
34921: FND_MSG_PUB.Add;
34922: RAISE FND_API.G_EXC_ERROR;
34923: END IF;
34924: END IF;
34949: END LOOP;
34950:
34951: IF l_dup_count > 1
34952: THEN
34953: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_KEYS_LOCKED');
34954: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
34955: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
34956: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
34957: FND_MSG_PUB.Add;
34950:
34951: IF l_dup_count > 1
34952: THEN
34953: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_KEYS_LOCKED');
34954: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
34955: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
34956: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
34957: FND_MSG_PUB.Add;
34958: RAISE FND_API.G_EXC_ERROR;
34951: IF l_dup_count > 1
34952: THEN
34953: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_KEYS_LOCKED');
34954: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
34955: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
34956: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
34957: FND_MSG_PUB.Add;
34958: RAISE FND_API.G_EXC_ERROR;
34959: END IF;
34952: THEN
34953: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_KEYS_LOCKED');
34954: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
34955: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
34956: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
34957: FND_MSG_PUB.Add;
34958: RAISE FND_API.G_EXC_ERROR;
34959: END IF;
34960: END IF;
34964: px_config_tbl(i).instance_id <> fnd_api.g_miss_num)
34965: THEN
34966: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => px_config_tbl(i).instance_id)
34967: THEN
34968: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
34969: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
34970: FND_MSG_PUB.Add;
34971: RAISE FND_API.G_EXC_ERROR;
34972: ELSE
34965: THEN
34966: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => px_config_tbl(i).instance_id)
34967: THEN
34968: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
34969: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
34970: FND_MSG_PUB.Add;
34971: RAISE FND_API.G_EXC_ERROR;
34972: ELSE
34973: l_found:='N';
35012: );
35013:
35014:
35015: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
35016: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
35017: FND_MSG_PUB.Add;
35018: RAISE FND_API.G_EXC_ERROR;
35019: END IF;
35020: l_lock_count:=l_lock_tbl.COUNT+1;
35044: l_lock_count:=l_lock_tbl.COUNT+1;
35045: l_lock_tbl(l_lock_count).instance_id:=l_rel_tbl(l_chld_csr).subject_id;
35046: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => l_rel_tbl(l_chld_csr).subject_id)
35047: THEN
35048: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35049: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_lock_tbl(l_lock_count).instance_id);
35050: FND_MSG_PUB.Add;
35051: RAISE FND_API.G_EXC_ERROR;
35052: END IF;
35045: l_lock_tbl(l_lock_count).instance_id:=l_rel_tbl(l_chld_csr).subject_id;
35046: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => l_rel_tbl(l_chld_csr).subject_id)
35047: THEN
35048: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35049: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_lock_tbl(l_lock_count).instance_id);
35050: FND_MSG_PUB.Add;
35051: RAISE FND_API.G_EXC_ERROR;
35052: END IF;
35053: l_lock_tbl(l_lock_count).root_instance_id:=l_root_node;
35069: ,p_config_inst_item_id => px_config_tbl(i).config_inst_item_id
35070: ,p_config_inst_rev_num => px_config_tbl(i).config_inst_rev_num
35071: )
35072: THEN
35073: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEYS_LOCKED');
35074: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35075: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35076: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35077: FND_MSG_PUB.Add;
35070: ,p_config_inst_rev_num => px_config_tbl(i).config_inst_rev_num
35071: )
35072: THEN
35073: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEYS_LOCKED');
35074: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35075: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35076: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35077: FND_MSG_PUB.Add;
35078: RAISE FND_API.G_EXC_ERROR;
35071: )
35072: THEN
35073: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEYS_LOCKED');
35074: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35075: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35076: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35077: FND_MSG_PUB.Add;
35078: RAISE FND_API.G_EXC_ERROR;
35079: ELSE
35072: THEN
35073: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEYS_LOCKED');
35074: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35075: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35076: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35077: FND_MSG_PUB.Add;
35078: RAISE FND_API.G_EXC_ERROR;
35079: ELSE
35080: l_lock_count:=l_lock_tbl.COUNT+1;
35108: px_config_tbl(i).lock_status:=2;
35109: END IF;
35110: END IF;
35111: ELSE
35112: FND_MESSAGE.SET_NAME('CSI','CSI_PASSED_INVALID_KEYS');
35113: FND_MSG_PUB.Add;
35114: RAISE FND_API.G_EXC_ERROR;
35115: END IF;
35116:
35309: ,x_msg_data => x_msg_data
35310: );
35311:
35312: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
35313: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
35314: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
35315: FND_MSG_PUB.Add;
35316: RAISE FND_API.G_EXC_ERROR;
35317: END IF;
35310: );
35311:
35312: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
35313: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
35314: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
35315: FND_MSG_PUB.Add;
35316: RAISE FND_API.G_EXC_ERROR;
35317: END IF;
35318: */
35744: --l_unlock_config(l_config_count+l_bld).source_txn_line_ref3 :=p_config_tbl(i).source_txn_line_ref3;
35745: IF l_bld_unlock_tbl(l_bld).lock_status = 2 AND
35746: p_config_tbl(i).source_application_id = 542
35747: THEN
35748: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_UNLOCK_TREE');
35749: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35750: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35751: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35752: FND_MSG_PUB.Add;
35745: IF l_bld_unlock_tbl(l_bld).lock_status = 2 AND
35746: p_config_tbl(i).source_application_id = 542
35747: THEN
35748: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_UNLOCK_TREE');
35749: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35750: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35751: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35752: FND_MSG_PUB.Add;
35753: RAISE FND_API.G_EXC_ERROR;
35746: p_config_tbl(i).source_application_id = 542
35747: THEN
35748: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_UNLOCK_TREE');
35749: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35750: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35751: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35752: FND_MSG_PUB.Add;
35753: RAISE FND_API.G_EXC_ERROR;
35754: ELSIF (p_config_tbl(i).lock_status IS NULL OR
35747: THEN
35748: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_UNLOCK_TREE');
35749: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35750: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35751: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35752: FND_MSG_PUB.Add;
35753: RAISE FND_API.G_EXC_ERROR;
35754: ELSIF (p_config_tbl(i).lock_status IS NULL OR
35755: p_config_tbl(i).lock_status NOT IN (0,1)) OR
35754: ELSIF (p_config_tbl(i).lock_status IS NULL OR
35755: p_config_tbl(i).lock_status NOT IN (0,1)) OR
35756: p_config_tbl(i).lock_status > l_bld_unlock_tbl(l_bld).lock_status
35757: THEN
35758: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35759: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
35760: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35761: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35762: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35755: p_config_tbl(i).lock_status NOT IN (0,1)) OR
35756: p_config_tbl(i).lock_status > l_bld_unlock_tbl(l_bld).lock_status
35757: THEN
35758: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35759: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
35760: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35761: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35762: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35763: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35756: p_config_tbl(i).lock_status > l_bld_unlock_tbl(l_bld).lock_status
35757: THEN
35758: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35759: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
35760: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35761: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35762: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35763: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35764: FND_MSG_PUB.Add;
35757: THEN
35758: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35759: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
35760: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35761: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35762: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35763: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35764: FND_MSG_PUB.Add;
35765: RAISE FND_API.G_EXC_ERROR;
35758: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35759: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
35760: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35761: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35762: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35763: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35764: FND_MSG_PUB.Add;
35765: RAISE FND_API.G_EXC_ERROR;
35766: END IF;
35759: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
35760: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35761: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
35762: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
35763: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
35764: FND_MSG_PUB.Add;
35765: RAISE FND_API.G_EXC_ERROR;
35766: END IF;
35767: END IF;
35855: IF (p_config_tbl(i).lock_status IS NULL OR
35856: p_config_tbl(i).lock_status NOT IN (0,1)) OR
35857: p_config_tbl(i).lock_status > l_valid_lock_status
35858: THEN
35859: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INS_STATUS');
35860: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35861: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35862: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_config_tbl(i).instance_id);
35863: FND_MSG_PUB.Add;
35856: p_config_tbl(i).lock_status NOT IN (0,1)) OR
35857: p_config_tbl(i).lock_status > l_valid_lock_status
35858: THEN
35859: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INS_STATUS');
35860: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35861: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35862: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_config_tbl(i).instance_id);
35863: FND_MSG_PUB.Add;
35864: RAISE FND_API.G_EXC_ERROR;
35857: p_config_tbl(i).lock_status > l_valid_lock_status
35858: THEN
35859: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INS_STATUS');
35860: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35861: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35862: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_config_tbl(i).instance_id);
35863: FND_MSG_PUB.Add;
35864: RAISE FND_API.G_EXC_ERROR;
35865: END IF;
35858: THEN
35859: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INS_STATUS');
35860: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35861: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35862: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_config_tbl(i).instance_id);
35863: FND_MSG_PUB.Add;
35864: RAISE FND_API.G_EXC_ERROR;
35865: END IF;
35866: ELSE
35927: IF (p_config_tbl(i).lock_status IS NULL OR
35928: p_config_tbl(i).lock_status NOT IN (0,1)) OR
35929: p_config_tbl(i).lock_status > l_valid_lock_status
35930: THEN
35931: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35932: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35933: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35934: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
35935: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
35928: p_config_tbl(i).lock_status NOT IN (0,1)) OR
35929: p_config_tbl(i).lock_status > l_valid_lock_status
35930: THEN
35931: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35932: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35933: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35934: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
35935: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
35936: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
35929: p_config_tbl(i).lock_status > l_valid_lock_status
35930: THEN
35931: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35932: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35933: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35934: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
35935: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
35936: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
35937: FND_MSG_PUB.Add;
35930: THEN
35931: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35932: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35933: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35934: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
35935: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
35936: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
35937: FND_MSG_PUB.Add;
35938: RAISE FND_API.G_EXC_ERROR;
35931: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
35932: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35933: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35934: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
35935: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
35936: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
35937: FND_MSG_PUB.Add;
35938: RAISE FND_API.G_EXC_ERROR;
35939: END IF;
35932: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
35933: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
35934: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
35935: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
35936: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
35937: FND_MSG_PUB.Add;
35938: RAISE FND_API.G_EXC_ERROR;
35939: END IF;
35940: ELSE
35959: END IF;
35960:
35961: IF l_warning = 'Y'
35962: THEN
35963: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LOCKS');
35964: FND_MSG_PUB.Add;
35965: ELSIF l_warning = 'E'
35966: THEN
35967: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKID_NOT_PASSED');
35963: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LOCKS');
35964: FND_MSG_PUB.Add;
35965: ELSIF l_warning = 'E'
35966: THEN
35967: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKID_NOT_PASSED');
35968: FND_MSG_PUB.Add;
35969: RAISE FND_API.G_EXC_ERROR;
35970: END IF;
35971: csi_gen_utility_pvt.put_line('Count of l_unlock_tbl is :'||l_unlock_tbl.count);
36000: AND lock_id = l_unlock_ins_tbl(i).lock_id
36001: AND lock_status IN (1,2);
36002: IF l_instance_ctr >1 -- this includes root
36003: THEN
36004: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INST_STATUS');
36005: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_unlock_ins_tbl(i).instance_id);
36006: FND_MSG_PUB.Add;
36007: RAISE FND_API.G_EXC_ERROR;
36008: END IF;
36001: AND lock_status IN (1,2);
36002: IF l_instance_ctr >1 -- this includes root
36003: THEN
36004: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INST_STATUS');
36005: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_unlock_ins_tbl(i).instance_id);
36006: FND_MSG_PUB.Add;
36007: RAISE FND_API.G_EXC_ERROR;
36008: END IF;
36009: END IF;
36031: AND lock_id = l_unlock_root(i).lock_id
36032: AND lock_status IN (1,2);
36033: IF l_config_ctr >1 -- this includes root
36034: THEN
36035: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONF_STATUS');
36036: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_unlock_root(i).config_inst_hdr_id);
36037: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_unlock_root(i).config_inst_item_id);
36038: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_unlock_root(i).config_inst_rev_num);
36039: FND_MSG_PUB.Add;
36032: AND lock_status IN (1,2);
36033: IF l_config_ctr >1 -- this includes root
36034: THEN
36035: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONF_STATUS');
36036: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_unlock_root(i).config_inst_hdr_id);
36037: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_unlock_root(i).config_inst_item_id);
36038: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_unlock_root(i).config_inst_rev_num);
36039: FND_MSG_PUB.Add;
36040: RAISE FND_API.G_EXC_ERROR;
36033: IF l_config_ctr >1 -- this includes root
36034: THEN
36035: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONF_STATUS');
36036: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_unlock_root(i).config_inst_hdr_id);
36037: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_unlock_root(i).config_inst_item_id);
36038: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_unlock_root(i).config_inst_rev_num);
36039: FND_MSG_PUB.Add;
36040: RAISE FND_API.G_EXC_ERROR;
36041: END IF;
36034: THEN
36035: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONF_STATUS');
36036: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_unlock_root(i).config_inst_hdr_id);
36037: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_unlock_root(i).config_inst_item_id);
36038: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_unlock_root(i).config_inst_rev_num);
36039: FND_MSG_PUB.Add;
36040: RAISE FND_API.G_EXC_ERROR;
36041: END IF;
36042: END IF;