[Home] [Help]
485: fnd_lookup_values_vl fvl,
486: per_time_periods ptp
487: where kount.payroll_action_type = fvl.lookup_code
488: and fvl.lookup_type = 'ACTION_TYPE'
489: and sysdate between nvl(fvl.start_date_active,fnd_date.canonical_to_date('2000/01/31')) and nvl(fvl.end_date_active, fnd_date.canonical_to_date('4000/01/31'))
490: and kount.time_period_id = ptp.time_period_id
491: order by parent_payroll_control_id desc, ptp.time_period_id asc;
492: l_master_period_message varchar2(4000);
493: cursor get_master_rec_mesg is
500: select meaning
501: from fnd_lookup_values_vl
502: where lookup_code in ('LABEL1_IMP_SUM', 'LABEL2_IMP_SUM', 'LABEL3_IMP_SUM', 'LABEL4_IMP_SUM')
503: and lookup_type = 'PSP_MESSAGE_TEXT'
504: and sysdate between start_date_active and nvl(end_date_active, fnd_date.canonical_to_date('4000/01/31'))
505: order by lookup_code;
506: l_count integer;
507: l_temp_heading varchar2(1000);
508: l_heading varchar2(1000);
600: BEGIN
601:
602: FND_MSG_PUB.Initialize;
603: ---hr_utility.trace_on('Y','IMPORT-1');
604: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');
605: hr_utility.trace(' Entering IMPORT_PAYTRANS');
606:
607:
608: /*******************************************************************************************
633: l_TGL_REVB_ACC_DATE := 'P';
634: end if;
635: close get_tgl_revb_acc_date;
636:
637: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_TGL_REVB_ACC_DATE, l_TGL_DATE_USED='||l_TGL_REVB_ACC_DATE ||','|| l_TGL_DATE_USED);
638:
639: -- open get_payroll_dates_csr;
640: -- fetch get_payroll_dates_csr into l_set_of_books_id, l_start_date, l_end_date, l_payroll_id;
641:
651: end if;
652:
653: close get_payroll_id_csr ;
654:
655: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_start_date, l_end_date, l_payroll_id='||l_start_date ||','|| l_end_date ||','|| l_payroll_id);
656:
657: /***** Commented the following for bug fix 3098050
658: Following portion had been commented as henceforth from this bug fix onwards, BG/SOB values would
659: be passed as parameters to the corresponding concurrenct request.
699: OPEN emphours_config_cur;
700: FETCH emphours_config_cur INTO g_uom;
701: CLOSE emphours_config_cur;
702:
703: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_sob_currency_code, g_uom ='||g_sob_currency_code ||','|| g_uom );
704:
705: OPEN ee_ci_mapping_cur;
706: FETCH ee_ci_mapping_cur INTO l_gl_column, l_pt_column, l_tk_column, l_aw_column, l_eo_column, l_et_column;
707: CLOSE ee_ci_mapping_cur;
710: OPEN ignore_date_earned_cur;
711: FETCH ignore_date_earned_cur INTO g_ignore_date_earned;
712: CLOSE ignore_date_earned_cur;
713:
714: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_ignore_date_earned = '||g_ignore_date_earned);
715:
716: l_column_count := 0;
717: IF (l_pt_column IS NOT NULL) THEN
718: l_column_count := l_column_count + 1;
729: IF (l_et_column IS NOT NULL) THEN
730: l_column_count := l_column_count + 1;
731: END IF;
732:
733: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_column_count ='||l_column_count );
734:
735: IF (l_column_count > 1) AND (l_column_count < 4) THEN
736: fnd_message.set_name('PSP', 'PSP_EE_INCOMPLETE_CI');
737: fnd_msg_pub.add;
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: end if;
772: close get_clearing_account_csr;
773:
774: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_clearing_account ='||l_clearing_account );
775:
776: /* Following code is added for bug 2056877 ,Added validation for generic suspense account */
777: l_return_value := psp_general.find_global_suspense(l_end_date,
778: l_resp_business_group_id,
825: close get_payroll_assig_actions_csr;
826:
827: open get_payroll_assig_actions_csr;
828:
829: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' **************************************************************');
830:
831: LOOP
832:
833: fetch get_payroll_assig_actions_csr into g_payroll_asg_rec;
851: -- Get all transactions from pay_costs table based on
852: -- assignment_action_id we got from assignment actions
853:
854:
855: 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||','||
856: l_assignment_action_id||','||p_time_period_id);
857:
858: OPEN get_pay_costs_csr;
859: FETCH get_pay_costs_csr into g_pay_costs_rec;