29:
30: --Validate not null fields
31: IF l_type IS NOT NULL THEN
32: IF p_national_identifier IS NULL or p_national_identifier = hr_api.g_varchar2 THEN
33: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PIN');
34: END IF;
35: END IF;
36:
37: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN
503: END IF ;
504: IF p_org_info_type_code = 'FI_LOCAL_UNIT_DETAILS'
505: THEN -- LOCAL_UNIT_DETAILS
506:
507: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
508: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
509: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
510:
511: END IF ; -- end of LOCAL_UNIT_DETAILS
504: IF p_org_info_type_code = 'FI_LOCAL_UNIT_DETAILS'
505: THEN -- LOCAL_UNIT_DETAILS
506:
507: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
508: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
509: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
510:
511: END IF ; -- end of LOCAL_UNIT_DETAILS
512: --------------------------- Y-Number Unique Bug ----------------------------
505: THEN -- LOCAL_UNIT_DETAILS
506:
507: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
508: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
509: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
510:
511: END IF ; -- end of LOCAL_UNIT_DETAILS
512: --------------------------- Y-Number Unique Bug ----------------------------
513:
565: END IF;
566: -- End Of For Y-Number --
567:
568: -- 3900118 To validate whole number
569: validate_number(p_org_information6,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
570: -- 3900118 To validate whole number
571:
572:
573:
616: THEN
617:
618: RAISE INVALID_TYEL_GROUP ;
619: -- Group Code
620: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','GROUP_CODE'),'HR_376633_FI_WHOLE_NUMBER');
621:
622:
623: END IF;
624:
654:
655: IF p_org_info_type_code = 'FI_PENSION_DEPARTMENT_CODES'
656: THEN -- FI_PENSION_DEPARTMENT_CODES
657: -- Department Code
658: validate_number(p_org_information3,hr_general.decode_lookup('FI_FORM_LABELS','DEPARTMENT_CODE'),'HR_376633_FI_WHOLE_NUMBER');
659:
660: OPEN c_ins_dept_code;
661: FETCH c_ins_dept_code INTO l_count;
662: CLOSE c_ins_dept_code;
965: EXCEPTION
966: WHEN INVALID_POLICY_NUMBER_FORMAT
967: THEN
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:
973:
974: WHEN INVALID_Y_NUMBER_FORMAT
975: THEN
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:
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');
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:
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');
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:
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');
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
1360:
1361: IF p_org_info_type_code = 'FI_LOCAL_UNIT_DETAILS'
1362: THEN -- LOCAL_UNIT_DETAILS
1363:
1364: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
1365: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
1366: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
1367:
1368:
1361: IF p_org_info_type_code = 'FI_LOCAL_UNIT_DETAILS'
1362: THEN -- LOCAL_UNIT_DETAILS
1363:
1364: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
1365: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
1366: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
1367:
1368:
1369: END IF ; -- end of LOCAL_UNIT_DETAILS
1362: THEN -- LOCAL_UNIT_DETAILS
1363:
1364: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
1365: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
1366: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
1367:
1368:
1369: END IF ; -- end of LOCAL_UNIT_DETAILS
1370:
1394: END IF;
1395: -- End Of For Y-Number --
1396: --
1397: -- 3900118 To validate whole number
1398: validate_number(p_org_information6,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
1399: -- 3900118 To validate whole number
1400:
1401: END IF ; -- end of LEGAL_EMPLOYER_DETAILS
1402:
1447: THEN
1448:
1449: RAISE INVALID_TYEL_GROUP ;
1450: -- Group Code
1451: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','GROUP_CODE'),'HR_376633_FI_WHOLE_NUMBER');
1452:
1453:
1454: END IF;
1455:
1486: IF p_org_info_type_code = 'FI_PENSION_DEPARTMENT_CODES'
1487: THEN -- FI_PENSION_DEPARTMENT_CODES
1488: IF p_org_information3 IS NOT NULL THEN
1489: -- Department Code
1490: validate_number(p_org_information3,hr_general.decode_lookup('FI_FORM_LABELS','DEPARTMENT_CODE'),'HR_376633_FI_WHOLE_NUMBER');
1491:
1492: OPEN c_upd_dept_code;
1493: FETCH c_upd_dept_code INTO l_count;
1494: CLOSE c_upd_dept_code;
1798: EXCEPTION
1799: WHEN INVALID_POLICY_NUMBER_FORMAT
1800: THEN
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:
1806:
1807: WHEN INVALID_Y_NUMBER_FORMAT
1808: THEN
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:
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');
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:
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');
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:
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');
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
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 );
2149: hr_utility.raise_error;
2150: END IF;
2151: END IF;
2152: END UPDATE_TERMINATION_VALIDATE ;