APPS.HRSPINE dependencies on HR_UTILITY

Line 318: hr_utility.set_location(l_function,10);

314: l_function varchar2(30) := 'Increment Function';
315:
316: begin
317:
318: hr_utility.set_location(l_function,10);
319: hr_utility.set_location('p_placement_id - '||p_placement_id,50);
320: hr_utility.set_location('p_effective_start_date - '||p_effective_start_date,50);
321: hr_utility.set_location('p_step_id - '||p_step_id,50);
322: hr_utility.set_location('p_grade_spine_id - '||p_grade_spine_id,50);

Line 319: hr_utility.set_location('p_placement_id - '||p_placement_id,50);

315:
316: begin
317:
318: hr_utility.set_location(l_function,10);
319: hr_utility.set_location('p_placement_id - '||p_placement_id,50);
320: hr_utility.set_location('p_effective_start_date - '||p_effective_start_date,50);
321: hr_utility.set_location('p_step_id - '||p_step_id,50);
322: hr_utility.set_location('p_grade_spine_id - '||p_grade_spine_id,50);
323:

Line 320: hr_utility.set_location('p_effective_start_date - '||p_effective_start_date,50);

316: begin
317:
318: hr_utility.set_location(l_function,10);
319: hr_utility.set_location('p_placement_id - '||p_placement_id,50);
320: hr_utility.set_location('p_effective_start_date - '||p_effective_start_date,50);
321: hr_utility.set_location('p_step_id - '||p_step_id,50);
322: hr_utility.set_location('p_grade_spine_id - '||p_grade_spine_id,50);
323:
324: open csr_increment1;

Line 321: hr_utility.set_location('p_step_id - '||p_step_id,50);

317:
318: hr_utility.set_location(l_function,10);
319: hr_utility.set_location('p_placement_id - '||p_placement_id,50);
320: hr_utility.set_location('p_effective_start_date - '||p_effective_start_date,50);
321: hr_utility.set_location('p_step_id - '||p_step_id,50);
322: hr_utility.set_location('p_grade_spine_id - '||p_grade_spine_id,50);
323:
324: open csr_increment1;
325: fetch csr_increment1 into l_increment1;

Line 322: hr_utility.set_location('p_grade_spine_id - '||p_grade_spine_id,50);

318: hr_utility.set_location(l_function,10);
319: hr_utility.set_location('p_placement_id - '||p_placement_id,50);
320: hr_utility.set_location('p_effective_start_date - '||p_effective_start_date,50);
321: hr_utility.set_location('p_step_id - '||p_step_id,50);
322: hr_utility.set_location('p_grade_spine_id - '||p_grade_spine_id,50);
323:
324: open csr_increment1;
325: fetch csr_increment1 into l_increment1;
326: close csr_increment1;

Line 328: hr_utility.set_location('l_increment1 (1st SPP Record) - '||l_increment1,60);

324: open csr_increment1;
325: fetch csr_increment1 into l_increment1;
326: close csr_increment1;
327:
328: hr_utility.set_location('l_increment1 (1st SPP Record) - '||l_increment1,60);
329:
330: open csr_increment2;
331: fetch csr_increment2 into l_increment2;
332: close csr_increment2;

Line 334: hr_utility.set_location('l_increment2 (No Step Change) - '||l_increment2,60);

330: open csr_increment2;
331: fetch csr_increment2 into l_increment2;
332: close csr_increment2;
333:
334: hr_utility.set_location('l_increment2 (No Step Change) - '||l_increment2,60);
335:
336: open csr_increment3;
337: fetch csr_increment3 into l_increment3;
338: close csr_increment3;

Line 340: hr_utility.set_location('l_increment3 (Grade Scale Auto Change) - '||l_increment3,60);

336: open csr_increment3;
337: fetch csr_increment3 into l_increment3;
338: close csr_increment3;
339:
340: hr_utility.set_location('l_increment3 (Grade Scale Auto Change) - '||l_increment3,60);
341:
342: open csr_increment4;
343: fetch csr_increment4 into l_increment4;
344: close csr_increment4;

Line 346: hr_utility.set_location('l_increment4 (1st Grade Spinal Point) - '||l_increment4,60);

342: open csr_increment4;
343: fetch csr_increment4 into l_increment4;
344: close csr_increment4;
345:
346: hr_utility.set_location('l_increment4 (1st Grade Spinal Point) - '||l_increment4,60);
347:
348: open csr_all_placements;
349: fetch csr_all_placements into l_dummy;
350: close csr_all_placements;

Line 352: hr_utility.set_location('l_dummy (Placement ID to be returned) - '||l_dummy,70);

348: open csr_all_placements;
349: fetch csr_all_placements into l_dummy;
350: close csr_all_placements;
351:
352: hr_utility.set_location('l_dummy (Placement ID to be returned) - '||l_dummy,70);
353:
354: hr_utility.set_location('End of '||l_function,80);
355:
356: return l_dummy;

Line 354: hr_utility.set_location('End of '||l_function,80);

350: close csr_all_placements;
351:
352: hr_utility.set_location('l_dummy (Placement ID to be returned) - '||l_dummy,70);
353:
354: hr_utility.set_location('End of '||l_function,80);
355:
356: return l_dummy;
357:
358: end func_increment;

Line 397: hr_utility.set_location(l_package,1);

393: l_package varchar2(30) := 'Business Rule Check';
394:
395: begin
396:
397: hr_utility.set_location(l_package,1);
398: hr_utility.set_location('p_business_rule - '||p_business_rule,1);
399: hr_utility.set_location('p_br_date_from - '||p_br_date_from,1);
400: hr_utility.set_location('p_br_date_to - '||p_br_date_to,1);
401: hr_utility.set_location('p_dependant_date - '||p_dependant_date,1);

Line 398: hr_utility.set_location('p_business_rule - '||p_business_rule,1);

394:
395: begin
396:
397: hr_utility.set_location(l_package,1);
398: hr_utility.set_location('p_business_rule - '||p_business_rule,1);
399: hr_utility.set_location('p_br_date_from - '||p_br_date_from,1);
400: hr_utility.set_location('p_br_date_to - '||p_br_date_to,1);
401: hr_utility.set_location('p_dependant_date - '||p_dependant_date,1);
402:

Line 399: hr_utility.set_location('p_br_date_from - '||p_br_date_from,1);

395: begin
396:
397: hr_utility.set_location(l_package,1);
398: hr_utility.set_location('p_business_rule - '||p_business_rule,1);
399: hr_utility.set_location('p_br_date_from - '||p_br_date_from,1);
400: hr_utility.set_location('p_br_date_to - '||p_br_date_to,1);
401: hr_utility.set_location('p_dependant_date - '||p_dependant_date,1);
402:
403: --

Line 400: hr_utility.set_location('p_br_date_to - '||p_br_date_to,1);

396:
397: hr_utility.set_location(l_package,1);
398: hr_utility.set_location('p_business_rule - '||p_business_rule,1);
399: hr_utility.set_location('p_br_date_from - '||p_br_date_from,1);
400: hr_utility.set_location('p_br_date_to - '||p_br_date_to,1);
401: hr_utility.set_location('p_dependant_date - '||p_dependant_date,1);
402:
403: --
404: -- Check if the business rule has not been set that all other business rule

Line 401: hr_utility.set_location('p_dependant_date - '||p_dependant_date,1);

397: hr_utility.set_location(l_package,1);
398: hr_utility.set_location('p_business_rule - '||p_business_rule,1);
399: hr_utility.set_location('p_br_date_from - '||p_br_date_from,1);
400: hr_utility.set_location('p_br_date_to - '||p_br_date_to,1);
401: hr_utility.set_location('p_dependant_date - '||p_dependant_date,1);
402:
403: --
404: -- Check if the business rule has not been set that all other business rule
405: -- only parameters are null, else raise an error.

Line 414: hr_utility.raise_error;

410: or p_br_date_to is not null
411: or p_dependant_date is not null then
412:
413: fnd_message.set_name('PER', 'HR_289506_SPP_BR_NULL');
414: hr_utility.raise_error;
415:
416: end if;
417:
418: end if;

Line 443: hr_utility.raise_error;

439:
440: if p_business_rule not IN ('AOJ','DOB','ASD','LHD') then
441:
442: fnd_message.set_name('PER', 'HR_289507_SPP_BR_INVALID');
443: hr_utility.raise_error;
444:
445: end if;
446:
447: --

Line 455: hr_utility.raise_error;

451: if p_br_date_from is null
452: or p_br_date_to is null then
453:
454: fnd_message.set_name('PER', 'HR_289510_SPP_BR_DATE_NULL');
455: hr_utility.raise_error;
456:
457: elsif nvl(l_br_date_to,l_br_date_from) < nvl(l_br_date_from,l_br_date_to) then
458:
459: -- The business rule date from is greater than the date to

Line 463: hr_utility.raise_error;

459: -- The business rule date from is greater than the date to
460: -- so raise an error accordingly
461:
462: fnd_message.set_name('PER', 'HR_289500_SPP_BR_DATE');
463: hr_utility.raise_error;
464:
465: elsif nvl(l_br_date_to,l_br_date_from) >= nvl(l_br_date_from,l_br_date_to) then
466:
467: -- The business rule dates are valid, now check that the gap between is not

Line 475: hr_utility.raise_error;

471:
472: -- Gap is greater than one year, so raise error
473:
474: fnd_message.set_name('PER', 'HR_289501_SPP_BR_YEAR_GREATER');
475: hr_utility.raise_error;
476:
477: end if;
478:
479: end if;

Line 489: hr_utility.raise_error;

485:
486: -- raise error as process doesn't know what date to increment assignments on
487:
488: fnd_message.set_name('PER', 'HR_289502_SPP_DEPEND_DATE');
489: hr_utility.raise_error;
490:
491: end if;
492:
493: --

Line 509: hr_utility.raise_error;

505: -- Raise error due to effective date not being between business rule dates
506: --
507:
508: fnd_message.set_name('PER', 'HR_289503_SPP_EFF_BR_DATE');
509: hr_utility.raise_error;
510:
511: end if;
512:
513: --

Line 524: hr_utility.raise_error;

520: -- Raise error due to year from being greater than the year to
521: --
522:
523: fnd_message.set_name('PER', 'HR_289504_SPP_BR_YEAR_FROM_TO');
524: hr_utility.raise_error;
525:
526: end if;
527:
528: else

Line 635: hr_utility.set_location('MAX POINT REACHED!',20);

631: FETCH csr_next_sequence into l_next_sequence_number,
632: l_next_spinal_point;
633:
634: if csr_next_sequence%notfound then
635: hr_utility.set_location('MAX POINT REACHED!',20);
636: l_update := 'N';
637: l_exception_report1 := 'Y';
638: exit;
639:

Line 641: hr_utility.set_location('FOUND',21);

637: l_exception_report1 := 'Y';
638: exit;
639:
640: else
641: hr_utility.set_location('FOUND',21);
642: l_zero := l_zero+1;
643: l_update := 'Y';
644:
645: if p_increment_number = l_zero then

Line 672: hr_utility.set_location('get step id',1313);

668: -- select statement to get new step id for assignment
669: -- ------------------------------------------------------------------
670: --
671: BEGIN
672: hr_utility.set_location('get step id',1313);
673: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1313);
674: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1313);
675: hr_utility.set_location('l_next_sequence_number '
676: ||l_next_sequence_number,1313);

Line 673: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1313);

669: -- ------------------------------------------------------------------
670: --
671: BEGIN
672: hr_utility.set_location('get step id',1313);
673: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1313);
674: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1313);
675: hr_utility.set_location('l_next_sequence_number '
676: ||l_next_sequence_number,1313);
677: select step_id

Line 674: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1313);

670: --
671: BEGIN
672: hr_utility.set_location('get step id',1313);
673: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1313);
674: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1313);
675: hr_utility.set_location('l_next_sequence_number '
676: ||l_next_sequence_number,1313);
677: select step_id
678: into l_new_step_id

Line 675: hr_utility.set_location('l_next_sequence_number '

671: BEGIN
672: hr_utility.set_location('get step id',1313);
673: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1313);
674: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1313);
675: hr_utility.set_location('l_next_sequence_number '
676: ||l_next_sequence_number,1313);
677: select step_id
678: into l_new_step_id
679: from per_spinal_point_steps_f

Line 686: hr_utility.set_location('NO_DATA_FOUND',1314);

682: and spinal_point_id = l_next_spinal_point;
683: EXCEPTION
684: WHEN NO_DATA_FOUND
685: THEN
686: hr_utility.set_location('NO_DATA_FOUND',1314);
687: hr_utility.set_location('step id',1314);
688: hr_utility.set_location('not found for l_next_sequence_number'
689: ||l_next_sequence_number, 1314);
690: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1314);

Line 687: hr_utility.set_location('step id',1314);

683: EXCEPTION
684: WHEN NO_DATA_FOUND
685: THEN
686: hr_utility.set_location('NO_DATA_FOUND',1314);
687: hr_utility.set_location('step id',1314);
688: hr_utility.set_location('not found for l_next_sequence_number'
689: ||l_next_sequence_number, 1314);
690: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1314);
691: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1314);

Line 688: hr_utility.set_location('not found for l_next_sequence_number'

684: WHEN NO_DATA_FOUND
685: THEN
686: hr_utility.set_location('NO_DATA_FOUND',1314);
687: hr_utility.set_location('step id',1314);
688: hr_utility.set_location('not found for l_next_sequence_number'
689: ||l_next_sequence_number, 1314);
690: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1314);
691: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1314);
692: END;

Line 690: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1314);

686: hr_utility.set_location('NO_DATA_FOUND',1314);
687: hr_utility.set_location('step id',1314);
688: hr_utility.set_location('not found for l_next_sequence_number'
689: ||l_next_sequence_number, 1314);
690: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1314);
691: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1314);
692: END;
693: --
694: -- Now update all the records using the api

Line 691: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1314);

687: hr_utility.set_location('step id',1314);
688: hr_utility.set_location('not found for l_next_sequence_number'
689: ||l_next_sequence_number, 1314);
690: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id,1314);
691: hr_utility.set_location('l_next_spinal_point '||l_next_spinal_point,1314);
692: END;
693: --
694: -- Now update all the records using the api
695: --

Line 713: hr_utility.set_location ('Before HR_SPP_EXCEPTION_DATA.populate_spp_table',101);

709: ,p_effective_start_date => l_effective_start_date
710: ,p_effective_end_date => l_effective_end_date
711: );
712: --
713: hr_utility.set_location ('Before HR_SPP_EXCEPTION_DATA.populate_spp_table',101);
714: hr_utility.set_location ('l_exception_report_1 = '||l_exception_report1,151);
715: --
716: ----------------------------------------------------------------------------
717: -- Update the what if table with the updated record

Line 714: hr_utility.set_location ('l_exception_report_1 = '||l_exception_report1,151);

710: ,p_effective_end_date => l_effective_end_date
711: );
712: --
713: hr_utility.set_location ('Before HR_SPP_EXCEPTION_DATA.populate_spp_table',101);
714: hr_utility.set_location ('l_exception_report_1 = '||l_exception_report1,151);
715: --
716: ----------------------------------------------------------------------------
717: -- Update the what if table with the updated record
718: -- --------------------------------------------------------------------------

Line 719: hr_utility.set_location ('HR_SPP_WI_DATA.populate_spp_wi_table',121);

715: --
716: ----------------------------------------------------------------------------
717: -- Update the what if table with the updated record
718: -- --------------------------------------------------------------------------
719: hr_utility.set_location ('HR_SPP_WI_DATA.populate_spp_wi_table',121);
720: hr_utility.set_location ('HR_SPP_WI_DATA - Placement:'||p_placement_id,121);
721: hr_utility.set_location ('HR_SPP_WI_DATA - Assignment:'||p_assignment_id,121);
722: --
723: HR_SPP_WI_DATA.populate_spp_wi_table

Line 720: hr_utility.set_location ('HR_SPP_WI_DATA - Placement:'||p_placement_id,121);

716: ----------------------------------------------------------------------------
717: -- Update the what if table with the updated record
718: -- --------------------------------------------------------------------------
719: hr_utility.set_location ('HR_SPP_WI_DATA.populate_spp_wi_table',121);
720: hr_utility.set_location ('HR_SPP_WI_DATA - Placement:'||p_placement_id,121);
721: hr_utility.set_location ('HR_SPP_WI_DATA - Assignment:'||p_assignment_id,121);
722: --
723: HR_SPP_WI_DATA.populate_spp_wi_table
724: (p_placement_id => p_placement_id

Line 721: hr_utility.set_location ('HR_SPP_WI_DATA - Assignment:'||p_assignment_id,121);

717: -- Update the what if table with the updated record
718: -- --------------------------------------------------------------------------
719: hr_utility.set_location ('HR_SPP_WI_DATA.populate_spp_wi_table',121);
720: hr_utility.set_location ('HR_SPP_WI_DATA - Placement:'||p_placement_id,121);
721: hr_utility.set_location ('HR_SPP_WI_DATA - Assignment:'||p_assignment_id,121);
722: --
723: HR_SPP_WI_DATA.populate_spp_wi_table
724: (p_placement_id => p_placement_id
725: ,p_assignment_id => p_assignment_id

Line 748: hr_utility.set_location

744: -- --------------------------------------------------------------------------
745: --
746: if (l_exception_report1 = 'Y')
747: then
748: hr_utility.set_location
749: ('Populating HR_SPP_EXCEPTION_DATA.populate_spp_table',102);
750: -- vik failing with no data found here.
751: -- but why doesn't the comment show up on the trace?
752: HR_SPP_EXCEPTION_DATA.populate_spp_table

Line 835: hr_utility.set_location('Entering check_increment_available procedure',5);

831:
832:
833: begin
834:
835: hr_utility.set_location('Entering check_increment_available procedure',5);
836:
837: l_future_sequence_id := null;
838: l_update := 'Y';
839:

Line 851: hr_utility.set_location('NO_DATA_FOUND',1315);

847: where placement_id = p_placement_id;
848: EXCEPTION
849: WHEN NO_DATA_FOUND
850: THEN
851: hr_utility.set_location('NO_DATA_FOUND',1315);
852: hr_utility.set_location('max(effective_end_date) ',1315);
853: hr_utility.set_location('not found for p_placement_id '
854: ||p_placement_id, 1315);
855: END;

Line 852: hr_utility.set_location('max(effective_end_date) ',1315);

848: EXCEPTION
849: WHEN NO_DATA_FOUND
850: THEN
851: hr_utility.set_location('NO_DATA_FOUND',1315);
852: hr_utility.set_location('max(effective_end_date) ',1315);
853: hr_utility.set_location('not found for p_placement_id '
854: ||p_placement_id, 1315);
855: END;
856: --

Line 853: hr_utility.set_location('not found for p_placement_id '

849: WHEN NO_DATA_FOUND
850: THEN
851: hr_utility.set_location('NO_DATA_FOUND',1315);
852: hr_utility.set_location('max(effective_end_date) ',1315);
853: hr_utility.set_location('not found for p_placement_id '
854: ||p_placement_id, 1315);
855: END;
856: --
857: if (p_end_date = l_max_end_date)

Line 860: hr_utility.set_location('Datetrack mode = UPDATE',10);

856: --
857: if (p_end_date = l_max_end_date)
858: and (P_Effective_Date <> p_effective_start_date)
859: then
860: hr_utility.set_location('Datetrack mode = UPDATE',10);
861: l_datetrack_mode := 'UPDATE';
862: elsif
863: (P_Effective_Date = p_effective_start_date)
864: then

Line 865: hr_utility.set_location('Datetrack mode = CORRECTION',10);

861: l_datetrack_mode := 'UPDATE';
862: elsif
863: (P_Effective_Date = p_effective_start_date)
864: then
865: hr_utility.set_location('Datetrack mode = CORRECTION',10);
866: l_datetrack_mode := 'CORRECTION';
867: else
868: hr_utility.set_location('Datetrack mode = UPDATE_CHANGE_INSERT',10);
869: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';

Line 868: hr_utility.set_location('Datetrack mode = UPDATE_CHANGE_INSERT',10);

864: then
865: hr_utility.set_location('Datetrack mode = CORRECTION',10);
866: l_datetrack_mode := 'CORRECTION';
867: else
868: hr_utility.set_location('Datetrack mode = UPDATE_CHANGE_INSERT',10);
869: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
870: end if;
871: --
872: p_datetrack_mode := l_datetrack_mode;

Line 877: hr_utility.set_location('max_end_date:'||l_max_end_date,170);

873: --
874: -- ------------------------------------------------------------------
875: -- Get the step_id,sequence number for the future record
876: -- ------------------------------------------------------------------
877: hr_utility.set_location('max_end_date:'||l_max_end_date,170);
878: hr_utility.set_location('L_End_Date:'||p_end_date,170);
879: hr_utility.set_location('p_placement_id - '||p_placement_id,333);
880: if p_end_date <> hr_api.g_eot
881: and p_end_date <> l_max_end_date

Line 878: hr_utility.set_location('L_End_Date:'||p_end_date,170);

874: -- ------------------------------------------------------------------
875: -- Get the step_id,sequence number for the future record
876: -- ------------------------------------------------------------------
877: hr_utility.set_location('max_end_date:'||l_max_end_date,170);
878: hr_utility.set_location('L_End_Date:'||p_end_date,170);
879: hr_utility.set_location('p_placement_id - '||p_placement_id,333);
880: if p_end_date <> hr_api.g_eot
881: and p_end_date <> l_max_end_date
882: then

Line 879: hr_utility.set_location('p_placement_id - '||p_placement_id,333);

875: -- Get the step_id,sequence number for the future record
876: -- ------------------------------------------------------------------
877: hr_utility.set_location('max_end_date:'||l_max_end_date,170);
878: hr_utility.set_location('L_End_Date:'||p_end_date,170);
879: hr_utility.set_location('p_placement_id - '||p_placement_id,333);
880: if p_end_date <> hr_api.g_eot
881: and p_end_date <> l_max_end_date
882: then
883: BEGIN

Line 895: hr_utility.set_location('NO_DATA_FOUND',1316);

891: and spp.step_id = sps.step_id;
892: EXCEPTION
893: WHEN NO_DATA_FOUND
894: THEN
895: hr_utility.set_location('NO_DATA_FOUND',1316);
896: hr_utility.set_location('sps.grade_spine_id ',1316);
897: hr_utility.set_location('not found for p_placement_id '
898: ||p_placement_id, 1316);
899: END;

Line 896: hr_utility.set_location('sps.grade_spine_id ',1316);

892: EXCEPTION
893: WHEN NO_DATA_FOUND
894: THEN
895: hr_utility.set_location('NO_DATA_FOUND',1316);
896: hr_utility.set_location('sps.grade_spine_id ',1316);
897: hr_utility.set_location('not found for p_placement_id '
898: ||p_placement_id, 1316);
899: END;
900: --

Line 897: hr_utility.set_location('not found for p_placement_id '

893: WHEN NO_DATA_FOUND
894: THEN
895: hr_utility.set_location('NO_DATA_FOUND',1316);
896: hr_utility.set_location('sps.grade_spine_id ',1316);
897: hr_utility.set_location('not found for p_placement_id '
898: ||p_placement_id, 1316);
899: END;
900: --
901: if nvl(l_future_grade_spine_id,-99) <> p_grade_spine_id

Line 914: hr_utility.set_location('Ceiling fetch',170);

910: l_exception_report1 := 'Y';
911: --
912: end if;
913: --
914: hr_utility.set_location('Ceiling fetch',170);
915: --
916: -- ------------------------------------------------------------------
917: -- Get the max ceiling step_id for the pay scale and the special
918: -- ceiling step id for the assignment

Line 936: hr_utility.set_location('NO_DATA_FOUND',1400);

932: and paa.effective_end_date;
933: EXCEPTION
934: WHEN NO_DATA_FOUND
935: THEN
936: hr_utility.set_location('NO_DATA_FOUND',1400);
937: hr_utility.set_location('pgs ceiling_step_id ',1400);
938: hr_utility.set_location('not found for p_assignment_id'
939: ||p_assignment_id, 1400);
940: hr_utility.set_location('p_parent_spine_id '||p_parent_spine_id, 1400);

Line 937: hr_utility.set_location('pgs ceiling_step_id ',1400);

933: EXCEPTION
934: WHEN NO_DATA_FOUND
935: THEN
936: hr_utility.set_location('NO_DATA_FOUND',1400);
937: hr_utility.set_location('pgs ceiling_step_id ',1400);
938: hr_utility.set_location('not found for p_assignment_id'
939: ||p_assignment_id, 1400);
940: hr_utility.set_location('p_parent_spine_id '||p_parent_spine_id, 1400);
941: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1400);

Line 938: hr_utility.set_location('not found for p_assignment_id'

934: WHEN NO_DATA_FOUND
935: THEN
936: hr_utility.set_location('NO_DATA_FOUND',1400);
937: hr_utility.set_location('pgs ceiling_step_id ',1400);
938: hr_utility.set_location('not found for p_assignment_id'
939: ||p_assignment_id, 1400);
940: hr_utility.set_location('p_parent_spine_id '||p_parent_spine_id, 1400);
941: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1400);
942: END;

Line 940: hr_utility.set_location('p_parent_spine_id '||p_parent_spine_id, 1400);

936: hr_utility.set_location('NO_DATA_FOUND',1400);
937: hr_utility.set_location('pgs ceiling_step_id ',1400);
938: hr_utility.set_location('not found for p_assignment_id'
939: ||p_assignment_id, 1400);
940: hr_utility.set_location('p_parent_spine_id '||p_parent_spine_id, 1400);
941: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1400);
942: END;
943: --
944: hr_utility.set_location('Max step and sequence fetch',170);

Line 941: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1400);

937: hr_utility.set_location('pgs ceiling_step_id ',1400);
938: hr_utility.set_location('not found for p_assignment_id'
939: ||p_assignment_id, 1400);
940: hr_utility.set_location('p_parent_spine_id '||p_parent_spine_id, 1400);
941: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1400);
942: END;
943: --
944: hr_utility.set_location('Max step and sequence fetch',170);
945:

Line 944: hr_utility.set_location('Max step and sequence fetch',170);

940: hr_utility.set_location('p_parent_spine_id '||p_parent_spine_id, 1400);
941: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1400);
942: END;
943: --
944: hr_utility.set_location('Max step and sequence fetch',170);
945:
946: if l_max_ceiling_step_id <> l_special_ceiling_step_id then -- 115.42 Update
947:
948: l_max_ceiling_step_id := l_special_ceiling_step_id;

Line 962: hr_utility.set_location('NO_DATA_FOUND',1500);

958: and p_effective_date between effective_start_date and effective_end_date;
959: EXCEPTION
960: WHEN NO_DATA_FOUND
961: THEN
962: hr_utility.set_location('NO_DATA_FOUND',1500);
963: hr_utility.set_location('special_ceiling_sequence ',1500);
964: hr_utility.set_location('not found for l_special_ceiling_step_id '
965: ||l_special_ceiling_step_id, 1500);
966: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);

Line 963: hr_utility.set_location('special_ceiling_sequence ',1500);

959: EXCEPTION
960: WHEN NO_DATA_FOUND
961: THEN
962: hr_utility.set_location('NO_DATA_FOUND',1500);
963: hr_utility.set_location('special_ceiling_sequence ',1500);
964: hr_utility.set_location('not found for l_special_ceiling_step_id '
965: ||l_special_ceiling_step_id, 1500);
966: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);
967: END;

Line 964: hr_utility.set_location('not found for l_special_ceiling_step_id '

960: WHEN NO_DATA_FOUND
961: THEN
962: hr_utility.set_location('NO_DATA_FOUND',1500);
963: hr_utility.set_location('special_ceiling_sequence ',1500);
964: hr_utility.set_location('not found for l_special_ceiling_step_id '
965: ||l_special_ceiling_step_id, 1500);
966: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);
967: END;
968: -- ------------------------------------------------------------------

Line 966: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);

962: hr_utility.set_location('NO_DATA_FOUND',1500);
963: hr_utility.set_location('special_ceiling_sequence ',1500);
964: hr_utility.set_location('not found for l_special_ceiling_step_id '
965: ||l_special_ceiling_step_id, 1500);
966: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);
967: END;
968: -- ------------------------------------------------------------------
969: -- Get the max step_id and seuence for the grade
970: -- ------------------------------------------------------------------

Line 984: hr_utility.set_location('NO_DATA_FOUND',1500);

980: between effective_start_date and effective_end_date);
981: EXCEPTION
982: WHEN NO_DATA_FOUND
983: THEN
984: hr_utility.set_location('NO_DATA_FOUND',1500);
985: hr_utility.set_location('sequence and step id',1500);
986: hr_utility.set_location('not found for max grade sequence and ', 1500);
987: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);
988: END;

Line 985: hr_utility.set_location('sequence and step id',1500);

981: EXCEPTION
982: WHEN NO_DATA_FOUND
983: THEN
984: hr_utility.set_location('NO_DATA_FOUND',1500);
985: hr_utility.set_location('sequence and step id',1500);
986: hr_utility.set_location('not found for max grade sequence and ', 1500);
987: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);
988: END;
989: --

Line 986: hr_utility.set_location('not found for max grade sequence and ', 1500);

982: WHEN NO_DATA_FOUND
983: THEN
984: hr_utility.set_location('NO_DATA_FOUND',1500);
985: hr_utility.set_location('sequence and step id',1500);
986: hr_utility.set_location('not found for max grade sequence and ', 1500);
987: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);
988: END;
989: --
990: if l_special_ceiling_sequence <> l_grade_max_sequence

Line 987: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);

983: THEN
984: hr_utility.set_location('NO_DATA_FOUND',1500);
985: hr_utility.set_location('sequence and step id',1500);
986: hr_utility.set_location('not found for max grade sequence and ', 1500);
987: hr_utility.set_location('p_grade_spine_id '||p_grade_spine_id, 1500);
988: END;
989: --
990: if l_special_ceiling_sequence <> l_grade_max_sequence
991: then

Line 996: hr_utility.set_location(' ***** ANOTHER PROBLEM ***** ',333);

992: l_grade_max_step_id := l_special_ceiling_step_id;
993: l_grade_max_sequence := l_special_ceiling_sequence;
994: end if;
995: --
996: hr_utility.set_location(' ***** ANOTHER PROBLEM ***** ',333);
997: hr_utility.set_location('l_grade_max_step_id - '||l_grade_max_step_id,333);
998: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
999: hr_utility.set_location('l_special_ceiling_step_id - '||l_special_ceiling_step_id,333);
1000: hr_utility.set_location('l_special_ceiling_sequence - '||l_special_ceiling_sequence,333);

Line 997: hr_utility.set_location('l_grade_max_step_id - '||l_grade_max_step_id,333);

993: l_grade_max_sequence := l_special_ceiling_sequence;
994: end if;
995: --
996: hr_utility.set_location(' ***** ANOTHER PROBLEM ***** ',333);
997: hr_utility.set_location('l_grade_max_step_id - '||l_grade_max_step_id,333);
998: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
999: hr_utility.set_location('l_special_ceiling_step_id - '||l_special_ceiling_step_id,333);
1000: hr_utility.set_location('l_special_ceiling_sequence - '||l_special_ceiling_sequence,333);
1001: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);

Line 998: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);

994: end if;
995: --
996: hr_utility.set_location(' ***** ANOTHER PROBLEM ***** ',333);
997: hr_utility.set_location('l_grade_max_step_id - '||l_grade_max_step_id,333);
998: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
999: hr_utility.set_location('l_special_ceiling_step_id - '||l_special_ceiling_step_id,333);
1000: hr_utility.set_location('l_special_ceiling_sequence - '||l_special_ceiling_sequence,333);
1001: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1002: --

Line 999: hr_utility.set_location('l_special_ceiling_step_id - '||l_special_ceiling_step_id,333);

995: --
996: hr_utility.set_location(' ***** ANOTHER PROBLEM ***** ',333);
997: hr_utility.set_location('l_grade_max_step_id - '||l_grade_max_step_id,333);
998: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
999: hr_utility.set_location('l_special_ceiling_step_id - '||l_special_ceiling_step_id,333);
1000: hr_utility.set_location('l_special_ceiling_sequence - '||l_special_ceiling_sequence,333);
1001: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1002: --
1003: if l_future_sequence_id = -99 or l_future_sequence_id is null

Line 1000: hr_utility.set_location('l_special_ceiling_sequence - '||l_special_ceiling_sequence,333);

996: hr_utility.set_location(' ***** ANOTHER PROBLEM ***** ',333);
997: hr_utility.set_location('l_grade_max_step_id - '||l_grade_max_step_id,333);
998: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
999: hr_utility.set_location('l_special_ceiling_step_id - '||l_special_ceiling_step_id,333);
1000: hr_utility.set_location('l_special_ceiling_sequence - '||l_special_ceiling_sequence,333);
1001: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1002: --
1003: if l_future_sequence_id = -99 or l_future_sequence_id is null
1004: then

Line 1001: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);

997: hr_utility.set_location('l_grade_max_step_id - '||l_grade_max_step_id,333);
998: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
999: hr_utility.set_location('l_special_ceiling_step_id - '||l_special_ceiling_step_id,333);
1000: hr_utility.set_location('l_special_ceiling_sequence - '||l_special_ceiling_sequence,333);
1001: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1002: --
1003: if l_future_sequence_id = -99 or l_future_sequence_id is null
1004: then
1005: l_future_sequence_id := l_grade_max_sequence;

Line 1008: hr_utility.set_location('l_grade_max_step_id:'||l_grade_max_step_id,200);

1004: then
1005: l_future_sequence_id := l_grade_max_sequence;
1006: end if;
1007: --
1008: hr_utility.set_location('l_grade_max_step_id:'||l_grade_max_step_id,200);
1009: hr_utility.set_location('l_grade_max_sequence:'||l_grade_max_sequence,200);
1010: --
1011: -- ------------------------------------------------------------------
1012: -- Check if assignment already at a grade limit

Line 1009: hr_utility.set_location('l_grade_max_sequence:'||l_grade_max_sequence,200);

1005: l_future_sequence_id := l_grade_max_sequence;
1006: end if;
1007: --
1008: hr_utility.set_location('l_grade_max_step_id:'||l_grade_max_step_id,200);
1009: hr_utility.set_location('l_grade_max_sequence:'||l_grade_max_sequence,200);
1010: --
1011: -- ------------------------------------------------------------------
1012: -- Check if assignment already at a grade limit
1013: -- ------------------------------------------------------------------

Line 1014: hr_utility.set_location('Ceiling Reached?',201);

1010: --
1011: -- ------------------------------------------------------------------
1012: -- Check if assignment already at a grade limit
1013: -- ------------------------------------------------------------------
1014: hr_utility.set_location('Ceiling Reached?',201);
1015: hr_utility.set_location('Step ID '||p_step_id,201);
1016: hr_utility.set_location('l_special_ceiling_step_id '||l_special_ceiling_step_id,201);
1017: hr_utility.set_location('max_ceiling_step_id '||l_max_ceiling_step_id,201);
1018: --

Line 1015: hr_utility.set_location('Step ID '||p_step_id,201);

1011: -- ------------------------------------------------------------------
1012: -- Check if assignment already at a grade limit
1013: -- ------------------------------------------------------------------
1014: hr_utility.set_location('Ceiling Reached?',201);
1015: hr_utility.set_location('Step ID '||p_step_id,201);
1016: hr_utility.set_location('l_special_ceiling_step_id '||l_special_ceiling_step_id,201);
1017: hr_utility.set_location('max_ceiling_step_id '||l_max_ceiling_step_id,201);
1018: --
1019: if (l_special_ceiling_step_id = p_step_id

Line 1016: hr_utility.set_location('l_special_ceiling_step_id '||l_special_ceiling_step_id,201);

1012: -- Check if assignment already at a grade limit
1013: -- ------------------------------------------------------------------
1014: hr_utility.set_location('Ceiling Reached?',201);
1015: hr_utility.set_location('Step ID '||p_step_id,201);
1016: hr_utility.set_location('l_special_ceiling_step_id '||l_special_ceiling_step_id,201);
1017: hr_utility.set_location('max_ceiling_step_id '||l_max_ceiling_step_id,201);
1018: --
1019: if (l_special_ceiling_step_id = p_step_id
1020: or l_grade_max_step_id = p_step_id)

Line 1017: hr_utility.set_location('max_ceiling_step_id '||l_max_ceiling_step_id,201);

1013: -- ------------------------------------------------------------------
1014: hr_utility.set_location('Ceiling Reached?',201);
1015: hr_utility.set_location('Step ID '||p_step_id,201);
1016: hr_utility.set_location('l_special_ceiling_step_id '||l_special_ceiling_step_id,201);
1017: hr_utility.set_location('max_ceiling_step_id '||l_max_ceiling_step_id,201);
1018: --
1019: if (l_special_ceiling_step_id = p_step_id
1020: or l_grade_max_step_id = p_step_id)
1021: then

Line 1026: hr_utility.set_location('l_update '||l_update,201);

1022: l_update := 'N';
1023: l_exception_report1 := 'Y';
1024: end if;
1025: --
1026: hr_utility.set_location('l_update '||l_update,201);
1027: --
1028: -- ------------------------------------------------------------------
1029: -- Get the sequence number for the two ceiling step id's along with
1030: -- the spinal_point_id for the max ceiling

Line 1032: hr_utility.set_location('sequence number for the two ceiling',202);

1028: -- ------------------------------------------------------------------
1029: -- Get the sequence number for the two ceiling step id's along with
1030: -- the spinal_point_id for the max ceiling
1031: -- ------------------------------------------------------------------
1032: hr_utility.set_location('sequence number for the two ceiling',202);
1033: hr_utility.set_location(l_max_ceiling_step_id,203);
1034: hr_utility.set_location(l_special_ceiling_step_id,204);
1035: BEGIN
1036: select psp1.sequence,

Line 1033: hr_utility.set_location(l_max_ceiling_step_id,203);

1029: -- Get the sequence number for the two ceiling step id's along with
1030: -- the spinal_point_id for the max ceiling
1031: -- ------------------------------------------------------------------
1032: hr_utility.set_location('sequence number for the two ceiling',202);
1033: hr_utility.set_location(l_max_ceiling_step_id,203);
1034: hr_utility.set_location(l_special_ceiling_step_id,204);
1035: BEGIN
1036: select psp1.sequence,
1037: nvl(psp2.sequence,99999999),

Line 1034: hr_utility.set_location(l_special_ceiling_step_id,204);

1030: -- the spinal_point_id for the max ceiling
1031: -- ------------------------------------------------------------------
1032: hr_utility.set_location('sequence number for the two ceiling',202);
1033: hr_utility.set_location(l_max_ceiling_step_id,203);
1034: hr_utility.set_location(l_special_ceiling_step_id,204);
1035: BEGIN
1036: select psp1.sequence,
1037: nvl(psp2.sequence,99999999),
1038: psp1.spinal_point_id,

Line 1055: hr_utility.set_location('NO_DATA_FOUND',1600);

1051: and sps2.step_id = l_special_ceiling_step_id;
1052: EXCEPTION
1053: WHEN NO_DATA_FOUND
1054: THEN
1055: hr_utility.set_location('NO_DATA_FOUND',1600);
1056: hr_utility.set_location('sequence and point ids ',1600);
1057: hr_utility.set_location('not found for l_max_ceiling_step_id '
1058: ||l_max_ceiling_step_id, 1600);
1059: hr_utility.set_location('and l_special_ceiling_step_id '

Line 1056: hr_utility.set_location('sequence and point ids ',1600);

1052: EXCEPTION
1053: WHEN NO_DATA_FOUND
1054: THEN
1055: hr_utility.set_location('NO_DATA_FOUND',1600);
1056: hr_utility.set_location('sequence and point ids ',1600);
1057: hr_utility.set_location('not found for l_max_ceiling_step_id '
1058: ||l_max_ceiling_step_id, 1600);
1059: hr_utility.set_location('and l_special_ceiling_step_id '
1060: ||l_special_ceiling_step_id, 1600);

Line 1057: hr_utility.set_location('not found for l_max_ceiling_step_id '

1053: WHEN NO_DATA_FOUND
1054: THEN
1055: hr_utility.set_location('NO_DATA_FOUND',1600);
1056: hr_utility.set_location('sequence and point ids ',1600);
1057: hr_utility.set_location('not found for l_max_ceiling_step_id '
1058: ||l_max_ceiling_step_id, 1600);
1059: hr_utility.set_location('and l_special_ceiling_step_id '
1060: ||l_special_ceiling_step_id, 1600);
1061: END;

Line 1059: hr_utility.set_location('and l_special_ceiling_step_id '

1055: hr_utility.set_location('NO_DATA_FOUND',1600);
1056: hr_utility.set_location('sequence and point ids ',1600);
1057: hr_utility.set_location('not found for l_max_ceiling_step_id '
1058: ||l_max_ceiling_step_id, 1600);
1059: hr_utility.set_location('and l_special_ceiling_step_id '
1060: ||l_special_ceiling_step_id, 1600);
1061: END;
1062: --
1063: -- ------------------------------------------------------------------

Line 1068: hr_utility.set_location('******* CEILING ERROR CATCH *********',333);

1064: -- Select the max number of steps left for the grade - Also compare
1065: -- the two limits and stop if reached
1066: -- ------------------------------------------------------------------
1067: --
1068: hr_utility.set_location('******* CEILING ERROR CATCH *********',333);
1069: hr_utility.set_location('l_max_sequence_number - '||l_max_sequence_number,333);
1070: hr_utility.set_location('l_max_special_sequence_number - '||l_max_special_sequence_number,333);
1071: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
1072: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);

Line 1069: hr_utility.set_location('l_max_sequence_number - '||l_max_sequence_number,333);

1065: -- the two limits and stop if reached
1066: -- ------------------------------------------------------------------
1067: --
1068: hr_utility.set_location('******* CEILING ERROR CATCH *********',333);
1069: hr_utility.set_location('l_max_sequence_number - '||l_max_sequence_number,333);
1070: hr_utility.set_location('l_max_special_sequence_number - '||l_max_special_sequence_number,333);
1071: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
1072: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1073: hr_utility.set_location('p_sequence_number - '||p_sequence_number,333);

Line 1070: hr_utility.set_location('l_max_special_sequence_number - '||l_max_special_sequence_number,333);

1066: -- ------------------------------------------------------------------
1067: --
1068: hr_utility.set_location('******* CEILING ERROR CATCH *********',333);
1069: hr_utility.set_location('l_max_sequence_number - '||l_max_sequence_number,333);
1070: hr_utility.set_location('l_max_special_sequence_number - '||l_max_special_sequence_number,333);
1071: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
1072: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1073: hr_utility.set_location('p_sequence_number - '||p_sequence_number,333);
1074: BEGIN

Line 1071: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);

1067: --
1068: hr_utility.set_location('******* CEILING ERROR CATCH *********',333);
1069: hr_utility.set_location('l_max_sequence_number - '||l_max_sequence_number,333);
1070: hr_utility.set_location('l_max_special_sequence_number - '||l_max_special_sequence_number,333);
1071: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
1072: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1073: hr_utility.set_location('p_sequence_number - '||p_sequence_number,333);
1074: BEGIN
1075: select count(sps.sequence)

Line 1072: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);

1068: hr_utility.set_location('******* CEILING ERROR CATCH *********',333);
1069: hr_utility.set_location('l_max_sequence_number - '||l_max_sequence_number,333);
1070: hr_utility.set_location('l_max_special_sequence_number - '||l_max_special_sequence_number,333);
1071: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
1072: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1073: hr_utility.set_location('p_sequence_number - '||p_sequence_number,333);
1074: BEGIN
1075: select count(sps.sequence)
1076: into l_max_count

Line 1073: hr_utility.set_location('p_sequence_number - '||p_sequence_number,333);

1069: hr_utility.set_location('l_max_sequence_number - '||l_max_sequence_number,333);
1070: hr_utility.set_location('l_max_special_sequence_number - '||l_max_special_sequence_number,333);
1071: hr_utility.set_location('l_grade_max_sequence - '||l_grade_max_sequence,333);
1072: hr_utility.set_location('l_future_sequence_id - '||l_future_sequence_id,333);
1073: hr_utility.set_location('p_sequence_number - '||p_sequence_number,333);
1074: BEGIN
1075: select count(sps.sequence)
1076: into l_max_count
1077: from per_spinal_point_steps_f sps

Line 1090: hr_utility.set_location('NO_DATA_FOUND',1700);

1086: order by sps.sequence;
1087: EXCEPTION
1088: WHEN NO_DATA_FOUND
1089: THEN
1090: hr_utility.set_location('NO_DATA_FOUND',1700);
1091: hr_utility.set_location('max spinal point count ',1700);
1092: hr_utility.set_location('not found for p_grade_spine_id '
1093: ||p_grade_spine_id, 1700);
1094: hr_utility.set_location('and > p_sequence_number '

Line 1091: hr_utility.set_location('max spinal point count ',1700);

1087: EXCEPTION
1088: WHEN NO_DATA_FOUND
1089: THEN
1090: hr_utility.set_location('NO_DATA_FOUND',1700);
1091: hr_utility.set_location('max spinal point count ',1700);
1092: hr_utility.set_location('not found for p_grade_spine_id '
1093: ||p_grade_spine_id, 1700);
1094: hr_utility.set_location('and > p_sequence_number '
1095: ||p_sequence_number, 1700);

Line 1092: hr_utility.set_location('not found for p_grade_spine_id '

1088: WHEN NO_DATA_FOUND
1089: THEN
1090: hr_utility.set_location('NO_DATA_FOUND',1700);
1091: hr_utility.set_location('max spinal point count ',1700);
1092: hr_utility.set_location('not found for p_grade_spine_id '
1093: ||p_grade_spine_id, 1700);
1094: hr_utility.set_location('and > p_sequence_number '
1095: ||p_sequence_number, 1700);
1096: hr_utility.set_location('l_max_sequence_number '

Line 1094: hr_utility.set_location('and > p_sequence_number '

1090: hr_utility.set_location('NO_DATA_FOUND',1700);
1091: hr_utility.set_location('max spinal point count ',1700);
1092: hr_utility.set_location('not found for p_grade_spine_id '
1093: ||p_grade_spine_id, 1700);
1094: hr_utility.set_location('and > p_sequence_number '
1095: ||p_sequence_number, 1700);
1096: hr_utility.set_location('l_max_sequence_number '
1097: ||l_max_sequence_number, 1700);
1098: hr_utility.set_location('l_max_special_sequence_number '

Line 1096: hr_utility.set_location('l_max_sequence_number '

1092: hr_utility.set_location('not found for p_grade_spine_id '
1093: ||p_grade_spine_id, 1700);
1094: hr_utility.set_location('and > p_sequence_number '
1095: ||p_sequence_number, 1700);
1096: hr_utility.set_location('l_max_sequence_number '
1097: ||l_max_sequence_number, 1700);
1098: hr_utility.set_location('l_max_special_sequence_number '
1099: ||l_max_special_sequence_number, 1700);
1100: hr_utility.set_location('l_future_sequence_id '

Line 1098: hr_utility.set_location('l_max_special_sequence_number '

1094: hr_utility.set_location('and > p_sequence_number '
1095: ||p_sequence_number, 1700);
1096: hr_utility.set_location('l_max_sequence_number '
1097: ||l_max_sequence_number, 1700);
1098: hr_utility.set_location('l_max_special_sequence_number '
1099: ||l_max_special_sequence_number, 1700);
1100: hr_utility.set_location('l_future_sequence_id '
1101: ||l_future_sequence_id, 1700);
1102: hr_utility.set_location('l_grade_max_sequence '

Line 1100: hr_utility.set_location('l_future_sequence_id '

1096: hr_utility.set_location('l_max_sequence_number '
1097: ||l_max_sequence_number, 1700);
1098: hr_utility.set_location('l_max_special_sequence_number '
1099: ||l_max_special_sequence_number, 1700);
1100: hr_utility.set_location('l_future_sequence_id '
1101: ||l_future_sequence_id, 1700);
1102: hr_utility.set_location('l_grade_max_sequence '
1103: ||l_grade_max_sequence, 1700);
1104: END;

Line 1102: hr_utility.set_location('l_grade_max_sequence '

1098: hr_utility.set_location('l_max_special_sequence_number '
1099: ||l_max_special_sequence_number, 1700);
1100: hr_utility.set_location('l_future_sequence_id '
1101: ||l_future_sequence_id, 1700);
1102: hr_utility.set_location('l_grade_max_sequence '
1103: ||l_grade_max_sequence, 1700);
1104: END;
1105: hr_utility.set_location ('hrspine.spine', 1222);
1106: hr_utility.set_location ('count(sps.sequence):'||L_Max_Count,12222);

Line 1105: hr_utility.set_location ('hrspine.spine', 1222);

1101: ||l_future_sequence_id, 1700);
1102: hr_utility.set_location('l_grade_max_sequence '
1103: ||l_grade_max_sequence, 1700);
1104: END;
1105: hr_utility.set_location ('hrspine.spine', 1222);
1106: hr_utility.set_location ('count(sps.sequence):'||L_Max_Count,12222);
1107: -- ------------------------------------------------------------------
1108: -- Checks the increment by number is not greater than
1109: -- the max number of steps left for the grade

Line 1106: hr_utility.set_location ('count(sps.sequence):'||L_Max_Count,12222);

1102: hr_utility.set_location('l_grade_max_sequence '
1103: ||l_grade_max_sequence, 1700);
1104: END;
1105: hr_utility.set_location ('hrspine.spine', 1222);
1106: hr_utility.set_location ('count(sps.sequence):'||L_Max_Count,12222);
1107: -- ------------------------------------------------------------------
1108: -- Checks the increment by number is not greater than
1109: -- the max number of steps left for the grade
1110: -- ------------------------------------------------------------------

Line 1112: hr_utility.set_location('Assign Value to l_increment',140);

1108: -- Checks the increment by number is not greater than
1109: -- the max number of steps left for the grade
1110: -- ------------------------------------------------------------------
1111: --
1112: hr_utility.set_location('Assign Value to l_increment',140);
1113: --
1114: l_increment := p_increment_number;
1115: --
1116: hr_utility.set_location('Value = '||l_increment,140);

Line 1116: hr_utility.set_location('Value = '||l_increment,140);

1112: hr_utility.set_location('Assign Value to l_increment',140);
1113: --
1114: l_increment := p_increment_number;
1115: --
1116: hr_utility.set_location('Value = '||l_increment,140);
1117: hr_utility.set_location('Max Count Value = '||L_Max_Count,141);
1118: --
1119: if l_increment > L_Max_Count
1120: then

Line 1117: hr_utility.set_location('Max Count Value = '||L_Max_Count,141);

1113: --
1114: l_increment := p_increment_number;
1115: --
1116: hr_utility.set_location('Value = '||l_increment,140);
1117: hr_utility.set_location('Max Count Value = '||L_Max_Count,141);
1118: --
1119: if l_increment > L_Max_Count
1120: then
1121: l_increment := L_Max_Count;

Line 1127: hr_utility.set_location('L_Max_Count = 0 so update denied',141);

1123: end if;
1124: --
1125: if L_Max_Count = 0
1126: then
1127: hr_utility.set_location('L_Max_Count = 0 so update denied',141);
1128: l_update := 'N';
1129: end if;
1130: --
1131: p_increment := l_increment;

Line 1139: hr_utility.set_location('Exiting check_increment_available procedure',15);

1135: l_max_special_sequence_number := p_max_special_sequence_number;
1136: l_max_spinal_point_id := p_max_spinal_point_id;
1137: l_max_special_spinal_point_id := p_max_special_spinal_point_id;
1138: --
1139: hr_utility.set_location('Exiting check_increment_available procedure',15);
1140: --
1141: end check_increment_available;
1142: --
1143: /* -------------------------------------------------------------------- */

Line 1194: hr_utility.raise_error;

1190: or p_org_structure_ver_id is null
1191: then
1192: -- Raise error
1193: fnd_message.set_name('PER', 'HR_289280_SPP_INC_ORG_STRUCT');
1194: hr_utility.raise_error;
1195: end if;
1196: end if;
1197: --
1198: -- Check qualifications - Either both parameters have to be passed

Line 1207: hr_utility.raise_error;

1203: if p_qual_type is null
1204: then
1205: -- Raise error
1206: fnd_message.set_name('PER', 'HR_289290_SPP_INC_QUAL');
1207: hr_utility.raise_error;
1208: end if;
1209: end if;
1210: --
1211: --

Line 1220: hr_utility.raise_error;

1216: open csr_legal_entity;
1217: fetch csr_legal_entity into l_dummy;
1218: if csr_legal_entity%notfound then
1219: fnd_message.set_name('PER', 'HR_289291_SPP_INC_LEGAL_ENTITY');
1220: hr_utility.raise_error;
1221: end if;
1222: close csr_legal_entity;
1223: end if;
1224: --

Line 1811: -- hr_utility.set_location('HRSPINE - Business Rule = '||l_br_flag,55);

1807: ,p_year_from => p_year_from
1808: ,p_dependant_date => p_dependant_date
1809: ,p_br_flag => l_br_flag);
1810:
1811: -- hr_utility.set_location('HRSPINE - Business Rule = '||l_br_flag,55);
1812:
1813: --
1814: -- Check that all the constraints are correct
1815: --

Line 1824: hr_utility.trace ('concat string = ' || p_concat_segs);

1820: ,p_qual_type => p_qual_type
1821: ,p_business_group_id => p_business_group_id
1822: ,p_legal_entity => p_legal_entity);
1823:
1824: hr_utility.trace ('concat string = ' || p_concat_segs);
1825: --
1826: if (p_concat_segs is not null)
1827: then
1828: hr_utility.set_location ('hrspine.spine', 2);

Line 1828: hr_utility.set_location ('hrspine.spine', 2);

1824: hr_utility.trace ('concat string = ' || p_concat_segs);
1825: --
1826: if (p_concat_segs is not null)
1827: then
1828: hr_utility.set_location ('hrspine.spine', 2);
1829: --
1830: BEGIN
1831: select concatenated_segment_delimiter
1832: into l_concat_sep

Line 1840: hr_utility.set_location('NO_DATA_FOUND',1900);

1836: and id_flex_code = 'GRP';
1837: EXCEPTION
1838: WHEN NO_DATA_FOUND
1839: THEN
1840: hr_utility.set_location('NO_DATA_FOUND',1900);
1841: hr_utility.set_location('concatenated_segment_delimiter ',1900);
1842: hr_utility.set_location('not found for p_id_flex_num '
1843: ||p_id_flex_num, 1900);
1844: END;

Line 1841: hr_utility.set_location('concatenated_segment_delimiter ',1900);

1837: EXCEPTION
1838: WHEN NO_DATA_FOUND
1839: THEN
1840: hr_utility.set_location('NO_DATA_FOUND',1900);
1841: hr_utility.set_location('concatenated_segment_delimiter ',1900);
1842: hr_utility.set_location('not found for p_id_flex_num '
1843: ||p_id_flex_num, 1900);
1844: END;
1845: --

Line 1842: hr_utility.set_location('not found for p_id_flex_num '

1838: WHEN NO_DATA_FOUND
1839: THEN
1840: hr_utility.set_location('NO_DATA_FOUND',1900);
1841: hr_utility.set_location('concatenated_segment_delimiter ',1900);
1842: hr_utility.set_location('not found for p_id_flex_num '
1843: ||p_id_flex_num, 1900);
1844: END;
1845: --
1846: -- loop through for each segment, and re-arrange into the correct

Line 1860: hr_utility.trace ((c1rec.application_column_name || ' = ')

1856: l_length := l_pos_sep - l_pos;
1857: l_seg_value := substr (p_concat_segs, l_pos, l_length);
1858: end if;
1859: l_pos := l_pos + l_length + 1; -- skip on to next segment
1860: hr_utility.trace ((c1rec.application_column_name || ' = ')
1861: || l_seg_value);
1862: if (c1rec.application_column_name = 'SEGMENT1') then
1863: l_seg1 := l_seg_value;
1864: elsif (c1rec.application_column_name = 'SEGMENT2') then

Line 1923: hr_utility.trace ('ERROR : unknown application column name');

1919: l_seg29 := l_seg_value;
1920: elsif (c1rec.application_column_name = 'SEGMENT30') then
1921: l_seg30 := l_seg_value;
1922: else
1923: hr_utility.trace ('ERROR : unknown application column name');
1924: end if;
1925: end loop;
1926: hr_utility.set_location ('hrspine.spine', 4);
1927: hr_utility.set_location('Seg 1 - '||l_seg1,4);

Line 1926: hr_utility.set_location ('hrspine.spine', 4);

1922: else
1923: hr_utility.trace ('ERROR : unknown application column name');
1924: end if;
1925: end loop;
1926: hr_utility.set_location ('hrspine.spine', 4);
1927: hr_utility.set_location('Seg 1 - '||l_seg1,4);
1928: hr_utility.set_location('Seg 15 - '||l_seg15,4);
1929: end if;
1930: --

Line 1927: hr_utility.set_location('Seg 1 - '||l_seg1,4);

1923: hr_utility.trace ('ERROR : unknown application column name');
1924: end if;
1925: end loop;
1926: hr_utility.set_location ('hrspine.spine', 4);
1927: hr_utility.set_location('Seg 1 - '||l_seg1,4);
1928: hr_utility.set_location('Seg 15 - '||l_seg15,4);
1929: end if;
1930: --
1931: -- Set the count to see if any data is updated

Line 1928: hr_utility.set_location('Seg 15 - '||l_seg15,4);

1924: end if;
1925: end loop;
1926: hr_utility.set_location ('hrspine.spine', 4);
1927: hr_utility.set_location('Seg 1 - '||l_seg1,4);
1928: hr_utility.set_location('Seg 15 - '||l_seg15,4);
1929: end if;
1930: --
1931: -- Set the count to see if any data is updated
1932: --

Line 1956: hr_utility.set_location ('hrspine.spine', 51);

1952: --
1953: -- fetch standard cursor, no group partial matching
1954: --
1955: /*** vik ***/
1956: hr_utility.set_location ('hrspine.spine', 51);
1957: FETCH C_Spinal_Placements_Cursor
1958: INTO LC_Placement_ID,
1959: LC_Step_ID,
1960: LC_Assignment_ID,

Line 1973: hr_utility.set_location ('hrspine.spine', 69);

1969: l_grade_spine_id;
1970: -- vik
1971: if (C_Spinal_Placements_Cursor%notfound)
1972: then
1973: hr_utility.set_location ('hrspine.spine', 69);
1974: hr_utility.set_location ('no data found', 69);
1975: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);
1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);

Line 1974: hr_utility.set_location ('no data found', 69);

1970: -- vik
1971: if (C_Spinal_Placements_Cursor%notfound)
1972: then
1973: hr_utility.set_location ('hrspine.spine', 69);
1974: hr_utility.set_location ('no data found', 69);
1975: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);
1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);

Line 1975: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);

1971: if (C_Spinal_Placements_Cursor%notfound)
1972: then
1973: hr_utility.set_location ('hrspine.spine', 69);
1974: hr_utility.set_location ('no data found', 69);
1975: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);
1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1979: else

Line 1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);

1972: then
1973: hr_utility.set_location ('hrspine.spine', 69);
1974: hr_utility.set_location ('no data found', 69);
1975: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);
1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1979: else
1980: hr_utility.set_location ('hrspine.spine', 79);

Line 1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);

1973: hr_utility.set_location ('hrspine.spine', 69);
1974: hr_utility.set_location ('no data found', 69);
1975: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);
1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1979: else
1980: hr_utility.set_location ('hrspine.spine', 79);
1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);

Line 1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);

1974: hr_utility.set_location ('no data found', 69);
1975: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);
1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1979: else
1980: hr_utility.set_location ('hrspine.spine', 79);
1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);
1982: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);

Line 1980: hr_utility.set_location ('hrspine.spine', 79);

1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1979: else
1980: hr_utility.set_location ('hrspine.spine', 79);
1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);
1982: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);
1983: hr_utility.set_location ('and for '||TO_CHAR(LC_Placement_ID),79);
1984: hr_utility.set_location ('for'|| P_Parent_Spine_ID,79);

Line 1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);

1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1979: else
1980: hr_utility.set_location ('hrspine.spine', 79);
1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);
1982: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);
1983: hr_utility.set_location ('and for '||TO_CHAR(LC_Placement_ID),79);
1984: hr_utility.set_location ('for'|| P_Parent_Spine_ID,79);
1985: end if;

Line 1982: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);

1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1979: else
1980: hr_utility.set_location ('hrspine.spine', 79);
1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);
1982: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);
1983: hr_utility.set_location ('and for '||TO_CHAR(LC_Placement_ID),79);
1984: hr_utility.set_location ('for'|| P_Parent_Spine_ID,79);
1985: end if;
1986: --

Line 1983: hr_utility.set_location ('and for '||TO_CHAR(LC_Placement_ID),79);

1979: else
1980: hr_utility.set_location ('hrspine.spine', 79);
1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);
1982: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);
1983: hr_utility.set_location ('and for '||TO_CHAR(LC_Placement_ID),79);
1984: hr_utility.set_location ('for'|| P_Parent_Spine_ID,79);
1985: end if;
1986: --
1987: l_message_number_count := l_message_number_count + 1;

Line 1984: hr_utility.set_location ('for'|| P_Parent_Spine_ID,79);

1980: hr_utility.set_location ('hrspine.spine', 79);
1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);
1982: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);
1983: hr_utility.set_location ('and for '||TO_CHAR(LC_Placement_ID),79);
1984: hr_utility.set_location ('for'|| P_Parent_Spine_ID,79);
1985: end if;
1986: --
1987: l_message_number_count := l_message_number_count + 1;
1988: --

Line 1995: hr_utility.set_location ('hrspine.spine', 6);

1991: else
1992: --
1993: -- fetch key cursor, with group partial matching
1994: --
1995: hr_utility.set_location ('hrspine.spine', 6);
1996: FETCH C_Key_Spinal_Placements_Cursor
1997: INTO LC_Placement_ID,
1998: LC_Step_ID,
1999: LC_Assignment_ID,

Line 2080: hr_utility.set_location('Setting new Business Rule dates',1);

2076: -- ================================================================================
2077:
2078: if to_date(to_char(p_br_date_to,'YYYY'),'YYYY') > to_date(to_char(p_br_date_from,'YYYY'),'YYYY') then
2079:
2080: hr_utility.set_location('Setting new Business Rule dates',1);
2081:
2082: l_year_from_temp := substr(to_char(p_br_date_from,'DD-MM-RRRR'),6,5); -- Year to
2083: hr_utility.set_location(l_year_from_temp,1);
2084:

Line 2083: hr_utility.set_location(l_year_from_temp,1);

2079:
2080: hr_utility.set_location('Setting new Business Rule dates',1);
2081:
2082: l_year_from_temp := substr(to_char(p_br_date_from,'DD-MM-RRRR'),6,5); -- Year to
2083: hr_utility.set_location(l_year_from_temp,1);
2084:
2085: l_br_date_to_temp1 := '31-12'||l_year_from_temp;
2086: hr_utility.set_location(l_br_date_to_temp1,1);
2087:

Line 2086: hr_utility.set_location(l_br_date_to_temp1,1);

2082: l_year_from_temp := substr(to_char(p_br_date_from,'DD-MM-RRRR'),6,5); -- Year to
2083: hr_utility.set_location(l_year_from_temp,1);
2084:
2085: l_br_date_to_temp1 := '31-12'||l_year_from_temp;
2086: hr_utility.set_location(l_br_date_to_temp1,1);
2087:
2088: l_year_to_temp := substr(to_char(p_br_date_to,'DD-MM-RRRR'),6,5); -- Year from
2089: hr_utility.set_location(l_year_to_temp,2);
2090:

Line 2089: hr_utility.set_location(l_year_to_temp,2);

2085: l_br_date_to_temp1 := '31-12'||l_year_from_temp;
2086: hr_utility.set_location(l_br_date_to_temp1,1);
2087:
2088: l_year_to_temp := substr(to_char(p_br_date_to,'DD-MM-RRRR'),6,5); -- Year from
2089: hr_utility.set_location(l_year_to_temp,2);
2090:
2091: l_br_date_from_temp1 := '01-01'||l_year_to_temp;
2092: hr_utility.set_location(l_br_date_from_temp1,2);
2093:

Line 2092: hr_utility.set_location(l_br_date_from_temp1,2);

2088: l_year_to_temp := substr(to_char(p_br_date_to,'DD-MM-RRRR'),6,5); -- Year from
2089: hr_utility.set_location(l_year_to_temp,2);
2090:
2091: l_br_date_from_temp1 := '01-01'||l_year_to_temp;
2092: hr_utility.set_location(l_br_date_from_temp1,2);
2093:
2094: l_year_loop := 'Y';
2095:
2096: else

Line 2111: hr_utility.set_location('== p_br_date_from == '||p_br_date_from,3);

2107: -- for the end of the first year and then again for the start of the second year
2108:
2109: if l_year_loop = 'Y' and l_year_loop_count = 1 then
2110:
2111: hr_utility.set_location('== p_br_date_from == '||p_br_date_from,3);
2112: hr_utility.set_location('== l_br_date_to_temp1 == '||l_br_date_to_temp1,3);
2113: l_br_date_from := to_date(to_char(p_br_date_from,'DD-MM-RRRR'),'DD-MM-RRRR');
2114: l_br_date_to := to_date(l_br_date_to_temp1,'DD-MM-RRRR');
2115: l_year_temp := l_year_from_temp;

Line 2112: hr_utility.set_location('== l_br_date_to_temp1 == '||l_br_date_to_temp1,3);

2108:
2109: if l_year_loop = 'Y' and l_year_loop_count = 1 then
2110:
2111: hr_utility.set_location('== p_br_date_from == '||p_br_date_from,3);
2112: hr_utility.set_location('== l_br_date_to_temp1 == '||l_br_date_to_temp1,3);
2113: l_br_date_from := to_date(to_char(p_br_date_from,'DD-MM-RRRR'),'DD-MM-RRRR');
2114: l_br_date_to := to_date(l_br_date_to_temp1,'DD-MM-RRRR');
2115: l_year_temp := l_year_from_temp;
2116:

Line 2132: hr_utility.set_location('Business Rule Set +++++++++++',10);

2128:
2129: end if;
2130:
2131:
2132: hr_utility.set_location('Business Rule Set +++++++++++',10);
2133:
2134: open csr_assignment_business_rule;
2135:
2136: LOOP

Line 2142: hr_utility.set_location('p_business_rule - '||p_business_rule,10);

2138: -- ================================================================================
2139: -- First find all the people who have a grade step placement for the business group
2140: -- ================================================================================
2141:
2142: hr_utility.set_location('p_business_rule - '||p_business_rule,10);
2143: hr_utility.set_location('p_br_date_from - '||l_br_date_from,10);
2144: hr_utility.set_location('p_br_date_to - '||l_br_date_to,10);
2145: hr_utility.set_location('p_year_from - '||p_year_from,10);
2146: hr_utility.set_location('p_year_to - '||p_year_to,10);

Line 2143: hr_utility.set_location('p_br_date_from - '||l_br_date_from,10);

2139: -- First find all the people who have a grade step placement for the business group
2140: -- ================================================================================
2141:
2142: hr_utility.set_location('p_business_rule - '||p_business_rule,10);
2143: hr_utility.set_location('p_br_date_from - '||l_br_date_from,10);
2144: hr_utility.set_location('p_br_date_to - '||l_br_date_to,10);
2145: hr_utility.set_location('p_year_from - '||p_year_from,10);
2146: hr_utility.set_location('p_year_to - '||p_year_to,10);
2147: hr_utility.set_location('l_year_temp - '||l_year_temp,10);

Line 2144: hr_utility.set_location('p_br_date_to - '||l_br_date_to,10);

2140: -- ================================================================================
2141:
2142: hr_utility.set_location('p_business_rule - '||p_business_rule,10);
2143: hr_utility.set_location('p_br_date_from - '||l_br_date_from,10);
2144: hr_utility.set_location('p_br_date_to - '||l_br_date_to,10);
2145: hr_utility.set_location('p_year_from - '||p_year_from,10);
2146: hr_utility.set_location('p_year_to - '||p_year_to,10);
2147: hr_utility.set_location('l_year_temp - '||l_year_temp,10);
2148: hr_utility.set_location('l_earliest_start_date - '||to_char(l_earliest_start_date,'DD-MM-YYYY'),10);

Line 2145: hr_utility.set_location('p_year_from - '||p_year_from,10);

2141:
2142: hr_utility.set_location('p_business_rule - '||p_business_rule,10);
2143: hr_utility.set_location('p_br_date_from - '||l_br_date_from,10);
2144: hr_utility.set_location('p_br_date_to - '||l_br_date_to,10);
2145: hr_utility.set_location('p_year_from - '||p_year_from,10);
2146: hr_utility.set_location('p_year_to - '||p_year_to,10);
2147: hr_utility.set_location('l_year_temp - '||l_year_temp,10);
2148: hr_utility.set_location('l_earliest_start_date - '||to_char(l_earliest_start_date,'DD-MM-YYYY'),10);
2149:

Line 2146: hr_utility.set_location('p_year_to - '||p_year_to,10);

2142: hr_utility.set_location('p_business_rule - '||p_business_rule,10);
2143: hr_utility.set_location('p_br_date_from - '||l_br_date_from,10);
2144: hr_utility.set_location('p_br_date_to - '||l_br_date_to,10);
2145: hr_utility.set_location('p_year_from - '||p_year_from,10);
2146: hr_utility.set_location('p_year_to - '||p_year_to,10);
2147: hr_utility.set_location('l_year_temp - '||l_year_temp,10);
2148: hr_utility.set_location('l_earliest_start_date - '||to_char(l_earliest_start_date,'DD-MM-YYYY'),10);
2149:
2150: fetch csr_assignment_business_rule into l_br_assignment_id,

Line 2147: hr_utility.set_location('l_year_temp - '||l_year_temp,10);

2143: hr_utility.set_location('p_br_date_from - '||l_br_date_from,10);
2144: hr_utility.set_location('p_br_date_to - '||l_br_date_to,10);
2145: hr_utility.set_location('p_year_from - '||p_year_from,10);
2146: hr_utility.set_location('p_year_to - '||p_year_to,10);
2147: hr_utility.set_location('l_year_temp - '||l_year_temp,10);
2148: hr_utility.set_location('l_earliest_start_date - '||to_char(l_earliest_start_date,'DD-MM-YYYY'),10);
2149:
2150: fetch csr_assignment_business_rule into l_br_assignment_id,
2151: l_br_date_of_birth,

Line 2148: hr_utility.set_location('l_earliest_start_date - '||to_char(l_earliest_start_date,'DD-MM-YYYY'),10);

2144: hr_utility.set_location('p_br_date_to - '||l_br_date_to,10);
2145: hr_utility.set_location('p_year_from - '||p_year_from,10);
2146: hr_utility.set_location('p_year_to - '||p_year_to,10);
2147: hr_utility.set_location('l_year_temp - '||l_year_temp,10);
2148: hr_utility.set_location('l_earliest_start_date - '||to_char(l_earliest_start_date,'DD-MM-YYYY'),10);
2149:
2150: fetch csr_assignment_business_rule into l_br_assignment_id,
2151: l_br_date_of_birth,
2152: l_br_annivarsary_of_joining,

Line 2171: hr_utility.set_location('l_br_assignment_id,'||l_br_assignment_id,15);

2167: l_payroll_id := null;
2168:
2169: end if;
2170:
2171: hr_utility.set_location('l_br_assignment_id,'||l_br_assignment_id,15);
2172: hr_utility.set_location('l_br_date_of_birth,'||l_br_date_of_birth,15);
2173: hr_utility.set_location('l_br_annivarsary_of_joining,'||l_br_annivarsary_of_joining,15);
2174: hr_utility.set_location('l_br_latest_hire_date,'||l_br_latest_hire_date,15);
2175: hr_utility.set_location('l_br_adjusted_svc_date,'||l_br_adjusted_svc_date,15);

Line 2172: hr_utility.set_location('l_br_date_of_birth,'||l_br_date_of_birth,15);

2168:
2169: end if;
2170:
2171: hr_utility.set_location('l_br_assignment_id,'||l_br_assignment_id,15);
2172: hr_utility.set_location('l_br_date_of_birth,'||l_br_date_of_birth,15);
2173: hr_utility.set_location('l_br_annivarsary_of_joining,'||l_br_annivarsary_of_joining,15);
2174: hr_utility.set_location('l_br_latest_hire_date,'||l_br_latest_hire_date,15);
2175: hr_utility.set_location('l_br_adjusted_svc_date,'||l_br_adjusted_svc_date,15);
2176: hr_utility.set_location('l_copy_br_assignment_id = '||l_copy_br_assignment_id,16);

Line 2173: hr_utility.set_location('l_br_annivarsary_of_joining,'||l_br_annivarsary_of_joining,15);

2169: end if;
2170:
2171: hr_utility.set_location('l_br_assignment_id,'||l_br_assignment_id,15);
2172: hr_utility.set_location('l_br_date_of_birth,'||l_br_date_of_birth,15);
2173: hr_utility.set_location('l_br_annivarsary_of_joining,'||l_br_annivarsary_of_joining,15);
2174: hr_utility.set_location('l_br_latest_hire_date,'||l_br_latest_hire_date,15);
2175: hr_utility.set_location('l_br_adjusted_svc_date,'||l_br_adjusted_svc_date,15);
2176: hr_utility.set_location('l_copy_br_assignment_id = '||l_copy_br_assignment_id,16);
2177: hr_utility.set_location('l_br_assignment_id = '||l_br_assignment_id,16);

Line 2174: hr_utility.set_location('l_br_latest_hire_date,'||l_br_latest_hire_date,15);

2170:
2171: hr_utility.set_location('l_br_assignment_id,'||l_br_assignment_id,15);
2172: hr_utility.set_location('l_br_date_of_birth,'||l_br_date_of_birth,15);
2173: hr_utility.set_location('l_br_annivarsary_of_joining,'||l_br_annivarsary_of_joining,15);
2174: hr_utility.set_location('l_br_latest_hire_date,'||l_br_latest_hire_date,15);
2175: hr_utility.set_location('l_br_adjusted_svc_date,'||l_br_adjusted_svc_date,15);
2176: hr_utility.set_location('l_copy_br_assignment_id = '||l_copy_br_assignment_id,16);
2177: hr_utility.set_location('l_br_assignment_id = '||l_br_assignment_id,16);
2178:

Line 2175: hr_utility.set_location('l_br_adjusted_svc_date,'||l_br_adjusted_svc_date,15);

2171: hr_utility.set_location('l_br_assignment_id,'||l_br_assignment_id,15);
2172: hr_utility.set_location('l_br_date_of_birth,'||l_br_date_of_birth,15);
2173: hr_utility.set_location('l_br_annivarsary_of_joining,'||l_br_annivarsary_of_joining,15);
2174: hr_utility.set_location('l_br_latest_hire_date,'||l_br_latest_hire_date,15);
2175: hr_utility.set_location('l_br_adjusted_svc_date,'||l_br_adjusted_svc_date,15);
2176: hr_utility.set_location('l_copy_br_assignment_id = '||l_copy_br_assignment_id,16);
2177: hr_utility.set_location('l_br_assignment_id = '||l_br_assignment_id,16);
2178:
2179: l_br_update := 'N';

Line 2176: hr_utility.set_location('l_copy_br_assignment_id = '||l_copy_br_assignment_id,16);

2172: hr_utility.set_location('l_br_date_of_birth,'||l_br_date_of_birth,15);
2173: hr_utility.set_location('l_br_annivarsary_of_joining,'||l_br_annivarsary_of_joining,15);
2174: hr_utility.set_location('l_br_latest_hire_date,'||l_br_latest_hire_date,15);
2175: hr_utility.set_location('l_br_adjusted_svc_date,'||l_br_adjusted_svc_date,15);
2176: hr_utility.set_location('l_copy_br_assignment_id = '||l_copy_br_assignment_id,16);
2177: hr_utility.set_location('l_br_assignment_id = '||l_br_assignment_id,16);
2178:
2179: l_br_update := 'N';
2180:

Line 2177: hr_utility.set_location('l_br_assignment_id = '||l_br_assignment_id,16);

2173: hr_utility.set_location('l_br_annivarsary_of_joining,'||l_br_annivarsary_of_joining,15);
2174: hr_utility.set_location('l_br_latest_hire_date,'||l_br_latest_hire_date,15);
2175: hr_utility.set_location('l_br_adjusted_svc_date,'||l_br_adjusted_svc_date,15);
2176: hr_utility.set_location('l_copy_br_assignment_id = '||l_copy_br_assignment_id,16);
2177: hr_utility.set_location('l_br_assignment_id = '||l_br_assignment_id,16);
2178:
2179: l_br_update := 'N';
2180:
2181: if l_first_call_flag = FALSE then

Line 2183: hr_utility.set_location('l_first_call_flag = FALSE',20);

2179: l_br_update := 'N';
2180:
2181: if l_first_call_flag = FALSE then
2182:
2183: hr_utility.set_location('l_first_call_flag = FALSE',20);
2184:
2185: -- Check if the next record has the same assignment id
2186:
2187: if l_copy_br_assignment_id = l_br_assignment_id then

Line 2189: hr_utility.set_location('Assignments Match - Duplicates',25);

2185: -- Check if the next record has the same assignment id
2186:
2187: if l_copy_br_assignment_id = l_br_assignment_id then
2188:
2189: hr_utility.set_location('Assignments Match - Duplicates',25);
2190:
2191: l_duplicate_flag := TRUE;
2192:
2193: else

Line 2195: hr_utility.set_location('Assignments Don''t Match - No Duplicates',25);

2191: l_duplicate_flag := TRUE;
2192:
2193: else
2194:
2195: hr_utility.set_location('Assignments Don''t Match - No Duplicates',25);
2196:
2197: l_duplicate_flag := FALSE;
2198: l_br_update := 'Y';
2199:

Line 2208: hr_utility.set_location('p_business_rule - '||p_business_rule,30);

2204: -- ================================================================================
2205:
2206: if p_business_rule = 'DOB' then -- ** DATE OF BIRTH ** --
2207:
2208: hr_utility.set_location('p_business_rule - '||p_business_rule,30);
2209:
2210: if l_duplicate_flag = TRUE
2211: and l_copy_br_date_of_birth <> l_br_date_of_birth then
2212:

Line 2231: hr_utility.set_location('p_business_rule - '||p_business_rule,30);

2227: end if;
2228:
2229: elsif p_business_rule = 'AOJ' then -- ** ANNIVERSARY OF JOINING ** --
2230:
2231: hr_utility.set_location('p_business_rule - '||p_business_rule,30);
2232:
2233: if l_duplicate_flag = TRUE
2234: and l_copy_br_anniv_of_joining <> l_br_annivarsary_of_joining then
2235:

Line 2236: hr_utility.set_location('Anniversary Of Joining Changed!',1);

2232:
2233: if l_duplicate_flag = TRUE
2234: and l_copy_br_anniv_of_joining <> l_br_annivarsary_of_joining then
2235:
2236: hr_utility.set_location('Anniversary Of Joining Changed!',1);
2237: l_br_update := 'N';
2238: l_duplicate_error_flag := TRUE; -- Incase next record is same assignment
2239:
2240: end if;

Line 2246: hr_utility.set_location('p_business_rule - '||p_business_rule,30);

2242: l_effective_date := l_copy_br_anniv_of_joining;
2243:
2244: elsif p_business_rule = 'ASD' then -- ** ADJUSTED SERVICE DATE ** --
2245:
2246: hr_utility.set_location('p_business_rule - '||p_business_rule,30);
2247:
2248: if l_duplicate_flag = TRUE
2249: and l_copy_br_adjusted_svc_date <>l_br_adjusted_svc_date then
2250:

Line 2270: hr_utility.set_location('p_business_rule - '||p_business_rule,30);

2266: end if;
2267:
2268: elsif p_business_rule = 'LHD' then -- ** LATEST HIRE DATE ** --
2269:
2270: hr_utility.set_location('p_business_rule - '||p_business_rule,30);
2271:
2272: if l_duplicate_flag = TRUE
2273: and l_copy_br_latest_hire_date <> l_br_latest_hire_date then
2274:

Line 2275: hr_utility.set_location('Duplicate but Latest Hire Date Changed',1);

2271:
2272: if l_duplicate_flag = TRUE
2273: and l_copy_br_latest_hire_date <> l_br_latest_hire_date then
2274:
2275: hr_utility.set_location('Duplicate but Latest Hire Date Changed',1);
2276: l_br_update := 'N';
2277: l_duplicate_error_flag := TRUE; -- Incase next record is same assignment
2278:
2279: end if;

Line 2286: hr_utility.set_location('Invalid Business Rule',1);

2282:
2283: else
2284:
2285: -- Invalid Business Rule
2286: hr_utility.set_location('Invalid Business Rule',1);
2287:
2288: fnd_message.set_name('PER', 'HR_289507_SPP_BR_INVALID');
2289: hr_utility.raise_error;
2290:

Line 2289: hr_utility.raise_error;

2285: -- Invalid Business Rule
2286: hr_utility.set_location('Invalid Business Rule',1);
2287:
2288: fnd_message.set_name('PER', 'HR_289507_SPP_BR_INVALID');
2289: hr_utility.raise_error;
2290:
2291: end if;
2292:
2293:

Line 2304: hr_utility.set_location('Business Rule Dates Over Two Years',31);

2300: l_effective_date := l_effective_date + 1;
2301: end if;
2302: if to_date(to_char(p_br_date_to,'YYYY'),'YYYY') > to_date(to_char(p_br_date_from,'YYYY'),'YYYY') then
2303:
2304: hr_utility.set_location('Business Rule Dates Over Two Years',31);
2305:
2306: -- use l_effective_year for l_br_date_from year
2307: -- and l_effective_month for l_br_date_to year
2308: -- and l_temp_year for l_effective_date

Line 2313: hr_utility.set_location('l_temp_year '||l_temp_year,75);

2309: l_effective_year := to_char(p_br_date_from, 'YYYY');
2310: l_effective_month := to_char(p_br_date_to, 'YYYY');
2311: l_temp_year := to_char(l_effective_date,'DD/MM')||'/';
2312:
2313: hr_utility.set_location('l_temp_year '||l_temp_year,75);
2314:
2315: if to_date(l_temp_year||l_effective_year,'DD-MM-YYYY') >= p_br_date_from then
2316:
2317: hr_utility.set_location('End of year',31);

Line 2317: hr_utility.set_location('End of year',31);

2313: hr_utility.set_location('l_temp_year '||l_temp_year,75);
2314:
2315: if to_date(l_temp_year||l_effective_year,'DD-MM-YYYY') >= p_br_date_from then
2316:
2317: hr_utility.set_location('End of year',31);
2318:
2319: l_effective_year := to_char(p_br_date_from,'YYYY');
2320: l_effective_month := to_char(l_effective_date,'DD/MM')||'/';
2321: l_temp_year := l_effective_month||l_effective_year;

Line 2327: hr_utility.set_location('Start of year',31);

2323: l_effective_date := to_date(l_temp_year,'DD/MM/YYYY');
2324:
2325: elsif to_date(l_temp_year||l_effective_month,'DD-MM-YYYY') <= p_br_date_to then
2326:
2327: hr_utility.set_location('Start of year',31);
2328:
2329: l_effective_year := to_char(p_br_date_to,'YYYY');
2330: l_effective_month := to_char(l_effective_date,'DD/MM')||'/';
2331: l_temp_year := l_effective_month||l_effective_year;

Line 2339: hr_utility.set_location('Business Rule Over One Year',31);

2335: end if;
2336:
2337: elsif to_date(to_char(p_br_date_to,'YYYY'),'YYYY') = to_date(to_char(p_br_date_from,'YYYY'),'YYYY') then
2338:
2339: hr_utility.set_location('Business Rule Over One Year',31);
2340:
2341: l_effective_year := to_char(p_br_date_from,'YYYY');
2342: l_effective_month := to_char(l_effective_date,'DD/MM')||'/';
2343: l_temp_year := l_effective_month||l_effective_year;

Line 2345: hr_utility.set_location('l_temp_year '||l_temp_year,31);

2341: l_effective_year := to_char(p_br_date_from,'YYYY');
2342: l_effective_month := to_char(l_effective_date,'DD/MM')||'/';
2343: l_temp_year := l_effective_month||l_effective_year;
2344:
2345: hr_utility.set_location('l_temp_year '||l_temp_year,31);
2346:
2347: l_effective_date := to_date(l_temp_year,'DD/MM/YYYY');
2348:
2349: end if;

Line 2359: hr_utility.set_location('--------- Dependant Date Rule - '||p_dependant_date,32);

2355: -- effective date to use
2356: --
2357: -- ===============================================================================
2358:
2359: hr_utility.set_location('--------- Dependant Date Rule - '||p_dependant_date,32);
2360:
2361: if p_dependant_date = 'DD1' then -- ## Effective Date ##
2362:
2363: hr_utility.set_location('Dependant Date Rule - Effectvie Date',33);

Line 2363: hr_utility.set_location('Dependant Date Rule - Effectvie Date',33);

2359: hr_utility.set_location('--------- Dependant Date Rule - '||p_dependant_date,32);
2360:
2361: if p_dependant_date = 'DD1' then -- ## Effective Date ##
2362:
2363: hr_utility.set_location('Dependant Date Rule - Effectvie Date',33);
2364:
2365: l_effective_date := p_effective_date;
2366:
2367: elsif p_dependant_date = 'DD2' then -- ## Business Rule effective Date ##

Line 2369: hr_utility.set_location('Dependant Date Rule - Business Rule Effective Date',33);

2365: l_effective_date := p_effective_date;
2366:
2367: elsif p_dependant_date = 'DD2' then -- ## Business Rule effective Date ##
2368:
2369: hr_utility.set_location('Dependant Date Rule - Business Rule Effective Date',33);
2370:
2371: l_effective_date := l_effective_date;
2372:
2373: elsif p_dependant_date = 'DD3' then -- ## Start Of Next Month ##

Line 2375: hr_utility.set_location('Dependant Date Rule - Start Of Next Month',33);

2371: l_effective_date := l_effective_date;
2372:
2373: elsif p_dependant_date = 'DD3' then -- ## Start Of Next Month ##
2374:
2375: hr_utility.set_location('Dependant Date Rule - Start Of Next Month',33);
2376: hr_utility.set_location('l_effective_date = '||l_effective_date,33);
2377:
2378: l_effective_date := last_day(l_effective_date)+1;
2379:

Line 2376: hr_utility.set_location('l_effective_date = '||l_effective_date,33);

2372:
2373: elsif p_dependant_date = 'DD3' then -- ## Start Of Next Month ##
2374:
2375: hr_utility.set_location('Dependant Date Rule - Start Of Next Month',33);
2376: hr_utility.set_location('l_effective_date = '||l_effective_date,33);
2377:
2378: l_effective_date := last_day(l_effective_date)+1;
2379:
2380: elsif p_dependant_date = 'DD4' then -- ## Start Of next pay period ##

Line 2382: hr_utility.set_location('Pay Period Dependant Date',33);

2378: l_effective_date := last_day(l_effective_date)+1;
2379:
2380: elsif p_dependant_date = 'DD4' then -- ## Start Of next pay period ##
2381:
2382: hr_utility.set_location('Pay Period Dependant Date',33);
2383:
2384: if l_copy_payroll_id is null then
2385:
2386: hr_utility.set_location('Null Payroll Id',33);

Line 2386: hr_utility.set_location('Null Payroll Id',33);

2382: hr_utility.set_location('Pay Period Dependant Date',33);
2383:
2384: if l_copy_payroll_id is null then
2385:
2386: hr_utility.set_location('Null Payroll Id',33);
2387:
2388: l_update2 := 'N';
2389: l_exception_report2 := 'Y';
2390:

Line 2399: hr_utility.set_location('Payroll Exists - l_effective_date - '||l_effective_date,33);

2395: open csr_pay_period;
2396: fetch csr_pay_period into l_effective_date;
2397: close csr_pay_period;
2398:
2399: hr_utility.set_location('Payroll Exists - l_effective_date - '||l_effective_date,33);
2400:
2401: end if;
2402:
2403: else

Line 2408: hr_utility.raise_error;

2404:
2405: -- Invalid Dependant Date
2406:
2407: fnd_message.set_name('PER', 'HR_289508_SPP_BR_DEP_DATE');
2408: hr_utility.raise_error;
2409:
2410: end if; -- End of dependant date set
2411:
2412: hr_utility.set_location('l_br_update - '||l_br_update,40);

Line 2412: hr_utility.set_location('l_br_update - '||l_br_update,40);

2408: hr_utility.raise_error;
2409:
2410: end if; -- End of dependant date set
2411:
2412: hr_utility.set_location('l_br_update - '||l_br_update,40);
2413: hr_utility.set_location('++ New effective date - '||l_effective_date,40);
2414:
2415: if l_br_update = 'Y'
2416:

Line 2413: hr_utility.set_location('++ New effective date - '||l_effective_date,40);

2409:
2410: end if; -- End of dependant date set
2411:
2412: hr_utility.set_location('l_br_update - '||l_br_update,40);
2413: hr_utility.set_location('++ New effective date - '||l_effective_date,40);
2414:
2415: if l_br_update = 'Y'
2416:
2417: and l_duplicate_flag = FALSE

Line 2420: hr_utility.set_location('++++++++++++++ UPDATING ++++++++++++++++++',45);

2416:
2417: and l_duplicate_flag = FALSE
2418: and l_duplicate_error_flag = FALSE then
2419:
2420: hr_utility.set_location('++++++++++++++ UPDATING ++++++++++++++++++',45);
2421:
2422: -- ================================================================================
2423: -- Call the main cursor to retrieve all information required - Assignment Id used
2424: -- ================================================================================

Line 2440: hr_utility.set_location ('hrspine.spine', 52);

2436: if (p_concat_segs is null) then
2437: --
2438: -- fetch standard cursor, no group partial matching
2439: --
2440: hr_utility.set_location ('hrspine.spine', 52);
2441: FETCH C_Spinal_Placements_Cursor
2442: INTO LC_Placement_ID,
2443: LC_Step_ID,
2444: LC_Assignment_ID,

Line 2463: hr_utility.set_location ('hrspine.spine', 6);

2459: else
2460: --
2461: -- fetch key cursor, with group partial matching
2462: --
2463: hr_utility.set_location ('hrspine.spine', 6);
2464: FETCH C_Key_Spinal_Placements_Cursor
2465: INTO LC_Placement_ID,
2466: LC_Step_ID,
2467: LC_Assignment_ID,

Line 2483: hr_utility.set_location('Placement Found - '||LC_Placement_ID,45);

2479:
2480: EXIT when C_Key_Spinal_Placements_Cursor%notfound;
2481: end if;
2482: --
2483: hr_utility.set_location('Placement Found - '||LC_Placement_ID,45);
2484: hr_utility.set_location('############# Effective Date ###### '||l_effective_date,45);
2485: --
2486: -- Call the procedure to heck if assignment selected can be incremented
2487: --

Line 2484: hr_utility.set_location('############# Effective Date ###### '||l_effective_date,45);

2480: EXIT when C_Key_Spinal_Placements_Cursor%notfound;
2481: end if;
2482: --
2483: hr_utility.set_location('Placement Found - '||LC_Placement_ID,45);
2484: hr_utility.set_location('############# Effective Date ###### '||l_effective_date,45);
2485: --
2486: -- Call the procedure to heck if assignment selected can be incremented
2487: --
2488:

Line 2509: hr_utility.set_location('############# Effective Date ###### '||l_effective_date,45);

2505: ,p_max_special_sequence_number => l_max_special_sequence_number
2506: ,p_max_spinal_point_id => l_max_spinal_point_id
2507: ,p_max_special_spinal_point_id => l_max_special_spinal_point_id );
2508:
2509: hr_utility.set_location('############# Effective Date ###### '||l_effective_date,45);
2510:
2511: if l_update = 'N' or l_update2 = 'N' then
2512:
2513: l_update := 'N';

Line 2612: hr_utility.set_location ('hrspine.spine', 11);

2608:
2609: -- -----------------------------------------------------------
2610: -- set last auto inc. date on parent spine
2611: -- -----------------------------------------------------------
2612: hr_utility.set_location ('hrspine.spine', 11);
2613: UPDATE per_parent_spines
2614: SET last_automatic_increment_date = P_Effective_Date,
2615: last_update_date = sysdate,
2616: program_update_date = sysdate

Line 2624: hr_utility.set_location ('officially no data.spine', 11);

2620: --
2621: if l_message_number_count = 0 then
2622: --
2623: p_message_number := 'PER_289573_SPP_NO_DATA';
2624: hr_utility.set_location ('officially no data.spine', 11);
2625: --
2626: else
2627: --
2628: p_message_number := null;

Line 2629: hr_utility.set_location ('hrspine.spine shd be sweet', 11);

2625: --
2626: else
2627: --
2628: p_message_number := null;
2629: hr_utility.set_location ('hrspine.spine shd be sweet', 11);
2630: end if;
2631: hr_utility.set_location ('hrspine.spine', 12);
2632: --
2633: END spine;

Line 2631: hr_utility.set_location ('hrspine.spine', 12);

2627: --
2628: p_message_number := null;
2629: hr_utility.set_location ('hrspine.spine shd be sweet', 11);
2630: end if;
2631: hr_utility.set_location ('hrspine.spine', 12);
2632: --
2633: END spine;
2634: --
2635: END hrspine;