DBA Data[Home] [Help]

APPS.FTE_MOVES_PVT dependencies on WSH_DEBUG_SV

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

270: l_entity_ids WSH_UTIL_CORE.id_tab_type;
271: idx NUMBER;
272:
273: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'MARK_MOVE_REPRICE_FLAG';
274: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
275:
276: BEGIN
277:
278: SAVEPOINT MARK_MOVE_REPRICE_FLAG_PUB;

Line 294: wsh_debug_sv.push(l_module_name);

290: l_number_of_warnings := 0;
291: l_number_of_errors := 0;
292:
293: IF l_debug_on THEN
294: wsh_debug_sv.push(l_module_name);
295: END IF;
296:
297: idx := 1;
298: FOR get_trips_from_move_rec IN get_trips_from_move_cur(p_MOVE_id)

Line 309: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:27 ',WSH_DEBUG_SV.C_PROC_LEVEL);

305: -- END OF
306: --
307: --
308: IF l_debug_on THEN
309: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:27 ',WSH_DEBUG_SV.C_PROC_LEVEL);
310: END IF;
311:
312: IF get_trips_from_move_cur%ISOPEN THEN
313: CLOSE get_trips_from_move_cur;

Line 346: WSH_DEBUG_SV.pop(l_module_name);

342: p_encoded => FND_API.G_FALSE
343: );
344:
345: IF l_debug_on THEN
346: WSH_DEBUG_SV.pop(l_module_name);
347: END IF;
348:
349:
350:

Line 363: WSH_DEBUG_SV.logmsg(l_module_name,' Error Occured ' ||

359: p_encoded => FND_API.G_FALSE
360: );
361:
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,' Error Occured ' ||
364: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
365: WSH_DEBUG_SV.pop(l_module_name);
366: END IF;
367:

Line 364: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

360: );
361:
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,' Error Occured ' ||
364: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
365: WSH_DEBUG_SV.pop(l_module_name);
366: END IF;
367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 365: WSH_DEBUG_SV.pop(l_module_name);

361:
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,' Error Occured ' ||
364: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
365: WSH_DEBUG_SV.pop(l_module_name);
366: END IF;
367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO MARK_MOVE_REPRICE_FLAG_PUB;

Line 378: WSH_DEBUG_SV.logmsg(l_module_name,' Unexpected error Occured ' ||

374: p_data => x_msg_data,
375: p_encoded => FND_API.G_FALSE
376: );
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,' Unexpected error Occured ' ||
379: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name);
381: END IF;
382:

Line 379: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

375: p_encoded => FND_API.G_FALSE
376: );
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,' Unexpected error Occured ' ||
379: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name);
381: END IF;
382:
383: WHEN OTHERS THEN

Line 380: WSH_DEBUG_SV.pop(l_module_name);

376: );
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,' Unexpected error Occured ' ||
379: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name);
381: END IF;
382:
383: WHEN OTHERS THEN
384: IF l_debug_on THEN

Line 385: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:13 ',WSH_DEBUG_SV.C_PROC_LEVEL);

381: END IF;
382:
383: WHEN OTHERS THEN
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:13 ',WSH_DEBUG_SV.C_PROC_LEVEL);
386: END IF;
387:
388: ROLLBACK TO MARK_MOVE_REPRICE_FLAG_PUB;
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 397: WSH_DEBUG_SV.logmsg(l_module_name,' SQL Error Occured ' ||

393: p_data => x_msg_data,
394: p_encoded => FND_API.G_FALSE
395: );
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,' SQL Error Occured ' ||
398: SQLCODE||' '||SQLERRM, WSH_DEBUG_SV.C_PROC_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name);
400: END IF;
401:

Line 398: SQLCODE||' '||SQLERRM, WSH_DEBUG_SV.C_PROC_LEVEL);

394: p_encoded => FND_API.G_FALSE
395: );
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,' SQL Error Occured ' ||
398: SQLCODE||' '||SQLERRM, WSH_DEBUG_SV.C_PROC_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name);
400: END IF;
401:
402:

Line 399: WSH_DEBUG_SV.pop(l_module_name);

395: );
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,' SQL Error Occured ' ||
398: SQLCODE||' '||SQLERRM, WSH_DEBUG_SV.C_PROC_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name);
400: END IF;
401:
402:
403: END MARK_MOVE_REPRICE_FLAG;