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 );
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 );
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;
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;
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
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;
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
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 );
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;
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
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');
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
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;
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
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;
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
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 );
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;
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
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: