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.

[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on DPP_OUTPUT_XML_GT

Line 758: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,

754: ELSE
755: l_txn_subtype := 'PRICE_INCREASE';
756: END IF;
757:
758: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
759: NewPrice,
760: Currency,
761: Inventory_Org_Name,
762: inventory_item_id,

Line 782: UPDATE DPP_OUTPUT_XML_GT

778: l_item_cost_tbl(i).Reason_for_failure := 'Costing setup is not done or the cost is Zero for the item:'||l_item_cost_tbl(i).item_number ;
779: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Costing setup is not done or the cost is Zero for the item:'||l_item_cost_tbl(i).item_number);
780: l_return_status := FND_API.G_RET_STS_ERROR;
781:
782: UPDATE DPP_OUTPUT_XML_GT
783: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure
784: WHERE organization_id = Item_rec.organization_id
785: AND inventory_item_id = l_item_cost_tbl(i).inventory_item_id;
786:

Line 848: UPDATE DPP_OUTPUT_XML_GT

844: l_item_cost_tbl(i).Reason_for_failure := 'This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number;
845: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number);
846: l_return_status := FND_API.G_RET_STS_ERROR;
847:
848: UPDATE DPP_OUTPUT_XML_GT
849: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure
850: WHERE organization_id = Item_rec.organization_id
851: AND inventory_item_id = l_item_cost_tbl(i).inventory_item_id;
852:

Line 1028: UPDATE DPP_OUTPUT_XML_GT

1024: l_return_status := FND_API.G_RET_STS_ERROR;
1025: l_status_Update_tbl(i).update_status := 'N';
1026: l_item_cost_tbl(i).Reason_for_failure := 'OZFACCTG Workflow - Failure for item:'||l_item_cost_tbl(i).item_number||' Error Message: '||SUBSTR(l_errmsg,1,254);
1027:
1028: UPDATE DPP_OUTPUT_XML_GT
1029: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure
1030: WHERE organization_id = Item_rec.organization_id
1031: AND inventory_item_id = l_item_cost_tbl(i).inventory_item_id;
1032:

Line 1241: UPDATE DPP_OUTPUT_XML_GT

1237: END;
1238:
1239: IF l_dev_status IN ('WARNING','ERROR') THEN
1240: l_return_status := FND_API.g_ret_sts_error;
1241: UPDATE DPP_OUTPUT_XML_GT
1242: SET reason_for_failure = 'Std Cost Update Request ID: '||l_cost_upd_req_id||' '|| l_dev_phase||' with '||l_dev_status
1243: WHERE organization_id = Organization_Rec.organization_id;
1244:
1245: -- Flip the success flag to N for all items to enable resubmission

Line 1260: UPDATE DPP_OUTPUT_XML_GT

1256: ELSE
1257: l_return_status := FND_API.g_ret_sts_error;
1258: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status);
1259:
1260: UPDATE DPP_OUTPUT_XML_GT
1261: SET reason_for_failure = 'Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status;
1262:
1263: -- Flip the success flag to N for all items to enable resubmission
1264: FOR i IN l_status_Update_tbl.FIRST..l_status_Update_tbl.LAST

Line 1289: UPDATE DPP_OUTPUT_XML_GT

1285: AND Group_Id = l_Import_Cost_Group_Id
1286: AND Process_Flag = 3;
1287:
1288: FORALL indx IN inventory_item_ids.FIRST .. inventory_item_ids.LAST
1289: UPDATE DPP_OUTPUT_XML_GT
1290: SET reason_for_failure = error_explanations(indx)
1291: WHERE inventory_item_id = inventory_item_ids(indx);
1292:
1293:

Line 1333: UPDATE DPP_OUTPUT_XML_GT

1329: AND Transaction_Header_Id = l_txn_hdr_rec.Transaction_Header_Id
1330: AND Process_Flag = 3;
1331:
1332: FORALL indx IN source_line_ids.FIRST .. source_line_ids.LAST
1333: UPDATE DPP_OUTPUT_XML_GT
1334: SET reason_for_failure = error_explanations(indx)
1335: WHERE transaction_line_id = source_line_ids(indx);
1336:
1337: IF source_line_ids.COUNT > 0 THEN

Line 1388: DPP_OUTPUT_XML_GT dpp_gt

1384: transaction_line_ids,
1385: transaction_subtypes
1386: FROM
1387: mtl_material_transactions mmt,
1388: DPP_OUTPUT_XML_GT dpp_gt
1389: WHERE
1390: mmt.transaction_source_type_id = 13 -- Inventory
1391: AND mmt.source_line_id = l_txn_hdr_rec.Execution_Detail_ID
1392: AND mmt.transaction_type_id = l_transaction_type_id

Line 1440: DPP_OUTPUT_XML_GT dpp_gt

1436: transaction_subtypes
1437: FROM
1438: mtl_material_transactions mmt,
1439: cst_cost_updates ccu,
1440: DPP_OUTPUT_XML_GT dpp_gt
1441: WHERE
1442: mmt.transaction_source_id = ccu.cost_update_id
1443: AND mmt.transaction_source_type_id = 11
1444: AND mmt.transaction_action_id = l_transaction_action_id

Line 1507: --Get the output XML from DPP_OUTPUT_XML_GT table

1503:
1504: BEGIN
1505: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Status before generating output xml: ' || l_return_status);
1506:
1507: --Get the output XML from DPP_OUTPUT_XML_GT table
1508: l_Transaction_Number := '''' || l_txn_hdr_rec.Transaction_Number || '''';
1509:
1510: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
1511: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,

Line 1517: from DPP_OUTPUT_XML_GT

1513: inventory_org_name ORGNAME,
1514: NewPrice NEWPRICE,
1515: Currency CURRENCY,
1516: Reason_For_Failure REASON
1517: from DPP_OUTPUT_XML_GT
1518: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
1519: ELSE
1520: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1521: END IF;