eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on HR_UTILITY

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

147: lv_runnable_process varchar2(1);
148:
149:
150: begin
151: --hr_utility.trace_on(null,'PYWF');
152:
153: gv_package := 'pay_ca_wf_pkg';
154:
155: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;

Line 174: hr_utility.trace('Exception: No Data Found in payroll_wf_process');

170: and name = l_workflowprocess
171: and end_date is null;
172:
173: exception when no_data_found then
174: hr_utility.trace('Exception: No Data Found in payroll_wf_process');
175: null;
176:
177: end;
178:

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

175: null;
176:
177: end;
178:
179: hr_utility.trace('Item Type : '|| l_item_type);
180: hr_utility.trace('Item Key : '|| l_item_key);
181: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
182:
183: if lv_runnable_process = 'Y' then

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

176:
177: end;
178:
179: hr_utility.trace('Item Type : '|| l_item_type);
180: hr_utility.trace('Item Key : '|| l_item_key);
181: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
182:
183: if lv_runnable_process = 'Y' then
184:

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

177: end;
178:
179: hr_utility.trace('Item Type : '|| l_item_type);
180: hr_utility.trace('Item Key : '|| l_item_key);
181: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
182:
183: if lv_runnable_process = 'Y' then
184:
185: StartProcess(p_business_group_id,

Line 287: when hr_utility.hr_error then

283: end if;
284:
285: exception
286:
287: when hr_utility.hr_error then
288: --
289: -- Set up error message and error return code.
290: --
291: hr_utility.trace('in the exception');

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

287: when hr_utility.hr_error then
288: --
289: -- Set up error message and error return code.
290: --
291: hr_utility.trace('in the exception');
292:
293: errbuf := hr_utility.get_message;
294: retcode := 2;
295:

Line 293: errbuf := hr_utility.get_message;

289: -- Set up error message and error return code.
290: --
291: hr_utility.trace('in the exception');
292:
293: errbuf := hr_utility.get_message;
294: retcode := 2;
295:
296: when others then
297:

Line 752: hr_utility.set_location('Starting: ' || l_proc, 100);

748:
749:
750: begin
751:
752: hr_utility.set_location('Starting: ' || l_proc, 100);
753:
754: lv_conc_prog_name(1) := 'BEE Batch Process (Transfer)';
755: lv_conc_prog_name(2) := 'Retro-Notifications Report';
756: lv_conc_prog_name(3) := 'RetroPay By Element';

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

776: lv_conc_prog_name(23) := 'Costing';
777: lv_conc_prog_name(24) := 'Costing Detail Report';
778: lv_conc_prog_name(25) := 'Costing Summary Report';
779:
780: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
781: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
782: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
783:
784: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')

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

777: lv_conc_prog_name(24) := 'Costing Detail Report';
778: lv_conc_prog_name(25) := 'Costing Summary Report';
779:
780: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
781: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
782: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
783:
784: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
785: into lv_date_time from dual;

Line 782: hr_utility.trace('Workflow process name is : '|| Workflowprocess);

778: lv_conc_prog_name(25) := 'Costing Summary Report';
779:
780: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
781: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
782: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
783:
784: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
785: into lv_date_time from dual;
786:

Line 788: hr_utility.trace('before create_process');

784: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
785: into lv_date_time from dual;
786:
787:
788: hr_utility.trace('before create_process');
789:
790: wf_engine.createProcess(ItemType => ItemType,
791: ItemKey => ItemKey,
792: process => Workflowprocess);

Line 798: hr_utility.trace('In StartProcess before HR_SIGNON.Initialize_HR_Security');

794: wf_engine.SetItemUserKey(ItemType => ItemType,
795: ItemKey => ItemKey,
796: UserKey => ItemUserKey);
797:
798: hr_utility.trace('In StartProcess before HR_SIGNON.Initialize_HR_Security');
799:
800: HR_SIGNON.Initialize_HR_Security;
801:
802: hr_utility.trace('After HR_SIGNON.Initialize_HR_Security');

Line 802: hr_utility.trace('After HR_SIGNON.Initialize_HR_Security');

798: hr_utility.trace('In StartProcess before HR_SIGNON.Initialize_HR_Security');
799:
800: HR_SIGNON.Initialize_HR_Security;
801:
802: hr_utility.trace('After HR_SIGNON.Initialize_HR_Security');
803:
804: l_user_id := FND_GLOBAL.USER_ID;
805: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
806: l_resp_id := FND_GLOBAL.RESP_ID;

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

807: l_org_id := FND_GLOBAL.ORG_ID;
808: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
809: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
810:
811: hr_utility.trace('l_user_id = ' || l_user_id);
812: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
813: hr_utility.trace('l_resp_id = ' || l_resp_id);
814: hr_utility.trace('l_org_id = ' || l_org_id);
815: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);

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

808: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
809: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
810:
811: hr_utility.trace('l_user_id = ' || l_user_id);
812: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
813: hr_utility.trace('l_resp_id = ' || l_resp_id);
814: hr_utility.trace('l_org_id = ' || l_org_id);
815: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
816: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);

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

809: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
810:
811: hr_utility.trace('l_user_id = ' || l_user_id);
812: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
813: hr_utility.trace('l_resp_id = ' || l_resp_id);
814: hr_utility.trace('l_org_id = ' || l_org_id);
815: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
816: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
817: hr_utility.trace('business group = ' || to_char(p_business_group_id));

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

810:
811: hr_utility.trace('l_user_id = ' || l_user_id);
812: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
813: hr_utility.trace('l_resp_id = ' || l_resp_id);
814: hr_utility.trace('l_org_id = ' || l_org_id);
815: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
816: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
817: hr_utility.trace('business group = ' || to_char(p_business_group_id));
818:

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

811: hr_utility.trace('l_user_id = ' || l_user_id);
812: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
813: hr_utility.trace('l_resp_id = ' || l_resp_id);
814: hr_utility.trace('l_org_id = ' || l_org_id);
815: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
816: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
817: hr_utility.trace('business group = ' || to_char(p_business_group_id));
818:
819: lv_gre_name := '';

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

812: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
813: hr_utility.trace('l_resp_id = ' || l_resp_id);
814: hr_utility.trace('l_org_id = ' || l_org_id);
815: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
816: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
817: hr_utility.trace('business group = ' || to_char(p_business_group_id));
818:
819: lv_gre_name := '';
820: lv_tax_group := '';

Line 817: hr_utility.trace('business group = ' || to_char(p_business_group_id));

813: hr_utility.trace('l_resp_id = ' || l_resp_id);
814: hr_utility.trace('l_org_id = ' || l_org_id);
815: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
816: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
817: hr_utility.trace('business group = ' || to_char(p_business_group_id));
818:
819: lv_gre_name := '';
820: lv_tax_group := '';
821:

Line 831: hr_utility.trace('Workflow Mode = ' || lv_workflow_mode);

827: end if;
828:
829: close cur_workflow_mode;
830:
831: hr_utility.trace('Workflow Mode = ' || lv_workflow_mode);
832:
833: open cur_retro_period;
834: fetch cur_retro_period into lv_retro_period;
835: close cur_retro_period;

Line 837: hr_utility.trace('Retro Period = ' || lv_retro_period);

833: open cur_retro_period;
834: fetch cur_retro_period into lv_retro_period;
835: close cur_retro_period;
836:
837: hr_utility.trace('Retro Period = ' || lv_retro_period);
838:
839: open cur_event_group;
840: fetch cur_event_group into lv_event_group_name;
841: close cur_event_group;

Line 843: hr_utility.trace('Event Group = ' || lv_event_group_name);

839: open cur_event_group;
840: fetch cur_event_group into lv_event_group_name;
841: close cur_event_group;
842:
843: hr_utility.trace('Event Group = ' || lv_event_group_name);
844:
845: open cur_retropay_asg_set;
846: fetch cur_retropay_asg_set into lv_retropay_asg_set;
847: close cur_retropay_asg_set;

Line 849: hr_utility.trace('RetroPay Assignment Set = ' || lv_retropay_asg_set);

845: open cur_retropay_asg_set;
846: fetch cur_retropay_asg_set into lv_retropay_asg_set;
847: close cur_retropay_asg_set;
848:
849: hr_utility.trace('RetroPay Assignment Set = ' || lv_retropay_asg_set);
850:
851: open cur_retropay_element_set;
852: fetch cur_retropay_element_set into lv_retropay_element_set;
853: close cur_retropay_element_set;

Line 855: hr_utility.trace('RetroPay Element Set = ' || lv_retropay_element_set);

851: open cur_retropay_element_set;
852: fetch cur_retropay_element_set into lv_retropay_element_set;
853: close cur_retropay_element_set;
854:
855: hr_utility.trace('RetroPay Element Set = ' || lv_retropay_element_set);
856:
857: open cur_payroll_element_set;
858: fetch cur_payroll_element_set into lv_payroll_element_set;
859: close cur_payroll_element_set;

Line 861: hr_utility.trace('Payroll Run Element Set = ' || lv_payroll_element_set);

857: open cur_payroll_element_set;
858: fetch cur_payroll_element_set into lv_payroll_element_set;
859: close cur_payroll_element_set;
860:
861: hr_utility.trace('Payroll Run Element Set = ' || lv_payroll_element_set);
862:
863: open cur_payroll_asg_set;
864: fetch cur_payroll_asg_set into lv_payroll_assignment_set;
865: close cur_payroll_asg_set;

Line 867: hr_utility.trace('Payroll Run Assignment Set = ' || lv_payroll_assignment_set);

863: open cur_payroll_asg_set;
864: fetch cur_payroll_asg_set into lv_payroll_assignment_set;
865: close cur_payroll_asg_set;
866:
867: hr_utility.trace('Payroll Run Assignment Set = ' || lv_payroll_assignment_set);
868:
869: open cur_payroll_run_type;
870: fetch cur_payroll_run_type into lv_payroll_run_type;
871: close cur_payroll_run_type;

Line 873: hr_utility.trace('Payroll Run Type = ' || lv_payroll_run_type);

869: open cur_payroll_run_type;
870: fetch cur_payroll_run_type into lv_payroll_run_type;
871: close cur_payroll_run_type;
872:
873: hr_utility.trace('Payroll Run Type = ' || lv_payroll_run_type);
874:
875: open cur_sdr_reporting_dimension;
876: fetch cur_sdr_reporting_dimension into lv_reporting_dimension;
877: close cur_sdr_reporting_dimension;

Line 879: hr_utility.trace('SDR Reporting Dimension = ' || lv_reporting_dimension);

875: open cur_sdr_reporting_dimension;
876: fetch cur_sdr_reporting_dimension into lv_reporting_dimension;
877: close cur_sdr_reporting_dimension;
878:
879: hr_utility.trace('SDR Reporting Dimension = ' || lv_reporting_dimension);
880:
881: open cur_exp_group_name;
882: fetch cur_exp_group_name into lv_exp_group_name;
883: close cur_exp_group_name;

Line 885: hr_utility.trace('Exception Group Name = ' || lv_exp_group_name);

881: open cur_exp_group_name;
882: fetch cur_exp_group_name into lv_exp_group_name;
883: close cur_exp_group_name;
884:
885: hr_utility.trace('Exception Group Name = ' || lv_exp_group_name);
886:
887: open cur_exp_report_name;
888: fetch cur_exp_report_name into lv_exp_report_name;
889: close cur_exp_report_name;

Line 891: hr_utility.trace('Exception Report Name = ' || lv_exp_report_name);

887: open cur_exp_report_name;
888: fetch cur_exp_report_name into lv_exp_report_name;
889: close cur_exp_report_name;
890:
891: hr_utility.trace('Exception Report Name = ' || lv_exp_report_name);
892:
893: open cur_exp_variance_type;
894: fetch cur_exp_variance_type into lv_exp_vartype_name;
895: close cur_exp_variance_type;

Line 897: hr_utility.trace('Exception Variance Type = ' || lv_exp_vartype_name);

893: open cur_exp_variance_type;
894: fetch cur_exp_variance_type into lv_exp_vartype_name;
895: close cur_exp_variance_type;
896:
897: hr_utility.trace('Exception Variance Type = ' || lv_exp_vartype_name);
898:
899: open cur_prepay_payment_method;
900: fetch cur_prepay_payment_method into lv_prepay_payment_method;
901: close cur_prepay_payment_method;

Line 903: hr_utility.trace('PrePayment Payment Method = ' || lv_prepay_payment_method);

899: open cur_prepay_payment_method;
900: fetch cur_prepay_payment_method into lv_prepay_payment_method;
901: close cur_prepay_payment_method;
902:
903: hr_utility.trace('PrePayment Payment Method = ' || lv_prepay_payment_method);
904:
905: open cur_ele_element_set;
906: fetch cur_ele_element_set into lv_ele_element_set;
907: close cur_ele_element_set;

Line 909: hr_utility.trace('Element Register Element Set = ' || lv_ele_element_set);

905: open cur_ele_element_set;
906: fetch cur_ele_element_set into lv_ele_element_set;
907: close cur_ele_element_set;
908:
909: hr_utility.trace('Element Register Element Set = ' || lv_ele_element_set);
910:
911: open cur_ele_element_class;
912: fetch cur_ele_element_class into lv_ele_element_class;
913: close cur_ele_element_class;

Line 915: hr_utility.trace('Element Register Element Classification = ' || lv_ele_element_class);

911: open cur_ele_element_class;
912: fetch cur_ele_element_class into lv_ele_element_class;
913: close cur_ele_element_class;
914:
915: hr_utility.trace('Element Register Element Classification = ' || lv_ele_element_class);
916:
917: open cur_ele_element_name;
918: fetch cur_ele_element_name into lv_ele_element_name;
919: close cur_ele_element_name;

Line 921: hr_utility.trace('Element Register Element Name = ' || lv_ele_element_name);

917: open cur_ele_element_name;
918: fetch cur_ele_element_name into lv_ele_element_name;
919: close cur_ele_element_name;
920:
921: hr_utility.trace('Element Register Element Name = ' || lv_ele_element_name);
922:
923: open cur_ele_employee;
924: fetch cur_ele_employee into lv_ele_employee;
925: close cur_ele_employee;

Line 927: hr_utility.trace('Element Register Employee = ' || lv_ele_employee);

923: open cur_ele_employee;
924: fetch cur_ele_employee into lv_ele_employee;
925: close cur_ele_employee;
926:
927: hr_utility.trace('Element Register Employee = ' || lv_ele_employee);
928:
929: open cur_ded_class;
930: fetch cur_ded_class into lv_deduction_class;
931: close cur_ded_class;

Line 933: hr_utility.trace('Deduction Report Dedn Classification = ' || lv_deduction_class);

929: open cur_ded_class;
930: fetch cur_ded_class into lv_deduction_class;
931: close cur_ded_class;
932:
933: hr_utility.trace('Deduction Report Dedn Classification = ' || lv_deduction_class);
934:
935: open cur_ded_name;
936: fetch cur_ded_name into lv_deduction_name;
937: close cur_ded_name;

Line 939: hr_utility.trace('Deduction Report Dedn Name = ' || lv_deduction_name);

935: open cur_ded_name;
936: fetch cur_ded_name into lv_deduction_name;
937: close cur_ded_name;
938:
939: hr_utility.trace('Deduction Report Dedn Name = ' || lv_deduction_name);
940:
941: open cur_reg_dimension;
942: fetch cur_reg_dimension into lv_reg_reporting_dimension;
943: close cur_reg_dimension;

Line 945: hr_utility.trace('Payroll Register Reporting Dimension = ' || lv_reg_reporting_dimension);

941: open cur_reg_dimension;
942: fetch cur_reg_dimension into lv_reg_reporting_dimension;
943: close cur_reg_dimension;
944:
945: hr_utility.trace('Payroll Register Reporting Dimension = ' || lv_reg_reporting_dimension);
946:
947: open cur_cheque_payment_type;
948: fetch cur_cheque_payment_type into lv_cheque_payment_type;
949: close cur_cheque_payment_type;

Line 951: hr_utility.trace('Chequewriter Payment Type = ' || lv_cheque_payment_type);

947: open cur_cheque_payment_type;
948: fetch cur_cheque_payment_type into lv_cheque_payment_type;
949: close cur_cheque_payment_type;
950:
951: hr_utility.trace('Chequewriter Payment Type = ' || lv_cheque_payment_type);
952:
953: open cur_cheque_payment_method;
954: fetch cur_cheque_payment_method into lv_cheque_payment_method;
955: close cur_cheque_payment_method;

Line 957: hr_utility.trace('Chequewriter Payment Method = ' || lv_cheque_payment_method);

953: open cur_cheque_payment_method;
954: fetch cur_cheque_payment_method into lv_cheque_payment_method;
955: close cur_cheque_payment_method;
956:
957: hr_utility.trace('Chequewriter Payment Method = ' || lv_cheque_payment_method);
958:
959: open cur_cheque_sort_seq;
960: fetch cur_cheque_sort_seq into lv_cheque_sort_sequence;
961: close cur_cheque_sort_seq;

Line 963: hr_utility.trace('Chequewriter Sort Seq = ' || lv_cheque_sort_sequence);

959: open cur_cheque_sort_seq;
960: fetch cur_cheque_sort_seq into lv_cheque_sort_sequence;
961: close cur_cheque_sort_seq;
962:
963: hr_utility.trace('Chequewriter Sort Seq = ' || lv_cheque_sort_sequence);
964:
965: open cur_cheque_style;
966: fetch cur_cheque_style into lv_cheque_style;
967: close cur_cheque_style;

Line 969: hr_utility.trace('Chequewriter Style = ' || lv_cheque_style);

965: open cur_cheque_style;
966: fetch cur_cheque_style into lv_cheque_style;
967: close cur_cheque_style;
968:
969: hr_utility.trace('Chequewriter Style = ' || lv_cheque_style);
970:
971: open cur_deposit_advice_data_type;
972: fetch cur_deposit_advice_data_type into lv_da_data_type;
973: close cur_deposit_advice_data_type;

Line 975: hr_utility.trace('Deposit Advice Data Type = ' || lv_da_data_type);

971: open cur_deposit_advice_data_type;
972: fetch cur_deposit_advice_data_type into lv_da_data_type;
973: close cur_deposit_advice_data_type;
974:
975: hr_utility.trace('Deposit Advice Data Type = ' || lv_da_data_type);
976:
977: open cur_roe_asg_set;
978: fetch cur_roe_asg_set into lv_roe_asg_set;
979: close cur_roe_asg_set;

Line 981: hr_utility.trace('ROE Assignment Set = ' || lv_roe_asg_set);

977: open cur_roe_asg_set;
978: fetch cur_roe_asg_set into lv_roe_asg_set;
979: close cur_roe_asg_set;
980:
981: hr_utility.trace('ROE Assignment Set = ' || lv_roe_asg_set);
982:
983: open cur_roe_worksheet_person;
984: fetch cur_roe_worksheet_person into lv_roe_worksheet_person;
985: close cur_roe_worksheet_person;

Line 987: hr_utility.trace('ROE Worksheet Person = ' || lv_roe_worksheet_person);

983: open cur_roe_worksheet_person;
984: fetch cur_roe_worksheet_person into lv_roe_worksheet_person;
985: close cur_roe_worksheet_person;
986:
987: hr_utility.trace('ROE Worksheet Person = ' || lv_roe_worksheet_person);
988:
989: open cur_roe_mag_media_person;
990: fetch cur_roe_mag_media_person into lv_roe_mag_media_person;
991: close cur_roe_mag_media_person;

Line 993: hr_utility.trace('ROE Magnetic Media Person = ' || lv_roe_mag_media_person);

989: open cur_roe_mag_media_person;
990: fetch cur_roe_mag_media_person into lv_roe_mag_media_person;
991: close cur_roe_mag_media_person;
992:
993: hr_utility.trace('ROE Magnetic Media Person = ' || lv_roe_mag_media_person);
994:
995: open cur_costing_summary_accruals;
996: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
997: close cur_costing_summary_accruals;

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

995: open cur_costing_summary_accruals;
996: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
997: close cur_costing_summary_accruals;
998:
999: hr_utility.trace('Costing Summary Accruals = ' || lv_cost_summary_accruals);
1000:
1001: open cur_costing_summary_file_out;
1002: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
1003: close cur_costing_summary_file_out;

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

1001: open cur_costing_summary_file_out;
1002: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
1003: close cur_costing_summary_file_out;
1004:
1005: hr_utility.trace('Costing Summary File Format = ' || lv_cost_summary_file_out);
1006:
1007: open cur_costing_detail_ele_set;
1008: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
1009: close cur_costing_detail_ele_set;

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

1007: open cur_costing_detail_ele_set;
1008: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
1009: close cur_costing_detail_ele_set;
1010:
1011: hr_utility.trace('Costing Detail Element Set = ' || lv_cost_detail_ele_set);
1012:
1013: open cur_costing_detail_ele_name;
1014: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
1015: close cur_costing_detail_ele_name;

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

1013: open cur_costing_detail_ele_name;
1014: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
1015: close cur_costing_detail_ele_name;
1016:
1017: hr_utility.trace('Costing Detail Element Name = ' || lv_cost_detail_ele_name);
1018:
1019: open cur_costing_detail_ele_class;
1020: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
1021: close cur_costing_detail_ele_class;

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

1019: open cur_costing_detail_ele_class;
1020: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
1021: close cur_costing_detail_ele_class;
1022:
1023: hr_utility.trace('Costing Detail Element Classification = ' || lv_cost_detail_ele_class);
1024:
1025: open cur_costing_detail_asg_set;
1026: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
1027: close cur_costing_detail_asg_set;

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

1025: open cur_costing_detail_asg_set;
1026: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
1027: close cur_costing_detail_asg_set;
1028:
1029: hr_utility.trace('Costing Detail Assignment Set = ' || lv_cost_detail_asg_set);
1030:
1031: open cur_costing_detail_accruals;
1032: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
1033: close cur_costing_detail_accruals;

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

1031: open cur_costing_detail_accruals;
1032: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
1033: close cur_costing_detail_accruals;
1034:
1035: hr_utility.trace('Costing Detail Accruals = ' || lv_cost_detail_accruals);
1036:
1037: begin
1038: select period_name
1039: into lv_gtn_period

Line 1044: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);

1040: from per_time_periods
1041: where payroll_id = to_number(p_payroll_id)
1042: and time_period_id = to_number(p_gross_to_net_period);
1043:
1044: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);
1045:
1046: exception when no_data_found then
1047: hr_utility.trace('lv_gtn_period exception: no_data_found ');
1048: null;

Line 1047: hr_utility.trace('lv_gtn_period exception: no_data_found ');

1043:
1044: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);
1045:
1046: exception when no_data_found then
1047: hr_utility.trace('lv_gtn_period exception: no_data_found ');
1048: null;
1049:
1050: end;
1051:

Line 1058: hr_utility.trace('lv_payroll_process = ' || lv_payroll_process);

1054: into lv_payroll_process
1055: from pay_payroll_actions
1056: where payroll_action_id = to_number(p_payroll_process);
1057:
1058: hr_utility.trace('lv_payroll_process = ' || lv_payroll_process);
1059:
1060: exception when no_data_found then
1061: hr_utility.trace('lv_payroll_process exception: no_data_found ');
1062: null;

Line 1061: hr_utility.trace('lv_payroll_process exception: no_data_found ');

1057:
1058: hr_utility.trace('lv_payroll_process = ' || lv_payroll_process);
1059:
1060: exception when no_data_found then
1061: hr_utility.trace('lv_payroll_process exception: no_data_found ');
1062: null;
1063:
1064: end;
1065:

Line 1071: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);

1067: select to_char(sysdate, 'HHSSSS')
1068: into lv_exp_finder_pqp
1069: from dual;
1070:
1071: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
1072:
1073: exception when no_data_found then
1074: hr_utility.trace('lv_exp_finder_pqp exception: no_data_found ');
1075: null;

Line 1074: hr_utility.trace('lv_exp_finder_pqp exception: no_data_found ');

1070:
1071: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
1072:
1073: exception when no_data_found then
1074: hr_utility.trace('lv_exp_finder_pqp exception: no_data_found ');
1075: null;
1076:
1077: end;
1078:

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

1084: where payroll_id = l_payroll_id
1085: and fnd_date.canonical_to_date(p_date_earned)
1086: between effective_start_date and effective_end_date;
1087:
1088: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
1089:
1090: exception when no_data_found then
1091: hr_utility.trace('lv_payroll_name exception: no_data_found ');
1092: null;

Line 1091: hr_utility.trace('lv_payroll_name exception: no_data_found ');

1087:
1088: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
1089:
1090: exception when no_data_found then
1091: hr_utility.trace('lv_payroll_name exception: no_data_found ');
1092: null;
1093:
1094: end;
1095:

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

1099: into lv_consolidation_set_name
1100: from pay_consolidation_sets
1101: where consolidation_set_id = l_consolidation_set_id;
1102:
1103: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
1104:
1105: exception when no_data_found then
1106: hr_utility.trace('lv_consolidation_set_name exception: no_data_found ');
1107: null;

Line 1106: hr_utility.trace('lv_consolidation_set_name exception: no_data_found ');

1102:
1103: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
1104:
1105: exception when no_data_found then
1106: hr_utility.trace('lv_consolidation_set_name exception: no_data_found ');
1107: null;
1108:
1109: end;
1110:

Line 1122: hr_utility.trace('lv_organization = ' || lv_organization);

1118: and fnd_date.canonical_to_date(p_date_earned) between
1119: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1120:
1121:
1122: hr_utility.trace('lv_organization = ' || lv_organization);
1123:
1124: exception when no_data_found then
1125: hr_utility.trace('lv_organization exception: no_data_found ');
1126: null;

Line 1125: hr_utility.trace('lv_organization exception: no_data_found ');

1121:
1122: hr_utility.trace('lv_organization = ' || lv_organization);
1123:
1124: exception when no_data_found then
1125: hr_utility.trace('lv_organization exception: no_data_found ');
1126: null;
1127:
1128: end;
1129:

Line 1137: hr_utility.trace('lv_location = ' || lv_location);

1133: into lv_location
1134: from hr_locations
1135: where location_id = to_number(p_location);
1136:
1137: hr_utility.trace('lv_location = ' || lv_location);
1138:
1139: exception when no_data_found then
1140: hr_utility.trace('lv_location exception: no_data_found ');
1141: null;

Line 1140: hr_utility.trace('lv_location exception: no_data_found ');

1136:
1137: hr_utility.trace('lv_location = ' || lv_location);
1138:
1139: exception when no_data_found then
1140: hr_utility.trace('lv_location exception: no_data_found ');
1141: null;
1142:
1143: end;
1144:

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

1152: and business_group_id = p_business_group_id
1153: and fnd_date.canonical_to_date(p_date_earned) between
1154: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1155:
1156: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1157:
1158: exception when no_data_found then
1159: hr_utility.trace('lv_gre_name exception: no_data_found ');
1160: null;

Line 1159: hr_utility.trace('lv_gre_name exception: no_data_found ');

1155:
1156: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1157:
1158: exception when no_data_found then
1159: hr_utility.trace('lv_gre_name exception: no_data_found ');
1160: null;
1161:
1162: end;
1163: end if;

Line 1180: hr_utility.trace('lv_tax_group = ' || lv_tax_group);

1176: and hou.organization_id = to_number(p_tax_group)
1177: and fnd_date.canonical_to_date(p_date_earned) between
1178: hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
1179:
1180: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
1181:
1182: exception when no_data_found then
1183: hr_utility.trace('lv_tax_group exception: no_data_found ');
1184: null;

Line 1183: hr_utility.trace('lv_tax_group exception: no_data_found ');

1179:
1180: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
1181:
1182: exception when no_data_found then
1183: hr_utility.trace('lv_tax_group exception: no_data_found ');
1184: null;
1185:
1186: end;
1187: end if;

Line 1207: hr_utility.trace('lv_account_number = ' || lv_account_number);

1203: and pcp.source_id = to_number(p_qhsf_account_number)
1204: and hoi2.org_information1 = 'QC'
1205: and hoi2.org_information_context = 'Provincial Information';
1206:
1207: hr_utility.trace('lv_account_number = ' || lv_account_number);
1208:
1209: exception when no_data_found then
1210: hr_utility.trace('lv_account_number exception: no_data_found ');
1211: null;

Line 1210: hr_utility.trace('lv_account_number exception: no_data_found ');

1206:
1207: hr_utility.trace('lv_account_number = ' || lv_account_number);
1208:
1209: exception when no_data_found then
1210: hr_utility.trace('lv_account_number exception: no_data_found ');
1211: null;
1212:
1213: end;
1214: end if;

Line 1267: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );

1263: from hr_lookups
1264: where lookup_code = p_reg_sort_one
1265: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1266:
1267: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );
1268:
1269: exception when no_data_found then
1270: hr_utility.trace('lv_reg_sort_one exception: no_data_found ');
1271: null;

Line 1270: hr_utility.trace('lv_reg_sort_one exception: no_data_found ');

1266:
1267: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );
1268:
1269: exception when no_data_found then
1270: hr_utility.trace('lv_reg_sort_one exception: no_data_found ');
1271: null;
1272: end;
1273:
1274: begin

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

1277: from hr_lookups
1278: where lookup_code = p_reg_sort_two
1279: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1280:
1281: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );
1282:
1283: exception when no_data_found then
1284: hr_utility.trace('lv_reg_sort_two exception: no_data_found ');
1285: null;

Line 1284: hr_utility.trace('lv_reg_sort_two exception: no_data_found ');

1280:
1281: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );
1282:
1283: exception when no_data_found then
1284: hr_utility.trace('lv_reg_sort_two exception: no_data_found ');
1285: null;
1286: end;
1287:
1288: begin

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

1291: from hr_lookups
1292: where lookup_code = p_reg_sort_three
1293: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1294:
1295: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );
1296:
1297: exception when no_data_found then
1298: hr_utility.trace('lv_reg_sort_three exception: no_data_found ');
1299: null;

Line 1298: hr_utility.trace('lv_reg_sort_three exception: no_data_found ');

1294:
1295: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );
1296:
1297: exception when no_data_found then
1298: hr_utility.trace('lv_reg_sort_three exception: no_data_found ');
1299: null;
1300: end;
1301:
1302: begin

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

1307: into lv_batch_name
1308: from pay_batch_headers
1309: where batch_id = p_batch_id;
1310:
1311: hr_utility.trace('Batch Name :' ||lv_batch_name);
1312:
1313: end if;
1314:
1315: exception when no_data_found then

Line 1317: hr_utility.trace('lv_batch_name exception: no_data_found ');

1313: end if;
1314:
1315: exception when no_data_found then
1316: lv_batch_name := '';
1317: hr_utility.trace('lv_batch_name exception: no_data_found ');
1318: null;
1319:
1320: end;
1321:

Line 1335: hr_utility.trace('lv_contact_user_name exception: OTHERS at get_notifier');

1331: to_number(p_gre),
1332: p_date_earned);
1333:
1334: exception when others then
1335: hr_utility.trace('lv_contact_user_name exception: OTHERS at get_notifier');
1336: null;
1337:
1338: end;
1339:

Line 1354: hr_utility.trace('lv_role_name exception: no_data_found');

1350: from wf_roles
1351: where name = lv_contact_user_name ;
1352:
1353: exception when no_data_found then
1354: hr_utility.trace('lv_role_name exception: no_data_found');
1355: null;
1356:
1357: end;
1358:

Line 1359: hr_utility.trace('orig system : '|| lv_orig_system);

1355: null;
1356:
1357: end;
1358:
1359: hr_utility.trace('orig system : '|| lv_orig_system);
1360: hr_utility.trace('orig system id : '|| lv_orig_system_id);
1361: hr_utility.trace('role name = ' || lv_role_name);
1362:
1363: wf_engine.SetItemOwner (itemtype => ItemType,

Line 1360: hr_utility.trace('orig system id : '|| lv_orig_system_id);

1356:
1357: end;
1358:
1359: hr_utility.trace('orig system : '|| lv_orig_system);
1360: hr_utility.trace('orig system id : '|| lv_orig_system_id);
1361: hr_utility.trace('role name = ' || lv_role_name);
1362:
1363: wf_engine.SetItemOwner (itemtype => ItemType,
1364: itemkey => ItemKey,

Line 1361: hr_utility.trace('role name = ' || lv_role_name);

1357: end;
1358:
1359: hr_utility.trace('orig system : '|| lv_orig_system);
1360: hr_utility.trace('orig system id : '|| lv_orig_system_id);
1361: hr_utility.trace('role name = ' || lv_role_name);
1362:
1363: wf_engine.SetItemOwner (itemtype => ItemType,
1364: itemkey => ItemKey,
1365: owner => ProcessOwner);

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

1620: end if;
1621:
1622: lv_process_list_html_2 := lv_process_list_html_2||')';
1623:
1624: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1625: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1626: hr_utility.trace('p_date_earned = ' || p_date_earned);
1627: hr_utility.trace('p_date_paid = ' || p_date_paid);
1628: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);

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

1621:
1622: lv_process_list_html_2 := lv_process_list_html_2||')';
1623:
1624: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1625: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1626: hr_utility.trace('p_date_earned = ' || p_date_earned);
1627: hr_utility.trace('p_date_paid = ' || p_date_paid);
1628: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1629: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);

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

1622: lv_process_list_html_2 := lv_process_list_html_2||')';
1623:
1624: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1625: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1626: hr_utility.trace('p_date_earned = ' || p_date_earned);
1627: hr_utility.trace('p_date_paid = ' || p_date_paid);
1628: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1629: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1630:

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

1623:
1624: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1625: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1626: hr_utility.trace('p_date_earned = ' || p_date_earned);
1627: hr_utility.trace('p_date_paid = ' || p_date_paid);
1628: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1629: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1630:
1631: begin

Line 1628: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);

1624: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1625: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1626: hr_utility.trace('p_date_earned = ' || p_date_earned);
1627: hr_utility.trace('p_date_paid = ' || p_date_paid);
1628: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1629: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1630:
1631: begin
1632:

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

1625: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1626: hr_utility.trace('p_date_earned = ' || p_date_earned);
1627: hr_utility.trace('p_date_paid = ' || p_date_paid);
1628: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1629: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1630:
1631: begin
1632:
1633: num_varname(1) := 'USER_ID';

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

2345:
2346: -- print out set values for attributes
2347:
2348: for j in varname.first..varname.last loop
2349: hr_utility.trace( 'varname '|| j ||' = '||varname(j));
2350: hr_utility.trace( 'varval '|| j ||' = '||varval(j));
2351: end loop;
2352:
2353:

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

2346: -- print out set values for attributes
2347:
2348: for j in varname.first..varname.last loop
2349: hr_utility.trace( 'varname '|| j ||' = '||varname(j));
2350: hr_utility.trace( 'varval '|| j ||' = '||varval(j));
2351: end loop;
2352:
2353:
2354: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);

Line 2355: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));

2351: end loop;
2352:
2353:
2354: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
2355: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
2356:
2357: for k in num_varname.first..num_varname.last loop
2358: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
2359: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));

Line 2358: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));

2354: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
2355: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
2356:
2357: for k in num_varname.first..num_varname.last loop
2358: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
2359: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));
2360: end loop;
2361:
2362:

Line 2359: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));

2355: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
2356:
2357: for k in num_varname.first..num_varname.last loop
2358: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
2359: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));
2360: end loop;
2361:
2362:
2363: wf_engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);

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

2360: end loop;
2361:
2362:
2363: wf_engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
2364: hr_utility.trace( 'Total Num Count = '||to_char(num_varname.COUNT));
2365:
2366: exception
2367: when OTHERS then
2368: hr_utility.trace('varname exception: OTHERS of TextArray');

Line 2368: hr_utility.trace('varname exception: OTHERS of TextArray');

2364: hr_utility.trace( 'Total Num Count = '||to_char(num_varname.COUNT));
2365:
2366: exception
2367: when OTHERS then
2368: hr_utility.trace('varname exception: OTHERS of TextArray');
2369: raise;
2370: end;
2371:
2372: hr_utility.trace('Before StartProcess');

Line 2372: hr_utility.trace('Before StartProcess');

2368: hr_utility.trace('varname exception: OTHERS of TextArray');
2369: raise;
2370: end;
2371:
2372: hr_utility.trace('Before StartProcess');
2373:
2374: wf_engine.StartProcess (ItemType => ItemType,
2375: ItemKey => ItemKey );
2376:

Line 2377: hr_utility.trace('After StartProcess');

2373:
2374: wf_engine.StartProcess (ItemType => ItemType,
2375: ItemKey => ItemKey );
2376:
2377: hr_utility.trace('After StartProcess');
2378:
2379: hr_utility.set_location('Leaving: ' || l_proc, 100);
2380:
2381:

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

2375: ItemKey => ItemKey );
2376:
2377: hr_utility.trace('After StartProcess');
2378:
2379: hr_utility.set_location('Leaving: ' || l_proc, 100);
2380:
2381:
2382: exception
2383: when others then

Line 2424: hr_utility.set_location('Starting: ' || l_proc, 100);

2420: and organization_id = p_gre_id;
2421:
2422: begin
2423:
2424: hr_utility.set_location('Starting: ' || l_proc, 100);
2425:
2426: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
2427:
2428: hr_utility.trace('Profile Value : '|| lv_contact_source);

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

2424: hr_utility.set_location('Starting: ' || l_proc, 100);
2425:
2426: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
2427:
2428: hr_utility.trace('Profile Value : '|| lv_contact_source);
2429: hr_utility.trace('Payroll Id : '|| p_payroll_id);
2430: hr_utility.trace('GRE Id : '|| p_gre_id);
2431: hr_utility.trace('Effective Date : '|| p_effective_date);
2432:

Line 2429: hr_utility.trace('Payroll Id : '|| p_payroll_id);

2425:
2426: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
2427:
2428: hr_utility.trace('Profile Value : '|| lv_contact_source);
2429: hr_utility.trace('Payroll Id : '|| p_payroll_id);
2430: hr_utility.trace('GRE Id : '|| p_gre_id);
2431: hr_utility.trace('Effective Date : '|| p_effective_date);
2432:
2433:

Line 2430: hr_utility.trace('GRE Id : '|| p_gre_id);

2426: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
2427:
2428: hr_utility.trace('Profile Value : '|| lv_contact_source);
2429: hr_utility.trace('Payroll Id : '|| p_payroll_id);
2430: hr_utility.trace('GRE Id : '|| p_gre_id);
2431: hr_utility.trace('Effective Date : '|| p_effective_date);
2432:
2433:
2434: if lv_contact_source = 'PAYROLL' then

Line 2431: hr_utility.trace('Effective Date : '|| p_effective_date);

2427:
2428: hr_utility.trace('Profile Value : '|| lv_contact_source);
2429: hr_utility.trace('Payroll Id : '|| p_payroll_id);
2430: hr_utility.trace('GRE Id : '|| p_gre_id);
2431: hr_utility.trace('Effective Date : '|| p_effective_date);
2432:
2433:
2434: if lv_contact_source = 'PAYROLL' then
2435:

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

2435:
2436: open c_payroll_contact;
2437: fetch c_payroll_contact into lv_contact_user_name;
2438:
2439: hr_utility.trace('Contact User : '|| lv_contact_user_name);
2440:
2441: if c_payroll_contact%NOTFOUND then
2442: lv_contact_user_name := 'SYSADMIN';
2443: end if;

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

2465: end if;
2466:
2467: return lv_contact_user_name;
2468:
2469: hr_utility.set_location('Leaving: ' || l_proc, 100);
2470:
2471: end get_notifier;
2472:
2473:

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

2473:
2474: procedure error is
2475: begin
2476:
2477: hr_utility.trace('Run time error in test script');
2478: hr_utility.trace('Sqlerror: '||sqlerrm);
2479: hr_utility.trace('Errname: '||wf_core.error_name);
2480: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));

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

2474: procedure error is
2475: begin
2476:
2477: hr_utility.trace('Run time error in test script');
2478: hr_utility.trace('Sqlerror: '||sqlerrm);
2479: hr_utility.trace('Errname: '||wf_core.error_name);
2480: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));

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

2475: begin
2476:
2477: hr_utility.trace('Run time error in test script');
2478: hr_utility.trace('Sqlerror: '||sqlerrm);
2479: hr_utility.trace('Errname: '||wf_core.error_name);
2480: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));

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

2476:
2477: hr_utility.trace('Run time error in test script');
2478: hr_utility.trace('Sqlerror: '||sqlerrm);
2479: hr_utility.trace('Errname: '||wf_core.error_name);
2480: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));

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

2477: hr_utility.trace('Run time error in test script');
2478: hr_utility.trace('Sqlerror: '||sqlerrm);
2479: hr_utility.trace('Errname: '||wf_core.error_name);
2480: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));

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

2478: hr_utility.trace('Sqlerror: '||sqlerrm);
2479: hr_utility.trace('Errname: '||wf_core.error_name);
2480: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));

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

2479: hr_utility.trace('Errname: '||wf_core.error_name);
2480: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2487: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));

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

2480: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2487: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2488: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));

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

2481: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2487: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2488: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2489: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));

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

2482: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2487: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2488: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2489: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2490: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));

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

2483: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2487: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2488: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2489: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2490: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2491:

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

2484: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2487: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2488: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2489: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2490: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2491:
2492: end error;

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

2485: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2487: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2488: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2489: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2490: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2491:
2492: end error;
2493:

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

2486: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
2487: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
2488: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
2489: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
2490: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
2491:
2492: end error;
2493:
2494: