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

Line 389: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acq_Cost_Processor <<<');

385: l_commit_records_count NUMBER := 500; -- COMMIT to be issued every 500 records. Can be changed, if reqd.
386:
387: BEGIN
388: IF g_debug = 'Y' THEN
389: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acq_Cost_Processor <<<');
390: END IF;
391: l_recs_processed := 0;
392: -----------------------------------------------------
393: -- Initialize error variables

Line 529: fnd_file.put_line(fnd_file.log,'Start date: ' || to_char(l_start_date,'DD-MON-RR'));

525: l_end_date := i_end_date;
526: end if;
527:
528: IF g_debug = 'Y' THEN
529: fnd_file.put_line(fnd_file.log,'Start date: ' || to_char(l_start_date,'DD-MON-RR'));
530: fnd_file.put_line(fnd_file.log,'End Date: ' || to_char(l_end_date,'DD-MON-RR'));
531: END IF;
532:
533:

Line 530: fnd_file.put_line(fnd_file.log,'End Date: ' || to_char(l_end_date,'DD-MON-RR'));

526: end if;
527:
528: IF g_debug = 'Y' THEN
529: fnd_file.put_line(fnd_file.log,'Start date: ' || to_char(l_start_date,'DD-MON-RR'));
530: fnd_file.put_line(fnd_file.log,'End Date: ' || to_char(l_end_date,'DD-MON-RR'));
531: END IF;
532:
533:
534: -- ==================================================================================

Line 573: fnd_file.put_line(fnd_file.log, 'Transaction: ' ||to_char(c_rec.transaction_id));

569: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
570:
571: BEGIN
572: If G_DEBUG ='Y' then
573: fnd_file.put_line(fnd_file.log, 'Transaction: ' ||to_char(c_rec.transaction_id));
574: end If;
575:
576: l_stmt_num := 60;
577:

Line 1010: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice: ' ||to_char(c_inv.INVOICE_DISTRIBUTION_ID));

1006: BEGIN
1007: FOR c_inv IN c_invoices LOOP
1008:
1009: IF G_DEBUG = 'Y' THEN
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice: ' ||to_char(c_inv.INVOICE_DISTRIBUTION_ID));
1011: END IF;
1012:
1013: --------------------------------------------------------------------------------
1014: --AP price correction documents should NOT be restricted only

Line 1421: fnd_file.put_line(fnd_file.LOG, ' 500 txns processed.... Issuing Commit ');

1417: -- Added Perf bug# 5214447. Issuing intermediate commits after processing preset No. of rows.
1418:
1419: IF l_recs_processed >= l_commit_records_count THEN
1420: IF g_debug = 'Y' THEN
1421: fnd_file.put_line(fnd_file.LOG, ' 500 txns processed.... Issuing Commit ');
1422: END IF;
1423: l_recs_processed := 0;
1424: COMMIT;
1425: END IF;

Line 2252: fnd_file.put_line(fnd_file.LOG, ' 500 txns processed.... Issuing Commit ');

2248: END IF;
2249: END LOOP;
2250: IF l_recs_processed >= l_commit_records_count THEN
2251: IF g_debug = 'Y' THEN
2252: fnd_file.put_line(fnd_file.LOG, ' 500 txns processed.... Issuing Commit ');
2253: END IF;
2254: l_recs_processed := 0;
2255: COMMIT;
2256: END IF;

Line 2290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acq_Cost_Processor >>>');

2286:
2287: END;
2288: /*LCM Adjustment*/
2289: IF g_debug = 'Y' THEN
2290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acq_Cost_Processor >>>');
2291: END IF;
2292:
2293: ELSIF i_source_flag = 2 THEN
2294: -------------------------------------------------------------------------------------

Line 2366: fnd_file.put_line(fnd_file.log, 'Transaction: ' ||to_char(l_rec_transaction_id));

2362: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
2363:
2364: BEGIN
2365: If G_DEBUG ='Y' then
2366: fnd_file.put_line(fnd_file.log, 'Transaction: ' ||to_char(l_rec_transaction_id));
2367: end If;
2368:
2369: -- Delete from MMT and MPTCD transactions that were created for the
2370: -- previous run for this receipt and then delete from craca and cracda*/

Line 2840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice: ' ||to_char(c_inv.INVOICE_DISTRIBUTION_ID));

2836: FOR c_inv IN c_invoices LOOP
2837:
2838:
2839: IF G_DEBUG = 'Y' THEN
2840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice: ' ||to_char(c_inv.INVOICE_DISTRIBUTION_ID));
2841: END IF;
2842:
2843: --------------------------------------------------------------------------------
2844: --AP price correction documents should NOT be restricted only

Line 3047: fnd_file.put_line(fnd_file.LOG, ' 500 txns processed.... Issuing Commit ');

3043: -- Added Perf bug# 5214447. Issuing intermediate commits after processing preset No. of rows.
3044:
3045: IF l_recs_processed >= l_commit_records_count THEN
3046: IF g_debug = 'Y' THEN
3047: fnd_file.put_line(fnd_file.LOG, ' 500 txns processed.... Issuing Commit ');
3048: END IF;
3049: l_recs_processed := 0;
3050: COMMIT;
3051: END IF;

Line 3092: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acq_Cost_Adjustment_Processor >>>');

3088: CLOSE c_receipts_src_flag_2_invid;
3089: END IF;
3090:
3091: IF g_debug = 'Y' THEN
3092: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acq_Cost_Adjustment_Processor >>>');
3093: END IF;
3094:
3095: END IF; -- i_source_flag check
3096:

Line 3223: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GET_NQR <<< ');

3219:
3220: o_err_num := 0;
3221:
3222: IF g_debug = 'Y' THEN
3223: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GET_NQR <<< ');
3224: END IF;
3225: -------------------------------------------
3226: -- Determine if PO is for Service Line Type
3227: -------------------------------------------

Line 3333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Net Quantity/Amount: '||to_char(l_nqr));

3329: -- Return the net quantity received as calculated
3330: --------------------------------------------------------
3331:
3332: IF g_debug = 'Y' THEN
3333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Net Quantity/Amount: '||to_char(l_nqr));
3334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GET_NQR >>> ');
3335: END IF;
3336: RETURN (l_nqr);
3337: EXCEPTION

Line 3334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GET_NQR >>> ');

3330: --------------------------------------------------------
3331:
3332: IF g_debug = 'Y' THEN
3333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Net Quantity/Amount: '||to_char(l_nqr));
3334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GET_NQR >>> ');
3335: END IF;
3336: RETURN (l_nqr);
3337: EXCEPTION
3338: WHEN OTHERS THEN

Line 4288: fnd_file.put_line(fnd_file.log,'Calculating the Adjustment amount');

4284: /* now calculate the amount to be posted as the adjustment amount */
4285:
4286: If G_DEBUG = 'Y' then
4287:
4288: fnd_file.put_line(fnd_file.log,'Calculating the Adjustment amount');
4289: fnd_file.put_line(fnd_file.log,'Header ID : ' || to_char(i_header));
4290:
4291: End If;
4292:

Line 4289: fnd_file.put_line(fnd_file.log,'Header ID : ' || to_char(i_header));

4285:
4286: If G_DEBUG = 'Y' then
4287:
4288: fnd_file.put_line(fnd_file.log,'Calculating the Adjustment amount');
4289: fnd_file.put_line(fnd_file.log,'Header ID : ' || to_char(i_header));
4290:
4291: End If;
4292:
4293: l_stmt_num := 45;

Line 4320: fnd_file.put_line(fnd_file.log,'Original Acq cost:'|| l_ori_acq_amount);

4316: END;
4317:
4318: If G_DEBUG = 'Y' then
4319:
4320: fnd_file.put_line(fnd_file.log,'Original Acq cost:'|| l_ori_acq_amount);
4321: End If;
4322:
4323: /* now get the SUM of all the incremental amounts posted to MMT so far in the previous periods */
4324:

Line 4340: fnd_file.put_line(fnd_file.log,'old increment :' || to_char(l_old_increments));

4336: from cst_rcv_acq_costs_adj craca2
4337: where craca2.header_id = i_header);
4338:
4339:
4340: fnd_file.put_line(fnd_file.log,'old increment :' || to_char(l_old_increments));
4341:
4342: select nvl(net_quantity_received,0)
4343: into l_net_qty_received
4344: from cst_rcv_acq_costs_adj

Line 4355: fnd_file.put_line(fnd_file.log,'RTV Adjustment amount : ' || to_char(l_rtv_adj_amount));

4351: l_rtv_qty := nvl(abs(l_net_qty_received - l_original_qty_received),0);
4352:
4353: l_rtv_adj_amount := l_rtv_qty * l_original_acq_cost;
4354:
4355: fnd_file.put_line(fnd_file.log,'RTV Adjustment amount : ' || to_char(l_rtv_adj_amount));
4356:
4357: fnd_file.put_line(fnd_file.log,'Current acq cost : ' || to_char(l_acq_cost));
4358:
4359:

Line 4357: fnd_file.put_line(fnd_file.log,'Current acq cost : ' || to_char(l_acq_cost));

4353: l_rtv_adj_amount := l_rtv_qty * l_original_acq_cost;
4354:
4355: fnd_file.put_line(fnd_file.log,'RTV Adjustment amount : ' || to_char(l_rtv_adj_amount));
4356:
4357: fnd_file.put_line(fnd_file.log,'Current acq cost : ' || to_char(l_acq_cost));
4358:
4359:
4360:
4361: l_acq_adjustment_amount := (NVL(l_acq_cost,0) * l_net_qty_received)

Line 4364: fnd_file.put_line(fnd_file.log,'Adjustment amount : ' || to_char(l_acq_adjustment_amount));

4360:
4361: l_acq_adjustment_amount := (NVL(l_acq_cost,0) * l_net_qty_received)
4362: - l_ori_acq_amount - l_old_increments + l_rtv_adj_amount;
4363:
4364: fnd_file.put_line(fnd_file.log,'Adjustment amount : ' || to_char(l_acq_adjustment_amount));
4365:
4366: /* Now check if the amount to be posted is greater than 0.If it is then post an entry into MMT.Otherwise dont */
4367:
4368: IF l_acq_adjustment_amount <> 0 then

Line 4445: fnd_file.put_line(fnd_file.log,'item id : ' || to_char(l_item));

4441: /* Now get the accounts for all the cost elements */
4442:
4443: l_stmt_num := 70;
4444:
4445: fnd_file.put_line(fnd_file.log,'item id : ' || to_char(l_item));
4446: fnd_file.put_line(fnd_file.log,'org_id : ' || to_char(i_org_id));
4447:
4448:
4449: l_stmt_num := 90;

Line 4446: fnd_file.put_line(fnd_file.log,'org_id : ' || to_char(i_org_id));

4442:
4443: l_stmt_num := 70;
4444:
4445: fnd_file.put_line(fnd_file.log,'item id : ' || to_char(l_item));
4446: fnd_file.put_line(fnd_file.log,'org_id : ' || to_char(i_org_id));
4447:
4448:
4449: l_stmt_num := 90;
4450: select MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_transaction_id

Line 4976: fnd_file.put_line(fnd_file.log,'in get_rcv_rate');

4972:
4973: l_stmt_num := 10;
4974:
4975: IF g_debug = 'Y' THEN
4976: fnd_file.put_line(fnd_file.log,'in get_rcv_rate');
4977: fnd_file.put_line(fnd_file.log,'i_rcv_txn_id'||i_rcv_txn_id);
4978: END IF;
4979:
4980: --fixed BUG 13362339

Line 4977: fnd_file.put_line(fnd_file.log,'i_rcv_txn_id'||i_rcv_txn_id);

4973: l_stmt_num := 10;
4974:
4975: IF g_debug = 'Y' THEN
4976: fnd_file.put_line(fnd_file.log,'in get_rcv_rate');
4977: fnd_file.put_line(fnd_file.log,'i_rcv_txn_id'||i_rcv_txn_id);
4978: END IF;
4979:
4980: --fixed BUG 13362339
4981: /*SELECT count(rcv_transaction_id)

Line 5097: fnd_file.put_line(fnd_file.log,'l_rcv_rate_'|| l_rcv_rate);

5093:
5094: END IF;*/
5095:
5096: IF g_debug = 'Y' THEN
5097: fnd_file.put_line(fnd_file.log,'l_rcv_rate_'|| l_rcv_rate);
5098: END IF;
5099:
5100: return l_rcv_rate;
5101:

Line 5709: fnd_file.put_line(fnd_file.log,'date is : '|| to_char(l_end_date,'DD-MON-RR'));

5705: l_end_date := to_date(i_end_date,'RR/MM/DD HH24:MI:SS');
5706:
5707: If G_DEBUG = 'Y' then
5708:
5709: fnd_file.put_line(fnd_file.log,'date is : '|| to_char(l_end_date,'DD-MON-RR'));
5710:
5711: End If;
5712:
5713: l_stmt_num := 10;

Line 5718: fnd_file.put_line(fnd_file.log,'Legal Entity : '|| to_char(i_legal_entity));

5714:
5715:
5716: /* start printing out the Parameters */
5717:
5718: fnd_file.put_line(fnd_file.log,'Legal Entity : '|| to_char(i_legal_entity));
5719: fnd_file.put_line(fnd_file.log,'Cost Type : '|| to_char(i_cost_type_id));
5720: fnd_file.put_line(fnd_file.log,'Period : '|| to_char(i_period));
5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));
5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));

Line 5719: fnd_file.put_line(fnd_file.log,'Cost Type : '|| to_char(i_cost_type_id));

5715:
5716: /* start printing out the Parameters */
5717:
5718: fnd_file.put_line(fnd_file.log,'Legal Entity : '|| to_char(i_legal_entity));
5719: fnd_file.put_line(fnd_file.log,'Cost Type : '|| to_char(i_cost_type_id));
5720: fnd_file.put_line(fnd_file.log,'Period : '|| to_char(i_period));
5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));
5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));
5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));

Line 5720: fnd_file.put_line(fnd_file.log,'Period : '|| to_char(i_period));

5716: /* start printing out the Parameters */
5717:
5718: fnd_file.put_line(fnd_file.log,'Legal Entity : '|| to_char(i_legal_entity));
5719: fnd_file.put_line(fnd_file.log,'Cost Type : '|| to_char(i_cost_type_id));
5720: fnd_file.put_line(fnd_file.log,'Period : '|| to_char(i_period));
5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));
5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));
5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));
5724: fnd_file.put_line(fnd_file.log,'Run Option : '|| to_char(i_run_option));

Line 5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));

5717:
5718: fnd_file.put_line(fnd_file.log,'Legal Entity : '|| to_char(i_legal_entity));
5719: fnd_file.put_line(fnd_file.log,'Cost Type : '|| to_char(i_cost_type_id));
5720: fnd_file.put_line(fnd_file.log,'Period : '|| to_char(i_period));
5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));
5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));
5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));
5724: fnd_file.put_line(fnd_file.log,'Run Option : '|| to_char(i_run_option));
5725: fnd_file.put_line(fnd_file.log,'Receipt No : '|| to_char(i_receipt_no));

Line 5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));

5718: fnd_file.put_line(fnd_file.log,'Legal Entity : '|| to_char(i_legal_entity));
5719: fnd_file.put_line(fnd_file.log,'Cost Type : '|| to_char(i_cost_type_id));
5720: fnd_file.put_line(fnd_file.log,'Period : '|| to_char(i_period));
5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));
5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));
5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));
5724: fnd_file.put_line(fnd_file.log,'Run Option : '|| to_char(i_run_option));
5725: fnd_file.put_line(fnd_file.log,'Receipt No : '|| to_char(i_receipt_no));
5726: fnd_file.put_line(fnd_file.log,'Invoice No : '|| to_char(i_invoice_no));

Line 5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));

5719: fnd_file.put_line(fnd_file.log,'Cost Type : '|| to_char(i_cost_type_id));
5720: fnd_file.put_line(fnd_file.log,'Period : '|| to_char(i_period));
5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));
5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));
5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));
5724: fnd_file.put_line(fnd_file.log,'Run Option : '|| to_char(i_run_option));
5725: fnd_file.put_line(fnd_file.log,'Receipt No : '|| to_char(i_receipt_no));
5726: fnd_file.put_line(fnd_file.log,'Invoice No : '|| to_char(i_invoice_no));
5727:

Line 5724: fnd_file.put_line(fnd_file.log,'Run Option : '|| to_char(i_run_option));

5720: fnd_file.put_line(fnd_file.log,'Period : '|| to_char(i_period));
5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));
5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));
5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));
5724: fnd_file.put_line(fnd_file.log,'Run Option : '|| to_char(i_run_option));
5725: fnd_file.put_line(fnd_file.log,'Receipt No : '|| to_char(i_receipt_no));
5726: fnd_file.put_line(fnd_file.log,'Invoice No : '|| to_char(i_invoice_no));
5727:
5728: /* call the same Acquisition Cost Processor code with the new modified parameters */

Line 5725: fnd_file.put_line(fnd_file.log,'Receipt No : '|| to_char(i_receipt_no));

5721: fnd_file.put_line(fnd_file.log,'Process Upto date : '|| to_char(to_date(i_end_date,'RR/MM/DD HH24:MI:SS'),'DD-MON-RR'));
5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));
5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));
5724: fnd_file.put_line(fnd_file.log,'Run Option : '|| to_char(i_run_option));
5725: fnd_file.put_line(fnd_file.log,'Receipt No : '|| to_char(i_receipt_no));
5726: fnd_file.put_line(fnd_file.log,'Invoice No : '|| to_char(i_invoice_no));
5727:
5728: /* call the same Acquisition Cost Processor code with the new modified parameters */
5729:

Line 5726: fnd_file.put_line(fnd_file.log,'Invoice No : '|| to_char(i_invoice_no));

5722: fnd_file.put_line(fnd_file.log,'Cost Group : '|| to_char(i_cost_group_id));
5723: fnd_file.put_line(fnd_file.log,'Source : '|| to_char(i_source_flag));
5724: fnd_file.put_line(fnd_file.log,'Run Option : '|| to_char(i_run_option));
5725: fnd_file.put_line(fnd_file.log,'Receipt No : '|| to_char(i_receipt_no));
5726: fnd_file.put_line(fnd_file.log,'Invoice No : '|| to_char(i_invoice_no));
5727:
5728: /* call the same Acquisition Cost Processor code with the new modified parameters */
5729:
5730: l_stmt_num := 20;

Line 5762: fnd_file.put_line(fnd_file.log,'Exception occured in Acquisition_cost_adj_processor : ' || l_err_code || ' ' || l_err_msg);

5758: EXCEPTION
5759:
5760: WHEN others then
5761:
5762: fnd_file.put_line(fnd_file.log,'Exception occured in Acquisition_cost_adj_processor : ' || l_err_code || ' ' || l_err_msg);
5763:
5764: ROLLBACK;
5765:
5766: CONC_STATUS := fnd_concurrent.set_completion_status ('ERROR','CST_INVALID_EXCEPTION');