DBA Data[Home] [Help]

APPS.HR_SE_VALIDATE_PKG dependencies on HR_GENERAL

Line 31: l_field := hr_general.decode_lookup('SE_FORM_LABELS','FIRST_NAME');

27: --Validate not null fields
28:
29: IF l_type IS NOT NULL THEN
30: IF p_first_name IS NULL THEN
31: l_field := hr_general.decode_lookup('SE_FORM_LABELS','FIRST_NAME');
32:
33: IF l_field IS NOT NULL THEN
34: fnd_message.set_name('PER', 'HR_377202_SE_MANDATORY_MSG');
35: fnd_message.set_token('NAME',l_field, translate => true );

Line 47: l_field := hr_general.decode_lookup('SE_FORM_LABELS','PIN');

43: or per_per_bus.g_global_transfer_in_process = false THEN
44:
45: IF p_national_identifier IS NULL or p_national_identifier = hr_api.g_varchar2 THEN
46:
47: l_field := hr_general.decode_lookup('SE_FORM_LABELS','PIN');
48:
49: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN
50: fnd_message.set_name('PER', 'HR_377202_SE_MANDATORY_MSG');
51: fnd_message.set_token('NAME',l_field, translate => true );

Line 687: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','AST'));

683:
684:
685: ELSIF p_org_info_type_code = 'SE_LOCAL_UNIT_DETAILS' THEN
686: -- validate for presence of Decimals in AST Number
687: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','AST'));
688: -- validate for Uniqness of AST Number within a Legal Employer
689: IF p_org_information1 IS NOT NULL THEN
690: OPEN FIND_LEGAL_EMPLOYER;
691: FETCH FIND_LEGAL_EMPLOYER INTO L_LEGAL_EMPLOYER;

Line 704: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','CFAR'));

700: END IF ;
701: END IF;
702:
703: -- validate for presence of Decimals in CFAR Number
704: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','CFAR'));
705:
706: IF p_org_information6 ='Y' THEN
707: OPEN FIND_LEGAL_EMPLOYER;
708: FETCH FIND_LEGAL_EMPLOYER INTO L_LEGAL_EMPLOYER;

Line 723: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','CONFD'));

719:
720:
721: ELSIF p_org_info_type_code = 'SE_LEGAL_EMPLOYER_DETAILS' THEN
722: -- validate for presence of Decimals in Confederation Number
723: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','CONFD'));
724: -- validate for presence of Decimals in Organization Number
725: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','ORG'));
726:
727: -- validate for Uniqness of Organization Number within a Legal Employer

Line 725: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','ORG'));

721: ELSIF p_org_info_type_code = 'SE_LEGAL_EMPLOYER_DETAILS' THEN
722: -- validate for presence of Decimals in Confederation Number
723: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','CONFD'));
724: -- validate for presence of Decimals in Organization Number
725: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','ORG'));
726:
727: -- validate for Uniqness of Organization Number within a Legal Employer
728: IF p_org_information2 IS NOT NULL THEN
729: OPEN org_number;

Line 890: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');

886: END IF;
887: EXCEPTION
888: WHEN ENTER_GROUP_BY THEN
889: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
890: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');
891: fnd_message.set_token('NAME',l_token, translate => true );
892: hr_utility.raise_error;
893:
894: WHEN ENTER_ALL THEN

Line 896: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||

892: hr_utility.raise_error;
893:
894: WHEN ENTER_ALL THEN
895: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
896: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
897: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
898: hr_general.decode_lookup('SE_FORM_LABELS','AMT')|| ','||
899: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
900: fnd_message.set_token('NAME',l_token, translate => true );

Line 897: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||

893:
894: WHEN ENTER_ALL THEN
895: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
896: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
897: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
898: hr_general.decode_lookup('SE_FORM_LABELS','AMT')|| ','||
899: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
900: fnd_message.set_token('NAME',l_token, translate => true );
901: hr_utility.raise_error;

Line 898: hr_general.decode_lookup('SE_FORM_LABELS','AMT')|| ','||

894: WHEN ENTER_ALL THEN
895: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
896: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
897: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
898: hr_general.decode_lookup('SE_FORM_LABELS','AMT')|| ','||
899: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
900: fnd_message.set_token('NAME',l_token, translate => true );
901: hr_utility.raise_error;
902: WHEN UNIQUE_AST_NUMBER THEN

Line 899: hr_general.decode_lookup('SE_FORM_LABELS','GBU');

895: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
896: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
897: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
898: hr_general.decode_lookup('SE_FORM_LABELS','AMT')|| ','||
899: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
900: fnd_message.set_token('NAME',l_token, translate => true );
901: hr_utility.raise_error;
902: WHEN UNIQUE_AST_NUMBER THEN
903: fnd_message.set_name('PER', 'HR_377206_SE_UNIQUE_AST_NUMBER');

Line 1564: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','AST'));

1560:
1561:
1562: ELSIF p_org_info_type_code = 'SE_LOCAL_UNIT_DETAILS' THEN
1563: -- validate for presence of Decimals in AST Number
1564: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','AST'));
1565: -- validate for Uniqness of AST Number within a Legal Employer
1566:
1567:
1568: IF p_org_information1 IS NOT NULL THEN

Line 1582: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','CFAR'));

1578: END IF ;
1579: END IF;
1580:
1581: -- validate for presence of Decimals in CFAR Number
1582: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','CFAR'));
1583:
1584: IF p_org_information6 ='Y' THEN
1585: OPEN FIND_LEGAL_EMPLOYER;
1586: FETCH FIND_LEGAL_EMPLOYER INTO L_LEGAL_EMPLOYER;

Line 1600: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','CONFD'));

1596:
1597:
1598: ELSIF p_org_info_type_code = 'SE_LEGAL_EMPLOYER_DETAILS' THEN
1599: -- validate for presence of Decimals in Confederation Number
1600: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','CONFD'));
1601: -- validate for presence of Decimals in Organization Number
1602: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','ORG'));
1603:
1604: -- validate for Uniqness of Organization Number within a Legal Employer

Line 1602: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','ORG'));

1598: ELSIF p_org_info_type_code = 'SE_LEGAL_EMPLOYER_DETAILS' THEN
1599: -- validate for presence of Decimals in Confederation Number
1600: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','CONFD'));
1601: -- validate for presence of Decimals in Organization Number
1602: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','ORG'));
1603:
1604: -- validate for Uniqness of Organization Number within a Legal Employer
1605: IF p_org_information2 IS NOT NULL THEN
1606: OPEN org_number;

Line 1773: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');

1769: EXCEPTION
1770:
1771: WHEN ENTER_GROUP_BY THEN
1772: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1773: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');
1774: fnd_message.set_token('NAME',l_token, translate => true );
1775: hr_utility.raise_error;
1776:
1777: WHEN ENTER_ALL THEN

Line 1779: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||

1775: hr_utility.raise_error;
1776:
1777: WHEN ENTER_ALL THEN
1778: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1779: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
1780: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
1781: hr_general.decode_lookup('SE_FORM_LABELS','AMT') || ','||
1782: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
1783: fnd_message.set_token('NAME',l_token, translate => true );

Line 1780: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||

1776:
1777: WHEN ENTER_ALL THEN
1778: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1779: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
1780: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
1781: hr_general.decode_lookup('SE_FORM_LABELS','AMT') || ','||
1782: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
1783: fnd_message.set_token('NAME',l_token, translate => true );
1784: hr_utility.raise_error;

Line 1781: hr_general.decode_lookup('SE_FORM_LABELS','AMT') || ','||

1777: WHEN ENTER_ALL THEN
1778: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1779: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
1780: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
1781: hr_general.decode_lookup('SE_FORM_LABELS','AMT') || ','||
1782: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
1783: fnd_message.set_token('NAME',l_token, translate => true );
1784: hr_utility.raise_error;
1785: WHEN UNIQUE_AST_NUMBER THEN

Line 1782: hr_general.decode_lookup('SE_FORM_LABELS','GBU');

1778: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1779: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
1780: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
1781: hr_general.decode_lookup('SE_FORM_LABELS','AMT') || ','||
1782: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
1783: fnd_message.set_token('NAME',l_token, translate => true );
1784: hr_utility.raise_error;
1785: WHEN UNIQUE_AST_NUMBER THEN
1786: