eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_SWF_ARCHIVE dependencies on FND_FILE

Line 288: fnd_file.put_line(fnd_file.log,'Staff Details - Teachers Number ');

284: fetch get_context_values into g_teach_dff_name,l_context,l_column;
285: close get_context_values;
286:
287: if g_teach_dff_name is null then
288: fnd_file.put_line(fnd_file.log,'Staff Details - Teachers Number ');
289: end if;
290:
291: hr_utility.set_location('Teachers Number DFF name :'||g_teach_dff_name,20);
292: hr_utility.set_location('Teachers Number Context name :'||l_context,30);

Line 720: fnd_file.put_line(fnd_file.log,substr('Error in rangecode '

716: when others then
717: hr_utility.set_location(' Leaving: '
718: ||l_proc,50);
719:
720: fnd_file.put_line(fnd_file.log,substr('Error in rangecode '
721: ||sqlerrm(sqlcode),1,80));
722:
723: -- Return cursor that selects no rows
724: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

Line 1047: fnd_file.put_line(fnd_file.log,'Contract Details - Contract Type Configuration is not set.Please configure and proce');

1043: else
1044: g_pick_from_asg := 'N';
1045: end if;
1046: else
1047: fnd_file.put_line(fnd_file.log,'Contract Details - Contract Type Configuration is not set.Please configure and proce');
1048: raise e_contract_type_nt_defined;
1049: end if;
1050: if chunk = 1 then
1051: hr_utility.set_location('g_pick_from_asg : ' || g_pick_from_asg,30);

Line 1386: fnd_file.put_line(fnd_file.log,'Staff record could not be fetched as of ' || l_effective_date ||' for Assignment act ID :'||p_assactid);

1382: open csr_person_details(l_effective_date);
1383: fetch csr_person_details into l_staff_rec;
1384: if csr_person_details%notfound then
1385: hr_utility.set_location('Staff record could not be fetched as of ' || l_effective_date ||' for Assignment act ID :'||p_assactid,9999);
1386: fnd_file.put_line(fnd_file.log,'Staff record could not be fetched as of ' || l_effective_date ||' for Assignment act ID :'||p_assactid);
1387: --raise e_cont_eff_dt_nt_found;
1388: end if;
1389: close csr_person_details;
1390:

Line 1735: fnd_file.put_line (fnd_file.log, l_warning_msg);

1731: fetch get_formula_id into l_formula_id,l_formula_name;
1732: if get_formula_id%notfound then
1733: hr_utility.set_location('formula -'||l_formula_name||'- not present/effective in table',11);
1734: l_warning_msg := 'formula -'||l_formula_name||'- not present or effective for assignment '||p_assignment_number||' on '||p_effective_date;
1735: fnd_file.put_line (fnd_file.log, l_warning_msg);
1736: end if;
1737: close get_formula_id;
1738:
1739: if l_formula_id is not null then

Line 1821: fnd_file.put_line (fnd_file.log, l_warning_msg);

1817: fetch get_formula_id into l_formula_id,l_formula_name;
1818: if get_formula_id%notfound then
1819: hr_utility.set_location('formula -'||l_formula_name||'- not present/effective in table',11);
1820: l_warning_msg := 'formula -'||l_formula_name||'- not present or effective for assignment '||p_assignment_number||' on '||p_effective_date;
1821: fnd_file.put_line (fnd_file.log, l_warning_msg);
1822: end if;
1823: close get_formula_id;
1824:
1825: if l_formula_id is not null then

Line 2197: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_hrs_details_rec.hrs_per_wk_formula);

2193: l_hours_per_week := run_user_formula(l_hrs_details_rec.hrs_per_wk_formula,p_assignment_id,p_effective_date,g_business_group_id,l_assignment_number);
2194: hr_utility.set_location('Formula Result Value '||l_hours_per_week,20);
2195: exception when others then
2196: populate_run_msg(p_assactid,'Error while executing formula id '|| l_hrs_details_rec.hrs_per_wk_formula||'. Please refer Log file for details' );
2197: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_hrs_details_rec.hrs_per_wk_formula);
2198: fnd_file.put_line(fnd_file.log,sqlerrm);
2199: end;
2200: end if;
2201:

Line 2198: fnd_file.put_line(fnd_file.log,sqlerrm);

2194: hr_utility.set_location('Formula Result Value '||l_hours_per_week,20);
2195: exception when others then
2196: populate_run_msg(p_assactid,'Error while executing formula id '|| l_hrs_details_rec.hrs_per_wk_formula||'. Please refer Log file for details' );
2197: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_hrs_details_rec.hrs_per_wk_formula);
2198: fnd_file.put_line(fnd_file.log,sqlerrm);
2199: end;
2200: end if;
2201:
2202: if l_hrs_details_rec.wks_per_yr_source = 'FORMULA' then

Line 2209: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_hrs_details_rec.wks_per_yr_formula);

2205: l_weeks_per_yr := run_user_formula(l_hrs_details_rec.wks_per_yr_formula,p_assignment_id,p_effective_date,g_business_group_id,l_assignment_number);
2206: hr_utility.set_location('Formula Result Value '||l_weeks_per_yr,20);
2207: exception when others then
2208: populate_run_msg(p_assactid,'Error while executing formula id '|| l_hrs_details_rec.wks_per_yr_formula||'. Please refer Log file for details' );
2209: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_hrs_details_rec.wks_per_yr_formula);
2210: fnd_file.put_line(fnd_file.log,sqlerrm);
2211: end;
2212: end if;
2213: elsif l_hrs_details_rec.wks_per_yr_source = 'COLUMN' then

Line 2210: fnd_file.put_line(fnd_file.log,sqlerrm);

2206: hr_utility.set_location('Formula Result Value '||l_weeks_per_yr,20);
2207: exception when others then
2208: populate_run_msg(p_assactid,'Error while executing formula id '|| l_hrs_details_rec.wks_per_yr_formula||'. Please refer Log file for details' );
2209: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_hrs_details_rec.wks_per_yr_formula);
2210: fnd_file.put_line(fnd_file.log,sqlerrm);
2211: end;
2212: end if;
2213: elsif l_hrs_details_rec.wks_per_yr_source = 'COLUMN' then
2214: open get_wk_per_yr(l_hrs_details_rec.wks_per_yr_column,l_contract_type);

Line 2238: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_fte_formula_id);

2234: l_fte_hrs := run_user_formula(l_fte_formula_id,p_assignment_id,p_effective_date,g_business_group_id,l_assignment_number);
2235: hr_utility.set_location('Formula Result Value '||l_fte_hrs,20);
2236: exception when others then
2237: populate_run_msg(p_assactid,'Error while executing formula id '|| l_fte_formula_id||'. Please refer Log file for details' );
2238: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_fte_formula_id);
2239: fnd_file.put_line(fnd_file.log,sqlerrm);
2240: end;
2241: elsif l_fte_src = 'ASG_BUDGET' then
2242: /*open get_fte_budget_hrs;

Line 2239: fnd_file.put_line(fnd_file.log,sqlerrm);

2235: hr_utility.set_location('Formula Result Value '||l_fte_hrs,20);
2236: exception when others then
2237: populate_run_msg(p_assactid,'Error while executing formula id '|| l_fte_formula_id||'. Please refer Log file for details' );
2238: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_fte_formula_id);
2239: fnd_file.put_line(fnd_file.log,sqlerrm);
2240: end;
2241: elsif l_fte_src = 'ASG_BUDGET' then
2242: /*open get_fte_budget_hrs;
2243: fetch get_fte_budget_hrs into l_fte_hrs;

Line 2262: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_fte_formula_id);

2258: hr_utility.set_location('l_hours_per_week'||l_hours_per_week,20);
2259:
2260: if l_error_message is not null then
2261: populate_run_msg(p_assactid,'Error while executing formula GB_CALCULATE_FTE_USING_PQP_CONTRACT_TYPES.'||l_error_message );
2262: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_fte_formula_id);
2263: fnd_file.put_line(fnd_file.log,sqlerrm);
2264: end if;
2265:
2266: if l_fte_hrs = 0 or l_fte_hrs is null then

Line 2263: fnd_file.put_line(fnd_file.log,sqlerrm);

2259:
2260: if l_error_message is not null then
2261: populate_run_msg(p_assactid,'Error while executing formula GB_CALCULATE_FTE_USING_PQP_CONTRACT_TYPES.'||l_error_message );
2262: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_fte_formula_id);
2263: fnd_file.put_line(fnd_file.log,sqlerrm);
2264: end if;
2265:
2266: if l_fte_hrs = 0 or l_fte_hrs is null then
2267: l_arch := false;

Line 2829: fnd_file.put_line(fnd_file.log,'Contract Details - Contract Type Configuration is not set.Please configure and proceed');

2825: hr_utility.set_location('p_person_id :'|| p_person_id, 20);
2826: hr_utility.set_location('p_hlta_status :'|| p_hlta_status, 20);
2827:
2828: if g_pick_from_asg is null then
2829: fnd_file.put_line(fnd_file.log,'Contract Details - Contract Type Configuration is not set.Please configure and proceed');
2830: hr_utility.raise_error;
2831: end if;
2832:
2833: if p_effective_date is null then

Line 2834: fnd_file.put_line(fnd_file.log,'Contract Details - Contract effective date could not be determined.');

2830: hr_utility.raise_error;
2831: end if;
2832:
2833: if p_effective_date is null then
2834: fnd_file.put_line(fnd_file.log,'Contract Details - Contract effective date could not be determined.');
2835: hr_utility.raise_error;
2836: end if;
2837:
2838: open get_date_of_arrival_src;

Line 2861: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_user_formula_name);

2857: l_date_of_arrival_dcsf := run_user_formula(l_user_formula_name,l_asg_rec.assignment_id,g_census_day,g_business_group_id,l_asg_rec.assignment_number);
2858: hr_utility.set_location('Formula Result Value '||l_date_of_arrival_dcsf,20);
2859: exception when others then
2860: populate_run_msg(p_assactid,'Error while executing formula id '|| l_user_formula_name||'. Please refer Log file for details' );
2861: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_user_formula_name);
2862: fnd_file.put_line(fnd_file.log,sqlerrm);
2863: end;
2864: else
2865: l_date_of_arrival_dcsf := l_asg_dates_rec.date_of_arrival_dcsf;

Line 2862: fnd_file.put_line(fnd_file.log,sqlerrm);

2858: hr_utility.set_location('Formula Result Value '||l_date_of_arrival_dcsf,20);
2859: exception when others then
2860: populate_run_msg(p_assactid,'Error while executing formula id '|| l_user_formula_name||'. Please refer Log file for details' );
2861: fnd_file.put_line(fnd_file.log,'Error while executing formula id '|| l_user_formula_name);
2862: fnd_file.put_line(fnd_file.log,sqlerrm);
2863: end;
2864: else
2865: l_date_of_arrival_dcsf := l_asg_dates_rec.date_of_arrival_dcsf;
2866: end if;

Line 2887: fnd_file.put_line(fnd_file.log,'Error while executing formula '|| l_user_formula_name);

2883: l_date_of_arrival_dcsf :=run_user_formula(l_user_formula_name,l_asg_rec.assignment_id,g_census_day,g_business_group_id,l_asg_rec.assignment_number);
2884: hr_utility.set_location('Formula Result Value '||l_date_of_arrival_dcsf,20);
2885: exception when others then
2886: populate_run_msg(p_assactid,'Error while executing formula '|| l_user_formula_name||'. Please refer Log file for details' );
2887: fnd_file.put_line(fnd_file.log,'Error while executing formula '|| l_user_formula_name);
2888: fnd_file.put_line(fnd_file.log,sqlerrm);
2889: end;
2890: else
2891: l_date_of_arrival_dcsf := l_asg_dates_rec.date_of_arrival_dcsf;

Line 2888: fnd_file.put_line(fnd_file.log,sqlerrm);

2884: hr_utility.set_location('Formula Result Value '||l_date_of_arrival_dcsf,20);
2885: exception when others then
2886: populate_run_msg(p_assactid,'Error while executing formula '|| l_user_formula_name||'. Please refer Log file for details' );
2887: fnd_file.put_line(fnd_file.log,'Error while executing formula '|| l_user_formula_name);
2888: fnd_file.put_line(fnd_file.log,sqlerrm);
2889: end;
2890: else
2891: l_date_of_arrival_dcsf := l_asg_dates_rec.date_of_arrival_dcsf;
2892: end if;

Line 3918: fnd_file.put_line(fnd_file.log,'Establishment number should not be entered for Type 3 Extract.');

3914: close param_details;
3915:
3916: if param_details_rec.data_return_type = 'TYPE3' and param_details_rec.estb_num is not null then
3917: raise_application_error(-20002,'Establishment number should not be entered for Type 3 Extract.');
3918: fnd_file.put_line(fnd_file.log,'Establishment number should not be entered for Type 3 Extract.');
3919: fnd_file.put_line(fnd_file.output,'Establishment number should not be entered for Type 3 Extract.');
3920: fnd_file.put_line(fnd_file.output,' ');
3921: end if;
3922:

Line 3919: fnd_file.put_line(fnd_file.output,'Establishment number should not be entered for Type 3 Extract.');

3915:
3916: if param_details_rec.data_return_type = 'TYPE3' and param_details_rec.estb_num is not null then
3917: raise_application_error(-20002,'Establishment number should not be entered for Type 3 Extract.');
3918: fnd_file.put_line(fnd_file.log,'Establishment number should not be entered for Type 3 Extract.');
3919: fnd_file.put_line(fnd_file.output,'Establishment number should not be entered for Type 3 Extract.');
3920: fnd_file.put_line(fnd_file.output,' ');
3921: end if;
3922:
3923: if param_details_rec.data_return_type = 'TYPE2' and param_details_rec.estb_num is null then

Line 3920: fnd_file.put_line(fnd_file.output,' ');

3916: if param_details_rec.data_return_type = 'TYPE3' and param_details_rec.estb_num is not null then
3917: raise_application_error(-20002,'Establishment number should not be entered for Type 3 Extract.');
3918: fnd_file.put_line(fnd_file.log,'Establishment number should not be entered for Type 3 Extract.');
3919: fnd_file.put_line(fnd_file.output,'Establishment number should not be entered for Type 3 Extract.');
3920: fnd_file.put_line(fnd_file.output,' ');
3921: end if;
3922:
3923: if param_details_rec.data_return_type = 'TYPE2' and param_details_rec.estb_num is null then
3924: raise_application_error(-20002,'Establishment number should be entered for Type 2 Extract.');

Line 3925: fnd_file.put_line(fnd_file.log,'Establishment number should be entered for Type 2 Extract.');

3921: end if;
3922:
3923: if param_details_rec.data_return_type = 'TYPE2' and param_details_rec.estb_num is null then
3924: raise_application_error(-20002,'Establishment number should be entered for Type 2 Extract.');
3925: fnd_file.put_line(fnd_file.log,'Establishment number should be entered for Type 2 Extract.');
3926: fnd_file.put_line(fnd_file.output,'Establishment number should be entered for Type 2 Extract.');
3927: fnd_file.put_line(fnd_file.output,' ');
3928: end if;
3929:

Line 3926: fnd_file.put_line(fnd_file.output,'Establishment number should be entered for Type 2 Extract.');

3922:
3923: if param_details_rec.data_return_type = 'TYPE2' and param_details_rec.estb_num is null then
3924: raise_application_error(-20002,'Establishment number should be entered for Type 2 Extract.');
3925: fnd_file.put_line(fnd_file.log,'Establishment number should be entered for Type 2 Extract.');
3926: fnd_file.put_line(fnd_file.output,'Establishment number should be entered for Type 2 Extract.');
3927: fnd_file.put_line(fnd_file.output,' ');
3928: end if;
3929:
3930:

Line 3927: fnd_file.put_line(fnd_file.output,' ');

3923: if param_details_rec.data_return_type = 'TYPE2' and param_details_rec.estb_num is null then
3924: raise_application_error(-20002,'Establishment number should be entered for Type 2 Extract.');
3925: fnd_file.put_line(fnd_file.log,'Establishment number should be entered for Type 2 Extract.');
3926: fnd_file.put_line(fnd_file.output,'Establishment number should be entered for Type 2 Extract.');
3927: fnd_file.put_line(fnd_file.output,' ');
3928: end if;
3929:
3930:
3931: hr_utility.set_location('Leaving '|| l_proc, 110);

Line 4046: fnd_file.put_line(fnd_file.log,'Contract Details - Contract Type Configuration is not set.Please configure and proce');

4042: else
4043: g_pick_from_asg := 'N';
4044: end if;
4045: else
4046: fnd_file.put_line(fnd_file.log,'Contract Details - Contract Type Configuration is not set.Please configure and proce');
4047: end if;
4048: ------------------------------------------------------------------------------
4049: --dyn_sql call here. dyn_sql builds all the dynamic sql strings that are used
4050: -- in the archive procedures.this has been wrapped into a procedure to keep the

Line 4172: fnd_file.put_line(fnd_file.log,'Error(s) in assignment id: '||l_archive_tab(1).assignment_id||'. Please refer Output file for detailed error messages');

4168: l_archive_qual and l_archive_addl_payment and l_archive_hrs then
4169:
4170: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);
4171: else
4172: fnd_file.put_line(fnd_file.log,'Error(s) in assignment id: '||l_archive_tab(1).assignment_id||'. Please refer Output file for detailed error messages');
4173: raise_application_error(-20001,'Error(s) found while archiving data.');
4174: end if;
4175:
4176: else

Line 4429: fnd_file.put_line(fnd_file.output,'Parameter Details:');

4425: open param_details;
4426: fetch param_details into param_details_rec;
4427: close param_details;
4428:
4429: fnd_file.put_line(fnd_file.output,'Parameter Details:');
4430: fnd_file.put_line(fnd_file.output,rpad('Census Year',25)||': '||param_details_rec.census_year);
4431: fnd_file.put_line(fnd_file.output,rpad('Census Day',25)||': '||param_details_rec.census_day);
4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);
4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);

Line 4430: fnd_file.put_line(fnd_file.output,rpad('Census Year',25)||': '||param_details_rec.census_year);

4426: fetch param_details into param_details_rec;
4427: close param_details;
4428:
4429: fnd_file.put_line(fnd_file.output,'Parameter Details:');
4430: fnd_file.put_line(fnd_file.output,rpad('Census Year',25)||': '||param_details_rec.census_year);
4431: fnd_file.put_line(fnd_file.output,rpad('Census Day',25)||': '||param_details_rec.census_day);
4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);
4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);
4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);

Line 4431: fnd_file.put_line(fnd_file.output,rpad('Census Day',25)||': '||param_details_rec.census_day);

4427: close param_details;
4428:
4429: fnd_file.put_line(fnd_file.output,'Parameter Details:');
4430: fnd_file.put_line(fnd_file.output,rpad('Census Year',25)||': '||param_details_rec.census_year);
4431: fnd_file.put_line(fnd_file.output,rpad('Census Day',25)||': '||param_details_rec.census_day);
4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);
4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);
4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);
4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);

Line 4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);

4428:
4429: fnd_file.put_line(fnd_file.output,'Parameter Details:');
4430: fnd_file.put_line(fnd_file.output,rpad('Census Year',25)||': '||param_details_rec.census_year);
4431: fnd_file.put_line(fnd_file.output,rpad('Census Day',25)||': '||param_details_rec.census_day);
4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);
4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);
4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);
4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);
4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);

Line 4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);

4429: fnd_file.put_line(fnd_file.output,'Parameter Details:');
4430: fnd_file.put_line(fnd_file.output,rpad('Census Year',25)||': '||param_details_rec.census_year);
4431: fnd_file.put_line(fnd_file.output,rpad('Census Day',25)||': '||param_details_rec.census_day);
4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);
4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);
4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);
4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);
4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);
4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);

Line 4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);

4430: fnd_file.put_line(fnd_file.output,rpad('Census Year',25)||': '||param_details_rec.census_year);
4431: fnd_file.put_line(fnd_file.output,rpad('Census Day',25)||': '||param_details_rec.census_day);
4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);
4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);
4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);
4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);
4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);
4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);
4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);

Line 4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);

4431: fnd_file.put_line(fnd_file.output,rpad('Census Day',25)||': '||param_details_rec.census_day);
4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);
4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);
4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);
4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);
4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);
4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);
4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);
4439: fnd_file.put_line(fnd_file.output,rpad('Assignment Set',25)||': '||param_details_rec.asg_set);

Line 4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);

4432: fnd_file.put_line(fnd_file.output,rpad('Continuous Start Day',25)||': '||param_details_rec.cont_st_day);
4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);
4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);
4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);
4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);
4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);
4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);
4439: fnd_file.put_line(fnd_file.output,rpad('Assignment Set',25)||': '||param_details_rec.asg_set);
4440: fnd_file.put_line(fnd_file.output,' ');

Line 4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);

4433: fnd_file.put_line(fnd_file.output,rpad('Continuous End Day',25)||': '||param_details_rec.cont_end_day);
4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);
4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);
4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);
4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);
4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);
4439: fnd_file.put_line(fnd_file.output,rpad('Assignment Set',25)||': '||param_details_rec.asg_set);
4440: fnd_file.put_line(fnd_file.output,' ');
4441: fnd_file.put_line(fnd_file.output,' ');

Line 4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);

4434: fnd_file.put_line(fnd_file.output,rpad('LEA Number',25)||': '||param_details_rec.lea_num);
4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);
4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);
4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);
4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);
4439: fnd_file.put_line(fnd_file.output,rpad('Assignment Set',25)||': '||param_details_rec.asg_set);
4440: fnd_file.put_line(fnd_file.output,' ');
4441: fnd_file.put_line(fnd_file.output,' ');
4442:

Line 4439: fnd_file.put_line(fnd_file.output,rpad('Assignment Set',25)||': '||param_details_rec.asg_set);

4435: fnd_file.put_line(fnd_file.output,rpad('Data Return Type',25)||': '||param_details_rec.data_return_type);
4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);
4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);
4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);
4439: fnd_file.put_line(fnd_file.output,rpad('Assignment Set',25)||': '||param_details_rec.asg_set);
4440: fnd_file.put_line(fnd_file.output,' ');
4441: fnd_file.put_line(fnd_file.output,' ');
4442:
4443:

Line 4440: fnd_file.put_line(fnd_file.output,' ');

4436: fnd_file.put_line(fnd_file.output,rpad('Establishment Number',25)||': '||param_details_rec.estb_num);
4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);
4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);
4439: fnd_file.put_line(fnd_file.output,rpad('Assignment Set',25)||': '||param_details_rec.asg_set);
4440: fnd_file.put_line(fnd_file.output,' ');
4441: fnd_file.put_line(fnd_file.output,' ');
4442:
4443:
4444: if param_details_rec.data_return_type <> 'TYPE4' then

Line 4441: fnd_file.put_line(fnd_file.output,' ');

4437: fnd_file.put_line(fnd_file.output,rpad('Exclude Absence',25)||': '||param_details_rec.exclude_abs);
4438: fnd_file.put_line(fnd_file.output,rpad('Exclude Qualification',25)||': '||param_details_rec.exclude_qual);
4439: fnd_file.put_line(fnd_file.output,rpad('Assignment Set',25)||': '||param_details_rec.asg_set);
4440: fnd_file.put_line(fnd_file.output,' ');
4441: fnd_file.put_line(fnd_file.output,' ');
4442:
4443:
4444: if param_details_rec.data_return_type <> 'TYPE4' then
4445: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed With Errors :',50));

Line 4445: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed With Errors :',50));

4441: fnd_file.put_line(fnd_file.output,' ');
4442:
4443:
4444: if param_details_rec.data_return_type <> 'TYPE4' then
4445: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed With Errors :',50));
4446: fnd_file.put_line(fnd_file.output,' ');
4447: for asg_rec in csr_asg loop
4448: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4449: rpad('NI Number',11) ||

Line 4446: fnd_file.put_line(fnd_file.output,' ');

4442:
4443:
4444: if param_details_rec.data_return_type <> 'TYPE4' then
4445: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed With Errors :',50));
4446: fnd_file.put_line(fnd_file.output,' ');
4447: for asg_rec in csr_asg loop
4448: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4449: rpad('NI Number',11) ||
4450: rpad('Assignment Number',19) ||

Line 4448: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||

4444: if param_details_rec.data_return_type <> 'TYPE4' then
4445: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed With Errors :',50));
4446: fnd_file.put_line(fnd_file.output,' ');
4447: for asg_rec in csr_asg loop
4448: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4449: rpad('NI Number',11) ||
4450: rpad('Assignment Number',19) ||
4451: rpad('Employee Name', 50));
4452: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

Line 4452: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

4448: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4449: rpad('NI Number',11) ||
4450: rpad('Assignment Number',19) ||
4451: rpad('Employee Name', 50));
4452: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
4453: rpad('-',10,'-') || ' ' ||
4454: rpad('-',18,'-') || ' ' ||
4455: rpad('-',50,'-'));
4456: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;

Line 4457: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||

4453: rpad('-',10,'-') || ' ' ||
4454: rpad('-',18,'-') || ' ' ||
4455: rpad('-',50,'-'));
4456: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
4457: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
4458: rpad(asg_rec.ni_no ,10) || ' ' ||
4459: rpad(asg_rec.asg_no, 18) || ' ' ||
4460: rpad(l_temp,50));
4461:

Line 4465: fnd_file.put_line(fnd_file.output,rpad('Error Message(s) :',18));

4461:
4462: l_counter := 1;
4463: for msg_rec in messages(asg_rec.asg_act_id) loop
4464: if l_counter = 1 then
4465: fnd_file.put_line(fnd_file.output,rpad('Error Message(s) :',18));
4466: end if;
4467: fnd_file.put_line(fnd_file.output,substr(msg_rec.error_text,1,255));
4468: l_counter:= l_counter +1;
4469: end loop;

Line 4467: fnd_file.put_line(fnd_file.output,substr(msg_rec.error_text,1,255));

4463: for msg_rec in messages(asg_rec.asg_act_id) loop
4464: if l_counter = 1 then
4465: fnd_file.put_line(fnd_file.output,rpad('Error Message(s) :',18));
4466: end if;
4467: fnd_file.put_line(fnd_file.output,substr(msg_rec.error_text,1,255));
4468: l_counter:= l_counter +1;
4469: end loop;
4470: fnd_file.put_line(fnd_file.output,' ');
4471: end loop;

Line 4470: fnd_file.put_line(fnd_file.output,' ');

4466: end if;
4467: fnd_file.put_line(fnd_file.output,substr(msg_rec.error_text,1,255));
4468: l_counter:= l_counter +1;
4469: end loop;
4470: fnd_file.put_line(fnd_file.output,' ');
4471: end loop;
4472:
4473: fnd_file.put_line(fnd_file.output,' ');
4474: fnd_file.put_line(fnd_file.output,' ');

Line 4473: fnd_file.put_line(fnd_file.output,' ');

4469: end loop;
4470: fnd_file.put_line(fnd_file.output,' ');
4471: end loop;
4472:
4473: fnd_file.put_line(fnd_file.output,' ');
4474: fnd_file.put_line(fnd_file.output,' ');
4475: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed Without Errors :',50));
4476: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4477: rpad('NI Number',11) ||

Line 4474: fnd_file.put_line(fnd_file.output,' ');

4470: fnd_file.put_line(fnd_file.output,' ');
4471: end loop;
4472:
4473: fnd_file.put_line(fnd_file.output,' ');
4474: fnd_file.put_line(fnd_file.output,' ');
4475: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed Without Errors :',50));
4476: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4477: rpad('NI Number',11) ||
4478: rpad('Assignment Number',19) ||

Line 4475: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed Without Errors :',50));

4471: end loop;
4472:
4473: fnd_file.put_line(fnd_file.output,' ');
4474: fnd_file.put_line(fnd_file.output,' ');
4475: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed Without Errors :',50));
4476: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4477: rpad('NI Number',11) ||
4478: rpad('Assignment Number',19) ||
4479: rpad('Employee Name', 50));

Line 4476: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||

4472:
4473: fnd_file.put_line(fnd_file.output,' ');
4474: fnd_file.put_line(fnd_file.output,' ');
4475: fnd_file.put_line(fnd_file.output,rpad('Assignments Processed Without Errors :',50));
4476: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4477: rpad('NI Number',11) ||
4478: rpad('Assignment Number',19) ||
4479: rpad('Employee Name', 50));
4480: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

Line 4480: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

4476: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4477: rpad('NI Number',11) ||
4478: rpad('Assignment Number',19) ||
4479: rpad('Employee Name', 50));
4480: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
4481: rpad('-',10,'-') || ' ' ||
4482: rpad('-',18,'-') || ' ' ||
4483: rpad('-',50,'-'));
4484:

Line 4488: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||

4484:
4485: for asg_rec in asg_without_errors loop
4486:
4487: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
4488: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
4489: rpad(asg_rec.ni_no ,10) || ' ' ||
4490: rpad(asg_rec.asg_no, 18) || ' ' ||
4491: rpad(l_temp,50));
4492: end loop;

Line 4498: fnd_file.put_line(fnd_file.output,' ');

4494: l_counter := 0;
4495: for fte_hrs_errors in fte_hrs loop
4496: l_counter := l_counter + 1;
4497: if l_counter = 1 then
4498: fnd_file.put_line(fnd_file.output,' ');
4499: fnd_file.put_line(fnd_file.output,'The following person(s) has a total Full Time Equivalent ratio greater than 1.5');
4500: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4501: rpad('NI Number',11) ||
4502: rpad('Employee Name', 50));

Line 4499: fnd_file.put_line(fnd_file.output,'The following person(s) has a total Full Time Equivalent ratio greater than 1.5');

4495: for fte_hrs_errors in fte_hrs loop
4496: l_counter := l_counter + 1;
4497: if l_counter = 1 then
4498: fnd_file.put_line(fnd_file.output,' ');
4499: fnd_file.put_line(fnd_file.output,'The following person(s) has a total Full Time Equivalent ratio greater than 1.5');
4500: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4501: rpad('NI Number',11) ||
4502: rpad('Employee Name', 50));
4503: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

Line 4500: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||

4496: l_counter := l_counter + 1;
4497: if l_counter = 1 then
4498: fnd_file.put_line(fnd_file.output,' ');
4499: fnd_file.put_line(fnd_file.output,'The following person(s) has a total Full Time Equivalent ratio greater than 1.5');
4500: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4501: rpad('NI Number',11) ||
4502: rpad('Employee Name', 50));
4503: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
4504: rpad('-',10,'-') || ' ' ||

Line 4503: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

4499: fnd_file.put_line(fnd_file.output,'The following person(s) has a total Full Time Equivalent ratio greater than 1.5');
4500: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
4501: rpad('NI Number',11) ||
4502: rpad('Employee Name', 50));
4503: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
4504: rpad('-',10,'-') || ' ' ||
4505: rpad('-',50,'-'));
4506: end if;
4507:

Line 4511: fnd_file.put_line(fnd_file.output,rpad(emp_rec.emp_no, 18) || ' ' ||

4507:
4508: open emp_details(fte_hrs_errors.person_id);
4509: fetch emp_details into emp_rec;
4510: l_temp := emp_rec.l_name || ', '|| emp_rec.title || ' ' || emp_rec.f_name || ' ' || emp_rec.m_name;
4511: fnd_file.put_line(fnd_file.output,rpad(emp_rec.emp_no, 18) || ' ' ||
4512: rpad(emp_rec.ni_no ,10) || ' ' ||
4513: rpad(l_temp,50));
4514: close emp_details;
4515:

Line 4523: fnd_file.put_line(fnd_file.output,'Atleast one staff record in this school''s return should show a role of Head Teacher');

4519: fetch hdtr_count into l_hdtr_count;
4520: close hdtr_count;
4521:
4522: if param_details_rec.data_return_type <>'TYPE3' and l_hdtr_count = 0 then
4523: fnd_file.put_line(fnd_file.output,'Atleast one staff record in this school''s return should show a role of Head Teacher');
4524: end if;
4525: end if ; --data_return_type <> 'TYPE4'
4526:
4527: if param_details_rec.data_return_type = 'TYPE4' then

Line 4540: fnd_file.put_line(fnd_file.output,rpad('Full Time Educational Psychologists Count',60)||': '||l_espf_full_time);

4536: open epsy_fte_sum_part_time;
4537: fetch epsy_fte_sum_part_time into l_espf_fte;
4538: close epsy_fte_sum_part_time;
4539:
4540: fnd_file.put_line(fnd_file.output,rpad('Full Time Educational Psychologists Count',60)||': '||l_espf_full_time);
4541: fnd_file.put_line(fnd_file.output,rpad('Part Time Educational Psychologists Count',60)||': '||l_espf_part_time);
4542: fnd_file.put_line(fnd_file.output,rpad('Total FTE- part Time Educational Psychologists ',60)||': '||l_espf_fte);
4543:
4544:

Line 4541: fnd_file.put_line(fnd_file.output,rpad('Part Time Educational Psychologists Count',60)||': '||l_espf_part_time);

4537: fetch epsy_fte_sum_part_time into l_espf_fte;
4538: close epsy_fte_sum_part_time;
4539:
4540: fnd_file.put_line(fnd_file.output,rpad('Full Time Educational Psychologists Count',60)||': '||l_espf_full_time);
4541: fnd_file.put_line(fnd_file.output,rpad('Part Time Educational Psychologists Count',60)||': '||l_espf_part_time);
4542: fnd_file.put_line(fnd_file.output,rpad('Total FTE- part Time Educational Psychologists ',60)||': '||l_espf_fte);
4543:
4544:
4545: end if;

Line 4542: fnd_file.put_line(fnd_file.output,rpad('Total FTE- part Time Educational Psychologists ',60)||': '||l_espf_fte);

4538: close epsy_fte_sum_part_time;
4539:
4540: fnd_file.put_line(fnd_file.output,rpad('Full Time Educational Psychologists Count',60)||': '||l_espf_full_time);
4541: fnd_file.put_line(fnd_file.output,rpad('Part Time Educational Psychologists Count',60)||': '||l_espf_part_time);
4542: fnd_file.put_line(fnd_file.output,rpad('Total FTE- part Time Educational Psychologists ',60)||': '||l_espf_fte);
4543:
4544:
4545: end if;
4546: