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

Line 220: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

216: FOR UPDATE OF SHIP_CONFIRM_RULE_ID NOWAIT;
217:
218: recinfo C_Lock_Row%ROWTYPE;
219: --
220: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
221: --
222: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LOCK_ROW';
223: --
224:

Line 230: WSH_DEBUG_SV.push(l_module_name);

226: BEGIN
227:
228: --
229: IF l_debug_on THEN
230: WSH_DEBUG_SV.push(l_module_name);
231: --
232: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
233: END IF;
234: --

Line 232: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

228: --
229: IF l_debug_on THEN
230: WSH_DEBUG_SV.push(l_module_name);
231: --
232: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
233: END IF;
234: --
235:
236: OPEN C_Lock_Row;

Line 243: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');

239: CLOSE C_Lock_Row;
240: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
241: IF l_debug_on THEN
242:
243: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
244:
245: END IF;
246: app_exception.raise_exception;
247: END IF;

Line 319: WSH_DEBUG_SV.log(l_module_name,'Nothing has changed');

315: (( p_ship_confirm_rule_info.LAST_UPDATE_DATE IS NULL) and
316: ( recinfo.LAST_UPDATE_DATE IS NULL)))*/ THEN
317: --
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.log(l_module_name,'Nothing has changed');
320: WSH_DEBUG_SV.pop(l_module_name);
321: END IF;
322: --
323: RETURN;

Line 320: WSH_DEBUG_SV.pop(l_module_name);

316: ( recinfo.LAST_UPDATE_DATE IS NULL)))*/ THEN
317: --
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.log(l_module_name,'Nothing has changed');
320: WSH_DEBUG_SV.pop(l_module_name);
321: END IF;
322: --
323: RETURN;
324: ELSE

Line 330: WSH_DEBUG_SV.pop(l_module_name);

326: app_exception.raise_exception;
327: END IF;
328: --
329: IF l_debug_on THEN
330: WSH_DEBUG_SV.pop(l_module_name);
331: END IF;
332: --
333: EXCEPTION
334: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN

Line 343: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

339:
340:
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
345: END IF;
346: --
347: RAISE;

Line 344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');

340:
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
345: END IF;
346: --
347: RAISE;
348:

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: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
361:
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: RAISE;

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

361:
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: RAISE;
369:

Line 372: WSH_DEBUG_SV.pop(l_module_name);

368: RAISE;
369:
370: --
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.pop(l_module_name);
373: END IF;
374: --
375: END Lock_Row;
376:

Line 385: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

381: PROCEDURE Delete_Row(
382: p_rowid IN VARCHAR2,
383: x_return_status OUT NOCOPY VARCHAR2) IS
384: --
385: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
386: --
387: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '. ' || 'DELETE_ROW';
388: --
389: BEGIN

Line 395: WSH_DEBUG_SV.push(l_module_name);

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

Line 397: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

393: --
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.push(l_module_name);
396: --
397: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
398: END IF;
399: --
400: DELETE FROM WSH_SHIP_CONFIRM_RULES
401: WHERE rowid = p_rowid;

Line 411: WSH_DEBUG_SV.pop(l_module_name);

407: --
408: -- Debug Statements
409: --
410: IF l_debug_on THEN
411: WSH_DEBUG_SV.pop(l_module_name);
412: END IF;
413: --
414: --
415: EXCEPTION

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

420: --
421: -- Debug Statements
422: --
423: IF l_debug_on THEN
424: 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_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
426: END IF;
427: --
428: END Delete_Row;

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

421: -- Debug Statements
422: --
423: IF l_debug_on THEN
424: 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_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
426: END IF;
427: --
428: END Delete_Row;
429: