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 71: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

67: --
68: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
69: --
70: IF l_debug_on IS NULL THEN
71: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
72: END IF;
73:
74: IF l_debug_on THEN
75: WSH_DEBUG_SV.push(l_module_name);

Line 75: WSH_DEBUG_SV.push(l_module_name);

71: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
72: END IF;
73:
74: IF l_debug_on THEN
75: WSH_DEBUG_SV.push(l_module_name);
76: WSH_DEBUG_SV.log(l_module_name,'p_subinventory',p_subinventory);
77: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
78: END IF;
79:

Line 76: WSH_DEBUG_SV.log(l_module_name,'p_subinventory',p_subinventory);

72: END IF;
73:
74: IF l_debug_on THEN
75: WSH_DEBUG_SV.push(l_module_name);
76: WSH_DEBUG_SV.log(l_module_name,'p_subinventory',p_subinventory);
77: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
78: END IF;
79:
80: FOR k in 1..3 LOOP

Line 77: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);

73:
74: IF l_debug_on THEN
75: WSH_DEBUG_SV.push(l_module_name);
76: WSH_DEBUG_SV.log(l_module_name,'p_subinventory',p_subinventory);
77: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
78: END IF;
79:
80: FOR k in 1..3 LOOP
81:

Line 130: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name is : ' ||l_printer_name|| ' at Subinventory for concurrent Program is '||v_concurrent_program_name );

126: FETCH c_orgsub_printer into l_printer_name ;
127: CLOSE c_orgsub_printer;
128: --
129: IF l_debug_on THEN --{
130: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name is : ' ||l_printer_name|| ' at Subinventory for concurrent Program is '||v_concurrent_program_name );
131: END IF;
132: ---
133: if l_printer_name = '-1' and l_org_found = 0 then
134:

Line 147: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name is : ' ||l_printer_name|| ' at Organization for concurrent Program is '||v_concurrent_program_name );

143: FETCH c_org_printer into l_printer_name ;
144: CLOSE c_org_printer;
145: --
146: IF l_debug_on THEN --{
147: WSH_DEBUG_SV.logmsg(l_module_name, 'l_printer_name is : ' ||l_printer_name|| ' at Organization for concurrent Program is '||v_concurrent_program_name );
148: END IF;
149: --
150: end if ;
151:

Line 178: WSH_DEBUG_SV.pop(l_module_name);

174:
175: END LOOP;
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.pop(l_module_name);
179: END IF;
180: --
181: exception
182: when others then

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

183: x_error_message := 'Exception occurred in WSH_INV_INTEGRATION_GRP.Find_Printer';
184: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: --
186: IF l_debug_on THEN
187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
188: END IF;
189:
190: END Find_Printer ;
191:

Line 293: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

289: BEGIN
290: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
291:
292: IF l_debug_on IS NULL THEN
293: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
294: END IF;
295:
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);

Line 297: WSH_DEBUG_SV.push(l_module_name);

293: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
294: END IF;
295:
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);
298: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
299: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
300: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
301: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);

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

294: END IF;
295:
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);
298: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
299: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
300: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
301: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);

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

295:
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);
298: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
299: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
300: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
301: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);
303: END IF;

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

296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);
298: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
299: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
300: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
301: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);
303: END IF;
304:

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

297: WSH_DEBUG_SV.push(l_module_name);
298: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
299: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
300: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
301: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);
303: END IF;
304:
305: savepoint Complete_Inv_Interface;

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

298: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
299: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
300: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
301: WSH_DEBUG_SV.log(l_module_name,'p_txn_header_id',p_txn_header_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_txn_batch_id',p_txn_batch_id);
303: END IF;
304:
305: savepoint Complete_Inv_Interface;
306:

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

309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: IF l_debug_on THEN
313: WSH_DEBUG_SV.logmsg(l_module_name,'Done Compatible_API_Call');
314: END IF;
315:
316: -- Initialize message stack if required
317: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

318: FND_MSG_PUB.initialize;
319: END IF;
320:
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.logmsg(l_module_name,'Done FND_API.to_Boolean');
323: END IF;
324:
325: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
326:

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

331: l_det_rec.stop_id,
332: l_det_rec.delivery_detail_id;
333: l_row_count := detail_rec_csr%ROWCOUNT;
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.log(l_module_name,'No of Record fetch l_row_count',l_row_count);
336: END IF;
337: CLOSE detail_rec_csr;
338:
339: IF (l_row_count < 1 ) THEN

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

344:
345: l_stop_id := l_det_rec.stop_id(l_det_rec.stop_id.first);
346:
347: IF l_debug_on THEN
348: WSH_DEBUG_SV.log(l_module_name,'l_stop_id',l_stop_id);
349: END IF;
350:
351: FORALL i IN 1 ..l_row_count
352: UPDATE wsh_delivery_details

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

355:
356: l_row_count := SQL%ROWCOUNT;
357:
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.log(l_module_name,'No of Record Update to Y l_row_count',l_row_count);
360: END IF;
361:
362: /* Check if all the delivery details under the trip stop are interfaced to inventory and OM.
363: If yes, then update the pending_interface_flag of the trip to NULL.*/

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

377: FETCH c_lines_not_interfaced INTO l_temp_id;
378:
379: IF (c_lines_not_interfaced%NOTFOUND) THEN
380: IF l_debug_on THEN
381: WSH_DEBUG_SV.log(l_module_name,'All lines are Interface to INV and OM',l_temp_id);
382: END IF;
383:
384: UPDATE wsh_trip_stops
385: SET pending_interface_flag = NULL

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

387:
388: l_row_count := SQL%ROWCOUNT;
389:
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag update to NULL for stop',l_det_rec.stop_id(l_index));
392: END IF;
393: ELSE
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.log(l_module_name,'All lines are Not Interface to INV and OM',l_temp_id);

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

391: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag update to NULL for stop',l_det_rec.stop_id(l_index));
392: END IF;
393: ELSE
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.log(l_module_name,'All lines are Not Interface to INV and OM',l_temp_id);
396: END IF;
397: END IF;
398: CLOSE c_lines_not_interfaced;
399:

Line 421: WSH_DEBUG_SV.pop(l_module_name);

417: , p_count => x_msg_count
418: , p_data => x_msg_data);
419:
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.pop(l_module_name);
422: END IF;
423:
424: EXCEPTION
425: WHEN no_data_found THEN

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

424: EXCEPTION
425: WHEN no_data_found THEN
426: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'No Record found to complete interface',WSH_DEBUG_SV.C_EXCEP_LEVEL);
429: WSH_DEBUG_SV.pop(l_module_name);
430: END IF;
431:
432:

Line 429: WSH_DEBUG_SV.pop(l_module_name);

425: WHEN no_data_found THEN
426: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'No Record found to complete interface',WSH_DEBUG_SV.C_EXCEP_LEVEL);
429: WSH_DEBUG_SV.pop(l_module_name);
430: END IF;
431:
432:
433: WHEN trip_stop_locked THEN

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

432:
433: WHEN trip_stop_locked THEN
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name,'Could not locked the records for stop',WSH_DEBUG_SV.C_EXCEP_LEVEL);
437: WSH_DEBUG_SV.pop(l_module_name);
438: END IF;
439: IF detail_rec_csr%ISOPEN THEN
440: CLOSE detail_rec_csr;

Line 437: WSH_DEBUG_SV.pop(l_module_name);

433: WHEN trip_stop_locked THEN
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name,'Could not locked the records for stop',WSH_DEBUG_SV.C_EXCEP_LEVEL);
437: WSH_DEBUG_SV.pop(l_module_name);
438: END IF;
439: IF detail_rec_csr%ISOPEN THEN
440: CLOSE detail_rec_csr;
441: END IF;

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

454: , p_count => x_msg_count
455: , p_data => x_msg_data
456: );
457: IF l_debug_on THEN
458: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
459: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
460: END IF;
461: rollback to savepoint Complete_Inv_Interface;
462:

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

455: , p_data => x_msg_data
456: );
457: IF l_debug_on THEN
458: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
459: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
460: END IF;
461: rollback to savepoint Complete_Inv_Interface;
462:
463: WHEN OTHERS THEN

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

475: , p_count => x_msg_count
476: , p_data => x_msg_data
477: );
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
480: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
482: END IF;
483: rollback to savepoint Complete_Inv_Interface;

Line 480: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

476: , p_data => x_msg_data
477: );
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
480: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
482: END IF;
483: rollback to savepoint Complete_Inv_Interface;
484:

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

477: );
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
480: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
482: END IF;
483: rollback to savepoint Complete_Inv_Interface;
484:
485: END Complete_Inv_Interface;