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
45: (p_api_name => l_proc
46: ,p_argument => 'organization_link_id'
47: ,p_argument_value => p_organization_link_id
48: );
63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
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);
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
105: (p_api_name => l_proc
106: ,p_argument => 'organization_link_id'
107: ,p_argument_value => p_organization_link_id
108: );
106: ,p_argument => 'organization_link_id'
107: ,p_argument_value => p_organization_link_id
108: );
109: --
110: if ( nvl(hr_lip_bus.g_organization_link_id, hr_api.g_number)
111: = p_organization_link_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global
194: --
195: --
196: -- Check mandatory parameters have been set
197: --
198: hr_api.mandatory_arg_error
199: (p_api_name => l_proc
200: ,p_argument => 'organization_link_id'
201: ,p_argument_value => p_organization_link_id);
202: --
277: --
278: if (not l_api_updating
279: and p_calculation_method is not null)
280: or (l_api_updating
281: and nvl(hr_lip_shd.g_old_rec.calculation_method, hr_api.g_varchar2) <> nvl(p_calculation_method, hr_api.g_varchar2)
282: and p_calculation_method is not null) then
283: --
284: --
285: -- Check that it is a valid value from the lookup type 'DE_WORKING_HOURS_CALC_METHOD'.
283: --
284: --
285: -- Check that it is a valid value from the lookup type 'DE_WORKING_HOURS_CALC_METHOD'.
286: --
287: if hr_api.not_exists_in_hr_lookups
288: (p_effective_date => p_effective_date
289: ,p_lookup_type => 'DE_WORKING_HOURS_CALC_METHOD'
290: ,p_lookup_code => p_calculation_method) then
291: fnd_message.set_name('PER', 'HR_DE_CALC_METHOD_LOOKUP_CHK');
344: --
345: if (not l_api_updating
346: and p_std_working_hours_per_year is not null)
347: or (l_api_updating
348: and nvl(hr_lip_shd.g_old_rec.std_working_hours_per_year, hr_api.g_number) <> nvl(p_std_working_hours_per_year, hr_api.g_number)
349: and p_std_working_hours_per_year is not null) then
350: --
351: --
352: -- Check that it is between 0 and 999999999999999.
408: --
409: if (not l_api_updating
410: and p_std_percentage is not null)
411: or (l_api_updating
412: and nvl(hr_lip_shd.g_old_rec.std_percentage, hr_api.g_number) <> nvl(p_std_percentage, hr_api.g_number)
413: and p_std_percentage is not null) then
414: --
415: --
416: -- Check that it is between 0 and 100.
474: --
475: if (not l_api_updating
476: and p_max_remuneration is not null)
477: or (l_api_updating
478: and nvl(hr_lip_shd.g_old_rec.max_remuneration, hr_api.g_number) <> nvl(p_max_remuneration, hr_api.g_number)
479: and p_max_remuneration is not null) then
480: --
481: --
482: -- Check that it is between 0 and 9999999999.99.
534: ,p_validation_end_date in date) is
535: select null
536: from hr_de_liability_premiums_f
537: where organization_link_id = p_organization_link_id
538: and liability_premiums_id <> nvl(p_liability_premiums_id, hr_api.g_number)
539: and p_validation_start_date <= effective_end_date
540: and p_validation_end_date >= effective_start_date;
541:
542: --
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
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
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
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
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
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
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
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
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
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
651: or (p_rec.liability_premiums_id is null) then
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
651: or (p_rec.liability_premiums_id is null) then
652: --
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
651: or (p_rec.liability_premiums_id is null) then
652: --
653: -- Only execute the validation if absolutely necessary:
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
651: or (p_rec.liability_premiums_id is null) then
652: --
653: -- Only execute the validation if absolutely necessary:
654: -- a) During update, the structure column value or any
756: fnd_message.set_token('STEP ', '5');
757: fnd_message.raise_error;
758: END IF;
759: --
760: IF NVL(p_rec.organization_link_id, hr_api.g_number) <> NVL(hr_lip_shd.g_old_rec.organization_link_id, hr_api.g_number) THEN
761: l_argument := 'organization_link_id';
762: RAISE l_error;
763: END IF;
764: --
763: END IF;
764: --
765: EXCEPTION
766: WHEN l_error THEN
767: hr_api.argument_changed_error
768: (p_api_name => l_proc
769: ,p_argument => l_argument);
770: WHEN OTHERS THEN
771: RAISE;
813: Begin
814: --
815: -- Ensure that the p_datetrack_mode argument is not null
816: --
817: hr_api.mandatory_arg_error
818: (p_api_name => l_proc
819: ,p_argument => 'datetrack_mode'
820: ,p_argument_value => p_datetrack_mode
821: );
823: -- Mode will be valid, as this is checked at the start of the upd.
824: --
825: -- Ensure the arguments are not null
826: --
827: hr_api.mandatory_arg_error
828: (p_api_name => l_proc
829: ,p_argument => 'validation_start_date'
830: ,p_argument_value => p_validation_start_date
831: );
829: ,p_argument => 'validation_start_date'
830: ,p_argument_value => p_validation_start_date
831: );
832: --
833: hr_api.mandatory_arg_error
834: (p_api_name => l_proc
835: ,p_argument => 'validation_end_date'
836: ,p_argument_value => p_validation_end_date
837: );
907: Begin
908: --
909: -- Ensure that the p_datetrack_mode argument is not null
910: --
911: hr_api.mandatory_arg_error
912: (p_api_name => l_proc
913: ,p_argument => 'datetrack_mode'
914: ,p_argument_value => p_datetrack_mode
915: );
916: --
917: -- Only perform the validation if the datetrack mode is either
918: -- DELETE or ZAP
919: --
920: If (p_datetrack_mode = hr_api.g_delete or
921: p_datetrack_mode = hr_api.g_zap) then
922: --
923: --
924: -- Ensure the arguments are not null
917: -- Only perform the validation if the datetrack mode is either
918: -- DELETE or ZAP
919: --
920: If (p_datetrack_mode = hr_api.g_delete or
921: p_datetrack_mode = hr_api.g_zap) then
922: --
923: --
924: -- Ensure the arguments are not null
925: --
922: --
923: --
924: -- Ensure the arguments are not null
925: --
926: hr_api.mandatory_arg_error
927: (p_api_name => l_proc
928: ,p_argument => 'validation_start_date'
929: ,p_argument_value => p_validation_start_date
930: );
928: ,p_argument => 'validation_start_date'
929: ,p_argument_value => p_validation_start_date
930: );
931: --
932: hr_api.mandatory_arg_error
933: (p_api_name => l_proc
934: ,p_argument => 'validation_end_date'
935: ,p_argument_value => p_validation_end_date
936: );
934: ,p_argument => 'validation_end_date'
935: ,p_argument_value => p_validation_end_date
936: );
937: --
938: hr_api.mandatory_arg_error
939: (p_api_name => l_proc
940: ,p_argument => 'liability_premiums_id'
941: ,p_argument_value => p_liability_premiums_id
942: );