DBA Data[Home] [Help]

APPS.OTA_LPM_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_lpm_ins.g_learning_path_member_id_i := p_learning_path_member_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_lpm_ins.g_learning_path_member_id_i := p_learning_path_member_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --
32: --
33: -- ----------------------------------------------------------------------------

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

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

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

155: );
156: --
157: --
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: --

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

230: l_proc varchar2(72) := g_package||'pre_insert';
231: l_exists varchar2(1);
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: If (ota_lpm_ins.g_learning_path_member_id_i is not null) Then
237: --
238: -- Verify registered primary key values not already in use

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

266: Fetch C_Sel1 Into p_rec.learning_path_member_id;
267: Close C_Sel1;
268: End If;
269: --
270: hr_utility.set_location(' Leaving:'||l_proc, 10);
271: End pre_insert;
272: --
273: -- ----------------------------------------------------------------------------
274: -- |-----------------------------< post_insert >------------------------------|

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

309: --
310: l_proc varchar2(72) := g_package||'post_insert';
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: begin
315: --
316: ota_lpm_rki.after_insert
317: (p_effective_date => p_effective_date

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

388: ,p_hook_type => 'AI');
389: --
390: end;
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: End post_insert;
394: --
395: -- ----------------------------------------------------------------------------
396: -- |---------------------------------< ins >----------------------------------|

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

402: --
403: l_proc varchar2(72) := g_package||'ins';
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Call the supporting insert validate operations
409: --
410: ota_lpm_bus.insert_validate

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

432: --
433: -- Call to raise any errors on multi-message list
434: hr_multi_message.end_validation_set;
435: --
436: hr_utility.set_location('Leaving:'||l_proc, 20);
437: end ins;
438: --
439: -- ----------------------------------------------------------------------------
440: -- |---------------------------------< ins >----------------------------------|

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

477: l_rec ota_lpm_shd.g_rec_type;
478: l_proc varchar2(72) := g_package||'ins';
479: --
480: Begin
481: hr_utility.set_location('Entering:'||l_proc, 5);
482: --
483: -- Call conversion function to turn arguments into the
484: -- p_rec structure.
485: --

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

531: --
532: p_learning_path_member_id := l_rec.learning_path_member_id;
533: p_object_version_number := l_rec.object_version_number;
534: --
535: hr_utility.set_location(' Leaving:'||l_proc, 10);
536: End ins;
537: --
538: end ota_lpm_ins;