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_FOLDER_EXTENSIONS_PVT dependencies on WSH_UTIL_CORE

Line 48: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

44: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_INFO',p_folder_ext_rec.display_trip_info);
45: WSH_DEBUG_SV.log(l_module_name, 'Userid', p_folder_ext_rec.user_id);
46: END IF;
47: --
48: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
49:
50: OPEN c_ext_rec_cur(p_folder_ext_rec.folder_id);
51: FETCH c_ext_rec_cur INTO l_folder_extension_id;
52:

Line 142: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_EXT',l_module_name);

138:
139: EXCEPTION
140:
141: WHEN others THEN
142: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_EXT',l_module_name);
143: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
144: --
145: IF l_debug_on THEN
146: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 143: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

139: EXCEPTION
140:
141: WHEN others THEN
142: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_EXT',l_module_name);
143: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
144: --
145: IF l_debug_on THEN
146: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
147: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

176: WSH_DEBUG_SV.log(l_module_name,'p_folder_id',p_folder_id);
177: --
178: END IF;
179: --
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
181:
182: -- Only if record has been deleted from fnd_folders, delete it
183: -- from WSH custom table
184:

Line 224: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_EXT',l_module_name);

220: --
221: EXCEPTION
222:
223: WHEN others THEN
224: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_EXT',l_module_name);
225: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
226: --
227: IF l_debug_on THEN
228: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 225: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

221: EXCEPTION
222:
223: WHEN others THEN
224: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_EXT',l_module_name);
225: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
226: --
227: IF l_debug_on THEN
228: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
229: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

275: WSH_DEBUG_SV.log(l_module_name,'COUNT of records', p_folder_cust_tab.count);
276: END IF;
277: --
278: -- Initialize the Local variables for return status
279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
280: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
281:
282: OPEN c_cust_rec_cur(p_folder_cust_tab(p_folder_cust_tab.FIRST).folder_id);
283: FETCH c_cust_rec_cur

Line 280: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

276: END IF;
277: --
278: -- Initialize the Local variables for return status
279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
280: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
281:
282: OPEN c_cust_rec_cur(p_folder_cust_tab(p_folder_cust_tab.FIRST).folder_id);
283: FETCH c_cust_rec_cur
284: INTO l_folder_id;

Line 307: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

303: DELETE FROM wsh_folder_custom_actions
304: WHERE folder_id = l_folder_id;
305: END IF;
306:
307: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
308: FOR i in 1..p_folder_cust_tab.count
309: LOOP
310: INSERT INTO wsh_folder_custom_actions
311: (ACTION_ID,

Line 360: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_CUSTOM',l_module_name);

356:
357: EXCEPTION
358:
359: WHEN others THEN
360: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_CUSTOM',l_module_name);
361: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
362: --
363: IF l_debug_on THEN
364: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 361: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

357: EXCEPTION
358:
359: WHEN others THEN
360: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_CUSTOM',l_module_name);
361: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
362: --
363: IF l_debug_on THEN
364: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
365: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 400: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

396: WSH_DEBUG_SV.log(l_module_name,'p_folder_id',p_folder_id);
397: --
398: END IF;
399: --
400: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
401:
402: DELETE FROM wsh_folder_custom_actions
403: WHERE folder_id = p_folder_id;
404:

Line 425: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_CUSTOM',l_module_name);

421: --
422: EXCEPTION
423:
424: WHEN others THEN
425: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_CUSTOM',l_module_name);
426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

422: EXCEPTION
423:
424: WHEN others THEN
425: wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_CUSTOM',l_module_name);
426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');