[Home] [Help]
599:
600: BEGIN
601:
602: FND_MSG_PUB.Initialize;
603: ---hr_utility.trace_on('Y','IMPORT-1');
604: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');
605: hr_utility.trace(' Entering IMPORT_PAYTRANS');
606:
607:
601:
602: FND_MSG_PUB.Initialize;
603: ---hr_utility.trace_on('Y','IMPORT-1');
604: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');
605: hr_utility.trace(' Entering IMPORT_PAYTRANS');
606:
607:
608: /*******************************************************************************************
609:
857:
858: OPEN get_pay_costs_csr;
859: FETCH get_pay_costs_csr into g_pay_costs_rec;
860: IF get_pay_costs_csr%NOTFOUND then
861: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);
862: raise NO_DATA_FOUND;
863: close get_pay_costs_csr;
864: END IF;
865: close get_pay_costs_csr;
866: l_prev_time_period_id := null;
867: l_prev_start_date := TO_DATE('1','j');
868: l_prev_end_date := TO_DATE('1','j');
869:
870: hr_utility.trace(' opening get_pay_costs_csr for l_assignment_action_id = '||l_assignment_action_id);
871:
872: OPEN get_pay_costs_csr;
873: LOOP --LOOP1 begin
874: BEGIN
874: BEGIN
875: fetch get_pay_costs_csr into g_pay_costs_rec;
876: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
877:
878: hr_utility.trace(' NEXT loop iteration');
879: hr_utility.trace(' Initial g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
880: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
881:
882:
875: fetch get_pay_costs_csr into g_pay_costs_rec;
876: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
877:
878: hr_utility.trace(' NEXT loop iteration');
879: hr_utility.trace(' Initial g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
880: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
881:
882:
883: g_entry_date_earned := NULL;
876: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
877:
878: hr_utility.trace(' NEXT loop iteration');
879: hr_utility.trace(' Initial g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
880: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
881:
882:
883: g_entry_date_earned := NULL;
884: OPEN ee_date_earned_cur;
884: OPEN ee_date_earned_cur;
885: FETCH ee_date_earned_cur INTO g_effective_start_date, g_effective_end_date, g_entry_date_earned; -- LD Added
886: CLOSE ee_date_earned_cur;
887:
888: hr_utility.trace(' after cursor g_effective_start_date: ' || to_char(g_effective_start_date,'DD-MON-YYYY'));
889: hr_utility.trace(' after cursor g_effective_end_date: ' || to_char(g_effective_end_date,'DD-MON-YYYY'));
890: hr_utility.trace(' after cursor g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
891:
892: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);
885: FETCH ee_date_earned_cur INTO g_effective_start_date, g_effective_end_date, g_entry_date_earned; -- LD Added
886: CLOSE ee_date_earned_cur;
887:
888: hr_utility.trace(' after cursor g_effective_start_date: ' || to_char(g_effective_start_date,'DD-MON-YYYY'));
889: hr_utility.trace(' after cursor g_effective_end_date: ' || to_char(g_effective_end_date,'DD-MON-YYYY'));
890: hr_utility.trace(' after cursor g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
891:
892: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);
893:
886: CLOSE ee_date_earned_cur;
887:
888: hr_utility.trace(' after cursor g_effective_start_date: ' || to_char(g_effective_start_date,'DD-MON-YYYY'));
889: hr_utility.trace(' after cursor g_effective_end_date: ' || to_char(g_effective_end_date,'DD-MON-YYYY'));
890: hr_utility.trace(' after cursor g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
891:
892: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);
893:
894: /* Commented for bug 6046087
901: IF (g_ignore_date_earned = 'Y') THEN
902: g_start_date := g_pay_costs_rec.tp_start_date;
903: g_end_date := g_pay_costs_rec.tp_end_date;
904:
905: hr_utility.trace('IF cost_id, start_Date,
906: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
907: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
908: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
909:
910: ELSE
911: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
912: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
913:
914: hr_utility.trace('ELSE cost_id, start_Date,
915: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
916: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
917: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
918: END IF;
916: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
917: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
918: END IF;
919:
920: hr_utility.trace(' g_start_date ' || to_char(g_start_date,'DD-MON-YYYY'));
921: hr_utility.trace(' g_end_date ' || to_char(g_end_date,'DD-MON-YYYY'));
922:
923:
924: l_or_gl_ccid := NULL;
917: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
918: END IF;
919:
920: hr_utility.trace(' g_start_date ' || to_char(g_start_date,'DD-MON-YYYY'));
921: hr_utility.trace(' g_end_date ' || to_char(g_end_date,'DD-MON-YYYY'));
922:
923:
924: l_or_gl_ccid := NULL;
925: l_or_project_id := NULL;
938: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
939: USING g_pay_costs_rec.date_earned;
940: EXCEPTION
941: WHEN OTHERS THEN
942: hr_utility.trace(' No Element Entry record found');
943: END;
944: ELSE
945: BEGIN
946: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
950: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
951: USING g_pay_costs_rec.date_earned;
952: EXCEPTION
953: WHEN OTHERS THEN
954: hr_utility.trace(' No Element Entry record found');
955: END;
956: END IF;
957: ELSIF (l_gl_column IS NOT NULL) THEN
958: BEGIN
962: INTO l_or_gl_ccid
963: USING g_pay_costs_rec.date_earned;
964: EXCEPTION
965: WHEN OTHERS THEN
966: hr_utility.trace(' No Element Entry record found');
967: END;
968: ELSIF (l_pt_column IS NOT NULL) THEN
969: IF (l_aw_column IS NOT NULL) THEN
970: BEGIN
976: INTO l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
977: USING g_pay_costs_rec.date_earned;
978: EXCEPTION
979: WHEN OTHERS THEN
980: hr_utility.trace(' No Element Entry record found');
981: END;
982: ELSE
983: BEGIN
984: EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
989: INTO l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
990: USING g_pay_costs_rec.date_earned;
991: EXCEPTION
992: WHEN OTHERS THEN
993: hr_utility.trace(' No Element Entry record found');
994: END;
995: END IF;
996: END IF;
997:
1123: if g_pay_costs_rec.time_period_id <> nvl(l_prev_time_period_id, -1) OR
1124: g_start_date <> l_prev_start_date OR
1125: g_end_date <> l_prev_end_date
1126: then
1127: hr_utility.trace(' CHANGE IN TIME PERIOD ');
1128: l_prev_time_period_id := g_pay_costs_rec.time_period_id;
1129: l_prev_start_date := g_start_date;
1130: l_prev_end_date := g_end_date;
1131:
1141: -- This procedure looks into per_assignments_f for assignment
1142: -- end date. If the assignment end date falls in to the payroll period,
1143: -- it updates the array rows with 'N' for the rows after the assignment end date.
1144:
1145: hr_utility.trace(' UPDATE_WCAL_ASG_END_DATE');
1146: UPDATE_WCAL_ASG_END_DATE(X_ASSIGNMENT_ID => l_assignment_id,
1147: X_RETURN_STATUS => l_return_status);
1148: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1149: l_error_api_name := 'UPDATE_WCAL_ASG_END_DATE : ';
1149: l_error_api_name := 'UPDATE_WCAL_ASG_END_DATE : ';
1150: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1151: end if;
1152:
1153: hr_utility.trace(' UPDATE_WCAL_ASG_BEGIN_DATE');
1154: UPDATE_WCAL_ASG_BEGIN_DATE(X_ASSIGNMENT_ID => l_assignment_id,
1155: X_RETURN_STATUS => l_return_status);
1156: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1157: l_error_api_name := 'UPDATE_WCAL_ASG_BEGIN_DATE : ';
1161: -- This procedure looks into per_assignments_f for assignment
1162: -- status. If the assignment status is 'Suspend' or 'Terminate' for any of the days
1163: -- in the payroll period, it updates the working calendar array with 'N' for those days.
1164:
1165: hr_utility.trace(' UPDATE_WCAL_ASG_STATUS');
1166: UPDATE_WCAL_ASG_STATUS(X_ASSIGNMENT_ID => l_assignment_id,
1167: X_RETURN_STATUS => l_return_status);
1168: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1169: l_error_api_name := 'UPDATE_WCAL_ASG_STATUS : ';
1168: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1169: l_error_api_name := 'UPDATE_WCAL_ASG_STATUS : ';
1170: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1171: end if;
1172: hr_utility.trace(' AFTER UPDATE_WCAL_ASG_STATUS');
1173: begin
1174: l_export_id := null;
1175:
1176: for i in 1..time_period_id_a.count
1174: l_export_id := null;
1175:
1176: for i in 1..time_period_id_a.count
1177: loop
1178: hr_utility.trace(' KKKK='||i);
1179: if (g_pay_costs_rec.time_period_id = time_period_id_a(i)
1180: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271
1181: then
1182: hr_utility.trace(' KXyy='||i);
1178: hr_utility.trace(' KKKK='||i);
1179: if (g_pay_costs_rec.time_period_id = time_period_id_a(i)
1180: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271
1181: then
1182: hr_utility.trace(' KXyy='||i);
1183: l_export_id := payroll_control_id_a(i);
1184: hr_utility.trace(' KXzy='||i);
1185: end if;
1186: end loop;
1180: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271
1181: then
1182: hr_utility.trace(' KXyy='||i);
1183: l_export_id := payroll_control_id_a(i);
1184: hr_utility.trace(' KXzy='||i);
1185: end if;
1186: end loop;
1187:
1188: exception
1187:
1188: exception
1189: when others then
1190: l_period_name := sqlerrm;
1191: hr_utility.trace(' KKKK'||l_period_name);
1192:
1193:
1194: end;
1195: hr_utility.trace(' AFTER SET l_export_id');
1191: hr_utility.trace(' KKKK'||l_period_name);
1192:
1193:
1194: end;
1195: hr_utility.trace(' AFTER SET l_export_id');
1196: end if;
1197:
1198: hr_utility.trace(' Found cost record Cost_id, costed_value =' ||g_pay_costs_rec.cost_id||','||g_pay_costs_rec.costed_value);
1199: -- Bug 1994421 : Zero Work Days Build - Assigned values to variables for processing non active assignments -lveerubh
1194: end;
1195: hr_utility.trace(' AFTER SET l_export_id');
1196: end if;
1197:
1198: hr_utility.trace(' Found cost record Cost_id, costed_value =' ||g_pay_costs_rec.cost_id||','||g_pay_costs_rec.costed_value);
1199: -- Bug 1994421 : Zero Work Days Build - Assigned values to variables for processing non active assignments -lveerubh
1200: g_non_active_flag := 'N';
1201: g_hire_zero_Work_days := 'N';
1202: g_all_holiday_zero_work_days := 'N';
1214: RAISE ZERO_WORK_DAYS;
1215: end if;
1216: /*END IF;*/
1217:
1218: hr_utility.trace(' Before opening check_payroll_lines_csr');
1219: OPEN check_payroll_lines_csr;
1220: FETCH check_payroll_lines_csr into l_cost_id;
1221:
1222: IF check_payroll_lines_csr%NOTFOUND then
1221:
1222: IF check_payroll_lines_csr%NOTFOUND then
1223: l_counter := l_counter + 1;
1224:
1225: ---hr_utility.trace(' No data found in payroll_lines ');
1226: -- If first record insert a record in psp_payroll_controls
1227:
1228:
1229: hr_utility.trace(' l_counter = '||l_counter);
1225: ---hr_utility.trace(' No data found in payroll_lines ');
1226: -- If first record insert a record in psp_payroll_controls
1227:
1228:
1229: hr_utility.trace(' l_counter = '||l_counter);
1230: IF l_counter > 0 then
1231: -- Introduced for bug fix 2916848
1232:
1233: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||
1229: hr_utility.trace(' l_counter = '||l_counter);
1230: IF l_counter > 0 then
1231: -- Introduced for bug fix 2916848
1232:
1233: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||
1234: g_pay_costs_rec.output_currency_code);
1235: IF nvl(l_prev_currency_code,g_pay_costs_rec.output_currency_code) <> g_pay_costs_rec.output_currency_code THEN
1236: l_prev_currency_code := g_pay_costs_rec.output_currency_code;
1237: l_export_id := NULL;
1367: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1368: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1369: fnd_message.set_token('CLEARING', l_clearing_account_value);
1370: fnd_msg_pub.add;
1371: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1372: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1375:
1370: fnd_msg_pub.add;
1371: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1372: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1375:
1376: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id
1377: FROM DUAL;
1378: x_rowid := NULL;
1746: l_error_api_name := 'CREATE_SLINE_BUDGET_CHANGE : ';
1747: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1748: end if;
1749:
1750: hr_utility.trace(' Opening get_difference_csr cursor');
1751:
1752: -- Insert rounding routine here
1753: open get_difference_csr;
1754: fetch get_difference_csr into l_subline_sum;
1821: WHEN OTHERS then
1822: retcode := 2;
1823: rollback;
1824:
1825: hr_utility.trace(' Process failed here');
1826:
1827: psp_message_s.print_error(p_mode=>FND_FILE.log,
1828: p_print_header=>FND_API.G_TRUE
1829: );
1839: payroll_control_id_a.delete;
1840: time_period_id_a.delete;
1841: currency_code_a.delete; -- Bug 6468271
1842:
1843: hr_utility.trace(' Finally Updating psp_payroll_controls');
1844:
1845: FORALL k in 1 .. l_total_num_rec
1846: UPDATE psp_payroll_controls
1847: set number_of_cr = r_payroll_Control_array.r_tot_cr(k),
1914: fnd_file.put_line(fnd_file.log, '');
1915:
1916: l_count := 0;
1917: l_heading := null;
1918: hr_utility.trace(' before get_import_summary_heading');
1919: fnd_file.put_line(fnd_file.log, ' ');
1920: fnd_file.put_line(fnd_file.log, ' ');
1921: fnd_file.put_line(fnd_file.log, ' ');
1922: open get_import_summary_heading;
1966: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
1967: fnd_file.put_line(fnd_file.log, '');
1968: fnd_file.put_line(fnd_file.log, '');
1969: fnd_file.put_line(fnd_file.log, '');
1970: hr_utility.trace(' Leaving IMPORT_PAYTRANS');
1971:
1972: EXCEPTION
1973: WHEN NO_DATA_FOUND then
1974: close get_payroll_assig_actions_csr;
2181: n number(9) := 0;
2182: */
2183:
2184: begin
2185: hr_utility.trace(' assignment_id = '||x_assignment_id);
2186: l_begin_date := null;
2187:
2188: ----dbms_output.put_line('Entered Proceduer update_wcal_asg_begin_date..');
2189: open get_asg_begin_date_csr;
2188: ----dbms_output.put_line('Entered Proceduer update_wcal_asg_begin_date..');
2189: open get_asg_begin_date_csr;
2190: fetch get_asg_begin_date_csr into l_begin_date;
2191: close get_asg_begin_date_csr;
2192: ---hr_utility.trace(' asg begin date = '||l_begin_date);
2193: ---hr_utility.trace(' g date = '||g_start_date||','||g_end_date);
2194: /*
2195: if trunc(l_begin_date) != trunc(g_start_date) then
2196: ----dbms_output.put_line('Entered IF..');
2189: open get_asg_begin_date_csr;
2190: fetch get_asg_begin_date_csr into l_begin_date;
2191: close get_asg_begin_date_csr;
2192: ---hr_utility.trace(' asg begin date = '||l_begin_date);
2193: ---hr_utility.trace(' g date = '||g_start_date||','||g_end_date);
2194: /*
2195: if trunc(l_begin_date) != trunc(g_start_date) then
2196: ----dbms_output.put_line('Entered IF..');
2197: n := (trunc(l_begin_date) - trunc(g_start_date)) ;
2217: while i < n loop
2218: if work_calendar(i)='Y' then
2219: g_no_of_person_work_days:= g_no_of_person_work_days - 1;
2220: work_calendar(i):= 'N';
2221: hr_utility.trace(' i = N, i = '||i);
2222: -- ------dbms_output.put_line('Work Calendar' ||to_char(i)||' N');
2223: end if;
2224: i:= i+1;
2225: end loop;
2735: begin
2736:
2737: ----dbms_output.PUT_LINE(' Just entered calculate_balance_amount proc... ' );
2738: ----dbms_output.PUT_LINE('g_no_of_days ' || to_char(g_no_of_days));
2739: hr_utility.trace(' Entering CALCULATE_BALANCE_AMOUNT');
2740:
2741: for i in 1..g_no_of_days loop
2742: ----dbms_output.PUT_LINE('Daily Amount ' || to_char(i) || ' ' || to_char(daily_calendar(i)));
2743: l_total_salary := l_total_salary + daily_calendar(i);
2753: x_balance_amount := 0.00;
2754: end if;
2755: x_return_status := FND_API.G_RET_STS_SUCCESS;
2756:
2757: hr_utility.trace(' Leaving CALCULATE_BALANCE_AMOUNT');
2758:
2759: EXCEPTION
2760: WHEN OTHERS then
2761: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CALCULATE_BALANCE_AMOUNT');
2924: l_paybasis varchar2(30);
2925:
2926: --
2927: BEGIN
2928: hr_utility.trace(' Entering CREATE_SLINE_SALARY_CHANGE');
2929: hr_utility.trace(' X_Payroll_line_id ...' || to_char(x_payroll_line_id));
2930: open get_payroll_line_csr;
2931: fetch get_payroll_line_csr into g_payroll_line_rec;
2932: if get_payroll_line_csr%NOTFOUND then
2925:
2926: --
2927: BEGIN
2928: hr_utility.trace(' Entering CREATE_SLINE_SALARY_CHANGE');
2929: hr_utility.trace(' X_Payroll_line_id ...' || to_char(x_payroll_line_id));
2930: open get_payroll_line_csr;
2931: fetch get_payroll_line_csr into g_payroll_line_rec;
2932: if get_payroll_line_csr%NOTFOUND then
2933: fnd_message.set_name('PSP', 'PSP_NO_PAYROLL_LINES');
2935: close get_payroll_line_csr;
2936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2937: end if;
2938: close get_payroll_line_csr;
2939: ---hr_utility.trace(' Pay amount .. ' || to_char(g_payroll_line_rec.pay_amount));
2940: ---hr_utility.trace(' Balance amount .. ' || to_char(g_payroll_line_rec.balance_amount));
2941:
2942: l_sub_line_start_date := trunc(g_start_date);
2943:
2936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2937: end if;
2938: close get_payroll_line_csr;
2939: ---hr_utility.trace(' Pay amount .. ' || to_char(g_payroll_line_rec.pay_amount));
2940: ---hr_utility.trace(' Balance amount .. ' || to_char(g_payroll_line_rec.balance_amount));
2941:
2942: l_sub_line_start_date := trunc(g_start_date);
2943:
2944: if round(g_payroll_line_rec.balance_amount, g_precision) <> 0.00 then -- Modified rounding precision to currency precision for bug fix 2916848
2951: l_daily_balance := round((g_payroll_line_rec.balance_amount / l_total_work_days), g_ext_precision);
2952: else
2953: l_daily_balance := 0.00;
2954: end if;
2955: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
2956: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
2957: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
2958: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
2959: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
2952: else
2953: l_daily_balance := 0.00;
2954: end if;
2955: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
2956: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
2957: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
2958: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
2959: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
2960:
2953: l_daily_balance := 0.00;
2954: end if;
2955: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
2956: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
2957: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
2958: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
2959: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
2960:
2961: open get_proposal_csr;
2954: end if;
2955: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
2956: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
2957: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
2958: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
2959: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
2960:
2961: open get_proposal_csr;
2962: --fetch geto _proposal_csr into l_change_date, l_salary, l_proposed_salary;
2955: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
2956: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
2957: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
2958: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
2959: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
2960:
2961: open get_proposal_csr;
2962: --fetch geto _proposal_csr into l_change_date, l_salary, l_proposed_salary;
2963: fetch get_proposal_csr into
2964: l_proposed_salary, l_change_date;
2965: -- l_proposed_salary, l_salary, l_change_date;
2966: -- l_last_change_date1, l_pay_basis1;
2967:
2968: ---hr_utility.trace(' Just After fetch get_proposal l_change_date '||to_char(l_change_date) );
2969: ---hr_utility.trace(' Just After fetch get_proposal l_proposed_sal '||to_char(l_proposed_salary) );
2970: if get_proposal_csr%NOTFOUND then
2971: close get_proposal_csr;
2972: raise NO_DATA_FOUND;
2965: -- l_proposed_salary, l_salary, l_change_date;
2966: -- l_last_change_date1, l_pay_basis1;
2967:
2968: ---hr_utility.trace(' Just After fetch get_proposal l_change_date '||to_char(l_change_date) );
2969: ---hr_utility.trace(' Just After fetch get_proposal l_proposed_sal '||to_char(l_proposed_salary) );
2970: if get_proposal_csr%NOTFOUND then
2971: close get_proposal_csr;
2972: raise NO_DATA_FOUND;
2973: end if;
2972: raise NO_DATA_FOUND;
2973: end if;
2974: close get_proposal_csr;
2975:
2976: hr_utility.trace(' Just crossed NOTFOUND if' );
2977:
2978: open get_proposal_csr;
2979: loop
2980: hr_utility.trace(' Just entered Loop ' );
2976: hr_utility.trace(' Just crossed NOTFOUND if' );
2977:
2978: open get_proposal_csr;
2979: loop
2980: hr_utility.trace(' Just entered Loop ' );
2981: -- fetch get_proposal_csr into l_change_date, l_salary, l_proposed_salary;
2982:
2983:
2984: fetch get_proposal_csr into
2986: -- l_proposed_salary, l_salary, l_change_date,
2987: -- l_last_change_date1, l_pay_basis1;
2988:
2989: EXIT WHEN get_proposal_csr%NOTFOUND;
2990: --- hr_utility.trace(' After Exit When' );
2991:
2992: ---hr_utility.trace(' proposed salary inside loop '||to_char(l_proposed_salary));
2993: ---hr_utility.trace(' change_date is inside loop '||to_char(l_change_date));
2994:
2988:
2989: EXIT WHEN get_proposal_csr%NOTFOUND;
2990: --- hr_utility.trace(' After Exit When' );
2991:
2992: ---hr_utility.trace(' proposed salary inside loop '||to_char(l_proposed_salary));
2993: ---hr_utility.trace(' change_date is inside loop '||to_char(l_change_date));
2994:
2995: open get_proposal_prevsal_csr(l_change_date);
2996: fetch get_proposal_prevsal_csr into get_proposal_prevsal_rec;
2989: EXIT WHEN get_proposal_csr%NOTFOUND;
2990: --- hr_utility.trace(' After Exit When' );
2991:
2992: ---hr_utility.trace(' proposed salary inside loop '||to_char(l_proposed_salary));
2993: ---hr_utility.trace(' change_date is inside loop '||to_char(l_change_date));
2994:
2995: open get_proposal_prevsal_csr(l_change_date);
2996: fetch get_proposal_prevsal_csr into get_proposal_prevsal_rec;
2997: if get_proposal_prevsal_csr%NOTFOUND then
2994:
2995: open get_proposal_prevsal_csr(l_change_date);
2996: fetch get_proposal_prevsal_csr into get_proposal_prevsal_rec;
2997: if get_proposal_prevsal_csr%NOTFOUND then
2998: --- hr_utility.trace(' no data found');
2999: -- close get_proposal_prevsal_csr;
3000: -- raise NO_DATA_FOUND;
3001: --exit;
3002: null;
3003: end if;
3004: close get_proposal_prevsal_csr;
3005:
3006: l_salary:=nvl(get_proposal_prevsal_rec.previous_salary, 0);
3007: ---hr_utility.trace(' sal from previous '||to_char(l_salary));
3008:
3009:
3010:
3011: l_work_days := 0;
3010:
3011: l_work_days := 0;
3012: l_rate_salary := 0.00;
3013: l_array_begin := (trunc(l_sub_line_start_date) - trunc(g_start_date)) + 1;
3014: hr_utility.trace(' l_arry_begin .......' || to_char(l_array_begin));
3015: l_array_end := (trunc(l_change_date) - trunc(g_start_date));
3016: l_sub_line_end_date := trunc(l_change_date) - 1;
3017: hr_utility.trace(' i......... ' || to_char(i));
3018: for i in l_array_begin..l_array_end loop
3013: l_array_begin := (trunc(l_sub_line_start_date) - trunc(g_start_date)) + 1;
3014: hr_utility.trace(' l_arry_begin .......' || to_char(l_array_begin));
3015: l_array_end := (trunc(l_change_date) - trunc(g_start_date));
3016: l_sub_line_end_date := trunc(l_change_date) - 1;
3017: hr_utility.trace(' i......... ' || to_char(i));
3018: for i in l_array_begin..l_array_end loop
3019: l_rate_salary := l_rate_salary + daily_calendar(i);
3020: -- commented the following line and added it in the following if
3021: -- the reason is if the last date is non working day, in sub lines
3034: else
3035: l_balance_salary := 0.00;
3036: end if;
3037:
3038: ---hr_utility.trace(' Daily Balance ..' || to_char(l_daily_balance));
3039: ---hr_utility.trace(' Rate Salary ..' || to_char(l_rate_salary));
3040: hr_utility.trace(' Balance Salary ..' || to_char(l_balance_salary));
3041: if round((l_rate_salary + l_balance_salary),0) = 0 then
3042: l_total_daily_rate := 0.00;
3035: l_balance_salary := 0.00;
3036: end if;
3037:
3038: ---hr_utility.trace(' Daily Balance ..' || to_char(l_daily_balance));
3039: ---hr_utility.trace(' Rate Salary ..' || to_char(l_rate_salary));
3040: hr_utility.trace(' Balance Salary ..' || to_char(l_balance_salary));
3041: if round((l_rate_salary + l_balance_salary),0) = 0 then
3042: l_total_daily_rate := 0.00;
3043: else
3036: end if;
3037:
3038: ---hr_utility.trace(' Daily Balance ..' || to_char(l_daily_balance));
3039: ---hr_utility.trace(' Rate Salary ..' || to_char(l_rate_salary));
3040: hr_utility.trace(' Balance Salary ..' || to_char(l_balance_salary));
3041: if round((l_rate_salary + l_balance_salary),0) = 0 then
3042: l_total_daily_rate := 0.00;
3043: else
3044: l_total_daily_rate := l_daily_rate + l_daily_balance;
3044: l_total_daily_rate := l_daily_rate + l_daily_balance;
3045: end if;
3046: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3047: FROM DUAL;
3048: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3049: hr_utility.trace(' inserting into Sublines -1');
3050: if l_total_daily_Rate > 0 then
3051:
3052: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3045: end if;
3046: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3047: FROM DUAL;
3048: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3049: hr_utility.trace(' inserting into Sublines -1');
3050: if l_total_daily_Rate > 0 then
3051:
3052: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3053: X_ROWID => l_rowid,
3083: x_attribute8 => NULL,
3084: x_attribute9 => NULL,
3085: x_attribute10 => NULL,
3086: X_MODE => 'R' );
3087: hr_utility.trace(' Crossed Insert rec into sub lines');
3088:
3089: l_rowid := NULL;
3090: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3091: X_ROWID => l_rowid,
3117: l_balance_salary := 0.00;
3118: end if;
3119: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3120: FROM DUAL;
3121: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3122: hr_utility.trace(' inserting into Sublines -2');
3123: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3124: X_ROWID => l_rowid,
3125: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3118: end if;
3119: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3120: FROM DUAL;
3121: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3122: hr_utility.trace(' inserting into Sublines -2');
3123: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3124: X_ROWID => l_rowid,
3125: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3126: X_PAYROLL_LINE_ID => x_payroll_line_id,
3154: x_attribute8 => NULL,
3155: x_attribute9 => NULL,
3156: x_attribute10 => NULL,
3157: X_MODE => 'R' );
3158: ----hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3159: ----hr_utility.trace(' Crossed Insert rec into sub lines 2');
3160: l_rowid := NULL;
3161: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3162: X_ROWID => l_rowid,
3155: x_attribute9 => NULL,
3156: x_attribute10 => NULL,
3157: X_MODE => 'R' );
3158: ----hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3159: ----hr_utility.trace(' Crossed Insert rec into sub lines 2');
3160: l_rowid := NULL;
3161: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3162: X_ROWID => l_rowid,
3163: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3166: X_MODE => 'R');
3167:
3168: close get_proposal_csr;
3169:
3170: hr_utility.trace(' Leaving CREATE_SLINE_SALARY_CHANGE');
3171:
3172:
3173: EXCEPTION
3174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3178:
3179: WHEN NO_DATA_FOUND then
3180: begin
3181: ----hr_utility.trace(' Entered NO_DATA_FOUND');
3182:
3183: open get_previous_proposal_csr;
3184: ----hr_utility.trace(' After open cursor');
3185: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3180: begin
3181: ----hr_utility.trace(' Entered NO_DATA_FOUND');
3182:
3183: open get_previous_proposal_csr;
3184: ----hr_utility.trace(' After open cursor');
3185: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3186: ----hr_utility.trace(' After fetch cursor');
3187: if get_previous_proposal_csr%NOTFOUND then
3188: ----hr_utility.trace(' Entered if NOTFOUND');
3182:
3183: open get_previous_proposal_csr;
3184: ----hr_utility.trace(' After open cursor');
3185: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3186: ----hr_utility.trace(' After fetch cursor');
3187: if get_previous_proposal_csr%NOTFOUND then
3188: ----hr_utility.trace(' Entered if NOTFOUND');
3189: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3190: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3184: ----hr_utility.trace(' After open cursor');
3185: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3186: ----hr_utility.trace(' After fetch cursor');
3187: if get_previous_proposal_csr%NOTFOUND then
3188: ----hr_utility.trace(' Entered if NOTFOUND');
3189: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3190: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3191: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3192:
3185: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3186: ----hr_utility.trace(' After fetch cursor');
3187: if get_previous_proposal_csr%NOTFOUND then
3188: ----hr_utility.trace(' Entered if NOTFOUND');
3189: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3190: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3191: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3192:
3193: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3186: ----hr_utility.trace(' After fetch cursor');
3187: if get_previous_proposal_csr%NOTFOUND then
3188: ----hr_utility.trace(' Entered if NOTFOUND');
3189: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3190: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3191: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3192:
3193: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3194:
3187: if get_previous_proposal_csr%NOTFOUND then
3188: ----hr_utility.trace(' Entered if NOTFOUND');
3189: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3190: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3191: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3192:
3193: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3194:
3195: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3192:
3193: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3194:
3195: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3196: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3197: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3198: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3199: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3200:
3193: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3194:
3195: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3196: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3197: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3198: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3199: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3200:
3201: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3194:
3195: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3196: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3197: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3198: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3199: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3200:
3201: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3202: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3195: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3196: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3197: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3198: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3199: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3200:
3201: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3202: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3203: l_salary:=0;
3197: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3198: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3199: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3200:
3201: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3202: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3203: l_salary:=0;
3204: hr_utility.trace(' inserting into Sublines -3');
3205: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3198: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3199: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3200:
3201: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3202: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3203: l_salary:=0;
3204: hr_utility.trace(' inserting into Sublines -3');
3205: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3206: X_ROWID => l_rowid,
3200:
3201: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3202: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3203: l_salary:=0;
3204: hr_utility.trace(' inserting into Sublines -3');
3205: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3206: X_ROWID => l_rowid,
3207: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3208: X_PAYROLL_LINE_ID => x_payroll_line_id,
3276: ----dbms_output.PUT_LINE('salary Used ' || to_char(l_salary));
3277:
3278: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3279: FROM DUAL;
3280: hr_utility.trace(' inserting into Sublines -5');
3281: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3282: X_ROWID => l_rowid,
3283: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3284: X_PAYROLL_LINE_ID => x_payroll_line_id,
3323: ----dbms_output.PUT_LINE('After Insert record ');
3324: end;
3325: end if;
3326: end;
3327: hr_utility.trace(' Leaving CREATE_SLINE_SALARY_CHANGE');
3328: close get_previous_proposal_csr;
3329:
3330: WHEN OTHERS then
3331:
3328: close get_previous_proposal_csr;
3329:
3330: WHEN OTHERS then
3331:
3332: hr_utility.trace(' Failing with the OTHERS exception');
3333: ----dbms_output.PUT_LINE('Error Num : ' || to_char(SQLCODE) || 'Err Msg : ' || SUBSTR(SQLERRM,1,100));
3334: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3335: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3375:
3376:
3377: begin
3378:
3379: hr_utility.trace(' Entering CREATE_SLINE_ASG_CHANGE');
3380: ----dbms_output.put_line('Entered Proceduer create_sline_asg_change..');
3381: open get_asg_begin_date_csr;
3382: fetch get_asg_begin_date_csr into l_start_date;
3383: if get_asg_begin_date_csr%FOUND then
3413: end if;
3414: close get_asg_end_date_csr;
3415: x_return_status := FND_API.G_RET_STS_SUCCESS;
3416:
3417: hr_utility.trace(' Leaving CREATE_SLINE_ASG_CHANGE');
3418:
3419: EXCEPTION
3420: WHEN OTHERS then
3421: close get_asg_end_date_csr;
3468: l_total_work_days number(3) := 0;
3469:
3470: begin
3471:
3472: hr_utility.trace(' Entering CREATE_SLINE_ASG_STATUS_CHANGE');
3473: ----dbms_output.put_line('Entered Proceduer create_sline_asg_status_change..');
3474: for i in 1..g_no_of_days loop
3475: if work_calendar(i) = 'Y' then
3476: l_total_work_days := l_total_work_days + 1;
3524: -- ----dbms_output.put_line('Entered 3rd if ..');
3525:
3526: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3527: FROM DUAL;
3528: hr_utility.trace(' inserting into Sublines -6');
3529: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3530: X_ROWID => l_rowid,
3531: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3532: X_PAYROLL_LINE_ID => x_payroll_line_id,
3573: l_tmp_start_date := trunc(l_start_date);
3574: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3575: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3576: FROM DUAL;
3577: hr_utility.trace(' inserting into Sublines -7');
3578: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3579: X_ROWID => l_rowid,
3580: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3581: X_PAYROLL_LINE_ID => x_payroll_line_id,
3629: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
3630: l_tmp_end_date := trunc(l_end_date);
3631: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3632: FROM DUAL;
3633: hr_utility.trace(' inserting into Sublines -8');
3634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3635: X_ROWID => l_rowid,
3636: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3637: X_PAYROLL_LINE_ID => x_payroll_line_id,
3693: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3694: end if;
3695: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3696: FROM DUAL;
3697: hr_utility.trace(' inserting into Sublines -10');
3698: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3699: X_ROWID => l_rowid,
3700: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3701: X_PAYROLL_LINE_ID => x_payroll_line_id,
3763: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3764: end if;
3765: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3766: FROM DUAL;
3767: hr_utility.trace(' inserting into Sublines -12');
3768: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3769: X_ROWID => l_rowid,
3770: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3771: X_PAYROLL_LINE_ID => x_payroll_line_id,
3811: l_tmp_start_date := trunc(l_start_date);
3812: l_tmp_end_date := trunc(l_end_date) ;
3813: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3814: FROM DUAL;
3815: hr_utility.trace(' inserting into Sublines -13');
3816: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3817: X_ROWID => l_rowid,
3818: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3819: X_PAYROLL_LINE_ID => x_payroll_line_id,
3875:
3876: end if;
3877: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3878: FROM DUAL;
3879: hr_utility.trace(' inserting into Sublines -14');
3880: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3881: X_ROWID => l_rowid,
3882: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3883: X_PAYROLL_LINE_ID => x_payroll_line_id,
3947: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3948: end if;
3949: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3950: FROM DUAL;
3951: hr_utility.trace(' inserting into Sublines -15');
3952: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3953: X_ROWID => l_rowid,
3954: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3955: X_PAYROLL_LINE_ID => x_payroll_line_id,
3996: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3997:
3998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3999: FROM DUAL;
4000: hr_utility.trace(' inserting into Sublines -17');
4001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4002: X_ROWID => l_rowid,
4003: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4004: X_PAYROLL_LINE_ID => x_payroll_line_id,
4051: l_tmp_end_date := trunc(l_end_date);
4052:
4053: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4054: FROM DUAL;
4055: hr_utility.trace(' inserting into Sublines -19');
4056: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4057: X_ROWID => l_rowid,
4058: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4059: X_PAYROLL_LINE_ID => x_payroll_line_id,
4114: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4115: end if;
4116: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4117: FROM DUAL;
4118: hr_utility.trace(' inserting into Sublines -21');
4119: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4120: X_ROWID => l_rowid,
4121: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4122: X_PAYROLL_LINE_ID => x_payroll_line_id,
4174: END LOOP;
4175: close get_asg_status_csr;
4176: x_return_status := FND_API.G_RET_STS_SUCCESS;
4177:
4178: hr_utility.trace(' Leaving CREATE_SLINE_ASG_STATUS_CHANGE');
4179: EXCEPTION
4180: WHEN NO_DATA_FOUND then
4181: x_return_status := FND_API.G_RET_STS_SUCCESS;
4182: close get_asg_status_csr;
4226:
4227: begin
4228: ----dbms_output.put_line('Entered Proceduer create_sline_emp_end_date..');
4229:
4230: hr_utility.trace(' Entering CREATE_SLINE_EMP_END_DATE');
4231:
4232: open check_service_period_begin_csr;
4233: LOOP
4234: fetch check_service_period_begin_csr into l_date_start;
4241: if l_date_start > g_sublines_rec.sub_line_start_date then
4242: l_tmp_end_date := trunc(l_date_start) - 1;
4243: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4244: FROM DUAL;
4245: hr_utility.trace(' inserting into Sublines -22');
4246: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4247: X_ROWID => l_rowid,
4248: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4249: X_PAYROLL_LINE_ID => x_payroll_line_id,
4288:
4289: l_tmp_start_date := trunc(l_date_start);
4290: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4291: FROM DUAL;
4292: hr_utility.trace(' inserting into Sublines -25');
4293: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4294: X_ROWID => l_rowid,
4295: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4296: X_PAYROLL_LINE_ID => x_payroll_line_id,
4354: if l_actual_termination_date < g_sublines_rec.sub_line_end_date then
4355: l_tmp_end_date := trunc(l_actual_termination_date) - 1;
4356: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4357: FROM DUAL;
4358: hr_utility.trace(' inserting into Sublines -28');
4359: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4360: X_ROWID => l_rowid,
4361: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4362: X_PAYROLL_LINE_ID => x_payroll_line_id,
4401:
4402: l_tmp_start_date := trunc(l_actual_termination_date);
4403: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4404: FROM DUAL;
4405: hr_utility.trace(' inserting into Sublines -30');
4406: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4407: X_ROWID => l_rowid,
4408: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4409: X_PAYROLL_LINE_ID => x_payroll_line_id,
4457: END LOOP;
4458: close check_service_period_end_csr; -- bug fix 2806589
4459: x_return_status := FND_API.G_RET_STS_SUCCESS;
4460:
4461: hr_utility.trace(' Leaving CREATE_SLINE_EMP_END_DATE');
4462:
4463: EXCEPTION
4464: WHEN OTHERS then
4465: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_EMP_END_DATE');
4521:
4522:
4523: begin
4524:
4525: hr_utility.trace(' Entering CREATE_SLINE_ORG_CHANGE');
4526:
4527: ----dbms_output.put_line('Entered Procedure create_sline_org_change');
4528: open get_old_org_csr;
4529: ----dbms_output.put_line('Before fetch of get_old_org_csr...');
4587: end if;
4588:
4589: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4590: FROM DUAL;
4591: hr_utility.trace(' inserting into Sublines -32');
4592: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4593: X_ROWID => l_rowid,
4594: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4595: X_PAYROLL_LINE_ID => x_payroll_line_id,
4651: end if;
4652:
4653: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4654: FROM DUAL;
4655: hr_utility.trace(' inserting into Sublines -33');
4656: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4657: X_ROWID => l_rowid,
4658: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4659: X_PAYROLL_LINE_ID => x_payroll_line_id,
4724: end if;
4725:
4726: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4727: FROM DUAL;
4728: hr_utility.trace(' inserting into Sublines -34');
4729: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4730: X_ROWID => l_rowid,
4731: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4732: X_PAYROLL_LINE_ID => x_payroll_line_id,
4788: end if;
4789:
4790: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4791: FROM DUAL;
4792: hr_utility.trace(' inserting into Sublines -35');
4793: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4794: X_ROWID => l_rowid,
4795: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4796: X_PAYROLL_LINE_ID => x_payroll_line_id,
4858: end if;
4859:
4860: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4861: FROM DUAL;
4862: hr_utility.trace(' inserting into Sublines -37');
4863: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4864: X_ROWID => l_rowid,
4865: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4866: X_PAYROLL_LINE_ID => x_payroll_line_id,
4922: end if;
4923:
4924: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4925: FROM DUAL;
4926: hr_utility.trace(' inserting into Sublines -39');
4927: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4928: X_ROWID => l_rowid,
4929: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4930: X_PAYROLL_LINE_ID => x_payroll_line_id,
4986: end if;
4987:
4988: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4989: FROM DUAL;
4990: hr_utility.trace(' inserting into Sublines -42');
4991: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4992: X_ROWID => l_rowid,
4993: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4994: X_PAYROLL_LINE_ID => x_payroll_line_id,
5044: END LOOP;
5045: close get_assg_csr;
5046: x_return_status := FND_API.G_RET_STS_SUCCESS;
5047:
5048: hr_utility.trace(' Leaving CREATE_SLINE_ORG_CHANGE');
5049:
5050: EXCEPTION
5051: WHEN NO_DATA_FOUND then
5052: x_return_status := FND_API.G_RET_STS_SUCCESS;
5114:
5115:
5116: begin
5117:
5118: hr_utility.trace(' Entering CREATE_SLINE_JOB_CHANGE');
5119:
5120: open get_old_job_csr;
5121: fetch get_old_job_csr into l_effective_start_date, l_old_job_id;
5122: if get_old_job_csr%NOTFOUND then
5172: end if;
5173:
5174: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5175: FROM DUAL;
5176: hr_utility.trace(' inserting into Sublines -52');
5177: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5178: X_ROWID => l_rowid,
5179: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5180: X_PAYROLL_LINE_ID => x_payroll_line_id,
5236: end if;
5237:
5238: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5239: FROM DUAL;
5240: hr_utility.trace(' inserting into Sublines -62');
5241: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5242: X_ROWID => l_rowid,
5243: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5244: X_PAYROLL_LINE_ID => x_payroll_line_id,
5309: end if;
5310:
5311: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5312: FROM DUAL;
5313: hr_utility.trace(' inserting into Sublines -92');
5314: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5315: X_ROWID => l_rowid,
5316: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5317: X_PAYROLL_LINE_ID => x_payroll_line_id,
5373: end if;
5374:
5375: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5376: FROM DUAL;
5377: hr_utility.trace(' inserting into Sublines -102');
5378: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5379: X_ROWID => l_rowid,
5380: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5381: X_PAYROLL_LINE_ID => x_payroll_line_id,
5443: end if;
5444:
5445: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5446: FROM DUAL;
5447: hr_utility.trace(' inserting into Sublines -202');
5448: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5449: X_ROWID => l_rowid,
5450: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5451: X_PAYROLL_LINE_ID => x_payroll_line_id,
5507: end if;
5508:
5509: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5510: FROM DUAL;
5511: hr_utility.trace(' inserting into Sublines -302');
5512: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5513: X_ROWID => l_rowid,
5514: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5515: X_PAYROLL_LINE_ID => x_payroll_line_id,
5571: end if;
5572:
5573: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5574: FROM DUAL;
5575: hr_utility.trace(' inserting into Sublines -402');
5576: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5577: X_ROWID => l_rowid,
5578: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5579: X_PAYROLL_LINE_ID => x_payroll_line_id,
5637: end if;
5638: END LOOP;
5639: close get_assg_csr;
5640: x_return_status := FND_API.G_RET_STS_SUCCESS;
5641: hr_utility.trace(' Leaving CREATE_SLINE_JOB_CHANGE');
5642: EXCEPTION
5643: WHEN NO_DATA_FOUND then
5644: x_return_status := FND_API.G_RET_STS_SUCCESS;
5645: close get_assg_csr;
5704:
5705:
5706: begin
5707:
5708: hr_utility.trace(' Entering CREATE_SLINE_POSITION_CHANGE');
5709:
5710: open get_old_position_csr;
5711: fetch get_old_position_csr into l_effective_start_date, l_old_position_id;
5712: if get_old_position_csr%NOTFOUND then
5762: end if;
5763:
5764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5765: FROM DUAL;
5766: hr_utility.trace(' inserting into Sublines -502');
5767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5768: X_ROWID => l_rowid,
5769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5770: X_PAYROLL_LINE_ID => x_payroll_line_id,
5826: end if;
5827:
5828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5829: FROM DUAL;
5830: hr_utility.trace(' inserting into Sublines -502');
5831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5832: X_ROWID => l_rowid,
5833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5834: X_PAYROLL_LINE_ID => x_payroll_line_id,
5899: end if;
5900:
5901: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5902: FROM DUAL;
5903: hr_utility.trace(' inserting into Sublines -702');
5904: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5905: X_ROWID => l_rowid,
5906: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5907: X_PAYROLL_LINE_ID => x_payroll_line_id,
5963: end if;
5964:
5965: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5966: FROM DUAL;
5967: hr_utility.trace(' inserting into Sublines -802');
5968: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5969: X_ROWID => l_rowid,
5970: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5971: X_PAYROLL_LINE_ID => x_payroll_line_id,
6033: end if;
6034:
6035: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6036: FROM DUAL;
6037: hr_utility.trace(' inserting into Sublines -902');
6038: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6039: X_ROWID => l_rowid,
6040: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6041: X_PAYROLL_LINE_ID => x_payroll_line_id,
6097: end if;
6098:
6099: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6100: FROM DUAL;
6101: hr_utility.trace(' inserting into Sublines -802');
6102: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6103: X_ROWID => l_rowid,
6104: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6105: X_PAYROLL_LINE_ID => x_payroll_line_id,
6161: end if;
6162:
6163: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6164: FROM DUAL;
6165: hr_utility.trace(' inserting into Sublines -1002');
6166: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6167: X_ROWID => l_rowid,
6168: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6169: X_PAYROLL_LINE_ID => x_payroll_line_id,
6227: end if;
6228: END LOOP;
6229: close get_assg_csr;
6230: x_return_status := FND_API.G_RET_STS_SUCCESS;
6231: hr_utility.trace(' Leaving CREATE_SLINE_POSITION_CHANGE');
6232: EXCEPTION
6233: WHEN NO_DATA_FOUND then
6234: x_return_status := FND_API.G_RET_STS_SUCCESS;
6235: close get_assg_csr;
6296: l_no_of_days number(3) := 0;
6297:
6298:
6299: begin
6300: hr_utility.trace(' Entering CREATE_SLINE_GRADE_CHANGE');
6301: open get_old_grade_csr;
6302: fetch get_old_grade_csr into l_effective_start_date, l_old_grade_id;
6303: if get_old_grade_csr%NOTFOUND then
6304: l_old_grade_id := 0;
6353: end if;
6354:
6355: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6356: FROM DUAL;
6357: hr_utility.trace(' inserting into Sublines -2002');
6358: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6359: X_ROWID => l_rowid,
6360: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6361: X_PAYROLL_LINE_ID => x_payroll_line_id,
6417: end if;
6418:
6419: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6420: FROM DUAL;
6421: hr_utility.trace(' inserting into Sublines -3002');
6422: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6423: X_ROWID => l_rowid,
6424: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6425: X_PAYROLL_LINE_ID => x_payroll_line_id,
6490: end if;
6491:
6492: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6493: FROM DUAL;
6494: hr_utility.trace(' inserting into Sublines -4002');
6495: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6496: X_ROWID => l_rowid,
6497: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6498: X_PAYROLL_LINE_ID => x_payroll_line_id,
6554: end if;
6555:
6556: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6557: FROM DUAL;
6558: hr_utility.trace(' inserting into Sublines -5002');
6559: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6560: X_ROWID => l_rowid,
6561: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6562: X_PAYROLL_LINE_ID => x_payroll_line_id,
6624: end if;
6625:
6626: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6627: FROM DUAL;
6628: hr_utility.trace(' inserting into Sublines -6002');
6629: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6630: X_ROWID => l_rowid,
6631: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6632: X_PAYROLL_LINE_ID => x_payroll_line_id,
6688: end if;
6689:
6690: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6691: FROM DUAL;
6692: hr_utility.trace(' inserting into Sublines -7002');
6693: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6694: X_ROWID => l_rowid,
6695: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6696: X_PAYROLL_LINE_ID => x_payroll_line_id,
6752: end if;
6753:
6754: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6755: FROM DUAL;
6756: hr_utility.trace(' inserting into Sublines -8002');
6757: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6758: X_ROWID => l_rowid,
6759: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6760: X_PAYROLL_LINE_ID => x_payroll_line_id,
6805: l_old_grade_id := l_new_grade_id;
6806: END LOOP;
6807: close get_sublines_csr;
6808: x_return_status := FND_API.G_RET_STS_SUCCESS;
6809: hr_utility.trace(' Leaving CREATE_SLINE_GRADE_CHANGE');
6810: EXCEPTION
6811: WHEN NO_DATA_FOUND then
6812: x_return_status := FND_API.G_RET_STS_SUCCESS;
6813: close get_sublines_csr;
6891: l_no_of_days number(3) := 0;
6892:
6893:
6894: begin
6895: hr_utility.trace(' Entering CREATE_SLINE_PPGROUP_CHANGE');
6896: open get_old_ppgroup_csr;
6897: fetch get_old_ppgroup_csr into l_effective_start_date, l_old_ppgroup_id;
6898: if get_old_ppgroup_csr%NOTFOUND then
6899: l_old_ppgroup_id := 0;
6948: end if;
6949:
6950: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6951: FROM DUAL;
6952: hr_utility.trace(' inserting into Sublines -9002');
6953: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6954: X_ROWID => l_rowid,
6955: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6956: X_PAYROLL_LINE_ID => x_payroll_line_id,
7012: end if;
7013:
7014: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7015: FROM DUAL;
7016: hr_utility.trace(' inserting into Sublines -2Y');
7017: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7018: X_ROWID => l_rowid,
7019: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7020: X_PAYROLL_LINE_ID => x_payroll_line_id,
7085: end if;
7086:
7087: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7088: FROM DUAL;
7089: hr_utility.trace(' inserting into Sublines -2OX');
7090: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7091: X_ROWID => l_rowid,
7092: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7093: X_PAYROLL_LINE_ID => x_payroll_line_id,
7149: end if;
7150:
7151: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7152: FROM DUAL;
7153: hr_utility.trace(' inserting into Sublines -2LXL');
7154: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7155: X_ROWID => l_rowid,
7156: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7157: X_PAYROLL_LINE_ID => x_payroll_line_id,
7219: end if;
7220:
7221: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7222: FROM DUAL;
7223: hr_utility.trace(' inserting into Sublines -2UIORA');
7224: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7225: X_ROWID => l_rowid,
7226: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7227: X_PAYROLL_LINE_ID => x_payroll_line_id,
7283: end if;
7284:
7285: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7286: FROM DUAL;
7287: hr_utility.trace(' inserting into Sublines -2JADF');
7288: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7289: X_ROWID => l_rowid,
7290: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7291: X_PAYROLL_LINE_ID => x_payroll_line_id,
7347: end if;
7348:
7349: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7350: FROM DUAL;
7351: hr_utility.trace(' inserting into Sublines -299ek');
7352: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7353: X_ROWID => l_rowid,
7354: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7355: X_PAYROLL_LINE_ID => x_payroll_line_id,
7413: end if;
7414: END LOOP;
7415: close get_assg_csr;
7416: x_return_status := FND_API.G_RET_STS_SUCCESS;
7417: hr_utility.trace(' Leaving CREATE_SLINE_PPGROUP_CHANGE');
7418: EXCEPTION
7419: WHEN NO_DATA_FOUND then
7420: x_return_status := FND_API.G_RET_STS_SUCCESS;
7421: close get_assg_csr;
7471: l_new_fte_temp VARCHAR2(150); -- new added for Bug 2023920
7472: l_old_fte_temp VARCHAR2(150); -- new added for Bug 2023920
7473:
7474: begin
7475: hr_utility.trace(' Entering CREATE_SLINE_FTE_CHANGE');
7476: -- l_fte_option_value := FND_PROFILE.VALue('PSP_FTE_OPTIONS');
7477: l_fte_option_value :=psp_general.get_specific_profile('PSP_FTE_OPTIONS');
7478: if NVL(l_fte_option_value,' ') = 'BUDGET_VALUES' or l_fte_option_value IS NULL then
7479: x_return_status := FND_API.G_RET_STS_SUCCESS;
7627: end if;
7628:
7629: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7630: FROM DUAL;
7631: hr_utility.trace(' inserting into Sublines -2kdfd');
7632: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7633: X_ROWID => l_rowid,
7634: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7635: X_PAYROLL_LINE_ID => x_payroll_line_id,
7691: end if;
7692:
7693: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7694: FROM DUAL;
7695: hr_utility.trace(' inserting into Sublines -2LKJL:JL');
7696: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7697: X_ROWID => l_rowid,
7698: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7699: X_PAYROLL_LINE_ID => x_payroll_line_id,
7762: end if;
7763:
7764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7765: FROM DUAL;
7766: hr_utility.trace(' inserting into Sublines -2UUUUUUAA');
7767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7768: X_ROWID => l_rowid,
7769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7770: X_PAYROLL_LINE_ID => x_payroll_line_id,
7826: end if;
7827:
7828: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id
7829: FROM DUAL;
7830: hr_utility.trace(' inserting into Sublines -2KKKKK');
7831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7832: X_ROWID => l_rowid,
7833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7834: X_PAYROLL_LINE_ID => x_payroll_line_id,
7896: end if;
7897:
7898: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7899: FROM DUAL;
7900: hr_utility.trace(' inserting into Sublines -2OOOPP888');
7901: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7902: X_ROWID => l_rowid,
7903: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7904: X_PAYROLL_LINE_ID => x_payroll_line_id,
7960: end if;
7961:
7962: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7963: FROM DUAL;
7964: hr_utility.trace(' inserting into Sublines -27777MMMN');
7965: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7966: X_ROWID => l_rowid,
7967: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7968: X_PAYROLL_LINE_ID => x_payroll_line_id,
8024: end if;
8025:
8026: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8027: FROM DUAL;
8028: hr_utility.trace(' inserting into Sublines -2EEEERRSS');
8029: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8030: X_ROWID => l_rowid,
8031: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8032: X_PAYROLL_LINE_ID => x_payroll_line_id,
8088:
8089: END LOOP;
8090: dbms_sql.close_cursor(l_cur_handle);
8091: x_return_status := FND_API.G_RET_STS_SUCCESS;
8092: hr_utility.trace(' Leaving CREATE_SLINE_FTE_CHANGE');
8093: EXCEPTION
8094: WHEN OTHERS then
8095: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');
8096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8173: return;
8174: end if;
8175: */
8176:
8177: hr_utility.trace(' Entering CREATE_SLINE_BUDGET_CHANGE');
8178: open get_old_budget_csr;
8179: fetch get_old_budget_csr into l_effective_start_date, l_old_value;
8180: if get_old_budget_csr%NOTFOUND then
8181: l_old_value := 0;
8230: end if;
8231:
8232: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8233: FROM DUAL;
8234: hr_utility.trace(' inserting into Sublines -2WWWEEERR');
8235: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8236: X_ROWID => l_rowid,
8237: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8238: X_PAYROLL_LINE_ID => x_payroll_line_id,
8294: end if;
8295:
8296: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8297: FROM DUAL;
8298: hr_utility.trace(' inserting into Sublines -29999*****888');
8299: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8300: X_ROWID => l_rowid,
8301: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8302: X_PAYROLL_LINE_ID => x_payroll_line_id,
8367: end if;
8368:
8369: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8370: FROM DUAL;
8371: hr_utility.trace(' inserting into Sublines -2DDDDDD');
8372: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8373: X_ROWID => l_rowid,
8374: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8375: X_PAYROLL_LINE_ID => x_payroll_line_id,
8431: end if;
8432:
8433: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8434: FROM DUAL;
8435: hr_utility.trace(' inserting into Sublines -2UKOSO');
8436: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8437: X_ROWID => l_rowid,
8438: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8439: X_PAYROLL_LINE_ID => x_payroll_line_id,
8501: end if;
8502:
8503: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8504: FROM DUAL;
8505: hr_utility.trace(' inserting into Sublines -2JYUPA');
8506: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8507: X_ROWID => l_rowid,
8508: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8509: X_PAYROLL_LINE_ID => x_payroll_line_id,
8565: end if;
8566:
8567: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8568: FROM DUAL;
8569: hr_utility.trace(' inserting into Sublines -2NBMM');
8570: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8571: X_ROWID => l_rowid,
8572: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8573: X_PAYROLL_LINE_ID => x_payroll_line_id,
8629: end if;
8630:
8631: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8632: FROM DUAL;
8633: hr_utility.trace(' inserting into Sublines -2TOPP');
8634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8635: X_ROWID => l_rowid,
8636: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8637: X_PAYROLL_LINE_ID => x_payroll_line_id,
8695: end if;
8696: END LOOP;
8697: close get_assg_csr;
8698: x_return_status := FND_API.G_RET_STS_SUCCESS;
8699: hr_utility.trace(' Leaving CREATE_SLINE_BUDGET_CHANGE');
8700: EXCEPTION
8701: WHEN NO_DATA_FOUND then
8702: x_return_status := FND_API.G_RET_STS_SUCCESS;
8703: close get_assg_csr;
8746: AND payroll_id = l_payroll_id; ---3922347
8747:
8748: BEGIN
8749:
8750: hr_utility.trace(' Entering CHECK_ZERO_WORK_DAYS');
8751: hr_utility.trace(' zero work days check asg, g_no_of_person_workdays= '||x_assignment_id||','||g_no_of_person_work_days);
8752: IF g_no_of_person_work_days <= 0 then
8753:
8754: /* The following code is added for the enhancement Zero Work days .This code addition will identify the
8747:
8748: BEGIN
8749:
8750: hr_utility.trace(' Entering CHECK_ZERO_WORK_DAYS');
8751: hr_utility.trace(' zero work days check asg, g_no_of_person_workdays= '||x_assignment_id||','||g_no_of_person_work_days);
8752: IF g_no_of_person_work_days <= 0 then
8753:
8754: /* The following code is added for the enhancement Zero Work days .This code addition will identify the
8755: non active assignments and assignments which have started on the last day of payroll , which is a non working day
8759: FETCH non_active_asg_csr INTO l_count_asg_active;
8760: CLOSE non_active_asg_csr;
8761:
8762: IF l_count_asg_active > 0 THEN
8763: hr_utility.trace(' assignment_id l_count_asg_active > 0 asg = '||x_assignment_id);
8764: g_non_active_flag := 'Y';
8765: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8766: return;
8767: END IF;
8773: /*Bug 5557724: to_char(some_date,'D') returns a number indicating the weekday. However, for a given date, this number
8774: returned varies with NLS_TERRITORY. So replaced it with to_char(some_date,'DY') that gives the abbreviated day. */
8775: -- IF to_char(l_effective_start_date,'DY', 'nls_date_language=english') IN ('SUN','SAT') THEN
8776: IF (psp_general.business_days(l_effective_start_date, l_effective_start_date, x_assignment_id) = 0) THEN
8777: hr_utility.trace(' assignment starts in non working day = '||x_assignment_id);
8778: g_hire_zero_work_days := 'Y';
8779: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8780: return;
8781: END IF;
8791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8792: END IF;
8793: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8794:
8795: hr_utility.trace(' Leaving CHECK_ZERO_WORK_DAYS');
8796:
8797: EXCEPTION
8798: WHEN OTHERS then
8799: ------dbms_output.put_line('Check_zero_work_days.....'||x_assignment_id||' '||x_costed_value);
8848: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;
8849: l_tp_end_date per_time_periods.end_date%TYPE; -- BUG 6886237
8850: BEGIN
8851:
8852: hr_utility.trace(' Entering CREATE_SLINE_TERM_EMP');
8853: OPEN get_payroll_line_csr;
8854: FETCH get_payroll_line_csr INTO g_payroll_line_rec;
8855: CLOSE get_payroll_line_csr;
8856:
8864: where payroll_line_id = x_payroll_line_id));
8865:
8866: -- Inserting into PSP_SUB_LINES
8867: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
8868: hr_utility.trace(' inserting into Sublines -2UISISI');
8869: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8870: X_ROWID => l_rowid,
8871: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8872: X_PAYROLL_LINE_ID => x_payroll_line_id,
8911: X_PARENT_LINE_ID => l_sub_line_id,
8912: X_MODE => 'R');
8913: x_return_status := FND_API.G_RET_STS_SUCCESS;
8914:
8915: hr_utility.trace(' Leaving CREATE_SLINE_TERM_EMP');
8916:
8917: EXCEPTION
8918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8919: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8956: l_temp_start_date DATE;
8957: l_temp_end_date DATE;
8958:
8959: BEGIN
8960: hr_utility.trace(' Entering Create Prorate Calendar st_dt, end_dt, pay_amnt, payroll_line_id, balnce_amt ='||
8961: p_start_date ||','|| p_end_date||','|| p_pay_amount||','|| p_payroll_line_id ||','|| p_balance_amount);
8962: hr_utility.trace(' g_st_dt, g_end_dt =' ||g_start_date ||','|| g_end_date);
8963: l_non_working_day_flag := 0;
8964: l_start_date := p_start_date;
8958:
8959: BEGIN
8960: hr_utility.trace(' Entering Create Prorate Calendar st_dt, end_dt, pay_amnt, payroll_line_id, balnce_amt ='||
8961: p_start_date ||','|| p_end_date||','|| p_pay_amount||','|| p_payroll_line_id ||','|| p_balance_amount);
8962: hr_utility.trace(' g_st_dt, g_end_dt =' ||g_start_date ||','|| g_end_date);
8963: l_non_working_day_flag := 0;
8964: l_start_date := p_start_date;
8965: l_end_date := p_end_date;
8966:
8972: IF (i < 1) THEN
8973: i := 1;
8974: l_start_date := g_start_date;
8975: END IF;
8976: hr_utility.trace(' l_st_dt, l_end_dt =' ||l_start_date ||','|| l_end_date);
8977: l_business_days := psp_general.business_days(l_start_date, l_end_date);
8978: hr_utility.trace(' l_business_days , g_no_of_days='|| l_business_days||','||g_no_of_days);
8979:
8980: IF (l_business_days = 0) THEN
8974: l_start_date := g_start_date;
8975: END IF;
8976: hr_utility.trace(' l_st_dt, l_end_dt =' ||l_start_date ||','|| l_end_date);
8977: l_business_days := psp_general.business_days(l_start_date, l_end_date);
8978: hr_utility.trace(' l_business_days , g_no_of_days='|| l_business_days||','||g_no_of_days);
8979:
8980: IF (l_business_days = 0) THEN
8981: l_non_working_day_flag := 1;
8982: l_business_days := 1;
8985: j := i;
8986:
8987: WHILE (j <= g_no_of_days)
8988: LOOP
8989: hr_utility.trace(' daily rate 0.0 for j=' ||j);
8990: daily_calendar(j) := 0.00;
8991: j := j + 1;
8992: END LOOP;
8993:
8993:
8994: l_daily_rate := 0.00;
8995: IF (NVL(p_pay_amount, 0) <> 0.00) THEN
8996: l_daily_rate := p_pay_amount;
8997: hr_utility.trace(' p_pay_amount, l_daily_rate=' ||l_daily_rate);
8998: IF (l_non_working_day_flag = 0) THEN
8999: l_daily_rate := ROUND((p_pay_amount / l_business_days), g_ext_precision);
9000: hr_utility.trace(' l_non_working_day_flag = 0 , l_daily_rate=' ||l_daily_rate);
9001: END IF;
8996: l_daily_rate := p_pay_amount;
8997: hr_utility.trace(' p_pay_amount, l_daily_rate=' ||l_daily_rate);
8998: IF (l_non_working_day_flag = 0) THEN
8999: l_daily_rate := ROUND((p_pay_amount / l_business_days), g_ext_precision);
9000: hr_utility.trace(' l_non_working_day_flag = 0 , l_daily_rate=' ||l_daily_rate);
9001: END IF;
9002: END IF;
9003:
9004: l_total_salary := 0.00;
9029: l_end_date := l_start_date;
9030: end if;
9031:
9032: l_final_daily_rate := l_daily_rate;
9033: hr_utility.trace(' l_total__salary = '||l_total_salary);
9034: l_final_salary := ROUND(l_total_salary, g_precision);
9035: hr_utility.trace(' l_final_salary = '||l_final_salary);
9036: l_balance_amount :=0.0;
9037:
9031:
9032: l_final_daily_rate := l_daily_rate;
9033: hr_utility.trace(' l_total__salary = '||l_total_salary);
9034: l_final_salary := ROUND(l_total_salary, g_precision);
9035: hr_utility.trace(' l_final_salary = '||l_final_salary);
9036: l_balance_amount :=0.0;
9037:
9038:
9039: IF l_final_salary <> ROUND(p_pay_amount, g_precision) THEN
9037:
9038:
9039: IF l_final_salary <> ROUND(p_pay_amount, g_precision) THEN
9040: l_balance_amount := p_pay_amount - l_final_salary;
9041: hr_utility.trace(' l_balance_amount = '||l_balance_amount);
9042: l_daily_balance := ROUND((l_balance_amount / l_business_days), g_ext_precision);
9043: hr_utility.trace(' l_daily_balance = '||l_daily_balance);
9044: l_final_daily_rate := l_final_daily_rate + l_daily_balance;
9045: hr_utility.trace(' l_finally_daily_rate 2= '||l_final_daily_rate);
9039: IF l_final_salary <> ROUND(p_pay_amount, g_precision) THEN
9040: l_balance_amount := p_pay_amount - l_final_salary;
9041: hr_utility.trace(' l_balance_amount = '||l_balance_amount);
9042: l_daily_balance := ROUND((l_balance_amount / l_business_days), g_ext_precision);
9043: hr_utility.trace(' l_daily_balance = '||l_daily_balance);
9044: l_final_daily_rate := l_final_daily_rate + l_daily_balance;
9045: hr_utility.trace(' l_finally_daily_rate 2= '||l_final_daily_rate);
9046: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9047: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9041: hr_utility.trace(' l_balance_amount = '||l_balance_amount);
9042: l_daily_balance := ROUND((l_balance_amount / l_business_days), g_ext_precision);
9043: hr_utility.trace(' l_daily_balance = '||l_daily_balance);
9044: l_final_daily_rate := l_final_daily_rate + l_daily_balance;
9045: hr_utility.trace(' l_finally_daily_rate 2= '||l_final_daily_rate);
9046: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9047: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9048: END IF;
9049:
9043: hr_utility.trace(' l_daily_balance = '||l_daily_balance);
9044: l_final_daily_rate := l_final_daily_rate + l_daily_balance;
9045: hr_utility.trace(' l_finally_daily_rate 2= '||l_final_daily_rate);
9046: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9047: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9048: END IF;
9049:
9050: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9051:
9048: END IF;
9049:
9050: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9051:
9052: hr_utility.trace(' inserting into Sublines -2LLLLLLLALALAL');
9053: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
9054: (X_ROWID => l_rowid,
9055: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
9056: X_PAYROLL_LINE_ID => p_payroll_line_id,
9096: X_MODE => 'R');
9097:
9098: p_balance_amount :=l_balance_amount;
9099: p_return_status := FND_API.G_RET_STS_SUCCESS;
9100: hr_utility.trace(' Leaving CREATE PRORATE CALENDAR');
9101: EXCEPTION
9102: WHEN fnd_api.g_exc_unexpected_error THEN
9103: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9104: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;