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

Line 213: hr_utility.trace('l_payroll_id = ' || to_char(l_payroll_id));

209: ,p_consolidation_set_id => ln_consolidation_set_id);
210:
211: /* Removed old code to use get_payroll_action bug#3438254 */
212:
213: hr_utility.trace('l_payroll_id = ' || to_char(l_payroll_id));
214: hr_utility.trace('l_asg_set_id = ' || to_char(l_asg_set_id));
215:
216: --Database Version --Bug 3331023
217:

Line 214: hr_utility.trace('l_asg_set_id = ' || to_char(l_asg_set_id));

210:
211: /* Removed old code to use get_payroll_action bug#3438254 */
212:
213: hr_utility.trace('l_payroll_id = ' || to_char(l_payroll_id));
214: hr_utility.trace('l_asg_set_id = ' || to_char(l_asg_set_id));
215:
216: --Database Version --Bug 3331023
217:
218: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then

Line 369: hr_utility.trace(' p_prepayment_action_id '|| to_char(p_prepayment_action_id));

365:
366: lc_return_flag VARCHAR2(1);
367:
368: BEGIN
369: hr_utility.trace(' p_prepayment_action_id '|| to_char(p_prepayment_action_id));
370: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date)); hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
371: hr_utility.trace(' p_consolidation_set_id '|| to_char(p_consolidation_set_id));
372:
373: lc_return_flag := 'N';

Line 370: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date)); hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));

366: lc_return_flag VARCHAR2(1);
367:
368: BEGIN
369: hr_utility.trace(' p_prepayment_action_id '|| to_char(p_prepayment_action_id));
370: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date)); hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
371: hr_utility.trace(' p_consolidation_set_id '|| to_char(p_consolidation_set_id));
372:
373: lc_return_flag := 'N';
374: open c_direct_deposit_run(p_prepayment_action_id,

Line 371: hr_utility.trace(' p_consolidation_set_id '|| to_char(p_consolidation_set_id));

367:
368: BEGIN
369: hr_utility.trace(' p_prepayment_action_id '|| to_char(p_prepayment_action_id));
370: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date)); hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
371: hr_utility.trace(' p_consolidation_set_id '|| to_char(p_consolidation_set_id));
372:
373: lc_return_flag := 'N';
374: open c_direct_deposit_run(p_prepayment_action_id,
375: p_deposit_start_date,

Line 381: hr_utility.trace('c_direct_deposit_run%found lc_return_flag: '|| lc_return_flag);

377: p_consolidation_set_id);
378: fetch c_direct_deposit_run into lc_dd_flag;
379: if c_direct_deposit_run%found then
380: lc_return_flag := 'Y';
381: hr_utility.trace('c_direct_deposit_run%found lc_return_flag: '|| lc_return_flag);
382:
383: else
384: open c_no_prepayments(p_prepayment_action_id);
385: fetch c_no_prepayments into lc_no_prepayment_flag;

Line 388: hr_utility.trace('c_no_prepayments%found lc_return_flag: '|| lc_return_flag);

384: open c_no_prepayments(p_prepayment_action_id);
385: fetch c_no_prepayments into lc_no_prepayment_flag;
386: if c_no_prepayments%found then
387: lc_return_flag := 'Y';
388: hr_utility.trace('c_no_prepayments%found lc_return_flag: '|| lc_return_flag);
389: end if;
390: close c_no_prepayments;
391: end if;
392: close c_direct_deposit_run;

Line 628: -- hr_utility.trace_on('Y','CAASGSET');

624: -- algorithm is quite similar to the other process cases,
625: -- but we have to take into account assignments and
626: -- personal payment methods.
627: begin
628: -- hr_utility.trace_on('Y','CAASGSET');
629: hr_utility.set_location('pycadar.action_creation',1);
630: -- Initialising local variables here to avoid GSCC warnings
631: ln_prev_pre_pymt_action_id := null;
632: ln_prev_source_action_id := null;

Line 629: hr_utility.set_location('pycadar.action_creation',1);

625: -- but we have to take into account assignments and
626: -- personal payment methods.
627: begin
628: -- hr_utility.trace_on('Y','CAASGSET');
629: hr_utility.set_location('pycadar.action_creation',1);
630: -- Initialising local variables here to avoid GSCC warnings
631: ln_prev_pre_pymt_action_id := null;
632: ln_prev_source_action_id := null;
633: ln_prev_asg_act_id := -999999;

Line 719: hr_utility.set_location('pycadar.action_creation l_asg_set_id = '

715: ,p_consolidation_set_id => ln_consolidation_set_id);
716:
717: /* removed old code to use get_payroll_action bug#3438254 */
718:
719: hr_utility.set_location('pycadar.action_creation l_asg_set_id = '
720: ,l_asg_set_id);
721:
722: IF l_asg_set_id IS NOT NULL THEN
723: open c_actions_asg_set(pactid,stperson,endperson,l_asg_set_id);

Line 732: hr_utility.set_location('pycadar.action_creation',2);

728: END IF;
729:
730: num := 0;
731: loop
732: hr_utility.set_location('pycadar.action_creation',2);
733: IF l_asg_set_id IS NOT NULL THEN
734: fetch c_actions_asg_set into lockedactid,assignid,greid;
735: if c_actions_asg_set%found then num := num + 1; end if;
736: exit when c_actions_asg_set%notfound;

Line 747: hr_utility.trace(' c_actions.lockedactid is '||to_char(lockedactid));

743: END IF;
744: --
745: IF lockedactid <> ln_prev_asg_act_id THEN
746:
747: hr_utility.trace(' c_actions.lockedactid is '||to_char(lockedactid));
748: open c_pre_payments (lockedactid);
749: fetch c_pre_payments into ln_pre_pymt_action_id;
750: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'
751: ||to_char(ln_pre_pymt_action_id));

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

746:
747: hr_utility.trace(' c_actions.lockedactid is '||to_char(lockedactid));
748: open c_pre_payments (lockedactid);
749: fetch c_pre_payments into ln_pre_pymt_action_id;
750: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'
751: ||to_char(ln_pre_pymt_action_id));
752: close c_pre_payments;
753:
754: -- we need to insert one action for each of the

Line 758: hr_utility.trace(' ln_prev_pre_pymt_action_id is'

754: -- we need to insert one action for each of the
755: -- rows that we return from the cursor (i.e. one
756: -- for each assignment/pre-payment).
757:
758: hr_utility.trace(' ln_prev_pre_pymt_action_id is'
759: ||to_char(ln_prev_pre_pymt_action_id));
760: if (ln_prev_pre_pymt_action_id is null or
761: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
762: open c_payments (ln_pre_pymt_action_id);

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

760: if (ln_prev_pre_pymt_action_id is null or
761: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
762: open c_payments (ln_pre_pymt_action_id);
763: loop
764: hr_utility.set_location('procdar',99);
765: fetch c_payments into ln_source_action_id;
766: hr_utility.trace(' ln_source_action_id is'
767: ||to_char(ln_source_action_id));
768:

Line 766: hr_utility.trace(' ln_source_action_id is'

762: open c_payments (ln_pre_pymt_action_id);
763: loop
764: hr_utility.set_location('procdar',99);
765: fetch c_payments into ln_source_action_id;
766: hr_utility.trace(' ln_source_action_id is'
767: ||to_char(ln_source_action_id));
768:
769: hr_utility.set_location('procdar',98);
770: if c_payments%notfound then

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

765: fetch c_payments into ln_source_action_id;
766: hr_utility.trace(' ln_source_action_id is'
767: ||to_char(ln_source_action_id));
768:
769: hr_utility.set_location('procdar',98);
770: if c_payments%notfound then
771: exit;
772: end if;
773: hr_utility.set_location('procdar',97);

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

769: hr_utility.set_location('procdar',98);
770: if c_payments%notfound then
771: exit;
772: end if;
773: hr_utility.set_location('procdar',97);
774: /**************************************************************
775: ** we need to insert one action for each of the rows that we
776: ** return from the cursor (i.e. one for each
777: ** assignment/pre-payment source).

Line 779: hr_utility.trace(' ln_prev_source_action_id is'

775: ** we need to insert one action for each of the rows that we
776: ** return from the cursor (i.e. one for each
777: ** assignment/pre-payment source).
778: **************************************************************/
779: hr_utility.trace(' ln_prev_source_action_id is'
780: ||to_char(ln_prev_source_action_id));
781: if (ln_prev_source_action_id is null or
782: ln_source_action_id <> ln_prev_source_action_id or
783: ln_source_action_id is null) then

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

781: if (ln_prev_source_action_id is null or
782: ln_source_action_id <> ln_prev_source_action_id or
783: ln_source_action_id is null) then
784:
785: hr_utility.set_location('procdar',3);
786: select pay_assignment_actions_s.nextval
787: into lockingactid
788: from dual;
789:

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

789:
790: -- insert the action record.
791: hr_nonrun_asact.insact(lockingactid,assignid,
792: pactid,chunk,greid);
793: hr_utility.trace('Inserted into paa');
794: hr_utility.trace(' assignment_id is ' ||to_char(assignid));
795: -- insert an interlock to this action.
796: hr_nonrun_asact.insint(lockingactid,lockedactid);
797: hr_utility.trace('Inserted into interlock');

Line 794: hr_utility.trace(' assignment_id is ' ||to_char(assignid));

790: -- insert the action record.
791: hr_nonrun_asact.insact(lockingactid,assignid,
792: pactid,chunk,greid);
793: hr_utility.trace('Inserted into paa');
794: hr_utility.trace(' assignment_id is ' ||to_char(assignid));
795: -- insert an interlock to this action.
796: hr_nonrun_asact.insint(lockingactid,lockedactid);
797: hr_utility.trace('Inserted into interlock');
798:

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

793: hr_utility.trace('Inserted into paa');
794: hr_utility.trace(' assignment_id is ' ||to_char(assignid));
795: -- insert an interlock to this action.
796: hr_nonrun_asact.insint(lockingactid,lockedactid);
797: hr_utility.trace('Inserted into interlock');
798:
799: if ln_source_action_id is not null then
800:
801: hr_utility.trace('serial number updated if loop ');

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

797: hr_utility.trace('Inserted into interlock');
798:
799: if ln_source_action_id is not null then
800:
801: hr_utility.trace('serial number updated if loop ');
802: hr_utility.trace('serial number is '||ln_source_action_id);
803: update pay_assignment_Actions
804: set serial_number = 'P'||ln_source_action_id
805: --set serial_number = ln_source_action_id

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

798:
799: if ln_source_action_id is not null then
800:
801: hr_utility.trace('serial number updated if loop ');
802: hr_utility.trace('serial number is '||ln_source_action_id);
803: update pay_assignment_Actions
804: set serial_number = 'P'||ln_source_action_id
805: --set serial_number = ln_source_action_id
806: where assignment_action_id = lockingactid;

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

804: set serial_number = 'P'||ln_source_action_id
805: --set serial_number = ln_source_action_id
806: where assignment_action_id = lockingactid;
807: else
808: hr_utility.trace('serial number else ');
809: open c_payroll_run (ln_pre_pymt_action_id);
810: fetch c_payroll_run into ln_master_action_id;
811: close c_payroll_run;
812: hr_utility.trace(' ln_master_action_id is'

Line 812: hr_utility.trace(' ln_master_action_id is'

808: hr_utility.trace('serial number else ');
809: open c_payroll_run (ln_pre_pymt_action_id);
810: fetch c_payroll_run into ln_master_action_id;
811: close c_payroll_run;
812: hr_utility.trace(' ln_master_action_id is'
813: ||to_char(ln_master_action_id));
814:
815: update pay_assignment_Actions
816: set serial_number = 'M'||ln_master_action_id

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

839: end if;
840:
841: /* removed the commented code bug#3438254 */
842:
843: hr_utility.set_location('procdar',4);
844: ln_prev_pre_pymt_action_id := null;
845: open c_actions_zero_pay(pactid,stperson,endperson);
846:
847: loop

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

844: ln_prev_pre_pymt_action_id := null;
845: open c_actions_zero_pay(pactid,stperson,endperson);
846:
847: loop
848: hr_utility.set_location('procdar',5);
849: lv_ass_set_on := 'N';
850: hr_utility.trace('Start of c_actions_zero_pay ');
851: fetch c_actions_zero_pay INTO ln_direct_dep_act_id, --gives P,U
852: ln_assignment_id,

Line 850: hr_utility.trace('Start of c_actions_zero_pay ');

846:
847: loop
848: hr_utility.set_location('procdar',5);
849: lv_ass_set_on := 'N';
850: hr_utility.trace('Start of c_actions_zero_pay ');
851: fetch c_actions_zero_pay INTO ln_direct_dep_act_id, --gives P,U
852: ln_assignment_id,
853: ln_tax_unit_id;
854: exit WHEN c_actions_zero_pay%NOTFOUND;

Line 855: hr_utility.trace(' NZ PrePayment Id is' ||ln_direct_dep_act_id);

851: fetch c_actions_zero_pay INTO ln_direct_dep_act_id, --gives P,U
852: ln_assignment_id,
853: ln_tax_unit_id;
854: exit WHEN c_actions_zero_pay%NOTFOUND;
855: hr_utility.trace(' NZ PrePayment Id is' ||ln_direct_dep_act_id);
856:
857: /* Added this code for Assignment set validation bug#3438254,
858: Otherwise it was displaying all the assignments that are
859: not in the given Assignment Set.

Line 864: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);

860: */
861: lv_ass_set_on := hr_assignment_set.assignment_in_set(
862: l_asg_set_id,
863: ln_assignment_id);
864: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);
865:
866: If lv_ass_set_on = 'Y' then
867:
868: open c_pre_payments (ln_direct_dep_act_id); --gives me R,Q

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

868: open c_pre_payments (ln_direct_dep_act_id); --gives me R,Q
869: fetch c_pre_payments into ln_pre_pymt_action_id;
870: close c_pre_payments;
871:
872: hr_utility.trace(' NZ Run ActionId is' ||to_char(ln_pre_pymt_action_id));
873: hr_utility.trace(' NZ ln_prev_pre_pymt_action_id is' ||to_char(ln_prev_pre_pymt_action_id));
874:
875: if (ln_prev_pre_pymt_action_id is null or
876: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then

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

869: fetch c_pre_payments into ln_pre_pymt_action_id;
870: close c_pre_payments;
871:
872: hr_utility.trace(' NZ Run ActionId is' ||to_char(ln_pre_pymt_action_id));
873: hr_utility.trace(' NZ ln_prev_pre_pymt_action_id is' ||to_char(ln_prev_pre_pymt_action_id));
874:
875: if (ln_prev_pre_pymt_action_id is null or
876: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
877:

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

874:
875: if (ln_prev_pre_pymt_action_id is null or
876: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
877:
878: hr_utility.set_location('procdar',6);
879: select pay_assignment_actions_s.nextval
880: into ln_deposit_action_id
881: from dual;
882:

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

886: pactid, chunk, ln_tax_unit_id);
887:
888: -- insert an interlock to this action.
889: hr_nonrun_asact.insint(ln_deposit_action_id,ln_direct_dep_act_id);
890: hr_utility.trace(' NZ Inserted into paa');
891: hr_utility.trace(' Asg id: '||to_char(ln_assignment_id));
892:
893: /* removed the commented code bug#3438254 */
894:

Line 891: hr_utility.trace(' Asg id: '||to_char(ln_assignment_id));

887:
888: -- insert an interlock to this action.
889: hr_nonrun_asact.insint(ln_deposit_action_id,ln_direct_dep_act_id);
890: hr_utility.trace(' NZ Inserted into paa');
891: hr_utility.trace(' Asg id: '||to_char(ln_assignment_id));
892:
893: /* removed the commented code bug#3438254 */
894:
895: update pay_assignment_Actions

Line 908: -- hr_utility.trace_off;

904: End if; -- lv_ass_set_on = 'Y'
905:
906: end loop;
907: close c_actions_zero_pay;
908: -- hr_utility.trace_off;
909:
910: commit;
911: end action_creation;
912: --------------------- archive_action_creation ----------------------------

Line 1046: -- hr_utility.trace_on(null, 'ARCH_DEPADV');

1042: ,p_assignment_set_id => ln_asg_set_id
1043: ,p_payroll_id => ln_payroll_id
1044: ,p_consolidation_set_id => ln_consolidation_set_id);
1045:
1046: -- hr_utility.trace_on(null, 'ARCH_DEPADV');
1047: hr_utility.set_location('pycadar archive_action_creation',1);
1048: open c_paid_actions(stperson, endperson,
1049: ln_payroll_id,
1050: ln_consolidation_set_id,

Line 1047: hr_utility.set_location('pycadar archive_action_creation',1);

1043: ,p_payroll_id => ln_payroll_id
1044: ,p_consolidation_set_id => ln_consolidation_set_id);
1045:
1046: -- hr_utility.trace_on(null, 'ARCH_DEPADV');
1047: hr_utility.set_location('pycadar archive_action_creation',1);
1048: open c_paid_actions(stperson, endperson,
1049: ln_payroll_id,
1050: ln_consolidation_set_id,
1051: ld_deposit_start_date,

Line 1054: hr_utility.set_location('pycadar archive_action_creation',2);

1050: ln_consolidation_set_id,
1051: ld_deposit_start_date,
1052: ld_deposit_end_date);
1053: loop
1054: hr_utility.set_location('pycadar archive_action_creation',2);
1055:
1056: lv_ass_set_on := 'N';
1057:
1058: fetch c_paid_actions into ln_dd_action_id,

Line 1070: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);

1066:
1067: lv_ass_set_on := hr_assignment_set.assignment_in_set(
1068: ln_asg_set_id,
1069: ln_assignment_id);
1070: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);
1071:
1072: IF lv_ass_set_on = 'Y' THEN
1073: hr_utility.trace('c_paid_actions.ln_dd_action_id is' ||to_char(ln_dd_action_id));
1074: hr_utility.trace(' ln_assignment_id is' ||to_char(ln_assignment_id));

Line 1073: hr_utility.trace('c_paid_actions.ln_dd_action_id is' ||to_char(ln_dd_action_id));

1069: ln_assignment_id);
1070: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);
1071:
1072: IF lv_ass_set_on = 'Y' THEN
1073: hr_utility.trace('c_paid_actions.ln_dd_action_id is' ||to_char(ln_dd_action_id));
1074: hr_utility.trace(' ln_assignment_id is' ||to_char(ln_assignment_id));
1075: hr_utility.trace(' ln_tax_unit_id is' ||to_char(ln_tax_unit_id));
1076:
1077: hr_utility.set_location('pycadar archive_action_creation',3);

Line 1074: hr_utility.trace(' ln_assignment_id is' ||to_char(ln_assignment_id));

1070: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);
1071:
1072: IF lv_ass_set_on = 'Y' THEN
1073: hr_utility.trace('c_paid_actions.ln_dd_action_id is' ||to_char(ln_dd_action_id));
1074: hr_utility.trace(' ln_assignment_id is' ||to_char(ln_assignment_id));
1075: hr_utility.trace(' ln_tax_unit_id is' ||to_char(ln_tax_unit_id));
1076:
1077: hr_utility.set_location('pycadar archive_action_creation',3);
1078: select pay_assignment_actions_s.nextval

Line 1075: hr_utility.trace(' ln_tax_unit_id is' ||to_char(ln_tax_unit_id));

1071:
1072: IF lv_ass_set_on = 'Y' THEN
1073: hr_utility.trace('c_paid_actions.ln_dd_action_id is' ||to_char(ln_dd_action_id));
1074: hr_utility.trace(' ln_assignment_id is' ||to_char(ln_assignment_id));
1075: hr_utility.trace(' ln_tax_unit_id is' ||to_char(ln_tax_unit_id));
1076:
1077: hr_utility.set_location('pycadar archive_action_creation',3);
1078: select pay_assignment_actions_s.nextval
1079: into ln_deposit_action_id

Line 1077: hr_utility.set_location('pycadar archive_action_creation',3);

1073: hr_utility.trace('c_paid_actions.ln_dd_action_id is' ||to_char(ln_dd_action_id));
1074: hr_utility.trace(' ln_assignment_id is' ||to_char(ln_assignment_id));
1075: hr_utility.trace(' ln_tax_unit_id is' ||to_char(ln_tax_unit_id));
1076:
1077: hr_utility.set_location('pycadar archive_action_creation',3);
1078: select pay_assignment_actions_s.nextval
1079: into ln_deposit_action_id
1080: from dual;
1081:

Line 1086: hr_utility.trace('Inserted into paa, New Asg_act_id:'||to_char(ln_deposit_action_id));

1082: -- insert the action record.
1083: hr_nonrun_asact.insact(ln_deposit_action_id,
1084: ln_assignment_id,
1085: pactid, chunk, ln_tax_unit_id);
1086: hr_utility.trace('Inserted into paa, New Asg_act_id:'||to_char(ln_deposit_action_id));
1087: -- insert an interlock to this action.
1088: hr_nonrun_asact.insint(ln_deposit_action_id, ln_dd_action_id);
1089:
1090: update pay_assignment_Actions

Line 1100: hr_utility.set_location('pycadar archive_action_creation',4);

1096: close c_non_void_pymts;
1097: end loop;
1098: close c_paid_actions;
1099:
1100: hr_utility.set_location('pycadar archive_action_creation',4);
1101:
1102: END archive_action_creation;
1103:
1104: ---------------------------------- sort_action -------------------------------

Line 1361: hr_utility.trace('###### IN Qualifying Proc');

1357: --
1358: --
1359:
1360: BEGIN
1361: hr_utility.trace('###### IN Qualifying Proc');
1362: --
1363: l_actid := pay_proc_environment_pkg.get_pactid;
1364: --
1365: ln_curr_payroll_act_id := l_actid;

Line 1366: hr_utility.trace('In QualProc l_actid := ' || l_actid);

1362: --
1363: l_actid := pay_proc_environment_pkg.get_pactid;
1364: --
1365: ln_curr_payroll_act_id := l_actid;
1366: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1367: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1368:
1369: IF pycadar_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1370: pycadar_pkg.g_payroll_act_id := ln_curr_payroll_act_id;

Line 1367: hr_utility.trace('p_assignment_id := ' || p_assignment_id);

1363: l_actid := pay_proc_environment_pkg.get_pactid;
1364: --
1365: ln_curr_payroll_act_id := l_actid;
1366: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1367: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1368:
1369: IF pycadar_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1370: pycadar_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1371:

Line 1385: -- hr_utility.trace('l_payroll_id :='||l_payroll_id);

1381: ,l_effective_date
1382: ,l_business_group_id
1383: ,l_legislation_code);
1384:
1385: -- hr_utility.trace('l_payroll_id :='||l_payroll_id);
1386: -- hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1387: -- hr_utility.trace('l_start_date :='||l_start_date);
1388: -- hr_utility.trace('l_end_date :='||l_end_date);
1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);

Line 1386: -- hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);

1382: ,l_business_group_id
1383: ,l_legislation_code);
1384:
1385: -- hr_utility.trace('l_payroll_id :='||l_payroll_id);
1386: -- hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1387: -- hr_utility.trace('l_start_date :='||l_start_date);
1388: -- hr_utility.trace('l_end_date :='||l_end_date);
1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);
1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);

Line 1387: -- hr_utility.trace('l_start_date :='||l_start_date);

1383: ,l_legislation_code);
1384:
1385: -- hr_utility.trace('l_payroll_id :='||l_payroll_id);
1386: -- hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1387: -- hr_utility.trace('l_start_date :='||l_start_date);
1388: -- hr_utility.trace('l_end_date :='||l_end_date);
1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);
1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);
1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);

Line 1388: -- hr_utility.trace('l_end_date :='||l_end_date);

1384:
1385: -- hr_utility.trace('l_payroll_id :='||l_payroll_id);
1386: -- hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1387: -- hr_utility.trace('l_start_date :='||l_start_date);
1388: -- hr_utility.trace('l_end_date :='||l_end_date);
1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);
1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);
1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);

Line 1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);

1385: -- hr_utility.trace('l_payroll_id :='||l_payroll_id);
1386: -- hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1387: -- hr_utility.trace('l_start_date :='||l_start_date);
1388: -- hr_utility.trace('l_end_date :='||l_end_date);
1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);
1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);
1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);
1393: -- hr_utility.trace('l_effective_date :='||l_effective_date);

Line 1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);

1386: -- hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1387: -- hr_utility.trace('l_start_date :='||l_start_date);
1388: -- hr_utility.trace('l_end_date :='||l_end_date);
1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);
1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);
1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);
1393: -- hr_utility.trace('l_effective_date :='||l_effective_date);
1394: -- hr_utility.trace('l_business_group_id :='||l_business_group_id);

Line 1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);

1387: -- hr_utility.trace('l_start_date :='||l_start_date);
1388: -- hr_utility.trace('l_end_date :='||l_end_date);
1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);
1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);
1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);
1393: -- hr_utility.trace('l_effective_date :='||l_effective_date);
1394: -- hr_utility.trace('l_business_group_id :='||l_business_group_id);
1395: -- hr_utility.trace('l_legislation_code :='||l_legislation_code);

Line 1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);

1388: -- hr_utility.trace('l_end_date :='||l_end_date);
1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);
1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);
1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);
1393: -- hr_utility.trace('l_effective_date :='||l_effective_date);
1394: -- hr_utility.trace('l_business_group_id :='||l_business_group_id);
1395: -- hr_utility.trace('l_legislation_code :='||l_legislation_code);
1396:

Line 1393: -- hr_utility.trace('l_effective_date :='||l_effective_date);

1389: -- hr_utility.trace('l_rep_group :='||l_rep_group);
1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);
1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);
1393: -- hr_utility.trace('l_effective_date :='||l_effective_date);
1394: -- hr_utility.trace('l_business_group_id :='||l_business_group_id);
1395: -- hr_utility.trace('l_legislation_code :='||l_legislation_code);
1396:
1397: --

Line 1394: -- hr_utility.trace('l_business_group_id :='||l_business_group_id);

1390: -- hr_utility.trace('l_rep_category :='||l_rep_category);
1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);
1393: -- hr_utility.trace('l_effective_date :='||l_effective_date);
1394: -- hr_utility.trace('l_business_group_id :='||l_business_group_id);
1395: -- hr_utility.trace('l_legislation_code :='||l_legislation_code);
1396:
1397: --
1398: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');

Line 1395: -- hr_utility.trace('l_legislation_code :='||l_legislation_code);

1391: -- hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1392: -- hr_utility.trace('l_assignment_id :='||l_assignment_id);
1393: -- hr_utility.trace('l_effective_date :='||l_effective_date);
1394: -- hr_utility.trace('l_business_group_id :='||l_business_group_id);
1395: -- hr_utility.trace('l_legislation_code :='||l_legislation_code);
1396:
1397: --
1398: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
1399: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');

Line 1420: --hr_utility.trace(statem);

1416: --
1417: DECLARE
1418: BEGIN
1419: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
1420: --hr_utility.trace(statem);
1421: sql_cur := dbms_sql.open_cursor;
1422: dbms_sql.parse(sql_cur
1423: ,statem
1424: ,dbms_sql.v7);

Line 1442: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);

1438: END IF;
1439: END;
1440: --
1441: --
1442: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1443: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1444:
1445: IF pycadar_pkg.g_assignment_set_id IS NULL THEN
1446: OPEN csr_asg(pycadar_pkg.g_payroll_id

Line 1443: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);

1439: END;
1440: --
1441: --
1442: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1443: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1444:
1445: IF pycadar_pkg.g_assignment_set_id IS NULL THEN
1446: OPEN csr_asg(pycadar_pkg.g_payroll_id
1447: ,pycadar_pkg.g_consolidation_set_id

Line 1462: hr_utility.trace('csr_asg didnot return any row');

1458: FETCH csr_asg INTO ln_assignment_id, ln_action_ctx_id;
1459:
1460:
1461: IF csr_asg%NOTFOUND THEN
1462: hr_utility.trace('csr_asg didnot return any row');
1463: EXIT;
1464: ELSE
1465: IF check_if_qualified_for_CA(ln_action_ctx_id
1466: ,ln_assignment_id

Line 1472: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);

1468: ,pycadar_pkg.g_end_dt
1469: ,pycadar_pkg.g_consolidation_set_id) = 'Y' THEN
1470:
1471: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1472: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1473:
1474: END IF;
1475: END IF;
1476:

Line 1506: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);

1502: ,pycadar_pkg.g_end_dt
1503: ,pycadar_pkg.g_consolidation_set_id) = 'Y' THEN
1504:
1505: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1506: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1507: END IF;
1508: END IF;
1509:
1510: END LOOP;

Line 1519: hr_utility.trace('g_tmp_tbl.COUNT := ' || g_tmp_tbl.COUNT);

1515:
1516: l_qualifier := 'N';
1517: k := 1;
1518:
1519: hr_utility.trace('g_tmp_tbl.COUNT := ' || g_tmp_tbl.COUNT);
1520:
1521: IF g_tmp_tbl.EXISTS(p_assignment_id) THEN
1522: l_qualifier := 'Y';
1523: END IF;

Line 1525: hr_utility.trace('B4 Return l_qualifier := ' || l_qualifier);

1521: IF g_tmp_tbl.EXISTS(p_assignment_id) THEN
1522: l_qualifier := 'Y';
1523: END IF;
1524:
1525: hr_utility.trace('B4 Return l_qualifier := ' || l_qualifier);
1526:
1527:
1528: IF l_qualifier = 'Y' THEN
1529: p_qualifier := 'Y' ;

Line 1580: hr_utility.trace('Entering check_if_qualified_for_CA');

1576: lv_rev_run_exists VARCHAR2(1);
1577: BEGIN
1578: --
1579: --
1580: hr_utility.trace('Entering check_if_qualified_for_CA');
1581:
1582: OPEN c_prepay_arch_action(p_archive_action_id);
1583: FETCH c_prepay_arch_action INTO ln_prepay_action_id;
1584: IF c_prepay_arch_action%notfound THEN

Line 1595: hr_utility.trace('ln_prepay_action_id :='||ln_prepay_action_id);

1591: END IF;
1592: CLOSE c_prepay_arch_action;
1593: --
1594: --
1595: hr_utility.trace('ln_prepay_action_id :='||ln_prepay_action_id);
1596:
1597: IF pay_us_employee_payslip_web.get_doc_eit(
1598: 'PAYSLIP'
1599: ,'PRINT'