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

Line 176: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

172: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
173:
174: IF l_debug_on IS NULL
175: THEN
176: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
177: END IF;
178: IF NOT FND_API.Compatible_API_Call
179: (
180: l_api_version_number,

Line 194: wsh_debug_sv.push (l_module_name);

190: FND_MSG_PUB.initialize;
191: END IF;
192:
193: IF l_debug_on THEN
194: wsh_debug_sv.push (l_module_name);
195: wsh_debug_sv.log (l_module_name,'Action_code',p_action_code);
196: wsh_debug_sv.log (l_module_name,'p_org_info_tab.count',p_org_info_tab.count);
197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);
198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);

Line 195: wsh_debug_sv.log (l_module_name,'Action_code',p_action_code);

191: END IF;
192:
193: IF l_debug_on THEN
194: wsh_debug_sv.push (l_module_name);
195: wsh_debug_sv.log (l_module_name,'Action_code',p_action_code);
196: wsh_debug_sv.log (l_module_name,'p_org_info_tab.count',p_org_info_tab.count);
197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);
198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);
199: wsh_debug_sv.log (l_module_name,'Carrier_service_id',p_carrier_service_id);

Line 196: wsh_debug_sv.log (l_module_name,'p_org_info_tab.count',p_org_info_tab.count);

192:
193: IF l_debug_on THEN
194: wsh_debug_sv.push (l_module_name);
195: wsh_debug_sv.log (l_module_name,'Action_code',p_action_code);
196: wsh_debug_sv.log (l_module_name,'p_org_info_tab.count',p_org_info_tab.count);
197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);
198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);
199: wsh_debug_sv.log (l_module_name,'Carrier_service_id',p_carrier_service_id);
200: wsh_debug_sv.log (l_module_name,'Ship_method_code',p_ship_method_code);

Line 197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);

193: IF l_debug_on THEN
194: wsh_debug_sv.push (l_module_name);
195: wsh_debug_sv.log (l_module_name,'Action_code',p_action_code);
196: wsh_debug_sv.log (l_module_name,'p_org_info_tab.count',p_org_info_tab.count);
197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);
198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);
199: wsh_debug_sv.log (l_module_name,'Carrier_service_id',p_carrier_service_id);
200: wsh_debug_sv.log (l_module_name,'Ship_method_code',p_ship_method_code);
201: wsh_debug_sv.log (l_module_name,'Ship_method',p_ship_method);

Line 198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);

194: wsh_debug_sv.push (l_module_name);
195: wsh_debug_sv.log (l_module_name,'Action_code',p_action_code);
196: wsh_debug_sv.log (l_module_name,'p_org_info_tab.count',p_org_info_tab.count);
197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);
198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);
199: wsh_debug_sv.log (l_module_name,'Carrier_service_id',p_carrier_service_id);
200: wsh_debug_sv.log (l_module_name,'Ship_method_code',p_ship_method_code);
201: wsh_debug_sv.log (l_module_name,'Ship_method',p_ship_method);
202: END IF;

Line 199: wsh_debug_sv.log (l_module_name,'Carrier_service_id',p_carrier_service_id);

195: wsh_debug_sv.log (l_module_name,'Action_code',p_action_code);
196: wsh_debug_sv.log (l_module_name,'p_org_info_tab.count',p_org_info_tab.count);
197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);
198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);
199: wsh_debug_sv.log (l_module_name,'Carrier_service_id',p_carrier_service_id);
200: wsh_debug_sv.log (l_module_name,'Ship_method_code',p_ship_method_code);
201: wsh_debug_sv.log (l_module_name,'Ship_method',p_ship_method);
202: END IF;
203:

Line 200: wsh_debug_sv.log (l_module_name,'Ship_method_code',p_ship_method_code);

196: wsh_debug_sv.log (l_module_name,'p_org_info_tab.count',p_org_info_tab.count);
197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);
198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);
199: wsh_debug_sv.log (l_module_name,'Carrier_service_id',p_carrier_service_id);
200: wsh_debug_sv.log (l_module_name,'Ship_method_code',p_ship_method_code);
201: wsh_debug_sv.log (l_module_name,'Ship_method',p_ship_method);
202: END IF;
203:
204: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 201: wsh_debug_sv.log (l_module_name,'Ship_method',p_ship_method);

197: wsh_debug_sv.log (l_module_name,'Carrier_id',p_carrier_id);
198: wsh_debug_sv.log (l_module_name,'Freight_code',p_freight_code);
199: wsh_debug_sv.log (l_module_name,'Carrier_service_id',p_carrier_service_id);
200: wsh_debug_sv.log (l_module_name,'Ship_method_code',p_ship_method_code);
201: wsh_debug_sv.log (l_module_name,'Ship_method',p_ship_method);
202: END IF;
203:
204: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
205: l_carrier_id := p_carrier_id ;

Line 272: wsh_debug_sv.log(l_module_name,'l_org_info_tab.count',l_org_info_tab.count);

268: --}
269: END IF;
270:
271: IF l_debug_on THEN
272: wsh_debug_sv.log(l_module_name,'l_org_info_tab.count',l_org_info_tab.count);
273: END IF;
274:
275: --Organization validation
276: IF ( l_org_info_tab.count > 0 ) THEN

Line 282: wsh_debug_sv.logmsg(l_module_name,'Calling wsh_util_validate.validate_org',WSH_DEBUG_SV.C_PROC_LEVEL);

278:
279: FOR i in l_org_info_tab.FIRST..l_org_info_tab.LAST LOOP
280: --{
281: IF l_debug_on THEN
282: wsh_debug_sv.logmsg(l_module_name,'Calling wsh_util_validate.validate_org',WSH_DEBUG_SV.C_PROC_LEVEL);
283: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_id',l_org_info_tab(i).org_id);
284: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_code',l_org_info_tab(i).org_code);
285: END IF;
286:

Line 283: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_id',l_org_info_tab(i).org_id);

279: FOR i in l_org_info_tab.FIRST..l_org_info_tab.LAST LOOP
280: --{
281: IF l_debug_on THEN
282: wsh_debug_sv.logmsg(l_module_name,'Calling wsh_util_validate.validate_org',WSH_DEBUG_SV.C_PROC_LEVEL);
283: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_id',l_org_info_tab(i).org_id);
284: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_code',l_org_info_tab(i).org_code);
285: END IF;
286:
287: WSH_UTIL_VALIDATE.validate_org(

Line 284: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_code',l_org_info_tab(i).org_code);

280: --{
281: IF l_debug_on THEN
282: wsh_debug_sv.logmsg(l_module_name,'Calling wsh_util_validate.validate_org',WSH_DEBUG_SV.C_PROC_LEVEL);
283: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_id',l_org_info_tab(i).org_id);
284: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_code',l_org_info_tab(i).org_code);
285: END IF;
286:
287: WSH_UTIL_VALIDATE.validate_org(
288: p_org_id => l_org_info_tab(i).org_id, --Out param

Line 293: wsh_debug_sv.log(l_module_name,'Return Status After Calling wsh_util_validate.validate_org',l_return_status);

289: p_org_code => l_org_info_tab(i).org_code,
290: x_return_status => l_return_status );
291:
292: IF l_debug_on THEN
293: wsh_debug_sv.log(l_module_name,'Return Status After Calling wsh_util_validate.validate_org',l_return_status);
294: END IF;
295:
296: WSH_UTIL_CORE.api_post_call(
297: p_return_status => l_return_status,

Line 307: wsh_debug_sv.log(l_module_name,'Fetching wsh_carrier_services data for Carrier Service Id',l_carrier_service_id);

303: --Carrier service validation
304: IF (l_carrier_service_id IS NOT NULL ) THEN
305: --{
306: IF l_debug_on THEN
307: wsh_debug_sv.log(l_module_name,'Fetching wsh_carrier_services data for Carrier Service Id',l_carrier_service_id);
308: END IF;
309: OPEN c_check_carrier_ser_exists(l_carrier_service_id);
310: FETCH c_check_carrier_ser_exists INTO l_carrier_service_info_tab(1);
311:

Line 330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_validate.validate_ship_method',WSH_DEBUG_SV.C_PROC_LEVEL);

326: ELSIF ((l_ship_method_code IS NOT NULL ) OR (l_ship_method IS NOT NULL )) THEN
327: --{
328:
329: IF l_debug_on THEN
330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_validate.validate_ship_method',WSH_DEBUG_SV.C_PROC_LEVEL);
331: END IF;
332:
333: WSH_UTIL_VALIDATE.validate_ship_method(
334: p_ship_method_code => l_ship_method_code, --Out param

Line 339: wsh_debug_sv.log(l_module_name,'Return Status After Calling wsh_util_validate.validate_ship_method',l_return_status);

335: p_ship_method_name => l_ship_method, --Out param
336: x_return_status => l_return_status);
337:
338: IF l_debug_on THEN
339: wsh_debug_sv.log(l_module_name,'Return Status After Calling wsh_util_validate.validate_ship_method',l_return_status);
340: END IF;
341:
342: WSH_UTIL_CORE.api_post_call(
343: p_return_status => l_return_status,

Line 348: wsh_debug_sv.log(l_module_name,'Fetching wsh_carrier_services data for ship method code',l_ship_method_code);

344: x_num_warnings => l_num_warnings,
345: x_num_errors => l_num_errors);
346:
347: IF l_debug_on THEN
348: wsh_debug_sv.log(l_module_name,'Fetching wsh_carrier_services data for ship method code',l_ship_method_code);
349: END IF;
350:
351: --Fetch carrier_serivce_id and corresponding DFF.
352: OPEN c_check_carrier_sm_exists (l_ship_method_code);

Line 371: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_UTIL_VALIDATE.Validate_Freight_Code',WSH_DEBUG_SV.C_PROC_LEVEL);

367: --Carrier validation
368: ELSIF ((l_carrier_id IS NOT NULL ) OR (l_freight_code IS NOT NULL)) THEN
369: --{
370: IF l_debug_on THEN
371: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_UTIL_VALIDATE.Validate_Freight_Code',WSH_DEBUG_SV.C_PROC_LEVEL);
372: END IF;
373:
374: WSH_UTIL_VALIDATE.Validate_Freight_Code(
375: x_Carrier_id => l_carrier_id, --out param

Line 380: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_UTIL_VALIDATE.Validate_Freight_Code',l_return_status);

376: p_freight_code => l_freight_code,
377: x_return_status => l_return_status);
378:
379: IF l_debug_on THEN
380: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_UTIL_VALIDATE.Validate_Freight_Code',l_return_status);
381: END IF;
382:
383: WSH_UTIL_CORE.api_post_call(
384: p_return_status => l_return_status,

Line 429: wsh_debug_sv.log(l_module_name,'Carrier_service_id',l_carrier_service_info_tab(l_index).carrier_service_id);

425: -- removing the reference of previous buffer.
426: l_car_ser_out_rec := null;
427:
428: IF l_debug_on THEN
429: wsh_debug_sv.log(l_module_name,'Carrier_service_id',l_carrier_service_info_tab(l_index).carrier_service_id);
430: wsh_debug_sv.log(l_module_name,'Organization_id',l_rec_org_car_ser_tab.ORGANIZATION_ID);
431: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433:

Line 430: wsh_debug_sv.log(l_module_name,'Organization_id',l_rec_org_car_ser_tab.ORGANIZATION_ID);

426: l_car_ser_out_rec := null;
427:
428: IF l_debug_on THEN
429: wsh_debug_sv.log(l_module_name,'Carrier_service_id',l_carrier_service_info_tab(l_index).carrier_service_id);
430: wsh_debug_sv.log(l_module_name,'Organization_id',l_rec_org_car_ser_tab.ORGANIZATION_ID);
431: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433:
434: WSH_CARRIERS_GRP.Assign_Org_Carrier_Service(

Line 431: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',WSH_DEBUG_SV.C_PROC_LEVEL);

427:
428: IF l_debug_on THEN
429: wsh_debug_sv.log(l_module_name,'Carrier_service_id',l_carrier_service_info_tab(l_index).carrier_service_id);
430: wsh_debug_sv.log(l_module_name,'Organization_id',l_rec_org_car_ser_tab.ORGANIZATION_ID);
431: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433:
434: WSH_CARRIERS_GRP.Assign_Org_Carrier_Service(
435: p_api_version_number => p_api_version_number,

Line 448: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',l_return_status);

444: x_msg_count => l_msg_count,
445: x_msg_data => l_msg_data );
446:
447: IF l_debug_on THEN
448: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_CARRIERS_GRP.Assign_Org_Carrier_Service',l_return_status);
449: END IF;
450:
451: WSH_UTIL_CORE.api_post_call(
452: p_return_status => l_return_status,

Line 459: wsh_debug_sv.log(l_module_name,'x_car_out_rec_tab(' || To_Char (x_car_out_rec_tab.count) || ').carrier_service_id',x_car_out_rec_tab(x_car_out_rec_tab.count).carrier_service_id);

455:
456: x_car_out_rec_tab(x_car_out_rec_tab.count + 1) := l_car_ser_out_rec;
457:
458: IF l_debug_on THEN
459: wsh_debug_sv.log(l_module_name,'x_car_out_rec_tab(' || To_Char (x_car_out_rec_tab.count) || ').carrier_service_id',x_car_out_rec_tab(x_car_out_rec_tab.count).carrier_service_id);
460: wsh_debug_sv.log(l_module_name,'x_car_out_rec_tab(' || To_Char (x_car_out_rec_tab.count) || ').org_carrier_service_id',x_car_out_rec_tab(x_car_out_rec_tab.count).org_carrier_service_id);
461: END IF;
462: --}
463: END LOOP;

Line 460: wsh_debug_sv.log(l_module_name,'x_car_out_rec_tab(' || To_Char (x_car_out_rec_tab.count) || ').org_carrier_service_id',x_car_out_rec_tab(x_car_out_rec_tab.count).org_carrier_service_id);

456: x_car_out_rec_tab(x_car_out_rec_tab.count + 1) := l_car_ser_out_rec;
457:
458: IF l_debug_on THEN
459: wsh_debug_sv.log(l_module_name,'x_car_out_rec_tab(' || To_Char (x_car_out_rec_tab.count) || ').carrier_service_id',x_car_out_rec_tab(x_car_out_rec_tab.count).carrier_service_id);
460: wsh_debug_sv.log(l_module_name,'x_car_out_rec_tab(' || To_Char (x_car_out_rec_tab.count) || ').org_carrier_service_id',x_car_out_rec_tab(x_car_out_rec_tab.count).org_carrier_service_id);
461: END IF;
462: --}
463: END LOOP;
464: --Org Loop

Line 472: wsh_debug_sv.logmsg(l_module_name,' No eligible carrier services found ');

468: --} If l_carrier_service_info_tab.COUNT > 0
469: ELSE
470: --{
471: IF l_debug_on THEN
472: wsh_debug_sv.logmsg(l_module_name,'** No eligible carrier services found **');
473: END IF;
474: --}
475: END IF;
476: --}

Line 490: WSH_DEBUG_SV.pop(l_module_name);

486: p_count => x_msg_count,
487: p_data => x_msg_data );
488: --
489: IF l_debug_on THEN
490: WSH_DEBUG_SV.pop(l_module_name);
491: END IF;
492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN

Line 515: WSH_DEBUG_SV.logmsg(l_module_name,'Expected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

511: p_count => x_msg_count,
512: p_data => x_msg_data );
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'Expected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
517: END IF;
518: --
519: --}

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

512: p_data => x_msg_data );
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'Expected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
517: END IF;
518: --
519: --}
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

537: p_count => x_msg_count ,
538: p_data => x_msg_data );
539: --
540: IF l_debug_on THEN
541: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
543: END IF;
544: --}
545: WHEN OTHERS THEN

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

538: p_data => x_msg_data );
539: --
540: IF l_debug_on THEN
541: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
543: END IF;
544: --}
545: WHEN OTHERS THEN
546: --{

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

570: p_count => x_msg_count ,
571: p_data => x_msg_data );
572: --
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
575: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
576: END IF;
577: --}
578:

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

571: p_data => x_msg_data );
572: --
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
575: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
576: END IF;
577: --}
578:
579: END Assign_Org_Carrier_Service;