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.WSH_GEOCODING dependencies on WSH_DEBUG_SV

Line 91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

87: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
88: --
89: IF l_debug_on IS NULL
90: THEN
91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
92: END IF;
93: --
94: --
95: -- Debug Statements

Line 98: WSH_DEBUG_SV.push(l_module_name);

94: --
95: -- Debug Statements
96: --
97: IF l_debug_on THEN
98: WSH_DEBUG_SV.push(l_module_name);
99: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',l_location.WSH_LOCATION_ID);
100: WSH_DEBUG_SV.log(l_module_name,'LOCATION_SOURCE_CODE',l_location.LOCATION_SOURCE_CODE);
101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);
102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);

Line 99: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',l_location.WSH_LOCATION_ID);

95: -- Debug Statements
96: --
97: IF l_debug_on THEN
98: WSH_DEBUG_SV.push(l_module_name);
99: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',l_location.WSH_LOCATION_ID);
100: WSH_DEBUG_SV.log(l_module_name,'LOCATION_SOURCE_CODE',l_location.LOCATION_SOURCE_CODE);
101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);
102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);
103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);

Line 100: WSH_DEBUG_SV.log(l_module_name,'LOCATION_SOURCE_CODE',l_location.LOCATION_SOURCE_CODE);

96: --
97: IF l_debug_on THEN
98: WSH_DEBUG_SV.push(l_module_name);
99: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',l_location.WSH_LOCATION_ID);
100: WSH_DEBUG_SV.log(l_module_name,'LOCATION_SOURCE_CODE',l_location.LOCATION_SOURCE_CODE);
101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);
102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);
103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);
104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);

Line 101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);

97: IF l_debug_on THEN
98: WSH_DEBUG_SV.push(l_module_name);
99: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',l_location.WSH_LOCATION_ID);
100: WSH_DEBUG_SV.log(l_module_name,'LOCATION_SOURCE_CODE',l_location.LOCATION_SOURCE_CODE);
101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);
102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);
103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);
104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);
105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);

Line 102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);

98: WSH_DEBUG_SV.push(l_module_name);
99: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',l_location.WSH_LOCATION_ID);
100: WSH_DEBUG_SV.log(l_module_name,'LOCATION_SOURCE_CODE',l_location.LOCATION_SOURCE_CODE);
101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);
102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);
103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);
104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);
105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);
106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);

Line 103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);

99: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',l_location.WSH_LOCATION_ID);
100: WSH_DEBUG_SV.log(l_module_name,'LOCATION_SOURCE_CODE',l_location.LOCATION_SOURCE_CODE);
101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);
102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);
103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);
104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);
105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);
106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);
107: WSH_DEBUG_SV.log(l_module_name,'LATITUDE',l_location.LATITUDE);

Line 104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);

100: WSH_DEBUG_SV.log(l_module_name,'LOCATION_SOURCE_CODE',l_location.LOCATION_SOURCE_CODE);
101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);
102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);
103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);
104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);
105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);
106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);
107: WSH_DEBUG_SV.log(l_module_name,'LATITUDE',l_location.LATITUDE);
108: WSH_DEBUG_SV.log(l_module_name,'LONGITUDE',l_location.LONGITUDE);

Line 105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);

101: WSH_DEBUG_SV.log(l_module_name,'COUNTRY',l_location.COUNTRY);
102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);
103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);
104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);
105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);
106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);
107: WSH_DEBUG_SV.log(l_module_name,'LATITUDE',l_location.LATITUDE);
108: WSH_DEBUG_SV.log(l_module_name,'LONGITUDE',l_location.LONGITUDE);
109: WSH_DEBUG_SV.log(l_module_name,'TIMEZONE_CODE',l_location.TIMEZONE_CODE);

Line 106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);

102: WSH_DEBUG_SV.log(l_module_name,'PROVINCE',l_location.PROVINCE);
103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);
104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);
105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);
106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);
107: WSH_DEBUG_SV.log(l_module_name,'LATITUDE',l_location.LATITUDE);
108: WSH_DEBUG_SV.log(l_module_name,'LONGITUDE',l_location.LONGITUDE);
109: WSH_DEBUG_SV.log(l_module_name,'TIMEZONE_CODE',l_location.TIMEZONE_CODE);
110: END IF;

Line 107: WSH_DEBUG_SV.log(l_module_name,'LATITUDE',l_location.LATITUDE);

103: WSH_DEBUG_SV.log(l_module_name,'STATE',l_location.STATE);
104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);
105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);
106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);
107: WSH_DEBUG_SV.log(l_module_name,'LATITUDE',l_location.LATITUDE);
108: WSH_DEBUG_SV.log(l_module_name,'LONGITUDE',l_location.LONGITUDE);
109: WSH_DEBUG_SV.log(l_module_name,'TIMEZONE_CODE',l_location.TIMEZONE_CODE);
110: END IF;
111:

Line 108: WSH_DEBUG_SV.log(l_module_name,'LONGITUDE',l_location.LONGITUDE);

104: WSH_DEBUG_SV.log(l_module_name,'COUNTY',l_location.COUNTY);
105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);
106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);
107: WSH_DEBUG_SV.log(l_module_name,'LATITUDE',l_location.LATITUDE);
108: WSH_DEBUG_SV.log(l_module_name,'LONGITUDE',l_location.LONGITUDE);
109: WSH_DEBUG_SV.log(l_module_name,'TIMEZONE_CODE',l_location.TIMEZONE_CODE);
110: END IF;
111:
112: IF (l_location.postal_code IS NOT NULL) THEN

Line 109: WSH_DEBUG_SV.log(l_module_name,'TIMEZONE_CODE',l_location.TIMEZONE_CODE);

105: WSH_DEBUG_SV.log(l_module_name,'CITY',l_location.CITY);
106: WSH_DEBUG_SV.log(l_module_name,'POSTAL_CODE',l_location.POSTAL_CODE);
107: WSH_DEBUG_SV.log(l_module_name,'LATITUDE',l_location.LATITUDE);
108: WSH_DEBUG_SV.log(l_module_name,'LONGITUDE',l_location.LONGITUDE);
109: WSH_DEBUG_SV.log(l_module_name,'TIMEZONE_CODE',l_location.TIMEZONE_CODE);
110: END IF;
111:
112: IF (l_location.postal_code IS NOT NULL) THEN
113:

Line 372: WSH_DEBUG_SV.log(l_module_name,'Calling program unit HZ_TIMEZONE_PUB.Get_Primary_Zone');

368:
369: IF (x_record_found) THEN
370:
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'Calling program unit HZ_TIMEZONE_PUB.Get_Primary_Zone');
373: END IF;
374:
375: /* Following workaround is because of non availability of NAVTECH data yet */
376: x_begin_dst_hour := 2;

Line 413: WSH_DEBUG_SV.log(l_module_name,'No record found in wsh_location_data_ext');

409: x_msg_count,
410: x_msg_data );
411: ELSE
412: IF l_debug_on THEN
413: WSH_DEBUG_SV.log(l_module_name,'No record found in wsh_location_data_ext');
414: END IF;
415: END IF;
416: l_location.latitude := x_latitude;
417: l_location.longitude := x_longitude;

Line 421: WSH_DEBUG_SV.log(l_module_name,'After calling HZ API ');

417: l_location.longitude := x_longitude;
418: l_location.timezone_code := x_timezone_code;
419: l_location.geometry := x_geometry;
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.log(l_module_name,'After calling HZ API ');
422: WSH_DEBUG_SV.log(l_module_name,'latitude : ' || l_location.latitude);
423: WSH_DEBUG_SV.log(l_module_name,'longitude : ' || l_location.longitude);
424: WSH_DEBUG_SV.log(l_module_name,'timezone_code : ' || l_location.timezone_code);
425: END IF;

Line 422: WSH_DEBUG_SV.log(l_module_name,'latitude : ' || l_location.latitude);

418: l_location.timezone_code := x_timezone_code;
419: l_location.geometry := x_geometry;
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.log(l_module_name,'After calling HZ API ');
422: WSH_DEBUG_SV.log(l_module_name,'latitude : ' || l_location.latitude);
423: WSH_DEBUG_SV.log(l_module_name,'longitude : ' || l_location.longitude);
424: WSH_DEBUG_SV.log(l_module_name,'timezone_code : ' || l_location.timezone_code);
425: END IF;
426:

Line 423: WSH_DEBUG_SV.log(l_module_name,'longitude : ' || l_location.longitude);

419: l_location.geometry := x_geometry;
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.log(l_module_name,'After calling HZ API ');
422: WSH_DEBUG_SV.log(l_module_name,'latitude : ' || l_location.latitude);
423: WSH_DEBUG_SV.log(l_module_name,'longitude : ' || l_location.longitude);
424: WSH_DEBUG_SV.log(l_module_name,'timezone_code : ' || l_location.timezone_code);
425: END IF;
426:
427: ELSE

Line 424: WSH_DEBUG_SV.log(l_module_name,'timezone_code : ' || l_location.timezone_code);

420: IF l_debug_on THEN
421: WSH_DEBUG_SV.log(l_module_name,'After calling HZ API ');
422: WSH_DEBUG_SV.log(l_module_name,'latitude : ' || l_location.latitude);
423: WSH_DEBUG_SV.log(l_module_name,'longitude : ' || l_location.longitude);
424: WSH_DEBUG_SV.log(l_module_name,'timezone_code : ' || l_location.timezone_code);
425: END IF;
426:
427: ELSE
428:

Line 430: WSH_DEBUG_SV.log(l_module_name,'No record found in wsh_location_data_ext');

426:
427: ELSE
428:
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.log(l_module_name,'No record found in wsh_location_data_ext');
431: END IF;
432:
433: END IF;
434:

Line 436: WSH_DEBUG_SV.pop(l_module_name);

432:
433: END IF;
434:
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.pop(l_module_name);
437: END IF;
438:
439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN

Line 443: WSH_DEBUG_SV.pop(l_module_name);

439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN
441: p_SqlErrM := sqlerrm||'(Could not find entry for Location)';
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.pop(l_module_name);
444: END IF;
445:
446: END Get_Lat_Long_and_TimeZone;
447: