APPS.PSP_ERA_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: psp_era_ins.g_effort_report_approval_id_i := p_effort_report_approval_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: psp_era_ins.g_effort_report_approval_id_i := p_effort_report_approval_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 200: hr_utility.set_location(' Leaving:'||l_proc, 10);

196: );
197: --
198: --
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: Exception
202: When hr_api.check_integrity_violated Then
203: -- A check constraint has been violated
204: --

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

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

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

307: Fetch C_Sel1 Into p_rec.effort_report_approval_id;
308: Close C_Sel1;
309: End If;
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: End pre_insert;
313: --
314: -- ----------------------------------------------------------------------------
315: -- |-----------------------------< 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: psp_era_rki.after_insert
357: (p_effort_report_approval_id

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 486: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

510: --
511: -- Call to raise any errors on multi-message list
512: hr_multi_message.end_validation_set;
513: --
514: hr_utility.set_location('Leaving:'||l_proc, 20);
515: end ins;
516: --
517: -- ----------------------------------------------------------------------------
518: -- |---------------------------------< ins >----------------------------------|

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

575: l_rec psp_era_shd.g_rec_type;
576: l_proc varchar2(72) := g_package||'ins';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Call conversion function to turn arguments into the
582: -- p_rec structure.
583: --

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

649: --
650: p_effort_report_approval_id := l_rec.effort_report_approval_id;
651: p_object_version_number := l_rec.object_version_number;
652: --
653: hr_utility.set_location(' Leaving:'||l_proc, 10);
654: End ins;
655: --
656: end psp_era_ins;