DBA Data[Home] [Help]

APPS.PQH_GIN_SHD dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_gin_shd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |---------------------------< constraint_error >---------------------------|
13: -- ----------------------------------------------------------------------------

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

133: Begin
134:
135: If g_debug then
136: --
137: hr_utility.set_location('Entering:'||l_proc, 5);
138: --
139: End if;
140:
141: --

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

153: );
154: --
155: If g_debug then
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: --
159: End if;
160:
161: End find_dt_upd_modes;

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

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

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

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

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

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

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

221: ,p_base_key_column => 'global_index_id'
222: ,p_base_key_value => p_base_key_value
223: );
224: --
225: hr_utility.set_location(l_proc, 10);
226: --
227: --
228: -- Update the specified datetrack row setting the effective
229: -- end date to the specified new effective end date.

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

236: between t.effective_start_date and t.effective_end_date;
237: --
238: --
239: p_object_version_number := l_object_version_number;
240: hr_utility.set_location(' Leaving:'||l_proc, 15);
241: --
242: End upd_effective_end_date;
243: --
244: -- ----------------------------------------------------------------------------

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

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

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

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