50: --Validate not null fields
51: IF g_per_type IS NOT NULL THEN -- for fixing Bug 4436984
52: IF p_first_name IS NULL THEN
53: IF v_field IS NULL THEN
54: v_field := hr_general.decode_lookup('KW_FORM_LABELS','M_FIRST_NAME');
55: ELSE
56: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','M_FIRST_NAME');
57: END IF;
58: END IF;
52: IF p_first_name IS NULL THEN
53: IF v_field IS NULL THEN
54: v_field := hr_general.decode_lookup('KW_FORM_LABELS','M_FIRST_NAME');
55: ELSE
56: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','M_FIRST_NAME');
57: END IF;
58: END IF;
59: END IF; -- end for EMP check
60:
64: /*IF g_per_type IS NOT NULL THEN
65:
66: IF p_national_identifier IS NULL THEN
67: IF v_field IS NULL THEN
68: v_field := hr_general.decode_lookup('KW_FORM_LABELS','CIVIL_IDENTIFIER');
69: ELSE
70: v_field := v_field||hr_general.decode_lookup('KW_FORM_LABELS','CIVIL_IDENTIFIER');
71: END IF;
72: END IF;
66: IF p_national_identifier IS NULL THEN
67: IF v_field IS NULL THEN
68: v_field := hr_general.decode_lookup('KW_FORM_LABELS','CIVIL_IDENTIFIER');
69: ELSE
70: v_field := v_field||hr_general.decode_lookup('KW_FORM_LABELS','CIVIL_IDENTIFIER');
71: END IF;
72: END IF;
73: END IF;*/
74:
74:
75: /*IF g_per_type IS NOT NULL THEN
76: IF p_per_information3 IS NULL THEN
77: IF v_field IS NULL THEN
78: v_field := hr_general.decode_lookup('KW_FORM_LABELS','M_ALT_FIRST_NAME');
79: ELSE
80: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','M_ALT_FIRST_NAME');
81: END IF;
82: END IF;
76: IF p_per_information3 IS NULL THEN
77: IF v_field IS NULL THEN
78: v_field := hr_general.decode_lookup('KW_FORM_LABELS','M_ALT_FIRST_NAME');
79: ELSE
80: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','M_ALT_FIRST_NAME');
81: END IF;
82: END IF;
83: END IF;
84:
84:
85: IF g_per_type IS NOT NULL THEN
86: IF p_per_information6 IS NULL THEN
87: IF v_field IS NULL THEN
88: v_field := hr_general.decode_lookup('KW_FORM_LABELS','M_ALT_FAMILY_NAME');
89: ELSE
90: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','M_ALT_FAMILY_NAME');
91: END IF;
92: END IF;
86: IF p_per_information6 IS NULL THEN
87: IF v_field IS NULL THEN
88: v_field := hr_general.decode_lookup('KW_FORM_LABELS','M_ALT_FAMILY_NAME');
89: ELSE
90: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','M_ALT_FAMILY_NAME');
91: END IF;
92: END IF;
93: END IF;*/ -- Removed with reference to bug #4150446
94:
97: CLOSE c_type;
98: IF g_per_type IS NOT NULL THEN -- for fixing Bug 4436984
99: IF p_nationality IS NULL THEN
100: IF v_field IS NULL THEN
101: v_field := hr_general.decode_lookup('KW_FORM_LABELS','NATIONALITY');
102: ELSE
103: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','NATIONALITY');
104: END IF;
105: END IF;
99: IF p_nationality IS NULL THEN
100: IF v_field IS NULL THEN
101: v_field := hr_general.decode_lookup('KW_FORM_LABELS','NATIONALITY');
102: ELSE
103: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','NATIONALITY');
104: END IF;
105: END IF;
106: END IF;
107: IF v_field IS NOT NULL THEN
663: v_field := NULL;
664: IF p_pem_information_category = 'KW' then
665: IF p_employer_name is null then
666: IF v_field IS NULL THEN
667: v_field := hr_general.decode_lookup('KW_FORM_LABELS','PREVIOUS_EMPLOYER');
668: ELSE
669: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','PREVIOUS_EMPLOYER');
670: END IF;
671:
665: IF p_employer_name is null then
666: IF v_field IS NULL THEN
667: v_field := hr_general.decode_lookup('KW_FORM_LABELS','PREVIOUS_EMPLOYER');
668: ELSE
669: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','PREVIOUS_EMPLOYER');
670: END IF;
671:
672: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
673: fnd_message.set_token('NAME',v_field, translate => true );
933:
934: /*IF UPPER(l_nationality) = l_local_nationality THEN
935: IF (p_segment2 IS NULL) THEN
936: IF v_field IS NULL THEN
937: v_field := hr_general.decode_lookup('KW_FORM_LABELS','SOCIAL_SEC_NUMBER');
938: ELSE
939: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','SOCIAL_SEC_NUMBER');
940: END IF;
941: END IF;
935: IF (p_segment2 IS NULL) THEN
936: IF v_field IS NULL THEN
937: v_field := hr_general.decode_lookup('KW_FORM_LABELS','SOCIAL_SEC_NUMBER');
938: ELSE
939: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','SOCIAL_SEC_NUMBER');
940: END IF;
941: END IF;
942: END IF;*/
943: