[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
99: */
100: g_package_name :='PER_PL_ASSIGNMENT.';
101: l_proc := g_package_name||'CREATE_PL_SECONDARY_EMP_ASG';
102: /* Added for GSI Bug 5472781 */
103: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
104: hr_utility.set_location('Leaving : '||l_proc,10);
105: return;
106: END IF;
107: hr_utility.set_location(l_proc,10);
100: g_package_name :='PER_PL_ASSIGNMENT.';
101: l_proc := g_package_name||'CREATE_PL_SECONDARY_EMP_ASG';
102: /* Added for GSI Bug 5472781 */
103: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
104: hr_utility.set_location('Leaving : '||l_proc,10);
105: return;
106: END IF;
107: hr_utility.set_location(l_proc,10);
108:
103: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
104: hr_utility.set_location('Leaving : '||l_proc,10);
105: return;
106: END IF;
107: hr_utility.set_location(l_proc,10);
108:
109:
110: hr_api.mandatory_arg_error --Contract Category is mandatory
111: (p_api_name => l_proc,
137: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'),
138: p_argument_value => p_scl_segment14
139: );
140:
141: hr_utility.set_location(l_proc,20);
142: ------Conditionally mandatory---------
143: --------for a normal contract,the assignment category is mandatory...
144: -------core store this in employment_category in per_all_assignments_f table..displays it as assignment_category on UI
145: if p_scl_segment3='NORMAL' then
157: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),
158: p_argument_value => P_SCL_SEGMENT12
159: );
160: elsif p_scl_segment12 is not null then
161: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
162: hr_utility.raise_error;
163: end if;
164:
165: -----if any of the following 3 has been entered then ..other two become mandatory
158: p_argument_value => P_SCL_SEGMENT12
159: );
160: elsif p_scl_segment12 is not null then
161: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
162: hr_utility.raise_error;
163: end if;
164:
165: -----if any of the following 3 has been entered then ..other two become mandatory
166: -----Notice Period Date(p_scl_segment15),Notice Period End Date(p_scl_segment16),Notice Period(p_notice_period)
181: p_argument_value => p_notice_period
182: );
183: if ( (p_NOTICE_PERIOD_UOM like '_1' and p_notice_period >1) or
184: (p_NOTICE_PERIOD_UOM like '_' and p_notice_period =1)) then
185: hr_utility.set_message(800,'HR_375856_NOTICE_UNIT_MISMATCH');
186: hr_utility.raise_error;
187: end if;
188: end if;
189: -----if p_notice_period is entered and notice_period_uom is null??
182: );
183: if ( (p_NOTICE_PERIOD_UOM like '_1' and p_notice_period >1) or
184: (p_NOTICE_PERIOD_UOM like '_' and p_notice_period =1)) then
185: hr_utility.set_message(800,'HR_375856_NOTICE_UNIT_MISMATCH');
186: hr_utility.raise_error;
187: end if;
188: end if;
189: -----if p_notice_period is entered and notice_period_uom is null??
190: -----taken care by core per_asg_bus3.chk_notice_period_uom
193: --Bug 4504375
194: -- change of contract reason and contract type change date are mandatory
195: -- if any one of them is not null
196: if p_scl_segment6 is not null and p_scl_segment13 is null then
197: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
198: hr_utility.set_message_token(l_token_name=>'DETAIL1',
199: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
200: hr_utility.set_message_token(l_token_name=>'DETAIL2',
201: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
194: -- change of contract reason and contract type change date are mandatory
195: -- if any one of them is not null
196: if p_scl_segment6 is not null and p_scl_segment13 is null then
197: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
198: hr_utility.set_message_token(l_token_name=>'DETAIL1',
199: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
200: hr_utility.set_message_token(l_token_name=>'DETAIL2',
201: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
202:
196: if p_scl_segment6 is not null and p_scl_segment13 is null then
197: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
198: hr_utility.set_message_token(l_token_name=>'DETAIL1',
199: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
200: hr_utility.set_message_token(l_token_name=>'DETAIL2',
201: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
202:
203: hr_utility.raise_error;
204: elsif p_scl_segment6 is null and p_scl_segment13 is not null then
199: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
200: hr_utility.set_message_token(l_token_name=>'DETAIL2',
201: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
202:
203: hr_utility.raise_error;
204: elsif p_scl_segment6 is null and p_scl_segment13 is not null then
205: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
206: hr_utility.set_message_token(l_token_name=>'DETAIL1',
207: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
201: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
202:
203: hr_utility.raise_error;
204: elsif p_scl_segment6 is null and p_scl_segment13 is not null then
205: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
206: hr_utility.set_message_token(l_token_name=>'DETAIL1',
207: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
208:
209: hr_utility.set_message_token(l_token_name=>'DETAIL2',
202:
203: hr_utility.raise_error;
204: elsif p_scl_segment6 is null and p_scl_segment13 is not null then
205: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
206: hr_utility.set_message_token(l_token_name=>'DETAIL1',
207: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
208:
209: hr_utility.set_message_token(l_token_name=>'DETAIL2',
210: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
205: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
206: hr_utility.set_message_token(l_token_name=>'DETAIL1',
207: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
208:
209: hr_utility.set_message_token(l_token_name=>'DETAIL2',
210: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
211: hr_utility.raise_error;
212: end if;
213:
207: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
208:
209: hr_utility.set_message_token(l_token_name=>'DETAIL2',
210: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
211: hr_utility.raise_error;
212: end if;
213:
214: -----other validations like value set comparison will be taken
215: -----care by core when they validate the flexfields.
213:
214: -----other validations like value set comparison will be taken
215: -----care by core when they validate the flexfields.
216: -----what we need to check are the dates being entered.
217: hr_utility.set_location(l_proc,30);
218: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
219: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
220: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
215: -----care by core when they validate the flexfields.
216: -----what we need to check are the dates being entered.
217: hr_utility.set_location(l_proc,30);
218: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
219: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
220: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
222: hr_utility.raise_error;
223:
216: -----what we need to check are the dates being entered.
217: hr_utility.set_location(l_proc,30);
218: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
219: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
220: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
222: hr_utility.raise_error;
223:
224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
217: hr_utility.set_location(l_proc,30);
218: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
219: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
220: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
222: hr_utility.raise_error;
223:
224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
225: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
218: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
219: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
220: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
222: hr_utility.raise_error;
223:
224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
225: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
226: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
222: hr_utility.raise_error;
223:
224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
225: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
226: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
227: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
228: hr_utility.raise_error;
229:
222: hr_utility.raise_error;
223:
224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
225: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
226: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
227: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
228: hr_utility.raise_error;
229:
230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
223:
224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
225: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
226: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
227: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
228: hr_utility.raise_error;
229:
230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
231: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
225: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
226: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
227: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
228: hr_utility.raise_error;
229:
230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
231: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
232: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
227: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
228: hr_utility.raise_error;
229:
230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
231: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
232: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
233: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
234: hr_utility.raise_error;
235:
228: hr_utility.raise_error;
229:
230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
231: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
232: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
233: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
234: hr_utility.raise_error;
235:
236: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
229:
230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
231: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
232: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
233: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
234: hr_utility.raise_error;
235:
236: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
237: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
231: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
232: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
233: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
234: hr_utility.raise_error;
235:
236: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
237: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
238: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
234: hr_utility.raise_error;
235:
236: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
237: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
238: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
239: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
240: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
241: hr_utility.raise_error;
242:
235:
236: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
237: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
238: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
239: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
240: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
241: hr_utility.raise_error;
242:
243:
236: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
237: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
238: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
239: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
240: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
241: hr_utility.raise_error;
242:
243:
244: /*
237: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
238: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
239: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
240: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
241: hr_utility.raise_error;
242:
243:
244: /*
245: This check has been removed because of bug 4504312 DATE CONTRACT SIGNED1 ACCEPTS DATES EVEN AFTER THE CONTRACT START DATE
246: Hence Date Contract Signed must be before or same as Contract Start Date. ie)(p_scl_segment14)<(p_scl_segment11)is the condition
247: 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
248: Date contract Signed.
249: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
250: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
251: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
252: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
253: hr_utility.raise_error;
254: */
247: 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
248: Date contract Signed.
249: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
250: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
251: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
252: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
253: hr_utility.raise_error;
254: */
255:
248: Date contract Signed.
249: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
250: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
251: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
252: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
253: hr_utility.raise_error;
254: */
255:
256: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
249: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
250: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
251: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
252: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
253: hr_utility.raise_error;
254: */
255:
256: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
257: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
253: hr_utility.raise_error;
254: */
255:
256: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
257: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
258: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
260: hr_utility.raise_error;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
254: */
255:
256: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
257: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
258: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
260: hr_utility.raise_error;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
262: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
255:
256: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
257: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
258: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
260: hr_utility.raise_error;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
262: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
263: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
256: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
257: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
258: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
260: hr_utility.raise_error;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
262: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
263: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
264: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
258: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
260: hr_utility.raise_error;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
262: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
263: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
264: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
265: hr_utility.raise_error;
266: elsif p_payroll_id is not null then
259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
260: hr_utility.raise_error;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
262: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
263: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
264: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
265: hr_utility.raise_error;
266: elsif p_payroll_id is not null then
267:
260: hr_utility.raise_error;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
262: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
263: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
264: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
265: hr_utility.raise_error;
266: elsif p_payroll_id is not null then
267:
268: l_oldage_pension_rights:=null;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
262: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
263: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
264: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
265: hr_utility.raise_error;
266: elsif p_payroll_id is not null then
267:
268: l_oldage_pension_rights:=null;
269:
273:
274: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
275: But this is redundant as For Polish Employee these are mandatory
276: if l_nip is null then
277: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
278: hr_utility.raise_error;
279: end if; */
280:
281: if l_oldage_pension_rights is null then
274: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
275: But this is redundant as For Polish Employee these are mandatory
276: if l_nip is null then
277: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
278: hr_utility.raise_error;
279: end if; */
280:
281: if l_oldage_pension_rights is null then
282: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
278: hr_utility.raise_error;
279: end if; */
280:
281: if l_oldage_pension_rights is null then
282: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
283: 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
284: hr_utility.raise_error;
285: end if;
286:
279: end if; */
280:
281: if l_oldage_pension_rights is null then
282: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
283: 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
284: hr_utility.raise_error;
285: end if;
286:
287: if l_tax_office is null then
280:
281: if l_oldage_pension_rights is null then
282: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
283: 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
284: hr_utility.raise_error;
285: end if;
286:
287: if l_tax_office is null then
288: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
284: hr_utility.raise_error;
285: end if;
286:
287: if l_tax_office is null then
288: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
289: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
290: hr_utility.raise_error;
291: end if;
292:
285: end if;
286:
287: if l_tax_office is null then
288: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
289: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
290: hr_utility.raise_error;
291: end if;
292:
293: l_one:=0;
286:
287: if l_tax_office is null then
288: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
289: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
290: hr_utility.raise_error;
291: end if;
292:
293: l_one:=0;
294:
294:
295: if p_scl_segment3 in ('CIVIL','F_LUMP','LUMP') then
296: /*we cannot have a civil contract with payroll id while creating...
297: 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...*/
298: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
299: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
300: hr_utility.raise_error;
301: end if;
302:
295: if p_scl_segment3 in ('CIVIL','F_LUMP','LUMP') then
296: /*we cannot have a civil contract with payroll id while creating...
297: 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...*/
298: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
299: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
300: hr_utility.raise_error;
301: end if;
302:
303:
296: /*we cannot have a civil contract with payroll id while creating...
297: 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...*/
298: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
299: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
300: hr_utility.raise_error;
301: end if;
302:
303:
304: open csr_check_sii_exists(p_person_id,p_effective_date) ;
305: fetch csr_check_sii_exists into l_one;
306: close csr_check_sii_exists;
307:
308: if l_one <> 1 then
309: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
310: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
311: hr_utility.raise_error;
312: end if;
313:
306: close csr_check_sii_exists;
307:
308: if l_one <> 1 then
309: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
310: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
311: hr_utility.raise_error;
312: end if;
313:
314: l_one:=0;
307:
308: if l_one <> 1 then
309: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
310: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
311: hr_utility.raise_error;
312: end if;
313:
314: l_one:=0;
315:
317: fetch csr_check_paye_exists into l_one;
318: close csr_check_paye_exists;
319:
320: if l_one<> 1 then
321: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
322: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
323: hr_utility.raise_error;
324: end if;
325:
318: close csr_check_paye_exists;
319:
320: if l_one<> 1 then
321: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
322: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
323: hr_utility.raise_error;
324: end if;
325:
326: end if; --date checks over
319:
320: if l_one<> 1 then
321: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
322: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
323: hr_utility.raise_error;
324: end if;
325:
326: end if; --date checks over
327:
324: end if;
325:
326: end if; --date checks over
327:
328: hr_utility.set_location(l_proc,40);
329: Exception
330: when others then
331: hr_utility.set_location(l_proc,50);
332: hr_utility.raise_error;
327:
328: hr_utility.set_location(l_proc,40);
329: Exception
330: when others then
331: hr_utility.set_location(l_proc,50);
332: hr_utility.raise_error;
333: end create_pl_secondary_emp_asg;
334:
335:
328: hr_utility.set_location(l_proc,40);
329: Exception
330: when others then
331: hr_utility.set_location(l_proc,50);
332: hr_utility.raise_error;
333: end create_pl_secondary_emp_asg;
334:
335:
336: ---------start of update_pl_emp_asg-----------
403: --7)payroll check ..get it from the table and then do the validation
404: g_package_name :='PER_PL_ASSIGNMENT.';
405: l_proc:=g_package_name||'UPDATE_PL_EMP_ASG';
406: /* Added for GSI Bug 5472781 */
407: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
408: hr_utility.set_location('Leaving : '||l_proc,10);
409: return;
410: END IF;
411: hr_utility.set_location(l_proc,10);
404: g_package_name :='PER_PL_ASSIGNMENT.';
405: l_proc:=g_package_name||'UPDATE_PL_EMP_ASG';
406: /* Added for GSI Bug 5472781 */
407: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
408: hr_utility.set_location('Leaving : '||l_proc,10);
409: return;
410: END IF;
411: hr_utility.set_location(l_proc,10);
412: l_person_id:= get_person_id(p_assignment_id,p_effective_date);
407: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
408: hr_utility.set_location('Leaving : '||l_proc,10);
409: return;
410: END IF;
411: hr_utility.set_location(l_proc,10);
412: l_person_id:= get_person_id(p_assignment_id,p_effective_date);
413: hr_api.mandatory_arg_error --Contract Category is mandatory
414: (p_api_name => l_proc,
415: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),
440: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'),
441: p_argument_value => p_segment14
442: );
443:
444: hr_utility.set_location(l_proc,20);
445:
446: ------Conditionally mandatory---------
447: /*
448: 1)update_emp_asg_criteria will be called first..this is where the payroll id,employment_category will be set
468: p_argument_value => P_SEGMENT12
469: );
470: elsif p_segment12<>hr_api.g_varchar2 then --replaced in 115.11
471: --Bug 5386451
472: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
473: hr_utility.raise_error;
474: end if;
475:
476: -----if any of the following 3 has been entered then ..other two become mandatory
469: );
470: elsif p_segment12<>hr_api.g_varchar2 then --replaced in 115.11
471: --Bug 5386451
472: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
473: hr_utility.raise_error;
474: end if;
475:
476: -----if any of the following 3 has been entered then ..other two become mandatory
477: -----Notice Period Date(p_scl_segment15),Notice Period End Date(p_scl_segment16),Notice Period(p_notice_period)
492: p_argument_value => p_notice_period
493: );
494: if ( (p_NOTICE_PERIOD_UOM like '_1' and p_notice_period >1) or
495: (p_NOTICE_PERIOD_UOM like '_' and p_notice_period =1)) then
496: hr_utility.set_message(800,'HR_375856_NOTICE_UNIT_MISMATCH');
497: hr_utility.raise_error;
498: end if;
499: end if;
500: -----if p_notice_period is entered and notice_period_uom is null??
493: );
494: if ( (p_NOTICE_PERIOD_UOM like '_1' and p_notice_period >1) or
495: (p_NOTICE_PERIOD_UOM like '_' and p_notice_period =1)) then
496: hr_utility.set_message(800,'HR_375856_NOTICE_UNIT_MISMATCH');
497: hr_utility.raise_error;
498: end if;
499: end if;
500: -----if p_notice_period is entered and notice_period_uom is null??
501: -----taken care by core per_asg_bus3.chk_notice_period_uom
503: --Bug 4504375
504: -- change of contract reason and contract type change date are mandatory
505: -- if any one of them is not null
506: if p_segment6 is not null and p_segment13 is null then
507: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
508: hr_utility.set_message_token(l_token_name=>'DETAIL1',
509: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
510: hr_utility.set_message_token(l_token_name=>'DETAIL2',
511: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
504: -- change of contract reason and contract type change date are mandatory
505: -- if any one of them is not null
506: if p_segment6 is not null and p_segment13 is null then
507: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
508: hr_utility.set_message_token(l_token_name=>'DETAIL1',
509: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
510: hr_utility.set_message_token(l_token_name=>'DETAIL2',
511: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
512:
506: if p_segment6 is not null and p_segment13 is null then
507: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
508: hr_utility.set_message_token(l_token_name=>'DETAIL1',
509: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
510: hr_utility.set_message_token(l_token_name=>'DETAIL2',
511: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
512:
513: hr_utility.raise_error;
514: elsif p_segment6 is null and p_segment13 is not null then
509: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
510: hr_utility.set_message_token(l_token_name=>'DETAIL2',
511: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
512:
513: hr_utility.raise_error;
514: elsif p_segment6 is null and p_segment13 is not null then
515: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
516: hr_utility.set_message_token(l_token_name=>'DETAIL1',
517: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
511: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
512:
513: hr_utility.raise_error;
514: elsif p_segment6 is null and p_segment13 is not null then
515: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
516: hr_utility.set_message_token(l_token_name=>'DETAIL1',
517: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
518:
519: hr_utility.set_message_token(l_token_name=>'DETAIL2',
512:
513: hr_utility.raise_error;
514: elsif p_segment6 is null and p_segment13 is not null then
515: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
516: hr_utility.set_message_token(l_token_name=>'DETAIL1',
517: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
518:
519: hr_utility.set_message_token(l_token_name=>'DETAIL2',
520: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
515: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');
516: hr_utility.set_message_token(l_token_name=>'DETAIL1',
517: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
518:
519: hr_utility.set_message_token(l_token_name=>'DETAIL2',
520: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
521: hr_utility.raise_error;
522: end if;
523:
517: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));
518:
519: hr_utility.set_message_token(l_token_name=>'DETAIL2',
520: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));
521: hr_utility.raise_error;
522: end if;
523:
524:
525:
530: --no need to check for null ...
531:
532: --contract category cannot be changed once created
533: if l_contract_category <> p_segment3 then
534: hr_utility.set_message(800,'HR_375868_DONT_CHANGE_CATEGORY');
535: hr_utility.raise_error;
536: end if;
537:
538: --contract type change allowed only after reason and change date are provided
531:
532: --contract category cannot be changed once created
533: if l_contract_category <> p_segment3 then
534: hr_utility.set_message(800,'HR_375868_DONT_CHANGE_CATEGORY');
535: hr_utility.raise_error;
536: end if;
537:
538: --contract type change allowed only after reason and change date are provided
539: --p_contract_type cannot be null...no check if user is updating it from null to some contract type
538: --contract type change allowed only after reason and change date are provided
539: --p_contract_type cannot be null...no check if user is updating it from null to some contract type
540: if l_contract_type <> p_segment4 then
541: if(l_contract_change_reason is null or (p_effective_date-1)<>nvl(l_contract_type_change_date,p_effective_date)) then
542: hr_utility.set_message(800,'HR_375867_DISALLOW_TYPE_CHANGE');
543: hr_utility.raise_error;
544: end if;
545: end if;
546:
539: --p_contract_type cannot be null...no check if user is updating it from null to some contract type
540: if l_contract_type <> p_segment4 then
541: if(l_contract_change_reason is null or (p_effective_date-1)<>nvl(l_contract_type_change_date,p_effective_date)) then
542: hr_utility.set_message(800,'HR_375867_DISALLOW_TYPE_CHANGE');
543: hr_utility.raise_error;
544: end if;
545: end if;
546:
547: --contract length to be within 30 characters
545: end if;
546:
547: --contract length to be within 30 characters
548: if length(p_segment5)>30 then
549: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
550: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
551: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
552: hr_utility.raise_error;
553: end if;
546:
547: --contract length to be within 30 characters
548: if length(p_segment5)>30 then
549: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
550: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
551: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
552: hr_utility.raise_error;
553: end if;
554:
547: --contract length to be within 30 characters
548: if length(p_segment5)>30 then
549: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
550: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
551: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
552: hr_utility.raise_error;
553: end if;
554:
555: -----other validations like value set comparison will be taken
548: if length(p_segment5)>30 then
549: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
550: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
551: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
552: hr_utility.raise_error;
553: end if;
554:
555: -----other validations like value set comparison will be taken
556: ----care by core when they validate the flexfields.
555: -----other validations like value set comparison will be taken
556: ----care by core when they validate the flexfields.
557: -----what we need to check are the dates being entered.
558:
559: hr_utility.set_location(l_proc,30);
560:
561: -- Bug 7041296
562: -- pick minimum start date of assignment
563: -- and compare contract_start_date with minimum(assignment eff_start_date)
564: open csr_effective_start_date;
565: fetch csr_effective_start_date into l_asg_min_start_date;
566: close csr_effective_start_date;
567:
568: --hr_utility.trace('Bug 7041296 : p_segment11 :'||p_segment11||'l_asg_min_start_date:'||l_asg_min_start_date);
569:
570: if fnd_date.canonical_to_date(p_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
571: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
572: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
567:
568: --hr_utility.trace('Bug 7041296 : p_segment11 :'||p_segment11||'l_asg_min_start_date:'||l_asg_min_start_date);
569:
570: if fnd_date.canonical_to_date(p_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
571: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
572: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
573: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
574: hr_utility.raise_error;
575:
568: --hr_utility.trace('Bug 7041296 : p_segment11 :'||p_segment11||'l_asg_min_start_date:'||l_asg_min_start_date);
569:
570: if fnd_date.canonical_to_date(p_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
571: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
572: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
573: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
574: hr_utility.raise_error;
575:
576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then
569:
570: if fnd_date.canonical_to_date(p_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
571: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
572: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
573: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
574: hr_utility.raise_error;
575:
576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then
577: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
570: if fnd_date.canonical_to_date(p_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
571: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
572: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
573: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
574: hr_utility.raise_error;
575:
576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then
577: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
578: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
573: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
574: hr_utility.raise_error;
575:
576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then
577: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
578: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
579: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
580: hr_utility.raise_error;
581:
574: hr_utility.raise_error;
575:
576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then
577: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
578: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
579: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
580: hr_utility.raise_error;
581:
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then
575:
576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then
577: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
578: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
579: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
580: hr_utility.raise_error;
581:
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then
583: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then
577: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
578: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
579: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
580: hr_utility.raise_error;
581:
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then
583: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
584: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
579: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
580: hr_utility.raise_error;
581:
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then
583: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
584: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
585: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
586: hr_utility.raise_error;
587:
580: hr_utility.raise_error;
581:
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then
583: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
584: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
585: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
586: hr_utility.raise_error;
587:
588: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
581:
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then
583: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
584: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
585: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
586: hr_utility.raise_error;
587:
588: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
589: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment14) then
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then
583: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
584: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
585: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
586: hr_utility.raise_error;
587:
588: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
589: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment14) then
590: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
586: hr_utility.raise_error;
587:
588: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
589: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment14) then
590: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
591: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
592: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
593: hr_utility.raise_error;
594:
587:
588: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
589: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment14) then
590: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
591: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
592: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
593: hr_utility.raise_error;
594:
595: /*
588: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
589: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment14) then
590: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
591: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
592: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
593: hr_utility.raise_error;
594:
595: /*
596: This check has been removed because of bug 4504312 DATE CONTRACT SIGNE D ACCEPTS DATES EVEN AFTER THE CONTRACT START DATE
589: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment14) then
590: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
591: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
592: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
593: hr_utility.raise_error;
594:
595: /*
596: This check has been removed because of bug 4504312 DATE CONTRACT SIGNE D ACCEPTS DATES EVEN AFTER THE CONTRACT START DATE
597: Hence Date Contract Signed must be before or same as Contract Start Date. ie)(p_scl_segment14)<(p_scl_segment11)is the condition
597: Hence Date Contract Signed must be before or same as Contract Start Date. ie)(p_scl_segment14)<(p_scl_segment11)is the condition
598: 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
599: Date contract Signed.
600: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
601: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
602: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
603: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
604: hr_utility.raise_error;
605: */
598: 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
599: Date contract Signed.
600: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
601: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
602: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
603: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
604: hr_utility.raise_error;
605: */
606:
599: Date contract Signed.
600: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
601: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
602: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
603: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
604: hr_utility.raise_error;
605: */
606:
607: elsif fnd_date.canonical_to_date(p_segment15) < fnd_date.canonical_to_date(p_segment11) then
600: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
601: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
602: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
603: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
604: hr_utility.raise_error;
605: */
606:
607: elsif fnd_date.canonical_to_date(p_segment15) < fnd_date.canonical_to_date(p_segment11) then
608: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
604: hr_utility.raise_error;
605: */
606:
607: elsif fnd_date.canonical_to_date(p_segment15) < fnd_date.canonical_to_date(p_segment11) then
608: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
609: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
611: hr_utility.raise_error;
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
605: */
606:
607: elsif fnd_date.canonical_to_date(p_segment15) < fnd_date.canonical_to_date(p_segment11) then
608: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
609: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
611: hr_utility.raise_error;
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
613: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
606:
607: elsif fnd_date.canonical_to_date(p_segment15) < fnd_date.canonical_to_date(p_segment11) then
608: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
609: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
611: hr_utility.raise_error;
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
613: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
614: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
607: elsif fnd_date.canonical_to_date(p_segment15) < fnd_date.canonical_to_date(p_segment11) then
608: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
609: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
611: hr_utility.raise_error;
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
613: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
614: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
615: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
609: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
611: hr_utility.raise_error;
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
613: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
614: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
615: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
616: hr_utility.raise_error;
617: else
610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
611: hr_utility.raise_error;
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
613: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
614: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
615: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
616: hr_utility.raise_error;
617: else
618:
611: hr_utility.raise_error;
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
613: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
614: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
615: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
616: hr_utility.raise_error;
617: else
618:
619: --if status has been changed ..then create sii/paye record from existing tax record if they already exist
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
613: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
614: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
615: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
616: hr_utility.raise_error;
617: else
618:
619: --if status has been changed ..then create sii/paye record from existing tax record if they already exist
620: open csr_assgt_type(p_assignment_id,p_effective_date-1);
786:
787: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
788: But this is redundant as For Polish Employee these are mandatory
789: if l_nip is null then
790: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
791: hr_utility.raise_error;
792: end if;
793: */
794:
787: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
788: But this is redundant as For Polish Employee these are mandatory
789: if l_nip is null then
790: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
791: hr_utility.raise_error;
792: end if;
793: */
794:
795: if l_oldage_pension_rights is null then
792: end if;
793: */
794:
795: if l_oldage_pension_rights is null then
796: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
797: 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
798: hr_utility.raise_error;
799: end if;
800:
793: */
794:
795: if l_oldage_pension_rights is null then
796: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
797: 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
798: hr_utility.raise_error;
799: end if;
800:
801: if l_tax_office is null then
794:
795: if l_oldage_pension_rights is null then
796: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
797: 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
798: hr_utility.raise_error;
799: end if;
800:
801: if l_tax_office is null then
802: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
798: hr_utility.raise_error;
799: end if;
800:
801: if l_tax_office is null then
802: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
803: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
804: hr_utility.raise_error;
805: end if;
806:
799: end if;
800:
801: if l_tax_office is null then
802: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
803: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
804: hr_utility.raise_error;
805: end if;
806:
807:
800:
801: if l_tax_office is null then
802: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
803: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
804: hr_utility.raise_error;
805: end if;
806:
807:
808: open csr_assgt_type(p_assignment_id,p_effective_date) ;
821: fetch csr_check_sii_exists into l_one;
822: close csr_check_sii_exists;
823:
824: if l_one <> 1 then
825: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
826: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
827: hr_utility.raise_error;
828: end if;
829:
822: close csr_check_sii_exists;
823:
824: if l_one <> 1 then
825: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
826: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
827: hr_utility.raise_error;
828: end if;
829:
830: l_one:=0;
823:
824: if l_one <> 1 then
825: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
826: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
827: hr_utility.raise_error;
828: end if;
829:
830: l_one:=0;
831: open csr_check_paye_exists(l_join_variable,p_effective_date);
832: fetch csr_check_paye_exists into l_one;
833: close csr_check_paye_exists;
834:
835: if l_one <> 1 then
836: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
837: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
838: hr_utility.raise_error;
839: end if;
840:
833: close csr_check_paye_exists;
834:
835: if l_one <> 1 then
836: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
837: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
838: hr_utility.raise_error;
839: end if;
840:
841: end if;--is payroll id null?
834:
835: if l_one <> 1 then
836: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
837: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
838: hr_utility.raise_error;
839: end if;
840:
841: end if;--is payroll id null?
842: end if;--end of date checks
842: end if;--end of date checks
843:
844: exception
845: when others then
846: hr_utility.set_location(l_proc,99);
847: hr_utility.raise_error;
848: end ;
849: ----end of update_pl_emp_asg----
850:
843:
844: exception
845: when others then
846: hr_utility.set_location(l_proc,99);
847: hr_utility.raise_error;
848: end ;
849: ----end of update_pl_emp_asg----
850:
851: ----Start of Update_pl_emp_asg_criteria----
873: Begin
874: g_package_name :='PER_PL_ASSIGNMENT.';
875: l_proc:=g_package_name||'UPDATE_PL_EMP_ASG_CRITERIA';
876: /* Added for GSI Bug 5472781 */
877: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
878: hr_utility.set_location('Leaving : '||l_proc,10);
879: return;
880: END IF;
881: hr_utility.set_location(l_proc,10);
874: g_package_name :='PER_PL_ASSIGNMENT.';
875: l_proc:=g_package_name||'UPDATE_PL_EMP_ASG_CRITERIA';
876: /* Added for GSI Bug 5472781 */
877: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
878: hr_utility.set_location('Leaving : '||l_proc,10);
879: return;
880: END IF;
881: hr_utility.set_location(l_proc,10);
882: l_person_id:=get_person_id(P_ASSIGNMENT_ID,p_effective_date);
877: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
878: hr_utility.set_location('Leaving : '||l_proc,10);
879: return;
880: END IF;
881: hr_utility.set_location(l_proc,10);
882: l_person_id:=get_person_id(P_ASSIGNMENT_ID,p_effective_date);
883: open csr_get_contract_cat ;
884: fetch csr_get_contract_cat into l_contract_category;
885: close csr_get_contract_cat;
883: open csr_get_contract_cat ;
884: fetch csr_get_contract_cat into l_contract_category;
885: close csr_get_contract_cat;
886: if l_contract_category='NORMAL' then
887: hr_utility.set_location(l_proc,20);
888: hr_api.mandatory_arg_error
889: (p_api_name => l_proc,
890: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
891: p_argument_value => p_employment_category
895:
896: --if p_payroll_id is not null then Replace null with hr_api.g_number in 115.10
897: --Bug 5386451
898: if p_payroll_id <> hr_api.g_number then
899: hr_utility.set_location(l_proc,30);
900: open csr_oldage_taxoffice_check(l_person_id,p_effective_date);
901: fetch csr_oldage_taxoffice_check into l_oldage_pension_rights,l_tax_office ;
902: close csr_oldage_taxoffice_check;
903:
902: close csr_oldage_taxoffice_check;
903:
904: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
905: But this is redundant as For Polish Employee these are mandatory if l_nip is null then
906: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
907: hr_utility.raise_error;
908: end if;*/
909:
910: if l_oldage_pension_rights is null then
903:
904: /* NIP is neccessary to attach a payroll only for Polish employees(Both Citizenship and nationality)
905: But this is redundant as For Polish Employee these are mandatory if l_nip is null then
906: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
907: hr_utility.raise_error;
908: end if;*/
909:
910: if l_oldage_pension_rights is null then
911: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
907: hr_utility.raise_error;
908: end if;*/
909:
910: if l_oldage_pension_rights is null then
911: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
912: 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
913: hr_utility.raise_error;
914: end if;
915:
908: end if;*/
909:
910: if l_oldage_pension_rights is null then
911: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
912: 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
913: hr_utility.raise_error;
914: end if;
915:
916: if l_tax_office is null then
909:
910: if l_oldage_pension_rights is null then
911: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
912: 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
913: hr_utility.raise_error;
914: end if;
915:
916: if l_tax_office is null then
917: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
913: hr_utility.raise_error;
914: end if;
915:
916: if l_tax_office is null then
917: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
918: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
919: hr_utility.raise_error;
920: end if;
921:
914: end if;
915:
916: if l_tax_office is null then
917: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
918: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
919: hr_utility.raise_error;
920: end if;
921:
922:
915:
916: if l_tax_office is null then
917: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
918: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
919: hr_utility.raise_error;
920: end if;
921:
922:
923: open csr_assgt_type(p_assignment_id,p_effective_date);
929: fetch csr_get_contract_cat into l_contract_category;
930: close csr_get_contract_cat;
931:
932: if l_contract_category is null then
933: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
934: 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
935: hr_utility.raise_error;
936: elsif l_contract_category ='NORMAL' then /* and l_assgt_type in ('ACTIVE_ASSIGN' ,'SUSP_ASSIGN') then */
937: l_join_variable:=l_person_id;
930: close csr_get_contract_cat;
931:
932: if l_contract_category is null then
933: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
934: 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
935: hr_utility.raise_error;
936: elsif l_contract_category ='NORMAL' then /* and l_assgt_type in ('ACTIVE_ASSIGN' ,'SUSP_ASSIGN') then */
937: l_join_variable:=l_person_id;
938: else
931:
932: if l_contract_category is null then
933: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
934: 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
935: hr_utility.raise_error;
936: elsif l_contract_category ='NORMAL' then /* and l_assgt_type in ('ACTIVE_ASSIGN' ,'SUSP_ASSIGN') then */
937: l_join_variable:=l_person_id;
938: else
939: l_join_variable:=p_assignment_id;
946: fetch csr_check_sii_exists into l_one;
947: close csr_check_sii_exists;
948:
949: if l_one <> 1 then
950: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
951: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
952: hr_utility.raise_error;
953: end if;
954:
947: close csr_check_sii_exists;
948:
949: if l_one <> 1 then
950: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
951: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
952: hr_utility.raise_error;
953: end if;
954:
955: l_one:=0;
948:
949: if l_one <> 1 then
950: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
951: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));
952: hr_utility.raise_error;
953: end if;
954:
955: l_one:=0;
956: open csr_check_paye_exists(l_join_variable,p_effective_date);
957: fetch csr_check_paye_exists into l_one;
958: close csr_check_paye_exists;
959:
960: if l_one <> 1 then
961: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
962: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
963: hr_utility.raise_error;
964: end if;
965:
958: close csr_check_paye_exists;
959:
960: if l_one <> 1 then
961: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
962: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
963: hr_utility.raise_error;
964: end if;
965:
966: end if; --payroll id is null?
959:
960: if l_one <> 1 then
961: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
962: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));
963: hr_utility.raise_error;
964: end if;
965:
966: end if; --payroll id is null?
967: hr_utility.set_location(l_proc,40);
963: hr_utility.raise_error;
964: end if;
965:
966: end if; --payroll id is null?
967: hr_utility.set_location(l_proc,40);
968: Exception
969: when others then
970: hr_utility.set_location(l_proc,50);
971: hr_utility.raise_error;
966: end if; --payroll id is null?
967: hr_utility.set_location(l_proc,40);
968: Exception
969: when others then
970: hr_utility.set_location(l_proc,50);
971: hr_utility.raise_error;
972: end;
973:
974: PROCEDURE CREATE_PL_SECONDARY_EMP_ASG_A
967: hr_utility.set_location(l_proc,40);
968: Exception
969: when others then
970: hr_utility.set_location(l_proc,50);
971: hr_utility.raise_error;
972: end;
973:
974: PROCEDURE CREATE_PL_SECONDARY_EMP_ASG_A
975: (P_ASSIGNMENT_ID in number,
992:
993: BEGIN
994: l_proc:='CREATE_PL_SECONDARY_EMP_ASG_A';
995: /* Added for GSI Bug 5472781 */
996: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
997: hr_utility.set_location('Leaving : '||l_proc,10);
998: return;
999: END IF;
1000:
993: BEGIN
994: l_proc:='CREATE_PL_SECONDARY_EMP_ASG_A';
995: /* Added for GSI Bug 5472781 */
996: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
997: hr_utility.set_location('Leaving : '||l_proc,10);
998: return;
999: END IF;
1000:
1001: if p_scl_segment3 = 'LUMP' then
1059:
1060: BEGIN
1061: l_proc:='UPDATE_PL_EMP_ASG_A';
1062: /* Added for GSI Bug 5472781 */
1063: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1064: hr_utility.set_location('Leaving : '||l_proc,10);
1065: return;
1066: END IF;
1067:
1060: BEGIN
1061: l_proc:='UPDATE_PL_EMP_ASG_A';
1062: /* Added for GSI Bug 5472781 */
1063: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
1064: hr_utility.set_location('Leaving : '||l_proc,10);
1065: return;
1066: END IF;
1067:
1068: l_record_exists := '0';