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

Line 101: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

97: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
98: --
99: IF l_debug_on IS NULL
100: THEN
101: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
102: END IF;
103: --
104: IF l_debug_on THEN
105: WSH_DEBUG_SV.push(l_module_name);

Line 105: WSH_DEBUG_SV.push(l_module_name);

101: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
102: END IF;
103: --
104: IF l_debug_on THEN
105: WSH_DEBUG_SV.push(l_module_name);
106: WSH_DEBUG_SV.log(l_module_name,'APPL_SHORT_NAME',appl_short_name);
107: WSH_DEBUG_SV.log(l_module_name,'FLEXFIELD_NAME',flexfield_name);
108:
109: END IF;

Line 106: WSH_DEBUG_SV.log(l_module_name,'APPL_SHORT_NAME',appl_short_name);

102: END IF;
103: --
104: IF l_debug_on THEN
105: WSH_DEBUG_SV.push(l_module_name);
106: WSH_DEBUG_SV.log(l_module_name,'APPL_SHORT_NAME',appl_short_name);
107: WSH_DEBUG_SV.log(l_module_name,'FLEXFIELD_NAME',flexfield_name);
108:
109: END IF;
110: --

Line 107: WSH_DEBUG_SV.log(l_module_name,'FLEXFIELD_NAME',flexfield_name);

103: --
104: IF l_debug_on THEN
105: WSH_DEBUG_SV.push(l_module_name);
106: WSH_DEBUG_SV.log(l_module_name,'APPL_SHORT_NAME',appl_short_name);
107: WSH_DEBUG_SV.log(l_module_name,'FLEXFIELD_NAME',flexfield_name);
108:
109: END IF;
110: --
111: OPEN c_get_flexname;

Line 133: WSH_DEBUG_SV.pop(l_module_name);

129: --
130: -- Debug Statements
131: --
132: IF l_debug_on THEN
133: WSH_DEBUG_SV.pop(l_module_name);
134: END IF;
135: --
136: END get_flexfield;
137:

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: --
177: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
178: END IF;
179: --

Line 177: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);

173: --
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.push(l_module_name);
176: --
177: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
178: END IF;
179: --
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
181:

Line 205: WSH_DEBUG_SV.pop(l_module_name);

201: --
202: -- Debug Statements
203: --
204: IF l_debug_on THEN
205: WSH_DEBUG_SV.pop(l_module_name);
206: END IF;
207: --
208: RETURN j;
209: END IF;

Line 275: WSH_DEBUG_SV.log(l_module_name,'fnd_flex_descval.segment_column_name(i))',fnd_flex_descval.segment_column_name(i));

271: n := fnd_flex_descval.segment_count;
272: FOR i in 1..n LOOP
273: --{
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.log(l_module_name,'fnd_flex_descval.segment_column_name(i))',fnd_flex_descval.segment_column_name(i));
276: END if;
277: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 2)) = 'TP' ) THEN
278: --{
279: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 12))

Line 296: WSH_DEBUG_SV.log(l_module_name,'The segments value is',fnd_flex_descval.segment_value(i));

292:
293: k := k + 1;
294: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),10)));
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.log(l_module_name,'The segments value is',fnd_flex_descval.segment_value(i));
297: WSH_DEBUG_SV.log(l_module_name,'The segment id is',fnd_flex_descval.segment_id(i));
298: END IF;
299: -- bug 5948562, segment value - used for display, segment id - should be stored in db to prevent any format issues.
300: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);

Line 297: WSH_DEBUG_SV.log(l_module_name,'The segment id is',fnd_flex_descval.segment_id(i));

293: k := k + 1;
294: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),10)));
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.log(l_module_name,'The segments value is',fnd_flex_descval.segment_value(i));
297: WSH_DEBUG_SV.log(l_module_name,'The segment id is',fnd_flex_descval.segment_id(i));
298: END IF;
299: -- bug 5948562, segment value - used for display, segment id - should be stored in db to prevent any format issues.
300: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);
301: END IF;

Line 308: WSH_DEBUG_SV.log(l_module_name,'ERROR_SEGMENT',fnd_flex_descval.error_segment);

304: --}
305: END LOOP;
306: ELSE
307: IF l_debug_on THEN
308: WSH_DEBUG_SV.log(l_module_name,'ERROR_SEGMENT',fnd_flex_descval.error_segment);
309: WSH_DEBUG_SV.log(l_module_name,'ERROR_MESSAGE',fnd_flex_descval.error_message);
310: END IF;
311: --} validate_desccols
312: END IF;

Line 309: WSH_DEBUG_SV.log(l_module_name,'ERROR_MESSAGE',fnd_flex_descval.error_message);

305: END LOOP;
306: ELSE
307: IF l_debug_on THEN
308: WSH_DEBUG_SV.log(l_module_name,'ERROR_SEGMENT',fnd_flex_descval.error_segment);
309: WSH_DEBUG_SV.log(l_module_name,'ERROR_MESSAGE',fnd_flex_descval.error_message);
310: END IF;
311: --} validate_desccols
312: END IF;
313: -- End of fix for bug 2353335

Line 329: WSH_DEBUG_SV.pop(l_module_name);

325: --
326: -- Debug Statements
327: --
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.pop(l_module_name);
330: END IF;
331: --
332: RETURN j;
333: EXCEPTION

Line 344: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

Line 345: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');

341: -- Debug Statements
342: --
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
345: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
346: END IF;
347: --
348: -- Debug Statements
349: --

Line 351: WSH_DEBUG_SV.pop(l_module_name);

347: --
348: -- Debug Statements
349: --
350: IF l_debug_on THEN
351: WSH_DEBUG_SV.pop(l_module_name);
352: END IF;
353: --
354: RETURN NULL;
355: --

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

361: --
362: -- Debug Statements
363: --
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
367: END IF;
368: --
369: -- Debug Statements

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

362: -- Debug Statements
363: --
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
367: END IF;
368: --
369: -- Debug Statements
370: --

Line 372: WSH_DEBUG_SV.pop(l_module_name);

368: --
369: -- Debug Statements
370: --
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.pop(l_module_name);
373: END IF;
374: --
375: RETURN NULL;
376:

Line 407: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

403: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
404: --
405: IF l_debug_on IS NULL
406: THEN
407: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
408: END IF;
409: --
410: IF l_debug_on THEN
411: WSH_DEBUG_SV.push(l_module_name);

Line 411: WSH_DEBUG_SV.push(l_module_name);

407: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
408: END IF;
409: --
410: IF l_debug_on THEN
411: WSH_DEBUG_SV.push(l_module_name);
412: --
413: WSH_DEBUG_SV.log(l_module_name,'P_FLEXFIELD_NAME',P_FLEXFIELD_NAME);
414: END IF;
415: --

Line 413: WSH_DEBUG_SV.log(l_module_name,'P_FLEXFIELD_NAME',P_FLEXFIELD_NAME);

409: --
410: IF l_debug_on THEN
411: WSH_DEBUG_SV.push(l_module_name);
412: --
413: WSH_DEBUG_SV.log(l_module_name,'P_FLEXFIELD_NAME',P_FLEXFIELD_NAME);
414: END IF;
415: --
416: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
417:

Line 429: WSH_DEBUG_SV.pop(l_module_name);

425: --
426: -- Debug Statements
427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.pop(l_module_name);
430: END IF;
431: --
432: return;
433: END IF;

Line 448: WSH_DEBUG_SV.pop(l_module_name);

444: --
445: -- Debug Statements
446: --
447: IF l_debug_on THEN
448: WSH_DEBUG_SV.pop(l_module_name);
449: END IF;
450: --
451: EXCEPTION
452: WHEN Others THEN

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

458: --
459: -- Debug Statements
460: --
461: IF l_debug_on THEN
462: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
463: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
464: END IF;
465: --
466: END Get_DFF_Defaults;

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

459: -- Debug Statements
460: --
461: IF l_debug_on THEN
462: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
463: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
464: END IF;
465: --
466: END Get_DFF_Defaults;
467:

Line 498: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

494: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
495: --
496: IF l_debug_on IS NULL
497: THEN
498: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
499: END IF;
500: --
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.push(l_module_name);

Line 502: WSH_DEBUG_SV.push(l_module_name);

498: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
499: END IF;
500: --
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.push(l_module_name);
503: --
504: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
505: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
506: END IF;

Line 504: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);

500: --
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.push(l_module_name);
503: --
504: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
505: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
506: END IF;
507: --
508: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 505: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);

501: IF l_debug_on THEN
502: WSH_DEBUG_SV.push(l_module_name);
503: --
504: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
505: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
506: END IF;
507: --
508: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
509: flexfield_name := p_table_name;

Line 522: WSH_DEBUG_SV.pop(l_module_name);

518: --
519: -- Debug Statements
520: --
521: IF l_debug_on THEN
522: WSH_DEBUG_SV.pop(l_module_name);
523: END IF;
524: --
525: return;
526: END IF;

Line 585: WSH_DEBUG_SV.pop(l_module_name);

581: --
582: -- Debug Statements
583: --
584: IF l_debug_on THEN
585: WSH_DEBUG_SV.pop(l_module_name);
586: END IF;
587: --
588: EXCEPTION
589: WHEN Invalid_Table THEN

Line 598: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

594: --
595: -- Debug Statements
596: --
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
600: END IF;
601: --
602: WHEN Others THEN

Line 599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');

595: -- Debug Statements
596: --
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
600: END IF;
601: --
602: WHEN Others THEN
603: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

607: --
608: -- Debug Statements
609: --
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
613: END IF;
614: --
615: END Write_DFF_Attributes;

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

608: -- Debug Statements
609: --
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
613: END IF;
614: --
615: END Write_DFF_Attributes;
616:

Line 677: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

673: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
674: --
675: IF l_debug_on IS NULL
676: THEN
677: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
678: END IF;
679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.push(l_module_name);

Line 681: WSH_DEBUG_SV.push(l_module_name);

677: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
678: END IF;
679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.push(l_module_name);
682: --
683: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
684: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
685: END IF;

Line 683: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);

679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.push(l_module_name);
682: --
683: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
684: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
685: END IF;
686: --
687: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 684: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);

680: IF l_debug_on THEN
681: WSH_DEBUG_SV.push(l_module_name);
682: --
683: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
684: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
685: END IF;
686: --
687: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
688:

Line 767: WSH_DEBUG_SV.pop(l_module_name);

763: --
764: -- Debug Statements
765: --
766: IF l_debug_on THEN
767: WSH_DEBUG_SV.pop(l_module_name);
768: END IF;
769: --
770: EXCEPTION
771: WHEN Invalid_Delivery THEN

Line 783: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

779: --
780: -- Debug Statements
781: --
782: IF l_debug_on THEN
783: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
784: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_DELIVERY');
785: END IF;
786: --
787: -- Exception Handling added for Bug 3118519.

Line 784: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_DELIVERY');

780: -- Debug Statements
781: --
782: IF l_debug_on THEN
783: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
784: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_DELIVERY');
785: END IF;
786: --
787: -- Exception Handling added for Bug 3118519.
788: WHEN Invalid_Del_Detail THEN

Line 800: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DEL_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

796: --
797: -- Debug Statements
798: --
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DEL_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_DEL_DETAIL');
802: END IF;
803: --
804: WHEN Invalid_Table THEN

Line 801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_DEL_DETAIL');

797: -- Debug Statements
798: --
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DEL_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_DEL_DETAIL');
802: END IF;
803: --
804: WHEN Invalid_Table THEN
805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 813: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

809: --
810: -- Debug Statements
811: --
812: IF l_debug_on THEN
813: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
815: END IF;
816: --
817: WHEN Others THEN

Line 814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');

810: -- Debug Statements
811: --
812: IF l_debug_on THEN
813: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
815: END IF;
816: --
817: WHEN Others THEN
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

822: --
823: -- Debug Statements
824: --
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
827: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
828: END IF;
829: --
830: END Read_Table_Attributes;

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

823: -- Debug Statements
824: --
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
827: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
828: END IF;
829: --
830: END Read_Table_Attributes;
831:

Line 863: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

859: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
860: --
861: IF l_debug_on IS NULL
862: THEN
863: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
864: END IF;
865: --
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.push(l_module_name);

Line 867: WSH_DEBUG_SV.push(l_module_name);

863: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
864: END IF;
865: --
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.push(l_module_name);
868: --
869: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
870: END IF;
871: --

Line 869: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);

865: --
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.push(l_module_name);
868: --
869: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
870: END IF;
871: --
872: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
873:

Line 897: WSH_DEBUG_SV.pop(l_module_name);

893: --
894: -- Debug Statements
895: --
896: IF l_debug_on THEN
897: WSH_DEBUG_SV.pop(l_module_name);
898: END IF;
899: --
900: RETURN j;
901: END IF;

Line 946: WSH_DEBUG_SV.pop(l_module_name);

942: --
943: -- Debug Statements
944: --
945: IF l_debug_on THEN
946: WSH_DEBUG_SV.pop(l_module_name);
947: END IF;
948: --
949: RETURN j;
950:

Line 962: WSH_DEBUG_SV.pop(l_module_name);

958: --
959: -- Debug Statements
960: --
961: IF l_debug_on THEN
962: WSH_DEBUG_SV.pop(l_module_name);
963: END IF;
964: --
965: RETURN NULL;
966:

Line 971: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

967: --
968: -- Debug Statements
969: --
970: IF l_debug_on THEN
971: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
973: END IF;
974: --
975: WHEN Others THEN

Line 972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');

968: -- Debug Statements
969: --
970: IF l_debug_on THEN
971: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
973: END IF;
974: --
975: WHEN Others THEN
976: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 983: WSH_DEBUG_SV.pop(l_module_name);

979: --
980: -- Debug Statements
981: --
982: IF l_debug_on THEN
983: WSH_DEBUG_SV.pop(l_module_name);
984: END IF;
985: --
986: RETURN NULL;
987:

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

989: --
990: -- Debug Statements
991: --
992: IF l_debug_on THEN
993: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
995: END IF;
996: --
997: END Check_DFF_Req;

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

990: -- Debug Statements
991: --
992: IF l_debug_on THEN
993: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
995: END IF;
996: --
997: END Check_DFF_Req;
998:

Line 1032: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1028: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1029: --
1030: IF l_debug_on IS NULL
1031: THEN
1032: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1033: END IF;
1034: --
1035: IF l_debug_on THEN
1036: WSH_DEBUG_SV.push(l_module_name);

Line 1036: WSH_DEBUG_SV.push(l_module_name);

1032: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1033: END IF;
1034: --
1035: IF l_debug_on THEN
1036: WSH_DEBUG_SV.push(l_module_name);
1037: --
1038: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
1039: WSH_DEBUG_SV.log(l_module_name,'P_CONTEXT',P_CONTEXT);
1040: END IF;

Line 1038: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);

1034: --
1035: IF l_debug_on THEN
1036: WSH_DEBUG_SV.push(l_module_name);
1037: --
1038: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
1039: WSH_DEBUG_SV.log(l_module_name,'P_CONTEXT',P_CONTEXT);
1040: END IF;
1041: --
1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1039: WSH_DEBUG_SV.log(l_module_name,'P_CONTEXT',P_CONTEXT);

1035: IF l_debug_on THEN
1036: WSH_DEBUG_SV.push(l_module_name);
1037: --
1038: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
1039: WSH_DEBUG_SV.log(l_module_name,'P_CONTEXT',P_CONTEXT);
1040: END IF;
1041: --
1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1043:

Line 1067: WSH_DEBUG_SV.pop(l_module_name);

1063: --
1064: -- Debug Statements
1065: --
1066: IF l_debug_on THEN
1067: WSH_DEBUG_SV.pop(l_module_name);
1068: END IF;
1069: --
1070: RETURN j;
1071: END IF;

Line 1131: WSH_DEBUG_SV.pop(l_module_name);

1127: --
1128: -- Debug Statements
1129: --
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.pop(l_module_name);
1132: END IF;
1133: --
1134: RETURN j;
1135:

Line 1147: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1143: --
1144: -- Debug Statements
1145: --
1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1148: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
1149: END IF;
1150: --
1151: -- Debug Statements

Line 1148: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');

1144: -- Debug Statements
1145: --
1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TABLE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1148: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TABLE');
1149: END IF;
1150: --
1151: -- Debug Statements
1152: --

Line 1154: WSH_DEBUG_SV.pop(l_module_name);

1150: --
1151: -- Debug Statements
1152: --
1153: IF l_debug_on THEN
1154: WSH_DEBUG_SV.pop(l_module_name);
1155: END IF;
1156: --
1157: RETURN NULL;
1158:

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

1164: --
1165: -- Debug Statements
1166: --
1167: IF l_debug_on THEN
1168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1170: END IF;
1171: --
1172: -- Debug Statements

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

1165: -- Debug Statements
1166: --
1167: IF l_debug_on THEN
1168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1170: END IF;
1171: --
1172: -- Debug Statements
1173: --

Line 1175: WSH_DEBUG_SV.pop(l_module_name);

1171: --
1172: -- Debug Statements
1173: --
1174: IF l_debug_on THEN
1175: WSH_DEBUG_SV.pop(l_module_name);
1176: END IF;
1177: --
1178: RETURN NULL;
1179:

Line 1213: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1209: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1210: --
1211: IF l_debug_on IS NULL
1212: THEN
1213: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1214: END IF;
1215: --
1216: IF l_debug_on THEN
1217: WSH_DEBUG_SV.push(l_module_name);

Line 1217: WSH_DEBUG_SV.push(l_module_name);

1213: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1214: END IF;
1215: --
1216: IF l_debug_on THEN
1217: WSH_DEBUG_SV.push(l_module_name);
1218: --
1219: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
1220: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
1221: END IF;

Line 1219: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);

1215: --
1216: IF l_debug_on THEN
1217: WSH_DEBUG_SV.push(l_module_name);
1218: --
1219: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
1220: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
1221: END IF;
1222: --
1223: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1220: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);

1216: IF l_debug_on THEN
1217: WSH_DEBUG_SV.push(l_module_name);
1218: --
1219: WSH_DEBUG_SV.log(l_module_name,'P_TABLE_NAME',P_TABLE_NAME);
1220: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
1221: END IF;
1222: --
1223: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1224: IF (p_table_name = 'WSH_NEW_DELIVERIES') THEN

Line 1236: WSH_DEBUG_SV.pop(l_module_name);

1232: --
1233: -- Debug Statements
1234: --
1235: IF l_debug_on THEN
1236: WSH_DEBUG_SV.pop(l_module_name);
1237: END IF;
1238: --
1239: return;
1240: END IF;

Line 1257: WSH_DEBUG_SV.pop(l_module_name);

1253: --
1254: -- Debug Statements
1255: --
1256: IF l_debug_on THEN
1257: WSH_DEBUG_SV.pop(l_module_name);
1258: END IF;
1259: --
1260: return;
1261: END IF;

Line 1291: WSH_DEBUG_SV.pop(l_module_name);

1287: --
1288: -- Debug Statements
1289: --
1290: IF l_debug_on THEN
1291: WSH_DEBUG_SV.pop(l_module_name);
1292: END IF;
1293: --
1294: EXCEPTION
1295: WHEN Required_Attributes_Empty THEN

Line 1307: WSH_DEBUG_SV.logmsg(l_module_name,'REQUIRED_ATTRIBUTES_EMPTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1303: --
1304: -- Debug Statements
1305: --
1306: IF l_debug_on THEN
1307: WSH_DEBUG_SV.logmsg(l_module_name,'REQUIRED_ATTRIBUTES_EMPTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REQUIRED_ATTRIBUTES_EMPTY');
1309: END IF;
1310: --
1311: WHEN Others THEN

Line 1308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REQUIRED_ATTRIBUTES_EMPTY');

1304: -- Debug Statements
1305: --
1306: IF l_debug_on THEN
1307: WSH_DEBUG_SV.logmsg(l_module_name,'REQUIRED_ATTRIBUTES_EMPTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REQUIRED_ATTRIBUTES_EMPTY');
1309: END IF;
1310: --
1311: WHEN Others THEN
1312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

1315: --
1316: -- Debug Statements
1317: --
1318: IF l_debug_on THEN
1319: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1320: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1321: END IF;
1322: --
1323: END Validate_DFF;

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

1316: -- Debug Statements
1317: --
1318: IF l_debug_on THEN
1319: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1320: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1321: END IF;
1322: --
1323: END Validate_DFF;
1324: