DBA Data[Home] [Help]

APPS.PAY_CAL_SHD dependencies on HR_UTILITY

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

147: --
148: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
149: --
150: Begin
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: -- Call the corresponding datetrack api
154: --
155: dt_api.find_dt_upd_modes

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

162: ,p_update_override => p_update_override
163: ,p_update_change_insert => p_update_change_insert
164: );
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: End find_dt_upd_modes;
168: --
169: -- ----------------------------------------------------------------------------
170: -- |---------------------------< find_dt_del_modes >--------------------------|

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

181: l_proc varchar2(72) := g_package||'find_dt_del_modes';
182: --
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: -- Call the corresponding datetrack api
188: --
189: dt_api.find_dt_del_modes

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

196: ,p_future_change => p_future_change
197: ,p_delete_next_change => p_delete_next_change
198: );
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End find_dt_del_modes;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |-----------------------< upd_effective_end_date >-------------------------|

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

215: l_proc varchar2(72) := g_package||'upd_effective_end_date';
216: l_object_version_number number;
217: --
218: Begin
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: --
221: -- Because we are updating a row we must get the next object
222: -- version number.
223: --

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

227: ,p_base_key_column => 'cost_allocation_id'
228: ,p_base_key_value => p_base_key_value
229: );
230: --
231: hr_utility.set_location(l_proc, 10);
232:
233: hr_utility.set_location('p_effective_date:'|| p_effective_date, 10);
234: hr_utility.set_location('p_base_key_value:'|| p_base_key_value, 10);
235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);

Line 233: hr_utility.set_location('p_effective_date:'|| p_effective_date, 10);

229: );
230: --
231: hr_utility.set_location(l_proc, 10);
232:
233: hr_utility.set_location('p_effective_date:'|| p_effective_date, 10);
234: hr_utility.set_location('p_base_key_value:'|| p_base_key_value, 10);
235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);
236: hr_utility.set_location('p_validation_start_date:'|| p_validation_start_date, 10);
237: hr_utility.set_location('p_validation_end_date:'|| p_validation_end_date, 10);

Line 234: hr_utility.set_location('p_base_key_value:'|| p_base_key_value, 10);

230: --
231: hr_utility.set_location(l_proc, 10);
232:
233: hr_utility.set_location('p_effective_date:'|| p_effective_date, 10);
234: hr_utility.set_location('p_base_key_value:'|| p_base_key_value, 10);
235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);
236: hr_utility.set_location('p_validation_start_date:'|| p_validation_start_date, 10);
237: hr_utility.set_location('p_validation_end_date:'|| p_validation_end_date, 10);
238: hr_utility.set_location('p_object_version_number:'|| p_object_version_number, 10);

Line 235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);

231: hr_utility.set_location(l_proc, 10);
232:
233: hr_utility.set_location('p_effective_date:'|| p_effective_date, 10);
234: hr_utility.set_location('p_base_key_value:'|| p_base_key_value, 10);
235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);
236: hr_utility.set_location('p_validation_start_date:'|| p_validation_start_date, 10);
237: hr_utility.set_location('p_validation_end_date:'|| p_validation_end_date, 10);
238: hr_utility.set_location('p_object_version_number:'|| p_object_version_number, 10);
239: hr_utility.set_location('l_object_version_number:'|| l_object_version_number, 10);

Line 236: hr_utility.set_location('p_validation_start_date:'|| p_validation_start_date, 10);

232:
233: hr_utility.set_location('p_effective_date:'|| p_effective_date, 10);
234: hr_utility.set_location('p_base_key_value:'|| p_base_key_value, 10);
235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);
236: hr_utility.set_location('p_validation_start_date:'|| p_validation_start_date, 10);
237: hr_utility.set_location('p_validation_end_date:'|| p_validation_end_date, 10);
238: hr_utility.set_location('p_object_version_number:'|| p_object_version_number, 10);
239: hr_utility.set_location('l_object_version_number:'|| l_object_version_number, 10);
240:

Line 237: hr_utility.set_location('p_validation_end_date:'|| p_validation_end_date, 10);

233: hr_utility.set_location('p_effective_date:'|| p_effective_date, 10);
234: hr_utility.set_location('p_base_key_value:'|| p_base_key_value, 10);
235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);
236: hr_utility.set_location('p_validation_start_date:'|| p_validation_start_date, 10);
237: hr_utility.set_location('p_validation_end_date:'|| p_validation_end_date, 10);
238: hr_utility.set_location('p_object_version_number:'|| p_object_version_number, 10);
239: hr_utility.set_location('l_object_version_number:'|| l_object_version_number, 10);
240:
241: pay_cal_shd.g_api_dml := true; -- Set the api dml status

Line 238: hr_utility.set_location('p_object_version_number:'|| p_object_version_number, 10);

234: hr_utility.set_location('p_base_key_value:'|| p_base_key_value, 10);
235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);
236: hr_utility.set_location('p_validation_start_date:'|| p_validation_start_date, 10);
237: hr_utility.set_location('p_validation_end_date:'|| p_validation_end_date, 10);
238: hr_utility.set_location('p_object_version_number:'|| p_object_version_number, 10);
239: hr_utility.set_location('l_object_version_number:'|| l_object_version_number, 10);
240:
241: pay_cal_shd.g_api_dml := true; -- Set the api dml status
242: --

Line 239: hr_utility.set_location('l_object_version_number:'|| l_object_version_number, 10);

235: hr_utility.set_location('p_new_effective_end_date:'|| p_new_effective_end_date, 10);
236: hr_utility.set_location('p_validation_start_date:'|| p_validation_start_date, 10);
237: hr_utility.set_location('p_validation_end_date:'|| p_validation_end_date, 10);
238: hr_utility.set_location('p_object_version_number:'|| p_object_version_number, 10);
239: hr_utility.set_location('l_object_version_number:'|| l_object_version_number, 10);
240:
241: pay_cal_shd.g_api_dml := true; -- Set the api dml status
242: --
243: -- Update the specified datetrack row setting the effective

Line 254: hr_utility.set_location('after Update:', 20);

250: where t.cost_allocation_id = p_base_key_value
251: and p_effective_date
252: between t.effective_start_date and t.effective_end_date;
253: --
254: hr_utility.set_location('after Update:', 20);
255:
256: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
257: p_object_version_number := l_object_version_number;
258: hr_utility.set_location(' Leaving:'||l_proc, 15);

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

254: hr_utility.set_location('after Update:', 20);
255:
256: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
257: p_object_version_number := l_object_version_number;
258: hr_utility.set_location(' Leaving:'||l_proc, 15);
259: --
260: Exception
261: When Others Then
262: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

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