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

Line 113: fnd_file.put_line(fnd_file.log, 'calling Update_eamCost');

109: END;
110:
111: l_stmt_num := 30;
112: if (l_debug = 'Y') then
113: fnd_file.put_line(fnd_file.log, 'calling Update_eamCost');
114: end if;
115: Update_eamCost (
116: p_api_version => 1.0,
117: x_return_status => l_return_status,

Line 135: FND_FILE.put_line(FND_FILE.log, x_msg_data);

131: p_login_id => p_login_id,
132: p_txn_date => l_txn_date);
133:
134: IF l_return_status <> FND_API.g_ret_sts_success THEN
135: FND_FILE.put_line(FND_FILE.log, x_msg_data);
136: l_api_message := 'Update_eamCost returned error';
137: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
138: FND_MESSAGE.set_token('TEXT', l_api_message);
139: FND_MSG_pub.add;

Line 277: fnd_file.put_line(fnd_file.log, 'In process_resCost');

273: l_debug := fnd_profile.value('MRP_DEBUG');
274:
275:
276: if (l_debug = 'Y') THEN
277: fnd_file.put_line(fnd_file.log, 'In process_resCost');
278: end if;
279:
280:
281: -- Standard call to check for call compatibility

Line 324: fnd_file.put_line(fnd_file.log, 'l_txn_mode: ' || to_char(l_txn_mode));

320: l_res_seq_num := l_resourcetxn_rec.resource_seq_num;
321: END IF;
322:
323: if (l_debug = 'Y') THEN
324: fnd_file.put_line(fnd_file.log, 'l_txn_mode: ' || to_char(l_txn_mode));
325: end if;
326:
327: l_stmt_num := 50;
328: Update_eamCost (

Line 350: FND_FILE.put_line(FND_FILE.log, x_msg_data);

346: p_login_id => p_login_id,
347: p_txn_date => l_resourcetxn_rec.txn_date);
348:
349: IF l_return_status <> FND_API.g_ret_sts_success THEN
350: FND_FILE.put_line(FND_FILE.log, x_msg_data);
351: l_api_message := 'Update_eamCost returned error';
352: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
353: FND_MESSAGE.set_token('TEXT', l_api_message);
354: FND_MSG_pub.add;

Line 518: fnd_file.put_line(fnd_file.log, 'In Update_eamCost');

514: SAVEPOINT Update_eamCost_PUB;
515: l_debug := fnd_profile.value('MRP_DEBUG');
516:
517: if (l_debug = 'Y') then
518: fnd_file.put_line(fnd_file.log, 'In Update_eamCost');
519: end if;
520:
521: -- Standard call to check for call compatibility
522: IF NOT FND_API.Compatible_API_Call (

Line 551: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing job '

547: FND_MSG_PUB.ADD;
548: RAISE FND_API.g_exc_error;
549: END IF;
550:
551: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing job '
552: || to_char(p_wip_entity_id));
553:
554:
555: -- Process only job with eAM wip entity type

Line 611: FND_FILE.put_line(FND_FILE.log, x_msg_data);

607: x_cost_element_id => l_eam_cost_element
608: );
609:
610: if (l_return_status <> fnd_api.g_ret_sts_success) then
611: FND_FILE.put_line(FND_FILE.log, x_msg_data);
612: l_api_message := 'get_CostElement_for_DirectItem returned unexpected error';
613: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
614: FND_MESSAGE.set_token('TEXT', l_api_message);
615: FND_MSG_pub.add;

Line 620: FND_FILE.PUT_LINE(FND_FILE.LOG,'eam_cost_element_id: '|| to_char(l_eam_cost_element));

616: raise fnd_api.g_exc_unexpected_error;
617: end if;
618:
619: if (l_debug = 'Y') then
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'eam_cost_element_id: '|| to_char(l_eam_cost_element));
621: end if;
622:
623: else /* p_txn_mode in (1,2,3) */
624: l_eam_cost_element := Get_eamCostElement(p_txn_mode,p_org_id,p_resource_id);

Line 660: fnd_file.put_line(fnd_file.log, 'Getting maint Cost_category');

656: l_stmt_num := 80;
657: l_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: if (l_debug = 'Y') then
660: fnd_file.put_line(fnd_file.log, 'Getting maint Cost_category');
661: end if;
662:
663: Get_MaintCostCat(
664: p_txn_mode,

Line 675: FND_FILE.put_line(FND_FILE.log, x_msg_data);

671: x_owning_dept => l_owning_dept_id,
672: x_maint_cost_cat => l_maint_cost_category);
673:
674: IF l_return_status <> FND_API.g_ret_sts_success THEN
675: FND_FILE.put_line(FND_FILE.log, x_msg_data);
676: l_api_message := 'Get_MaintCostCat returned error';
677: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
678: FND_MESSAGE.set_token('TEXT', l_api_message);
679: FND_MSG_pub.add;

Line 686: fnd_file.put_line(fnd_file.log, 'Calling insertUpdate_EamPerBal');

682:
683: END IF; -- end checking p_txn_mode
684:
685: if (l_debug = 'Y') then
686: fnd_file.put_line(fnd_file.log, 'Calling insertUpdate_EamPerBal');
687: end if;
688:
689: -- Insert/update WIP_EAM_PERIOD_BALANCES
690: l_stmt_num := 120;

Line 718: FND_FILE.put_line(FND_FILE.log, x_msg_data);

714: p_login_id => p_login_id,
715: p_txn_date => p_txn_date);
716:
717: IF l_return_status <> FND_API.g_ret_sts_success THEN
718: FND_FILE.put_line(FND_FILE.log, x_msg_data);
719: l_api_message := 'InsertUpdate_eamPerBal returned error';
720: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
721: FND_MESSAGE.set_token('TEXT', l_api_message);
722: FND_MSG_pub.add;

Line 739: FND_FILE.PUT_LINE(fnd_file.log,'1 exception ' || SQLERRM );

735:
736:
737: EXCEPTION
738: WHEN FND_API.g_exc_error THEN
739: FND_FILE.PUT_LINE(fnd_file.log,'1 exception ' || SQLERRM );
740: ROLLBACK TO Update_eamCost_PUB;
741: x_return_status := FND_API.g_ret_sts_error;
742:
743: -- Get message count and data

Line 750: FND_FILE.PUT_LINE(fnd_file.log,'1 exception ' || SQLERRM );

746: , p_data => x_msg_data
747: );
748:
749: WHEN FND_API.g_exc_unexpected_error THEN
750: FND_FILE.PUT_LINE(fnd_file.log,'1 exception ' || SQLERRM );
751: ROLLBACK TO Update_eamCost_PUB;
752: x_return_status := FND_API.g_ret_sts_unexp_error ;
753:
754: -- Get message count and data

Line 761: fnd_file.put_line(fnd_file.log, 'Exception in Update_eamcost'|| SQLERRM);

757: , p_data => x_msg_data
758: );
759:
760: WHEN OTHERS THEN
761: fnd_file.put_line(fnd_file.log, 'Exception in Update_eamcost'|| SQLERRM);
762: ROLLBACK TO Update_eamCost_PUB;
763: x_return_status := fnd_api.g_ret_sts_unexp_error ;
764:
765: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 914: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_eamPerBal');

910: SAVEPOINT InsertUpdate_eamPerBal_PUB;
911: l_debug := fnd_profile.value('MRP_DEBUG');
912:
913: if (l_debug = 'Y') then
914: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_eamPerBal');
915: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
916: end if;
917:
918: -- Standard call to check for call compatibility

Line 915: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));

911: l_debug := fnd_profile.value('MRP_DEBUG');
912:
913: if (l_debug = 'Y') then
914: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_eamPerBal');
915: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
916: end if;
917:
918: -- Standard call to check for call compatibility
919: IF NOT FND_API.Compatible_API_Call (

Line 1083: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');

1079: ELSE
1080: l_stmt_num := 160;
1081:
1082: if (l_debug = 'Y') then
1083: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1084: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1085: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );

Line 1084: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );

1080: l_stmt_num := 160;
1081:
1082: if (l_debug = 'Y') then
1083: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1084: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1085: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));

Line 1085: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );

1081:
1082: if (l_debug = 'Y') then
1083: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1084: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1085: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1089: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );

Line 1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );

1082: if (l_debug = 'Y') then
1083: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1084: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1085: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1089: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1090: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );

Line 1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );

1083: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1084: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1085: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1089: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1090: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1091: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );

Line 1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));

1084: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1085: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1089: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1090: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1091: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );
1092: end if;

Line 1089: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );

1085: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1089: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1090: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1091: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );
1092: end if;
1093:

Line 1090: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );

1086: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1089: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1090: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1091: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );
1092: end if;
1093:
1094:

Line 1091: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );

1087: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1088: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1089: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1090: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1091: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );
1092: end if;
1093:
1094:
1095: INSERT INTO wip_eam_period_balances (

Line 1154: fnd_file.put_line(fnd_file.log, 'Inserted into wepb');

1150: p_prog_app_id,
1151: p_prog_id
1152: );
1153: if (l_debug = 'Y') then
1154: fnd_file.put_line(fnd_file.log, 'Inserted into wepb');
1155: end if;
1156:
1157: END IF; -- end checking job balance row
1158:

Line 1197: fnd_file.put_line(fnd_file.log,'txn date: ' || p_txn_date);

1193: ---------------------------------------
1194: -- Check for Asset route
1195: ---------------------------------------
1196: if (l_route_asset = 'Y') then
1197: fnd_file.put_line(fnd_file.log,'txn date: ' || p_txn_date);
1198:
1199: l_stmt_num := 164;
1200:
1201: /* Pick up the member asset route information from EAM_WORK_ORDER_ROUTE

Line 1330: FND_FILE.PUT_LINE(fnd_file.log,'inserted into cst_eam_asset_per_balances' );

1326:
1327: end if;
1328:
1329: if (l_debug = 'Y') then
1330: FND_FILE.PUT_LINE(fnd_file.log,'inserted into cst_eam_asset_per_balances' );
1331: end if;
1332:
1333: -- Standard check of p_commit
1334: IF FND_API.to_Boolean(p_commit) THEN

Line 1346: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );

1342:
1343: EXCEPTION
1344:
1345: WHEN FND_API.g_exc_error THEN
1346: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );
1347: ROLLBACK TO InsertUpdate_eamPerBal_PUB;
1348: x_return_status := FND_API.g_ret_sts_error;
1349:
1350: -- Get message count and data

Line 1357: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );

1353: , p_data => x_msg_data
1354: );
1355:
1356: WHEN FND_API.g_exc_unexpected_error THEN
1357: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );
1358: ROLLBACK TO InsertUpdate_eamPerBal_PUB;
1359: x_return_status := FND_API.g_ret_sts_unexp_error ;
1360:
1361: -- Get message count and data

Line 1368: FND_FILE.PUT_LINE(fnd_file.log,'exception' || SQLERRM );

1364: , p_data => x_msg_data
1365: );
1366:
1367: WHEN OTHERS THEN
1368: FND_FILE.PUT_LINE(fnd_file.log,'exception' || SQLERRM );
1369: ROLLBACK TO InsertUpdate_eamPerBal_PUB;
1370: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1371:
1372: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 1481: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_assetPerBal');

1477: SAVEPOINT InsertUpdate_assetPerBal_PUB;
1478: l_debug := fnd_profile.value('MRP_DEBUG');
1479:
1480: if (l_debug = 'Y') then
1481: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_assetPerBal');
1482: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
1483: end if;
1484:
1485: -- Standard call to check for call compatibility

Line 1482: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));

1478: l_debug := fnd_profile.value('MRP_DEBUG');
1479:
1480: if (l_debug = 'Y') then
1481: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_assetPerBal');
1482: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
1483: end if;
1484:
1485: -- Standard call to check for call compatibility
1486: IF NOT FND_API.Compatible_API_Call (

Line 1607: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );

1603:
1604: EXCEPTION
1605:
1606: WHEN FND_API.g_exc_error THEN
1607: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );
1608: ROLLBACK TO InsertUpdate_assetPerBal_PUB;
1609: x_return_status := FND_API.g_ret_sts_error;
1610: -- Get message count and data
1611: FND_MSG_PUB.count_and_get

Line 1617: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );

1613: , p_data => x_msg_data
1614: );
1615:
1616: WHEN FND_API.g_exc_unexpected_error THEN
1617: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );
1618: ROLLBACK TO InsertUpdate_assetPerBal_PUB;
1619: x_return_status := FND_API.g_ret_sts_unexp_error ;
1620:
1621: -- Get message count and data

Line 1628: FND_FILE.PUT_LINE(fnd_file.log,'exception' || SQLERRM );

1624: , p_data => x_msg_data
1625: );
1626:
1627: WHEN OTHERS THEN
1628: FND_FILE.PUT_LINE(fnd_file.log,'exception' || SQLERRM );
1629: ROLLBACK TO InsertUpdate_assetPerBal_PUB;
1630: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1631:
1632: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 1687: fnd_file.put_line(fnd_file.log, 'In Get_eamCostElement');

1683:
1684: l_debug := fnd_profile.value('MRP_DEBUG');
1685:
1686: if (l_debug = 'Y') THEN
1687: fnd_file.put_line(fnd_file.log, 'In Get_eamCostElement');
1688: end if;
1689:
1690:
1691: IF p_txn_mode = 1 THEN -- material

Line 1715: fnd_file.put_line(fnd_file.log, 'l_eam_cost_element: '|| to_char(l_eam_cost_element));

1711: END IF; -- end checking resource type
1712: END IF; -- end checking txn mode
1713:
1714: if (l_debug = 'Y') THEN
1715: fnd_file.put_line(fnd_file.log, 'l_eam_cost_element: '|| to_char(l_eam_cost_element));
1716: fnd_file.put_line(fnd_file.log, 'resource id: '|| to_char(p_resource_id));
1717: end if;
1718:
1719: RETURN l_eam_cost_element;

Line 1716: fnd_file.put_line(fnd_file.log, 'resource id: '|| to_char(p_resource_id));

1712: END IF; -- end checking txn mode
1713:
1714: if (l_debug = 'Y') THEN
1715: fnd_file.put_line(fnd_file.log, 'l_eam_cost_element: '|| to_char(l_eam_cost_element));
1716: fnd_file.put_line(fnd_file.log, 'resource id: '|| to_char(p_resource_id));
1717: end if;
1718:
1719: RETURN l_eam_cost_element;
1720:

Line 1723: FND_FILE.PUT_LINE(FND_FILE.LOG,'Get_eamCostElement - statement '

1719: RETURN l_eam_cost_element;
1720:
1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: FND_FILE.PUT_LINE(FND_FILE.LOG,'Get_eamCostElement - statement '
1724: || l_stmt_num || ': '
1725: || substr(SQLERRM,1,200));
1726:
1727: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 1927: FND_FILE.PUT_LINE(FND_FILE.LOG,'Get_MaintCostCat - statement '

1923: */
1924:
1925: EXCEPTION
1926: WHEN OTHERS THEN
1927: FND_FILE.PUT_LINE(FND_FILE.LOG,'Get_MaintCostCat - statement '
1928: || l_stmt_num || ': '
1929: || substr(SQLERRM,1,200));
1930: x_return_status := FND_API.g_ret_sts_unexp_error ;
1931:

Line 2413: FND_FILE.PUT_LINE(FND_FILE.LOG,'Delete_eamPerBal - statement '

2409: WHEN OTHERS THEN
2410: ROLLBACK TO Delete_eamPerBal_PUB;
2411: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2412:
2413: FND_FILE.PUT_LINE(FND_FILE.LOG,'Delete_eamPerBal - statement '
2414: || l_stmt_num || ': '
2415: || substr(SQLERRM,1,200));
2416:
2417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 5639: FND_FILE.PUT_LINE(fnd_file.log,'Check if direct item');

5635: SAVEPOINT check_if_direct_item_PUB;
5636: l_debug := fnd_profile.value('MRP_DEBUG');
5637:
5638: if (l_debug = 'Y') then
5639: FND_FILE.PUT_LINE(fnd_file.log,'Check if direct item');
5640: end if;
5641:
5642: -- Standard call to check for call compatibility
5643: IF NOT FND_API.Compatible_API_Call (

Line 5672: fnd_file.put_line(fnd_file.log,'RCV transaction ID : '||p_interface_txn_id);

5668: -- instead of interface_transaction_id. Get the interface_transaction_id from rcv_transactions.
5669: l_stmt_num := 25;
5670:
5671: if(l_debug = 'Y') then
5672: fnd_file.put_line(fnd_file.log,'RCV transaction ID : '||p_interface_txn_id);
5673: end if;
5674:
5675: SELECT interface_transaction_id
5676: INTO l_interface_txn_id

Line 5685: fnd_file.put_line(fnd_file.log,'Interface Txn ID : '||l_interface_txn_id);

5681: RAISE fnd_api.g_exc_error;
5682: END IF;
5683:
5684: if(l_debug = 'Y') then
5685: fnd_file.put_line(fnd_file.log,'Interface Txn ID : '||l_interface_txn_id);
5686: end if;
5687:
5688: -- Obtain wip entity, organization and item ID for the receiving transaction
5689: l_stmt_num := 30;

Line 5700: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));

5696: FROM rcv_transactions_interface
5697: WHERE interface_transaction_id = l_interface_txn_id;
5698:
5699: if (l_debug = 'Y') then
5700: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));
5701: fnd_file.put_line(fnd_file.log,'item: ' || to_char(l_item_id));
5702: fnd_file.put_line(fnd_file.log,'to_org: ' || to_char(l_org_id));
5703: end if;
5704:

Line 5701: fnd_file.put_line(fnd_file.log,'item: ' || to_char(l_item_id));

5697: WHERE interface_transaction_id = l_interface_txn_id;
5698:
5699: if (l_debug = 'Y') then
5700: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));
5701: fnd_file.put_line(fnd_file.log,'item: ' || to_char(l_item_id));
5702: fnd_file.put_line(fnd_file.log,'to_org: ' || to_char(l_org_id));
5703: end if;
5704:
5705: -- Get EAM enabled flag for organization

Line 5702: fnd_file.put_line(fnd_file.log,'to_org: ' || to_char(l_org_id));

5698:
5699: if (l_debug = 'Y') then
5700: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));
5701: fnd_file.put_line(fnd_file.log,'item: ' || to_char(l_item_id));
5702: fnd_file.put_line(fnd_file.log,'to_org: ' || to_char(l_org_id));
5703: end if;
5704:
5705: -- Get EAM enabled flag for organization
5706: l_stmt_num := 40;

Line 5713: fnd_file.put_line(fnd_file.log,'EAM flag: ' || l_eam_flag);

5709: FROM mtl_parameters
5710: WHERE organization_id = l_org_id;
5711:
5712: if (l_debug = 'Y') then
5713: fnd_file.put_line(fnd_file.log,'EAM flag: ' || l_eam_flag);
5714: end if;
5715:
5716: -- Get entity type for the job
5717: l_stmt_num := 50;

Line 5724: fnd_file.put_line(fnd_file.log,'Entity: ' || to_char(l_entity_type));

5720: FROM wip_entities
5721: WHERE wip_entity_id = l_wip_entity_id;
5722:
5723: if (l_debug = 'Y') then
5724: fnd_file.put_line(fnd_file.log,'Entity: ' || to_char(l_entity_type));
5725: end if;
5726:
5727: -- Validate organization and entity type
5728: l_stmt_num := 60;

Line 5735: fnd_file.put_line(fnd_file.log,'EAM job!');

5731: ELSE
5732: -- Check for Item ID
5733: l_stmt_num := 70;
5734: if (l_debug = 'Y') then
5735: fnd_file.put_line(fnd_file.log,'EAM job!');
5736: end if;
5737:
5738: IF (l_item_id IS NULL) THEN
5739: x_direct_item_flag := 1;

Line 5749: fnd_file.put_line(fnd_file.log,'osp flag : ' || l_osp_item);

5745: WHERE inventory_item_id = l_item_id
5746: AND organization_id = l_org_id;
5747:
5748: if (l_debug = 'Y') then
5749: fnd_file.put_line(fnd_file.log,'osp flag : ' || l_osp_item);
5750: end if;
5751:
5752: IF (l_osp_item = 'N') THEN
5753: x_direct_item_flag := 1;

Line 5761: fnd_file.put_line(fnd_file.log,'Direct item flag : ' || to_char(x_direct_item_flag));

5757: END IF; /* check for NULL item_id */
5758: END IF; /* Organization and job are of EAM type */
5759:
5760: if (l_debug = 'Y') then
5761: fnd_file.put_line(fnd_file.log,'Direct item flag : ' || to_char(x_direct_item_flag));
5762: end if;
5763:
5764: -- Standard check of p_commit
5765: IF FND_API.to_Boolean(p_commit) THEN

Line 5923: fnd_file.put_line(fnd_file.log,'RCV transaction ID : '||l_txn_id);

5919: l_stmt_num := 25;
5920:
5921: l_txn_id := l_directItem_rec.rcv_transaction_id;
5922: if(l_debug = 'Y') then
5923: fnd_file.put_line(fnd_file.log,'RCV transaction ID : '||l_txn_id);
5924: end if;
5925:
5926: /* Modified quantity to source_doc_quantity for bug 3253815. When the
5927: receipt UOM is different from the UOM on the PO, using quantity

Line 5944: fnd_file.put_line(fnd_file.log,'Interface txn ID : '

5940: -- instead of rcv_transaction_id
5941: -- l_directItem_rec.rcv_transaction_id := l_interface_txn_id;
5942:
5943: if (l_debug = 'Y') then
5944: fnd_file.put_line(fnd_file.log,'Interface txn ID : '
5945: || to_char(l_interface_txn_id));
5946: end if;
5947:
5948:

Line 6065: fnd_file.put_line(fnd_file.log,'Actual resource rate: ' || to_char(l_actual_res_rate) ||

6061: and rti.po_distribution_id = pod.po_distribution_id
6062: and pol.po_line_id = pod.po_line_id;
6063:
6064: if (l_debug = 'Y') then
6065: fnd_file.put_line(fnd_file.log,'Actual resource rate: ' || to_char(l_actual_res_rate) ||
6066: 'Currency Conv rate : ' ||to_char(l_curr_rate)||
6067: 'Order Type Lookup Code : ' ||to_char( l_po_order_type_lookup_code));
6068: end if;
6069:

Line 6121: fnd_file.put_line(fnd_file.log,'Actual resource rate: ' || to_char(l_actual_res_rate));

6117: l_actual_res_rate := l_actual_res_rate * (l_quantity/l_directItem_rec.primary_quantity);
6118: END IF;
6119:
6120: if (l_debug = 'Y') then
6121: fnd_file.put_line(fnd_file.log,'Actual resource rate: ' || to_char(l_actual_res_rate));
6122: end if;
6123:
6124: l_directItem_rec.actual_resource_rate := l_actual_res_rate * l_curr_rate;
6125: l_directItem_rec.usage_rate_or_amount := l_actual_res_rate * l_curr_rate;

Line 6217: fnd_file.put_line(fnd_file.log,'Populated direct item record for job ' || to_char(l_directItem_rec.wip_entity_id));

6213: and muom.base_uom_flag(+) = 'Y'
6214: and muom.language(+) = userenv('LANG');*/
6215:
6216: if (l_debug = 'Y') then
6217: fnd_file.put_line(fnd_file.log,'Populated direct item record for job ' || to_char(l_directItem_rec.wip_entity_id));
6218: end if;
6219:
6220:
6221: -- Obtain PO transaction type

Line 6228: fnd_file.put_line(fnd_file.log,'PO txn type is ' || l_po_txn_type);

6224: from rcv_transactions_interface
6225: where interface_transaction_id = l_interface_txn_id;
6226:
6227: if (l_debug = 'Y') then
6228: fnd_file.put_line(fnd_file.log,'PO txn type is ' || l_po_txn_type);
6229: end if;
6230:
6231: -- Update sign on primary quantity
6232: l_stmt_num := 45;

Line 6242: fnd_file.put_line(fnd_file.log,'Primary quantity: ' || to_char(l_directItem_rec.primary_quantity));

6238: l_directItem_rec.transaction_quantity := -1 * abs(l_directItem_rec.transaction_quantity);
6239:
6240: end if;
6241: if (l_debug = 'Y') then
6242: fnd_file.put_line(fnd_file.log,'Primary quantity: ' || to_char(l_directItem_rec.primary_quantity));
6243: end if;
6244:
6245: -- Get WE details
6246: l_stmt_num := 50;

Line 6257: fnd_file.put_line(fnd_file.log,'Job Name : ' || l_directItem_rec.wip_entity_name);

6253: from wip_entities
6254: where wip_entity_id = l_directItem_rec.wip_entity_id;
6255:
6256: if (l_debug = 'Y') then
6257: fnd_file.put_line(fnd_file.log,'Job Name : ' || l_directItem_rec.wip_entity_name);
6258: end if;
6259:
6260: -- Get Department details
6261: l_stmt_num := 60;

Line 6273: fnd_file.put_line(fnd_file.log,'Dept Code : ' || l_directitem_rec.department_code);

6269: and wo.operation_seq_num = l_directItem_rec.operation_seq_num
6270: and wo.organization_id = l_directItem_rec.organization_id
6271: and bd.department_id = wo.department_id;
6272: if (l_debug = 'Y') then
6273: fnd_file.put_line(fnd_file.log,'Dept Code : ' || l_directitem_rec.department_code);
6274: end if;
6275:
6276: -- Default other attributes
6277: l_stmt_num := 70;

Line 6283: fnd_file.put_line(fnd_file.log,'user name : ' || l_directItem_rec.created_by_name);

6279: into l_directItem_rec.created_by_name
6280: from fnd_user
6281: where user_id = l_directItem_rec.created_by;
6282: if (l_debug = 'Y') then
6283: fnd_file.put_line(fnd_file.log,'user name : ' || l_directItem_rec.created_by_name);
6284: end if;
6285:
6286: l_stmt_num := 80;
6287: select user_name

Line 6292: fnd_file.put_line(fnd_file.log,'updated by ' || l_directItem_rec.last_updated_by);

6288: into l_directItem_rec.last_updated_by_name
6289: from fnd_user
6290: where user_id = l_directItem_rec.last_updated_by;
6291: if (l_debug = 'Y') then
6292: fnd_file.put_line(fnd_file.log,'updated by ' || l_directItem_rec.last_updated_by);
6293: end if;
6294:
6295: l_stmt_num := 90;
6296: select organization_code

Line 6301: fnd_file.put_line(fnd_file.log,'organization code ' || l_directItem_rec.organization_code);

6297: into l_directItem_rec.organization_code
6298: from mtl_parameters
6299: where organization_id = l_directItem_rec.organization_id;
6300: if (l_debug = 'Y') then
6301: fnd_file.put_line(fnd_file.log,'organization code ' || l_directItem_rec.organization_code);
6302: end if;
6303:
6304: l_stmt_num := 100;
6305: if (l_directItem_rec.reason_id IS NOT NULL) then

Line 6311: fnd_file.put_line(fnd_file.log,'reason name ' || l_directItem_rec.reason_name);

6307: into l_directItem_rec.reason_name
6308: from mtl_transaction_reasons
6309: where reason_id = l_directItem_rec.reason_id;
6310: if (l_debug = 'Y') then
6311: fnd_file.put_line(fnd_file.log,'reason name ' || l_directItem_rec.reason_name);
6312: end if;
6313: end if;
6314:
6315:

Line 6334: FND_FILE.put_line(FND_FILE.log, l_msg_data);

6330: x_msg_data => l_msg_data
6331: );
6332:
6333: IF l_return_status <> FND_API.g_ret_sts_success THEN
6334: FND_FILE.put_line(FND_FILE.log, l_msg_data);
6335: l_api_message := 'WIP_EAM_RESOURCE_TRANSACTION.WIP_EAMRCVDIRECTITEM_HOOK returned error';
6336: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6337: FND_MESSAGE.set_token('TEXT', l_api_message);
6338: FND_MSG_pub.add;

Line 6503: fnd_file.put_line(fnd_file.log,'Transaction ID ' || to_char(direct_item_txn_rec.transaction_id));

6499: -- Loop through all direct item transactions
6500: FOR direct_item_txn_rec IN direct_item_txn_cur LOOP
6501:
6502: if (l_debug = 'Y') then
6503: fnd_file.put_line(fnd_file.log,'Transaction ID ' || to_char(direct_item_txn_rec.transaction_id));
6504: end if;
6505: /* Organization_id is the same for the entire group */
6506: l_organization_id := direct_item_txn_rec.organization_id;
6507:

Line 6558: fnd_file.put_line(fnd_file.log,'Transaction value ' || to_char(l_txn_value));

6554: l_acct_line_type := 5;
6555: end if;
6556:
6557: if (l_debug = 'Y') then
6558: fnd_file.put_line(fnd_file.log,'Transaction value ' || to_char(l_txn_value));
6559: fnd_file.put_line(fnd_file.log,'Base Transaction value ' || to_char(l_base_txn_value));
6560: fnd_file.put_line(fnd_file.log,'Quantity ' || to_char(direct_item_txn_rec.qty));
6561: end if;
6562:

Line 6559: fnd_file.put_line(fnd_file.log,'Base Transaction value ' || to_char(l_base_txn_value));

6555: end if;
6556:
6557: if (l_debug = 'Y') then
6558: fnd_file.put_line(fnd_file.log,'Transaction value ' || to_char(l_txn_value));
6559: fnd_file.put_line(fnd_file.log,'Base Transaction value ' || to_char(l_base_txn_value));
6560: fnd_file.put_line(fnd_file.log,'Quantity ' || to_char(direct_item_txn_rec.qty));
6561: end if;
6562:
6563: l_stmt_num := 80;

Line 6560: fnd_file.put_line(fnd_file.log,'Quantity ' || to_char(direct_item_txn_rec.qty));

6556:
6557: if (l_debug = 'Y') then
6558: fnd_file.put_line(fnd_file.log,'Transaction value ' || to_char(l_txn_value));
6559: fnd_file.put_line(fnd_file.log,'Base Transaction value ' || to_char(l_base_txn_value));
6560: fnd_file.put_line(fnd_file.log,'Quantity ' || to_char(direct_item_txn_rec.qty));
6561: end if;
6562:
6563: l_stmt_num := 80;
6564: if (l_debug = 'Y') then

Line 6565: fnd_file.put_line(fnd_file.log,'Insert RI account ' || to_char(direct_item_txn_rec.rcv_acct_id));

6561: end if;
6562:
6563: l_stmt_num := 80;
6564: if (l_debug = 'Y') then
6565: fnd_file.put_line(fnd_file.log,'Insert RI account ' || to_char(direct_item_txn_rec.rcv_acct_id));
6566: end if;
6567:
6568: -- Insert line for receiving inspection if it's not an IPV transfer
6569: -- Insert line for account (adjusment account) if it's an IPV transfer

Line 6608: FND_FILE.put_line(FND_FILE.log, x_msg_data);

6604: x_cost_element_id => l_cost_element
6605: );
6606:
6607: if (l_return_status <> fnd_api.g_ret_sts_success) then
6608: FND_FILE.put_line(FND_FILE.log, x_msg_data);
6609: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
6610: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6611: FND_MESSAGE.set_token('TEXT', l_api_message);
6612: FND_MSG_pub.add;

Line 6617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'mfg cost_element_id: '|| to_char(l_cost_element));

6613: raise fnd_api.g_exc_unexpected_error;
6614: end if;
6615:
6616: if (l_debug = 'Y') then
6617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'mfg cost_element_id: '|| to_char(l_cost_element));
6618: end if;
6619:
6620: select decode(l_cost_element, 1, nvl(material_account,-1),
6621: 3, nvl(resource_account, -1),

Line 6630: fnd_file.put_line(fnd_file.log,'Insert WIP material acct ' || to_char(l_wip_acct));

6626:
6627: l_stmt_num := 100;
6628: -- Insert line for WIP valuation
6629: if (l_debug = 'Y') then
6630: fnd_file.put_line(fnd_file.log,'Insert WIP material acct ' || to_char(l_wip_acct));
6631: end if;
6632:
6633:
6634: insert_direct_item_distr (

Line 6660: fnd_file.put_line(fnd_file.log,'Update wip_period_balances');

6656:
6657: -- Update wip period balances , pl_material_in
6658: l_stmt_num := 110;
6659: if (l_debug = 'Y') then
6660: fnd_file.put_line(fnd_file.log,'Update wip_period_balances');
6661: end if;
6662:
6663: update_wip_period_balances (
6664: p_api_version => 1.0,

Line 6685: fnd_file.put_line(fnd_file.log,'Update eamcost');

6681:
6682: -- update wip_eam_asset_per_balances material cost
6683: l_stmt_num := 120;
6684: if (l_debug = 'Y') then
6685: fnd_file.put_line(fnd_file.log,'Update eamcost');
6686: end if;
6687:
6688: update_eamCost (
6689: p_api_version => 1.0,

Line 6719: fnd_file.put_line(fnd_file.log,'Insert direct item transaction');

6715:
6716: /* insert_direct_item_txn */
6717: l_stmt_num := 130;
6718: if (l_debug = 'Y') then
6719: fnd_file.put_line(fnd_file.log,'Insert direct item transaction');
6720: end if;
6721: insert_direct_item_txn (
6722: p_api_version => 1.0,
6723: p_group_id => p_group_id,

Line 6758: fnd_file.put_line(fnd_file.log,'Delete from wcti');

6754: END IF;
6755:
6756: l_stmt_num := 140;
6757: if (l_debug = 'Y') then
6758: fnd_file.put_line(fnd_file.log,'Delete from wcti');
6759: end if;
6760: delete from wip_cost_txn_interface
6761: where group_id = p_group_id
6762: and process_status = 2;

Line 6801: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.cost_direct_item_txn: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));

6797: --
6798: WHEN OTHERS THEN
6799: ROLLBACK TO cost_direct_item_txn_PUB;
6800: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6801: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.cost_direct_item_txn: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
6802: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6803: THEN
6804: fnd_msg_pub.add_exc_msg
6805: ( 'CST_eamCost_PUB'

Line 6961: fnd_file.put_line(fnd_file.log,'Txn value: ' || to_char(l_txn_value));

6957: where currency_code = l_func_currency;
6958: end if;
6959:
6960: if (l_debug = 'Y') then
6961: fnd_file.put_line(fnd_file.log,'Txn value: ' || to_char(l_txn_value));
6962: fnd_file.put_line(fnd_file.log,'Base txn value: ' || to_char(l_base_txn_value));
6963: end if;
6964:
6965: l_stmt_num := 95;

Line 6962: fnd_file.put_line(fnd_file.log,'Base txn value: ' || to_char(l_base_txn_value));

6958: end if;
6959:
6960: if (l_debug = 'Y') then
6961: fnd_file.put_line(fnd_file.log,'Txn value: ' || to_char(l_txn_value));
6962: fnd_file.put_line(fnd_file.log,'Base txn value: ' || to_char(l_base_txn_value));
6963: end if;
6964:
6965: l_stmt_num := 95;
6966: /* Direct Item Acct Enh (Patchset J) */

Line 6981: FND_FILE.put_line(FND_FILE.log, x_msg_data);

6977: x_cost_element_id => l_cost_element
6978: );
6979:
6980: if (l_return_status <> fnd_api.g_ret_sts_success) then
6981: FND_FILE.put_line(FND_FILE.log, x_msg_data);
6982: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
6983: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6984: FND_MESSAGE.set_token('TEXT', l_api_message);
6985: FND_MSG_pub.add;

Line 6990: FND_FILE.PUT_LINE(FND_FILE.LOG,'mfg cost_element_id: '|| to_char(l_cost_element));

6986: raise fnd_api.g_exc_unexpected_error;
6987: end if;
6988:
6989: if (l_debug = 'Y') then
6990: FND_FILE.PUT_LINE(FND_FILE.LOG,'mfg cost_element_id: '|| to_char(l_cost_element));
6991: end if;
6992:
6993: -- insert into wip_transaction_accounts
6994: l_stmt_num := 100;

Line 7088: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.insert_direct_item_distr(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));

7084: --
7085: WHEN OTHERS THEN
7086: ROLLBACK TO insert_direct_item_distr_PUB;
7087: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7088: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.insert_direct_item_distr(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
7089: --
7090: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
7091: THEN
7092: fnd_msg_pub.add_exc_msg

Line 7222: FND_FILE.put_line(FND_FILE.log, x_msg_data);

7218: x_cost_element_id => l_cost_element
7219: );
7220:
7221: if (x_return_status <> fnd_api.g_ret_sts_success) then
7222: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7223: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7224: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7225: FND_MESSAGE.set_token('TEXT', l_api_message);
7226: FND_MSG_pub.add;

Line 7231: FND_FILE.PUT_LINE(FND_FILE.LOG,'mfg cost_element: '|| to_char(l_cost_element));

7227: raise fnd_api.g_exc_unexpected_error;
7228: end if;
7229:
7230: if (l_debug = 'Y') then
7231: FND_FILE.PUT_LINE(FND_FILE.LOG,'mfg cost_element: '|| to_char(l_cost_element));
7232: end if;
7233:
7234: /* Bug 4321505 - Modified the dynamic update query to remove literals
7235: in the SQL and use bind variables instead. This is to make the SQL

Line 7401: fnd_file.put_line(fnd_file.log,'Insert into WT');

7397:
7398: -- Insert into Wip_transactions
7399: l_stmt_num := 20;
7400: if (l_debug = 'Y') then
7401: fnd_file.put_line(fnd_file.log,'Insert into WT');
7402: end if;
7403:
7404: /* Insert Currency_Actual_Resource_Rate also - Bug 2719622 */
7405:

Line 7530: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.insert_direct_item_txn: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));

7526: --
7527: WHEN OTHERS THEN
7528: ROLLBACK TO insert_direct_item_txn_PUB;
7529: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7530: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.insert_direct_item_txn: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
7531: --
7532: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
7533: THEN
7534: fnd_msg_pub.add_exc_msg

Line 8037: fnd_file.put_line(fnd_file.log,'enter-->');

8033:
8034: -------------------------------------------------------------------------
8035: -- Check Entity Type is eAM and that it has a Route Asset
8036: -------------------------------------------------------------------------
8037: fnd_file.put_line(fnd_file.log,'enter-->');
8038:
8039: fnd_file.put_line(fnd_file.log,'p_wcti_group_id: ' || to_char(p_wcti_group_id));
8040:
8041: for c_route_rec in c_route_assets(p_wcti_group_id)

Line 8039: fnd_file.put_line(fnd_file.log,'p_wcti_group_id: ' || to_char(p_wcti_group_id));

8035: -- Check Entity Type is eAM and that it has a Route Asset
8036: -------------------------------------------------------------------------
8037: fnd_file.put_line(fnd_file.log,'enter-->');
8038:
8039: fnd_file.put_line(fnd_file.log,'p_wcti_group_id: ' || to_char(p_wcti_group_id));
8040:
8041: for c_route_rec in c_route_assets(p_wcti_group_id)
8042:
8043: LOOP

Line 8044: fnd_file.put_line(fnd_file.log,'Route rec: txn:' || to_char(c_route_rec.transaction_id)

8040:
8041: for c_route_rec in c_route_assets(p_wcti_group_id)
8042:
8043: LOOP
8044: fnd_file.put_line(fnd_file.log,'Route rec: txn:' || to_char(c_route_rec.transaction_id)
8045: || ' Org:' || to_char(c_route_rec.organization_id)
8046: || ' WE:' || to_char(c_route_rec.wip_entity_id)
8047: || ' AcctPer: ' || to_char(c_route_rec.acct_period_id));
8048:

Line 8341: fnd_file.put_line(fnd_file.log,l_msg_data);

8337: );
8338: --
8339: WHEN fnd_api.g_exc_unexpected_error THEN
8340: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8341: fnd_file.put_line(fnd_file.log,l_msg_data);
8342:
8343: -- Get message count and data
8344: fnd_msg_pub.count_and_get
8345: ( p_count => x_msg_count

Line 8584: fnd_file.put_line(fnd_file.log, 'In get_CostEle_for_DirectItem');

8580: SAVEPOINT get_CostEle_for_DirectItem_PVT;
8581:
8582: l_debug := fnd_profile.value('MRP_DEBUG');
8583: if (l_debug = 'Y') THEN
8584: fnd_file.put_line(fnd_file.log, 'In get_CostEle_for_DirectItem');
8585: end if;
8586:
8587: ------------------------------------------------
8588: -- Standard call to check for API compatibility

Line 8867: fnd_file.put_line(fnd_file.log, 'In get_ExpType_for_DirectItem');

8863: SAVEPOINT get_ExpType_for_DirectItem_PVT;
8864:
8865: l_debug := fnd_profile.value('MRP_DEBUG');
8866: if (l_debug = 'Y') THEN
8867: fnd_file.put_line(fnd_file.log, 'In get_ExpType_for_DirectItem');
8868: end if;
8869:
8870: ------------------------------------------------
8871: -- Standard call to check for API compatibility