DBA Data[Home] [Help]

APPS.JAI_PA_BILLING_PKG dependencies on FND_FILE

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

1804: ln_rec_tax_amt := null;
1805: ln_nrec_tax_amt := null;
1806: ln_lines_to_insert := 1; -- Loop controller to insert more than one lines for partially recoverable tax lines in PO
1807:
1808: Fnd_File.put_line(Fnd_File.LOG, 'r_pa_tax.modvat_flag ='||r_pa_tax.modvat_flag
1809: ||',r_tax_details.mod_cr_percentage='||r_tax_details.mod_cr_percentage
1810: );
1811:
1812: if r_pa_tax.modvat_flag = jai_constants.YES

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

1822: ln_rec_tax_amt := nvl(ln_tax_amt,0) * (r_tax_details.mod_cr_percentage/100) ;
1823: ln_nrec_tax_amt := nvl(ln_tax_amt,0) - nvl(ln_rec_tax_amt,0);
1824:
1825: end if;
1826: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
1827: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
1828: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
1829: );
1830:

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

1869: lv_dist_code_combination_id := r_inv_dist.dist_code_combination_id;
1870:
1871: end if;
1872:
1873: fnd_file.put_line(fnd_file.log, 'Before insert into jai_ap_source_doc_taxes ');
1874:
1875: open gc_fnd_curr_precision (r_invs.invoice_currency_code);
1876: fetch gc_fnd_curr_precision into ln_precision;
1877: close gc_fnd_curr_precision;

Line 1883: fnd_file.put_line(fnd_file.log,

1879: if ln_precision is null then
1880: ln_precision := 0;
1881: end if;
1882:
1883: fnd_file.put_line(fnd_file.log,
1884: 'Before inserting into ap_invoice_distributions_all for distribution line no :'|| ln_dist_line_num);
1885:
1886: ln_request_id := fnd_profile.value ('CONC_REQUEST_ID');
1887: ln_program_application_id := r_inv_dist.program_application_id;

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

2094: r_inv_curr c_get_inv_currency%rowtype;
2095:
2096: begin
2097:
2098: fnd_file.put_line(fnd_file.log, 'start of function update_payment_schedule');
2099:
2100: open c_total_payment_amt;
2101: fetch c_total_payment_amt into v_total_payment_amt;
2102: close c_total_payment_amt;

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

2101: fetch c_total_payment_amt into v_total_payment_amt;
2102: close c_total_payment_amt;
2103:
2104: if nvl(v_total_payment_amt, -1) = -1 then
2105: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'
2106: || to_char(v_total_payment_amt));
2107: return false;
2108: end if;
2109:

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

2161: return true;
2162:
2163: exception
2164: when others then
2165: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
2166: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
2167: return false;
2168: end update_payment_schedule;
2169:

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

2162:
2163: exception
2164: when others then
2165: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
2166: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
2167: return false;
2168: end update_payment_schedule;
2169:
2170: /*------------------------------------------------------------------------------------------------------------*/

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

2186:
2187: exception
2188: when others then
2189: if sqlcode = -6551 then -- object referred in EXECUTE IMMEDIATE is not available in the database
2190: fnd_file.put_line(fnd_file.log, 'mrc api is not existing(update)');
2191: else
2192: fnd_file.put_line(fnd_file.log, 'mrc api exists and different err(update)->'||sqlerrm);
2193: raise;
2194: end if;

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

2188: when others then
2189: if sqlcode = -6551 then -- object referred in EXECUTE IMMEDIATE is not available in the database
2190: fnd_file.put_line(fnd_file.log, 'mrc api is not existing(update)');
2191: else
2192: fnd_file.put_line(fnd_file.log, 'mrc api exists and different err(update)->'||sqlerrm);
2193: raise;
2194: end if;
2195: end update_mrc_data;
2196:

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

2216: when others then
2217: if sqlcode = -6550 then
2218: -- object referred in execute immediate is not available in the database
2219: null;
2220: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
2221: ELSE
2222: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
2223: RAISE;
2224: END IF;

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

2218: -- object referred in execute immediate is not available in the database
2219: null;
2220: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
2221: ELSE
2222: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
2223: RAISE;
2224: END IF;
2225: end insert_mrc_data;
2226: