DBA Data[Home] [Help]

APPS.HR_ITL_BUS dependencies on HR_UTILITY

Line 120: hr_utility.set_location(' Entering:' || l_proc,10);

116:
117: Begin
118:
119:
120: hr_utility.set_location(' Entering:' || l_proc,10);
121:
122: open csr_id;
123: fetch csr_id into l_name;
124:

Line 132: hr_utility.set_location(' Leaving:' || l_proc,20);

128: end if;
129:
130: close csr_id;
131:
132: hr_utility.set_location(' Leaving:' || l_proc,20);
133:
134: Exception
135: when app_exception.application_exception then
136: IF hr_multi_message.exception_add

Line 139: hr_utility.set_location(' Leaving:'|| l_proc,30);

135: when app_exception.application_exception then
136: IF hr_multi_message.exception_add
137: (p_associated_column1 => 'HR_KI_INTEGRATIONS_TL.INTEGRATION_ID'
138: ) THEN
139: hr_utility.set_location(' Leaving:'|| l_proc,30);
140: raise;
141: END IF;
142:
143: hr_utility.set_location(' Leaving:'|| l_proc,40);

Line 143: hr_utility.set_location(' Leaving:'|| l_proc,40);

139: hr_utility.set_location(' Leaving:'|| l_proc,30);
140: raise;
141: END IF;
142:
143: hr_utility.set_location(' Leaving:'|| l_proc,40);
144: --
145: End chk_integration_id;
146:
147:

Line 193: hr_utility.set_location('Entering:'||l_proc,10);

189: l_check varchar2(1);
190:
191: --
192: Begin
193: hr_utility.set_location('Entering:'||l_proc,10);
194: --
195: -- Check value has been passed
196: --
197:

Line 204: hr_utility.set_location('Checking:'||l_proc,20);

200: ,p_argument => 'PARTNER_NAME'
201: ,p_argument_value => p_partner_name
202: );
203:
204: hr_utility.set_location('Checking:'||l_proc,20);
205:
206: hr_api.mandatory_arg_error
207: (p_api_name => l_proc
208: ,p_argument => 'SERVICE_NAME'

Line 211: hr_utility.set_location('Checking:'||l_proc,30);

207: (p_api_name => l_proc
208: ,p_argument => 'SERVICE_NAME'
209: ,p_argument_value => p_service_name
210: );
211: hr_utility.set_location('Checking:'||l_proc,30);
212:
213: ---First check if record already present in the table
214: --- for same id ,partner name and service name and language
215: ---If record exist then user is not updating the record

Line 220: hr_utility.set_location('After fetching:'||l_proc,40);

216: ---so NO validation is required
217:
218: open csr_name;
219: fetch csr_name into l_name;
220: hr_utility.set_location('After fetching:'||l_proc,40);
221: if (csr_name%found)
222: then
223: close csr_name;
224: fnd_message.set_name('PER','PER_449984_ITL_SNAME_DUPLICATE');

Line 229: hr_utility.set_location(' Leaving:'||l_proc,50);

225: fnd_message.raise_error;
226: end if;
227: close csr_name;
228:
229: hr_utility.set_location(' Leaving:'||l_proc,50);
230: exception
231: when app_exception.application_exception then
232: if hr_multi_message.exception_add
233: (p_associated_column1 => 'HR_KI_INTEGRATIONS_TL.SERVICE_NAME'

Line 235: hr_utility.set_location(' Leaving:'||l_proc, 60);

231: when app_exception.application_exception then
232: if hr_multi_message.exception_add
233: (p_associated_column1 => 'HR_KI_INTEGRATIONS_TL.SERVICE_NAME'
234: )then
235: hr_utility.set_location(' Leaving:'||l_proc, 60);
236: raise;
237: end if;
238: hr_utility.set_location(' Leaving:'||l_proc,70);
239: End CHK_SERVICE_NAME;

Line 238: hr_utility.set_location(' Leaving:'||l_proc,70);

234: )then
235: hr_utility.set_location(' Leaving:'||l_proc, 60);
236: raise;
237: end if;
238: hr_utility.set_location(' Leaving:'||l_proc,70);
239: End CHK_SERVICE_NAME;
240:
241: --
242: -- ----------------------------------------------------------------------------

Line 253: hr_utility.set_location('Entering:'||l_proc, 5);

249: --
250: l_proc varchar2(72) := g_package||'insert_validate';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: -- Call all supporting business operations
256: --
257: --

Line 276: hr_utility.set_location(' Leaving:'||l_proc, 10);

272: ,p_partner_name => p_rec.partner_name
273: ,p_service_name => p_rec.service_name
274: ,p_language => p_rec.language
275: );
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End insert_validate;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |---------------------------< update_validate >----------------------------|

Line 289: hr_utility.set_location('Entering:'||l_proc, 5);

285: --
286: l_proc varchar2(72) := g_package||'update_validate';
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Call all supporting business operations
292: --
293: --

Line 313: hr_utility.set_location(' Leaving:'||l_proc, 10);

309: ,p_language => p_rec.language
310: );
311: --
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: End update_validate;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |---------------------------< delete_validate >----------------------------|

Line 326: hr_utility.set_location('Entering:'||l_proc, 5);

322: --
323: l_proc varchar2(72) := g_package||'delete_validate';
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: -- Call all supporting business operations
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 330: hr_utility.set_location(' Leaving:'||l_proc, 10);

326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: -- Call all supporting business operations
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: End delete_validate;
332: --
333: end hr_itl_bus;