APPS.PAY_WF_PKG dependencies on HR_UTILITY

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

172:
173: --
174: --
175: begin
176: --hr_utility.trace_on(null,'PYWF');
177: gv_package := 'pay_wf_pkg';
178: l_RequestorUsername := 'SYSADMIN';
179:
180: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;

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

195: and name = l_workflowprocess
196: and end_date is null;
197:
198: Exception when others then
199: hr_utility.trace('In exception: OTHERS at payroll_wf_process');
200: null;
201:
202: END;
203:

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

202: END;
203:
204:
205:
206: hr_utility.trace('Item Type is : '|| l_item_type);
207: hr_utility.trace('Item Key is : '|| l_item_key);
208: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
209:
210: if lv_runnable_process = 'Y' then

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

203:
204:
205:
206: hr_utility.trace('Item Type is : '|| l_item_type);
207: hr_utility.trace('Item Key is : '|| l_item_key);
208: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
209:
210: if lv_runnable_process = 'Y' then
211:

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

204:
205:
206: hr_utility.trace('Item Type is : '|| l_item_type);
207: hr_utility.trace('Item Key is : '|| l_item_key);
208: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
209:
210: if lv_runnable_process = 'Y' then
211:
212: StartProcess( p_business_group_id,

Line 306: WHEN hr_utility.hr_error THEN

302: end if;
303:
304: EXCEPTION
305: --
306: WHEN hr_utility.hr_error THEN
307: --
308: -- Set up error message and error return code.
309: --
310: --hr_utility.trace('in the exception');

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

306: WHEN hr_utility.hr_error THEN
307: --
308: -- Set up error message and error return code.
309: --
310: --hr_utility.trace('in the exception');
311: errbuf := hr_utility.get_message;
312: retcode := 2;
313: --
314: --

Line 311: errbuf := hr_utility.get_message;

307: --
308: -- Set up error message and error return code.
309: --
310: --hr_utility.trace('in the exception');
311: errbuf := hr_utility.get_message;
312: retcode := 2;
313: --
314: --
315: WHEN others THEN

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

426:
427: --
428: --
429: begin
430: --hr_utility.trace_on(null,'PYWF');
431: gv_package := 'pay_wf_pkg';
432: l_RequestorUsername := 'SYSADMIN';
433:
434: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;

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

449: and name = l_workflowprocess
450: and end_date is null;
451:
452: Exception when others then
453: hr_utility.trace('In exception: OTHERS at payroll_wf_process');
454: null;
455:
456: END;
457:

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

456: END;
457:
458:
459:
460: hr_utility.trace('Item Type is : '|| l_item_type);
461: hr_utility.trace('Item Key is : '|| l_item_key);
462: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
463:
464: if lv_runnable_process = 'Y' then

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

457:
458:
459:
460: hr_utility.trace('Item Type is : '|| l_item_type);
461: hr_utility.trace('Item Key is : '|| l_item_key);
462: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
463:
464: if lv_runnable_process = 'Y' then
465:

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

458:
459:
460: hr_utility.trace('Item Type is : '|| l_item_type);
461: hr_utility.trace('Item Key is : '|| l_item_key);
462: hr_utility.trace('Workflow Process is : '|| l_workflowprocess);
463:
464: if lv_runnable_process = 'Y' then
465:
466: StartProcess( p_business_group_id,

Line 565: WHEN hr_utility.hr_error THEN

561: end if;
562:
563: EXCEPTION
564: --
565: WHEN hr_utility.hr_error THEN
566: --
567: -- Set up error message and error return code.
568: --
569: --hr_utility.trace('in the exception');

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

565: WHEN hr_utility.hr_error THEN
566: --
567: -- Set up error message and error return code.
568: --
569: --hr_utility.trace('in the exception');
570: errbuf := hr_utility.get_message;
571: retcode := 2;
572: --
573: --

Line 570: errbuf := hr_utility.get_message;

566: --
567: -- Set up error message and error return code.
568: --
569: --hr_utility.trace('in the exception');
570: errbuf := hr_utility.get_message;
571: retcode := 2;
572: --
573: --
574: WHEN others THEN

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

880: -- exception
881: -- when others then null;
882: -- end;
883:
884: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
885: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
886: hr_utility.trace('WF process name is : '|| Workflowprocess);
887:
888: begin

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

881: -- when others then null;
882: -- end;
883:
884: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
885: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
886: hr_utility.trace('WF process name is : '|| Workflowprocess);
887:
888: begin
889: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;

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

882: -- end;
883:
884: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
885: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
886: hr_utility.trace('WF process name is : '|| Workflowprocess);
887:
888: begin
889: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
890: end;

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

888: begin
889: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
890: end;
891:
892: hr_utility.trace('b4 create_process');
893:
894: wf_engine.createProcess( ItemType => ItemType,
895: ItemKey => ItemKey,
896: process => Workflowprocess);

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

897:
898: wf_engine.SetItemUserKey( ItemType => ItemType,
899: ItemKey => ItemKey,
900: UserKey => ItemUserKey);
901: hr_utility.trace('In Start Process b4 HR_SIGNON.Initialize_HR_Security');
902: HR_SIGNON.Initialize_HR_Security;
903: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of Start ');
904:
905: l_user_id:= FND_GLOBAL.USER_ID;

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

899: ItemKey => ItemKey,
900: UserKey => ItemUserKey);
901: hr_utility.trace('In Start Process b4 HR_SIGNON.Initialize_HR_Security');
902: HR_SIGNON.Initialize_HR_Security;
903: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of Start ');
904:
905: l_user_id:= FND_GLOBAL.USER_ID;
906: l_resp_appl_id:= FND_GLOBAL.RESP_APPL_ID;
907: l_resp_id:= FND_GLOBAL.RESP_ID;

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

909:
910: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
911: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
912:
913: hr_utility.trace('l_user_id = ' || l_user_id);
914: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
915: hr_utility.trace('l_resp_id = ' || l_resp_id);
916: hr_utility.trace('l_org_id = ' || l_org_id);
917: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);

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

910: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
911: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
912:
913: hr_utility.trace('l_user_id = ' || l_user_id);
914: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
915: hr_utility.trace('l_resp_id = ' || l_resp_id);
916: hr_utility.trace('l_org_id = ' || l_org_id);
917: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
918: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);

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

911: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
912:
913: hr_utility.trace('l_user_id = ' || l_user_id);
914: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
915: hr_utility.trace('l_resp_id = ' || l_resp_id);
916: hr_utility.trace('l_org_id = ' || l_org_id);
917: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
918: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
919: hr_utility.trace('BG = ' || to_char(p_business_group_id));

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

912:
913: hr_utility.trace('l_user_id = ' || l_user_id);
914: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
915: hr_utility.trace('l_resp_id = ' || l_resp_id);
916: hr_utility.trace('l_org_id = ' || l_org_id);
917: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
918: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
919: hr_utility.trace('BG = ' || to_char(p_business_group_id));
920: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);

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

913: hr_utility.trace('l_user_id = ' || l_user_id);
914: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
915: hr_utility.trace('l_resp_id = ' || l_resp_id);
916: hr_utility.trace('l_org_id = ' || l_org_id);
917: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
918: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
919: hr_utility.trace('BG = ' || to_char(p_business_group_id));
920: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
921:

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

914: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
915: hr_utility.trace('l_resp_id = ' || l_resp_id);
916: hr_utility.trace('l_org_id = ' || l_org_id);
917: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
918: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
919: hr_utility.trace('BG = ' || to_char(p_business_group_id));
920: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
921:
922:

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

915: hr_utility.trace('l_resp_id = ' || l_resp_id);
916: hr_utility.trace('l_org_id = ' || l_org_id);
917: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
918: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
919: hr_utility.trace('BG = ' || to_char(p_business_group_id));
920: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
921:
922:
923: /*

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

916: hr_utility.trace('l_org_id = ' || l_org_id);
917: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
918: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
919: hr_utility.trace('BG = ' || to_char(p_business_group_id));
920: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
921:
922:
923: /*
924: fnd_global.apps_initialize(l_user_id,l_resp_id,l_resp_appl_id);

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

928: select currency_code into lv_currency_code
929: from per_business_groups
930: where business_group_id = p_business_group_id;
931: Exception when others then
932: hr_utility.trace('In exception: OTHERS ');
933: null;
934:
935: END;
936:

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

945: AND BG.BUSINESS_GROUP_ID= p_business_group_id
946: AND PPT.PAYMENT_TYPE_NAME = 'NACHA'
947: );
948: Exception when others then
949: hr_utility.trace('In exception: OTHERS ');
950: null;
951:
952: END;
953:

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

963: AND BG.BUSINESS_GROUP_ID= p_business_group_id
964: AND PPT.PAYMENT_TYPE_NAME = 'Check'
965: );
966: Exception when others then
967: hr_utility.trace('In exception: OTHERS ');
968: null;
969:
970: END;
971:

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

975: from pay_report_format_mappings_f
976: where report_type = 'DAR'
977: and report_category = p_da_report_category;
978: Exception when others then
979: hr_utility.trace('In exception: OTHERS ');
980: null;
981:
982: END;
983:

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

989: where payroll_id = p_payroll_id
990: and fnd_date.canonical_to_date(p_date_earned)
991: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
992:
993: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
994: Exception when others then
995: hr_utility.trace('In exception: OTHERS ');
996: null;
997:

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

991: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
992:
993: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
994: Exception when others then
995: hr_utility.trace('In exception: OTHERS ');
996: null;
997:
998: END;
999:

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

1002: select consolidation_set_name into lv_consolidation_set_name
1003: from pay_consolidation_sets
1004: where consolidation_set_id = p_consolidation_set_id;
1005:
1006: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
1007: Exception when others then
1008: hr_utility.trace('In exception: OTHERS ');
1009: null;
1010:

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

1004: where consolidation_set_id = p_consolidation_set_id;
1005:
1006: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
1007: Exception when others then
1008: hr_utility.trace('In exception: OTHERS ');
1009: null;
1010:
1011: END;
1012:

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

1014: -- GRE Name
1015: select name into lv_gre_name
1016: from hr_tax_units_v
1017: where tax_unit_id = to_number(p_gre);
1018: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1019:
1020: Exception when others then
1021: hr_utility.trace('In exception: OTHERS ');
1022: null;

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

1017: where tax_unit_id = to_number(p_gre);
1018: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1019:
1020: Exception when others then
1021: hr_utility.trace('In exception: OTHERS ');
1022: null;
1023:
1024: END;
1025:

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

1027: -- Period Name
1028: select PERIOD_NAME into lv_period_name
1029: from per_time_periods
1030: where time_period_id = p_period;
1031: hr_utility.trace('lv_period_name = ' || lv_period_name);
1032:
1033: Exception when others then
1034: hr_utility.trace('In exception: OTHERS ');
1035: null;

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

1030: where time_period_id = p_period;
1031: hr_utility.trace('lv_period_name = ' || lv_period_name);
1032:
1033: Exception when others then
1034: hr_utility.trace('In exception: OTHERS ');
1035: null;
1036:
1037: END;
1038:

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

1042: into lv_event_group_name
1043: from pay_event_groups
1044: where event_group_id = substr(p_event_group,12,length(p_event_group));
1045:
1046: hr_utility.trace('lv_event_group_name = ' || lv_event_group_name);
1047:
1048: Exception when others then
1049: hr_utility.trace('In exception: OTHERS ');
1050: null;

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

1045:
1046: hr_utility.trace('lv_event_group_name = ' || lv_event_group_name);
1047:
1048: Exception when others then
1049: hr_utility.trace('In exception: OTHERS ');
1050: null;
1051:
1052: END;
1053:

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

1059: where business_group_id = p_business_group_id
1060: and org_payment_method_id = p_nacha_payment_method
1061: and fnd_date.canonical_to_date(p_date_earned)
1062: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1063: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
1064:
1065: Exception when others then
1066: hr_utility.trace('In exception: OTHERS Nacha Org Payment Method Name ');
1067: null;

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

1062: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1063: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
1064:
1065: Exception when others then
1066: hr_utility.trace('In exception: OTHERS Nacha Org Payment Method Name ');
1067: null;
1068:
1069: END;
1070:

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

1076: where business_group_id = p_business_group_id
1077: and org_payment_method_id = p_check_writer_payment_method
1078: and fnd_date.canonical_to_date(p_date_earned)
1079: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1080: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
1081: Exception when others then
1082: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');
1083: null;
1084:

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

1078: and fnd_date.canonical_to_date(p_date_earned)
1079: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1080: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
1081: Exception when others then
1082: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');
1083: null;
1084:
1085: END;
1086:

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

1092: where business_group_id = p_business_group_id
1093: and org_payment_method_id = p_payment_method_override
1094: and fnd_date.canonical_to_date(p_date_earned)
1095: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1096: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
1097: Exception when others then
1098: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');
1099: null;
1100:

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

1094: and fnd_date.canonical_to_date(p_date_earned)
1095: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1096: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
1097: Exception when others then
1098: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');
1099: null;
1100:
1101: END;
1102:

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

1104: open cur_costing_summary_accruals;
1105: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
1106: close cur_costing_summary_accruals;
1107:
1108: hr_utility.trace('Costing Summary Accruals = ' || lv_cost_summary_accruals);
1109:
1110: open cur_costing_summary_file_out;
1111: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
1112: close cur_costing_summary_file_out;

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

1110: open cur_costing_summary_file_out;
1111: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
1112: close cur_costing_summary_file_out;
1113:
1114: hr_utility.trace('Costing Summary File Format = ' || lv_cost_summary_file_out);
1115:
1116: open cur_costing_detail_ele_set;
1117: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
1118: close cur_costing_detail_ele_set;

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

1116: open cur_costing_detail_ele_set;
1117: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
1118: close cur_costing_detail_ele_set;
1119:
1120: hr_utility.trace('Costing Detail Element Set = ' || lv_cost_detail_ele_set);
1121:
1122: open cur_costing_detail_ele_name;
1123: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
1124: close cur_costing_detail_ele_name;

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

1122: open cur_costing_detail_ele_name;
1123: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
1124: close cur_costing_detail_ele_name;
1125:
1126: hr_utility.trace('Costing Detail Element Name = ' || lv_cost_detail_ele_name);
1127:
1128: open cur_costing_detail_ele_class;
1129: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
1130: close cur_costing_detail_ele_class;

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

1128: open cur_costing_detail_ele_class;
1129: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
1130: close cur_costing_detail_ele_class;
1131:
1132: hr_utility.trace('Costing Detail Element Classification = ' || lv_cost_detail_ele_class);
1133:
1134: open cur_costing_detail_asg_set;
1135: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
1136: close cur_costing_detail_asg_set;

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

1134: open cur_costing_detail_asg_set;
1135: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
1136: close cur_costing_detail_asg_set;
1137:
1138: hr_utility.trace('Costing Detail Assignment Set = ' || lv_cost_detail_asg_set);
1139:
1140: open cur_costing_detail_accruals;
1141: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
1142: close cur_costing_detail_accruals;

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

1140: open cur_costing_detail_accruals;
1141: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
1142: close cur_costing_detail_accruals;
1143:
1144: hr_utility.trace('Costing Detail Accruals = ' || lv_cost_detail_accruals);
1145:
1146: END;
1147:
1148:

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

1152: into lv_Payroll_WF_Notify_Action
1153: from pay_action_parameters
1154: where parameter_name = 'PAYROLL_WF_NOTIFY_ACTION';
1155:
1156: hr_utility.trace('lv_Payroll_WF_Notify_Action = ' || lv_Payroll_WF_Notify_Action);
1157: If lv_Payroll_WF_Notify_Action = 'WAIT' then
1158: lv_isResponseRequired := 'Y';
1159: lv_isPaymentWait := 'Y';
1160: elsif lv_Payroll_WF_Notify_Action = 'NOWAIT' then

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

1164: lv_isResponseRequired := 'N';
1165: lv_isPaymentWait := 'Y';
1166: end if;
1167:
1168: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
1169: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
1170:
1171: Exception when others then
1172: hr_utility.trace('In exception: OTHERS ');

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

1165: lv_isPaymentWait := 'Y';
1166: end if;
1167:
1168: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
1169: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
1170:
1171: Exception when others then
1172: hr_utility.trace('In exception: OTHERS ');
1173: lv_isResponseRequired := 'Y';

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

1168: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
1169: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
1170:
1171: Exception when others then
1172: hr_utility.trace('In exception: OTHERS ');
1173: lv_isResponseRequired := 'Y';
1174: lv_isPaymentWait := 'Y';
1175: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
1176:

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

1171: Exception when others then
1172: hr_utility.trace('In exception: OTHERS ');
1173: lv_isResponseRequired := 'Y';
1174: lv_isPaymentWait := 'Y';
1175: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
1176:
1177: END;
1178:
1179: Begin

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

1183: from fnd_common_lookups
1184: where lookup_type = 'CHEQUE_PROCEDURE'
1185: and lookup_code = p_check_writer_sort_sequence;
1186:
1187: hr_utility.trace('lv_check_sort_seq_meaning = ' || lv_check_sort_seq_meaning);
1188: Exception when others then
1189: hr_utility.trace('In exception: OTHERS ');
1190: null;
1191:

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

1185: and lookup_code = p_check_writer_sort_sequence;
1186:
1187: hr_utility.trace('lv_check_sort_seq_meaning = ' || lv_check_sort_seq_meaning);
1188: Exception when others then
1189: hr_utility.trace('In exception: OTHERS ');
1190: null;
1191:
1192: END;
1193:

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

1200: from pqp_exception_reports per
1201: where legislation_code = 'US'
1202: and per.exception_report_id = p_exception_report_name;
1203:
1204: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
1205: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
1206: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
1207:
1208: Exception when others then

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

1201: where legislation_code = 'US'
1202: and per.exception_report_id = p_exception_report_name;
1203:
1204: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
1205: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
1206: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
1207:
1208: Exception when others then
1209: hr_utility.trace('In exception: OTHERS ');

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

1202: and per.exception_report_id = p_exception_report_name;
1203:
1204: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
1205: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
1206: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
1207:
1208: Exception when others then
1209: hr_utility.trace('In exception: OTHERS ');
1210: null;

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

1205: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
1206: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
1207:
1208: Exception when others then
1209: hr_utility.trace('In exception: OTHERS ');
1210: null;
1211:
1212: END;
1213: /*

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

1220: from pqp_exception_report_groups perg
1221: where legislation_code = 'US'
1222: and perg.EXCEPTION_GROUP_ID = p_exception_group_name;
1223:
1224: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1225: Exception when others then
1226: hr_utility.trace('In exception: OTHERS ');
1227: null;
1228:

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

1222: and perg.EXCEPTION_GROUP_ID = p_exception_group_name;
1223:
1224: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1225: Exception when others then
1226: hr_utility.trace('In exception: OTHERS ');
1227: null;
1228:
1229: END;
1230: */

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

1233: into lv_element_name
1234: from pay_element_types_f
1235: where element_type_id = p_element;
1236: Exception when others then
1237: hr_utility.trace('In exception: OTHERS ');
1238: null;
1239:
1240: END;
1241:

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

1246: into lv_batch_name
1247: from pay_batch_headers
1248: where batch_id = p_batch_id;
1249: End If;
1250: hr_utility.trace('Batch Name :' ||lv_batch_name);
1251:
1252: Exception when others then
1253: lv_batch_name := '';
1254: hr_utility.trace('In exception: Batch Name ');

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

1250: hr_utility.trace('Batch Name :' ||lv_batch_name);
1251:
1252: Exception when others then
1253: lv_batch_name := '';
1254: hr_utility.trace('In exception: Batch Name ');
1255: null;
1256:
1257: END;
1258:

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

1268: to_number(p_gre),
1269: p_date_earned);
1270:
1271: Exception when others then
1272: hr_utility.trace('In exception: OTHERS at get_notifier');
1273: null;
1274:
1275: END;
1276:

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

1281: from wf_roles
1282: where name = lv_contact_user_name ;
1283:
1284: Exception when others then
1285: hr_utility.trace('In exception: OTHERS ');
1286: null;
1287:
1288: END;
1289: -- For debugging .. remove the code

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

1316: select fnd_profile_server.value('USERNAME')
1317: into l_profile_user_name
1318: from dual;
1319:
1320: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1321: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1322: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1323: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1324:

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

1317: into l_profile_user_name
1318: from dual;
1319:
1320: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1321: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1322: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1323: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1324:
1325: Exception when others then

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

1318: from dual;
1319:
1320: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1321: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1322: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1323: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1324:
1325: Exception when others then
1326: hr_utility.trace('In exception: OTHERS at profile');

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

1319:
1320: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1321: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1322: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1323: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1324:
1325: Exception when others then
1326: hr_utility.trace('In exception: OTHERS at profile');
1327: null;

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

1322: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
1323: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
1324:
1325: Exception when others then
1326: hr_utility.trace('In exception: OTHERS at profile');
1327: null;
1328:
1329: END;
1330:

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

1328:
1329: END;
1330:
1331: --'JJ CA HRMS Manager';
1332: hr_utility.trace('orig ststem : '|| l_orig_system);
1333: hr_utility.trace('orig ststem : '|| l_orig_system_id);
1334: hr_utility.trace('l_role_name = ' || l_role_name);
1335:
1336: wf_engine.SetItemOwner ( itemtype => ItemType,

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

1329: END;
1330:
1331: --'JJ CA HRMS Manager';
1332: hr_utility.trace('orig ststem : '|| l_orig_system);
1333: hr_utility.trace('orig ststem : '|| l_orig_system_id);
1334: hr_utility.trace('l_role_name = ' || l_role_name);
1335:
1336: wf_engine.SetItemOwner ( itemtype => ItemType,
1337: itemkey => ItemKey,

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

1330:
1331: --'JJ CA HRMS Manager';
1332: hr_utility.trace('orig ststem : '|| l_orig_system);
1333: hr_utility.trace('orig ststem : '|| l_orig_system_id);
1334: hr_utility.trace('l_role_name = ' || l_role_name);
1335:
1336: wf_engine.SetItemOwner ( itemtype => ItemType,
1337: itemkey => ItemKey,
1338: owner => ProcessOwner);

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

1666: lv_cur_process(p) := null;
1667: end loop;
1668: end if;
1669:
1670: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1671: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1672: hr_utility.trace('p_date_earned = ' || p_date_earned);
1673: hr_utility.trace('p_date_paid = ' || p_date_paid);
1674: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);

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

1667: end loop;
1668: end if;
1669:
1670: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1671: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1672: hr_utility.trace('p_date_earned = ' || p_date_earned);
1673: hr_utility.trace('p_date_paid = ' || p_date_paid);
1674: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1675: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);

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

1668: end if;
1669:
1670: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1671: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1672: hr_utility.trace('p_date_earned = ' || p_date_earned);
1673: hr_utility.trace('p_date_paid = ' || p_date_paid);
1674: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1675: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1676: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);

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

1669:
1670: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1671: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1672: hr_utility.trace('p_date_earned = ' || p_date_earned);
1673: hr_utility.trace('p_date_paid = ' || p_date_paid);
1674: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1675: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1676: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1677: hr_utility.trace('check_style = ' || p_check_style);

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

1670: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1671: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1672: hr_utility.trace('p_date_earned = ' || p_date_earned);
1673: hr_utility.trace('p_date_paid = ' || p_date_paid);
1674: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1675: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1676: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1677: hr_utility.trace('check_style = ' || p_check_style);
1678: begin

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

1671: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1672: hr_utility.trace('p_date_earned = ' || p_date_earned);
1673: hr_utility.trace('p_date_paid = ' || p_date_paid);
1674: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1675: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1676: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1677: hr_utility.trace('check_style = ' || p_check_style);
1678: begin
1679:

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

1672: hr_utility.trace('p_date_earned = ' || p_date_earned);
1673: hr_utility.trace('p_date_paid = ' || p_date_paid);
1674: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1675: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1676: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1677: hr_utility.trace('check_style = ' || p_check_style);
1678: begin
1679:
1680: i := 0;

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

1673: hr_utility.trace('p_date_paid = ' || p_date_paid);
1674: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
1675: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1676: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
1677: hr_utility.trace('check_style = ' || p_check_style);
1678: begin
1679:
1680: i := 0;
1681:

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

2215: num_varname(i) := 'SECURITY_GROUP_ID';
2216: num_varvalue(i) := l_profile_sec_grp_id;
2217:
2218: for j in varname.first..varname.last loop
2219: hr_utility.trace( 'J = '|| j );
2220: hr_utility.trace( 'varname = '||varname(j));
2221: hr_utility.trace( 'varval = '||varval(j));
2222: end loop;
2223:

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

2216: num_varvalue(i) := l_profile_sec_grp_id;
2217:
2218: for j in varname.first..varname.last loop
2219: hr_utility.trace( 'J = '|| j );
2220: hr_utility.trace( 'varname = '||varname(j));
2221: hr_utility.trace( 'varval = '||varval(j));
2222: end loop;
2223:
2224: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);

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

2217:
2218: for j in varname.first..varname.last loop
2219: hr_utility.trace( 'J = '|| j );
2220: hr_utility.trace( 'varname = '||varname(j));
2221: hr_utility.trace( 'varval = '||varval(j));
2222: end loop;
2223:
2224: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
2225: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));

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

2221: hr_utility.trace( 'varval = '||varval(j));
2222: end loop;
2223:
2224: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
2225: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
2226:
2227: for p in num_varname.first..num_varname.last loop
2228: hr_utility.trace( 'p = '|| p );
2229: hr_utility.trace( 'num_varname = '||num_varname(p));

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

2224: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
2225: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
2226:
2227: for p in num_varname.first..num_varname.last loop
2228: hr_utility.trace( 'p = '|| p );
2229: hr_utility.trace( 'num_varname = '||num_varname(p));
2230: hr_utility.trace( 'num_varval = '||num_varvalue(p));
2231: end loop;
2232:

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

2225: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
2226:
2227: for p in num_varname.first..num_varname.last loop
2228: hr_utility.trace( 'p = '|| p );
2229: hr_utility.trace( 'num_varname = '||num_varname(p));
2230: hr_utility.trace( 'num_varval = '||num_varvalue(p));
2231: end loop;
2232:
2233: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);

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

2226:
2227: for p in num_varname.first..num_varname.last loop
2228: hr_utility.trace( 'p = '|| p );
2229: hr_utility.trace( 'num_varname = '||num_varname(p));
2230: hr_utility.trace( 'num_varval = '||num_varvalue(p));
2231: end loop;
2232:
2233: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
2234:

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

2231: end loop;
2232:
2233: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
2234:
2235: hr_utility.trace( 'Total Num Kount = '||to_char(num_varname.COUNT));
2236: exception
2237: when OTHERS then
2238: hr_utility.trace('In exception: OTHERS of TextArray');
2239: raise;

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

2234:
2235: hr_utility.trace( 'Total Num Kount = '||to_char(num_varname.COUNT));
2236: exception
2237: when OTHERS then
2238: hr_utility.trace('In exception: OTHERS of TextArray');
2239: raise;
2240: end;
2241:
2242: /*

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

2260: itemkey => ItemKey,
2261: aname => 'MESSAGE_TEXT1',
2262: avalue => l_message_text1);
2263:
2264: hr_utility.trace('B4 SetItemAttrText : l_role_name = ' || l_role_name);
2265: wf_engine.SetItemAttrText ( itemtype => ItemType,
2266: itemkey => ItemKey,
2267: aname => 'ROLE_NAME',
2268: avalue => l_role_name);

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

2271: itemkey => ItemKey,
2272: aname => 'APPLNAME',
2273: avalue => 'PAY');
2274:
2275: hr_utility.trace('APPLNAME ');
2276: */
2277:
2278: hr_utility.trace('b4 starting process');
2279:

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

2274:
2275: hr_utility.trace('APPLNAME ');
2276: */
2277:
2278: hr_utility.trace('b4 starting process');
2279:
2280: wf_engine.StartProcess ( ItemType => ItemType,
2281: ItemKey => ItemKey );
2282: hr_utility.trace('a4 starting process');

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

2278: hr_utility.trace('b4 starting process');
2279:
2280: wf_engine.StartProcess ( ItemType => ItemType,
2281: ItemKey => ItemKey );
2282: hr_utility.trace('a4 starting process');
2283:
2284:
2285:
2286: exception

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

2603: -- exception
2604: -- when others then null;
2605: -- end;
2606:
2607: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
2608: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
2609: hr_utility.trace('WF process name is : '|| Workflowprocess);
2610:
2611: begin

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

2604: -- when others then null;
2605: -- end;
2606:
2607: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
2608: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
2609: hr_utility.trace('WF process name is : '|| Workflowprocess);
2610:
2611: begin
2612: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;

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

2605: -- end;
2606:
2607: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
2608: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
2609: hr_utility.trace('WF process name is : '|| Workflowprocess);
2610:
2611: begin
2612: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
2613: end;

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

2611: begin
2612: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
2613: end;
2614:
2615: hr_utility.trace('b4 create_process');
2616:
2617: wf_engine.createProcess( ItemType => ItemType,
2618: ItemKey => ItemKey,
2619: process => Workflowprocess);

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

2620:
2621: wf_engine.SetItemUserKey( ItemType => ItemType,
2622: ItemKey => ItemKey,
2623: UserKey => ItemUserKey);
2624: hr_utility.trace('In Start Process b4 HR_SIGNON.Initialize_HR_Security');
2625: HR_SIGNON.Initialize_HR_Security;
2626: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of Start ');
2627:
2628: l_user_id:= FND_GLOBAL.USER_ID;

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

2622: ItemKey => ItemKey,
2623: UserKey => ItemUserKey);
2624: hr_utility.trace('In Start Process b4 HR_SIGNON.Initialize_HR_Security');
2625: HR_SIGNON.Initialize_HR_Security;
2626: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of Start ');
2627:
2628: l_user_id:= FND_GLOBAL.USER_ID;
2629: l_resp_appl_id:= FND_GLOBAL.RESP_APPL_ID;
2630: l_resp_id:= FND_GLOBAL.RESP_ID;

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

2632:
2633: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
2634: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
2635:
2636: hr_utility.trace('l_user_id = ' || l_user_id);
2637: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
2638: hr_utility.trace('l_resp_id = ' || l_resp_id);
2639: hr_utility.trace('l_org_id = ' || l_org_id);
2640: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);

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

2633: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
2634: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
2635:
2636: hr_utility.trace('l_user_id = ' || l_user_id);
2637: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
2638: hr_utility.trace('l_resp_id = ' || l_resp_id);
2639: hr_utility.trace('l_org_id = ' || l_org_id);
2640: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
2641: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);

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

2634: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
2635:
2636: hr_utility.trace('l_user_id = ' || l_user_id);
2637: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
2638: hr_utility.trace('l_resp_id = ' || l_resp_id);
2639: hr_utility.trace('l_org_id = ' || l_org_id);
2640: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
2641: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
2642: hr_utility.trace('BG = ' || to_char(p_business_group_id));

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

2635:
2636: hr_utility.trace('l_user_id = ' || l_user_id);
2637: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
2638: hr_utility.trace('l_resp_id = ' || l_resp_id);
2639: hr_utility.trace('l_org_id = ' || l_org_id);
2640: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
2641: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
2642: hr_utility.trace('BG = ' || to_char(p_business_group_id));
2643: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);

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

2636: hr_utility.trace('l_user_id = ' || l_user_id);
2637: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
2638: hr_utility.trace('l_resp_id = ' || l_resp_id);
2639: hr_utility.trace('l_org_id = ' || l_org_id);
2640: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
2641: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
2642: hr_utility.trace('BG = ' || to_char(p_business_group_id));
2643: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
2644:

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

2637: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
2638: hr_utility.trace('l_resp_id = ' || l_resp_id);
2639: hr_utility.trace('l_org_id = ' || l_org_id);
2640: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
2641: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
2642: hr_utility.trace('BG = ' || to_char(p_business_group_id));
2643: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
2644:
2645:

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

2638: hr_utility.trace('l_resp_id = ' || l_resp_id);
2639: hr_utility.trace('l_org_id = ' || l_org_id);
2640: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
2641: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
2642: hr_utility.trace('BG = ' || to_char(p_business_group_id));
2643: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
2644:
2645:
2646: /*

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

2639: hr_utility.trace('l_org_id = ' || l_org_id);
2640: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
2641: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
2642: hr_utility.trace('BG = ' || to_char(p_business_group_id));
2643: hr_utility.trace('PAYMENT TYPE = ' || p_nacha_payment_type);
2644:
2645:
2646: /*
2647: fnd_global.apps_initialize(l_user_id,l_resp_id,l_resp_appl_id);

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

2651: select currency_code into lv_currency_code
2652: from per_business_groups
2653: where business_group_id = p_business_group_id;
2654: Exception when others then
2655: hr_utility.trace('In exception: OTHERS ');
2656: null;
2657:
2658: END;
2659:

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

2668: AND BG.BUSINESS_GROUP_ID= p_business_group_id
2669: AND PPT.PAYMENT_TYPE_NAME = 'NACHA'
2670: );
2671: Exception when others then
2672: hr_utility.trace('In exception: OTHERS ');
2673: null;
2674:
2675: END;
2676:

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

2686: AND BG.BUSINESS_GROUP_ID= p_business_group_id
2687: AND PPT.PAYMENT_TYPE_NAME = 'Check'
2688: );
2689: Exception when others then
2690: hr_utility.trace('In exception: OTHERS ');
2691: null;
2692:
2693: END;
2694:

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

2698: from pay_report_format_mappings_f
2699: where report_type = 'DAR'
2700: and report_category = p_da_report_category;
2701: Exception when others then
2702: hr_utility.trace('In exception: OTHERS ');
2703: null;
2704:
2705: END;
2706:

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

2712: where payroll_id = p_payroll_id
2713: and fnd_date.canonical_to_date(p_date_earned)
2714: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2715:
2716: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
2717: Exception when others then
2718: hr_utility.trace('In exception: OTHERS ');
2719: null;
2720:

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

2714: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2715:
2716: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
2717: Exception when others then
2718: hr_utility.trace('In exception: OTHERS ');
2719: null;
2720:
2721: END;
2722:

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

2725: select consolidation_set_name into lv_consolidation_set_name
2726: from pay_consolidation_sets
2727: where consolidation_set_id = p_consolidation_set_id;
2728:
2729: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
2730: Exception when others then
2731: hr_utility.trace('In exception: OTHERS ');
2732: null;
2733:

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

2727: where consolidation_set_id = p_consolidation_set_id;
2728:
2729: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
2730: Exception when others then
2731: hr_utility.trace('In exception: OTHERS ');
2732: null;
2733:
2734: END;
2735:

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

2737: -- GRE Name
2738: select name into lv_gre_name
2739: from hr_tax_units_v
2740: where tax_unit_id = to_number(p_gre);
2741: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
2742:
2743: Exception when others then
2744: hr_utility.trace('In exception: OTHERS ');
2745: null;

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

2740: where tax_unit_id = to_number(p_gre);
2741: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
2742:
2743: Exception when others then
2744: hr_utility.trace('In exception: OTHERS ');
2745: null;
2746:
2747: END;
2748:

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

2750: -- Period Name
2751: select PERIOD_NAME into lv_period_name
2752: from per_time_periods
2753: where time_period_id = p_period;
2754: hr_utility.trace('lv_period_name = ' || lv_period_name);
2755:
2756: Exception when others then
2757: hr_utility.trace('In exception: OTHERS ');
2758: null;

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

2753: where time_period_id = p_period;
2754: hr_utility.trace('lv_period_name = ' || lv_period_name);
2755:
2756: Exception when others then
2757: hr_utility.trace('In exception: OTHERS ');
2758: null;
2759:
2760: END;
2761:

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

2765: into lv_event_group_name
2766: from pay_event_groups
2767: where event_group_id = substr(p_event_group,12,length(p_event_group));
2768:
2769: hr_utility.trace('lv_event_group_name = ' || lv_event_group_name);
2770:
2771: Exception when others then
2772: hr_utility.trace('In exception: OTHERS ');
2773: null;

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

2768:
2769: hr_utility.trace('lv_event_group_name = ' || lv_event_group_name);
2770:
2771: Exception when others then
2772: hr_utility.trace('In exception: OTHERS ');
2773: null;
2774:
2775: END;
2776:

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

2782: where business_group_id = p_business_group_id
2783: and org_payment_method_id = p_nacha_payment_method
2784: and fnd_date.canonical_to_date(p_date_earned)
2785: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2786: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
2787:
2788: Exception when others then
2789: hr_utility.trace('In exception: OTHERS Nacha Org Payment Method Name ');
2790: null;

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

2785: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2786: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
2787:
2788: Exception when others then
2789: hr_utility.trace('In exception: OTHERS Nacha Org Payment Method Name ');
2790: null;
2791:
2792: END;
2793:

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

2799: where business_group_id = p_business_group_id
2800: and org_payment_method_id = p_check_writer_payment_method
2801: and fnd_date.canonical_to_date(p_date_earned)
2802: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2803: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
2804: Exception when others then
2805: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');
2806: null;
2807:

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

2801: and fnd_date.canonical_to_date(p_date_earned)
2802: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2803: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
2804: Exception when others then
2805: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');
2806: null;
2807:
2808: END;
2809:

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

2815: where business_group_id = p_business_group_id
2816: and org_payment_method_id = p_payment_method_override
2817: and fnd_date.canonical_to_date(p_date_earned)
2818: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2819: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
2820: Exception when others then
2821: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');
2822: null;
2823:

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

2817: and fnd_date.canonical_to_date(p_date_earned)
2818: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2819: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
2820: Exception when others then
2821: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');
2822: null;
2823:
2824: END;
2825:

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

2827: open cur_costing_summary_accruals;
2828: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
2829: close cur_costing_summary_accruals;
2830:
2831: hr_utility.trace('Costing Summary Accruals = ' || lv_cost_summary_accruals);
2832:
2833: open cur_costing_summary_file_out;
2834: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
2835: close cur_costing_summary_file_out;

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

2833: open cur_costing_summary_file_out;
2834: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
2835: close cur_costing_summary_file_out;
2836:
2837: hr_utility.trace('Costing Summary File Format = ' || lv_cost_summary_file_out);
2838:
2839: open cur_costing_detail_ele_set;
2840: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
2841: close cur_costing_detail_ele_set;

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

2839: open cur_costing_detail_ele_set;
2840: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
2841: close cur_costing_detail_ele_set;
2842:
2843: hr_utility.trace('Costing Detail Element Set = ' || lv_cost_detail_ele_set);
2844:
2845: open cur_costing_detail_ele_name;
2846: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
2847: close cur_costing_detail_ele_name;

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

2845: open cur_costing_detail_ele_name;
2846: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
2847: close cur_costing_detail_ele_name;
2848:
2849: hr_utility.trace('Costing Detail Element Name = ' || lv_cost_detail_ele_name);
2850:
2851: open cur_costing_detail_ele_class;
2852: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
2853: close cur_costing_detail_ele_class;

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

2851: open cur_costing_detail_ele_class;
2852: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
2853: close cur_costing_detail_ele_class;
2854:
2855: hr_utility.trace('Costing Detail Element Classification = ' || lv_cost_detail_ele_class);
2856:
2857: open cur_costing_detail_asg_set;
2858: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
2859: close cur_costing_detail_asg_set;

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

2857: open cur_costing_detail_asg_set;
2858: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
2859: close cur_costing_detail_asg_set;
2860:
2861: hr_utility.trace('Costing Detail Assignment Set = ' || lv_cost_detail_asg_set);
2862:
2863: open cur_costing_detail_accruals;
2864: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
2865: close cur_costing_detail_accruals;

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

2863: open cur_costing_detail_accruals;
2864: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
2865: close cur_costing_detail_accruals;
2866:
2867: hr_utility.trace('Costing Detail Accruals = ' || lv_cost_detail_accruals);
2868:
2869: -- bug 12704242
2870: open cur_retropay_definition;
2871: fetch cur_retropay_definition into lv_retropay_definition;

Line 2874: hr_utility.trace('Retro Definition id = ' || lv_retropay_definition);

2870: open cur_retropay_definition;
2871: fetch cur_retropay_definition into lv_retropay_definition;
2872: close cur_retropay_definition;
2873:
2874: hr_utility.trace('Retro Definition id = ' || lv_retropay_definition);
2875:
2876: END;
2877:
2878:

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

2882: into lv_Payroll_WF_Notify_Action
2883: from pay_action_parameters
2884: where parameter_name = 'PAYROLL_WF_NOTIFY_ACTION';
2885:
2886: hr_utility.trace('lv_Payroll_WF_Notify_Action = ' || lv_Payroll_WF_Notify_Action);
2887: If lv_Payroll_WF_Notify_Action = 'WAIT' then
2888: lv_isResponseRequired := 'Y';
2889: lv_isPaymentWait := 'Y';
2890: elsif lv_Payroll_WF_Notify_Action = 'NOWAIT' then

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

2894: lv_isResponseRequired := 'N';
2895: lv_isPaymentWait := 'Y';
2896: end if;
2897:
2898: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
2899: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
2900:
2901: Exception when others then
2902: hr_utility.trace('In exception: OTHERS ');

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

2895: lv_isPaymentWait := 'Y';
2896: end if;
2897:
2898: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
2899: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
2900:
2901: Exception when others then
2902: hr_utility.trace('In exception: OTHERS ');
2903: lv_isResponseRequired := 'Y';

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

2898: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
2899: hr_utility.trace('lv_isPaymentWait = ' || lv_isPaymentWait);
2900:
2901: Exception when others then
2902: hr_utility.trace('In exception: OTHERS ');
2903: lv_isResponseRequired := 'Y';
2904: lv_isPaymentWait := 'Y';
2905: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
2906:

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

2901: Exception when others then
2902: hr_utility.trace('In exception: OTHERS ');
2903: lv_isResponseRequired := 'Y';
2904: lv_isPaymentWait := 'Y';
2905: hr_utility.trace('lv_isResponseRequire = ' || lv_isResponseRequired);
2906:
2907: END;
2908:
2909: Begin

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

2913: from fnd_common_lookups
2914: where lookup_type = 'CHEQUE_PROCEDURE'
2915: and lookup_code = p_check_writer_sort_sequence;
2916:
2917: hr_utility.trace('lv_check_sort_seq_meaning = ' || lv_check_sort_seq_meaning);
2918: Exception when others then
2919: hr_utility.trace('In exception: OTHERS ');
2920: null;
2921:

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

2915: and lookup_code = p_check_writer_sort_sequence;
2916:
2917: hr_utility.trace('lv_check_sort_seq_meaning = ' || lv_check_sort_seq_meaning);
2918: Exception when others then
2919: hr_utility.trace('In exception: OTHERS ');
2920: null;
2921:
2922: END;
2923:

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

2930: from pqp_exception_reports per
2931: where legislation_code = 'US'
2932: and per.exception_report_id = p_exception_report_name;
2933:
2934: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
2935: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
2936: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
2937:
2938: Exception when others then

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

2931: where legislation_code = 'US'
2932: and per.exception_report_id = p_exception_report_name;
2933:
2934: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
2935: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
2936: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
2937:
2938: Exception when others then
2939: hr_utility.trace('In exception: OTHERS ');

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

2932: and per.exception_report_id = p_exception_report_name;
2933:
2934: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);
2935: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
2936: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
2937:
2938: Exception when others then
2939: hr_utility.trace('In exception: OTHERS ');
2940: null;

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

2935: hr_utility.trace('lv_orv_type = ' || lv_orv_type);
2936: hr_utility.trace('lv_orv_value = ' || lv_orv_value);
2937:
2938: Exception when others then
2939: hr_utility.trace('In exception: OTHERS ');
2940: null;
2941:
2942: END;
2943: /*

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

2950: from pqp_exception_report_groups perg
2951: where legislation_code = 'US'
2952: and perg.EXCEPTION_GROUP_ID = p_exception_group_name;
2953:
2954: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
2955: Exception when others then
2956: hr_utility.trace('In exception: OTHERS ');
2957: null;
2958:

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

2952: and perg.EXCEPTION_GROUP_ID = p_exception_group_name;
2953:
2954: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
2955: Exception when others then
2956: hr_utility.trace('In exception: OTHERS ');
2957: null;
2958:
2959: END;
2960: */

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

2963: into lv_element_name
2964: from pay_element_types_f
2965: where element_type_id = p_element;
2966: Exception when others then
2967: hr_utility.trace('In exception: OTHERS ');
2968: null;
2969:
2970: END;
2971:

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

2976: into lv_batch_name
2977: from pay_batch_headers
2978: where batch_id = p_batch_id;
2979: End If;
2980: hr_utility.trace('Batch Name :' ||lv_batch_name);
2981:
2982: Exception when others then
2983: lv_batch_name := '';
2984: hr_utility.trace('In exception: Batch Name ');

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

2980: hr_utility.trace('Batch Name :' ||lv_batch_name);
2981:
2982: Exception when others then
2983: lv_batch_name := '';
2984: hr_utility.trace('In exception: Batch Name ');
2985: null;
2986:
2987: END;
2988:

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

2998: to_number(p_gre),
2999: p_date_earned);
3000:
3001: Exception when others then
3002: hr_utility.trace('In exception: OTHERS at get_notifier');
3003: null;
3004:
3005: END;
3006:

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

3011: from wf_roles
3012: where name = lv_contact_user_name ;
3013:
3014: Exception when others then
3015: hr_utility.trace('In exception: OTHERS ');
3016: null;
3017:
3018: END;
3019: -- For debugging .. remove the code

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

3046: select fnd_profile_server.value('USERNAME')
3047: into l_profile_user_name
3048: from dual;
3049:
3050: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
3051: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
3052: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
3053: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
3054:

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

3047: into l_profile_user_name
3048: from dual;
3049:
3050: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
3051: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
3052: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
3053: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
3054:
3055: Exception when others then

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

3048: from dual;
3049:
3050: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
3051: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
3052: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
3053: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
3054:
3055: Exception when others then
3056: hr_utility.trace('In exception: OTHERS at profile');

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

3049:
3050: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
3051: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
3052: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
3053: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
3054:
3055: Exception when others then
3056: hr_utility.trace('In exception: OTHERS at profile');
3057: null;

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

3052: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);
3053: hr_utility.trace('jj payuswfpkg l_profile_user_namep = '||l_profile_user_name);
3054:
3055: Exception when others then
3056: hr_utility.trace('In exception: OTHERS at profile');
3057: null;
3058:
3059: END;
3060:

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

3058:
3059: END;
3060:
3061: --'JJ CA HRMS Manager';
3062: hr_utility.trace('orig ststem : '|| l_orig_system);
3063: hr_utility.trace('orig ststem : '|| l_orig_system_id);
3064: hr_utility.trace('l_role_name = ' || l_role_name);
3065:
3066: wf_engine.SetItemOwner ( itemtype => ItemType,

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

3059: END;
3060:
3061: --'JJ CA HRMS Manager';
3062: hr_utility.trace('orig ststem : '|| l_orig_system);
3063: hr_utility.trace('orig ststem : '|| l_orig_system_id);
3064: hr_utility.trace('l_role_name = ' || l_role_name);
3065:
3066: wf_engine.SetItemOwner ( itemtype => ItemType,
3067: itemkey => ItemKey,

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

3060:
3061: --'JJ CA HRMS Manager';
3062: hr_utility.trace('orig ststem : '|| l_orig_system);
3063: hr_utility.trace('orig ststem : '|| l_orig_system_id);
3064: hr_utility.trace('l_role_name = ' || l_role_name);
3065:
3066: wf_engine.SetItemOwner ( itemtype => ItemType,
3067: itemkey => ItemKey,
3068: owner => ProcessOwner);

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

3405: lv_cur_process(p) := null;
3406: end loop;
3407: end if;
3408:
3409: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
3410: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
3411: hr_utility.trace('p_date_earned = ' || p_date_earned);
3412: hr_utility.trace('p_date_paid = ' || p_date_paid);
3413: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);

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

3406: end loop;
3407: end if;
3408:
3409: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
3410: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
3411: hr_utility.trace('p_date_earned = ' || p_date_earned);
3412: hr_utility.trace('p_date_paid = ' || p_date_paid);
3413: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
3414: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);

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

3407: end if;
3408:
3409: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
3410: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
3411: hr_utility.trace('p_date_earned = ' || p_date_earned);
3412: hr_utility.trace('p_date_paid = ' || p_date_paid);
3413: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
3414: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
3415: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);

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

3408:
3409: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
3410: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
3411: hr_utility.trace('p_date_earned = ' || p_date_earned);
3412: hr_utility.trace('p_date_paid = ' || p_date_paid);
3413: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
3414: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
3415: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
3416: hr_utility.trace('check_style = ' || p_check_style);

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

3409: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
3410: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
3411: hr_utility.trace('p_date_earned = ' || p_date_earned);
3412: hr_utility.trace('p_date_paid = ' || p_date_paid);
3413: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
3414: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
3415: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
3416: hr_utility.trace('check_style = ' || p_check_style);
3417: begin

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

3410: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
3411: hr_utility.trace('p_date_earned = ' || p_date_earned);
3412: hr_utility.trace('p_date_paid = ' || p_date_paid);
3413: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
3414: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
3415: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
3416: hr_utility.trace('check_style = ' || p_check_style);
3417: begin
3418:

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

3411: hr_utility.trace('p_date_earned = ' || p_date_earned);
3412: hr_utility.trace('p_date_paid = ' || p_date_paid);
3413: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
3414: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
3415: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
3416: hr_utility.trace('check_style = ' || p_check_style);
3417: begin
3418:
3419: i := 0;

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

3412: hr_utility.trace('p_date_paid = ' || p_date_paid);
3413: hr_utility.trace('p_payroll_assignment_set_name = ' || p_payroll_assignment_set_name);
3414: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
3415: hr_utility.trace('ln_nacha_payment_type_id = ' || ln_nacha_payment_type_id);
3416: hr_utility.trace('check_style = ' || p_check_style);
3417: begin
3418:
3419: i := 0;
3420:

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

3978: num_varname(i) := 'SECURITY_GROUP_ID';
3979: num_varvalue(i) := l_profile_sec_grp_id;
3980:
3981: for j in varname.first..varname.last loop
3982: hr_utility.trace( 'J = '|| j );
3983: hr_utility.trace( 'varname = '||varname(j));
3984: hr_utility.trace( 'varval = '||varval(j));
3985: end loop;
3986:

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

3979: num_varvalue(i) := l_profile_sec_grp_id;
3980:
3981: for j in varname.first..varname.last loop
3982: hr_utility.trace( 'J = '|| j );
3983: hr_utility.trace( 'varname = '||varname(j));
3984: hr_utility.trace( 'varval = '||varval(j));
3985: end loop;
3986:
3987: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);

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

3980:
3981: for j in varname.first..varname.last loop
3982: hr_utility.trace( 'J = '|| j );
3983: hr_utility.trace( 'varname = '||varname(j));
3984: hr_utility.trace( 'varval = '||varval(j));
3985: end loop;
3986:
3987: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
3988: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));

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

3984: hr_utility.trace( 'varval = '||varval(j));
3985: end loop;
3986:
3987: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
3988: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
3989:
3990: for p in num_varname.first..num_varname.last loop
3991: hr_utility.trace( 'p = '|| p );
3992: hr_utility.trace( 'num_varname = '||num_varname(p));

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

3987: Wf_Engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
3988: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
3989:
3990: for p in num_varname.first..num_varname.last loop
3991: hr_utility.trace( 'p = '|| p );
3992: hr_utility.trace( 'num_varname = '||num_varname(p));
3993: hr_utility.trace( 'num_varval = '||num_varvalue(p));
3994: end loop;
3995:

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

3988: hr_utility.trace( 'Total Var Kount = '||to_char(varname.COUNT));
3989:
3990: for p in num_varname.first..num_varname.last loop
3991: hr_utility.trace( 'p = '|| p );
3992: hr_utility.trace( 'num_varname = '||num_varname(p));
3993: hr_utility.trace( 'num_varval = '||num_varvalue(p));
3994: end loop;
3995:
3996: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);

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

3989:
3990: for p in num_varname.first..num_varname.last loop
3991: hr_utility.trace( 'p = '|| p );
3992: hr_utility.trace( 'num_varname = '||num_varname(p));
3993: hr_utility.trace( 'num_varval = '||num_varvalue(p));
3994: end loop;
3995:
3996: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
3997:

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

3994: end loop;
3995:
3996: Wf_Engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
3997:
3998: hr_utility.trace( 'Total Num Kount = '||to_char(num_varname.COUNT));
3999: exception
4000: when OTHERS then
4001: hr_utility.trace('In exception: OTHERS of TextArray');
4002: raise;

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

3997:
3998: hr_utility.trace( 'Total Num Kount = '||to_char(num_varname.COUNT));
3999: exception
4000: when OTHERS then
4001: hr_utility.trace('In exception: OTHERS of TextArray');
4002: raise;
4003: end;
4004:
4005: /*

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

4023: itemkey => ItemKey,
4024: aname => 'MESSAGE_TEXT1',
4025: avalue => l_message_text1);
4026:
4027: hr_utility.trace('B4 SetItemAttrText : l_role_name = ' || l_role_name);
4028: wf_engine.SetItemAttrText ( itemtype => ItemType,
4029: itemkey => ItemKey,
4030: aname => 'ROLE_NAME',
4031: avalue => l_role_name);

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

4034: itemkey => ItemKey,
4035: aname => 'APPLNAME',
4036: avalue => 'PAY');
4037:
4038: hr_utility.trace('APPLNAME ');
4039: */
4040:
4041: hr_utility.trace('b4 starting process');
4042:

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

4037:
4038: hr_utility.trace('APPLNAME ');
4039: */
4040:
4041: hr_utility.trace('b4 starting process');
4042:
4043: wf_engine.StartProcess ( ItemType => ItemType,
4044: ItemKey => ItemKey );
4045: hr_utility.trace('a4 starting process');

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

4041: hr_utility.trace('b4 starting process');
4042:
4043: wf_engine.StartProcess ( ItemType => ItemType,
4044: ItemKey => ItemKey );
4045: hr_utility.trace('a4 starting process');
4046:
4047:
4048:
4049: exception

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

4098:
4099: l_proc := gv_package||'.get_notifier';
4100: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
4101:
4102: hr_utility.trace('Profile Value is : '|| lv_contact_source);
4103: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
4104: hr_utility.trace('GRE Id is : '|| ln_gre_id);
4105: hr_utility.trace('Effective Date is : '|| l_effective_date);
4106:

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

4099: l_proc := gv_package||'.get_notifier';
4100: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
4101:
4102: hr_utility.trace('Profile Value is : '|| lv_contact_source);
4103: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
4104: hr_utility.trace('GRE Id is : '|| ln_gre_id);
4105: hr_utility.trace('Effective Date is : '|| l_effective_date);
4106:
4107:

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

4100: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
4101:
4102: hr_utility.trace('Profile Value is : '|| lv_contact_source);
4103: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
4104: hr_utility.trace('GRE Id is : '|| ln_gre_id);
4105: hr_utility.trace('Effective Date is : '|| l_effective_date);
4106:
4107:
4108:

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

4101:
4102: hr_utility.trace('Profile Value is : '|| lv_contact_source);
4103: hr_utility.trace('Payroll Id is : '|| ln_payroll_id);
4104: hr_utility.trace('GRE Id is : '|| ln_gre_id);
4105: hr_utility.trace('Effective Date is : '|| l_effective_date);
4106:
4107:
4108:
4109: if lv_contact_source = 'PAYROLL' then

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

4108:
4109: if lv_contact_source = 'PAYROLL' then
4110: open c_payroll_contact;
4111: fetch c_payroll_contact into lv_contact_user_name;
4112: hr_utility.trace('Contact User is : '|| lv_contact_user_name);
4113: if c_payroll_contact%NOTFOUND then
4114: lv_contact_user_name := 'SYSADMIN';
4115: end if;
4116:

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

4134: end if;
4135:
4136: return lv_contact_user_name;
4137:
4138: hr_utility.set_location('Leaving: ' || l_proc, 100);
4139: end get_notifier;
4140:
4141:
4142: procedure error

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

4158: dbms_output.put_line('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4159: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4160: */
4161:
4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));

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

4159: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4160: */
4161:
4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));

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

4160: */
4161:
4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));

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

4161:
4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));

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

4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));

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

4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));

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

4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));

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

4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));

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

4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));

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

4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));

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

4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4176:

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

4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4176:
4177: end error;

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

4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4176:
4177: end error;
4178:

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

4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4176:
4177: end error;
4178:
4179: