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.FV_CCR_DATA_LOAD_PKG dependencies on FND_FILE

Line 4479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_errbuf);

4475: loop
4476: ap_approval_pkg.BATCH_APPROVAL_FOR_VENDOR(vendor_ids(l_vendor_cnt), l_module_name);
4477: l_errbuf := 'New Active Vendor Id: '||vendor_ids(i);
4478: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
4479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_errbuf);
4480: select vendor_name into l_vendor_name from po_vendors where vendor_id = vendor_ids(i);
4481: insert_temp_data(4,duns_ids(i),vendor_ids(i),l_vendor_name,null,null,null);
4482:
4483: end loop;

Line 4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' CCR Data Load Report');

4611: insert_temp_data(3,null,message_text ,null,crec.duns||crec.plus_four,null,null);
4612: END LOOP;
4613: END IF;
4614:
4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' CCR Data Load Report');
4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4617:
4618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Concurrent Request ID: '||l_request_id);
4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');

Line 4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4612: END LOOP;
4613: END IF;
4614:
4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' CCR Data Load Report');
4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4617:
4618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Concurrent Request ID: '||l_request_id);
4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');
4620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 4618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Concurrent Request ID: '||l_request_id);

4614:
4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' CCR Data Load Report');
4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4617:
4618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Concurrent Request ID: '||l_request_id);
4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');
4620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('File Location: '||p_file_location,75,' ')||rpad('File Name: '||p_file_name,75,' ')||'File Type: '||p_file_type);
4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));

Line 4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');

4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' CCR Data Load Report');
4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4617:
4618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Concurrent Request ID: '||l_request_id);
4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');
4620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('File Location: '||p_file_location,75,' ')||rpad('File Name: '||p_file_name,75,' ')||'File Type: '||p_file_type);
4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));
4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 4620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4617:
4618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Concurrent Request ID: '||l_request_id);
4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');
4620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('File Location: '||p_file_location,75,' ')||rpad('File Name: '||p_file_name,75,' ')||'File Type: '||p_file_type);
4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));
4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4624:

Line 4621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('File Location: '||p_file_location,75,' ')||rpad('File Name: '||p_file_name,75,' ')||'File Type: '||p_file_type);

4617:
4618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Concurrent Request ID: '||l_request_id);
4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');
4620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('File Location: '||p_file_location,75,' ')||rpad('File Name: '||p_file_name,75,' ')||'File Type: '||p_file_type);
4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));
4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4624:
4625: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XML Parameters');

Line 4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));

4618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Concurrent Request ID: '||l_request_id);
4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');
4620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('File Location: '||p_file_location,75,' ')||rpad('File Name: '||p_file_name,75,' ')||'File Type: '||p_file_type);
4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));
4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4624:
4625: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XML Parameters');
4626: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),35,' ')||'CAGE Code: '||'N/A');

Line 4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Extract File Parameters ');
4620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('File Location: '||p_file_location,75,' ')||rpad('File Name: '||p_file_name,75,' ')||'File Type: '||p_file_type);
4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));
4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4624:
4625: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XML Parameters');
4626: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),35,' ')||'CAGE Code: '||'N/A');
4627: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Taxpayer Number: '||'N/A',75,' ')||'Registration Status: '||'N/A');

Line 4625: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XML Parameters');

4621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('File Location: '||p_file_location,75,' ')||rpad('File Name: '||p_file_name,75,' ')||'File Type: '||p_file_type);
4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));
4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4624:
4625: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XML Parameters');
4626: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),35,' ')||'CAGE Code: '||'N/A');
4627: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Taxpayer Number: '||'N/A',75,' ')||'Registration Status: '||'N/A');
4628: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Start Date: '||'N/A',75,' ')||'End Date: '||'N/A');
4629:

Line 4626: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),35,' ')||'CAGE Code: '||'N/A');

4622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' '));
4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4624:
4625: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XML Parameters');
4626: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),35,' ')||'CAGE Code: '||'N/A');
4627: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Taxpayer Number: '||'N/A',75,' ')||'Registration Status: '||'N/A');
4628: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Start Date: '||'N/A',75,' ')||'End Date: '||'N/A');
4629:
4630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' ')||'Insert New Records: '||p_insert_data);

Line 4627: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Taxpayer Number: '||'N/A',75,' ')||'Registration Status: '||'N/A');

4623: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4624:
4625: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XML Parameters');
4626: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),35,' ')||'CAGE Code: '||'N/A');
4627: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Taxpayer Number: '||'N/A',75,' ')||'Registration Status: '||'N/A');
4628: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Start Date: '||'N/A',75,' ')||'End Date: '||'N/A');
4629:
4630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' ')||'Insert New Records: '||p_insert_data);
4631:

Line 4628: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Start Date: '||'N/A',75,' ')||'End Date: '||'N/A');

4624:
4625: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XML Parameters');
4626: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),35,' ')||'CAGE Code: '||'N/A');
4627: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Taxpayer Number: '||'N/A',75,' ')||'Registration Status: '||'N/A');
4628: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Start Date: '||'N/A',75,' ')||'End Date: '||'N/A');
4629:
4630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' ')||'Insert New Records: '||p_insert_data);
4631:
4632: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 4630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' ')||'Insert New Records: '||p_insert_data);

4626: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),35,' ')||'CAGE Code: '||'N/A');
4627: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Taxpayer Number: '||'N/A',75,' ')||'Registration Status: '||'N/A');
4628: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Start Date: '||'N/A',75,' ')||'End Date: '||'N/A');
4629:
4630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' ')||'Insert New Records: '||p_insert_data);
4631:
4632: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4634:

Line 4632: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4628: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Start Date: '||'N/A',75,' ')||'End Date: '||'N/A');
4629:
4630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' ')||'Insert New Records: '||p_insert_data);
4631:
4632: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4634:
4635: l_report_count := 0;
4636:

Line 4633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4629:
4630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS Numbers To Query: '||nvl(p_duns,'All'),75,' ')||rpad('Enter DUNS Number: '||nvl(p_duns,'N/A'),75,' ')||'Insert New Records: '||p_insert_data);
4631:
4632: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4634:
4635: l_report_count := 0;
4636:
4637: FOR l_ccr_rep in c_ccr_rep

Line 4640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

4636:
4637: FOR l_ccr_rep in c_ccr_rep
4638: LOOP
4639: l_report_count := l_report_count + 1;
4640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4641: IF l_ccr_rep.record_type ='1' THEN
4642: IF (l_title1set = false) THEN
4643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Returned ======================================================================= ');
4644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 4643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Returned ======================================================================= ');

4639: l_report_count := l_report_count + 1;
4640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4641: IF l_ccr_rep.record_type ='1' THEN
4642: IF (l_title1set = false) THEN
4643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Returned ======================================================================= ');
4644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('SSN/TIN',20,' ')||' '||rpad('Registration Status',30,' '));
4646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-------',20,' ')||' '||rpad('-------------------',30,' '));
4647: l_title1set := true;

Line 4644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4641: IF l_ccr_rep.record_type ='1' THEN
4642: IF (l_title1set = false) THEN
4643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Returned ======================================================================= ');
4644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('SSN/TIN',20,' ')||' '||rpad('Registration Status',30,' '));
4646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-------',20,' ')||' '||rpad('-------------------',30,' '));
4647: l_title1set := true;
4648: END IF;

Line 4645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('SSN/TIN',20,' ')||' '||rpad('Registration Status',30,' '));

4641: IF l_ccr_rep.record_type ='1' THEN
4642: IF (l_title1set = false) THEN
4643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Returned ======================================================================= ');
4644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('SSN/TIN',20,' ')||' '||rpad('Registration Status',30,' '));
4646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-------',20,' ')||' '||rpad('-------------------',30,' '));
4647: l_title1set := true;
4648: END IF;
4649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||

Line 4646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-------',20,' ')||' '||rpad('-------------------',30,' '));

4642: IF (l_title1set = false) THEN
4643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Returned ======================================================================= ');
4644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('SSN/TIN',20,' ')||' '||rpad('Registration Status',30,' '));
4646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-------',20,' ')||' '||rpad('-------------------',30,' '));
4647: l_title1set := true;
4648: END IF;
4649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||
4650: rpad(l_ccr_rep.reference2,10,' ')||' '||rpad(l_ccr_rep.reference3,20,' ')||' '||l_ccr_rep.reference4);

Line 4649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||

4645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('SSN/TIN',20,' ')||' '||rpad('Registration Status',30,' '));
4646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-------',20,' ')||' '||rpad('-------------------',30,' '));
4647: l_title1set := true;
4648: END IF;
4649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||
4650: rpad(l_ccr_rep.reference2,10,' ')||' '||rpad(l_ccr_rep.reference3,20,' ')||' '||l_ccr_rep.reference4);
4651: ELSIF l_ccr_rep.record_type ='2' THEN
4652: IF (l_title2set = false) THEN
4653: if p_xml_import = 'Y' then

Line 4654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'========================================================================== DUN/DUNS+4 ============================================================================ ');

4650: rpad(l_ccr_rep.reference2,10,' ')||' '||rpad(l_ccr_rep.reference3,20,' ')||' '||l_ccr_rep.reference4);
4651: ELSIF l_ccr_rep.record_type ='2' THEN
4652: IF (l_title2set = false) THEN
4653: if p_xml_import = 'Y' then
4654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'========================================================================== DUN/DUNS+4 ============================================================================ ');
4655: else
4656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== New DUN/DUNS+4 ============================================================================ ');
4657: end if;
4658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 4656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== New DUN/DUNS+4 ============================================================================ ');

4652: IF (l_title2set = false) THEN
4653: if p_xml_import = 'Y' then
4654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'========================================================================== DUN/DUNS+4 ============================================================================ ');
4655: else
4656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== New DUN/DUNS+4 ============================================================================ ');
4657: end if;
4658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||'Notes');
4660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||'-----');

Line 4658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'========================================================================== DUN/DUNS+4 ============================================================================ ');
4655: else
4656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== New DUN/DUNS+4 ============================================================================ ');
4657: end if;
4658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||'Notes');
4660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||'-----');
4661: l_title2set := true;
4662: END IF;

Line 4659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||'Notes');

4655: else
4656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== New DUN/DUNS+4 ============================================================================ ');
4657: end if;
4658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||'Notes');
4660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||'-----');
4661: l_title2set := true;
4662: END IF;
4663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);

Line 4660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||'-----');

4656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== New DUN/DUNS+4 ============================================================================ ');
4657: end if;
4658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||'Notes');
4660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||'-----');
4661: l_title2set := true;
4662: END IF;
4663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);
4664:

Line 4663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);

4659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||'Notes');
4660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||'-----');
4661: l_title2set := true;
4662: END IF;
4663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);
4664:
4665: ELSIF l_ccr_rep.record_type ='3' THEN
4666: IF (l_title3set = false) THEN
4667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Messages Reported ========================================================================== ');

Line 4667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Messages Reported ========================================================================== ');

4663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);
4664:
4665: ELSIF l_ccr_rep.record_type ='3' THEN
4666: IF (l_title3set = false) THEN
4667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Messages Reported ========================================================================== ');
4668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Source',20,' ')||' '||rpad('Message',90 ,' ')||' '||'Action');
4670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------',20,' ')||' '||rpad('-------',90 ,' ')||' '||'------');
4671: l_title3set := true;

Line 4668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4664:
4665: ELSIF l_ccr_rep.record_type ='3' THEN
4666: IF (l_title3set = false) THEN
4667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Messages Reported ========================================================================== ');
4668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Source',20,' ')||' '||rpad('Message',90 ,' ')||' '||'Action');
4670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------',20,' ')||' '||rpad('-------',90 ,' ')||' '||'------');
4671: l_title3set := true;
4672: END IF;

Line 4669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Source',20,' ')||' '||rpad('Message',90 ,' ')||' '||'Action');

4665: ELSIF l_ccr_rep.record_type ='3' THEN
4666: IF (l_title3set = false) THEN
4667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Messages Reported ========================================================================== ');
4668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Source',20,' ')||' '||rpad('Message',90 ,' ')||' '||'Action');
4670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------',20,' ')||' '||rpad('-------',90 ,' ')||' '||'------');
4671: l_title3set := true;
4672: END IF;
4673:

Line 4670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------',20,' ')||' '||rpad('-------',90 ,' ')||' '||'------');

4666: IF (l_title3set = false) THEN
4667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Messages Reported ========================================================================== ');
4668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('Source',20,' ')||' '||rpad('Message',90 ,' ')||' '||'Action');
4670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------',20,' ')||' '||rpad('-------',90 ,' ')||' '||'------');
4671: l_title3set := true;
4672: END IF;
4673:
4674: IF length(l_ccr_rep.reference1) > 90 THEN

Line 4679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.reference3,20,' ')||' '||substr(l_ccr_rep.reference1,i,90)||' '||l_ccr_rep.reference2);

4675: i := 1;
4676: WHILE i < length(l_ccr_rep.reference1)
4677: LOOP
4678: if i = 1 then
4679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.reference3,20,' ')||' '||substr(l_ccr_rep.reference1,i,90)||' '||l_ccr_rep.reference2);
4680: else
4681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(' ',20,' ')||' '||substr(l_ccr_rep.reference1,i,90));
4682: end if;
4683: i := i + 90;

Line 4681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(' ',20,' ')||' '||substr(l_ccr_rep.reference1,i,90));

4677: LOOP
4678: if i = 1 then
4679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.reference3,20,' ')||' '||substr(l_ccr_rep.reference1,i,90)||' '||l_ccr_rep.reference2);
4680: else
4681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(' ',20,' ')||' '||substr(l_ccr_rep.reference1,i,90));
4682: end if;
4683: i := i + 90;
4684: END LOOP;
4685: ELSE

Line 4686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.reference3,20,' ')||' '||rpad(l_ccr_rep.reference1,length(l_ccr_rep.reference1),' ')||' '||l_ccr_rep.reference2);

4682: end if;
4683: i := i + 90;
4684: END LOOP;
4685: ELSE
4686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.reference3,20,' ')||' '||rpad(l_ccr_rep.reference1,length(l_ccr_rep.reference1),' ')||' '||l_ccr_rep.reference2);
4687: END IF;
4688:
4689: --sthota
4690: ELSIF l_ccr_rep.record_type ='4' THEN

Line 4693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');

4689: --sthota
4690: ELSIF l_ccr_rep.record_type ='4' THEN
4691: IF (l_title4set = false) THEN
4692: if p_xml_import = 'Y' then
4693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4695: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4696: else
4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');

Line 4694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');

4690: ELSIF l_ccr_rep.record_type ='4' THEN
4691: IF (l_title4set = false) THEN
4692: if p_xml_import = 'Y' then
4693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4695: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4696: else
4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');

Line 4695: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');

4691: IF (l_title4set = false) THEN
4692: if p_xml_import = 'Y' then
4693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4695: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4696: else
4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4699: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');

Line 4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');

4693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4695: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4696: else
4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4699: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4700:
4701: end if;

Line 4698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');

4694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4695: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4696: else
4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4699: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4700:
4701: end if;
4702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 4699: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');

4695: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4696: else
4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== Active Vendors - DUN/DUNS+4 ============================================================ ');
4698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4699: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4700:
4701: end if;
4702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Vendor Id',90,' ')||' '||'Vendor Name');

Line 4702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'The following vendors are made active with the current Data Transfer program ');
4699: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4700:
4701: end if;
4702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Vendor Id',90,' ')||' '||'Vendor Name');
4704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('---------',90,' ')||' '||'-----------');
4705: l_title4set := true;
4706: END IF;

Line 4703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Vendor Id',90,' ')||' '||'Vendor Name');

4699: FND_FILE.put_line(FND_FILE.OUTPUT,'and an Invoice Validation program will be submitted automatically ');
4700:
4701: end if;
4702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Vendor Id',90,' ')||' '||'Vendor Name');
4704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('---------',90,' ')||' '||'-----------');
4705: l_title4set := true;
4706: END IF;
4707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);

Line 4704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('---------',90,' ')||' '||'-----------');

4700:
4701: end if;
4702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Vendor Id',90,' ')||' '||'Vendor Name');
4704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('---------',90,' ')||' '||'-----------');
4705: l_title4set := true;
4706: END IF;
4707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);
4708:

Line 4707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);

4703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Vendor Id',90,' ')||' '||'Vendor Name');
4704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('---------',90,' ')||' '||'-----------');
4705: l_title4set := true;
4706: END IF;
4707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(l_ccr_rep.duns_info,20,' ')||' '||rpad(substr(l_ccr_rep.reference1,1,90),90,' ')||' '||l_ccr_rep.reference2);
4708:
4709:
4710: END IF;
4711: END LOOP;

Line 4715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');

4711: END LOOP;
4712:
4713: --bug3958492
4714: if l_report_count = 0 then
4715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');
4716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4717: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('Taxpayer ID',20,' ')||' '||rpad('Registration Status',30,' '));
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-----------',20,' ')||' '||rpad('-------------------',30,' '));
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'None');

Line 4716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4712:
4713: --bug3958492
4714: if l_report_count = 0 then
4715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');
4716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4717: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('Taxpayer ID',20,' ')||' '||rpad('Registration Status',30,' '));
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-----------',20,' ')||' '||rpad('-------------------',30,' '));
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'None');
4720: end if;

Line 4717: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('Taxpayer ID',20,' ')||' '||rpad('Registration Status',30,' '));

4713: --bug3958492
4714: if l_report_count = 0 then
4715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');
4716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4717: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('Taxpayer ID',20,' ')||' '||rpad('Registration Status',30,' '));
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-----------',20,' ')||' '||rpad('-------------------',30,' '));
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'None');
4720: end if;
4721:

Line 4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-----------',20,' ')||' '||rpad('-------------------',30,' '));

4714: if l_report_count = 0 then
4715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');
4716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4717: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('Taxpayer ID',20,' ')||' '||rpad('Registration Status',30,' '));
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-----------',20,' ')||' '||rpad('-------------------',30,' '));
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'None');
4720: end if;
4721:
4722:

Line 4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'None');

4715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');
4716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4717: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('DUNS/DUNS+4 Number',20,' ')||' '||rpad('Legal Business Name',90,' ')||' '||rpad('CAGE Code',10,' ')||' '||rpad('Taxpayer ID',20,' ')||' '||rpad('Registration Status',30,' '));
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad('------------------',20,' ')||' '||rpad('-------------------',90,' ')||' '||rpad('---------',10,' ')||' '||rpad('-----------',20,' ')||' '||rpad('-------------------',30,' '));
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'None');
4720: end if;
4721:
4722:
4723: -- purge the temporary tables

Line 4734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');

4730: when others then
4731: retcode := -1;
4732: l_errbuf := 'Exception : Inside CCR MAIN ->'||SQLERRM;
4733: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'Inside CCR MAIN ',l_errbuf);
4734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');
4735: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'PROCESS ENDING WITH EXCEPTION:'|| l_errbuf);
4736: END Main;
4737:
4738: -------------------------------------------------------------------------------

Line 4735: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'PROCESS ENDING WITH EXCEPTION:'|| l_errbuf);

4731: retcode := -1;
4732: l_errbuf := 'Exception : Inside CCR MAIN ->'||SQLERRM;
4733: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'Inside CCR MAIN ',l_errbuf);
4734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'====================================================================== DUNS/DUNS+4 Processed ====================================================================== ');
4735: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'PROCESS ENDING WITH EXCEPTION:'|| l_errbuf);
4736: END Main;
4737:
4738: -------------------------------------------------------------------------------
4739: --Bug 8335551