eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_SPP_UPD dependencies on HR_UTILITY

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

64: --
65: l_proc varchar2(72) := g_package||'dt_update_dml';
66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --

Line 71: hr_utility.set_location(l_proc, 10);

67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.
75: --

Line 83: hr_utility.set_location('Entering:'||l_proc, 10);

79: ,p_base_key_column => 'placement_id'
80: ,p_base_key_value => p_rec.placement_id
81: );
82: --
83: hr_utility.set_location('Entering:'||l_proc, 10);
84: hr_utility.set_location('Reason '|| p_rec.reason, 10);
85: hr_utility.set_location('Placement ID '||p_rec.placement_id, 10);
86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);
87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);

Line 84: hr_utility.set_location('Reason '|| p_rec.reason, 10);

80: ,p_base_key_value => p_rec.placement_id
81: );
82: --
83: hr_utility.set_location('Entering:'||l_proc, 10);
84: hr_utility.set_location('Reason '|| p_rec.reason, 10);
85: hr_utility.set_location('Placement ID '||p_rec.placement_id, 10);
86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);
87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);
88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);

Line 85: hr_utility.set_location('Placement ID '||p_rec.placement_id, 10);

81: );
82: --
83: hr_utility.set_location('Entering:'||l_proc, 10);
84: hr_utility.set_location('Reason '|| p_rec.reason, 10);
85: hr_utility.set_location('Placement ID '||p_rec.placement_id, 10);
86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);
87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);
88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);
89: hr_utility.set_location('End Date '||p_validation_end_date, 10);

Line 86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);

82: --
83: hr_utility.set_location('Entering:'||l_proc, 10);
84: hr_utility.set_location('Reason '|| p_rec.reason, 10);
85: hr_utility.set_location('Placement ID '||p_rec.placement_id, 10);
86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);
87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);
88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);
89: hr_utility.set_location('End Date '||p_validation_end_date, 10);
90: hr_utility.set_location('Increment Number'||p_rec.increment_number, 20);

Line 87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);

83: hr_utility.set_location('Entering:'||l_proc, 10);
84: hr_utility.set_location('Reason '|| p_rec.reason, 10);
85: hr_utility.set_location('Placement ID '||p_rec.placement_id, 10);
86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);
87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);
88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);
89: hr_utility.set_location('End Date '||p_validation_end_date, 10);
90: hr_utility.set_location('Increment Number'||p_rec.increment_number, 20);
91: per_spp_shd.g_api_dml := true; -- Set the api dml status

Line 88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);

84: hr_utility.set_location('Reason '|| p_rec.reason, 10);
85: hr_utility.set_location('Placement ID '||p_rec.placement_id, 10);
86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);
87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);
88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);
89: hr_utility.set_location('End Date '||p_validation_end_date, 10);
90: hr_utility.set_location('Increment Number'||p_rec.increment_number, 20);
91: per_spp_shd.g_api_dml := true; -- Set the api dml status
92: --

Line 89: hr_utility.set_location('End Date '||p_validation_end_date, 10);

85: hr_utility.set_location('Placement ID '||p_rec.placement_id, 10);
86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);
87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);
88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);
89: hr_utility.set_location('End Date '||p_validation_end_date, 10);
90: hr_utility.set_location('Increment Number'||p_rec.increment_number, 20);
91: per_spp_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Update the per_spinal_point_placements_f Row

Line 90: hr_utility.set_location('Increment Number'||p_rec.increment_number, 20);

86: hr_utility.set_location('Step ID '||p_rec.step_id, 10);
87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);
88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);
89: hr_utility.set_location('End Date '||p_validation_end_date, 10);
90: hr_utility.set_location('Increment Number'||p_rec.increment_number, 20);
91: per_spp_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Update the per_spinal_point_placements_f Row
94: --

Line 146: hr_utility.set_location('Entering:'||l_proc, 15);

142: and effective_start_date = p_validation_start_date
143: and effective_end_date = p_validation_end_date;
144: --
145: per_spp_shd.g_api_dml := false; -- Unset the api dml status
146: hr_utility.set_location('Entering:'||l_proc, 15);
147: --
148: -- Set the effective start and end dates
149: --
150: p_rec.effective_start_date := p_validation_start_date;

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

150: p_rec.effective_start_date := p_validation_start_date;
151: p_rec.effective_end_date := p_validation_end_date;
152: End If;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 20);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: per_spp_shd.g_api_dml := false; -- Unset the api dml status

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

209: --
210: l_proc varchar2(72) := g_package||'update_dml';
211: --
212: Begin
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: per_spp_upd.dt_update_dml
216: (p_rec => p_rec
217: ,p_effective_date => p_effective_date

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

219: ,p_validation_start_date => p_validation_start_date
220: ,p_validation_end_date => p_validation_end_date
221: );
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: End update_dml;
225: --
226: -- ----------------------------------------------------------------------------
227: -- |----------------------------< dt_pre_update >-----------------------------|

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

277: l_proc varchar2(72) := g_package||'dt_pre_update';
278: l_dummy_version_number number;
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: If (p_datetrack_mode <> hr_api.g_correction) then
283: --
284: -- Update the current effective end date
285: --

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

315: ,p_validation_start_date => p_validation_start_date
316: ,p_validation_end_date => p_validation_end_date
317: );
318: End If;
319: hr_utility.set_location(' Leaving:'||l_proc, 20);
320: End dt_pre_update;
321: --
322: -- ----------------------------------------------------------------------------
323: -- |------------------------------< pre_update >------------------------------|

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

362: --
363: l_proc varchar2(72) := g_package||'pre_update';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: --
369: --
370: dt_pre_update

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

374: ,p_validation_start_date => p_validation_start_date
375: ,p_validation_end_date => p_validation_end_date
376: );
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 10);
379: End pre_update;
380: --
381: -- ----------------------------------------------------------------------------
382: -- |----------------------------< post_update >-------------------------------|

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

420: --
421: l_proc varchar2(72) := g_package||'post_update';
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: begin
426: --
427: per_spp_rku.after_update
428: (p_effective_date

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

564: ,p_hook_type => 'AU');
565: --
566: end;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 10);
569: End post_update;
570: --
571: -- ----------------------------------------------------------------------------
572: -- |-----------------------------< convert_defs >-----------------------------|

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

779: l_validation_end_date date;
780: l_datetrack_mode varchar2(30);
781: --
782: Begin
783: hr_utility.set_location('Entering:'||l_proc, 5);
784: --
785: --
786: -- Ensure that the DateTrack update mode is valid
787: --

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

905: l_proc varchar2(72) := g_package||'upd';
906: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
907: --
908: Begin
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: hr_utility.set_location('assignment_id :'||p_assignment_id,5);
911: hr_utility.set_location('effective_date :'||p_effective_date,5);
912: --
913: -- Get the parent_spine_id

Line 910: hr_utility.set_location('assignment_id :'||p_assignment_id,5);

906: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
907: --
908: Begin
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: hr_utility.set_location('assignment_id :'||p_assignment_id,5);
911: hr_utility.set_location('effective_date :'||p_effective_date,5);
912: --
913: -- Get the parent_spine_id
914: --

Line 911: hr_utility.set_location('effective_date :'||p_effective_date,5);

907: --
908: Begin
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: hr_utility.set_location('assignment_id :'||p_assignment_id,5);
911: hr_utility.set_location('effective_date :'||p_effective_date,5);
912: --
913: -- Get the parent_spine_id
914: --
915: select distinct parent_spine_id

Line 926: hr_utility.set_location('Entering:'||l_proc, 6);

922: and paa.effective_end_date
923: and p_effective_date between pgs.effective_start_date
924: and pgs.effective_end_date;
925: --
926: hr_utility.set_location('Entering:'||l_proc, 6);
927: --
928: -- Call conversion function to turn arguments into the
929: -- l_rec structure.
930: --

Line 980: hr_utility.set_location('Entering:'||l_proc, 7);

976: ,p_information30
977: ,p_information_category
978: ,p_object_version_number
979: );
980: hr_utility.set_location('Entering:'||l_proc, 7);
981: /*
982: select effective_start_date,effective_end_date
983: into l_rec.effective_start_date, l_rec.effective_end_date
984: from per_spinal_point_placements_f

Line 989: hr_utility.set_location('Entering:'||l_proc, 8);

985: where placement_id = p_placement_id
986: and p_effective_date between effective_start_date
987: and effective_end_date;
988: */
989: hr_utility.set_location('Entering:'||l_proc, 8);
990: --
991: -- Having converted the arguments into the
992: -- plsql record structure we call the corresponding record
993: -- business process.

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

1004: p_effective_start_date := l_rec.effective_start_date;
1005: p_effective_end_date := l_rec.effective_end_date;
1006: --
1007: --
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);
1009:
1010: /* added this exception for bug 6346478 which will fix 6024292.
1011: The fix for 6024292 has been reverted as it is raising bug 6346478*/
1012:

Line 1015: hr_utility.set_message(800, 'HR_289829_NO_SPP_REC_FOR_EDATE');

1011: The fix for 6024292 has been reverted as it is raising bug 6346478*/
1012:
1013: exception
1014: when no_data_found then
1015: hr_utility.set_message(800, 'HR_289829_NO_SPP_REC_FOR_EDATE');
1016: hr_utility.raise_error;
1017: End upd;
1018: --
1019: end per_spp_upd;

Line 1016: hr_utility.raise_error;

1012:
1013: exception
1014: when no_data_found then
1015: hr_utility.set_message(800, 'HR_289829_NO_SPP_REC_FOR_EDATE');
1016: hr_utility.raise_error;
1017: End upd;
1018: --
1019: end per_spp_upd;