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

Line 168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' ', 54, ' ') || (' Page : '||cntr||' ') || lpad(' ', 54, ' '));

164: l_country;
165: CLOSE bill_addr_csr;
166:
167:
168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' ', 54, ' ') || ('** Page : '||cntr||' **') || lpad(' ', 54, ' '));
169: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 121, '-'));
170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Number', 20, ' ') || ': ' || rpad (hdr.consolidated_invoice_number,30,' ') || rPAD('Currency ', 20, ' ') || ': ' || rPAD(l_curr_descr, 47, ' '));
171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Customer Account', 20, ' ') || ': ' || rpad(l_customer_number,30,' ') || rPAD('Customer Name ', 20, ' ') || ': ' || rPAD(l_customer_name, 47, ' '));
172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Date', 20, ' ') || ': '|| rPAD( hdr.date_consolidated , 99, ' ') );

Line 169: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 121, '-'));

165: CLOSE bill_addr_csr;
166:
167:
168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' ', 54, ' ') || ('** Page : '||cntr||' **') || lpad(' ', 54, ' '));
169: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 121, '-'));
170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Number', 20, ' ') || ': ' || rpad (hdr.consolidated_invoice_number,30,' ') || rPAD('Currency ', 20, ' ') || ': ' || rPAD(l_curr_descr, 47, ' '));
171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Customer Account', 20, ' ') || ': ' || rpad(l_customer_number,30,' ') || rPAD('Customer Name ', 20, ' ') || ': ' || rPAD(l_customer_name, 47, ' '));
172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Date', 20, ' ') || ': '|| rPAD( hdr.date_consolidated , 99, ' ') );
173:

Line 170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Number', 20, ' ') || ': ' || rpad (hdr.consolidated_invoice_number,30,' ') || rPAD('Currency ', 20, ' ') || ': ' || rPAD(l_curr_descr, 47, ' '));

166:
167:
168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' ', 54, ' ') || ('** Page : '||cntr||' **') || lpad(' ', 54, ' '));
169: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 121, '-'));
170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Number', 20, ' ') || ': ' || rpad (hdr.consolidated_invoice_number,30,' ') || rPAD('Currency ', 20, ' ') || ': ' || rPAD(l_curr_descr, 47, ' '));
171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Customer Account', 20, ' ') || ': ' || rpad(l_customer_number,30,' ') || rPAD('Customer Name ', 20, ' ') || ': ' || rPAD(l_customer_name, 47, ' '));
172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Date', 20, ' ') || ': '|| rPAD( hdr.date_consolidated , 99, ' ') );
173:
174: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Billing Address', 20, ' ')||': '||rPAD( l_addr1 , 99, ' '));

Line 171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Customer Account', 20, ' ') || ': ' || rpad(l_customer_number,30,' ') || rPAD('Customer Name ', 20, ' ') || ': ' || rPAD(l_customer_name, 47, ' '));

167:
168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' ', 54, ' ') || ('** Page : '||cntr||' **') || lpad(' ', 54, ' '));
169: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 121, '-'));
170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Number', 20, ' ') || ': ' || rpad (hdr.consolidated_invoice_number,30,' ') || rPAD('Currency ', 20, ' ') || ': ' || rPAD(l_curr_descr, 47, ' '));
171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Customer Account', 20, ' ') || ': ' || rpad(l_customer_number,30,' ') || rPAD('Customer Name ', 20, ' ') || ': ' || rPAD(l_customer_name, 47, ' '));
172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Date', 20, ' ') || ': '|| rPAD( hdr.date_consolidated , 99, ' ') );
173:
174: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Billing Address', 20, ' ')||': '||rPAD( l_addr1 , 99, ' '));
175:

Line 172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Date', 20, ' ') || ': '|| rPAD( hdr.date_consolidated , 99, ' ') );

168: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' ', 54, ' ') || ('** Page : '||cntr||' **') || lpad(' ', 54, ' '));
169: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 121, '-'));
170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Number', 20, ' ') || ': ' || rpad (hdr.consolidated_invoice_number,30,' ') || rPAD('Currency ', 20, ' ') || ': ' || rPAD(l_curr_descr, 47, ' '));
171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Customer Account', 20, ' ') || ': ' || rpad(l_customer_number,30,' ') || rPAD('Customer Name ', 20, ' ') || ': ' || rPAD(l_customer_name, 47, ' '));
172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Date', 20, ' ') || ': '|| rPAD( hdr.date_consolidated , 99, ' ') );
173:
174: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Billing Address', 20, ' ')||': '||rPAD( l_addr1 , 99, ' '));
175:
176: IF ( l_addr2 IS NOT NULL ) THEN

Line 174: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Billing Address', 20, ' ')||': '||rPAD( l_addr1 , 99, ' '));

170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Number', 20, ' ') || ': ' || rpad (hdr.consolidated_invoice_number,30,' ') || rPAD('Currency ', 20, ' ') || ': ' || rPAD(l_curr_descr, 47, ' '));
171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Customer Account', 20, ' ') || ': ' || rpad(l_customer_number,30,' ') || rPAD('Customer Name ', 20, ' ') || ': ' || rPAD(l_customer_name, 47, ' '));
172: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Invoice Date', 20, ' ') || ': '|| rPAD( hdr.date_consolidated , 99, ' ') );
173:
174: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Billing Address', 20, ' ')||': '||rPAD( l_addr1 , 99, ' '));
175:
176: IF ( l_addr2 IS NOT NULL ) THEN
177: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_addr2 , 99, ' ') );
178: END IF;

Line 177: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_addr2 , 99, ' ') );

173:
174: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Billing Address', 20, ' ')||': '||rPAD( l_addr1 , 99, ' '));
175:
176: IF ( l_addr2 IS NOT NULL ) THEN
177: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_addr2 , 99, ' ') );
178: END IF;
179: IF ( l_addr3 IS NOT NULL ) THEN
180: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_addr3 , 99, ' ') );
181: END IF;

Line 180: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_addr3 , 99, ' ') );

176: IF ( l_addr2 IS NOT NULL ) THEN
177: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_addr2 , 99, ' ') );
178: END IF;
179: IF ( l_addr3 IS NOT NULL ) THEN
180: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_addr3 , 99, ' ') );
181: END IF;
182: IF ( l_addr4 IS NOT NULL ) THEN
183: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ')|| rPAD( l_addr4 , 99, ' ') );
184: END IF;

Line 183: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ')|| rPAD( l_addr4 , 99, ' ') );

179: IF ( l_addr3 IS NOT NULL ) THEN
180: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_addr3 , 99, ' ') );
181: END IF;
182: IF ( l_addr4 IS NOT NULL ) THEN
183: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ')|| rPAD( l_addr4 , 99, ' ') );
184: END IF;
185: IF ( l_city IS NOT NULL ) THEN
186: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_city , 99, ' ') );
187: END IF;

Line 186: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_city , 99, ' ') );

182: IF ( l_addr4 IS NOT NULL ) THEN
183: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ')|| rPAD( l_addr4 , 99, ' ') );
184: END IF;
185: IF ( l_city IS NOT NULL ) THEN
186: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_city , 99, ' ') );
187: END IF;
188: IF ( l_state IS NOT NULL ) THEN
189: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_state , 99, ' ') );
190: END IF;

Line 189: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_state , 99, ' ') );

185: IF ( l_city IS NOT NULL ) THEN
186: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_city , 99, ' ') );
187: END IF;
188: IF ( l_state IS NOT NULL ) THEN
189: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_state , 99, ' ') );
190: END IF;
191: IF ( l_postal_code IS NOT NULL ) THEN
192: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_postal_code , 99, ' ') );
193: END IF;

Line 192: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_postal_code , 99, ' ') );

188: IF ( l_state IS NOT NULL ) THEN
189: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_state , 99, ' ') );
190: END IF;
191: IF ( l_postal_code IS NOT NULL ) THEN
192: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_postal_code , 99, ' ') );
193: END IF;
194: IF ( l_country IS NOT NULL ) THEN
195: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_country , 99, ' ') );
196: END IF;

Line 195: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_country , 99, ' ') );

191: IF ( l_postal_code IS NOT NULL ) THEN
192: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_postal_code , 99, ' ') );
193: END IF;
194: IF ( l_country IS NOT NULL ) THEN
195: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_country , 99, ' ') );
196: END IF;
197:
198: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 121, ' '));
199: --Process all lines

Line 198: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 121, ' '));

194: IF ( l_country IS NOT NULL ) THEN
195: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 22, ' ') || rPAD( l_country , 99, ' ') );
196: END IF;
197:
198: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 121, ' '));
199: --Process all lines
200: l_khr_id := NULL;
201: l_kle_id := NULL;
202: FOR lines IN cons_line(hdr.id) LOOP

Line 249: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));

245: CLOSE asset_name;
246:
247: IF (l_flag = 'Y') THEN
248: l_flag := 'N';
249: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
250: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract', 30, ' ') ||rpad('Asset Number', 15, ' ') ||rpad('Asset Description', 31, ' ')|| rpad('Item', 20, ' ') || lpad('Amount',25,' '));
251: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,LPAD('-', 121, '-'));
252:
253: END IF;

Line 250: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract', 30, ' ') ||rpad('Asset Number', 15, ' ') ||rpad('Asset Description', 31, ' ')|| rpad('Item', 20, ' ') || lpad('Amount',25,' '));

246:
247: IF (l_flag = 'Y') THEN
248: l_flag := 'N';
249: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
250: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract', 30, ' ') ||rpad('Asset Number', 15, ' ') ||rpad('Asset Description', 31, ' ')|| rpad('Item', 20, ' ') || lpad('Amount',25,' '));
251: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,LPAD('-', 121, '-'));
252:
253: END IF;
254: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number, 30,' ') ||rpad(nvl(l_asset_name, ' '),15,' ')||rpad(nvl(l_asset_descr, ' '),31,' ')||rpad(l_line_name,20,' ')|| lpad(l_formatted_amount,25,' '));

Line 251: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,LPAD('-', 121, '-'));

247: IF (l_flag = 'Y') THEN
248: l_flag := 'N';
249: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
250: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract', 30, ' ') ||rpad('Asset Number', 15, ' ') ||rpad('Asset Description', 31, ' ')|| rpad('Item', 20, ' ') || lpad('Amount',25,' '));
251: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,LPAD('-', 121, '-'));
252:
253: END IF;
254: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number, 30,' ') ||rpad(nvl(l_asset_name, ' '),15,' ')||rpad(nvl(l_asset_descr, ' '),31,' ')||rpad(l_line_name,20,' ')|| lpad(l_formatted_amount,25,' '));
255: ELSIF ((l_format_type = '2') OR (lines.khr_id IS NOT NULL AND lines.kle_id IS NULL)) THEN

Line 254: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number, 30,' ') ||rpad(nvl(l_asset_name, ' '),15,' ')||rpad(nvl(l_asset_descr, ' '),31,' ')||rpad(l_line_name,20,' ')|| lpad(l_formatted_amount,25,' '));

250: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract', 30, ' ') ||rpad('Asset Number', 15, ' ') ||rpad('Asset Description', 31, ' ')|| rpad('Item', 20, ' ') || lpad('Amount',25,' '));
251: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,LPAD('-', 121, '-'));
252:
253: END IF;
254: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number, 30,' ') ||rpad(nvl(l_asset_name, ' '),15,' ')||rpad(nvl(l_asset_descr, ' '),31,' ')||rpad(l_line_name,20,' ')|| lpad(l_formatted_amount,25,' '));
255: ELSIF ((l_format_type = '2') OR (lines.khr_id IS NOT NULL AND lines.kle_id IS NULL)) THEN
256:
257: --setting the format type
258: IF(NOT(l_format_set)) THEN

Line 273: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));

269: END IF;
270: IF (l_flag = 'Y') THEN
271: l_flag := 'N';
272:
273: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract' ,45, ' ')||rpad('Item' ,51,' ')||lpad('Amount',25,' '));
275: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
276: END IF;
277: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number,45,' ')||rpad(l_line_name,51,' ')||lpad(l_formatted_amount,25,' ') );

Line 274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract' ,45, ' ')||rpad('Item' ,51,' ')||lpad('Amount',25,' '));

270: IF (l_flag = 'Y') THEN
271: l_flag := 'N';
272:
273: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract' ,45, ' ')||rpad('Item' ,51,' ')||lpad('Amount',25,' '));
275: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
276: END IF;
277: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number,45,' ')||rpad(l_line_name,51,' ')||lpad(l_formatted_amount,25,' ') );
278: ELSE

Line 275: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));

271: l_flag := 'N';
272:
273: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract' ,45, ' ')||rpad('Item' ,51,' ')||lpad('Amount',25,' '));
275: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
276: END IF;
277: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number,45,' ')||rpad(l_line_name,51,' ')||lpad(l_formatted_amount,25,' ') );
278: ELSE
279: IF (l_flag = 'Y') THEN

Line 277: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number,45,' ')||rpad(l_line_name,51,' ')||lpad(l_formatted_amount,25,' ') );

273: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Lease Contract' ,45, ' ')||rpad('Item' ,51,' ')||lpad('Amount',25,' '));
275: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
276: END IF;
277: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number,45,' ')||rpad(l_line_name,51,' ')||lpad(l_formatted_amount,25,' ') );
278: ELSE
279: IF (l_flag = 'Y') THEN
280: l_flag := 'N';
281: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));

Line 281: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));

277: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(l_contract_number,45,' ')||rpad(l_line_name,51,' ')||lpad(l_formatted_amount,25,' ') );
278: ELSE
279: IF (l_flag = 'Y') THEN
280: l_flag := 'N';
281: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
282: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Item' ,96,' ') ||lpad('Amount',25,' '));
283: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
284: END IF;
285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(l_line_name,96,' ') || lpad(l_formatted_amount,25,' '));

Line 282: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Item' ,96,' ') ||lpad('Amount',25,' '));

278: ELSE
279: IF (l_flag = 'Y') THEN
280: l_flag := 'N';
281: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
282: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Item' ,96,' ') ||lpad('Amount',25,' '));
283: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
284: END IF;
285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(l_line_name,96,' ') || lpad(l_formatted_amount,25,' '));
286: END IF;

Line 283: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));

279: IF (l_flag = 'Y') THEN
280: l_flag := 'N';
281: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
282: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Item' ,96,' ') ||lpad('Amount',25,' '));
283: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
284: END IF;
285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(l_line_name,96,' ') || lpad(l_formatted_amount,25,' '));
286: END IF;
287:

Line 285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(l_line_name,96,' ') || lpad(l_formatted_amount,25,' '));

281: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
282: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad('Item' ,96,' ') ||lpad('Amount',25,' '));
283: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('-', 121, '-'));
284: END IF;
285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(l_line_name,96,' ') || lpad(l_formatted_amount,25,' '));
286: END IF;
287:
288: END LOOP;
289:

Line 290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(' ', 95, ' ') || RPAD('-', 26, '-') );

286: END IF;
287:
288: END LOOP;
289:
290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(' ', 95, ' ') || RPAD('-', 26, '-') );
291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('Invoice Total : ', 96, ' ') ||lpad(okl_accounting_util.format_amount(hdr.amount,hdr.currency_code), 25 ,' ') );
292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,RPAD('=', 121, '='));
293:
294: --Start afresh for next invoice

Line 291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('Invoice Total : ', 96, ' ') ||lpad(okl_accounting_util.format_amount(hdr.amount,hdr.currency_code), 25 ,' ') );

287:
288: END LOOP;
289:
290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(' ', 95, ' ') || RPAD('-', 26, '-') );
291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('Invoice Total : ', 96, ' ') ||lpad(okl_accounting_util.format_amount(hdr.amount,hdr.currency_code), 25 ,' ') );
292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,RPAD('=', 121, '='));
293:
294: --Start afresh for next invoice
295: l_khr_id := NULL;

Line 292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,RPAD('=', 121, '='));

288: END LOOP;
289:
290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(' ', 95, ' ') || RPAD('-', 26, '-') );
291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, LPAD('Invoice Total : ', 96, ' ') ||lpad(okl_accounting_util.format_amount(hdr.amount,hdr.currency_code), 25 ,' ') );
292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,RPAD('=', 121, '='));
293:
294: --Start afresh for next invoice
295: l_khr_id := NULL;
296: l_kle_id := NULL;

Line 302: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error in Printing Consolidated Bill : '||SQLERRM);

298: x_return_status := okl_api.g_ret_sts_success;
299: EXCEPTION
300: WHEN OTHERS THEN
301: x_return_status := okl_api.g_ret_sts_unexp_error;
302: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error in Printing Consolidated Bill : '||SQLERRM);
303: END print_cons_bill;
304:
305:
306:

Line 330: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Starting Consolidated Bill Printing ... ');

326: lx_return_status VARCHAR2(1);
327:
328: BEGIN
329:
330: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Starting Consolidated Bill Printing ... ');
331:
332:
333:
334: Okl_Print_Cons_Bill.print_cons_bill(

Line 341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End Consolidated Bill Printing. ');

337: x_msg_count => lx_msg_count,
338: x_msg_data => errbuf
339: );
340:
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End Consolidated Bill Printing. ');
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error Counts = '||lx_msg_count);

Line 342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');

338: x_msg_data => errbuf
339: );
340:
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End Consolidated Bill Printing. ');
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error Counts = '||lx_msg_count);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');

Line 343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);

339: );
340:
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End Consolidated Bill Printing. ');
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error Counts = '||lx_msg_count);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');
347: BEGIN

Line 344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

340:
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End Consolidated Bill Printing. ');
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error Counts = '||lx_msg_count);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');
347: BEGIN
348: IF ( lx_msg_count > 0 ) THEN

Line 345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error Counts = '||lx_msg_count);

341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End Consolidated Bill Printing. ');
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error Counts = '||lx_msg_count);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');
347: BEGIN
348: IF ( lx_msg_count > 0 ) THEN
349: FOR i IN 1..lx_msg_count LOOP

Line 346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');

342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error Counts = '||lx_msg_count);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');
347: BEGIN
348: IF ( lx_msg_count > 0 ) THEN
349: FOR i IN 1..lx_msg_count LOOP
350:

Line 356: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,i || ': ' || lx_msg_data);

352: p_encoded => 'F',
353: p_data => lx_msg_data,
354: p_msg_index_out => l_msg_index_out);
355:
356: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,i || ': ' || lx_msg_data);
357: END LOOP;
358: END IF;
359: EXCEPTION
360: WHEN OTHERS THEN

Line 361: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

357: END LOOP;
358: END IF;
359: EXCEPTION
360: WHEN OTHERS THEN
361: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
362:
363: END;
364: EXCEPTION
365: WHEN OTHERS THEN