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

Line 144: fnd_file.put_line(fnd_file.output,'This report is for Financials for India Customers only' );

140: IF (AD_EVENT_REGISTRY_PKG.Is_Event_Done( p_Owner => 'JA',
141: p_Event_Name => 'JAI_EXISTENCE_OF_TABLES' ) = FALSE )
142: OR lv_sob_currency <> 'INR' THEN
143:
144: fnd_file.put_line(fnd_file.output,'This report is for Financials for India Customers only' );
145: return;
146:
147: END IF;
148:

Line 161: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );

157: CLOSE cur_orgn_name;
158:
159: END IF;
160:
161: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
162: fnd_file.new_line(fnd_file.output,1);
163: fnd_file.put_line(fnd_file.output,'Parameters :' );
164: fnd_file.new_line(fnd_file.output,1);
165: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );

Line 162: fnd_file.new_line(fnd_file.output,1);

158:
159: END IF;
160:
161: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
162: fnd_file.new_line(fnd_file.output,1);
163: fnd_file.put_line(fnd_file.output,'Parameters :' );
164: fnd_file.new_line(fnd_file.output,1);
165: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
166: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );

Line 163: fnd_file.put_line(fnd_file.output,'Parameters :' );

159: END IF;
160:
161: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
162: fnd_file.new_line(fnd_file.output,1);
163: fnd_file.put_line(fnd_file.output,'Parameters :' );
164: fnd_file.new_line(fnd_file.output,1);
165: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
166: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
167: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );

Line 164: fnd_file.new_line(fnd_file.output,1);

160:
161: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
162: fnd_file.new_line(fnd_file.output,1);
163: fnd_file.put_line(fnd_file.output,'Parameters :' );
164: fnd_file.new_line(fnd_file.output,1);
165: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
166: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
167: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
168:

Line 165: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );

161: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
162: fnd_file.new_line(fnd_file.output,1);
163: fnd_file.put_line(fnd_file.output,'Parameters :' );
164: fnd_file.new_line(fnd_file.output,1);
165: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
166: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
167: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
168:
169: ln_receipt_count := 0;

Line 166: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );

162: fnd_file.new_line(fnd_file.output,1);
163: fnd_file.put_line(fnd_file.output,'Parameters :' );
164: fnd_file.new_line(fnd_file.output,1);
165: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
166: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
167: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
168:
169: ln_receipt_count := 0;
170:

Line 167: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );

163: fnd_file.put_line(fnd_file.output,'Parameters :' );
164: fnd_file.new_line(fnd_file.output,1);
165: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
166: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
167: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
168:
169: ln_receipt_count := 0;
170:
171: fnd_file.new_line(fnd_file.output,6);

Line 171: fnd_file.new_line(fnd_file.output,6);

167: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
168:
169: ln_receipt_count := 0;
170:
171: fnd_file.new_line(fnd_file.output,6);
172:
173: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Begins**********************************' );
174:
175: FOR receipt_rec IN cur_receipt_records(ld_start_date,ld_end_date) LOOP

Line 173: fnd_file.put_line(fnd_file.output,'OPM Cost Update Begins' );

169: ln_receipt_count := 0;
170:
171: fnd_file.new_line(fnd_file.output,6);
172:
173: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Begins**********************************' );
174:
175: FOR receipt_rec IN cur_receipt_records(ld_start_date,ld_end_date) LOOP
176:
177: fnd_file.new_line(fnd_file.output,2);

Line 177: fnd_file.new_line(fnd_file.output,2);

173: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Begins**********************************' );
174:
175: FOR receipt_rec IN cur_receipt_records(ld_start_date,ld_end_date) LOOP
176:
177: fnd_file.new_line(fnd_file.output,2);
178:
179: OPEN cur_receipt_num(receipt_rec.shipment_line_id);
180: FETCH cur_receipt_num INTO lv_receipt_num;
181: CLOSE cur_receipt_num;

Line 193: fnd_file.new_line(fnd_file.output,2);

189: END IF;
190:
191: lv_receipt_processed := 'N';
192:
193: fnd_file.new_line(fnd_file.output,2);
194: fnd_file.put_line(fnd_file.output,'Receipt Number :' ||lv_receipt_num );
195: fnd_file.put_line(fnd_file.output,'Organization Name :' ||lv_orgn_name );
196:
197:

Line 194: fnd_file.put_line(fnd_file.output,'Receipt Number :' ||lv_receipt_num );

190:
191: lv_receipt_processed := 'N';
192:
193: fnd_file.new_line(fnd_file.output,2);
194: fnd_file.put_line(fnd_file.output,'Receipt Number :' ||lv_receipt_num );
195: fnd_file.put_line(fnd_file.output,'Organization Name :' ||lv_orgn_name );
196:
197:
198: FOR rcv_costing_records IN cur_rcv_costing_records(receipt_rec.shipment_line_id) LOOP

Line 195: fnd_file.put_line(fnd_file.output,'Organization Name :' ||lv_orgn_name );

191: lv_receipt_processed := 'N';
192:
193: fnd_file.new_line(fnd_file.output,2);
194: fnd_file.put_line(fnd_file.output,'Receipt Number :' ||lv_receipt_num );
195: fnd_file.put_line(fnd_file.output,'Organization Name :' ||lv_orgn_name );
196:
197:
198: FOR rcv_costing_records IN cur_rcv_costing_records(receipt_rec.shipment_line_id) LOOP
199:

Line 247: fnd_file.put_line(fnd_file.output,'ln_costing_amount before conversion:'||ln_costing_amount );

243: ln_costing_amt_func_curr := round((ln_costing_amt_func_curr * ln_apportion_factor)/rcv_costing_records.primary_quantity,5);
244: /* end for bug 7655123 */
245:
246: --Added by JMEENA for bug#7268999
247: fnd_file.put_line(fnd_file.output,'ln_costing_amount before conversion:'||ln_costing_amount );
248: ln_costing_amount:= ln_costing_amount/NVL(rcv_costing_records.currency_conversion_rate,1);
249: fnd_file.put_line(fnd_file.output,'ln_costing_amount After conversion:'||ln_costing_amount );
250: --End of bug#7268999
251:

Line 249: fnd_file.put_line(fnd_file.output,'ln_costing_amount After conversion:'||ln_costing_amount );

245:
246: --Added by JMEENA for bug#7268999
247: fnd_file.put_line(fnd_file.output,'ln_costing_amount before conversion:'||ln_costing_amount );
248: ln_costing_amount:= ln_costing_amount/NVL(rcv_costing_records.currency_conversion_rate,1);
249: fnd_file.put_line(fnd_file.output,'ln_costing_amount After conversion:'||ln_costing_amount );
250: --End of bug#7268999
251:
252: /*bug 8966461 - negative quantities will lead to apportion factor becoming negative.
253: * Therefore, if we divide by ABS(quantity) then costing amount will be negative.

Line 280: fnd_file.new_line(fnd_file.output,1);

276:
277: END IF;
278:
279: lv_receipt_processed := 'Y';
280: fnd_file.new_line(fnd_file.output,1);
281: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
282: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
283: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
284: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );

Line 281: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );

277: END IF;
278:
279: lv_receipt_processed := 'Y';
280: fnd_file.new_line(fnd_file.output,1);
281: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
282: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
283: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
284: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );
285: END LOOP;

Line 282: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );

278:
279: lv_receipt_processed := 'Y';
280: fnd_file.new_line(fnd_file.output,1);
281: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
282: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
283: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
284: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );
285: END LOOP;
286:

Line 283: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );

279: lv_receipt_processed := 'Y';
280: fnd_file.new_line(fnd_file.output,1);
281: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
282: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
283: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
284: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );
285: END LOOP;
286:
287: IF lv_receipt_processed = 'N' THEN

Line 284: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );

280: fnd_file.new_line(fnd_file.output,1);
281: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
282: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
283: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
284: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );
285: END LOOP;
286:
287: IF lv_receipt_processed = 'N' THEN
288:

Line 289: fnd_file.new_line(fnd_file.output,1);

285: END LOOP;
286:
287: IF lv_receipt_processed = 'N' THEN
288:
289: fnd_file.new_line(fnd_file.output,1);
290: fnd_file.put_line(fnd_file.output,'The Receipt was already Cost updated');
291:
292: END IF;
293:

Line 290: fnd_file.put_line(fnd_file.output,'The Receipt was already Cost updated');

286:
287: IF lv_receipt_processed = 'N' THEN
288:
289: fnd_file.new_line(fnd_file.output,1);
290: fnd_file.put_line(fnd_file.output,'The Receipt was already Cost updated');
291:
292: END IF;
293:
294: ln_receipt_count := ln_receipt_count + 1;

Line 297: fnd_file.new_line(fnd_file.output,2);

293:
294: ln_receipt_count := ln_receipt_count + 1;
295:
296: END LOOP;
297: fnd_file.new_line(fnd_file.output,2);
298: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);
299: fnd_file.new_line(fnd_file.output,2);
300:
301: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Ends**********************************' );

Line 298: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);

294: ln_receipt_count := ln_receipt_count + 1;
295:
296: END LOOP;
297: fnd_file.new_line(fnd_file.output,2);
298: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);
299: fnd_file.new_line(fnd_file.output,2);
300:
301: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Ends**********************************' );
302: COMMIT;

Line 299: fnd_file.new_line(fnd_file.output,2);

295:
296: END LOOP;
297: fnd_file.new_line(fnd_file.output,2);
298: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);
299: fnd_file.new_line(fnd_file.output,2);
300:
301: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Ends**********************************' );
302: COMMIT;
303: EXCEPTION

Line 301: fnd_file.put_line(fnd_file.output,'OPM Cost Update Ends' );

297: fnd_file.new_line(fnd_file.output,2);
298: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);
299: fnd_file.new_line(fnd_file.output,2);
300:
301: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Ends**********************************' );
302: COMMIT;
303: EXCEPTION
304: WHEN OTHERS THEN
305: retcode := 2;

Line 307: fnd_file.put_line(fnd_file.log,'Error while processing receipt :'||lv_receipt_num);

303: EXCEPTION
304: WHEN OTHERS THEN
305: retcode := 2;
306: errbuf := SUBSTR(SQLERRM,1,200);
307: fnd_file.put_line(fnd_file.log,'Error while processing receipt :'||lv_receipt_num);
308: ROLLBACK;
309: END opm_cost_adjust;
310:
311: END jai_rcv_opm_costing_pkg;