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

Line 246: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

242:
243: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
244: IF l_debug_on IS NULL
245: THEN
246: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
247: END IF;
248:
249: IF p_batch_id IS NULL
250: THEN

Line 260: WSH_DEBUG_SV.push(l_module_name);

256: raise FND_API.G_EXC_ERROR;
257: END IF;
258:
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.push(l_module_name);
261: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
262: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
263: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
264: END IF;

Line 261: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);

257: END IF;
258:
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.push(l_module_name);
261: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
262: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
263: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
264: END IF;
265:

Line 262: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);

258:
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.push(l_module_name);
261: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
262: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
263: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
264: END IF;
265:
266:

Line 263: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

259: IF l_debug_on THEN
260: WSH_DEBUG_SV.push(l_module_name);
261: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
262: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
263: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
264: END IF;
265:
266:
267: l_commit := FND_API.G_FALSE;

Line 272: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Get_Batch_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

268: l_completion_status := 'NORMAL';
269:
270: -- get delivery selection parameters for the batch
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Get_Batch_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
273: END IF;
274:
275: Get_Batch_Parameters(
276: p_batch_id => p_batch_id,

Line 283: WSH_DEBUG_SV.logmsg(l_module_name, 'Got Batch Parameters' );

279:
280: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
281: THEN
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.logmsg(l_module_name, 'Got Batch Parameters' );
284: END IF;
285: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
286: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
287: THEN

Line 293: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_MDC_SRS.Get_Batch_Parameters');

289: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
290: errbuf := 'Error occurred in WSH_MDC_SRS.Get_Batch_Parameters';
291: retcode := '2';
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_MDC_SRS.Get_Batch_Parameters');
294: END IF;
295: raise FND_API.G_EXC_ERROR;
296: END IF;
297:

Line 301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type',WSH_DEBUG_SV.C_PROC_LEVEL);

297:
298:
299: -- check if the organization is TPW org
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type',WSH_DEBUG_SV.C_PROC_LEVEL);
302: END IF;
303:
304: l_org_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_type(
305: p_organization_id => l_sel_del_attr.org_id,

Line 311: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type returned with warnings');

307:
308: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
309: THEN
310: IF l_debug_on THEN
311: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type returned with warnings');
312: END IF;
313: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
314: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
315: THEN

Line 321: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type');

317: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type');
318: errbuf := 'Error occurred in WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type';
319: retcode := '2';
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type');
322: END IF;
323: raise FND_API.G_EXC_ERROR;
324: END IF;
325:

Line 327: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization type '||l_org_type);

323: raise FND_API.G_EXC_ERROR;
324: END IF;
325:
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization type '||l_org_type);
328: END IF;
329:
330: IF l_org_type = 'TPW'
331: THEN

Line 343: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization CMS value '||l_org_type);

339: FETCH Get_Cms_Org_Type INTO l_org_type;
340: CLOSE Get_Cms_Org_Type;
341:
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization CMS value '||l_org_type);
344: END IF;
345:
346: IF l_org_type = 'Y'
347: THEN

Line 353: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Get_Deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

349: END IF;
350:
351: -- get deliveries for the set of parameters
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Get_Deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
354: END IF;
355:
356: Get_Deliveries(
357: p_sel_del_attr => l_sel_del_attr,

Line 365: WSH_DEBUG_SV.logmsg(l_module_name, 'Got Deliveries' );

361:
362: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
363: THEN
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.logmsg(l_module_name, 'Got Deliveries' );
366: END IF;
367: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
368: THEN
369: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_MDC_SRS.Get_Deliveries');

Line 417: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type',WSH_DEBUG_SV.C_PROC_LEVEL);

413: IF(l_cms_org_flag)
414: THEN
415:
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type',WSH_DEBUG_SV.C_PROC_LEVEL);
418: END IF;
419:
420: l_del_cms := null;
421: l_del_cms := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

Line 430: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type returned with warnings');

426: );
427: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
428: THEN
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type returned with warnings');
431: END IF;
432: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
433: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
434: THEN

Line 484: WSH_DEBUG_SV.logmsg(l_module_name,'Unassigning delivery '||l_delivery_tab(i).delivery_id||' from it''s delivery leg');

480: FETCH Get_Trip INTO l_trip_id;
481: CLOSE Get_Trip;
482:
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.logmsg(l_module_name,'Unassigning delivery '||l_delivery_tab(i).delivery_id||' from it''s delivery leg');
485: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);
486: END IF;
487: l_unassign_trip_tab(1) := Copy_Record(l_delivery_tab(i), l_delivery_addnl_attr_tab(i));
488:

Line 485: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);

481: CLOSE Get_Trip;
482:
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.logmsg(l_module_name,'Unassigning delivery '||l_delivery_tab(i).delivery_id||' from it''s delivery leg');
485: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);
486: END IF;
487: l_unassign_trip_tab(1) := Copy_Record(l_delivery_tab(i), l_delivery_addnl_attr_tab(i));
488:
489: l_action_params.action_code := 'UNASSIGN-TRIP';

Line 508: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_tab(i).delivery_id||' unassigned successfully');

504:
505: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
506: THEN
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_tab(i).delivery_id||' unassigned successfully');
509: END IF;
510: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
511: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
512: THEN

Line 520: WSH_DEBUG_SV.logmsg(l_module_name, l_message);

516: l_message := fnd_msg_pub.get(m,'F');
517: l_message := replace(l_message,chr(0),' ');
518: WSH_UTIL_CORE.PrintMsg(l_message);
519: IF l_debug_on THEN
520: WSH_DEBUG_SV.logmsg(l_module_name, l_message);
521: END IF;
522: END LOOP;
523:
524: fnd_msg_pub.delete_msg();

Line 542: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_tab(i).delivery_id||' unassigned from trip with warnings');

538:
539: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
540: THEN
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_tab(i).delivery_id||' unassigned from trip with warnings');
543: FOR m in 1..l_msg_count
544: LOOP
545: l_message := fnd_msg_pub.get(m,'F');
546: l_message := replace(l_message,chr(0),' ');

Line 547: WSH_DEBUG_SV.logmsg(l_module_name, l_message);

543: FOR m in 1..l_msg_count
544: LOOP
545: l_message := fnd_msg_pub.get(m,'F');
546: l_message := replace(l_message,chr(0),' ');
547: WSH_DEBUG_SV.logmsg(l_module_name, l_message);
548: END LOOP;
549: END IF;
550: fnd_msg_pub.delete_msg();
551: END IF;

Line 573: WSH_DEBUG_SV.logmsg(l_module_name,'Checking if FTE is installed');

569: END IF;
570:
571:
572: IF l_debug_on THEN
573: WSH_DEBUG_SV.logmsg(l_module_name,'Checking if FTE is installed');
574: END IF;
575:
576: IF WSH_UTIL_CORE.fte_is_installed = 'Y'
577: THEN

Line 583: WSH_DEBUG_SV.logmsg(l_module_name,'FTE is installed');

579: -- group the deliveries based on constraints
580: WSH_UTIL_CORE.PrintMsg('Grouping deliveries based on constraints');
581:
582: IF l_debug_on THEN
583: WSH_DEBUG_SV.logmsg(l_module_name,'FTE is installed');
584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);
585: END IF;
586:
587: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(

Line 584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);

580: WSH_UTIL_CORE.PrintMsg('Grouping deliveries based on constraints');
581:
582: IF l_debug_on THEN
583: WSH_DEBUG_SV.logmsg(l_module_name,'FTE is installed');
584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);
585: END IF;
586:
587: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
588: p_init_msg_list => l_init_msg_list,

Line 611: WSH_DEBUG_SV.logmsg(l_module_name, 'validate constraints call successful');

607: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
608: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
609: THEN
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.logmsg(l_module_name, 'validate constraints call successful');
612: WSH_DEBUG_SV.logmsg(l_module_name, 'Deliveries grouped based on constraints');
613: END IF;
614: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
615: THEN

Line 612: WSH_DEBUG_SV.logmsg(l_module_name, 'Deliveries grouped based on constraints');

608: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
609: THEN
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.logmsg(l_module_name, 'validate constraints call successful');
612: WSH_DEBUG_SV.logmsg(l_module_name, 'Deliveries grouped based on constraints');
613: END IF;
614: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
615: THEN
616: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy');

Line 623: WSH_DEBUG_SV.logmsg(l_module_name, l_message);

619: l_message := fnd_msg_pub.get(m,'F');
620: l_message := replace(l_message,chr(0),' ');
621: WSH_UTIL_CORE.PrintMsg(l_message);
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.logmsg(l_module_name, l_message);
624: END IF;
625: END LOOP;
626:
627: fnd_msg_pub.delete_msg();

Line 636: WSH_DEBUG_SV.logmsg(l_module_name, 'validate constraints call successful with following warnings');

632: raise FND_API.G_EXC_ERROR;
633: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
634: THEN
635: IF l_debug_on THEN
636: WSH_DEBUG_SV.logmsg(l_module_name, 'validate constraints call successful with following warnings');
637: FOR m in 1..l_msg_count
638: LOOP
639: l_message := fnd_msg_pub.get(m,'F');
640: l_message := replace(l_message,chr(0),' ');

Line 641: WSH_DEBUG_SV.logmsg(l_module_name, l_message);

637: FOR m in 1..l_msg_count
638: LOOP
639: l_message := fnd_msg_pub.get(m,'F');
640: l_message := replace(l_message,chr(0),' ');
641: WSH_DEBUG_SV.logmsg(l_module_name, l_message);
642: END LOOP;
643: END IF;
644: fnd_msg_pub.delete_msg();
645: END IF;

Line 691: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Get_Grouping_Attrs',WSH_DEBUG_SV.C_PROC_LEVEL);

687:
688:
689: -- get grouping rule
690: IF l_debug_on THEN
691: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Get_Grouping_Attrs',WSH_DEBUG_SV.C_PROC_LEVEL);
692: END IF;
693:
694: Get_Grouping_Attrs(
695: p_grouping_rule_id => l_sel_del_attr.rule_id,

Line 702: WSH_DEBUG_SV.logmsg(l_module_name, 'Got Grouping Attrs' );

698:
699: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
700: THEN
701: IF l_debug_on THEN
702: WSH_DEBUG_SV.logmsg(l_module_name, 'Got Grouping Attrs' );
703: END IF;
704: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
705: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
706: THEN

Line 717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Set_Intermediate_Location',WSH_DEBUG_SV.C_PROC_LEVEL);

713:
714:
715: -- set the intermediate location for the deliveries
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Set_Intermediate_Location',WSH_DEBUG_SV.C_PROC_LEVEL);
718: END IF;
719:
720: Set_Intermediate_Location(
721: p_consol_loc_id => l_sel_del_attr.consol_ship_to_loc_id,

Line 732: WSH_DEBUG_SV.logmsg(l_module_name, 'Set Intermediate call successful');

728:
729: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
730: THEN
731: IF l_debug_on THEN
732: WSH_DEBUG_SV.logmsg(l_module_name, 'Set Intermediate call successful');
733: END IF;
734: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
735: THEN
736: IF l_debug_on THEN

Line 737: WSH_DEBUG_SV.logmsg(l_module_name, 'Set Intermediate Location call completed with warnings');

733: END IF;
734: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
735: THEN
736: IF l_debug_on THEN
737: WSH_DEBUG_SV.logmsg(l_module_name, 'Set Intermediate Location call completed with warnings');
738: END IF;
739: l_completion_status := 'WARNING';
740: retcode := '1';
741: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

Line 768: WSH_DEBUG_SV.logmsg(l_module_name, 'Creating hash values with hash power = '||l_hash_power);

764: l_valid_hash := TRUE;
765: l_hash_power := l_hash_power + 1;
766: l_hash_size := power(2,l_hash_power);
767: IF l_debug_on THEN
768: WSH_DEBUG_SV.logmsg(l_module_name, 'Creating hash values with hash power = '||l_hash_power);
769: END IF;
770: l_hash_base := 1;
771: l_group_tab.DELETE;
772: j := 0;

Line 781: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Get_Hash_Value',WSH_DEBUG_SV.C_PROC_LEVEL);

777: --{
778: -- get hash value for the record
779: --{
780: IF l_debug_on THEN
781: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Get_Hash_Value',WSH_DEBUG_SV.C_PROC_LEVEL);
782: END IF;
783: Get_Hash_Value(
784: x_delivery_rec => l_delivery_tab(i),
785: x_delivery_addnl_attr_rec => l_delivery_addnl_attr_tab(i),

Line 796: WSH_DEBUG_SV.logmsg(l_module_name, 'Got Hash Value' );

792:
793: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
794: THEN
795: IF l_debug_on THEN
796: WSH_DEBUG_SV.logmsg(l_module_name, 'Got Hash Value' );
797: END IF;
798: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
799: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
800: THEN

Line 822: WSH_DEBUG_SV.logmsg(l_module_name, 'Hash value not unique. Rebuilding hash table with bigger hash size');

818: THEN
819: --{
820: -- hash value not unique
821: IF l_debug_on THEN
822: WSH_DEBUG_SV.logmsg(l_module_name, 'Hash value not unique. Rebuilding hash table with bigger hash size');
823: END IF;
824: WSH_UTIL_CORE.PrintMsg('Hash conflict. Dropping and rebuilding rule based grouping.');
825: l_valid_hash := FALSE;
826: EXIT;

Line 831: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_addnl_attr_tab(i).delivery_id||' added to existing hash group '||l_group_tab(l_group_index).group_id);

827: --}
828: END IF;
829: -- add delivery to existing group
830: IF l_debug_on THEN
831: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_addnl_attr_tab(i).delivery_id||' added to existing hash group '||l_group_tab(l_group_index).group_id);
832: END IF;
833: WSH_UTIL_CORE.PrintMsg(' Delivery: '||l_delivery_addnl_attr_tab(i).delivery_id||', Hash Group: '||l_group_tab(l_group_index).group_id);
834: l_delivery_addnl_attr_tab(i).group_id := l_group_tab(l_group_index).group_id;
835: l_del_index := l_group_tab(l_group_index).delivery_list.LAST;

Line 845: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_addnl_attr_tab(i).delivery_id||' added to new hash group '||l_group_tab(l_group_index).group_id);

841: l_group_tab(l_group_index).hash_string := l_delivery_addnl_attr_tab(i).hash_string;
842: SELECT WSH_DELIVERY_GROUP_S.nextval INTO l_group_tab(l_group_index).group_id FROM DUAL;
843: l_delivery_addnl_attr_tab(i).group_id := l_group_tab(l_group_index).group_id;
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_addnl_attr_tab(i).delivery_id||' added to new hash group '||l_group_tab(l_group_index).group_id);
846: END IF;
847: WSH_UTIL_CORE.PrintMsg(' Delivery: '||l_delivery_addnl_attr_tab(i).delivery_id||', Hash Group: '||l_group_tab(l_group_index).group_id);
848: l_group_tab(l_group_index).delivery_list(0) := l_delivery_addnl_attr_tab(i).delivery_id;
849: --}

Line 863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Create_Consolidations',WSH_DEBUG_SV.C_PROC_LEVEL);

859:
860:
861: -- create consolidations
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Create_Consolidations',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: Create_Consolidations(
866: x_delivery_tab => l_delivery_tab,
867: x_delivery_addnl_attr_tab => l_delivery_addnl_attr_tab,

Line 881: WSH_DEBUG_SV.logmsg(l_module_name, 'Create Consolidations Successful');

877:
878: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
879: THEN
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name, 'Create Consolidations Successful');
882: END IF;
883: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
884: THEN
885: IF l_debug_on THEN

Line 886: WSH_DEBUG_SV.logmsg(l_module_name, 'Create Consolidations completed with warnings');

882: END IF;
883: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
884: THEN
885: IF l_debug_on THEN
886: WSH_DEBUG_SV.logmsg(l_module_name, 'Create Consolidations completed with warnings');
887: END IF;
888: l_completion_status := 'WARNING';
889: retcode := '1';
890:

Line 906: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsolidation trips');

902: -- create deconsolidation trips
903: IF(l_sel_del_attr.create_deconsol_trips_flag = 'Y')
904: THEN
905: IF l_debug_on THEN
906: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsolidation trips');
907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Create_Deconsol_Trips',WSH_DEBUG_SV.C_PROC_LEVEL);
908: END IF;
909:
910: Create_Deconsol_Trips(

Line 907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Create_Deconsol_Trips',WSH_DEBUG_SV.C_PROC_LEVEL);

903: IF(l_sel_del_attr.create_deconsol_trips_flag = 'Y')
904: THEN
905: IF l_debug_on THEN
906: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsolidation trips');
907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Create_Deconsol_Trips',WSH_DEBUG_SV.C_PROC_LEVEL);
908: END IF;
909:
910: Create_Deconsol_Trips(
911: x_delivery_tab => l_delivery_tab,

Line 921: WSH_DEBUG_SV.logmsg(l_module_name, 'Create Deconsolidation Trips Successful');

917:
918: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
919: THEN
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.logmsg(l_module_name, 'Create Deconsolidation Trips Successful');
922: END IF;
923: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
924: THEN
925: IF l_debug_on THEN

Line 926: WSH_DEBUG_SV.logmsg(l_module_name, 'Create Deconsolidation Trips completed with warnings');

922: END IF;
923: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
924: THEN
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.logmsg(l_module_name, 'Create Deconsolidation Trips completed with warnings');
927: END IF;
928: l_completion_status := 'WARNING';
929: retcode := '1';
930: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

Line 947: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION',WSH_DEBUG_SV.C_PROC_LEVEL);

943: IF(l_sel_del_attr.route_trips_flag = 'Y')
944: THEN
945: WSH_UTIL_CORE.PrintMsg('Routing the trips created');
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION',WSH_DEBUG_SV.C_PROC_LEVEL);
948: END IF;
949: /*
950: WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION(
951: p_init_msg_list => l_init_msg_list,

Line 976: WSH_DEBUG_SV.logmsg(l_module_name, 'Routing Trips Successful');

972:
973: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
974: THEN
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name, 'Routing Trips Successful');
977: END IF;
978: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
979: THEN
980: IF l_debug_on THEN

Line 981: WSH_DEBUG_SV.logmsg(l_module_name, 'Routing Trips completed with warnings');

977: END IF;
978: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
979: THEN
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.logmsg(l_module_name, 'Routing Trips completed with warnings');
982: END IF;
983: FOR m in 1..l_msg_count
984: LOOP
985: l_message := fnd_msg_pub.get(m,'F');

Line 989: WSH_DEBUG_SV.logmsg(l_module_name, l_message);

985: l_message := fnd_msg_pub.get(m,'F');
986: l_message := replace(l_message,chr(0),' ');
987: WSH_UTIL_CORE.PrintMsg(l_message);
988: IF l_debug_on THEN
989: WSH_DEBUG_SV.logmsg(l_module_name, l_message);
990: END IF;
991: END LOOP;
992:
993: fnd_msg_pub.delete_msg();

Line 1007: WSH_DEBUG_SV.logmsg(l_module_name, l_message);

1003: l_message := fnd_msg_pub.get(m,'F');
1004: l_message := replace(l_message,chr(0),' ');
1005: WSH_UTIL_CORE.PrintMsg(l_message);
1006: IF l_debug_on THEN
1007: WSH_DEBUG_SV.logmsg(l_module_name, l_message);
1008: END IF;
1009: END LOOP;
1010:
1011: fnd_msg_pub.delete_msg();

Line 1044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.Rate_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);

1040:
1041:
1042: WSH_UTIL_CORE.PrintMsg('Rating Deliveries');
1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.Rate_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
1045: END IF;
1046:
1047: l_rating_in_param_rec.seq_tender_flag := 'Y';
1048: l_rating_in_param_rec.action := 'RATE';

Line 1063: WSH_DEBUG_SV.logmsg(l_module_name, 'Rating Deliveries Successful');

1059:
1060: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1061: THEN
1062: IF l_debug_on THEN
1063: WSH_DEBUG_SV.logmsg(l_module_name, 'Rating Deliveries Successful');
1064: END IF;
1065: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
1066: THEN
1067: IF l_debug_on THEN

Line 1068: WSH_DEBUG_SV.logmsg(l_module_name, 'Rating Deliveries completed with warnings');

1064: END IF;
1065: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
1066: THEN
1067: IF l_debug_on THEN
1068: WSH_DEBUG_SV.logmsg(l_module_name, 'Rating Deliveries completed with warnings');
1069: END IF;
1070: l_completion_status := 'WARNING';
1071: retcode := '1';
1072: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

Line 1096: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed successfully');

1092: THEN
1093: retcode := '0';
1094: WSH_UTIL_CORE.PrintMsg('Delivery Consolidation completed successfully');
1095: IF l_debug_on THEN
1096: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed successfully');
1097: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);
1098: END IF;
1099: ELSIF l_completion_status = 'WARNING'
1100: THEN

Line 1097: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);

1093: retcode := '0';
1094: WSH_UTIL_CORE.PrintMsg('Delivery Consolidation completed successfully');
1095: IF l_debug_on THEN
1096: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed successfully');
1097: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);
1098: END IF;
1099: ELSIF l_completion_status = 'WARNING'
1100: THEN
1101: retcode := '1';

Line 1104: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed with warnings');

1100: THEN
1101: retcode := '1';
1102: WSH_UTIL_CORE.PrintMsg('Delivery Consolidation completed with warnings');
1103: IF l_debug_on THEN
1104: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed with warnings');
1105: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);
1106: END IF;
1107: END IF;
1108: COMMIT;

Line 1105: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);

1101: retcode := '1';
1102: WSH_UTIL_CORE.PrintMsg('Delivery Consolidation completed with warnings');
1103: IF l_debug_on THEN
1104: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed with warnings');
1105: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);
1106: END IF;
1107: END IF;
1108: COMMIT;
1109:

Line 1111: WSH_DEBUG_SV.pop(l_module_name);

1107: END IF;
1108: COMMIT;
1109:
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.pop(l_module_name);
1112: END IF;
1113:
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR

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

1124: END IF;
1125: retcode := '2';
1126:
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1129: END IF;
1130:
1131: WHEN l_exc_complete
1132: THEN

Line 1136: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed successfully');

1132: THEN
1133: retcode := '1';
1134: WSH_UTIL_CORE.PrintMsg('Delivery Consolidation completed successfully');
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed successfully');
1137: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);
1138: END IF;
1139:
1140: IF l_debug_on THEN

Line 1137: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);

1133: retcode := '1';
1134: WSH_UTIL_CORE.PrintMsg('Delivery Consolidation completed successfully');
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_MDC_SRS.Schedule_Batch completed successfully');
1137: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);
1138: END IF;
1139:
1140: IF l_debug_on THEN
1141: WSH_DEBUG_SV.pop(l_module_name);

Line 1141: WSH_DEBUG_SV.pop(l_module_name);

1137: WSH_DEBUG_SV.logmsg(l_module_name, 'Current time is '||SYSDATE);
1138: END IF;
1139:
1140: IF l_debug_on THEN
1141: WSH_DEBUG_SV.pop(l_module_name);
1142: END IF;
1143:
1144: WHEN OTHERS
1145: THEN

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

1152: retcode := '2';
1153:
1154:
1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1157: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1158: END IF;
1159:
1160: END Schedule_Batch;

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

1153:
1154:
1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1157: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1158: END IF;
1159:
1160: END Schedule_Batch;
1161:

Line 1223: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1219:
1220: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1221: IF l_debug_on IS NULL
1222: THEN
1223: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1224: END IF;
1225:
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.push(l_module_name);

Line 1227: WSH_DEBUG_SV.push(l_module_name);

1223: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1224: END IF;
1225:
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.push(l_module_name);
1228: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
1229: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1230: END IF;
1231:

Line 1228: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);

1224: END IF;
1225:
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.push(l_module_name);
1228: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
1229: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1230: END IF;
1231:
1232: OPEN Get_Batch(p_batch_id);

Line 1229: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

1225:
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.push(l_module_name);
1228: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
1229: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1230: END IF;
1231:
1232: OPEN Get_Batch(p_batch_id);
1233: FETCH Get_Batch INTO x_sel_del_attr;

Line 1237: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.org_id: '||x_sel_del_attr.org_id);

1233: FETCH Get_Batch INTO x_sel_del_attr;
1234: CLOSE Get_Batch;
1235:
1236: IF l_debug_on THEN
1237: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.org_id: '||x_sel_del_attr.org_id);
1238: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rule_id: '||x_sel_del_attr.rule_id);
1239: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_ship_to_loc_id: '||x_sel_del_attr.consol_ship_to_loc_id);
1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);
1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);

Line 1238: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rule_id: '||x_sel_del_attr.rule_id);

1234: CLOSE Get_Batch;
1235:
1236: IF l_debug_on THEN
1237: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.org_id: '||x_sel_del_attr.org_id);
1238: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rule_id: '||x_sel_del_attr.rule_id);
1239: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_ship_to_loc_id: '||x_sel_del_attr.consol_ship_to_loc_id);
1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);
1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);
1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);

Line 1239: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_ship_to_loc_id: '||x_sel_del_attr.consol_ship_to_loc_id);

1235:
1236: IF l_debug_on THEN
1237: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.org_id: '||x_sel_del_attr.org_id);
1238: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rule_id: '||x_sel_del_attr.rule_id);
1239: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_ship_to_loc_id: '||x_sel_del_attr.consol_ship_to_loc_id);
1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);
1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);
1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);

Line 1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);

1236: IF l_debug_on THEN
1237: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.org_id: '||x_sel_del_attr.org_id);
1238: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rule_id: '||x_sel_del_attr.rule_id);
1239: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_ship_to_loc_id: '||x_sel_del_attr.consol_ship_to_loc_id);
1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);
1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);
1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);

Line 1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);

1237: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.org_id: '||x_sel_del_attr.org_id);
1238: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rule_id: '||x_sel_del_attr.rule_id);
1239: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_ship_to_loc_id: '||x_sel_del_attr.consol_ship_to_loc_id);
1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);
1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);
1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);

Line 1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);

1238: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rule_id: '||x_sel_del_attr.rule_id);
1239: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_ship_to_loc_id: '||x_sel_del_attr.consol_ship_to_loc_id);
1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);
1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);
1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);
1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);

Line 1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);

1239: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_ship_to_loc_id: '||x_sel_del_attr.consol_ship_to_loc_id);
1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);
1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);
1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);
1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);
1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);

Line 1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);

1240: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.consol_shipto_override_flag: '||x_sel_del_attr.consol_shipto_override_flag);
1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);
1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);
1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);
1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);
1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);

Line 1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);

1241: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_from: '||x_sel_del_attr.delivery_name_from);
1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);
1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);
1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);
1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);
1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);

Line 1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);

1242: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.delivery_name_to: '||x_sel_del_attr.delivery_name_to);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);
1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);
1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);
1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);
1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);
1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);

Line 1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);

1243: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_starts_within: '||x_sel_del_attr.pick_up_DATE_starts_within);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);
1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);
1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);
1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);
1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);
1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);
1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);

Line 1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);

1244: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_up_DATE_ends_within: '||x_sel_del_attr.pick_up_DATE_ends_within);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);
1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);
1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);
1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);
1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);
1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);
1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);
1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);

Line 1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);

1245: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_starts_within: '||x_sel_del_attr.drop_off_DATE_starts_within);
1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);
1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);
1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);
1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);
1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);
1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);
1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);
1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);

Line 1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);

1246: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.drop_off_DATE_ends_within: '||x_sel_del_attr.drop_off_DATE_ends_within);
1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);
1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);
1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);
1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);
1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);
1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);
1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);
1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);

Line 1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);

1247: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.pick_release_batch_id: '||x_sel_del_attr.pick_release_batch_id);
1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);
1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);
1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);
1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);
1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);
1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);
1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);
1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);

Line 1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);

1248: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.customer_id: '||x_sel_del_attr.customer_id);
1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);
1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);
1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);
1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);
1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);
1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);
1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);
1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);

Line 1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);

1249: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.fob_code: '||x_sel_del_attr.fob_code);
1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);
1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);
1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);
1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);
1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);
1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);
1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);
1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);

Line 1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);

1250: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.freight_terms_code: '||x_sel_del_attr.freight_terms_code);
1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);
1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);
1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);
1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);
1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);
1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);
1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);
1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);

Line 1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);

1251: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.carrier_id: '||x_sel_del_attr.carrier_id);
1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);
1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);
1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);
1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);
1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);
1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);
1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);

Line 1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);

1252: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.mode_of_transport: '||x_sel_del_attr.mode_of_transport);
1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);
1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);
1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);
1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);
1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);
1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);
1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);

Line 1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);

1253: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.service_level: '||x_sel_del_attr.service_level);
1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);
1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);
1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);
1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);
1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);
1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);

Line 1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);

1254: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.loading_sequence: '||x_sel_del_attr.loading_sequence);
1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);
1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);
1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);
1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);
1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);
1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);

Line 1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);

1255: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.intmed_ship_to_loc_id: '||x_sel_del_attr.intmed_ship_to_loc_id);
1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);
1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);
1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);
1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);
1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);
1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);

Line 1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);

1256: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_loc_id: '||x_sel_del_attr.ulti_ship_to_loc_id);
1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);
1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);
1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);
1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);
1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);
1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);

Line 1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);

1257: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_region_id: '||x_sel_del_attr.ulti_ship_to_region_id);
1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);
1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);
1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);
1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);
1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);
1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);

Line 1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);

1258: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_from: '||x_sel_del_attr.ulti_ship_to_zip_from);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);
1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);
1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);
1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);
1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);
1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);
1266: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.trip_name_prefix: '||x_sel_del_attr.trip_name_prefix);

Line 1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);

1259: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zip_to: '||x_sel_del_attr.ulti_ship_to_zip_to);
1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);
1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);
1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);
1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);
1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);
1266: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.trip_name_prefix: '||x_sel_del_attr.trip_name_prefix);
1267: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight: '||x_sel_del_attr.max_trip_weight);

Line 1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);

1260: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.ulti_ship_to_zone_id: '||x_sel_del_attr.ulti_ship_to_zone_id);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);
1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);
1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);
1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);
1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);
1266: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.trip_name_prefix: '||x_sel_del_attr.trip_name_prefix);
1267: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight: '||x_sel_del_attr.max_trip_weight);
1268: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight_uom: '||x_sel_del_attr.max_trip_weight_uom);

Line 1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);

1261: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_staged_del_flag: '||x_sel_del_attr.inc_staged_del_flag);
1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);
1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);
1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);
1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);
1266: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.trip_name_prefix: '||x_sel_del_attr.trip_name_prefix);
1267: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight: '||x_sel_del_attr.max_trip_weight);
1268: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight_uom: '||x_sel_del_attr.max_trip_weight_uom);
1269: END IF;

Line 1266: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.trip_name_prefix: '||x_sel_del_attr.trip_name_prefix);

1262: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.inc_del_assgnd_trip_flag: '||x_sel_del_attr.inc_del_assgnd_trip_flag);
1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);
1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);
1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);
1266: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.trip_name_prefix: '||x_sel_del_attr.trip_name_prefix);
1267: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight: '||x_sel_del_attr.max_trip_weight);
1268: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight_uom: '||x_sel_del_attr.max_trip_weight_uom);
1269: END IF;
1270:

Line 1267: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight: '||x_sel_del_attr.max_trip_weight);

1263: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.create_deconsol_trips_flag: '||x_sel_del_attr.create_deconsol_trips_flag);
1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);
1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);
1266: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.trip_name_prefix: '||x_sel_del_attr.trip_name_prefix);
1267: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight: '||x_sel_del_attr.max_trip_weight);
1268: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight_uom: '||x_sel_del_attr.max_trip_weight_uom);
1269: END IF;
1270:
1271: IF l_debug_on THEN

Line 1268: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight_uom: '||x_sel_del_attr.max_trip_weight_uom);

1264: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.route_trips_flag: '||x_sel_del_attr.route_trips_flag);
1265: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.rate_trips_flag: '||x_sel_del_attr.rate_trips_flag);
1266: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.trip_name_prefix: '||x_sel_del_attr.trip_name_prefix);
1267: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight: '||x_sel_del_attr.max_trip_weight);
1268: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight_uom: '||x_sel_del_attr.max_trip_weight_uom);
1269: END IF;
1270:
1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.pop(l_module_name);

Line 1272: WSH_DEBUG_SV.pop(l_module_name);

1268: WSH_DEBUG_SV.logmsg(l_module_name,'x_sel_del_attr.max_trip_weight_uom: '||x_sel_del_attr.max_trip_weight_uom);
1269: END IF;
1270:
1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.pop(l_module_name);
1273: END IF;
1274: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1275: EXCEPTION
1276: WHEN OTHERS

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

1275: EXCEPTION
1276: WHEN OTHERS
1277: THEN
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1280: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1281: END IF;
1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1283: END Get_Batch_Parameters;

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

1276: WHEN OTHERS
1277: THEN
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1280: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1281: END IF;
1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1283: END Get_Batch_Parameters;
1284:

Line 1321: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1317:
1318: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1319: IF l_debug_on IS NULL
1320: THEN
1321: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1322: END IF;
1323:
1324: IF l_debug_on THEN
1325: WSH_DEBUG_SV.push(l_module_name);

Line 1325: WSH_DEBUG_SV.push(l_module_name);

1321: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1322: END IF;
1323:
1324: IF l_debug_on THEN
1325: WSH_DEBUG_SV.push(l_module_name);
1326: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1327:
1328: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.org_id :',p_sel_del_attr.org_id);
1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);

Line 1326: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

1322: END IF;
1323:
1324: IF l_debug_on THEN
1325: WSH_DEBUG_SV.push(l_module_name);
1326: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1327:
1328: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.org_id :',p_sel_del_attr.org_id);
1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);
1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);

Line 1328: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.org_id :',p_sel_del_attr.org_id);

1324: IF l_debug_on THEN
1325: WSH_DEBUG_SV.push(l_module_name);
1326: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1327:
1328: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.org_id :',p_sel_del_attr.org_id);
1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);
1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);
1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);
1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);

Line 1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);

1325: WSH_DEBUG_SV.push(l_module_name);
1326: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1327:
1328: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.org_id :',p_sel_del_attr.org_id);
1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);
1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);
1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);
1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);
1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);

Line 1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);

1326: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1327:
1328: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.org_id :',p_sel_del_attr.org_id);
1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);
1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);
1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);
1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);
1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);
1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);

Line 1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);

1327:
1328: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.org_id :',p_sel_del_attr.org_id);
1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);
1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);
1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);
1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);
1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);
1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);
1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);

Line 1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);

1328: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.org_id :',p_sel_del_attr.org_id);
1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);
1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);
1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);
1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);
1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);
1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);
1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);
1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);

Line 1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);

1329: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rule_id :',p_sel_del_attr.rule_id);
1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);
1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);
1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);
1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);
1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);
1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);
1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);
1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);

Line 1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);

1330: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_ship_to_loc_id :',p_sel_del_attr.consol_ship_to_loc_id);
1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);
1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);
1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);
1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);
1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);
1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);
1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);
1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);

Line 1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);

1331: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.consol_shipto_override_flag :',p_sel_del_attr.consol_shipto_override_flag);
1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);
1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);
1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);
1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);
1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);
1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);
1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);
1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);

Line 1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);

1332: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_from :',p_sel_del_attr.delivery_name_from);
1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);
1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);
1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);
1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);
1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);
1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);
1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);
1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);

Line 1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);

1333: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.delivery_name_to :',p_sel_del_attr.delivery_name_to);
1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);
1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);
1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);
1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);
1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);
1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);
1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);
1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);

Line 1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);

1334: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_starts_within :',p_sel_del_attr.pick_up_DATE_starts_within);
1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);
1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);
1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);
1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);
1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);
1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);
1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);
1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);

Line 1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);

1335: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_up_DATE_ends_within :',p_sel_del_attr.pick_up_DATE_ends_within);
1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);
1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);
1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);
1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);
1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);
1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);
1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);
1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);

Line 1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);

1336: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_starts_within :',p_sel_del_attr.drop_off_DATE_starts_within);
1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);
1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);
1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);
1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);
1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);
1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);
1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);
1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);

Line 1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);

1337: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.drop_off_DATE_ends_within :',p_sel_del_attr.drop_off_DATE_ends_within);
1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);
1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);
1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);
1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);
1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);
1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);
1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);
1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);

Line 1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);

1338: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.pick_release_batch_id :',p_sel_del_attr.pick_release_batch_id);
1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);
1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);
1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);
1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);
1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);
1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);
1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);
1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);

Line 1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);

1339: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.customer_id :',p_sel_del_attr.customer_id);
1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);
1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);
1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);
1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);
1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);
1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);
1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);
1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);

Line 1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);

1340: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.fob_code :',p_sel_del_attr.fob_code);
1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);
1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);
1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);
1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);
1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);
1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);
1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);
1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);

Line 1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);

1341: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.freight_terms_code :',p_sel_del_attr.freight_terms_code);
1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);
1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);
1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);
1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);
1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);
1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);
1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);
1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);

Line 1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);

1342: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.carrier_id :',p_sel_del_attr.carrier_id);
1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);
1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);
1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);
1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);
1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);
1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);
1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);
1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);

Line 1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);

1343: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.mode_of_transport :',p_sel_del_attr.mode_of_transport);
1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);
1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);
1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);
1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);
1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);
1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);
1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);
1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);

Line 1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);

1344: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.service_level :',p_sel_del_attr.service_level);
1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);
1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);
1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);
1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);
1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);
1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);
1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);
1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);

Line 1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);

1345: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.loading_sequence :',p_sel_del_attr.loading_sequence);
1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);
1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);
1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);
1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);
1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);
1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);
1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);
1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);

Line 1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);

1346: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.intmed_ship_to_loc_id :',p_sel_del_attr.intmed_ship_to_loc_id);
1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);
1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);
1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);
1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);
1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);
1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);
1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);
1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);

Line 1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);

1347: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_loc_id :',p_sel_del_attr.ulti_ship_to_loc_id);
1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);
1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);
1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);
1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);
1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);
1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);
1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);
1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);

Line 1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);

1348: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_region_id :',p_sel_del_attr.ulti_ship_to_region_id);
1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);
1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);
1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);
1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);
1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);
1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);
1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);
1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);

Line 1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);

1349: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_from :',p_sel_del_attr.ulti_ship_to_zip_from);
1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);
1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);
1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);
1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);
1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);
1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);
1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);
1357: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.trip_name_prefix :',p_sel_del_attr.trip_name_prefix);

Line 1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);

1350: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zip_to :',p_sel_del_attr.ulti_ship_to_zip_to);
1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);
1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);
1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);
1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);
1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);
1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);
1357: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.trip_name_prefix :',p_sel_del_attr.trip_name_prefix);
1358: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight :',p_sel_del_attr.max_trip_weight);

Line 1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);

1351: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.ulti_ship_to_zone_id :',p_sel_del_attr.ulti_ship_to_zone_id);
1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);
1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);
1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);
1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);
1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);
1357: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.trip_name_prefix :',p_sel_del_attr.trip_name_prefix);
1358: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight :',p_sel_del_attr.max_trip_weight);
1359: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight_uom :',p_sel_del_attr.max_trip_weight_uom);

Line 1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);

1352: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_staged_del_flag :',p_sel_del_attr.inc_staged_del_flag);
1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);
1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);
1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);
1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);
1357: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.trip_name_prefix :',p_sel_del_attr.trip_name_prefix);
1358: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight :',p_sel_del_attr.max_trip_weight);
1359: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight_uom :',p_sel_del_attr.max_trip_weight_uom);
1360: END IF;

Line 1357: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.trip_name_prefix :',p_sel_del_attr.trip_name_prefix);

1353: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.inc_del_assgnd_trip_flag :',p_sel_del_attr.inc_del_assgnd_trip_flag);
1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);
1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);
1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);
1357: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.trip_name_prefix :',p_sel_del_attr.trip_name_prefix);
1358: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight :',p_sel_del_attr.max_trip_weight);
1359: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight_uom :',p_sel_del_attr.max_trip_weight_uom);
1360: END IF;
1361:

Line 1358: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight :',p_sel_del_attr.max_trip_weight);

1354: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.create_deconsol_trips_flag :',p_sel_del_attr.create_deconsol_trips_flag);
1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);
1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);
1357: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.trip_name_prefix :',p_sel_del_attr.trip_name_prefix);
1358: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight :',p_sel_del_attr.max_trip_weight);
1359: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight_uom :',p_sel_del_attr.max_trip_weight_uom);
1360: END IF;
1361:
1362:

Line 1359: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight_uom :',p_sel_del_attr.max_trip_weight_uom);

1355: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.route_trips_flag :',p_sel_del_attr.route_trips_flag);
1356: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.rate_trips_flag :',p_sel_del_attr.rate_trips_flag);
1357: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.trip_name_prefix :',p_sel_del_attr.trip_name_prefix);
1358: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight :',p_sel_del_attr.max_trip_weight);
1359: WSH_DEBUG_SV.log(l_module_name,'p_sel_del_attr.max_trip_weight_uom :',p_sel_del_attr.max_trip_weight_uom);
1360: END IF;
1361:
1362:
1363: l_select_clause := 'SELECT WND.DELIVERY_ID, WND.NAME, WND.ORGANIZATION_ID, WND.STATUS_CODE, WND.PLANNED_FLAG, WND.INITIAL_PICKUP_DATE,';

Line 1610: WSH_DEBUG_SV.logmsg(l_module_name,'Query built : '||l_query);

1606:
1607: l_query := l_select_clause||l_from_clause||l_where_clause;
1608:
1609: IF l_debug_on THEN
1610: WSH_DEBUG_SV.logmsg(l_module_name,'Query built : '||l_query);
1611: END IF;
1612:
1613:
1614: IF l_debug_on THEN

Line 1615: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.OpenDynamicCursor',WSH_DEBUG_SV.C_PROC_LEVEL);

1611: END IF;
1612:
1613:
1614: IF l_debug_on THEN
1615: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.OpenDynamicCursor',WSH_DEBUG_SV.C_PROC_LEVEL);
1616: END IF;
1617:
1618: WSH_UTIL_CORE.OpenDynamicCursor(c_deliveries, l_query, l_col_tab);
1619:

Line 1621: WSH_DEBUG_SV.logmsg(l_module_name,'Dynamic cursor open');

1617:
1618: WSH_UTIL_CORE.OpenDynamicCursor(c_deliveries, l_query, l_col_tab);
1619:
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'Dynamic cursor open');
1622: END IF;
1623:
1624: LOOP
1625: --{

Line 1673: WSH_DEBUG_SV.pop(l_module_name);

1669: CLOSE c_deliveries;
1670:
1671:
1672: IF l_debug_on THEN
1673: WSH_DEBUG_SV.pop(l_module_name);
1674: END IF;
1675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1676:
1677: EXCEPTION

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

1677: EXCEPTION
1678: WHEN OTHERS
1679: THEN
1680: IF l_debug_on THEN
1681: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1683: END IF;
1684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1685: END Get_Deliveries;

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

1678: WHEN OTHERS
1679: THEN
1680: IF l_debug_on THEN
1681: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1683: END IF;
1684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1685: END Get_Deliveries;
1686:

Line 1737: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1733:
1734: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1735: IF l_debug_on IS NULL
1736: THEN
1737: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1738: END IF;
1739:
1740: IF l_debug_on THEN
1741: WSH_DEBUG_SV.push(l_module_name);

Line 1741: WSH_DEBUG_SV.push(l_module_name);

1737: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1738: END IF;
1739:
1740: IF l_debug_on THEN
1741: WSH_DEBUG_SV.push(l_module_name);
1742: WSH_DEBUG_SV.log(l_module_name,'p_consol_loc_id',p_consol_loc_id);
1743: WSH_DEBUG_SV.log(l_module_name,'p_override_ship_to_flag',p_override_ship_to_flag);
1744: WSH_DEBUG_SV.log(l_module_name,'p_rule_zone_id',p_rule_zone_id);
1745: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

Line 1742: WSH_DEBUG_SV.log(l_module_name,'p_consol_loc_id',p_consol_loc_id);

1738: END IF;
1739:
1740: IF l_debug_on THEN
1741: WSH_DEBUG_SV.push(l_module_name);
1742: WSH_DEBUG_SV.log(l_module_name,'p_consol_loc_id',p_consol_loc_id);
1743: WSH_DEBUG_SV.log(l_module_name,'p_override_ship_to_flag',p_override_ship_to_flag);
1744: WSH_DEBUG_SV.log(l_module_name,'p_rule_zone_id',p_rule_zone_id);
1745: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1746: END IF;

Line 1743: WSH_DEBUG_SV.log(l_module_name,'p_override_ship_to_flag',p_override_ship_to_flag);

1739:
1740: IF l_debug_on THEN
1741: WSH_DEBUG_SV.push(l_module_name);
1742: WSH_DEBUG_SV.log(l_module_name,'p_consol_loc_id',p_consol_loc_id);
1743: WSH_DEBUG_SV.log(l_module_name,'p_override_ship_to_flag',p_override_ship_to_flag);
1744: WSH_DEBUG_SV.log(l_module_name,'p_rule_zone_id',p_rule_zone_id);
1745: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1746: END IF;
1747:

Line 1744: WSH_DEBUG_SV.log(l_module_name,'p_rule_zone_id',p_rule_zone_id);

1740: IF l_debug_on THEN
1741: WSH_DEBUG_SV.push(l_module_name);
1742: WSH_DEBUG_SV.log(l_module_name,'p_consol_loc_id',p_consol_loc_id);
1743: WSH_DEBUG_SV.log(l_module_name,'p_override_ship_to_flag',p_override_ship_to_flag);
1744: WSH_DEBUG_SV.log(l_module_name,'p_rule_zone_id',p_rule_zone_id);
1745: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1746: END IF;
1747:
1748: WSH_UTIL_CORE.PrintMsg('Setting intermediate location for the deliveries');

Line 1745: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

1741: WSH_DEBUG_SV.push(l_module_name);
1742: WSH_DEBUG_SV.log(l_module_name,'p_consol_loc_id',p_consol_loc_id);
1743: WSH_DEBUG_SV.log(l_module_name,'p_override_ship_to_flag',p_override_ship_to_flag);
1744: WSH_DEBUG_SV.log(l_module_name,'p_rule_zone_id',p_rule_zone_id);
1745: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1746: END IF;
1747:
1748: WSH_UTIL_CORE.PrintMsg('Setting intermediate location for the deliveries');
1749: WSH_UTIL_CORE.PrintMsg(' Default intermediate location is '||p_consol_loc_id);

Line 1763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_deconsol',WSH_DEBUG_SV.C_PROC_LEVEL);

1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1760:
1761: -- call constraints API to set the intermediate location
1762: IF l_debug_on THEN
1763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_deconsol',WSH_DEBUG_SV.C_PROC_LEVEL);
1764: END IF;
1765:
1766: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_deconsol(
1767: p_init_msg_list => l_init_msg_list,

Line 1781: WSH_DEBUG_SV.logmsg(l_module_name, 'Intermediate location set successfully for the deliveries');

1777:
1778: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1779: THEN
1780: IF l_debug_on THEN
1781: WSH_DEBUG_SV.logmsg(l_module_name, 'Intermediate location set successfully for the deliveries');
1782: END IF;
1783: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
1784: THEN
1785: IF l_debug_on THEN

Line 1786: WSH_DEBUG_SV.logmsg(l_module_name, 'Intermediate location set with warnings');

1782: END IF;
1783: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
1784: THEN
1785: IF l_debug_on THEN
1786: WSH_DEBUG_SV.logmsg(l_module_name, 'Intermediate location set with warnings');
1787: END IF;
1788: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1789: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1790: THEN

Line 1797: WSH_DEBUG_SV.logmsg(l_module_name, l_message);

1793: LOOP
1794: l_message := fnd_msg_pub.get(m,'F');
1795: l_message := replace(l_message,chr(0),' ');
1796: IF l_debug_on THEN
1797: WSH_DEBUG_SV.logmsg(l_module_name, l_message);
1798: END IF;
1799: WSH_UTIL_CORE.PrintMsg(l_message);
1800: END LOOP;
1801:

Line 1823: WSH_DEBUG_SV.logmsg(l_module_name, 'Internal Location check for '||l_deconsol_output_tab(i).deconsol_location);

1819: x_delivery_tab(l_delivery_id).intmed_ship_to_location_id := l_deconsol_output_tab(i).deconsol_location;
1820:
1821: --check if the location is an internal location
1822: IF l_debug_on THEN
1823: WSH_DEBUG_SV.logmsg(l_module_name, 'Internal Location check for '||l_deconsol_output_tab(i).deconsol_location);
1824: END IF;
1825:
1826: l_int_loc := FALSE;
1827:

Line 1829: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LOCATIONS_PKG.convert_internal_cust_location',WSH_DEBUG_SV.C_PROC_LEVEL);

1825:
1826: l_int_loc := FALSE;
1827:
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LOCATIONS_PKG.convert_internal_cust_location',WSH_DEBUG_SV.C_PROC_LEVEL);
1830: END IF;
1831:
1832: WSH_LOCATIONS_PKG.convert_internal_cust_location(
1833: p_internal_cust_location_id => l_deconsol_output_tab(i).deconsol_location,

Line 1840: WSH_DEBUG_SV.logmsg(l_module_name, 'Internal location checked successfully');

1836:
1837: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1838: THEN
1839: IF l_debug_on THEN
1840: WSH_DEBUG_SV.logmsg(l_module_name, 'Internal location checked successfully');
1841: END IF;
1842: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
1843: THEN
1844: IF l_debug_on THEN

Line 1845: WSH_DEBUG_SV.logmsg(l_module_name, 'Internal location checked with warnings');

1841: END IF;
1842: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
1843: THEN
1844: IF l_debug_on THEN
1845: WSH_DEBUG_SV.logmsg(l_module_name, 'Internal location checked with warnings');
1846: END IF;
1847: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1848: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1849: THEN

Line 1851: WSH_DEBUG_SV.logmsg(l_module_name, 'Internal location check errored out');

1847: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1848: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1849: THEN
1850: IF l_debug_on THEN
1851: WSH_DEBUG_SV.logmsg(l_module_name, 'Internal location check errored out');
1852: END IF;
1853: --removing the delivery record from consolidation
1854: l_int_loc := TRUE;
1855: END IF;

Line 1861: WSH_DEBUG_SV.logmsg(l_module_name, 'Location '||l_deconsol_output_tab(i).deconsol_location||' is an internal location');

1857: IF l_dummy_loc IS NOT NULL
1858: THEN
1859: l_int_loc := TRUE;
1860: IF l_debug_on THEN
1861: WSH_DEBUG_SV.logmsg(l_module_name, 'Location '||l_deconsol_output_tab(i).deconsol_location||' is an internal location');
1862: END IF;
1863: END IF;
1864:
1865: -- Remove validation failed records and records with internal locations

Line 1883: WSH_DEBUG_SV.pop(l_module_name);

1879: i := l_deconsol_output_tab.NEXT(i);
1880: END LOOP;
1881:
1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.pop(l_module_name);
1884: END IF;
1885: EXCEPTION
1886: WHEN FND_API.G_EXC_ERROR
1887: THEN

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

1885: EXCEPTION
1886: WHEN FND_API.G_EXC_ERROR
1887: THEN
1888: IF l_debug_on THEN
1889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1890: END IF;
1891: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1892:
1893: WHEN OTHERS

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

1892:
1893: WHEN OTHERS
1894: THEN
1895: IF l_debug_on THEN
1896: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1897: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1898: END IF;
1899: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1900:

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

1893: WHEN OTHERS
1894: THEN
1895: IF l_debug_on THEN
1896: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1897: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1898: END IF;
1899: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1900:
1901: END Set_Intermediate_Location;

Line 1951: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1947:
1948: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1949: IF l_debug_on IS NULL
1950: THEN
1951: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1952: END IF;
1953:
1954: IF l_debug_on THEN
1955: WSH_DEBUG_SV.push(l_module_name);

Line 1955: WSH_DEBUG_SV.push(l_module_name);

1951: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1952: END IF;
1953:
1954: IF l_debug_on THEN
1955: WSH_DEBUG_SV.push(l_module_name);
1956: WSH_DEBUG_SV.log(l_module_name,'p_grouping_rule_id',p_grouping_rule_id);
1957: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1958: END IF;
1959:

Line 1956: WSH_DEBUG_SV.log(l_module_name,'p_grouping_rule_id',p_grouping_rule_id);

1952: END IF;
1953:
1954: IF l_debug_on THEN
1955: WSH_DEBUG_SV.push(l_module_name);
1956: WSH_DEBUG_SV.log(l_module_name,'p_grouping_rule_id',p_grouping_rule_id);
1957: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1958: END IF;
1959:
1960: OPEN Get_Attrs(p_grouping_rule_id);

Line 1957: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

1953:
1954: IF l_debug_on THEN
1955: WSH_DEBUG_SV.push(l_module_name);
1956: WSH_DEBUG_SV.log(l_module_name,'p_grouping_rule_id',p_grouping_rule_id);
1957: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1958: END IF;
1959:
1960: OPEN Get_Attrs(p_grouping_rule_id);
1961: FETCH Get_Attrs INTO x_group_by_flags;

Line 1971: WSH_DEBUG_SV.pop(l_module_name);

1967:
1968: WSH_UTIL_CORE.PrintMsg('Rule used for consolidation: '''||l_rule_name||'''');
1969:
1970: IF l_debug_on THEN
1971: WSH_DEBUG_SV.pop(l_module_name);
1972: END IF;
1973: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1974: EXCEPTION
1975: WHEN OTHERS

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

1974: EXCEPTION
1975: WHEN OTHERS
1976: THEN
1977: IF l_debug_on THEN
1978: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1979: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1980: END IF;
1981: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1982: END Get_Grouping_Attrs;

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

1975: WHEN OTHERS
1976: THEN
1977: IF l_debug_on THEN
1978: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1979: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1980: END IF;
1981: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1982: END Get_Grouping_Attrs;
1983:

Line 2042: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2038:
2039: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2040: IF l_debug_on IS NULL
2041: THEN
2042: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2043: END IF;
2044:
2045: IF l_debug_on THEN
2046: WSH_DEBUG_SV.push(l_module_name);

Line 2046: WSH_DEBUG_SV.push(l_module_name);

2042: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2043: END IF;
2044:
2045: IF l_debug_on THEN
2046: WSH_DEBUG_SV.push(l_module_name);
2047: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2048: WSH_DEBUG_SV.log(l_module_name,'x_delivery_rec.delivery_id :',x_delivery_rec.delivery_id);
2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);
2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);

Line 2047: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

2043: END IF;
2044:
2045: IF l_debug_on THEN
2046: WSH_DEBUG_SV.push(l_module_name);
2047: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2048: WSH_DEBUG_SV.log(l_module_name,'x_delivery_rec.delivery_id :',x_delivery_rec.delivery_id);
2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);
2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);
2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);

Line 2048: WSH_DEBUG_SV.log(l_module_name,'x_delivery_rec.delivery_id :',x_delivery_rec.delivery_id);

2044:
2045: IF l_debug_on THEN
2046: WSH_DEBUG_SV.push(l_module_name);
2047: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2048: WSH_DEBUG_SV.log(l_module_name,'x_delivery_rec.delivery_id :',x_delivery_rec.delivery_id);
2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);
2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);
2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);
2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);

Line 2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);

2045: IF l_debug_on THEN
2046: WSH_DEBUG_SV.push(l_module_name);
2047: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2048: WSH_DEBUG_SV.log(l_module_name,'x_delivery_rec.delivery_id :',x_delivery_rec.delivery_id);
2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);
2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);
2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);
2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);
2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);

Line 2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);

2046: WSH_DEBUG_SV.push(l_module_name);
2047: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2048: WSH_DEBUG_SV.log(l_module_name,'x_delivery_rec.delivery_id :',x_delivery_rec.delivery_id);
2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);
2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);
2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);
2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);
2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);
2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);

Line 2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);

2047: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2048: WSH_DEBUG_SV.log(l_module_name,'x_delivery_rec.delivery_id :',x_delivery_rec.delivery_id);
2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);
2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);
2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);
2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);
2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);
2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);
2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);

Line 2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);

2048: WSH_DEBUG_SV.log(l_module_name,'x_delivery_rec.delivery_id :',x_delivery_rec.delivery_id);
2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);
2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);
2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);
2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);
2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);
2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);
2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);
2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);

Line 2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);

2049: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_from :',p_group_by_flags.ship_from);
2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);
2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);
2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);
2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);
2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);
2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);
2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);
2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);

Line 2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);

2050: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.customer :',p_group_by_flags.customer);
2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);
2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);
2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);
2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);
2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);
2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);
2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);
2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);

Line 2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);

2051: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.intmed_ship_to :',p_group_by_flags.intmed_ship_to);
2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);
2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);
2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);
2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);
2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);
2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);
2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);
2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);

Line 2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);

2052: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.carrier :',p_group_by_flags.carrier);
2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);
2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);
2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);
2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);
2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);
2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);
2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);
2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);

Line 2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);

2053: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.mode_of_transport :',p_group_by_flags.mode_of_transport);
2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);
2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);
2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);
2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);
2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);
2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);
2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);
2061: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_city :',p_group_by_flags.ship_to_city);

Line 2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);

2054: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.service_level :',p_group_by_flags.service_level);
2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);
2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);
2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);
2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);
2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);
2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);
2061: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_city :',p_group_by_flags.ship_to_city);
2062: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_postal_code :',p_group_by_flags.ship_to_postal_code);

Line 2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);

2055: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.fob :',p_group_by_flags.fob);
2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);
2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);
2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);
2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);
2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);
2061: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_city :',p_group_by_flags.ship_to_city);
2062: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_postal_code :',p_group_by_flags.ship_to_postal_code);
2063: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_zone :',p_group_by_flags.ship_to_zone);

Line 2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);

2056: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.freight_terms :',p_group_by_flags.freight_terms);
2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);
2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);
2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);
2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);
2061: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_city :',p_group_by_flags.ship_to_city);
2062: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_postal_code :',p_group_by_flags.ship_to_postal_code);
2063: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_zone :',p_group_by_flags.ship_to_zone);
2064: END IF;

Line 2061: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_city :',p_group_by_flags.ship_to_city);

2057: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.loading_sequence :',p_group_by_flags.loading_sequence);
2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);
2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);
2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);
2061: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_city :',p_group_by_flags.ship_to_city);
2062: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_postal_code :',p_group_by_flags.ship_to_postal_code);
2063: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_zone :',p_group_by_flags.ship_to_zone);
2064: END IF;
2065:

Line 2062: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_postal_code :',p_group_by_flags.ship_to_postal_code);

2058: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_lcode :',p_group_by_flags.ship_to_code);
2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);
2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);
2061: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_city :',p_group_by_flags.ship_to_city);
2062: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_postal_code :',p_group_by_flags.ship_to_postal_code);
2063: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_zone :',p_group_by_flags.ship_to_zone);
2064: END IF;
2065:
2066: x_hash_string := x_delivery_rec.initial_pickup_location_id || '-' || x_delivery_rec.intmed_ship_to_location_id

Line 2063: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_zone :',p_group_by_flags.ship_to_zone);

2059: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_country :',p_group_by_flags.ship_to_country);
2060: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_state :',p_group_by_flags.ship_to_state);
2061: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_city :',p_group_by_flags.ship_to_city);
2062: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_postal_code :',p_group_by_flags.ship_to_postal_code);
2063: WSH_DEBUG_SV.log(l_module_name,'p_group_by_flags.ship_to_zone :',p_group_by_flags.ship_to_zone);
2064: END IF;
2065:
2066: x_hash_string := x_delivery_rec.initial_pickup_location_id || '-' || x_delivery_rec.intmed_ship_to_location_id
2067: || '-' || x_delivery_addnl_attr_rec.group_id;

Line 2175: WSH_DEBUG_SV.logmsg(l_module_name,'hash string :'||x_hash_string);

2171: END IF;
2172: END IF;
2173:
2174: IF l_debug_on THEN
2175: WSH_DEBUG_SV.logmsg(l_module_name,'hash string :'||x_hash_string);
2176: END IF;
2177:
2178: x_hash_value := dbms_utility.get_hash_value(
2179: name => x_hash_string,

Line 2184: WSH_DEBUG_SV.logmsg(l_module_name,'hash value :'||x_hash_value);

2180: base => p_hash_base,
2181: hash_size => p_hash_size );
2182:
2183: IF l_debug_on THEN
2184: WSH_DEBUG_SV.logmsg(l_module_name,'hash value :'||x_hash_value);
2185: END IF;
2186:
2187: IF l_debug_on THEN
2188: WSH_DEBUG_SV.pop(l_module_name);

Line 2188: WSH_DEBUG_SV.pop(l_module_name);

2184: WSH_DEBUG_SV.logmsg(l_module_name,'hash value :'||x_hash_value);
2185: END IF;
2186:
2187: IF l_debug_on THEN
2188: WSH_DEBUG_SV.pop(l_module_name);
2189: END IF;
2190: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2191:
2192: EXCEPTION

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

2192: EXCEPTION
2193: WHEN OTHERS
2194: THEN
2195: IF l_debug_on THEN
2196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2198: END IF;
2199: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2200:

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

2193: WHEN OTHERS
2194: THEN
2195: IF l_debug_on THEN
2196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2198: END IF;
2199: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2200:
2201: END Get_Hash_Value;

Line 2272: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2268:
2269: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2270: IF l_debug_on IS NULL
2271: THEN
2272: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2273: END IF;
2274:
2275: IF l_debug_on THEN
2276: WSH_DEBUG_SV.push(l_module_name);

Line 2276: WSH_DEBUG_SV.push(l_module_name);

2272: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2273: END IF;
2274:
2275: IF l_debug_on THEN
2276: WSH_DEBUG_SV.push(l_module_name);
2277: WSH_DEBUG_SV.log(l_module_name,'delivery count',x_delivery_tab.COUNT);
2278: WSH_DEBUG_SV.log(l_module_name,'group count',p_group_tab.COUNT);
2279: WSH_DEBUG_SV.log(l_module_name,'trip max weight',p_max_trip_weight);
2280: WSH_DEBUG_SV.log(l_module_name,'trip weight uom',p_max_weight_uom);

Line 2277: WSH_DEBUG_SV.log(l_module_name,'delivery count',x_delivery_tab.COUNT);

2273: END IF;
2274:
2275: IF l_debug_on THEN
2276: WSH_DEBUG_SV.push(l_module_name);
2277: WSH_DEBUG_SV.log(l_module_name,'delivery count',x_delivery_tab.COUNT);
2278: WSH_DEBUG_SV.log(l_module_name,'group count',p_group_tab.COUNT);
2279: WSH_DEBUG_SV.log(l_module_name,'trip max weight',p_max_trip_weight);
2280: WSH_DEBUG_SV.log(l_module_name,'trip weight uom',p_max_weight_uom);
2281: WSH_DEBUG_SV.log(l_module_name,'trip name prefix',p_trip_name_prefix);

Line 2278: WSH_DEBUG_SV.log(l_module_name,'group count',p_group_tab.COUNT);

2274:
2275: IF l_debug_on THEN
2276: WSH_DEBUG_SV.push(l_module_name);
2277: WSH_DEBUG_SV.log(l_module_name,'delivery count',x_delivery_tab.COUNT);
2278: WSH_DEBUG_SV.log(l_module_name,'group count',p_group_tab.COUNT);
2279: WSH_DEBUG_SV.log(l_module_name,'trip max weight',p_max_trip_weight);
2280: WSH_DEBUG_SV.log(l_module_name,'trip weight uom',p_max_weight_uom);
2281: WSH_DEBUG_SV.log(l_module_name,'trip name prefix',p_trip_name_prefix);
2282: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

Line 2279: WSH_DEBUG_SV.log(l_module_name,'trip max weight',p_max_trip_weight);

2275: IF l_debug_on THEN
2276: WSH_DEBUG_SV.push(l_module_name);
2277: WSH_DEBUG_SV.log(l_module_name,'delivery count',x_delivery_tab.COUNT);
2278: WSH_DEBUG_SV.log(l_module_name,'group count',p_group_tab.COUNT);
2279: WSH_DEBUG_SV.log(l_module_name,'trip max weight',p_max_trip_weight);
2280: WSH_DEBUG_SV.log(l_module_name,'trip weight uom',p_max_weight_uom);
2281: WSH_DEBUG_SV.log(l_module_name,'trip name prefix',p_trip_name_prefix);
2282: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2283: END IF;

Line 2280: WSH_DEBUG_SV.log(l_module_name,'trip weight uom',p_max_weight_uom);

2276: WSH_DEBUG_SV.push(l_module_name);
2277: WSH_DEBUG_SV.log(l_module_name,'delivery count',x_delivery_tab.COUNT);
2278: WSH_DEBUG_SV.log(l_module_name,'group count',p_group_tab.COUNT);
2279: WSH_DEBUG_SV.log(l_module_name,'trip max weight',p_max_trip_weight);
2280: WSH_DEBUG_SV.log(l_module_name,'trip weight uom',p_max_weight_uom);
2281: WSH_DEBUG_SV.log(l_module_name,'trip name prefix',p_trip_name_prefix);
2282: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2283: END IF;
2284:

Line 2281: WSH_DEBUG_SV.log(l_module_name,'trip name prefix',p_trip_name_prefix);

2277: WSH_DEBUG_SV.log(l_module_name,'delivery count',x_delivery_tab.COUNT);
2278: WSH_DEBUG_SV.log(l_module_name,'group count',p_group_tab.COUNT);
2279: WSH_DEBUG_SV.log(l_module_name,'trip max weight',p_max_trip_weight);
2280: WSH_DEBUG_SV.log(l_module_name,'trip weight uom',p_max_weight_uom);
2281: WSH_DEBUG_SV.log(l_module_name,'trip name prefix',p_trip_name_prefix);
2282: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2283: END IF;
2284:
2285: l_commit := FND_API.g_false;

Line 2282: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

2278: WSH_DEBUG_SV.log(l_module_name,'group count',p_group_tab.COUNT);
2279: WSH_DEBUG_SV.log(l_module_name,'trip max weight',p_max_trip_weight);
2280: WSH_DEBUG_SV.log(l_module_name,'trip weight uom',p_max_weight_uom);
2281: WSH_DEBUG_SV.log(l_module_name,'trip name prefix',p_trip_name_prefix);
2282: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2283: END IF;
2284:
2285: l_commit := FND_API.g_false;
2286: IF (p_max_trip_weight IS NOT NULL AND p_max_weight_uom IS NOT NULL)

Line 2296: WSH_DEBUG_SV.logmsg(l_module_name,'Consolidation Trip weight taken into consideration');

2292: IF l_trip_weight_flag
2293: THEN
2294: WSH_UTIL_CORE.PrintMsg(' Note: Consolidation trip weight threshold is '||p_max_trip_weight||' '||p_max_weight_uom);
2295: IF l_debug_on THEN
2296: WSH_DEBUG_SV.logmsg(l_module_name,'Consolidation Trip weight taken into consideration');
2297: END IF;
2298: ELSE
2299: IF l_debug_on THEN
2300: WSH_DEBUG_SV.logmsg(l_module_name,'Consolidation Trip weight ignored');

Line 2300: WSH_DEBUG_SV.logmsg(l_module_name,'Consolidation Trip weight ignored');

2296: WSH_DEBUG_SV.logmsg(l_module_name,'Consolidation Trip weight taken into consideration');
2297: END IF;
2298: ELSE
2299: IF l_debug_on THEN
2300: WSH_DEBUG_SV.logmsg(l_module_name,'Consolidation Trip weight ignored');
2301: END IF;
2302: END IF;
2303:
2304: l_failed_index := x_failed_records.LAST;

Line 2358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Add_For_Consolidation',WSH_DEBUG_SV.C_PROC_LEVEL);

2354:
2355: ELSE
2356: l_del_rec := Copy_Record(x_delivery_tab(l_d_id),x_delivery_addnl_attr_tab(l_d_id));
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Add_For_Consolidation',WSH_DEBUG_SV.C_PROC_LEVEL);
2359: END IF;
2360:
2361: Add_For_Consolidation(
2362: p_delivery_rec => l_del_rec,

Line 2374: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery added for consolidation');

2370:
2371: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2372: THEN
2373: IF l_debug_on THEN
2374: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery added for consolidation');
2375: END IF;
2376: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2377: THEN
2378: IF l_debug_on THEN

Line 2379: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery added with warning');

2375: END IF;
2376: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2377: THEN
2378: IF l_debug_on THEN
2379: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery added with warning');
2380: END IF;
2381: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2382: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2383: THEN

Line 2396: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Add_For_Consolidation',WSH_DEBUG_SV.C_PROC_LEVEL);

2392:
2393: ELSE -- weight flag is not checked
2394: l_del_rec := Copy_Record(x_delivery_tab(l_d_id),x_delivery_addnl_attr_tab(l_d_id));
2395: IF l_debug_on THEN
2396: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MDC_SRS.Add_For_Consolidation',WSH_DEBUG_SV.C_PROC_LEVEL);
2397: END IF;
2398:
2399: Add_For_Consolidation(
2400: p_delivery_rec => l_del_rec,

Line 2412: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery added for consolidation');

2408:
2409: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2410: THEN
2411: IF l_debug_on THEN
2412: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery added for consolidation');
2413: END IF;
2414: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2415: THEN
2416: IF l_debug_on THEN

Line 2417: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery added with warning');

2413: END IF;
2414: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2415: THEN
2416: IF l_debug_on THEN
2417: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery added with warning');
2418: END IF;
2419: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2420: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2421: THEN

Line 2449: WSH_DEBUG_SV.logmsg(l_module_name,'Creating consolidation delivery for consolidation no. '||l_consol_tab(k).consol_index);

2445: --{
2446:
2447: -- Create consol deliveries
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'Creating consolidation delivery for consolidation no. '||l_consol_tab(k).consol_index);
2450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
2451: END IF;
2452:
2453: WSH_DELIVERIES_GRP.Delivery_ACTION(

Line 2450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

2446:
2447: -- Create consol deliveries
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'Creating consolidation delivery for consolidation no. '||l_consol_tab(k).consol_index);
2450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
2451: END IF;
2452:
2453: WSH_DELIVERIES_GRP.Delivery_ACTION(
2454: p_api_version_number => l_api_version_number,

Line 2468: WSH_DEBUG_SV.logmsg(l_module_name, 'Consolidation Created successfully');

2464:
2465: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2466: THEN
2467: IF l_debug_on THEN
2468: WSH_DEBUG_SV.logmsg(l_module_name, 'Consolidation Created successfully');
2469: END IF;
2470: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2471: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2472: THEN

Line 2487: WSH_DEBUG_SV.logmsg(l_module_name, 'Created consolidations with following warnings');

2483: raise FND_API.G_EXC_ERROR;
2484: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2485: THEN
2486: IF l_debug_on THEN
2487: WSH_DEBUG_SV.logmsg(l_module_name, 'Created consolidations with following warnings');
2488: FOR i in 1..l_mesg_count
2489: LOOP
2490: l_message := fnd_msg_pub.get(m,'F');
2491: l_message := replace(l_message,chr(0),' ');

Line 2492: WSH_DEBUG_SV.logmsg(l_module_name, l_message);

2488: FOR i in 1..l_mesg_count
2489: LOOP
2490: l_message := fnd_msg_pub.get(m,'F');
2491: l_message := replace(l_message,chr(0),' ');
2492: WSH_DEBUG_SV.logmsg(l_module_name, l_message);
2493: END LOOP;
2494: END IF;
2495: fnd_msg_pub.delete_msg();
2496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2522: WSH_DEBUG_SV.pop(l_module_name);

2518: --}
2519: END LOOP; -- end loop for table of groups
2520:
2521: IF l_debug_on THEN
2522: WSH_DEBUG_SV.pop(l_module_name);
2523: END IF;
2524: EXCEPTION
2525: WHEN FND_API.G_EXC_ERROR
2526: THEN

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

2525: WHEN FND_API.G_EXC_ERROR
2526: THEN
2527: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Consolidation');
2528: IF l_debug_on THEN
2529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2530: END IF;
2531: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2532: WHEN OTHERS
2533: THEN

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

2534: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
2535: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Consolidation');
2536: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2537: IF l_debug_on THEN
2538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2540: END IF;
2541:
2542: END Create_Consolidations;

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

2535: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Consolidation');
2536: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2537: IF l_debug_on THEN
2538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2540: END IF;
2541:
2542: END Create_Consolidations;
2543:

Line 2613: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2609:
2610: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2611: IF l_debug_on IS NULL
2612: THEN
2613: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2614: END IF;
2615:
2616: IF l_debug_on THEN
2617: WSH_DEBUG_SV.push(l_module_name);

Line 2617: WSH_DEBUG_SV.push(l_module_name);

2613: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2614: END IF;
2615:
2616: IF l_debug_on THEN
2617: WSH_DEBUG_SV.push(l_module_name);
2618: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2619: END IF;
2620:
2621: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2618: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

2614: END IF;
2615:
2616: IF l_debug_on THEN
2617: WSH_DEBUG_SV.push(l_module_name);
2618: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2619: END IF;
2620:
2621: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2622: WSH_UTIL_CORE.PrintMsg('Creating deconsolidation trips');

Line 2642: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip for delivery '||l_del_id);

2638:
2639: SAVEPOINT CREATE_TRIP;
2640: l_del_id := x_delivery_tab(i).delivery_id;
2641: IF l_debug_on THEN
2642: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip for delivery '||l_del_id);
2643: END IF;
2644:
2645: OPEN Get_Intermediate_Dropoff_Date(p_consol_trip_id(x_delivery_addnl_attr_tab(i).consol_index));
2646: FETCH Get_Intermediate_Dropoff_Date INTO x_delivery_addnl_attr_tab(i).intermediate_pickup_date;

Line 2664: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');

2660: l_trip_info_tab.DELETE;
2661:
2662: l_commit := FND_API.g_false;
2663: IF l_debug_on THEN
2664: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
2665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2666: END IF;
2667:
2668: WSH_TRIPS_GRP.Create_Update_Trip(

Line 2665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

2661:
2662: l_commit := FND_API.g_false;
2663: IF l_debug_on THEN
2664: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
2665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2666: END IF;
2667:
2668: WSH_TRIPS_GRP.Create_Update_Trip(
2669: p_api_version_number => l_api_version_number,

Line 2683: WSH_DEBUG_SV.logmsg(l_module_name, 'Created trip succesfully');

2679:
2680: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2681: THEN
2682: IF l_debug_on THEN
2683: WSH_DEBUG_SV.logmsg(l_module_name, 'Created trip succesfully');
2684: END IF;
2685: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2686: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2687: THEN

Line 2694: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2690: FOR m in 1..l_msg_count
2691: LOOP
2692: l_message := fnd_msg_pub.get(m,'F');
2693: l_message := replace(l_message,chr(0),' ');
2694: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2695: END LOOP;
2696: END IF;
2697: fnd_msg_pub.delete_msg();
2698: raise FND_API.G_EXC_ERROR;

Line 2703: WSH_DEBUG_SV.logmsg(l_module_name,'Trip created with warnings');

2699:
2700: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2701: THEN
2702: IF l_debug_on THEN
2703: WSH_DEBUG_SV.logmsg(l_module_name,'Trip created with warnings');
2704: FOR m in 1..l_msg_count
2705: LOOP
2706: l_message := fnd_msg_pub.get(m,'F');
2707: l_message := replace(l_message,chr(0),' ');

Line 2708: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2704: FOR m in 1..l_msg_count
2705: LOOP
2706: l_message := fnd_msg_pub.get(m,'F');
2707: l_message := replace(l_message,chr(0),' ');
2708: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2709: END LOOP;
2710: END IF;
2711: fnd_msg_pub.delete_msg();
2712: END IF;

Line 2731: WSH_DEBUG_SV.logmsg(l_module_name,'Renaming deconsol trip, attaching prefix '||p_trip_name_prefix);

2727: l_trip_info_rec.name := l_trip_name;
2728: l_trip_info_tab(0) := l_trip_info_rec;
2729:
2730: IF l_debug_on THEN
2731: WSH_DEBUG_SV.logmsg(l_module_name,'Renaming deconsol trip, attaching prefix '||p_trip_name_prefix);
2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2733: END IF;
2734:
2735:

Line 2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

2728: l_trip_info_tab(0) := l_trip_info_rec;
2729:
2730: IF l_debug_on THEN
2731: WSH_DEBUG_SV.logmsg(l_module_name,'Renaming deconsol trip, attaching prefix '||p_trip_name_prefix);
2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2733: END IF;
2734:
2735:
2736: WSH_TRIPS_GRP.Create_Update_Trip(

Line 2751: WSH_DEBUG_SV.logmsg(l_module_name, 'Renamed trip succesfully');

2747:
2748: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2749: THEN
2750: IF l_debug_on THEN
2751: WSH_DEBUG_SV.logmsg(l_module_name, 'Renamed trip succesfully');
2752: END IF;
2753: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2754: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2755: THEN

Line 2762: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2758: FOR m in 1..l_msg_count
2759: LOOP
2760: l_message := fnd_msg_pub.get(m,'F');
2761: l_message := replace(l_message,chr(0),' ');
2762: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2763: END LOOP;
2764: END IF;
2765: fnd_msg_pub.delete_msg();
2766: raise FND_API.G_EXC_ERROR;

Line 2771: WSH_DEBUG_SV.logmsg(l_module_name,'Trip renamed with warnings');

2767:
2768: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2769: THEN
2770: IF l_debug_on THEN
2771: WSH_DEBUG_SV.logmsg(l_module_name,'Trip renamed with warnings');
2772: FOR m in 1..l_msg_count
2773: LOOP
2774: l_message := fnd_msg_pub.get(m,'F');
2775: l_message := replace(l_message,chr(0),' ');

Line 2776: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2772: FOR m in 1..l_msg_count
2773: LOOP
2774: l_message := fnd_msg_pub.get(m,'F');
2775: l_message := replace(l_message,chr(0),' ');
2776: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2777: END LOOP;
2778: END IF;
2779: fnd_msg_pub.delete_msg();
2780: END IF;

Line 2819: WSH_DEBUG_SV.logmsg(l_module_name, 'Trip unplanned succesfully');

2815:
2816: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2817: THEN
2818: IF l_debug_on THEN
2819: WSH_DEBUG_SV.logmsg(l_module_name, 'Trip unplanned succesfully');
2820: END IF;
2821: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2822: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2823: THEN

Line 2830: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2826: FOR m in 1..l_msg_count
2827: LOOP
2828: l_message := fnd_msg_pub.get(m,'F');
2829: l_message := replace(l_message,chr(0),' ');
2830: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2831: END LOOP;
2832: END IF;
2833: fnd_msg_pub.delete_msg();
2834: raise FND_API.G_EXC_ERROR;

Line 2839: WSH_DEBUG_SV.logmsg(l_module_name,'Trip unplanned with warnings');

2835:
2836: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2837: THEN
2838: IF l_debug_on THEN
2839: WSH_DEBUG_SV.logmsg(l_module_name,'Trip unplanned with warnings');
2840: FOR m in 1..l_msg_count
2841: LOOP
2842: l_message := fnd_msg_pub.get(m,'F');
2843: l_message := replace(l_message,chr(0),' ');

Line 2844: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2840: FOR m in 1..l_msg_count
2841: LOOP
2842: l_message := fnd_msg_pub.get(m,'F');
2843: l_message := replace(l_message,chr(0),' ');
2844: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2845: END LOOP;
2846: END IF;
2847: fnd_msg_pub.delete_msg();
2848: END IF;

Line 2864: WSH_DEBUG_SV.logmsg(l_module_name,'Creating pickup stop');

2860: l_stop_in_rec.caller := 'WSH';
2861: l_stop_in_rec.phase := NULL;
2862: l_stop_in_rec.action_code := 'CREATE';
2863: IF l_debug_on THEN
2864: WSH_DEBUG_SV.logmsg(l_module_name,'Creating pickup stop');
2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2866: END IF;
2867:
2868: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(

Line 2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);

2861: l_stop_in_rec.phase := NULL;
2862: l_stop_in_rec.action_code := 'CREATE';
2863: IF l_debug_on THEN
2864: WSH_DEBUG_SV.logmsg(l_module_name,'Creating pickup stop');
2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2866: END IF;
2867:
2868: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
2869: p_api_version_number => l_api_version_number,

Line 2883: WSH_DEBUG_SV.logmsg(l_module_name, 'Pickup Stop created succesfully');

2879:
2880: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2881: THEN
2882: IF l_debug_on THEN
2883: WSH_DEBUG_SV.logmsg(l_module_name, 'Pickup Stop created succesfully');
2884: END IF;
2885: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2886: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2887: THEN

Line 2894: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2890: FOR m in 1..l_msg_count
2891: LOOP
2892: l_message := fnd_msg_pub.get(m,'F');
2893: l_message := replace(l_message,chr(0),' ');
2894: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2895: END LOOP;
2896: END IF;
2897: fnd_msg_pub.delete_msg();
2898: raise FND_API.G_EXC_ERROR;

Line 2903: WSH_DEBUG_SV.logmsg(l_module_name,'Pickup Stop created with warnings');

2899:
2900: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2901: THEN
2902: IF l_debug_on THEN
2903: WSH_DEBUG_SV.logmsg(l_module_name,'Pickup Stop created with warnings');
2904: FOR m in 1..l_msg_count
2905: LOOP
2906: l_message := fnd_msg_pub.get(m,'F');
2907: l_message := replace(l_message,chr(0),' ');

Line 2908: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2904: FOR m in 1..l_msg_count
2905: LOOP
2906: l_message := fnd_msg_pub.get(m,'F');
2907: l_message := replace(l_message,chr(0),' ');
2908: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2909: END LOOP;
2910: END IF;
2911: fnd_msg_pub.delete_msg();
2912: END IF;

Line 2921: WSH_DEBUG_SV.logmsg(l_module_name,'Creating dropoff stop');

2917: l_dropoff_stop_info.planned_arrival_date := x_delivery_tab(i).ultimate_dropoff_date;
2918: l_dropoff_stop_info.planned_departure_date := x_delivery_tab(i).ultimate_dropoff_date;
2919: l_dropoff_rec_attr_tab(1):=l_dropoff_stop_info;
2920: IF l_debug_on THEN
2921: WSH_DEBUG_SV.logmsg(l_module_name,'Creating dropoff stop');
2922: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2923: END IF;
2924:
2925:

Line 2922: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);

2918: l_dropoff_stop_info.planned_departure_date := x_delivery_tab(i).ultimate_dropoff_date;
2919: l_dropoff_rec_attr_tab(1):=l_dropoff_stop_info;
2920: IF l_debug_on THEN
2921: WSH_DEBUG_SV.logmsg(l_module_name,'Creating dropoff stop');
2922: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2923: END IF;
2924:
2925:
2926: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(

Line 2941: WSH_DEBUG_SV.logmsg(l_module_name, 'Dropoff Stop created succesfully');

2937:
2938: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2939: THEN
2940: IF l_debug_on THEN
2941: WSH_DEBUG_SV.logmsg(l_module_name, 'Dropoff Stop created succesfully');
2942: END IF;
2943: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2944: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2945: THEN

Line 2952: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2948: FOR m in 1..l_msg_count
2949: LOOP
2950: l_message := fnd_msg_pub.get(m,'F');
2951: l_message := replace(l_message,chr(0),' ');
2952: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2953: END LOOP;
2954: END IF;
2955: fnd_msg_pub.delete_msg();
2956: raise FND_API.G_EXC_ERROR;

Line 2961: WSH_DEBUG_SV.logmsg(l_module_name,'Dropoff Stop created with warnings');

2957:
2958: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2959: THEN
2960: IF l_debug_on THEN
2961: WSH_DEBUG_SV.logmsg(l_module_name,'Dropoff Stop created with warnings');
2962: FOR m in 1..l_msg_count
2963: LOOP
2964: l_message := fnd_msg_pub.get(m,'F');
2965: l_message := replace(l_message,chr(0),' ');

Line 2966: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

2962: FOR m in 1..l_msg_count
2963: LOOP
2964: l_message := fnd_msg_pub.get(m,'F');
2965: l_message := replace(l_message,chr(0),' ');
2966: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2967: END LOOP;
2968: END IF;
2969: fnd_msg_pub.delete_msg();
2970: END IF;

Line 3012: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning delivery to trip');

3008: l_rec_attr_tab(1).party_id := x_delivery_tab(i).party_id;
3009: l_rec_attr_tab(1).shipping_control := x_delivery_tab(i).shipping_control;
3010:
3011: IF l_debug_on THEN
3012: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning delivery to trip');
3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);
3014: END IF;
3015:
3016:

Line 3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);

3009: l_rec_attr_tab(1).shipping_control := x_delivery_tab(i).shipping_control;
3010:
3011: IF l_debug_on THEN
3012: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning delivery to trip');
3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);
3014: END IF;
3015:
3016:
3017: WSH_DELIVERIES_GRP.Delivery_Action(

Line 3032: WSH_DEBUG_SV.logmsg(l_module_name, 'Assigned delivery to trip succesfully');

3028:
3029: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
3030: THEN
3031: IF l_debug_on THEN
3032: WSH_DEBUG_SV.logmsg(l_module_name, 'Assigned delivery to trip succesfully');
3033: END IF;
3034: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
3035: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
3036: THEN

Line 3043: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

3039: FOR m in 1..l_msg_count
3040: LOOP
3041: l_message := fnd_msg_pub.get(m,'F');
3042: l_message := replace(l_message,chr(0),' ');
3043: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
3044: END LOOP;
3045: END IF;
3046: fnd_msg_pub.delete_msg();
3047: raise FND_API.G_EXC_ERROR;

Line 3052: WSH_DEBUG_SV.logmsg(l_module_name,'Assigned delivery to trip with warnings');

3048:
3049: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
3050: THEN
3051: IF l_debug_on THEN
3052: WSH_DEBUG_SV.logmsg(l_module_name,'Assigned delivery to trip with warnings');
3053: FOR m in 1..l_msg_count
3054: LOOP
3055: l_message := fnd_msg_pub.get(m,'F');
3056: l_message := replace(l_message,chr(0),' ');

Line 3057: WSH_DEBUG_SV.logmsg(l_module_name,l_message);

3053: FOR m in 1..l_msg_count
3054: LOOP
3055: l_message := fnd_msg_pub.get(m,'F');
3056: l_message := replace(l_message,chr(0),' ');
3057: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
3058: END LOOP;
3059: END IF;
3060: fnd_msg_pub.delete_msg();
3061: END IF;

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

3082: ROLLBACK TO CREATE_TRIP;
3083: WSH_UTIL_CORE.PrintMsg('Exception occurred while creating deconsol trip for delivery '||l_del_id);
3084: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3085: IF l_debug_on THEN
3086: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3087: END IF;
3088: i := x_delivery_tab.NEXT(i);
3089: IF l_trip_cr_flag
3090: THEN

Line 3097: WSH_DEBUG_SV.pop(l_module_name);

3093: END IF;
3094: END;
3095: END LOOP;
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.pop(l_module_name);
3098: END IF;
3099:
3100: EXCEPTION
3101: WHEN FND_API.G_EXC_ERROR

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

3101: WHEN FND_API.G_EXC_ERROR
3102: THEN
3103: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Deconsol_Trip');
3104: IF l_debug_on THEN
3105: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3106: END IF;
3107: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3108: WHEN OTHERS
3109: THEN

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

3110: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
3111: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Deconsol_Trip');
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3113: IF l_debug_on THEN
3114: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3116: END IF;
3117: END Create_Deconsol_Trips;
3118:

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

3111: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Deconsol_Trip');
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3113: IF l_debug_on THEN
3114: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3116: END IF;
3117: END Create_Deconsol_Trips;
3118:
3119: PROCEDURE Add_For_Consolidation(

Line 3141: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3137:
3138: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3139: IF l_debug_on IS NULL
3140: THEN
3141: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3142: END IF;
3143:
3144: IF l_debug_on THEN
3145: WSH_DEBUG_SV.push(l_module_name);

Line 3145: WSH_DEBUG_SV.push(l_module_name);

3141: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3142: END IF;
3143:
3144: IF l_debug_on THEN
3145: WSH_DEBUG_SV.push(l_module_name);
3146: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_delivery_rec.delivery_id);
3147: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
3148: END IF;
3149:

Line 3146: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_delivery_rec.delivery_id);

3142: END IF;
3143:
3144: IF l_debug_on THEN
3145: WSH_DEBUG_SV.push(l_module_name);
3146: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_delivery_rec.delivery_id);
3147: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
3148: END IF;
3149:
3150: l_consol_count := x_consol_tab.LAST;

Line 3147: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

3143:
3144: IF l_debug_on THEN
3145: WSH_DEBUG_SV.push(l_module_name);
3146: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_delivery_rec.delivery_id);
3147: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
3148: END IF;
3149:
3150: l_consol_count := x_consol_tab.LAST;
3151: IF l_consol_count IS NULL

Line 3169: WSH_DEBUG_SV.logmsg(l_module_name,'Adding to existing consolidation group');

3165: x_consol_tab(i).delivery_tab(l_del_count + 1) := p_delivery_rec;
3166: x_consol_tab(i).total_weight := x_consol_tab(i).total_weight + p_del_weight;
3167: x_consol_index := x_consol_tab(i).consol_index;
3168: IF l_debug_on THEN
3169: WSH_DEBUG_SV.logmsg(l_module_name,'Adding to existing consolidation group');
3170: END IF;
3171: EXIT;
3172: END IF;
3173:

Line 3189: WSH_DEBUG_SV.logmsg(l_module_name,'Creating new consolidation group');

3185: l_consol_rec.delivery_tab(1) := p_delivery_rec;
3186: x_consol_tab(l_consol_count+1) := l_consol_rec;
3187: x_consol_index := l_consol_rec.consol_index;
3188: IF l_debug_on THEN
3189: WSH_DEBUG_SV.logmsg(l_module_name,'Creating new consolidation group');
3190: END IF;
3191:
3192: END IF;
3193:

Line 3196: WSH_DEBUG_SV.pop(l_module_name);

3192: END IF;
3193:
3194: WSH_UTIL_CORE.PrintMsg(' Delivery: '||p_delivery_rec.delivery_id||', Consolidation Index: '||x_consol_index);
3195: IF l_debug_on THEN
3196: WSH_DEBUG_SV.pop(l_module_name);
3197: END IF;
3198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3199: EXCEPTION
3200: WHEN OTHERS

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

3199: EXCEPTION
3200: WHEN OTHERS
3201: THEN
3202: IF l_debug_on THEN
3203: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3204: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3205: END IF;
3206: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3207: END Add_For_Consolidation;

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

3200: WHEN OTHERS
3201: THEN
3202: IF l_debug_on THEN
3203: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3204: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3205: END IF;
3206: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3207: END Add_For_Consolidation;
3208: