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

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

79: l_last_updated_by per_spinal_point_placements_f.last_updated_by%TYPE;
80: l_last_update_login per_spinal_point_placements_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=

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

100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> hr_api.g_insert) then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --
108: Open C_Sel1;

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

238: ,l_last_update_login
239: );
240: --
241: per_spp_shd.g_api_dml := false; -- Unset the api dml status
242: hr_utility.set_location(' Leaving:'||l_proc, 15);
243: --
244: Exception
245: When hr_api.check_integrity_violated Then
246: -- A check constraint has been violated

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

270: --
271: l_proc varchar2(72) := g_package||'insert_dml';
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: per_spp_ins.dt_insert_dml
277: (p_rec => p_rec
278: ,p_effective_date => p_effective_date

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

280: ,p_validation_start_date => p_validation_start_date
281: ,p_validation_end_date => p_validation_end_date
282: );
283: --
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: End insert_dml;
286: --
287: -- ----------------------------------------------------------------------------
288: -- |------------------------------< pre_insert >------------------------------|

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

335: --
336: Cursor C_Sel1 is select per_spinal_point_placements_s.nextval from sys.dual;
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: --
342: -- Select the next sequence number
343: --

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

345: Fetch C_Sel1 Into p_rec.placement_id;
346: Close C_Sel1;
347: --
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: End pre_insert;
351: --
352: -- ----------------------------------------------------------------------------
353: -- |---------------------------< delete_future_spp >---------------------------|

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

380: --
381: --
382: BEGIN
383:
384: hr_utility.set_location('Entering : '||l_proc, 5);
385: --
386: l_previous_id := -1;
387: --
388: -- Delete all future SPP records.

Line 391: hr_utility.set_location(l_proc||'/ pl_id = '||c_future_spp.placement_id, 10);

387: --
388: -- Delete all future SPP records.
389: FOR c_future_spp IN csr_future_spp_records(p_assignment_id, p_effective_date) LOOP
390: --
391: hr_utility.set_location(l_proc||'/ pl_id = '||c_future_spp.placement_id, 10);
392: hr_utility.set_location(l_proc||'/ ovn = '||c_future_spp.object_version_number, 10);
393: --
394: -- If the record retrieved has a different placement id
395: -- then perform a ZAP on this record. If the ID is the same

Line 392: hr_utility.set_location(l_proc||'/ ovn = '||c_future_spp.object_version_number, 10);

388: -- Delete all future SPP records.
389: FOR c_future_spp IN csr_future_spp_records(p_assignment_id, p_effective_date) LOOP
390: --
391: hr_utility.set_location(l_proc||'/ pl_id = '||c_future_spp.placement_id, 10);
392: hr_utility.set_location(l_proc||'/ ovn = '||c_future_spp.object_version_number, 10);
393: --
394: -- If the record retrieved has a different placement id
395: -- then perform a ZAP on this record. If the ID is the same
396: -- as the previous id then do nothing as this record has already

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

397: -- been deleted.
398: --
399: IF l_previous_id <> c_future_spp.placement_id THEN
400: --
401: hr_utility.set_location(l_proc, 20);
402: --
403: l_previous_id := c_future_spp.placement_id;
404: l_object_version_number := c_future_spp.object_version_number;
405: --

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

414: END IF;
415: --
416: END LOOP;
417: --
418: hr_utility.set_location('Leaving : '||l_proc, 30);
419:
420: END delete_future_spps;
421: --
422: -- ----------------------------------------------------------------------------

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

532: l_effective_end_date date;
533: --
534: BEGIN
535: --
536: hr_utility.set_location('Entering '||l_proc, 10);
537: --
538: l_end_date := null;
539: l_assignment_id := p_assignment_id;
540:

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

552: l_object_version_number, l_step_id;
553: if spp_details%found then
554: --
555: if ( l_end_date < l_spp_eff_end_date) then --Fixed for bug9157053
556: hr_utility.set_location(l_proc, 20);
557: hr_sp_placement_api.delete_spp
558: (p_validate => false
559: ,p_effective_date => l_end_date
560: ,p_datetrack_mode => 'DELETE'

Line 577: hr_utility.set_location(l_proc, 30);

573: --
574: end if;
575: close future_spps;
576: --
577: hr_utility.set_location(l_proc, 30);
578: --
579: -- Keep the SPPs in synchronous with Assignment updates.
580: --
581: l_validation_start_date := p_effective_date+1;

Line 593: hr_utility.set_location('Assignment ID '||l_assignment_id, 40);

589: l_dummy := 'N';
590: l_placement_id := null;
591: l_object_version_number := null;
592:
593: hr_utility.set_location('Assignment ID '||l_assignment_id, 40);
594: hr_utility.set_location('Effective start date '||l_asg_eff_start_date, 40);
595: hr_utility.set_location('Effective end date '||l_asg_eff_end_date, 40);
596: hr_utility.set_location('Grade ID '||l_grade_id, 40);
597: --

Line 594: hr_utility.set_location('Effective start date '||l_asg_eff_start_date, 40);

590: l_placement_id := null;
591: l_object_version_number := null;
592:
593: hr_utility.set_location('Assignment ID '||l_assignment_id, 40);
594: hr_utility.set_location('Effective start date '||l_asg_eff_start_date, 40);
595: hr_utility.set_location('Effective end date '||l_asg_eff_end_date, 40);
596: hr_utility.set_location('Grade ID '||l_grade_id, 40);
597: --
598: -- Start of 3335915

Line 595: hr_utility.set_location('Effective end date '||l_asg_eff_end_date, 40);

591: l_object_version_number := null;
592:
593: hr_utility.set_location('Assignment ID '||l_assignment_id, 40);
594: hr_utility.set_location('Effective start date '||l_asg_eff_start_date, 40);
595: hr_utility.set_location('Effective end date '||l_asg_eff_end_date, 40);
596: hr_utility.set_location('Grade ID '||l_grade_id, 40);
597: --
598: -- Start of 3335915
599: /*

Line 596: hr_utility.set_location('Grade ID '||l_grade_id, 40);

592:
593: hr_utility.set_location('Assignment ID '||l_assignment_id, 40);
594: hr_utility.set_location('Effective start date '||l_asg_eff_start_date, 40);
595: hr_utility.set_location('Effective end date '||l_asg_eff_end_date, 40);
596: hr_utility.set_location('Grade ID '||l_grade_id, 40);
597: --
598: -- Start of 3335915
599: /*
600: open same_grade_update(l_assignment_id, l_asg_eff_start_date, l_grade_id);

Line 603: hr_utility.set_location('Assignment update is not a Grade Update', 50);

599: /*
600: open same_grade_update(l_assignment_id, l_asg_eff_start_date, l_grade_id);
601: fetch same_grade_update into l_dummy;
602: if same_grade_update%found and l_dummy ='Y' then
603: hr_utility.set_location('Assignment update is not a Grade Update', 50);
604: --
605: open spp_details(l_assignment_id, l_asg_eff_start_date);
606: fetch spp_details into l_placement_id, l_spp_eff_start_date,
607: l_spp_eff_end_date, l_object_version_number, l_step_id;

Line 610: hr_utility.set_location('SPP found', 60);

606: fetch spp_details into l_placement_id, l_spp_eff_start_date,
607: l_spp_eff_end_date, l_object_version_number, l_step_id;
608: --
609: if spp_details%found then
610: hr_utility.set_location('SPP found', 60);
611: hr_utility.set_location('Placement ID: '||l_placement_id, 60);
612: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 60);
613: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 60);
614: hr_utility.set_location('Object version number: '||l_object_version_number, 60);

Line 611: hr_utility.set_location('Placement ID: '||l_placement_id, 60);

607: l_spp_eff_end_date, l_object_version_number, l_step_id;
608: --
609: if spp_details%found then
610: hr_utility.set_location('SPP found', 60);
611: hr_utility.set_location('Placement ID: '||l_placement_id, 60);
612: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 60);
613: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 60);
614: hr_utility.set_location('Object version number: '||l_object_version_number, 60);
615: hr_utility.set_location('Step ID: '||l_step_id, 60);

Line 612: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 60);

608: --
609: if spp_details%found then
610: hr_utility.set_location('SPP found', 60);
611: hr_utility.set_location('Placement ID: '||l_placement_id, 60);
612: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 60);
613: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 60);
614: hr_utility.set_location('Object version number: '||l_object_version_number, 60);
615: hr_utility.set_location('Step ID: '||l_step_id, 60);
616: --

Line 613: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 60);

609: if spp_details%found then
610: hr_utility.set_location('SPP found', 60);
611: hr_utility.set_location('Placement ID: '||l_placement_id, 60);
612: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 60);
613: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 60);
614: hr_utility.set_location('Object version number: '||l_object_version_number, 60);
615: hr_utility.set_location('Step ID: '||l_step_id, 60);
616: --
617: BEGIN

Line 614: hr_utility.set_location('Object version number: '||l_object_version_number, 60);

610: hr_utility.set_location('SPP found', 60);
611: hr_utility.set_location('Placement ID: '||l_placement_id, 60);
612: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 60);
613: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 60);
614: hr_utility.set_location('Object version number: '||l_object_version_number, 60);
615: hr_utility.set_location('Step ID: '||l_step_id, 60);
616: --
617: BEGIN
618: hr_utility.set_location(l_proc, 70);

Line 615: hr_utility.set_location('Step ID: '||l_step_id, 60);

611: hr_utility.set_location('Placement ID: '||l_placement_id, 60);
612: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 60);
613: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 60);
614: hr_utility.set_location('Object version number: '||l_object_version_number, 60);
615: hr_utility.set_location('Step ID: '||l_step_id, 60);
616: --
617: BEGIN
618: hr_utility.set_location(l_proc, 70);
619: hr_sp_placement_api.update_spp

Line 618: hr_utility.set_location(l_proc, 70);

614: hr_utility.set_location('Object version number: '||l_object_version_number, 60);
615: hr_utility.set_location('Step ID: '||l_step_id, 60);
616: --
617: BEGIN
618: hr_utility.set_location(l_proc, 70);
619: hr_sp_placement_api.update_spp
620: (p_effective_date => l_asg_eff_start_date
621: ,p_datetrack_mode => 'UPDATE'
622: ,p_placement_id => l_placement_id

Line 629: hr_utility.trace('Cannot process Placement id '||to_char(l_placement_id));

625: ,p_effective_start_date => l_effective_start_date
626: ,p_effective_end_date => l_effective_end_date);
627: EXCEPTION
628: when others then
629: hr_utility.trace('Cannot process Placement id '||to_char(l_placement_id));
630: hr_utility.trace('Effective start date '||to_char(l_spp_eff_start_date));
631: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));
632: END;
633: --

Line 630: hr_utility.trace('Effective start date '||to_char(l_spp_eff_start_date));

626: ,p_effective_end_date => l_effective_end_date);
627: EXCEPTION
628: when others then
629: hr_utility.trace('Cannot process Placement id '||to_char(l_placement_id));
630: hr_utility.trace('Effective start date '||to_char(l_spp_eff_start_date));
631: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));
632: END;
633: --
634: else

Line 631: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));

627: EXCEPTION
628: when others then
629: hr_utility.trace('Cannot process Placement id '||to_char(l_placement_id));
630: hr_utility.trace('Effective start date '||to_char(l_spp_eff_start_date));
631: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));
632: END;
633: --
634: else
635: hr_utility.set_location(l_proc||' No SPP found.', 80);

Line 635: hr_utility.set_location(l_proc||' No SPP found.', 80);

631: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));
632: END;
633: --
634: else
635: hr_utility.set_location(l_proc||' No SPP found.', 80);
636: end if;
637: close spp_details;
638: end if;
639: close same_grade_update;

Line 649: hr_utility.set_location('Updation on Assignment was grade to null ', 90);

645: open change_grade_to_null(l_assignment_id, l_asg_eff_start_date, l_grade_id);
646: fetch change_grade_to_null into l_dummy;
647: if change_grade_to_null%found and l_dummy = 'Y' then
648:
649: hr_utility.set_location('Updation on Assignment was grade to null ', 90);
650: hr_utility.set_location('End date the SPP', 90);
651:
652: open spp_details(l_assignment_id, l_asg_eff_start_date);
653: fetch spp_details into l_placement_id, l_spp_eff_start_date,

Line 650: hr_utility.set_location('End date the SPP', 90);

646: fetch change_grade_to_null into l_dummy;
647: if change_grade_to_null%found and l_dummy = 'Y' then
648:
649: hr_utility.set_location('Updation on Assignment was grade to null ', 90);
650: hr_utility.set_location('End date the SPP', 90);
651:
652: open spp_details(l_assignment_id, l_asg_eff_start_date);
653: fetch spp_details into l_placement_id, l_spp_eff_start_date,
654: l_spp_eff_end_date, l_object_version_number, l_step_id;

Line 656: hr_utility.set_location('SPP found', 100);

652: open spp_details(l_assignment_id, l_asg_eff_start_date);
653: fetch spp_details into l_placement_id, l_spp_eff_start_date,
654: l_spp_eff_end_date, l_object_version_number, l_step_id;
655: if spp_details%found then
656: hr_utility.set_location('SPP found', 100);
657: hr_utility.set_location('Placement ID: '||l_placement_id, 100);
658: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 100);
659: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 100);
660: hr_utility.set_location('Object version number: '||l_object_version_number, 100);

Line 657: hr_utility.set_location('Placement ID: '||l_placement_id, 100);

653: fetch spp_details into l_placement_id, l_spp_eff_start_date,
654: l_spp_eff_end_date, l_object_version_number, l_step_id;
655: if spp_details%found then
656: hr_utility.set_location('SPP found', 100);
657: hr_utility.set_location('Placement ID: '||l_placement_id, 100);
658: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 100);
659: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 100);
660: hr_utility.set_location('Object version number: '||l_object_version_number, 100);
661: hr_utility.set_location('Step ID: '||l_step_id, 100);

Line 658: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 100);

654: l_spp_eff_end_date, l_object_version_number, l_step_id;
655: if spp_details%found then
656: hr_utility.set_location('SPP found', 100);
657: hr_utility.set_location('Placement ID: '||l_placement_id, 100);
658: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 100);
659: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 100);
660: hr_utility.set_location('Object version number: '||l_object_version_number, 100);
661: hr_utility.set_location('Step ID: '||l_step_id, 100);
662: --

Line 659: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 100);

655: if spp_details%found then
656: hr_utility.set_location('SPP found', 100);
657: hr_utility.set_location('Placement ID: '||l_placement_id, 100);
658: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 100);
659: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 100);
660: hr_utility.set_location('Object version number: '||l_object_version_number, 100);
661: hr_utility.set_location('Step ID: '||l_step_id, 100);
662: --
663: BEGIN

Line 660: hr_utility.set_location('Object version number: '||l_object_version_number, 100);

656: hr_utility.set_location('SPP found', 100);
657: hr_utility.set_location('Placement ID: '||l_placement_id, 100);
658: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 100);
659: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 100);
660: hr_utility.set_location('Object version number: '||l_object_version_number, 100);
661: hr_utility.set_location('Step ID: '||l_step_id, 100);
662: --
663: BEGIN
664: hr_sp_placement_api.delete_spp

Line 661: hr_utility.set_location('Step ID: '||l_step_id, 100);

657: hr_utility.set_location('Placement ID: '||l_placement_id, 100);
658: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 100);
659: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 100);
660: hr_utility.set_location('Object version number: '||l_object_version_number, 100);
661: hr_utility.set_location('Step ID: '||l_step_id, 100);
662: --
663: BEGIN
664: hr_sp_placement_api.delete_spp
665: (p_validate => false

Line 673: hr_utility.set_location('SPP end dated with '||

669: ,p_object_version_number => l_object_version_number
670: ,p_effective_start_date => l_effective_start_date
671: ,p_effective_end_date => l_effective_end_date
672: );
673: hr_utility.set_location('SPP end dated with '||
674: (to_char((l_asg_eff_start_date-1),'DD-MON-RRRR')), 110);
675:
676: EXCEPTION
677: when others then

Line 678: hr_utility.trace('Cannot process Placement id '||to_char(l_placement_id));

674: (to_char((l_asg_eff_start_date-1),'DD-MON-RRRR')), 110);
675:
676: EXCEPTION
677: when others then
678: hr_utility.trace('Cannot process Placement id '||to_char(l_placement_id));
679: hr_utility.trace('Effective start date '||to_char(l_spp_eff_start_date));
680: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));
681: END;
682: --

Line 679: hr_utility.trace('Effective start date '||to_char(l_spp_eff_start_date));

675:
676: EXCEPTION
677: when others then
678: hr_utility.trace('Cannot process Placement id '||to_char(l_placement_id));
679: hr_utility.trace('Effective start date '||to_char(l_spp_eff_start_date));
680: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));
681: END;
682: --
683: else

Line 680: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));

676: EXCEPTION
677: when others then
678: hr_utility.trace('Cannot process Placement id '||to_char(l_placement_id));
679: hr_utility.trace('Effective start date '||to_char(l_spp_eff_start_date));
680: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));
681: END;
682: --
683: else
684: hr_utility.set_location('No SPP found.', 120);

Line 684: hr_utility.set_location('No SPP found.', 120);

680: hr_utility.trace('Encountered error - ORA: '||to_char(SQLCODE));
681: END;
682: --
683: else
684: hr_utility.set_location('No SPP found.', 120);
685: end if;
686: close spp_details;
687:
688: end if;

Line 690: hr_utility.set_location(l_proc, 125);

686: close spp_details;
687:
688: end if;
689: close change_grade_to_null;
690: hr_utility.set_location(l_proc, 125);
691: --
692: --
693: --
694: open change_grade_update(l_assignment_id, l_asg_eff_start_date, l_grade_id);

Line 698: hr_utility.set_location('Updation on Assignment was Grade1 to Grade2 ', 130);

694: open change_grade_update(l_assignment_id, l_asg_eff_start_date, l_grade_id);
695: fetch change_grade_update into l_dummy;
696: if change_grade_update%found and l_dummy = 'Y' then
697:
698: hr_utility.set_location('Updation on Assignment was Grade1 to Grade2 ', 130);
699: hr_utility.set_location('So if any SPP found then update with lowest step_id', 130);
700:
701: open spp_details(l_assignment_id, l_asg_eff_start_date);
702: fetch spp_details into l_placement_id, l_spp_eff_start_date,

Line 699: hr_utility.set_location('So if any SPP found then update with lowest step_id', 130);

695: fetch change_grade_update into l_dummy;
696: if change_grade_update%found and l_dummy = 'Y' then
697:
698: hr_utility.set_location('Updation on Assignment was Grade1 to Grade2 ', 130);
699: hr_utility.set_location('So if any SPP found then update with lowest step_id', 130);
700:
701: open spp_details(l_assignment_id, l_asg_eff_start_date);
702: fetch spp_details into l_placement_id, l_spp_eff_start_date,
703: l_spp_eff_end_date, l_object_version_number,l_step_id;

Line 707: hr_utility.set_location('SPP found', 140);

703: l_spp_eff_end_date, l_object_version_number,l_step_id;
704:
705: if spp_details%found then
706:
707: hr_utility.set_location('SPP found', 140);
708: hr_utility.set_location('Placement ID: '||l_placement_id, 140);
709: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 140);
710: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 140);
711: hr_utility.set_location('Object version number: '||l_object_version_number, 140);

Line 708: hr_utility.set_location('Placement ID: '||l_placement_id, 140);

704:
705: if spp_details%found then
706:
707: hr_utility.set_location('SPP found', 140);
708: hr_utility.set_location('Placement ID: '||l_placement_id, 140);
709: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 140);
710: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 140);
711: hr_utility.set_location('Object version number: '||l_object_version_number, 140);
712: hr_utility.set_location('Step ID: '||l_step_id, 140);

Line 709: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 140);

705: if spp_details%found then
706:
707: hr_utility.set_location('SPP found', 140);
708: hr_utility.set_location('Placement ID: '||l_placement_id, 140);
709: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 140);
710: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 140);
711: hr_utility.set_location('Object version number: '||l_object_version_number, 140);
712: hr_utility.set_location('Step ID: '||l_step_id, 140);
713:

Line 710: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 140);

706:
707: hr_utility.set_location('SPP found', 140);
708: hr_utility.set_location('Placement ID: '||l_placement_id, 140);
709: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 140);
710: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 140);
711: hr_utility.set_location('Object version number: '||l_object_version_number, 140);
712: hr_utility.set_location('Step ID: '||l_step_id, 140);
713:
714: hr_assignment_internal.maintain_spp_asg

Line 711: hr_utility.set_location('Object version number: '||l_object_version_number, 140);

707: hr_utility.set_location('SPP found', 140);
708: hr_utility.set_location('Placement ID: '||l_placement_id, 140);
709: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 140);
710: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 140);
711: hr_utility.set_location('Object version number: '||l_object_version_number, 140);
712: hr_utility.set_location('Step ID: '||l_step_id, 140);
713:
714: hr_assignment_internal.maintain_spp_asg
715: (p_assignment_id => l_assignment_id

Line 712: hr_utility.set_location('Step ID: '||l_step_id, 140);

708: hr_utility.set_location('Placement ID: '||l_placement_id, 140);
709: hr_utility.set_location('Effective start date: '||l_spp_eff_start_date, 140);
710: hr_utility.set_location('Effective end date: '||l_spp_eff_end_date, 140);
711: hr_utility.set_location('Object version number: '||l_object_version_number, 140);
712: hr_utility.set_location('Step ID: '||l_step_id, 140);
713:
714: hr_assignment_internal.maintain_spp_asg
715: (p_assignment_id => l_assignment_id
716: ,p_datetrack_mode => 'UPDATE'

Line 723: hr_utility.set_location('No SPP found.', 160);

719: ,p_grade_id => l_grade_id
720: ,p_spp_delete_warning => l_spp_delete_warning);
721: else
722:
723: hr_utility.set_location('No SPP found.', 160);
724:
725: end if;
726: close spp_details;
727:

Line 731: hr_utility.set_location(l_proc, 170);

727:
728:
729: end if;
730: close change_grade_update;
731: hr_utility.set_location(l_proc, 170);
732: --
733: END LOOP;
734: hr_utility.set_location('Leaving '||l_proc, 180);
735: --

Line 734: hr_utility.set_location('Leaving '||l_proc, 180);

730: close change_grade_update;
731: hr_utility.set_location(l_proc, 170);
732: --
733: END LOOP;
734: hr_utility.set_location('Leaving '||l_proc, 180);
735: --
736: END Sync_spp_asg;
737: --
738: -- Bug 2977842 ends here.

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

790: where step_id = p_rec.step_id;
791: -- Code changes end for bug 7457065
792:
793: Begin
794: hr_utility.set_location('Entering:'||l_proc, 5);
795:
796: -- Code changes start for bug 7457065
797: open c_step_end_date;
798: fetch c_step_end_date into l_step_end_date;

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

797: open c_step_end_date;
798: fetch c_step_end_date into l_step_end_date;
799: close c_step_end_date;
800: --
801: hr_utility.set_location(l_proc, 6);
802: --
803: if l_step_end_date < p_rec.effective_end_date then
804:
805: update per_spinal_point_placements_f

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

807: where placement_id = p_rec.placement_id
808: and effective_start_date = p_rec.effective_start_date;
809:
810: end if;
811: hr_utility.set_location(l_proc, 7);
812:
813: -- Code changes end for bug 7457065
814:
815: begin

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

888: ,p_effective_date => p_effective_date);
889: --
890: --Bug 2977842 ends here.
891: --
892: hr_utility.set_location(' Leaving:'||l_proc, 10);
893: End post_insert;
894: --
895: -- ----------------------------------------------------------------------------
896: -- |-------------------------------< ins_lck >--------------------------------|

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

948: l_enforce_foreign_locking boolean;
949: -- bug 3158554 ends here.
950: --
951: Begin
952: hr_utility.set_location('Entering:'||l_proc, 5);
953: --
954: -- Validate the datetrack mode mode getting the validation start
955: -- and end dates for the specified datetrack operation.
956: --

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

1023: --p_validation_start_date := l_validation_start_date;
1024: --p_validation_end_date := l_validation_end_date;
1025: --
1026: -- bug 3158554 ends here..
1027: hr_utility.set_location(' Leaving:'||l_proc, 10);
1028: --
1029: End ins_lck;
1030: --
1031: -- ----------------------------------------------------------------------------

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

1042: l_validation_start_date date;
1043: l_validation_end_date date;
1044: --
1045: Begin
1046: hr_utility.set_location('Entering:'||l_proc, 5);
1047: --
1048: -- Call the supporting insert validate operations
1049: --
1050: per_spp_bus.insert_validate

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

1108: ,p_replace_future_spp => p_replace_future_spp --Added for bug 2977842.
1109: );
1110:
1111: --
1112: hr_utility.set_location('Leaving:'||l_proc,10);
1113: end ins;
1114: --
1115: -- ----------------------------------------------------------------------------
1116: -- |---------------------------------< ins >----------------------------------|

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

1181: and p_effective_date between pgs.effective_start_date
1182: and pgs.effective_end_date;
1183: Begin
1184: --
1185: hr_utility.set_location('Entering:'||l_proc, 10);
1186: --
1187: -- Get the parent_spine_id (Not passed in api as updated in the assignment
1188: -- form)
1189: --

Line 1198: hr_utility.raise_error;

1194: --
1195: close chk_step_valid_for_grade;
1196: --
1197: fnd_message.set_name('PER', 'HR_289834_STEP_INV_FOR_GRADE');
1198: hr_utility.raise_error;
1199: --
1200: end if;
1201: --
1202: close chk_step_valid_for_grade;

Line 1275: hr_utility.set_location(' Leaving:'||l_proc, 999);

1271: p_effective_end_date := l_rec.effective_end_date;
1272: p_object_version_number := l_rec.object_version_number;
1273: --
1274: --
1275: hr_utility.set_location(' Leaving:'||l_proc, 999);
1276: --
1277: End ins;
1278: --
1279: end per_spp_ins;