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 555: hr_utility.set_location(l_proc, 20);

551: fetch spp_details into l_placement_id, l_spp_eff_start_date, l_spp_eff_end_date,
552: l_object_version_number, l_step_id;
553: if spp_details%found then
554: --
555: hr_utility.set_location(l_proc, 20);
556: hr_sp_placement_api.delete_spp
557: (p_validate => false
558: ,p_effective_date => l_end_date
559: ,p_datetrack_mode => 'DELETE'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

780: --
781: l_proc varchar2(72) := g_package||'post_insert';
782: --
783: Begin
784: hr_utility.set_location('Entering:'||l_proc, 5);
785: begin
786: --
787: per_spp_rki.after_insert
788: (p_effective_date => p_effective_date

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

858: ,p_effective_date => p_effective_date);
859: --
860: --Bug 2977842 ends here.
861: --
862: hr_utility.set_location(' Leaving:'||l_proc, 10);
863: End post_insert;
864: --
865: -- ----------------------------------------------------------------------------
866: -- |-------------------------------< ins_lck >--------------------------------|

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

918: l_enforce_foreign_locking boolean;
919: -- bug 3158554 ends here.
920: --
921: Begin
922: hr_utility.set_location('Entering:'||l_proc, 5);
923: --
924: -- Validate the datetrack mode mode getting the validation start
925: -- and end dates for the specified datetrack operation.
926: --

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

993: --p_validation_start_date := l_validation_start_date;
994: --p_validation_end_date := l_validation_end_date;
995: --
996: -- bug 3158554 ends here..
997: hr_utility.set_location(' Leaving:'||l_proc, 10);
998: --
999: End ins_lck;
1000: --
1001: -- ----------------------------------------------------------------------------

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

1012: l_validation_start_date date;
1013: l_validation_end_date date;
1014: --
1015: Begin
1016: hr_utility.set_location('Entering:'||l_proc, 5);
1017: --
1018: -- Call the supporting insert validate operations
1019: --
1020: per_spp_bus.insert_validate

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

1078: ,p_replace_future_spp => p_replace_future_spp --Added for bug 2977842.
1079: );
1080:
1081: --
1082: hr_utility.set_location('Leaving:'||l_proc,10);
1083: end ins;
1084: --
1085: -- ----------------------------------------------------------------------------
1086: -- |---------------------------------< ins >----------------------------------|

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

1151: and p_effective_date between pgs.effective_start_date
1152: and pgs.effective_end_date;
1153: Begin
1154: --
1155: hr_utility.set_location('Entering:'||l_proc, 10);
1156: --
1157: -- Get the parent_spine_id (Not passed in api as updated in the assignment
1158: -- form)
1159: --

Line 1168: hr_utility.raise_error;

1164: --
1165: close chk_step_valid_for_grade;
1166: --
1167: fnd_message.set_name('PER', 'HR_289834_STEP_INV_FOR_GRADE');
1168: hr_utility.raise_error;
1169: --
1170: end if;
1171: --
1172: close chk_step_valid_for_grade;

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

1241: p_effective_end_date := l_rec.effective_end_date;
1242: p_object_version_number := l_rec.object_version_number;
1243: --
1244: --
1245: hr_utility.set_location(' Leaving:'||l_proc, 999);
1246: --
1247: End ins;
1248: --
1249: end per_spp_ins;