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 2009: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2005: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2006: --
2007: IF l_debug_on IS NULL
2008: THEN
2009: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2010: END IF;
2011: --
2012: --
2013: -- Debug Statements

Line 2016: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2164: 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 );

2160:
2161: IF (l_dup_pk = -1) THEN
2162: -- Duplicate row does not exist.
2163: IF l_debug_on THEN
2164: 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 );
2165: END IF;
2166:
2167: cnt := cnt + 1;
2168: pLocLocationIdTbl(cnt) := p_location_id;

Line 2175: 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 );

2171:
2172: ELSE
2173: -- duplicate row exists
2174: IF l_debug_on THEN
2175: 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 );
2176: END IF;
2177: END IF;
2178: END IF;
2179:

Line 2190: WSH_DEBUG_SV.pop(l_module_name);

2186: --
2187: -- Debug Statements
2188: --
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.pop(l_module_name);
2191: END IF;
2192: --
2193: END get_location_owner;
2194:

Line 2219: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2215: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2216: --
2217: IF l_debug_on IS NULL
2218: THEN
2219: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2220: END IF;
2221: --
2222: --
2223: -- Debug Statements

Line 2226: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2300: WSH_DEBUG_SV.pop(l_module_name);

2296: --
2297: -- Debug Statements
2298: --
2299: IF l_debug_on THEN
2300: WSH_DEBUG_SV.pop(l_module_name);
2301: END IF;
2302: --
2303: END insert_location_owners;
2304:

Line 2338: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2342: WSH_DEBUG_SV.push(l_module_name);

2338: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2339: END IF;
2340:
2341: IF l_debug_on THEN
2342: WSH_DEBUG_SV.push(l_module_name);
2343: END IF;
2344:
2345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2346:

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

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

Line 2356: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 2364: WSH_DEBUG_SV.pop(l_module_name);

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

Line 2424: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2428: WSH_DEBUG_SV.push(l_module_name);

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

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

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

Line 2470: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

Line 2519: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2523: WSH_DEBUG_SV.push(l_module_name);

2519: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2520: END IF;
2521:
2522: IF l_debug_on THEN
2523: WSH_DEBUG_SV.push(l_module_name);
2524: END IF;
2525: --
2526: --
2527:

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

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

Line 2543: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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