PACKAGE BODY: APPS.PY_ZA_USERMESG_PKG

Source

1 package body py_za_usermesg_pkg as
2 /* $Header: pyzamesg.pkb 120.2 2005/08/25 02:47:18 kapalani noship $ */
3 -------------------------------------------------------------------
4 function get_message
5 (
6    x_message_name in char
7 )  return varchar2 is
8 
9 x_message_text varchar2(2000);
10 
11 begin
12 
13    select distinct(message_text)
14    into   x_message_text
15    from   fnd_new_messages
16    where  message_name = x_message_name
17    and    language_code = userenv('LANG');
18 
19    return x_message_text;
20 
21 --   pragma restrict_references(get_message,WNDS); -- Bug 4543522
22 
23 exception
24    when no_data_found then
25       null;
26 
27 end;
28 end py_za_usermesg_pkg;