eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CNU_BUS1 dependencies on HR_UTILITY

Line 20: hr_utility.set_location(' Entering '||l_proc, 10);

16: l_proc varchar2(72) := g_package|| ' chk_element_name';
17: --
18: Begin
19: --
20: hr_utility.set_location(' Entering '||l_proc, 10);
21: --
22: hr_api.mandatory_arg_error
23: (p_api_name => l_proc
24: ,p_argument => 'p_element_name'

Line 28: hr_utility.set_location(' Leaving:'||l_proc, 20);

24: ,p_argument => 'p_element_name'
25: ,p_argument_value => p_element_name
26: );
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: end chk_element_name;
30: -- ----------------------------------------------------------------------------
31: -- |---------------------------< chk_contribution_usage_type >----------------|
32: -- ----------------------------------------------------------------------------

Line 42: hr_utility.set_location(' Entering '||l_proc, 10);

38: l_proc varchar2(72) := g_package|| ' chk_contribution_usage_type';
39: --
40: Begin
41: --
42: hr_utility.set_location(' Entering '||l_proc, 10);
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'p_effective_date'

Line 65: hr_utility.set_location(' Leaving:'||l_proc, 20);

61: fnd_message.set_name('PAY', 'PAY_74897_CNU_BAD_USAGE_TYPE');
62: fnd_message.raise_error;
63: end if;
64: --
65: hr_utility.set_location(' Leaving:'||l_proc, 20);
66: end chk_contribution_usage_type;
67: -- ----------------------------------------------------------------------------
68: -- |---------------------------< chk_rate_type >-------------------------------|
69: -- ----------------------------------------------------------------------------

Line 79: hr_utility.set_location(' Entering '||l_proc, 10);

75: l_proc varchar2(72) := g_package|| ' chk_rate_type';
76: --
77: Begin
78: --
79: hr_utility.set_location(' Entering '||l_proc, 10);
80: --
81: hr_api.mandatory_arg_error
82: (p_api_name => l_proc
83: ,p_argument => 'p_effective_date'

Line 99: hr_utility.set_location(' Leaving:'||l_proc, 20);

95: fnd_message.raise_error;
96: end if;
97: end if;
98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 20);
100: end chk_rate_type;
101: -- ----------------------------------------------------------------------------
102: -- |---------------------------< chk_process_type >-----------------------------|
103: -- ----------------------------------------------------------------------------

Line 113: hr_utility.set_location(' Entering '||l_proc, 10);

109: l_proc varchar2(72) := g_package|| ' chk_process_type';
110: --
111: Begin
112: --
113: hr_utility.set_location(' Entering '||l_proc, 10);
114: --
115: hr_api.mandatory_arg_error
116: (p_api_name => l_proc
117: ,p_argument => 'p_effective_date'

Line 136: hr_utility.set_location(' Leaving:'||l_proc, 20);

132: fnd_message.set_name('PAY', 'PAY_74899_CNU_BAD_PROCESS');
133: fnd_message.raise_error;
134: end if;
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 20);
137: end chk_process_type;
138: -- ----------------------------------------------------------------------------
139: -- |---------------------------< chk_lu_group_code >--------------------------|
140: -- ----------------------------------------------------------------------------

Line 152: hr_utility.set_location(' Entering '||l_proc, 10);

148: -- The group code must be in either FR_ELEMENT_GROUP or USER_ELEMENT_GROUP
149: --
150: Begin
151: --
152: hr_utility.set_location(' Entering '||l_proc, 10);
153: --
154: hr_api.mandatory_arg_error
155: (p_api_name => l_proc
156: ,p_argument => 'p_effective_date'

Line 181: hr_utility.set_location(' Leaving:'||l_proc, 20);

177: fnd_message.raise_error;
178: end if;
179: end if;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 20);
182: end chk_lu_group_code;
183: -- ----------------------------------------------------------------------------
184: -- |---------------------------< chk_business_group_id >----------------------|
185: -- ----------------------------------------------------------------------------

Line 204: hr_utility.set_location(' Entering '||l_proc, 10);

200: where pbg.business_group_id = p_business_group_id;
201: --
202: Begin
203: --
204: hr_utility.set_location(' Entering '||l_proc, 10);
205: --
206: -- Only test if not null
207: --
208: If p_business_group_id is not null

Line 218: hr_utility.set_location(' Step:'|| l_proc, 20);

214: then
215: fnd_message.set_name('PAY', 'PAY_74901_CNU_BAD_LEGISLATION');
216: fnd_message.raise_error;
217: end if;
218: hr_utility.set_location(' Step:'|| l_proc, 20);
219: end if;
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 30);
222: end chk_business_group_id;

Line 221: hr_utility.set_location(' Leaving:'||l_proc, 30);

217: end if;
218: hr_utility.set_location(' Step:'|| l_proc, 20);
219: end if;
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 30);
222: end chk_business_group_id;
223: -- ----------------------------------------------------------------------------
224: -- |---------------------------< chk_rate_category_type >---------------------|
225: -- ----------------------------------------------------------------------------

Line 235: hr_utility.set_location(' Entering '||l_proc, 10);

231: l_proc varchar2(72) := g_package|| ' chk_rate_category_type';
232: --
233: Begin
234: --
235: hr_utility.set_location(' Entering '||l_proc, 10);
236: hr_api.mandatory_arg_error
237: (p_api_name => l_proc
238: ,p_argument => 'p_rate_category'
239: ,p_argument_value => p_rate_category

Line 242: hr_utility.set_location(' Step:'|| l_proc, 20);

238: ,p_argument => 'p_rate_category'
239: ,p_argument_value => p_rate_category
240: );
241: --
242: hr_utility.set_location(' Step:'|| l_proc, 20);
243: if ( (p_rate_category <> 'S')
244: and(p_rate_category <> 'W')
245: and(p_rate_category <> 'T')
246: and(p_rate_category <> 'R')

Line 256: hr_utility.set_location(' Step:'|| l_proc, 30);

252: fnd_message.set_name('PAY', 'PAY_74902_CNU_BAD_RATE_CAT');
253: fnd_message.raise_error;
254: end if;
255: --
256: hr_utility.set_location(' Step:'|| l_proc, 30);
257: if( ( ( p_rate_category = 'W'
258: OR p_rate_category = 'T'
259: OR p_rate_category = 'R'
260: ) and p_rate_type is not null)

Line 269: hr_utility.set_location(' Leaving:'||l_proc, 40);

265: then
266: fnd_message.set_name('PAY', 'PAY_74903_CNU_BAD_RATE_STD');
267: fnd_message.raise_error;
268: end if;
269: hr_utility.set_location(' Leaving:'||l_proc, 40);
270: end chk_rate_category_type;
271: --
272:
273: -- ----------------------------------------------------------------------------

Line 314: hr_utility.set_location(' Entering '||l_proc, 10);

310: Begin
311: --
312: -- URSSAF
313: --
314: hr_utility.set_location(' Entering '||l_proc, 10);
315: if p_contribution_type = 'URSSAF'
316: and( (substr(p_code, 1, 1) <> '1')
317: OR(substr(p_code, 2, 2) <> 'XX')
318: OR( (substr(p_code, 7, 1) <> 'A')

Line 331: hr_utility.set_location(' Step:'|| l_proc, 20);

327: OR(is_numeric(substr(p_code, 6, 1)) <> '1')
328: OR(length(p_code) <> 7 and length(p_code) <> 8)
329: )
330: then
331: hr_utility.set_location(' Step:'|| l_proc, 20);
332: fnd_message.set_name('PAY', 'PAY_74904_CNU_BAD_URSSAF');
333: fnd_message.raise_error;
334: end if;
335: hr_utility.set_location(' Step:'|| l_proc, 30);

Line 335: hr_utility.set_location(' Step:'|| l_proc, 30);

331: hr_utility.set_location(' Step:'|| l_proc, 20);
332: fnd_message.set_name('PAY', 'PAY_74904_CNU_BAD_URSSAF');
333: fnd_message.raise_error;
334: end if;
335: hr_utility.set_location(' Step:'|| l_proc, 30);
336: --
337: -- ASSEDIC
338: --
339: if p_contribution_type = 'ASSEDIC'

Line 356: hr_utility.set_location(' Step:'|| l_proc, 50);

352: then
353: fnd_message.set_name('PAY', 'PAY_74905_CNU_BAD_ASSEDIC');
354: fnd_message.raise_error;
355: end if;
356: hr_utility.set_location(' Step:'|| l_proc, 50);
357: --
358: -- AGIRC
359: --
360: if p_contribution_type = 'AGIRC'

Line 371: hr_utility.set_location(' Step:'|| l_proc, 60);

367: then
368: fnd_message.set_name('PAY', 'PAY_74906_CNU_BAD_AGIRC');
369: fnd_message.raise_error;
370: end if;
371: hr_utility.set_location(' Step:'|| l_proc, 60);
372: --
373: --
374: -- ARRCO
375: --

Line 388: hr_utility.set_location(' Leaving:'||l_proc, 80);

384: fnd_message.set_name('PAY', 'PAY_74907_CNU_BAD_ARRCO');
385: fnd_message.raise_error;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 80);
389: end chk_validate_code;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |---------------------------< chk_contribution_codes >---------------------|

Line 412: hr_utility.set_location(' Entering '||l_proc, 10);

408: --
409: -- check mandatory parameters have been set
410: --
411: --
412: hr_utility.set_location(' Entering '||l_proc, 10);
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc
415: ,p_argument => 'p_contribution_type'
416: ,p_argument_value => p_contribution_type

Line 423: hr_utility.set_location(' Step:'|| l_proc, 20);

419: -- main code can only be null if cont type is URSSAF
420: --
421: if p_contribution_type <> 'URSSAF' and p_contribution_code is null and p_rate_category <> 'C'
422: then
423: hr_utility.set_location(' Step:'|| l_proc, 20);
424: fnd_message.set_name('PAY', 'PAY_74908_CNU_MISSING_CODE');
425: fnd_message.raise_error;
426: end if;
427: --

Line 439: hr_utility.set_location(' Step:'|| l_proc, 30);

435: if (l_api_updating and
436: nvl(pay_cnu_shd.g_old_rec.retro_contribution_code, hr_api.g_varchar2) <>
437: nvl(p_retro_contribution_code, hr_api.g_varchar2) and p_retro_contribution_code is not null)
438: then
439: hr_utility.set_location(' Step:'|| l_proc, 30);
440: pay_cnu_bus1.chk_validate_code( p_code => p_retro_contribution_code
441: ,p_contribution_type => p_contribution_type
442: ,p_rate_category => p_rate_category);
443: end if;

Line 449: hr_utility.set_location(' Step:'|| l_proc, 40);

445: -- If this is an insert and code is not null check.
446: --
447: if (NOT l_api_updating and p_contribution_code is not null)
448: then
449: hr_utility.set_location(' Step:'|| l_proc, 40);
450: pay_cnu_bus1.chk_validate_code( p_code => p_contribution_code
451: ,p_contribution_type => p_contribution_type
452: ,p_rate_category => p_rate_category);
453: end if;

Line 454: hr_utility.set_location(' Step:'|| l_proc, 45);

450: pay_cnu_bus1.chk_validate_code( p_code => p_contribution_code
451: ,p_contribution_type => p_contribution_type
452: ,p_rate_category => p_rate_category);
453: end if;
454: hr_utility.set_location(' Step:'|| l_proc, 45);
455: --
456: -- Check retro code
457: --
458: if (NOT l_api_updating and p_retro_contribution_code is not null)

Line 464: hr_utility.set_location(' Leaving:'||l_proc, 50);

460: pay_cnu_bus1.chk_validate_code( p_code => p_retro_contribution_code
461: ,p_contribution_type => p_contribution_type
462: ,p_rate_category => p_rate_category);
463: end if;
464: hr_utility.set_location(' Leaving:'||l_proc, 50);
465: end chk_contribution_codes;
466: -- ----------------------------------------------------------------------------
467: -- |---------------------------< chk_contribution_type >----------------------|
468: -- ----------------------------------------------------------------------------

Line 480: hr_utility.set_location(' Entering '||l_proc, 10);

476: --
477: -- check mandatory parameters have been set
478: --
479: --
480: hr_utility.set_location(' Entering '||l_proc, 10);
481: hr_api.mandatory_arg_error
482: (p_api_name => l_proc
483: ,p_argument => 'p_contribution_type'
484: ,p_argument_value => p_contribution_type

Line 492: hr_utility.set_location(' Step:'|| l_proc, 20);

488: and p_contribution_type <> 'ASSEDIC'
489: and p_contribution_type <> 'AGIRC'
490: and p_contribution_type <> 'ARRCO'
491: then
492: hr_utility.set_location(' Step:'|| l_proc, 20);
493: fnd_message.set_name('PAY', 'PAY_74909_CNU_BAD_CONT_TYPE');
494: fnd_message.raise_error;
495: end if;
496: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 496: hr_utility.set_location(' Leaving:'||l_proc, 90);

492: hr_utility.set_location(' Step:'|| l_proc, 20);
493: fnd_message.set_name('PAY', 'PAY_74909_CNU_BAD_CONT_TYPE');
494: fnd_message.raise_error;
495: end if;
496: hr_utility.set_location(' Leaving:'||l_proc, 90);
497: end chk_contribution_type;
498:
499: -- ----------------------------------------------------------------------------
500: -- |---------------------------< chk_group_code >------------------------------|

Line 542: hr_utility.set_location(' Entering '||l_proc, 10);

538: --
539: -- check mandatory parameters have been set
540: --
541: --
542: hr_utility.set_location(' Entering '||l_proc, 10);
543: hr_api.mandatory_arg_error
544: (p_api_name => l_proc
545: ,p_argument => 'p_group_code'
546: ,p_argument_value => p_group_code

Line 549: hr_utility.set_location(' Step:'|| l_proc, 30);

545: ,p_argument => 'p_group_code'
546: ,p_argument_value => p_group_code
547: );
548: --
549: hr_utility.set_location(' Step:'|| l_proc, 30);
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc
552: ,p_argument => 'p_process_type'
553: ,p_argument_value => p_process_type

Line 556: hr_utility.set_location(' Step:'|| l_proc, 40);

552: ,p_argument => 'p_process_type'
553: ,p_argument_value => p_process_type
554: );
555: --
556: hr_utility.set_location(' Step:'|| l_proc, 40);
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc
559: ,p_argument => 'p_element_name'
560: ,p_argument_value => p_element_name

Line 563: hr_utility.set_location(' Step:'|| l_proc, 50);

559: ,p_argument => 'p_element_name'
560: ,p_argument_value => p_element_name
561: );
562: --
563: hr_utility.set_location(' Step:'|| l_proc, 50);
564: hr_api.mandatory_arg_error
565: (p_api_name => l_proc
566: ,p_argument => 'p_contribution_usage_type'
567: ,p_argument_value => p_contribution_usage_type

Line 573: hr_utility.set_location(' Step:'|| l_proc, 60);

569: --
570: -- This is an insert (not called for update or delete)
571: -- check the combination is unique
572: --
573: hr_utility.set_location(' Step:'|| l_proc, 60);
574: open csr_unique;
575: fetch csr_unique into l_cu_id;
576: if csr_unique%FOUND then
577: close csr_unique;

Line 582: hr_utility.set_location(' Step:'|| l_proc, 80);

578: fnd_message.set_name('PAY', 'PAY_74910_CNU_CHANGING_GROUP');
579: fnd_message.raise_error;
580: else
581: close csr_unique;
582: hr_utility.set_location(' Step:'|| l_proc, 80);
583: end if;
584: --
585: hr_utility.set_location(' Leaving:'||l_proc, 90);
586: end chk_group_code;

Line 585: hr_utility.set_location(' Leaving:'||l_proc, 90);

581: close csr_unique;
582: hr_utility.set_location(' Step:'|| l_proc, 80);
583: end if;
584: --
585: hr_utility.set_location(' Leaving:'||l_proc, 90);
586: end chk_group_code;
587: -- ----------------------------------------------------------------------------
588: -- |---------------------------< chk_dates >----------------------------------|
589: -- ----------------------------------------------------------------------------

Line 649: hr_utility.set_location(' Entering '||l_proc, 10);

645: --
646: -- check mandatory parameters have been set
647: --
648: --
649: hr_utility.set_location(' Entering '||l_proc, 10);
650: hr_api.mandatory_arg_error
651: (p_api_name => l_proc
652: ,p_argument => 'p_date_from'
653: ,p_argument_value => p_date_from

Line 656: hr_utility.set_location(' Step:'|| l_proc, 20);

652: ,p_argument => 'p_date_from'
653: ,p_argument_value => p_date_from
654: );
655: --
656: hr_utility.set_location(' Step:'|| l_proc, 20);
657: hr_api.mandatory_arg_error
658: (p_api_name => l_proc
659: ,p_argument => 'p_group_code'
660: ,p_argument_value => p_group_code

Line 663: hr_utility.set_location(' Step:'|| l_proc, 30);

659: ,p_argument => 'p_group_code'
660: ,p_argument_value => p_group_code
661: );
662: --
663: hr_utility.set_location(' Step:'|| l_proc, 30);
664: hr_api.mandatory_arg_error
665: (p_api_name => l_proc
666: ,p_argument => 'p_process_type'
667: ,p_argument_value => p_process_type

Line 670: hr_utility.set_location(' Step:'|| l_proc, 40);

666: ,p_argument => 'p_process_type'
667: ,p_argument_value => p_process_type
668: );
669: --
670: hr_utility.set_location(' Step:'|| l_proc, 40);
671: hr_api.mandatory_arg_error
672: (p_api_name => l_proc
673: ,p_argument => 'p_element_name'
674: ,p_argument_value => p_element_name

Line 677: hr_utility.set_location(' Step:'|| l_proc, 50);

673: ,p_argument => 'p_element_name'
674: ,p_argument_value => p_element_name
675: );
676: --
677: hr_utility.set_location(' Step:'|| l_proc, 50);
678: hr_api.mandatory_arg_error
679: (p_api_name => l_proc
680: ,p_argument => 'p_contribution_usage_type'
681: ,p_argument_value => p_contribution_usage_type

Line 695: hr_utility.set_location(' Step:'|| l_proc, 55);

691: --
692: -- Check that the date_from is before or on the date_to
693: --
694: if p_date_from > nvl(p_date_to, hr_api.g_eot) THEN
695: hr_utility.set_location(' Step:'|| l_proc, 55);
696: fnd_message.set_name('PAY', 'PAY_74911_CNU_DATE_FROM');
697: fnd_message.raise_error;
698: end if;
699: --

Line 707: hr_utility.set_location(' Step:'|| l_proc, 60);

703: nvl(pay_cnu_shd.g_old_rec.date_to, hr_api.g_date) <>
704: nvl(p_date_to, hr_api.g_date) )
705: or (NOT l_api_updating)
706: then
707: hr_utility.set_location(' Step:'|| l_proc, 60);
708: open csr_unique;
709: fetch csr_unique into l_cu_id;
710: if csr_unique%FOUND then
711: close csr_unique;

Line 712: hr_utility.set_location(' Step:'|| l_proc, 70);

708: open csr_unique;
709: fetch csr_unique into l_cu_id;
710: if csr_unique%FOUND then
711: close csr_unique;
712: hr_utility.set_location(' Step:'|| l_proc, 70);
713: fnd_message.set_name('PAY', 'PAY_74912_CNU_DUPLICATE_USAGE');
714: fnd_message.raise_error;
715: else
716: close csr_unique;

Line 717: hr_utility.set_location(' Step:'|| l_proc, 80);

713: fnd_message.set_name('PAY', 'PAY_74912_CNU_DUPLICATE_USAGE');
714: fnd_message.raise_error;
715: else
716: close csr_unique;
717: hr_utility.set_location(' Step:'|| l_proc, 80);
718: end if;
719: end if;
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 721: hr_utility.set_location(' Leaving:'||l_proc, 90);

717: hr_utility.set_location(' Step:'|| l_proc, 80);
718: end if;
719: end if;
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 90);
722: end chk_dates;
723: --
724: -- ----------------------------------------------------------------------------
725: -- |---------------------------< LOAD_ROW >------------------------------------|

Line 863: hr_utility.set_location(' Entering '||l_proc, 10);

859: --
860: -- check mandatory parameters have been set
861: --
862: --
863: hr_utility.set_location(' Entering '||l_proc, 10);
864: hr_api.mandatory_arg_error
865: (p_api_name => l_proc
866: ,p_argument => 'p_rate_category'
867: ,p_argument_value => p_rate_category

Line 924: hr_utility.set_location(' Leaving:'||l_proc, 90);

920: else
921: close csr_chk_unique;
922: end if;
923: End if;
924: hr_utility.set_location(' Leaving:'||l_proc, 90);
925: end chk_code_rate_id;
926: -------------------------------------------------------------------------------
927: end pay_cnu_bus1;