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_PROPERTY_TAX_STATEMENT_PVT dependencies on FND_FILE

Line 295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ', 63 , ' ' ) || fnd_message.get_string('OKL','OKL_TITLE') || RPAD(' ', 63 , ' ' ));

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 Lease 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 , ' ' ));

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

292: l_request_id := Fnd_Global.CONC_REQUEST_ID;
293:
294: --Product Title for the report: Oracle Lease 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 , ' ' ));
300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length_len, '-' ));

Line 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:

Line 300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length_len, '-' ));

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:
304: --Fetch Operating unit from the profile

Line 301: 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:
304: --Fetch Operating unit from the profile
305: OPEN get_operating_unit_csr;

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

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:
304: --Fetch Operating unit from the profile
305: OPEN get_operating_unit_csr;
306: FETCH get_operating_unit_csr INTO l_op_unit;

Line 310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(fnd_message.get_string( 'OKL', 'OKL_OPERATING_UNIT')|| ':',l_Contract#_len,' ')

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

Line 312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string( 'AR', 'AR_NLS_AAP_REPORT_PARAMETERS')||':' );

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;

Line 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 );

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;

Line 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);

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;

Line 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);

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;

Line 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 );

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:

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

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:
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,'-'));

Line 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') );

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')||

Line 331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-')||' '||RPAD('-',86,'-'));

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')||
335: GET_PROPER_LENGTH( fnd_message.get_string('OKL', 'OKL_ASSET_NUMBER' ),l_asset_name_len,'TITLE')||

Line 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')||

Line 345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));

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
349: FOR r_cntrct_asst_id_csr IN c_cntrct_asst_id_csr(p_cont_num_from,p_cont_num_to,p_asset_name_from,p_asset_name_to) LOOP

Line 346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));

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
349: FOR r_cntrct_asst_id_csr IN c_cntrct_asst_id_csr(p_cont_num_from,p_cont_num_to,p_asset_name_from,p_asset_name_to) LOOP
350: --get single contract and its asset from cursor

Line 365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(p_act_ppt_tax.contract_number,l_Contract#_len,'DATA')||

361: some_data := 'N';
362: --Fetch Actual property tax for the asset
363: FOR p_act_ppt_tax IN c_act_ppt_tax(l_cont_id,l_asset_id) LOOP
364: some_data := 'Y';
365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(p_act_ppt_tax.contract_number,l_Contract#_len,'DATA')||
366: GET_PROPER_LENGTH(p_act_ppt_tax.name,l_asset_name_len,'DATA')||
367: GET_PROPER_LENGTH(p_act_ppt_tax.JURSDCTN_NAME ,l_jurisd_name_len,'DATA')||
368: GET_PROPER_LENGTH(p_act_ppt_tax.lien_date ,l_lien_date_len,'DATA')||
369: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount_imp,l_curr_code) ,l_apt_amount_len,'DATA')||

Line 382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(p_estm_ppt_tax.contract_number,l_Contract#_len,'DATA')||

378: END LOOP;
379: --Fetch Estimated property tax for the asset
380: FOR p_estm_ppt_tax IN c_estm_ppt_tax(l_cont_id,l_asset_id) LOOP
381: some_data := 'Y';
382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(p_estm_ppt_tax.contract_number,l_Contract#_len,'DATA')||
383: GET_PROPER_LENGTH(p_estm_ppt_tax.name,l_asset_name_len,'DATA')||
384: GET_PROPER_LENGTH(NULL ,l_jurisd_name_len,'DATA')||
385: GET_PROPER_LENGTH(NULL ,l_lien_date_len,'DATA')||
386: GET_PROPER_LENGTH(NULL,l_apt_amount_len,'DATA')||

Line 398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(p_adjst_ppt_tax.contract_number,l_Contract#_len,'DATA')||

394: END LOOP;
395: --Fetch Adjusted property tax for the asset
396: FOR p_adjst_ppt_tax IN c_adjst_ppt_tax(l_cont_id,l_asset_id) LOOP
397: some_data := 'Y';
398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(p_adjst_ppt_tax.contract_number,l_Contract#_len,'DATA')||
399: GET_PROPER_LENGTH(p_adjst_ppt_tax.name,l_asset_name_len,'DATA')||
400: GET_PROPER_LENGTH(NULL ,l_jurisd_name_len,'DATA')||
401: GET_PROPER_LENGTH(NULL ,l_lien_date_len,'DATA')||
402: GET_PROPER_LENGTH(NULL,l_apt_amount_len,'DATA')||

Line 414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));

410: END LOOP;
411:
412: -- To avoid unnecessary printing of lines
413: IF some_data = 'Y' THEN
414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
415:
416:
417: -- IF(l_act_amt <> 0 OR l_est_amt <>0 OR l_adjst_amt <> 0) THEN
418: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));

Line 418: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));

414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
415:
416:
417: -- IF(l_act_amt <> 0 OR l_est_amt <>0 OR l_adjst_amt <> 0) THEN
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));

Line 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));

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,'-' ));

Line 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));

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;

Line 426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));

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;
429: END LOOP;
430: EXCEPTION

Line 434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);

430: EXCEPTION
431: WHEN OTHERS THEN
432: p_errbuf := SQLERRM;
433: p_retcode := 2;
434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
435: IF(SQLCODE <> -20001) THEN
436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
437: RAISE;
438: ELSE

Line 436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);

432: p_errbuf := SQLERRM;
433: p_retcode := 2;
434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
435: IF(SQLCODE <> -20001) THEN
436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
437: RAISE;
438: ELSE
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
440: APP_EXCEPTION.RAISE_EXCEPTION;

Line 439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);

435: IF(SQLCODE <> -20001) THEN
436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
437: RAISE;
438: ELSE
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
440: APP_EXCEPTION.RAISE_EXCEPTION;
441: END IF;
442: END do_report;
443: