I tried following (Series60 SDK) but it doesn't do anything
either in device itself nor emulator.

TBaSystemSoundType SoundType;
SoundType.iMajor=KSystemSoundAlarmUID;
CoeSoundPlayer::PlaySoundNow(SoundType);