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

Line 233: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

229: BEGIN
230: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
231:
232: IF l_debug_on IS NULL THEN
233: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
234: END IF;
235:
236: IF l_debug_on THEN
237: WSH_DEBUG_SV.push(l_module_name);

Line 237: WSH_DEBUG_SV.push(l_module_name);

233: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
234: END IF;
235:
236: IF l_debug_on THEN
237: WSH_DEBUG_SV.push(l_module_name);
238: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
239: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
240: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
241: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);

Line 238: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

234: END IF;
235:
236: IF l_debug_on THEN
237: WSH_DEBUG_SV.push(l_module_name);
238: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
239: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
240: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
241: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
242: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);

Line 239: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

235:
236: IF l_debug_on THEN
237: WSH_DEBUG_SV.push(l_module_name);
238: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
239: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
240: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
241: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
242: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);
243: END IF;

Line 240: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);

236: IF l_debug_on THEN
237: WSH_DEBUG_SV.push(l_module_name);
238: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
239: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
240: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
241: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
242: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);
243: END IF;
244:

Line 241: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);

237: WSH_DEBUG_SV.push(l_module_name);
238: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
239: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
240: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
241: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
242: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);
243: END IF;
244:
245: savepoint Complete_Inv_Interface;

Line 242: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);

238: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
239: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
240: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
241: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
242: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);
243: END IF;
244:
245: savepoint Complete_Inv_Interface;
246:

Line 253: WSH_DEBUG_SV.logmsg(l_module_name,'Done Compatible_API_Call');

249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252: IF l_debug_on THEN
253: WSH_DEBUG_SV.logmsg(l_module_name,'Done Compatible_API_Call');
254: END IF;
255:
256: -- Initialize message stack if required
257: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 262: WSH_DEBUG_SV.logmsg(l_module_name,'Done FND_API.to_Boolean');

258: FND_MSG_PUB.initialize;
259: END IF;
260:
261: IF l_debug_on THEN
262: WSH_DEBUG_SV.logmsg(l_module_name,'Done FND_API.to_Boolean');
263: END IF;
264:
265: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
266:

Line 275: WSH_DEBUG_SV.log(l_module_name,'No of Record fetch l_row_count',l_row_count);

271: l_det_rec.stop_id,
272: l_det_rec.delivery_detail_id;
273: l_row_count := detail_rec_csr%ROWCOUNT;
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.log(l_module_name,'No of Record fetch l_row_count',l_row_count);
276: END IF;
277: CLOSE detail_rec_csr;
278:
279: IF (l_row_count < 1 ) THEN

Line 288: WSH_DEBUG_SV.log(l_module_name,'l_stop_id',l_stop_id);

284:
285: l_stop_id := l_det_rec.stop_id(l_det_rec.stop_id.first);
286:
287: IF l_debug_on THEN
288: WSH_DEBUG_SV.log(l_module_name,'l_stop_id',l_stop_id);
289: END IF;
290:
291: FORALL i IN 1 ..l_row_count
292: UPDATE wsh_delivery_details

Line 299: WSH_DEBUG_SV.log(l_module_name,'No of Record Update to Y l_row_count',l_row_count);

295:
296: l_row_count := SQL%ROWCOUNT;
297:
298: IF l_debug_on THEN
299: WSH_DEBUG_SV.log(l_module_name,'No of Record Update to Y l_row_count',l_row_count);
300: END IF;
301:
302: /* Check if all the delivery details under the trip stop are interfaced to inventory and OM.
303: If yes, then update the pending_interface_flag of the trip to NULL.*/

Line 321: WSH_DEBUG_SV.log(l_module_name,'All lines are Interface to INV and OM',l_temp_id);

317: FETCH c_lines_not_interfaced INTO l_temp_id;
318:
319: IF (c_lines_not_interfaced%NOTFOUND) THEN
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.log(l_module_name,'All lines are Interface to INV and OM',l_temp_id);
322: END IF;
323:
324: UPDATE wsh_trip_stops
325: SET pending_interface_flag = NULL

Line 331: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag update to NULL for stop',l_det_rec.stop_id(l_index));

327:
328: l_row_count := SQL%ROWCOUNT;
329:
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag update to NULL for stop',l_det_rec.stop_id(l_index));
332: END IF;
333: ELSE
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.log(l_module_name,'All lines are Not Interface to INV and OM',l_temp_id);

Line 335: WSH_DEBUG_SV.log(l_module_name,'All lines are Not Interface to INV and OM',l_temp_id);

331: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag update to NULL for stop',l_det_rec.stop_id(l_index));
332: END IF;
333: ELSE
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.log(l_module_name,'All lines are Not Interface to INV and OM',l_temp_id);
336: END IF;
337: END IF;
338: CLOSE c_lines_not_interfaced;
339:

Line 361: WSH_DEBUG_SV.pop(l_module_name);

357: , p_count => x_msg_count
358: , p_data => x_msg_data);
359:
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.pop(l_module_name);
362: END IF;
363:
364: EXCEPTION
365: WHEN no_data_found THEN

Line 368: WSH_DEBUG_SV.logmsg(l_module_name,'No Record found to complete interface',WSH_DEBUG_SV.C_EXCEP_LEVEL);

364: EXCEPTION
365: WHEN no_data_found THEN
366: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
367: IF l_debug_on THEN
368: WSH_DEBUG_SV.logmsg(l_module_name,'No Record found to complete interface',WSH_DEBUG_SV.C_EXCEP_LEVEL);
369: WSH_DEBUG_SV.pop(l_module_name);
370: END IF;
371:
372:

Line 369: WSH_DEBUG_SV.pop(l_module_name);

365: WHEN no_data_found THEN
366: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
367: IF l_debug_on THEN
368: WSH_DEBUG_SV.logmsg(l_module_name,'No Record found to complete interface',WSH_DEBUG_SV.C_EXCEP_LEVEL);
369: WSH_DEBUG_SV.pop(l_module_name);
370: END IF;
371:
372:
373: WHEN trip_stop_locked THEN

Line 376: WSH_DEBUG_SV.logmsg(l_module_name,'Could not locked the records for stop',WSH_DEBUG_SV.C_EXCEP_LEVEL);

372:
373: WHEN trip_stop_locked THEN
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'Could not locked the records for stop',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name);
378: END IF;
379: IF detail_rec_csr%ISOPEN THEN
380: CLOSE detail_rec_csr;

Line 377: WSH_DEBUG_SV.pop(l_module_name);

373: WHEN trip_stop_locked THEN
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'Could not locked the records for stop',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name);
378: END IF;
379: IF detail_rec_csr%ISOPEN THEN
380: CLOSE detail_rec_csr;
381: END IF;

Line 398: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

394: , p_count => x_msg_count
395: , p_data => x_msg_data
396: );
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
400: END IF;
401: rollback to savepoint Complete_Inv_Interface;
402:

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

395: , p_data => x_msg_data
396: );
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
400: END IF;
401: rollback to savepoint Complete_Inv_Interface;
402:
403: WHEN OTHERS THEN

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

415: , p_count => x_msg_count
416: , p_data => x_msg_data
417: );
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
420: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
422: END IF;
423: rollback to savepoint Complete_Inv_Interface;

Line 420: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

416: , p_data => x_msg_data
417: );
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
420: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
422: END IF;
423: rollback to savepoint Complete_Inv_Interface;
424:

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

417: );
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
420: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
422: END IF;
423: rollback to savepoint Complete_Inv_Interface;
424:
425: END Complete_Inv_Interface;