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.DPP_ITEMCOST_PVT dependencies on DPP_UTILITY_PVT

Line 233: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start at: '||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

229: END IF;
230:
231: -- Debug Message
232: IF g_debug THEN
233: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start at: '||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
234: END IF;
235:
236: -- Initialize API return status to sucess
237: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 276: DPP_UTILITY_PVT.debug_message('After mandatory checks:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
275: IF G_DEBUG THEN
276: DPP_UTILITY_PVT.debug_message('After mandatory checks:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
277: END IF;
278:
279: l_bg_process_mode := nvl(fnd_profile.value('DPP_ACCT_GEN_USE_WORKFLOW'),'N');
280:

Line 289: DPP_UTILITY_PVT.debug_message('Invalid User');

285: FROM fnd_user
286: WHERE user_id = l_txn_hdr_rec.last_updated_by;
287: EXCEPTION
288: WHEN NO_DATA_FOUND THEN
289: DPP_UTILITY_PVT.debug_message('Invalid User');
290: RAISE FND_API.G_EXC_ERROR;
291: WHEN OTHERS THEN
292: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
293: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');

Line 650: DPP_UTILITY_PVT.debug_message('Price Protection responsibility not available for Last updated user'||l_user_name);

646: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_RESP');
647: FND_MESSAGE.set_token('USER', l_user_name);
648: FND_MSG_PUB.add;
649: IF g_debug THEN
650: DPP_UTILITY_PVT.debug_message('Price Protection responsibility not available for Last updated user'||l_user_name);
651: END IF;
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:

Line 665: DPP_UTILITY_PVT.debug_message('The cost type DPPCost is not setup.');

661: FROM cst_cost_types
662: WHERE cost_type_id = 8;
663: EXCEPTION
664: WHEN NO_DATA_FOUND THEN
665: DPP_UTILITY_PVT.debug_message('The cost type DPPCost is not setup.');
666: RAISE FND_API.G_EXC_ERROR;
667: END;
668:
669: SELECT dpp_cst_group_id_seq.nextval

Line 692: DPP_UTILITY_PVT.debug_message('Debug Flag: ' || l_debug_flag );

688:
689: l_debug_flag := fnd_profile.value('ACCOUNT_GENERATOR:DEBUG_MODE');
690:
691: IF G_DEBUG THEN
692: DPP_UTILITY_PVT.debug_message('Debug Flag: ' || l_debug_flag );
693: END IF;
694: END IF;
695:
696: -- Standard begin of API savepoint

Line 701: DPP_UTILITY_PVT.debug_message('Before For Loop:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

697: SAVEPOINT Update_ItemCost_PVT;
698:
699: IF l_item_cost_tbl.COUNT > 0 THEN
700: IF G_DEBUG THEN
701: DPP_UTILITY_PVT.debug_message('Before For Loop:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
702: END IF;
703:
704: FOR i IN l_item_cost_tbl.FIRST..l_item_cost_tbl.LAST LOOP
705: l_status_Update_tbl(i).transaction_line_id := l_item_cost_tbl(i).transaction_line_id;

Line 716: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_item_cost_tbl(i).currency

712: IF l_item_cost_tbl(i).currency = Item_rec.currency_code THEN
713: l_to_amount := l_item_cost_tbl(i).new_price;
714: ELSE
715: l_to_amount := 0;
716: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_item_cost_tbl(i).currency
717: ,p_to_currency => Item_rec.currency_code
718: ,p_conv_type => FND_API.G_MISS_CHAR
719: ,p_conv_rate => FND_API.G_MISS_NUM
720: ,p_conv_date => l_trunc_sysdate

Line 783: DPP_UTILITY_PVT.debug_message('Costing setup is not done or the cost is Zero for the item:'||l_item_cost_tbl(i).item_number);

779: --If Prior cost is Zero or not defined then raise an Exception
780: IF l_prior_cost = 0 THEN
781: --ADD Messages
782: 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 ;
783: DPP_UTILITY_PVT.debug_message('Costing setup is not done or the cost is Zero for the item:'||l_item_cost_tbl(i).item_number);
784: l_return_status := FND_API.G_RET_STS_ERROR;
785:
786: UPDATE DPP_OUTPUT_XML_GT
787: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure

Line 849: DPP_UTILITY_PVT.debug_message('This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number);

845: END IF; --NVL(l_incorrect_price_exists,0) = 0
846:
847: IF NVL(l_incorrect_price_exists,0) = 1 THEN
848: l_item_cost_tbl(i).Reason_for_failure := 'This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number;
849: DPP_UTILITY_PVT.debug_message('This inventory organizations has an incorrect cost for item:'||l_item_cost_tbl(i).item_number);
850: l_return_status := FND_API.G_RET_STS_ERROR;
851:
852: UPDATE DPP_OUTPUT_XML_GT
853: SET reason_for_failure = l_item_cost_tbl(i).Reason_for_failure

Line 905: DPP_UTILITY_PVT.debug_message('submitting the fnd_flex_workflow_generate process');

901: aname => 'ORGANIZATION_ID',
902: avalue => Item_rec.organization_id);
903:
904: IF G_DEBUG THEN
905: DPP_UTILITY_PVT.debug_message('submitting the fnd_flex_workflow_generate process');
906: END IF;
907:
908: l_result := Fnd_Flex_Workflow.GENERATE('OZFACCTG',
909: l_itemkey,

Line 1023: DPP_UTILITY_PVT.debug_message('Success OZFACCTG WF'||'-'||x_return_ccid);

1019: l_To_Amount);
1020:
1021: l_status_Update_tbl(i).update_status := 'Y';
1022: IF G_DEBUG THEN
1023: DPP_UTILITY_PVT.debug_message('Success OZFACCTG WF'||'-'||x_return_ccid);
1024: END IF;
1025:
1026: END IF; -- end if for primary_cost_method
1027: ELSE

Line 1029: DPP_UTILITY_PVT.debug_message('OZFACCTG WF - Failure');

1025:
1026: END IF; -- end if for primary_cost_method
1027: ELSE
1028: IF G_DEBUG THEN
1029: DPP_UTILITY_PVT.debug_message('OZFACCTG WF - Failure');
1030: END IF;
1031:
1032: l_return_status := FND_API.G_RET_STS_ERROR;
1033: l_status_Update_tbl(i).update_status := 'N';

Line 1158: DPP_UTILITY_PVT.debug_message('After For Loop:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1154: END LOOP;
1155: END IF;
1156:
1157: IF g_debug THEN
1158: DPP_UTILITY_PVT.debug_message('After For Loop:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1159: END IF;
1160:
1161: --Calling the "Cost Import Process" Concurrent Program
1162: BEGIN

Line 1180: DPP_UTILITY_PVT.debug_message('Cost Import Request ID: '||l_cost_import_req_id);

1176:
1177: COMMIT;
1178:
1179: IF g_debug THEN
1180: DPP_UTILITY_PVT.debug_message('Cost Import Request ID: '||l_cost_import_req_id);
1181: END IF;
1182:
1183: l_wait_req := fnd_concurrent.wait_for_request(
1184: request_id => l_cost_import_req_id,

Line 1195: DPP_UTILITY_PVT.debug_message('After Import Request:' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1191: message => l_message);
1192: END;
1193:
1194: IF g_debug THEN
1195: DPP_UTILITY_PVT.debug_message('After Import Request:' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1196: DPP_UTILITY_PVT.debug_message('l_phase: ' || l_dev_phase || '; l_status: ' || l_dev_status);
1197: END IF;
1198:
1199: IF l_dev_status NOT IN ('WARNING','ERROR') THEN

Line 1196: DPP_UTILITY_PVT.debug_message('l_phase: ' || l_dev_phase || '; l_status: ' || l_dev_status);

1192: END;
1193:
1194: IF g_debug THEN
1195: DPP_UTILITY_PVT.debug_message('After Import Request:' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1196: DPP_UTILITY_PVT.debug_message('l_phase: ' || l_dev_phase || '; l_status: ' || l_dev_status);
1197: END IF;
1198:
1199: IF l_dev_status NOT IN ('WARNING','ERROR') THEN
1200:

Line 1238: DPP_UTILITY_PVT.debug_message('Std Cost Update Request ID: '||l_cost_upd_req_id);

1234: argument24 => 2);
1235: COMMIT;
1236:
1237: IF g_debug THEN
1238: DPP_UTILITY_PVT.debug_message('Std Cost Update Request ID: '||l_cost_upd_req_id);
1239: END IF;
1240:
1241: l_wait_req := fnd_concurrent.wait_for_request(
1242: request_id => l_cost_upd_req_id,

Line 1252: DPP_UTILITY_PVT.debug_message('l_phase: '||l_dev_phase|| '; l_status: '||l_dev_status);

1248: dev_status => l_dev_status,
1249: message => l_message);
1250:
1251: IF g_debug THEN
1252: DPP_UTILITY_PVT.debug_message('l_phase: '||l_dev_phase|| '; l_status: '||l_dev_status);
1253: END IF;
1254:
1255: END;
1256:

Line 1273: DPP_UTILITY_PVT.debug_message('After Std Cost Update request:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1269:
1270: END LOOP;
1271:
1272: IF g_debug THEN
1273: DPP_UTILITY_PVT.debug_message('After Std Cost Update request:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1274: END IF;
1275:
1276: ELSE
1277: l_return_status := FND_API.g_ret_sts_error;

Line 1278: DPP_UTILITY_PVT.debug_message('Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status);

1274: END IF;
1275:
1276: ELSE
1277: l_return_status := FND_API.g_ret_sts_error;
1278: DPP_UTILITY_PVT.debug_message('Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status);
1279:
1280: UPDATE DPP_OUTPUT_XML_GT
1281: SET reason_for_failure = 'Item Cost Import Request ID: '||l_cost_import_req_id||' '|| l_dev_phase||' with '||l_dev_status;
1282:

Line 1292: DPP_UTILITY_PVT.debug_message('Starting Error Processing: ' || l_return_status);

1288:
1289: END IF;
1290:
1291: IF g_debug THEN
1292: DPP_UTILITY_PVT.debug_message('Starting Error Processing: ' || l_return_status);
1293: END IF;
1294:
1295: -- Standard begin of API savepoint
1296: SAVEPOINT Update_ItemCost_PVT;

Line 1298: DPP_UTILITY_PVT.debug_message('Before Std Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1294:
1295: -- Standard begin of API savepoint
1296: SAVEPOINT Update_ItemCost_PVT;
1297: IF g_debug THEN
1298: DPP_UTILITY_PVT.debug_message('Before Std Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1299: END IF;
1300:
1301: -- Begin Error Processing for Std Cost Update
1302: SELECT Inventory_Item_Id,

Line 1322: DPP_UTILITY_PVT.debug_message('After Std Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1318: l_return_status := FND_API.g_ret_sts_error;
1319: END IF;
1320:
1321: IF g_debug THEN
1322: DPP_UTILITY_PVT.debug_message('After Std Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1323: END IF;
1324:
1325: -- End Error Processing for Std Cost Update
1326:

Line 1346: DPP_UTILITY_PVT.debug_message('Before Avg Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1342: message => l_msg_data);
1343:
1344: ELSE
1345: IF g_debug THEN
1346: DPP_UTILITY_PVT.debug_message('Before Avg Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1347: END IF;
1348:
1349: SELECT Source_Line_Id,
1350: Nvl(Error_Explanation,Error_Code) Error_Explanation

Line 1372: DPP_UTILITY_PVT.debug_message('After Avg Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1368: END IF;
1369: -- End Error Processing for Avg Cost Update
1370:
1371: IF g_debug THEN
1372: DPP_UTILITY_PVT.debug_message('After Avg Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1373: DPP_UTILITY_PVT.debug_message('Inserting into SLA tables: ' || l_return_status);
1374: END IF;
1375:
1376: l_sysdate := sysdate;

Line 1373: DPP_UTILITY_PVT.debug_message('Inserting into SLA tables: ' || l_return_status);

1369: -- End Error Processing for Avg Cost Update
1370:
1371: IF g_debug THEN
1372: DPP_UTILITY_PVT.debug_message('After Avg Cost Error Processing:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1373: DPP_UTILITY_PVT.debug_message('Inserting into SLA tables: ' || l_return_status);
1374: END IF;
1375:
1376: l_sysdate := sysdate;
1377:

Line 1403: DPP_UTILITY_PVT.debug_message('After SLA Hdr Insert:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1399: ,l_txn_hdr_rec.last_updated_by
1400: ,FND_GLOBAL.login_id);
1401:
1402: IF g_debug THEN
1403: DPP_UTILITY_PVT.debug_message('After SLA Hdr Insert:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1404: END IF;
1405:
1406: IF g_debug THEN
1407: DPP_UTILITY_PVT.debug_message('Inserting into SLA Lines table for Avg Cost Update ');

Line 1407: DPP_UTILITY_PVT.debug_message('Inserting into SLA Lines table for Avg Cost Update ');

1403: DPP_UTILITY_PVT.debug_message('After SLA Hdr Insert:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1404: END IF;
1405:
1406: IF g_debug THEN
1407: DPP_UTILITY_PVT.debug_message('Inserting into SLA Lines table for Avg Cost Update ');
1408: END IF;
1409:
1410: -- Begin SLA Line Processing for Avg Cost Update
1411: BEGIN

Line 1454: DPP_UTILITY_PVT.debug_message('No Data Found for SLA lines table insertion - Avg Costing...');

1450: ,l_sysdate
1451: ,l_txn_hdr_rec.last_updated_by);
1452: EXCEPTION
1453: WHEN NO_DATA_FOUND THEN
1454: DPP_UTILITY_PVT.debug_message('No Data Found for SLA lines table insertion - Avg Costing...');
1455: END;
1456: -- End SLA Line Processing for Avg Cost Update
1457:
1458: IF g_debug THEN

Line 1459: DPP_UTILITY_PVT.debug_message('Inserting into SLA Lines table for Std Cost Update: ');

1455: END;
1456: -- End SLA Line Processing for Avg Cost Update
1457:
1458: IF g_debug THEN
1459: DPP_UTILITY_PVT.debug_message('Inserting into SLA Lines table for Std Cost Update: ');
1460: DPP_UTILITY_PVT.debug_message('Before SLA Line Insert - Std:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1461: END IF;
1462:
1463: -- Begin SLA Line Processing for Std Cost Update

Line 1460: DPP_UTILITY_PVT.debug_message('Before SLA Line Insert - Std:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1456: -- End SLA Line Processing for Avg Cost Update
1457:
1458: IF g_debug THEN
1459: DPP_UTILITY_PVT.debug_message('Inserting into SLA Lines table for Std Cost Update: ');
1460: DPP_UTILITY_PVT.debug_message('Before SLA Line Insert - Std:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1461: END IF;
1462:
1463: -- Begin SLA Line Processing for Std Cost Update
1464: BEGIN

Line 1510: DPP_UTILITY_PVT.debug_message('No Data Found for SLA table insertion...');

1506: ,l_txn_hdr_rec.last_updated_by);
1507:
1508: EXCEPTION
1509: WHEN NO_DATA_FOUND THEN
1510: DPP_UTILITY_PVT.debug_message('No Data Found for SLA table insertion...');
1511: END;
1512: -- End SLA Line Processing for Std Cost Update
1513:
1514: EXCEPTION

Line 1524: DPP_UTILITY_PVT.debug_message('Error in SLA Tables Insertion:' || sqlerrm);

1520: fnd_message.set_token('ERRNO', sqlcode);
1521: fnd_message.set_token('REASON', sqlerrm);
1522: FND_MSG_PUB.add;
1523: -- END IF;
1524: DPP_UTILITY_PVT.debug_message('Error in SLA Tables Insertion:' || sqlerrm);
1525: END;
1526: END IF;
1527:
1528: IF g_debug THEN

Line 1529: DPP_UTILITY_PVT.debug_message('Before Exe Dtls Update:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1525: END;
1526: END IF;
1527:
1528: IF g_debug THEN
1529: DPP_UTILITY_PVT.debug_message('Before Exe Dtls Update:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1530: END IF;
1531:
1532: << INCORRECT_PRICE >>
1533:

Line 1544: DPP_UTILITY_PVT.debug_message('Status before generating output xml: ' || l_return_status);

1540: FROM DUAL;
1541:
1542: BEGIN
1543: IF g_debug THEN
1544: DPP_UTILITY_PVT.debug_message('Status before generating output xml: ' || l_return_status);
1545: END IF;
1546:
1547: --Get the output XML from DPP_OUTPUT_XML_GT table
1548: l_Transaction_Number := '''' || l_txn_hdr_rec.Transaction_Number || '''';

Line 1578: DPP_UTILITY_PVT.debug_message('Status before calling update API: ' || l_return_status);

1574: FND_MSG_PUB.add;
1575: END;
1576:
1577: IF g_debug THEN
1578: DPP_UTILITY_PVT.debug_message('Status before calling update API: ' || l_return_status);
1579: END IF;
1580:
1581: l_exe_update_rec.Transaction_Header_ID := l_txn_hdr_rec.Transaction_Header_ID;
1582: l_exe_update_rec.Org_ID := l_txn_hdr_rec.Org_ID;

Line 1603: DPP_UTILITY_PVT.debug_message('After Exe Dtls Update:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1599: ,p_EXE_UPDATE_rec => l_exe_update_rec
1600: ,p_status_Update_tbl=> l_status_Update_tbl
1601: );
1602: IF g_debug THEN
1603: DPP_UTILITY_PVT.debug_message('After Exe Dtls Update:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1604: END IF;
1605:
1606: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1607: x_return_status := l_return_status;

Line 1618: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1614: END IF;
1615:
1616: -- Debug Message
1617: IF g_debug THEN
1618: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1619: END IF;
1620:
1621: -- Standard call to get message count and if count is 1, get message info.
1622: FND_MSG_PUB.Count_And_Get