[Home] [Help]
156: lv_runnable_process varchar2(1);
157:
158:
159: begin
160: --hr_utility.trace_on(null,'PYWF');
161:
162: gv_package := 'pay_ca_wf_pkg';
163:
164: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
179: and name = l_workflowprocess
180: and end_date is null;
181:
182: exception when no_data_found then
183: hr_utility.trace('Exception: No Data Found in payroll_wf_process');
184: null;
185:
186: end;
187:
184: null;
185:
186: end;
187:
188: hr_utility.trace('Item Type : '|| l_item_type);
189: hr_utility.trace('Item Key : '|| l_item_key);
190: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
191:
192: if lv_runnable_process = 'Y' then
185:
186: end;
187:
188: hr_utility.trace('Item Type : '|| l_item_type);
189: hr_utility.trace('Item Key : '|| l_item_key);
190: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
191:
192: if lv_runnable_process = 'Y' then
193:
186: end;
187:
188: hr_utility.trace('Item Type : '|| l_item_type);
189: hr_utility.trace('Item Key : '|| l_item_key);
190: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
191:
192: if lv_runnable_process = 'Y' then
193:
194: StartProcess(p_business_group_id,
292: end if;
293:
294: exception
295:
296: when hr_utility.hr_error then
297: --
298: -- Set up error message and error return code.
299: --
300: hr_utility.trace('in the exception');
296: when hr_utility.hr_error then
297: --
298: -- Set up error message and error return code.
299: --
300: hr_utility.trace('in the exception');
301:
302: errbuf := hr_utility.get_message;
303: retcode := 2;
304:
298: -- Set up error message and error return code.
299: --
300: hr_utility.trace('in the exception');
301:
302: errbuf := hr_utility.get_message;
303: retcode := 2;
304:
305: when others then
306:
419: lv_runnable_process varchar2(1);
420:
421:
422: begin
423: --hr_utility.trace_on(null,'PYWF');
424:
425: gv_package := 'pay_ca_wf_pkg';
426:
427: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
442: and name = l_workflowprocess
443: and end_date is null;
444:
445: exception when no_data_found then
446: hr_utility.trace('Exception: No Data Found in payroll_wf_process');
447: null;
448:
449: end;
450:
447: null;
448:
449: end;
450:
451: hr_utility.trace('Item Type : '|| l_item_type);
452: hr_utility.trace('Item Key : '|| l_item_key);
453: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
454:
455: if lv_runnable_process = 'Y' then
448:
449: end;
450:
451: hr_utility.trace('Item Type : '|| l_item_type);
452: hr_utility.trace('Item Key : '|| l_item_key);
453: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
454:
455: if lv_runnable_process = 'Y' then
456:
449: end;
450:
451: hr_utility.trace('Item Type : '|| l_item_type);
452: hr_utility.trace('Item Key : '|| l_item_key);
453: hr_utility.trace('Workflow Process : '|| l_workflowprocess);
454:
455: if lv_runnable_process = 'Y' then
456:
457: StartProcess(p_business_group_id,
560: end if;
561:
562: exception
563:
564: when hr_utility.hr_error then
565: --
566: -- Set up error message and error return code.
567: --
568: hr_utility.trace('in the exception');
564: when hr_utility.hr_error then
565: --
566: -- Set up error message and error return code.
567: --
568: hr_utility.trace('in the exception');
569:
570: errbuf := hr_utility.get_message;
571: retcode := 2;
572:
566: -- Set up error message and error return code.
567: --
568: hr_utility.trace('in the exception');
569:
570: errbuf := hr_utility.get_message;
571: retcode := 2;
572:
573: when others then
574:
1026:
1027:
1028: begin
1029:
1030: hr_utility.set_location('Starting: ' || l_proc, 100);
1031:
1032: lv_conc_prog_name(1) := 'BEE Batch Process (Transfer)';
1033: lv_conc_prog_name(2) := 'Retro-Notifications Report (Enhanced) - PDF';
1034: lv_conc_prog_name(3) := 'RetroPay By Element';
1054: lv_conc_prog_name(23) := 'Costing';
1055: lv_conc_prog_name(24) := 'Costing Detail Report';
1056: lv_conc_prog_name(25) := 'Costing Summary Report';
1057:
1058: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
1059: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
1060: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
1061:
1062: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
1055: lv_conc_prog_name(24) := 'Costing Detail Report';
1056: lv_conc_prog_name(25) := 'Costing Summary Report';
1057:
1058: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
1059: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
1060: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
1061:
1062: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
1063: into lv_date_time from dual;
1056: lv_conc_prog_name(25) := 'Costing Summary Report';
1057:
1058: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
1059: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
1060: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
1061:
1062: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
1063: into lv_date_time from dual;
1064:
1062: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
1063: into lv_date_time from dual;
1064:
1065:
1066: hr_utility.trace('before create_process');
1067:
1068: wf_engine.createProcess(ItemType => ItemType,
1069: ItemKey => ItemKey,
1070: process => Workflowprocess);
1072: wf_engine.SetItemUserKey(ItemType => ItemType,
1073: ItemKey => ItemKey,
1074: UserKey => ItemUserKey);
1075:
1076: hr_utility.trace('In StartProcess before HR_SIGNON.Initialize_HR_Security');
1077:
1078: HR_SIGNON.Initialize_HR_Security;
1079:
1080: hr_utility.trace('After HR_SIGNON.Initialize_HR_Security');
1076: hr_utility.trace('In StartProcess before HR_SIGNON.Initialize_HR_Security');
1077:
1078: HR_SIGNON.Initialize_HR_Security;
1079:
1080: hr_utility.trace('After HR_SIGNON.Initialize_HR_Security');
1081:
1082: l_user_id := FND_GLOBAL.USER_ID;
1083: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
1084: l_resp_id := FND_GLOBAL.RESP_ID;
1085: l_org_id := FND_GLOBAL.ORG_ID;
1086: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
1087: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
1088:
1089: hr_utility.trace('l_user_id = ' || l_user_id);
1090: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
1091: hr_utility.trace('l_resp_id = ' || l_resp_id);
1092: hr_utility.trace('l_org_id = ' || l_org_id);
1093: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
1086: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
1087: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
1088:
1089: hr_utility.trace('l_user_id = ' || l_user_id);
1090: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
1091: hr_utility.trace('l_resp_id = ' || l_resp_id);
1092: hr_utility.trace('l_org_id = ' || l_org_id);
1093: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
1094: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
1087: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
1088:
1089: hr_utility.trace('l_user_id = ' || l_user_id);
1090: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
1091: hr_utility.trace('l_resp_id = ' || l_resp_id);
1092: hr_utility.trace('l_org_id = ' || l_org_id);
1093: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
1094: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
1095: hr_utility.trace('business group = ' || to_char(p_business_group_id));
1088:
1089: hr_utility.trace('l_user_id = ' || l_user_id);
1090: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
1091: hr_utility.trace('l_resp_id = ' || l_resp_id);
1092: hr_utility.trace('l_org_id = ' || l_org_id);
1093: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
1094: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
1095: hr_utility.trace('business group = ' || to_char(p_business_group_id));
1096:
1089: hr_utility.trace('l_user_id = ' || l_user_id);
1090: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
1091: hr_utility.trace('l_resp_id = ' || l_resp_id);
1092: hr_utility.trace('l_org_id = ' || l_org_id);
1093: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
1094: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
1095: hr_utility.trace('business group = ' || to_char(p_business_group_id));
1096:
1097: lv_gre_name := '';
1090: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
1091: hr_utility.trace('l_resp_id = ' || l_resp_id);
1092: hr_utility.trace('l_org_id = ' || l_org_id);
1093: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
1094: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
1095: hr_utility.trace('business group = ' || to_char(p_business_group_id));
1096:
1097: lv_gre_name := '';
1098: lv_tax_group := '';
1091: hr_utility.trace('l_resp_id = ' || l_resp_id);
1092: hr_utility.trace('l_org_id = ' || l_org_id);
1093: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
1094: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
1095: hr_utility.trace('business group = ' || to_char(p_business_group_id));
1096:
1097: lv_gre_name := '';
1098: lv_tax_group := '';
1099:
1105: end if;
1106:
1107: close cur_workflow_mode;
1108:
1109: hr_utility.trace('Workflow Mode = ' || lv_workflow_mode);
1110:
1111: open cur_retro_period;
1112: fetch cur_retro_period into lv_retro_period;
1113: close cur_retro_period;
1111: open cur_retro_period;
1112: fetch cur_retro_period into lv_retro_period;
1113: close cur_retro_period;
1114:
1115: hr_utility.trace('Retro Period = ' || lv_retro_period);
1116:
1117: open cur_event_group;
1118: fetch cur_event_group into lv_event_group_name;
1119: close cur_event_group;
1117: open cur_event_group;
1118: fetch cur_event_group into lv_event_group_name;
1119: close cur_event_group;
1120:
1121: hr_utility.trace('Event Group = ' || lv_event_group_name);
1122:
1123: open cur_retropay_asg_set;
1124: fetch cur_retropay_asg_set into lv_retropay_asg_set;
1125: close cur_retropay_asg_set;
1123: open cur_retropay_asg_set;
1124: fetch cur_retropay_asg_set into lv_retropay_asg_set;
1125: close cur_retropay_asg_set;
1126:
1127: hr_utility.trace('RetroPay Assignment Set = ' || lv_retropay_asg_set);
1128:
1129: open cur_retropay_element_set;
1130: fetch cur_retropay_element_set into lv_retropay_element_set;
1131: close cur_retropay_element_set;
1129: open cur_retropay_element_set;
1130: fetch cur_retropay_element_set into lv_retropay_element_set;
1131: close cur_retropay_element_set;
1132:
1133: hr_utility.trace('RetroPay Element Set = ' || lv_retropay_element_set);
1134:
1135: open cur_payroll_element_set;
1136: fetch cur_payroll_element_set into lv_payroll_element_set;
1137: close cur_payroll_element_set;
1135: open cur_payroll_element_set;
1136: fetch cur_payroll_element_set into lv_payroll_element_set;
1137: close cur_payroll_element_set;
1138:
1139: hr_utility.trace('Payroll Run Element Set = ' || lv_payroll_element_set);
1140:
1141: open cur_payroll_asg_set;
1142: fetch cur_payroll_asg_set into lv_payroll_assignment_set;
1143: close cur_payroll_asg_set;
1141: open cur_payroll_asg_set;
1142: fetch cur_payroll_asg_set into lv_payroll_assignment_set;
1143: close cur_payroll_asg_set;
1144:
1145: hr_utility.trace('Payroll Run Assignment Set = ' || lv_payroll_assignment_set);
1146:
1147: open cur_payroll_run_type;
1148: fetch cur_payroll_run_type into lv_payroll_run_type;
1149: close cur_payroll_run_type;
1147: open cur_payroll_run_type;
1148: fetch cur_payroll_run_type into lv_payroll_run_type;
1149: close cur_payroll_run_type;
1150:
1151: hr_utility.trace('Payroll Run Type = ' || lv_payroll_run_type);
1152:
1153: open cur_sdr_reporting_dimension;
1154: fetch cur_sdr_reporting_dimension into lv_reporting_dimension;
1155: close cur_sdr_reporting_dimension;
1153: open cur_sdr_reporting_dimension;
1154: fetch cur_sdr_reporting_dimension into lv_reporting_dimension;
1155: close cur_sdr_reporting_dimension;
1156:
1157: hr_utility.trace('SDR Reporting Dimension = ' || lv_reporting_dimension);
1158:
1159: open cur_exp_group_name;
1160: fetch cur_exp_group_name into lv_exp_group_name;
1161: close cur_exp_group_name;
1159: open cur_exp_group_name;
1160: fetch cur_exp_group_name into lv_exp_group_name;
1161: close cur_exp_group_name;
1162:
1163: hr_utility.trace('Exception Group Name = ' || lv_exp_group_name);
1164:
1165: open cur_exp_report_name;
1166: fetch cur_exp_report_name into lv_exp_report_name;
1167: close cur_exp_report_name;
1165: open cur_exp_report_name;
1166: fetch cur_exp_report_name into lv_exp_report_name;
1167: close cur_exp_report_name;
1168:
1169: hr_utility.trace('Exception Report Name = ' || lv_exp_report_name);
1170:
1171: open cur_exp_variance_type;
1172: fetch cur_exp_variance_type into lv_exp_vartype_name;
1173: close cur_exp_variance_type;
1171: open cur_exp_variance_type;
1172: fetch cur_exp_variance_type into lv_exp_vartype_name;
1173: close cur_exp_variance_type;
1174:
1175: hr_utility.trace('Exception Variance Type = ' || lv_exp_vartype_name);
1176:
1177: open cur_prepay_payment_method;
1178: fetch cur_prepay_payment_method into lv_prepay_payment_method;
1179: close cur_prepay_payment_method;
1177: open cur_prepay_payment_method;
1178: fetch cur_prepay_payment_method into lv_prepay_payment_method;
1179: close cur_prepay_payment_method;
1180:
1181: hr_utility.trace('PrePayment Payment Method = ' || lv_prepay_payment_method);
1182:
1183: open cur_ele_element_set;
1184: fetch cur_ele_element_set into lv_ele_element_set;
1185: close cur_ele_element_set;
1183: open cur_ele_element_set;
1184: fetch cur_ele_element_set into lv_ele_element_set;
1185: close cur_ele_element_set;
1186:
1187: hr_utility.trace('Element Register Element Set = ' || lv_ele_element_set);
1188:
1189: open cur_ele_element_class;
1190: fetch cur_ele_element_class into lv_ele_element_class;
1191: close cur_ele_element_class;
1189: open cur_ele_element_class;
1190: fetch cur_ele_element_class into lv_ele_element_class;
1191: close cur_ele_element_class;
1192:
1193: hr_utility.trace('Element Register Element Classification = ' || lv_ele_element_class);
1194:
1195: open cur_ele_element_name;
1196: fetch cur_ele_element_name into lv_ele_element_name;
1197: close cur_ele_element_name;
1195: open cur_ele_element_name;
1196: fetch cur_ele_element_name into lv_ele_element_name;
1197: close cur_ele_element_name;
1198:
1199: hr_utility.trace('Element Register Element Name = ' || lv_ele_element_name);
1200:
1201: open cur_ele_employee;
1202: fetch cur_ele_employee into lv_ele_employee;
1203: close cur_ele_employee;
1201: open cur_ele_employee;
1202: fetch cur_ele_employee into lv_ele_employee;
1203: close cur_ele_employee;
1204:
1205: hr_utility.trace('Element Register Employee = ' || lv_ele_employee);
1206:
1207: open cur_ded_class;
1208: fetch cur_ded_class into lv_deduction_class;
1209: close cur_ded_class;
1207: open cur_ded_class;
1208: fetch cur_ded_class into lv_deduction_class;
1209: close cur_ded_class;
1210:
1211: hr_utility.trace('Deduction Report Dedn Classification = ' || lv_deduction_class);
1212:
1213: open cur_ded_name;
1214: fetch cur_ded_name into lv_deduction_name;
1215: close cur_ded_name;
1213: open cur_ded_name;
1214: fetch cur_ded_name into lv_deduction_name;
1215: close cur_ded_name;
1216:
1217: hr_utility.trace('Deduction Report Dedn Name = ' || lv_deduction_name);
1218:
1219: open cur_reg_dimension;
1220: fetch cur_reg_dimension into lv_reg_reporting_dimension;
1221: close cur_reg_dimension;
1219: open cur_reg_dimension;
1220: fetch cur_reg_dimension into lv_reg_reporting_dimension;
1221: close cur_reg_dimension;
1222:
1223: hr_utility.trace('Payroll Register Reporting Dimension = ' || lv_reg_reporting_dimension);
1224:
1225: open cur_cheque_payment_type;
1226: fetch cur_cheque_payment_type into lv_cheque_payment_type;
1227: close cur_cheque_payment_type;
1225: open cur_cheque_payment_type;
1226: fetch cur_cheque_payment_type into lv_cheque_payment_type;
1227: close cur_cheque_payment_type;
1228:
1229: hr_utility.trace('Chequewriter Payment Type = ' || lv_cheque_payment_type);
1230:
1231: open cur_cheque_payment_method;
1232: fetch cur_cheque_payment_method into lv_cheque_payment_method;
1233: close cur_cheque_payment_method;
1231: open cur_cheque_payment_method;
1232: fetch cur_cheque_payment_method into lv_cheque_payment_method;
1233: close cur_cheque_payment_method;
1234:
1235: hr_utility.trace('Chequewriter Payment Method = ' || lv_cheque_payment_method);
1236:
1237: open cur_cheque_sort_seq;
1238: fetch cur_cheque_sort_seq into lv_cheque_sort_sequence;
1239: close cur_cheque_sort_seq;
1237: open cur_cheque_sort_seq;
1238: fetch cur_cheque_sort_seq into lv_cheque_sort_sequence;
1239: close cur_cheque_sort_seq;
1240:
1241: hr_utility.trace('Chequewriter Sort Seq = ' || lv_cheque_sort_sequence);
1242:
1243: open cur_cheque_style;
1244: fetch cur_cheque_style into lv_cheque_style;
1245: close cur_cheque_style;
1243: open cur_cheque_style;
1244: fetch cur_cheque_style into lv_cheque_style;
1245: close cur_cheque_style;
1246:
1247: hr_utility.trace('Chequewriter Style = ' || lv_cheque_style);
1248:
1249: open cur_deposit_advice_data_type;
1250: fetch cur_deposit_advice_data_type into lv_da_data_type;
1251: close cur_deposit_advice_data_type;
1249: open cur_deposit_advice_data_type;
1250: fetch cur_deposit_advice_data_type into lv_da_data_type;
1251: close cur_deposit_advice_data_type;
1252:
1253: hr_utility.trace('Deposit Advice Data Type = ' || lv_da_data_type);
1254:
1255: open cur_roe_asg_set;
1256: fetch cur_roe_asg_set into lv_roe_asg_set;
1257: close cur_roe_asg_set;
1255: open cur_roe_asg_set;
1256: fetch cur_roe_asg_set into lv_roe_asg_set;
1257: close cur_roe_asg_set;
1258:
1259: hr_utility.trace('ROE Assignment Set = ' || lv_roe_asg_set);
1260:
1261: open cur_roe_worksheet_person;
1262: fetch cur_roe_worksheet_person into lv_roe_worksheet_person;
1263: close cur_roe_worksheet_person;
1261: open cur_roe_worksheet_person;
1262: fetch cur_roe_worksheet_person into lv_roe_worksheet_person;
1263: close cur_roe_worksheet_person;
1264:
1265: hr_utility.trace('ROE Worksheet Person = ' || lv_roe_worksheet_person);
1266:
1267: open cur_roe_mag_media_person;
1268: fetch cur_roe_mag_media_person into lv_roe_mag_media_person;
1269: close cur_roe_mag_media_person;
1267: open cur_roe_mag_media_person;
1268: fetch cur_roe_mag_media_person into lv_roe_mag_media_person;
1269: close cur_roe_mag_media_person;
1270:
1271: hr_utility.trace('ROE Magnetic Media Person = ' || lv_roe_mag_media_person);
1272:
1273: open cur_costing_summary_accruals;
1274: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
1275: close cur_costing_summary_accruals;
1273: open cur_costing_summary_accruals;
1274: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
1275: close cur_costing_summary_accruals;
1276:
1277: hr_utility.trace('Costing Summary Accruals = ' || lv_cost_summary_accruals);
1278:
1279: open cur_costing_summary_file_out;
1280: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
1281: close cur_costing_summary_file_out;
1279: open cur_costing_summary_file_out;
1280: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
1281: close cur_costing_summary_file_out;
1282:
1283: hr_utility.trace('Costing Summary File Format = ' || lv_cost_summary_file_out);
1284:
1285: open cur_costing_detail_ele_set;
1286: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
1287: close cur_costing_detail_ele_set;
1285: open cur_costing_detail_ele_set;
1286: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
1287: close cur_costing_detail_ele_set;
1288:
1289: hr_utility.trace('Costing Detail Element Set = ' || lv_cost_detail_ele_set);
1290:
1291: open cur_costing_detail_ele_name;
1292: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
1293: close cur_costing_detail_ele_name;
1291: open cur_costing_detail_ele_name;
1292: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
1293: close cur_costing_detail_ele_name;
1294:
1295: hr_utility.trace('Costing Detail Element Name = ' || lv_cost_detail_ele_name);
1296:
1297: open cur_costing_detail_ele_class;
1298: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
1299: close cur_costing_detail_ele_class;
1297: open cur_costing_detail_ele_class;
1298: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
1299: close cur_costing_detail_ele_class;
1300:
1301: hr_utility.trace('Costing Detail Element Classification = ' || lv_cost_detail_ele_class);
1302:
1303: open cur_costing_detail_asg_set;
1304: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
1305: close cur_costing_detail_asg_set;
1303: open cur_costing_detail_asg_set;
1304: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
1305: close cur_costing_detail_asg_set;
1306:
1307: hr_utility.trace('Costing Detail Assignment Set = ' || lv_cost_detail_asg_set);
1308:
1309: open cur_costing_detail_accruals;
1310: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
1311: close cur_costing_detail_accruals;
1309: open cur_costing_detail_accruals;
1310: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
1311: close cur_costing_detail_accruals;
1312:
1313: hr_utility.trace('Costing Detail Accruals = ' || lv_cost_detail_accruals);
1314:
1315: begin
1316: select period_name
1317: into lv_gtn_period
1318: from per_time_periods
1319: where payroll_id = to_number(p_payroll_id)
1320: and time_period_id = to_number(p_gross_to_net_period);
1321:
1322: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);
1323:
1324: exception when no_data_found then
1325: hr_utility.trace('lv_gtn_period exception: no_data_found ');
1326: null;
1321:
1322: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);
1323:
1324: exception when no_data_found then
1325: hr_utility.trace('lv_gtn_period exception: no_data_found ');
1326: null;
1327:
1328: end;
1329:
1332: into lv_payroll_process
1333: from pay_payroll_actions
1334: where payroll_action_id = to_number(p_payroll_process);
1335:
1336: hr_utility.trace('lv_payroll_process = ' || lv_payroll_process);
1337:
1338: exception when no_data_found then
1339: hr_utility.trace('lv_payroll_process exception: no_data_found ');
1340: null;
1335:
1336: hr_utility.trace('lv_payroll_process = ' || lv_payroll_process);
1337:
1338: exception when no_data_found then
1339: hr_utility.trace('lv_payroll_process exception: no_data_found ');
1340: null;
1341:
1342: end;
1343:
1345: select to_char(sysdate, 'HHSSSS')
1346: into lv_exp_finder_pqp
1347: from dual;
1348:
1349: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
1350:
1351: exception when no_data_found then
1352: hr_utility.trace('lv_exp_finder_pqp exception: no_data_found ');
1353: null;
1348:
1349: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
1350:
1351: exception when no_data_found then
1352: hr_utility.trace('lv_exp_finder_pqp exception: no_data_found ');
1353: null;
1354:
1355: end;
1356:
1362: where payroll_id = l_payroll_id
1363: and fnd_date.canonical_to_date(p_date_earned)
1364: between effective_start_date and effective_end_date;
1365:
1366: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
1367:
1368: exception when no_data_found then
1369: hr_utility.trace('lv_payroll_name exception: no_data_found ');
1370: null;
1365:
1366: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
1367:
1368: exception when no_data_found then
1369: hr_utility.trace('lv_payroll_name exception: no_data_found ');
1370: null;
1371:
1372: end;
1373:
1377: into lv_consolidation_set_name
1378: from pay_consolidation_sets
1379: where consolidation_set_id = l_consolidation_set_id;
1380:
1381: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
1382:
1383: exception when no_data_found then
1384: hr_utility.trace('lv_consolidation_set_name exception: no_data_found ');
1385: null;
1380:
1381: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
1382:
1383: exception when no_data_found then
1384: hr_utility.trace('lv_consolidation_set_name exception: no_data_found ');
1385: null;
1386:
1387: end;
1388:
1396: and fnd_date.canonical_to_date(p_date_earned) between
1397: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1398:
1399:
1400: hr_utility.trace('lv_organization = ' || lv_organization);
1401:
1402: exception when no_data_found then
1403: hr_utility.trace('lv_organization exception: no_data_found ');
1404: null;
1399:
1400: hr_utility.trace('lv_organization = ' || lv_organization);
1401:
1402: exception when no_data_found then
1403: hr_utility.trace('lv_organization exception: no_data_found ');
1404: null;
1405:
1406: end;
1407:
1411: into lv_location
1412: from hr_locations
1413: where location_id = to_number(p_location);
1414:
1415: hr_utility.trace('lv_location = ' || lv_location);
1416:
1417: exception when no_data_found then
1418: hr_utility.trace('lv_location exception: no_data_found ');
1419: null;
1414:
1415: hr_utility.trace('lv_location = ' || lv_location);
1416:
1417: exception when no_data_found then
1418: hr_utility.trace('lv_location exception: no_data_found ');
1419: null;
1420:
1421: end;
1422:
1430: and business_group_id = p_business_group_id
1431: and fnd_date.canonical_to_date(p_date_earned) between
1432: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1433:
1434: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1435:
1436: exception when no_data_found then
1437: hr_utility.trace('lv_gre_name exception: no_data_found ');
1438: null;
1433:
1434: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1435:
1436: exception when no_data_found then
1437: hr_utility.trace('lv_gre_name exception: no_data_found ');
1438: null;
1439:
1440: end;
1441: end if;
1454: and hou.organization_id = to_number(p_tax_group)
1455: and fnd_date.canonical_to_date(p_date_earned) between
1456: hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
1457:
1458: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
1459:
1460: exception when no_data_found then
1461: hr_utility.trace('lv_tax_group exception: no_data_found ');
1462: null;
1457:
1458: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
1459:
1460: exception when no_data_found then
1461: hr_utility.trace('lv_tax_group exception: no_data_found ');
1462: null;
1463:
1464: end;
1465: end if;
1481: and pcp.source_id = to_number(p_qhsf_account_number)
1482: and hoi2.org_information1 = 'QC'
1483: and hoi2.org_information_context = 'Provincial Information';
1484:
1485: hr_utility.trace('lv_account_number = ' || lv_account_number);
1486:
1487: exception when no_data_found then
1488: hr_utility.trace('lv_account_number exception: no_data_found ');
1489: null;
1484:
1485: hr_utility.trace('lv_account_number = ' || lv_account_number);
1486:
1487: exception when no_data_found then
1488: hr_utility.trace('lv_account_number exception: no_data_found ');
1489: null;
1490:
1491: end;
1492: end if;
1541: from hr_lookups
1542: where lookup_code = p_reg_sort_one
1543: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1544:
1545: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );
1546:
1547: exception when no_data_found then
1548: hr_utility.trace('lv_reg_sort_one exception: no_data_found ');
1549: null;
1544:
1545: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );
1546:
1547: exception when no_data_found then
1548: hr_utility.trace('lv_reg_sort_one exception: no_data_found ');
1549: null;
1550: end;
1551:
1552: begin
1555: from hr_lookups
1556: where lookup_code = p_reg_sort_two
1557: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1558:
1559: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );
1560:
1561: exception when no_data_found then
1562: hr_utility.trace('lv_reg_sort_two exception: no_data_found ');
1563: null;
1558:
1559: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );
1560:
1561: exception when no_data_found then
1562: hr_utility.trace('lv_reg_sort_two exception: no_data_found ');
1563: null;
1564: end;
1565:
1566: begin
1569: from hr_lookups
1570: where lookup_code = p_reg_sort_three
1571: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1572:
1573: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );
1574:
1575: exception when no_data_found then
1576: hr_utility.trace('lv_reg_sort_three exception: no_data_found ');
1577: null;
1572:
1573: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );
1574:
1575: exception when no_data_found then
1576: hr_utility.trace('lv_reg_sort_three exception: no_data_found ');
1577: null;
1578: end;
1579:
1580: begin
1585: into lv_batch_name
1586: from pay_batch_headers
1587: where batch_id = p_batch_id;
1588:
1589: hr_utility.trace('Batch Name :' ||lv_batch_name);
1590:
1591: end if;
1592:
1593: exception when no_data_found then
1591: end if;
1592:
1593: exception when no_data_found then
1594: lv_batch_name := '';
1595: hr_utility.trace('lv_batch_name exception: no_data_found ');
1596: null;
1597:
1598: end;
1599:
1609: to_number(p_gre),
1610: p_date_earned);
1611:
1612: exception when others then
1613: hr_utility.trace('lv_contact_user_name exception: OTHERS at get_notifier');
1614: null;
1615:
1616: end;
1617:
1628: from wf_roles
1629: where name = lv_contact_user_name ;
1630:
1631: exception when no_data_found then
1632: hr_utility.trace('lv_role_name exception: no_data_found');
1633: null;
1634:
1635: end;
1636:
1633: null;
1634:
1635: end;
1636:
1637: hr_utility.trace('orig system : '|| lv_orig_system);
1638: hr_utility.trace('orig system id : '|| lv_orig_system_id);
1639: hr_utility.trace('role name = ' || lv_role_name);
1640:
1641: wf_engine.SetItemOwner (itemtype => ItemType,
1634:
1635: end;
1636:
1637: hr_utility.trace('orig system : '|| lv_orig_system);
1638: hr_utility.trace('orig system id : '|| lv_orig_system_id);
1639: hr_utility.trace('role name = ' || lv_role_name);
1640:
1641: wf_engine.SetItemOwner (itemtype => ItemType,
1642: itemkey => ItemKey,
1635: end;
1636:
1637: hr_utility.trace('orig system : '|| lv_orig_system);
1638: hr_utility.trace('orig system id : '|| lv_orig_system_id);
1639: hr_utility.trace('role name = ' || lv_role_name);
1640:
1641: wf_engine.SetItemOwner (itemtype => ItemType,
1642: itemkey => ItemKey,
1643: owner => ProcessOwner);
1898: end if;
1899:
1900: lv_process_list_html_2 := lv_process_list_html_2||')';
1901:
1902: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1903: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1904: hr_utility.trace('p_date_earned = ' || p_date_earned);
1905: hr_utility.trace('p_date_paid = ' || p_date_paid);
1906: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1899:
1900: lv_process_list_html_2 := lv_process_list_html_2||')';
1901:
1902: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1903: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1904: hr_utility.trace('p_date_earned = ' || p_date_earned);
1905: hr_utility.trace('p_date_paid = ' || p_date_paid);
1906: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1907: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1900: lv_process_list_html_2 := lv_process_list_html_2||')';
1901:
1902: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1903: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1904: hr_utility.trace('p_date_earned = ' || p_date_earned);
1905: hr_utility.trace('p_date_paid = ' || p_date_paid);
1906: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1907: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1908:
1901:
1902: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1903: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1904: hr_utility.trace('p_date_earned = ' || p_date_earned);
1905: hr_utility.trace('p_date_paid = ' || p_date_paid);
1906: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1907: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1908:
1909: begin
1902: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
1903: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1904: hr_utility.trace('p_date_earned = ' || p_date_earned);
1905: hr_utility.trace('p_date_paid = ' || p_date_paid);
1906: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1907: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1908:
1909: begin
1910:
1903: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
1904: hr_utility.trace('p_date_earned = ' || p_date_earned);
1905: hr_utility.trace('p_date_paid = ' || p_date_paid);
1906: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
1907: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
1908:
1909: begin
1910:
1911: num_varname(1) := 'USER_ID';
2648:
2649: -- print out set values for attributes
2650:
2651: for j in varname.first..varname.last loop
2652: hr_utility.trace( 'varname '|| j ||' = '||varname(j));
2653: hr_utility.trace( 'varval '|| j ||' = '||varval(j));
2654: end loop;
2655:
2656:
2649: -- print out set values for attributes
2650:
2651: for j in varname.first..varname.last loop
2652: hr_utility.trace( 'varname '|| j ||' = '||varname(j));
2653: hr_utility.trace( 'varval '|| j ||' = '||varval(j));
2654: end loop;
2655:
2656:
2657: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
2654: end loop;
2655:
2656:
2657: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
2658: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
2659:
2660: for k in num_varname.first..num_varname.last loop
2661: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
2662: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));
2657: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
2658: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
2659:
2660: for k in num_varname.first..num_varname.last loop
2661: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
2662: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));
2663: end loop;
2664:
2665:
2658: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
2659:
2660: for k in num_varname.first..num_varname.last loop
2661: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
2662: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));
2663: end loop;
2664:
2665:
2666: wf_engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
2663: end loop;
2664:
2665:
2666: wf_engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
2667: hr_utility.trace( 'Total Num Count = '||to_char(num_varname.COUNT));
2668:
2669: exception
2670: when OTHERS then
2671: hr_utility.trace('varname exception: OTHERS of TextArray');
2667: hr_utility.trace( 'Total Num Count = '||to_char(num_varname.COUNT));
2668:
2669: exception
2670: when OTHERS then
2671: hr_utility.trace('varname exception: OTHERS of TextArray');
2672: raise;
2673: end;
2674:
2675: hr_utility.trace('Before StartProcess');
2671: hr_utility.trace('varname exception: OTHERS of TextArray');
2672: raise;
2673: end;
2674:
2675: hr_utility.trace('Before StartProcess');
2676:
2677: wf_engine.StartProcess (ItemType => ItemType,
2678: ItemKey => ItemKey );
2679:
2676:
2677: wf_engine.StartProcess (ItemType => ItemType,
2678: ItemKey => ItemKey );
2679:
2680: hr_utility.trace('After StartProcess');
2681:
2682: hr_utility.set_location('Leaving: ' || l_proc, 100);
2683:
2684:
2678: ItemKey => ItemKey );
2679:
2680: hr_utility.trace('After StartProcess');
2681:
2682: hr_utility.set_location('Leaving: ' || l_proc, 100);
2683:
2684:
2685: exception
2686: when others then
3155:
3156:
3157: begin
3158:
3159: hr_utility.set_location('Starting: ' || l_proc, 100);
3160:
3161: lv_conc_prog_name(1) := 'BEE Batch Process (Transfer)';
3162: lv_conc_prog_name(2) := 'Retro-Notifications Report (Enhanced) - PDF';
3163: lv_conc_prog_name(3) := 'Retropay (Enhanced)';
3183: lv_conc_prog_name(23) := 'Costing';
3184: lv_conc_prog_name(24) := 'Costing Detail Report';
3185: lv_conc_prog_name(25) := 'Costing Summary Report';
3186:
3187: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
3188: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
3189: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
3190:
3191: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
3184: lv_conc_prog_name(24) := 'Costing Detail Report';
3185: lv_conc_prog_name(25) := 'Costing Summary Report';
3186:
3187: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
3188: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
3189: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
3190:
3191: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
3192: into lv_date_time from dual;
3185: lv_conc_prog_name(25) := 'Costing Summary Report';
3186:
3187: hr_utility.trace('In StartProcess Item Type is : '|| ItemType);
3188: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
3189: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
3190:
3191: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
3192: into lv_date_time from dual;
3193:
3191: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
3192: into lv_date_time from dual;
3193:
3194:
3195: hr_utility.trace('before create_process');
3196:
3197: wf_engine.createProcess(ItemType => ItemType,
3198: ItemKey => ItemKey,
3199: process => Workflowprocess);
3201: wf_engine.SetItemUserKey(ItemType => ItemType,
3202: ItemKey => ItemKey,
3203: UserKey => ItemUserKey);
3204:
3205: hr_utility.trace('In StartProcess before HR_SIGNON.Initialize_HR_Security');
3206:
3207: HR_SIGNON.Initialize_HR_Security;
3208:
3209: hr_utility.trace('After HR_SIGNON.Initialize_HR_Security');
3205: hr_utility.trace('In StartProcess before HR_SIGNON.Initialize_HR_Security');
3206:
3207: HR_SIGNON.Initialize_HR_Security;
3208:
3209: hr_utility.trace('After HR_SIGNON.Initialize_HR_Security');
3210:
3211: l_user_id := FND_GLOBAL.USER_ID;
3212: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3213: l_resp_id := FND_GLOBAL.RESP_ID;
3214: l_org_id := FND_GLOBAL.ORG_ID;
3215: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
3216: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
3217:
3218: hr_utility.trace('l_user_id = ' || l_user_id);
3219: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
3220: hr_utility.trace('l_resp_id = ' || l_resp_id);
3221: hr_utility.trace('l_org_id = ' || l_org_id);
3222: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
3215: l_per_sec_id := FND_GLOBAL.PER_SECURITY_PROFILE_ID;
3216: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
3217:
3218: hr_utility.trace('l_user_id = ' || l_user_id);
3219: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
3220: hr_utility.trace('l_resp_id = ' || l_resp_id);
3221: hr_utility.trace('l_org_id = ' || l_org_id);
3222: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
3223: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
3216: l_sec_grp_id := FND_GLOBAL.SECURITY_GROUP_ID;
3217:
3218: hr_utility.trace('l_user_id = ' || l_user_id);
3219: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
3220: hr_utility.trace('l_resp_id = ' || l_resp_id);
3221: hr_utility.trace('l_org_id = ' || l_org_id);
3222: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
3223: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
3224: hr_utility.trace('business group = ' || to_char(p_business_group_id));
3217:
3218: hr_utility.trace('l_user_id = ' || l_user_id);
3219: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
3220: hr_utility.trace('l_resp_id = ' || l_resp_id);
3221: hr_utility.trace('l_org_id = ' || l_org_id);
3222: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
3223: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
3224: hr_utility.trace('business group = ' || to_char(p_business_group_id));
3225:
3218: hr_utility.trace('l_user_id = ' || l_user_id);
3219: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
3220: hr_utility.trace('l_resp_id = ' || l_resp_id);
3221: hr_utility.trace('l_org_id = ' || l_org_id);
3222: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
3223: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
3224: hr_utility.trace('business group = ' || to_char(p_business_group_id));
3225:
3226: lv_gre_name := '';
3219: hr_utility.trace('l_resp_appl_id = ' || l_resp_appl_id);
3220: hr_utility.trace('l_resp_id = ' || l_resp_id);
3221: hr_utility.trace('l_org_id = ' || l_org_id);
3222: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
3223: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
3224: hr_utility.trace('business group = ' || to_char(p_business_group_id));
3225:
3226: lv_gre_name := '';
3227: lv_tax_group := '';
3220: hr_utility.trace('l_resp_id = ' || l_resp_id);
3221: hr_utility.trace('l_org_id = ' || l_org_id);
3222: hr_utility.trace('l_per_sec_id = ' || l_per_sec_id);
3223: hr_utility.trace('l_sec_grp_id = ' || l_sec_grp_id);
3224: hr_utility.trace('business group = ' || to_char(p_business_group_id));
3225:
3226: lv_gre_name := '';
3227: lv_tax_group := '';
3228:
3234: end if;
3235:
3236: close cur_workflow_mode;
3237:
3238: hr_utility.trace('Workflow Mode = ' || lv_workflow_mode);
3239:
3240: open cur_retro_period;
3241: fetch cur_retro_period into lv_retro_period;
3242: close cur_retro_period;
3240: open cur_retro_period;
3241: fetch cur_retro_period into lv_retro_period;
3242: close cur_retro_period;
3243:
3244: hr_utility.trace('Retro Period = ' || lv_retro_period);
3245:
3246: -- bug 12704242
3247: open cur_retropay_definition;
3248: fetch cur_retropay_definition into lv_retropay_definition;
3247: open cur_retropay_definition;
3248: fetch cur_retropay_definition into lv_retropay_definition;
3249: close cur_retropay_definition;
3250:
3251: hr_utility.trace('Retro Definition id = ' || lv_retropay_definition);
3252:
3253: open cur_event_group;
3254: fetch cur_event_group into lv_event_group_name;
3255: close cur_event_group;
3253: open cur_event_group;
3254: fetch cur_event_group into lv_event_group_name;
3255: close cur_event_group;
3256:
3257: hr_utility.trace('Event Group = ' || lv_event_group_name);
3258:
3259: open cur_retropay_asg_set;
3260: fetch cur_retropay_asg_set into lv_retropay_asg_set;
3261: close cur_retropay_asg_set;
3259: open cur_retropay_asg_set;
3260: fetch cur_retropay_asg_set into lv_retropay_asg_set;
3261: close cur_retropay_asg_set;
3262:
3263: hr_utility.trace('RetroPay Assignment Set = ' || lv_retropay_asg_set);
3264:
3265: open cur_retropay_element_set;
3266: fetch cur_retropay_element_set into lv_retropay_element_set;
3267: close cur_retropay_element_set;
3265: open cur_retropay_element_set;
3266: fetch cur_retropay_element_set into lv_retropay_element_set;
3267: close cur_retropay_element_set;
3268:
3269: hr_utility.trace('RetroPay Element Set = ' || lv_retropay_element_set);
3270:
3271: open cur_payroll_element_set;
3272: fetch cur_payroll_element_set into lv_payroll_element_set;
3273: close cur_payroll_element_set;
3271: open cur_payroll_element_set;
3272: fetch cur_payroll_element_set into lv_payroll_element_set;
3273: close cur_payroll_element_set;
3274:
3275: hr_utility.trace('Payroll Run Element Set = ' || lv_payroll_element_set);
3276:
3277: open cur_payroll_asg_set;
3278: fetch cur_payroll_asg_set into lv_payroll_assignment_set;
3279: close cur_payroll_asg_set;
3277: open cur_payroll_asg_set;
3278: fetch cur_payroll_asg_set into lv_payroll_assignment_set;
3279: close cur_payroll_asg_set;
3280:
3281: hr_utility.trace('Payroll Run Assignment Set = ' || lv_payroll_assignment_set);
3282:
3283: open cur_payroll_run_type;
3284: fetch cur_payroll_run_type into lv_payroll_run_type;
3285: close cur_payroll_run_type;
3283: open cur_payroll_run_type;
3284: fetch cur_payroll_run_type into lv_payroll_run_type;
3285: close cur_payroll_run_type;
3286:
3287: hr_utility.trace('Payroll Run Type = ' || lv_payroll_run_type);
3288:
3289: open cur_sdr_reporting_dimension;
3290: fetch cur_sdr_reporting_dimension into lv_reporting_dimension;
3291: close cur_sdr_reporting_dimension;
3289: open cur_sdr_reporting_dimension;
3290: fetch cur_sdr_reporting_dimension into lv_reporting_dimension;
3291: close cur_sdr_reporting_dimension;
3292:
3293: hr_utility.trace('SDR Reporting Dimension = ' || lv_reporting_dimension);
3294:
3295: open cur_exp_group_name;
3296: fetch cur_exp_group_name into lv_exp_group_name;
3297: close cur_exp_group_name;
3295: open cur_exp_group_name;
3296: fetch cur_exp_group_name into lv_exp_group_name;
3297: close cur_exp_group_name;
3298:
3299: hr_utility.trace('Exception Group Name = ' || lv_exp_group_name);
3300:
3301: open cur_exp_report_name;
3302: fetch cur_exp_report_name into lv_exp_report_name;
3303: close cur_exp_report_name;
3301: open cur_exp_report_name;
3302: fetch cur_exp_report_name into lv_exp_report_name;
3303: close cur_exp_report_name;
3304:
3305: hr_utility.trace('Exception Report Name = ' || lv_exp_report_name);
3306:
3307: open cur_exp_variance_type;
3308: fetch cur_exp_variance_type into lv_exp_vartype_name;
3309: close cur_exp_variance_type;
3307: open cur_exp_variance_type;
3308: fetch cur_exp_variance_type into lv_exp_vartype_name;
3309: close cur_exp_variance_type;
3310:
3311: hr_utility.trace('Exception Variance Type = ' || lv_exp_vartype_name);
3312:
3313: open cur_prepay_payment_method;
3314: fetch cur_prepay_payment_method into lv_prepay_payment_method;
3315: close cur_prepay_payment_method;
3313: open cur_prepay_payment_method;
3314: fetch cur_prepay_payment_method into lv_prepay_payment_method;
3315: close cur_prepay_payment_method;
3316:
3317: hr_utility.trace('PrePayment Payment Method = ' || lv_prepay_payment_method);
3318:
3319: open cur_ele_element_set;
3320: fetch cur_ele_element_set into lv_ele_element_set;
3321: close cur_ele_element_set;
3319: open cur_ele_element_set;
3320: fetch cur_ele_element_set into lv_ele_element_set;
3321: close cur_ele_element_set;
3322:
3323: hr_utility.trace('Element Register Element Set = ' || lv_ele_element_set);
3324:
3325: open cur_ele_element_class;
3326: fetch cur_ele_element_class into lv_ele_element_class;
3327: close cur_ele_element_class;
3325: open cur_ele_element_class;
3326: fetch cur_ele_element_class into lv_ele_element_class;
3327: close cur_ele_element_class;
3328:
3329: hr_utility.trace('Element Register Element Classification = ' || lv_ele_element_class);
3330:
3331: open cur_ele_element_name;
3332: fetch cur_ele_element_name into lv_ele_element_name;
3333: close cur_ele_element_name;
3331: open cur_ele_element_name;
3332: fetch cur_ele_element_name into lv_ele_element_name;
3333: close cur_ele_element_name;
3334:
3335: hr_utility.trace('Element Register Element Name = ' || lv_ele_element_name);
3336:
3337: open cur_ele_employee;
3338: fetch cur_ele_employee into lv_ele_employee;
3339: close cur_ele_employee;
3337: open cur_ele_employee;
3338: fetch cur_ele_employee into lv_ele_employee;
3339: close cur_ele_employee;
3340:
3341: hr_utility.trace('Element Register Employee = ' || lv_ele_employee);
3342:
3343: open cur_ded_class;
3344: fetch cur_ded_class into lv_deduction_class;
3345: close cur_ded_class;
3343: open cur_ded_class;
3344: fetch cur_ded_class into lv_deduction_class;
3345: close cur_ded_class;
3346:
3347: hr_utility.trace('Deduction Report Dedn Classification = ' || lv_deduction_class);
3348:
3349: open cur_ded_name;
3350: fetch cur_ded_name into lv_deduction_name;
3351: close cur_ded_name;
3349: open cur_ded_name;
3350: fetch cur_ded_name into lv_deduction_name;
3351: close cur_ded_name;
3352:
3353: hr_utility.trace('Deduction Report Dedn Name = ' || lv_deduction_name);
3354:
3355: open cur_reg_dimension;
3356: fetch cur_reg_dimension into lv_reg_reporting_dimension;
3357: close cur_reg_dimension;
3355: open cur_reg_dimension;
3356: fetch cur_reg_dimension into lv_reg_reporting_dimension;
3357: close cur_reg_dimension;
3358:
3359: hr_utility.trace('Payroll Register Reporting Dimension = ' || lv_reg_reporting_dimension);
3360:
3361: open cur_cheque_payment_type;
3362: fetch cur_cheque_payment_type into lv_cheque_payment_type;
3363: close cur_cheque_payment_type;
3361: open cur_cheque_payment_type;
3362: fetch cur_cheque_payment_type into lv_cheque_payment_type;
3363: close cur_cheque_payment_type;
3364:
3365: hr_utility.trace('Chequewriter Payment Type = ' || lv_cheque_payment_type);
3366:
3367: open cur_cheque_payment_method;
3368: fetch cur_cheque_payment_method into lv_cheque_payment_method;
3369: close cur_cheque_payment_method;
3367: open cur_cheque_payment_method;
3368: fetch cur_cheque_payment_method into lv_cheque_payment_method;
3369: close cur_cheque_payment_method;
3370:
3371: hr_utility.trace('Chequewriter Payment Method = ' || lv_cheque_payment_method);
3372:
3373: open cur_cheque_sort_seq;
3374: fetch cur_cheque_sort_seq into lv_cheque_sort_sequence;
3375: close cur_cheque_sort_seq;
3373: open cur_cheque_sort_seq;
3374: fetch cur_cheque_sort_seq into lv_cheque_sort_sequence;
3375: close cur_cheque_sort_seq;
3376:
3377: hr_utility.trace('Chequewriter Sort Seq = ' || lv_cheque_sort_sequence);
3378:
3379: open cur_cheque_style;
3380: fetch cur_cheque_style into lv_cheque_style;
3381: close cur_cheque_style;
3379: open cur_cheque_style;
3380: fetch cur_cheque_style into lv_cheque_style;
3381: close cur_cheque_style;
3382:
3383: hr_utility.trace('Chequewriter Style = ' || lv_cheque_style);
3384:
3385: open cur_deposit_advice_data_type;
3386: fetch cur_deposit_advice_data_type into lv_da_data_type;
3387: close cur_deposit_advice_data_type;
3385: open cur_deposit_advice_data_type;
3386: fetch cur_deposit_advice_data_type into lv_da_data_type;
3387: close cur_deposit_advice_data_type;
3388:
3389: hr_utility.trace('Deposit Advice Data Type = ' || lv_da_data_type);
3390:
3391: open cur_roe_asg_set;
3392: fetch cur_roe_asg_set into lv_roe_asg_set;
3393: close cur_roe_asg_set;
3391: open cur_roe_asg_set;
3392: fetch cur_roe_asg_set into lv_roe_asg_set;
3393: close cur_roe_asg_set;
3394:
3395: hr_utility.trace('ROE Assignment Set = ' || lv_roe_asg_set);
3396:
3397: open cur_roe_worksheet_person;
3398: fetch cur_roe_worksheet_person into lv_roe_worksheet_person;
3399: close cur_roe_worksheet_person;
3397: open cur_roe_worksheet_person;
3398: fetch cur_roe_worksheet_person into lv_roe_worksheet_person;
3399: close cur_roe_worksheet_person;
3400:
3401: hr_utility.trace('ROE Worksheet Person = ' || lv_roe_worksheet_person);
3402:
3403: open cur_roe_mag_media_person;
3404: fetch cur_roe_mag_media_person into lv_roe_mag_media_person;
3405: close cur_roe_mag_media_person;
3403: open cur_roe_mag_media_person;
3404: fetch cur_roe_mag_media_person into lv_roe_mag_media_person;
3405: close cur_roe_mag_media_person;
3406:
3407: hr_utility.trace('ROE Magnetic Media Person = ' || lv_roe_mag_media_person);
3408:
3409: open cur_costing_summary_accruals;
3410: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
3411: close cur_costing_summary_accruals;
3409: open cur_costing_summary_accruals;
3410: fetch cur_costing_summary_accruals into lv_cost_summary_accruals;
3411: close cur_costing_summary_accruals;
3412:
3413: hr_utility.trace('Costing Summary Accruals = ' || lv_cost_summary_accruals);
3414:
3415: open cur_costing_summary_file_out;
3416: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
3417: close cur_costing_summary_file_out;
3415: open cur_costing_summary_file_out;
3416: fetch cur_costing_summary_file_out into lv_cost_summary_file_out;
3417: close cur_costing_summary_file_out;
3418:
3419: hr_utility.trace('Costing Summary File Format = ' || lv_cost_summary_file_out);
3420:
3421: open cur_costing_detail_ele_set;
3422: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
3423: close cur_costing_detail_ele_set;
3421: open cur_costing_detail_ele_set;
3422: fetch cur_costing_detail_ele_set into lv_cost_detail_ele_set;
3423: close cur_costing_detail_ele_set;
3424:
3425: hr_utility.trace('Costing Detail Element Set = ' || lv_cost_detail_ele_set);
3426:
3427: open cur_costing_detail_ele_name;
3428: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
3429: close cur_costing_detail_ele_name;
3427: open cur_costing_detail_ele_name;
3428: fetch cur_costing_detail_ele_name into lv_cost_detail_ele_name;
3429: close cur_costing_detail_ele_name;
3430:
3431: hr_utility.trace('Costing Detail Element Name = ' || lv_cost_detail_ele_name);
3432:
3433: open cur_costing_detail_ele_class;
3434: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
3435: close cur_costing_detail_ele_class;
3433: open cur_costing_detail_ele_class;
3434: fetch cur_costing_detail_ele_class into lv_cost_detail_ele_class;
3435: close cur_costing_detail_ele_class;
3436:
3437: hr_utility.trace('Costing Detail Element Classification = ' || lv_cost_detail_ele_class);
3438:
3439: open cur_costing_detail_asg_set;
3440: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
3441: close cur_costing_detail_asg_set;
3439: open cur_costing_detail_asg_set;
3440: fetch cur_costing_detail_asg_set into lv_cost_detail_asg_set;
3441: close cur_costing_detail_asg_set;
3442:
3443: hr_utility.trace('Costing Detail Assignment Set = ' || lv_cost_detail_asg_set);
3444:
3445: open cur_costing_detail_accruals;
3446: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
3447: close cur_costing_detail_accruals;
3445: open cur_costing_detail_accruals;
3446: fetch cur_costing_detail_accruals into lv_cost_detail_accruals;
3447: close cur_costing_detail_accruals;
3448:
3449: hr_utility.trace('Costing Detail Accruals = ' || lv_cost_detail_accruals);
3450:
3451: begin
3452: select period_name
3453: into lv_gtn_period
3454: from per_time_periods
3455: where payroll_id = to_number(p_payroll_id)
3456: and time_period_id = to_number(p_gross_to_net_period);
3457:
3458: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);
3459:
3460: exception when no_data_found then
3461: hr_utility.trace('lv_gtn_period exception: no_data_found ');
3462: null;
3457:
3458: hr_utility.trace('lv_gtn_period = ' || lv_gtn_period);
3459:
3460: exception when no_data_found then
3461: hr_utility.trace('lv_gtn_period exception: no_data_found ');
3462: null;
3463:
3464: end;
3465:
3468: into lv_payroll_process
3469: from pay_payroll_actions
3470: where payroll_action_id = to_number(p_payroll_process);
3471:
3472: hr_utility.trace('lv_payroll_process = ' || lv_payroll_process);
3473:
3474: exception when no_data_found then
3475: hr_utility.trace('lv_payroll_process exception: no_data_found ');
3476: null;
3471:
3472: hr_utility.trace('lv_payroll_process = ' || lv_payroll_process);
3473:
3474: exception when no_data_found then
3475: hr_utility.trace('lv_payroll_process exception: no_data_found ');
3476: null;
3477:
3478: end;
3479:
3481: select to_char(sysdate, 'HHSSSS')
3482: into lv_exp_finder_pqp
3483: from dual;
3484:
3485: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
3486:
3487: exception when no_data_found then
3488: hr_utility.trace('lv_exp_finder_pqp exception: no_data_found ');
3489: null;
3484:
3485: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
3486:
3487: exception when no_data_found then
3488: hr_utility.trace('lv_exp_finder_pqp exception: no_data_found ');
3489: null;
3490:
3491: end;
3492:
3498: where payroll_id = l_payroll_id
3499: and fnd_date.canonical_to_date(p_date_earned)
3500: between effective_start_date and effective_end_date;
3501:
3502: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
3503:
3504: exception when no_data_found then
3505: hr_utility.trace('lv_payroll_name exception: no_data_found ');
3506: null;
3501:
3502: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
3503:
3504: exception when no_data_found then
3505: hr_utility.trace('lv_payroll_name exception: no_data_found ');
3506: null;
3507:
3508: end;
3509:
3513: into lv_consolidation_set_name
3514: from pay_consolidation_sets
3515: where consolidation_set_id = l_consolidation_set_id;
3516:
3517: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
3518:
3519: exception when no_data_found then
3520: hr_utility.trace('lv_consolidation_set_name exception: no_data_found ');
3521: null;
3516:
3517: hr_utility.trace('lv_consolidation_set_name = ' || lv_consolidation_set_name);
3518:
3519: exception when no_data_found then
3520: hr_utility.trace('lv_consolidation_set_name exception: no_data_found ');
3521: null;
3522:
3523: end;
3524:
3532: and fnd_date.canonical_to_date(p_date_earned) between
3533: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
3534:
3535:
3536: hr_utility.trace('lv_organization = ' || lv_organization);
3537:
3538: exception when no_data_found then
3539: hr_utility.trace('lv_organization exception: no_data_found ');
3540: null;
3535:
3536: hr_utility.trace('lv_organization = ' || lv_organization);
3537:
3538: exception when no_data_found then
3539: hr_utility.trace('lv_organization exception: no_data_found ');
3540: null;
3541:
3542: end;
3543:
3547: into lv_location
3548: from hr_locations
3549: where location_id = to_number(p_location);
3550:
3551: hr_utility.trace('lv_location = ' || lv_location);
3552:
3553: exception when no_data_found then
3554: hr_utility.trace('lv_location exception: no_data_found ');
3555: null;
3550:
3551: hr_utility.trace('lv_location = ' || lv_location);
3552:
3553: exception when no_data_found then
3554: hr_utility.trace('lv_location exception: no_data_found ');
3555: null;
3556:
3557: end;
3558:
3566: and business_group_id = p_business_group_id
3567: and fnd_date.canonical_to_date(p_date_earned) between
3568: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
3569:
3570: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
3571:
3572: exception when no_data_found then
3573: hr_utility.trace('lv_gre_name exception: no_data_found ');
3574: null;
3569:
3570: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
3571:
3572: exception when no_data_found then
3573: hr_utility.trace('lv_gre_name exception: no_data_found ');
3574: null;
3575:
3576: end;
3577: end if;
3590: and hou.organization_id = to_number(p_tax_group)
3591: and fnd_date.canonical_to_date(p_date_earned) between
3592: hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
3593:
3594: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
3595:
3596: exception when no_data_found then
3597: hr_utility.trace('lv_tax_group exception: no_data_found ');
3598: null;
3593:
3594: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
3595:
3596: exception when no_data_found then
3597: hr_utility.trace('lv_tax_group exception: no_data_found ');
3598: null;
3599:
3600: end;
3601: end if;
3617: and pcp.source_id = to_number(p_qhsf_account_number)
3618: and hoi2.org_information1 = 'QC'
3619: and hoi2.org_information_context = 'Provincial Information';
3620:
3621: hr_utility.trace('lv_account_number = ' || lv_account_number);
3622:
3623: exception when no_data_found then
3624: hr_utility.trace('lv_account_number exception: no_data_found ');
3625: null;
3620:
3621: hr_utility.trace('lv_account_number = ' || lv_account_number);
3622:
3623: exception when no_data_found then
3624: hr_utility.trace('lv_account_number exception: no_data_found ');
3625: null;
3626:
3627: end;
3628: end if;
3677: from hr_lookups
3678: where lookup_code = p_reg_sort_one
3679: and lookup_type = 'PAY_CA_YE_SORT_CODE';
3680:
3681: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );
3682:
3683: exception when no_data_found then
3684: hr_utility.trace('lv_reg_sort_one exception: no_data_found ');
3685: null;
3680:
3681: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );
3682:
3683: exception when no_data_found then
3684: hr_utility.trace('lv_reg_sort_one exception: no_data_found ');
3685: null;
3686: end;
3687:
3688: begin
3691: from hr_lookups
3692: where lookup_code = p_reg_sort_two
3693: and lookup_type = 'PAY_CA_YE_SORT_CODE';
3694:
3695: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );
3696:
3697: exception when no_data_found then
3698: hr_utility.trace('lv_reg_sort_two exception: no_data_found ');
3699: null;
3694:
3695: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );
3696:
3697: exception when no_data_found then
3698: hr_utility.trace('lv_reg_sort_two exception: no_data_found ');
3699: null;
3700: end;
3701:
3702: begin
3705: from hr_lookups
3706: where lookup_code = p_reg_sort_three
3707: and lookup_type = 'PAY_CA_YE_SORT_CODE';
3708:
3709: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );
3710:
3711: exception when no_data_found then
3712: hr_utility.trace('lv_reg_sort_three exception: no_data_found ');
3713: null;
3708:
3709: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );
3710:
3711: exception when no_data_found then
3712: hr_utility.trace('lv_reg_sort_three exception: no_data_found ');
3713: null;
3714: end;
3715:
3716: begin
3721: into lv_batch_name
3722: from pay_batch_headers
3723: where batch_id = p_batch_id;
3724:
3725: hr_utility.trace('Batch Name :' ||lv_batch_name);
3726:
3727: end if;
3728:
3729: exception when no_data_found then
3727: end if;
3728:
3729: exception when no_data_found then
3730: lv_batch_name := '';
3731: hr_utility.trace('lv_batch_name exception: no_data_found ');
3732: null;
3733:
3734: end;
3735:
3745: to_number(p_gre),
3746: p_date_earned);
3747:
3748: exception when others then
3749: hr_utility.trace('lv_contact_user_name exception: OTHERS at get_notifier');
3750: null;
3751:
3752: end;
3753:
3764: from wf_roles
3765: where name = lv_contact_user_name ;
3766:
3767: exception when no_data_found then
3768: hr_utility.trace('lv_role_name exception: no_data_found');
3769: null;
3770:
3771: end;
3772:
3769: null;
3770:
3771: end;
3772:
3773: hr_utility.trace('orig system : '|| lv_orig_system);
3774: hr_utility.trace('orig system id : '|| lv_orig_system_id);
3775: hr_utility.trace('role name = ' || lv_role_name);
3776:
3777: wf_engine.SetItemOwner (itemtype => ItemType,
3770:
3771: end;
3772:
3773: hr_utility.trace('orig system : '|| lv_orig_system);
3774: hr_utility.trace('orig system id : '|| lv_orig_system_id);
3775: hr_utility.trace('role name = ' || lv_role_name);
3776:
3777: wf_engine.SetItemOwner (itemtype => ItemType,
3778: itemkey => ItemKey,
3771: end;
3772:
3773: hr_utility.trace('orig system : '|| lv_orig_system);
3774: hr_utility.trace('orig system id : '|| lv_orig_system_id);
3775: hr_utility.trace('role name = ' || lv_role_name);
3776:
3777: wf_engine.SetItemOwner (itemtype => ItemType,
3778: itemkey => ItemKey,
3779: owner => ProcessOwner);
4065: end if;
4066:
4067: lv_process_list_html_2 := lv_process_list_html_2||')';
4068:
4069: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
4070: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
4071: hr_utility.trace('p_date_earned = ' || p_date_earned);
4072: hr_utility.trace('p_date_paid = ' || p_date_paid);
4073: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
4066:
4067: lv_process_list_html_2 := lv_process_list_html_2||')';
4068:
4069: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
4070: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
4071: hr_utility.trace('p_date_earned = ' || p_date_earned);
4072: hr_utility.trace('p_date_paid = ' || p_date_paid);
4073: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
4074: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
4067: lv_process_list_html_2 := lv_process_list_html_2||')';
4068:
4069: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
4070: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
4071: hr_utility.trace('p_date_earned = ' || p_date_earned);
4072: hr_utility.trace('p_date_paid = ' || p_date_paid);
4073: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
4074: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
4075:
4068:
4069: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
4070: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
4071: hr_utility.trace('p_date_earned = ' || p_date_earned);
4072: hr_utility.trace('p_date_paid = ' || p_date_paid);
4073: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
4074: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
4075:
4076: begin
4069: hr_utility.trace('p_payroll_id = ' || p_payroll_id);
4070: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
4071: hr_utility.trace('p_date_earned = ' || p_date_earned);
4072: hr_utility.trace('p_date_paid = ' || p_date_paid);
4073: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
4074: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
4075:
4076: begin
4077:
4070: hr_utility.trace('p_consolidation_set_id = ' || p_consolidation_set_id);
4071: hr_utility.trace('p_date_earned = ' || p_date_earned);
4072: hr_utility.trace('p_date_paid = ' || p_date_paid);
4073: hr_utility.trace('p_payroll_assignment_set = ' || p_payroll_assignment_set);
4074: hr_utility.trace('p_payroll_run_type = ' || p_payroll_run_type);
4075:
4076: begin
4077:
4078: num_varname(1) := 'USER_ID';
4835:
4836: -- print out set values for attributes
4837:
4838: for j in varname.first..varname.last loop
4839: hr_utility.trace( 'varname '|| j ||' = '||varname(j));
4840: hr_utility.trace( 'varval '|| j ||' = '||varval(j));
4841: end loop;
4842:
4843:
4836: -- print out set values for attributes
4837:
4838: for j in varname.first..varname.last loop
4839: hr_utility.trace( 'varname '|| j ||' = '||varname(j));
4840: hr_utility.trace( 'varval '|| j ||' = '||varval(j));
4841: end loop;
4842:
4843:
4844: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
4841: end loop;
4842:
4843:
4844: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
4845: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
4846:
4847: for k in num_varname.first..num_varname.last loop
4848: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
4849: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));
4844: wf_engine.SetItemAttrTextArray(ItemType, ItemKey, varname, varval);
4845: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
4846:
4847: for k in num_varname.first..num_varname.last loop
4848: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
4849: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));
4850: end loop;
4851:
4852:
4845: hr_utility.trace( 'Total Count = '||to_char(varname.COUNT));
4846:
4847: for k in num_varname.first..num_varname.last loop
4848: hr_utility.trace( 'num_varname '|| k ||' = '||num_varname(k));
4849: hr_utility.trace( 'num_varval '|| k ||' = '||num_varvalue(k));
4850: end loop;
4851:
4852:
4853: wf_engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
4850: end loop;
4851:
4852:
4853: wf_engine.SetItemAttrNumberArray(ItemType, ItemKey, num_varname, num_varvalue);
4854: hr_utility.trace( 'Total Num Count = '||to_char(num_varname.COUNT));
4855:
4856: exception
4857: when OTHERS then
4858: hr_utility.trace('varname exception: OTHERS of TextArray');
4854: hr_utility.trace( 'Total Num Count = '||to_char(num_varname.COUNT));
4855:
4856: exception
4857: when OTHERS then
4858: hr_utility.trace('varname exception: OTHERS of TextArray');
4859: raise;
4860: end;
4861:
4862: hr_utility.trace('Before StartProcess');
4858: hr_utility.trace('varname exception: OTHERS of TextArray');
4859: raise;
4860: end;
4861:
4862: hr_utility.trace('Before StartProcess');
4863:
4864: wf_engine.StartProcess (ItemType => ItemType,
4865: ItemKey => ItemKey );
4866:
4863:
4864: wf_engine.StartProcess (ItemType => ItemType,
4865: ItemKey => ItemKey );
4866:
4867: hr_utility.trace('After StartProcess');
4868:
4869: hr_utility.set_location('Leaving: ' || l_proc, 100);
4870:
4871:
4865: ItemKey => ItemKey );
4866:
4867: hr_utility.trace('After StartProcess');
4868:
4869: hr_utility.set_location('Leaving: ' || l_proc, 100);
4870:
4871:
4872: exception
4873: when others then
4910: and organization_id = p_gre_id;
4911:
4912: begin
4913:
4914: hr_utility.set_location('Starting: ' || l_proc, 100);
4915:
4916: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
4917:
4918: hr_utility.trace('Profile Value : '|| lv_contact_source);
4914: hr_utility.set_location('Starting: ' || l_proc, 100);
4915:
4916: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
4917:
4918: hr_utility.trace('Profile Value : '|| lv_contact_source);
4919: hr_utility.trace('Payroll Id : '|| p_payroll_id);
4920: hr_utility.trace('GRE Id : '|| p_gre_id);
4921: hr_utility.trace('Effective Date : '|| p_effective_date);
4922:
4915:
4916: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
4917:
4918: hr_utility.trace('Profile Value : '|| lv_contact_source);
4919: hr_utility.trace('Payroll Id : '|| p_payroll_id);
4920: hr_utility.trace('GRE Id : '|| p_gre_id);
4921: hr_utility.trace('Effective Date : '|| p_effective_date);
4922:
4923:
4916: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
4917:
4918: hr_utility.trace('Profile Value : '|| lv_contact_source);
4919: hr_utility.trace('Payroll Id : '|| p_payroll_id);
4920: hr_utility.trace('GRE Id : '|| p_gre_id);
4921: hr_utility.trace('Effective Date : '|| p_effective_date);
4922:
4923:
4924: if lv_contact_source = 'PAYROLL' then
4917:
4918: hr_utility.trace('Profile Value : '|| lv_contact_source);
4919: hr_utility.trace('Payroll Id : '|| p_payroll_id);
4920: hr_utility.trace('GRE Id : '|| p_gre_id);
4921: hr_utility.trace('Effective Date : '|| p_effective_date);
4922:
4923:
4924: if lv_contact_source = 'PAYROLL' then
4925:
4925:
4926: open c_payroll_contact;
4927: fetch c_payroll_contact into lv_contact_user_name;
4928:
4929: hr_utility.trace('Contact User : '|| lv_contact_user_name);
4930:
4931: if c_payroll_contact%NOTFOUND then
4932: lv_contact_user_name := 'SYSADMIN';
4933: end if;
4955: end if;
4956:
4957: return lv_contact_user_name;
4958:
4959: hr_utility.set_location('Leaving: ' || l_proc, 100);
4960:
4961: end get_notifier;
4962:
4963:
4963:
4964: procedure error is
4965: begin
4966:
4967: hr_utility.trace('Run time error in test script');
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4964: procedure error is
4965: begin
4966:
4967: hr_utility.trace('Run time error in test script');
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4965: begin
4966:
4967: hr_utility.trace('Run time error in test script');
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4966:
4967: hr_utility.trace('Run time error in test script');
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4967: hr_utility.trace('Run time error in test script');
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4981:
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4981:
4982: end error;
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4981:
4982: end error;
4983:
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4981:
4982: end error;
4983:
4984: