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.

[Home] [Help]

APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on HR_UTILITY

Line 186: hr_utility.trace('Entering get_DAxml_payroll_action');

182: ld_deposit_start_date DATE;
183: ld_deposit_end_date DATE;
184:
185: BEGIN
186: hr_utility.trace('Entering get_DAxml_payroll_action');
187: open c_get_payroll_action(p_payroll_action_id);
188: fetch c_get_payroll_action into lv_legislative_parameters,
189: ld_deposit_start_date,
190: ld_deposit_end_date;

Line 191: hr_utility.trace('lv_legislative_parameters := ' || lv_legislative_parameters);

187: open c_get_payroll_action(p_payroll_action_id);
188: fetch c_get_payroll_action into lv_legislative_parameters,
189: ld_deposit_start_date,
190: ld_deposit_end_date;
191: hr_utility.trace('lv_legislative_parameters := ' || lv_legislative_parameters);
192: hr_utility.trace('ld_deposit_start_date := ' || TO_CHAR(ld_deposit_start_date));
193: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));
194:
195: close c_get_payroll_action;

Line 192: hr_utility.trace('ld_deposit_start_date := ' || TO_CHAR(ld_deposit_start_date));

188: fetch c_get_payroll_action into lv_legislative_parameters,
189: ld_deposit_start_date,
190: ld_deposit_end_date;
191: hr_utility.trace('lv_legislative_parameters := ' || lv_legislative_parameters);
192: hr_utility.trace('ld_deposit_start_date := ' || TO_CHAR(ld_deposit_start_date));
193: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));
194:
195: close c_get_payroll_action;
196:

Line 193: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));

189: ld_deposit_start_date,
190: ld_deposit_end_date;
191: hr_utility.trace('lv_legislative_parameters := ' || lv_legislative_parameters);
192: hr_utility.trace('ld_deposit_start_date := ' || TO_CHAR(ld_deposit_start_date));
193: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));
194:
195: close c_get_payroll_action;
196:
197: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(

Line 207: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);

203: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
204: 'CONSOLIDATION_SET_ID',
205: lv_legislative_parameters);
206:
207: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);
208: hr_utility.trace('ln_payroll_id := ' || ln_payroll_id);
209: hr_utility.trace('ln_consolidation_set_id := ' || ln_consolidation_set_id);
210:
211: p_deposit_start_date := ld_deposit_start_date;

Line 208: hr_utility.trace('ln_payroll_id := ' || ln_payroll_id);

204: 'CONSOLIDATION_SET_ID',
205: lv_legislative_parameters);
206:
207: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);
208: hr_utility.trace('ln_payroll_id := ' || ln_payroll_id);
209: hr_utility.trace('ln_consolidation_set_id := ' || ln_consolidation_set_id);
210:
211: p_deposit_start_date := ld_deposit_start_date;
212: p_deposit_end_date := ld_deposit_end_date;

Line 209: hr_utility.trace('ln_consolidation_set_id := ' || ln_consolidation_set_id);

205: lv_legislative_parameters);
206:
207: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);
208: hr_utility.trace('ln_payroll_id := ' || ln_payroll_id);
209: hr_utility.trace('ln_consolidation_set_id := ' || ln_consolidation_set_id);
210:
211: p_deposit_start_date := ld_deposit_start_date;
212: p_deposit_end_date := ld_deposit_end_date;
213: p_payroll_id := ln_payroll_id;

Line 217: hr_utility.trace('Leaving get_DAxml_payroll_action');

213: p_payroll_id := ln_payroll_id;
214: p_assignment_set_id := ln_assignment_set_id;
215: p_consolidation_set_id := ln_consolidation_set_id;
216:
217: hr_utility.trace('Leaving get_DAxml_payroll_action');
218:
219: END get_DAxml_payroll_action;
220:
221: /********************************************************************

Line 351: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);

347:
348: lc_return_flag VARCHAR2(1);
349:
350: BEGIN
351: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);
352: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date));
353: hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
354: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);
355:

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

348: lc_return_flag VARCHAR2(1);
349:
350: BEGIN
351: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);
352: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date));
353: hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
354: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);
355:
356: lc_return_flag := 'N';

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

349:
350: BEGIN
351: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);
352: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date));
353: hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
354: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);
355:
356: lc_return_flag := 'N';
357: open c_nacha_run(p_prepayment_action_id,

Line 354: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);

350: BEGIN
351: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);
352: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date));
353: hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
354: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);
355:
356: lc_return_flag := 'N';
357: open c_nacha_run(p_prepayment_action_id,
358: p_deposit_start_date,

Line 424: hr_utility.trace('Entering check_if_qualified_for_US');

420: lv_rev_run_exists VARCHAR2(1);
421: BEGIN
422: --
423: --
424: hr_utility.trace('Entering check_if_qualified_for_US');
425:
426: OPEN c_prepay_arch_action(p_archive_action_id);
427: FETCH c_prepay_arch_action INTO ln_prepay_action_id;
428: IF c_prepay_arch_action%notfound THEN

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

435: END IF;
436: CLOSE c_prepay_arch_action;
437: --
438: --
439: hr_utility.trace('ln_prepay_action_id :='||ln_prepay_action_id);
440:
441: IF pay_us_employee_payslip_web.get_doc_eit(
442: 'PAYSLIP'
443: ,'PRINT'

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

586: ,p_assignment_set_id => ln_assignment_set_id
587: ,p_payroll_id => ln_payroll_id
588: ,p_consolidation_set_id => ln_consolidation_set_id);
589:
590: hr_utility.set_location('procdar archive',1);
591: open c_paid_actions(stperson, endperson,
592: ln_payroll_id,
593: ln_consolidation_set_id,
594: ld_deposit_start_date,

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

593: ln_consolidation_set_id,
594: ld_deposit_start_date,
595: ld_deposit_end_date);
596: loop
597: hr_utility.set_location('procdar archive',2);
598:
599: lc_asg_flag := 'N';
600:
601: fetch c_paid_actions into ln_nacha_action_id,

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

607: ln_assignment_set_id,
608: ln_assignment_id);
609:
610: IF lc_asg_flag = 'Y' THEN
611: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
612: ||to_char(ln_nacha_action_id));
613:
614:
615:

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

613:
614:
615:
616:
617: hr_utility.set_location('procdar archive',3);
618: select pay_assignment_actions_s.nextval
619: into ln_deposit_action_id
620: from dual;
621:

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

622: -- insert the action record.
623: hr_nonrun_asact.insact(ln_deposit_action_id,
624: ln_assignment_id,
625: pactid, chunk, ln_tax_unit_id);
626: hr_utility.trace('Inserted into paa');
627: -- insert an interlock to this action.
628: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
629:
630: update pay_assignment_Actions

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

635:
636: end loop;
637: close c_paid_actions;
638:
639: hr_utility.set_location('procdar archive',4);
640:
641: END archive_action_creation;
642:
643: /***********************************************************************

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

857: Zero_Pay_Flag Varchar2(1);
858: ln_person_id number;
859: lv_action_type varchar2(1);
860: BEGIN
861: hr_utility.set_location('procdar',1);
862:
863: -- Database Version --Bug 3331028
864: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
865: l_db_version := '/*+ RULE */';

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

874: ,p_assignment_set_id => l_asg_set_id
875: ,p_payroll_id => ln_payroll_id
876: ,p_consolidation_set_id => ln_consolidation_set_id);
877:
878: hr_utility.trace('pactid='||pactid);
879: hr_utility.trace('ln_payroll_id='||ln_payroll_id);
880: hr_utility.trace('ln_consolidation_set_id='||ln_consolidation_set_id);
881:
882: -- Query string for the reference cursor c_paid_actions

Line 879: hr_utility.trace('ln_payroll_id='||ln_payroll_id);

875: ,p_payroll_id => ln_payroll_id
876: ,p_consolidation_set_id => ln_consolidation_set_id);
877:
878: hr_utility.trace('pactid='||pactid);
879: hr_utility.trace('ln_payroll_id='||ln_payroll_id);
880: hr_utility.trace('ln_consolidation_set_id='||ln_consolidation_set_id);
881:
882: -- Query string for the reference cursor c_paid_actions
883: l_paid_actions := 'select distinct '||l_db_version||' act.assignment_action_id,

Line 880: hr_utility.trace('ln_consolidation_set_id='||ln_consolidation_set_id);

876: ,p_consolidation_set_id => ln_consolidation_set_id);
877:
878: hr_utility.trace('pactid='||pactid);
879: hr_utility.trace('ln_payroll_id='||ln_payroll_id);
880: hr_utility.trace('ln_consolidation_set_id='||ln_consolidation_set_id);
881:
882: -- Query string for the reference cursor c_paid_actions
883: l_paid_actions := 'select distinct '||l_db_version||' act.assignment_action_id,
884: act.assignment_id,

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

960: open c_paid_actions for l_paid_actions using pactid, stperson, endperson;
961: end if;
962: --
963: loop
964: hr_utility.set_location('procdar',2);
965: if l_asg_set_id is not null then
966: fetch c_actions_asg_set into ln_nacha_action_id, ln_assignment_id,
967: ln_tax_unit_id, ld_effective_date,
968: lv_action_type;

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

979: else
980: Zero_Pay_Flag := 'Y';
981: end if;
982:
983: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
984: ||to_char(ln_nacha_action_id));
985:
986: open c_pre_payments (ln_nacha_action_id);
987: fetch c_pre_payments into ln_pre_pymt_action_id;

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

985:
986: open c_pre_payments (ln_nacha_action_id);
987: fetch c_pre_payments into ln_pre_pymt_action_id;
988: close c_pre_payments;
989: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'
990: ||to_char(ln_pre_pymt_action_id));
991:
992: if Zero_Pay_Flag = 'N' then
993: hr_utility.trace(' Not a Zero Pay Assignment');

Line 993: hr_utility.trace(' Not a Zero Pay Assignment');

989: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'
990: ||to_char(ln_pre_pymt_action_id));
991:
992: if Zero_Pay_Flag = 'N' then
993: hr_utility.trace(' Not a Zero Pay Assignment');
994: /**************************************************************************
995: ** we need to insert atleast one action for each of the rows that we
996: ** return from the cursor (i.e. one for each assignment/pre-payment action).
997: **************************************************************************/

Line 998: hr_utility.trace(' ln_prev_pre_pymt_action_id is'

994: /**************************************************************************
995: ** we need to insert atleast one action for each of the rows that we
996: ** return from the cursor (i.e. one for each assignment/pre-payment action).
997: **************************************************************************/
998: hr_utility.trace(' ln_prev_pre_pymt_action_id is'
999: ||to_char(ln_prev_pre_pymt_action_id));
1000: if (ln_prev_pre_pymt_action_id is null or
1001: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1002: open c_payments (ln_pre_pymt_action_id, ld_effective_date);

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

1000: if (ln_prev_pre_pymt_action_id is null or
1001: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1002: open c_payments (ln_pre_pymt_action_id, ld_effective_date);
1003: loop
1004: hr_utility.set_location('procdar',99);
1005: fetch c_payments into ln_source_action_id;
1006: hr_utility.trace(' ln_source_action_id is'
1007: ||to_char(ln_source_action_id));
1008:

Line 1006: hr_utility.trace(' ln_source_action_id is'

1002: open c_payments (ln_pre_pymt_action_id, ld_effective_date);
1003: loop
1004: hr_utility.set_location('procdar',99);
1005: fetch c_payments into ln_source_action_id;
1006: hr_utility.trace(' ln_source_action_id is'
1007: ||to_char(ln_source_action_id));
1008:
1009: hr_utility.set_location('procdar',98);
1010: if c_payments%notfound then

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

1005: fetch c_payments into ln_source_action_id;
1006: hr_utility.trace(' ln_source_action_id is'
1007: ||to_char(ln_source_action_id));
1008:
1009: hr_utility.set_location('procdar',98);
1010: if c_payments%notfound then
1011: exit;
1012: end if;
1013: hr_utility.set_location('procdar',97);

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

1009: hr_utility.set_location('procdar',98);
1010: if c_payments%notfound then
1011: exit;
1012: end if;
1013: hr_utility.set_location('procdar',97);
1014: /**************************************************************
1015: ** we need to insert one action for each of the rows that we
1016: ** return from the cursor (i.e. one for each assignment/pre-payment source).
1017: **************************************************************/

Line 1018: hr_utility.trace(' ln_prev_source_action_id is'

1014: /**************************************************************
1015: ** we need to insert one action for each of the rows that we
1016: ** return from the cursor (i.e. one for each assignment/pre-payment source).
1017: **************************************************************/
1018: hr_utility.trace(' ln_prev_source_action_id is'
1019: ||to_char(ln_prev_source_action_id));
1020: if (ln_prev_source_action_id is null or
1021: ln_source_action_id <> ln_prev_source_action_id or
1022: ln_source_action_id is null) then

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

1020: if (ln_prev_source_action_id is null or
1021: ln_source_action_id <> ln_prev_source_action_id or
1022: ln_source_action_id is null) then
1023:
1024: hr_utility.set_location('procdar',3);
1025: select pay_assignment_actions_s.nextval
1026: into ln_deposit_action_id
1027: from dual;
1028:

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

1029: -- insert the action record.
1030: hr_nonrun_asact.insact(ln_deposit_action_id,
1031: ln_assignment_id,
1032: pactid, chunk, ln_tax_unit_id);
1033: hr_utility.trace('Inserted into paa');
1034: -- insert an interlock to this action.
1035: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
1036:
1037: hr_utility.trace('Inserted into interlock');

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

1033: hr_utility.trace('Inserted into paa');
1034: -- insert an interlock to this action.
1035: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
1036:
1037: hr_utility.trace('Inserted into interlock');
1038: if ln_source_action_id is not null then
1039: hr_utility.trace('serial number updated if loop ');
1040: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
1041: update pay_assignment_Actions

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

1035: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
1036:
1037: hr_utility.trace('Inserted into interlock');
1038: if ln_source_action_id is not null then
1039: hr_utility.trace('serial number updated if loop ');
1040: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
1041: update pay_assignment_Actions
1042: set serial_number = 'P'||ln_source_action_id
1043: where assignment_action_id = ln_deposit_action_id;

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

1036:
1037: hr_utility.trace('Inserted into interlock');
1038: if ln_source_action_id is not null then
1039: hr_utility.trace('serial number updated if loop ');
1040: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
1041: update pay_assignment_Actions
1042: set serial_number = 'P'||ln_source_action_id
1043: where assignment_action_id = ln_deposit_action_id;
1044: else

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

1041: update pay_assignment_Actions
1042: set serial_number = 'P'||ln_source_action_id
1043: where assignment_action_id = ln_deposit_action_id;
1044: else
1045: hr_utility.trace('serial number else ');
1046: open c_payroll_run (ln_pre_pymt_action_id);
1047: fetch c_payroll_run into ln_master_action_id;
1048: close c_payroll_run;
1049: hr_utility.trace(' ln_master_action_id is'

Line 1049: hr_utility.trace(' ln_master_action_id is'

1045: hr_utility.trace('serial number else ');
1046: open c_payroll_run (ln_pre_pymt_action_id);
1047: fetch c_payroll_run into ln_master_action_id;
1048: close c_payroll_run;
1049: hr_utility.trace(' ln_master_action_id is'
1050: ||to_char(ln_master_action_id));
1051:
1052: update pay_assignment_Actions
1053: set serial_number = 'M'||ln_master_action_id

Line 1064: hr_utility.trace('Zero Pay Assignment');

1060: close c_payments;
1061: ln_prev_pre_pymt_action_id := ln_pre_pymt_action_id;
1062: end if;
1063: elsif Zero_Pay_Flag = 'Y' then
1064: hr_utility.trace('Zero Pay Assignment');
1065: if (ln_prev_pre_pymt_action_id is null or
1066: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1067: hr_utility.set_location('procdar',6);
1068: select pay_assignment_actions_s.nextval

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

1063: elsif Zero_Pay_Flag = 'Y' then
1064: hr_utility.trace('Zero Pay Assignment');
1065: if (ln_prev_pre_pymt_action_id is null or
1066: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1067: hr_utility.set_location('procdar',6);
1068: select pay_assignment_actions_s.nextval
1069: into ln_deposit_action_id
1070: from dual;
1071:

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

1075: pactid, chunk, ln_tax_unit_id);
1076:
1077: -- insert an interlock to this action.
1078: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
1079: hr_utility.trace(' NZ Inserted into paa');
1080:
1081:
1082: open c_payroll_run (ln_nacha_action_id);
1083: fetch c_payroll_run into ln_master_action_id;

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

1086: update pay_assignment_Actions
1087: set serial_number = 'M'||ln_master_action_id
1088: where assignment_action_id = ln_deposit_action_id;
1089:
1090: hr_utility.trace(' NZ ln_master_action_id is'
1091: ||to_char(ln_master_action_id));
1092:
1093: -- skip till next pre payment action id
1094: ln_prev_pre_pymt_action_id := ln_pre_pymt_action_id;

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

1249: --
1250: --
1251:
1252: BEGIN
1253: hr_utility.trace('###### IN Qualifying Proc');
1254: --
1255: l_actid := pay_proc_environment_pkg.get_pactid;
1256: --
1257: ln_curr_payroll_act_id := l_actid;

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

1254: --
1255: l_actid := pay_proc_environment_pkg.get_pactid;
1256: --
1257: ln_curr_payroll_act_id := l_actid;
1258: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1259: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1260:
1261: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1262: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;

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

1255: l_actid := pay_proc_environment_pkg.get_pactid;
1256: --
1257: ln_curr_payroll_act_id := l_actid;
1258: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1259: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1260:
1261: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1262: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1263:

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

1273: ,l_effective_date
1274: ,l_business_group_id
1275: ,l_legislation_code);
1276:
1277: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1278: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1279: --hr_utility.trace('l_start_date :='||l_start_date);
1280: --hr_utility.trace('l_end_date :='||l_end_date);
1281: --hr_utility.trace('l_rep_group :='||l_rep_group);

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

1274: ,l_business_group_id
1275: ,l_legislation_code);
1276:
1277: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1278: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1279: --hr_utility.trace('l_start_date :='||l_start_date);
1280: --hr_utility.trace('l_end_date :='||l_end_date);
1281: --hr_utility.trace('l_rep_group :='||l_rep_group);
1282: --hr_utility.trace('l_rep_category :='||l_rep_category);

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

1275: ,l_legislation_code);
1276:
1277: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1278: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1279: --hr_utility.trace('l_start_date :='||l_start_date);
1280: --hr_utility.trace('l_end_date :='||l_end_date);
1281: --hr_utility.trace('l_rep_group :='||l_rep_group);
1282: --hr_utility.trace('l_rep_category :='||l_rep_category);
1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);

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

1276:
1277: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1278: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1279: --hr_utility.trace('l_start_date :='||l_start_date);
1280: --hr_utility.trace('l_end_date :='||l_end_date);
1281: --hr_utility.trace('l_rep_group :='||l_rep_group);
1282: --hr_utility.trace('l_rep_category :='||l_rep_category);
1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1284: --hr_utility.trace('l_assignment_id :='||l_assignment_id);

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

1277: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1278: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1279: --hr_utility.trace('l_start_date :='||l_start_date);
1280: --hr_utility.trace('l_end_date :='||l_end_date);
1281: --hr_utility.trace('l_rep_group :='||l_rep_group);
1282: --hr_utility.trace('l_rep_category :='||l_rep_category);
1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1284: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1285: --hr_utility.trace('l_effective_date :='||l_effective_date);

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

1278: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1279: --hr_utility.trace('l_start_date :='||l_start_date);
1280: --hr_utility.trace('l_end_date :='||l_end_date);
1281: --hr_utility.trace('l_rep_group :='||l_rep_group);
1282: --hr_utility.trace('l_rep_category :='||l_rep_category);
1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1284: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1285: --hr_utility.trace('l_effective_date :='||l_effective_date);
1286: --hr_utility.trace('l_business_group_id :='||l_business_group_id);

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

1279: --hr_utility.trace('l_start_date :='||l_start_date);
1280: --hr_utility.trace('l_end_date :='||l_end_date);
1281: --hr_utility.trace('l_rep_group :='||l_rep_group);
1282: --hr_utility.trace('l_rep_category :='||l_rep_category);
1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1284: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1285: --hr_utility.trace('l_effective_date :='||l_effective_date);
1286: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1287: --hr_utility.trace('l_legislation_code :='||l_legislation_code);

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

1280: --hr_utility.trace('l_end_date :='||l_end_date);
1281: --hr_utility.trace('l_rep_group :='||l_rep_group);
1282: --hr_utility.trace('l_rep_category :='||l_rep_category);
1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1284: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1285: --hr_utility.trace('l_effective_date :='||l_effective_date);
1286: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1287: --hr_utility.trace('l_legislation_code :='||l_legislation_code);
1288:

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

1281: --hr_utility.trace('l_rep_group :='||l_rep_group);
1282: --hr_utility.trace('l_rep_category :='||l_rep_category);
1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1284: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1285: --hr_utility.trace('l_effective_date :='||l_effective_date);
1286: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1287: --hr_utility.trace('l_legislation_code :='||l_legislation_code);
1288:
1289: --

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

1282: --hr_utility.trace('l_rep_category :='||l_rep_category);
1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1284: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1285: --hr_utility.trace('l_effective_date :='||l_effective_date);
1286: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1287: --hr_utility.trace('l_legislation_code :='||l_legislation_code);
1288:
1289: --
1290: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');

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

1283: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1284: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1285: --hr_utility.trace('l_effective_date :='||l_effective_date);
1286: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1287: --hr_utility.trace('l_legislation_code :='||l_legislation_code);
1288:
1289: --
1290: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
1291: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');

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

1308: --
1309: DECLARE
1310: BEGIN
1311: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
1312: --hr_utility.trace(statem);
1313: sql_cur := dbms_sql.open_cursor;
1314: dbms_sql.parse(sql_cur
1315: ,statem
1316: ,dbms_sql.v7);

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

1330: END IF;
1331: END;
1332: --
1333: --
1334: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1335: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1336:
1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id

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

1331: END;
1332: --
1333: --
1334: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1335: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1336:
1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id

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

1358: ,pay_us_deposit_advice_pkg.g_end_dt
1359: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1360:
1361: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1362: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1363:
1364: END IF;
1365: END IF;
1366:

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

1392: ,pay_us_deposit_advice_pkg.g_end_dt
1393: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1394:
1395: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1396: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1397: END IF;
1398: END IF;
1399:
1400: END LOOP;

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

1405:
1406: l_qualifier := 'N';
1407: k := 1;
1408:
1409: hr_utility.trace('g_tmp_tbl.COUNT := ' || g_tmp_tbl.COUNT);
1410:
1411: IF g_tmp_tbl.EXISTS(p_assignment_id) THEN
1412: l_qualifier := 'Y';
1413: END IF;

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

1411: IF g_tmp_tbl.EXISTS(p_assignment_id) THEN
1412: l_qualifier := 'Y';
1413: END IF;
1414:
1415: hr_utility.trace('B4 Return l_qualifier := ' || l_qualifier);
1416:
1417:
1418: IF l_qualifier = 'Y' THEN
1419: p_qualifier := 'Y' ;

Line 1452: hr_utility.trace('Entering into Func DAxml_range_cursor');

1448: lv_legislation_code VARCHAR2(10);
1449: lv_sqlstr VARCHAR2(32000);
1450:
1451: BEGIN
1452: hr_utility.trace('Entering into Func DAxml_range_cursor');
1453: get_DAxml_payroll_action(p_payroll_action_id => pactid
1454: ,p_deposit_start_date => ld_deposit_start_date
1455: ,p_deposit_end_date => ld_deposit_end_date
1456: ,p_assignment_set_id => ln_assignment_set_id

Line 1460: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);

1456: ,p_assignment_set_id => ln_assignment_set_id
1457: ,p_payroll_id => ln_payroll_id
1458: ,p_consolidation_set_id => ln_consolidation_set_id);
1459:
1460: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1461: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1462: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1463: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1464: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);

Line 1461: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);

1457: ,p_payroll_id => ln_payroll_id
1458: ,p_consolidation_set_id => ln_consolidation_set_id);
1459:
1460: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1461: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1462: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1463: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1464: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);
1465: --

Line 1462: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);

1458: ,p_consolidation_set_id => ln_consolidation_set_id);
1459:
1460: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1461: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1462: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1463: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1464: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);
1465: --
1466: --

Line 1463: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);

1459:
1460: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1461: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1462: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1463: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1464: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);
1465: --
1466: --
1467:

Line 1464: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);

1460: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1461: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1462: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1463: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1464: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);
1465: --
1466: --
1467:
1468: --Database Version --Bug 3331028

Line 1547: hr_utility.trace('lv_sqlstr := ' || lv_sqlstr);

1543: end if; -- ln_assignment_set_id NOT NULL
1544:
1545: end if;
1546:
1547: hr_utility.trace('lv_sqlstr := ' || lv_sqlstr);
1548:
1549: psqlstr := lv_sqlstr;
1550:
1551: end DAxml_range_cursor;