36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------
96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := hr_lip_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: hr_lip_bus.g_organization_link_id := p_organization_link_id;
142: hr_lip_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ---------------------------------------------------------------------------
189: --
190: l_proc varchar2(72) := g_package || 'chk_organization_link_id';
191: l_org_link_type varchar2(30);
192: begin
193: hr_utility.set_location('Entering:'|| l_proc, 10);
194: --
195: --
196: -- Check mandatory parameters have been set
197: --
199: (p_api_name => l_proc
200: ,p_argument => 'organization_link_id'
201: ,p_argument_value => p_organization_link_id);
202: --
203: hr_utility.set_location(l_proc, 20);
204: --
205: --
206: -- Check that the organization link exists.
207: --
215: else
216: close c_organization_link;
217: end if;
218: --
219: hr_utility.set_location(l_proc, 30);
220: --
221: --
222: -- Check that the organization link has a link type of 'DE_LIABILITY_INSURANCE'.
223: --
225: fnd_message.set_name('PER', 'HR_DE_LINK_LIABILITY_INS');
226: fnd_message.raise_error;
227: end if;
228: --
229: hr_utility.set_location(' Leaving:'|| l_proc, 40);
230: end chk_organization_link_id;
231: --
232: -- ---------------------------------------------------------------------------
233: -- |-----------------------< chk_calculation_method >------------------------|
267: --
268: l_proc varchar2(72) := g_package || 'chk_calculation_method';
269: l_api_updating boolean;
270: begin
271: hr_utility.set_location('Entering:'|| l_proc, 10);
272: --
273: l_api_updating := hr_lip_shd.api_updating
274: (p_effective_date => p_effective_date
275: ,p_liability_premiums_id => p_liability_premiums_id
292: fnd_message.raise_error;
293: end if;
294: end if;
295: --
296: hr_utility.set_location(' Leaving:'|| l_proc, 20);
297: end chk_calculation_method;
298: --
299: -- ---------------------------------------------------------------------------
300: -- |-------------------< chk_std_working_hours_per_year >--------------------|
334: --
335: l_proc varchar2(72) := g_package || 'chk_std_working_hours_per_year';
336: l_api_updating boolean;
337: begin
338: hr_utility.set_location('Entering:'|| l_proc, 10);
339: --
340: l_api_updating := hr_lip_shd.api_updating
341: (p_effective_date => p_effective_date
342: ,p_liability_premiums_id => p_liability_premiums_id
356: fnd_message.raise_error;
357: end if;
358: end if;
359: --
360: hr_utility.set_location(' Leaving:'|| l_proc, 20);
361: end chk_std_working_hours_per_year;
362: --
363: -- ---------------------------------------------------------------------------
364: -- |-------------------------< chk_std_percentage >--------------------------|
398: --
399: l_proc varchar2(72) := g_package || 'chk_std_percentage';
400: l_api_updating boolean;
401: begin
402: hr_utility.set_location('Entering:'|| l_proc, 10);
403: --
404: l_api_updating := hr_lip_shd.api_updating
405: (p_effective_date => p_effective_date
406: ,p_liability_premiums_id => p_liability_premiums_id
420: fnd_message.raise_error;
421: end if;
422: end if;
423: --
424: hr_utility.set_location(l_proc, 20);
425: --
426: hr_utility.set_location(' Leaving:'|| l_proc, 40);
427: end chk_std_percentage;
428: --
422: end if;
423: --
424: hr_utility.set_location(l_proc, 20);
425: --
426: hr_utility.set_location(' Leaving:'|| l_proc, 40);
427: end chk_std_percentage;
428: --
429: -- ---------------------------------------------------------------------------
430: -- |-------------------------< chk_max_remuneration >------------------------|
464: --
465: l_proc varchar2(72) := g_package || 'chk_max_remuneration';
466: l_api_updating boolean;
467: begin
468: hr_utility.set_location('Entering:'|| l_proc, 10);
469: --
470: l_api_updating := hr_lip_shd.api_updating
471: (p_effective_date => p_effective_date
472: ,p_liability_premiums_id => p_liability_premiums_id
487: end if;
488: null;
489: end if;
490: --
491: hr_utility.set_location(' Leaving:'|| l_proc, 20);
492: end chk_max_remuneration;
493: --
494: -- ---------------------------------------------------------------------------
495: -- |-----------------------< chk_overlapping_premiums >----------------------|
545: --
546: l_proc varchar2(72) := g_package || 'chk_overlapping_premiums';
547: l_dummy varchar2(2000);
548: begin
549: hr_utility.set_location('Entering:'|| l_proc, 10);
550: --
551: --
552: -- Check that there are no overlapping records for the same organization link.
553: --
564: else
565: close c_liability_premiums;
566: end if;
567: --
568: hr_utility.set_location(' Leaving:'|| l_proc, 20);
569: end chk_overlapping_premiums;
570: --
571: -- ----------------------------------------------------------------------------
572: -- |------------------------------< chk_df >----------------------------------|
602: --
603: l_proc varchar2(72) := g_package || 'chk_df';
604: --
605: begin
606: hr_utility.set_location('Entering:'||l_proc,10);
607: --
608: if ((p_rec.liability_premiums_id is not null) and (
609: nvl(hr_lip_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: ,p_attribute20_value => p_rec.attribute20
702: );
703: end if;
704: --
705: hr_utility.set_location(' Leaving:'||l_proc,20);
706: end chk_df;
707: --
708: -- ----------------------------------------------------------------------------
709: -- |-----------------------< chk_non_updateable_args >------------------------|
979: --
980: l_proc varchar2(72) := g_package||'insert_validate';
981: --
982: Begin
983: hr_utility.set_location('Entering:'||l_proc, 5);
984: --
985: hr_lip_bus.set_security_group_id(p_organization_link_id => p_rec.organization_link_id);
986: --
987: chk_overlapping_premiums
1018: ,p_max_remuneration => p_rec.max_remuneration);
1019: --
1020: hr_lip_bus.chk_df(p_rec);
1021: --
1022: hr_utility.set_location(' Leaving:'||l_proc, 10);
1023: End insert_validate;
1024: --
1025: -- ----------------------------------------------------------------------------
1026: -- |---------------------------< update_validate >----------------------------|
1035: --
1036: l_proc varchar2(72) := g_package||'update_validate';
1037: --
1038: Begin
1039: hr_utility.set_location('Entering:'||l_proc, 5);
1040: --
1041: -- Call all supporting business operations
1042: --
1043: hr_lip_bus.set_security_group_id(p_organization_link_id => p_rec.organization_link_id);
1086: ,p_max_remuneration => p_rec.max_remuneration);
1087: --
1088: hr_lip_bus.chk_df(p_rec);
1089: --
1090: hr_utility.set_location(' Leaving:'||l_proc, 10);
1091: End update_validate;
1092: --
1093: -- ----------------------------------------------------------------------------
1094: -- |---------------------------< delete_validate >----------------------------|
1103: --
1104: l_proc varchar2(72) := g_package||'delete_validate';
1105: --
1106: Begin
1107: hr_utility.set_location('Entering:'||l_proc, 5);
1108: --
1109: -- Call all supporting business operations
1110: --
1111: dt_delete_validate
1120: ,p_organization_link_id => p_rec.organization_link_id
1121: ,p_validation_start_date => p_validation_start_date
1122: ,p_validation_end_date => p_validation_end_date);
1123: --
1124: hr_utility.set_location(' Leaving:'||l_proc, 10);
1125: End delete_validate;
1126: --
1127: end hr_lip_bus;