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 607: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Reversal' );

603: ( l_txn_act_id = 29 and l_src_type_id = 7 ) OR
604: ( ( l_txn_act_id = 12 and l_src_type_id = 7 and i_fob_point = 2 ) AND
605: l_txn_org_id = i_org_id ) ) THEN
606: IF (l_debug = 'Y' ) THEN
607: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Reversal' );
608: END IF;
609: CSTPAVCP.CompEncumbrance_IntOrdersExp (
610: p_api_version => 1.0,
611: p_transaction_id => i_txn_id,

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

614: x_return_status => l_return_status,
615: x_return_message => l_return_message );
616:
617: IF (l_debug = 'Y' ) THEN
618: FND_FILE.put_line( FND_FILE.log, 'Encumbrance Amount: '||l_enc_amount||', Encumbrance Account: '||l_enc_acct );
619: END IF;
620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;

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

642:
643: /* Bug 6030861 :Added hook call to override the recoverable and Non-Recoverable
644: taxes for ENCUMBRANCE_REVERSAL event */
645: IF l_debug = 'Y' THEN
646: fnd_file.put_line(fnd_file.log, 'Getting Po_Distribution_id for Receving transaction :'||l_rcv_transaction_id);
647: END IF;
648:
649: l_stmt_num := 43;
650: SELECT po_distribution_id

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

652: FROM rcv_transactions
653: WHERE transaction_id =l_rcv_transaction_id;
654:
655: IF l_debug = 'Y' THEN
656: fnd_file.put_line(fnd_file.log, 'Calling CST_Common_hooks.Get_NRtax_amount for PO_DIST :'||l_loc_po_distribution_id);
657: END IF;
658:
659: l_stmt_num := 45;
660: l_hook_used := CST_Common_hooks.Get_NRtax_amount(

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

677:
678: IF (l_err_num <> 0) THEN
679: -- Error occured
680: IF l_debug = 'Y' THEN
681: fnd_file.put_line(fnd_file.log, 'Error getting Enc Tax in CST_Common_hooks.Get_NRtax_amount at statement :'||l_stmt_num);
682: fnd_file.put_line(fnd_file.log, 'Error Code : '||l_err_code||' Error Message : '||l_err_msg);
683: END IF;
684: RAISE process_error;
685: END IF;

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

678: IF (l_err_num <> 0) THEN
679: -- Error occured
680: IF l_debug = 'Y' THEN
681: fnd_file.put_line(fnd_file.log, 'Error getting Enc Tax in CST_Common_hooks.Get_NRtax_amount at statement :'||l_stmt_num);
682: fnd_file.put_line(fnd_file.log, 'Error Code : '||l_err_code||' Error Message : '||l_err_msg);
683: END IF;
684: RAISE process_error;
685: END IF;
686:

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

684: RAISE process_error;
685: END IF;
686:
687: IF l_debug = 'Y' THEN
688: fnd_file.put_line(fnd_file.log,'Hook Used CST_Common_hooks.Get_NRtax_amount :'|| l_hook_used ||
689: ' l_loc_recoverable_tax : '||l_loc_recoverable_tax||
690: ' l_loc_non_recoverable_tax : '||l_loc_non_recoverable_tax);
691: END IF;
692:

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

733: where transaction_id = i_txn_id
734: and transaction_costed_date is NULL;
735:
736: IF (l_debug = 'Y' ) THEN
737: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_Txn >>');
738: END IF;
739:
740: EXCEPTION
741:

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

1303:
1304: -- check error
1305:
1306: if(l_err_num <> 0) then
1307: fnd_file.put_line(fnd_file.log, 'failed after distribute_accounts');
1308: raise process_error;
1309: end if;
1310:
1311: if (i_txn_act_id = 30) then /* WIP Scrap */

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

1349: i_prg_appl_id, i_prg_id,
1350: l_err_num, l_err_code, l_err_msg);
1351:
1352: if(l_err_num <> 0) then
1353: fnd_file.put_line(fnd_file.log, 'failed after inv_accounts');
1354: raise process_error;
1355: end if;
1356:
1357:

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

1378: l_err_num, l_err_code, l_err_msg);
1379:
1380:
1381: if(l_err_num <> 0) then
1382: fnd_file.put_line(fnd_file.log, 'failed after ovhd_accounts');
1383: raise process_error;
1384: end if;
1385:
1386: end if;

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

1389:
1390: EXCEPTION
1391:
1392: when process_error then
1393: fnd_file.put_line(fnd_file.log,'process raised');
1394: rollback;
1395: O_error_num := l_err_num;
1396: O_error_code := l_err_code;
1397: O_error_message := l_err_msg;

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

1396: O_error_code := l_err_code;
1397: O_error_message := l_err_msg;
1398:
1399: when others then
1400: fnd_file.put_line(fnd_file.log,'other exceptions raised');
1401: rollback;
1402: O_error_num := SQLCODE;
1403: O_error_message := 'CSTPACDP.wip_cost_txn (' || to_char(l_stmt_num) ||
1404: '): ' || substr(SQLERRM,1,180);

Line 1739: 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);

1735: (i_src_type_id <>1) and
1736: (i_txn_act_id <> 6) and
1737: (NOT (l_pd_xfer_ind = 'Y' and i_txn_act_id = 1 and i_src_type_id = 8)))
1738: then
1739: 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);
1740: return;
1741: elsif (i_exp_item = 1 and l_exp_acct = -1) then
1742:
1743: l_stmt_num := 20;

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

1762: * doesnt get booked *
1763: ****************************************************************************************/
1764: 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 */
1765: then
1766: fnd_file.put_line(fnd_file.log, 'Process/Discrete Internal Order issue for Asset Item from Expense Sub-Inventory.');
1767:
1768: distribute_accounts(i_org_id, i_txn_id,
1769: 0,i_cost_grp_id,i_txn_act_id,
1770: i_item_id, i_p_qty, 2,

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

1780: end if;
1781: elsif (l_pd_xfer_ind = 'N') OR
1782: (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 */
1783: then
1784: fnd_file.put_line(fnd_file.log, 'Posting elemental inv accounts');
1785:
1786: inventory_accounts(i_org_id, i_txn_id, 2,
1787: i_txn_act_id,i_cost_grp_id,
1788: i_item_id, i_p_qty,

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

2024: END IF;
2025: END IF;
2026:
2027: IF l_debug = 'Y' THEN
2028: FND_FILE.put_line(FND_FILE.log, 'Internal Order Issue to Expense');
2029: FND_FILE.put_line(FND_FILE.log, 'Debit Account - Receivables: '||to_char(l_acct) || ' InterOrg profit: ' || l_io_profit_acct);
2030: END IF;
2031:
2032: l_elemental := 0;

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

2025: END IF;
2026:
2027: IF l_debug = 'Y' THEN
2028: FND_FILE.put_line(FND_FILE.log, 'Internal Order Issue to Expense');
2029: FND_FILE.put_line(FND_FILE.log, 'Debit Account - Receivables: '||to_char(l_acct) || ' InterOrg profit: ' || l_io_profit_acct);
2030: END IF;
2031:
2032: l_elemental := 0;
2033: l_ovhd_absp := 0;

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

2039: l_elemental := 0;
2040: l_ovhd_absp := 0;
2041: end if;
2042:
2043: fnd_file.put_line(fnd_file.log, 'distribute_accounts()');
2044:
2045: -- Now for RMA receipts that reference an original sales order line ID
2046: IF (i_src_type_id = 12 AND i_txn_act_id = 27 AND l_ref_om_line_id IS NOT NULL) THEN
2047:

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

2115: --
2116: -- Book Receivalbes with transfer price
2117: -- Book Interorg Profit with diff of transfer price and cost
2118: --
2119: fnd_file.put_line(fnd_file.log,'Process/Discrete IO Issue to Exp Destination transaction');
2120:
2121: l_stmt_num := 50;
2122:
2123: l_io_receivable_acct := l_acct;

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

2139: end if;
2140:
2141: l_stmt_num := 60;
2142:
2143: fnd_file.put_line(fnd_file.log, 'booking receivables: ' || (-1 * i_p_qty * l_transfer_price) ||' ' || i_pri_curr);
2144:
2145: insert_account(i_org_id, i_txn_id, i_item_id, -1 * i_p_qty * l_transfer_price,
2146: -1 * i_p_qty, l_acct, i_sob_id, l_acct_line_type,
2147: NULL, NULL,

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

2157:
2158: --
2159: -- Book InterOrg Profit
2160: --
2161: fnd_file.put_line(fnd_file.log, 'booking interorg profit if necessary');
2162:
2163:
2164: l_stmt_num := 70;
2165: SELECT SUM(NVL(base_transaction_value,0))

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

2168: WHERE transaction_id = i_txn_id
2169: AND organization_id = i_org_id
2170: ;
2171:
2172: fnd_file.put_line(fnd_file.log,'InterOrg Profit amount: ' || l_value);
2173:
2174: IF l_value <> 0
2175: THEN
2176:

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

2221: and level_type = 1;
2222:
2223: if (l_mat_ovhd_exists > 0) then
2224:
2225: fnd_file.put_line(fnd_file.log, 'ovhd_accounts()');
2226: ovhd_accounts(i_org_id, i_txn_id, i_item_id, -1 * i_p_qty, i_sob_id,
2227: i_txn_date,i_txn_src_id, i_src_type_id,
2228: i_subinv, NULL,
2229: i_pri_curr, i_alt_curr, i_conv_date,

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

2394: l_return_status := fnd_api.g_ret_sts_success;
2395: l_msg_count := 0;
2396:
2397:
2398: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2399: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2400: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2401: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2402: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);

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

2395: l_msg_count := 0;
2396:
2397:
2398: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2399: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2400: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2401: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2402: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2403: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);

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

2396:
2397:
2398: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2399: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2400: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2401: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2402: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2403: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2404: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);

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

2397:
2398: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2399: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2400: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2401: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2402: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2403: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2404: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2405: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);

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

2398: fnd_file.put_line(fnd_file.log,'interorg_cost_txn(..)');
2399: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2400: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2401: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2402: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2403: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2404: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2405: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);
2406:

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

2399: fnd_file.put_line(fnd_file.log, 'transaction_id:' || i_txn_id);
2400: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2401: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2402: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2403: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2404: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2405: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);
2406:
2407: /* OPM INVCONV sschinch check if this is a process discrete transfer */

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

2400: fnd_file.put_line(fnd_file.log,'org_id:' || i_org_id);
2401: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2402: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2403: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2404: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2405: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);
2406:
2407: /* OPM INVCONV sschinch check if this is a process discrete transfer */
2408: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)

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

2401: fnd_file.put_line(fnd_file.log,'i_txn_org_id:' || i_txn_org_id);
2402: fnd_file.put_line(fnd_file.log,'i_txf_org_id:' || i_txf_org_id);
2403: fnd_file.put_line(fnd_file.log,'i_txf_txn_id:' || i_txf_txn_id);
2404: fnd_file.put_line(fnd_file.log,'i_exp_item:' || i_exp_item);
2405: fnd_file.put_line(fnd_file.log,'i_fob_point:' || i_fob_point);
2406:
2407: /* OPM INVCONV sschinch check if this is a process discrete transfer */
2408: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)
2409: INTO l_pd_txfr_ind

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

2436: WHERE org_information_context = 'Accounting Information'
2437: AND organization_id = i_txf_org_id;
2438:
2439: l_io_invoicing := to_number(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'));
2440: fnd_file.put_line(fnd_file.LOG, 'SrcTypeID/ActID = ' || i_src_type_id ||'/'|| i_txn_act_id ||
2441: ' OU/xferOU: ' || l_org_ou ||'/'|| l_txf_org_ou ||
2442: ' Internal Order invoicing: ' || l_io_invoicing);
2443:
2444: END IF;

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

2533: (i_txn_act_id = 15 and i_org_id = i_txn_org_id)) then -- OPM INVCONV umoogala
2534: l_snd_rcv := 2;
2535: end if;
2536:
2537: fnd_file.put_line(fnd_file.log,'l_snd_rcv:' || l_snd_rcv);
2538:
2539:
2540: if (l_snd_rcv = 1) then
2541: if (i_org_id = i_txn_org_id or i_txn_act_id = 3) then

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

2590: l_subinv := NULL;
2591: end if;
2592: end if;
2593:
2594: fnd_file.put_line(fnd_file.log,'l_from_org:' || l_from_org);
2595: fnd_file.put_line(fnd_file.log,'l_to_org:' || l_to_org);
2596:
2597:
2598:

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

2591: end if;
2592: end if;
2593:
2594: fnd_file.put_line(fnd_file.log,'l_from_org:' || l_from_org);
2595: fnd_file.put_line(fnd_file.log,'l_to_org:' || l_to_org);
2596:
2597:
2598:
2599: CSTPAVCP.get_snd_rcv_rate(i_txn_id, l_from_org, l_to_org,

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

2755:
2756: /*******************************************************************
2757: ** Do sending org distribution **
2758: *******************************************************************/
2759: fnd_file.put_line(fnd_file.log,'Sending org distributions');
2760:
2761: if (l_from_org = i_org_id) and (i_txn_act_id = 22) -- OPM INVCONV umoogala
2762: then
2763: /* INVCONV Bug#5476804 ANTHIYAG 21-Aug-2006 Start */

Line 2770: 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');

2766: * Inter-Org profit accounts need to be booked, Otherwise if Intercompany Invoicing is enabled *
2767: * for a Expense Item, No need for creating any bookings at all *
2768: ***********************************************************************************************/
2769: 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 */
2770: 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');
2771: RETURN;
2772: END IF;
2773: /* INVCONV Bug#5476804 ANTHIYAG 21-Aug-2006 End */
2774: --

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

2795: if (l_acct = -1) then
2796: l_acct := i_trp_acct;
2797: end if;
2798:
2799: fnd_file.put_line(fnd_file.log,'Freight account: ' || l_value);
2800:
2801: insert_account(l_from_org, i_txn_id, i_item_id, -1*l_value,
2802: l_snd_qty, l_acct, l_snd_sob_id, 12, NULL, NULL,
2803: i_txn_date, i_txn_src_id, i_src_type_id,

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

2819: -- l_value := i_trp_cost + (i_txf_price * l_snd_qty);
2820: --
2821: l_value := i_txf_price * l_snd_qty;
2822:
2823: fnd_file.put_line(fnd_file.log,'Receivables amount: ' || l_value);
2824:
2825: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 10,
2826: NULL, NULL, l_subinv,0, l_snd_rcv,
2827: l_err_num, l_err_code, l_err_msg);

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

2853: --
2854: if i_exp_item = 0
2855: then
2856:
2857: fnd_file.put_line(fnd_file.log,'Intransit account: with item cost' );
2858:
2859: /*
2860: --
2861: -- Bug 4900652

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

2897: and (i_txn_act_id = 21) -- Bug 5351724
2898: and (i_exp_item = 1) -- Bug 5348953: No IC Invoicing for expense items
2899: then
2900: NULL;
2901: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||
2902: 'is enabled.');
2903: else
2904: /* Book InterOrg profit */
2905: SELECT SUM(NVL(base_transaction_value,0))

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

2908: WHERE transaction_id = i_txn_id
2909: AND organization_id = l_from_org
2910: ;
2911:
2912: fnd_file.put_line(fnd_file.log,'InterOrg Profit amount: ' || l_value);
2913:
2914: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 34,
2915: NULL, NULL, l_subinv,0, l_snd_rcv,
2916: l_err_num, l_err_code, l_err_msg);

Line 3006: 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');

3002: * for a Expense Item, No need for creating any bookings at all *
3003: ***********************************************************************************************/
3004:
3005: 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 */
3006: 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');
3007: RETURN;
3008: ELSE
3009: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: Not booking to expense. Receivables and InterOrg Profit Accounts will get booked');
3010: END IF;

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

3005: 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 */
3006: 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');
3007: RETURN;
3008: ELSE
3009: fnd_file.put_line(fnd_file.log, 'Process/Discrete Xfer: Not booking to expense. Receivables and InterOrg Profit Accounts will get booked');
3010: END IF;
3011: /* INVCONV Bug#5465239 ANTHIYAG 18-Aug-2006 End */
3012: else
3013: distribute_accounts(l_from_org, i_txn_id,

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

3081: else
3082: l_value := i_txf_cost;
3083: end if;
3084:
3085: fnd_file.put_line(fnd_file.log,'Transfer Credit account: ' || l_value);
3086:
3087: /* Credit sending org transfer credit */
3088: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 11,
3089: NULL, NULL, l_subinv,0, l_snd_rcv,

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

3128: else
3129: l_value := i_trp_cost;
3130: end if;
3131:
3132: fnd_file.put_line(fnd_file.log,'Freight account: ' || l_value);
3133:
3134: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 12,
3135: NULL, NULL, l_subinv,0, l_snd_rcv,
3136: l_err_num, l_err_code, l_err_msg);

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

3184: else
3185: l_value := i_txf_price * l_snd_qty; -- OPM INVCONV umoogala/sschinch
3186: end if;
3187:
3188: fnd_file.put_line(fnd_file.log,'receivables account: ' || l_value);
3189:
3190: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 10,
3191: NULL, NULL, l_subinv,0, l_snd_rcv,
3192: l_err_num, l_err_code, l_err_msg);

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

3233: AND (i_txn_act_id = 21) -- Bug 5351724
3234: AND (i_exp_item = 0) -- Bug 5348953: No IC Invoicing for expense items
3235: THEN
3236: NULL;
3237: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||
3238: 'is enabled.');
3239: ELSE
3240:
3241: /* Book interorg profit */

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

3245: WHERE transaction_id = i_txn_id
3246: AND organization_id = l_from_org
3247: ;
3248:
3249: fnd_file.put_line(fnd_file.log,'InterOrg profit account: ' || l_value);
3250:
3251: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1,
3252: G_INTERORG_PROFIT_ACCT,
3253: NULL, NULL, l_subinv,0, l_snd_rcv,

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

3364:
3365: /*******************************************************************
3366: ** Do receiving org distribution **
3367: *******************************************************************/
3368: fnd_file.put_line(fnd_file.log,'Receiving org distributions');
3369:
3370: /* Begin OPM INVCONV sschinch Logical Intransit Receipt FOB Shipping*/
3371: if (i_txn_act_id = 15)
3372: then

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

3380: -- Dr Intransit
3381: -- Amount should be (transfer_price + freight)
3382: -- actual_cost in mcacd is (transfer_price + freight)
3383: --
3384: fnd_file.put_line(fnd_file.log,'Dr intransit account @ org cost');
3385:
3386: /* Dr Receiving Org's intransit. */
3387: l_intransit := 1;
3388:

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

3417: -- Cr InterOrg Payables with transfer price.
3418: --
3419: l_value := i_txf_price * l_rcv_qty;
3420:
3421: fnd_file.put_line(fnd_file.log,'Cr payable. amount(l_value):' || -1 * l_value);
3422:
3423: /* INVCONV Bug#5471471 ANTHIYAG 18-Aug-2006 Start */
3424: /************************************************************************************
3425: * If Intercompany invoicing is enabled, then the booking should be made against the *

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

3497: if (l_acct = -1) then
3498: l_acct := i_trp_acct;
3499: end if;
3500:
3501: fnd_file.put_line(fnd_file.log,'Cr Freight. amount(l_value):' || -1 * l_value);
3502: insert_account(l_to_org, i_txn_id, i_item_id, -1 * l_value,
3503: l_rcv_qty, l_acct, l_rcv_sob_id, 12, NULL, NULL,
3504: i_txn_date, i_txn_src_id, i_src_type_id,
3505: l_rcv_curr, l_snd_curr,

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

3548: where mctcd.transaction_id = i_txn_id
3549: and mctcd.organization_id = l_std_org
3550: ;
3551:
3552: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);
3553:
3554: l_stmt_num := 90;
3555:
3556: -- If MOH Absorption is overridden, the this level moh costs have to be driven to ppv.

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

3597: and level_type = 1);
3598: -- Earn only this level MOH
3599: END IF;
3600:
3601: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);
3602:
3603:
3604: -- Changes for PJM for Standard Costing
3605: l_stmt_num := 95;

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

3650: else
3651: l_intransit := 0;
3652: end if;
3653:
3654: fnd_file.put_line(fnd_file.log,'l_intransit:' || l_intransit);
3655:
3656:
3657: -- First do the distributions for ownership change
3658: if ((i_txn_act_id = 3 and i_txn_qty > 0) or

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

3659: (i_txn_act_id = 21 and i_fob_point = 1) or
3660: (i_txn_act_id = 12 and i_fob_point = 2)) then
3661: if (l_to_org = i_org_id) then /* Avg Costing */
3662: /* Debit inventory or intransit at receiving org's cost */
3663: fnd_file.put_line(fnd_file.log,'Calling Inventory acct');
3664:
3665: --
3666: -- OPM INVCONV umoogala
3667: -- Added if/else block to process process-discrete transfers

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

3723: l_acct_line_type := 1;
3724: end if;
3725:
3726: if (l_debug = 'Y') then
3727: fnd_file.put_line(fnd_file.log, 'l_acct_line_type:' || l_acct_line_type);
3728: end if;
3729:
3730:
3731: --

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

3731: --
3732: -- Bug 5391121: incorrect sign for qty
3733: -- was: -1 * l_rcv_qty, now: l_rcv_qty
3734: --
3735: fnd_file.put_line(fnd_file.log,'calling insert_account for booking INV with value/qty: ' || l_value ||'/'||l_rcv_qty);
3736: insert_account(l_to_org, i_txn_id, i_item_id, l_value,
3737: l_rcv_qty, l_acct, l_rcv_sob_id, l_acct_line_type, NULL, NULL,
3738: i_txn_date, i_txn_src_id, i_src_type_id,
3739: l_rcv_curr, l_snd_curr,

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

3748: end if;
3749: end if; -- OPM INVCONV umoogala
3750:
3751: else /* Std Costing Org */
3752: fnd_file.put_line(fnd_file.log,'Calling distribute accts');
3753:
3754: if (l_intransit = 1 and l_std_exp_item = 0) then
3755: distribute_accounts(l_to_org, i_txn_id,
3756: 0,i_cost_grp_id,i_txn_act_id,

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

3765: raise process_error;
3766: end if;
3767:
3768: else
3769: fnd_file.put_line(fnd_file.log,'Calling distribute accts(2)');
3770:
3771: if (l_std_exp_item = 1 or l_std_exp_sub = 1) then
3772: distribute_accounts(l_to_org, i_txn_id,
3773: 0,i_cost_grp_id,i_txn_act_id,

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

3782: raise process_error;
3783: end if;
3784:
3785: else
3786: fnd_file.put_line(fnd_file.log,'Calling distribute accts(3)');
3787:
3788: distribute_accounts(l_to_org, i_txn_id,
3789: 0,i_cost_grp_id,i_txn_act_id,
3790: i_item_id, l_rcv_qty, 1,

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

3816: from mtl_cst_txn_cost_details mctcd
3817: where mctcd.transaction_id = i_txn_id
3818: and mctcd.organization_id = l_std_org;
3819:
3820: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);
3821:
3822: l_stmt_num := 90;
3823:
3824: /* If MOH Absorption is overridden, the this level moh costs

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

3866: and level_type = 1);
3867: /* Earn only this level MOH */
3868: END IF;
3869:
3870: fnd_file.put_line(fnd_file.log,'ppv:' || l_ppv);
3871:
3872:
3873: /* Changes for PJM for Standard Costing */
3874: l_stmt_num := 95;

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

4015: if (l_err_num <> 0) then
4016: raise process_error;
4017: end if;
4018:
4019: fnd_file.put_line(fnd_file.log,'Inter Company Accrual amount(l_value):' || l_value || ' acct: ' || l_acct);
4020:
4021: ELSE
4022: /* INVCONV Bug#5476815 ANTHIYAG 21-Aug-2006 End */
4023:

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

4031: if (l_acct = -1) then
4032: l_acct := l_io_pay_acct;
4033: end if;
4034:
4035: fnd_file.put_line(fnd_file.log,'Payable amount(l_value):' || l_value || ' acct: ' || l_acct);
4036:
4037: /* Bug 3169767: use -1*l_rcv_qty */
4038: insert_account(l_to_org, i_txn_id, i_item_id, -1 * l_value,
4039: -1 * l_rcv_qty, l_acct, l_rcv_sob_id, 9, NULL, NULL,

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

4214: */
4215:
4216: elsif (l_std_exp_item = 0) then /* Standard Cost Org */
4217:
4218: fnd_file.put_line(fnd_file.log,'Std org: Dr inv at receiving org cost');
4219:
4220:
4221: /* Debit Invenoty at Rcv org's cost */
4222: if (l_std_exp_sub = 1) then

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

4350:
4351: l_stmt_num := 2;
4352: if (i_qty = 0 and l_debug = 'Y') THEN
4353: FND_MESSAGE.set_name('BOM', 'CST_UPDATE_ZERO_QTY');
4354: fnd_file.put_line(fnd_file.log, 'CSTPACDP.avcu_cost_txn: ' || FND_MESSAGE.Get);
4355: end if;
4356:
4357: l_stmt_num := 5;
4358:

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

5434: l_cost := '';
5435:
5436: l_stmt_num := 10;
5437:
5438: fnd_file.put_line(fnd_file.log, 'In Inventory_accounts');
5439:
5440: l_debug := fnd_profile.value('MRP_DEBUG');
5441:
5442: select decode(i_exp_item, 0, nvl(i_exp_subinv,0), i_exp_item)

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

5509: and organization_id = i_org_id
5510: and cost_group_id = i_cost_grp_id;
5511:
5512: if (l_debug = 'Y') then
5513: fnd_file.put_line(fnd_file.log, 'layer_id:' || l_layer_id);
5514: end if;
5515:
5516:
5517: if (i_intransit = 1 and i_exp_item = 0) then

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

5523: l_acct_line_type := 1;
5524: end if;
5525:
5526: if (l_debug = 'Y') then
5527: fnd_file.put_line(fnd_file.log, 'l_acct_line_type:' || l_acct_line_type);
5528: end if;
5529:
5530:
5531: l_stmt_num := 30;

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

5557: FOR cost_element IN 1..5 loop
5558: l_cost := NULL;
5559:
5560: if (l_debug = 'Y') then
5561: fnd_file.put_line(fnd_file.log, 'in cost element loop');
5562: end if;
5563:
5564:
5565: l_stmt_num := 40;

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

5579:
5580: if (l_cost is not NULL) then
5581:
5582: if (l_debug = 'Y') then
5583: fnd_file.put_line(fnd_file.log, 'org-txn-i_p_qty-cost_element-i_subinv');
5584: fnd_file.put_line(fnd_file.log, i_org_id || '-' || i_txn_id || '-' ||
5585: i_p_qty || '-' || i_subinv);
5586: end if;
5587: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

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

5580: if (l_cost is not NULL) then
5581:
5582: if (l_debug = 'Y') then
5583: fnd_file.put_line(fnd_file.log, 'org-txn-i_p_qty-cost_element-i_subinv');
5584: fnd_file.put_line(fnd_file.log, i_org_id || '-' || i_txn_id || '-' ||
5585: i_p_qty || '-' || i_subinv);
5586: end if;
5587: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
5588: sign(i_p_qty), l_acct_line_type,

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

5595: raise process_error;
5596: end if;
5597:
5598: if (l_debug = 'Y') then
5599: fnd_file.put_line(fnd_file.log, 'Calling Insert Account');
5600: end if;
5601:
5602:
5603: if (l_acct = -1) then

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

5780:
5781: when process_error then
5782: rollback;
5783: if (l_debug = 'Y') then
5784: fnd_file.put_line (fnd_file.log, 'Inventory_accounts' || to_char(l_stmt_num)
5785: || substr(SQLERRM,1,180));
5786: end if;
5787: O_error_num := l_err_num;
5788: O_error_code := l_err_code;

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

5805: when others then
5806:
5807: rollback;
5808: if (l_debug = 'Y') then
5809: fnd_file.put_line (fnd_file.log, 'Inventory_accounts' || to_char(l_stmt_num)
5810: || substr(SQLERRM,1,180)) ;
5811: end if;
5812: O_error_num := SQLCODE;
5813: O_error_message := 'CSTPACDP.inventory_accounts' || to_char(l_stmt_num) ||

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

5880: l_err_msg := '';
5881: l_debug := fnd_profile.value('MRP_DEBUG');
5882:
5883:
5884: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5885: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5886: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5887: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5888: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);

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

5881: l_debug := fnd_profile.value('MRP_DEBUG');
5882:
5883:
5884: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5885: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5886: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5887: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5888: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5889: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);

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

5882:
5883:
5884: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5885: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5886: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5887: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5888: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5889: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5890: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);

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

5883:
5884: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5885: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5886: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5887: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5888: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5889: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5890: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);
5891:

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

5884: fnd_file.put_line(fnd_file.log,'In distribute_accounts');
5885: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5886: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5887: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5888: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5889: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5890: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);
5891:
5892:

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

5885: fnd_file.put_line(fnd_file.log,'i_org_id:' || i_org_id );
5886: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5887: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5888: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5889: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5890: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);
5891:
5892:
5893: -- For the logical txns introduced in the dropshipment project, standard costing

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

5886: fnd_file.put_line(fnd_file.log,'i_txn_id:' || i_txn_id);
5887: fnd_file.put_line(fnd_file.log,'i_comm_iss_flag:' || i_comm_iss_flag);
5888: fnd_file.put_line(fnd_file.log,'i_acct_linr_type:' || i_acct_line_type);
5889: fnd_file.put_line(fnd_file.log,'i_elemental:' || i_elemental);
5890: fnd_file.put_line(fnd_file.log,'i_ovhd_absp:' || i_ovhd_absp);
5891:
5892:
5893: -- For the logical txns introduced in the dropshipment project, standard costing
5894: -- orgs will also call the average cost distribution processor. A few changes

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

5955: OR
5956: (cost_element_id = 2
5957: and level_type = decode(i_ovhd_absp,1,2,2,0,level_type)));
5958:
5959: fnd_file.put_line(fnd_file.log,'actual_cost:' || l_elemental_cost(cost_element) );
5960:
5961: if (l_elemental_cost(cost_element) is not null) then
5962:
5963: -- dropshipment changes

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

5990: into l_acct
5991: from dual;
5992: end if;
5993:
5994: fnd_file.put_line(fnd_file.log, 'ElementID: ' || cost_element || ' Amt: ' || (i_p_qty * l_elemental_cost(cost_element)) ||
5995: ' Acct: ' || l_acct);
5996:
5997: insert_account(i_org_id, i_txn_id, i_item_id, i_p_qty * l_elemental_cost(cost_element),
5998: i_p_qty, l_acct, i_sob_id, i_acct_line_type,

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

6104: END;
6105: l_cost := l_cost + l_ce_round_cost;
6106: END LOOP;
6107:
6108: fnd_file.put_line(fnd_file.log,'actual_cost(60):' || l_cost );
6109:
6110:
6111: l_stmt_num := 60;
6112:

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

6133: end if;
6134:
6135: l_stmt_num := 70;
6136:
6137: fnd_file.put_line(fnd_file.log, 'Insert account()');
6138:
6139: insert_account(i_org_id, i_txn_id, i_item_id, i_p_qty * l_cost,
6140: i_p_qty, l_acct, i_sob_id, i_acct_line_type,
6141: NULL, NULL,

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

6582: l_err_num := 0;
6583: l_err_code := '';
6584: l_err_msg := '';
6585:
6586: fnd_file.put_line(fnd_file.log, 'In insert accounts');
6587:
6588: if (i_acct = -1) then
6589: raise invalid_acct_error;
6590: end if;

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

6631: END IF;
6632: END IF;
6633: END IF; /* IF(l_enc_rev = 1) */
6634:
6635: FND_FILE.put_line(FND_FILE.log,'l_ussgl_tc : '||l_ussgl_tc);
6636:
6637:
6638: /* The following select statement will be made to refer to cst_organization_definitions as an impact of the HR-PROFILE option */
6639: l_stmt_num := 5;

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

6777: rollback;
6778: O_error_num := SQLCODE;
6779: O_error_message := 'CSTPACDP.insert_account (' || to_char(l_stmt_num)
6780: || ') ' || substr(SQLERRM,1,180);
6781: FND_FILE.put_line(FND_FILE.log,'DS - others Exception, sqlcode = '||SQLCODE);
6782:
6783: end insert_account;
6784:
6785: procedure balance_account(

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

6797:
6798: BEGIN
6799:
6800: l_stmt_num := 10;
6801: fnd_file.put_line(fnd_file.log,'In balance account!!!!');
6802:
6803: select nvl(sum(base_transaction_value),0), nvl(sum(transaction_value),0)
6804: into l_base_value, l_value
6805: from mtl_transaction_accounts

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

6809: if (l_base_value = 0 and l_value = 0) then
6810: return;
6811: end if;
6812:
6813: fnd_file.put_line(fnd_file.log, 'Adjustment Amount: '||l_base_value);
6814: l_stmt_num := 20;
6815:
6816: -- Bug# 4052277 (propagation of 4015478).
6817: -- Added condition in where clause to check that balance amount should not be

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

6829: AND organization_id = i_org_id
6830: AND accounting_line_type NOT IN (9,10,15); /* this condition added for 4052277 */
6831:
6832: l_stmt_num := 30;
6833: fnd_file.put_line(fnd_file.log,'Adjusting Balance value against record ' || l_rowid);
6834:
6835:
6836: update mtl_transaction_accounts
6837: set transaction_value = decode(transaction_value, NULL,

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

7094: l_conv_date DATE;
7095: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 End */
7096:
7097: begin
7098: fnd_file.put_line(fnd_file.log, 'cost_process_discrete_trx <<<');
7099: l_debug := fnd_profile.value('MRP_DEBUG');
7100:
7101: /* Check if the organization_id and/or transfer_organization_id
7102: are average or FIFO/LIFO orgs. If so, error out this transaction, since it is just meant

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

7152:
7153:
7154: -- code to stop profile is at the end of this procedure.
7155: --
7156: fnd_file.put_line(fnd_file.log, 'src/act: ' || src_type_id ||'/'|| txn_act_id);
7157:
7158: fnd_file.put_line(fnd_file.log, 'txnId/Org: ' || trans_id || '/' || org_id ||
7159: ', xferOrg: ' || txf_org_id || ' XferPrice: ' || interorg_xfr_price ||
7160: ', p_qty: ' || p_qty);

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

7154: -- code to stop profile is at the end of this procedure.
7155: --
7156: fnd_file.put_line(fnd_file.log, 'src/act: ' || src_type_id ||'/'|| txn_act_id);
7157:
7158: fnd_file.put_line(fnd_file.log, 'txnId/Org: ' || trans_id || '/' || org_id ||
7159: ', xferOrg: ' || txf_org_id || ' XferPrice: ' || interorg_xfr_price ||
7160: ', p_qty: ' || p_qty);
7161: fnd_file.put_line(fnd_file.log, 'cg_id: ' || cg_id);
7162:

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

7157:
7158: fnd_file.put_line(fnd_file.log, 'txnId/Org: ' || trans_id || '/' || org_id ||
7159: ', xferOrg: ' || txf_org_id || ' XferPrice: ' || interorg_xfr_price ||
7160: ', p_qty: ' || p_qty);
7161: fnd_file.put_line(fnd_file.log, 'cg_id: ' || cg_id);
7162:
7163: --
7164: -- Bug 5233635; Should not book InterOrg Profit when Intercompany Invoicing is enabled.
7165: --

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

7178: WHERE org_information_context = 'Accounting Information'
7179: AND organization_id = txf_org_id;
7180:
7181: l_io_invoicing := to_number(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'));
7182: fnd_file.put_line(fnd_file.LOG, 'OU/xferOU: ' || l_org_ou ||'/'||l_txf_org_ou||
7183: ' Internal Order invoicing: ' || l_io_invoicing);
7184:
7185: --
7186: -- End Bug 5233635

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

7209: INTO pjm_flg
7210: FROM MTL_PARAMETERS
7211: WHERE organization_id = org_id;
7212:
7213: fnd_file.put_line(fnd_file.log, 'wms_flg: ' || wms_flg || ' pjm_flg: ' || pjm_flg);
7214:
7215: l_stmt_num := 60;
7216:
7217: /* Not sure what to do here!

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

7344: WHERE secondary_inventory_name = subinv
7345: AND organization_id = org_id;
7346: end if;
7347:
7348: fnd_file.put_line(fnd_file.log, 'iexp_flag/exp_flg/exp_sub: ' || iexp_flg ||'/'|| exp_flg || '/'|| exp_sub);
7349:
7350:
7351: /*----------------------------------------------------------------------+
7352: | Get elemental accounts

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

7430:
7431: /*----------------------------------------------------------------------+
7432: |Insert standard cost into mtl_cst_actual_cost_details
7433: +----------------------------------------------------------------------*/
7434: fnd_file.put_line(fnd_file.log, 'inserting into mcacd');
7435:
7436: l_stmt_num := 280;
7437: CSTPSISC.ins_std_cost(org_id, item_id, trans_id,
7438: txn_act_id, src_type_id,

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

7496: from_cost_grp := txf_cg_id;
7497: to_cost_grp := cg_id;
7498: end if;
7499:
7500: fnd_file.put_line(fnd_file.log,'snd_rcv: ' || snd_rcv);
7501: fnd_file.put_line(fnd_file.log,'from_org: ' || from_org);
7502: fnd_file.put_line(fnd_file.log,'to_org: ' || to_org);
7503:
7504: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 Start */

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

7497: to_cost_grp := cg_id;
7498: end if;
7499:
7500: fnd_file.put_line(fnd_file.log,'snd_rcv: ' || snd_rcv);
7501: fnd_file.put_line(fnd_file.log,'from_org: ' || from_org);
7502: fnd_file.put_line(fnd_file.log,'to_org: ' || to_org);
7503:
7504: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 Start */
7505: CSTPAVCP.get_snd_rcv_rate(trans_id, from_org, to_org,

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

7498: end if;
7499:
7500: fnd_file.put_line(fnd_file.log,'snd_rcv: ' || snd_rcv);
7501: fnd_file.put_line(fnd_file.log,'from_org: ' || from_org);
7502: fnd_file.put_line(fnd_file.log,'to_org: ' || to_org);
7503:
7504: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 Start */
7505: CSTPAVCP.get_snd_rcv_rate(trans_id, from_org, to_org,
7506: l_snd_sob_id, l_snd_curr, l_rcv_sob_id, l_rcv_curr,

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

7509:
7510: if (O_Error_Num <> 0) then
7511: raise errexit;
7512: end if;
7513: fnd_file.put(fnd_file.log, 'fromOrg/SOB/Curr: ' || from_org ||'/'|| l_snd_sob_id ||'/'|| l_snd_curr);
7514: fnd_file.put(fnd_file.log, 'toOrg/SOB/Curr: ' || to_org ||'/'|| l_rcv_sob_id ||'/'|| l_rcv_curr);
7515: fnd_file.put(fnd_file.log, 'currType/Rate/Date: ' || l_curr_type ||'/'|| l_conv_rate ||'/'|| l_conv_date);
7516:
7517: /* umoogala Bug#5708387 13-dec-2006

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

7510: if (O_Error_Num <> 0) then
7511: raise errexit;
7512: end if;
7513: fnd_file.put(fnd_file.log, 'fromOrg/SOB/Curr: ' || from_org ||'/'|| l_snd_sob_id ||'/'|| l_snd_curr);
7514: fnd_file.put(fnd_file.log, 'toOrg/SOB/Curr: ' || to_org ||'/'|| l_rcv_sob_id ||'/'|| l_rcv_curr);
7515: fnd_file.put(fnd_file.log, 'currType/Rate/Date: ' || l_curr_type ||'/'|| l_conv_rate ||'/'|| l_conv_date);
7516:
7517: /* umoogala Bug#5708387 13-dec-2006
7518: * l_conv_date is not returned from above call. Using txn date

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

7511: raise errexit;
7512: end if;
7513: fnd_file.put(fnd_file.log, 'fromOrg/SOB/Curr: ' || from_org ||'/'|| l_snd_sob_id ||'/'|| l_snd_curr);
7514: fnd_file.put(fnd_file.log, 'toOrg/SOB/Curr: ' || to_org ||'/'|| l_rcv_sob_id ||'/'|| l_rcv_curr);
7515: fnd_file.put(fnd_file.log, 'currType/Rate/Date: ' || l_curr_type ||'/'|| l_conv_rate ||'/'|| l_conv_date);
7516:
7517: /* umoogala Bug#5708387 13-dec-2006
7518: * l_conv_date is not returned from above call. Using txn date
7519: */

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

7518: * l_conv_date is not returned from above call. Using txn date
7519: */
7520: l_conv_date := nvl(l_conv_date, txn_date);
7521:
7522: fnd_file.put(fnd_file.log, 'currDate: ' || l_conv_date );
7523: /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 End */
7524:
7525: /*----------------------------------------------------------------------+
7526: | Get sending and reciving uom

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

7577: AND mip.to_organization_id = to_org
7578: AND mp.organization_id = org_id
7579: AND mmt.transaction_id = trans_id;
7580:
7581: fnd_file.put_line(fnd_file.log, 'FOB = ' || fob_pt);
7582:
7583:
7584: /*----------------------------------------------------------------------+
7585: | Get act_cost and item_cost. It is used only in AX code

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

7589: FROM cst_item_costs_for_gl_view
7590: WHERE inventory_item_id = item_id
7591: AND organization_id = org_id;
7592:
7593: fnd_file.put_line(fnd_file.log, 'act_cost: ' || act_cost || ' item_cost: ' || item_cost);
7594:
7595:
7596: /*----------------------------------------------------------------------+
7597: * Get PPV Account only for receiving transactions

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

7682: -- Bug 5021305: Added following to see overhead rules are setup or not.
7683: -- Bug 5349860: umoogala - exclude issue/receipt (to exp destination) txn.
7684: --
7685:
7686: fnd_file.put_line(fnd_file.log, 'Verifying whether to earn MOH or not...');
7687:
7688: IF (txn_act_id <> 1) AND (txn_act_id <> 17) AND
7689: (NOT exp_flg = 1) AND (NOT exp_sub = 1)
7690: THEN

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

7712: x_return_status => l_return_status);
7713: RAISE moh_rules_error;
7714: END IF;
7715:
7716: fnd_file.put_line(fnd_file.log, 'l_earn_moh: ' || l_earn_moh);
7717:
7718: END IF;
7719:
7720: <>

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

7740: then
7741: --{
7742:
7743: /* Direct interorg between discrete orgs or fob ship */
7744: fnd_file.put_line(fnd_file.log, 'Processing shipment txn. FOB = ' || fob_pt);
7745:
7746: /*----------------------------------------------------------------------+
7747: |Sending Organization : Do accounting for asset subinventory only
7748: +----------------------------------------------------------------------*/

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

7756:
7757: /*----------------------------------------------------------------------+
7758: | Cr Inv. Val @ sending org cost
7759: +----------------------------------------------------------------------*/
7760: fnd_file.put_line(fnd_file.log, 'Cr Inv Val @ sending org cost');
7761:
7762: CSTPACDP.distribute_accounts(
7763: org_id, trans_id,
7764: 0, cg_id , txn_act_id,

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

7788:
7789: /*----------------------------------------------------------------------+
7790: | Dr Exp Acct
7791: +----------------------------------------------------------------------*/
7792: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
7793: l_stmt_num := 750;
7794:
7795: --
7796: -- Bug 5331207:

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

7835:
7836: /*----------------------------------------------------------------------+
7837: | Cr Freight Acct
7838: +----------------------------------------------------------------------*/
7839: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
7840: CSTPACDP.insert_account
7841: (org_id, trans_id, item_id, -1 * trp_cost,
7842: p_qty, trp_acct, sob_id, 12, NULL, NULL,
7843: txn_date, txn_src_id, src_type_id,

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

7869: io_rec_acct := user_acct_id;
7870: end if;
7871:
7872:
7873: fnd_file.put_line(fnd_file.log, 'Dr Receivables with ' || (txf_price * p_qty) || ' ' || pri_curr);
7874: CSTPACDP.insert_account
7875: (org_id, trans_id, item_id, -1 * txf_price * p_qty,
7876: -1 * p_qty, io_rec_acct, sob_id, 10, NULL, NULL,
7877: txn_date, txn_src_id, src_type_id,

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

7899: and (txn_act_id = 21) -- Bug 5351724
7900: and (iexp_flg = 0) -- Bug 5348953: No IC Invoicing for expense items
7901: then
7902: NULL;
7903: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||
7904: 'is enabled.');
7905: else
7906: /*
7907: * Replaced with following SQL

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

7919: WHERE transaction_id = trans_id
7920: AND organization_id = org_id
7921: ;
7922:
7923: fnd_file.put_line(fnd_file.log, 'InterOrg Profit = ' || nvl(interorg_profit, 0) || ' ' || pri_curr);
7924:
7925: if (interorg_profit <> 0)
7926: then
7927:

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

7938: then
7939: interorg_profit_acct := user_acct_id;
7940: end if;
7941:
7942: fnd_file.put_line(fnd_file.log, 'Cr InterOrg Profit with ' || nvl(interorg_profit,0) || ' ' || pri_curr);
7943: CSTPACDP.insert_account
7944: (org_id, trans_id, item_id, -1 * interorg_profit,
7945: p_qty, interorg_profit_acct, sob_id,
7946: G_INTERORG_PROFIT_ACCT, NULL, NULL,

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

7968: elsif (txn_act_id = 21 AND fob_pt = 2)
7969: then
7970: --{
7971:
7972: fnd_file.put_line(fnd_file.log, 'Processing intransit shipment. FOB = ' || fob_pt);
7973:
7974: --
7975: -- Bug 5332792: No accounting for shipment txn with FOB Receipt for expense item
7976: -- Added 2nd condition (NOT iexp_flg = 1) to the IF stmt below.

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

7994:
7995: /*----------------------------------------------------------------------+
7996: | Cr Inv. Val @ sending org cost
7997: +----------------------------------------------------------------------*/
7998: fnd_file.put_line(fnd_file.log, 'Cr Inv Val @ sending org cost');
7999: CSTPACDP.distribute_accounts(
8000: org_id, trans_id,
8001: 0, cg_id , txn_act_id,
8002: item_id, p_qty, 1,

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

8016:
8017: /*----------------------------------------------------------------------+
8018: | Dr Intransit Acct @ org cost
8019: +----------------------------------------------------------------------*/
8020: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
8021: CSTPACDP.distribute_accounts(
8022: org_id, trans_id, 0, cg_id , txn_act_id,
8023: item_id, -1 * p_qty, 14, 0, 0,
8024: io_inv_acct, NULL, NULL, NULL, NULL,NULL,

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

8050: then
8051: mat_acct := user_acct_id;
8052: end if;
8053:
8054: fnd_file.put_line(fnd_file.log, 'Cr Inv Val');
8055: CSTPACDP.insert_account
8056: (org_id, trans_id, item_id, 0,
8057: p_qty, mat_acct, sob_id, 1, NULL, NULL,
8058: txn_date, txn_src_id, src_type_id,

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

8080: then
8081: io_inv_acct := user_acct_id;
8082: end if;
8083:
8084: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct');
8085: CSTPACDP.insert_account
8086: (org_id, trans_id, item_id, 0,
8087: -1 * p_qty, io_inv_acct, sob_id, 14, NULL, NULL,
8088: txn_date, txn_src_id, src_type_id,

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

8110:
8111: /*----------------------------------------------------------------------+
8112: | Cr Exp Acct
8113: +----------------------------------------------------------------------*/
8114: fnd_file.put_line(fnd_file.log, 'Cr Exp Acct');
8115: CSTPACDP.distribute_accounts(
8116: org_id, trans_id, 0, cg_id , txn_act_id,
8117: item_id, p_qty, 2, 0, 0,
8118: exp_acct, NULL, NULL, NULL, NULL, NULL,

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

8128:
8129: /*----------------------------------------------------------------------+
8130: | Dr Intransit Acct @ org cost
8131: +----------------------------------------------------------------------*/
8132: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
8133: CSTPACDP.distribute_accounts(
8134: org_id, trans_id,
8135: 0, cg_id , txn_act_id,
8136: item_id, -1 * p_qty, 14,

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

8185: * Dr. Exp Acct @ Transfer Price
8186: * Cr InterOrg Payables with Transfer Price
8187: */
8188:
8189: fnd_file.put_line(fnd_file.log, 'processing direct interorg receiving txn.');
8190:
8191:
8192: /*----------------------------------------------------------------------+
8193: | Cr receiving org payable @ transfer price

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

8210: then
8211: io_pay_acct := user_acct_id;
8212: end if;
8213:
8214: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
8215: CSTPACDP.insert_account
8216: (org_id, trans_id, item_id, -1 * payamt,
8217: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
8218: txn_date, txn_src_id, src_type_id,

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

8250:
8251: /*----------------------------------------------------------------------+
8252: | Dr Exp Acct
8253: +----------------------------------------------------------------------*/
8254: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8255: CSTPACDP.insert_account
8256: (org_id, trans_id, item_id, interorg_xfr_price * p_qty,
8257: p_qty, exp_acct, sob_id, 2, NULL, NULL,
8258: txn_date, txn_src_id, src_type_id,

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

8275:
8276: /*----------------------------------------------------------------------+
8277: | Dr Inv. Val @ org cost
8278: +----------------------------------------------------------------------*/
8279: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8280: CSTPACDP.distribute_accounts(
8281: org_id, trans_id,
8282: 0, cg_id , txn_act_id,
8283: item_id, p_qty, 1,

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

8303:
8304: /*----------------------------------------------------------------------+
8305: | Booking Overhead Acct
8306: +----------------------------------------------------------------------*/
8307: fnd_file.put_line(fnd_file.log, 'Booking Overhead Acct');
8308: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
8309: -1 * p_qty, sob_id,
8310: txn_date, txn_src_id, src_type_id, subinv,
8311: snd_rcv, pri_curr,

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

8350: then
8351: io_ppv_acct := user_acct_id;
8352: end if;
8353:
8354: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
8355: CSTPACDP.insert_account
8356: (org_id, trans_id, item_id, ppv_amt,
8357: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
8358: txn_date, txn_src_id, src_type_id,

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

8418: then
8419: exp_acct := user_acct_id;
8420: end if;
8421:
8422: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8423: CSTPACDP.distribute_accounts(
8424: org_id, trans_id,
8425: 0, cg_id , txn_act_id,
8426: item_id, p_qty, 2,

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

8446:
8447: /*----------------------------------------------------------------------+
8448: | Dr Inv. Val @ org cost
8449: +----------------------------------------------------------------------*/
8450: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8451: CSTPACDP.distribute_accounts(
8452: org_id, trans_id,
8453: 0, cg_id , txn_act_id,
8454: item_id, p_qty, 1,

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

8487:
8488: /*----------------------------------------------------------------------+
8489: | Cr Intransit Acct @ org cost
8490: +----------------------------------------------------------------------*/
8491: fnd_file.put_line(fnd_file.log, 'Cr Intransit Acct @ org cost');
8492: CSTPACDP.distribute_accounts(
8493: org_id, trans_id,
8494: 0, cg_id , txn_act_id,
8495: item_id, -1 * p_qty, 14,

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

8534: then
8535: io_pay_acct := user_acct_id;
8536: end if;
8537:
8538: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
8539: CSTPACDP.insert_account
8540: (org_id, trans_id, item_id, payamt,
8541: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
8542: txn_date, txn_src_id, src_type_id,

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

8561: l_stmt_num := 931;
8562: /*----------------------------------------------------------------------+
8563: | Dr Inv. Val @ org cost
8564: +----------------------------------------------------------------------*/
8565: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8566: CSTPACDP.distribute_accounts(
8567: org_id, trans_id,
8568: 0, cg_id , txn_act_id,
8569: item_id, p_qty, 1,

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

8586: +----------------------------------------------------------------------*/
8587: IF (txn_act_id <> 17) AND -- Bug 5349860
8588: (exp_flg = 0) AND (exp_sub = 0) AND (l_earn_moh <> 0)
8589: THEN
8590: fnd_file.put_line(fnd_file.log, 'Booking Overhead Acct');
8591: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
8592: -1 * p_qty, sob_id,
8593: txn_date, txn_src_id, src_type_id, subinv,
8594: snd_rcv, pri_curr,

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

8632: then
8633: io_ppv_acct := user_acct_id;
8634: end if;
8635:
8636: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
8637: CSTPACDP.insert_account
8638: (org_id, trans_id, item_id, ppv_amt,
8639: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
8640: txn_date, txn_src_id, src_type_id,

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

8669: then
8670: exp_acct := user_acct_id;
8671: end if;
8672:
8673: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8674: CSTPACDP.insert_account
8675: (org_id, trans_id, item_id, -1 * payamt,
8676: p_qty, exp_acct, sob_id, 2, NULL, NULL,
8677: txn_date, txn_src_id, src_type_id,

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

8761: then
8762: io_inv_acct := user_acct_id;
8763: end if;
8764:
8765: fnd_file.put_line(fnd_file.log, 'Cr Intransit Acct @ org cost');
8766: CSTPACDP.distribute_accounts(
8767: org_id, trans_id,
8768: 0, cg_id , txn_act_id,
8769: item_id, -1 * p_qty, 14,

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

8797: then
8798: trp_acct := user_acct_id;
8799: end if;
8800:
8801: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
8802: CSTPACDP.insert_account
8803: (org_id, trans_id, item_id, -1 * trp_cost,
8804: p_qty, trp_acct, sob_id, 12, NULL, NULL,
8805: txn_date, txn_src_id, src_type_id,

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

8831: io_rec_acct := user_acct_id;
8832: end if;
8833:
8834:
8835: fnd_file.put_line(fnd_file.log, 'Dr Receivalbes with ' || (interorg_xfr_price * p_qty) || ' ' || pri_curr);
8836: CSTPACDP.insert_account
8837: (org_id, trans_id, item_id, interorg_xfr_price * p_qty,
8838: p_qty, io_rec_acct, sob_id, 10, NULL, NULL,
8839: txn_date, txn_src_id, src_type_id,

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

8858: and (txn_act_id = 21) -- Bug 5351724
8859: and (iexp_flg = 0) -- Bug 5348953: No IC Invoicing for expense items
8860: then
8861: NULL;
8862: fnd_file.put_line(fnd_file.log, 'No need to book InterOrg Profit since InterCompany Invoicing ' ||
8863: 'is enabled.');
8864: else
8865:
8866: -- interorg_profit := interorg_xfr_price - (item_cost + (trp_cost/p_qty));

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

8887: then
8888: interorg_profit_acct := user_acct_id;
8889: end if;
8890:
8891: fnd_file.put_line(fnd_file.log, 'Dr InterOrg Profit with ' || nvl(interorg_profit,0) || ' ' || pri_curr);
8892: CSTPACDP.insert_account
8893: (org_id, trans_id, item_id, -1 * interorg_profit, /* ANTHIYAG Bug#5459157 11-Aug-2006 */
8894: p_qty, interorg_profit_acct, sob_id,
8895: G_INTERORG_PROFIT_ACCT, NULL, NULL,

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

8955: then
8956: io_pay_acct := user_acct_id;
8957: end if;
8958:
8959: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
8960: CSTPACDP.insert_account
8961: (org_id, trans_id, item_id, payamt,
8962: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
8963: txn_date, txn_src_id, src_type_id,

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

8989: then
8990: trp_acct := user_acct_id;
8991: end if;
8992:
8993: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
8994: CSTPACDP.insert_account
8995: (org_id, trans_id, item_id, -1 * trp_cost,
8996: p_qty, trp_acct, sob_id, 12, NULL, NULL,
8997: txn_date, txn_src_id, src_type_id,

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

9025: then
9026: acv_acct := user_acct_id;
9027: end if;
9028:
9029: fnd_file.put_line(fnd_file.log, 'Cr variance account with ' || var_amt || ' ' || pri_curr);
9030: CSTPACDP.insert_account
9031: (org_id, trans_id, item_id, var_amt,
9032: p_qty, acv_acct, sob_id, 13, NULL, NULL,
9033: txn_date, txn_src_id, src_type_id,

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

9066: then
9067: exp_acct := user_acct_id;
9068: end if;
9069:
9070: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
9071: CSTPACDP.insert_account
9072: (org_id, trans_id, item_id, trp_cost,
9073: p_qty, exp_acct, sob_id, 2, NULL, NULL,
9074: txn_date, txn_src_id, src_type_id,

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

9102: then
9103: io_inv_acct := user_acct_id;
9104: end if;
9105:
9106: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
9107: CSTPACDP.distribute_accounts(
9108: org_id, trans_id,
9109: 0, cg_id , txn_act_id,
9110: item_id, p_qty, 14,

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

9125:
9126: /* receiving overhead absorption */
9127: /* Earn MOH only for asset subinventory */
9128:
9129: fnd_file.put_line(fnd_file.log, '-- Booking Overhead Acct: exp_flg/exp_sub: ' || exp_flg ||'/'||exp_sub ||
9130: ' bookMOH Obsorption?: ' || l_earn_moh);
9131:
9132: if (exp_flg = 0) AND (exp_sub = 0) AND (l_earn_moh <> 0)
9133: then

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

9134:
9135: /*----------------------------------------------------------------------+
9136: | Booking Overhead Acct
9137: +----------------------------------------------------------------------*/
9138: fnd_file.put_line(fnd_file.log, '-- Booking Overhead Acct');
9139: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
9140: -1 * p_qty, sob_id,
9141: txn_date, txn_src_id, src_type_id, subinv,
9142: snd_rcv, pri_curr,

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

9181: then
9182: io_ppv_acct := user_acct_id;
9183: end if;
9184:
9185: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
9186: CSTPACDP.insert_account
9187: (org_id, trans_id, item_id, ppv_amt,
9188: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
9189: txn_date, txn_src_id, src_type_id,

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

9224: then
9225: enc_acct := user_acct_id;
9226: end if;
9227:
9228: fnd_file.put_line(fnd_file.log, 'Cr Enc Acct with ' || enc_amt || ' ' || pri_curr);
9229: CSTPACDP.insert_account
9230: (org_id, trans_id, item_id, -1*enc_amt,
9231: p_qty, enc_acct, sob_id, 15, NULL, NULL,
9232: txn_date, txn_src_id, src_type_id,

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

9255: (txn_act_id = 22 AND src_type_id = 8))
9256: AND tprice_option <> 0 )
9257: then
9258: -- {
9259: fnd_file.put_line(FND_FILE.LOG, 'Start calling CST_TPRICE_PVT.Adjust_Acct');
9260:
9261: CST_TPRICE_PVT.Adjust_Acct(1.0, p_tprice_option => tprice_option,
9262: p_txf_price => txf_price, p_txn_id => trans_id,
9263: p_cost_grp_id => cg_id, p_txf_cost_grp => txf_cg_id,

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

9282: added code to call balance account to adjust any rounding errors */
9283:
9284: l_stmt_num := 942;
9285:
9286: fnd_file.put_line(fnd_file.log, 'Balancing Accounts');
9287: CSTPACDP.balance_account(org_id, trans_id, O_Error_Num, O_Error_Code, O_Error_Message);
9288:
9289: if O_Error_Num <> 0
9290: then

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

9305:
9306: /* Change for AX team
9307: Begin
9308: */
9309: -- fnd_file.put_line(fnd_file.log, '[AX]FINAL');
9310: -- fnd_file.put_line(fnd_file.log, '===================================================');
9311:
9312: uom_conv_rate := 1;
9313:

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

9306: /* Change for AX team
9307: Begin
9308: */
9309: -- fnd_file.put_line(fnd_file.log, '[AX]FINAL');
9310: -- fnd_file.put_line(fnd_file.log, '===================================================');
9311:
9312: uom_conv_rate := 1;
9313:
9314: l_stmt_num := 951;

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

9316: act_cost := item_cost;
9317:
9318: end if;
9319:
9320: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9321: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9322: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9323: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9324: -- fnd_file.put_line(fnd_file.log, '===================================================');

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

9317:
9318: end if;
9319:
9320: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9321: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9322: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9323: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9324: -- fnd_file.put_line(fnd_file.log, '===================================================');
9325:

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

9318: end if;
9319:
9320: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9321: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9322: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9323: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9324: -- fnd_file.put_line(fnd_file.log, '===================================================');
9325:
9326: if (txn_act_id = 3 OR txn_act_id = 21 )

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

9319:
9320: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9321: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9322: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9323: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9324: -- fnd_file.put_line(fnd_file.log, '===================================================');
9325:
9326: if (txn_act_id = 3 OR txn_act_id = 21 )
9327: then

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

9320: -- fnd_file.put_line(fnd_file.log, '[AX]item_id = %ld', (long)item_id);
9321: -- fnd_file.put_line(fnd_file.log, '[AX]send_uom = %s', send_uom.arr);
9322: -- fnd_file.put_line(fnd_file.log, '[AX]rec_uom = %s', rec_uom.arr);
9323: -- fnd_file.put_line(fnd_file.log, '[AX]Actual Cost = %6.2f', (float)act_cost);
9324: -- fnd_file.put_line(fnd_file.log, '===================================================');
9325:
9326: if (txn_act_id = 3 OR txn_act_id = 21 )
9327: then
9328: -- {

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

9327: then
9328: -- {
9329:
9330: l_stmt_num := 952;
9331: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9332: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9333: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9334: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9335:

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

9328: -- {
9329:
9330: l_stmt_num := 952;
9331: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9332: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9333: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9334: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9335:
9336: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');

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

9329:
9330: l_stmt_num := 952;
9331: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9332: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9333: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9334: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9335:
9336: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9337: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);

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

9330: l_stmt_num := 952;
9331: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9332: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9333: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9334: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9335:
9336: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9337: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9338: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);

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

9332: -- fnd_file.put_line(fnd_file.log, '[AX]Transafer Cost = %6.2f', (float)txf_cost);
9333: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9334: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9335:
9336: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9337: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9338: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9339:
9340: /* commented for bug 2865814 -- these messages raise signal 8 error.

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

9333: -- fnd_file.put_line(fnd_file.log, '[AX]Transport Cost = %6.2f', (float)trp_cost);
9334: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9335:
9336: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9337: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9338: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9339:
9340: /* commented for bug 2865814 -- these messages raise signal 8 error.
9341: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');

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

9334: -- fnd_file.put_line(fnd_file.log, '[AX]Primary Qty = %6.2f', (float)p_qty);
9335:
9336: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9337: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9338: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9339:
9340: /* commented for bug 2865814 -- these messages raise signal 8 error.
9341: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9342: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',

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

9337: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9338: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9339:
9340: /* commented for bug 2865814 -- these messages raise signal 8 error.
9341: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9342: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',
9343: (float)(((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty)));
9344: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(recving record)]The Rcv Txn cost shld be = %6.2f',
9345: (float)(((((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty))*conv_rate)/(uom_conv_rate)));

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

9338: -- fnd_file.put_line(fnd_file.log, '[AX in f]UOM conv rate = %6.2f', (float)uom_conv_rate);
9339:
9340: /* commented for bug 2865814 -- these messages raise signal 8 error.
9341: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9342: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',
9343: (float)(((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty)));
9344: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(recving record)]The Rcv Txn cost shld be = %6.2f',
9345: (float)(((((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty))*conv_rate)/(uom_conv_rate)));
9346: */

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

9340: /* commented for bug 2865814 -- these messages raise signal 8 error.
9341: -- fnd_file.put_line(fnd_file.log, '---------------------------------------------------');
9342: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(sending record)]The Txn cost shld be = %6.2f',
9343: (float)(((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty)));
9344: -- fnd_file.put_line(fnd_file.log, '[AXcstavcpb-formula(recving record)]The Rcv Txn cost shld be = %6.2f',
9345: (float)(((((act_cost*abs(p_qty))+txf_cost+trp_cost)/abs(p_qty))*conv_rate)/(uom_conv_rate)));
9346: */
9347: -- }
9348: else

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

9351: then
9352: -- {
9353: l_stmt_num := 953;
9354:
9355: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);
9356: -- fnd_file.put_line(fnd_file.log, '[AX*]Rcvg Transaction Cost = %6.2f', (float)txn_cost*conv_rate);
9357: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9358: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);
9359: -- }

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

9352: -- {
9353: l_stmt_num := 953;
9354:
9355: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);
9356: -- fnd_file.put_line(fnd_file.log, '[AX*]Rcvg Transaction Cost = %6.2f', (float)txn_cost*conv_rate);
9357: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9358: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);
9359: -- }
9360: end if;

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

9353: l_stmt_num := 953;
9354:
9355: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);
9356: -- fnd_file.put_line(fnd_file.log, '[AX*]Rcvg Transaction Cost = %6.2f', (float)txn_cost*conv_rate);
9357: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9358: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);
9359: -- }
9360: end if;
9361: -- }

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

9354:
9355: -- fnd_file.put_line(fnd_file.log, '[AX]Sendg Transaction Cost = %6.2f', (float)txn_cost);
9356: -- fnd_file.put_line(fnd_file.log, '[AX*]Rcvg Transaction Cost = %6.2f', (float)txn_cost*conv_rate);
9357: -- fnd_file.put_line(fnd_file.log, '[AX]Curr conv rate = %6.2f', (float)conv_rate);
9358: -- fnd_file.put_line(fnd_file.log, '[AX]UOM conv rate = %6.2f', (float)uom_conv_rate);
9359: -- }
9360: end if;
9361: -- }
9362: end if;

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

9429:
9430:
9431: COMMIT;
9432:
9433: fnd_file.put_line(fnd_file.log, 'cost_process_discrete_trx >>>');
9434:
9435: EXCEPTION
9436: when moh_rules_error then
9437: rollback;

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

9442: o_error_message := FND_MESSAGE.Get;
9443:
9444: when errexit
9445: then
9446: fnd_file.put_line(fnd_file.log,'in errexit exception');
9447: ROLLBACK;
9448:
9449: O_Error_Num := NVL(O_Error_Num, -1);
9450: O_Error_Message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || l_stmt_num || '):' ||

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

9479: commit;
9480:
9481: when others
9482: then
9483: fnd_file.put_line(fnd_file.log,'other exception raised');
9484: rollback;
9485:
9486: O_error_num := SQLCODE;
9487: O_error_code := SQLCODE;

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

9520: l_debug VARCHAR2(1);
9521: BEGIN
9522:
9523: IF G_DEBUG = 'Y' THEN
9524: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');
9525: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);
9526: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);
9527: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);
9528: END IF;

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

9521: BEGIN
9522:
9523: IF G_DEBUG = 'Y' THEN
9524: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');
9525: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);
9526: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);
9527: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);
9528: END IF;
9529:

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

9522:
9523: IF G_DEBUG = 'Y' THEN
9524: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');
9525: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);
9526: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);
9527: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);
9528: END IF;
9529:
9530: IF (i_txn_type_id <> 16) OR (i_txn_type_id IS NULL) THEN

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

9523: IF G_DEBUG = 'Y' THEN
9524: fnd_file.put_line(fnd_file.log,'balance_account_txn_type +');
9525: fnd_file.put_line(fnd_file.log,' i_txn_type_id:'||i_txn_type_id);
9526: fnd_file.put_line(fnd_file.log,' i_txn_id :'||i_txn_id);
9527: fnd_file.put_line(fnd_file.log,' i_org_id :'||i_org_id);
9528: END IF;
9529:
9530: IF (i_txn_type_id <> 16) OR (i_txn_type_id IS NULL) THEN
9531:

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

9529:
9530: IF (i_txn_type_id <> 16) OR (i_txn_type_id IS NULL) THEN
9531:
9532: IF G_DEBUG = 'Y' THEN
9533: fnd_file.put_line(fnd_file.log,'Calling balance_account');
9534: END IF;
9535:
9536: balance_account(
9537: I_ORG_ID => i_org_id,

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

9542:
9543: ELSE
9544:
9545: IF G_DEBUG = 'Y' THEN
9546: fnd_file.put_line(fnd_file.log,' Case Logical RMA');
9547: END IF;
9548:
9549:
9550: l_stmt_num := 10;

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

9665: RETURN;
9666: END IF;
9667:
9668: IF G_DEBUG = 'Y' THEN
9669: fnd_file.put_line(fnd_file.log, 'Sum of base amount: '||l_base_value);
9670: fnd_file.put_line(fnd_file.log, 'Sum of transaction amount: '||l_value);
9671: END IF;
9672:
9673: l_stmt_num := 20;

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

9666: END IF;
9667:
9668: IF G_DEBUG = 'Y' THEN
9669: fnd_file.put_line(fnd_file.log, 'Sum of base amount: '||l_base_value);
9670: fnd_file.put_line(fnd_file.log, 'Sum of transaction amount: '||l_value);
9671: END IF;
9672:
9673: l_stmt_num := 20;
9674:

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

9672:
9673: l_stmt_num := 20;
9674:
9675: IF G_DEBUG = 'Y' THEN
9676: fnd_file.put_line(fnd_file.log, 'Creating the difference in adjustment account');
9677: END IF;
9678:
9679:
9680: l_mta_rec.accounting_line_type := 37;

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

9782: FROM DUAL;
9783:
9784: END IF;
9785: IF G_DEBUG = 'Y' THEN
9786: fnd_file.put_line(fnd_file.log,'balance_account_txn_type -');
9787: END IF;
9788: EXCEPTION
9789:
9790: WHEN OTHERS then