APPS.OTA_OCL_INS dependencies on HR_UTILITY

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

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --

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

124: );
125: --
126: --
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --

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

192: --
193: Cursor C_Sel1 is select ota_competence_languages_s.nextval from sys.dual;
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: --
199: -- Select the next sequence number
200: --

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

201: Open C_Sel1;
202: Fetch C_Sel1 Into p_rec.competence_language_id;
203: Close C_Sel1;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 10);
206: End pre_insert;
207: --
208: -- ----------------------------------------------------------------------------
209: -- |-----------------------------< post_insert >------------------------------|

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

244: --
245: l_proc varchar2(72) := g_package||'post_insert';
246: --
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: begin
250: --
251: ota_ocl_rki.after_insert
252: (p_effective_date => p_effective_date

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

315: ,p_hook_type => 'AI');
316: --
317: end;
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);
320: End post_insert;
321: --
322: -- ----------------------------------------------------------------------------
323: -- |---------------------------------< ins >----------------------------------|

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

329: --
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call the supporting insert validate operations
336: --
337: ota_ocl_bus.insert_validate

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

353: (p_effective_date
354: ,p_rec
355: );
356: --
357: hr_utility.set_location('Leaving:'||l_proc, 20);
358: end ins;
359: --
360: -- ----------------------------------------------------------------------------
361: -- |---------------------------------< ins >----------------------------------|

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

394: l_rec ota_ocl_shd.g_rec_type;
395: l_proc varchar2(72) := g_package||'ins';
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Call conversion function to turn arguments into the
401: -- p_rec structure.
402: --

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

444: --
445: p_competence_language_id := l_rec.competence_language_id;
446: p_object_version_number := l_rec.object_version_number;
447: --
448: hr_utility.set_location(' Leaving:'||l_proc, 10);
449: End ins;
450: --
451: end ota_ocl_ins;