APPS.OTA_TDB_INS dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Entering:'||l_proc, 10);

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ota_tdb_ins.g_booking_id_i := p_booking_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 28: hr_utility.set_location(' Leaving:'||l_proc, 20);

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ota_tdb_ins.g_booking_id_i := p_booking_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |------------------------------< insert_dml >------------------------------|

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

75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: ota_tdb_shd.g_api_dml := true; -- Set the api dml status
83: --

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

241: );
242: --
243: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: Exception
247: When hr_api.check_integrity_violated Then
248: -- A check constraint has been violated
249: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

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

316: --
317: l_exists varchar2(1);
318: --
319: Begin
320: hr_utility.set_location('Entering:'||l_proc, 5);
321:
322: If (ota_tdb_ins.g_booking_id_i is not null) Then
323: --
324: -- Verify registered primary key values not already in use

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

352: Close C_Sel1;
353: --
354: End If;
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: End pre_insert;
358: --
359: -- ----------------------------------------------------------------------------
360: -- |-----------------------------< post_insert >------------------------------|

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

401: from ota_events
402: where event_id = p_rec.event_id;
403:
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: IF p_rec.line_id is not null then
408: l_return := ota_utility.check_wf_status(p_rec.line_id,'BLOCK');
409: IF l_return = TRUE THEN

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

426: END LOOP;
427:
428: END IF;
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 10);
431:
432:
433: End post_insert;
434: --

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

454: --
455: l_proc varchar2(72) := g_package||'ins';
456: --
457: Begin
458: hr_utility.set_location('Entering:'||l_proc, 5);
459: --
460: -- Determine if the business process is to be validated.
461: --
462: If p_validate then

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

487: If p_validate then
488: Raise HR_Api.Validate_Enabled;
489: End If;
490: --
491: hr_utility.set_location(' Leaving:'||l_proc, 10);
492: Exception
493: When HR_Api.Validate_Enabled Then
494: --
495: -- As the Validate_Enabled exception has been raised

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

595: l_rec ota_tdb_shd.g_rec_type;
596: l_proc varchar2(72) := g_package||'ins';
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Call conversion function to turn arguments into the
602: -- p_rec structure.
603: --

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

704: --
705: p_booking_id := l_rec.booking_id;
706: p_object_version_number := l_rec.object_version_number;
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 10);
709: End ins;
710: --
711: end ota_tdb_ins;
712: