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

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

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_sps_ins.g_step_id_i := p_step_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_sps_ins.g_step_id_i := p_step_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------

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

101: l_last_updated_by per_spinal_point_steps_f.last_updated_by%TYPE;
102: l_last_update_login per_spinal_point_steps_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Set the effective start and end dates to the corresponding
108: -- validation start and end dates
109: --

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

113: -- If the datetrack_mode is not INSERT then we must populate the WHO
114: -- columns with the 'old' creation values and 'new' updated values.
115: --
116: If (p_datetrack_mode <> hr_api.g_insert) then
117: hr_utility.set_location(l_proc, 10);
118: --
119: -- Get the object version number for the insert
120: --
121: p_rec.object_version_number :=

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

256: ,l_last_update_login
257: );
258: --
259: per_sps_shd.g_api_dml := false; -- Unset the api dml status
260: hr_utility.set_location(' Leaving:'||l_proc, 15);
261: --
262: Exception
263: When hr_api.check_integrity_violated Then
264: -- A check constraint has been violated

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

288: --
289: l_proc varchar2(72) := g_package||'insert_dml';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: per_sps_ins.dt_insert_dml
295: (p_rec => p_rec
296: ,p_effective_date => p_effective_date

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

298: ,p_validation_start_date => p_validation_start_date
299: ,p_validation_end_date => p_validation_end_date
300: );
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: End insert_dml;
304: --
305: -- ----------------------------------------------------------------------------
306: -- |------------------------------< pre_insert >------------------------------|

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

360: l_proc varchar2(72) := g_package||'pre_insert';
361: l_exists varchar2(1);
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: If (per_sps_ins.g_step_id_i is not null) Then
367: --
368: -- Verify registered primary key values not already in use

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

397: Close C_Sel1;
398: End If;
399: --
400: --
401: hr_utility.set_location(' Leaving:'||l_proc, 10);
402: End pre_insert;
403: --
404: -- ----------------------------------------------------------------------------
405: -- |----------------------------< post_insert >-------------------------------|

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

462: and psp.spinal_point_id = p_rec.spinal_point_id;
463:
464: --
465: Begin
466: hr_utility.set_location('Entering:'||l_proc, 5);
467:
468: --
469: -- Need to create option and option in plan for Benefit
470: --

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

472: open csr_get_names;
473: fetch csr_get_names into l_pay_scale_name,l_spinal_point_name,l_grade_id;
474: if csr_get_names%notfound then
475: close csr_get_names;
476: hr_utility.set_location(l_proc, 10);
477: else
478: /* comment out BUG3179239
479: l_return := pqh_gsp_sync_compensation_obj.create_option_for_point
480: (p_spinal_point_id => p_rec.spinal_point_id

Line 485: hr_utility.trace('pqh_gsp_sync_compensation_obj.create_option_for_point : '

481: ,p_pay_scale_name => l_pay_scale_name
482: ,p_spinal_point_name => l_spinal_point_name
483: );
484: --
485: hr_utility.trace('pqh_gsp_sync_compensation_obj.create_option_for_point : '
486: || l_return);
487: --
488: if l_return <> 'SUCCESS' Then
489: l_message := fnd_message.get;

Line 490: hr_utility.trace('error message : ' || l_message);

486: || l_return);
487: --
488: if l_return <> 'SUCCESS' Then
489: l_message := fnd_message.get;
490: hr_utility.trace('error message : ' || l_message);
491: fnd_message.set_name('PER','HR_289527_CRE_OPTION_FOR_POINT');
492: if l_message is not null then
493: fnd_message.set_token('ERR_CODE',l_message);
494: else

Line 511: hr_utility.trace('pqh_gsp_sync_compensation_obj.oipl_for_step : '

507: ,p_effective_date => p_effective_date
508: ,p_datetrack_mode => p_datetrack_mode
509: );
510: --
511: hr_utility.trace('pqh_gsp_sync_compensation_obj.oipl_for_step : '
512: || l_return);
513: --
514: if l_return <> 'SUCCESS' Then
515: l_message := fnd_message.get;

Line 516: hr_utility.trace('error message : ' || l_message);

512: || l_return);
513: --
514: if l_return <> 'SUCCESS' Then
515: l_message := fnd_message.get;
516: hr_utility.trace('error message : ' || l_message);
517: fnd_message.set_name('PER','HR_289528_CRE_OPTION_IN_PLAN');
518: if l_message is not null then
519: fnd_message.set_token('ERR_CODE',l_message);
520: else

Line 528: hr_utility.set_location(l_proc, 20);

524: fnd_message.raise_error;
525: End if;
526: end if;
527: --
528: hr_utility.set_location(l_proc, 20);
529: --
530: begin
531: --
532: per_sps_rki.after_insert

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

633: ,p_hook_type => 'AI');
634: --
635: end;
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 30);
638: End post_insert;
639: --
640: -- ----------------------------------------------------------------------------
641: -- |-------------------------------< ins_lck >--------------------------------|

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

685: l_validation_start_date date;
686: l_validation_end_date date;
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Validate the datetrack mode mode getting the validation start
692: -- and end dates for the specified datetrack operation.
693: --

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

709: --
710: p_validation_start_date := l_validation_start_date;
711: p_validation_end_date := l_validation_end_date;
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 10);
714: --
715: End ins_lck;
716: --
717: -- ----------------------------------------------------------------------------

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

727: l_validation_start_date date;
728: l_validation_end_date date;
729: --
730: Begin
731: hr_utility.set_location('Entering:'||l_proc, 5);
732: --
733: -- Call the lock operation
734: --
735: per_sps_ins.ins_lck

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

785: --
786: -- Call to raise any errors on multi-message list
787: hr_multi_message.end_validation_set;
788: --
789: hr_utility.set_location('Leaving:'||l_proc,10);
790: end ins;
791: --
792: -- ----------------------------------------------------------------------------
793: -- |---------------------------------< ins >----------------------------------|

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

842: l_rec per_sps_shd.g_rec_type;
843: l_proc varchar2(72) := g_package||'ins';
844: --
845: Begin
846: hr_utility.set_location('Entering:'||l_proc, 5);
847: --
848: -- Call conversion function to turn arguments into the
849: -- p_rec structure.
850: --

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

911: p_effective_end_date := l_rec.effective_end_date;
912: p_object_version_number := l_rec.object_version_number;
913: --
914: --
915: hr_utility.set_location(' Leaving:'||l_proc, 10);
916: End ins;
917: --
918: end per_sps_ins;