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

Line 165: /hr_utility.trace_on(null,'SQWL');/

161: AND ASG.payroll_id is not null; */
162:
163: BEGIN
164:
165: /*hr_utility.trace_on(null,'SQWL');*/
166: ld_Quater_end_date:=fnd_date.canonical_to_date(p_effective_date);
167:
168: /* Handling special condition for NY state: */
169: IF p_state = 'NY' AND to_char(ld_Quater_end_date,'MM') = '12' THEN

Line 191: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);

187: OPEN c_get_format_type(p_state,p_format);
188: FETCH c_get_format_type into lv_format_meaning;
189: CLOSE c_get_format_type;
190:
191: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
192: hr_utility.trace('p_effective_date: '||p_effective_date);
193: hr_utility.trace('p_report_option: '||p_report_option);
194:
195: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);

Line 192: hr_utility.trace('p_effective_date: '||p_effective_date);

188: FETCH c_get_format_type into lv_format_meaning;
189: CLOSE c_get_format_type;
190:
191: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
192: hr_utility.trace('p_effective_date: '||p_effective_date);
193: hr_utility.trace('p_report_option: '||p_report_option);
194:
195: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);
196: INSERT

Line 193: hr_utility.trace('p_report_option: '||p_report_option);

189: CLOSE c_get_format_type;
190:
191: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
192: hr_utility.trace('p_effective_date: '||p_effective_date);
193: hr_utility.trace('p_report_option: '||p_report_option);
194:
195: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);
196: INSERT
197: INTO pay_payroll_actions

Line 195: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);

191: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
192: hr_utility.trace('p_effective_date: '||p_effective_date);
193: hr_utility.trace('p_report_option: '||p_report_option);
194:
195: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);
196: INSERT
197: INTO pay_payroll_actions
198: (payroll_action_id
199: ,action_type

Line 252: hr_utility.trace('l_previous_sqwl_run_check: '||l_previous_sqwl_run_check);

248: AND business_group_id = p_business_group_id
249: AND effective_date = fnd_date.canonical_to_date (p_effective_date)
250: AND pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = c_get_all_gres_rec.organization_id;
251:
252: hr_utility.trace('l_previous_sqwl_run_check: '||l_previous_sqwl_run_check);
253:
254: select count(paa.assignment_action_id)
255: into l_chk_gre_assign_actions
256: from pay_assignment_actions paa,

Line 275: hr_utility.trace('l_chk_gre_assign_actions: '||l_chk_gre_assign_actions);

271: and pact.EFFECTIVE_DATE between
272: peft.EFFECTIVE_START_DATE and peft.EFFECTIVE_END_DATE
273: and peft.SUI_STATE_CODE = lv_state_code;
274: -- BUG 12391841
275: hr_utility.trace('l_chk_gre_assign_actions: '||l_chk_gre_assign_actions);
276:
277: IF l_previous_sqwl_run_check = 0 and l_chk_gre_assign_actions > 0 THEN
278:
279: SELECT pay_us_reporting_utils_pkg.get_file_name(c_get_all_gres_rec.organization_id,

Line 287: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);

283: substr(lv_format_meaning,1,1) )
284: INTO l_file_name
285: FROM dual;
286:
287: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);
288:
289:
290: hr_utility.trace(' calling conc request :');
291: hr_utility.trace(' final p_state :'||p_state);

Line 290: hr_utility.trace(' calling conc request :');

286:
287: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);
288:
289:
290: hr_utility.trace(' calling conc request :');
291: hr_utility.trace(' final p_state :'||p_state);
292: hr_utility.trace(' final lv_year :'||lv_year);
293: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
294: hr_utility.trace(' final lv_report_category :'||lv_report_category);

Line 291: hr_utility.trace(' final p_state :'||p_state);

287: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);
288:
289:
290: hr_utility.trace(' calling conc request :');
291: hr_utility.trace(' final p_state :'||p_state);
292: hr_utility.trace(' final lv_year :'||lv_year);
293: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
294: hr_utility.trace(' final lv_report_category :'||lv_report_category);
295: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);

Line 292: hr_utility.trace(' final lv_year :'||lv_year);

288:
289:
290: hr_utility.trace(' calling conc request :');
291: hr_utility.trace(' final p_state :'||p_state);
292: hr_utility.trace(' final lv_year :'||lv_year);
293: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
294: hr_utility.trace(' final lv_report_category :'||lv_report_category);
295: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);
296: BEGIN

Line 293: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);

289:
290: hr_utility.trace(' calling conc request :');
291: hr_utility.trace(' final p_state :'||p_state);
292: hr_utility.trace(' final lv_year :'||lv_year);
293: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
294: hr_utility.trace(' final lv_report_category :'||lv_report_category);
295: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);
296: BEGIN
297: l_req_id := fnd_request.submit_request(application => 'PAY',

Line 294: hr_utility.trace(' final lv_report_category :'||lv_report_category);

290: hr_utility.trace(' calling conc request :');
291: hr_utility.trace(' final p_state :'||p_state);
292: hr_utility.trace(' final lv_year :'||lv_year);
293: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
294: hr_utility.trace(' final lv_report_category :'||lv_report_category);
295: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);
296: BEGIN
297: l_req_id := fnd_request.submit_request(application => 'PAY',
298: program => 'SQWLARCH',

Line 295: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);

291: hr_utility.trace(' final p_state :'||p_state);
292: hr_utility.trace(' final lv_year :'||lv_year);
293: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
294: hr_utility.trace(' final lv_report_category :'||lv_report_category);
295: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);
296: BEGIN
297: l_req_id := fnd_request.submit_request(application => 'PAY',
298: program => 'SQWLARCH',
299: argument1 => 'ARCHIVE',

Line 334: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

330: EXCEPTION
331:
332: WHEN OTHERS THEN
333:
334: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
335:
336: END ;
337:
338: commit;

Line 340: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);

336: END ;
337:
338: commit;
339:
340: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
341:
342: END IF; /*l_previous_sqwl_run_check*/
343: end loop;
344: ELSE

Line 393: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

389: EXCEPTION
390:
391: WHEN OTHERS THEN
392:
393: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
394:
395: END ;
396: commit;
397: NULL;

Line 400: hr_utility.trace_off;

396: commit;
397: NULL;
398: END IF;
399:
400: hr_utility.trace_off;
401: END; /* procedure process_sqwl */
402:
403: /* Rollback SQWL */
404: PROCEDURE rollback_sqwl(errbuf OUT nocopy VARCHAR2,

Line 443: /* hr_utility.trace_on(null,'SQWL'); */

439: l_report_type pay_payroll_actions.report_type%TYPE;
440: l_child_count NUMBER;
441: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
442: BEGIN
443: /* hr_utility.trace_on(null,'SQWL'); */
444: hr_utility.trace('p_process_year : '||p_process_year);
445: hr_utility.trace('p_payroll_action_id : '||p_payroll_action_id);
446: hr_utility.trace('p_payroll_action_id_hidden : '||p_payroll_action_id_hidden);
447:

Line 444: hr_utility.trace('p_process_year : '||p_process_year);

440: l_child_count NUMBER;
441: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
442: BEGIN
443: /* hr_utility.trace_on(null,'SQWL'); */
444: hr_utility.trace('p_process_year : '||p_process_year);
445: hr_utility.trace('p_payroll_action_id : '||p_payroll_action_id);
446: hr_utility.trace('p_payroll_action_id_hidden : '||p_payroll_action_id_hidden);
447:
448: SELECT report_type INTO l_report_type

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

441: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
442: BEGIN
443: /* hr_utility.trace_on(null,'SQWL'); */
444: hr_utility.trace('p_process_year : '||p_process_year);
445: hr_utility.trace('p_payroll_action_id : '||p_payroll_action_id);
446: hr_utility.trace('p_payroll_action_id_hidden : '||p_payroll_action_id_hidden);
447:
448: SELECT report_type INTO l_report_type
449: FROM pay_payroll_actions

Line 446: hr_utility.trace('p_payroll_action_id_hidden : '||p_payroll_action_id_hidden);

442: BEGIN
443: /* hr_utility.trace_on(null,'SQWL'); */
444: hr_utility.trace('p_process_year : '||p_process_year);
445: hr_utility.trace('p_payroll_action_id : '||p_payroll_action_id);
446: hr_utility.trace('p_payroll_action_id_hidden : '||p_payroll_action_id_hidden);
447:
448: SELECT report_type INTO l_report_type
449: FROM pay_payroll_actions
450: WHERE payroll_action_id = p_payroll_action_id;

Line 459: hr_utility.trace('payroll_action not found');

455: LOOP
456: FETCH c_get_child_payroll_actions INTO ln_child_payroll_action_id;
457:
458: IF c_get_child_payroll_actions%notfound then
459: hr_utility.trace('payroll_action not found');
460: BEGIN
461: l_req_id := fnd_request.submit_request(application => 'PAY',
462: program => 'US_ROLLBACK_PROCESS', -- */ 'US_RETRY_PROCESS',
463: argument1 => 'ROLLBACK', --*/ 'RERUN',

Line 475: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

471: EXCEPTION
472:
473: WHEN OTHERS THEN
474:
475: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
476:
477: END ;
478: commit;
479: /* PY_ROLLBACK_PKG.rollback_payroll_action(p_payroll_action_id);*/

Line 480: hr_utility.trace('rolled back parent payroll action id '||p_payroll_action_id);

476:
477: END ;
478: commit;
479: /* PY_ROLLBACK_PKG.rollback_payroll_action(p_payroll_action_id);*/
480: hr_utility.trace('rolled back parent payroll action id '||p_payroll_action_id);
481: EXIT;
482: END IF;
483:
484: hr_utility.trace('ln_child_payroll_action_id : '||ln_child_payroll_action_id);

Line 484: hr_utility.trace('ln_child_payroll_action_id : '||ln_child_payroll_action_id);

480: hr_utility.trace('rolled back parent payroll action id '||p_payroll_action_id);
481: EXIT;
482: END IF;
483:
484: hr_utility.trace('ln_child_payroll_action_id : '||ln_child_payroll_action_id);
485: BEGIN
486: l_req_id := fnd_request.submit_request(application => 'PAY',
487: program => 'US_ROLLBACK_PROCESS', -- */ 'US_RETRY_PROCESS',
488: argument1 => 'ROLLBACK', --*/ 'RERUN',

Line 500: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

496: EXCEPTION
497:
498: WHEN OTHERS THEN
499:
500: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
501:
502: END ;
503: COMMIT;
504: /*PY_ROLLBACK_PKG.rollback_payroll_action(ln_child_payroll_action_id);*/

Line 505: hr_utility.trace('rolled back child payroll action id '||ln_child_payroll_action_id);

501:
502: END ;
503: COMMIT;
504: /*PY_ROLLBACK_PKG.rollback_payroll_action(ln_child_payroll_action_id);*/
505: hr_utility.trace('rolled back child payroll action id '||ln_child_payroll_action_id);
506:
507: END LOOP;
508: ELSIF l_report_type = 'SQWL' OR l_report_type = 'SMWL' THEN /* Modified for Bug 14456648 */
509:

Line 510: hr_utility.trace('l_report_type '||l_report_type);

506:
507: END LOOP;
508: ELSIF l_report_type = 'SQWL' OR l_report_type = 'SMWL' THEN /* Modified for Bug 14456648 */
509:
510: hr_utility.trace('l_report_type '||l_report_type);
511:
512: BEGIN
513: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',legislative_parameters)
514: INTO l_parent_payroll_action_id from pay_payroll_actions

Line 523: hr_utility.trace('l_parent_payroll_action_id '||l_parent_payroll_action_id);

519: WHEN OTHERS THEN
520: null;
521: END;
522:
523: hr_utility.trace('l_parent_payroll_action_id '||l_parent_payroll_action_id);
524: IF l_parent_payroll_action_id is not null then
525: BEGIN
526: SELECT count(payroll_action_id) into l_child_count
527: FROM pay_payroll_actions p1

Line 536: hr_utility.trace('l_child_count '||l_child_count);

532: null;
533: END;
534: END IF;
535:
536: hr_utility.trace('l_child_count '||l_child_count);
537:
538: BEGIN
539: l_req_id := fnd_request.submit_request(application => 'PAY',
540: program => 'US_ROLLBACK_PROCESS', -- */ 'US_RETRY_PROCESS',

Line 553: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

549: EXCEPTION
550:
551: WHEN OTHERS THEN
552:
553: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
554:
555: END ;
556: COMMIT;
557:

Line 561: hr_utility.trace('l_child_count true '||l_child_count);

557:
558:
559:
560: IF l_child_count = 1 THEN
561: hr_utility.trace('l_child_count true '||l_child_count);
562: BEGIN
563: l_req_id := fnd_request.submit_request(application => 'PAY',
564: program => 'US_ROLLBACK_PROCESS', -- */ 'US_RETRY_PROCESS',
565: argument1 => 'ROLLBACK', --*/ 'RERUN',

Line 577: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

573: EXCEPTION
574:
575: WHEN OTHERS THEN
576:
577: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
578:
579: END ;
580: COMMIT;
581:

Line 586: hr_utility.trace_off;

582: END IF;
583:
584:
585: END IF;
586: hr_utility.trace_off;
587: END; /* Procedure Rollback */
588:
589:
590: PROCEDURE process_smwl (errbuf OUT nocopy VARCHAR2,

Line 708: /hr_utility.trace_on(null,'SMWL');/

704: AND ASG.payroll_id is not null; */
705:
706: BEGIN
707:
708: /*hr_utility.trace_on(null,'SMWL');*/
709: ld_Month_end_date:=fnd_date.canonical_to_date(p_effective_date);
710:
711: /* Handling special condition for NY state: */
712: -- IF p_state = 'NY' AND to_char(ld_Quater_end_date,'MM') = '12' THEN

Line 734: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);

730: OPEN c_get_format_type(p_state,p_format);
731: FETCH c_get_format_type into lv_format_meaning;
732: CLOSE c_get_format_type;
733:
734: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
735: hr_utility.trace('p_effective_date: '||p_effective_date);
736: hr_utility.trace('p_report_option: '||p_report_option);
737:
738: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);

Line 735: hr_utility.trace('p_effective_date: '||p_effective_date);

731: FETCH c_get_format_type into lv_format_meaning;
732: CLOSE c_get_format_type;
733:
734: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
735: hr_utility.trace('p_effective_date: '||p_effective_date);
736: hr_utility.trace('p_report_option: '||p_report_option);
737:
738: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);
739: INSERT

Line 736: hr_utility.trace('p_report_option: '||p_report_option);

732: CLOSE c_get_format_type;
733:
734: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
735: hr_utility.trace('p_effective_date: '||p_effective_date);
736: hr_utility.trace('p_report_option: '||p_report_option);
737:
738: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);
739: INSERT
740: INTO pay_payroll_actions

Line 738: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);

734: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
735: hr_utility.trace('p_effective_date: '||p_effective_date);
736: hr_utility.trace('p_report_option: '||p_report_option);
737:
738: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);
739: INSERT
740: INTO pay_payroll_actions
741: (payroll_action_id
742: ,action_type

Line 795: hr_utility.trace('l_previous_smwl_run_check: '||l_previous_smwl_run_check);

791: AND business_group_id = p_business_group_id
792: AND effective_date = fnd_date.canonical_to_date (p_effective_date)
793: AND pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = c_get_all_gres_rec.organization_id;
794:
795: hr_utility.trace('l_previous_smwl_run_check: '||l_previous_smwl_run_check);
796:
797: select count(paa.assignment_action_id)
798: into l_chk_gre_assign_actions
799: from pay_assignment_actions paa,

Line 818: hr_utility.trace('l_chk_gre_assign_actions: '||l_chk_gre_assign_actions);

814: and pact.EFFECTIVE_DATE between
815: peft.EFFECTIVE_START_DATE and peft.EFFECTIVE_END_DATE
816: and peft.SUI_STATE_CODE = lv_state_code;
817: -- BUG 12391841
818: hr_utility.trace('l_chk_gre_assign_actions: '||l_chk_gre_assign_actions);
819:
820: IF l_previous_smwl_run_check = 0 and l_chk_gre_assign_actions > 0 THEN
821:
822: SELECT pay_us_reporting_utils_pkg.get_file_name(c_get_all_gres_rec.organization_id,

Line 830: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);

826: substr(lv_format_meaning,1,1) )
827: INTO l_file_name
828: FROM dual;
829:
830: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);
831:
832:
833: hr_utility.trace(' calling conc request :');
834: hr_utility.trace(' final p_state :'||p_state);

Line 833: hr_utility.trace(' calling conc request :');

829:
830: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);
831:
832:
833: hr_utility.trace(' calling conc request :');
834: hr_utility.trace(' final p_state :'||p_state);
835: hr_utility.trace(' final lv_year :'||lv_year);
836: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
837: hr_utility.trace(' final lv_report_category :'||lv_report_category);

Line 834: hr_utility.trace(' final p_state :'||p_state);

830: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);
831:
832:
833: hr_utility.trace(' calling conc request :');
834: hr_utility.trace(' final p_state :'||p_state);
835: hr_utility.trace(' final lv_year :'||lv_year);
836: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
837: hr_utility.trace(' final lv_report_category :'||lv_report_category);
838: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);

Line 835: hr_utility.trace(' final lv_year :'||lv_year);

831:
832:
833: hr_utility.trace(' calling conc request :');
834: hr_utility.trace(' final p_state :'||p_state);
835: hr_utility.trace(' final lv_year :'||lv_year);
836: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
837: hr_utility.trace(' final lv_report_category :'||lv_report_category);
838: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);
839: BEGIN

Line 836: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);

832:
833: hr_utility.trace(' calling conc request :');
834: hr_utility.trace(' final p_state :'||p_state);
835: hr_utility.trace(' final lv_year :'||lv_year);
836: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
837: hr_utility.trace(' final lv_report_category :'||lv_report_category);
838: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);
839: BEGIN
840: l_req_id := fnd_request.submit_request(application => 'PAY',

Line 837: hr_utility.trace(' final lv_report_category :'||lv_report_category);

833: hr_utility.trace(' calling conc request :');
834: hr_utility.trace(' final p_state :'||p_state);
835: hr_utility.trace(' final lv_year :'||lv_year);
836: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
837: hr_utility.trace(' final lv_report_category :'||lv_report_category);
838: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);
839: BEGIN
840: l_req_id := fnd_request.submit_request(application => 'PAY',
841: program => 'SQWLARCH',

Line 838: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);

834: hr_utility.trace(' final p_state :'||p_state);
835: hr_utility.trace(' final lv_year :'||lv_year);
836: hr_utility.trace(' final p_business_group_id :'||p_business_group_id);
837: hr_utility.trace(' final lv_report_category :'||lv_report_category);
838: hr_utility.trace(' final c_get_all_gres_rec.organization_id :'||c_get_all_gres_rec.organization_id);
839: BEGIN
840: l_req_id := fnd_request.submit_request(application => 'PAY',
841: program => 'SQWLARCH',
842: argument1 => 'ARCHIVE',

Line 877: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

873: EXCEPTION
874:
875: WHEN OTHERS THEN
876:
877: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
878:
879: END ;
880:
881: commit;

Line 883: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);

879: END ;
880:
881: commit;
882:
883: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
884:
885: END IF; /*l_previous_smwl_run_check*/
886: end loop;
887: ELSE

Line 936: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

932: EXCEPTION
933:
934: WHEN OTHERS THEN
935:
936: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
937:
938: END ;
939: commit;
940: NULL;

Line 943: hr_utility.trace_off;

939: commit;
940: NULL;
941: END IF;
942:
943: hr_utility.trace_off;
944: END; /* procedure process_smwl */
945:
946:
947: END pay_us_sqwl_gre;