33: IF per_per_bus.g_global_transfer_in_process IS NULL
34: or per_per_bus.g_global_transfer_in_process = false THEN
35:
36: IF p_national_identifier IS NULL or p_national_identifier = hr_api.g_varchar2 THEN
37: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PIN');
38: END IF;
39: END IF;
40: END IF;
41:
508: END IF ;
509: IF p_org_info_type_code = 'FI_LOCAL_UNIT_DETAILS'
510: THEN -- LOCAL_UNIT_DETAILS
511:
512: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
513: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
514: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
515:
516: END IF ; -- end of LOCAL_UNIT_DETAILS
509: IF p_org_info_type_code = 'FI_LOCAL_UNIT_DETAILS'
510: THEN -- LOCAL_UNIT_DETAILS
511:
512: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
513: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
514: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
515:
516: END IF ; -- end of LOCAL_UNIT_DETAILS
517: --------------------------- Y-Number Unique Bug ----------------------------
510: THEN -- LOCAL_UNIT_DETAILS
511:
512: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
513: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
514: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
515:
516: END IF ; -- end of LOCAL_UNIT_DETAILS
517: --------------------------- Y-Number Unique Bug ----------------------------
518:
570: END IF;
571: -- End Of For Y-Number --
572:
573: -- 3900118 To validate whole number
574: validate_number(p_org_information6,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
575: -- 3900118 To validate whole number
576:
577:
578:
621: THEN
622:
623: RAISE INVALID_TYEL_GROUP ;
624: -- Group Code
625: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','GROUP_CODE'),'HR_376633_FI_WHOLE_NUMBER');
626:
627:
628: END IF;
629:
659:
660: IF p_org_info_type_code = 'FI_PENSION_DEPARTMENT_CODES'
661: THEN -- FI_PENSION_DEPARTMENT_CODES
662: -- Department Code
663: validate_number(p_org_information3,hr_general.decode_lookup('FI_FORM_LABELS','DEPARTMENT_CODE'),'HR_376633_FI_WHOLE_NUMBER');
664:
665: OPEN c_ins_dept_code;
666: FETCH c_ins_dept_code INTO l_count;
667: CLOSE c_ins_dept_code;
979: EXCEPTION
980: WHEN INVALID_POLICY_NUMBER_FORMAT
981: THEN
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:
987:
988: WHEN INVALID_Y_NUMBER_FORMAT
989: THEN
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:
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');
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:
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');
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:
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');
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
1374:
1375: IF p_org_info_type_code = 'FI_LOCAL_UNIT_DETAILS'
1376: THEN -- LOCAL_UNIT_DETAILS
1377:
1378: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
1379: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
1380: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
1381:
1382:
1375: IF p_org_info_type_code = 'FI_LOCAL_UNIT_DETAILS'
1376: THEN -- LOCAL_UNIT_DETAILS
1377:
1378: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
1379: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
1380: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
1381:
1382:
1383: END IF ; -- end of LOCAL_UNIT_DETAILS
1376: THEN -- LOCAL_UNIT_DETAILS
1377:
1378: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));
1379: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));
1380: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
1381:
1382:
1383: END IF ; -- end of LOCAL_UNIT_DETAILS
1384:
1408: END IF;
1409: -- End Of For Y-Number --
1410: --
1411: -- 3900118 To validate whole number
1412: validate_number(p_org_information6,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));
1413: -- 3900118 To validate whole number
1414:
1415: END IF ; -- end of LEGAL_EMPLOYER_DETAILS
1416:
1461: THEN
1462:
1463: RAISE INVALID_TYEL_GROUP ;
1464: -- Group Code
1465: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','GROUP_CODE'),'HR_376633_FI_WHOLE_NUMBER');
1466:
1467:
1468: END IF;
1469:
1500: IF p_org_info_type_code = 'FI_PENSION_DEPARTMENT_CODES'
1501: THEN -- FI_PENSION_DEPARTMENT_CODES
1502: IF p_org_information3 IS NOT NULL THEN
1503: -- Department Code
1504: validate_number(p_org_information3,hr_general.decode_lookup('FI_FORM_LABELS','DEPARTMENT_CODE'),'HR_376633_FI_WHOLE_NUMBER');
1505:
1506: OPEN c_upd_dept_code;
1507: FETCH c_upd_dept_code INTO l_count;
1508: CLOSE c_upd_dept_code;
1818: EXCEPTION
1819: WHEN INVALID_POLICY_NUMBER_FORMAT
1820: THEN
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:
1826:
1827: WHEN INVALID_Y_NUMBER_FORMAT
1828: THEN
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:
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');
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:
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');
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:
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');
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
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 );
2169: hr_utility.raise_error;
2170: END IF;
2171: END IF;
2172: END UPDATE_TERMINATION_VALIDATE ;