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

Line 173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

169:
170: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
171: IF l_debug_on IS NULL
172: THEN
173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
174: END IF;
175: IF l_debug_on THEN
176: WSH_DEBUG_SV.push(l_module_name);
177: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);

Line 176: WSH_DEBUG_SV.push(l_module_name);

172: THEN
173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
174: END IF;
175: IF l_debug_on THEN
176: WSH_DEBUG_SV.push(l_module_name);
177: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
178: END IF;
179: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
180:

Line 177: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);

173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
174: END IF;
175: IF l_debug_on THEN
176: WSH_DEBUG_SV.push(l_module_name);
177: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
178: END IF;
179: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
180:
181: OPEN cur_delivery;

Line 210: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED',l_count);

206: AND INVENTORY_ITEM_ID = msik.inventory_item_id
207: AND UPPER(CROSS_REFERENCE) ='NO')
208: AND msik.inventory_item_id = v_cur_item.item_id;
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED',l_count);
211: END IF;
212: EXCEPTION
213: WHEN NO_DATA_FOUND THEN
214: l_count:=0;

Line 216: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

212: EXCEPTION
213: WHEN NO_DATA_FOUND THEN
214: l_count:=0;
215: IF l_debug_on THEN
216: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
217: END IF;
218: END;
219: IF l_count > 0 THEN
220: IF NOT del_count.EXISTS(TO_CHAR(v_cur_item.destination_cont_id)

Line 309: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED',l_count);

305: AND INVENTORY_ITEM_ID = msik.inventory_item_id
306: AND UPPER(CROSS_REFERENCE) ='NO')
307: AND msik.inventory_item_id = v_cur_item.item_id;
308: IF l_debug_on THEN
309: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED',l_count);
310: END IF;
311: IF l_count > 0 THEN
312: --To get Item Information into the object type
313: v_items:= wsh_opsm_asn_items_rec ( v_cur_item.delivery_id ,

Line 1007: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1003: l_count:=0;
1004: << rslt_par_tab_no_data >>
1005: l_count:=0;
1006: IF l_debug_on THEN
1007: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1008: END IF;
1009: EXCEPTION
1010: WHEN NO_DATA_FOUND THEN
1011: l_count:=0;

Line 1013: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1009: EXCEPTION
1010: WHEN NO_DATA_FOUND THEN
1011: l_count:=0;
1012: IF l_debug_on THEN
1013: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1014: END IF;
1015: WHEN OTHERS THEN
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1013: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1014: END IF;
1015: WHEN OTHERS THEN
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1018: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
1019: END IF;
1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1021: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);

Line 1018: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');

1014: END IF;
1015: WHEN OTHERS THEN
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1018: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
1019: END IF;
1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1021: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
1022: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';

Line 1033: WSH_DEBUG_SV.pop(l_module_name);

1029: p_out_items :=v_items_tab;
1030: p_out_itemdetails :=v_itemdetails_tab;
1031: p_out_itemgenealogy :=v_itemgenealogy_tab;
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.pop(l_module_name);
1034: END IF;
1035: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1036: DECLARE
1037: --l_end_time DATE;

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

1065: --dbms_output.put_line('time difference= '||l_time_diff_secs);
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: IF l_debug_on THEN
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1070: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
1071: END IF;
1072: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1073: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);

Line 1070: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');

1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: IF l_debug_on THEN
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1070: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
1071: END IF;
1072: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1073: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
1074: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';

Line 1240: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1236:
1237: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1238: IF l_debug_on IS NULL
1239: THEN
1240: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1241: END IF;
1242: IF l_debug_on THEN
1243: WSH_DEBUG_SV.push(l_module_name);
1244: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);

Line 1243: WSH_DEBUG_SV.push(l_module_name);

1239: THEN
1240: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1241: END IF;
1242: IF l_debug_on THEN
1243: WSH_DEBUG_SV.push(l_module_name);
1244: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
1245: END IF;
1246: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1247:

Line 1244: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);

1240: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1241: END IF;
1242: IF l_debug_on THEN
1243: WSH_DEBUG_SV.push(l_module_name);
1244: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
1245: END IF;
1246: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1247:
1248: OPEN cur_delivery;

Line 1277: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED',l_count);

1273: AND INVENTORY_ITEM_ID = msik.inventory_item_id
1274: AND UPPER(CROSS_REFERENCE) ='NO')
1275: AND msik.inventory_item_id = v_cur_item.item_id;
1276: IF l_debug_on THEN
1277: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED',l_count);
1278: END IF;
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: l_count:=0;

Line 1283: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: l_count:=0;
1282: IF l_debug_on THEN
1283: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1284: END IF;
1285: END;
1286: IF l_count > 0 THEN
1287: IF NOT del_count.EXISTS(TO_CHAR(v_cur_item.destination_cont_id)

Line 1374: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED',l_count);

1370: AND INVENTORY_ITEM_ID = msik.inventory_item_id
1371: AND UPPER(CROSS_REFERENCE) ='NO')
1372: AND msik.inventory_item_id = v_cur_item.item_id;
1373: IF l_debug_on THEN
1374: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED',l_count);
1375: END IF;
1376: IF l_count > 0 THEN
1377: --To get Item Information into the object type
1378: v_items:= wsh_opsm_asn_items_rec ( v_cur_item.delivery_id ,

Line 2070: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2066: l_count:=0;
2067: << rslt_par_tab_no_data >>
2068: l_count:=0;
2069: IF l_debug_on THEN
2070: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2071: END IF;
2072: EXCEPTION
2073: WHEN NO_DATA_FOUND THEN
2074: l_count:=0;

Line 2076: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2072: EXCEPTION
2073: WHEN NO_DATA_FOUND THEN
2074: l_count:=0;
2075: IF l_debug_on THEN
2076: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2077: END IF;
2078: WHEN OTHERS THEN
2079: IF l_debug_on THEN
2080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2076: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2077: END IF;
2078: WHEN OTHERS THEN
2079: IF l_debug_on THEN
2080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2081: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2082: END IF;
2083: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2084: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);

Line 2081: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');

2077: END IF;
2078: WHEN OTHERS THEN
2079: IF l_debug_on THEN
2080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2081: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2082: END IF;
2083: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2084: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
2085: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';

Line 2096: WSH_DEBUG_SV.pop(l_module_name);

2092: p_out_items :=v_items_tab;
2093: p_out_itemdetails :=v_itemdetails_tab;
2094: p_out_itemgenealogy :=v_itemgenealogy_tab;
2095: IF l_debug_on THEN
2096: WSH_DEBUG_SV.pop(l_module_name);
2097: END IF;
2098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2099: DECLARE
2100: --l_end_time DATE;

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

2128: --dbms_output.put_line('time difference= '||l_time_diff_secs);
2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: IF l_debug_on THEN
2132: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2133: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2134: END IF;
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2136: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);

Line 2133: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');

2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: IF l_debug_on THEN
2132: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2133: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2134: END IF;
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2136: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
2137: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';

Line 2174: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2170: BEGIN
2171: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2172: IF l_debug_on IS NULL
2173: THEN
2174: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2175: END IF;
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.push(l_module_name);
2178: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);

Line 2177: WSH_DEBUG_SV.push(l_module_name);

2173: THEN
2174: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2175: END IF;
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.push(l_module_name);
2178: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
2179: END IF;
2180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2181: FOR v_opsm_items IN c_opsm_items LOOP

Line 2178: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);

2174: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2175: END IF;
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.push(l_module_name);
2178: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
2179: END IF;
2180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2181: FOR v_opsm_items IN c_opsm_items LOOP
2182: --To check wheather Item is OPSM Integrated or not

Line 2206: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED SINLGE',l_count);

2202: AND UPPER(CROSS_REFERENCE) ='NO')
2203: AND msik.inventory_item_id = v_opsm_items.item_id;
2204: l_count1:=l_count1+l_count;
2205: IF l_debug_on THEN
2206: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED SINLGE',l_count);
2207: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED COUNT',l_count1);
2208: END IF;
2209: IF l_count1 > 0 THEN
2210: EXIT;

Line 2207: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED COUNT',l_count1);

2203: AND msik.inventory_item_id = v_opsm_items.item_id;
2204: l_count1:=l_count1+l_count;
2205: IF l_debug_on THEN
2206: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED SINLGE',l_count);
2207: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED COUNT',l_count1);
2208: END IF;
2209: IF l_count1 > 0 THEN
2210: EXIT;
2211: END IF;

Line 2217: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2213: WHEN NO_DATA_FOUND THEN
2214: l_count:=0;
2215: p_opsmexist:='N';
2216: IF l_debug_on THEN
2217: WSH_DEBUG_SV.logmsg(l_module_name,'No Data Found error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2218: END IF;
2219: END;
2220: END LOOP;
2221: IF l_count1 > 0 THEN

Line 2224: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);

2220: END LOOP;
2221: IF l_count1 > 0 THEN
2222: p_opsmexist:='Y';
2223: IF l_debug_on THEN
2224: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);
2225: END IF;
2226: ELSE
2227: p_opsmexist:='N';
2228: IF l_debug_on THEN

Line 2229: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);

2225: END IF;
2226: ELSE
2227: p_opsmexist:='N';
2228: IF l_debug_on THEN
2229: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);
2230: END IF;
2231: END IF;
2232: x_msg_data := l_msg_data;
2233: IF l_debug_on THEN

Line 2234: WSH_DEBUG_SV.pop(l_module_name);

2230: END IF;
2231: END IF;
2232: x_msg_data := l_msg_data;
2233: IF l_debug_on THEN
2234: WSH_DEBUG_SV.pop(l_module_name);
2235: END IF;
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: l_count:=0;

Line 2241: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);

2237: WHEN OTHERS THEN
2238: l_count:=0;
2239: p_opsmexist:='N';
2240: IF l_debug_on THEN
2241: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);
2242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2244: END IF;
2245: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

2238: l_count:=0;
2239: p_opsmexist:='N';
2240: IF l_debug_on THEN
2241: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);
2242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2244: END IF;
2245: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2246: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.SUBMIT_REQUEST',l_module_name);

Line 2243: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');

2239: p_opsmexist:='N';
2240: IF l_debug_on THEN
2241: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);
2242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2244: END IF;
2245: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2246: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.SUBMIT_REQUEST',l_module_name);
2247: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.SUBMIT_REQUEST';