1 PACKAGE xla_messages_pkg AS
2 /* $Header: xlacmmsg.pkh 120.2 2003/02/22 19:25:56 svjoshi ship $ */
3 /*======================================================================+
4 | Copyright (c) 1994-2001 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_messages_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Messages Package |
13 | |
14 | HISTORY |
15 | 07-Dec-94 P. Labrevois Created |
16 | 07-Feb-01 Adapted for XLA |
17 | |
18 +======================================================================*/
19
20 g_message_number NUMBER := NULL;
21
22 /*======================================================================+
23 | |
24 | Public Function |
25 | |
26 | get_message_prefixed |
27 | |
28 | Return the message text associated with a message, prefixed with the | |
29 | message number. |
30 | |
31 +======================================================================*/
32 FUNCTION get_message_prefixed
33 RETURN VARCHAR2;
34
35 /*======================================================================+
36 | |
37 | Public Function |
38 | |
39 | get_message |
40 | |
41 | Return the message text associated with a message. The function can | |
42 | accept up to 6 tokens. |
43 | |
44 +======================================================================*/
45 FUNCTION get_message
46 RETURN VARCHAR2;
47
48 FUNCTION get_message
49 (p_appli_s_name IN VARCHAR2
50 ,p_msg_name IN VARCHAR2)
51 RETURN VARCHAR2;
52
53 FUNCTION get_message
54 (p_appli_s_name IN VARCHAR2
55 ,p_msg_name IN VARCHAR2
56 ,p_token_1 IN VARCHAR2
57 ,p_value_1 IN VARCHAR2)
58 RETURN VARCHAR2;
59
60 FUNCTION get_message
61 (p_appli_s_name IN VARCHAR2
62 ,p_msg_name IN VARCHAR2
63 ,p_token_1 IN VARCHAR2
64 ,p_value_1 IN VARCHAR2
65 ,p_token_2 IN VARCHAR2
66 ,p_value_2 IN VARCHAR2)
67 RETURN VARCHAR2;
68
69 FUNCTION get_message
70 (p_appli_s_name IN VARCHAR2
71 ,p_msg_name IN VARCHAR2
72 ,p_token_1 IN VARCHAR2
73 ,p_value_1 IN VARCHAR2
74 ,p_token_2 IN VARCHAR2
75 ,p_value_2 IN VARCHAR2
76 ,p_token_3 IN VARCHAR2
77 ,p_value_3 IN VARCHAR2)
78 RETURN VARCHAR2;
79
80 FUNCTION get_message
81 (p_appli_s_name IN VARCHAR2
82 ,p_msg_name IN VARCHAR2
83 ,p_token_1 IN VARCHAR2
84 ,p_value_1 IN VARCHAR2
85 ,p_token_2 IN VARCHAR2
86 ,p_value_2 IN VARCHAR2
87 ,p_token_3 IN VARCHAR2
88 ,p_value_3 IN VARCHAR2
89 ,p_token_4 IN VARCHAR2
90 ,p_value_4 IN VARCHAR2)
91 RETURN VARCHAR2;
92
93 FUNCTION get_message
94 (p_appli_s_name IN VARCHAR2
95 ,p_msg_name IN VARCHAR2
96 ,p_token_1 IN VARCHAR2
97 ,p_value_1 IN VARCHAR2
98 ,p_token_2 IN VARCHAR2
99 ,p_value_2 IN VARCHAR2
100 ,p_token_3 IN VARCHAR2
101 ,p_value_3 IN VARCHAR2
102 ,p_token_4 IN VARCHAR2
103 ,p_value_4 IN VARCHAR2
104 ,p_token_5 IN VARCHAR2
105 ,p_value_5 IN VARCHAR2)
106 RETURN VARCHAR2;
107
108 FUNCTION get_message
109 (p_appli_s_name IN VARCHAR2
110 ,p_msg_name IN VARCHAR2
111 ,p_token_1 IN VARCHAR2
112 ,p_value_1 IN VARCHAR2
113 ,p_token_2 IN VARCHAR2
114 ,p_value_2 IN VARCHAR2
115 ,p_token_3 IN VARCHAR2
116 ,p_value_3 IN VARCHAR2
117 ,p_token_4 IN VARCHAR2
118 ,p_value_4 IN VARCHAR2
119 ,p_token_5 IN VARCHAR2
120 ,p_value_5 IN VARCHAR2
121 ,p_token_6 IN VARCHAR2
122 ,p_value_6 IN VARCHAR2)
123 RETURN VARCHAR2;
124
125 /*======================================================================+
126 | |
127 | Public Function |
128 | |
129 | build_message |
130 | |
131 | Build the message text. The function can accept up to 6 tokens. | |
132 | |
133 +======================================================================*/
134 PROCEDURE build_message
135 (p_appli_s_name IN VARCHAR2
136 ,p_msg_name IN VARCHAR2);
137
138 PROCEDURE build_message
139 (p_appli_s_name IN VARCHAR2
140 ,p_msg_name IN VARCHAR2
141 ,p_token_1 IN VARCHAR2
142 ,p_value_1 IN VARCHAR2);
143
144 PROCEDURE build_message
145 (p_appli_s_name IN VARCHAR2
146 ,p_msg_name IN VARCHAR2
147 ,p_token_1 IN VARCHAR2
148 ,p_value_1 IN VARCHAR2
149 ,p_token_2 IN VARCHAR2
150 ,p_value_2 IN VARCHAR2);
151
152 PROCEDURE build_message
153 (p_appli_s_name IN VARCHAR2
154 ,p_msg_name IN VARCHAR2
155 ,p_token_1 IN VARCHAR2
156 ,p_value_1 IN VARCHAR2
157 ,p_token_2 IN VARCHAR2
158 ,p_value_2 IN VARCHAR2
159 ,p_token_3 IN VARCHAR2
160 ,p_value_3 IN VARCHAR2);
161
162 PROCEDURE build_message
163 (p_appli_s_name IN VARCHAR2
164 ,p_msg_name IN VARCHAR2
165 ,p_token_1 IN VARCHAR2
166 ,p_value_1 IN VARCHAR2
167 ,p_token_2 IN VARCHAR2
168 ,p_value_2 IN VARCHAR2
169 ,p_token_3 IN VARCHAR2
170 ,p_value_3 IN VARCHAR2
171 ,p_token_4 IN VARCHAR2
172 ,p_value_4 IN VARCHAR2);
173
174 PROCEDURE build_message
175 (p_appli_s_name IN VARCHAR2
176 ,p_msg_name IN VARCHAR2
177 ,p_token_1 IN VARCHAR2
178 ,p_value_1 IN VARCHAR2
179 ,p_token_2 IN VARCHAR2
180 ,p_value_2 IN VARCHAR2
181 ,p_token_3 IN VARCHAR2
182 ,p_value_3 IN VARCHAR2
183 ,p_token_4 IN VARCHAR2
184 ,p_value_4 IN VARCHAR2
185 ,p_token_5 IN VARCHAR2
186 ,p_value_5 IN VARCHAR2);
187
188 PROCEDURE build_message
189 (p_appli_s_name IN VARCHAR2
190 ,p_msg_name IN VARCHAR2
191 ,p_token_1 IN VARCHAR2
192 ,p_value_1 IN VARCHAR2
193 ,p_token_2 IN VARCHAR2
194 ,p_value_2 IN VARCHAR2
195 ,p_token_3 IN VARCHAR2
196 ,p_value_3 IN VARCHAR2
197 ,p_token_4 IN VARCHAR2
198 ,p_value_4 IN VARCHAR2
199 ,p_token_5 IN VARCHAR2
200 ,p_value_5 IN VARCHAR2
201 ,p_token_6 IN VARCHAR2
202 ,p_value_6 IN VARCHAR2);
203
204 END xla_messages_pkg;