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

Line 81: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

77: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
78: --
79: IF l_debug_on IS NULL
80: THEN
81: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
82: END IF;
83: --
84: IF l_debug_on THEN
85: WSH_DEBUG_SV.push(l_module_name);

Line 85: WSH_DEBUG_SV.push(l_module_name);

81: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
82: END IF;
83: --
84: IF l_debug_on THEN
85: WSH_DEBUG_SV.push(l_module_name);
86: --
87: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
89: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);

Line 87: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);

83: --
84: IF l_debug_on THEN
85: WSH_DEBUG_SV.push(l_module_name);
86: --
87: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
89: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
90: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
91: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);

Line 88: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);

84: IF l_debug_on THEN
85: WSH_DEBUG_SV.push(l_module_name);
86: --
87: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
89: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
90: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
91: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
92: END IF;

Line 89: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);

85: WSH_DEBUG_SV.push(l_module_name);
86: --
87: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
89: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
90: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
91: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
92: END IF;
93: --

Line 90: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);

86: --
87: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
89: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
90: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
91: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
92: END IF;
93: --
94: open id_sequence;

Line 91: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);

87: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
89: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
90: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
91: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
92: END IF;
93: --
94: open id_sequence;
95: fetch id_sequence into X_query_id;

Line 206: WSH_DEBUG_SV.pop(l_module_name,'no_data_found');

202:
203: if (row_id%NOTFOUND) then
204: close row_id;
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.pop(l_module_name,'no_data_found');
207: END IF;
208: raise NO_DATA_FOUND;
209: end if;
210:

Line 214: WSH_DEBUG_SV.pop(l_module_name);

210:
211: close row_id;
212: --
213: IF l_debug_on THEN
214: WSH_DEBUG_SV.pop(l_module_name);
215: END IF;
216: --
217: exception
218: when DUP_VAL_ON_INDEX then

Line 222: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

218: when DUP_VAL_ON_INDEX then
219: fnd_message.set_name('WSH', 'WSH_DUPLICATE_RECORD');
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
224: END IF;
225: --
226: app_exception.raise_exception;

Line 223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');

219: fnd_message.set_name('WSH', 'WSH_DUPLICATE_RECORD');
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
224: END IF;
225: --
226: app_exception.raise_exception;
227: when app_exception.record_lock_exception then

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

227: when app_exception.record_lock_exception then
228: fnd_message.set_name('OE', 'WSH_NO_LOCK');
229: --
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
233: END IF;
234: --
235: app_exception.raise_exception;

Line 232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');

228: fnd_message.set_name('OE', 'WSH_NO_LOCK');
229: --
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
233: END IF;
234: --
235: app_exception.raise_exception;
236: end insert_row;

Line 318: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

314: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
315: --
316: IF l_debug_on IS NULL
317: THEN
318: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
319: END IF;
320: --
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.push(l_module_name);

Line 322: WSH_DEBUG_SV.push(l_module_name);

318: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
319: END IF;
320: --
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.push(l_module_name);
323: --
324: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
325: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
326: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);

Line 324: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);

320: --
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.push(l_module_name);
323: --
324: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
325: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
326: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
327: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
328: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);

Line 325: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);

321: IF l_debug_on THEN
322: WSH_DEBUG_SV.push(l_module_name);
323: --
324: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
325: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
326: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
327: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
328: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
329: END IF;

Line 326: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);

322: WSH_DEBUG_SV.push(l_module_name);
323: --
324: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
325: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
326: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
327: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
328: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
329: END IF;
330: --

Line 327: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);

323: --
324: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
325: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
326: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
327: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
328: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
329: END IF;
330: --
331: open lock_record;

Line 328: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);

324: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
325: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
326: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
327: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
328: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
329: END IF;
330: --
331: open lock_record;
332:

Line 340: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_DELETED');

336: close lock_record;
337:
338: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_DELETED');
341: END IF;
342: app_exception.raise_exception;
343:
344: end if;

Line 476: WSH_DEBUG_SV.pop(l_module_name,'Nothing changed');

472: ) then
473:
474: --
475: IF l_debug_on THEN
476: WSH_DEBUG_SV.pop(l_module_name,'Nothing changed');
477: END IF;
478: --
479: return;
480:

Line 485: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_CHANGED');

481: else
482:
483: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
484: IF l_debug_on THEN
485: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_CHANGED');
486: END IF;
487: app_exception.raise_exception;
488:
489: end if;

Line 493: WSH_DEBUG_SV.log(l_module_name,'tlinfo.BASELANG',tlinfo.BASELANG);

489: end if;
490:
491: for tlinfo in c1 loop
492: IF l_debug_on THEN
493: WSH_DEBUG_SV.log(l_module_name,'tlinfo.BASELANG',tlinfo.BASELANG);
494: END IF;
495: if (tlinfo.BASELANG = 'Y') then
496: if ( ((tlinfo.NAME = X_NAME)
497: OR ((tlinfo.NAME is null) AND (X_NAME is null)))

Line 505: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_CHANGED');

501: null;
502: else
503: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
504: IF l_debug_on THEN
505: WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_CHANGED');
506: END IF;
507: app_exception.raise_exception;
508: end if;
509: end if;

Line 513: WSH_DEBUG_SV.pop(l_module_name);

509: end if;
510: end loop;
511: --
512: IF l_debug_on THEN
513: WSH_DEBUG_SV.pop(l_module_name);
514: END IF;
515: --
516: end lock_row;
517:

Line 577: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

573: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
574: --
575: IF l_debug_on IS NULL
576: THEN
577: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
578: END IF;
579: --
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.push(l_module_name);

Line 581: WSH_DEBUG_SV.push(l_module_name);

577: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
578: END IF;
579: --
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.push(l_module_name);
582: --
583: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
584: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
585: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);

Line 583: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);

579: --
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.push(l_module_name);
582: --
583: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
584: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
585: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
586: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
587: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);

Line 584: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);

580: IF l_debug_on THEN
581: WSH_DEBUG_SV.push(l_module_name);
582: --
583: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
584: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
585: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
586: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
587: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
588: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);

Line 585: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);

581: WSH_DEBUG_SV.push(l_module_name);
582: --
583: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
584: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
585: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
586: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
587: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
588: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
589: END IF;

Line 586: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);

582: --
583: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
584: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
585: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
586: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
587: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
588: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
589: END IF;
590: --

Line 587: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);

583: WSH_DEBUG_SV.log(l_module_name,'X_QUERY_ID',X_QUERY_ID);
584: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
585: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
586: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
587: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
588: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
589: END IF;
590: --
591: update wsh_saved_queries_b set

Line 588: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);

584: WSH_DEBUG_SV.log(l_module_name,'X_NAME',X_NAME);
585: WSH_DEBUG_SV.log(l_module_name,'X_DESCRIPTION',X_DESCRIPTION);
586: WSH_DEBUG_SV.log(l_module_name,'X_ENTITY_TYPE',X_ENTITY_TYPE);
587: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
588: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
589: END IF;
590: --
591: update wsh_saved_queries_b set
592:

Line 623: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);

619:
620: where query_id = X_query_id;
621:
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
624: END IF;
625: if (SQL%NOTFOUND) then
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.pop(l_module_name,'no_data_found');

Line 627: WSH_DEBUG_SV.pop(l_module_name,'no_data_found');

623: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
624: END IF;
625: if (SQL%NOTFOUND) then
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.pop(l_module_name,'no_data_found');
628: END IF;
629: raise NO_DATA_FOUND;
630: end if;
631:

Line 643: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);

639: where QUERY_ID = X_QUERY_ID
640: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
641:
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
644: END IF;
645: if (sql%notfound) then
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.pop(l_module_name,'no_data_found');

Line 647: WSH_DEBUG_SV.pop(l_module_name,'no_data_found');

643: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
644: END IF;
645: if (sql%notfound) then
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.pop(l_module_name,'no_data_found');
648: END IF;
649: raise no_data_found;
650: end if;
651: --

Line 653: WSH_DEBUG_SV.pop(l_module_name);

649: raise no_data_found;
650: end if;
651: --
652: IF l_debug_on THEN
653: WSH_DEBUG_SV.pop(l_module_name);
654: END IF;
655: --
656: exception
657: when DUP_VAL_ON_INDEX then

Line 661: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

657: when DUP_VAL_ON_INDEX then
658: fnd_message.set_name('WSH', 'WSH_DUPLICATE_RECORD');
659: --
660: IF l_debug_on THEN
661: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
663: END IF;
664: --
665: app_exception.raise_exception;

Line 662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');

658: fnd_message.set_name('WSH', 'WSH_DUPLICATE_RECORD');
659: --
660: IF l_debug_on THEN
661: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
663: END IF;
664: --
665: app_exception.raise_exception;
666: when app_exception.record_lock_exception then

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

666: when app_exception.record_lock_exception then
667: fnd_message.set_name('OE', 'WSH_NO_LOCK');
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
672: END IF;
673: --
674: app_exception.raise_exception;

Line 671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');

667: fnd_message.set_name('OE', 'WSH_NO_LOCK');
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
672: END IF;
673: --
674: app_exception.raise_exception;
675: end update_row;

Line 705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

701: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
702: --
703: IF l_debug_on IS NULL
704: THEN
705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
706: END IF;
707: --
708: IF l_debug_on THEN
709: WSH_DEBUG_SV.push(l_module_name);

Line 709: WSH_DEBUG_SV.push(l_module_name);

705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
706: END IF;
707: --
708: IF l_debug_on THEN
709: WSH_DEBUG_SV.push(l_module_name);
710: END IF;
711: --
712: delete from WSH_SAVED_QUERIES_TL
713: where QUERY_ID = X_QUERY_ID;

Line 716: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);

712: delete from WSH_SAVED_QUERIES_TL
713: where QUERY_ID = X_QUERY_ID;
714:
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);
717: END IF;
718: if (sql%notfound) then
719: IF l_debug_on THEN
720: WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');

Line 720: WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');

716: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);
717: END IF;
718: if (sql%notfound) then
719: IF l_debug_on THEN
720: WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');
721: END IF;
722: raise no_data_found;
723: end if;
724:

Line 729: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);

725: delete from wsh_saved_queries_b
726: where query_id = X_query_id;
727:
728: IF l_debug_on THEN
729: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);
730: END IF;
731: if (SQL%NOTFOUND) then
732: IF l_debug_on THEN
733: WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');

Line 733: WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');

729: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);
730: END IF;
731: if (SQL%NOTFOUND) then
732: IF l_debug_on THEN
733: WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');
734: END IF;
735: raise NO_DATA_FOUND;
736: end if;
737: --

Line 739: WSH_DEBUG_SV.pop(l_module_name);

735: raise NO_DATA_FOUND;
736: end if;
737: --
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.pop(l_module_name);
740: END IF;
741: --
742: end delete_row;
743:

Line 759: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

755: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
756: --
757: IF l_debug_on IS NULL
758: THEN
759: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
760: END IF;
761: --
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.push(l_module_name);

Line 763: WSH_DEBUG_SV.push(l_module_name);

759: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
760: END IF;
761: --
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.push(l_module_name);
764: END IF;
765: --
766: delete from WSH_SAVED_QUERIES_TL T
767: where not exists

Line 773: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);

769: from WSH_SAVED_QUERIES_B B
770: where B.QUERY_ID = T.QUERY_ID
771: );
772: IF l_debug_on THEN
773: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
774: END IF;
775:
776: update WSH_SAVED_QUERIES_TL T set (
777: NAME,

Line 802: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);

798: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
799: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
800: ));
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
803: END IF;
804: insert into WSH_SAVED_QUERIES_TL (
805: QUERY_ID,
806: NAME,

Line 836: WSH_DEBUG_SV.log(l_module_name,'Rows inserted',SQL%ROWCOUNT);

832: where T.QUERY_ID = B.QUERY_ID
833: and T.LANGUAGE = L.LANGUAGE_CODE);
834:
835: IF l_debug_on THEN
836: WSH_DEBUG_SV.log(l_module_name,'Rows inserted',SQL%ROWCOUNT);
837: END IF;
838: --
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.pop(l_module_name);

Line 840: WSH_DEBUG_SV.pop(l_module_name);

836: WSH_DEBUG_SV.log(l_module_name,'Rows inserted',SQL%ROWCOUNT);
837: END IF;
838: --
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.pop(l_module_name);
841: END IF;
842: --
843: end ADD_LANGUAGE;
844: