[Home] [Help]
47: END IF;
48:
49: /*Bug fix- 4570879 added an additional check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN')*/
50: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN') THEN
51: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
52: fnd_message.set_token('NAME',l_field, translate => true );
53: hr_utility.raise_error;
54: END IF;
55:
48:
49: /*Bug fix- 4570879 added an additional check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN')*/
50: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN') THEN
51: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
52: fnd_message.set_token('NAME',l_field, translate => true );
53: hr_utility.raise_error;
54: END IF;
55:
56: END;
346:
347:
348: /* BUG FIX 4103631 */
349: if length(p_org_information1) <> 9 then
350: fnd_message.set_name('PER','HR_376828_NO_INVALID_ORG_NUM');
351: fnd_message.raise_error;
352: end if;
353: /* BUG FIX 4103631 */
354:
347:
348: /* BUG FIX 4103631 */
349: if length(p_org_information1) <> 9 then
350: fnd_message.set_name('PER','HR_376828_NO_INVALID_ORG_NUM');
351: fnd_message.raise_error;
352: end if;
353: /* BUG FIX 4103631 */
354:
355: open orgnum(s_effective_date);
366: IF l_org_information1 = p_org_information1 THEN
367: IF (l_organization_id = l_org_id) and (l_org_info_type_code <> p_org_info_type_code) then
368: null;
369: ELSE
370: fnd_message.set_name('PER','HR_376805_NO_ORG_NUMBER_UNIQUE');
371: fnd_message.raise_error;
372: END IF;
373: END IF;
374: end loop;
367: IF (l_organization_id = l_org_id) and (l_org_info_type_code <> p_org_info_type_code) then
368: null;
369: ELSE
370: fnd_message.set_name('PER','HR_376805_NO_ORG_NUMBER_UNIQUE');
371: fnd_message.raise_error;
372: END IF;
373: END IF;
374: end loop;
375: close orgnum;
376: ELSIF p_org_info_type_code = 'NO_LOCAL_UNITS' THEN
377: open orglocalunit(s_effective_date);
378: fetch orglocalunit into l_org_information1;
379: IF orglocalunit%FOUND THEN
380: fnd_message.set_name('PER','HR_376806_NO_LOCAL_UNIT_MSG');
381: fnd_message.raise_error;
382: END IF;
383: close orglocalunit;
384:
377: open orglocalunit(s_effective_date);
378: fetch orglocalunit into l_org_information1;
379: IF orglocalunit%FOUND THEN
380: fnd_message.set_name('PER','HR_376806_NO_LOCAL_UNIT_MSG');
381: fnd_message.raise_error;
382: END IF;
383: close orglocalunit;
384:
385:
394:
395: -- checking if start date is greater than the end date
396: IF (l_curr_start_date > l_curr_end_date )
397: THEN
398: fnd_message.set_name('PAY','PAY_376859_NO_DATE_EARLY');
399: fnd_message.raise_error;
400:
401: ELSE
402:
395: -- checking if start date is greater than the end date
396: IF (l_curr_start_date > l_curr_end_date )
397: THEN
398: fnd_message.set_name('PAY','PAY_376859_NO_DATE_EARLY');
399: fnd_message.raise_error;
400:
401: ELSE
402:
403: -- commenting the validation below to allow exemption limit/economic aid to be entered for overlapping periods
414: (l_start_date BETWEEN l_curr_start_date AND l_curr_end_date ) OR
415: (l_end_date BETWEEN l_curr_start_date AND l_curr_end_date )
416:
417: THEN
418: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
419: --fnd_message.set_token('START_DATE',l_curr_start_date);
420: --fnd_message.set_token('END_DATE',l_curr_end_date);
421: fnd_message.raise_error;
422: EXIT ;
415: (l_end_date BETWEEN l_curr_start_date AND l_curr_end_date )
416:
417: THEN
418: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
419: --fnd_message.set_token('START_DATE',l_curr_start_date);
420: --fnd_message.set_token('END_DATE',l_curr_end_date);
421: fnd_message.raise_error;
422: EXIT ;
423: END IF;
416:
417: THEN
418: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
419: --fnd_message.set_token('START_DATE',l_curr_start_date);
420: --fnd_message.set_token('END_DATE',l_curr_end_date);
421: fnd_message.raise_error;
422: EXIT ;
423: END IF;
424:
417: THEN
418: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
419: --fnd_message.set_token('START_DATE',l_curr_start_date);
420: --fnd_message.set_token('END_DATE',l_curr_end_date);
421: fnd_message.raise_error;
422: EXIT ;
423: END IF;
424:
425: END LOOP;
433: (mod(to_number(to_char(l_curr_end_date,'MM')),2) <> 0)
434: THEN
435:
436: -- raise error message
437: fnd_message.set_name('PAY','PAY_376860_NO_DATE_BIMONTH');
438: fnd_message.raise_error;
439:
440: END IF;
441:
434: THEN
435:
436: -- raise error message
437: fnd_message.set_name('PAY','PAY_376860_NO_DATE_BIMONTH');
438: fnd_message.raise_error;
439:
440: END IF;
441:
442: END IF;
458: CLOSE csr_repoting_span;
459: --
460: IF l_overlap_status = 'Y' THEN
461: --
462: fnd_message.set_name(801,'PAY_376893_NO_YEAR_EXISTS');
463: fnd_message.set_token('REP_CODE',p_org_information3);
464: fnd_message.raise_error;
465: --
466: END IF;
459: --
460: IF l_overlap_status = 'Y' THEN
461: --
462: fnd_message.set_name(801,'PAY_376893_NO_YEAR_EXISTS');
463: fnd_message.set_token('REP_CODE',p_org_information3);
464: fnd_message.raise_error;
465: --
466: END IF;
467: --
460: IF l_overlap_status = 'Y' THEN
461: --
462: fnd_message.set_name(801,'PAY_376893_NO_YEAR_EXISTS');
463: fnd_message.set_token('REP_CODE',p_org_information3);
464: fnd_message.raise_error;
465: --
466: END IF;
467: --
468: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
466: END IF;
467: --
468: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
469: --
470: fnd_message.set_name(801,'PAY_376892_NO_BALANCE_MISSING');
471: fnd_message.raise_error;
472: --
473: END IF;
474: --
467: --
468: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
469: --
470: fnd_message.set_name(801,'PAY_376892_NO_BALANCE_MISSING');
471: fnd_message.raise_error;
472: --
473: END IF;
474: --
475: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
473: END IF;
474: --
475: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
476: --
477: fnd_message.set_name(801,'PAY_376889_NO_ELEMENT_MISSING');
478: fnd_message.raise_error;
479: --
480: END IF;
481: --
474: --
475: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
476: --
477: fnd_message.set_name(801,'PAY_376889_NO_ELEMENT_MISSING');
478: fnd_message.raise_error;
479: --
480: END IF;
481: --
482: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
480: END IF;
481: --
482: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
483: --
484: fnd_message.set_name(801,'PAY_376890_NO_PROCEDURE_ABSENT');
485: fnd_message.raise_error;
486: --
487: END IF;
488: --
481: --
482: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
483: --
484: fnd_message.set_name(801,'PAY_376890_NO_PROCEDURE_ABSENT');
485: fnd_message.raise_error;
486: --
487: END IF;
488: --
489: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
487: END IF;
488: --
489: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
490: --
491: fnd_message.set_name(801,'PAY_376891_NO_SUMMATION_PROC');
492: fnd_message.raise_error;
493: --
494: END IF;
495: --
488: --
489: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
490: --
491: fnd_message.set_name(801,'PAY_376891_NO_SUMMATION_PROC');
492: fnd_message.raise_error;
493: --
494: END IF;
495: --
496: END IF;
505:
506:
507: IF(NVL(p_org_information3,'N') = 'N'
508: AND(p_org_information4 IS NOT NULL OR p_org_information5 IS NOT NULL)) THEN
509: fnd_message.set_name('PER', 'HR_376899_NO_HOL_PAY_OVER_60');
510: fnd_message.RAISE_ERROR;
511: END IF;
512:
513: IF(NVL(p_org_information3,'N') = 'Y'
506:
507: IF(NVL(p_org_information3,'N') = 'N'
508: AND(p_org_information4 IS NOT NULL OR p_org_information5 IS NOT NULL)) THEN
509: fnd_message.set_name('PER', 'HR_376899_NO_HOL_PAY_OVER_60');
510: fnd_message.RAISE_ERROR;
511: END IF;
512:
513: IF(NVL(p_org_information3,'N') = 'Y'
514: AND p_org_information4 IS NULL) THEN
512:
513: IF(NVL(p_org_information3,'N') = 'Y'
514: AND p_org_information4 IS NULL) THEN
515: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
516: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
517: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
518: fnd_message.RAISE_ERROR;
519: END IF;
520:
513: IF(NVL(p_org_information3,'N') = 'Y'
514: AND p_org_information4 IS NULL) THEN
515: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
516: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
517: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
518: fnd_message.RAISE_ERROR;
519: END IF;
520:
521: IF(NVL(p_org_information3,'N') = 'Y'
514: AND p_org_information4 IS NULL) THEN
515: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
516: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
517: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
518: fnd_message.RAISE_ERROR;
519: END IF;
520:
521: IF(NVL(p_org_information3,'N') = 'Y'
522: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
520:
521: IF(NVL(p_org_information3,'N') = 'Y'
522: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
523: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
524: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
525: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
526: fnd_message.RAISE_ERROR;
527: END IF;
528:
521: IF(NVL(p_org_information3,'N') = 'Y'
522: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
523: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
524: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
525: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
526: fnd_message.RAISE_ERROR;
527: END IF;
528:
529:
522: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
523: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
524: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
525: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
526: fnd_message.RAISE_ERROR;
527: END IF;
528:
529:
530: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y' ) THEN
527: END IF;
528:
529:
530: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y' ) THEN
531: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
532: fnd_message.RAISE_ERROR;
533: END IF ;
534:
535: ELSIF p_org_info_type_code = 'NO_ABSENCE_PAYMENT_DETAILS' THEN
528:
529:
530: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y' ) THEN
531: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
532: fnd_message.RAISE_ERROR;
533: END IF ;
534:
535: ELSIF p_org_info_type_code = 'NO_ABSENCE_PAYMENT_DETAILS' THEN
536:
539: INTO l_pay_to_be_adjusted;
540: CLOSE csr_pay_to_be_adjusted;
541:
542: IF (NVL(p_org_information5,'S') = 'H' AND l_pay_to_be_adjusted.pay_to_be_adjusted = 'Y') THEN
543: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
544: fnd_message.RAISE_ERROR;
545: END IF ;
546: END IF;
547: /*Pgopal - Bug 5341353 fix - End*/
540: CLOSE csr_pay_to_be_adjusted;
541:
542: IF (NVL(p_org_information5,'S') = 'H' AND l_pay_to_be_adjusted.pay_to_be_adjusted = 'Y') THEN
543: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
544: fnd_message.RAISE_ERROR;
545: END IF ;
546: END IF;
547: /*Pgopal - Bug 5341353 fix - End*/
548:
549: /*Pgopal - Bug 5341353 fix - End*/
550: -- Pension Validation Bug 6153601 , Bug 6166346----
551: IF p_org_info_type_code = 'NO_PENSION_PROVIDER' THEN
552: IF p_org_information8 > p_org_information9 THEN
553: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
554: fnd_message.RAISE_ERROR;
555: END IF;
556: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
557: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
550: -- Pension Validation Bug 6153601 , Bug 6166346----
551: IF p_org_info_type_code = 'NO_PENSION_PROVIDER' THEN
552: IF p_org_information8 > p_org_information9 THEN
553: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
554: fnd_message.RAISE_ERROR;
555: END IF;
556: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
557: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
558: fnd_message.RAISE_ERROR;
553: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
554: fnd_message.RAISE_ERROR;
555: END IF;
556: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
557: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
558: fnd_message.RAISE_ERROR;
559: END IF;
560: OPEN csr_pension_type_provider_chk;
561: LOOP
554: fnd_message.RAISE_ERROR;
555: END IF;
556: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
557: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
558: fnd_message.RAISE_ERROR;
559: END IF;
560: OPEN csr_pension_type_provider_chk;
561: LOOP
562: FETCH csr_pension_type_provider_chk INTO l_csr_pension_provider_chk;
561: LOOP
562: FETCH csr_pension_type_provider_chk INTO l_csr_pension_provider_chk;
563: EXIT WHEN csr_pension_type_provider_chk%NOTFOUND;
564: CLOSE csr_pension_type_provider_chk;
565: fnd_message.set_name('PER','PER_376922_NO_PEN_PRV_UNIQUE');
566: fnd_message.RAISE_ERROR;
567: END LOOP;
568: CLOSE csr_pension_type_provider_chk;
569:
562: FETCH csr_pension_type_provider_chk INTO l_csr_pension_provider_chk;
563: EXIT WHEN csr_pension_type_provider_chk%NOTFOUND;
564: CLOSE csr_pension_type_provider_chk;
565: fnd_message.set_name('PER','PER_376922_NO_PEN_PRV_UNIQUE');
566: fnd_message.RAISE_ERROR;
567: END LOOP;
568: CLOSE csr_pension_type_provider_chk;
569:
570: END IF;
571:
572:
573: IF p_org_info_type_code = 'NO_PENSION_DETAILS' THEN
574: IF to_number(p_org_information2) < 0 THEN
575: fnd_message.set_name('PER','PER_376923_NO_PEN_ORG_NUM');
576: fnd_message.RAISE_ERROR;
577: END IF;
578:
579: OPEN csr_pension_type_chk;
572:
573: IF p_org_info_type_code = 'NO_PENSION_DETAILS' THEN
574: IF to_number(p_org_information2) < 0 THEN
575: fnd_message.set_name('PER','PER_376923_NO_PEN_ORG_NUM');
576: fnd_message.RAISE_ERROR;
577: END IF;
578:
579: OPEN csr_pension_type_chk;
580: LOOP
581: FETCH csr_pension_type_chk INTO l_csr_pension_type_record;
582: EXIT WHEN csr_pension_type_chk%NOTFOUND;
583: IF l_csr_pension_type_record.pension_types = p_org_information1 then
584: CLOSE csr_pension_type_chk;
585: fnd_message.set_name('PER','PER_376924_NO_PEN_TYPE_DUP');
586: fnd_message.RAISE_ERROR;
587: End IF;
588: END LOOP;
589: CLOSE csr_pension_type_chk;
582: EXIT WHEN csr_pension_type_chk%NOTFOUND;
583: IF l_csr_pension_type_record.pension_types = p_org_information1 then
584: CLOSE csr_pension_type_chk;
585: fnd_message.set_name('PER','PER_376924_NO_PEN_TYPE_DUP');
586: fnd_message.RAISE_ERROR;
587: End IF;
588: END LOOP;
589: CLOSE csr_pension_type_chk;
590:
593: FETCH csr_org_number_chk INTO l_csr_org_number_record;
594: EXIT WHEN csr_org_number_chk%NOTFOUND;
595: IF l_csr_org_number_record.org_number <> p_org_information2 then
596: CLOSE csr_org_number_chk;
597: fnd_message.set_name('PER','PER_376925_NO_PEN_TYPE_ORG');
598: fnd_message.RAISE_ERROR;
599: End IF;
600: END LOOP;
601: CLOSE csr_org_number_chk;
594: EXIT WHEN csr_org_number_chk%NOTFOUND;
595: IF l_csr_org_number_record.org_number <> p_org_information2 then
596: CLOSE csr_org_number_chk;
597: fnd_message.set_name('PER','PER_376925_NO_PEN_TYPE_ORG');
598: fnd_message.RAISE_ERROR;
599: End IF;
600: END LOOP;
601: CLOSE csr_org_number_chk;
602: END IF;
820: IF p_org_info_type_code = 'NO_LOCAL_UNIT_DETAILS' OR p_org_info_type_code = 'NO_LEGAL_EMPLOYER_DETAILS' THEN
821:
822: /* BUG FIX 4103631 */
823: if length(p_org_information1) <> 9 then
824: fnd_message.set_name('PER','HR_376828_NO_INVALID_ORG_NUM');
825: fnd_message.raise_error;
826: end if;
827: /* BUG FIX 4103631 */
828:
821:
822: /* BUG FIX 4103631 */
823: if length(p_org_information1) <> 9 then
824: fnd_message.set_name('PER','HR_376828_NO_INVALID_ORG_NUM');
825: fnd_message.raise_error;
826: end if;
827: /* BUG FIX 4103631 */
828:
829:
849: NULL ;
850: -- Bug Fix 5370311 End
851:
852: ELSE
853: fnd_message.set_name('PER','HR_376805_NO_ORG_NUMBER_UNIQUE');
854: fnd_message.raise_error;
855: END IF;
856: END IF;
857: end loop;
850: -- Bug Fix 5370311 End
851:
852: ELSE
853: fnd_message.set_name('PER','HR_376805_NO_ORG_NUMBER_UNIQUE');
854: fnd_message.raise_error;
855: END IF;
856: END IF;
857: end loop;
858: close orgnum;
859: ELSIF p_org_info_type_code = 'NO_LOCAL_UNITS' THEN
860: open orglocalunit (s_effective_date);
861: fetch orglocalunit into l_org_information1;
862: IF orglocalunit%FOUND THEN
863: fnd_message.set_name('PER','HR_376806_NO_LOCAL_UNIT_MSG');
864: fnd_message.raise_error;
865: END IF;
866: close orglocalunit;
867:
860: open orglocalunit (s_effective_date);
861: fetch orglocalunit into l_org_information1;
862: IF orglocalunit%FOUND THEN
863: fnd_message.set_name('PER','HR_376806_NO_LOCAL_UNIT_MSG');
864: fnd_message.raise_error;
865: END IF;
866: close orglocalunit;
867:
868:
876:
877: -- checking if start date is greater than the end date
878: IF (l_curr_start_date > l_curr_end_date )
879: THEN
880: fnd_message.set_name('PAY','PAY_376859_NO_DATE_EARLY');
881: fnd_message.raise_error;
882:
883: ELSE
884:
877: -- checking if start date is greater than the end date
878: IF (l_curr_start_date > l_curr_end_date )
879: THEN
880: fnd_message.set_name('PAY','PAY_376859_NO_DATE_EARLY');
881: fnd_message.raise_error;
882:
883: ELSE
884:
885: -- commenting the validation below to allow exemption limit/economic aid to be entered for overlapping periods
896: (l_start_date BETWEEN l_curr_start_date AND l_curr_end_date ) OR
897: (l_end_date BETWEEN l_curr_start_date AND l_curr_end_date )
898:
899: THEN
900: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
901: --fnd_message.set_token('START_DATE',l_curr_start_date);
902: --fnd_message.set_token('END_DATE',l_curr_end_date);
903: fnd_message.raise_error;
904: EXIT ;
897: (l_end_date BETWEEN l_curr_start_date AND l_curr_end_date )
898:
899: THEN
900: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
901: --fnd_message.set_token('START_DATE',l_curr_start_date);
902: --fnd_message.set_token('END_DATE',l_curr_end_date);
903: fnd_message.raise_error;
904: EXIT ;
905: END IF;
898:
899: THEN
900: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
901: --fnd_message.set_token('START_DATE',l_curr_start_date);
902: --fnd_message.set_token('END_DATE',l_curr_end_date);
903: fnd_message.raise_error;
904: EXIT ;
905: END IF;
906:
899: THEN
900: fnd_message.set_name('PAY','PAY_376858_NO_EXEM_LIMIT_ERR');
901: --fnd_message.set_token('START_DATE',l_curr_start_date);
902: --fnd_message.set_token('END_DATE',l_curr_end_date);
903: fnd_message.raise_error;
904: EXIT ;
905: END IF;
906:
907: END LOOP;
915: (mod(to_number(to_char(l_curr_end_date,'MM')),2) <> 0)
916: THEN
917:
918: -- raise error message
919: fnd_message.set_name('PAY','PAY_376860_NO_DATE_BIMONTH');
920: fnd_message.raise_error;
921:
922: END IF;
923:
916: THEN
917:
918: -- raise error message
919: fnd_message.set_name('PAY','PAY_376860_NO_DATE_BIMONTH');
920: fnd_message.raise_error;
921:
922: END IF;
923:
924: END IF;
941: CLOSE csr_repoting_span;
942: --
943: IF l_overlap_status = 'Y' THEN
944: --
945: fnd_message.set_name(801,'PAY_376883_NO_YEAR_EXISTS');
946: fnd_message.set_token('REP_CODE',p_org_information3);
947: fnd_message.raise_error;
948: --
949: END IF;
942: --
943: IF l_overlap_status = 'Y' THEN
944: --
945: fnd_message.set_name(801,'PAY_376883_NO_YEAR_EXISTS');
946: fnd_message.set_token('REP_CODE',p_org_information3);
947: fnd_message.raise_error;
948: --
949: END IF;
950: --
943: IF l_overlap_status = 'Y' THEN
944: --
945: fnd_message.set_name(801,'PAY_376883_NO_YEAR_EXISTS');
946: fnd_message.set_token('REP_CODE',p_org_information3);
947: fnd_message.raise_error;
948: --
949: END IF;
950: --
951: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
949: END IF;
950: --
951: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
952: --
953: fnd_message.set_name(801,'PAY_376892_NO_BALANCE_MISSING');
954: fnd_message.raise_error;
955: --
956: END IF;
957: --
950: --
951: IF p_org_information4 IN ('BAL','BAL_CODE_CTX') AND p_org_information5 IS NULL THEN
952: --
953: fnd_message.set_name(801,'PAY_376892_NO_BALANCE_MISSING');
954: fnd_message.raise_error;
955: --
956: END IF;
957: --
958: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
956: END IF;
957: --
958: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
959: --
960: fnd_message.set_name(801,'PAY_376889_NO_ELEMENT_MISSING');
961: fnd_message.raise_error;
962: --
963: END IF;
964: --
957: --
958: IF p_org_information4 = 'RRV_ELEMENT' AND p_org_information6 IS NULL THEN
959: --
960: fnd_message.set_name(801,'PAY_376889_NO_ELEMENT_MISSING');
961: fnd_message.raise_error;
962: --
963: END IF;
964: --
965: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
963: END IF;
964: --
965: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
966: --
967: fnd_message.set_name(801,'PAY_376890_NO_PROCEDURE_ABSENT');
968: fnd_message.raise_error;
969: --
970: END IF;
971: --
964: --
965: IF p_org_information4 = 'PROCEDURE' AND p_org_information7 IS NULL THEN
966: --
967: fnd_message.set_name(801,'PAY_376890_NO_PROCEDURE_ABSENT');
968: fnd_message.raise_error;
969: --
970: END IF;
971: --
972: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
970: END IF;
971: --
972: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
973: --
974: fnd_message.set_name(801,'PAY_376891_NO_SUMMATION_PROC');
975: fnd_message.raise_error;
976: --
977: END IF;
978: --
971: --
972: IF p_org_information14 = 'PROCEDURE' AND p_org_information15 IS NULL THEN
973: --
974: fnd_message.set_name(801,'PAY_376891_NO_SUMMATION_PROC');
975: fnd_message.raise_error;
976: --
977: END IF;
978: --
979: END IF;
989:
990:
991: IF(NVL(p_org_information3,'N') = 'N'
992: AND(p_org_information4 IS NOT NULL OR p_org_information5 IS NOT NULL)) THEN
993: fnd_message.set_name('PER', 'HR_376899_NO_HOL_PAY_OVER_60');
994: fnd_message.RAISE_ERROR;
995: END IF;
996:
997: IF(NVL(p_org_information3,'N') = 'Y'
990:
991: IF(NVL(p_org_information3,'N') = 'N'
992: AND(p_org_information4 IS NOT NULL OR p_org_information5 IS NOT NULL)) THEN
993: fnd_message.set_name('PER', 'HR_376899_NO_HOL_PAY_OVER_60');
994: fnd_message.RAISE_ERROR;
995: END IF;
996:
997: IF(NVL(p_org_information3,'N') = 'Y'
998: AND p_org_information4 IS NULL) THEN
996:
997: IF(NVL(p_org_information3,'N') = 'Y'
998: AND p_org_information4 IS NULL) THEN
999: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
1000: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1001: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1002: fnd_message.RAISE_ERROR;
1003: END IF;
1004:
997: IF(NVL(p_org_information3,'N') = 'Y'
998: AND p_org_information4 IS NULL) THEN
999: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
1000: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1001: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1002: fnd_message.RAISE_ERROR;
1003: END IF;
1004:
1005: IF(NVL(p_org_information3,'N') = 'Y'
998: AND p_org_information4 IS NULL) THEN
999: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
1000: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1001: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1002: fnd_message.RAISE_ERROR;
1003: END IF;
1004:
1005: IF(NVL(p_org_information3,'N') = 'Y'
1006: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1004:
1005: IF(NVL(p_org_information3,'N') = 'Y'
1006: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1007: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
1008: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1009: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1010: fnd_message.RAISE_ERROR;
1011:
1012: END IF;
1005: IF(NVL(p_org_information3,'N') = 'Y'
1006: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1007: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
1008: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1009: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1010: fnd_message.RAISE_ERROR;
1011:
1012: END IF;
1013:
1006: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1007: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
1008: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1009: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1010: fnd_message.RAISE_ERROR;
1011:
1012: END IF;
1013:
1014:
1012: END IF;
1013:
1014:
1015: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y') THEN
1016: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
1017: fnd_message.RAISE_ERROR;
1018: END IF ;
1019:
1020: ELSIF p_org_info_type_code = 'NO_ABSENCE_PAYMENT_DETAILS' THEN
1013:
1014:
1015: IF (NVL(l_hourly_salaried.hourly_salaried,'S') = 'H' AND p_org_information5 = 'Y') THEN
1016: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
1017: fnd_message.RAISE_ERROR;
1018: END IF ;
1019:
1020: ELSIF p_org_info_type_code = 'NO_ABSENCE_PAYMENT_DETAILS' THEN
1021:
1024: INTO l_pay_to_be_adjusted;
1025: CLOSE csr_pay_to_be_adjusted;
1026:
1027: IF (NVL(p_org_information5,'S') = 'H' AND l_pay_to_be_adjusted.pay_to_be_adjusted = 'Y') THEN
1028: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
1029: fnd_message.RAISE_ERROR;
1030: END IF ;
1031:
1032: END IF;
1025: CLOSE csr_pay_to_be_adjusted;
1026:
1027: IF (NVL(p_org_information5,'S') = 'H' AND l_pay_to_be_adjusted.pay_to_be_adjusted = 'Y') THEN
1028: fnd_message.set_name('PER', 'HR_376900_NO_HOL_PAY_TO_BE_ADJ');
1029: fnd_message.RAISE_ERROR;
1030: END IF ;
1031:
1032: END IF;
1033: /*Pgopal - Bug 5341353 fix - End*/
1034:
1035: -- Pension Validation Bug 6153601 , Bug 6166346----
1036: IF p_org_info_type_code = 'NO_PENSION_PROVIDER' THEN
1037: IF p_org_information8 > p_org_information9 THEN
1038: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
1039: fnd_message.RAISE_ERROR;
1040: END IF;
1041: OPEN csr_pension_provider_date_chk;
1042: LOOP
1035: -- Pension Validation Bug 6153601 , Bug 6166346----
1036: IF p_org_info_type_code = 'NO_PENSION_PROVIDER' THEN
1037: IF p_org_information8 > p_org_information9 THEN
1038: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
1039: fnd_message.RAISE_ERROR;
1040: END IF;
1041: OPEN csr_pension_provider_date_chk;
1042: LOOP
1043: FETCH csr_pension_provider_date_chk INTO l_csr_pen_prov_date_chk;
1043: FETCH csr_pension_provider_date_chk INTO l_csr_pen_prov_date_chk;
1044: EXIT WHEN csr_pension_provider_date_chk%NOTFOUND;
1045: 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
1046: CLOSE csr_pension_provider_date_chk;
1047: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
1048: fnd_message.RAISE_ERROR;
1049: END IF;
1050: END LOOP;
1051: CLOSE csr_pension_provider_date_chk;
1044: EXIT WHEN csr_pension_provider_date_chk%NOTFOUND;
1045: 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
1046: CLOSE csr_pension_provider_date_chk;
1047: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
1048: fnd_message.RAISE_ERROR;
1049: END IF;
1050: END LOOP;
1051: CLOSE csr_pension_provider_date_chk;
1052:
1055: FETCH csr_pension_type_provider_chk INTO l_csr_pension_provider_chk;
1056: EXIT WHEN csr_pension_type_provider_chk%NOTFOUND;
1057: IF l_csr_pension_provider_chk.org_information_id <> p_org_information_id THEN
1058: CLOSE csr_pension_type_provider_chk;
1059: fnd_message.set_name('PER','PER_376922_NO_PEN_PRV_UNIQUE');
1060: fnd_message.RAISE_ERROR;
1061: END IF;
1062: END LOOP;
1063: CLOSE csr_pension_type_provider_chk;
1056: EXIT WHEN csr_pension_type_provider_chk%NOTFOUND;
1057: IF l_csr_pension_provider_chk.org_information_id <> p_org_information_id THEN
1058: CLOSE csr_pension_type_provider_chk;
1059: fnd_message.set_name('PER','PER_376922_NO_PEN_PRV_UNIQUE');
1060: fnd_message.RAISE_ERROR;
1061: END IF;
1062: END LOOP;
1063: CLOSE csr_pension_type_provider_chk;
1064: END IF;
1063: CLOSE csr_pension_type_provider_chk;
1064: END IF;
1065: IF p_org_info_type_code = 'NO_PENSION_DETAILS' THEN
1066: IF to_number(p_org_information2) < 0 THEN
1067: fnd_message.set_name('PER','PER_376923_NO_PEN_ORG_NUM');
1068: fnd_message.RAISE_ERROR;
1069: END IF;
1070:
1071: OPEN csr_pension_type_chk;
1064: END IF;
1065: IF p_org_info_type_code = 'NO_PENSION_DETAILS' THEN
1066: IF to_number(p_org_information2) < 0 THEN
1067: fnd_message.set_name('PER','PER_376923_NO_PEN_ORG_NUM');
1068: fnd_message.RAISE_ERROR;
1069: END IF;
1070:
1071: OPEN csr_pension_type_chk;
1072: LOOP
1073: FETCH csr_pension_type_chk INTO l_csr_pension_type_record;
1074: EXIT WHEN csr_pension_type_chk%NOTFOUND;
1075: IF l_csr_pension_type_record.pension_types = p_org_information1 then
1076: CLOSE csr_pension_type_chk;
1077: fnd_message.set_name('PER','PER_376924_NO_PEN_TYPE_DUP');
1078: fnd_message.RAISE_ERROR;
1079: End IF;
1080: END LOOP;
1081: CLOSE csr_pension_type_chk;
1074: EXIT WHEN csr_pension_type_chk%NOTFOUND;
1075: IF l_csr_pension_type_record.pension_types = p_org_information1 then
1076: CLOSE csr_pension_type_chk;
1077: fnd_message.set_name('PER','PER_376924_NO_PEN_TYPE_DUP');
1078: fnd_message.RAISE_ERROR;
1079: End IF;
1080: END LOOP;
1081: CLOSE csr_pension_type_chk;
1082:
1085: FETCH csr_org_number_chk INTO l_csr_org_number_record;
1086: EXIT WHEN csr_org_number_chk%NOTFOUND;
1087: IF l_csr_org_number_record.org_number <> p_org_information2 then
1088: CLOSE csr_org_number_chk;
1089: fnd_message.set_name('PER','PER_376925_NO_PEN_TYPE_ORG');
1090: fnd_message.RAISE_ERROR;
1091: End IF;
1092: END LOOP;
1093: CLOSE csr_org_number_chk;
1086: EXIT WHEN csr_org_number_chk%NOTFOUND;
1087: IF l_csr_org_number_record.org_number <> p_org_information2 then
1088: CLOSE csr_org_number_chk;
1089: fnd_message.set_name('PER','PER_376925_NO_PEN_TYPE_ORG');
1090: fnd_message.RAISE_ERROR;
1091: End IF;
1092: END LOOP;
1093: CLOSE csr_org_number_chk;
1094: END IF;
1120: where qualification_type_id = p_qualification_type_id;
1121:
1122:
1123: if p_qua_information1 <> l_nus2000_code then
1124: fnd_message.set_name('PER', 'HR_376822_NO_NUS2000_MISMATCH');
1125: hr_utility.raise_error;
1126: end if;
1127:
1128:
1135: and pq.person_id = p_person_id
1136: and pq.qua_information_category='NO'
1137: and pq.qua_information2='Y';
1138: IF l_count > 0 then
1139: fnd_message.set_name('PER', 'HR_376812_NO_HIGHEST_LEVEL');
1140: hr_utility.raise_error;
1141: END IF;
1142: END IF ;
1143: END IF;
1180: FETCH c_information1 INTO l_nus2000_code ;
1181: CLOSE c_information1;
1182:
1183: if p_qua_information1 <> l_nus2000_code then
1184: fnd_message.set_name('PER', 'HR_376822_NO_NUS2000_MISMATCH');
1185: hr_utility.raise_error;
1186: end if;
1187:
1188:
1202: and pq.qua_information_category='NO'
1203: and pq.qua_information2='Y';
1204:
1205: IF l_count > 0 then
1206: fnd_message.set_name('PER', 'HR_376812_NO_HIGHEST_LEVEL');
1207: hr_utility.raise_error;
1208: END IF;
1209:
1210: END IF;
1249: fetch orgtype into l_int_ext_flag;
1250: close orgtype;
1251:
1252: if l_int_ext_flag='INT' then
1253: fnd_message.set_name('PER','HR_376818_NO_SOC_SEC');
1254: fnd_message.raise_error;
1255: end if;
1256:
1257: END IF;
1250: close orgtype;
1251:
1252: if l_int_ext_flag='INT' then
1253: fnd_message.set_name('PER','HR_376818_NO_SOC_SEC');
1254: fnd_message.raise_error;
1255: end if;
1256:
1257: END IF;
1258: END IF;
1280: IF (p_ctr_information1 IS NOT NULL AND p_ctr_information_category ='NO') THEN
1281:
1282: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
1283: --
1284: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1285: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1286: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1287: hr_utility.raise_error;
1288: --
1281:
1282: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
1283: --
1284: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1285: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1286: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1287: hr_utility.raise_error;
1288: --
1289: END IF;
1282: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
1283: --
1284: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1285: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1286: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1287: hr_utility.raise_error;
1288: --
1289: END IF;
1290: END IF;
1314: l_active_start_date := hr_contract_api.get_active_start_date (p_contract_id,p_effective_date,p_status);
1315:
1316: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
1317: --
1318: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1319: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1320: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1321: hr_utility.raise_error;
1322: --
1315:
1316: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
1317: --
1318: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1319: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1320: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1321: hr_utility.raise_error;
1322: --
1323: END IF;
1316: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
1317: --
1318: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1319: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1320: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1321: hr_utility.raise_error;
1322: --
1323: END IF;
1324: END IF;
1348: IF (p_inc_information1 IS NOT NULL AND p_inc_information_category ='NO' )THEN
1349: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)
1350: THEN
1351: --
1352: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1353: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));
1354: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1355: hr_utility.raise_error;
1356: --
1349: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)
1350: THEN
1351: --
1352: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1353: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));
1354: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1355: hr_utility.raise_error;
1356: --
1357: END IF;
1350: THEN
1351: --
1352: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1353: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));
1354: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1355: hr_utility.raise_error;
1356: --
1357: END IF;
1358: END IF;
1360: IF (p_inc_information2 IS NOT NULL AND p_inc_information_category ='NO') THEN
1361: IF (fnd_date.canonical_to_date(p_inc_information2) < p_incident_date)
1362: THEN
1363: --
1364: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1365: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));
1366: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1367: hr_utility.raise_error;
1368: --
1361: IF (fnd_date.canonical_to_date(p_inc_information2) < p_incident_date)
1362: THEN
1363: --
1364: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1365: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));
1366: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1367: hr_utility.raise_error;
1368: --
1369: END IF;
1362: THEN
1363: --
1364: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1365: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));
1366: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1367: hr_utility.raise_error;
1368: --
1369: END IF;
1370: END IF;
1410:
1411: --GSI Bug 4584922
1412: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
1413: IF(l_age > p_scl_segment14 ) THEN
1414: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1415: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1416: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1417: hr_utility.raise_error;
1418:
1411: --GSI Bug 4584922
1412: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
1413: IF(l_age > p_scl_segment14 ) THEN
1414: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1415: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1416: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1417: hr_utility.raise_error;
1418:
1419: END IF;
1412: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
1413: IF(l_age > p_scl_segment14 ) THEN
1414: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1415: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1416: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1417: hr_utility.raise_error;
1418:
1419: END IF;
1420: END IF;
1421:
1422: --GSI Bug 4584922
1423: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
1424: IF( p_scl_segment12
1426: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1427: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1428: hr_utility.raise_error;
1429: END IF;
1422: --GSI Bug 4584922
1423: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
1424: IF( p_scl_segment12
1426: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1427: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1428: hr_utility.raise_error;
1429: END IF;
1430: END IF;
1423: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
1424: IF( p_scl_segment12
1426: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1427: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1428: hr_utility.raise_error;
1429: END IF;
1430: END IF;
1431:
1431:
1432: --GSI Bug 4584922
1433: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
1434: IF( p_scl_segment13
1436: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1437: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1438: hr_utility.raise_error;
1439: END IF;
1432: --GSI Bug 4584922
1433: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
1434: IF( p_scl_segment13
1436: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1437: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1438: hr_utility.raise_error;
1439: END IF;
1440: END IF;
1433: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
1434: IF( p_scl_segment13
1436: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1437: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1438: hr_utility.raise_error;
1439: END IF;
1440: END IF;
1441: END IF;
1478:
1479: --GSI Bug 4584922
1480: IF(p_segment14 <> hr_api.g_varchar2) THEN
1481: IF(l_age > p_segment14 ) THEN
1482: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1483: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1484: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1485: hr_utility.raise_error;
1486:
1479: --GSI Bug 4584922
1480: IF(p_segment14 <> hr_api.g_varchar2) THEN
1481: IF(l_age > p_segment14 ) THEN
1482: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1483: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1484: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1485: hr_utility.raise_error;
1486:
1487: END IF;
1480: IF(p_segment14 <> hr_api.g_varchar2) THEN
1481: IF(l_age > p_segment14 ) THEN
1482: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1483: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1484: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1485: hr_utility.raise_error;
1486:
1487: END IF;
1488: END IF;
1489:
1490: --GSI Bug 4584922
1491: IF(p_segment12 <> hr_api.g_varchar2) THEN
1492: IF( p_segment12
1494: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1495: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1496: hr_utility.raise_error;
1497: END IF;
1490: --GSI Bug 4584922
1491: IF(p_segment12 <> hr_api.g_varchar2) THEN
1492: IF( p_segment12
1494: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1495: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1496: hr_utility.raise_error;
1497: END IF;
1498: END IF;
1491: IF(p_segment12 <> hr_api.g_varchar2) THEN
1492: IF( p_segment12
1494: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1495: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1496: hr_utility.raise_error;
1497: END IF;
1498: END IF;
1499:
1499:
1500: --GSI Bug 4584922
1501: IF(p_segment13 <> hr_api.g_varchar2) THEN
1502: IF( p_segment13
1504: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1505: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1506: hr_utility.raise_error;
1507: END IF;
1500: --GSI Bug 4584922
1501: IF(p_segment13 <> hr_api.g_varchar2) THEN
1502: IF( p_segment13
1504: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1505: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1506: hr_utility.raise_error;
1507: END IF;
1508: END IF;
1501: IF(p_segment13 <> hr_api.g_varchar2) THEN
1502: IF( p_segment13
1504: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1505: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1506: hr_utility.raise_error;
1507: END IF;
1508: END IF;
1509: END IF;
1612: CLOSE csr_chk_element_eit_year;
1613: --
1614: IF (l_year_status = 'Y') THEN
1615: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');
1616: fnd_message.set_token('REP_CODE',l_overlap_code); --p_eei_information3);
1617: hr_utility.raise_error;
1618: END IF;
1619: --
1620: -- Validation to check if single input value is mapped to more than one column in Extra Element Info DDF
1679: CLOSE csr_get_le_details;
1680:
1681: IF( p_eei_information2 = rec_get_ele_code.eei_information2) THEN
1682: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1683: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1684: fnd_message.set_token('LE',rec_get_le_details.name);
1685: hr_utility.raise_error;
1686: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1687: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1680:
1681: IF( p_eei_information2 = rec_get_ele_code.eei_information2) THEN
1682: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1683: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1684: fnd_message.set_token('LE',rec_get_le_details.name);
1685: hr_utility.raise_error;
1686: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1687: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1688: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1684: fnd_message.set_token('LE',rec_get_le_details.name);
1685: hr_utility.raise_error;
1686: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1687: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1688: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1689: fnd_message.set_token('LE',rec_get_le_details.name);
1690: hr_utility.raise_error;
1691: END IF;
1692: END IF;
1685: hr_utility.raise_error;
1686: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1687: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1688: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1689: fnd_message.set_token('LE',rec_get_le_details.name);
1690: hr_utility.raise_error;
1691: END IF;
1692: END IF;
1693:
1834: CLOSE csr_chk_element_eit_year;
1835: --
1836: IF (l_year_status = 'Y') THEN
1837: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');
1838: fnd_message.set_token('REP_CODE', l_overlap_code); --p_eei_information3);
1839: hr_utility.raise_error;
1840: END IF;
1841: --
1842: -- Validation to check if single input value is mapped to more than one column in Extra Element Info DDF
1909: FETCH csr_get_le_details INTO rec_get_le_details;
1910: CLOSE csr_get_le_details;
1911:
1912: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1913: --fnd_message.set_token('LE',rec_get_ele_code_le_glob.eei_information2);
1914: fnd_message.set_token('LE',rec_get_le_details.name);
1915: hr_utility.raise_error;
1916: END IF;
1917:
1910: CLOSE csr_get_le_details;
1911:
1912: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1913: --fnd_message.set_token('LE',rec_get_ele_code_le_glob.eei_information2);
1914: fnd_message.set_token('LE',rec_get_le_details.name);
1915: hr_utility.raise_error;
1916: END IF;
1917:
1918: