DBA Data[Home] [Help]

APPS.PAY_CNU_BUS1 dependencies on HR_API

Line 22: hr_api.mandatory_arg_error

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'
25: ,p_argument_value => p_element_name
26: );

Line 44: hr_api.mandatory_arg_error

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'
47: ,p_argument_value => p_effective_date
48: );

Line 50: hr_api.mandatory_arg_error

46: ,p_argument => 'p_effective_date'
47: ,p_argument_value => p_effective_date
48: );
49: --
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52: ,p_argument => 'p_contribution_usage_type'
53: ,p_argument_value => p_contribution_usage_type
54: );

Line 56: If hr_api.not_exists_in_hr_lookups (

52: ,p_argument => 'p_contribution_usage_type'
53: ,p_argument_value => p_contribution_usage_type
54: );
55: --
56: If hr_api.not_exists_in_hr_lookups (
57: p_effective_date => p_effective_date
58: ,p_lookup_type => 'FR_CONTRIBUTION_USAGE_TYPE'
59: ,p_lookup_code => p_contribution_usage_type)
60: then

Line 81: hr_api.mandatory_arg_error

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'
84: ,p_argument_value => p_effective_date
85: );

Line 89: If hr_api.not_exists_in_hr_lookups (

85: );
86: --
87: If p_rate_type is not null
88: then
89: If hr_api.not_exists_in_hr_lookups (
90: p_effective_date => p_effective_date
91: ,p_lookup_type => 'FR_CONTRIBUTION_RATE_TYPE'
92: ,p_lookup_code => p_rate_type)
93: then

Line 115: hr_api.mandatory_arg_error

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'
118: ,p_argument_value => p_effective_date
119: );

Line 121: hr_api.mandatory_arg_error

117: ,p_argument => 'p_effective_date'
118: ,p_argument_value => p_effective_date
119: );
120: --
121: hr_api.mandatory_arg_error
122: (p_api_name => l_proc
123: ,p_argument => 'p_process_type'
124: ,p_argument_value => p_process_type
125: );

Line 127: If hr_api.not_exists_in_hr_lookups (

123: ,p_argument => 'p_process_type'
124: ,p_argument_value => p_process_type
125: );
126: --
127: If hr_api.not_exists_in_hr_lookups (
128: p_effective_date => p_effective_date
129: ,p_lookup_type => 'FR_PROCESS_TYPE'
130: ,p_lookup_code => p_process_type)
131: then

Line 154: hr_api.mandatory_arg_error

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'
157: ,p_argument_value => p_effective_date
158: );

Line 160: hr_api.mandatory_arg_error

156: ,p_argument => 'p_effective_date'
157: ,p_argument_value => p_effective_date
158: );
159: --
160: hr_api.mandatory_arg_error
161: (p_api_name => l_proc
162: ,p_argument => 'p_group_code'
163: ,p_argument_value => p_group_code
164: );

Line 166: If hr_api.not_exists_in_hr_lookups (

162: ,p_argument => 'p_group_code'
163: ,p_argument_value => p_group_code
164: );
165: --
166: If hr_api.not_exists_in_hr_lookups (
167: p_effective_date => p_effective_date
168: ,p_lookup_type => 'FR_ELEMENT_GROUP'
169: ,p_lookup_code => p_group_code )
170: then

Line 171: If hr_api.not_exists_in_hr_lookups (

167: p_effective_date => p_effective_date
168: ,p_lookup_type => 'FR_ELEMENT_GROUP'
169: ,p_lookup_code => p_group_code )
170: then
171: If hr_api.not_exists_in_hr_lookups (
172: p_effective_date => p_effective_date
173: ,p_lookup_type => 'FR_USER_ELEMENT_GROUP'
174: ,p_lookup_code => p_group_code )
175: then

Line 236: hr_api.mandatory_arg_error

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
240: );

Line 413: hr_api.mandatory_arg_error

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
417: );

Line 436: nvl(pay_cnu_shd.g_old_rec.retro_contribution_code, hr_api.g_varchar2) <>

432: --
433: -- If this is an update and retro is changing (and not changing to null) check.
434: --
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

Line 437: nvl(p_retro_contribution_code, hr_api.g_varchar2) and p_retro_contribution_code is not null)

433: -- If this is an update and retro is changing (and not changing to null) check.
434: --
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

Line 481: hr_api.mandatory_arg_error

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
485: );

Line 543: hr_api.mandatory_arg_error

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
547: );

Line 550: hr_api.mandatory_arg_error

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
554: );

Line 557: hr_api.mandatory_arg_error

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
561: );

Line 564: hr_api.mandatory_arg_error

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
568: );

Line 634: and ( ((nvl(p_date_to, hr_api.g_eot) <= nvl(cnu.date_to, hr_api.g_eot)

630: or(cnu.business_group_id is null)
631: )
632: )
633: )
634: and ( ((nvl(p_date_to, hr_api.g_eot) <= nvl(cnu.date_to, hr_api.g_eot)
635: and nvl(p_date_to, hr_api.g_eot) >= cnu.date_from))
636: OR
637: ( (p_date_from >= cnu.date_from)
638: and p_date_from <= nvl(cnu.date_to, hr_api.g_eot))

Line 635: and nvl(p_date_to, hr_api.g_eot) >= cnu.date_from))

631: )
632: )
633: )
634: and ( ((nvl(p_date_to, hr_api.g_eot) <= nvl(cnu.date_to, hr_api.g_eot)
635: and nvl(p_date_to, hr_api.g_eot) >= cnu.date_from))
636: OR
637: ( (p_date_from >= cnu.date_from)
638: and p_date_from <= nvl(cnu.date_to, hr_api.g_eot))
639: OR

Line 638: and p_date_from <= nvl(cnu.date_to, hr_api.g_eot))

634: and ( ((nvl(p_date_to, hr_api.g_eot) <= nvl(cnu.date_to, hr_api.g_eot)
635: and nvl(p_date_to, hr_api.g_eot) >= cnu.date_from))
636: OR
637: ( (p_date_from >= cnu.date_from)
638: and p_date_from <= nvl(cnu.date_to, hr_api.g_eot))
639: OR
640: ( (p_date_from <= cnu.date_from)
641: and nvl(p_date_to, hr_api.g_eot) >= nvl(cnu.date_to, hr_api.g_eot))
642: );

Line 641: and nvl(p_date_to, hr_api.g_eot) >= nvl(cnu.date_to, hr_api.g_eot))

637: ( (p_date_from >= cnu.date_from)
638: and p_date_from <= nvl(cnu.date_to, hr_api.g_eot))
639: OR
640: ( (p_date_from <= cnu.date_from)
641: and nvl(p_date_to, hr_api.g_eot) >= nvl(cnu.date_to, hr_api.g_eot))
642: );
643: --
644: Begin
645: --

Line 650: hr_api.mandatory_arg_error

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
654: );

Line 657: hr_api.mandatory_arg_error

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
661: );

Line 664: hr_api.mandatory_arg_error

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
668: );

Line 671: hr_api.mandatory_arg_error

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
675: );

Line 678: hr_api.mandatory_arg_error

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
682: );

Line 694: if p_date_from > nvl(p_date_to, hr_api.g_eot) THEN

690: );
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;

Line 703: nvl(pay_cnu_shd.g_old_rec.date_to, hr_api.g_date) <>

699: --
700: -- If the date_to is changing or if this is an insert
701: --
702: if (l_api_updating and
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);

Line 704: nvl(p_date_to, hr_api.g_date) )

700: -- If the date_to is changing or if this is an insert
701: --
702: if (l_api_updating and
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;

Line 864: hr_api.mandatory_arg_error

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
868: );