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_UTILITY_PVT dependencies on FND_LOG

Line 418: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_vendors(): x_return_status: ' || x_return_status);

414: x_rec_count := l_vendor_tbl.COUNT;
415: x_vendor_tbl := l_vendor_tbl;
416: x_return_status := fnd_api.g_ret_sts_success;
417:
418: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_vendors(): x_return_status: ' || x_return_status);
419:
420: EXCEPTION
421: WHEN OTHERS THEN
422: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 503: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_vendor_sites(): x_return_status: ' || x_return_status);

499: x_rec_count := l_vendor_site_tbl.COUNT;
500: x_vendor_site_tbl := l_vendor_site_tbl;
501: x_return_status := fnd_api.g_ret_sts_success;
502:
503: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_vendor_sites(): x_return_status: ' || x_return_status);
504:
505: EXCEPTION
506:
507: WHEN FND_API.G_EXC_ERROR THEN

Line 581: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_vendor_contacts(): x_return_status: ' || x_return_status);

577: x_rec_count := l_vendor_contact_tbl.COUNT;
578: x_vendor_contact_tbl := l_vendor_contact_tbl;
579: x_return_status := fnd_api.g_ret_sts_success;
580:
581: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_vendor_contacts(): x_return_status: ' || x_return_status);
582:
583: EXCEPTION
584: WHEN FND_API.G_EXC_ERROR THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;

Line 789: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_items(): x_return_status: ' || x_return_status);

785: x_rec_count := l_itemnum_tbl.COUNT;
786: x_item_tbl := l_itemnum_tbl;
787: x_return_status := fnd_api.g_ret_sts_success;
788:
789: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_items(): x_return_status: ' || x_return_status);
790:
791: EXCEPTION
792:
793: WHEN FND_API.G_EXC_ERROR THEN

Line 883: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_customer_items(): x_return_status: ' || x_return_status);

879: x_rec_count := l_customer_item_tbl.COUNT;
880: x_customer_item_tbl := l_customer_item_tbl;
881: x_return_status := fnd_api.g_ret_sts_success;
882:
883: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_customer_items(): x_return_status: ' || x_return_status);
884:
885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
887: x_return_status := FND_API.G_RET_STS_ERROR;

Line 970: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_customer_items_all(): x_return_status: ' || x_return_status);

966: x_rec_count := l_customer_item_tbl.COUNT;
967: x_customer_item_tbl := l_customer_item_tbl;
968: x_return_status := fnd_api.g_ret_sts_success;
969:
970: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_customer_items_all(): x_return_status: ' || x_return_status);
971:
972: EXCEPTION
973: WHEN FND_API.G_EXC_ERROR THEN
974: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1040: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_warehouses(): x_return_status: ' || x_return_status);

1036:
1037: x_rec_count := l_warehouse_tbl.COUNT;
1038: x_warehouse_tbl := l_warehouse_tbl;
1039:
1040: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_warehouses(): x_return_status: ' || x_return_status);
1041:
1042: EXCEPTION
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1199: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'Error in fetching primary UOM: ' || SQLERRM);

1195: AND mp.organization_id = mp.master_organization_id
1196: AND rownum = 1;
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'Error in fetching primary UOM: ' || SQLERRM);
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: END;
1202:
1203: l_covered_inv_tbl(i).uom_code := l_primary_uom_code; -- Default to Primary UOM

Line 1212: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_coveredinventory(): x_return_status: ' || x_return_status);

1208: p_covered_inv_tbl := l_covered_inv_tbl;
1209:
1210: x_return_status := fnd_api.g_ret_sts_success;
1211:
1212: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_coveredinventory(): x_return_status: ' || x_return_status);
1213:
1214: EXCEPTION
1215:
1216: WHEN OTHERS THEN

Line 1507: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_EXCEPTION, l_module, 'Error in fetching primary UOM: ' || SQLERRM);

1503: AND mp.organization_id = mp.master_organization_id
1504: AND rownum = 1;
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_EXCEPTION, l_module, 'Error in fetching primary UOM: ' || SQLERRM);
1508: x_return_status := FND_API.G_RET_STS_ERROR;
1509: END;
1510:
1511: l_inventorydetails_tbl(i).uom_code := l_primary_uom_code; -- Default to Primary UOM

Line 1520: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_inventorydetails(): x_return_status: ' || x_return_status);

1516: END LOOP; -- tbl loop
1517: x_rec_count := l_inventorydetails_tbl.COUNT;
1518: p_inventorydetails_tbl := l_inventorydetails_tbl;
1519:
1520: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_inventorydetails(): x_return_status: ' || x_return_status);
1521:
1522: EXCEPTION
1523: WHEN FND_API.G_EXC_ERROR THEN
1524: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1612: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_customerInventory(): x_return_status: ' || x_return_status);

1608: END LOOP;
1609: x_rec_count := l_cust_inv_tbl.COUNT;
1610: p_cust_inv_tbl := l_cust_inv_tbl;
1611:
1612: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_customerInventory(): x_return_status: ' || x_return_status);
1613:
1614: EXCEPTION
1615: WHEN FND_API.G_EXC_ERROR THEN
1616: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1694: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_customers(): x_return_status: ' || x_return_status);

1690:
1691: x_rec_count := l_customer_tbl.COUNT;
1692: x_customer_tbl := l_customer_tbl;
1693:
1694: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_customers(): x_return_status: ' || x_return_status);
1695:
1696: EXCEPTION
1697: WHEN FND_API.G_EXC_ERROR THEN
1698: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1763: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_customers_all(): x_return_status: ' || x_return_status);

1759:
1760: x_rec_count := l_customer_tbl.COUNT;
1761: x_customer_tbl := l_customer_tbl;
1762:
1763: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'search_customers_all(): x_return_status: ' || x_return_status);
1764:
1765: EXCEPTION
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1900: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'convert_currency(): x_return_status: ' || l_return_status);

1896: ,x_return_status => l_return_status
1897: ,x_to_amount => l_to_amount
1898: ,x_rate => l_exchange_rate);
1899:
1900: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'convert_currency(): x_return_status: ' || l_return_status);
1901:
1902: IF l_return_status = 'S' THEN
1903: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'convert_currency(): Exchange Rate : ' || l_exchange_rate);
1904:

Line 1903: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'convert_currency(): Exchange Rate : ' || l_exchange_rate);

1899:
1900: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'convert_currency(): x_return_status: ' || l_return_status);
1901:
1902: IF l_return_status = 'S' THEN
1903: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'convert_currency(): Exchange Rate : ' || l_exchange_rate);
1904:
1905: l_cust_price_tbl(i).converted_price_change := l_to_amount;
1906: END IF;
1907: ELSE

Line 1908: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'No conversion of currency code required');

1904:
1905: l_cust_price_tbl(i).converted_price_change := l_to_amount;
1906: END IF;
1907: ELSE
1908: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'No conversion of currency code required');
1909:
1910: l_cust_price_tbl(i).converted_price_change := l_cust_price_tbl(i).price_change;
1911: END IF;
1912: END IF;

Line 1918: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_lastprice(): x_return_status: ' || x_return_status);

1914:
1915: x_rec_count := l_cust_price_tbl.COUNT;
1916: p_cust_price_tbl := l_cust_price_tbl;
1917:
1918: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_lastprice(): x_return_status: ' || x_return_status);
1919:
1920: EXCEPTION
1921: WHEN FND_API.G_EXC_ERROR THEN
1922: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2030: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_listprice(): x_return_status: ' || x_return_status);

2026:
2027: x_rec_count := l_listprice_tbl.COUNT;
2028: p_listprice_tbl := l_listprice_tbl;
2029:
2030: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_listprice(): x_return_status: ' || x_return_status);
2031:
2032: EXCEPTION
2033: WHEN FND_API.G_EXC_ERROR THEN
2034: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2280: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_warehouse(): x_return_status: ' || x_return_status);

2276:
2277: x_rec_count := l_warehouse_tbl.COUNT;
2278: p_warehouse_tbl := l_warehouse_tbl;
2279:
2280: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_warehouse(): x_return_status: ' || x_return_status);
2281:
2282: EXCEPTION
2283: WHEN FND_API.G_EXC_ERROR THEN
2284: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2342: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_customer(): x_return_status: ' || x_return_status);

2338:
2339: x_rec_count := l_customer_tbl.COUNT;
2340: p_customer_tbl := l_customer_tbl;
2341:
2342: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_customer(): x_return_status: ' || x_return_status);
2343:
2344: EXCEPTION
2345: WHEN OTHERS THEN
2346: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2388: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'debug: start ' || l_org_id);

2384:
2385: RAISE fnd_api.g_exc_error;
2386: END IF;
2387:
2388: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'debug: start ' || l_org_id);
2389:
2390: x_rec_count := 0;
2391: x_return_status := fnd_api.g_ret_sts_success;
2392:

Line 2415: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_product(): x_return_status: ' || x_return_status);

2411:
2412: x_rec_count := l_item_tbl.COUNT;
2413: p_item_tbl := l_item_tbl;
2414:
2415: DPP_UTILITY_PVT.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, 'get_product(): x_return_status: ' || x_return_status);
2416:
2417: EXCEPTION
2418: WHEN OTHERS THEN
2419: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2428: --To be used incase we are storing the log messages in the fnd_log_messages table

2424: fnd_message.set_token('REASON', sqlerrm);
2425: FND_MSG_PUB.ADD;
2426: END Get_Product;
2427:
2428: --To be used incase we are storing the log messages in the fnd_log_messages table
2429: --Currently all debug messages are going into the DPP_LOG_MESSAGES table
2430:
2431: PROCEDURE debug_message (p_log_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
2432: p_module_name IN VARCHAR2,

Line 2431: PROCEDURE debug_message (p_log_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

2427:
2428: --To be used incase we are storing the log messages in the fnd_log_messages table
2429: --Currently all debug messages are going into the DPP_LOG_MESSAGES table
2430:
2431: PROCEDURE debug_message (p_log_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
2432: p_module_name IN VARCHAR2,
2433: p_text IN VARCHAR2)
2434: IS
2435:

Line 2438: IF( p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2434: IS
2435:
2436: BEGIN
2437:
2438: IF( p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2439: FND_LOG.STRING(p_log_level, p_module_name, p_text);
2440: END IF;
2441:
2442: END debug_message;

Line 2439: FND_LOG.STRING(p_log_level, p_module_name, p_text);

2435:
2436: BEGIN
2437:
2438: IF( p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2439: FND_LOG.STRING(p_log_level, p_module_name, p_text);
2440: END IF;
2441:
2442: END debug_message;
2443:

Line 2601: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, sqlerrm);

2597: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.convert_currency');
2598: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2599: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);
2600: FND_MSG_PUB.ADD;
2601: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, sqlerrm);
2602:
2603: END convert_currency;
2604:
2605: PROCEDURE calculate_functional_curr(

Line 2686: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'debug: start ' || l_org_id);

2682: END IF;
2683:
2684: END IF;
2685:
2686: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'debug: start ' || l_org_id);
2687:
2688: x_mrc_sob_type_code := 'P';
2689: OPEN c_get_gl_info(l_org_id);
2690: FETCH c_get_gl_info INTO x_set_of_books_id, x_fc_currency_code;