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

Line 35: hr_utility.trace('Reached range_cursor');

31: lv_legislative_param varchar2(240);
32: begin
33:
34:
35: hr_utility.trace('Reached range_cursor');
36: hr_utility.trace('PACTID = '||to_char(pactid));
37:
38: select legislative_parameters
39: into lv_legislative_param

Line 36: hr_utility.trace('PACTID = '||to_char(pactid));

32: begin
33:
34:
35: hr_utility.trace('Reached range_cursor');
36: hr_utility.trace('PACTID = '||to_char(pactid));
37:
38: select legislative_parameters
39: into lv_legislative_param
40: from pay_payroll_actions

Line 59: hr_utility.trace(sqlstr);

55: AND ASG.business_group_id + 0 = PPA.business_group_id
56: AND ASG.payroll_id is not null
57: ORDER BY ASG.person_id';
58:
59: hr_utility.trace(sqlstr);
60:
61: exception when others then
62: hr_utility.trace('Error in range_cursor - '||to_char(sqlcode) || '-' || sqlerrm);
63:

Line 62: hr_utility.trace('Error in range_cursor - '||to_char(sqlcode) || '-' || sqlerrm);

58:
59: hr_utility.trace(sqlstr);
60:
61: exception when others then
62: hr_utility.trace('Error in range_cursor - '||to_char(sqlcode) || '-' || sqlerrm);
63:
64: end range_cursor;
65:
66: ---------------------------------- action_creation ----------------------------------

Line 185: hr_utility.trace('Entering action_creation');

181: l_action NUMBER;
182: l_step number;
183:
184: begin
185: hr_utility.trace('Entering action_creation');
186:
187: l_step := 1;
188: select effective_date,
189: pay_us_payroll_utils.get_parameter(

Line 199: hr_utility.trace('year start '|| to_char(l_year_start,'dd-mm-yyyy'));

195: where payroll_action_id = pactid;
196:
197: l_year_start := trunc(g_effective_date, 'Y');
198: l_year_end := add_months(trunc(g_effective_date, 'Y'),12) -1;
199: hr_utility.trace('year start '|| to_char(l_year_start,'dd-mm-yyyy'));
200: hr_utility.trace('year end '|| to_char(l_year_end,'dd-mm-yyyy'));
201:
202: lv_range_person_on := pay_ac_utility.range_person_on(
203: p_report_type => 'YREND_YEMA'

Line 200: hr_utility.trace('year end '|| to_char(l_year_end,'dd-mm-yyyy'));

196:
197: l_year_start := trunc(g_effective_date, 'Y');
198: l_year_end := add_months(trunc(g_effective_date, 'Y'),12) -1;
199: hr_utility.trace('year start '|| to_char(l_year_start,'dd-mm-yyyy'));
200: hr_utility.trace('year end '|| to_char(l_year_end,'dd-mm-yyyy'));
201:
202: lv_range_person_on := pay_ac_utility.range_person_on(
203: p_report_type => 'YREND_YEMA'
204: ,p_report_format => 'YEMA_ARCH'

Line 210: hr_utility.trace ('Person ranges are ON');

206: ,p_report_category => 'RT');
207:
208: l_step := 2;
209: IF lv_range_person_on THEN
210: hr_utility.trace ('Person ranges are ON');
211: OPEN c_actions_range_person(l_year_start,
212: l_year_end,
213: g_tax_unit_id,
214: stperson,

Line 217: hr_utility.trace ('Person ranges are OFF');

213: g_tax_unit_id,
214: stperson,
215: endperson);
216: ELSE
217: hr_utility.trace ('Person ranges are OFF');
218: OPEN c_actions(
219: l_year_start,
220: l_year_end,
221: g_tax_unit_id,

Line 235: hr_utility.trace('assignid = ' || assignid);

231: EXIT WHEN c_actions_range_person%NOTFOUND;
232: ELSE
233: FETCH c_actions INTO assignid,lockedactid;
234: EXIT WHEn c_actions%NOTFOUND;
235: hr_utility.trace('assignid = ' || assignid);
236: hr_utility.trace('lockedactid = ' || lockedactid);
237: END IF;
238:
239: select pay_assignment_actions_s.nextval

Line 236: hr_utility.trace('lockedactid = ' || lockedactid);

232: ELSE
233: FETCH c_actions INTO assignid,lockedactid;
234: EXIT WHEn c_actions%NOTFOUND;
235: hr_utility.trace('assignid = ' || assignid);
236: hr_utility.trace('lockedactid = ' || lockedactid);
237: END IF;
238:
239: select pay_assignment_actions_s.nextval
240: into lockingactid

Line 251: hr_utility.trace('inserted into temp object actions - ' || lockingactid);

247: pactid =>pactid,
248: chunk =>chunk,
249: greid =>g_tax_unit_id);
250:
251: hr_utility.trace('inserted into temp object actions - ' || lockingactid);
252:
253: end loop;
254:
255: if lv_range_person_on then

Line 261: hr_utility.trace('leaving action_creation');

257: else
258: close c_actions;
259: end if;
260:
261: hr_utility.trace('leaving action_creation');
262: exception
263: when others then
264: raise_application_error(-20001,'Error in action_creation in Step ' || l_step);
265: end action_creation;

Line 312: hr_utility.trace('entering archive_init');

308: l_step number;
309:
310: begin
311: --
312: hr_utility.trace('entering archive_init');
313: --
314: g_payroll_action_id := p_payroll_action_id;
315: --
316: /* l_count := 0;

Line 353: hr_utility.trace('g_run_balance_status = '||g_run_balance_status);

349: l_business_group_id,
350: l_bal_attribute_name,
351: l_leg_code);
352:
353: hr_utility.trace('g_run_balance_status = '||g_run_balance_status);
354:
355: l_count := l_count + 1;
356:
357: end loop;

Line 361: hr_utility.trace('leaving archive_init');

357: end loop;
358: close c_get_bal_attributes;
359: l_step := 5;
360:
361: hr_utility.trace('leaving archive_init');
362:
363: exception when no_data_found then
364: raise_application_error(-20001,'In Archive_Init No Data Found In Step '|| l_step);
365: */

Line 448: hr_utility.trace('entering archive_code');

444: l_step number;
445:
446: begin
447:
448: hr_utility.trace('entering archive_code');
449:
450: l_step := 1;
451:
452: SELECT aa.object_id,

Line 461: hr_utility.trace('l_asgid = ' || l_asgid);

457: l_payroll_action_id
458: FROM pay_temp_object_actions aa
459: WHERE aa.object_action_id = p_assignment_action_id;
460:
461: hr_utility.trace('l_asgid = ' || l_asgid);
462: hr_utility.trace('l_chunk = ' || l_chunk);
463: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);
464: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
465:

Line 462: hr_utility.trace('l_chunk = ' || l_chunk);

458: FROM pay_temp_object_actions aa
459: WHERE aa.object_action_id = p_assignment_action_id;
460:
461: hr_utility.trace('l_asgid = ' || l_asgid);
462: hr_utility.trace('l_chunk = ' || l_chunk);
463: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);
464: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
465:
466: open c_get_session_id;

Line 463: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);

459: WHERE aa.object_action_id = p_assignment_action_id;
460:
461: hr_utility.trace('l_asgid = ' || l_asgid);
462: hr_utility.trace('l_chunk = ' || l_chunk);
463: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);
464: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
465:
466: open c_get_session_id;
467: fetch c_get_session_id into g_session_id;

Line 464: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);

460:
461: hr_utility.trace('l_asgid = ' || l_asgid);
462: hr_utility.trace('l_chunk = ' || l_chunk);
463: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);
464: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
465:
466: open c_get_session_id;
467: fetch c_get_session_id into g_session_id;
468: hr_utility.trace('lv_session_id = '|| lv_session_id);

Line 468: hr_utility.trace('lv_session_id = '|| lv_session_id);

464: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
465:
466: open c_get_session_id;
467: fetch c_get_session_id into g_session_id;
468: hr_utility.trace('lv_session_id = '|| lv_session_id);
469: close c_get_session_id;
470: g_run_balance_status := 'N';
471:
472: if g_run_balance_status = 'Y' then

Line 491: hr_utility.trace('opened c_non_zero_run_result');

487: close c_non_zero_run_balance;
488: end if;
489: end loop;
490: else -- Run Balance Status is 'N'
491: hr_utility.trace('opened c_non_zero_run_result');
492: hr_utility.trace('l_asgid = '|| l_asgid);
493: hr_utility.trace('g_effective_date = '||trunc(g_effective_date,'Y'));
494: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
495:

Line 492: hr_utility.trace('l_asgid = '|| l_asgid);

488: end if;
489: end loop;
490: else -- Run Balance Status is 'N'
491: hr_utility.trace('opened c_non_zero_run_result');
492: hr_utility.trace('l_asgid = '|| l_asgid);
493: hr_utility.trace('g_effective_date = '||trunc(g_effective_date,'Y'));
494: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
495:
496: l_step := 4;

Line 493: hr_utility.trace('g_effective_date = '||trunc(g_effective_date,'Y'));

489: end loop;
490: else -- Run Balance Status is 'N'
491: hr_utility.trace('opened c_non_zero_run_result');
492: hr_utility.trace('l_asgid = '|| l_asgid);
493: hr_utility.trace('g_effective_date = '||trunc(g_effective_date,'Y'));
494: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
495:
496: l_step := 4;
497: OPEN c_non_zero_run_result(l_asgid,

Line 494: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);

490: else -- Run Balance Status is 'N'
491: hr_utility.trace('opened c_non_zero_run_result');
492: hr_utility.trace('l_asgid = '|| l_asgid);
493: hr_utility.trace('g_effective_date = '||trunc(g_effective_date,'Y'));
494: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
495:
496: l_step := 4;
497: OPEN c_non_zero_run_result(l_asgid,
498: trunc(g_effective_date,'Y'),

Line 501: hr_utility.trace('lv_result_value = '||lv_result_value);

497: OPEN c_non_zero_run_result(l_asgid,
498: trunc(g_effective_date,'Y'),
499: g_tax_unit_id);
500: FETCH c_non_zero_run_result into lv_result_value;
501: hr_utility.trace('lv_result_value = '||lv_result_value);
502: CLOSE c_non_zero_run_result;
503:
504: end if;
505:

Line 529: hr_utility.trace('assignment_id = ' || l_asgid);

525:
526:
527:
528:
529: hr_utility.trace('assignment_id = ' || l_asgid);
530: end if;
531:
532: hr_utility.trace('leaving archive_code');
533:

Line 532: hr_utility.trace('leaving archive_code');

528:
529: hr_utility.trace('assignment_id = ' || l_asgid);
530: end if;
531:
532: hr_utility.trace('leaving archive_code');
533:
534: exception
535: when others then
536: raise_application_error(-20001,'Error in archive_code in Step ' || l_step);

Line 555: hr_utility.trace('entering archive_deinit');

551: g_tax_unit_id
552: from pay_payroll_actions
553: where payroll_action_id = p_payroll_action_id;
554: --
555: hr_utility.trace('entering archive_deinit');
556: --
557: pay_us_yepp_miss_assign_pkg.select_employee(p_payroll_action_id,
558: g_effective_date,
559: g_tax_unit_id,

Line 568: hr_utility.trace('leaving archive_deinit');

564: DELETE FROM pay_us_rpt_totals
565: WHERE attribute1='YEAR END MISSING ASSIGNMENTS'
566: AND location_id = p_payroll_action_id;
567: --
568: hr_utility.trace('leaving archive_deinit');
569: end ARCHIVE_DEINIT;
570:
571: --begin
572: --hr_utility.trace_on(null,'YREND_YEMA');

Line 572: --hr_utility.trace_on(null,'YREND_YEMA');

568: hr_utility.trace('leaving archive_deinit');
569: end ARCHIVE_DEINIT;
570:
571: --begin
572: --hr_utility.trace_on(null,'YREND_YEMA');
573: end pay_archive_missing_asg_pkg;
574: