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

Line 67: g_debug boolean := hr_utility.debug_enabled;

63: --
64: c_package constant varchar2(31) := 'pay_yrend_reports_pkg.';
65: c_commit_num constant number := 1000;
66: --
67: g_debug boolean := hr_utility.debug_enabled;
68: --
69: ----------------------------------- range_cursor ----------------------------------
70: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
71: /* Bug : 10254849 */

Line 124: hr_utility.trace('List of Person IDs, Assignment IDs picked up by RANGE CURSOR Code');

120: /* Bug : 10254849 */
121: if g_debug then
122: open get_person_id_debug(pactid, l_eoy_payroll_action_id, l_tax_unit_id);
123: num := 0;
124: hr_utility.trace('List of Person IDs, Assignment IDs picked up by RANGE CURSOR Code');
125: hr_utility.trace('-----------------------------------------------------------------');
126: loop
127: fetch get_person_id_debug into person_id,assignment_id;
128: if get_person_id_debug%found then num := num + 1; end if;

Line 125: hr_utility.trace('-----------------------------------------------------------------');

121: if g_debug then
122: open get_person_id_debug(pactid, l_eoy_payroll_action_id, l_tax_unit_id);
123: num := 0;
124: hr_utility.trace('List of Person IDs, Assignment IDs picked up by RANGE CURSOR Code');
125: hr_utility.trace('-----------------------------------------------------------------');
126: loop
127: fetch get_person_id_debug into person_id,assignment_id;
128: if get_person_id_debug%found then num := num + 1; end if;
129: exit when get_person_id_debug%notfound;

Line 130: hr_utility.trace(' (' || num || ') ' || 'PERSON ID :' || person_id || ' ASSIGNMENT ID :' || assignment_id);

126: loop
127: fetch get_person_id_debug into person_id,assignment_id;
128: if get_person_id_debug%found then num := num + 1; end if;
129: exit when get_person_id_debug%notfound;
130: hr_utility.trace(' (' || num || ') ' || 'PERSON ID :' || person_id || ' ASSIGNMENT ID :' || assignment_id);
131: end loop;
132: close get_person_id_debug;
133: end if;
134:

Line 135: --hr_utility.trace('Session ID = '||to_char(USERENV('SESSIONID')));

131: end loop;
132: close get_person_id_debug;
133: end if;
134:
135: --hr_utility.trace('Session ID = '||to_char(USERENV('SESSIONID')));
136: end range_cursor;
137:
138: ---------------------------------- action_creation ----------------------------------
139: procedure action_creation(pactid in number,

Line 250: -- hr_utility.trace_on(null, 'W2REG');

246:
247: l_procedure_name VARCHAR2(100);
248:
249: begin
250: -- hr_utility.trace_on(null, 'W2REG');
251: l_procedure_name := 'action_creation';
252: hr_utility.set_location(l_procedure_name, 1);
253: --
254: -- Query has been added to fetch tax_unit_id, year to be passed to the cursor

Line 252: hr_utility.set_location(l_procedure_name, 1);

248:
249: begin
250: -- hr_utility.trace_on(null, 'W2REG');
251: l_procedure_name := 'action_creation';
252: hr_utility.set_location(l_procedure_name, 1);
253: --
254: -- Query has been added to fetch tax_unit_id, year to be passed to the cursor
255: select pay_yrend_reports_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters),
256: pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),

Line 282: hr_utility.trace('l_assign_set= ' || l_assign_set);

278: ('T_U_ID',ppa1.legislative_parameters) =
279: pay_yrend_reports_pkg.get_parameter
280: ('TRANSFER_GRE',ppa.legislative_parameters);
281:
282: hr_utility.trace('l_assign_set= ' || l_assign_set);
283: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);
284: hr_utility.trace('l_eoy_payroll_action_id=' || l_eoy_payroll_action_id);
285: hr_utility.trace('l_assign_year=' || l_assign_year);
286: hr_utility.trace('pactid=' || pactid);

Line 283: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);

279: pay_yrend_reports_pkg.get_parameter
280: ('TRANSFER_GRE',ppa.legislative_parameters);
281:
282: hr_utility.trace('l_assign_set= ' || l_assign_set);
283: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);
284: hr_utility.trace('l_eoy_payroll_action_id=' || l_eoy_payroll_action_id);
285: hr_utility.trace('l_assign_year=' || l_assign_year);
286: hr_utility.trace('pactid=' || pactid);
287: hr_utility.trace('stperson=' || stperson);

Line 284: hr_utility.trace('l_eoy_payroll_action_id=' || l_eoy_payroll_action_id);

280: ('TRANSFER_GRE',ppa.legislative_parameters);
281:
282: hr_utility.trace('l_assign_set= ' || l_assign_set);
283: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);
284: hr_utility.trace('l_eoy_payroll_action_id=' || l_eoy_payroll_action_id);
285: hr_utility.trace('l_assign_year=' || l_assign_year);
286: hr_utility.trace('pactid=' || pactid);
287: hr_utility.trace('stperson=' || stperson);
288: hr_utility.trace('endperson=' || endperson);

Line 285: hr_utility.trace('l_assign_year=' || l_assign_year);

281:
282: hr_utility.trace('l_assign_set= ' || l_assign_set);
283: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);
284: hr_utility.trace('l_eoy_payroll_action_id=' || l_eoy_payroll_action_id);
285: hr_utility.trace('l_assign_year=' || l_assign_year);
286: hr_utility.trace('pactid=' || pactid);
287: hr_utility.trace('stperson=' || stperson);
288: hr_utility.trace('endperson=' || endperson);
289: hr_utility.set_location(l_procedure_name, 10);

Line 286: hr_utility.trace('pactid=' || pactid);

282: hr_utility.trace('l_assign_set= ' || l_assign_set);
283: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);
284: hr_utility.trace('l_eoy_payroll_action_id=' || l_eoy_payroll_action_id);
285: hr_utility.trace('l_assign_year=' || l_assign_year);
286: hr_utility.trace('pactid=' || pactid);
287: hr_utility.trace('stperson=' || stperson);
288: hr_utility.trace('endperson=' || endperson);
289: hr_utility.set_location(l_procedure_name, 10);
290:

Line 287: hr_utility.trace('stperson=' || stperson);

283: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);
284: hr_utility.trace('l_eoy_payroll_action_id=' || l_eoy_payroll_action_id);
285: hr_utility.trace('l_assign_year=' || l_assign_year);
286: hr_utility.trace('pactid=' || pactid);
287: hr_utility.trace('stperson=' || stperson);
288: hr_utility.trace('endperson=' || endperson);
289: hr_utility.set_location(l_procedure_name, 10);
290:
291: if l_assign_set is not null then

Line 288: hr_utility.trace('endperson=' || endperson);

284: hr_utility.trace('l_eoy_payroll_action_id=' || l_eoy_payroll_action_id);
285: hr_utility.trace('l_assign_year=' || l_assign_year);
286: hr_utility.trace('pactid=' || pactid);
287: hr_utility.trace('stperson=' || stperson);
288: hr_utility.trace('endperson=' || endperson);
289: hr_utility.set_location(l_procedure_name, 10);
290:
291: if l_assign_set is not null then
292: hr_utility.set_location(l_procedure_name, 20);

Line 289: hr_utility.set_location(l_procedure_name, 10);

285: hr_utility.trace('l_assign_year=' || l_assign_year);
286: hr_utility.trace('pactid=' || pactid);
287: hr_utility.trace('stperson=' || stperson);
288: hr_utility.trace('endperson=' || endperson);
289: hr_utility.set_location(l_procedure_name, 10);
290:
291: if l_assign_set is not null then
292: hr_utility.set_location(l_procedure_name, 20);
293: open c_actions_with_asg_set(pactid, stperson, endperson,

Line 292: hr_utility.set_location(l_procedure_name, 20);

288: hr_utility.trace('endperson=' || endperson);
289: hr_utility.set_location(l_procedure_name, 10);
290:
291: if l_assign_set is not null then
292: hr_utility.set_location(l_procedure_name, 20);
293: open c_actions_with_asg_set(pactid, stperson, endperson,
294: l_assign_year, l_tax_unit_id,
295: l_assign_set, l_eoy_payroll_action_id);
296: num := 0;

Line 304: hr_utility.trace('[ ACTION CREATION CODE, ASSIGNMENT SET AS INPUT PARAM ] PERSON ID :' || p_person_id || ' ASSIGNMENT ID :' || assignid );

300: exit when c_actions_with_asg_set%notfound;
301:
302: /* Bug : 10254849 */
303: if g_debug then
304: hr_utility.trace('[ ACTION CREATION CODE, ASSIGNMENT SET AS INPUT PARAM ] PERSON ID :' || p_person_id || ' ASSIGNMENT ID :' || assignid );
305: end if;
306: -- Commenting the IF clause as this condition is already taken care
307: -- in the action_creation cursor.
308: -- if (hr_assignment_set.person_in_set(l_assign_set,p_person_id)='Y') then

Line 318: hr_utility.set_location(l_procedure_name, 30);

314: select pay_assignment_actions_s.nextval
315: into lockingactid
316: from dual;
317:
318: hr_utility.set_location(l_procedure_name, 30);
319: -- insert the action record.
320: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
321:
322: /* update pay_assignment_actions with the year end assignment_actions into serial number

Line 342: hr_utility.set_location(l_procedure_name, 40);

338: --
339: -- BUG2538173
340: --
341: elsif l_state_code is not null then
342: hr_utility.set_location(l_procedure_name, 40);
343: open c_state_context('TAX_UNIT_ID');
344: fetch c_state_context into l_tuid_context;
345: close c_state_context;
346:

Line 351: hr_utility.set_location(l_procedure_name, 50);

347: open c_state_context('JURISDICTION_CODE');
348: fetch c_state_context into l_juri_context;
349: close c_state_context;
350:
351: hr_utility.set_location(l_procedure_name, 50);
352: c_actions_with_state_sql :=
353: 'select act.assignment_action_id,
354: act.assignment_id,
355: act.tax_unit_id,

Line 373: hr_utility.set_location(l_procedure_name, 60);

369: AND paf.effective_end_date >= ''' || l_start_date || '''
370: AND paf.assignment_type = ''E''
371: and to_number(act.serial_number) between ' || stperson || ' and ' ||endperson;
372:
373: hr_utility.set_location(l_procedure_name, 60);
374: if l_locality_code is null then
375: open c_state_ueid('A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD');
376: fetch c_state_ueid into l_subj_whable;
377: close c_state_ueid;

Line 383: hr_utility.set_location(l_procedure_name, 70);

379: open c_state_ueid('A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');
380: fetch c_state_ueid into l_subj_nwhable;
381: close c_state_ueid;
382:
383: hr_utility.set_location(l_procedure_name, 70);
384: c_actions_with_state_sql := c_actions_with_state_sql ||
385: ' AND exists ( select 1 from dual
386: where 1 =
387: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)

Line 407: hr_utility.set_location(l_procedure_name, 80);

403: -- County
404: --
405: elsif length(l_locality_code) = 11 and
406: substr(l_locality_code, 8,4) = '0000' then
407: hr_utility.set_location(l_procedure_name, 80);
408: open c_state_ueid('A_COUNTY_SUBJ_WHABLE_PER_JD_GRE_YTD');
409: fetch c_state_ueid into l_subj_whable;
410: close c_state_ueid;
411:

Line 416: hr_utility.set_location(l_procedure_name, 90);

412: open c_state_ueid('A_COUNTY_SUBJ_NWHABLE_PER_JD_GRE_YTD');
413: fetch c_state_ueid into l_subj_nwhable;
414: close c_state_ueid;
415:
416: hr_utility.set_location(l_procedure_name, 90);
417: c_actions_with_state_sql := c_actions_with_state_sql ||
418: ' AND exists ( select 1 from dual
419: where 1 =
420: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)

Line 439: hr_utility.set_location(l_procedure_name, 100);

435: -- City
436: --
437: elsif length(l_locality_code) = 11 and
438: substr(l_locality_code, 8,4) <> '0000' then
439: hr_utility.set_location(l_procedure_name, 100);
440:
441: open c_state_ueid('A_CITY_SUBJ_WHABLE_PER_JD_GRE_YTD');
442: fetch c_state_ueid into l_subj_whable;
443: close c_state_ueid;

Line 448: hr_utility.trace('l_subj_whable='||l_subj_whable);

444:
445: open c_state_ueid('A_CITY_SUBJ_NWHABLE_PER_JD_GRE_YTD');
446: fetch c_state_ueid into l_subj_nwhable;
447: close c_state_ueid;
448: hr_utility.trace('l_subj_whable='||l_subj_whable);
449: hr_utility.trace('l_subj_nwhable='||l_subj_nwhable);
450:
451: c_actions_with_state_sql := c_actions_with_state_sql ||
452: ' AND exists ( select 1 from dual

Line 449: hr_utility.trace('l_subj_nwhable='||l_subj_nwhable);

445: open c_state_ueid('A_CITY_SUBJ_NWHABLE_PER_JD_GRE_YTD');
446: fetch c_state_ueid into l_subj_nwhable;
447: close c_state_ueid;
448: hr_utility.trace('l_subj_whable='||l_subj_whable);
449: hr_utility.trace('l_subj_nwhable='||l_subj_nwhable);
450:
451: c_actions_with_state_sql := c_actions_with_state_sql ||
452: ' AND exists ( select 1 from dual
453: where 1 =

Line 473: hr_utility.set_location(l_procedure_name, 120);

469: -- School District
470: --
471: elsif length(l_locality_code) = 8 then
472:
473: hr_utility.set_location(l_procedure_name, 120);
474: open c_state_ueid('A_SCHOOL_SUBJ_WHABLE_PER_JD_GRE_YTD');
475: fetch c_state_ueid into l_subj_whable;
476: close c_state_ueid;
477:

Line 500: hr_utility.set_location(l_procedure_name, 150);

496: and fic2.context_id = ' || l_juri_context || '
497: and substr(ltrim(rtrim(fic2.context)),1,8) = ''' || l_locality_code || '''))';
498:
499: end if;
500: hr_utility.set_location(l_procedure_name, 150);
501:
502: num := 0;
503: OPEN c_actions_with_state FOR c_actions_with_state_sql;
504: loop

Line 508: hr_utility.trace('In the c_actions_with_state%found in action cursor');

504: loop
505: fetch c_actions_with_state into lockedactid,assignid,greid,p_person_id;
506: if c_actions_with_state%found then
507: num := num + 1;
508: hr_utility.trace('In the c_actions_with_state%found in action cursor');
509: else
510: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');
511: exit;
512: end if;

Line 510: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');

506: if c_actions_with_state%found then
507: num := num + 1;
508: hr_utility.trace('In the c_actions_with_state%found in action cursor');
509: else
510: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');
511: exit;
512: end if;
513: /* Bug : 10254849 */
514: if g_debug then

Line 515: hr_utility.trace(' [ ACTION CREATION CODE, STATE CODE AS INPUT PARAM ] PERSON ID :' || p_person_id || ' ASSIGNMENT ID:' || assignid);

511: exit;
512: end if;
513: /* Bug : 10254849 */
514: if g_debug then
515: hr_utility.trace(' [ ACTION CREATION CODE, STATE CODE AS INPUT PARAM ] PERSON ID :' || p_person_id || ' ASSIGNMENT ID:' || assignid);
516: end if;
517: hr_utility.set_location(l_procedure_name, 160);
518: select pay_assignment_actions_s.nextval
519: into lockingactid

Line 517: hr_utility.set_location(l_procedure_name, 160);

513: /* Bug : 10254849 */
514: if g_debug then
515: hr_utility.trace(' [ ACTION CREATION CODE, STATE CODE AS INPUT PARAM ] PERSON ID :' || p_person_id || ' ASSIGNMENT ID:' || assignid);
516: end if;
517: hr_utility.set_location(l_procedure_name, 160);
518: select pay_assignment_actions_s.nextval
519: into lockingactid
520: from dual;
521:

Line 533: hr_utility.set_location(l_procedure_name, 170);

529: end loop;
530: close c_actions_with_state;
531: -- end of l_state_code
532: else
533: hr_utility.set_location(l_procedure_name, 170);
534: open c_actions_without_asg_set(pactid, stperson, endperson,
535: l_assign_year, l_tax_unit_id,
536: l_eoy_payroll_action_id,l_effective_date,l_start_date);
537: num := 0;

Line 545: hr_utility.trace(' [ ACTION CREATION CODE, NO SELECTION CRITERIA ] PERSON ID :' || p_person_id || ' ASSIGNMENT ID :' || assignid);

541: exit when c_actions_without_asg_set%notfound;
542:
543: /* Bug : 10254849 */
544: if g_debug then
545: hr_utility.trace(' [ ACTION CREATION CODE, NO SELECTION CRITERIA ] PERSON ID :' || p_person_id || ' ASSIGNMENT ID :' || assignid);
546: end if;
547:
548: -- Commenting the IF clause as this condition is already taken care
549: -- in the action_creation cursor.

Line 556: hr_utility.set_location(l_procedure_name, 180);

552: -- we need to insert one action for each of the
553: -- rows that we return from the cursor (i.e. one
554: -- for each assignment/pre-payment/reversal).
555:
556: hr_utility.set_location(l_procedure_name, 180);
557: select pay_assignment_actions_s.nextval
558: into lockingactid
559: from dual;
560:

Line 581: hr_utility.set_location(l_procedure_name, 250);

577:
578: end loop;
579: close c_actions_without_asg_set;
580: end if;
581: hr_utility.set_location(l_procedure_name, 250);
582: end action_creation;
583:
584: ---------------------------------- sort_action ----------------------------------
585: procedure sort_action

Line 638: hr_utility.trace('Error in Sort Procedure - getting legislative param');

634: from pay_payroll_actions ppa1 /* PYUGEN payroll action id */
635: where ppa1.payroll_action_id = payactid;
636: exception
637: when no_data_found then
638: hr_utility.trace('Error in Sort Procedure - getting legislative param');
639: raise;
640: end;
641: sqlstr := 'select paa1.rowid
642: /* we need the row id of the assignment actions that are

Line 767: hr_utility.set_location(l_proc,0);

763: --
764: begin
765: --
766: if g_debug then
767: hr_utility.set_location(l_proc,0);
768: hr_utility.trace('pay_yrend_report_pkg start deinitialize code');
769: end if;
770: --
771: -- following procedure will be called ordinarily

Line 768: hr_utility.trace('pay_yrend_report_pkg start deinitialize code');

764: begin
765: --
766: if g_debug then
767: hr_utility.set_location(l_proc,0);
768: hr_utility.trace('pay_yrend_report_pkg start deinitialize code');
769: end if;
770: --
771: -- following procedure will be called ordinarily
772: -- without calling directly.

Line 804: hr_utility.trace('pay_yrend_report_pkg delete '||to_char(l_del_cnt)||' records');

800: end loop;
801: close csr_del;
802: --
803: if g_debug then
804: hr_utility.trace('pay_yrend_report_pkg delete '||to_char(l_del_cnt)||' records');
805: end if;
806: --
807: if l_del_cnt > 0 then
808: --

Line 816: hr_utility.set_location(l_proc,1000);

812: --
813: end if;
814: --
815: if g_debug then
816: hr_utility.set_location(l_proc,1000);
817: hr_utility.trace('pay_yrend_report_pkg end deinitialize code');
818: end if;
819: --
820: end deinitialize_code;

Line 817: hr_utility.trace('pay_yrend_report_pkg end deinitialize code');

813: end if;
814: --
815: if g_debug then
816: hr_utility.set_location(l_proc,1000);
817: hr_utility.trace('pay_yrend_report_pkg end deinitialize code');
818: end if;
819: --
820: end deinitialize_code;
821: --