DBA Data[Home] [Help]

APPS.PER_SUB_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: per_sub_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_subjects_taken row.

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

63: where subjects_taken_id = p_rec.subjects_taken_id;
64: --
65: per_sub_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 117: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: -- Start of Row Handler User Hook for post_delete.
162: --
163: Begin

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

224: end;
225: --
226: -- End of Row Handler User Hook for post_delete.
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End post_delete;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |---------------------------------< del >----------------------------------|

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

239: --
240: l_proc varchar2(72) := g_package||'del';
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- Determine if the business process is to be validated.
246: --
247: If p_validate then

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

280: If p_validate then
281: Raise HR_Api.Validate_Enabled;
282: End If;
283: --
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: Exception
286: When HR_Api.Validate_Enabled Then
287: --
288: -- As the Validate_Enabled exception has been raised

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

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

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

320: -- business process
321: --
322: del(l_rec, p_validate);
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End del;
326: --
327: end per_sub_del;