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 314: fnd_file.put_line(fnd_file.log, 'calling Update_eamCost');

310: END;
311:
312: l_stmt_num := 30;
313: if (l_debug = 'Y') then
314: fnd_file.put_line(fnd_file.log, 'calling Update_eamCost');
315: end if;
316: Update_eamCost (
317: p_api_version => 1.0,
318: x_return_status => l_return_status,

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

332: p_login_id => p_login_id,
333: p_txn_date => l_txn_date);
334:
335: IF l_return_status <> FND_API.g_ret_sts_success THEN
336: FND_FILE.put_line(FND_FILE.log, x_msg_data);
337: l_api_message := 'Update_eamCost returned error';
338: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
339: FND_MESSAGE.set_token('TEXT', l_api_message);
340: FND_MSG_pub.add;

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

474: l_debug := fnd_profile.value('MRP_DEBUG');
475:
476:
477: if (l_debug = 'Y') THEN
478: fnd_file.put_line(fnd_file.log, 'In process_resCost');
479: end if;
480:
481:
482: -- Standard call to check for call compatibility

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

521: l_res_seq_num := l_resourcetxn_rec.resource_seq_num;
522: END IF;
523:
524: if (l_debug = 'Y') THEN
525: fnd_file.put_line(fnd_file.log, 'l_txn_mode: ' || to_char(l_txn_mode));
526: end if;
527:
528: l_stmt_num := 50;
529: Update_eamCost (

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

547: p_login_id => p_login_id,
548: p_txn_date => l_resourcetxn_rec.txn_date);
549:
550: IF l_return_status <> FND_API.g_ret_sts_success THEN
551: FND_FILE.put_line(FND_FILE.log, x_msg_data);
552: l_api_message := 'Update_eamCost returned error';
553: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
554: FND_MESSAGE.set_token('TEXT', l_api_message);
555: FND_MSG_pub.add;

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

716: SAVEPOINT Update_eamCost_PUB;
717: l_debug := fnd_profile.value('MRP_DEBUG');
718:
719: if (l_debug = 'Y') then
720: fnd_file.put_line(fnd_file.log, 'In Update_eamCost');
721: end if;
722:
723: -- Standard call to check for call compatibility
724: IF NOT FND_API.Compatible_API_Call (

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

749: FND_MSG_PUB.ADD;
750: RAISE FND_API.g_exc_error;
751: END IF;
752:
753: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing job '
754: || to_char(p_wip_entity_id));
755:
756:
757: -- Process only job with eAM wip entity type

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

809: x_cost_element_id => l_eam_cost_element
810: );
811:
812: if (l_return_status <> fnd_api.g_ret_sts_success) then
813: FND_FILE.put_line(FND_FILE.log, x_msg_data);
814: l_api_message := 'get_CostElement_for_DirectItem returned unexpected error';
815: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
816: FND_MESSAGE.set_token('TEXT', l_api_message);
817: FND_MSG_pub.add;

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

818: raise fnd_api.g_exc_unexpected_error;
819: end if;
820:
821: if (l_debug = 'Y') then
822: FND_FILE.PUT_LINE(FND_FILE.LOG,'eam_cost_element_id: '|| to_char(l_eam_cost_element));
823: end if;
824:
825: else /* p_txn_mode in (1,2,3) */
826: l_eam_cost_element := Get_eamCostElement(p_txn_mode,p_org_id,p_resource_id);

Line 851: fnd_file.put_line(fnd_file.log, 'l_check_category'||l_check_category);

847: FROM bom_departments
848: WHERE department_id = l_owning_dept_id;
849:
850: IF(l_debug = 'Y')THEN
851: fnd_file.put_line(fnd_file.log, 'l_check_category'||l_check_category);
852: END IF;
853:
854: IF(l_check_category=1) THEN
855:

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

878: l_stmt_num := 80;
879: l_return_status := FND_API.G_RET_STS_SUCCESS;
880:
881: if (l_debug = 'Y') then
882: fnd_file.put_line(fnd_file.log, 'Getting maint Cost_category');
883: end if;
884:
885: Get_MaintCostCat(
886: p_txn_mode,

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

893: x_owning_dept => l_owning_dept_id,
894: x_maint_cost_cat => l_maint_cost_category);
895:
896: IF l_return_status <> FND_API.g_ret_sts_success THEN
897: FND_FILE.put_line(FND_FILE.log, x_msg_data);
898: l_api_message := 'Get_MaintCostCat returned error';
899: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
900: FND_MESSAGE.set_token('TEXT', l_api_message);
901: FND_MSG_pub.add;

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

904:
905: END IF; -- end checking p_txn_mode
906:
907: if (l_debug = 'Y') then
908: fnd_file.put_line(fnd_file.log, 'Calling insertUpdate_EamPerBal');
909: end if;
910:
911: -- Insert/update WIP_EAM_PERIOD_BALANCES
912: l_stmt_num := 120;

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

936: p_login_id => p_login_id,
937: p_txn_date => p_txn_date);
938:
939: IF l_return_status <> FND_API.g_ret_sts_success THEN
940: FND_FILE.put_line(FND_FILE.log, x_msg_data);
941: l_api_message := 'InsertUpdate_eamPerBal returned error';
942: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
943: FND_MESSAGE.set_token('TEXT', l_api_message);
944: FND_MSG_pub.add;

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

957:
958:
959: EXCEPTION
960: WHEN FND_API.g_exc_error THEN
961: FND_FILE.PUT_LINE(fnd_file.log,'1 exception ' || SQLERRM );
962: ROLLBACK TO Update_eamCost_PUB;
963: x_return_status := FND_API.g_ret_sts_error;
964:
965: -- Get message count and data

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

968: , p_data => x_msg_data
969: );
970:
971: WHEN FND_API.g_exc_unexpected_error THEN
972: FND_FILE.PUT_LINE(fnd_file.log,'1 exception ' || SQLERRM );
973: ROLLBACK TO Update_eamCost_PUB;
974: x_return_status := FND_API.g_ret_sts_unexp_error ;
975:
976: -- Get message count and data

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

979: , p_data => x_msg_data
980: );
981:
982: WHEN OTHERS THEN
983: fnd_file.put_line(fnd_file.log, 'Exception in Update_eamcost'|| SQLERRM);
984: ROLLBACK TO Update_eamCost_PUB;
985: x_return_status := fnd_api.g_ret_sts_unexp_error ;
986:
987: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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

1132: SAVEPOINT InsertUpdate_eamPerBal_PUB;
1133: l_debug := fnd_profile.value('MRP_DEBUG');
1134:
1135: if (l_debug = 'Y') then
1136: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_eamPerBal');
1137: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
1138: end if;
1139:
1140: -- Standard call to check for call compatibility

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

1133: l_debug := fnd_profile.value('MRP_DEBUG');
1134:
1135: if (l_debug = 'Y') then
1136: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_eamPerBal');
1137: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
1138: end if;
1139:
1140: -- Standard call to check for call compatibility
1141: IF NOT FND_API.Compatible_API_Call (

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

1301: ELSE
1302: l_stmt_num := 160;
1303:
1304: if (l_debug = 'Y') then
1305: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1306: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1307: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1308: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );

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

1302: l_stmt_num := 160;
1303:
1304: if (l_debug = 'Y') then
1305: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1306: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1307: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1308: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1310: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));

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

1303:
1304: if (l_debug = 'Y') then
1305: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1306: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1307: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1308: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1310: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1311: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );

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

1304: if (l_debug = 'Y') then
1305: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1306: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1307: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1308: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1310: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1311: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1312: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );

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

1305: FND_FILE.PUT_LINE(fnd_file.log,'Inserting wip_eam_period_balances....');
1306: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1307: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1308: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1310: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1311: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1312: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1313: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );

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

1306: FND_FILE.PUT_LINE(fnd_file.log,'period_Setname: '|| l_period_set_name );
1307: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1308: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1310: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1311: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1312: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1313: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );
1314: end if;

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

1307: FND_FILE.PUT_LINE(fnd_file.log,'period_name: '||l_period_name );
1308: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1310: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1311: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1312: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1313: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );
1314: end if;
1315:

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

1308: FND_FILE.PUT_LINE(fnd_file.log,'acct_period_id: '||to_char( l_period_id) );
1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1310: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1311: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1312: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1313: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );
1314: end if;
1315:
1316:

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

1309: FND_FILE.PUT_LINE(fnd_file.log,'owning_dept_id: '||to_char(p_owning_dept_id) );
1310: FND_FILE.PUT_LINE(fnd_file.log,'op dept_id: '||to_char(p_dept_id ));
1311: FND_FILE.PUT_LINE(fnd_file.log,'op_seq_num: '||to_char(p_opseq_num) );
1312: FND_FILE.PUT_LINE(fnd_file.log,'COST_category: '|| to_char( p_maint_cost_cat) );
1313: FND_FILE.PUT_LINE(fnd_file.log,'asset group id: '|| to_char( p_asset_group_id) );
1314: end if;
1315:
1316:
1317: INSERT INTO wip_eam_period_balances (

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

1372: p_prog_app_id,
1373: p_prog_id
1374: );
1375: if (l_debug = 'Y') then
1376: fnd_file.put_line(fnd_file.log, 'Inserted into wepb');
1377: end if;
1378:
1379: END IF; -- end checking job balance row
1380:

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

1415: ---------------------------------------
1416: -- Check for Asset route
1417: ---------------------------------------
1418: if (l_route_asset = 'Y') then
1419: fnd_file.put_line(fnd_file.log,'txn date: ' || p_txn_date);
1420:
1421: l_stmt_num := 164;
1422:
1423: /* Pick up the member asset route information from EAM_WORK_ORDER_ROUTE

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

1548:
1549: end if;
1550:
1551: if (l_debug = 'Y') then
1552: FND_FILE.PUT_LINE(fnd_file.log,'inserted into cst_eam_asset_per_balances' );
1553: end if;
1554:
1555: -- Standard check of p_commit
1556: IF FND_API.to_Boolean(p_commit) THEN

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

1564:
1565: EXCEPTION
1566:
1567: WHEN FND_API.g_exc_error THEN
1568: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );
1569: ROLLBACK TO InsertUpdate_eamPerBal_PUB;
1570: x_return_status := FND_API.g_ret_sts_error;
1571:
1572: -- Get message count and data

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

1575: , p_data => x_msg_data
1576: );
1577:
1578: WHEN FND_API.g_exc_unexpected_error THEN
1579: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );
1580: ROLLBACK TO InsertUpdate_eamPerBal_PUB;
1581: x_return_status := FND_API.g_ret_sts_unexp_error ;
1582:
1583: -- Get message count and data

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

1586: , p_data => x_msg_data
1587: );
1588:
1589: WHEN OTHERS THEN
1590: FND_FILE.PUT_LINE(fnd_file.log,'exception' || SQLERRM );
1591: ROLLBACK TO InsertUpdate_eamPerBal_PUB;
1592: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1593:
1594: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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

1699: SAVEPOINT InsertUpdate_assetPerBal_PUB;
1700: l_debug := fnd_profile.value('MRP_DEBUG');
1701:
1702: if (l_debug = 'Y') then
1703: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_assetPerBal');
1704: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
1705: end if;
1706:
1707: -- Standard call to check for call compatibility

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

1700: l_debug := fnd_profile.value('MRP_DEBUG');
1701:
1702: if (l_debug = 'Y') then
1703: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_assetPerBal');
1704: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
1705: end if;
1706:
1707: -- Standard call to check for call compatibility
1708: IF NOT FND_API.Compatible_API_Call (

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

1825:
1826: EXCEPTION
1827:
1828: WHEN FND_API.g_exc_error THEN
1829: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );
1830: ROLLBACK TO InsertUpdate_assetPerBal_PUB;
1831: x_return_status := FND_API.g_ret_sts_error;
1832: -- Get message count and data
1833: FND_MSG_PUB.count_and_get

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

1835: , p_data => x_msg_data
1836: );
1837:
1838: WHEN FND_API.g_exc_unexpected_error THEN
1839: FND_FILE.PUT_LINE(fnd_file.log,' exception' || SQLERRM );
1840: ROLLBACK TO InsertUpdate_assetPerBal_PUB;
1841: x_return_status := FND_API.g_ret_sts_unexp_error ;
1842:
1843: -- Get message count and data

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

1846: , p_data => x_msg_data
1847: );
1848:
1849: WHEN OTHERS THEN
1850: FND_FILE.PUT_LINE(fnd_file.log,'exception' || SQLERRM );
1851: ROLLBACK TO InsertUpdate_assetPerBal_PUB;
1852: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1853:
1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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

1905:
1906: l_debug := fnd_profile.value('MRP_DEBUG');
1907:
1908: if (l_debug = 'Y') THEN
1909: fnd_file.put_line(fnd_file.log, 'In Get_eamCostElement');
1910: end if;
1911:
1912:
1913: IF p_txn_mode = 1 THEN -- material

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

1933: END IF; -- end checking resource type
1934: END IF; -- end checking txn mode
1935:
1936: if (l_debug = 'Y') THEN
1937: fnd_file.put_line(fnd_file.log, 'l_eam_cost_element: '|| to_char(l_eam_cost_element));
1938: fnd_file.put_line(fnd_file.log, 'resource id: '|| to_char(p_resource_id));
1939: end if;
1940:
1941: RETURN l_eam_cost_element;

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

1934: END IF; -- end checking txn mode
1935:
1936: if (l_debug = 'Y') THEN
1937: fnd_file.put_line(fnd_file.log, 'l_eam_cost_element: '|| to_char(l_eam_cost_element));
1938: fnd_file.put_line(fnd_file.log, 'resource id: '|| to_char(p_resource_id));
1939: end if;
1940:
1941: RETURN l_eam_cost_element;
1942:

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

1941: RETURN l_eam_cost_element;
1942:
1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: FND_FILE.PUT_LINE(FND_FILE.LOG,'Get_eamCostElement - statement '
1946: || l_stmt_num || ': '
1947: || substr(SQLERRM,1,200));
1948:
1949: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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

2145: */
2146:
2147: EXCEPTION
2148: WHEN OTHERS THEN
2149: FND_FILE.PUT_LINE(FND_FILE.LOG,'Get_MaintCostCat - statement '
2150: || l_stmt_num || ': '
2151: || substr(SQLERRM,1,200));
2152: x_return_status := FND_API.g_ret_sts_unexp_error ;
2153:

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

2631: WHEN OTHERS THEN
2632: ROLLBACK TO Delete_eamPerBal_PUB;
2633: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2634:
2635: FND_FILE.PUT_LINE(FND_FILE.LOG,'Delete_eamPerBal - statement '
2636: || l_stmt_num || ': '
2637: || substr(SQLERRM,1,200));
2638:
2639: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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

5931: SAVEPOINT check_if_direct_item_PUB;
5932: l_debug := fnd_profile.value('MRP_DEBUG');
5933:
5934: if (l_debug = 'Y') then
5935: FND_FILE.PUT_LINE(fnd_file.log,'Check if direct item');
5936: end if;
5937:
5938: -- Standard call to check for call compatibility
5939: IF NOT FND_API.Compatible_API_Call (

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

5964: -- instead of interface_transaction_id. Get the interface_transaction_id from rcv_transactions.
5965: l_stmt_num := 25;
5966:
5967: if(l_debug = 'Y') then
5968: fnd_file.put_line(fnd_file.log,'RCV transaction ID : '||p_interface_txn_id);
5969: end if;
5970:
5971: SELECT interface_transaction_id
5972: INTO l_interface_txn_id

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

5977: RAISE fnd_api.g_exc_error;
5978: END IF;
5979:
5980: if(l_debug = 'Y') then
5981: fnd_file.put_line(fnd_file.log,'Interface Txn ID : '||l_interface_txn_id);
5982: end if;
5983:
5984: -- Obtain wip entity, organization and item ID for the receiving transaction
5985: l_stmt_num := 30;

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

5992: FROM rcv_transactions_interface
5993: WHERE interface_transaction_id = l_interface_txn_id;
5994:
5995: if (l_debug = 'Y') then
5996: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));
5997: fnd_file.put_line(fnd_file.log,'item: ' || to_char(l_item_id));
5998: fnd_file.put_line(fnd_file.log,'to_org: ' || to_char(l_org_id));
5999: end if;
6000:

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

5993: WHERE interface_transaction_id = l_interface_txn_id;
5994:
5995: if (l_debug = 'Y') then
5996: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));
5997: fnd_file.put_line(fnd_file.log,'item: ' || to_char(l_item_id));
5998: fnd_file.put_line(fnd_file.log,'to_org: ' || to_char(l_org_id));
5999: end if;
6000:
6001: -- Get EAM enabled flag for organization

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

5994:
5995: if (l_debug = 'Y') then
5996: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));
5997: fnd_file.put_line(fnd_file.log,'item: ' || to_char(l_item_id));
5998: fnd_file.put_line(fnd_file.log,'to_org: ' || to_char(l_org_id));
5999: end if;
6000:
6001: -- Get EAM enabled flag for organization
6002: l_stmt_num := 40;

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

6005: FROM mtl_parameters
6006: WHERE organization_id = l_org_id;
6007:
6008: if (l_debug = 'Y') then
6009: fnd_file.put_line(fnd_file.log,'EAM flag: ' || l_eam_flag);
6010: end if;
6011:
6012: -- Get entity type for the job
6013: l_stmt_num := 50;

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

6016: FROM wip_entities
6017: WHERE wip_entity_id = l_wip_entity_id;
6018:
6019: if (l_debug = 'Y') then
6020: fnd_file.put_line(fnd_file.log,'Entity: ' || to_char(l_entity_type));
6021: end if;
6022:
6023: -- Validate organization and entity type
6024: l_stmt_num := 60;

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

6027: ELSE
6028: -- Check for Item ID
6029: l_stmt_num := 70;
6030: if (l_debug = 'Y') then
6031: fnd_file.put_line(fnd_file.log,'EAM job!');
6032: end if;
6033:
6034: IF (l_item_id IS NULL) THEN
6035: x_direct_item_flag := 1;

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

6041: WHERE inventory_item_id = l_item_id
6042: AND organization_id = l_org_id;
6043:
6044: if (l_debug = 'Y') then
6045: fnd_file.put_line(fnd_file.log,'osp flag : ' || l_osp_item);
6046: end if;
6047:
6048: IF (l_osp_item = 'N') THEN
6049: x_direct_item_flag := 1;

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

6053: END IF; /* check for NULL item_id */
6054: END IF; /* Organization and job are of EAM type */
6055:
6056: if (l_debug = 'Y') then
6057: fnd_file.put_line(fnd_file.log,'Direct item flag : ' || to_char(x_direct_item_flag));
6058: end if;
6059:
6060: -- Standard check of p_commit
6061: IF FND_API.to_Boolean(p_commit) THEN

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

6224: l_stmt_num := 25;
6225:
6226: l_txn_id := l_directItem_rec.rcv_transaction_id;
6227: if(l_debug = 'Y') then
6228: fnd_file.put_line(fnd_file.log,'RCV transaction ID : '||l_txn_id);
6229: end if;
6230:
6231: /* Modified quantity to source_doc_quantity for bug 3253815. When the
6232: receipt UOM is different from the UOM on the PO, using quantity

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

6245: -- instead of rcv_transaction_id
6246: -- l_directItem_rec.rcv_transaction_id := l_interface_txn_id;
6247:
6248: if (l_debug = 'Y') then
6249: fnd_file.put_line(fnd_file.log,'Interface txn ID : '
6250: || to_char(l_interface_txn_id));
6251: end if;
6252:
6253:

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

6381: l_curr_rate := l_directItem_rec.currency_conversion_rate;
6382: l_curr_code := l_directItem_rec.currency_code;
6383:
6384: if (l_debug = 'Y') then
6385: fnd_file.put_line(fnd_file.log,'Actual resource rate: ' || to_char(l_actual_res_rate) ||
6386: 'Currency Conv rate : ' ||to_char(l_curr_rate)||
6387: 'Order Type Lookup Code : ' ||to_char( l_po_order_type_lookup_code));
6388: end if;
6389:

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

6471: l_actual_res_rate := l_actual_res_rate * (l_quantity/l_directItem_rec.primary_quantity);
6472: END IF;
6473:
6474: if (l_debug = 'Y') then
6475: fnd_file.put_line(fnd_file.log,'Actual resource rate: ' || to_char(l_actual_res_rate));
6476: end if;
6477:
6478: l_directItem_rec.actual_resource_rate := l_actual_res_rate * l_curr_rate;
6479: l_directItem_rec.usage_rate_or_amount := l_actual_res_rate * l_curr_rate;

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

6567: and muom.base_uom_flag(+) = 'Y'
6568: and muom.language(+) = userenv('LANG'); */
6569:
6570: if (l_debug = 'Y') then
6571: fnd_file.put_line(fnd_file.log,'Populated direct item record for job ' || to_char(l_directItem_rec.wip_entity_id));
6572: end if;
6573:
6574:
6575: -- Obtain PO transaction type

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

6578: from rcv_transactions_interface
6579: where interface_transaction_id = l_interface_txn_id;
6580:
6581: if (l_debug = 'Y') then
6582: fnd_file.put_line(fnd_file.log,'PO txn type is ' || l_po_txn_type);
6583: end if;
6584:
6585: -- Update sign on primary quantity
6586: l_stmt_num := 45;

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

6592: l_directItem_rec.transaction_quantity := -1 * abs(l_directItem_rec.transaction_quantity);
6593:
6594: end if;
6595: if (l_debug = 'Y') then
6596: fnd_file.put_line(fnd_file.log,'Primary quantity: ' || to_char(l_directItem_rec.primary_quantity));
6597: end if;
6598:
6599: -- Get WE details
6600: l_stmt_num := 50;

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

6607: from wip_entities
6608: where wip_entity_id = l_directItem_rec.wip_entity_id;
6609:
6610: if (l_debug = 'Y') then
6611: fnd_file.put_line(fnd_file.log,'Job Name : ' || l_directItem_rec.wip_entity_name);
6612: end if;
6613:
6614: -- Get Department details
6615: l_stmt_num := 60;

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

6623: and wo.operation_seq_num = l_directItem_rec.operation_seq_num
6624: and wo.organization_id = l_directItem_rec.organization_id
6625: and bd.department_id = wo.department_id;
6626: if (l_debug = 'Y') then
6627: fnd_file.put_line(fnd_file.log,'Dept Code : ' || l_directitem_rec.department_code);
6628: end if;
6629:
6630: -- Default other attributes
6631: l_stmt_num := 70;

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

6633: into l_directItem_rec.created_by_name
6634: from fnd_user
6635: where user_id = l_directItem_rec.created_by;
6636: if (l_debug = 'Y') then
6637: fnd_file.put_line(fnd_file.log,'user name : ' || l_directItem_rec.created_by_name);
6638: end if;
6639:
6640: l_stmt_num := 80;
6641: select user_name

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

6642: into l_directItem_rec.last_updated_by_name
6643: from fnd_user
6644: where user_id = l_directItem_rec.last_updated_by;
6645: if (l_debug = 'Y') then
6646: fnd_file.put_line(fnd_file.log,'updated by ' || l_directItem_rec.last_updated_by);
6647: end if;
6648:
6649: l_stmt_num := 90;
6650: select organization_code

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

6651: into l_directItem_rec.organization_code
6652: from mtl_parameters
6653: where organization_id = l_directItem_rec.organization_id;
6654: if (l_debug = 'Y') then
6655: fnd_file.put_line(fnd_file.log,'organization code ' || l_directItem_rec.organization_code);
6656: end if;
6657:
6658: l_stmt_num := 100;
6659: if (l_directItem_rec.reason_id IS NOT NULL) then

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

6661: into l_directItem_rec.reason_name
6662: from mtl_transaction_reasons
6663: where reason_id = l_directItem_rec.reason_id;
6664: if (l_debug = 'Y') then
6665: fnd_file.put_line(fnd_file.log,'reason name ' || l_directItem_rec.reason_name);
6666: end if;
6667: end if;
6668:
6669:

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

6684: x_msg_data => l_msg_data
6685: );
6686:
6687: IF l_return_status <> FND_API.g_ret_sts_success THEN
6688: FND_FILE.put_line(FND_FILE.log, l_msg_data);
6689: l_api_message := 'WIP_EAM_RESOURCE_TRANSACTION.WIP_EAMRCVDIRECTITEM_HOOK returned error';
6690: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6691: FND_MESSAGE.set_token('TEXT', l_api_message);
6692: FND_MSG_pub.add;

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

6863: -- Loop through all direct item transactions
6864: FOR direct_item_txn_rec IN direct_item_txn_cur LOOP
6865:
6866: if (l_debug = 'Y') then
6867: fnd_file.put_line(fnd_file.log,'Transaction ID ' || to_char(direct_item_txn_rec.transaction_id));
6868: end if;
6869: /* Organization_id is the same for the entire group */
6870: l_organization_id := direct_item_txn_rec.organization_id;
6871:

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

6918: l_acct_line_type := 5;
6919: end if;
6920:
6921: if (l_debug = 'Y') then
6922: fnd_file.put_line(fnd_file.log,'Transaction value ' || to_char(l_txn_value));
6923: fnd_file.put_line(fnd_file.log,'Base Transaction value ' || to_char(l_base_txn_value));
6924: fnd_file.put_line(fnd_file.log,'Quantity ' || to_char(direct_item_txn_rec.qty));
6925: end if;
6926:

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

6919: end if;
6920:
6921: if (l_debug = 'Y') then
6922: fnd_file.put_line(fnd_file.log,'Transaction value ' || to_char(l_txn_value));
6923: fnd_file.put_line(fnd_file.log,'Base Transaction value ' || to_char(l_base_txn_value));
6924: fnd_file.put_line(fnd_file.log,'Quantity ' || to_char(direct_item_txn_rec.qty));
6925: end if;
6926:
6927: l_stmt_num := 80;

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

6920:
6921: if (l_debug = 'Y') then
6922: fnd_file.put_line(fnd_file.log,'Transaction value ' || to_char(l_txn_value));
6923: fnd_file.put_line(fnd_file.log,'Base Transaction value ' || to_char(l_base_txn_value));
6924: fnd_file.put_line(fnd_file.log,'Quantity ' || to_char(direct_item_txn_rec.qty));
6925: end if;
6926:
6927: l_stmt_num := 80;
6928: if (l_debug = 'Y') then

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

6925: end if;
6926:
6927: l_stmt_num := 80;
6928: if (l_debug = 'Y') then
6929: fnd_file.put_line(fnd_file.log,'Insert RI account ' || to_char(direct_item_txn_rec.rcv_acct_id));
6930: end if;
6931:
6932: -- Insert line for receiving inspection if it's not an IPV transfer
6933: -- Insert line for account (adjusment account) if it's an IPV transfer

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

7012: x_cost_element_id => l_cost_element
7013: );
7014:
7015: if (l_return_status <> fnd_api.g_ret_sts_success) then
7016: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7017: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7018: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7019: FND_MESSAGE.set_token('TEXT', l_api_message);
7020: FND_MSG_pub.add;

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

7021: raise fnd_api.g_exc_unexpected_error;
7022: end if;
7023:
7024: if (l_debug = 'Y') then
7025: FND_FILE.PUT_LINE(FND_FILE.LOG, 'mfg cost_element_id: '|| to_char(l_cost_element));
7026: end if;
7027:
7028: select decode(l_cost_element, 1, nvl(material_account,-1),
7029: 3, nvl(resource_account, -1),

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

7034:
7035: l_stmt_num := 100;
7036: -- Insert line for WIP valuation
7037: if (l_debug = 'Y') then
7038: fnd_file.put_line(fnd_file.log,'Insert WIP material acct ' || to_char(l_wip_acct));
7039: end if;
7040:
7041:
7042: insert_direct_item_distr (

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

7065:
7066: -- Update wip period balances , pl_material_in
7067: l_stmt_num := 110;
7068: if (l_debug = 'Y') then
7069: fnd_file.put_line(fnd_file.log,'Update wip_period_balances');
7070: end if;
7071:
7072: update_wip_period_balances (
7073: p_api_version => 1.0,

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

7090:
7091: -- update wip_eam_asset_per_balances material cost
7092: l_stmt_num := 120;
7093: if (l_debug = 'Y') then
7094: fnd_file.put_line(fnd_file.log,'Update eamcost');
7095: end if;
7096:
7097: update_eamCost (
7098: p_api_version => 1.0,

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

7124:
7125: /* insert_direct_item_txn */
7126: l_stmt_num := 130;
7127: if (l_debug = 'Y') then
7128: fnd_file.put_line(fnd_file.log,'Insert direct item transaction');
7129: end if;
7130: insert_direct_item_txn (
7131: p_api_version => 1.0,
7132: p_group_id => p_group_id,

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

7163: END IF;
7164:
7165: l_stmt_num := 140;
7166: if (l_debug = 'Y') then
7167: fnd_file.put_line(fnd_file.log,'Delete from wcti');
7168: end if;
7169: delete from wip_cost_txn_interface
7170: where group_id = p_group_id
7171: and process_status = 2;

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

7206: --
7207: WHEN OTHERS THEN
7208: ROLLBACK TO cost_direct_item_txn_PUB;
7209: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7210: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.cost_direct_item_txn: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
7211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
7212: THEN
7213: fnd_msg_pub.add_exc_msg
7214: ( 'CST_eamCost_PUB'

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

7395: END IF; /* p_acct_line_type = 15 */
7396:
7397:
7398: if (l_debug = 'Y') then
7399: fnd_file.put_line(fnd_file.log,'Txn value: ' || to_char(l_txn_value));
7400: fnd_file.put_line(fnd_file.log,'Base txn value: ' || to_char(l_base_txn_value));
7401: end if;
7402:
7403:

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

7396:
7397:
7398: if (l_debug = 'Y') then
7399: fnd_file.put_line(fnd_file.log,'Txn value: ' || to_char(l_txn_value));
7400: fnd_file.put_line(fnd_file.log,'Base txn value: ' || to_char(l_base_txn_value));
7401: end if;
7402:
7403:
7404: /* Bug 9356654 WIP Encumbrance enhancement

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

7421: x_cost_element_id => l_cost_element
7422: );
7423:
7424: if (l_return_status <> fnd_api.g_ret_sts_success) then
7425: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7426: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7427: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7428: FND_MESSAGE.set_token('TEXT', l_api_message);
7429: FND_MSG_pub.add;

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

7430: raise fnd_api.g_exc_unexpected_error;
7431: end if;
7432:
7433: if (l_debug = 'Y') then
7434: FND_FILE.PUT_LINE(FND_FILE.LOG,'mfg cost_element_id: '|| to_char(l_cost_element));
7435: end if;
7436:
7437: END IF; --p_acct_line_type <> 15
7438:

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

7637: --
7638: WHEN OTHERS THEN
7639: ROLLBACK TO insert_direct_item_distr_PUB;
7640: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7641: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.insert_direct_item_distr(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
7642: --
7643: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
7644: THEN
7645: fnd_msg_pub.add_exc_msg

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

7771: x_cost_element_id => l_cost_element
7772: );
7773:
7774: if (x_return_status <> fnd_api.g_ret_sts_success) then
7775: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7776: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7777: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7778: FND_MESSAGE.set_token('TEXT', l_api_message);
7779: FND_MSG_pub.add;

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

7780: raise fnd_api.g_exc_unexpected_error;
7781: end if;
7782:
7783: if (l_debug = 'Y') then
7784: FND_FILE.PUT_LINE(FND_FILE.LOG,'mfg cost_element: '|| to_char(l_cost_element));
7785: end if;
7786:
7787: /* Bug 4321505 - Modified the dynamic update query to remove literals
7788: in the SQL and use bind variables instead. This is to make the SQL

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

7950:
7951: -- Insert into Wip_transactions
7952: l_stmt_num := 20;
7953: if (l_debug = 'Y') then
7954: fnd_file.put_line(fnd_file.log,'Insert into WT');
7955: end if;
7956:
7957: /* Insert Currency_Actual_Resource_Rate also - Bug 2719622 */
7958:

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

8099: --
8100: WHEN OTHERS THEN
8101: ROLLBACK TO insert_direct_item_txn_PUB;
8102: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8103: fnd_file.put_line(fnd_file.log,'CST_eamCost_PUB.insert_direct_item_txn: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
8104: --
8105: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
8106: THEN
8107: fnd_msg_pub.add_exc_msg

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

8606:
8607: -------------------------------------------------------------------------
8608: -- Check Entity Type is eAM and that it has a Route Asset
8609: -------------------------------------------------------------------------
8610: fnd_file.put_line(fnd_file.log,'enter-->');
8611:
8612: fnd_file.put_line(fnd_file.log,'p_wcti_group_id: ' || to_char(p_wcti_group_id));
8613:
8614: for c_route_rec in c_route_assets(p_wcti_group_id)

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

8608: -- Check Entity Type is eAM and that it has a Route Asset
8609: -------------------------------------------------------------------------
8610: fnd_file.put_line(fnd_file.log,'enter-->');
8611:
8612: fnd_file.put_line(fnd_file.log,'p_wcti_group_id: ' || to_char(p_wcti_group_id));
8613:
8614: for c_route_rec in c_route_assets(p_wcti_group_id)
8615:
8616: LOOP

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

8613:
8614: for c_route_rec in c_route_assets(p_wcti_group_id)
8615:
8616: LOOP
8617: fnd_file.put_line(fnd_file.log,'Route rec: txn:' || to_char(c_route_rec.transaction_id)
8618: || ' Org:' || to_char(c_route_rec.organization_id)
8619: || ' WE:' || to_char(c_route_rec.wip_entity_id)
8620: || ' AcctPer: ' || to_char(c_route_rec.acct_period_id));
8621:

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

8910: );
8911: --
8912: WHEN fnd_api.g_exc_unexpected_error THEN
8913: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8914: fnd_file.put_line(fnd_file.log,l_msg_data);
8915:
8916: -- Get message count and data
8917: fnd_msg_pub.count_and_get
8918: ( p_count => x_msg_count

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

9156: SAVEPOINT get_CostEle_for_DirectItem_PVT;
9157:
9158: l_debug := fnd_profile.value('MRP_DEBUG');
9159: if (l_debug = 'Y') THEN
9160: fnd_file.put_line(fnd_file.log, 'In get_CostEle_for_DirectItem');
9161: end if;
9162:
9163: ------------------------------------------------
9164: -- Standard call to check for API compatibility

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

9502: SAVEPOINT get_ExpType_for_DirectItem_PVT;
9503:
9504: l_debug := fnd_profile.value('MRP_DEBUG');
9505: if (l_debug = 'Y') THEN
9506: fnd_file.put_line(fnd_file.log, 'In get_ExpType_for_DirectItem');
9507: end if;
9508:
9509: ------------------------------------------------
9510: -- Standard call to check for API compatibility

Line 9663: fnd_file.put_line(fnd_file.log, 'No expenditure type found in category associations');

9659: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9660: l_statement := 90;
9661: if (l_expenditure_type = to_char(-1)) then
9662: if (l_debug = 'Y') THEN
9663: fnd_file.put_line(fnd_file.log, 'No expenditure type found in category associations');
9664: fnd_file.put_line(fnd_file.log, 'Deriving expenditure type from Project Parameters');
9665: end if;
9666: begin
9667: select ppp.dir_item_expenditure_type

Line 9664: fnd_file.put_line(fnd_file.log, 'Deriving expenditure type from Project Parameters');

9660: l_statement := 90;
9661: if (l_expenditure_type = to_char(-1)) then
9662: if (l_debug = 'Y') THEN
9663: fnd_file.put_line(fnd_file.log, 'No expenditure type found in category associations');
9664: fnd_file.put_line(fnd_file.log, 'Deriving expenditure type from Project Parameters');
9665: end if;
9666: begin
9667: select ppp.dir_item_expenditure_type
9668: into l_expenditure_type

Line 9686: fnd_file.put_line(fnd_file.log, 'No expenditure type found in Project Parameters');

9682: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9683: l_statement := 100;
9684: if (l_expenditure_type = to_char(-1)) then
9685: if (l_debug = 'Y') THEN
9686: fnd_file.put_line(fnd_file.log, 'No expenditure type found in Project Parameters');
9687: fnd_file.put_line(fnd_file.log, 'Deriving expenditure type from PJM Org Parameters');
9688: end if;
9689: begin
9690: select pop.dir_item_expenditure_type

Line 9687: fnd_file.put_line(fnd_file.log, 'Deriving expenditure type from PJM Org Parameters');

9683: l_statement := 100;
9684: if (l_expenditure_type = to_char(-1)) then
9685: if (l_debug = 'Y') THEN
9686: fnd_file.put_line(fnd_file.log, 'No expenditure type found in Project Parameters');
9687: fnd_file.put_line(fnd_file.log, 'Deriving expenditure type from PJM Org Parameters');
9688: end if;
9689: begin
9690: select pop.dir_item_expenditure_type
9691: into l_expenditure_type

Line 9697: fnd_file.put_line(fnd_file.log, 'No expenditure type found, transaction will error out');

9693: where pop.organization_id = l_organization_id;
9694: exception
9695: when no_data_found then
9696: if (l_debug = 'Y') THEN
9697: fnd_file.put_line(fnd_file.log, 'No expenditure type found, transaction will error out');
9698: end if;
9699: l_expenditure_type := to_char(-1);
9700: l_api_message := 'No expenditure type has been setup in the category, project prameters';
9701: l_api_message := l_api_message || ' or project organization parameters';