DBA Data[Home] [Help]

APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on FND_FILE

Line 820: fnd_file.put_line(fnd_file.log,'location: 1 l_total_full_day: '||l_total_full_day);

816:
817: l_sickness_end_date := LEAST(l_start_end_date.end_date, l_sickness_group.fourteenth_date );
818: IF l_sickness_group.fourteenth_date < l_start_end_date.end_date THEN
819:
820: fnd_file.put_line(fnd_file.log,'location: 1 l_total_full_day: '||l_total_full_day);
821: fnd_file.put_line(fnd_file.log,'location: 1 l_start_end_date.end_date : '||l_start_end_date.end_date );
822:
823: l_exit_flag := 'Y';
824: if nvl(l_start_end_date.full_day,0) > 0 then

Line 821: fnd_file.put_line(fnd_file.log,'location: 1 l_start_end_date.end_date : '||l_start_end_date.end_date );

817: l_sickness_end_date := LEAST(l_start_end_date.end_date, l_sickness_group.fourteenth_date );
818: IF l_sickness_group.fourteenth_date < l_start_end_date.end_date THEN
819:
820: fnd_file.put_line(fnd_file.log,'location: 1 l_total_full_day: '||l_total_full_day);
821: fnd_file.put_line(fnd_file.log,'location: 1 l_start_end_date.end_date : '||l_start_end_date.end_date );
822:
823: l_exit_flag := 'Y';
824: if nvl(l_start_end_date.full_day,0) > 0 then
825: l_full_day := l_employer_days - l_total_full_day;

Line 841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);

837:
838: l_total_full_day:= nvl(l_start_end_date.full_day,0) + nvl(l_total_full_day,0)
839: + nvl(l_start_end_date.part_day,0);
840:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );

Line 842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);

838: l_total_full_day:= nvl(l_start_end_date.full_day,0) + nvl(l_total_full_day,0)
839: + nvl(l_start_end_date.part_day,0);
840:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );

Line 843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);

839: + nvl(l_start_end_date.part_day,0);
840:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));

Line 844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);

840:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
848:

Line 845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );

841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
848:
849: IF l_start_end_date.start_date < g_start_date THEN

Line 846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );

842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
848:
849: IF l_start_end_date.start_date < g_start_date THEN
850: l_sickness_start_date := g_start_date;

Line 847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));

843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
848:
849: IF l_start_end_date.start_date < g_start_date THEN
850: l_sickness_start_date := g_start_date;
851: ELSE