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