DBA Data[Home] [Help]

APPS.PAY_ECU_SHD dependencies on HR_UTILITY

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

63:
64: l_proc varchar2(72) := g_package||'check_unique_constraint';
65: l_dummy varchar2(2);
66: begin
67: hr_utility.set_location('Entering '|| l_proc, 10);
68: open csr_chk_unique_constrnt;
69: fetch csr_chk_unique_constrnt into l_dummy;
70: if (csr_chk_unique_constrnt%found) then
71: close csr_chk_unique_constrnt;

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

164: --
165: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
166: --
167: Begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: -- Call the corresponding datetrack api
171: --
172: dt_api.find_dt_upd_modes

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

179: ,p_update_override => p_update_override
180: ,p_update_change_insert => p_update_change_insert
181: );
182: --
183: hr_utility.set_location(' Leaving:'||l_proc, 10);
184: End find_dt_upd_modes;
185: --
186: -- ----------------------------------------------------------------------------
187: -- |---------------------------< find_dt_del_modes >--------------------------|

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

198: l_proc varchar2(72) := g_package||'find_dt_del_modes';
199: --
200: --
201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- Call the corresponding datetrack api
205: --
206: dt_api.find_dt_del_modes

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

213: ,p_future_change => p_future_change
214: ,p_delete_next_change => p_delete_next_change
215: );
216: --
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: End find_dt_del_modes;
219: --
220: -- ----------------------------------------------------------------------------
221: -- |-----------------------< upd_effective_end_date >-------------------------|

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

232: l_proc varchar2(72) := g_package||'upd_effective_end_date';
233: l_object_version_number number;
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: -- Because we are updating a row we must get the next object
239: -- version number.
240: --

Line 248: hr_utility.set_location(l_proc, 10);

244: ,p_base_key_column => 'element_class_usage_id'
245: ,p_base_key_value => p_base_key_value
246: );
247: --
248: hr_utility.set_location(l_proc, 10);
249: --
250: --
251: -- Update the specified datetrack row setting the effective
252: -- end date to the specified new effective end date.

Line 263: hr_utility.set_location(' Leaving:'||l_proc, 15);

259: between t.effective_start_date and t.effective_end_date;
260: --
261: --
262: p_object_version_number := l_object_version_number;
263: hr_utility.set_location(' Leaving:'||l_proc, 15);
264: --
265: End upd_effective_end_date;
266: --
267: -- ----------------------------------------------------------------------------

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

302: --
303: --
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: -- Ensure that all the mandatory arguments are not null
309: --
310: hr_api.mandatory_arg_error(p_api_name => l_proc

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

380: --
381: p_validation_start_date := l_validation_start_date;
382: p_validation_end_date := l_validation_end_date;
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 30);
385: --
386: -- We need to trap the ORA LOCK exception
387: --
388: Exception