DBA Data[Home] [Help]

APPS.PQH_DOA_SHD dependencies on HR_UTILITY

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

137: --
138: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: -- Call the corresponding datetrack api
144: --
145: dt_api.find_dt_upd_modes

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

152: ,p_update_override => p_update_override
153: ,p_update_change_insert => p_update_change_insert
154: );
155: --
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: End find_dt_upd_modes;
158: --
159: -- ----------------------------------------------------------------------------
160: -- |---------------------------< find_dt_del_modes >--------------------------|

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

171: l_proc varchar2(72) := g_package||'find_dt_del_modes';
172: --
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: -- Call the corresponding datetrack api
178: --
179: dt_api.find_dt_del_modes

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

186: ,p_future_change => p_future_change
187: ,p_delete_next_change => p_delete_next_change
188: );
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: End find_dt_del_modes;
192: --
193: -- ----------------------------------------------------------------------------
194: -- |-----------------------< upd_effective_end_date >-------------------------|

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

205: l_proc varchar2(72) := g_package||'upd_effective_end_date';
206: l_object_version_number number;
207: --
208: Begin
209: hr_utility.set_location('Entering:'||l_proc, 5);
210: --
211: -- Because we are updating a row we must get the next object
212: -- version number.
213: --

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

217: ,p_base_key_column => 'document_attribute_id'
218: ,p_base_key_value => p_base_key_value
219: );
220: --
221: hr_utility.set_location(l_proc, 10);
222: pqh_doa_shd.g_api_dml := true; -- Set the api dml status
223: --
224: -- Update the specified datetrack row setting the effective
225: -- end date to the specified new effective end date.

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

232: between t.effective_start_date and t.effective_end_date;
233: --
234: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
235: p_object_version_number := l_object_version_number;
236: hr_utility.set_location(' Leaving:'||l_proc, 15);
237: --
238: Exception
239: When Others Then
240: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status

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

279: --
280: --
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- Ensure that all the mandatory arguments are not null
286: --
287: hr_api.mandatory_arg_error(p_api_name => l_proc

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

360: --
361: p_validation_start_date := l_validation_start_date;
362: p_validation_end_date := l_validation_end_date;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 30);
365: --
366: -- We need to trap the ORA LOCK exception
367: --
368: Exception