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.63 2011/11/09 23:42:36 hekkiral ship $ */
3: PROCEDURE Check_Transaction(
4: p_transaction_header_id IN NUMBER
5: ,p_status_change IN VARCHAR2

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

354:
355: WHEN OTHERS THEN
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
358: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.check_txnclose');
359: fnd_message.set_token('ERRNO', sqlcode);
360: fnd_message.set_token('REASON', sqlerrm);
361: FND_MSG_PUB.add;
362:

Line 386: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_VENDORS';

382: IS
383: l_search_criteria_tbl search_criteria_tbl_type := p_search_criteria;
384: l_vendor_tbl vendor_tbl_type;
385: l_trunc_sysdate DATE := trunc(sysdate);
386: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_VENDORS';
387:
388: CURSOR get_vendor_csr (p_search_criteria IN VARCHAR2, p_search_text IN VARCHAR2) IS
389: SELECT
390: vendor_id,

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 425: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendors');

421: WHEN OTHERS THEN
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423:
424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
425: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendors');
426: fnd_message.set_token('ERRNO', sqlcode);
427: fnd_message.set_token('REASON', sqlerrm);
428: FND_MSG_PUB.ADD;
429:

Line 441: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_VENDOR_SITES';

437: )
438: IS
439: l_search_criteria_tbl search_criteria_tbl_type := p_search_criteria;
440: l_vendor_site_tbl vendor_site_tbl_type;
441: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_VENDOR_SITES';
442:
443:
444: CURSOR get_vendor_sites_csr (p_search_criteria1 IN VARCHAR2,
445: p_search_text1 IN VARCHAR2,

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 514: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_sites');

510: WHEN OTHERS THEN
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512:
513: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
514: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_sites');
515: fnd_message.set_token('ERRNO', sqlcode);
516: fnd_message.set_token('REASON', sqlerrm);
517: FND_MSG_PUB.ADD;
518:

Line 530: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_VENDOR_CONTACTS';

526: )
527: IS
528: l_search_criteria_tbl search_criteria_tbl_type := p_search_criteria;
529: l_vendor_contact_tbl vendor_contact_tbl_type;
530: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_VENDOR_CONTACTS';
531:
532: CURSOR get_vendor_contacts_csr (p_search_criteria1 IN VARCHAR2, p_search_text1 IN VARCHAR2,
533: p_search_criteria2 IN VARCHAR2, p_search_text2 IN VARCHAR2) IS
534: SELECT assa.vendor_site_id,

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 591: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_contacts');

587: WHEN OTHERS THEN
588: x_return_status := fnd_api.g_ret_sts_unexp_error;
589:
590: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
591: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_contacts');
592: fnd_message.set_token('ERRNO', sqlcode);
593: fnd_message.set_token('REASON', sqlerrm);
594: FND_MSG_PUB.ADD;
595:

Line 610: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_ITEMS';

606: l_itemnum_tbl itemnum_tbl_type;
607: l_supp_trade_profile_id NUMBER;
608: l_supp_item_count NUMBER := 0;
609: l_trunc_sysdate DATE := trunc(sysdate);
610: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_ITEMS';
611:
612: CURSOR get_item_csr (p_search_criteria1 IN VARCHAR2,
613: p_search_text1 IN VARCHAR2,
614: p_search_criteria2 IN VARCHAR2,

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 800: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_items');

796: WHEN OTHERS THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error;
798:
799: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
800: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_items');
801: fnd_message.set_token('ERRNO', sqlcode);
802: fnd_message.set_token('REASON', sqlerrm);
803: FND_MSG_PUB.ADD;
804:

Line 818: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_CUSTOMER_ITEMS';

814: )
815: IS
816: l_search_criteria_tbl search_criteria_tbl_type := p_search_criteria;
817: l_customer_item_tbl item_tbl_type;
818: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_CUSTOMER_ITEMS';
819:
820: CURSOR get_customer_item_csr (p_search_criteria1 IN VARCHAR2, p_search_text1 IN VARCHAR2,
821: p_search_criteria2 IN VARCHAR2, p_search_text2 IN VARCHAR2,
822: p_search_criteria3 IN VARCHAR2, p_search_text3 IN VARCHAR2) IS

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 893: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items');

889: WHEN OTHERS THEN
890: x_return_status := fnd_api.g_ret_sts_unexp_error;
891:
892: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
893: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items');
894: fnd_message.set_token('ERRNO', sqlcode);
895: fnd_message.set_token('REASON', sqlerrm);
896: FND_MSG_PUB.ADD;
897:

Line 910: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_CUSTOMER_ITEMS_ALL';

906: )
907: IS
908: l_search_criteria_tbl search_criteria_tbl_type := p_search_criteria;
909: l_customer_item_tbl item_tbl_type;
910: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_CUSTOMER_ITEMS_ALL';
911:
912: CURSOR get_customer_items_all_csr (p_search_criteria1 IN VARCHAR2, p_search_text1 IN VARCHAR2,
913: p_search_criteria2 IN VARCHAR2, p_search_text2 IN VARCHAR2) IS
914:

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 980: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items_all');

976: WHEN OTHERS THEN
977: x_return_status := fnd_api.g_ret_sts_unexp_error;
978:
979: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
980: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items_all');
981: fnd_message.set_token('ERRNO', sqlcode);
982: fnd_message.set_token('REASON', sqlerrm);
983: FND_MSG_PUB.ADD;
984:

Line 1015: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_WAREHOUSES';

1011: ORDER BY ood.organization_name;
1012:
1013: l_search_criteria_tbl search_criteria_tbl_type := p_search_criteria;
1014: l_warehouse_tbl warehouse_tbl_type;
1015: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_WAREHOUSES';
1016:
1017: BEGIN
1018: x_rec_count := 0;
1019: x_return_status := fnd_api.g_ret_sts_success;

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 1050: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_warehouses');

1046: WHEN OTHERS THEN
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048:
1049: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1050: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_warehouses');
1051: fnd_message.set_token('ERRNO', sqlcode);
1052: fnd_message.set_token('REASON', sqlerrm);
1053: FND_MSG_PUB.ADD;
1054: END search_warehouses;

Line 1068: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_COVEREDINVENTORY';

1064: l_covered_inv_wh_tbl dpp_inv_cov_wh_tbl_type;
1065: l_covered_inv_rct_tbl dpp_inv_cov_rct_tbl_type;
1066: l_num_count NUMBER;
1067: l_primary_uom_code VARCHAR2(3);
1068: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_COVEREDINVENTORY';
1069:
1070: CURSOR get_covered_inventory_csr (p_org_id IN NUMBER, p_effective_start_date DATE, p_effective_end_date DATE, p_inventory_item_id IN NUMBER) IS
1071: SELECT
1072: sum(case when ( (NVL(moqd.orig_date_received,moqd.date_received) >= p_effective_start_date)

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 1220: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CoveredInventory');

1216: WHEN OTHERS THEN
1217: x_return_status := fnd_api.g_ret_sts_unexp_error;
1218:
1219: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1220: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CoveredInventory');
1221: fnd_message.set_token('ERRNO', sqlcode);
1222: fnd_message.set_token('REASON', sqlerrm);
1223: FND_MSG_PUB.ADD;
1224:

Line 1244: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_INVENTORYDETAILS';

1240: l_include_flag VARCHAR2(1);
1241: l_flag VARCHAR2(1);
1242: l_days_out NUMBER;
1243: l_primary_uom_code VARCHAR2(3);
1244: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_INVENTORYDETAILS';
1245:
1246: CURSOR get_covered_inventory_csr (p_org_id IN NUMBER, p_effective_start_date DATE, p_effective_end_date DATE, p_inventory_item_id IN NUMBER) IS
1247: SELECT
1248: sum(case when ((trunc(NVL(moqd.orig_date_received,moqd.date_received)) >= trunc(p_effective_start_date))

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 1530: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_InventoryDetails');

1526: WHEN OTHERS THEN
1527: x_return_status := fnd_api.g_ret_sts_unexp_error;
1528:
1529: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1530: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_InventoryDetails');
1531: fnd_message.set_token('ERRNO', sqlcode);
1532: fnd_message.set_token('REASON', sqlerrm);
1533: FND_MSG_PUB.ADD;
1534:

Line 1546: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_CUSTOMERINVENTORY';

1542: )
1543: IS
1544: l_hdr_rec dpp_inv_hdr_rec_type := p_hdr_rec;
1545: l_cust_inv_tbl dpp_cust_inv_tbl_type := p_cust_inv_tbl;
1546: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_CUSTOMERINVENTORY';
1547:
1548: CURSOR get_customer_inventory_csr (p_effective_start_date IN DATE,
1549: p_effective_end_date IN DATE ,
1550: p_customer_id IN NUMBER,

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 1621: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CustomerInventory');

1617:
1618: WHEN OTHERS THEN
1619: x_return_status := fnd_api.g_ret_sts_unexp_error;
1620: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1621: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CustomerInventory');
1622: fnd_message.set_token('ERRNO', sqlcode);
1623: fnd_message.set_token('REASON', sqlerrm);
1624: FND_MSG_PUB.ADD;
1625: END Get_CustomerInventory;

Line 1637: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_CUSTOMERS';

1633: )
1634: IS
1635: l_search_criteria_tbl search_criteria_tbl_type := p_search_criteria;
1636: l_customer_tbl customer_tbl_type;
1637: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_CUSTOMERS';
1638:
1639: CURSOR get_customer_csr (
1640: p_search_criteria1 IN VARCHAR2, p_search_text1 IN VARCHAR2,
1641: p_search_criteria2 IN VARCHAR2, p_search_text2 IN VARCHAR2) IS

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 1704: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers');

1700: WHEN OTHERS THEN
1701: x_return_status := fnd_api.g_ret_sts_unexp_error;
1702:
1703: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1704: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers');
1705: fnd_message.set_token('ERRNO', sqlcode);
1706: fnd_message.set_token('REASON', sqlerrm);
1707: FND_MSG_PUB.ADD;
1708:

Line 1721: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_CUSTOMERS_ALL';

1717: )
1718: IS
1719: l_search_criteria_tbl search_criteria_tbl_type := p_search_criteria;
1720: l_customer_tbl customer_tbl_type;
1721: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.SEARCH_CUSTOMERS_ALL';
1722:
1723: CURSOR get_customers_all_csr (
1724: p_search_criteria1 IN VARCHAR2,
1725: p_search_text1 IN VARCHAR2

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 1773: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers_all');

1769: WHEN OTHERS THEN
1770: x_return_status := fnd_api.g_ret_sts_unexp_error;
1771:
1772: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1773: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers_all');
1774: fnd_message.set_token('ERRNO', sqlcode);
1775: fnd_message.set_token('REASON', sqlerrm);
1776: FND_MSG_PUB.ADD;
1777:

Line 1794: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_LASTPRICE';

1790: l_exchange_rate NUMBER;
1791: l_to_amount NUMBER;
1792: l_return_status VARCHAR2(1);
1793: l_trunc_sysdate DATE := trunc(sysdate);
1794: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_LASTPRICE';
1795:
1796: CURSOR get_last_price_csr (p_org_id IN NUMBER,
1797: p_inventory_item_id IN NUMBER,
1798: p_customer_id IN NUMBER,

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

1886: --Get the converted Price change if the currency is different
1887: IF l_hdr_rec.currency_code <> l_cust_price_tbl(i).invoice_currency_code THEN
1888: --Call the convert currency API to get the converted value of Price change
1889: l_to_amount := 0;
1890: DPP_UTILITY_PVT.convert_currency( p_from_currency => l_hdr_rec.currency_code
1891: ,p_to_currency => l_cust_price_tbl(i).invoice_currency_code
1892: ,p_conv_type => FND_API.G_MISS_CHAR
1893: ,p_conv_rate => FND_API.G_MISS_NUM
1894: ,p_conv_date => l_trunc_sysdate

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 1928: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_LastPrice');

1924: WHEN OTHERS THEN
1925: x_return_status := fnd_api.g_ret_sts_unexp_error;
1926:
1927: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1928: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_LastPrice');
1929: fnd_message.set_token('ERRNO', sqlcode);
1930: fnd_message.set_token('REASON', sqlerrm);
1931: FND_MSG_PUB.ADD;
1932:

Line 1951: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_LISTPRICE';

1947: l_exchange_rate NUMBER;
1948: l_to_amount NUMBER;
1949: l_return_status VARCHAR2(1);
1950: l_trunc_sysdate DATE := trunc(sysdate);
1951: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_LISTPRICE';
1952:
1953: CURSOR get_list_price_csr (p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
1954: SELECT
1955: msi.LIST_PRICE_PER_UNIT list_price

Line 2011: DPP_UTILITY_PVT.convert_currency(

2007: IF l_functional_currency = l_header_rec.currency_code THEN
2008: l_to_amount := get_list_price_rec.list_price;
2009: ELSE
2010: l_to_amount := 0;
2011: DPP_UTILITY_PVT.convert_currency(
2012: p_from_currency => l_functional_currency
2013: ,p_to_currency => l_header_rec.currency_code
2014: ,p_conv_type => FND_API.G_MISS_CHAR
2015: ,p_conv_rate => FND_API.G_MISS_NUM

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 2040: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_ListPrice');

2036: WHEN OTHERS THEN
2037: x_return_status := fnd_api.g_ret_sts_unexp_error;
2038:
2039: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2040: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_ListPrice');
2041: fnd_message.set_token('ERRNO', sqlcode);
2042: fnd_message.set_token('REASON', sqlerrm);
2043: FND_MSG_PUB.ADD;
2044:

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

2088: WHEN OTHERS THEN
2089: x_return_status := fnd_api.g_ret_sts_unexp_error;
2090:
2091: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2092: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor');
2093: fnd_message.set_token('ERRNO', sqlcode);
2094: fnd_message.set_token('REASON', sqlerrm);
2095: FND_MSG_PUB.ADD;
2096: END Get_Vendor;

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

2158: WHEN OTHERS THEN
2159: x_return_status := fnd_api.g_ret_sts_unexp_error;
2160:
2161: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2162: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Site');
2163: fnd_message.set_token('ERRNO', sqlcode);
2164: fnd_message.set_token('REASON', sqlerrm);
2165: FND_MSG_PUB.ADD;
2166: END Get_Vendor_Site;

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

2226: WHEN OTHERS THEN
2227: x_return_status := fnd_api.g_ret_sts_unexp_error;
2228:
2229: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2230: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Contact');
2231: fnd_message.set_token('ERRNO', sqlcode);
2232: fnd_message.set_token('REASON', sqlerrm);
2233: FND_MSG_PUB.ADD;
2234: END Get_Vendor_Contact;

Line 2251: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_WAREHOUSE';

2247: org_organization_definitions ood
2248: WHERE
2249: ood.organization_id = p_organization_id;
2250: l_warehouse_tbl warehouse_tbl_type := p_warehouse_tbl;
2251: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_WAREHOUSE';
2252:
2253: BEGIN
2254: x_rec_count := 0;
2255: x_return_status := fnd_api.g_ret_sts_success;

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 2289: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Warehouse');

2285: WHEN OTHERS THEN
2286: x_return_status := fnd_api.g_ret_sts_unexp_error;
2287:
2288: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2289: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Warehouse');
2290: fnd_message.set_token('ERRNO', sqlcode);
2291: fnd_message.set_token('REASON', sqlerrm);
2292: FND_MSG_PUB.ADD;
2293: END Get_Warehouse;

Line 2313: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_CUSTOMER';

2309: hp.party_id = hz.party_id and
2310: hz.cust_account_id = p_customer_id;
2311:
2312: l_customer_tbl customer_tbl_type := p_customer_tbl;
2313: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_CUSTOMER';
2314:
2315: BEGIN
2316: x_rec_count := 0;
2317: x_return_status := fnd_api.g_ret_sts_success;

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 2348: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Customer');

2344: EXCEPTION
2345: WHEN OTHERS THEN
2346: x_return_status := fnd_api.g_ret_sts_unexp_error;
2347: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2348: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Customer');
2349: fnd_message.set_token('ERRNO', sqlcode);
2350: fnd_message.set_token('REASON', sqlerrm);
2351: FND_MSG_PUB.ADD;
2352: END Get_Customer;

Line 2363: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_PRODUCT';

2359: )
2360: IS
2361:
2362: l_org_id NUMBER;
2363: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.GET_PRODUCT';
2364:
2365: CURSOR Get_Product_csr (p_inventory_item_id IN NUMBER, p_org_id IN NUMBER)
2366: IS
2367: SELECT concatenated_segments,

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 2422: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Product');

2418: WHEN OTHERS THEN
2419: x_return_status := fnd_api.g_ret_sts_unexp_error;
2420:
2421: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2422: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Product');
2423: fnd_message.set_token('ERRNO', sqlcode);
2424: fnd_message.set_token('REASON', sqlerrm);
2425: FND_MSG_PUB.ADD;
2426: END Get_Product;

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

2513: WHEN OTHERS THEN
2514: x_return_status := fnd_api.g_ret_sts_unexp_error;
2515:
2516: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2517: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.get_EmailAddress');
2518: fnd_message.set_token('ERRNO', sqlcode);
2519: fnd_message.set_token('REASON', sqlerrm);
2520: FND_MSG_PUB.ADD;
2521: END get_EmailAddress;

Line 2544: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.CONVERT_CURRENCY';

2540: -- this should be a profile
2541: l_denominator NUMBER; -- Not used in Marketing.
2542: l_numerator NUMBER; -- Not used in Marketing.
2543: l_conversion_type VARCHAR2(30); -- Curr conversion type; see API doc for details.
2544: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.CONVERT_CURRENCY';
2545:
2546: BEGIN
2547: -- Initialize return status.
2548: x_return_status := fnd_api.g_ret_sts_success;

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

2593: x_return_status := fnd_api.g_ret_sts_error;
2594: WHEN OTHERS THEN
2595: x_return_status := fnd_api.g_ret_sts_unexp_error;
2596: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
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);

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 2628: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.CALCULATE_FUNCTIONAL_CURR';

2624: l_denominator NUMBER; -- Not used in Marketing.
2625: l_numerator NUMBER; -- Not used in Marketing.
2626: l_conversion_type VARCHAR2(30);
2627: l_org_id NUMBER;
2628: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_UTILITY_PVT.CALCULATE_FUNCTIONAL_CURR';
2629:
2630: -- Cursor to get the primary set_of_books_id ,functional_currency_code
2631: CURSOR c_get_gl_info(p_org_id IN NUMBER)
2632: IS

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;

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

2730: WHEN OTHERS THEN
2731: x_return_status := fnd_api.g_ret_sts_unexp_error;
2732:
2733: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2734: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.Convert_functional_curr');
2735: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2736: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);
2737: FND_MSG_PUB.ADD;
2738: END calculate_functional_curr;

Line 2760: END DPP_UTILITY_PVT;

2756: BEGIN
2757: RETURN gl_mc_currency_pkg.CurrRound(p_amount, p_currency_code);
2758: END CurrRound;
2759:
2760: END DPP_UTILITY_PVT;