Usage of foreign key as part of composite key or creating a new key (id)? Which one to use when?

Question

Both are valid, but which one should be used when?

Here's a little example:

Case of AlarmProfileID as prime key

Case of composite key consisting of {username and name}