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 247: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

708: --
709: p_booking_id := l_rec.booking_id;
710: p_object_version_number := l_rec.object_version_number;
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 10);
713: End ins;
714: --
715: end ota_tdb_ins;
716: