291: l_curr_code := okl_accounting_util.get_func_curr_code;
292: l_request_id := Fnd_Global.CONC_REQUEST_ID;
293:
294: --Product Title for the report: Oracle Leasing and Finance Management
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ', 63 , ' ' ) || fnd_message.get_string('OKL','OKL_TITLE') || RPAD(' ', 63 , ' ' ));
296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
297:
298: --Title of the report: Property Tax Statement
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ', 64 , ' ' ) || fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_TITLE') || RPAD(' ', 53 , ' ' ));
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ', 63 , ' ' ) || fnd_message.get_string('OKL','OKL_TITLE') || RPAD(' ', 63 , ' ' ));
296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
297:
298: --Title of the report: Property Tax Statement
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ', 64 , ' ' ) || fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_TITLE') || RPAD(' ', 53 , ' ' ));
300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length_len, '-' ));
301: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
303:
306: FETCH get_operating_unit_csr INTO l_op_unit;
307: CLOSE get_operating_unit_csr;
308:
309: --Display Operating unit, Request Id and input parameters. Display the input parameters only if they have been passed
310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(fnd_message.get_string( 'OKL', 'OKL_OPERATING_UNIT')|| ':',l_Contract#_len,' ')
311: || RPAD(l_op_unit,30,' ') || RPAD( ' ', 72 , ' ') || RPAD(fnd_message.get_string('FND', 'REQUEST ID'),25,' ') ||':'|| l_request_id);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string( 'AR', 'AR_NLS_AAP_REPORT_PARAMETERS')||':' );
313:
314: IF(p_cont_num_from IS NOT NULL) THEN
307: CLOSE get_operating_unit_csr;
308:
309: --Display Operating unit, Request Id and input parameters. Display the input parameters only if they have been passed
310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(fnd_message.get_string( 'OKL', 'OKL_OPERATING_UNIT')|| ':',l_Contract#_len,' ')
311: || RPAD(l_op_unit,30,' ') || RPAD( ' ', 72 , ' ') || RPAD(fnd_message.get_string('FND', 'REQUEST ID'),25,' ') ||':'|| l_request_id);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string( 'AR', 'AR_NLS_AAP_REPORT_PARAMETERS')||':' );
313:
314: IF(p_cont_num_from IS NOT NULL) THEN
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CNTRCT_FRM'),22,' ') ||':'|| p_cont_num_from );
308:
309: --Display Operating unit, Request Id and input parameters. Display the input parameters only if they have been passed
310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(fnd_message.get_string( 'OKL', 'OKL_OPERATING_UNIT')|| ':',l_Contract#_len,' ')
311: || RPAD(l_op_unit,30,' ') || RPAD( ' ', 72 , ' ') || RPAD(fnd_message.get_string('FND', 'REQUEST ID'),25,' ') ||':'|| l_request_id);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string( 'AR', 'AR_NLS_AAP_REPORT_PARAMETERS')||':' );
313:
314: IF(p_cont_num_from IS NOT NULL) THEN
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CNTRCT_FRM'),22,' ') ||':'|| p_cont_num_from );
316: END IF;
311: || RPAD(l_op_unit,30,' ') || RPAD( ' ', 72 , ' ') || RPAD(fnd_message.get_string('FND', 'REQUEST ID'),25,' ') ||':'|| l_request_id);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string( 'AR', 'AR_NLS_AAP_REPORT_PARAMETERS')||':' );
313:
314: IF(p_cont_num_from IS NOT NULL) THEN
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CNTRCT_FRM'),22,' ') ||':'|| p_cont_num_from );
316: END IF;
317: IF(p_cont_num_to IS NOT NULL) THEN
318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CNTRCT_TO'),22,' ') ||':'|| p_cont_num_to);
319: END IF;
314: IF(p_cont_num_from IS NOT NULL) THEN
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CNTRCT_FRM'),22,' ') ||':'|| p_cont_num_from );
316: END IF;
317: IF(p_cont_num_to IS NOT NULL) THEN
318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CNTRCT_TO'),22,' ') ||':'|| p_cont_num_to);
319: END IF;
320: IF(p_asset_name_from IS NOT NULL) THEN
321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_ASSET_FRM'),22,' ')||':' ||p_asset_name_from);
322: END IF;
317: IF(p_cont_num_to IS NOT NULL) THEN
318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CNTRCT_TO'),22,' ') ||':'|| p_cont_num_to);
319: END IF;
320: IF(p_asset_name_from IS NOT NULL) THEN
321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_ASSET_FRM'),22,' ')||':' ||p_asset_name_from);
322: END IF;
323: IF(p_asset_name_to IS NOT NULL) THEN
324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_ASSET_TO'),22,' ')||':'||p_asset_name_to );
325: END IF;
320: IF(p_asset_name_from IS NOT NULL) THEN
321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_ASSET_FRM'),22,' ')||':' ||p_asset_name_from);
322: END IF;
323: IF(p_asset_name_to IS NOT NULL) THEN
324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || RPAD(fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_ASSET_TO'),22,' ')||':'||p_asset_name_to );
325: END IF;
326:
327: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
328:
326:
327: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
328:
329: --Display the Titles Actual Property Tax and Billing Details
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_ACT_TITLE') || RPAD(' ',58, ' ') || fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_BILL_TITLE') );
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-')||' '||RPAD('-',86,'-'));
332:
333: --Display all the column headers in the table
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CTR_NUM'),l_Contract#_len,'TITLE')||
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',l_Contract#_len, ' ') || fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_ACT_TITLE') || RPAD(' ',58, ' ') || fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_BILL_TITLE') );
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-')||' '||RPAD('-',86,'-'));
332:
333: --Display all the column headers in the table
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CTR_NUM'),l_Contract#_len,'TITLE')||
335: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_ASSET_NUMBER' ),l_asset_name_len,'TITLE')||
336: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_JURISDCTN') ,l_jurisd_name_len,'TITLE')||
337: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_LIEN_DATE') ,l_lien_date_len,'TITLE')||
338: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_IMP' ) ,l_apt_amount_len,'TITLE')||
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-')||' '||RPAD('-',86,'-'));
332:
333: --Display all the column headers in the table
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CTR_NUM'),l_Contract#_len,'TITLE')||
335: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_ASSET_NUMBER' ),l_asset_name_len,'TITLE')||
336: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_JURISDCTN') ,l_jurisd_name_len,'TITLE')||
337: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_LIEN_DATE') ,l_lien_date_len,'TITLE')||
338: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_IMP' ) ,l_apt_amount_len,'TITLE')||
339: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_BILL') ,l_amt_billable_len,'TITLE')||
332:
333: --Display all the column headers in the table
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CTR_NUM'),l_Contract#_len,'TITLE')||
335: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_ASSET_NUMBER' ),l_asset_name_len,'TITLE')||
336: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_JURISDCTN') ,l_jurisd_name_len,'TITLE')||
337: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_LIEN_DATE') ,l_lien_date_len,'TITLE')||
338: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_IMP' ) ,l_apt_amount_len,'TITLE')||
339: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_BILL') ,l_amt_billable_len,'TITLE')||
340: RPAD( ' ', 2, ' ') ||
333: --Display all the column headers in the table
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CTR_NUM'),l_Contract#_len,'TITLE')||
335: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_ASSET_NUMBER' ),l_asset_name_len,'TITLE')||
336: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_JURISDCTN') ,l_jurisd_name_len,'TITLE')||
337: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_LIEN_DATE') ,l_lien_date_len,'TITLE')||
338: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_IMP' ) ,l_apt_amount_len,'TITLE')||
339: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_BILL') ,l_amt_billable_len,'TITLE')||
340: RPAD( ' ', 2, ' ') ||
341: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_PURP' ) ,l_strm_purpose_len,'TITLE')||
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_CTR_NUM'),l_Contract#_len,'TITLE')||
335: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_ASSET_NUMBER' ),l_asset_name_len,'TITLE')||
336: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_JURISDCTN') ,l_jurisd_name_len,'TITLE')||
337: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_LIEN_DATE') ,l_lien_date_len,'TITLE')||
338: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_IMP' ) ,l_apt_amount_len,'TITLE')||
339: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_BILL') ,l_amt_billable_len,'TITLE')||
340: RPAD( ' ', 2, ' ') ||
341: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_PURP' ) ,l_strm_purpose_len,'TITLE')||
342: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_TYPE') ,l_strm_type_len,'TITLE')||
335: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_ASSET_NUMBER' ),l_asset_name_len,'TITLE')||
336: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_JURISDCTN') ,l_jurisd_name_len,'TITLE')||
337: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_LIEN_DATE') ,l_lien_date_len,'TITLE')||
338: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_IMP' ) ,l_apt_amount_len,'TITLE')||
339: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_BILL') ,l_amt_billable_len,'TITLE')||
340: RPAD( ' ', 2, ' ') ||
341: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_PURP' ) ,l_strm_purpose_len,'TITLE')||
342: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_TYPE') ,l_strm_type_len,'TITLE')||
343: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_DATE'),l_date_len,'TITLE')||
337: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_LIEN_DATE') ,l_lien_date_len,'TITLE')||
338: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_IMP' ) ,l_apt_amount_len,'TITLE')||
339: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_BILL') ,l_amt_billable_len,'TITLE')||
340: RPAD( ' ', 2, ' ') ||
341: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_PURP' ) ,l_strm_purpose_len,'TITLE')||
342: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_TYPE') ,l_strm_type_len,'TITLE')||
343: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_DATE'),l_date_len,'TITLE')||
344: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_AMT' ) ,l_bill_amount_len,'TITLE'));
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
338: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_IMP' ) ,l_apt_amount_len,'TITLE')||
339: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_BILL') ,l_amt_billable_len,'TITLE')||
340: RPAD( ' ', 2, ' ') ||
341: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_PURP' ) ,l_strm_purpose_len,'TITLE')||
342: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_TYPE') ,l_strm_type_len,'TITLE')||
343: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_DATE'),l_date_len,'TITLE')||
344: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_AMT' ) ,l_bill_amount_len,'TITLE'));
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
339: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_AMT_BILL') ,l_amt_billable_len,'TITLE')||
340: RPAD( ' ', 2, ' ') ||
341: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_PURP' ) ,l_strm_purpose_len,'TITLE')||
342: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_TYPE') ,l_strm_type_len,'TITLE')||
343: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_DATE'),l_date_len,'TITLE')||
344: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_AMT' ) ,l_bill_amount_len,'TITLE'));
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
347:
340: RPAD( ' ', 2, ' ') ||
341: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_PURP' ) ,l_strm_purpose_len,'TITLE')||
342: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_BPD_PTAX_RPT_STRM_TYPE') ,l_strm_type_len,'TITLE')||
343: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_DATE'),l_date_len,'TITLE')||
344: GET_PROPER_LENGTH( fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_AMT' ) ,l_bill_amount_len,'TITLE'));
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
347:
348: --Open the cursor and fetch all contracts and assets in the specified range
418: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
419: --l_excs_amt := l_act_amt - l_est_amt - l_adjst_amt;
420: l_excs_amt := (l_act_amt + l_est_amt)- l_imp_amt; -- l_act_amt - l_est_amt - l_adjst_amt;
421: IF( l_excs_amt < 0) THEN
422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_SHORT'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));
423: ELSE
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_EXCESS'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));
425: END IF;
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
420: l_excs_amt := (l_act_amt + l_est_amt)- l_imp_amt; -- l_act_amt - l_est_amt - l_adjst_amt;
421: IF( l_excs_amt < 0) THEN
422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_SHORT'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));
423: ELSE
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_EXCESS'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));
425: END IF;
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
427: -- END IF;
428: END IF;