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:
108: -- Bug#14275662
109: IF g_per_type IS NOT NULL THEN -- for fixing Bug 4436984
110: IF p_nationality IS NULL THEN
111: IF v_field IS NULL THEN
112: v_field := hr_general.decode_lookup('KW_FORM_LABELS','NATIONALITY');
113: ELSE
114: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','NATIONALITY');
115: END IF;
116: END IF;
110: IF p_nationality IS NULL THEN
111: IF v_field IS NULL THEN
112: v_field := hr_general.decode_lookup('KW_FORM_LABELS','NATIONALITY');
113: ELSE
114: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','NATIONALITY');
115: END IF;
116: END IF;
117: END IF;
118: IF v_field IS NOT NULL THEN
675: v_field := NULL;
676: IF p_pem_information_category = 'KW' then
677: IF p_employer_name is null then
678: IF v_field IS NULL THEN
679: v_field := hr_general.decode_lookup('KW_FORM_LABELS','PREVIOUS_EMPLOYER');
680: ELSE
681: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','PREVIOUS_EMPLOYER');
682: END IF;
683:
677: IF p_employer_name is null then
678: IF v_field IS NULL THEN
679: v_field := hr_general.decode_lookup('KW_FORM_LABELS','PREVIOUS_EMPLOYER');
680: ELSE
681: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','PREVIOUS_EMPLOYER');
682: END IF;
683:
684: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
685: fnd_message.set_token('NAME',v_field, translate => true );
945:
946: /*IF UPPER(l_nationality) = l_local_nationality THEN
947: IF (p_segment2 IS NULL) THEN
948: IF v_field IS NULL THEN
949: v_field := hr_general.decode_lookup('KW_FORM_LABELS','SOCIAL_SEC_NUMBER');
950: ELSE
951: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','SOCIAL_SEC_NUMBER');
952: END IF;
953: END IF;
947: IF (p_segment2 IS NULL) THEN
948: IF v_field IS NULL THEN
949: v_field := hr_general.decode_lookup('KW_FORM_LABELS','SOCIAL_SEC_NUMBER');
950: ELSE
951: v_field := v_field||', '||hr_general.decode_lookup('KW_FORM_LABELS','SOCIAL_SEC_NUMBER');
952: END IF;
953: END IF;
954: END IF;*/
955: