[Home] [Help]
42:
43: return l_personid;
44: Exception
45: When others then
46: hr_utility.set_location(g_package_name||'get_person_id',10);
47: hr_utility.raise_error;
48: end get_person_id;
49:
50:
43: return l_personid;
44: Exception
45: When others then
46: hr_utility.set_location(g_package_name||'get_person_id',10);
47: hr_utility.raise_error;
48: end get_person_id;
49:
50:
51: PROCEDURE create_pl_secondary_emp_asg
100:
101: g_package_name :='PER_PL_ASSIGNMENT.';
102: l_proc := g_package_name||'CREATE_PL_SECONDARY_EMP_ASG';
103: /* Added for GSI Bug 5472781 */
104: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
105: hr_utility.set_location('Leaving : '||l_proc,10);
106: return;
107: END IF;
108: hr_utility.set_location(l_proc,10);
101: g_package_name :='PER_PL_ASSIGNMENT.';
102: l_proc := g_package_name||'CREATE_PL_SECONDARY_EMP_ASG';
103: /* Added for GSI Bug 5472781 */
104: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
105: hr_utility.set_location('Leaving : '||l_proc,10);
106: return;
107: END IF;
108: hr_utility.set_location(l_proc,10);
109:
104: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
105: hr_utility.set_location('Leaving : '||l_proc,10);
106: return;
107: END IF;
108: hr_utility.set_location(l_proc,10);
109:
110:
111: hr_api.mandatory_arg_error --Contract Category is mandatory
112: (p_api_name => l_proc,
138: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'),
139: p_argument_value => p_scl_segment14
140: );
141:
142: hr_utility.set_location(l_proc,20);
143: ------Conditionally mandatory---------
144: --------for a normal contract,the assignment category is mandatory...
145: -------core store this in employment_category in per_all_assignments_f table..displays it as assignment_category on UI
146: if p_scl_segment3='NORMAL' then
158: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),
159: p_argument_value => P_SCL_SEGMENT12
160: );
161: elsif p_scl_segment12 is not null then
162: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
163: hr_utility.raise_error;
164: end if;
165:
166: -----if any of the following 3 has been entered then ..other two become mandatory
159: p_argument_value => P_SCL_SEGMENT12
160: );
161: elsif p_scl_segment12 is not null then
162: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
163: hr_utility.raise_error;
164: end if;
165:
166: -----if any of the following 3 has been entered then ..other two become mandatory
167: -----Notice Period Date(p_scl_segment15),Notice Period End Date(p_scl_segment16),Notice Period(p_notice_period)
182: p_argument_value => p_notice_period
183: );
184: if ( (p_NOTICE_PERIOD_UOM like '_1' and p_notice_period >1) or
185: (p_NOTICE_PERIOD_UOM like '_' and p_notice_period =1)) then
186: hr_utility.set_message(800,'HR_375856_NOTICE_UNIT_MISMATCH');
187: hr_utility.raise_error;
188: end if;
189: end if;
190: -----if p_notice_period is entered and notice_period_uom is null??
183: );
184: if ( (p_NOTICE_PERIOD_UOM like '_1' and p_notice_period >1) or
185: (p_NOTICE_PERIOD_UOM like '_' and p_notice_period =1)) then
186: hr_utility.set_message(800,'HR_375856_NOTICE_UNIT_MISMATCH');
187: hr_utility.raise_error;
188: end if;
189: end if;
190: -----if p_notice_period is entered and notice_period_uom is null??
191: -----taken care by core per_asg_bus3.chk_notice_period_uom
194: --Bug 4504375
195: -- change of contract reason and contract type change date are mandatory
196: -- if any one of them is not null
197: if p_scl_segment6 is not null and p_scl_segment13 is null then
198: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
199: hr_utility.set_message_token(l_token_name=>'DETAIL1',
200: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
201: hr_utility.set_message_token(l_token_name=>'DETAIL2',
202: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
195: -- change of contract reason and contract type change date are mandatory
196: -- if any one of them is not null
197: if p_scl_segment6 is not null and p_scl_segment13 is null then
198: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
199: hr_utility.set_message_token(l_token_name=>'DETAIL1',
200: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
201: hr_utility.set_message_token(l_token_name=>'DETAIL2',
202: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
203:
197: if p_scl_segment6 is not null and p_scl_segment13 is null then
198: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
199: hr_utility.set_message_token(l_token_name=>'DETAIL1',
200: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
201: hr_utility.set_message_token(l_token_name=>'DETAIL2',
202: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
203:
204: hr_utility.raise_error;
205: elsif p_scl_segment6 is null and p_scl_segment13 is not null then
200: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
201: hr_utility.set_message_token(l_token_name=>'DETAIL2',
202: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
203:
204: hr_utility.raise_error;
205: elsif p_scl_segment6 is null and p_scl_segment13 is not null then
206: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
207: hr_utility.set_message_token(l_token_name=>'DETAIL1',
208: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
202: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
203:
204: hr_utility.raise_error;
205: elsif p_scl_segment6 is null and p_scl_segment13 is not null then
206: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
207: hr_utility.set_message_token(l_token_name=>'DETAIL1',
208: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
209:
210: hr_utility.set_message_token(l_token_name=>'DETAIL2',
203:
204: hr_utility.raise_error;
205: elsif p_scl_segment6 is null and p_scl_segment13 is not null then
206: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
207: hr_utility.set_message_token(l_token_name=>'DETAIL1',
208: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
209:
210: hr_utility.set_message_token(l_token_name=>'DETAIL2',
211: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
206: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
207: hr_utility.set_message_token(l_token_name=>'DETAIL1',
208: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
209:
210: hr_utility.set_message_token(l_token_name=>'DETAIL2',
211: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
212: hr_utility.raise_error;
213: end if;
214:
208: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
209:
210: hr_utility.set_message_token(l_token_name=>'DETAIL2',
211: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
212: hr_utility.raise_error;
213: end if;
214:
215: -----other validations like value set comparison will be taken
216: -----care by core when they validate the flexfields.
214:
215: -----other validations like value set comparison will be taken
216: -----care by core when they validate the flexfields.
217: -----what we need to check are the dates being entered.
218: hr_utility.set_location(l_proc,30);
219: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
220: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
221: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
222: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
216: -----care by core when they validate the flexfields.
217: -----what we need to check are the dates being entered.
218: hr_utility.set_location(l_proc,30);
219: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
220: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
221: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
222: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
223: hr_utility.raise_error;
224:
217: -----what we need to check are the dates being entered.
218: hr_utility.set_location(l_proc,30);
219: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
220: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
221: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
222: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
223: hr_utility.raise_error;
224:
225: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
218: hr_utility.set_location(l_proc,30);
219: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
220: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
221: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
222: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
223: hr_utility.raise_error;
224:
225: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
226: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
219: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
220: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
221: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
222: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
223: hr_utility.raise_error;
224:
225: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
226: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
227: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
222: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
223: hr_utility.raise_error;
224:
225: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
226: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
227: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
228: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
229: hr_utility.raise_error;
230:
223: hr_utility.raise_error;
224:
225: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
226: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
227: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
228: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
229: hr_utility.raise_error;
230:
231: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
224:
225: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
226: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
227: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
228: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
229: hr_utility.raise_error;
230:
231: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
232: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
225: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
226: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
227: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
228: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
229: hr_utility.raise_error;
230:
231: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
232: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
233: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
228: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
229: hr_utility.raise_error;
230:
231: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
232: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
233: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
234: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
235: hr_utility.raise_error;
236:
229: hr_utility.raise_error;
230:
231: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
232: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
233: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
234: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
235: hr_utility.raise_error;
236:
237: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
230:
231: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
232: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
233: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
234: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
235: hr_utility.raise_error;
236:
237: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
238: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
231: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
232: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
233: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
234: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
235: hr_utility.raise_error;
236:
237: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
238: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
239: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
235: hr_utility.raise_error;
236:
237: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
238: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
239: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
240: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
241: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
242: hr_utility.raise_error;
243:
236:
237: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
238: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
239: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
240: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
241: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
242: hr_utility.raise_error;
243:
244:
237: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
238: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
239: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
240: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
241: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
242: hr_utility.raise_error;
243:
244:
245: /*
238: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
239: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
240: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
241: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
242: hr_utility.raise_error;
243:
244:
245: /*
246: This check has been removed because of bug 4504312 DATE CONTRACT SIGNED1 ACCEPTS DATES EVEN AFTER THE CONTRACT START DATE
247: Hence Date Contract Signed must be before or same as Contract Start Date. ie)(p_scl_segment14)<(p_scl_segment11)is the condition
248: to be held correct.Otherwise a note message is to be thrown.Since note messages cannot be thrown from api's there wont be any check for
249: Date contract Signed.
250: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
251: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
252: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
253: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
254: hr_utility.raise_error;
255: */
248: to be held correct.Otherwise a note message is to be thrown.Since note messages cannot be thrown from api's there wont be any check for
249: Date contract Signed.
250: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
251: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
252: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
253: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
254: hr_utility.raise_error;
255: */
256:
249: Date contract Signed.
250: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
251: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
252: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
253: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
254: hr_utility.raise_error;
255: */
256:
257: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
250: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
251: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
252: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
253: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
254: hr_utility.raise_error;
255: */
256:
257: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
258: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
254: hr_utility.raise_error;
255: */
256:
257: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
258: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
259: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
260: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
261: hr_utility.raise_error;
262: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
255: */
256:
257: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
258: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
259: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
260: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
261: hr_utility.raise_error;
262: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
263: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
256:
257: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
258: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
259: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
260: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
261: hr_utility.raise_error;
262: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
263: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
264: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
257: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
258: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
259: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
260: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
261: hr_utility.raise_error;
262: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
263: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
264: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
265: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
259: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
260: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
261: hr_utility.raise_error;
262: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
263: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
264: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
265: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
266: hr_utility.raise_error;
267: elsif p_payroll_id is not null then
260: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
261: hr_utility.raise_error;
262: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
263: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
264: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
265: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
266: hr_utility.raise_error;
267: elsif p_payroll_id is not null then
268:
261: hr_utility.raise_error;
262: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
263: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
264: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
265: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
266: hr_utility.raise_error;
267: elsif p_payroll_id is not null then
268:
269: l_oldage_pension_rights:=null;
262: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
263: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
264: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
265: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
266: hr_utility.raise_error;
267: elsif p_payroll_id is not null then
268:
269: l_oldage_pension_rights:=null;
270:
274:
275: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
276: But this is redundant as For Polish Employee these are mandatory
277: if l_nip is null then
278: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
279: hr_utility.raise_error;
280: end if; */
281:
282: if l_oldage_pension_rights is null then
275: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
276: But this is redundant as For Polish Employee these are mandatory
277: if l_nip is null then
278: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
279: hr_utility.raise_error;
280: end if; */
281:
282: if l_oldage_pension_rights is null then
283: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
279: hr_utility.raise_error;
280: end if; */
281:
282: if l_oldage_pension_rights is null then
283: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
284: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
285: hr_utility.raise_error;
286: end if;
287:
280: end if; */
281:
282: if l_oldage_pension_rights is null then
283: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
284: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
285: hr_utility.raise_error;
286: end if;
287:
288: if l_tax_office is null then
281:
282: if l_oldage_pension_rights is null then
283: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
284: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
285: hr_utility.raise_error;
286: end if;
287:
288: if l_tax_office is null then
289: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
285: hr_utility.raise_error;
286: end if;
287:
288: if l_tax_office is null then
289: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
290: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
291: hr_utility.raise_error;
292: end if;
293:
286: end if;
287:
288: if l_tax_office is null then
289: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
290: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
291: hr_utility.raise_error;
292: end if;
293:
294: -- Bug 9534572
287:
288: if l_tax_office is null then
289: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
290: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
291: hr_utility.raise_error;
292: end if;
293:
294: -- Bug 9534572
295: -- As we do not deliver Oracle Payroll functionality specific to Polish legislation,
301:
302: --if p_scl_segment3 in ('CIVIL','F_LUMP','LUMP') then
303: --we cannot have a civil contract with payroll id while creating...
304: --this is bcoz .user in no way that we can have a tax or sii record ..as they need assignment id to have sii record...
305: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
306: -- hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
307: -- hr_utility.raise_error;
308: --end if;
309:
302: --if p_scl_segment3 in ('CIVIL','F_LUMP','LUMP') then
303: --we cannot have a civil contract with payroll id while creating...
304: --this is bcoz .user in no way that we can have a tax or sii record ..as they need assignment id to have sii record...
305: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
306: -- hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
307: -- hr_utility.raise_error;
308: --end if;
309:
310:
303: --we cannot have a civil contract with payroll id while creating...
304: --this is bcoz .user in no way that we can have a tax or sii record ..as they need assignment id to have sii record...
305: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
306: -- hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
307: -- hr_utility.raise_error;
308: --end if;
309:
310:
311: --open csr_check_sii_exists(p_person_id,p_effective_date) ;
312: --fetch csr_check_sii_exists into l_one;
313: --close csr_check_sii_exists;
314:
315: --if l_one <> 1 then
316: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
317: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
318: -- hr_utility.raise_error;
319: --end if;
320:
313: --close csr_check_sii_exists;
314:
315: --if l_one <> 1 then
316: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
317: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
318: -- hr_utility.raise_error;
319: --end if;
320:
321: --l_one:=0;
314:
315: --if l_one <> 1 then
316: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
317: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
318: -- hr_utility.raise_error;
319: --end if;
320:
321: --l_one:=0;
322:
324: --fetch csr_check_paye_exists into l_one;
325: --close csr_check_paye_exists;
326:
327: --if l_one<> 1 then
328: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
329: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
330: -- hr_utility.raise_error;
331: --end if;
332: */
325: --close csr_check_paye_exists;
326:
327: --if l_one<> 1 then
328: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
329: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
330: -- hr_utility.raise_error;
331: --end if;
332: */
333:
326:
327: --if l_one<> 1 then
328: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
329: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
330: -- hr_utility.raise_error;
331: --end if;
332: */
333:
334:
333:
334:
335: end if; --date checks over
336:
337: hr_utility.set_location(l_proc,40);
338: Exception
339: when others then
340: hr_utility.set_location(l_proc,50);
341: hr_utility.raise_error;
336:
337: hr_utility.set_location(l_proc,40);
338: Exception
339: when others then
340: hr_utility.set_location(l_proc,50);
341: hr_utility.raise_error;
342: end create_pl_secondary_emp_asg;
343:
344:
337: hr_utility.set_location(l_proc,40);
338: Exception
339: when others then
340: hr_utility.set_location(l_proc,50);
341: hr_utility.raise_error;
342: end create_pl_secondary_emp_asg;
343:
344:
345: ---------start of update_pl_emp_asg-----------
440: --7)payroll check ..get it from the table and then do the validation
441: g_package_name :='PER_PL_ASSIGNMENT.';
442: l_proc:=g_package_name||'UPDATE_PL_EMP_ASG';
443: /* Added for GSI Bug 5472781 */
444: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
445: hr_utility.set_location('Leaving : '||l_proc,10);
446: return;
447: END IF;
448: hr_utility.set_location(l_proc,10);
441: g_package_name :='PER_PL_ASSIGNMENT.';
442: l_proc:=g_package_name||'UPDATE_PL_EMP_ASG';
443: /* Added for GSI Bug 5472781 */
444: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
445: hr_utility.set_location('Leaving : '||l_proc,10);
446: return;
447: END IF;
448: hr_utility.set_location(l_proc,10);
449: l_person_id:= get_person_id(p_assignment_id,p_effective_date);
444: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
445: hr_utility.set_location('Leaving : '||l_proc,10);
446: return;
447: END IF;
448: hr_utility.set_location(l_proc,10);
449: l_person_id:= get_person_id(p_assignment_id,p_effective_date);
450:
451: --Added for Bug 7510498
452: --Modified for Bug 7554037
531: p_argument_value => l_segment14
532: );
533:
534:
535: hr_utility.set_location(l_proc,20);
536:
537: ------Conditionally mandatory---------
538: /*
539: 1)update_emp_asg_criteria will be called first..this is where the payroll id,employment_category will be set
559: p_argument_value => l_SEGMENT12
560: );
561: elsif p_segment12<>hr_api.g_varchar2 then --replaced in 115.11
562: --Bug 5386451
563: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
564: hr_utility.raise_error;
565: end if;
566:
567: --Added for Bug 7554037
560: );
561: elsif p_segment12<>hr_api.g_varchar2 then --replaced in 115.11
562: --Bug 5386451
563: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
564: hr_utility.raise_error;
565: end if;
566:
567: --Added for Bug 7554037
568: OPEN csr_get_notice_details;
610: );
611:
612: if ( (l_notice_uom like '_1' and l_notice_period >1) or
613: (l_notice_uom like '_' and l_notice_period =1)) then
614: hr_utility.set_message(800,'HR_375856_NOTICE_UNIT_MISMATCH');
615: hr_utility.raise_error;
616: end if;
617: end if;
618:
611:
612: if ( (l_notice_uom like '_1' and l_notice_period >1) or
613: (l_notice_uom like '_' and l_notice_period =1)) then
614: hr_utility.set_message(800,'HR_375856_NOTICE_UNIT_MISMATCH');
615: hr_utility.raise_error;
616: end if;
617: end if;
618:
619: end if ; -- Bug#11888146
625: --Bug 4504375
626: -- change of contract reason and contract type change date are mandatory
627: -- if any one of them is not null
628: if p_segment6 is not null and p_segment13 is null then
629: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
630: hr_utility.set_message_token(l_token_name=>'DETAIL1',
631: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
632: hr_utility.set_message_token(l_token_name=>'DETAIL2',
633: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
626: -- change of contract reason and contract type change date are mandatory
627: -- if any one of them is not null
628: if p_segment6 is not null and p_segment13 is null then
629: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
630: hr_utility.set_message_token(l_token_name=>'DETAIL1',
631: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
632: hr_utility.set_message_token(l_token_name=>'DETAIL2',
633: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
634:
628: if p_segment6 is not null and p_segment13 is null then
629: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
630: hr_utility.set_message_token(l_token_name=>'DETAIL1',
631: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
632: hr_utility.set_message_token(l_token_name=>'DETAIL2',
633: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
634:
635: hr_utility.raise_error;
636: elsif p_segment6 is null and p_segment13 is not null then
631: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
632: hr_utility.set_message_token(l_token_name=>'DETAIL2',
633: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
634:
635: hr_utility.raise_error;
636: elsif p_segment6 is null and p_segment13 is not null then
637: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
638: hr_utility.set_message_token(l_token_name=>'DETAIL1',
639: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
633: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
634:
635: hr_utility.raise_error;
636: elsif p_segment6 is null and p_segment13 is not null then
637: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
638: hr_utility.set_message_token(l_token_name=>'DETAIL1',
639: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
640:
641: hr_utility.set_message_token(l_token_name=>'DETAIL2',
634:
635: hr_utility.raise_error;
636: elsif p_segment6 is null and p_segment13 is not null then
637: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
638: hr_utility.set_message_token(l_token_name=>'DETAIL1',
639: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
640:
641: hr_utility.set_message_token(l_token_name=>'DETAIL2',
642: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
637: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
638: hr_utility.set_message_token(l_token_name=>'DETAIL1',
639: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
640:
641: hr_utility.set_message_token(l_token_name=>'DETAIL2',
642: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
643: hr_utility.raise_error;
644: end if;
645:
639: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
640:
641: hr_utility.set_message_token(l_token_name=>'DETAIL2',
642: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
643: hr_utility.raise_error;
644: end if;
645:
646:
647:
653: --no need to check for null ...
654:
655: --contract category cannot be changed once created
656: if (l_contract_category <> p_segment3) AND (p_segment3 <> hr_api.g_varchar2) then --changed for Bug 7510498
657: hr_utility.set_message(800,'HR_375868_DONT_CHANGE_CATEGORY');
658: hr_utility.raise_error;
659: end if;
660:
661: --contract type change allowed only after reason and change date are provided
654:
655: --contract category cannot be changed once created
656: if (l_contract_category <> p_segment3) AND (p_segment3 <> hr_api.g_varchar2) then --changed for Bug 7510498
657: hr_utility.set_message(800,'HR_375868_DONT_CHANGE_CATEGORY');
658: hr_utility.raise_error;
659: end if;
660:
661: --contract type change allowed only after reason and change date are provided
662: --p_contract_type cannot be null...no check if user is updating it from null to some contract type
661: --contract type change allowed only after reason and change date are provided
662: --p_contract_type cannot be null...no check if user is updating it from null to some contract type
663: if (l_contract_type <> p_segment4) AND (p_segment4 <> hr_api.g_varchar2) THEN --changed for Bug 7510498
664: if(l_contract_change_reason is null or (p_effective_date-1)<>nvl(l_contract_type_change_date,p_effective_date)) then
665: hr_utility.set_message(800,'HR_375867_DISALLOW_TYPE_CHANGE');
666: hr_utility.raise_error;
667: end if;
668: end if;
669:
662: --p_contract_type cannot be null...no check if user is updating it from null to some contract type
663: if (l_contract_type <> p_segment4) AND (p_segment4 <> hr_api.g_varchar2) THEN --changed for Bug 7510498
664: if(l_contract_change_reason is null or (p_effective_date-1)<>nvl(l_contract_type_change_date,p_effective_date)) then
665: hr_utility.set_message(800,'HR_375867_DISALLOW_TYPE_CHANGE');
666: hr_utility.raise_error;
667: end if;
668: end if;
669:
670:
669:
670:
671: --contract length to be within 30 characters
672: if length(p_segment5)>30 AND (p_segment5 <> hr_api.g_varchar2) THEN --changed for Bug 7510498
673: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
674: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
675: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
676: hr_utility.raise_error;
677: end if;
670:
671: --contract length to be within 30 characters
672: if length(p_segment5)>30 AND (p_segment5 <> hr_api.g_varchar2) THEN --changed for Bug 7510498
673: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
674: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
675: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
676: hr_utility.raise_error;
677: end if;
678:
671: --contract length to be within 30 characters
672: if length(p_segment5)>30 AND (p_segment5 <> hr_api.g_varchar2) THEN --changed for Bug 7510498
673: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
674: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
675: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
676: hr_utility.raise_error;
677: end if;
678:
679: -----other validations like value set comparison will be taken
672: if length(p_segment5)>30 AND (p_segment5 <> hr_api.g_varchar2) THEN --changed for Bug 7510498
673: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
674: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
675: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
676: hr_utility.raise_error;
677: end if;
678:
679: -----other validations like value set comparison will be taken
680: ----care by core when they validate the flexfields.
679: -----other validations like value set comparison will be taken
680: ----care by core when they validate the flexfields.
681: -----what we need to check are the dates being entered.
682:
683: hr_utility.set_location(l_proc,30);
684:
685: -- Bug 7041296
686: -- pick minimum start date of assignment
687: -- and compare contract_start_date with minimum(assignment eff_start_date)
689: fetch csr_effective_start_date into l_asg_min_start_date;
690: close csr_effective_start_date;
691:
692:
693: --hr_utility.trace('Bug 7041296 : p_segment11 :'||p_segment11||'l_asg_min_start_date:'||l_asg_min_start_date);
694: --Changed for Bug 7510498
695: if fnd_date.canonical_to_date(l_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
696: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
697: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
692:
693: --hr_utility.trace('Bug 7041296 : p_segment11 :'||p_segment11||'l_asg_min_start_date:'||l_asg_min_start_date);
694: --Changed for Bug 7510498
695: if fnd_date.canonical_to_date(l_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
696: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
697: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
698: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
699: hr_utility.raise_error;
700:
693: --hr_utility.trace('Bug 7041296 : p_segment11 :'||p_segment11||'l_asg_min_start_date:'||l_asg_min_start_date);
694: --Changed for Bug 7510498
695: if fnd_date.canonical_to_date(l_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
696: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
697: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
698: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
699: hr_utility.raise_error;
700:
701: elsif fnd_date.canonical_to_date(l_segment12) < fnd_date.canonical_to_date(l_segment11) then
694: --Changed for Bug 7510498
695: if fnd_date.canonical_to_date(l_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
696: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
697: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
698: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
699: hr_utility.raise_error;
700:
701: elsif fnd_date.canonical_to_date(l_segment12) < fnd_date.canonical_to_date(l_segment11) then
702: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
695: if fnd_date.canonical_to_date(l_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
696: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
697: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
698: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
699: hr_utility.raise_error;
700:
701: elsif fnd_date.canonical_to_date(l_segment12) < fnd_date.canonical_to_date(l_segment11) then
702: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
703: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
698: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
699: hr_utility.raise_error;
700:
701: elsif fnd_date.canonical_to_date(l_segment12) < fnd_date.canonical_to_date(l_segment11) then
702: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
703: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
704: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
705: hr_utility.raise_error;
706:
699: hr_utility.raise_error;
700:
701: elsif fnd_date.canonical_to_date(l_segment12) < fnd_date.canonical_to_date(l_segment11) then
702: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
703: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
704: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
705: hr_utility.raise_error;
706:
707: ELSIF fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment11) then
700:
701: elsif fnd_date.canonical_to_date(l_segment12) < fnd_date.canonical_to_date(l_segment11) then
702: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
703: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
704: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
705: hr_utility.raise_error;
706:
707: ELSIF fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment11) then
708: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
701: elsif fnd_date.canonical_to_date(l_segment12) < fnd_date.canonical_to_date(l_segment11) then
702: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
703: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
704: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
705: hr_utility.raise_error;
706:
707: ELSIF fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment11) then
708: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
709: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
704: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
705: hr_utility.raise_error;
706:
707: ELSIF fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment11) then
708: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
709: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
710: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
711: hr_utility.raise_error;
712:
705: hr_utility.raise_error;
706:
707: ELSIF fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment11) then
708: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
709: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
710: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
711: hr_utility.raise_error;
712:
713: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
706:
707: ELSIF fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment11) then
708: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
709: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
710: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
711: hr_utility.raise_error;
712:
713: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
714: elsif fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment14) then
707: ELSIF fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment11) then
708: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
709: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
710: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
711: hr_utility.raise_error;
712:
713: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
714: elsif fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment14) then
715: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
711: hr_utility.raise_error;
712:
713: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
714: elsif fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment14) then
715: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
716: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
717: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
718: hr_utility.raise_error;
719:
712:
713: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
714: elsif fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment14) then
715: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
716: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
717: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
718: hr_utility.raise_error;
719:
720: /*
713: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
714: elsif fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment14) then
715: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
716: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
717: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
718: hr_utility.raise_error;
719:
720: /*
721: This check has been removed because of bug 4504312 DATE CONTRACT SIGNE D ACCEPTS DATES EVEN AFTER THE CONTRACT START DATE
714: elsif fnd_date.canonical_to_date(l_segment13) < fnd_date.canonical_to_date(l_segment14) then
715: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
716: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
717: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
718: hr_utility.raise_error;
719:
720: /*
721: This check has been removed because of bug 4504312 DATE CONTRACT SIGNE D ACCEPTS DATES EVEN AFTER THE CONTRACT START DATE
722: Hence Date Contract Signed must be before or same as Contract Start Date. ie)(p_scl_segment14)<(p_scl_segment11)is the condition
722: Hence Date Contract Signed must be before or same as Contract Start Date. ie)(p_scl_segment14)<(p_scl_segment11)is the condition
723: to be held correct.Otherwise a note message is to be thrown.Since note messages cannot be thrown from api's there wont be any check for
724: Date contract Signed.
725: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
726: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
727: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
728: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
729: hr_utility.raise_error;
730: */
723: to be held correct.Otherwise a note message is to be thrown.Since note messages cannot be thrown from api's there wont be any check for
724: Date contract Signed.
725: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
726: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
727: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
728: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
729: hr_utility.raise_error;
730: */
731:
724: Date contract Signed.
725: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
726: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
727: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
728: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
729: hr_utility.raise_error;
730: */
731:
732: elsif fnd_date.canonical_to_date(l_segment15) < fnd_date.canonical_to_date(l_segment11) then
725: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
726: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
727: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
728: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
729: hr_utility.raise_error;
730: */
731:
732: elsif fnd_date.canonical_to_date(l_segment15) < fnd_date.canonical_to_date(l_segment11) then
733: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
729: hr_utility.raise_error;
730: */
731:
732: elsif fnd_date.canonical_to_date(l_segment15) < fnd_date.canonical_to_date(l_segment11) then
733: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
734: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
735: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
736: hr_utility.raise_error;
737: elsif fnd_date.canonical_to_date(l_segment16) < fnd_date.canonical_to_date(l_segment15) then
730: */
731:
732: elsif fnd_date.canonical_to_date(l_segment15) < fnd_date.canonical_to_date(l_segment11) then
733: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
734: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
735: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
736: hr_utility.raise_error;
737: elsif fnd_date.canonical_to_date(l_segment16) < fnd_date.canonical_to_date(l_segment15) then
738: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
731:
732: elsif fnd_date.canonical_to_date(l_segment15) < fnd_date.canonical_to_date(l_segment11) then
733: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
734: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
735: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
736: hr_utility.raise_error;
737: elsif fnd_date.canonical_to_date(l_segment16) < fnd_date.canonical_to_date(l_segment15) then
738: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
739: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
732: elsif fnd_date.canonical_to_date(l_segment15) < fnd_date.canonical_to_date(l_segment11) then
733: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
734: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
735: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
736: hr_utility.raise_error;
737: elsif fnd_date.canonical_to_date(l_segment16) < fnd_date.canonical_to_date(l_segment15) then
738: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
739: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
740: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
734: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
735: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
736: hr_utility.raise_error;
737: elsif fnd_date.canonical_to_date(l_segment16) < fnd_date.canonical_to_date(l_segment15) then
738: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
739: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
740: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
741: hr_utility.raise_error;
742: else
735: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
736: hr_utility.raise_error;
737: elsif fnd_date.canonical_to_date(l_segment16) < fnd_date.canonical_to_date(l_segment15) then
738: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
739: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
740: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
741: hr_utility.raise_error;
742: else
743:
736: hr_utility.raise_error;
737: elsif fnd_date.canonical_to_date(l_segment16) < fnd_date.canonical_to_date(l_segment15) then
738: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
739: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
740: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
741: hr_utility.raise_error;
742: else
743:
744: --if status has been changed ..then create sii/paye record from existing tax record if they already exist
737: elsif fnd_date.canonical_to_date(l_segment16) < fnd_date.canonical_to_date(l_segment15) then
738: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
739: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
740: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
741: hr_utility.raise_error;
742: else
743:
744: --if status has been changed ..then create sii/paye record from existing tax record if they already exist
745: open csr_assgt_type(p_assignment_id,p_effective_date-1);
911:
912: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
913: But this is redundant as For Polish Employee these are mandatory
914: if l_nip is null then
915: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
916: hr_utility.raise_error;
917: end if;
918: */
919:
912: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
913: But this is redundant as For Polish Employee these are mandatory
914: if l_nip is null then
915: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
916: hr_utility.raise_error;
917: end if;
918: */
919:
920: if l_oldage_pension_rights is null then
917: end if;
918: */
919:
920: if l_oldage_pension_rights is null then
921: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
922: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
923: hr_utility.raise_error;
924: end if;
925:
918: */
919:
920: if l_oldage_pension_rights is null then
921: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
922: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
923: hr_utility.raise_error;
924: end if;
925:
926: if l_tax_office is null then
919:
920: if l_oldage_pension_rights is null then
921: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
922: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
923: hr_utility.raise_error;
924: end if;
925:
926: if l_tax_office is null then
927: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
923: hr_utility.raise_error;
924: end if;
925:
926: if l_tax_office is null then
927: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
928: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
929: hr_utility.raise_error;
930: end if;
931:
924: end if;
925:
926: if l_tax_office is null then
927: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
928: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
929: hr_utility.raise_error;
930: end if;
931:
932:
925:
926: if l_tax_office is null then
927: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
928: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
929: hr_utility.raise_error;
930: end if;
931:
932:
933: open csr_assgt_type(p_assignment_id,p_effective_date) ;
953: --fetch csr_check_sii_exists into l_one;
954: --close csr_check_sii_exists;
955:
956: --if l_one <> 1 then
957: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
958: --hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
959: --hr_utility.raise_error;
960: --end if;
961:
954: --close csr_check_sii_exists;
955:
956: --if l_one <> 1 then
957: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
958: --hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
959: --hr_utility.raise_error;
960: --end if;
961:
962: --l_one:=0;
955:
956: --if l_one <> 1 then
957: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
958: --hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
959: --hr_utility.raise_error;
960: --end if;
961:
962: --l_one:=0;
963: --open csr_check_paye_exists(l_join_variable,p_effective_date);
964: --fetch csr_check_paye_exists into l_one;
965: --close csr_check_paye_exists;
966:
967: --if l_one <> 1 then
968: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
969: --hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
970: --hr_utility.raise_error;
971: --end if;
972: */
965: --close csr_check_paye_exists;
966:
967: --if l_one <> 1 then
968: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
969: --hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
970: --hr_utility.raise_error;
971: --end if;
972: */
973:
966:
967: --if l_one <> 1 then
968: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
969: --hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
970: --hr_utility.raise_error;
971: --end if;
972: */
973:
974: end if;--is payroll id null?
972: */
973:
974: end if;--is payroll id null?
975: end if;--end of date checks
976: hr_utility.set_location('Leaving '||l_proc,30);
977: exception
978: when others then
979: hr_utility.set_location(l_proc,99);
980: hr_utility.raise_error;
975: end if;--end of date checks
976: hr_utility.set_location('Leaving '||l_proc,30);
977: exception
978: when others then
979: hr_utility.set_location(l_proc,99);
980: hr_utility.raise_error;
981: end ;
982: ----end of update_pl_emp_asg----
983:
976: hr_utility.set_location('Leaving '||l_proc,30);
977: exception
978: when others then
979: hr_utility.set_location(l_proc,99);
980: hr_utility.raise_error;
981: end ;
982: ----end of update_pl_emp_asg----
983:
984: ----Start of Update_pl_emp_asg_criteria----
1015: Begin
1016: g_package_name :='PER_PL_ASSIGNMENT.';
1017: l_proc:=g_package_name||'UPDATE_PL_EMP_ASG_CRITERIA';
1018: /* Added for GSI Bug 5472781 */
1019: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1020: hr_utility.set_location('Leaving : '||l_proc,10);
1021: return;
1022: END IF;
1023: hr_utility.set_location(l_proc,10);
1016: g_package_name :='PER_PL_ASSIGNMENT.';
1017: l_proc:=g_package_name||'UPDATE_PL_EMP_ASG_CRITERIA';
1018: /* Added for GSI Bug 5472781 */
1019: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1020: hr_utility.set_location('Leaving : '||l_proc,10);
1021: return;
1022: END IF;
1023: hr_utility.set_location(l_proc,10);
1024: l_person_id:=get_person_id(P_ASSIGNMENT_ID,p_effective_date);
1019: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1020: hr_utility.set_location('Leaving : '||l_proc,10);
1021: return;
1022: END IF;
1023: hr_utility.set_location(l_proc,10);
1024: l_person_id:=get_person_id(P_ASSIGNMENT_ID,p_effective_date);
1025: open csr_get_contract_cat ;
1026: fetch csr_get_contract_cat into l_contract_category;
1027: close csr_get_contract_cat;
1030: FETCH csr_get_payroll_emp_cat INTO l_employment_category;
1031: CLOSE csr_get_payroll_emp_cat;
1032:
1033: if l_contract_category='NORMAL' then
1034: hr_utility.set_location(l_proc,20);
1035: IF (p_employment_category IS NULL OR p_employment_category <> hr_api.g_varchar2)
1036: then
1037: hr_api.mandatory_arg_error
1038: (p_api_name => l_proc,
1051:
1052: --if p_payroll_id is not null then Replace null with hr_api.g_number in 115.10
1053: --Bug 5386451
1054: if p_payroll_id <> hr_api.g_number then
1055: hr_utility.set_location(l_proc,30);
1056: open csr_oldage_taxoffice_check(l_person_id,p_effective_date);
1057: fetch csr_oldage_taxoffice_check into l_oldage_pension_rights,l_tax_office ;
1058: close csr_oldage_taxoffice_check;
1059:
1058: close csr_oldage_taxoffice_check;
1059:
1060: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
1061: But this is redundant as For Polish Employee these are mandatory if l_nip is null then
1062: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
1063: hr_utility.raise_error;
1064: end if;*/
1065:
1066: if l_oldage_pension_rights is null then
1059:
1060: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
1061: But this is redundant as For Polish Employee these are mandatory if l_nip is null then
1062: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
1063: hr_utility.raise_error;
1064: end if;*/
1065:
1066: if l_oldage_pension_rights is null then
1067: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1063: hr_utility.raise_error;
1064: end if;*/
1065:
1066: if l_oldage_pension_rights is null then
1067: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1068: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
1069: hr_utility.raise_error;
1070: end if;
1071:
1064: end if;*/
1065:
1066: if l_oldage_pension_rights is null then
1067: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1068: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
1069: hr_utility.raise_error;
1070: end if;
1071:
1072: if l_tax_office is null then
1065:
1066: if l_oldage_pension_rights is null then
1067: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1068: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
1069: hr_utility.raise_error;
1070: end if;
1071:
1072: if l_tax_office is null then
1073: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1069: hr_utility.raise_error;
1070: end if;
1071:
1072: if l_tax_office is null then
1073: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1074: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
1075: hr_utility.raise_error;
1076: end if;
1077:
1070: end if;
1071:
1072: if l_tax_office is null then
1073: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1074: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
1075: hr_utility.raise_error;
1076: end if;
1077:
1078:
1071:
1072: if l_tax_office is null then
1073: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1074: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
1075: hr_utility.raise_error;
1076: end if;
1077:
1078:
1079: -- Bug 9534572
1091: --fetch csr_get_contract_cat into l_contract_category;
1092: --close csr_get_contract_cat;
1093:
1094: --if l_contract_category is null then
1095: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1096: --hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY')); --Changed to CONTRACT_CATEGORY for bug 7425845
1097: --hr_utility.raise_error;
1098: --elsif l_contract_category ='NORMAL' then -- and l_assgt_type in ('ACTIVE_ASSIGN' ,'SUSP_ASSIGN') then
1099: --l_join_variable:=l_person_id;
1092: --close csr_get_contract_cat;
1093:
1094: --if l_contract_category is null then
1095: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1096: --hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY')); --Changed to CONTRACT_CATEGORY for bug 7425845
1097: --hr_utility.raise_error;
1098: --elsif l_contract_category ='NORMAL' then -- and l_assgt_type in ('ACTIVE_ASSIGN' ,'SUSP_ASSIGN') then
1099: --l_join_variable:=l_person_id;
1100: --else
1093:
1094: --if l_contract_category is null then
1095: --hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1096: --hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY')); --Changed to CONTRACT_CATEGORY for bug 7425845
1097: --hr_utility.raise_error;
1098: --elsif l_contract_category ='NORMAL' then -- and l_assgt_type in ('ACTIVE_ASSIGN' ,'SUSP_ASSIGN') then
1099: --l_join_variable:=l_person_id;
1100: --else
1101: --l_join_variable:=p_assignment_id;
1108: --fetch csr_check_sii_exists into l_one;
1109: --close csr_check_sii_exists;
1110:
1111: --if l_one <> 1 then
1112: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1113: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
1114: -- hr_utility.raise_error;
1115: --end if;
1116:
1109: --close csr_check_sii_exists;
1110:
1111: --if l_one <> 1 then
1112: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1113: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
1114: -- hr_utility.raise_error;
1115: --end if;
1116:
1117: --l_one:=0;
1110:
1111: --if l_one <> 1 then
1112: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1113: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
1114: -- hr_utility.raise_error;
1115: --end if;
1116:
1117: --l_one:=0;
1118: --open csr_check_paye_exists(l_join_variable,p_effective_date);
1119: --fetch csr_check_paye_exists into l_one;
1120: --close csr_check_paye_exists;
1121:
1122: --if l_one <> 1 then
1123: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1124: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
1125: -- hr_utility.raise_error;
1126: --end if;
1127: */
1120: --close csr_check_paye_exists;
1121:
1122: --if l_one <> 1 then
1123: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1124: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
1125: -- hr_utility.raise_error;
1126: --end if;
1127: */
1128:
1121:
1122: --if l_one <> 1 then
1123: -- hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
1124: -- hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
1125: -- hr_utility.raise_error;
1126: --end if;
1127: */
1128:
1129: end if; --payroll id is null?
1126: --end if;
1127: */
1128:
1129: end if; --payroll id is null?
1130: hr_utility.set_location(l_proc,40);
1131: Exception
1132: when others then
1133: hr_utility.set_location(l_proc,50);
1134: hr_utility.raise_error;
1129: end if; --payroll id is null?
1130: hr_utility.set_location(l_proc,40);
1131: Exception
1132: when others then
1133: hr_utility.set_location(l_proc,50);
1134: hr_utility.raise_error;
1135: end;
1136:
1137: PROCEDURE CREATE_PL_SECONDARY_EMP_ASG_A
1130: hr_utility.set_location(l_proc,40);
1131: Exception
1132: when others then
1133: hr_utility.set_location(l_proc,50);
1134: hr_utility.raise_error;
1135: end;
1136:
1137: PROCEDURE CREATE_PL_SECONDARY_EMP_ASG_A
1138: (P_ASSIGNMENT_ID in number,
1155:
1156: BEGIN
1157: l_proc:='CREATE_PL_SECONDARY_EMP_ASG_A';
1158: /* Added for GSI Bug 5472781 */
1159: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1160: hr_utility.set_location('Leaving : '||l_proc,10);
1161: return;
1162: END IF;
1163:
1156: BEGIN
1157: l_proc:='CREATE_PL_SECONDARY_EMP_ASG_A';
1158: /* Added for GSI Bug 5472781 */
1159: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1160: hr_utility.set_location('Leaving : '||l_proc,10);
1161: return;
1162: END IF;
1163:
1164: if p_scl_segment3 = 'LUMP' then
1222:
1223: BEGIN
1224: l_proc:='UPDATE_PL_EMP_ASG_A';
1225: /* Added for GSI Bug 5472781 */
1226: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1227: hr_utility.set_location('Leaving : '||l_proc,10);
1228: return;
1229: END IF;
1230:
1223: BEGIN
1224: l_proc:='UPDATE_PL_EMP_ASG_A';
1225: /* Added for GSI Bug 5472781 */
1226: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1227: hr_utility.set_location('Leaving : '||l_proc,10);
1228: return;
1229: END IF;
1230:
1231: l_record_exists := '0';