I am still not grasping something with how pathing works when trying to copy a file using the file function. I have a base.pp profile located here:

dmin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile/manifests/linux# ls -al
total 20
drwxr-x--- 4 pe-puppet pe-puppet 4096 Apr  3 19:40 .
drwxr-x--- 3 pe-puppet pe-puppet 4096 Apr  3 16:20 ..
-rw-r----- 1 pe-puppet pe-puppet 1802 Apr  3 19:40 base.pp
drwxr-x--- 2 pe-puppet pe-puppet 4096 Apr  3 19:18 files
drwxr-x--- 2 pe-puppet pe-puppet 4096 Apr  3 16:20 manifests
admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile/manifests/linux#

Which has:

file { '/etc/snmp/snmpd.conf':
        ensure  => file,
        content => file("${module_name}/manifests/linux/files/conf.snmpd.debian.${facts['company_node_identification']['datacenter']}"),

When I run it on my test agent I get:

puppet agent -t
Info: Using environment 'production'
Info: Retrieving pluginfacts
Info: Retrieving plugin
Info: Loading facts
Error: Could not retrieve catalog from remote server: Error 500 on SERVER: Server Error: Evaluation Error: Error while evaluating a Resource Statement, 
Evaluation Error: Error while evaluating a Function Call, Could not find any files from profile/manifests/linux/files/conf.snmpd.debian.ash 
(file: /etc/puppetlabs/code/environments/production/site-modules/profile/manifests/linux/base.pp, line: 28, column: 20) on node ash-test-99
Warning: Not using cache on failed catalog
Error: Could not retrieve catalog; skipping run

And I am 100% sure this file exists:

admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules# ls -al
total 28
drwxr-x--- 7 pe-puppet pe-puppet 4096 Feb 24 16:22 .
drwxr-x--- 8 pe-puppet pe-puppet 4096 Apr  3 19:40 ..
drwxr-x--- 4 pe-puppet pe-puppet 4096 Jan 26 21:50 adhoc
drwxr-x--- 3 pe-puppet pe-puppet 4096 Feb  8 18:09 custom_facts
drwxr-x--- 3 pe-puppet pe-puppet 4096 Feb 24 16:22 firewall
drwxr-x--- 3 pe-puppet pe-puppet 4096 Apr  3 16:16 profile
drwxr-x--- 3 pe-puppet pe-puppet 4096 Feb 10 16:44 role
admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules# cd profile/
admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile# cd manifests/
admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile/manifests# ls
example.pp  linux 
admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile/manifests# cd linux/
admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile/manifests/linux# ls -al
total 20
drwxr-x--- 4 pe-puppet pe-puppet 4096 Apr  3 19:40 .
drwxr-x--- 3 pe-puppet pe-puppet 4096 Apr  3 16:20 ..
-rw-r----- 1 pe-puppet pe-puppet 1802 Apr  3 19:40 base.pp
drwxr-x--- 2 pe-puppet pe-puppet 4096 Apr  3 19:18 files
drwxr-x--- 2 pe-puppet pe-puppet 4096 Apr  3 16:20 manifests
admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile/manifests/linux# cd files/
admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile/manifests/linux/files# ls -al
total 28
drwxr-x--- 2 pe-puppet pe-puppet 4096 Apr  3 19:18 .
drwxr-x--- 4 pe-puppet pe-puppet 4096 Apr  3 19:40 ..
-rw-r----- 1 pe-puppet pe-puppet  363 Apr  3 16:16 conf.snmpd.debian.ash

admin@pe-master:/etc/puppetlabs/code/environments/production/site-modules/profile/manifests/linux/files#