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 43: l_field := hr_general.decode_lookup('SE_FORM_LABELS','PIN');

39: END IF;
40:
41: IF p_national_identifier IS NULL or p_national_identifier = hr_api.g_varchar2 THEN
42:
43: l_field := hr_general.decode_lookup('SE_FORM_LABELS','PIN');
44:
45: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN
46: fnd_message.set_name('PER', 'HR_377202_SE_MANDATORY_MSG');
47: fnd_message.set_token('NAME',l_field, translate => true );

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

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

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

695: END IF ;
696: END IF;
697:
698: -- validate for presence of Decimals in CFAR Number
699: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','CFAR'));
700:
701: IF p_org_information6 ='Y' THEN
702: OPEN FIND_LEGAL_EMPLOYER;
703: FETCH FIND_LEGAL_EMPLOYER INTO L_LEGAL_EMPLOYER;

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

714:
715:
716: ELSIF p_org_info_type_code = 'SE_LEGAL_EMPLOYER_DETAILS' THEN
717: -- validate for presence of Decimals in Confederation Number
718: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','CONFD'));
719: -- validate for presence of Decimals in Organization Number
720: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','ORG'));
721:
722: -- validate for Uniqness of Organization Number within a Legal Employer

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

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

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

881: END IF;
882: EXCEPTION
883: WHEN ENTER_GROUP_BY THEN
884: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
885: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');
886: fnd_message.set_token('NAME',l_token, translate => true );
887: hr_utility.raise_error;
888:
889: WHEN ENTER_ALL THEN

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

887: hr_utility.raise_error;
888:
889: WHEN ENTER_ALL THEN
890: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
891: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
892: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
893: hr_general.decode_lookup('SE_FORM_LABELS','AMT')|| ','||
894: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
895: fnd_message.set_token('NAME',l_token, translate => true );

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

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

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

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

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

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

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

1555:
1556:
1557: ELSIF p_org_info_type_code = 'SE_LOCAL_UNIT_DETAILS' THEN
1558: -- validate for presence of Decimals in AST Number
1559: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','AST'));
1560: -- validate for Uniqness of AST Number within a Legal Employer
1561:
1562:
1563: IF p_org_information1 IS NOT NULL THEN

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

1573: END IF ;
1574: END IF;
1575:
1576: -- validate for presence of Decimals in CFAR Number
1577: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','CFAR'));
1578:
1579: IF p_org_information6 ='Y' THEN
1580: OPEN FIND_LEGAL_EMPLOYER;
1581: FETCH FIND_LEGAL_EMPLOYER INTO L_LEGAL_EMPLOYER;

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

1591:
1592:
1593: ELSIF p_org_info_type_code = 'SE_LEGAL_EMPLOYER_DETAILS' THEN
1594: -- validate for presence of Decimals in Confederation Number
1595: validate_number(p_org_information1,hr_general.decode_lookup('SE_FORM_LABELS','CONFD'));
1596: -- validate for presence of Decimals in Organization Number
1597: validate_number(p_org_information2,hr_general.decode_lookup('SE_FORM_LABELS','ORG'));
1598:
1599: -- validate for Uniqness of Organization Number within a Legal Employer

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

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

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

1764: EXCEPTION
1765:
1766: WHEN ENTER_GROUP_BY THEN
1767: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1768: l_token := hr_general.decode_lookup('SE_FORM_LABELS','GBP');
1769: fnd_message.set_token('NAME',l_token, translate => true );
1770: hr_utility.raise_error;
1771:
1772: WHEN ENTER_ALL THEN

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

1770: hr_utility.raise_error;
1771:
1772: WHEN ENTER_ALL THEN
1773: fnd_message.set_name('PER','HR_377202_SE_MANDATORY_MSG');
1774: l_token := hr_general.decode_lookup('SE_FORM_LABELS','UNIT') || ','||
1775: hr_general.decode_lookup('SE_FORM_LABELS','UP') || ','||
1776: hr_general.decode_lookup('SE_FORM_LABELS','AMT') || ','||
1777: hr_general.decode_lookup('SE_FORM_LABELS','GBU');
1778: fnd_message.set_token('NAME',l_token, translate => true );

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

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

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

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

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

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