DBA Data[Home] [Help]

APPS.GHR_PDC_UPD dependencies on HR_UTILITY

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

55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;

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

77: where pd_classification_id = p_rec.pd_classification_id;
78: --
79: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated

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

137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --

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

139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_update >------------------------------|

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

179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: -- This is a hook point and the user hook for post_update is called here.
186: --
187: begin

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

211: );
212: end;
213: -- End of API User Hook for post_update.
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: End post_update;
217: --
218: -- ----------------------------------------------------------------------------
219: -- |-----------------------------< convert_defs >-----------------------------|

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

264: l_proc varchar2(72) := g_package||'convert_defs';
265: --
266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: --
270: -- We must now examine each argument value in the
271: -- p_rec plsql record structure
272: -- to see if a system default is being used. If a system default

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

297: ghr_pdc_shd.g_old_rec.grade_level;
298: End If;
299:
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 10);
302: --
303: End convert_defs;
304: --
305: -- ----------------------------------------------------------------------------

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

312: --
313: l_proc varchar2(72) := g_package||'upd';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- We must lock the row which we need to update.
319: --
320: ghr_pdc_shd.lck

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

363: l_rec ghr_pdc_shd.g_rec_type;
364: l_proc varchar2(72) := g_package||'upd';
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: hr_utility.set_location('pdc id:' || to_char(p_pd_classification_id) ||l_proc, 5);
369: hr_utility.set_location('pd id:' || to_char(p_position_description_id)||l_proc, 5);
370: hr_utility.set_location('ovn :' || to_char(p_position_description_id)||l_proc, 5);
371: --

Line 368: hr_utility.set_location('pdc id:' || to_char(p_pd_classification_id) ||l_proc, 5);

364: l_proc varchar2(72) := g_package||'upd';
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: hr_utility.set_location('pdc id:' || to_char(p_pd_classification_id) ||l_proc, 5);
369: hr_utility.set_location('pd id:' || to_char(p_position_description_id)||l_proc, 5);
370: hr_utility.set_location('ovn :' || to_char(p_position_description_id)||l_proc, 5);
371: --
372: -- Call conversion function to turn arguments into the

Line 369: hr_utility.set_location('pd id:' || to_char(p_position_description_id)||l_proc, 5);

365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: hr_utility.set_location('pdc id:' || to_char(p_pd_classification_id) ||l_proc, 5);
369: hr_utility.set_location('pd id:' || to_char(p_position_description_id)||l_proc, 5);
370: hr_utility.set_location('ovn :' || to_char(p_position_description_id)||l_proc, 5);
371: --
372: -- Call conversion function to turn arguments into the
373: -- l_rec structure.

Line 370: hr_utility.set_location('ovn :' || to_char(p_position_description_id)||l_proc, 5);

366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: hr_utility.set_location('pdc id:' || to_char(p_pd_classification_id) ||l_proc, 5);
369: hr_utility.set_location('pd id:' || to_char(p_position_description_id)||l_proc, 5);
370: hr_utility.set_location('ovn :' || to_char(p_position_description_id)||l_proc, 5);
371: --
372: -- Call conversion function to turn arguments into the
373: -- l_rec structure.
374: --

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

391: --
392: upd(l_rec);
393: p_object_version_number := l_rec.object_version_number;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End upd;
397: --
398: end ghr_pdc_upd;