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

Line 167: --hr_utility.trace_on(null,'PYWF');

163:
164: --
165: --
166: begin
167: --hr_utility.trace_on(null,'PYWF');
168: gv_package := 'pay_wf_pkg';
169: l_RequestorUsername := 'SYSADMIN';
170:
171: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;

Line 190: hr_utility.trace('In exception: OTHERS at payroll_wf_process');

186: and name = l_workflowprocess
187: and end_date is null;
188:
189: Exception when others then
190: hr_utility.trace('In exception: OTHERS at payroll_wf_process');
191: null;
192:
193: END;
194:

Line 197: hr_utility.trace('Item Type is : '|| l_item_type);

193: END;
194:
195:
196:
197: hr_utility.trace('Item Type is : '|| l_item_type);
198: hr_utility.trace('Item Key is : '|| l_item_key);
199: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
200:
201: if lv_runnable_process = 'Y' then

Line 198: hr_utility.trace('Item Key is : '|| l_item_key);

194:
195:
196:
197: hr_utility.trace('Item Type is : '|| l_item_type);
198: hr_utility.trace('Item Key is : '|| l_item_key);
199: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
200:
201: if lv_runnable_process = 'Y' then
202:

Line 199: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);

195:
196:
197: hr_utility.trace('Item Type is : '|| l_item_type);
198: hr_utility.trace('Item Key is : '|| l_item_key);
199: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
200:
201: if lv_runnable_process = 'Y' then
202:
203: StartProcess( p_business_group_id,

Line 297: WHEN hr_utility.hr_error THEN

293: end if;
294:
295: EXCEPTION
296: --
297: WHEN hr_utility.hr_error THEN
298: --
299: -- Set up error message and error return code.
300: --
301: --hr_utility.trace('in the exception');

Line 301: --hr_utility.trace('in the exception');

297: WHEN hr_utility.hr_error THEN
298: --
299: -- Set up error message and error return code.
300: --
301: --hr_utility.trace('in the exception');
302: errbuf := hr_utility.get_message;
303: retcode := 2;
304: --
305: --

Line 302: errbuf := hr_utility.get_message;

298: --
299: -- Set up error message and error return code.
300: --
301: --hr_utility.trace('in the exception');
302: errbuf := hr_utility.get_message;
303: retcode := 2;
304: --
305: --
306: WHEN others THEN

Line 616: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);

612: -- exception
613: -- when others then null;
614: -- end;
615:
616: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
617: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
618: hr_utility.trace('WF process name is : '|| Workflowprocess);
619:
620: begin

Line 617: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);

613: -- when others then null;
614: -- end;
615:
616: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
617: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
618: hr_utility.trace('WF process name is : '|| Workflowprocess);
619:
620: begin
621: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;

Line 618: hr_utility.trace('WF process name is : '|| Workflowprocess);

614: -- end;
615:
616: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
617: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
618: hr_utility.trace('WF process name is : '|| Workflowprocess);
619:
620: begin
621: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
622: end;

Line 624: hr_utility.trace('b4 create_process');

620: begin
621: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
622: end;
623:
624: hr_utility.trace('b4 create_process');
625:
626: wf_engine.createProcess( ItemType => ItemType,
627: ItemKey => ItemKey,
628: process => Workflowprocess);

Line 633: hr_utility.trace('In Start Process b4 HR_SIGNON.Initialize_HR_Security');

629:
630: wf_engine.SetItemUserKey( ItemType => ItemType,
631: ItemKey => ItemKey,
632: UserKey => ItemUserKey);
633: hr_utility.trace('In Start Process b4 HR_SIGNON.Initialize_HR_Security');
634: HR_SIGNON.Initialize_HR_Security;
635: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of Start ');
636:
637: l_user_id:= FND_GLOBAL.USER_ID;

Line 635: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of Start ');

631: ItemKey => ItemKey,
632: UserKey => ItemUserKey);
633: hr_utility.trace('In Start Process b4 HR_SIGNON.Initialize_HR_Security');
634: HR_SIGNON.Initialize_HR_Security;
635: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of Start ');
636:
637: l_user_id:= FND_GLOBAL.USER_ID;
638: l_resp_appl_id:= FND_GLOBAL.RESP_APPL_ID;
639: l_resp_id:= FND_GLOBAL.RESP_ID;

Line 645: hr_utility.trace('l_user_id = ' || l_user_id);

641:
642: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
643: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
644:
645: hr_utility.trace('l_user_id = ' || l_user_id);
646: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
647: hr_utility.trace('l_resp_id = ' || l_resp_id);
648: hr_utility.trace('l_org_id = ' || l_org_id);
649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);

Line 646: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);

642: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
643: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
644:
645: hr_utility.trace('l_user_id = ' || l_user_id);
646: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
647: hr_utility.trace('l_resp_id = ' || l_resp_id);
648: hr_utility.trace('l_org_id = ' || l_org_id);
649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
650: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);

Line 647: hr_utility.trace('l_resp_id = ' || l_resp_id);

643: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
644:
645: hr_utility.trace('l_user_id = ' || l_user_id);
646: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
647: hr_utility.trace('l_resp_id = ' || l_resp_id);
648: hr_utility.trace('l_org_id = ' || l_org_id);
649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
650: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
651: hr_utility.trace('BG = ' || to_char(p_business_group_id));

Line 648: hr_utility.trace('l_org_id = ' || l_org_id);

644:
645: hr_utility.trace('l_user_id = ' || l_user_id);
646: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
647: hr_utility.trace('l_resp_id = ' || l_resp_id);
648: hr_utility.trace('l_org_id = ' || l_org_id);
649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
650: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
651: hr_utility.trace('BG = ' || to_char(p_business_group_id));
652: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);

Line 649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);

645: hr_utility.trace('l_user_id = ' || l_user_id);
646: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
647: hr_utility.trace('l_resp_id = ' || l_resp_id);
648: hr_utility.trace('l_org_id = ' || l_org_id);
649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
650: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
651: hr_utility.trace('BG = ' || to_char(p_business_group_id));
652: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
653:

Line 650: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);

646: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
647: hr_utility.trace('l_resp_id = ' || l_resp_id);
648: hr_utility.trace('l_org_id = ' || l_org_id);
649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
650: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
651: hr_utility.trace('BG = ' || to_char(p_business_group_id));
652: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
653:
654:

Line 651: hr_utility.trace('BG = ' || to_char(p_business_group_id));

647: hr_utility.trace('l_resp_id = ' || l_resp_id);
648: hr_utility.trace('l_org_id = ' || l_org_id);
649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
650: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
651: hr_utility.trace('BG = ' || to_char(p_business_group_id));
652: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
653:
654:
655: /*

Line 652: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);

648: hr_utility.trace('l_org_id = ' || l_org_id);
649: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
650: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
651: hr_utility.trace('BG = ' || to_char(p_business_group_id));
652: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
653:
654:
655: /*
656: fnd_global.apps_initialize(l_user_id,l_resp_id,l_resp_appl_id);

Line 664: hr_utility.trace('In exception: OTHERS ');

660: select currency_code into lv_currency_code
661: from per_business_groups
662: where business_group_id = p_business_group_id;
663: Exception when others then
664: hr_utility.trace('In exception: OTHERS ');
665: null;
666:
667: END;
668:

Line 681: hr_utility.trace('In exception: OTHERS ');

677: AND BG.BUSINESS_GROUP_ID= p_business_group_id
678: AND PPT.PAYMENT_TYPE_NAME = 'NACHA'
679: );
680: Exception when others then
681: hr_utility.trace('In exception: OTHERS ');
682: null;
683:
684: END;
685:

Line 699: hr_utility.trace('In exception: OTHERS ');

695: AND BG.BUSINESS_GROUP_ID= p_business_group_id
696: AND PPT.PAYMENT_TYPE_NAME = 'Check'
697: );
698: Exception when others then
699: hr_utility.trace('In exception: OTHERS ');
700: null;
701:
702: END;
703:

Line 711: hr_utility.trace('In exception: OTHERS ');

707: from pay_report_format_mappings_f
708: where report_type = 'DAR'
709: and report_category = p_da_report_category;
710: Exception when others then
711: hr_utility.trace('In exception: OTHERS ');
712: null;
713:
714: END;
715:

Line 725: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);

721: where payroll_id = p_payroll_id
722: and fnd_date.canonical_to_date(p_date_earned)
723: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
724:
725: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
726: Exception when others then
727: hr_utility.trace('In exception: OTHERS ');
728: null;
729:

Line 727: hr_utility.trace('In exception: OTHERS ');

723: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
724:
725: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
726: Exception when others then
727: hr_utility.trace('In exception: OTHERS ');
728: null;
729:
730: END;
731:

Line 738: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);

734: select consolidation_set_name into lv_consolidation_set_name
735: from pay_consolidation_sets
736: where consolidation_set_id = p_consolidation_set_id;
737:
738: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
739: Exception when others then
740: hr_utility.trace('In exception: OTHERS ');
741: null;
742:

Line 740: hr_utility.trace('In exception: OTHERS ');

736: where consolidation_set_id = p_consolidation_set_id;
737:
738: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
739: Exception when others then
740: hr_utility.trace('In exception: OTHERS ');
741: null;
742:
743: END;
744:

Line 750: hr_utility.trace('lv_gre_name = ' || lv_gre_name);

746: -- GRE Name
747: select name into lv_gre_name
748: from hr_tax_units_v
749: where tax_unit_id = to_number(p_gre);
750: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
751:
752: Exception when others then
753: hr_utility.trace('In exception: OTHERS ');
754: null;

Line 753: hr_utility.trace('In exception: OTHERS ');

749: where tax_unit_id = to_number(p_gre);
750: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
751:
752: Exception when others then
753: hr_utility.trace('In exception: OTHERS ');
754: null;
755:
756: END;
757:

Line 763: hr_utility.trace('lv_period_name = ' || lv_period_name);

759: -- Period Name
760: select PERIOD_NAME into lv_period_name
761: from per_time_periods
762: where time_period_id = p_period;
763: hr_utility.trace('lv_period_name = ' || lv_period_name);
764:
765: Exception when others then
766: hr_utility.trace('In exception: OTHERS ');
767: null;

Line 766: hr_utility.trace('In exception: OTHERS ');

762: where time_period_id = p_period;
763: hr_utility.trace('lv_period_name = ' || lv_period_name);
764:
765: Exception when others then
766: hr_utility.trace('In exception: OTHERS ');
767: null;
768:
769: END;
770:

Line 778: hr_utility.trace('lv_event_group_name = ' || lv_event_group_name);

774: into lv_event_group_name
775: from pay_event_groups
776: where event_group_id = substr(p_event_group,12,length(p_event_group));
777:
778: hr_utility.trace('lv_event_group_name = ' || lv_event_group_name);
779:
780: Exception when others then
781: hr_utility.trace('In exception: OTHERS ');
782: null;

Line 781: hr_utility.trace('In exception: OTHERS ');

777:
778: hr_utility.trace('lv_event_group_name = ' || lv_event_group_name);
779:
780: Exception when others then
781: hr_utility.trace('In exception: OTHERS ');
782: null;
783:
784: END;
785:

Line 795: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);

791: where business_group_id = p_business_group_id
792: and org_payment_method_id = p_nacha_payment_method
793: and fnd_date.canonical_to_date(p_date_earned)
794: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
795: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
796:
797: Exception when others then
798: hr_utility.trace('In exception: OTHERS Nacha Org Payment Method Name ');
799: null;

Line 798: hr_utility.trace('In exception: OTHERS Nacha Org Payment Method Name ');

794: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
795: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
796:
797: Exception when others then
798: hr_utility.trace('In exception: OTHERS Nacha Org Payment Method Name ');
799: null;
800:
801: END;
802:

Line 812: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);

808: where business_group_id = p_business_group_id
809: and org_payment_method_id = p_check_writer_payment_method
810: and fnd_date.canonical_to_date(p_date_earned)
811: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
812: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
813: Exception when others then
814: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');
815: null;
816:

Line 814: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');

810: and fnd_date.canonical_to_date(p_date_earned)
811: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
812: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
813: Exception when others then
814: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');
815: null;
816:
817: END;
818:

Line 828: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);

824: where business_group_id = p_business_group_id
825: and org_payment_method_id = p_payment_method_override
826: and fnd_date.canonical_to_date(p_date_earned)
827: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
828: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
829: Exception when others then
830: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');
831: null;
832:

Line 830: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');

826: and fnd_date.canonical_to_date(p_date_earned)
827: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
828: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
829: Exception when others then
830: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');
831: null;
832:
833: END;
834:

Line 840: hr_utility.trace('Costing Summary Accruals = ' || lv_cost_summary_accruals);

836: open cur_costing_summary_accruals;
837: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
838: close cur_costing_summary_accruals;
839:
840: hr_utility.trace('Costing Summary Accruals = ' || lv_cost_summary_accruals);
841:
842: open cur_costing_summary_file_out;
843: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
844: close cur_costing_summary_file_out;

Line 846: hr_utility.trace('Costing Summary File Format = ' || lv_cost_summary_file_out);

842: open cur_costing_summary_file_out;
843: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
844: close cur_costing_summary_file_out;
845:
846: hr_utility.trace('Costing Summary File Format = ' || lv_cost_summary_file_out);
847:
848: open cur_costing_detail_ele_set;
849: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
850: close cur_costing_detail_ele_set;

Line 852: hr_utility.trace('Costing Detail Element Set = ' || lv_cost_detail_ele_set);

848: open cur_costing_detail_ele_set;
849: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
850: close cur_costing_detail_ele_set;
851:
852: hr_utility.trace('Costing Detail Element Set = ' || lv_cost_detail_ele_set);
853:
854: open cur_costing_detail_ele_name;
855: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
856: close cur_costing_detail_ele_name;

Line 858: hr_utility.trace('Costing Detail Element Name = ' || lv_cost_detail_ele_name);

854: open cur_costing_detail_ele_name;
855: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
856: close cur_costing_detail_ele_name;
857:
858: hr_utility.trace('Costing Detail Element Name = ' || lv_cost_detail_ele_name);
859:
860: open cur_costing_detail_ele_class;
861: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
862: close cur_costing_detail_ele_class;

Line 864: hr_utility.trace('Costing Detail Element Classification = ' || lv_cost_detail_ele_class);

860: open cur_costing_detail_ele_class;
861: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
862: close cur_costing_detail_ele_class;
863:
864: hr_utility.trace('Costing Detail Element Classification = ' || lv_cost_detail_ele_class);
865:
866: open cur_costing_detail_asg_set;
867: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
868: close cur_costing_detail_asg_set;

Line 870: hr_utility.trace('Costing Detail Assignment Set = ' || lv_cost_detail_asg_set);

866: open cur_costing_detail_asg_set;
867: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
868: close cur_costing_detail_asg_set;
869:
870: hr_utility.trace('Costing Detail Assignment Set = ' || lv_cost_detail_asg_set);
871:
872: open cur_costing_detail_accruals;
873: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
874: close cur_costing_detail_accruals;

Line 876: hr_utility.trace('Costing Detail Accruals = ' || lv_cost_detail_accruals);

872: open cur_costing_detail_accruals;
873: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
874: close cur_costing_detail_accruals;
875:
876: hr_utility.trace('Costing Detail Accruals = ' || lv_cost_detail_accruals);
877:
878: END;
879:
880:

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

884: into lv_Payroll_WF_Notify_Action
885: from pay_action_parameters
886: where parameter_name = 'PAYROLL_WF_NOTIFY_ACTION';
887:
888: hr_utility.trace('lv_Payroll_WF_Notify_Action = ' || lv_Payroll_WF_Notify_Action);
889: If lv_Payroll_WF_Notify_Action = 'WAIT' then
890: lv_isResponseRequired := 'Y';
891: lv_isPaymentWait := 'Y';
892: elsif lv_Payroll_WF_Notify_Action = 'NOWAIT' then

Line 900: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);

896: lv_isResponseRequired := 'N';
897: lv_isPaymentWait := 'Y';
898: end if;
899:
900: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
901: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
902:
903: Exception when others then
904: hr_utility.trace('In exception: OTHERS ');

Line 901: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);

897: lv_isPaymentWait := 'Y';
898: end if;
899:
900: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
901: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
902:
903: Exception when others then
904: hr_utility.trace('In exception: OTHERS ');
905: lv_isResponseRequired := 'Y';

Line 904: hr_utility.trace('In exception: OTHERS ');

900: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
901: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
902:
903: Exception when others then
904: hr_utility.trace('In exception: OTHERS ');
905: lv_isResponseRequired := 'Y';
906: lv_isPaymentWait := 'Y';
907: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
908:

Line 907: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);

903: Exception when others then
904: hr_utility.trace('In exception: OTHERS ');
905: lv_isResponseRequired := 'Y';
906: lv_isPaymentWait := 'Y';
907: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
908:
909: END;
910:
911: Begin

Line 919: hr_utility.trace('lv_check_sort_seq_meaning = ' || lv_check_sort_seq_meaning);

915: from fnd_common_lookups
916: where lookup_type = 'CHEQUE_PROCEDURE'
917: and lookup_code = p_check_writer_sort_sequence;
918:
919: hr_utility.trace('lv_check_sort_seq_meaning = ' || lv_check_sort_seq_meaning);
920: Exception when others then
921: hr_utility.trace('In exception: OTHERS ');
922: null;
923:

Line 921: hr_utility.trace('In exception: OTHERS ');

917: and lookup_code = p_check_writer_sort_sequence;
918:
919: hr_utility.trace('lv_check_sort_seq_meaning = ' || lv_check_sort_seq_meaning);
920: Exception when others then
921: hr_utility.trace('In exception: OTHERS ');
922: null;
923:
924: END;
925:

Line 936: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);

932: from pqp_exception_reports per
933: where legislation_code = 'US'
934: and per.exception_report_id = p_exception_report_name;
935:
936: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
937: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
938: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
939:
940: Exception when others then

Line 937: hr_utility.trace('lv_orv_type = ' || lv_orv_type);

933: where legislation_code = 'US'
934: and per.exception_report_id = p_exception_report_name;
935:
936: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
937: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
938: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
939:
940: Exception when others then
941: hr_utility.trace('In exception: OTHERS ');

Line 938: hr_utility.trace('lv_orv_value = ' || lv_orv_value);

934: and per.exception_report_id = p_exception_report_name;
935:
936: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
937: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
938: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
939:
940: Exception when others then
941: hr_utility.trace('In exception: OTHERS ');
942: null;

Line 941: hr_utility.trace('In exception: OTHERS ');

937: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
938: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
939:
940: Exception when others then
941: hr_utility.trace('In exception: OTHERS ');
942: null;
943:
944: END;
945: /*

Line 956: hr_utility.trace('lv_gre_name = ' || lv_gre_name);

952: from pqp_exception_report_groups perg
953: where legislation_code = 'US'
954: and perg.EXCEPTION_GROUP_ID = p_exception_group_name;
955:
956: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
957: Exception when others then
958: hr_utility.trace('In exception: OTHERS ');
959: null;
960:

Line 958: hr_utility.trace('In exception: OTHERS ');

954: and perg.EXCEPTION_GROUP_ID = p_exception_group_name;
955:
956: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
957: Exception when others then
958: hr_utility.trace('In exception: OTHERS ');
959: null;
960:
961: END;
962: */

Line 969: hr_utility.trace('In exception: OTHERS ');

965: into lv_element_name
966: from pay_element_types_f
967: where element_type_id = p_element;
968: Exception when others then
969: hr_utility.trace('In exception: OTHERS ');
970: null;
971:
972: END;
973:

Line 982: hr_utility.trace('Batch Name :' ||lv_batch_name);

978: into lv_batch_name
979: from pay_batch_headers
980: where batch_id = p_batch_id;
981: End If;
982: hr_utility.trace('Batch Name :' ||lv_batch_name);
983:
984: Exception when others then
985: lv_batch_name := '';
986: hr_utility.trace('In exception: Batch Name ');

Line 986: hr_utility.trace('In exception: Batch Name ');

982: hr_utility.trace('Batch Name :' ||lv_batch_name);
983:
984: Exception when others then
985: lv_batch_name := '';
986: hr_utility.trace('In exception: Batch Name ');
987: null;
988:
989: END;
990:

Line 1004: hr_utility.trace('In exception: OTHERS at get_notifier');

1000: to_number(p_gre),
1001: p_date_earned);
1002:
1003: Exception when others then
1004: hr_utility.trace('In exception: OTHERS at get_notifier');
1005: null;
1006:
1007: END;
1008:

Line 1017: hr_utility.trace('In exception: OTHERS ');

1013: from wf_roles
1014: where name = lv_contact_user_name ;
1015:
1016: Exception when others then
1017: hr_utility.trace('In exception: OTHERS ');
1018: null;
1019:
1020: END;
1021: -- For debugging .. remove the code

Line 1047: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);

1043: select fnd_profile_server.value('USERNAME')
1044: into l_profile_user_name
1045: from dual;
1046:
1047: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1048: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1049: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1050: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1051:

Line 1048: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);

1044: into l_profile_user_name
1045: from dual;
1046:
1047: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1048: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1049: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1050: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1051:
1052: Exception when others then

Line 1049: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);

1045: from dual;
1046:
1047: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1048: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1049: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1050: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1051:
1052: Exception when others then
1053: hr_utility.trace('In exception: OTHERS at profile');

Line 1050: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);

1046:
1047: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1048: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1049: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1050: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1051:
1052: Exception when others then
1053: hr_utility.trace('In exception: OTHERS at profile');
1054: null;

Line 1053: hr_utility.trace('In exception: OTHERS at profile');

1049: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1050: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1051:
1052: Exception when others then
1053: hr_utility.trace('In exception: OTHERS at profile');
1054: null;
1055:
1056: END;
1057:

Line 1059: hr_utility.trace('orig ststem : '|| l_orig_system);

1055:
1056: END;
1057:
1058: --'JJ CA HRMS Manager';
1059: hr_utility.trace('orig ststem : '|| l_orig_system);
1060: hr_utility.trace('orig ststem : '|| l_orig_system_id);
1061: hr_utility.trace('l_role_name = ' || l_role_name);
1062:
1063: wf_engine.SetItemOwner ( itemtype => ItemType,

Line 1060: hr_utility.trace('orig ststem : '|| l_orig_system_id);

1056: END;
1057:
1058: --'JJ CA HRMS Manager';
1059: hr_utility.trace('orig ststem : '|| l_orig_system);
1060: hr_utility.trace('orig ststem : '|| l_orig_system_id);
1061: hr_utility.trace('l_role_name = ' || l_role_name);
1062:
1063: wf_engine.SetItemOwner ( itemtype => ItemType,
1064: itemkey => ItemKey,

Line 1061: hr_utility.trace('l_role_name = ' || l_role_name);

1057:
1058: --'JJ CA HRMS Manager';
1059: hr_utility.trace('orig ststem : '|| l_orig_system);
1060: hr_utility.trace('orig ststem : '|| l_orig_system_id);
1061: hr_utility.trace('l_role_name = ' || l_role_name);
1062:
1063: wf_engine.SetItemOwner ( itemtype => ItemType,
1064: itemkey => ItemKey,
1065: owner => ProcessOwner);

Line 1397: hr_utility.trace('p_payroll_id = ' || p_payroll_id);

1393: lv_cur_process(p) := null;
1394: end loop;
1395: end if;
1396:
1397: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1398: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1399: hr_utility.trace('p_date_earned = ' || p_date_earned);
1400: hr_utility.trace('p_date_paid = ' || p_date_paid);
1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);

Line 1398: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);

1394: end loop;
1395: end if;
1396:
1397: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1398: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1399: hr_utility.trace('p_date_earned = ' || p_date_earned);
1400: hr_utility.trace('p_date_paid = ' || p_date_paid);
1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1402: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);

Line 1399: hr_utility.trace('p_date_earned = ' || p_date_earned);

1395: end if;
1396:
1397: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1398: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1399: hr_utility.trace('p_date_earned = ' || p_date_earned);
1400: hr_utility.trace('p_date_paid = ' || p_date_paid);
1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1402: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1403: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);

Line 1400: hr_utility.trace('p_date_paid = ' || p_date_paid);

1396:
1397: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1398: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1399: hr_utility.trace('p_date_earned = ' || p_date_earned);
1400: hr_utility.trace('p_date_paid = ' || p_date_paid);
1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1402: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1403: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1404: hr_utility.trace('check_style = ' || p_check_style);

Line 1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);

1397: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1398: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1399: hr_utility.trace('p_date_earned = ' || p_date_earned);
1400: hr_utility.trace('p_date_paid = ' || p_date_paid);
1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1402: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1403: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1404: hr_utility.trace('check_style = ' || p_check_style);
1405: begin

Line 1402: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);

1398: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1399: hr_utility.trace('p_date_earned = ' || p_date_earned);
1400: hr_utility.trace('p_date_paid = ' || p_date_paid);
1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1402: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1403: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1404: hr_utility.trace('check_style = ' || p_check_style);
1405: begin
1406:

Line 1403: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);

1399: hr_utility.trace('p_date_earned = ' || p_date_earned);
1400: hr_utility.trace('p_date_paid = ' || p_date_paid);
1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1402: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1403: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1404: hr_utility.trace('check_style = ' || p_check_style);
1405: begin
1406:
1407: i := 0;

Line 1404: hr_utility.trace('check_style = ' || p_check_style);

1400: hr_utility.trace('p_date_paid = ' || p_date_paid);
1401: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1402: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1403: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1404: hr_utility.trace('check_style = ' || p_check_style);
1405: begin
1406:
1407: i := 0;
1408:

Line 1946: hr_utility.trace( 'J = '|| j );

1942: num_varname(i) := 'SECURITY_GROUP_ID';
1943: num_varvalue(i) := l_profile_sec_grp_id;
1944:
1945: for j in varname.first..varname.last loop
1946: hr_utility.trace( 'J = '|| j );
1947: hr_utility.trace( 'varname = '||varname(j));
1948: hr_utility.trace( 'varval = '||varval(j));
1949: end loop;
1950:

Line 1947: hr_utility.trace( 'varname = '||varname(j));

1943: num_varvalue(i) := l_profile_sec_grp_id;
1944:
1945: for j in varname.first..varname.last loop
1946: hr_utility.trace( 'J = '|| j );
1947: hr_utility.trace( 'varname = '||varname(j));
1948: hr_utility.trace( 'varval = '||varval(j));
1949: end loop;
1950:
1951: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);

Line 1948: hr_utility.trace( 'varval = '||varval(j));

1944:
1945: for j in varname.first..varname.last loop
1946: hr_utility.trace( 'J = '|| j );
1947: hr_utility.trace( 'varname = '||varname(j));
1948: hr_utility.trace( 'varval = '||varval(j));
1949: end loop;
1950:
1951: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
1952: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));

Line 1952: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));

1948: hr_utility.trace( 'varval = '||varval(j));
1949: end loop;
1950:
1951: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
1952: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
1953:
1954: for p in num_varname.first..num_varname.last loop
1955: hr_utility.trace( 'p = '|| p );
1956: hr_utility.trace( 'num_varname = '||num_varname(p));

Line 1955: hr_utility.trace( 'p = '|| p );

1951: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
1952: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
1953:
1954: for p in num_varname.first..num_varname.last loop
1955: hr_utility.trace( 'p = '|| p );
1956: hr_utility.trace( 'num_varname = '||num_varname(p));
1957: hr_utility.trace( 'num_varval = '||num_varvalue(p));
1958: end loop;
1959:

Line 1956: hr_utility.trace( 'num_varname = '||num_varname(p));

1952: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
1953:
1954: for p in num_varname.first..num_varname.last loop
1955: hr_utility.trace( 'p = '|| p );
1956: hr_utility.trace( 'num_varname = '||num_varname(p));
1957: hr_utility.trace( 'num_varval = '||num_varvalue(p));
1958: end loop;
1959:
1960: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);

Line 1957: hr_utility.trace( 'num_varval = '||num_varvalue(p));

1953:
1954: for p in num_varname.first..num_varname.last loop
1955: hr_utility.trace( 'p = '|| p );
1956: hr_utility.trace( 'num_varname = '||num_varname(p));
1957: hr_utility.trace( 'num_varval = '||num_varvalue(p));
1958: end loop;
1959:
1960: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
1961:

Line 1962: hr_utility.trace( 'Total Num Kount = '||to_char(num_varname.COUNT));

1958: end loop;
1959:
1960: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
1961:
1962: hr_utility.trace( 'Total Num Kount = '||to_char(num_varname.COUNT));
1963: exception
1964: when OTHERS then
1965: hr_utility.trace('In exception: OTHERS of TextArray');
1966: raise;

Line 1965: hr_utility.trace('In exception: OTHERS of TextArray');

1961:
1962: hr_utility.trace( 'Total Num Kount = '||to_char(num_varname.COUNT));
1963: exception
1964: when OTHERS then
1965: hr_utility.trace('In exception: OTHERS of TextArray');
1966: raise;
1967: end;
1968:
1969: /*

Line 1991: hr_utility.trace('B4 SetItemAttrText : l_role_name = ' || l_role_name);

1987: itemkey => ItemKey,
1988: aname => 'MESSAGE_TEXT1',
1989: avalue => l_message_text1);
1990:
1991: hr_utility.trace('B4 SetItemAttrText : l_role_name = ' || l_role_name);
1992: wf_engine.SetItemAttrText ( itemtype => ItemType,
1993: itemkey => ItemKey,
1994: aname => 'ROLE_NAME',
1995: avalue => l_role_name);

Line 2002: hr_utility.trace('APPLNAME ');

1998: itemkey => ItemKey,
1999: aname => 'APPLNAME',
2000: avalue => 'PAY');
2001:
2002: hr_utility.trace('APPLNAME ');
2003: */
2004:
2005: hr_utility.trace('b4 starting process');
2006:

Line 2005: hr_utility.trace('b4 starting process');

2001:
2002: hr_utility.trace('APPLNAME ');
2003: */
2004:
2005: hr_utility.trace('b4 starting process');
2006:
2007: wf_engine.StartProcess ( ItemType => ItemType,
2008: ItemKey => ItemKey );
2009: hr_utility.trace('a4 starting process');

Line 2009: hr_utility.trace('a4 starting process');

2005: hr_utility.trace('b4 starting process');
2006:
2007: wf_engine.StartProcess ( ItemType => ItemType,
2008: ItemKey => ItemKey );
2009: hr_utility.trace('a4 starting process');
2010:
2011:
2012:
2013: exception

Line 2066: hr_utility.trace('Profile Value is : '|| lv_contact_source);

2062:
2063: l_proc := gv_package||'.get_notifier';
2064: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
2065:
2066: hr_utility.trace('Profile Value is : '|| lv_contact_source);
2067: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
2068: hr_utility.trace('GRE Id is : '|| ln_gre_id);
2069: hr_utility.trace('Effective Date is : '|| l_effective_date);
2070:

Line 2067: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);

2063: l_proc := gv_package||'.get_notifier';
2064: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
2065:
2066: hr_utility.trace('Profile Value is : '|| lv_contact_source);
2067: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
2068: hr_utility.trace('GRE Id is : '|| ln_gre_id);
2069: hr_utility.trace('Effective Date is : '|| l_effective_date);
2070:
2071:

Line 2068: hr_utility.trace('GRE Id is : '|| ln_gre_id);

2064: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
2065:
2066: hr_utility.trace('Profile Value is : '|| lv_contact_source);
2067: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
2068: hr_utility.trace('GRE Id is : '|| ln_gre_id);
2069: hr_utility.trace('Effective Date is : '|| l_effective_date);
2070:
2071:
2072:

Line 2069: hr_utility.trace('Effective Date is : '|| l_effective_date);

2065:
2066: hr_utility.trace('Profile Value is : '|| lv_contact_source);
2067: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
2068: hr_utility.trace('GRE Id is : '|| ln_gre_id);
2069: hr_utility.trace('Effective Date is : '|| l_effective_date);
2070:
2071:
2072:
2073: if lv_contact_source = 'PAYROLL' then

Line 2076: hr_utility.trace('Contact User is : '|| lv_contact_user_name);

2072:
2073: if lv_contact_source = 'PAYROLL' then
2074: open c_payroll_contact;
2075: fetch c_payroll_contact into lv_contact_user_name;
2076: hr_utility.trace('Contact User is : '|| lv_contact_user_name);
2077: if c_payroll_contact%NOTFOUND then
2078: lv_contact_user_name := 'SYSADMIN';
2079: end if;
2080:

Line 2102: hr_utility.set_location('Leaving: ' || l_proc, 100);

2098: end if;
2099:
2100: return lv_contact_user_name;
2101:
2102: hr_utility.set_location('Leaving: ' || l_proc, 100);
2103: end get_notifier;
2104:
2105:
2106: procedure error

Line 2126: hr_utility.trace('Run time error in test script');

2122: dbms_output.put_line('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2123: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2124: */
2125:
2126: hr_utility.trace('Run time error in test script');
2127: hr_utility.trace('Sqlerror: '||sqlerrm);
2128: hr_utility.trace('Errname: '||wf_core.error_name);
2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));

Line 2127: hr_utility.trace('Sqlerror: '||sqlerrm);

2123: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2124: */
2125:
2126: hr_utility.trace('Run time error in test script');
2127: hr_utility.trace('Sqlerror: '||sqlerrm);
2128: hr_utility.trace('Errname: '||wf_core.error_name);
2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));

Line 2128: hr_utility.trace('Errname: '||wf_core.error_name);

2124: */
2125:
2126: hr_utility.trace('Run time error in test script');
2127: hr_utility.trace('Sqlerror: '||sqlerrm);
2128: hr_utility.trace('Errname: '||wf_core.error_name);
2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));

Line 2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));

2125:
2126: hr_utility.trace('Run time error in test script');
2127: hr_utility.trace('Sqlerror: '||sqlerrm);
2128: hr_utility.trace('Errname: '||wf_core.error_name);
2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));

Line 2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));

2126: hr_utility.trace('Run time error in test script');
2127: hr_utility.trace('Sqlerror: '||sqlerrm);
2128: hr_utility.trace('Errname: '||wf_core.error_name);
2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));

Line 2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));

2127: hr_utility.trace('Sqlerror: '||sqlerrm);
2128: hr_utility.trace('Errname: '||wf_core.error_name);
2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));

Line 2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));

2128: hr_utility.trace('Errname: '||wf_core.error_name);
2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));

Line 2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));

2129: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2137: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));

Line 2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));

2130: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2137: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2138: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));

Line 2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));

2131: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2137: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2138: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2139: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));

Line 2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));

2132: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2137: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2138: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2139: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2140:

Line 2137: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));

2133: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2137: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2138: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2139: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2140:
2141: end error;

Line 2138: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));

2134: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2137: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2138: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2139: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2140:
2141: end error;
2142:

Line 2139: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));

2135: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2136: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2137: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2138: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2139: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2140:
2141: end error;
2142:
2143: