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

Line 134: 18-jun-1999 achauhan 115.4 replaced dbms-output with hr_utility.trace

130: payroll is not specified.
131: 24-JUN-1999 mcpham 115.5 Modified c_actions cursor, added
132: c_get_locked_action cursor and some
133: codes in prodedure action_creation.
134: 18-jun-1999 achauhan 115.4 replaced dbms-output with hr_utility.trace
135: 18-MAR-1999 kkawol 110.1 Added get_parameter.
136: 05-JAN-1999 kkawol 110.0 Created
137: */
138: ----------------------------------- range_cursor ----------------------------------

Line 359: --hr_utility.trace_on(null, 'DAR');

355: ln_master_action_id NUMBER;
356:
357: BEGIN
358:
359: --hr_utility.trace_on(null, 'DAR');
360: hr_utility.set_location('procdar',1);
361:
362: -- Database Version --Bug 3331028
363: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then

Line 360: hr_utility.set_location('procdar',1);

356:
357: BEGIN
358:
359: --hr_utility.trace_on(null, 'DAR');
360: hr_utility.set_location('procdar',1);
361:
362: -- Database Version --Bug 3331028
363: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
364: l_db_version := '/*+ RULE */';

Line 440: hr_utility.set_location('procdar',2);

436: -- Reference cursor opened for the query string l_paid_actions --Bug 3331028
437: open c_paid_actions for l_paid_actions using pactid, stperson, endperson;
438: --
439: loop
440: hr_utility.set_location('procdar',2);
441: fetch c_paid_actions into ln_nacha_action_id, ln_assignment_id,
442: ln_tax_unit_id, ld_effective_date;
443: exit WHEN c_paid_actions%NOTFOUND;
444: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'

Line 444: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'

440: hr_utility.set_location('procdar',2);
441: fetch c_paid_actions into ln_nacha_action_id, ln_assignment_id,
442: ln_tax_unit_id, ld_effective_date;
443: exit WHEN c_paid_actions%NOTFOUND;
444: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
445: ||to_char(ln_nacha_action_id));
446: open c_pre_payments (ln_nacha_action_id);
447: fetch c_pre_payments into ln_pre_pymt_action_id;
448: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'

Line 448: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'

444: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
445: ||to_char(ln_nacha_action_id));
446: open c_pre_payments (ln_nacha_action_id);
447: fetch c_pre_payments into ln_pre_pymt_action_id;
448: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'
449: ||to_char(ln_pre_pymt_action_id));
450: close c_pre_payments;
451:
452: /**************************************************************************

Line 456: hr_utility.trace(' ln_prev_pre_pymt_action_id is'

452: /**************************************************************************
453: ** we need to insert atleast one action for each of the rows that we
454: ** return from the cursor (i.e. one for each assignment/pre-payment action).
455: **************************************************************************/
456: hr_utility.trace(' ln_prev_pre_pymt_action_id is'
457: ||to_char(ln_prev_pre_pymt_action_id));
458: if (ln_prev_pre_pymt_action_id is null or
459: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
460: open c_payments (ln_pre_pymt_action_id, ld_effective_date);

Line 462: hr_utility.set_location('procdar',99);

458: if (ln_prev_pre_pymt_action_id is null or
459: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
460: open c_payments (ln_pre_pymt_action_id, ld_effective_date);
461: loop
462: hr_utility.set_location('procdar',99);
463: fetch c_payments into ln_source_action_id;
464: hr_utility.trace(' ln_source_action_id is'
465: ||to_char(ln_source_action_id));
466:

Line 464: hr_utility.trace(' ln_source_action_id is'

460: open c_payments (ln_pre_pymt_action_id, ld_effective_date);
461: loop
462: hr_utility.set_location('procdar',99);
463: fetch c_payments into ln_source_action_id;
464: hr_utility.trace(' ln_source_action_id is'
465: ||to_char(ln_source_action_id));
466:
467: hr_utility.set_location('procdar',98);
468: if c_payments%notfound then

Line 467: hr_utility.set_location('procdar',98);

463: fetch c_payments into ln_source_action_id;
464: hr_utility.trace(' ln_source_action_id is'
465: ||to_char(ln_source_action_id));
466:
467: hr_utility.set_location('procdar',98);
468: if c_payments%notfound then
469: exit;
470: end if;
471: hr_utility.set_location('procdar',97);

Line 471: hr_utility.set_location('procdar',97);

467: hr_utility.set_location('procdar',98);
468: if c_payments%notfound then
469: exit;
470: end if;
471: hr_utility.set_location('procdar',97);
472:
473: /**************************************************************
474: ** we need to insert one action for each of the rows that we
475: ** return from the cursor (i.e. one for each assignment/pre-payment source).

Line 477: hr_utility.trace(' ln_prev_source_action_id is'

473: /**************************************************************
474: ** we need to insert one action for each of the rows that we
475: ** return from the cursor (i.e. one for each assignment/pre-payment source).
476: **************************************************************/
477: hr_utility.trace(' ln_prev_source_action_id is'
478: ||to_char(ln_prev_source_action_id));
479: if (ln_prev_source_action_id is null or
480: ln_source_action_id <> ln_prev_source_action_id or
481: ln_source_action_id is null) then

Line 483: hr_utility.set_location('procdar',3);

479: if (ln_prev_source_action_id is null or
480: ln_source_action_id <> ln_prev_source_action_id or
481: ln_source_action_id is null) then
482:
483: hr_utility.set_location('procdar',3);
484: select pay_assignment_actions_s.nextval
485: into ln_deposit_action_id
486: from dual;
487:

Line 492: hr_utility.trace('Inserted into paa');

488: -- insert the action record.
489: hr_nonrun_asact.insact(ln_deposit_action_id,
490: ln_assignment_id,
491: pactid, chunk, ln_tax_unit_id);
492: hr_utility.trace('Inserted into paa');
493: -- insert an interlock to this action.
494: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
495:
496: hr_utility.trace('Inserted into interlock');

Line 496: hr_utility.trace('Inserted into interlock');

492: hr_utility.trace('Inserted into paa');
493: -- insert an interlock to this action.
494: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
495:
496: hr_utility.trace('Inserted into interlock');
497: if ln_source_action_id is not null then
498: hr_utility.trace('serial number updated if loop ');
499: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
500: update pay_assignment_Actions

Line 498: hr_utility.trace('serial number updated if loop ');

494: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
495:
496: hr_utility.trace('Inserted into interlock');
497: if ln_source_action_id is not null then
498: hr_utility.trace('serial number updated if loop ');
499: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
500: update pay_assignment_Actions
501: set serial_number = 'P'||ln_source_action_id
502: --set serial_number = ln_source_action_id

Line 499: hr_utility.trace('serial number is '||to_char(ln_source_action_id));

495:
496: hr_utility.trace('Inserted into interlock');
497: if ln_source_action_id is not null then
498: hr_utility.trace('serial number updated if loop ');
499: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
500: update pay_assignment_Actions
501: set serial_number = 'P'||ln_source_action_id
502: --set serial_number = ln_source_action_id
503: where assignment_action_id = ln_deposit_action_id;

Line 505: hr_utility.trace('serial number else ');

501: set serial_number = 'P'||ln_source_action_id
502: --set serial_number = ln_source_action_id
503: where assignment_action_id = ln_deposit_action_id;
504: else
505: hr_utility.trace('serial number else ');
506: open c_payroll_run (ln_pre_pymt_action_id);
507: fetch c_payroll_run into ln_master_action_id;
508: close c_payroll_run;
509: hr_utility.trace(' ln_master_action_id is'

Line 509: hr_utility.trace(' ln_master_action_id is'

505: hr_utility.trace('serial number else ');
506: open c_payroll_run (ln_pre_pymt_action_id);
507: fetch c_payroll_run into ln_master_action_id;
508: close c_payroll_run;
509: hr_utility.trace(' ln_master_action_id is'
510: ||to_char(ln_master_action_id));
511:
512: update pay_assignment_Actions
513: set serial_number = 'M'||ln_master_action_id

Line 529: hr_utility.set_location('procdar',4);

525: end if;
526: end loop;
527: close c_paid_actions;
528:
529: hr_utility.set_location('procdar',4);
530: ln_prev_pre_pymt_action_id := null;
531: open c_actions_zero_pay(pactid,stperson,endperson);
532:
533: loop

Line 534: hr_utility.set_location('procdar',5);

530: ln_prev_pre_pymt_action_id := null;
531: open c_actions_zero_pay(pactid,stperson,endperson);
532:
533: loop
534: hr_utility.set_location('procdar',5);
535: fetch c_actions_zero_pay INTO ln_nacha_action_id, --gives P,U
536: ln_assignment_id,
537: ln_tax_unit_id;
538: exit WHEN c_actions_zero_pay%NOTFOUND;

Line 539: hr_utility.trace(' NZ PrePayment Id is' ||to_char(ln_nacha_action_id));

535: fetch c_actions_zero_pay INTO ln_nacha_action_id, --gives P,U
536: ln_assignment_id,
537: ln_tax_unit_id;
538: exit WHEN c_actions_zero_pay%NOTFOUND;
539: hr_utility.trace(' NZ PrePayment Id is' ||to_char(ln_nacha_action_id));
540:
541: open c_pre_payments (ln_nacha_action_id); --gives me R,Q
542: fetch c_pre_payments into ln_pre_pymt_action_id;
543: close c_pre_payments;

Line 545: hr_utility.trace(' NZ Run ActionId is' ||to_char(ln_pre_pymt_action_id));

541: open c_pre_payments (ln_nacha_action_id); --gives me R,Q
542: fetch c_pre_payments into ln_pre_pymt_action_id;
543: close c_pre_payments;
544:
545: hr_utility.trace(' NZ Run ActionId is' ||to_char(ln_pre_pymt_action_id));
546: hr_utility.trace(' NZ ln_prev_pre_pymt_action_id is' ||to_char(ln_prev_pre_pymt_action_id));
547:
548: if (ln_prev_pre_pymt_action_id is null or
549: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then

Line 546: hr_utility.trace(' NZ ln_prev_pre_pymt_action_id is' ||to_char(ln_prev_pre_pymt_action_id));

542: fetch c_pre_payments into ln_pre_pymt_action_id;
543: close c_pre_payments;
544:
545: hr_utility.trace(' NZ Run ActionId is' ||to_char(ln_pre_pymt_action_id));
546: hr_utility.trace(' NZ ln_prev_pre_pymt_action_id is' ||to_char(ln_prev_pre_pymt_action_id));
547:
548: if (ln_prev_pre_pymt_action_id is null or
549: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
550:

Line 551: hr_utility.set_location('procdar',6);

547:
548: if (ln_prev_pre_pymt_action_id is null or
549: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
550:
551: hr_utility.set_location('procdar',6);
552: select pay_assignment_actions_s.nextval
553: into ln_deposit_action_id
554: from dual;
555:

Line 563: hr_utility.trace(' NZ Inserted into paa');

559: pactid, chunk, ln_tax_unit_id);
560:
561: -- insert an interlock to this action.
562: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
563: hr_utility.trace(' NZ Inserted into paa');
564:
565: open c_payroll_run (ln_nacha_action_id);
566: fetch c_payroll_run into ln_master_action_id;
567: hr_utility.trace(' NZ ln_master_action_id is'

Line 567: hr_utility.trace(' NZ ln_master_action_id is'

563: hr_utility.trace(' NZ Inserted into paa');
564:
565: open c_payroll_run (ln_nacha_action_id);
566: fetch c_payroll_run into ln_master_action_id;
567: hr_utility.trace(' NZ ln_master_action_id is'
568: ||to_char(ln_master_action_id));
569: close c_payroll_run;
570:
571: update pay_assignment_Actions

Line 856: --hr_utility.trace_on(null, 'DAR');

852:
853: ass_set_id := pyusdar_pkg.get_parameter('ASG_SET_ID',
854: l_legislative_parameters);
855:
856: --hr_utility.trace_on(null, 'DAR');
857: hr_utility.set_location('procdar archive',1);
858: open c_paid_actions(pactid, stperson, endperson);
859: loop
860: hr_utility.set_location('procdar archive',2);

Line 857: hr_utility.set_location('procdar archive',1);

853: ass_set_id := pyusdar_pkg.get_parameter('ASG_SET_ID',
854: l_legislative_parameters);
855:
856: --hr_utility.trace_on(null, 'DAR');
857: hr_utility.set_location('procdar archive',1);
858: open c_paid_actions(pactid, stperson, endperson);
859: loop
860: hr_utility.set_location('procdar archive',2);
861:

Line 860: hr_utility.set_location('procdar archive',2);

856: --hr_utility.trace_on(null, 'DAR');
857: hr_utility.set_location('procdar archive',1);
858: open c_paid_actions(pactid, stperson, endperson);
859: loop
860: hr_utility.set_location('procdar archive',2);
861:
862: ass_flag := 'N';
863:
864: fetch c_paid_actions into ln_nacha_action_id, ln_assignment_id,

Line 871: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'

867:
868: ass_flag := hr_assignment_set.assignment_in_set(ass_set_id,ln_assignment_id);
869:
870: IF ass_flag = 'Y' THEN
871: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
872: ||to_char(ln_nacha_action_id));
873:
874: hr_utility.set_location('procdar archive',3);
875: select pay_assignment_actions_s.nextval

Line 874: hr_utility.set_location('procdar archive',3);

870: IF ass_flag = 'Y' THEN
871: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
872: ||to_char(ln_nacha_action_id));
873:
874: hr_utility.set_location('procdar archive',3);
875: select pay_assignment_actions_s.nextval
876: into ln_deposit_action_id
877: from dual;
878:

Line 883: hr_utility.trace('Inserted into paa');

879: -- insert the action record.
880: hr_nonrun_asact.insact(ln_deposit_action_id,
881: ln_assignment_id,
882: pactid, chunk, ln_tax_unit_id);
883: hr_utility.trace('Inserted into paa');
884: -- insert an interlock to this action.
885: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
886:
887: update pay_assignment_Actions

Line 897: hr_utility.set_location('procdar archive',4);

893: end loop;
894: close c_paid_actions;
895:
896: --
897: hr_utility.set_location('procdar archive',4);
898: ln_prev_pre_pymt_action_id := null;
899: open c_actions_zero_pay(pactid,stperson,endperson);
900:
901: loop

Line 902: hr_utility.set_location('procdar archive',5);

898: ln_prev_pre_pymt_action_id := null;
899: open c_actions_zero_pay(pactid,stperson,endperson);
900:
901: loop
902: hr_utility.set_location('procdar archive',5);
903:
904: ass_flag := 'N';
905:
906: fetch c_actions_zero_pay INTO ln_nacha_action_id, --gives P,U

Line 910: hr_utility.trace(' NZ PrePayment Id is' ||to_char(ln_nacha_action_id));

906: fetch c_actions_zero_pay INTO ln_nacha_action_id, --gives P,U
907: ln_assignment_id,
908: ln_tax_unit_id;
909: exit WHEN c_actions_zero_pay%NOTFOUND;
910: hr_utility.trace(' NZ PrePayment Id is' ||to_char(ln_nacha_action_id));
911:
912: hr_utility.set_location('procdar archive',3);
913:
914: ass_flag := hr_assignment_set.assignment_in_set(ass_set_id,ln_assignment_id);

Line 912: hr_utility.set_location('procdar archive',3);

908: ln_tax_unit_id;
909: exit WHEN c_actions_zero_pay%NOTFOUND;
910: hr_utility.trace(' NZ PrePayment Id is' ||to_char(ln_nacha_action_id));
911:
912: hr_utility.set_location('procdar archive',3);
913:
914: ass_flag := hr_assignment_set.assignment_in_set(ass_set_id,ln_assignment_id);
915:
916: IF ass_flag = 'Y' THEN

Line 929: hr_utility.trace(' NZ Inserted into paa');

925: pactid, chunk, ln_tax_unit_id);
926:
927: -- insert an interlock to this action.
928: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
929: hr_utility.trace(' NZ Inserted into paa');
930:
931: update pay_assignment_Actions
932: set serial_number = ln_nacha_action_id
933: where assignment_action_id = ln_deposit_action_id;