APPS.OTA_CCI_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_cci_ins.g_category_usage_id_i := p_category_usage_id;
29: ota_cci_ins.g_certification_id_i := p_certification_id;
30: --

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

27: --
28: ota_cci_ins.g_category_usage_id_i := p_category_usage_id;
29: ota_cci_ins.g_certification_id_i := p_certification_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 232: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

272: Close C_Sel1;
273: End If;
274: */
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End pre_insert;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |-----------------------------< post_insert >------------------------------|

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

315: --
316: l_proc varchar2(72) := g_package||'post_insert';
317: --
318: Begin
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: begin
321: --
322: ota_cci_rki.after_insert
323: (p_effective_date => p_effective_date

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

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

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

403: l_category_usage_id OTA_CERT_CAT_INCLUSIONS.category_usage_id%TYPE;
404:
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408:
409: l_certification_id := p_rec.certification_id;
410: l_category_usage_id := p_rec.category_usage_id;
411:

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

441: --
442: -- Call to raise any errors on multi-message list
443: hr_multi_message.end_validation_set;
444: --
445: hr_utility.set_location('Leaving:'||l_proc, 20);
446: end ins;
447: --
448: -- ----------------------------------------------------------------------------
449: -- |---------------------------------< ins >----------------------------------|

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

484: l_rec ota_cci_shd.g_rec_type;
485: l_proc varchar2(72) := g_package||'ins';
486: --
487: Begin
488: hr_utility.set_location('Entering:'||l_proc, 5);
489: --
490: -- Call conversion function to turn arguments into the
491: -- p_rec structure.
492: --

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

535: --p_category_usage_id := l_rec.category_usage_id;
536: --p_certification_id := l_rec.certification_id;
537: p_object_version_number := l_rec.object_version_number;
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: End ins;
541: --
542: end ota_cci_ins;