APPS.OTA_CTU_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_ctu_ins.g_category_usage_id_i := p_category_usage_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_ctu_ins.g_category_usage_id_i := p_category_usage_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 165: hr_utility.set_location(' Leaving:'||l_proc, 10);

161: );
162: --
163: --
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 10);
166: Exception
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: --

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

236: l_proc varchar2(72) := g_package||'pre_insert';
237: l_exists varchar2(1);
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: If (ota_ctu_ins.g_category_usage_id_i is not null) Then
243: --
244: -- Verify registered primary key values not already in use

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

272: Fetch C_Sel1 Into p_rec.category_usage_id;
273: Close C_Sel1;
274: End If;
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_ctu_rki.after_insert
323: (p_effective_date => p_effective_date

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

398: ,p_hook_type => 'AI');
399: --
400: end;
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: End post_insert;
404: --
405: -- ----------------------------------------------------------------------------
406: -- |---------------------------------< ins >----------------------------------|

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

412: --
413: l_proc varchar2(72) := g_package||'ins';
414: --
415: Begin
416: hr_utility.set_location('Entering:'||l_proc, 5);
417: --
418: -- Call the supporting insert validate operations
419: --
420: ota_ctu_bus.insert_validate

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

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

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

490: l_rec ota_ctu_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'ins';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);
495: --
496: -- Call conversion function to turn arguments into the
497: -- p_rec structure.
498: --

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

547: --
548: p_category_usage_id := l_rec.category_usage_id;
549: p_object_version_number := l_rec.object_version_number;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: End ins;
553: --
554: end ota_ctu_ins;