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 DPP_UTILITY_PVT

Line 1: PACKAGE BODY DPP_UTILITY_PVT AS

1: PACKAGE BODY DPP_UTILITY_PVT AS
2: /* $Header: dppvutlb.pls 120.43 2008/05/29 05:38:13 sdasan noship $ */
3: PROCEDURE Check_Transaction(
4: p_transaction_header_id IN NUMBER
5: ,p_status_change IN VARCHAR2

Line 388: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.check_txnclose');

384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385:
386: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
387: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
388: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.check_txnclose');
389: fnd_message.set_token('ERRNO', sqlcode);
390: fnd_message.set_token('REASON', sqlerrm);
391: FND_MSG_PUB.ADD;
392: END IF;

Line 437: DPP_UTILITY_PVT.debug_message ('search_vendors(): x_return_status: ' || x_return_status);

433: x_vendor_tbl := l_vendor_tbl;
434: x_return_status := fnd_api.g_ret_sts_success;
435:
436: IF DPP_DEBUG_HIGH_ON THEN
437: DPP_UTILITY_PVT.debug_message ('search_vendors(): x_return_status: ' || x_return_status);
438: END IF;
439:
440: EXCEPTION
441: WHEN OTHERS THEN

Line 446: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendors');

442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443:
444: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
445: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
446: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendors');
447: fnd_message.set_token('ERRNO', sqlcode);
448: fnd_message.set_token('REASON', sqlerrm);
449: FND_MSG_PUB.ADD;
450: END IF;

Line 528: DPP_UTILITY_PVT.debug_message ('search_vendor_sites(): x_return_status: ' || x_return_status);

524: x_rec_count := l_vendor_site_tbl.COUNT;
525: x_vendor_site_tbl := l_vendor_site_tbl;
526: x_return_status := fnd_api.g_ret_sts_success;
527: IF DPP_DEBUG_HIGH_ON THEN
528: DPP_UTILITY_PVT.debug_message ('search_vendor_sites(): x_return_status: ' || x_return_status);
529: END IF;
530:
531: EXCEPTION
532:

Line 541: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_sites');

537: x_return_status := fnd_api.g_ret_sts_unexp_error;
538:
539: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
540: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
541: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_sites');
542: fnd_message.set_token('ERRNO', sqlcode);
543: fnd_message.set_token('REASON', sqlerrm);
544: FND_MSG_PUB.ADD;
545: END IF;

Line 611: DPP_UTILITY_PVT.debug_message ('search_vendor_contacts(): x_return_status: ' || x_return_status);

607: x_rec_count := l_vendor_contact_tbl.COUNT;
608: x_vendor_contact_tbl := l_vendor_contact_tbl;
609: x_return_status := fnd_api.g_ret_sts_success;
610: IF DPP_DEBUG_HIGH_ON THEN
611: DPP_UTILITY_PVT.debug_message ('search_vendor_contacts(): x_return_status: ' || x_return_status);
612: END IF;
613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN

Line 623: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_contacts');

619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620:
621: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
622: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
623: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_contacts');
624: fnd_message.set_token('ERRNO', sqlcode);
625: fnd_message.set_token('REASON', sqlerrm);
626: FND_MSG_PUB.ADD;
627: END IF;

Line 827: DPP_UTILITY_PVT.debug_message ('search_items(): x_return_status: ' || x_return_status);

823: x_rec_count := l_itemnum_tbl.COUNT;
824: x_item_tbl := l_itemnum_tbl;
825: x_return_status := fnd_api.g_ret_sts_success;
826: IF DPP_DEBUG_HIGH_ON THEN
827: DPP_UTILITY_PVT.debug_message ('search_items(): x_return_status: ' || x_return_status);
828: END IF;
829:
830: EXCEPTION
831:

Line 840: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_items');

836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_items');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);
843: FND_MSG_PUB.ADD;
844: END IF;

Line 925: DPP_UTILITY_PVT.debug_message ('search_customer_items(): x_return_status: ' || x_return_status);

921: x_rec_count := l_customer_item_tbl.COUNT;
922: x_customer_item_tbl := l_customer_item_tbl;
923: x_return_status := fnd_api.g_ret_sts_success;
924: IF DPP_DEBUG_HIGH_ON THEN
925: DPP_UTILITY_PVT.debug_message ('search_customer_items(): x_return_status: ' || x_return_status);
926: END IF;
927:
928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN

Line 937: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items');

933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934:
935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
936: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
937: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items');
938: fnd_message.set_token('ERRNO', sqlcode);
939: fnd_message.set_token('REASON', sqlerrm);
940: FND_MSG_PUB.ADD;
941: END IF;

Line 999: DPP_UTILITY_PVT.debug_message ('search_warehouses(): x_return_status: ' || x_return_status);

995: x_rec_count := l_warehouse_tbl.COUNT;
996: x_warehouse_tbl := l_warehouse_tbl;
997:
998: IF DPP_DEBUG_HIGH_ON THEN
999: DPP_UTILITY_PVT.debug_message ('search_warehouses(): x_return_status: ' || x_return_status);
1000: END IF;
1001:
1002: EXCEPTION
1003: WHEN FND_API.G_EXC_ERROR THEN

Line 1011: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_warehouses');

1007: x_return_status := fnd_api.g_ret_sts_unexp_error;
1008:
1009: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1010: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1011: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_warehouses');
1012: fnd_message.set_token('ERRNO', sqlcode);
1013: fnd_message.set_token('REASON', sqlerrm);
1014: FND_MSG_PUB.ADD;
1015: END IF;

Line 1160: DPP_UTILITY_PVT.debug_message ('Error in fetching primary UOM: ' || SQLERRM);

1156: AND mp.organization_id = mp.master_organization_id
1157: AND rownum = 1;
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: DPP_UTILITY_PVT.debug_message ('Error in fetching primary UOM: ' || SQLERRM);
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: END;
1163:
1164: l_covered_inv_tbl(i).uom_code := l_primary_uom_code; -- Default to Primary UOM

Line 1174: DPP_UTILITY_PVT.debug_message ('get_coveredinventory(): x_return_status: ' || x_return_status);

1170:
1171: x_return_status := fnd_api.g_ret_sts_success;
1172:
1173: IF DPP_DEBUG_HIGH_ON THEN
1174: DPP_UTILITY_PVT.debug_message ('get_coveredinventory(): x_return_status: ' || x_return_status);
1175: END IF;
1176:
1177: EXCEPTION
1178:

Line 1184: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CoveredInventory');

1180: x_return_status := fnd_api.g_ret_sts_unexp_error;
1181:
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1183: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1184: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CoveredInventory');
1185: fnd_message.set_token('ERRNO', sqlcode);
1186: fnd_message.set_token('REASON', sqlerrm);
1187: FND_MSG_PUB.ADD;
1188: END IF;

Line 1471: DPP_UTILITY_PVT.debug_message ('Error in fetching primary UOM: ' || SQLERRM);

1467: AND mp.organization_id = mp.master_organization_id
1468: AND rownum = 1;
1469: EXCEPTION
1470: WHEN OTHERS THEN
1471: DPP_UTILITY_PVT.debug_message ('Error in fetching primary UOM: ' || SQLERRM);
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: END;
1474:
1475: l_inventorydetails_tbl(i).uom_code := l_primary_uom_code; -- Default to Primary UOM

Line 1485: DPP_UTILITY_PVT.debug_message ('get_inventorydetails(): x_return_status: ' || x_return_status);

1481: x_rec_count := l_inventorydetails_tbl.COUNT;
1482: p_inventorydetails_tbl := l_inventorydetails_tbl;
1483:
1484: IF DPP_DEBUG_HIGH_ON THEN
1485: DPP_UTILITY_PVT.debug_message ('get_inventorydetails(): x_return_status: ' || x_return_status);
1486: END IF;
1487:
1488: EXCEPTION
1489: WHEN FND_API.G_EXC_ERROR THEN

Line 1497: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_InventoryDetails');

1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494:
1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1496: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1497: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_InventoryDetails');
1498: fnd_message.set_token('ERRNO', sqlcode);
1499: fnd_message.set_token('REASON', sqlerrm);
1500: FND_MSG_PUB.ADD;
1501: END IF;

Line 1579: DPP_UTILITY_PVT.debug_message ('get_customerInventory(): x_return_status: ' || x_return_status);

1575: x_rec_count := l_cust_inv_tbl.COUNT;
1576: p_cust_inv_tbl := l_cust_inv_tbl;
1577:
1578: IF DPP_DEBUG_HIGH_ON THEN
1579: DPP_UTILITY_PVT.debug_message ('get_customerInventory(): x_return_status: ' || x_return_status);
1580: END IF;
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
1583: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1589: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CustomerInventory');

1585: WHEN OTHERS THEN
1586: x_return_status := fnd_api.g_ret_sts_unexp_error;
1587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1588: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1589: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CustomerInventory');
1590: fnd_message.set_token('ERRNO', sqlcode);
1591: fnd_message.set_token('REASON', sqlerrm);
1592: FND_MSG_PUB.ADD;
1593: END IF;

Line 1663: DPP_UTILITY_PVT.debug_message ('search_customers(): x_return_status: ' || x_return_status);

1659: x_rec_count := l_customer_tbl.COUNT;
1660: x_customer_tbl := l_customer_tbl;
1661:
1662: IF DPP_DEBUG_HIGH_ON THEN
1663: DPP_UTILITY_PVT.debug_message ('search_customers(): x_return_status: ' || x_return_status);
1664: END IF;
1665:
1666: EXCEPTION
1667: WHEN FND_API.G_EXC_ERROR THEN

Line 1675: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers');

1671: x_return_status := fnd_api.g_ret_sts_unexp_error;
1672:
1673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1674: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1675: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers');
1676: fnd_message.set_token('ERRNO', sqlcode);
1677: fnd_message.set_token('REASON', sqlerrm);
1678: FND_MSG_PUB.ADD;
1679: END IF;

Line 1791: DPP_UTILITY_PVT.convert_currency( p_from_currency => l_hdr_rec.currency_code

1787: --Get the converted Price change if the currency is different
1788: IF l_hdr_rec.currency_code <> l_cust_price_tbl(i).invoice_currency_code THEN
1789: --Call the convert currency API to get the converted value of Price change
1790: l_to_amount := 0;
1791: DPP_UTILITY_PVT.convert_currency( p_from_currency => l_hdr_rec.currency_code
1792: ,p_to_currency => l_cust_price_tbl(i).invoice_currency_code
1793: ,p_conv_type => FND_API.G_MISS_CHAR
1794: ,p_conv_rate => FND_API.G_MISS_NUM
1795: ,p_conv_date => l_trunc_sysdate

Line 1801: DPP_UTILITY_PVT.debug_message ('convert_currency(): x_return_status: ' || l_return_status);

1797: ,x_return_status => l_return_status
1798: ,x_to_amount => l_to_amount
1799: ,x_rate => l_exchange_rate);
1800: IF DPP_DEBUG_HIGH_ON THEN
1801: DPP_UTILITY_PVT.debug_message ('convert_currency(): x_return_status: ' || l_return_status);
1802: END IF;
1803: IF l_return_status = 'S' THEN
1804: IF DPP_DEBUG_HIGH_ON THEN
1805: DPP_UTILITY_PVT.debug_message ('convert_currency(): Exchange Rate : ' || l_exchange_rate);

Line 1805: DPP_UTILITY_PVT.debug_message ('convert_currency(): Exchange Rate : ' || l_exchange_rate);

1801: DPP_UTILITY_PVT.debug_message ('convert_currency(): x_return_status: ' || l_return_status);
1802: END IF;
1803: IF l_return_status = 'S' THEN
1804: IF DPP_DEBUG_HIGH_ON THEN
1805: DPP_UTILITY_PVT.debug_message ('convert_currency(): Exchange Rate : ' || l_exchange_rate);
1806: END IF;
1807: l_cust_price_tbl(i).converted_price_change := l_to_amount;
1808: END IF;
1809: ELSE

Line 1811: DPP_UTILITY_PVT.debug_message ('No conversion of currency code required');

1807: l_cust_price_tbl(i).converted_price_change := l_to_amount;
1808: END IF;
1809: ELSE
1810: IF DPP_DEBUG_HIGH_ON THEN
1811: DPP_UTILITY_PVT.debug_message ('No conversion of currency code required');
1812: END IF;
1813: l_cust_price_tbl(i).converted_price_change := l_cust_price_tbl(i).price_change;
1814: END IF;
1815: END IF;

Line 1822: DPP_UTILITY_PVT.debug_message ('get_lastprice(): x_return_status: ' || x_return_status);

1818: x_rec_count := l_cust_price_tbl.COUNT;
1819: p_cust_price_tbl := l_cust_price_tbl;
1820:
1821: IF DPP_DEBUG_HIGH_ON THEN
1822: DPP_UTILITY_PVT.debug_message ('get_lastprice(): x_return_status: ' || x_return_status);
1823: END IF;
1824:
1825: EXCEPTION
1826: WHEN FND_API.G_EXC_ERROR THEN

Line 1834: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_LastPrice');

1830: x_return_status := fnd_api.g_ret_sts_unexp_error;
1831:
1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1833: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1834: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_LastPrice');
1835: fnd_message.set_token('ERRNO', sqlcode);
1836: fnd_message.set_token('REASON', sqlerrm);
1837: FND_MSG_PUB.ADD;
1838: END IF;

Line 1917: DPP_UTILITY_PVT.convert_currency(

1913: IF l_functional_currency = l_header_rec.currency_code THEN
1914: l_to_amount := get_list_price_rec.list_price;
1915: ELSE
1916: l_to_amount := 0;
1917: DPP_UTILITY_PVT.convert_currency(
1918: p_from_currency => l_functional_currency
1919: ,p_to_currency => l_header_rec.currency_code
1920: ,p_conv_type => FND_API.G_MISS_CHAR
1921: ,p_conv_rate => FND_API.G_MISS_NUM

Line 1937: DPP_UTILITY_PVT.debug_message ('get_listprice(): x_return_status: ' || x_return_status);

1933: x_rec_count := l_listprice_tbl.COUNT;
1934: p_listprice_tbl := l_listprice_tbl;
1935:
1936: IF DPP_DEBUG_HIGH_ON THEN
1937: DPP_UTILITY_PVT.debug_message ('get_listprice(): x_return_status: ' || x_return_status);
1938: END IF;
1939:
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN

Line 1949: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_ListPrice');

1945: x_return_status := fnd_api.g_ret_sts_unexp_error;
1946:
1947: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1949: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_ListPrice');
1950: fnd_message.set_token('ERRNO', sqlcode);
1951: fnd_message.set_token('REASON', sqlerrm);
1952: FND_MSG_PUB.ADD;
1953: END IF;

Line 2003: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor');

1999: x_return_status := fnd_api.g_ret_sts_unexp_error;
2000:
2001: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2002: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2003: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor');
2004: fnd_message.set_token('ERRNO', sqlcode);
2005: fnd_message.set_token('REASON', sqlerrm);
2006: FND_MSG_PUB.ADD;
2007: END IF;

Line 2075: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Site');

2071: x_return_status := fnd_api.g_ret_sts_unexp_error;
2072:
2073: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2074: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2075: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Site');
2076: fnd_message.set_token('ERRNO', sqlcode);
2077: fnd_message.set_token('REASON', sqlerrm);
2078: FND_MSG_PUB.ADD;
2079: END IF;

Line 2145: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Contact');

2141: x_return_status := fnd_api.g_ret_sts_unexp_error;
2142:
2143: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2144: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2145: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Contact');
2146: fnd_message.set_token('ERRNO', sqlcode);
2147: fnd_message.set_token('REASON', sqlerrm);
2148: FND_MSG_PUB.ADD;
2149: END IF;

Line 2196: DPP_UTILITY_PVT.debug_message ('get_warehouse(): x_return_status: ' || x_return_status);

2192: x_rec_count := l_warehouse_tbl.COUNT;
2193: p_warehouse_tbl := l_warehouse_tbl;
2194:
2195: IF DPP_DEBUG_HIGH_ON THEN
2196: DPP_UTILITY_PVT.debug_message ('get_warehouse(): x_return_status: ' || x_return_status);
2197: END IF;
2198:
2199: EXCEPTION
2200: WHEN FND_API.G_EXC_ERROR THEN

Line 2207: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Warehouse');

2203: x_return_status := fnd_api.g_ret_sts_unexp_error;
2204:
2205: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2206: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2207: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Warehouse');
2208: fnd_message.set_token('ERRNO', sqlcode);
2209: fnd_message.set_token('REASON', sqlerrm);
2210: FND_MSG_PUB.ADD;
2211: END IF;

Line 2258: DPP_UTILITY_PVT.debug_message ('get_customer(): x_return_status: ' || x_return_status);

2254: x_rec_count := l_customer_tbl.COUNT;
2255: p_customer_tbl := l_customer_tbl;
2256:
2257: IF DPP_DEBUG_HIGH_ON THEN
2258: DPP_UTILITY_PVT.debug_message ('get_customer(): x_return_status: ' || x_return_status);
2259: END IF;
2260:
2261: EXCEPTION
2262: WHEN OTHERS THEN

Line 2266: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Customer');

2262: WHEN OTHERS THEN
2263: x_return_status := fnd_api.g_ret_sts_unexp_error;
2264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2265: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2266: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Customer');
2267: fnd_message.set_token('ERRNO', sqlcode);
2268: fnd_message.set_token('REASON', sqlerrm);
2269: FND_MSG_PUB.ADD;
2270: END IF;

Line 2309: dpp_utility_pvt.debug_message('debug: start ' || l_org_id);

2305: RAISE fnd_api.g_exc_error;
2306: END IF;
2307:
2308: IF (DPP_DEBUG_HIGH_ON) THEN
2309: dpp_utility_pvt.debug_message('debug: start ' || l_org_id);
2310: END IF;
2311:
2312: x_rec_count := 0;
2313: x_return_status := fnd_api.g_ret_sts_success;

Line 2338: DPP_UTILITY_PVT.debug_message ('get_product(): x_return_status: ' || x_return_status);

2334: x_rec_count := l_item_tbl.COUNT;
2335: p_item_tbl := l_item_tbl;
2336:
2337: IF DPP_DEBUG_HIGH_ON THEN
2338: DPP_UTILITY_PVT.debug_message ('get_product(): x_return_status: ' || x_return_status);
2339: END IF;
2340: EXCEPTION
2341: WHEN OTHERS THEN
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2346: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Product');

2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343:
2344: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2345: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2346: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Product');
2347: fnd_message.set_token('ERRNO', sqlcode);
2348: fnd_message.set_token('REASON', sqlerrm);
2349: FND_MSG_PUB.ADD;
2350: END IF;

Line 2449: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.get_EmailAddress');

2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446:
2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2448: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2449: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.get_EmailAddress');
2450: fnd_message.set_token('ERRNO', sqlcode);
2451: fnd_message.set_token('REASON', sqlerrm);
2452: FND_MSG_PUB.ADD;
2453: END IF;

Line 2535: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.convert_currency');

2531: x_return_status := fnd_api.g_ret_sts_error;
2532: WHEN OTHERS THEN
2533: x_return_status := fnd_api.g_ret_sts_unexp_error;
2534: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2535: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.convert_currency');
2536: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2537: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);
2538: FND_MSG_PUB.ADD;
2539: DPP_UTILITY_PVT.debug_message(sqlerrm);

Line 2539: DPP_UTILITY_PVT.debug_message(sqlerrm);

2535: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.convert_currency');
2536: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2537: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);
2538: FND_MSG_PUB.ADD;
2539: DPP_UTILITY_PVT.debug_message(sqlerrm);
2540:
2541: END convert_currency;
2542:
2543: PROCEDURE calculate_functional_curr(

Line 2630: dpp_utility_pvt.debug_message('debug: start ' || l_org_id);

2626:
2627: END IF;
2628:
2629: IF (DPP_DEBUG_HIGH_ON) THEN
2630: dpp_utility_pvt.debug_message('debug: start ' || l_org_id);
2631: END IF;
2632:
2633: x_mrc_sob_type_code := 'P';
2634: OPEN c_get_gl_info(l_org_id);

Line 2686: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.Convert_functional_curr');

2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683:
2684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2685: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2686: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.Convert_functional_curr');
2687: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2688: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);
2689: FND_MSG_PUB.ADD;
2690: END IF;

Line 2692: END DPP_UTILITY_PVT;

2688: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);
2689: FND_MSG_PUB.ADD;
2690: END IF;
2691: END calculate_functional_curr;
2692: END DPP_UTILITY_PVT;