DBA Data[Home] [Help]

APPS.PQH_DOC_SHD dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

220: ,p_base_key_column => 'document_id'
221: ,p_base_key_value => p_base_key_value
222: );
223: --
224: hr_utility.set_location(l_proc, 10);
225: pqh_doc_shd.g_api_dml := true; -- Set the api dml status
226: --
227: -- Update the specified datetrack row setting the effective
228: -- end date to the specified new effective end date.

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

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

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

290: --
291: --
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Ensure that all the mandatory arguments are not null
297: --
298: hr_utility.set_location('Entering:'||p_effective_date||'docid'||p_document_id||l_proc, 5);

Line 298: hr_utility.set_location('Entering:'||p_effective_date||'docid'||p_document_id||l_proc, 5);

294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Ensure that all the mandatory arguments are not null
297: --
298: hr_utility.set_location('Entering:'||p_effective_date||'docid'||p_document_id||l_proc, 5);
299: hr_api.mandatory_arg_error(p_api_name => l_proc
300: ,p_argument => 'effective_date'
301: ,p_argument_value => p_effective_date
302: );

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

372: --
373: p_validation_start_date := l_validation_start_date;
374: p_validation_end_date := l_validation_end_date;
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 30);
377: --
378: -- We need to trap the ORA LOCK exception
379: --
380: Exception