eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_FI_VALIDATE_PKG dependencies on HR_NI_CHK_PKG

Line 531: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'

527: END IF ;
528:
529: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
530: THEN -- length
531: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
532: THEN
533: RAISE INVALID_Y_NUMBER_FORMAT;
534: END IF ;
535: ELSE

Line 558: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'

554: END IF ;
555:
556: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
557: THEN -- length
558: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
559: THEN
560: RAISE INVALID_Y_NUMBER_FORMAT;
561: END IF ;
562: ELSE

Line 582: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'

578: -- For Y-Number --
579: IF p_org_information1 IS NOT NULL THEN
580: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
581: THEN -- length
582: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
583: THEN
584: RAISE INVALID_Y_NUMBER_FORMAT;
585: END IF ;
586: ELSE

Line 596: l_return := hr_ni_chk_pkg.validate_national_identifier(p_org_information2,null,null,'WHEN-VALIDATE-RECORD',null,l_business_group_id,'FI',l_session_date,l_warning,null,null,null);

592: IF p_org_information2 IS NOT NULL
593: THEN
594: BEGIN
595: select EFFECTIVE_DATE into l_session_date from fnd_sessions where SESSION_ID = userenv('SESSIONID');
596: l_return := hr_ni_chk_pkg.validate_national_identifier(p_org_information2,null,null,'WHEN-VALIDATE-RECORD',null,l_business_group_id,'FI',l_session_date,l_warning,null,null,null);
597: EXCEPTION
598: WHEN OTHERS
599: THEN
600: fnd_message.set_name('PAY', 'HR_FI_INVALID_NATIONAL_ID');

Line 704: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information8,'DDDDDDDD-DD')='0'

700: IF p_org_information8 IS NOT NULL
701: THEN
702: IF ( (LENGTH(p_org_information8) =11) AND (SUBSTR(p_org_information8,9,1)='-') )
703: THEN -- length
704: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information8,'DDDDDDDD-DD')='0'
705: THEN
706: RAISE INVALID_PP_CUSTOMER_NUM_FORMAT;
707: ELSE
708: l_last_two_digits := substr(p_org_information8,10,2);

Line 745: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDX')='0'

741: IF( (l_pipn_length >=8) AND (l_pipn_length <=11) )
742: THEN -- Length between 8 to 11
743: IF l_pipn_length = 8
744: THEN -- 46-1234M
745: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDX')='0'
746: THEN
747: RAISE INVALID_PIP_NUMBER_FORMAT;
748: END IF;
749: ELSIF l_pipn_length = 9

Line 751: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDX')='0'

747: RAISE INVALID_PIP_NUMBER_FORMAT;
748: END IF;
749: ELSIF l_pipn_length = 9
750: THEN -- 46-12345M
751: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDX')='0'
752: THEN
753: RAISE INVALID_PIP_NUMBER_FORMAT;
754: END IF;
755:

Line 758: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDX')='0'

754: END IF;
755:
756: ELSIF l_pipn_length = 10
757: THEN -- 46-123456M
758: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDX')='0'
759: THEN
760: RAISE INVALID_PIP_NUMBER_FORMAT;
761: END IF;
762:

Line 765: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDDX')='0'

761: END IF;
762:
763: ELSIF l_pipn_length = 11
764: THEN -- 46-1234567M
765: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDDX')='0'
766: THEN
767: RAISE INVALID_PIP_NUMBER_FORMAT;
768: END IF;
769: END IF;

Line 780: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DDDD-DDDDX')='0'

776: IF SUBSTR(p_org_information6,5,1) = '-'
777: THEN -- SECOND FORMAT NNNN-NNNNT
778: IF l_pipn_length = 10
779: THEN -- 1234-5678M
780: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DDDD-DDDDX')='0'
781: THEN
782: RAISE INVALID_PIP_NUMBER_FORMAT;
783: END IF;
784: ELSE

Line 819: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDX')='0'

815: IF( (l_pipn_length >=8) AND (l_pipn_length <=11) )
816: THEN -- Length between 8 to 11
817: IF l_pipn_length = 8
818: THEN -- 46-1234M
819: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDX')='0'
820: THEN
821: RAISE INVALID_PIP_NUMBER_FORMAT;
822: END IF;
823: ELSIF l_pipn_length = 9

Line 825: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDX')='0'

821: RAISE INVALID_PIP_NUMBER_FORMAT;
822: END IF;
823: ELSIF l_pipn_length = 9
824: THEN -- 46-12345M
825: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDX')='0'
826: THEN
827: RAISE INVALID_PIP_NUMBER_FORMAT;
828: END IF;
829: ELSIF l_pipn_length = 10

Line 831: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDX')='0'

827: RAISE INVALID_PIP_NUMBER_FORMAT;
828: END IF;
829: ELSIF l_pipn_length = 10
830: THEN -- 46-123456M
831: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDX')='0'
832: THEN
833: RAISE INVALID_PIP_NUMBER_FORMAT;
834: END IF;
835: ELSIF l_pipn_length = 11

Line 837: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDDX')='0'

833: RAISE INVALID_PIP_NUMBER_FORMAT;
834: END IF;
835: ELSIF l_pipn_length = 11
836: THEN -- 46-1234567M
837: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDDX')='0'
838: THEN
839: RAISE INVALID_PIP_NUMBER_FORMAT;
840: END IF;
841: END IF;

Line 850: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDD-DDDDX')='0'

846: IF SUBSTR(p_org_information1,5,1) = '-'
847: THEN -- SECOND FORMAT NNNN-NNNNT
848: IF l_pipn_length = 10
849: THEN -- 1234-5678M
850: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDD-DDDDX')='0'
851: THEN
852: RAISE INVALID_PIP_NUMBER_FORMAT;
853: END IF;
854: ELSE

Line 869: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information2,'DDDDDDDD-DD')='0'

865: IF p_org_information2 IS NOT NULL
866: THEN
867: IF ( (LENGTH(p_org_information2) =11) AND (SUBSTR(p_org_information2,9,1)='-') )
868: THEN -- length
869: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information2,'DDDDDDDD-DD')='0'
870: THEN
871: RAISE INVALID_PP_CUSTOMER_NUM_FORMAT;
872: ELSE
873: l_last_two_digits := substr(p_org_information2,10,2);

Line 914: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information4,'DDD-DDDDDDD-X')='0'

910: IF p_org_information4 IS NOT NULL
911: THEN
912: IF ( (LENGTH(p_org_information4) =13) AND (SUBSTR(p_org_information4,4,1)='-') AND (SUBSTR(p_org_information4,12,1)='-') )
913: THEN -- length
914: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information4,'DDD-DDDDDDD-X')='0'
915: THEN
916: RAISE INVALID_POLICY_NUMBER_FORMAT;
917: END IF;
918: ELSE

Line 950: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information3,'DDD-DDDDDDD-X')='0'

946: IF p_org_information3 IS NOT NULL
947: THEN
948: IF ( (LENGTH(p_org_information3) =13) AND (SUBSTR(p_org_information3,4,1)='-') AND (SUBSTR(p_org_information3,12,1)='-') )
949: THEN -- length
950: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information3,'DDD-DDDDDDD-X')='0'
951: THEN
952: RAISE INVALID_POLICY_NUMBER_FORMAT;
953: END IF;
954: ELSE

Line 1348: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'

1344: END IF ;
1345:
1346: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
1347: THEN -- length
1348: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
1349: THEN
1350: RAISE INVALID_Y_NUMBER_FORMAT;
1351: END IF ;
1352: ELSE

Line 1387: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'

1383: END IF ;
1384:
1385: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
1386: THEN -- length
1387: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
1388: THEN
1389: RAISE INVALID_Y_NUMBER_FORMAT;
1390: END IF ;
1391: ELSE

Line 1411: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'

1407: IF p_org_information1 IS NOT NULL
1408: THEN
1409: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
1410: THEN -- length
1411: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
1412: THEN
1413: RAISE INVALID_Y_NUMBER_FORMAT;
1414: END IF ;
1415: ELSE

Line 1427: l_return :=hr_ni_chk_pkg.validate_national_identifier(p_org_information2,null,null,'WHEN-VALIDATE-RECORD',null,l_business_group_id,'FI',l_session_date,l_warning,null,null,null);

1423: IF p_org_information2 IS NOT NULL
1424: THEN
1425: BEGIN
1426: SELECT EFFECTIVE_DATE INTO l_session_date FROM fnd_sessions WHERE SESSION_ID = userenv('SESSIONID');
1427: l_return :=hr_ni_chk_pkg.validate_national_identifier(p_org_information2,null,null,'WHEN-VALIDATE-RECORD',null,l_business_group_id,'FI',l_session_date,l_warning,null,null,null);
1428: EXCEPTION
1429: WHEN OTHERS
1430: THEN
1431: fnd_message.set_name('PAY', 'HR_FI_INVALID_NATIONAL_ID');

Line 1541: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information8,'DDDDDDDD-DD')='0'

1537: IF p_org_information8 IS NOT NULL
1538: THEN
1539: IF ( (LENGTH(p_org_information8) =11) AND (SUBSTR(p_org_information8,9,1)='-') )
1540: THEN -- length
1541: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information8,'DDDDDDDD-DD')='0'
1542: THEN
1543: RAISE INVALID_PP_CUSTOMER_NUM_FORMAT;
1544: ELSE
1545: l_last_two_digits := substr(p_org_information8,10,2);

Line 1586: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDX')='0'

1582: IF( (l_pipn_length >=8) AND (l_pipn_length <=11) )
1583: THEN -- Length between 8 to 11
1584: IF l_pipn_length = 8
1585: THEN -- 46-1234M
1586: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDX')='0'
1587: THEN
1588: RAISE INVALID_PIP_NUMBER_FORMAT;
1589: END IF;
1590: ELSIF l_pipn_length = 9

Line 1592: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDX')='0'

1588: RAISE INVALID_PIP_NUMBER_FORMAT;
1589: END IF;
1590: ELSIF l_pipn_length = 9
1591: THEN -- 46-12345M
1592: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDX')='0'
1593: THEN
1594: RAISE INVALID_PIP_NUMBER_FORMAT;
1595: END IF;
1596: ELSIF l_pipn_length = 10

Line 1598: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDX')='0'

1594: RAISE INVALID_PIP_NUMBER_FORMAT;
1595: END IF;
1596: ELSIF l_pipn_length = 10
1597: THEN -- 46-123456M
1598: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDX')='0'
1599: THEN
1600: RAISE INVALID_PIP_NUMBER_FORMAT;
1601: END IF;
1602: ELSIF l_pipn_length = 11

Line 1604: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDDX')='0'

1600: RAISE INVALID_PIP_NUMBER_FORMAT;
1601: END IF;
1602: ELSIF l_pipn_length = 11
1603: THEN -- 46-1234567M
1604: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDDX')='0'
1605: THEN
1606: RAISE INVALID_PIP_NUMBER_FORMAT;
1607: END IF;
1608: END IF;

Line 1617: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DDDD-DDDDX')='0'

1613: IF SUBSTR(p_org_information6,5,1) = '-'
1614: THEN -- SECOND FORMAT NNNN-NNNNT
1615: IF l_pipn_length = 10
1616: THEN -- 1234-5678M
1617: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DDDD-DDDDX')='0'
1618: THEN
1619: RAISE INVALID_PIP_NUMBER_FORMAT;
1620: END IF;
1621: ELSE

Line 1654: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDX')='0'

1650: IF( (l_pipn_length >=8) AND (l_pipn_length <=11) )
1651: THEN -- Length between 8 to 11
1652: IF l_pipn_length = 8
1653: THEN -- 46-1234M
1654: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDX')='0'
1655: THEN
1656: RAISE INVALID_PIP_NUMBER_FORMAT;
1657: END IF;
1658: ELSIF l_pipn_length = 9

Line 1660: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDX')='0'

1656: RAISE INVALID_PIP_NUMBER_FORMAT;
1657: END IF;
1658: ELSIF l_pipn_length = 9
1659: THEN -- 46-12345M
1660: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDX')='0'
1661: THEN
1662: RAISE INVALID_PIP_NUMBER_FORMAT;
1663: END IF;
1664: ELSIF l_pipn_length = 10

Line 1666: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDX')='0'

1662: RAISE INVALID_PIP_NUMBER_FORMAT;
1663: END IF;
1664: ELSIF l_pipn_length = 10
1665: THEN -- 46-123456M
1666: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDX')='0'
1667: THEN
1668: RAISE INVALID_PIP_NUMBER_FORMAT;
1669: END IF;
1670: ELSIF l_pipn_length = 11

Line 1672: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDDX')='0'

1668: RAISE INVALID_PIP_NUMBER_FORMAT;
1669: END IF;
1670: ELSIF l_pipn_length = 11
1671: THEN -- 46-1234567M
1672: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDDX')='0'
1673: THEN
1674: RAISE INVALID_PIP_NUMBER_FORMAT;
1675: END IF;
1676: END IF;

Line 1685: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDD-DDDDX')='0'

1681: IF SUBSTR(p_org_information1,5,1) = '-'
1682: THEN -- SECOND FORMAT NNNN-NNNNT
1683: IF l_pipn_length = 10
1684: THEN -- 1234-5678M
1685: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDD-DDDDX')='0'
1686: THEN
1687: RAISE INVALID_PIP_NUMBER_FORMAT;
1688: END IF;
1689: ELSE

Line 1704: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information2,'DDDDDDDD-DD')='0'

1700: IF p_org_information2 IS NOT NULL
1701: THEN
1702: IF ( (LENGTH(p_org_information2) =11) AND (SUBSTR(p_org_information2,9,1)='-') )
1703: THEN -- length
1704: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information2,'DDDDDDDD-DD')='0'
1705: THEN
1706: RAISE INVALID_PP_CUSTOMER_NUM_FORMAT;
1707: ELSE
1708: l_last_two_digits := substr(p_org_information2,10,2);

Line 1747: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information4,'DDD-DDDDDDD-X')='0'

1743: IF p_org_information4 IS NOT NULL
1744: THEN
1745: IF ( (LENGTH(p_org_information4) =13) AND (SUBSTR(p_org_information4,4,1)='-') AND (SUBSTR(p_org_information4,12,1)='-') )
1746: THEN -- length
1747: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information4,'DDD-DDDDDDD-X')='0'
1748: THEN
1749: RAISE INVALID_POLICY_NUMBER_FORMAT;
1750: END IF;
1751: ELSE

Line 1784: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information3,'DDD-DDDDDDD-X')='0'

1780: IF p_org_information3 IS NOT NULL
1781: THEN
1782: IF ( (LENGTH(p_org_information3) =13) AND (SUBSTR(p_org_information3,4,1)='-') AND (SUBSTR(p_org_information3,12,1)='-') )
1783: THEN -- length
1784: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information3,'DDD-DDDDDDD-X')='0'
1785: THEN
1786: RAISE INVALID_POLICY_NUMBER_FORMAT;
1787: END IF;
1788: ELSE