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.

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

435: and effective_start_date > p_rec.effective_start_date;
436: -- code changes end for bug 7457065
437:
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440:
441: -- Code Changes start for Bug 7457065
442: open c_step_end_date;
443: fetch c_step_end_date into l_step_end_date;

Line 445: hr_utility.set_location(l_proc, 6);

441: -- Code Changes start for Bug 7457065
442: open c_step_end_date;
443: fetch c_step_end_date into l_step_end_date;
444: close c_step_end_date;
445: hr_utility.set_location(l_proc, 6);
446: if l_step_end_date < p_rec.effective_end_date then
447: open c_next_placement_st_date;
448: fetch c_next_placement_st_date into l_next_placement_st_date;
449: close c_next_placement_st_date;

Line 450: hr_utility.set_location(l_proc, 7);

446: if l_step_end_date < p_rec.effective_end_date then
447: open c_next_placement_st_date;
448: fetch c_next_placement_st_date into l_next_placement_st_date;
449: close c_next_placement_st_date;
450: hr_utility.set_location(l_proc, 7);
451: if l_next_placement_st_date is not null then
452: hr_utility.set_location(l_proc, 8);
453: if l_next_placement_st_date > l_step_end_date + 1 then
454: fnd_message.set_name('PER', 'HR_50439_SP_GAP_ERROR');

Line 452: hr_utility.set_location(l_proc, 8);

448: fetch c_next_placement_st_date into l_next_placement_st_date;
449: close c_next_placement_st_date;
450: hr_utility.set_location(l_proc, 7);
451: if l_next_placement_st_date is not null then
452: hr_utility.set_location(l_proc, 8);
453: if l_next_placement_st_date > l_step_end_date + 1 then
454: fnd_message.set_name('PER', 'HR_50439_SP_GAP_ERROR');
455: fnd_message.set_token('END_DATE',l_step_end_date);
456: fnd_message.raise_error;

Line 458: hr_utility.set_location(l_proc, 9);

454: fnd_message.set_name('PER', 'HR_50439_SP_GAP_ERROR');
455: fnd_message.set_token('END_DATE',l_step_end_date);
456: fnd_message.raise_error;
457: end if;
458: hr_utility.set_location(l_proc, 9);
459: else
460: hr_utility.set_location(l_proc, 10);
461: update per_spinal_point_placements_f
462: set effective_end_date = l_step_end_date

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

456: fnd_message.raise_error;
457: end if;
458: hr_utility.set_location(l_proc, 9);
459: else
460: hr_utility.set_location(l_proc, 10);
461: update per_spinal_point_placements_f
462: set effective_end_date = l_step_end_date
463: where placement_id = p_rec.placement_id
464: and effective_start_date = p_rec.effective_start_date;

Line 465: hr_utility.set_location(l_proc, 11);

461: update per_spinal_point_placements_f
462: set effective_end_date = l_step_end_date
463: where placement_id = p_rec.placement_id
464: and effective_start_date = p_rec.effective_start_date;
465: hr_utility.set_location(l_proc, 11);
466: end if;
467: hr_utility.set_location(l_proc, 12);
468: end if;
469:

Line 467: hr_utility.set_location(l_proc, 12);

463: where placement_id = p_rec.placement_id
464: and effective_start_date = p_rec.effective_start_date;
465: hr_utility.set_location(l_proc, 11);
466: end if;
467: hr_utility.set_location(l_proc, 12);
468: end if;
469:
470: hr_utility.set_location(l_proc, 13);
471: -- Code Changes end for Bug 7457065

Line 470: hr_utility.set_location(l_proc, 13);

466: end if;
467: hr_utility.set_location(l_proc, 12);
468: end if;
469:
470: hr_utility.set_location(l_proc, 13);
471: -- Code Changes end for Bug 7457065
472: begin
473: --
474: per_spp_rku.after_update

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

611: ,p_hook_type => 'AU');
612: --
613: end;
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: End post_update;
617: --
618: -- ----------------------------------------------------------------------------
619: -- |-----------------------------< convert_defs >-----------------------------|

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

826: l_validation_end_date date;
827: l_datetrack_mode varchar2(30);
828: --
829: Begin
830: hr_utility.set_location('Entering:'||l_proc, 5);
831: --
832: --
833: -- Ensure that the DateTrack update mode is valid
834: --

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

952: l_proc varchar2(72) := g_package||'upd';
953: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
954: --
955: Begin
956: hr_utility.set_location('Entering:'||l_proc, 5);
957: hr_utility.set_location('assignment_id :'||p_assignment_id,5);
958: hr_utility.set_location('effective_date :'||p_effective_date,5);
959: --
960: -- Get the parent_spine_id

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

953: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
954: --
955: Begin
956: hr_utility.set_location('Entering:'||l_proc, 5);
957: hr_utility.set_location('assignment_id :'||p_assignment_id,5);
958: hr_utility.set_location('effective_date :'||p_effective_date,5);
959: --
960: -- Get the parent_spine_id
961: --

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

954: --
955: Begin
956: hr_utility.set_location('Entering:'||l_proc, 5);
957: hr_utility.set_location('assignment_id :'||p_assignment_id,5);
958: hr_utility.set_location('effective_date :'||p_effective_date,5);
959: --
960: -- Get the parent_spine_id
961: --
962: select distinct parent_spine_id

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

969: and paa.effective_end_date
970: and p_effective_date between pgs.effective_start_date
971: and pgs.effective_end_date;
972: --
973: hr_utility.set_location('Entering:'||l_proc, 6);
974: --
975: -- Call conversion function to turn arguments into the
976: -- l_rec structure.
977: --

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

1023: ,p_information30
1024: ,p_information_category
1025: ,p_object_version_number
1026: );
1027: hr_utility.set_location('Entering:'||l_proc, 7);
1028: /*
1029: select effective_start_date,effective_end_date
1030: into l_rec.effective_start_date, l_rec.effective_end_date
1031: from per_spinal_point_placements_f

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

1032: where placement_id = p_placement_id
1033: and p_effective_date between effective_start_date
1034: and effective_end_date;
1035: */
1036: hr_utility.set_location('Entering:'||l_proc, 8);
1037: --
1038: -- Having converted the arguments into the
1039: -- plsql record structure we call the corresponding record
1040: -- business process.

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

1051: p_effective_start_date := l_rec.effective_start_date;
1052: p_effective_end_date := l_rec.effective_end_date;
1053: --
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 10);
1056:
1057: /* added this exception for bug 6346478 which will fix 6024292.
1058: The fix for 6024292 has been reverted as it is raising bug 6346478*/
1059:

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

1058: The fix for 6024292 has been reverted as it is raising bug 6346478*/
1059:
1060: exception
1061: when no_data_found then
1062: hr_utility.set_message(800, 'HR_289829_NO_SPP_REC_FOR_EDATE');
1063: hr_utility.raise_error;
1064: End upd;
1065: --
1066: end per_spp_upd;

Line 1063: hr_utility.raise_error;

1059:
1060: exception
1061: when no_data_found then
1062: hr_utility.set_message(800, 'HR_289829_NO_SPP_REC_FOR_EDATE');
1063: hr_utility.raise_error;
1064: End upd;
1065: --
1066: end per_spp_upd;