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

Line 145: -- hr_utility.trace_on('Y','GTN');

141: l_payroll_text varchar2(70);
142: --
143: begin
144:
145: -- hr_utility.trace_on('Y','GTN');
146: hr_utility.trace('reached range_cursor');
147:
148:
149: select ppa.legislative_parameters,

Line 146: hr_utility.trace('reached range_cursor');

142: --
143: begin
144:
145: -- hr_utility.trace_on('Y','GTN');
146: hr_utility.trace('reached range_cursor');
147:
148:
149: select ppa.legislative_parameters,
150: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),

Line 201: hr_utility.trace('leaving range_cursor');

197: asg.effective_start_date and asg.effective_end_date
198: and asg.business_group_id +0 = ppa_gen.business_group_id
199: order by asg.person_id';
200:
201: hr_utility.trace('leaving range_cursor');
202:
203: end range_cursor;
204: ---------------------------------- action_creation ----------------------------------
205: --

Line 291: --hr_utility.trace_on('Y','ORACLE');

287: -- algorithm is quite similar to the other process cases,
288: -- but we have to take into account assignments and
289: -- personal payment methods.
290: begin
291: --hr_utility.trace_on('Y','ORACLE');
292: hr_utility.trace('entering action_creation');
293: hr_utility.set_location('procpyr',1);
294: open c_parameters(pactid);
295:

Line 292: hr_utility.trace('entering action_creation');

288: -- but we have to take into account assignments and
289: -- personal payment methods.
290: begin
291: --hr_utility.trace_on('Y','ORACLE');
292: hr_utility.trace('entering action_creation');
293: hr_utility.set_location('procpyr',1);
294: open c_parameters(pactid);
295:
296: --Bug 3364759 -- Fetced the values of the cursors in the variables l_business_group_id, l_start_date, l_effective_date

Line 293: hr_utility.set_location('procpyr',1);

289: -- personal payment methods.
290: begin
291: --hr_utility.trace_on('Y','ORACLE');
292: hr_utility.trace('entering action_creation');
293: hr_utility.set_location('procpyr',1);
294: open c_parameters(pactid);
295:
296: --Bug 3364759 -- Fetced the values of the cursors in the variables l_business_group_id, l_start_date, l_effective_date
297: -- as well.

Line 317: hr_utility.trace('Error getting defined balance id');

313: and ue.user_entity_id = di.user_entity_id
314: and ue.creator_type = 'B'
315: and nvl(ue.legislation_code,'US') = 'US';
316: exception when others then
317: hr_utility.trace('Error getting defined balance id');
318: raise;
319: end;
320:
321: begin

Line 331: hr_utility.trace('Error getting defined balance id');

327: and ue.user_entity_id = di.user_entity_id
328: and ue.creator_type = 'B'
329: and nvl(ue.legislation_code,'US') = 'US';
330: exception when others then
331: hr_utility.trace('Error getting defined balance id');
332: raise;
333: end;
334: */
335:

Line 336: hr_utility.set_location('procpyr',1);

332: raise;
333: end;
334: */
335:
336: hr_utility.set_location('procpyr',1);
337: open c_actions(pactid,stperson,endperson);
338: num := 0;
339: loop
340: hr_utility.set_location('procpyr',2);

Line 340: hr_utility.set_location('procpyr',2);

336: hr_utility.set_location('procpyr',1);
337: open c_actions(pactid,stperson,endperson);
338: num := 0;
339: loop
340: hr_utility.set_location('procpyr',2);
341: fetch c_actions into action_type,lockedactid,assignid,greid;
342: if c_actions%found then num := num + 1; end if;
343: exit when c_actions%notfound;
344: --

Line 389: hr_utility.set_location('procpyr',3);

385:
386:
387: null;
388: else
389: hr_utility.set_location('procpyr',3);
390: select pay_assignment_actions_s.nextval
391: into lockingactid
392: from dual;
393: --

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

403: end if;
404: --
405: end loop;
406: close c_actions;
407: hr_utility.trace('leaving action_creation');
408: end action_create_bra;
409:
410: ---------------------------------- action_creation ----------------------------------
411: --

Line 497: --hr_utility.trace_on('Y','ORACLE');

493: -- algorithm is quite similar to the other process cases,
494: -- but we have to take into account assignments and
495: -- personal payment methods.
496: begin
497: --hr_utility.trace_on('Y','ORACLE');
498: hr_utility.trace('entering action_creation');
499: hr_utility.set_location('procpyr',1);
500: open c_parameters(pactid);
501:

Line 498: hr_utility.trace('entering action_creation');

494: -- but we have to take into account assignments and
495: -- personal payment methods.
496: begin
497: --hr_utility.trace_on('Y','ORACLE');
498: hr_utility.trace('entering action_creation');
499: hr_utility.set_location('procpyr',1);
500: open c_parameters(pactid);
501:
502: --Bug 3364759 -- Fetced the values of the cursors in the variables l_business_group_id, l_start_date, l_effective_date

Line 499: hr_utility.set_location('procpyr',1);

495: -- personal payment methods.
496: begin
497: --hr_utility.trace_on('Y','ORACLE');
498: hr_utility.trace('entering action_creation');
499: hr_utility.set_location('procpyr',1);
500: open c_parameters(pactid);
501:
502: --Bug 3364759 -- Fetced the values of the cursors in the variables l_business_group_id, l_start_date, l_effective_date
503: -- as well.

Line 523: hr_utility.trace('Error getting defined balance id');

519: and ue.user_entity_id = di.user_entity_id
520: and ue.creator_type = 'B'
521: and nvl(ue.legislation_code,'US') = 'US';
522: exception when others then
523: hr_utility.trace('Error getting defined balance id');
524: raise;
525: end;
526:
527: begin

Line 537: hr_utility.trace('Error getting defined balance id');

533: and ue.user_entity_id = di.user_entity_id
534: and ue.creator_type = 'B'
535: and nvl(ue.legislation_code,'US') = 'US';
536: exception when others then
537: hr_utility.trace('Error getting defined balance id');
538: raise;
539: end;
540: */
541:

Line 542: hr_utility.set_location('procpyr',1);

538: raise;
539: end;
540: */
541:
542: hr_utility.set_location('procpyr',1);
543: open c_actions(pactid,stperson,endperson);
544: num := 0;
545: loop
546: hr_utility.set_location('procpyr',2);

Line 546: hr_utility.set_location('procpyr',2);

542: hr_utility.set_location('procpyr',1);
543: open c_actions(pactid,stperson,endperson);
544: num := 0;
545: loop
546: hr_utility.set_location('procpyr',2);
547: fetch c_actions into action_type,lockedactid,assignid,greid;
548: if c_actions%found then num := num + 1; end if;
549: exit when c_actions%notfound;
550: --

Line 595: hr_utility.set_location('procpyr',3);

591:
592:
593: null;
594: else
595: hr_utility.set_location('procpyr',3);
596: select pay_assignment_actions_s.nextval
597: into lockingactid
598: from dual;
599: --

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

605: end if;
606: --
607: end loop;
608: close c_actions;
609: hr_utility.trace('leaving action_creation');
610: end action_creation;
611: ---------------------------------- sort_action ----------------------------------
612: procedure sort_action
613: (

Line 727: -- hr_utility.trace_on (null,'1');

723: begin
724:
725: begin
726: --
727: -- hr_utility.trace_on (null,'1');
728: hr_utility.trace('entering archive_init');
729: select
730: ppa.legislative_parameters,
731: ppa.business_group_id,

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

724:
725: begin
726: --
727: -- hr_utility.trace_on (null,'1');
728: hr_utility.trace('entering archive_init');
729: select
730: ppa.legislative_parameters,
731: ppa.business_group_id,
732: ppa.start_date,

Line 752: hr_utility.trace('p_asg_flag in archive_init='||p_asg_flag);

748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
749: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
750: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
751:
752: hr_utility.trace('p_asg_flag in archive_init='||p_asg_flag);
753: p_ded_bal_status1 := pay_us_payroll_utils.check_balance_status(p_start_date
754: ,p_business_group_id
755: ,'PAY_US_PRE_TAX_DEDUCTIONS','US');
756: p_ded_bal_status2 := pay_us_payroll_utils.check_balance_status(p_start_date

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

911: exception
912: when no_data_found then
913: null;
914: end;
915: hr_utility.trace('leaving archive_init');
916: end ARCHIVE_INIT;
917:
918:
919: Procedure ARCHIVE_CODE (p_payroll_action_id IN NUMBER

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

918:
919: Procedure ARCHIVE_CODE (p_payroll_action_id IN NUMBER
920: ,p_chunk_number IN NUMBER) IS
921: begin
922: hr_utility.trace('entering archive_code');
923: hr_utility.trace('l_arch_count ='||l_arch_count);
924: /*-- Bug#4942114 starts --*/
925: /* pay_gtnlod_pkg.load_data(p_payroll_action_id => p_payroll_action_id,
926: p_chunk => p_chunk_number,

Line 923: hr_utility.trace('l_arch_count ='||l_arch_count);

919: Procedure ARCHIVE_CODE (p_payroll_action_id IN NUMBER
920: ,p_chunk_number IN NUMBER) IS
921: begin
922: hr_utility.trace('entering archive_code');
923: hr_utility.trace('l_arch_count ='||l_arch_count);
924: /*-- Bug#4942114 starts --*/
925: /* pay_gtnlod_pkg.load_data(p_payroll_action_id => p_payroll_action_id,
926: p_chunk => p_chunk_number,
927: ppa_finder => p_ppa_finder,

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

958: p_er_liab_status => p_er_liab_status,
959: p_wc_er_liab_status_count => p_wc_er_liab_status_count,
960: p_asg_flag => p_asg_flag);
961: /*-- Bug#4942114 ends --*/
962: hr_utility.trace('leaving archive_code');
963: end ARCHIVE_CODE;
964:
965: PROCEDURE CREATE_GTN_XML_DATA
966: IS

Line 973: hr_utility.trace ('Entering '|| lv_proc_name);

969:
970: BEGIN
971:
972: lv_proc_name := g_proc_name || 'CREATE_GTN_XML_DATA';
973: hr_utility.trace ('Entering '|| lv_proc_name);
974:
975: pay_us_xdo_report.populate_gtn_report_data(p_ppa_finder => p_ppa_finder
976: ,p_xfdf_blob => lb_xml_blob);
977: pay_core_files.write_to_magtape_lob(lb_xml_blob);

Line 979: hr_utility.trace ('Leaving '|| lv_proc_name);

975: pay_us_xdo_report.populate_gtn_report_data(p_ppa_finder => p_ppa_finder
976: ,p_xfdf_blob => lb_xml_blob);
977: pay_core_files.write_to_magtape_lob(lb_xml_blob);
978:
979: hr_utility.trace ('Leaving '|| lv_proc_name);
980:
981: EXCEPTION WHEN OTHERS THEN
982: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS of Procedure' || lv_proc_name);
983: END CREATE_GTN_XML_DATA;

Line 982: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS of Procedure' || lv_proc_name);

978:
979: hr_utility.trace ('Leaving '|| lv_proc_name);
980:
981: EXCEPTION WHEN OTHERS THEN
982: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS of Procedure' || lv_proc_name);
983: END CREATE_GTN_XML_DATA;
984:
985:
986: Procedure ARCHIVE_DEINIT(p_payroll_action_id IN NUMBER) IS

Line 1052: hr_utility.trace ('Entering '|| lv_proc_name);

1048:
1049: BEGIN
1050:
1051: lv_proc_name := g_proc_name || 'CREATE_GTN_XML_DATA';
1052: hr_utility.trace ('Entering '|| lv_proc_name);
1053: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);
1054: hr_utility.trace ('p_template_code '|| p_template_code);
1055: --bug 6365474
1056: OPEN csr_release;

Line 1053: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);

1049: BEGIN
1050:
1051: lv_proc_name := g_proc_name || 'CREATE_GTN_XML_DATA';
1052: hr_utility.trace ('Entering '|| lv_proc_name);
1053: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);
1054: hr_utility.trace ('p_template_code '|| p_template_code);
1055: --bug 6365474
1056: OPEN csr_release;
1057: FETCH csr_release INTO l_release;

Line 1054: hr_utility.trace ('p_template_code '|| p_template_code);

1050:
1051: lv_proc_name := g_proc_name || 'CREATE_GTN_XML_DATA';
1052: hr_utility.trace ('Entering '|| lv_proc_name);
1053: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);
1054: hr_utility.trace ('p_template_code '|| p_template_code);
1055: --bug 6365474
1056: OPEN csr_release;
1057: FETCH csr_release INTO l_release;
1058: CLOSE csr_release;

Line 1099: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);

1095: -- bug 6799553
1096:
1097: pay_archive.remove_report_actions(p_payroll_action_id);
1098:
1099: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
1100: hr_utility.trace ('lv_template_code '|| lv_template_code);
1101: hr_utility.trace ('ln_application_id '|| ln_application_id);
1102: hr_utility.trace ('lv_template_type '|| lv_template_type);
1103: --bug 6365474

Line 1100: hr_utility.trace ('lv_template_code '|| lv_template_code);

1096:
1097: pay_archive.remove_report_actions(p_payroll_action_id);
1098:
1099: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
1100: hr_utility.trace ('lv_template_code '|| lv_template_code);
1101: hr_utility.trace ('ln_application_id '|| ln_application_id);
1102: hr_utility.trace ('lv_template_type '|| lv_template_type);
1103: --bug 6365474
1104: if(l_release = 12) then

Line 1101: hr_utility.trace ('ln_application_id '|| ln_application_id);

1097: pay_archive.remove_report_actions(p_payroll_action_id);
1098:
1099: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
1100: hr_utility.trace ('lv_template_code '|| lv_template_code);
1101: hr_utility.trace ('ln_application_id '|| ln_application_id);
1102: hr_utility.trace ('lv_template_type '|| lv_template_type);
1103: --bug 6365474
1104: if(l_release = 12) then
1105:

Line 1102: hr_utility.trace ('lv_template_type '|| lv_template_type);

1098:
1099: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
1100: hr_utility.trace ('lv_template_code '|| lv_template_code);
1101: hr_utility.trace ('ln_application_id '|| ln_application_id);
1102: hr_utility.trace ('lv_template_type '|| lv_template_type);
1103: --bug 6365474
1104: if(l_release = 12) then
1105:
1106: ln_req_id := fnd_request.submit_request

Line 1119: hr_utility.trace ('Leaving 12'|| lv_proc_name);

1115: argument6 => 'N',
1116: argument7 => lv_template_type,
1117: argument8 => 'PDF'
1118: );
1119: hr_utility.trace ('Leaving 12'|| lv_proc_name);
1120: else
1121: --bug 6365474
1122: ln_req_id := fnd_request.submit_request
1123: (

Line 1137: hr_utility.trace ('Leaving 11i'|| lv_proc_name);

1133: );
1134:
1135:
1136:
1137: hr_utility.trace ('Leaving 11i'|| lv_proc_name);
1138: --bug 6365474
1139: end if;
1140: --bug 6365474
1141:

Line 1149: -- hr_utility.trace_on(NULL,'trc_pypaygtn');

1145:
1146: end ARCHIVE_DEINIT;
1147:
1148: BEGIN
1149: -- hr_utility.trace_on(NULL,'trc_pypaygtn');
1150: g_proc_name := 'PAY_PAYGTN_PKG.';
1151:
1152: END PAY_PAYGTN_PKG;