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:
48:
49: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN
50: fnd_message.set_name('PER', 'HR_377202_SE_MANDATORY_MSG');
51: fnd_message.set_token('NAME',l_field, translate => true );
52: hr_utility.raise_error;
53: END IF;
54:
55: END IF;
56: END IF;
68: BEGIN
69: --
70: -- Added for GSI Bug 5472781
71: --
72: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
73: --
74: validate
75: (p_person_type_id => p_person_type_id
76: ,p_first_name => p_first_name
90: BEGIN
91: --
92: -- Added for GSI Bug 5472781
93: --
94: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
95: --
96: per_per_bus.chk_person_type
97: (p_person_type_id => l_person_type_id
98: ,p_business_group_id => p_business_group_id
117: BEGIN
118: --
119: -- Added for GSI Bug 5472781
120: --
121: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
122: --
123: per_per_bus.chk_person_type
124: (p_person_type_id => l_person_type_id
125: ,p_business_group_id => p_business_group_id
144: BEGIN
145: --
146: -- Added for GSI Bug 5472781
147: --
148: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
149: --
150: per_per_bus.chk_person_type
151: (p_person_type_id => l_person_type_id
152: ,p_business_group_id => p_business_group_id
641: BEGIN
642: --
643: -- Added for GSI Bug 5472781
644: --
645: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
646: --
647: OPEN getbgid;
648: FETCH getbgid INTO l_business_group_id;
649: CLOSE getbgid;
844: IF instr(p_org_information1,'.')>0 THEN
845: RAISE INVALID_INSURANCE_DECIMAL;
846: END IF;
847: ELSIF p_org_info_type_code='SE_SOE_ELEMENT_ADD_DETAILS' THEN
848: -- hr_utility.trace_on(null,'vetri');
849: -- hr_utility.trace('Joined ==> ' );
850: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
851: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
845: RAISE INVALID_INSURANCE_DECIMAL;
846: END IF;
847: ELSIF p_org_info_type_code='SE_SOE_ELEMENT_ADD_DETAILS' THEN
848: -- hr_utility.trace_on(null,'vetri');
849: -- hr_utility.trace('Joined ==> ' );
850: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
851: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
846: END IF;
847: ELSIF p_org_info_type_code='SE_SOE_ELEMENT_ADD_DETAILS' THEN
848: -- hr_utility.trace_on(null,'vetri');
849: -- hr_utility.trace('Joined ==> ' );
850: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
851: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
854: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
847: ELSIF p_org_info_type_code='SE_SOE_ELEMENT_ADD_DETAILS' THEN
848: -- hr_utility.trace_on(null,'vetri');
849: -- hr_utility.trace('Joined ==> ' );
850: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
851: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
854: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
855: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
848: -- hr_utility.trace_on(null,'vetri');
849: -- hr_utility.trace('Joined ==> ' );
850: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
851: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
854: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
855: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
856: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
849: -- hr_utility.trace('Joined ==> ' );
850: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
851: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
854: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
855: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
856: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
857: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
850: -- hr_utility.set_location(' p_org_information3 ' ||p_org_information3 ,10);
851: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
854: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
855: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
856: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
857: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
858:
851: -- hr_utility.set_location(' p_org_information4 '||p_org_information4 ,10);
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
854: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
855: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
856: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
857: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
858:
859: IF p_org_information5 ='I'
852: -- hr_utility.set_location(' p_org_information5 '||p_org_information5 ,10);
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
854: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
855: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
856: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
857: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
858:
859: IF p_org_information5 ='I'
860: THEN
853: -- hr_utility.set_location(' p_org_information6 '||p_org_information6 ,10);
854: -- hr_utility.set_location(' p_org_information7 '||p_org_information7 ,10);
855: -- hr_utility.set_location(' p_org_information8 '||p_org_information8 ,10);
856: -- hr_utility.set_location(' p_org_information9 '||p_org_information9 ,10);
857: -- hr_utility.set_location(' p_org_information10 '||p_org_information10 ,10);
858:
859: IF p_org_information5 ='I'
860: THEN
861: IF p_org_information7 IS NULL
888: WHEN ENTER_GROUP_BY THEN
889: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
890: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');
891: fnd_message.set_token('NAME',l_token, translate => true );
892: hr_utility.raise_error;
893:
894: WHEN ENTER_ALL THEN
895: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
896: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
897: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
898: hr_general.decode_lookup('SE_FORM_LABELS','AMT')|| ','||
899: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
900: fnd_message.set_token('NAME',l_token, translate => true );
901: hr_utility.raise_error;
902: WHEN UNIQUE_AST_NUMBER THEN
903: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');
904: hr_utility.raise_error;
905:
900: fnd_message.set_token('NAME',l_token, translate => true );
901: hr_utility.raise_error;
902: WHEN UNIQUE_AST_NUMBER THEN
903: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');
904: hr_utility.raise_error;
905:
906: WHEN UNIQUE_ORG_NUMBER THEN
907: fnd_message.set_name('PER', 'HR_377214_SE_UNIQUE_ORG_NUMBER');
908: hr_utility.raise_error;
904: hr_utility.raise_error;
905:
906: WHEN UNIQUE_ORG_NUMBER THEN
907: fnd_message.set_name('PER', 'HR_377214_SE_UNIQUE_ORG_NUMBER');
908: hr_utility.raise_error;
909:
910: WHEN UNIQUE_MAIN_LOCAL_UNIT THEN
911: fnd_message.set_name('PER', 'HR_377208_SE_MAIN_LOCAL_UNIT');
912: hr_utility.raise_error;
908: hr_utility.raise_error;
909:
910: WHEN UNIQUE_MAIN_LOCAL_UNIT THEN
911: fnd_message.set_name('PER', 'HR_377208_SE_MAIN_LOCAL_UNIT');
912: hr_utility.raise_error;
913:
914: WHEN UNIQUE_LOCAL_UNITS THEN
915: fnd_message.set_name('PER', 'HR_377210_SE_UNIQUE_LOCAL_UNIT');
916: hr_utility.raise_error;
912: hr_utility.raise_error;
913:
914: WHEN UNIQUE_LOCAL_UNITS THEN
915: fnd_message.set_name('PER', 'HR_377210_SE_UNIQUE_LOCAL_UNIT');
916: hr_utility.raise_error;
917:
918: WHEN UNIQUE_LE_AP
919: THEN
920: fnd_message.set_name('PAY', 'HR_377227_SE_LE_UNIQ_MILE_RATE');
917:
918: WHEN UNIQUE_LE_AP
919: THEN
920: fnd_message.set_name('PAY', 'HR_377227_SE_LE_UNIQ_MILE_RATE');
921: hr_utility.raise_error;
922:
923: WHEN INVALID_DATE
924: THEN
925: fnd_message.set_name('PAY', 'HR_377228_SE_VALID_DATE');
922:
923: WHEN INVALID_DATE
924: THEN
925: fnd_message.set_name('PAY', 'HR_377228_SE_VALID_DATE');
926: hr_utility.raise_error;
927:
928: WHEN INVALID_TAX
929: THEN
930: fnd_message.set_name('PAY', 'HR_377234_SE_TAX_DECL');
927:
928: WHEN INVALID_TAX
929: THEN
930: fnd_message.set_name('PAY', 'HR_377234_SE_TAX_DECL');
931: hr_utility.raise_error;
932:
933: WHEN INVALID_YEAR
934: THEN
935: fnd_message.set_name('PAY', 'HR_377236_SE_INVALID_YEAR');
932:
933: WHEN INVALID_YEAR
934: THEN
935: fnd_message.set_name('PAY', 'HR_377236_SE_INVALID_YEAR');
936: hr_utility.raise_error;
937:
938: WHEN INVALID_DECIMAL
939: THEN
940: fnd_message.set_name('PAY', 'HR_377237_SE_INVALID_DECIMAL');
937:
938: WHEN INVALID_DECIMAL
939: THEN
940: fnd_message.set_name('PAY', 'HR_377237_SE_INVALID_DECIMAL');
941: hr_utility.raise_error;
942: WHEN INVALID_CATEGORY
943: THEN
944: fnd_message.set_name('PAY', 'HR_377240_SE_INVALID_CATEGORY');
945: hr_utility.raise_error;
941: hr_utility.raise_error;
942: WHEN INVALID_CATEGORY
943: THEN
944: fnd_message.set_name('PAY', 'HR_377240_SE_INVALID_CATEGORY');
945: hr_utility.raise_error;
946: WHEN INVALID_UPDATE
947: THEN
948: fnd_message.set_name('PAY', 'HR_377241_SE_INVALID_UPDATE');
949: hr_utility.raise_error;
945: hr_utility.raise_error;
946: WHEN INVALID_UPDATE
947: THEN
948: fnd_message.set_name('PAY', 'HR_377241_SE_INVALID_UPDATE');
949: hr_utility.raise_error;
950: WHEN INVALID_INSURANCE_NUMBER
951: THEN
952: fnd_message.set_name('PAY', 'HR_377248_SE_INVALID_INSURANCE');
953: hr_utility.raise_error;
949: hr_utility.raise_error;
950: WHEN INVALID_INSURANCE_NUMBER
951: THEN
952: fnd_message.set_name('PAY', 'HR_377248_SE_INVALID_INSURANCE');
953: hr_utility.raise_error;
954: WHEN INVALID_VALUE
955: THEN
956: fnd_message.set_name('PAY', 'HR_377249_SE_INVALID_VALUE');
957: fnd_message.set_token('X',to_char(l_global_value));
954: WHEN INVALID_VALUE
955: THEN
956: fnd_message.set_name('PAY', 'HR_377249_SE_INVALID_VALUE');
957: fnd_message.set_token('X',to_char(l_global_value));
958: hr_utility.raise_error;
959: WHEN INVALID_INSURANCE_DECIMAL
960: THEN
961: fnd_message.set_name('PAY', 'HR_377250_SE_INVALID_INS_DECIM');
962: hr_utility.raise_error;
958: hr_utility.raise_error;
959: WHEN INVALID_INSURANCE_DECIMAL
960: THEN
961: fnd_message.set_name('PAY', 'HR_377250_SE_INVALID_INS_DECIM');
962: hr_utility.raise_error;
963: WHEN UNIQUE_YEAR
964: THEN
965: fnd_message.set_name('PER', 'HR_377270_SE_STD_WORK_YEAR');
966: hr_utility.raise_error;
962: hr_utility.raise_error;
963: WHEN UNIQUE_YEAR
964: THEN
965: fnd_message.set_name('PER', 'HR_377270_SE_STD_WORK_YEAR');
966: hr_utility.raise_error;
967: WHEN INVALID_MEMBERSHIP_NUMBER
968: THEN
969: fnd_message.set_name('PAY', 'HR_377263_SE_INVALID_MEMBER');
970: hr_utility.raise_error;
966: hr_utility.raise_error;
967: WHEN INVALID_MEMBERSHIP_NUMBER
968: THEN
969: fnd_message.set_name('PAY', 'HR_377263_SE_INVALID_MEMBER');
970: hr_utility.raise_error;
971: WHEN INVALID_MEMBERSHIP_DECIMAL
972: THEN
973: fnd_message.set_name('PAY', 'HR_377264_SE_INVALID_MEM_DECIM');
974: hr_utility.raise_error;
970: hr_utility.raise_error;
971: WHEN INVALID_MEMBERSHIP_DECIMAL
972: THEN
973: fnd_message.set_name('PAY', 'HR_377264_SE_INVALID_MEM_DECIM');
974: hr_utility.raise_error;
975: WHEN INVALID_WORK_NUMBER
976: THEN
977: fnd_message.set_name('PAY', 'HR_377265_SE_INVALID_WORK');
978: hr_utility.raise_error;
974: hr_utility.raise_error;
975: WHEN INVALID_WORK_NUMBER
976: THEN
977: fnd_message.set_name('PAY', 'HR_377265_SE_INVALID_WORK');
978: hr_utility.raise_error;
979: WHEN INVALID_WORK_DECIMAL
980: THEN
981: fnd_message.set_name('PAY', 'HR_377266_SE_INVALID_WOR_DECIM');
982: hr_utility.raise_error;
978: hr_utility.raise_error;
979: WHEN INVALID_WORK_DECIMAL
980: THEN
981: fnd_message.set_name('PAY', 'HR_377266_SE_INVALID_WOR_DECIM');
982: hr_utility.raise_error;
983: WHEN INVALID_ASSOCIATION_NUMBER
984: THEN
985: fnd_message.set_name('PAY', 'HR_377267_SE_INVALID_ASSOCIAT');
986: hr_utility.raise_error;
982: hr_utility.raise_error;
983: WHEN INVALID_ASSOCIATION_NUMBER
984: THEN
985: fnd_message.set_name('PAY', 'HR_377267_SE_INVALID_ASSOCIAT');
986: hr_utility.raise_error;
987: WHEN INVALID_ASSOCIATION_DECIMAL
988: THEN
989: fnd_message.set_name('PAY', 'HR_377268_SE_INVALID_ASS_DECIM');
990: hr_utility.raise_error;
986: hr_utility.raise_error;
987: WHEN INVALID_ASSOCIATION_DECIMAL
988: THEN
989: fnd_message.set_name('PAY', 'HR_377268_SE_INVALID_ASS_DECIM');
990: hr_utility.raise_error;
991: WHEN INVALID_AGREEMENT_NUMBER
992: THEN
993: fnd_message.set_name('PAY', 'HR_377261_SE_AGREEMENT_CODE');
994: hr_utility.raise_error;
990: hr_utility.raise_error;
991: WHEN INVALID_AGREEMENT_NUMBER
992: THEN
993: fnd_message.set_name('PAY', 'HR_377261_SE_AGREEMENT_CODE');
994: hr_utility.raise_error;
995: WHEN INVALID_AGREEMENT_DECIMAL
996: THEN
997: fnd_message.set_name('PAY', 'HR_377269_SE_INVALID_AGR_DECIM');
998: hr_utility.raise_error;
994: hr_utility.raise_error;
995: WHEN INVALID_AGREEMENT_DECIMAL
996: THEN
997: fnd_message.set_name('PAY', 'HR_377269_SE_INVALID_AGR_DECIM');
998: hr_utility.raise_error;
999: WHEN INVALID_AGREEMENT_NUM
1000: THEN
1001: fnd_message.set_name('PAY', 'HR_377271_SE_AGREEMENT_NUMBER');
1002: hr_utility.raise_error;
998: hr_utility.raise_error;
999: WHEN INVALID_AGREEMENT_NUM
1000: THEN
1001: fnd_message.set_name('PAY', 'HR_377271_SE_AGREEMENT_NUMBER');
1002: hr_utility.raise_error;
1003:
1004:
1005: END validate_create_org_inf;
1006:
1513: BEGIN
1514: --
1515: -- Added for GSI Bug 5472781
1516: --
1517: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1518: --
1519:
1520: OPEN getorgid;
1521: FETCH getorgid INTO l_organization_id;
1771: WHEN ENTER_GROUP_BY THEN
1772: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1773: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');
1774: fnd_message.set_token('NAME',l_token, translate => true );
1775: hr_utility.raise_error;
1776:
1777: WHEN ENTER_ALL THEN
1778: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1779: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
1780: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
1781: hr_general.decode_lookup('SE_FORM_LABELS','AMT') || ','||
1782: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
1783: fnd_message.set_token('NAME',l_token, translate => true );
1784: hr_utility.raise_error;
1785: WHEN UNIQUE_AST_NUMBER THEN
1786:
1787: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');
1788: hr_utility.raise_error;
1784: hr_utility.raise_error;
1785: WHEN UNIQUE_AST_NUMBER THEN
1786:
1787: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');
1788: hr_utility.raise_error;
1789:
1790: WHEN UNIQUE_ORG_NUMBER THEN
1791: fnd_message.set_name('PER', 'HR_377214_SE_UNIQUE_ORG_NUMBER');
1792: hr_utility.raise_error;
1788: hr_utility.raise_error;
1789:
1790: WHEN UNIQUE_ORG_NUMBER THEN
1791: fnd_message.set_name('PER', 'HR_377214_SE_UNIQUE_ORG_NUMBER');
1792: hr_utility.raise_error;
1793:
1794:
1795: WHEN UNIQUE_MAIN_LOCAL_UNIT THEN
1796: fnd_message.set_name('PER', 'HR_377208_SE_MAIN_LOCAL_UNIT');
1793:
1794:
1795: WHEN UNIQUE_MAIN_LOCAL_UNIT THEN
1796: fnd_message.set_name('PER', 'HR_377208_SE_MAIN_LOCAL_UNIT');
1797: hr_utility.raise_error;
1798:
1799: WHEN UNIQUE_LOCAL_UNITS THEN
1800: fnd_message.set_name('PER', 'HR_377210_SE_UNIQUE_LOCAL_UNIT');
1801: hr_utility.raise_error;
1797: hr_utility.raise_error;
1798:
1799: WHEN UNIQUE_LOCAL_UNITS THEN
1800: fnd_message.set_name('PER', 'HR_377210_SE_UNIQUE_LOCAL_UNIT');
1801: hr_utility.raise_error;
1802: WHEN UNIQUE_LE_AP
1803: THEN
1804: fnd_message.set_name('PAY', 'HR_377227_SE_LE_UNIQ_MILE_RATE');
1805: hr_utility.raise_error;
1801: hr_utility.raise_error;
1802: WHEN UNIQUE_LE_AP
1803: THEN
1804: fnd_message.set_name('PAY', 'HR_377227_SE_LE_UNIQ_MILE_RATE');
1805: hr_utility.raise_error;
1806:
1807: WHEN INVALID_DATE
1808: THEN
1809: fnd_message.set_name('PAY', 'HR_377228_SE_VALID_DATE');
1806:
1807: WHEN INVALID_DATE
1808: THEN
1809: fnd_message.set_name('PAY', 'HR_377228_SE_VALID_DATE');
1810: hr_utility.raise_error;
1811: WHEN INVALID_TAX
1812: THEN
1813: fnd_message.set_name('PAY', 'HR_377234_SE_TAX_DECL');
1814: hr_utility.raise_error;
1810: hr_utility.raise_error;
1811: WHEN INVALID_TAX
1812: THEN
1813: fnd_message.set_name('PAY', 'HR_377234_SE_TAX_DECL');
1814: hr_utility.raise_error;
1815:
1816: WHEN INVALID_YEAR
1817: THEN
1818: fnd_message.set_name('PAY', 'HR_377236_SE_INVALID_YEAR');
1815:
1816: WHEN INVALID_YEAR
1817: THEN
1818: fnd_message.set_name('PAY', 'HR_377236_SE_INVALID_YEAR');
1819: hr_utility.raise_error;
1820:
1821: WHEN INVALID_DECIMAL
1822: THEN
1823: fnd_message.set_name('PAY', 'HR_377237_SE_INVALID_DECIMAL');
1820:
1821: WHEN INVALID_DECIMAL
1822: THEN
1823: fnd_message.set_name('PAY', 'HR_377237_SE_INVALID_DECIMAL');
1824: hr_utility.raise_error;
1825: WHEN INVALID_CATEGORY
1826: THEN
1827: fnd_message.set_name('PAY', 'HR_377240_SE_INVALID_CATEGORY');
1828: hr_utility.raise_error;
1824: hr_utility.raise_error;
1825: WHEN INVALID_CATEGORY
1826: THEN
1827: fnd_message.set_name('PAY', 'HR_377240_SE_INVALID_CATEGORY');
1828: hr_utility.raise_error;
1829: WHEN INVALID_UPDATE
1830: THEN
1831: fnd_message.set_name('PAY', 'HR_377241_SE_INVALID_UPDATE');
1832: hr_utility.raise_error;
1828: hr_utility.raise_error;
1829: WHEN INVALID_UPDATE
1830: THEN
1831: fnd_message.set_name('PAY', 'HR_377241_SE_INVALID_UPDATE');
1832: hr_utility.raise_error;
1833: WHEN INVALID_INSURANCE_NUMBER
1834: THEN
1835: fnd_message.set_name('PAY', 'HR_377248_SE_INVALID_INSURANCE');
1836: hr_utility.raise_error;
1832: hr_utility.raise_error;
1833: WHEN INVALID_INSURANCE_NUMBER
1834: THEN
1835: fnd_message.set_name('PAY', 'HR_377248_SE_INVALID_INSURANCE');
1836: hr_utility.raise_error;
1837: WHEN INVALID_VALUE
1838: THEN
1839: fnd_message.set_name('PAY', 'HR_377249_SE_INVALID_VALUE');
1840: fnd_message.set_token('X',to_char(l_global_value));
1837: WHEN INVALID_VALUE
1838: THEN
1839: fnd_message.set_name('PAY', 'HR_377249_SE_INVALID_VALUE');
1840: fnd_message.set_token('X',to_char(l_global_value));
1841: hr_utility.raise_error;
1842: WHEN INVALID_INSURANCE_DECIMAL
1843: THEN
1844: fnd_message.set_name('PAY', 'HR_377250_SE_INVALID_INS_DECIM');
1845: hr_utility.raise_error;
1841: hr_utility.raise_error;
1842: WHEN INVALID_INSURANCE_DECIMAL
1843: THEN
1844: fnd_message.set_name('PAY', 'HR_377250_SE_INVALID_INS_DECIM');
1845: hr_utility.raise_error;
1846: WHEN UNIQUE_YEAR
1847: THEN
1848: fnd_message.set_name('PER', 'HR_377270_SE_STD_WORK_YEAR');
1849: hr_utility.raise_error;
1845: hr_utility.raise_error;
1846: WHEN UNIQUE_YEAR
1847: THEN
1848: fnd_message.set_name('PER', 'HR_377270_SE_STD_WORK_YEAR');
1849: hr_utility.raise_error;
1850: WHEN INVALID_MEMBERSHIP_NUMBER
1851: THEN
1852: fnd_message.set_name('PAY', 'HR_377263_SE_INVALID_MEMBER');
1853: hr_utility.raise_error;
1849: hr_utility.raise_error;
1850: WHEN INVALID_MEMBERSHIP_NUMBER
1851: THEN
1852: fnd_message.set_name('PAY', 'HR_377263_SE_INVALID_MEMBER');
1853: hr_utility.raise_error;
1854: WHEN INVALID_MEMBERSHIP_DECIMAL
1855: THEN
1856: fnd_message.set_name('PAY', 'HR_377264_SE_INVALID_MEM_DECIM');
1857: hr_utility.raise_error;
1853: hr_utility.raise_error;
1854: WHEN INVALID_MEMBERSHIP_DECIMAL
1855: THEN
1856: fnd_message.set_name('PAY', 'HR_377264_SE_INVALID_MEM_DECIM');
1857: hr_utility.raise_error;
1858: WHEN INVALID_WORK_NUMBER
1859: THEN
1860: fnd_message.set_name('PAY', 'HR_377265_SE_INVALID_WORK');
1861: hr_utility.raise_error;
1857: hr_utility.raise_error;
1858: WHEN INVALID_WORK_NUMBER
1859: THEN
1860: fnd_message.set_name('PAY', 'HR_377265_SE_INVALID_WORK');
1861: hr_utility.raise_error;
1862: WHEN INVALID_WORK_DECIMAL
1863: THEN
1864: fnd_message.set_name('PAY', 'HR_377266_SE_INVALID_WOR_DECIM');
1865: hr_utility.raise_error;
1861: hr_utility.raise_error;
1862: WHEN INVALID_WORK_DECIMAL
1863: THEN
1864: fnd_message.set_name('PAY', 'HR_377266_SE_INVALID_WOR_DECIM');
1865: hr_utility.raise_error;
1866: WHEN INVALID_ASSOCIATION_NUMBER
1867: THEN
1868: fnd_message.set_name('PAY', 'HR_377267_SE_INVALID_ASSOCIAT');
1869: hr_utility.raise_error;
1865: hr_utility.raise_error;
1866: WHEN INVALID_ASSOCIATION_NUMBER
1867: THEN
1868: fnd_message.set_name('PAY', 'HR_377267_SE_INVALID_ASSOCIAT');
1869: hr_utility.raise_error;
1870: WHEN INVALID_ASSOCIATION_DECIMAL
1871: THEN
1872: fnd_message.set_name('PAY', 'HR_377268_SE_INVALID_ASS_DECIM');
1873: hr_utility.raise_error;
1869: hr_utility.raise_error;
1870: WHEN INVALID_ASSOCIATION_DECIMAL
1871: THEN
1872: fnd_message.set_name('PAY', 'HR_377268_SE_INVALID_ASS_DECIM');
1873: hr_utility.raise_error;
1874: WHEN INVALID_AGREEMENT_NUMBER
1875: THEN
1876: fnd_message.set_name('PAY', 'HR_377261_SE_AGREEMENT_CODE');
1877: hr_utility.raise_error;
1873: hr_utility.raise_error;
1874: WHEN INVALID_AGREEMENT_NUMBER
1875: THEN
1876: fnd_message.set_name('PAY', 'HR_377261_SE_AGREEMENT_CODE');
1877: hr_utility.raise_error;
1878: WHEN INVALID_AGREEMENT_DECIMAL
1879: THEN
1880: fnd_message.set_name('PAY', 'HR_377269_SE_INVALID_AGR_DECIM');
1881: hr_utility.raise_error;
1877: hr_utility.raise_error;
1878: WHEN INVALID_AGREEMENT_DECIMAL
1879: THEN
1880: fnd_message.set_name('PAY', 'HR_377269_SE_INVALID_AGR_DECIM');
1881: hr_utility.raise_error;
1882: WHEN INVALID_AGREEMENT_NUM
1883: THEN
1884: fnd_message.set_name('PAY', 'HR_377271_SE_AGREEMENT_NUMBER');
1885: hr_utility.raise_error;
1881: hr_utility.raise_error;
1882: WHEN INVALID_AGREEMENT_NUM
1883: THEN
1884: fnd_message.set_name('PAY', 'HR_377271_SE_AGREEMENT_NUMBER');
1885: hr_utility.raise_error;
1886:
1887:
1888:
1889: END validate_update_org_inf;
1906: IF p_token IS NOT NULL
1907: THEN
1908: fnd_message.set_name('PER', 'HR_377207_SE_INVALID_FORMAT');
1909: fnd_message.set_token('NAME',p_token, translate => true );
1910: hr_utility.raise_error;
1911: ELSE
1912: fnd_message.set_name('PER', p_message);
1913: hr_utility.raise_error;
1914: END IF ;
1909: fnd_message.set_token('NAME',p_token, translate => true );
1910: hr_utility.raise_error;
1911: ELSE
1912: fnd_message.set_name('PER', p_message);
1913: hr_utility.raise_error;
1914: END IF ;
1915:
1916: END IF;
1917: END IF;
1938: BEGIN
1939: --
1940: -- Added for GSI Bug 5472781
1941: --
1942: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1943: --
1944: OPEN get_int_or_ext_flag;
1945: FETCH get_int_or_ext_flag INTO l_internal_external_flag;
1946: CLOSE get_int_or_ext_flag;
1956: EXCEPTION
1957: WHEN INT_EXT_EXCEPTION
1958: THEN
1959: fnd_message.set_name('PER', 'HR_377211_SE_SOC_SEC_OFFICE');
1960: hr_utility.raise_error;
1961: END CREATE_ORG_CLASS_VALIDATE;
1962: ---
1963:
1964:
1972: BEGIN
1973: --
1974: -- Added for GSI Bug 5472781
1975: --
1976: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1977: --
1978:
1979: IF (p_scl_segment5 IS NOT NULL AND p_scl_segment5 <> hr_api.g_varchar2)
1980: AND (p_scl_segment6 IS NOT NULL AND p_scl_segment6 <> hr_api.g_varchar2) THEN
1988: EXCEPTION
1989: WHEN VALID_NOTIFY_DATE
1990: THEN
1991: fnd_message.set_name('PER', 'HR_377212_SE_VALID_NOTIFY_DATE');
1992: hr_utility.raise_error;
1993:
1994: END CREATE_ASG_VALIDATE;
1995:
1996: -- End OF Create_Asg_validate
2006: BEGIN
2007: --
2008: -- Added for GSI Bug 5472781
2009: --
2010: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
2011: --
2012:
2013: IF (p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2)
2014: AND (p_segment6 IS NOT NULL AND p_segment6 <> hr_api.g_varchar2) THEN
2022:
2023: EXCEPTION
2024: WHEN VALID_NOTIFY_DATE THEN
2025: fnd_message.set_name('PER', 'HR_377212_SE_VALID_NOTIFY_DATE');
2026: hr_utility.raise_error;
2027:
2028: END UPDATE_ASG_VALIDATE ;
2029:
2030: -- End Of UPDATE_ASG_VALIDATE