DBA Data[Home] [Help]

APPS.GHR_PRH_DEL dependencies on HR_UTILITY

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

47: l_proc varchar2(72);
48: --
49: Begin
50: l_proc := g_package||'delete_dml';
51: hr_utility.set_location('Entering:'||l_proc, 5);
52: --
53:
54: -- Delete the ghr_pa_routing_history row.
55: --

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

56: delete from ghr_pa_routing_history
57: where pa_routing_history_id = p_rec.pa_routing_history_id;
58: --
59:
60: hr_utility.set_location(' Leaving:'||l_proc, 10);
61: --
62: Exception
63: When hr_api.child_integrity_violated then
64: -- Child integrity has been violated

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

105: l_proc varchar2(72) ;
106: --
107: Begin
108: l_proc := g_package||'pre_delete';
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: End pre_delete;
113: --

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

107: Begin
108: l_proc := g_package||'pre_delete';
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: End pre_delete;
113: --
114: -- ----------------------------------------------------------------------------
115: -- |-----------------------------< post_delete >------------------------------|

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

148: l_proc varchar2(72) ;
149: --
150: Begin
151: l_proc := g_package||'post_delete';
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: -- This is a hook point and the user hook for post_delete is called here.
155: --
156: begin

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

193: );
194: end;
195: -- End of API User Hook for post_delete.
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End post_delete;
199: --
200: -- ----------------------------------------------------------------------------
201: -- |---------------------------------< del >----------------------------------|

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

209: l_proc varchar2(72);
210: --
211: Begin
212: l_proc := g_package||'del';
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- Determine if the business process is to be validated.
216: --
217: If p_validate then

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

250: If p_validate then
251: Raise HR_Api.Validate_Enabled;
252: End If;
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 10);
255: Exception
256: When HR_Api.Validate_Enabled Then
257: --
258: -- As the Validate_Enabled exception has been raised

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

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

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

291: -- business process
292: --
293: del(l_rec, p_validate);
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End del;
297: --
298: end ghr_prh_del;