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

Line 141: hr_utility.set_location('Entering: '||l_proc,1);

137:
138: l_person_rec csr_person_details%rowtype;
139: BEGIN
140:
141: hr_utility.set_location('Entering: '||l_proc,1);
142: l_arch := true;
143:
144: open csr_person_details;
145: fetch csr_person_details into l_person_rec;

Line 152: hr_utility.trace('Start date ' ||l_person_rec.effective_start_date);

148: l_arch := false;
149: end if;
150: close csr_person_details;
151:
152: hr_utility.trace('Start date ' ||l_person_rec.effective_start_date);
153:
154:
155: p_person_rec.person_id := l_person_rec.p_person_id;
156: p_person_rec.assignment_id := l_person_rec.assignment_id;

Line 164: hr_utility.set_location('Leaving: '||l_proc,999);

160: p_person_rec.act_info5 := l_person_rec.national_identifier;
161: p_person_rec.act_info6 := l_person_rec.emp_no;
162: p_person_rec.act_info7 := l_person_rec.p_person_id;
163:
164: hr_utility.set_location('Leaving: '||l_proc,999);
165: return l_arch;
166: END fetch_person_rec;
167: --
168: --

Line 177: hr_utility.set_location('Entering: '||l_proc,1);

173: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';
174: l_ovn number;
175: l_action_id number;
176: BEGIN
177: hr_utility.set_location('Entering: '||l_proc,1);
178: if p_tab_rec_data.count > 0 then
179: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
180: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
181: hr_utility.trace('action_context_id = '|| p_assactid);

Line 180: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);

176: BEGIN
177: hr_utility.set_location('Entering: '||l_proc,1);
178: if p_tab_rec_data.count > 0 then
179: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
180: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
181: hr_utility.trace('action_context_id = '|| p_assactid);
182: if p_tab_rec_data(i).action_info_category is not null then
183: pay_action_information_api.create_action_information(
184: p_action_information_id => l_action_id,

Line 181: hr_utility.trace('action_context_id = '|| p_assactid);

177: hr_utility.set_location('Entering: '||l_proc,1);
178: if p_tab_rec_data.count > 0 then
179: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
180: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
181: hr_utility.trace('action_context_id = '|| p_assactid);
182: if p_tab_rec_data(i).action_info_category is not null then
183: pay_action_information_api.create_action_information(
184: p_action_information_id => l_action_id,
185: p_object_version_number => l_ovn,

Line 225: hr_utility.set_location('Leaving: '||l_proc,999);

221: );
222: end if;
223: end loop;
224: end if;
225: hr_utility.set_location('Leaving: '||l_proc,999);
226: END insert_archive_row;
227: --
228: --
229:

Line 255: hr_utility.set_location('Entering: '||l_proc,1);

251: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
252: BEGIN
253:
254:
255: hr_utility.set_location('Entering: '||l_proc,1);
256: fnd_file.put_line(FND_FILE.log, 'Enering Range: pactid: '||pactid);
257: OPEN csr_parameter_info;
258: fetch csr_parameter_info into l_report_type;
259: CLOSE csr_parameter_info ;

Line 269: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

265: 'pay_payroll_actions ppa '||
266: 'where ppa.payroll_action_id = :payroll_action_id '||
267: 'and ppa.business_group_id = ppf.business_group_id '||
268: 'order by ppf.person_id';
269: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
270:
271: END IF;
272: hr_utility.set_location('Leaving '|| l_proc, 10);
273: EXCEPTION

Line 272: hr_utility.set_location('Leaving '|| l_proc, 10);

268: 'order by ppf.person_id';
269: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
270:
271: END IF;
272: hr_utility.set_location('Leaving '|| l_proc, 10);
273: EXCEPTION
274: when others then
275: hr_utility.set_location(' Leaving: '||l_proc,50);
276: fnd_file.put_line(FND_FILE.log, 'Exception in range: '||sqlcode || '-' || sqlerrm);

Line 275: hr_utility.set_location(' Leaving: '||l_proc,50);

271: END IF;
272: hr_utility.set_location('Leaving '|| l_proc, 10);
273: EXCEPTION
274: when others then
275: hr_utility.set_location(' Leaving: '||l_proc,50);
276: fnd_file.put_line(FND_FILE.log, 'Exception in range: '||sqlcode || '-' || sqlerrm);
277: hr_utility.raise_error;
278: -- raise_application_error(-20001,'Errors found in range cursor.');
279: END range_cursor;

Line 277: hr_utility.raise_error;

273: EXCEPTION
274: when others then
275: hr_utility.set_location(' Leaving: '||l_proc,50);
276: fnd_file.put_line(FND_FILE.log, 'Exception in range: '||sqlcode || '-' || sqlerrm);
277: hr_utility.raise_error;
278: -- raise_application_error(-20001,'Errors found in range cursor.');
279: END range_cursor;
280: --
281: --

Line 372: hr_utility.set_location('Entering: '||l_proc,1);

368:
369:
370: BEGIN
371:
372: hr_utility.set_location('Entering: '||l_proc,1);
373:
374: open csr_parameter_info;
375: fetch csr_parameter_info into l_tax_ref,
376: l_payroll_id,

Line 383: hr_utility.set_location('Fetching Assignments with DEO type Court Order',15);

379: l_business_group_id;
380: close csr_parameter_info;
381:
382:
383: hr_utility.set_location('Fetching Assignments with DEO type Court Order',15);
384: -- To fetch DEO records
385: for asg_rec in csr_get_deo_asg(l_tax_ref,l_payroll_id,l_payment_from_date,l_payment_to_date,l_business_group_id)
386: loop
387: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);

Line 387: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);

383: hr_utility.set_location('Fetching Assignments with DEO type Court Order',15);
384: -- To fetch DEO records
385: for asg_rec in csr_get_deo_asg(l_tax_ref,l_payroll_id,l_payment_from_date,l_payment_to_date,l_business_group_id)
386: loop
387: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
388: --hr_utility.set_location('Assignment ID :' || asg_rec.assignment_action_id,15);
389: --hr_utility.set_location('Assignment ID :' || asg_rec.date_paid,15);
390:
391: -- Create one assignment action for every assignment

Line 388: --hr_utility.set_location('Assignment ID :' || asg_rec.assignment_action_id,15);

384: -- To fetch DEO records
385: for asg_rec in csr_get_deo_asg(l_tax_ref,l_payroll_id,l_payment_from_date,l_payment_to_date,l_business_group_id)
386: loop
387: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
388: --hr_utility.set_location('Assignment ID :' || asg_rec.assignment_action_id,15);
389: --hr_utility.set_location('Assignment ID :' || asg_rec.date_paid,15);
390:
391: -- Create one assignment action for every assignment
392: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);

Line 389: --hr_utility.set_location('Assignment ID :' || asg_rec.date_paid,15);

385: for asg_rec in csr_get_deo_asg(l_tax_ref,l_payroll_id,l_payment_from_date,l_payment_to_date,l_business_group_id)
386: loop
387: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
388: --hr_utility.set_location('Assignment ID :' || asg_rec.assignment_action_id,15);
389: --hr_utility.set_location('Assignment ID :' || asg_rec.date_paid,15);
390:
391: -- Create one assignment action for every assignment
392: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
393: select pay_assignment_actions_s.nextval

Line 392: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);

388: --hr_utility.set_location('Assignment ID :' || asg_rec.assignment_action_id,15);
389: --hr_utility.set_location('Assignment ID :' || asg_rec.date_paid,15);
390:
391: -- Create one assignment action for every assignment
392: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
393: select pay_assignment_actions_s.nextval
394: into lockingactid
395: from dual;
396:

Line 407: hr_utility.set_location('Leaving: '||l_proc,999);

403: chunk,
404: null
405: );
406: end loop;
407: hr_utility.set_location('Leaving: '||l_proc,999);
408:
409: end action_creation;
410:
411:

Line 424: hr_utility.set_location('Entering '|| l_proc, 10);

420: IS
421: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
422:
423: BEGIN
424: hr_utility.set_location('Entering '|| l_proc, 10);
425:
426: hr_utility.set_location('Leaving '|| l_proc, 10);
427: END archinit;
428: --

Line 426: hr_utility.set_location('Leaving '|| l_proc, 10);

422:
423: BEGIN
424: hr_utility.set_location('Entering '|| l_proc, 10);
425:
426: hr_utility.set_location('Leaving '|| l_proc, 10);
427: END archinit;
428: --
429: --
430: --

Line 618: hr_utility.set_location('Entering: '||l_proc,1);

614: l_sum_due number := 0;
615:
616:
617: BEGIN
618: hr_utility.set_location('Entering: '||l_proc,1);
619: hr_utility.set_location('p_effective_date: '||p_effective_date,1);
620: open csr_parameter_info;
621: fetch csr_parameter_info into l_tax_ref,
622: l_payroll_id,

Line 619: hr_utility.set_location('p_effective_date: '||p_effective_date,1);

615:
616:
617: BEGIN
618: hr_utility.set_location('Entering: '||l_proc,1);
619: hr_utility.set_location('p_effective_date: '||p_effective_date,1);
620: open csr_parameter_info;
621: fetch csr_parameter_info into l_tax_ref,
622: l_payroll_id,
623: l_payment_from_date,

Line 629: hr_utility.set_location('Archive Code ',10);

625: l_business_group_id;
626: close csr_parameter_info;
627:
628:
629: hr_utility.set_location('Archive Code ',10);
630: hr_utility.set_location('Fetching Employee details ',20);
631: -- Fetching employee details
632: l_archive_person := fetch_person_rec(p_assactid, p_effective_date,l_archive_tab(0));
633:

Line 630: hr_utility.set_location('Fetching Employee details ',20);

626: close csr_parameter_info;
627:
628:
629: hr_utility.set_location('Archive Code ',10);
630: hr_utility.set_location('Fetching Employee details ',20);
631: -- Fetching employee details
632: l_archive_person := fetch_person_rec(p_assactid, p_effective_date,l_archive_tab(0));
633:
634: hr_utility.set_location('Fetching Assignment DEO details ',30);

Line 634: hr_utility.set_location('Fetching Assignment DEO details ',30);

630: hr_utility.set_location('Fetching Employee details ',20);
631: -- Fetching employee details
632: l_archive_person := fetch_person_rec(p_assactid, p_effective_date,l_archive_tab(0));
633:
634: hr_utility.set_location('Fetching Assignment DEO details ',30);
635:
636:
637: OPEN get_defined_balance_id('Court Order','_PER_CO_TD_REF_PTD');
638: FETCH get_defined_balance_id INTO g_co_id;

Line 709: hr_utility.set_location('Leaving: '||l_proc,999);

705: if l_archive_person then
706: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);
707: end if;
708:
709: hr_utility.set_location('Leaving: '||l_proc,999);
710:
711: EXCEPTION
712: when others then
713: raise_application_error(-20001,'Errors found while archiving data.');

Line 1041: hr_utility.set_location('Entering deinit: '||l_proc,1);

1037: ---------------------
1038:
1039: BEGIN
1040:
1041: hr_utility.set_location('Entering deinit: '||l_proc,1);
1042:
1043: -- To avoid re-archiving while Retry
1044: delete from pay_action_information pai
1045: where pai.action_context_id = pactid

Line 1062: hr_utility.set_location('Business group id = ' || l_emp_rec.business_group_id,10);

1058: end if;
1059:
1060: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
1061:
1062: hr_utility.set_location('Business group id = ' || l_emp_rec.business_group_id,10);
1063: hr_utility.set_location('Employer PAYE Reference = ' || l_emp_rec.tax_ref,20);
1064: hr_utility.set_location('Employer Name = ' || l_emp_rec.employer_name,30);
1065: hr_utility.set_location('Payroll Name = '||l_payroll_name,40);
1066: hr_utility.set_location('Payment from date = '||l_emp_rec.payment_from_date,50);

Line 1063: hr_utility.set_location('Employer PAYE Reference = ' || l_emp_rec.tax_ref,20);

1059:
1060: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
1061:
1062: hr_utility.set_location('Business group id = ' || l_emp_rec.business_group_id,10);
1063: hr_utility.set_location('Employer PAYE Reference = ' || l_emp_rec.tax_ref,20);
1064: hr_utility.set_location('Employer Name = ' || l_emp_rec.employer_name,30);
1065: hr_utility.set_location('Payroll Name = '||l_payroll_name,40);
1066: hr_utility.set_location('Payment from date = '||l_emp_rec.payment_from_date,50);
1067: hr_utility.set_location('Payment to date = '||l_emp_rec.payment_to_date,60);

Line 1064: hr_utility.set_location('Employer Name = ' || l_emp_rec.employer_name,30);

1060: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
1061:
1062: hr_utility.set_location('Business group id = ' || l_emp_rec.business_group_id,10);
1063: hr_utility.set_location('Employer PAYE Reference = ' || l_emp_rec.tax_ref,20);
1064: hr_utility.set_location('Employer Name = ' || l_emp_rec.employer_name,30);
1065: hr_utility.set_location('Payroll Name = '||l_payroll_name,40);
1066: hr_utility.set_location('Payment from date = '||l_emp_rec.payment_from_date,50);
1067: hr_utility.set_location('Payment to date = '||l_emp_rec.payment_to_date,60);
1068:

Line 1065: hr_utility.set_location('Payroll Name = '||l_payroll_name,40);

1061:
1062: hr_utility.set_location('Business group id = ' || l_emp_rec.business_group_id,10);
1063: hr_utility.set_location('Employer PAYE Reference = ' || l_emp_rec.tax_ref,20);
1064: hr_utility.set_location('Employer Name = ' || l_emp_rec.employer_name,30);
1065: hr_utility.set_location('Payroll Name = '||l_payroll_name,40);
1066: hr_utility.set_location('Payment from date = '||l_emp_rec.payment_from_date,50);
1067: hr_utility.set_location('Payment to date = '||l_emp_rec.payment_to_date,60);
1068:
1069: hr_utility.set_location('Archiving GB DEO EMPLOYER DETAILS',60);

Line 1066: hr_utility.set_location('Payment from date = '||l_emp_rec.payment_from_date,50);

1062: hr_utility.set_location('Business group id = ' || l_emp_rec.business_group_id,10);
1063: hr_utility.set_location('Employer PAYE Reference = ' || l_emp_rec.tax_ref,20);
1064: hr_utility.set_location('Employer Name = ' || l_emp_rec.employer_name,30);
1065: hr_utility.set_location('Payroll Name = '||l_payroll_name,40);
1066: hr_utility.set_location('Payment from date = '||l_emp_rec.payment_from_date,50);
1067: hr_utility.set_location('Payment to date = '||l_emp_rec.payment_to_date,60);
1068:
1069: hr_utility.set_location('Archiving GB DEO EMPLOYER DETAILS',60);
1070:

Line 1067: hr_utility.set_location('Payment to date = '||l_emp_rec.payment_to_date,60);

1063: hr_utility.set_location('Employer PAYE Reference = ' || l_emp_rec.tax_ref,20);
1064: hr_utility.set_location('Employer Name = ' || l_emp_rec.employer_name,30);
1065: hr_utility.set_location('Payroll Name = '||l_payroll_name,40);
1066: hr_utility.set_location('Payment from date = '||l_emp_rec.payment_from_date,50);
1067: hr_utility.set_location('Payment to date = '||l_emp_rec.payment_to_date,60);
1068:
1069: hr_utility.set_location('Archiving GB DEO EMPLOYER DETAILS',60);
1070:
1071: pay_action_information_api.create_action_information (

Line 1069: hr_utility.set_location('Archiving GB DEO EMPLOYER DETAILS',60);

1065: hr_utility.set_location('Payroll Name = '||l_payroll_name,40);
1066: hr_utility.set_location('Payment from date = '||l_emp_rec.payment_from_date,50);
1067: hr_utility.set_location('Payment to date = '||l_emp_rec.payment_to_date,60);
1068:
1069: hr_utility.set_location('Archiving GB DEO EMPLOYER DETAILS',60);
1070:
1071: pay_action_information_api.create_action_information (
1072: p_action_information_id => l_action_info_id
1073: , p_action_context_id => pactid

Line 1102: hr_utility.set_location('Spawning DEO Payment Schedule Output process:'||l_emp_rec.report_format,1);

1098: write_footer;
1099:
1100: -- For Spawning the output Concurrent Program
1101:
1102: hr_utility.set_location('Spawning DEO Payment Schedule Output process:'||l_emp_rec.report_format,1);
1103:
1104: if (xml_layout) then
1105: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');
1106: end if;

Line 1118: hr_utility.set_location('xml_layout is true',1);

1114: elsif l_emp_rec.report_format = 'CSV' then
1115: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','PAYGBDEOSOPCSV','en','US','ETEXT');
1116: end if;
1117: if xml_layout then
1118: hr_utility.set_location('xml_layout is true',1);
1119: fnd_file.put_line(fnd_file.LOG,'xml_layout is true');
1120: else
1121: hr_utility.set_location('xml_layout is false',2);
1122: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');

Line 1121: hr_utility.set_location('xml_layout is false',2);

1117: if xml_layout then
1118: hr_utility.set_location('xml_layout is true',1);
1119: fnd_file.put_line(fnd_file.LOG,'xml_layout is true');
1120: else
1121: hr_utility.set_location('xml_layout is false',2);
1122: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');
1123: end if;
1124:
1125: IF (xml_layout = true and g_validation_check = 'Y')

Line 1139: hr_utility.set_location('Error spawning new process',1);

1135: --check for process submit error
1136: IF l_request_id = 0
1137: THEN
1138: fnd_file.put_line(fnd_file.LOG,'Error spawning new process');
1139: hr_utility.set_location('Error spawning new process',1);
1140: END IF;
1141: END IF;
1142:
1143: hr_utility.set_location('Leaving: '||l_proc,999);

Line 1143: hr_utility.set_location('Leaving: '||l_proc,999);

1139: hr_utility.set_location('Error spawning new process',1);
1140: END IF;
1141: END IF;
1142:
1143: hr_utility.set_location('Leaving: '||l_proc,999);
1144:
1145: END deinitialization_code;
1146: --
1147: --