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.JAI_AR_TRX_PKG dependencies on FND_FILE

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

264: */
265: ld_start_date := fnd_date.canonical_to_date(p_start_date);
266: ld_end_date := fnd_date.canonical_to_date(p_end_date) ;
267:
268: fnd_file.put_line(FND_FILE.LOG,'Input parameters are p_org_id-> ' || p_org_id
269: ||' ,p_start_date -> ' || p_start_date
270: ||' ,p_end_date -> ' || p_end_date
271: ||' ,p_customer_trx_id -> ' || p_customer_trx_id); --bug#5194107
272:

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

276: ln_last_update_login := fnd_global.login_id; --bug#5194107
277:
278: ln_org_id := mo_global.get_current_org_id() ; -- Harshita for Bug 5490479
279:
280: fnd_file.put_line(FND_FILE.LOG,'Processing Customer Trx id : ' || p_customer_trx_id);
281:
282: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
283: Loop
284: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);

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

280: fnd_file.put_line(FND_FILE.LOG,'Processing Customer Trx id : ' || p_customer_trx_id);
281:
282: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
283: Loop
284: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);
285: fnd_file.put_line(FND_FILE.LOG,'Customer Trx Line id : ' ||delivery_rec.customer_trx_line_id);
286: --added for bug#6685050, start
287: OPEN c_same_inv_no(delivery_rec.customer_trx_id);
288: FETCH c_same_inv_no INTO lv_same_inv_no;

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

281:
282: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
283: Loop
284: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);
285: fnd_file.put_line(FND_FILE.LOG,'Customer Trx Line id : ' ||delivery_rec.customer_trx_line_id);
286: --added for bug#6685050, start
287: OPEN c_same_inv_no(delivery_rec.customer_trx_id);
288: FETCH c_same_inv_no INTO lv_same_inv_no;
289: CLOSE c_same_inv_no;

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

324:
325: --start additions by vkaranam for bug#5194107
326: IF ln_vat_invoice_no IS NOT NULL or ld_vat_invoice_date IS NOT NULL THEN
327:
328: fnd_file.put_line(FND_FILE.LOG,' VAT invoice No -> '||ln_vat_invoice_no
329: || ', VAT inv date -> ' ||ld_vat_invoice_date
330: ||' for customer_trx_id -> '||delivery_rec.customer_trx_id );
331:
332: --Added by Zhiwei for bug#14040855 JAI Trigger elimination begin

Line 387: fnd_file.put_line( FND_FILE.LOG

383: -----------------------------------------------------------------------------------------------------------------
384: -- when then profile "JAI:Include Excise and VAT Invoice Number in AR transactions - Referencde" set to "Yes"
385: lv_display_flag := FND_PROFILE.VALUE('JAI_DISP_VAT_EXC_INV_AR_TRX_REF');
386:
387: fnd_file.put_line( FND_FILE.LOG
388: , 'JAI:Include Excise and VAT Invoice Number in AR transactions - Referencde is set to ' ||
389: lv_display_flag);
390:
391: fnd_file.put_line( FND_FILE.LOG

Line 391: fnd_file.put_line( FND_FILE.LOG

387: fnd_file.put_line( FND_FILE.LOG
388: , 'JAI:Include Excise and VAT Invoice Number in AR transactions - Referencde is set to ' ||
389: lv_display_flag);
390:
391: fnd_file.put_line( FND_FILE.LOG
392: , 'delivery_rec.customer_trx_id :'||delivery_rec.customer_trx_id);
393: fnd_file.put_line( FND_FILE.LOG
394: , 'lv_excise_invoice_no :' || lv_excise_invoice_no);
395: fnd_file.put_line( FND_FILE.LOG

Line 393: fnd_file.put_line( FND_FILE.LOG

389: lv_display_flag);
390:
391: fnd_file.put_line( FND_FILE.LOG
392: , 'delivery_rec.customer_trx_id :'||delivery_rec.customer_trx_id);
393: fnd_file.put_line( FND_FILE.LOG
394: , 'lv_excise_invoice_no :' || lv_excise_invoice_no);
395: fnd_file.put_line( FND_FILE.LOG
396: , 'lv_vat_invoice_no :' || ln_vat_invoice_no);
397:

Line 395: fnd_file.put_line( FND_FILE.LOG

391: fnd_file.put_line( FND_FILE.LOG
392: , 'delivery_rec.customer_trx_id :'||delivery_rec.customer_trx_id);
393: fnd_file.put_line( FND_FILE.LOG
394: , 'lv_excise_invoice_no :' || lv_excise_invoice_no);
395: fnd_file.put_line( FND_FILE.LOG
396: , 'lv_vat_invoice_no :' || ln_vat_invoice_no);
397:
398: IF ( lv_excise_invoice_no IS NOT NULL OR ln_vat_invoice_no IS NOT NULL)
399: AND nvl(lv_display_flag, 'N') = 'Y'

Line 406: fnd_file.put_line(FND_FILE.LOG,'The invoice number has been displayed successfully!');

402: , pv_excise_invoice_no => lv_excise_invoice_no
403: , pv_vat_invoice_no => ln_vat_invoice_no
404: );
405:
406: fnd_file.put_line(FND_FILE.LOG,'The invoice number has been displayed successfully!');
407: END IF;
408: -----------------------------------------------------------------------------------------------------------------
409: --Add by Bo Li for VAT/Excise Number shown in AR transaction workbench(Bug 9303168#) on 19-Jan-2010,End
410: end loop;

Line 751: fnd_file.put_line( FND_FILE.LOG

747:
748: --get the profile value
749: lv_display_flag := FND_PROFILE.VALUE('JAI_DISP_VAT_EXC_INV_AR_TRX_REF');
750:
751: fnd_file.put_line( FND_FILE.LOG
752: , 'pn_customer_trx_id :' || pn_customer_trx_id);
753: fnd_file.put_line( FND_FILE.LOG
754: , 'lv_excise_invoice_no :' || lv_excise_invoice_no);
755: fnd_file.put_line( FND_FILE.LOG

Line 753: fnd_file.put_line( FND_FILE.LOG

749: lv_display_flag := FND_PROFILE.VALUE('JAI_DISP_VAT_EXC_INV_AR_TRX_REF');
750:
751: fnd_file.put_line( FND_FILE.LOG
752: , 'pn_customer_trx_id :' || pn_customer_trx_id);
753: fnd_file.put_line( FND_FILE.LOG
754: , 'lv_excise_invoice_no :' || lv_excise_invoice_no);
755: fnd_file.put_line( FND_FILE.LOG
756: , 'lv_vat_invoice_no :' || lv_vat_invoice_no);
757:

Line 755: fnd_file.put_line( FND_FILE.LOG

751: fnd_file.put_line( FND_FILE.LOG
752: , 'pn_customer_trx_id :' || pn_customer_trx_id);
753: fnd_file.put_line( FND_FILE.LOG
754: , 'lv_excise_invoice_no :' || lv_excise_invoice_no);
755: fnd_file.put_line( FND_FILE.LOG
756: , 'lv_vat_invoice_no :' || lv_vat_invoice_no);
757:
758: -- update the reference field in the AR transaction workbench
759: IF (lv_excise_invoice_no IS NOT NULL OR lv_vat_invoice_no IS NOT NULL OR lv_st_invoice_num IS NOT NULL)

Line 767: fnd_file.put_line( FND_FILE.LOG

763: JAI_AR_MATCH_TAX_PKG.display_vat_invoice_no(pn_customer_trx_id => pn_customer_trx_id,
764: pv_excise_invoice_no => lv_excise_invoice_no,
765: pv_vat_invoice_no => lv_vat_invoice_no);
766:
767: fnd_file.put_line( FND_FILE.LOG
768: , 'The invoice number has been displayed successfully!');
769: END IF;
770:
771: COMMIT;