DBA Data[Home] [Help]

APPS.PER_FDL_BUS dependencies on HR_API

Line 57: hr_api.mandatory_arg_error

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

Line 85: hr_api.set_security_group_id

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

Line 91: hr_api.set_legislation_context(l_legislation_code);

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

Line 135: hr_api.mandatory_arg_error

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

Line 142: if ( nvl(per_fdl_bus.g_fnd_doc_link_id, hr_api.g_number)

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

Line 219: nvl(per_fdl_shd.g_old_rec.fdl_information_category, hr_api.g_varchar2) <>

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

Line 220: nvl(p_rec.fdl_information_category, hr_api.g_varchar2) or

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

Line 221: nvl(per_fdl_shd.g_old_rec.fdl_information1, hr_api.g_varchar2) <>

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

Line 222: nvl(p_rec.fdl_information1, hr_api.g_varchar2) or

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

Line 223: nvl(per_fdl_shd.g_old_rec.fdl_information2, hr_api.g_varchar2) <>

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

Line 224: nvl(p_rec.fdl_information2, hr_api.g_varchar2) or

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

Line 225: nvl(per_fdl_shd.g_old_rec.fdl_information3, hr_api.g_varchar2) <>

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

Line 226: nvl(p_rec.fdl_information3, hr_api.g_varchar2) or

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

Line 227: nvl(per_fdl_shd.g_old_rec.fdl_information4, hr_api.g_varchar2) <>

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

Line 228: nvl(p_rec.fdl_information4, hr_api.g_varchar2) or

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

Line 229: nvl(per_fdl_shd.g_old_rec.fdl_information5, hr_api.g_varchar2) <>

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

Line 230: nvl(p_rec.fdl_information5, hr_api.g_varchar2) or

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

Line 231: nvl(per_fdl_shd.g_old_rec.fdl_information6, hr_api.g_varchar2) <>

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

Line 232: nvl(p_rec.fdl_information6, hr_api.g_varchar2) or

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

Line 233: nvl(per_fdl_shd.g_old_rec.fdl_information7, hr_api.g_varchar2) <>

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

Line 234: nvl(p_rec.fdl_information7, hr_api.g_varchar2) or

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

Line 235: nvl(per_fdl_shd.g_old_rec.fdl_information8, hr_api.g_varchar2) <>

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

Line 236: nvl(p_rec.fdl_information8, hr_api.g_varchar2) or

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

Line 237: nvl(per_fdl_shd.g_old_rec.fdl_information9, 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

Line 238: nvl(p_rec.fdl_information9, hr_api.g_varchar2) or

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

Line 239: nvl(per_fdl_shd.g_old_rec.fdl_information10, hr_api.g_varchar2) <>

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:

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