DBA Data[Home] [Help]

APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on FND_FILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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