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

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

187: ld_deposit_start_date DATE;
188: ld_deposit_end_date DATE;
189:
190: BEGIN
191: hr_utility.trace('Entering get_DAxml_payroll_action');
192: open c_get_payroll_action(p_payroll_action_id);
193: fetch c_get_payroll_action into lv_legislative_parameters,
194: ld_deposit_start_date,
195: ld_deposit_end_date;

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

192: open c_get_payroll_action(p_payroll_action_id);
193: fetch c_get_payroll_action into lv_legislative_parameters,
194: ld_deposit_start_date,
195: ld_deposit_end_date;
196: hr_utility.trace('lv_legislative_parameters := ' || lv_legislative_parameters);
197: hr_utility.trace('ld_deposit_start_date := ' || TO_CHAR(ld_deposit_start_date));
198: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));
199:
200: close c_get_payroll_action;

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

193: fetch c_get_payroll_action into lv_legislative_parameters,
194: ld_deposit_start_date,
195: ld_deposit_end_date;
196: hr_utility.trace('lv_legislative_parameters := ' || lv_legislative_parameters);
197: hr_utility.trace('ld_deposit_start_date := ' || TO_CHAR(ld_deposit_start_date));
198: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));
199:
200: close c_get_payroll_action;
201:

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

194: ld_deposit_start_date,
195: ld_deposit_end_date;
196: hr_utility.trace('lv_legislative_parameters := ' || lv_legislative_parameters);
197: hr_utility.trace('ld_deposit_start_date := ' || TO_CHAR(ld_deposit_start_date));
198: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));
199:
200: close c_get_payroll_action;
201:
202: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(

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

208: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
209: 'CONSOLIDATION_SET_ID',
210: lv_legislative_parameters);
211:
212: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);
213: hr_utility.trace('ln_payroll_id := ' || ln_payroll_id);
214: hr_utility.trace('ln_consolidation_set_id := ' || ln_consolidation_set_id);
215:
216: p_deposit_start_date := ld_deposit_start_date;

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

209: 'CONSOLIDATION_SET_ID',
210: lv_legislative_parameters);
211:
212: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);
213: hr_utility.trace('ln_payroll_id := ' || ln_payroll_id);
214: hr_utility.trace('ln_consolidation_set_id := ' || ln_consolidation_set_id);
215:
216: p_deposit_start_date := ld_deposit_start_date;
217: p_deposit_end_date := ld_deposit_end_date;

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

210: lv_legislative_parameters);
211:
212: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);
213: hr_utility.trace('ln_payroll_id := ' || ln_payroll_id);
214: hr_utility.trace('ln_consolidation_set_id := ' || ln_consolidation_set_id);
215:
216: p_deposit_start_date := ld_deposit_start_date;
217: p_deposit_end_date := ld_deposit_end_date;
218: p_payroll_id := ln_payroll_id;

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

218: p_payroll_id := ln_payroll_id;
219: p_assignment_set_id := ln_assignment_set_id;
220: p_consolidation_set_id := ln_consolidation_set_id;
221:
222: hr_utility.trace('Leaving get_DAxml_payroll_action');
223:
224: END get_DAxml_payroll_action;
225:
226: /********************************************************************

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

352:
353: lc_return_flag VARCHAR2(1);
354:
355: BEGIN
356: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);
357: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date));
358: hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
359: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);
360:

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

353: lc_return_flag VARCHAR2(1);
354:
355: BEGIN
356: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);
357: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date));
358: hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
359: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);
360:
361: lc_return_flag := 'N';

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

354:
355: BEGIN
356: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);
357: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date));
358: hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
359: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);
360:
361: lc_return_flag := 'N';
362: open c_nacha_run(p_prepayment_action_id,

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

355: BEGIN
356: hr_utility.trace(' p_prepayment_action_id '|| p_prepayment_action_id);
357: hr_utility.trace(' p_deposit_start_date ' || to_char(p_deposit_start_date));
358: hr_utility.trace(' p_deposit_end_date ' || to_char(p_deposit_end_date));
359: hr_utility.trace(' p_consolidation_set_id '|| p_consolidation_set_id);
360:
361: lc_return_flag := 'N';
362: open c_nacha_run(p_prepayment_action_id,
363: p_deposit_start_date,

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

425: lv_rev_run_exists VARCHAR2(1);
426: BEGIN
427: --
428: --
429: hr_utility.trace('Entering check_if_qualified_for_US');
430:
431: OPEN c_prepay_arch_action(p_archive_action_id);
432: FETCH c_prepay_arch_action INTO ln_prepay_action_id;
433: IF c_prepay_arch_action%notfound THEN

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

440: END IF;
441: CLOSE c_prepay_arch_action;
442: --
443: --
444: hr_utility.trace('ln_prepay_action_id :='||ln_prepay_action_id);
445:
446: IF pay_us_employee_payslip_web.get_doc_eit(
447: 'PAYSLIP'
448: ,'PRINT'

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

593: ,p_assignment_set_id => ln_assignment_set_id
594: ,p_payroll_id => ln_payroll_id
595: ,p_consolidation_set_id => ln_consolidation_set_id);
596:
597: hr_utility.set_location('procdar archive',1);
598: hr_utility.trace('stperson:'||stperson||',endperson:'||endperson||',ln_payroll_id:'||ln_payroll_id||
599: ',ln_consolidation_set_id:'||ln_consolidation_set_id||',ld_deposit_start_date:'||
600: ld_deposit_start_date||',ld_deposit_end_date:'||ld_deposit_end_date);
601: open c_paid_actions(stperson, endperson,

Line 598: hr_utility.trace('stperson:'||stperson||',endperson:'||endperson||',ln_payroll_id:'||ln_payroll_id||

594: ,p_payroll_id => ln_payroll_id
595: ,p_consolidation_set_id => ln_consolidation_set_id);
596:
597: hr_utility.set_location('procdar archive',1);
598: hr_utility.trace('stperson:'||stperson||',endperson:'||endperson||',ln_payroll_id:'||ln_payroll_id||
599: ',ln_consolidation_set_id:'||ln_consolidation_set_id||',ld_deposit_start_date:'||
600: ld_deposit_start_date||',ld_deposit_end_date:'||ld_deposit_end_date);
601: open c_paid_actions(stperson, endperson,
602: ln_payroll_id,

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

603: ln_consolidation_set_id,
604: ld_deposit_start_date,
605: ld_deposit_end_date);
606: loop
607: hr_utility.set_location('procdar archive',2);
608:
609: lc_asg_flag := 'N';
610:
611: fetch c_paid_actions into ln_nacha_action_id,

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

617: ln_assignment_set_id,
618: ln_assignment_id);
619:
620: IF lc_asg_flag = 'Y' THEN
621: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
622: ||to_char(ln_nacha_action_id));
623:
624:
625:

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

623:
624:
625:
626:
627: hr_utility.set_location('procdar archive',3);
628: select pay_assignment_actions_s.nextval
629: into ln_deposit_action_id
630: from dual;
631:

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

632: -- insert the action record.
633: hr_nonrun_asact.insact(ln_deposit_action_id,
634: ln_assignment_id,
635: pactid, chunk, ln_tax_unit_id);
636: hr_utility.trace('Inserted into paa');
637: -- insert an interlock to this action.
638: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
639:
640: update pay_assignment_Actions

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

645:
646: end loop;
647: close c_paid_actions;
648:
649: hr_utility.set_location('procdar archive',4);
650:
651: END archive_action_creation;
652:
653: /***********************************************************************

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

867: Zero_Pay_Flag Varchar2(1);
868: ln_person_id number;
869: lv_action_type varchar2(1);
870: BEGIN
871: hr_utility.set_location('procdar',1);
872:
873: -- Database Version --Bug 3331028
874: if (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) then
875: l_db_version := '/*+ RULE */';

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

884: ,p_assignment_set_id => l_asg_set_id
885: ,p_payroll_id => ln_payroll_id
886: ,p_consolidation_set_id => ln_consolidation_set_id);
887:
888: hr_utility.trace('pactid='||pactid);
889: hr_utility.trace('ln_payroll_id='||ln_payroll_id);
890: hr_utility.trace('ln_consolidation_set_id='||ln_consolidation_set_id);
891:
892: -- Query string for the reference cursor c_paid_actions

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

885: ,p_payroll_id => ln_payroll_id
886: ,p_consolidation_set_id => ln_consolidation_set_id);
887:
888: hr_utility.trace('pactid='||pactid);
889: hr_utility.trace('ln_payroll_id='||ln_payroll_id);
890: hr_utility.trace('ln_consolidation_set_id='||ln_consolidation_set_id);
891:
892: -- Query string for the reference cursor c_paid_actions
893: l_paid_actions := 'select distinct '||l_db_version||' act.assignment_action_id,

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

886: ,p_consolidation_set_id => ln_consolidation_set_id);
887:
888: hr_utility.trace('pactid='||pactid);
889: hr_utility.trace('ln_payroll_id='||ln_payroll_id);
890: hr_utility.trace('ln_consolidation_set_id='||ln_consolidation_set_id);
891:
892: -- Query string for the reference cursor c_paid_actions
893: l_paid_actions := 'select distinct '||l_db_version||' act.assignment_action_id,
894: act.assignment_id,

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

970: open c_paid_actions for l_paid_actions using pactid, stperson, endperson;
971: end if;
972: --
973: loop
974: hr_utility.set_location('procdar',2);
975: if l_asg_set_id is not null then
976: fetch c_actions_asg_set into ln_nacha_action_id, ln_assignment_id,
977: ln_tax_unit_id, ld_effective_date,
978: lv_action_type;

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

989: else
990: Zero_Pay_Flag := 'Y';
991: end if;
992:
993: hr_utility.trace(' c_paid_actions.ln_nacha_action_id is'
994: ||to_char(ln_nacha_action_id));
995:
996: open c_pre_payments (ln_nacha_action_id);
997: fetch c_pre_payments into ln_pre_pymt_action_id;

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

995:
996: open c_pre_payments (ln_nacha_action_id);
997: fetch c_pre_payments into ln_pre_pymt_action_id;
998: close c_pre_payments;
999: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'
1000: ||to_char(ln_pre_pymt_action_id));
1001:
1002: if Zero_Pay_Flag = 'N' then
1003: hr_utility.trace(' Not a Zero Pay Assignment');

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

999: hr_utility.trace(' c_pre_payments.ln_pre_pymt_action_id is'
1000: ||to_char(ln_pre_pymt_action_id));
1001:
1002: if Zero_Pay_Flag = 'N' then
1003: hr_utility.trace(' Not a Zero Pay Assignment');
1004: /**************************************************************************
1005: ** we need to insert atleast one action for each of the rows that we
1006: ** return from the cursor (i.e. one for each assignment/pre-payment action).
1007: **************************************************************************/

Line 1008: hr_utility.trace(' ln_prev_pre_pymt_action_id is'

1004: /**************************************************************************
1005: ** we need to insert atleast one action for each of the rows that we
1006: ** return from the cursor (i.e. one for each assignment/pre-payment action).
1007: **************************************************************************/
1008: hr_utility.trace(' ln_prev_pre_pymt_action_id is'
1009: ||to_char(ln_prev_pre_pymt_action_id));
1010: if (ln_prev_pre_pymt_action_id is null or
1011: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1012: open c_payments (ln_pre_pymt_action_id, ld_effective_date);

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

1010: if (ln_prev_pre_pymt_action_id is null or
1011: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1012: open c_payments (ln_pre_pymt_action_id, ld_effective_date);
1013: loop
1014: hr_utility.set_location('procdar',99);
1015: fetch c_payments into ln_source_action_id;
1016: hr_utility.trace(' ln_source_action_id is'
1017: ||to_char(ln_source_action_id));
1018:

Line 1016: hr_utility.trace(' ln_source_action_id is'

1012: open c_payments (ln_pre_pymt_action_id, ld_effective_date);
1013: loop
1014: hr_utility.set_location('procdar',99);
1015: fetch c_payments into ln_source_action_id;
1016: hr_utility.trace(' ln_source_action_id is'
1017: ||to_char(ln_source_action_id));
1018:
1019: hr_utility.set_location('procdar',98);
1020: if c_payments%notfound then

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

1015: fetch c_payments into ln_source_action_id;
1016: hr_utility.trace(' ln_source_action_id is'
1017: ||to_char(ln_source_action_id));
1018:
1019: hr_utility.set_location('procdar',98);
1020: if c_payments%notfound then
1021: exit;
1022: end if;
1023: hr_utility.set_location('procdar',97);

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

1019: hr_utility.set_location('procdar',98);
1020: if c_payments%notfound then
1021: exit;
1022: end if;
1023: hr_utility.set_location('procdar',97);
1024: /**************************************************************
1025: ** we need to insert one action for each of the rows that we
1026: ** return from the cursor (i.e. one for each assignment/pre-payment source).
1027: **************************************************************/

Line 1028: hr_utility.trace(' ln_prev_source_action_id is'

1024: /**************************************************************
1025: ** we need to insert one action for each of the rows that we
1026: ** return from the cursor (i.e. one for each assignment/pre-payment source).
1027: **************************************************************/
1028: hr_utility.trace(' ln_prev_source_action_id is'
1029: ||to_char(ln_prev_source_action_id));
1030: if (ln_prev_source_action_id is null or
1031: ln_source_action_id <> ln_prev_source_action_id or
1032: ln_source_action_id is null) then

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

1030: if (ln_prev_source_action_id is null or
1031: ln_source_action_id <> ln_prev_source_action_id or
1032: ln_source_action_id is null) then
1033:
1034: hr_utility.set_location('procdar',3);
1035: select pay_assignment_actions_s.nextval
1036: into ln_deposit_action_id
1037: from dual;
1038:

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

1039: -- insert the action record.
1040: hr_nonrun_asact.insact(ln_deposit_action_id,
1041: ln_assignment_id,
1042: pactid, chunk, ln_tax_unit_id);
1043: hr_utility.trace('Inserted into paa');
1044: -- insert an interlock to this action.
1045: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
1046:
1047: hr_utility.trace('Inserted into interlock');

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

1043: hr_utility.trace('Inserted into paa');
1044: -- insert an interlock to this action.
1045: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
1046:
1047: hr_utility.trace('Inserted into interlock');
1048: if ln_source_action_id is not null then
1049: hr_utility.trace('serial number updated if loop ');
1050: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
1051: update pay_assignment_Actions

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

1045: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
1046:
1047: hr_utility.trace('Inserted into interlock');
1048: if ln_source_action_id is not null then
1049: hr_utility.trace('serial number updated if loop ');
1050: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
1051: update pay_assignment_Actions
1052: set serial_number = 'P'||ln_source_action_id
1053: where assignment_action_id = ln_deposit_action_id;

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

1046:
1047: hr_utility.trace('Inserted into interlock');
1048: if ln_source_action_id is not null then
1049: hr_utility.trace('serial number updated if loop ');
1050: hr_utility.trace('serial number is '||to_char(ln_source_action_id));
1051: update pay_assignment_Actions
1052: set serial_number = 'P'||ln_source_action_id
1053: where assignment_action_id = ln_deposit_action_id;
1054: else

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

1051: update pay_assignment_Actions
1052: set serial_number = 'P'||ln_source_action_id
1053: where assignment_action_id = ln_deposit_action_id;
1054: else
1055: hr_utility.trace('serial number else ');
1056: open c_payroll_run (ln_pre_pymt_action_id);
1057: fetch c_payroll_run into ln_master_action_id;
1058: close c_payroll_run;
1059: hr_utility.trace(' ln_master_action_id is'

Line 1059: hr_utility.trace(' ln_master_action_id is'

1055: hr_utility.trace('serial number else ');
1056: open c_payroll_run (ln_pre_pymt_action_id);
1057: fetch c_payroll_run into ln_master_action_id;
1058: close c_payroll_run;
1059: hr_utility.trace(' ln_master_action_id is'
1060: ||to_char(ln_master_action_id));
1061:
1062: update pay_assignment_Actions
1063: set serial_number = 'M'||ln_master_action_id

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

1070: close c_payments;
1071: ln_prev_pre_pymt_action_id := ln_pre_pymt_action_id;
1072: end if;
1073: elsif Zero_Pay_Flag = 'Y' then
1074: hr_utility.trace('Zero Pay Assignment');
1075: if (ln_prev_pre_pymt_action_id is null or
1076: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1077: hr_utility.set_location('procdar',6);
1078: select pay_assignment_actions_s.nextval

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

1073: elsif Zero_Pay_Flag = 'Y' then
1074: hr_utility.trace('Zero Pay Assignment');
1075: if (ln_prev_pre_pymt_action_id is null or
1076: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1077: hr_utility.set_location('procdar',6);
1078: select pay_assignment_actions_s.nextval
1079: into ln_deposit_action_id
1080: from dual;
1081:

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

1085: pactid, chunk, ln_tax_unit_id);
1086:
1087: -- insert an interlock to this action.
1088: hr_nonrun_asact.insint(ln_deposit_action_id, ln_nacha_action_id);
1089: hr_utility.trace(' NZ Inserted into paa');
1090:
1091:
1092: open c_payroll_run (ln_nacha_action_id);
1093: fetch c_payroll_run into ln_master_action_id;

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

1096: update pay_assignment_Actions
1097: set serial_number = 'M'||ln_master_action_id
1098: where assignment_action_id = ln_deposit_action_id;
1099:
1100: hr_utility.trace(' NZ ln_master_action_id is'
1101: ||to_char(ln_master_action_id));
1102:
1103: -- skip till next pre payment action id
1104: ln_prev_pre_pymt_action_id := ln_pre_pymt_action_id;

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

1259: --
1260: --
1261:
1262: BEGIN
1263: hr_utility.trace('###### IN Qualifying Proc');
1264: --
1265: l_actid := pay_proc_environment_pkg.get_pactid;
1266: --
1267: ln_curr_payroll_act_id := l_actid;

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

1264: --
1265: l_actid := pay_proc_environment_pkg.get_pactid;
1266: --
1267: ln_curr_payroll_act_id := l_actid;
1268: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1269: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1270:
1271: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1272: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;

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

1265: l_actid := pay_proc_environment_pkg.get_pactid;
1266: --
1267: ln_curr_payroll_act_id := l_actid;
1268: hr_utility.trace('In QualProc l_actid := ' || l_actid);
1269: hr_utility.trace('p_assignment_id := ' || p_assignment_id);
1270:
1271: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1272: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1273:

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

1283: ,l_effective_date
1284: ,l_business_group_id
1285: ,l_legislation_code);
1286:
1287: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1288: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1289: --hr_utility.trace('l_start_date :='||l_start_date);
1290: --hr_utility.trace('l_end_date :='||l_end_date);
1291: --hr_utility.trace('l_rep_group :='||l_rep_group);

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

1284: ,l_business_group_id
1285: ,l_legislation_code);
1286:
1287: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1288: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1289: --hr_utility.trace('l_start_date :='||l_start_date);
1290: --hr_utility.trace('l_end_date :='||l_end_date);
1291: --hr_utility.trace('l_rep_group :='||l_rep_group);
1292: --hr_utility.trace('l_rep_category :='||l_rep_category);

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

1285: ,l_legislation_code);
1286:
1287: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1288: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1289: --hr_utility.trace('l_start_date :='||l_start_date);
1290: --hr_utility.trace('l_end_date :='||l_end_date);
1291: --hr_utility.trace('l_rep_group :='||l_rep_group);
1292: --hr_utility.trace('l_rep_category :='||l_rep_category);
1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);

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

1286:
1287: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1288: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1289: --hr_utility.trace('l_start_date :='||l_start_date);
1290: --hr_utility.trace('l_end_date :='||l_end_date);
1291: --hr_utility.trace('l_rep_group :='||l_rep_group);
1292: --hr_utility.trace('l_rep_category :='||l_rep_category);
1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1294: --hr_utility.trace('l_assignment_id :='||l_assignment_id);

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

1287: --hr_utility.trace('l_payroll_id :='||l_payroll_id);
1288: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1289: --hr_utility.trace('l_start_date :='||l_start_date);
1290: --hr_utility.trace('l_end_date :='||l_end_date);
1291: --hr_utility.trace('l_rep_group :='||l_rep_group);
1292: --hr_utility.trace('l_rep_category :='||l_rep_category);
1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1294: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1295: --hr_utility.trace('l_effective_date :='||l_effective_date);

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

1288: --hr_utility.trace('l_consolidation_set_id :='||l_consolidation_set_id);
1289: --hr_utility.trace('l_start_date :='||l_start_date);
1290: --hr_utility.trace('l_end_date :='||l_end_date);
1291: --hr_utility.trace('l_rep_group :='||l_rep_group);
1292: --hr_utility.trace('l_rep_category :='||l_rep_category);
1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1294: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1295: --hr_utility.trace('l_effective_date :='||l_effective_date);
1296: --hr_utility.trace('l_business_group_id :='||l_business_group_id);

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

1289: --hr_utility.trace('l_start_date :='||l_start_date);
1290: --hr_utility.trace('l_end_date :='||l_end_date);
1291: --hr_utility.trace('l_rep_group :='||l_rep_group);
1292: --hr_utility.trace('l_rep_category :='||l_rep_category);
1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1294: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1295: --hr_utility.trace('l_effective_date :='||l_effective_date);
1296: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1297: --hr_utility.trace('l_legislation_code :='||l_legislation_code);

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

1290: --hr_utility.trace('l_end_date :='||l_end_date);
1291: --hr_utility.trace('l_rep_group :='||l_rep_group);
1292: --hr_utility.trace('l_rep_category :='||l_rep_category);
1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1294: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1295: --hr_utility.trace('l_effective_date :='||l_effective_date);
1296: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1297: --hr_utility.trace('l_legislation_code :='||l_legislation_code);
1298:

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

1291: --hr_utility.trace('l_rep_group :='||l_rep_group);
1292: --hr_utility.trace('l_rep_category :='||l_rep_category);
1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1294: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1295: --hr_utility.trace('l_effective_date :='||l_effective_date);
1296: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1297: --hr_utility.trace('l_legislation_code :='||l_legislation_code);
1298:
1299: --

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

1292: --hr_utility.trace('l_rep_category :='||l_rep_category);
1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1294: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1295: --hr_utility.trace('l_effective_date :='||l_effective_date);
1296: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1297: --hr_utility.trace('l_legislation_code :='||l_legislation_code);
1298:
1299: --
1300: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');

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

1293: --hr_utility.trace('l_assignment_set_id :='||l_assignment_set_id);
1294: --hr_utility.trace('l_assignment_id :='||l_assignment_id);
1295: --hr_utility.trace('l_effective_date :='||l_effective_date);
1296: --hr_utility.trace('l_business_group_id :='||l_business_group_id);
1297: --hr_utility.trace('l_legislation_code :='||l_legislation_code);
1298:
1299: --
1300: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
1301: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');

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

1318: --
1319: DECLARE
1320: BEGIN
1321: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
1322: --hr_utility.trace(statem);
1323: sql_cur := dbms_sql.open_cursor;
1324: dbms_sql.parse(sql_cur
1325: ,statem
1326: ,dbms_sql.v7);

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

1340: END IF;
1341: END;
1342: --
1343: --
1344: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1345: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1346:
1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id

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

1341: END;
1342: --
1343: --
1344: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1345: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1346:
1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id

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

1368: ,pay_us_deposit_advice_pkg.g_end_dt
1369: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1370:
1371: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1372: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1373:
1374: END IF;
1375: END IF;
1376:

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

1402: ,pay_us_deposit_advice_pkg.g_end_dt
1403: ,pay_us_deposit_advice_pkg.g_consolidation_set_id) = 'Y' THEN
1404:
1405: g_tmp_tbl(ln_assignment_id) := ln_assignment_id;
1406: hr_utility.trace('g_tmp_tbl(' || ln_assignment_id || ') := ' || ln_assignment_id);
1407: END IF;
1408: END IF;
1409:
1410: END LOOP;

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

1415:
1416: l_qualifier := 'N';
1417: k := 1;
1418:
1419: hr_utility.trace('g_tmp_tbl.COUNT := ' || g_tmp_tbl.COUNT);
1420:
1421: IF g_tmp_tbl.EXISTS(p_assignment_id) THEN
1422: l_qualifier := 'Y';
1423: END IF;

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

1421: IF g_tmp_tbl.EXISTS(p_assignment_id) THEN
1422: l_qualifier := 'Y';
1423: END IF;
1424:
1425: hr_utility.trace('B4 Return l_qualifier := ' || l_qualifier);
1426:
1427:
1428: IF l_qualifier = 'Y' THEN
1429: p_qualifier := 'Y' ;

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

1458: lv_legislation_code VARCHAR2(10);
1459: lv_sqlstr VARCHAR2(32000);
1460:
1461: BEGIN
1462: hr_utility.trace('Entering into Func DAxml_range_cursor');
1463: get_DAxml_payroll_action(p_payroll_action_id => pactid
1464: ,p_deposit_start_date => ld_deposit_start_date
1465: ,p_deposit_end_date => ld_deposit_end_date
1466: ,p_assignment_set_id => ln_assignment_set_id

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

1466: ,p_assignment_set_id => ln_assignment_set_id
1467: ,p_payroll_id => ln_payroll_id
1468: ,p_consolidation_set_id => ln_consolidation_set_id);
1469:
1470: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1471: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1472: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1473: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1474: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);

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

1467: ,p_payroll_id => ln_payroll_id
1468: ,p_consolidation_set_id => ln_consolidation_set_id);
1469:
1470: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1471: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1472: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1473: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1474: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);
1475: --

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

1468: ,p_consolidation_set_id => ln_consolidation_set_id);
1469:
1470: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1471: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1472: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1473: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1474: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);
1475: --
1476: --

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

1469:
1470: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1471: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1472: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1473: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1474: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);
1475: --
1476: --
1477:

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

1470: hr_utility.trace('ln_payroll_id :='||ln_payroll_id);
1471: hr_utility.trace('ln_consolidation_set_id :='||ln_consolidation_set_id);
1472: hr_utility.trace('ld_deposit_start_date :='||ld_deposit_start_date);
1473: hr_utility.trace('ld_deposit_end_date :='||ld_deposit_end_date);
1474: hr_utility.trace('ln_assignment_set_id :='||ln_assignment_set_id);
1475: --
1476: --
1477:
1478: --Database Version --Bug 3331028

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

1553: end if; -- ln_assignment_set_id NOT NULL
1554:
1555: end if;
1556:
1557: hr_utility.trace('lv_sqlstr := ' || lv_sqlstr);
1558:
1559: psqlstr := lv_sqlstr;
1560:
1561: end DAxml_range_cursor;