APPS.OTA_CME_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_cme_ins.g_cert_mbr_enrollment_id_i := p_cert_mbr_enrollment_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_cme_ins.g_cert_mbr_enrollment_id_i := p_cert_mbr_enrollment_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 152: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

223: l_proc varchar2(72) := g_package||'pre_insert';
224: l_exists varchar2(1);
225: --
226: Begin
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: If (ota_cme_ins.g_cert_mbr_enrollment_id_i is not null) Then
230: --
231: -- Verify registered primary key values not already in use

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

259: Fetch C_Sel1 Into p_rec.cert_mbr_enrollment_id;
260: Close C_Sel1;
261: End If;
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: End pre_insert;
265: --
266: -- ----------------------------------------------------------------------------
267: -- |-----------------------------< post_insert >------------------------------|

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

302: --
303: l_proc varchar2(72) := g_package||'post_insert';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: begin
308: --
309: ota_cme_rki.after_insert
310: (p_effective_date => p_effective_date

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

375: ,p_hook_type => 'AI');
376: --
377: end;
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: End post_insert;
381: --
382: -- ----------------------------------------------------------------------------
383: -- |---------------------------------< ins >----------------------------------|

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

389: --
390: l_proc varchar2(72) := g_package||'ins';
391: --
392: Begin
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: --
395: -- Call the supporting insert validate operations
396: --
397: ota_cme_bus.insert_validate

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

419: --
420: -- Call to raise any errors on multi-message list
421: hr_multi_message.end_validation_set;
422: --
423: hr_utility.set_location('Leaving:'||l_proc, 20);
424: end ins;
425: --
426: -- ----------------------------------------------------------------------------
427: -- |---------------------------------< ins >----------------------------------|

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

461: l_rec ota_cme_shd.g_rec_type;
462: l_proc varchar2(72) := g_package||'ins';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: -- Call conversion function to turn arguments into the
468: -- p_rec structure.
469: --

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

512: --
513: p_cert_mbr_enrollment_id := l_rec.cert_mbr_enrollment_id;
514: p_object_version_number := l_rec.object_version_number;
515: --
516: hr_utility.set_location(' Leaving:'||l_proc, 10);
517: End ins;
518: --
519: end ota_cme_ins;