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

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

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;

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

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

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

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

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

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

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

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

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;

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

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