[Home] [Help]
444: CURSOR time_pct_def_cur
445: IS
446: SELECT peed.period_end_date,
447: peed.enc_end_date_id,
448: NVL(peed.prev_enc_end_date, fnd_date.canonical_to_date('4712/12/31')) prev_enc_end_date
449: FROM psp_enc_end_dates peed
450: WHERE
451: --- removed sysdate check for Bug fix 2597666
452: peed.business_group_id = p_business_group_id
822: l_input_value_id NUMBER(15);
823: l_formula_id NUMBER(15);
824:
825: -- Introduced for bug fix 3551561
826: l_change_end_date DATE DEFAULT fnd_date.canonical_to_date('4712/12/31');
827: l_prev_change_end_date DATE;
828: l_prev_change_date DATE;
829: -- End of bug fix 3551561
830: l_annualization_factor NUMBER;
867: AND pee.effective_end_date >= ff.effective_start_date;
868:
869: BEGIN
870: l_proc_step:= 10;
871: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
872: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
873: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
937: l_enc_amount := 0;
938: l_proc_step:= 60 + (I / 100000);
939:
940: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
941: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
942: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
943: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
944: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
945: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
938: l_proc_step:= 60 + (I / 100000);
939:
940: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
941: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
942: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
943: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
944: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
945: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
946:
939:
940: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
941: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
942: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
943: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
944: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
945: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
946:
947: IF (l_bus_working_days = 0) THEN
940: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
941: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
942: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
943: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
944: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
945: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
946:
947: IF (l_bus_working_days = 0) THEN
948: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
976: l_inputs.DELETE;
977: l_outputs.DELETE;
978:
979: ff_exec.init_formula(l_formula_id, l_asg_start_date, l_inputs,l_outputs);
980: hr_utility.trace('Initiated Formula l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) || ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date));
981:
982: hr_utility.trace('l_inputs.COUNT: ' || l_inputs.COUNT);
983: FOR recno IN 1..l_inputs.COUNT
984: LOOP
997: ELSIF l_inputs(recno).name='TIME_PERIOD_ID' THEN
998: l_inputs(recno).value := fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I));
999: hr_utility.trace('Assigned time_period_id');
1000: ELSIF l_inputs(recno).name='ASG_START_DATE' THEN
1001: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_start_date);
1002: hr_utility.trace('Assigned asg_start_date');
1003: ELSIF l_inputs(recno).name='ASG_END_DATE' THEN
1004: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_end_date);
1005: hr_utility.trace('Assigned asg_end_date');
1000: ELSIF l_inputs(recno).name='ASG_START_DATE' THEN
1001: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_start_date);
1002: hr_utility.trace('Assigned asg_start_date');
1003: ELSIF l_inputs(recno).name='ASG_END_DATE' THEN
1004: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_end_date);
1005: hr_utility.trace('Assigned asg_end_date');
1006: ELSIF l_inputs(recno).name='BUS_DAYS_IN_CHUNK' THEN
1007: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id));
1008: hr_utility.trace('Assigned business days in chunk');
1006: ELSIF l_inputs(recno).name='BUS_DAYS_IN_CHUNK' THEN
1007: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id));
1008: hr_utility.trace('Assigned business days in chunk');
1009: ELSIF l_inputs(recno).name='PERIOD_START_DATE' THEN
1010: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_start_date);
1011: hr_utility.trace('Assigned period_start_date');
1012: ELSIF l_inputs(recno).name='PERIOD_END_DATE' THEN
1013: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_end_date);
1014: hr_utility.trace('Assigned period_end_date');
1009: ELSIF l_inputs(recno).name='PERIOD_START_DATE' THEN
1010: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_start_date);
1011: hr_utility.trace('Assigned period_start_date');
1012: ELSIF l_inputs(recno).name='PERIOD_END_DATE' THEN
1013: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_end_date);
1014: hr_utility.trace('Assigned period_end_date');
1015: ELSIF l_inputs(recno).name='BUS_DAYS_IN_PERIOD' THEN
1016: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id));
1017: hr_utility.trace('Assigned business days in period');
1044: l_pay_basis := r_salary_proposal.r_pay_basis(J);
1045: l_proc_step:= 70 + (J / 100000);
1046:
1047: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1048: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1049: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1050: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1051: ' l_pay_basis: ' || l_pay_basis);
1052:
1058: l_start_date := GREATEST(l_change_date, l_asg_start_date);
1059: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
1060: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched) / ( l_bus_working_days )), g_ext_precision);
1061:
1062: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1063: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1064: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1065: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1066:
1059: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
1060: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched) / ( l_bus_working_days )), g_ext_precision);
1061:
1062: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1063: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1064: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1065: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1066:
1067: l_end_date := GREATEST(l_start_date, l_change_date) - 1;
1087: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
1088: l_enc_amount := l_enc_amount + ROUND(((l_pay_amount * l_bus_days_in_sched)/( l_bus_working_days )),g_ext_precision);
1089: END IF;
1090:
1091: hr_utility.trace('l_element_start_date: ' || fnd_date.date_to_canonical(l_element_start_date) ||
1092: ' l_element_end_date: ' || fnd_date.date_to_canonical(l_element_end_date) ||
1093: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1094: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1095: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1088: l_enc_amount := l_enc_amount + ROUND(((l_pay_amount * l_bus_days_in_sched)/( l_bus_working_days )),g_ext_precision);
1089: END IF;
1090:
1091: hr_utility.trace('l_element_start_date: ' || fnd_date.date_to_canonical(l_element_start_date) ||
1092: ' l_element_end_date: ' || fnd_date.date_to_canonical(l_element_end_date) ||
1093: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1094: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1095: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1096: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1090:
1091: hr_utility.trace('l_element_start_date: ' || fnd_date.date_to_canonical(l_element_start_date) ||
1092: ' l_element_end_date: ' || fnd_date.date_to_canonical(l_element_end_date) ||
1093: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1094: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1095: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1096: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1097: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1098:
1091: hr_utility.trace('l_element_start_date: ' || fnd_date.date_to_canonical(l_element_start_date) ||
1092: ' l_element_end_date: ' || fnd_date.date_to_canonical(l_element_end_date) ||
1093: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1094: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1095: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1096: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1097: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1098:
1099: EXIT WHEN l_element_start_date > l_asg_end_date;
1142: l_end_date := l_period_end_date;
1143: l_period_counter := 0;
1144:
1145: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
1146: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
1147: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
1148: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1149:
1150: IF (l_bus_working_days > 0) THEN
1143: l_period_counter := 0;
1144:
1145: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
1146: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
1147: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
1148: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1149:
1150: IF (l_bus_working_days > 0) THEN
1151: FOR J IN 1..r_salary_proposal.r_change_date.COUNT
1168: l_pay_basis := r_salary_proposal.r_pay_basis(J);
1169: l_proc_step:= 130 + (J / 100000);
1170:
1171: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1172: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1173: ' l_change_end_date: ' || fnd_date.date_to_canonical(l_change_end_date) ||
1174: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1175: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1176: ' l_pay_basis: ' || l_pay_basis);
1169: l_proc_step:= 130 + (J / 100000);
1170:
1171: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1172: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1173: ' l_change_end_date: ' || fnd_date.date_to_canonical(l_change_end_date) ||
1174: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1175: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1176: ' l_pay_basis: ' || l_pay_basis);
1177:
1202: END LOOP; -- Introduced for bug fix 3673723
1203:
1204: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched)/( l_bus_working_days )), g_ext_precision);
1205: -- End of changes for bug fix 3551561
1206: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1207: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1208: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1209: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1210: -- l_end_date := GREATEST(l_start_date, l_change_date) - 1; Commented for bug fix 3551561
1203:
1204: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched)/( l_bus_working_days )), g_ext_precision);
1205: -- End of changes for bug fix 3551561
1206: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1207: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1208: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1209: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1210: -- l_end_date := GREATEST(l_start_date, l_change_date) - 1; Commented for bug fix 3551561
1211: l_prev_change_end_date := l_change_end_date;
1313: LPAD(r_enc_period.r_encumbrance_amount(recno), 18, ' ') || ' ' ||
1314: LPAD(r_enc_period.r_period_amount(recno), 18, ' ') || ' ' ||
1315: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
1316: END LOOP;
1317: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1318:
1319: p_return_status := fnd_api.g_ret_sts_success;
1320: EXCEPTION
1321: WHEN DIVIDE_BY_ZERO THEN
1320: EXCEPTION
1321: WHEN DIVIDE_BY_ZERO THEN
1322: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1323: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1324: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1325: p_return_status := fnd_api.g_ret_sts_unexp_error;
1326: WHEN OTHERS THEN
1327: IF (g_error_message IS NULL) THEN
1328: g_error_message := l_proc_name || ': ' || SQLERRM;
1328: g_error_message := l_proc_name || ': ' || SQLERRM;
1329: END IF;
1330: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');
1331: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1333: p_return_status := fnd_api.g_ret_sts_unexp_error;
1334: END determine_enc_amount;
1335: -- End of changes for bug fix 3488734
1336:
1552: IF (p_process_flag = 'SA') THEN
1553: l_sa_reason_code := l_reason_code;
1554: END IF;
1555:
1556: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering process_all_hier');
1557: hr_utility.trace(' p_chunk_pointer: ' || p_chunk_pointer ||
1558: ' p_asg_start_date: ' || TO_CHAR(p_asg_start_date, 'DD-MON-RRRR') ||
1559: ' p_asg_end_date: ' || TO_CHAR(p_asg_end_date, 'DD-MON-RRRR') ||
1560: ' p_process_flag: ' || p_process_flag);
1996: END IF;
1997: END LOOP;
1998: END IF;
1999: t_poeta_gl_hier_array.DELETE;
2000: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving process_all_hier');
2001: END process_all_hier;
2002:
2003: PROCEDURE log_gl_hours_message IS
2004: BEGIN
2012: BEGIN
2013: l_proc_step := 10;
2014: l_proc_name := 'CREATE_LINES';
2015:
2016: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
2017: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
2018: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2019: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2020: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2016: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
2017: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
2018: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2019: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2020: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2021:
2022: p_return_status := fnd_api.g_ret_sts_success;
2023:
2024: OPEN c_person_id;
2093: g_orig_pointer := 1;
2094: l_orig_pointer := 1;
2095: l_chunk_pointer := 1;
2096: l_prev_enc_lines_counter := t_enc_lines_array.r_time_period_id.COUNT + 1;
2097: l_min_start_date := fnd_date.canonical_to_date('1800/01/01');
2098: l_max_end_date := LEAST(NVL(g_actual_term_date, g_enc_org_end_date), g_enc_org_end_date);
2099: l_ignore_start := -1;
2100: l_ignore_end := -1;
2101:
2149: ' PF: ' || l_process_flag || ' EA: ' || l_earnings_amount || ' ED: ' || TO_CHAR(l_effective_date, 'DD-MON-RRRR') ||
2150: ' BD: ' || l_bus_days_in_chunk);
2151:
2152: hr_utility.trace('l_chunk_pointer: ' || fnd_number.number_to_canonical(l_chunk_pointer) ||
2153: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
2154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2155: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2156: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2157: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2150: ' BD: ' || l_bus_days_in_chunk);
2151:
2152: hr_utility.trace('l_chunk_pointer: ' || fnd_number.number_to_canonical(l_chunk_pointer) ||
2153: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
2154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2155: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2156: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2157: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2151:
2152: hr_utility.trace('l_chunk_pointer: ' || fnd_number.number_to_canonical(l_chunk_pointer) ||
2153: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
2154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2155: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2156: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2157: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2152: hr_utility.trace('l_chunk_pointer: ' || fnd_number.number_to_canonical(l_chunk_pointer) ||
2153: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
2154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2155: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2156: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2157: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2160: ' l_process_flag: ' || l_process_flag ||
2153: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
2154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2155: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2156: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2157: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2160: ' l_process_flag: ' || l_process_flag ||
2161: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
3130: r_enc_period.r_period_amount.DELETE;
3131: r_enc_period.r_reason_code.DELETE;
3132:
3133: l_proc_step := 210;
3134: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3135: EXCEPTION
3136: WHEN suspense_autopop_failed THEN
3137: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3138: p_return_status := fnd_api.g_ret_sts_unexp_error;
3137: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3138: p_return_status := fnd_api.g_ret_sts_unexp_error;
3139: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3140: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3141: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3142: WHEN OTHERS THEN
3143: IF (g_error_message IS NULL) THEN
3144: g_error_message := l_proc_name || ': ' || SQLERRM;
3145: END IF;
3145: END IF;
3146: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3147: p_return_status := fnd_api.g_ret_sts_unexp_error;
3148: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3149: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3150: END create_lines;
3151:
3152: ---------------------- I N S E R T S T A T E M E N T ------------------------------------
3153: PROCEDURE insert_into_enc_lines(
3479: l_end_date date := p_ls_end_date;
3480: i NUMBER := 1;
3481: l_bus_days_in_period NUMBER;
3482: l_bus_days_in_schedules NUMBER;
3483: l_susp_date DATE DEFAULT fnd_date.canonical_to_date('1800/01/01');
3484:
3485:
3486: DIVIDE_BY_ZERO EXCEPTION;
3487:
4048: BEGIN
4049: psp_matrix_driver_pkg.set_runid;
4050: l_run_id := psp_matrix_driver_pkg.get_run_id;
4051:
4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4055: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4056: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4116: l_sub_slice_counter := 1;
4117: l_proc_step := 20 + (I / 100000);
4118:
4119: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4120: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4121: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4122: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4123: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4124: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4117: l_proc_step := 20 + (I / 100000);
4118:
4119: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4120: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4121: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4122: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4123: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4124: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4125: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4118:
4119: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4120: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4121: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4122: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4123: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4124: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4125: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4126:
4119: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4120: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4121: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4122: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4123: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4124: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4125: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4126:
4127: IF (r_sch_rec.end_date.COUNT > 0) THEN
4135: -- FETCH global_element_cur INTO l_start_date, l_end_date, l_schedule_percent;
4136:
4137: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4138: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4139: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4140: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4141: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4142: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));
4143:
4136:
4137: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4138: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4139: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4140: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4141: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4142: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));
4143:
4144: -- IF (global_element_cur%NOTFOUND) THEN
4515: l_sub_slice_counter := 1;
4516: l_proc_step := 50 + (I / 100000);
4517:
4518: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4519: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4520: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4521: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4522: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4523: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
4516: l_proc_step := 50 + (I / 100000);
4517:
4518: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4519: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4520: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4521: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4522: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4523: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
4524: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4517:
4518: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4519: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4520: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4521: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4522: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4523: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
4524: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4525:
4518: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4519: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4520: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4521: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4522: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4523: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
4524: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4525:
4526: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
4532: l_proc_step := 60 + (et_recno / 100000);
4533:
4534: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4535: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4536: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4537: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4538: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4539:
4540: -- OPEN ls_matrix_cur;
4533:
4534: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4535: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4536: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4537: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4538: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4539:
4540: -- OPEN ls_matrix_cur;
4541: -- FETCH ls_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
4916: l_sub_slice_counter := 1;
4917: l_proc_step := 80 + (I / 100000);
4918:
4919: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4920: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4921: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4922: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4923: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4924: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4917: l_proc_step := 80 + (I / 100000);
4918:
4919: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4920: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4921: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4922: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4923: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4924: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4925: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4918:
4919: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4920: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4921: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4922: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4923: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4924: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4925: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4926:
4919: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4920: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4921: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4922: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4923: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4924: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4925: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4926:
4927: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
4933: l_proc_step := 90 + (eg_recno / 100000);
4934:
4935: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4936: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4937: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4938: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4939: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4940:
4941: -- OPEN eg_matrix_cur;
4934:
4935: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4936: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4937: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4938: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4939: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4940:
4941: -- OPEN eg_matrix_cur;
4942: -- FETCH eg_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
5313: l_sub_slice_counter := 1;
5314: l_proc_step := 110 + (I / 100000);
5315:
5316: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5317: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5318: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5319: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5320: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5321: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
5314: l_proc_step := 110 + (I / 100000);
5315:
5316: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5317: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5318: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5319: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5320: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5321: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
5322: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5315:
5316: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5317: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5318: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5319: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5320: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5321: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
5322: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5323:
5316: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5317: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5318: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5319: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5320: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5321: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
5322: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5323:
5324: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5330: l_proc_step := 120 + (l_rec_no / 100000);
5331:
5332: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5333: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5334: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5335: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5336: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5337: -- OPEN ls_matrix_cur;
5338: -- FETCH ls_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
5331:
5332: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5333: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5334: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5335: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5336: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5337: -- OPEN ls_matrix_cur;
5338: -- FETCH ls_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
5339: -- IF (ls_matrix_cur%NOTFOUND) THEN
5586: l_sub_slice_counter := 1;
5587: l_proc_step := 150 + (I / 100000);
5588:
5589: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5590: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5591: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5592: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5593: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5594: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5587: l_proc_step := 150 + (I / 100000);
5588:
5589: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5590: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5591: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5592: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5593: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5594: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5595: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5588:
5589: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5590: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5591: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5592: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5593: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5594: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5595: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5596:
5589: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5590: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5591: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5592: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5593: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5594: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5595: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5596:
5597: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5605: -- FETCH odls_cur INTO l_start_date, l_end_date, l_schedule_percent;
5606:
5607: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5608: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5609: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5610: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5611: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5612: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));
5613:
5606:
5607: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5608: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5609: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5610: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5611: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5612: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));
5613:
5614: -- IF (odls_cur%NOTFOUND) THEN
5866: l_sub_slice_counter := 1;
5867: l_proc_step := 180 + (I / 100000);
5868:
5869: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5870: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5871: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5872: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5873: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5874: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5867: l_proc_step := 180 + (I / 100000);
5868:
5869: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5870: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5871: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5872: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5873: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5874: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5875: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5868:
5869: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5870: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5871: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5872: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5873: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5874: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5875: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5876:
5869: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5870: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5871: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5872: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5873: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5874: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5875: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5876:
5877: IF (l_process_flag IN ('BAL', 'Y')) AND (r_da.end_date_active.COUNT > 0) THEN
5887: l_proc_step := 190 + (l_rec_no / 100000);
5888:
5889: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5890: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5891: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5892: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5893: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5894:
5895: IF (l_start_date > l_asg_end_date) THEN
5888:
5889: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5890: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5891: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5892: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5893: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5894:
5895: IF (l_start_date > l_asg_end_date) THEN
5896: r_enc_period_tmp1.r_period_ind(l_rec_no) := r_enc_period.r_period_ind(I);
6111: l_sub_slice_counter := 1;
6112: l_proc_step := 210 + (I / 100000);
6113:
6114: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
6115: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6116: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6117: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6118: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6119: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
6112: l_proc_step := 210 + (I / 100000);
6113:
6114: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
6115: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6116: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6117: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6118: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6119: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
6120: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6113:
6114: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
6115: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6116: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6117: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6118: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6119: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
6120: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6121:
6114: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
6115: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6116: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6117: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6118: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6119: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
6120: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6121:
6122: IF (l_process_flag IN ('BAL', 'Y')) AND (l_sch_pointer <= r_sa.end_date_active.COUNT) THEN
6133: l_proc_step := 220 + (l_rec_no / 100000);
6134:
6135: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6136: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6137: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6138: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6139: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
6140:
6141: IF (r_sa.start_date_active(sa_recno) > l_asg_end_date) THEN
6134:
6135: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6136: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6137: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6138: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6139: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
6140:
6141: IF (r_sa.start_date_active(sa_recno) > l_asg_end_date) THEN
6142: r_enc_period.r_period_ind(l_rec_no) := r_enc_period_tmp1.r_period_ind(I);
6329: LPAD(r_enc_period.r_schedule_percent(recno), 16, ' ') || ' ' ||
6330: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
6331: r_enc_period.r_encumbrance_amount(recno) := 0;
6332: END LOOP;
6333: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6334:
6335: p_return_status := fnd_api.g_ret_sts_success;
6336: EXCEPTION
6337: WHEN OTHERS THEN
6341: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6342: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6343: p_return_status := fnd_api.g_ret_sts_unexp_error;
6344: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6345: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6346: END sub_slice_asg_chunk;
6347: -- End of bug fix 3462452
6348:
6349: PROCEDURE cel_init(p_payroll_action_id IN NUMBER) IS
6383: FROM psp_enc_payrolls pep
6384: WHERE pep.business_group_id = l_business_group_id
6385: AND pep.set_of_books_id = l_set_of_books_id;
6386: BEGIN
6387: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_RANGE_CODE pactid: ' || pactid);
6388:
6389: l_last_update_date := SYSDATE;
6390: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6391: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6399:
6400: IF (l_payroll_id = -1) THEN
6401: l_payroll_id := NULL;
6402: END IF;
6403: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_payroll_id: ' || l_payroll_id || '
6404: process_mode: ' || l_process_mode);
6405:
6406: l_process_code := 'CEL';
6407: IF (l_process_mode = 'TERMINATE') THEN
6424:
6425: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6427: END IF;
6428: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed enc_pre_process for l_payroll_id: ' || l_payroll_id || ' process_mode: ' || l_process_mode);
6429: ELSE
6430: OPEN enc_payrolls_cur;
6431: LOOP
6432: FETCH enc_payrolls_cur INTO l_payroll_id;
6435: enc_pre_process(pactid, l_payroll_id, l_process_mode, l_return_status);
6436: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6438: END IF;
6439: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed enc_pre_process for l_payroll_id: ' || l_payroll_id || ' process_mode: ' || l_process_mode);
6440: END LOOP;
6441: CLOSE enc_payrolls_cur;
6442: l_payroll_id := NULL;
6443: END IF;
6473: p_return_status => l_return_status);
6474: RAISE NO_UPDATE_REC_FOUND;
6475: END IF;
6476:
6477: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' sqlstr: ' || sqlstr);
6478: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6479: EXCEPTION
6480: WHEN NO_UPDATE_REC_FOUND THEN
6481: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6474: RAISE NO_UPDATE_REC_FOUND;
6475: END IF;
6476:
6477: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' sqlstr: ' || sqlstr);
6478: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6479: EXCEPTION
6480: WHEN NO_UPDATE_REC_FOUND THEN
6481: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6482: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6478: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6479: EXCEPTION
6480: WHEN NO_UPDATE_REC_FOUND THEN
6481: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6482: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6483: WHEN OTHERS THEN
6484: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6485: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6486: p_print_header => FND_API.G_TRUE);
6483: WHEN OTHERS THEN
6484: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6485: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6486: p_print_header => FND_API.G_TRUE);
6487: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6488: END cel_range_code;
6489:
6490: PROCEDURE cel_asg_action_code (p_pactid IN NUMBER,
6491: start_asg IN NUMBER,
6500: TYPE t_number_15 IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
6501: t_asg_array t_number_15;
6502: l_asg_action_id NUMBER(15);
6503: BEGIN
6504: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_ASG_ACTION_CODE p_pactid: ' || p_pactid || '
6505: start_asg: ' || start_asg || '
6506: end_asg: ' || end_asg || '
6507: p_chunk_num: ' || p_chunk_num);
6508:
6509: OPEN get_assignments_cur;
6510: FETCH get_assignments_cur BULK COLLECT INTO t_asg_array;
6511: CLOSE get_assignments_cur;
6512:
6513: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_asg_array.COUNT: ' || t_asg_array.COUNT);
6514: FOR recno IN 1..t_asg_array.COUNT
6515: LOOP
6516: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_action_id FROM DUAL;
6517: hr_nonrun_asact.insact(l_asg_action_id,
6520: object_id => t_asg_array(recno),
6521: object_type => 'ASG',
6522: p_transient_action => TRUE);
6523: END LOOP;
6524: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ASG_ACTION_CODE payroll_action_id: ' || p_pactid || '
6525: start_asg: ' || start_asg || '
6526: end_asg: ' || end_asg || '
6527: p_chunk_num: ' || p_chunk_num);
6528: END cel_asg_action_code;
6941: p_value2 => l_organization_id,
6942: p_value3 => l_element_type_id,
6943: p_information2 => l_organization_name,
6944: p_information3 => l_element_name,
6945: p_information4 => fnd_date.date_to_canonical(cel_warnings.start_date(recno)),
6946: p_information5 => fnd_date.date_to_canonical(cel_warnings.end_date(recno)),
6947: p_information6 => cel_warnings.hierarchy_code(recno),
6948: p_information7 => cel_warnings.error_status(recno),
6949: p_return_status => l_return_status);
6942: p_value3 => l_element_type_id,
6943: p_information2 => l_organization_name,
6944: p_information3 => l_element_name,
6945: p_information4 => fnd_date.date_to_canonical(cel_warnings.start_date(recno)),
6946: p_information5 => fnd_date.date_to_canonical(cel_warnings.end_date(recno)),
6947: p_information6 => cel_warnings.hierarchy_code(recno),
6948: p_information7 => cel_warnings.error_status(recno),
6949: p_return_status => l_return_status);
6950: END LOOP;
6961: cel_warnings.percent.DELETE;
6962: END log_cel_warnings;
6963: BEGIN
6964: SAVEPOINT CEL_ARCHIVE;
6965: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
6966:
6967: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
6968: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6969: g_set_of_books_id := l_set_of_books_id;
7013: l_enc_create := 1;
7014: l_pre_process_mode:= 'R';
7015: g_currency_code := psp_general.get_currency_code(l_business_group_id);
7016: psp_general.get_currency_precision(g_currency_code,g_precision,g_ext_precision);
7017: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_line_type: U
7018: g_request_id: ' || g_request_id || '
7019: g_payroll_action_id: ' || g_payroll_action_id || '
7020: g_currency_code: ' || g_currency_code || '
7021: g_ge_autopop: ' || g_ge_autopop || ' g_et_autopop: ' || g_et_autopop ||
7026: OPEN c_obtain_eff_date_option;
7027: FETCH c_obtain_eff_date_option INTO g_eff_date_value;
7028: CLOSE c_obtain_eff_date_option;
7029:
7030: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_eff_date_value: ' || g_eff_date_value);
7031:
7032: obtain_enc_org_end_date(p_enc_org_end_date => l_enc_org_end_date,
7033: p_business_group_id => l_business_group_id,
7034: p_set_of_books_id => l_set_of_books_id,
7036: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7038: END IF;
7039: g_enc_org_end_date := l_enc_org_end_date ;
7040: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_org_end_date: ' || fnd_date.date_to_canonical(g_enc_org_end_date));
7041:
7042: OPEN get_asg_id_cur;
7043: FETCH get_asg_id_cur INTO l_min_asg_id, l_max_asg_id;
7044: CLOSE get_asg_id_cur;
7041:
7042: OPEN get_asg_id_cur;
7043: FETCH get_asg_id_cur INTO l_min_asg_id, l_max_asg_id;
7044: CLOSE get_asg_id_cur;
7045: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_min_asg_id: ' || l_min_asg_id || ' l_max_asg_id: ' || l_max_asg_id);
7046:
7047: OPEN get_payroll_asg_cur;
7048: FETCH get_payroll_asg_cur BULK COLLECT INTO t_assignments.payroll_array, t_assignments.asg_array, t_assignments.term_date_array;
7049: CLOSE get_payroll_asg_cur;
7047: OPEN get_payroll_asg_cur;
7048: FETCH get_payroll_asg_cur BULK COLLECT INTO t_assignments.payroll_array, t_assignments.asg_array, t_assignments.term_date_array;
7049: CLOSE get_payroll_asg_cur;
7050:
7051: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' t_assignments.asg_array.COUNT: ' || t_assignments.asg_array.COUNT);
7052: FOR recno IN 1 ..t_assignments.asg_array.COUNT
7053: LOOP
7054: l_assignment_id := t_assignments.asg_array(recno);
7055: l_payroll_id := t_assignments.payroll_array(recno);
7109:
7110: IF l_enc_create = 0 AND l_enc_create_lines = 0 THEN
7111: l_enc_create :=1;
7112: END IF;
7113: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_actual_term_date: ' || fnd_date.date_to_canonical(g_actual_term_date) || '
7114: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7115: l_enc_create: ' || l_enc_create);
7116:
7117: IF l_enc_create > 0 THEN
7110: IF l_enc_create = 0 AND l_enc_create_lines = 0 THEN
7111: l_enc_create :=1;
7112: END IF;
7113: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_actual_term_date: ' || fnd_date.date_to_canonical(g_actual_term_date) || '
7114: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7115: l_enc_create: ' || l_enc_create);
7116:
7117: IF l_enc_create > 0 THEN
7118: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' p_chunk_number: ' || p_chunk_number || '
7114: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7115: l_enc_create: ' || l_enc_create);
7116:
7117: IF l_enc_create > 0 THEN
7118: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' p_chunk_number: ' || p_chunk_number || '
7119: p_assignment_id => ' || l_assignment_id || '
7120: p_payroll_id => ' || l_payroll_id || '
7121: p_element_type_id => ' || l_element_type_id || '
7122: p_business_group_id => ' || l_business_group_id || '
7133: p_return_status => l_return_status);
7134: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7136: END IF;
7137: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);
7138: log_cel_warnings;
7139: END IF;
7140: END IF;
7141: IF (g_employee_hours = 'Y') THEN
7158:
7159: IF l_enc_create = 0 AND l_enc_create_lines = 0 THEN
7160: l_enc_create :=1;
7161: END IF;
7162: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_actual_term_date: ' || fnd_date.date_to_canonical(g_actual_term_date) || '
7163: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7164: l_enc_create: ' || l_enc_create);
7165:
7166: IF l_enc_create > 0 THEN
7159: IF l_enc_create = 0 AND l_enc_create_lines = 0 THEN
7160: l_enc_create :=1;
7161: END IF;
7162: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_actual_term_date: ' || fnd_date.date_to_canonical(g_actual_term_date) || '
7163: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7164: l_enc_create: ' || l_enc_create);
7165:
7166: IF l_enc_create > 0 THEN
7167: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' p_chunk_number: ' || p_chunk_number || '
7163: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7164: l_enc_create: ' || l_enc_create);
7165:
7166: IF l_enc_create > 0 THEN
7167: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' p_chunk_number: ' || p_chunk_number || '
7168: p_assignment_id => ' || l_assignment_id || '
7169: p_payroll_id => ' || l_payroll_id || '
7170: p_element_type_id => ' || l_element_type_id || '
7171: p_business_group_id => ' || l_business_group_id || '
7182: p_return_status => l_return_status);
7183: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7185: END IF;
7186: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);
7187: log_cel_warnings;
7188: END IF;
7189: END IF;
7190: END IF;
7195: fnd_file.put_line(fnd_file.log, 'No element found for encumbrance.');
7196: END IF;
7197: CLOSE earnings_element_cur;
7198:
7199: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_enc_lines_array.r_enc_element_type_id.COUNT: ' || t_enc_lines_array.r_enc_element_type_id.COUNT);
7200: verify_changes(p_payroll_id => l_payroll_id,
7201: p_assignment_id => l_assignment_id,
7202: p_business_group_id => l_business_group_id,
7203: p_set_of_books_id => l_set_of_books_id,
7206:
7207: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7208: RAISE fnd_api.g_exc_unexpected_error;
7209: END IF;
7210: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed verify_changes for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7211: ELSE
7212: IF (l_liq_all_count > 0) THEN
7213: UPDATE psp_enc_lines_history pelh
7214: SET change_flag = 'N'
7220: WHERE pesl.assignment_id = l_assignment_id
7221: AND pesl.payroll_id = l_payroll_id
7222: AND status_code = 'A'
7223: AND pesl.enc_summary_line_id = pelh.enc_summary_line_id);
7224: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines to be liquidated');
7225: DELETE psp_enc_changed_assignments
7226: WHERE assignment_id = l_assignment_id
7227: AND payroll_id = l_payroll_id
7228: AND change_type = 'ZZ';
7248: AND NVL(paa.action_status, ppa.action_status) = 'C'
7249: and ppa.date_earned between ptp.start_date and ptp.end_date
7250: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date)) );
7251:
7252: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines to be liquidated by regular liquidation');
7253: UPDATE psp_enc_lines_history pelh
7254: SET change_flag = 'U'
7255: WHERE assignment_id = l_assignment_id
7256: AND payroll_id = l_payroll_id
7271: AND NVL(paa.action_status, ppa.action_status) = 'C'
7272: and ppa.date_earned between ptp.start_date and ptp.end_date
7273: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date)) );
7274:
7275: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines not to be liquidated by regular liquidation');
7276: END IF;
7277: END IF;
7278:
7279: create_liq_lines (p_payroll_action_id => p_payroll_action_id,
7286:
7287: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7288: RAISE fnd_api.g_exc_unexpected_error;
7289: END IF;
7290: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed create_liq_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7291:
7292: create_sum_lines (p_payroll_action_id => p_payroll_action_id,
7293: p_payroll_id => l_payroll_id,
7294: p_assignment_id => l_assignment_id,
7298:
7299: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7300: RAISE fnd_api.g_exc_unexpected_error;
7301: END IF;
7302: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed create_sum_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7303:
7304: update_hierarchy_dates (p_payroll_action_id => p_payroll_action_id,
7305: p_payroll_id => l_payroll_id,
7306: p_assignment_id => l_assignment_id,
7350:
7351: t_assignments.payroll_array.delete;
7352: t_assignments.asg_array.delete;
7353:
7354: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7355: EXCEPTION
7356: WHEN OTHERS THEN
7357: log_cel_warnings;
7358: IF (g_error_message IS NOT NULL) THEN
7409: END IF;
7410: END IF;
7411: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7412: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7413: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7414: ROLLBACK TO CEL_ARCHIVE;
7415: RAISE;
7416: END cel_archive;
7417:
7459: FROM psp_enc_summary_lines
7460: WHERE payroll_action_id = p_payroll_action_id
7461: AND status_code = 'N';
7462: BEGIN
7463: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);
7464: l_last_update_date := SYSDATE;
7465: l_last_updated_by:= NVL(FND_GLOBAL.USER_ID, -1);
7466: l_request_id := fnd_global.conc_request_id;
7467:
7479: FETCH error_check_cur INTO l_error_count;
7480: CLOSE error_check_cur;
7481:
7482: IF (l_error_count > 0) THEN
7483: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Create and Update Encumbrance process has errors. Please review the Run Results Report for more details.');
7484: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7485: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7486: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7487: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7482: IF (l_error_count > 0) THEN
7483: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Create and Update Encumbrance process has errors. Please review the Run Results Report for more details.');
7484: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7485: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7486: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7487: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7488: l_request_id := fnd_request.submit_request('PSP',
7489: 'PSPENRSLT',
7490: '',
7495: TO_CHAR(l_business_group_id),
7496: TO_CHAR(l_set_of_books_id));
7497:
7498: IF l_request_id = 0 THEN
7499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7500: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7501: fnd_msg_pub.add;
7502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7503: END IF;
7539:
7540: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7541: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7543: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7544:
7545: DELETE FROM psp_enc_controls pec
7546: WHERE pec.payroll_action_id = p_payroll_action_id
7547: AND NOT EXISTS (SELECT 1
7546: WHERE pec.payroll_action_id = p_payroll_action_id
7547: AND NOT EXISTS (SELECT 1
7548: FROM psp_enc_lines pel
7549: WHERE pel.enc_control_id = pec.enc_control_id);
7550: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines in psp_enc_controls which doesnt have a line in psp_enc_lines');
7551:
7552: UPDATE psp_enc_controls pec
7553: SET (action_code,
7554: number_of_dr, number_of_cr,
7564: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7565: FROM psp_enc_lines pel
7566: WHERE pel.enc_control_id = pec.enc_control_id)
7567: WHERE payroll_action_id = p_payroll_action_id;
7568: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');
7569:
7570: IF (l_process_mode = 'TERMINATE') THEN
7571: UPDATE psp_enc_changed_assignments peca
7572: SET payroll_action_id = p_payroll_action_id
7583: 'U', l_last_updated_by, l_last_update_date, NULL, NVL(peca.reference_id, 0),
7584: NVL(peca.action_type, 'U'), p_payroll_action_id, change_date
7585: FROM psp_enc_changed_assignments peca
7586: WHERE payroll_action_id = p_payroll_action_id;
7587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7588:
7589: DELETE psp_enc_changed_assignments peca
7590: WHERE peca.payroll_action_id = p_payroll_action_id;
7591: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');
7587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7588:
7589: DELETE psp_enc_changed_assignments peca
7590: WHERE peca.payroll_action_id = p_payroll_action_id;
7591: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');
7592:
7593: UPDATE psp_enc_processes
7594: SET process_status = 'P'
7595: WHERE payroll_action_id = p_payroll_action_id;
7592:
7593: UPDATE psp_enc_processes
7594: SET process_status = 'P'
7595: WHERE payroll_action_id = p_payroll_action_id;
7596: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');
7597:
7598: UPDATE psp_enc_processes
7599: SET process_status = 'B',
7600: process_phase = 'no_summarize_transfer'
7620: FROM psp_enc_summary_lines pesl
7621: WHERE pesl.payroll_action_id = p_payroll_action_id
7622: AND pesl.status_code = 'N'
7623: AND pesl.superceded_line_id is NOT NULL);
7624: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7625: END IF;
7626:
7627: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7628: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7625: END IF;
7626:
7627: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7628: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7629: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7630: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7631: l_request_id := fnd_request.submit_request('PSP',
7632: 'PSPENRSLT',
7633: '',
7638: TO_CHAR(l_business_group_id),
7639: TO_CHAR(l_set_of_books_id));
7640:
7641: IF l_request_id = 0 THEN
7642: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7643: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7644: fnd_msg_pub.add;
7645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7646: END IF;
7654: IF (l_st_count > 0) THEN
7655: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7656: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7657:
7658: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Summarize and Transfer');
7659: l_request_id := fnd_request.submit_request('PSP',
7660: 'PSPENSTR',
7661: '',
7662: '',
7665: TO_CHAR(l_business_group_id),
7666: TO_CHAR(l_set_of_books_id));
7667:
7668: IF l_request_id = 0 THEN
7669: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer submission failed');
7670: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7671: fnd_msg_pub.add;
7672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7673: END IF;
7675: UPDATE psp_enc_processes
7676: SET process_phase = 'deinit_st'
7677: WHERE payroll_action_id = p_payroll_action_id
7678: AND process_code = 'ST';
7679: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7680:
7681: COMMIT;
7682:
7683: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');
7679: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7680:
7681: COMMIT;
7682:
7683: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');
7684: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
7685:
7686: IF call_status = FALSE THEN
7687: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
7683: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');
7684: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
7685:
7686: IF call_status = FALSE THEN
7687: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
7688: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
7689: fnd_msg_pub.add;
7690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7691: END IF;
7688: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
7689: fnd_msg_pub.add;
7690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7691: END IF;
7692: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');
7693: ELSE
7694: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer not required as there arent any new summary lines');
7695: END IF;
7696: END IF;
7690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7691: END IF;
7692: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');
7693: ELSE
7694: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer not required as there arent any new summary lines');
7695: END IF;
7696: END IF;
7697:
7698: COMMIT;
7695: END IF;
7696: END IF;
7697:
7698: COMMIT;
7699: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);
7700: END cel_deinit;
7701:
7702: PROCEDURE verify_changes(p_payroll_id IN NUMBER,
7703: p_assignment_id IN NUMBER,
7807: l_enc_lines_no NUMBER(15);
7808: l_delete_flag CHAR(1);
7809: l_return_status VARCHAR2(1);
7810: BEGIN
7811: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering verify_changes
7812: p_payroll_id: ' || p_payroll_id || ' p_assignment_id: ' || p_assignment_id || '
7813: p_business_group_id: ' || p_business_group_id || ' p_set_of_books_id: ' || p_set_of_books_id || '
7814: p_enc_line_type: ' || p_enc_line_type);
7815:
8111: t_enc_lines_array.r_hierarchy_code.DELETE;
8112: t_enc_lines_array.r_hierarchy_start_date.DELETE;
8113: t_enc_lines_array.r_hierarchy_end_date.DELETE;
8114:
8115: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_enc_lines_array2.r_enc_element_type_id.COUNT: ' || t_enc_lines_array2.r_enc_element_type_id.COUNT);
8116:
8117: --IF (t_enc_lines_array2.r_enc_element_type_id.COUNT = 0) THEN
8118: --delete_previous_error_log(p_assignment_id => p_assignment_id,
8119: --p_payroll_id => p_payroll_id,
8129: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8130: RAISE fnd_api.g_exc_unexpected_error;
8131: END IF;
8132:
8133: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8134: p_payroll_id: ' || p_payroll_id || ' p_assignment_id: ' || p_assignment_id || '
8135: p_business_group_id: ' || p_business_group_id || ' p_set_of_books_id: ' || p_set_of_books_id || '
8136: p_enc_line_type: ' || p_enc_line_type);
8137: l_retcode := FND_API.G_RET_STS_SUCCESS;
8142: END IF;
8143: g_error_api_path := SUBSTR('VERIFY_CHANGES:' || g_error_api_path,1,230);
8144: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES', 'VERIFY_CHANGES');
8145: l_retcode := fnd_api.g_ret_sts_unexp_error;
8146: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8147: p_payroll_id: ' || p_payroll_id || '
8148: p_assignment_id: ' || p_assignment_id || '
8149: p_business_group_id: ' || p_business_group_id || '
8150: p_set_of_books_id: ' || p_set_of_books_id || '
8227: FROM psp_enc_lines_history pelh
8228: WHERE pelh.change_flag = 'N'
8229: AND pelh.assignment_id = p_assignment_id
8230: AND pelh.payroll_id = p_payroll_id);
8231: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' No of liquidation lines created: ' || SQL%ROWCOUNT);
8232:
8233: p_return_status := fnd_api.g_ret_sts_success;
8234: EXCEPTION
8235: WHEN OTHERS THEN
8397: g_actual_term_date, SYSDATE,
8398: l_last_updated_by, l_last_update_login,
8399: l_last_updated_by, SYSDATE,
8400: t_sum_lines.org_id(recno));
8401: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' No of Summary lines created (t_sum_lines.enc_control_id.COUNT): ' || t_sum_lines.enc_control_id.COUNT);
8402:
8403: IF (g_dff_grouping_option = 'Y') THEN
8404: FORALL recno IN 1..t_sum_lines.enc_summary_line_id.COUNT
8405: UPDATE psp_enc_lines pel
8502: WHERE ROWNUM = 1;
8503:
8504: CURSOR action_parameters_cur IS
8505: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),
8506: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8507: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8508: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8504: CURSOR action_parameters_cur IS
8505: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),
8506: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8507: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8508: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8506: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8507: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8508: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8514: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8508: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8514: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8515: FROM psp_enc_processes pep,
8516: fnd_concurrent_requests fcr
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8514: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8515: FROM psp_enc_processes pep,
8516: fnd_concurrent_requests fcr
8517: WHERE pep.payroll_action_id = p_payroll_action_id
8518: AND fcr.request_id = pep.request_id;
8604:
8605: l_prev_enc_end_date PSP_ENC_END_DATES_V.prev_enc_end_date%TYPE; -- Bug 7188209
8606:
8607: BEGIN
8608: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ENC_PRE_PROCESS
8609: p_payroll_action_id: ' || p_payroll_action_id || '
8610: p_payroll_id: ' || p_payroll_id || '
8611: p_process_mode: ' || p_process_mode);
8612:
8612:
8613: l_request_id := FND_GLOBAL. CONC_REQUEST_ID;
8614: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8615: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8616: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_request_id: ' || l_request_id ||'
8617: l_set_of_books_id: ' || l_set_of_books_id || '
8618: l_business_group_id: ' || l_business_group_id);
8619:
8620: IF (p_process_mode = 'REGULAR') THEN
8630: OPEN c_tp_start_date;
8631: FETCH c_tp_start_date INTO l_enc_begin_date;
8632: CLOSE c_tp_start_date;
8633: END IF;
8634: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_enc_begin_date: ' || fnd_date.date_to_canonical(l_enc_begin_date));
8635:
8636: l_pre_process_mode := 'R';
8637: IF (l_new_cust = 0 AND psp_general.start_capturing_updates(l_business_group_id) = 'N') THEN
8638: l_pre_process_mode := 'F';
8646: p_return_status => l_return_status);
8647: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8649: END IF;
8650: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed psp_enc_pre_process.poeta_pre_process');
8651:
8652: IF (l_pre_process_mode <>'F') THEN
8653: psp_enc_pre_process.labor_schedule_pre_process
8654: (p_enc_line_type => 'U',
8657:
8658: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8660: END IF;
8661: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed psp_enc_pre_process.labor_schedule_pre_process');
8662: END IF;
8663:
8664: OPEN enc_payroll_cur;
8665: FETCH enc_payroll_cur INTO l_inc_exc_flag;
8663:
8664: OPEN enc_payroll_cur;
8665: FETCH enc_payroll_cur INTO l_inc_exc_flag;
8666: CLOSE enc_payroll_cur;
8667: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_inc_exc_flag: ' || l_inc_exc_flag);
8668:
8669: -- Bug 7188209
8670: select prev_enc_end_date into l_prev_enc_end_date
8671: from PSP_ENC_END_DATES_V
8670: select prev_enc_end_date into l_prev_enc_end_date
8671: from PSP_ENC_END_DATES_V
8672: where business_group_id = l_business_group_id
8673: and set_of_books_id = l_set_of_books_id;
8674: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_prev_enc_end_date = ' || l_prev_enc_end_date);
8675:
8676:
8677: IF l_inc_exc_flag = 'Y' THEN
8678:
8729: and ppa.date_earned between ptp.start_date and ptp.end_date
8730: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8731: AND pesl.payroll_id = p_payroll_id);
8732:
8733: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8734:
8735:
8736: -- Added this INSERT for bug 7188209
8737:
8774: AND pesl.status_code IN ('A', 'N')
8775: AND pesl.effective_date > l_prev_enc_end_date
8776: AND pesl.payroll_id = p_payroll_id);
8777:
8778: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8779:
8780: INSERT INTO psp_enc_changed_assignments
8781: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8782: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
8818: WHERE pesl.assignment_id = pa.assignment_id
8819: AND pesl.status_code = 'N'
8820: AND pesl.payroll_id = p_payroll_id);
8821:
8822: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8823:
8824: ELSE
8825:
8826: INSERT INTO psp_enc_changed_assignments
8869: AND ppa.payroll_id = pesl.payroll_id
8870: AND ppa.action_type IN ( 'R','Q')
8871: AND paa.action_status(+) = 'C'),l_enc_begin_date)) );
8872:
8873: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8874:
8875: -- Added for bug 7188209
8876: INSERT INTO psp_enc_changed_assignments
8877: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8906: WHERE pesl.assignment_id = pa.assignment_id
8907: AND pesl.status_code IN ('A', 'N')
8908: AND pesl.effective_date > l_prev_enc_end_date);
8909:
8910: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8911:
8912: INSERT INTO psp_enc_changed_assignments
8913: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8914: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
8949: FROM psp_enc_summary_lines pesl
8950: WHERE pesl.assignment_id = pa.assignment_id
8951: AND pesl.status_code = 'N'
8952: AND pesl.payroll_id = p_payroll_id);
8953: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8954: END IF;
8955:
8956: INSERT INTO psp_enc_changed_assignments
8957: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8996: and ppa.date_earned between ptp.start_date and ptp.end_date
8997: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8998: AND pesl2.payroll_id = p_payroll_id);
8999:
9000: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9001:
9002: UPDATE psp_enc_changed_assignments peca
9003: SET payroll_action_id = p_payroll_action_id
9004: WHERE payroll_action_id IS NULL
9007: FROM psp_enc_process_assignments pepa
9008: WHERE pepa.assignment_id = peca.assignment_id
9009: AND pepa.assignment_status NOT IN ('B', 'P')
9010: AND pepa.payroll_id = peca.payroll_id);
9011: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Marked ' || SQL%ROWCOUNT || ' assignments in psp_enc_changed_assignments to be processed by this Create and Update process');
9012:
9013: DELETE FROM psp_enc_changed_assignments
9014: WHERE payroll_action_id = p_payroll_action_id
9015: AND payroll_id = p_payroll_id
9020: MINUS
9021: SELECT ASSIGNMENT_ID FROM psp_enc_changed_asg_history
9022: WHERE payroll_id = p_payroll_id);
9023:
9024: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Deleted ' || SQL%ROWCOUNT || ' fresh excluded assignments in psp_enc_changed_assignments not to be processed by this Create and Update process');
9025:
9026: OPEN in_process_asg_cur;
9027: LOOP
9028: FETCH in_process_asg_cur INTO l_assignment_id, l_payroll_action_id;
9073: FETCH action_parameters_cur INTO l_person_id1, l_termination_date1,
9074: l_person_id2, l_termination_date2, l_person_id3, l_termination_date3,
9075: l_person_id4, l_termination_date4, l_person_id5, l_termination_date5;
9076: CLOSE action_parameters_cur;
9077: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_person_id1: ' || l_person_id1 || ' l_termination_date1: ' || fnd_date.date_to_canonical(l_termination_date1) || '
9078: l_person_id2: ' || l_person_id2 || ' l_termination_date2: ' || fnd_date.date_to_canonical(l_termination_date2) || '
9079: l_person_id3: ' || l_person_id3 || ' l_termination_date3: ' || fnd_date.date_to_canonical(l_termination_date3) || '
9080: l_person_id4: ' || l_person_id4 || ' l_termination_date4: ' || fnd_date.date_to_canonical(l_termination_date4) || '
9081: l_person_id5: ' || l_person_id5 || ' l_termination_date5: ' || fnd_date.date_to_canonical(l_termination_date5));
9074: l_person_id2, l_termination_date2, l_person_id3, l_termination_date3,
9075: l_person_id4, l_termination_date4, l_person_id5, l_termination_date5;
9076: CLOSE action_parameters_cur;
9077: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_person_id1: ' || l_person_id1 || ' l_termination_date1: ' || fnd_date.date_to_canonical(l_termination_date1) || '
9078: l_person_id2: ' || l_person_id2 || ' l_termination_date2: ' || fnd_date.date_to_canonical(l_termination_date2) || '
9079: l_person_id3: ' || l_person_id3 || ' l_termination_date3: ' || fnd_date.date_to_canonical(l_termination_date3) || '
9080: l_person_id4: ' || l_person_id4 || ' l_termination_date4: ' || fnd_date.date_to_canonical(l_termination_date4) || '
9081: l_person_id5: ' || l_person_id5 || ' l_termination_date5: ' || fnd_date.date_to_canonical(l_termination_date5));
9082:
9075: l_person_id4, l_termination_date4, l_person_id5, l_termination_date5;
9076: CLOSE action_parameters_cur;
9077: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_person_id1: ' || l_person_id1 || ' l_termination_date1: ' || fnd_date.date_to_canonical(l_termination_date1) || '
9078: l_person_id2: ' || l_person_id2 || ' l_termination_date2: ' || fnd_date.date_to_canonical(l_termination_date2) || '
9079: l_person_id3: ' || l_person_id3 || ' l_termination_date3: ' || fnd_date.date_to_canonical(l_termination_date3) || '
9080: l_person_id4: ' || l_person_id4 || ' l_termination_date4: ' || fnd_date.date_to_canonical(l_termination_date4) || '
9081: l_person_id5: ' || l_person_id5 || ' l_termination_date5: ' || fnd_date.date_to_canonical(l_termination_date5));
9082:
9083: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9076: CLOSE action_parameters_cur;
9077: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_person_id1: ' || l_person_id1 || ' l_termination_date1: ' || fnd_date.date_to_canonical(l_termination_date1) || '
9078: l_person_id2: ' || l_person_id2 || ' l_termination_date2: ' || fnd_date.date_to_canonical(l_termination_date2) || '
9079: l_person_id3: ' || l_person_id3 || ' l_termination_date3: ' || fnd_date.date_to_canonical(l_termination_date3) || '
9080: l_person_id4: ' || l_person_id4 || ' l_termination_date4: ' || fnd_date.date_to_canonical(l_termination_date4) || '
9081: l_person_id5: ' || l_person_id5 || ' l_termination_date5: ' || fnd_date.date_to_canonical(l_termination_date5));
9082:
9083: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9084: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9077: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_person_id1: ' || l_person_id1 || ' l_termination_date1: ' || fnd_date.date_to_canonical(l_termination_date1) || '
9078: l_person_id2: ' || l_person_id2 || ' l_termination_date2: ' || fnd_date.date_to_canonical(l_termination_date2) || '
9079: l_person_id3: ' || l_person_id3 || ' l_termination_date3: ' || fnd_date.date_to_canonical(l_termination_date3) || '
9080: l_person_id4: ' || l_person_id4 || ' l_termination_date4: ' || fnd_date.date_to_canonical(l_termination_date4) || '
9081: l_person_id5: ' || l_person_id5 || ' l_termination_date5: ' || fnd_date.date_to_canonical(l_termination_date5));
9082:
9083: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9084: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9085: SELECT DISTINCT l_request_id,
9096: AND NOT EXISTS (SELECT 1
9097: FROM psp_enc_summary_lines pesl2
9098: WHERE pesl2.person_id = l_person_id1
9099: AND pesl2.status_code = 'N');
9100: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9101: IF (SQL%ROWCOUNT = 0) THEN
9102: OPEN in_process_term_cur(l_person_id1);
9103: LOOP
9104: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9163: AND NOT EXISTS (SELECT 1
9164: FROM psp_enc_summary_lines pesl2
9165: WHERE pesl2.person_id = l_person_id2
9166: AND pesl2.status_code = 'N');
9167: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9168: IF (SQL%ROWCOUNT = 0) THEN
9169: OPEN in_process_term_cur(l_person_id2);
9170: LOOP
9171: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9231: AND NOT EXISTS (SELECT 1
9232: FROM psp_enc_summary_lines pesl2
9233: WHERE pesl2.person_id = l_person_id3
9234: AND pesl2.status_code = 'N');
9235: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9236: IF (SQL%ROWCOUNT = 0) THEN
9237: OPEN in_process_term_cur(l_person_id3);
9238: LOOP
9239: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9299: AND NOT EXISTS (SELECT 1
9300: FROM psp_enc_summary_lines pesl2
9301: WHERE pesl2.person_id = l_person_id4
9302: AND pesl2.status_code = 'N');
9303: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9304: IF (SQL%ROWCOUNT = 0) THEN
9305: OPEN in_process_term_cur(l_person_id4);
9306: LOOP
9307: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9367: AND NOT EXISTS (SELECT 1
9368: FROM psp_enc_summary_lines pesl2
9369: WHERE pesl2.person_id = l_person_id5
9370: AND pesl2.status_code = 'N');
9371: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9372: IF (SQL%ROWCOUNT = 0) THEN
9373: OPEN in_process_term_cur(l_person_id5);
9374: LOOP
9375: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9419: END IF;
9420: END IF;
9421:
9422: COMMIT;
9423: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
9424: p_payroll_action_id: ' || p_payroll_action_id || '
9425: p_payroll_id: ' || p_payroll_id || '
9426: p_process_mode: ' || p_process_mode);
9427: p_return_status := fnd_api.g_ret_sts_success;
9431: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
9432: END IF;
9433: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
9434: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
9435: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
9436: p_payroll_action_id: ' || p_payroll_action_id || '
9437: p_payroll_id: ' || p_payroll_id || '
9438: p_process_mode: ' || p_process_mode);
9439: p_return_status := fnd_api.g_ret_sts_unexp_error;
9483: AND assignment_id = p_assignment_id;
9484:
9485: l_request_id NUMBER(15);
9486: BEGIN
9487: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9488: l_request_id := fnd_global.conc_request_id;
9489:
9490: IF (p_person_id1 IS NULL) THEN
9491: OPEN superceded_line_cur(NULL);
9495: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
9496: UPDATE psp_enc_lines_history
9497: SET change_flag = 'N'
9498: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
9499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9500:
9501: DELETE psp_enc_summary_lines
9502: WHERE payroll_action_id = p_payroll_action_id;
9503: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
9499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9500:
9501: DELETE psp_enc_summary_lines
9502: WHERE payroll_action_id = p_payroll_action_id;
9503: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
9504:
9505: DELETE psp_enc_lines
9506: WHERE payroll_action_id = p_payroll_action_id;
9507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
9503: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
9504:
9505: DELETE psp_enc_lines
9506: WHERE payroll_action_id = p_payroll_action_id;
9507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
9508:
9509: DELETE psp_enc_controls
9510: WHERE payroll_action_id = p_payroll_action_id;
9511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
9508:
9509: DELETE psp_enc_controls
9510: WHERE payroll_action_id = p_payroll_action_id;
9511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9512:
9513: DELETE psp_report_errors
9514: WHERE payroll_action_id = p_payroll_action_id;
9515: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9512:
9513: DELETE psp_report_errors
9514: WHERE payroll_action_id = p_payroll_action_id;
9515: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9516:
9517: UPDATE psp_enc_processes
9518: SET process_status = 'B',
9519: process_phase = 'rollback'
9517: UPDATE psp_enc_processes
9518: SET process_status = 'B',
9519: process_phase = 'rollback'
9520: WHERE payroll_action_id = p_payroll_action_id;
9521: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
9522:
9523: UPDATE psp_enc_process_assignments
9524: SET assignment_status = 'B'
9525: WHERE payroll_action_id = p_payroll_action_id;
9522:
9523: UPDATE psp_enc_process_assignments
9524: SET assignment_status = 'B'
9525: WHERE payroll_action_id = p_payroll_action_id;
9526: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');
9527:
9528: UPDATE psp_enc_changed_assignments
9529: SET payroll_action_id = NULL
9530: WHERE payroll_action_id = p_payroll_action_id;
9527:
9528: UPDATE psp_enc_changed_assignments
9529: SET payroll_action_id = NULL
9530: WHERE payroll_action_id = p_payroll_action_id;
9531: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
9532:
9533: INSERT INTO psp_enc_changed_assignments
9534: (request_id, assignment_id, payroll_id, change_type,
9535: processed_flag, reference_id, action_type, change_date)
9537: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date
9538: FROM psp_enc_changed_asg_history pecah
9539: WHERE payroll_action_id = p_payroll_action_id
9540: AND action_type NOT IN ('CR', 'LQ', 'TR');
9541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9542:
9543: DELETE psp_enc_changed_asg_history
9544: WHERE payroll_action_id = p_payroll_action_id;
9545: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9542:
9543: DELETE psp_enc_changed_asg_history
9544: WHERE payroll_action_id = p_payroll_action_id;
9545: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9546: ELSE
9547: OPEN asg_cur(p_person_id1, p_assignment_id1);
9548: FETCH asg_cur BULK COLLECT INTO l_assignments;
9549: CLOSE asg_cur;
9613: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
9614: UPDATE psp_enc_lines_history
9615: SET change_flag = 'N'
9616: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
9617: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9618:
9619: DELETE psp_enc_summary_lines
9620: WHERE payroll_action_id = p_payroll_action_id
9621: AND assignment_id = l_assignments(recno);
9618:
9619: DELETE psp_enc_summary_lines
9620: WHERE payroll_action_id = p_payroll_action_id
9621: AND assignment_id = l_assignments(recno);
9622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
9623:
9624: DELETE psp_enc_lines
9625: WHERE payroll_action_id = p_payroll_action_id
9626: AND assignment_id = l_assignments(recno);
9623:
9624: DELETE psp_enc_lines
9625: WHERE payroll_action_id = p_payroll_action_id
9626: AND assignment_id = l_assignments(recno);
9627: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
9628:
9629: DELETE psp_enc_controls pec
9630: WHERE payroll_action_id = p_payroll_action_id
9631: AND NOT EXISTS (SELECT 1
9631: AND NOT EXISTS (SELECT 1
9632: FROM psp_enc_lines pel
9633: WHERE payroll_action_id = p_payroll_action_id
9634: AND pel.enc_control_id = pec.enc_control_id);
9635: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9636:
9637: DELETE psp_report_errors
9638: WHERE payroll_action_id = p_payroll_action_id
9639: AND source_id = l_assignments(recno);
9636:
9637: DELETE psp_report_errors
9638: WHERE payroll_action_id = p_payroll_action_id
9639: AND source_id = l_assignments(recno);
9640: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9641:
9642: UPDATE psp_enc_process_assignments
9643: SET assignment_status = 'B'
9644: WHERE payroll_action_id = p_payroll_action_id
9642: UPDATE psp_enc_process_assignments
9643: SET assignment_status = 'B'
9644: WHERE payroll_action_id = p_payroll_action_id
9645: AND assignment_id = l_assignments(recno);
9646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');
9647:
9648: UPDATE psp_enc_changed_assignments
9649: SET payroll_action_id = NULL
9650: WHERE payroll_action_id = p_payroll_action_id
9648: UPDATE psp_enc_changed_assignments
9649: SET payroll_action_id = NULL
9650: WHERE payroll_action_id = p_payroll_action_id
9651: AND assignment_id = l_assignments(recno);
9652: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
9653:
9654: INSERT INTO psp_enc_changed_assignments
9655: (request_id, assignment_id, payroll_id, change_type,
9656: processed_flag, reference_id, action_type, change_date)
9659: FROM psp_enc_changed_asg_history pecah
9660: WHERE payroll_action_id = p_payroll_action_id
9661: AND assignment_id = l_assignments(recno)
9662: AND action_type NOT IN ('CR', 'LQ', 'TR');
9663: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9664:
9665: DELETE psp_enc_changed_asg_history
9666: WHERE payroll_action_id = p_payroll_action_id
9667: AND assignment_id = l_assignments(recno);
9664:
9665: DELETE psp_enc_changed_asg_history
9666: WHERE payroll_action_id = p_payroll_action_id
9667: AND assignment_id = l_assignments(recno);
9668: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9669: END LOOP;
9670:
9671: UPDATE psp_enc_processes
9672: SET process_status = 'B',
9674: WHERE payroll_action_id = p_payroll_action_id
9675: AND NOT EXISTS (SELECT 1
9676: FROM psp_enc_summary_lines
9677: WHERE payroll_action_id = p_payroll_action_id);
9678: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
9679: END IF;
9680:
9681: COMMIT;
9682: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9678: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
9679: END IF;
9680:
9681: COMMIT;
9682: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9683: retcode := fnd_api.g_ret_sts_success;
9684: EXCEPTION
9685: WHEN OTHERS THEN
9686: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
9684: EXCEPTION
9685: WHEN OTHERS THEN
9686: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
9687: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
9688: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9689: retcode := fnd_api.g_ret_sts_unexp_error;
9690: END rollback_cel;
9691:
9692: PROCEDURE load_sch_hierarchy (p_assignment_id IN NUMBER,
10035: AND ( poa.gl_code_combination_id IS NOT NULL
10036: OR poa.award_id IS NOT NULL)
10037: ORDER BY poa.start_date_active, poa.end_date_active;
10038: BEGIN
10039: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10040: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10041: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10042: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10043:
10059: r_gee.attribute5, r_gee.attribute6,
10060: r_gee.attribute7, r_gee.attribute8,
10061: r_gee.attribute9, r_gee.attribute10, r_gee.acct_type;
10062: CLOSE global_element_cur;
10063: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_gee.line_account_id.COUNT: ' || r_gee.line_account_id.COUNT);
10064:
10065: OPEN sch_lines_element_type_cur;
10066: FETCH sch_lines_element_type_cur BULK COLLECT INTO r_et.line_account_id,
10067: r_et.gl_code_combination_id, r_et.project_id,
10075: r_et.attribute5, r_et.attribute6,
10076: r_et.attribute7, r_et.attribute8,
10077: r_et.attribute9, r_et.attribute10, r_et.acct_type;
10078: CLOSE sch_lines_element_type_cur;
10079: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_et.line_account_id.COUNT: ' || r_et.line_account_id.COUNT);
10080:
10081: OPEN sch_lines_element_class_cur;
10082: FETCH sch_lines_element_class_cur BULK COLLECT INTO r_ec.line_account_id,
10083: r_ec.gl_code_combination_id, r_ec.project_id,
10091: r_ec.attribute5, r_ec.attribute6,
10092: r_ec.attribute7, r_ec.attribute8,
10093: r_ec.attribute9, r_ec.attribute10, r_ec.acct_type;
10094: CLOSE sch_lines_element_class_cur;
10095: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_ec.line_account_id.COUNT: ' || r_ec.line_account_id.COUNT);
10096:
10097: OPEN sch_lines_assignment_cur;
10098: FETCH sch_lines_assignment_cur BULK COLLECT INTO r_asg.line_account_id,
10099: r_asg.gl_code_combination_id, r_asg.project_id,
10107: r_asg.attribute5, r_asg.attribute6,
10108: r_asg.attribute7, r_asg.attribute8,
10109: r_asg.attribute9, r_asg.attribute10, r_asg.acct_type;
10110: CLOSE sch_lines_assignment_cur;
10111: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_asg.line_account_id.COUNT: ' || r_asg.line_account_id.COUNT);
10112:
10113: OPEN asg_org_cur;
10114: FETCH asg_org_cur BULK COLLECT INTO r_asg_org.organization_id, r_asg_org.start_date, r_asg_org.end_date;
10115: CLOSE asg_org_cur;
10329: r_gsa.attribute9.DELETE;
10330: r_gsa.attribute10.DELETE;
10331: r_gsa.acct_type.DELETE;
10332: END LOOP;
10333: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_odls.line_account_id.COUNT: ' || r_odls.line_account_id.COUNT);
10334: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_da.line_account_id.COUNT: ' || r_da.line_account_id.COUNT);
10335: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa_tmp.line_account_id.COUNT: ' || r_sa_tmp.line_account_id.COUNT);
10336:
10337: IF (r_sa_tmp.line_account_id.COUNT = 0) THEN
10330: r_gsa.attribute10.DELETE;
10331: r_gsa.acct_type.DELETE;
10332: END LOOP;
10333: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_odls.line_account_id.COUNT: ' || r_odls.line_account_id.COUNT);
10334: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_da.line_account_id.COUNT: ' || r_da.line_account_id.COUNT);
10335: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa_tmp.line_account_id.COUNT: ' || r_sa_tmp.line_account_id.COUNT);
10336:
10337: IF (r_sa_tmp.line_account_id.COUNT = 0) THEN
10338: OPEN generic_suspense_cur;
10331: r_gsa.acct_type.DELETE;
10332: END LOOP;
10333: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_odls.line_account_id.COUNT: ' || r_odls.line_account_id.COUNT);
10334: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_da.line_account_id.COUNT: ' || r_da.line_account_id.COUNT);
10335: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa_tmp.line_account_id.COUNT: ' || r_sa_tmp.line_account_id.COUNT);
10336:
10337: IF (r_sa_tmp.line_account_id.COUNT = 0) THEN
10338: OPEN generic_suspense_cur;
10339: FETCH generic_suspense_cur BULK COLLECT INTO r_sa.line_account_id,
10348: r_sa.attribute5, r_sa.attribute6,
10349: r_sa.attribute7, r_sa.attribute8,
10350: r_sa.attribute9, r_sa.attribute10, r_sa.acct_type;
10351: CLOSE generic_suspense_cur;
10352: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa.line_account_id.COUNT: ' || r_sa.line_account_id.COUNT);
10353: ELSE
10354: OPEN generic_suspense_cur;
10355: FETCH generic_suspense_cur BULK COLLECT INTO r_gsa.line_account_id,
10356: r_gsa.gl_code_combination_id, r_gsa.project_id,
10364: r_gsa.attribute5, r_gsa.attribute6,
10365: r_gsa.attribute7, r_gsa.attribute8,
10366: r_gsa.attribute9, r_gsa.attribute10, r_gsa.acct_type;
10367: CLOSE generic_suspense_cur;
10368: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_gsa.line_account_id.COUNT: ' || r_gsa.line_account_id.COUNT);
10369:
10370: g_sa_pointer := 0;
10371: IF (r_sa_tmp.start_date_active(1) >= r_enc_period.r_asg_start_date(1)) THEN
10372: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) ||
10368: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_gsa.line_account_id.COUNT: ' || r_gsa.line_account_id.COUNT);
10369:
10370: g_sa_pointer := 0;
10371: IF (r_sa_tmp.start_date_active(1) >= r_enc_period.r_asg_start_date(1)) THEN
10372: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) ||
10373: ' r_sa_tmp.start_date_active(1): ' || r_sa_tmp.start_date_active(1) ||
10374: ' r_enc_period.r_asg_start_date(1): ' || r_enc_period.r_asg_start_date(1));
10375: FOR gsa_rec_no IN 1..r_gsa.line_account_id.COUNT
10376: LOOP
10401: r_sa.attribute9(g_sa_pointer) := r_gsa.attribute9(gsa_rec_no);
10402: r_sa.attribute10(g_sa_pointer) := r_gsa.attribute10(gsa_rec_no);
10403: r_sa.acct_type(g_sa_pointer) := r_gsa.acct_type(gsa_rec_no);
10404: END LOOP;
10405: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Identified Generic Suspense Lines for suspense gap before the first suspense line');
10406: END IF;
10407: g_sa_pointer := g_sa_pointer + 1;
10408: r_sa.line_account_id(g_sa_pointer) := r_sa_tmp.line_account_id(1);
10409: r_sa.gl_code_combination_id(g_sa_pointer) := r_sa_tmp.gl_code_combination_id(1);
10428: r_sa.attribute8(g_sa_pointer) := r_sa_tmp.attribute8(1);
10429: r_sa.attribute9(g_sa_pointer) := r_sa_tmp.attribute9(1);
10430: r_sa.attribute10(g_sa_pointer) := r_sa_tmp.attribute10(1);
10431: r_sa.acct_type(g_sa_pointer) := r_sa_tmp.acct_type(1);
10432: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Stamped first suspense line');
10433:
10434: IF (r_sa_tmp.line_account_id.COUNT > 1) THEN
10435: FOR sa_recno IN 2..r_sa_tmp.line_account_id.COUNT
10436: LOOP
10556: r_sa_tmp.attribute9.DELETE;
10557: r_sa_tmp.attribute10.DELETE;
10558: r_sa_tmp.acct_type.DELETE;
10559: END IF;
10560: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa.line_account_id.COUNT: ' || r_sa.line_account_id.COUNT);
10561: END IF;
10562:
10563: r_gsa.line_account_id.DELETE;
10564: r_gsa.gl_code_combination_id.DELETE;
10584: r_gsa.attribute9.DELETE;
10585: r_gsa.attribute10.DELETE;
10586: r_gsa.acct_type.DELETE;
10587:
10588: g_pateo_end_date := fnd_date.canonical_to_date('1800/01/01 00:00:00');
10589:
10590: hr_utility.trace('
10591: Global Element Hierarchy');
10592: hr_utility.trace(LPAD('Element Account Id', 18, ' ') || ' ' ||
10923: END IF;
10924: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_sa.poeta_end_date(recno), g_pateo_end_date));
10925: END LOOP;
10926:
10927: IF ((g_pateo_end_date = fnd_date.canonical_to_date('1800/01/01 00:00:00')) OR
10928: (g_pateo_end_date < g_enc_org_end_date)) THEN
10929: g_pateo_end_date := g_enc_org_end_date;
10930: END IF;
10931: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_pateo_end_date: ' || TO_CHAR(g_pateo_end_date, 'DD-MON-RRRR'));
10927: IF ((g_pateo_end_date = fnd_date.canonical_to_date('1800/01/01 00:00:00')) OR
10928: (g_pateo_end_date < g_enc_org_end_date)) THEN
10929: g_pateo_end_date := g_enc_org_end_date;
10930: END IF;
10931: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_pateo_end_date: ' || TO_CHAR(g_pateo_end_date, 'DD-MON-RRRR'));
10932:
10933: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
10934: p_return_status := fnd_api.g_ret_sts_success;
10935: EXCEPTION
10929: g_pateo_end_date := g_enc_org_end_date;
10930: END IF;
10931: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_pateo_end_date: ' || TO_CHAR(g_pateo_end_date, 'DD-MON-RRRR'));
10932:
10933: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
10934: p_return_status := fnd_api.g_ret_sts_success;
10935: EXCEPTION
10936: WHEN OTHERS THEN
10937: IF (g_error_message IS NULL) THEN
10939: END IF;
10940: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
10941: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
10942: p_return_status := fnd_api.g_ret_sts_unexp_error;
10943: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
10944: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
10945: END load_sch_hierarchy;
10946:
10947: PROCEDURE add_cel_warnings(p_start_date IN DATE DEFAULT NULL,
10940: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
10941: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
10942: p_return_status := fnd_api.g_ret_sts_unexp_error;
10943: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
10944: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
10945: END load_sch_hierarchy;
10946:
10947: PROCEDURE add_cel_warnings(p_start_date IN DATE DEFAULT NULL,
10948: p_end_date IN DATE DEFAULT NULL,
11289: t_enc_lines r_enc_rec;
11290: t_enc_nlines r_enc_rec;
11291: l_nlines_counter NUMBER(15);
11292: BEGIN
11293: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering UPDATE_HIERARCHY_DATES');
11294: OPEN hierarchy_dates_cur;
11295: FETCH hierarchy_dates_cur BULK COLLECT INTO t_enc_lines.element_type_id, t_enc_lines.hierarchy_code,
11296: t_enc_lines.gl_ccid, t_enc_lines.project_id, t_enc_lines.task_id,
11297: t_enc_lines.award_id, t_enc_lines.exp_org_id, t_enc_lines.exp_type,
11500: AND enc_start_date <= t_enc_nlines.enc_end_date(recno)
11501: AND enc_end_date >= t_enc_nlines.enc_start_date(recno);
11502: END IF;
11503: p_return_status := fnd_api.g_ret_sts_success;
11504: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
11505: EXCEPTION
11506: WHEN OTHERS THEN
11507: IF (g_error_message IS NULL) THEN
11508: g_error_message := 'UPDATE_HIERARCHY_DATES: ' || SQLERRM;
11509: END IF;
11510: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
11511: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' UPDATE_HIERARCHY_DATES');
11512: p_return_status := fnd_api.g_ret_sts_unexp_error;
11513: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
11514: END update_hierarchy_dates;
11515:
11516: PROCEDURE clear_sch_hierarchy IS
11517: BEGIN