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

Line 42: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

38: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
39: --
40: IF l_debug_on IS NULL
41: THEN
42: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
43: END IF;
44: --
45: IF l_debug_on THEN
46: WSH_DEBUG_SV.push(l_module_name);

Line 46: WSH_DEBUG_SV.push(l_module_name);

42: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
43: END IF;
44: --
45: IF l_debug_on THEN
46: WSH_DEBUG_SV.push(l_module_name);
47: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
48: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
49: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
50: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.AMOUNT',p_freight_cost_type_info.AMOUNT);

Line 47: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);

43: END IF;
44: --
45: IF l_debug_on THEN
46: WSH_DEBUG_SV.push(l_module_name);
47: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
48: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
49: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
50: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.AMOUNT',p_freight_cost_type_info.AMOUNT);
51: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CURRENCY_CODE',p_freight_cost_type_info.currency_code);

Line 48: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);

44: --
45: IF l_debug_on THEN
46: WSH_DEBUG_SV.push(l_module_name);
47: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
48: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
49: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
50: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.AMOUNT',p_freight_cost_type_info.AMOUNT);
51: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CURRENCY_CODE',p_freight_cost_type_info.currency_code);
52: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CHARGE_MAP_FLAG',p_freight_cost_type_info.charge_map_flag);

Line 49: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);

45: IF l_debug_on THEN
46: WSH_DEBUG_SV.push(l_module_name);
47: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
48: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
49: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
50: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.AMOUNT',p_freight_cost_type_info.AMOUNT);
51: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CURRENCY_CODE',p_freight_cost_type_info.currency_code);
52: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CHARGE_MAP_FLAG',p_freight_cost_type_info.charge_map_flag);
53: END IF;

Line 50: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.AMOUNT',p_freight_cost_type_info.AMOUNT);

46: WSH_DEBUG_SV.push(l_module_name);
47: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
48: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
49: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
50: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.AMOUNT',p_freight_cost_type_info.AMOUNT);
51: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CURRENCY_CODE',p_freight_cost_type_info.currency_code);
52: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CHARGE_MAP_FLAG',p_freight_cost_type_info.charge_map_flag);
53: END IF;
54: --

Line 51: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CURRENCY_CODE',p_freight_cost_type_info.currency_code);

47: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
48: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
49: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
50: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.AMOUNT',p_freight_cost_type_info.AMOUNT);
51: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CURRENCY_CODE',p_freight_cost_type_info.currency_code);
52: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CHARGE_MAP_FLAG',p_freight_cost_type_info.charge_map_flag);
53: END IF;
54: --
55: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 52: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CHARGE_MAP_FLAG',p_freight_cost_type_info.charge_map_flag);

48: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
49: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
50: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.AMOUNT',p_freight_cost_type_info.AMOUNT);
51: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CURRENCY_CODE',p_freight_cost_type_info.currency_code);
52: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CHARGE_MAP_FLAG',p_freight_cost_type_info.charge_map_flag);
53: END IF;
54: --
55: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
56:

Line 165: WSH_DEBUG_SV.log(l_module_name,'x_freight_cost_type_id',x_freight_cost_type_id);

161: --
162: -- Debug Statements
163: --
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.log(l_module_name,'x_freight_cost_type_id',x_freight_cost_type_id);
166: WSH_DEBUG_SV.pop(l_module_name);
167: END IF;
168: --
169: EXCEPTION

Line 166: WSH_DEBUG_SV.pop(l_module_name);

162: -- Debug Statements
163: --
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.log(l_module_name,'x_freight_cost_type_id',x_freight_cost_type_id);
166: WSH_DEBUG_SV.pop(l_module_name);
167: END IF;
168: --
169: EXCEPTION
170: WHEN create_failure THEN

Line 178: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

174: --
175: -- Debug Statements
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_FAILURE');
180: END IF;
181: --
182: WHEN others THEN

Line 179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_FAILURE');

175: -- Debug Statements
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_FAILURE');
180: END IF;
181: --
182: WHEN others THEN
183: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');

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

186: --
187: -- Debug Statements
188: --
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
192: END IF;
193: --
194: END Create_Freight_Cost_Type;

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

187: -- Debug Statements
188: --
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
192: END IF;
193: --
194: END Create_Freight_Cost_Type;
195:

Line 218: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

214: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
215: --
216: IF l_debug_on IS NULL
217: THEN
218: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
219: END IF;
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.push(l_module_name);

Line 222: WSH_DEBUG_SV.push(l_module_name);

218: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
219: END IF;
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.push(l_module_name);
223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
225: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
226: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);

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

220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.push(l_module_name);
223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
225: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
226: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
227: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
228: END IF;

Line 225: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);

221: IF l_debug_on THEN
222: WSH_DEBUG_SV.push(l_module_name);
223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
225: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
226: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
227: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
228: END IF;
229: --

Line 226: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);

222: WSH_DEBUG_SV.push(l_module_name);
223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
225: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
226: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
227: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
228: END IF;
229: --
230: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 227: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);

223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
225: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_ID',p_freight_cost_type_info.freight_cost_type_id);
226: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
227: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
228: END IF;
229: --
230: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
231:

Line 277: WSH_DEBUG_SV.pop(l_module_name);

273: --
274: -- Debug Statements
275: --
276: IF l_debug_on THEN
277: WSH_DEBUG_SV.pop(l_module_name);
278: END IF;
279: --
280: EXCEPTION
281: WHEN others THEN

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

284: --
285: -- Debug Statements
286: --
287: IF l_debug_on THEN
288: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
290: END IF;
291: --
292: END Update_Freight_Cost_Type;

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

285: -- Debug Statements
286: --
287: IF l_debug_on THEN
288: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
290: END IF;
291: --
292: END Update_Freight_Cost_Type;
293:

Line 323: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

319: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
320: --
321: IF l_debug_on IS NULL
322: THEN
323: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
324: END IF;
325: --
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.push(l_module_name);

Line 327: WSH_DEBUG_SV.push(l_module_name);

323: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
324: END IF;
325: --
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.push(l_module_name);
328: --
329: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
330: END IF;
331: --

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

325: --
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.push(l_module_name);
328: --
329: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
330: END IF;
331: --
332: OPEN lock_row;
333: FETCH lock_row INTO Recinfo;

Line 415: WSH_DEBUG_SV.pop(l_module_name);

411: --
412: -- Debug Statements
413: --
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.pop(l_module_name);
416: END IF;
417: --
418: RETURN;
419: ELSE

Line 428: WSH_DEBUG_SV.pop(l_module_name);

424: --
425: -- Debug Statements
426: --
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.pop(l_module_name);
429: END IF;
430: --
431: EXCEPTION
432: WHEN others THEN

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

434: --
435: -- Debug Statements
436: --
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
440: END IF;
441: --
442: raise;

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

435: -- Debug Statements
436: --
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
440: END IF;
441: --
442: raise;
443:

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: END Lock_Freight_Cost_Type;
452:

Line 482: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

478: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
479: --
480: IF l_debug_on IS NULL
481: THEN
482: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
483: END IF;
484: --
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.push(l_module_name);

Line 486: WSH_DEBUG_SV.push(l_module_name);

482: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
483: END IF;
484: --
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.push(l_module_name);
487: --
488: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
489: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_ID',P_FREIGHT_COST_TYPE_ID);
490: END IF;

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

484: --
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.push(l_module_name);
487: --
488: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
489: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_ID',P_FREIGHT_COST_TYPE_ID);
490: END IF;
491: --
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 489: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_ID',P_FREIGHT_COST_TYPE_ID);

485: IF l_debug_on THEN
486: WSH_DEBUG_SV.push(l_module_name);
487: --
488: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
489: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_ID',P_FREIGHT_COST_TYPE_ID);
490: END IF;
491: --
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
493: l_freight_cost_type_id := p_freight_cost_type_id;

Line 512: WSH_DEBUG_SV.pop(l_module_name);

508: --
509: -- Debug Statements
510: --
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.pop(l_module_name);
513: END IF;
514: --
515: EXCEPTION
516: WHEN row_not_found THEN

Line 523: WSH_DEBUG_SV.logmsg(l_module_name,'ROW_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

519: --
520: -- Debug Statements
521: --
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.logmsg(l_module_name,'ROW_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
524: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ROW_NOT_FOUND');
525: END IF;
526: --
527: WHEN others THEN

Line 524: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ROW_NOT_FOUND');

520: -- Debug Statements
521: --
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.logmsg(l_module_name,'ROW_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
524: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ROW_NOT_FOUND');
525: END IF;
526: --
527: WHEN others THEN
528: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');

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

530: --
531: -- Debug Statements
532: --
533: IF l_debug_on THEN
534: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
535: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
536: END IF;
537: --
538: END Delete_Freight_Cost_Type;

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

531: -- Debug Statements
532: --
533: IF l_debug_on THEN
534: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
535: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
536: END IF;
537: --
538: END Delete_Freight_Cost_Type;
539: