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 163: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

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

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

270: Fetch C_Sel1 Into p_rec.category_usage_id;
271: Close C_Sel1;
272: End If;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: End pre_insert;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |-----------------------------< post_insert >------------------------------|

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

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

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

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

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

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

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

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

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

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

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

543: --
544: p_category_usage_id := l_rec.category_usage_id;
545: p_object_version_number := l_rec.object_version_number;
546: --
547: hr_utility.set_location(' Leaving:'||l_proc, 10);
548: End ins;
549: --
550: end ota_ctu_ins;