APPS.OTA_LCI_INS dependencies on HR_UTILITY

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

22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ota_lci_ins.g_learning_path_id_i := p_learning_path_id;
29: ota_lci_ins.g_category_usage_id_i := p_category_usage_id;
30: --

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

27: --
28: ota_lci_ins.g_learning_path_id_i := p_learning_path_id;
29: ota_lci_ins.g_category_usage_id_i := p_category_usage_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------

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

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

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

149: );
150: --
151: --
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: Exception
155: When hr_api.check_integrity_violated Then
156: -- A check constraint has been violated
157: --

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

229: l_proc varchar2(72) := g_package||'pre_insert';
230: -- l_exists varchar2(1);
231: --
232: Begin
233: hr_utility.set_location('Entering:'||l_proc, 5);
234: --
235: /*
236: If (ota_lci_ins.g_learning_path_id_i is not null or
237: ota_lci_ins.g_category_usage_id_i is not null) Then

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

279: Close C_Sel1;
280: End If;
281: */
282: --
283: hr_utility.set_location(' Leaving:'||l_proc, 10);
284: End pre_insert;
285: --
286: -- ----------------------------------------------------------------------------
287: -- |-----------------------------< post_insert >------------------------------|

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

322: --
323: l_proc varchar2(72) := g_package||'post_insert';
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: begin
328: --
329: ota_lci_rki.after_insert
330: (p_effective_date => p_effective_date

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

393: ,p_hook_type => 'AI');
394: --
395: end;
396: --
397: hr_utility.set_location(' Leaving:'||l_proc, 10);
398: End post_insert;
399: --
400: -- ----------------------------------------------------------------------------
401: -- |---------------------------------< ins >----------------------------------|

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

409: l_learning_path_id OTA_LP_CAT_INCLUSIONS.learning_path_id%TYPE;
410: l_category_usage_id OTA_LP_CAT_INCLUSIONS.category_usage_id%TYPE;
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414:
415: l_learning_path_id := p_rec.learning_path_id;
416: l_category_usage_id := p_rec.category_usage_id;
417:

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

455: --
456: -- Call to raise any errors on multi-message list
457: hr_multi_message.end_validation_set;
458: --
459: hr_utility.set_location('Leaving:'||l_proc, 20);
460: end ins;
461: --
462: -- ----------------------------------------------------------------------------
463: -- |---------------------------------< ins >----------------------------------|

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

499: l_proc varchar2(72) := g_package||'ins';
500:
501: --
502: Begin
503: hr_utility.set_location('Entering:'||l_proc, 5);
504:
505: --
506: -- Call conversion function to turn arguments into the
507: -- p_rec structure.

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

551: -- p_learning_path_id := l_rec.learning_path_id;
552: -- p_category_usage_id := l_rec.category_usage_id;
553: p_object_version_number := l_rec.object_version_number;
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 10);
556: End ins;
557: --
558: end ota_lci_ins;