[Home] [Help]
319: p_clob := l_clob;
320: --
321: EXCEPTION
322: WHEN OTHERS THEN
323: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
324: hr_utility.set_location(sqlerrm(sqlcode),110);
325: --
326: END write_to_clob;
327: --
578: BEGIN
579: --
580: l_first_flag := 0;
581:
582: fnd_file.put_line(fnd_file.log, 'p_person_id'||p_person_id);
583: --
584: OPEN csr_asg_contribution;
585: LOOP
586: --
619: --
620: IF rec_asg_contribution.start_date > (l_asg_end_date + 1) THEN
621: --
622: CLOSE csr_asg_contribution;
623: fnd_file.put_line(fnd_file.log,'Pos 4');
624: RETURN ('N');
625: --
626: END IF;
627: --
629: --
630: IF l_asg_end_date >= p_effective_date THEN
631: --
632: CLOSE csr_asg_contribution;
633: fnd_file.put_line(fnd_file.log,'Pos 5');
634: RETURN ('Y');
635: --
636: END IF;
637: --
1209: -- Setup legislative parameters as global values for future use.
1210: --
1211: set_parameters(p_payroll_action_id);
1212: --
1213: Fnd_file.put_line(FND_FILE.LOG,'Inside Archive');
1214:
1215: -- Archive: EMEA REPORT DETAILS -> PYNOEOYA
1216: --
1217: pay_action_information_api.create_action_information
1753: --
1754: --
1755: l_employed_throughout_year := employed_throughout_year(l_asg_rec.person_id
1756: , l_asg_rec.legal_employer_id, g_report_date);
1757: fnd_file.put_line(fnd_file.log,'l_employed_throughout_year:'||l_employed_throughout_year);
1758: l_non_cont_dates_days := NULL;
1759: --
1760: IF l_employed_throughout_year = 'N' THEN
1761: --
3053: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
3054: --
3055: EXCEPTION
3056: WHEN OTHERS THEN
3057: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
3058: hr_utility.set_location(sqlerrm(sqlcode),120);
3059: --
3060: END deinitialization_code;
3061: --