APPS.OTA_OFF_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_off_ins.g_offering_id_i := p_offering_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_off_ins.g_offering_id_i := p_offering_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------

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

78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --

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

192: );
193: --
194: --
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: Exception
198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: --

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

267: l_proc varchar2(72) := g_package||'pre_insert';
268: l_exists varchar2(1);
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: If (ota_off_ins.g_offering_id_i is not null) Then
274: --
275: -- Verify registered primary key values not already in use

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

303: Fetch C_Sel1 Into p_rec.offering_id;
304: Close C_Sel1;
305: End If;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: End pre_insert;
309: --
310: -- ----------------------------------------------------------------------------
311: -- |-----------------------------< post_insert >------------------------------|

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

346: --
347: l_proc varchar2(72) := g_package||'post_insert';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: begin
352: --
353: ota_off_rki.after_insert
354: (p_effective_date => p_effective_date

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

460: ,p_hook_type => 'AI');
461: --
462: end;
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 10);
465: End post_insert;
466: --
467: -- ----------------------------------------------------------------------------
468: -- |---------------------------------< ins >----------------------------------|

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

475: --
476: l_proc varchar2(72) := g_package||'ins';
477: --
478: Begin
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: -- Call the supporting insert validate operations
482: --
483: ota_off_bus.insert_validate

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

506: --
507: -- Call to raise any errors on multi-message list
508: hr_multi_message.end_validation_set;
509: --
510: hr_utility.set_location('Leaving:'||l_proc, 20);
511: end ins;
512: --
513: -- ----------------------------------------------------------------------------
514: -- |---------------------------------< ins >----------------------------------|

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

571: l_rec ota_off_shd.g_rec_type;
572: l_proc varchar2(72) := g_package||'ins';
573: --
574: Begin
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: -- Call conversion function to turn arguments into the
578: -- p_rec structure.
579: --

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

646: --
647: p_offering_id := l_rec.offering_id;
648: p_object_version_number := l_rec.object_version_number;
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 10);
651: End ins;
652: --
653: end ota_off_ins;