53: hr_utility.set_location('Entering:'|| l_proc, 10);
54: --
55: -- Ensure that all the mandatory parameter are not null
56: --
57: hr_api.mandatory_arg_error
58: (p_api_name => l_proc
59: ,p_argument => 'fnd_doc_link_id'
60: ,p_argument_value => p_fnd_doc_link_id
61: );
81: close csr_sec_grp;
82: --
83: -- Set the security_group_id in CLIENT_INFO
84: --
85: hr_api.set_security_group_id
86: (p_security_group_id => l_security_group_id
87: );
88: --
89: -- Set the sessions legislation context in HR_SESSION_DATA
87: );
88: --
89: -- Set the sessions legislation context in HR_SESSION_DATA
90: --
91: hr_api.set_legislation_context(l_legislation_code);
92: end if;
93: --
94: hr_utility.set_location(' Leaving:'|| l_proc, 20);
95: --
131: hr_utility.set_location('Entering:'|| l_proc, 10);
132: --
133: -- Ensure that all the mandatory parameter are not null
134: --
135: hr_api.mandatory_arg_error
136: (p_api_name => l_proc
137: ,p_argument => 'fnd_doc_link_id'
138: ,p_argument_value => p_fnd_doc_link_id
139: );
138: ,p_argument_value => p_fnd_doc_link_id
139: );
140:
141: --
142: if ( nvl(per_fdl_bus.g_fnd_doc_link_id, hr_api.g_number)
143: = p_fnd_doc_link_id) then
144: --
145: -- The legislation code has already been found with a previous
146: -- call to this function. Just return the value in the global
215: begin
216: hr_utility.set_location('Entering:'||l_proc,10);
217: --
218: if ((p_rec.fnd_doc_link_id is not null) and (
219: nvl(per_fdl_shd.g_old_rec.fdl_information_category, hr_api.g_varchar2) <>
220: nvl(p_rec.fdl_information_category, hr_api.g_varchar2) or
221: nvl(per_fdl_shd.g_old_rec.fdl_information1, hr_api.g_varchar2) <>
222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
216: hr_utility.set_location('Entering:'||l_proc,10);
217: --
218: if ((p_rec.fnd_doc_link_id is not null) and (
219: nvl(per_fdl_shd.g_old_rec.fdl_information_category, hr_api.g_varchar2) <>
220: nvl(p_rec.fdl_information_category, hr_api.g_varchar2) or
221: nvl(per_fdl_shd.g_old_rec.fdl_information1, hr_api.g_varchar2) <>
222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
217: --
218: if ((p_rec.fnd_doc_link_id is not null) and (
219: nvl(per_fdl_shd.g_old_rec.fdl_information_category, hr_api.g_varchar2) <>
220: nvl(p_rec.fdl_information_category, hr_api.g_varchar2) or
221: nvl(per_fdl_shd.g_old_rec.fdl_information1, hr_api.g_varchar2) <>
222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
218: if ((p_rec.fnd_doc_link_id is not null) and (
219: nvl(per_fdl_shd.g_old_rec.fdl_information_category, hr_api.g_varchar2) <>
220: nvl(p_rec.fdl_information_category, hr_api.g_varchar2) or
221: nvl(per_fdl_shd.g_old_rec.fdl_information1, hr_api.g_varchar2) <>
222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
219: nvl(per_fdl_shd.g_old_rec.fdl_information_category, hr_api.g_varchar2) <>
220: nvl(p_rec.fdl_information_category, hr_api.g_varchar2) or
221: nvl(per_fdl_shd.g_old_rec.fdl_information1, hr_api.g_varchar2) <>
222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
220: nvl(p_rec.fdl_information_category, hr_api.g_varchar2) or
221: nvl(per_fdl_shd.g_old_rec.fdl_information1, hr_api.g_varchar2) <>
222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
221: nvl(per_fdl_shd.g_old_rec.fdl_information1, hr_api.g_varchar2) <>
222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
237: nvl(per_fdl_shd.g_old_rec.fdl_information9, hr_api.g_varchar2) <>
230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
237: nvl(per_fdl_shd.g_old_rec.fdl_information9, hr_api.g_varchar2) <>
238: nvl(p_rec.fdl_information9, hr_api.g_varchar2) or
231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
237: nvl(per_fdl_shd.g_old_rec.fdl_information9, hr_api.g_varchar2) <>
238: nvl(p_rec.fdl_information9, hr_api.g_varchar2) or
239: nvl(per_fdl_shd.g_old_rec.fdl_information10, hr_api.g_varchar2) <>
232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
237: nvl(per_fdl_shd.g_old_rec.fdl_information9, hr_api.g_varchar2) <>
238: nvl(p_rec.fdl_information9, hr_api.g_varchar2) or
239: nvl(per_fdl_shd.g_old_rec.fdl_information10, hr_api.g_varchar2) <>
240: nvl(p_rec.fdl_information10, hr_api.g_varchar2) ))
233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
237: nvl(per_fdl_shd.g_old_rec.fdl_information9, hr_api.g_varchar2) <>
238: nvl(p_rec.fdl_information9, hr_api.g_varchar2) or
239: nvl(per_fdl_shd.g_old_rec.fdl_information10, hr_api.g_varchar2) <>
240: nvl(p_rec.fdl_information10, hr_api.g_varchar2) ))
241: or (p_rec.fnd_doc_link_id is null) then
234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
237: nvl(per_fdl_shd.g_old_rec.fdl_information9, hr_api.g_varchar2) <>
238: nvl(p_rec.fdl_information9, hr_api.g_varchar2) or
239: nvl(per_fdl_shd.g_old_rec.fdl_information10, hr_api.g_varchar2) <>
240: nvl(p_rec.fdl_information10, hr_api.g_varchar2) ))
241: or (p_rec.fnd_doc_link_id is null) then
242: --
235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
237: nvl(per_fdl_shd.g_old_rec.fdl_information9, hr_api.g_varchar2) <>
238: nvl(p_rec.fdl_information9, hr_api.g_varchar2) or
239: nvl(per_fdl_shd.g_old_rec.fdl_information10, hr_api.g_varchar2) <>
240: nvl(p_rec.fdl_information10, hr_api.g_varchar2) ))
241: or (p_rec.fnd_doc_link_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:
236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or
237: nvl(per_fdl_shd.g_old_rec.fdl_information9, hr_api.g_varchar2) <>
238: nvl(p_rec.fdl_information9, hr_api.g_varchar2) or
239: nvl(per_fdl_shd.g_old_rec.fdl_information10, hr_api.g_varchar2) <>
240: nvl(p_rec.fdl_information10, hr_api.g_varchar2) ))
241: or (p_rec.fnd_doc_link_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:
244: -- a) During update, the structure column value or any