DBA Data[Home] [Help]

APPS.PAY_RFI_SHD dependencies on HR_UTILITY

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

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

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

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

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

193: and p_effective_date
194: between m.effective_start_date and m.effective_end_date;
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: Open C_sel1;
199: Fetch C_Sel1 Into
200: l_parent_key_value1;
201: If C_Sel1%NOTFOUND then

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

222: ,p_future_change => p_future_change
223: ,p_delete_next_change => p_delete_next_change
224: );
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: End find_dt_del_modes;
228: --
229: -- ----------------------------------------------------------------------------
230: -- |-----------------------< upd_effective_end_date >-------------------------|

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

241: l_proc varchar2(72) := g_package||'upd_effective_end_date';
242: l_object_version_number number;
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: -- Because we are updating a row we must get the next object
248: -- version number.
249: --

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

253: ,p_base_key_column => 'report_format_item_id'
254: ,p_base_key_value => p_base_key_value
255: );
256: --
257: hr_utility.set_location(l_proc, 10);
258: pay_rfi_shd.g_api_dml := true; -- Set the api dml status
259: --
260: -- Update the specified datetrack row setting the effective
261: -- end date to the specified new effective end date.

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

268: between t.effective_start_date and t.effective_end_date;
269: --
270: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
271: p_object_version_number := l_object_version_number;
272: hr_utility.set_location(' Leaving:'||l_proc, 15);
273: --
274: Exception
275: When Others Then
276: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status

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

320: --
321: --
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: -- Ensure that all the mandatory arguments are not null
327: --
328: hr_api.mandatory_arg_error(p_api_name => l_proc

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

409: --
410: p_validation_start_date := l_validation_start_date;
411: p_validation_end_date := l_validation_end_date;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 30);
414: --
415: -- We need to trap the ORA LOCK exception
416: --
417: Exception

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

492: l_report_format_item_id PAY_REPORT_FORMAT_ITEMS_F.REPORT_FORMAT_ITEM_ID%TYPE;
493: --
494: Begin
495: --
496: hr_utility.set_location('Entering:'||l_proc, 5);
497:
498: if p_report_type is null or p_report_qualifier is null or
499: p_report_category is null or p_user_entity_id is null then
500:

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

528: end if;
529:
530: close csr_format_item_id;
531:
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
533:
534: return l_report_format_item_id;
535: --
536: End get_report_format_item_id;