APPS.PER_VAC_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: per_vac_ins.g_vacancy_id_i := p_vacancy_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: per_vac_ins.g_vacancy_id_i := p_vacancy_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: per_vac_shd.g_api_dml := true; -- Set the api dml status
86: --

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

194: );
195: --
196: per_vac_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: Exception
200: When hr_api.check_integrity_violated then
201: -- A check constraint has been violated
202: per_vac_shd.g_api_dml := false; -- Unset the api dml status

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

270: l_proc varchar2(72) := g_package||'pre_insert';
271: l_exists varchar2(1);
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: if (per_vac_ins.g_vacancy_id_i is not null) then
277: --
278: -- Verify registered primary key values not already in use

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

306: Fetch C_Sel1 Into p_rec.vacancy_id;
307: Close C_Sel1;
308: end if;
309: --
310: hr_utility.set_location(' Leaving:'||l_proc, 10);
311: End pre_insert;
312: --
313: -- ----------------------------------------------------------------------------
314: -- |-----------------------------< post_insert >------------------------------|

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

349: --
350: l_proc varchar2(72) := g_package||'post_insert';
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: begin
355: --
356: per_vac_rki.after_insert
357: (p_effective_date

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

469: ,p_hook_type => 'AI');
470: --
471: end;
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: End post_insert;
475: --
476: -- ----------------------------------------------------------------------------
477: -- |---------------------------------< ins >----------------------------------|

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

485: --
486: l_proc varchar2(72) := g_package||'ins';
487: --
488: Begin
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: -- Call the supporting insert validate operations
492: --
493: per_vac_bus.insert_validate

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

512: ,p_effective_date
513: );
514: hr_multi_message.end_validation_set();
515: --
516: hr_utility.set_location('Leaving:'||l_proc, 20);
517: end ins;
518: --
519: -- ----------------------------------------------------------------------------
520: -- |---------------------------------< ins >----------------------------------|

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

579: l_rec per_vac_shd.g_rec_type;
580: l_proc varchar2(72) := g_package||'ins';
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call conversion function to turn arguments into the
586: -- p_rec structure.
587: --

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

655: --
656: p_vacancy_id := l_rec.vacancy_id;
657: p_object_version_number := l_rec.object_version_number;
658: --
659: hr_utility.set_location(' Leaving:'||l_proc, 10);
660: End ins;
661: --
662: end per_vac_ins;