APPS.OTA_TDB_DEL dependencies on HR_UTILITY

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

56: --
57: l_proc varchar2(72) := g_package||'delete_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: --
62: ota_tdb_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Delete the ota_delegate_bookings row.

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

67: where booking_id = p_rec.booking_id;
68: --
69: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 10);
72: --
73: Exception
74: When hr_api.child_integrity_violated then
75: -- Child integrity has been violated

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

122:
123: l_proc varchar2(72) := g_package||'pre_delete';
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128:
129: --
130: -- Get the event id before deleting, in case the event status needs to

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

142: delete from ota_booking_status_histories
143: where booking_id = p_rec.booking_id;
144: --
145:
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: End pre_delete;
148: --
149: -- ----------------------------------------------------------------------------
150: -- |-----------------------------< post_delete >------------------------------|

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

198: v_forum_id number;
199: v_object_version_number number;
200: --
201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204:
205: ota_evt_shd.get_event_details(g_event_id,
206: l_event_rec,

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

262: Close c_get_forum_id;
263:
264:
265:
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: End post_delete;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |---------------------------------< del >----------------------------------|

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

277: --
278: l_proc varchar2(72) := g_package||'del';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- Determine if the business process is to be validated.
284: --
285: If p_validate then

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

318: If p_validate then
319: Raise HR_Api.Validate_Enabled;
320: End If;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 10);
323: Exception
324: When HR_Api.Validate_Enabled Then
325: --
326: -- As the Validate_Enabled exception has been raised

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

342: l_rec ota_tdb_shd.g_rec_type;
343: l_proc varchar2(72) := g_package||'del';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- As the delete procedure accepts a plsql record structure we do need to
349: -- convert the arguments into the record structure.
350: -- We don't need to call the supplied conversion argument routine as we

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

358: -- business process
359: --
360: del(l_rec, p_validate);
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 10);
363: End del;
364: --
365: end ota_tdb_del;