DBA Data[Home] [Help]

APPS.GHR_PAR_INS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: ghr_pa_requests

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

510: p_rec.object_version_number
511: );
512: --
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: Exception
516: When hr_api.check_integrity_violated Then
517: -- A check constraint has been violated
518: ghr_par_shd.constraint_error

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

575: --
576: Cursor C_Sel1 is select ghr_pa_requests_s.nextval from sys.dual;
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: if p_rec.pa_request_id is null then
581: --
582: --
583: -- Select the next sequence number

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

585: open C_Sel1;
586: Fetch C_Sel1 Into p_rec.pa_request_id;
587: Close C_Sel1;
588: end if;
589: hr_utility.set_location(' Leaving:'||l_proc, 10);
590: End pre_insert;
591:
592: --
593: -- ----------------------------------------------------------------------------

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

626: --
627: l_proc varchar2(72) := g_package||'post_insert';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: -- This is a hook point and the user hook for post_insert is called here.
633: --
634: begin

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

862: );
863: end;
864: -- End of API User Hook for post_insert.
865:
866: hr_utility.set_location(' Leaving:'||l_proc, 10);
867: End post_insert;
868: --
869: -- ----------------------------------------------------------------------------
870: -- |---------------------------------< ins >----------------------------------|

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

876: --
877: l_proc varchar2(72) := g_package||'ins';
878: --
879: Begin
880: hr_utility.set_location('Entering:'||l_proc, 5);
881: --
882: -- Call the supporting insert validate operations
883: --
884: ghr_par_bus.insert_validate(p_rec);

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

1132: l_rec ghr_par_shd.g_rec_type;
1133: l_proc varchar2(72) := g_package||'ins';
1134: --
1135: Begin
1136: hr_utility.set_location('Entering:'||l_proc, 5);
1137: --
1138: -- Call conversion function to turn arguments into the
1139: -- p_rec structure.
1140: --

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

1378: --
1379: p_pa_request_id := l_rec.pa_request_id;
1380: p_object_version_number := l_rec.object_version_number;
1381: --
1382: hr_utility.set_location(' Leaving:'||l_proc, 10);
1383: End ins;
1384: --
1385: end ghr_par_ins;