DBA Data[Home] [Help]

APPS.HR_FI_VALIDATE_PKG dependencies on HR_GENERAL

Line 33: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PIN');

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

Line 507: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));

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

Line 508: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));

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 ----------------------------

Line 509: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));

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:

Line 569: validate_number(p_org_information6,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));

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:

Line 620: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','GROUP_CODE'),'HR_376633_FI_WHOLE_NUMBER');

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:

Line 658: validate_number(p_org_information3,hr_general.decode_lookup('FI_FORM_LABELS','DEPARTMENT_CODE'),'HR_376633_FI_WHOLE_NUMBER');

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;

Line 969: l_field := hr_general.decode_lookup('FI_FORM_LABELS','ACC_INS_POLICY');

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:

Line 977: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');

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:

Line 984: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');

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:

Line 991: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');

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:

Line 1004: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');

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

Line 1364: validate_number(p_org_information1,hr_general.decode_lookup('FI_FORM_LABELS','SUB_DISBURSEMENT'));

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:

Line 1365: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','LOCAL_UNIT_NUMBER'));

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

Line 1366: validate_number(p_org_information4,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));

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:

Line 1398: validate_number(p_org_information6,hr_general.decode_lookup('FI_FORM_LABELS','EMP_ORG_MEMBERSHIP'));

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:

Line 1451: validate_number(p_org_information2,hr_general.decode_lookup('FI_FORM_LABELS','GROUP_CODE'),'HR_376633_FI_WHOLE_NUMBER');

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:

Line 1490: validate_number(p_org_information3,hr_general.decode_lookup('FI_FORM_LABELS','DEPARTMENT_CODE'),'HR_376633_FI_WHOLE_NUMBER');

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;

Line 1802: l_field := hr_general.decode_lookup('FI_FORM_LABELS','ACC_INS_POLICY');

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:

Line 1810: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');

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:

Line 1817: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_PROV_CUST');

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:

Line 1824: l_field := hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS_POLICY');

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:

Line 1836: l_field := hr_general.decode_lookup('FI_FORM_LABELS','Y_NUMBER');

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

Line 2148: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','L_REASON'), translate => true );

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 ;