eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_NHS_BUS dependencies on HR_API

Line 39: hr_api.mandatory_arg_error

35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error
40: (p_api_name => l_proc
41: ,p_argument => 'nota_history_id'
42: ,p_argument_value => p_nota_history_id
43: );

Line 62: hr_api.set_security_group_id

58: close csr_sec_grp;
59: --
60: -- Set the security_group_id in CLIENT_INFO
61: --
62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 100: hr_api.mandatory_arg_error

96: hr_utility.set_location('Entering:'|| l_proc, 10);
97: --
98: -- Ensure that all the mandatory parameter are not null
99: --
100: hr_api.mandatory_arg_error
101: (p_api_name => l_proc
102: ,p_argument => 'nota_history_id'
103: ,p_argument_value => p_nota_history_id
104: );

Line 106: if ( nvl(ota_nhs_bus.g_nota_history_id, hr_api.g_number)

102: ,p_argument => 'nota_history_id'
103: ,p_argument_value => p_nota_history_id
104: );
105: --
106: if ( nvl(ota_nhs_bus.g_nota_history_id, hr_api.g_number)
107: = p_nota_history_id) then
108: --
109: -- The legislation code has already been found with a previous
110: -- call to this function. Just return the value in the global

Line 182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>

178: begin
179: hr_utility.set_location('Entering:'||l_proc,10);
180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>

Line 183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or

179: hr_utility.set_location('Entering:'||l_proc,10);
180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or

Line 184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>

180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>

Line 185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or

181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or

Line 186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>

182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>

Line 187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or

183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or

Line 188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>

184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>

Line 189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or

185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or

Line 190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>

186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>

Line 191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or

187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or

Line 192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>

188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>

Line 193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or

189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or

Line 194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>

190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>

Line 195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or

191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or

Line 196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>

192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>

Line 197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or

193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or

Line 198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>

194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>

Line 199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or

195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or

Line 200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>

196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>

Line 201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or

197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or

Line 202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>

198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>

Line 203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or

199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or

Line 204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>

200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>

Line 205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or

201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or

Line 206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>

202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>

Line 207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or

203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or

Line 208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>

204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>

Line 209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or

205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or

Line 210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>

206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>

Line 211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or

207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or

Line 212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>

208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>

Line 213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or

209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or

Line 214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>

210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>

Line 215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or

211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or

Line 216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>

212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>

Line 217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or

213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or

Line 218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>

214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>

Line 219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or

215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )

Line 220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>

216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317

Line 221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or

217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317
225: or (p_rec.nota_history_id is null) ) then

Line 222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>

218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317
225: or (p_rec.nota_history_id is null) ) then
226:

Line 223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )

219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317
225: or (p_rec.nota_history_id is null) ) then
226:
227: --

Line 334: if nvl(p_rec.business_group_id,hr_api.g_number) <>

330: fnd_message.set_token('STEP ', '5');
331: fnd_message.raise_error;
332: END IF;
333:
334: if nvl(p_rec.business_group_id,hr_api.g_number) <>
335: nvl(ota_nhs_shd.g_old_rec.business_group_id,hr_api.g_number)
336: then
337: l_argument := 'business_group_id';
338: raise l_error;

Line 335: nvl(ota_nhs_shd.g_old_rec.business_group_id,hr_api.g_number)

331: fnd_message.raise_error;
332: END IF;
333:
334: if nvl(p_rec.business_group_id,hr_api.g_number) <>
335: nvl(ota_nhs_shd.g_old_rec.business_group_id,hr_api.g_number)
336: then
337: l_argument := 'business_group_id';
338: raise l_error;
339: end if;

Line 340: if nvl(p_rec.customer_id,hr_api.g_number) <>

336: then
337: l_argument := 'business_group_id';
338: raise l_error;
339: end if;
340: if nvl(p_rec.customer_id,hr_api.g_number) <>
341: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number)
342: then
343: l_argument := 'customer_id';
344: raise l_error;

Line 341: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number)

337: l_argument := 'business_group_id';
338: raise l_error;
339: end if;
340: if nvl(p_rec.customer_id,hr_api.g_number) <>
341: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number)
342: then
343: l_argument := 'customer_id';
344: raise l_error;
345: end if;

Line 346: if nvl(p_rec.organization_id,hr_api.g_number) <>

342: then
343: l_argument := 'customer_id';
344: raise l_error;
345: end if;
346: if nvl(p_rec.organization_id,hr_api.g_number) <>
347: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number)
348: then
349: l_argument := 'organization_id';
350: raise l_error;

Line 347: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number)

343: l_argument := 'customer_id';
344: raise l_error;
345: end if;
346: if nvl(p_rec.organization_id,hr_api.g_number) <>
347: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number)
348: then
349: l_argument := 'organization_id';
350: raise l_error;
351: end if;

Line 352: if nvl(p_rec.person_id,hr_api.g_number) <>

348: then
349: l_argument := 'organization_id';
350: raise l_error;
351: end if;
352: if nvl(p_rec.person_id,hr_api.g_number) <>
353: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number)
354: then
355: l_argument := 'person_id';
356: raise l_error;

Line 353: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number)

349: l_argument := 'organization_id';
350: raise l_error;
351: end if;
352: if nvl(p_rec.person_id,hr_api.g_number) <>
353: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number)
354: then
355: l_argument := 'person_id';
356: raise l_error;
357: end if;

Line 361: hr_api.argument_changed_error

357: end if;
358:
359: EXCEPTION
360: WHEN l_error THEN
361: hr_api.argument_changed_error
362: (p_api_name => l_proc
363: ,p_argument => l_argument);
364: WHEN OTHERS THEN
365: RAISE;

Line 405: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number) <>

401: ota_nhs_bus.get_profile_value(l_cross_business_group,
402: l_business_group_id );
403:
404: if (((p_nota_history_id is not null) and
405: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number) <>
406: nvl(p_organization_id,hr_api.g_number))
407: or (p_nota_history_id is null)) then
408: --
409: hr_utility.set_location('Entering:'||l_proc, 10);

Line 406: nvl(p_organization_id,hr_api.g_number))

402: l_business_group_id );
403:
404: if (((p_nota_history_id is not null) and
405: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number) <>
406: nvl(p_organization_id,hr_api.g_number))
407: or (p_nota_history_id is null)) then
408: --
409: hr_utility.set_location('Entering:'||l_proc, 10);
410: if (p_organization_id is not null) then

Line 466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>

462: Begin
463: hr_utility.set_location('Entering:'||l_proc, 5);
464:
465: if (((p_nota_history_id is not null) and
466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>
467: nvl(p_customer_id,hr_api.g_number))
468: or (p_nota_history_id is null)) then
469: --
470: hr_utility.set_location('Entering:'||l_proc, 10);

Line 467: nvl(p_customer_id,hr_api.g_number))

463: hr_utility.set_location('Entering:'||l_proc, 5);
464:
465: if (((p_nota_history_id is not null) and
466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>
467: nvl(p_customer_id,hr_api.g_number))
468: or (p_nota_history_id is null)) then
469: --
470: hr_utility.set_location('Entering:'||l_proc, 10);
471: if (p_customer_id is not null) then

Line 554: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number) <>

550: l_business_group_id );
551:
552:
553: if (((p_nota_history_id is not null) and
554: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number) <>
555: nvl(p_person_id,hr_api.g_number))
556: or (p_nota_history_id is null)) then
557: --
558: hr_utility.set_location('Entering:'||l_proc, 10);

Line 555: nvl(p_person_id,hr_api.g_number))

551:
552:
553: if (((p_nota_history_id is not null) and
554: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number) <>
555: nvl(p_person_id,hr_api.g_number))
556: or (p_nota_history_id is null)) then
557: --
558: hr_utility.set_location('Entering:'||l_proc, 10);
559: if p_person_id is not null then

Line 654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>

650: Begin
651: hr_utility.set_location('Entering:'||l_proc, 5);
652:
653: if (((p_nota_history_id is not null) and
654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>
655: nvl(p_contact_id,hr_api.g_number))
656: or (p_nota_history_id is null)) then
657: --
658: hr_utility.set_location('Entering:'||l_proc, 10);

Line 655: nvl(p_contact_id,hr_api.g_number))

651: hr_utility.set_location('Entering:'||l_proc, 5);
652:
653: if (((p_nota_history_id is not null) and
654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>
655: nvl(p_contact_id,hr_api.g_number))
656: or (p_nota_history_id is null)) then
657: --
658: hr_utility.set_location('Entering:'||l_proc, 10);
659:

Line 709: hr_api.mandatory_arg_error

705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: --
707: -- check mandatory parameters has been set
708: --
709: hr_api.mandatory_arg_error
710: (p_api_name => l_proc
711: ,p_argument => 'effective_date'
712: ,p_argument_value =>p_effective_date);
713:

Line 716: nvl(ota_nhs_shd.g_old_rec.status,hr_api.g_varchar2) <>

712: ,p_argument_value =>p_effective_date);
713:
714:
715: if (((p_nota_history_id is not null) and
716: nvl(ota_nhs_shd.g_old_rec.status,hr_api.g_varchar2) <>
717: nvl(p_status,hr_api.g_varchar2))
718: or
719: (p_nota_history_id is null)) then
720:

Line 717: nvl(p_status,hr_api.g_varchar2))

713:
714:
715: if (((p_nota_history_id is not null) and
716: nvl(ota_nhs_shd.g_old_rec.status,hr_api.g_varchar2) <>
717: nvl(p_status,hr_api.g_varchar2))
718: or
719: (p_nota_history_id is null)) then
720:
721: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 728: if hr_api.not_exists_in_hr_lookups -- Bug 2478551

724: -- check if the status value exists in hr_lookups
725: -- where lookup_type is 'OTA_TRAINING_STATUSES'
726: --
727: if p_status is not null then
728: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
729: (p_effective_date => p_effective_date
730: ,p_lookup_type => 'OTA_TRAINING_STATUSES'
731: ,p_lookup_code => p_status) then
732: fnd_message.set_name('OTA','OTA_13880_NHS_STATUS_INVALID');

Line 760: hr_api.mandatory_arg_error

756: hr_utility.set_location(' Leaving:'||l_proc, 10);
757: --
758: -- check mandatory parameters has been set
759: --
760: hr_api.mandatory_arg_error
761: (p_api_name => l_proc
762: ,p_argument => 'effective_date'
763: ,p_argument_value => p_effective_date);
764:

Line 766: nvl(ota_nhs_shd.g_old_rec.type,hr_api.g_varchar2) <>

762: ,p_argument => 'effective_date'
763: ,p_argument_value => p_effective_date);
764:
765: if (((p_nota_history_id is not null) and
766: nvl(ota_nhs_shd.g_old_rec.type,hr_api.g_varchar2) <>
767: nvl(p_type,hr_api.g_varchar2))
768: or
769: (p_nota_history_id is null)) then
770:

Line 767: nvl(p_type,hr_api.g_varchar2))

763: ,p_argument_value => p_effective_date);
764:
765: if (((p_nota_history_id is not null) and
766: nvl(ota_nhs_shd.g_old_rec.type,hr_api.g_varchar2) <>
767: nvl(p_type,hr_api.g_varchar2))
768: or
769: (p_nota_history_id is null)) then
770:
771: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 778: if hr_api.not_exists_in_hr_lookups -- Bug 2478551

774: -- check if the status value exists in hr_lookups
775: -- where lookup_type is 'OTA_TRAINING_TYPES'
776: --
777: if p_type is not null then
778: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
779: (p_effective_date => p_effective_date
780: ,p_lookup_type => 'OTA_TRAINING_TYPES'
781: ,p_lookup_code => p_type) then
782: fnd_message.set_name('OTA','OTA_13879_NHS_TYPE_INVALID');

Line 812: hr_api.mandatory_arg_error

808: hr_utility.set_location(' Leaving:'||l_proc, 10);
809: --
810: -- check mandatory parameters has been set
811: --
812: hr_api.mandatory_arg_error
813: (p_api_name => l_proc
814: ,p_argument => 'effective_date'
815: ,p_argument_value => p_effective_date);
816:

Line 819: nvl(ota_nhs_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>

815: ,p_argument_value => p_effective_date);
816:
817:
818: if (((p_nota_history_id is not null) and
819: nvl(ota_nhs_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
820: nvl(p_duration_units,hr_api.g_varchar2))
821: or
822: (p_nota_history_id is null)) then
823:

Line 820: nvl(p_duration_units,hr_api.g_varchar2))

816:
817:
818: if (((p_nota_history_id is not null) and
819: nvl(ota_nhs_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
820: nvl(p_duration_units,hr_api.g_varchar2))
821: or
822: (p_nota_history_id is null)) then
823:
824: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 831: if hr_api.not_exists_in_hr_lookups -- Bug 2478551

827: -- check if the status value exists in hr_lookups
828: -- where lookup_type is 'FREQUENCY'
829: --
830: if p_duration_units is not null then
831: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
832: (p_effective_date => p_effective_date
833: ,p_lookup_type => 'OTA_DURATION_UNITS'
834: ,p_lookup_code => p_duration_units) then
835: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');

Line 928: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: -- Call all supporting business operations
927: --
928: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
929: --
930:
931: /*chk_organization_id(p_rec.nota_history_id
932: ,p_rec.organization_id

Line 989: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

985: hr_utility.set_location('Entering:'||l_proc, 5);
986: --
987: -- Call all supporting business operations
988: --
989: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
990: --
991:
992: chk_non_updateable_args
993: (p_effective_date => p_effective_date