DBA Data[Home] [Help]

APPS.HR_SA_VALIDATE_PKG dependencies on HR_GENERAL

Line 49: v_field := hr_general.decode_lookup('SA_FORM_LABELS','TITLE');

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

Line 54: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_FIRST_NAME');

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;

Line 56: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_FIRST_NAME');

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

Line 62: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_FATHER_NAME');

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

Line 64: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_FATHER_NAME');

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

Line 71: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_GRANDFATHER_NAME');

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;*/

Line 73: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_GRANDFATHER_NAME');

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

Line 78: v_field := hr_general.decode_lookup('SA_FORM_LABELS','CIVIL_IDENTITY');

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;

Line 80: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','CIVIL_IDENTITY');

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

Line 87: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FIRST_NAME');

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

Line 89: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FIRST_NAME');

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

Line 94: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FATHER_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
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

Line 96: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FATHER_NAME');

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

Line 101: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FAMILY_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
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;

Line 103: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_ALT_FAMILY_NAME');

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;

Line 113: v_field := hr_general.decode_lookup('SA_FORM_LABELS','RELIGION');

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;*/

Line 115: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','RELIGION');

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

Line 121: v_field := hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');

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;

Line 123: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','NATIONALITY');

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;

Line 500: l_field := hr_general.decode_lookup('SA_FORM_LABELS','DURATION');

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

Line 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;

Line 506: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','DURATION_UNITS');

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

Line 512: l_field := hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');

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;

Line 514: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');

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