[Home] [Help]
601:
602: BEGIN
603:
604: FND_MSG_PUB.Initialize;
605: ---hr_utility.trace_on('Y','IMPORT-1');
606: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');
607: hr_utility.trace(' Entering IMPORT_PAYTRANS');
608:
609:
603:
604: FND_MSG_PUB.Initialize;
605: ---hr_utility.trace_on('Y','IMPORT-1');
606: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');
607: hr_utility.trace(' Entering IMPORT_PAYTRANS');
608:
609:
610: /*******************************************************************************************
611:
828:
829: open get_payroll_assig_actions_csr;
830:
831: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' **************************************************************');
832: hr_utility.trace(' **************************************************************');
833:
834: LOOP
835:
836: fetch get_payroll_assig_actions_csr into g_payroll_asg_rec;
857:
858: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_assigment_id, l_assignment_action_id, p_time_period_id = '||l_assignment_id||','||
859: l_assignment_action_id||','||p_time_period_id);
860:
861: hr_utility.trace('l_assignment_id = '||l_assignment_id);
862: hr_utility.trace('l_assignment_action_id = '||l_assignment_action_id);
863: hr_utility.trace('p_time_period_id = '||p_time_period_id);
864: hr_utility.trace('g_payroll_asg_rec.effective_date = '||g_payroll_asg_rec.effective_date);
865:
858: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_assigment_id, l_assignment_action_id, p_time_period_id = '||l_assignment_id||','||
859: l_assignment_action_id||','||p_time_period_id);
860:
861: hr_utility.trace('l_assignment_id = '||l_assignment_id);
862: hr_utility.trace('l_assignment_action_id = '||l_assignment_action_id);
863: hr_utility.trace('p_time_period_id = '||p_time_period_id);
864: hr_utility.trace('g_payroll_asg_rec.effective_date = '||g_payroll_asg_rec.effective_date);
865:
866: OPEN get_pay_costs_csr;
859: l_assignment_action_id||','||p_time_period_id);
860:
861: hr_utility.trace('l_assignment_id = '||l_assignment_id);
862: hr_utility.trace('l_assignment_action_id = '||l_assignment_action_id);
863: hr_utility.trace('p_time_period_id = '||p_time_period_id);
864: hr_utility.trace('g_payroll_asg_rec.effective_date = '||g_payroll_asg_rec.effective_date);
865:
866: OPEN get_pay_costs_csr;
867: FETCH get_pay_costs_csr into g_pay_costs_rec;
860:
861: hr_utility.trace('l_assignment_id = '||l_assignment_id);
862: hr_utility.trace('l_assignment_action_id = '||l_assignment_action_id);
863: hr_utility.trace('p_time_period_id = '||p_time_period_id);
864: hr_utility.trace('g_payroll_asg_rec.effective_date = '||g_payroll_asg_rec.effective_date);
865:
866: OPEN get_pay_costs_csr;
867: FETCH get_pay_costs_csr into g_pay_costs_rec;
868: IF get_pay_costs_csr%NOTFOUND then
865:
866: OPEN get_pay_costs_csr;
867: FETCH get_pay_costs_csr into g_pay_costs_rec;
868: IF get_pay_costs_csr%NOTFOUND then
869: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);
870: raise NO_COST_DATA_FOUND;
871: close get_pay_costs_csr;
872: END IF;
873: close get_pay_costs_csr;
874: l_prev_time_period_id := null;
875: l_prev_start_date := TO_DATE('1','j');
876: l_prev_end_date := TO_DATE('1','j');
877:
878: hr_utility.trace(' opening get_pay_costs_csr for l_assignment_action_id = '||l_assignment_action_id);
879:
880: OPEN get_pay_costs_csr;
881: LOOP --LOOP1 begin
882: BEGIN
882: BEGIN
883: fetch get_pay_costs_csr into g_pay_costs_rec;
884: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
885:
886: hr_utility.trace(' NEXT loop iteration');
887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
883: fetch get_pay_costs_csr into g_pay_costs_rec;
884: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
885:
886: hr_utility.trace(' NEXT loop iteration');
887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
884: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
885:
886: hr_utility.trace(' NEXT loop iteration');
887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
886: hr_utility.trace(' NEXT loop iteration');
887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');
907:
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');
907:
908:
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');
907:
908:
909: g_entry_date_earned := NULL;
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');
907:
908:
909: g_entry_date_earned := NULL;
910:
907:
908:
909: g_entry_date_earned := NULL;
910:
911: hr_utility.trace(' set to null - g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
912:
913: OPEN ee_date_earned_cur;
914: FETCH ee_date_earned_cur INTO g_effective_start_date, g_effective_end_date, g_entry_date_earned; -- LD Added
915: CLOSE ee_date_earned_cur;
913: OPEN ee_date_earned_cur;
914: FETCH ee_date_earned_cur INTO g_effective_start_date, g_effective_end_date, g_entry_date_earned; -- LD Added
915: CLOSE ee_date_earned_cur;
916:
917: hr_utility.trace(' after cursor g_effective_start_date: ' || to_char(g_effective_start_date,'DD-MON-YYYY'));
918: hr_utility.trace(' after cursor g_effective_end_date: ' || to_char(g_effective_end_date,'DD-MON-YYYY'));
919: hr_utility.trace(' after cursor g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
920: hr_utility.trace(' g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
921:
914: FETCH ee_date_earned_cur INTO g_effective_start_date, g_effective_end_date, g_entry_date_earned; -- LD Added
915: CLOSE ee_date_earned_cur;
916:
917: hr_utility.trace(' after cursor g_effective_start_date: ' || to_char(g_effective_start_date,'DD-MON-YYYY'));
918: hr_utility.trace(' after cursor g_effective_end_date: ' || to_char(g_effective_end_date,'DD-MON-YYYY'));
919: hr_utility.trace(' after cursor g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
920: hr_utility.trace(' g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
921:
922: /* Commented for bug 6046087
915: CLOSE ee_date_earned_cur;
916:
917: hr_utility.trace(' after cursor g_effective_start_date: ' || to_char(g_effective_start_date,'DD-MON-YYYY'));
918: hr_utility.trace(' after cursor g_effective_end_date: ' || to_char(g_effective_end_date,'DD-MON-YYYY'));
919: hr_utility.trace(' after cursor g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
920: hr_utility.trace(' g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
921:
922: /* Commented for bug 6046087
923: -- Bug 5642002: get the element date if available
916:
917: hr_utility.trace(' after cursor g_effective_start_date: ' || to_char(g_effective_start_date,'DD-MON-YYYY'));
918: hr_utility.trace(' after cursor g_effective_end_date: ' || to_char(g_effective_end_date,'DD-MON-YYYY'));
919: hr_utility.trace(' after cursor g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
920: hr_utility.trace(' g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
921:
922: /* Commented for bug 6046087
923: -- Bug 5642002: get the element date if available
924: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
929: IF (g_ignore_date_earned = 'Y') THEN
930: g_start_date := g_pay_costs_rec.tp_start_date;
931: g_end_date := g_pay_costs_rec.tp_end_date;
932:
933: hr_utility.trace('IF cost_id, start_Date,
934: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
935: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
936: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
937:
938: ELSE
939: -- Moved the following statement inside ELSE clause for bug 8993953 to avoid overrides
940: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);
941:
942: hr_utility.trace(' after nvl condition g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
943:
944: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
945: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
946:
943:
944: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
945: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
946:
947: hr_utility.trace('ELSE cost_id, start_Date,
948: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
949: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
950: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
951: END IF;
949: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
950: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
951: END IF;
952:
953: hr_utility.trace(' g_start_date ' || to_char(g_start_date,'DD-MON-YYYY'));
954: hr_utility.trace(' g_end_date ' || to_char(g_end_date,'DD-MON-YYYY'));
955:
956:
957: l_or_gl_ccid := NULL;
950: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
951: END IF;
952:
953: hr_utility.trace(' g_start_date ' || to_char(g_start_date,'DD-MON-YYYY'));
954: hr_utility.trace(' g_end_date ' || to_char(g_end_date,'DD-MON-YYYY'));
955:
956:
957: l_or_gl_ccid := NULL;
958: l_or_project_id := NULL;
971: 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
972: USING g_pay_costs_rec.date_earned;
973: EXCEPTION
974: WHEN OTHERS THEN
975: hr_utility.trace(' No Element Entry record found');
976: END;
977: ELSE
978: BEGIN
979: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
983: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
984: USING g_pay_costs_rec.date_earned;
985: EXCEPTION
986: WHEN OTHERS THEN
987: hr_utility.trace(' No Element Entry record found');
988: END;
989: END IF;
990: ELSIF (l_gl_column IS NOT NULL) THEN
991: BEGIN
995: INTO l_or_gl_ccid
996: USING g_pay_costs_rec.date_earned;
997: EXCEPTION
998: WHEN OTHERS THEN
999: hr_utility.trace(' No Element Entry record found');
1000: END;
1001: ELSIF (l_pt_column IS NOT NULL) THEN
1002: IF (l_aw_column IS NOT NULL) THEN
1003: BEGIN
1009: INTO l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
1010: USING g_pay_costs_rec.date_earned;
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: hr_utility.trace(' No Element Entry record found');
1014: END;
1015: ELSE
1016: BEGIN
1017: EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
1022: INTO l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
1023: USING g_pay_costs_rec.date_earned;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: hr_utility.trace(' No Element Entry record found');
1027: END;
1028: END IF;
1029: END IF;
1030:
1156: if g_pay_costs_rec.time_period_id <> nvl(l_prev_time_period_id, -1) OR
1157: g_start_date <> l_prev_start_date OR
1158: g_end_date <> l_prev_end_date
1159: then
1160: hr_utility.trace(' CHANGE IN TIME PERIOD ');
1161: l_prev_time_period_id := g_pay_costs_rec.time_period_id;
1162: l_prev_start_date := g_start_date;
1163: l_prev_end_date := g_end_date;
1164:
1174: -- This procedure looks into per_assignments_f for assignment
1175: -- end date. If the assignment end date falls in to the payroll period,
1176: -- it updates the array rows with 'N' for the rows after the assignment end date.
1177:
1178: hr_utility.trace(' UPDATE_WCAL_ASG_END_DATE');
1179: UPDATE_WCAL_ASG_END_DATE(X_ASSIGNMENT_ID => l_assignment_id,
1180: X_RETURN_STATUS => l_return_status);
1181: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1182: l_error_api_name := 'UPDATE_WCAL_ASG_END_DATE : ';
1182: l_error_api_name := 'UPDATE_WCAL_ASG_END_DATE : ';
1183: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1184: end if;
1185:
1186: hr_utility.trace(' UPDATE_WCAL_ASG_BEGIN_DATE');
1187: UPDATE_WCAL_ASG_BEGIN_DATE(X_ASSIGNMENT_ID => l_assignment_id,
1188: X_RETURN_STATUS => l_return_status);
1189: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1190: l_error_api_name := 'UPDATE_WCAL_ASG_BEGIN_DATE : ';
1194: -- This procedure looks into per_assignments_f for assignment
1195: -- status. If the assignment status is 'Suspend' or 'Terminate' for any of the days
1196: -- in the payroll period, it updates the working calendar array with 'N' for those days.
1197:
1198: hr_utility.trace(' UPDATE_WCAL_ASG_STATUS');
1199: UPDATE_WCAL_ASG_STATUS(X_ASSIGNMENT_ID => l_assignment_id,
1200: X_RETURN_STATUS => l_return_status);
1201: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1202: l_error_api_name := 'UPDATE_WCAL_ASG_STATUS : ';
1201: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1202: l_error_api_name := 'UPDATE_WCAL_ASG_STATUS : ';
1203: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1204: end if;
1205: hr_utility.trace(' AFTER UPDATE_WCAL_ASG_STATUS');
1206: begin
1207: l_export_id := null;
1208:
1209: for i in 1..time_period_id_a.count
1207: l_export_id := null;
1208:
1209: for i in 1..time_period_id_a.count
1210: loop
1211: hr_utility.trace(' KKKK='||i);
1212: if (g_pay_costs_rec.time_period_id = time_period_id_a(i)
1213: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271
1214: then
1215: hr_utility.trace(' KXyy='||i);
1211: hr_utility.trace(' KKKK='||i);
1212: if (g_pay_costs_rec.time_period_id = time_period_id_a(i)
1213: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271
1214: then
1215: hr_utility.trace(' KXyy='||i);
1216: l_export_id := payroll_control_id_a(i);
1217: hr_utility.trace(' KXzy='||i);
1218: end if;
1219: end loop;
1213: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271
1214: then
1215: hr_utility.trace(' KXyy='||i);
1216: l_export_id := payroll_control_id_a(i);
1217: hr_utility.trace(' KXzy='||i);
1218: end if;
1219: end loop;
1220:
1221: exception
1220:
1221: exception
1222: when others then
1223: l_period_name := sqlerrm;
1224: hr_utility.trace(' KKKK'||l_period_name);
1225:
1226:
1227: end;
1228: hr_utility.trace(' AFTER SET l_export_id');
1224: hr_utility.trace(' KKKK'||l_period_name);
1225:
1226:
1227: end;
1228: hr_utility.trace(' AFTER SET l_export_id');
1229: end if;
1230:
1231: hr_utility.trace(' Found cost record Cost_id, costed_value =' ||g_pay_costs_rec.cost_id||','||g_pay_costs_rec.costed_value);
1232: -- Bug 1994421 : Zero Work Days Build - Assigned values to variables for processing non active assignments -lveerubh
1227: end;
1228: hr_utility.trace(' AFTER SET l_export_id');
1229: end if;
1230:
1231: hr_utility.trace(' Found cost record Cost_id, costed_value =' ||g_pay_costs_rec.cost_id||','||g_pay_costs_rec.costed_value);
1232: -- Bug 1994421 : Zero Work Days Build - Assigned values to variables for processing non active assignments -lveerubh
1233: g_non_active_flag := 'N';
1234: g_hire_zero_Work_days := 'N';
1235: g_all_holiday_zero_work_days := 'N';
1247: RAISE ZERO_WORK_DAYS;
1248: end if;
1249: /*END IF;*/
1250:
1251: hr_utility.trace(' Before opening check_payroll_lines_csr');
1252: OPEN check_payroll_lines_csr;
1253: FETCH check_payroll_lines_csr into l_cost_id;
1254:
1255: hr_utility.trace(' After check_payroll_lines_csr - l_cost_id = '||l_cost_id);
1251: hr_utility.trace(' Before opening check_payroll_lines_csr');
1252: OPEN check_payroll_lines_csr;
1253: FETCH check_payroll_lines_csr into l_cost_id;
1254:
1255: hr_utility.trace(' After check_payroll_lines_csr - l_cost_id = '||l_cost_id);
1256:
1257: IF check_payroll_lines_csr%NOTFOUND then
1258:
1259: hr_utility.trace(' check_payroll_lines_csr%NOTFOUND');
1255: hr_utility.trace(' After check_payroll_lines_csr - l_cost_id = '||l_cost_id);
1256:
1257: IF check_payroll_lines_csr%NOTFOUND then
1258:
1259: hr_utility.trace(' check_payroll_lines_csr%NOTFOUND');
1260:
1261: l_counter := l_counter + 1;
1262:
1263: ---hr_utility.trace(' No data found in payroll_lines ');
1259: hr_utility.trace(' check_payroll_lines_csr%NOTFOUND');
1260:
1261: l_counter := l_counter + 1;
1262:
1263: ---hr_utility.trace(' No data found in payroll_lines ');
1264: -- If first record insert a record in psp_payroll_controls
1265:
1266:
1267: hr_utility.trace(' l_counter = '||l_counter);
1263: ---hr_utility.trace(' No data found in payroll_lines ');
1264: -- If first record insert a record in psp_payroll_controls
1265:
1266:
1267: hr_utility.trace(' l_counter = '||l_counter);
1268: IF l_counter > 0 then
1269: -- Introduced for bug fix 2916848
1270:
1271: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||
1267: hr_utility.trace(' l_counter = '||l_counter);
1268: IF l_counter > 0 then
1269: -- Introduced for bug fix 2916848
1270:
1271: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||
1272: g_pay_costs_rec.output_currency_code);
1273: -- Commented this if condition for bug 9435225
1274: -- IF nvl(l_prev_currency_code,g_pay_costs_rec.output_currency_code) <> g_pay_costs_rec.output_currency_code THEN
1275: l_prev_currency_code := g_pay_costs_rec.output_currency_code;
1406: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1407: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1408: fnd_message.set_token('CLEARING', l_clearing_account_value);
1409: fnd_msg_pub.add;
1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;
1413: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1414:
1409: fnd_msg_pub.add;
1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;
1413: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1414:
1415: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id
1416: FROM DUAL;
1417: x_rowid := NULL;
1417: x_rowid := NULL;
1418:
1419: -- intro this IF-ENDIF and changed the next IF stmt to check gms_posting_date for 2426343
1420:
1421: hr_utility.trace('g_non_active_flag = '||g_non_active_flag);
1422: If g_non_active_flag = 'Y' then
1423: -- date earned will be the max date any child sub line can take as effective date.
1424:
1425: l_gms_posting_date := g_pay_costs_rec.date_earned;
1422: If g_non_active_flag = 'Y' then
1423: -- date earned will be the max date any child sub line can take as effective date.
1424:
1425: l_gms_posting_date := g_pay_costs_rec.date_earned;
1426: hr_utility.trace('l_gms_posting_date = '||l_gms_posting_date);
1427:
1428: psp_general.get_gms_effective_date(l_person_id, l_gms_posting_date);
1429: hr_utility.trace('After proc call - l_gms_posting_date = '||l_gms_posting_date);
1430:
1425: l_gms_posting_date := g_pay_costs_rec.date_earned;
1426: hr_utility.trace('l_gms_posting_date = '||l_gms_posting_date);
1427:
1428: psp_general.get_gms_effective_date(l_person_id, l_gms_posting_date);
1429: hr_utility.trace('After proc call - l_gms_posting_date = '||l_gms_posting_date);
1430:
1431: IF l_gms_posting_date is null then
1432:
1433: hr_utility.trace('l_gms_posting_date is null');
1429: hr_utility.trace('After proc call - l_gms_posting_date = '||l_gms_posting_date);
1430:
1431: IF l_gms_posting_date is null then
1432:
1433: hr_utility.trace('l_gms_posting_date is null');
1434:
1435: hr_utility.trace('l_person_id = '||l_person_id);
1436: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
1437:
1431: IF l_gms_posting_date is null then
1432:
1433: hr_utility.trace('l_gms_posting_date is null');
1434:
1435: hr_utility.trace('l_person_id = '||l_person_id);
1436: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
1437:
1438: hr_utility.trace('I might fail now');
1439:
1432:
1433: hr_utility.trace('l_gms_posting_date is null');
1434:
1435: hr_utility.trace('l_person_id = '||l_person_id);
1436: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
1437:
1438: hr_utility.trace('I might fail now');
1439:
1440: select distinct substr(full_name,1,50)
1434:
1435: hr_utility.trace('l_person_id = '||l_person_id);
1436: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
1437:
1438: hr_utility.trace('I might fail now');
1439:
1440: select distinct substr(full_name,1,50)
1441: into l_employee_name
1442: from per_people_f
1442: from per_people_f
1443: where person_id = l_person_id and
1444: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;
1445:
1446: hr_utility.trace('Am i successful');
1447:
1448: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');
1449: FND_MESSAGE.set_token('Employee',l_employee_name);
1450: FND_MSG_PUB.ADD;
1451: g_non_active_flag := 'E'; --ERROR, skip this assg, bcos not a single day it is active
1452: END IF;
1453: END IF;
1454:
1455: hr_utility.trace('-pass 10');
1456:
1457: /* For Bug 1994421 - Zero Work Days Build :
1458: To process the non active assignments the new procedure Create_sline_term_employee is called
1459: A assignment is non active if the g_non_active_flag or g_hire_zero_work_days are 'Y'
1463: IF g_non_active_flag = 'Y' OR g_hire_zero_work_days = 'Y' OR g_all_holiday_zero_work_days = 'Y' THEN
1464:
1465: --Insert a single line into psp_payroll_lines
1466:
1467: hr_utility.trace('-pass 20');
1468:
1469: PSP_PAYROLL_LINES_PKG.INSERT_ROW (
1470: X_ROWID => x_rowid,
1471: X_PAYROLL_LINE_ID => l_line_id ,
1495: X_OR_EXPENDITURE_ORG_ID => l_or_expenditure_org_id,
1496: X_OR_EXPENDITURE_TYPE => l_or_expenditure_type);
1497:
1498: -- The following code is required as psp_payroll_controls will be updated with the total debit and credit amount
1499: hr_utility.trace('-pass 30');
1500:
1501: IF g_pay_costs_rec.debit_or_credit = 'D' then
1502: r_payroll_control_array.r_tot_dr(l_cur_rec)
1503: := r_payroll_control_array.r_tot_dr(l_cur_rec) +1;
1513: r_payroll_control_array.r_cr_amount(l_cur_rec) + g_pay_costs_rec.costed_value;
1514:
1515: END IF;
1516:
1517: hr_utility.trace('-pass 40');
1518:
1519: -- write single sub-line in PSP_PAYROLL_SUB_LINES
1520:
1521: IF g_non_active_flag = 'Y' THEN
1537:
1538: ELSE
1539: ---End of changes made for Non active assignments: Done as part of Bug 1994421 -Zero Work Days Build -lveerubh
1540:
1541: hr_utility.trace('-pass 50');
1542:
1543: PSP_PAYROLL_LINES_PKG.INSERT_ROW (
1544: X_ROWID => x_rowid,
1545: X_PAYROLL_LINE_ID => l_line_id ,
1572: -- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date IS NULL) THEN -- Introduced for bug fix 2916848
1573:
1574: ---IF g_pay_costs_rec.start_date IS NULL THEN ... commented for 4897071
1575:
1576: hr_utility.trace('-pass 60');
1577:
1578: CREATE_DAILY_RATE_CALENDAR(
1579: X_ASSIGNMENT_ID => l_assignment_id,
1580: X_time_period_id => p_time_period_id,
1808: l_error_api_name := 'CREATE_SLINE_BUDGET_CHANGE : ';
1809: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1810: end if;
1811:
1812: hr_utility.trace(' Opening get_difference_csr cursor');
1813:
1814: -- Insert rounding routine here
1815: open get_difference_csr;
1816: fetch get_difference_csr into l_subline_sum;
1863:
1864: return;
1865: WHEN NO_COST_DATA_FOUND then
1866: close get_pay_costs_csr;
1867: hr_utility.trace('-exception 10- sqlerrm = '||sqlerrm);
1868:
1869: IF check_payroll_lines_csr%ISOPEN THEN
1870: hr_utility.trace('-exception 10- close check_payroll_lines_csr');
1871: close check_payroll_lines_csr;
1866: close get_pay_costs_csr;
1867: hr_utility.trace('-exception 10- sqlerrm = '||sqlerrm);
1868:
1869: IF check_payroll_lines_csr%ISOPEN THEN
1870: hr_utility.trace('-exception 10- close check_payroll_lines_csr');
1871: close check_payroll_lines_csr;
1872: END IF;
1873:
1874: select distinct substr(full_name,1,50) into l_employee_name from per_people_f
1881:
1882: sysdate between effective_start_date and effective_end_date;
1883: */
1884:
1885: hr_utility.trace('-inside exception 10-');
1886:
1887: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_COSTING_EMP');
1888: FND_MESSAGE.set_token('Employee',l_employee_name);
1889: FND_MSG_PUB.ADD;
1894: retcode := 2;
1895:
1896: rollback;
1897:
1898: hr_utility.trace(' Process failed here');
1899: hr_utility.trace('-exception 20- sqlerrm = '||sqlerrm);
1900:
1901: psp_message_s.print_error(p_mode=>FND_FILE.log,
1902: p_print_header=>FND_API.G_TRUE
1895:
1896: rollback;
1897:
1898: hr_utility.trace(' Process failed here');
1899: hr_utility.trace('-exception 20- sqlerrm = '||sqlerrm);
1900:
1901: psp_message_s.print_error(p_mode=>FND_FILE.log,
1902: p_print_header=>FND_API.G_TRUE
1903: );
1913: payroll_control_id_a.delete;
1914: time_period_id_a.delete;
1915: currency_code_a.delete; -- Bug 6468271
1916:
1917: hr_utility.trace(' Finally Updating psp_payroll_controls');
1918:
1919: FORALL k in 1 .. l_total_num_rec
1920: UPDATE psp_payroll_controls
1921: set number_of_cr = r_payroll_Control_array.r_tot_cr(k),
1988: fnd_file.put_line(fnd_file.log, '');
1989:
1990: l_count := 0;
1991: l_heading := null;
1992: hr_utility.trace(' before get_import_summary_heading');
1993: fnd_file.put_line(fnd_file.log, ' ');
1994: fnd_file.put_line(fnd_file.log, ' ');
1995: fnd_file.put_line(fnd_file.log, ' ');
1996: open get_import_summary_heading;
2040: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
2041: fnd_file.put_line(fnd_file.log, '');
2042: fnd_file.put_line(fnd_file.log, '');
2043: fnd_file.put_line(fnd_file.log, '');
2044: hr_utility.trace(' Leaving IMPORT_PAYTRANS');
2045:
2046: EXCEPTION
2047: WHEN NO_DATA_FOUND then
2048: close get_payroll_assig_actions_csr;
2255: n number(9) := 0;
2256: */
2257:
2258: begin
2259: hr_utility.trace(' assignment_id = '||x_assignment_id);
2260: l_begin_date := null;
2261:
2262: ----dbms_output.put_line('Entered Proceduer update_wcal_asg_begin_date..');
2263: open get_asg_begin_date_csr;
2262: ----dbms_output.put_line('Entered Proceduer update_wcal_asg_begin_date..');
2263: open get_asg_begin_date_csr;
2264: fetch get_asg_begin_date_csr into l_begin_date;
2265: close get_asg_begin_date_csr;
2266: ---hr_utility.trace(' asg begin date = '||l_begin_date);
2267: ---hr_utility.trace(' g date = '||g_start_date||','||g_end_date);
2268: /*
2269: if trunc(l_begin_date) != trunc(g_start_date) then
2270: ----dbms_output.put_line('Entered IF..');
2263: open get_asg_begin_date_csr;
2264: fetch get_asg_begin_date_csr into l_begin_date;
2265: close get_asg_begin_date_csr;
2266: ---hr_utility.trace(' asg begin date = '||l_begin_date);
2267: ---hr_utility.trace(' g date = '||g_start_date||','||g_end_date);
2268: /*
2269: if trunc(l_begin_date) != trunc(g_start_date) then
2270: ----dbms_output.put_line('Entered IF..');
2271: n := (trunc(l_begin_date) - trunc(g_start_date)) ;
2291: while i < n loop
2292: if work_calendar(i)='Y' then
2293: g_no_of_person_work_days:= g_no_of_person_work_days - 1;
2294: work_calendar(i):= 'N';
2295: hr_utility.trace(' i = N, i = '||i);
2296: -- ------dbms_output.put_line('Work Calendar' ||to_char(i)||' N');
2297: end if;
2298: i:= i+1;
2299: end loop;
2809: begin
2810:
2811: ----dbms_output.PUT_LINE(' Just entered calculate_balance_amount proc... ' );
2812: ----dbms_output.PUT_LINE('g_no_of_days ' || to_char(g_no_of_days));
2813: hr_utility.trace(' Entering CALCULATE_BALANCE_AMOUNT');
2814:
2815: for i in 1..g_no_of_days loop
2816: ----dbms_output.PUT_LINE('Daily Amount ' || to_char(i) || ' ' || to_char(daily_calendar(i)));
2817: l_total_salary := l_total_salary + daily_calendar(i);
2827: x_balance_amount := 0.00;
2828: end if;
2829: x_return_status := FND_API.G_RET_STS_SUCCESS;
2830:
2831: hr_utility.trace(' Leaving CALCULATE_BALANCE_AMOUNT');
2832:
2833: EXCEPTION
2834: WHEN OTHERS then
2835: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CALCULATE_BALANCE_AMOUNT');
2998: l_paybasis varchar2(30);
2999:
3000: --
3001: BEGIN
3002: hr_utility.trace(' Entering CREATE_SLINE_SALARY_CHANGE');
3003: hr_utility.trace(' X_Payroll_line_id ...' || to_char(x_payroll_line_id));
3004: open get_payroll_line_csr;
3005: fetch get_payroll_line_csr into g_payroll_line_rec;
3006: if get_payroll_line_csr%NOTFOUND then
2999:
3000: --
3001: BEGIN
3002: hr_utility.trace(' Entering CREATE_SLINE_SALARY_CHANGE');
3003: hr_utility.trace(' X_Payroll_line_id ...' || to_char(x_payroll_line_id));
3004: open get_payroll_line_csr;
3005: fetch get_payroll_line_csr into g_payroll_line_rec;
3006: if get_payroll_line_csr%NOTFOUND then
3007: fnd_message.set_name('PSP', 'PSP_NO_PAYROLL_LINES');
3009: close get_payroll_line_csr;
3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011: end if;
3012: close get_payroll_line_csr;
3013: ---hr_utility.trace(' Pay amount .. ' || to_char(g_payroll_line_rec.pay_amount));
3014: ---hr_utility.trace(' Balance amount .. ' || to_char(g_payroll_line_rec.balance_amount));
3015:
3016: l_sub_line_start_date := trunc(g_start_date);
3017:
3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011: end if;
3012: close get_payroll_line_csr;
3013: ---hr_utility.trace(' Pay amount .. ' || to_char(g_payroll_line_rec.pay_amount));
3014: ---hr_utility.trace(' Balance amount .. ' || to_char(g_payroll_line_rec.balance_amount));
3015:
3016: l_sub_line_start_date := trunc(g_start_date);
3017:
3018: if round(g_payroll_line_rec.balance_amount, g_precision) <> 0.00 then -- Modified rounding precision to currency precision for bug fix 2916848
3025: l_daily_balance := round((g_payroll_line_rec.balance_amount / l_total_work_days), g_ext_precision);
3026: else
3027: l_daily_balance := 0.00;
3028: end if;
3029: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
3030: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
3031: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
3032: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
3033: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3026: else
3027: l_daily_balance := 0.00;
3028: end if;
3029: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
3030: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
3031: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
3032: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
3033: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3034:
3027: l_daily_balance := 0.00;
3028: end if;
3029: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
3030: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
3031: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
3032: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
3033: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3034:
3035: open get_proposal_csr;
3028: end if;
3029: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
3030: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
3031: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
3032: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
3033: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3034:
3035: open get_proposal_csr;
3036: --fetch geto _proposal_csr into l_change_date, l_salary, l_proposed_salary;
3029: ---hr_utility.trace(' Daily Balance.. ' || to_char(l_daily_balance));
3030: ---hr_utility.trace(' Assignment_id .. ' || to_char(g_payroll_line_rec.assignment_id));
3031: ---hr_utility.trace(' Element type_id .. ' || to_char(g_payroll_line_rec.element_type_id));
3032: ---hr_utility.trace(' G_start_date .. ' || to_char(g_start_date,'YYYY/MM/DD HH24:MI:SS'));
3033: ---hr_utility.trace(' G_end_date .. ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3034:
3035: open get_proposal_csr;
3036: --fetch geto _proposal_csr into l_change_date, l_salary, l_proposed_salary;
3037: fetch get_proposal_csr into
3038: l_proposed_salary, l_change_date;
3039: -- l_proposed_salary, l_salary, l_change_date;
3040: -- l_last_change_date1, l_pay_basis1;
3041:
3042: ---hr_utility.trace(' Just After fetch get_proposal l_change_date '||to_char(l_change_date) );
3043: ---hr_utility.trace(' Just After fetch get_proposal l_proposed_sal '||to_char(l_proposed_salary) );
3044: if get_proposal_csr%NOTFOUND then
3045: close get_proposal_csr;
3046: raise NO_DATA_FOUND;
3039: -- l_proposed_salary, l_salary, l_change_date;
3040: -- l_last_change_date1, l_pay_basis1;
3041:
3042: ---hr_utility.trace(' Just After fetch get_proposal l_change_date '||to_char(l_change_date) );
3043: ---hr_utility.trace(' Just After fetch get_proposal l_proposed_sal '||to_char(l_proposed_salary) );
3044: if get_proposal_csr%NOTFOUND then
3045: close get_proposal_csr;
3046: raise NO_DATA_FOUND;
3047: end if;
3046: raise NO_DATA_FOUND;
3047: end if;
3048: close get_proposal_csr;
3049:
3050: hr_utility.trace(' Just crossed NOTFOUND if' );
3051:
3052: open get_proposal_csr;
3053: loop
3054: hr_utility.trace(' Just entered Loop ' );
3050: hr_utility.trace(' Just crossed NOTFOUND if' );
3051:
3052: open get_proposal_csr;
3053: loop
3054: hr_utility.trace(' Just entered Loop ' );
3055: -- fetch get_proposal_csr into l_change_date, l_salary, l_proposed_salary;
3056:
3057:
3058: fetch get_proposal_csr into
3060: -- l_proposed_salary, l_salary, l_change_date,
3061: -- l_last_change_date1, l_pay_basis1;
3062:
3063: EXIT WHEN get_proposal_csr%NOTFOUND;
3064: --- hr_utility.trace(' After Exit When' );
3065:
3066: ---hr_utility.trace(' proposed salary inside loop '||to_char(l_proposed_salary));
3067: ---hr_utility.trace(' change_date is inside loop '||to_char(l_change_date));
3068:
3062:
3063: EXIT WHEN get_proposal_csr%NOTFOUND;
3064: --- hr_utility.trace(' After Exit When' );
3065:
3066: ---hr_utility.trace(' proposed salary inside loop '||to_char(l_proposed_salary));
3067: ---hr_utility.trace(' change_date is inside loop '||to_char(l_change_date));
3068:
3069: open get_proposal_prevsal_csr(l_change_date);
3070: fetch get_proposal_prevsal_csr into get_proposal_prevsal_rec;
3063: EXIT WHEN get_proposal_csr%NOTFOUND;
3064: --- hr_utility.trace(' After Exit When' );
3065:
3066: ---hr_utility.trace(' proposed salary inside loop '||to_char(l_proposed_salary));
3067: ---hr_utility.trace(' change_date is inside loop '||to_char(l_change_date));
3068:
3069: open get_proposal_prevsal_csr(l_change_date);
3070: fetch get_proposal_prevsal_csr into get_proposal_prevsal_rec;
3071: if get_proposal_prevsal_csr%NOTFOUND then
3068:
3069: open get_proposal_prevsal_csr(l_change_date);
3070: fetch get_proposal_prevsal_csr into get_proposal_prevsal_rec;
3071: if get_proposal_prevsal_csr%NOTFOUND then
3072: --- hr_utility.trace(' no data found');
3073: -- close get_proposal_prevsal_csr;
3074: -- raise NO_DATA_FOUND;
3075: --exit;
3076: null;
3077: end if;
3078: close get_proposal_prevsal_csr;
3079:
3080: l_salary:=nvl(get_proposal_prevsal_rec.previous_salary, 0);
3081: ---hr_utility.trace(' sal from previous '||to_char(l_salary));
3082:
3083:
3084:
3085: l_work_days := 0;
3084:
3085: l_work_days := 0;
3086: l_rate_salary := 0.00;
3087: l_array_begin := (trunc(l_sub_line_start_date) - trunc(g_start_date)) + 1;
3088: hr_utility.trace(' l_arry_begin .......' || to_char(l_array_begin));
3089: l_array_end := (trunc(l_change_date) - trunc(g_start_date));
3090: l_sub_line_end_date := trunc(l_change_date) - 1;
3091: hr_utility.trace(' i......... ' || to_char(i));
3092: for i in l_array_begin..l_array_end loop
3087: l_array_begin := (trunc(l_sub_line_start_date) - trunc(g_start_date)) + 1;
3088: hr_utility.trace(' l_arry_begin .......' || to_char(l_array_begin));
3089: l_array_end := (trunc(l_change_date) - trunc(g_start_date));
3090: l_sub_line_end_date := trunc(l_change_date) - 1;
3091: hr_utility.trace(' i......... ' || to_char(i));
3092: for i in l_array_begin..l_array_end loop
3093: l_rate_salary := l_rate_salary + daily_calendar(i);
3094: -- commented the following line and added it in the following if
3095: -- the reason is if the last date is non working day, in sub lines
3108: else
3109: l_balance_salary := 0.00;
3110: end if;
3111:
3112: ---hr_utility.trace(' Daily Balance ..' || to_char(l_daily_balance));
3113: ---hr_utility.trace(' Rate Salary ..' || to_char(l_rate_salary));
3114: hr_utility.trace(' Balance Salary ..' || to_char(l_balance_salary));
3115: if round((l_rate_salary + l_balance_salary),0) = 0 then
3116: l_total_daily_rate := 0.00;
3109: l_balance_salary := 0.00;
3110: end if;
3111:
3112: ---hr_utility.trace(' Daily Balance ..' || to_char(l_daily_balance));
3113: ---hr_utility.trace(' Rate Salary ..' || to_char(l_rate_salary));
3114: hr_utility.trace(' Balance Salary ..' || to_char(l_balance_salary));
3115: if round((l_rate_salary + l_balance_salary),0) = 0 then
3116: l_total_daily_rate := 0.00;
3117: else
3110: end if;
3111:
3112: ---hr_utility.trace(' Daily Balance ..' || to_char(l_daily_balance));
3113: ---hr_utility.trace(' Rate Salary ..' || to_char(l_rate_salary));
3114: hr_utility.trace(' Balance Salary ..' || to_char(l_balance_salary));
3115: if round((l_rate_salary + l_balance_salary),0) = 0 then
3116: l_total_daily_rate := 0.00;
3117: else
3118: l_total_daily_rate := l_daily_rate + l_daily_balance;
3118: l_total_daily_rate := l_daily_rate + l_daily_balance;
3119: end if;
3120: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3121: FROM DUAL;
3122: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3123: hr_utility.trace(' inserting into Sublines -1');
3124: if l_total_daily_Rate > 0 then
3125:
3126: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3119: end if;
3120: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3121: FROM DUAL;
3122: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3123: hr_utility.trace(' inserting into Sublines -1');
3124: if l_total_daily_Rate > 0 then
3125:
3126: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3127: X_ROWID => l_rowid,
3157: x_attribute8 => NULL,
3158: x_attribute9 => NULL,
3159: x_attribute10 => NULL,
3160: X_MODE => 'R' );
3161: hr_utility.trace(' Crossed Insert rec into sub lines');
3162:
3163: l_rowid := NULL;
3164: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3165: X_ROWID => l_rowid,
3191: l_balance_salary := 0.00;
3192: end if;
3193: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3194: FROM DUAL;
3195: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3196: hr_utility.trace(' inserting into Sublines -2');
3197: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3198: X_ROWID => l_rowid,
3199: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3192: end if;
3193: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3194: FROM DUAL;
3195: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3196: hr_utility.trace(' inserting into Sublines -2');
3197: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3198: X_ROWID => l_rowid,
3199: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3200: X_PAYROLL_LINE_ID => x_payroll_line_id,
3228: x_attribute8 => NULL,
3229: x_attribute9 => NULL,
3230: x_attribute10 => NULL,
3231: X_MODE => 'R' );
3232: ----hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3233: ----hr_utility.trace(' Crossed Insert rec into sub lines 2');
3234: l_rowid := NULL;
3235: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3236: X_ROWID => l_rowid,
3229: x_attribute9 => NULL,
3230: x_attribute10 => NULL,
3231: X_MODE => 'R' );
3232: ----hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3233: ----hr_utility.trace(' Crossed Insert rec into sub lines 2');
3234: l_rowid := NULL;
3235: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3236: X_ROWID => l_rowid,
3237: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3240: X_MODE => 'R');
3241:
3242: close get_proposal_csr;
3243:
3244: hr_utility.trace(' Leaving CREATE_SLINE_SALARY_CHANGE');
3245:
3246:
3247: EXCEPTION
3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
3251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3252:
3253: WHEN NO_DATA_FOUND then
3254: begin
3255: ----hr_utility.trace(' Entered NO_DATA_FOUND');
3256:
3257: open get_previous_proposal_csr;
3258: ----hr_utility.trace(' After open cursor');
3259: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3254: begin
3255: ----hr_utility.trace(' Entered NO_DATA_FOUND');
3256:
3257: open get_previous_proposal_csr;
3258: ----hr_utility.trace(' After open cursor');
3259: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3260: ----hr_utility.trace(' After fetch cursor');
3261: if get_previous_proposal_csr%NOTFOUND then
3262: ----hr_utility.trace(' Entered if NOTFOUND');
3256:
3257: open get_previous_proposal_csr;
3258: ----hr_utility.trace(' After open cursor');
3259: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3260: ----hr_utility.trace(' After fetch cursor');
3261: if get_previous_proposal_csr%NOTFOUND then
3262: ----hr_utility.trace(' Entered if NOTFOUND');
3263: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3264: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3258: ----hr_utility.trace(' After open cursor');
3259: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3260: ----hr_utility.trace(' After fetch cursor');
3261: if get_previous_proposal_csr%NOTFOUND then
3262: ----hr_utility.trace(' Entered if NOTFOUND');
3263: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3264: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3265: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3266:
3259: fetch get_previous_proposal_csr into l_salary, l_change_date, l_paybasis;
3260: ----hr_utility.trace(' After fetch cursor');
3261: if get_previous_proposal_csr%NOTFOUND then
3262: ----hr_utility.trace(' Entered if NOTFOUND');
3263: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3264: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3265: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3266:
3267: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3260: ----hr_utility.trace(' After fetch cursor');
3261: if get_previous_proposal_csr%NOTFOUND then
3262: ----hr_utility.trace(' Entered if NOTFOUND');
3263: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3264: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3265: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3266:
3267: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3268:
3261: if get_previous_proposal_csr%NOTFOUND then
3262: ----hr_utility.trace(' Entered if NOTFOUND');
3263: ----hr_utility.trace(' Pay amount ' || to_char(g_payroll_line_rec.pay_amount));
3264: ----hr_utility.trace(' Person work days ' || to_char(g_no_of_person_work_days));
3265: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3266:
3267: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3268:
3269: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3266:
3267: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3268:
3269: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3270: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3271: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3272: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3273: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3274:
3267: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3268:
3269: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3270: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3271: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3272: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3273: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3274:
3275: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3268:
3269: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3270: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3271: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3272: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3273: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3274:
3275: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3276: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3269: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3270: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3271: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3272: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3273: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3274:
3275: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3276: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3277: l_salary:=0;
3271: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3272: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3273: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3274:
3275: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3276: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3277: l_salary:=0;
3278: hr_utility.trace(' inserting into Sublines -3');
3279: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3272: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3273: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3274:
3275: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3276: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3277: l_salary:=0;
3278: hr_utility.trace(' inserting into Sublines -3');
3279: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3280: X_ROWID => l_rowid,
3274:
3275: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3276: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3277: l_salary:=0;
3278: hr_utility.trace(' inserting into Sublines -3');
3279: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3280: X_ROWID => l_rowid,
3281: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3282: X_PAYROLL_LINE_ID => x_payroll_line_id,
3350: ----dbms_output.PUT_LINE('salary Used ' || to_char(l_salary));
3351:
3352: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3353: FROM DUAL;
3354: hr_utility.trace(' inserting into Sublines -5');
3355: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3356: X_ROWID => l_rowid,
3357: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3358: X_PAYROLL_LINE_ID => x_payroll_line_id,
3397: ----dbms_output.PUT_LINE('After Insert record ');
3398: end;
3399: end if;
3400: end;
3401: hr_utility.trace(' Leaving CREATE_SLINE_SALARY_CHANGE');
3402: close get_previous_proposal_csr;
3403:
3404: WHEN OTHERS then
3405:
3402: close get_previous_proposal_csr;
3403:
3404: WHEN OTHERS then
3405:
3406: hr_utility.trace(' Failing with the OTHERS exception');
3407: ----dbms_output.PUT_LINE('Error Num : ' || to_char(SQLCODE) || 'Err Msg : ' || SUBSTR(SQLERRM,1,100));
3408: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3409: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3449:
3450:
3451: begin
3452:
3453: hr_utility.trace(' Entering CREATE_SLINE_ASG_CHANGE');
3454: ----dbms_output.put_line('Entered Proceduer create_sline_asg_change..');
3455: open get_asg_begin_date_csr;
3456: fetch get_asg_begin_date_csr into l_start_date;
3457: if get_asg_begin_date_csr%FOUND then
3487: end if;
3488: close get_asg_end_date_csr;
3489: x_return_status := FND_API.G_RET_STS_SUCCESS;
3490:
3491: hr_utility.trace(' Leaving CREATE_SLINE_ASG_CHANGE');
3492:
3493: EXCEPTION
3494: WHEN OTHERS then
3495: close get_asg_end_date_csr;
3542: l_total_work_days number(3) := 0;
3543:
3544: begin
3545:
3546: hr_utility.trace(' Entering CREATE_SLINE_ASG_STATUS_CHANGE');
3547: ----dbms_output.put_line('Entered Proceduer create_sline_asg_status_change..');
3548: for i in 1..g_no_of_days loop
3549: if work_calendar(i) = 'Y' then
3550: l_total_work_days := l_total_work_days + 1;
3598: -- ----dbms_output.put_line('Entered 3rd if ..');
3599:
3600: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3601: FROM DUAL;
3602: hr_utility.trace(' inserting into Sublines -6');
3603: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3604: X_ROWID => l_rowid,
3605: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3606: X_PAYROLL_LINE_ID => x_payroll_line_id,
3647: l_tmp_start_date := trunc(l_start_date);
3648: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3649: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3650: FROM DUAL;
3651: hr_utility.trace(' inserting into Sublines -7');
3652: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3653: X_ROWID => l_rowid,
3654: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3655: X_PAYROLL_LINE_ID => x_payroll_line_id,
3703: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
3704: l_tmp_end_date := trunc(l_end_date);
3705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3706: FROM DUAL;
3707: hr_utility.trace(' inserting into Sublines -8');
3708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3709: X_ROWID => l_rowid,
3710: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3711: X_PAYROLL_LINE_ID => x_payroll_line_id,
3767: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3768: end if;
3769: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3770: FROM DUAL;
3771: hr_utility.trace(' inserting into Sublines -10');
3772: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3773: X_ROWID => l_rowid,
3774: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3775: X_PAYROLL_LINE_ID => x_payroll_line_id,
3837: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3838: end if;
3839: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3840: FROM DUAL;
3841: hr_utility.trace(' inserting into Sublines -12');
3842: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3843: X_ROWID => l_rowid,
3844: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3845: X_PAYROLL_LINE_ID => x_payroll_line_id,
3885: l_tmp_start_date := trunc(l_start_date);
3886: l_tmp_end_date := trunc(l_end_date) ;
3887: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3888: FROM DUAL;
3889: hr_utility.trace(' inserting into Sublines -13');
3890: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3891: X_ROWID => l_rowid,
3892: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3893: X_PAYROLL_LINE_ID => x_payroll_line_id,
3949:
3950: end if;
3951: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3952: FROM DUAL;
3953: hr_utility.trace(' inserting into Sublines -14');
3954: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3955: X_ROWID => l_rowid,
3956: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3957: X_PAYROLL_LINE_ID => x_payroll_line_id,
4021: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4022: end if;
4023: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4024: FROM DUAL;
4025: hr_utility.trace(' inserting into Sublines -15');
4026: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4027: X_ROWID => l_rowid,
4028: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4029: X_PAYROLL_LINE_ID => x_payroll_line_id,
4070: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
4071:
4072: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4073: FROM DUAL;
4074: hr_utility.trace(' inserting into Sublines -17');
4075: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4076: X_ROWID => l_rowid,
4077: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4078: X_PAYROLL_LINE_ID => x_payroll_line_id,
4125: l_tmp_end_date := trunc(l_end_date);
4126:
4127: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4128: FROM DUAL;
4129: hr_utility.trace(' inserting into Sublines -19');
4130: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4131: X_ROWID => l_rowid,
4132: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4133: X_PAYROLL_LINE_ID => x_payroll_line_id,
4188: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4189: end if;
4190: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4191: FROM DUAL;
4192: hr_utility.trace(' inserting into Sublines -21');
4193: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4194: X_ROWID => l_rowid,
4195: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4196: X_PAYROLL_LINE_ID => x_payroll_line_id,
4248: END LOOP;
4249: close get_asg_status_csr;
4250: x_return_status := FND_API.G_RET_STS_SUCCESS;
4251:
4252: hr_utility.trace(' Leaving CREATE_SLINE_ASG_STATUS_CHANGE');
4253: EXCEPTION
4254: WHEN NO_DATA_FOUND then
4255: x_return_status := FND_API.G_RET_STS_SUCCESS;
4256: close get_asg_status_csr;
4300:
4301: begin
4302: ----dbms_output.put_line('Entered Proceduer create_sline_emp_end_date..');
4303:
4304: hr_utility.trace(' Entering CREATE_SLINE_EMP_END_DATE');
4305:
4306: open check_service_period_begin_csr;
4307: LOOP
4308: fetch check_service_period_begin_csr into l_date_start;
4315: if l_date_start > g_sublines_rec.sub_line_start_date then
4316: l_tmp_end_date := trunc(l_date_start) - 1;
4317: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4318: FROM DUAL;
4319: hr_utility.trace(' inserting into Sublines -22');
4320: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4321: X_ROWID => l_rowid,
4322: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4323: X_PAYROLL_LINE_ID => x_payroll_line_id,
4362:
4363: l_tmp_start_date := trunc(l_date_start);
4364: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4365: FROM DUAL;
4366: hr_utility.trace(' inserting into Sublines -25');
4367: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4368: X_ROWID => l_rowid,
4369: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4370: X_PAYROLL_LINE_ID => x_payroll_line_id,
4428: if l_actual_termination_date < g_sublines_rec.sub_line_end_date then
4429: l_tmp_end_date := trunc(l_actual_termination_date) - 1;
4430: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4431: FROM DUAL;
4432: hr_utility.trace(' inserting into Sublines -28');
4433: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4434: X_ROWID => l_rowid,
4435: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4436: X_PAYROLL_LINE_ID => x_payroll_line_id,
4475:
4476: l_tmp_start_date := trunc(l_actual_termination_date);
4477: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4478: FROM DUAL;
4479: hr_utility.trace(' inserting into Sublines -30');
4480: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4481: X_ROWID => l_rowid,
4482: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4483: X_PAYROLL_LINE_ID => x_payroll_line_id,
4531: END LOOP;
4532: close check_service_period_end_csr; -- bug fix 2806589
4533: x_return_status := FND_API.G_RET_STS_SUCCESS;
4534:
4535: hr_utility.trace(' Leaving CREATE_SLINE_EMP_END_DATE');
4536:
4537: EXCEPTION
4538: WHEN OTHERS then
4539: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_EMP_END_DATE');
4595:
4596:
4597: begin
4598:
4599: hr_utility.trace(' Entering CREATE_SLINE_ORG_CHANGE');
4600:
4601: ----dbms_output.put_line('Entered Procedure create_sline_org_change');
4602: open get_old_org_csr;
4603: ----dbms_output.put_line('Before fetch of get_old_org_csr...');
4661: end if;
4662:
4663: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4664: FROM DUAL;
4665: hr_utility.trace(' inserting into Sublines -32');
4666: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4667: X_ROWID => l_rowid,
4668: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4669: X_PAYROLL_LINE_ID => x_payroll_line_id,
4725: end if;
4726:
4727: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4728: FROM DUAL;
4729: hr_utility.trace(' inserting into Sublines -33');
4730: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4731: X_ROWID => l_rowid,
4732: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4733: X_PAYROLL_LINE_ID => x_payroll_line_id,
4798: end if;
4799:
4800: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4801: FROM DUAL;
4802: hr_utility.trace(' inserting into Sublines -34');
4803: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4804: X_ROWID => l_rowid,
4805: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4806: X_PAYROLL_LINE_ID => x_payroll_line_id,
4862: end if;
4863:
4864: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4865: FROM DUAL;
4866: hr_utility.trace(' inserting into Sublines -35');
4867: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4868: X_ROWID => l_rowid,
4869: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4870: X_PAYROLL_LINE_ID => x_payroll_line_id,
4932: end if;
4933:
4934: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4935: FROM DUAL;
4936: hr_utility.trace(' inserting into Sublines -37');
4937: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4938: X_ROWID => l_rowid,
4939: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4940: X_PAYROLL_LINE_ID => x_payroll_line_id,
4996: end if;
4997:
4998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4999: FROM DUAL;
5000: hr_utility.trace(' inserting into Sublines -39');
5001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5002: X_ROWID => l_rowid,
5003: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5004: X_PAYROLL_LINE_ID => x_payroll_line_id,
5060: end if;
5061:
5062: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5063: FROM DUAL;
5064: hr_utility.trace(' inserting into Sublines -42');
5065: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5066: X_ROWID => l_rowid,
5067: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5068: X_PAYROLL_LINE_ID => x_payroll_line_id,
5118: END LOOP;
5119: close get_assg_csr;
5120: x_return_status := FND_API.G_RET_STS_SUCCESS;
5121:
5122: hr_utility.trace(' Leaving CREATE_SLINE_ORG_CHANGE');
5123:
5124: EXCEPTION
5125: WHEN NO_DATA_FOUND then
5126: x_return_status := FND_API.G_RET_STS_SUCCESS;
5188:
5189:
5190: begin
5191:
5192: hr_utility.trace(' Entering CREATE_SLINE_JOB_CHANGE');
5193:
5194: open get_old_job_csr;
5195: fetch get_old_job_csr into l_effective_start_date, l_old_job_id;
5196: if get_old_job_csr%NOTFOUND then
5246: end if;
5247:
5248: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5249: FROM DUAL;
5250: hr_utility.trace(' inserting into Sublines -52');
5251: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5252: X_ROWID => l_rowid,
5253: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5254: X_PAYROLL_LINE_ID => x_payroll_line_id,
5310: end if;
5311:
5312: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5313: FROM DUAL;
5314: hr_utility.trace(' inserting into Sublines -62');
5315: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5316: X_ROWID => l_rowid,
5317: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5318: X_PAYROLL_LINE_ID => x_payroll_line_id,
5383: end if;
5384:
5385: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5386: FROM DUAL;
5387: hr_utility.trace(' inserting into Sublines -92');
5388: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5389: X_ROWID => l_rowid,
5390: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5391: X_PAYROLL_LINE_ID => x_payroll_line_id,
5447: end if;
5448:
5449: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5450: FROM DUAL;
5451: hr_utility.trace(' inserting into Sublines -102');
5452: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5453: X_ROWID => l_rowid,
5454: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5455: X_PAYROLL_LINE_ID => x_payroll_line_id,
5517: end if;
5518:
5519: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5520: FROM DUAL;
5521: hr_utility.trace(' inserting into Sublines -202');
5522: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5523: X_ROWID => l_rowid,
5524: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5525: X_PAYROLL_LINE_ID => x_payroll_line_id,
5581: end if;
5582:
5583: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5584: FROM DUAL;
5585: hr_utility.trace(' inserting into Sublines -302');
5586: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5587: X_ROWID => l_rowid,
5588: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5589: X_PAYROLL_LINE_ID => x_payroll_line_id,
5645: end if;
5646:
5647: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5648: FROM DUAL;
5649: hr_utility.trace(' inserting into Sublines -402');
5650: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5651: X_ROWID => l_rowid,
5652: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5653: X_PAYROLL_LINE_ID => x_payroll_line_id,
5711: end if;
5712: END LOOP;
5713: close get_assg_csr;
5714: x_return_status := FND_API.G_RET_STS_SUCCESS;
5715: hr_utility.trace(' Leaving CREATE_SLINE_JOB_CHANGE');
5716: EXCEPTION
5717: WHEN NO_DATA_FOUND then
5718: x_return_status := FND_API.G_RET_STS_SUCCESS;
5719: close get_assg_csr;
5778:
5779:
5780: begin
5781:
5782: hr_utility.trace(' Entering CREATE_SLINE_POSITION_CHANGE');
5783:
5784: open get_old_position_csr;
5785: fetch get_old_position_csr into l_effective_start_date, l_old_position_id;
5786: if get_old_position_csr%NOTFOUND then
5836: end if;
5837:
5838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5839: FROM DUAL;
5840: hr_utility.trace(' inserting into Sublines -502');
5841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5842: X_ROWID => l_rowid,
5843: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5844: X_PAYROLL_LINE_ID => x_payroll_line_id,
5900: end if;
5901:
5902: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5903: FROM DUAL;
5904: hr_utility.trace(' inserting into Sublines -502');
5905: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5906: X_ROWID => l_rowid,
5907: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5908: X_PAYROLL_LINE_ID => x_payroll_line_id,
5973: end if;
5974:
5975: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5976: FROM DUAL;
5977: hr_utility.trace(' inserting into Sublines -702');
5978: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5979: X_ROWID => l_rowid,
5980: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5981: X_PAYROLL_LINE_ID => x_payroll_line_id,
6037: end if;
6038:
6039: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6040: FROM DUAL;
6041: hr_utility.trace(' inserting into Sublines -802');
6042: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6043: X_ROWID => l_rowid,
6044: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6045: X_PAYROLL_LINE_ID => x_payroll_line_id,
6107: end if;
6108:
6109: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6110: FROM DUAL;
6111: hr_utility.trace(' inserting into Sublines -902');
6112: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6113: X_ROWID => l_rowid,
6114: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6115: X_PAYROLL_LINE_ID => x_payroll_line_id,
6171: end if;
6172:
6173: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6174: FROM DUAL;
6175: hr_utility.trace(' inserting into Sublines -802');
6176: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6177: X_ROWID => l_rowid,
6178: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6179: X_PAYROLL_LINE_ID => x_payroll_line_id,
6235: end if;
6236:
6237: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6238: FROM DUAL;
6239: hr_utility.trace(' inserting into Sublines -1002');
6240: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6241: X_ROWID => l_rowid,
6242: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6243: X_PAYROLL_LINE_ID => x_payroll_line_id,
6301: end if;
6302: END LOOP;
6303: close get_assg_csr;
6304: x_return_status := FND_API.G_RET_STS_SUCCESS;
6305: hr_utility.trace(' Leaving CREATE_SLINE_POSITION_CHANGE');
6306: EXCEPTION
6307: WHEN NO_DATA_FOUND then
6308: x_return_status := FND_API.G_RET_STS_SUCCESS;
6309: close get_assg_csr;
6370: l_no_of_days number(3) := 0;
6371:
6372:
6373: begin
6374: hr_utility.trace(' Entering CREATE_SLINE_GRADE_CHANGE');
6375: open get_old_grade_csr;
6376: fetch get_old_grade_csr into l_effective_start_date, l_old_grade_id;
6377: if get_old_grade_csr%NOTFOUND then
6378: l_old_grade_id := 0;
6427: end if;
6428:
6429: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6430: FROM DUAL;
6431: hr_utility.trace(' inserting into Sublines -2002');
6432: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6433: X_ROWID => l_rowid,
6434: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6435: X_PAYROLL_LINE_ID => x_payroll_line_id,
6491: end if;
6492:
6493: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6494: FROM DUAL;
6495: hr_utility.trace(' inserting into Sublines -3002');
6496: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6497: X_ROWID => l_rowid,
6498: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6499: X_PAYROLL_LINE_ID => x_payroll_line_id,
6564: end if;
6565:
6566: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6567: FROM DUAL;
6568: hr_utility.trace(' inserting into Sublines -4002');
6569: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6570: X_ROWID => l_rowid,
6571: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6572: X_PAYROLL_LINE_ID => x_payroll_line_id,
6628: end if;
6629:
6630: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6631: FROM DUAL;
6632: hr_utility.trace(' inserting into Sublines -5002');
6633: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6634: X_ROWID => l_rowid,
6635: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6636: X_PAYROLL_LINE_ID => x_payroll_line_id,
6698: end if;
6699:
6700: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6701: FROM DUAL;
6702: hr_utility.trace(' inserting into Sublines -6002');
6703: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6704: X_ROWID => l_rowid,
6705: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6706: X_PAYROLL_LINE_ID => x_payroll_line_id,
6762: end if;
6763:
6764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6765: FROM DUAL;
6766: hr_utility.trace(' inserting into Sublines -7002');
6767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6768: X_ROWID => l_rowid,
6769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6770: X_PAYROLL_LINE_ID => x_payroll_line_id,
6826: end if;
6827:
6828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6829: FROM DUAL;
6830: hr_utility.trace(' inserting into Sublines -8002');
6831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6832: X_ROWID => l_rowid,
6833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6834: X_PAYROLL_LINE_ID => x_payroll_line_id,
6879: l_old_grade_id := l_new_grade_id;
6880: END LOOP;
6881: close get_sublines_csr;
6882: x_return_status := FND_API.G_RET_STS_SUCCESS;
6883: hr_utility.trace(' Leaving CREATE_SLINE_GRADE_CHANGE');
6884: EXCEPTION
6885: WHEN NO_DATA_FOUND then
6886: x_return_status := FND_API.G_RET_STS_SUCCESS;
6887: close get_sublines_csr;
6965: l_no_of_days number(3) := 0;
6966:
6967:
6968: begin
6969: hr_utility.trace(' Entering CREATE_SLINE_PPGROUP_CHANGE');
6970: open get_old_ppgroup_csr;
6971: fetch get_old_ppgroup_csr into l_effective_start_date, l_old_ppgroup_id;
6972: if get_old_ppgroup_csr%NOTFOUND then
6973: l_old_ppgroup_id := 0;
7022: end if;
7023:
7024: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7025: FROM DUAL;
7026: hr_utility.trace(' inserting into Sublines -9002');
7027: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7028: X_ROWID => l_rowid,
7029: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7030: X_PAYROLL_LINE_ID => x_payroll_line_id,
7086: end if;
7087:
7088: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7089: FROM DUAL;
7090: hr_utility.trace(' inserting into Sublines -2Y');
7091: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7092: X_ROWID => l_rowid,
7093: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7094: X_PAYROLL_LINE_ID => x_payroll_line_id,
7159: end if;
7160:
7161: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7162: FROM DUAL;
7163: hr_utility.trace(' inserting into Sublines -2OX');
7164: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7165: X_ROWID => l_rowid,
7166: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7167: X_PAYROLL_LINE_ID => x_payroll_line_id,
7223: end if;
7224:
7225: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7226: FROM DUAL;
7227: hr_utility.trace(' inserting into Sublines -2LXL');
7228: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7229: X_ROWID => l_rowid,
7230: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7231: X_PAYROLL_LINE_ID => x_payroll_line_id,
7293: end if;
7294:
7295: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7296: FROM DUAL;
7297: hr_utility.trace(' inserting into Sublines -2UIORA');
7298: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7299: X_ROWID => l_rowid,
7300: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7301: X_PAYROLL_LINE_ID => x_payroll_line_id,
7357: end if;
7358:
7359: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7360: FROM DUAL;
7361: hr_utility.trace(' inserting into Sublines -2JADF');
7362: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7363: X_ROWID => l_rowid,
7364: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7365: X_PAYROLL_LINE_ID => x_payroll_line_id,
7421: end if;
7422:
7423: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7424: FROM DUAL;
7425: hr_utility.trace(' inserting into Sublines -299ek');
7426: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7427: X_ROWID => l_rowid,
7428: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7429: X_PAYROLL_LINE_ID => x_payroll_line_id,
7487: end if;
7488: END LOOP;
7489: close get_assg_csr;
7490: x_return_status := FND_API.G_RET_STS_SUCCESS;
7491: hr_utility.trace(' Leaving CREATE_SLINE_PPGROUP_CHANGE');
7492: EXCEPTION
7493: WHEN NO_DATA_FOUND then
7494: x_return_status := FND_API.G_RET_STS_SUCCESS;
7495: close get_assg_csr;
7545: l_new_fte_temp VARCHAR2(150); -- new added for Bug 2023920
7546: l_old_fte_temp VARCHAR2(150); -- new added for Bug 2023920
7547:
7548: begin
7549: hr_utility.trace(' Entering CREATE_SLINE_FTE_CHANGE');
7550: -- l_fte_option_value := FND_PROFILE.VALue('PSP_FTE_OPTIONS');
7551: l_fte_option_value :=psp_general.get_specific_profile('PSP_FTE_OPTIONS');
7552: if NVL(l_fte_option_value,' ') = 'BUDGET_VALUES' or l_fte_option_value IS NULL then
7553: x_return_status := FND_API.G_RET_STS_SUCCESS;
7701: end if;
7702:
7703: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7704: FROM DUAL;
7705: hr_utility.trace(' inserting into Sublines -2kdfd');
7706: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7707: X_ROWID => l_rowid,
7708: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7709: X_PAYROLL_LINE_ID => x_payroll_line_id,
7765: end if;
7766:
7767: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7768: FROM DUAL;
7769: hr_utility.trace(' inserting into Sublines -2LKJL:JL');
7770: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7771: X_ROWID => l_rowid,
7772: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7773: X_PAYROLL_LINE_ID => x_payroll_line_id,
7836: end if;
7837:
7838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7839: FROM DUAL;
7840: hr_utility.trace(' inserting into Sublines -2UUUUUUAA');
7841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7842: X_ROWID => l_rowid,
7843: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7844: X_PAYROLL_LINE_ID => x_payroll_line_id,
7900: end if;
7901:
7902: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id
7903: FROM DUAL;
7904: hr_utility.trace(' inserting into Sublines -2KKKKK');
7905: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7906: X_ROWID => l_rowid,
7907: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7908: X_PAYROLL_LINE_ID => x_payroll_line_id,
7970: end if;
7971:
7972: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7973: FROM DUAL;
7974: hr_utility.trace(' inserting into Sublines -2OOOPP888');
7975: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7976: X_ROWID => l_rowid,
7977: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7978: X_PAYROLL_LINE_ID => x_payroll_line_id,
8034: end if;
8035:
8036: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8037: FROM DUAL;
8038: hr_utility.trace(' inserting into Sublines -27777MMMN');
8039: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8040: X_ROWID => l_rowid,
8041: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8042: X_PAYROLL_LINE_ID => x_payroll_line_id,
8098: end if;
8099:
8100: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8101: FROM DUAL;
8102: hr_utility.trace(' inserting into Sublines -2EEEERRSS');
8103: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8104: X_ROWID => l_rowid,
8105: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8106: X_PAYROLL_LINE_ID => x_payroll_line_id,
8162:
8163: END LOOP;
8164: dbms_sql.close_cursor(l_cur_handle);
8165: x_return_status := FND_API.G_RET_STS_SUCCESS;
8166: hr_utility.trace(' Leaving CREATE_SLINE_FTE_CHANGE');
8167: EXCEPTION
8168: WHEN OTHERS then
8169: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');
8170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8247: return;
8248: end if;
8249: */
8250:
8251: hr_utility.trace(' Entering CREATE_SLINE_BUDGET_CHANGE');
8252: open get_old_budget_csr;
8253: fetch get_old_budget_csr into l_effective_start_date, l_old_value;
8254: if get_old_budget_csr%NOTFOUND then
8255: l_old_value := 0;
8304: end if;
8305:
8306: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8307: FROM DUAL;
8308: hr_utility.trace(' inserting into Sublines -2WWWEEERR');
8309: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8310: X_ROWID => l_rowid,
8311: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8312: X_PAYROLL_LINE_ID => x_payroll_line_id,
8368: end if;
8369:
8370: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8371: FROM DUAL;
8372: hr_utility.trace(' inserting into Sublines -29999*****888');
8373: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8374: X_ROWID => l_rowid,
8375: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8376: X_PAYROLL_LINE_ID => x_payroll_line_id,
8441: end if;
8442:
8443: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8444: FROM DUAL;
8445: hr_utility.trace(' inserting into Sublines -2DDDDDD');
8446: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8447: X_ROWID => l_rowid,
8448: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8449: X_PAYROLL_LINE_ID => x_payroll_line_id,
8505: end if;
8506:
8507: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8508: FROM DUAL;
8509: hr_utility.trace(' inserting into Sublines -2UKOSO');
8510: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8511: X_ROWID => l_rowid,
8512: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8513: X_PAYROLL_LINE_ID => x_payroll_line_id,
8575: end if;
8576:
8577: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8578: FROM DUAL;
8579: hr_utility.trace(' inserting into Sublines -2JYUPA');
8580: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8581: X_ROWID => l_rowid,
8582: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8583: X_PAYROLL_LINE_ID => x_payroll_line_id,
8639: end if;
8640:
8641: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8642: FROM DUAL;
8643: hr_utility.trace(' inserting into Sublines -2NBMM');
8644: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8645: X_ROWID => l_rowid,
8646: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8647: X_PAYROLL_LINE_ID => x_payroll_line_id,
8703: end if;
8704:
8705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8706: FROM DUAL;
8707: hr_utility.trace(' inserting into Sublines -2TOPP');
8708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8709: X_ROWID => l_rowid,
8710: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8711: X_PAYROLL_LINE_ID => x_payroll_line_id,
8769: end if;
8770: END LOOP;
8771: close get_assg_csr;
8772: x_return_status := FND_API.G_RET_STS_SUCCESS;
8773: hr_utility.trace(' Leaving CREATE_SLINE_BUDGET_CHANGE');
8774: EXCEPTION
8775: WHEN NO_DATA_FOUND then
8776: x_return_status := FND_API.G_RET_STS_SUCCESS;
8777: close get_assg_csr;
8820: AND payroll_id = l_payroll_id; ---3922347
8821:
8822: BEGIN
8823:
8824: hr_utility.trace(' Entering CHECK_ZERO_WORK_DAYS');
8825: hr_utility.trace(' zero work days check asg, g_no_of_person_workdays= '||x_assignment_id||','||g_no_of_person_work_days);
8826: IF g_no_of_person_work_days <= 0 then
8827:
8828: /* The following code is added for the enhancement Zero Work days .This code addition will identify the
8821:
8822: BEGIN
8823:
8824: hr_utility.trace(' Entering CHECK_ZERO_WORK_DAYS');
8825: hr_utility.trace(' zero work days check asg, g_no_of_person_workdays= '||x_assignment_id||','||g_no_of_person_work_days);
8826: IF g_no_of_person_work_days <= 0 then
8827:
8828: /* The following code is added for the enhancement Zero Work days .This code addition will identify the
8829: non active assignments and assignments which have started on the last day of payroll , which is a non working day
8833: FETCH non_active_asg_csr INTO l_count_asg_active;
8834: CLOSE non_active_asg_csr;
8835:
8836: IF l_count_asg_active > 0 THEN
8837: hr_utility.trace(' assignment_id l_count_asg_active > 0 asg = '||x_assignment_id);
8838: g_non_active_flag := 'Y';
8839: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8840: return;
8841: END IF;
8847: /*Bug 5557724: to_char(some_date,'D') returns a number indicating the weekday. However, for a given date, this number
8848: returned varies with NLS_TERRITORY. So replaced it with to_char(some_date,'DY') that gives the abbreviated day. */
8849: -- IF to_char(l_effective_start_date,'DY', 'nls_date_language=english') IN ('SUN','SAT') THEN
8850: IF (psp_general.business_days(l_effective_start_date, l_effective_start_date, x_assignment_id) = 0) THEN
8851: hr_utility.trace(' assignment starts in non working day = '||x_assignment_id);
8852: g_hire_zero_work_days := 'Y';
8853: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8854: return;
8855: END IF;
8865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8866: END IF;
8867: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8868:
8869: hr_utility.trace(' Leaving CHECK_ZERO_WORK_DAYS');
8870:
8871: EXCEPTION
8872: WHEN OTHERS then
8873: ------dbms_output.put_line('Check_zero_work_days.....'||x_assignment_id||' '||x_costed_value);
8922: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;
8923: l_tp_end_date per_time_periods.end_date%TYPE; -- BUG 6886237
8924: BEGIN
8925:
8926: hr_utility.trace(' Entering CREATE_SLINE_TERM_EMP');
8927: OPEN get_payroll_line_csr;
8928: FETCH get_payroll_line_csr INTO g_payroll_line_rec;
8929: CLOSE get_payroll_line_csr;
8930:
8938: where payroll_line_id = x_payroll_line_id));
8939:
8940: -- Inserting into PSP_SUB_LINES
8941: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
8942: hr_utility.trace(' inserting into Sublines -2UISISI');
8943: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8944: X_ROWID => l_rowid,
8945: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8946: X_PAYROLL_LINE_ID => x_payroll_line_id,
8985: X_PARENT_LINE_ID => l_sub_line_id,
8986: X_MODE => 'R');
8987: x_return_status := FND_API.G_RET_STS_SUCCESS;
8988:
8989: hr_utility.trace(' Leaving CREATE_SLINE_TERM_EMP');
8990:
8991: EXCEPTION
8992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8993: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
9030: l_temp_start_date DATE;
9031: l_temp_end_date DATE;
9032:
9033: BEGIN
9034: hr_utility.trace(' Entering Create Prorate Calendar st_dt, end_dt, pay_amnt, payroll_line_id, balnce_amt ='||
9035: p_start_date ||','|| p_end_date||','|| p_pay_amount||','|| p_payroll_line_id ||','|| p_balance_amount);
9036: hr_utility.trace(' g_st_dt, g_end_dt =' ||g_start_date ||','|| g_end_date);
9037: l_non_working_day_flag := 0;
9038: l_start_date := p_start_date;
9032:
9033: BEGIN
9034: hr_utility.trace(' Entering Create Prorate Calendar st_dt, end_dt, pay_amnt, payroll_line_id, balnce_amt ='||
9035: p_start_date ||','|| p_end_date||','|| p_pay_amount||','|| p_payroll_line_id ||','|| p_balance_amount);
9036: hr_utility.trace(' g_st_dt, g_end_dt =' ||g_start_date ||','|| g_end_date);
9037: l_non_working_day_flag := 0;
9038: l_start_date := p_start_date;
9039: l_end_date := p_end_date;
9040:
9046: IF (i < 1) THEN
9047: i := 1;
9048: l_start_date := g_start_date;
9049: END IF;
9050: hr_utility.trace(' l_st_dt, l_end_dt =' ||l_start_date ||','|| l_end_date);
9051: l_business_days := psp_general.business_days(l_start_date, l_end_date);
9052: hr_utility.trace(' l_business_days , g_no_of_days='|| l_business_days||','||g_no_of_days);
9053:
9054: IF (l_business_days = 0) THEN
9048: l_start_date := g_start_date;
9049: END IF;
9050: hr_utility.trace(' l_st_dt, l_end_dt =' ||l_start_date ||','|| l_end_date);
9051: l_business_days := psp_general.business_days(l_start_date, l_end_date);
9052: hr_utility.trace(' l_business_days , g_no_of_days='|| l_business_days||','||g_no_of_days);
9053:
9054: IF (l_business_days = 0) THEN
9055: l_non_working_day_flag := 1;
9056: l_business_days := 1;
9059: j := i;
9060:
9061: WHILE (j <= g_no_of_days)
9062: LOOP
9063: hr_utility.trace(' daily rate 0.0 for j=' ||j);
9064: daily_calendar(j) := 0.00;
9065: j := j + 1;
9066: END LOOP;
9067:
9067:
9068: l_daily_rate := 0.00;
9069: IF (NVL(p_pay_amount, 0) <> 0.00) THEN
9070: l_daily_rate := p_pay_amount;
9071: hr_utility.trace(' p_pay_amount, l_daily_rate=' ||l_daily_rate);
9072: IF (l_non_working_day_flag = 0) THEN
9073: l_daily_rate := ROUND((p_pay_amount / l_business_days), g_ext_precision);
9074: hr_utility.trace(' l_non_working_day_flag = 0 , l_daily_rate=' ||l_daily_rate);
9075: END IF;
9070: l_daily_rate := p_pay_amount;
9071: hr_utility.trace(' p_pay_amount, l_daily_rate=' ||l_daily_rate);
9072: IF (l_non_working_day_flag = 0) THEN
9073: l_daily_rate := ROUND((p_pay_amount / l_business_days), g_ext_precision);
9074: hr_utility.trace(' l_non_working_day_flag = 0 , l_daily_rate=' ||l_daily_rate);
9075: END IF;
9076: END IF;
9077:
9078: l_total_salary := 0.00;
9103: l_end_date := l_start_date;
9104: end if;
9105:
9106: l_final_daily_rate := l_daily_rate;
9107: hr_utility.trace(' l_total__salary = '||l_total_salary);
9108: l_final_salary := ROUND(l_total_salary, g_precision);
9109: hr_utility.trace(' l_final_salary = '||l_final_salary);
9110: l_balance_amount :=0.0;
9111:
9105:
9106: l_final_daily_rate := l_daily_rate;
9107: hr_utility.trace(' l_total__salary = '||l_total_salary);
9108: l_final_salary := ROUND(l_total_salary, g_precision);
9109: hr_utility.trace(' l_final_salary = '||l_final_salary);
9110: l_balance_amount :=0.0;
9111:
9112:
9113: IF l_final_salary <> ROUND(p_pay_amount, g_precision) THEN
9111:
9112:
9113: IF l_final_salary <> ROUND(p_pay_amount, g_precision) THEN
9114: l_balance_amount := p_pay_amount - l_final_salary;
9115: hr_utility.trace(' l_balance_amount = '||l_balance_amount);
9116: l_daily_balance := ROUND((l_balance_amount / l_business_days), g_ext_precision);
9117: hr_utility.trace(' l_daily_balance = '||l_daily_balance);
9118: l_final_daily_rate := l_final_daily_rate + l_daily_balance;
9119: hr_utility.trace(' l_finally_daily_rate 2= '||l_final_daily_rate);
9113: IF l_final_salary <> ROUND(p_pay_amount, g_precision) THEN
9114: l_balance_amount := p_pay_amount - l_final_salary;
9115: hr_utility.trace(' l_balance_amount = '||l_balance_amount);
9116: l_daily_balance := ROUND((l_balance_amount / l_business_days), g_ext_precision);
9117: hr_utility.trace(' l_daily_balance = '||l_daily_balance);
9118: l_final_daily_rate := l_final_daily_rate + l_daily_balance;
9119: hr_utility.trace(' l_finally_daily_rate 2= '||l_final_daily_rate);
9120: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9121: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9115: hr_utility.trace(' l_balance_amount = '||l_balance_amount);
9116: l_daily_balance := ROUND((l_balance_amount / l_business_days), g_ext_precision);
9117: hr_utility.trace(' l_daily_balance = '||l_daily_balance);
9118: l_final_daily_rate := l_final_daily_rate + l_daily_balance;
9119: hr_utility.trace(' l_finally_daily_rate 2= '||l_final_daily_rate);
9120: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9121: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9122: END IF;
9123:
9117: hr_utility.trace(' l_daily_balance = '||l_daily_balance);
9118: l_final_daily_rate := l_final_daily_rate + l_daily_balance;
9119: hr_utility.trace(' l_finally_daily_rate 2= '||l_final_daily_rate);
9120: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9121: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9122: END IF;
9123:
9124: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9125:
9122: END IF;
9123:
9124: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9125:
9126: hr_utility.trace(' inserting into Sublines -2LLLLLLLALALAL');
9127: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
9128: (X_ROWID => l_rowid,
9129: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
9130: X_PAYROLL_LINE_ID => p_payroll_line_id,
9170: X_MODE => 'R');
9171:
9172: p_balance_amount :=l_balance_amount;
9173: p_return_status := FND_API.G_RET_STS_SUCCESS;
9174: hr_utility.trace(' Leaving CREATE PRORATE CALENDAR');
9175: EXCEPTION
9176: WHEN fnd_api.g_exc_unexpected_error THEN
9177: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9178: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;