APPS.OTA_FOI_INS dependencies on HR_UTILITY

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

24: --
25: l_proc varchar2(72) := g_package||'set_base_key_value';
26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ota_foi_ins.g_forum_id_i := p_forum_id;
31: ota_foi_ins.g_object_id_i := p_object_id;
32: ota_foi_ins.g_object_type_i := p_object_type;

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

30: ota_foi_ins.g_forum_id_i := p_forum_id;
31: ota_foi_ins.g_object_id_i := p_object_id;
32: ota_foi_ins.g_object_type_i := p_object_type;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --
37: --
38: -- ----------------------------------------------------------------------------

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

84: --
85: l_proc varchar2(72) := g_package||'insert_dml';
86: --
87: Begin
88: hr_utility.set_location('Entering:'||l_proc, 5);
89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: --
92: --

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

112: );
113: --
114: --
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --

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

193: l_proc varchar2(72) := g_package||'pre_insert';
194: l_exists varchar2(1);
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: /*
200: If (ota_foi_ins.g_forum_id_i is not null or
201: ota_foi_ins.g_object_id_i is not null or

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

239: Close C_Sel1;
240: End If;
241: */
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: End pre_insert;
245: --
246: -- ----------------------------------------------------------------------------
247: -- |-----------------------------< post_insert >------------------------------|

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

282: --
283: l_proc varchar2(72) := g_package||'post_insert';
284: --
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 5);
287: begin
288: --
289: ota_foi_rki.after_insert
290: (p_effective_date => p_effective_date

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

313: ,p_hook_type => 'AI');
314: --
315: end;
316: --
317: hr_utility.set_location(' Leaving:'||l_proc, 10);
318: End post_insert;
319: --
320: -- ----------------------------------------------------------------------------
321: -- |---------------------------------< ins >----------------------------------|

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

331: l_object_type ota_frm_obj_inclusions.object_type%TYPE;
332:
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: l_forum_id := p_rec.forum_id;
338: l_object_id := p_rec.object_id;
339: l_object_type := p_rec.object_type;

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

378: --
379: -- Call to raise any errors on multi-message list
380: hr_multi_message.end_validation_set;
381: --
382: hr_utility.set_location('Leaving:'||l_proc, 20);
383: end ins;
384: --
385: -- ----------------------------------------------------------------------------
386: -- |---------------------------------< ins >----------------------------------|

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

402: l_rec ota_foi_shd.g_rec_type;
403: l_proc varchar2(72) := g_package||'ins';
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Call conversion function to turn arguments into the
409: -- p_rec structure.
410: --

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

438: --p_object_id := l_rec.object_id;
439: --p_object_type := l_rec.object_type;
440: p_object_version_number := l_rec.object_version_number;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 10);
443: End ins;
444: --
445: end ota_foi_ins;