DBA Data[Home] [Help]

APPS.PER_PHN_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_phones row.
53: --
54: delete from per_phones

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

53: --
54: delete from per_phones
55: where phone_id = p_rec.phone_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: --
150: -- Start of API User Hook for post_delete.
151: begin

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

202: );
203: end;
204: -- End of API User Hook for post_delete.
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: End post_delete;
208: --
209: -- ----------------------------------------------------------------------------
210: -- |---------------------------------< del >----------------------------------|

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

217: --
218: l_proc varchar2(72) := g_package||'del';
219: --
220: Begin
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: -- Determine if the business process is to be validated.
224: --
225: If p_validate then

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

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

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

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

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

306: -- business process
307: --
308: del(l_rec, p_validate);
309: --
310: hr_utility.set_location(' Leaving:'||l_proc, 10);
311: End del;
312: --
313: end per_phn_del;