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 99: fnd_file.put_line(fnd_file.output,'This report is for Financials for India Customers only' );

95: IF (AD_EVENT_REGISTRY_PKG.Is_Event_Done( p_Owner => 'JA',
96: p_Event_Name => 'JAI_EXISTENCE_OF_TABLES' ) = FALSE )
97: OR lv_sob_currency <> 'INR' THEN
98:
99: fnd_file.put_line(fnd_file.output,'This report is for Financials for India Customers only' );
100: return;
101:
102: END IF;
103:

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

112: CLOSE cur_orgn_name;
113:
114: END IF;
115:
116: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
117: fnd_file.new_line(fnd_file.output,1);
118: fnd_file.put_line(fnd_file.output,'Parameters :' );
119: fnd_file.new_line(fnd_file.output,1);
120: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );

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

113:
114: END IF;
115:
116: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
117: fnd_file.new_line(fnd_file.output,1);
118: fnd_file.put_line(fnd_file.output,'Parameters :' );
119: fnd_file.new_line(fnd_file.output,1);
120: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
121: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );

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

114: END IF;
115:
116: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
117: fnd_file.new_line(fnd_file.output,1);
118: fnd_file.put_line(fnd_file.output,'Parameters :' );
119: fnd_file.new_line(fnd_file.output,1);
120: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
121: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
122: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );

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

115:
116: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
117: fnd_file.new_line(fnd_file.output,1);
118: fnd_file.put_line(fnd_file.output,'Parameters :' );
119: fnd_file.new_line(fnd_file.output,1);
120: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
121: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
122: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
123:

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

116: fnd_file.put_line(fnd_file.output,'Concurrent Program Name: India - Program to Update OPM Cost' );
117: fnd_file.new_line(fnd_file.output,1);
118: fnd_file.put_line(fnd_file.output,'Parameters :' );
119: fnd_file.new_line(fnd_file.output,1);
120: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
121: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
122: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
123:
124: ln_receipt_count := 0;

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

117: fnd_file.new_line(fnd_file.output,1);
118: fnd_file.put_line(fnd_file.output,'Parameters :' );
119: fnd_file.new_line(fnd_file.output,1);
120: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
121: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
122: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
123:
124: ln_receipt_count := 0;
125:

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

118: fnd_file.put_line(fnd_file.output,'Parameters :' );
119: fnd_file.new_line(fnd_file.output,1);
120: fnd_file.put_line(fnd_file.output,' Organization Name :'||lv_orgn_name );
121: fnd_file.put_line(fnd_file.output,' Receipt Start Date :'||ld_start_date );
122: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
123:
124: ln_receipt_count := 0;
125:
126: fnd_file.new_line(fnd_file.output,6);

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

122: fnd_file.put_line(fnd_file.output,' Receipt End Date :'||ld_end_date );
123:
124: ln_receipt_count := 0;
125:
126: fnd_file.new_line(fnd_file.output,6);
127:
128: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Begins**********************************' );
129:
130: FOR receipt_rec IN cur_receipt_records(ld_start_date,ld_end_date) LOOP

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

124: ln_receipt_count := 0;
125:
126: fnd_file.new_line(fnd_file.output,6);
127:
128: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Begins**********************************' );
129:
130: FOR receipt_rec IN cur_receipt_records(ld_start_date,ld_end_date) LOOP
131:
132: fnd_file.new_line(fnd_file.output,2);

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

128: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Begins**********************************' );
129:
130: FOR receipt_rec IN cur_receipt_records(ld_start_date,ld_end_date) LOOP
131:
132: fnd_file.new_line(fnd_file.output,2);
133:
134: OPEN cur_receipt_num(receipt_rec.shipment_line_id);
135: FETCH cur_receipt_num INTO lv_receipt_num;
136: CLOSE cur_receipt_num;

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

144: END IF;
145:
146: lv_receipt_processed := 'N';
147:
148: fnd_file.new_line(fnd_file.output,2);
149: fnd_file.put_line(fnd_file.output,'Receipt Number :' ||lv_receipt_num );
150: fnd_file.put_line(fnd_file.output,'Organization Name :' ||lv_orgn_name );
151:
152:

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

145:
146: lv_receipt_processed := 'N';
147:
148: fnd_file.new_line(fnd_file.output,2);
149: fnd_file.put_line(fnd_file.output,'Receipt Number :' ||lv_receipt_num );
150: fnd_file.put_line(fnd_file.output,'Organization Name :' ||lv_orgn_name );
151:
152:
153: FOR rcv_costing_records IN cur_rcv_costing_records(receipt_rec.shipment_line_id) LOOP

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

146: lv_receipt_processed := 'N';
147:
148: fnd_file.new_line(fnd_file.output,2);
149: fnd_file.put_line(fnd_file.output,'Receipt Number :' ||lv_receipt_num );
150: fnd_file.put_line(fnd_file.output,'Organization Name :' ||lv_orgn_name );
151:
152:
153: FOR rcv_costing_records IN cur_rcv_costing_records(receipt_rec.shipment_line_id) LOOP
154:

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

189:
190: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor
191: ( p_transaction_id => rcv_costing_records.transaction_id);
192: --Added by JMEENA for bug#7268999
193: fnd_file.put_line(fnd_file.output,'ln_costing_amount before conversion:'||ln_costing_amount );
194: ln_costing_amount:= ln_costing_amount/NVL(rcv_costing_records.currency_conversion_rate,1);
195: fnd_file.put_line(fnd_file.output,'ln_costing_amount After conversion:'||ln_costing_amount );
196: --End of bug#7268999
197:

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

191: ( p_transaction_id => rcv_costing_records.transaction_id);
192: --Added by JMEENA for bug#7268999
193: fnd_file.put_line(fnd_file.output,'ln_costing_amount before conversion:'||ln_costing_amount );
194: ln_costing_amount:= ln_costing_amount/NVL(rcv_costing_records.currency_conversion_rate,1);
195: fnd_file.put_line(fnd_file.output,'ln_costing_amount After conversion:'||ln_costing_amount );
196: --End of bug#7268999
197:
198: ln_costing_amount := round((ln_costing_amount * ln_apportion_factor)/ABS(rcv_costing_records.quantity),5);
199:

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

214:
215: END IF;
216:
217: lv_receipt_processed := 'Y';
218: fnd_file.new_line(fnd_file.output,1);
219: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
220: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
221: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
222: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );

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

215: END IF;
216:
217: lv_receipt_processed := 'Y';
218: fnd_file.new_line(fnd_file.output,1);
219: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
220: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
221: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
222: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );
223: END LOOP;

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

216:
217: lv_receipt_processed := 'Y';
218: fnd_file.new_line(fnd_file.output,1);
219: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
220: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
221: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
222: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );
223: END LOOP;
224:

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

217: lv_receipt_processed := 'Y';
218: fnd_file.new_line(fnd_file.output,1);
219: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
220: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
221: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
222: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );
223: END LOOP;
224:
225: IF lv_receipt_processed = 'N' THEN

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

218: fnd_file.new_line(fnd_file.output,1);
219: fnd_file.put_line(fnd_file.output,'Transaction Type :' ||rcv_costing_records.transaction_type );
220: fnd_file.put_line(fnd_file.output,'Transaction Quantity :' ||rcv_costing_records.quantity );
221: fnd_file.put_line(fnd_file.output,'Non recoverable taxes per unit:' ||ln_costing_amount );
222: fnd_file.put_line(fnd_file.output,'Cost Update Successful' );
223: END LOOP;
224:
225: IF lv_receipt_processed = 'N' THEN
226:

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

223: END LOOP;
224:
225: IF lv_receipt_processed = 'N' THEN
226:
227: fnd_file.new_line(fnd_file.output,1);
228: fnd_file.put_line(fnd_file.output,'The Receipt was already Cost updated');
229:
230: END IF;
231:

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

224:
225: IF lv_receipt_processed = 'N' THEN
226:
227: fnd_file.new_line(fnd_file.output,1);
228: fnd_file.put_line(fnd_file.output,'The Receipt was already Cost updated');
229:
230: END IF;
231:
232: ln_receipt_count := ln_receipt_count + 1;

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

231:
232: ln_receipt_count := ln_receipt_count + 1;
233:
234: END LOOP;
235: fnd_file.new_line(fnd_file.output,2);
236: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);
237: fnd_file.new_line(fnd_file.output,2);
238:
239: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Ends**********************************' );

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

232: ln_receipt_count := ln_receipt_count + 1;
233:
234: END LOOP;
235: fnd_file.new_line(fnd_file.output,2);
236: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);
237: fnd_file.new_line(fnd_file.output,2);
238:
239: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Ends**********************************' );
240: COMMIT;

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

233:
234: END LOOP;
235: fnd_file.new_line(fnd_file.output,2);
236: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);
237: fnd_file.new_line(fnd_file.output,2);
238:
239: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Ends**********************************' );
240: COMMIT;
241: EXCEPTION

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

235: fnd_file.new_line(fnd_file.output,2);
236: fnd_file.put_line(fnd_file.output,'Total number of receipts processed :' ||ln_receipt_count);
237: fnd_file.new_line(fnd_file.output,2);
238:
239: fnd_file.put_line(fnd_file.output,'**********************************OPM Cost Update Ends**********************************' );
240: COMMIT;
241: EXCEPTION
242: WHEN OTHERS THEN
243: retcode := 2;

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

241: EXCEPTION
242: WHEN OTHERS THEN
243: retcode := 2;
244: errbuf := SUBSTR(SQLERRM,1,200);
245: fnd_file.put_line(fnd_file.log,'Error while processing receipt :'||lv_receipt_num);
246: ROLLBACK;
247: END opm_cost_adjust;
248:
249: END jai_rcv_opm_costing_pkg;