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

Line 142: FND_FILE.PUT_LINE(FND_FILE.LOG,'cost_logical_itr_receipt(): interorg_rec: ' || to_char(l_interorg_rec));

138: l_err_code,
139: l_err_msg);
140:
141: IF g_debug = 'Y' THEN
142: FND_FILE.PUT_LINE(FND_FILE.LOG,'cost_logical_itr_receipt(): interorg_rec: ' || to_char(l_interorg_rec));
143: END IF;
144:
145: if (l_err_num <> 0) then
146: raise process_error;

Line 191: FND_FILE.PUT_LINE(FND_FILE.LOG,'interorg(): interorg_rec: ' || to_char(l_interorg_rec));

187: l_err_num,
188: l_err_code,
189: l_err_msg);
190: IF g_debug = 'Y' THEN
191: FND_FILE.PUT_LINE(FND_FILE.LOG,'interorg(): interorg_rec: ' || to_char(l_interorg_rec));
192: END IF;
193: if (l_err_num <> 0) then
194: raise process_error;
195: end if;

Line 1124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Standard costing org : ' || to_char(l_std_org));

1120: l_std_to_org := 0;
1121: end if;
1122:
1123:
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Standard costing org : ' || to_char(l_std_org));
1125:
1126: if(l_debug = 'Y') then
1127: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1128: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);

Line 1127: fnd_file.put_line(fnd_file.log, 'In interorg(..)');

1123:
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Standard costing org : ' || to_char(l_std_org));
1125:
1126: if(l_debug = 'Y') then
1127: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1128: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1129: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1130: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1131: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);

Line 1128: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);

1124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Standard costing org : ' || to_char(l_std_org));
1125:
1126: if(l_debug = 'Y') then
1127: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1128: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1129: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1130: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1131: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);
1132: end if;

Line 1129: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);

1125:
1126: if(l_debug = 'Y') then
1127: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1128: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1129: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1130: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1131: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);
1132: end if;
1133:

Line 1130: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);

1126: if(l_debug = 'Y') then
1127: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1128: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1129: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1130: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1131: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);
1132: end if;
1133:
1134: /* bug 3048258: For std costing, item cost from cost organization should be used */

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

1127: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1128: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1129: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1130: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1131: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);
1132: end if;
1133:
1134: /* bug 3048258: For std costing, item cost from cost organization should be used */
1135: l_stmt_num := 15;

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');

1293: and cost_group_id = l_to_cost_grp;
1294: end if;
1295:
1296:
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1299:
1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));

Line 1298: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);

1294: end if;
1295:
1296:
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1299:
1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
1302: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));

Line 1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');

1296:
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1299:
1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
1302: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
1303:
1304: /* Bug #2352604, 2362306.

Line 1301: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));

1297: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1299:
1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
1302: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
1303:
1304: /* Bug #2352604, 2362306.
1305: Call create_layers when :

Line 1302: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));

1298: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1299:
1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
1302: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
1303:
1304: /* Bug #2352604, 2362306.
1305: Call create_layers when :
1306: Direct Interorg transfers

Line 1347: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');

1343: and inventory_item_id = i_item_id
1344: and cost_group_id = l_from_cost_grp;
1345: end if;
1346:
1347: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
1350: if (l_from_method IN (5,6)) then
1351: CSTPLENG.consume_layers(

Line 1348: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));

1344: and cost_group_id = l_from_cost_grp;
1345: end if;
1346:
1347: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
1350: if (l_from_method IN (5,6)) then
1351: CSTPLENG.consume_layers(
1352: i_org_id,

Line 1349: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));

1345: end if;
1346:
1347: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
1350: if (l_from_method IN (5,6)) then
1351: CSTPLENG.consume_layers(
1352: i_org_id,
1353: i_txn_id,

Line 1413: fnd_file.put_line(fnd_file.log, 'item is expense in receiving std org');

1409: where inventory_item_id = i_item_id
1410: and organization_id = l_std_org;
1411: end if;
1412: if (l_to_std_exp = 1) then
1413: fnd_file.put_line(fnd_file.log, 'item is expense in receiving std org');
1414: elsif
1415: /* end for bug 3671538 */
1416: ((l_std_exp <> 1) or (l_std_from_org = 1) or
1417: (l_std_to_org = 1 and i_txn_action_id = 12 and i_fob_point = 1))

Line 1438: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for std org using cost from CICD');

1434: l_stmt_num := 70;
1435: /* If no rows exist in cicd (item hasn't been costed), insert into */
1436: /* mcacd using 0 value of this level material */
1437: if (l_count > 0) then
1438: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for std org using cost from CICD');
1439: insert into mtl_cst_actual_cost_details (
1440: transaction_id,
1441: organization_id,
1442: layer_id,

Line 1491: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for std org using 0 cost');

1487: and cost_type_id = 1
1488: and inventory_item_id = i_item_id
1489: group by cost_element_id, level_type;
1490: else
1491: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for std org using 0 cost');
1492: insert into mtl_cst_actual_cost_details (
1493: transaction_id,
1494: organization_id,
1495: layer_id,

Line 1564: FND_FILE.put_line(fnd_file.log, '--Material Overhead Absorption Overridden--');

1560: RAISE moh_rules_error;
1561: END IF;
1562:
1563: if (l_earn_moh = 0 ) then
1564: FND_FILE.put_line(fnd_file.log, '--Material Overhead Absorption Overridden--');
1565: else
1566:
1567: Insert into mtl_actual_cost_subelement(
1568: layer_id,

Line 1881: FND_FILE.PUT_LINE(FND_FILE.LOG,'Creating layers when sending org is std costing org');

1877: Intransit receipt, FOB receipt from std to LIFO
1878: */
1879:
1880: if(o_interorg_rec=1 and i_txn_action_id <> 3) then
1881: FND_FILE.PUT_LINE(FND_FILE.LOG,'Creating layers when sending org is std costing org');
1882:
1883: -- Fix for bug 1872444
1884: -- Populate l_to_layer before calling CSTPLENG.create_layers
1885: -- for direct interorg transactions

Line 1896: fnd_file.put_line(fnd_file.log, 'Calling createlayers for the std org' || i_org_id || ': interorg rec : '|| o_interorg_rec || ':txn_update_id :'|| l_txn_update_id );

1892: and cost_group_id = l_to_cost_grp;
1893: end if;
1894:
1895: if(l_debug = 'Y') then
1896: fnd_file.put_line(fnd_file.log, 'Calling createlayers for the std org' || i_org_id || ': interorg rec : '|| o_interorg_rec || ':txn_update_id :'|| l_txn_update_id );
1897: end if;
1898:
1899:
1900: CSTPLENG.create_layers(

Line 2074: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' insert into MCACD from MCTCD with l_txfr_std_exp = 1');

2070: and msi.secondary_inventory_name = mmt.subinventory_code;
2071:
2072: if (l_txfr_std_exp = 1) then
2073: l_stmt_num := 260;
2074: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' insert into MCACD from MCTCD with l_txfr_std_exp = 1');
2075: insert into mtl_cst_actual_cost_details (
2076: transaction_id,
2077: organization_id,
2078: layer_id,

Line 2126: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' update MMT from MCACD with l_txfr_std_exp = 1');

2122: WHERE ctcd.transaction_id = l_txn_update_id
2123: AND ctcd.organization_id = l_std_org
2124: /* AND ctcd.transaction_cost >= 0 */; -- modified for bug #3835412
2125:
2126: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' update MMT from MCACD with l_txfr_std_exp = 1');
2127: update mtl_material_transactions mmt
2128: set (last_update_date,
2129: last_updated_by,
2130: last_update_login,

Line 2169: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' insert into MCACD from MCTCD with l_to_std_exp = 1');

2165: where mmt.transaction_id = i_txn_id;
2166: end if;
2167:
2168: l_stmt_num := 270;
2169: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' insert into MCACD from MCTCD with l_to_std_exp = 1');
2170: insert into mtl_cst_actual_cost_details (
2171: transaction_id,
2172: organization_id,
2173: layer_id,

Line 2223: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' update MMT from MCACD with l_to_std_exp = 1');

2219: /* AND ctcd.transaction_cost >= 0 */; -- modified for bug #3835412
2220:
2221: -- update mmt if this is the receiving transaction id
2222: if (i_txn_org_id = l_std_org) then
2223: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' update MMT from MCACD with l_to_std_exp = 1');
2224: update mtl_material_transactions mmt
2225: set (last_update_date,
2226: last_updated_by,
2227: last_update_login,

Line 3194: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)

3190: from cst_inv_layers
3191: where layer_id = l_from_layer;
3192:
3193: if l_debug = 'Y' then
3194: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)
3195: ||',layer change: '|| to_char(l_layer_chg));
3196: FND_FILE.PUT_LINE(FND_FILE.LOG,'From layer: '|| to_char(l_from_layer)
3197: || 'From qty: '|| to_char(l_from_qty));
3198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To layer: '|| to_char(l_to_layer)

Line 3196: FND_FILE.PUT_LINE(FND_FILE.LOG,'From layer: '|| to_char(l_from_layer)

3192:
3193: if l_debug = 'Y' then
3194: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)
3195: ||',layer change: '|| to_char(l_layer_chg));
3196: FND_FILE.PUT_LINE(FND_FILE.LOG,'From layer: '|| to_char(l_from_layer)
3197: || 'From qty: '|| to_char(l_from_qty));
3198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To layer: '|| to_char(l_to_layer)
3199: || 'To qty: '|| to_char(l_to_qty));
3200: end if;

Line 3198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To layer: '|| to_char(l_to_layer)

3194: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)
3195: ||',layer change: '|| to_char(l_layer_chg));
3196: FND_FILE.PUT_LINE(FND_FILE.LOG,'From layer: '|| to_char(l_from_layer)
3197: || 'From qty: '|| to_char(l_from_qty));
3198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To layer: '|| to_char(l_to_layer)
3199: || 'To qty: '|| to_char(l_to_qty));
3200: end if;
3201:
3202: /************************************************************

Line 3328: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCACD inserted for trxn '

3324: and inv_layer_id = l_inv_layer_id;
3325: end if; --- i checking layer cost and inserting MCACD
3326:
3327: if l_debug = 'Y' then
3328: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCACD inserted for trxn '
3329: || to_char(i_txn_id)
3330: || ':' || to_char(l_stmt_num));
3331: end if;
3332:

Line 3427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory layer created');

3423: i_prg_id,
3424: sysdate);
3425:
3426: IF (l_debug = 'Y') THEN
3427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory layer created');
3428: END IF;
3429:
3430: /* Delete cost details for the inventory layer from CILCD.
3431: No rows should be present. Just a safety check

Line 3502: FND_FILE.PUT_LINE(FND_FILE.LOG,'Compute_layer_actual_cost completed for txn '

3498: raise process_error;
3499: end if;
3500:
3501: if l_debug = 'Y' then
3502: FND_FILE.PUT_LINE(FND_FILE.LOG,'Compute_layer_actual_cost completed for txn '
3503: || to_char(i_txn_id)
3504: || ':' || to_char(l_stmt_num));
3505: end if;
3506: /* Borrow Payback Enhancement Bug#2325290 */

Line 3510: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling payback_variance() ');

3506: /* Borrow Payback Enhancement Bug#2325290 */
3507: if (l_txn_type_id = 68) and (l_layer_chg = 0) then
3508:
3509: if l_debug = 'Y' then
3510: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling payback_variance() ');
3511: end if;
3512:
3513: payback_variance(
3514: i_org_id,

Line 3583: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calc_layer_average_cost completed for txn '

3579: raise process_error;
3580: end if;
3581:
3582: if l_debug = 'Y' then
3583: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calc_layer_average_cost completed for txn '
3584: || to_char(i_txn_id)
3585: || ':' || to_char(l_stmt_num));
3586: end if;
3587: end if; -- end from asset sub

Line 3670: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '

3666: and organization_id = i_org_id
3667: and layer_id = l_from_layer;
3668:
3669: if l_debug = 'Y' then
3670: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '
3671: || to_char(i_txn_id)
3672: || ',to layer '|| to_char(l_from_layer)
3673: || ',stmt ' || to_char(l_stmt_num));
3674: end if;

Line 3731: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '

3727: and organization_id = i_org_id
3728: and layer_id = l_from_layer;
3729:
3730: if l_debug = 'Y' then
3731: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '
3732: || to_char(i_txn_id)
3733: || ',to layer '|| to_char(l_from_layer)
3734: || ',stmt ' || to_char(l_stmt_num));
3735: end if;

Line 3772: FND_FILE.PUT_LINE(FND_FILE.LOG,'created_layer called for txn '

3768: raise process_error;
3769: end if;
3770:
3771: if l_debug = 'Y' then
3772: FND_FILE.PUT_LINE(FND_FILE.LOG,'created_layer called for txn '
3773: || to_char(i_txn_id)
3774: || ',to layer '|| to_char(l_to_layer)
3775: || ',stmt ' || to_char(l_stmt_num));
3776: end if;

Line 3804: FND_FILE.PUT_LINE(FND_FILE.LOG,'calc_layer_avg_cost called for txn '

3800: raise process_error;
3801: end if;
3802:
3803: if l_debug = 'Y' then
3804: FND_FILE.PUT_LINE(FND_FILE.LOG,'calc_layer_avg_cost called for txn '
3805: || to_char(i_txn_id)
3806: || ',to layer '|| to_char(l_to_layer)
3807: || ',stmt ' || to_char(l_stmt_num));
3808: end if;

Line 3893: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '

3889: and inv_layer_id = l_inv_layer_id;
3890: end if; -- end checking for layer cost
3891:
3892: if l_debug = 'Y' then
3893: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '
3894: || to_char(i_txn_id)
3895: || ',to layer '|| to_char(l_to_layer)
3896: || ',stmt ' || to_char(l_stmt_num));
3897: end if;

Line 3933: FND_FILE.PUT_LINE(FND_FILE.LOG,'created_layer called for txn '

3929: raise process_error;
3930: end if;
3931:
3932: if l_debug = 'Y' then
3933: FND_FILE.PUT_LINE(FND_FILE.LOG,'created_layer called for txn '
3934: || to_char(i_txn_id)
3935: || ',to layer '|| to_char(l_to_layer)
3936: || ',stmt ' || to_char(l_stmt_num));
3937: end if;

Line 3965: FND_FILE.PUT_LINE(FND_FILE.LOG,'calc_layer_avg_cost called for txn '

3961: raise process_error;
3962: end if;
3963:
3964: if l_debug = 'Y' then
3965: FND_FILE.PUT_LINE(FND_FILE.LOG,'calc_layer_avg_cost called for txn '
3966: || to_char(i_txn_id)
3967: || ',to layer '|| to_char(l_to_layer)
3968: || ',stmt ' || to_char(l_stmt_num));
3969: end if;

Line 4174: fnd_file.put_line(fnd_file.log, 'borrow quantity' || l_total_borrow_qty);

4170:
4171: l_total_borrow_qty := l_total_borrow_qty + abs(l_loan_quantity);
4172: end loop; -- end looping c_payback_rec
4173:
4174: fnd_file.put_line(fnd_file.log, 'borrow quantity' || l_total_borrow_qty);
4175:
4176: l_stmt_num := 30;
4177: /* Figure out the payback cost */
4178: for c_mclacd_rec in c_mclacd_data(i_txn_id) LOOP

Line 4372: fnd_file.put_line(fnd_file.log, l_procedure_name || ' <<<');

4368: l_snd_qty := o_txn_qty;
4369: l_std_exp := 0;
4370:
4371: IF g_debug = 'Y' THEN
4372: fnd_file.put_line(fnd_file.log, l_procedure_name || ' <<<');
4373: END IF;
4374:
4375: l_earn_moh := 1;
4376: l_return_status := fnd_api.g_ret_sts_success;

Line 4532: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);

4528: o_interorg_rec := 0;
4529: end if;
4530:
4531: IF g_debug = 'Y' THEN
4532: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4533: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4534: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4535: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4536: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||

Line 4533: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);

4529: end if;
4530:
4531: IF g_debug = 'Y' THEN
4532: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4533: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4534: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4535: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4536: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4537: ' Transfer Price: ' || i_txf_price ||

Line 4534: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);

4530:
4531: IF g_debug = 'Y' THEN
4532: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4533: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4534: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4535: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4536: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4537: ' Transfer Price: ' || i_txf_price ||
4538: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);

Line 4535: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);

4531: IF g_debug = 'Y' THEN
4532: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4533: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4534: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4535: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4536: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4537: ' Transfer Price: ' || i_txf_price ||
4538: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);
4539: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);

Line 4536: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||

4532: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4533: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4534: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4535: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4536: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4537: ' Transfer Price: ' || i_txf_price ||
4538: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);
4539: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);
4540: fnd_file.put_line(fnd_file.log, 'o_interorg_rec: ' || o_interorg_rec);

Line 4539: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);

4535: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4536: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4537: ' Transfer Price: ' || i_txf_price ||
4538: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);
4539: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);
4540: fnd_file.put_line(fnd_file.log, 'o_interorg_rec: ' || o_interorg_rec);
4541: END IF;
4542:
4543:

Line 4540: fnd_file.put_line(fnd_file.log, 'o_interorg_rec: ' || o_interorg_rec);

4536: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4537: ' Transfer Price: ' || i_txf_price ||
4538: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);
4539: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);
4540: fnd_file.put_line(fnd_file.log, 'o_interorg_rec: ' || o_interorg_rec);
4541: END IF;
4542:
4543:
4544: if ((i_txn_action_id in (21,22)) OR

Line 4560: fnd_file.put_line(fnd_file.log, 'Updating trx: ' || i_txn_id || ' with trxCost: ' || l_rcv_txn_cost);

4556: and cost_group_id = l_from_cost_grp;
4557: end if;
4558:
4559: IF g_debug = 'Y' THEN
4560: fnd_file.put_line(fnd_file.log, 'Updating trx: ' || i_txn_id || ' with trxCost: ' || l_rcv_txn_cost);
4561: END IF;
4562:
4563: l_stmt_num := 50;
4564: Update mtl_material_transactions

Line 4570: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interorg transfer send org: (consume layers) ...');

4566: where transaction_id = i_txn_id;
4567:
4568:
4569: IF g_debug = 'Y' THEN
4570: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interorg transfer send org: (consume layers) ...');
4571: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
4572: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
4573: END IF;
4574:

Line 4571: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));

4567:
4568:
4569: IF g_debug = 'Y' THEN
4570: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interorg transfer send org: (consume layers) ...');
4571: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
4572: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
4573: END IF;
4574:
4575: --

Line 4572: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));

4568:
4569: IF g_debug = 'Y' THEN
4570: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interorg transfer send org: (consume layers) ...');
4571: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
4572: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
4573: END IF;
4574:
4575: --
4576: -- Bug 5222084: consume_layers layer should be called only for the following txns.

Line 4615: fnd_file.put_line(fnd_file.log, 'Updating trx: ' || i_txn_id || ' with trxCost: ' || l_rcv_txn_cost);

4611: elsif (i_txn_action_id = 12 AND i_fob_point = 1)
4612: then
4613:
4614: IF g_debug = 'Y' THEN
4615: fnd_file.put_line(fnd_file.log, 'Updating trx: ' || i_txn_id || ' with trxCost: ' || l_rcv_txn_cost);
4616: END IF;
4617:
4618: l_stmt_num := 70;
4619: Update mtl_material_transactions

Line 4629: fnd_file.put_line(fnd_file.log, 'inserting to MCTCD for txn: ' || i_txn_id || '. trxCost: ' || l_rcv_txn_cost);

4625: (i_txn_action_id = 12 AND i_fob_point = 2))
4626: then
4627:
4628: IF g_debug = 'Y' THEN
4629: fnd_file.put_line(fnd_file.log, 'inserting to MCTCD for txn: ' || i_txn_id || '. trxCost: ' || l_rcv_txn_cost);
4630: END IF;
4631:
4632: l_stmt_num := 80;
4633: insert into mtl_cst_txn_cost_details (

Line 4688: FND_FILE.PUT_LINE(FND_FILE.LOG, l_procedure_name || ': Interorg transfer receiving org: (create layers) ...');

4684: end if;
4685:
4686:
4687: IF g_debug = 'Y' THEN
4688: FND_FILE.PUT_LINE(FND_FILE.LOG, l_procedure_name || ': Interorg transfer receiving org: (create layers) ...');
4689: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
4690: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
4691: END IF;
4692:

Line 4689: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));

4685:
4686:
4687: IF g_debug = 'Y' THEN
4688: FND_FILE.PUT_LINE(FND_FILE.LOG, l_procedure_name || ': Interorg transfer receiving org: (create layers) ...');
4689: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
4690: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
4691: END IF;
4692:
4693: /* Call create_layers when :

Line 4690: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));

4686:
4687: IF g_debug = 'Y' THEN
4688: FND_FILE.PUT_LINE(FND_FILE.LOG, l_procedure_name || ': Interorg transfer receiving org: (create layers) ...');
4689: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
4690: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
4691: END IF;
4692:
4693: /* Call create_layers when :
4694: Direct Interorg transfers

Line 4731: fnd_file.put_line(fnd_file.log, l_procedure_name || ' >>>');

4727:
4728: END IF;
4729:
4730: IF g_debug = 'Y' THEN
4731: fnd_file.put_line(fnd_file.log, l_procedure_name || ' >>>');
4732: END IF;
4733:
4734: EXCEPTION
4735: when others then