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 105: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));

101:
102: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_update';
103: BEGIN
104: hr_utility.trace('Entering '||l_proc);
105: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
106: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
107: hr_utility.trace('p_payroll_id='||p_payroll_id);
108: hr_utility.trace('p_payroll_name='||p_payroll_name);
109: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);

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

119: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_start, l_cur_eff_end;
120: CLOSE get_current_details;
121: --
122: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
123: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));
124: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
125: --
126: hr_utility.trace('Fetching Current PAYE Ref.');
127: OPEN get_paye_ref(l_cur_scl_id);

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

120: CLOSE get_current_details;
121: --
122: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
123: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));
124: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
125: --
126: hr_utility.trace('Fetching Current PAYE Ref.');
127: OPEN get_paye_ref(l_cur_scl_id);
128: FETCH get_paye_ref INTO l_cur_paye_ref;

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

132: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
133: OPEN get_min_max_dates;
134: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
135: CLOSE get_min_max_dates;
136: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
137: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
138: --
139: IF p_datetrack_mode = hr_api.g_correction THEN
140: hr_utility.trace('Datetrack Action is Correction.');

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

133: OPEN get_min_max_dates;
134: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
135: CLOSE get_min_max_dates;
136: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
137: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
138: --
139: IF p_datetrack_mode = hr_api.g_correction THEN
140: hr_utility.trace('Datetrack Action is Correction.');
141: --

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

167: l_span_end := hr_gbbal.span_end(l_cur_eff_start);
168: --
169: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
170: fnd_message.set_token('TAX_YEAR',
171: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
172: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
173: fnd_message.raise_error;
174: END IF;
175: --

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

168: --
169: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
170: fnd_message.set_token('TAX_YEAR',
171: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
172: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
173: fnd_message.raise_error;
174: END IF;
175: --
176: hr_utility.trace('Change as at the start date is ok, Checking end date');

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

200: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
201: --
202: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
203: fnd_message.set_token('TAX_YEAR',
204: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
205: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
206: fnd_message.raise_error;
207: END IF;
208: --

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

201: --
202: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
203: fnd_message.set_token('TAX_YEAR',
204: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
205: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
206: fnd_message.raise_error;
207: END IF;
208: --
209: hr_utility.trace('Change as at the end date is ok too.');

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

224: if csr_term_asg_future_act_exists%notfound then
225: close csr_term_asg_exists;
226: close csr_term_asg_future_act_exists;
227: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
228: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
229: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
230: fnd_message.raise_error;
231: end if;
232: close csr_term_asg_future_act_exists;

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

248: if csr_term_asg_future_act_exists%notfound then
249: close csr_term_asg_exists;
250: close csr_term_asg_future_act_exists;
251: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
252: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
253: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
254: fnd_message.raise_error;
255: end if;
256: close csr_term_asg_future_act_exists;

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

283: l_span_end := hr_gbbal.span_end(p_effective_date);
284: --
285: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
286: fnd_message.set_token('TAX_YEAR',
287: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
288: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
289: fnd_message.raise_error;
290: END IF;
291: --

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

284: --
285: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
286: fnd_message.set_token('TAX_YEAR',
287: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
288: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
289: fnd_message.raise_error;
290: END IF;
291: --
292: hr_utility.trace('Change as at the new effective date ok, no need to check as at the effective end date');

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

307: if csr_term_asg_future_act_exists%notfound then
308: close csr_term_asg_exists;
309: close csr_term_asg_future_act_exists;
310: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
311: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
312: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
313: fnd_message.raise_error;
314: end if;
315: close csr_term_asg_future_act_exists;

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

341: l_span_end := hr_gbbal.span_end(p_effective_date);
342: --
343: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
344: fnd_message.set_token('TAX_YEAR',
345: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
346: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
347: fnd_message.raise_error;
348: END IF;
349: --

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

342: --
343: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
344: fnd_message.set_token('TAX_YEAR',
345: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
346: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
347: fnd_message.raise_error;
348: END IF;
349: --
350: hr_utility.trace('Change as at the new effective date ok, Checking as at the effective end date');

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

375: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
376: --
377: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
378: fnd_message.set_token('TAX_YEAR',
379: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
380: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
381: fnd_message.raise_error;
382: END IF;
383: --

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

376: --
377: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
378: fnd_message.set_token('TAX_YEAR',
379: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
380: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
381: fnd_message.raise_error;
382: END IF;
383: --
384: hr_utility.trace('Change as at the end date is ok too.');

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

399: if csr_term_asg_future_act_exists%notfound then
400: close csr_term_asg_exists;
401: close csr_term_asg_future_act_exists;
402: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
403: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
404: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
405: fnd_message.raise_error;
406: end if;
407: close csr_term_asg_future_act_exists;

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

423: if csr_term_asg_future_act_exists%notfound then
424: close csr_term_asg_exists;
425: close csr_term_asg_future_act_exists;
426: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
427: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
428: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
429: fnd_message.raise_error;
430: end if;
431: close csr_term_asg_future_act_exists;

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

532:
533: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_delete';
534: BEGIN
535: hr_utility.trace('Entering '||l_proc);
536: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
537: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
538: hr_utility.trace('p_payroll_id='||p_payroll_id);
539: --
540: hr_utility.trace('Fetching current payroll details');

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

542: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_end;
543: CLOSE get_current_details;
544: --
545: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
546: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
547: --
548: hr_utility.trace('Fetching Current PAYE Ref.');
549: OPEN get_paye_ref(l_cur_scl_id);
550: FETCH get_paye_ref INTO l_cur_paye_ref;

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

554: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
555: OPEN get_min_max_dates;
556: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
557: CLOSE get_min_max_dates;
558: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
559: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
560: --
561: IF p_datetrack_mode = hr_api.g_delete_next_change THEN
562: hr_utility.trace('Datetrack Mode is Delete next change.');

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

555: OPEN get_min_max_dates;
556: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
557: CLOSE get_min_max_dates;
558: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
559: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
560: --
561: IF p_datetrack_mode = hr_api.g_delete_next_change THEN
562: hr_utility.trace('Datetrack Mode is Delete next change.');
563: hr_utility.trace('Fetching end date of next instance.');

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

564: OPEN get_next_details;
565: FETCH get_next_details INTO l_next_eff_end;
566: CLOSE get_next_details;
567: --
568: hr_utility.trace('l_next_eff_date='||fnd_date.date_to_displaydate(l_next_eff_end));
569: hr_utility.trace('Fetching PAYE Ref on next to next instance.');
570: OPEN get_next_to_next_details;
571: FETCH get_next_to_next_details INTO l_next_to_next_scl_id;
572: CLOSE get_next_to_next_details;

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

591: l_span_end := hr_gbbal.span_end(l_next_eff_end);
592: --
593: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
594: fnd_message.set_token('TAX_YEAR',
595: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
596: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
597: fnd_message.raise_error;
598: END IF;
599: --

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

592: --
593: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
594: fnd_message.set_token('TAX_YEAR',
595: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
596: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
597: fnd_message.raise_error;
598: END IF;
599: --
600:

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

613: if csr_term_asg_future_act_exists%notfound then
614: close csr_term_asg_exists;
615: close csr_term_asg_future_act_exists;
616: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
617: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
618: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
619: fnd_message.raise_error;
620: end if;
621: close csr_term_asg_future_act_exists;