DBA Data[Home] [Help]

PACKAGE BODY: APPS.XLA_MESSAGES_PKG

Source


1 PACKAGE BODY xla_messages_pkg AS
2 /* $Header: xlacmmsg.pkb 120.4 2011/04/26 11:20:42 sgullape ship $ */
3 /*======================================================================+
4 |             Copyright (c) 1995-2002 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-95 P. Labrevois    Created                                  |
16 |    07-Feb-01                 Adapted for XLA                          |
17 |                                                                       |
18 +======================================================================*/
19 
20 /*======================================================================+
21 |                                                                       |
22 |                                                                       |
23 |                                                                       |
24 |                                                                       |
25 |                                                                       |
26 |                                                                       |
27 |                                                                       |
28 |                                                                       |
29 |                                                                       |
30 |                                                                       |
31 | build_message                                                         |
32 |                                                                       |
33 |                                                                       |
34 |                                                                       |
35 |                                                                       |
36 |                                                                       |
37 |                                                                       |
38 |                                                                       |
39 |                                                                       |
40 |                                                                       |
41 |                                                                       |
42 +======================================================================*/
43 
44 
45 /*======================================================================+
46 |                                                                       |
47 | build_message                                                         |
48 |                                                                       |
49 | Build the message, to token is passed.                                |
50 |                                                                       |
51 +======================================================================*/
52 PROCEDURE build_message
53   (p_appli_s_name                 IN  VARCHAR2
54   ,p_msg_name                     IN  VARCHAR2)
55 
56 IS
57 
58 BEGIN
59 fnd_message.set_name
60   (p_appli_s_name
61   ,p_msg_name);
62 
63 --
64 -- Store the message number in a global
65 --
66 g_message_number := fnd_message.get_number
67   (p_appli_s_name
68   ,p_msg_name);
69 END build_message;
70 
71 
72 /*======================================================================+
73 |                                                                       |
74 | build_message                                                         |
75 |                                                                       |
76 | Build the message, completed with the value for 1 token               |
77 |                                                                       |
78 +======================================================================*/
79 PROCEDURE build_message
80   (p_appli_s_name                 IN  VARCHAR2
81   ,p_msg_name                     IN  VARCHAR2
82   ,p_token_1                      IN  VARCHAR2
83   ,p_value_1                      IN  VARCHAR2)
84 
85 IS
86 
87 BEGIN
88 build_message
89   (p_appli_s_name
90   ,p_msg_name);
91 
92 fnd_message.set_token
93   (p_token_1
94   ,p_value_1);
95 END build_message;
96 
97 
98 /*======================================================================+
99 |                                                                       |
100 | Public Procedure                                                      |
101 |                                                                       |
102 | build_message                                                         |
103 |                                                                       |
104 | Build the message, completed with the value for 2 token               |
105 |                                                                       |
106 +======================================================================*/
107 PROCEDURE build_message
108   (p_appli_s_name                 IN  VARCHAR2
109   ,p_msg_name                     IN  VARCHAR2
110   ,p_token_1                      IN  VARCHAR2
111   ,p_value_1                      IN  VARCHAR2
112   ,p_token_2                      IN  VARCHAR2
113   ,p_value_2                      IN  VARCHAR2)
114 
115 IS
116 
117 BEGIN
118 build_message
119   (p_appli_s_name
120   ,p_msg_name
121   ,p_token_1
122   ,p_value_1);
123 
124 fnd_message.set_token
125   (p_token_2
126   ,p_value_2);
127 END build_message;
128 
129 
130 /*======================================================================+
131 |                                                                       |
132 | Public Procedure                                                      |
133 |                                                                       |
134 | build_message                                                         |
135 |                                                                       |
136 | Build the message, completed with the value for 3 token               |
137 |                                                                       |
138 +======================================================================*/
139 PROCEDURE build_message
140   (p_appli_s_name                 IN  VARCHAR2
141   ,p_msg_name                     IN  VARCHAR2
142   ,p_token_1                      IN  VARCHAR2
143   ,p_value_1                      IN  VARCHAR2
144   ,p_token_2                      IN  VARCHAR2
145   ,p_value_2                      IN  VARCHAR2
146   ,p_token_3                      IN  VARCHAR2
147   ,p_value_3                      IN  VARCHAR2)
148 
149 IS
150 
151 BEGIN
152 build_message
153   (p_appli_s_name
154   ,p_msg_name
155   ,p_token_1
156   ,p_value_1
157   ,p_token_2
158   ,p_value_2);
159 
160 fnd_message.set_token
161   (p_token_3
162   ,p_value_3);
163 END build_message;
164 
165 
166 /*======================================================================+
167 |                                                                       |
168 | Public Procedure                                                      |
169 |                                                                       |
170 | build_message                                                         |
171 |                                                                       |
172 | Build the message, completed with the value for 4 token               |
173 |                                                                       |
174 +======================================================================*/
175 PROCEDURE build_message
176   (p_appli_s_name                 IN  VARCHAR2
177   ,p_msg_name                     IN  VARCHAR2
178   ,p_token_1                      IN  VARCHAR2
179   ,p_value_1                      IN  VARCHAR2
180   ,p_token_2                      IN  VARCHAR2
181   ,p_value_2                      IN  VARCHAR2
182   ,p_token_3                      IN  VARCHAR2
183   ,p_value_3                      IN  VARCHAR2
184   ,p_token_4                      IN  VARCHAR2
185   ,p_value_4                      IN  VARCHAR2)
186 
187 IS
188 
189 BEGIN
190 build_message
191   (p_appli_s_name
192   ,p_msg_name
193   ,p_token_1
194   ,p_value_1
195   ,p_token_2
196   ,p_value_2
197   ,p_token_3
198   ,p_value_3);
199 
200 fnd_message.set_token
201   (p_token_4
202   ,p_value_4);
203 END build_message;
204 
205 
206 /*======================================================================+
207 |                                                                       |
208 | Public Procedure                                                      |
209 |                                                                       |
210 | build_message                                                         |
211 |                                                                       |
212 | Build the message, completed with the value for 5 token               |
213 |                                                                       |
214 +======================================================================*/
215 PROCEDURE build_message
216   (p_appli_s_name                 IN  VARCHAR2
217   ,p_msg_name                     IN  VARCHAR2
218   ,p_token_1                      IN  VARCHAR2
219   ,p_value_1                      IN  VARCHAR2
220   ,p_token_2                      IN  VARCHAR2
221   ,p_value_2                      IN  VARCHAR2
222   ,p_token_3                      IN  VARCHAR2
223   ,p_value_3                      IN  VARCHAR2
224   ,p_token_4                      IN  VARCHAR2
225   ,p_value_4                      IN  VARCHAR2
226   ,p_token_5                      IN  VARCHAR2
227   ,p_value_5                      IN  VARCHAR2)
228 
229 IS
230 
231 BEGIN
232 build_message
233   (p_appli_s_name
234   ,p_msg_name
235   ,p_token_1
236   ,p_value_1
237   ,p_token_2
238   ,p_value_2
239   ,p_token_3
240   ,p_value_3
241   ,p_token_4
242   ,p_value_4);
243 
244 fnd_message.set_token
245   (p_token_5
246   ,p_value_5);
247 END build_message;
248 
249 
250 /*======================================================================+
251 |                                                                       |
252 | Public Procedure                                                      |
253 |                                                                       |
254 | build_message                                                         |
255 |                                                                       |
256 | Build the message, completed with the value for 6 token               |
257 |                                                                       |
258 +======================================================================*/
259 PROCEDURE build_message
260   (p_appli_s_name                 IN  VARCHAR2
261   ,p_msg_name                     IN  VARCHAR2
262   ,p_token_1                      IN  VARCHAR2
263   ,p_value_1                      IN  VARCHAR2
264   ,p_token_2                      IN  VARCHAR2
265   ,p_value_2                      IN  VARCHAR2
266   ,p_token_3                      IN  VARCHAR2
267   ,p_value_3                      IN  VARCHAR2
268   ,p_token_4                      IN  VARCHAR2
269   ,p_value_4                      IN  VARCHAR2
270   ,p_token_5                      IN  VARCHAR2
271   ,p_value_5                      IN  VARCHAR2
272   ,p_token_6                      IN  VARCHAR2
273   ,p_value_6                      IN  VARCHAR2)
274 
275 IS
276 
277 BEGIN
278 build_message
279   (p_appli_s_name
280   ,p_msg_name
281   ,p_token_1
282   ,p_value_1
283   ,p_token_2
284   ,p_value_2
285   ,p_token_3
286   ,p_value_3
287   ,p_token_4
288   ,p_value_4
289   ,p_token_5
290   ,p_value_5);
291 
292 fnd_message.set_token
293   (p_token_6
294   ,p_value_6);
295 END build_message;
296 
297 
298 /*======================================================================+
299 |                                                                       |
300 |                                                                       |
301 |                                                                       |
302 |                                                                       |
303 |                                                                       |
304 |                                                                       |
305 |                                                                       |
306 |                                                                       |
307 |                                                                       |
308 |                                                                       |
309 | get_message_prefixed                                                  |
310 |                                                                       |
311 |                                                                       |
312 |                                                                       |
313 |                                                                       |
314 |                                                                       |
315 |                                                                       |
316 |                                                                       |
317 |                                                                       |
318 |                                                                       |
319 |                                                                       |
320 +======================================================================*/
321 
322 /*======================================================================+
323 |                                                                       |
324 | Public Function                                                       |
325 |                                                                       |
326 | get_message_prefixed                                                  |
327 |                                                                       |
328 | Return the message from the message stack, prefixed with the message  |
329 | number.                                                               |
330 +======================================================================*/
331 FUNCTION  get_message_prefixed
332 RETURN VARCHAR2
333 
334 IS
335 
336 BEGIN
337 
338 --Bug : 12369074
339 --Removed IF condition,so it returns 2000 characters for all releases.
340 
341    IF g_message_number IS NULL THEN
342       RETURN SUBSTR(fnd_message.get,1,2000);
343    ELSE
344       RETURN SUBSTR('XLA-'
345                ||   TO_CHAR(g_message_number)
346                ||   xla_environment_pkg.g_chr_newline
347                ||   xla_environment_pkg.g_chr_newline
348                ||   fnd_message.get
349                ||   xla_environment_pkg.g_chr_newline,1,2000);
350    END IF;
351 
352 END get_message_prefixed;
353 
354 
355 /*======================================================================+
356 |                                                                       |
357 |                                                                       |
358 |                                                                       |
359 |                                                                       |
360 |                                                                       |
361 |                                                                       |
362 |                                                                       |
363 |                                                                       |
364 |                                                                       |
365 |                                                                       |
366 | get_message                                                           |
367 |                                                                       |
368 |                                                                       |
369 |                                                                       |
370 |                                                                       |
371 |                                                                       |
372 |                                                                       |
373 |                                                                       |
374 |                                                                       |
375 |                                                                       |
376 |                                                                       |
377 +======================================================================*/
378 
379 
380 /*======================================================================+
381 |                                                                       |
382 | Public Function                                                       |
383 |                                                                       |
384 | get_message                                                           |
385 |                                                                       |
386 | Return the message from the message stack.                            |
387 +======================================================================*/
388 FUNCTION  get_message
389 RETURN VARCHAR2
390 
391 IS
392 
393 BEGIN
394 --Bug : 12369074
395 --Removed IF condition,so it returns 2000 characters for all releases.
396 
397    RETURN SUBSTR(fnd_message.get,1,2000);
398 
399 END get_message;
400 
401 
402 /*======================================================================+
403 |                                                                       |
404 | Public Function                                                       |
405 |                                                                       |
406 | get_message                                                           |
407 |                                                                       |
408 | Return the message not associated with any token.                     |
409 |                                                                       |
410 +======================================================================*/
411 FUNCTION  get_message
412   (p_appli_s_name                 IN  VARCHAR2
413   ,p_msg_name                     IN  VARCHAR2)
414 RETURN VARCHAR2
415 
416 IS
417 
418 BEGIN
419 build_message
420   (p_appli_s_name
421   ,p_msg_name);
422 
423 RETURN get_message;
424 END get_message;
425 
426 
427 /*======================================================================+
428 |                                                                       |
429 | Public Function                                                       |
430 |                                                                       |
431 | get_message                                                           |
432 |                                                                       |
433 | Return the message completed with the value for 1 token.              |
434 |                                                                       |
435 +======================================================================*/
436 FUNCTION  get_message
437   (p_appli_s_name                 IN  VARCHAR2
438   ,p_msg_name                     IN  VARCHAR2
439   ,p_token_1                      IN  VARCHAR2
440   ,p_value_1                      IN  VARCHAR2)
441 RETURN VARCHAR2
442 
443 IS
444 BEGIN
445 build_message
446   (p_appli_s_name
447   ,p_msg_name
448   ,p_token_1
449   ,p_value_1);
450 
451 RETURN get_message;
452 END get_message;
453 
454 
455 /*======================================================================+
456 |                                                                       |
457 | Public Function                                                       |
458 |                                                                       |
459 | get_message                                                           |
460 |                                                                       |
461 | Return the message completed with the value for 2 token.              |
462 |                                                                       |
463 +======================================================================*/
464 FUNCTION  get_message
465   (p_appli_s_name                 IN  VARCHAR2
466   ,p_msg_name                     IN  VARCHAR2
467   ,p_token_1                      IN  VARCHAR2
468   ,p_value_1                      IN  VARCHAR2
469   ,p_token_2                      IN  VARCHAR2
470   ,p_value_2                      IN  VARCHAR2)
471 RETURN VARCHAR2
472 
473 IS
474 BEGIN
475 build_message
476   (p_appli_s_name
477   ,p_msg_name
478   ,p_token_1
479   ,p_value_1
480   ,p_token_2
481   ,p_value_2);
482 
483 RETURN get_message;
484 END get_message;
485 
486 
487 /*======================================================================+
488 |                                                                       |
489 | Public Function                                                       |
490 |                                                                       |
491 | get_message                                                           |
492 |                                                                       |
493 | Return the message completed with the value for 3 token.              |
494 |                                                                       |
495 +======================================================================*/
496 FUNCTION  get_message
497   (p_appli_s_name                 IN  VARCHAR2
498   ,p_msg_name                     IN  VARCHAR2
499   ,p_token_1                      IN  VARCHAR2
500   ,p_value_1                      IN  VARCHAR2
501   ,p_token_2                      IN  VARCHAR2
502   ,p_value_2                      IN  VARCHAR2
503   ,p_token_3                      IN  VARCHAR2
504   ,p_value_3                      IN  VARCHAR2)
505 RETURN VARCHAR2
506 
507 IS
508 BEGIN
509 build_message
510   (p_appli_s_name
511   ,p_msg_name
512   ,p_token_1
513   ,p_value_1
514   ,p_token_2
515   ,p_value_2
516   ,p_token_3
517   ,p_value_3);
518 
519 RETURN get_message;
520 END get_message;
521 
522 
523 /*======================================================================+
524 |                                                                       |
525 | Public Function                                                       |
526 |                                                                       |
527 | get_message                                                           |
528 |                                                                       |
529 | Return the message completed with the value for 4 token.              |
530 |                                                                       |
531 +======================================================================*/
532 FUNCTION  get_message
533   (p_appli_s_name                 IN  VARCHAR2
534   ,p_msg_name                     IN  VARCHAR2
535   ,p_token_1                      IN  VARCHAR2
536   ,p_value_1                      IN  VARCHAR2
537   ,p_token_2                      IN  VARCHAR2
538   ,p_value_2                      IN  VARCHAR2
539   ,p_token_3                      IN  VARCHAR2
540   ,p_value_3                      IN  VARCHAR2
541   ,p_token_4                      IN  VARCHAR2
542   ,p_value_4                      IN  VARCHAR2)
543 RETURN VARCHAR2
544 
545 IS
546 BEGIN
547 build_message
548   (p_appli_s_name
549   ,p_msg_name
550   ,p_token_1
551   ,p_value_1
552   ,p_token_2
553   ,p_value_2
554   ,p_token_3
555   ,p_value_3
556   ,p_token_4
557   ,p_value_4);
558 
559 RETURN get_message;
560 END get_message;
561 
562 
563 /*======================================================================+
564 |                                                                       |
565 | Public Function                                                       |
566 |                                                                       |
567 | get_message                                                           |
568 |                                                                       |
569 | Return the message completed with the value for 5 token.              |
570 |                                                                       |
571 +======================================================================*/
572 FUNCTION  get_message
573   (p_appli_s_name                 IN  VARCHAR2
574   ,p_msg_name                     IN  VARCHAR2
575   ,p_token_1                      IN  VARCHAR2
576   ,p_value_1                      IN  VARCHAR2
577   ,p_token_2                      IN  VARCHAR2
578   ,p_value_2                      IN  VARCHAR2
579   ,p_token_3                      IN  VARCHAR2
580   ,p_value_3                      IN  VARCHAR2
581   ,p_token_4                      IN  VARCHAR2
582   ,p_value_4                      IN  VARCHAR2
583   ,p_token_5                      IN  VARCHAR2
584   ,p_value_5                      IN  VARCHAR2)
585 RETURN VARCHAR2
586 
587 IS
588 BEGIN
589 build_message
590   (p_appli_s_name
591   ,p_msg_name
592   ,p_token_1
593   ,p_value_1
594   ,p_token_2
595   ,p_value_2
596   ,p_token_3
597   ,p_value_3
598   ,p_token_4
599   ,p_value_4
600   ,p_token_5
601   ,p_value_5);
602 
603 RETURN get_message;
604 END get_message;
605 
606 
607 /*======================================================================+
608 |                                                                       |
609 | Public Function                                                       |
610 |                                                                       |
611 | get_message                                                           |
612 |                                                                       |
613 | Return the message completed with the value for 6 token.              |
614 |                                                                       |
615 +======================================================================*/
616 FUNCTION  get_message
617   (p_appli_s_name                 IN  VARCHAR2
618   ,p_msg_name                     IN  VARCHAR2
619   ,p_token_1                      IN  VARCHAR2
620   ,p_value_1                      IN  VARCHAR2
621   ,p_token_2                      IN  VARCHAR2
622   ,p_value_2                      IN  VARCHAR2
623   ,p_token_3                      IN  VARCHAR2
624   ,p_value_3                      IN  VARCHAR2
625   ,p_token_4                      IN  VARCHAR2
626   ,p_value_4                      IN  VARCHAR2
627   ,p_token_5                      IN  VARCHAR2
628   ,p_value_5                      IN  VARCHAR2
629   ,p_token_6                      IN  VARCHAR2
630   ,p_value_6                      IN  VARCHAR2)
631 RETURN VARCHAR2
632 
633 IS
634 BEGIN
635 build_message
636   (p_appli_s_name
637   ,p_msg_name
638   ,p_token_1
639   ,p_value_1
640   ,p_token_2
641   ,p_value_2
642   ,p_token_3
643   ,p_value_3
644   ,p_token_4
645   ,p_value_4
646   ,p_token_5
647   ,p_value_5
648   ,p_token_6
649   ,p_value_6);
650 
651 RETURN get_message;
652 END get_message;
653 
654 
655 END xla_messages_pkg;