DBA Data[Home] [Help]

APPS.OTA_NHS_INS dependencies on HR_UTILITY

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

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

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

25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: ota_nhs_ins.g_nota_history_id_i := p_nota_history_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --
32: --
33:

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: ota_nhs_shd.g_api_dml := true; -- Set the api dml status
86: --

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

174: );
175: --
176: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: Exception
180: When hr_api.check_integrity_violated Then
181: -- A check constraint has been violated
182: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

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

247: l_exists varchar2(1);
248: l_proc varchar2(72) := g_package||'pre_insert';
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: If (ota_nhs_ins.g_nota_history_id_i is not null) Then
254: --
255: -- Verify registered primary key values not already in use

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

283: Close C_Sel1;
284: --
285: End If;
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: End pre_insert;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |-----------------------------< post_insert >------------------------------|

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

324: --
325: l_proc varchar2(72) := g_package||'post_insert';
326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: --
330: begin
331: --
332: ota_nhs_rki.after_insert

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

424: ,p_hook_type => 'AI');
425: --
426: end;
427:
428: hr_utility.set_location(' Leaving:'||l_proc, 10);
429: End post_insert;
430: --
431: -- ----------------------------------------------------------------------------
432: -- |---------------------------------< ins >----------------------------------|

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

438: --
439: l_proc varchar2(72) := g_package||'ins';
440: --
441: Begin
442: hr_utility.set_location('Entering:'||l_proc, 5);
443: --
444: -- Call the supporting insert validate operations
445: --
446: ota_nhs_bus.insert_validate(p_effective_date ,

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

511: l_rec ota_nhs_shd.g_rec_type;
512: l_proc varchar2(72) := g_package||'ins';
513: --
514: Begin
515: hr_utility.set_location('Entering:'||l_proc, 5);
516: --
517: -- Call conversion function to turn arguments into the
518: -- p_rec structure.
519: --

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

574: --
575: p_nota_history_id := l_rec.nota_history_id;
576: p_object_version_number := l_rec.object_version_number;
577: --
578: hr_utility.set_location(' Leaving:'||l_proc, 10);
579: End ins;
580: --
581: end ota_nhs_ins;