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.GHR_VALIDATE_CHECK dependencies on HR_UTILITY

Line 593: hr_utility.set_message(8301,'GHR_38288_POSITION_INVALID');

589: ghr_validate_perwsdpo.validate_perwsdpo(p_pa_request_rec.to_position_id,p_pa_request_rec.effective_date);
590: ghr_validate_perwsdpo.update_posn_status(p_pa_request_rec.to_position_id,p_pa_request_rec.effective_date);
591: exception
592: when others then
593: hr_utility.set_message(8301,'GHR_38288_POSITION_INVALID');
594: hr_utility.raise_error;
595: end;
596: End If;
597: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_pa_request_rec.to_position_id,

Line 594: hr_utility.raise_error;

590: ghr_validate_perwsdpo.update_posn_status(p_pa_request_rec.to_position_id,p_pa_request_rec.effective_date);
591: exception
592: when others then
593: hr_utility.set_message(8301,'GHR_38288_POSITION_INVALID');
594: hr_utility.raise_error;
595: end;
596: End If;
597: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_pa_request_rec.to_position_id,
598: p_pa_request_rec.effective_date);

Line 611: hr_utility.set_message(8301,'GHR_38289_PERSON_INVALID');

607: l_person_usr_type := v_get_person_types.user_person_type;
608: END LOOP;
609: -- Bug 4377361 included EMP_APL for person type condition
610: If l_person_sys_type IN ('EMP','EMP_APL') and l_person_usr_type = 'Invalid Employee' then
611: hr_utility.set_message(8301,'GHR_38289_PERSON_INVALID');
612: --hr_utility.show_error;
613: End If;
614:
615: FOR c_noa_family_code_rec in c_noa_family_code(p_pa_request_rec.effective_date) LOOP

Line 612: --hr_utility.show_error;

608: END LOOP;
609: -- Bug 4377361 included EMP_APL for person type condition
610: If l_person_sys_type IN ('EMP','EMP_APL') and l_person_usr_type = 'Invalid Employee' then
611: hr_utility.set_message(8301,'GHR_38289_PERSON_INVALID');
612: --hr_utility.show_error;
613: End If;
614:
615: FOR c_noa_family_code_rec in c_noa_family_code(p_pa_request_rec.effective_date) LOOP
616: l_noa_family_code := c_noa_family_code_rec.noa_family_code;

Line 626: hr_utility.set_message(8301, 'GHR_38553_GM_QUM_QUA');

622: IF p_pa_request_rec.first_action_la_code1 = 'QUM' AND
623: p_pa_request_rec.first_action_la_code2 = 'QUA' AND
624: p_pa_request_rec.first_noa_code = '890' AND
625: p_pa_request_rec.from_pay_plan <> 'GM' THEN
626: hr_utility.set_message(8301, 'GHR_38553_GM_QUM_QUA');
627: hr_utility.raise_error;
628: END IF;
629:
630: /* Do not allow creation of assignment if Position is Primary Assignment of another Person */

Line 627: hr_utility.raise_error;

623: p_pa_request_rec.first_action_la_code2 = 'QUA' AND
624: p_pa_request_rec.first_noa_code = '890' AND
625: p_pa_request_rec.from_pay_plan <> 'GM' THEN
626: hr_utility.set_message(8301, 'GHR_38553_GM_QUM_QUA');
627: hr_utility.raise_error;
628: END IF;
629:
630: /* Do not allow creation of assignment if Position is Primary Assignment of another Person */
631: /* Cursor includes check to exclude from Position. */

Line 654: hr_utility.set_message(8301,'GHR_38290_POSITION_ENCUMBERED');

650: l_assignment_found := TRUE;
651: END LOOP;
652:
653: IF l_assignment_found THEN
654: hr_utility.set_message(8301,'GHR_38290_POSITION_ENCUMBERED');
655: hr_utility.raise_error;
656: END IF;
657:
658: -- For other than Appt. we need to check whether any assignment is existing as on that date.

Line 655: hr_utility.raise_error;

651: END LOOP;
652:
653: IF l_assignment_found THEN
654: hr_utility.set_message(8301,'GHR_38290_POSITION_ENCUMBERED');
655: hr_utility.raise_error;
656: END IF;
657:
658: -- For other than Appt. we need to check whether any assignment is existing as on that date.
659:

Line 669: hr_utility.set_message(8301,'GHR_38290_POSITION_ENCUMBERED');

665: l_assignment_found := TRUE;
666: END LOOP;
667:
668: IF l_assignment_found THEN
669: hr_utility.set_message(8301,'GHR_38290_POSITION_ENCUMBERED');
670: hr_utility.raise_error;
671: END IF;
672: END IF;
673: END IF;

Line 670: hr_utility.raise_error;

666: END LOOP;
667:
668: IF l_assignment_found THEN
669: hr_utility.set_message(8301,'GHR_38290_POSITION_ENCUMBERED');
670: hr_utility.raise_error;
671: END IF;
672: END IF;
673: END IF;
674: --End of Bug 3751864

Line 689: hr_utility.set_message(8301, 'GHR_38291_NOT_ACCEPTED');

685: ,'ACCEPTED') loop
686: l_assignment_found := TRUE;
687: end loop;
688: if not l_assignment_found then
689: hr_utility.set_message(8301, 'GHR_38291_NOT_ACCEPTED');
690: hr_utility.raise_error;
691: end if;
692: -- Bug 4377361 included EMP_APL for person type condition
693: Elsif l_person_sys_type IN ('EMP','EMP_APL') then

Line 690: hr_utility.raise_error;

686: l_assignment_found := TRUE;
687: end loop;
688: if not l_assignment_found then
689: hr_utility.set_message(8301, 'GHR_38291_NOT_ACCEPTED');
690: hr_utility.raise_error;
691: end if;
692: -- Bug 4377361 included EMP_APL for person type condition
693: Elsif l_person_sys_type IN ('EMP','EMP_APL') then
694: -- If employees are added to APP family then may need to change this!!

Line 697: hr_utility.set_location('GHRVALID-passed family code'||p_pa_request_rec.noa_family_code,1);

693: Elsif l_person_sys_type IN ('EMP','EMP_APL') then
694: -- If employees are added to APP family then may need to change this!!
695: -- Bug# 1145963 -- Fetching noa_family_code based on current first_noa_id since
696: -- p_pa_request_rec.noa_family_code always point to family code of original first_noa_id
697: hr_utility.set_location('GHRVALID-passed family code'||p_pa_request_rec.noa_family_code,1);
698: hr_utility.set_location('GHRVALID-current family code'||l_noa_family_code,2);
699: hr_utility.set_location('GHRVALID-noa code'||p_pa_request_rec.first_noa_code,3);
700:
701: IF l_noa_family_code = 'RETURN_TO_DUTY' and l_session.noa_id_correct is null THEN

Line 698: hr_utility.set_location('GHRVALID-current family code'||l_noa_family_code,2);

694: -- If employees are added to APP family then may need to change this!!
695: -- Bug# 1145963 -- Fetching noa_family_code based on current first_noa_id since
696: -- p_pa_request_rec.noa_family_code always point to family code of original first_noa_id
697: hr_utility.set_location('GHRVALID-passed family code'||p_pa_request_rec.noa_family_code,1);
698: hr_utility.set_location('GHRVALID-current family code'||l_noa_family_code,2);
699: hr_utility.set_location('GHRVALID-noa code'||p_pa_request_rec.first_noa_code,3);
700:
701: IF l_noa_family_code = 'RETURN_TO_DUTY' and l_session.noa_id_correct is null THEN
702: for c_asg_stat_type_rec in c_asg_stat_type (p_pa_request_rec.employee_assignment_id

Line 699: hr_utility.set_location('GHRVALID-noa code'||p_pa_request_rec.first_noa_code,3);

695: -- Bug# 1145963 -- Fetching noa_family_code based on current first_noa_id since
696: -- p_pa_request_rec.noa_family_code always point to family code of original first_noa_id
697: hr_utility.set_location('GHRVALID-passed family code'||p_pa_request_rec.noa_family_code,1);
698: hr_utility.set_location('GHRVALID-current family code'||l_noa_family_code,2);
699: hr_utility.set_location('GHRVALID-noa code'||p_pa_request_rec.first_noa_code,3);
700:
701: IF l_noa_family_code = 'RETURN_TO_DUTY' and l_session.noa_id_correct is null THEN
702: for c_asg_stat_type_rec in c_asg_stat_type (p_pa_request_rec.employee_assignment_id
703: ,p_pa_request_rec.effective_date

Line 708: hr_utility.set_message(8301, 'GHR_38292_NOT_SUSP_ASSIGN');

704: ,'SUSP_ASSIGN') LOOP
705: l_assignment_found := TRUE;
706: END LOOP;
707: IF not l_assignment_found THEN
708: hr_utility.set_message(8301, 'GHR_38292_NOT_SUSP_ASSIGN');
709: hr_utility.raise_error;
710: END IF;
711: /*
712: -- Note : Commenting the following 'Else part' as a temporary fix to bug 637083

Line 709: hr_utility.raise_error;

705: l_assignment_found := TRUE;
706: END LOOP;
707: IF not l_assignment_found THEN
708: hr_utility.set_message(8301, 'GHR_38292_NOT_SUSP_ASSIGN');
709: hr_utility.raise_error;
710: END IF;
711: /*
712: -- Note : Commenting the following 'Else part' as a temporary fix to bug 637083
713: -- Should be revisiting this code when we have the NOA specific Bus. rules in place

Line 721: hr_utility.set_message(8301, 'GHR_38293_NOT_ACTIVE_ASSIGN');

717: ,'ACTIVE_ASSIGN') loop
718: l_assignment_found := TRUE;
719: end loop;
720: if not l_assignment_found then
721: hr_utility.set_message(8301, 'GHR_38293_NOT_ACTIVE_ASSIGN');
722: hr_utility.raise_error;
723: end if;
724: */
725: End If;

Line 722: hr_utility.raise_error;

718: l_assignment_found := TRUE;
719: end loop;
720: if not l_assignment_found then
721: hr_utility.set_message(8301, 'GHR_38293_NOT_ACTIVE_ASSIGN');
722: hr_utility.raise_error;
723: end if;
724: */
725: End If;
726: End If;

Line 736: hr_utility.set_message(8301,'GHR_38847_NO_SEP_WITH_FUTR');

732: l_futr_actions := v_future_actions.futr_rpa;
733: EXIT;
734: END LOOP;
735: IF (l_futr_actions IS NOT NULL) THEN
736: hr_utility.set_message(8301,'GHR_38847_NO_SEP_WITH_FUTR');
737: hr_utility.raise_error;
738: END IF;
739: END IF;
740: -- End Sundar Bug 3263109/3263096

Line 737: hr_utility.raise_error;

733: EXIT;
734: END LOOP;
735: IF (l_futr_actions IS NOT NULL) THEN
736: hr_utility.set_message(8301,'GHR_38847_NO_SEP_WITH_FUTR');
737: hr_utility.raise_error;
738: END IF;
739: END IF;
740: -- End Sundar Bug 3263109/3263096
741:

Line 748: hr_utility.set_message(8301, 'GHR_38889_SES_WGI_NO');

744: IF ( p_pa_request_rec.effective_date >= to_date('2004/01/11','YYYY/MM/DD') ) THEN
745: IF ( p_pa_request_rec.to_pay_plan in ('ES','EP','IE','FE') ) THEN
746:
747: If p_pa_request_rec.first_noa_code ='893' THEN
748: hr_utility.set_message(8301, 'GHR_38889_SES_WGI_NO');
749: hr_utility.raise_error;
750: END IF;
751:
752: l_user_tab_id := ghr_pay_calc.get_user_table_id(

Line 749: hr_utility.raise_error;

745: IF ( p_pa_request_rec.to_pay_plan in ('ES','EP','IE','FE') ) THEN
746:
747: If p_pa_request_rec.first_noa_code ='893' THEN
748: hr_utility.set_message(8301, 'GHR_38889_SES_WGI_NO');
749: hr_utility.raise_error;
750: END IF;
751:
752: l_user_tab_id := ghr_pay_calc.get_user_table_id(
753: p_position_id => p_pa_request_rec.to_position_id

Line 764: hr_utility.set_message(8301, 'GHR_38849_SES_TO_STEP_OR_RATE');

760: l_essl_table := TRUE;
761: END LOOP;
762:
763: IF ( l_essl_table and p_pa_request_rec.to_step_or_rate <>'00' ) THEN
764: hr_utility.set_message(8301, 'GHR_38849_SES_TO_STEP_OR_RATE');
765: hr_utility.raise_error;
766: END IF;
767: END IF;
768: END IF;

Line 765: hr_utility.raise_error;

761: END LOOP;
762:
763: IF ( l_essl_table and p_pa_request_rec.to_step_or_rate <>'00' ) THEN
764: hr_utility.set_message(8301, 'GHR_38849_SES_TO_STEP_OR_RATE');
765: hr_utility.raise_error;
766: END IF;
767: END IF;
768: END IF;
769: --- End fix code 3417859

Line 775: hr_utility.set_message(8301, 'GHR_38897_EE_WGI_NO');

771: IF ( p_pa_request_rec.effective_date >= to_date('2004/01/11','YYYY/MM/DD') ) THEN
772: IF ( p_pa_request_rec.to_pay_plan in ('EE') ) THEN
773:
774: IF p_pa_request_rec.first_noa_code ='893' THEN
775: hr_utility.set_message(8301, 'GHR_38897_EE_WGI_NO');
776: hr_utility.raise_error;
777: END IF;
778:
779: l_user_tab_id := ghr_pay_calc.get_user_table_id(

Line 776: hr_utility.raise_error;

772: IF ( p_pa_request_rec.to_pay_plan in ('EE') ) THEN
773:
774: IF p_pa_request_rec.first_noa_code ='893' THEN
775: hr_utility.set_message(8301, 'GHR_38897_EE_WGI_NO');
776: hr_utility.raise_error;
777: END IF;
778:
779: l_user_tab_id := ghr_pay_calc.get_user_table_id(
780: p_position_id => p_pa_request_rec.to_position_id

Line 791: hr_utility.set_message(8301, 'GHR_38895_EE_TO_STEP_OR_RATE');

787: l_essl_table := TRUE;
788: END LOOP;
789:
790: IF ( l_essl_table and p_pa_request_rec.to_step_or_rate <>'00' ) THEN
791: hr_utility.set_message(8301, 'GHR_38895_EE_TO_STEP_OR_RATE');
792: hr_utility.raise_error;
793: END IF;
794: END IF;
795: END IF;

Line 792: hr_utility.raise_error;

788: END LOOP;
789:
790: IF ( l_essl_table and p_pa_request_rec.to_step_or_rate <>'00' ) THEN
791: hr_utility.set_message(8301, 'GHR_38895_EE_TO_STEP_OR_RATE');
792: hr_utility.raise_error;
793: END IF;
794: END IF;
795: END IF;
796: --End of Bug#3604377

Line 802: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

798: /* Check whether agency code transferred to entered or not in case of 352 separation actions */
799: l_to_agency_code := p_per_sep_retire.agency_code_transfer_to;
800: If p_pa_request_rec.first_noa_code = '352' and
801: l_to_agency_code is NULL THEN
802: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
803: fnd_message.set_token('REQUIRED_LIST','Agency Code Transferred to');
804: hr_utility.raise_error;
805: End If;
806: -- Bug# 1893483

Line 804: hr_utility.raise_error;

800: If p_pa_request_rec.first_noa_code = '352' and
801: l_to_agency_code is NULL THEN
802: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
803: fnd_message.set_token('REQUIRED_LIST','Agency Code Transferred to');
804: hr_utility.raise_error;
805: End If;
806: -- Bug# 1893483
807:
808: /* check part hours if work schedule is not F,G,B */

Line 813: hr_utility.set_message(8301, 'GHR_38333_PART_TIME_HR_REQ');

809: l_work_schedule_code:=p_pa_request_rec.WORK_SCHEDULE;
810: l_part_time_hr :=p_pa_request_rec.part_time_hours;
811: If l_work_schedule_code not in ('F','G','B','I','J') and
812: l_part_time_hr is null then
813: hr_utility.set_message(8301, 'GHR_38333_PART_TIME_HR_REQ');
814: hr_utility.raise_error;
815: end if;
816:
817: -- Bug#5036370 RRR Changes

Line 814: hr_utility.raise_error;

810: l_part_time_hr :=p_pa_request_rec.part_time_hours;
811: If l_work_schedule_code not in ('F','G','B','I','J') and
812: l_part_time_hr is null then
813: hr_utility.set_message(8301, 'GHR_38333_PART_TIME_HR_REQ');
814: hr_utility.raise_error;
815: end if;
816:
817: -- Bug#5036370 RRR Changes
818: /* Check whether Service Obligation Information is entered for GHR_INCENTIVE Family or Not */

Line 820: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_start_date,10);

816:
817: -- Bug#5036370 RRR Changes
818: /* Check whether Service Obligation Information is entered for GHR_INCENTIVE Family or Not */
819: l_serv_oblig_code := p_per_service_oblig.service_oblig_type_code;
820: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_start_date,10);
821: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_end_date,10);
822: l_serv_oblig_stdt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_start_date);
823: l_serv_oblig_enddt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_end_date);
824:

Line 821: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_end_date,10);

817: -- Bug#5036370 RRR Changes
818: /* Check whether Service Obligation Information is entered for GHR_INCENTIVE Family or Not */
819: l_serv_oblig_code := p_per_service_oblig.service_oblig_type_code;
820: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_start_date,10);
821: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_end_date,10);
822: l_serv_oblig_stdt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_start_date);
823: l_serv_oblig_enddt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_end_date);
824:
825: IF (l_noa_family_code = 'GHR_INCENTIVE' OR

Line 835: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

831: LOOP
832: l_cnt := incentive_rec.cnt;
833: END LOOP;
834: IF l_cnt <= 0 THEN
835: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
836: fnd_message.set_token('REQUIRED_LIST','Incentive Category Details');
837: hr_utility.raise_error;
838: END IF;
839: IF (p_pa_request_rec.first_noa_code <> '825' OR p_pa_request_rec.second_noa_code <> '825') THEN --bug# 5983639 removed the NOT

Line 837: hr_utility.raise_error;

833: END LOOP;
834: IF l_cnt <= 0 THEN
835: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
836: fnd_message.set_token('REQUIRED_LIST','Incentive Category Details');
837: hr_utility.raise_error;
838: END IF;
839: IF (p_pa_request_rec.first_noa_code <> '825' OR p_pa_request_rec.second_noa_code <> '825') THEN --bug# 5983639 removed the NOT
840: IF NOT (p_pa_request_rec.first_noa_code = '827' AND p_pa_request_rec.pa_incentive_payment_option = 'B') THEN
841: hr_utility.set_location('first noa code '||p_pa_request_rec.first_noa_code,10);

Line 841: hr_utility.set_location('first noa code '||p_pa_request_rec.first_noa_code,10);

837: hr_utility.raise_error;
838: END IF;
839: IF (p_pa_request_rec.first_noa_code <> '825' OR p_pa_request_rec.second_noa_code <> '825') THEN --bug# 5983639 removed the NOT
840: IF NOT (p_pa_request_rec.first_noa_code = '827' AND p_pa_request_rec.pa_incentive_payment_option = 'B') THEN
841: hr_utility.set_location('first noa code '||p_pa_request_rec.first_noa_code,10);
842: IF ((l_serv_oblig_code IS NULL OR l_serv_oblig_stdt IS NULL) AND l_session.noa_id_correct IS NULL ) THEN
843: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
844: fnd_message.set_token('REQUIRED_LIST','Service Obligation Code, Service Obligation Start Date');
845: hr_utility.raise_error;

Line 843: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

839: IF (p_pa_request_rec.first_noa_code <> '825' OR p_pa_request_rec.second_noa_code <> '825') THEN --bug# 5983639 removed the NOT
840: IF NOT (p_pa_request_rec.first_noa_code = '827' AND p_pa_request_rec.pa_incentive_payment_option = 'B') THEN
841: hr_utility.set_location('first noa code '||p_pa_request_rec.first_noa_code,10);
842: IF ((l_serv_oblig_code IS NULL OR l_serv_oblig_stdt IS NULL) AND l_session.noa_id_correct IS NULL ) THEN
843: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
844: fnd_message.set_token('REQUIRED_LIST','Service Obligation Code, Service Obligation Start Date');
845: hr_utility.raise_error;
846: End If;
847: END IF;

Line 845: hr_utility.raise_error;

841: hr_utility.set_location('first noa code '||p_pa_request_rec.first_noa_code,10);
842: IF ((l_serv_oblig_code IS NULL OR l_serv_oblig_stdt IS NULL) AND l_session.noa_id_correct IS NULL ) THEN
843: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
844: fnd_message.set_token('REQUIRED_LIST','Service Obligation Code, Service Obligation Start Date');
845: hr_utility.raise_error;
846: End If;
847: END IF;
848: IF l_serv_oblig_code IS NOT NULL AND l_serv_oblig_stdt IS NOT NULL THEN
849: /* Check the Service Obligation Period.*/

Line 853: hr_utility.set_message(8301,'GHR_38999_STDT_GRTR_ENDDT');

849: /* Check the Service Obligation Period.*/
850: /*Bug # 6738306 "=" added in the below if condition and Token is set for the
851: error message*/
852: IF l_serv_oblig_stdt >= NVL(l_serv_oblig_enddt,to_date('4712/12/31','YYYY/MM/DD')) THEN
853: hr_utility.set_message(8301,'GHR_38999_STDT_GRTR_ENDDT');
854: FND_MESSAGE.SET_TOKEN('MESSAGE','Service Obligation End Date must be
855: greater than Service Obligation Start Date');
856: --Bug 14276354 Added Token 14276354
857: FND_MESSAGE.SET_TOKEN('EIT','US Fed Service Obligation Information');

Line 858: hr_utility.raise_error;

854: FND_MESSAGE.SET_TOKEN('MESSAGE','Service Obligation End Date must be
855: greater than Service Obligation Start Date');
856: --Bug 14276354 Added Token 14276354
857: FND_MESSAGE.SET_TOKEN('EIT','US Fed Service Obligation Information');
858: hr_utility.raise_error;
859: END IF;
860: IF p_pa_request_rec.first_noa_code = '815' THEN
861: l_min_months := 6;
862: l_max_months := 48;

Line 871: hr_utility.set_message(8301,'GHR_38998_INV_SERVOBL_PERIOD');

867:
868: l_min_date := ADD_MONTHS(l_serv_oblig_stdt,l_min_months);
869: l_max_date := ADD_MONTHS(l_serv_oblig_stdt,l_max_months);
870: IF NOT (NVL(l_serv_oblig_enddt,to_date('4712/12/31','YYYY/MM/DD')) BETWEEN l_min_date AND l_max_date) THEN
871: hr_utility.set_message(8301,'GHR_38998_INV_SERVOBL_PERIOD');
872: fnd_message.set_token('NOAC',p_pa_request_rec.first_noa_code);
873: fnd_message.set_token('MIN_PERIOD', to_char(l_min_months)||' Months');
874: fnd_message.set_token('MAX_PERIOD', ' 4 Years');
875: hr_utility.raise_error;

Line 875: hr_utility.raise_error;

871: hr_utility.set_message(8301,'GHR_38998_INV_SERVOBL_PERIOD');
872: fnd_message.set_token('NOAC',p_pa_request_rec.first_noa_code);
873: fnd_message.set_token('MIN_PERIOD', to_char(l_min_months)||' Months');
874: fnd_message.set_token('MAX_PERIOD', ' 4 Years');
875: hr_utility.raise_error;
876: END IF;
877: END IF;
878: END IF;
879: END IF;

Line 896: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

892: IF l_inct_ctgy_pcnt <> 0 THEN
893: -- End Bug# 5039100
894: IF l_cnt = 1 AND l_biweekly_end_date IS NULL THEN
895: IF p_per_group1.retention_inc_review_date IS NULL THEN
896: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
897: fnd_message.set_token('REQUIRED_LIST','Retention Incentive Review Date');
898: hr_utility.raise_error;
899: END IF;
900: END IF;

Line 898: hr_utility.raise_error;

894: IF l_cnt = 1 AND l_biweekly_end_date IS NULL THEN
895: IF p_per_group1.retention_inc_review_date IS NULL THEN
896: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
897: fnd_message.set_token('REQUIRED_LIST','Retention Incentive Review Date');
898: hr_utility.raise_error;
899: END IF;
900: END IF;
901: END IF;
902: END IF;

Line 913: hr_utility.set_message(8301,'GHR_38120_NO_SEP_FUTR_INCN_ELT');

909: l_futr_incentive_cnt := v_future_incentives.cnt;
910: EXIT;
911: END LOOP;
912: IF (l_futr_incentive_cnt > 0) THEN
913: hr_utility.set_message(8301,'GHR_38120_NO_SEP_FUTR_INCN_ELT');
914: hr_utility.raise_error;
915: END IF;
916: END IF;
917: /* Bug#5039691 Verify whether the NOA Code is Valid or not as on the effective date.

Line 914: hr_utility.raise_error;

910: EXIT;
911: END LOOP;
912: IF (l_futr_incentive_cnt > 0) THEN
913: hr_utility.set_message(8301,'GHR_38120_NO_SEP_FUTR_INCN_ELT');
914: hr_utility.raise_error;
915: END IF;
916: END IF;
917: /* Bug#5039691 Verify whether the NOA Code is Valid or not as on the effective date.
918: Verify this for all actions EXCEPT correction, cancellation. */

Line 930: hr_utility.set_message(8301, 'GHR_38167_INV_NAT_OF_ACT_FAM');

926: exit;
927: END LOOP;
928: -- to include logic to check if not valid as of the effective date
929: IF NOT l_exists THEN
930: hr_utility.set_message(8301, 'GHR_38167_INV_NAT_OF_ACT_FAM');
931: hr_utility.raise_error;
932: END IF;
933: END IF;
934: -- Bug#5036370 RRR Changes

Line 931: hr_utility.raise_error;

927: END LOOP;
928: -- to include logic to check if not valid as of the effective date
929: IF NOT l_exists THEN
930: hr_utility.set_message(8301, 'GHR_38167_INV_NAT_OF_ACT_FAM');
931: hr_utility.raise_error;
932: END IF;
933: END IF;
934: -- Bug#5036370 RRR Changes
935:

Line 947: hr_utility.set_message(8301, 'GHR_38334_ADJ_BASIC_PAY');

943: l_to_supervisor_diff := p_pa_request_rec.TO_SUPERVISORY_DIFFERENTIAL ;
944:
945: if l_To_Pay_Basis ='PA' and
946: nvl(l_To_adj_basic_pay,0) <> nvl(l_To_Basic_Pay,0) + nvl(l_To_Locality_Adj,0) then
947: hr_utility.set_message(8301, 'GHR_38334_ADJ_BASIC_PAY');
948: hr_utility.raise_error;
949: end if;
950: --bug 3584511
951: IF (p_pa_request_rec.noa_family_code <> 'GHR_STUDENT_LOAN' and ghr_process_sf52.g_total_pay_check = 'Y') THEN

Line 948: hr_utility.raise_error;

944:
945: if l_To_Pay_Basis ='PA' and
946: nvl(l_To_adj_basic_pay,0) <> nvl(l_To_Basic_Pay,0) + nvl(l_To_Locality_Adj,0) then
947: hr_utility.set_message(8301, 'GHR_38334_ADJ_BASIC_PAY');
948: hr_utility.raise_error;
949: end if;
950: --bug 3584511
951: IF (p_pa_request_rec.noa_family_code <> 'GHR_STUDENT_LOAN' and ghr_process_sf52.g_total_pay_check = 'Y') THEN
952: if l_To_Pay_Basis ='PA' and

Line 954: hr_utility.set_message(8301, 'GHR_38335_TOTAL_PAY');

950: --bug 3584511
951: IF (p_pa_request_rec.noa_family_code <> 'GHR_STUDENT_LOAN' and ghr_process_sf52.g_total_pay_check = 'Y') THEN
952: if l_To_Pay_Basis ='PA' and
953: nvl(l_To_total_pay,0) <> nvl(l_To_adj_basic_pay,0) + nvl(l_To_other_pay,0) then
954: hr_utility.set_message(8301, 'GHR_38335_TOTAL_PAY');
955: hr_utility.raise_error;
956: end if;
957: END IF;
958: /* check staffing diff. */

Line 955: hr_utility.raise_error;

951: IF (p_pa_request_rec.noa_family_code <> 'GHR_STUDENT_LOAN' and ghr_process_sf52.g_total_pay_check = 'Y') THEN
952: if l_To_Pay_Basis ='PA' and
953: nvl(l_To_total_pay,0) <> nvl(l_To_adj_basic_pay,0) + nvl(l_To_other_pay,0) then
954: hr_utility.set_message(8301, 'GHR_38335_TOTAL_PAY');
955: hr_utility.raise_error;
956: end if;
957: END IF;
958: /* check staffing diff. */
959: l_staffing_differential:=p_pa_request_rec.TO_STAFFING_DIFFERENTIAL;

Line 966: hr_utility.set_message(8301, 'GHR_38344_INVALID_STAFF_DIFF');

962: l_staffing_differential,
963: 'PA',
964: p_pa_request_rec.to_pay_basis)
965: > round((nvl(l_To_Basic_Pay,0) * 0.05)) then
966: hr_utility.set_message(8301, 'GHR_38344_INVALID_STAFF_DIFF');
967: hr_utility.raise_error;
968: end if;
969:
970: /* check retention allowance */

Line 967: hr_utility.raise_error;

963: 'PA',
964: p_pa_request_rec.to_pay_basis)
965: > round((nvl(l_To_Basic_Pay,0) * 0.05)) then
966: hr_utility.set_message(8301, 'GHR_38344_INVALID_STAFF_DIFF');
967: hr_utility.raise_error;
968: end if;
969:
970: /* check retention allowance */
971: l_Retention_Allowance:=p_pa_request_rec.TO_RETENTION_ALLOWANCE;

Line 976: hr_utility.set_message(8301, 'GHR_38345_INVALID_RET_ALLOW');

972: -- Code added for Student Loan
973: IF p_pa_request_rec.noa_family_code <> 'GHR_STUDENT_LOAN' then
974: if l_Retention_Allowance is not null and
975: l_Retention_Allowance > (nvl(l_To_Basic_Pay,0) * 0.25) then -- Bug 3067420 Removed 'ROUND'
976: hr_utility.set_message(8301, 'GHR_38345_INVALID_RET_ALLOW');
977: hr_utility.raise_error;
978: end if;
979: END IF;
980:

Line 977: hr_utility.raise_error;

973: IF p_pa_request_rec.noa_family_code <> 'GHR_STUDENT_LOAN' then
974: if l_Retention_Allowance is not null and
975: l_Retention_Allowance > (nvl(l_To_Basic_Pay,0) * 0.25) then -- Bug 3067420 Removed 'ROUND'
976: hr_utility.set_message(8301, 'GHR_38345_INVALID_RET_ALLOW');
977: hr_utility.raise_error;
978: end if;
979: END IF;
980:
981: -- Modified for FWS

Line 985: hr_utility.set_message(8301, 'GHR_38844_NOT_ENTITLED_OTH_PAY');

981: -- Modified for FWS
982:
983: IF p_pa_request_rec.to_pay_basis ='PH' AND
984: (p_pa_request_rec.first_noa_code IN ('818','819') or NVL(l_to_supervisor_diff,0) > 0) THEN
985: hr_utility.set_message(8301, 'GHR_38844_NOT_ENTITLED_OTH_PAY');
986: hr_utility.raise_error;
987: END IF;
988:
989: IF p_pa_request_rec.from_pay_basis ='PA' and p_pa_request_rec.to_pay_basis ='PH' THEN

Line 986: hr_utility.raise_error;

982:
983: IF p_pa_request_rec.to_pay_basis ='PH' AND
984: (p_pa_request_rec.first_noa_code IN ('818','819') or NVL(l_to_supervisor_diff,0) > 0) THEN
985: hr_utility.set_message(8301, 'GHR_38844_NOT_ENTITLED_OTH_PAY');
986: hr_utility.raise_error;
987: END IF;
988:
989: IF p_pa_request_rec.from_pay_basis ='PA' and p_pa_request_rec.to_pay_basis ='PH' THEN
990: FOR chk_for_sup_rec IN check_for_supervisory LOOP

Line 992: hr_utility.set_message(8301, 'GHR_38844_NOT_ENTITLED_OTH_PAY');

988:
989: IF p_pa_request_rec.from_pay_basis ='PA' and p_pa_request_rec.to_pay_basis ='PH' THEN
990: FOR chk_for_sup_rec IN check_for_supervisory LOOP
991: IF nvl(chk_for_sup_rec.screen_entry_value,0) > 0 THEN
992: hr_utility.set_message(8301, 'GHR_38844_NOT_ENTITLED_OTH_PAY');
993: hr_utility.raise_error;
994: END IF;
995: END LOOP;
996: END IF;

Line 993: hr_utility.raise_error;

989: IF p_pa_request_rec.from_pay_basis ='PA' and p_pa_request_rec.to_pay_basis ='PH' THEN
990: FOR chk_for_sup_rec IN check_for_supervisory LOOP
991: IF nvl(chk_for_sup_rec.screen_entry_value,0) > 0 THEN
992: hr_utility.set_message(8301, 'GHR_38844_NOT_ENTITLED_OTH_PAY');
993: hr_utility.raise_error;
994: END IF;
995: END LOOP;
996: END IF;
997:

Line 1010: hr_utility.set_message(8301, 'GHR_SUP_DIFF_AMT_TOO_BIG');

1006: l_to_supervisor_diff,
1007: 'PA',
1008: p_pa_request_rec.to_pay_basis)
1009: > (nvl(l_To_Basic_Pay,0) * 0.25) then
1010: hr_utility.set_message(8301, 'GHR_SUP_DIFF_AMT_TOO_BIG');
1011: hr_utility.raise_error;
1012: end if;
1013: */
1014:

Line 1011: hr_utility.raise_error;

1007: 'PA',
1008: p_pa_request_rec.to_pay_basis)
1009: > (nvl(l_To_Basic_Pay,0) * 0.25) then
1010: hr_utility.set_message(8301, 'GHR_SUP_DIFF_AMT_TOO_BIG');
1011: hr_utility.raise_error;
1012: end if;
1013: */
1014:
1015: /* check effective date */

Line 1020: hr_utility.set_message(8301, 'GHR_38379_INV_EFFECT_DATE');

1016: /* Bug# 923276 - Remove 90-day limitation on effective date - Hence commented out - 24th July,1999
1017: l_effective_date :=p_pa_request_rec.EFFECTIVE_DATE;
1018: l_effective_date :=p_pa_request_rec.EFFECTIVE_DATE;
1019: if (l_effective_date-sysdate) > 90 then
1020: hr_utility.set_message(8301, 'GHR_38379_INV_EFFECT_DATE');
1021: hr_utility.raise_error;
1022: end if;
1023: */
1024:

Line 1021: hr_utility.raise_error;

1017: l_effective_date :=p_pa_request_rec.EFFECTIVE_DATE;
1018: l_effective_date :=p_pa_request_rec.EFFECTIVE_DATE;
1019: if (l_effective_date-sysdate) > 90 then
1020: hr_utility.set_message(8301, 'GHR_38379_INV_EFFECT_DATE');
1021: hr_utility.raise_error;
1022: end if;
1023: */
1024:
1025:

Line 1051: hr_utility.set_message(8301,'GHR_38387_AP_EXISTS');

1047: );
1048:
1049: If l_prem_pay is not null or
1050: l_amount is not null then
1051: hr_utility.set_message(8301,'GHR_38387_AP_EXISTS');
1052: hr_utility.raise_error;
1053: End if;
1054:
1055: Elsif p_pa_request_rec.first_noa_code = '819' then -- if AP

Line 1052: hr_utility.raise_error;

1048:
1049: If l_prem_pay is not null or
1050: l_amount is not null then
1051: hr_utility.set_message(8301,'GHR_38387_AP_EXISTS');
1052: hr_utility.raise_error;
1053: End if;
1054:
1055: Elsif p_pa_request_rec.first_noa_code = '819' then -- if AP
1056: -- check if the person already gets an AUO

Line 1077: hr_utility.set_message(8301,'GHR_38388_AUO_EXISTS');

1073: );
1074:
1075: If l_prem_pay is not null or
1076: l_amount is not null then
1077: hr_utility.set_message(8301,'GHR_38388_AUO_EXISTS');
1078: hr_utility.raise_error;
1079: End if;
1080: End if;
1081:

Line 1078: hr_utility.raise_error;

1074:
1075: If l_prem_pay is not null or
1076: l_amount is not null then
1077: hr_utility.set_message(8301,'GHR_38388_AUO_EXISTS');
1078: hr_utility.raise_error;
1079: End if;
1080: End if;
1081:
1082:

Line 1109: hr_utility.set_message(8301,'GHR_38595_INVALID_AWARD_UOM');

1105: --
1106: -- Start Bug 1379280
1107: if p_pa_request_rec.first_noa_code in ('846','847','872') and
1108: p_pa_request_rec.award_uom <> 'H' then
1109: hr_utility.set_message(8301,'GHR_38595_INVALID_AWARD_UOM');
1110: hr_utility.raise_error;
1111: end if;
1112: if p_pa_request_rec.first_noa_code in ('840','841','842','843','844','845','848',
1113: '849','815','816','825','878','879') and

Line 1110: hr_utility.raise_error;

1106: -- Start Bug 1379280
1107: if p_pa_request_rec.first_noa_code in ('846','847','872') and
1108: p_pa_request_rec.award_uom <> 'H' then
1109: hr_utility.set_message(8301,'GHR_38595_INVALID_AWARD_UOM');
1110: hr_utility.raise_error;
1111: end if;
1112: if p_pa_request_rec.first_noa_code in ('840','841','842','843','844','845','848',
1113: '849','815','816','825','878','879') and
1114: p_pa_request_rec.award_uom <> 'M' then

Line 1115: hr_utility.set_message(8301,'GHR_38597_INVALID_AWARD_UOM');

1111: end if;
1112: if p_pa_request_rec.first_noa_code in ('840','841','842','843','844','845','848',
1113: '849','815','816','825','878','879') and
1114: p_pa_request_rec.award_uom <> 'M' then
1115: hr_utility.set_message(8301,'GHR_38597_INVALID_AWARD_UOM');
1116: hr_utility.raise_error;
1117: end if;
1118: -- End Bug 1379280
1119:

Line 1116: hr_utility.raise_error;

1112: if p_pa_request_rec.first_noa_code in ('840','841','842','843','844','845','848',
1113: '849','815','816','825','878','879') and
1114: p_pa_request_rec.award_uom <> 'M' then
1115: hr_utility.set_message(8301,'GHR_38597_INVALID_AWARD_UOM');
1116: hr_utility.raise_error;
1117: end if;
1118: -- End Bug 1379280
1119:
1120: --Pradeep for 3934195.

Line 1174: hr_utility.set_message(8301,'GHR_38904_AWARD_AMT_TOO_BIG5');

1170: /*l_award_salary := ghr_pay_calc.convert_amount(p_pa_request_rec.from_basic_pay
1171: ,p_pa_request_rec.from_pay_basis,'PA');*/
1172: -- end Bug# 4748927
1173: --Use the same Message Name for All.
1174: hr_utility.set_message(8301,'GHR_38904_AWARD_AMT_TOO_BIG5');
1175:
1176: --bug#5482191
1177:
1178:

Line 1183: hr_utility.set_message_token('ALLOWED','5%');

1179: IF ( p_pa_request_rec.first_noa_code='844'
1180: OR p_pa_request_rec.second_noa_code='844' ) THEN
1181:
1182: l_max_allowed_amount := 5*l_award_salary/100;
1183: hr_utility.set_message_token('ALLOWED','5%');
1184:
1185: ELSIF ( p_pa_request_rec.first_noa_code IN ('840','841')
1186: OR p_pa_request_rec.second_noa_code IN ('840','841')
1187: OR p_pa_request_rec.first_noa_code IN ('885','886') AND l_psi = '00'

Line 1191: hr_utility.set_message_token('ALLOWED','25%');

1187: OR p_pa_request_rec.first_noa_code IN ('885','886') AND l_psi = '00'
1188: OR p_pa_request_rec.second_noa_code IN ('885','886') AND l_psi = '00' ) THEN
1189:
1190: l_max_allowed_amount := 25*l_award_salary/100;
1191: hr_utility.set_message_token('ALLOWED','25%');
1192: --8528195
1193: ELSIF (p_pa_request_rec.first_noa_code='879'
1194: OR p_pa_request_rec.second_noa_code='879') THEN
1195:

Line 1197: hr_utility.set_message_token('ALLOWED','20%');

1193: ELSIF (p_pa_request_rec.first_noa_code='879'
1194: OR p_pa_request_rec.second_noa_code='879') THEN
1195:
1196: l_max_allowed_amount := 20*l_award_salary/100;
1197: hr_utility.set_message_token('ALLOWED','20%');
1198: --8528195
1199: ELSIF ( p_pa_request_rec.first_noa_code IN ('878')
1200: OR p_pa_request_rec.second_noa_code IN ('878') ) THEN
1201:

Line 1203: hr_utility.set_message_token('ALLOWED','35%');

1199: ELSIF ( p_pa_request_rec.first_noa_code IN ('878')
1200: OR p_pa_request_rec.second_noa_code IN ('878') ) THEN
1201:
1202: l_max_allowed_amount := 35*l_award_salary/100;
1203: hr_utility.set_message_token('ALLOWED','35%');
1204:
1205: --bug#5482191
1206: ELSIF (( p_pa_request_rec.first_noa_code IN ('849')
1207: OR p_pa_request_rec.second_noa_code IN ('849')) and l_psi = '00' ) THEN

Line 1210: hr_utility.set_message_token('ALLOWED','35%');

1206: ELSIF (( p_pa_request_rec.first_noa_code IN ('849')
1207: OR p_pa_request_rec.second_noa_code IN ('849')) and l_psi = '00' ) THEN
1208:
1209: l_max_allowed_amount := 35*l_award_salary/100;
1210: hr_utility.set_message_token('ALLOWED','35%');
1211:
1212:
1213:
1214: ELSIF ( p_pa_request_rec.first_noa_code IN ('825','842','843','848')

Line 1218: hr_utility.set_message(8301,'GHR_38905_AWARD_AMT_TOO_BIG6');

1214: ELSIF ( p_pa_request_rec.first_noa_code IN ('825','842','843','848')
1215: OR p_pa_request_rec.second_noa_code IN ('825','842','843','848') ) THEN
1216:
1217: l_max_allowed_amount := 25000;
1218: hr_utility.set_message(8301,'GHR_38905_AWARD_AMT_TOO_BIG6');
1219: hr_utility.set_message_token('ALLOWED','$25000');
1220:
1221: END IF;
1222:

Line 1219: hr_utility.set_message_token('ALLOWED','$25000');

1215: OR p_pa_request_rec.second_noa_code IN ('825','842','843','848') ) THEN
1216:
1217: l_max_allowed_amount := 25000;
1218: hr_utility.set_message(8301,'GHR_38905_AWARD_AMT_TOO_BIG6');
1219: hr_utility.set_message_token('ALLOWED','$25000');
1220:
1221: END IF;
1222:
1223:

Line 1234: hr_utility.set_message(8301, 'GHR_38898_AWARD_AMT_TOO_BIG3');

1230: ELSE
1231: l_max_allowed_amount := 50*l_award_salary/100;
1232: END IF;
1233: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1234: hr_utility.set_message(8301, 'GHR_38898_AWARD_AMT_TOO_BIG3');
1235: hr_utility.raise_error;
1236: END IF;
1237: --3818297 Added NVL
1238: ELSIF ( ghr_pay_calc.LEO_position( p_prd => l_temp

Line 1235: hr_utility.raise_error;

1231: l_max_allowed_amount := 50*l_award_salary/100;
1232: END IF;
1233: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1234: hr_utility.set_message(8301, 'GHR_38898_AWARD_AMT_TOO_BIG3');
1235: hr_utility.raise_error;
1236: END IF;
1237: --3818297 Added NVL
1238: ELSIF ( ghr_pay_calc.LEO_position( p_prd => l_temp
1239: ,p_position_id => NVL(p_pa_request_rec.to_position_id,p_pa_request_rec.from_position_id)

Line 1250: hr_utility.set_message(8301, 'GHR_38896_AWARD_AMT_TOO_BIG2');

1246: IF l_max_allowed_amount < 15000 THEN
1247: l_max_allowed_amount := 15000;
1248: END IF;
1249: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1250: hr_utility.set_message(8301, 'GHR_38896_AWARD_AMT_TOO_BIG2');
1251: hr_utility.raise_error;
1252: END IF;
1253: --3818297 Added NVL
1254: ELSIF (NOT ghr_pay_calc.LEO_position( p_prd => l_temp

Line 1251: hr_utility.raise_error;

1247: l_max_allowed_amount := 15000;
1248: END IF;
1249: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1250: hr_utility.set_message(8301, 'GHR_38896_AWARD_AMT_TOO_BIG2');
1251: hr_utility.raise_error;
1252: END IF;
1253: --3818297 Added NVL
1254: ELSIF (NOT ghr_pay_calc.LEO_position( p_prd => l_temp
1255: ,p_position_id => NVL(p_pa_request_rec.to_position_id,p_pa_request_rec.from_position_id)

Line 1263: hr_utility.set_message(8301, 'GHR_AWARD_AMT_TOO_BIG');

1259: ) )THEN
1260:
1261: l_max_allowed_amount := 25*l_award_salary/100;
1262: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1263: hr_utility.set_message(8301, 'GHR_AWARD_AMT_TOO_BIG');
1264: hr_utility.raise_error;
1265: END IF;
1266: END IF;
1267:

Line 1264: hr_utility.raise_error;

1260:
1261: l_max_allowed_amount := 25*l_award_salary/100;
1262: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1263: hr_utility.set_message(8301, 'GHR_AWARD_AMT_TOO_BIG');
1264: hr_utility.raise_error;
1265: END IF;
1266: END IF;
1267:
1268: ELSIF ( p_pa_request_rec.first_noa_code='815'

Line 1279: hr_utility.set_message(8301, 'GHR_38898_AWARD_AMT_TOO_BIG3');

1275: ELSE
1276: l_max_allowed_amount := 50*l_award_salary/100;
1277: END IF;
1278: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1279: hr_utility.set_message(8301, 'GHR_38898_AWARD_AMT_TOO_BIG3');
1280: hr_utility.raise_error;
1281: END IF;
1282: ELSE
1283: l_max_allowed_amount := 25*l_award_salary/100;

Line 1280: hr_utility.raise_error;

1276: l_max_allowed_amount := 50*l_award_salary/100;
1277: END IF;
1278: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1279: hr_utility.set_message(8301, 'GHR_38898_AWARD_AMT_TOO_BIG3');
1280: hr_utility.raise_error;
1281: END IF;
1282: ELSE
1283: l_max_allowed_amount := 25*l_award_salary/100;
1284: hr_utility.set_message_token('ALLOWED','25%');

Line 1284: hr_utility.set_message_token('ALLOWED','25%');

1280: hr_utility.raise_error;
1281: END IF;
1282: ELSE
1283: l_max_allowed_amount := 25*l_award_salary/100;
1284: hr_utility.set_message_token('ALLOWED','25%');
1285:
1286: END IF;
1287: END IF;
1288:

Line 1292: hr_utility.raise_error;

1288:
1289: -- Raise an Error if Award Amount is Greater than the Maximum Allowed Amount.
1290: IF p_pa_request_rec.award_amount > round(l_max_allowed_amount) THEN
1291: --Name is already set.
1292: hr_utility.raise_error;
1293: ELSE
1294:
1295: --If there is no error then clear the message stack.
1296: hr_utility.clear_message;

Line 1296: hr_utility.clear_message;

1292: hr_utility.raise_error;
1293: ELSE
1294:
1295: --If there is no error then clear the message stack.
1296: hr_utility.clear_message;
1297:
1298: END IF;
1299:
1300: --Check for Minimum Amount.

Line 1303: hr_utility.set_message(8301, 'GHR_38903_AWARD_AMT_TOO_LESS');

1299:
1300: --Check for Minimum Amount.
1301:
1302: --Use the same Message Name for All.
1303: hr_utility.set_message(8301, 'GHR_38903_AWARD_AMT_TOO_LESS');
1304:
1305: --Getting the Minimum Allowed Amount.
1306: IF ( p_pa_request_rec.first_noa_code='879'
1307: OR p_pa_request_rec.second_noa_code='879' ) THEN

Line 1310: hr_utility.set_message_token('ALLOWED','5%');

1306: IF ( p_pa_request_rec.first_noa_code='879'
1307: OR p_pa_request_rec.second_noa_code='879' ) THEN
1308:
1309: l_min_allowed_amount := 5*l_award_salary/100;
1310: hr_utility.set_message_token('ALLOWED','5%');
1311: END IF;
1312:
1313: --Raise an Error if Award Amount is Less than the Minimum Allowed Amount.
1314: IF p_pa_request_rec.award_amount < trunc(nvl(l_min_allowed_amount,0)) THEN

Line 1315: hr_utility.raise_error;

1311: END IF;
1312:
1313: --Raise an Error if Award Amount is Less than the Minimum Allowed Amount.
1314: IF p_pa_request_rec.award_amount < trunc(nvl(l_min_allowed_amount,0)) THEN
1315: hr_utility.raise_error;
1316: ELSE
1317: -- If there is no error then clear the message stack.
1318: hr_utility.clear_message;
1319: END IF;

Line 1318: hr_utility.clear_message;

1314: IF p_pa_request_rec.award_amount < trunc(nvl(l_min_allowed_amount,0)) THEN
1315: hr_utility.raise_error;
1316: ELSE
1317: -- If there is no error then clear the message stack.
1318: hr_utility.clear_message;
1319: END IF;
1320:
1321: END IF; -- End if of p_pa_request_rec.noa_family_code = 'AWARD'
1322: --Pradeep end of Bug 3934195

Line 1332: hr_utility.set_message(8301,'GHR_38621_PART_TIME_IND_NR');

1328: if p_pa_request_rec.noa_family_code in ('APP', 'CHG_HOURS', 'CHG_WORK_SCHED', 'CONV_APP'
1329: ,'REASSIGNMENT', 'RETURN_TO_DUTY') and
1330: p_pa_request_rec.work_schedule in ('B','F','G','I','J') and
1331: p_asg_non_sf52.parttime_indicator is not null then
1332: hr_utility.set_message(8301,'GHR_38621_PART_TIME_IND_NR');
1333: hr_utility.raise_error;
1334: end if;
1335: --
1336: -- START fix for 3563491 Madhuri

Line 1333: hr_utility.raise_error;

1329: ,'REASSIGNMENT', 'RETURN_TO_DUTY') and
1330: p_pa_request_rec.work_schedule in ('B','F','G','I','J') and
1331: p_asg_non_sf52.parttime_indicator is not null then
1332: hr_utility.set_message(8301,'GHR_38621_PART_TIME_IND_NR');
1333: hr_utility.raise_error;
1334: end if;
1335: --
1336: -- START fix for 3563491 Madhuri
1337: --

Line 1384: hr_utility.set_message(8301,'GHR_38920_NO_NTE_DATE');

1380: nvl(p_pa_request_rec.effective_date,trunc(sysdate)) )
1381: LOOP
1382: l_asg_status := cur_nte_check_rec.user_status;
1383: END LOOP;
1384: hr_utility.set_message(8301,'GHR_38920_NO_NTE_DATE');
1385: hr_utility.set_message_token('ASG_STATUS',l_asg_status);
1386: hr_utility.raise_error;
1387: END IF;
1388:

Line 1385: hr_utility.set_message_token('ASG_STATUS',l_asg_status);

1381: LOOP
1382: l_asg_status := cur_nte_check_rec.user_status;
1383: END LOOP;
1384: hr_utility.set_message(8301,'GHR_38920_NO_NTE_DATE');
1385: hr_utility.set_message_token('ASG_STATUS',l_asg_status);
1386: hr_utility.raise_error;
1387: END IF;
1388:
1389: END IF;

Line 1386: hr_utility.raise_error;

1382: l_asg_status := cur_nte_check_rec.user_status;
1383: END LOOP;
1384: hr_utility.set_message(8301,'GHR_38920_NO_NTE_DATE');
1385: hr_utility.set_message_token('ASG_STATUS',l_asg_status);
1386: hr_utility.raise_error;
1387: END IF;
1388:
1389: END IF;
1390: -- END of fix for 3563491

Line 1400: hr_utility.set_message(8301,'GHR_38693_NO_UPDATE_TO_POS');

1396: -- process a separate action to change the To Position.
1397: IF p_pa_request_rec.first_noa_code = '866'
1398: AND p_pa_request_rec.from_position_id <> p_pa_request_rec.to_position_id
1399: THEN
1400: hr_utility.set_message(8301,'GHR_38693_NO_UPDATE_TO_POS');
1401: hr_utility.raise_error;
1402: END IF;
1403: --
1404: -- Added the following by skutteti on 08-Nov-99 for bug #983824

Line 1401: hr_utility.raise_error;

1397: IF p_pa_request_rec.first_noa_code = '866'
1398: AND p_pa_request_rec.from_position_id <> p_pa_request_rec.to_position_id
1399: THEN
1400: hr_utility.set_message(8301,'GHR_38693_NO_UPDATE_TO_POS');
1401: hr_utility.raise_error;
1402: END IF;
1403: --
1404: -- Added the following by skutteti on 08-Nov-99 for bug #983824
1405: --

Line 1412: hr_utility.set_message(8301,'GHR_PART_TIME_IND_IS_NULL');

1408: --
1409: if p_pa_request_rec.noa_family_code in ('CHG_HOURS', 'CHG_WORK_SCHED') and
1410: p_pa_request_rec.work_schedule in ('P','Q','S','T') and
1411: p_asg_non_sf52.parttime_indicator is null then
1412: hr_utility.set_message(8301,'GHR_PART_TIME_IND_IS_NULL');
1413: hr_utility.raise_error;
1414: end if;
1415: -- Student Loan Repayment Code Changes start
1416: -- added for Student Loan Repayment Changes - 3494728 bug

Line 1413: hr_utility.raise_error;

1409: if p_pa_request_rec.noa_family_code in ('CHG_HOURS', 'CHG_WORK_SCHED') and
1410: p_pa_request_rec.work_schedule in ('P','Q','S','T') and
1411: p_asg_non_sf52.parttime_indicator is null then
1412: hr_utility.set_message(8301,'GHR_PART_TIME_IND_IS_NULL');
1413: hr_utility.raise_error;
1414: end if;
1415: -- Student Loan Repayment Code Changes start
1416: -- added for Student Loan Repayment Changes - 3494728 bug
1417: IF ( p_pa_request_rec.first_noa_code = '817' or p_pa_request_rec.second_noa_code = '817') THEN

Line 1430: hr_utility.set_location('The Appointment Type is: '||l_appt_type,12345);

1426:
1427:
1428: l_appt_type := l_per_ei_data.pei_information3;
1429:
1430: hr_utility.set_location('The Appointment Type is: '||l_appt_type,12345);
1431:
1432: IF l_appt_type in ('34','44') THEN
1433: hr_utility.set_message(8301,'GHR_38878_APPT_TYPE_SCH_C');
1434: hr_utility.raise_error;

Line 1433: hr_utility.set_message(8301,'GHR_38878_APPT_TYPE_SCH_C');

1429:
1430: hr_utility.set_location('The Appointment Type is: '||l_appt_type,12345);
1431:
1432: IF l_appt_type in ('34','44') THEN
1433: hr_utility.set_message(8301,'GHR_38878_APPT_TYPE_SCH_C');
1434: hr_utility.raise_error;
1435: END IF;
1436:
1437: FOR cur_repay_sch_rec in cur_repay_sch

Line 1434: hr_utility.raise_error;

1430: hr_utility.set_location('The Appointment Type is: '||l_appt_type,12345);
1431:
1432: IF l_appt_type in ('34','44') THEN
1433: hr_utility.set_message(8301,'GHR_38878_APPT_TYPE_SCH_C');
1434: hr_utility.raise_error;
1435: END IF;
1436:
1437: FOR cur_repay_sch_rec in cur_repay_sch
1438: LOOP

Line 1444: hr_utility.set_message(8301,'GHR_38862_AMT_EXCEEDS_LIMIT');

1440: l_review_date := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(cur_repay_sch_rec.review_date));
1441: END LOOP;
1442:
1443: IF ( p_pa_request_rec.award_amount > 10000 ) then
1444: hr_utility.set_message(8301,'GHR_38862_AMT_EXCEEDS_LIMIT');
1445: hr_utility.raise_error;
1446: END IF;
1447:
1448: IF l_repay_sch IS NULL THEN

Line 1445: hr_utility.raise_error;

1441: END LOOP;
1442:
1443: IF ( p_pa_request_rec.award_amount > 10000 ) then
1444: hr_utility.set_message(8301,'GHR_38862_AMT_EXCEEDS_LIMIT');
1445: hr_utility.raise_error;
1446: END IF;
1447:
1448: IF l_repay_sch IS NULL THEN
1449: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

Line 1449: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

1445: hr_utility.raise_error;
1446: END IF;
1447:
1448: IF l_repay_sch IS NULL THEN
1449: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1450: hr_utility.set_message_token('REQUIRED_LIST','Repayment Schedule' );
1451: hr_utility.raise_error;
1452: END IF;
1453:

Line 1450: hr_utility.set_message_token('REQUIRED_LIST','Repayment Schedule' );

1446: END IF;
1447:
1448: IF l_repay_sch IS NULL THEN
1449: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1450: hr_utility.set_message_token('REQUIRED_LIST','Repayment Schedule' );
1451: hr_utility.raise_error;
1452: END IF;
1453:
1454: IF l_review_date is not null THEN

Line 1451: hr_utility.raise_error;

1447:
1448: IF l_repay_sch IS NULL THEN
1449: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1450: hr_utility.set_message_token('REQUIRED_LIST','Repayment Schedule' );
1451: hr_utility.raise_error;
1452: END IF;
1453:
1454: IF l_review_date is not null THEN
1455: IF (l_review_date < p_pa_request_rec.effective_date) THEN

Line 1456: hr_utility.set_message(8301,'GHR_38863_REVIEW_DATE_LESS');

1452: END IF;
1453:
1454: IF l_review_date is not null THEN
1455: IF (l_review_date < p_pa_request_rec.effective_date) THEN
1456: hr_utility.set_message(8301,'GHR_38863_REVIEW_DATE_LESS');
1457: hr_utility.raise_error;
1458: END IF;
1459: END IF;
1460:

Line 1457: hr_utility.raise_error;

1453:
1454: IF l_review_date is not null THEN
1455: IF (l_review_date < p_pa_request_rec.effective_date) THEN
1456: hr_utility.set_message(8301,'GHR_38863_REVIEW_DATE_LESS');
1457: hr_utility.raise_error;
1458: END IF;
1459: END IF;
1460:
1461: IF l_repay_sch = 'L' THEN

Line 1469: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');

1465: ,p_effective_date => p_pa_request_rec.effective_date
1466: ,p_value => l_slr_recur_amount
1467: ,p_multiple_error_flag => l_multiple_error_flag);
1468: if l_slr_recur_amount is not null then
1469: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');
1470: hr_utility.raise_error;
1471: end if;
1472: else
1473: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment LumpSum'

Line 1470: hr_utility.raise_error;

1466: ,p_value => l_slr_recur_amount
1467: ,p_multiple_error_flag => l_multiple_error_flag);
1468: if l_slr_recur_amount is not null then
1469: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');
1470: hr_utility.raise_error;
1471: end if;
1472: else
1473: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment LumpSum'
1474: ,p_input_value_name => 'Amount'

Line 1489: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');

1485: l_ele_end_date := cur_ele_end_date_rec.effective_end_date;
1486: END LOOP;
1487:
1488: if (l_slr_lumpsum is not null and l_session.noa_id_correct is NOT NULL) then
1489: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');
1490: hr_utility.raise_error;
1491: elsif (p_pa_request_rec.effective_date <= l_ele_end_date) then
1492: hr_utility.set_message(8301,'GHR_38867_ERR_ELE_OVERLAPS');
1493: hr_utility.set_message_token('EFF_DATE',l_ele_end_date);

Line 1490: hr_utility.raise_error;

1486: END LOOP;
1487:
1488: if (l_slr_lumpsum is not null and l_session.noa_id_correct is NOT NULL) then
1489: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');
1490: hr_utility.raise_error;
1491: elsif (p_pa_request_rec.effective_date <= l_ele_end_date) then
1492: hr_utility.set_message(8301,'GHR_38867_ERR_ELE_OVERLAPS');
1493: hr_utility.set_message_token('EFF_DATE',l_ele_end_date);
1494: hr_utility.raise_error;

Line 1492: hr_utility.set_message(8301,'GHR_38867_ERR_ELE_OVERLAPS');

1488: if (l_slr_lumpsum is not null and l_session.noa_id_correct is NOT NULL) then
1489: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');
1490: hr_utility.raise_error;
1491: elsif (p_pa_request_rec.effective_date <= l_ele_end_date) then
1492: hr_utility.set_message(8301,'GHR_38867_ERR_ELE_OVERLAPS');
1493: hr_utility.set_message_token('EFF_DATE',l_ele_end_date);
1494: hr_utility.raise_error;
1495: end if;
1496:

Line 1493: hr_utility.set_message_token('EFF_DATE',l_ele_end_date);

1489: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');
1490: hr_utility.raise_error;
1491: elsif (p_pa_request_rec.effective_date <= l_ele_end_date) then
1492: hr_utility.set_message(8301,'GHR_38867_ERR_ELE_OVERLAPS');
1493: hr_utility.set_message_token('EFF_DATE',l_ele_end_date);
1494: hr_utility.raise_error;
1495: end if;
1496:
1497: end if;

Line 1494: hr_utility.raise_error;

1490: hr_utility.raise_error;
1491: elsif (p_pa_request_rec.effective_date <= l_ele_end_date) then
1492: hr_utility.set_message(8301,'GHR_38867_ERR_ELE_OVERLAPS');
1493: hr_utility.set_message_token('EFF_DATE',l_ele_end_date);
1494: hr_utility.raise_error;
1495: end if;
1496:
1497: end if;
1498: end if;

Line 1529: hr_utility.set_location('Ret Amount '||l_reta_amount,4);

1525: p_effective_date => p_pa_request_rec.effective_date,
1526: p_value => l_stad_amount,
1527: p_multiple_error_flag => l_multiple_error_flag
1528: );
1529: hr_utility.set_location('Ret Amount '||l_reta_amount,4);
1530: hr_utility.set_location('Supv Amount '||l_supv_amount,5);
1531: hr_utility.set_location('Stad Amount '||l_stad_amount,6);
1532: /* Pradeep commented this for 3306515.
1533:

Line 1530: hr_utility.set_location('Supv Amount '||l_supv_amount,5);

1526: p_value => l_stad_amount,
1527: p_multiple_error_flag => l_multiple_error_flag
1528: );
1529: hr_utility.set_location('Ret Amount '||l_reta_amount,4);
1530: hr_utility.set_location('Supv Amount '||l_supv_amount,5);
1531: hr_utility.set_location('Stad Amount '||l_stad_amount,6);
1532: /* Pradeep commented this for 3306515.
1533:
1534: IF (l_reta_amount is NULL and

Line 1531: hr_utility.set_location('Stad Amount '||l_stad_amount,6);

1527: p_multiple_error_flag => l_multiple_error_flag
1528: );
1529: hr_utility.set_location('Ret Amount '||l_reta_amount,4);
1530: hr_utility.set_location('Supv Amount '||l_supv_amount,5);
1531: hr_utility.set_location('Stad Amount '||l_stad_amount,6);
1532: /* Pradeep commented this for 3306515.
1533:
1534: IF (l_reta_amount is NULL and
1535: l_supv_amount is NULL and

Line 1540: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');

1536: l_stad_amount is NULL )
1537: and
1538: (p_pa_request_rec.to_other_pay_amount is null or
1539: p_pa_request_rec.to_other_pay_amount = 0 ) THEN
1540: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');
1541: hr_utility.raise_error;
1542: END IF;
1543: */
1544: END IF;

Line 1541: hr_utility.raise_error;

1537: and
1538: (p_pa_request_rec.to_other_pay_amount is null or
1539: p_pa_request_rec.to_other_pay_amount = 0 ) THEN
1540: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');
1541: hr_utility.raise_error;
1542: END IF;
1543: */
1544: END IF;
1545:

Line 1567: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,4);

1563: p_effective_date => p_pa_request_rec.effective_date,
1564: p_value => l_premium_pay_ind,
1565: p_multiple_error_flag => l_multiple_error_flag
1566: );
1567: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,4);
1568:
1569: END IF;
1570:
1571: /* IF l_premium_pay_ind IS NOT NULL and p_premium_pay.premium_pay_ind IS NOT NULL THEN

Line 1573: hr_utility.set_message(8301, 'GHR_38861_PREM_PAY_IND_ALREADY');

1569: END IF;
1570:
1571: /* IF l_premium_pay_ind IS NOT NULL and p_premium_pay.premium_pay_ind IS NOT NULL THEN
1572:
1573: hr_utility.set_message(8301, 'GHR_38861_PREM_PAY_IND_ALREADY');
1574: hr_utility.raise_error;
1575:
1576: END IF;
1577:

Line 1574: hr_utility.raise_error;

1570:
1571: /* IF l_premium_pay_ind IS NOT NULL and p_premium_pay.premium_pay_ind IS NOT NULL THEN
1572:
1573: hr_utility.set_message(8301, 'GHR_38861_PREM_PAY_IND_ALREADY');
1574: hr_utility.raise_error;
1575:
1576: END IF;
1577:
1578: IF p_premium_pay.premium_pay_ind IS NOT NULL THEN

Line 1580: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,5);

1576: END IF;
1577:
1578: IF p_premium_pay.premium_pay_ind IS NOT NULL THEN
1579: l_premium_pay_ind := p_premium_pay.premium_pay_ind;
1580: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,5);
1581: END IF; --Premium Pay Ind is not coming from p_premium_pay.premium_pay_ind.
1582: */
1583: IF ( l_premium_pay_ind IS NULL ) THEN
1584: l_null_list := 'Premium Pay Indicator';

Line 1585: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

1581: END IF; --Premium Pay Ind is not coming from p_premium_pay.premium_pay_ind.
1582: */
1583: IF ( l_premium_pay_ind IS NULL ) THEN
1584: l_null_list := 'Premium Pay Indicator';
1585: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1586: fnd_message.set_token('REQUIRED_LIST',l_null_list);
1587: hr_utility.raise_error;
1588: END IF;
1589:

Line 1587: hr_utility.raise_error;

1583: IF ( l_premium_pay_ind IS NULL ) THEN
1584: l_null_list := 'Premium Pay Indicator';
1585: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1586: fnd_message.set_token('REQUIRED_LIST',l_null_list);
1587: hr_utility.raise_error;
1588: END IF;
1589:
1590: --Pradeep. Bug# 3562063 New Business Rules for Title 38
1591: IF l_premium_pay_ind NOT IN ( 'K','X' ) THEN

Line 1592: hr_utility.set_message(8301,'GHR_38871_850_PREM_PAY');

1588: END IF;
1589:
1590: --Pradeep. Bug# 3562063 New Business Rules for Title 38
1591: IF l_premium_pay_ind NOT IN ( 'K','X' ) THEN
1592: hr_utility.set_message(8301,'GHR_38871_850_PREM_PAY');
1593: hr_utility.raise_error;
1594: END IF;
1595:
1596:

Line 1593: hr_utility.raise_error;

1589:
1590: --Pradeep. Bug# 3562063 New Business Rules for Title 38
1591: IF l_premium_pay_ind NOT IN ( 'K','X' ) THEN
1592: hr_utility.set_message(8301,'GHR_38871_850_PREM_PAY');
1593: hr_utility.raise_error;
1594: END IF;
1595:
1596:
1597: l_occ_code := p_pa_request_rec.from_occ_code;

Line 1603: hr_utility.set_message(8301,'GHR_38875_850_OCC_SERIES1');

1599: --If Nature of Action is 850 and Occupation Series is 0610, then Premium Pay Indicator can only be K.
1600: If ( l_occ_code = '0610' )
1601: AND ( l_premium_pay_ind <> 'K' ) THEN
1602:
1603: hr_utility.set_message(8301,'GHR_38875_850_OCC_SERIES1');
1604: hr_utility.raise_error;
1605:
1606: End If;
1607:

Line 1604: hr_utility.raise_error;

1600: If ( l_occ_code = '0610' )
1601: AND ( l_premium_pay_ind <> 'K' ) THEN
1602:
1603: hr_utility.set_message(8301,'GHR_38875_850_OCC_SERIES1');
1604: hr_utility.raise_error;
1605:
1606: End If;
1607:
1608: --If Nature of Action is 850 and Occupation Series is 0660, then Premium Pay Indicator can not be K.

Line 1612: hr_utility.set_message(8301,'GHR_38876_850_OCC_SERIES2');

1608: --If Nature of Action is 850 and Occupation Series is 0660, then Premium Pay Indicator can not be K.
1609: If ( l_occ_code = '0660' )
1610: AND ( l_premium_pay_ind = 'K' ) THEN
1611:
1612: hr_utility.set_message(8301,'GHR_38876_850_OCC_SERIES2');
1613: hr_utility.raise_error;
1614:
1615: End If;
1616: ----Bug# 3562063

Line 1613: hr_utility.raise_error;

1609: If ( l_occ_code = '0660' )
1610: AND ( l_premium_pay_ind = 'K' ) THEN
1611:
1612: hr_utility.set_message(8301,'GHR_38876_850_OCC_SERIES2');
1613: hr_utility.raise_error;
1614:
1615: End If;
1616: ----Bug# 3562063
1617:

Line 1620: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');

1616: ----Bug# 3562063
1617:
1618: If l_premium_pay_ind='K' and l_occ_code NOT IN ('0602','0603','0610','0680','0681','0682','0683') THEN
1619:
1620: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');
1621: hr_utility.raise_error;
1622:
1623: End If;
1624:

Line 1621: hr_utility.raise_error;

1617:
1618: If l_premium_pay_ind='K' and l_occ_code NOT IN ('0602','0603','0610','0680','0681','0682','0683') THEN
1619:
1620: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');
1621: hr_utility.raise_error;
1622:
1623: End If;
1624:
1625: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN

Line 1627: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');

1623: End If;
1624:
1625: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN
1626:
1627: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');
1628: hr_utility.raise_error;
1629:
1630: End If;
1631:

Line 1628: hr_utility.raise_error;

1624:
1625: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN
1626:
1627: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');
1628: hr_utility.raise_error;
1629:
1630: End If;
1631:
1632: ghr_api.retrieve_element_entry_value

Line 1640: hr_utility.set_location('AP Amount '||l_ap_amount,7);

1636: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,
1637: P_VALUE => l_ap_amount,
1638: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
1639: );
1640: hr_utility.set_location('AP Amount '||l_ap_amount,7);
1641:
1642: ghr_api.retrieve_element_entry_value
1643: (P_ELEMENT_NAME => 'AUO',
1644: P_INPUT_VALUE_NAME => 'Amount',

Line 1650: hr_utility.set_location('AUO Amount '||l_auo_amount,7);

1646: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,
1647: P_VALUE => l_auo_amount,
1648: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
1649: );
1650: hr_utility.set_location('AUO Amount '||l_auo_amount,7);
1651: -- Start of bug 4016362
1652: /********* Added Cursor BG_rec to get business group id
1653: to be passed to get_element_details procedure *************/
1654:

Line 1690: hr_utility.set_message(8301,'GHR_38858_PREM_PAY_OTH_PAY');

1686: IF ( l_auo_amount is NOT NULL )
1687: or ( l_ap_amount IS NOT NULL )
1688: or ( l_edp_eff_start_date IS NOT NULL )
1689: or ( l_hz_eff_start_date IS NOT NULL ) THEN
1690: hr_utility.set_message(8301,'GHR_38858_PREM_PAY_OTH_PAY');
1691: hr_utility.raise_error;
1692: END IF;
1693:
1694: --Check whether the elements AUO, AP, Hazard and EDP pay are existing in Future.

Line 1691: hr_utility.raise_error;

1687: or ( l_ap_amount IS NOT NULL )
1688: or ( l_edp_eff_start_date IS NOT NULL )
1689: or ( l_hz_eff_start_date IS NOT NULL ) THEN
1690: hr_utility.set_message(8301,'GHR_38858_PREM_PAY_OTH_PAY');
1691: hr_utility.raise_error;
1692: END IF;
1693:
1694: --Check whether the elements AUO, AP, Hazard and EDP pay are existing in Future.
1695:

Line 1703: hr_utility.set_location('AUO Amount '||l_auo_amount,8);

1699: ,p_effective_date => p_pa_request_rec.effective_date
1700: ,p_value => l_auo_amount
1701: ,p_effective_start_date => l_eff_start_date);
1702:
1703: hr_utility.set_location('AUO Amount '||l_auo_amount,8);
1704: get_element_details_future(p_element_name => 'Availability Pay'
1705: ,p_input_value_name => 'Amount'
1706: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1707: ,p_effective_date => p_pa_request_rec.effective_date

Line 1711: hr_utility.set_location('AP Amount '||l_ap_amount,8);

1707: ,p_effective_date => p_pa_request_rec.effective_date
1708: ,p_value => l_ap_amount
1709: ,p_effective_start_date => l_eff_start_date);
1710:
1711: hr_utility.set_location('AP Amount '||l_ap_amount,8);
1712: get_element_details_future(p_element_name => 'Hazard Pay'
1713: ,p_input_value_name => 'Premium Pay Ind'
1714: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1715: ,p_effective_date => p_pa_request_rec.effective_date

Line 1719: hr_utility.set_location('Hz Amount '||l_hz_ind,8);

1715: ,p_effective_date => p_pa_request_rec.effective_date
1716: ,p_value => l_hz_ind
1717: ,p_effective_start_date => l_hz_eff_start_date);
1718:
1719: hr_utility.set_location('Hz Amount '||l_hz_ind,8);
1720: get_element_details_future(p_element_name => 'EDP Pay'
1721: ,p_input_value_name => 'Premium Pay Ind'
1722: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1723: ,p_effective_date => p_pa_request_rec.effective_date

Line 1726: hr_utility.set_location('EDP Pay amount'||l_edp_ind,8);

1722: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1723: ,p_effective_date => p_pa_request_rec.effective_date
1724: ,p_value => l_edp_ind
1725: ,p_effective_start_date => l_edp_eff_start_date);
1726: hr_utility.set_location('EDP Pay amount'||l_edp_ind,8);
1727:
1728: IF ( l_auo_amount is NOT NULL )
1729: or ( l_ap_amount IS NOT NULL )
1730: or ( l_hz_eff_start_date IS NOT NULL )

Line 1732: hr_utility.set_message(8301,'GHR_38865_PREM_PAY_OTH_PAY_FUT');

1728: IF ( l_auo_amount is NOT NULL )
1729: or ( l_ap_amount IS NOT NULL )
1730: or ( l_hz_eff_start_date IS NOT NULL )
1731: or ( l_edp_eff_start_date IS NOT NULL ) THEN
1732: hr_utility.set_message(8301,'GHR_38865_PREM_PAY_OTH_PAY_FUT');
1733: hr_utility.raise_error;
1734: END IF;
1735:
1736:

Line 1733: hr_utility.raise_error;

1729: or ( l_ap_amount IS NOT NULL )
1730: or ( l_hz_eff_start_date IS NOT NULL )
1731: or ( l_edp_eff_start_date IS NOT NULL ) THEN
1732: hr_utility.set_message(8301,'GHR_38865_PREM_PAY_OTH_PAY_FUT');
1733: hr_utility.raise_error;
1734: END IF;
1735:
1736:
1737: --To check whether nre date and at least one special pay amount is entered or not

Line 1751: hr_utility.set_location('Amount l_mddds_pay_amount_old '|| l_mddds_pay_amount_old,5);

1747: p_effective_date => p_pa_request_rec.effective_date,
1748: p_value => l_mddds_pay_amount_old,
1749: p_multiple_error_flag => l_multiple_error_flag
1750: );
1751: hr_utility.set_location('Amount l_mddds_pay_amount_old '|| l_mddds_pay_amount_old,5);
1752: IF l_mddds_pay_amount_old IS NULL THEN
1753: l_null_list := 'MD/DDS Special Pay Amount';
1754: END IF;
1755:

Line 1768: hr_utility.set_location('MDDDS Special Pay NTE Date old '|| l_mddds_pay_nte_date_old,6);

1764: p_effective_date => p_pa_request_rec.effective_date,
1765: p_value => l_mddds_pay_nte_date_old,
1766: p_multiple_error_flag => l_multiple_error_flag
1767: );
1768: hr_utility.set_location('MDDDS Special Pay NTE Date old '|| l_mddds_pay_nte_date_old,6);
1769:
1770: IF l_mddds_pay_nte_date_old IS NULL THEN
1771: l_null_list := l_null_list||l_new_line||'MD/DDS Special Pay NTE Date';
1772: END IF;

Line 1778: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

1774: END IF;
1775:
1776: IF l_null_list IS NOT NULL THEN
1777:
1778: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1779: fnd_message.set_token('REQUIRED_LIST',l_null_list);
1780: hr_utility.raise_error;
1781:
1782: End If;

Line 1780: hr_utility.raise_error;

1776: IF l_null_list IS NOT NULL THEN
1777:
1778: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1779: fnd_message.set_token('REQUIRED_LIST',l_null_list);
1780: hr_utility.raise_error;
1781:
1782: End If;
1783:
1784: IF l_mddds_specia_pay_nte_date IS NOT NULL

Line 1787: hr_utility.set_message(8301,'GHR_38853_NTE_DATE_EFF_DATE');

1783:
1784: IF l_mddds_specia_pay_nte_date IS NOT NULL
1785: and l_mddds_specia_pay_nte_date
1786: < p_pa_request_rec.effective_date THEN
1787: hr_utility.set_message(8301,'GHR_38853_NTE_DATE_EFF_DATE');
1788: fnd_message.set_token('PROC','MD/DDS Special Pay ');--bug# 14728585
1789: hr_utility.raise_error;
1790: END IF;
1791:

Line 1789: hr_utility.raise_error;

1785: and l_mddds_specia_pay_nte_date
1786: < p_pa_request_rec.effective_date THEN
1787: hr_utility.set_message(8301,'GHR_38853_NTE_DATE_EFF_DATE');
1788: fnd_message.set_token('PROC','MD/DDS Special Pay ');--bug# 14728585
1789: hr_utility.raise_error;
1790: END IF;
1791:
1792: END IF; -- End of If .. 850.
1793: --Begin Bug# 8653508

Line 1796: hr_utility.set_location(' Detail Action Validations ',101);

1792: END IF; -- End of If .. 850.
1793: --Begin Bug# 8653508
1794:
1795: IF (p_pa_request_rec.noa_family_code = 'GHR_DETAIL') THEN
1796: hr_utility.set_location(' Detail Action Validations ',101);
1797: FOR cur_detail_info_rec IN cur_detail_info LOOP
1798: l_detail_type := cur_detail_info_rec.rei_information3;
1799: l_unclassified_duty_ind := cur_detail_info_rec.rei_information4;
1800: l_detail_position_id := cur_detail_info_rec.rei_information5; --Bug# 11781477

Line 1810: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

1806: END IF;
1807: IF l_unclassified_duty_ind IS NULL THEN
1808: l_null_list := l_null_list||l_new_line||'Unclassified Duties Indicator';--Bug# 9578885
1809: END IF;
1810: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1811: fnd_message.set_token('REQUIRED_LIST',l_null_list);
1812: hr_utility.raise_error;
1813: END IF;
1814: --Begin Bug# 11781477

Line 1812: hr_utility.raise_error;

1808: l_null_list := l_null_list||l_new_line||'Unclassified Duties Indicator';--Bug# 9578885
1809: END IF;
1810: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
1811: fnd_message.set_token('REQUIRED_LIST',l_null_list);
1812: hr_utility.raise_error;
1813: END IF;
1814: --Begin Bug# 11781477
1815: FOR p_get_pos_avl_status IN c_get_pos_avl_status(l_detail_position_id,p_pa_request_rec.effective_date) LOOP
1816: IF p_get_pos_avl_status.status <> 'Active' THEN

Line 1817: hr_utility.set_message(8301,'GHR_38193_DETAIL_POSAVL_CHK');

1813: END IF;
1814: --Begin Bug# 11781477
1815: FOR p_get_pos_avl_status IN c_get_pos_avl_status(l_detail_position_id,p_pa_request_rec.effective_date) LOOP
1816: IF p_get_pos_avl_status.status <> 'Active' THEN
1817: hr_utility.set_message(8301,'GHR_38193_DETAIL_POSAVL_CHK');
1818: FND_MESSAGE.SET_TOKEN('HIRING_STATUS',p_get_pos_avl_status.status);
1819: hr_utility.raise_error;
1820: END IF;
1821: END LOOP;

Line 1819: hr_utility.raise_error;

1815: FOR p_get_pos_avl_status IN c_get_pos_avl_status(l_detail_position_id,p_pa_request_rec.effective_date) LOOP
1816: IF p_get_pos_avl_status.status <> 'Active' THEN
1817: hr_utility.set_message(8301,'GHR_38193_DETAIL_POSAVL_CHK');
1818: FND_MESSAGE.SET_TOKEN('HIRING_STATUS',p_get_pos_avl_status.status);
1819: hr_utility.raise_error;
1820: END IF;
1821: END LOOP;
1822: --End Bug# 11781477
1823: --Begin Bug# 9899054, 9898968

Line 1829: hr_utility.set_message(8301,'GHR_38286_DETAIL_ASG_CHK');

1825: IF p_pa_request_rec.first_noa_code IN ('730','930') THEN
1826: --Begin Bug# 9898968
1827: IF l_session.noa_id_correct IS NULL THEN
1828: FOR l_detail_chk IN c_detail_chk(p_pa_request_rec.effective_date) LOOP
1829: hr_utility.set_message(8301,'GHR_38286_DETAIL_ASG_CHK');
1830: hr_utility.raise_error;
1831: END LOOP;
1832: END IF;
1833: --End Bug# 9898968

Line 1830: hr_utility.raise_error;

1826: --Begin Bug# 9898968
1827: IF l_session.noa_id_correct IS NULL THEN
1828: FOR l_detail_chk IN c_detail_chk(p_pa_request_rec.effective_date) LOOP
1829: hr_utility.set_message(8301,'GHR_38286_DETAIL_ASG_CHK');
1830: hr_utility.raise_error;
1831: END LOOP;
1832: END IF;
1833: --End Bug# 9898968
1834: END IF;

Line 1846: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');

1842: l_detail_nte_date := fnd_date.canonical_to_date(c_detail_first_nte_date_rec.first_noa_information1);
1843: END LOOP;
1844: END IF;
1845: IF l_detail_nte_date <= p_pa_request_rec.effective_date THEN
1846: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');
1847: FND_MESSAGE.SET_TOKEN('DETAIL_GEN_MSG','Detail NTE Date must not be earlier than the Detail Start Date');--Bug# 9899054
1848: hr_utility.raise_error;
1849: END IF;
1850: --Begin Bug# 11776559

Line 1848: hr_utility.raise_error;

1844: END IF;
1845: IF l_detail_nte_date <= p_pa_request_rec.effective_date THEN
1846: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');
1847: FND_MESSAGE.SET_TOKEN('DETAIL_GEN_MSG','Detail NTE Date must not be earlier than the Detail Start Date');--Bug# 9899054
1848: hr_utility.raise_error;
1849: END IF;
1850: --Begin Bug# 11776559
1851: IF l_detail_nte_date IS NOT NULL THEN
1852: ghr_history_fetch.fetch_asgei

Line 1860: hr_utility.set_message(8301,'GHR_38287_DETAIL_NTE_CHK');

1856: p_asg_ei_data => l_asg_extra_info_rec
1857: );
1858: FOR l_detail_chk IN c_detail_chk(l_detail_nte_date) LOOP
1859: IF NVL(l_detail_chk.assignment_extra_info_id,9999999) <> nvl(l_asg_extra_info_rec.assignment_extra_info_id,9999999) THEN
1860: hr_utility.set_message(8301,'GHR_38287_DETAIL_NTE_CHK');
1861: hr_utility.raise_error;
1862: END IF;
1863: END LOOP;
1864: END IF;

Line 1861: hr_utility.raise_error;

1857: );
1858: FOR l_detail_chk IN c_detail_chk(l_detail_nte_date) LOOP
1859: IF NVL(l_detail_chk.assignment_extra_info_id,9999999) <> nvl(l_asg_extra_info_rec.assignment_extra_info_id,9999999) THEN
1860: hr_utility.set_message(8301,'GHR_38287_DETAIL_NTE_CHK');
1861: hr_utility.raise_error;
1862: END IF;
1863: END LOOP;
1864: END IF;
1865: --End Bug# 11776559

Line 1869: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');

1865: --End Bug# 11776559
1866: END IF;
1867: --end Bug# 9899054 , 9898968
1868: IF p_pa_request_rec.first_noa_code IN ('930','931','932') AND l_detail_type between 'G' and 'P' THEN
1869: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');
1870: fnd_message.set_token('DETAIL_GEN_MSG','IF NOA is 9xx then Detail Type must be between A and F');
1871: hr_utility.raise_error;
1872: ELSIF p_pa_request_rec.first_noa_code IN ('730','731','732') AND l_detail_type between 'A' and 'F' THEN
1873: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');

Line 1871: hr_utility.raise_error;

1867: --end Bug# 9899054 , 9898968
1868: IF p_pa_request_rec.first_noa_code IN ('930','931','932') AND l_detail_type between 'G' and 'P' THEN
1869: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');
1870: fnd_message.set_token('DETAIL_GEN_MSG','IF NOA is 9xx then Detail Type must be between A and F');
1871: hr_utility.raise_error;
1872: ELSIF p_pa_request_rec.first_noa_code IN ('730','731','732') AND l_detail_type between 'A' and 'F' THEN
1873: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');
1874: fnd_message.set_token('DETAIL_GEN_MSG','IF NOA is 7xx then Detail Type must be between G and P');
1875: hr_utility.raise_error;

Line 1873: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');

1869: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');
1870: fnd_message.set_token('DETAIL_GEN_MSG','IF NOA is 9xx then Detail Type must be between A and F');
1871: hr_utility.raise_error;
1872: ELSIF p_pa_request_rec.first_noa_code IN ('730','731','732') AND l_detail_type between 'A' and 'F' THEN
1873: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');
1874: fnd_message.set_token('DETAIL_GEN_MSG','IF NOA is 7xx then Detail Type must be between G and P');
1875: hr_utility.raise_error;
1876: END IF;
1877: --check is there any open Detail Assignment record exists

Line 1875: hr_utility.raise_error;

1871: hr_utility.raise_error;
1872: ELSIF p_pa_request_rec.first_noa_code IN ('730','731','732') AND l_detail_type between 'A' and 'F' THEN
1873: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');
1874: fnd_message.set_token('DETAIL_GEN_MSG','IF NOA is 7xx then Detail Type must be between G and P');
1875: hr_utility.raise_error;
1876: END IF;
1877: --check is there any open Detail Assignment record exists
1878: FOR cur_detail_exists_rec IN cur_detail_exists(p_pa_request_rec.employee_assignment_id,
1879: nvl(p_pa_request_rec.effective_date,trunc(sysdate))) LOOP

Line 1883: hr_utility.set_message(8301,'GHR_37753_DETAIL_INFO_CHK');

1879: nvl(p_pa_request_rec.effective_date,trunc(sysdate))) LOOP
1880: --Bug# 9625781 added correct and 730, 930 condition
1881: IF cur_detail_exists_rec.user_status IS NOT NULL AND
1882: p_pa_request_rec.first_noa_code IN ('730','930') AND l_session.noa_id_correct IS NULL THEN
1883: hr_utility.set_message(8301,'GHR_37753_DETAIL_INFO_CHK');
1884: hr_utility.raise_error;
1885: END IF;
1886: END LOOP;
1887: END IF;

Line 1884: hr_utility.raise_error;

1880: --Bug# 9625781 added correct and 730, 930 condition
1881: IF cur_detail_exists_rec.user_status IS NOT NULL AND
1882: p_pa_request_rec.first_noa_code IN ('730','930') AND l_session.noa_id_correct IS NULL THEN
1883: hr_utility.set_message(8301,'GHR_37753_DETAIL_INFO_CHK');
1884: hr_utility.raise_error;
1885: END IF;
1886: END LOOP;
1887: END IF;
1888: --End Bug# 8653508

Line 1900: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,3);

1896: LOOP
1897: l_premium_pay_ind := cur_premium_pay_ind_rec.premium_pay_ind;
1898: END LOOP;
1899:
1900: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,3);
1901: IF l_premium_pay_ind IS NULL THEN
1902: ghr_api.retrieve_element_entry_value
1903: (p_element_name => 'Premium Pay',
1904: p_input_value_name => 'Premium Pay Ind',

Line 1915: hr_utility.set_message(8301,'GHR_38872_855_PREM_PAY');

1911: END IF;
1912:
1913: IF ( l_premium_pay_ind ) IS NULL
1914: OR ( l_premium_pay_ind <> 'K' ) THEN
1915: hr_utility.set_message(8301,'GHR_38872_855_PREM_PAY');
1916: hr_utility.raise_error;
1917: END IF;
1918:
1919: l_occ_code := p_pa_request_rec.from_occ_code;

Line 1916: hr_utility.raise_error;

1912:
1913: IF ( l_premium_pay_ind ) IS NULL
1914: OR ( l_premium_pay_ind <> 'K' ) THEN
1915: hr_utility.set_message(8301,'GHR_38872_855_PREM_PAY');
1916: hr_utility.raise_error;
1917: END IF;
1918:
1919: l_occ_code := p_pa_request_rec.from_occ_code;
1920:

Line 1923: hr_utility.set_message(8301,'GHR_38873_855_OCC_SERIES');

1919: l_occ_code := p_pa_request_rec.from_occ_code;
1920:
1921: If ( l_occ_code <> '0610' ) THEN
1922:
1923: hr_utility.set_message(8301,'GHR_38873_855_OCC_SERIES');
1924: hr_utility.raise_error;
1925:
1926: End If;
1927: --Bug# 3562063

Line 1924: hr_utility.raise_error;

1920:
1921: If ( l_occ_code <> '0610' ) THEN
1922:
1923: hr_utility.set_message(8301,'GHR_38873_855_OCC_SERIES');
1924: hr_utility.raise_error;
1925:
1926: End If;
1927: --Bug# 3562063
1928:

Line 1940: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,3);

1936: FOR cur_premium_pay_rec IN cur_premium_pay
1937: LOOP
1938: l_premium_pay_ind := cur_premium_pay_rec.premium_pay_ind;
1939: END LOOP;
1940: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,3);
1941:
1942: IF l_premium_pay_ind IS NULL THEN
1943: --Bug#3579579
1944: ghr_api.retrieve_element_entry_value

Line 1952: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,4);

1948: p_effective_date => p_pa_request_rec.effective_date,
1949: p_value => l_premium_pay_ind,
1950: p_multiple_error_flag => l_multiple_error_flag
1951: );
1952: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,4);
1953: END IF;
1954:
1955: l_occ_code := p_pa_request_rec.to_occ_code;
1956: hr_utility.set_location('Occ Code '|| l_occ_code,5);

Line 1956: hr_utility.set_location('Occ Code '|| l_occ_code,5);

1952: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,4);
1953: END IF;
1954:
1955: l_occ_code := p_pa_request_rec.to_occ_code;
1956: hr_utility.set_location('Occ Code '|| l_occ_code,5);
1957: IF l_occ_code IS NULL THEN
1958: l_occ_code := p_pa_request_rec.from_occ_code;
1959: END IF;
1960:

Line 1963: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');

1959: END IF;
1960:
1961: If l_premium_pay_ind='K' and l_occ_code NOT IN ('0602','0603','0610','0680','0681','0682','0683') THEN
1962:
1963: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');
1964: hr_utility.raise_error;
1965:
1966: End If;
1967:

Line 1964: hr_utility.raise_error;

1960:
1961: If l_premium_pay_ind='K' and l_occ_code NOT IN ('0602','0603','0610','0680','0681','0682','0683') THEN
1962:
1963: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');
1964: hr_utility.raise_error;
1965:
1966: End If;
1967:
1968: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN

Line 1970: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');

1966: End If;
1967:
1968: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN
1969:
1970: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');
1971: hr_utility.raise_error;
1972:
1973: End If;
1974:

Line 1971: hr_utility.raise_error;

1967:
1968: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN
1969:
1970: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');
1971: hr_utility.raise_error;
1972:
1973: End If;
1974:
1975: get_element_details_future(p_element_name => 'Premium Pay'

Line 1982: hr_utility.set_location('Premium Pay Ind future'|| l_premium_pay_ind,4);

1978: ,p_effective_date => p_pa_request_rec.effective_date
1979: ,p_value => l_premium_pay_ind
1980: ,p_effective_start_date => l_eff_start_date);
1981:
1982: hr_utility.set_location('Premium Pay Ind future'|| l_premium_pay_ind,4);
1983:
1984: If l_premium_pay_ind='K' and l_occ_code NOT IN ('0602','0603','0610','0680','0681','0682','0683') THEN
1985:
1986: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');

Line 1986: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');

1982: hr_utility.set_location('Premium Pay Ind future'|| l_premium_pay_ind,4);
1983:
1984: If l_premium_pay_ind='K' and l_occ_code NOT IN ('0602','0603','0610','0680','0681','0682','0683') THEN
1985:
1986: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');
1987: hr_utility.raise_error;
1988:
1989: End If;
1990:

Line 1987: hr_utility.raise_error;

1983:
1984: If l_premium_pay_ind='K' and l_occ_code NOT IN ('0602','0603','0610','0680','0681','0682','0683') THEN
1985:
1986: hr_utility.set_message(8301,'GHR_38859_OCC_CD_PREM_PAY_IND');
1987: hr_utility.raise_error;
1988:
1989: End If;
1990:
1991: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN

Line 1993: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');

1989: End If;
1990:
1991: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN
1992:
1993: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');
1994: hr_utility.raise_error;
1995:
1996: End If;
1997:

Line 1994: hr_utility.raise_error;

1990:
1991: If l_premium_pay_ind='X' and l_occ_code NOT IN ('0180','0602','0620','0631','0633','0651','0660','0680') THEN
1992:
1993: hr_utility.set_message(8301, 'GHR_38860_OCC_CD_PREM_PAY_IND');
1994: hr_utility.raise_error;
1995:
1996: End If;
1997:
1998:

Line 2011: hr_utility.set_location('AP Amount '||l_ap_amount,7);

2007: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,
2008: P_VALUE => l_ap_amount,
2009: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
2010: );
2011: hr_utility.set_location('AP Amount '||l_ap_amount,7);
2012: IF l_ap_amount is NULL and
2013: (p_pa_request_rec.to_other_pay_amount is null or
2014: p_pa_request_rec.to_other_pay_amount = 0 ) THEN
2015: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');

Line 2015: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');

2011: hr_utility.set_location('AP Amount '||l_ap_amount,7);
2012: IF l_ap_amount is NULL and
2013: (p_pa_request_rec.to_other_pay_amount is null or
2014: p_pa_request_rec.to_other_pay_amount = 0 ) THEN
2015: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');
2016: hr_utility.raise_error;
2017: END IF;
2018:
2019: --Pradeep

Line 2016: hr_utility.raise_error;

2012: IF l_ap_amount is NULL and
2013: (p_pa_request_rec.to_other_pay_amount is null or
2014: p_pa_request_rec.to_other_pay_amount = 0 ) THEN
2015: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');
2016: hr_utility.raise_error;
2017: END IF;
2018:
2019: --Pradeep
2020: --Title 38 Employess should not get Avaialability Pay.

Line 2029: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,7);

2025: p_effective_date => p_pa_request_rec.effective_date,
2026: p_value => l_premium_pay_ind,
2027: p_multiple_error_flag => l_multiple_error_flag
2028: );
2029: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,7);
2030:
2031: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2032:
2033: hr_utility.set_message(8301,'GHR_38857_OTH_PAY_PREM_PAY');

Line 2033: hr_utility.set_message(8301,'GHR_38857_OTH_PAY_PREM_PAY');

2029: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,7);
2030:
2031: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2032:
2033: hr_utility.set_message(8301,'GHR_38857_OTH_PAY_PREM_PAY');
2034: hr_utility.raise_error;
2035:
2036: END IF;
2037:

Line 2034: hr_utility.raise_error;

2030:
2031: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2032:
2033: hr_utility.set_message(8301,'GHR_38857_OTH_PAY_PREM_PAY');
2034: hr_utility.raise_error;
2035:
2036: END IF;
2037:
2038: --To check if premium pay element is existing in the future

Line 2046: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,8);

2042: ,p_effective_date => p_pa_request_rec.effective_date
2043: ,p_value => l_premium_pay_ind
2044: ,p_effective_start_date => l_eff_start_date);
2045:
2046: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,8);
2047:
2048: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2049:
2050: hr_utility.set_message(8301,'GHR_38866_OTH_PAY_PREM_PAY_FUT');

Line 2050: hr_utility.set_message(8301,'GHR_38866_OTH_PAY_PREM_PAY_FUT');

2046: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,8);
2047:
2048: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2049:
2050: hr_utility.set_message(8301,'GHR_38866_OTH_PAY_PREM_PAY_FUT');
2051: hr_utility.raise_error;
2052:
2053: END IF;
2054:

Line 2051: hr_utility.raise_error;

2047:
2048: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2049:
2050: hr_utility.set_message(8301,'GHR_38866_OTH_PAY_PREM_PAY_FUT');
2051: hr_utility.raise_error;
2052:
2053: END IF;
2054:
2055: END IF;

Line 2067: hr_utility.set_location('AUO Amount '||l_auo_amount,7);

2063: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,
2064: P_VALUE => l_auo_amount,
2065: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
2066: );
2067: hr_utility.set_location('AUO Amount '||l_auo_amount,7);
2068: IF l_auo_amount is NULL and
2069: (p_pa_request_rec.to_other_pay_amount is null or
2070: p_pa_request_rec.to_other_pay_amount = 0 ) THEN
2071: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');

Line 2071: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');

2067: hr_utility.set_location('AUO Amount '||l_auo_amount,7);
2068: IF l_auo_amount is NULL and
2069: (p_pa_request_rec.to_other_pay_amount is null or
2070: p_pa_request_rec.to_other_pay_amount = 0 ) THEN
2071: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');
2072: hr_utility.raise_error;
2073: END IF;
2074:
2075: --Pradeep

Line 2072: hr_utility.raise_error;

2068: IF l_auo_amount is NULL and
2069: (p_pa_request_rec.to_other_pay_amount is null or
2070: p_pa_request_rec.to_other_pay_amount = 0 ) THEN
2071: hr_utility.set_message(8301,'GHR_38589_NULL_OTHER_PAY');
2072: hr_utility.raise_error;
2073: END IF;
2074:
2075: --Pradeep
2076: --Title 38 Employess should not get AUO.

Line 2085: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,7);

2081: p_effective_date => p_pa_request_rec.effective_date,
2082: p_value => l_premium_pay_ind,
2083: p_multiple_error_flag => l_multiple_error_flag
2084: );
2085: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,7);
2086:
2087: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2088:
2089: hr_utility.set_message(8301,'GHR_38857_OTH_PAY_PREM_PAY');

Line 2089: hr_utility.set_message(8301,'GHR_38857_OTH_PAY_PREM_PAY');

2085: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,7);
2086:
2087: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2088:
2089: hr_utility.set_message(8301,'GHR_38857_OTH_PAY_PREM_PAY');
2090: hr_utility.raise_error;
2091:
2092: END IF;
2093:

Line 2090: hr_utility.raise_error;

2086:
2087: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2088:
2089: hr_utility.set_message(8301,'GHR_38857_OTH_PAY_PREM_PAY');
2090: hr_utility.raise_error;
2091:
2092: END IF;
2093:
2094: --To check if premium pay element is existing in the future

Line 2102: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,8);

2098: ,p_effective_date => p_pa_request_rec.effective_date
2099: ,p_value => l_premium_pay_ind
2100: ,p_effective_start_date => l_eff_start_date);
2101:
2102: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,8);
2103:
2104: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2105:
2106: hr_utility.set_message(8301,'GHR_38866_OTH_PAY_PREM_PAY_FUT');

Line 2106: hr_utility.set_message(8301,'GHR_38866_OTH_PAY_PREM_PAY_FUT');

2102: hr_utility.set_location('Premium Pay Ind '|| l_prem_pay,8);
2103:
2104: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2105:
2106: hr_utility.set_message(8301,'GHR_38866_OTH_PAY_PREM_PAY_FUT');
2107: hr_utility.raise_error;
2108:
2109: END IF;
2110:

Line 2107: hr_utility.raise_error;

2103:
2104: IF l_premium_pay_ind IN ( 'K','L','M','X' ) THEN
2105:
2106: hr_utility.set_message(8301,'GHR_38866_OTH_PAY_PREM_PAY_FUT');
2107: hr_utility.raise_error;
2108:
2109: END IF;
2110:
2111: END IF;

Line 2118: hr_utility.set_location('Check 855 Retained Grade ...get open pay range ' ,20);

2114: OR ( p_pa_request_rec.first_noa_code='002' and p_pa_request_rec.second_noa_code ='855') THEN
2115:
2116: IF p_pa_request_rec.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
2117: begin
2118: hr_utility.set_location('Check 855 Retained Grade ...get open pay range ' ,20);
2119:
2120: l_retained_grade := ghr_pc_basic_pay.get_retained_grade_details (p_pa_request_rec.person_id
2121: ,NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)));
2122:

Line 2133: hr_utility.set_location(' check 855 Retained to step ' || l_to_step_or_rate,22);

2129: ELSE
2130: l_to_step_or_rate := l_retained_grade.step_or_rate;
2131: END IF;
2132:
2133: hr_utility.set_location(' check 855 Retained to step ' || l_to_step_or_rate,22);
2134:
2135: l_retained_grade := ghr_pc_basic_pay.get_retained_grade_details (p_pa_request_rec.person_id
2136: ,(p_pa_request_rec.effective_date - 1));
2137:

Line 2148: hr_utility.set_location(' check 855 Retained from step ' || l_from_step_or_rate,24);

2144: ELSE
2145: l_from_step_or_rate := l_retained_grade.step_or_rate;
2146: END IF;
2147:
2148: hr_utility.set_location(' check 855 Retained from step ' || l_from_step_or_rate,24);
2149:
2150: exception
2151: when others then
2152: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);

Line 2152: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);

2148: hr_utility.set_location(' check 855 Retained from step ' || l_from_step_or_rate,24);
2149:
2150: exception
2151: when others then
2152: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);
2153: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');
2154: hr_utility.raise_error;
2155: end;
2156:

Line 2153: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');

2149:
2150: exception
2151: when others then
2152: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);
2153: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');
2154: hr_utility.raise_error;
2155: end;
2156:
2157: IF ABS(l_to_step_or_rate - l_from_step_or_rate) > 2 THEN

Line 2154: hr_utility.raise_error;

2150: exception
2151: when others then
2152: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);
2153: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');
2154: hr_utility.raise_error;
2155: end;
2156:
2157: IF ABS(l_to_step_or_rate - l_from_step_or_rate) > 2 THEN
2158: hr_utility.set_message(8301,'GHR_38852_TO_STEP_OR_RATE');

Line 2158: hr_utility.set_message(8301,'GHR_38852_TO_STEP_OR_RATE');

2154: hr_utility.raise_error;
2155: end;
2156:
2157: IF ABS(l_to_step_or_rate - l_from_step_or_rate) > 2 THEN
2158: hr_utility.set_message(8301,'GHR_38852_TO_STEP_OR_RATE');
2159: hr_utility.raise_error;
2160: END IF;
2161:
2162: END IF;

Line 2159: hr_utility.raise_error;

2155: end;
2156:
2157: IF ABS(l_to_step_or_rate - l_from_step_or_rate) > 2 THEN
2158: hr_utility.set_message(8301,'GHR_38852_TO_STEP_OR_RATE');
2159: hr_utility.raise_error;
2160: END IF;
2161:
2162: END IF;
2163: END IF;

Line 2208: hr_utility.set_message(8301,'GHR_ONE_OP_UPDATE_ONLY');

2204: l_for_810_count := l_for_810_count + 1;
2205: end if;
2206: --
2207: if l_for_810_count > 1 then
2208: hr_utility.set_message(8301,'GHR_ONE_OP_UPDATE_ONLY');
2209: hr_utility.raise_error;
2210: end if;
2211: end if;
2212: hr_utility.set_location('GHRVALID-Before LAC Validation',3);

Line 2209: hr_utility.raise_error;

2205: end if;
2206: --
2207: if l_for_810_count > 1 then
2208: hr_utility.set_message(8301,'GHR_ONE_OP_UPDATE_ONLY');
2209: hr_utility.raise_error;
2210: end if;
2211: end if;
2212: hr_utility.set_location('GHRVALID-Before LAC Validation',3);
2213: -- Bug # 941255 --Venkat-- Check that LACs are Valid when Update HR

Line 2212: hr_utility.set_location('GHRVALID-Before LAC Validation',3);

2208: hr_utility.set_message(8301,'GHR_ONE_OP_UPDATE_ONLY');
2209: hr_utility.raise_error;
2210: end if;
2211: end if;
2212: hr_utility.set_location('GHRVALID-Before LAC Validation',3);
2213: -- Bug # 941255 --Venkat-- Check that LACs are Valid when Update HR
2214: -- in progress and give a Error message if NOAC/LAC combination is invalid
2215: --
2216: -- Check if first_action_la_code1 is valid

Line 2226: hr_utility.set_message(8301, 'GHR_38105_INV_FIRST_LA_CODE1');

2222: exit;
2223: end loop;
2224: --
2225: if not l_exists then
2226: hr_utility.set_message(8301, 'GHR_38105_INV_FIRST_LA_CODE1');
2227: hr_utility.raise_error;
2228: end if;
2229: end if;
2230:

Line 2227: hr_utility.raise_error;

2223: end loop;
2224: --
2225: if not l_exists then
2226: hr_utility.set_message(8301, 'GHR_38105_INV_FIRST_LA_CODE1');
2227: hr_utility.raise_error;
2228: end if;
2229: end if;
2230:
2231: l_exists := false;

Line 2241: hr_utility.set_message(8301, 'GHR_38106_INV_FIRST_LA_CODE2');

2237: exit;
2238: end loop;
2239: --
2240: if not l_exists then
2241: hr_utility.set_message(8301, 'GHR_38106_INV_FIRST_LA_CODE2');
2242: hr_utility.raise_error;
2243: end if;
2244: end if;
2245: l_exists := false;

Line 2242: hr_utility.raise_error;

2238: end loop;
2239: --
2240: if not l_exists then
2241: hr_utility.set_message(8301, 'GHR_38106_INV_FIRST_LA_CODE2');
2242: hr_utility.raise_error;
2243: end if;
2244: end if;
2245: l_exists := false;
2246: --

Line 2256: hr_utility.set_message(8301, 'GHR_38107_INV_SECOND_LA_CODE1');

2252: exit;
2253: end loop;
2254: --
2255: if not l_exists then
2256: hr_utility.set_message(8301, 'GHR_38107_INV_SECOND_LA_CODE1');
2257: hr_utility.raise_error;
2258: end if;
2259: end if;
2260: l_exists := false;

Line 2257: hr_utility.raise_error;

2253: end loop;
2254: --
2255: if not l_exists then
2256: hr_utility.set_message(8301, 'GHR_38107_INV_SECOND_LA_CODE1');
2257: hr_utility.raise_error;
2258: end if;
2259: end if;
2260: l_exists := false;
2261: --

Line 2271: hr_utility.set_message(8301, 'GHR_38108_INV_SECOND_LA_CODE2');

2267: exit;
2268: end loop;
2269: --
2270: if not l_exists then
2271: hr_utility.set_message(8301, 'GHR_38108_INV_SECOND_LA_CODE2');
2272: hr_utility.raise_error;
2273: end if;
2274: end if;
2275: hr_utility.set_location('GHRVALID-After LAC Validation',4);

Line 2272: hr_utility.raise_error;

2268: end loop;
2269: --
2270: if not l_exists then
2271: hr_utility.set_message(8301, 'GHR_38108_INV_SECOND_LA_CODE2');
2272: hr_utility.raise_error;
2273: end if;
2274: end if;
2275: hr_utility.set_location('GHRVALID-After LAC Validation',4);
2276: --

Line 2275: hr_utility.set_location('GHRVALID-After LAC Validation',4);

2271: hr_utility.set_message(8301, 'GHR_38108_INV_SECOND_LA_CODE2');
2272: hr_utility.raise_error;
2273: end if;
2274: end if;
2275: hr_utility.set_location('GHRVALID-After LAC Validation',4);
2276: --
2277: --
2278: -- Validate if the open pay range basic pay is entered by user.
2279: --

Line 2298: hr_utility.set_location('GHRVALID-Open Pay Range get table_id' ,5);

2294: ,p_pa_request_rec.pay_rate_determinant
2295: ,p_pa_request_rec.pa_request_id
2296: ,NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) ) THEN
2297:
2298: hr_utility.set_location('GHRVALID-Open Pay Range get table_id' ,5);
2299:
2300:
2301:
2302: IF p_pa_request_rec.pay_rate_determinant IN ('A','B','E','F','U','V') THEN

Line 2304: hr_utility.set_location('Retained Grade ...get open pay range ' ,20);

2300:
2301:
2302: IF p_pa_request_rec.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
2303: begin
2304: hr_utility.set_location('Retained Grade ...get open pay range ' ,20);
2305:
2306: l_retained_grade := ghr_pc_basic_pay.get_retained_grade_details (p_pa_request_rec.person_id
2307: ,NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)));
2308: l_user_table_id := l_retained_grade.user_table_id;

Line 2311: hr_utility.set_location(' Retained user table id ' || to_char(l_user_table_id),22);

2307: ,NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)));
2308: l_user_table_id := l_retained_grade.user_table_id;
2309: l_pay_plan := l_retained_grade.pay_plan;
2310: l_grade_or_level := l_retained_grade.grade_or_level;
2311: hr_utility.set_location(' Retained user table id ' || to_char(l_user_table_id),22);
2312: exception
2313: when others then
2314: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);
2315: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');

Line 2314: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);

2310: l_grade_or_level := l_retained_grade.grade_or_level;
2311: hr_utility.set_location(' Retained user table id ' || to_char(l_user_table_id),22);
2312: exception
2313: when others then
2314: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);
2315: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');
2316: hr_utility.raise_error;
2317: end;
2318:

Line 2315: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');

2311: hr_utility.set_location(' Retained user table id ' || to_char(l_user_table_id),22);
2312: exception
2313: when others then
2314: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);
2315: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');
2316: hr_utility.raise_error;
2317: end;
2318:
2319: ELSE

Line 2316: hr_utility.raise_error;

2312: exception
2313: when others then
2314: hr_utility.set_location('Retained Exception raised ' || sqlerrm(sqlcode),25);
2315: hr_utility.set_message(8301,'GHR_38255_MISSING_RETAINED_DET');
2316: hr_utility.raise_error;
2317: end;
2318:
2319: ELSE
2320:

Line 2348: --hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);

2344: END IF;
2345:
2346:
2347:
2348: --hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2349: --hr_utility.set_location('GHRVALID-l_pay_plan ' || to_char(l_pay_plan) ,5);
2350: --hr_utility.set_location('GHRVALID-l_grade_or_level ' || to_char(l_grade_or_level) ,5);
2351:
2352: hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);

Line 2349: --hr_utility.set_location('GHRVALID-l_pay_plan ' || to_char(l_pay_plan) ,5);

2345:
2346:
2347:
2348: --hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2349: --hr_utility.set_location('GHRVALID-l_pay_plan ' || to_char(l_pay_plan) ,5);
2350: --hr_utility.set_location('GHRVALID-l_grade_or_level ' || to_char(l_grade_or_level) ,5);
2351:
2352: hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2353: hr_utility.set_location('GHRVALID-Open Pay Range get values' ,5);

Line 2350: --hr_utility.set_location('GHRVALID-l_grade_or_level ' || to_char(l_grade_or_level) ,5);

2346:
2347:
2348: --hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2349: --hr_utility.set_location('GHRVALID-l_pay_plan ' || to_char(l_pay_plan) ,5);
2350: --hr_utility.set_location('GHRVALID-l_grade_or_level ' || to_char(l_grade_or_level) ,5);
2351:
2352: hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2353: hr_utility.set_location('GHRVALID-Open Pay Range get values' ,5);
2354:

Line 2352: hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);

2348: --hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2349: --hr_utility.set_location('GHRVALID-l_pay_plan ' || to_char(l_pay_plan) ,5);
2350: --hr_utility.set_location('GHRVALID-l_grade_or_level ' || to_char(l_grade_or_level) ,5);
2351:
2352: hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2353: hr_utility.set_location('GHRVALID-Open Pay Range get values' ,5);
2354:
2355: ghr_pay_calc.get_open_pay_table_values
2356: (p_user_table_id => l_user_table_id

Line 2353: hr_utility.set_location('GHRVALID-Open Pay Range get values' ,5);

2349: --hr_utility.set_location('GHRVALID-l_pay_plan ' || to_char(l_pay_plan) ,5);
2350: --hr_utility.set_location('GHRVALID-l_grade_or_level ' || to_char(l_grade_or_level) ,5);
2351:
2352: hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2353: hr_utility.set_location('GHRVALID-Open Pay Range get values' ,5);
2354:
2355: ghr_pay_calc.get_open_pay_table_values
2356: (p_user_table_id => l_user_table_id
2357: ,p_pay_plan => l_pay_plan

Line 2364: hr_utility.set_location('GHRVALID-Open Pay Ranges found',5);

2360: ,p_row_high => l_row_high
2361: ,p_row_low => l_row_low );
2362:
2363:
2364: hr_utility.set_location('GHRVALID-Open Pay Ranges found',5);
2365:
2366: IF l_row_low is null and l_row_high is null then
2367: ---Raise Error
2368: hr_utility.set_message(8301, 'GHR_38715_OPEN_PAY_RANGE_NF');

Line 2368: hr_utility.set_message(8301, 'GHR_38715_OPEN_PAY_RANGE_NF');

2364: hr_utility.set_location('GHRVALID-Open Pay Ranges found',5);
2365:
2366: IF l_row_low is null and l_row_high is null then
2367: ---Raise Error
2368: hr_utility.set_message(8301, 'GHR_38715_OPEN_PAY_RANGE_NF');
2369: hr_utility.raise_error;
2370: END IF;
2371:
2372: -- 5482191 Start

Line 2369: hr_utility.raise_error;

2365:
2366: IF l_row_low is null and l_row_high is null then
2367: ---Raise Error
2368: hr_utility.set_message(8301, 'GHR_38715_OPEN_PAY_RANGE_NF');
2369: hr_utility.raise_error;
2370: END IF;
2371:
2372: -- 5482191 Start
2373: --Bug 5658361 IF NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) >= to_date('07/01/2007','DD/MM/YYYY') AND

Line 2378: hr_utility.set_message(8301, 'GHR_38513_AFHR_VAL_CHK');

2374: --Bug 5658361 p_pa_request_rec.first_noa_code in ('891','892','893','894','890','896','897') AND
2375: --Bug# 6073655 Brought out this code from the l_psi<>'00' condition
2376: IF p_pa_request_rec.first_noa_code = '897'
2377: AND p_pa_request_rec.to_basic_pay >= p_pa_request_rec.from_basic_pay THEN
2378: hr_utility.set_message(8301, 'GHR_38513_AFHR_VAL_CHK');
2379: hr_utility.raise_error;
2380: END IF;
2381: --Bug# 6073655
2382: IF l_psi <> '00' THEN

Line 2379: hr_utility.raise_error;

2375: --Bug# 6073655 Brought out this code from the l_psi<>'00' condition
2376: IF p_pa_request_rec.first_noa_code = '897'
2377: AND p_pa_request_rec.to_basic_pay >= p_pa_request_rec.from_basic_pay THEN
2378: hr_utility.set_message(8301, 'GHR_38513_AFHR_VAL_CHK');
2379: hr_utility.raise_error;
2380: END IF;
2381: --Bug# 6073655
2382: IF l_psi <> '00' THEN
2383: IF NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) >= to_date('30/04/2006','DD/MM/YYYY') THEN --Bug 5658361

Line 2386: hr_utility.set_message(8301, 'GHR_38506_AFHR_PRD_CHK');

2382: IF l_psi <> '00' THEN
2383: IF NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) >= to_date('30/04/2006','DD/MM/YYYY') THEN --Bug 5658361
2384: IF p_pa_request_rec.pay_rate_determinant IN ('4','R') AND
2385: l_row_high >= p_pa_request_rec.to_basic_pay THEN
2386: hr_utility.set_message(8301, 'GHR_38506_AFHR_PRD_CHK');
2387: hr_utility.raise_error;
2388: ELSIF p_pa_request_rec.pay_rate_determinant = 'T' AND
2389: l_row_low <= p_pa_request_rec.to_basic_pay THEN
2390: hr_utility.set_message(8301, 'GHR_38508_AFHR_PRD_CHK');

Line 2387: hr_utility.raise_error;

2383: IF NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) >= to_date('30/04/2006','DD/MM/YYYY') THEN --Bug 5658361
2384: IF p_pa_request_rec.pay_rate_determinant IN ('4','R') AND
2385: l_row_high >= p_pa_request_rec.to_basic_pay THEN
2386: hr_utility.set_message(8301, 'GHR_38506_AFHR_PRD_CHK');
2387: hr_utility.raise_error;
2388: ELSIF p_pa_request_rec.pay_rate_determinant = 'T' AND
2389: l_row_low <= p_pa_request_rec.to_basic_pay THEN
2390: hr_utility.set_message(8301, 'GHR_38508_AFHR_PRD_CHK');
2391: hr_utility.raise_error;

Line 2390: hr_utility.set_message(8301, 'GHR_38508_AFHR_PRD_CHK');

2386: hr_utility.set_message(8301, 'GHR_38506_AFHR_PRD_CHK');
2387: hr_utility.raise_error;
2388: ELSIF p_pa_request_rec.pay_rate_determinant = 'T' AND
2389: l_row_low <= p_pa_request_rec.to_basic_pay THEN
2390: hr_utility.set_message(8301, 'GHR_38508_AFHR_PRD_CHK');
2391: hr_utility.raise_error;
2392: ELSIF p_pa_request_rec.pay_rate_determinant = '0' AND
2393: (l_row_low > p_pa_request_rec.to_basic_pay OR l_row_high < p_pa_request_rec.to_basic_pay) THEN
2394: hr_utility.set_message(8301, 'GHR_38507_AFHR_PAY_CHK');

Line 2391: hr_utility.raise_error;

2387: hr_utility.raise_error;
2388: ELSIF p_pa_request_rec.pay_rate_determinant = 'T' AND
2389: l_row_low <= p_pa_request_rec.to_basic_pay THEN
2390: hr_utility.set_message(8301, 'GHR_38508_AFHR_PRD_CHK');
2391: hr_utility.raise_error;
2392: ELSIF p_pa_request_rec.pay_rate_determinant = '0' AND
2393: (l_row_low > p_pa_request_rec.to_basic_pay OR l_row_high < p_pa_request_rec.to_basic_pay) THEN
2394: hr_utility.set_message(8301, 'GHR_38507_AFHR_PAY_CHK');
2395: hr_utility.raise_error;

Line 2394: hr_utility.set_message(8301, 'GHR_38507_AFHR_PAY_CHK');

2390: hr_utility.set_message(8301, 'GHR_38508_AFHR_PRD_CHK');
2391: hr_utility.raise_error;
2392: ELSIF p_pa_request_rec.pay_rate_determinant = '0' AND
2393: (l_row_low > p_pa_request_rec.to_basic_pay OR l_row_high < p_pa_request_rec.to_basic_pay) THEN
2394: hr_utility.set_message(8301, 'GHR_38507_AFHR_PAY_CHK');
2395: hr_utility.raise_error;
2396: END IF;
2397: IF p_pa_request_rec.to_step_or_rate <> '00' THEN --Bug 5657572
2398: hr_utility.set_message(8301, 'GHR_38474_AFH_TO_STEP_OR_RATE');

Line 2395: hr_utility.raise_error;

2391: hr_utility.raise_error;
2392: ELSIF p_pa_request_rec.pay_rate_determinant = '0' AND
2393: (l_row_low > p_pa_request_rec.to_basic_pay OR l_row_high < p_pa_request_rec.to_basic_pay) THEN
2394: hr_utility.set_message(8301, 'GHR_38507_AFHR_PAY_CHK');
2395: hr_utility.raise_error;
2396: END IF;
2397: IF p_pa_request_rec.to_step_or_rate <> '00' THEN --Bug 5657572
2398: hr_utility.set_message(8301, 'GHR_38474_AFH_TO_STEP_OR_RATE');
2399: hr_utility.raise_error;

Line 2398: hr_utility.set_message(8301, 'GHR_38474_AFH_TO_STEP_OR_RATE');

2394: hr_utility.set_message(8301, 'GHR_38507_AFHR_PAY_CHK');
2395: hr_utility.raise_error;
2396: END IF;
2397: IF p_pa_request_rec.to_step_or_rate <> '00' THEN --Bug 5657572
2398: hr_utility.set_message(8301, 'GHR_38474_AFH_TO_STEP_OR_RATE');
2399: hr_utility.raise_error;
2400: END IF;
2401: END IF;
2402: ELSE

Line 2399: hr_utility.raise_error;

2395: hr_utility.raise_error;
2396: END IF;
2397: IF p_pa_request_rec.to_step_or_rate <> '00' THEN --Bug 5657572
2398: hr_utility.set_message(8301, 'GHR_38474_AFH_TO_STEP_OR_RATE');
2399: hr_utility.raise_error;
2400: END IF;
2401: END IF;
2402: ELSE
2403: --6489042 No validation is needed for PRD 2

Line 2412: hr_utility.set_message(8301, 'GHR_38714_OPEN_PAY_RANGE_VAL');

2408: l_row_high >= p_pa_request_rec.to_basic_pay then
2409: null;
2410: ELSE
2411: ---Raise Error
2412: hr_utility.set_message(8301, 'GHR_38714_OPEN_PAY_RANGE_VAL');
2413: hr_utility.set_message_token('MIN',to_char(l_row_low));
2414: hr_utility.set_message_token('MAX',to_char(l_row_high));
2415: hr_utility.raise_error;
2416: END IF;

Line 2413: hr_utility.set_message_token('MIN',to_char(l_row_low));

2409: null;
2410: ELSE
2411: ---Raise Error
2412: hr_utility.set_message(8301, 'GHR_38714_OPEN_PAY_RANGE_VAL');
2413: hr_utility.set_message_token('MIN',to_char(l_row_low));
2414: hr_utility.set_message_token('MAX',to_char(l_row_high));
2415: hr_utility.raise_error;
2416: END IF;
2417: END IF;

Line 2414: hr_utility.set_message_token('MAX',to_char(l_row_high));

2410: ELSE
2411: ---Raise Error
2412: hr_utility.set_message(8301, 'GHR_38714_OPEN_PAY_RANGE_VAL');
2413: hr_utility.set_message_token('MIN',to_char(l_row_low));
2414: hr_utility.set_message_token('MAX',to_char(l_row_high));
2415: hr_utility.raise_error;
2416: END IF;
2417: END IF;
2418: END IF;

Line 2415: hr_utility.raise_error;

2411: ---Raise Error
2412: hr_utility.set_message(8301, 'GHR_38714_OPEN_PAY_RANGE_VAL');
2413: hr_utility.set_message_token('MIN',to_char(l_row_low));
2414: hr_utility.set_message_token('MAX',to_char(l_row_high));
2415: hr_utility.raise_error;
2416: END IF;
2417: END IF;
2418: END IF;
2419: -- 5482191 End

Line 2428: hr_utility.set_message(8301, 'GHR_38462_AFHR_POS_SEL');

2424: /**** As per GPPA update 46 req. for 890 any employee is fine
2425: IF NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) >= to_date('07/01/2007','DD/MM/YYYY') AND
2426: p_pa_request_rec.first_noa_code = '890' THEN
2427: IF l_psi = '00' THEN
2428: hr_utility.set_message(8301, 'GHR_38462_AFHR_POS_SEL');
2429: hr_utility.raise_error;
2430: END IF;
2431: END IF;
2432: *******/

Line 2429: hr_utility.raise_error;

2425: IF NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) >= to_date('07/01/2007','DD/MM/YYYY') AND
2426: p_pa_request_rec.first_noa_code = '890' THEN
2427: IF l_psi = '00' THEN
2428: hr_utility.set_message(8301, 'GHR_38462_AFHR_POS_SEL');
2429: hr_utility.raise_error;
2430: END IF;
2431: END IF;
2432: *******/
2433: END IF;

Line 2442: hr_utility.set_message(8301, 'GHR_38457_AFHR_NOA_CHK');

2438: --Removed 894 NOAC for rating of record check as part of GPPA U46 Req.
2439: IF p_pa_request_rec.first_noa_code in ('891','892') AND l_psi <> '00' THEN
2440: IF p_pa_request_rec.first_noa_code = '891' AND
2441: nvl(p_perf_appraisal_type.rating_rec_level,'X') NOT IN ('3','4','5') THEN
2442: hr_utility.set_message(8301, 'GHR_38457_AFHR_NOA_CHK');
2443: hr_utility.raise_error;
2444: END IF;
2445: IF p_pa_request_rec.first_noa_code = '892' AND
2446: nvl(p_perf_appraisal_type.rating_rec_level,'X') IN ('1','2') THEN

Line 2443: hr_utility.raise_error;

2439: IF p_pa_request_rec.first_noa_code in ('891','892') AND l_psi <> '00' THEN
2440: IF p_pa_request_rec.first_noa_code = '891' AND
2441: nvl(p_perf_appraisal_type.rating_rec_level,'X') NOT IN ('3','4','5') THEN
2442: hr_utility.set_message(8301, 'GHR_38457_AFHR_NOA_CHK');
2443: hr_utility.raise_error;
2444: END IF;
2445: IF p_pa_request_rec.first_noa_code = '892' AND
2446: nvl(p_perf_appraisal_type.rating_rec_level,'X') IN ('1','2') THEN
2447: hr_utility.set_message(8301, 'GHR_38510_AFHR_NOA_CHK');

Line 2447: hr_utility.set_message(8301, 'GHR_38510_AFHR_NOA_CHK');

2443: hr_utility.raise_error;
2444: END IF;
2445: IF p_pa_request_rec.first_noa_code = '892' AND
2446: nvl(p_perf_appraisal_type.rating_rec_level,'X') IN ('1','2') THEN
2447: hr_utility.set_message(8301, 'GHR_38510_AFHR_NOA_CHK');
2448: hr_utility.raise_error;
2449: END IF;
2450: /****GPPA U46
2451: IF p_pa_request_rec.first_noa_code = '894' AND

Line 2448: hr_utility.raise_error;

2444: END IF;
2445: IF p_pa_request_rec.first_noa_code = '892' AND
2446: nvl(p_perf_appraisal_type.rating_rec_level,'X') IN ('1','2') THEN
2447: hr_utility.set_message(8301, 'GHR_38510_AFHR_NOA_CHK');
2448: hr_utility.raise_error;
2449: END IF;
2450: /****GPPA U46
2451: IF p_pa_request_rec.first_noa_code = '894' AND
2452: nvl(p_perf_appraisal_type.rating_rec_level,'X') = '1' THEN

Line 2453: hr_utility.set_message(8301, 'GHR_38511_AFHR_NOA_CHK');

2449: END IF;
2450: /****GPPA U46
2451: IF p_pa_request_rec.first_noa_code = '894' AND
2452: nvl(p_perf_appraisal_type.rating_rec_level,'X') = '1' THEN
2453: hr_utility.set_message(8301, 'GHR_38511_AFHR_NOA_CHK');
2454: hr_utility.raise_error;
2455: END IF;
2456: *****GPPA ****/
2457: END IF;

Line 2454: hr_utility.raise_error;

2450: /****GPPA U46
2451: IF p_pa_request_rec.first_noa_code = '894' AND
2452: nvl(p_perf_appraisal_type.rating_rec_level,'X') = '1' THEN
2453: hr_utility.set_message(8301, 'GHR_38511_AFHR_NOA_CHK');
2454: hr_utility.raise_error;
2455: END IF;
2456: *****GPPA ****/
2457: END IF;
2458:

Line 2475: hr_utility.set_message(8301,'GHR_38824_RG_TPS_REQUIRED');

2471: NULL;
2472: END;
2473: IF l_retained_grade.person_extra_info_id is not null and
2474: l_retained_grade.temp_step is null THEN
2475: hr_utility.set_message(8301,'GHR_38824_RG_TPS_REQUIRED');
2476: hr_utility.raise_error;
2477: END IF;
2478: END IF;
2479: --Bug 5527363

Line 2476: hr_utility.raise_error;

2472: END;
2473: IF l_retained_grade.person_extra_info_id is not null and
2474: l_retained_grade.temp_step is null THEN
2475: hr_utility.set_message(8301,'GHR_38824_RG_TPS_REQUIRED');
2476: hr_utility.raise_error;
2477: END IF;
2478: END IF;
2479: --Bug 5527363
2480: IF p_pa_request_rec.noa_family_code = 'CONV_APP' AND p_within_grade_incr.p_date_wgi_due IS NOT NULL

Line 2482: hr_utility.set_message(8301,'GHR_37740_CONV_APP_NULL_DLEI');

2478: END IF;
2479: --Bug 5527363
2480: IF p_pa_request_rec.noa_family_code = 'CONV_APP' AND p_within_grade_incr.p_date_wgi_due IS NOT NULL
2481: AND p_within_grade_incr.p_last_equi_incr IS NULL THEN
2482: hr_utility.set_message(8301,'GHR_37740_CONV_APP_NULL_DLEI');
2483: hr_utility.raise_error;
2484: END IF;
2485:
2486: /* Bug#5132121 Service Obligation for Student Loan and MD/DDS */

Line 2483: hr_utility.raise_error;

2479: --Bug 5527363
2480: IF p_pa_request_rec.noa_family_code = 'CONV_APP' AND p_within_grade_incr.p_date_wgi_due IS NOT NULL
2481: AND p_within_grade_incr.p_last_equi_incr IS NULL THEN
2482: hr_utility.set_message(8301,'GHR_37740_CONV_APP_NULL_DLEI');
2483: hr_utility.raise_error;
2484: END IF;
2485:
2486: /* Bug#5132121 Service Obligation for Student Loan and MD/DDS */
2487: IF p_pa_request_rec.first_noa_code IN ('817', '850', '480') OR

Line 2496: hr_utility.set_message(8301,

2492: l_serv_oblg_start_date := l_cur_service_oblg_ei.srvc_oblg_st_date;
2493: l_serv_oblg_end_date := l_cur_service_oblg_ei.srvc_oblg_end_date;
2494: IF l_serv_oblg_type IS NOT NULL AND
2495: (l_serv_oblg_start_date IS NULL OR l_serv_oblg_end_date IS NULL) THEN
2496: hr_utility.set_message(8301,
2497: 'GHR_38454_SRVC_OBLG_TYPE_CHK');
2498: hr_utility.raise_error;
2499: END IF;
2500:

Line 2498: hr_utility.raise_error;

2494: IF l_serv_oblg_type IS NOT NULL AND
2495: (l_serv_oblg_start_date IS NULL OR l_serv_oblg_end_date IS NULL) THEN
2496: hr_utility.set_message(8301,
2497: 'GHR_38454_SRVC_OBLG_TYPE_CHK');
2498: hr_utility.raise_error;
2499: END IF;
2500:
2501: IF l_serv_oblg_start_date IS NOT NULL AND
2502: (l_serv_oblg_end_date IS NULL OR l_serv_oblg_type IS NULL) THEN

Line 2503: hr_utility.set_message(8301,

2499: END IF;
2500:
2501: IF l_serv_oblg_start_date IS NOT NULL AND
2502: (l_serv_oblg_end_date IS NULL OR l_serv_oblg_type IS NULL) THEN
2503: hr_utility.set_message(8301,
2504: 'GHR_38455_SRVC_OBLG_ST_DT_CHK');
2505: hr_utility.raise_error;
2506: END IF;
2507: END LOOP;

Line 2505: hr_utility.raise_error;

2501: IF l_serv_oblg_start_date IS NOT NULL AND
2502: (l_serv_oblg_end_date IS NULL OR l_serv_oblg_type IS NULL) THEN
2503: hr_utility.set_message(8301,
2504: 'GHR_38455_SRVC_OBLG_ST_DT_CHK');
2505: hr_utility.raise_error;
2506: END IF;
2507: END LOOP;
2508: END IF;
2509: /* Bug#5132121 Service Obligation for Student Loan and MD/DDS */

Line 2515: hr_utility.set_location('Tsp SCD check '||p_pa_request_rec.first_noa_code , 11);

2511: --Bug# 14368933 removed NOAs 280,292,293,781,882
2512: IF (p_pa_request_rec.first_noa_code IN ('280','292','293','781','882') OR SUBSTR(p_pa_request_rec.first_noa_code,1,1) IN ('1','5')) OR
2513: ((p_pa_request_rec.second_noa_code IN ('280','292','293','781','882') OR SUBSTR(p_pa_request_rec.second_noa_code,1,1) IN ('1','5')) AND
2514: p_pa_request_rec.first_noa_code IN ('002')) THEN
2515: hr_utility.set_location('Tsp SCD check '||p_pa_request_rec.first_noa_code , 11);
2516: FOR l_get_tsp_scd IN c_get_tsp_scd LOOP
2517: l_tsp_scd := l_get_tsp_scd.tsp_scd;
2518: END LOOP;
2519: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR

Line 2522: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');

2518: END LOOP;
2519: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2520: IF nvl(p_pa_request_rec.retirement_plan,'@') IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') THEN
2521: IF l_tsp_scd IS NULL THEN
2522: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');
2523: hr_utility.raise_error;
2524: END IF;
2525: END IF;
2526: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR

Line 2523: hr_utility.raise_error;

2519: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2520: IF nvl(p_pa_request_rec.retirement_plan,'@') IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') THEN
2521: IF l_tsp_scd IS NULL THEN
2522: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');
2523: hr_utility.raise_error;
2524: END IF;
2525: END IF;
2526: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2527: IF p_pa_request_rec.retirement_plan IS NOT NULL AND p_pa_request_rec.retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR')

Line 2530: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');

2526: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2527: IF p_pa_request_rec.retirement_plan IS NOT NULL AND p_pa_request_rec.retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR')
2528: AND l_tsp_scd IS NOT NULL THEN
2529: IF NOT(p_pa_request_rec.retirement_plan = '4' AND NVL(p_pa_request_rec.annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN --Bug# 11808857
2530: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');
2531: hr_utility.raise_error;
2532: END IF;
2533: END IF;
2534: END IF;

Line 2531: hr_utility.raise_error;

2527: IF p_pa_request_rec.retirement_plan IS NOT NULL AND p_pa_request_rec.retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR')
2528: AND l_tsp_scd IS NOT NULL THEN
2529: IF NOT(p_pa_request_rec.retirement_plan = '4' AND NVL(p_pa_request_rec.annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN --Bug# 11808857
2530: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');
2531: hr_utility.raise_error;
2532: END IF;
2533: END IF;
2534: END IF;
2535: --End Bug# 12557463

Line 2539: hr_utility.set_location('Tsp SCD check for NOA '||p_pa_request_rec.first_noa_code , 11);

2535: --End Bug# 12557463
2536: --Begin Bug# 14769681
2537: IF p_pa_request_rec.first_noa_code IN ('803') OR
2538: (p_pa_request_rec.second_noa_code IN ('803') AND p_pa_request_rec.first_noa_code IN ('002')) THEN
2539: hr_utility.set_location('Tsp SCD check for NOA '||p_pa_request_rec.first_noa_code , 11);
2540: FOR l_get_tsp_scd IN c_get_tsp_scd_803 LOOP
2541: l_tsp_scd := l_get_tsp_scd.tsp_scd;
2542: END LOOP;
2543: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR

Line 2546: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');

2542: END LOOP;
2543: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2544: IF nvl(p_pa_request_rec.retirement_plan,'@') IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') THEN
2545: IF l_tsp_scd IS NULL THEN
2546: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');
2547: hr_utility.raise_error;
2548: END IF;
2549: END IF;
2550: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR

Line 2547: hr_utility.raise_error;

2543: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2544: IF nvl(p_pa_request_rec.retirement_plan,'@') IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') THEN
2545: IF l_tsp_scd IS NULL THEN
2546: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');
2547: hr_utility.raise_error;
2548: END IF;
2549: END IF;
2550: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2551: IF p_pa_request_rec.retirement_plan IS NOT NULL AND p_pa_request_rec.retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR')

Line 2554: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');

2550: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2551: IF p_pa_request_rec.retirement_plan IS NOT NULL AND p_pa_request_rec.retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR')
2552: AND l_tsp_scd IS NOT NULL THEN
2553: IF NOT(p_pa_request_rec.retirement_plan = '4' AND NVL(p_pa_request_rec.annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN
2554: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');
2555: hr_utility.raise_error;
2556: END IF;
2557: END IF;
2558: END IF;

Line 2555: hr_utility.raise_error;

2551: IF p_pa_request_rec.retirement_plan IS NOT NULL AND p_pa_request_rec.retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR')
2552: AND l_tsp_scd IS NOT NULL THEN
2553: IF NOT(p_pa_request_rec.retirement_plan = '4' AND NVL(p_pa_request_rec.annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN
2554: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');
2555: hr_utility.raise_error;
2556: END IF;
2557: END IF;
2558: END IF;
2559: --End Bug# 14769681

Line 2562: hr_utility.set_location('Fehb Elig Exp Date '||p_pa_request_rec.first_noa_code , 11);

2558: END IF;
2559: --End Bug# 14769681
2560: --Begin Bug 12637350
2561: IF p_pa_request_rec.noa_family_code IN ('APP','CONV_APP','EXT_NTE') THEN
2562: hr_utility.set_location('Fehb Elig Exp Date '||p_pa_request_rec.first_noa_code , 11);
2563: FOR c_detail_first_nte_date_rec in c_detail_first_nte_date LOOP
2564: l_noa_nte_date := fnd_date.canonical_to_date(c_detail_first_nte_date_rec.first_noa_information1);
2565: END LOOP;
2566: FOR c_cur_fehb_elg_exp_date in cur_fehb_elg_exp_date LOOP

Line 2579: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');

2575: end loop;
2576: END IF;
2577: --Bug# 14686129 removed equal condition not to trigger error for 365 days
2578: IF l_noa_nte_date < l_asg_start_date AND l_fehb_elig_exp_date IS NOT NULL THEN
2579: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
2580: hr_utility.raise_error;
2581: END IF;
2582: END IF;
2583: --End Bug 12637350

Line 2580: hr_utility.raise_error;

2576: END IF;
2577: --Bug# 14686129 removed equal condition not to trigger error for 365 days
2578: IF l_noa_nte_date < l_asg_start_date AND l_fehb_elig_exp_date IS NOT NULL THEN
2579: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
2580: hr_utility.raise_error;
2581: END IF;
2582: END IF;
2583: --End Bug 12637350
2584: end Validate_CHECK;

Line 2652: hr_utility.set_location('PAYROLL User -- BSR -- from asgid-- ', 1);

2648: ----
2649:
2650: IF (p_element_name = 'Basic Salary Rate'
2651: and (fnd_profile.value('HR_USER_TYPE') = 'INT')) THEN
2652: hr_utility.set_location('PAYROLL User -- BSR -- from asgid-- ', 1);
2653: l_new_element_name :=
2654: pqp_fedhr_uspay_int_utils.return_new_element_name(
2655: p_assignment_id => p_assignment_id,
2656: p_business_group_id => ll_bg_id,

Line 2660: hr_utility.set_location('HR USER or PAYROLL User without BSR element -- from elt name -- ', 1);

2656: p_business_group_id => ll_bg_id,
2657: p_effective_date => ll_effective_date);
2658: ELSIF (fnd_profile.value('HR_USER_TYPE') <> 'INT'
2659: or (p_element_name <> 'Basic Salary Rate' and (fnd_profile.value('HR_USER_TYPE') = 'INT'))) THEN
2660: hr_utility.set_location('HR USER or PAYROLL User without BSR element -- from elt name -- ', 1);
2661: l_new_element_name :=
2662: pqp_fedhr_uspay_int_utils.return_new_element_name(
2663: p_fedhr_element_name => p_element_name,
2664: p_business_group_id => ll_bg_id,