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

Line 2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)

2227: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2228: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2229: );
2230:
2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)
2232: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2233: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2234: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2235: ); --12560704

Line 2238: fnd_file.put_line(fnd_file.log,'Document references cannot be null, cannot continue to derive the document details'); --12560704

2234: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2235: ); --12560704
2236:
2237: if p_document_line_id is null or p_document_source is null then
2238: fnd_file.put_line(fnd_file.log,'Document references cannot be null, cannot continue to derive the document details'); --12560704
2239: p_process_message := 'Document references cannot be null, cannot continue to derive the document details';
2240: p_process_flag := jai_constants.EXPECTED_ERROR;
2241: return;
2242: end if;

Line 2255: fnd_file.put_line(fnd_file.log,'Purchase Order does not exists for po_header_id ='||p_document_id ||' and po_line_id='|| p_document_line_id); --12560704

2251: fetch c_get_po_details into r_po_details;
2252: close c_get_po_details;
2253:
2254: if r_po_details.document_id is null then
2255: fnd_file.put_line(fnd_file.log,'Purchase Order does not exists for po_header_id ='||p_document_id ||' and po_line_id='|| p_document_line_id); --12560704
2256: jai_cmn_debug_contexts_pkg.print (ln_reg_id
2257: ,'Purchase Order does not exists for po_header_id ='||p_document_id ||' and po_line_id='|| p_document_line_id
2258: );
2259: end if;

Line 2261: fnd_file.put_line(fnd_file.log,'Purchase transaction details are r_po_details.document_id '||r_po_details.document_id||fnd_global.local_chr(10)

2257: ,'Purchase Order does not exists for po_header_id ='||p_document_id ||' and po_line_id='|| p_document_line_id
2258: );
2259: end if;
2260:
2261: fnd_file.put_line(fnd_file.log,'Purchase transaction details are r_po_details.document_id '||r_po_details.document_id||fnd_global.local_chr(10)
2262: ||'r_po_details.document_line_id =' ||r_po_details.document_line_id ||fnd_global.local_chr(10)
2263: ||'r_po_details.document_line_amt =' ||r_po_details.document_line_amt ||fnd_global.local_chr(10)
2264: ||'r_po_details.organization_id =' ||r_po_details.organization_id ||fnd_global.local_chr(10)
2265: ||'r_po_details.location_id =' ||r_po_details.location_id ||fnd_global.local_chr(10)); --12560704

Line 2290: fnd_file.put_line(fnd_file.log,'Purchase transaction details p_trx_repo_extract.repository_tax_amt '||p_trx_repo_extract.repository_tax_amt);--12560704

2286: open c_get_po_line_loc_srvtyp (cp_po_line_id => p_document_line_id) ;
2287: fetch c_get_po_line_loc_srvtyp into lv_service_type
2288: ,p_trx_repo_extract.repository_tax_amt;
2289: close c_get_po_line_loc_srvtyp;
2290: fnd_file.put_line(fnd_file.log,'Purchase transaction details p_trx_repo_extract.repository_tax_amt '||p_trx_repo_extract.repository_tax_amt);--12560704
2291: if nvl(p_called_from,'$#$') not in ('JAINRPRW') then
2292: -- if called from Repository Review UI then do not default service type from document
2293: p_trx_repo_extract.service_type_code := lv_service_type;
2294: end if;

Line 2307: fnd_file.put_line(fnd_file.log,'c_get_rcv_details details for po receipt v_organization_id= '||v_organization_id||fnd_global.local_chr(10)

2303:
2304: open c_get_rcv_details;
2305: fetch c_get_rcv_details into v_organization_id,v_location_id,v_po_header_id,v_po_line_id,v_transaction_id;
2306: close c_get_rcv_details;
2307: fnd_file.put_line(fnd_file.log,'c_get_rcv_details details for po receipt v_organization_id= '||v_organization_id||fnd_global.local_chr(10)
2308: || ' v_location_id = '||v_location_id|| fnd_global.local_chr(10) || ' v_po_header_id = '||v_po_header_id||' v_po_line_id --> '||v_po_line_id ); --12560704
2309:
2310: open c_get_receipt_details(v_transaction_id);
2311: fetch c_get_receipt_details into r_rcv_details;

Line 2342: fnd_file.put_line(fnd_file.log,'Receiving transaction details are r_rcv_details.document_id '||r_rcv_details.document_id||fnd_global.local_chr(10)

2338: p_trx_repo_extract.location_id := r_rcv_details.location_id;
2339: else
2340: p_trx_repo_extract.location_id := v_location_id;
2341: end if;
2342: fnd_file.put_line(fnd_file.log,'Receiving transaction details are r_rcv_details.document_id '||r_rcv_details.document_id||fnd_global.local_chr(10)
2343: ||'r_rcv_details.document_line_id =' ||r_rcv_details.document_line_id ||fnd_global.local_chr(10)
2344: ||'r_rcv_details.document_line_amt =' ||r_rcv_details.document_line_amt ||fnd_global.local_chr(10)
2345: ||'r_rcv_details.organization_id =' ||r_rcv_details.organization_id ||fnd_global.local_chr(10)
2346: ||'r_rcv_details.location_id =' ||r_rcv_details.location_id ||fnd_global.local_chr(10));--12560704

Line 2665: -- fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are ln_repository_tax_amount '||ln_repository_tax_amount);--12560704 --Comment by Chong.Lei for POT code port

2661:
2662: OPEN c_get_standalone_inv_details;
2663: FETCH c_get_standalone_inv_details INTO r_ap_details;
2664: CLOSE c_get_standalone_inv_details;
2665: -- fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are ln_repository_tax_amount '||ln_repository_tax_amount);--12560704 --Comment by Chong.Lei for POT code port
2666: -- fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are ln_payment_amount '||ln_payment_amount);--12560704 --Comment by Chong.Lei for POT code port
2667: -- Added by Chong.Lei for POT code port begin
2668: --Add by Xiao for POT Phase III, reg bug#12895841
2669: IF r_ap_details.document_number IS NULL THEN

Line 2666: -- fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are ln_payment_amount '||ln_payment_amount);--12560704 --Comment by Chong.Lei for POT code port

2662: OPEN c_get_standalone_inv_details;
2663: FETCH c_get_standalone_inv_details INTO r_ap_details;
2664: CLOSE c_get_standalone_inv_details;
2665: -- fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are ln_repository_tax_amount '||ln_repository_tax_amount);--12560704 --Comment by Chong.Lei for POT code port
2666: -- fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are ln_payment_amount '||ln_payment_amount);--12560704 --Comment by Chong.Lei for POT code port
2667: -- Added by Chong.Lei for POT code port begin
2668: --Add by Xiao for POT Phase III, reg bug#12895841
2669: IF r_ap_details.document_number IS NULL THEN
2670: OPEN c_get_dist_details;

Line 2812: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details p_trx_repo_extract.repository_tax_amt '||p_trx_repo_extract.repository_tax_amt);--12560704

2808: --Added by Wenqiong for 13462951 on Feb 09, 2012 end
2809: END IF;
2810:
2811: p_trx_repo_extract.repository_tax_amt := ln_repository_tax_amount;
2812: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details p_trx_repo_extract.repository_tax_amt '||p_trx_repo_extract.repository_tax_amt);--12560704
2813:
2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)
2815: ||'r_ap_details.document_line_id =' ||r_ap_details.document_line_id ||fnd_global.local_chr(10)
2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)

Line 2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)

2810:
2811: p_trx_repo_extract.repository_tax_amt := ln_repository_tax_amount;
2812: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details p_trx_repo_extract.repository_tax_amt '||p_trx_repo_extract.repository_tax_amt);--12560704
2813:
2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)
2815: ||'r_ap_details.document_line_id =' ||r_ap_details.document_line_id ||fnd_global.local_chr(10)
2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)
2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)
2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)

Line 3110: fnd_file.put_line(fnd_file.log,'lr_refs_rec.invoice_id '|| lr_refs_rec.invoice_id ||' lr_refs_rec.line_id) '||lr_refs_rec.line_id );

3106: ln_doc_line_id := p_trx_repo_extract_rec.document_line_id;
3107: lv_trx_src := p_trx_repo_extract_rec.transaction_source;
3108: if lv_trx_src='STANDALONE_INVOICE'
3109: then
3110: fnd_file.put_line(fnd_file.log,'lr_refs_rec.invoice_id '|| lr_refs_rec.invoice_id ||' lr_refs_rec.line_id) '||lr_refs_rec.line_id );
3111: --lr_line_number refers to the tax line number in apila in the standlone invoice
3112: open c_get_line_number(lr_refs_rec.invoice_id,lr_refs_rec.line_id);
3113: fetch c_get_line_number into lr_inv_dist_id,lr_line_number;
3114: close c_get_line_number;

Line 3116: fnd_file.put_line(fnd_file.log,'lr_inv_dist_id '|| lr_inv_dist_id ||' lr_line_number '||lr_line_number );

3112: open c_get_line_number(lr_refs_rec.invoice_id,lr_refs_rec.line_id);
3113: fetch c_get_line_number into lr_inv_dist_id,lr_line_number;
3114: close c_get_line_number;
3115:
3116: fnd_file.put_line(fnd_file.log,'lr_inv_dist_id '|| lr_inv_dist_id ||' lr_line_number '||lr_line_number );
3117:
3118: end if;
3119: -- end bug#10085619
3120: