APPS.HR_RU_ASG_HOOK dependencies on HR_API

Line 66: IF p_segment1 <> hr_api.g_varchar2 THEN

62: ELSE
63: l_eff_start_date := l_eff_start_date;
64: l_eff_end_date := l_eff_end_date;
65: END IF;
66: IF p_segment1 <> hr_api.g_varchar2 THEN
67: BEGIN
68: select distinct hou.organization_id
69: INTO l_org_id
70: from HR_ALL_ORGANIZATION_UNITS hou, HR_ALL_ORGANIZATION_UNITS_TL hout, HR_ORGANIZATION_INFORMATION hoi

Line 87: IF p_segment2 <> hr_api.g_varchar2 OR p_segment2 IS NULL THEN

83: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','EMPLOYER'));
84: hr_utility.raise_error;
85: END;
86: END IF;
87: IF p_segment2 <> hr_api.g_varchar2 OR p_segment2 IS NULL THEN
88: IF p_segment2 IS NOT NULL THEN
89: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','EMP_TYPE'),
90: p_segment2,
91: 'YES_NO',

Line 107: IF p_segment3 <> hr_api.g_varchar2 THEN

103: hr_utility.raise_error;
104: END IF;
105: END IF;
106: END IF;
107: IF p_segment3 <> hr_api.g_varchar2 THEN
108: l_cont_status := hr_ru_utility.check_contract_number_unique(p_segment3
109: ,p_assignment_id
110: ,l_business_group_id
111: );

Line 117: IF p_segment4 <> hr_api.g_varchar2 THEN

113: hr_utility.set_message(800, 'HR_RU_INVALID_CONTRACT_NUMBER');
114: hr_utility.raise_error;
115: END IF;
116: END IF;
117: IF p_segment4 <> hr_api.g_varchar2 THEN
118: IF fnd_date.canonical_to_date(p_segment4) < l_min_start_date THEN
119: hr_utility.set_message(800, 'HR_RU_INVALID_ISSUE_DATE');
120: hr_utility.raise_error;
121: END IF;

Line 123: IF p_segment5 <> hr_api.g_varchar2 THEN

119: hr_utility.set_message(800, 'HR_RU_INVALID_ISSUE_DATE');
120: hr_utility.raise_error;
121: END IF;
122: END IF;
123: IF p_segment5 <> hr_api.g_varchar2 THEN
124: IF fnd_date.canonical_to_date(p_segment5) < l_min_start_date THEN
125: hr_utility.set_message(800, 'HR_RU_INVALID_END_DATE');
126: hr_utility.raise_error;
127: END IF;

Line 129: IF p_segment6 <> hr_api.g_varchar2 THEN

125: hr_utility.set_message(800, 'HR_RU_INVALID_END_DATE');
126: hr_utility.raise_error;
127: END IF;
128: END IF;
129: IF p_segment6 <> hr_api.g_varchar2 THEN
130: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','CONT_LIMIT_REASON'),
131: p_segment6,
132: 'RU_LIMITED_CONTRACT_REASON',
133: p_effective_date);

Line 135: IF p_assignment_status_type_id <> hr_api.g_number THEN

131: p_segment6,
132: 'RU_LIMITED_CONTRACT_REASON',
133: p_effective_date);
134: END IF;
135: IF p_assignment_status_type_id <> hr_api.g_number THEN
136: IF (p_assignment_status_type_id = 3 OR p_assignment_status_type_id = 8) AND
137: p_segment7 IS NULL THEN
138: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
139: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','TERM_REASON'));

Line 143: IF p_segment7 <> hr_api.g_varchar2 THEN

139: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','TERM_REASON'));
140: hr_utility.raise_error;
141: END IF;
142: END IF;
143: IF p_segment7 <> hr_api.g_varchar2 THEN
144: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','END_REASON'),
145: p_segment7,
146: 'LEAV_REAS',
147: p_effective_date);

Line 149: IF p_segment8 <> hr_api.g_varchar2 THEN

145: p_segment7,
146: 'LEAV_REAS',
147: p_effective_date);
148: END IF;
149: IF p_segment8 <> hr_api.g_varchar2 THEN
150: BEGIN
151: SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_SPECIAL_WORK_CONDITIONS'
152: AND lookup_code=p_segment8 AND enabled_flag='Y';
153: EXCEPTION

Line 160: IF p_segment12 <> hr_api.g_varchar2 THEN

156: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','SPECIAL_WORK_CONDITIONS'));
157: hr_utility.raise_error;
158: END;
159: END IF;
160: IF p_segment12 <> hr_api.g_varchar2 THEN
161: BEGIN
162: SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_LONG_SERVICE'
163: AND lookup_code=p_segment12 AND enabled_flag='Y';
164: EXCEPTION

Line 171: IF p_segment9 <> hr_api.g_varchar2 THEN

167: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','LONG_SERVICE_REASON'));
168: hr_utility.raise_error;
169: END;
170: END IF;
171: IF p_segment9 <> hr_api.g_varchar2 THEN
172: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TERRITORY_CONDITIONS'),
173: p_segment9,
174: 'RU_TERRITORY_CONDITIONS',
175: p_effective_date);

Line 177: IF p_segment10 <> hr_api.g_varchar2 THEN

173: p_segment9,
174: 'RU_TERRITORY_CONDITIONS',
175: p_effective_date);
176: END IF;
177: IF p_segment10 <> hr_api.g_varchar2 THEN
178: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','RECORD_SERVICE_REASON'),
179: p_segment10,
180: 'RU_CALC_RECORD_SERVICE',
181: p_effective_date);

Line 183: IF p_segment14 <> hr_api.g_varchar2 THEN

179: p_segment10,
180: 'RU_CALC_RECORD_SERVICE',
181: p_effective_date);
182: END IF;
183: IF p_segment14 <> hr_api.g_varchar2 THEN
184: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','UNINTERRUPTED_SERVICE_RECORD'),
185: p_segment14,
186: 'YES_NO',
187: p_effective_date);

Line 189: IF p_segment15 <> hr_api.g_varchar2 THEN

185: p_segment14,
186: 'YES_NO',
187: p_effective_date);
188: END IF;
189: IF p_segment15 <> hr_api.g_varchar2 THEN
190: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TOTAL_SERVICE_RECORD'),
191: p_segment15,
192: 'YES_NO',
193: p_effective_date);

Line 320: IF p_scl_segment8 <> hr_api.g_varchar2 THEN

316: p_scl_segment7,
317: 'LEAV_REAS',
318: p_effective_date);
319: END IF;
320: IF p_scl_segment8 <> hr_api.g_varchar2 THEN
321: BEGIN
322: SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_SPECIAL_WORK_CONDITIONS'
323: AND lookup_code=p_scl_segment8 AND enabled_flag='Y';
324: EXCEPTION

Line 331: IF p_scl_segment12 <> hr_api.g_varchar2 THEN

327: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','SPECIAL_WORK_CONDITIONS'));
328: hr_utility.raise_error;
329: END;
330: END IF;
331: IF p_scl_segment12 <> hr_api.g_varchar2 THEN
332: BEGIN
333: SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_LONG_SERVICE'
334: AND lookup_code=p_scl_segment12 AND enabled_flag='Y';
335: EXCEPTION

Line 342: IF p_scl_segment9 <> hr_api.g_varchar2 THEN

338: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','LONG_SERVICE_REASON'));
339: hr_utility.raise_error;
340: END;
341: END IF;
342: IF p_scl_segment9 <> hr_api.g_varchar2 THEN
343: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TERRITORY_CONDITIONS'),
344: p_scl_segment9,
345: 'RU_TERRITORY_CONDITIONS',
346: p_effective_date);

Line 348: IF p_scl_segment10 <> hr_api.g_varchar2 THEN

344: p_scl_segment9,
345: 'RU_TERRITORY_CONDITIONS',
346: p_effective_date);
347: END IF;
348: IF p_scl_segment10 <> hr_api.g_varchar2 THEN
349: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','RECORD_SERVICE_REASON'),
350: p_scl_segment10,
351: 'RU_CALC_RECORD_SERVICE',
352: p_effective_date);

Line 354: IF p_scl_segment14 <> hr_api.g_varchar2 THEN

350: p_scl_segment10,
351: 'RU_CALC_RECORD_SERVICE',
352: p_effective_date);
353: END IF;
354: IF p_scl_segment14 <> hr_api.g_varchar2 THEN
355: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','UNINTERRUPTED_SERVICE_RECORD'),
356: p_scl_segment14,
357: 'YES_NO',
358: p_effective_date);

Line 360: IF p_scl_segment15 <> hr_api.g_varchar2 THEN

356: p_scl_segment14,
357: 'YES_NO',
358: p_effective_date);
359: END IF;
360: IF p_scl_segment15 <> hr_api.g_varchar2 THEN
361: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TOTAL_SERVICE_RECORD'),
362: p_scl_segment15,
363: 'YES_NO',
364: p_effective_date);