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 l_emp_type = 'Y' THEN -- To Fix Bug 4438655
119: IF p_nationality IS NULL THEN
117: END IF;*/
118: IF l_emp_type = 'Y' THEN -- To Fix Bug 4438655
119: IF p_nationality IS NULL THEN
120: IF v_field IS NULL THEN
121: v_field := hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');
122: ELSE
123: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');
124: END IF;
125: END IF;
119: IF p_nationality IS NULL THEN
120: IF v_field IS NULL THEN
121: v_field := hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');
122: ELSE
123: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');
124: END IF;
125: END IF;
126: END IF; -- To Fix Bug 4438655
127: END IF;
496:
497: IF p_ctr_information_category = 'SA' THEN
498: IF p_type = 'SPECIFIED_PERIOD' THEN
499: IF p_duration IS NULL THEN
500: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION');
501: END IF;
502: IF p_duration_units IS NULL THEN
503: IF l_field IS NULL THEN
504: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
500: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION');
501: END IF;
502: IF p_duration_units IS NULL THEN
503: IF l_field IS NULL THEN
504: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
505: ELSE
506: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
507: END IF;
508: END IF;
502: IF p_duration_units IS NULL THEN
503: IF l_field IS NULL THEN
504: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
505: ELSE
506: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');
507: END IF;
508: END IF;
509: END IF;
510: IF p_contractual_job_title IS NULL THEN
508: END IF;
509: END IF;
510: IF p_contractual_job_title IS NULL THEN
511: IF l_field IS NULL THEN
512: l_field := hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
513: ELSE
514: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
515: END IF;
516: END IF;
510: IF p_contractual_job_title IS NULL THEN
511: IF l_field IS NULL THEN
512: l_field := hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
513: ELSE
514: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
515: END IF;
516: END IF;
517: IF l_field IS NOT NULL THEN
518: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');