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_SHD dependencies on HR_UTILITY

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

121: l_proc varchar2(72) := g_package|| 'api_updating';
122: --
123: Begin
124: --
125: hr_utility.set_location('Entering :'||l_proc, 5);
126: If (p_effective_date is null or
127: p_placement_id is null or
128: p_object_version_number is null) Then
129: --

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

130: -- One of the primary key arguments is null therefore we must
131: -- set the returning function value to false
132: --
133: l_fct_ret := false;
134: hr_utility.set_location('Entering :'||l_proc, 10);
135: Else
136: hr_utility.set_location('Entering :'||l_proc, 15);
137:
138: If (p_placement_id =

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

132: --
133: l_fct_ret := false;
134: hr_utility.set_location('Entering :'||l_proc, 10);
135: Else
136: hr_utility.set_location('Entering :'||l_proc, 15);
137:
138: If (p_placement_id =
139: per_spp_shd.g_old_rec.placement_id and
140: p_object_version_number =

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

142: --
143: -- The g_old_rec is current therefore we must
144: -- set the returning function to true
145: --
146: hr_utility.set_location('Entering :'||l_proc, 20);
147: l_fct_ret := true;
148: Else
149: hr_utility.set_location('Entering :'||l_proc, 25);
150: --

Line 149: hr_utility.set_location('Entering :'||l_proc, 25);

145: --
146: hr_utility.set_location('Entering :'||l_proc, 20);
147: l_fct_ret := true;
148: Else
149: hr_utility.set_location('Entering :'||l_proc, 25);
150: --
151: -- Select the current row
152: --
153: Open C_Sel1;

Line 164: hr_utility.set_location('Entering :'||l_proc, 30);

160: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: End If;
163: Close C_Sel1;
164: hr_utility.set_location('Entering :'||l_proc, 30);
165: If (p_object_version_number
166: <> per_spp_shd.g_old_rec.object_version_number) Then
167: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
168: fnd_message.raise_error;

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

202: and p_effective_date between paa1.effective_start_date
203: and paa1.effective_end_date);
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: -- Call the corresponding datetrack api
209: --
210: dt_api.find_dt_upd_modes

Line 228: hr_utility.set_location('REMOVING UPDATE OVERRIDE',6);

224: open csr_future_grade_scale;
225: fetch csr_future_grade_scale into l_grade_id;
226:
227: if csr_future_grade_scale%found then
228: hr_utility.set_location('REMOVING UPDATE OVERRIDE',6);
229: p_update_override := false;
230: end if;
231:
232: close csr_future_grade_scale;

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

230: end if;
231:
232: close csr_future_grade_scale;
233:
234: hr_utility.set_location(' Leaving:'||l_proc, 10);
235: End find_dt_upd_modes;
236: --
237: -- ----------------------------------------------------------------------------
238: -- |---------------------------< find_dt_del_modes >--------------------------|

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

260: and p_effective_date
261: between t.effective_start_date and t.effective_end_date;
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: Open C_sel1;
266: Fetch C_Sel1 Into
267: l_parent_key_value1
268: ,l_parent_key_value2;

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

293: ,p_future_change => p_future_change
294: ,p_delete_next_change => p_delete_next_change
295: );
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 10);
298: End find_dt_del_modes;
299: --
300: -- ----------------------------------------------------------------------------
301: -- |-----------------------< upd_effective_end_date >-------------------------|

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

312: l_proc varchar2(72) := g_package||'upd_effective_end_date';
313: l_object_version_number number;
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- Because we are updating a row we must get the next object
319: -- version number.
320: --

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

324: ,p_base_key_column => 'placement_id'
325: ,p_base_key_value => p_base_key_value
326: );
327: --
328: hr_utility.set_location(l_proc, 10);
329: hr_utility.set_location('PLacement_id: '||p_base_key_value,1);
330: hr_utility.set_location('Object Version Number: '||l_object_version_number,2);
331: hr_utility.set_location('Effective_Date: '||p_effective_date,3);
332: hr_utility.set_location('NEW Effective_End_Date: '||p_new_effective_end_date,4);

Line 329: hr_utility.set_location('PLacement_id: '||p_base_key_value,1);

325: ,p_base_key_value => p_base_key_value
326: );
327: --
328: hr_utility.set_location(l_proc, 10);
329: hr_utility.set_location('PLacement_id: '||p_base_key_value,1);
330: hr_utility.set_location('Object Version Number: '||l_object_version_number,2);
331: hr_utility.set_location('Effective_Date: '||p_effective_date,3);
332: hr_utility.set_location('NEW Effective_End_Date: '||p_new_effective_end_date,4);
333: per_spp_shd.g_api_dml := true; -- Set the api dml status

Line 330: hr_utility.set_location('Object Version Number: '||l_object_version_number,2);

326: );
327: --
328: hr_utility.set_location(l_proc, 10);
329: hr_utility.set_location('PLacement_id: '||p_base_key_value,1);
330: hr_utility.set_location('Object Version Number: '||l_object_version_number,2);
331: hr_utility.set_location('Effective_Date: '||p_effective_date,3);
332: hr_utility.set_location('NEW Effective_End_Date: '||p_new_effective_end_date,4);
333: per_spp_shd.g_api_dml := true; -- Set the api dml status
334: --

Line 331: hr_utility.set_location('Effective_Date: '||p_effective_date,3);

327: --
328: hr_utility.set_location(l_proc, 10);
329: hr_utility.set_location('PLacement_id: '||p_base_key_value,1);
330: hr_utility.set_location('Object Version Number: '||l_object_version_number,2);
331: hr_utility.set_location('Effective_Date: '||p_effective_date,3);
332: hr_utility.set_location('NEW Effective_End_Date: '||p_new_effective_end_date,4);
333: per_spp_shd.g_api_dml := true; -- Set the api dml status
334: --
335: -- Update the specified datetrack row setting the effective

Line 332: hr_utility.set_location('NEW Effective_End_Date: '||p_new_effective_end_date,4);

328: hr_utility.set_location(l_proc, 10);
329: hr_utility.set_location('PLacement_id: '||p_base_key_value,1);
330: hr_utility.set_location('Object Version Number: '||l_object_version_number,2);
331: hr_utility.set_location('Effective_Date: '||p_effective_date,3);
332: hr_utility.set_location('NEW Effective_End_Date: '||p_new_effective_end_date,4);
333: per_spp_shd.g_api_dml := true; -- Set the api dml status
334: --
335: -- Update the specified datetrack row setting the effective
336: -- end date to the specified new effective end date.

Line 347: hr_utility.set_location(' Leaving:'||l_proc, 15);

343: between t.effective_start_date and t.effective_end_date;
344: --
345: per_spp_shd.g_api_dml := false; -- Unset the api dml status
346: p_object_version_number := l_object_version_number;
347: hr_utility.set_location(' Leaving:'||l_proc, 15);
348: --
349: Exception
350: When Others Then
351: per_spp_shd.g_api_dml := false; -- Unset the api dml status

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

437: --
438: --
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc, 5);
442: --
443: -- Ensure that all the mandatory arguments are not null
444: --
445: hr_api.mandatory_arg_error(p_api_name => l_proc

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

445: hr_api.mandatory_arg_error(p_api_name => l_proc
446: ,p_argument => 'effective_date'
447: ,p_argument_value => p_effective_date
448: );
449: hr_utility.set_location('Entering:'||l_proc, 6);
450: --
451: hr_api.mandatory_arg_error(p_api_name => l_proc
452: ,p_argument => 'datetrack_mode'
453: ,p_argument_value => p_datetrack_mode

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

451: hr_api.mandatory_arg_error(p_api_name => l_proc
452: ,p_argument => 'datetrack_mode'
453: ,p_argument_value => p_datetrack_mode
454: );
455: hr_utility.set_location('Entering:'||l_proc, 7);
456: --
457: hr_api.mandatory_arg_error(p_api_name => l_proc
458: ,p_argument => 'placement_id'
459: ,p_argument_value => p_placement_id

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

457: hr_api.mandatory_arg_error(p_api_name => l_proc
458: ,p_argument => 'placement_id'
459: ,p_argument_value => p_placement_id
460: );
461: hr_utility.set_location('Entering:'||l_proc, 8);
462: --
463: hr_api.mandatory_arg_error(p_api_name => l_proc
464: ,p_argument => 'object_version_number'
465: ,p_argument_value => p_object_version_number

Line 467: hr_utility.set_location('Entering:'||l_proc, 9);

463: hr_api.mandatory_arg_error(p_api_name => l_proc
464: ,p_argument => 'object_version_number'
465: ,p_argument_value => p_object_version_number
466: );
467: hr_utility.set_location('Entering:'||l_proc, 9);
468: --
469: -- Check to ensure the datetrack mode is not INSERT.
470: --
471: If (p_datetrack_mode <> hr_api.g_insert) then

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

471: If (p_datetrack_mode <> hr_api.g_insert) then
472: --
473: -- We must select and lock the current row.
474: --
475: hr_utility.set_location('Entering:'||l_proc, 10);
476: --
477: Open C_Sel1;
478: Fetch C_Sel1 Into per_spp_shd.g_old_rec;
479:

Line 583: hr_utility.set_location(' Leaving:'||l_proc, 30);

579: -- p_validation_end_date := l_validation_end_date;
580: --
581: -- bug 3158554 ends here.
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 30);
584: --
585: -- We need to trap the ORA LOCK exception
586: --
587: Exception