32:
33: IF l_field IS NOT NULL THEN
34: fnd_message.set_name('PER', 'HR_377202_SE_MANDATORY_MSG');
35: fnd_message.set_token('NAME',l_field, translate => true );
36: hr_utility.raise_error;
37: END IF;
38:
39: END IF;
40:
44:
45: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN
46: fnd_message.set_name('PER', 'HR_377202_SE_MANDATORY_MSG');
47: fnd_message.set_token('NAME',l_field, translate => true );
48: hr_utility.raise_error;
49: END IF;
50:
51: END IF;
52: END IF;
63: BEGIN
64: --
65: -- Added for GSI Bug 5472781
66: --
67: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
68: --
69: validate
70: (p_person_type_id => p_person_type_id
71: ,p_first_name => p_first_name
85: BEGIN
86: --
87: -- Added for GSI Bug 5472781
88: --
89: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
90: --
91: per_per_bus.chk_person_type
92: (p_person_type_id => l_person_type_id
93: ,p_business_group_id => p_business_group_id
112: BEGIN
113: --
114: -- Added for GSI Bug 5472781
115: --
116: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
117: --
118: per_per_bus.chk_person_type
119: (p_person_type_id => l_person_type_id
120: ,p_business_group_id => p_business_group_id
139: BEGIN
140: --
141: -- Added for GSI Bug 5472781
142: --
143: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
144: --
145: per_per_bus.chk_person_type
146: (p_person_type_id => l_person_type_id
147: ,p_business_group_id => p_business_group_id
636: BEGIN
637: --
638: -- Added for GSI Bug 5472781
639: --
640: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
641: --
642: OPEN getbgid;
643: FETCH getbgid INTO l_business_group_id;
644: CLOSE getbgid;
839: IF instr(p_org_information1,'.')>0 THEN
840: RAISE INVALID_INSURANCE_DECIMAL;
841: END IF;
842: ELSIF p_org_info_type_code='SE_SOE_ELEMENT_ADD_DETAILS' THEN
843: -- hr_utility.trace_on(null,'vetri');
844: -- hr_utility.trace('Joined ==> ' );
845: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
846: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
840: RAISE INVALID_INSURANCE_DECIMAL;
841: END IF;
842: ELSIF p_org_info_type_code='SE_SOE_ELEMENT_ADD_DETAILS' THEN
843: -- hr_utility.trace_on(null,'vetri');
844: -- hr_utility.trace('Joined ==> ' );
845: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
846: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
841: END IF;
842: ELSIF p_org_info_type_code='SE_SOE_ELEMENT_ADD_DETAILS' THEN
843: -- hr_utility.trace_on(null,'vetri');
844: -- hr_utility.trace('Joined ==> ' );
845: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
846: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
849: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
842: ELSIF p_org_info_type_code='SE_SOE_ELEMENT_ADD_DETAILS' THEN
843: -- hr_utility.trace_on(null,'vetri');
844: -- hr_utility.trace('Joined ==> ' );
845: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
846: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
849: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
850: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
843: -- hr_utility.trace_on(null,'vetri');
844: -- hr_utility.trace('Joined ==> ' );
845: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
846: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
849: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
850: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
851: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
844: -- hr_utility.trace('Joined ==> ' );
845: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
846: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
849: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
850: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
851: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
852: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
845: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
846: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
849: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
850: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
851: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
852: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
853:
846: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
849: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
850: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
851: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
852: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
853:
854: IF p_org_information5 ='I'
847: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
849: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
850: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
851: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
852: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
853:
854: IF p_org_information5 ='I'
855: THEN
848: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
849: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
850: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
851: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
852: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
853:
854: IF p_org_information5 ='I'
855: THEN
856: IF p_org_information7 IS NULL
883: WHEN ENTER_GROUP_BY THEN
884: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
885: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');
886: fnd_message.set_token('NAME',l_token, translate => true );
887: hr_utility.raise_error;
888:
889: WHEN ENTER_ALL THEN
890: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
891: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
892: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
893: hr_general.decode_lookup('SE_FORM_LABELS','AMT')|| ','||
894: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
895: fnd_message.set_token('NAME',l_token, translate => true );
896: hr_utility.raise_error;
897: WHEN UNIQUE_AST_NUMBER THEN
898: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');
899: hr_utility.raise_error;
900:
895: fnd_message.set_token('NAME',l_token, translate => true );
896: hr_utility.raise_error;
897: WHEN UNIQUE_AST_NUMBER THEN
898: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');
899: hr_utility.raise_error;
900:
901: WHEN UNIQUE_ORG_NUMBER THEN
902: fnd_message.set_name('PER', 'HR_377214_SE_UNIQUE_ORG_NUMBER');
903: hr_utility.raise_error;
899: hr_utility.raise_error;
900:
901: WHEN UNIQUE_ORG_NUMBER THEN
902: fnd_message.set_name('PER', 'HR_377214_SE_UNIQUE_ORG_NUMBER');
903: hr_utility.raise_error;
904:
905: WHEN UNIQUE_MAIN_LOCAL_UNIT THEN
906: fnd_message.set_name('PER', 'HR_377208_SE_MAIN_LOCAL_UNIT');
907: hr_utility.raise_error;
903: hr_utility.raise_error;
904:
905: WHEN UNIQUE_MAIN_LOCAL_UNIT THEN
906: fnd_message.set_name('PER', 'HR_377208_SE_MAIN_LOCAL_UNIT');
907: hr_utility.raise_error;
908:
909: WHEN UNIQUE_LOCAL_UNITS THEN
910: fnd_message.set_name('PER', 'HR_377210_SE_UNIQUE_LOCAL_UNIT');
911: hr_utility.raise_error;
907: hr_utility.raise_error;
908:
909: WHEN UNIQUE_LOCAL_UNITS THEN
910: fnd_message.set_name('PER', 'HR_377210_SE_UNIQUE_LOCAL_UNIT');
911: hr_utility.raise_error;
912:
913: WHEN UNIQUE_LE_AP
914: THEN
915: fnd_message.set_name('PAY', 'HR_377227_SE_LE_UNIQ_MILE_RATE');
912:
913: WHEN UNIQUE_LE_AP
914: THEN
915: fnd_message.set_name('PAY', 'HR_377227_SE_LE_UNIQ_MILE_RATE');
916: hr_utility.raise_error;
917:
918: WHEN INVALID_DATE
919: THEN
920: fnd_message.set_name('PAY', 'HR_377228_SE_VALID_DATE');
917:
918: WHEN INVALID_DATE
919: THEN
920: fnd_message.set_name('PAY', 'HR_377228_SE_VALID_DATE');
921: hr_utility.raise_error;
922:
923: WHEN INVALID_TAX
924: THEN
925: fnd_message.set_name('PAY', 'HR_377234_SE_TAX_DECL');
922:
923: WHEN INVALID_TAX
924: THEN
925: fnd_message.set_name('PAY', 'HR_377234_SE_TAX_DECL');
926: hr_utility.raise_error;
927:
928: WHEN INVALID_YEAR
929: THEN
930: fnd_message.set_name('PAY', 'HR_377236_SE_INVALID_YEAR');
927:
928: WHEN INVALID_YEAR
929: THEN
930: fnd_message.set_name('PAY', 'HR_377236_SE_INVALID_YEAR');
931: hr_utility.raise_error;
932:
933: WHEN INVALID_DECIMAL
934: THEN
935: fnd_message.set_name('PAY', 'HR_377237_SE_INVALID_DECIMAL');
932:
933: WHEN INVALID_DECIMAL
934: THEN
935: fnd_message.set_name('PAY', 'HR_377237_SE_INVALID_DECIMAL');
936: hr_utility.raise_error;
937: WHEN INVALID_CATEGORY
938: THEN
939: fnd_message.set_name('PAY', 'HR_377240_SE_INVALID_CATEGORY');
940: hr_utility.raise_error;
936: hr_utility.raise_error;
937: WHEN INVALID_CATEGORY
938: THEN
939: fnd_message.set_name('PAY', 'HR_377240_SE_INVALID_CATEGORY');
940: hr_utility.raise_error;
941: WHEN INVALID_UPDATE
942: THEN
943: fnd_message.set_name('PAY', 'HR_377241_SE_INVALID_UPDATE');
944: hr_utility.raise_error;
940: hr_utility.raise_error;
941: WHEN INVALID_UPDATE
942: THEN
943: fnd_message.set_name('PAY', 'HR_377241_SE_INVALID_UPDATE');
944: hr_utility.raise_error;
945: WHEN INVALID_INSURANCE_NUMBER
946: THEN
947: fnd_message.set_name('PAY', 'HR_377248_SE_INVALID_INSURANCE');
948: hr_utility.raise_error;
944: hr_utility.raise_error;
945: WHEN INVALID_INSURANCE_NUMBER
946: THEN
947: fnd_message.set_name('PAY', 'HR_377248_SE_INVALID_INSURANCE');
948: hr_utility.raise_error;
949: WHEN INVALID_VALUE
950: THEN
951: fnd_message.set_name('PAY', 'HR_377249_SE_INVALID_VALUE');
952: fnd_message.set_token('X',to_char(l_global_value));
949: WHEN INVALID_VALUE
950: THEN
951: fnd_message.set_name('PAY', 'HR_377249_SE_INVALID_VALUE');
952: fnd_message.set_token('X',to_char(l_global_value));
953: hr_utility.raise_error;
954: WHEN INVALID_INSURANCE_DECIMAL
955: THEN
956: fnd_message.set_name('PAY', 'HR_377250_SE_INVALID_INS_DECIM');
957: hr_utility.raise_error;
953: hr_utility.raise_error;
954: WHEN INVALID_INSURANCE_DECIMAL
955: THEN
956: fnd_message.set_name('PAY', 'HR_377250_SE_INVALID_INS_DECIM');
957: hr_utility.raise_error;
958: WHEN UNIQUE_YEAR
959: THEN
960: fnd_message.set_name('PER', 'HR_377270_SE_STD_WORK_YEAR');
961: hr_utility.raise_error;
957: hr_utility.raise_error;
958: WHEN UNIQUE_YEAR
959: THEN
960: fnd_message.set_name('PER', 'HR_377270_SE_STD_WORK_YEAR');
961: hr_utility.raise_error;
962: WHEN INVALID_MEMBERSHIP_NUMBER
963: THEN
964: fnd_message.set_name('PAY', 'HR_377263_SE_INVALID_MEMBER');
965: hr_utility.raise_error;
961: hr_utility.raise_error;
962: WHEN INVALID_MEMBERSHIP_NUMBER
963: THEN
964: fnd_message.set_name('PAY', 'HR_377263_SE_INVALID_MEMBER');
965: hr_utility.raise_error;
966: WHEN INVALID_MEMBERSHIP_DECIMAL
967: THEN
968: fnd_message.set_name('PAY', 'HR_377264_SE_INVALID_MEM_DECIM');
969: hr_utility.raise_error;
965: hr_utility.raise_error;
966: WHEN INVALID_MEMBERSHIP_DECIMAL
967: THEN
968: fnd_message.set_name('PAY', 'HR_377264_SE_INVALID_MEM_DECIM');
969: hr_utility.raise_error;
970: WHEN INVALID_WORK_NUMBER
971: THEN
972: fnd_message.set_name('PAY', 'HR_377265_SE_INVALID_WORK');
973: hr_utility.raise_error;
969: hr_utility.raise_error;
970: WHEN INVALID_WORK_NUMBER
971: THEN
972: fnd_message.set_name('PAY', 'HR_377265_SE_INVALID_WORK');
973: hr_utility.raise_error;
974: WHEN INVALID_WORK_DECIMAL
975: THEN
976: fnd_message.set_name('PAY', 'HR_377266_SE_INVALID_WOR_DECIM');
977: hr_utility.raise_error;
973: hr_utility.raise_error;
974: WHEN INVALID_WORK_DECIMAL
975: THEN
976: fnd_message.set_name('PAY', 'HR_377266_SE_INVALID_WOR_DECIM');
977: hr_utility.raise_error;
978: WHEN INVALID_ASSOCIATION_NUMBER
979: THEN
980: fnd_message.set_name('PAY', 'HR_377267_SE_INVALID_ASSOCIAT');
981: hr_utility.raise_error;
977: hr_utility.raise_error;
978: WHEN INVALID_ASSOCIATION_NUMBER
979: THEN
980: fnd_message.set_name('PAY', 'HR_377267_SE_INVALID_ASSOCIAT');
981: hr_utility.raise_error;
982: WHEN INVALID_ASSOCIATION_DECIMAL
983: THEN
984: fnd_message.set_name('PAY', 'HR_377268_SE_INVALID_ASS_DECIM');
985: hr_utility.raise_error;
981: hr_utility.raise_error;
982: WHEN INVALID_ASSOCIATION_DECIMAL
983: THEN
984: fnd_message.set_name('PAY', 'HR_377268_SE_INVALID_ASS_DECIM');
985: hr_utility.raise_error;
986: WHEN INVALID_AGREEMENT_NUMBER
987: THEN
988: fnd_message.set_name('PAY', 'HR_377261_SE_AGREEMENT_CODE');
989: hr_utility.raise_error;
985: hr_utility.raise_error;
986: WHEN INVALID_AGREEMENT_NUMBER
987: THEN
988: fnd_message.set_name('PAY', 'HR_377261_SE_AGREEMENT_CODE');
989: hr_utility.raise_error;
990: WHEN INVALID_AGREEMENT_DECIMAL
991: THEN
992: fnd_message.set_name('PAY', 'HR_377269_SE_INVALID_AGR_DECIM');
993: hr_utility.raise_error;
989: hr_utility.raise_error;
990: WHEN INVALID_AGREEMENT_DECIMAL
991: THEN
992: fnd_message.set_name('PAY', 'HR_377269_SE_INVALID_AGR_DECIM');
993: hr_utility.raise_error;
994: WHEN INVALID_AGREEMENT_NUM
995: THEN
996: fnd_message.set_name('PAY', 'HR_377271_SE_AGREEMENT_NUMBER');
997: hr_utility.raise_error;
993: hr_utility.raise_error;
994: WHEN INVALID_AGREEMENT_NUM
995: THEN
996: fnd_message.set_name('PAY', 'HR_377271_SE_AGREEMENT_NUMBER');
997: hr_utility.raise_error;
998:
999:
1000: END validate_create_org_inf;
1001:
1508: BEGIN
1509: --
1510: -- Added for GSI Bug 5472781
1511: --
1512: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1513: --
1514:
1515: OPEN getorgid;
1516: FETCH getorgid INTO l_organization_id;
1766: WHEN ENTER_GROUP_BY THEN
1767: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1768: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');
1769: fnd_message.set_token('NAME',l_token, translate => true );
1770: hr_utility.raise_error;
1771:
1772: WHEN ENTER_ALL THEN
1773: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1774: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
1775: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
1776: hr_general.decode_lookup('SE_FORM_LABELS','AMT') || ','||
1777: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
1778: fnd_message.set_token('NAME',l_token, translate => true );
1779: hr_utility.raise_error;
1780: WHEN UNIQUE_AST_NUMBER THEN
1781:
1782: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');
1783: hr_utility.raise_error;
1779: hr_utility.raise_error;
1780: WHEN UNIQUE_AST_NUMBER THEN
1781:
1782: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');
1783: hr_utility.raise_error;
1784:
1785: WHEN UNIQUE_ORG_NUMBER THEN
1786: fnd_message.set_name('PER', 'HR_377214_SE_UNIQUE_ORG_NUMBER');
1787: hr_utility.raise_error;
1783: hr_utility.raise_error;
1784:
1785: WHEN UNIQUE_ORG_NUMBER THEN
1786: fnd_message.set_name('PER', 'HR_377214_SE_UNIQUE_ORG_NUMBER');
1787: hr_utility.raise_error;
1788:
1789:
1790: WHEN UNIQUE_MAIN_LOCAL_UNIT THEN
1791: fnd_message.set_name('PER', 'HR_377208_SE_MAIN_LOCAL_UNIT');
1788:
1789:
1790: WHEN UNIQUE_MAIN_LOCAL_UNIT THEN
1791: fnd_message.set_name('PER', 'HR_377208_SE_MAIN_LOCAL_UNIT');
1792: hr_utility.raise_error;
1793:
1794: WHEN UNIQUE_LOCAL_UNITS THEN
1795: fnd_message.set_name('PER', 'HR_377210_SE_UNIQUE_LOCAL_UNIT');
1796: hr_utility.raise_error;
1792: hr_utility.raise_error;
1793:
1794: WHEN UNIQUE_LOCAL_UNITS THEN
1795: fnd_message.set_name('PER', 'HR_377210_SE_UNIQUE_LOCAL_UNIT');
1796: hr_utility.raise_error;
1797: WHEN UNIQUE_LE_AP
1798: THEN
1799: fnd_message.set_name('PAY', 'HR_377227_SE_LE_UNIQ_MILE_RATE');
1800: hr_utility.raise_error;
1796: hr_utility.raise_error;
1797: WHEN UNIQUE_LE_AP
1798: THEN
1799: fnd_message.set_name('PAY', 'HR_377227_SE_LE_UNIQ_MILE_RATE');
1800: hr_utility.raise_error;
1801:
1802: WHEN INVALID_DATE
1803: THEN
1804: fnd_message.set_name('PAY', 'HR_377228_SE_VALID_DATE');
1801:
1802: WHEN INVALID_DATE
1803: THEN
1804: fnd_message.set_name('PAY', 'HR_377228_SE_VALID_DATE');
1805: hr_utility.raise_error;
1806: WHEN INVALID_TAX
1807: THEN
1808: fnd_message.set_name('PAY', 'HR_377234_SE_TAX_DECL');
1809: hr_utility.raise_error;
1805: hr_utility.raise_error;
1806: WHEN INVALID_TAX
1807: THEN
1808: fnd_message.set_name('PAY', 'HR_377234_SE_TAX_DECL');
1809: hr_utility.raise_error;
1810:
1811: WHEN INVALID_YEAR
1812: THEN
1813: fnd_message.set_name('PAY', 'HR_377236_SE_INVALID_YEAR');
1810:
1811: WHEN INVALID_YEAR
1812: THEN
1813: fnd_message.set_name('PAY', 'HR_377236_SE_INVALID_YEAR');
1814: hr_utility.raise_error;
1815:
1816: WHEN INVALID_DECIMAL
1817: THEN
1818: fnd_message.set_name('PAY', 'HR_377237_SE_INVALID_DECIMAL');
1815:
1816: WHEN INVALID_DECIMAL
1817: THEN
1818: fnd_message.set_name('PAY', 'HR_377237_SE_INVALID_DECIMAL');
1819: hr_utility.raise_error;
1820: WHEN INVALID_CATEGORY
1821: THEN
1822: fnd_message.set_name('PAY', 'HR_377240_SE_INVALID_CATEGORY');
1823: hr_utility.raise_error;
1819: hr_utility.raise_error;
1820: WHEN INVALID_CATEGORY
1821: THEN
1822: fnd_message.set_name('PAY', 'HR_377240_SE_INVALID_CATEGORY');
1823: hr_utility.raise_error;
1824: WHEN INVALID_UPDATE
1825: THEN
1826: fnd_message.set_name('PAY', 'HR_377241_SE_INVALID_UPDATE');
1827: hr_utility.raise_error;
1823: hr_utility.raise_error;
1824: WHEN INVALID_UPDATE
1825: THEN
1826: fnd_message.set_name('PAY', 'HR_377241_SE_INVALID_UPDATE');
1827: hr_utility.raise_error;
1828: WHEN INVALID_INSURANCE_NUMBER
1829: THEN
1830: fnd_message.set_name('PAY', 'HR_377248_SE_INVALID_INSURANCE');
1831: hr_utility.raise_error;
1827: hr_utility.raise_error;
1828: WHEN INVALID_INSURANCE_NUMBER
1829: THEN
1830: fnd_message.set_name('PAY', 'HR_377248_SE_INVALID_INSURANCE');
1831: hr_utility.raise_error;
1832: WHEN INVALID_VALUE
1833: THEN
1834: fnd_message.set_name('PAY', 'HR_377249_SE_INVALID_VALUE');
1835: fnd_message.set_token('X',to_char(l_global_value));
1832: WHEN INVALID_VALUE
1833: THEN
1834: fnd_message.set_name('PAY', 'HR_377249_SE_INVALID_VALUE');
1835: fnd_message.set_token('X',to_char(l_global_value));
1836: hr_utility.raise_error;
1837: WHEN INVALID_INSURANCE_DECIMAL
1838: THEN
1839: fnd_message.set_name('PAY', 'HR_377250_SE_INVALID_INS_DECIM');
1840: hr_utility.raise_error;
1836: hr_utility.raise_error;
1837: WHEN INVALID_INSURANCE_DECIMAL
1838: THEN
1839: fnd_message.set_name('PAY', 'HR_377250_SE_INVALID_INS_DECIM');
1840: hr_utility.raise_error;
1841: WHEN UNIQUE_YEAR
1842: THEN
1843: fnd_message.set_name('PER', 'HR_377270_SE_STD_WORK_YEAR');
1844: hr_utility.raise_error;
1840: hr_utility.raise_error;
1841: WHEN UNIQUE_YEAR
1842: THEN
1843: fnd_message.set_name('PER', 'HR_377270_SE_STD_WORK_YEAR');
1844: hr_utility.raise_error;
1845: WHEN INVALID_MEMBERSHIP_NUMBER
1846: THEN
1847: fnd_message.set_name('PAY', 'HR_377263_SE_INVALID_MEMBER');
1848: hr_utility.raise_error;
1844: hr_utility.raise_error;
1845: WHEN INVALID_MEMBERSHIP_NUMBER
1846: THEN
1847: fnd_message.set_name('PAY', 'HR_377263_SE_INVALID_MEMBER');
1848: hr_utility.raise_error;
1849: WHEN INVALID_MEMBERSHIP_DECIMAL
1850: THEN
1851: fnd_message.set_name('PAY', 'HR_377264_SE_INVALID_MEM_DECIM');
1852: hr_utility.raise_error;
1848: hr_utility.raise_error;
1849: WHEN INVALID_MEMBERSHIP_DECIMAL
1850: THEN
1851: fnd_message.set_name('PAY', 'HR_377264_SE_INVALID_MEM_DECIM');
1852: hr_utility.raise_error;
1853: WHEN INVALID_WORK_NUMBER
1854: THEN
1855: fnd_message.set_name('PAY', 'HR_377265_SE_INVALID_WORK');
1856: hr_utility.raise_error;
1852: hr_utility.raise_error;
1853: WHEN INVALID_WORK_NUMBER
1854: THEN
1855: fnd_message.set_name('PAY', 'HR_377265_SE_INVALID_WORK');
1856: hr_utility.raise_error;
1857: WHEN INVALID_WORK_DECIMAL
1858: THEN
1859: fnd_message.set_name('PAY', 'HR_377266_SE_INVALID_WOR_DECIM');
1860: hr_utility.raise_error;
1856: hr_utility.raise_error;
1857: WHEN INVALID_WORK_DECIMAL
1858: THEN
1859: fnd_message.set_name('PAY', 'HR_377266_SE_INVALID_WOR_DECIM');
1860: hr_utility.raise_error;
1861: WHEN INVALID_ASSOCIATION_NUMBER
1862: THEN
1863: fnd_message.set_name('PAY', 'HR_377267_SE_INVALID_ASSOCIAT');
1864: hr_utility.raise_error;
1860: hr_utility.raise_error;
1861: WHEN INVALID_ASSOCIATION_NUMBER
1862: THEN
1863: fnd_message.set_name('PAY', 'HR_377267_SE_INVALID_ASSOCIAT');
1864: hr_utility.raise_error;
1865: WHEN INVALID_ASSOCIATION_DECIMAL
1866: THEN
1867: fnd_message.set_name('PAY', 'HR_377268_SE_INVALID_ASS_DECIM');
1868: hr_utility.raise_error;
1864: hr_utility.raise_error;
1865: WHEN INVALID_ASSOCIATION_DECIMAL
1866: THEN
1867: fnd_message.set_name('PAY', 'HR_377268_SE_INVALID_ASS_DECIM');
1868: hr_utility.raise_error;
1869: WHEN INVALID_AGREEMENT_NUMBER
1870: THEN
1871: fnd_message.set_name('PAY', 'HR_377261_SE_AGREEMENT_CODE');
1872: hr_utility.raise_error;
1868: hr_utility.raise_error;
1869: WHEN INVALID_AGREEMENT_NUMBER
1870: THEN
1871: fnd_message.set_name('PAY', 'HR_377261_SE_AGREEMENT_CODE');
1872: hr_utility.raise_error;
1873: WHEN INVALID_AGREEMENT_DECIMAL
1874: THEN
1875: fnd_message.set_name('PAY', 'HR_377269_SE_INVALID_AGR_DECIM');
1876: hr_utility.raise_error;
1872: hr_utility.raise_error;
1873: WHEN INVALID_AGREEMENT_DECIMAL
1874: THEN
1875: fnd_message.set_name('PAY', 'HR_377269_SE_INVALID_AGR_DECIM');
1876: hr_utility.raise_error;
1877: WHEN INVALID_AGREEMENT_NUM
1878: THEN
1879: fnd_message.set_name('PAY', 'HR_377271_SE_AGREEMENT_NUMBER');
1880: hr_utility.raise_error;
1876: hr_utility.raise_error;
1877: WHEN INVALID_AGREEMENT_NUM
1878: THEN
1879: fnd_message.set_name('PAY', 'HR_377271_SE_AGREEMENT_NUMBER');
1880: hr_utility.raise_error;
1881:
1882:
1883:
1884: END validate_update_org_inf;
1901: IF p_token IS NOT NULL
1902: THEN
1903: fnd_message.set_name('PER', 'HR_377207_SE_INVALID_FORMAT');
1904: fnd_message.set_token('NAME',p_token, translate => true );
1905: hr_utility.raise_error;
1906: ELSE
1907: fnd_message.set_name('PER', p_message);
1908: hr_utility.raise_error;
1909: END IF ;
1904: fnd_message.set_token('NAME',p_token, translate => true );
1905: hr_utility.raise_error;
1906: ELSE
1907: fnd_message.set_name('PER', p_message);
1908: hr_utility.raise_error;
1909: END IF ;
1910:
1911: END IF;
1912: END IF;
1933: BEGIN
1934: --
1935: -- Added for GSI Bug 5472781
1936: --
1937: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1938: --
1939: OPEN get_int_or_ext_flag;
1940: FETCH get_int_or_ext_flag INTO l_internal_external_flag;
1941: CLOSE get_int_or_ext_flag;
1951: EXCEPTION
1952: WHEN INT_EXT_EXCEPTION
1953: THEN
1954: fnd_message.set_name('PER', 'HR_377211_SE_SOC_SEC_OFFICE');
1955: hr_utility.raise_error;
1956: END CREATE_ORG_CLASS_VALIDATE;
1957: ---
1958:
1959:
1967: BEGIN
1968: --
1969: -- Added for GSI Bug 5472781
1970: --
1971: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1972: --
1973:
1974: IF (p_scl_segment5 IS NOT NULL AND p_scl_segment5 <> hr_api.g_varchar2)
1975: AND (p_scl_segment6 IS NOT NULL AND p_scl_segment6 <> hr_api.g_varchar2) THEN
1983: EXCEPTION
1984: WHEN VALID_NOTIFY_DATE
1985: THEN
1986: fnd_message.set_name('PER', 'HR_377212_SE_VALID_NOTIFY_DATE');
1987: hr_utility.raise_error;
1988:
1989: END CREATE_ASG_VALIDATE;
1990:
1991: -- End OF Create_Asg_validate
2001: BEGIN
2002: --
2003: -- Added for GSI Bug 5472781
2004: --
2005: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
2006: --
2007:
2008: IF (p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2)
2009: AND (p_segment6 IS NOT NULL AND p_segment6 <> hr_api.g_varchar2) THEN
2017:
2018: EXCEPTION
2019: WHEN VALID_NOTIFY_DATE THEN
2020: fnd_message.set_name('PER', 'HR_377212_SE_VALID_NOTIFY_DATE');
2021: hr_utility.raise_error;
2022:
2023: END UPDATE_ASG_VALIDATE ;
2024:
2025: -- End Of UPDATE_ASG_VALIDATE