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_UTILITY

Line 45: hr_utility.raise_error;

41:
42: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN
43: fnd_message.set_name('PER', 'HR_376603_FI_MANDATORY_MSG');
44: fnd_message.set_token('NAME',l_field, translate => true );
45: hr_utility.raise_error;
46: END IF;
47: IF p_date_of_birth IS NOT NULL AND p_per_information8 IS NOT NULL THEN
48: BEGIN
49: l_date:= fnd_date.canonical_to_date(p_per_information8);

Line 52: hr_utility.raise_error;

48: BEGIN
49: l_date:= fnd_date.canonical_to_date(p_per_information8);
50: IF p_date_of_birth >= l_date THEN
51: fnd_message.set_name('PER', 'HR_376609_FI_INVALID_DATE');
52: hr_utility.raise_error;
53: END IF;
54: EXCEPTION
55: WHEN OTHERS THEN
56: NULL;

Line 73: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

69: BEGIN
70: --
71: -- Added for GSI Bug 5472781
72: --
73: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
74: --
75: validate
76: (p_person_type_id => p_person_type_id
77: ,p_first_name => p_first_name

Line 99: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

95: BEGIN
96: --
97: -- Added for GSI Bug 5472781
98: --
99: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
100: --
101: per_per_bus.chk_person_type
102: (p_person_type_id => l_person_type_id
103: ,p_business_group_id => p_business_group_id

Line 130: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

126: BEGIN
127: --
128: -- Added for GSI Bug 5472781
129: --
130: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
131: --
132: per_per_bus.chk_person_type
133: (p_person_type_id => l_person_type_id
134: ,p_business_group_id => p_business_group_id

Line 161: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

157: BEGIN
158: --
159: -- Added for GSI Bug 5472781
160: --
161: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
162: --
163: per_per_bus.chk_person_type
164: (p_person_type_id => l_person_type_id
165: ,p_business_group_id => p_business_group_id

Line 191: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

187: BEGIN
188: --
189: -- Added for GSI Bug 5472781
190: --
191: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
192: --
193: 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
194: fnd_message.set_name('PER', 'HR_376605_FI_EDUCATION_CODE');
195: hr_utility.raise_error;

Line 195: hr_utility.raise_error;

191: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
192: --
193: 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
194: fnd_message.set_name('PER', 'HR_376605_FI_EDUCATION_CODE');
195: hr_utility.raise_error;
196: END IF;
197:
198: IF p_qua_information1 is not null and length(p_qua_information1) not in (2,6) THEN
199: fnd_message.set_name('PER', 'HR_376608_FI_EC_INVALID_LENGTH');

Line 200: hr_utility.raise_error;

196: END IF;
197:
198: IF p_qua_information1 is not null and length(p_qua_information1) not in (2,6) THEN
199: fnd_message.set_name('PER', 'HR_376608_FI_EC_INVALID_LENGTH');
200: hr_utility.raise_error;
201: END IF;
202: validate_number(p_qua_information1,NULL,'HR_376605_FI_EDUCATION_CODE');
203: IF p_qua_information2 ='Y' THEN
204: select count(*)

Line 213: hr_utility.raise_error;

209: and pq.qua_information_category='FI'
210: and pq.qua_information2='Y';
211: IF l_count > 0 then
212: fnd_message.set_name('PER', 'HR_376606_FI_PREFERRED_LEVEL');
213: hr_utility.raise_error;
214: END IF;
215: END IF ;
216: END IF;
217: END qual_insert_validate;

Line 239: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

235: BEGIN
236: --
237: -- Added for GSI Bug 5472781
238: --
239: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
240: --
241: 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
242: fnd_message.set_name('PER', 'HR_376605_FI_EDUCATION_CODE');
243: hr_utility.raise_error;

Line 243: hr_utility.raise_error;

239: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
240: --
241: 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
242: fnd_message.set_name('PER', 'HR_376605_FI_EDUCATION_CODE');
243: hr_utility.raise_error;
244: END IF;
245: validate_number(p_qua_information1,NULL,'HR_376605_FI_EDUCATION_CODE');
246: IF p_qua_information1 is not null and length(p_qua_information1) not in (2,6) THEN
247: fnd_message.set_name('PER', 'HR_376608_FI_EC_INVALID_LENGTH');

Line 248: hr_utility.raise_error;

244: END IF;
245: validate_number(p_qua_information1,NULL,'HR_376605_FI_EDUCATION_CODE');
246: IF p_qua_information1 is not null and length(p_qua_information1) not in (2,6) THEN
247: fnd_message.set_name('PER', 'HR_376608_FI_EC_INVALID_LENGTH');
248: hr_utility.raise_error;
249: END IF;
250: IF p_qua_information2 ='Y' THEN
251: l_person_id := NULL;
252: OPEN c_person_id;

Line 267: hr_utility.raise_error;

263: and pq.qua_information2='Y';
264:
265: IF l_count > 0 then
266: fnd_message.set_name('PER', 'HR_376606_FI_PREFERRED_LEVEL');
267: hr_utility.raise_error;
268: END IF;
269:
270: END IF;
271: END IF;

Line 490: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

486: BEGIN
487: --
488: -- Added for GSI Bug 5472781
489: --
490: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
491: --
492:
493: OPEN getbgid;
494: FETCH getbgid INTO l_business_group_id;

Line 606: hr_utility.raise_error;

602: EXCEPTION
603: WHEN OTHERS
604: THEN
605: fnd_message.set_name('PAY', 'HR_FI_INVALID_NATIONAL_ID');
606: hr_utility.raise_error;
607: END ;
608: END IF;
609: -- End Of PIN --
610: END IF ; -- end of FI_EXTERNAL_COMPANY_DETAILS

Line 986: hr_utility.raise_error;

982:
983: l_field := hr_general.decode_lookup('FI_FORM_LABELS','ACC_INS_POLICY');
984: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
985: fnd_message.set_token('NAME',l_field, translate => true );
986: hr_utility.raise_error;
987:
988: WHEN INVALID_Y_NUMBER_FORMAT
989: THEN
990:

Line 994: hr_utility.raise_error;

990:
991: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
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 INVALID_PP_CUSTOMER_NUM_FORMAT
997: THEN
998: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');

Line 1001: hr_utility.raise_error;

997: THEN
998: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');
999: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1000: fnd_message.set_token('NAME',l_field, translate => true );
1001: hr_utility.raise_error;
1002:
1003: /* WHEN INVALID_PIP_NUMBER_FORMAT - bug fix 7600677
1004: THEN
1005: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');

Line 1008: hr_utility.raise_error;*/

1004: THEN
1005: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');
1006: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1007: fnd_message.set_token('NAME',l_field, translate => true );
1008: hr_utility.raise_error;*/
1009:
1010: WHEN UNIQUE_LOCAL_UNITS
1011: THEN
1012:

Line 1014: hr_utility.raise_error;

1010: WHEN UNIQUE_LOCAL_UNITS
1011: THEN
1012:
1013: fnd_message.set_name('PER', 'HR_376614_FI_UNIQUE_LOCAL_UNIT');
1014: hr_utility.raise_error;
1015:
1016: WHEN UNIQUE_Y_NUMBER
1017: THEN
1018: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');

Line 1021: hr_utility.raise_error;

1017: THEN
1018: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
1019: fnd_message.set_name('PER', 'HR_376613_FI_UNIQUE_MSG');
1020: fnd_message.set_token('NAME',l_field, translate => true );
1021: hr_utility.raise_error;
1022: WHEN UNIQUE_DEPT_CODE
1023: THEN
1024:
1025: fnd_message.set_name('PAY', 'HR_376630_FI_UNIQUE_DEPT_CODE');

Line 1026: hr_utility.raise_error;

1022: WHEN UNIQUE_DEPT_CODE
1023: THEN
1024:
1025: fnd_message.set_name('PAY', 'HR_376630_FI_UNIQUE_DEPT_CODE');
1026: hr_utility.raise_error;
1027:
1028: WHEN UNIQUE_GROUP_CODE
1029: THEN
1030:

Line 1032: hr_utility.raise_error;

1028: WHEN UNIQUE_GROUP_CODE
1029: THEN
1030:
1031: fnd_message.set_name('PAY', 'HR_376632_FI_UNIQUE_GROUP_CODE');
1032: hr_utility.raise_error;
1033:
1034: WHEN UNIQUE_PENSION_TYPE
1035: THEN
1036:

Line 1038: hr_utility.raise_error;

1034: WHEN UNIQUE_PENSION_TYPE
1035: THEN
1036:
1037: fnd_message.set_name('PAY', 'HR_376647_FI_UNIQ_PENSION_TYPE');
1038: hr_utility.raise_error;
1039:
1040: WHEN UNIQUE_LE_LC
1041: THEN
1042:

Line 1044: hr_utility.raise_error;

1040: WHEN UNIQUE_LE_LC
1041: THEN
1042:
1043: fnd_message.set_name('PAY', 'HR_376631_FI_UNIQUE_LE_LC');
1044: hr_utility.raise_error;
1045:
1046:
1047: WHEN UNIQUE_LE_AP
1048: THEN

Line 1051: hr_utility.raise_error;

1047: WHEN UNIQUE_LE_AP
1048: THEN
1049:
1050: fnd_message.set_name('PAY', 'HR_376638_FI_UNIQUE_ACC_PROV');
1051: hr_utility.raise_error;
1052: WHEN UNIQUE_LU_AP
1053: THEN
1054:
1055: fnd_message.set_name('PAY', 'HR_376645_FI_LU_UNIQ_ACC_PROV');

Line 1056: hr_utility.raise_error;

1052: WHEN UNIQUE_LU_AP
1053: THEN
1054:
1055: fnd_message.set_name('PAY', 'HR_376645_FI_LU_UNIQ_ACC_PROV');
1056: hr_utility.raise_error;
1057: WHEN INVALID_DATE
1058: THEN
1059:
1060: fnd_message.set_name('PAY', 'HR_376639_FI_VALID_DATE');

Line 1061: hr_utility.raise_error;

1057: WHEN INVALID_DATE
1058: THEN
1059:
1060: fnd_message.set_name('PAY', 'HR_376639_FI_VALID_DATE');
1061: hr_utility.raise_error;
1062:
1063: WHEN INVALID_TYEL_GROUP
1064: THEN
1065:

Line 1067: hr_utility.raise_error;

1063: WHEN INVALID_TYEL_GROUP
1064: THEN
1065:
1066: fnd_message.set_name('PAY', 'HR_376648_FI_TEL_GROUP_DTLS');
1067: hr_utility.raise_error;
1068:
1069: WHEN UNIQUE_PENSION_INS_NUM
1070: THEN
1071: fnd_message.set_name('PAY', 'HR_376650_FI_UNIQ_PEN_INS_NUM');

Line 1072: hr_utility.raise_error;

1068:
1069: WHEN UNIQUE_PENSION_INS_NUM
1070: THEN
1071: fnd_message.set_name('PAY', 'HR_376650_FI_UNIQ_PEN_INS_NUM');
1072: hr_utility.raise_error;
1073:
1074: WHEN UNIQUE_LU_PENSION_INS_NUM
1075: THEN
1076: fnd_message.set_name('PAY', 'HR_376651_FI_LU_PEN_INS_NUM');

Line 1077: hr_utility.raise_error;

1073:
1074: WHEN UNIQUE_LU_PENSION_INS_NUM
1075: THEN
1076: fnd_message.set_name('PAY', 'HR_376651_FI_LU_PEN_INS_NUM');
1077: hr_utility.raise_error;
1078:
1079: WHEN UNIQUE_PG_DTLS_PG
1080: THEN
1081: fnd_message.set_name('PAY', 'HR_376649_FI_LEL_TAEL_GROUP');

Line 1082: hr_utility.raise_error;

1078:
1079: WHEN UNIQUE_PG_DTLS_PG
1080: THEN
1081: fnd_message.set_name('PAY', 'HR_376649_FI_LEL_TAEL_GROUP');
1082: hr_utility.raise_error;
1083:
1084: WHEN UNIQUE_PENSION_USER_PT
1085: THEN
1086: fnd_message.set_name('PAY', 'HR_376654_FI_LE_TEL_GROUP_DTLS');

Line 1087: hr_utility.raise_error;

1083:
1084: WHEN UNIQUE_PENSION_USER_PT
1085: THEN
1086: fnd_message.set_name('PAY', 'HR_376654_FI_LE_TEL_GROUP_DTLS');
1087: hr_utility.raise_error;
1088:
1089:
1090: END validate_create_org_inf;
1091:

Line 1321: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

1317: BEGIN
1318: --
1319: -- Added for GSI Bug 5472781
1320: --
1321: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1322: --
1323: OPEN getorgid;
1324: FETCH getorgid INTO l_organization_id;
1325: CLOSE getorgid;

Line 1339: hr_utility.raise_error;

1335: CLOSE orglocalunit;
1336: IF l_count > 0
1337: THEN
1338: fnd_message.set_name('PER', 'Update');
1339: hr_utility.raise_error;
1340:
1341: RAISE UNIQUE_LOCAL_UNITS ;
1342: END IF ;
1343:

Line 1446: hr_utility.raise_error;

1442: EXCEPTION
1443: WHEN OTHERS
1444: THEN
1445: fnd_message.set_name('PAY', 'HR_FI_INVALID_NATIONAL_ID');
1446: hr_utility.raise_error;
1447: END ;
1448: END IF;
1449: -- End Of PIN --
1450: END IF; -- end of FI_EXTERNAL_COMPANY_DETAILS

Line 1825: hr_utility.raise_error;

1821:
1822: l_field := hr_general.decode_lookup('FI_FORM_LABELS','ACC_INS_POLICY');
1823: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1824: fnd_message.set_token('NAME',l_field, translate => true );
1825: hr_utility.raise_error;
1826:
1827: WHEN INVALID_Y_NUMBER_FORMAT
1828: THEN
1829:

Line 1833: hr_utility.raise_error;

1829:
1830: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
1831: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1832: fnd_message.set_token('NAME',l_field, translate => true );
1833: hr_utility.raise_error;
1834:
1835: WHEN INVALID_PP_CUSTOMER_NUM_FORMAT
1836: THEN
1837: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');

Line 1840: hr_utility.raise_error;

1836: THEN
1837: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');
1838: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1839: fnd_message.set_token('NAME',l_field, translate => true );
1840: hr_utility.raise_error;
1841:
1842: /* WHEN INVALID_PIP_NUMBER_FORMAT
1843: THEN
1844: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');

Line 1847: hr_utility.raise_error; */

1843: THEN
1844: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');
1845: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
1846: fnd_message.set_token('NAME',l_field, translate => true );
1847: hr_utility.raise_error; */
1848:
1849: WHEN UNIQUE_LOCAL_UNITS
1850: THEN
1851: fnd_message.set_name('PER', 'HR_376614_FI_UNIQUE_LOCAL_UNIT');

Line 1852: hr_utility.raise_error;

1848:
1849: WHEN UNIQUE_LOCAL_UNITS
1850: THEN
1851: fnd_message.set_name('PER', 'HR_376614_FI_UNIQUE_LOCAL_UNIT');
1852: hr_utility.raise_error;
1853:
1854: WHEN UNIQUE_Y_NUMBER
1855: THEN
1856: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');

Line 1859: hr_utility.raise_error;

1855: THEN
1856: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');
1857: fnd_message.set_name('PER', 'HR_376613_FI_UNIQUE_MSG');
1858: fnd_message.set_token('NAME',l_field, translate => true );
1859: hr_utility.raise_error;
1860: WHEN UNIQUE_DEPT_CODE
1861: THEN
1862:
1863: fnd_message.set_name('PAY', 'HR_376630_FI_UNIQUE_DEPT_CODE');

Line 1864: hr_utility.raise_error;

1860: WHEN UNIQUE_DEPT_CODE
1861: THEN
1862:
1863: fnd_message.set_name('PAY', 'HR_376630_FI_UNIQUE_DEPT_CODE');
1864: hr_utility.raise_error;
1865:
1866: WHEN UNIQUE_GROUP_CODE
1867: THEN
1868:

Line 1870: hr_utility.raise_error;

1866: WHEN UNIQUE_GROUP_CODE
1867: THEN
1868:
1869: fnd_message.set_name('PAY', 'HR_376632_FI_UNIQUE_GROUP_CODE');
1870: hr_utility.raise_error;
1871:
1872: WHEN UNIQUE_PENSION_TYPE
1873: THEN
1874:

Line 1876: hr_utility.raise_error;

1872: WHEN UNIQUE_PENSION_TYPE
1873: THEN
1874:
1875: fnd_message.set_name('PAY', 'HR_376647_FI_UNIQ_PENSION_TYPE');
1876: hr_utility.raise_error;
1877:
1878:
1879: WHEN UNIQUE_LE_LC
1880: THEN

Line 1883: hr_utility.raise_error;

1879: WHEN UNIQUE_LE_LC
1880: THEN
1881:
1882: fnd_message.set_name('PAY', 'HR_376631_FI_UNIQUE_LE_LC');
1883: hr_utility.raise_error;
1884:
1885: WHEN UNIQUE_LE_AP
1886: THEN
1887:

Line 1889: hr_utility.raise_error;

1885: WHEN UNIQUE_LE_AP
1886: THEN
1887:
1888: fnd_message.set_name('PAY', 'HR_376638_FI_UNIQUE_ACC_PROV');
1889: hr_utility.raise_error;
1890:
1891: WHEN UNIQUE_LU_AP
1892: THEN
1893:

Line 1895: hr_utility.raise_error;

1891: WHEN UNIQUE_LU_AP
1892: THEN
1893:
1894: fnd_message.set_name('PAY', 'HR_376645_FI_LU_UNIQ_ACC_PROV');
1895: hr_utility.raise_error;
1896:
1897: WHEN INVALID_DATE
1898: THEN
1899:

Line 1901: hr_utility.raise_error;

1897: WHEN INVALID_DATE
1898: THEN
1899:
1900: fnd_message.set_name('PAY', 'HR_376639_FI_VALID_DATE');
1901: hr_utility.raise_error;
1902:
1903: WHEN INVALID_TYEL_GROUP
1904: THEN
1905:

Line 1907: hr_utility.raise_error;

1903: WHEN INVALID_TYEL_GROUP
1904: THEN
1905:
1906: fnd_message.set_name('PAY', 'HR_376648_FI_TEL_GROUP_DTLS');
1907: hr_utility.raise_error;
1908:
1909:
1910: WHEN UNIQUE_PENSION_INS_NUM
1911: THEN

Line 1913: hr_utility.raise_error;

1909:
1910: WHEN UNIQUE_PENSION_INS_NUM
1911: THEN
1912: fnd_message.set_name('PAY', 'HR_376650_FI_UNIQ_PEN_INS_NUM');
1913: hr_utility.raise_error;
1914:
1915: WHEN UNIQUE_LU_PENSION_INS_NUM
1916: THEN
1917: fnd_message.set_name('PAY', 'HR_376651_FI_LU_PEN_INS_NUM');

Line 1918: hr_utility.raise_error;

1914:
1915: WHEN UNIQUE_LU_PENSION_INS_NUM
1916: THEN
1917: fnd_message.set_name('PAY', 'HR_376651_FI_LU_PEN_INS_NUM');
1918: hr_utility.raise_error;
1919:
1920:
1921: WHEN UNIQUE_PG_DTLS_PG
1922: THEN

Line 1924: hr_utility.raise_error;

1920:
1921: WHEN UNIQUE_PG_DTLS_PG
1922: THEN
1923: fnd_message.set_name('PAY', 'HR_376649_FI_LEL_TAEL_GROUP');
1924: hr_utility.raise_error;
1925:
1926: WHEN UNIQUE_PENSION_USER_PT
1927: THEN
1928: fnd_message.set_name('PAY', 'HR_376654_FI_LE_TEL_GROUP_DTLS');

Line 1929: hr_utility.raise_error;

1925:
1926: WHEN UNIQUE_PENSION_USER_PT
1927: THEN
1928: fnd_message.set_name('PAY', 'HR_376654_FI_LE_TEL_GROUP_DTLS');
1929: hr_utility.raise_error;
1930:
1931: END validate_update_org_inf;
1932:
1933: --- End Of validate_update_org_inf

Line 2002: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

1998: BEGIN
1999: --
2000: -- Added for GSI Bug 5472781
2001: --
2002: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2003: --
2004: OPEN getbgid;
2005: FETCH getbgid INTO l_business_group_id;
2006: CLOSE getbgid;

Line 2033: hr_utility.raise_error;

2029: EXCEPTION
2030: WHEN UNIQUE_RPT_ASG
2031: THEN
2032: fnd_message.set_name('PER', 'HR_376610_FI_UNIQUE_RPT_ASG');
2033: hr_utility.raise_error;
2034:
2035: END CREATE_ASG_VALIDATE;
2036:
2037: -- End OF Create_Asg_validate

Line 2113: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

2109: BEGIN
2110: --
2111: -- Added for GSI Bug 5472781
2112: --
2113: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2114: --
2115: OPEN c_person;
2116: LOOP
2117: FETCH c_person INTO l_person_id;

Line 2150: hr_utility.raise_error;

2146: EXCEPTION
2147: WHEN UNIQUE_RPT_ASG
2148: THEN
2149: fnd_message.set_name('PER', 'HR_376610_FI_UNIQUE_RPT_ASG');
2150: hr_utility.raise_error;
2151:
2152: END UPDATE_ASG_VALIDATE ;
2153:
2154: -- End Of UPDATE_ASG_VALIDATE

Line 2164: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

2160: BEGIN
2161: --
2162: -- Added for GSI Bug 5472781
2163: --
2164: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2165: --
2166: IF p_leaving_reason IS NULL THEN
2167: fnd_message.set_name('PER', 'HR_376603_FI_MANDATORY_MSG');
2168: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','L_REASON'), translate => true );

Line 2169: hr_utility.raise_error;

2165: --
2166: IF p_leaving_reason IS NULL THEN
2167: fnd_message.set_name('PER', 'HR_376603_FI_MANDATORY_MSG');
2168: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','L_REASON'), translate => true );
2169: hr_utility.raise_error;
2170: END IF;
2171: END IF;
2172: END UPDATE_TERMINATION_VALIDATE ;
2173:

Line 2203: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

2199: BEGIN
2200: --
2201: -- Added for GSI Bug 5472781
2202: --
2203: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2204: --
2205: OPEN get_int_or_ext_flag;
2206: FETCH get_int_or_ext_flag INTO l_internal_external_flag;
2207: CLOSE get_int_or_ext_flag;

Line 2235: hr_utility.raise_error;

2231: EXCEPTION
2232: WHEN EXT_COMP_EXCEPTION
2233: THEN
2234: fnd_message.set_name('PER', 'HR_376615_FI_EXT_COMPANY');
2235: hr_utility.raise_error;
2236: WHEN PEN_PROV_EXCEPTION
2237: THEN
2238: fnd_message.set_name('PAY', 'HR_376628_FI_PEN_PROVIDER');
2239: hr_utility.raise_error;

Line 2239: hr_utility.raise_error;

2235: hr_utility.raise_error;
2236: WHEN PEN_PROV_EXCEPTION
2237: THEN
2238: fnd_message.set_name('PAY', 'HR_376628_FI_PEN_PROVIDER');
2239: hr_utility.raise_error;
2240: WHEN ACC_PROV_EXCEPTION
2241: THEN
2242: fnd_message.set_name('PAY', 'HR_376629_FI_ACC_INS_PROVIDER');
2243: hr_utility.raise_error;

Line 2243: hr_utility.raise_error;

2239: hr_utility.raise_error;
2240: WHEN ACC_PROV_EXCEPTION
2241: THEN
2242: fnd_message.set_name('PAY', 'HR_376629_FI_ACC_INS_PROVIDER');
2243: hr_utility.raise_error;
2244:
2245: WHEN PROV_TAX_EXCEPTION
2246: THEN
2247: fnd_message.set_name('PAY', 'HR_376635_FI_PROV_TAX_OFFICE');

Line 2248: hr_utility.raise_error;

2244:
2245: WHEN PROV_TAX_EXCEPTION
2246: THEN
2247: fnd_message.set_name('PAY', 'HR_376635_FI_PROV_TAX_OFFICE');
2248: hr_utility.raise_error;
2249:
2250:
2251: END CREATE_ORG_CLASS_VALIDATE;
2252: ---

Line 2284: hr_utility.raise_error;

2280: IF p_token IS NOT NULL AND p_message IS NULL
2281: THEN
2282: fnd_message.set_name('PER', 'HR_376612_FI_INVALID_FORMAT');
2283: fnd_message.set_token('NAME',p_token, translate => true );
2284: hr_utility.raise_error;
2285: ELSIF p_message IS NOT NULL
2286: THEN
2287: fnd_message.set_name('PER', p_message);
2288: fnd_message.set_token('NAME',p_token, translate => true );

Line 2289: hr_utility.raise_error;

2285: ELSIF p_message IS NOT NULL
2286: THEN
2287: fnd_message.set_name('PER', p_message);
2288: fnd_message.set_token('NAME',p_token, translate => true );
2289: hr_utility.raise_error;
2290: END IF ;
2291:
2292: END IF;
2293: END IF;

Line 2321: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

2317: BEGIN
2318: --
2319: -- Added for GSI Bug 5472781
2320: --
2321: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2322: --
2323: -- get the values of the person_id profile
2324: fnd_profile.put('PER_PERSON_ID',p_person_id);
2325: if p_abs_information_category='FI_F' THEN

Line 2332: hr_utility.raise_error;

2328: CLOSE get_start_date;
2329:
2330: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN
2331: fnd_message.set_name('PAY', 'HR_376663_FI_MATERNITY_DATE');
2332: hr_utility.raise_error;
2333: END IF;
2334: END IF;
2335: END IF;
2336:

Line 2369: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

2365: BEGIN
2366: --
2367: -- Added for GSI Bug 5472781
2368: --
2369: IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
2370: --
2371: open get_person_id(p_absence_attendance_id);
2372: fetch get_person_id into l_person_id;
2373: close get_person_id;

Line 2385: hr_utility.raise_error;

2381: CLOSE get_start_date;
2382:
2383: if fnd_date.canonical_to_date(p_abs_information1) < l_start_date THEN
2384: fnd_message.set_name('PAY', 'HR_376663_FI_MATERNITY_DATE');
2385: hr_utility.raise_error;
2386: END IF;
2387: END IF;
2388: END IF;
2389: END PERSON_ABSENCE_UPDATE;