DBA Data[Home] [Help]

APPS.OTA_LME_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_lme_ins.g_lp_member_enrollment_id_i := p_lp_member_enrollment_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_lme_ins.g_lp_member_enrollment_id_i := p_lp_member_enrollment_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 180: hr_utility.set_location(' Leaving:'||l_proc, 10);

176: );
177: --
178: --
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: Exception
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: --

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

251: l_proc varchar2(72) := g_package||'pre_insert';
252: l_exists varchar2(1);
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: If (ota_lme_ins.g_lp_member_enrollment_id_i is not null) Then
258: --
259: -- Verify registered primary key values not already in use

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

287: Fetch C_Sel1 Into p_rec.lp_member_enrollment_id;
288: Close C_Sel1;
289: End If;
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 10);
292: End pre_insert;
293: --
294: -- ----------------------------------------------------------------------------
295: -- |-----------------------------< post_insert >------------------------------|

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

330: --
331: l_proc varchar2(72) := g_package||'post_insert';
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: begin
336: --
337: ota_lme_rki.after_insert
338: (p_effective_date => p_effective_date

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

431: ,p_hook_type => 'AI');
432: --
433: end;
434: --
435: hr_utility.set_location(' Leaving:'||l_proc, 10);
436: End post_insert;
437: --
438: -- ----------------------------------------------------------------------------
439: -- |---------------------------------< ins >----------------------------------|

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

445: --
446: l_proc varchar2(72) := g_package||'ins';
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);
450: --
451: -- Call the supporting insert validate operations
452: --
453: ota_lme_bus.insert_validate

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

475: --
476: -- Call to raise any errors on multi-message list
477: hr_multi_message.end_validation_set;
478: --
479: hr_utility.set_location('Leaving:'||l_proc, 20);
480: end ins;
481: --
482: -- ----------------------------------------------------------------------------
483: -- |---------------------------------< ins >----------------------------------|

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

531: l_rec ota_lme_shd.g_rec_type;
532: l_proc varchar2(72) := g_package||'ins';
533: --
534: Begin
535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: -- Call conversion function to turn arguments into the
538: -- p_rec structure.
539: --

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

596: --
597: p_lp_member_enrollment_id := l_rec.lp_member_enrollment_id;
598: p_object_version_number := l_rec.object_version_number;
599: --
600: hr_utility.set_location(' Leaving:'||l_proc, 10);
601: End ins;
602: --
603: end ota_lme_ins;