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

Line 78: -- hr_utility.trace_on(null,'ZATAXREGAR');

74:
75: leg_param pay_payroll_actions.legislative_parameters%type;
76:
77: begin
78: -- hr_utility.trace_on(null,'ZATAXREGAR');
79: hr_utility.set_location('Entering: '||l_proc,10);
80: hr_utility.set_location('pactid: '||pactid,10);
81:
82: -- Retrieve legislative parameters from the archiver payroll action

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

75: leg_param pay_payroll_actions.legislative_parameters%type;
76:
77: begin
78: -- hr_utility.trace_on(null,'ZATAXREGAR');
79: hr_utility.set_location('Entering: '||l_proc,10);
80: hr_utility.set_location('pactid: '||pactid,10);
81:
82: -- Retrieve legislative parameters from the archiver payroll action
83: select legislative_parameters

Line 80: hr_utility.set_location('pactid: '||pactid,10);

76:
77: begin
78: -- hr_utility.trace_on(null,'ZATAXREGAR');
79: hr_utility.set_location('Entering: '||l_proc,10);
80: hr_utility.set_location('pactid: '||pactid,10);
81:
82: -- Retrieve legislative parameters from the archiver payroll action
83: select legislative_parameters
84: into leg_param

Line 88: hr_utility.set_location('leg_param:'||leg_param,20);

84: into leg_param
85: from pay_payroll_actions
86: where payroll_action_id = pactid;
87:
88: hr_utility.set_location('leg_param:'||leg_param,20);
89:
90: -- Get Parameters
91: g_legal_entity_id := get_parameter(leg_param,'LEGAL_ENTITY');
92: g_end_period_date := fnd_date.canonical_to_date(get_parameter(leg_param,'END_PERIOD_DATE'));

Line 95: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);

91: g_legal_entity_id := get_parameter(leg_param,'LEGAL_ENTITY');
92: g_end_period_date := fnd_date.canonical_to_date(get_parameter(leg_param,'END_PERIOD_DATE'));
93: g_spc_asg_id := get_parameter(leg_param,'SPC_ASG');
94:
95: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);
96: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);
97:
98: -- commenting this out as this range cursor is no longer valid
99: /*

Line 96: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);

92: g_end_period_date := fnd_date.canonical_to_date(get_parameter(leg_param,'END_PERIOD_DATE'));
93: g_spc_asg_id := get_parameter(leg_param,'SPC_ASG');
94:
95: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);
96: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);
97:
98: -- commenting this out as this range cursor is no longer valid
99: /*
100: sqlstr :=

Line 132: hr_utility.set_location(' Leaving: '||l_proc,100);

128: end if;
129:
130: sqlstr := sqlstr|| ' ORDER BY PAF.person_id';
131:
132: hr_utility.set_location(' Leaving: '||l_proc,100);
133: end range_cursor;
134:
135: procedure action_creation(pactid in number,
136: stperson in number,

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

192:
193: leg_param pay_payroll_actions.legislative_parameters%type;
194:
195: begin
196: hr_utility.set_location('Entering: '||l_proc,10);
197: hr_utility.set_location('chunk: '||chunk,10);
198:
199: -- Retrieve legislative parameters from the archiver payroll action
200: select legislative_parameters

Line 197: hr_utility.set_location('chunk: '||chunk,10);

193: leg_param pay_payroll_actions.legislative_parameters%type;
194:
195: begin
196: hr_utility.set_location('Entering: '||l_proc,10);
197: hr_utility.set_location('chunk: '||chunk,10);
198:
199: -- Retrieve legislative parameters from the archiver payroll action
200: select legislative_parameters
201: into leg_param

Line 205: hr_utility.set_location('leg_param:'||leg_param,20);

201: into leg_param
202: from pay_payroll_actions
203: where payroll_action_id = pactid;
204:
205: hr_utility.set_location('leg_param:'||leg_param,20);
206:
207: -- Get Parameters
208: g_legal_entity_id := get_parameter(leg_param,'LEGAL_ENTITY');
209: g_payroll_id := get_parameter(leg_param,'PAYROLL_ID');

Line 214: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);

210: g_end_period_date := fnd_date.canonical_to_date(get_parameter(leg_param,'END_PERIOD_DATE'));
211: g_inc_all_asg := get_parameter(leg_param,'INC_ALL_ASG');
212: g_spc_asg_id := get_parameter(leg_param,'SPC_ASG');
213:
214: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);
215: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);
216: hr_utility.set_location('g_payroll_id :'||g_payroll_id ,20);
217: hr_utility.set_location('g_spc_asg_id:'||g_spc_asg_id,20);
218: hr_utility.set_location('g_inc_all_asg:'||g_inc_all_asg,20);

Line 215: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);

211: g_inc_all_asg := get_parameter(leg_param,'INC_ALL_ASG');
212: g_spc_asg_id := get_parameter(leg_param,'SPC_ASG');
213:
214: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);
215: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);
216: hr_utility.set_location('g_payroll_id :'||g_payroll_id ,20);
217: hr_utility.set_location('g_spc_asg_id:'||g_spc_asg_id,20);
218: hr_utility.set_location('g_inc_all_asg:'||g_inc_all_asg,20);
219:

Line 216: hr_utility.set_location('g_payroll_id :'||g_payroll_id ,20);

212: g_spc_asg_id := get_parameter(leg_param,'SPC_ASG');
213:
214: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);
215: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);
216: hr_utility.set_location('g_payroll_id :'||g_payroll_id ,20);
217: hr_utility.set_location('g_spc_asg_id:'||g_spc_asg_id,20);
218: hr_utility.set_location('g_inc_all_asg:'||g_inc_all_asg,20);
219:
220: FOR v_assignments IN csr_processed_assignments

Line 217: hr_utility.set_location('g_spc_asg_id:'||g_spc_asg_id,20);

213:
214: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);
215: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);
216: hr_utility.set_location('g_payroll_id :'||g_payroll_id ,20);
217: hr_utility.set_location('g_spc_asg_id:'||g_spc_asg_id,20);
218: hr_utility.set_location('g_inc_all_asg:'||g_inc_all_asg,20);
219:
220: FOR v_assignments IN csr_processed_assignments
221: ( p_payroll_id => g_payroll_id

Line 218: hr_utility.set_location('g_inc_all_asg:'||g_inc_all_asg,20);

214: hr_utility.set_location('g_legal_entity_id:'||g_legal_entity_id,20);
215: hr_utility.set_location('g_end_period_date:'||g_end_period_date,20);
216: hr_utility.set_location('g_payroll_id :'||g_payroll_id ,20);
217: hr_utility.set_location('g_spc_asg_id:'||g_spc_asg_id,20);
218: hr_utility.set_location('g_inc_all_asg:'||g_inc_all_asg,20);
219:
220: FOR v_assignments IN csr_processed_assignments
221: ( p_payroll_id => g_payroll_id
222: , p_period_end_date => g_end_period_date

Line 227: hr_utility.set_location('Assignment ID:'||v_assignments.assignment_id,20);

223: , p_asg_id => g_spc_asg_id
224: , p_legal_entity_id => g_legal_entity_id
225: )
226: LOOP
227: hr_utility.set_location('Assignment ID:'||v_assignments.assignment_id,20);
228:
229: IF (py_za_tax_reg.include_assignment(v_assignments.assignment_id,
230: g_end_period_date,
231: g_inc_all_asg) = 'Y') THEN

Line 232: hr_utility.set_location('Incl Assignment ID:'||v_assignments.assignment_id,30);

228:
229: IF (py_za_tax_reg.include_assignment(v_assignments.assignment_id,
230: g_end_period_date,
231: g_inc_all_asg) = 'Y') THEN
232: hr_utility.set_location('Incl Assignment ID:'||v_assignments.assignment_id,30);
233:
234: select pay_assignment_actions_s.nextval
235: into l_ass_act_id
236: from dual;

Line 249: hr_utility.set_location(' Leaving: '||l_proc,100);

245:
246:
247: END LOOP; -- End of Loop csr_processed_assignments
248:
249: hr_utility.set_location(' Leaving: '||l_proc,100);
250: end action_creation;
251:
252: procedure archinit(p_payroll_action_id in number)
253: is

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

256: leg_param pay_payroll_actions.legislative_parameters%type;
257:
258:
259: begin
260: hr_utility.set_location('Entering: '||l_proc,10);
261:
262:
263: -- Commenting out below portion as it is not required to set
264: -- the globals from archinit when they are getting set in

Line 274: hr_utility.set_location('leg_param:'||leg_param,20);

270: into leg_param
271: from pay_payroll_actions
272: where payroll_action_id = p_payroll_action_id;
273:
274: hr_utility.set_location('leg_param:'||leg_param,20);
275:
276: -- Get Parameters
277: g_legal_entity_id := get_parameter(leg_param,'LEGAL_ENTITY');
278: g_payroll_id := get_parameter(leg_param,'PAYROLL_ID');

Line 307: hr_utility.set_location('Leaving: '||l_proc,100);

303: , p_tax_year => g_tax_year
304: );
305: */
306:
307: hr_utility.set_location('Leaving: '||l_proc,100);
308: end archinit;
309:
310: procedure archive_code(p_assactid in number,
311: p_effective_date in date)

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

330: l_qtr_num number;
331: l_pay_advice_date per_time_periods.end_date%type;
332:
333: begin
334: hr_utility.set_location('Entering: '||l_proc,10);
335: hr_utility.set_location('Processing Action ID:'||p_assactid,10);
336:
337: -- Retrieve legislative parameters from the archiver payroll action
338: select ppa.legislative_parameters, ppa.payroll_action_id

Line 335: hr_utility.set_location('Processing Action ID:'||p_assactid,10);

331: l_pay_advice_date per_time_periods.end_date%type;
332:
333: begin
334: hr_utility.set_location('Entering: '||l_proc,10);
335: hr_utility.set_location('Processing Action ID:'||p_assactid,10);
336:
337: -- Retrieve legislative parameters from the archiver payroll action
338: select ppa.legislative_parameters, ppa.payroll_action_id
339: into leg_param, l_payroll_action_id

Line 345: hr_utility.set_location('leg_param:'||leg_param,20);

341: pay_assignment_actions paa
342: where paa.payroll_action_id = ppa.payroll_action_id
343: and paa.assignment_action_id = p_assactid;
344:
345: hr_utility.set_location('leg_param:'||leg_param,20);
346:
347: -- Get Parameters
348: g_payroll_name := get_parameter(leg_param,'PAYROLL_NAME');
349: g_end_period_date := fnd_date.canonical_to_date(get_parameter(leg_param,'END_PERIOD_DATE'));

Line 383: hr_utility.set_location('g_tax_year:'||g_tax_year,20);

379: where paf2.assignment_id = paa.assignment_id
380: and effective_start_date <= g_end_period_date)
381: and g_end_period_date between ptp.start_date and ptp.end_date;
382:
383: hr_utility.set_location('g_tax_year:'||g_tax_year,20);
384: hr_utility.set_location('g_end_period_id:'||g_end_period_id,20);
385: hr_utility.set_location('l_qtr_num:'||l_qtr_num,20);
386: hr_utility.set_location('l_pay_advice_date:'||l_pay_advice_date,20);
387:

Line 384: hr_utility.set_location('g_end_period_id:'||g_end_period_id,20);

380: and effective_start_date <= g_end_period_date)
381: and g_end_period_date between ptp.start_date and ptp.end_date;
382:
383: hr_utility.set_location('g_tax_year:'||g_tax_year,20);
384: hr_utility.set_location('g_end_period_id:'||g_end_period_id,20);
385: hr_utility.set_location('l_qtr_num:'||l_qtr_num,20);
386: hr_utility.set_location('l_pay_advice_date:'||l_pay_advice_date,20);
387:
388:

Line 385: hr_utility.set_location('l_qtr_num:'||l_qtr_num,20);

381: and g_end_period_date between ptp.start_date and ptp.end_date;
382:
383: hr_utility.set_location('g_tax_year:'||g_tax_year,20);
384: hr_utility.set_location('g_end_period_id:'||g_end_period_id,20);
385: hr_utility.set_location('l_qtr_num:'||l_qtr_num,20);
386: hr_utility.set_location('l_pay_advice_date:'||l_pay_advice_date,20);
387:
388:
389: if to_char(g_end_period_date, 'Mon') = 'Aug' then

Line 386: hr_utility.set_location('l_pay_advice_date:'||l_pay_advice_date,20);

382:
383: hr_utility.set_location('g_tax_year:'||g_tax_year,20);
384: hr_utility.set_location('g_end_period_id:'||g_end_period_id,20);
385: hr_utility.set_location('l_qtr_num:'||l_qtr_num,20);
386: hr_utility.set_location('l_pay_advice_date:'||l_pay_advice_date,20);
387:
388:
389: if to_char(g_end_period_date, 'Mon') = 'Aug' then
390: if l_qtr_num <> 2 then

Line 405: hr_utility.set_location('g_tax_year:'||g_tax_year,20);

401: end if;
402:
403: end if;
404:
405: hr_utility.set_location('g_tax_year:'||g_tax_year,20);
406: hr_utility.set_location('g_end_period_id:'||g_end_period_id,20);
407:
408:
409: select MIN(ptp.time_period_id)

Line 406: hr_utility.set_location('g_end_period_id:'||g_end_period_id,20);

402:
403: end if;
404:
405: hr_utility.set_location('g_tax_year:'||g_tax_year,20);
406: hr_utility.set_location('g_end_period_id:'||g_end_period_id,20);
407:
408:
409: select MIN(ptp.time_period_id)
410: into g_st_period_id

Line 427: hr_utility.set_location('Assignment ID:'||l_asg_id,20);

423: , p_retrieve_ytd => g_ret_ytd
424: , p_tax_year => g_tax_year
425: );
426:
427: hr_utility.set_location('Assignment ID:'||l_asg_id,20);
428:
429: IF ( g_tax_year <= '2009') THEN
430: py_za_tax_reg.pre_process(
431: p_payroll_id => g_payroll_id

Line 469: hr_utility.set_location('l_tot_assignments '||l_tax_register_id,30);

465: , p_assactid => p_assactid
466: );
467: END IF;
468:
469: hr_utility.set_location('l_tot_assignments '||l_tax_register_id,30);
470: hr_utility.set_location('l_tot_assignments '||l_tot_assignments,30);
471:
472: hr_utility.set_location('Leaving: '||l_proc,100);
473: end archive_code;

Line 470: hr_utility.set_location('l_tot_assignments '||l_tot_assignments,30);

466: );
467: END IF;
468:
469: hr_utility.set_location('l_tot_assignments '||l_tax_register_id,30);
470: hr_utility.set_location('l_tot_assignments '||l_tot_assignments,30);
471:
472: hr_utility.set_location('Leaving: '||l_proc,100);
473: end archive_code;
474:

Line 472: hr_utility.set_location('Leaving: '||l_proc,100);

468:
469: hr_utility.set_location('l_tot_assignments '||l_tax_register_id,30);
470: hr_utility.set_location('l_tot_assignments '||l_tot_assignments,30);
471:
472: hr_utility.set_location('Leaving: '||l_proc,100);
473: end archive_code;
474:
475:
476: procedure deinit_code(pactid in number)

Line 533: hr_utility.set_location('leg_param:'||leg_param,10);

529: into leg_param
530: from pay_payroll_actions
531: where payroll_action_id = pactid;
532:
533: hr_utility.set_location('leg_param:'||leg_param,10);
534:
535: -- Get Parameters
536: g_end_period_date := fnd_date.canonical_to_date(get_parameter(leg_param,'END_PERIOD_DATE'));
537: g_inc_all_asg := get_parameter(leg_param,'INC_ALL_ASG');

Line 558: hr_utility.set_location('Archiving payroll info',20);

554:
555:
556: for pay in get_payroll_info
557: loop
558: hr_utility.set_location('Archiving payroll info',20);
559: -- Archive PAYROLL DETAILS
560: pay_action_information_api.create_action_information
561: (
562: p_action_information_id => l_action_info_id,

Line 574: hr_utility.set_location('Archived payroll info',30);

570: p_action_information3 => pay.start_date,
571: p_action_information4 => pay.end_date
572: );
573:
574: hr_utility.set_location('Archived payroll info',30);
575: end loop;
576:
577:
578: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','PYZATXREGREP','en','US','PDF');

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

600: -- Commit;
601: --check for process submit error
602: IF l_request_id = 0
603: THEN
604: hr_utility.set_location('Error spawning new process',1);
605: END IF;
606: END IF;
607:
608: end deinit_code;