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_PARTNER_GEO_MATCH_PVT dependencies on PVX_UTILITY_PVT

Line 247: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

243:
244: -- Debug Message
245: IF (PV_DEBUG_HIGH_ON) THEN
246:
247: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
248: END IF;
249:
250:
251:

Line 260: PVX_UTILITY_PVT.debug_message('Address not found.');

256: OPEN c_get_address(p_partner_party_id);
257: FETCH c_get_address INTO l_address_rec;
258: IF c_get_address%NOTFOUND THEN
259: IF (PV_DEBUG_HIGH_ON) THEN
260: PVX_UTILITY_PVT.debug_message('Address not found.');
261: END IF;
262: l_exist_address_flag := 'N';
263: END IF;
264: CLOSE c_get_address;

Line 282: PVX_UTILITY_PVT.debug_message('l_postal_code_start = ' || l_postal_code_start);

278: INTO l_postal_code_end
279: FROM dual;
280:
281: IF (PV_DEBUG_HIGH_ON) THEN
282: PVX_UTILITY_PVT.debug_message('l_postal_code_start = ' || l_postal_code_start);
283: END IF;
284:
285: IF (PV_DEBUG_HIGH_ON) THEN
286: PVX_UTILITY_PVT.debug_message('l_postal_code_end = ' || l_postal_code_end);

Line 286: PVX_UTILITY_PVT.debug_message('l_postal_code_end = ' || l_postal_code_end);

282: PVX_UTILITY_PVT.debug_message('l_postal_code_start = ' || l_postal_code_start);
283: END IF;
284:
285: IF (PV_DEBUG_HIGH_ON) THEN
286: PVX_UTILITY_PVT.debug_message('l_postal_code_end = ' || l_postal_code_end);
287: END IF;
288:
289: IF l_postal_code_start <= l_address_rec.postal_code AND
290: l_address_rec.postal_code >= l_postal_code_end THEN

Line 430: PVX_UTILITY_PVT.debug_message('Final used geo_hierarchy_id = ' || x_geo_hierarchy_id);

426:
427: x_geo_hierarchy_id := l_geo_hierarchy_id;
428:
429: IF (PV_DEBUG_HIGH_ON) THEN
430: PVX_UTILITY_PVT.debug_message('Final used geo_hierarchy_id = ' || x_geo_hierarchy_id);
431: END IF;
432:
433:
434: -- Debug Message

Line 437: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');

433:
434: -- Debug Message
435: IF (PV_DEBUG_HIGH_ON) THEN
436:
437: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
438: END IF;
439:
440: -- Standard call to get message count and if count is 1, get message info.
441: FND_MSG_PUB.Count_And_Get

Line 580: PVX_UTILITY_PVT.debug_message('Final used geo_hierarchy_id = ' || x_geo_hierarchy_id);

576:
577: x_geo_hierarchy_id := l_geo_hierarchy_id;
578:
579: IF (PV_DEBUG_HIGH_ON) THEN
580: PVX_UTILITY_PVT.debug_message('Final used geo_hierarchy_id = ' || x_geo_hierarchy_id);
581: END IF;
582: END Get_Matched_Geo_Id_By_Country;
583:
584:

Line 639: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

635:
636: -- Debug Message
637: IF (PV_DEBUG_HIGH_ON) THEN
638:
639: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
640: END IF;
641:
642: -- Initialize API return status to SUCCESS
643: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 732: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

728:
729: -- Debug Message
730: IF (PV_DEBUG_HIGH_ON) THEN
731:
732: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
733: END IF;
734:
735: -- Initialize API return status to SUCCESS
736: x_return_status := FND_API.G_RET_STS_SUCCESS;