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_REGIONS_SEARCH_PKG dependencies on WSH_DEBUG_SV

Line 93: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

89: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
90: --
91: IF l_debug_on IS NULL
92: THEN
93: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
94: END IF;
95:
96: l_return_status := FND_API.G_RET_STS_SUCCESS;
97: --

Line 102: WSH_DEBUG_SV.push(l_module_name);

98: --
99: -- Debug Statements
100: --
101: IF l_debug_on THEN
102: WSH_DEBUG_SV.push(l_module_name);
103: --
104: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
105: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
106: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);

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

100: --
101: IF l_debug_on THEN
102: WSH_DEBUG_SV.push(l_module_name);
103: --
104: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
105: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
106: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
107: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

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

101: IF l_debug_on THEN
102: WSH_DEBUG_SV.push(l_module_name);
103: --
104: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
105: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
106: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
107: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);

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

102: WSH_DEBUG_SV.push(l_module_name);
103: --
104: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
105: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
106: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
107: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

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

103: --
104: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
105: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
106: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
107: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

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

104: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
105: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
106: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
107: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
112: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

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

105: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
106: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
107: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
112: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
113: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

Line 110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

106: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
107: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
112: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
113: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
114: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

Line 111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

107: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
112: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
113: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
114: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
115: END IF;

Line 112: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

108: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
112: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
113: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
114: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
115: END IF;
116: l_key := TO_CHAR(P_REGION_TYPE, g_int_mask) ||'-'||

Line 113: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

109: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
112: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
113: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
114: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
115: END IF;
116: l_key := TO_CHAR(P_REGION_TYPE, g_int_mask) ||'-'||
117: LPAD(P_COUNTRY, g_lpad_length, g_lpad_char) ||'-'||

Line 114: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

110: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
111: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
112: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
113: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
114: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
115: END IF;
116: l_key := TO_CHAR(P_REGION_TYPE, g_int_mask) ||'-'||
117: LPAD(P_COUNTRY, g_lpad_length, g_lpad_char) ||'-'||
118: LPAD(P_COUNTRY_CODE, g_lpad_code_length, g_lpad_char) ||'-'||

Line 131: WSH_DEBUG_SV.pop(l_module_name);

127:
128: x_key := l_key;
129:
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.pop(l_module_name);
132: END IF;
133: x_return_status := l_return_status;
134: EXCEPTION
135: WHEN others THEN

Line 140: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

136: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_key');
137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
138: --
139: IF l_debug_on THEN
140: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
142: END IF;
143: END get_key;
144:

Line 141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
138: --
139: IF l_debug_on THEN
140: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
142: END IF;
143: END get_key;
144:
145: PROCEDURE Get_Region_Info (

Line 173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

169: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
170: --
171: IF l_debug_on IS NULL
172: THEN
173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
174: END IF;
175: --
176: --
177: -- Debug Statements

Line 180: WSH_DEBUG_SV.push(l_module_name);

176: --
177: -- Debug Statements
178: --
179: IF l_debug_on THEN
180: WSH_DEBUG_SV.push(l_module_name);
181: --
182: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
183: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

Line 182: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);

178: --
179: IF l_debug_on THEN
180: WSH_DEBUG_SV.push(l_module_name);
181: --
182: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
183: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

Line 183: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);

179: IF l_debug_on THEN
180: WSH_DEBUG_SV.push(l_module_name);
181: --
182: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
183: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

Line 184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

180: WSH_DEBUG_SV.push(l_module_name);
181: --
182: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
183: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);

Line 185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);

181: --
182: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
183: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

Line 186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

182: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
183: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

Line 187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

183: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

Line 188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);

184: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

Line 189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

185: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
193: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

Line 190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

186: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
193: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
194: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

Line 191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

187: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
193: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
194: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
195: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

Line 192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

188: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
193: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
194: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
195: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
196: END IF;

Line 193: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

189: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
193: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
194: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
195: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
196: END IF;
197: --

Line 194: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

190: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
193: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
194: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
195: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
196: END IF;
197: --
198:

Line 195: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

191: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
192: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
193: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
194: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
195: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
196: END IF;
197: --
198:
199: Get_Region_Info (

Line 221: WSH_DEBUG_SV.pop(l_module_name);

217: --
218: -- Debug Statements
219: --
220: IF l_debug_on THEN
221: WSH_DEBUG_SV.pop(l_module_name);
222: END IF;
223: --
224: END Get_Region_Info;
225:

Line 278: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

274: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
275: --
276: IF l_debug_on IS NULL
277: THEN
278: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
279: END IF;
280: --
281: --
282: -- Debug Statements

Line 285: WSH_DEBUG_SV.push(l_module_name);

281: --
282: -- Debug Statements
283: --
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.push(l_module_name);
286: --
287: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
288: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

Line 287: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);

283: --
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.push(l_module_name);
286: --
287: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
288: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

Line 288: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);

284: IF l_debug_on THEN
285: WSH_DEBUG_SV.push(l_module_name);
286: --
287: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
288: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

Line 289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

285: WSH_DEBUG_SV.push(l_module_name);
286: --
287: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
288: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);

Line 290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);

286: --
287: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
288: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

Line 291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

287: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
288: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

Line 292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

288: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

Line 293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);

289: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

Line 294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

290: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

Line 295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

291: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
299: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

Line 296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

292: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
299: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
300: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

Line 297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

293: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
299: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
300: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
301: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);

Line 298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

294: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
299: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
300: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
301: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
302: END IF;

Line 299: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

295: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
299: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
300: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
301: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
302: END IF;
303: --

Line 300: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

296: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
299: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
300: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
301: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
302: END IF;
303: --
304: get_key(

Line 301: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);

297: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
298: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
299: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
300: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
301: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
302: END IF;
303: --
304: get_key(
305: p_country => p_country,

Line 320: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from get_key : '|| l_return_status);

316: x_key => l_key,
317: x_return_status => l_return_status);
318:
319: IF l_debug_on THEN
320: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from get_key : '|| l_return_status);
321: END IF;
322:
323: IF g_regions_info_tab.EXISTS(l_key) THEN
324: x_regions := g_regions_info_tab(l_key);

Line 326: wsh_debug_sv.log(l_module_name, 'used cache for key', l_key);

322:
323: IF g_regions_info_tab.EXISTS(l_key) THEN
324: x_regions := g_regions_info_tab(l_key);
325: IF l_debug_on THEN
326: wsh_debug_sv.log(l_module_name, 'used cache for key', l_key);
327: wsh_debug_sv.log(l_module_name, 'x_regions.count', x_regions.count);
328: END IF;
329: ELSE
330:

Line 327: wsh_debug_sv.log(l_module_name, 'x_regions.count', x_regions.count);

323: IF g_regions_info_tab.EXISTS(l_key) THEN
324: x_regions := g_regions_info_tab(l_key);
325: IF l_debug_on THEN
326: wsh_debug_sv.log(l_module_name, 'used cache for key', l_key);
327: wsh_debug_sv.log(l_module_name, 'x_regions.count', x_regions.count);
328: END IF;
329: ELSE
330:
331: IF (p_region_type IS NULL) THEN

Line 511: WSH_DEBUG_SV.logmsg(l_module_name, 'Get_Region_Id:: sql_string_length: ' || length(sql_string));

507:
508: -- Debug Statements
509: --
510: IF l_debug_on THEN
511: WSH_DEBUG_SV.logmsg(l_module_name, 'Get_Region_Id:: sql_string_length: ' || length(sql_string));
512: for i IN 1..length(sql_string) loop
513: if mod(i,100) = 0 then
514: WSH_DEBUG_SV.logmsg(l_module_name, substr(sql_string,i, 100));
515: end if;

Line 514: WSH_DEBUG_SV.logmsg(l_module_name, substr(sql_string,i, 100));

510: IF l_debug_on THEN
511: WSH_DEBUG_SV.logmsg(l_module_name, 'Get_Region_Id:: sql_string_length: ' || length(sql_string));
512: for i IN 1..length(sql_string) loop
513: if mod(i,100) = 0 then
514: WSH_DEBUG_SV.logmsg(l_module_name, substr(sql_string,i, 100));
515: end if;
516: end loop;
517: END IF;
518: IF (cnt = 0) THEN

Line 582: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching region info of '||l_region_info.region_id);

578: LOOP
579: FETCH l_region_cur INTO l_region_info;
580: EXIT WHEN l_region_cur%NOTFOUND;
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching region info of '||l_region_info.region_id);
583: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt);
584: END IF;
585: x_regions(cnt) := l_region_info;
586: cnt :=cnt + 1;

Line 583: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt);

579: FETCH l_region_cur INTO l_region_info;
580: EXIT WHEN l_region_cur%NOTFOUND;
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching region info of '||l_region_info.region_id);
583: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt);
584: END IF;
585: x_regions(cnt) := l_region_info;
586: cnt :=cnt + 1;
587:

Line 603: WSH_DEBUG_SV.pop(l_module_name);

599: --
600: -- Debug Statements
601: --
602: IF l_debug_on THEN
603: WSH_DEBUG_SV.pop(l_module_name);
604: END IF;
605: --
606: EXCEPTION
607: WHEN OTHERS THEN

Line 615: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

611: --
612: -- Debug Statements
613: --
614: IF l_debug_on THEN
615: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
617: --Bug 4775798
618: ELSE
619: WSH_UTIL_CORE.printmsg('Unexpected error has occured in Get_Region_Info');

Line 616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

612: -- Debug Statements
613: --
614: IF l_debug_on THEN
615: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
617: --Bug 4775798
618: ELSE
619: WSH_UTIL_CORE.printmsg('Unexpected error has occured in Get_Region_Info');
620: WSH_UTIL_CORE.printmsg('Oracle error message is '|| SQLERRM);

Line 710: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

706: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
707: --
708: IF l_debug_on IS NULL
709: THEN
710: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
711: END IF;
712: --
713: --
714: -- Debug Statements

Line 717: WSH_DEBUG_SV.push(l_module_name);

713: --
714: -- Debug Statements
715: --
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.push(l_module_name);
718: --
719: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
720: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

Line 719: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);

715: --
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.push(l_module_name);
718: --
719: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
720: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

Line 720: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);

716: IF l_debug_on THEN
717: WSH_DEBUG_SV.push(l_module_name);
718: --
719: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
720: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

Line 721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

717: WSH_DEBUG_SV.push(l_module_name);
718: --
719: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
720: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);

Line 722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);

718: --
719: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
720: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

Line 723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

719: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
720: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

Line 724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

720: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

Line 725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);

721: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

Line 726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

722: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

Line 727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

723: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

Line 728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

724: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
732: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

Line 729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

725: WSH_DEBUG_SV.log(l_module_name,'P_ZONE',P_ZONE);
726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
732: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
733: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);

Line 730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

726: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
732: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
733: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
734: WSH_DEBUG_SV.log(l_module_name,'P_RECURSIVELY_FLAG',P_RECURSIVELY_FLAG);

Line 731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

727: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
732: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
733: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
734: WSH_DEBUG_SV.log(l_module_name,'P_RECURSIVELY_FLAG',P_RECURSIVELY_FLAG);
735: END IF;

Line 732: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

728: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
732: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
733: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
734: WSH_DEBUG_SV.log(l_module_name,'P_RECURSIVELY_FLAG',P_RECURSIVELY_FLAG);
735: END IF;
736: --

Line 733: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);

729: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
732: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
733: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
734: WSH_DEBUG_SV.log(l_module_name,'P_RECURSIVELY_FLAG',P_RECURSIVELY_FLAG);
735: END IF;
736: --
737: Get_Region_Info (

Line 734: WSH_DEBUG_SV.log(l_module_name,'P_RECURSIVELY_FLAG',P_RECURSIVELY_FLAG);

730: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
731: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
732: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
733: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_FLAG',P_SEARCH_FLAG);
734: WSH_DEBUG_SV.log(l_module_name,'P_RECURSIVELY_FLAG',P_RECURSIVELY_FLAG);
735: END IF;
736: --
737: Get_Region_Info (
738: p_country => p_country,

Line 795: WSH_DEBUG_SV.pop(l_module_name);

791: --
792: -- Debug Statements
793: --
794: IF l_debug_on THEN
795: WSH_DEBUG_SV.pop(l_module_name);
796: END IF;
797: --
798: END Get_Region_Info;
799:

Line 843: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

839: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
840: --
841: IF l_debug_on IS NULL
842: THEN
843: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
844: END IF;
845: --
846: --
847: -- Debug Statements

Line 850: WSH_DEBUG_SV.push(l_module_name);

846: --
847: -- Debug Statements
848: --
849: IF l_debug_on THEN
850: WSH_DEBUG_SV.push(l_module_name);
851: --
852: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
853: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

Line 852: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

848: --
849: IF l_debug_on THEN
850: WSH_DEBUG_SV.push(l_module_name);
851: --
852: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
853: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

Line 853: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

849: IF l_debug_on THEN
850: WSH_DEBUG_SV.push(l_module_name);
851: --
852: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
853: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

Line 854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

850: WSH_DEBUG_SV.push(l_module_name);
851: --
852: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
853: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
858: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

Line 855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

851: --
852: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
853: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
858: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
859: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

Line 856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

852: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
853: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
858: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
859: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
860: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE_CODE',P_LANGUAGE_CODE);

Line 857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

853: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
858: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
859: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
860: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE_CODE',P_LANGUAGE_CODE);
861: END IF;

Line 858: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

854: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
858: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
859: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
860: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE_CODE',P_LANGUAGE_CODE);
861: END IF;
862: --

Line 859: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

855: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
858: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
859: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
860: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE_CODE',P_LANGUAGE_CODE);
861: END IF;
862: --
863: IF (p_country_code IS NULL AND p_state_code IS NULL AND p_city_code IS NULL ) THEN

Line 860: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE_CODE',P_LANGUAGE_CODE);

856: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
857: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
858: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
859: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
860: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE_CODE',P_LANGUAGE_CODE);
861: END IF;
862: --
863: IF (p_country_code IS NULL AND p_state_code IS NULL AND p_city_code IS NULL ) THEN
864: l_region_id := -1;

Line 869: WSH_DEBUG_SV.pop(l_module_name);

865: --
866: -- Debug Statements
867: --
868: IF l_debug_on THEN
869: WSH_DEBUG_SV.pop(l_module_name);
870: END IF;
871: --
872: return;
873: END IF;

Line 981: WSH_DEBUG_SV.logmsg(l_module_name, 'Get_Region_Id:: sql_string_length: ' || length(sql_string));

977:
978: -- Debug Statements
979: --
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.logmsg(l_module_name, 'Get_Region_Id:: sql_string_length: ' || length(sql_string));
982: WSH_DEBUG_SV.logmsg(l_module_name, substr(sql_string,101, 200));
983: END IF;
984:
985: IF (cnt = 0) THEN

Line 982: WSH_DEBUG_SV.logmsg(l_module_name, substr(sql_string,101, 200));

978: -- Debug Statements
979: --
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.logmsg(l_module_name, 'Get_Region_Id:: sql_string_length: ' || length(sql_string));
982: WSH_DEBUG_SV.logmsg(l_module_name, substr(sql_string,101, 200));
983: END IF;
984:
985: IF (cnt = 0) THEN
986: EXECUTE IMMEDIATE sql_string

Line 1044: WSH_DEBUG_SV.logmsg(l_module_name, 'sql_string:: ' || sql_string);

1040: --
1041: -- Debug Statements
1042: --
1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.logmsg(l_module_name, 'sql_string:: ' || sql_string);
1045: WSH_DEBUG_SV.logmsg(l_module_name, 'region_id = ' || l_region_id);
1046: END IF;
1047:
1048: x_region_id := l_region_id;

Line 1045: WSH_DEBUG_SV.logmsg(l_module_name, 'region_id = ' || l_region_id);

1041: -- Debug Statements
1042: --
1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.logmsg(l_module_name, 'sql_string:: ' || sql_string);
1045: WSH_DEBUG_SV.logmsg(l_module_name, 'region_id = ' || l_region_id);
1046: END IF;
1047:
1048: x_region_id := l_region_id;
1049:

Line 1054: WSH_DEBUG_SV.pop(l_module_name);

1050: --
1051: -- Debug Statements
1052: --
1053: IF l_debug_on THEN
1054: WSH_DEBUG_SV.pop(l_module_name);
1055: END IF;
1056: --
1057: EXCEPTION
1058: WHEN OTHERS THEN

Line 1065: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1061: --
1062: -- Debug Statements
1063: --
1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1066: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1067: END IF;
1068: --
1069: END Get_Region_Id_Codes_Only;

Line 1066: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1062: -- Debug Statements
1063: --
1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1066: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1067: END IF;
1068: --
1069: END Get_Region_Id_Codes_Only;
1070:

Line 1113: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1109: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1110: --
1111: IF l_debug_on IS NULL
1112: THEN
1113: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1114: END IF;
1115: --
1116: --
1117: -- Debug Statements

Line 1120: WSH_DEBUG_SV.push(l_module_name);

1116: --
1117: -- Debug Statements
1118: --
1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.push(l_module_name);
1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1123: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

Line 1122: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

1118: --
1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.push(l_module_name);
1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1123: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

Line 1123: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.push(l_module_name);
1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1123: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

Line 1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

1120: WSH_DEBUG_SV.push(l_module_name);
1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1123: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
1128: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

Line 1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1123: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
1128: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
1129: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

Line 1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

1122: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1123: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
1128: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
1129: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
1130: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

Line 1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

1123: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
1128: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
1129: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
1130: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
1131: END IF;

Line 1128: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);

1124: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
1128: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
1129: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
1130: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
1131: END IF;
1132: --

Line 1129: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);

1125: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
1128: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
1129: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
1130: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
1131: END IF;
1132: --
1133: IF ((p_country_code IS NULL AND p_state_code IS NULL AND p_city_code IS NULL ) OR ( p_region_type = 2 AND p_city_code IS NULL) OR (p_region_type=1 and p_state_code IS NULL) OR (p_region_type = 0 AND p_country_code IS NULL)) THEN

Line 1130: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

1126: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
1127: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
1128: WSH_DEBUG_SV.log(l_module_name,'P_REGION_TYPE',P_REGION_TYPE);
1129: WSH_DEBUG_SV.log(l_module_name,'P_INTERFACE_FLAG',P_INTERFACE_FLAG);
1130: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
1131: END IF;
1132: --
1133: IF ((p_country_code IS NULL AND p_state_code IS NULL AND p_city_code IS NULL ) OR ( p_region_type = 2 AND p_city_code IS NULL) OR (p_region_type=1 and p_state_code IS NULL) OR (p_region_type = 0 AND p_country_code IS NULL)) THEN
1134: l_region_id := -1;

Line 1139: WSH_DEBUG_SV.pop(l_module_name);

1135: --
1136: -- Debug Statements
1137: --
1138: IF l_debug_on THEN
1139: WSH_DEBUG_SV.pop(l_module_name);
1140: END IF;
1141: --
1142: return;
1143: END IF;

Line 1162: WSH_DEBUG_SV.logmsg(l_module_name, 'getting non-tl id '||x_region_id_non_tl);

1158: --
1159: -- Debug Statements
1160: --
1161: IF l_debug_on THEN
1162: WSH_DEBUG_SV.logmsg(l_module_name, 'getting non-tl id '||x_region_id_non_tl);
1163: WSH_DEBUG_SV.logmsg(l_module_name, 'country code '||p_country_code);
1164: END IF;
1165:
1166: Get_Region_Id_Codes_Only (

Line 1163: WSH_DEBUG_SV.logmsg(l_module_name, 'country code '||p_country_code);

1159: -- Debug Statements
1160: --
1161: IF l_debug_on THEN
1162: WSH_DEBUG_SV.logmsg(l_module_name, 'getting non-tl id '||x_region_id_non_tl);
1163: WSH_DEBUG_SV.logmsg(l_module_name, 'country code '||p_country_code);
1164: END IF;
1165:
1166: Get_Region_Id_Codes_Only (
1167: p_country_code => p_country_code,

Line 1181: WSH_DEBUG_SV.logmsg(l_module_name, 'got non-tl id '||x_region_id_non_tl);

1177: --
1178: -- Debug Statements
1179: --
1180: IF l_debug_on THEN
1181: WSH_DEBUG_SV.logmsg(l_module_name, 'got non-tl id '||x_region_id_non_tl);
1182: WSH_DEBUG_SV.logmsg(l_module_name, 'for region type '||l_region_type);
1183: END IF;
1184:
1185: IF (x_region_id_non_tl = -1) THEN

Line 1182: WSH_DEBUG_SV.logmsg(l_module_name, 'for region type '||l_region_type);

1178: -- Debug Statements
1179: --
1180: IF l_debug_on THEN
1181: WSH_DEBUG_SV.logmsg(l_module_name, 'got non-tl id '||x_region_id_non_tl);
1182: WSH_DEBUG_SV.logmsg(l_module_name, 'for region type '||l_region_type);
1183: END IF;
1184:
1185: IF (x_region_id_non_tl = -1) THEN
1186: --

Line 1190: WSH_DEBUG_SV.pop(l_module_name);

1186: --
1187: -- Debug Statements
1188: --
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.pop(l_module_name);
1191: END IF;
1192: --
1193: return;
1194: END IF;

Line 1212: WSH_DEBUG_SV.logmsg(l_module_name, 'checking tl id '||x_region_id_with_tl);

1208: --
1209: -- Debug Statements
1210: --
1211: IF l_debug_on THEN
1212: WSH_DEBUG_SV.logmsg(l_module_name, 'checking tl id '||x_region_id_with_tl);
1213: WSH_DEBUG_SV.pop(l_module_name);
1214: END IF;
1215: --
1216: END Get_Region_Id_Codes_Only;

Line 1213: WSH_DEBUG_SV.pop(l_module_name);

1209: -- Debug Statements
1210: --
1211: IF l_debug_on THEN
1212: WSH_DEBUG_SV.logmsg(l_module_name, 'checking tl id '||x_region_id_with_tl);
1213: WSH_DEBUG_SV.pop(l_module_name);
1214: END IF;
1215: --
1216: END Get_Region_Id_Codes_Only;
1217:

Line 1252: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1248: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1249: --
1250: IF l_debug_on IS NULL
1251: THEN
1252: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1253: END IF;
1254: --
1255: --
1256: -- Debug Statements

Line 1259: WSH_DEBUG_SV.push(l_module_name);

1255: --
1256: -- Debug Statements
1257: --
1258: IF l_debug_on THEN
1259: WSH_DEBUG_SV.push(l_module_name);
1260: --
1261: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
1262: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1263: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

Line 1261: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);

1257: --
1258: IF l_debug_on THEN
1259: WSH_DEBUG_SV.push(l_module_name);
1260: --
1261: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
1262: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1263: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1264: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
1265: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE',P_POSTAL_CODE);

Line 1262: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

1258: IF l_debug_on THEN
1259: WSH_DEBUG_SV.push(l_module_name);
1260: --
1261: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
1262: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1263: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1264: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
1265: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE',P_POSTAL_CODE);
1266: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);

Line 1263: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

1259: WSH_DEBUG_SV.push(l_module_name);
1260: --
1261: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
1262: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1263: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1264: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
1265: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE',P_POSTAL_CODE);
1266: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1267: END IF;

Line 1264: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);

1260: --
1261: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
1262: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1263: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1264: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
1265: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE',P_POSTAL_CODE);
1266: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1267: END IF;
1268: --

Line 1265: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE',P_POSTAL_CODE);

1261: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
1262: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1263: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1264: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
1265: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE',P_POSTAL_CODE);
1266: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1267: END IF;
1268: --
1269: l_region_info.country_code := p_country_code;

Line 1266: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);

1262: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
1263: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1264: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
1265: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE',P_POSTAL_CODE);
1266: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1267: END IF;
1268: --
1269: l_region_info.country_code := p_country_code;
1270: l_region_info.country := p_country;

Line 1339: WSH_DEBUG_SV.logmsg(l_module_name,nvl(l_region_info.country,l_region_info.country_code)||' '||nvl(l_region_info.state,l_region_info.state_code)||' '||nvl(l_region_info.city,l_region_info.city_code)||' '||l_region_info.postal_code_from);

1335: --
1336: -- Debug Statements
1337: --
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.logmsg(l_module_name,nvl(l_region_info.country,l_region_info.country_code)||' '||nvl(l_region_info.state,l_region_info.state_code)||' '||nvl(l_region_info.city,l_region_info.city_code)||' '||l_region_info.postal_code_from);
1340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.ADD_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1341: END IF;
1342: --
1343: Wsh_Regions_Pkg.Add_Region(

Line 1340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.ADD_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);

1336: -- Debug Statements
1337: --
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.logmsg(l_module_name,nvl(l_region_info.country,l_region_info.country_code)||' '||nvl(l_region_info.state,l_region_info.state_code)||' '||nvl(l_region_info.city,l_region_info.city_code)||' '||l_region_info.postal_code_from);
1340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.ADD_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1341: END IF;
1342: --
1343: Wsh_Regions_Pkg.Add_Region(
1344: p_country_code => l_region_info.country_code,

Line 1378: wsh_debug_sv.logmsg(l_module_name,nvl(l_region_info.country,l_region_info.country_code)

1374: END IF;
1375:
1376: IF (l_region_rec1.region_id = -1 AND p_insert_flag <> 'Y') THEN
1377: IF l_debug_on THEN
1378: wsh_debug_sv.logmsg(l_module_name,nvl(l_region_info.country,l_region_info.country_code)
1379: ||' '
1380: ||nvl(l_region_info.state,l_region_info.state_code)
1381: ||' '
1382: ||nvl(l_region_info.city,l_region_info.city_code)

Line 1398: WSH_DEBUG_SV.pop(l_module_name);

1394: --
1395: -- Debug Statements
1396: --
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.pop(l_module_name);
1399: END IF;
1400: --
1401: RETURN l_region_rec1.region_id;
1402:

Line 1474: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1470: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
1471:
1472: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1473: IF l_debug_on IS NULL THEN
1474: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1475: END IF;
1476:
1477: --bug 4775798
1478: --changed WSH_UTIL_CORE.println to WSH_DEBUG_SV.log

Line 1478: --changed WSH_UTIL_CORE.println to WSH_DEBUG_SV.log

1474: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1475: END IF;
1476:
1477: --bug 4775798
1478: --changed WSH_UTIL_CORE.println to WSH_DEBUG_SV.log
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.push(l_module_name);
1481: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1482: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);

Line 1480: WSH_DEBUG_SV.push(l_module_name);

1476:
1477: --bug 4775798
1478: --changed WSH_UTIL_CORE.println to WSH_DEBUG_SV.log
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.push(l_module_name);
1481: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1482: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1483: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1484: END IF;

Line 1481: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);

1477: --bug 4775798
1478: --changed WSH_UTIL_CORE.println to WSH_DEBUG_SV.log
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.push(l_module_name);
1481: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1482: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1483: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1484: END IF;
1485:

Line 1482: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);

1478: --changed WSH_UTIL_CORE.println to WSH_DEBUG_SV.log
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.push(l_module_name);
1481: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1482: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1483: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1484: END IF;
1485:
1486: IF p_location_type IS NULL THEN

Line 1483: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);

1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.push(l_module_name);
1481: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1482: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1483: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1484: END IF;
1485:
1486: IF p_location_type IS NULL THEN
1487: l_location_type := 'BOTH';

Line 1496: WSH_DEBUG_SV.log(l_module_name,'l_START_DATE',l_START_DATE);

1492: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');
1493: l_end_date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS') +1;
1494:
1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.log(l_module_name,'l_START_DATE',l_START_DATE);
1497: WSH_DEBUG_SV.log(l_module_name,'l_END_DATE',l_END_DATE);
1498: END IF;
1499:
1500: IF p_mode = 'CREATE' THEN

Line 1497: WSH_DEBUG_SV.log(l_module_name,'l_END_DATE',l_END_DATE);

1493: l_end_date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS') +1;
1494:
1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.log(l_module_name,'l_START_DATE',l_START_DATE);
1497: WSH_DEBUG_SV.log(l_module_name,'l_END_DATE',l_END_DATE);
1498: END IF;
1499:
1500: IF p_mode = 'CREATE' THEN
1501:

Line 1504: wsh_debug_sv.logmsg(l_module_name,'Processing locations. Following locations could not be mapped to existing regions.');

1500: IF p_mode = 'CREATE' THEN
1501:
1502: l_processing_date := sysdate;
1503: IF l_debug_on THEN
1504: wsh_debug_sv.logmsg(l_module_name,'Processing locations. Following locations could not be mapped to existing regions.');
1505: END IF;
1506:
1507: IF (p_insert_flag = 'Y') THEN
1508: IF l_debug_on THEN

Line 1509: wsh_debug_sv.logmsg(l_module_name,'These have been inserted in the regions interface tables');

1505: END IF;
1506:
1507: IF (p_insert_flag = 'Y') THEN
1508: IF l_debug_on THEN
1509: wsh_debug_sv.logmsg(l_module_name,'These have been inserted in the regions interface tables');
1510: END IF;
1511:
1512: ELSE
1513: IF l_debug_on THEN

Line 1514: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');

1510: END IF;
1511:
1512: ELSE
1513: IF l_debug_on THEN
1514: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');
1515: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');
1516: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');
1517: END IF;
1518:

Line 1515: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');

1511:
1512: ELSE
1513: IF l_debug_on THEN
1514: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');
1515: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');
1516: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');
1517: END IF;
1518:
1519: END IF;

Line 1516: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');

1512: ELSE
1513: IF l_debug_on THEN
1514: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');
1515: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');
1516: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');
1517: END IF;
1518:
1519: END IF;
1520:

Line 1527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);

1523: --
1524: -- Debug Statements
1525: --
1526: IF l_debug_on THEN
1527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1528: END IF;
1529: --
1530: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (
1531: p_country => loc.territory_short_name,

Line 1546: wsh_debug_sv.logmsg(l_module_name,'Total number of interfaced regions '||l_count);

1542: END LOOP;
1543:
1544: IF (p_insert_flag = 'Y') THEN
1545: IF l_debug_on THEN
1546: wsh_debug_sv.logmsg(l_module_name,'Total number of interfaced regions '||l_count);
1547:
1548: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');
1549: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');
1550: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');

Line 1548: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');

1544: IF (p_insert_flag = 'Y') THEN
1545: IF l_debug_on THEN
1546: wsh_debug_sv.logmsg(l_module_name,'Total number of interfaced regions '||l_count);
1547:
1548: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');
1549: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');
1550: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');
1551: FOR loc IN get_region_info(l_processing_date) LOOP
1552: wsh_debug_sv.logmsg(l_module_name,loc.country||' '||loc.state||' '||loc.city||' '||loc.postal_code_from);

Line 1549: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');

1545: IF l_debug_on THEN
1546: wsh_debug_sv.logmsg(l_module_name,'Total number of interfaced regions '||l_count);
1547:
1548: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');
1549: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');
1550: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');
1551: FOR loc IN get_region_info(l_processing_date) LOOP
1552: wsh_debug_sv.logmsg(l_module_name,loc.country||' '||loc.state||' '||loc.city||' '||loc.postal_code_from);
1553: END LOOP;

Line 1550: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');

1546: wsh_debug_sv.logmsg(l_module_name,'Total number of interfaced regions '||l_count);
1547:
1548: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');
1549: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');
1550: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');
1551: FOR loc IN get_region_info(l_processing_date) LOOP
1552: wsh_debug_sv.logmsg(l_module_name,loc.country||' '||loc.state||' '||loc.city||' '||loc.postal_code_from);
1553: END LOOP;
1554: END IF;

Line 1552: wsh_debug_sv.logmsg(l_module_name,loc.country||' '||loc.state||' '||loc.city||' '||loc.postal_code_from);

1548: wsh_debug_sv.logmsg(l_module_name,'---------------------------------------------------------------');
1549: wsh_debug_sv.logmsg(l_module_name,'Country State City Postal Code');
1550: wsh_debug_sv.logmsg(l_module_name,'------- ----- ---- ------ ----');
1551: FOR loc IN get_region_info(l_processing_date) LOOP
1552: wsh_debug_sv.logmsg(l_module_name,loc.country||' '||loc.state||' '||loc.city||' '||loc.postal_code_from);
1553: END LOOP;
1554: END IF;
1555: END IF;
1556:

Line 1572: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from Mapping_Regions_Main : '|| l_return_status);

1568: x_sqlerr => l_sqlerr);
1569:
1570:
1571: IF l_debug_on THEN
1572: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from Mapping_Regions_Main : '|| l_return_status);
1573: END IF;
1574:
1575: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1576:

Line 1585: WSH_DEBUG_SV.log(l_module_name,'ERRBUF',p_errbuf);

1581: END IF;
1582: END IF;
1583: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.log(l_module_name,'ERRBUF',p_errbuf);
1586: WSH_DEBUG_SV.log(l_module_name,'RETCODE',p_retcode);
1587: WSH_DEBUG_SV.pop(l_module_name);
1588: END IF;
1589:

Line 1586: WSH_DEBUG_SV.log(l_module_name,'RETCODE',p_retcode);

1582: END IF;
1583: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.log(l_module_name,'ERRBUF',p_errbuf);
1586: WSH_DEBUG_SV.log(l_module_name,'RETCODE',p_retcode);
1587: WSH_DEBUG_SV.pop(l_module_name);
1588: END IF;
1589:
1590: EXCEPTION

Line 1587: WSH_DEBUG_SV.pop(l_module_name);

1583: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.log(l_module_name,'ERRBUF',p_errbuf);
1586: WSH_DEBUG_SV.log(l_module_name,'RETCODE',p_retcode);
1587: WSH_DEBUG_SV.pop(l_module_name);
1588: END IF;
1589:
1590: EXCEPTION
1591:

Line 1596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

1592: WHEN No_Data_Found THEN
1593:
1594: WSH_UTIL_CORE.printmsg('No matching records for the entered parameters');
1595: IF l_debug_on THEN
1596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1597: END IF;
1598:
1599: WHEN others THEN
1600: l_sqlcode := SQLCODE;

Line 1614: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1610: p_retcode := '2';
1611:
1612:
1613: IF l_debug_on THEN
1614: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1615: END IF;
1616:
1617: END Map_Location_Region_Child;
1618:

Line 1657: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1653: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1654: --
1655: IF l_debug_on IS NULL
1656: THEN
1657: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1658: END IF;
1659:
1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.push(l_module_name);

Line 1661: WSH_DEBUG_SV.push(l_module_name);

1657: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1658: END IF;
1659:
1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.push(l_module_name);
1662: END IF;
1663:
1664: FND_PROFILE.Get('CONC_REQUEST_ID', l_this_request);
1665:

Line 1705: WSH_DEBUG_SV.pop(l_module_name);

1701: END IF;
1702: x_completion_status := l_completion_status;
1703:
1704: IF l_debug_on THEN
1705: WSH_DEBUG_SV.pop(l_module_name);
1706: END IF;
1707: EXCEPTION
1708: WHEN others THEN
1709: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');

Line 1712: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1708: WHEN others THEN
1709: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');
1710: --
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1714: END IF;
1715:
1716: END Get_Child_Requests_Status;

Line 1713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1709: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');
1710: --
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1714: END IF;
1715:
1716: END Get_Child_Requests_Status;
1717:

Line 1743: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1739: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1740: --
1741: IF l_debug_on IS NULL
1742: THEN
1743: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1744: END IF;
1745:
1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.push(l_module_name);

Line 1747: WSH_DEBUG_SV.push(l_module_name);

1743: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1744: END IF;
1745:
1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.push(l_module_name);
1748: END IF;
1749:
1750: --
1751: --

Line 1755: WSH_DEBUG_SV.push(l_module_name);

1751: --
1752: -- Debug Statements
1753: --
1754: IF l_debug_on THEN
1755: WSH_DEBUG_SV.push(l_module_name);
1756: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1757: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);

Line 1756: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);

1752: -- Debug Statements
1753: --
1754: IF l_debug_on THEN
1755: WSH_DEBUG_SV.push(l_module_name);
1756: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1757: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1760: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',p_insert_flag);

Line 1757: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);

1753: --
1754: IF l_debug_on THEN
1755: WSH_DEBUG_SV.push(l_module_name);
1756: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1757: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1760: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',p_insert_flag);
1761: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);

Line 1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);

1754: IF l_debug_on THEN
1755: WSH_DEBUG_SV.push(l_module_name);
1756: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1757: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1760: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',p_insert_flag);
1761: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1762: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);

Line 1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);

1755: WSH_DEBUG_SV.push(l_module_name);
1756: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1757: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1760: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',p_insert_flag);
1761: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1762: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1763: END IF;

Line 1760: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',p_insert_flag);

1756: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1757: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1760: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',p_insert_flag);
1761: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1762: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1763: END IF;
1764:

Line 1761: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);

1757: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1760: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',p_insert_flag);
1761: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1762: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1763: END IF;
1764:
1765: IF l_debug_on THEN

Line 1762: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);

1758: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1759: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1760: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',p_insert_flag);
1761: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1762: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1763: END IF;
1764:
1765: IF l_debug_on THEN
1766: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING PROCESS_ALL_LOCATIONS API with location_type=BOTH' ,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1766: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING PROCESS_ALL_LOCATIONS API with location_type=BOTH' ,WSH_DEBUG_SV.C_PROC_LEVEL);

1762: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1763: END IF;
1764:
1765: IF l_debug_on THEN
1766: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING PROCESS_ALL_LOCATIONS API with location_type=BOTH' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1767: END IF;
1768:
1769: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(
1770: p_dummy1 => NULL,

Line 1781: WSH_DEBUG_SV.pop(l_module_name);

1777: p_num_of_instances => p_num_of_instances
1778: );
1779:
1780: IF l_debug_on THEN
1781: WSH_DEBUG_SV.pop(l_module_name);
1782: END IF;
1783:
1784: EXCEPTION
1785: WHEN others THEN

Line 1789: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1785: WHEN others THEN
1786: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
1787: --
1788: IF l_debug_on THEN
1789: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1791: END IF;
1792:
1793: END Process_All_Locations;

Line 1790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1786: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
1787: --
1788: IF l_debug_on THEN
1789: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1791: END IF;
1792:
1793: END Process_All_Locations;
1794:

Line 1845: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1841: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1842: --
1843: IF l_debug_on IS NULL
1844: THEN
1845: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1846: END IF;
1847:
1848:
1849: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

Line 1856: WSH_DEBUG_SV.push(l_module_name);

1852: --
1853: -- Debug Statements
1854: --
1855: IF l_debug_on THEN
1856: WSH_DEBUG_SV.push(l_module_name);
1857: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1858: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);

Line 1857: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);

1853: -- Debug Statements
1854: --
1855: IF l_debug_on THEN
1856: WSH_DEBUG_SV.push(l_module_name);
1857: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1858: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);

Line 1858: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);

1854: --
1855: IF l_debug_on THEN
1856: WSH_DEBUG_SV.push(l_module_name);
1857: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1858: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1862: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);

Line 1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);

1855: IF l_debug_on THEN
1856: WSH_DEBUG_SV.push(l_module_name);
1857: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1858: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1862: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1863: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);

Line 1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);

1856: WSH_DEBUG_SV.push(l_module_name);
1857: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1858: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1862: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1863: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1864: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);

Line 1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);

1857: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY1',P_DUMMY1);
1858: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1862: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1863: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1864: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1865: END IF;

Line 1862: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);

1858: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY2',P_DUMMY2);
1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1862: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1863: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1864: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1865: END IF;
1866: --

Line 1863: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);

1859: WSH_DEBUG_SV.log(l_module_name,'P_INSERT_FLAG',P_INSERT_FLAG);
1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1862: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1863: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1864: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1865: END IF;
1866: --
1867: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');

Line 1864: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);

1860: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
1861: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
1862: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
1863: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
1864: WSH_DEBUG_SV.log(l_module_name,'P_NUM_OF_INSTANCES',p_num_of_instances);
1865: END IF;
1866: --
1867: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');
1868: l_end_date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS') +1;

Line 1871: WSH_DEBUG_SV.log(l_module_name,'l_START_DATE',l_START_DATE);

1867: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');
1868: l_end_date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS') +1;
1869:
1870: IF l_debug_on THEN
1871: WSH_DEBUG_SV.log(l_module_name,'l_START_DATE',l_START_DATE);
1872: WSH_DEBUG_SV.log(l_module_name,'l_END_DATE',l_END_DATE);
1873: END IF;
1874:
1875: IF p_num_of_instances is null or p_num_of_instances = 0 then

Line 1872: WSH_DEBUG_SV.log(l_module_name,'l_END_DATE',l_END_DATE);

1868: l_end_date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS') +1;
1869:
1870: IF l_debug_on THEN
1871: WSH_DEBUG_SV.log(l_module_name,'l_START_DATE',l_START_DATE);
1872: WSH_DEBUG_SV.log(l_module_name,'l_END_DATE',l_END_DATE);
1873: END IF;
1874:
1875: IF p_num_of_instances is null or p_num_of_instances = 0 then
1876: l_num_of_instances := 1;

Line 1886: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Map_Location_Region_Child',WSH_DEBUG_SV.C_PROC_LEVEL);

1882: -- parameter
1883: IF p_mode = 'CREATE' THEN
1884: --{
1885: IF l_debug_on THEN
1886: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Map_Location_Region_Child',WSH_DEBUG_SV.C_PROC_LEVEL);
1887: END IF;
1888:
1889: Map_Location_Region_Child (
1890: p_errbuf => l_errbuf,

Line 1901: WSH_DEBUG_SV.logmsg(l_module_name,'Return Code from Map_Location_Region_Child : '||l_retcode);

1897: p_end_date => p_end_date,
1898: p_insert_flag => p_insert_flag);
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,'Return Code from Map_Location_Region_Child : '||l_retcode);
1902: END IF;
1903:
1904: IF l_retcode = '2' THEN
1905: l_completion_status := 'ERROR';

Line 1917: WSH_DEBUG_SV.log(l_module_name, ' l_req_data', l_req_data);

1913: --{
1914: l_req_data := fnd_conc_global.request_data;
1915:
1916: IF l_debug_on THEN
1917: WSH_DEBUG_SV.log(l_module_name, ' l_req_data', l_req_data);
1918: END IF;
1919:
1920: IF l_req_data IS NOT NULL THEN
1921: l_import_start_date := to_date(SUBSTR(l_req_data, INSTR(l_req_data,':',1,1)+1, LENGTH(l_req_data)),'YYYY/MM/DD HH24:MI:SS');

Line 1935: wsh_debug_sv.log(l_module_name, 'l_req_data 1', l_req_data);

1931: l_end_date1 := p_end_date;
1932: END IF;
1933:
1934: IF l_debug_on THEN
1935: wsh_debug_sv.log(l_module_name, 'l_req_data 1', l_req_data);
1936: wsh_debug_sv.log(l_module_name, 'l_start_date1', l_start_date1);
1937: wsh_debug_sv.log(l_module_name, 'l_end_date1', l_end_date1);
1938: END IF;
1939:

Line 1936: wsh_debug_sv.log(l_module_name, 'l_start_date1', l_start_date1);

1932: END IF;
1933:
1934: IF l_debug_on THEN
1935: wsh_debug_sv.log(l_module_name, 'l_req_data 1', l_req_data);
1936: wsh_debug_sv.log(l_module_name, 'l_start_date1', l_start_date1);
1937: wsh_debug_sv.log(l_module_name, 'l_end_date1', l_end_date1);
1938: END IF;
1939:
1940: IF l_req_data IS NULL OR l_req_data = '1' THEN

Line 1937: wsh_debug_sv.log(l_module_name, 'l_end_date1', l_end_date1);

1933:
1934: IF l_debug_on THEN
1935: wsh_debug_sv.log(l_module_name, 'l_req_data 1', l_req_data);
1936: wsh_debug_sv.log(l_module_name, 'l_start_date1', l_start_date1);
1937: wsh_debug_sv.log(l_module_name, 'l_end_date1', l_end_date1);
1938: END IF;
1939:
1940: IF l_req_data IS NULL OR l_req_data = '1' THEN
1941: --{

Line 1945: WSH_DEBUG_SV.logmsg(l_module_name, 'Location Type is External');

1941: --{
1942: IF p_location_type = 'EXTERNAL' THEN
1943: --{
1944: IF l_debug_on THEN
1945: WSH_DEBUG_SV.logmsg(l_module_name, 'Location Type is External');
1946: END IF;
1947:
1948: EXECUTE IMMEDIATE 'SELECT MIN(LOCATION_ID),MAX(LOCATION_ID)
1949: FROM ( SELECT location_id, NTILE(:num_instances) OVER (ORDER BY location_id) worker

Line 1961: WSH_DEBUG_SV.logmsg(l_module_name, 'Location Type is Internal');

1957:
1958: ELSIF p_location_type = 'INTERNAL' THEN
1959:
1960: IF l_debug_on THEN
1961: WSH_DEBUG_SV.logmsg(l_module_name, 'Location Type is Internal');
1962: END IF;
1963:
1964: EXECUTE IMMEDIATE 'SELECT MIN(LOCATION_ID),MAX(LOCATION_ID)
1965: FROM ( SELECT location_id, NTILE(:num_instances) OVER (ORDER BY location_id) worker

Line 1977: WSH_DEBUG_SV.logmsg(l_module_name, 'Location Type is Both');

1973:
1974: ELSIF p_location_type = 'BOTH' THEN
1975:
1976: IF l_debug_on THEN
1977: WSH_DEBUG_SV.logmsg(l_module_name, 'Location Type is Both');
1978: END IF;
1979:
1980: EXECUTE IMMEDIATE 'SELECT MIN(LOCATION_ID),MAX(LOCATION_ID)
1981: FROM ( SELECT location_id, NTILE(:num_instances) OVER (ORDER BY location_id) worker

Line 1999: WSH_DEBUG_SV.logmsg(l_module_name, 'Value of i : '|| i ||' l_worker_min : '||l_worker_min_tab(i)||

1995: FOR i in 1..l_worker_min_tab.count
1996: LOOP
1997:
1998: IF l_debug_on THEN
1999: WSH_DEBUG_SV.logmsg(l_module_name, 'Value of i : '|| i ||' l_worker_min : '||l_worker_min_tab(i)||
2000: ' l_worker_max : '||l_worker_max_tab(i));
2001: END IF;
2002:
2003:

Line 2019: WSH_DEBUG_SV.log(l_module_name, 'Child request ID ', l_new_request_id);

2015: argument6 => l_end_date1,
2016: argument7 => p_insert_flag);
2017:
2018: IF l_debug_on THEN
2019: WSH_DEBUG_SV.log(l_module_name, 'Child request ID ', l_new_request_id);
2020: END IF;
2021:
2022: IF l_new_request_id = 0 THEN
2023: IF l_debug_on THEN

Line 2024: WSH_debug_sv.logmsg(l_module_name,'Error Submitting concurrent request for worker : '||i);

2020: END IF;
2021:
2022: IF l_new_request_id = 0 THEN
2023: IF l_debug_on THEN
2024: WSH_debug_sv.logmsg(l_module_name,'Error Submitting concurrent request for worker : '||i);
2025: END IF;
2026: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2027: END IF;
2028:

Line 2035: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Map_Location_Region_Child',WSH_DEBUG_SV.C_PROC_LEVEL);

2031: --}
2032: ELSIF l_worker_min_tab.count <>0 AND nvl(p_num_of_instances,0) = 0 THEN
2033: --{
2034: IF l_debug_on THEN
2035: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Map_Location_Region_Child',WSH_DEBUG_SV.C_PROC_LEVEL);
2036: END IF;
2037:
2038: Map_Location_Region_Child (
2039: p_errbuf => l_errbuf,

Line 2050: WSH_DEBUG_SV.logmsg(l_module_name,'Return Code from Map_Location_Region_Child : '||l_retcode);

2046: p_end_date => l_end_date1,
2047: p_insert_flag => p_insert_flag);
2048:
2049: IF l_debug_on THEN
2050: WSH_DEBUG_SV.logmsg(l_module_name,'Return Code from Map_Location_Region_Child : '||l_retcode);
2051: END IF;
2052:
2053: IF l_retcode = '2' THEN
2054: l_completion_status := 'ERROR';

Line 2085: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);

2081: --
2082: -- Debug Statements
2083: --
2084: IF l_debug_on THEN
2085: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
2086: WSH_DEBUG_SV.log(l_module_name,'RETCODE',l_retcode);
2087: WSH_DEBUG_SV.pop(l_module_name);
2088: END IF;
2089:

Line 2086: WSH_DEBUG_SV.log(l_module_name,'RETCODE',l_retcode);

2082: -- Debug Statements
2083: --
2084: IF l_debug_on THEN
2085: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
2086: WSH_DEBUG_SV.log(l_module_name,'RETCODE',l_retcode);
2087: WSH_DEBUG_SV.pop(l_module_name);
2088: END IF;
2089:
2090: EXCEPTION

Line 2087: WSH_DEBUG_SV.pop(l_module_name);

2083: --
2084: IF l_debug_on THEN
2085: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
2086: WSH_DEBUG_SV.log(l_module_name,'RETCODE',l_retcode);
2087: WSH_DEBUG_SV.pop(l_module_name);
2088: END IF;
2089:
2090: EXCEPTION
2091: WHEN others THEN

Line 2095: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2091: WHEN others THEN
2092: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2093: --
2094: IF l_debug_on THEN
2095: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2097: END IF;
2098:
2099: END Process_All_Locations;

Line 2096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2092: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2093: --
2094: IF l_debug_on THEN
2095: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2097: END IF;
2098:
2099: END Process_All_Locations;
2100:

Line 2113: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2109: x_return_status OUT NOCOPY VARCHAR2 )
2110: IS
2111:
2112: l_session_id NUMBER := 0;
2113: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2114: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'refresh_cache';
2115:
2116: BEGIN
2117: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2120: wsh_debug_sv.push (l_module_name);

2116: BEGIN
2117: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2118: --
2119: IF l_debug_on THEN
2120: wsh_debug_sv.push (l_module_name);
2121: END IF;
2122: --
2123:
2124: l_session_id := userenv('sessionid');

Line 2127: wsh_debug_sv.logmsg(l_module_name,'g_regions_info_tab count : '||g_regions_info_tab.COUNT);

2123:
2124: l_session_id := userenv('sessionid');
2125:
2126: IF l_debug_on THEN
2127: wsh_debug_sv.logmsg(l_module_name,'g_regions_info_tab count : '||g_regions_info_tab.COUNT);
2128: wsh_debug_sv.logmsg(l_module_name,'g_session_id : '||g_session_id||' Current session id : '||l_session_id);
2129: END IF;
2130:
2131: IF g_session_id IS NULL OR l_session_id <> g_session_id

Line 2128: wsh_debug_sv.logmsg(l_module_name,'g_session_id : '||g_session_id||' Current session id : '||l_session_id);

2124: l_session_id := userenv('sessionid');
2125:
2126: IF l_debug_on THEN
2127: wsh_debug_sv.logmsg(l_module_name,'g_regions_info_tab count : '||g_regions_info_tab.COUNT);
2128: wsh_debug_sv.logmsg(l_module_name,'g_session_id : '||g_session_id||' Current session id : '||l_session_id);
2129: END IF;
2130:
2131: IF g_session_id IS NULL OR l_session_id <> g_session_id
2132: OR g_country_code <> p_country_code OR g_regions_info_tab.count > 5000 THEN

Line 2138: wsh_debug_sv.logmsg(l_module_name,'Regions Cache cleared');

2134: g_country_code := p_country_code;
2135: g_session_id := l_session_id;
2136:
2137: IF l_debug_on THEN
2138: wsh_debug_sv.logmsg(l_module_name,'Regions Cache cleared');
2139: END IF;
2140:
2141: END IF;
2142:

Line 2145: wsh_debug_sv.pop (l_module_name);

2141: END IF;
2142:
2143: --
2144: IF l_debug_on THEN
2145: wsh_debug_sv.pop (l_module_name);
2146: END IF;
2147: --
2148:
2149: EXCEPTION

Line 2155: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2151: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.refresh_cache');
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2153: --
2154: IF l_debug_on THEN
2155: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2156: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2157: END IF;
2158: --
2159: END refresh_cache;

Line 2156: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2153: --
2154: IF l_debug_on THEN
2155: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2156: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2157: END IF;
2158: --
2159: END refresh_cache;
2160:

Line 2301: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2297: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2298: --
2299: IF l_debug_on IS NULL
2300: THEN
2301: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2302: END IF;
2303: --
2304: --
2305: -- Debug Statements

Line 2308: WSH_DEBUG_SV.push(l_module_name);

2304: --
2305: -- Debug Statements
2306: --
2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.push(l_module_name);
2309: --
2310: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
2311: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

Line 2310: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);

2306: --
2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.push(l_module_name);
2309: --
2310: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
2311: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

Line 2311: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);

2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.push(l_module_name);
2309: --
2310: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
2311: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

Line 2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

2308: WSH_DEBUG_SV.push(l_module_name);
2309: --
2310: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
2311: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

Line 2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);

2309: --
2310: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
2311: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

Line 2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);

2310: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
2311: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

Line 2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);

2311: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION',P_COUNTRY_REGION);
2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

Line 2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

2312: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
2320: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

Line 2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);

2313: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
2320: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
2321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);

Line 2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);

2314: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_FROM',P_POSTAL_CODE_FROM);
2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
2320: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
2321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
2322: WSH_DEBUG_SV.log(l_module_name,'P_ZONE_FLAG',P_ZONE_FLAG);

Line 2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);

2315: WSH_DEBUG_SV.log(l_module_name,'P_POSTAL_CODE_TO',P_POSTAL_CODE_TO);
2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
2320: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
2321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
2322: WSH_DEBUG_SV.log(l_module_name,'P_ZONE_FLAG',P_ZONE_FLAG);
2323: END IF;

Line 2320: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);

2316: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
2320: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
2321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
2322: WSH_DEBUG_SV.log(l_module_name,'P_ZONE_FLAG',P_ZONE_FLAG);
2323: END IF;
2324:

Line 2321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);

2317: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_REGION_CODE',P_COUNTRY_REGION_CODE);
2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
2320: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
2321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
2322: WSH_DEBUG_SV.log(l_module_name,'P_ZONE_FLAG',P_ZONE_FLAG);
2323: END IF;
2324:
2325:

Line 2322: WSH_DEBUG_SV.log(l_module_name,'P_ZONE_FLAG',P_ZONE_FLAG);

2318: WSH_DEBUG_SV.log(l_module_name,'P_STATE_CODE',P_STATE_CODE);
2319: WSH_DEBUG_SV.log(l_module_name,'P_CITY_CODE',P_CITY_CODE);
2320: WSH_DEBUG_SV.log(l_module_name,'P_LANG_CODE',P_LANG_CODE);
2321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
2322: WSH_DEBUG_SV.log(l_module_name,'P_ZONE_FLAG',P_ZONE_FLAG);
2323: END IF;
2324:
2325:
2326: IF g_regions_info_tab.count = 0 THEN

Line 2364: WSH_DEBUG_SV.log(l_module_name,'Number of regions found in wrl : ',l_rgid_tab.COUNT);

2360: x_region_tab => l_rgid_tab,
2361: x_return_status => l_return_status);
2362:
2363: IF l_debug_on THEN
2364: WSH_DEBUG_SV.log(l_module_name,'Number of regions found in wrl : ',l_rgid_tab.COUNT);
2365: END IF;
2366: --
2367:
2368: IF l_rgid_tab.COUNT > 0 THEN

Line 2377: WSH_DEBUG_SV.log(l_module_name,'l_rgid_tab(j) : ',l_rgid_tab(j));

2373: CLOSE region_details;
2374:
2375: --
2376: IF l_debug_on THEN
2377: WSH_DEBUG_SV.log(l_module_name,'l_rgid_tab(j) : ',l_rgid_tab(j));
2378: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_id : ',l_region_info.region_id);
2379: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_type : ',l_region_info.region_type);
2380: WSH_DEBUG_SV.log(l_module_name,'cnt_region : ',cnt_region);
2381: END IF;

Line 2378: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_id : ',l_region_info.region_id);

2374:
2375: --
2376: IF l_debug_on THEN
2377: WSH_DEBUG_SV.log(l_module_name,'l_rgid_tab(j) : ',l_rgid_tab(j));
2378: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_id : ',l_region_info.region_id);
2379: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_type : ',l_region_info.region_type);
2380: WSH_DEBUG_SV.log(l_module_name,'cnt_region : ',cnt_region);
2381: END IF;
2382: --

Line 2379: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_type : ',l_region_info.region_type);

2375: --
2376: IF l_debug_on THEN
2377: WSH_DEBUG_SV.log(l_module_name,'l_rgid_tab(j) : ',l_rgid_tab(j));
2378: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_id : ',l_region_info.region_id);
2379: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_type : ',l_region_info.region_type);
2380: WSH_DEBUG_SV.log(l_module_name,'cnt_region : ',cnt_region);
2381: END IF;
2382: --
2383:

Line 2380: WSH_DEBUG_SV.log(l_module_name,'cnt_region : ',cnt_region);

2376: IF l_debug_on THEN
2377: WSH_DEBUG_SV.log(l_module_name,'l_rgid_tab(j) : ',l_rgid_tab(j));
2378: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_id : ',l_region_info.region_id);
2379: WSH_DEBUG_SV.log(l_module_name,'l_region_info.region_type : ',l_region_info.region_type);
2380: WSH_DEBUG_SV.log(l_module_name,'cnt_region : ',cnt_region);
2381: END IF;
2382: --
2383:
2384: cnt_region := cnt_region + 1;

Line 2403: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching zone info of '||l_region_rec3.region_id);

2399:
2400: -- Debug Statements
2401: --
2402: IF l_debug_on THEN
2403: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching zone info of '||l_region_rec3.region_id);
2404: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);
2405: END IF;
2406:
2407: x_regions(cnt_region) := l_region_rec3;

Line 2404: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);

2400: -- Debug Statements
2401: --
2402: IF l_debug_on THEN
2403: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching zone info of '||l_region_rec3.region_id);
2404: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);
2405: END IF;
2406:
2407: x_regions(cnt_region) := l_region_rec3;
2408:

Line 2448: WSH_DEBUG_SV.logmsg(l_module_name, ' fetched location data city '||l_region_rec2.city||' country code '||l_region_rec2.country_code||'State '||l_region_rec2.state||' postal_code '||l_region_rec2.postal_code_from);

2444: --
2445: -- Debug Statements
2446: --
2447: IF l_debug_on THEN
2448: WSH_DEBUG_SV.logmsg(l_module_name, ' fetched location data city '||l_region_rec2.city||' country code '||l_region_rec2.country_code||'State '||l_region_rec2.state||' postal_code '||l_region_rec2.postal_code_from);
2449: END IF;
2450:
2451: END IF;
2452:

Line 2477: WSH_DEBUG_SV.logmsg(l_module_name, ' region type '||l_region_type);

2473: --
2474: -- Debug Statements
2475: --
2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.logmsg(l_module_name, ' region type '||l_region_type);
2478: WSH_DEBUG_SV.logmsg(l_module_name, ' city: '||l_region_rec2.city||' code: '||l_region_rec2.city_code);
2479: WSH_DEBUG_SV.logmsg(l_module_name, ' state: '||l_region_rec2.state||' code: '||l_region_rec2.state_code);
2480: WSH_DEBUG_SV.logmsg(l_module_name, ' country: '||l_region_rec2.country||' code: '||l_region_rec2.country_code);
2481: END IF;

Line 2478: WSH_DEBUG_SV.logmsg(l_module_name, ' city: '||l_region_rec2.city||' code: '||l_region_rec2.city_code);

2474: -- Debug Statements
2475: --
2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.logmsg(l_module_name, ' region type '||l_region_type);
2478: WSH_DEBUG_SV.logmsg(l_module_name, ' city: '||l_region_rec2.city||' code: '||l_region_rec2.city_code);
2479: WSH_DEBUG_SV.logmsg(l_module_name, ' state: '||l_region_rec2.state||' code: '||l_region_rec2.state_code);
2480: WSH_DEBUG_SV.logmsg(l_module_name, ' country: '||l_region_rec2.country||' code: '||l_region_rec2.country_code);
2481: END IF;
2482:

Line 2479: WSH_DEBUG_SV.logmsg(l_module_name, ' state: '||l_region_rec2.state||' code: '||l_region_rec2.state_code);

2475: --
2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.logmsg(l_module_name, ' region type '||l_region_type);
2478: WSH_DEBUG_SV.logmsg(l_module_name, ' city: '||l_region_rec2.city||' code: '||l_region_rec2.city_code);
2479: WSH_DEBUG_SV.logmsg(l_module_name, ' state: '||l_region_rec2.state||' code: '||l_region_rec2.state_code);
2480: WSH_DEBUG_SV.logmsg(l_module_name, ' country: '||l_region_rec2.country||' code: '||l_region_rec2.country_code);
2481: END IF;
2482:
2483: cnt := cnt + 1;

Line 2480: WSH_DEBUG_SV.logmsg(l_module_name, ' country: '||l_region_rec2.country||' code: '||l_region_rec2.country_code);

2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.logmsg(l_module_name, ' region type '||l_region_type);
2478: WSH_DEBUG_SV.logmsg(l_module_name, ' city: '||l_region_rec2.city||' code: '||l_region_rec2.city_code);
2479: WSH_DEBUG_SV.logmsg(l_module_name, ' state: '||l_region_rec2.state||' code: '||l_region_rec2.state_code);
2480: WSH_DEBUG_SV.logmsg(l_module_name, ' country: '||l_region_rec2.country||' code: '||l_region_rec2.country_code);
2481: END IF;
2482:
2483: cnt := cnt + 1;
2484:

Line 2488: WSH_DEBUG_SV.logmsg(l_module_name, 'number in loop '||cnt);

2484:
2485: -- Debug Statements
2486: --
2487: IF l_debug_on THEN
2488: WSH_DEBUG_SV.logmsg(l_module_name, 'number in loop '||cnt);
2489: END IF;
2490:
2491: -- Bugfix 2877445 if region type is postal code then dont search with
2492: -- city and state information. This is under the assumption that postal

Line 2587: WSH_DEBUG_SV.logmsg(l_module_name, ' parent offset '||l_parent_offset);

2583:
2584: -- Debug Statements
2585: --
2586: IF l_debug_on THEN
2587: WSH_DEBUG_SV.logmsg(l_module_name, ' parent offset '||l_parent_offset);
2588: END IF;
2589:
2590: END IF;
2591:

Line 2597: WSH_DEBUG_SV.logmsg(l_module_name, 'got region id '||l_region_rec1.region_id);

2593:
2594: -- Debug Statements
2595: --
2596: IF l_debug_on THEN
2597: WSH_DEBUG_SV.logmsg(l_module_name, 'got region id '||l_region_rec1.region_id);
2598: END IF;
2599:
2600: IF l_region_rec1.region_id > 0 THEN
2601:

Line 2606: WSH_DEBUG_SV.logmsg(l_module_name, ' Using region info of '||l_region_rec1.region_id);

2602: cnt_region := cnt_region + 1;
2603: -- Debug Statements
2604: --
2605: IF l_debug_on THEN
2606: WSH_DEBUG_SV.logmsg(l_module_name, ' Using region info of '||l_region_rec1.region_id);
2607: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);
2608: END IF;
2609:
2610: IF is_first THEN

Line 2607: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);

2603: -- Debug Statements
2604: --
2605: IF l_debug_on THEN
2606: WSH_DEBUG_SV.logmsg(l_module_name, ' Using region info of '||l_region_rec1.region_id);
2607: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);
2608: END IF;
2609:
2610: IF is_first THEN
2611: l_region_rec1.is_input_type := 'Y'; -- Record is fetched based on the exact input match.

Line 2619: WSH_DEBUG_SV.logmsg(l_module_name, ' Using region info of '||l_regions(i).region_id);

2615: -- Populating the output table x_regions such that the index starts from '1' not from '0'.
2616: FOR i IN l_regions.FIRST.. l_regions.LAST
2617: LOOP
2618: IF l_debug_on THEN
2619: WSH_DEBUG_SV.logmsg(l_module_name, ' Using region info of '||l_regions(i).region_id);
2620: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);
2621: END IF;
2622: l_regions(i).is_input_type := 'Y';
2623: x_regions(cnt_region) := l_regions(i);

Line 2620: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);

2616: FOR i IN l_regions.FIRST.. l_regions.LAST
2617: LOOP
2618: IF l_debug_on THEN
2619: WSH_DEBUG_SV.logmsg(l_module_name, ' Using region info of '||l_regions(i).region_id);
2620: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);
2621: END IF;
2622: l_regions(i).is_input_type := 'Y';
2623: x_regions(cnt_region) := l_regions(i);
2624: cnt_region := cnt_region + 1;

Line 2628: WSH_DEBUG_SV.pop(l_module_name);

2624: cnt_region := cnt_region + 1;
2625: END LOOP;
2626:
2627: IF l_debug_on THEN
2628: WSH_DEBUG_SV.pop(l_module_name);
2629: END IF;
2630:
2631: RETURN;
2632: END IF;

Line 2653: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching zone info of '||l_region_rec3.region_id);

2649:
2650: -- Debug Statements
2651: --
2652: IF l_debug_on THEN
2653: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching zone info of '||l_region_rec3.region_id);
2654: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);
2655: END IF;
2656:
2657: x_regions(cnt_region) := l_region_rec3;

Line 2654: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);

2650: -- Debug Statements
2651: --
2652: IF l_debug_on THEN
2653: WSH_DEBUG_SV.logmsg(l_module_name, ' fetching zone info of '||l_region_rec3.region_id);
2654: WSH_DEBUG_SV.logmsg(l_module_name, ' inserting into region table at '||cnt_region);
2655: END IF;
2656:
2657: x_regions(cnt_region) := l_region_rec3;
2658:

Line 2685: WSH_DEBUG_SV.logmsg(l_module_name, ' x_regions.COUNT '||x_regions.COUNT);

2681: IF (x_regions.COUNT = 0) THEN
2682: x_status := 1;
2683: ELSE
2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.logmsg(l_module_name, ' x_regions.COUNT '||x_regions.COUNT);
2686: END IF;
2687: END IF;
2688:
2689: --

Line 2693: WSH_DEBUG_SV.pop(l_module_name);

2689: --
2690: -- Debug Statements
2691: --
2692: IF l_debug_on THEN
2693: WSH_DEBUG_SV.pop(l_module_name);
2694: END IF;
2695: --
2696: --Bug 4775798
2697: EXCEPTION

Line 2701: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2697: EXCEPTION
2698: WHEN OTHERS THEN
2699: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2700: IF l_debug_on THEN
2701: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2703: ELSE
2704: WSH_UTIL_CORE.printmsg('Unexpected error has occured in WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2705: WSH_UTIL_CORE.printmsg(SQLERRM);

Line 2702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

2698: WHEN OTHERS THEN
2699: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2700: IF l_debug_on THEN
2701: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2703: ELSE
2704: WSH_UTIL_CORE.printmsg('Unexpected error has occured in WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2705: WSH_UTIL_CORE.printmsg(SQLERRM);
2706: END IF;

Line 2743: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2739: l_region_id_string VARCHAR2(32767);
2740: --
2741:
2742: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Get_All_RegionId_Matches';
2743: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2744: l_return_status VARCHAR2(1);
2745:
2746: BEGIN
2747:

Line 2751: wsh_debug_sv.push(l_module_name);

2747:
2748: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2749:
2750: IF l_debug_on THEN
2751: wsh_debug_sv.push(l_module_name);
2752: END IF;
2753:
2754: IF (p_use_cache) and (p_location_id < g_cache_max_size) THEN
2755:

Line 2770: wsh_debug_sv.pop(l_module_name);

2766: IF (l_region_id_tab(itr)<>-1) THEN
2767: x_region_tab := l_region_id_tab;
2768: END IF;
2769: IF l_debug_on THEN
2770: wsh_debug_sv.pop(l_module_name);
2771: END IF;
2772: RETURN;
2773: END IF;
2774: END IF;

Line 2809: WSH_DEBUG_SV.pop(l_module_name);

2805: g_location_region_tab(p_location_id) := l_region_id_string;
2806: END IF;
2807:
2808: IF l_debug_on THEN
2809: WSH_DEBUG_SV.pop(l_module_name);
2810: END IF;
2811:
2812: EXCEPTION
2813: WHEN others THEN

Line 2821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2817: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');
2818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2819: --
2820: IF l_debug_on THEN
2821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2823: --Bug 4775798
2824: ELSE
2825: WSH_UTIL_CORE.printmsg('Unexpected error has occured in Get_All_RegionId_Matches');

Line 2822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2819: --
2820: IF l_debug_on THEN
2821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2823: --Bug 4775798
2824: ELSE
2825: WSH_UTIL_CORE.printmsg('Unexpected error has occured in Get_All_RegionId_Matches');
2826: WSH_UTIL_CORE.printmsg('Oracle error message is '|| SQLERRM);

Line 2861: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2857:
2858: --
2859:
2860: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Get_All_Zone_Matches';
2861: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2862:
2863: BEGIN
2864:
2865: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2868: wsh_debug_sv.push(l_module_name);

2864:
2865: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2866:
2867: IF l_debug_on THEN
2868: wsh_debug_sv.push(l_module_name);
2869: END IF;
2870:
2871: IF (p_region_id < g_cache_max_size AND g_region_zone_tab.EXISTS(p_region_id)) THEN
2872:

Line 2885: wsh_debug_sv.pop(l_module_name);

2881: x_zone_tab := l_zone_tab;
2882: END IF;
2883:
2884: IF l_debug_on THEN
2885: wsh_debug_sv.pop(l_module_name);
2886: END IF;
2887: RETURN;
2888: END IF;
2889:

Line 2923: WSH_DEBUG_SV.pop(l_module_name);

2919:
2920: END IF;
2921:
2922: IF l_debug_on THEN
2923: WSH_DEBUG_SV.pop(l_module_name);
2924: END IF;
2925:
2926: EXCEPTION
2927: WHEN others THEN

Line 2935: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2931: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches');
2932: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2933: --
2934: IF l_debug_on THEN
2935: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2936: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2937: END IF;
2938: --
2939: END Get_All_Zone_Matches;

Line 2936: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2932: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2933: --
2934: IF l_debug_on THEN
2935: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2936: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2937: END IF;
2938: --
2939: END Get_All_Zone_Matches;
2940:

Line 2984: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2980: rg_itr NUMBER;
2981: r_nrec NUMBER;
2982: i NUMBER;
2983: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'get_all_region_deconsols';
2984: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2985:
2986: CURSOR c_get_all_regions_loc(c_location_id IN NUMBER, c_lang_code IN VARCHAR2) IS
2987: SELECT wrl.region_id,
2988: wr.region_type,

Line 3016: wsh_debug_sv.push (l_module_name);

3012: ----{
3013: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3014:
3015: IF l_debug_on THEN
3016: wsh_debug_sv.push (l_module_name);
3017: END IF;
3018:
3019: IF l_debug_on THEN
3020: WSH_DEBUG_SV.logmsg(l_module_name,'p_location_id: '|| p_location_id);

Line 3020: WSH_DEBUG_SV.logmsg(l_module_name,'p_location_id: '|| p_location_id);

3016: wsh_debug_sv.push (l_module_name);
3017: END IF;
3018:
3019: IF l_debug_on THEN
3020: WSH_DEBUG_SV.logmsg(l_module_name,'p_location_id: '|| p_location_id);
3021: END IF;
3022:
3023: -- If region deconsolidation location tab exists in cache, return
3024: -- else query database through c_get_all_regions_loc cursor

Line 3031: WSH_DEBUG_SV.pop(l_module_name);

3027:
3028: IF p_zone_flag = TRUE AND g_loc_region_zone_deconsol_tab.EXISTS(p_location_id) THEN
3029: x_region_consol_tab := g_loc_region_zone_deconsol_tab(p_location_id);
3030: IF l_debug_on THEN
3031: WSH_DEBUG_SV.pop(l_module_name);
3032: END IF;
3033: return;
3034: ELSIF g_loc_region_deconsol_tab.EXISTS(p_location_id) THEN
3035: x_region_consol_tab := g_loc_region_deconsol_tab(p_location_id);

Line 3037: WSH_DEBUG_SV.pop(l_module_name);

3033: return;
3034: ELSIF g_loc_region_deconsol_tab.EXISTS(p_location_id) THEN
3035: x_region_consol_tab := g_loc_region_deconsol_tab(p_location_id);
3036: IF l_debug_on THEN
3037: WSH_DEBUG_SV.pop(l_module_name);
3038: END IF;
3039: return;
3040: ELSE
3041: OPEN c_get_all_regions_loc(p_location_id,p_lang_code);

Line 3053: WSH_DEBUG_SV.logmsg(l_module_name,'l_region_tab.COUNT: '|| l_region_tab.COUNT);

3049: CLOSE c_get_all_regions_loc;
3050: END IF;
3051:
3052: IF l_debug_on THEN
3053: WSH_DEBUG_SV.logmsg(l_module_name,'l_region_tab.COUNT: '|| l_region_tab.COUNT);
3054: END IF;
3055:
3056: i := 1;
3057: IF p_use_cache = TRUE THEN

Line 3089: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);

3085: -- If deconsol location exists for region, then add it to deconsol_tab
3086: IF l_region_tab(r_itr).Deconsol_location IS NOT NULL THEN
3087: l_reg_zon_deconsol_tab(rg_itr) := l_region_tab(r_itr);
3088: IF l_debug_on THEN
3089: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);
3090: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);
3091: END IF;
3092: END IF;
3093:

Line 3090: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);

3086: IF l_region_tab(r_itr).Deconsol_location IS NOT NULL THEN
3087: l_reg_zon_deconsol_tab(rg_itr) := l_region_tab(r_itr);
3088: IF l_debug_on THEN
3089: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);
3090: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);
3091: END IF;
3092: END IF;
3093:
3094: IF p_use_cache = TRUE AND l_region_id < g_cache_max_size THEN

Line 3105: WSH_DEBUG_SV.logmsg(l_module_name,'l_zone_deconsol_tab.COUNT: '|| l_zone_deconsol_tab.COUNT);

3101: CLOSE c_get_zone_for_region;
3102: END IF;
3103:
3104: IF l_debug_on THEN
3105: WSH_DEBUG_SV.logmsg(l_module_name,'l_zone_deconsol_tab.COUNT: '|| l_zone_deconsol_tab.COUNT);
3106: END IF;
3107: ELSIF NOT (g_region_zone_deconsol_tab.EXISTS(l_region_id)) OR p_use_cache = FALSE THEN
3108: OPEN c_get_zone_for_region(l_region_id);
3109: FETCH c_get_zone_for_region BULK COLLECT INTO l_zone_deconsol_tab;

Line 3114: WSH_DEBUG_SV.logmsg(l_module_name,'l_zone_deconsol_tab.COUNT: '|| l_zone_deconsol_tab.COUNT);

3110: CLOSE c_get_zone_for_region;
3111: END IF;
3112:
3113: IF l_debug_on THEN
3114: WSH_DEBUG_SV.logmsg(l_module_name,'l_zone_deconsol_tab.COUNT: '|| l_zone_deconsol_tab.COUNT);
3115: END IF;
3116: -- IF p_rule_to_zone_id IS NOT NULL:
3117: -- If caller is not WMS: If at any level of regions the zone(s) obtained do not match
3118: -- with input p_rule_to_zone_id, that level of zone should be skipped.

Line 3132: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);

3128: IF l_zone_deconsol_tab(z_itr).region_id = p_rule_to_zone_id THEN
3129: rg_itr := rg_itr+1;
3130: l_reg_zon_deconsol_tab(rg_itr) := l_zone_deconsol_tab(z_itr);
3131: IF l_debug_on THEN
3132: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);
3133: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);
3134: END IF;
3135: EXIT;
3136: END IF;

Line 3133: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);

3129: rg_itr := rg_itr+1;
3130: l_reg_zon_deconsol_tab(rg_itr) := l_zone_deconsol_tab(z_itr);
3131: IF l_debug_on THEN
3132: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);
3133: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);
3134: END IF;
3135: EXIT;
3136: END IF;
3137:

Line 3150: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);

3146: LOOP
3147: rg_itr := rg_itr+1;
3148: l_reg_zon_deconsol_tab(rg_itr) := l_zone_deconsol_tab(z_itr);
3149: IF l_debug_on THEN
3150: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);
3151: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);
3152: END IF;
3153:
3154: EXIT WHEN z_itr = l_zone_deconsol_tab.LAST;

Line 3151: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);

3147: rg_itr := rg_itr+1;
3148: l_reg_zon_deconsol_tab(rg_itr) := l_zone_deconsol_tab(z_itr);
3149: IF l_debug_on THEN
3150: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).region_id: '|| l_reg_zon_deconsol_tab(rg_itr).region_id);
3151: WSH_DEBUG_SV.logmsg(l_module_name,'l_reg_zon_deconsol_tab(rg_itr).deconsol_location: '|| l_reg_zon_deconsol_tab(rg_itr).Deconsol_location);
3152: END IF;
3153:
3154: EXIT WHEN z_itr = l_zone_deconsol_tab.LAST;
3155: z_itr:= l_zone_deconsol_tab.NEXT(z_itr);

Line 3175: WSH_DEBUG_SV.logmsg(l_module_name,'x_region_consol_tab.COUNT: '|| x_region_consol_tab.COUNT);

3171: x_region_consol_tab := l_region_deconsol_tab;
3172: END IF;
3173:
3174: IF l_debug_on THEN
3175: WSH_DEBUG_SV.logmsg(l_module_name,'x_region_consol_tab.COUNT: '|| x_region_consol_tab.COUNT);
3176: END IF;
3177:
3178: IF l_debug_on THEN
3179: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: '|| x_return_status);

Line 3179: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: '|| x_return_status);

3175: WSH_DEBUG_SV.logmsg(l_module_name,'x_region_consol_tab.COUNT: '|| x_region_consol_tab.COUNT);
3176: END IF;
3177:
3178: IF l_debug_on THEN
3179: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: '|| x_return_status);
3180: END IF;
3181:
3182: IF l_debug_on THEN
3183: wsh_debug_sv.pop (l_module_name);

Line 3183: wsh_debug_sv.pop (l_module_name);

3179: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: '|| x_return_status);
3180: END IF;
3181:
3182: IF l_debug_on THEN
3183: wsh_debug_sv.pop (l_module_name);
3184: END IF;
3185: ----}
3186:
3187: EXCEPTION

Line 3193: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3191: --
3192: IF l_debug_on THEN
3193: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3194: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3195: END IF;
3196:
3197: WHEN OTHERS THEN

Line 3194: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3191: --
3192: IF l_debug_on THEN
3193: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3194: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3195: END IF;
3196:
3197: WHEN OTHERS THEN
3198: IF c_get_all_regions_loc%ISOPEN THEN

Line 3208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

3204: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols');
3205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3206: --
3207: IF l_debug_on THEN
3208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3210: END IF;
3211:
3212: END get_all_region_deconsols;

Line 3209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3206: --
3207: IF l_debug_on THEN
3208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3210: END IF;
3211:
3212: END get_all_region_deconsols;
3213:

Line 3273: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3269: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3270: --
3271: IF l_debug_on IS NULL
3272: THEN
3273: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3274: END IF;
3275: --
3276: --
3277: -- Debug Statements

Line 3280: WSH_DEBUG_SV.push(l_module_name);

3276: --
3277: -- Debug Statements
3278: --
3279: IF l_debug_on THEN
3280: WSH_DEBUG_SV.push(l_module_name);
3281: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3282: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);

Line 3281: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);

3277: -- Debug Statements
3278: --
3279: IF l_debug_on THEN
3280: WSH_DEBUG_SV.push(l_module_name);
3281: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3282: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);

Line 3282: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);

3278: --
3279: IF l_debug_on THEN
3280: WSH_DEBUG_SV.push(l_module_name);
3281: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3282: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3286: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);

Line 3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);

3279: IF l_debug_on THEN
3280: WSH_DEBUG_SV.push(l_module_name);
3281: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3282: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3286: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3287: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);

Line 3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);

3280: WSH_DEBUG_SV.push(l_module_name);
3281: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3282: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3286: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3287: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3288: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);

Line 3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);

3281: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3282: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3286: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3287: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3288: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
3289: END IF;

Line 3286: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);

3282: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3286: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3287: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3288: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
3289: END IF;
3290: --

Line 3287: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);

3283: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3286: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3287: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3288: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
3289: END IF;
3290: --
3291:

Line 3288: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);

3284: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3285: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3286: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3287: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3288: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
3289: END IF;
3290: --
3291:
3292: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3317: WSH_DEBUG_SV.log(l_module_name, 'Region_Id Fetched', x_region_info.region_id);

3313: --
3314: -- Debug Statements
3315: --
3316: IF l_debug_on THEN
3317: WSH_DEBUG_SV.log(l_module_name, 'Region_Id Fetched', x_region_info.region_id);
3318: END IF;
3319: --
3320:
3321: --

Line 3325: WSH_DEBUG_SV.pop(l_module_name);

3321: --
3322: -- Debug Statements
3323: --
3324: IF l_debug_on THEN
3325: WSH_DEBUG_SV.pop(l_module_name);
3326: END IF;
3327: --
3328:
3329: -- Exception Handling part

Line 3336: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO EXCEPTION : ' || sqlerrm);

3332: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3333: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3334: fnd_message.set_token('MSG_TEXT', SQLERRM);
3335: IF l_debug_on THEN
3336: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO EXCEPTION : ' || sqlerrm);
3337: WSH_DEBUG_SV.pop(l_module_name);
3338: END IF;
3339:
3340: END;

Line 3337: WSH_DEBUG_SV.pop(l_module_name);

3333: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3334: fnd_message.set_token('MSG_TEXT', SQLERRM);
3335: IF l_debug_on THEN
3336: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO EXCEPTION : ' || sqlerrm);
3337: WSH_DEBUG_SV.pop(l_module_name);
3338: END IF;
3339:
3340: END;
3341:

Line 3391: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3387: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3388: --
3389: IF l_debug_on IS NULL
3390: THEN
3391: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3392: END IF;
3393: --
3394: --
3395: -- Debug Statements

Line 3398: WSH_DEBUG_SV.push(l_module_name);

3394: --
3395: -- Debug Statements
3396: --
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.push(l_module_name);
3399: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3400: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);

Line 3399: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);

3395: -- Debug Statements
3396: --
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.push(l_module_name);
3399: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3400: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);
3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);

Line 3400: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);

3396: --
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.push(l_module_name);
3399: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3400: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);
3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);

Line 3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);

3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.push(l_module_name);
3399: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3400: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);
3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3405: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);

Line 3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);

3398: WSH_DEBUG_SV.push(l_module_name);
3399: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3400: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);
3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3405: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3406: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);

Line 3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);

3399: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY', P_COUNTRY);
3400: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);
3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3405: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3406: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3407: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);

Line 3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);

3400: WSH_DEBUG_SV.log(l_module_name, 'P_STATE', P_STATE);
3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);
3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3405: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3406: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3407: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
3408: END IF;

Line 3405: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);

3401: WSH_DEBUG_SV.log(l_module_name, 'P_CITY', P_CITY);
3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);
3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3405: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3406: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3407: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
3408: END IF;
3409: --

Line 3406: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);

3402: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY-CODE', P_COUNTRY_CODE);
3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3405: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3406: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3407: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
3408: END IF;
3409: --
3410:

Line 3407: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);

3403: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3404: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3405: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3406: WSH_DEBUG_SV.log(l_module_name, 'P_SEARCH_FLAG', P_SEARCH_FLAG);
3407: WSH_DEBUG_SV.log(l_module_name, 'P_LANG_CODE', P_LANG_CODE);
3408: END IF;
3409: --
3410:
3411: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3428: WSH_DEBUG_SV.log(l_module_name, 'Region_Id Fetched', x_region_info.region_id);

3424: --
3425: -- Debug Statements
3426: --
3427: IF l_debug_on THEN
3428: WSH_DEBUG_SV.log(l_module_name, 'Region_Id Fetched', x_region_info.region_id);
3429: END IF;
3430: --
3431:
3432: --

Line 3436: WSH_DEBUG_SV.pop(l_module_name);

3432: --
3433: -- Debug Statements
3434: --
3435: IF l_debug_on THEN
3436: WSH_DEBUG_SV.pop(l_module_name);
3437: END IF;
3438: --
3439:
3440: -- Exception Handling part

Line 3447: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO_CODE EXCEPTION : ' || SUBSTR(SQLERRM,1,200));

3443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3444: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3445: fnd_message.set_token('MSG_TEXT', SQLERRM);
3446: IF l_debug_on THEN
3447: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO_CODE EXCEPTION : ' || SUBSTR(SQLERRM,1,200));
3448: WSH_DEBUG_SV.pop(l_module_name);
3449: END IF;
3450:
3451: END;

Line 3448: WSH_DEBUG_SV.pop(l_module_name);

3444: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3445: fnd_message.set_token('MSG_TEXT', SQLERRM);
3446: IF l_debug_on THEN
3447: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_INFO_CODE EXCEPTION : ' || SUBSTR(SQLERRM,1,200));
3448: WSH_DEBUG_SV.pop(l_module_name);
3449: END IF;
3450:
3451: END;
3452:

Line 3510: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3506: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3507: --
3508: IF l_debug_on IS NULL
3509: THEN
3510: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3511: END IF;
3512: --
3513: --
3514: -- Debug Statements

Line 3517: WSH_DEBUG_SV.push(l_module_name);

3513: --
3514: -- Debug Statements
3515: --
3516: IF l_debug_on THEN
3517: WSH_DEBUG_SV.push(l_module_name);
3518: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY_CODE', P_COUNTRY_CODE);
3519: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);

Line 3518: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY_CODE', P_COUNTRY_CODE);

3514: -- Debug Statements
3515: --
3516: IF l_debug_on THEN
3517: WSH_DEBUG_SV.push(l_module_name);
3518: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY_CODE', P_COUNTRY_CODE);
3519: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3522: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);

Line 3519: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);

3515: --
3516: IF l_debug_on THEN
3517: WSH_DEBUG_SV.push(l_module_name);
3518: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY_CODE', P_COUNTRY_CODE);
3519: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3522: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3523: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);

Line 3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);

3516: IF l_debug_on THEN
3517: WSH_DEBUG_SV.push(l_module_name);
3518: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY_CODE', P_COUNTRY_CODE);
3519: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3522: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3523: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3524: WSH_DEBUG_SV.log(l_module_name, 'P_LANGUAGE_CODE', P_LANGUAGE_CODE);

Line 3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);

3517: WSH_DEBUG_SV.push(l_module_name);
3518: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY_CODE', P_COUNTRY_CODE);
3519: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3522: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3523: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3524: WSH_DEBUG_SV.log(l_module_name, 'P_LANGUAGE_CODE', P_LANGUAGE_CODE);
3525: END IF;

Line 3522: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);

3518: WSH_DEBUG_SV.log(l_module_name, 'P_COUNTRY_CODE', P_COUNTRY_CODE);
3519: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3522: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3523: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3524: WSH_DEBUG_SV.log(l_module_name, 'P_LANGUAGE_CODE', P_LANGUAGE_CODE);
3525: END IF;
3526: --

Line 3523: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);

3519: WSH_DEBUG_SV.log(l_module_name, 'P_STATE_CODE', P_STATE_CODE);
3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3522: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3523: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3524: WSH_DEBUG_SV.log(l_module_name, 'P_LANGUAGE_CODE', P_LANGUAGE_CODE);
3525: END IF;
3526: --
3527:

Line 3524: WSH_DEBUG_SV.log(l_module_name, 'P_LANGUAGE_CODE', P_LANGUAGE_CODE);

3520: WSH_DEBUG_SV.log(l_module_name, 'P_CITY_CODE', P_CITY_CODE);
3521: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_FROM', P_POSTAL_CODE_FROM);
3522: WSH_DEBUG_SV.log(l_module_name, 'P_POSTAL_CODE_TO', P_POSTAL_CODE_TO);
3523: WSH_DEBUG_SV.log(l_module_name, 'P_REGION_TYPE', P_REGION_TYPE);
3524: WSH_DEBUG_SV.log(l_module_name, 'P_LANGUAGE_CODE', P_LANGUAGE_CODE);
3525: END IF;
3526: --
3527:
3528: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3574: WSH_DEBUG_SV.log(l_module_name, 'Region_Id Fetched', x_region_id);

3570: --
3571: -- Debug Statements
3572: --
3573: IF l_debug_on THEN
3574: WSH_DEBUG_SV.log(l_module_name, 'Region_Id Fetched', x_region_id);
3575: END IF;
3576: --
3577:
3578: --

Line 3582: WSH_DEBUG_SV.pop(l_module_name);

3578: --
3579: -- Debug Statements
3580: --
3581: IF l_debug_on THEN
3582: WSH_DEBUG_SV.pop(l_module_name);
3583: END IF;
3584: --
3585:
3586: --wsh_debug_sv.logmsg(l_module_name, 'TOTAL TIME TAKEN FOR CHECK_REGION_ID_CODES_ONLY : ' || ((dbms_utility.get_time - t1)/100));

Line 3586: --wsh_debug_sv.logmsg(l_module_name, 'TOTAL TIME TAKEN FOR CHECK_REGION_ID_CODES_ONLY : ' || ((dbms_utility.get_time - t1)/100));

3582: WSH_DEBUG_SV.pop(l_module_name);
3583: END IF;
3584: --
3585:
3586: --wsh_debug_sv.logmsg(l_module_name, 'TOTAL TIME TAKEN FOR CHECK_REGION_ID_CODES_ONLY : ' || ((dbms_utility.get_time - t1)/100));
3587: -- Exception Handling part
3588: EXCEPTION
3589: WHEN OTHERS THEN
3590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3594: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_ID_CODES_ONLY EXCEPTION : ' || SUBSTR(SQLERRM,1,200));

3590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3591: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3592: fnd_message.set_token('MSG_TEXT', SQLERRM);
3593: IF l_debug_on THEN
3594: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_ID_CODES_ONLY EXCEPTION : ' || SUBSTR(SQLERRM,1,200));
3595: WSH_DEBUG_SV.pop(l_module_name);
3596: END IF;
3597:
3598: END;

Line 3595: WSH_DEBUG_SV.pop(l_module_name);

3591: fnd_message.set_name('WSH', 'WSH_UTIL_MESSAGE_U');
3592: fnd_message.set_token('MSG_TEXT', SQLERRM);
3593: IF l_debug_on THEN
3594: wsh_debug_sv.logmsg(l_module_name, 'CHECK_REGION_ID_CODES_ONLY EXCEPTION : ' || SUBSTR(SQLERRM,1,200));
3595: WSH_DEBUG_SV.pop(l_module_name);
3596: END IF;
3597:
3598: END;
3599: