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.PQP_USTIAA_PKG dependencies on HR_UTILITY

Line 22: hr_utility.set_location('Entering : '||l_proc_name, 10);

18: l_payroll_text VARCHAR2(100);
19: l_tax_unit_text VARCHAR2(100);
20:
21: BEGIN
22: hr_utility.set_location('Entering : '||l_proc_name, 10);
23: SELECT ppa.legislative_parameters,
24: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
25: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
26: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)

Line 33: hr_utility.set_location('..Parameters are :'||leg_param,15);

29: l_payroll_id,
30: l_tax_unit_id
31: FROM pay_payroll_actions ppa
32: WHERE ppa.payroll_action_id = pactid;
33: hr_utility.set_location('..Parameters are :'||leg_param,15);
34:
35: -- For Bug 5636004 Performance Improvement.
36:
37: IF l_consolidation_set_id is not null THEN

Line 74: hr_utility.set_location('Leaving : '||l_proc_name, 90);

70: and ppa_run.effective_date between asg.effective_start_date
71: and asg.effective_end_date
72: and asg.business_group_id = ppa_gen.business_group_id
73: order by asg.person_id';
74: hr_utility.set_location('Leaving : '||l_proc_name, 90);
75: EXCEPTION
76: WHEN OTHERS THEN
77: sqlstr := NULL;
78: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);

Line 78: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);

74: hr_utility.set_location('Leaving : '||l_proc_name, 90);
75: EXCEPTION
76: WHEN OTHERS THEN
77: sqlstr := NULL;
78: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
79: hr_utility.set_location('Leaving : '||l_proc_name, 150);
80: RAISE;
81: END range_cursor;
82:

Line 79: hr_utility.set_location('Leaving : '||l_proc_name, 150);

75: EXCEPTION
76: WHEN OTHERS THEN
77: sqlstr := NULL;
78: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
79: hr_utility.set_location('Leaving : '||l_proc_name, 150);
80: RAISE;
81: END range_cursor;
82:
83: -- ---------------------------------------------------------------------

Line 164: hr_utility.set_location('Entering : '||l_proc_name, 10);

160: l_payments_bal NUMBER;
161: l_gross_defined_balance_id NUMBER;
162: l_payments_defined_balance_id NUMBER;
163: BEGIN
164: hr_utility.set_location('Entering : '||l_proc_name, 10);
165: OPEN c_parameters(pactid);
166: FETCH c_parameters INTO leg_param,
167: l_consolidation_set_id,
168: l_payroll_id,

Line 171: hr_utility.set_location('..Parameters are :'||leg_param, 15);

167: l_consolidation_set_id,
168: l_payroll_id,
169: l_tax_unit_id;
170: CLOSE c_parameters;
171: hr_utility.set_location('..Parameters are :'||leg_param, 15);
172: BEGIN
173: OPEN c_defbal;
174: LOOP
175: FETCH c_defbal INTO l_defbal;

Line 190: hr_utility.trace('Error getting defined balance id');

186: l_payments_defined_balance_id IS NULL THEN
187: RAISE no_userid;
188: END IF;
189: EXCEPTION WHEN no_userid THEN
190: hr_utility.trace('Error getting defined balance id');
191: RAISE;
192: END;
193: --
194: -- Open the Assignment Action Creation Cursor

Line 196: hr_utility.set_location('..Opening the Assignment Action Creation Cursor', 20);

192: END;
193: --
194: -- Open the Assignment Action Creation Cursor
195: --
196: hr_utility.set_location('..Opening the Assignment Action Creation Cursor', 20);
197: OPEN c_actions(pactid,stperson,endperson);
198: num := 0;
199: LOOP
200: FETCH c_actions INTO action_type,lockedactid,assignid,greid;

Line 235: hr_utility.set_location('Leaving : '||l_proc_name, 90);

231: */
232:
233: END LOOP;
234: CLOSE c_actions;
235: hr_utility.set_location('Leaving : '||l_proc_name, 90);
236: EXCEPTION
237: WHEN OTHERS THEN
238: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
239: hr_utility.set_location('Leaving : '||l_proc_name, 150);

Line 238: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);

234: CLOSE c_actions;
235: hr_utility.set_location('Leaving : '||l_proc_name, 90);
236: EXCEPTION
237: WHEN OTHERS THEN
238: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
239: hr_utility.set_location('Leaving : '||l_proc_name, 150);
240: RAISE;
241: END action_creation;
242:

Line 239: hr_utility.set_location('Leaving : '||l_proc_name, 150);

235: hr_utility.set_location('Leaving : '||l_proc_name, 90);
236: EXCEPTION
237: WHEN OTHERS THEN
238: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
239: hr_utility.set_location('Leaving : '||l_proc_name, 150);
240: RAISE;
241: END action_creation;
242:
243: -- ---------------------------------------------------------------------

Line 253: hr_utility.set_location('Entering : '||l_proc_name, 10);

249: len OUT NOCOPY NUMBER
250: ) IS
251: l_proc_name VARCHAR2(150) := g_proc_name ||'sort_action';
252: BEGIN
253: hr_utility.set_location('Entering : '||l_proc_name, 10);
254: sqlstr := 'select paa1.rowid
255: from pay_assignment_actions paa1,
256: pay_payroll_actions ppa1
257: where ppa1.payroll_action_id = :pactid

Line 263: hr_utility.set_location('Leaving : '||l_proc_name, 90);

259: order by paa1.assignment_id,paa1.assignment_action_id
260: for update of paa1.assignment_id';
261:
262: len := LENGTH(sqlstr);
263: hr_utility.set_location('Leaving : '||l_proc_name, 90);
264: EXCEPTION
265: WHEN OTHERS THEN
266: sqlstr := NULL;
267: len := NULL;

Line 268: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);

264: EXCEPTION
265: WHEN OTHERS THEN
266: sqlstr := NULL;
267: len := NULL;
268: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
269: hr_utility.set_location('Leaving : '||l_proc_name, 150);
270: RAISE;
271: END sort_action;
272:

Line 269: hr_utility.set_location('Leaving : '||l_proc_name, 150);

265: WHEN OTHERS THEN
266: sqlstr := NULL;
267: len := NULL;
268: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
269: hr_utility.set_location('Leaving : '||l_proc_name, 150);
270: RAISE;
271: END sort_action;
272:
273: -- ---------------------------------------------------------------------

Line 389: hr_utility.set_location('Entering : '||l_proc_name, 10);

385: l_payments_bal NUMBER;
386: l_gross_defined_balance_id NUMBER;
387: l_payments_defined_balance_id NUMBER;
388: BEGIN
389: hr_utility.set_location('Entering : '||l_proc_name, 10);
390:
391: OPEN c_parameters(pactid);
392: FETCH c_parameters INTO leg_param,
393: l_consolidation_set_id,

Line 397: hr_utility.set_location('..Parameters are :'||leg_param, 15);

393: l_consolidation_set_id,
394: l_payroll_id,
395: l_tax_unit_id;
396: CLOSE c_parameters;
397: hr_utility.set_location('..Parameters are :'||leg_param, 15);
398: BEGIN
399: OPEN c_defbal;
400: LOOP
401: FETCH c_defbal INTO l_defbal;

Line 416: hr_utility.trace('Error getting defined balance id');

412: l_payments_defined_balance_id IS NULL THEN
413: RAISE no_userid;
414: END IF;
415: EXCEPTION WHEN no_userid THEN
416: hr_utility.trace('Error getting defined balance id');
417: RAISE;
418: END;
419: --
420: -- Open the Assignment Action Creation Cursor

Line 422: hr_utility.set_location('..Opening the Assignment Action Creation Cursor', 20);

418: END;
419: --
420: -- Open the Assignment Action Creation Cursor
421: --
422: hr_utility.set_location('..Opening the Assignment Action Creation Cursor', 20);
423: OPEN c_actions_ops(pactid,stperson,endperson);
424: LOOP
425: FETCH c_actions_ops INTO lockedactid,assignid;
426: IF c_actions_ops%FOUND THEN

Line 442: hr_utility.set_location('Leaving : '||l_proc_name, 90);

438: EXIT WHEN c_actions_ops%NOTFOUND;
439:
440: END LOOP;
441: CLOSE c_actions_ops;
442: hr_utility.set_location('Leaving : '||l_proc_name, 90);
443: -- hr_utility.trace_on(null, 'TIAA');
444: EXCEPTION
445: WHEN OTHERS THEN
446: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);

Line 443: -- hr_utility.trace_on(null, 'TIAA');

439:
440: END LOOP;
441: CLOSE c_actions_ops;
442: hr_utility.set_location('Leaving : '||l_proc_name, 90);
443: -- hr_utility.trace_on(null, 'TIAA');
444: EXCEPTION
445: WHEN OTHERS THEN
446: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
447: hr_utility.set_location('Leaving : '||l_proc_name, 150);

Line 446: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);

442: hr_utility.set_location('Leaving : '||l_proc_name, 90);
443: -- hr_utility.trace_on(null, 'TIAA');
444: EXCEPTION
445: WHEN OTHERS THEN
446: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
447: hr_utility.set_location('Leaving : '||l_proc_name, 150);
448: RAISE;
449: END action_creation_ops;
450:

Line 447: hr_utility.set_location('Leaving : '||l_proc_name, 150);

443: -- hr_utility.trace_on(null, 'TIAA');
444: EXCEPTION
445: WHEN OTHERS THEN
446: hr_utility.set_location('..Error in '||l_proc_name||' : '||SQLERRM,150);
447: hr_utility.set_location('Leaving : '||l_proc_name, 150);
448: RAISE;
449: END action_creation_ops;
450:
451: -- ----------------------------------------------------------------------------

Line 472: hr_utility.set_location('Entering : '||l_proc_name, 10);

468: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.get_amount';
469:
470: BEGIN
471:
472: hr_utility.set_location('Entering : '||l_proc_name, 10);
473:
474: OPEN csr_def_bal_id;
475: fetch csr_def_bal_id INTO l_def_bal_id;
476: CLOSE csr_def_bal_id;

Line 478: --hr_utility.set_location('l_def_bal_id : '||l_def_bal_id, 12);-

474: OPEN csr_def_bal_id;
475: fetch csr_def_bal_id INTO l_def_bal_id;
476: CLOSE csr_def_bal_id;
477:
478: --hr_utility.set_location('l_def_bal_id : '||l_def_bal_id, 12);-
479: --hr_utility.set_location('p_bal_type_id : '||p_bal_type_id, 14);
480: --hr_utility.set_location('p_assactid : '||p_assactid, 16);
481:
482: IF l_def_bal_id is not null THEN

Line 479: --hr_utility.set_location('p_bal_type_id : '||p_bal_type_id, 14);

475: fetch csr_def_bal_id INTO l_def_bal_id;
476: CLOSE csr_def_bal_id;
477:
478: --hr_utility.set_location('l_def_bal_id : '||l_def_bal_id, 12);-
479: --hr_utility.set_location('p_bal_type_id : '||p_bal_type_id, 14);
480: --hr_utility.set_location('p_assactid : '||p_assactid, 16);
481:
482: IF l_def_bal_id is not null THEN
483: l_value := pay_balance_pkg.get_value

Line 480: --hr_utility.set_location('p_assactid : '||p_assactid, 16);

476: CLOSE csr_def_bal_id;
477:
478: --hr_utility.set_location('l_def_bal_id : '||l_def_bal_id, 12);-
479: --hr_utility.set_location('p_bal_type_id : '||p_bal_type_id, 14);
480: --hr_utility.set_location('p_assactid : '||p_assactid, 16);
481:
482: IF l_def_bal_id is not null THEN
483: l_value := pay_balance_pkg.get_value
484: (p_defined_balance_id => l_def_bal_id,

Line 490: hr_utility.set_location('Leaving : '||l_proc_name, 20);

486: END IF;
487:
488: RETURN(l_value);
489:
490: hr_utility.set_location('Leaving : '||l_proc_name, 20);
491:
492: END get_amount;
493:
494: -- ------------------------------------------------------------------------------

Line 577: hr_utility.set_location('Entering : '||l_proc_name, 10);

573: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.chk_cont_type_override';
574: l_sub_plan varchar2(5);
575: l_source varchar2(2);
576: BEGIN
577: hr_utility.set_location('Entering : '||l_proc_name, 10);
578:
579: OPEN csr_asg_info;
580: FETCH csr_asg_info INTO l_source, l_sub_plan;
581: IF csr_asg_info%found THEN

Line 591: hr_utility.set_location('Leaving : '||l_proc_name, 20);

587: end if;
588: END IF;
589: CLOSE csr_asg_info;
590:
591: hr_utility.set_location('Leaving : '||l_proc_name, 20);
592:
593: END chk_cont_type_override;
594:
595: -- -------------------------------------------------------------------

Line 653: hr_utility.set_location('Entering : '||l_proc_name, 10);

649: l_proc_name varchar2(100) := 'pqp_ustiaa_pkg.load_xml';
650: l_data varchar2(500);
651: BEGIN
652:
653: hr_utility.set_location('Entering : '||l_proc_name, 10);
654:
655: IF p_node_type = 'CS' THEN
656: pay_core_files.write_to_magtape_lob('<'||p_node||'>');
657: ELSIF p_node_type = 'CE' THEN

Line 669: hr_utility.set_location('Leaving : '||l_proc_name, 20);

665: l_data := REPLACE (l_data, '"', '"');
666: pay_core_files.write_to_magtape_lob('<'||p_node||'>'||l_data||'');
667: END IF;
668:
669: hr_utility.set_location('Leaving : '||l_proc_name, 20);
670:
671: END LOAD_XML;
672:
673: -- ---------------------------------------------------------------------

Line 694: hr_utility.set_location('Entering : '||l_proc_name, 10);

690: l_end_date date;
691: l_bg_name per_business_groups.name%TYPE;
692:
693: BEGIN
694: hr_utility.set_location('Entering : '||l_proc_name, 10);
695:
696: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
697: IF (l_payroll_action_id is null) THEN
698: l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

Line 700: -- hr_utility.set_location('l_payroll_action_id : '||l_payroll_action_id, 15);

696: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
697: IF (l_payroll_action_id is null) THEN
698: l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
699: END IF;
700: -- hr_utility.set_location('l_payroll_action_id : '||l_payroll_action_id, 15);
701:
702: OPEN csr_rpt_data(l_payroll_action_id);
703: FETCH csr_rpt_data INTO
704: l_start_date,

Line 714: -- hr_utility.set_location('l_bg_name : '||l_bg_name, 15);

710: load_xml('D','BG_NAME',l_bg_name);
711: load_xml('D','RPT_START_DATE',l_start_date);
712: load_xml('D','RPT_END_DATE',l_end_date);
713:
714: -- hr_utility.set_location('l_bg_name : '||l_bg_name, 15);
715:
716: hr_utility.set_location('Leaving : '||l_proc_name, 20);
717:
718:

Line 716: hr_utility.set_location('Leaving : '||l_proc_name, 20);

712: load_xml('D','RPT_END_DATE',l_end_date);
713:
714: -- hr_utility.set_location('l_bg_name : '||l_bg_name, 15);
715:
716: hr_utility.set_location('Leaving : '||l_proc_name, 20);
717:
718:
719: END generate_header_xml;
720:

Line 728: hr_utility.set_location('Entering : '||l_proc_name, 10);

724: PROCEDURE generate_footer_xml is
725: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.generate_footer_xml';
726: BEGIN
727:
728: hr_utility.set_location('Entering : '||l_proc_name, 10);
729:
730: load_xml('CE','US_TIAA_CREF','');
731:
732: hr_utility.set_location('Leaving : '||l_proc_name, 20);

Line 732: hr_utility.set_location('Leaving : '||l_proc_name, 20);

728: hr_utility.set_location('Entering : '||l_proc_name, 10);
729:
730: load_xml('CE','US_TIAA_CREF','');
731:
732: hr_utility.set_location('Leaving : '||l_proc_name, 20);
733:
734: END generate_footer_xml;
735:
736: -- ---------------------------------------------------------------------