DBA Data[Home] [Help]

APPS.PER_ASN_DEL dependencies on HR_UTILITY

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

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

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

53: --
54: delete from per_assessments
55: where assessment_id = p_rec.assessment_id;
56: --
57: hr_utility.set_location(' Leaving:'||l_proc, 10);
58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated

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

101: --
102: l_proc varchar2(72) := g_package||'pre_delete';
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: End pre_delete;
109: --

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

103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: End pre_delete;
109: --
110: -- ----------------------------------------------------------------------------
111: -- |-----------------------------< post_delete >------------------------------|

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

143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: -- This is a hook point and the user hook for post_delete is called here.
150: --
151: begin

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

197: );
198: end;
199: -- End of API User Hook for post_delete.
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End post_delete;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |---------------------------------< del >----------------------------------|

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

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

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

263: If p_validate then
264: Raise HR_Api.Validate_Enabled;
265: End If;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: Exception
269: When HR_Api.Validate_Enabled Then
270: --
271: -- As the Validate_Enabled exception has been raised

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

287: l_rec per_asn_shd.g_rec_type;
288: l_proc varchar2(72) := g_package||'del';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- As the delete procedure accepts a plsql record structure we do need to
294: -- convert the arguments into the record structure.
295: -- We don't need to call the supplied conversion argument routine as we

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

303: -- business process
304: --
305: del(l_rec, p_validate);
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: End del;
309: --
310: end per_asn_del;