[Home] [Help]
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;
4762: (p_instance_rec.inv_master_organization_id <> FND_API.G_MISS_NUM))
4763: THEN
4764: IF NOT (csi_Item_Instance_Vld_Pvt.Is_Valid_Master_Org
4765: (p_instance_rec.inv_master_organization_id)) THEN
4766: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_MAST_ORG');
4767: FND_MSG_PUB.Add;
4768: RAISE FND_API.G_EXC_ERROR;
4769: END IF;
4770: p_instance_rec.vld_organization_id := p_instance_rec.inv_master_organization_id;
4782: WHERE organization_id = p_instance_rec.vld_organization_id
4783: AND master_organization_id = p_instance_rec.inv_master_organization_id;
4784: EXCEPTION
4785: WHEN NO_DATA_FOUND THEN
4786: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_VLD_MAST_COMB');
4787: FND_MSG_PUB.Add;
4788: RAISE FND_API.G_EXC_ERROR;
4789: END;
4790: ELSE
4787: FND_MSG_PUB.Add;
4788: RAISE FND_API.G_EXC_ERROR;
4789: END;
4790: ELSE
4791: FND_MESSAGE.SET_NAME('CSI','CSI_NO_VLD_ORG');
4792: FND_MSG_PUB.Add;
4793: RAISE FND_API.G_EXC_ERROR;
4794: END IF;
4795: -- End of modifications by sk on 02/19/02 for bug 2198575
4828: FROM hr_all_organization_units
4829: WHERE organization_id = p_instance_rec.vld_organization_id;
4830: EXCEPTION
4831: WHEN NO_DATA_FOUND THEN
4832: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4833: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4834: fnd_msg_pub.ADD;
4835: RAISE fnd_api.g_exc_error;
4836: END;
4829: WHERE organization_id = p_instance_rec.vld_organization_id;
4830: EXCEPTION
4831: WHEN NO_DATA_FOUND THEN
4832: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4833: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4834: fnd_msg_pub.ADD;
4835: RAISE fnd_api.g_exc_error;
4836: END;
4837: IF p_instance_rec.location_id IS NULL
4835: RAISE fnd_api.g_exc_error;
4836: END;
4837: IF p_instance_rec.location_id IS NULL
4838: THEN
4839: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4840: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4841: fnd_msg_pub.ADD;
4842: RAISE fnd_api.g_exc_error;
4843: END IF;
4836: END;
4837: IF p_instance_rec.location_id IS NULL
4838: THEN
4839: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4840: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4841: fnd_msg_pub.ADD;
4842: RAISE fnd_api.g_exc_error;
4843: END IF;
4844: END IF;
4855: FROM hr_all_organization_units
4856: WHERE organization_id = p_instance_rec.vld_organization_id;
4857: EXCEPTION
4858: WHEN NO_DATA_FOUND THEN
4859: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4860: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4861: fnd_msg_pub.ADD;
4862: RAISE fnd_api.g_exc_error;
4863: END;
4856: WHERE organization_id = p_instance_rec.vld_organization_id;
4857: EXCEPTION
4858: WHEN NO_DATA_FOUND THEN
4859: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4860: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4861: fnd_msg_pub.ADD;
4862: RAISE fnd_api.g_exc_error;
4863: END;
4864: IF p_instance_rec.install_location_id IS NULL
4862: RAISE fnd_api.g_exc_error;
4863: END;
4864: IF p_instance_rec.install_location_id IS NULL
4865: THEN
4866: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4867: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4868: fnd_msg_pub.ADD;
4869: RAISE fnd_api.g_exc_error;
4870: END IF;
4863: END;
4864: IF p_instance_rec.install_location_id IS NULL
4865: THEN
4866: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
4867: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4868: fnd_msg_pub.ADD;
4869: RAISE fnd_api.g_exc_error;
4870: END IF;
4871: END IF;
4910: END IF;
4911: END LOOP;
4912: IF l_valid_flag <> 'Y'
4913: THEN
4914: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4915: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4916: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4917: FND_MSG_PUB.Add;
4918: RAISE fnd_api.g_exc_error;
4911: END LOOP;
4912: IF l_valid_flag <> 'Y'
4913: THEN
4914: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4915: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4916: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4917: FND_MSG_PUB.Add;
4918: RAISE fnd_api.g_exc_error;
4919: END IF;
4912: IF l_valid_flag <> 'Y'
4913: THEN
4914: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4915: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4916: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4917: FND_MSG_PUB.Add;
4918: RAISE fnd_api.g_exc_error;
4919: END IF;
4920: END IF;
4940: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'Y';
4941: Exception
4942: when others then
4943:
4944: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4945: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4946: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4947: FND_MSG_PUB.Add;
4948: RAISE fnd_api.g_exc_error;
4941: Exception
4942: when others then
4943:
4944: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4945: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4946: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4947: FND_MSG_PUB.Add;
4948: RAISE fnd_api.g_exc_error;
4949: End;
4942: when others then
4943:
4944: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4945: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4946: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4947: FND_MSG_PUB.Add;
4948: RAISE fnd_api.g_exc_error;
4949: End;
4950: --
4978: p_item_attribute_tbl(p_ins_count_rec.inv_count).equipment_type := l_equipment_type;
4979: EXCEPTION
4980: WHEN OTHERS THEN
4981: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4982: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4983: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4984: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4985: FND_MSG_PUB.Add;
4986: RAISE fnd_api.g_exc_error;
4979: EXCEPTION
4980: WHEN OTHERS THEN
4981: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4982: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4983: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4984: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4985: FND_MSG_PUB.Add;
4986: RAISE fnd_api.g_exc_error;
4987: END;
4980: WHEN OTHERS THEN
4981: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
4982: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
4983: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
4984: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
4985: FND_MSG_PUB.Add;
4986: RAISE fnd_api.g_exc_error;
4987: END;
4988: End if;
5079: ,x_reason_failed => l_reason_failed
5080: ,x_token => l_token
5081: )
5082: THEN
5083: -- FND_MESSAGE.SET_NAME('CSI', l_reason_failed); -- commented for bug 5351886
5084: -- FND_MSG_PUB.Add; -- commented for bug 5351886
5085: csi_gen_utility_pvt.put_line('Call to eam_assetnumber_pub.validate_fields failed with following reason');
5086: csi_gen_utility_pvt.put_line(l_reason_failed);
5087: RAISE FND_API.G_EXC_ERROR;
5086: csi_gen_utility_pvt.put_line(l_reason_failed);
5087: RAISE FND_API.G_EXC_ERROR;
5088: END IF;
5089: ELSE
5090: FND_MESSAGE.SET_NAME('CSI', 'CSI_NON_EAM_ITEM');
5091: FND_MSG_PUB.Add;
5092: RAISE FND_API.G_EXC_ERROR;
5093: END IF;
5094: END IF;
5275: -- Validation for Location Source and Location ID
5276: IF p_instance_rec.location_type_code = FND_API.G_MISS_CHAR OR
5277: p_instance_rec.location_type_code IS NULL THEN
5278: IF p_instance_rec.creation_complete_flag = 'Y' THEN
5279: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_LOCATION');
5280: FND_MSG_PUB.ADD;
5281: RAISE fnd_api.g_exc_error;
5282: ELSE
5283: p_instance_rec.creation_complete_flag := 'N';
5284: END IF;
5285: ELSE
5286: IF p_instance_rec.location_id IS NULL OR
5287: p_instance_rec.location_id = FND_API.G_MISS_NUM THEN
5288: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
5289: FND_MSG_PUB.ADD;
5290: RAISE fnd_api.g_exc_error;
5291: ELSE
5292: -- Validate location_id
5303: END IF;
5304: End Loop;
5305: --
5306: IF l_valid_flag <> 'Y' THEN
5307: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
5308: FND_MSG_PUB.ADD;
5309: RAISE fnd_api.g_exc_error;
5310: END IF;
5311: END IF; -- p_location_tbl count
5358: RAISE fnd_api.g_exc_error;
5359: END IF;
5360: --validation for accounting classification_code
5361: IF (p_party_tbl.count < 1) THEN
5362: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_PARTY_RECORD');
5363: FND_MSG_PUB.Add;
5364: RAISE FND_API.G_EXC_ERROR;
5365: ELSE
5366: FOR l_count IN p_party_tbl.FIRST..p_party_tbl.LAST LOOP
5371: END IF;
5372: END IF;
5373: END LOOP;
5374: IF l_owner_count <> 1 THEN
5375: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_EXISTS');
5376: FND_MESSAGE.SET_TOKEN('OWNER',l_owner);
5377: FND_MSG_PUB.Add;
5378: RAISE fnd_api.g_exc_error;
5379: END IF;
5372: END IF;
5373: END LOOP;
5374: IF l_owner_count <> 1 THEN
5375: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_EXISTS');
5376: FND_MESSAGE.SET_TOKEN('OWNER',l_owner);
5377: FND_MSG_PUB.Add;
5378: RAISE fnd_api.g_exc_error;
5379: END IF;
5380: --
5384: --
5385: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5386: --
5387: IF l_int_party_id IS NULL THEN
5388: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5389: FND_MSG_PUB.ADD;
5390: RAISE FND_API.G_EXC_ERROR;
5391: END IF;
5392: --
5414: p_instance_rec.accounting_class_code := 'CUST_PROD';
5415: ELSE
5416: IF ((p_instance_rec.accounting_class_code = 'WIP') OR
5417: (p_instance_rec.accounting_class_code = 'PROJECT')) THEN
5418: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_CLASS');
5419: FND_MSG_PUB.Add;
5420: RAISE FND_API.G_EXC_ERROR;
5421: END IF;
5422: END IF;
5493: IF ((p_instance_rec.active_start_date IS NOT NULL) AND
5494: (p_instance_rec.active_start_date <> FND_API.G_MISS_DATE)) AND
5495: (p_instance_rec.active_start_date > SYSDATE)
5496: THEN
5497: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_START_DATE');
5498: FND_MSG_PUB.Add;
5499: RAISE FND_API.G_EXC_ERROR;
5500: END IF;
5501:
5523: END IF;
5524: END LOOP;
5525: --
5526: IF l_valid_flag <> 'Y' THEN
5527: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM_CONDITION');
5528: FND_MESSAGE.SET_TOKEN('INSTANCE_CONDITION_ID',p_instance_rec.instance_condition_id);
5529: FND_MSG_PUB.Add;
5530: RAISE fnd_api.g_exc_error;
5531: END IF;
5524: END LOOP;
5525: --
5526: IF l_valid_flag <> 'Y' THEN
5527: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM_CONDITION');
5528: FND_MESSAGE.SET_TOKEN('INSTANCE_CONDITION_ID',p_instance_rec.instance_condition_id);
5529: FND_MSG_PUB.Add;
5530: RAISE fnd_api.g_exc_error;
5531: END IF;
5532: END IF;
5563: FROM csi_instance_statuses
5564: WHERE name = l_instance_status;
5565: --
5566: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5567: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5568: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5569: FND_MSG_PUB.Add;
5570: RAISE FND_API.G_EXC_ERROR;
5571: END IF;
5564: WHERE name = l_instance_status;
5565: --
5566: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5567: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5568: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5569: FND_MSG_PUB.Add;
5570: RAISE FND_API.G_EXC_ERROR;
5571: END IF;
5572: EXCEPTION
5570: RAISE FND_API.G_EXC_ERROR;
5571: END IF;
5572: EXCEPTION
5573: WHEN NO_DATA_FOUND THEN
5574: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5575: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5576: FND_MSG_PUB.Add;
5577: RAISE FND_API.G_EXC_ERROR;
5578: END;
5571: END IF;
5572: EXCEPTION
5573: WHEN NO_DATA_FOUND THEN
5574: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5575: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5576: FND_MSG_PUB.Add;
5577: RAISE FND_API.G_EXC_ERROR;
5578: END;
5579: ELSIF (p_instance_rec.instance_status_id = 1) THEN
5576: FND_MSG_PUB.Add;
5577: RAISE FND_API.G_EXC_ERROR;
5578: END;
5579: ELSIF (p_instance_rec.instance_status_id = 1) THEN
5580: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5581: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5582: FND_MSG_PUB.Add;
5583: RAISE FND_API.G_EXC_ERROR;
5584: ELSE
5577: RAISE FND_API.G_EXC_ERROR;
5578: END;
5579: ELSIF (p_instance_rec.instance_status_id = 1) THEN
5580: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5581: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5582: FND_MSG_PUB.Add;
5583: RAISE FND_API.G_EXC_ERROR;
5584: ELSE
5585: IF p_generic_id_tbl.count > 0 THEN
5594: END IF;
5595: END LOOP;
5596: --
5597: IF l_valid_flag <> 'Y' THEN
5598: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5599: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5600: FND_MSG_PUB.Add;
5601: RAISE FND_API.G_EXC_ERROR;
5602: END IF;
5595: END LOOP;
5596: --
5597: IF l_valid_flag <> 'Y' THEN
5598: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5599: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5600: FND_MSG_PUB.Add;
5601: RAISE FND_API.G_EXC_ERROR;
5602: END IF;
5603: --
5601: RAISE FND_API.G_EXC_ERROR;
5602: END IF;
5603: --
5604: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5605: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5606: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5607: FND_MSG_PUB.Add;
5608: RAISE FND_API.G_EXC_ERROR;
5609: END IF;
5602: END IF;
5603: --
5604: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5605: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5606: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5607: FND_MSG_PUB.Add;
5608: RAISE FND_API.G_EXC_ERROR;
5609: END IF;
5610: END IF;
5622: p_generic_id_tbl(p_ins_count_rec.generic_count).valid_flag := 'Y';
5623: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := l_terminated_flag;
5624: --
5625: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5626: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5627: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5628: FND_MSG_PUB.Add;
5629: RAISE FND_API.G_EXC_ERROR;
5630: END IF;
5623: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := l_terminated_flag;
5624: --
5625: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5626: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');
5627: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5628: FND_MSG_PUB.Add;
5629: RAISE FND_API.G_EXC_ERROR;
5630: END IF;
5631: Exception
5631: Exception
5632: when others then
5633: p_generic_id_tbl(p_ins_count_rec.generic_count).valid_flag := 'N';
5634: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := NULL;
5635: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5636: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5637: FND_MSG_PUB.Add;
5638: RAISE FND_API.G_EXC_ERROR;
5639: End;
5632: when others then
5633: p_generic_id_tbl(p_ins_count_rec.generic_count).valid_flag := 'N';
5634: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := NULL;
5635: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
5636: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',p_instance_rec.instance_status_id);
5637: FND_MSG_PUB.Add;
5638: RAISE FND_API.G_EXC_ERROR;
5639: End;
5640: END IF;
5656: END IF;
5657: END LOOP;
5658: --
5659: IF l_valid_flag <> 'Y' THEN
5660: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SYSTEM_ID');
5661: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_instance_rec.system_id);
5662: FND_MSG_PUB.Add;
5663: RAISE fnd_api.g_exc_error;
5664: END IF;
5657: END LOOP;
5658: --
5659: IF l_valid_flag <> 'Y' THEN
5660: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SYSTEM_ID');
5661: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_instance_rec.system_id);
5662: FND_MSG_PUB.Add;
5663: RAISE fnd_api.g_exc_error;
5664: END IF;
5665: END IF;
5694: END IF;
5695: END LOOP;
5696: --
5697: IF l_valid_flag <> 'Y' THEN
5698: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_TYPE');
5699: FND_MESSAGE.SET_TOKEN('INSTANCE_TYPE_CODE',p_instance_rec.instance_type_code);
5700: FND_MSG_PUB.Add;
5701: RAISE fnd_api.g_exc_error;
5702: END IF;
5695: END LOOP;
5696: --
5697: IF l_valid_flag <> 'Y' THEN
5698: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_TYPE');
5699: FND_MESSAGE.SET_TOKEN('INSTANCE_TYPE_CODE',p_instance_rec.instance_type_code);
5700: FND_MSG_PUB.Add;
5701: RAISE fnd_api.g_exc_error;
5702: END IF;
5703: END IF;
5731: END IF;
5732: End Loop;
5733: --
5734: if l_valid_flag <> 'Y' then
5735: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_USAGE_CODE');
5736: FND_MESSAGE.SET_TOKEN('INSTANCE_USAGE_CODE',p_instance_rec.instance_usage_code);
5737: FND_MSG_PUB.Add;
5738: RAISE fnd_api.g_exc_error;
5739: end if;
5732: End Loop;
5733: --
5734: if l_valid_flag <> 'Y' then
5735: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_USAGE_CODE');
5736: FND_MESSAGE.SET_TOKEN('INSTANCE_USAGE_CODE',p_instance_rec.instance_usage_code);
5737: FND_MSG_PUB.Add;
5738: RAISE fnd_api.g_exc_error;
5739: end if;
5740: End if;
5770: END IF;
5771: End Loop;
5772: --
5773: if l_valid_flag <> 'Y' then
5774: FND_MESSAGE.SET_NAME('CSI','CSI_OPERATIONAL_STATUS_CODE');
5775: FND_MESSAGE.SET_TOKEN('OPERATIONAL_STATUS_CODE',p_instance_rec.operational_status_code);
5776: FND_MSG_PUB.Add;
5777: RAISE fnd_api.g_exc_error;
5778: end if;
5771: End Loop;
5772: --
5773: if l_valid_flag <> 'Y' then
5774: FND_MESSAGE.SET_NAME('CSI','CSI_OPERATIONAL_STATUS_CODE');
5775: FND_MESSAGE.SET_TOKEN('OPERATIONAL_STATUS_CODE',p_instance_rec.operational_status_code);
5776: FND_MSG_PUB.Add;
5777: RAISE fnd_api.g_exc_error;
5778: end if;
5779: End if;
5902: (p_instance_rec.sales_unit_price IS NOT NULL AND
5903: p_instance_rec.sales_unit_price <> FND_API.G_MISS_NUM))
5904: )
5905: THEN
5906: FND_MESSAGE.SET_NAME('CSI','CSI_NO_PRICE_OR_CODE');
5907: FND_MSG_PUB.Add;
5908: RAISE fnd_api.g_exc_error;
5909: END IF;
5910: -- End addition of columns for FA Integration
5990: p_instance_rec.install_location_type_code = 'HR_LOCATIONS'
5991: THEN
5992: IF p_instance_rec.install_location_id IS NULL OR
5993: p_instance_rec.install_location_id = FND_API.G_MISS_NUM THEN
5994: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
5995: FND_MSG_PUB.ADD;
5996: RAISE fnd_api.g_exc_error;
5997: END IF;
5998: --
6009: END IF;
6010: End Loop;
6011: --
6012: IF l_valid_flag <> 'Y' THEN
6013: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
6014: FND_MSG_PUB.ADD;
6015: RAISE fnd_api.g_exc_error;
6016: END IF;
6017: END IF;
6033: RAISE fnd_api.g_exc_error;
6034: END IF;
6035: END IF;
6036: ELSE
6037: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
6038: FND_MSG_PUB.Add;
6039: RAISE FND_API.G_EXC_ERROR;
6040: END IF;
6041: END IF;
6218: );
6219:
6220: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
6221: THEN
6222: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6223: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6224: FND_MSG_PUB.Add;
6225: RAISE FND_API.G_EXC_ERROR;
6226: END IF;
6219:
6220: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
6221: THEN
6222: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6223: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6224: FND_MSG_PUB.Add;
6225: RAISE FND_API.G_EXC_ERROR;
6226: END IF;
6227: -- srramakr Bug # 2255391. In CTO, since the configured item is created as a part of Sales Order
6292: ,x_ctr_grp_id_instance => l_ctr_grp_id_instance
6293: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
6294: );
6295: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6296: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6297: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6298: FND_MSG_PUB.Add;
6299: RAISE FND_API.G_EXC_ERROR;
6300: END IF; -- return status
6293: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
6294: );
6295: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6296: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6297: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6298: FND_MSG_PUB.Add;
6299: RAISE FND_API.G_EXC_ERROR;
6300: END IF; -- return status
6301: END IF; -- ctr. grp template exists1
6340: ,x_msg_data => x_msg_data
6341: );
6342:
6343: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6344: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
6345: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
6346: FND_MSG_PUB.Add;
6347: RAISE FND_API.G_EXC_ERROR;
6348: END IF;
6341: );
6342:
6343: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6344: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
6345: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
6346: FND_MSG_PUB.Add;
6347: RAISE FND_API.G_EXC_ERROR;
6348: END IF;
6349:
6572: );
6573:
6574:
6575: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6576: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_HISTORY');
6577: FND_MSG_PUB.Add;
6578: RAISE FND_API.G_EXC_ERROR;
6579: END IF;
6580:
6961: FROM csi_item_instances
6962: WHERE instance_id = l_instance_rec.instance_id;
6963: EXCEPTION
6964: WHEN NO_DATA_FOUND THEN
6965: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_NUM');
6966: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', l_instance_rec.instance_id);
6967: FND_MSG_PUB.Add;
6968: RAISE FND_API.G_EXC_ERROR;
6969: END;
6962: WHERE instance_id = l_instance_rec.instance_id;
6963: EXCEPTION
6964: WHEN NO_DATA_FOUND THEN
6965: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_NUM');
6966: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER', l_instance_rec.instance_id);
6967: FND_MSG_PUB.Add;
6968: RAISE FND_API.G_EXC_ERROR;
6969: END;
6970:
7535: --
7536: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7537: --
7538: IF l_internal_party_id IS NULL THEN
7539: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
7540: FND_MSG_PUB.ADD;
7541: RAISE FND_API.G_EXC_ERROR;
7542: END IF;
7543: --
7581: x_msg_data => x_msg_data
7582: );
7583: --
7584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7585: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
7586: FND_MSG_PUB.Add;
7587: RAISE FND_API.G_EXC_ERROR;
7588: END IF;
7589: ELSE
7601: x_msg_data => x_msg_data
7602: );
7603: --
7604: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7605: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
7606: FND_MSG_PUB.Add;
7607: RAISE FND_API.G_EXC_ERROR;
7608: END IF;
7609: END IF;
7620: -- Opening Cursor to retrieve Child Id records Details
7621: OPEN curr_instance_rec(l_rel_tbl(j).subject_id);
7622: FETCH curr_instance_rec INTO l_curr_instance_rec;
7623: IF curr_instance_rec%NOTFOUND THEN
7624: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
7625: FND_MSG_PUB.ADD;
7626: RAISE FND_API.G_EXC_ERROR;
7627: END IF;
7628: CLOSE curr_instance_rec;
8000: --
8001: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
8002: --
8003: IF l_full_dump_frequency IS NULL THEN
8004: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
8005: FND_MSG_PUB.ADD;
8006: RAISE FND_API.G_EXC_ERROR;
8007: END IF;
8008: --
10218: -- Opening New Cursor to retrieve Child Id records Details
10219: OPEN new_instance_rec(l_rel_tbl(j).subject_id);
10220: FETCH new_instance_rec INTO l_new_instance_rec;
10221: IF new_instance_rec%NOTFOUND THEN
10222: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
10223: FND_MSG_PUB.ADD;
10224: RAISE FND_API.G_EXC_ERROR;
10225: END IF;
10226: CLOSE new_instance_rec;
11093: --
11094: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
11095: --
11096: IF l_internal_party_id IS NULL THEN
11097: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
11098: FND_MSG_PUB.ADD;
11099: RAISE FND_API.G_EXC_ERROR;
11100: END IF;
11101: --
11233:
11234: IF l_txn_exists IS NOT NULL AND p_txn_type_id <> 53 --End of:Added for bug 5615162
11235: THEN
11236: x_return_status := fnd_api.g_ret_sts_error ;
11237: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11238: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11239: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11240: fnd_msg_pub.add;
11241: RAISE fnd_api.g_exc_error;
11234: IF l_txn_exists IS NOT NULL AND p_txn_type_id <> 53 --End of:Added for bug 5615162
11235: THEN
11236: x_return_status := fnd_api.g_ret_sts_error ;
11237: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11238: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11239: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11240: fnd_msg_pub.add;
11241: RAISE fnd_api.g_exc_error;
11242: END IF;
11235: THEN
11236: x_return_status := fnd_api.g_ret_sts_error ;
11237: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11238: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11239: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11240: fnd_msg_pub.add;
11241: RAISE fnd_api.g_exc_error;
11242: END IF;
11243: EXCEPTION
11248: END;
11249: ELSIF (( p_source_transaction_date IS NOT NULL) AND (p_source_transaction_date > SYSDATE)) AND
11250: p_source_transaction_date <> fnd_api.g_miss_date THEN
11251: x_return_status := fnd_api.g_ret_sts_error ;
11252: fnd_message.set_name('CSI', 'CSI_PASS_TXNS_GT_SYS');
11253: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11254: fnd_msg_pub.add;
11255: RAISE fnd_api.g_exc_error;
11256: END IF;
11249: ELSIF (( p_source_transaction_date IS NOT NULL) AND (p_source_transaction_date > SYSDATE)) AND
11250: p_source_transaction_date <> fnd_api.g_miss_date THEN
11251: x_return_status := fnd_api.g_ret_sts_error ;
11252: fnd_message.set_name('CSI', 'CSI_PASS_TXNS_GT_SYS');
11253: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11254: fnd_msg_pub.add;
11255: RAISE fnd_api.g_exc_error;
11256: END IF;
11257: p_oks_txn_inst_tbl(J).transfer_date := l_transaction_date;
11521: AND transaction_id <> p_transaction_id
11522: AND ROWNUM=1;
11523: IF l_temp IS NOT NULL THEN
11524: x_return_status := fnd_api.g_ret_sts_error ;
11525: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11526: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11527: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11528: fnd_msg_pub.add;
11529: RAISE fnd_api.g_exc_error;
11522: AND ROWNUM=1;
11523: IF l_temp IS NOT NULL THEN
11524: x_return_status := fnd_api.g_ret_sts_error ;
11525: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11526: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11527: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11528: fnd_msg_pub.add;
11529: RAISE fnd_api.g_exc_error;
11530: END IF;
11523: IF l_temp IS NOT NULL THEN
11524: x_return_status := fnd_api.g_ret_sts_error ;
11525: fnd_message.set_name('CSI', 'CSI_HAS_TXNS_GT_SYS');
11526: fnd_message.set_token('INSTANCE_ID',p_instance_id );
11527: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11528: fnd_msg_pub.add;
11529: RAISE fnd_api.g_exc_error;
11530: END IF;
11531: EXCEPTION
11536: END;
11537: ELSIF (( p_source_transaction_date IS NOT NULL) AND (p_source_transaction_date > SYSDATE)) AND
11538: p_source_transaction_date <> fnd_api.g_miss_date THEN
11539: x_return_status := fnd_api.g_ret_sts_error ;
11540: fnd_message.set_name('CSI', 'CSI_PASS_TXNS_GT_SYS');
11541: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11542: fnd_msg_pub.add;
11543: RAISE fnd_api.g_exc_error;
11544: END IF;
11537: ELSIF (( p_source_transaction_date IS NOT NULL) AND (p_source_transaction_date > SYSDATE)) AND
11538: p_source_transaction_date <> fnd_api.g_miss_date THEN
11539: x_return_status := fnd_api.g_ret_sts_error ;
11540: fnd_message.set_name('CSI', 'CSI_PASS_TXNS_GT_SYS');
11541: fnd_message.set_token('SOURCE_TXN_DATE',to_char(p_source_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
11542: fnd_msg_pub.add;
11543: RAISE fnd_api.g_exc_error;
11544: END IF;
11545: p_oks_txn_inst_tbl(l_oks_txn_count).transfer_date := l_transaction_date;
11595: csi_gen_utility_pvt.put_line('End Call_to_Contracts : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
11596: WHEN fnd_api.g_exc_error THEN
11597: RAISE fnd_api.g_exc_error;
11598: WHEN OTHERS THEN
11599: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
11600: FND_MESSAGE.Set_Token('API_NAME', 'Call_to_Contracts');
11601: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
11602: FND_MSG_PUB.Add;
11603: RAISE fnd_api.g_exc_error;
11596: WHEN fnd_api.g_exc_error THEN
11597: RAISE fnd_api.g_exc_error;
11598: WHEN OTHERS THEN
11599: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
11600: FND_MESSAGE.Set_Token('API_NAME', 'Call_to_Contracts');
11601: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
11602: FND_MSG_PUB.Add;
11603: RAISE fnd_api.g_exc_error;
11604: END Call_to_Contracts;
11597: RAISE fnd_api.g_exc_error;
11598: WHEN OTHERS THEN
11599: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
11600: FND_MESSAGE.Set_Token('API_NAME', 'Call_to_Contracts');
11601: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
11602: FND_MSG_PUB.Add;
11603: RAISE fnd_api.g_exc_error;
11604: END Call_to_Contracts;
11605:
12270: -- in the database else raise error
12271: OPEN curr_instance_rec(p_instance_rec.INSTANCE_ID);
12272: FETCH curr_instance_rec INTO l_curr_instance_rec;
12273: IF (l_curr_instance_rec.object_version_number <> nvl(p_instance_rec.OBJECT_VERSION_NUMBER,0)) THEN
12274: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
12275: FND_MSG_PUB.ADD;
12276: RAISE FND_API.G_EXC_ERROR;
12277: END IF;
12278: CLOSE curr_instance_rec;
12313: (l_lock_status = 0)
12314: THEN
12315: NULL;
12316: ELSE
12317: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_LOCKED');
12318: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
12319: FND_MSG_PUB.ADD;
12320: RAISE FND_API.G_EXC_ERROR;
12321: END IF;
12314: THEN
12315: NULL;
12316: ELSE
12317: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_LOCKED');
12318: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
12319: FND_MSG_PUB.ADD;
12320: RAISE FND_API.G_EXC_ERROR;
12321: END IF;
12322: END IF;
12483: IF (NOT l_wip_loc_chgd) AND (l_get_instance_rec.location_type_code <> 'INVENTORY' AND
12484: l_cur_instance_rec.last_vld_organization_id <> l_get_instance_rec.vld_organization_id
12485: AND l_curr_instance_rec.instance_usage_code <> 'IN_TRANSIT') --Added for bug 6188180
12486: THEN
12487: FND_MESSAGE.Set_Name('CSI', 'CSI_CANNOT_MODIFY_VLD_ORG');
12488: FND_MSG_PUB.ADD;
12489: RAISE FND_API.G_EXC_ERROR;
12490: END IF;
12491:
12522: IF NOT(CSI_Item_Instance_vld_pvt.Is_Forward_Synch
12523: (p_instance_id => p_instance_rec.INSTANCE_ID,
12524: p_stop_all_txn => fnd_api.g_true,
12525: p_mtl_txn_id => fnd_api.g_miss_num)) THEN
12526: FND_MESSAGE.Set_Name('CSI', 'CSI_API_NO_FORWARD_SYNCH');
12527: FND_MESSAGE.Set_Token('INSTANCE', p_instance_rec.INSTANCE_ID);
12528: FND_MSG_PUB.ADD;
12529: RAISE FND_API.G_EXC_ERROR;
12530: END IF;
12523: (p_instance_id => p_instance_rec.INSTANCE_ID,
12524: p_stop_all_txn => fnd_api.g_true,
12525: p_mtl_txn_id => fnd_api.g_miss_num)) THEN
12526: FND_MESSAGE.Set_Name('CSI', 'CSI_API_NO_FORWARD_SYNCH');
12527: FND_MESSAGE.Set_Token('INSTANCE', p_instance_rec.INSTANCE_ID);
12528: FND_MSG_PUB.ADD;
12529: RAISE FND_API.G_EXC_ERROR;
12530: END IF;
12531: ELSE -- Even if seq exists, stop later txns
12532: IF NOT(CSI_Item_Instance_vld_pvt.Is_Forward_Synch
12533: (p_instance_id => p_instance_rec.INSTANCE_ID,
12534: p_stop_all_txn => fnd_api.g_false, -- Stop only later txns
12535: p_mtl_txn_id => p_txn_rec.inv_material_transaction_id)) THEN
12536: FND_MESSAGE.Set_Name('CSI', 'CSI_API_NO_FORWARD_SYNCH');
12537: FND_MESSAGE.Set_Token('INSTANCE', p_instance_rec.INSTANCE_ID);
12538: FND_MSG_PUB.ADD;
12539: RAISE FND_API.G_EXC_ERROR;
12540: END IF;
12533: (p_instance_id => p_instance_rec.INSTANCE_ID,
12534: p_stop_all_txn => fnd_api.g_false, -- Stop only later txns
12535: p_mtl_txn_id => p_txn_rec.inv_material_transaction_id)) THEN
12536: FND_MESSAGE.Set_Name('CSI', 'CSI_API_NO_FORWARD_SYNCH');
12537: FND_MESSAGE.Set_Token('INSTANCE', p_instance_rec.INSTANCE_ID);
12538: FND_MSG_PUB.ADD;
12539: RAISE FND_API.G_EXC_ERROR;
12540: END IF;
12541: END IF;
12544: IF ((p_instance_rec.instance_id IS NULL) OR
12545: (p_instance_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
12546: IF ((p_instance_rec.instance_id IS NULL) OR
12547: (p_instance_rec.instance_id <> l_curr_instance_rec.instance_id)) THEN
12548: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12549: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');
12550: FND_MSG_PUB.ADD;
12551: RAISE FND_API.G_EXC_ERROR;
12552: END IF;
12545: (p_instance_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
12546: IF ((p_instance_rec.instance_id IS NULL) OR
12547: (p_instance_rec.instance_id <> l_curr_instance_rec.instance_id)) THEN
12548: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12549: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');
12550: FND_MSG_PUB.ADD;
12551: RAISE FND_API.G_EXC_ERROR;
12552: END IF;
12553: END IF;
12566: RAISE fnd_api.g_exc_error;
12567: END IF;
12568: -- End addition for eam integration
12569: /*
12570: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12571: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_NUMBER');
12572: FND_MSG_PUB.ADD;
12573: RAISE FND_API.G_EXC_ERROR;
12574: */
12567: END IF;
12568: -- End addition for eam integration
12569: /*
12570: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12571: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_NUMBER');
12572: FND_MSG_PUB.ADD;
12573: RAISE FND_API.G_EXC_ERROR;
12574: */
12575: END IF;
12596: cptv.non_source_instance_id = p_instance_rec.instance_id)));
12597:
12598: IF(l_number_open_ro>0)
12599: THEN
12600: FND_MESSAGE.Set_Name('CSI', 'CSI_OPEN_RO_EXISTS');
12601: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID OR SERIAL_NUMBER');
12602: FND_MSG_PUB.ADD;
12603: RAISE FND_API.G_EXC_ERROR;
12604:
12597:
12598: IF(l_number_open_ro>0)
12599: THEN
12600: FND_MESSAGE.Set_Name('CSI', 'CSI_OPEN_RO_EXISTS');
12601: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID OR SERIAL_NUMBER');
12602: FND_MSG_PUB.ADD;
12603: RAISE FND_API.G_EXC_ERROR;
12604:
12605: END IF;
12607:
12608: --validation for open depot repair orders for CMRO
12609:
12610: IF p_instance_rec.inventory_item_id IS NULL THEN
12611: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_ITEM');
12612: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12613: fnd_message.set_token('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12614: FND_MSG_PUB.ADD;
12615: RAISE FND_API.G_EXC_ERROR;
12608: --validation for open depot repair orders for CMRO
12609:
12610: IF p_instance_rec.inventory_item_id IS NULL THEN
12611: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_ITEM');
12612: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12613: fnd_message.set_token('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12614: FND_MSG_PUB.ADD;
12615: RAISE FND_API.G_EXC_ERROR;
12616: ELSE
12609:
12610: IF p_instance_rec.inventory_item_id IS NULL THEN
12611: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_ITEM');
12612: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12613: fnd_message.set_token('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12614: FND_MSG_PUB.ADD;
12615: RAISE FND_API.G_EXC_ERROR;
12616: ELSE
12617: IF (p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM)
12622:
12623: THEN
12624: l_part_or_serial_change := TRUE;
12625: ELSE
12626: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12627: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID');
12628: FND_MSG_PUB.ADD;
12629: RAISE FND_API.G_EXC_ERROR;
12630: END IF;
12623: THEN
12624: l_part_or_serial_change := TRUE;
12625: ELSE
12626: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12627: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID');
12628: FND_MSG_PUB.ADD;
12629: RAISE FND_API.G_EXC_ERROR;
12630: END IF;
12631: END IF;
12648: p_inventory_item_id => p_instance_rec.inventory_item_id,
12649: p_serial_number => p_instance_rec.serial_number,
12650: x_mtl_txn_tbl => l_mtl_txn_tbl);
12651: IF NVL(l_mtl_txn_tbl.Count,0) > 0 THEN
12652: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12653: FND_MESSAGE.Set_Token('COLUMN', 'SERIAL_NUMBER');
12654: FND_MSG_PUB.ADD;
12655: RAISE FND_API.G_EXC_ERROR;
12656: END IF;
12649: p_serial_number => p_instance_rec.serial_number,
12650: x_mtl_txn_tbl => l_mtl_txn_tbl);
12651: IF NVL(l_mtl_txn_tbl.Count,0) > 0 THEN
12652: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12653: FND_MESSAGE.Set_Token('COLUMN', 'SERIAL_NUMBER');
12654: FND_MSG_PUB.ADD;
12655: RAISE FND_API.G_EXC_ERROR;
12656: END IF;
12657: ELSE
12654: FND_MSG_PUB.ADD;
12655: RAISE FND_API.G_EXC_ERROR;
12656: END IF;
12657: ELSE
12658: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12659: FND_MESSAGE.Set_Token('COLUMN', 'SERIAL_NUMBER');
12660: FND_MSG_PUB.ADD;
12661: RAISE FND_API.G_EXC_ERROR;
12662: END IF;
12655: RAISE FND_API.G_EXC_ERROR;
12656: END IF;
12657: ELSE
12658: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12659: FND_MESSAGE.Set_Token('COLUMN', 'SERIAL_NUMBER');
12660: FND_MSG_PUB.ADD;
12661: RAISE FND_API.G_EXC_ERROR;
12662: END IF;
12663: */ -- Commented for bug 6965008
12666: --end of code for 6176621
12667:
12668: --
12669: IF p_instance_rec.instance_status_id IS NULL THEN
12670: FND_MESSAGE.Set_Name('CSI','CSI_API_MANDATORY_STATUS');
12671: FND_MSG_PUB.ADD;
12672: RAISE FND_API.G_EXC_ERROR;
12673: END IF;
12674: --
12672: RAISE FND_API.G_EXC_ERROR;
12673: END IF;
12674: --
12675: IF p_instance_rec.quantity IS NULL THEN
12676: FND_MESSAGE.Set_Name('CSI','CSI_API_MANDATORY_QUANTITY');
12677: FND_MSG_PUB.ADD;
12678: RAISE FND_API.G_EXC_ERROR;
12679: END IF;
12680: --
12678: RAISE FND_API.G_EXC_ERROR;
12679: END IF;
12680: --
12681: IF p_instance_rec.unit_of_measure IS NULL THEN
12682: FND_MESSAGE.Set_Name('CSI','CSI_API_MANDATORY_UOM');
12683: FND_MSG_PUB.ADD;
12684: RAISE FND_API.G_EXC_ERROR;
12685: END IF;
12686: --
12703: WHERE organization_id = p_instance_rec.vld_organization_id
12704: AND master_organization_id = p_instance_rec.inv_master_organization_id;
12705: EXCEPTION
12706: WHEN NO_DATA_FOUND THEN
12707: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_VLD_MAST_COMB');
12708: FND_MSG_PUB.Add;
12709: RAISE FND_API.G_EXC_ERROR;
12710: END;
12711: /***** FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12707: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_VLD_MAST_COMB');
12708: FND_MSG_PUB.Add;
12709: RAISE FND_API.G_EXC_ERROR;
12710: END;
12711: /***** FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12712: FND_MESSAGE.Set_Token('COLUMN', 'INV_MASTER_ORGANIZATION_ID');
12713: FND_MSG_PUB.ADD;
12714: RAISE FND_API.G_EXC_ERROR; *****/
12715: END IF;
12708: FND_MSG_PUB.Add;
12709: RAISE FND_API.G_EXC_ERROR;
12710: END;
12711: /***** FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12712: FND_MESSAGE.Set_Token('COLUMN', 'INV_MASTER_ORGANIZATION_ID');
12713: FND_MSG_PUB.ADD;
12714: RAISE FND_API.G_EXC_ERROR; *****/
12715: END IF;
12716: END IF;
12731: l_get_instance_rec.location_id:=p_instance_rec.location_id;
12732:
12733: EXCEPTION
12734: WHEN NO_DATA_FOUND THEN
12735: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12736: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12737: fnd_msg_pub.ADD;
12738: RAISE fnd_api.g_exc_error;
12739: END;
12732:
12733: EXCEPTION
12734: WHEN NO_DATA_FOUND THEN
12735: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12736: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12737: fnd_msg_pub.ADD;
12738: RAISE fnd_api.g_exc_error;
12739: END;
12740: IF p_instance_rec.location_id IS NULL
12738: RAISE fnd_api.g_exc_error;
12739: END;
12740: IF p_instance_rec.location_id IS NULL
12741: THEN
12742: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12743: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12744: fnd_msg_pub.ADD;
12745: RAISE fnd_api.g_exc_error;
12746: END IF;
12739: END;
12740: IF p_instance_rec.location_id IS NULL
12741: THEN
12742: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12743: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12744: fnd_msg_pub.ADD;
12745: RAISE fnd_api.g_exc_error;
12746: END IF;
12747: END IF;
12758: FROM hr_all_organization_units
12759: WHERE organization_id = p_instance_rec.vld_organization_id;
12760: EXCEPTION
12761: WHEN NO_DATA_FOUND THEN
12762: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12763: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12764: fnd_msg_pub.ADD;
12765: RAISE fnd_api.g_exc_error;
12766: END;
12759: WHERE organization_id = p_instance_rec.vld_organization_id;
12760: EXCEPTION
12761: WHEN NO_DATA_FOUND THEN
12762: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12763: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12764: fnd_msg_pub.ADD;
12765: RAISE fnd_api.g_exc_error;
12766: END;
12767: IF p_instance_rec.install_location_id IS NULL
12765: RAISE fnd_api.g_exc_error;
12766: END;
12767: IF p_instance_rec.install_location_id IS NULL
12768: THEN
12769: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12770: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12771: fnd_msg_pub.ADD;
12772: RAISE fnd_api.g_exc_error;
12773: END IF;
12766: END;
12767: IF p_instance_rec.install_location_id IS NULL
12768: THEN
12769: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');
12770: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12771: fnd_msg_pub.ADD;
12772: RAISE fnd_api.g_exc_error;
12773: END IF;
12774: END IF;
12781: IF ((p_instance_rec.active_start_date IS NULL) OR
12782: (p_instance_rec.active_start_date <> FND_API.G_MISS_DATE)) THEN
12783: IF ((p_instance_rec.active_start_date IS NULL) OR
12784: (p_instance_rec.active_start_date <> l_curr_instance_rec.active_start_date)) THEN
12785: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12786: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
12787: FND_MSG_PUB.ADD;
12788: RAISE FND_API.G_EXC_ERROR;
12789: END IF;
12782: (p_instance_rec.active_start_date <> FND_API.G_MISS_DATE)) THEN
12783: IF ((p_instance_rec.active_start_date IS NULL) OR
12784: (p_instance_rec.active_start_date <> l_curr_instance_rec.active_start_date)) THEN
12785: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
12786: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
12787: FND_MSG_PUB.ADD;
12788: RAISE FND_API.G_EXC_ERROR;
12789: END IF;
12790: END IF;
12795: (p_instance_rec.active_end_date < SYSDATE) THEN
12796: IF (p_instance_rec.check_for_instance_expiry = fnd_api.g_true) THEN
12797: IF NOT (p_called_from_rel = fnd_api.g_true OR p_txn_rec.transaction_type_id = 401)
12798: THEN
12799: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_UPD_EXP_ITEM');
12800: FND_MSG_PUB.ADD;
12801: RAISE FND_API.G_EXC_ERROR;
12802: END IF;
12803: END IF;
12829: (p_instance_rec.instance_status_id)))
12830: THEN
12831: IF ((p_instance_rec.ACTIVE_END_DATE IS NULL) OR
12832: (p_instance_rec.ACTIVE_END_DATE = FND_API.G_MISS_DATE)) THEN
12833: FND_MESSAGE.Set_Name('CSI', 'CSI_API_TER_DATE');
12834: FND_MSG_PUB.ADD;
12835: RAISE FND_API.G_EXC_ERROR;
12836: ELSIF p_instance_rec.ACTIVE_END_DATE < sysdate THEN
12837: IF NOT(CSI_Item_Instance_vld_pvt.EndDate_Valid
12842: RAISE FND_API.G_EXC_ERROR;
12843: END IF;
12844: ELSIF ((p_instance_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE) AND
12845: (p_instance_rec.ACTIVE_END_DATE > sysdate)) THEN
12846: FND_MESSAGE.Set_Name('CSI', 'CSI_API_FUTURE_DATE');
12847: FND_MSG_PUB.ADD;
12848: RAISE FND_API.G_EXC_ERROR;
12849: END IF;
12850: END IF;
12873: EXIT;
12874: END IF;
12875: END LOOP;
12876: IF l_valid_flag = 'N' then
12877: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12878: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12879: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12880: FND_MSG_PUB.Add;
12881: RAISE fnd_api.g_exc_error;
12874: END IF;
12875: END LOOP;
12876: IF l_valid_flag = 'N' then
12877: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12878: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12879: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12880: FND_MSG_PUB.Add;
12881: RAISE fnd_api.g_exc_error;
12882: END IF;
12875: END LOOP;
12876: IF l_valid_flag = 'N' then
12877: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12878: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
12879: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12880: FND_MSG_PUB.Add;
12881: RAISE fnd_api.g_exc_error;
12882: END IF;
12883: END IF;
12905: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'Y';
12906: EXCEPTION
12907: WHEN OTHERS THEN
12908: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12909: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12910: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12911: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12912: FND_MSG_PUB.Add;
12913: RAISE fnd_api.g_exc_error;
12906: EXCEPTION
12907: WHEN OTHERS THEN
12908: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12909: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12910: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12911: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12912: FND_MSG_PUB.Add;
12913: RAISE fnd_api.g_exc_error;
12914: END;
12907: WHEN OTHERS THEN
12908: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12909: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12910: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12911: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12912: FND_MSG_PUB.Add;
12913: RAISE fnd_api.g_exc_error;
12914: END;
12915:
12944: p_item_attribute_tbl(p_ins_count_rec.inv_count).equipment_type := l_equipment_type;
12945: EXCEPTION
12946: WHEN OTHERS THEN
12947: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12948: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12949: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12950: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12951: FND_MSG_PUB.Add;
12952: RAISE fnd_api.g_exc_error;
12945: EXCEPTION
12946: WHEN OTHERS THEN
12947: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12948: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12949: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12950: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12951: FND_MSG_PUB.Add;
12952: RAISE fnd_api.g_exc_error;
12953: END;
12946: WHEN OTHERS THEN
12947: p_item_attribute_tbl(p_ins_count_rec.inv_count).valid_flag := 'N';
12948: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
12949: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_get_instance_rec.inventory_item_id);
12950: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
12951: FND_MSG_PUB.Add;
12952: RAISE fnd_api.g_exc_error;
12953: END;
12954: END IF;
13046: ,x_reason_failed => l_reason_failed
13047: ,x_token => l_token
13048: )
13049: THEN
13050: -- FND_MESSAGE.SET_NAME('CSI', l_reason_failed); -- commented for bug 5351886
13051: -- FND_MSG_PUB.Add; -- commented for bug 5351886
13052: csi_gen_utility_pvt.put_line('Call to eam_assetnumber_pub.validate_fields failed with following reason');
13053: csi_gen_utility_pvt.put_line(l_reason_failed);
13054: RAISE FND_API.G_EXC_ERROR;
13053: csi_gen_utility_pvt.put_line(l_reason_failed);
13054: RAISE FND_API.G_EXC_ERROR;
13055: END IF;
13056: ELSE
13057: FND_MESSAGE.SET_NAME('CSI', 'CSI_NON_EAM_ITEM');
13058: FND_MSG_PUB.Add;
13059: RAISE FND_API.G_EXC_ERROR;
13060: END IF;
13061: END IF;
13064: IF l_get_instance_rec.system_id IS NOT NULL AND
13065: l_get_instance_rec.system_id <> FND_API.G_MISS_NUM THEN
13066: IF NOT csi_Item_Instance_Vld_pvt.Is_Valid_System_id(
13067: l_get_instance_rec.system_id) THEN
13068: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SYSTEM_ID');
13069: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',l_get_instance_rec.system_id);
13070: FND_MSG_PUB.Add;
13071: RAISE FND_API.G_EXC_ERROR;
13072: END IF;
13065: l_get_instance_rec.system_id <> FND_API.G_MISS_NUM THEN
13066: IF NOT csi_Item_Instance_Vld_pvt.Is_Valid_System_id(
13067: l_get_instance_rec.system_id) THEN
13068: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_SYSTEM_ID');
13069: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',l_get_instance_rec.system_id);
13070: FND_MSG_PUB.Add;
13071: RAISE FND_API.G_EXC_ERROR;
13072: END IF;
13073: END IF;
13118:
13119: --start code fix for 6176621
13120:
13121: IF l_serial_control not in (2, 5) and l_part_or_serial_change THEN
13122: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_UPD_SRL');
13123: FND_MSG_PUB.Add;
13124: RAISE FND_API.g_exc_error;
13125: END IF;
13126:
13128:
13129: -- Updating a Serial Number to NULL is not allowed.
13130: IF l_curr_instance_rec.serial_number IS NOT NULL AND
13131: p_instance_rec.serial_number IS NULL THEN
13132: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_UPD_SRL_NULL');
13133: FND_MSG_PUB.Add;
13134: RAISE FND_API.G_EXC_ERROR;
13135: END IF;
13136: --
13270: ,l_return_value => l_return_value
13271: );
13272: IF l_return_value = FALSE THEN
13273: --Commented out code for bug 7657438, no need to raise more than one error message
13274: --fnd_message.set_name('CSI','CSI_FAIL_UNIQUENESS');
13275: --fnd_msg_pub.add;
13276: RAISE fnd_api.g_exc_error;
13277: END IF;
13278: END IF;
13350: );
13351:
13352: IF l_return_value = FALSE
13353: THEN
13354: FND_MESSAGE.Set_Name('CSI', 'CSI_CHANGE_VLD_ORG');
13355: FND_MSG_PUB.ADD;
13356: RAISE FND_API.G_EXC_ERROR;
13357: END IF;
13358: END IF;
13400: p_instance_rec.accounting_class_code := l_acct_class_code;
13401: -- END IF;
13402: ELSE
13403: IF (p_instance_rec.accounting_class_code <> l_acct_class_code) THEN
13404: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_CLASS');
13405: FND_MSG_PUB.Add;
13406: RAISE FND_API.G_EXC_ERROR;
13407: END IF;
13408: END IF; -- not null
13442: AND ((p_instance_rec.quantity = 0) OR (p_instance_rec.quantity = FND_API.G_MISS_NUM))
13443: --AND ((p_instance_rec.active_end_date IS NULL) OR (p_instance_rec.active_end_date > SYSDATE))
13444: AND ((p_instance_rec.active_end_date IS NULL) OR (p_instance_rec.active_end_date > l_curr_instance_rec.active_end_date))
13445: THEN
13446: FND_MESSAGE.Set_Name('CSI', 'CSI_API_CANNOT_UNEXPIRE');
13447: FND_MSG_PUB.ADD;
13448: RAISE FND_API.G_EXC_ERROR;
13449: END IF;
13450:
13465: THEN
13466: IF (CSI_Item_Instance_vld_pvt.val_inst_ter_flag --added first change
13467: (l_get_instance_rec.instance_status_id))
13468: THEN
13469: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_STATUS');
13470: FND_MSG_PUB.ADD;
13471: RAISE FND_API.G_EXC_ERROR;
13472: END IF;
13473: END IF;
13493: end if;
13494: End Loop;
13495: --
13496: if l_valid_flag <> 'Y' then
13497: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM_CONDITION');
13498: FND_MESSAGE.SET_TOKEN('INSTANCE_CONDITION_ID',p_instance_rec.instance_condition_id);
13499: FND_MSG_PUB.Add;
13500: RAISE fnd_api.g_exc_error;
13501: end if;
13494: End Loop;
13495: --
13496: if l_valid_flag <> 'Y' then
13497: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM_CONDITION');
13498: FND_MESSAGE.SET_TOKEN('INSTANCE_CONDITION_ID',p_instance_rec.instance_condition_id);
13499: FND_MSG_PUB.Add;
13500: RAISE fnd_api.g_exc_error;
13501: end if;
13502: end if;
13576: end if;
13577: End Loop;
13578: --
13579: if l_valid_flag <> 'Y' then
13580: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_TYPE');
13581: FND_MESSAGE.SET_TOKEN('INSTANCE_TYPE_CODE',p_instance_rec.instance_type_code);
13582: FND_MSG_PUB.Add;
13583: RAISE fnd_api.g_exc_error;
13584: end if;
13577: End Loop;
13578: --
13579: if l_valid_flag <> 'Y' then
13580: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_TYPE');
13581: FND_MESSAGE.SET_TOKEN('INSTANCE_TYPE_CODE',p_instance_rec.instance_type_code);
13582: FND_MSG_PUB.Add;
13583: RAISE fnd_api.g_exc_error;
13584: end if;
13585: End if;
13616: end if;
13617: End Loop;
13618: --
13619: if l_valid_flag <> 'Y' then
13620: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_USAGE_CODE');
13621: FND_MESSAGE.SET_TOKEN('INSTANCE_USAGE_CODE',p_instance_rec.instance_usage_code);
13622: FND_MSG_PUB.Add;
13623: RAISE fnd_api.g_exc_error;
13624: end if;
13617: End Loop;
13618: --
13619: if l_valid_flag <> 'Y' then
13620: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_USAGE_CODE');
13621: FND_MESSAGE.SET_TOKEN('INSTANCE_USAGE_CODE',p_instance_rec.instance_usage_code);
13622: FND_MSG_PUB.Add;
13623: RAISE fnd_api.g_exc_error;
13624: end if;
13625: End if;
13659: END IF;
13660: End Loop;
13661: --
13662: if l_valid_flag <> 'Y' then
13663: FND_MESSAGE.SET_NAME('CSI','CSI_OPERATIONAL_STATUS_CODE');
13664: FND_MESSAGE.SET_TOKEN('OPERATIONAL_STATUS_CODE',p_instance_rec.operational_status_code);
13665: FND_MSG_PUB.Add;
13666: RAISE fnd_api.g_exc_error;
13667: end if;
13660: End Loop;
13661: --
13662: if l_valid_flag <> 'Y' then
13663: FND_MESSAGE.SET_NAME('CSI','CSI_OPERATIONAL_STATUS_CODE');
13664: FND_MESSAGE.SET_TOKEN('OPERATIONAL_STATUS_CODE',p_instance_rec.operational_status_code);
13665: FND_MSG_PUB.Add;
13666: RAISE fnd_api.g_exc_error;
13667: end if;
13668: End if;
13695: into l_int_party_id
13696: from csi_install_parameters;
13697:
13698: IF l_int_party_id IS NULL THEN
13699: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
13700: FND_MSG_PUB.ADD;
13701: RAISE FND_API.G_EXC_ERROR;
13702: END IF;
13703: END IF;
14041: p_instance_rec.sales_unit_price <> FND_API.G_MISS_NUM)))
14042: )
14043: )
14044: THEN
14045: FND_MESSAGE.SET_NAME('CSI','CSI_NO_PRICE_OR_CODE');
14046: FND_MSG_PUB.Add;
14047: RAISE fnd_api.g_exc_error;
14048: END IF;
14049: -- End addition of columns for FA Integration
14076: l_get_instance_rec.instance_usage_code IS NULL OR
14077: l_get_instance_rec.instance_usage_code = fnd_api.g_miss_char) AND
14078: l_temp_rec IS NOT NULL
14079: THEN
14080: FND_MESSAGE.Set_Name('CSI', 'CSI_INVALID_USAGE_CODE');
14081: FND_MSG_PUB.ADD;
14082: RAISE fnd_api.g_exc_error;
14083: END IF;
14084:
14106: AND (active_end_date IS NULL OR active_end_date > SYSDATE);
14107:
14108: IF l_temp_rec1 IS NOT NULL
14109: THEN
14110: FND_MESSAGE.Set_Name('CSI', 'CSI_MODIFY_USAGE_CODE');
14111: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
14112: FND_MSG_PUB.ADD;
14113: RAISE fnd_api.g_exc_error;
14114: END IF;
14107:
14108: IF l_temp_rec1 IS NOT NULL
14109: THEN
14110: FND_MESSAGE.Set_Name('CSI', 'CSI_MODIFY_USAGE_CODE');
14111: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
14112: FND_MSG_PUB.ADD;
14113: RAISE fnd_api.g_exc_error;
14114: END IF;
14115: EXCEPTION
14209: --bring has parent logic here
14210: IF csi_Item_Instance_Vld_Pvt.Instance_has_Parent(
14211: p_instance_id => p_instance_rec.instance_id
14212: ) THEN
14213: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INSTANCE_HAS_PARENT');
14214: FND_MSG_PUB.ADD;
14215: RAISE fnd_api.g_exc_error;
14216: END IF;
14217: -- Validate Location ID
14218: IF l_get_instance_rec.location_type_code IS NULL OR
14219: l_get_instance_rec.location_type_code = FND_API.G_MISS_CHAR OR
14220: l_get_instance_rec.location_id IS NULL OR
14221: l_get_instance_rec.location_id = FND_API.G_MISS_NUM THEN
14222: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
14223: FND_MSG_PUB.ADD;
14224: RAISE fnd_api.g_exc_error;
14225: END IF;
14226: --
14237: END IF;
14238: End Loop;
14239: --
14240: IF l_valid_flag <> 'Y' THEN
14241: FND_MESSAGE.SET_NAME('CSI','CSI_API_LOCATION_NOT_VALID');
14242: FND_MSG_PUB.ADD;
14243: RAISE fnd_api.g_exc_error;
14244: END IF;
14245: END IF; -- p_location_tbl count
14402: THEN
14403: IF ((l_serial_control = 6) and (l_get_instance_rec.serial_number is null)) THEN
14404: p_instance_rec.creation_complete_flag := 'N';
14405: ELSE
14406: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTES');
14407: FND_MSG_PUB.Add;
14408: RAISE fnd_api.g_exc_error;
14409: END IF;
14410: ELSE
14449: WHERE csi.incident_status_id = csb.incident_status_id
14450: AND csi.customer_product_id = p_instance_rec.instance_id
14451: AND NVL(close_flag,'N')<>'Y';
14452:
14453: FND_MESSAGE.SET_NAME('CSI','CSI_IB_HAS_OPEN_SR');
14454: FND_MSG_PUB.ADD;
14455: RAISE FND_API.G_EXC_ERROR;
14456:
14457: EXCEPTION
14455: RAISE FND_API.G_EXC_ERROR;
14456:
14457: EXCEPTION
14458: WHEN TOO_MANY_ROWS THEN
14459: FND_MESSAGE.SET_NAME('CSI','CSI_IB_HAS_OPEN_SR');
14460: FND_MSG_PUB.ADD;
14461: RAISE FND_API.G_EXC_ERROR;
14462:
14463: WHEN NO_DATA_FOUND THEN -- modfied for bug 3693511
14480: p_instance_rec.install_location_type_code = 'HR_LOCATIONS' --4926773
14481: THEN
14482: IF p_instance_rec.install_location_id IS NULL OR
14483: p_instance_rec.install_location_id = FND_API.G_MISS_NUM THEN
14484: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
14485: FND_MSG_PUB.ADD;
14486: RAISE fnd_api.g_exc_error;
14487: END IF;
14488: --
14499: END IF;
14500: End Loop;
14501: --
14502: IF l_valid_flag <> 'Y' THEN
14503: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
14504: FND_MSG_PUB.ADD;
14505: RAISE fnd_api.g_exc_error;
14506: END IF;
14507: END IF;
14523: RAISE fnd_api.g_exc_error;
14524: END IF;
14525: END IF;
14526: ELSE
14527: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INSTALL_LOC');
14528: FND_MSG_PUB.Add;
14529: RAISE FND_API.G_EXC_ERROR;
14530: END IF;
14531: END IF;
14573: IF l_shippable_item_flag = 'Y' AND
14574: NVL(l_shipped_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date AND
14575: TRUNC(l_shipped_date) > TRUNC(p_instance_rec.INSTALL_DATE) THEN --Changed for bug#12818015
14576:
14577: FND_MESSAGE.Set_Name('CSI', 'CSI_INVALID_INSTALL_DATE');
14578: FND_MSG_PUB.ADD;
14579: RAISE FND_API.G_EXC_ERROR;
14580: END IF;
14581:
14874: );
14875:
14876: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
14877: THEN
14878: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14879: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14880: FND_MSG_PUB.Add;
14881: RAISE FND_API.G_EXC_ERROR;
14882: END IF;
14875:
14876: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
14877: THEN
14878: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14879: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14880: FND_MSG_PUB.Add;
14881: RAISE FND_API.G_EXC_ERROR;
14882: END IF;
14883: END IF;
14950: ,x_ctr_grp_id_instance => l_ctr_grp_id_instance
14951: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
14952: );
14953: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
14954: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14955: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14956: FND_MSG_PUB.Add;
14957: RAISE FND_API.G_EXC_ERROR;
14958: END IF;
14951: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
14952: );
14953: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
14954: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14955: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14956: FND_MSG_PUB.Add;
14957: RAISE FND_API.G_EXC_ERROR;
14958: END IF;
14959: END IF; -- COunter template existance check for the new item
15085: ,x_msg_data => x_msg_data
15086: );
15087:
15088: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
15089: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
15090: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
15091: FND_MSG_PUB.Add;
15092: RAISE FND_API.G_EXC_ERROR;
15093: END IF;
15086: );
15087:
15088: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
15089: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
15090: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
15091: FND_MSG_PUB.Add;
15092: RAISE FND_API.G_EXC_ERROR;
15093: END IF;
15094:
15100: --
15101: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
15102: --
15103: IF l_full_dump_frequency IS NULL THEN
15104: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
15105: FND_MSG_PUB.ADD;
15106: RAISE FND_API.G_EXC_ERROR;
15107: END IF;
15108: --
19546: x_msg_count => x_msg_count,
19547: x_msg_data => x_msg_data
19548: );
19549: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
19550: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
19551: FND_MSG_PUB.Add;
19552: RAISE FND_API.G_EXC_ERROR;
19553: END IF;
19554: END IF;
19562:
19563: OPEN curr_instance_rec(l_rel_tbl(j).subject_id);
19564: FETCH curr_instance_rec INTO l_curr_instance_rec;
19565: IF curr_instance_rec%NOTFOUND THEN
19566: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
19567: FND_MSG_PUB.ADD;
19568: RAISE FND_API.G_EXC_ERROR;
19569: END IF;
19570: CLOSE curr_instance_rec;
19584:
19585: IF l_temp IS NOT NULL
19586: THEN
19587: x_return_status := FND_API.G_RET_STS_ERROR ;
19588: FND_MESSAGE.Set_Name('CSI', 'CSI_CHILD_HAS_TXN');
19589: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number);
19590: FND_MSG_PUB.ADD;
19591: RAISE FND_API.G_EXC_ERROR;
19592: END IF;
19585: IF l_temp IS NOT NULL
19586: THEN
19587: x_return_status := FND_API.G_RET_STS_ERROR ;
19588: FND_MESSAGE.Set_Name('CSI', 'CSI_CHILD_HAS_TXN');
19589: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number);
19590: FND_MSG_PUB.ADD;
19591: RAISE FND_API.G_EXC_ERROR;
19592: END IF;
19593: EXCEPTION
19609: IF p_instance_rec.instance_status_id IS NOT NULL AND
19610: p_instance_rec.instance_status_id <> fnd_api.g_miss_num THEN
19611: IF NOT (CSI_Item_Instance_vld_pvt.val_inst_ter_flag(
19612: p_instance_rec.instance_status_id)) THEN
19613: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TERM_STATUS');
19614: FND_MSG_PUB.ADD;
19615: RAISE FND_API.G_EXC_ERROR;
19616: END IF;
19617: l_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
19635: FROM csi_item_instances
19636: WHERE instance_id = p_instance_rec.instance_id;
19637: EXCEPTION
19638: WHEN NO_DATA_FOUND THEN
19639: fnd_message.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
19640: fnd_message.set_token('INSTANCE_ID',p_instance_rec.instance_id);
19641: fnd_msg_pub.ADD;
19642: END;
19643: ELSE
19636: WHERE instance_id = p_instance_rec.instance_id;
19637: EXCEPTION
19638: WHEN NO_DATA_FOUND THEN
19639: fnd_message.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
19640: fnd_message.set_token('INSTANCE_ID',p_instance_rec.instance_id);
19641: fnd_msg_pub.ADD;
19642: END;
19643: ELSE
19644: l_vld_org := p_instance_rec.vld_organization_id;
19824: );
19825:
19826: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
19827:
19828: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
19829: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
19830: FND_MSG_PUB.Add;
19831: RAISE FND_API.G_EXC_ERROR;
19832: END IF;
19825:
19826: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
19827:
19828: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
19829: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
19830: FND_MSG_PUB.Add;
19831: RAISE FND_API.G_EXC_ERROR;
19832: END IF;
19833:
19838: --
19839: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
19840: --
19841: IF l_full_dump_frequency IS NULL THEN
19842: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
19843: FND_MSG_PUB.ADD;
19844: RAISE FND_API.G_EXC_ERROR;
19845: END IF;
19846:
20679: -- in the database else raise error
20680: OPEN get_instance_rec(p_instance_rec.instance_id);
20681: FETCH get_instance_rec INTO l_curr_instance_rec;
20682: IF (l_curr_instance_rec.object_version_number <> nvl(p_instance_rec.OBJECT_VERSION_NUMBER,0)) THEN
20683: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
20684: FND_MSG_PUB.ADD;
20685: RAISE FND_API.G_EXC_ERROR;
20686: END IF;
20687:
20685: RAISE FND_API.G_EXC_ERROR;
20686: END IF;
20687:
20688: IF get_instance_rec%NOTFOUND THEN
20689: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
20690: FND_MSG_PUB.ADD;
20691: RAISE FND_API.G_EXC_ERROR;
20692: END IF;
20693: CLOSE get_instance_rec;
20737:
20738: IF l_parent_found = 'Y' THEN
20739: -- Added for bug#14559620
20740: x_return_status := FND_API.G_RET_STS_ERROR ;
20741: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
20742: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number );
20743: FND_MESSAGE.SET_TOKEN('TXN_DATE',to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
20744: FND_MSG_PUB.ADD;
20745: RAISE FND_API.G_EXC_ERROR;
20738: IF l_parent_found = 'Y' THEN
20739: -- Added for bug#14559620
20740: x_return_status := FND_API.G_RET_STS_ERROR ;
20741: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
20742: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number );
20743: FND_MESSAGE.SET_TOKEN('TXN_DATE',to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
20744: FND_MSG_PUB.ADD;
20745: RAISE FND_API.G_EXC_ERROR;
20746: END IF;
20739: -- Added for bug#14559620
20740: x_return_status := FND_API.G_RET_STS_ERROR ;
20741: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
20742: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_instance_rec.instance_number );
20743: FND_MESSAGE.SET_TOKEN('TXN_DATE',to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
20744: FND_MSG_PUB.ADD;
20745: RAISE FND_API.G_EXC_ERROR;
20746: END IF;
20747: END IF;
20781: x_msg_data => x_msg_data
20782: );
20783: --
20784: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
20785: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
20786: FND_MSG_PUB.Add;
20787: RAISE FND_API.G_EXC_ERROR;
20788: END IF;
20789: END IF;
20797: END IF;
20798:
20799: IF l_has_unexpired_children = TRUE THEN
20800: IF p_expire_children = 'F' THEN
20801: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_EXPIRE_INSTANCE');
20802: FND_MSG_PUB.Add;
20803: RAISE FND_API.G_EXC_ERROR;
20804:
20805: ELSE
20827: IF p_instance_rec.instance_status_id IS NOT NULL AND
20828: p_instance_rec.instance_status_id <> fnd_api.g_miss_num THEN
20829: IF NOT (CSI_Item_Instance_vld_pvt.val_inst_ter_flag(
20830: p_instance_rec.instance_status_id)) THEN
20831: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TERM_STATUS');
20832: FND_MSG_PUB.ADD;
20833: RAISE FND_API.G_EXC_ERROR;
20834: END IF;
20835: l_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
20859: WHERE csi.incident_status_id = csb.incident_status_id
20860: AND csi.customer_product_id = p_instance_rec.instance_id
20861: AND NVL(close_flag,'N')<>'Y';
20862:
20863: FND_MESSAGE.SET_NAME('CSI','CSI_IB_HAS_OPEN_SR');
20864: FND_MSG_PUB.ADD;
20865: RAISE FND_API.G_EXC_ERROR;
20866:
20867: EXCEPTION
20865: RAISE FND_API.G_EXC_ERROR;
20866:
20867: EXCEPTION
20868: WHEN TOO_MANY_ROWS THEN
20869: FND_MESSAGE.SET_NAME('CSI','CSI_IB_HAS_OPEN_SR');
20870: FND_MSG_PUB.ADD;
20871: RAISE FND_API.G_EXC_ERROR;
20872:
20873: WHEN NO_DATA_FOUND THEN -- modfied for bug 3693511
20921: FROM csi_item_instances
20922: WHERE instance_id = p_instance_rec.instance_id;
20923: EXCEPTION
20924: WHEN NO_DATA_FOUND THEN
20925: fnd_message.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
20926: fnd_message.set_token('INSTANCE_ID',p_instance_rec.instance_id);
20927: fnd_msg_pub.ADD;
20928: END;
20929: ELSE
20922: WHERE instance_id = p_instance_rec.instance_id;
20923: EXCEPTION
20924: WHEN NO_DATA_FOUND THEN
20925: fnd_message.set_name('CSI','CSI_API_INVALID_INSTANCE_ID');
20926: fnd_message.set_token('INSTANCE_ID',p_instance_rec.instance_id);
20927: fnd_msg_pub.ADD;
20928: END;
20929: ELSE
20930: l_vld_org := p_instance_rec.vld_organization_id;
21115: );
21116:
21117: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
21118:
21119: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
21120: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
21121: FND_MSG_PUB.Add;
21122: RAISE FND_API.G_EXC_ERROR;
21123: END IF;
21116:
21117: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
21118:
21119: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
21120: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
21121: FND_MSG_PUB.Add;
21122: RAISE FND_API.G_EXC_ERROR;
21123: END IF;
21124: -- END IF;
21135: --
21136: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
21137: --
21138: IF l_full_dump_frequency IS NULL THEN
21139: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
21140: FND_MSG_PUB.ADD;
21141: RAISE FND_API.G_EXC_ERROR;
21142: END IF;
21143:
22084: IF p_source_instance_rec.location_type_code = 'INVENTORY'
22085: OR p_source_instance_rec.location_type_code = 'WIP'
22086: OR p_source_instance_rec.location_type_code = 'PROJECT'
22087: THEN
22088: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
22089: FND_MSG_PUB.ADD;
22090: RAISE FND_API.G_EXC_ERROR;
22091: END IF;
22092:
22095: INTO l_dummy
22096: FROM csi_i_assets
22097: WHERE instance_id =p_source_instance_rec.instance_id;
22098:
22099: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
22100: FND_MSG_PUB.ADD;
22101: RAISE FND_API.G_EXC_ERROR;
22102: EXCEPTION
22103: WHEN OTHERS THEN
22115: ,p_transaction_type_id => p_txn_rec.transaction_type_id
22116: ) -- Added by sk on 09/13/01
22117: THEN
22118: l_return_value := FALSE;
22119: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_BE_SERIALIZED');
22120: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER', 'serial_number');
22121: FND_MSG_PUB.ADD;
22122: RAISE FND_API.G_EXC_ERROR;
22123: END IF;
22116: ) -- Added by sk on 09/13/01
22117: THEN
22118: l_return_value := FALSE;
22119: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_BE_SERIALIZED');
22120: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER', 'serial_number');
22121: FND_MSG_PUB.ADD;
22122: RAISE FND_API.G_EXC_ERROR;
22123: END IF;
22124: END IF;
22132: FROM csi_item_instances
22133: WHERE instance_id = p_source_instance_rec.instance_id;
22134: EXCEPTION
22135: WHEN NO_DATA_FOUND THEN
22136: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANITY');
22137: FND_MSG_PUB.Add;
22138: RAISE FND_API.G_EXC_ERROR;
22139: END;
22140:
22139: END;
22140:
22141: --verifying the quantity
22142: IF (p_quantity1 + p_quantity2) <> l_quantity THEN
22143: FND_MESSAGE.SET_NAME('CSI','CSI_API_INCORRECT_QUANTITY');
22144: FND_MSG_PUB.Add;
22145: RAISE FND_API.G_EXC_ERROR;
22146: END IF;
22147:
22300: FROM csi_item_instances
22301: WHERE instance_id = p_source_instance_rec.instance_id;
22302: EXCEPTION
22303: WHEN NO_DATA_FOUND THEN
22304: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OBJ_NUM');
22305: FND_MSG_PUB.ADD;
22306: RAISE FND_API.G_EXC_ERROR;
22307: END;
22308: l_new_instance_rec.instance_id := p_source_instance_rec.instance_id;
22587: IF p_source_instance_rec.location_type_code = 'INVENTORY'
22588: OR p_source_instance_rec.location_type_code = 'WIP'
22589: OR p_source_instance_rec.location_type_code = 'PROJECT'
22590: THEN
22591: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
22592: FND_MSG_PUB.ADD;
22593: RAISE FND_API.G_EXC_ERROR;
22594: END IF;
22595:
22598: INTO l_dummy
22599: FROM csi_i_assets
22600: WHERE instance_id =p_source_instance_rec.instance_id;
22601:
22602: FND_MESSAGE.SET_NAME('CSI','CSI_CANNOT_SPLIT');
22603: FND_MSG_PUB.ADD;
22604: RAISE FND_API.G_EXC_ERROR;
22605: EXCEPTION
22606: WHEN OTHERS THEN
22617: ,p_transaction_type_id => p_txn_rec.transaction_type_id
22618: ) -- Added by sk on 09/13/01
22619: THEN
22620: l_return_value := FALSE;
22621: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_BE_SERIALIZED');
22622: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER', 'serial_number');
22623: FND_MSG_PUB.ADD;
22624: RAISE FND_API.G_EXC_ERROR;
22625: END IF;
22618: ) -- Added by sk on 09/13/01
22619: THEN
22620: l_return_value := FALSE;
22621: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANNOT_BE_SERIALIZED');
22622: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER', 'serial_number');
22623: FND_MSG_PUB.ADD;
22624: RAISE FND_API.G_EXC_ERROR;
22625: END IF;
22626: END IF;
22633: FROM csi_item_instances
22634: WHERE instance_id = p_source_instance_rec.instance_id;
22635: EXCEPTION
22636: WHEN NO_DATA_FOUND THEN
22637: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANITY');
22638: FND_MSG_PUB.Add;
22639: RAISE FND_API.G_EXC_ERROR;
22640: END;
22641: -- Added by sk for bug 2186683
22863: -- End of code addition for fixing bug 2139782.
22864: END LOOP;
22865: Else --l_quantity is <= 1
22866:
22867: FND_MESSAGE.SET_NAME('CSI','CSI_API_QUANTITY_NOT_VALID');
22868: FND_MESSAGE.SET_TOKEN('QUANTITY', l_quantity);
22869: FND_MSG_PUB.ADD;
22870: -- RAISE fnd_api.g_exc_error;
22871: End If;
22864: END LOOP;
22865: Else --l_quantity is <= 1
22866:
22867: FND_MESSAGE.SET_NAME('CSI','CSI_API_QUANTITY_NOT_VALID');
22868: FND_MESSAGE.SET_TOKEN('QUANTITY', l_quantity);
22869: FND_MSG_PUB.ADD;
22870: -- RAISE fnd_api.g_exc_error;
22871: End If;
22872:
22877: FROM csi_item_instances
22878: WHERE instance_id = p_source_instance_rec.instance_id;
22879: EXCEPTION
22880: WHEN NO_DATA_FOUND THEN
22881: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OBJ_NUM');
22882: FND_MSG_PUB.ADD;
22883: RAISE FND_API.G_EXC_ERROR;
22884: END;
22885: --
23226: l_nearest_full_dump := l_time_stamp;
23227: -- If the user chooses a date before the creation date of the instance
23228: -- then raise an error
23229: IF p_time_stamp < l_time_stamp THEN
23230: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
23231: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
23232: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
23233: FND_MSG_PUB.Add;
23234: RAISE FND_API.G_EXC_ERROR;
23227: -- If the user chooses a date before the creation date of the instance
23228: -- then raise an error
23229: IF p_time_stamp < l_time_stamp THEN
23230: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
23231: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
23232: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
23233: FND_MSG_PUB.Add;
23234: RAISE FND_API.G_EXC_ERROR;
23235: END IF;
23228: -- then raise an error
23229: IF p_time_stamp < l_time_stamp THEN
23230: FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
23231: FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
23232: FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
23233: FND_MSG_PUB.Add;
23234: RAISE FND_API.G_EXC_ERROR;
23235: END IF;
23236:
24032: -- in the database else raise error
24033: OPEN get_curr_ver_label_rec(p_version_label_rec.VERSION_LABEL_ID);
24034: FETCH get_curr_ver_label_rec INTO l_curr_ver_label_rec;
24035: IF (l_curr_ver_label_rec.object_version_number <> nvl(p_version_label_rec.OBJECT_VERSION_NUMBER,-1)) THEN
24036: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
24037: FND_MSG_PUB.ADD;
24038: RAISE FND_API.G_EXC_ERROR;
24039: END IF;
24040: IF get_curr_ver_label_rec%NOTFOUND THEN
24037: FND_MSG_PUB.ADD;
24038: RAISE FND_API.G_EXC_ERROR;
24039: END IF;
24040: IF get_curr_ver_label_rec%NOTFOUND THEN
24041: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
24042: FND_MSG_PUB.ADD;
24043: RAISE FND_API.G_EXC_ERROR;
24044: END IF;
24045: CLOSE get_curr_ver_label_rec;
24117: --
24118: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
24119: --
24120: IF l_full_dump_frequency IS NULL THEN
24121: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
24122: FND_MSG_PUB.ADD;
24123: RAISE FND_API.G_EXC_ERROR;
24124: END IF;
24125: --
25150: -- in the database else raise error
25151: OPEN get_curr_ver_label_rec(p_version_label_rec.version_label_id);
25152: FETCH get_curr_ver_label_rec INTO l_curr_ver_label_rec;
25153: IF (l_curr_ver_label_rec.object_version_number <> nvl(p_version_label_rec.OBJECT_VERSION_NUMBER,-1)) THEN
25154: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
25155: FND_MSG_PUB.ADD;
25156: RAISE FND_API.G_EXC_ERROR;
25157: END IF;
25158:
25156: RAISE FND_API.G_EXC_ERROR;
25157: END IF;
25158:
25159: IF get_curr_ver_label_rec%NOTFOUND THEN
25160: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
25161: FND_MSG_PUB.ADD;
25162: RAISE FND_API.G_EXC_ERROR;
25163: END IF;
25164: CLOSE get_curr_ver_label_rec;
25232: --
25233: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
25234: --
25235: IF l_full_dump_frequency IS NULL THEN
25236: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
25237: FND_MSG_PUB.ADD;
25238: RAISE FND_API.G_EXC_ERROR;
25239: END IF;
25240:
25640: -- If the user chooses a date before the creation date of the instance
25641: -- then raise an error
25642: IF p_time_stamp < l_time_stamp THEN
25643: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
25644: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
25645: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25646: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25647: -- FND_MSG_PUB.Add;
25648: -- RAISE FND_API.G_EXC_ERROR;
25641: -- then raise an error
25642: IF p_time_stamp < l_time_stamp THEN
25643: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
25644: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
25645: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25646: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25647: -- FND_MSG_PUB.Add;
25648: -- RAISE FND_API.G_EXC_ERROR;
25649: l_ext_tbl.DELETE(i);
25642: IF p_time_stamp < l_time_stamp THEN
25643: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
25644: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
25645: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25646: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
25647: -- FND_MSG_PUB.Add;
25648: -- RAISE FND_API.G_EXC_ERROR;
25649: l_ext_tbl.DELETE(i);
25650: RAISE Process_next;
26097: END LOOP;
26098: --
26099: IF l_valid_flag <> 'Y'
26100: THEN
26101: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
26102: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_ext_attrib_rec.instance_id);
26103: FND_MSG_PUB.Add;
26104: RAISE fnd_api.g_exc_error;
26105: END IF;
26098: --
26099: IF l_valid_flag <> 'Y'
26100: THEN
26101: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
26102: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_ext_attrib_rec.instance_id);
26103: FND_MSG_PUB.Add;
26104: RAISE fnd_api.g_exc_error;
26105: END IF;
26106: END IF;
26149: END LOOP;
26150: --
26151: IF l_valid_flag <> 'Y'
26152: THEN
26153: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
26154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_ext_attrib_rec.attribute_id);
26155: FND_MSG_PUB.Add;
26156: RAISE fnd_api.g_exc_error;
26157: END IF;
26150: --
26151: IF l_valid_flag <> 'Y'
26152: THEN
26153: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
26154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_ext_attrib_rec.attribute_id);
26155: FND_MSG_PUB.Add;
26156: RAISE fnd_api.g_exc_error;
26157: END IF;
26158: END IF;
26180: p_ext_attr_tbl(p_ext_count_rec.ext_attr_count).instance_id := l_instance_id;
26181: END IF;
26182: END IF;
26183: ELSE
26184: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
26185: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_ext_attrib_rec.attribute_id);
26186: FND_MSG_PUB.Add;
26187: END IF;
26188: --
26181: END IF;
26182: END IF;
26183: ELSE
26184: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
26185: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_ext_attrib_rec.attribute_id);
26186: FND_MSG_PUB.Add;
26187: END IF;
26188: --
26189:
26299: END LOOP;
26300: --
26301: IF l_valid_flag <> 'Y'
26302: THEN
26303: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
26304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',l_ori_inventory_item_id);
26305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',l_ori_master_org_id);
26306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',l_item_category_id);
26307: FND_MSG_PUB.Add;
26300: --
26301: IF l_valid_flag <> 'Y'
26302: THEN
26303: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
26304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',l_ori_inventory_item_id);
26305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',l_ori_master_org_id);
26306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',l_item_category_id);
26307: FND_MSG_PUB.Add;
26308: RAISE fnd_api.g_exc_error;
26301: IF l_valid_flag <> 'Y'
26302: THEN
26303: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
26304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',l_ori_inventory_item_id);
26305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',l_ori_master_org_id);
26306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',l_item_category_id);
26307: FND_MSG_PUB.Add;
26308: RAISE fnd_api.g_exc_error;
26309: END IF;
26302: THEN
26303: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
26304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',l_ori_inventory_item_id);
26305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',l_ori_master_org_id);
26306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',l_item_category_id);
26307: FND_MSG_PUB.Add;
26308: RAISE fnd_api.g_exc_error;
26309: END IF;
26310: END IF;
26696:
26697: -- Verify start effective date
26698: IF ( p_ext_attrib_rec.active_start_date <> FND_API.G_MISS_DATE) THEN
26699: IF (p_ext_attrib_rec.active_start_date <> l_ext_attrib_rec.active_start_date) THEN
26700: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
26701: FND_MESSAGE.Set_Token('COLUMN', 'EXTENDED ATTRIBUTE START_DATE');
26702: FND_MSG_PUB.ADD;
26703: RAISE FND_API.G_EXC_ERROR;
26704: END IF;
26697: -- Verify start effective date
26698: IF ( p_ext_attrib_rec.active_start_date <> FND_API.G_MISS_DATE) THEN
26699: IF (p_ext_attrib_rec.active_start_date <> l_ext_attrib_rec.active_start_date) THEN
26700: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
26701: FND_MESSAGE.Set_Token('COLUMN', 'EXTENDED ATTRIBUTE START_DATE');
26702: FND_MSG_PUB.ADD;
26703: RAISE FND_API.G_EXC_ERROR;
26704: END IF;
26705: END IF;
26722:
26723: -- Verify attribute id
26724: IF ( p_ext_attrib_rec.attribute_id <> FND_API.G_MISS_NUM) THEN
26725: IF (l_ext_attrib_rec.attribute_id <> l_ext_attrib_rec.attribute_id) THEN
26726: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
26727: FND_MESSAGE.Set_Token('COLUMN', 'EXTENDED ATTRIBUTE_ID');
26728: FND_MSG_PUB.ADD;
26729: RAISE FND_API.G_EXC_ERROR;
26730: END IF;
26723: -- Verify attribute id
26724: IF ( p_ext_attrib_rec.attribute_id <> FND_API.G_MISS_NUM) THEN
26725: IF (l_ext_attrib_rec.attribute_id <> l_ext_attrib_rec.attribute_id) THEN
26726: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
26727: FND_MESSAGE.Set_Token('COLUMN', 'EXTENDED ATTRIBUTE_ID');
26728: FND_MSG_PUB.ADD;
26729: RAISE FND_API.G_EXC_ERROR;
26730: END IF;
26731: END IF;
27983: -- into l_curr_instance_rec.
27984: /*
27985: IF ((p_source_instance_rec.VLD_ORGANIZATION_ID = FND_API.G_MISS_NUM)
27986: OR (p_source_instance_rec.VLD_ORGANIZATION_ID IS NULL)) THEN
27987: FND_MESSAGE.SET_NAME('CSI','CSI_API_VLD_ORG_ID_NULL');
27988: FND_MSG_PUB.Add;
27989: RAISE FND_API.G_EXC_ERROR;
27990: ELSE
27991: l_new_instance_rec.VLD_ORGANIZATION_ID := p_source_instance_rec.VLD_ORGANIZATION_ID;
28009: -- End addition by sk for bug 2186683
28010:
28011: IF (p_source_instance_rec.instance_id IS NULL) OR
28012: (p_source_instance_rec.instance_id = FND_API.G_MISS_NUM) THEN
28013: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_ID_NULL');
28014: FND_MSG_PUB.Add;
28015: RAISE FND_API.G_EXC_ERROR;
28016: ELSIF NOT (csi_Item_Instance_Vld_pvt.Val_and_get_inst_rec(
28017: p_source_instance_rec.instance_id ,
28021:
28022: -- Check if the user has not passed incorrect options for contacts
28023: IF ((p_copy_parties = fnd_api.g_false)
28024: AND (p_copy_contacts = fnd_api.g_true)) THEN
28025: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_PTY_CONTACT_OPT');
28026: FND_MSG_PUB.Add;
28027: RAISE FND_API.G_EXC_ERROR;
28028: END IF;
28029: -- If the user has passed p_copy_parties as false get only the owner, else get all the parties
29193: IF ((l_contact_tbl(tab_row_contact).contact_ip_id IS NULL) OR
29194: (l_contact_tbl(tab_row_contact).contact_ip_id
29195: = FND_API.G_MISS_NUM)
29196: OR NOT(l_contact_found_flag) ) THEN
29197: FND_MESSAGE.SET_NAME('CSI','CSI_API_CONTACT_IP_ID_NULL');
29198: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',
29199: l_contact_tbl(tab_row_contact).instance_party_id);
29200: FND_MSG_PUB.Add;
29201: RAISE FND_API.G_EXC_ERROR;
29194: (l_contact_tbl(tab_row_contact).contact_ip_id
29195: = FND_API.G_MISS_NUM)
29196: OR NOT(l_contact_found_flag) ) THEN
29197: FND_MESSAGE.SET_NAME('CSI','CSI_API_CONTACT_IP_ID_NULL');
29198: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',
29199: l_contact_tbl(tab_row_contact).instance_party_id);
29200: FND_MSG_PUB.Add;
29201: RAISE FND_API.G_EXC_ERROR;
29202: END IF;
29558: IF (p_source_instance_rec.VERSION_LABEL IS NULL ) OR
29559: (p_source_instance_rec.VERSION_LABEL = FND_API.G_MISS_CHAR) THEN
29560: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
29561: IF l_version_label IS NULL THEN
29562: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
29563: FND_MSG_PUB.ADD;
29564: RAISE FND_API.G_EXC_ERROR;
29565: ELSE
29566: l_new_instance_rec.version_label := l_version_label;
29592:
29593: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
29594: csi_gen_utility_pvt.put_line( ' Error from COPY_SINGLE_ITEM_INSTANCE.CREATE_VERSION_LABEL..');
29595: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
29596: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
29597: FND_MESSAGE.SET_TOKEN('API_ERROR','CREATE_VERSION_LABEL');
29598: FND_MSG_PUB.Add;
29599: RAISE FND_API.G_EXC_ERROR;
29600: END IF;
29593: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
29594: csi_gen_utility_pvt.put_line( ' Error from COPY_SINGLE_ITEM_INSTANCE.CREATE_VERSION_LABEL..');
29595: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
29596: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
29597: FND_MESSAGE.SET_TOKEN('API_ERROR','CREATE_VERSION_LABEL');
29598: FND_MSG_PUB.Add;
29599: RAISE FND_API.G_EXC_ERROR;
29600: END IF;
29601: -- End of Addition by rtalluri for Bug: 2420897 on 08/19/02
29613: --
29614: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
29615: --
29616: IF l_internal_party_id IS NULL THEN
29617: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
29618: FND_MSG_PUB.ADD;
29619: RAISE FND_API.G_EXC_ERROR;
29620: END IF;
29621: --
29911: -- Verify instance quantity
29912: IF ((p_source_instance_rec.QUANTITY IS NULL)
29913: OR (p_source_instance_rec.QUANTITY = FND_API.G_MISS_NUM )
29914: OR (p_source_instance_rec.QUANTITY <> 1)) THEN
29915: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');
29916: FND_MESSAGE.SET_TOKEN('QUANTITY',p_source_instance_rec.QUANTITY);
29917: FND_MSG_PUB.Add;
29918: RAISE FND_API.G_EXC_ERROR;
29919: END IF;
29912: IF ((p_source_instance_rec.QUANTITY IS NULL)
29913: OR (p_source_instance_rec.QUANTITY = FND_API.G_MISS_NUM )
29914: OR (p_source_instance_rec.QUANTITY <> 1)) THEN
29915: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');
29916: FND_MESSAGE.SET_TOKEN('QUANTITY',p_source_instance_rec.QUANTITY);
29917: FND_MSG_PUB.Add;
29918: RAISE FND_API.G_EXC_ERROR;
29919: END IF;
29920: -- Verify the Passed Inventory Item is Trackable
29941: --
29942: IF p_create_instance = FND_API.G_TRUE THEN
29943: IF (p_source_instance_rec.instance_id IS NULL) OR
29944: (p_source_instance_rec.instance_id = FND_API.G_MISS_NUM) THEN
29945: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_ID_NULL');
29946: FND_MSG_PUB.Add;
29947: RAISE FND_API.G_EXC_ERROR;
29948: END IF;
29949: --
29987: csi_gen_utility_pvt.put_line (' Bom explosion error code > 0 '|| l_Error_Code ||' '||l_err_msg);
29988: ELSIF l_Error_Code > 0 THEN
29989: csi_gen_utility_pvt.put_line (' Bom explosion error code < 0'|| l_Error_Code ||' '||l_err_msg);
29990: END IF;
29991: FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');
29992: FND_MSG_PUB.Add;
29993: RAISE FND_API.G_EXC_ERROR;
29994: END IF; -- error
29995: --
32870:
32871:
32872: IF (p_source_instance_rec.instance_id IS NULL) OR
32873: (p_source_instance_rec.instance_id = FND_API.G_MISS_NUM) THEN
32874: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_ID_NULL');
32875: FND_MSG_PUB.Add;
32876: RAISE FND_API.G_EXC_ERROR;
32877: ELSIF NOT (csi_Item_Instance_Vld_pvt.Val_and_get_inst_rec(
32878: p_source_instance_rec.instance_id ,
32883:
32884: -- Check if the user has not passed incorrect options for contacts
32885: IF ((p_copy_parties = fnd_api.g_false)
32886: AND (p_copy_contacts = fnd_api.g_true)) THEN
32887: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_PTY_CONTACT_OPT');
32888: FND_MSG_PUB.Add;
32889: RAISE FND_API.G_EXC_ERROR;
32890: END IF;
32891:
34008: IF ((l_contact_tbl(tab_row_contact).contact_ip_id IS NULL) OR
34009: (l_contact_tbl(tab_row_contact).contact_ip_id
34010: = FND_API.G_MISS_NUM)
34011: OR NOT(l_contact_found_flag) ) THEN
34012: FND_MESSAGE.SET_NAME('CSI','CSI_API_CONTACT_IP_ID_NULL');
34013: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',
34014: l_contact_tbl(tab_row_contact).instance_party_id);
34015: FND_MSG_PUB.Add;
34016: RAISE FND_API.G_EXC_ERROR;
34009: (l_contact_tbl(tab_row_contact).contact_ip_id
34010: = FND_API.G_MISS_NUM)
34011: OR NOT(l_contact_found_flag) ) THEN
34012: FND_MESSAGE.SET_NAME('CSI','CSI_API_CONTACT_IP_ID_NULL');
34013: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',
34014: l_contact_tbl(tab_row_contact).instance_party_id);
34015: FND_MSG_PUB.Add;
34016: RAISE FND_API.G_EXC_ERROR;
34017: END IF;
34365: IF (p_source_instance_rec.VERSION_LABEL IS NULL ) OR
34366: (p_source_instance_rec.VERSION_LABEL = FND_API.G_MISS_CHAR) THEN
34367: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
34368: IF l_version_label IS NULL THEN
34369: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
34370: FND_MSG_PUB.ADD;
34371: RAISE FND_API.G_EXC_ERROR;
34372: ELSE
34373: l_new_instance_rec.version_label := l_version_label;
34399:
34400: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
34401: csi_gen_utility_pvt.put_line( ' Error from COPY_ITEM_INSTANCE.CREATE_VERSION_LABEL..');
34402: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
34403: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
34404: FND_MESSAGE.SET_TOKEN('API_ERROR','CREATE_VERSION_LABEL');
34405: FND_MSG_PUB.Add;
34406: RAISE FND_API.G_EXC_ERROR;
34407: END IF;
34400: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
34401: csi_gen_utility_pvt.put_line( ' Error from COPY_ITEM_INSTANCE.CREATE_VERSION_LABEL..');
34402: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
34403: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
34404: FND_MESSAGE.SET_TOKEN('API_ERROR','CREATE_VERSION_LABEL');
34405: FND_MSG_PUB.Add;
34406: RAISE FND_API.G_EXC_ERROR;
34407: END IF;
34408: -- End of Addition by rtalluri for Bug: 2420897 on 08/19/02
34420: --
34421: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
34422: --
34423: IF l_internal_party_id IS NULL THEN
34424: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
34425: FND_MSG_PUB.ADD;
34426: RAISE FND_API.G_EXC_ERROR;
34427: END IF;
34428:
34559: x_msg_data => x_msg_data
34560: );
34561: --
34562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
34563: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
34564: FND_MSG_PUB.Add;
34565: RAISE FND_API.G_EXC_ERROR;
34566: END IF;
34567: END IF;
35160:
35161: -- Start API body
35162: IF (p_instance_id IS NULL)
35163: THEN
35164: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_INSTANCE_ID');
35165: FND_MESSAGE.Set_Token('INSTANCE_ID', p_instance_id);
35166: FND_MSG_PUB.ADD;
35167: RAISE FND_API.G_EXC_ERROR;
35168: END IF;
35161: -- Start API body
35162: IF (p_instance_id IS NULL)
35163: THEN
35164: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_INSTANCE_ID');
35165: FND_MESSAGE.Set_Token('INSTANCE_ID', p_instance_id);
35166: FND_MSG_PUB.ADD;
35167: RAISE FND_API.G_EXC_ERROR;
35168: END IF;
35169:
35572: END LOOP;
35573:
35574: IF l_dup_count > 1
35575: THEN
35576: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_INS_KEY');
35577: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
35578: FND_MSG_PUB.Add;
35579: RAISE FND_API.G_EXC_ERROR;
35580: END IF;
35573:
35574: IF l_dup_count > 1
35575: THEN
35576: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_INS_KEY');
35577: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
35578: FND_MSG_PUB.Add;
35579: RAISE FND_API.G_EXC_ERROR;
35580: END IF;
35581: END IF;
35606: END LOOP;
35607:
35608: IF l_dup_count > 1
35609: THEN
35610: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_KEYS_LOCKED');
35611: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35612: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35613: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35614: FND_MSG_PUB.Add;
35607:
35608: IF l_dup_count > 1
35609: THEN
35610: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_KEYS_LOCKED');
35611: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35612: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35613: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35614: FND_MSG_PUB.Add;
35615: RAISE FND_API.G_EXC_ERROR;
35608: IF l_dup_count > 1
35609: THEN
35610: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_KEYS_LOCKED');
35611: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35612: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35613: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35614: FND_MSG_PUB.Add;
35615: RAISE FND_API.G_EXC_ERROR;
35616: END IF;
35609: THEN
35610: FND_MESSAGE.SET_NAME('CSI','CSI_DUPLICATE_KEYS_LOCKED');
35611: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35612: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35613: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35614: FND_MSG_PUB.Add;
35615: RAISE FND_API.G_EXC_ERROR;
35616: END IF;
35617: END IF;
35621: px_config_tbl(i).instance_id <> fnd_api.g_miss_num)
35622: THEN
35623: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => px_config_tbl(i).instance_id)
35624: THEN
35625: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35626: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
35627: FND_MSG_PUB.Add;
35628: RAISE FND_API.G_EXC_ERROR;
35629: ELSE
35622: THEN
35623: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => px_config_tbl(i).instance_id)
35624: THEN
35625: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35626: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
35627: FND_MSG_PUB.Add;
35628: RAISE FND_API.G_EXC_ERROR;
35629: ELSE
35630: l_found:='N';
35669: );
35670:
35671:
35672: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
35673: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
35674: FND_MSG_PUB.Add;
35675: RAISE FND_API.G_EXC_ERROR;
35676: END IF;
35677: l_lock_count:=l_lock_tbl.COUNT+1;
35701: l_lock_count:=l_lock_tbl.COUNT+1;
35702: l_lock_tbl(l_lock_count).instance_id:=l_rel_tbl(l_chld_csr).subject_id;
35703: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => l_rel_tbl(l_chld_csr).subject_id)
35704: THEN
35705: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35706: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_lock_tbl(l_lock_count).instance_id);
35707: FND_MSG_PUB.Add;
35708: RAISE FND_API.G_EXC_ERROR;
35709: END IF;
35702: l_lock_tbl(l_lock_count).instance_id:=l_rel_tbl(l_chld_csr).subject_id;
35703: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => l_rel_tbl(l_chld_csr).subject_id)
35704: THEN
35705: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35706: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_lock_tbl(l_lock_count).instance_id);
35707: FND_MSG_PUB.Add;
35708: RAISE FND_API.G_EXC_ERROR;
35709: END IF;
35710: l_lock_tbl(l_lock_count).root_instance_id:=l_root_node;
35726: ,p_config_inst_item_id => px_config_tbl(i).config_inst_item_id
35727: ,p_config_inst_rev_num => px_config_tbl(i).config_inst_rev_num
35728: )
35729: THEN
35730: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEYS_LOCKED');
35731: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35732: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35733: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35734: FND_MSG_PUB.Add;
35727: ,p_config_inst_rev_num => px_config_tbl(i).config_inst_rev_num
35728: )
35729: THEN
35730: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEYS_LOCKED');
35731: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35732: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35733: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35734: FND_MSG_PUB.Add;
35735: RAISE FND_API.G_EXC_ERROR;
35728: )
35729: THEN
35730: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEYS_LOCKED');
35731: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35732: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35733: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35734: FND_MSG_PUB.Add;
35735: RAISE FND_API.G_EXC_ERROR;
35736: ELSE
35729: THEN
35730: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEYS_LOCKED');
35731: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',px_config_tbl(i).config_inst_hdr_id);
35732: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',px_config_tbl(i).config_inst_item_id);
35733: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',px_config_tbl(i).config_inst_rev_num);
35734: FND_MSG_PUB.Add;
35735: RAISE FND_API.G_EXC_ERROR;
35736: ELSE
35737: l_lock_count:=l_lock_tbl.COUNT+1;
35765: px_config_tbl(i).lock_status:=2;
35766: END IF;
35767: END IF;
35768: ELSE
35769: FND_MESSAGE.SET_NAME('CSI','CSI_PASSED_INVALID_KEYS');
35770: FND_MSG_PUB.Add;
35771: RAISE FND_API.G_EXC_ERROR;
35772: END IF;
35773:
35966: ,x_msg_data => x_msg_data
35967: );
35968:
35969: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
35970: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
35971: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
35972: FND_MSG_PUB.Add;
35973: RAISE FND_API.G_EXC_ERROR;
35974: END IF;
35967: );
35968:
35969: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
35970: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
35971: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
35972: FND_MSG_PUB.Add;
35973: RAISE FND_API.G_EXC_ERROR;
35974: END IF;
35975: */
36405: --l_unlock_config(l_config_count+l_bld).source_txn_line_ref3 :=p_config_tbl(i).source_txn_line_ref3;
36406: IF l_bld_unlock_tbl(l_bld).lock_status = 2 AND
36407: p_config_tbl(i).source_application_id = 542
36408: THEN
36409: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_UNLOCK_TREE');
36410: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36411: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36412: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36413: FND_MSG_PUB.Add;
36406: IF l_bld_unlock_tbl(l_bld).lock_status = 2 AND
36407: p_config_tbl(i).source_application_id = 542
36408: THEN
36409: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_UNLOCK_TREE');
36410: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36411: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36412: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36413: FND_MSG_PUB.Add;
36414: RAISE FND_API.G_EXC_ERROR;
36407: p_config_tbl(i).source_application_id = 542
36408: THEN
36409: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_UNLOCK_TREE');
36410: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36411: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36412: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36413: FND_MSG_PUB.Add;
36414: RAISE FND_API.G_EXC_ERROR;
36415: ELSIF (p_config_tbl(i).lock_status IS NULL OR
36408: THEN
36409: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_UNLOCK_TREE');
36410: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36411: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36412: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36413: FND_MSG_PUB.Add;
36414: RAISE FND_API.G_EXC_ERROR;
36415: ELSIF (p_config_tbl(i).lock_status IS NULL OR
36416: p_config_tbl(i).lock_status NOT IN (0,1)) OR
36415: ELSIF (p_config_tbl(i).lock_status IS NULL OR
36416: p_config_tbl(i).lock_status NOT IN (0,1)) OR
36417: p_config_tbl(i).lock_status > l_bld_unlock_tbl(l_bld).lock_status
36418: THEN
36419: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36420: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
36421: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36422: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36423: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36416: p_config_tbl(i).lock_status NOT IN (0,1)) OR
36417: p_config_tbl(i).lock_status > l_bld_unlock_tbl(l_bld).lock_status
36418: THEN
36419: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36420: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
36421: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36422: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36423: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36424: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36417: p_config_tbl(i).lock_status > l_bld_unlock_tbl(l_bld).lock_status
36418: THEN
36419: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36420: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
36421: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36422: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36423: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36424: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36425: FND_MSG_PUB.Add;
36418: THEN
36419: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36420: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
36421: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36422: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36423: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36424: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36425: FND_MSG_PUB.Add;
36426: RAISE FND_API.G_EXC_ERROR;
36419: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36420: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
36421: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36422: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36423: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36424: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36425: FND_MSG_PUB.Add;
36426: RAISE FND_API.G_EXC_ERROR;
36427: END IF;
36420: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_bld_unlock_tbl(l_bld).lock_status);
36421: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36422: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_bld_unlock_tbl(l_bld).config_inst_hdr_id);
36423: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_bld_unlock_tbl(l_bld).config_inst_item_id);
36424: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_bld_unlock_tbl(l_bld).config_inst_rev_num);
36425: FND_MSG_PUB.Add;
36426: RAISE FND_API.G_EXC_ERROR;
36427: END IF;
36428: END IF;
36516: IF (p_config_tbl(i).lock_status IS NULL OR
36517: p_config_tbl(i).lock_status NOT IN (0,1)) OR
36518: p_config_tbl(i).lock_status > l_valid_lock_status
36519: THEN
36520: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INS_STATUS');
36521: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36522: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36523: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_config_tbl(i).instance_id);
36524: FND_MSG_PUB.Add;
36517: p_config_tbl(i).lock_status NOT IN (0,1)) OR
36518: p_config_tbl(i).lock_status > l_valid_lock_status
36519: THEN
36520: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INS_STATUS');
36521: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36522: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36523: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_config_tbl(i).instance_id);
36524: FND_MSG_PUB.Add;
36525: RAISE FND_API.G_EXC_ERROR;
36518: p_config_tbl(i).lock_status > l_valid_lock_status
36519: THEN
36520: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INS_STATUS');
36521: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36522: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36523: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_config_tbl(i).instance_id);
36524: FND_MSG_PUB.Add;
36525: RAISE FND_API.G_EXC_ERROR;
36526: END IF;
36519: THEN
36520: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INS_STATUS');
36521: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36522: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36523: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_config_tbl(i).instance_id);
36524: FND_MSG_PUB.Add;
36525: RAISE FND_API.G_EXC_ERROR;
36526: END IF;
36527: ELSE
36588: IF (p_config_tbl(i).lock_status IS NULL OR
36589: p_config_tbl(i).lock_status NOT IN (0,1)) OR
36590: p_config_tbl(i).lock_status > l_valid_lock_status
36591: THEN
36592: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36593: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36594: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36595: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
36596: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
36589: p_config_tbl(i).lock_status NOT IN (0,1)) OR
36590: p_config_tbl(i).lock_status > l_valid_lock_status
36591: THEN
36592: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36593: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36594: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36595: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
36596: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
36597: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
36590: p_config_tbl(i).lock_status > l_valid_lock_status
36591: THEN
36592: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36593: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36594: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36595: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
36596: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
36597: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
36598: FND_MSG_PUB.Add;
36591: THEN
36592: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36593: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36594: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36595: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
36596: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
36597: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
36598: FND_MSG_PUB.Add;
36599: RAISE FND_API.G_EXC_ERROR;
36592: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CON_STATUS');
36593: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36594: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36595: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
36596: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
36597: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
36598: FND_MSG_PUB.Add;
36599: RAISE FND_API.G_EXC_ERROR;
36600: END IF;
36593: FND_MESSAGE.SET_TOKEN('ORIGINAL_STATUS',l_valid_lock_status);
36594: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',p_config_tbl(i).lock_status);
36595: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',p_config_tbl(i).config_inst_hdr_id);
36596: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',p_config_tbl(i).config_inst_item_id);
36597: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',p_config_tbl(i).config_inst_rev_num);
36598: FND_MSG_PUB.Add;
36599: RAISE FND_API.G_EXC_ERROR;
36600: END IF;
36601: ELSE
36620: END IF;
36621:
36622: IF l_warning = 'Y'
36623: THEN
36624: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LOCKS');
36625: FND_MSG_PUB.Add;
36626: ELSIF l_warning = 'E'
36627: THEN
36628: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKID_NOT_PASSED');
36624: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LOCKS');
36625: FND_MSG_PUB.Add;
36626: ELSIF l_warning = 'E'
36627: THEN
36628: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKID_NOT_PASSED');
36629: FND_MSG_PUB.Add;
36630: RAISE FND_API.G_EXC_ERROR;
36631: END IF;
36632: csi_gen_utility_pvt.put_line('Count of l_unlock_tbl is :'||l_unlock_tbl.count);
36661: AND lock_id = l_unlock_ins_tbl(i).lock_id
36662: AND lock_status IN (1,2);
36663: IF l_instance_ctr >1 -- this includes root
36664: THEN
36665: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INST_STATUS');
36666: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_unlock_ins_tbl(i).instance_id);
36667: FND_MSG_PUB.Add;
36668: RAISE FND_API.G_EXC_ERROR;
36669: END IF;
36662: AND lock_status IN (1,2);
36663: IF l_instance_ctr >1 -- this includes root
36664: THEN
36665: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_INST_STATUS');
36666: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_unlock_ins_tbl(i).instance_id);
36667: FND_MSG_PUB.Add;
36668: RAISE FND_API.G_EXC_ERROR;
36669: END IF;
36670: END IF;
36692: AND lock_id = l_unlock_root(i).lock_id
36693: AND lock_status IN (1,2);
36694: IF l_config_ctr >1 -- this includes root
36695: THEN
36696: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONF_STATUS');
36697: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_unlock_root(i).config_inst_hdr_id);
36698: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_unlock_root(i).config_inst_item_id);
36699: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_unlock_root(i).config_inst_rev_num);
36700: FND_MSG_PUB.Add;
36693: AND lock_status IN (1,2);
36694: IF l_config_ctr >1 -- this includes root
36695: THEN
36696: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONF_STATUS');
36697: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_unlock_root(i).config_inst_hdr_id);
36698: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_unlock_root(i).config_inst_item_id);
36699: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_unlock_root(i).config_inst_rev_num);
36700: FND_MSG_PUB.Add;
36701: RAISE FND_API.G_EXC_ERROR;
36694: IF l_config_ctr >1 -- this includes root
36695: THEN
36696: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONF_STATUS');
36697: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_unlock_root(i).config_inst_hdr_id);
36698: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_unlock_root(i).config_inst_item_id);
36699: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_unlock_root(i).config_inst_rev_num);
36700: FND_MSG_PUB.Add;
36701: RAISE FND_API.G_EXC_ERROR;
36702: END IF;
36695: THEN
36696: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONF_STATUS');
36697: FND_MESSAGE.SET_TOKEN('CONFIG_INST_HDR_ID',l_unlock_root(i).config_inst_hdr_id);
36698: FND_MESSAGE.SET_TOKEN('CONFIG_INST_ITEM_ID',l_unlock_root(i).config_inst_item_id);
36699: FND_MESSAGE.SET_TOKEN('CONFIG_INST_REV_NUM',l_unlock_root(i).config_inst_rev_num);
36700: FND_MSG_PUB.Add;
36701: RAISE FND_API.G_EXC_ERROR;
36702: END IF;
36703: END IF;