43: END IF;
44:
45: /*Bug fix- 4570879 added an additional check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN')*/
46: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN') THEN
47: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
48: fnd_message.set_token('NAME',l_field, translate => true );
49: hr_utility.raise_error;
50: END IF;
51:
44:
45: /*Bug fix- 4570879 added an additional check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN')*/
46: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN') THEN
47: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
48: fnd_message.set_token('NAME',l_field, translate => true );
49: hr_utility.raise_error;
50: END IF;
51:
52: END;
342:
343:
344: /* BUG FIX 4103631 */
345: if length(p_org_information1) <> 9 then
346: fnd_message.set_name('PER','HR_376828_NO_INVALID_ORG_NUM');
347: fnd_message.raise_error;
348: end if;
349: /* BUG FIX 4103631 */
350:
343:
344: /* BUG FIX 4103631 */
345: if length(p_org_information1) <> 9 then
346: fnd_message.set_name('PER','HR_376828_NO_INVALID_ORG_NUM');
347: fnd_message.raise_error;
348: end if;
349: /* BUG FIX 4103631 */
350:
351: open orgnum(s_effective_date);
362: IF l_org_information1 = p_org_information1 THEN
363: IF (l_organization_id = l_org_id) and (l_org_info_type_code <> p_org_info_type_code) then
364: null;
365: ELSE
366: fnd_message.set_name('PER','HR_376805_NO_ORG_NUMBER_UNIQUE');
367: fnd_message.raise_error;
368: END IF;
369: END IF;
370: end loop;
363: IF (l_organization_id = l_org_id) and (l_org_info_type_code <> p_org_info_type_code) then
364: null;
365: ELSE
366: fnd_message.set_name('PER','HR_376805_NO_ORG_NUMBER_UNIQUE');
367: fnd_message.raise_error;
368: END IF;
369: END IF;
370: end loop;
371: close orgnum;
372: ELSIF p_org_info_type_code = 'NO_LOCAL_UNITS' THEN
373: open orglocalunit(s_effective_date);
374: fetch orglocalunit into l_org_information1;
375: IF orglocalunit%FOUND THEN
376: fnd_message.set_name('PER','HR_376806_NO_LOCAL_UNIT_MSG');
377: fnd_message.raise_error;
378: END IF;
379: close orglocalunit;
380:
373: open orglocalunit(s_effective_date);
374: fetch orglocalunit into l_org_information1;
375: IF orglocalunit%FOUND THEN
376: fnd_message.set_name('PER','HR_376806_NO_LOCAL_UNIT_MSG');
377: fnd_message.raise_error;
378: END IF;
379: close orglocalunit;
380:
381:
390:
391: -- checking if start date is greater than the end date
392: IF (l_curr_start_date > l_curr_end_date )
393: THEN
394: fnd_message.set_name('PAY','PAY_376859_NO_DATE_EARLY');
395: fnd_message.raise_error;
396:
397: ELSE
398:
391: -- checking if start date is greater than the end date
392: IF (l_curr_start_date > l_curr_end_date )
393: THEN
394: fnd_message.set_name('PAY','PAY_376859_NO_DATE_EARLY');
395: fnd_message.raise_error;
396:
397: ELSE
398:
399: -- commenting the validation below to allow exemption limit/economic aid to be entered for overlapping periods
410: (l_start_date BETWEEN l_curr_start_date AND l_curr_end_date ) OR
411: (l_end_date BETWEEN l_curr_start_date AND l_curr_end_date )
412:
413: THEN
414: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
415: --fnd_message.set_token('START_DATE',l_curr_start_date);
416: --fnd_message.set_token('END_DATE',l_curr_end_date);
417: fnd_message.raise_error;
418: EXIT ;
411: (l_end_date BETWEEN l_curr_start_date AND l_curr_end_date )
412:
413: THEN
414: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
415: --fnd_message.set_token('START_DATE',l_curr_start_date);
416: --fnd_message.set_token('END_DATE',l_curr_end_date);
417: fnd_message.raise_error;
418: EXIT ;
419: END IF;
412:
413: THEN
414: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
415: --fnd_message.set_token('START_DATE',l_curr_start_date);
416: --fnd_message.set_token('END_DATE',l_curr_end_date);
417: fnd_message.raise_error;
418: EXIT ;
419: END IF;
420:
413: THEN
414: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
415: --fnd_message.set_token('START_DATE',l_curr_start_date);
416: --fnd_message.set_token('END_DATE',l_curr_end_date);
417: fnd_message.raise_error;
418: EXIT ;
419: END IF;
420:
421: END LOOP;
429: (mod(to_number(to_char(l_curr_end_date,'MM')),2) <> 0)
430: THEN
431:
432: -- raise error message
433: fnd_message.set_name('PAY','PAY_376860_NO_DATE_BIMONTH');
434: fnd_message.raise_error;
435:
436: END IF;
437:
430: THEN
431:
432: -- raise error message
433: fnd_message.set_name('PAY','PAY_376860_NO_DATE_BIMONTH');
434: fnd_message.raise_error;
435:
436: END IF;
437:
438: END IF;
454: CLOSE csr_repoting_span;
455: --
456: IF l_overlap_status = 'Y' THEN
457: --
458: fnd_message.set_name(801,'PAY_376893_NO_YEAR_EXISTS');
459: fnd_message.set_token('REP_CODE',p_org_information3);
460: fnd_message.raise_error;
461: --
462: END IF;
455: --
456: IF l_overlap_status = 'Y' THEN
457: --
458: fnd_message.set_name(801,'PAY_376893_NO_YEAR_EXISTS');
459: fnd_message.set_token('REP_CODE',p_org_information3);
460: fnd_message.raise_error;
461: --
462: END IF;
463: --
456: IF l_overlap_status = 'Y' THEN
457: --
458: fnd_message.set_name(801,'PAY_376893_NO_YEAR_EXISTS');
459: fnd_message.set_token('REP_CODE',p_org_information3);
460: fnd_message.raise_error;
461: --
462: END IF;
463: --
464: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
462: END IF;
463: --
464: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
465: --
466: fnd_message.set_name(801,'PAY_376892_NO_BALANCE_MISSING');
467: fnd_message.raise_error;
468: --
469: END IF;
470: --
463: --
464: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
465: --
466: fnd_message.set_name(801,'PAY_376892_NO_BALANCE_MISSING');
467: fnd_message.raise_error;
468: --
469: END IF;
470: --
471: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
469: END IF;
470: --
471: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
472: --
473: fnd_message.set_name(801,'PAY_376889_NO_ELEMENT_MISSING');
474: fnd_message.raise_error;
475: --
476: END IF;
477: --
470: --
471: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
472: --
473: fnd_message.set_name(801,'PAY_376889_NO_ELEMENT_MISSING');
474: fnd_message.raise_error;
475: --
476: END IF;
477: --
478: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
476: END IF;
477: --
478: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
479: --
480: fnd_message.set_name(801,'PAY_376890_NO_PROCEDURE_ABSENT');
481: fnd_message.raise_error;
482: --
483: END IF;
484: --
477: --
478: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
479: --
480: fnd_message.set_name(801,'PAY_376890_NO_PROCEDURE_ABSENT');
481: fnd_message.raise_error;
482: --
483: END IF;
484: --
485: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
483: END IF;
484: --
485: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
486: --
487: fnd_message.set_name(801,'PAY_376891_NO_SUMMATION_PROC');
488: fnd_message.raise_error;
489: --
490: END IF;
491: --
484: --
485: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
486: --
487: fnd_message.set_name(801,'PAY_376891_NO_SUMMATION_PROC');
488: fnd_message.raise_error;
489: --
490: END IF;
491: --
492: END IF;
501:
502:
503: IF(NVL(p_org_information3,'N') = 'N'
504: AND(p_org_information4 IS NOT NULL OR p_org_information5 IS NOT NULL)) THEN
505: fnd_message.set_name('PER', 'HR_376899_NO_HOL_PAY_OVER_60');
506: fnd_message.RAISE_ERROR;
507: END IF;
508:
509: IF(NVL(p_org_information3,'N') = 'Y'
502:
503: IF(NVL(p_org_information3,'N') = 'N'
504: AND(p_org_information4 IS NOT NULL OR p_org_information5 IS NOT NULL)) THEN
505: fnd_message.set_name('PER', 'HR_376899_NO_HOL_PAY_OVER_60');
506: fnd_message.RAISE_ERROR;
507: END IF;
508:
509: IF(NVL(p_org_information3,'N') = 'Y'
510: AND p_org_information4 IS NULL) THEN
508:
509: IF(NVL(p_org_information3,'N') = 'Y'
510: AND p_org_information4 IS NULL) THEN
511: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
512: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
513: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
514: fnd_message.RAISE_ERROR;
515: END IF;
516:
509: IF(NVL(p_org_information3,'N') = 'Y'
510: AND p_org_information4 IS NULL) THEN
511: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
512: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
513: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
514: fnd_message.RAISE_ERROR;
515: END IF;
516:
517: IF(NVL(p_org_information3,'N') = 'Y'
510: AND p_org_information4 IS NULL) THEN
511: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
512: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
513: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
514: fnd_message.RAISE_ERROR;
515: END IF;
516:
517: IF(NVL(p_org_information3,'N') = 'Y'
518: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
516:
517: IF(NVL(p_org_information3,'N') = 'Y'
518: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
519: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
520: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
521: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
522: fnd_message.RAISE_ERROR;
523: END IF;
524:
517: IF(NVL(p_org_information3,'N') = 'Y'
518: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
519: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
520: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
521: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
522: fnd_message.RAISE_ERROR;
523: END IF;
524:
525:
518: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
519: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
520: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
521: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
522: fnd_message.RAISE_ERROR;
523: END IF;
524:
525:
526: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y' ) THEN
523: END IF;
524:
525:
526: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y' ) THEN
527: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
528: fnd_message.RAISE_ERROR;
529: END IF ;
530:
531: ELSIF p_org_info_type_code = 'NO_ABSENCE_PAYMENT_DETAILS' THEN
524:
525:
526: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y' ) THEN
527: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
528: fnd_message.RAISE_ERROR;
529: END IF ;
530:
531: ELSIF p_org_info_type_code = 'NO_ABSENCE_PAYMENT_DETAILS' THEN
532:
535: INTO l_pay_to_be_adjusted;
536: CLOSE csr_pay_to_be_adjusted;
537:
538: IF (NVL(p_org_information5,'S') = 'H' AND l_pay_to_be_adjusted.pay_to_be_adjusted = 'Y') THEN
539: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
540: fnd_message.RAISE_ERROR;
541: END IF ;
542: END IF;
543: /*Pgopal - Bug 5341353 fix - End*/
536: CLOSE csr_pay_to_be_adjusted;
537:
538: IF (NVL(p_org_information5,'S') = 'H' AND l_pay_to_be_adjusted.pay_to_be_adjusted = 'Y') THEN
539: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
540: fnd_message.RAISE_ERROR;
541: END IF ;
542: END IF;
543: /*Pgopal - Bug 5341353 fix - End*/
544:
545: /*Pgopal - Bug 5341353 fix - End*/
546: -- Pension Validation Bug 6153601 , Bug 6166346----
547: IF p_org_info_type_code = 'NO_PENSION_PROVIDER' THEN
548: IF p_org_information8 > p_org_information9 THEN
549: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
550: fnd_message.RAISE_ERROR;
551: END IF;
552: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
553: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
546: -- Pension Validation Bug 6153601 , Bug 6166346----
547: IF p_org_info_type_code = 'NO_PENSION_PROVIDER' THEN
548: IF p_org_information8 > p_org_information9 THEN
549: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
550: fnd_message.RAISE_ERROR;
551: END IF;
552: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
553: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
554: fnd_message.RAISE_ERROR;
549: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
550: fnd_message.RAISE_ERROR;
551: END IF;
552: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
553: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
554: fnd_message.RAISE_ERROR;
555: END IF;
556: OPEN csr_pension_type_provider_chk;
557: LOOP
550: fnd_message.RAISE_ERROR;
551: END IF;
552: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
553: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
554: fnd_message.RAISE_ERROR;
555: END IF;
556: OPEN csr_pension_type_provider_chk;
557: LOOP
558: FETCH csr_pension_type_provider_chk INTO l_csr_pension_provider_chk;
557: LOOP
558: FETCH csr_pension_type_provider_chk INTO l_csr_pension_provider_chk;
559: EXIT WHEN csr_pension_type_provider_chk%NOTFOUND;
560: CLOSE csr_pension_type_provider_chk;
561: fnd_message.set_name('PER','PER_376922_NO_PEN_PRV_UNIQUE');
562: fnd_message.RAISE_ERROR;
563: END LOOP;
564: CLOSE csr_pension_type_provider_chk;
565:
558: FETCH csr_pension_type_provider_chk INTO l_csr_pension_provider_chk;
559: EXIT WHEN csr_pension_type_provider_chk%NOTFOUND;
560: CLOSE csr_pension_type_provider_chk;
561: fnd_message.set_name('PER','PER_376922_NO_PEN_PRV_UNIQUE');
562: fnd_message.RAISE_ERROR;
563: END LOOP;
564: CLOSE csr_pension_type_provider_chk;
565:
566: END IF;
567:
568:
569: IF p_org_info_type_code = 'NO_PENSION_DETAILS' THEN
570: IF to_number(p_org_information2) < 0 THEN
571: fnd_message.set_name('PER','PER_376923_NO_PEN_ORG_NUM');
572: fnd_message.RAISE_ERROR;
573: END IF;
574:
575: OPEN csr_pension_type_chk;
568:
569: IF p_org_info_type_code = 'NO_PENSION_DETAILS' THEN
570: IF to_number(p_org_information2) < 0 THEN
571: fnd_message.set_name('PER','PER_376923_NO_PEN_ORG_NUM');
572: fnd_message.RAISE_ERROR;
573: END IF;
574:
575: OPEN csr_pension_type_chk;
576: LOOP
577: FETCH csr_pension_type_chk INTO l_csr_pension_type_record;
578: EXIT WHEN csr_pension_type_chk%NOTFOUND;
579: IF l_csr_pension_type_record.pension_types = p_org_information1 then
580: CLOSE csr_pension_type_chk;
581: fnd_message.set_name('PER','PER_376924_NO_PEN_TYPE_DUP');
582: fnd_message.RAISE_ERROR;
583: End IF;
584: END LOOP;
585: CLOSE csr_pension_type_chk;
578: EXIT WHEN csr_pension_type_chk%NOTFOUND;
579: IF l_csr_pension_type_record.pension_types = p_org_information1 then
580: CLOSE csr_pension_type_chk;
581: fnd_message.set_name('PER','PER_376924_NO_PEN_TYPE_DUP');
582: fnd_message.RAISE_ERROR;
583: End IF;
584: END LOOP;
585: CLOSE csr_pension_type_chk;
586:
589: FETCH csr_org_number_chk INTO l_csr_org_number_record;
590: EXIT WHEN csr_org_number_chk%NOTFOUND;
591: IF l_csr_org_number_record.org_number <> p_org_information2 then
592: CLOSE csr_org_number_chk;
593: fnd_message.set_name('PER','PER_376925_NO_PEN_TYPE_ORG');
594: fnd_message.RAISE_ERROR;
595: End IF;
596: END LOOP;
597: CLOSE csr_org_number_chk;
590: EXIT WHEN csr_org_number_chk%NOTFOUND;
591: IF l_csr_org_number_record.org_number <> p_org_information2 then
592: CLOSE csr_org_number_chk;
593: fnd_message.set_name('PER','PER_376925_NO_PEN_TYPE_ORG');
594: fnd_message.RAISE_ERROR;
595: End IF;
596: END LOOP;
597: CLOSE csr_org_number_chk;
598: END IF;
816: IF p_org_info_type_code = 'NO_LOCAL_UNIT_DETAILS' OR p_org_info_type_code = 'NO_LEGAL_EMPLOYER_DETAILS' THEN
817:
818: /* BUG FIX 4103631 */
819: if length(p_org_information1) <> 9 then
820: fnd_message.set_name('PER','HR_376828_NO_INVALID_ORG_NUM');
821: fnd_message.raise_error;
822: end if;
823: /* BUG FIX 4103631 */
824:
817:
818: /* BUG FIX 4103631 */
819: if length(p_org_information1) <> 9 then
820: fnd_message.set_name('PER','HR_376828_NO_INVALID_ORG_NUM');
821: fnd_message.raise_error;
822: end if;
823: /* BUG FIX 4103631 */
824:
825:
845: NULL ;
846: -- Bug Fix 5370311 End
847:
848: ELSE
849: fnd_message.set_name('PER','HR_376805_NO_ORG_NUMBER_UNIQUE');
850: fnd_message.raise_error;
851: END IF;
852: END IF;
853: end loop;
846: -- Bug Fix 5370311 End
847:
848: ELSE
849: fnd_message.set_name('PER','HR_376805_NO_ORG_NUMBER_UNIQUE');
850: fnd_message.raise_error;
851: END IF;
852: END IF;
853: end loop;
854: close orgnum;
855: ELSIF p_org_info_type_code = 'NO_LOCAL_UNITS' THEN
856: open orglocalunit (s_effective_date);
857: fetch orglocalunit into l_org_information1;
858: IF orglocalunit%FOUND THEN
859: fnd_message.set_name('PER','HR_376806_NO_LOCAL_UNIT_MSG');
860: fnd_message.raise_error;
861: END IF;
862: close orglocalunit;
863:
856: open orglocalunit (s_effective_date);
857: fetch orglocalunit into l_org_information1;
858: IF orglocalunit%FOUND THEN
859: fnd_message.set_name('PER','HR_376806_NO_LOCAL_UNIT_MSG');
860: fnd_message.raise_error;
861: END IF;
862: close orglocalunit;
863:
864:
872:
873: -- checking if start date is greater than the end date
874: IF (l_curr_start_date > l_curr_end_date )
875: THEN
876: fnd_message.set_name('PAY','PAY_376859_NO_DATE_EARLY');
877: fnd_message.raise_error;
878:
879: ELSE
880:
873: -- checking if start date is greater than the end date
874: IF (l_curr_start_date > l_curr_end_date )
875: THEN
876: fnd_message.set_name('PAY','PAY_376859_NO_DATE_EARLY');
877: fnd_message.raise_error;
878:
879: ELSE
880:
881: -- commenting the validation below to allow exemption limit/economic aid to be entered for overlapping periods
892: (l_start_date BETWEEN l_curr_start_date AND l_curr_end_date ) OR
893: (l_end_date BETWEEN l_curr_start_date AND l_curr_end_date )
894:
895: THEN
896: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
897: --fnd_message.set_token('START_DATE',l_curr_start_date);
898: --fnd_message.set_token('END_DATE',l_curr_end_date);
899: fnd_message.raise_error;
900: EXIT ;
893: (l_end_date BETWEEN l_curr_start_date AND l_curr_end_date )
894:
895: THEN
896: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
897: --fnd_message.set_token('START_DATE',l_curr_start_date);
898: --fnd_message.set_token('END_DATE',l_curr_end_date);
899: fnd_message.raise_error;
900: EXIT ;
901: END IF;
894:
895: THEN
896: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
897: --fnd_message.set_token('START_DATE',l_curr_start_date);
898: --fnd_message.set_token('END_DATE',l_curr_end_date);
899: fnd_message.raise_error;
900: EXIT ;
901: END IF;
902:
895: THEN
896: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
897: --fnd_message.set_token('START_DATE',l_curr_start_date);
898: --fnd_message.set_token('END_DATE',l_curr_end_date);
899: fnd_message.raise_error;
900: EXIT ;
901: END IF;
902:
903: END LOOP;
911: (mod(to_number(to_char(l_curr_end_date,'MM')),2) <> 0)
912: THEN
913:
914: -- raise error message
915: fnd_message.set_name('PAY','PAY_376860_NO_DATE_BIMONTH');
916: fnd_message.raise_error;
917:
918: END IF;
919:
912: THEN
913:
914: -- raise error message
915: fnd_message.set_name('PAY','PAY_376860_NO_DATE_BIMONTH');
916: fnd_message.raise_error;
917:
918: END IF;
919:
920: END IF;
937: CLOSE csr_repoting_span;
938: --
939: IF l_overlap_status = 'Y' THEN
940: --
941: fnd_message.set_name(801,'PAY_376883_NO_YEAR_EXISTS');
942: fnd_message.set_token('REP_CODE',p_org_information3);
943: fnd_message.raise_error;
944: --
945: END IF;
938: --
939: IF l_overlap_status = 'Y' THEN
940: --
941: fnd_message.set_name(801,'PAY_376883_NO_YEAR_EXISTS');
942: fnd_message.set_token('REP_CODE',p_org_information3);
943: fnd_message.raise_error;
944: --
945: END IF;
946: --
939: IF l_overlap_status = 'Y' THEN
940: --
941: fnd_message.set_name(801,'PAY_376883_NO_YEAR_EXISTS');
942: fnd_message.set_token('REP_CODE',p_org_information3);
943: fnd_message.raise_error;
944: --
945: END IF;
946: --
947: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
945: END IF;
946: --
947: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
948: --
949: fnd_message.set_name(801,'PAY_376892_NO_BALANCE_MISSING');
950: fnd_message.raise_error;
951: --
952: END IF;
953: --
946: --
947: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
948: --
949: fnd_message.set_name(801,'PAY_376892_NO_BALANCE_MISSING');
950: fnd_message.raise_error;
951: --
952: END IF;
953: --
954: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
952: END IF;
953: --
954: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
955: --
956: fnd_message.set_name(801,'PAY_376889_NO_ELEMENT_MISSING');
957: fnd_message.raise_error;
958: --
959: END IF;
960: --
953: --
954: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
955: --
956: fnd_message.set_name(801,'PAY_376889_NO_ELEMENT_MISSING');
957: fnd_message.raise_error;
958: --
959: END IF;
960: --
961: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
959: END IF;
960: --
961: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
962: --
963: fnd_message.set_name(801,'PAY_376890_NO_PROCEDURE_ABSENT');
964: fnd_message.raise_error;
965: --
966: END IF;
967: --
960: --
961: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
962: --
963: fnd_message.set_name(801,'PAY_376890_NO_PROCEDURE_ABSENT');
964: fnd_message.raise_error;
965: --
966: END IF;
967: --
968: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
966: END IF;
967: --
968: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
969: --
970: fnd_message.set_name(801,'PAY_376891_NO_SUMMATION_PROC');
971: fnd_message.raise_error;
972: --
973: END IF;
974: --
967: --
968: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
969: --
970: fnd_message.set_name(801,'PAY_376891_NO_SUMMATION_PROC');
971: fnd_message.raise_error;
972: --
973: END IF;
974: --
975: END IF;
985:
986:
987: IF(NVL(p_org_information3,'N') = 'N'
988: AND(p_org_information4 IS NOT NULL OR p_org_information5 IS NOT NULL)) THEN
989: fnd_message.set_name('PER', 'HR_376899_NO_HOL_PAY_OVER_60');
990: fnd_message.RAISE_ERROR;
991: END IF;
992:
993: IF(NVL(p_org_information3,'N') = 'Y'
986:
987: IF(NVL(p_org_information3,'N') = 'N'
988: AND(p_org_information4 IS NOT NULL OR p_org_information5 IS NOT NULL)) THEN
989: fnd_message.set_name('PER', 'HR_376899_NO_HOL_PAY_OVER_60');
990: fnd_message.RAISE_ERROR;
991: END IF;
992:
993: IF(NVL(p_org_information3,'N') = 'Y'
994: AND p_org_information4 IS NULL) THEN
992:
993: IF(NVL(p_org_information3,'N') = 'Y'
994: AND p_org_information4 IS NULL) THEN
995: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
996: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
997: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
998: fnd_message.RAISE_ERROR;
999: END IF;
1000:
993: IF(NVL(p_org_information3,'N') = 'Y'
994: AND p_org_information4 IS NULL) THEN
995: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
996: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
997: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
998: fnd_message.RAISE_ERROR;
999: END IF;
1000:
1001: IF(NVL(p_org_information3,'N') = 'Y'
994: AND p_org_information4 IS NULL) THEN
995: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
996: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
997: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
998: fnd_message.RAISE_ERROR;
999: END IF;
1000:
1001: IF(NVL(p_org_information3,'N') = 'Y'
1002: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1000:
1001: IF(NVL(p_org_information3,'N') = 'Y'
1002: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1003: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
1004: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1005: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1006: fnd_message.RAISE_ERROR;
1007:
1008: END IF;
1001: IF(NVL(p_org_information3,'N') = 'Y'
1002: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1003: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
1004: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1005: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1006: fnd_message.RAISE_ERROR;
1007:
1008: END IF;
1009:
1002: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1003: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
1004: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1005: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1006: fnd_message.RAISE_ERROR;
1007:
1008: END IF;
1009:
1010:
1008: END IF;
1009:
1010:
1011: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y') THEN
1012: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
1013: fnd_message.RAISE_ERROR;
1014: END IF ;
1015:
1016: ELSIF p_org_info_type_code = 'NO_ABSENCE_PAYMENT_DETAILS' THEN
1009:
1010:
1011: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y') THEN
1012: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
1013: fnd_message.RAISE_ERROR;
1014: END IF ;
1015:
1016: ELSIF p_org_info_type_code = 'NO_ABSENCE_PAYMENT_DETAILS' THEN
1017:
1020: INTO l_pay_to_be_adjusted;
1021: CLOSE csr_pay_to_be_adjusted;
1022:
1023: IF (NVL(p_org_information5,'S') = 'H' AND l_pay_to_be_adjusted.pay_to_be_adjusted = 'Y') THEN
1024: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
1025: fnd_message.RAISE_ERROR;
1026: END IF ;
1027:
1028: END IF;
1021: CLOSE csr_pay_to_be_adjusted;
1022:
1023: IF (NVL(p_org_information5,'S') = 'H' AND l_pay_to_be_adjusted.pay_to_be_adjusted = 'Y') THEN
1024: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
1025: fnd_message.RAISE_ERROR;
1026: END IF ;
1027:
1028: END IF;
1029: /*Pgopal - Bug 5341353 fix - End*/
1030:
1031: -- Pension Validation Bug 6153601 , Bug 6166346----
1032: IF p_org_info_type_code = 'NO_PENSION_PROVIDER' THEN
1033: IF p_org_information8 > p_org_information9 THEN
1034: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
1035: fnd_message.RAISE_ERROR;
1036: END IF;
1037: OPEN csr_pension_provider_date_chk;
1038: LOOP
1031: -- Pension Validation Bug 6153601 , Bug 6166346----
1032: IF p_org_info_type_code = 'NO_PENSION_PROVIDER' THEN
1033: IF p_org_information8 > p_org_information9 THEN
1034: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
1035: fnd_message.RAISE_ERROR;
1036: END IF;
1037: OPEN csr_pension_provider_date_chk;
1038: LOOP
1039: FETCH csr_pension_provider_date_chk INTO l_csr_pen_prov_date_chk;
1039: FETCH csr_pension_provider_date_chk INTO l_csr_pen_prov_date_chk;
1040: EXIT WHEN csr_pension_provider_date_chk%NOTFOUND;
1041: IF fnd_date.canonical_to_date(l_csr_pen_prov_date_chk.org_information1) > fnd_date.canonical_to_date(l_csr_pen_prov_date_chk.org_information2) THEN
1042: CLOSE csr_pension_provider_date_chk;
1043: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
1044: fnd_message.RAISE_ERROR;
1045: END IF;
1046: END LOOP;
1047: CLOSE csr_pension_provider_date_chk;
1040: EXIT WHEN csr_pension_provider_date_chk%NOTFOUND;
1041: IF fnd_date.canonical_to_date(l_csr_pen_prov_date_chk.org_information1) > fnd_date.canonical_to_date(l_csr_pen_prov_date_chk.org_information2) THEN
1042: CLOSE csr_pension_provider_date_chk;
1043: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
1044: fnd_message.RAISE_ERROR;
1045: END IF;
1046: END LOOP;
1047: CLOSE csr_pension_provider_date_chk;
1048:
1051: FETCH csr_pension_type_provider_chk INTO l_csr_pension_provider_chk;
1052: EXIT WHEN csr_pension_type_provider_chk%NOTFOUND;
1053: IF l_csr_pension_provider_chk.org_information_id <> p_org_information_id THEN
1054: CLOSE csr_pension_type_provider_chk;
1055: fnd_message.set_name('PER','PER_376922_NO_PEN_PRV_UNIQUE');
1056: fnd_message.RAISE_ERROR;
1057: END IF;
1058: END LOOP;
1059: CLOSE csr_pension_type_provider_chk;
1052: EXIT WHEN csr_pension_type_provider_chk%NOTFOUND;
1053: IF l_csr_pension_provider_chk.org_information_id <> p_org_information_id THEN
1054: CLOSE csr_pension_type_provider_chk;
1055: fnd_message.set_name('PER','PER_376922_NO_PEN_PRV_UNIQUE');
1056: fnd_message.RAISE_ERROR;
1057: END IF;
1058: END LOOP;
1059: CLOSE csr_pension_type_provider_chk;
1060: END IF;
1059: CLOSE csr_pension_type_provider_chk;
1060: END IF;
1061: IF p_org_info_type_code = 'NO_PENSION_DETAILS' THEN
1062: IF to_number(p_org_information2) < 0 THEN
1063: fnd_message.set_name('PER','PER_376923_NO_PEN_ORG_NUM');
1064: fnd_message.RAISE_ERROR;
1065: END IF;
1066:
1067: OPEN csr_pension_type_chk;
1060: END IF;
1061: IF p_org_info_type_code = 'NO_PENSION_DETAILS' THEN
1062: IF to_number(p_org_information2) < 0 THEN
1063: fnd_message.set_name('PER','PER_376923_NO_PEN_ORG_NUM');
1064: fnd_message.RAISE_ERROR;
1065: END IF;
1066:
1067: OPEN csr_pension_type_chk;
1068: LOOP
1069: FETCH csr_pension_type_chk INTO l_csr_pension_type_record;
1070: EXIT WHEN csr_pension_type_chk%NOTFOUND;
1071: IF l_csr_pension_type_record.pension_types = p_org_information1 then
1072: CLOSE csr_pension_type_chk;
1073: fnd_message.set_name('PER','PER_376924_NO_PEN_TYPE_DUP');
1074: fnd_message.RAISE_ERROR;
1075: End IF;
1076: END LOOP;
1077: CLOSE csr_pension_type_chk;
1070: EXIT WHEN csr_pension_type_chk%NOTFOUND;
1071: IF l_csr_pension_type_record.pension_types = p_org_information1 then
1072: CLOSE csr_pension_type_chk;
1073: fnd_message.set_name('PER','PER_376924_NO_PEN_TYPE_DUP');
1074: fnd_message.RAISE_ERROR;
1075: End IF;
1076: END LOOP;
1077: CLOSE csr_pension_type_chk;
1078:
1081: FETCH csr_org_number_chk INTO l_csr_org_number_record;
1082: EXIT WHEN csr_org_number_chk%NOTFOUND;
1083: IF l_csr_org_number_record.org_number <> p_org_information2 then
1084: CLOSE csr_org_number_chk;
1085: fnd_message.set_name('PER','PER_376925_NO_PEN_TYPE_ORG');
1086: fnd_message.RAISE_ERROR;
1087: End IF;
1088: END LOOP;
1089: CLOSE csr_org_number_chk;
1082: EXIT WHEN csr_org_number_chk%NOTFOUND;
1083: IF l_csr_org_number_record.org_number <> p_org_information2 then
1084: CLOSE csr_org_number_chk;
1085: fnd_message.set_name('PER','PER_376925_NO_PEN_TYPE_ORG');
1086: fnd_message.RAISE_ERROR;
1087: End IF;
1088: END LOOP;
1089: CLOSE csr_org_number_chk;
1090: END IF;
1116: where qualification_type_id = p_qualification_type_id;
1117:
1118:
1119: if p_qua_information1 <> l_nus2000_code then
1120: fnd_message.set_name('PER', 'HR_376822_NO_NUS2000_MISMATCH');
1121: hr_utility.raise_error;
1122: end if;
1123:
1124:
1131: and pq.person_id = p_person_id
1132: and pq.qua_information_category='NO'
1133: and pq.qua_information2='Y';
1134: IF l_count > 0 then
1135: fnd_message.set_name('PER', 'HR_376812_NO_HIGHEST_LEVEL');
1136: hr_utility.raise_error;
1137: END IF;
1138: END IF ;
1139: END IF;
1176: FETCH c_information1 INTO l_nus2000_code ;
1177: CLOSE c_information1;
1178:
1179: if p_qua_information1 <> l_nus2000_code then
1180: fnd_message.set_name('PER', 'HR_376822_NO_NUS2000_MISMATCH');
1181: hr_utility.raise_error;
1182: end if;
1183:
1184:
1198: and pq.qua_information_category='NO'
1199: and pq.qua_information2='Y';
1200:
1201: IF l_count > 0 then
1202: fnd_message.set_name('PER', 'HR_376812_NO_HIGHEST_LEVEL');
1203: hr_utility.raise_error;
1204: END IF;
1205:
1206: END IF;
1245: fetch orgtype into l_int_ext_flag;
1246: close orgtype;
1247:
1248: if l_int_ext_flag='INT' then
1249: fnd_message.set_name('PER','HR_376818_NO_SOC_SEC');
1250: fnd_message.raise_error;
1251: end if;
1252:
1253: END IF;
1246: close orgtype;
1247:
1248: if l_int_ext_flag='INT' then
1249: fnd_message.set_name('PER','HR_376818_NO_SOC_SEC');
1250: fnd_message.raise_error;
1251: end if;
1252:
1253: END IF;
1254: END IF;
1276: IF (p_ctr_information1 IS NOT NULL AND p_ctr_information_category ='NO') THEN
1277:
1278: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
1279: --
1280: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1281: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1282: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1283: hr_utility.raise_error;
1284: --
1277:
1278: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
1279: --
1280: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1281: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1282: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1283: hr_utility.raise_error;
1284: --
1285: END IF;
1278: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
1279: --
1280: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1281: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1282: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1283: hr_utility.raise_error;
1284: --
1285: END IF;
1286: END IF;
1310: l_active_start_date := hr_contract_api.get_active_start_date (p_contract_id,p_effective_date,p_status);
1311:
1312: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
1313: --
1314: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1315: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1316: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1317: hr_utility.raise_error;
1318: --
1311:
1312: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
1313: --
1314: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1315: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1316: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1317: hr_utility.raise_error;
1318: --
1319: END IF;
1312: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
1313: --
1314: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1315: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1316: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1317: hr_utility.raise_error;
1318: --
1319: END IF;
1320: END IF;
1344: IF (p_inc_information1 IS NOT NULL AND p_inc_information_category ='NO' )THEN
1345: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)
1346: THEN
1347: --
1348: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1349: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));
1350: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1351: hr_utility.raise_error;
1352: --
1345: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)
1346: THEN
1347: --
1348: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1349: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));
1350: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1351: hr_utility.raise_error;
1352: --
1353: END IF;
1346: THEN
1347: --
1348: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1349: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));
1350: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1351: hr_utility.raise_error;
1352: --
1353: END IF;
1354: END IF;
1356: IF (p_inc_information2 IS NOT NULL AND p_inc_information_category ='NO') THEN
1357: IF (fnd_date.canonical_to_date(p_inc_information2) < p_incident_date)
1358: THEN
1359: --
1360: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1361: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));
1362: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1363: hr_utility.raise_error;
1364: --
1357: IF (fnd_date.canonical_to_date(p_inc_information2) < p_incident_date)
1358: THEN
1359: --
1360: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1361: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));
1362: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1363: hr_utility.raise_error;
1364: --
1365: END IF;
1358: THEN
1359: --
1360: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1361: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));
1362: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1363: hr_utility.raise_error;
1364: --
1365: END IF;
1366: END IF;
1406:
1407: --GSI Bug 4584922
1408: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
1409: IF(l_age > p_scl_segment14 ) THEN
1410: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1411: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1412: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1413: hr_utility.raise_error;
1414:
1407: --GSI Bug 4584922
1408: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
1409: IF(l_age > p_scl_segment14 ) THEN
1410: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1411: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1412: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1413: hr_utility.raise_error;
1414:
1415: END IF;
1408: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
1409: IF(l_age > p_scl_segment14 ) THEN
1410: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1411: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1412: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1413: hr_utility.raise_error;
1414:
1415: END IF;
1416: END IF;
1417:
1418: --GSI Bug 4584922
1419: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
1420: IF( p_scl_segment12
1422: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1423: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1424: hr_utility.raise_error;
1425: END IF;
1418: --GSI Bug 4584922
1419: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
1420: IF( p_scl_segment12
1422: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1423: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1424: hr_utility.raise_error;
1425: END IF;
1426: END IF;
1419: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
1420: IF( p_scl_segment12
1422: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1423: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1424: hr_utility.raise_error;
1425: END IF;
1426: END IF;
1427:
1427:
1428: --GSI Bug 4584922
1429: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
1430: IF( p_scl_segment13
1432: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1433: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1434: hr_utility.raise_error;
1435: END IF;
1428: --GSI Bug 4584922
1429: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
1430: IF( p_scl_segment13
1432: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1433: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1434: hr_utility.raise_error;
1435: END IF;
1436: END IF;
1429: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
1430: IF( p_scl_segment13
1432: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1433: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1434: hr_utility.raise_error;
1435: END IF;
1436: END IF;
1437: END IF;
1474:
1475: --GSI Bug 4584922
1476: IF(p_segment14 <> hr_api.g_varchar2) THEN
1477: IF(l_age > p_segment14 ) THEN
1478: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1479: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1480: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1481: hr_utility.raise_error;
1482:
1475: --GSI Bug 4584922
1476: IF(p_segment14 <> hr_api.g_varchar2) THEN
1477: IF(l_age > p_segment14 ) THEN
1478: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1479: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1480: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1481: hr_utility.raise_error;
1482:
1483: END IF;
1476: IF(p_segment14 <> hr_api.g_varchar2) THEN
1477: IF(l_age > p_segment14 ) THEN
1478: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1479: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1480: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1481: hr_utility.raise_error;
1482:
1483: END IF;
1484: END IF;
1485:
1486: --GSI Bug 4584922
1487: IF(p_segment12 <> hr_api.g_varchar2) THEN
1488: IF( p_segment12
1490: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1491: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1492: hr_utility.raise_error;
1493: END IF;
1486: --GSI Bug 4584922
1487: IF(p_segment12 <> hr_api.g_varchar2) THEN
1488: IF( p_segment12
1490: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1491: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1492: hr_utility.raise_error;
1493: END IF;
1494: END IF;
1487: IF(p_segment12 <> hr_api.g_varchar2) THEN
1488: IF( p_segment12
1490: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1491: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1492: hr_utility.raise_error;
1493: END IF;
1494: END IF;
1495:
1495:
1496: --GSI Bug 4584922
1497: IF(p_segment13 <> hr_api.g_varchar2) THEN
1498: IF( p_segment13
1500: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1501: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1502: hr_utility.raise_error;
1503: END IF;
1496: --GSI Bug 4584922
1497: IF(p_segment13 <> hr_api.g_varchar2) THEN
1498: IF( p_segment13
1500: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1501: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1502: hr_utility.raise_error;
1503: END IF;
1504: END IF;
1497: IF(p_segment13 <> hr_api.g_varchar2) THEN
1498: IF( p_segment13
1500: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1501: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1502: hr_utility.raise_error;
1503: END IF;
1504: END IF;
1505: END IF;
1608: CLOSE csr_chk_element_eit_year;
1609: --
1610: IF (l_year_status = 'Y') THEN
1611: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');
1612: fnd_message.set_token('REP_CODE',l_overlap_code); --p_eei_information3);
1613: hr_utility.raise_error;
1614: END IF;
1615: --
1616: -- Validation to check if single input value is mapped to more than one column in Extra Element Info DDF
1675: CLOSE csr_get_le_details;
1676:
1677: IF( p_eei_information2 = rec_get_ele_code.eei_information2) THEN
1678: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1679: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1680: fnd_message.set_token('LE',rec_get_le_details.name);
1681: hr_utility.raise_error;
1682: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1683: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1676:
1677: IF( p_eei_information2 = rec_get_ele_code.eei_information2) THEN
1678: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1679: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1680: fnd_message.set_token('LE',rec_get_le_details.name);
1681: hr_utility.raise_error;
1682: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1683: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1684: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1680: fnd_message.set_token('LE',rec_get_le_details.name);
1681: hr_utility.raise_error;
1682: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1683: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1684: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1685: fnd_message.set_token('LE',rec_get_le_details.name);
1686: hr_utility.raise_error;
1687: END IF;
1688: END IF;
1681: hr_utility.raise_error;
1682: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1683: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1684: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1685: fnd_message.set_token('LE',rec_get_le_details.name);
1686: hr_utility.raise_error;
1687: END IF;
1688: END IF;
1689:
1830: CLOSE csr_chk_element_eit_year;
1831: --
1832: IF (l_year_status = 'Y') THEN
1833: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');
1834: fnd_message.set_token('REP_CODE', l_overlap_code); --p_eei_information3);
1835: hr_utility.raise_error;
1836: END IF;
1837: --
1838: -- Validation to check if single input value is mapped to more than one column in Extra Element Info DDF
1905: FETCH csr_get_le_details INTO rec_get_le_details;
1906: CLOSE csr_get_le_details;
1907:
1908: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1909: --fnd_message.set_token('LE',rec_get_ele_code_le_glob.eei_information2);
1910: fnd_message.set_token('LE',rec_get_le_details.name);
1911: hr_utility.raise_error;
1912: END IF;
1913:
1906: CLOSE csr_get_le_details;
1907:
1908: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1909: --fnd_message.set_token('LE',rec_get_ele_code_le_glob.eei_information2);
1910: fnd_message.set_token('LE',rec_get_le_details.name);
1911: hr_utility.raise_error;
1912: END IF;
1913:
1914: