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_DEBUG_SV

Line 31: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

27: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
28: --
29: IF l_debug_on IS NULL
30: THEN
31: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
32: END IF;
33: --
34: IF l_debug_on THEN
35: WSH_DEBUG_SV.push(l_module_name);

Line 35: WSH_DEBUG_SV.push(l_module_name);

31: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
32: END IF;
33: --
34: IF l_debug_on THEN
35: WSH_DEBUG_SV.push(l_module_name);
36: WSH_DEBUG_SV.log(l_module_name, 'folder id', p_folder_ext_rec.folder_id);
37: WSH_DEBUG_SV.log(l_module_name, 'folder extension id', p_folder_ext_rec.folder_extension_id);
38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);
39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);

Line 36: WSH_DEBUG_SV.log(l_module_name, 'folder id', p_folder_ext_rec.folder_id);

32: END IF;
33: --
34: IF l_debug_on THEN
35: WSH_DEBUG_SV.push(l_module_name);
36: WSH_DEBUG_SV.log(l_module_name, 'folder id', p_folder_ext_rec.folder_id);
37: WSH_DEBUG_SV.log(l_module_name, 'folder extension id', p_folder_ext_rec.folder_extension_id);
38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);
39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);
40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);

Line 37: WSH_DEBUG_SV.log(l_module_name, 'folder extension id', p_folder_ext_rec.folder_extension_id);

33: --
34: IF l_debug_on THEN
35: WSH_DEBUG_SV.push(l_module_name);
36: WSH_DEBUG_SV.log(l_module_name, 'folder id', p_folder_ext_rec.folder_id);
37: WSH_DEBUG_SV.log(l_module_name, 'folder extension id', p_folder_ext_rec.folder_extension_id);
38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);
39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);
40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);
41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);

Line 38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);

34: IF l_debug_on THEN
35: WSH_DEBUG_SV.push(l_module_name);
36: WSH_DEBUG_SV.log(l_module_name, 'folder id', p_folder_ext_rec.folder_id);
37: WSH_DEBUG_SV.log(l_module_name, 'folder extension id', p_folder_ext_rec.folder_extension_id);
38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);
39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);
40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);
41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);
42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);

Line 39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);

35: WSH_DEBUG_SV.push(l_module_name);
36: WSH_DEBUG_SV.log(l_module_name, 'folder id', p_folder_ext_rec.folder_id);
37: WSH_DEBUG_SV.log(l_module_name, 'folder extension id', p_folder_ext_rec.folder_extension_id);
38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);
39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);
40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);
41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);
42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);
43: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_SHIP_CONF_DIALOGUE',p_folder_ext_rec.display_ship_conf_dialogue);

Line 40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);

36: WSH_DEBUG_SV.log(l_module_name, 'folder id', p_folder_ext_rec.folder_id);
37: WSH_DEBUG_SV.log(l_module_name, 'folder extension id', p_folder_ext_rec.folder_extension_id);
38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);
39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);
40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);
41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);
42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);
43: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_SHIP_CONF_DIALOGUE',p_folder_ext_rec.display_ship_conf_dialogue);
44: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_INFO',p_folder_ext_rec.display_trip_info);

Line 41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);

37: WSH_DEBUG_SV.log(l_module_name, 'folder extension id', p_folder_ext_rec.folder_extension_id);
38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);
39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);
40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);
41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);
42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);
43: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_SHIP_CONF_DIALOGUE',p_folder_ext_rec.display_ship_conf_dialogue);
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);

Line 42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);

38: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_DLVY_OTHERS', p_folder_ext_rec.DISPLAY_DLVY_OTHERS);
39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);
40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);
41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);
42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);
43: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_SHIP_CONF_DIALOGUE',p_folder_ext_rec.display_ship_conf_dialogue);
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;

Line 43: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_SHIP_CONF_DIALOGUE',p_folder_ext_rec.display_ship_conf_dialogue);

39: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_LINE_OTHERS',p_folder_ext_rec.display_line_others);
40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);
41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);
42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);
43: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_SHIP_CONF_DIALOGUE',p_folder_ext_rec.display_ship_conf_dialogue);
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: --

Line 44: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_INFO',p_folder_ext_rec.display_trip_info);

40: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_TRIP_OTHERS',p_folder_ext_rec.display_trip_others);
41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);
42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);
43: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_SHIP_CONF_DIALOGUE',p_folder_ext_rec.display_ship_conf_dialogue);
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;

Line 45: WSH_DEBUG_SV.log(l_module_name, 'Userid', p_folder_ext_rec.user_id);

41: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_STOP_OTHERS',p_folder_ext_rec.display_stop_others);
42: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_QM_LINE_OTHERS',p_folder_ext_rec.display_qm_line_others);
43: WSH_DEBUG_SV.log(l_module_name, 'DISPLAY_SHIP_CONF_DIALOGUE',p_folder_ext_rec.display_ship_conf_dialogue);
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:

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

131:
132: COMMIT;
133:
134: IF l_debug_on THEN
135: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
136: WSH_DEBUG_SV.pop(l_module_name);
137: END IF;
138:
139: EXCEPTION

Line 136: WSH_DEBUG_SV.pop(l_module_name);

132: COMMIT;
133:
134: IF l_debug_on THEN
135: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
136: WSH_DEBUG_SV.pop(l_module_name);
137: END IF;
138:
139: EXCEPTION
140:

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

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');
148: END IF;
149: --
150:

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

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');
148: END IF;
149: --
150:
151: END Insert_Update_Folder_Ext;

Line 171: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

167: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
168: --
169: IF l_debug_on IS NULL
170: THEN
171: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
172: END IF;
173: --
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.push(l_module_name);

Line 175: WSH_DEBUG_SV.push(l_module_name);

171: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
172: END IF;
173: --
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.push(l_module_name);
176: WSH_DEBUG_SV.log(l_module_name,'p_folder_id',p_folder_id);
177: --
178: END IF;
179: --

Line 176: WSH_DEBUG_SV.log(l_module_name,'p_folder_id',p_folder_id);

172: END IF;
173: --
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.push(l_module_name);
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;

Line 196: WSH_DEBUG_SV.log(l_module_name,'Flag',l_flag);

192: ELSE
193: l_flag := 'Y';
194: END IF;
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.log(l_module_name,'Flag',l_flag);
197: END IF;
198:
199: IF l_flag = 'N' THEN
200:

Line 205: WSH_DEBUG_SV.log(l_module_name,'Folders Deleted-',sql%rowcount);

201: DELETE FROM wsh_folder_extensions
202: WHERE folder_id = p_folder_id;
203:
204: IF l_debug_on THEN
205: WSH_DEBUG_SV.log(l_module_name,'Folders Deleted-',sql%rowcount);
206: END IF;
207:
208: COMMIT;
209: ELSE

Line 211: WSH_DEBUG_SV.logmsg(l_module_name,'No Folders Deleted');

207:
208: COMMIT;
209: ELSE
210: IF l_debug_on THEN
211: WSH_DEBUG_SV.logmsg(l_module_name,'No Folders Deleted');
212: END IF;
213:
214: END IF;
215:

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

213:
214: END IF;
215:
216: IF l_debug_on THEN
217: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
218: WSH_DEBUG_SV.pop(l_module_name);
219: END IF;
220: --
221: EXCEPTION

Line 218: WSH_DEBUG_SV.pop(l_module_name);

214: END IF;
215:
216: IF l_debug_on THEN
217: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
218: WSH_DEBUG_SV.pop(l_module_name);
219: END IF;
220: --
221: EXCEPTION
222:

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

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');
230: END IF;
231: --
232:

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

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');
230: END IF;
231: --
232:
233: END Delete_Folder_Ext;

Line 270: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

266: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
267: --
268: IF l_debug_on IS NULL
269: THEN
270: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
271: END IF;
272: --
273: IF l_debug_on THEN
274: WSH_DEBUG_SV.push(l_module_name);

Line 274: WSH_DEBUG_SV.push(l_module_name);

270: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
271: END IF;
272: --
273: IF l_debug_on THEN
274: WSH_DEBUG_SV.push(l_module_name);
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

Line 275: WSH_DEBUG_SV.log(l_module_name,'COUNT of records', p_folder_cust_tab.count);

271: END IF;
272: --
273: IF l_debug_on THEN
274: WSH_DEBUG_SV.push(l_module_name);
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;

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

349:
350: COMMIT;
351:
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
354: WSH_DEBUG_SV.pop(l_module_name);
355: END IF;
356:
357: EXCEPTION

Line 354: WSH_DEBUG_SV.pop(l_module_name);

350: COMMIT;
351:
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
354: WSH_DEBUG_SV.pop(l_module_name);
355: END IF;
356:
357: EXCEPTION
358:

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

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');
366: END IF;
367: --
368:

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

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');
366: END IF;
367: --
368:
369: END Insert_Update_Folder_Custom;

Line 391: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

387: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
388: --
389: IF l_debug_on IS NULL
390: THEN
391: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
392: END IF;
393: --
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.push(l_module_name);

Line 395: WSH_DEBUG_SV.push(l_module_name);

391: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
392: END IF;
393: --
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.push(l_module_name);
396: WSH_DEBUG_SV.log(l_module_name,'p_folder_id',p_folder_id);
397: --
398: END IF;
399: --

Line 396: WSH_DEBUG_SV.log(l_module_name,'p_folder_id',p_folder_id);

392: END IF;
393: --
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.push(l_module_name);
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;

Line 407: WSH_DEBUG_SV.logmsg(l_module_name,'No custom action for Folder Deleted');

403: WHERE folder_id = p_folder_id;
404:
405: IF sql%NOTFOUND THEN
406: IF l_debug_on THEN
407: WSH_DEBUG_SV.logmsg(l_module_name,'No custom action for Folder Deleted');
408: END IF;
409: END IF;
410:
411: IF l_debug_on THEN

Line 412: WSH_DEBUG_SV.log(l_module_name,'Folders Deleted-',sql%rowcount);

408: END IF;
409: END IF;
410:
411: IF l_debug_on THEN
412: WSH_DEBUG_SV.log(l_module_name,'Folders Deleted-',sql%rowcount);
413: END IF;
414:
415: COMMIT;
416:

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

414:
415: COMMIT;
416:
417: IF l_debug_on THEN
418: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
419: WSH_DEBUG_SV.pop(l_module_name);
420: END IF;
421: --
422: EXCEPTION

Line 419: WSH_DEBUG_SV.pop(l_module_name);

415: COMMIT;
416:
417: IF l_debug_on THEN
418: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
419: WSH_DEBUG_SV.pop(l_module_name);
420: END IF;
421: --
422: EXCEPTION
423:

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

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');
431: END IF;
432: --
433:

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

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');
431: END IF;
432: --
433:
434: END Delete_Folder_Custom;