APPS.HR_LIP_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

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

Line 67: hr_api.set_security_group_id

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

Line 104: hr_api.mandatory_arg_error

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

Line 110: if ( nvl(hr_lip_bus.g_organization_link_id, hr_api.g_number)

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

Line 198: hr_api.mandatory_arg_error

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: --

Line 281: and nvl(hr_lip_shd.g_old_rec.calculation_method, hr_api.g_varchar2) <> nvl(p_calculation_method, hr_api.g_varchar2)

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'.

Line 287: if hr_api.not_exists_in_hr_lookups

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');

Line 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)

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.

Line 412: and nvl(hr_lip_shd.g_old_rec.std_percentage, hr_api.g_number) <> nvl(p_std_percentage, hr_api.g_number)

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.

Line 478: and nvl(hr_lip_shd.g_old_rec.max_remuneration, hr_api.g_number) <> nvl(p_max_remuneration, hr_api.g_number)

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.

Line 538: and liability_premiums_id <> nvl(p_liability_premiums_id, hr_api.g_number)

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: --

Line 609: nvl(hr_lip_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

Line 610: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

Line 611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

Line 612: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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

Line 613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

Line 614: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

Line 615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

Line 616: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

Line 617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

Line 618: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

Line 619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

Line 620: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

Line 621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

Line 622: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

Line 623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

Line 624: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

Line 625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

Line 626: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

Line 627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

Line 628: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

Line 629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

Line 630: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

Line 631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

Line 632: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

Line 633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

Line 634: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

Line 635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

Line 636: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

Line 637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

Line 638: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

Line 639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

Line 640: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

Line 641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

Line 642: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

Line 643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

Line 644: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

Line 645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

Line 646: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) ))

Line 647: nvl(hr_lip_shd.g_old_rec.attribute19, 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

Line 648: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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: --

Line 649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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:

Line 650: nvl(p_rec.attribute20, 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:
654: -- a) During update, the structure column value or any

Line 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

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: --

Line 767: hr_api.argument_changed_error

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;

Line 817: hr_api.mandatory_arg_error

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

Line 827: hr_api.mandatory_arg_error

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

Line 833: hr_api.mandatory_arg_error

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

Line 911: hr_api.mandatory_arg_error

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

Line 920: If (p_datetrack_mode = hr_api.g_delete or

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

Line 921: p_datetrack_mode = hr_api.g_zap) then

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: --

Line 926: hr_api.mandatory_arg_error

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

Line 932: hr_api.mandatory_arg_error

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

Line 938: hr_api.mandatory_arg_error

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