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

Line 144: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_txn << ' );

140: l_debug := fnd_profile.value('MRP_DEBUG');
141:
142:
143: IF (l_debug = 'Y' ) THEN
144: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_txn << ' );
145: END IF;
146:
147:
148: -- Populate local variables

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG, l_err_msg);

244:
245: IF ( (l_nl_trackable = 'Y' OR l_asset_creation_code IS NOT NULL) AND l_status = 'N') THEN
246: l_err_msg := 'WARNING: Item NL Trackable/Depreciable but NL not Installed';
247: IF (l_debug = 'Y' ) THEN
248: FND_FILE.PUT_LINE(FND_FILE.LOG, l_err_msg);
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NL Trackable Flag: ' || l_nl_trackable);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NL Depreciable Flag: ' || l_asset_creation_code);
251: END IF;
252: END IF;

Line 249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NL Trackable Flag: ' || l_nl_trackable);

245: IF ( (l_nl_trackable = 'Y' OR l_asset_creation_code IS NOT NULL) AND l_status = 'N') THEN
246: l_err_msg := 'WARNING: Item NL Trackable/Depreciable but NL not Installed';
247: IF (l_debug = 'Y' ) THEN
248: FND_FILE.PUT_LINE(FND_FILE.LOG, l_err_msg);
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NL Trackable Flag: ' || l_nl_trackable);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NL Depreciable Flag: ' || l_asset_creation_code);
251: END IF;
252: END IF;
253:

Line 250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NL Depreciable Flag: ' || l_asset_creation_code);

246: l_err_msg := 'WARNING: Item NL Trackable/Depreciable but NL not Installed';
247: IF (l_debug = 'Y' ) THEN
248: FND_FILE.PUT_LINE(FND_FILE.LOG, l_err_msg);
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NL Trackable Flag: ' || l_nl_trackable);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NL Depreciable Flag: ' || l_asset_creation_code);
251: END IF;
252: END IF;
253:
254: IF (l_status = 'I') THEN

Line 263: fnd_file.put_line(fnd_file.log,'Debug: CSE cost distribution hook : ' || to_char(l_cse_hook_used));

259: l_err_num,
260: l_err_code,
261: l_err_msg);
262: IF (l_debug = 'Y' ) THEN
263: fnd_file.put_line(fnd_file.log,'Debug: CSE cost distribution hook : ' || to_char(l_cse_hook_used));
264: END IF;
265:
266: IF (l_err_num <> 0) THEN
267: RAISE CST_FAILED_CSE_CALL;

Line 636: FND_FILE.put_line( FND_FILE.log, 'l_purch_encum_flag : '||l_purch_encum_flag );

632: END;
633: END IF;
634:
635: IF (l_debug = 'Y' ) THEN
636: FND_FILE.put_line( FND_FILE.log, 'l_purch_encum_flag : '||l_purch_encum_flag );
637: FND_FILE.put_line( FND_FILE.log, 'l_txn_act_id : '||l_txn_act_id);
638: FND_FILE.put_line( FND_FILE.log, 'l_src_type_id : '||l_src_type_id);
639: FND_FILE.put_line( FND_FILE.log, 'i_fob_point : '||i_fob_point);
640: FND_FILE.put_line( FND_FILE.log, 'l_txn_org_id : '||l_txn_org_id);

Line 637: FND_FILE.put_line( FND_FILE.log, 'l_txn_act_id : '||l_txn_act_id);

633: END IF;
634:
635: IF (l_debug = 'Y' ) THEN
636: FND_FILE.put_line( FND_FILE.log, 'l_purch_encum_flag : '||l_purch_encum_flag );
637: FND_FILE.put_line( FND_FILE.log, 'l_txn_act_id : '||l_txn_act_id);
638: FND_FILE.put_line( FND_FILE.log, 'l_src_type_id : '||l_src_type_id);
639: FND_FILE.put_line( FND_FILE.log, 'i_fob_point : '||i_fob_point);
640: FND_FILE.put_line( FND_FILE.log, 'l_txn_org_id : '||l_txn_org_id);
641: FND_FILE.put_line( FND_FILE.log, 'l_txf_org_id : '||l_txf_org_id);

Line 638: FND_FILE.put_line( FND_FILE.log, 'l_src_type_id : '||l_src_type_id);

634:
635: IF (l_debug = 'Y' ) THEN
636: FND_FILE.put_line( FND_FILE.log, 'l_purch_encum_flag : '||l_purch_encum_flag );
637: FND_FILE.put_line( FND_FILE.log, 'l_txn_act_id : '||l_txn_act_id);
638: FND_FILE.put_line( FND_FILE.log, 'l_src_type_id : '||l_src_type_id);
639: FND_FILE.put_line( FND_FILE.log, 'i_fob_point : '||i_fob_point);
640: FND_FILE.put_line( FND_FILE.log, 'l_txn_org_id : '||l_txn_org_id);
641: FND_FILE.put_line( FND_FILE.log, 'l_txf_org_id : '||l_txf_org_id);
642: FND_FILE.put_line( FND_FILE.log, 'i_org_id : '||i_org_id);

Line 639: FND_FILE.put_line( FND_FILE.log, 'i_fob_point : '||i_fob_point);

635: IF (l_debug = 'Y' ) THEN
636: FND_FILE.put_line( FND_FILE.log, 'l_purch_encum_flag : '||l_purch_encum_flag );
637: FND_FILE.put_line( FND_FILE.log, 'l_txn_act_id : '||l_txn_act_id);
638: FND_FILE.put_line( FND_FILE.log, 'l_src_type_id : '||l_src_type_id);
639: FND_FILE.put_line( FND_FILE.log, 'i_fob_point : '||i_fob_point);
640: FND_FILE.put_line( FND_FILE.log, 'l_txn_org_id : '||l_txn_org_id);
641: FND_FILE.put_line( FND_FILE.log, 'l_txf_org_id : '||l_txf_org_id);
642: FND_FILE.put_line( FND_FILE.log, 'i_org_id : '||i_org_id);
643: END IF;

Line 640: FND_FILE.put_line( FND_FILE.log, 'l_txn_org_id : '||l_txn_org_id);

636: FND_FILE.put_line( FND_FILE.log, 'l_purch_encum_flag : '||l_purch_encum_flag );
637: FND_FILE.put_line( FND_FILE.log, 'l_txn_act_id : '||l_txn_act_id);
638: FND_FILE.put_line( FND_FILE.log, 'l_src_type_id : '||l_src_type_id);
639: FND_FILE.put_line( FND_FILE.log, 'i_fob_point : '||i_fob_point);
640: FND_FILE.put_line( FND_FILE.log, 'l_txn_org_id : '||l_txn_org_id);
641: FND_FILE.put_line( FND_FILE.log, 'l_txf_org_id : '||l_txf_org_id);
642: FND_FILE.put_line( FND_FILE.log, 'i_org_id : '||i_org_id);
643: END IF;
644:

Line 641: FND_FILE.put_line( FND_FILE.log, 'l_txf_org_id : '||l_txf_org_id);

637: FND_FILE.put_line( FND_FILE.log, 'l_txn_act_id : '||l_txn_act_id);
638: FND_FILE.put_line( FND_FILE.log, 'l_src_type_id : '||l_src_type_id);
639: FND_FILE.put_line( FND_FILE.log, 'i_fob_point : '||i_fob_point);
640: FND_FILE.put_line( FND_FILE.log, 'l_txn_org_id : '||l_txn_org_id);
641: FND_FILE.put_line( FND_FILE.log, 'l_txf_org_id : '||l_txf_org_id);
642: FND_FILE.put_line( FND_FILE.log, 'i_org_id : '||i_org_id);
643: END IF;
644:
645:

Line 642: FND_FILE.put_line( FND_FILE.log, 'i_org_id : '||i_org_id);

638: FND_FILE.put_line( FND_FILE.log, 'l_src_type_id : '||l_src_type_id);
639: FND_FILE.put_line( FND_FILE.log, 'i_fob_point : '||i_fob_point);
640: FND_FILE.put_line( FND_FILE.log, 'l_txn_org_id : '||l_txn_org_id);
641: FND_FILE.put_line( FND_FILE.log, 'l_txf_org_id : '||l_txf_org_id);
642: FND_FILE.put_line( FND_FILE.log, 'i_org_id : '||i_org_id);
643: END IF;
644:
645:
646:

Line 692: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Reversal' );

688: and l_enc_org_cost_method = 1 )
689: ) THEN
690:
691: IF (l_debug = 'Y' ) THEN
692: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Reversal' );
693: END IF;
694: CSTPAVCP.CompEncumbrance_IntOrdersExp (
695: p_api_version => 1.0,
696: p_transaction_id => i_txn_id,

Line 703: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Amount: '||l_enc_amount||', Encumbrance Account: '||l_enc_acct );

699: x_return_status => l_return_status,
700: x_return_message => l_return_message );
701:
702: IF (l_debug = 'Y' ) THEN
703: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Amount: '||l_enc_amount||', Encumbrance Account: '||l_enc_acct );
704: END IF;
705: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;

Line 735: fnd_file.put_line(fnd_file.log, 'Getting Po_Distribution_id for Receving transaction :'||l_rcv_transaction_id);

731: taxes for ENCUMBRANCE_REVERSAL event */
732: IF (l_txn_act_id <> 6) THEN
733:
734: IF l_debug = 'Y' THEN
735: fnd_file.put_line(fnd_file.log, 'Getting Po_Distribution_id for Receving transaction :'||l_rcv_transaction_id);
736: END IF;
737:
738: l_stmt_num := 43;
739: SELECT po_distribution_id

Line 745: fnd_file.put_line(fnd_file.log, 'Calling CST_Common_hooks.Get_NRtax_amount for PO_DIST :'||l_loc_po_distribution_id);

741: FROM rcv_transactions
742: WHERE transaction_id =l_rcv_transaction_id;
743:
744: IF l_debug = 'Y' THEN
745: fnd_file.put_line(fnd_file.log, 'Calling CST_Common_hooks.Get_NRtax_amount for PO_DIST :'||l_loc_po_distribution_id);
746: END IF;
747:
748: l_stmt_num := 45;
749: l_hook_used := CST_Common_hooks.Get_NRtax_amount(

Line 770: fnd_file.put_line(fnd_file.log, 'Error getting Enc Tax in CST_Common_hooks.Get_NRtax_amount at statement :'||l_stmt_num);

766:
767: IF (l_err_num <> 0) THEN
768: -- Error occured
769: IF l_debug = 'Y' THEN
770: fnd_file.put_line(fnd_file.log, 'Error getting Enc Tax in CST_Common_hooks.Get_NRtax_amount at statement :'||l_stmt_num);
771: fnd_file.put_line(fnd_file.log, 'Error Code : '||l_err_code||' Error Message : '||l_err_msg);
772: END IF;
773: RAISE process_error;
774: END IF;

Line 771: fnd_file.put_line(fnd_file.log, 'Error Code : '||l_err_code||' Error Message : '||l_err_msg);

767: IF (l_err_num <> 0) THEN
768: -- Error occured
769: IF l_debug = 'Y' THEN
770: fnd_file.put_line(fnd_file.log, 'Error getting Enc Tax in CST_Common_hooks.Get_NRtax_amount at statement :'||l_stmt_num);
771: fnd_file.put_line(fnd_file.log, 'Error Code : '||l_err_code||' Error Message : '||l_err_msg);
772: END IF;
773: RAISE process_error;
774: END IF;
775:

Line 777: fnd_file.put_line(fnd_file.log,'Hook Used CST_Common_hooks.Get_NRtax_amount :'|| l_hook_used ||

773: RAISE process_error;
774: END IF;
775:
776: IF l_debug = 'Y' THEN
777: fnd_file.put_line(fnd_file.log,'Hook Used CST_Common_hooks.Get_NRtax_amount :'|| l_hook_used ||
778: ' l_loc_recoverable_tax : '||l_loc_recoverable_tax||
779: ' l_loc_non_recoverable_tax : '||l_loc_non_recoverable_tax);
780: END IF;
781:

Line 828: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_Txn >>');

824: where transaction_id = i_txn_id
825: and transaction_costed_date is NULL;
826:
827: IF (l_debug = 'Y' ) THEN
828: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_Txn >>');
829: END IF;
830:
831: EXCEPTION
832:

Line 1398: fnd_file.put_line(fnd_file.log, 'failed after distribute_accounts');

1394:
1395: -- check error
1396:
1397: if(l_err_num <> 0) then
1398: fnd_file.put_line(fnd_file.log, 'failed after distribute_accounts');
1399: raise process_error;
1400: end if;
1401:
1402: if (i_txn_act_id = 30) then /* WIP Scrap */

Line 1444: fnd_file.put_line(fnd_file.log, 'failed after inv_accounts');

1440: i_prg_appl_id, i_prg_id,
1441: l_err_num, l_err_code, l_err_msg);
1442:
1443: if(l_err_num <> 0) then
1444: fnd_file.put_line(fnd_file.log, 'failed after inv_accounts');
1445: raise process_error;
1446: end if;
1447:
1448:

Line 1473: fnd_file.put_line(fnd_file.log, 'failed after ovhd_accounts');

1469: l_err_num, l_err_code, l_err_msg);
1470:
1471:
1472: if(l_err_num <> 0) then
1473: fnd_file.put_line(fnd_file.log, 'failed after ovhd_accounts');
1474: raise process_error;
1475: end if;
1476:
1477: end if;

Line 1484: fnd_file.put_line(fnd_file.log,'process raised');

1480:
1481: EXCEPTION
1482:
1483: when process_error then
1484: fnd_file.put_line(fnd_file.log,'process raised');
1485: rollback;
1486: O_error_num := l_err_num;
1487: O_error_code := l_err_code;
1488: O_error_message := l_err_msg;

Line 1491: fnd_file.put_line(fnd_file.log,'other exceptions raised');

1487: O_error_code := l_err_code;
1488: O_error_message := l_err_msg;
1489:
1490: when others then
1491: fnd_file.put_line(fnd_file.log,'other exceptions raised');
1492: rollback;
1493: O_error_num := SQLCODE;
1494: O_error_message := 'CSTPACDP.wip_cost_txn (' || to_char(l_stmt_num) ||
1495: '): ' || substr(SQLERRM,1,180);

Line 1830: fnd_file.put_line(fnd_file.log, 'expense item or sub (not PO source or not consigned). So, no accounting for txn: ' || i_txn_id);

1826: (i_src_type_id <>1) and
1827: (i_txn_act_id <> 6) and
1828: (NOT (l_pd_xfer_ind = 'Y' and i_txn_act_id = 1 and i_src_type_id = 8)))
1829: then
1830: fnd_file.put_line(fnd_file.log, 'expense item or sub (not PO source or not consigned). So, no accounting for txn: ' || i_txn_id);
1831: return;
1832: elsif (i_exp_item = 1 and l_exp_acct = -1) then
1833:
1834: l_stmt_num := 20;

Line 1857: fnd_file.put_line(fnd_file.log, 'Process/Discrete Internal Order issue for Asset Item from Expense Sub-Inventory.');

1853: * doesnt get booked *
1854: ****************************************************************************************/
1855: if (l_pd_xfer_ind = 'Y' and i_txn_act_id = 1 and i_src_type_id = 8 AND l_exp_sub = 1 and i_exp_item = 0) /* Bug#5485052 ANTHIYAG 23-Aug-2006 */
1856: then
1857: fnd_file.put_line(fnd_file.log, 'Process/Discrete Internal Order issue for Asset Item from Expense Sub-Inventory.');
1858:
1859: distribute_accounts(i_org_id, i_txn_id,
1860: 0,i_cost_grp_id,i_txn_act_id,
1861: i_item_id, i_p_qty, 2,

Line 1875: fnd_file.put_line(fnd_file.log, 'Posting elemental inv accounts');

1871: end if;
1872: elsif (l_pd_xfer_ind = 'N') OR
1873: (l_pd_xfer_ind = 'Y' and i_txn_act_id = 1 and i_src_type_id = 8 AND l_exp_sub = 0 and i_exp_item = 0) /* Bug#5485052 ANTHIYAG 23-Aug-2006 */
1874: then
1875: fnd_file.put_line(fnd_file.log, 'Posting elemental inv accounts');
1876:
1877: inventory_accounts(i_org_id, i_txn_id, 2,
1878: i_txn_act_id,i_cost_grp_id,
1879: i_item_id, i_p_qty,

Line 2119: FND_FILE.put_line(FND_FILE.log, 'Internal Order Issue to Expense');

2115: END IF;
2116: END IF;
2117:
2118: IF l_debug = 'Y' THEN
2119: FND_FILE.put_line(FND_FILE.log, 'Internal Order Issue to Expense');
2120: FND_FILE.put_line(FND_FILE.log, 'Debit Account - Receivables: '||to_char(l_acct) || ' InterOrg profit: ' || l_io_profit_acct);
2121: END IF;
2122:
2123: l_elemental := 0;

Line 2120: FND_FILE.put_line(FND_FILE.log, 'Debit Account - Receivables: '||to_char(l_acct) || ' InterOrg profit: ' || l_io_profit_acct);

2116: END IF;
2117:
2118: IF l_debug = 'Y' THEN
2119: FND_FILE.put_line(FND_FILE.log, 'Internal Order Issue to Expense');
2120: FND_FILE.put_line(FND_FILE.log, 'Debit Account - Receivables: '||to_char(l_acct) || ' InterOrg profit: ' || l_io_profit_acct);
2121: END IF;
2122:
2123: l_elemental := 0;
2124: l_ovhd_absp := 0;

Line 2134: fnd_file.put_line(fnd_file.log, 'distribute_accounts()');

2130: l_elemental := 0;
2131: l_ovhd_absp := 0;
2132: end if;
2133:
2134: fnd_file.put_line(fnd_file.log, 'distribute_accounts()');
2135:
2136: -- Now for RMA receipts that reference an original sales order line ID
2137: IF (i_src_type_id = 12 AND i_txn_act_id = 27 AND l_ref_om_line_id IS NOT NULL) THEN
2138:

Line 2210: fnd_file.put_line(fnd_file.log,'Process/Discrete IO Issue to Exp Destination transaction');

2206: --
2207: -- Book Receivalbes with transfer price
2208: -- Book Interorg Profit with diff of transfer price and cost
2209: --
2210: fnd_file.put_line(fnd_file.log,'Process/Discrete IO Issue to Exp Destination transaction');
2211:
2212: l_stmt_num := 50;
2213:
2214: l_io_receivable_acct := l_acct;

Line 2234: fnd_file.put_line(fnd_file.log, 'booking receivables: ' || (-1 * i_p_qty * l_transfer_price) ||' ' || i_pri_curr);

2230: end if;
2231:
2232: l_stmt_num := 60;
2233:
2234: fnd_file.put_line(fnd_file.log, 'booking receivables: ' || (-1 * i_p_qty * l_transfer_price) ||' ' || i_pri_curr);
2235:
2236: insert_account(i_org_id, i_txn_id, i_item_id, -1 * i_p_qty * l_transfer_price,
2237: -1 * i_p_qty, l_acct, i_sob_id, l_acct_line_type,
2238: NULL, NULL,

Line 2252: fnd_file.put_line(fnd_file.log, 'booking interorg profit if necessary');

2248:
2249: --
2250: -- Book InterOrg Profit
2251: --
2252: fnd_file.put_line(fnd_file.log, 'booking interorg profit if necessary');
2253:
2254:
2255: l_stmt_num := 70;
2256: SELECT SUM(NVL(base_transaction_value,0))

Line 2263: fnd_file.put_line(fnd_file.log,'InterOrg Profit amount: ' || l_value);

2259: WHERE transaction_id = i_txn_id
2260: AND organization_id = i_org_id
2261: ;
2262:
2263: fnd_file.put_line(fnd_file.log,'InterOrg Profit amount: ' || l_value);
2264:
2265: IF l_value <> 0
2266: THEN
2267:

Line 2316: fnd_file.put_line(fnd_file.log, 'ovhd_accounts()');

2312: and level_type = 1;
2313:
2314: if (l_mat_ovhd_exists > 0) then
2315:
2316: fnd_file.put_line(fnd_file.log, 'ovhd_accounts()');
2317: ovhd_accounts(i_org_id, i_txn_id, i_item_id, -1 * i_p_qty, i_sob_id,
2318: i_txn_date,i_txn_src_id, i_src_type_id,
2319: i_subinv, NULL,
2320: i_pri_curr, i_alt_curr, i_conv_date,

Line 2489: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');

2485: l_return_status := fnd_api.g_ret_sts_success;
2486: l_msg_count := 0;
2487:
2488:
2489: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2490: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2491: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);

Line 2490: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);

2486: l_msg_count := 0;
2487:
2488:
2489: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2490: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2491: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2494: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);

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

2487:
2488:
2489: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2490: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2491: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2494: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2495: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);

Line 2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);

2488:
2489: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2490: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2491: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2494: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2495: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2496: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);

Line 2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);

2489: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2490: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2491: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2494: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2495: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2496: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);
2497:

Line 2494: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);

2490: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2491: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2494: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2495: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2496: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);
2497:
2498: /* OPM INVCONV sschinch check if this is a process discrete transfer */

Line 2495: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);

2491: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2494: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2495: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2496: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);
2497:
2498: /* OPM INVCONV sschinch check if this is a process discrete transfer */
2499: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)

Line 2496: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);

2492: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2493: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2494: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2495: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2496: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);
2497:
2498: /* OPM INVCONV sschinch check if this is a process discrete transfer */
2499: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)
2500: INTO l_pd_txfr_ind

Line 2531: fnd_file.put_line(fnd_file.LOG, 'SrcTypeID/ActID = ' || i_src_type_id ||'/'|| i_txn_act_id ||

2527: WHERE org_information_context = 'Accounting Information'
2528: AND organization_id = i_txf_org_id;
2529:
2530: l_io_invoicing := to_number(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'));
2531: fnd_file.put_line(fnd_file.LOG, 'SrcTypeID/ActID = ' || i_src_type_id ||'/'|| i_txn_act_id ||
2532: ' OU/xferOU: ' || l_org_ou ||'/'|| l_txf_org_ou ||
2533: ' Internal Order invoicing: ' || l_io_invoicing);
2534:
2535: END IF;

Line 2628: fnd_file.put_line(fnd_file.log,'l_snd_rcv:' || l_snd_rcv);

2624: (i_txn_act_id = 15 and i_org_id = i_txn_org_id)) then -- OPM INVCONV umoogala
2625: l_snd_rcv := 2;
2626: end if;
2627:
2628: fnd_file.put_line(fnd_file.log,'l_snd_rcv:' || l_snd_rcv);
2629:
2630:
2631: if (l_snd_rcv = 1) then
2632: if (i_org_id = i_txn_org_id or i_txn_act_id = 3) then

Line 2685: fnd_file.put_line(fnd_file.log,'l_from_org:' || l_from_org);

2681: l_subinv := NULL;
2682: end if;
2683: end if;
2684:
2685: fnd_file.put_line(fnd_file.log,'l_from_org:' || l_from_org);
2686: fnd_file.put_line(fnd_file.log,'l_to_org:' || l_to_org);
2687:
2688:
2689:

Line 2686: fnd_file.put_line(fnd_file.log,'l_to_org:' || l_to_org);

2682: end if;
2683: end if;
2684:
2685: fnd_file.put_line(fnd_file.log,'l_from_org:' || l_from_org);
2686: fnd_file.put_line(fnd_file.log,'l_to_org:' || l_to_org);
2687:
2688:
2689:
2690: CSTPAVCP.get_snd_rcv_rate(i_txn_id, l_from_org, l_to_org,

Line 2850: fnd_file.put_line(fnd_file.log,'Sending org distributions');

2846:
2847: /*******************************************************************
2848: ** Do sending org distribution **
2849: *******************************************************************/
2850: fnd_file.put_line(fnd_file.log,'Sending org distributions');
2851:
2852: if (l_from_org = i_org_id) and (i_txn_act_id = 22) -- OPM INVCONV umoogala
2853: then
2854: /* INVCONV Bug#5476804 ANTHIYAG 21-Aug-2006 Start */

Line 2861: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: No bookings will be created, since this is an Expense item and Invoicing is enabled');

2857: * Inter-Org profit accounts need to be booked, Otherwise if Intercompany Invoicing is enabled *
2858: * for a Expense Item, No need for creating any bookings at all *
2859: ***********************************************************************************************/
2860: IF i_exp_item = 1 AND l_pd_txfr_ind = 1 AND nvl(l_io_invoicing,2) = 1 AND i_src_type_id = 8 AND l_org_ou <> l_txf_org_ou THEN /* INVCONV Bug#5498133/5498041 ANTHIYAG 30-Aug-2006 */
2861: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: No bookings will be created, since this is an Expense item and Invoicing is enabled');
2862: RETURN;
2863: END IF;
2864: /* INVCONV Bug#5476804 ANTHIYAG 21-Aug-2006 End */
2865: --

Line 2890: fnd_file.put_line(fnd_file.log,'Freight account: ' || l_value);

2886: if (l_acct = -1) then
2887: l_acct := i_trp_acct;
2888: end if;
2889:
2890: fnd_file.put_line(fnd_file.log,'Freight account: ' || l_value);
2891:
2892: insert_account(l_from_org, i_txn_id, i_item_id, -1*l_value,
2893: l_snd_qty, l_acct, l_snd_sob_id, 12, NULL, NULL,
2894: i_txn_date, i_txn_src_id, i_src_type_id,

Line 2914: fnd_file.put_line(fnd_file.log,'Receivables amount: ' || l_value);

2910: -- l_value := i_trp_cost + (i_txf_price * l_snd_qty);
2911: --
2912: l_value := i_txf_price * l_snd_qty;
2913:
2914: fnd_file.put_line(fnd_file.log,'Receivables amount: ' || l_value);
2915:
2916: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 10,
2917: NULL, NULL, l_subinv,0, l_snd_rcv,
2918: l_err_num, l_err_code, l_err_msg,NULL);

Line 2948: fnd_file.put_line(fnd_file.log,'Intransit account: with item cost' );

2944: --
2945: if i_exp_item = 0
2946: then
2947:
2948: fnd_file.put_line(fnd_file.log,'Intransit account: with item cost' );
2949:
2950: /*
2951: --
2952: -- Bug 4900652

Line 2992: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||

2988: and (i_txn_act_id = 21) -- Bug 5351724
2989: and (i_exp_item = 1) -- Bug 5348953: No IC Invoicing for expense items
2990: then
2991: NULL;
2992: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||
2993: 'is enabled.');
2994: else
2995: /* Book InterOrg profit */
2996: SELECT SUM(NVL(base_transaction_value,0))

Line 3003: fnd_file.put_line(fnd_file.log,'InterOrg Profit amount: ' || l_value);

2999: WHERE transaction_id = i_txn_id
3000: AND organization_id = l_from_org
3001: ;
3002:
3003: fnd_file.put_line(fnd_file.log,'InterOrg Profit amount: ' || l_value);
3004:
3005: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 34,
3006: NULL, NULL, l_subinv,0, l_snd_rcv,
3007: l_err_num, l_err_code, l_err_msg,NULL);

Line 3097: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: No bookings will be created, since this is a Expense item and Invoicing is enabled');

3093: * for a Expense Item, No need for creating any bookings at all *
3094: ***********************************************************************************************/
3095:
3096: IF nvl(l_io_invoicing,2) = 1 AND i_src_type_id IN (7, 8) AND l_org_ou <> l_txf_org_ou THEN /* INVCONV Bug#5498133/5498041 ANTHIYAG 30-Aug-2006 */
3097: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: No bookings will be created, since this is a Expense item and Invoicing is enabled');
3098: RETURN;
3099: ELSE
3100: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: Not booking to expense. Receivables and InterOrg Profit Accounts will get booked');
3101: END IF;

Line 3100: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: Not booking to expense. Receivables and InterOrg Profit Accounts will get booked');

3096: IF nvl(l_io_invoicing,2) = 1 AND i_src_type_id IN (7, 8) AND l_org_ou <> l_txf_org_ou THEN /* INVCONV Bug#5498133/5498041 ANTHIYAG 30-Aug-2006 */
3097: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: No bookings will be created, since this is a Expense item and Invoicing is enabled');
3098: RETURN;
3099: ELSE
3100: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: Not booking to expense. Receivables and InterOrg Profit Accounts will get booked');
3101: END IF;
3102: /* INVCONV Bug#5465239 ANTHIYAG 18-Aug-2006 End */
3103: else
3104: distribute_accounts(l_from_org, i_txn_id,

Line 3176: fnd_file.put_line(fnd_file.log,'Transfer Credit account: ' || l_value);

3172: else
3173: l_value := i_txf_cost;
3174: end if;
3175:
3176: fnd_file.put_line(fnd_file.log,'Transfer Credit account: ' || l_value);
3177:
3178: /* Credit sending org transfer credit */
3179: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 11,
3180: NULL, NULL, l_subinv,0, l_snd_rcv,

Line 3223: fnd_file.put_line(fnd_file.log,'Freight account: ' || l_value);

3219: else
3220: l_value := i_trp_cost;
3221: end if;
3222:
3223: fnd_file.put_line(fnd_file.log,'Freight account: ' || l_value);
3224:
3225: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 12,
3226: NULL, NULL, l_subinv,0, l_snd_rcv,
3227: l_err_num, l_err_code, l_err_msg,NULL);

Line 3279: fnd_file.put_line(fnd_file.log,'receivables account: ' || l_value);

3275: else
3276: l_value := i_txf_price * l_snd_qty; -- OPM INVCONV umoogala/sschinch
3277: end if;
3278:
3279: fnd_file.put_line(fnd_file.log,'receivables account: ' || l_value);
3280:
3281: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 10,
3282: NULL, NULL, l_subinv,0, l_snd_rcv,
3283: l_err_num, l_err_code, l_err_msg,NULL);

Line 3328: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||

3324: AND (i_txn_act_id = 21) -- Bug 5351724
3325: AND (i_exp_item = 0) -- Bug 5348953: No IC Invoicing for expense items
3326: THEN
3327: NULL;
3328: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||
3329: 'is enabled.');
3330: ELSE
3331:
3332: /* Book interorg profit */

Line 3340: fnd_file.put_line(fnd_file.log,'InterOrg profit account: ' || l_value);

3336: WHERE transaction_id = i_txn_id
3337: AND organization_id = l_from_org
3338: ;
3339:
3340: fnd_file.put_line(fnd_file.log,'InterOrg profit account: ' || l_value);
3341:
3342: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1,
3343: G_INTERORG_PROFIT_ACCT,
3344: NULL, NULL, l_subinv,0, l_snd_rcv,

Line 3459: fnd_file.put_line(fnd_file.log,'Receiving org distributions');

3455:
3456: /*******************************************************************
3457: ** Do receiving org distribution **
3458: *******************************************************************/
3459: fnd_file.put_line(fnd_file.log,'Receiving org distributions');
3460:
3461: /* Begin OPM INVCONV sschinch Logical Intransit Receipt FOB Shipping*/
3462: if (i_txn_act_id = 15)
3463: then

Line 3475: fnd_file.put_line(fnd_file.log,'Dr intransit account @ org cost');

3471: -- Dr Intransit
3472: -- Amount should be (transfer_price + freight)
3473: -- actual_cost in mcacd is (transfer_price + freight)
3474: --
3475: fnd_file.put_line(fnd_file.log,'Dr intransit account @ org cost');
3476:
3477: /* Dr Receiving Org's intransit. */
3478: l_intransit := 1;
3479:

Line 3512: fnd_file.put_line(fnd_file.log,'Cr payable. amount(l_value):' || -1 * l_value);

3508: -- Cr InterOrg Payables with transfer price.
3509: --
3510: l_value := i_txf_price * l_rcv_qty;
3511:
3512: fnd_file.put_line(fnd_file.log,'Cr payable. amount(l_value):' || -1 * l_value);
3513:
3514: /* INVCONV Bug#5471471 ANTHIYAG 18-Aug-2006 Start */
3515: /************************************************************************************
3516: * If Intercompany invoicing is enabled, then the booking should be made against the *

Line 3592: fnd_file.put_line(fnd_file.log,'Cr Freight. amount(l_value):' || -1 * l_value);

3588: if (l_acct = -1) then
3589: l_acct := i_trp_acct;
3590: end if;
3591:
3592: fnd_file.put_line(fnd_file.log,'Cr Freight. amount(l_value):' || -1 * l_value);
3593: insert_account(l_to_org, i_txn_id, i_item_id, -1 * l_value,
3594: l_rcv_qty, l_acct, l_rcv_sob_id, 12, NULL, NULL,
3595: i_txn_date, i_txn_src_id, i_src_type_id,
3596: l_rcv_curr, l_snd_curr,

Line 3643: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);

3639: where mctcd.transaction_id = i_txn_id
3640: and mctcd.organization_id = l_std_org
3641: ;
3642:
3643: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);
3644:
3645: l_stmt_num := 90;
3646:
3647: -- If MOH Absorption is overridden, the this level moh costs have to be driven to ppv.

Line 3692: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);

3688: and level_type = 1);
3689: -- Earn only this level MOH
3690: END IF;
3691:
3692: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);
3693:
3694:
3695: -- Changes for PJM for Standard Costing
3696: l_stmt_num := 95;

Line 3745: fnd_file.put_line(fnd_file.log,'l_intransit:' || l_intransit);

3741: else
3742: l_intransit := 0;
3743: end if;
3744:
3745: fnd_file.put_line(fnd_file.log,'l_intransit:' || l_intransit);
3746:
3747:
3748: -- First do the distributions for ownership change
3749: if ((i_txn_act_id = 3 and i_txn_qty > 0) or

Line 3754: fnd_file.put_line(fnd_file.log,'Calling Inventory acct');

3750: (i_txn_act_id = 21 and i_fob_point = 1) or
3751: (i_txn_act_id = 12 and i_fob_point = 2)) then
3752: if (l_to_org = i_org_id) then /* Avg Costing */
3753: /* Debit inventory or intransit at receiving org's cost */
3754: fnd_file.put_line(fnd_file.log,'Calling Inventory acct');
3755:
3756: --
3757: -- OPM INVCONV umoogala
3758: -- Added if/else block to process process-discrete transfers

Line 3818: fnd_file.put_line(fnd_file.log, 'l_acct_line_type:' || l_acct_line_type);

3814: l_acct_line_type := 1;
3815: end if;
3816:
3817: if (l_debug = 'Y') then
3818: fnd_file.put_line(fnd_file.log, 'l_acct_line_type:' || l_acct_line_type);
3819: end if;
3820:
3821:
3822: --

Line 3826: fnd_file.put_line(fnd_file.log,'calling insert_account for booking INV with value/qty: ' || l_value ||'/'||l_rcv_qty);

3822: --
3823: -- Bug 5391121: incorrect sign for qty
3824: -- was: -1 * l_rcv_qty, now: l_rcv_qty
3825: --
3826: fnd_file.put_line(fnd_file.log,'calling insert_account for booking INV with value/qty: ' || l_value ||'/'||l_rcv_qty);
3827: insert_account(l_to_org, i_txn_id, i_item_id, l_value,
3828: l_rcv_qty, l_acct, l_rcv_sob_id, l_acct_line_type, NULL, NULL,
3829: i_txn_date, i_txn_src_id, i_src_type_id,
3830: l_rcv_curr, l_snd_curr,

Line 3843: fnd_file.put_line(fnd_file.log,'Calling distribute accts');

3839: end if;
3840: end if; -- OPM INVCONV umoogala
3841:
3842: else /* Std Costing Org */
3843: fnd_file.put_line(fnd_file.log,'Calling distribute accts');
3844:
3845: if (l_intransit = 1 and l_std_exp_item = 0) then
3846: distribute_accounts(l_to_org, i_txn_id,
3847: 0,i_cost_grp_id,i_txn_act_id,

Line 3860: fnd_file.put_line(fnd_file.log,'Calling distribute accts(2)');

3856: raise process_error;
3857: end if;
3858:
3859: else
3860: fnd_file.put_line(fnd_file.log,'Calling distribute accts(2)');
3861:
3862: if (l_std_exp_item = 1 or l_std_exp_sub = 1) then
3863: distribute_accounts(l_to_org, i_txn_id,
3864: 0,i_cost_grp_id,i_txn_act_id,

Line 3877: fnd_file.put_line(fnd_file.log,'Calling distribute accts(3)');

3873: raise process_error;
3874: end if;
3875:
3876: else
3877: fnd_file.put_line(fnd_file.log,'Calling distribute accts(3)');
3878:
3879: distribute_accounts(l_to_org, i_txn_id,
3880: 0,i_cost_grp_id,i_txn_act_id,
3881: i_item_id, l_rcv_qty, 1,

Line 3911: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);

3907: from mtl_cst_txn_cost_details mctcd
3908: where mctcd.transaction_id = i_txn_id
3909: and mctcd.organization_id = l_std_org;
3910:
3911: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);
3912:
3913: l_stmt_num := 90;
3914:
3915: /* If MOH Absorption is overridden, the this level moh costs

Line 3961: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);

3957: and level_type = 1);
3958: /* Earn only this level MOH */
3959: END IF;
3960:
3961: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);
3962:
3963:
3964: /* Changes for PJM for Standard Costing */
3965: l_stmt_num := 95;

Line 4110: fnd_file.put_line(fnd_file.log,'Inter Company Accrual amount(l_value):' || l_value || ' acct: ' || l_acct);

4106: if (l_err_num <> 0) then
4107: raise process_error;
4108: end if;
4109:
4110: fnd_file.put_line(fnd_file.log,'Inter Company Accrual amount(l_value):' || l_value || ' acct: ' || l_acct);
4111:
4112: ELSE
4113: /* INVCONV Bug#5476815 ANTHIYAG 21-Aug-2006 End */
4114:

Line 4126: fnd_file.put_line(fnd_file.log,'Payable amount(l_value):' || l_value || ' acct: ' || l_acct);

4122: if (l_acct = -1) then
4123: l_acct := l_io_pay_acct;
4124: end if;
4125:
4126: fnd_file.put_line(fnd_file.log,'Payable amount(l_value):' || l_value || ' acct: ' || l_acct);
4127:
4128: /* Bug 3169767: use -1*l_rcv_qty */
4129: insert_account(l_to_org, i_txn_id, i_item_id, -1 * l_value,
4130: -1 * l_rcv_qty, l_acct, l_rcv_sob_id, 9, NULL, NULL,

Line 4309: fnd_file.put_line(fnd_file.log,'Std org: Dr inv at receiving org cost');

4305: */
4306:
4307: elsif (l_std_exp_item = 0 AND l_std_org = l_to_org ) then /* Standard Cost Org */
4308:
4309: fnd_file.put_line(fnd_file.log,'Std org: Dr inv at receiving org cost');
4310:
4311:
4312: /* Debit Invenoty at Rcv org's cost */
4313: if (l_std_exp_sub = 1) then

Line 4445: fnd_file.put_line(fnd_file.log, 'CSTPACDP.avcu_cost_txn: ' || FND_MESSAGE.Get);

4441:
4442: l_stmt_num := 2;
4443: if (i_qty = 0 and l_debug = 'Y') THEN
4444: FND_MESSAGE.set_name('BOM', 'CST_UPDATE_ZERO_QTY');
4445: fnd_file.put_line(fnd_file.log, 'CSTPACDP.avcu_cost_txn: ' || FND_MESSAGE.Get);
4446: end if;
4447:
4448: l_stmt_num := 5;
4449:

Line 5530: fnd_file.put_line(fnd_file.log, 'In Inventory_accounts');

5526: l_cost := '';
5527:
5528: l_stmt_num := 10;
5529:
5530: fnd_file.put_line(fnd_file.log, 'In Inventory_accounts');
5531:
5532: l_debug := fnd_profile.value('MRP_DEBUG');
5533:
5534: select decode(i_exp_item, 0, nvl(i_exp_subinv,0), i_exp_item)

Line 5605: fnd_file.put_line(fnd_file.log, 'layer_id:' || l_layer_id);

5601: and organization_id = i_org_id
5602: and cost_group_id = i_cost_grp_id;
5603:
5604: if (l_debug = 'Y') then
5605: fnd_file.put_line(fnd_file.log, 'layer_id:' || l_layer_id);
5606: end if;
5607:
5608:
5609: if (i_intransit = 1 and i_exp_item = 0) then

Line 5619: fnd_file.put_line(fnd_file.log, 'l_acct_line_type:' || l_acct_line_type);

5615: l_acct_line_type := 1;
5616: end if;
5617:
5618: if (l_debug = 'Y') then
5619: fnd_file.put_line(fnd_file.log, 'l_acct_line_type:' || l_acct_line_type);
5620: end if;
5621:
5622:
5623: l_stmt_num := 30;

Line 5653: fnd_file.put_line(fnd_file.log, 'in cost element loop');

5649: FOR cost_element IN 1..5 loop
5650: l_cost := NULL;
5651:
5652: if (l_debug = 'Y') then
5653: fnd_file.put_line(fnd_file.log, 'in cost element loop');
5654: end if;
5655:
5656:
5657: l_stmt_num := 40;

Line 5675: fnd_file.put_line(fnd_file.log, 'org-txn-i_p_qty-cost_element-i_subinv');

5671:
5672: if (l_cost is not NULL) then
5673:
5674: if (l_debug = 'Y') then
5675: fnd_file.put_line(fnd_file.log, 'org-txn-i_p_qty-cost_element-i_subinv');
5676: fnd_file.put_line(fnd_file.log, i_org_id || '-' || i_txn_id || '-' ||
5677: i_p_qty || '-' || i_subinv);
5678: end if;
5679: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

Line 5676: fnd_file.put_line(fnd_file.log, i_org_id || '-' || i_txn_id || '-' ||

5672: if (l_cost is not NULL) then
5673:
5674: if (l_debug = 'Y') then
5675: fnd_file.put_line(fnd_file.log, 'org-txn-i_p_qty-cost_element-i_subinv');
5676: fnd_file.put_line(fnd_file.log, i_org_id || '-' || i_txn_id || '-' ||
5677: i_p_qty || '-' || i_subinv);
5678: end if;
5679: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
5680: sign(i_p_qty), l_acct_line_type,

Line 5691: fnd_file.put_line(fnd_file.log, 'Calling Insert Account');

5687: raise process_error;
5688: end if;
5689:
5690: if (l_debug = 'Y') then
5691: fnd_file.put_line(fnd_file.log, 'Calling Insert Account');
5692: end if;
5693:
5694:
5695: if (l_acct = -1) then

Line 5876: fnd_file.put_line (fnd_file.log, 'Inventory_accounts' || to_char(l_stmt_num)

5872:
5873: when process_error then
5874: rollback;
5875: if (l_debug = 'Y') then
5876: fnd_file.put_line (fnd_file.log, 'Inventory_accounts' || to_char(l_stmt_num)
5877: || substr(SQLERRM,1,180));
5878: end if;
5879: O_error_num := l_err_num;
5880: O_error_code := l_err_code;

Line 5901: fnd_file.put_line (fnd_file.log, 'Inventory_accounts' || to_char(l_stmt_num)

5897: when others then
5898:
5899: rollback;
5900: if (l_debug = 'Y') then
5901: fnd_file.put_line (fnd_file.log, 'Inventory_accounts' || to_char(l_stmt_num)
5902: || substr(SQLERRM,1,180)) ;
5903: end if;
5904: O_error_num := SQLCODE;
5905: O_error_message := 'CSTPACDP.inventory_accounts' || to_char(l_stmt_num) ||

Line 5976: fnd_file.put_line(fnd_file.log,'In distribute_accounts');

5972: l_err_msg := '';
5973: l_debug := fnd_profile.value('MRP_DEBUG');
5974:
5975:
5976: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5977: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5978: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5979: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5980: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);

Line 5977: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );

5973: l_debug := fnd_profile.value('MRP_DEBUG');
5974:
5975:
5976: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5977: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5978: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5979: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5980: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5981: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);

Line 5978: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);

5974:
5975:
5976: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5977: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5978: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5979: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5980: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5981: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5982: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);

Line 5979: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);

5975:
5976: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5977: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5978: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5979: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5980: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5981: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5982: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);
5983:

Line 5980: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);

5976: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5977: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5978: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5979: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5980: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5981: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5982: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);
5983:
5984:

Line 5981: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);

5977: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5978: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5979: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5980: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5981: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5982: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);
5983:
5984:
5985: -- For the logical txns introduced in the dropshipment project, standard costing

Line 5982: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);

5978: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5979: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5980: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5981: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5982: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);
5983:
5984:
5985: -- For the logical txns introduced in the dropshipment project, standard costing
5986: -- orgs will also call the average cost distribution processor. A few changes

Line 6051: fnd_file.put_line(fnd_file.log,'actual_cost:' || l_elemental_cost(cost_element) );

6047: OR
6048: (cost_element_id = 2
6049: and level_type = decode(i_ovhd_absp,1,2,2,0,level_type)));
6050:
6051: fnd_file.put_line(fnd_file.log,'actual_cost:' || l_elemental_cost(cost_element) );
6052:
6053: if (l_elemental_cost(cost_element) is not null) then
6054:
6055: -- dropshipment changes

Line 6086: fnd_file.put_line(fnd_file.log, 'ElementID: ' || cost_element || ' Amt: ' || (i_p_qty * l_elemental_cost(cost_element)) ||

6082: into l_acct
6083: from dual;
6084: end if;
6085:
6086: fnd_file.put_line(fnd_file.log, 'ElementID: ' || cost_element || ' Amt: ' || (i_p_qty * l_elemental_cost(cost_element)) ||
6087: ' Acct: ' || l_acct);
6088:
6089: insert_account(i_org_id, i_txn_id, i_item_id, i_p_qty * l_elemental_cost(cost_element),
6090: i_p_qty, l_acct, i_sob_id, i_acct_line_type,

Line 6220: fnd_file.put_line(fnd_file.log,'actual_cost(60):' || l_cost );

6216: and level_type = decode(i_ovhd_absp,1,2,2,0,level_type)));
6217:
6218: END IF; --IF I_ACCT_LINE_TYPE = 14
6219:
6220: fnd_file.put_line(fnd_file.log,'actual_cost(60):' || l_cost );
6221:
6222:
6223: l_stmt_num := 60;
6224:

Line 6249: fnd_file.put_line(fnd_file.log, 'Insert account()');

6245: end if;
6246:
6247: l_stmt_num := 70;
6248:
6249: fnd_file.put_line(fnd_file.log, 'Insert account()');
6250:
6251: insert_account(i_org_id, i_txn_id, i_item_id, i_p_qty * l_cost,
6252: i_p_qty, l_acct, i_sob_id, i_acct_line_type,
6253: NULL, NULL,

Line 6707: fnd_file.put_line(fnd_file.log, 'In insert accounts');

6703: l_conv_rate := i_conv_rate;
6704: l_conv_date := i_conv_date;
6705: l_conv_type := i_conv_type;
6706:
6707: fnd_file.put_line(fnd_file.log, 'In insert accounts');
6708:
6709: if (i_acct = -1) then
6710: raise invalid_acct_error;
6711: end if;

Line 6758: FND_FILE.put_line(FND_FILE.log,'l_ussgl_tc : '||l_ussgl_tc);

6754: END IF;
6755: END IF;
6756: END IF; /* IF(l_enc_rev = 1) */
6757:
6758: FND_FILE.put_line(FND_FILE.log,'l_ussgl_tc : '||l_ussgl_tc);
6759:
6760:
6761: /* The following select statement will be made to refer to cst_organization_definitions as an impact of the HR-PROFILE option */
6762: l_stmt_num := 5;

Line 6912: FND_FILE.put_line(FND_FILE.log,'DS - others Exception, sqlcode = '||SQLCODE);

6908: rollback;
6909: O_error_num := SQLCODE;
6910: O_error_message := 'CSTPACDP.insert_account (' || to_char(l_stmt_num)
6911: || ') ' || substr(SQLERRM,1,180);
6912: FND_FILE.put_line(FND_FILE.log,'DS - others Exception, sqlcode = '||SQLCODE);
6913:
6914: end insert_account;
6915:
6916: procedure balance_account(

Line 6934: fnd_file.put_line(fnd_file.log,'In balance account!!!!');

6930:
6931: l_stmt_num := 10;
6932: l_debug := fnd_profile.value('MRP_DEBUG');
6933: IF (l_debug = 'Y') THEN
6934: fnd_file.put_line(fnd_file.log,'In balance account!!!!');
6935: END IF;
6936:
6937: select nvl(sum(base_transaction_value),0), nvl(sum(transaction_value),0)
6938: into l_base_value, l_value

Line 6948: fnd_file.put_line(fnd_file.log, 'Adjustment Amount(l_base_value): '||l_base_value);

6944: if (l_base_value = 0 and l_value = 0) then
6945: return;
6946: end if;
6947: IF (l_debug = 'Y') THEN
6948: fnd_file.put_line(fnd_file.log, 'Adjustment Amount(l_base_value): '||l_base_value);
6949: fnd_file.put_line(fnd_file.log, 'Adjustment Amount(l_value): '||l_value);
6950: END IF;
6951: l_stmt_num := 20;
6952:

Line 6949: fnd_file.put_line(fnd_file.log, 'Adjustment Amount(l_value): '||l_value);

6945: return;
6946: end if;
6947: IF (l_debug = 'Y') THEN
6948: fnd_file.put_line(fnd_file.log, 'Adjustment Amount(l_base_value): '||l_base_value);
6949: fnd_file.put_line(fnd_file.log, 'Adjustment Amount(l_value): '||l_value);
6950: END IF;
6951: l_stmt_num := 20;
6952:
6953: -- Bug# 4052277 (propagation of 4015478).

Line 6978: fnd_file.put_line(fnd_file.log,'Adjusting Balance value against record ' || l_rowid);

6974:
6975: IF (l_rowid IS NOT NULL ) THEN
6976: l_stmt_num := 30;
6977: IF (l_debug = 'Y') THEN
6978: fnd_file.put_line(fnd_file.log,'Adjusting Balance value against record ' || l_rowid);
6979: END IF;
6980:
6981: update mtl_transaction_accounts
6982: set transaction_value = decode(transaction_value, NULL,

Line 6992: fnd_file.put_line(fnd_file.log,'Could not find one single row which can absorb both l_value and l_base_value ');

6988: ELSE /*l_rowid is null */
6989: /*Bug8243112: If not found then find a row which can absorb l_value*/
6990: l_stmt_num := 40;
6991: IF (l_debug = 'Y') THEN
6992: fnd_file.put_line(fnd_file.log,'Could not find one single row which can absorb both l_value and l_base_value ');
6993: fnd_file.put_line(fnd_file.log,'Finding row which can absorb l_value ');
6994: END IF;
6995:
6996: SELECT MAX(rowid)

Line 6993: fnd_file.put_line(fnd_file.log,'Finding row which can absorb l_value ');

6989: /*Bug8243112: If not found then find a row which can absorb l_value*/
6990: l_stmt_num := 40;
6991: IF (l_debug = 'Y') THEN
6992: fnd_file.put_line(fnd_file.log,'Could not find one single row which can absorb both l_value and l_base_value ');
6993: fnd_file.put_line(fnd_file.log,'Finding row which can absorb l_value ');
6994: END IF;
6995:
6996: SELECT MAX(rowid)
6997: INTO l_rowid

Line 7008: fnd_file.put_line(fnd_file.log,'Adjusting the transaction value balance value against record ' || l_rowid);

7004: decode(l_value, 0, NULL,-1*l_value),
7005: transaction_value - l_value),0)) >= 0;
7006: l_stmt_num := 50;
7007: IF (l_debug = 'Y') THEN
7008: fnd_file.put_line(fnd_file.log,'Adjusting the transaction value balance value against record ' || l_rowid);
7009: END IF;
7010:
7011: update mtl_transaction_accounts
7012: set transaction_value = decode(transaction_value, NULL,

Line 7019: fnd_file.put_line(fnd_file.log,'Finding row which can absorb l_base_value ');

7015: where rowid = l_rowid;
7016: /*Bug8243112: Then find a row which can absorb l_base_value*/
7017: l_stmt_num := 60;
7018: IF (l_debug = 'Y') THEN
7019: fnd_file.put_line(fnd_file.log,'Finding row which can absorb l_base_value ');
7020: END IF;
7021:
7022: SELECT MAX(rowid)
7023: INTO l_rowid

Line 7033: fnd_file.put_line(fnd_file.log,'Adjusting the base transaction value balance value against record ' || l_rowid);

7029: sign(nvl(transaction_value,0)) >= 0;
7030:
7031: l_stmt_num := 70;
7032: IF (l_debug = 'Y') THEN
7033: fnd_file.put_line(fnd_file.log,'Adjusting the base transaction value balance value against record ' || l_rowid);
7034: END IF;
7035:
7036: update mtl_transaction_accounts
7037: set base_transaction_value = base_transaction_value - l_base_value

Line 7297: fnd_file.put_line(fnd_file.log, 'cost_process_discrete_trx <<<');

7293: l_conv_date DATE;
7294: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 End */
7295:
7296: begin
7297: fnd_file.put_line(fnd_file.log, 'cost_process_discrete_trx <<<');
7298: l_debug := fnd_profile.value('MRP_DEBUG');
7299:
7300: /* Check if the organization_id and/or transfer_organization_id
7301: are average or FIFO/LIFO orgs. If so, error out this transaction, since it is just meant

Line 7355: fnd_file.put_line(fnd_file.log, 'src/act: ' || src_type_id ||'/'|| txn_act_id);

7351:
7352:
7353: -- code to stop profile is at the end of this procedure.
7354: --
7355: fnd_file.put_line(fnd_file.log, 'src/act: ' || src_type_id ||'/'|| txn_act_id);
7356:
7357: fnd_file.put_line(fnd_file.log, 'txnId/Org: ' || trans_id || '/' || org_id ||
7358: ', xferOrg: ' || txf_org_id || ' XferPrice: ' || interorg_xfr_price ||
7359: ', p_qty: ' || p_qty);

Line 7357: fnd_file.put_line(fnd_file.log, 'txnId/Org: ' || trans_id || '/' || org_id ||

7353: -- code to stop profile is at the end of this procedure.
7354: --
7355: fnd_file.put_line(fnd_file.log, 'src/act: ' || src_type_id ||'/'|| txn_act_id);
7356:
7357: fnd_file.put_line(fnd_file.log, 'txnId/Org: ' || trans_id || '/' || org_id ||
7358: ', xferOrg: ' || txf_org_id || ' XferPrice: ' || interorg_xfr_price ||
7359: ', p_qty: ' || p_qty);
7360: fnd_file.put_line(fnd_file.log, 'cg_id: ' || cg_id);
7361:

Line 7360: fnd_file.put_line(fnd_file.log, 'cg_id: ' || cg_id);

7356:
7357: fnd_file.put_line(fnd_file.log, 'txnId/Org: ' || trans_id || '/' || org_id ||
7358: ', xferOrg: ' || txf_org_id || ' XferPrice: ' || interorg_xfr_price ||
7359: ', p_qty: ' || p_qty);
7360: fnd_file.put_line(fnd_file.log, 'cg_id: ' || cg_id);
7361:
7362: --
7363: -- Bug 5233635; Should not book InterOrg Profit when Intercompany Invoicing is enabled.
7364: --

Line 7381: fnd_file.put_line(fnd_file.LOG, 'OU/xferOU: ' || l_org_ou ||'/'||l_txf_org_ou||

7377: WHERE org_information_context = 'Accounting Information'
7378: AND organization_id = txf_org_id;
7379:
7380: l_io_invoicing := to_number(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'));
7381: fnd_file.put_line(fnd_file.LOG, 'OU/xferOU: ' || l_org_ou ||'/'||l_txf_org_ou||
7382: ' Internal Order invoicing: ' || l_io_invoicing);
7383:
7384: --
7385: -- End Bug 5233635

Line 7412: fnd_file.put_line(fnd_file.log, 'wms_flg: ' || wms_flg || ' pjm_flg: ' || pjm_flg);

7408: INTO pjm_flg
7409: FROM MTL_PARAMETERS
7410: WHERE organization_id = org_id;
7411:
7412: fnd_file.put_line(fnd_file.log, 'wms_flg: ' || wms_flg || ' pjm_flg: ' || pjm_flg);
7413:
7414: l_stmt_num := 60;
7415:
7416: /* Not sure what to do here!

Line 7547: fnd_file.put_line(fnd_file.log, 'iexp_flag/exp_flg/exp_sub: ' || iexp_flg ||'/'|| exp_flg || '/'|| exp_sub);

7543: WHERE secondary_inventory_name = subinv
7544: AND organization_id = org_id;
7545: end if;
7546:
7547: fnd_file.put_line(fnd_file.log, 'iexp_flag/exp_flg/exp_sub: ' || iexp_flg ||'/'|| exp_flg || '/'|| exp_sub);
7548:
7549:
7550: /*----------------------------------------------------------------------+
7551: | Get elemental accounts

Line 7633: fnd_file.put_line(fnd_file.log, 'inserting into mcacd');

7629:
7630: /*----------------------------------------------------------------------+
7631: |Insert standard cost into mtl_cst_actual_cost_details
7632: +----------------------------------------------------------------------*/
7633: fnd_file.put_line(fnd_file.log, 'inserting into mcacd');
7634:
7635: l_stmt_num := 280;
7636: CSTPSISC.ins_std_cost(org_id, item_id, trans_id,
7637: txn_act_id, src_type_id,

Line 7699: fnd_file.put_line(fnd_file.log,'snd_rcv: ' || snd_rcv);

7695: from_cost_grp := txf_cg_id;
7696: to_cost_grp := cg_id;
7697: end if;
7698:
7699: fnd_file.put_line(fnd_file.log,'snd_rcv: ' || snd_rcv);
7700: fnd_file.put_line(fnd_file.log,'from_org: ' || from_org);
7701: fnd_file.put_line(fnd_file.log,'to_org: ' || to_org);
7702:
7703: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 Start */

Line 7700: fnd_file.put_line(fnd_file.log,'from_org: ' || from_org);

7696: to_cost_grp := cg_id;
7697: end if;
7698:
7699: fnd_file.put_line(fnd_file.log,'snd_rcv: ' || snd_rcv);
7700: fnd_file.put_line(fnd_file.log,'from_org: ' || from_org);
7701: fnd_file.put_line(fnd_file.log,'to_org: ' || to_org);
7702:
7703: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 Start */
7704: CSTPAVCP.get_snd_rcv_rate(trans_id, from_org, to_org,

Line 7701: fnd_file.put_line(fnd_file.log,'to_org: ' || to_org);

7697: end if;
7698:
7699: fnd_file.put_line(fnd_file.log,'snd_rcv: ' || snd_rcv);
7700: fnd_file.put_line(fnd_file.log,'from_org: ' || from_org);
7701: fnd_file.put_line(fnd_file.log,'to_org: ' || to_org);
7702:
7703: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 Start */
7704: CSTPAVCP.get_snd_rcv_rate(trans_id, from_org, to_org,
7705: l_snd_sob_id, l_snd_curr, l_rcv_sob_id, l_rcv_curr,

Line 7712: fnd_file.put(fnd_file.log, 'fromOrg/SOB/Curr: ' || from_org ||'/'|| l_snd_sob_id ||'/'|| l_snd_curr);

7708:
7709: if (O_Error_Num <> 0) then
7710: raise errexit;
7711: end if;
7712: fnd_file.put(fnd_file.log, 'fromOrg/SOB/Curr: ' || from_org ||'/'|| l_snd_sob_id ||'/'|| l_snd_curr);
7713: fnd_file.put(fnd_file.log, 'toOrg/SOB/Curr: ' || to_org ||'/'|| l_rcv_sob_id ||'/'|| l_rcv_curr);
7714: fnd_file.put(fnd_file.log, 'currType/Rate/Date: ' || l_curr_type ||'/'|| l_conv_rate ||'/'|| l_conv_date);
7715:
7716: /* umoogala Bug#5708387 13-dec-2006

Line 7713: fnd_file.put(fnd_file.log, 'toOrg/SOB/Curr: ' || to_org ||'/'|| l_rcv_sob_id ||'/'|| l_rcv_curr);

7709: if (O_Error_Num <> 0) then
7710: raise errexit;
7711: end if;
7712: fnd_file.put(fnd_file.log, 'fromOrg/SOB/Curr: ' || from_org ||'/'|| l_snd_sob_id ||'/'|| l_snd_curr);
7713: fnd_file.put(fnd_file.log, 'toOrg/SOB/Curr: ' || to_org ||'/'|| l_rcv_sob_id ||'/'|| l_rcv_curr);
7714: fnd_file.put(fnd_file.log, 'currType/Rate/Date: ' || l_curr_type ||'/'|| l_conv_rate ||'/'|| l_conv_date);
7715:
7716: /* umoogala Bug#5708387 13-dec-2006
7717: * l_conv_date is not returned from above call. Using txn date

Line 7714: fnd_file.put(fnd_file.log, 'currType/Rate/Date: ' || l_curr_type ||'/'|| l_conv_rate ||'/'|| l_conv_date);

7710: raise errexit;
7711: end if;
7712: fnd_file.put(fnd_file.log, 'fromOrg/SOB/Curr: ' || from_org ||'/'|| l_snd_sob_id ||'/'|| l_snd_curr);
7713: fnd_file.put(fnd_file.log, 'toOrg/SOB/Curr: ' || to_org ||'/'|| l_rcv_sob_id ||'/'|| l_rcv_curr);
7714: fnd_file.put(fnd_file.log, 'currType/Rate/Date: ' || l_curr_type ||'/'|| l_conv_rate ||'/'|| l_conv_date);
7715:
7716: /* umoogala Bug#5708387 13-dec-2006
7717: * l_conv_date is not returned from above call. Using txn date
7718: */

Line 7721: fnd_file.put(fnd_file.log, 'currDate: ' || l_conv_date );

7717: * l_conv_date is not returned from above call. Using txn date
7718: */
7719: l_conv_date := nvl(l_conv_date, txn_date);
7720:
7721: fnd_file.put(fnd_file.log, 'currDate: ' || l_conv_date );
7722: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 End */
7723:
7724: /*----------------------------------------------------------------------+
7725: | Get sending and reciving uom

Line 7780: fnd_file.put_line(fnd_file.log, 'FOB = ' || fob_pt);

7776: AND mip.to_organization_id = to_org
7777: AND mp.organization_id = org_id
7778: AND mmt.transaction_id = trans_id;
7779:
7780: fnd_file.put_line(fnd_file.log, 'FOB = ' || fob_pt);
7781:
7782:
7783: /*----------------------------------------------------------------------+
7784: | Get act_cost and item_cost. It is used only in AX code

Line 7792: fnd_file.put_line(fnd_file.log, 'act_cost: ' || act_cost || ' item_cost: ' || item_cost);

7788: FROM cst_item_costs_for_gl_view
7789: WHERE inventory_item_id = item_id
7790: AND organization_id = org_id;
7791:
7792: fnd_file.put_line(fnd_file.log, 'act_cost: ' || act_cost || ' item_cost: ' || item_cost);
7793:
7794:
7795: /*----------------------------------------------------------------------+
7796: * Get PPV Account only for receiving transactions

Line 7885: fnd_file.put_line(fnd_file.log, 'Verifying whether to earn MOH or not...');

7881: -- Bug 5021305: Added following to see overhead rules are setup or not.
7882: -- Bug 5349860: umoogala - exclude issue/receipt (to exp destination) txn.
7883: --
7884:
7885: fnd_file.put_line(fnd_file.log, 'Verifying whether to earn MOH or not...');
7886:
7887: IF (txn_act_id <> 1) AND (txn_act_id <> 17) AND
7888: (NOT exp_flg = 1) AND (NOT exp_sub = 1)
7889: THEN

Line 7915: fnd_file.put_line(fnd_file.log, 'l_earn_moh: ' || l_earn_moh);

7911: x_return_status => l_return_status);
7912: RAISE moh_rules_error;
7913: END IF;
7914:
7915: fnd_file.put_line(fnd_file.log, 'l_earn_moh: ' || l_earn_moh);
7916:
7917: END IF;
7918:
7919: <>

Line 7943: fnd_file.put_line(fnd_file.log, 'Processing shipment txn. FOB = ' || fob_pt);

7939: then
7940: --{
7941:
7942: /* Direct interorg between discrete orgs or fob ship */
7943: fnd_file.put_line(fnd_file.log, 'Processing shipment txn. FOB = ' || fob_pt);
7944:
7945: /*----------------------------------------------------------------------+
7946: |Sending Organization : Do accounting for asset subinventory only
7947: +----------------------------------------------------------------------*/

Line 7959: fnd_file.put_line(fnd_file.log, 'Cr Inv Val @ sending org cost');

7955:
7956: /*----------------------------------------------------------------------+
7957: | Cr Inv. Val @ sending org cost
7958: +----------------------------------------------------------------------*/
7959: fnd_file.put_line(fnd_file.log, 'Cr Inv Val @ sending org cost');
7960:
7961: CSTPACDP.distribute_accounts(
7962: org_id, trans_id,
7963: 0, cg_id , txn_act_id,

Line 7991: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');

7987:
7988: /*----------------------------------------------------------------------+
7989: | Dr Exp Acct
7990: +----------------------------------------------------------------------*/
7991: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
7992: l_stmt_num := 750;
7993:
7994: --
7995: -- Bug 5331207:

Line 8038: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);

8034:
8035: /*----------------------------------------------------------------------+
8036: | Cr Freight Acct
8037: +----------------------------------------------------------------------*/
8038: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
8039: CSTPACDP.insert_account
8040: (org_id, trans_id, item_id, -1 * trp_cost,
8041: p_qty, trp_acct, sob_id, 12, NULL, NULL,
8042: txn_date, txn_src_id, src_type_id,

Line 8072: fnd_file.put_line(fnd_file.log, 'Dr Receivables with ' || (txf_price * p_qty) || ' ' || pri_curr);

8068: io_rec_acct := user_acct_id;
8069: end if;
8070:
8071:
8072: fnd_file.put_line(fnd_file.log, 'Dr Receivables with ' || (txf_price * p_qty) || ' ' || pri_curr);
8073: CSTPACDP.insert_account
8074: (org_id, trans_id, item_id, -1 * txf_price * p_qty,
8075: -1 * p_qty, io_rec_acct, sob_id, 10, NULL, NULL,
8076: txn_date, txn_src_id, src_type_id,

Line 8102: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||

8098: and (txn_act_id = 21) -- Bug 5351724
8099: and (iexp_flg = 0) -- Bug 5348953: No IC Invoicing for expense items
8100: then
8101: NULL;
8102: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||
8103: 'is enabled.');
8104: else
8105: /*
8106: * Replaced with following SQL

Line 8122: fnd_file.put_line(fnd_file.log, 'InterOrg Profit = ' || nvl(interorg_profit, 0) || ' ' || pri_curr);

8118: WHERE transaction_id = trans_id
8119: AND organization_id = org_id
8120: ;
8121:
8122: fnd_file.put_line(fnd_file.log, 'InterOrg Profit = ' || nvl(interorg_profit, 0) || ' ' || pri_curr);
8123:
8124: if (interorg_profit <> 0)
8125: then
8126:

Line 8141: fnd_file.put_line(fnd_file.log, 'Cr InterOrg Profit with ' || nvl(interorg_profit,0) || ' ' || pri_curr);

8137: then
8138: interorg_profit_acct := user_acct_id;
8139: end if;
8140:
8141: fnd_file.put_line(fnd_file.log, 'Cr InterOrg Profit with ' || nvl(interorg_profit,0) || ' ' || pri_curr);
8142: CSTPACDP.insert_account
8143: (org_id, trans_id, item_id, -1 * interorg_profit,
8144: p_qty, interorg_profit_acct, sob_id,
8145: G_INTERORG_PROFIT_ACCT, NULL, NULL,

Line 8171: fnd_file.put_line(fnd_file.log, 'Processing intransit shipment. FOB = ' || fob_pt);

8167: elsif (txn_act_id = 21 AND fob_pt = 2)
8168: then
8169: --{
8170:
8171: fnd_file.put_line(fnd_file.log, 'Processing intransit shipment. FOB = ' || fob_pt);
8172:
8173: --
8174: -- Bug 5332792: No accounting for shipment txn with FOB Receipt for expense item
8175: -- Added 2nd condition (NOT iexp_flg = 1) to the IF stmt below.

Line 8197: fnd_file.put_line(fnd_file.log, 'Cr Inv Val @ sending org cost');

8193:
8194: /*----------------------------------------------------------------------+
8195: | Cr Inv. Val @ sending org cost
8196: +----------------------------------------------------------------------*/
8197: fnd_file.put_line(fnd_file.log, 'Cr Inv Val @ sending org cost');
8198: CSTPACDP.distribute_accounts(
8199: org_id, trans_id,
8200: 0, cg_id , txn_act_id,
8201: item_id, p_qty, 1,

Line 8219: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');

8215:
8216: /*----------------------------------------------------------------------+
8217: | Dr Intransit Acct @ org cost
8218: +----------------------------------------------------------------------*/
8219: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
8220: CSTPACDP.distribute_accounts(
8221: org_id, trans_id, 0, cg_id , txn_act_id,
8222: item_id, -1 * p_qty, 14, 0, 0,
8223: io_inv_acct, NULL, NULL, NULL, NULL,NULL,

Line 8253: fnd_file.put_line(fnd_file.log, 'Cr Inv Val');

8249: then
8250: mat_acct := user_acct_id;
8251: end if;
8252:
8253: fnd_file.put_line(fnd_file.log, 'Cr Inv Val');
8254: CSTPACDP.insert_account
8255: (org_id, trans_id, item_id, 0,
8256: p_qty, mat_acct, sob_id, 1, NULL, NULL,
8257: txn_date, txn_src_id, src_type_id,

Line 8283: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct');

8279: then
8280: io_inv_acct := user_acct_id;
8281: end if;
8282:
8283: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct');
8284: CSTPACDP.insert_account
8285: (org_id, trans_id, item_id, 0,
8286: -1 * p_qty, io_inv_acct, sob_id, 14, NULL, NULL,
8287: txn_date, txn_src_id, src_type_id,

Line 8313: fnd_file.put_line(fnd_file.log, 'Cr Exp Acct');

8309:
8310: /*----------------------------------------------------------------------+
8311: | Cr Exp Acct
8312: +----------------------------------------------------------------------*/
8313: fnd_file.put_line(fnd_file.log, 'Cr Exp Acct');
8314: CSTPACDP.distribute_accounts(
8315: org_id, trans_id, 0, cg_id , txn_act_id,
8316: item_id, p_qty, 2, 0, 0,
8317: exp_acct, NULL, NULL, NULL, NULL, NULL,

Line 8331: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');

8327:
8328: /*----------------------------------------------------------------------+
8329: | Dr Intransit Acct @ org cost
8330: +----------------------------------------------------------------------*/
8331: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
8332: CSTPACDP.distribute_accounts(
8333: org_id, trans_id,
8334: 0, cg_id , txn_act_id,
8335: item_id, -1 * p_qty, 14,

Line 8388: fnd_file.put_line(fnd_file.log, 'processing direct interorg receiving txn.');

8384: * Dr. Exp Acct @ Transfer Price
8385: * Cr InterOrg Payables with Transfer Price
8386: */
8387:
8388: fnd_file.put_line(fnd_file.log, 'processing direct interorg receiving txn.');
8389:
8390:
8391: /*----------------------------------------------------------------------+
8392: | Cr receiving org payable @ transfer price

Line 8413: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);

8409: then
8410: io_pay_acct := user_acct_id;
8411: end if;
8412:
8413: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
8414: CSTPACDP.insert_account
8415: (org_id, trans_id, item_id, -1 * payamt,
8416: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
8417: txn_date, txn_src_id, src_type_id,

Line 8453: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');

8449:
8450: /*----------------------------------------------------------------------+
8451: | Dr Exp Acct
8452: +----------------------------------------------------------------------*/
8453: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8454: CSTPACDP.insert_account
8455: (org_id, trans_id, item_id, interorg_xfr_price * p_qty,
8456: p_qty, exp_acct, sob_id, 2, NULL, NULL,
8457: txn_date, txn_src_id, src_type_id,

Line 8478: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');

8474:
8475: /*----------------------------------------------------------------------+
8476: | Dr Inv. Val @ org cost
8477: +----------------------------------------------------------------------*/
8478: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8479: CSTPACDP.distribute_accounts(
8480: org_id, trans_id,
8481: 0, cg_id , txn_act_id,
8482: item_id, p_qty, 1,

Line 8506: fnd_file.put_line(fnd_file.log, 'Booking Overhead Acct');

8502:
8503: /*----------------------------------------------------------------------+
8504: | Booking Overhead Acct
8505: +----------------------------------------------------------------------*/
8506: fnd_file.put_line(fnd_file.log, 'Booking Overhead Acct');
8507: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
8508: -1 * p_qty, sob_id,
8509: txn_date, txn_src_id, src_type_id, subinv,
8510: snd_rcv, pri_curr,

Line 8553: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);

8549: then
8550: io_ppv_acct := user_acct_id;
8551: end if;
8552:
8553: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
8554: CSTPACDP.insert_account
8555: (org_id, trans_id, item_id, ppv_amt,
8556: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
8557: txn_date, txn_src_id, src_type_id,

Line 8621: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');

8617: then
8618: exp_acct := user_acct_id;
8619: end if;
8620:
8621: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8622: CSTPACDP.distribute_accounts(
8623: org_id, trans_id,
8624: 0, cg_id , txn_act_id,
8625: item_id, p_qty, 2,

Line 8649: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');

8645:
8646: /*----------------------------------------------------------------------+
8647: | Dr Inv. Val @ org cost
8648: +----------------------------------------------------------------------*/
8649: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8650: CSTPACDP.distribute_accounts(
8651: org_id, trans_id,
8652: 0, cg_id , txn_act_id,
8653: item_id, p_qty, 1,

Line 8690: fnd_file.put_line(fnd_file.log, 'Cr Intransit Acct @ org cost');

8686:
8687: /*----------------------------------------------------------------------+
8688: | Cr Intransit Acct @ org cost
8689: +----------------------------------------------------------------------*/
8690: fnd_file.put_line(fnd_file.log, 'Cr Intransit Acct @ org cost');
8691: CSTPACDP.distribute_accounts(
8692: org_id, trans_id,
8693: 0, cg_id , txn_act_id,
8694: item_id, -1 * p_qty, 14,

Line 8737: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);

8733: then
8734: io_pay_acct := user_acct_id;
8735: end if;
8736:
8737: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
8738: CSTPACDP.insert_account
8739: (org_id, trans_id, item_id, payamt,
8740: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
8741: txn_date, txn_src_id, src_type_id,

Line 8764: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');

8760: l_stmt_num := 931;
8761: /*----------------------------------------------------------------------+
8762: | Dr Inv. Val @ org cost
8763: +----------------------------------------------------------------------*/
8764: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8765: CSTPACDP.distribute_accounts(
8766: org_id, trans_id,
8767: 0, cg_id , txn_act_id,
8768: item_id, p_qty, 1,

Line 8789: fnd_file.put_line(fnd_file.log, 'Booking Overhead Acct');

8785: +----------------------------------------------------------------------*/
8786: IF (txn_act_id <> 17) AND -- Bug 5349860
8787: (exp_flg = 0) AND (exp_sub = 0) AND (l_earn_moh <> 0)
8788: THEN
8789: fnd_file.put_line(fnd_file.log, 'Booking Overhead Acct');
8790: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
8791: -1 * p_qty, sob_id,
8792: txn_date, txn_src_id, src_type_id, subinv,
8793: snd_rcv, pri_curr,

Line 8835: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);

8831: then
8832: io_ppv_acct := user_acct_id;
8833: end if;
8834:
8835: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
8836: CSTPACDP.insert_account
8837: (org_id, trans_id, item_id, ppv_amt,
8838: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
8839: txn_date, txn_src_id, src_type_id,

Line 8872: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');

8868: then
8869: exp_acct := user_acct_id;
8870: end if;
8871:
8872: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8873: CSTPACDP.insert_account
8874: (org_id, trans_id, item_id, -1 * payamt,
8875: p_qty, exp_acct, sob_id, 2, NULL, NULL,
8876: txn_date, txn_src_id, src_type_id,

Line 8964: fnd_file.put_line(fnd_file.log, 'Cr Intransit Acct @ org cost');

8960: then
8961: io_inv_acct := user_acct_id;
8962: end if;
8963:
8964: fnd_file.put_line(fnd_file.log, 'Cr Intransit Acct @ org cost');
8965: CSTPACDP.distribute_accounts(
8966: org_id, trans_id,
8967: 0, cg_id , txn_act_id,
8968: item_id, -1 * p_qty, 14,

Line 9000: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);

8996: then
8997: trp_acct := user_acct_id;
8998: end if;
8999:
9000: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
9001: CSTPACDP.insert_account
9002: (org_id, trans_id, item_id, -1 * trp_cost,
9003: p_qty, trp_acct, sob_id, 12, NULL, NULL,
9004: txn_date, txn_src_id, src_type_id,

Line 9034: fnd_file.put_line(fnd_file.log, 'Dr Receivalbes with ' || (interorg_xfr_price * p_qty) || ' ' || pri_curr);

9030: io_rec_acct := user_acct_id;
9031: end if;
9032:
9033:
9034: fnd_file.put_line(fnd_file.log, 'Dr Receivalbes with ' || (interorg_xfr_price * p_qty) || ' ' || pri_curr);
9035: CSTPACDP.insert_account
9036: (org_id, trans_id, item_id, interorg_xfr_price * p_qty,
9037: p_qty, io_rec_acct, sob_id, 10, NULL, NULL,
9038: txn_date, txn_src_id, src_type_id,

Line 9061: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||

9057: and (txn_act_id = 21) -- Bug 5351724
9058: and (iexp_flg = 0) -- Bug 5348953: No IC Invoicing for expense items
9059: then
9060: NULL;
9061: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||
9062: 'is enabled.');
9063: else
9064:
9065: -- interorg_profit := interorg_xfr_price - (item_cost + (trp_cost/p_qty));

Line 9090: fnd_file.put_line(fnd_file.log, 'Dr InterOrg Profit with ' || nvl(interorg_profit,0) || ' ' || pri_curr);

9086: then
9087: interorg_profit_acct := user_acct_id;
9088: end if;
9089:
9090: fnd_file.put_line(fnd_file.log, 'Dr InterOrg Profit with ' || nvl(interorg_profit,0) || ' ' || pri_curr);
9091: CSTPACDP.insert_account
9092: (org_id, trans_id, item_id, -1 * interorg_profit, /* ANTHIYAG Bug#5459157 11-Aug-2006 */
9093: p_qty, interorg_profit_acct, sob_id,
9094: G_INTERORG_PROFIT_ACCT, NULL, NULL,

Line 9158: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);

9154: then
9155: io_pay_acct := user_acct_id;
9156: end if;
9157:
9158: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
9159: CSTPACDP.insert_account
9160: (org_id, trans_id, item_id, payamt,
9161: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
9162: txn_date, txn_src_id, src_type_id,

Line 9192: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);

9188: then
9189: trp_acct := user_acct_id;
9190: end if;
9191:
9192: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
9193: CSTPACDP.insert_account
9194: (org_id, trans_id, item_id, -1 * trp_cost,
9195: p_qty, trp_acct, sob_id, 12, NULL, NULL,
9196: txn_date, txn_src_id, src_type_id,

Line 9228: fnd_file.put_line(fnd_file.log, 'Cr variance account with ' || var_amt || ' ' || pri_curr);

9224: then
9225: acv_acct := user_acct_id;
9226: end if;
9227:
9228: fnd_file.put_line(fnd_file.log, 'Cr variance account with ' || var_amt || ' ' || pri_curr);
9229: CSTPACDP.insert_account
9230: (org_id, trans_id, item_id, var_amt,
9231: p_qty, acv_acct, sob_id, 13, NULL, NULL,
9232: txn_date, txn_src_id, src_type_id,

Line 9269: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');

9265: then
9266: exp_acct := user_acct_id;
9267: end if;
9268:
9269: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
9270: CSTPACDP.insert_account
9271: (org_id, trans_id, item_id, trp_cost,
9272: p_qty, exp_acct, sob_id, 2, NULL, NULL,
9273: txn_date, txn_src_id, src_type_id,

Line 9305: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');

9301: then
9302: io_inv_acct := user_acct_id;
9303: end if;
9304:
9305: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
9306: CSTPACDP.distribute_accounts(
9307: org_id, trans_id,
9308: 0, cg_id , txn_act_id,
9309: item_id, p_qty, 14,

Line 9328: fnd_file.put_line(fnd_file.log, '-- Booking Overhead Acct: exp_flg/exp_sub: ' || exp_flg ||'/'||exp_sub ||

9324:
9325: /* receiving overhead absorption */
9326: /* Earn MOH only for asset subinventory */
9327:
9328: fnd_file.put_line(fnd_file.log, '-- Booking Overhead Acct: exp_flg/exp_sub: ' || exp_flg ||'/'||exp_sub ||
9329: ' bookMOH Obsorption?: ' || l_earn_moh);
9330:
9331: if (exp_flg = 0) AND (exp_sub = 0) AND (l_earn_moh <> 0)
9332: then

Line 9337: fnd_file.put_line(fnd_file.log, '-- Booking Overhead Acct');

9333:
9334: /*----------------------------------------------------------------------+
9335: | Booking Overhead Acct
9336: +----------------------------------------------------------------------*/
9337: fnd_file.put_line(fnd_file.log, '-- Booking Overhead Acct');
9338: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
9339: -1 * p_qty, sob_id,
9340: txn_date, txn_src_id, src_type_id, subinv,
9341: snd_rcv, pri_curr,

Line 9384: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);

9380: then
9381: io_ppv_acct := user_acct_id;
9382: end if;
9383:
9384: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
9385: CSTPACDP.insert_account
9386: (org_id, trans_id, item_id, ppv_amt,
9387: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
9388: txn_date, txn_src_id, src_type_id,

Line 9427: fnd_file.put_line(fnd_file.log, 'Cr Enc Acct with ' || enc_amt || ' ' || pri_curr);

9423: then
9424: enc_acct := user_acct_id;
9425: end if;
9426:
9427: fnd_file.put_line(fnd_file.log, 'Cr Enc Acct with ' || enc_amt || ' ' || pri_curr);
9428: CSTPACDP.insert_account
9429: (org_id, trans_id, item_id, -1*enc_amt,
9430: p_qty, enc_acct, sob_id, 15, NULL, NULL,
9431: txn_date, txn_src_id, src_type_id,

Line 9458: fnd_file.put_line(FND_FILE.LOG, 'Start calling CST_TPRICE_PVT.Adjust_Acct');

9454: (txn_act_id = 22 AND src_type_id = 8))
9455: AND tprice_option <> 0 )
9456: then
9457: -- {
9458: fnd_file.put_line(FND_FILE.LOG, 'Start calling CST_TPRICE_PVT.Adjust_Acct');
9459:
9460: CST_TPRICE_PVT.Adjust_Acct(1.0, p_tprice_option => tprice_option,
9461: p_txf_price => txf_price, p_txn_id => trans_id,
9462: p_cost_grp_id => cg_id, p_txf_cost_grp => txf_cg_id,

Line 9485: fnd_file.put_line(fnd_file.log, 'Balancing Accounts');

9481: added code to call balance account to adjust any rounding errors */
9482:
9483: l_stmt_num := 942;
9484:
9485: fnd_file.put_line(fnd_file.log, 'Balancing Accounts');
9486: CSTPACDP.balance_account(org_id, trans_id, O_Error_Num, O_Error_Code, O_Error_Message);
9487:
9488: if O_Error_Num <> 0
9489: then

Line 9508: -- fnd_file.put_line(fnd_file.log, '[AX]FINAL');

9504:
9505: /* Change for AX team
9506: Begin
9507: */
9508: -- fnd_file.put_line(fnd_file.log, '[AX]FINAL');
9509: -- fnd_file.put_line(fnd_file.log, '===================================================');
9510:
9511: uom_conv_rate := 1;
9512:

Line 9509: -- fnd_file.put_line(fnd_file.log, '===================================================');

9505: /* Change for AX team
9506: Begin
9507: */
9508: -- fnd_file.put_line(fnd_file.log, '[AX]FINAL');
9509: -- fnd_file.put_line(fnd_file.log, '===================================================');
9510:
9511: uom_conv_rate := 1;
9512:
9513: l_stmt_num := 951;

Line 9519: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);

9515: act_cost := item_cost;
9516:
9517: end if;
9518:
9519: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9520: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9521: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9522: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9523: -- fnd_file.put_line(fnd_file.log, '===================================================');

Line 9520: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);

9516:
9517: end if;
9518:
9519: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9520: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9521: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9522: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9523: -- fnd_file.put_line(fnd_file.log, '===================================================');
9524:

Line 9521: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);

9517: end if;
9518:
9519: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9520: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9521: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9522: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9523: -- fnd_file.put_line(fnd_file.log, '===================================================');
9524:
9525: if (txn_act_id = 3 OR txn_act_id = 21 )

Line 9522: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);

9518:
9519: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9520: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9521: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9522: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9523: -- fnd_file.put_line(fnd_file.log, '===================================================');
9524:
9525: if (txn_act_id = 3 OR txn_act_id = 21 )
9526: then

Line 9523: -- fnd_file.put_line(fnd_file.log, '===================================================');

9519: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9520: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9521: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9522: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9523: -- fnd_file.put_line(fnd_file.log, '===================================================');
9524:
9525: if (txn_act_id = 3 OR txn_act_id = 21 )
9526: then
9527: -- {

Line 9530: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');

9526: then
9527: -- {
9528:
9529: l_stmt_num := 952;
9530: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9531: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9532: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9533: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9534:

Line 9531: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);

9527: -- {
9528:
9529: l_stmt_num := 952;
9530: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9531: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9532: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9533: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9534:
9535: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');

Line 9532: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);

9528:
9529: l_stmt_num := 952;
9530: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9531: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9532: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9533: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9534:
9535: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9536: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);

Line 9533: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);

9529: l_stmt_num := 952;
9530: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9531: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9532: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9533: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9534:
9535: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9536: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9537: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);

Line 9535: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');

9531: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9532: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9533: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9534:
9535: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9536: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9537: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9538:
9539: /* commented for bug 2865814 -- these messages raise signal 8 error.

Line 9536: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);

9532: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9533: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9534:
9535: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9536: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9537: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9538:
9539: /* commented for bug 2865814 -- these messages raise signal 8 error.
9540: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');

Line 9537: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);

9533: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9534:
9535: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9536: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9537: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9538:
9539: /* commented for bug 2865814 -- these messages raise signal 8 error.
9540: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9541: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',

Line 9540: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');

9536: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9537: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9538:
9539: /* commented for bug 2865814 -- these messages raise signal 8 error.
9540: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9541: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',
9542: (float)(((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty)));
9543: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(recving record)]The Rcv Txn cost shld be = %6.2f',
9544: (float)(((((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty))*conv_rate)/(uom_conv_rate)));

Line 9541: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',

9537: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9538:
9539: /* commented for bug 2865814 -- these messages raise signal 8 error.
9540: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9541: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',
9542: (float)(((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty)));
9543: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(recving record)]The Rcv Txn cost shld be = %6.2f',
9544: (float)(((((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty))*conv_rate)/(uom_conv_rate)));
9545: */

Line 9543: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(recving record)]The Rcv Txn cost shld be = %6.2f',

9539: /* commented for bug 2865814 -- these messages raise signal 8 error.
9540: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9541: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',
9542: (float)(((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty)));
9543: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(recving record)]The Rcv Txn cost shld be = %6.2f',
9544: (float)(((((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty))*conv_rate)/(uom_conv_rate)));
9545: */
9546: -- }
9547: else

Line 9554: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);

9550: then
9551: -- {
9552: l_stmt_num := 953;
9553:
9554: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);
9555: -- fnd_file.put_line(fnd_file.log, '[AX*]Rcvg Transaction Cost = %6.2f', (float)txn_cost*conv_rate);
9556: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9557: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);
9558: -- }

Line 9555: -- fnd_file.put_line(fnd_file.log, '[AX]Rcvg Transaction Cost = %6.2f', (float)txn_costconv_rate);

9551: -- {
9552: l_stmt_num := 953;
9553:
9554: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);
9555: -- fnd_file.put_line(fnd_file.log, '[AX*]Rcvg Transaction Cost = %6.2f', (float)txn_cost*conv_rate);
9556: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9557: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);
9558: -- }
9559: end if;

Line 9556: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);

9552: l_stmt_num := 953;
9553:
9554: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);
9555: -- fnd_file.put_line(fnd_file.log, '[AX*]Rcvg Transaction Cost = %6.2f', (float)txn_cost*conv_rate);
9556: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9557: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);
9558: -- }
9559: end if;
9560: -- }

Line 9557: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);

9553:
9554: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);
9555: -- fnd_file.put_line(fnd_file.log, '[AX*]Rcvg Transaction Cost = %6.2f', (float)txn_cost*conv_rate);
9556: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9557: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);
9558: -- }
9559: end if;
9560: -- }
9561: end if;

Line 9632: fnd_file.put_line(fnd_file.log, 'cost_process_discrete_trx >>>');

9628:
9629:
9630: COMMIT;
9631:
9632: fnd_file.put_line(fnd_file.log, 'cost_process_discrete_trx >>>');
9633:
9634: EXCEPTION
9635: when moh_rules_error then
9636: rollback;

Line 9645: fnd_file.put_line(fnd_file.log,'in errexit exception');

9641: o_error_message := FND_MESSAGE.Get;
9642:
9643: when errexit
9644: then
9645: fnd_file.put_line(fnd_file.log,'in errexit exception');
9646: ROLLBACK;
9647:
9648: O_Error_Num := NVL(O_Error_Num, -1);
9649: O_Error_Message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || l_stmt_num || '):' ||

Line 9682: fnd_file.put_line(fnd_file.log,'other exception raised');

9678: commit;
9679:
9680: when others
9681: then
9682: fnd_file.put_line(fnd_file.log,'other exception raised');
9683: rollback;
9684:
9685: O_error_num := SQLCODE;
9686: O_error_code := SQLCODE;

Line 9724: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');

9720: l_sign NUMBER;
9721: BEGIN
9722:
9723: IF G_DEBUG = 'Y' THEN
9724: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');
9725: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);
9726: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);
9727: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);
9728: END IF;

Line 9725: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);

9721: BEGIN
9722:
9723: IF G_DEBUG = 'Y' THEN
9724: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');
9725: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);
9726: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);
9727: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);
9728: END IF;
9729:

Line 9726: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);

9722:
9723: IF G_DEBUG = 'Y' THEN
9724: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');
9725: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);
9726: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);
9727: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);
9728: END IF;
9729:
9730: IF (i_txn_type_id <> 16) OR (i_txn_type_id IS NULL) THEN

Line 9727: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);

9723: IF G_DEBUG = 'Y' THEN
9724: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');
9725: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);
9726: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);
9727: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);
9728: END IF;
9729:
9730: IF (i_txn_type_id <> 16) OR (i_txn_type_id IS NULL) THEN
9731:

Line 9733: fnd_file.put_line(fnd_file.log,'Calling balance_account');

9729:
9730: IF (i_txn_type_id <> 16) OR (i_txn_type_id IS NULL) THEN
9731:
9732: IF G_DEBUG = 'Y' THEN
9733: fnd_file.put_line(fnd_file.log,'Calling balance_account');
9734: END IF;
9735:
9736: balance_account(
9737: I_ORG_ID => i_org_id,

Line 9746: fnd_file.put_line(fnd_file.log,' Case Logical RMA');

9742:
9743: ELSE
9744:
9745: IF G_DEBUG = 'Y' THEN
9746: fnd_file.put_line(fnd_file.log,' Case Logical RMA');
9747: END IF;
9748:
9749:
9750: l_stmt_num := 10;

Line 9872: fnd_file.put_line(fnd_file.log, 'Sum of base amount: '||l_base_value);

9868: RETURN;
9869: END IF;
9870:
9871: IF G_DEBUG = 'Y' THEN
9872: fnd_file.put_line(fnd_file.log, 'Sum of base amount: '||l_base_value);
9873: fnd_file.put_line(fnd_file.log, 'Sum of transaction amount: '||l_value);
9874: END IF;
9875:
9876: l_stmt_num := 20;

Line 9873: fnd_file.put_line(fnd_file.log, 'Sum of transaction amount: '||l_value);

9869: END IF;
9870:
9871: IF G_DEBUG = 'Y' THEN
9872: fnd_file.put_line(fnd_file.log, 'Sum of base amount: '||l_base_value);
9873: fnd_file.put_line(fnd_file.log, 'Sum of transaction amount: '||l_value);
9874: END IF;
9875:
9876: l_stmt_num := 20;
9877:

Line 9879: fnd_file.put_line(fnd_file.log, 'Creating the difference in adjustment account');

9875:
9876: l_stmt_num := 20;
9877:
9878: IF G_DEBUG = 'Y' THEN
9879: fnd_file.put_line(fnd_file.log, 'Creating the difference in adjustment account');
9880: END IF;
9881:
9882: IF (l_base_value*nvl(l_value,0) >=0 ) THEN
9883:

Line 10108: fnd_file.put_line(fnd_file.log,'Adjusting the transaction value balance value against record ' || l_rowid);

10104: decode(l_value, 0, NULL,-1*l_value),
10105: transaction_value - l_value),0)) >= 0;
10106: l_stmt_num := 50;
10107: IF (G_DEBUG = 'Y') THEN
10108: fnd_file.put_line(fnd_file.log,'Adjusting the transaction value balance value against record ' || l_rowid);
10109: END IF;
10110:
10111: update mtl_transaction_accounts
10112: set transaction_value = decode(transaction_value, NULL,

Line 10121: fnd_file.put_line(fnd_file.log,'balance_account_txn_type -');

10117: END IF;
10118:
10119: END IF;
10120: IF G_DEBUG = 'Y' THEN
10121: fnd_file.put_line(fnd_file.log,'balance_account_txn_type -');
10122: END IF;
10123: EXCEPTION
10124:
10125: WHEN OTHERS then