APPS.BEN_PCG_DEL dependencies on HR_UTILITY

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

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

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

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

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

92:
93: l_prtt_reimbmt_rqst_stat_cd ben_prtt_reimbmt_rqst_f.prtt_reimbmt_rqst_stat_cd%TYPE; -- UTF8 varchar2(15) ;
94: --
95: Begin
96: hr_utility.set_location('Entering:'||l_proc, 5);
97: --
98: open c_prc ;
99: fetch c_prc into l_prtt_reimbmt_rqst_stat_cd ;
100: if c_prc%found then

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

109: end if ;
110: else
111: close c_prc ;
112: end if ;
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: End chk_reimbmt_status;
115:
116:
117:

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

151: --
152: l_proc varchar2(72) := g_package||'pre_delete';
153: --
154: Begin
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: End pre_delete;
159: --

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

153: --
154: Begin
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: End pre_delete;
159: --
160: -- ----------------------------------------------------------------------------
161: -- |-----------------------------< post_delete >------------------------------|

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

193: --
194: l_proc varchar2(72) := g_package||'post_delete';
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: --
200: -- Start of API User Hook for post_delete.
201: --

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

254: --
255: -- End of API User Hook for post_delete.
256: --
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: End post_delete;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |---------------------------------< del >----------------------------------|

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

268: --
269: l_proc varchar2(72) := g_package||'del';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- We must lock the row which we need to delete.
275: --
276: ben_pcg_shd.lck

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

309: l_rec ben_pcg_shd.g_rec_type;
310: l_proc varchar2(72) := g_package||'del';
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: -- As the delete procedure accepts a plsql record structure we do need to
316: -- convert the arguments into the record structure.
317: -- We don't need to call the supplied conversion argument routine as we

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

325: -- business process
326: --
327: del(l_rec);
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 10);
330: End del;
331: --
332: end ben_pcg_del;