36:
37: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN
38: fnd_message.set_name('PER', 'HR_376603_FI_MANDATORY_MSG');
39: fnd_message.set_token('NAME',l_field, translate => true );
40: hr_utility.raise_error;
41: END IF;
42: IF p_date_of_birth IS NOT NULL AND p_per_information8 IS NOT NULL THEN
43: BEGIN
44: l_date:= fnd_date.canonical_to_date(p_per_information8);
43: BEGIN
44: l_date:= fnd_date.canonical_to_date(p_per_information8);
45: IF p_date_of_birth >= l_date THEN
46: fnd_message.set_name('PER', 'HR_376609_FI_INVALID_DATE');
47: hr_utility.raise_error;
48: END IF;
49: EXCEPTION
50: WHEN OTHERS THEN
51: NULL;
64: BEGIN
65: --
66: -- Added for GSI Bug 5472781
67: --
68: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
69: --
70: validate
71: (p_person_type_id => p_person_type_id
72: ,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', 'FI') 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
121: BEGIN
122: --
123: -- Added for GSI Bug 5472781
124: --
125: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
126: --
127: per_per_bus.chk_person_type
128: (p_person_type_id => l_person_type_id
129: ,p_business_group_id => p_business_group_id
152: BEGIN
153: --
154: -- Added for GSI Bug 5472781
155: --
156: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
157: --
158: per_per_bus.chk_person_type
159: (p_person_type_id => l_person_type_id
160: ,p_business_group_id => p_business_group_id
182: BEGIN
183: --
184: -- Added for GSI Bug 5472781
185: --
186: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
187: --
188: IF substr(p_qua_information1,1,1) not in ('0','1','2','3','4','5','6','7','9') OR substr(p_qua_information1,2,1) not in ('0','1','2','3','4','5','6','7','8','9') THEN
189: fnd_message.set_name('PER', 'HR_376605_FI_EDUCATION_CODE');
190: hr_utility.raise_error;
186: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
187: --
188: IF substr(p_qua_information1,1,1) not in ('0','1','2','3','4','5','6','7','9') OR substr(p_qua_information1,2,1) not in ('0','1','2','3','4','5','6','7','8','9') THEN
189: fnd_message.set_name('PER', 'HR_376605_FI_EDUCATION_CODE');
190: hr_utility.raise_error;
191: END IF;
192:
193: IF p_qua_information1 is not null and length(p_qua_information1) not in (2,6) THEN
194: fnd_message.set_name('PER', 'HR_376608_FI_EC_INVALID_LENGTH');
191: END IF;
192:
193: IF p_qua_information1 is not null and length(p_qua_information1) not in (2,6) THEN
194: fnd_message.set_name('PER', 'HR_376608_FI_EC_INVALID_LENGTH');
195: hr_utility.raise_error;
196: END IF;
197: validate_number(p_qua_information1,NULL,'HR_376605_FI_EDUCATION_CODE');
198: IF p_qua_information2 ='Y' THEN
199: select count(*)
204: and pq.qua_information_category='FI'
205: and pq.qua_information2='Y';
206: IF l_count > 0 then
207: fnd_message.set_name('PER', 'HR_376606_FI_PREFERRED_LEVEL');
208: hr_utility.raise_error;
209: END IF;
210: END IF ;
211: END IF;
212: END qual_insert_validate;
230: BEGIN
231: --
232: -- Added for GSI Bug 5472781
233: --
234: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
235: --
236: IF substr(p_qua_information1,1,1) not in ('0','1','2','3','4','5','6','7','9') OR substr(p_qua_information1,2,1) not in ('0','1','2','3','4','5','6','7','8','9') THEN
237: fnd_message.set_name('PER', 'HR_376605_FI_EDUCATION_CODE');
238: hr_utility.raise_error;
234: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
235: --
236: IF substr(p_qua_information1,1,1) not in ('0','1','2','3','4','5','6','7','9') OR substr(p_qua_information1,2,1) not in ('0','1','2','3','4','5','6','7','8','9') THEN
237: fnd_message.set_name('PER', 'HR_376605_FI_EDUCATION_CODE');
238: hr_utility.raise_error;
239: END IF;
240: validate_number(p_qua_information1,NULL,'HR_376605_FI_EDUCATION_CODE');
241: IF p_qua_information1 is not null and length(p_qua_information1) not in (2,6) THEN
242: fnd_message.set_name('PER', 'HR_376608_FI_EC_INVALID_LENGTH');
239: END IF;
240: validate_number(p_qua_information1,NULL,'HR_376605_FI_EDUCATION_CODE');
241: IF p_qua_information1 is not null and length(p_qua_information1) not in (2,6) THEN
242: fnd_message.set_name('PER', 'HR_376608_FI_EC_INVALID_LENGTH');
243: hr_utility.raise_error;
244: END IF;
245: IF p_qua_information2 ='Y' THEN
246: l_person_id := NULL;
247: OPEN c_person_id;
258: and pq.qua_information2='Y';
259:
260: IF l_count > 0 then
261: fnd_message.set_name('PER', 'HR_376606_FI_PREFERRED_LEVEL');
262: hr_utility.raise_error;
263: END IF;
264:
265: END IF;
266: END IF;
481: BEGIN
482: --
483: -- Added for GSI Bug 5472781
484: --
485: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
486: --
487:
488: OPEN getbgid;
489: FETCH getbgid INTO l_business_group_id;
597: EXCEPTION
598: WHEN OTHERS
599: THEN
600: fnd_message.set_name('PAY', 'HR_FI_INVALID_NATIONAL_ID');
601: hr_utility.raise_error;
602: END ;
603: END IF;
604: -- End Of PIN --
605: END IF ; -- end of FI_EXTERNAL_COMPANY_DETAILS
968:
969: l_field := hr_general.decode_lookup('FI_FORM_LABELS','ACC_INS_POLICY');
970: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
971: fnd_message.set_token('NAME',l_field, translate => true );
972: hr_utility.raise_error;
973:
974: WHEN INVALID_Y_NUMBER_FORMAT
975: THEN
976:
976:
977: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
978: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
979: fnd_message.set_token('NAME',l_field, translate => true );
980: hr_utility.raise_error;
981:
982: WHEN INVALID_PP_CUSTOMER_NUM_FORMAT
983: THEN
984: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');
983: THEN
984: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');
985: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
986: fnd_message.set_token('NAME',l_field, translate => true );
987: hr_utility.raise_error;
988:
989: WHEN INVALID_PIP_NUMBER_FORMAT
990: THEN
991: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');
990: THEN
991: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');
992: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
993: fnd_message.set_token('NAME',l_field, translate => true );
994: hr_utility.raise_error;
995:
996: WHEN UNIQUE_LOCAL_UNITS
997: THEN
998:
996: WHEN UNIQUE_LOCAL_UNITS
997: THEN
998:
999: fnd_message.set_name('PER', 'HR_376614_FI_UNIQUE_LOCAL_UNIT');
1000: hr_utility.raise_error;
1001:
1002: WHEN UNIQUE_Y_NUMBER
1003: THEN
1004: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
1003: THEN
1004: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
1005: fnd_message.set_name('PER', 'HR_376613_FI_UNIQUE_MSG');
1006: fnd_message.set_token('NAME',l_field, translate => true );
1007: hr_utility.raise_error;
1008: WHEN UNIQUE_DEPT_CODE
1009: THEN
1010:
1011: fnd_message.set_name('PAY', 'HR_376630_FI_UNIQUE_DEPT_CODE');
1008: WHEN UNIQUE_DEPT_CODE
1009: THEN
1010:
1011: fnd_message.set_name('PAY', 'HR_376630_FI_UNIQUE_DEPT_CODE');
1012: hr_utility.raise_error;
1013:
1014: WHEN UNIQUE_GROUP_CODE
1015: THEN
1016:
1014: WHEN UNIQUE_GROUP_CODE
1015: THEN
1016:
1017: fnd_message.set_name('PAY', 'HR_376632_FI_UNIQUE_GROUP_CODE');
1018: hr_utility.raise_error;
1019:
1020: WHEN UNIQUE_PENSION_TYPE
1021: THEN
1022:
1020: WHEN UNIQUE_PENSION_TYPE
1021: THEN
1022:
1023: fnd_message.set_name('PAY', 'HR_376647_FI_UNIQ_PENSION_TYPE');
1024: hr_utility.raise_error;
1025:
1026: WHEN UNIQUE_LE_LC
1027: THEN
1028:
1026: WHEN UNIQUE_LE_LC
1027: THEN
1028:
1029: fnd_message.set_name('PAY', 'HR_376631_FI_UNIQUE_LE_LC');
1030: hr_utility.raise_error;
1031:
1032:
1033: WHEN UNIQUE_LE_AP
1034: THEN
1033: WHEN UNIQUE_LE_AP
1034: THEN
1035:
1036: fnd_message.set_name('PAY', 'HR_376638_FI_UNIQUE_ACC_PROV');
1037: hr_utility.raise_error;
1038: WHEN UNIQUE_LU_AP
1039: THEN
1040:
1041: fnd_message.set_name('PAY', 'HR_376645_FI_LU_UNIQ_ACC_PROV');
1038: WHEN UNIQUE_LU_AP
1039: THEN
1040:
1041: fnd_message.set_name('PAY', 'HR_376645_FI_LU_UNIQ_ACC_PROV');
1042: hr_utility.raise_error;
1043: WHEN INVALID_DATE
1044: THEN
1045:
1046: fnd_message.set_name('PAY', 'HR_376639_FI_VALID_DATE');
1043: WHEN INVALID_DATE
1044: THEN
1045:
1046: fnd_message.set_name('PAY', 'HR_376639_FI_VALID_DATE');
1047: hr_utility.raise_error;
1048:
1049: WHEN INVALID_TYEL_GROUP
1050: THEN
1051:
1049: WHEN INVALID_TYEL_GROUP
1050: THEN
1051:
1052: fnd_message.set_name('PAY', 'HR_376648_FI_TEL_GROUP_DTLS');
1053: hr_utility.raise_error;
1054:
1055: WHEN UNIQUE_PENSION_INS_NUM
1056: THEN
1057: fnd_message.set_name('PAY', 'HR_376650_FI_UNIQ_PEN_INS_NUM');
1054:
1055: WHEN UNIQUE_PENSION_INS_NUM
1056: THEN
1057: fnd_message.set_name('PAY', 'HR_376650_FI_UNIQ_PEN_INS_NUM');
1058: hr_utility.raise_error;
1059:
1060: WHEN UNIQUE_LU_PENSION_INS_NUM
1061: THEN
1062: fnd_message.set_name('PAY', 'HR_376651_FI_LU_PEN_INS_NUM');
1059:
1060: WHEN UNIQUE_LU_PENSION_INS_NUM
1061: THEN
1062: fnd_message.set_name('PAY', 'HR_376651_FI_LU_PEN_INS_NUM');
1063: hr_utility.raise_error;
1064:
1065: WHEN UNIQUE_PG_DTLS_PG
1066: THEN
1067: fnd_message.set_name('PAY', 'HR_376649_FI_LEL_TAEL_GROUP');
1064:
1065: WHEN UNIQUE_PG_DTLS_PG
1066: THEN
1067: fnd_message.set_name('PAY', 'HR_376649_FI_LEL_TAEL_GROUP');
1068: hr_utility.raise_error;
1069:
1070: WHEN UNIQUE_PENSION_USER_PT
1071: THEN
1072: fnd_message.set_name('PAY', 'HR_376654_FI_LE_TEL_GROUP_DTLS');
1069:
1070: WHEN UNIQUE_PENSION_USER_PT
1071: THEN
1072: fnd_message.set_name('PAY', 'HR_376654_FI_LE_TEL_GROUP_DTLS');
1073: hr_utility.raise_error;
1074:
1075:
1076: END validate_create_org_inf;
1077:
1303: BEGIN
1304: --
1305: -- Added for GSI Bug 5472781
1306: --
1307: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1308: --
1309: OPEN getorgid;
1310: FETCH getorgid INTO l_organization_id;
1311: CLOSE getorgid;
1321: CLOSE orglocalunit;
1322: IF l_count > 0
1323: THEN
1324: fnd_message.set_name('PER', 'Update');
1325: hr_utility.raise_error;
1326:
1327: RAISE UNIQUE_LOCAL_UNITS ;
1328: END IF ;
1329:
1428: EXCEPTION
1429: WHEN OTHERS
1430: THEN
1431: fnd_message.set_name('PAY', 'HR_FI_INVALID_NATIONAL_ID');
1432: hr_utility.raise_error;
1433: END ;
1434: END IF;
1435: -- End Of PIN --
1436: END IF; -- end of FI_EXTERNAL_COMPANY_DETAILS
1801:
1802: l_field := hr_general.decode_lookup('FI_FORM_LABELS','ACC_INS_POLICY');
1803: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1804: fnd_message.set_token('NAME',l_field, translate => true );
1805: hr_utility.raise_error;
1806:
1807: WHEN INVALID_Y_NUMBER_FORMAT
1808: THEN
1809:
1809:
1810: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
1811: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1812: fnd_message.set_token('NAME',l_field, translate => true );
1813: hr_utility.raise_error;
1814:
1815: WHEN INVALID_PP_CUSTOMER_NUM_FORMAT
1816: THEN
1817: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');
1816: THEN
1817: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');
1818: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1819: fnd_message.set_token('NAME',l_field, translate => true );
1820: hr_utility.raise_error;
1821:
1822: WHEN INVALID_PIP_NUMBER_FORMAT
1823: THEN
1824: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');
1823: THEN
1824: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');
1825: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1826: fnd_message.set_token('NAME',l_field, translate => true );
1827: hr_utility.raise_error;
1828:
1829: WHEN UNIQUE_LOCAL_UNITS
1830: THEN
1831: fnd_message.set_name('PER', 'HR_376614_FI_UNIQUE_LOCAL_UNIT');
1828:
1829: WHEN UNIQUE_LOCAL_UNITS
1830: THEN
1831: fnd_message.set_name('PER', 'HR_376614_FI_UNIQUE_LOCAL_UNIT');
1832: hr_utility.raise_error;
1833:
1834: WHEN UNIQUE_Y_NUMBER
1835: THEN
1836: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
1835: THEN
1836: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
1837: fnd_message.set_name('PER', 'HR_376613_FI_UNIQUE_MSG');
1838: fnd_message.set_token('NAME',l_field, translate => true );
1839: hr_utility.raise_error;
1840: WHEN UNIQUE_DEPT_CODE
1841: THEN
1842:
1843: fnd_message.set_name('PAY', 'HR_376630_FI_UNIQUE_DEPT_CODE');
1840: WHEN UNIQUE_DEPT_CODE
1841: THEN
1842:
1843: fnd_message.set_name('PAY', 'HR_376630_FI_UNIQUE_DEPT_CODE');
1844: hr_utility.raise_error;
1845:
1846: WHEN UNIQUE_GROUP_CODE
1847: THEN
1848:
1846: WHEN UNIQUE_GROUP_CODE
1847: THEN
1848:
1849: fnd_message.set_name('PAY', 'HR_376632_FI_UNIQUE_GROUP_CODE');
1850: hr_utility.raise_error;
1851:
1852: WHEN UNIQUE_PENSION_TYPE
1853: THEN
1854:
1852: WHEN UNIQUE_PENSION_TYPE
1853: THEN
1854:
1855: fnd_message.set_name('PAY', 'HR_376647_FI_UNIQ_PENSION_TYPE');
1856: hr_utility.raise_error;
1857:
1858:
1859: WHEN UNIQUE_LE_LC
1860: THEN
1859: WHEN UNIQUE_LE_LC
1860: THEN
1861:
1862: fnd_message.set_name('PAY', 'HR_376631_FI_UNIQUE_LE_LC');
1863: hr_utility.raise_error;
1864:
1865: WHEN UNIQUE_LE_AP
1866: THEN
1867:
1865: WHEN UNIQUE_LE_AP
1866: THEN
1867:
1868: fnd_message.set_name('PAY', 'HR_376638_FI_UNIQUE_ACC_PROV');
1869: hr_utility.raise_error;
1870:
1871: WHEN UNIQUE_LU_AP
1872: THEN
1873:
1871: WHEN UNIQUE_LU_AP
1872: THEN
1873:
1874: fnd_message.set_name('PAY', 'HR_376645_FI_LU_UNIQ_ACC_PROV');
1875: hr_utility.raise_error;
1876:
1877: WHEN INVALID_DATE
1878: THEN
1879:
1877: WHEN INVALID_DATE
1878: THEN
1879:
1880: fnd_message.set_name('PAY', 'HR_376639_FI_VALID_DATE');
1881: hr_utility.raise_error;
1882:
1883: WHEN INVALID_TYEL_GROUP
1884: THEN
1885:
1883: WHEN INVALID_TYEL_GROUP
1884: THEN
1885:
1886: fnd_message.set_name('PAY', 'HR_376648_FI_TEL_GROUP_DTLS');
1887: hr_utility.raise_error;
1888:
1889:
1890: WHEN UNIQUE_PENSION_INS_NUM
1891: THEN
1889:
1890: WHEN UNIQUE_PENSION_INS_NUM
1891: THEN
1892: fnd_message.set_name('PAY', 'HR_376650_FI_UNIQ_PEN_INS_NUM');
1893: hr_utility.raise_error;
1894:
1895: WHEN UNIQUE_LU_PENSION_INS_NUM
1896: THEN
1897: fnd_message.set_name('PAY', 'HR_376651_FI_LU_PEN_INS_NUM');
1894:
1895: WHEN UNIQUE_LU_PENSION_INS_NUM
1896: THEN
1897: fnd_message.set_name('PAY', 'HR_376651_FI_LU_PEN_INS_NUM');
1898: hr_utility.raise_error;
1899:
1900:
1901: WHEN UNIQUE_PG_DTLS_PG
1902: THEN
1900:
1901: WHEN UNIQUE_PG_DTLS_PG
1902: THEN
1903: fnd_message.set_name('PAY', 'HR_376649_FI_LEL_TAEL_GROUP');
1904: hr_utility.raise_error;
1905:
1906: WHEN UNIQUE_PENSION_USER_PT
1907: THEN
1908: fnd_message.set_name('PAY', 'HR_376654_FI_LE_TEL_GROUP_DTLS');
1905:
1906: WHEN UNIQUE_PENSION_USER_PT
1907: THEN
1908: fnd_message.set_name('PAY', 'HR_376654_FI_LE_TEL_GROUP_DTLS');
1909: hr_utility.raise_error;
1910:
1911: END validate_update_org_inf;
1912:
1913: --- End Of validate_update_org_inf
1978: BEGIN
1979: --
1980: -- Added for GSI Bug 5472781
1981: --
1982: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1983: --
1984: OPEN getbgid;
1985: FETCH getbgid INTO l_business_group_id;
1986: CLOSE getbgid;
2009: EXCEPTION
2010: WHEN UNIQUE_RPT_ASG
2011: THEN
2012: fnd_message.set_name('PER', 'HR_376610_FI_UNIQUE_RPT_ASG');
2013: hr_utility.raise_error;
2014:
2015: END CREATE_ASG_VALIDATE;
2016:
2017: -- End OF Create_Asg_validate
2089: BEGIN
2090: --
2091: -- Added for GSI Bug 5472781
2092: --
2093: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2094: --
2095: OPEN c_person;
2096: LOOP
2097: FETCH c_person INTO l_person_id;
2126: EXCEPTION
2127: WHEN UNIQUE_RPT_ASG
2128: THEN
2129: fnd_message.set_name('PER', 'HR_376610_FI_UNIQUE_RPT_ASG');
2130: hr_utility.raise_error;
2131:
2132: END UPDATE_ASG_VALIDATE ;
2133:
2134: -- End Of UPDATE_ASG_VALIDATE
2140: BEGIN
2141: --
2142: -- Added for GSI Bug 5472781
2143: --
2144: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2145: --
2146: IF p_leaving_reason IS NULL THEN
2147: fnd_message.set_name('PER', 'HR_376603_FI_MANDATORY_MSG');
2148: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','L_REASON'), translate => true );
2145: --
2146: IF p_leaving_reason IS NULL THEN
2147: fnd_message.set_name('PER', 'HR_376603_FI_MANDATORY_MSG');
2148: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','L_REASON'), translate => true );
2149: hr_utility.raise_error;
2150: END IF;
2151: END IF;
2152: END UPDATE_TERMINATION_VALIDATE ;
2153:
2179: BEGIN
2180: --
2181: -- Added for GSI Bug 5472781
2182: --
2183: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2184: --
2185: OPEN get_int_or_ext_flag;
2186: FETCH get_int_or_ext_flag INTO l_internal_external_flag;
2187: CLOSE get_int_or_ext_flag;
2211: EXCEPTION
2212: WHEN EXT_COMP_EXCEPTION
2213: THEN
2214: fnd_message.set_name('PER', 'HR_376615_FI_EXT_COMPANY');
2215: hr_utility.raise_error;
2216: WHEN PEN_PROV_EXCEPTION
2217: THEN
2218: fnd_message.set_name('PAY', 'HR_376628_FI_PEN_PROVIDER');
2219: hr_utility.raise_error;
2215: hr_utility.raise_error;
2216: WHEN PEN_PROV_EXCEPTION
2217: THEN
2218: fnd_message.set_name('PAY', 'HR_376628_FI_PEN_PROVIDER');
2219: hr_utility.raise_error;
2220: WHEN ACC_PROV_EXCEPTION
2221: THEN
2222: fnd_message.set_name('PAY', 'HR_376629_FI_ACC_INS_PROVIDER');
2223: hr_utility.raise_error;
2219: hr_utility.raise_error;
2220: WHEN ACC_PROV_EXCEPTION
2221: THEN
2222: fnd_message.set_name('PAY', 'HR_376629_FI_ACC_INS_PROVIDER');
2223: hr_utility.raise_error;
2224:
2225: WHEN PROV_TAX_EXCEPTION
2226: THEN
2227: fnd_message.set_name('PAY', 'HR_376635_FI_PROV_TAX_OFFICE');
2224:
2225: WHEN PROV_TAX_EXCEPTION
2226: THEN
2227: fnd_message.set_name('PAY', 'HR_376635_FI_PROV_TAX_OFFICE');
2228: hr_utility.raise_error;
2229:
2230:
2231: END CREATE_ORG_CLASS_VALIDATE;
2232: ---
2260: IF p_token IS NOT NULL AND p_message IS NULL
2261: THEN
2262: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
2263: fnd_message.set_token('NAME',p_token, translate => true );
2264: hr_utility.raise_error;
2265: ELSIF p_message IS NOT NULL
2266: THEN
2267: fnd_message.set_name('PER', p_message);
2268: fnd_message.set_token('NAME',p_token, translate => true );
2265: ELSIF p_message IS NOT NULL
2266: THEN
2267: fnd_message.set_name('PER', p_message);
2268: fnd_message.set_token('NAME',p_token, translate => true );
2269: hr_utility.raise_error;
2270: END IF ;
2271:
2272: END IF;
2273: END IF;
2297: BEGIN
2298: --
2299: -- Added for GSI Bug 5472781
2300: --
2301: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2302: --
2303: -- get the values of the person_id profile
2304: fnd_profile.put('PER_PERSON_ID',p_person_id);
2305: if p_abs_information_category='FI_F' THEN
2308: CLOSE get_start_date;
2309:
2310: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN
2311: fnd_message.set_name('PAY', 'HR_376663_FI_MATERNITY_DATE');
2312: hr_utility.raise_error;
2313: END IF;
2314: END IF;
2315: END IF;
2316:
2345: BEGIN
2346: --
2347: -- Added for GSI Bug 5472781
2348: --
2349: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2350: --
2351: open get_person_id(p_absence_attendance_id);
2352: fetch get_person_id into l_person_id;
2353: close get_person_id;
2361: CLOSE get_start_date;
2362:
2363: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN
2364: fnd_message.set_name('PAY', 'HR_376663_FI_MATERNITY_DATE');
2365: hr_utility.raise_error;
2366: END IF;
2367: END IF;
2368: END IF;
2369: END PERSON_ABSENCE_UPDATE;