DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on FND_FILE

Line 175: fnd_file.put_line(FND_FILE.LOG,'Input parameters are p_org_id-> ' || p_org_id

171: */
172: ld_start_date := fnd_date.canonical_to_date(p_start_date);
173: ld_end_date := fnd_date.canonical_to_date(p_end_date) ;
174:
175: fnd_file.put_line(FND_FILE.LOG,'Input parameters are p_org_id-> ' || p_org_id
176: ||' ,p_start_date -> ' || p_start_date
177: ||' ,p_end_date -> ' || p_end_date
178: ||' ,p_customer_trx_id -> ' || p_customer_trx_id); --bug#5194107
179:

Line 187: fnd_file.put_line(FND_FILE.LOG,'Processing Customer Trx id : ' || p_customer_trx_id);

183: ln_last_update_login := fnd_global.login_id; --bug#5194107
184:
185: ln_org_id := mo_global.get_current_org_id() ; -- Harshita for Bug 5490479
186:
187: fnd_file.put_line(FND_FILE.LOG,'Processing Customer Trx id : ' || p_customer_trx_id);
188:
189: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
190: Loop
191: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);

Line 191: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);

187: fnd_file.put_line(FND_FILE.LOG,'Processing Customer Trx id : ' || p_customer_trx_id);
188:
189: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
190: Loop
191: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);
192: fnd_file.put_line(FND_FILE.LOG,'Customer Trx Line id : ' ||delivery_rec.customer_trx_line_id);
193: --added for bug#6685050, start
194: OPEN c_same_inv_no(delivery_rec.customer_trx_id);
195: FETCH c_same_inv_no INTO lv_same_inv_no;

Line 192: fnd_file.put_line(FND_FILE.LOG,'Customer Trx Line id : ' ||delivery_rec.customer_trx_line_id);

188:
189: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
190: Loop
191: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);
192: fnd_file.put_line(FND_FILE.LOG,'Customer Trx Line id : ' ||delivery_rec.customer_trx_line_id);
193: --added for bug#6685050, start
194: OPEN c_same_inv_no(delivery_rec.customer_trx_id);
195: FETCH c_same_inv_no INTO lv_same_inv_no;
196: CLOSE c_same_inv_no;

Line 223: fnd_file.put_line(FND_FILE.LOG,' VAT invoice No -> '||ln_vat_invoice_no

219:
220: --start additions by vkaranam for bug#5194107
221: IF ln_vat_invoice_no IS NOT NULL or ld_vat_invoice_date IS NOT NULL THEN
222:
223: fnd_file.put_line(FND_FILE.LOG,' VAT invoice No -> '||ln_vat_invoice_no
224: || ', VAT inv date -> ' ||ld_vat_invoice_date
225: ||' for customer_trx_id -> '||delivery_rec.customer_trx_id );
226:
227: UPDATE JAI_AR_TRXS

Line 257: fnd_file.put_line(FND_FILE.LOG,'System encountered the error '||errbuf);

253: p_param3 => ln_vat_invoice_no, --added for bug#6685050
254: p_param4 => lv_same_inv_no); --added for bug#6685050
255:
256: IF retcode <> 0 THEN
257: fnd_file.put_line(FND_FILE.LOG,'System encountered the error '||errbuf);
258: raise_application_error(20011,'System encountered the error '||errbuf);
259: END IF;
260: END IF;
261: --End of Addition by anujsax for Bug#5636544