DBA Data[Home] [Help]

APPS.WSH_FREIGHT_COSTS_PUB dependencies on WSH_DEBUG_SV

Line 109: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

105: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
106: --
107: IF l_debug_on IS NULL
108: THEN
109: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
110: END IF;
111: --
112: IF l_debug_on THEN
113: WSH_DEBUG_SV.push(l_module_name);

Line 113: WSH_DEBUG_SV.push(l_module_name);

109: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
110: END IF;
111: --
112: IF l_debug_on THEN
113: WSH_DEBUG_SV.push(l_module_name);
114: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_ID',p_pub_freight_rec.FREIGHT_COST_ID);
115: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_TYPE_ID',p_pub_freight_rec.FREIGHT_COST_TYPE_ID);
116: END IF;
117: --

Line 114: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_ID',p_pub_freight_rec.FREIGHT_COST_ID);

110: END IF;
111: --
112: IF l_debug_on THEN
113: WSH_DEBUG_SV.push(l_module_name);
114: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_ID',p_pub_freight_rec.FREIGHT_COST_ID);
115: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_TYPE_ID',p_pub_freight_rec.FREIGHT_COST_TYPE_ID);
116: END IF;
117: --
118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 115: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_TYPE_ID',p_pub_freight_rec.FREIGHT_COST_TYPE_ID);

111: --
112: IF l_debug_on THEN
113: WSH_DEBUG_SV.push(l_module_name);
114: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_ID',p_pub_freight_rec.FREIGHT_COST_ID);
115: WSH_DEBUG_SV.log(l_module_name,'p_pub_freight_rec.FREIGHT_COST_TYPE_ID',p_pub_freight_rec.FREIGHT_COST_TYPE_ID);
116: END IF;
117: --
118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
119:

Line 177: WSH_DEBUG_SV.pop(l_module_name);

173: x_pvt_freight_rec.STOP_LOCATION_ID := p_pub_freight_rec.STOP_LOCATION_ID;
174: x_pvt_freight_rec.PLANNED_DEP_DATE := p_pub_freight_rec.PLANNED_DEP_DATE;
175:
176: IF l_debug_on THEN
177: WSH_DEBUG_SV.pop(l_module_name);
178: END IF;
179: --
180: EXCEPTION
181: WHEN OTHERS THEN

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

182: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_freightpub_to_pvt',l_module_name);
183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
184: --
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
188: END IF;
189: --
190: END;

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

183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
184: --
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
188: END IF;
189: --
190: END;
191:

Line 236: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

232: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
233: --
234: IF l_debug_on IS NULL
235: THEN
236: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
237: END IF;
238: --
239: IF l_debug_on THEN
240: wsh_debug_sv.push (l_module_name, 'Create_Update_Freight_Costs');

Line 240: wsh_debug_sv.push (l_module_name, 'Create_Update_Freight_Costs');

236: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
237: END IF;
238: --
239: IF l_debug_on THEN
240: wsh_debug_sv.push (l_module_name, 'Create_Update_Freight_Costs');
241: END IF;
242:
243: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 256: wsh_debug_sv.log(l_module_name, 'map_freightpub_to_pvt x_return_status',x_return_status);

252: p_pub_freight_rec => p_pub_freight_costs ,
253: x_pvt_freight_rec => l_pvt_freight_rec,
254: x_return_status => x_return_status);
255: IF l_debug_on THEN
256: wsh_debug_sv.log(l_module_name, 'map_freightpub_to_pvt x_return_status',x_return_status);
257: END IF;
258:
259: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
260: raise FND_API.G_EXC_ERROR;

Line 294: WSH_DEBUG_SV.pop(l_module_name);

290: p_count => x_msg_count,
291: p_data => x_msg_data);
292:
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.pop(l_module_name);
295: END IF;
296:
297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN

Line 305: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',

301: p_count => x_msg_count,
302: p_data => x_msg_data,
303: p_encoded => FND_API.G_FALSE);
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
306: WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309:

Line 306: WSH_DEBUG_SV.C_EXCEP_LEVEL);

302: p_data => x_msg_data,
303: p_encoded => FND_API.G_FALSE);
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
306: WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

303: p_encoded => FND_API.G_FALSE);
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
306: WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

313: p_count => x_msg_count,
314: p_data => x_msg_data,
315: p_encoded => FND_API.G_FALSE);
316: IF l_debug_on THEN
317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321:

Line 318: WSH_DEBUG_SV.C_EXCEP_LEVEL);

314: p_data => x_msg_data,
315: p_encoded => FND_API.G_FALSE);
316: IF l_debug_on THEN
317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321:
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

315: p_encoded => FND_API.G_FALSE);
316: IF l_debug_on THEN
317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321:
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
323: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',

325: p_count => x_msg_count,
326: p_data => x_msg_data,
327: p_encoded => FND_API.G_FALSE);
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
330: WSH_DEBUG_SV.C_EXCEP_LEVEL);
331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
332: END IF;
333:

Line 330: WSH_DEBUG_SV.C_EXCEP_LEVEL);

326: p_data => x_msg_data,
327: p_encoded => FND_API.G_FALSE);
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
330: WSH_DEBUG_SV.C_EXCEP_LEVEL);
331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
332: END IF;
333:
334: WHEN OTHERS THEN

Line 331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

327: p_encoded => FND_API.G_FALSE);
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
330: WSH_DEBUG_SV.C_EXCEP_LEVEL);
331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
332: END IF;
333:
334: WHEN OTHERS THEN
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

338: p_count => x_msg_count,
339: p_data => x_msg_data,
340: p_encoded => FND_API.G_FALSE);
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
345: END IF;
346: END Create_Update_Freight_Costs;

Line 343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

339: p_data => x_msg_data,
340: p_encoded => FND_API.G_FALSE);
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
345: END IF;
346: END Create_Update_Freight_Costs;
347:

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

340: p_encoded => FND_API.G_FALSE);
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
345: END IF;
346: END Create_Update_Freight_Costs;
347:
348: --Harmonizing Project **heali