45: FETCH c_emp_type INTO l_emp_type;
46: CLOSE c_emp_type;
47: --Validate not null fields
48: /*IF p_title IS NULL THEN
49: v_field := hr_general.decode_lookup('SA_FORM_LABELS','TITLE');
50: END IF; */ /* To Fix Bug 4432530*/
51: IF l_emp_type = 'Y' THEN -- To Fix Bug 4432530
52: IF p_first_name IS NULL THEN
53: IF v_field IS NULL THEN
50: END IF; */ /* To Fix Bug 4432530*/
51: IF l_emp_type = 'Y' THEN -- To Fix Bug 4432530
52: IF p_first_name IS NULL THEN
53: IF v_field IS NULL THEN
54: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_FIRST_NAME');
55: ELSE
56: v_field := v_field||', '||hr_general.decode_lookup('SA_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('SA_FORM_LABELS','M_FIRST_NAME');
55: ELSE
56: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_FIRST_NAME');
57: END IF;
58: END IF;
59: END IF; -- For EMP check
60: /* IF p_per_information1 IS NULL THEN
58: END IF;
59: END IF; -- For EMP check
60: /* IF p_per_information1 IS NULL THEN
61: IF v_field IS NULL THEN
62: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_FATHER_NAME');
63: ELSE
64: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_FATHER_NAME');
65: END IF;
66: END IF; */ --Removed as per enhancement bug 3580573
60: /* IF p_per_information1 IS NULL THEN
61: IF v_field IS NULL THEN
62: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_FATHER_NAME');
63: ELSE
64: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_FATHER_NAME');
65: END IF;
66: END IF; */ --Removed as per enhancement bug 3580573
67: --Validate grandfather is not null if nationality is saudi
68: IF UPPER(p_nationality) = FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN
67: --Validate grandfather is not null if nationality is saudi
68: IF UPPER(p_nationality) = FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN
69: /*IF p_per_information2 IS NULL THEN
70: IF v_field IS NULL THEN
71: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_GRANDFATHER_NAME');
72: ELSE
73: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_GRANDFATHER_NAME');
74: END IF;
75: END IF;*/
69: /*IF p_per_information2 IS NULL THEN
70: IF v_field IS NULL THEN
71: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_GRANDFATHER_NAME');
72: ELSE
73: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_GRANDFATHER_NAME');
74: END IF;
75: END IF;*/
76: IF p_national_identifier IS NULL THEN
77: IF v_field IS NULL THEN
74: END IF;
75: END IF;*/
76: IF p_national_identifier IS NULL THEN
77: IF v_field IS NULL THEN
78: v_field := hr_general.decode_lookup('SA_FORM_LABELS','CIVIL_IDENTITY');
79: ELSE
80: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','CIVIL_IDENTITY');
81: END IF;
82: END IF;
76: IF p_national_identifier IS NULL THEN
77: IF v_field IS NULL THEN
78: v_field := hr_general.decode_lookup('SA_FORM_LABELS','CIVIL_IDENTITY');
79: ELSE
80: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','CIVIL_IDENTITY');
81: END IF;
82: END IF;
83: END IF;
84: /* IF l_emp_type = 'Y' THEN
83: END IF;
84: /* IF l_emp_type = 'Y' THEN
85: IF p_per_information3 IS NULL THEN
86: IF v_field IS NULL THEN
87: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FIRST_NAME');
88: ELSE
89: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FIRST_NAME');
90: END IF;
91: END IF; */ --Removed as per bug 4150446
85: IF p_per_information3 IS NULL THEN
86: IF v_field IS NULL THEN
87: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FIRST_NAME');
88: ELSE
89: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FIRST_NAME');
90: END IF;
91: END IF; */ --Removed as per bug 4150446
92: /* IF p_per_information4 IS NULL THEN
93: IF v_field IS NULL THEN
90: END IF;
91: END IF; */ --Removed as per bug 4150446
92: /* IF p_per_information4 IS NULL THEN
93: IF v_field IS NULL THEN
94: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FATHER_NAME');
95: ELSE
96: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FATHER_NAME');
97: END IF;
98: END IF; */ --Removed as per enhancement bug 3580573
92: /* IF p_per_information4 IS NULL THEN
93: IF v_field IS NULL THEN
94: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FATHER_NAME');
95: ELSE
96: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FATHER_NAME');
97: END IF;
98: END IF; */ --Removed as per enhancement bug 3580573
99: /* IF p_per_information6 IS NULL THEN
100: IF v_field IS NULL THEN
97: END IF;
98: END IF; */ --Removed as per enhancement bug 3580573
99: /* IF p_per_information6 IS NULL THEN
100: IF v_field IS NULL THEN
101: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FAMILY_NAME');
102: ELSE
103: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FAMILY_NAME');
104: END IF;
105: END IF;
99: /* IF p_per_information6 IS NULL THEN
100: IF v_field IS NULL THEN
101: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FAMILY_NAME');
102: ELSE
103: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FAMILY_NAME');
104: END IF;
105: END IF;
106: END IF;*/ --Removed as per bug 4150446
107: OPEN c_type;
109: CLOSE c_type;
110: IF g_type IS NOT NULL THEN
111: /*IF p_per_information7 IS NULL THEN
112: IF v_field IS NULL THEN
113: v_field := hr_general.decode_lookup('SA_FORM_LABELS','RELIGION');
114: ELSE
115: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','RELIGION');
116: END IF;
117: END IF;*/
111: /*IF p_per_information7 IS NULL THEN
112: IF v_field IS NULL THEN
113: v_field := hr_general.decode_lookup('SA_FORM_LABELS','RELIGION');
114: ELSE
115: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','RELIGION');
116: END IF;
117: END IF;*/
118: IF per_per_bus.g_global_transfer_in_process IS NULL
119: OR per_per_bus.g_global_transfer_in_process = FALSE THEN -- To Fix for Bug 9109692
119: OR per_per_bus.g_global_transfer_in_process = FALSE THEN -- To Fix for Bug 9109692
120: IF l_emp_type = 'Y' THEN -- To Fix Bug 4438655
121: IF p_nationality IS NULL THEN
122: IF v_field IS NULL THEN
123: v_field := hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');
124: ELSE
125: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');
126: END IF;
127: END IF;
121: IF p_nationality IS NULL THEN
122: IF v_field IS NULL THEN
123: v_field := hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');
124: ELSE
125: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');
126: END IF;
127: END IF;
128: END IF; -- To Fix Bug 4438655
129: END IF; -- To fix for bug 9109692
499:
500: IF p_ctr_information_category = 'SA' THEN
501: IF p_type = 'SPECIFIED_PERIOD' THEN
502: IF p_duration IS NULL THEN
503: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION');
504: END IF;
505: IF p_duration_units IS NULL THEN
506: IF l_field IS NULL THEN
507: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
503: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION');
504: END IF;
505: IF p_duration_units IS NULL THEN
506: IF l_field IS NULL THEN
507: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
508: ELSE
509: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
510: END IF;
511: END IF;
505: IF p_duration_units IS NULL THEN
506: IF l_field IS NULL THEN
507: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
508: ELSE
509: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
510: END IF;
511: END IF;
512: END IF;
513: IF p_contractual_job_title IS NULL THEN
511: END IF;
512: END IF;
513: IF p_contractual_job_title IS NULL THEN
514: IF l_field IS NULL THEN
515: l_field := hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
516: ELSE
517: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
518: END IF;
519: END IF;
513: IF p_contractual_job_title IS NULL THEN
514: IF l_field IS NULL THEN
515: l_field := hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
516: ELSE
517: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
518: END IF;
519: END IF;
520: IF l_field IS NOT NULL THEN
521: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');