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.PV_OPP_MATCH_PUB dependencies on DBMS_UTILITY

Line 404: l_start := dbms_utility.get_time;

400: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
401: Debug('Rule Caching............................................');
402: END IF;
403:
404: l_start := dbms_utility.get_time;
405: Cache_Rules;
406:
407: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
408: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

Line 408: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

404: l_start := dbms_utility.get_time;
405: Cache_Rules;
406:
407: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
408: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
409: END IF;
410:
411: l_count := g_opp_selection_tab.COUNT;
412:

Line 423: l_start := dbms_utility.get_time;

419: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
420: Debug('Opportunity Rule Selection Starts....................................');
421: END IF;
422:
423: l_start := dbms_utility.get_time;
424:
425: WHILE (i <= l_count AND (NOT l_stop_flag)) LOOP
426: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
427: Debug('******************************************************');

Line 632: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

628: x_selected_rule_id := g_opp_selection_tab(i).process_rule_id;
629:
630: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
631: Debug('%%%%%%%Selected Rule ID: ' || x_selected_rule_id);
632: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
633: Debug('Number of rule items scanned/evaluated before finding a matching rule: ' || i);
634: END IF;
635:
636: -- -------------------------------------------------------------

Line 756: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

752: END IF;
753: END LOOP;
754:
755: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
756: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
757: END IF;
758:
759: IF (NOT l_stop_flag) THEN
760: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1357: l_start := DBMS_UTILITY.get_time;

1353: Debug('..........................................................');
1354: Debug('Calling Form_Where_Clause.......................');
1355: END IF;
1356:
1357: l_start := DBMS_UTILITY.get_time;
1358:
1359: pv_match_v2_pub.Form_Where_Clause(
1360: p_api_version_number => p_api_version,
1361: p_attr_id_tbl => l_attr_id_tbl,

Line 1392: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1388: RAISE FND_API.g_exc_unexpected_error;
1389: END IF;
1390:
1391: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1392: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1393:
1394: Debug('# of Partners Matched: ' || x_partner_tbl.COUNT);
1395: Debug('Partners Matched: ');
1396:

Line 1474: l_start := DBMS_UTILITY.get_time;

1470: Debug('Calling pv_locator.Get_Partners..........................');
1471: Debug('# of Partners Sent: ' || l_partner_id_tbl.COUNT);
1472: END IF;
1473:
1474: l_start := DBMS_UTILITY.get_time;
1475:
1476: pv_locator.Get_Partners (
1477: p_api_version => p_api_version,
1478: p_customer_address => l_customer_address,

Line 1501: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1497: RAISE FND_API.g_exc_unexpected_error;
1498: END IF;
1499:
1500: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1501: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1502: END IF;
1503:
1504: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1505: x_distance_uom_returned := 'KILOMETERS';

Line 1550: l_start := DBMS_UTILITY.get_time;

1546: Debug('Calling Tie_Breaker......................................');
1547: Debug('# of Partners Sent: ' || x_partner_tbl.COUNT);
1548: END IF;
1549:
1550: l_start := DBMS_UTILITY.get_time;
1551:
1552: Tie_Breaker(
1553: p_api_version => p_api_version,
1554: p_process_rule_id => p_process_rule_id,

Line 1571: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1567: RAISE FND_API.g_exc_unexpected_error;
1568: END IF;
1569:
1570: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1571: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1572: END IF;
1573: END IF;
1574:
1575: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1660: l_start := DBMS_UTILITY.get_time;

1656: ELSE
1657: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1658: Debug('Preferred Partner Party ID: ' || l_preferred_partner_party_id);
1659: END IF;
1660: l_start := DBMS_UTILITY.get_time;
1661:
1662: -- ----------------------------------------------------------------------------
1663: -- If the preferred partner already exists in x_partner_tbl, delete it from
1664: -- x_partner_tbl. The reason for doing this is that preferred partner should

Line 1705: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1701: x_distance_uom_returned := 'MILES';
1702: END IF;
1703:
1704: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1705: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1706: Debug('Distance Unit Returned: ' || x_distance_uom_returned);
1707: END IF;
1708:
1709: -- ---------------------------------------------------------------------------

Line 1768: l_start := DBMS_UTILITY.get_time;

1764: Debug('..........................................................');
1765: Debug('Calling pv_match_v2_pub.Get_Matched_Partner_Details..........................');
1766: END IF;
1767:
1768: l_start := DBMS_UTILITY.get_time;
1769:
1770: pv_match_v2_pub.Get_Matched_Partner_Details(
1771: p_api_version_number => p_api_version,
1772: p_init_msg_list => FND_API.G_FALSE,

Line 1802: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1798: RAISE FND_API.g_exc_unexpected_error;
1799: END IF;
1800:
1801: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1802: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1803: END IF;
1804:
1805:
1806: -- -----------------------------------------------------------------

Line 1912: l_start := DBMS_UTILITY.get_time;

1908: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1909: Debug('Routing the opportunity to partner(s)....................');
1910: END IF;
1911:
1912: l_start := DBMS_UTILITY.get_time;
1913:
1914: -- -------------------------------------------------------------
1915: -- Retrieve user name if it's NULL.
1916: -- -------------------------------------------------------------

Line 1960: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1956: RAISE FND_API.g_exc_unexpected_error;
1957: END IF;
1958:
1959: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1960: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1961: END IF;
1962: END IF;
1963:
1964:

Line 2335: l_start := dbms_utility.get_time;

2331: -- -------------------------------------------------------
2332: -- Check for dupes. No need to continue if there are no
2333: -- dupes.
2334: -- -------------------------------------------------------
2335: l_start := dbms_utility.get_time;
2336:
2337: BEGIN
2338: SELECT *
2339: INTO l_dup_count

Line 2359: Debug('Finding Dups Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

2355:
2356: FETCH c_tie_breaking_attr INTO lc_cursor;
2357:
2358: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2359: Debug('Finding Dups Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2360: END IF;
2361: END LOOP;
2362:
2363: CLOSE c_tie_breaking_attr;

Line 2388: l_start := dbms_utility.get_time;

2384: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2385: Debug('Start sorting..............................');
2386: END IF;
2387:
2388: l_start := dbms_utility.get_time;
2389:
2390: l_index := 1;
2391:
2392: FOR x IN (

Line 2426: Debug('Sorting Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

2422:
2423:
2424: -- DEBUGGING -------------------------------------------------------------
2425: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2426: Debug('Sorting Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2427:
2428: Debug('Printing out partner IDs after sorting...');
2429: FOR i IN 1..x_partner_tbl.COUNT LOOP
2430: Debug(x_partner_tbl(i));