[Home] [Help]
PACKAGE BODY: APPS.HR_VIEW_ALERT_MESSAGES
Source
1 PACKAGE BODY HR_VIEW_ALERT_MESSAGES AS
2 /* $Header: pervamsg.pkb 115.4 2003/05/16 14:23:13 akmistry noship $ */
3 msg varchar2(2000);
4
5 /*----------------------------------------------------*/
6 /* Business Group Version overloaded version with 10 */
7 /* tokens */
8 /*----------------------------------------------------*/
9
10 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
11 ,p_token1 in varchar2
12 ,p_token2 in varchar2
13 ,p_token3 in varchar2
14 ,p_token4 in varchar2
15 ,p_token5 in varchar2
16 ,p_token6 in varchar2
17 ,p_token7 in varchar2
18 ,p_token8 in varchar2
19 ,p_token9 in varchar2
20 ,p_tokena in varchar2
21 ,p_business_group in number)
22 RETURN VARCHAR2 IS
23 --
24 BEGIN
25 --
26 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
27 --
28 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
29 --
30 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
31 --
32 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
33 --
34 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
35 --
36 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
37 --
38 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
39 --
40 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
41 --
42 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
43 --
44 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
45 --
46 HR_BPL_MESSAGE.set_token('TOKENA',p_tokena);
47 --
48 msg := HR_BPL_MESSAGE.get;
49 --
50 RETURN(msg);
51 END GET_MESSAGE_LNG_BG;
52
53 /*----------------------------------------------------*/
54 /* Business Group Version overloaded version with 9 */
55 /* tokens */
56 /*----------------------------------------------------*/
57
58
59 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
60 ,p_token1 in varchar2
61 ,p_token2 in varchar2
62 ,p_token3 in varchar2
63 ,p_token4 in varchar2
64 ,p_token5 in varchar2
65 ,p_token6 in varchar2
66 ,p_token7 in varchar2
67 ,p_token8 in varchar2
68 ,p_token9 in varchar2
69 ,p_business_group in number)
70 RETURN VARCHAR2 IS
71 --
72 BEGIN
73 --
74 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
75 --
76 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
77 --
78 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
79 --
80 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
81 --
82 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
83 --
84 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
85 --
86 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
87 --
88 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
89 --
90 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
91 --
92 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
93 --
94 msg := HR_BPL_MESSAGE.get;
95 --
96 RETURN(msg);
97 END GET_MESSAGE_LNG_BG;
98
99 /*----------------------------------------------------*/
100 /* Business Group Version overloaded version with 8 */
101 /* tokens */
102 /*----------------------------------------------------*/
103
104
105 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
106 ,p_token1 in varchar2
107 ,p_token2 in varchar2
108 ,p_token3 in varchar2
109 ,p_token4 in varchar2
110 ,p_token5 in varchar2
111 ,p_token6 in varchar2
112 ,p_token7 in varchar2
113 ,p_token8 in varchar2
114 ,p_business_group in number)
115 RETURN VARCHAR2 IS
116 --
117 BEGIN
118 --
119 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
120 --
121 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
122 --
123 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
124 --
125 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
126 --
127 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
128 --
129 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
130 --
131 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
132 --
133 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
134 --
135 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
136 --
137 msg := HR_BPL_MESSAGE.get;
138 --
139 RETURN(msg);
140 END GET_MESSAGE_LNG_BG;
141
142
143 /*----------------------------------------------------*/
144 /* Business Group Version overloaded version with 7 */
145 /* tokens */
146 /*----------------------------------------------------*/
147
148 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
149 ,p_token1 in varchar2
150 ,p_token2 in varchar2
151 ,p_token3 in varchar2
152 ,p_token4 in varchar2
153 ,p_token5 in varchar2
154 ,p_token6 in varchar2
155 ,p_token7 in varchar2
156 ,p_business_group in number)
157 RETURN VARCHAR2 IS
158 --
159 BEGIN
160 --
161 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
162 --
163 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
164 --
165 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
166 --
167 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
168 --
169 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
170 --
171 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
172 --
173 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
174 --
175 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
176 --
177 msg := HR_BPL_MESSAGE.get;
178 --
179 RETURN(msg);
180 END GET_MESSAGE_LNG_BG;
181
182 /*----------------------------------------------------*/
183 /* Business Group Version overloaded version with 6 */
184 /* tokens */
185 /*----------------------------------------------------*/
186
187 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
188 ,p_token1 in varchar2
189 ,p_token2 in varchar2
190 ,p_token3 in varchar2
191 ,p_token4 in varchar2
192 ,p_token5 in varchar2
193 ,p_token6 in varchar2
194 ,p_business_group in number)
195 RETURN VARCHAR2 IS
196 --
197 BEGIN
198 --
199 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
200 --
201 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
202 --
203 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
204 --
205 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
206 --
207 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
208 --
209 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
210 --
211 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
212 --
213 msg := HR_BPL_MESSAGE.get;
214 --
215 RETURN(msg);
216 END GET_MESSAGE_LNG_BG;
217
218 /*----------------------------------------------------*/
219 /* Business Group Version overloaded version with 5 */
220 /* tokens */
221 /*----------------------------------------------------*/
222
223 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
224 ,p_token1 in varchar2
225 ,p_token2 in varchar2
226 ,p_token3 in varchar2
227 ,p_token4 in varchar2
228 ,p_token5 in varchar2
229 ,p_business_group in number)
230 RETURN VARCHAR2 IS
231 --
232 BEGIN
233 --
234 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
235 --
236 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
237 --
238 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
239 --
240 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
241 --
242 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
243 --
244 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
245 --
246 msg := HR_BPL_MESSAGE.get;
247 --
248 RETURN(msg);
249 END GET_MESSAGE_LNG_BG;
250
251 /*----------------------------------------------------*/
252 /* Business Group Version overloaded version with 4 */
253 /* tokens */
254 /*----------------------------------------------------*/
255
256 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
257 ,p_token1 in varchar2
258 ,p_token2 in varchar2
259 ,p_token3 in varchar2
260 ,p_token4 in varchar2
261 ,p_business_group in number)
262 RETURN VARCHAR2 IS
263 --
264 BEGIN
265 --
266 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
267 --
268 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
269 --
270 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
271 --
272 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
273 --
274 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
275 --
276 msg := HR_BPL_MESSAGE.get;
277 --
278 RETURN(msg);
279 END GET_MESSAGE_LNG_BG;
280
281 /*----------------------------------------------------*/
282 /* Business Group Version overloaded version with 3 */
283 /* tokens */
284 /*----------------------------------------------------*/
285
286 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
287 ,p_token1 in varchar2
288 ,p_token2 in varchar2
289 ,p_token3 in varchar2
290 ,p_business_group in number)
291 RETURN VARCHAR2 IS
292 --
293 BEGIN
294 --
295 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
296 --
297 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
298 --
299 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
300 --
301 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
302 --
303 msg := HR_BPL_MESSAGE.get;
304 --
305 RETURN(msg);
306 END GET_MESSAGE_LNG_BG;
307
308 /*----------------------------------------------------*/
309 /* Business Group Version overloaded version with 2 */
310 /* tokens */
311 /*----------------------------------------------------*/
312
313 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
314 ,p_token1 in varchar2
315 ,p_token2 in varchar2
316 ,p_business_group in number)
317 RETURN VARCHAR2 IS
318 --
319 BEGIN
320 --
321 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
322 --
323 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
324 --
325 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
326 --
327 msg := HR_BPL_MESSAGE.get;
328 --
329 RETURN(msg);
330 END GET_MESSAGE_LNG_BG;
331
332 /*----------------------------------------------------*/
333 /* Business Group Version overloaded version with 1 */
334 /* token */
335 /*----------------------------------------------------*/
336
337 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
338 ,p_token1 in varchar2
339 ,p_business_group in number)
340 RETURN VARCHAR2 IS
341 --
342 BEGIN
343 --
344 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
345 --
346 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
347 --
348 msg := HR_BPL_MESSAGE.get;
349 --
350 RETURN(msg);
351 END GET_MESSAGE_LNG_BG;
352
353 /*----------------------------------------------------*/
354 /* Business Group Version 0 tokens */
355 /* */
356 /*----------------------------------------------------*/
357
358 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
359 ,p_business_group in number)
360 RETURN VARCHAR2 IS
361 --
362 BEGIN
363 --
364 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_business_group);
365 --
366 msg := HR_BPL_MESSAGE.get;
367 --
368 RETURN(msg);
369 END GET_MESSAGE_LNG_BG;
370
371 /*----------------------------------------------------*/
372 /* Supervisor Version
373 /* 12 TOKENS
374 /*----------------------------------------------------*/
375 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
376 ,p_token1 in varchar2
377 ,p_token2 in varchar2
378 ,p_token3 in varchar2
379 ,p_token4 in varchar2
380 ,p_token5 in varchar2
381 ,p_token6 in varchar2
382 ,p_token7 in varchar2
383 ,p_token8 in varchar2
384 ,p_token9 in varchar2
385 ,p_tokenA in varchar2
386 ,p_tokenB in varchar2
387 ,p_tokenC in varchar2
388 ,p_assignment_id in number)
389 RETURN VARCHAR2 IS
390 --
391 BEGIN
392 --
393 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
394 --
395 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
396 --
397 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
398 --
399 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
400 --
401 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
402 --
403 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
404 --
405 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
406 --
407 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
408 --
409 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
410 --
411 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
412 --
413 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
414 --
415 HR_BPL_MESSAGE.set_token('TOKENB',p_tokenB);
416 --
417 HR_BPL_MESSAGE.set_token('TOKENC',p_tokenC);
418 --
419 msg := HR_BPL_MESSAGE.get;
420 --
421 RETURN (msg);
422 --
423 END GET_MESSAGE_LNG_SUP;
424
425 /*----------------------------------------------------*/
426 /* Supervisor Version
427 /* 11 TOKENS
431 ,p_token2 in varchar2
428 /*----------------------------------------------------*/
429 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
430 ,p_token1 in varchar2
432 ,p_token3 in varchar2
433 ,p_token4 in varchar2
434 ,p_token5 in varchar2
435 ,p_token6 in varchar2
436 ,p_token7 in varchar2
437 ,p_token8 in varchar2
438 ,p_token9 in varchar2
439 ,p_tokenA in varchar2
440 ,p_tokenB in varchar2
441 ,p_assignment_id in number)
442 RETURN VARCHAR2 IS
443 --
444 BEGIN
445 --
446 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
447 --
448 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
449 --
450 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
451 --
452 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
453 --
454 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
455 --
456 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
457 --
458 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
459 --
460 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
461 --
462 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
463 --
464 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
465 --
466 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
467 --
468 HR_BPL_MESSAGE.set_token('TOKENB',p_tokenB);
469 --
470 msg := HR_BPL_MESSAGE.get;
471 --
472 RETURN (msg);
473 --
474 END GET_MESSAGE_LNG_SUP;
475
476 /*----------------------------------------------------*/
477 /* Supervisor Version
478 /* 10 TOKENS
479 /*----------------------------------------------------*/
480 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
481 ,p_token1 in varchar2
482 ,p_token2 in varchar2
483 ,p_token3 in varchar2
484 ,p_token4 in varchar2
485 ,p_token5 in varchar2
486 ,p_token6 in varchar2
487 ,p_token7 in varchar2
488 ,p_token8 in varchar2
489 ,p_token9 in varchar2
490 ,p_tokenA in varchar2
491 ,p_assignment_id in number)
492 RETURN VARCHAR2 IS
493 --
494 BEGIN
495 --
496 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
497 --
498 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
499 --
500 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
501 --
502 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
503 --
504 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
505 --
506 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
507 --
508 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
509 --
510 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
511 --
512 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
513 --
514 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
515 --
516 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
517 --
518 msg := HR_BPL_MESSAGE.get;
519 --
520 RETURN (msg);
521 --
522 END GET_MESSAGE_LNG_SUP;
523
524 /*----------------------------------------------------*/
525 /* Supervisor Version overloaded version with 9 tokens
526 /*
527 /*----------------------------------------------------*/
528
529 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
530 ,p_token1 in varchar2
531 ,p_token2 in varchar2
532 ,p_token3 in varchar2
533 ,p_token4 in varchar2
534 ,p_token5 in varchar2
535 ,p_token6 in varchar2
536 ,p_token7 in varchar2
537 ,p_token8 in varchar2
538 ,p_token9 in varchar2
539 ,p_assignment_id in number)
540 RETURN VARCHAR2 IS
541 --
542 BEGIN
543 --
544 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
545 --
546 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
547 --
548 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
549 --
550 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
551 --
552 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
553 --
554 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
555 --
556 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
557 --
558 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
559 --
560 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
561 --
562 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
563 --
564 msg := HR_BPL_MESSAGE.get;
565 --
566 RETURN (msg);
567 --
568 END GET_MESSAGE_LNG_SUP;
569
570 /*----------------------------------------------------*/
571 /* Supervisor Version overloaded version with 8 tokens
572 /*
573 /*----------------------------------------------------*/
574
575 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
576 ,p_token1 in varchar2
577 ,p_token2 in varchar2
578 ,p_token3 in varchar2
579 ,p_token4 in varchar2
580 ,p_token5 in varchar2
581 ,p_token6 in varchar2
582 ,p_token7 in varchar2
583 ,p_token8 in varchar2
584 ,p_assignment_id in number)
585 RETURN VARCHAR2 IS
586 --
587 BEGIN
588 --
589 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
590 --
591 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
592 --
593 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
594 --
595 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
596 --
597 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
598 --
599 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
600 --
601 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
602 --
603 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
604 --
605 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
606 --
607 msg := HR_BPL_MESSAGE.get;
608 --
609 RETURN (msg);
610 --
611 END GET_MESSAGE_LNG_SUP;
612
613 /*----------------------------------------------------*/
614 /* Supervisor Version overloaded version with 7 tokens
615 /*
616 /*----------------------------------------------------*/
617
618 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
619 ,p_token1 in varchar2
620 ,p_token2 in varchar2
621 ,p_token3 in varchar2
622 ,p_token4 in varchar2
623 ,p_token5 in varchar2
624 ,p_token6 in varchar2
625 ,p_token7 in varchar2
626 ,p_assignment_id in number)
627 RETURN VARCHAR2 IS
628 --
629 BEGIN
630 --
631 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
632 --
633 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
634 --
635 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
636 --
637 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
638 --
639 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
640 --
641 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
642 --
643 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
644 --
645 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
646 --
647 msg := HR_BPL_MESSAGE.get;
648 --
649 RETURN (msg);
650 --
651 END GET_MESSAGE_LNG_SUP;
652
653 /*----------------------------------------------------*/
654 /* Supervisor Version overloaded version with 6 tokens
655 /*
659 ,p_token1 in varchar2
656 /*----------------------------------------------------*/
657
658 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
660 ,p_token2 in varchar2
661 ,p_token3 in varchar2
662 ,p_token4 in varchar2
663 ,p_token5 in varchar2
664 ,p_token6 in varchar2
665 ,p_assignment_id in number)
666 RETURN VARCHAR2 IS
667 --
668 BEGIN
669 --
670 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
671 --
672 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
673 --
674 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
675 --
676 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
677 --
678 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
679 --
680 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
681 --
682 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
683 --
684 msg := HR_BPL_MESSAGE.get;
685 --
686 RETURN (msg);
687 --
688 END GET_MESSAGE_LNG_SUP;
689
690 /*----------------------------------------------------*/
691 /* Supervisor Version overloaded version with 5 tokens
692 /*
693 /*----------------------------------------------------*/
694
695 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
696 ,p_token1 in varchar2
697 ,p_token2 in varchar2
698 ,p_token3 in varchar2
699 ,p_token4 in varchar2
700 ,p_token5 in varchar2
701 ,p_assignment_id in number)
702 RETURN VARCHAR2 IS
703 --
704 BEGIN
705 --
706 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
707 --
708 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
709 --
710 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
711 --
712 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
713 --
714 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
715 --
716 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
717 --
718 msg := HR_BPL_MESSAGE.get;
719 --
720 RETURN (msg);
721 --
722 END GET_MESSAGE_LNG_SUP;
723
724 /*----------------------------------------------------*/
725 /* Supervisor Version overloaded version with 4 tokens
726 /*
727 /*----------------------------------------------------*/
728
729 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
730 ,p_token1 in varchar2
731 ,p_token2 in varchar2
732 ,p_token3 in varchar2
733 ,p_token4 in varchar2
734 ,p_assignment_id in number)
735 RETURN VARCHAR2 IS
736 --
737 BEGIN
738 --
739 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
740 --
741 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
742 --
743 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
744 --
745 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
746 --
747 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
748 --
749 msg := HR_BPL_MESSAGE.get;
750 --
751 RETURN (msg);
752 --
753 END GET_MESSAGE_LNG_SUP;
754
755 /*----------------------------------------------------*/
756 /* Supervisor Version overloaded version with 3 tokens
757 /*
758 /*----------------------------------------------------*/
759
760 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
761 ,p_token1 in varchar2
762 ,p_token2 in varchar2
763 ,p_token3 in varchar2
764 ,p_assignment_id in number)
765 RETURN VARCHAR2 IS
766 --
767 BEGIN
768 --
769 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
770 --
771 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
772 --
773 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
774 --
775 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
776 --
777 msg := HR_BPL_MESSAGE.get;
778 --
779 RETURN (msg);
780 --
781 END GET_MESSAGE_LNG_SUP;
782
783 /*----------------------------------------------------*/
784 /* Supervisor Version overloaded version with 2 tokens
785 /*
786 /*----------------------------------------------------*/
787
788 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
789 ,p_token1 in varchar2
790 ,p_token2 in varchar2
791 ,p_assignment_id in number)
792 RETURN VARCHAR2 IS
793 --
794 BEGIN
795 --
796 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
797 --
798 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
799 --
800 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
801 --
802 msg := HR_BPL_MESSAGE.get;
803 --
804 RETURN (msg);
805 --
806 END GET_MESSAGE_LNG_SUP;
807
808 /*----------------------------------------------------*/
809 /* Supervisor Version overloaded version with 1 token
810 /*
811 /*----------------------------------------------------*/
812
813 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
814 ,p_token1 in varchar2
815 ,p_assignment_id in number)
816 RETURN VARCHAR2 IS
817 --
818 BEGIN
819 --
820 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
821 --
825 --
822 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
823 --
824 msg := HR_BPL_MESSAGE.get;
826 RETURN (msg);
827 --
828 END GET_MESSAGE_LNG_SUP;
829
830 /*----------------------------------------------------*/
831 /* Supervisor Version overloaded version with 0 tokens
832 /*
833 /*----------------------------------------------------*/
834
835 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
836 ,p_assignment_id in number)
837 RETURN VARCHAR2 IS
838 --
839 BEGIN
840 --
841 HR_BPL_MESSAGE.SET_NAME_SUP('PER',p_message,p_assignment_id);
842 --
843 msg := HR_BPL_MESSAGE.get;
844 --
845 RETURN (msg);
846 --
847 END GET_MESSAGE_LNG_SUP;
848
849 /*----------------------------------------------------*/
850 /* Primary Supervisor Version
851 /*
852 /*----------------------------------------------------*/
853
854 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
855 ,p_token1 in varchar2
856 ,p_token2 in varchar2
857 ,p_token3 in varchar2
858 ,p_token4 in varchar2
859 ,p_token5 in varchar2
860 ,p_token6 in varchar2
861 ,p_token7 in varchar2
862 ,p_token8 in varchar2
863 ,p_token9 in varchar2
864 ,p_tokenA in varchar2
865 ,p_tokenB in varchar2
866 ,p_tokenC in varchar2
867 ,p_assignment_id in number)
868 RETURN VARCHAR2 IS
869 --
870 BEGIN
871 --
872 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
873 --
874 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
875 --
876 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
877 --
878 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
879 --
880 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
881 --
882 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
883 --
884 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
885 --
886 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
887 --
888 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
889 --
890 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
891 --
892 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
893 --
894 HR_BPL_MESSAGE.set_token('TOKENB',p_tokenB);
895 --
896 HR_BPL_MESSAGE.set_token('TOKENC',p_tokenC);
897 --
898 msg := HR_BPL_MESSAGE.get;
899 --
900 RETURN (msg);
901 --
902 END GET_MESSAGE_LNG_PSUP;
903
904 /*----------------------------------------------------*/
905 /* Primary Supervisor Version
906 /*
907 /*----------------------------------------------------*/
908
909 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
910 ,p_token1 in varchar2
911 ,p_token2 in varchar2
912 ,p_token3 in varchar2
913 ,p_token4 in varchar2
914 ,p_token5 in varchar2
915 ,p_token6 in varchar2
916 ,p_token7 in varchar2
920 ,p_tokenB in varchar2
917 ,p_token8 in varchar2
918 ,p_token9 in varchar2
919 ,p_tokenA in varchar2
921 ,p_assignment_id in number)
922 RETURN VARCHAR2 IS
923 --
924 BEGIN
925 --
926 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
927 --
928 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
929 --
930 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
931 --
932 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
933 --
934 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
935 --
936 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
937 --
938 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
939 --
940 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
941 --
942 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
943 --
944 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
945 --
946 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
947 --
948 HR_BPL_MESSAGE.set_token('TOKENB',p_tokenB);
949 --
950 msg := HR_BPL_MESSAGE.get;
951 --
952 RETURN (msg);
953 --
954 END GET_MESSAGE_LNG_PSUP;
955
956 /*----------------------------------------------------*/
957 /* Primary Supervisor Version
958 /* TEN TOKENS
959 /*----------------------------------------------------*/
960
961 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
962 ,p_token1 in varchar2
963 ,p_token2 in varchar2
964 ,p_token3 in varchar2
965 ,p_token4 in varchar2
966 ,p_token5 in varchar2
967 ,p_token6 in varchar2
968 ,p_token7 in varchar2
969 ,p_token8 in varchar2
970 ,p_token9 in varchar2
971 ,p_tokenA in varchar2
972 ,p_assignment_id in number)
973 RETURN VARCHAR2 IS
974 --
975 BEGIN
976 --
977 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
978 --
979 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
980 --
981 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
982 --
983 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
984 --
985 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
986 --
987 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
988 --
989 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
990 --
991 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
992 --
993 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
994 --
995 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
996 --
1000 --
997 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
998 --
999 msg := HR_BPL_MESSAGE.get;
1001 RETURN (msg);
1002 --
1003 END GET_MESSAGE_LNG_PSUP;
1004
1005 /*----------------------------------------------------*/
1006 /* Primary Supervisor Version overloaded with 9 tokens
1007 /*
1008 /*----------------------------------------------------*/
1009
1010 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1011 ,p_token1 in varchar2
1012 ,p_token2 in varchar2
1013 ,p_token3 in varchar2
1014 ,p_token4 in varchar2
1015 ,p_token5 in varchar2
1016 ,p_token6 in varchar2
1017 ,p_token7 in varchar2
1018 ,p_token8 in varchar2
1019 ,p_token9 in varchar2
1020 ,p_assignment_id in number)
1021 RETURN VARCHAR2 IS
1022 --
1023 BEGIN
1024 --
1025 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1026 --
1027 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1028 --
1029 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1030 --
1031 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1032 --
1033 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1034 --
1035 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1036 --
1037 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1038 --
1039 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1040 --
1041 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1042 --
1043 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
1044 --
1045 msg := HR_BPL_MESSAGE.get;
1046 --
1047 RETURN (msg);
1048 --
1049 END GET_MESSAGE_LNG_PSUP;
1050
1051 /*----------------------------------------------------*/
1052 /* Primary Supervisor Version overloaded with 8 tokens
1053 /*
1054 /*----------------------------------------------------*/
1055
1056 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1057 ,p_token1 in varchar2
1058 ,p_token2 in varchar2
1059 ,p_token3 in varchar2
1060 ,p_token4 in varchar2
1061 ,p_token5 in varchar2
1062 ,p_token6 in varchar2
1063 ,p_token7 in varchar2
1064 ,p_token8 in varchar2
1065 ,p_assignment_id in number)
1066 RETURN VARCHAR2 IS
1067 --
1068 BEGIN
1069 --
1070 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1071 --
1072 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1076 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1073 --
1074 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1075 --
1077 --
1078 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1079 --
1080 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1081 --
1082 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1083 --
1084 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1085 --
1086 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1087 --
1088 msg := HR_BPL_MESSAGE.get;
1089 --
1090 RETURN (msg);
1091 --
1092 END GET_MESSAGE_LNG_PSUP;
1093
1094 /*----------------------------------------------------*/
1095 /* Primary Supervisor Version overloaded with 7 tokens
1096 /*
1097 /*----------------------------------------------------*/
1098
1099 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1100 ,p_token1 in varchar2
1101 ,p_token2 in varchar2
1102 ,p_token3 in varchar2
1103 ,p_token4 in varchar2
1104 ,p_token5 in varchar2
1105 ,p_token6 in varchar2
1106 ,p_token7 in varchar2
1107 ,p_assignment_id in number)
1108 RETURN VARCHAR2 IS
1109 --
1110 BEGIN
1111 --
1112 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1113 --
1114 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1115 --
1116 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1117 --
1118 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1119 --
1120 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1121 --
1122 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1123 --
1124 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1125 --
1126 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1127 --
1128 msg := HR_BPL_MESSAGE.get;
1129 --
1130 RETURN (msg);
1131 --
1132 END GET_MESSAGE_LNG_PSUP;
1133
1134 /*----------------------------------------------------*/
1135 /* Primary Supervisor Version overloaded with 6 tokens
1136 /*
1137 /*----------------------------------------------------*/
1138
1139 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1140 ,p_token1 in varchar2
1141 ,p_token2 in varchar2
1142 ,p_token3 in varchar2
1143 ,p_token4 in varchar2
1144 ,p_token5 in varchar2
1145 ,p_token6 in varchar2
1146 ,p_assignment_id in number)
1147 RETURN VARCHAR2 IS
1148 --
1149 BEGIN
1150 --
1151 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1152 --
1153 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1154 --
1155 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1156 --
1157 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1158 --
1159 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1160 --
1161 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1162 --
1163 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1164 --
1165 msg := HR_BPL_MESSAGE.get;
1166 --
1167 RETURN (msg);
1168 --
1169 END GET_MESSAGE_LNG_PSUP;
1170
1174 /*----------------------------------------------------*/
1171 /*----------------------------------------------------*/
1172 /* Primary Supervisor Version overloaded with 5 tokens
1173 /*
1175
1176 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1177 ,p_token1 in varchar2
1178 ,p_token2 in varchar2
1179 ,p_token3 in varchar2
1180 ,p_token4 in varchar2
1181 ,p_token5 in varchar2
1182 ,p_assignment_id in number)
1183 RETURN VARCHAR2 IS
1184 --
1185 BEGIN
1186 --
1187 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1188 --
1189 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1190 --
1191 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1192 --
1193 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1194 --
1195 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1196 --
1197 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1198 --
1199 msg := HR_BPL_MESSAGE.get;
1200 --
1201 RETURN (msg);
1202 --
1203 END GET_MESSAGE_LNG_PSUP;
1204
1205
1206 /*----------------------------------------------------*/
1207 /* Primary Supervisor Version overloaded with 4 tokens
1208 /*
1209 /*----------------------------------------------------*/
1210
1211 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1212 ,p_token1 in varchar2
1213 ,p_token2 in varchar2
1214 ,p_token3 in varchar2
1215 ,p_token4 in varchar2
1216 ,p_assignment_id in number)
1217 RETURN VARCHAR2 IS
1218 --
1219 BEGIN
1220 --
1221 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1222 --
1223 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1224 --
1225 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1226 --
1227 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1228 --
1229 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1230 --
1231 msg := HR_BPL_MESSAGE.get;
1232 --
1233 RETURN (msg);
1234 --
1235 END GET_MESSAGE_LNG_PSUP;
1236
1237 /*----------------------------------------------------*/
1238 /* Primary Supervisor Version overloaded with 3 tokens
1239 /*
1240 /*----------------------------------------------------*/
1241
1242 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1243 ,p_token1 in varchar2
1244 ,p_token2 in varchar2
1245 ,p_token3 in varchar2
1246 ,p_assignment_id in number)
1247 RETURN VARCHAR2 IS
1248 --
1249 BEGIN
1250 --
1254 --
1251 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1252 --
1253 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1255 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1256 --
1257 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1258 --
1259 msg := HR_BPL_MESSAGE.get;
1260 --
1261 RETURN (msg);
1262 --
1263 END GET_MESSAGE_LNG_PSUP;
1264
1265 /*----------------------------------------------------*/
1266 /* Primary Supervisor Version overloaded with 2 tokens
1267 /*
1268 /*----------------------------------------------------*/
1269
1270 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1271 ,p_token1 in varchar2
1272 ,p_token2 in varchar2
1273 ,p_assignment_id in number)
1274 RETURN VARCHAR2 IS
1275 --
1276 BEGIN
1277 --
1278 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1279 --
1280 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1281 --
1282 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1283 --
1284 msg := HR_BPL_MESSAGE.get;
1285 --
1286 RETURN (msg);
1287 --
1288 END GET_MESSAGE_LNG_PSUP;
1289
1290 /*----------------------------------------------------*/
1291 /* Primary Supervisor Version overloaded with 1 token
1292 /*
1293 /*----------------------------------------------------*/
1294
1295 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1296 ,p_token1 in varchar2
1297 ,p_assignment_id in number)
1298 RETURN VARCHAR2 IS
1299 --
1300 BEGIN
1301 --
1302 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1303 --
1304 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1305 --
1306 msg := HR_BPL_MESSAGE.get;
1307 --
1308 RETURN (msg);
1309 --
1310 END GET_MESSAGE_LNG_PSUP;
1311
1312 /*----------------------------------------------------*/
1313 /* Primary Supervisor Version overloaded with 0 tokens
1314 /*
1315 /*----------------------------------------------------*/
1316
1317 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
1318 ,p_assignment_id in number)
1319 RETURN VARCHAR2 IS
1320 --
1321 BEGIN
1322 --
1323 HR_BPL_MESSAGE.SET_NAME_PSUP('PER',p_message,p_assignment_id);
1324 --
1325 msg := HR_BPL_MESSAGE.get;
1326 --
1327 RETURN (msg);
1328 --
1329 END GET_MESSAGE_LNG_PSUP;
1330
1331
1332 /*----------------------------------------------------*/
1333 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
1334 /* ELEVEN TOKENS */
1335 /*----------------------------------------------------*/
1336
1337 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1338 ,p_token1 in varchar2
1339 ,p_token2 in varchar2
1340 ,p_token3 in varchar2
1341 ,p_token4 in varchar2
1342 ,p_token5 in varchar2
1343 ,p_token6 in varchar2
1344 ,p_token7 in varchar2
1345 ,p_token8 in varchar2
1346 ,p_token9 in varchar2
1347 ,p_tokenA in varchar2
1348 ,p_tokenB in varchar2
1349 ,p_tokenC in varchar2
1350 ,p_person_id in number)
1351 RETURN VARCHAR2 IS
1352 --
1353 BEGIN
1354 --
1355 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1356 --
1357 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1358 --
1359 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1360 --
1361 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1362 --
1363 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1364 --
1365 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1366 --
1367 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1368 --
1369 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1370 --
1371 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1372 --
1373 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
1374 --
1375 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
1376 --
1377 HR_BPL_MESSAGE.set_token('TOKENB',p_tokenB);
1378 --
1379 HR_BPL_MESSAGE.set_token('TOKENC',p_tokenC);
1380 --
1381
1382 msg := HR_BPL_MESSAGE.get;
1383 --
1384 RETURN (msg);
1385 --
1386 END get_message_lng_psn;
1387
1388
1389
1390 /*----------------------------------------------------*/
1391 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
1392 /* ELEVEN TOKENS */
1393 /*----------------------------------------------------*/
1394
1395 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1396 ,p_token1 in varchar2
1397 ,p_token2 in varchar2
1398 ,p_token3 in varchar2
1399 ,p_token4 in varchar2
1400 ,p_token5 in varchar2
1401 ,p_token6 in varchar2
1402 ,p_token7 in varchar2
1403 ,p_token8 in varchar2
1404 ,p_token9 in varchar2
1408 RETURN VARCHAR2 IS
1405 ,p_tokenA in varchar2
1406 ,p_tokenB in varchar2
1407 ,p_person_id in number)
1409 --
1410 BEGIN
1411 --
1412 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1413 --
1414 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1415 --
1416 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1417 --
1418 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1419 --
1420 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1421 --
1422 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1423 --
1424 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1425 --
1426 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1427 --
1428 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1429 --
1430 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
1431 --
1432 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
1433 --
1434 HR_BPL_MESSAGE.set_token('TOKENB',p_tokenB);
1435 --
1436 msg := HR_BPL_MESSAGE.get;
1437 --
1438 RETURN (msg);
1439 --
1440 END get_message_lng_psn;
1441
1442
1443 /*----------------------------------------------------*/
1444 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
1445 /* TEN TOKENS */
1446 /*----------------------------------------------------*/
1447
1448 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1449 ,p_token1 in varchar2
1450 ,p_token2 in varchar2
1451 ,p_token3 in varchar2
1452 ,p_token4 in varchar2
1453 ,p_token5 in varchar2
1454 ,p_token6 in varchar2
1455 ,p_token7 in varchar2
1456 ,p_token8 in varchar2
1457 ,p_token9 in varchar2
1458 ,p_tokenA in varchar2
1459 ,p_person_id in number)
1460 RETURN VARCHAR2 IS
1461 --
1462 BEGIN
1463 --
1464 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1465 --
1466 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1467 --
1468 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1469 --
1470 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1471 --
1472 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1473 --
1474 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1475 --
1476 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1477 --
1478 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1479 --
1480 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1481 --
1482 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
1483 --
1484 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
1485 --
1486 msg := HR_BPL_MESSAGE.get;
1487 --
1488 RETURN (msg);
1489 --
1490 END get_message_lng_psn;
1491
1492 /*----------------------------------------------------*/
1493 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
1494 /* NINE TOKENS */
1495 /*----------------------------------------------------*/
1496
1497 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1498 ,p_token1 in varchar2
1499 ,p_token2 in varchar2
1500 ,p_token3 in varchar2
1501 ,p_token4 in varchar2
1502 ,p_token5 in varchar2
1503 ,p_token6 in varchar2
1504 ,p_token7 in varchar2
1505 ,p_token8 in varchar2
1506 ,p_token9 in varchar2
1507 ,p_person_id in number)
1508 RETURN VARCHAR2 IS
1509 --
1510 BEGIN
1511 --
1512 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1513 --
1514 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1515 --
1516 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1517 --
1518 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1519 --
1520 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1521 --
1522 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1523 --
1524 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1525 --
1526 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1527 --
1528 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1529 --
1530 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
1531 --
1532 msg := HR_BPL_MESSAGE.get;
1533 --
1534 RETURN (msg);
1535 --
1539 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1536 END get_message_lng_psn;
1537
1538 /*----------------------------------------------------*/
1540 /* 8 TOKENS */
1541 /*----------------------------------------------------*/
1542
1543 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1544 ,p_token1 in varchar2
1545 ,p_token2 in varchar2
1546 ,p_token3 in varchar2
1547 ,p_token4 in varchar2
1548 ,p_token5 in varchar2
1549 ,p_token6 in varchar2
1550 ,p_token7 in varchar2
1551 ,p_token8 in varchar2
1552 ,p_person_id in number)
1553 RETURN VARCHAR2 IS
1554 --
1555 BEGIN
1556 --
1557 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1558 --
1559 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1560 --
1561 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1562 --
1563 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1564 --
1565 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1566 --
1567 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1568 --
1569 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1570 --
1571 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1572 --
1573 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1574 --
1575 msg := HR_BPL_MESSAGE.get;
1576 --
1577 RETURN (msg);
1578 --
1579 END get_message_lng_psn;
1580
1581 /*----------------------------------------------------*/
1582 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1583 /* 7 TOKENS */
1584 /*----------------------------------------------------*/
1585
1586 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1587 ,p_token1 in varchar2
1588 ,p_token2 in varchar2
1589 ,p_token3 in varchar2
1590 ,p_token4 in varchar2
1591 ,p_token5 in varchar2
1592 ,p_token6 in varchar2
1593 ,p_token7 in varchar2
1594 ,p_person_id in number)
1595 RETURN VARCHAR2 IS
1596 --
1597 BEGIN
1598 --
1599 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1600 --
1601 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1602 --
1603 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1604 --
1605 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1606 --
1607 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1608 --
1609 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1610 --
1611 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1612 --
1613 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1614 --
1615 msg := HR_BPL_MESSAGE.get;
1616 --
1617 RETURN (msg);
1618 --
1619 END get_message_lng_psn;
1620
1621 /*----------------------------------------------------*/
1622 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1623 /* 6 TOKENS */
1624 /*----------------------------------------------------*/
1625
1626 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1627 ,p_token1 in varchar2
1628 ,p_token2 in varchar2
1629 ,p_token3 in varchar2
1630 ,p_token4 in varchar2
1631 ,p_token5 in varchar2
1632 ,p_token6 in varchar2
1633 ,p_person_id in number)
1634 RETURN VARCHAR2 IS
1635 --
1636 BEGIN
1637 --
1638 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1639 --
1640 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1641 --
1642 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1643 --
1644 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1645 --
1646 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1647 --
1648 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1649 --
1650 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1651 --
1652 msg := HR_BPL_MESSAGE.get;
1653 --
1654 RETURN (msg);
1655 --
1656 END get_message_lng_psn;
1657
1658 /*----------------------------------------------------*/
1659 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1660 /* 5 TOKENS */
1661 /*----------------------------------------------------*/
1662
1663 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1664 ,p_token1 in varchar2
1665 ,p_token2 in varchar2
1666 ,p_token3 in varchar2
1667 ,p_token4 in varchar2
1668 ,p_token5 in varchar2
1669 ,p_person_id in number)
1670 RETURN VARCHAR2 IS
1671 --
1672 BEGIN
1673 --
1674 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1675 --
1676 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1677 --
1678 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1679 --
1680 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1681 --
1682 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1683 --
1684 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1685 --
1686 msg := HR_BPL_MESSAGE.get;
1687 --
1688 RETURN (msg);
1689 --
1693 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1690 END get_message_lng_psn;
1691
1692 /*----------------------------------------------------*/
1694 /* 4 TOKENS */
1695 /*----------------------------------------------------*/
1696
1697 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1698 ,p_token1 in varchar2
1699 ,p_token2 in varchar2
1700 ,p_token3 in varchar2
1701 ,p_token4 in varchar2
1702 ,p_person_id in number)
1703 RETURN VARCHAR2 IS
1704 --
1705 BEGIN
1706 --
1707 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1708 --
1709 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1710 --
1711 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1712 --
1713 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1714 --
1715 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1716 --
1717 msg := HR_BPL_MESSAGE.get;
1718 --
1719 RETURN (msg);
1720 --
1721 END get_message_lng_psn;
1722
1723 /*----------------------------------------------------*/
1724 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1725 /* 3 TOKENS */
1726 /*----------------------------------------------------*/
1727
1728 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1729 ,p_token1 in varchar2
1730 ,p_token2 in varchar2
1731 ,p_token3 in varchar2
1732 ,p_person_id in number)
1733 RETURN VARCHAR2 IS
1734 --
1735 BEGIN
1736 --
1737 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1738 --
1739 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1740 --
1741 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1742 --
1743 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1744 --
1745 msg := HR_BPL_MESSAGE.get;
1746 --
1747 RETURN (msg);
1748 --
1749 END get_message_lng_psn;
1750
1751 /*----------------------------------------------------*/
1752 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1753 /* 2 TOKENS */
1754 /*----------------------------------------------------*/
1755
1756 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1757 ,p_token1 in varchar2
1758 ,p_token2 in varchar2
1759 ,p_person_id in number)
1760 RETURN VARCHAR2 IS
1761 --
1762 BEGIN
1763 --
1764 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1765 --
1766 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1767 --
1768 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1769 --
1770 msg := HR_BPL_MESSAGE.get;
1771 --
1772 RETURN (msg);
1773 --
1774 END get_message_lng_psn;
1775
1776 /*----------------------------------------------------*/
1777 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1778 /* 1 TOKENS */
1779 /*----------------------------------------------------*/
1780
1781 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1782 ,p_token1 in varchar2
1783 ,p_person_id in number)
1784 RETURN VARCHAR2 IS
1785 --
1786 BEGIN
1787 --
1788 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1789 --
1790 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1791 --
1792 msg := HR_BPL_MESSAGE.get;
1793 --
1794 RETURN (msg);
1795 --
1796 END get_message_lng_psn;
1797
1798 /*----------------------------------------------------*/
1799 /* Overloaded Version of GET_MESSAGE_LNG_PSN with */
1800 /* 0 TOKENS */
1801 /*----------------------------------------------------*/
1802
1803 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
1804 ,p_person_id in number)
1805 RETURN VARCHAR2 IS
1806 --
1807 BEGIN
1808 --
1809 HR_BPL_MESSAGE.SET_NAME_PSN('PER',p_message,p_person_id);
1810 --
1811 msg := HR_BPL_MESSAGE.get;
1812 --
1813 RETURN (msg);
1814 --
1815 END get_message_lng_psn;
1816 --
1817
1818
1819 /*----------------------------------------------------*/
1820 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN */
1821 /* ELEVEN TOKENS */
1822 /*----------------------------------------------------*/
1823
1824 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
1825 ,p_token1 in varchar2
1826 ,p_token2 in varchar2
1827 ,p_token3 in varchar2
1828 ,p_token4 in varchar2
1829 ,p_token5 in varchar2
1830 ,p_token6 in varchar2
1831 ,p_token7 in varchar2
1832 ,p_token8 in varchar2
1833 ,p_token9 in varchar2
1834 ,p_tokenA in varchar2
1835 ,p_tokenB in varchar2
1836 ,p_person_id in number)
1837 RETURN VARCHAR2 IS
1838 --
1839 BEGIN
1840 --
1841 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
1842 --
1843 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1844 --
1845 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1846 --
1847 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1848 --
1852 --
1849 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1850 --
1851 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1853 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1854 --
1855 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1856 --
1857 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1858 --
1859 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
1860 --
1861 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
1862 --
1863 HR_BPL_MESSAGE.set_token('TOKENB',p_tokenB);
1864 --
1865 msg := HR_BPL_MESSAGE.get;
1866 --
1867 RETURN (msg);
1868 --
1869 END get_message_lng_sup_psn;
1870
1871
1872 /*----------------------------------------------------*/
1873 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN */
1874 /* TEN TOKENS */
1875 /*----------------------------------------------------*/
1876
1877 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
1878 ,p_token1 in varchar2
1879 ,p_token2 in varchar2
1880 ,p_token3 in varchar2
1881 ,p_token4 in varchar2
1882 ,p_token5 in varchar2
1883 ,p_token6 in varchar2
1884 ,p_token7 in varchar2
1885 ,p_token8 in varchar2
1886 ,p_token9 in varchar2
1887 ,p_tokenA in varchar2
1888 ,p_person_id in number)
1889 RETURN VARCHAR2 IS
1890 --
1891 BEGIN
1892 --
1893 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
1894 --
1895 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1896 --
1897 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1898 --
1899 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1900 --
1901 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1902 --
1903 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1904 --
1905 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1906 --
1907 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1908 --
1909 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1910 --
1911 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
1912 --
1913 HR_BPL_MESSAGE.set_token('TOKENA',p_tokenA);
1914 --
1915 msg := HR_BPL_MESSAGE.get;
1916 --
1917 RETURN (msg);
1918 --
1919 END get_message_lng_sup_psn;
1920
1921 /*----------------------------------------------------*/
1922 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN */
1923 /* NINE TOKENS */
1924 /*----------------------------------------------------*/
1925
1926 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
1927 ,p_token1 in varchar2
1928 ,p_token2 in varchar2
1929 ,p_token3 in varchar2
1930 ,p_token4 in varchar2
1931 ,p_token5 in varchar2
1932 ,p_token6 in varchar2
1933 ,p_token7 in varchar2
1934 ,p_token8 in varchar2
1935 ,p_token9 in varchar2
1936 ,p_person_id in number)
1937 RETURN VARCHAR2 IS
1938 --
1939 BEGIN
1940 --
1941 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
1942 --
1943 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1944 --
1945 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1946 --
1947 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1948 --
1949 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1950 --
1951 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1952 --
1953 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1954 --
1955 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
1956 --
1957 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
1958 --
1959 HR_BPL_MESSAGE.set_token('TOKEN9',p_token9);
1960 --
1961 msg := HR_BPL_MESSAGE.get;
1962 --
1963 RETURN (msg);
1964 --
1965 END get_message_lng_sup_psn;
1966
1967 /*----------------------------------------------------*/
1968 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
1969 /* 8 TOKENS */
1970 /*----------------------------------------------------*/
1971
1972 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
1973 ,p_token1 in varchar2
1974 ,p_token2 in varchar2
1975 ,p_token3 in varchar2
1976 ,p_token4 in varchar2
1977 ,p_token5 in varchar2
1978 ,p_token6 in varchar2
1979 ,p_token7 in varchar2
1980 ,p_token8 in varchar2
1981 ,p_person_id in number)
1982 RETURN VARCHAR2 IS
1983 --
1984 BEGIN
1985 --
1986 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
1987 --
1988 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
1989 --
1990 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
1991 --
1992 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
1993 --
1994 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
1995 --
1996 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
1997 --
1998 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
1999 --
2000 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
2001 --
2002 HR_BPL_MESSAGE.set_token('TOKEN8',p_token8);
2003 --
2004 msg := HR_BPL_MESSAGE.get;
2005 --
2009
2006 RETURN (msg);
2007 --
2008 END get_message_lng_sup_psn;
2010 /*----------------------------------------------------*/
2011 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
2012 /* 7 TOKENS */
2013 /*----------------------------------------------------*/
2014
2015 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
2016 ,p_token1 in varchar2
2017 ,p_token2 in varchar2
2018 ,p_token3 in varchar2
2019 ,p_token4 in varchar2
2020 ,p_token5 in varchar2
2021 ,p_token6 in varchar2
2022 ,p_token7 in varchar2
2023 ,p_person_id in number)
2024 RETURN VARCHAR2 IS
2025 --
2026 BEGIN
2027 --
2028 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
2029 --
2030 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
2031 --
2032 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
2033 --
2034 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
2035 --
2036 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
2037 --
2038 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
2039 --
2040 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
2041 --
2042 HR_BPL_MESSAGE.set_token('TOKEN7',p_token7);
2043 --
2044 msg := HR_BPL_MESSAGE.get;
2045 --
2046 RETURN (msg);
2047 --
2048 END get_message_lng_sup_psn;
2049
2050 /*----------------------------------------------------*/
2051 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
2052 /* 6 TOKENS */
2053 /*----------------------------------------------------*/
2054
2055 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
2056 ,p_token1 in varchar2
2057 ,p_token2 in varchar2
2058 ,p_token3 in varchar2
2059 ,p_token4 in varchar2
2060 ,p_token5 in varchar2
2061 ,p_token6 in varchar2
2062 ,p_person_id in number)
2063 RETURN VARCHAR2 IS
2064 --
2065 BEGIN
2066 --
2067 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
2068 --
2069 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
2070 --
2071 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
2072 --
2073 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
2074 --
2075 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
2076 --
2077 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
2078 --
2079 HR_BPL_MESSAGE.set_token('TOKEN6',p_token6);
2080 --
2081 msg := HR_BPL_MESSAGE.get;
2082 --
2083 RETURN (msg);
2084 --
2085 END get_message_lng_sup_psn;
2086
2087 /*----------------------------------------------------*/
2088 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
2089 /* 5 TOKENS */
2090 /*----------------------------------------------------*/
2091
2092 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
2093 ,p_token1 in varchar2
2094 ,p_token2 in varchar2
2095 ,p_token3 in varchar2
2096 ,p_token4 in varchar2
2097 ,p_token5 in varchar2
2098 ,p_person_id in number)
2099 RETURN VARCHAR2 IS
2100 --
2101 BEGIN
2102 --
2103 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
2104 --
2105 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
2106 --
2107 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
2108 --
2109 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
2110 --
2111 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
2112 --
2113 HR_BPL_MESSAGE.set_token('TOKEN5',p_token5);
2114 --
2115 msg := HR_BPL_MESSAGE.get;
2116 --
2117 RETURN (msg);
2118 --
2119 END get_message_lng_sup_psn;
2120
2121 /*----------------------------------------------------*/
2122 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
2123 /* 4 TOKENS */
2124 /*----------------------------------------------------*/
2125
2126 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
2127 ,p_token1 in varchar2
2128 ,p_token2 in varchar2
2129 ,p_token3 in varchar2
2130 ,p_token4 in varchar2
2131 ,p_person_id in number)
2132 RETURN VARCHAR2 IS
2133 --
2134 BEGIN
2135 --
2136 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
2137 --
2138 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
2139 --
2140 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
2141 --
2142 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
2143 --
2144 HR_BPL_MESSAGE.set_token('TOKEN4',p_token4);
2145 --
2146 msg := HR_BPL_MESSAGE.get;
2147 --
2148 RETURN (msg);
2149 --
2150 END get_message_lng_sup_psn;
2151
2152 /*----------------------------------------------------*/
2153 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
2154 /* 3 TOKENS */
2155 /*----------------------------------------------------*/
2156
2157 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
2158 ,p_token1 in varchar2
2159 ,p_token2 in varchar2
2160 ,p_token3 in varchar2
2161 ,p_person_id in number)
2162 RETURN VARCHAR2 IS
2163 --
2164 BEGIN
2165 --
2166 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
2167 --
2168 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
2169 --
2170 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
2171 --
2172 HR_BPL_MESSAGE.set_token('TOKEN3',p_token3);
2173 --
2174 msg := HR_BPL_MESSAGE.get;
2175 --
2176 RETURN (msg);
2177 --
2178 END get_message_lng_sup_psn;
2179
2180 /*----------------------------------------------------*/
2181 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
2182 /* 2 TOKENS */
2183 /*----------------------------------------------------*/
2184
2185 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
2186 ,p_token1 in varchar2
2187 ,p_token2 in varchar2
2188 ,p_person_id in number)
2189 RETURN VARCHAR2 IS
2190 --
2191 BEGIN
2192 --
2193 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
2194 --
2195 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
2196 --
2197 HR_BPL_MESSAGE.set_token('TOKEN2',p_token2);
2198 --
2199 msg := HR_BPL_MESSAGE.get;
2200 --
2201 RETURN (msg);
2202 --
2203 END get_message_lng_sup_psn;
2204
2205 /*----------------------------------------------------*/
2206 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
2207 /* 1 TOKENS */
2208 /*----------------------------------------------------*/
2209
2210 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
2211 ,p_token1 in varchar2
2212 ,p_person_id in number)
2213 RETURN VARCHAR2 IS
2214 --
2215 BEGIN
2216 --
2217 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
2218 --
2219 HR_BPL_MESSAGE.set_token('TOKEN1',p_token1);
2220 --
2221 msg := HR_BPL_MESSAGE.get;
2222 --
2223 RETURN (msg);
2224 --
2225 END get_message_lng_sup_psn;
2226
2227 /*----------------------------------------------------*/
2228 /* Overloaded Version of GET_MESSAGE_LNG_SUP_PSN with */
2229 /* 0 TOKENS */
2230 /*----------------------------------------------------*/
2231
2232 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
2233 ,p_person_id in number)
2234 RETURN VARCHAR2 IS
2235 --
2236 BEGIN
2237 --
2238 HR_BPL_MESSAGE.SET_NAME_PSN_PSUP('PER',p_message,p_person_id);
2239 --
2240 msg := HR_BPL_MESSAGE.get;
2241 --
2242 RETURN (msg);
2243 --
2244 END get_message_lng_sup_psn;
2245 --
2246 END HR_VIEW_ALERT_MESSAGES;