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_MATCH_V3_PUB dependencies on DBMS_UTILITY

Line 343: l_start := dbms_utility.get_time;

339: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
340: Debug('Rule Caching............................................');
341: END IF;
342:
343: l_start := dbms_utility.get_time;
344: Cache_Rules;
345:
346: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
347: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

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

343: l_start := dbms_utility.get_time;
344: Cache_Rules;
345:
346: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
347: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
348: END IF;
349:
350: l_count := g_opp_selection_tab.COUNT;
351:

Line 362: l_start := dbms_utility.get_time;

358: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
359: Debug('Opportunity Rule Selection Starts....................................');
360: END IF;
361:
362: l_start := dbms_utility.get_time;
363:
364: WHILE (i <= l_count AND (NOT l_stop_flag)) LOOP
365: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
366: Debug('******************************************************');

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

566: x_selected_rule_id := g_opp_selection_tab(i).process_rule_id;
567:
568: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
569: Debug('%%%%%%%Selected Rule ID: ' || x_selected_rule_id);
570: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
571: Debug('Number of rule items scanned/evaluated before finding a matching rule: ' || i);
572: END IF;
573:
574: -- -------------------------------------------------------------

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

685: END IF;
686: END LOOP;
687:
688: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
689: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
690: END IF;
691:
692: IF (NOT l_stop_flag) THEN
693: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1225: l_start := DBMS_UTILITY.get_time;

1221: Debug('..........................................................');
1222: Debug('Calling Form_Where_Clause.......................');
1223: END IF;
1224:
1225: l_start := DBMS_UTILITY.get_time;
1226:
1227: pv_match_v2_pub.Form_Where_Clause(
1228: p_api_version_number => p_api_version,
1229: p_attr_id_tbl => l_attr_id_tbl,

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

1256: RAISE FND_API.g_exc_unexpected_error;
1257: END IF;
1258:
1259: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1260: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1261:
1262: Debug('# of Partners Matched: ' || x_partner_tbl.COUNT);
1263: Debug('Partners Matched: ');
1264:

Line 1342: l_start := DBMS_UTILITY.get_time;

1338: Debug('Calling pv_locator.Get_Partners..........................');
1339: Debug('# of Partners Sent: ' || l_partner_id_tbl.COUNT);
1340: END IF;
1341:
1342: l_start := DBMS_UTILITY.get_time;
1343:
1344: pv_locator.Get_Partners (
1345: p_api_version => p_api_version,
1346: p_customer_address => l_customer_address,

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

1365: RAISE FND_API.g_exc_unexpected_error;
1366: END IF;
1367:
1368: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1369: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1370: END IF;
1371:
1372: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1373: x_distance_uom_returned := 'KILOMETERS';

Line 1418: l_start := DBMS_UTILITY.get_time;

1414: Debug('Calling Tie_Breaker......................................');
1415: Debug('# of Partners Sent: ' || x_partner_tbl.COUNT);
1416: END IF;
1417:
1418: l_start := DBMS_UTILITY.get_time;
1419:
1420: Tie_Breaker(
1421: p_api_version => p_api_version,
1422: p_process_rule_id => p_process_rule_id,

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

1435: RAISE FND_API.g_exc_unexpected_error;
1436: END IF;
1437:
1438: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1439: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1440: END IF;
1441: END IF;
1442:
1443: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1460: l_start := DBMS_UTILITY.get_time;

1456: Debug('..........................................................');
1457: Debug('Calling Get_Matched_Partner_Details..........................');
1458: END IF;
1459:
1460: l_start := DBMS_UTILITY.get_time;
1461:
1462: IF (x_distance_tbl.EXISTS(1)) THEN
1463: FOR i IN 1..x_partner_tbl.COUNT LOOP
1464: x_distance_tbl(i) := l_partner_distance_tbl(x_partner_tbl(i));

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

1503: RAISE FND_API.g_exc_unexpected_error;
1504: END IF;
1505:
1506: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1507: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1508: END IF;
1509:
1510: -- ------------------------------------------------------------------
1511: -- Reassign distance to each partner.

Line 2769: l_start := dbms_utility.get_time;

2765: -- -------------------------------------------------------
2766: -- Check for dupes. No need to continue if there are no
2767: -- dupes.
2768: -- -------------------------------------------------------
2769: l_start := dbms_utility.get_time;
2770:
2771: BEGIN
2772: SELECT *
2773: INTO l_dup_count

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

2789:
2790: FETCH c_tie_breaking_attr INTO lc_cursor;
2791:
2792: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2793: Debug('Finding Dups Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2794: END IF;
2795: END LOOP;
2796:
2797: CLOSE c_tie_breaking_attr;

Line 2822: l_start := dbms_utility.get_time;

2818: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2819: Debug('Start sorting..............................');
2820: END IF;
2821:
2822: l_start := dbms_utility.get_time;
2823:
2824: l_index := 1;
2825:
2826: FOR x IN (

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

2856:
2857:
2858: -- DEBUGGING -------------------------------------------------------------
2859: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2860: Debug('Sorting Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2861:
2862: Debug('Printing out partner IDs after sorting...');
2863: FOR i IN 1..x_partner_tbl.COUNT LOOP
2864: Debug(x_partner_tbl(i));