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 1058: FND_FILE.PUT_LINE(FND_FILE.LOG,'Standard costing org : ' || to_char(l_std_org));

1054: l_std_to_org := 0;
1055: end if;
1056:
1057:
1058: FND_FILE.PUT_LINE(FND_FILE.LOG,'Standard costing org : ' || to_char(l_std_org));
1059:
1060: if(l_debug = 'Y') then
1061: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1062: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);

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

1057:
1058: FND_FILE.PUT_LINE(FND_FILE.LOG,'Standard costing org : ' || to_char(l_std_org));
1059:
1060: if(l_debug = 'Y') then
1061: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1062: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1063: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1064: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1065: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);

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

1058: FND_FILE.PUT_LINE(FND_FILE.LOG,'Standard costing org : ' || to_char(l_std_org));
1059:
1060: if(l_debug = 'Y') then
1061: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1062: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1063: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1064: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1065: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);
1066: end if;

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

1059:
1060: if(l_debug = 'Y') then
1061: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1062: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1063: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1064: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1065: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);
1066: end if;
1067:

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

1060: if(l_debug = 'Y') then
1061: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1062: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1063: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1064: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1065: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);
1066: end if;
1067:
1068: /* bug 3048258: For std costing, item cost from cost organization should be used */

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

1061: fnd_file.put_line(fnd_file.log, 'In interorg(..)');
1062: fnd_file.put_line(fnd_file.log, 'l_std_org' || l_std_org);
1063: fnd_file.put_line(fnd_file.log, 'l_std_from_org' || l_std_from_org);
1064: fnd_file.put_line(fnd_file.log, 'l_std_to_org' || l_std_to_org);
1065: fnd_file.put_line(fnd_file.log, 'i_fob_point' || i_fob_point);
1066: end if;
1067:
1068: /* bug 3048258: For std costing, item cost from cost organization should be used */
1069: l_stmt_num := 15;

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

1227: and cost_group_id = l_to_cost_grp;
1228: end if;
1229:
1230:
1231: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');
1232: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1233:
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1235: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));

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

1228: end if;
1229:
1230:
1231: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');
1232: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1233:
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1235: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
1236: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));

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

1230:
1231: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');
1232: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1233:
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1235: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
1236: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
1237:
1238: /* Bug #2352604, 2362306.

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

1231: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------l_to_method---------');
1232: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1233:
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1235: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
1236: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
1237:
1238: /* Bug #2352604, 2362306.
1239: Call create_layers when :

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

1232: FND_FILE.PUT_LINE(FND_FILE.LOG,'=' || l_to_method);
1233:
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer receiving org: (create layers) ...');
1235: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
1236: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
1237:
1238: /* Bug #2352604, 2362306.
1239: Call create_layers when :
1240: Direct Interorg transfers

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

1277: and inventory_item_id = i_item_id
1278: and cost_group_id = l_from_cost_grp;
1279: end if;
1280:
1281: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');
1282: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
1283: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
1284: if (l_from_method IN (5,6)) then
1285: CSTPLENG.consume_layers(

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

1278: and cost_group_id = l_from_cost_grp;
1279: end if;
1280:
1281: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');
1282: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
1283: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
1284: if (l_from_method IN (5,6)) then
1285: CSTPLENG.consume_layers(
1286: i_org_id,

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

1279: end if;
1280:
1281: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');
1282: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
1283: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
1284: if (l_from_method IN (5,6)) then
1285: CSTPLENG.consume_layers(
1286: i_org_id,
1287: i_txn_id,

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

1343: where inventory_item_id = i_item_id
1344: and organization_id = l_std_org;
1345: end if;
1346: if (l_to_std_exp = 1) then
1347: fnd_file.put_line(fnd_file.log, 'item is expense in receiving std org');
1348: elsif
1349: /* end for bug 3671538 */
1350: ((l_std_exp <> 1) or (l_std_from_org = 1) or
1351: (l_std_to_org = 1 and i_txn_action_id = 12 and i_fob_point = 1))

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

1368: l_stmt_num := 70;
1369: /* If no rows exist in cicd (item hasn't been costed), insert into */
1370: /* mcacd using 0 value of this level material */
1371: if (l_count > 0) then
1372: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for std org using cost from CICD');
1373: insert into mtl_cst_actual_cost_details (
1374: transaction_id,
1375: organization_id,
1376: layer_id,

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

1421: and cost_type_id = 1
1422: and inventory_item_id = i_item_id
1423: group by cost_element_id, level_type;
1424: else
1425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for std org using 0 cost');
1426: insert into mtl_cst_actual_cost_details (
1427: transaction_id,
1428: organization_id,
1429: layer_id,

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

1494: RAISE moh_rules_error;
1495: END IF;
1496:
1497: if (l_earn_moh = 0 ) then
1498: FND_FILE.put_line(fnd_file.log, '--Material Overhead Absorption Overridden--');
1499: else
1500:
1501: Insert into mtl_actual_cost_subelement(
1502: layer_id,

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

1811: Intransit receipt, FOB receipt from std to LIFO
1812: */
1813:
1814: if(o_interorg_rec=1 and i_txn_action_id <> 3) then
1815: FND_FILE.PUT_LINE(FND_FILE.LOG,'Creating layers when sending org is std costing org');
1816:
1817: -- Fix for bug 1872444
1818: -- Populate l_to_layer before calling CSTPLENG.create_layers
1819: -- for direct interorg transactions

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

1826: and cost_group_id = l_to_cost_grp;
1827: end if;
1828:
1829: if(l_debug = 'Y') then
1830: 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 );
1831: end if;
1832:
1833:
1834: CSTPLENG.create_layers(

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

2004: and msi.secondary_inventory_name = mmt.subinventory_code;
2005:
2006: if (l_txfr_std_exp = 1) then
2007: l_stmt_num := 260;
2008: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' insert into MCACD from MCTCD with l_txfr_std_exp = 1');
2009: insert into mtl_cst_actual_cost_details (
2010: transaction_id,
2011: organization_id,
2012: layer_id,

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

2056: WHERE ctcd.transaction_id = l_txn_update_id
2057: AND ctcd.organization_id = l_std_org
2058: /* AND ctcd.transaction_cost >= 0 */; -- modified for bug #3835412
2059:
2060: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' update MMT from MCACD with l_txfr_std_exp = 1');
2061: update mtl_material_transactions mmt
2062: set (last_update_date,
2063: last_updated_by,
2064: last_update_login,

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

2099: where mmt.transaction_id = i_txn_id;
2100: end if;
2101:
2102: l_stmt_num := 270;
2103: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' insert into MCACD from MCTCD with l_to_std_exp = 1');
2104: insert into mtl_cst_actual_cost_details (
2105: transaction_id,
2106: organization_id,
2107: layer_id,

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

2153: /* AND ctcd.transaction_cost >= 0 */; -- modified for bug #3835412
2154:
2155: -- update mmt if this is the receiving transaction id
2156: if (i_txn_org_id = l_std_org) then
2157: FND_FILE.PUT_LINE(FND_FILE.LOG, to_char(l_stmt_num) || ' update MMT from MCACD with l_to_std_exp = 1');
2158: update mtl_material_transactions mmt
2159: set (last_update_date,
2160: last_updated_by,
2161: last_update_login,

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

3124: from cst_inv_layers
3125: where layer_id = l_from_layer;
3126:
3127: if l_debug = 'Y' then
3128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)
3129: ||',layer change: '|| to_char(l_layer_chg));
3130: FND_FILE.PUT_LINE(FND_FILE.LOG,'From layer: '|| to_char(l_from_layer)
3131: || 'From qty: '|| to_char(l_from_qty));
3132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To layer: '|| to_char(l_to_layer)

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

3126:
3127: if l_debug = 'Y' then
3128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)
3129: ||',layer change: '|| to_char(l_layer_chg));
3130: FND_FILE.PUT_LINE(FND_FILE.LOG,'From layer: '|| to_char(l_from_layer)
3131: || 'From qty: '|| to_char(l_from_qty));
3132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To layer: '|| to_char(l_to_layer)
3133: || 'To qty: '|| to_char(l_to_qty));
3134: end if;

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

3128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)
3129: ||',layer change: '|| to_char(l_layer_chg));
3130: FND_FILE.PUT_LINE(FND_FILE.LOG,'From layer: '|| to_char(l_from_layer)
3131: || 'From qty: '|| to_char(l_from_qty));
3132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To layer: '|| to_char(l_to_layer)
3133: || 'To qty: '|| to_char(l_to_qty));
3134: end if;
3135:
3136: /************************************************************

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

3258: and inv_layer_id = l_inv_layer_id;
3259: end if; --- i checking layer cost and inserting MCACD
3260:
3261: if l_debug = 'Y' then
3262: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCACD inserted for trxn '
3263: || to_char(i_txn_id)
3264: || ':' || to_char(l_stmt_num));
3265: end if;
3266:

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

3356: i_prg_id,
3357: sysdate);
3358:
3359: IF (l_debug = 'Y') THEN
3360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory layer created');
3361: END IF;
3362:
3363: /* Delete cost details for the inventory layer from CILCD.
3364: No rows should be present. Just a safety check

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

3431: raise process_error;
3432: end if;
3433:
3434: if l_debug = 'Y' then
3435: FND_FILE.PUT_LINE(FND_FILE.LOG,'Compute_layer_actual_cost completed for txn '
3436: || to_char(i_txn_id)
3437: || ':' || to_char(l_stmt_num));
3438: end if;
3439: /* Borrow Payback Enhancement Bug#2325290 */

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

3439: /* Borrow Payback Enhancement Bug#2325290 */
3440: if (l_txn_type_id = 68) and (l_layer_chg = 0) then
3441:
3442: if l_debug = 'Y' then
3443: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling payback_variance() ');
3444: end if;
3445:
3446: payback_variance(
3447: i_org_id,

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

3512: raise process_error;
3513: end if;
3514:
3515: if l_debug = 'Y' then
3516: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calc_layer_average_cost completed for txn '
3517: || to_char(i_txn_id)
3518: || ':' || to_char(l_stmt_num));
3519: end if;
3520: end if; -- end from asset sub

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

3599: and organization_id = i_org_id
3600: and layer_id = l_from_layer;
3601:
3602: if l_debug = 'Y' then
3603: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '
3604: || to_char(i_txn_id)
3605: || ',to layer '|| to_char(l_from_layer)
3606: || ',stmt ' || to_char(l_stmt_num));
3607: end if;

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

3660: and organization_id = i_org_id
3661: and layer_id = l_from_layer;
3662:
3663: if l_debug = 'Y' then
3664: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '
3665: || to_char(i_txn_id)
3666: || ',to layer '|| to_char(l_from_layer)
3667: || ',stmt ' || to_char(l_stmt_num));
3668: end if;

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

3701: raise process_error;
3702: end if;
3703:
3704: if l_debug = 'Y' then
3705: FND_FILE.PUT_LINE(FND_FILE.LOG,'created_layer called for txn '
3706: || to_char(i_txn_id)
3707: || ',to layer '|| to_char(l_to_layer)
3708: || ',stmt ' || to_char(l_stmt_num));
3709: end if;

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

3733: raise process_error;
3734: end if;
3735:
3736: if l_debug = 'Y' then
3737: FND_FILE.PUT_LINE(FND_FILE.LOG,'calc_layer_avg_cost called for txn '
3738: || to_char(i_txn_id)
3739: || ',to layer '|| to_char(l_to_layer)
3740: || ',stmt ' || to_char(l_stmt_num));
3741: end if;

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

3822: and inv_layer_id = l_inv_layer_id;
3823: end if; -- end checking for layer cost
3824:
3825: if l_debug = 'Y' then
3826: FND_FILE.PUT_LINE(FND_FILE.LOG,'MCTCD inserted for txn '
3827: || to_char(i_txn_id)
3828: || ',to layer '|| to_char(l_to_layer)
3829: || ',stmt ' || to_char(l_stmt_num));
3830: end if;

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

3862: raise process_error;
3863: end if;
3864:
3865: if l_debug = 'Y' then
3866: FND_FILE.PUT_LINE(FND_FILE.LOG,'created_layer called for txn '
3867: || to_char(i_txn_id)
3868: || ',to layer '|| to_char(l_to_layer)
3869: || ',stmt ' || to_char(l_stmt_num));
3870: end if;

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

3894: raise process_error;
3895: end if;
3896:
3897: if l_debug = 'Y' then
3898: FND_FILE.PUT_LINE(FND_FILE.LOG,'calc_layer_avg_cost called for txn '
3899: || to_char(i_txn_id)
3900: || ',to layer '|| to_char(l_to_layer)
3901: || ',stmt ' || to_char(l_stmt_num));
3902: end if;

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

4103:
4104: l_total_borrow_qty := l_total_borrow_qty + abs(l_loan_quantity);
4105: end loop; -- end looping c_payback_rec
4106:
4107: fnd_file.put_line(fnd_file.log, 'borrow quantity' || l_total_borrow_qty);
4108:
4109: l_stmt_num := 30;
4110: /* Figure out the payback cost */
4111: for c_mclacd_rec in c_mclacd_data(i_txn_id) LOOP

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

4301: l_snd_qty := o_txn_qty;
4302: l_std_exp := 0;
4303:
4304: IF g_debug = 'Y' THEN
4305: fnd_file.put_line(fnd_file.log, l_procedure_name || ' <<<');
4306: END IF;
4307:
4308: l_earn_moh := 1;
4309: l_return_status := fnd_api.g_ret_sts_success;

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

4461: o_interorg_rec := 0;
4462: end if;
4463:
4464: IF g_debug = 'Y' THEN
4465: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4466: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4467: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4468: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4469: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||

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

4462: end if;
4463:
4464: IF g_debug = 'Y' THEN
4465: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4466: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4467: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4468: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4469: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4470: ' Transfer Price: ' || i_txf_price ||

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

4463:
4464: IF g_debug = 'Y' THEN
4465: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4466: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4467: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4468: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4469: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4470: ' Transfer Price: ' || i_txf_price ||
4471: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);

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

4464: IF g_debug = 'Y' THEN
4465: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4466: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4467: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4468: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4469: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4470: ' Transfer Price: ' || i_txf_price ||
4471: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);
4472: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);

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

4465: fnd_file.put_line(fnd_file.log, 'TxnOrg: ' || i_txn_org_id || ' Item: ' || i_item_id);
4466: fnd_file.put_line(fnd_file.log, 'fromOrg: ' || l_from_org || ' toOrg: ' || l_to_org);
4467: fnd_file.put_line(fnd_file.log, 'fromCG: ' || l_from_cost_grp || ' toCG: ' || l_to_cost_grp);
4468: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4469: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4470: ' Transfer Price: ' || i_txf_price ||
4471: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);
4472: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);
4473: fnd_file.put_line(fnd_file.log, 'o_interorg_rec: ' || o_interorg_rec);

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

4468: fnd_file.put_line(fnd_file.log, 'Transaction Action: ' || i_txn_action_id);
4469: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4470: ' Transfer Price: ' || i_txf_price ||
4471: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);
4472: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);
4473: fnd_file.put_line(fnd_file.log, 'o_interorg_rec: ' || o_interorg_rec);
4474: END IF;
4475:
4476:

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

4469: fnd_file.put_line(fnd_file.log, 'Transfer price options: ' || i_tprice_option ||
4470: ' Transfer Price: ' || i_txf_price ||
4471: ' Trp Cost: ' || l_trans_cost || ' Qty: ' || o_txn_qty);
4472: fnd_file.put_line(fnd_file.log, 'trx: ' || i_txn_id || ' trxCost: ' || l_rcv_txn_cost);
4473: fnd_file.put_line(fnd_file.log, 'o_interorg_rec: ' || o_interorg_rec);
4474: END IF;
4475:
4476:
4477: if ((i_txn_action_id in (21,22)) OR

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

4489: and cost_group_id = l_from_cost_grp;
4490: end if;
4491:
4492: IF g_debug = 'Y' THEN
4493: fnd_file.put_line(fnd_file.log, 'Updating trx: ' || i_txn_id || ' with trxCost: ' || l_rcv_txn_cost);
4494: END IF;
4495:
4496: l_stmt_num := 50;
4497: Update mtl_material_transactions

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

4499: where transaction_id = i_txn_id;
4500:
4501:
4502: IF g_debug = 'Y' THEN
4503: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interorg transfer send org: (consume layers) ...');
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
4505: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
4506: END IF;
4507:

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

4500:
4501:
4502: IF g_debug = 'Y' THEN
4503: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interorg transfer send org: (consume layers) ...');
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
4505: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
4506: END IF;
4507:
4508: --

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

4501:
4502: IF g_debug = 'Y' THEN
4503: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interorg transfer send org: (consume layers) ...');
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
4505: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
4506: END IF;
4507:
4508: --
4509: -- Bug 5222084: consume_layers layer should be called only for the following txns.

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

4544: elsif (i_txn_action_id = 12 AND i_fob_point = 1)
4545: then
4546:
4547: IF g_debug = 'Y' THEN
4548: fnd_file.put_line(fnd_file.log, 'Updating trx: ' || i_txn_id || ' with trxCost: ' || l_rcv_txn_cost);
4549: END IF;
4550:
4551: l_stmt_num := 70;
4552: Update mtl_material_transactions

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

4558: (i_txn_action_id = 12 AND i_fob_point = 2))
4559: then
4560:
4561: IF g_debug = 'Y' THEN
4562: fnd_file.put_line(fnd_file.log, 'inserting to MCTCD for txn: ' || i_txn_id || '. trxCost: ' || l_rcv_txn_cost);
4563: END IF;
4564:
4565: l_stmt_num := 80;
4566: insert into mtl_cst_txn_cost_details (

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

4617: end if;
4618:
4619:
4620: IF g_debug = 'Y' THEN
4621: FND_FILE.PUT_LINE(FND_FILE.LOG, l_procedure_name || ': Interorg transfer receiving org: (create layers) ...');
4622: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
4623: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
4624: END IF;
4625:

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

4618:
4619:
4620: IF g_debug = 'Y' THEN
4621: FND_FILE.PUT_LINE(FND_FILE.LOG, l_procedure_name || ': Interorg transfer receiving org: (create layers) ...');
4622: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
4623: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
4624: END IF;
4625:
4626: /* Call create_layers when :

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

4619:
4620: IF g_debug = 'Y' THEN
4621: FND_FILE.PUT_LINE(FND_FILE.LOG, l_procedure_name || ': Interorg transfer receiving org: (create layers) ...');
4622: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_to_method));
4623: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_to_layer));
4624: END IF;
4625:
4626: /* Call create_layers when :
4627: Direct Interorg transfers

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

4660:
4661: END IF;
4662:
4663: IF g_debug = 'Y' THEN
4664: fnd_file.put_line(fnd_file.log, l_procedure_name || ' >>>');
4665: END IF;
4666:
4667: EXCEPTION
4668: when others then