DBA Data[Home] [Help]

APPS.JAI_PA_BILLING_PKG dependencies on FND_FILE

Line 1844: Fnd_File.put_line(Fnd_File.LOG, 'r_pa_tax.modvat_flag ='||r_pa_tax.modvat_flag

1840: ln_rec_tax_amt := null;
1841: ln_nrec_tax_amt := null;
1842: ln_lines_to_insert := 1; -- Loop controller to insert more than one lines for partially recoverable tax lines in PO
1843:
1844: Fnd_File.put_line(Fnd_File.LOG, 'r_pa_tax.modvat_flag ='||r_pa_tax.modvat_flag
1845: ||',r_tax_details.mod_cr_percentage='||r_tax_details.mod_cr_percentage
1846: );
1847:
1848: if r_pa_tax.modvat_flag = jai_constants.YES

Line 1862: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||

1858: ln_rec_tax_amt := nvl(ln_tax_amt,0) * (r_tax_details.mod_cr_percentage/100) ;
1859: ln_nrec_tax_amt := nvl(ln_tax_amt,0) - nvl(ln_rec_tax_amt,0);
1860:
1861: end if;
1862: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
1863: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
1864: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
1865: );
1866:

Line 1909: fnd_file.put_line(fnd_file.log, 'Before insert into jai_ap_source_doc_taxes ');

1905: lv_dist_code_combination_id := r_inv_dist.dist_code_combination_id;
1906:
1907: end if;
1908:
1909: fnd_file.put_line(fnd_file.log, 'Before insert into jai_ap_source_doc_taxes ');
1910:
1911: open gc_fnd_curr_precision (r_invs.invoice_currency_code);
1912: fetch gc_fnd_curr_precision into ln_precision;
1913: close gc_fnd_curr_precision;

Line 1919: fnd_file.put_line(fnd_file.log,

1915: if ln_precision is null then
1916: ln_precision := 0;
1917: end if;
1918:
1919: fnd_file.put_line(fnd_file.log,
1920: 'Before inserting into ap_invoice_distributions_all for distribution line no :'|| ln_dist_line_num);
1921:
1922: ln_request_id := fnd_profile.value ('CONC_REQUEST_ID');
1923: ln_program_application_id := r_inv_dist.program_application_id;

Line 2134: fnd_file.put_line(fnd_file.log, 'start of function update_payment_schedule');

2130: r_inv_curr c_get_inv_currency%rowtype;
2131:
2132: begin
2133:
2134: fnd_file.put_line(fnd_file.log, 'start of function update_payment_schedule');
2135:
2136: open c_total_payment_amt;
2137: fetch c_total_payment_amt into v_total_payment_amt;
2138: close c_total_payment_amt;

Line 2141: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'

2137: fetch c_total_payment_amt into v_total_payment_amt;
2138: close c_total_payment_amt;
2139:
2140: if nvl(v_total_payment_amt, -1) = -1 then
2141: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'
2142: || to_char(v_total_payment_amt));
2143: return false;
2144: end if;
2145:

Line 2201: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');

2197: return true;
2198:
2199: exception
2200: when others then
2201: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
2202: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
2203: return false;
2204: end update_payment_schedule;
2205:

Line 2202: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);

2198:
2199: exception
2200: when others then
2201: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
2202: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
2203: return false;
2204: end update_payment_schedule;
2205:
2206: /*------------------------------------------------------------------------------------------------------------*/

Line 2226: fnd_file.put_line(fnd_file.log, 'mrc api is not existing(update)');

2222:
2223: exception
2224: when others then
2225: if sqlcode = -6551 then -- object referred in EXECUTE IMMEDIATE is not available in the database
2226: fnd_file.put_line(fnd_file.log, 'mrc api is not existing(update)');
2227: else
2228: fnd_file.put_line(fnd_file.log, 'mrc api exists and different err(update)->'||sqlerrm);
2229: raise;
2230: end if;

Line 2228: fnd_file.put_line(fnd_file.log, 'mrc api exists and different err(update)->'||sqlerrm);

2224: when others then
2225: if sqlcode = -6551 then -- object referred in EXECUTE IMMEDIATE is not available in the database
2226: fnd_file.put_line(fnd_file.log, 'mrc api is not existing(update)');
2227: else
2228: fnd_file.put_line(fnd_file.log, 'mrc api exists and different err(update)->'||sqlerrm);
2229: raise;
2230: end if;
2231: end update_mrc_data;
2232:

Line 2256: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');

2252: when others then
2253: if sqlcode = -6550 then
2254: -- object referred in execute immediate is not available in the database
2255: null;
2256: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
2257: ELSE
2258: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
2259: RAISE;
2260: END IF;

Line 2258: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);

2254: -- object referred in execute immediate is not available in the database
2255: null;
2256: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
2257: ELSE
2258: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
2259: RAISE;
2260: END IF;
2261: end insert_mrc_data;
2262: