5159: END IF;
5160:
5161: IF l_eam_item
5162: THEN
5163: csi_gen_utility_pvt.put_line( 'Calling eam_common_utilities_pvt.update_logical_asset...');
5164: csi_gen_utility_pvt.put_line( 'Inventory_item_id is :'||p_instance_rec.inventory_item_id);
5165: csi_gen_utility_pvt.put_line( 'Serial_number is :'||p_instance_rec.serial_number);
5166: csi_gen_utility_pvt.put_line( 'Network_asset_flag is :'||p_instance_rec.network_asset_flag);
5167: csi_gen_utility_pvt.put_line( 'Pn_location_id is :'||p_instance_rec.pn_location_id);
5165: csi_gen_utility_pvt.put_line( 'Serial_number is :'||p_instance_rec.serial_number);
5166: csi_gen_utility_pvt.put_line( 'Network_asset_flag is :'||p_instance_rec.network_asset_flag);
5167: csi_gen_utility_pvt.put_line( 'Pn_location_id is :'||p_instance_rec.pn_location_id);
5168: csi_gen_utility_pvt.put_line( 'Equipment_gen_object_id is :'||p_instance_rec.equipment_gen_object_id);
5169: eam_common_utilities_pvt.update_logical_asset
5170: ( p_inventory_item_id => p_instance_rec.inventory_item_id
5171: ,p_serial_number => p_instance_rec.serial_number
5172: ,p_network_asset_flag => p_instance_rec.network_asset_flag
5173: ,p_pn_location_id => p_instance_rec.pn_location_id
5175: ,x_return_status => x_return_status
5176: );
5177: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)
5178: THEN
5179: csi_gen_utility_pvt.put_line( 'Error from eam_common_utilities_pvt.update_logical_asset...');
5180: RAISE fnd_api.g_exc_error;
5181: END IF;
5182: END IF;
5183:
7605: IF l_eam_item AND
7606: (p_instance_rec.active_end_date IS NOT NULL AND
7607: p_instance_rec.active_end_date <> fnd_api.g_miss_date)
7608: THEN
7609: IF NOT eam_common_utilities_pvt.check_deactivate
7610: (p_maintenance_object_id => l_rel_tbl(j).subject_id
7611: ,p_maintenance_object_type => l_maintenance_object_type)
7612: THEN
7613: csi_gen_utility_pvt.put_line('Error from eam_common_utilities_pvt.check_deactivate API ');
7609: IF NOT eam_common_utilities_pvt.check_deactivate
7610: (p_maintenance_object_id => l_rel_tbl(j).subject_id
7611: ,p_maintenance_object_type => l_maintenance_object_type)
7612: THEN
7613: csi_gen_utility_pvt.put_line('Error from eam_common_utilities_pvt.check_deactivate API ');
7614: RAISE fnd_api.g_exc_error;
7615: END IF;
7616: END IF;
7617: -- End code addition for eam integration
12868: ELSE
12869: l_pn_location_id := p_instance_rec.pn_location_id;
12870: END IF;
12871:
12872: csi_gen_utility_pvt.put_line( 'Calling eam_common_utilities_pvt.update_logical_asset...');
12873: csi_gen_utility_pvt.put_line( 'Inventory_item_id is :'||l_get_instance_rec.inventory_item_id);
12874: csi_gen_utility_pvt.put_line( 'Serial_number is :'||l_get_instance_rec.serial_number);
12875: csi_gen_utility_pvt.put_line( 'Network_asset_flag is :'||l_network_asset_flag);
12876: csi_gen_utility_pvt.put_line( 'Pn_location_id is :'||l_pn_location_id);
12874: csi_gen_utility_pvt.put_line( 'Serial_number is :'||l_get_instance_rec.serial_number);
12875: csi_gen_utility_pvt.put_line( 'Network_asset_flag is :'||l_network_asset_flag);
12876: csi_gen_utility_pvt.put_line( 'Pn_location_id is :'||l_pn_location_id);
12877: csi_gen_utility_pvt.put_line( 'Equipment_gen_object_id is :'||p_instance_rec.equipment_gen_object_id);
12878: eam_common_utilities_pvt.update_logical_asset
12879: ( p_inventory_item_id => l_get_instance_rec.inventory_item_id
12880: ,p_serial_number => l_get_instance_rec.serial_number
12881: ,p_network_asset_flag => l_network_asset_flag
12882: ,p_pn_location_id => l_pn_location_id
12885: );
12886:
12887: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS)
12888: THEN
12889: csi_gen_utility_pvt.put_line( 'Error from eam_common_utilities_pvt.update_logical_asset...');
12890: RAISE fnd_api.g_exc_error;
12891: END IF;
12892: END IF;
12893:
14140: IF l_eam_item AND
14141: (p_instance_rec.active_end_date IS NOT NULL AND
14142: p_instance_rec.active_end_date <> fnd_api.g_miss_date)
14143: THEN
14144: IF NOT eam_common_utilities_pvt.check_deactivate
14145: (p_maintenance_object_id => p_instance_rec.instance_id
14146: ,p_maintenance_object_type => l_maintenance_object_type)
14147: THEN
14148: csi_gen_utility_pvt.put_line('Error from eam_common_utilities_pvt.check_deactivate API ');
14144: IF NOT eam_common_utilities_pvt.check_deactivate
14145: (p_maintenance_object_id => p_instance_rec.instance_id
14146: ,p_maintenance_object_type => l_maintenance_object_type)
14147: THEN
14148: csi_gen_utility_pvt.put_line('Error from eam_common_utilities_pvt.check_deactivate API ');
14149: RAISE fnd_api.g_exc_error;
14150: END IF;
14151: END IF;
14152: -- End code addition for eam integration
19157: IF l_eam_item AND
19158: (l_temp_date IS NOT NULL AND
19159: l_temp_date <> fnd_api.g_miss_date)
19160: THEN
19161: IF NOT eam_common_utilities_pvt.check_deactivate
19162: (p_maintenance_object_id => p_instance_rec.instance_id
19163: ,p_maintenance_object_type => l_maintenance_object_type)
19164: THEN
19165: csi_gen_utility_pvt.put_line('Error from eam_common_utilities_pvt.check_deactivate API ');
19161: IF NOT eam_common_utilities_pvt.check_deactivate
19162: (p_maintenance_object_id => p_instance_rec.instance_id
19163: ,p_maintenance_object_type => l_maintenance_object_type)
19164: THEN
19165: csi_gen_utility_pvt.put_line('Error from eam_common_utilities_pvt.check_deactivate API ');
19166: RAISE fnd_api.g_exc_error;
19167: END IF;
19168: END IF;
19169: -- End code addition for eam integration
20403: IF l_eam_item AND
20404: (p_instance_rec.active_end_date IS NOT NULL AND
20405: p_instance_rec.active_end_date <> fnd_api.g_miss_date)
20406: THEN
20407: IF NOT eam_common_utilities_pvt.check_deactivate
20408: (p_maintenance_object_id => p_instance_rec.instance_id
20409: ,p_maintenance_object_type => l_maintenance_object_type)
20410: THEN
20411: csi_gen_utility_pvt.put_line('Error from eam_common_utilities_pvt.check_deactivate API ');
20407: IF NOT eam_common_utilities_pvt.check_deactivate
20408: (p_maintenance_object_id => p_instance_rec.instance_id
20409: ,p_maintenance_object_type => l_maintenance_object_type)
20410: THEN
20411: csi_gen_utility_pvt.put_line('Error from eam_common_utilities_pvt.check_deactivate API ');
20412: RAISE fnd_api.g_exc_error;
20413: END IF;
20414: END IF;
20415: -- End code addition for eam integration