APPS.PSP_PRT_DEL dependencies on HR_UTILITY

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

54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: psp_prt_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the psp_report_templates row.

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

65: where template_id = p_rec.template_id;
66: --
67: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated

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

115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: End pre_delete;
123: --

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

117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: End pre_delete;
123: --
124: -- ----------------------------------------------------------------------------
125: -- |-----------------------------< post_delete >------------------------------|

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

157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin
161: hr_utility.set_location('Entering:'||l_proc, 5);
162: begin
163: --
164: psp_prt_rkd.after_delete
165: (p_template_id

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

215: ,p_hook_type => 'AD');
216: --
217: end;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: End post_delete;
221: --
222: -- ----------------------------------------------------------------------------
223: -- |---------------------------------< del >----------------------------------|

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

228: --
229: l_proc varchar2(72) := g_package||'del';
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: -- We must lock the row which we need to delete.
235: --
236: psp_prt_shd.lck

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

273: l_rec psp_prt_shd.g_rec_type;
274: l_proc varchar2(72) := g_package||'del';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- As the delete procedure accepts a plsql record structure we do need to
280: -- convert the arguments into the record structure.
281: -- We don't need to call the supplied conversion argument routine as we

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

289: -- business process
290: --
291: psp_prt_del.del(l_rec);
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: End del;
295: --
296: end psp_prt_del;