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.PAY_GB_PAYROLL_RULES dependencies on FND_DATE

Line 99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));

95:
96: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_update';
97: BEGIN
98: hr_utility.trace('Entering '||l_proc);
99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
101: hr_utility.trace('p_payroll_id='||p_payroll_id);
102: hr_utility.trace('p_payroll_name='||p_payroll_name);
103: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);

Line 117: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));

113: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_start, l_cur_eff_end;
114: CLOSE get_current_details;
115: --
116: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
117: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));
118: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
119: --
120: hr_utility.trace('Fetching Current PAYE Ref.');
121: OPEN get_paye_ref(l_cur_scl_id);

Line 118: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));

114: CLOSE get_current_details;
115: --
116: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
117: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));
118: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
119: --
120: hr_utility.trace('Fetching Current PAYE Ref.');
121: OPEN get_paye_ref(l_cur_scl_id);
122: FETCH get_paye_ref INTO l_cur_paye_ref;

Line 130: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));

126: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
127: OPEN get_min_max_dates;
128: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
129: CLOSE get_min_max_dates;
130: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
131: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
132: --
133: IF p_datetrack_mode = hr_api.g_correction THEN
134: hr_utility.trace('Datetrack Action is Correction.');

Line 131: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));

127: OPEN get_min_max_dates;
128: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
129: CLOSE get_min_max_dates;
130: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
131: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
132: --
133: IF p_datetrack_mode = hr_api.g_correction THEN
134: hr_utility.trace('Datetrack Action is Correction.');
135: --

Line 165: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||

161: l_span_end := hr_gbbal.span_end(l_cur_eff_start);
162: --
163: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
164: fnd_message.set_token('TAX_YEAR',
165: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
166: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
167: fnd_message.raise_error;
168: END IF;
169: --

Line 166: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));

162: --
163: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
164: fnd_message.set_token('TAX_YEAR',
165: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
166: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
167: fnd_message.raise_error;
168: END IF;
169: --
170: hr_utility.trace('Change as at the start date is ok, Checking end date');

Line 198: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||

194: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
195: --
196: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
197: fnd_message.set_token('TAX_YEAR',
198: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
199: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
200: fnd_message.raise_error;
201: END IF;
202: --

Line 199: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));

195: --
196: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
197: fnd_message.set_token('TAX_YEAR',
198: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
199: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
200: fnd_message.raise_error;
201: END IF;
202: --
203: hr_utility.trace('Change as at the end date is ok too.');

Line 219: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));

215: if csr_term_asg_future_act_exists%notfound then
216: close csr_term_asg_exists;
217: close csr_term_asg_future_act_exists;
218: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
219: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
220: fnd_message.raise_error;
221: end if;
222: close csr_term_asg_future_act_exists;
223: end if;

Line 239: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));

235: if csr_term_asg_future_act_exists%notfound then
236: close csr_term_asg_exists;
237: close csr_term_asg_future_act_exists;
238: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
239: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
240: fnd_message.raise_error;
241: end if;
242: close csr_term_asg_future_act_exists;
243: end if;

Line 273: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||

269: l_span_end := hr_gbbal.span_end(p_effective_date);
270: --
271: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
272: fnd_message.set_token('TAX_YEAR',
273: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
274: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
275: fnd_message.raise_error;
276: END IF;
277: --

Line 274: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));

270: --
271: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
272: fnd_message.set_token('TAX_YEAR',
273: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
274: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
275: fnd_message.raise_error;
276: END IF;
277: --
278: hr_utility.trace('Change as at the new effective date ok, no need to check as at the effective end date');

Line 294: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));

290: if csr_term_asg_future_act_exists%notfound then
291: close csr_term_asg_exists;
292: close csr_term_asg_future_act_exists;
293: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
294: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
295: fnd_message.raise_error;
296: end if;
297: close csr_term_asg_future_act_exists;
298: end if;

Line 327: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||

323: l_span_end := hr_gbbal.span_end(p_effective_date);
324: --
325: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
326: fnd_message.set_token('TAX_YEAR',
327: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
328: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
329: fnd_message.raise_error;
330: END IF;
331: --

Line 328: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));

324: --
325: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
326: fnd_message.set_token('TAX_YEAR',
327: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
328: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
329: fnd_message.raise_error;
330: END IF;
331: --
332: hr_utility.trace('Change as at the new effective date ok, Checking as at the effective end date');

Line 361: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||

357: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
358: --
359: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
360: fnd_message.set_token('TAX_YEAR',
361: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
362: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
363: fnd_message.raise_error;
364: END IF;
365: --

Line 362: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));

358: --
359: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
360: fnd_message.set_token('TAX_YEAR',
361: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
362: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
363: fnd_message.raise_error;
364: END IF;
365: --
366: hr_utility.trace('Change as at the end date is ok too.');

Line 382: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));

378: if csr_term_asg_future_act_exists%notfound then
379: close csr_term_asg_exists;
380: close csr_term_asg_future_act_exists;
381: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
382: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
383: fnd_message.raise_error;
384: end if;
385: close csr_term_asg_future_act_exists;
386: end if;

Line 402: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));

398: if csr_term_asg_future_act_exists%notfound then
399: close csr_term_asg_exists;
400: close csr_term_asg_future_act_exists;
401: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
402: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
403: fnd_message.raise_error;
404: end if;
405: close csr_term_asg_future_act_exists;
406: end if;

Line 504: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));

500:
501: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_delete';
502: BEGIN
503: hr_utility.trace('Entering '||l_proc);
504: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
505: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
506: hr_utility.trace('p_payroll_id='||p_payroll_id);
507: --
508: hr_utility.trace('Fetching current payroll details');

Line 514: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));

510: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_end;
511: CLOSE get_current_details;
512: --
513: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
514: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
515: --
516: hr_utility.trace('Fetching Current PAYE Ref.');
517: OPEN get_paye_ref(l_cur_scl_id);
518: FETCH get_paye_ref INTO l_cur_paye_ref;

Line 526: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));

522: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
523: OPEN get_min_max_dates;
524: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
525: CLOSE get_min_max_dates;
526: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
527: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
528: --
529: IF p_datetrack_mode = hr_api.g_delete_next_change THEN
530: hr_utility.trace('Datetrack Mode is Delete next change.');

Line 527: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));

523: OPEN get_min_max_dates;
524: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
525: CLOSE get_min_max_dates;
526: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
527: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
528: --
529: IF p_datetrack_mode = hr_api.g_delete_next_change THEN
530: hr_utility.trace('Datetrack Mode is Delete next change.');
531: hr_utility.trace('Fetching end date of next instance.');

Line 536: hr_utility.trace('l_next_eff_date='||fnd_date.date_to_displaydate(l_next_eff_end));

532: OPEN get_next_details;
533: FETCH get_next_details INTO l_next_eff_end;
534: CLOSE get_next_details;
535: --
536: hr_utility.trace('l_next_eff_date='||fnd_date.date_to_displaydate(l_next_eff_end));
537: hr_utility.trace('Fetching PAYE Ref on next to next instance.');
538: OPEN get_next_to_next_details;
539: FETCH get_next_to_next_details INTO l_next_to_next_scl_id;
540: CLOSE get_next_to_next_details;

Line 563: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||

559: l_span_end := hr_gbbal.span_end(l_next_eff_end);
560: --
561: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
562: fnd_message.set_token('TAX_YEAR',
563: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
564: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
565: fnd_message.raise_error;
566: END IF;
567: --

Line 564: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));

560: --
561: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
562: fnd_message.set_token('TAX_YEAR',
563: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
564: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
565: fnd_message.raise_error;
566: END IF;
567: --
568:

Line 582: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));

578: if csr_term_asg_future_act_exists%notfound then
579: close csr_term_asg_exists;
580: close csr_term_asg_future_act_exists;
581: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
582: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
583: fnd_message.raise_error;
584: end if;
585: close csr_term_asg_future_act_exists;
586: end if;