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

Line 152: WSH_DEBUG_SV.push(l_module_name);

148:
149: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
150:
151: IF l_debug_on THEN
152: WSH_DEBUG_SV.push(l_module_name);
153: END IF;
154:
155: FOR i IN p_LocationId_Tbl.FIRST..p_LocationId_Tbl.LAST LOOP
156: IF (x_Timezone_Tbl(i) IS NULL OR

Line 172: WSH_DEBUG_SV.LogMsg(l_module_name, 'Get_Lat_Long_and_Timezone: ' || p_LocationId_Tbl(i));

168: l_location.TIMEZONE_CODE := NULL;
169: l_location.GEOMETRY := NULL;
170:
171: IF l_debug_on THEN
172: WSH_DEBUG_SV.LogMsg(l_module_name, 'Get_Lat_Long_and_Timezone: ' || p_LocationId_Tbl(i));
173: END IF;
174:
175: WSH_GEOCODING.Get_Lat_Long_and_TimeZone(p_api_version => 1.0,
176: p_init_msg_list => NULL,

Line 183: WSH_DEBUG_SV.Log(l_module_name, 'latitude', l_location.LATITUDE);

179: x_msg_data => x_error_msg,
180: l_location => l_location);
181:
182: IF l_debug_on THEN
183: WSH_DEBUG_SV.Log(l_module_name, 'latitude', l_location.LATITUDE);
184: WSH_DEBUG_SV.Log(l_module_name, 'longitude', l_location.LONGITUDE);
185: WSH_DEBUG_SV.Log(l_module_name, 'timezone_code', l_location.TIMEZONE_CODE);
186: END IF;
187:

Line 184: WSH_DEBUG_SV.Log(l_module_name, 'longitude', l_location.LONGITUDE);

180: l_location => l_location);
181:
182: IF l_debug_on THEN
183: WSH_DEBUG_SV.Log(l_module_name, 'latitude', l_location.LATITUDE);
184: WSH_DEBUG_SV.Log(l_module_name, 'longitude', l_location.LONGITUDE);
185: WSH_DEBUG_SV.Log(l_module_name, 'timezone_code', l_location.TIMEZONE_CODE);
186: END IF;
187:
188: --Update the Latitude, Longitude, Geometry and Timezone Code if

Line 185: WSH_DEBUG_SV.Log(l_module_name, 'timezone_code', l_location.TIMEZONE_CODE);

181:
182: IF l_debug_on THEN
183: WSH_DEBUG_SV.Log(l_module_name, 'latitude', l_location.LATITUDE);
184: WSH_DEBUG_SV.Log(l_module_name, 'longitude', l_location.LONGITUDE);
185: WSH_DEBUG_SV.Log(l_module_name, 'timezone_code', l_location.TIMEZONE_CODE);
186: END IF;
187:
188: --Update the Latitude, Longitude, Geometry and Timezone Code if
189: --The source values are null.

Line 213: WSH_DEBUG_SV.pop(l_module_name);

209: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
210: END IF;
211:
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.pop(l_module_name);
214: END IF;
215:
216: EXCEPTION
217: WHEN OTHERS THEN

Line 220: WSH_DEBUG_SV.logmsg(l_module_name, x_error_msg);

216: EXCEPTION
217: WHEN OTHERS THEN
218: x_error_msg := 'Unexpected Error in Get_Missing_Timezones: ' || sqlerrm;
219: IF l_debug_on THEN
220: WSH_DEBUG_SV.logmsg(l_module_name, x_error_msg);
221: -- Bug 4775798
222: ELSE
223: WSH_UTIL_CORE.printmsg(x_error_msg);
224: END IF;

Line 229: WSH_DEBUG_SV.pop(l_module_name);

225: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
227:
228: IF l_debug_on THEN
229: WSH_DEBUG_SV.pop(l_module_name);
230: END IF;
231:
232: END Get_Missing_Timezones;
233:

Line 276: WSH_DEBUG_SV.push(l_module_name);

272:
273: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
274:
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.push(l_module_name);
277: END IF;
278:
279: k := p_location_ids.FIRST;
280: LOOP

Line 289: WSH_DEBUG_SV.LogMsg(l_module_name,

285: IF (l_latitude IS NOT NULL AND
286: l_longitude IS NOT NULL) THEN
287:
288: IF l_debug_on THEN
289: WSH_DEBUG_SV.LogMsg(l_module_name,
290: 'Create Geometry for Lat/Lon: ' || l_latitude || '/'|| l_longitude);
291: END IF;
292:
293: Create_Geometry (p_longitude => l_longitude,

Line 303: WSH_DEBUG_SV.LogMsg(l_module_name, 'Geometry Created Succesfully');

299:
300: IF (l_geometry IS NOT NULL) THEN
301:
302: IF l_debug_on THEN
303: WSH_DEBUG_SV.LogMsg(l_module_name, 'Geometry Created Succesfully');
304: END IF;
305:
306: BEGIN
307: UPDATE wsh_locations

Line 313: WSH_DEBUG_SV.LogMsg(l_module_name,

309: WHERE wsh_location_id = p_location_ids(k);
310: EXCEPTION
311: WHEN OTHERS THEN
312: IF l_debug_on THEN
313: WSH_DEBUG_SV.LogMsg(l_module_name,
314: 'Update Geometry failed for location id : ' || p_location_ids(k));
315: END IF;
316: x_error_msg := 'UNEXP. Error in Update Geometries: ' || sqlerrm;
317: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

324: k := p_location_ids.NEXT(k);
325: END LOOP;
326:
327: IF l_debug_on THEN
328: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status is : '||x_return_status);
329: WSH_DEBUG_SV.pop(l_module_name);
330: END IF;
331:
332: EXCEPTION

Line 329: WSH_DEBUG_SV.pop(l_module_name);

325: END LOOP;
326:
327: IF l_debug_on THEN
328: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status is : '||x_return_status);
329: WSH_DEBUG_SV.pop(l_module_name);
330: END IF;
331:
332: EXCEPTION
333: WHEN OTHERS THEN

Line 337: WSH_DEBUG_SV.pop(l_module_name);

333: WHEN OTHERS THEN
334: x_error_msg := 'UNEXP. Error in Update Geometries: ' || sqlerrm;
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
336: IF l_debug_on THEN
337: WSH_DEBUG_SV.pop(l_module_name);
338: END IF;
339: --NULL;
340: END;
341:

Line 755: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

751: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
752: --
753: IF l_debug_on IS NULL
754: THEN
755: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
756: END IF;
757: --
758: --
759: -- Debug Statements

Line 762: WSH_DEBUG_SV.push(l_module_name);

758: --
759: -- Debug Statements
760: --
761: IF l_debug_on THEN
762: WSH_DEBUG_SV.push(l_module_name);
763: --
764: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
765: WSH_DEBUG_SV.log(l_module_name,'P_FROM_LOCATION',P_FROM_LOCATION);
766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);

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

760: --
761: IF l_debug_on THEN
762: WSH_DEBUG_SV.push(l_module_name);
763: --
764: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
765: WSH_DEBUG_SV.log(l_module_name,'P_FROM_LOCATION',P_FROM_LOCATION);
766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);
767: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
768: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);

Line 765: WSH_DEBUG_SV.log(l_module_name,'P_FROM_LOCATION',P_FROM_LOCATION);

761: IF l_debug_on THEN
762: WSH_DEBUG_SV.push(l_module_name);
763: --
764: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
765: WSH_DEBUG_SV.log(l_module_name,'P_FROM_LOCATION',P_FROM_LOCATION);
766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);
767: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
768: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
769: WSH_DEBUG_SV.log(l_module_name,'P_CREATE_FACILITIES',P_CREATE_FACILITIES);

Line 766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);

762: WSH_DEBUG_SV.push(l_module_name);
763: --
764: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
765: WSH_DEBUG_SV.log(l_module_name,'P_FROM_LOCATION',P_FROM_LOCATION);
766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);
767: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
768: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
769: WSH_DEBUG_SV.log(l_module_name,'P_CREATE_FACILITIES',P_CREATE_FACILITIES);
770: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);

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

763: --
764: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
765: WSH_DEBUG_SV.log(l_module_name,'P_FROM_LOCATION',P_FROM_LOCATION);
766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);
767: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
768: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
769: WSH_DEBUG_SV.log(l_module_name,'P_CREATE_FACILITIES',P_CREATE_FACILITIES);
770: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
771: END IF;

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

764: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
765: WSH_DEBUG_SV.log(l_module_name,'P_FROM_LOCATION',P_FROM_LOCATION);
766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);
767: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
768: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
769: WSH_DEBUG_SV.log(l_module_name,'P_CREATE_FACILITIES',P_CREATE_FACILITIES);
770: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
771: END IF;
772:

Line 769: WSH_DEBUG_SV.log(l_module_name,'P_CREATE_FACILITIES',P_CREATE_FACILITIES);

765: WSH_DEBUG_SV.log(l_module_name,'P_FROM_LOCATION',P_FROM_LOCATION);
766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);
767: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
768: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
769: WSH_DEBUG_SV.log(l_module_name,'P_CREATE_FACILITIES',P_CREATE_FACILITIES);
770: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
771: END IF;
772:
773: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');

Line 770: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);

766: WSH_DEBUG_SV.log(l_module_name,'P_TO_LOCATION',P_TO_LOCATION);
767: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
768: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
769: WSH_DEBUG_SV.log(l_module_name,'P_CREATE_FACILITIES',P_CREATE_FACILITIES);
770: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
771: END IF;
772:
773: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');
774: l_end_date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS') +1;

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

773: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');
774: l_end_date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS') +1;
775:
776: IF l_debug_on THEN
777: WSH_DEBUG_SV.log(l_module_name,'l_START_DATE',l_START_DATE);
778: WSH_DEBUG_SV.log(l_module_name,'l_END_DATE', l_END_DATE);
779: END IF;
780:
781: --

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

774: l_end_date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS') +1;
775:
776: IF l_debug_on THEN
777: WSH_DEBUG_SV.log(l_module_name,'l_START_DATE',l_START_DATE);
778: WSH_DEBUG_SV.log(l_module_name,'l_END_DATE', l_END_DATE);
779: END IF;
780:
781: --
782: -- l_log_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

Line 792: -- WSH_DEBUG_SV.logmsg(l_module_name,'In the procedure Process_Locations');

788: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
789: END IF;
790: */
791: IF l_debug_on THEN
792: -- WSH_DEBUG_SV.logmsg(l_module_name,'In the procedure Process_Locations');
793: WSH_DEBUG_SV.logmsg(l_module_name,'Processing Locations between ' || p_from_location || ' and '|| p_to_location);
794: END IF;
795: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
796:

Line 793: WSH_DEBUG_SV.logmsg(l_module_name,'Processing Locations between ' || p_from_location || ' and '|| p_to_location);

789: END IF;
790: */
791: IF l_debug_on THEN
792: -- WSH_DEBUG_SV.logmsg(l_module_name,'In the procedure Process_Locations');
793: WSH_DEBUG_SV.logmsg(l_module_name,'Processing Locations between ' || p_from_location || ' and '|| p_to_location);
794: END IF;
795: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
796:
797: -- As a part of Bug 4995478 the derivation of ui_location_code is custom enabled.

Line 818: WSH_DEBUG_SV.logmsg(l_module_name,' Processing Custom Code for Locations');

814: --
815: IF l_use_custom_ui_location = 'Y' THEN
816: --
817: IF l_debug_on THEN
818: WSH_DEBUG_SV.logmsg(l_module_name,' Processing Custom Code for Locations');
819: END IF;
820: --
821: END IF;
822:

Line 828: WSH_DEBUG_SV.logmsg(l_module_name,'Processing the External Locations');

824: l_previous_rows := 0;
825:
826: IF p_location_type = 'EXTERNAL' OR p_location_type = 'BOTH' THEN
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.logmsg(l_module_name,'Processing the External Locations');
829: END IF;
830:
831: l_location_source_code := 'HZ';
832:

Line 868: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pUpdateLocationIdTbl.COUNT||' hz locations for update ');

864: l_previous_rows := l_current_rows ;
865:
866: IF pUpdateLocationIdTbl.COUNT <> 0 THEN
867: IF l_debug_on THEN
868: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pUpdateLocationIdTbl.COUNT||' hz locations for update ');
869: END IF;
870:
871: --
872: --Bug 4995478 Start

Line 923: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Missing_Timezones : ' || x_sqlerr);

919: x_error_msg => x_sqlerr);
920:
921: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Missing_Timezones : ' || x_sqlerr);
924: END IF;
925: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
926: END IF;
927:

Line 932: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Update_Locations ');

928: Update_Locations(pUpdateLocationIdTbl,l_location_source_code,x_return_status);
929:
930: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
931: IF l_debug_on THEN
932: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Update_Locations ');
933: WSH_DEBUG_SV.pop(l_module_name);
934: END IF;
935: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
936: return;

Line 933: WSH_DEBUG_SV.pop(l_module_name);

929:
930: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
931: IF l_debug_on THEN
932: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Update_Locations ');
933: WSH_DEBUG_SV.pop(l_module_name);
934: END IF;
935: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
936: return;
937: END IF;

Line 939: WSH_DEBUG_SV.logmsg(l_module_name,'Successful in the update operation');

935: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
936: return;
937: END IF;
938: IF l_debug_on THEN
939: WSH_DEBUG_SV.logmsg(l_module_name,'Successful in the update operation');
940: END IF;
941:
942: --Create facilities for the locations, if necessary.
943: --'N' is the default for the parameter.

Line 950: WSH_DEBUG_SV.logmsg(l_module_name,

946: IF (UPPER(p_create_facilities) = 'Y' OR
947: (p_create_facilities IS NULL AND WSH_UTIL_CORE.Tp_Is_Installed = 'Y')) THEN
948: i := pUpdateLocationIdTbl.COUNT;
949: IF l_debug_on THEN
950: WSH_DEBUG_SV.logmsg(l_module_name,
951: 'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| ' External locations.');
952: END IF;
953: BEGIN
954:

Line 963: WSH_DEBUG_SV.logmsg(l_module_name,'Create Facilities: ' || x_sqlerr);

959: x_error_msg => x_sqlerr);
960:
961: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
962: IF l_debug_on THEN
963: WSH_DEBUG_SV.logmsg(l_module_name,'Create Facilities: ' || x_sqlerr);
964: END IF;
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
966: END IF;
967:

Line 971: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. EXCEPTION WHILE CREATING FACILITIES: ' || sqlerrm);

967:
968: EXCEPTION
969: WHEN OTHERS THEN
970: IF l_debug_on THEN
971: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. EXCEPTION WHILE CREATING FACILITIES: ' || sqlerrm);
972: END IF;
973: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
974: END;
975: END IF;

Line 989: WSH_DEBUG_SV.logmsg(l_module_name,'Update_Geometries : ' || x_sqlerr);

985: x_return_status => x_return_status,
986: x_error_msg => x_sqlerr);
987: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
988: IF l_debug_on THEN
989: WSH_DEBUG_SV.logmsg(l_module_name,'Update_Geometries : ' || x_sqlerr);
990: END IF;
991: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
992: END IF;
993: EXCEPTION

Line 996: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. Exception while updating geometries: ' || sqlerrm);

992: END IF;
993: EXCEPTION
994: WHEN OTHERS THEN
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. Exception while updating geometries: ' || sqlerrm);
997: END IF;
998: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
999: END;
1000: END IF;

Line 1047: WSH_DEBUG_SV.logmsg(l_module_name,'Number of locations to be inserted or updated in this range is 0');

1043: l_previous_rows := l_current_rows ;
1044:
1045: IF pInsertLocationIdTbl.COUNT = 0 THEN
1046: IF l_debug_on THEN
1047: WSH_DEBUG_SV.logmsg(l_module_name,'Number of locations to be inserted or updated in this range is 0');
1048: END IF;
1049: --
1050: -- Debug Statements
1051: --

Line 1053: WSH_DEBUG_SV.pop(l_module_name);

1049: --
1050: -- Debug Statements
1051: --
1052: IF l_debug_on THEN
1053: WSH_DEBUG_SV.pop(l_module_name);
1054: END IF;
1055: --
1056: return ;
1057: END IF;

Line 1061: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pInsertLocationIdTbl.COUNT||' hz locations for insert ');

1057: END IF;
1058:
1059: IF pInsertLocationIdTbl.COUNT <> 0 THEN
1060: IF l_debug_on THEN
1061: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pInsertLocationIdTbl.COUNT||' hz locations for insert ');
1062: END IF;
1063:
1064: --
1065: --Bug 4995478 Start

Line 1113: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Missing_Timezones : ' || x_sqlerr);

1109: x_error_msg => x_sqlerr);
1110:
1111: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1112: IF l_debug_on THEN
1113: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Missing_Timezones : ' || x_sqlerr);
1114: END IF;
1115: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1116: END IF;
1117:

Line 1123: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Insert_Locations ');

1119:
1120: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1121: IF l_debug_on THEN
1122: -- Bug 4775798
1123: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Insert_Locations ');
1124: WSH_DEBUG_SV.pop(l_module_name);
1125: END IF;
1126: return;
1127: END IF;

Line 1124: WSH_DEBUG_SV.pop(l_module_name);

1120: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1121: IF l_debug_on THEN
1122: -- Bug 4775798
1123: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Insert_Locations ');
1124: WSH_DEBUG_SV.pop(l_module_name);
1125: END IF;
1126: return;
1127: END IF;
1128: IF l_debug_on THEN

Line 1129: WSH_DEBUG_SV.logmsg(l_module_name,'Successful in the insert operation');

1125: END IF;
1126: return;
1127: END IF;
1128: IF l_debug_on THEN
1129: WSH_DEBUG_SV.logmsg(l_module_name,'Successful in the insert operation');
1130: END IF;
1131: --Create facilities for the locations, if necessary.
1132: --'N' is the default for the parameter.
1133: -- 1. If this procedure is explicitly called with 'Y', then we create facilities.

Line 1139: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| 'External locations.');

1135: IF (UPPER(p_create_facilities) = 'Y' OR
1136: (p_create_facilities IS NULL AND WSH_UTIL_CORE.Tp_Is_Installed = 'Y')) THEN
1137: i := pInsertLocationIdTbl.COUNT;
1138: IF l_debug_on THEN
1139: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| 'External locations.');
1140: END IF;
1141: BEGIN
1142:
1143: WSH_FACILITIES_INTEGRATION.Create_Facilities(p_location_ids => pInsertLocationIdTbl,

Line 1151: WSH_DEBUG_SV.logmsg(l_module_name,'Create Facilities: ' || x_sqlerr);

1147: x_error_msg => x_sqlerr);
1148:
1149: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1150: IF l_debug_on THEN
1151: WSH_DEBUG_SV.logmsg(l_module_name,'Create Facilities: ' || x_sqlerr);
1152: END IF;
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1154: END IF;
1155:

Line 1159: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. EXCEPTION WHILE CREATING FACILITIES: ' || sqlerrm);

1155:
1156: EXCEPTION
1157: WHEN OTHERS THEN
1158: IF l_debug_on THEN
1159: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. EXCEPTION WHILE CREATING FACILITIES: ' || sqlerrm);
1160: END IF;
1161: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1162: END;
1163:

Line 1179: WSH_DEBUG_SV.logmsg(l_module_name,'Update_Geometries : ' || x_sqlerr);

1175: x_return_status => x_return_status,
1176: x_error_msg => x_sqlerr);
1177: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1178: IF l_debug_on THEN
1179: WSH_DEBUG_SV.logmsg(l_module_name,'Update_Geometries : ' || x_sqlerr);
1180: END IF;
1181: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1182: END IF;
1183: EXCEPTION

Line 1186: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. Exception while updating geometries: ' || sqlerrm);

1182: END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: IF l_debug_on THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. Exception while updating geometries: ' || sqlerrm);
1187: END IF;
1188: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1189: END;
1190: END IF;

Line 1207: WSH_DEBUG_SV.logmsg(l_module_name,'Processing the Internal Locations');

1203: l_previous_rows := 0;
1204:
1205: IF p_location_type = 'INTERNAL' OR p_location_type = 'BOTH' THEN
1206: IF l_debug_on THEN
1207: WSH_DEBUG_SV.logmsg(l_module_name,'Processing the Internal Locations');
1208: END IF;
1209: l_location_source_code := 'HR';
1210:
1211: OPEN Get_Int_Update_Loc (l_start_date, l_end_date);

Line 1246: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pUpdateLocationIdTbl.COUNT||' hr locations for update ');

1242: l_previous_rows := l_current_rows ;
1243:
1244: IF pUpdateLocationIdTbl.COUNT <> 0 THEN
1245: IF l_debug_on THEN
1246: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pUpdateLocationIdTbl.COUNT||' hr locations for update ');
1247: END IF;
1248:
1249: --
1250: --Bug 4995478 Start

Line 1295: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Missing_Timezones : ' || x_sqlerr);

1291: x_error_msg => x_sqlerr);
1292:
1293: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1294: IF l_debug_on THEN
1295: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Missing_Timezones : ' || x_sqlerr);
1296: END IF;
1297: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1298: END IF;
1299:

Line 1306: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Update_Locations ');

1302: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1303:
1304: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Update_Locations ');
1307: WSH_DEBUG_SV.pop(l_module_name);
1308: END IF;
1309: return;
1310: END IF;

Line 1307: WSH_DEBUG_SV.pop(l_module_name);

1303:
1304: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Update_Locations ');
1307: WSH_DEBUG_SV.pop(l_module_name);
1308: END IF;
1309: return;
1310: END IF;
1311: IF l_debug_on THEN

Line 1312: WSH_DEBUG_SV.logmsg(l_module_name,'Successful in the update operation');

1308: END IF;
1309: return;
1310: END IF;
1311: IF l_debug_on THEN
1312: WSH_DEBUG_SV.logmsg(l_module_name,'Successful in the update operation');
1313: END IF;
1314: --Create facilities for the locations, if necessary.
1315: --'N' is the default for the parameter.
1316: -- 1. If this procedure is explicitly called with 'Y', then we create facilities.

Line 1322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| 'Internal locations.');

1318: IF (UPPER(p_create_facilities) = 'Y' OR
1319: (p_create_facilities IS NULL AND WSH_UTIL_CORE.Tp_Is_Installed = 'Y')) THEN
1320: i := pUpdateLocationIdTbl.COUNT;
1321: IF l_debug_on THEN
1322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| 'Internal locations.');
1323: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||pUpdateOwnerNameTbl.COUNT|| 'Company Names.');
1324: END IF;
1325: BEGIN
1326:

Line 1323: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||pUpdateOwnerNameTbl.COUNT|| 'Company Names.');

1319: (p_create_facilities IS NULL AND WSH_UTIL_CORE.Tp_Is_Installed = 'Y')) THEN
1320: i := pUpdateLocationIdTbl.COUNT;
1321: IF l_debug_on THEN
1322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| 'Internal locations.');
1323: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||pUpdateOwnerNameTbl.COUNT|| 'Company Names.');
1324: END IF;
1325: BEGIN
1326:
1327: WSH_FACILITIES_INTEGRATION.Create_Facilities(p_location_ids => pUpdateLocationIdTbl,

Line 1336: WSH_DEBUG_SV.logmsg(l_module_name,'Create Facilities: ' || x_sqlerr);

1332:
1333:
1334: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name,'Create Facilities: ' || x_sqlerr);
1337: END IF;
1338: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1339: END IF;
1340:

Line 1344: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. EXCEPTION WHILE CREATING FACILITIES: ' || sqlerrm);

1340:
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: IF l_debug_on THEN
1344: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. EXCEPTION WHILE CREATING FACILITIES: ' || sqlerrm);
1345: END IF;
1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1347: END;
1348: END IF;

Line 1362: WSH_DEBUG_SV.logmsg(l_module_name,'Update_Geometries : ' || x_sqlerr);

1358: x_return_status => x_return_status,
1359: x_error_msg => x_sqlerr);
1360: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name,'Update_Geometries : ' || x_sqlerr);
1363: END IF;
1364: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1365: END IF;
1366: EXCEPTION

Line 1369: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. Exception while updating geometries: ' || sqlerrm);

1365: END IF;
1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. Exception while updating geometries: ' || sqlerrm);
1370: END IF;
1371: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1372: END;
1373: END IF;

Line 1422: WSH_DEBUG_SV.logmsg(l_module_name,'Number of locations to be inserted or updated in this range is 0');

1418: l_previous_rows := l_current_rows ;
1419:
1420: IF pInsertLocationIdTbl.COUNT = 0 THEN
1421: IF l_debug_on THEN
1422: WSH_DEBUG_SV.logmsg(l_module_name,'Number of locations to be inserted or updated in this range is 0');
1423: END IF;
1424: --
1425: -- Debug Statements
1426: --

Line 1428: WSH_DEBUG_SV.pop(l_module_name);

1424: --
1425: -- Debug Statements
1426: --
1427: IF l_debug_on THEN
1428: WSH_DEBUG_SV.pop(l_module_name);
1429: END IF;
1430: --
1431: return ;
1432: END IF;

Line 1436: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pInsertLocationIdTbl.COUNT||' hr locations for insert ');

1432: END IF;
1433:
1434: IF pInsertLocationIdTbl.COUNT <> 0 THEN
1435: IF l_debug_on THEN
1436: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pInsertLocationIdTbl.COUNT||' hr locations for insert ');
1437: END IF;
1438:
1439: --
1440: --Bug 4995478 Start

Line 1486: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Missing_Timezones : ' || x_sqlerr);

1482: x_error_msg => x_sqlerr);
1483:
1484: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1485: IF l_debug_on THEN
1486: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Missing_Timezones : ' || x_sqlerr);
1487: END IF;
1488: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1489: END IF;
1490:

Line 1497: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Insert_Locations ');

1493: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1494:
1495: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1496: IF l_debug_on THEN
1497: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Insert_Locations ');
1498: WSH_DEBUG_SV.pop(l_module_name);
1499: END IF;
1500: return;
1501: END IF;

Line 1498: WSH_DEBUG_SV.pop(l_module_name);

1494:
1495: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1496: IF l_debug_on THEN
1497: WSH_DEBUG_SV.logmsg(l_module_name,'Error in Insert_Locations ');
1498: WSH_DEBUG_SV.pop(l_module_name);
1499: END IF;
1500: return;
1501: END IF;
1502: IF l_debug_on THEN

Line 1503: WSH_DEBUG_SV.logmsg(l_module_name,'Successful in the insert operation');

1499: END IF;
1500: return;
1501: END IF;
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.logmsg(l_module_name,'Successful in the insert operation');
1504: END IF;
1505: --Create facilities for the locations, if necessary.
1506: --'N' is the default for the parameter.
1507: -- 1. If this procedure is explicitly called with 'Y', then we create facilities.

Line 1513: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| 'Internal locations.');

1509: IF (UPPER(p_create_facilities) = 'Y' OR
1510: (p_create_facilities IS NULL AND WSH_UTIL_CORE.Tp_Is_Installed = 'Y')) THEN
1511: i := pInsertLocationIdTbl.COUNT;
1512: IF l_debug_on THEN
1513: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| 'Internal locations.');
1514: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||pInsertOwnerNameTbl.COUNT|| 'Company Names.');
1515: END IF;
1516: BEGIN
1517: WSH_FACILITIES_INTEGRATION.Create_Facilities(p_location_ids => pInsertLocationIdTbl,

Line 1514: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||pInsertOwnerNameTbl.COUNT|| 'Company Names.');

1510: (p_create_facilities IS NULL AND WSH_UTIL_CORE.Tp_Is_Installed = 'Y')) THEN
1511: i := pInsertLocationIdTbl.COUNT;
1512: IF l_debug_on THEN
1513: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||i|| 'Internal locations.');
1514: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FACILITIES_INTEGRATION.CREATE_FACILITIES with ' ||pInsertOwnerNameTbl.COUNT|| 'Company Names.');
1515: END IF;
1516: BEGIN
1517: WSH_FACILITIES_INTEGRATION.Create_Facilities(p_location_ids => pInsertLocationIdTbl,
1518: p_company_names => pInsertOwnerNameTbl,

Line 1525: WSH_DEBUG_SV.logmsg(l_module_name,'Create Facilities: ' || x_sqlerr);

1521: x_error_msg => x_sqlerr);
1522:
1523: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1524: IF l_debug_on THEN
1525: WSH_DEBUG_SV.logmsg(l_module_name,'Create Facilities: ' || x_sqlerr);
1526: END IF;
1527: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1528: END IF;
1529:

Line 1533: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. EXCEPTION WHILE CREATING FACILITIES: ' || sqlerrm);

1529:
1530: EXCEPTION
1531: WHEN OTHERS THEN
1532: IF l_debug_on THEN
1533: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. EXCEPTION WHILE CREATING FACILITIES: ' || sqlerrm);
1534: END IF;
1535: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1536: END;
1537: END IF;

Line 1551: WSH_DEBUG_SV.logmsg(l_module_name,'Update_Geometries : ' || x_sqlerr);

1547: x_return_status => x_return_status,
1548: x_error_msg => x_sqlerr);
1549: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1550: IF l_debug_on THEN
1551: WSH_DEBUG_SV.logmsg(l_module_name,'Update_Geometries : ' || x_sqlerr);
1552: END IF;
1553: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1554: END IF;
1555: EXCEPTION

Line 1558: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. Exception while updating geometries: ' || sqlerrm);

1554: END IF;
1555: EXCEPTION
1556: WHEN OTHERS THEN
1557: IF l_debug_on THEN
1558: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXP. Exception while updating geometries: ' || sqlerrm);
1559: END IF;
1560: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1561: END;
1562: END IF;

Line 1580: WSH_DEBUG_SV.pop(l_module_name);

1576: --
1577: -- Debug Statements
1578: --
1579: IF l_debug_on THEN
1580: WSH_DEBUG_SV.pop(l_module_name);
1581: END IF;
1582: --
1583: EXCEPTION
1584: WHEN others THEN

Line 1593: WSH_DEBUG_SV.logmsg(l_module_name,'In the Others Exception of Locations_Child');

1589: -- Debug Statements
1590: --
1591: IF l_debug_on THEN
1592: -- Bug 4775798
1593: WSH_DEBUG_SV.logmsg(l_module_name,'In the Others Exception of Locations_Child');
1594: WSH_DEBUG_SV.logmsg(l_module_name,'SQLCODE : ' || l_sqlcode);
1595: WSH_DEBUG_SV.logmsg(l_module_name,'SQLERRM : ' || l_sqlerr);
1596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1597:

Line 1594: WSH_DEBUG_SV.logmsg(l_module_name,'SQLCODE : ' || l_sqlcode);

1590: --
1591: IF l_debug_on THEN
1592: -- Bug 4775798
1593: WSH_DEBUG_SV.logmsg(l_module_name,'In the Others Exception of Locations_Child');
1594: WSH_DEBUG_SV.logmsg(l_module_name,'SQLCODE : ' || l_sqlcode);
1595: WSH_DEBUG_SV.logmsg(l_module_name,'SQLERRM : ' || l_sqlerr);
1596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1597:
1598: ELSE

Line 1595: WSH_DEBUG_SV.logmsg(l_module_name,'SQLERRM : ' || l_sqlerr);

1591: IF l_debug_on THEN
1592: -- Bug 4775798
1593: WSH_DEBUG_SV.logmsg(l_module_name,'In the Others Exception of Locations_Child');
1594: WSH_DEBUG_SV.logmsg(l_module_name,'SQLCODE : ' || l_sqlcode);
1595: WSH_DEBUG_SV.logmsg(l_module_name,'SQLERRM : ' || l_sqlerr);
1596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1597:
1598: ELSE
1599: WSH_UTIL_CORE.printmsg('In the Others Exception of Locations_Child');

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

1592: -- Bug 4775798
1593: WSH_DEBUG_SV.logmsg(l_module_name,'In the Others Exception of Locations_Child');
1594: WSH_DEBUG_SV.logmsg(l_module_name,'SQLCODE : ' || l_sqlcode);
1595: WSH_DEBUG_SV.logmsg(l_module_name,'SQLERRM : ' || l_sqlerr);
1596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1597:
1598: ELSE
1599: WSH_UTIL_CORE.printmsg('In the Others Exception of Locations_Child');
1600: WSH_UTIL_CORE.printmsg(l_sqlcode);

Line 1632: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1628: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1629: --
1630: IF l_debug_on IS NULL
1631: THEN
1632: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1633: END IF;
1634: --
1635: --
1636: -- Debug Statements

Line 1639: WSH_DEBUG_SV.push(l_module_name);

1635: --
1636: -- Debug Statements
1637: --
1638: IF l_debug_on THEN
1639: WSH_DEBUG_SV.push(l_module_name);
1640: END IF;
1641: --
1642: FOR i IN 1..pLocationIdTbl.count LOOP
1643:

Line 1673: WSH_DEBUG_SV.pop(l_module_name);

1669: --
1670: -- Debug Statements
1671: --
1672: IF l_debug_on THEN
1673: WSH_DEBUG_SV.pop(l_module_name);
1674: END IF;
1675: --
1676: END get_site_number;
1677:

Line 1701: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1697: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1698: --
1699: IF l_debug_on IS NULL
1700: THEN
1701: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1702: END IF;
1703: --
1704: --
1705: -- Debug Statements

Line 1708: WSH_DEBUG_SV.push(l_module_name);

1704: --
1705: -- Debug Statements
1706: --
1707: IF l_debug_on THEN
1708: WSH_DEBUG_SV.push(l_module_name);
1709: --
1710: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
1711: END IF;
1712: --

Line 1710: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);

1706: --
1707: IF l_debug_on THEN
1708: WSH_DEBUG_SV.push(l_module_name);
1709: --
1710: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
1711: END IF;
1712: --
1713: BEGIN
1714: l_start := pInsertLocationIdTbl.FIRST;

Line 1775: WSH_DEBUG_SV.logmsg(l_module_name,'Duplicate location id found for location_id '||l_loc_id);

1771: --ORA:00001 is the unique constraint violation. We are attempting
1772: --to insert a facility that already exists.
1773: IF ( l_error_code = -1 ) THEN
1774: IF l_debug_on THEN
1775: WSH_DEBUG_SV.logmsg(l_module_name,'Duplicate location id found for location_id '||l_loc_id);
1776: END IF;
1777: l_start := l_start + sql%rowcount + 1;
1778: ELSE
1779: IF l_debug_on THEN

Line 1780: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE CREATING WSH_LOCATION LOCATION '||l_loc_id);

1776: END IF;
1777: l_start := l_start + sql%rowcount + 1;
1778: ELSE
1779: IF l_debug_on THEN
1780: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE CREATING WSH_LOCATION LOCATION '||l_loc_id);
1781: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);
1782: -- Bug 4775798
1783: ELSE
1784: WSH_UTIL_CORE.printmsg('UNEXPECTED ERROR WHILE CREATING WSH_LOCATION FOR LOCATION '||l_loc_id);

Line 1781: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);

1777: l_start := l_start + sql%rowcount + 1;
1778: ELSE
1779: IF l_debug_on THEN
1780: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE CREATING WSH_LOCATION LOCATION '||l_loc_id);
1781: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);
1782: -- Bug 4775798
1783: ELSE
1784: WSH_UTIL_CORE.printmsg('UNEXPECTED ERROR WHILE CREATING WSH_LOCATION FOR LOCATION '||l_loc_id);
1785: WSH_UTIL_CORE.printmsg('ERROR MESSAGE '||SQLERRM);

Line 1789: WSH_DEBUG_SV.pop(l_module_name);

1785: WSH_UTIL_CORE.printmsg('ERROR MESSAGE '||SQLERRM);
1786: END IF;
1787: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1788: IF l_debug_on THEN
1789: WSH_DEBUG_SV.pop(l_module_name);
1790: END IF;
1791: RETURN;
1792: END IF;
1793: END;

Line 1805: WSH_DEBUG_SV.pop(l_module_name);

1801: --
1802: -- Debug Statements
1803: --
1804: IF l_debug_on THEN
1805: WSH_DEBUG_SV.pop(l_module_name);
1806: END IF;
1807: --
1808: -- Bug 4775798
1809: EXCEPTION

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

1810: WHEN OTHERS THEN
1811: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1812: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.insert_locations', l_module_name);
1813: IF l_debug_on THEN
1814: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1815: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1816: ELSE
1817: WSH_UTIL_CORE.printmsg('Unexpected error in Insert_Locations');
1818: WSH_UTIL_CORE.printmsg(SQLERRM);

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

1811: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1812: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.insert_locations', l_module_name);
1813: IF l_debug_on THEN
1814: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1815: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1816: ELSE
1817: WSH_UTIL_CORE.printmsg('Unexpected error in Insert_Locations');
1818: WSH_UTIL_CORE.printmsg(SQLERRM);
1819: END IF;

Line 1843: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1839: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1840: --
1841: IF l_debug_on IS NULL
1842: THEN
1843: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1844: END IF;
1845: --
1846: --
1847: -- Debug Statements

Line 1850: WSH_DEBUG_SV.push(l_module_name);

1846: --
1847: -- Debug Statements
1848: --
1849: IF l_debug_on THEN
1850: WSH_DEBUG_SV.push(l_module_name);
1851: --
1852: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
1853: END IF;
1854: --

Line 1852: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);

1848: --
1849: IF l_debug_on THEN
1850: WSH_DEBUG_SV.push(l_module_name);
1851: --
1852: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
1853: END IF;
1854: --
1855: BEGIN
1856: forall i in pUpdateLocationIdTbl.FIRST..pUpdateLocationIdTbl.LAST

Line 1883: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE UPDATING WSH_LOCATION FOR LOCATION '||l_loc_id);

1879: WHEN OTHERS THEN
1880: l_loc_id := pUpdateLocCodeTbl(pUpdateLocationIdTbl.FIRST + sql%rowcount);
1881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE UPDATING WSH_LOCATION FOR LOCATION '||l_loc_id);
1884: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);
1885: WSH_DEBUG_SV.pop(l_module_name);
1886: -- Bug 4775798
1887: ELSE

Line 1884: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);

1880: l_loc_id := pUpdateLocCodeTbl(pUpdateLocationIdTbl.FIRST + sql%rowcount);
1881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE UPDATING WSH_LOCATION FOR LOCATION '||l_loc_id);
1884: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);
1885: WSH_DEBUG_SV.pop(l_module_name);
1886: -- Bug 4775798
1887: ELSE
1888: WSH_UTIL_CORE.printmsg('UNEXPECTED ERROR WHILE UPDATING WSH_LOCATION FOR LOCATION '||l_loc_id);

Line 1885: WSH_DEBUG_SV.pop(l_module_name);

1881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE UPDATING WSH_LOCATION FOR LOCATION '||l_loc_id);
1884: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);
1885: WSH_DEBUG_SV.pop(l_module_name);
1886: -- Bug 4775798
1887: ELSE
1888: WSH_UTIL_CORE.printmsg('UNEXPECTED ERROR WHILE UPDATING WSH_LOCATION FOR LOCATION '||l_loc_id);
1889: WSH_UTIL_CORE.printmsg('ERROR MESSAGE '||SQLERRM);

Line 1901: WSH_DEBUG_SV.pop(l_module_name);

1897: --
1898: -- Debug Statements
1899: --
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.pop(l_module_name);
1902: END IF;
1903: --
1904: -- Bug 4775798
1905: EXCEPTION

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

1906: WHEN OTHERS THEN
1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1908: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.update_locations', l_module_name);
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1912: ELSE
1913: WSH_UTIL_CORE.printmsg('Unexpected error in Update_Locations');
1914: WSH_UTIL_CORE.printmsg(SQLERRM);

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

1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1908: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.update_locations', l_module_name);
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1912: ELSE
1913: WSH_UTIL_CORE.printmsg('Unexpected error in Update_Locations');
1914: WSH_UTIL_CORE.printmsg(SQLERRM);
1915: END IF;

Line 2006: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2002: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2003: --
2004: IF l_debug_on IS NULL
2005: THEN
2006: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2007: END IF;
2008: --
2009: --
2010: -- Debug Statements

Line 2013: WSH_DEBUG_SV.push(l_module_name);

2009: --
2010: -- Debug Statements
2011: --
2012: IF l_debug_on THEN
2013: WSH_DEBUG_SV.push(l_module_name);
2014: --
2015: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
2016: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
2017: END IF;

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

2011: --
2012: IF l_debug_on THEN
2013: WSH_DEBUG_SV.push(l_module_name);
2014: --
2015: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
2016: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
2017: END IF;
2018: --
2019: -- Found out that this API is getting called multiple times for the same location_id

Line 2016: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);

2012: IF l_debug_on THEN
2013: WSH_DEBUG_SV.push(l_module_name);
2014: --
2015: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
2016: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
2017: END IF;
2018: --
2019: -- Found out that this API is getting called multiple times for the same location_id
2020: IF l_debug_on THEN

Line 2021: WSH_DEBUG_SV.logmsg(l_module_name,' getting owner for location '||p_location_id);

2017: END IF;
2018: --
2019: -- Found out that this API is getting called multiple times for the same location_id
2020: IF l_debug_on THEN
2021: WSH_DEBUG_SV.logmsg(l_module_name,' getting owner for location '||p_location_id);
2022: END IF;
2023:
2024: /*
2025: OPEN get_location_info(p_location_id);

Line 2060: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record does not exist for location '||p_location_id|| ' and organization id '||l_organization_id);

2056:
2057: IF (l_dup_pk = -1) THEN
2058: -- Duplicate row does not exist.
2059: IF l_debug_on THEN
2060: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record does not exist for location '||p_location_id|| ' and organization id '||l_organization_id);
2061: END IF;
2062:
2063: cnt := cnt + 1;
2064: pLocLocationIdTbl(cnt) := p_location_id;

Line 2071: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record exists for location '||p_location_id|| ' and organization id '||l_organization_id);

2067:
2068: ELSE
2069: -- duplicate row exists
2070: IF l_debug_on THEN
2071: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record exists for location '||p_location_id|| ' and organization id '||l_organization_id);
2072: END IF;
2073: END IF;
2074: END IF;
2075:

Line 2094: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record does not exist for location '||p_location_id|| ' and organization id -1 ');

2090:
2091: IF (l_dup_pk = -1) THEN
2092: -- Duplicate row does not exist.
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record does not exist for location '||p_location_id|| ' and organization id -1 ');
2095: END IF;
2096:
2097: cnt := cnt + 1;
2098: pLocLocationIdTbl(cnt) := p_location_id;

Line 2105: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record exists for location '||p_location_id|| ' and organization id -1 ');

2101:
2102: ELSE
2103: -- duplicate row exists
2104: IF l_debug_on THEN
2105: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record exists for location '||p_location_id|| ' and organization id -1 ');
2106: END IF;
2107: END IF;
2108: END IF;
2109:

Line 2139: WSH_DEBUG_SV.log(l_module_name,'l_owner_type after check_party_carrier_supplier : ',l_owner_type);

2135: -- Otherwise, value of l_owner_type will not change
2136:
2137: --
2138: IF l_debug_on THEN
2139: WSH_DEBUG_SV.log(l_module_name,'l_owner_type after check_party_carrier_supplier : ',l_owner_type);
2140: END IF;
2141: --
2142:
2143: IF (l_owner_type IS NULL) THEN

Line 2161: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record does not exist for location '||p_location_id|| ' and party id '||parties.party_id||' and owner type '||l_owner_type );

2157:
2158: IF (l_dup_pk = -1) THEN
2159: -- Duplicate row does not exist.
2160: IF l_debug_on THEN
2161: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record does not exist for location '||p_location_id|| ' and party id '||parties.party_id||' and owner type '||l_owner_type );
2162: END IF;
2163:
2164: cnt := cnt + 1;
2165: pLocLocationIdTbl(cnt) := p_location_id;

Line 2172: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record exists for location '||p_location_id|| ' and party id '||parties.party_id||' and owner type '||l_owner_type );

2168:
2169: ELSE
2170: -- duplicate row exists
2171: IF l_debug_on THEN
2172: WSH_DEBUG_SV.logmsg(l_module_name,' location owner record exists for location '||p_location_id|| ' and party id '||parties.party_id||' and owner type '||l_owner_type );
2173: END IF;
2174: END IF;
2175: END IF;
2176:

Line 2187: WSH_DEBUG_SV.pop(l_module_name);

2183: --
2184: -- Debug Statements
2185: --
2186: IF l_debug_on THEN
2187: WSH_DEBUG_SV.pop(l_module_name);
2188: END IF;
2189: --
2190: END get_location_owner;
2191:

Line 2216: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2212: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2213: --
2214: IF l_debug_on IS NULL
2215: THEN
2216: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2217: END IF;
2218: --
2219: --
2220: -- Debug Statements

Line 2223: WSH_DEBUG_SV.push(l_module_name);

2219: --
2220: -- Debug Statements
2221: --
2222: IF l_debug_on THEN
2223: WSH_DEBUG_SV.push(l_module_name);
2224: --
2225: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
2226: END IF;
2227: --

Line 2225: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);

2221: --
2222: IF l_debug_on THEN
2223: WSH_DEBUG_SV.push(l_module_name);
2224: --
2225: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_SOURCE_CODE',P_LOCATION_SOURCE_CODE);
2226: END IF;
2227: --
2228: pLocLocationIdTbl.delete;
2229: pLocOwnerIdTbl.delete;

Line 2232: WSH_DEBUG_SV.logmsg(l_module_name,' Number of locations being processed '||pLocationIdTbl.count);

2228: pLocLocationIdTbl.delete;
2229: pLocOwnerIdTbl.delete;
2230: pLocOwnerTypeTbl.delete;
2231: IF l_debug_on THEN
2232: WSH_DEBUG_SV.logmsg(l_module_name,' Number of locations being processed '||pLocationIdTbl.count);
2233: END IF;
2234: FOR cnt IN 1..pLocationIdTbl.count LOOP
2235: get_location_owner(pLocationIdTbl(cnt),p_location_source_code);
2236: END LOOP;

Line 2238: WSH_DEBUG_SV.logmsg(l_module_name,' Inserting owner table count '||pLocLocationIdTbl.count);

2234: FOR cnt IN 1..pLocationIdTbl.count LOOP
2235: get_location_owner(pLocationIdTbl(cnt),p_location_source_code);
2236: END LOOP;
2237: IF l_debug_on THEN
2238: WSH_DEBUG_SV.logmsg(l_module_name,' Inserting owner table count '||pLocLocationIdTbl.count);
2239: END IF;
2240: IF (pLocLocationIdTbl.count > 0) THEN
2241:
2242: BEGIN

Line 2277: WSH_DEBUG_SV.logmsg(l_module_name,'Duplicate owner_party_id found for location_id '||l_loc_id);

2273: --ORA:00001 is the unique constraint violation. We are attempting
2274: --to insert a facility that already exists.
2275: IF ( l_error_code = -1 ) THEN
2276: IF l_debug_on THEN
2277: WSH_DEBUG_SV.logmsg(l_module_name,'Duplicate owner_party_id found for location_id '||l_loc_id);
2278: END IF;
2279: l_start := l_start + sql%rowcount + 1;
2280: ELSE
2281: IF l_debug_on THEN

Line 2282: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE CREATING LOCATION OWNER FOR LOCATION '||l_loc_id);

2278: END IF;
2279: l_start := l_start + sql%rowcount + 1;
2280: ELSE
2281: IF l_debug_on THEN
2282: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE CREATING LOCATION OWNER FOR LOCATION '||l_loc_id);
2283: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);
2284: END IF;
2285: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2286: RETURN;

Line 2283: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);

2279: l_start := l_start + sql%rowcount + 1;
2280: ELSE
2281: IF l_debug_on THEN
2282: WSH_DEBUG_SV.logmsg(l_module_name,'UNEXPECTED ERROR WHILE CREATING LOCATION OWNER FOR LOCATION '||l_loc_id);
2283: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR MESSAGE '||SQLERRM);
2284: END IF;
2285: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2286: RETURN;
2287: END IF;

Line 2297: WSH_DEBUG_SV.pop(l_module_name);

2293: --
2294: -- Debug Statements
2295: --
2296: IF l_debug_on THEN
2297: WSH_DEBUG_SV.pop(l_module_name);
2298: END IF;
2299: --
2300: END insert_location_owners;
2301:

Line 2335: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2331: l_debug_on BOOLEAN;
2332: BEGIN
2333: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2334: IF l_debug_on IS NULL THEN
2335: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2336: END IF;
2337:
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.push(l_module_name);

Line 2339: WSH_DEBUG_SV.push(l_module_name);

2335: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2336: END IF;
2337:
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.push(l_module_name);
2340: END IF;
2341:
2342: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2343:

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

2348: NULL, -- SDO_ELEM_INFO: Not needed if point_type
2349: NULL); -- SDO_ORDINATES: Not needed if point_type
2350:
2351: IF l_debug_on THEN
2352: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status is : '||x_return_status);
2353: WSH_DEBUG_SV.pop(l_module_name);
2354: END IF;
2355:
2356: EXCEPTION

Line 2353: WSH_DEBUG_SV.pop(l_module_name);

2349: NULL); -- SDO_ORDINATES: Not needed if point_type
2350:
2351: IF l_debug_on THEN
2352: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status is : '||x_return_status);
2353: WSH_DEBUG_SV.pop(l_module_name);
2354: END IF;
2355:
2356: EXCEPTION
2357: WHEN OTHERS THEN

Line 2360: WSH_DEBUG_SV.LogMsg(l_module_name, x_error_msg);

2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: x_error_msg := 'ERROR: During Geometry Creation ' || sqlerrm;
2359: IF l_debug_on THEN
2360: WSH_DEBUG_SV.LogMsg(l_module_name, x_error_msg);
2361: WSH_DEBUG_SV.pop(l_module_name);
2362: END IF;
2363: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2364:

Line 2361: WSH_DEBUG_SV.pop(l_module_name);

2357: WHEN OTHERS THEN
2358: x_error_msg := 'ERROR: During Geometry Creation ' || sqlerrm;
2359: IF l_debug_on THEN
2360: WSH_DEBUG_SV.LogMsg(l_module_name, x_error_msg);
2361: WSH_DEBUG_SV.pop(l_module_name);
2362: END IF;
2363: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2364:
2365: END Create_Geometry;

Line 2421: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2417: BEGIN
2418: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2419: --
2420: IF l_debug_on IS NULL THEN
2421: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2422: END IF;
2423:
2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.push(l_module_name);

Line 2425: WSH_DEBUG_SV.push(l_module_name);

2421: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2422: END IF;
2423:
2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.push(l_module_name);
2426: END IF;
2427: --
2428: --
2429: l_cache_rec.input_param1 := to_char(p_internal_cust_location_id)||'-'||to_char(p_customer_id);

Line 2466: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

2462:
2463: --
2464: --
2465: IF l_debug_on THEN
2466: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
2467: WSH_DEBUG_SV.pop(l_module_name);
2468: END IF;
2469:
2470: EXCEPTION

Line 2467: WSH_DEBUG_SV.pop(l_module_name);

2463: --
2464: --
2465: IF l_debug_on THEN
2466: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
2467: WSH_DEBUG_SV.pop(l_module_name);
2468: END IF;
2469:
2470: EXCEPTION
2471: WHEN OTHERS THEN

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

2477: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',
2478: l_module_name);
2479:
2480: IF l_debug_on THEN
2481: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2482: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2483: END IF;
2484:
2485: END convert_internal_cust_location;

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

2478: l_module_name);
2479:
2480: IF l_debug_on THEN
2481: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2482: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2483: END IF;
2484:
2485: END convert_internal_cust_location;
2486:

Line 2516: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2512: BEGIN
2513: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2514: --
2515: IF l_debug_on IS NULL THEN
2516: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2517: END IF;
2518:
2519: IF l_debug_on THEN
2520: WSH_DEBUG_SV.push(l_module_name);

Line 2520: WSH_DEBUG_SV.push(l_module_name);

2516: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2517: END IF;
2518:
2519: IF l_debug_on THEN
2520: WSH_DEBUG_SV.push(l_module_name);
2521: END IF;
2522: --
2523: --
2524:

Line 2539: WSH_DEBUG_SV.log(l_module_name, 'returning', l_internal_org_location_id);

2535:
2536: --
2537: --
2538: IF l_debug_on THEN
2539: WSH_DEBUG_SV.log(l_module_name, 'returning', l_internal_org_location_id);
2540: WSH_DEBUG_SV.pop(l_module_name);
2541: END IF;
2542:
2543: RETURN l_internal_org_location_id;

Line 2540: WSH_DEBUG_SV.pop(l_module_name);

2536: --
2537: --
2538: IF l_debug_on THEN
2539: WSH_DEBUG_SV.log(l_module_name, 'returning', l_internal_org_location_id);
2540: WSH_DEBUG_SV.pop(l_module_name);
2541: END IF;
2542:
2543: RETURN l_internal_org_location_id;
2544:

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

2547: WSH_UTIL_CORE.DEFAULT_HANDLER(
2548: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',
2549: l_module_name);
2550: IF l_debug_on THEN
2551: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2553: END IF;
2554: RETURN NULL;
2555:

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

2548: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',
2549: l_module_name);
2550: IF l_debug_on THEN
2551: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2553: END IF;
2554: RETURN NULL;
2555:
2556: END convert_internal_cust_location;