DBA Data[Home] [Help]

APPS.PER_ELC_INS dependencies on HR_UTILITY

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

61: l_last_updated_by per_elections.last_updated_by%TYPE;
62: l_last_update_login per_elections.last_update_login%TYPE;
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: p_rec.object_version_number := 1; -- Initialise the object version
67: --
68: per_elc_shd.g_api_dml := true; -- Set the api dml status
69: --

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

236: );
237: --
238: per_elc_shd.g_api_dml := false; -- Unset the api dml status
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: Exception
242: When hr_api.check_integrity_violated Then
243: -- A check constraint has been violated
244: per_elc_shd.g_api_dml := false; -- Unset the api dml status

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

304: --
305: Cursor C_Sel1 is select per_elections_s.nextval from sys.dual;
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: --
311: -- Select the next sequence number
312: --

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

313: Open C_Sel1;
314: Fetch C_Sel1 Into p_rec.election_id;
315: Close C_Sel1;
316: --
317: hr_utility.set_location(' Leaving:'||l_proc, 10);
318: End pre_insert;
319: --
320: -- ----------------------------------------------------------------------------
321: -- |-----------------------------< post_insert >------------------------------|

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

356: --
357: l_proc varchar2(72) := g_package||'post_insert';
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: begin
362: --
363: per_elc_rki.after_insert
364: (p_effective_date => p_effective_date

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

515: ,p_hook_type => 'AI');
516: --
517: end;
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 10);
520: End post_insert;
521: --
522: -- ----------------------------------------------------------------------------
523: -- |---------------------------------< ins >----------------------------------|

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

530: --
531: l_proc varchar2(72) := g_package||'ins';
532: --
533: Begin
534: hr_utility.set_location('Entering:'||l_proc, 5);
535: --
536: -- Determine if the business process is to be validated.
537: --
538: If p_validate then

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

569: If p_validate then
570: Raise HR_Api.Validate_Enabled;
571: End If;
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: Exception
575: When HR_Api.Validate_Enabled Then
576: --
577: -- As the Validate_Enabled exception has been raised

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

577: -- As the Validate_Enabled exception has been raised
578: -- we must rollback to the savepoint
579: --
580: ROLLBACK TO ins_per_elc;
581: hr_utility.set_location('Leaving:'||l_proc, 20);
582: end ins;
583: --
584: -- ----------------------------------------------------------------------------
585: -- |---------------------------------< ins >----------------------------------|

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

663: l_rec per_elc_shd.g_rec_type;
664: l_proc varchar2(72) := g_package||'ins';
665: --
666: Begin
667: hr_utility.set_location('Entering:'||l_proc, 5);
668: --
669: -- Call conversion function to turn arguments into the
670: -- p_rec structure.
671: --

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

758: --
759: p_election_id := l_rec.election_id;
760: p_object_version_number := l_rec.object_version_number;
761: --
762: hr_utility.set_location(' Leaving:'||l_proc, 10);
763: End ins;
764: --
765: end per_elc_ins;