DBA Data[Home] [Help]

APPS.PQH_REI_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: pqh_rei_ins.g_role_extra_info_id_i := p_role_extra_info_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: pqh_rei_ins.g_role_extra_info_id_i := p_role_extra_info_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 236: hr_utility.set_location(' Leaving:'||l_proc, 10);

232: );
233: --
234: --
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: Exception
238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: --

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

308: l_proc varchar2(72) := g_package||'pre_insert';
309: l_exists varchar2(1);
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: If (pqh_rei_ins.g_role_extra_info_id_i is not null) Then
315: --
316: -- Verify registered primary key values not already in use

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

344: Fetch C_Sel1 Into p_rec.role_extra_info_id;
345: Close C_Sel1;
346: End If;
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 10);
349: End pre_insert;
350: --
351: -- ----------------------------------------------------------------------------
352: -- |-----------------------------< post_insert >------------------------------|

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

386: --
387: l_proc varchar2(72) := g_package||'post_insert';
388: --
389: Begin
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: begin
392: --
393: pqh_rei_rki.after_insert
394: (p_role_extra_info_id => p_rec.role_extra_info_id

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

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

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

487: --
488: l_proc varchar2(72) := g_package||'ins';
489: --
490: Begin
491: hr_utility.set_location('Entering:'||l_proc, 5);
492: --
493: --
494: -- Determine if the business process is to be validated.
495: --

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

530: --
531: -- Call to raise any errors on multi-message list
532: hr_multi_message.end_validation_set;
533: --
534: hr_utility.set_location('Leaving:'||l_proc, 20);
535: Exception
536: When HR_Api.Validate_Enabled Then
537: --
538: -- As the Validate_Enabled exception has been raised

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

622: l_rec pqh_rei_shd.g_rec_type;
623: l_proc varchar2(72) := g_package||'ins';
624: --
625: Begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: -- Call conversion function to turn arguments into the
629: -- p_rec structure.
630: --

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

715: --
716: p_role_extra_info_id := l_rec.role_extra_info_id;
717: p_object_version_number := l_rec.object_version_number;
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 10);
720: End ins;
721: --
722: end pqh_rei_ins;