DBA Data[Home] [Help]

APPS.PAY_GB_DEO dependencies on FND_FILE

Line 256: fnd_file.put_line(FND_FILE.log, 'Enering Range: pactid: '||pactid);

252: BEGIN
253:
254:
255: hr_utility.set_location('Entering: '||l_proc,1);
256: fnd_file.put_line(FND_FILE.log, 'Enering Range: pactid: '||pactid);
257: OPEN csr_parameter_info;
258: fetch csr_parameter_info into l_report_type;
259: CLOSE csr_parameter_info ;
260: fnd_file.put_line(FND_FILE.log, 'Rep_type:'||l_report_type);

Line 260: fnd_file.put_line(FND_FILE.log, 'Rep_type:'||l_report_type);

256: fnd_file.put_line(FND_FILE.log, 'Enering Range: pactid: '||pactid);
257: OPEN csr_parameter_info;
258: fetch csr_parameter_info into l_report_type;
259: CLOSE csr_parameter_info ;
260: fnd_file.put_line(FND_FILE.log, 'Rep_type:'||l_report_type);
261: IF l_report_type = 'DEO_PAY_REP' THEN
262:
263: sqlstr := 'select distinct person_id '||
264: 'from per_all_people_f ppf, '||

Line 276: fnd_file.put_line(FND_FILE.log, 'Exception in range: '||sqlcode || '-' || sqlerrm);

272: hr_utility.set_location('Leaving '|| l_proc, 10);
273: EXCEPTION
274: when others then
275: hr_utility.set_location(' Leaving: '||l_proc,50);
276: fnd_file.put_line(FND_FILE.log, 'Exception in range: '||sqlcode || '-' || sqlerrm);
277: hr_utility.raise_error;
278: -- raise_application_error(-20001,'Errors found in range cursor.');
279: END range_cursor;
280: --

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

879: l_form_name :='DEO Payment Schedule';
880:
881:
882:
883: fnd_file.put_line(fnd_file.output,' ');
884: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
885: fnd_file.put_line(fnd_file.output,' ');
886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

Line 884: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');

880:
881:
882:
883: fnd_file.put_line(fnd_file.output,' ');
884: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
885: fnd_file.put_line(fnd_file.output,' ');
886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

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

881:
882:
883: fnd_file.put_line(fnd_file.output,' ');
884: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
885: fnd_file.put_line(fnd_file.output,' ');
886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

Line 886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);

882:
883: fnd_file.put_line(fnd_file.output,' ');
884: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
885: fnd_file.put_line(fnd_file.output,' ');
886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

Line 887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

883: fnd_file.put_line(fnd_file.output,' ');
884: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
885: fnd_file.put_line(fnd_file.output,' ');
886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

Line 888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

884: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
885: fnd_file.put_line(fnd_file.output,' ');
886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);

Line 889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

885: fnd_file.put_line(fnd_file.output,' ');
886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);
893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

Line 890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

886: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);
893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

Line 891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

887: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);
893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
895: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);

Line 892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);

888: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);
893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
895: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
896: fnd_file.put_line(fnd_file.output,rpad('Payment from date : ',32) || l_rec.payment_from_date);

Line 893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

889: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);
893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
895: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
896: fnd_file.put_line(fnd_file.output,rpad('Payment from date : ',32) || l_rec.payment_from_date);
897: fnd_file.put_line(fnd_file.output,rpad('Payment to date : ',32) || l_rec.payment_to_date);

Line 894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

890: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);
893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
895: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
896: fnd_file.put_line(fnd_file.output,rpad('Payment from date : ',32) || l_rec.payment_from_date);
897: fnd_file.put_line(fnd_file.output,rpad('Payment to date : ',32) || l_rec.payment_to_date);
898:

Line 895: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);

891: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);
893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
895: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
896: fnd_file.put_line(fnd_file.output,rpad('Payment from date : ',32) || l_rec.payment_from_date);
897: fnd_file.put_line(fnd_file.output,rpad('Payment to date : ',32) || l_rec.payment_to_date);
898:
899:

Line 896: fnd_file.put_line(fnd_file.output,rpad('Payment from date : ',32) || l_rec.payment_from_date);

892: --fnd_file.put_line(fnd_file.output,rpad('HMRC Office : ',32) || l_det.hrmc_office);
893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
895: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
896: fnd_file.put_line(fnd_file.output,rpad('Payment from date : ',32) || l_rec.payment_from_date);
897: fnd_file.put_line(fnd_file.output,rpad('Payment to date : ',32) || l_rec.payment_to_date);
898:
899:
900: if length(l_addr2) > 0 then

Line 897: fnd_file.put_line(fnd_file.output,rpad('Payment to date : ',32) || l_rec.payment_to_date);

893: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
894: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
895: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
896: fnd_file.put_line(fnd_file.output,rpad('Payment from date : ',32) || l_rec.payment_from_date);
897: fnd_file.put_line(fnd_file.output,rpad('Payment to date : ',32) || l_rec.payment_to_date);
898:
899:
900: if length(l_addr2) > 0 then
901: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

Line 901: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

897: fnd_file.put_line(fnd_file.output,rpad('Payment to date : ',32) || l_rec.payment_to_date);
898:
899:
900: if length(l_addr2) > 0 then
901: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
902: end if;
903: if length(l_addr3) > 0 then
904: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
905: end if;

Line 904: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);

900: if length(l_addr2) > 0 then
901: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
902: end if;
903: if length(l_addr3) > 0 then
904: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
905: end if;
906: if length(l_addr4) > 0 then
907: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
908: end if;

Line 907: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);

903: if length(l_addr3) > 0 then
904: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
905: end if;
906: if length(l_addr4) > 0 then
907: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
908: end if;
909:
910: end write_header;
911: ---------------------

Line 914: fnd_file.put_line(fnd_file.output,null);

910: end write_header;
911: ---------------------
912: procedure write_sub_header(p_type varchar2,report_type varchar2) is
913: begin
914: fnd_file.put_line(fnd_file.output,null);
915: if p_type = 'E' then
916: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
917: else
918: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');

Line 916: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');

912: procedure write_sub_header(p_type varchar2,report_type varchar2) is
913: begin
914: fnd_file.put_line(fnd_file.output,null);
915: if p_type = 'E' then
916: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
917: else
918: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
919: end if;
920:

Line 918: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');

914: fnd_file.put_line(fnd_file.output,null);
915: if p_type = 'E' then
916: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
917: else
918: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
919: end if;
920:
921:
922: if p_type <> 'E' then --Completed records

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

919: end if;
920:
921:
922: if p_type <> 'E' then --Completed records
923: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
924: rpad('NI Number',11) ||
925: rpad('Employee Name', 51));
926: end if;
927:

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

926: end if;
927:
928:
929: if p_type <> 'E' then -- Completed records
930: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
931: rpad('-',10,'-') || ' ' ||
932: rpad('-',50,'-') );
933:
934: end if;

Line 996: fnd_file.put_line(fnd_file.output,rpad(asg_rec1.emp_no, 18) || ' ' ||

992:
993:
994: l_et_temp := asg_rec1.l_name || ', '|| asg_rec1.f_name;
995:
996: fnd_file.put_line(fnd_file.output,rpad(asg_rec1.emp_no, 18) || ' ' ||
997: rpad(asg_rec1.ni_no ,10) || ' ' ||
998: rpad(l_et_temp,50)) ;
999:
1000: l_count := l_count + 1;

Line 1004: fnd_file.put_line(fnd_file.output,null);

1000: l_count := l_count + 1;
1001: END LOOP;
1002: END IF;
1003:
1004: fnd_file.put_line(fnd_file.output,null);
1005: --fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
1006:
1007: l_counter := l_counter + l_count;
1008:

Line 1005: --fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);

1001: END LOOP;
1002: END IF;
1003:
1004: fnd_file.put_line(fnd_file.output,null);
1005: --fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
1006:
1007: l_counter := l_counter + l_count;
1008:
1009: end write_body;

Line 1029: fnd_file.put_line(fnd_file.output,null);

1025: open get_person_count;
1026: fetch get_person_count into l_person_count;
1027: close get_person_count;
1028:
1029: fnd_file.put_line(fnd_file.output,null);
1030: -- fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
1031: fnd_file.put_line(fnd_file.output,null);
1032: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
1033:

Line 1030: -- fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);

1026: fetch get_person_count into l_person_count;
1027: close get_person_count;
1028:
1029: fnd_file.put_line(fnd_file.output,null);
1030: -- fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
1031: fnd_file.put_line(fnd_file.output,null);
1032: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
1033:
1034: end write_footer;

Line 1031: fnd_file.put_line(fnd_file.output,null);

1027: close get_person_count;
1028:
1029: fnd_file.put_line(fnd_file.output,null);
1030: -- fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
1031: fnd_file.put_line(fnd_file.output,null);
1032: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
1033:
1034: end write_footer;
1035:

Line 1032: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);

1028:
1029: fnd_file.put_line(fnd_file.output,null);
1030: -- fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
1031: fnd_file.put_line(fnd_file.output,null);
1032: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
1033:
1034: end write_footer;
1035:
1036: ---------------------

Line 1105: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');

1101:
1102: hr_utility.set_location('Spawning DEO Payment Schedule Output process:'||l_emp_rec.report_format,1);
1103:
1104: if (xml_layout) then
1105: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');
1106: end if;
1107:
1108: fnd_file.put_line(fnd_file.LOG,'l_emp_rec.report_format'||l_emp_rec.report_format);
1109:

Line 1108: fnd_file.put_line(fnd_file.LOG,'l_emp_rec.report_format'||l_emp_rec.report_format);

1104: if (xml_layout) then
1105: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');
1106: end if;
1107:
1108: fnd_file.put_line(fnd_file.LOG,'l_emp_rec.report_format'||l_emp_rec.report_format);
1109:
1110: if l_emp_rec.report_format = 'XML' then
1111: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','PYGBDEOSOP','en','US','XML');
1112: elsif l_emp_rec.report_format = 'Plain' then

Line 1119: fnd_file.put_line(fnd_file.LOG,'xml_layout is true');

1115: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','PAYGBDEOSOPCSV','en','US','ETEXT');
1116: end if;
1117: if xml_layout then
1118: hr_utility.set_location('xml_layout is true',1);
1119: fnd_file.put_line(fnd_file.LOG,'xml_layout is true');
1120: else
1121: hr_utility.set_location('xml_layout is false',2);
1122: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');
1123: end if;

Line 1122: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');

1118: hr_utility.set_location('xml_layout is true',1);
1119: fnd_file.put_line(fnd_file.LOG,'xml_layout is true');
1120: else
1121: hr_utility.set_location('xml_layout is false',2);
1122: fnd_file.put_line(fnd_file.LOG,'xml_layout is false');
1123: end if;
1124:
1125: IF (xml_layout = true and g_validation_check = 'Y')
1126: THEN

Line 1138: fnd_file.put_line(fnd_file.LOG,'Error spawning new process');

1134: Commit;
1135: --check for process submit error
1136: IF l_request_id = 0
1137: THEN
1138: fnd_file.put_line(fnd_file.LOG,'Error spawning new process');
1139: hr_utility.set_location('Error spawning new process',1);
1140: END IF;
1141: END IF;
1142: