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_RTI_UPD dependencies on HR_UTILITY

Line 63: hr_utility.trace ('if part:'

59: ,1
60: ,4)
61: ,'DD-MM-YYYY');
62:
63: hr_utility.trace ('if part:'
64: || l_date_soy);
65: ELSE
66: l_date_soy := to_date ('06-04-'
67: || to_char (to_number (substr (to_char (p_effective_date

Line 73: hr_utility.trace ('else part:'

69: ,1
70: ,4)) - 1)
71: ,'DD-MM-YYYY');
72:
73: hr_utility.trace ('else part:'
74: || l_date_soy);
75: END IF;
76:
77: hr_utility.trace ('date after soy check:'

Line 77: hr_utility.trace ('date after soy check:'

73: hr_utility.trace ('else part:'
74: || l_date_soy);
75: END IF;
76:
77: hr_utility.trace ('date after soy check:'
78: || l_date_soy);
79: RETURN fnd_date.date_to_displaydate (l_date_soy);
80: END get_soy_date;
81:

Line 172: hr_utility.trace('Entering get_ni_reporting_flag function..');

168: AND pap.effective_end_date;
169:
170:
171: BEGIN
172: hr_utility.trace('Entering get_ni_reporting_flag function..');
173: hr_utility.trace('Parameters are:');
174: hr_utility.trace('p_assignment_id:'||p_assignment_id);
175: hr_utility.trace('p_person_id:'||p_person_id);
176: hr_utility.trace('p_effective_date:'||p_effective_date);

Line 173: hr_utility.trace('Parameters are:');

169:
170:
171: BEGIN
172: hr_utility.trace('Entering get_ni_reporting_flag function..');
173: hr_utility.trace('Parameters are:');
174: hr_utility.trace('p_assignment_id:'||p_assignment_id);
175: hr_utility.trace('p_person_id:'||p_person_id);
176: hr_utility.trace('p_effective_date:'||p_effective_date);
177: hr_utility.trace('p_paye_reference:'||p_paye_reference);

Line 174: hr_utility.trace('p_assignment_id:'||p_assignment_id);

170:
171: BEGIN
172: hr_utility.trace('Entering get_ni_reporting_flag function..');
173: hr_utility.trace('Parameters are:');
174: hr_utility.trace('p_assignment_id:'||p_assignment_id);
175: hr_utility.trace('p_person_id:'||p_person_id);
176: hr_utility.trace('p_effective_date:'||p_effective_date);
177: hr_utility.trace('p_paye_reference:'||p_paye_reference);
178:

Line 175: hr_utility.trace('p_person_id:'||p_person_id);

171: BEGIN
172: hr_utility.trace('Entering get_ni_reporting_flag function..');
173: hr_utility.trace('Parameters are:');
174: hr_utility.trace('p_assignment_id:'||p_assignment_id);
175: hr_utility.trace('p_person_id:'||p_person_id);
176: hr_utility.trace('p_effective_date:'||p_effective_date);
177: hr_utility.trace('p_paye_reference:'||p_paye_reference);
178:
179: l_ni_reporting_flag:=null;

Line 176: hr_utility.trace('p_effective_date:'||p_effective_date);

172: hr_utility.trace('Entering get_ni_reporting_flag function..');
173: hr_utility.trace('Parameters are:');
174: hr_utility.trace('p_assignment_id:'||p_assignment_id);
175: hr_utility.trace('p_person_id:'||p_person_id);
176: hr_utility.trace('p_effective_date:'||p_effective_date);
177: hr_utility.trace('p_paye_reference:'||p_paye_reference);
178:
179: l_ni_reporting_flag:=null;
180: open scr_ni_paye_aggr_flag;

Line 177: hr_utility.trace('p_paye_reference:'||p_paye_reference);

173: hr_utility.trace('Parameters are:');
174: hr_utility.trace('p_assignment_id:'||p_assignment_id);
175: hr_utility.trace('p_person_id:'||p_person_id);
176: hr_utility.trace('p_effective_date:'||p_effective_date);
177: hr_utility.trace('p_paye_reference:'||p_paye_reference);
178:
179: l_ni_reporting_flag:=null;
180: open scr_ni_paye_aggr_flag;
181: fetch scr_ni_paye_aggr_flag INTO v_per_agg_flag

Line 201: hr_utility.trace('fetched ni and paye aggregation flag');

197: AND paf.effective_end_date
198: AND p_effective_date BETWEEN pap.effective_start_date
199: AND pap.effective_end_date;*/
200:
201: hr_utility.trace('fetched ni and paye aggregation flag');
202: hr_utility.trace('v_per_agg_flag:'||v_per_agg_flag);
203: hr_utility.trace('v_per_ni_flag:'||v_per_ni_flag);
204: hr_utility.trace('v_primary_flag:'||v_primary_flag);
205: IF nvl (v_per_agg_flag

Line 202: hr_utility.trace('v_per_agg_flag:'||v_per_agg_flag);

198: AND p_effective_date BETWEEN pap.effective_start_date
199: AND pap.effective_end_date;*/
200:
201: hr_utility.trace('fetched ni and paye aggregation flag');
202: hr_utility.trace('v_per_agg_flag:'||v_per_agg_flag);
203: hr_utility.trace('v_per_ni_flag:'||v_per_ni_flag);
204: hr_utility.trace('v_primary_flag:'||v_primary_flag);
205: IF nvl (v_per_agg_flag
206: ,'N') = 'N'

Line 203: hr_utility.trace('v_per_ni_flag:'||v_per_ni_flag);

199: AND pap.effective_end_date;*/
200:
201: hr_utility.trace('fetched ni and paye aggregation flag');
202: hr_utility.trace('v_per_agg_flag:'||v_per_agg_flag);
203: hr_utility.trace('v_per_ni_flag:'||v_per_ni_flag);
204: hr_utility.trace('v_primary_flag:'||v_primary_flag);
205: IF nvl (v_per_agg_flag
206: ,'N') = 'N'
207: AND nvl (v_per_ni_flag

Line 204: hr_utility.trace('v_primary_flag:'||v_primary_flag);

200:
201: hr_utility.trace('fetched ni and paye aggregation flag');
202: hr_utility.trace('v_per_agg_flag:'||v_per_agg_flag);
203: hr_utility.trace('v_per_ni_flag:'||v_per_ni_flag);
204: hr_utility.trace('v_primary_flag:'||v_primary_flag);
205: IF nvl (v_per_agg_flag
206: ,'N') = 'N'
207: AND nvl (v_per_ni_flag
208: ,'N') = 'Y' then

Line 211: hr_utility.trace('Assignments are NI aggregated, hence in if part');

207: AND nvl (v_per_ni_flag
208: ,'N') = 'Y' then
209: --AND nvl (v_primary_flag
210: --,'N') = 'Y' THEN
211: hr_utility.trace('Assignments are NI aggregated, hence in if part');
212: open csr_primary_exists;
213: fetch csr_primary_exists into l_assignment_id;
214: hr_utility.trace('Checking if Primary Assignment exists or not');
215: if csr_primary_exists%notfound then

Line 214: hr_utility.trace('Checking if Primary Assignment exists or not');

210: --,'N') = 'Y' THEN
211: hr_utility.trace('Assignments are NI aggregated, hence in if part');
212: open csr_primary_exists;
213: fetch csr_primary_exists into l_assignment_id;
214: hr_utility.trace('Checking if Primary Assignment exists or not');
215: if csr_primary_exists%notfound then
216: l_ni_reporting_flag:= null;
217: hr_utility.trace('Primary Assignment is not found');
218: else-- primary flag exists

Line 217: hr_utility.trace('Primary Assignment is not found');

213: fetch csr_primary_exists into l_assignment_id;
214: hr_utility.trace('Checking if Primary Assignment exists or not');
215: if csr_primary_exists%notfound then
216: l_ni_reporting_flag:= null;
217: hr_utility.trace('Primary Assignment is not found');
218: else-- primary flag exists
219: open csr_primary_in_curr_paye;
220: fetch csr_primary_in_curr_paye into l_assignment_id;-- check for primary flag in current paye reference
221: hr_utility.trace('Checking if Primary Assignment exists in same PAYE reference');

Line 221: hr_utility.trace('Checking if Primary Assignment exists in same PAYE reference');

217: hr_utility.trace('Primary Assignment is not found');
218: else-- primary flag exists
219: open csr_primary_in_curr_paye;
220: fetch csr_primary_in_curr_paye into l_assignment_id;-- check for primary flag in current paye reference
221: hr_utility.trace('Checking if Primary Assignment exists in same PAYE reference');
222: if csr_primary_in_curr_paye%notfound then
223: hr_utility.trace('Primary not present in current PAYE reference');
224: open csr_oldest_asg;
225: fetch csr_oldest_asg into l_assignment_id;

Line 223: hr_utility.trace('Primary not present in current PAYE reference');

219: open csr_primary_in_curr_paye;
220: fetch csr_primary_in_curr_paye into l_assignment_id;-- check for primary flag in current paye reference
221: hr_utility.trace('Checking if Primary Assignment exists in same PAYE reference');
222: if csr_primary_in_curr_paye%notfound then
223: hr_utility.trace('Primary not present in current PAYE reference');
224: open csr_oldest_asg;
225: fetch csr_oldest_asg into l_assignment_id;
226: close csr_oldest_asg;
227: end if;

Line 231: hr_utility.trace('The primary assignment_id fetched by the cursor is:'||l_assignment_id);

227: end if;
228: close csr_primary_in_curr_paye;
229: end if;
230: close csr_primary_exists;
231: hr_utility.trace('The primary assignment_id fetched by the cursor is:'||l_assignment_id);
232: if l_assignment_id is not null then
233: if l_assignment_id=p_assignment_id then
234: l_ni_reporting_flag:='Y';
235: hr_utility.trace('Current One is Primary Assignment hence flag is set');

Line 235: hr_utility.trace('Current One is Primary Assignment hence flag is set');

231: hr_utility.trace('The primary assignment_id fetched by the cursor is:'||l_assignment_id);
232: if l_assignment_id is not null then
233: if l_assignment_id=p_assignment_id then
234: l_ni_reporting_flag:='Y';
235: hr_utility.trace('Current One is Primary Assignment hence flag is set');
236: else
237: hr_utility.trace('Current One is not Primary Assignment hence flag is not set');
238: l_ni_reporting_flag:='N';
239: end if;

Line 237: hr_utility.trace('Current One is not Primary Assignment hence flag is not set');

233: if l_assignment_id=p_assignment_id then
234: l_ni_reporting_flag:='Y';
235: hr_utility.trace('Current One is Primary Assignment hence flag is set');
236: else
237: hr_utility.trace('Current One is not Primary Assignment hence flag is not set');
238: l_ni_reporting_flag:='N';
239: end if;
240:
241: end if;

Line 243: hr_utility.trace('Assignments are NOT NI aggregated, hence in else part, setting the flag to No');

239: end if;
240:
241: end if;
242: else
243: hr_utility.trace('Assignments are NOT NI aggregated, hence in else part, setting the flag to No');
244: l_ni_reporting_flag:='N';
245: END IF;
246: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||p_assignment_id||'- is '||l_ni_reporting_flag);
247: RETURN l_ni_reporting_flag;

Line 246: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||p_assignment_id||'- is '||l_ni_reporting_flag);

242: else
243: hr_utility.trace('Assignments are NOT NI aggregated, hence in else part, setting the flag to No');
244: l_ni_reporting_flag:='N';
245: END IF;
246: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||p_assignment_id||'- is '||l_ni_reporting_flag);
247: RETURN l_ni_reporting_flag;
248: END get_ni_reporting_flag;
249:
250: FUNCTION check_primary_assignment(p_person_id in number, p_effective_date in date)

Line 282: hr_utility.trace('start of rti_payroll_id');

278: v_rti_payroll_id varchar2(30);
279: v_rti_assignment_id varchar2(30);
280: v_check_data varchar2(10);
281: BEGIN
282: hr_utility.trace('start of rti_payroll_id');
283: IF nvl (p_aggregation_flag
284: ,'N') = 'Y' THEN
285: SELECT assignment_number
286: INTO v_rti_payroll_id

Line 390: hr_utility.trace ('inside hook call new rti aggregation package');

386: p_effect_date date;
387: BEGIN
388:
389:
390: hr_utility.trace ('inside hook call new rti aggregation package');
391:
392: hr_utility.trace ('person_id:'
393: || p_person_id);
394:

Line 392: hr_utility.trace ('person_id:'

388:
389:
390: hr_utility.trace ('inside hook call new rti aggregation package');
391:
392: hr_utility.trace ('person_id:'
393: || p_person_id);
394:
395: hr_utility.trace ('p_effective_date:'
396: || p_effective_date);

Line 395: hr_utility.trace ('p_effective_date:'

391:
392: hr_utility.trace ('person_id:'
393: || p_person_id);
394:
395: hr_utility.trace ('p_effective_date:'
396: || p_effective_date);
397:
398: IF ((check_profile_exists ('GB RTI UPTAKE'))
399: AND (check_for_active_emp (p_person_id

Line 401: hr_utility.trace ('profile is active so inside extra entry');

397:
398: IF ((check_profile_exists ('GB RTI UPTAKE'))
399: AND (check_for_active_emp (p_person_id
400: ,p_effective_date) = 1)) THEN
401: hr_utility.trace ('profile is active so inside extra entry');
402:
403: OPEN csr_ni_paye_flag;
404:
405: FETCH csr_ni_paye_flag

Line 417: hr_utility.trace ('v_person_flags.per_agg_flag:'

413: ,v_person_flags.per_agg_flag
414: ,v_person_flags.per_ni_flag
415: ,p_effective_date);
416:
417: hr_utility.trace ('v_person_flags.per_agg_flag:'
418: || c_person_info.per_agg_flag);
419:
420: hr_utility.trace ('p_effective_date:'
421: || p_effective_date);

Line 420: hr_utility.trace ('p_effective_date:'

416:
417: hr_utility.trace ('v_person_flags.per_agg_flag:'
418: || c_person_info.per_agg_flag);
419:
420: hr_utility.trace ('p_effective_date:'
421: || p_effective_date);
422:
423: l_ni_reporting_flag := get_ni_reporting_flag (c_person_info.assignment_id
424: ,p_effective_date,p_person_id, null);

Line 430: hr_utility.trace ('p_assignment_extra_info_id:'

426: get_extra_info_exists (c_person_info.assignment_id
427: ,p_assignment_extra_info_id
428: ,p_object_version_number);
429:
430: hr_utility.trace ('p_assignment_extra_info_id:'
431: || p_assignment_extra_info_id);
432:
433: hr_utility.trace ('assignment_id:'
434: || c_person_info.assignment_id);

Line 433: hr_utility.trace ('assignment_id:'

429:
430: hr_utility.trace ('p_assignment_extra_info_id:'
431: || p_assignment_extra_info_id);
432:
433: hr_utility.trace ('assignment_id:'
434: || c_person_info.assignment_id);
435:
436: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
437:

Line 438: hr_utility.trace ('p_effect_date:'

434: || c_person_info.assignment_id);
435:
436: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
437:
438: hr_utility.trace ('p_effect_date:'
439: || p_effect_date);
440:
441: IF (p_effect_date <= c_person_info.assignment_start_date) THEN
442: p_effect_date := c_person_info.assignment_start_date;

Line 445: hr_utility.trace (' after if loop p_effect_date:'

441: IF (p_effect_date <= c_person_info.assignment_start_date) THEN
442: p_effect_date := c_person_info.assignment_start_date;
443: END IF;
444:
445: hr_utility.trace (' after if loop p_effect_date:'
446: || p_effect_date);
447:
448: IF p_assignment_extra_info_id = - 1 THEN
449: pay_gb_aei_api.pay_gb_ins_rti_agg_strt

Line 475: hr_utility.trace (sqlerrm);

471: END LOOP;
472: END IF;
473: EXCEPTION
474: WHEN others THEN
475: hr_utility.trace (sqlerrm);
476:
477: hr_utility.trace ('leaving update_rti_agg_person');
478:
479:

Line 477: hr_utility.trace ('leaving update_rti_agg_person');

473: EXCEPTION
474: WHEN others THEN
475: hr_utility.trace (sqlerrm);
476:
477: hr_utility.trace ('leaving update_rti_agg_person');
478:
479:
480: END update_rti_agg_person;
481:

Line 627: hr_utility.trace('Entering py_gb_rti_payroll_updt');

623: l_total_count:=0;
624:
625: retcode:=ret_error_status;
626: l_prev_emp_number:= null;
627: hr_utility.trace('Entering py_gb_rti_payroll_updt');
628: hr_utility.trace('Parameters are:');
629: hr_utility.trace('tax_ref_no:'||tax_ref_no);
630: hr_utility.trace('p_effective_date:'||p_effective_date);
631: hr_utility.trace('l_business_group_id:'||l_business_group_id);

Line 628: hr_utility.trace('Parameters are:');

624:
625: retcode:=ret_error_status;
626: l_prev_emp_number:= null;
627: hr_utility.trace('Entering py_gb_rti_payroll_updt');
628: hr_utility.trace('Parameters are:');
629: hr_utility.trace('tax_ref_no:'||tax_ref_no);
630: hr_utility.trace('p_effective_date:'||p_effective_date);
631: hr_utility.trace('l_business_group_id:'||l_business_group_id);
632: p_effect_date := get_soy_date (fnd_date.canonical_to_date(p_effective_date));

Line 629: hr_utility.trace('tax_ref_no:'||tax_ref_no);

625: retcode:=ret_error_status;
626: l_prev_emp_number:= null;
627: hr_utility.trace('Entering py_gb_rti_payroll_updt');
628: hr_utility.trace('Parameters are:');
629: hr_utility.trace('tax_ref_no:'||tax_ref_no);
630: hr_utility.trace('p_effective_date:'||p_effective_date);
631: hr_utility.trace('l_business_group_id:'||l_business_group_id);
632: p_effect_date := get_soy_date (fnd_date.canonical_to_date(p_effective_date));
633: hr_utility.trace('Effective Date after get_soy_date call:'||p_effect_date);

Line 630: hr_utility.trace('p_effective_date:'||p_effective_date);

626: l_prev_emp_number:= null;
627: hr_utility.trace('Entering py_gb_rti_payroll_updt');
628: hr_utility.trace('Parameters are:');
629: hr_utility.trace('tax_ref_no:'||tax_ref_no);
630: hr_utility.trace('p_effective_date:'||p_effective_date);
631: hr_utility.trace('l_business_group_id:'||l_business_group_id);
632: p_effect_date := get_soy_date (fnd_date.canonical_to_date(p_effective_date));
633: hr_utility.trace('Effective Date after get_soy_date call:'||p_effect_date);
634:

Line 631: hr_utility.trace('l_business_group_id:'||l_business_group_id);

627: hr_utility.trace('Entering py_gb_rti_payroll_updt');
628: hr_utility.trace('Parameters are:');
629: hr_utility.trace('tax_ref_no:'||tax_ref_no);
630: hr_utility.trace('p_effective_date:'||p_effective_date);
631: hr_utility.trace('l_business_group_id:'||l_business_group_id);
632: p_effect_date := get_soy_date (fnd_date.canonical_to_date(p_effective_date));
633: hr_utility.trace('Effective Date after get_soy_date call:'||p_effect_date);
634:
635: fnd_file.put_line (fnd_file.output

Line 633: hr_utility.trace('Effective Date after get_soy_date call:'||p_effect_date);

629: hr_utility.trace('tax_ref_no:'||tax_ref_no);
630: hr_utility.trace('p_effective_date:'||p_effective_date);
631: hr_utility.trace('l_business_group_id:'||l_business_group_id);
632: p_effect_date := get_soy_date (fnd_date.canonical_to_date(p_effective_date));
633: hr_utility.trace('Effective Date after get_soy_date call:'||p_effect_date);
634:
635: fnd_file.put_line (fnd_file.output
636: ,rpad ('-----------------------------------------------------------------'
637: ,80));

Line 679: hr_utility.trace('before start of the loop');

675: fnd_file.put_line (fnd_file.output
676: ,rpad ('-----------------------------------------------------------------'
677: ,80));
678:
679: hr_utility.trace('before start of the loop');
680: FOR v_person_details IN c_person_details(p_effect_date) LOOP
681: hr_utility.trace('In v_person_details Loop:');
682: hr_utility.trace('Person_id:'||v_person_details.person_id);
683: hr_utility.trace('Assignment_id:'||v_person_details.assignment_id);

Line 681: hr_utility.trace('In v_person_details Loop:');

677: ,80));
678:
679: hr_utility.trace('before start of the loop');
680: FOR v_person_details IN c_person_details(p_effect_date) LOOP
681: hr_utility.trace('In v_person_details Loop:');
682: hr_utility.trace('Person_id:'||v_person_details.person_id);
683: hr_utility.trace('Assignment_id:'||v_person_details.assignment_id);
684: hr_utility.trace('Primary Flag:'||v_person_details.asg_primary_flag);
685: l_total_count:= l_total_count +1;

Line 682: hr_utility.trace('Person_id:'||v_person_details.person_id);

678:
679: hr_utility.trace('before start of the loop');
680: FOR v_person_details IN c_person_details(p_effect_date) LOOP
681: hr_utility.trace('In v_person_details Loop:');
682: hr_utility.trace('Person_id:'||v_person_details.person_id);
683: hr_utility.trace('Assignment_id:'||v_person_details.assignment_id);
684: hr_utility.trace('Primary Flag:'||v_person_details.asg_primary_flag);
685: l_total_count:= l_total_count +1;
686: l_current_asg_id:=v_person_details.assignment_id;

Line 683: hr_utility.trace('Assignment_id:'||v_person_details.assignment_id);

679: hr_utility.trace('before start of the loop');
680: FOR v_person_details IN c_person_details(p_effect_date) LOOP
681: hr_utility.trace('In v_person_details Loop:');
682: hr_utility.trace('Person_id:'||v_person_details.person_id);
683: hr_utility.trace('Assignment_id:'||v_person_details.assignment_id);
684: hr_utility.trace('Primary Flag:'||v_person_details.asg_primary_flag);
685: l_total_count:= l_total_count +1;
686: l_current_asg_id:=v_person_details.assignment_id;
687: IF v_person_details.asg_primary_flag = 'Y' THEN

Line 684: hr_utility.trace('Primary Flag:'||v_person_details.asg_primary_flag);

680: FOR v_person_details IN c_person_details(p_effect_date) LOOP
681: hr_utility.trace('In v_person_details Loop:');
682: hr_utility.trace('Person_id:'||v_person_details.person_id);
683: hr_utility.trace('Assignment_id:'||v_person_details.assignment_id);
684: hr_utility.trace('Primary Flag:'||v_person_details.asg_primary_flag);
685: l_total_count:= l_total_count +1;
686: l_current_asg_id:=v_person_details.assignment_id;
687: IF v_person_details.asg_primary_flag = 'Y' THEN
688: l_primary_asg_id := v_person_details.assignment_id;

Line 698: hr_utility.trace('RTI Payroll ID is:'||l_rti_payroll_id);

694: if nvl (v_person_details.per_agg_flag
695: ,'N') = 'Y' then
696: l_rti_payroll_id:= v_person_details.primary_assignment_number;
697: end if;
698: hr_utility.trace('RTI Payroll ID is:'||l_rti_payroll_id);
699: IF (p_effect_date <= v_person_details.assignment_start_date) THEN
700: l_effective_date := v_person_details.assignment_start_date;
701: ELSE
702: l_effective_date:=p_effect_date;

Line 705: hr_utility.trace('Effective Date for the assignment is now set to:'||l_effective_date);

701: ELSE
702: l_effective_date:=p_effect_date;
703: END IF;
704:
705: hr_utility.trace('Effective Date for the assignment is now set to:'||l_effective_date);
706: hr_utility.trace('calling NI reporting flag function...');
707: l_ni_reporting_flag := null;
708: l_ni_reporting_flag := get_ni_reporting_flag (v_person_details.assignment_id
709: ,l_effective_date,

Line 706: hr_utility.trace('calling NI reporting flag function...');

702: l_effective_date:=p_effect_date;
703: END IF;
704:
705: hr_utility.trace('Effective Date for the assignment is now set to:'||l_effective_date);
706: hr_utility.trace('calling NI reporting flag function...');
707: l_ni_reporting_flag := null;
708: l_ni_reporting_flag := get_ni_reporting_flag (v_person_details.assignment_id
709: ,l_effective_date,
710: v_person_details.person_id, tax_ref_no);

Line 711: hr_utility.trace('Back to Main Function after NI reporting flag fetch...');

707: l_ni_reporting_flag := null;
708: l_ni_reporting_flag := get_ni_reporting_flag (v_person_details.assignment_id
709: ,l_effective_date,
710: v_person_details.person_id, tax_ref_no);
711: hr_utility.trace('Back to Main Function after NI reporting flag fetch...');
712:
713: if l_rti_payroll_id is not null
714: and l_ni_reporting_flag is not null then
715:

Line 716: hr_utility.trace('RTI PayrollID is not null for assignment:'||v_person_details.assignment_id);

712:
713: if l_rti_payroll_id is not null
714: and l_ni_reporting_flag is not null then
715:
716: hr_utility.trace('RTI PayrollID is not null for assignment:'||v_person_details.assignment_id);
717: OPEN c_payroll_details (v_person_details.assignment_id);
718:
719: FETCH c_payroll_details
720: INTO v_payroll_details;

Line 723: hr_utility.trace('For this assignment extra_information doesnt exists hence inserting it');

719: FETCH c_payroll_details
720: INTO v_payroll_details;
721:
722: IF c_payroll_details%NOTFOUND THEN
723: hr_utility.trace('For this assignment extra_information doesnt exists hence inserting it');
724: SELECT per_assignment_extra_info_s.nextval
725: INTO v_assignment_extra_info_id
726: FROM dual;
727:

Line 728: hr_utility.trace ('assignment_id:'

724: SELECT per_assignment_extra_info_s.nextval
725: INTO v_assignment_extra_info_id
726: FROM dual;
727:
728: hr_utility.trace ('assignment_id:'
729: || v_person_details.assignment_id);
730:
731: hr_utility.trace ('l_assignment_number:'
732: || l_assignment_number);

Line 731: hr_utility.trace ('l_assignment_number:'

727:
728: hr_utility.trace ('assignment_id:'
729: || v_person_details.assignment_id);
730:
731: hr_utility.trace ('l_assignment_number:'
732: || l_assignment_number);
733:
734: hr_utility.trace ('p_effect_date:'
735: || p_effect_date);

Line 734: hr_utility.trace ('p_effect_date:'

730:
731: hr_utility.trace ('l_assignment_number:'
732: || l_assignment_number);
733:
734: hr_utility.trace ('p_effect_date:'
735: || p_effect_date);
736:
737: hr_utility.trace('Calling the Extra Information Insert API...');
738: hr_utility.trace('Parameters are:');

Line 737: hr_utility.trace('Calling the Extra Information Insert API...');

733:
734: hr_utility.trace ('p_effect_date:'
735: || p_effect_date);
736:
737: hr_utility.trace('Calling the Extra Information Insert API...');
738: hr_utility.trace('Parameters are:');
739: hr_utility.trace('p_aei_information1:'||l_ni_reporting_flag);
740: hr_utility.trace('p_aei_information2:'||fnd_date.date_to_canonical(p_effect_date));
741: hr_utility.trace('p_aei_information3:'||l_rti_payroll_id);

Line 738: hr_utility.trace('Parameters are:');

734: hr_utility.trace ('p_effect_date:'
735: || p_effect_date);
736:
737: hr_utility.trace('Calling the Extra Information Insert API...');
738: hr_utility.trace('Parameters are:');
739: hr_utility.trace('p_aei_information1:'||l_ni_reporting_flag);
740: hr_utility.trace('p_aei_information2:'||fnd_date.date_to_canonical(p_effect_date));
741: hr_utility.trace('p_aei_information3:'||l_rti_payroll_id);
742:

Line 739: hr_utility.trace('p_aei_information1:'||l_ni_reporting_flag);

735: || p_effect_date);
736:
737: hr_utility.trace('Calling the Extra Information Insert API...');
738: hr_utility.trace('Parameters are:');
739: hr_utility.trace('p_aei_information1:'||l_ni_reporting_flag);
740: hr_utility.trace('p_aei_information2:'||fnd_date.date_to_canonical(p_effect_date));
741: hr_utility.trace('p_aei_information3:'||l_rti_payroll_id);
742:
743: pay_gb_aei_api.pay_gb_ins_rti_agg_strt

Line 740: hr_utility.trace('p_aei_information2:'||fnd_date.date_to_canonical(p_effect_date));

736:
737: hr_utility.trace('Calling the Extra Information Insert API...');
738: hr_utility.trace('Parameters are:');
739: hr_utility.trace('p_aei_information1:'||l_ni_reporting_flag);
740: hr_utility.trace('p_aei_information2:'||fnd_date.date_to_canonical(p_effect_date));
741: hr_utility.trace('p_aei_information3:'||l_rti_payroll_id);
742:
743: pay_gb_aei_api.pay_gb_ins_rti_agg_strt
744: (p_assignment_id => v_person_details.assignment_id

Line 741: hr_utility.trace('p_aei_information3:'||l_rti_payroll_id);

737: hr_utility.trace('Calling the Extra Information Insert API...');
738: hr_utility.trace('Parameters are:');
739: hr_utility.trace('p_aei_information1:'||l_ni_reporting_flag);
740: hr_utility.trace('p_aei_information2:'||fnd_date.date_to_canonical(p_effect_date));
741: hr_utility.trace('p_aei_information3:'||l_rti_payroll_id);
742:
743: pay_gb_aei_api.pay_gb_ins_rti_agg_strt
744: (p_assignment_id => v_person_details.assignment_id
745: ,p_business_group_id => l_business_group_id

Line 755: hr_utility.trace('Back to main program after insert api call...');

751: ,p_aei_information4 => l_payroll_id
752: ,p_object_version_number => p_object_version_number
753: ,p_assignment_extra_info_id => p_assignment_extra_info_id);
754:
755: hr_utility.trace('Back to main program after insert api call...');
756: l_asg_pr_count := l_asg_pr_count +1;
757: fnd_file.put_line (fnd_file.output
758: ,rpad ('Person ID: '
759: || v_person_details.person_id

Line 789: hr_utility.trace('For this assignment extra_information already exists hence skipping it');

785: ,80));
786: ELSE
787: l_count_processed := 1;
788: l_asg_not_pr_count:=l_asg_not_pr_count +1;
789: hr_utility.trace('For this assignment extra_information already exists hence skipping it');
790: END IF;
791:
792: CLOSE c_payroll_details;
793: else

Line 794: hr_utility.trace('RTI Payroll ID is null, cause may be data corruption for this person');

790: END IF;
791:
792: CLOSE c_payroll_details;
793: else
794: hr_utility.trace('RTI Payroll ID is null, cause may be data corruption for this person');
795: l_pre_emp_length:= length(l_prev_emp_number);
796: l_curr_emp_length:= length(v_person_details.employee_number);
797: if v_person_details.employee_number = l_prev_emp_number then
798: null;

Line 801: hr_utility.trace('both are not equal');

797: if v_person_details.employee_number = l_prev_emp_number then
798: null;
799:
800: else
801: hr_utility.trace('both are not equal');
802: hr_utility.trace('v_person_details.employee_number <> l_prev_emp_number');
803: l_err_count:= l_err_count + 1;
804: l_err_employee(l_err_count):= v_person_details.employee_number;
805: l_prev_emp_number:= v_person_details.employee_number;

Line 802: hr_utility.trace('v_person_details.employee_number <> l_prev_emp_number');

798: null;
799:
800: else
801: hr_utility.trace('both are not equal');
802: hr_utility.trace('v_person_details.employee_number <> l_prev_emp_number');
803: l_err_count:= l_err_count + 1;
804: l_err_employee(l_err_count):= v_person_details.employee_number;
805: l_prev_emp_number:= v_person_details.employee_number;
806: end if;

Line 810: hr_utility.trace('End of loop');

806: end if;
807:
808: -- add the employee number and say these assignments dont have primary flag set
809: end if;
810: hr_utility.trace('End of loop');
811: END LOOP;
812: commit;
813:
814: hr_utility.trace('Total Count is:'||l_total_count);

Line 814: hr_utility.trace('Total Count is:'||l_total_count);

810: hr_utility.trace('End of loop');
811: END LOOP;
812: commit;
813:
814: hr_utility.trace('Total Count is:'||l_total_count);
815: hr_utility.trace('Assignment Count Processesed:'||l_asg_pr_count);
816: hr_utility.trace('Assignment Count Not Processesed:'||l_asg_not_pr_count);
817: hr_utility.trace('Error count is:'||l_err_count);
818: if l_err_count>0 then

Line 815: hr_utility.trace('Assignment Count Processesed:'||l_asg_pr_count);

811: END LOOP;
812: commit;
813:
814: hr_utility.trace('Total Count is:'||l_total_count);
815: hr_utility.trace('Assignment Count Processesed:'||l_asg_pr_count);
816: hr_utility.trace('Assignment Count Not Processesed:'||l_asg_not_pr_count);
817: hr_utility.trace('Error count is:'||l_err_count);
818: if l_err_count>0 then
819: --loop through the employees and show the errors

Line 816: hr_utility.trace('Assignment Count Not Processesed:'||l_asg_not_pr_count);

812: commit;
813:
814: hr_utility.trace('Total Count is:'||l_total_count);
815: hr_utility.trace('Assignment Count Processesed:'||l_asg_pr_count);
816: hr_utility.trace('Assignment Count Not Processesed:'||l_asg_not_pr_count);
817: hr_utility.trace('Error count is:'||l_err_count);
818: if l_err_count>0 then
819: --loop through the employees and show the errors
820:

Line 817: hr_utility.trace('Error count is:'||l_err_count);

813:
814: hr_utility.trace('Total Count is:'||l_total_count);
815: hr_utility.trace('Assignment Count Processesed:'||l_asg_pr_count);
816: hr_utility.trace('Assignment Count Not Processesed:'||l_asg_not_pr_count);
817: hr_utility.trace('Error count is:'||l_err_count);
818: if l_err_count>0 then
819: --loop through the employees and show the errors
820:
821: fnd_file.put_line (fnd_file.output

Line 846: hr_utility.trace('l_err_employee(l_err_emp_number):'||l_err_employee(l_err_emp_number));

842: ,80));
843:
844:
845: for l_err_emp_number in l_err_employee.first..l_err_employee.last loop
846: hr_utility.trace('l_err_employee(l_err_emp_number):'||l_err_employee(l_err_emp_number));
847: fnd_file.put_line (fnd_file.output
848: ,rpad(l_err_employee(l_err_emp_number),80)
849: );
850:

Line 886: hr_utility.trace('Error occured :'||SQLERRM);

882: when ex_complete_error then
883: retcode := ret_error_status;
884: errbuf := l_proc || ' : Completed with Error!';
885: when others then
886: hr_utility.trace('Error occured :'||SQLERRM);
887: hr_utility.trace('Count Values till now:');
888: hr_utility.trace('Total Assignment Count is:'||l_total_count);
889: hr_utility.trace('Count of Assignments Processesed:'||l_asg_pr_count);
890: hr_utility.trace('Count of Assignments Not Processesed:'||l_asg_not_pr_count);

Line 887: hr_utility.trace('Count Values till now:');

883: retcode := ret_error_status;
884: errbuf := l_proc || ' : Completed with Error!';
885: when others then
886: hr_utility.trace('Error occured :'||SQLERRM);
887: hr_utility.trace('Count Values till now:');
888: hr_utility.trace('Total Assignment Count is:'||l_total_count);
889: hr_utility.trace('Count of Assignments Processesed:'||l_asg_pr_count);
890: hr_utility.trace('Count of Assignments Not Processesed:'||l_asg_not_pr_count);
891: hr_utility.trace('Current Assignment is:'||l_current_asg_id);

Line 888: hr_utility.trace('Total Assignment Count is:'||l_total_count);

884: errbuf := l_proc || ' : Completed with Error!';
885: when others then
886: hr_utility.trace('Error occured :'||SQLERRM);
887: hr_utility.trace('Count Values till now:');
888: hr_utility.trace('Total Assignment Count is:'||l_total_count);
889: hr_utility.trace('Count of Assignments Processesed:'||l_asg_pr_count);
890: hr_utility.trace('Count of Assignments Not Processesed:'||l_asg_not_pr_count);
891: hr_utility.trace('Current Assignment is:'||l_current_asg_id);
892: hr_utility.trace('Error count is:'||l_err_count);

Line 889: hr_utility.trace('Count of Assignments Processesed:'||l_asg_pr_count);

885: when others then
886: hr_utility.trace('Error occured :'||SQLERRM);
887: hr_utility.trace('Count Values till now:');
888: hr_utility.trace('Total Assignment Count is:'||l_total_count);
889: hr_utility.trace('Count of Assignments Processesed:'||l_asg_pr_count);
890: hr_utility.trace('Count of Assignments Not Processesed:'||l_asg_not_pr_count);
891: hr_utility.trace('Current Assignment is:'||l_current_asg_id);
892: hr_utility.trace('Error count is:'||l_err_count);
893: END py_gb_rti_payroll_updt;

Line 890: hr_utility.trace('Count of Assignments Not Processesed:'||l_asg_not_pr_count);

886: hr_utility.trace('Error occured :'||SQLERRM);
887: hr_utility.trace('Count Values till now:');
888: hr_utility.trace('Total Assignment Count is:'||l_total_count);
889: hr_utility.trace('Count of Assignments Processesed:'||l_asg_pr_count);
890: hr_utility.trace('Count of Assignments Not Processesed:'||l_asg_not_pr_count);
891: hr_utility.trace('Current Assignment is:'||l_current_asg_id);
892: hr_utility.trace('Error count is:'||l_err_count);
893: END py_gb_rti_payroll_updt;
894: END pay_gb_rti_upd;

Line 891: hr_utility.trace('Current Assignment is:'||l_current_asg_id);

887: hr_utility.trace('Count Values till now:');
888: hr_utility.trace('Total Assignment Count is:'||l_total_count);
889: hr_utility.trace('Count of Assignments Processesed:'||l_asg_pr_count);
890: hr_utility.trace('Count of Assignments Not Processesed:'||l_asg_not_pr_count);
891: hr_utility.trace('Current Assignment is:'||l_current_asg_id);
892: hr_utility.trace('Error count is:'||l_err_count);
893: END py_gb_rti_payroll_updt;
894: END pay_gb_rti_upd;

Line 892: hr_utility.trace('Error count is:'||l_err_count);

888: hr_utility.trace('Total Assignment Count is:'||l_total_count);
889: hr_utility.trace('Count of Assignments Processesed:'||l_asg_pr_count);
890: hr_utility.trace('Count of Assignments Not Processesed:'||l_asg_not_pr_count);
891: hr_utility.trace('Current Assignment is:'||l_current_asg_id);
892: hr_utility.trace('Error count is:'||l_err_count);
893: END py_gb_rti_payroll_updt;
894: END pay_gb_rti_upd;