3944: -- Bug 3824928 Added code below
3945: begin
3946: if(x_language_code = null) then
3947: select language into x_language_code
3948: from wf_users where name = x_bidder_username;
3949: end if;
3950: exception
3951: when others then
3952: x_language_code := null;
4476:
4477:
4478: select NOTIFICATION_PREFERENCE, LANGUAGE, TERRITORY
4479: into x_contact_notif_pref, x_contact_lang, x_contact_territory
4480: from wf_users where name = x_user_name;
4481:
4482: -- Get NLS_LANGUAGE and NLS_TERRITORY for the user corresponding to additional contact
4483:
4484: IF x_user_name is not null THEN