eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PL_ASSIGNMENT dependencies on HR_GENERAL

Line 112: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),

108:
109:
110: hr_api.mandatory_arg_error --Contract Category is mandatory
111: (p_api_name => l_proc,
112: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),
113: p_argument_value => p_scl_segment3
114: );
115:
116: hr_api.mandatory_arg_error --Contract Type is Mandatory

Line 118: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE'),

114: );
115:
116: hr_api.mandatory_arg_error --Contract Type is Mandatory
117: (p_api_name => l_proc,
118: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE'),
119: p_argument_value => p_scl_segment4
120: );
121:
122:

Line 125: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),

121:
122:
123: hr_api.mandatory_arg_error --Contract Number is Mandatory
124: (p_api_name => l_proc,
125: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),
126: p_argument_value => p_scl_segment5
127: );
128:
129: hr_api.mandatory_arg_error --Contract Start Date is mandatory

Line 131: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),

127: );
128:
129: hr_api.mandatory_arg_error --Contract Start Date is mandatory
130: (p_api_name => l_proc,
131: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),
132: p_argument_value => p_scl_segment11
133: );
134:
135: hr_api.mandatory_arg_error --Date Contract Signed is mandatory

Line 137: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'),

133: );
134:
135: hr_api.mandatory_arg_error --Date Contract Signed is mandatory
136: (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);

Line 148: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),

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
146: hr_api.mandatory_arg_error
147: (p_api_name => l_proc,
148: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
149: p_argument_value => P_EMPLOYMENT_CATEGORY
150: );
151: end if;
152:

Line 157: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),

153:
154: if p_scl_segment3='NORMAL' and p_scl_segment4<>'N01' then
155: hr_api.mandatory_arg_error
156: (p_api_name => l_proc,
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');

Line 170: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),

166: -----Notice Period Date(p_scl_segment15),Notice Period End Date(p_scl_segment16),Notice Period(p_notice_period)
167: if p_scl_segment16||p_scl_segment15||p_notice_period is not null then
168: hr_api.mandatory_arg_error
169: (p_api_name => l_proc,
170: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),
171: p_argument_value => p_scl_segment16
172: );
173: hr_api.mandatory_arg_error
174: (p_api_name => l_proc,

Line 175: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),

171: p_argument_value => p_scl_segment16
172: );
173: hr_api.mandatory_arg_error
174: (p_api_name => l_proc,
175: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),
176: p_argument_value => p_scl_segment15
177: );
178: hr_api.mandatory_arg_error
179: (p_api_name => l_proc,

Line 180: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD'),

176: p_argument_value => p_scl_segment15
177: );
178: hr_api.mandatory_arg_error
179: (p_api_name => l_proc,
180: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','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

Line 199: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));

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:
203: hr_utility.raise_error;

Line 201: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));

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
205: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');

Line 207: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));

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')));
211: hr_utility.raise_error;

Line 210: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));

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:
214: -----other validations like value set comparison will be taken

Line 220: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));

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

Line 226: 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.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

Line 227: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 232: 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.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.*/

Line 233: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 239: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));

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:

Line 240: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));

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

Line 251: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));

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:

Line 252: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 258: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));

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

Line 259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 263: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_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
267:

Line 264: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_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:
268: l_oldage_pension_rights:=null;

Line 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

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

Line 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

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;

Line 299: hr_utility.set_message_token (l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));

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:

Line 310: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));

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;

Line 322: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));

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

Line 415: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),

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'),
416: p_argument_value => p_segment3
417: );
418:
419: hr_api.mandatory_arg_error --Contract Type is Mandatory

Line 421: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE'),

417: );
418:
419: hr_api.mandatory_arg_error --Contract Type is Mandatory
420: (p_api_name => l_proc,
421: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE'),
422: p_argument_value => p_segment4
423: );
424:
425:

Line 428: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),

424:
425:
426: hr_api.mandatory_arg_error --Contract Number is Mandatory
427: (p_api_name => l_proc,
428: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),
429: p_argument_value => p_segment5
430: );
431:
432: hr_api.mandatory_arg_error --Contract Start Date is mandatory

Line 434: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),

430: );
431:
432: hr_api.mandatory_arg_error --Contract Start Date is mandatory
433: (p_api_name => l_proc,
434: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),
435: p_argument_value => p_segment11
436: );
437:
438: hr_api.mandatory_arg_error --Date Contract Signed is mandatory

Line 440: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'),

436: );
437:
438: hr_api.mandatory_arg_error --Date Contract Signed is mandatory
439: (p_api_name => l_proc,
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);

Line 459: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),

455: fetch csr_get_payroll_emp_cat into l_payroll_id,l_employment_category;
456: close csr_get_payroll_emp_cat;
457: hr_api.mandatory_arg_error
458: (p_api_name => l_proc,
459: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
460: p_argument_value => l_employment_category
461: );
462: end if;
463:

Line 467: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),

463:
464: if p_segment3='NORMAL' and p_segment4<>'N01' then
465: hr_api.mandatory_arg_error
466: (p_api_name => l_proc,
467: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),
468: p_argument_value => P_SEGMENT12
469: );
470: elsif p_segment12<>hr_api.g_varchar2 then --replaced in 115.11
471: --Bug 5386451

Line 481: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),

477: -----Notice Period Date(p_scl_segment15),Notice Period End Date(p_scl_segment16),Notice Period(p_notice_period)
478: if p_segment16||p_segment15||p_notice_period is not null then
479: hr_api.mandatory_arg_error
480: (p_api_name => l_proc,
481: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),
482: p_argument_value => p_segment16
483: );
484: hr_api.mandatory_arg_error
485: (p_api_name => l_proc,

Line 486: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),

482: p_argument_value => p_segment16
483: );
484: hr_api.mandatory_arg_error
485: (p_api_name => l_proc,
486: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),
487: p_argument_value => p_segment15
488: );
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc,

Line 491: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD'),

487: p_argument_value => p_segment15
488: );
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc,
491: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','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

Line 509: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));

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:
513: hr_utility.raise_error;

Line 511: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));

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
515: hr_utility.set_message(800,'HR_375835_ENTER_OTHER_VALUE');

Line 517: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE')));

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')));
521: hr_utility.raise_error;

Line 520: l_token_value=>lower(hr_general.decode_lookup('PL_FORM_LABELS','CHANGE_OF_CONTRACT_REASON')));

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

Line 550: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));

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:

Line 572: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 573: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_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
577: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');

Line 578: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_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:
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then

Line 579: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 584: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_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:
588: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/

Line 585: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 591: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));

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

Line 592: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));

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

Line 602: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));

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:

Line 603: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 609: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));

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

Line 610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));

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

Line 614: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_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
618:

Line 615: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_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:
619: --if status has been changed ..then create sii/paye record from existing tax record if they already exist

Line 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

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

Line 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

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:

Line 826: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));

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;

Line 837: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));

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?

Line 890: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),

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
892: );
893: end if;
894:

Line 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

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

Line 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

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:

Line 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

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

Line 951: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_SII_INFO_FLEX'));

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;

Line 962: hr_utility.set_message_token(l_token_name=>'TOKEN',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PL_TAX_INFO_FLEX'));

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?