[Home] [Help]
487: fnd_lookup_values_vl fvl,
488: per_time_periods ptp
489: where kount.payroll_action_type = fvl.lookup_code
490: and fvl.lookup_type = 'ACTION_TYPE'
491: 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'))
492: and kount.time_period_id = ptp.time_period_id
493: order by parent_payroll_control_id desc, ptp.time_period_id asc;
494: l_master_period_message varchar2(4000);
495: cursor get_master_rec_mesg is
502: select meaning
503: from fnd_lookup_values_vl
504: where lookup_code in ('LABEL1_IMP_SUM', 'LABEL2_IMP_SUM', 'LABEL3_IMP_SUM', 'LABEL4_IMP_SUM')
505: and lookup_type = 'PSP_MESSAGE_TEXT'
506: and sysdate between start_date_active and nvl(end_date_active, fnd_date.canonical_to_date('4000/01/31'))
507: order by lookup_code;
508: l_count integer;
509: l_temp_heading varchar2(1000);
510: l_heading varchar2(1000);
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:
610: /*******************************************************************************************
635: l_TGL_REVB_ACC_DATE := 'P';
636: end if;
637: close get_tgl_revb_acc_date;
638:
639: 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);
640:
641: -- open get_payroll_dates_csr;
642: -- fetch get_payroll_dates_csr into l_set_of_books_id, l_start_date, l_end_date, l_payroll_id;
643:
653: end if;
654:
655: close get_payroll_id_csr ;
656:
657: 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);
658:
659: /***** Commented the following for bug fix 3098050
660: Following portion had been commented as henceforth from this bug fix onwards, BG/SOB values would
661: be passed as parameters to the corresponding concurrenct request.
701: OPEN emphours_config_cur;
702: FETCH emphours_config_cur INTO g_uom;
703: CLOSE emphours_config_cur;
704:
705: 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 );
706:
707: OPEN ee_ci_mapping_cur;
708: FETCH ee_ci_mapping_cur INTO l_gl_column, l_pt_column, l_tk_column, l_aw_column, l_eo_column, l_et_column;
709: CLOSE ee_ci_mapping_cur;
712: OPEN ignore_date_earned_cur;
713: FETCH ignore_date_earned_cur INTO g_ignore_date_earned;
714: CLOSE ignore_date_earned_cur;
715:
716: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_ignore_date_earned = '||g_ignore_date_earned);
717:
718: l_column_count := 0;
719: IF (l_pt_column IS NOT NULL) THEN
720: l_column_count := l_column_count + 1;
731: IF (l_et_column IS NOT NULL) THEN
732: l_column_count := l_column_count + 1;
733: END IF;
734:
735: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_column_count ='||l_column_count );
736:
737: IF (l_column_count > 1) AND (l_column_count < 4) THEN
738: fnd_message.set_name('PSP', 'PSP_EE_INCOMPLETE_CI');
739: fnd_msg_pub.add;
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: end if;
774: close get_clearing_account_csr;
775:
776: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_clearing_account ='||l_clearing_account );
777:
778: /* Following code is added for bug 2056877 ,Added validation for generic suspense account */
779: l_return_value := psp_general.find_global_suspense(l_end_date,
780: l_resp_business_group_id,
827: close get_payroll_assig_actions_csr;
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:
854: -- Get all transactions from pay_costs table based on
855: -- assignment_action_id we got from assignment actions
856:
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);