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 536: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'

532: END IF ;
533:
534: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
535: THEN -- length
536: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
537: THEN
538: RAISE INVALID_Y_NUMBER_FORMAT;
539: END IF ;
540: ELSE

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

559: END IF ;
560:
561: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
562: THEN -- length
563: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
564: THEN
565: RAISE INVALID_Y_NUMBER_FORMAT;
566: END IF ;
567: ELSE

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

583: -- For Y-Number --
584: IF p_org_information1 IS NOT NULL THEN
585: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
586: THEN -- length
587: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
588: THEN
589: RAISE INVALID_Y_NUMBER_FORMAT;
590: END IF ;
591: ELSE

Line 601: 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: IF p_org_information2 IS NOT NULL
598: THEN
599: BEGIN
600: select EFFECTIVE_DATE into l_session_date from fnd_sessions where SESSION_ID = userenv('SESSIONID');
601: 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);
602: EXCEPTION
603: WHEN OTHERS
604: THEN
605: fnd_message.set_name('PAY', 'HR_FI_INVALID_NATIONAL_ID');

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

705: IF p_org_information8 IS NOT NULL
706: THEN
707: IF ( (LENGTH(p_org_information8) =11) AND (SUBSTR(p_org_information8,9,1)='-') )
708: THEN -- length
709: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information8,'DDDDDDDD-DD')='0'
710: THEN
711: RAISE INVALID_PP_CUSTOMER_NUM_FORMAT;
712: ELSE
713: l_last_two_digits := substr(p_org_information8,10,2);

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

747: IF( (l_pipn_length >=8) AND (l_pipn_length <=11) )
748: THEN -- Length between 8 to 11
749: IF l_pipn_length = 8
750: THEN -- 46-1234M
751: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDX')='0'
752: THEN
753: RAISE INVALID_PIP_NUMBER_FORMAT;
754: END IF;
755: ELSIF l_pipn_length = 9

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

753: RAISE INVALID_PIP_NUMBER_FORMAT;
754: END IF;
755: ELSIF l_pipn_length = 9
756: THEN -- 46-12345M
757: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDX')='0'
758: THEN
759: RAISE INVALID_PIP_NUMBER_FORMAT;
760: END IF;
761:

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

760: END IF;
761:
762: ELSIF l_pipn_length = 10
763: THEN -- 46-123456M
764: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDX')='0'
765: THEN
766: RAISE INVALID_PIP_NUMBER_FORMAT;
767: END IF;
768:

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

767: END IF;
768:
769: ELSIF l_pipn_length = 11
770: THEN -- 46-1234567M
771: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDDX')='0'
772: THEN
773: RAISE INVALID_PIP_NUMBER_FORMAT;
774: END IF;
775: END IF;

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

782: IF SUBSTR(p_org_information6,5,1) = '-'
783: THEN -- SECOND FORMAT NNNN-NNNNT
784: IF l_pipn_length = 10
785: THEN -- 1234-5678M
786: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DDDD-DDDDX')='0'
787: THEN
788: RAISE INVALID_PIP_NUMBER_FORMAT;
789: END IF;
790: ELSE

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

821: IF( (l_pipn_length >=8) AND (l_pipn_length <=11) )
822: THEN -- Length between 8 to 11
823: IF l_pipn_length = 8
824: THEN -- 46-1234M
825: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDX')='0'
826: THEN
827: RAISE INVALID_PIP_NUMBER_FORMAT;
828: END IF;
829: ELSIF l_pipn_length = 9

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

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

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

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

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

839: RAISE INVALID_PIP_NUMBER_FORMAT;
840: END IF;
841: ELSIF l_pipn_length = 11
842: THEN -- 46-1234567M
843: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDDX')='0'
844: THEN
845: RAISE INVALID_PIP_NUMBER_FORMAT;
846: END IF;
847: END IF;

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

852: IF SUBSTR(p_org_information1,5,1) = '-'
853: THEN -- SECOND FORMAT NNNN-NNNNT
854: IF l_pipn_length = 10
855: THEN -- 1234-5678M
856: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDD-DDDDX')='0'
857: THEN
858: RAISE INVALID_PIP_NUMBER_FORMAT;
859: END IF;
860: ELSE

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

871: IF p_org_information2 IS NOT NULL
872: THEN
873: IF ( (LENGTH(p_org_information2) =11) AND (SUBSTR(p_org_information2,9,1)='-') )
874: THEN -- length
875: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information2,'DDDDDDDD-DD')='0'
876: THEN
877: RAISE INVALID_PP_CUSTOMER_NUM_FORMAT;
878: ELSE
879: l_last_two_digits := substr(p_org_information2,10,2);

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

918: IF p_org_information4 IS NOT NULL
919: THEN
920: IF ( (LENGTH(p_org_information4) =13) AND (SUBSTR(p_org_information4,4,1)='-') AND (SUBSTR(p_org_information4,12,1)='-') )
921: THEN -- length
922: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information4,'DDD-DDDDDDD-X')='0'
923: THEN
924: RAISE INVALID_POLICY_NUMBER_FORMAT;
925: END IF;
926: ELSE

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

958: IF p_org_information3 IS NOT NULL
959: THEN
960: IF ( (LENGTH(p_org_information3) =13) AND (SUBSTR(p_org_information3,4,1)='-') AND (SUBSTR(p_org_information3,12,1)='-') )
961: THEN -- length
962: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information3,'DDD-DDDDDDD-X')='0'
963: THEN
964: RAISE INVALID_POLICY_NUMBER_FORMAT;
965: END IF;
966: ELSE

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

1358: END IF ;
1359:
1360: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
1361: THEN -- length
1362: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
1363: THEN
1364: RAISE INVALID_Y_NUMBER_FORMAT;
1365: END IF ;
1366: ELSE

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

1397: END IF ;
1398:
1399: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
1400: THEN -- length
1401: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
1402: THEN
1403: RAISE INVALID_Y_NUMBER_FORMAT;
1404: END IF ;
1405: ELSE

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

1421: IF p_org_information1 IS NOT NULL
1422: THEN
1423: IF ( (LENGTH(p_org_information1) =9) AND (SUBSTR(p_org_information1,8,1)='-') )
1424: THEN -- length
1425: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDDDDD-X')='0'
1426: THEN
1427: RAISE INVALID_Y_NUMBER_FORMAT;
1428: END IF ;
1429: ELSE

Line 1441: 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);

1437: IF p_org_information2 IS NOT NULL
1438: THEN
1439: BEGIN
1440: SELECT EFFECTIVE_DATE INTO l_session_date FROM fnd_sessions WHERE SESSION_ID = userenv('SESSIONID');
1441: 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);
1442: EXCEPTION
1443: WHEN OTHERS
1444: THEN
1445: fnd_message.set_name('PAY', 'HR_FI_INVALID_NATIONAL_ID');

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

1551: IF p_org_information8 IS NOT NULL
1552: THEN
1553: IF ( (LENGTH(p_org_information8) =11) AND (SUBSTR(p_org_information8,9,1)='-') )
1554: THEN -- length
1555: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information8,'DDDDDDDD-DD')='0'
1556: THEN
1557: RAISE INVALID_PP_CUSTOMER_NUM_FORMAT;
1558: ELSE
1559: l_last_two_digits := substr(p_org_information8,10,2);

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

1596: IF( (l_pipn_length >=8) AND (l_pipn_length <=11) )
1597: THEN -- Length between 8 to 11
1598: IF l_pipn_length = 8
1599: THEN -- 46-1234M
1600: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDX')='0'
1601: THEN
1602: RAISE INVALID_PIP_NUMBER_FORMAT;
1603: END IF;
1604: ELSIF l_pipn_length = 9

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

1602: RAISE INVALID_PIP_NUMBER_FORMAT;
1603: END IF;
1604: ELSIF l_pipn_length = 9
1605: THEN -- 46-12345M
1606: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDX')='0'
1607: THEN
1608: RAISE INVALID_PIP_NUMBER_FORMAT;
1609: END IF;
1610: ELSIF l_pipn_length = 10

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

1608: RAISE INVALID_PIP_NUMBER_FORMAT;
1609: END IF;
1610: ELSIF l_pipn_length = 10
1611: THEN -- 46-123456M
1612: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDX')='0'
1613: THEN
1614: RAISE INVALID_PIP_NUMBER_FORMAT;
1615: END IF;
1616: ELSIF l_pipn_length = 11

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

1614: RAISE INVALID_PIP_NUMBER_FORMAT;
1615: END IF;
1616: ELSIF l_pipn_length = 11
1617: THEN -- 46-1234567M
1618: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DD-DDDDDDDX')='0'
1619: THEN
1620: RAISE INVALID_PIP_NUMBER_FORMAT;
1621: END IF;
1622: END IF;

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

1627: IF SUBSTR(p_org_information6,5,1) = '-'
1628: THEN -- SECOND FORMAT NNNN-NNNNT
1629: IF l_pipn_length = 10
1630: THEN -- 1234-5678M
1631: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information6,'DDDD-DDDDX')='0'
1632: THEN
1633: RAISE INVALID_PIP_NUMBER_FORMAT;
1634: END IF;
1635: ELSE

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

1664: IF( (l_pipn_length >=8) AND (l_pipn_length <=11) )
1665: THEN -- Length between 8 to 11
1666: IF l_pipn_length = 8
1667: THEN -- 46-1234M
1668: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDX')='0'
1669: THEN
1670: RAISE INVALID_PIP_NUMBER_FORMAT;
1671: END IF;
1672: ELSIF l_pipn_length = 9

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

1670: RAISE INVALID_PIP_NUMBER_FORMAT;
1671: END IF;
1672: ELSIF l_pipn_length = 9
1673: THEN -- 46-12345M
1674: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDX')='0'
1675: THEN
1676: RAISE INVALID_PIP_NUMBER_FORMAT;
1677: END IF;
1678: ELSIF l_pipn_length = 10

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

1676: RAISE INVALID_PIP_NUMBER_FORMAT;
1677: END IF;
1678: ELSIF l_pipn_length = 10
1679: THEN -- 46-123456M
1680: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDX')='0'
1681: THEN
1682: RAISE INVALID_PIP_NUMBER_FORMAT;
1683: END IF;
1684: ELSIF l_pipn_length = 11

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

1682: RAISE INVALID_PIP_NUMBER_FORMAT;
1683: END IF;
1684: ELSIF l_pipn_length = 11
1685: THEN -- 46-1234567M
1686: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DD-DDDDDDDX')='0'
1687: THEN
1688: RAISE INVALID_PIP_NUMBER_FORMAT;
1689: END IF;
1690: END IF;

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

1695: IF SUBSTR(p_org_information1,5,1) = '-'
1696: THEN -- SECOND FORMAT NNNN-NNNNT
1697: IF l_pipn_length = 10
1698: THEN -- 1234-5678M
1699: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information1,'DDDD-DDDDX')='0'
1700: THEN
1701: RAISE INVALID_PIP_NUMBER_FORMAT;
1702: END IF;
1703: ELSE

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

1714: IF p_org_information2 IS NOT NULL
1715: THEN
1716: IF ( (LENGTH(p_org_information2) =11) AND (SUBSTR(p_org_information2,9,1)='-') )
1717: THEN -- length
1718: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information2,'DDDDDDDD-DD')='0'
1719: THEN
1720: RAISE INVALID_PP_CUSTOMER_NUM_FORMAT;
1721: ELSE
1722: l_last_two_digits := substr(p_org_information2,10,2);

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

1760: IF p_org_information4 IS NOT NULL
1761: THEN
1762: IF ( (LENGTH(p_org_information4) =13) AND (SUBSTR(p_org_information4,4,1)='-') AND (SUBSTR(p_org_information4,12,1)='-') )
1763: THEN -- length
1764: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information4,'DDD-DDDDDDD-X')='0'
1765: THEN
1766: RAISE INVALID_POLICY_NUMBER_FORMAT;
1767: END IF;
1768: ELSE

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

1799: IF p_org_information3 IS NOT NULL
1800: THEN
1801: IF ( (LENGTH(p_org_information3) =13) AND (SUBSTR(p_org_information3,4,1)='-') AND (SUBSTR(p_org_information3,12,1)='-') )
1802: THEN -- length
1803: IF HR_NI_CHK_PKG.CHK_NAT_ID_FORMAT(p_org_information3,'DDD-DDDDDDD-X')='0'
1804: THEN
1805: RAISE INVALID_POLICY_NUMBER_FORMAT;
1806: END IF;
1807: ELSE